[已解决]QC10项目导入导出问题

dabeixiong

把项目从QC10中导出成QCB文件，之后在另一台服务器上根据这个QCB文件创建项目时出错，提示"Failed To Import Project"。

我看了下错误信息是创建表test中有个字段超长引起，可检查字段后发现并未超长啊，请问哪位遇到过这种情况？

详细信息如下：

Messages:
Failed to Import Project;
Failed to create Quality Center project;
Failed to create project 'zjywpt';
Failed to import new project 'zjywpt';
Error in writing to table TEST;
Failed SQL: /* ~~QC */ INSERT INTO default_zjywpt_db.TEST

(TS_TEST_VERSION,TS_TEST_ID,TS_NAME,TS_STEPS,TS_PATH,TS_SUBJECT,TS_STATUS,TS_RESPONSIBLE,TS_CREATION_DATE,TS_DESCRIPTION,TS_TYPE,TS_TIMEO

UT,TS_ATTACHMENT,TS_RUNTIME_DATA,TS_USER_01,TS_USER_02,TS_USER_03,TS_USER_04,TS_USER_05,TS_USER_06,TS_USER_07,TS_USER_08,TS_USER_09,TS_US

ER_10,TS_USER_11,TS_USER_12,TS_USER_HR_01,TS_USER_HR_02,TS_USER_HR_03,TS_USER_HR_04,TS_USER_HR_05,TS_USER_HR_06,TS_ESTIMATE_DEVTIME,TS_TE

ST_VER_STAMP,TS_EXEC_STATUS,TS_TEMPLATE,TS_STEP_PARAM,TS_VTS,TS_VC_CUR_VER,TS_USER_13,TS_USER_14,TS_USER_15,TS_USER_16,TS_USER_17,TS_USER

_18,TS_USER_19,TS_USER_20,TS_USER_21,TS_USER_22,TS_USER_23,TS_USER_24,TS_TEXT_SYNC,TS_DEV_COMMENTS,TS_VC_USER_NAME,TS_VC_DATE,TS_VC_TIME,

TS_VC_COMMENTS,TS_VC_STATUS,TS_VC_START_AUDIT_ACTION_ID,TS_VC_END_AUDIT_ACTION_ID,TS_VC_VERSION_NUMBER,TS_BPTA_CHANGE_DETECTED,TS_BASE_TE

ST_ID) VALUES(, , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ,

)
[Mercury][Oracle JDBC Driver][Oracle]ORA-12899: value too large for column "DEFAULT_ZJYWPT_DB"."TEST"."TS_USER_07" (actual: 372, maximum:

250)
;
failed to import project
Stack Trace:
java.sql.SQLException: Failed SQL: /* ~~QC */ INSERT INTO default_zjywpt_db.TEST

(TS_TEST_VERSION,TS_TEST_ID,TS_NAME,TS_STEPS,TS_PATH,TS_SUBJECT,TS_STATUS,TS_RESPONSIBLE,TS_CREATION_DATE,TS_DESCRIPTION,TS_TYPE,TS_TIMEO

UT,TS_ATTACHMENT,TS_RUNTIME_DATA,TS_USER_01,TS_USER_02,TS_USER_03,TS_USER_04,TS_USER_05,TS_USER_06,TS_USER_07,TS_USER_08,TS_USER_09,TS_US

ER_10,TS_USER_11,TS_USER_12,TS_USER_HR_01,TS_USER_HR_02,TS_USER_HR_03,TS_USER_HR_04,TS_USER_HR_05,TS_USER_HR_06,TS_ESTIMATE_DEVTIME,TS_TE

ST_VER_STAMP,TS_EXEC_STATUS,TS_TEMPLATE,TS_STEP_PARAM,TS_VTS,TS_VC_CUR_VER,TS_USER_13,TS_USER_14,TS_USER_15,TS_USER_16,TS_USER_17,TS_USER

_18,TS_USER_19,TS_USER_20,TS_USER_21,TS_USER_22,TS_USER_23,TS_USER_24,TS_TEXT_SYNC,TS_DEV_COMMENTS,TS_VC_USER_NAME,TS_VC_DATE,TS_VC_TIME,

TS_VC_COMMENTS,TS_VC_STATUS,TS_VC_START_AUDIT_ACTION_ID,TS_VC_END_AUDIT_ACTION_ID,TS_VC_VERSION_NUMBER,TS_BPTA_CHANGE_DETECTED,TS_BASE_TE

ST_ID) VALUES(, , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ,

)
[Mercury][Oracle JDBC Driver][Oracle]ORA-12899: value too large for column "DEFAULT_ZJYWPT_DB"."TEST"."TS_USER_07" (actual: 372, maximum:

250)

at com.mercury.optane.core.db.CAbsStatement.createSQLExceptionWithSQLStatement(CAbsStatement.java:178)
at com.mercury.optane.core.db.CAbsStatement.doExecute(CAbsStatement.java:161)
at com.mercury.optane.core.db.CAbsStatement.doExecute(CAbsStatement.java:122)
at com.mercury.optane.core.db.CTdPreparedStatement.executeBatch(CTdPreparedStatement.java:991)
at com.mercury.optane.core.db.convertor.CDBWriter.executeBatch(CDBWriter.java:648)
at com.mercury.optane.core.db.convertor.CDBWriter.writeData(CDBWriter.java:526)
        wrapped in com.mercury.optane.core.CTdException: Error in writing to table TEST
at com.mercury.optane.core.db.convertor.CDBWriter.writeData(CDBWriter.java:568)
at com.mercury.optane.core.db.convertor.CDBForRawWriter.writeData(CDBForRawWriter.java:39)
at com.mercury.optane.core.db.convertor.CDBConvertor.copyTableData(CDBConvertor.java:755)
at com.mercury.optane.core.db.convertor.CDBConvertor.createTable(CDBConvertor.java:700)
at com.mercury.optane.core.db.convertor.CDBConvertor.convert(CDBConvertor.java:644)
at com.mercury.optane.core.db.convertor.CDBConvertor.convert(CDBConvertor.java:611)
at com.mercury.optane.core.db.convertor.CDBConvertor.convertRaw2DB(CDBConvertor.java:370)
at com.mercury.optane.core.db.convertor.CDBConvertor.convertRaw2DB(CDBConvertor.java:340)
at com.mercury.optane.core.db.convertor.CDBProject.importRawProject(CDBProject.java:182)
at com.mercury.td.saserver.api.logics.CProjectLogic.importProject(CProjectLogic.java:5131)
        wrapped in com.mercury.optane.core.CTdException: Failed to import new project 'zjywpt'
at com.mercury.td.saserver.api.logics.CProjectLogic.importProject(CProjectLogic.java:5144)
at com.mercury.td.saserver.api.logics.CProjectLogic.createProject(CProjectLogic.java:1871)
        wrapped in com.mercury.optane.core.CTdException: Failed to create project 'zjywpt'
at com.mercury.td.saserver.api.logics.CProjectLogic.createProject(CProjectLogic.java:1890)
        wrapped in com.mercury.optane.core.CTdException: Failed to create Quality Center project
at com.mercury.td.saserver.api.logics.CProjectLogic.createProject(CProjectLogic.java:1932)
at com.mercury.td.saserver.requests.ImportProject.execute(ImportProject.java:30)
at com.mercury.optane.core.web.RequestsDispatcher.execute(RequestsDispatcher.java:91)
        wrapped in com.mercury.optane.core.CTdException: Failed to Import Project
at com.mercury.optane.core.web.RequestsDispatcher.execute(RequestsDispatcher.java:98)
at com.mercury.td.web.CAbsServlet.executeFunction(CAbsServlet.java:436)
at com.mercury.td.web.CAbsServlet.processRequest(CAbsServlet.java:428)
at com.mercury.td.web.CAbsServlet.doPost(CAbsServlet.java:324)
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 com.hp.qc.core.utils.gzipfilter.GZIPFilter.doFilter(GZIPFilter.java:30)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
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)

dabeixiong

行了～找到原因了...俩数据库字符集不一样我了个去