• State Suggested Answer
  • Replies 2 replies
  • Answers 1 answer
  • Subscribers 95 subscribers
  • Views 3285 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.

Parents
  • 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.

Reply
  • 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.

Children
No Data