No relevant resource is found in the selected language.

This site uses cookies. By continuing to browse the site you are agreeing to our use of cookies. Read our privacy policy>Search


To have a better experience, please upgrade your IE browser.


Prompt Failed to open the database 'xxDB' in Logs

Publication Date:  2012-07-27 Views:  461 Downloads:  0

Issue Description

Database initialization fails. Check the logs in the C:\HWENGR\logs\logsServer directory and the following message is found:
2008-08-06_10:27:51(DBConnectionManager.getSingleConnection)    finish to getSingleConnection
2008-08-06_10:27:51(CMSSQLConfig.mssqlSetDBOwner)   Begin to set database xxDB's owner to NMSuser
2008-08-06_10:27:51(CMSSQLConfig.mssqlSetDBOwner)   ERROR:Set database xxDB's owner to NMSuser failed
2008-08-06_10:27:51(CMSSQLConfig.mssqlSetDBOwner)   ERROR:java.sql.SQLException: [Microsoft][ODBC SQL Server Driver][SQL Server] Failed to open the database 'xxDB', because the file cannot be accessed, or the memory or the disk space is insufficient. For details, see the SQL Server error logs.

Alarm Information


Handling Process

Step 1     Check the disk space.                               
Step 2    
To delete the database manually, run the following commands:
> isql -Usa -Psa's_password -SDBSVR
1> drop database database_name
2> go
Deleting the xxDB database is considered as an example.
> isql -Usa -Psa's_password -SDBSVR
1> drop database xxDB
2> go
Step 3     Initialize the database again.

Root Cause

Certain database files were deleted or the disk space is insufficient.