也就是附件打不开,找不到附件,这是为什么??
很奇怪,我都连续试了重新安装了好几次了,不知道为什么?
着急等待解决。 qc后台纪录的错误日至:
com.mercury.optane.core.CTdException
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/1/' AND RP_NAME='BUG_1_新建 文本文档.txt' 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/1/') AND RP_NAME ='BUG_1_新建 文本文档.txt' 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/1/' AND RP_NAME='BUG_1_新建 文本文档.txt' 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/1/') AND RP_NAME ='BUG_1_新建 文本文档.txt' AND RP_PATH_ID <> 0) FOLDER INNER JOIN REPOSITORY ON REPOSITORY.RP_PARENT_PATH LIKE FOLDER.FILE_PPATH || '%') D) D ORDER BY RP_PARENT_PATHat 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.GeneratedMethodAccessor81.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 Filesat 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-9-1 16:05 编辑 ]作者: leaveall 时间: 2009-2-26 17:54 标题: 我也遇到这种错误 提示找不到文件 和楼上的一样也是使用ORACLE
我的情况是 在我机器上打开图片只要是中文名字的都提示这种错误。
英文和数字的都很好,在其他人的机器上打开一切都正常。
还有一个问题我的机器上的QC不能输入中文,其他的人的正常。
不知道为什么这样呢?望高人解答下。作者: bill_hen 时间: 2009-2-28 02:51
What is the charset of your Oracle database?
It is probably complaining the RP_NAME column.