Forum Discussion

sandeepk's avatar
sandeepk
Level 5
6 years ago

Enterprise Vault Upgrade Monitoring Database Failed

Dear Team,

I am getting below error message when i upgrade enterprise vault 12.0 database

EnterpriseVaultMonitoring: Could not be upgraded. Database remains on version'7.4.8.5.0'. The database cannot be upgraded while other users are connected:There is one SQL connection open on this database from the computer 'EV'from program 'Microsoft SQL Server Management Studio' run by 'xxxxx\evadmin'.

 

Some databases could not be upgraded:

The Audit Database was upgraded successfully to '3.2.0.1.0'
The Directory Database was upgraded successfully to '12.24.6.207.0'
The Monitoring Database failed to upgrade from '7.4.8.5.0' to '12.1.0.9.0'

thanks

sandeepk

      • sandeepk's avatar
        sandeepk
        Level 5
        6 years ago

        Dear Tony,

        thanks for reply..

        after closing SQL Management Studio we are getting same error message. also we have put database in singlae user mode but no luck.. 

  • AndrewB's avatar
    AndrewB
    Moderator
    6 years ago

    you can run the query 'exec sp_who' and 'exec sp_who2' to find out what open connections you have to the db. you could also look at activity monitor if you needed to.

    • JimmyNeutron's avatar
      JimmyNeutron
      Level 6
      6 years ago

      You can view all the SQL transactions with SQL activity monitor. If all of you EV services are stopped you should not see any transactions running. You probably have orphaned/stale transactions that need to be killed.

      This happens when there is a connection made to that database which you will see in the activity monitor