uploading data through BDC

[Former Member]

Hi this is Saroj,

my question is that if there are 100 records to be uploaded by any method i.e. call transaction

or session metod,50 records are uploaded succesfully.there occured an error and rest of 50 records could not be uploaded.How to upload rest of the 50 records.Please answer the question.

[Former Member]

if you run the session method , you have yo find the log in SM35 and find the error records and correct the record and run again the program. in the same way call transaction method also display the error log and correct the records and upload agagin....

[Former Member]

Hi,

Use Session Method.

When your run bdc session from SM35 with hundred records.

If 50 records are updated and rest does not.

The Session will be marked as error.

GOTO>Logs>You can know where exactly the error has occured.

You can re-run the session in Foreground mode.and only those records will be uploaded which ahs got error.

Session Method has advantage in handling error over Call Transaction.

Regards,

Gurpreet

[Former Member]

Hi,

from your question your mention your uploading 100 records 50 records are getting error

for call transaction method :

take the error records in flat file and upload same as you done previous.

in session method:

run the same session in SM35 in forground mode ,it automatically stops in error records and change the record ,do manually .

Regards,

Madhu

[Former Member]

Hi,

As 50 records out of 100 are already uploaded and from the log you can easily come to know from which records it has error.

therefore in case of call transaction...correct the wrong records, delete the alreday enetred records from the flat file save the file and again execute the BDC.

In case of session excute the session in foreground...it will enetr the records manually...either you can correct the errored record at runtime and enter onto DB or simply as done above run session om corrected file.

Pooja