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

[AlexanderEscobar]

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?

[narendersarva]

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_limitatio...

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

Hope this helps.

Thanks

Naren

[AlexanderEscobar]

Hi Naren, Thanks for your answer

The Replica Version is 2023.11

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

[john_wang]

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:

1. Is the "account" table CDC-ready?

2. 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.