The synchronize to IAM was failed on the step “Synchronizing: tab_prefilter”. How can I find out the problem?
Page 1 / 1
Hi 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)
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!
That'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.