Skip to Content
0

SLT Initial load not inserting records

Dec 05, 2017 at 11:44 PM

95

avatar image
Former Member

While doing initial loads with SLT, tables are created and defined but records aren't inserted. The error messages were 'Duplicate key errors' and a workaround was to change the Refresh option in Table Settings for each table from 'Drop' to 'No Action'. The tables then get created and loaded after the reloading but no record is inserted.Very strange! Can someone help?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Andrey Martynov
Dec 06, 2017 at 07:55 AM
0

If you choose the refresh behaviour and at the same time get the "Duplicate key error", it means that the table already exists in target schema and contains the data.

Share
10 |10000 characters needed characters left characters exceeded
Manish Gupta Dec 28, 2017 at 12:35 PM
0

Please clarify what scenario you are using SLT for. If you are using SLT for Central Finance scenario, then there is a specific reason why this error comes up.
If you are using to load data for non- Central finance scenario, then this error comes because the record you are trying to load already exists in the target.

Share
10 |10000 characters needed characters left characters exceeded