[jira] [Created] (OFBIZ-4263) "linkParty" service throwing error "ERROR: update or delete on table "party_role" violates foreign key constraint "prdstrrle_prle" on table "product_store_role"
Locked
[jira] [Created] (OFBIZ-4263) "linkParty" service throwing error "ERROR: update or delete on table "party_role" violates foreign key constraint "prdstrrle_prle" on table "product_store_role"
 
|
"linkParty" 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 Priority: Minor Fix For: Release Branch 10.04, SVN trunk -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira |
[jira] [Updated] (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 ] Amit Sharma updated OFBIZ-4263: ------------------------------- Description: 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] Summary: "linkPartyRecord" service throwing error "ERROR: update or delete on table "party_role" violates foreign key constraint "prdstrrle_prle" on table "product_store_role" (was: "linkParty" service throwing error "ERROR: update or delete on table "party_role" violates foreign key constraint "prdstrrle_prle" on table "product_store_role") > "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 > Priority: Minor > Fix For: Release Branch 10.04, SVN trunk > > > 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 |
[jira] [Updated] (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"
|
|
In reply to this post by Nicolas Malin (Jira)
[ https://issues.apache.org/jira/browse/OFBIZ-4263?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Amit Sharma updated OFBIZ-4263: ------------------------------- Attachment: OFBIZ-4263.patch Here is the patch for the same. -- Amit > "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 > 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 |
[jira] [Assigned] (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"
|
|
In reply to this post by Nicolas Malin (Jira)
[ https://issues.apache.org/jira/browse/OFBIZ-4263?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ashish Vijaywargiya reassigned OFBIZ-4263: ------------------------------------------ Assignee: Ashish Vijaywargiya > "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 |
[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"
|
|
In reply to this post by Nicolas Malin (Jira)
[ 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 |
[jira] [Commented] (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"
|
|
In reply to this post by Nicolas Malin (Jira)
[ https://issues.apache.org/jira/browse/OFBIZ-4263?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13024764#comment-13024764 ] Amit Sharma commented on OFBIZ-4263: ------------------------------------ Thanks Ashish! -- Amit > "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 |
«
Return to OFBiz - Dev
|
1 view|%1 views
| Free forum by Nabble | Edit this page |