Skip to main content
Solved

How to put loggings to display in error logs


Forum|alt.badge.img+1

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.

Best answer by Robbert van Tongeren

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 :)

View original
Did this topic help you find an answer to your question?

3 replies

Robbert van Tongeren
Thinkwise blogger

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


Forum|alt.badge.img+1
  • Author
  • Sidekick
  • 26 replies
  • April 28, 2025

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


Robbert van Tongeren
Thinkwise blogger

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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings