• State Suggested Answer
  • Replies 2 replies
  • Answers 1 answer
  • Subscribers 95 subscribers
  • Views 3286 views
  • Users 0 members are here
Options
Related

Unable to compile the database

rahul rawat3
over 5 years ago

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.

  • 0 over 5 years ago

    You might be able to identify why the DB Queue task is failing by looking into the Database Journal with Job Queue Info. It might be that some custom triggers are the reason.

    But I would recommend contacting support as well.

  • 0 over 5 years ago

    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.