Qlik Replicate task fails with Unique Constraint violations post upgrade to 2023.11 SP02

[SwathiPulagam]

After an upgrade to Qlik Replicate 2023.11.0.282(SP02), tasks fail with:

[TARGET_APPLY ]T: Failed to execute statement. Error is: RetCode: SQL_ERROR SqlState: 23000 NativeError: 2627 Message: [Microsoft][ODBC Driver 18 for SQL Server][SQL Server]Violation of PRIMARY KEY constraint 'ticket_history_PRIMARY'. Cannot insert duplicate key in object 'dbo.ticket_history'. The duplicate key value is (3155326).

Environment

• Qlik Replicate 
• MYSQL Source Endpoint
• SQL Server Target Endpoint

Resolution

This is caused by RECOB-7967.

Fix Version

Upgrade to Qlik Replicate 2023.11 SP03.