站点管理激活项目时出现错误：Failed to Get Projects Properties（结贴）

zhoward

我在QC站点管理中维护一项目，名为Project_for_tem，修改密码然后重新激活，出现错误：Failed to Get Projects Properties.具体如下：
Messages:
Failed to Get Projects Properties;
Failed to get projects properties;
Failed to save projects properties;
Cannot build directory item for key '[mic_project_for_tem_db@jdbc:mercuryracle://serverfortesting:1521;sid=orcl(mic_project_for_tem_db)]' in TD Tables Struct Dir;
Failed to fill table struct for table null in database mic_project_for_tem_db@jdbc:mercuryracle://serverfortesting:1521;sid=orcl(mic_project_for_tem_db);
[Mercury][Oracle JDBC Driver][Oracle]ORA-28000: the account is locked
;

Stack Trace:
java.sql.SQLException: [Mercury][Oracle JDBC Driver][Oracle]ORA-28000: the account is locked

at com.mercury.jdbc.oraclebase.BaseExceptions.createSQLException(Unknown Source)
at com.mercury.jdbc.oraclebase.BaseExceptions.createException(Unknown Source)
at com.mercury.jdbc.oraclebase.BaseExceptions.getException(Unknown Source)
at com.mercury.jdbc.oracle.OracleImplConnection.connectAndAuthenticate(Unknown Source)
at com.mercury.jdbc.oracle.OracleImplConnection.open(Unknown Source)
at com.mercury.jdbc.oraclebase.BaseConnection.doConnect(Unknown Source)
at com.mercury.jdbc.oraclebase.BaseConnection.connect(Unknown Source)
at com.mercury.jdbc.oraclebase.BaseConnection.setupImplConnection(Unknown Source)
at com.mercury.jdbc.oraclebase.BaseConnection.open(Unknown Source)
at com.mercury.jdbc.oraclebase.BaseDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(DriverManager.java:525)
at java.sql.DriverManager.getConnection(DriverManager.java:140)
at com.mercury.optane.core.db.CTdDriverManager.getConnection(CTdDriverManager.java:81)
        wrapped in com.mercury.optane.core.CTdException:
at com.mercury.optane.core.db.CTdDriverManager.getConnection(CTdDriverManager.java:88)
at com.mercury.optane.core.db.CConnectionPool.newConnection(CConnectionPool.java:801)
at com.mercury.optane.core.db.CConnectionPool.tryToGetConnection(CConnectionPool.java:588)
at com.mercury.optane.core.db.CConnectionPool.getConnection(CConnectionPool.java:356)
at com.mercury.optane.core.db.CConnectionManager.getNotTransactedConnection(CConnectionManager.java:302)
at com.mercury.optane.core.db.CConnectionManager.getConnection(CConnectionManager.java:276)
at com.mercury.optane.core.db.CDatabaseFieldsInfo.obtainInfo(CDatabaseFieldsInfo.java:132)
        wrapped in com.mercury.optane.core.CTdException: Failed to fill table struct for table null in database mic_project_for_tem_db@jdbc:mercuryracle://serverfortesting:1521;sid=orcl(mic_project_for_tem_db)
at com.mercury.optane.core.db.CDatabaseFieldsInfo.obtainInfo(CDatabaseFieldsInfo.java:158)
at com.mercury.td.CTdDatabaseFieldsInfo.obtainInfo(CTdDatabaseFieldsInfo.java:78)
at com.mercury.optane.core.db.CDatabaseFieldsInfo.<init>(CDatabaseFieldsInfo.java:80)
at com.mercury.td.CTdDatabaseFieldsInfo.<init>(CTdDatabaseFieldsInfo.java:55)
at com.mercury.td.CTdTablesStructDirectory.createDirectoryItem(CTdTablesStructDirectory.java:86)
at com.mercury.optane.core.directory.CAbsDirectory$CacheResult.getOrCreate(CAbsDirectory.java:66)
        wrapped in com.mercury.optane.core.CTdException: Cannot build directory item for key '[mic_project_for_tem_db@jdbc:mercuryracle://serverfortesting:1521;sid=orcl(mic_project_for_tem_db)]' in TD Tables Struct Dir
at com.mercury.optane.core.directory.CAbsDirectory$CacheResult.getOrCreate(CAbsDirectory.java:77)
at com.mercury.optane.core.directory.CAbsDirectory.getDirectoryItem(CAbsDirectory.java:166)
at com.mercury.td.CTdTablesStructDirectory.getDirectoryItem(CTdTablesStructDirectory.java:67)
at com.mercury.optane.core.db.CAbsTablesStructDirectory.getDatabaseFieldsInfo(CAbsTablesStructDirectory.java:27)
at com.mercury.td.saserver.directory.CProject.getProjectDbContext(CProject.java:1531)
at com.mercury.td.saserver.directory.CProject.getProjectDbContext(CProject.java:1507)
at com.mercury.td.saserver.directory.CProject.getProjectVersion(CProject.java:1595)
at com.mercury.td.saserver.directory.CProject.getProjectVersion(CProject.java:1587)
at com.mercury.td.saserver.directory.CProject.saveToFrecWithVersion(CProject.java:734)
        wrapped in com.mercury.optane.core.CTdException: Failed to save projects properties
at com.mercury.td.saserver.directory.CProject.saveToFrecWithVersion(CProject.java:751)
at com.mercury.td.saserver.directory.CProject.saveToFrec(CProject.java:778)
at com.mercury.td.saserver.api.logics.CProjectLogic.getProjectsProperties(CProjectLogic.java:309)
        wrapped in com.mercury.optane.core.CTdException: Failed to get projects properties
at com.mercury.td.saserver.api.logics.CProjectLogic.getProjectsProperties(CProjectLogic.java:328)
at com.mercury.td.saserver.requests.GetProjectsProperties.execute(GetProjectsProperties.java:26)
at com.mercury.optane.core.web.RequestsDispatcher.execute(RequestsDispatcher.java:91)
        wrapped in com.mercury.optane.core.CTdException: Failed to Get Projects Properties
at com.mercury.optane.core.web.RequestsDispatcher.execute(RequestsDispatcher.java:98)
at com.mercury.td.web.CAbsServlet.executeFunction(CAbsServlet.java:444)
at com.mercury.td.web.CAbsServlet.processRequest(CAbsServlet.java:436)
at com.mercury.td.web.CAbsServlet.doPost(CAbsServlet.java:332)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at com.hp.qc.core.utils.gzipfilter.GZIPFilter.doFilter(GZIPFilter.java:30)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:81)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipalValve.java:39)
at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:153)
at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:59)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at org.apache.catalina.valves.FastCommonAccessLogValve.invoke(FastCommonAccessLogValve.java:481)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112)
at java.lang.Thread.run(Thread.java:595)

我能看懂的错误是java.sql.SQLException: [Mercury][Oracle JDBC Driver][Oracle]ORA-28000: the account is locked，用户被锁定。
请问这个问题该怎么解决？在线等，谢谢了

zhoward

ALTER USER username ACCOUNT UNLOCK; 对用户进行解锁。 重新进入站点管理，修改密码为空，然后就可以激活项目了。好像创建项目时，密码默认为空。