Skip to main content
Solved

IAM Sync error 2023.1


Freddy
Forum|alt.badge.img+16
  • Thinkwise Local Partner Brasil
  • 529 replies

What is causing this error?

[ERR] Process action "run_sync_script" in processflow "system_flow_sync_to_iam" in application 29 threw an exception. (571360e4)
Indicium.Shared.TSF.NonFatalDbException: Cannot insert the value NULL into column 'tree_show_label', table 'PROVA_IAM.dbo.tab'; column does not allow nulls. UPDATE fails.
The statement has been terminated.
 ---> Microsoft.Data.SqlClient.SqlException (0x80131904): Cannot insert the value NULL into column 'tree_show_label', table 'PROVA_IAM.dbo.tab'; column does not allow nulls. UPDATE fails.
The statement has been terminated.

 

Best answer by Freddy

Mark Jongeling wrote:

Hi Freddy,

This looks like that the synchronization script fails to submit a value for tree_show_label whilst it is a mandatory field. I'll take a look at it and get back in touch here once I know more.

You can double check if there are any tables in your branch that have no value for the tree_show_label column in advance.

 

Never even noticed that field.. but this field was NULL for one of the tables..  If that's a mandatory field you should make it mandatory as well in the SF. (we use 2023.1).  After making it a 0 in the SF, the sync was successful. 

View original
Did this topic help you find an answer to your question?
This topic has been closed for comments

2 replies

Mark Jongeling
Administrator
Forum|alt.badge.img+23

Hi Freddy,

This looks like that the synchronization script fails to submit a value for tree_show_label whilst it is a mandatory field. I'll take a look at it and get back in touch here once I know more.

You can double check if there are any tables in your branch that have no value for the tree_show_label column in advance.


Freddy
Forum|alt.badge.img+16
  • Author
  • Thinkwise Local Partner Brasil
  • 529 replies
  • Answer
  • February 3, 2023
Mark Jongeling wrote:

Hi Freddy,

This looks like that the synchronization script fails to submit a value for tree_show_label whilst it is a mandatory field. I'll take a look at it and get back in touch here once I know more.

You can double check if there are any tables in your branch that have no value for the tree_show_label column in advance.

 

Never even noticed that field.. but this field was NULL for one of the tables..  If that's a mandatory field you should make it mandatory as well in the SF. (we use 2023.1).  After making it a 0 in the SF, the sync was successful. 


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