Skip to Content
avatar image
Former Member

Structural changes in the source table

Hi,

I've created a Z table called ZSLT with 3 column: MANDT, ID and NAME.

I've inserted one record and after, started the replication. The record was replicated correctly into HANA.

After, I've added a new column called SURNAME in the source table. I waited 5 minutes and then I inserted a new records. I was expecting that this new column would be reflected in the HANA system, but instead, an error is showed in the iuuc_sync_mon transaction:

Z_ZSLT_017: Run 0000000001 aborted due to data inconsistency in 20150410 at 190018

Execution of program /1CADMC/OLC_001000000001654 failed, return code 3

As far as I understood, table changes should be reflected automatically, right? Any idea wha might be wrong here?

See below the systems version:

DMIS 2011_1_731 0007 SAPK-11607INDMIS - Installed on both systems (source and SLT dedicated machine).

HANA SP8 1.00.83.00.395718

Thanks and regards,

Roberto Falk

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Apr 11, 2015 at 05:16 PM

    Hi Robert,

    If the source table is in ECC ...Just adjust the table in SE14.

    Put the table name and click on activate and adjust the database.

    Once done try to do the replication.

    Hope it helps.

    Regards,

    Kannan

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 11, 2015 at 10:47 AM

    Hi Roberto,

    Can you please tell me the source system details .


    Did you change the key definition of the table ?

    Also please check the dictionary tables DD02L, DD02T and DD08L if they are in the status Replicate, or In Process.

    Now let me describe the scenario in detail,

    If your source System is on SAP NetWeaver Basis 6.40 or lower, and key definition is changed the trigger will fail. In this case you have to stop the replication for the affected table and start the replication.

    If the Source System is on SAP NetWeaver Basis 7.00 - 7.30: you have to implement SAP Note 1655725 and 1875769. By implementing these two notes on the ABAP source system, simple table structure changes (adding a non-key field) are possible with active SLT triggers.

    In case of complex table structure changes (change data type or length, add or delete key fields) the trigger and logging table have to be dropped and recreated. you have to implement SAP Note 1749824 for this case.

    Hope it can help you.

    Thanks,

    Subhash

    Add comment
    10|10000 characters needed characters exceeded