Error records in BDC session

[Former Member]

Hi Gurus,

I have a situation where I ran BDC session with around 100,000 records and in it I gor around 20,000 error records. How to find out what are the error records and how to process them. I know that we can do it manually but when the volume of records are very high I think it is not suggestable.

Can anyone suggest a good solution for this.

[Former Member]

Hi Gurus,

I have a situation where I ran BDC session with around 100,000 records and in it I gor around 20,000 error records. How to find out what are the error records and how to process them. I know that we can do it manually but when the volume of records are very high I think it is not suggestable.

Can anyone suggest a good solution for this.

[abdul_hakim]

Hi,

If you are using Session Method to transfer the data, then the error records will still be kept in the session once it has been processed. Incase if you are using the Call transaction method then you need to program a session for the failed records and insert same into the batch input session and process it later.

Cheers,

Hakim

[shadow]

Hi Kumar,

if u r using BDC session method in that case error records r store in Q file(i.e session).

come to BDC call transaction method ,one predefine program RSBDCSUB by using dis u can identify the error records.....

Regard's

SHAIK.

[Former Member]

Hi Shaik,

Ya I know that we can see the errors in Log and we process the sessions through RSBDCSUB but If you have thousands of error records, It is not suggestable to see each error record and correct it.

My question is, can we download all the error records into a file or else is there any way to identify the error records apart from going to Log correct each record.

Note: I am using BDC session not call transaction.

[shadow]

Hi kumar,

If you want to download the errors into file then go with call transaction method.

Capture the errors using BDCMSGCOLL structure.

Using FM GUI_DOWNLOAD and FM FORMAT_MESSAGE... you can download the

error records into a file .

see the error records.

in SM35 select your session---> click on process,

after processing the session click on log---> there you can find the error records.

Regards

SHAIK.

Edited by: SHAIK JAILABDIN on Dec 1, 2008 9:02 AM

[Former Member]

Hi kumar,

Instead of BDC session go for Call transaction and handle all the error records in the internal table by checking the BDCMSGCOLL(Message table), Simultaneou;y you can create the BDC session for error records.

Once data is in internal table you can download to file.

[Former Member]

after running the your session method, select the session name and click the log.

after that you can press the print button it will dispaly your log is ALV format here you can select TYPE of error the sort ascending order, the error record are come upside then you go for SYSTEM in the menu

LIST-> SAVE---> LOCAL FILE down load you log file.

[Former Member]

Hi,

If you are using Call Transation, Create an internal table which is having same structure as BDCMSGCOLL structure. For these error records process session .

Regards,

Sudhakar Reddy