topic Re: Failed to write to changes table in Qlik Replicate

Failed to write to changes table

MoeE — Tue, 22 Oct 2024 03:07:28 GMT

Hi,

Has anyone seen these errors before? The correct permissions to truncate are indeed enabled.

Failed (retcode -1) to execute statement: TRUNCATE TABLE [ctl].[attrep_changesE3A0D63108A3F061]

RetCode: SQL_ERROR SqlState: 42S02 NativeError: 4701 Message: [Microsoft][ODBC Driver 18 for SQL Server][SQL Server]Cannot find the object "attrep_changesE3A0D63108A3F061" because it does not exist or you do not have permissions. Line: 1 Column: -1

Failed to truncate table ctl.attrep_changesE3A0D63108A3F061

Failed to truncate net changes table

The table exists on the target. The target is Microsoft SQL Server.

Regards,

Mohammed

Re: Failed to write to changes table

sureshkumar — Tue, 22 Oct 2024 03:12:17 GMT

Hello @MoeE

Could you please review the SQL server logs for that specific timeframe for any locking information?

If you've enabled ""Apply batched changes to multiple tables concurrently" under the batch tuning option, kindly uncheck the option and Resume the task.

Regards,

Suresh

Re: Failed to write to changes table

SachinB — Tue, 22 Oct 2024 05:04:22 GMT

Hello @MoeE ,

In general, the attrep_changes table is used as a temporary table to hold operations that are being done against the target tables. This table is only used in CDC.

Please try to stop and resume the task and see if you get the same error, also check is the permission is revoked for this schema ctl

Regards,

Sachin B

Re: Failed to write to changes table

Kent_Feng — Tue, 22 Oct 2024 05:09:56 GMT

Hi @MoeE

According to my experience, the "Failed to truncate net changes table" error was usually caused by a networking or connection hiccup. As Sachin suggested, stop and resume the task may solve the issue or you can try Suresh' setting tuning which was found to be a solution for one of our support cases.

Regards

Kent

Re: Failed to write to changes table

MoeE — Tue, 22 Oct 2024 05:24:54 GMT

Hi @SachinB , @Kent_Feng ,

Thanks for the answers, much appreciated. Will update to let you know how it goes.

Regards,

Mohammed

Re: Failed to write to changes table

MoeE — Thu, 24 Oct 2024 05:41:41 GMT

Hi Suresh,

The "Apply batched changes to multiple tables concurrently" setting is already disabled. I looked through the SQL Server logs at the time of the error and there appears to be a login from the Qlik Replicate user. I'm thinking there was possible a brief disconnection from the target then Replicate reconnected?

Regards,

Mohammed

Re: Failed to write to changes table

sureshkumar — Fri, 25 Oct 2024 01:46:47 GMT

Hello @MoeE

Could be target disconnection.

Regards,

Suresh