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.