will1225 发表于 2008-7-9 19:19:24

qc9.0数据移植到QC9.2,报错,急寻解决方案,谢谢!

将QC9.0对应的数据库数据:SQL2005数据导出,文件名为:testback.bak。备份前期QC安装目录下的repository,备份其中的dbcon.txt和dbid.xml文件。
恢复操作执行过程为:先在SQL2005中还原数据,正常操作,再在QC9.2中建立同以前同名的域,RESTORE项目,导入dbid.xml文件。现实项目ACTIVE状态,点击项目图标,却不能正常展开,提示出错信息如下:
to Get Projects Properties;
Failed to get projects properties;
Failed to save projects properties;
Cannot build directory item for key '' in TD Tables Struct Dir;
Failed to fill table struct for table ACTIONS in database test_db@jdbc:mercury:sqlserver://CQ:1433(td);
Failed to determine structure of table 'ACTIONS';
Invalid object name 'ACTIONS'.;
Stack Trace:
java.sql.SQLException: Invalid object name 'ACTIONS'.
at com.mercury.jdbc.base.BaseExceptions.createException(Unknown Source)
at com.mercury.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.mercury.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown Source)
at com.mercury.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown Source)
at com.mercury.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown Source)
at com.mercury.jdbc.sqlserver.SQLServerImplStatement.getNextResultType(Unknown Source)
at com.mercury.jdbc.base.BaseStatement.commonTransitionToState(Unknown Source)
at com.mercury.jdbc.base.BaseStatement.postImplExecute(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.BaseStatement.executeQuery(Unknown Source)
at com.mercury.optane.core.db.CDatabaseFieldsInfo.fillStructArray(CDatabaseFieldsInfo.java:302)
wrapped in com.mercury.optane.core.db.CTdDbException: Failed to determine structure of table 'ACTIONS'
at com.mercury.optane.core.db.CDatabaseFieldsInfo.fillStructArray(CDatabaseFieldsInfo.java:325)
at com.mercury.optane.core.db.CDatabaseFieldsInfo.obtainInfo(CDatabaseFieldsInfo.java:131)
wrapped in com.mercury.optane.core.CTdException: Failed to fill table struct for table ACTIONS in database test_db@jdbc:mercury:sqlserver://CQ:1433(td)
at com.mercury.optane.core.db.CDatabaseFieldsInfo.obtainInfo(CDatabaseFieldsInfo.java:134)
at com.mercury.td.CTdDatabaseFieldsInfo.obtainInfo(CTdDatabaseFieldsInfo.java:76)
at com.mercury.optane.core.db.CDatabaseFieldsInfo.<init>(CDatabaseFieldsInfo.java:67)
at com.mercury.td.CTdDatabaseFieldsInfo.<init>(CTdDatabaseFieldsInfo.java:55)
at com.mercury.td.CTdTablesStructDirectory.createDirectoryItem(CTdTablesStructDirectory.java:77)
at com.mercury.optane.core.directory.CAbsDirectory.getDirectoryItem(CAbsDirectory.java:80)
wrapped in com.mercury.optane.core.CTdException: Cannot build directory item for key '' in TD Tables Struct Dir
at com.mercury.optane.core.directory.CAbsDirectory.getDirectoryItem(CAbsDirectory.java:86)
at com.mercury.td.CTdTablesStructDirectory.getDirectoryItem(CTdTablesStructDirectory.java:61)
at com.mercury.optane.core.db.CAbsTablesStructDirectory.getDatabaseFieldsInfo(CAbsTablesStructDirectory.java:27)
at com.mercury.td.saserver.directory.CProject.getProjectDbContext(CProject.java:1364)
at com.mercury.td.saserver.directory.CProject.getProjectDbContext(CProject.java:1341)
at com.mercury.td.saserver.directory.CProject.getProjectVersion(CProject.java:1428)
at com.mercury.td.saserver.directory.CProject.getProjectVersion(CProject.java:1420)
at com.mercury.td.saserver.directory.CProject.saveToFrecWithVersion(CProject.java:642)
wrapped in com.mercury.optane.core.CTdException: Failed to save projects properties
at com.mercury.td.saserver.directory.CProject.saveToFrecWithVersion(CProject.java:656)
at com.mercury.td.saserver.directory.CProject.saveToFrec(CProject.java:683)
at com.mercury.td.saserver.api.logics.CProjectLogic.getProjectsProperties(CProjectLogic.java:252)
wrapped in com.mercury.optane.core.CTdException: Failed to get projects properties
at com.mercury.td.saserver.api.logics.CProjectLogic.getProjectsProperties(CProjectLogic.java:273)
at com.mercury.td.saserver.requests.GetProjectsProperties.execute(GetProjectsProperties.java:25)
at com.mercury.optane.core.web.RequestsDispatcher.execute(RequestsDispatcher.java:87)
wrapped in com.mercury.optane.core.CTdException: Failed to Get Projects Properties
at com.mercury.optane.core.web.RequestsDispatcher.execute(RequestsDispatcher.java:93)
at com.mercury.optane.core.web.CAbsServlet.executeFunction(CAbsServlet.java:548)
at com.mercury.optane.core.web.CAbsServlet.processRequest(CAbsServlet.java:540)
at com.mercury.optane.core.web.CAbsServlet.doPost(CAbsServlet.java:423)
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:595)
我有什么地方做错了嘛,为什么提示ACTIONS出错。

kasimxiao 发表于 2008-7-13 21:15:57

直接导出项目,导入项目呢
页: [1]
查看完整版本: qc9.0数据移植到QC9.2,报错,急寻解决方案,谢谢!