51Testing软件测试论坛

标题: qc中新增bug时提示:不能在对象 'BUG' 中插入重复键。 [打印本页]

作者: 小飞天猪    时间: 2011-1-24 12:27
标题: qc中新增bug时提示:不能在对象 'BUG' 中插入重复键。
qc中新增bug时提示:违反了 PRIMARY KEY 约束 'BG_PRIMARYKEY'。不能在对象 'BUG' 中插入重复键。
哪位知道如何解决呢?
我只是在测试计划中新增了部分模块的操作,以及修改了缺陷的status,别的未做设置···

详细的错误信息如下:
Messages:
Failed to Post Bug;
Cannot create new Defect;
[Mercury][SQLServer JDBC Driver][SQLServer]违反了 PRIMARY KEY 约束 'BG_PRIMARYKEY'。不能在对象 'BUG' 中插入重复键。;

Stack Trace:
java.sql.SQLException: [Mercury][SQLServer JDBC Driver][SQLServer]违反了 PRIMARY KEY 约束 'BG_PRIMARYKEY'。不能在对象 'BUG' 中插入重复键。
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.TDSRPCRequest.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.BasePreparedStatement.postImplExecute(Unknown Source)
at com.mercury.jdbc.base.BaseStatement.commonExecute(Unknown Source)
at com.mercury.jdbc.base.BaseStatement.executeUpdateInternal(Unknown Source)
at com.mercury.jdbc.base.BasePreparedStatement.executeUpdate(Unknown Source)
at com.mercury.optane.core.db.CTdPreparedStatement.executeUpdate(CTdPreparedStatement.java:524)
at com.mercury.td.tdserver.api.logics.CBugLogic.createBug(CBugLogic.java:286)
        wrapped in com.mercury.optane.core.CTdException: Cannot create new Defect
at com.mercury.td.tdserver.api.logics.CBugLogic.createBug(CBugLogic.java:294)
at com.mercury.td.tdserver.api.logics.CBugLogic.postBug(CBugLogic.java:156)
at com.mercury.td.web.server.CTdServlet.redirectPostBug(CTdServlet.java:439)
at sun.reflect.GeneratedMethodAccessor85.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 Post Bug
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)
作者: archonwang    时间: 2011-1-28 14:53
数据库问题,建议重新刷新下QC bug表的bug_id序列




欢迎光临 51Testing软件测试论坛 (http://bbs.51testing.com/) Powered by Discuz! X3.2