Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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