Theattrep_apply_exceptionstable in Qlik Replicate is used for troubleshooting specific issues that occur during the data replication process. Based on the documentation and community discussions, the two situations where this table can be particularly useful are:
Apply conflicts (B): This table records errors related to conflicts that occur when applying changes to the target system.For instance, if there is a primary key violation or a constraint failure, the details of the conflict are logged in this table1.
Data errors (E): The table also captures errors related to the data itself, such as missing data or data type mismatches.If a record cannot be applied due to data-related issues, the error message and the statement that caused the error are stored in theattrep_apply_exceptionstable2.
Theattrep_apply_exceptionstable is not typically used forabnormal termination (A),table errors , orenvironment errors (D)as these issues are generally logged elsewhere within the system or require different troubleshooting approaches. For example, abnormalterminations might be logged in system event logs, while environment errors could be related to infrastructure issues outside the scope of Qlik Replicate's control tables.