topic Re: Cannot compute expression, not all column values are in the data record in Qlik Replicate

Cannot compute expression, not all column values are in the data record

nareshkumar — Mon, 20 May 2024 16:06:29 GMT

Our Source and Target system are cloud rds Postgres and Cloud Aurora Postgres respectively.

We had Source and Targets having same no of columns and Same primary Keys ..

However couple of table are frequently failing with

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

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

(or)Table 'lcadm'.'spb_shipment_route_exp' (subtask 0 thread 1) is suspended. Failed to get delete statement for table lios_raw.spb_shipment_route_exp,
stream position 0000005F/4CECD9C8.53.0000005F/4CECF7188

We had referential integrity constraints (FK) @ source. Does the source tables having Foreign keys will triggers above compute errors and suspend tables ? Please advise.

Re: Cannot compute expression, not all column values are in the data record

DesmondWOO — Tue, 21 May 2024 02:12:06 GMT

Hi @nareshkumar ,

It appears that you have defined filter for the table 'lios_raw.spb_order' and supplier_code is not a Primary Key column.

I would suggest using the source_lookup function or adding supplier_code as one of the primary key column.

Regards,
Desmond

Re: Cannot compute expression, not all column values are in the data record

sureshkumar — Tue, 21 May 2024 04:59:13 GMT

Hello @nareshkumar
Its mentioned in the user guide

"When using filters that do not contain a Primary Key, DELETE operations will not be captured."

Limitations and considerations #Limitations and considerations | Qlik Replicate Help

Regards,

Suresh