Unable to compile the database

Question

I am using One Identity Manager version 7 where after committing the all the jobs when i try to compile them, the compiler is unable to fetch the jobs to be compiled. 
 Instead it is having an Operation name QBM-K-QBMConstraintEnable2 in the queue which it is neither executing nor terminating. 
 Because of this problem i am unable to run any operation in One IM.

Barry Jackson · Answer

Hi Rahul, 
 I have come across this situation before ..... in my case there were some bad foreign keys in the database. 
 I suggest running: 
 exec dbo.QBM_PForeignKeyWrongReport 
 Which may or may not return some results. 
 If it does return results then run: 
 exec dbo.QBM_PForeignKeyWrongRepair 
 After that your ConstraintEnable2 should clear. 
 If the report does NOT return any results and/or the repair does not resolve the issue for you then I'm afraid it's a support case. 
 HTH, Barry.

Unable to compile the database

Top Replies