Replicate - Table suspension and Backup file inaccessible

guilherme-matte — Tue, 20 Dec 2022 22:31:37 GMT

Hello Team

Tried replicating 4 tables from an MSQLS Source, two of them went through ok, the other two did not.

One table gets suspended "dbo.sample_data" and returns an Error on replicate monitor Window

Second table "dbo.focus3_case" goes back to Queued status and the Task is interrupted

From the error windows, seems the backup file is inaccessible for the second case, but not entirely sure what is causing it.

Print attached with log, appreciate any ideas

Kind Regards

Re: Replicate - Table suspension and Backup file inaccessible

Michael_Litz — Tue, 20 Dec 2022 22:57:36 GMT

Hi,

You are correct in that the dbo.sample_data does not have a primary key and therefore it will not be able to be added into the publication/articles for the task. To fix this you will need to reference the using SQL server as a source in the user guide where there is a section on how to setup SQL server for tables with no PK.

Please check this link out:

https://help.qlik.com/en-US/replicate/May2022/Content/Replicate/Main/SQL%20Server/Replicate_Tables_that_do_not_have_a_Primary_Key.htm#Replicating%20tables%20that%20do%20not%20have%20a%20primary%20key

For the other table it looks like it is a missing/inaccessible TLOG backup file. we usually like to see a TLOG retention policy of 3 days. keep the TLOG and the TLOG backups online and in native format for 3 days so that the task can access then if needed.

Let me know if this helps out.

Thanks,
Michael

topic Replicate - Table suspension and Backup file inaccessible in Qlik Replicate

Replicate - Table suspension and Backup file inaccessible

Re: Replicate - Table suspension and Backup file inaccessible