12-27-2019 11:23 PM - edited 12-28-2019 02:12 AM
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
12-28-2019 03:41 AM
i need your help......
12-28-2019 06:02 PM
Did you try closing SQL Management Studio?
12-29-2019 11:18 PM
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..
12-31-2019 02:13 AM
Hi,
did you check for open sessions sql wise? Query active connections with sql.
01-06-2020 11:45 AM
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.
01-07-2020 02:47 PM
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