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>

Reminder

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

upgrade

Due to database administrator account has been locked, it will hint "database connected failure"

Publication Date:  2012-11-09 Views:  43 Downloads:  0
Issue Description
When the DSM server abnormal power down, using the client open a document, indicating that the "database connected failed".
Reason description: need through collecting client log to see the reasons of the problem, it may be caused by the database server and DSM server network connection interrupted, or the database’s own problems.
Alarm Information
None.
Handling Process
1, view through collecting DSM’s log:
2011-03-29 09:06:52,562 ERROR [UserOrganiseCacheRefreshTimer][com.huawei.dsm.util.OrganiseCacheUtil]:105 [OrganiseCacheUtil]Access Database error
2011-03-29 09:06:52,562 ERROR [UserOrganiseCacheRefreshTimer][com.huawei.dsm.util.UserOrganiseCacheRefreshTask]:60 [UserOrganiseCacheRefreshTask]  
UserOrganiseCacheRefreshTask error, running time:2011-03-29 09:06:52
org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (ORA-28000:  Account has been locked)
2, check the database, found that the database administrator account has been locked.
3, the methods to solve the database administrator account has been locked:
"HKEY_LOCAL_MACHINE\Software\Microsoft\MSSqlserver\MSSqlServer\LoginMode"
Modify the login mode, modify the key value to 2, hybrid mode.
After retarted the service, you can to local land and unlock the locked database administrator.
Root Cause
Need through collecting client log to see the reasons of the problem, it may be caused by the database server and DSM server network connection interrupted, or the database’s own problems.
Suggestions
To ensure the database administrator account will not be abnormal power off and be locked.

END