BDC

[Former Member]

Hi

lets say about 100 records I got in a flat file n after updating 50 records some how the systam crashed. now what happens when i run again the same file for second time in session as well in C.Trans.Will this file b picked up? if so how the system flows....

[Former Member]

Hi,

There are two ways to tackle this issue.

Method..1

Thru se16 check the table(s) being updated, preferably the last table as per your code. If you have say 1600 records in the flat file check for the upload of the 1600 th record.. If not ok, check for the upload of the 800 th record(N-N/2), if OK go & check

N+(N/2) th record if not ok goto N-(N/2) th record where N is the curent record number in the flat file . In about 4 or five checks you will converge on the last uploaded record.

Now from the flat file, remove the lines till the upload is ok & then re-run BDC.

Even here a record may be uploaded partially which has to be manually edited thru se16.

Method..2

Have a zee table for uploads. Just after uploading a record into the sap table, fill this zeetable with few fields of each the records. In an abort situation this table will tell the story of the update status. Take care to empty this table occasionally.

Regards,

Bhaskar