topic Re: Data Upload in Application Development and Automation Discussions

Data Upload

Former Member — Sat, 28 Oct 2006 12:46:13 GMT

At the time of uploading data some records got problem. Then what can we do? can we start from the beginning or do with the errored records. Plz explain step by step for both the methods(Call Transaction as well as Session Method.)

Thanks & Regards

venkat

Re: Data Upload

Former Member — Sat, 28 Oct 2006 19:23:14 GMT

If you are using the session method, you can process transactions in error using SM35.

I wouldn't recommend CALL TRANSACTION if you expect to have a lot of errors to process.

Rob

Re: Data Upload

Former Member — Sun, 29 Oct 2006 04:19:54 GMT

Thanks for ur reply

But when Iam uploading 10000 records using session method, of that 10 records contains errors. can I reprocess all the records or process only the 10 error records?

Re: Data Upload

Former Member — Sun, 29 Oct 2006 06:43:13 GMT

HI Venkat

Using the session method we can process the error records again via transaction SM35.

As per your example, a session is created for 10000 transactions and 10 were error. So next time when we go and re-process the session these 10 records only wil be processed. We can check the same, if we go the ANLAYSIS of the session, we can find the statastics like Records Processed, To Process...

Kind Regards

Eswar

Re: Data Upload

Former Member — Sun, 29 Oct 2006 06:57:36 GMT

Hi Eswar

Thanks for ur reply.

In reprocessing can I delete the processed records or no need to delete?

Thanks & Regards

venkat

Re: Data Upload

Former Member — Sun, 29 Oct 2006 07:04:43 GMT

One the session is created, we wont be using the file again. We can use the session created without interacting the source file. Hence no need to delete any records from the file.

Whereas transactions in session, we will reprocess the records that are yet to be processed and hence we will not modify the session.

Every execution of a session will create a log.

Kind Regards

Eswar

Re: Data Upload

Former Member — Mon, 30 Oct 2006 09:15:13 GMT

Hi Venkat,

If you are using session method then inside SM35 transaction you can very wel check : number of records processed, records in error, number of records needs to process.

Here you can also check log option to see reason why these records gone into error.So once you will get list of error records just check is there any problem in upload file or is there any other reason. Fixed the error and again you can create upload file for error records and processed through BDC or LSMW.
\

If you are using Call transaction method then write a ABAP code in such manner that it will give you number of processed records then number of error records at the end of your BDC processed. So here again you can find out reason for error records and create and upload file for error records only and then again you can processed it.

Thanks & regards,

Shilpa K.