topic Re: Multiple CDC tasks failing with "An unexpected error occurred while trying to retrieve access token” in Qlik Replicate

Multiple CDC tasks failing with "An unexpected error occurred while trying to retrieve access token”

MoeE — Wed, 08 Oct 2025 06:11:31 GMT

Hi,

A client's CDC tasks are frequently failing intermittently with the following error after a windows patch last month.

RetCode: SQL_ERROR SqlState: 42000 NativeError: 105117 Message: [Microsoft][ODBC Driver 18 for SQL Server][SQL Server]An error occurred while authenticating against Managed Service Identity: 'An unexpected error occurred while trying to retrieve access token.’

The target is Azure Analytics. I've researched the error online and haven't found much indication to the issue. Has anyone seen this before? The task stops, then can be resumed again. I am also seeing these two errors every time this occurs

[TARGET_APPLY ]E: Failed to load data of file CDC000013BF.csv to database [TARGET_APPLY ]E: Failed to copy data to net changes table [1022505] (bulk_apply.c:6413)

Help with this is appreciated. Thank you

Kind regards,

Mohammed

Re: Multiple CDC tasks failing with "An unexpected error occurred while trying to retrieve access token”

john_wang — Wed, 08 Oct 2025 14:22:22 GMT

Hello Mohammed, @MoeE

Thanks for the post here.

RetCode: SQL_ERROR  SqlState: 42000 NativeError: 105117 Message: [Microsoft][ODBC Driver 18 for SQL Server][SQL Server]An error occurred while authenticating against Managed Service Identity: 'An unexpected error occurred while trying to retrieve access token.’

It appears that the issue is more likely related to the latest Windows patch or the SQL Server ODBC Driver.

The error indicates that the Managed Identity token failed to be retrieved from the Azure Instance Metadata Service (IMDS).
Possible causes include:

A temporary Azure MSI (Managed Service Identity) outage
Network connectivity issues between the host and IMDS

In summary, these errors reflect a Synapse client/server communication problem.
This issue should be reviewed by the user’s DBA or escalated to Microsoft if necessary.

If you would like to investigate further, we suggest the following steps:

Check the SQL Server ODBC Driver version
Review driver timeout period — by default, the ODBC driver waits only a few seconds to retrieve the MSI token. If IMDS responds slowly, authentication may fail.
Set TARGET_APPLY to Verbose, reproduce the issue, and review the detailed task log files.
Enable ODBC tracing to capture additional diagnostic details.

Hope this helps.

John.

Re: Multiple CDC tasks failing with "An unexpected error occurred while trying to retrieve access token”

ChristopheL — Mon, 13 Oct 2025 12:10:43 GMT

Hi John,

We have exactly the same problem. You say to review the timeout period, does this mean to add for instance ConnectRetryCount=20;ConnectionTimeout=30 in the ODBC Attributes on the endpoint connection for Azure for the additional connection properties so it will retry 20 times and wait for a timeout of 30 seconds?

Thanks in advance,
Christophe

Re: Multiple CDC tasks failing with "An unexpected error occurred while trying to retrieve access token”

john_wang — Wed, 15 Oct 2025 05:06:06 GMT

Hello @ChristopheL ,

Thanks for the update. I could only find the parameter SQL_ATTR_LOGIN_TIMEOUT (SQL_LOGIN_TIMEOUT) on the Microsoft webpage. Please check if this is helpful.

Regards,

John.

Re: Multiple CDC tasks failing with "An unexpected error occurred while trying to retrieve access token”

MoeE — Wed, 15 Oct 2025 22:01:23 GMT

Hi Christophe,

I'm curious, did the issue begin appearing after Windows patching? Is your QR instance on an Azure VM, and is your target SQL Server or Synapse?

Regards,

Mohammed

Re: Multiple CDC tasks failing with "An unexpected error occurred while trying to retrieve access token”

ChristopheL — Thu, 16 Oct 2025 13:00:26 GMT

Hi MoeE,

I think it started when we updated the ODBC driver for SQL Server on the unix server that hosts Qlik Replicate from a version 17 to a version 18, but since it's done by an infrastructure team I'm not sure about it.

I can confirm however that the sollution I posted above seems to be working. Since I implemented it everywhere yesterday I finally had a night without any issues in the Qlik Tasks.

Kind regards,

Christophe

Re: Multiple CDC tasks failing with "An unexpected error occurred while trying to retrieve access token”

ChristopheL — Thu, 16 Oct 2025 13:06:09 GMT

Hi Mohammed;

i forgot to answer, but our target is Azure Synapse indeed and QR is on a virtual machine, a linux server.

Kind regards,

Christophe

Re: Multiple CDC tasks failing with "An unexpected error occurred while trying to retrieve access token”

john_wang — Thu, 16 Oct 2025 13:17:56 GMT

Thank you so much for the feedback, @ChristopheL ! Your input is truly valuable for everyone.

Re: Multiple CDC tasks failing with "An unexpected error occurred while trying to retrieve access token”

MoeE — Thu, 16 Oct 2025 23:45:02 GMT

Hi @ChristopheL,

Thanks for the response. Is this the solution that you tried?

Or did you implement @john_wang's solution to add the "SQL_ATTR_LOGIN_TIMEOUT (SQL_LOGIN_TIMEOUT)" parameter? Or only what is mentioned in the screenshot above?

Thanks,

Mohammed

Re: Multiple CDC tasks failing with "An unexpected error occurred while trying to retrieve access token”

ChristopheL — Fri, 17 Oct 2025 06:52:39 GMT

Hi Mohammed,

yes the screenshot is the solution I applied. ConnectioTimeout and SQL_ATTR_LOGIN_TIMEOUT are said to be the same in fact.

Kind regards,

Christophe

Re: Multiple CDC tasks failing with "An unexpected error occurred while trying to retrieve access token”

john_wang — Sat, 18 Oct 2025 02:57:44 GMT

I really appreciate your valuable information, Thank you @ChristopheL

Re: Multiple CDC tasks failing with "An unexpected error occurred while trying to retrieve access token”

MoeE — Tue, 21 Oct 2025 23:52:13 GMT

Hi @john_wang, @ChristopheL,

Unfortunately we tried these internal parameters on the target endpoint yet we're still seeing the issue. We applied them the same as shown in the screenshot.

Edit: I noticed that there was no semicolon at the end of the internal parameters and I wonder if that would have an effect "ConnectRetryCount=20;ConnectionTimeout=30"

Regards,

Mohammed

Re: Multiple CDC tasks failing with "An unexpected error occurred while trying to retrieve access token”

john_wang — Wed, 22 Oct 2025 08:32:00 GMT

Hello Mohammed, @MoeE

Thanks for the update.

Yes, we recommend adding a semicolon (";") at the end of the connection string. The complete string should look like:
ConnectRetryCount=20;ConnectionTimeout=30;

However, based on the ODBC Trace logs you uploaded in the support ticket, there are 32 errors such as:

DIAG [08S01] [Microsoft][ODBC Driver 18 for SQL Server]Communication link failure (10054)

This appears to be a network-related issue. Please check with your DBA or IT team for further assistance.

Regards,

John.