QC在生成报告的时候出错了

lht821008

win2003 server
oracle9i

我在qc上建立了一个域，域下面三个子系统，其中一个子系统生成文档报告没问题；但是其他的两个使用文档生成器做的时候就不可以，不知道怎么问题，我把报错发上来看看：

报错代码：
Messages:
Failed to List Repository Files;
SQL error executing statement SELECT RP_ID,RP_PARENT_PATH,RP_NAME,RP_PATH_ID,RP_MODIFIED_TIME,LENGTH(RP_DATA) AS DATA_LENGTH FROM (SELECT * FROM (SELECT * FROM REPOSITORY WHERE RP_PARENT_PATH='0/1/5/' AND RP_NAME='TDTmplt.tcf' AND RP_PATH_ID=0 UNION ALL SELECT REPOSITORY.* FROM (SELECT REPOSITORY.*, RP_PARENT_PATH || TO_CHAR(RP_PATH_ID)||'/' AS FILE_PPATH FROM REPOSITORY WHERE (RP_PARENT_PATH = '0/1/5/') AND RP_NAME ='TDTmplt.tcf' AND RP_PATH_ID <> 0) FOLDER INNER JOIN REPOSITORY ON REPOSITORY.RP_PARENT_PATH LIKE FOLDER.FILE_PPATH || '%') D) D ORDER BY RP_PARENT_PATH;
[Mercury][Oracle JDBC Driver][Oracle]ORA-00932: inconsistent datatypes
;

Stack Trace:
java.sql.SQLException: [Mercury][Oracle JDBC Driver][Oracle]ORA-00932: inconsistent datatypes

at com.mercury.jdbc.base.BaseExceptions.createException(Unknown Source)
at com.mercury.jdbc.base.BaseExceptions.getException(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 RP_ID,RP_PARENT_PATH,RP_NAME,RP_PATH_ID,RP_MODIFIED_TIME,LENGTH(RP_DATA) AS DATA_LENGTH FROM (SELECT * FROM (SELECT * FROM REPOSITORY WHERE RP_PARENT_PATH='0/1/5/' AND RP_NAME='TDTmplt.tcf' AND RP_PATH_ID=0 UNION ALL SELECT REPOSITORY.* FROM (SELECT REPOSITORY.*, RP_PARENT_PATH || TO_CHAR(RP_PATH_ID)||'/' AS FILE_PPATH FROM REPOSITORY WHERE (RP_PARENT_PATH = '0/1/5/') AND RP_NAME ='TDTmplt.tcf' AND RP_PATH_ID <> 0) FOLDER INNER JOIN REPOSITORY ON REPOSITORY.RP_PARENT_PATH LIKE FOLDER.FILE_PPATH || '%') D) D ORDER BY RP_PARENT_PATH
at com.mercury.optane.core.db.spring.JDBCTemplate.executeQuery(JDBCTemplate.java:560)
at com.mercury.optane.core.db.spring.JDBCTemplate.executeQuery(JDBCTemplate.java:442)
at com.mercury.optane.core.db.spring.JDBCTemplate.executeQuery(JDBCTemplate.java:429)
at com.mercury.optane.core.db.spring.JDBCTemplate.executeQuery(JDBCTemplate.java:357)
at com.mercury.optane.core.file.db.DBFileTree.listFilteredTable(DBFileTree.java:540)
at com.mercury.optane.core.file.db.DBFileTree.list(DBFileTree.java:514)
at com.mercury.optane.core.estorage.DBRepository.listFiles(DBRepository.java:58)
at com.mercury.td.tdserver.api.logics.CStreamingLogic.getFilesList(CStreamingLogic.java:100)
at com.mercury.td.web.server.CTdServlet.redirectListRepositoryFiles(CTdServlet.java:1321)
at sun.reflect.GeneratedMethodAccessor74.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 List Repository Files
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)

[ 本帖最后由 lht821008 于 2008-8-28 08:54 编辑 ]

小不点蜗牛

郁闷，这个有点唐突啊

lht821008

已经解决，重启服务得到解决。