topic Re: uploading data through BDC in Application Development and Automation Discussions

uploading data through BDC

Former Member — Mon, 16 Feb 2009 15:13:07 GMT

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.

Re: uploading data through BDC

Former Member — Mon, 16 Feb 2009 15:16:55 GMT

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....

Re: uploading data through BDC

Former Member — Mon, 16 Feb 2009 15:20:34 GMT

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

Re: uploading data through BDC

Former Member — Wed, 18 Feb 2009 11:31:23 GMT

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

Re: uploading data through BDC

Former Member — Wed, 18 Feb 2009 11:42:02 GMT

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