You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ofbiz.apache.org by "Scott Gray (JIRA)" <ji...@apache.org> on 2007/03/26 07:36:32 UTC
[jira] Commented: (OFBIZ-686) Key violation when generating
WorkEffortKeywords
[ https://issues.apache.org/jira/browse/OFBIZ-686?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12484024 ]
Scott Gray commented on OFBIZ-686:
----------------------------------
Hi Leon
>From the looks of things the problem is that the keyword is longer than 60 characters so it gets truncated going into the database, then when the code checks again later for an existing keyword it doesn't find one because it is comparing the original keyword to the truncated one.
I can fix that easily enough but it would be nice to know which field the keyword is coming from so that we can perhaps look at removing that field from the keyword generation if need be.
> Key violation when generating WorkEffortKeywords
> ------------------------------------------------
>
> Key: OFBIZ-686
> URL: https://issues.apache.org/jira/browse/OFBIZ-686
> Project: OFBiz (The Open for Business Project)
> 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 is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.