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

[nareshkumar]

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.  

[DesmondWOO]

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
 

 

[sureshkumar]

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