topic Re: MSSQL-CDC source endpoint permission issue in Qlik Replicate

MSSQL-CDC source endpoint permission issue

dineshkumarl — Mon, 29 May 2023 12:17:14 GMT

Hi All,

Our DB is enabled for CDC and we have granted view DB state and SELECT permissions for the DB.

However, we are receiving select permission denied on cdc_jobs for our db. We have granted this manually as well, but still the error persists.

Kindly let me know how I can resolve this.

Note: I have tried granting dbowner role for testing. The error is fixed post that. But we cannot grant dbowner role to our user.

I have attached error message for reference.

Re: MSSQL-CDC source endpoint permission issue

sureshkumar — Mon, 29 May 2023 13:47:59 GMT

Hello Team,

Could you please capture the logs i.e reproduce the issue in VERBOSE [set only SOURECE_CAPTURE=VERBOSE]

and also add Internal parameter skipMscdcJobFitnessCheck to analyze further. Thanks

Regards,

Suresh

Re: MSSQL-CDC source endpoint permission issue

dineshkumarl — Tue, 30 May 2023 03:45:33 GMT

Hi, I was able to bypass the error received after adding the parameter suggested. However, now its trying to create a DDL history table in the database. We have already granted select permission to ddl_history table in our database but the error persists. Are we missing something here?

Re: MSSQL-CDC source endpoint permission issue

sureshkumar — Tue, 30 May 2023 05:52:08 GMT

Hello Team,

Please create a support ticket, will work on your issue.

Regards,
Suresh

Re: MSSQL-CDC source endpoint permission issue

dineshkumarl — Tue, 30 May 2023 06:27:38 GMT

I have fixed the issue by disabling DDL checkbox in Advanced settings after referring Limitations documents.

Thanks for the assistance.

Re: MSSQL-CDC source endpoint permission issue

sureshkumar — Tue, 30 May 2023 06:35:59 GMT

Hello,

That's good to know that the issue has been resolved after unchecking the Capture DDL events.

Regards,
Suresh