Skip to main content

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.

 

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.

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. 

Terms & ConditionsCookie settings