[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.
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.
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.
We use 3 different kinds of cookies. You can choose which cookies you want to accept. We need basic cookies to make this site work, therefore these are the minimum you can select. Learn more about our cookies.