topic error in Application Development and Automation Discussions

error

Former Member — Mon, 03 Sep 2007 06:18:17 GMT

supose that I am uploading data from a flat file with 10 records and suppose if I get an error while uploading 5th record,then what willl happen and what we have to do in case of 'SESSION' as well as 'CALL TRANSACTION'.

Re: error

Former Member — Mon, 03 Sep 2007 06:22:21 GMT

it will generate a seesion log there you will find at which record the error was found

if you put commitwork at the end it will stop at that record and the total records will not be updated

if don't put commit work then it will up date up to 4th record

Re: error

Former Member — Mon, 03 Sep 2007 06:23:37 GMT

session stop the process.

call do success record.

SESSION METHOD

Data is not updated in database table unless Session is processed.

No sy-subrc is returned.

Error log is created for error records.

Updation in database table is always synchronous

CALL TRANSACTION

Immediate updation in database table.

Sy-subrc is returned.

Errors need to be handled explicitly

Updation in database table can be synchronous Or Asynchronous

Call transaction :

the transaction will be called immediatly when u run the report and the recording will be done once u execute the program...

Session method:

Session method will create a session ... U can schedule the session at any time so that it runs at the specified time..

Let us suppose that u need to enter some 1000 materials using MM01.. when u run this during normal working hours, it consumes time and server may lose its pace..

to avoid this , u can create a session for this data upload and schedule the session when users are less...say friday night..

hope this will be useful

Re: error

Former Member — Mon, 03 Sep 2007 06:28:47 GMT

Hi,

When you use CALL TRANSACTION, the data for the previous four records is already updated in the database.. if you have used it in E or A mode then the system will stop at the error screen.. but if you have used N mode, then it will skip the record and go ahead to the next record..

In this case, you will need to track the error record from the message table.. and later display a report or download the error records..

For SESSION method.. no record data will be updated in the database.. a log will be generated.. you can see that, correct the error record and re execute the session..

Thanks and Best Regards,

Vikas Bittera.