QC出现异常求帮助

iitachi

最近公司两套环境的QC分别出现很奇怪的异常情况，不知是否有人遇到或同样的问题。
两套环境用的都是QC9.0 + oracle11g

环境一的问题：
进入后台管理，激活项目时一部分项目正常，一部分项目无法激活，也获取不到用户信息。报错信息如下：

Messages:
Failed to Get Projects Properties;
Failed to get projects properties;
Failed to save projects properties;
Cannot build directory item for key '[default_apptest_db@jdbc:mercuryracle://10.xx.xx.xx:1521;sid=qcserver(default_apptest_db)]' in TD Tables Struct Dir;
Failed to fill table struct for table null in database default_apptest_db@jdbc:mercuryracle://10.xx.xx.xx:1521;sid=qcserver(default_apptest_db);
[Mercury][Oracle JDBC Driver]Login has timed out.;

Stack Trace:
java.sql.SQLException: [Mercury][Oracle JDBC Driver]Login has timed out.
at com.mercury.jdbc.base.BaseExceptions.createException(Unknown Source)
at com.mercury.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.mercury.jdbc.base.BaseConnectionStartup.<init>(Unknown Source)
at com.mercury.jdbc.base.BaseConnection$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at com.mercury.jdbc.base.BaseConnection.setupImplConnection(Unknown Source)
at com.mercury.jdbc.base.BaseConnection.open(Unknown Source)
at com.mercury.jdbc.base.BaseDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:140)
at com.mercury.optane.core.db.CTdDriverManager.getConnection(CTdDriverManager.java:74)
        wrapped in com.mercury.optane.core.CTdException:
at com.mercury.optane.core.db.CTdDriverManager.getConnection(CTdDriverManager.java:81)
at com.mercury.optane.core.db.CConnectionPool.newConnection(CConnectionPool.java:665)
at com.mercury.optane.core.db.CConnectionPool.tryToGetConnection(CConnectionPool.java:491)
at com.mercury.optane.core.db.CConnectionPool.getConnection(CConnectionPool.java:316)
at com.mercury.optane.core.db.CConnectionManager.getNotTransactedConnection(CConnectionManager.java:299)
at com.mercury.optane.core.db.CConnectionManager.getConnection(CConnectionManager.java:264)
at com.mercury.optane.core.db.CDatabaseFieldsInfo.obtainInfo(CDatabaseFieldsInfo.java:135)
        wrapped in com.mercury.optane.core.CTdException: Failed to fill table struct for table null in database default_apptest_db@jdbc:mercuryracle://10.xx.xx.xx:1521;sid=qcserver(default_apptest_db)
at com.mercury.optane.core.db.CDatabaseFieldsInfo.obtainInfo(CDatabaseFieldsInfo.java:157)
at com.mercury.td.CTdDatabaseFieldsInfo.obtainInfo(CTdDatabaseFieldsInfo.java:80)
at com.mercury.optane.core.db.CDatabaseFieldsInfo.<init>(CDatabaseFieldsInfo.java:77)
at com.mercury.td.CTdDatabaseFieldsInfo.<init>(CTdDatabaseFieldsInfo.java:58)
at com.mercury.td.CTdTablesStructDirectory.createDirectoryItem(CTdTablesStructDirectory.java:167)
at com.mercury.optane.core.directory.CAbsDirectory.getDirectoryItem(CAbsDirectory.java:81)
        wrapped in com.mercury.optane.core.CTdException: Cannot build directory item for key '[default_apptest_db@jdbc:mercuryracle://10.xx.xx.xx:1521;sid=qcserver(default_apptest_db)]' in TD Tables Struct Dir
at com.mercury.optane.core.directory.CAbsDirectory.getDirectoryItem(CAbsDirectory.java:87)
at com.mercury.td.CTdTablesStructDirectory.getDirectoryItem(CTdTablesStructDirectory.java:151)
at com.mercury.optane.core.db.CAbsTablesStructDirectory.getDatabaseFieldsInfo(CAbsTablesStructDirectory.java:101)
at com.mercury.td.saserver.directory.CProject.getProjectDbContext(CProject.java:1311)
at com.mercury.td.saserver.directory.CProject.getProjectDbContext(CProject.java:1288)
at com.mercury.td.saserver.directory.CProject.getProjectVersion(CProject.java:1373)
at com.mercury.td.saserver.directory.CProject.getProjectVersion(CProject.java:1365)
at com.mercury.td.saserver.directory.CProject.saveToFrecWithVersion(CProject.java:608)
        wrapped in com.mercury.optane.core.CTdException: Failed to save projects properties
at com.mercury.td.saserver.directory.CProject.saveToFrecWithVersion(CProject.java:621)
at com.mercury.td.saserver.directory.CProject.saveToFrec(CProject.java:648)
at com.mercury.td.saserver.api.logics.CProjectLogic.getProjectsProperties(CProjectLogic.java:261)
        wrapped in com.mercury.optane.core.CTdException: Failed to get projects properties
at com.mercury.td.saserver.api.logics.CProjectLogic.getProjectsProperties(CProjectLogic.java:282)
at com.mercury.td.saserver.web.CTdSiteAdminServlet.redirectGetProjectsProperties(CTdSiteAdminServlet.java:309)
at sun.reflect.GeneratedMethodAccessor80.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at com.mercury.optane.core.web.CAbsServlet.executeFunction(CAbsServlet.java:554)
        wrapped in com.mercury.optane.core.CTdException: Failed to Get Projects Properties
at com.mercury.optane.core.web.CAbsServlet.executeFunction(CAbsServlet.java:560)
at com.mercury.optane.core.web.CAbsServlet.processRequest(CAbsServlet.java:535)
at com.mercury.optane.core.web.CAbsServlet.doPost(CAbsServlet.java:418)
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 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:534)




环境二的问题：

登陆QC提示错误信息：

没有授权您注册模块<需求>。
请与您的项目管理员联系。

登陆进去后则看不到<需求>模块，而这些模块并没有做权限控制。。。

求帮助求解决。

lsekfe

'[default_apptest_db@jdbc:mercuryracle://10.xx.xx.xx:1521;sid=qcserver(default_apptest_db)]' in TD Tables Struct Dir;
Failed to fill table struct for table null in database

jingzizx

怎么看着是数据库有问题呢