How to get Error Record detail like id value,

Question

When running workflow getting error, i know this errors throughing becuase of missing id in parent tables, i want to know is there any way to view the exception record values that causing insert failed?

Error: Output Data (5): DataWrap2OCI::SendBatch: ORA-02291: integrity constraint (test_fk) violated - parent key not found

Insert into "test"("ID","VIOLATION_TYPE","LINK_VIOLATION_ID","CLASSIFICATION_ID","AMOUNT","MAX_AMOUNT_CONSIDERING_REPEAT","MAX_CONSIDERING_UNITS","SynchTimestamp","LastOperation") Values (:A1,:A2,:A3,:A4,:A5,:A6,:A7,:A8,:A9)

jamshed23 · Answer

thanks for your reply, but i want to know can we see this id in alteryx

TimN · Answer

Hi,

Not sure if this helps but the error you are getting is explained here:

https://www.techonthenet.com/oracle/errors/ora02291.php

If you know what field the PK is on the parent table, you could query the parent table and then validate if the value(s) you are trying to insert in the foreign key field of the child table exist on the parent table.