如何才能让QC改变默认指向的数据库？

lyron

请问我现在用原来TD的数据库副本（SQL的BAK文件）还原到QC的SQL数据库中，但是怎么才能让QC去使用这个数据库里的数据呢？

鹏城笑笑生

把QC自带的数据库卸载掉试试

lyron

楼上 我没用QC自带的数据库  我是直接用SQL数据库的

lyron

在线等待解答

lyron

目前把TD数据导入QC的数据库中，登陆QC时提示“链接项目错误”

Messages:
Failed to Connect Project;
Failed to connect user 'liuyan' to project 测试管理 in domain 世纪龙;
Failed to find project 测试管理 in domain 世纪龙;
Failed to load properties of project '世纪龙::测试管理';
Failed to obtain a connection to schema '世纪龙_测试管理_db';
Can't create a new database connection for url 'jdbc:mercury:sqlserver://LIUYAN:1433';
[Mercury][SQLServer JDBC Driver][SQLServer]设备激活错误。物理文件名 'D:\Program Files\Mercury\Quality Center\repository\qc\世纪龙_9\default_11测试管理_db0.mdf' 可能有误。;

Stack Trace:
java.sql.SQLException: [Mercury][SQLServer JDBC Driver][SQLServer]设备激活错误。物理文件名 'D:\Program Files\Mercury\Quality Center\repository\qc\世纪龙_9\default_11测试管理_db0.mdf' 可能有误。
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.SQLServerImplConnection.setCatalog(Unknown Source)
at com.mercury.jdbc.base.BaseConnection.setCatalog(Unknown Source)
at com.mercury.optane.core.db.CConnectionPool.newConnection(CConnectionPool.java:666)
        wrapped in com.mercury.optane.core.db.CTdDbException: Can't create a new database connection for url 'jdbc:mercury:sqlserver://LIUYAN:1433'
at com.mercury.optane.core.db.CConnectionPool.newConnection(CConnectionPool.java:689)
at com.mercury.optane.core.db.CConnectionPool.tryToGetConnection(CConnectionPool.java:491)
at com.mercury.optane.core.db.CConnectionPool.getConnection(CConnectionPool.java:316)
        wrapped in com.mercury.optane.core.db.CTdDbException: Failed to obtain a connection to schema '世纪龙_测试管理_db'
at com.mercury.optane.core.db.CConnectionPool.getConnection(CConnectionPool.java:344)
at com.mercury.optane.core.db.CConnectionManager.getNotTransactedConnection(CConnectionManager.java:299)
at com.mercury.optane.core.db.CConnectionManager.getConnection(CConnectionManager.java:264)
at com.mercury.optane.core.db.CAbsStatement.<init>(CAbsStatement.java:76)
at com.mercury.optane.core.db.CTdPreparedStatement.<init>(CTdPreparedStatement.java:129)
at com.mercury.optane.core.db.CTdPreparedStatement.<init>(CTdPreparedStatement.java:124)
at com.mercury.optane.core.db.spring.JDBCTemplate$AbstractPreparedStatementCreator.create(JDBCTemplate.java:616)
at com.mercury.optane.core.db.spring.JDBCTemplate.executeQuery(JDBCTemplate.java:553)
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.td.tdserver.directory.CDataConst.loadData(CDataConst.java:67)
at com.mercury.td.tdserver.directory.CDataConst.reload(CDataConst.java:219)
at com.mercury.optane.core.directory.CAbsDbReloadableDirectoryItem.reloadIfNeeded(CAbsDbReloadableDirectoryItem.java:119)
at com.mercury.optane.core.directory.CAbsReloadableDirectory.getDirectoryItem(CAbsReloadableDirectory.java:32)
at com.mercury.td.tdserver.directory.CDataConstDirectory.getDataConstValue(CDataConstDirectory.java:84)
at com.mercury.td.tdserver.directory.CTdProject.loadDBDirectory(CTdProject.java:1065)
at com.mercury.td.tdserver.directory.CTdProject.loadAllProjectProperties(CTdProject.java:1134)
        wrapped in com.mercury.optane.core.CTdException: Failed to load properties of project '世纪龙::测试管理'
at com.mercury.td.tdserver.directory.CTdProject.loadAllProjectProperties(CTdProject.java:1145)
at com.mercury.td.tdserver.directory.CTdProject.<init>(CTdProject.java:174)
at com.mercury.td.tdserver.directory.CProjectsDirectory.getProjectInfoFromDomSrv(CProjectsDirectory.java:203)
at com.mercury.td.tdserver.directory.CProjectsDirectory.getItem(CProjectsDirectory.java:115)
        wrapped in com.mercury.optane.core.CTdException: Failed to find project 测试管理 in domain 世纪龙
at com.mercury.td.tdserver.directory.CProjectsDirectory.getItem(CProjectsDirectory.java:131)
at com.mercury.td.tdserver.api.logics.CConnectionLogic.connectProject(CConnectionLogic.java:182)
        wrapped in com.mercury.optane.core.CTdException: Failed to connect user 'liuyan' to project 测试管理 in domain 世纪龙
at com.mercury.td.tdserver.api.logics.CConnectionLogic.connectProject(CConnectionLogic.java:217)
at com.mercury.td.web.server.CTdServlet.redirectConnectProject(CTdServlet.java:357)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
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 Connect Project
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)

lyron

这个问题真的没人知道吗？

lyron

再次顶起

lyron

看来真是没人知道啊

qfeng

td有很多表的字段和qc的有不小的差别，直接还原肯定有问题的

zhongling520

标结构不同，不能直接还原，你可以使用QC的迁移工具呗

lyron

好的 谢谢两位

james.zhong

搞不明白，QC有迁移工具为什么不用！