Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

bdc query (urgent help needed)

Former Member
0 Likes
625

hi all,

i am new to BDC so plz help me.

1.what we have to do if a system crashes in the middle of a BDC batch session?plz give me the steps to be carried for this.

2.what to do with errors in BDC batch session?

thanks & regards

sanjeev

Message was edited by: sanjeev singh

hi all,

i am new to BDC so plz help me.

1.what we have to do if a system crashes in the middle of a BDC batch session?plz give me the steps to be carried for this.

2.what to do with errors in BDC batch session?

thanks & regards

sanjeev

Message was edited by: sanjeev singh

4 REPLIES 4
Read only

Former Member
0 Likes
599

Hi

1. Check the relevant table for the last entry and compare with your input file.

Read only

Former Member
0 Likes
599

2. In call transaction Method:

The BDCMSGCOLL does not have the messages text. It has only the message type, number and message parameters.

You have to read the message text. (recall that the database table T100 stores all the messages.)

There are more than one method of doing this.

Following is the psuedocode for one of the methods.

LOOP for the internal table IT1 which has data value from flat file.

call transcation using....

if SY-SUBRC <> 0.

Read the dictionary table T100 FOR ALL ENTRIES in BDCMSGCOLL.

(also use the condition T100-SPRAS = SY-LANGU (the log on language. This is because you need only the message texts in English if the user is logged in English language)

IF message type is E , then, transfer the contents of this particular error record to file x. (TRANSFER......)

( Ignore all other messages. Only consider type 'E' messages. Ignore other types of messages.)

(You can also store the message text from T100 and the error record in another internal table IT2)

.....

....

ENDLOOP.

Alternatively,

Instead of

" Read the dictionary table T100 FOR ALL ENTRIES in BDCMSGCOLL."

you can use the function module

WRITE_MESSAGES to read the messages.

Please refer to the function module for the list of parameters.

Also refer FORMAT_MESSAGES function module.

Best Regards,

Vibha Deshmukh

*Plz mark useful answers

Read only

0 Likes
599

hi vibha

thanks for the reply but what about the following question ineed its answer urgently

what we have to do if a system crashes in the middle of a BDC batch session?plz give me the steps to be carried for this

Read only

0 Likes
599

1)When the system crashes the session at that point of time is saved, so you can simply restart the session.

2)when u again restart the session records have a status:

-error

-new

-finished so it process only the new ones

3)There can be a problem with update (terminated)

-> than check trx SM13