Skip to main content

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.

Hi Jheng,

In the thinkstore (from the 2025.1 and up) there is a application log solution which logs tasks, procedures, handlers and triggers.
It is also possible to adjust it yourself so that its logging process procedures as well.

I would recomment taking a look at that solution to see how we log stored procedures.

With this logging you will get a table (application_log) and it will log exactly those errors that you are getting into the application log.
From there on out you still have to troubleshoot on how to prevent the error from happening.

Hope this helps.

If you have any questions left, please let me know.

Kind regards,
Robbert


Hi Robert,

 

Our Universal GUI is currently 2024.3.15 , does this mean we are not able to put loggings to the application?

 

Please advice

 

Thank you


Hi Jheng,

 

The version of the SF has to be 2025.1 and up, since your universal is 2024.3 I would guess the SF is not yet 2025.1.

The solution is only available from 2025.1 and up I’m affraid, more reasons to upgrade asap :)


Reply