[ https://issues.apache.org/jira/browse/OFBIZ-686?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14213486#comment-14213486 ]
Deepak Dixit commented on OFBIZ-686: ------------------------------------ IMO we can close this issue, and I am also not able to regenerate issue. Field size 60 is sufficient for keyword kind of thing. > Key violation when generating WorkEffortKeywords > ------------------------------------------------ > > Key: OFBIZ-686 > URL: https://issues.apache.org/jira/browse/OFBIZ-686 > Project: OFBiz > Issue Type: Bug > Components: workeffort > Reporter: Leon Torres > Priority: Minor > > When I try creating a work effort content using createWorkEffortContent > service, I get the following error, > 2007-02-05 11:28:07,826 (http-0.0.0.0-8443-Processor4) [ > CallObjectMethod.java:166:ERROR] > ---- exception report > ---------------------------------------------------------- > Method in call method operation threw an exception > Exception: org.ofbiz.entity.GenericEntityException > Message: Exception while inserting the following entity: > [GenericEntity:WorkEffortKeyword][createdStamp,2007-02-05 > 11:28:07.775(java.sql.Timestamp)][createdTxStamp,2007-02-05 > 11:28:06.751(java.sql.Timestamp)][keyword,host=false&loc=myevite&brand=evite&enum=70&transactionid=1089079009&tile=1089079009&subid=false&site=evite&adsize=1x1&pagepos=118(java.lang.String)][lastUpdatedStamp,2007-02-05 > 11:28:07.775(java.sql.Timestamp)][lastUpdatedTxStamp,2007-02-05 > 11:28:06.751(java.sql.Timestamp)][relevancyWeight,1(java.lang.Long)][workEffortId,10116(java.lang.String)] > (while inserting: [GenericEntity:WorkEffortKeyword][createdStamp,2007-02-05 > 11:28:07.775(java.sql.Timestamp)][createdTxStamp,2007-02-05 > 11:28:06.751(java.sql.Timestamp)][keyword,host=false&loc=myevite&brand=evite&enum=70&transactionid=1089079009&tile=1089079009&subid=false&site=evite&adsize=1x1&pagepos=118(java.lang.String)][lastUpdatedStamp,2007-02-05 > 11:28:07.775(java.sql.Timestamp)][lastUpdatedTxStamp,2007-02-05 > 11:28:06.751(java.sql.Timestamp)][relevancyWeight,1(java.lang.Long)][workEffortId,10116(java.lang.String)] > (SQL Exception while executing the following:INSERT INTO WORK_EFFORT_KEYWORD > (WORK_EFFORT_ID, KEYWORD, RELEVANCY_WEIGHT, LAST_UPDATED_STAMP, > LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, > ?, ?, ?) (Duplicate key or integrity constraint violation message from > server: "Duplicate entry > '10116-host=false&loc=myevite&brand=evite&enum=70&transactionid=1' for key > 1"))) > ---- stack trace > --------------------------------------------------------------- > org.ofbiz.entity.GenericEntityException: Exception while inserting the > following entity: [GenericEntity:WorkEffortKeyword][createdStamp,2007-02-05 > 11:28:07.775(java.sql.Timestamp)][createdTxStamp,2007-02-05 > 11:28:06.751(java.sql.Timestamp)][keyword,host=false&loc=myevite&brand=evite&enum=70&transactionid=1089079009&tile=1089079009&subid=false&site=evite&adsize=1x1&pagepos=118(java.lang.String)][lastUpdatedStamp,2007-02-05 > 11:28:07.775(java.sql.Timestamp)][lastUpdatedTxStamp,2007-02-05 > 11:28:06.751(java.sql.Timestamp)][relevancyWeight,1(java.lang.Long)][workEffortId,10116(java.lang.String)] > (while inserting: [GenericEntity:WorkEffortKeyword][createdStamp,2007-02-05 > 11:28:07.775(java.sql.Timestamp)][createdTxStamp,2007-02-05 > 11:28:06.751(java.sql.Timestamp)][keyword,host=false&loc=myevite&brand=evite&enum=70&transactionid=1089079009&tile=1089079009&subid=false&site=evite&adsize=1x1&pagepos=118(java.lang.String)][lastUpdatedStamp,2007-02-05 > 11:28:07.775(java.sql.Timestamp)][lastUpdatedTxStamp,2007-02-05 > 11:28:06.751(java.sql.Timestamp)][relevancyWeight,1(java.lang.Long)][workEffortId,10116(java.lang.String)] > (SQL Exception while executing the following:INSERT INTO WORK_EFFORT_KEYWORD > (WORK_EFFORT_ID, KEYWORD, RELEVANCY_WEIGHT, LAST_UPDATED_STAMP, > LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, > ?, ?, ?) (Duplicate key or integrity constraint violation message from > server: "Duplicate entry > '10116-host=false&loc=myevite&brand=evite&enum=70&transactionid=1' for key > 1"))) > org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:116) > org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:65) > org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:559) > org.ofbiz.entity.GenericDelegator.storeAll(GenericDelegator.java:1097) > org.ofbiz.entity.GenericDelegator.storeAll(GenericDelegator.java:1047) > org.ofbiz.entity.GenericDelegator.storeAll(GenericDelegator.java:1032) > org.ofbiz.workeffort.workeffort.WorkEffortKeywordIndex.indexKeywords(WorkEffortKeywordIndex.java:132) > sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) > java.lang.reflect.Method.invoke(Method.java:324) > org.ofbiz.minilang.method.callops.CallObjectMethod.callMethod(CallObjectMethod.java:138) > org.ofbiz.minilang.method.callops.CallClassMethod.exec(CallClassMethod.java:90) > org.ofbiz.minilang.SimpleMethod.runSubOps(SimpleMethod.java:929) > org.ofbiz.minilang.SimpleMethod.exec(SimpleMethod.java:568) > org.ofbiz.minilang.SimpleMethod.runSimpleMethod(SimpleMethod.java:105) > org.ofbiz.minilang.SimpleMethod.runSimpleService(SimpleMethod.java:87) > org.ofbiz.minilang.SimpleServiceEngine.serviceInvoker(SimpleServiceEngine.java:76) > org.ofbiz.minilang.SimpleServiceEngine.runSync(SimpleServiceEngine.java:51) > org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:340) > org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:211) > org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:113) > org.ofbiz.entityext.eca.EntityEcaAction.runAction(EntityEcaAction.java:92) > org.ofbiz.entityext.eca.EntityEcaRule.eval(EntityEcaRule.java:112) > org.ofbiz.entityext.eca.DelegatorEcaHandler.evalRules(DelegatorEcaHandler.java:85) > org.ofbiz.entity.GenericDelegator.evalEcaRules(GenericDelegator.java:2410) > org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:573) > org.ofbiz.minilang.method.entityops.CreateValue.exec(CreateValue.java:64) > org.ofbiz.minilang.SimpleMethod.runSubOps(SimpleMethod.java:929) > org.ofbiz.minilang.SimpleMethod.exec(SimpleMethod.java:568) > org.ofbiz.minilang.SimpleMethod.runSimpleMethod(SimpleMethod.java:105) > org.ofbiz.minilang.SimpleMethod.runSimpleService(SimpleMethod.java:87) > org.ofbiz.minilang.SimpleServiceEngine.serviceInvoker(SimpleServiceEngine.java:76) > org.ofbiz.minilang.SimpleServiceEngine.runSync(SimpleServiceEngine.java:51) > org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:340) > org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:211) > org.ofbiz.service.group.GroupServiceModel.invoke(GroupServiceModel.java:122) > org.ofbiz.service.group.GroupModel.runAll(GroupModel.java:165) > org.ofbiz.service.group.GroupModel.run(GroupModel.java:130) > org.ofbiz.service.group.ServiceGroupEngine.runSync(ServiceGroupEngine.java:52) > org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:340) > org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:211) > org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:113) > com.opensourcestrategies.crmsfa.content.ContentServices.createContent(ContentServices.java:145) > com.opensourcestrategies.crmsfa.content.ContentServices.createContentForActivity(ContentServices.java:114) > sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) > java.lang.reflect.Method.invoke(Method.java:324) > org.ofbiz.service.engine.StandardJavaEngine.serviceInvoker(StandardJavaEngine.java:91) > org.ofbiz.service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java:53) > org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:340) > org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:211) > org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:113) > org.ofbiz.webapp.event.ServiceEventHandler.invoke(ServiceEventHandler.java:290) > org.ofbiz.webapp.control.RequestHandler.runEvent(RequestHandler.java:409) > org.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:240) > org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:185) > org.ofbiz.webapp.control.ControlServlet.doPost(ControlServlet.java:77) > javax.servlet.http.HttpServlet.service(HttpServlet.java:615) > javax.servlet.http.HttpServlet.service(HttpServlet.java:688) > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) > org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:248) > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) > org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) > org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) > org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) > org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) > org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:541) > org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) > org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869) > org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664) > org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527) > org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80) > org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684) > java.lang.Thread.run(Thread.java:534) -- This message was sent by Atlassian JIRA (v6.3.4#6332)