Task failed during CDC

[Titus]

Hi,

We are using SAP HANA as the source and Microsoft Azure SQL Database as the target. When we started the task, the full load was completed successfully. However, upon starting to apply CDC records to the target, the task failed with the error below.

00024368: 2024-03-21T09:43:53 [TARGET_APPLY    ]E:  RetCode: SQL_SUCCESS  SqlState: 42000 NativeError: 229 Message: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]The SELECT permission was denied on the object 'attrep_changesA50568549', database 'master', schema 'dbo'. [1022502]  (sqlserver_endpoint_imp.c:5528)

We did not mention the master database in the target endpoint; instead, we used another created database and granted db_owner permission. Why is the attrep table stored in the master database, and why are we encountering the above error?

Thanks,
Titus

[DesmondWOO]

Hi @Titus ,

Thank you for reaching out to Qlik Community.

Could you check the "Create target control tgables in schema" in the task setting? attrep_change table should be created under the control schema. 

Please also enable verbose logging on TARGET_APPLY. The task log will provide additional information. If you can't identify the root cause, please consider submitting a support ticket with the diagnostic package and verbose task log.

Regards,
Desmond