Skip to Content

SAP system copy installation stucked at Import ABAP phase

I tried to installed SAP using the system copy method. However, it was stuck at Import ABAP phase, import monitor Job 9. The process will stuck here forever will proceed further. If I check those SAP*** log, it will have the error shown in bold below:

(IMP) INFO: ExeFastLoad failed with <2: BCP Commit failed:[Microsoft][SQL Server Native Client 10.0][SQL Server]Violation of PRIMARY KEY constraint '/SAPDMC/LSORUL~0'.>

I have doubt, what is wrong, I already tried every possible method. However, the process still stuck at this phase. Can anyone provide any assistance or suggestion? Attached is one of the sample of error log.

SAPUSER.txt.zip (1.2 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Aug 16, 2012 at 08:41 AM

    Hi,

    From note 942540 we can see:

    {quote}
    ...
    These <TABART>.SQL files must be created manually on the source system
    by running a report SMIGR_CREATE_DDL. The resulting files must be copied
    to the directory <export directory>/DB/<DBSYS> of the target system.
    If this step was forgotten, on import duplicate key errors (violations
    of primary key constraint) could occur. If fastload is used you only see
    (IMP) INFO: ExeFastLoad failed with <2: BCP Commit failed>(IMP) ERROR:
    ExeFastload: rc = 2

    Solution
    The SMIGR_CREATE_DDL report must be executed as described in note
    771209.
    The resulting DFACT.SQL file must be copied to  the <export
    directory>/DB/MSS of the target system.
    The SAPDFACT-import must be rerun completely as follows:
    ...
    {quote}

    Did you run the SMIGR_CREATE_DDL (note 771209) in the source system?

    regards,

    Paul

    Add comment
    10|10000 characters needed characters exceeded

  • Aug 16, 2012 at 08:49 AM

    Hi,

    Sorry, I just saw the log you posted.

    Its failing on tables

    T5BPBS01 and T5BPBS02

    You can use the following statements to identify the duplicate entries
    on table T5BPBS01 which is affecting the index:

    -> Index T5BPBS02~0:
    SELECT <index key field 1>, <index key field 2>, count(*)
    FROM <SID>.<sid>.T5BPBS02
    GROUP BY <index key field1>, <index key field2>
    HAVING count(*) > 1

    -> Index T5BPBS01~1:
    SELECT <index key field1>, <index key field 2>, count(*)
    FROM <SID>.<sid>.T5BPBS01
    GROUP BY <index key field1>, <index key field2>
    HAVING count(*) > 1

    This will show any rows that are duplicates of the primary key.

    The steps to remove the duplicated keys can be found under:

    http://support.microsoft.com/kb/139444/en

    Check if these duplicate exist on source as well.

    (I can rewruite the sql to be clearer if you update with the key fields of the 2 mentioned indexes and the DB and instance sid)

    regards,

    Paul

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Ratnajit,

      I already tried the method mentioned. However, it still giving me the same error and the process is still stuck at job monitor, abap process 9. Any other way to solve this problem?