From the Error, it looks like Effective start and End date is not set properly. See to it variables are properly initialized and given value.

Try this link - https://shivabizint.wordpress.com/2010/09/16/to-open-obiee11g-catalog-manager-on-windows-64bit/

Going by the error message, "com.siebel.analytics.web.catalogmanager_1.0.0.jar" file is missing. Do you have this file anywhere in your OBIEE folder? This file should be there in \\OBIEE11g\Oracle_BI1\bifoundation\web\catalogmanager\plugins . If its not present, whether all necessary patches have been applied after…

By looking at the error, instead of flag value(usually like Y/N or 1/0) being populated, some other value(value of length 10) is getting into this column. please verify the SQL in the Operator. Also, I$ table is drop and create at each run. so if you manually change the column length of this table in DW, it might not be…