cancel
Showing results for 
Search instead for 
Did you mean: 

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

6 Replies

Re: Enterprise Vault Upgrade Monitoring Database Failed

i need your help......

Re: Enterprise Vault Upgrade Monitoring Database Failed

Did you try closing SQL Management Studio?

https://www.linkedin.com/in/awsterling/

Re: Enterprise Vault Upgrade Monitoring Database Failed

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

Re: Enterprise Vault Upgrade Monitoring Database Failed

Hi,

did you check for open sessions sql wise? Query active connections with sql.

Re: Enterprise Vault Upgrade Monitoring Database Failed

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.

Re: Enterprise Vault Upgrade Monitoring Database Failed

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