topic ERROR Adding A Filter to a CDC Job Consumig a Salesforce API in Qlik Replicate

ERROR Adding A Filter to a CDC Job Consumig a Salesforce API

AlexanderEscobar — Tue, 21 Oct 2025 17:47:03 GMT

Hi Everyone

Currently I'm trying to add a simple filter to exclude some records from a Qlik Replicate Job Consuming data from the Salesforce API

This is the source end point

This is the filter added (Exclude Equal To = 012Rn0000013oxNIAQ😞

The filter Works, as it's shown in the log:

00007760: 2025-10-20T16:24:32 [SOURCE_UNLOAD ]I: Unload finished for table ''.'Account' (Id = 1). 143165 rows sent. (streamcomponent.c:3786)

00010128: 2025-10-20T16:24:32 [TARGET_LOAD ]I: Load finished for table ''.'Account' (Id = 1). 143165 rows received. 22 rows skipped. Volume transferred 1711480472. (streamcomponent.c:4070)

00011776: 2025-10-20T16:25:30 [TASK_MANAGER ]I: Loading finished for table ''.'Account' (Id = 1) by subtask 1. 143165 records transferred. (replicationtask.c:3068)

But the Job goes to error after completing the load and throw this error message:

Table ''.'Account' (subtask 0 thread 1) is suspended. Cannot compute expression, not all column values are in the data record.

I think the problem is with the CDC process.

I tried to apply all the recommendation that I found in forums to handle null values on the column, adding a ifnull() function in the expression, COALESCE, adding this on the Transform column, but the process after loading the table goes to error and the job stop loading any new changes, any help?

Re: ERROR Adding A Filter to a CDC Job Consumig a Salesforce API

narendersarva — Tue, 21 Oct 2025 19:07:31 GMT

Hi @AlexanderEscobar

What is your Replicate version?

It is tough to determine what caused this error without looking at the entire task logs.

Please refer below 2025.5 replicate user guide limitations.

https://help.qlik.com/en-US/replicate/May2025/Content/Replicate/Main/Salesforce/salesforce_limitations_source.htm

If you need further assistance, please open a support case to investigate further.

Hope this helps.

Thanks

Naren

Re: ERROR Adding A Filter to a CDC Job Consumig a Salesforce API

AlexanderEscobar — Wed, 22 Oct 2025 01:17:01 GMT

Hi Naren, Thanks for your answer

The Replica Version is 2023.11

I attached the Diagnostic Package Log, in case it helps.

Re: ERROR Adding A Filter to a CDC Job Consumig a Salesforce API

john_wang — Wed, 22 Oct 2025 01:16:45 GMT

Hello @AlexanderEscobar ,

I've deleted the attachments as they may contain sensitive information. Please avoid sharing the Diagnostics Package in the community, as it’s publicly accessible to all visitors.

Regarding the error, could you please confirm the following:

Is the "account" table CDC-ready?
I noticed that you set the Bulk Version to 44.0 and the CDC Version to 43.0, while the default values are 62 and 56. Could you try removing these three version-related internal parameters and see if that helps?

If the error persists, please set SourceCapture and SourceUnload to Verbose in the Endpoint Server logging settings, reproduce the issue, and then collect the Diagnostics Package again.

Hope this helps.

John.