BDC Errors

[Former Member]

Hi ABAP Rocks,

Scenario 1: I am uploading 1000 records using session method(Syncr). I have an error in 950th record. What will happen and howmany records will upload?

Scenario 2: I am uploading 1000 records using Call Transaction method (Asyn). I have an error in 950th record. What will happen and howmany records will upload?

[GauthamV]

hi,

in first case records will not be uploaded after 950 th record .since it is an sync process.

whereas in 2nd case all records except 950 th record will be uploaded.

reward points if hlpful.

[Former Member]

If that is the case if u use session method and found some error in my 1st record . All records will not be uploaded?

I think this is wrong. Can anybody conform the answer pls?

[Former Member]

if you have done validation well then only 950th record will not be updated in session as well as call transaction...

[Former Member]

Hi,

I will tell u basic diff.

Syn : record will be sent after it receives confirmation about previous record.

Asyn:record will be sent regardless of previous record.

In session method, u can see all the records failed as well as successful in Tcode SM35, whereas in Call transaction method u have to handle errors manually like if 950 record is failed capture that record along with record no(Sy-tabix) and keep it seperate internal table. finally display all the error records.

Kindly check this and get back to me incase of any queries.

Dont forget to reward points if found useful.

Thanks and Regards,

Satyesh

[vinod_vemuru2]

Hi Buddula,

I think u already posted the same question in this thread.

Still have confusion?

Check this help.sap.com documentation.

The UPDATE Parameter

You use the UPDATE parameter to specify how updates produced by a transaction should be processed. You can select between these modes:

A Asynchronous updating. In this mode, the called transaction does not wait for any updates it produces to be completed. It simply passes the updates to the SAP update service. Asynchronous processing therefore usually results in faster execution of your data transfer program.

Asynchronous processing is NOT recommended for processing any larger amount of data. This is because the called transaction receives no completion message from the update module in asynchronous updating. The calling data transfer program, in turn, cannot determine whether a called transaction ended with a successful update of the database or not.

If you use asynchronous updating, then you will need to use the update management facility (Transaction SM12) to check whether updates have been terminated abnormally during session processing. Error analysis and recovery is less convenient than with synchronous updating.

S Synchronous updating. In this mode, the called transaction waits for any updates that it produces to be completed. Execution is slower than with asynchronous updating because called transactions wait for updating to be completed. However, the called transaction is able to return any update error message that occurs to your program. It is much easier for you to analyze and recover from errors.

L Local updating. If you update data locally, the update of the database will not be processed in a separate process, but in the process of the calling program. (See the ABAP keyword documentation on SET UPDATE TASK LOCAL for more information.)

http://help.sap.com/erp2005_ehp_03/helpdata/EN/fa/09715a543b11d1898e0000e8322d00/frameset.htm

Hope this time it will be clear.

Thanks,

Vinod.

[Former Member]

Yes. You have seen different type of answers for this thread. Which one is correct. I am confusing.

[vinod_vemuru2]

Hi Buddula,

I personally feel it is always better to rely on help.sap.com which is the documentation provided by SAP. This will be 99.99% correct and less prone for confusion. People have different views on the same topic. But the way SAP works might be different.

Another sugesstion . Why can't u create small BDC program with call transaction and session method for this scenario.

eg: Code a program for changing customer details.

Transaction XD02.

Create a text file having 3 records and 2 fields. Customer number and name1.

First record Take proper values from ur system and change name1.

Second record give customer number which doesn't exist in ur system(Inthis case BDC will fail)

Third record with proper data again.

Now Do CALL Transaction method with this file and see whether 3rd record is getting updated with new name from input file. As per my knowledge it should update 1st and 3rd record with new values. Both session and call transaction.

Check the same with session method.

It will hardly takes 2 to 3 hr to write the code for this.

Now u no need to rely on anybodys answer. Ofcource u will never forget these concepts once u do this.

Make sure that ur recording is working before starting coding:-)

Hope this idea will work.

Thanks,

Vinod.

[Former Member]

Hi,

In session method -- if there are any errors u can track them using tcode SM35.

Also session is used for more number of records so tht u ve the option of backgrnd processing.

In Call transaction -- the errors will be collected in the table BDCMSGCOLL.

this method is used when the number of records are less.

As far as I know thats the difference.

So, if 950th record has some errors in it this can be seen in tcode SM35 n corrected, the rest of the records will be updated.

In call transaction also BDCMSGCOLL wud ve collected the errored record so tht u can check n correct the errored record.

Hope this piece of info helped u.

Regards,

Ramya

[Former Member]

Hi buddula,

U told my answer is wrong. very good. Just execute for this scenario and see what really happens. I bet what i told works. Most imp thing is dont come to conclusions just by reading, see whether it really works or not by doing some testing on it.

[Former Member]

Hi,

I told u generally, first of all session process cannot be synchronous. So ur Q itself is wrong.

session method : THE DATA WILL PROCESS ASYNCHRONOUS MODE AND UPDATAES IN

SYNCHRONOUS MODE.

Call transaction : THE DATA WILL PROCESS SYNCHRONOUS MODE AND UPDATES ALSO

IN SYNCHRONOUS .