topic Re: BDC Errors in Application Development and Automation Discussions

BDC Errors

Former Member — Fri, 18 Nov 2005 22:53:39 GMT

I ran BDC session with some work orders. Many records failed. To look at which work order numbers failed I have to go thru each record, click a few buttons to get the work order number of one failed record. Is there any way to get numbers of all failed records easily - could be a report that can display all the original records that failed to load

Re: BDC Errors

Former Member — Sat, 19 Nov 2005 00:21:58 GMT

Jenny,

You can use transaction SM35 to view all your sessions. Click on the session then click on the Analysis button. Then click the incorrect radio button on the top. You can see only failed records. To view filaed transaction you can click on the Transaction Tab. If you want to check the data then click on Screens tab & then field List.

Hope this helps.

Cheers,

Bipin

Award points if you find this useful.

Re: BDC Errors

RichHeilman — Sat, 19 Nov 2005 02:32:19 GMT

Hi Jenny, i don't know of a handy report which could give you this information, you can do as Bipin suggested, but I believe that is what you don't want to have to do. I agree, it is a little cumbersome.

Welcome to SDN!

Regards,

Rich Heilman

Re: BDC Errors

Former Member — Sat, 19 Nov 2005 04:02:55 GMT

You will have to write a custom report to do that and it is not easy.

Re: BDC Errors

Former Member — Sat, 19 Nov 2005 09:33:36 GMT

Hi Jenny,

One of the inherent advantages of using BDC session method over Call transaction is that, you don't need to worry about report the errors in the program.

But if you really want a report sort of thing for Erroneous records, YOu can always use a Call transaction method, where in you can check for sy-subrc and prepare a log report in the program, which does the BDC.

See this.

Call transaction <TCODE> using t_BDCDATA

mode 'N'

UPdate 'S'

messages into t_Messages.

if sy-subrc <>0.

perform write_log.

endif.

form write_log.

call function 'FORMAT_MESSAGES',

*pass the message numbers IDs etc.

and get the message as the importing parameter.

Write:/ message.

endform

Regards,

Ravi

Re: BDC Errors

Former Member — Tue, 22 Nov 2005 19:18:25 GMT

Bipin, Rich, Srinivas, Ravi,

Thank you all for your help. I know how to look for the error as mentioned by Bipin. But it is not what I am looking. I think I need ot write a report on my own.

Jenny

Re: BDC Errors

Former Member — Tue, 22 Nov 2005 22:27:14 GMT

Hi Jenny,

If writing a program is what you are thinking about, then please go through the solution I gave another person on this forum. May be you can use the same logic.

Srinivas