Hello,

Would like to check on how to put loggings on Functionality or Process flow,  that will show/display in the error logs. For troubleshooting or debugging.

Currently we are having some issue in the system, and I would like to put loggings.

The functionality is control procedure (Tasks )  and using merge script template.

To give a small background of the implementation, we have process flow to import data in the system, the import data is a json file from other system.

Sample error we encounter is below.  I would like to put a logging to pin point exactly which data is causing an error.

Table name: order_line
Cannot insert the value NULL into column 'order_id', table 'dbo.order_line'; column does not allow nulls. UPDATE fails.
2025-04-15 06:15:00

Table name: order_address
Cannot insert the value NULL into column 'order_id', table ’order_address'; column does not allow nulls. UPDATE fails.
2025-04-15 06:15:00

Table name: order_timeline
Cannot insert the value NULL into column 'order_line_id', table 'order_timeline'; column does not allow nulls. UPDATE fails.
2025-04-15 06:15:00

Please advice.