Skip to Content
author's profile photo Former Member
Former Member

error handling in DATA MIGRATION

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • Best Answer
    Posted on Jul 16, 2014 at 06:02 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member 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

  • author's profile photo Former Member
    Former Member
    Posted on Jul 17, 2014 at 05:32 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member 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

  • Posted on Jul 17, 2014 at 06:02 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 18, 2014 at 01:49 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.