You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ofbiz.apache.org by "Ashish Vijaywargiya (JIRA)" <ji...@apache.org> on 2014/11/15 10:43:34 UTC
[jira] [Assigned] (OFBIZ-686) Key violation when generating
WorkEffortKeywords
[ https://issues.apache.org/jira/browse/OFBIZ-686?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Ashish Vijaywargiya reassigned OFBIZ-686:
-----------------------------------------
Assignee: Ashish Vijaywargiya
> 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
> Assignee: Ashish Vijaywargiya
> 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)