Qlik Replicate: Failure in resolving table name for objid %

[avidary_qlik]

A Qlik Replicate task with MSSQL as a source and Oracle as a target fails during Full Load and CDC.

The error logged:

Failure in resolving table name for objid %

Resolution

Failure in resolving table name for objid is commonly linked to temporary tables. When applications create temporary tables, they are logged in the transaction log. Qlik Replicate attempts to resolve the object ID from the log, but may fail if the object is unknown or transient.

To investigate further and to identify if there is data loss:

• Run the following query to identify the table name:

  SELECT name, object_id FROM sys.objects WHERE type = 'U' AND object_id LIKE '%' -- Replace % with the actual objid

• Consult with your database administrator to determine whether the object is a temporary table or if any maintenance activities have been performed. 
  
  
•  If the table is a temporary table, you can disregard the error.
  
  
• If data loss occurs due to maintenance activities, please open a support case with Qlik Support.

Cause

This error is often associated with temporary tables. When an application creates temporary tables, they are written to the transaction log. 

Qlik Replicate then attempts to read an unknown object ID from this log and fails to resolve it to a table name.

Environment

• Qlik Replicate