The synchronize to IAM was failed on the step “Synchronizing: tab_prefilter”. How can I find out the problem?
Solved
How to debug the issue when synchronizing fails
+12- Hero
- 108 replies
Best answer by Dennis van Leeuwen
The error in the Indicium log seems to confirm your suspicion.
[ERR] Process action "run_sync_script" in process flow "system_flow_sync_to_iam" in application 21 threw an exception. (dedd009e)
Indicium.Shared.TSF.NonFatalDbException: Cannot insert the value NULL into column 'tab_prefilter_id', table 'AMBER_IAM.dbo.usr_pref_model_tab_prefilter_status'; column does not allow nulls. UPDATE fails.
The statement has been terminated.
I have manually added the prefilter again with the same tab_prefilter_id as before and converted it to "Off hidden". Problem solved!
This topic has been closed for replies.
+23Hi Dennis,
The Indicium log is a good place to start. Synchronizing should never fail during the synchronization phase.
My guess is that you have encountered the issue where you have removed a prefilter from the model, whilst a user of your application has registered that prefilter in their user preferences. We have released a platform improvement for that: 🚀 Platform improvements for week 39 | Thinkwise Community (thinkwisesoftware.com)
"Wake me up before you low-code" | On holiday 06-02 till 27-06
1 person likes this
+12- Hero
- 108 replies
- Answer
The error in the Indicium log seems to confirm your suspicion.
[ERR] Process action "run_sync_script" in process flow "system_flow_sync_to_iam" in application 21 threw an exception. (dedd009e)
Indicium.Shared.TSF.NonFatalDbException: Cannot insert the value NULL into column 'tab_prefilter_id', table 'AMBER_IAM.dbo.usr_pref_model_tab_prefilter_status'; column does not allow nulls. UPDATE fails.
The statement has been terminated.
I have manually added the prefilter again with the same tab_prefilter_id as before and converted it to "Off hidden". Problem solved!
+23That's of course a possibility, but I recommend running the platform improvement.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.