error handling in DATA MIGRATION

[Former Member]

hi

i am a beginner in sap abap. i am learning data migration techniques . so i wanted to know that what are the possible error in bdc and lsmw apart from error of data in flat file.And how handle those errors. if anyone can share his/her experience based on real time projects then it will be very helpful.

thanks'

akash

[former_member189849]

Hi

Mostly you get data inconsistency issue like 1.length of your filed is and flat file field length not match.

2.Extra spaces in flat file.

3.Field length conversion.(we have to use conversion exit).

Regards,

Mahesh

[Former Member]

HII

thanks for the reply.

i want to ask few more doubts..like if i m uploading large no of records say 10000. and if 4000 records could not be updated due to some errors in flat file. so how do handle these un-updated records . as we can't manually check all the failed records and find the reasons. as different records may have different errors..

pls let me know if i haven't clearly explained my doubt ..

thanks

akash

[Former Member]

Hi

That depends on how you load the data in the system

It can think there are two ways to upload the data:

- Asynchronous: the data are picked up (from file) and loaded in different sessions (for example: a program read data from file and then prepare a BDC session)

- Synchronous: the data are picked up and loaded in the same session (for example a program read data from file and load them by BAPI)

In the first solution you can't know if a record is ok or not ok you need to elaborate it by BDC session: so here yuo need to decide what to do,

The BDC session keeps the wrong transaction so you can elaborate it manually (anyway it's better to be sure the file is correct before creating a BDC session)

In the second  case you can use many soltuon because you can know if a record is ok or not after running BAPI, so (for example) you can generate a new file with the wrong record only, in order to try to elaborate it again.

Max

[former_member575766]

Hi..

U would collect the records which are not updated using the function module ' FORMAT_MESSAGE'. Then u need to correct the records in the file which u upload

[Former Member]

thanks for the replies.

i want to know some more things regarding errors..

the question is that what can be the reasons apart from the error in flat file or data mismatch error that can occur during data migration..please reply

thanks

akash

[Former Member]

Hi

Usually before uploading the data from flat file, these data are checked in order to prevent error while uploading.

A program for uploading  data can be thought with 3 main parts:

- the first one: the reading of the file

- the second: the check of the data

- the third one: uploading the data

The control is very important but sometimes it's not possible to check all cases, so for the program control the file is good but the transaction fails: it tries to reduce the possibile errors.

And you need to consider a system problem can occur

Max

[Former Member]

can some error be caused if the database table is enqued???

[Former Member]

What do you mean?

Of course it needs to change the master data of a certain object (for example material) and this object is locked, as it 's going to be changed by another transaction:

this is a typical situation it can't control

but this is a logical lock, no database lock

Max

[Former Member]

can tell me some more typical situations that can lead to error..

[Former Member]

Custom control developed in the user-exit (perhaps developed after you've developed your interface)

The change of the setting of the system and so

Max

[Former Member]

can u please elaborate as i am not able to understand properly.

thanks

akash

[Former Member]

Hi

SAP allows to develop user-exit/enhancement/validation in the program to create business objects (like sales documents, accouting documents, vendor or customer master data....)

It's not easy to consider all these custom control while developing an interface to load data in SAP, so the loading often can fail due a custom control.

Max

[Former Member]

hii

thanks for replies..

i want to ask now about data migration techniques..

1) what all are the techniques apart from bdc n lsmw?

2) among all which one can be chosen (most efficient) ?

3) factors on which the technique is choosen?

thanks

akash