SLT unique index issue

[former_member588129]

Hi experts,

We are replicating data from ORACLE DB into SAP HANA, Our system is SAP_Basis 750, SLT version is DMIS 2011_1_731 SP0014.

There is a table in ORACLE DB, which has no primay key, but its unique index has three columns with a nullabe column. after we finish replicating data, Table is created in SAP HDB, its keys are unique index from source db. when triggers works in source db, failure occur with message 'ORA-01400: can not insert NULL into logging table ..'.

What should we do? there are too many tables like this situation.

Has anyone experiece a similar issue and found a workaround?
Thanks in advance,

Liam

[Andrey_M · Accepted solution]

SLT don't support NULL values in SP14. All fields in the logging tables creates with NOT NULL constraint.

[former_member588129 · Accepted solution]

thanks for you answer, i got it.