求助QC9.0缺陷模块附件问题着急。。。

lht821008

求助QC9.0缺陷模块附件上传问题

平台windows server2003
数据库oracle9i

其它都默认，表空间选择oracle的user表空间，大小扩展100mb;

安装一切都正常了，但是有个问题：
1、新建缺陷后，上传附件状态条显示传上去了，并且附件大小在附件列表中也有显示；
2、接着浏览这个缺陷，打开附件的时候，下载进度条正常走完了，但是接着弹出错误提示“找不到文件”；

也就是附件打不开，找不到附件，这是为什么？？
很奇怪，我都连续试了重新安装了好几次了，不知道为什么？
着急等待解决。
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 11:54 编辑 ]

lht821008

因为这个错误：
[Mercury][Oracle JDBC Driver][Oracle]ORA-00932: inconsistent datatypes

我又查了一下QC自带的数据字典的介绍发现存储附件的字段在ORACLE中是BLOB，但是QC类型定义为：LongVarBinary不知道这两种类型有什么区别，我用PL/SQL读取上传的文件打开都是正常显示的，说明附件正确的上传导数据库了市确定无疑的，但是为什么在QC界面上读取得时候就会友错误呢，找不到文件的错误。一头雾水

因为这样会造成读取附件的时候类在解析过程由于类型问题造成错误，也许是因为这个原因造成的吧，只是我的猜测！

[ 本帖最后由 lht821008 于 2008-9-1 16:05 编辑 ]

leaveall

和楼上的一样也是使用ORACLE
我的情况是 在我机器上打开图片只要是中文名字的都提示这种错误。
英文和数字的都很好，在其他人的机器上打开一切都正常。
还有一个问题我的机器上的QC不能输入中文，其他的人的正常。
不知道为什么这样呢？望高人解答下。

bill_hen

What is the charset of your Oracle database?
It is probably complaining the RP_NAME column.

QQ 联系: 546562584