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>


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