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 2011/04/25 11:41:05 UTC
[jira] [Closed] (OFBIZ-4263) "linkPartyRecord" service throwing
error "ERROR: update or delete on table "party_role" violates foreign key
constraint "prdstrrle_prle" on table "product_store_role"
[ https://issues.apache.org/jira/browse/OFBIZ-4263?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Ashish Vijaywargiya closed OFBIZ-4263.
--------------------------------------
Resolution: Fixed
Fixed at trunk r1096441 and releasebranch10.04 r1096442.
Thanks Amit.
--
Ashish
> "linkPartyRecord" service throwing error "ERROR: update or delete on table "party_role" violates foreign key constraint "prdstrrle_prle" on table "product_store_role"
> ----------------------------------------------------------------------------------------------------------------------------------------------------------------------
>
> Key: OFBIZ-4263
> URL: https://issues.apache.org/jira/browse/OFBIZ-4263
> Project: OFBiz
> Issue Type: Bug
> Components: party
> Reporter: Amit Sharma
> Assignee: Ashish Vijaywargiya
> Priority: Minor
> Fix For: Release Branch 10.04, SVN trunk
>
> Attachments: OFBIZ-4263.patch
>
>
> When we link party from https://localhost:8443/partymgr/control/linkparty?partyId=10000 screen.
> It is showing error on console :-
> 2011-04-25 13:22:37,720 (http-0.0.0.0-38443-3) [ GenericDelegator.java:1162:ERROR]
> ---- exception report ----------------------------------------------------------
> Failure in removeByCondition operation for entity [PartyRole]: org.ofbiz.entity.GenericDataSourceException: Generic Entity Exception occured in deleteByCondition (SQL Exception while executing the following:DELETE FROM public.PARTY_ROLE WHERE (PARTY_ID = '10001') (ERROR: update or delete on table "party_role" violates foreign key constraint "prdstrrle_prle" on table "product_store_role"
> Detail: Key (party_id,role_type_id)=(10001,CUSTOMER) is still referenced from table "product_store_role".)). Rolling back transaction.
> Exception: org.ofbiz.entity.GenericDataSourceException
> Message: Generic Entity Exception occured in deleteByCondition (SQL Exception while executing the following:DELETE FROM public.PARTY_ROLE WHERE (PARTY_ID = '10001') (ERROR: update or delete on table "party_role" violates foreign key constraint "prdstrrle_prle" on table "product_store_role"
> Detail: Key (party_id,role_type_id)=(10001,CUSTOMER) is still referenced from table "product_store_role".))
> ---- cause ---------------------------------------------------------------------
> Exception: org.ofbiz.entity.GenericDataSourceException
> Message: SQL Exception while executing the following:DELETE FROM public.PARTY_ROLE WHERE (PARTY_ID = '10001') (ERROR: update or delete on table "party_role" violates foreign key constraint "prdstrrle_prle" on table "product_store_role"
> Detail: Key (party_id,role_type_id)=(10001,CUSTOMER) is still referenced from table "product_store_role".)
> ---- cause ---------------------------------------------------------------------
> Exception: org.postgresql.util.PSQLException
> Message: ERROR: update or delete on table "party_role" violates foreign key constraint "prdstrrle_prle" on table "product_store_role"
> Detail: Key (party_id,role_type_id)=(10001,CUSTOMER) is still referenced from table "product_store_role".
> ---- stack trace ---------------------------------------------------------------
> org.postgresql.util.PSQLException: ERROR: update or delete on table "party_role" violates foreign key constraint "prdstrrle_prle" on table "product_store_role"
> Detail: Key (party_id,role_type_id)=(10001,CUSTOMER) is still referenced from table "product_store_role".
> org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1592)
> org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1327)
> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:192)
> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:451)
> org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:350)
> org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:304)
> org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
> org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
> org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:419)
> org.ofbiz.entity.datasource.GenericDAO.deleteByCondition(GenericDAO.java:1189)
> org.ofbiz.entity.datasource.GenericDAO.deleteByCondition(GenericDAO.java:1163)
> org.ofbiz.entity.datasource.GenericHelperDAO.removeByCondition(GenericHelperDAO.java:160)
> org.ofbiz.entity.GenericDelegator.removeByCondition(GenericDelegator.java:1151)
> org.ofbiz.entity.GenericDelegator.removeByAnd(GenericDelegator.java:1119)
> org.ofbiz.entity.GenericDelegator.removeByAnd(GenericDelegator.java:1104)
> org.ofbiz.party.party.PartyServices.linkParty(PartyServices.java:1612)
> 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:597)
> org.ofbiz.service.engine.StandardJavaEngine.serviceInvoker(StandardJavaEngine.java:100)
> org.ofbiz.service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java:57)
> org.ofbiz.service.ModelServiceReader$GenericInvokerImpl.runSync(ModelServiceReader.java:761)
> _$gen.file_58$.home.ofbiz.ofbiz_95$dev.ofbiz10.applications.party.servicedef.services_46$xml_35$linkPartyRecord.runSync(file:applications/party/servicedef/services.xml#linkPartyRecord:232)
> org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:399)
> org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:226)
> org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:167)
> org.ofbiz.webapp.event.ServiceEventHandler.invoke(ServiceEventHandler.java:336)
> org.ofbiz.webapp.control.RequestHandler.runEvent(RequestHandler.java:636)
> org.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:382)
> org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:227)
> org.ofbiz.webapp.control.ControlServlet.doPost(ControlServlet.java:90)
> javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
> javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:269)
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
> org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:555)
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
> org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:852)
> org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
> org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
> java.lang.Thread.run(Thread.java:619)
> --------------------------------------------------------------------------------
> 2011-04-25 13:22:37,720 (http-0.0.0.0-38443-3) [ TransactionUtil.java:344:INFO ] [TransactionUtil.rollback] transaction rolled back
> 2011-04-25 13:22:37,721 (http-0.0.0.0-38443-3) [ TransactionUtil.java:269:WARN ] [TransactionUtil.commit] Not committing transaction, status is No Transaction (6)
> 2011-04-25 13:22:37,721 (http-0.0.0.0-38443-3) [ PartyServices.java:1614:WARN ]
> ---- exception report ----------------------------------------------------------
> Exception: org.ofbiz.entity.GenericDataSourceException
> Message: Generic Entity Exception occured in deleteByCondition (SQL Exception while executing the following:DELETE FROM public.PARTY_ROLE WHERE (PARTY_ID = '10001') (ERROR: update or delete on table "party_role" violates foreign key constraint "prdstrrle_prle" on table "product_store_role"
> Detail: Key (party_id,role_type_id)=(10001,CUSTOMER) is still referenced from table "product_store_role".))
> ---- cause ---------------------------------------------------------------------
> Exception: org.ofbiz.entity.GenericDataSourceException
> Message: SQL Exception while executing the following:DELETE FROM public.PARTY_ROLE WHERE (PARTY_ID = '10001') (ERROR: update or delete on table "party_role" violates foreign key constraint "prdstrrle_prle" on table "product_store_role"
> Detail: Key (party_id,role_type_id)=(10001,CUSTOMER) is still referenced from table "product_store_role".)
> ---- cause ---------------------------------------------------------------------
> Exception: org.postgresql.util.PSQLException
> Message: ERROR: update or delete on table "party_role" violates foreign key constraint "prdstrrle_prle" on table "product_store_role"
> Detail: Key (party_id,role_type_id)=(10001,CUSTOMER) is still referenced from table "product_store_role".
> ---- stack trace ---------------------------------------------------------------
> org.postgresql.util.PSQLException: ERROR: update or delete on table "party_role" violates foreign key constraint "prdstrrle_prle" on table "product_store_role"
> Detail: Key (party_id,role_type_id)=(10001,CUSTOMER) is still referenced from table "product_store_role".
> org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1592)
> org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1327)
> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:192)
> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:451)
> org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:350)
> org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:304)
> org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
> org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
> org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:419)
> org.ofbiz.entity.datasource.GenericDAO.deleteByCondition(GenericDAO.java:1189)
> org.ofbiz.entity.datasource.GenericDAO.deleteByCondition(GenericDAO.java:1163)
> org.ofbiz.entity.datasource.GenericHelperDAO.removeByCondition(GenericHelperDAO.java:160)
> org.ofbiz.entity.GenericDelegator.removeByCondition(GenericDelegator.java:1151)
> org.ofbiz.entity.GenericDelegator.removeByAnd(GenericDelegator.java:1119)
> org.ofbiz.entity.GenericDelegator.removeByAnd(GenericDelegator.java:1104)
> org.ofbiz.party.party.PartyServices.linkParty(PartyServices.java:1612)
> 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:597)
> org.ofbiz.service.engine.StandardJavaEngine.serviceInvoker(StandardJavaEngine.java:100)
> org.ofbiz.service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java:57)
> org.ofbiz.service.ModelServiceReader$GenericInvokerImpl.runSync(ModelServiceReader.java:761)
> _$gen.file_58$.home.ofbiz_95$dev.ofbiz10.applications.party.servicedef.services_46$xml_35$linkPartyRecord.runSync(file:/home/ofbiz10/applications/party/servicedef/services.xml#linkPartyRecord:232)
> org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:399)
> org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:226)
> org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:167)
> org.ofbiz.webapp.event.ServiceEventHandler.invoke(ServiceEventHandler.java:336)
> org.ofbiz.webapp.control.RequestHandler.runEvent(RequestHandler.java:636)
> org.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:382)
> org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:227)
> org.ofbiz.webapp.control.ControlServlet.doPost(ControlServlet.java:90)
> javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
> javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:269)
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
> org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:555)
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
> org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:852)
> org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
> org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
> java.lang.Thread.run(Thread.java:619)
> --------------------------------------------------------------------------------
> 2011-04-25 13:22:37,745 (http-0.0.0.0-38443-3) [ ServiceDispatcher.java:599:INFO ] Sync service [partymgr/linkPartyRecord] finished in [404] milliseconds
> 2011-04-25 13:22:37,745 (http-0.0.0.0-38443-3) [ RequestHandler.java:637:INFO ] Ran Event [service:#linkPartyRecord] from [request], result is [success]
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira