topic Re: Failure in associating MetadataManager TABLE_DEF with CDC_TABLE_ENTRY" in Qlik Replicate

Failure in associating MetadataManager TABLE_DEF with CDC_TABLE_ENTRY"

jm32 — Wed, 01 May 2024 13:01:35 GMT

One of on our tasks, we periodically get the following error messages:
Unable to get TABLE_DEF for capture table [dbo.TableNAme]
Failure in associating MetadataManager TABLE_DEF with CDC_TABLE_ENTRY"

We are using SQL Server RDS as an Endpoint - NOT MS-CDC.

Any help is appreciated!

Re: Failure in associating MetadataManager TABLE_DEF with CDC_TABLE_ENTRY"

john_wang — Wed, 01 May 2024 13:43:45 GMT

Hello @jm32 ,

Thanks for reaching out to Qlik Community!

Understanding the root cause of this error message is proving challenging at the moment. Could you please set SOURCE_CAPTURE to 'Verbose' and reproduce the issue? Then examine the task log file for any potential clues.

Additionally, could you verify whether the table was dropped or if any DDL operations were performed on it

Hope this helps.

John.

Re: Failure in associating MetadataManager TABLE_DEF with CDC_TABLE_ENTRY"

Kent_Feng — Thu, 02 May 2024 00:35:41 GMT

Hi @jm32

The error message indicates it is very likely that the metadata of the table is changed, I would suggest a reload of the affected table.

Regards

Kent

Re: Failure in associating MetadataManager TABLE_DEF with CDC_TABLE_ENTRY"

SushilKumar — Thu, 02 May 2024 06:47:39 GMT

Hello @jm32

Metadata got changes happen on the database when someone re-org the table or by so patch or maintenance which alter the physical Structure of the tables.

QR gather metadata when FL or task resume by the timestamp. it will not update the metadata until FL or task resume by the timestamp. and above error occurs when QR identify mismatch in the gathered metadata and received metadata in terms of Object_ID

As transaction logs hold Object_ID not by the table names. Replication require a Coordination between Applicaion developer and Qlik replicate admin. It is requested to inform each other if anything is there if it needs to do on the tables which are participating in any replication task.

Regards,

Sushil Kumar

Re: Failure in associating MetadataManager TABLE_DEF with CDC_TABLE_ENTRY"

jm32 — Thu, 02 May 2024 19:55:56 GMT

We dropped the table and are rerunning the task. However, the table is now stuck in QUEUED.

How do we get a table out of being stuck in QUEUED? We have dropped in and readded it and it is stuck.

Re: Failure in associating MetadataManager TABLE_DEF with CDC_TABLE_ENTRY"

jm32 — Thu, 02 May 2024 20:20:48 GMT

The table has loaded now. However, we do not get any changes. Is that something to do with the ObjectID in the transaction log? A column was dropped and re-added on the source a couple of days ago. We exclude that column in the Qlik task as well.

Re: Failure in associating MetadataManager TABLE_DEF with CDC_TABLE_ENTRY"

Kent_Feng — Fri, 03 May 2024 00:47:01 GMT

Hi @jm32

Did you select the affected table and reload it as illustrated?

Thanks

Kent

Re: Failure in associating MetadataManager TABLE_DEF with CDC_TABLE_ENTRY"

DesmondWOO — Fri, 03 May 2024 02:02:48 GMT

Hi @jm32 ,

Make sure your table has been added to article. To verify same objecti_id is used, you can enable TRACE level on SOURCE_CAPTURE. If problem persists, please submit a support ticket.

Regards,
Desmond

Re: Failure in associating MetadataManager TABLE_DEF with CDC_TABLE_ENTRY"

jm32 — Fri, 03 May 2024 17:09:53 GMT

This has been resolved. The task wasn't resumed after we removed the table - just saved. Once we did these steps:
stopped task ->removed table -> Resumed task -> Stop Task -> Added table (after the target data was cleaned up) -> Resume task

Thanks all for your help

Re: Failure in associating MetadataManager TABLE_DEF with CDC_TABLE_ENTRY"

john_wang — Sat, 04 May 2024 00:40:59 GMT

Thank you so much for your update! @jm32 Glad to hear it's solved.

Best Regards,

John.