创建新项目出现错误，应该如何解决？

zzfhncn

创建新项目出现如下错误，应该如何解决？

to create Quality Center project;
Failed to create project 'BBM';
Failed to create new project 'BBM';
Error in writing to table ALL_LISTS;
[Mercury][SQLServer JDBC Driver][SQLServer]不能在具有唯一索引 'AL_FATHER_DESC_LWR_IDX' 的对象 'dbo.ALL_LISTS' 中插入重复键的行。;
Stack Trace:
com.mercury.jdbc.base.BaseBatchUpdateException: [Mercury][SQLServer JDBC Driver][SQLServer]不能在具有唯一索引 'AL_FATHER_DESC_LWR_IDX' 的对象 'dbo.ALL_LISTS' 中插入重复键的行。
at com.mercury.jdbc.sqlserver.SQLServerImplStatement.getBatchRowsAffectedCount(Unknown Source)
at com.mercury.jdbc.base.BasePreparedStatement.executeBatch(Unknown Source)
at com.mercury.optane.core.db.CTdPreparedStatement.executeBatch(CTdPreparedStatement.java:1860)
at com.mercury.optane.core.db.convertor.CDBWriter.executeBatch(CDBWriter.java:613)
at com.mercury.optane.core.db.convertor.CDBWriter.writeData(CDBWriter.java:503)
wrapped in com.mercury.optane.core.CTdException: Error in writing to table ALL_LISTS
at com.mercury.optane.core.db.convertor.CDBWriter.writeData(CDBWriter.java:540)
at com.mercury.optane.core.db.convertor.CDBConvertor.copyTableData(CDBConvertor.java:776)
at com.mercury.optane.core.db.convertor.CDBConvertor.createTable(CDBConvertor.java:723)
at com.mercury.optane.core.db.convertor.CDBConvertor.convert(CDBConvertor.java:671)
at com.mercury.optane.core.db.convertor.CDBConvertor.convert(CDBConvertor.java:636)
at com.mercury.optane.core.db.convertor.CDBConvertor.convertXML2DB(CDBConvertor.java:321)
at com.mercury.optane.core.db.convertor.CDBConvertor.convertXML2DB(CDBConvertor.java:293)
at com.mercury.optane.core.db.convertor.CDBProject.importProject(CDBProject.java:216)
at com.mercury.optane.core.db.convertor.CDBProject.importProject(CDBProject.java:190)
at com.mercury.td.saserver.api.logics.CProjectLogic.createNewTdProject(CProjectLogic.java:4238)
wrapped in com.mercury.optane.core.CTdException: Failed to create new project 'BBM'
at com.mercury.td.saserver.api.logics.CProjectLogic.createNewTdProject(CProjectLogic.java:4249)
at com.mercury.td.saserver.api.logics.CProjectLogic.createProject(CProjectLogic.java:1681)
wrapped in com.mercury.optane.core.CTdException: Failed to create project 'BBM'
at com.mercury.td.saserver.api.logics.CProjectLogic.createProject(CProjectLogic.java:1699)
wrapped in com.mercury.optane.core.CTdException: Failed to create Quality Center project
at com.mercury.td.saserver.api.logics.CProjectLogic.createProject(CProjectLogic.java:1740)
at com.mercury.td.saserver.web.CTdSiteAdminServlet.redirectCreateProject(CTdSiteAdminServlet.java:326)
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 Create 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.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)

fly

是QC？

zzfhncn

原帖由 fly 于 2008-7-29 13:15 发表
是QC？

是的。错误信息是：
to create Quality Center project;
Failed to create project 'BBM';
Failed to create new project 'BBM';
Error in writing to table ALL_LISTS;
[Mercury][SQLServer JDBC Driver][SQLServer]不能在具有唯一索引 'AL_FATHER_DESC_LWR_IDX' 的对象 'dbo.ALL_LISTS' 中插入重复键的行。;