Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
nareshkumar
Contributor III
Contributor III

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

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.  

Labels (1)
2 Replies
DesmondWOO
Support
Support

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
 

 

Help users find answers! Do not forget to mark a solution that worked for you! If already marked, give it a thumbs up!
sureshkumar
Support
Support

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