Skip to Content
avatar image
Former Member

SLT Initial load not inserting records

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?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Dec 06, 2017 at 07:55 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 28, 2017 at 12:35 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded