When extending a custom column in Siebel 8.X which have case and accent insensitive (CIAI) enabled, running EIM mapping wizard creates corresponding mapping in EIM table. After which running an EIM job will cause the job to fail with the following error
"SBL-EIM-00205: NULL target table for relation!" followed by "Failed to load the application dictionary"
Root Cause :
This issue is caused by EIM Mapping wizard which creates mapping for the custom column and also for CI Columns onthe EIM table. EIM mappings should not be existing in the EIM table, as CI columns are not supported by EIM
Solution :
This can be fixed by adopting the following steps
· Delete/inactivate the CI columns under EIM table
· Delete diccache.dat (dictionary) file from SiebSrvr\Bin directory so that fresh file will be created following the deletion of CI column mappings.