Qlik Replicate Full Load Target SAP HANA:General error;301 unique constraint violated

[Bill_Steinagle]

A Qlik Replicate Full Load Task fails with the error:

RetCode: SQL_ERROR SqlState: 23000 NativeError: 301 Message: [SAP AG][LIBODBCHDB DLL][HDBODBC] General error;301 unique constraint violated 

Environment:

• Qlik Replicate 
• SQL Server Source
• SAP HANA target

Resolution

Add the Internal Parameter named readSnapshotOnUnload. This resolves the issue of duplicated data during the Full Load / CDC Task.

1. Go to the  Endpoint connection
2. Switch to the Advanced tab
3. Click Internal Parameters
4. Add readSnapshotOnUnload and tick the value checkbox to enable it
   
   
   
   For more information about Internal Parameters, see Qlik Replicate: How to set Internal Parameters and what are they for? .

Internal Investigation ID(s) 

Jira QB-27017