• State Suggested Answer
  • Replies 4 replies
  • Answers 2 answers
  • Subscribers 97 subscribers
  • Views 987 views
  • Users 0 members are here
Options
Related

Cannot Connect to database because a system update is running.

sherif elaassar

Hello Guys,

I have a customer environment and it was working fine, then suddenly when I try to open any of the admin tools, it keeps telling me "Cannot connect to database because a system update is running".

It has been into this state now for 2 days and still the update is not finished and I cannot find any service or app running in the background to update.

Also, I don't have access on the DB Server to execute anything on the SQL Server Management Studio as this is a production DB and the customer has concerns about giving access to it.

if anyone has any clue, I would be so grateful.

I'm using OneIdentity Manager 9.2.1

Parents
  • 0

    This usually happens when a One Identity Manager update didn’t complete properly. The database sets a flag saying “system update is running” and never clears it, so you get locked out even if no update is active.

    You’ll need a DBA with SQL Server access to check the DialogDatabase table – if the IsUpdating flag is still set to 1, it can be reset to 0 once they confirm the schema is consistent. After that, the tools should connect normally again.

    If the update actually failed mid-way and caused corruption, then just clearing the flag won’t help. In that case, you’d either need to restore from backup or use a repair utility like Stellar Repair for MS SQL to bring the database back to a stable state before re-running the update.

Reply
  • 0

    This usually happens when a One Identity Manager update didn’t complete properly. The database sets a flag saying “system update is running” and never clears it, so you get locked out even if no update is active.

    You’ll need a DBA with SQL Server access to check the DialogDatabase table – if the IsUpdating flag is still set to 1, it can be reset to 0 once they confirm the schema is consistent. After that, the tools should connect normally again.

    If the update actually failed mid-way and caused corruption, then just clearing the flag won’t help. In that case, you’d either need to restore from backup or use a repair utility like Stellar Repair for MS SQL to bring the database back to a stable state before re-running the update.

Children
No Data