Director Login error: "The database is currently being upgraded, please try to login again in a few


  
 Applies To 
  
 Product(s):eB 
 Version(s):15.x.x & 16.x.x
 Environment: N/A
 Area: SMC, Director Login
 Subarea: Database Upgrade
 Original Author:Sayyad Inamdar, Bentley Technical Support Group

Problem Description:

User is trying to log in to Director and getting this error.

Error:

The database is currently being upgraded, please try to login again in a few moments.

Root Cause:

This leaves the database upgrade in middle and causes error while logging in.

Solution:

  1. Go to SQL Server Management Studio, Go to the databases make a new query for the database you are not able to log in
  2. Run this query: “Select * From db_packages
  3. You will get the following SQL

         4.The status codes are as follows U-Upgrading, I-Invalid, V- Valid. This creates the issue while logging in into Director.

         5.Run the another query to change this status to ‘V’. Update db_packages Set status='V'

This should resolve the issue.