关于QC使用Oracle数据的一些问题

sheng6804

公司使用的是QC9.0+Oracle9i搭建的测试管理平台，发现如下几个问题：
1，从需求转换为测试主题，然后再测试计划中编写测试用例后，只能用测试用例一条一条的与需求关联，使用需求选择测试用例时，无论如何也不能将测试用例与该需求链接起来；网上也只有需求和用例的链接方法可查询，却没有找到此类问题的解决方法，究竟是何原因望高手指点迷津，难道与Oracle的版本有关？
2，使用测试用例一条一条链接需求后，在需求里查看范围分析，当点击长条覆盖率图形后，弹出窗口，点击右下角的“添加测试覆盖”就会报错，内容为如下
Messages:
Failed to Get Coverage;
Failed to get list of entities keys and/or fill the GroupHeaders list for request: [Filter]{
TableName:REQ_COVER,
ColumnName:RC_ENTITY_STATUS,
LogicalFilter:All,
NO_CASE:
};
SQL error executing statement SELECT RC_ITEM_ID FROM REQ_COVER INNER JOIN TEST ON (RC_ENTITY_TYPE='TEST' AND RC_ENTITY_ID=TS_TEST_ID) OR (RC_ENTITY_TYPE='TESTCYCL' AND TS_TEST_ID=(SELECT TC_TEST_ID FROM TESTCYCL WHERE TC_TESTCYCL_ID=RC_ENTITY_ID)) LEFT OUTER JOIN TESTCYCL ON RC_ENTITY_TYPE='TESTCYCL' AND RC_ENTITY_ID=TC_TESTCYCL_ID WHERE ((( ((LOWER(TS_EXEC_STATUS)=/*P*/'all' AND RC_ENTITY_TYPE=/*P*/'TEST') OR (LOWER(TC_STATUS)=/*P*/'all' AND RC_ENTITY_TYPE=/*P*/'TESTCYCL')))) AND RC_REQ_ID IN ( SELECT RQ_REQ_ID FROM REQ WHERE RQ_REQ_PATH LIKE /*P*/'AABAAA%')) ORDER BY RC_ITEM_ID ASC;
[Mercury][Oracle JDBC Driver]No more data available to read.;

Stack Trace:
java.sql.SQLException: [Mercury][Oracle JDBC Driver]No more data available to read.
at com.mercury.jdbc.base.BaseExceptions.createException(Unknown Source)
at com.mercury.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.mercury.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.mercury.jdbc.oracle.net8.OracleNet8NSPTDAPacket.sendRequest(Unknown Source)
at com.mercury.jdbc.oracle.OracleImplStatement.execute(Unknown Source)
at com.mercury.jdbc.base.BaseStatement.commonExecute(Unknown Source)
at com.mercury.jdbc.base.BaseStatement.executeQueryInternal(Unknown Source)
at com.mercury.jdbc.base.BasePreparedStatement.executeQuery(Unknown Source)
at com.mercury.optane.core.db.CTdPreparedStatement.executeQuery(CTdPreparedStatement.java:510)
at com.mercury.optane.core.db.spring.JDBCTemplate.executeQuery(JDBCTemplate.java:554)
        wrapped in com.mercury.optane.core.db.CTdDbException: SQL error executing statement SELECT RC_ITEM_ID FROM REQ_COVER INNER JOIN TEST ON (RC_ENTITY_TYPE='TEST' AND RC_ENTITY_ID=TS_TEST_ID) OR (RC_ENTITY_TYPE='TESTCYCL' AND TS_TEST_ID=(SELECT TC_TEST_ID FROM TESTCYCL WHERE TC_TESTCYCL_ID=RC_ENTITY_ID)) LEFT OUTER JOIN TESTCYCL ON RC_ENTITY_TYPE='TESTCYCL' AND RC_ENTITY_ID=TC_TESTCYCL_ID WHERE ((( ((LOWER(TS_EXEC_STATUS)=/*P*/'all' AND RC_ENTITY_TYPE=/*P*/'TEST') OR (LOWER(TC_STATUS)=/*P*/'all' AND RC_ENTITY_TYPE=/*P*/'TESTCYCL')))) AND RC_REQ_ID IN ( SELECT RQ_REQ_ID FROM REQ WHERE RQ_REQ_PATH LIKE /*P*/'AABAAA%')) ORDER BY RC_ITEM_ID ASC
at com.mercury.optane.core.db.spring.JDBCTemplate.executeQuery(JDBCTemplate.java:560)
at com.mercury.optane.core.db.spring.JDBCTemplate.executeQuery(JDBCTemplate.java:455)
at com.mercury.optane.core.db.spring.JDBCTemplate.executeQuery(JDBCTemplate.java:379)
at com.mercury.td.appbase.getvalue.GetValueService.getKeysFromSqlStruct(GetValueService.java:581)
at com.mercury.td.appbase.getvalue.GetValueService.retrieveKeysAndGroupsFromRequest(GetValueService.java:303)
        wrapped in com.mercury.optane.core.CTdException: Failed to get list of entities keys and/or fill the GroupHeaders list for request: [Filter]{
TableName:REQ_COVER,
ColumnName:RC_ENTITY_STATUS,
LogicalFilter:All,
NO_CASE:
}
at com.mercury.td.appbase.getvalue.GetValueService.retrieveKeysAndGroupsFromRequest(GetValueService.java:317)
at com.mercury.td.appbase.getvalue.GetValueService.retrieveKeysFromRequest(GetValueService.java:210)
at com.mercury.td.appbase.getvalue.GetValueService.getValue(GetValueService.java:150)
at com.mercury.td.tdserver.api.logics.CAbsBaseApiLogic.getValue(CAbsBaseApiLogic.java:1132)
at com.mercury.td.tdserver.api.logics.CAbsBaseApiLogic.getValue(CAbsBaseApiLogic.java:1144)
at com.mercury.td.tdserver.api.logics.coverage.CCoverageLogic.getCoverage(CCoverageLogic.java:1322)
at com.mercury.td.web.server.CTdServlet.redirectGetCoverage(CTdServlet.java:803)
at sun.reflect.GeneratedMethodAccessor143.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 Coverage
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.td.web.server.CTdServlet.processRequest(CTdServlet.java:319)
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)
再次怀疑是Oracle版本问题
请教有什么方便快捷的解决方法没有？

lk5596801

对Oracle数据不熟

橙子