Trigger and Write to records smart service

Question

Hello Everyone, 
 
 I am trying to insert a record which would be using the Write to Records or Write to Data Store Entity smart service to a table that has a trigger at the backend DB. 
 The trigger is for checking for the existence of a particular value in another table. 
 
 If the ID being inserted exists in the another table, the insertion will proceed without any issues. 
 If the ID does not exist in the another table, the trigger will prevent the insertion and typically raise an error. 
 
 So in the second scenario if the ID is not found, will the write to records execute normally or would it give an error because of the trigger?

Abhishek Karumuru · Accepted Answer

hi abhishekc2773 the Write to Records or Write to Data Store Entity smart service will give an error if the trigger prevents the insertion

Shanmathi Ponnusamy · Answer

Hi abhishekc2773 , 
 Yes the node will error out. It will throw the following error.

Soma · Answer

Yes the node will error out because the SQL operation has not completed and returned an error. This will be passed back to process by the smart service

Trigger and Write to records smart service

Top Replies