https://community.qlik.com/t5/Qlik-Replicate/Task-failed-during-CDC/m-p/2434056#M10280 <P>Hi&nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/255986">@Titus</a>&nbsp;,<BR /><BR />Thank you for reaching out to Qlik Community.<BR /><BR />Could you check&nbsp;the "<SPAN>Create target control tgables in schema" in the task setting? attrep_change table should be created under the control schema.&nbsp;<BR /><BR />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.<BR /><BR />Regards,<BR />Desmond<BR /><BR /></SPAN></P> <P>&nbsp;</P> Mon, 25 Mar 2024 02:41:59 GMT DesmondWOO 2024-03-25T02:41:59Z https://community.qlik.com/t5/Qlik-Replicate/Task-failed-during-CDC/m-p/2433967#M10270 <DIV class="w-full text-token-text-primary" data-testid="conversation-turn-7"> <DIV class="px-4 py-2 justify-center text-base md:gap-6 m-auto"> <DIV class="flex flex-1 text-base mx-auto gap-3 md:px-5 lg:px-1 xl:px-5 md:max-w-3xl lg:max-w-[40rem] xl:max-w-[48rem] group"> <DIV class="relative flex w-full flex-col agent-turn"> <DIV class="flex-col gap-1 md:gap-3"> <DIV class="flex flex-grow flex-col max-w-full"> <DIV class="min-h-[20px] text-message flex flex-col items-start gap-3 whitespace-pre-wrap break-words [.text-message+&amp;]:mt-5 overflow-x-auto" data-message-author-role="assistant" data-message-id="eb5c170d-062a-451e-b931-2528aaafe14c"> <DIV class="markdown prose w-full break-words dark:prose-invert light"> <P>Hi,</P> <P>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.<BR /><BR />00024368: 2024-03-21T09:43:53 [TARGET_APPLY&nbsp;&nbsp;&nbsp; ]E:&nbsp; RetCode: SQL_SUCCESS&nbsp; 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]&nbsp; (sqlserver_endpoint_imp.c:5528)<BR /><BR /><SPAN>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?</SPAN><BR /><BR />Thanks,<BR />Titus</P> </DIV> </DIV> </DIV> <DIV class="mt-1 flex justify-start gap-3 empty:hidden"> <DIV class="text-gray-400 flex self-end lg:self-center items-center justify-center lg:justify-start mt-0 -ml-1 h-7 gap-[2px] visible"><BUTTON class="flex items-center gap-1.5 rounded-md p-1 text-xs text-token-text-tertiary hover:text-token-text-primary md:invisible md:group-hover:visible md:group-[.final-completion]:visible"></BUTTON><BUTTON class="flex items-center gap-1.5 rounded-md p-1 text-xs text-token-text-tertiary hover:text-token-text-primary md:invisible md:group-hover:visible md:group-[.final-completion]:visible"></BUTTON> <DIV class="flex">&nbsp;</DIV> </DIV> </DIV> <DIV class="pr-2 lg:pr-0">&nbsp;</DIV> </DIV> </DIV> </DIV> </DIV> </DIV> <DIV class="w-full text-token-text-primary" data-testid="conversation-turn-8"> <DIV class="px-4 py-2 justify-center text-base md:gap-6 m-auto"> <DIV class="flex flex-1 text-base mx-auto gap-3 md:px-5 lg:px-1 xl:px-5 md:max-w-3xl lg:max-w-[40rem] xl:max-w-[48rem] group"> <DIV class="flex-shrink-0 flex flex-col relative items-end"> <DIV> <DIV class="pt-0.5"> <DIV class="gizmo-shadow-stroke flex h-6 w-6 items-center justify-center overflow-hidden rounded-full">&nbsp;</DIV> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> Sat, 23 Mar 2024 17:13:41 GMT https://community.qlik.com/t5/Qlik-Replicate/Task-failed-during-CDC/m-p/2433967#M10270 Titus 2024-03-23T17:13:41Z https://community.qlik.com/t5/Qlik-Replicate/Task-failed-during-CDC/m-p/2434056#M10280 <P>Hi&nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/255986">@Titus</a>&nbsp;,<BR /><BR />Thank you for reaching out to Qlik Community.<BR /><BR />Could you check&nbsp;the "<SPAN>Create target control tgables in schema" in the task setting? attrep_change table should be created under the control schema.&nbsp;<BR /><BR />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.<BR /><BR />Regards,<BR />Desmond<BR /><BR /></SPAN></P> <P>&nbsp;</P> Mon, 25 Mar 2024 02:41:59 GMT https://community.qlik.com/t5/Qlik-Replicate/Task-failed-during-CDC/m-p/2434056#M10280 DesmondWOO 2024-03-25T02:41:59Z