[ https://issues.apache.org/jira/browse/OFBIZ-895?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
David E. Jones closed OFBIZ-895. -------------------------------- Resolution: Fixed Fix Version/s: SVN trunk Assignee: David E. Jones Thanks for reporting this, and thanks to the others who reported it as well and it is fixed in SVN rev 529354. > Failure in findByCondition operation for entity [PartyContactWithPurpose] in > run-install on mysql > ------------------------------------------------------------------------------------------------- > > Key: OFBIZ-895 > URL: https://issues.apache.org/jira/browse/OFBIZ-895 > Project: OFBiz (The Open for Business Project) > Issue Type: Sub-task > Components: accounting > Affects Versions: SVN trunk > Environment: MySql, probably hsql too > Reporter: Krzysztof Podejma > Assigned To: David E. Jones > Fix For: SVN trunk > > > this is log from "./ant run-install " > on derby all works well > 2007-04-16 09:48:58,046 (main) [ GenericDelegator.java:1701:ERROR] > ---- exception report > ---------------------------------------------------------- > Failure in findByCondition operation for entity [PartyContactWithPurpose]: > org.ofbiz.entity.GenericDataSourceException: SQL Exception while executing > the following:SELECT CM.CONTACT_MECH_ID AS CONTACT_MECH_ID, PCM.PARTY_ID AS > PARTY_ID, PCMP.CONTACT_MECH_PURPOSE_TYPE_ID AS CONTACT_MECH_PURPOSE_TYPE_ID, > PCM.FROM_DATE AS CONTACT_FROM_DATE, PCM.THRU_DATE AS CONTACT_THRU_DATE, > PCMP.FROM_DATE AS PURPOSE_FROM_DATE, PCMP.THRU_DATE AS PURPOSE_THRU_DATE, > CM.CONTACT_MECH_TYPE_ID AS CONTACT_MECH_TYPE_ID, CM.INFO_STRING AS > INFO_STRING, PCM.COMMENTS AS COMMENTS, PCM.EXTENSION AS EXTENSION, > PCM.ALLOW_SOLICITATION AS ALLOW_SOLICITATION, PT.DESCRIPTION AS > PURPOSE_DESCRIPTION FROM PARTY_CONTACT_MECH_PURPOSE PCMP INNER JOIN > CONTACT_MECH CM ON PCMP.CONTACT_MECH_ID = CM.CONTACT_MECH_ID INNER JOIN > PARTY_CONTACT_MECH PCM ON CM.CONTACT_MECH_ID = PCM.CONTACT_MECH_ID INNER JOIN > CONTACT_MECH_PURPOSE_TYPE PT ON PCMP.CONTACT_MECH_PURPOSE_TYPE_ID = > PT.CONTACT_MECH_PURPOSE_TYPE_ID WHERE (PARTY_ID = ? AND > CONTACT_MECH_PURPOSE_TYPE_ID = ? AND CONTACT_MECH_TYPE_ID = ? AND INFO_STRING > IS NOT NULL) ORDER BY PURPOSE_FROM_DATE DESC (Column 'PARTY_ID' in where > clause is ambiguous). Rolling back transaction. > Exception: org.ofbiz.entity.GenericDataSourceException > Message: SQL Exception while executing the following:SELECT > CM.CONTACT_MECH_ID AS CONTACT_MECH_ID, PCM.PARTY_ID AS PARTY_ID, > PCMP.CONTACT_MECH_PURPOSE_TYPE_ID AS CONTACT_MECH_PURPOSE_TYPE_ID, > PCM.FROM_DATE AS CONTACT_FROM_DATE, PCM.THRU_DATE AS CONTACT_THRU_DATE, > PCMP.FROM_DATE AS PURPOSE_FROM_DATE, PCMP.THRU_DATE AS PURPOSE_THRU_DATE, > CM.CONTACT_MECH_TYPE_ID AS CONTACT_MECH_TYPE_ID, CM.INFO_STRING AS > INFO_STRING, PCM.COMMENTS AS COMMENTS, PCM.EXTENSION AS EXTENSION, > PCM.ALLOW_SOLICITATION AS ALLOW_SOLICITATION, PT.DESCRIPTION AS > PURPOSE_DESCRIPTION FROM PARTY_CONTACT_MECH_PURPOSE PCMP INNER JOIN > CONTACT_MECH CM ON PCMP.CONTACT_MECH_ID = CM.CONTACT_MECH_ID INNER JOIN > PARTY_CONTACT_MECH PCM ON CM.CONTACT_MECH_ID = PCM.CONTACT_MECH_ID INNER JOIN > CONTACT_MECH_PURPOSE_TYPE PT ON PCMP.CONTACT_MECH_PURPOSE_TYPE_ID = > PT.CONTACT_MECH_PURPOSE_TYPE_ID WHERE (PARTY_ID = ? AND > CONTACT_MECH_PURPOSE_TYPE_ID = ? AND CONTACT_MECH_TYPE_ID = ? AND INFO_STRING > IS NOT NULL) ORDER BY PURPOSE_FROM_DATE DESC (Column 'PARTY_ID' in where > clause is ambiguous) > ---- stack trace > --------------------------------------------------------------- > org.ofbiz.entity.GenericDataSourceException: SQL Exception while executing > the following:SELECT CM.CONTACT_MECH_ID AS CONTACT_MECH_ID, PCM.PARTY_ID AS > PARTY_ID, PCMP.CONTACT_MECH_PURPOSE_TYPE_ID AS CONTACT_MECH_PURPOSE_TYPE_ID, > PCM.FROM_DATE AS CONTACT_FROM_DATE, PCM.THRU_DATE AS CONTACT_THRU_DATE, > PCMP.FROM_DATE AS PURPOSE_FROM_DATE, PCMP.THRU_DATE AS PURPOSE_THRU_DATE, > CM.CONTACT_MECH_TYPE_ID AS CONTACT_MECH_TYPE_ID, CM.INFO_STRING AS > INFO_STRING, PCM.COMMENTS AS COMMENTS, PCM.EXTENSION AS EXTENSION, > PCM.ALLOW_SOLICITATION AS ALLOW_SOLICITATION, PT.DESCRIPTION AS > PURPOSE_DESCRIPTION FROM PARTY_CONTACT_MECH_PURPOSE PCMP INNER JOIN > CONTACT_MECH CM ON PCMP.CONTACT_MECH_ID = CM.CONTACT_MECH_ID INNER JOIN > PARTY_CONTACT_MECH PCM ON CM.CONTACT_MECH_ID = PCM.CONTACT_MECH_ID INNER JOIN > CONTACT_MECH_PURPOSE_TYPE PT ON PCMP.CONTACT_MECH_PURPOSE_TYPE_ID = > PT.CONTACT_MECH_PURPOSE_TYPE_ID WHERE (PARTY_ID = ? AND > CONTACT_MECH_PURPOSE_TYPE_ID = ? AND CONTACT_MECH_TYPE_ID = ? AND INFO_STRING > IS NOT NULL) ORDER BY PURPOSE_FROM_DATE DESC (Column 'PARTY_ID' in where > clause is ambiguous) > org.ofbiz.entity.jdbc.SQLProcessor.executeQuery(SQLProcessor.java:399) > org.ofbiz.entity.datasource.GenericDAO.selectListIteratorByCondition(GenericDAO.java:767) > org.ofbiz.entity.datasource.GenericHelperDAO.findListIteratorByCondition(GenericHelperDAO.java:143) > org.ofbiz.entity.GenericDelegator.findListIteratorByCondition(GenericDelegator.java:1793) > org.ofbiz.entity.GenericDelegator.findByCondition(GenericDelegator.java:1693) > org.ofbiz.entity.GenericDelegator.findByCondition(GenericDelegator.java:1672) > com.opensourcestrategies.crmsfa.party.PartyHelper.getPrimaryEmailForParty(PartyHelper.java:461) > com.opensourcestrategies.crmsfa.common.NotificationServices.sendCrmNotificationEmails(NotificationServices.java:104) > 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:91) > org.ofbiz.service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java:53) > org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:336) > org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:211) > org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:136) > com.opensourcestrategies.crmsfa.accounts.AccountsServices.sendAccountResponsibilityNotificationEmails(AccountsServices.java:293) > 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:91) > org.ofbiz.service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java:53) > org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:336) > org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:211) > org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:136) > org.ofbiz.service.eca.ServiceEcaAction.runAction(ServiceEcaAction.java:104) > org.ofbiz.service.eca.ServiceEcaRule.eval(ServiceEcaRule.java:138) > org.ofbiz.service.eca.ServiceEcaUtil.evalRules(ServiceEcaUtil.java:165) > org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:452) > org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:211) > org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:136) > com.opensourcestrategies.crmsfa.party.PartyServices.autoAssignParty(PartyServices.java:576) > 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:91) > org.ofbiz.service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java:53) > org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:336) > org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:211) > org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:136) > org.ofbiz.entityext.eca.EntityEcaAction.runAction(EntityEcaAction.java:92) > org.ofbiz.entityext.eca.EntityEcaRule.eval(EntityEcaRule.java:112) > org.ofbiz.entityext.eca.DelegatorEcaHandler.evalRules(DelegatorEcaHandler.java:85) > org.ofbiz.entity.GenericDelegator.evalEcaRules(GenericDelegator.java:2410) > org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:573) > org.ofbiz.entity.GenericDelegator.storeAll(GenericDelegator.java:1097) > org.ofbiz.entity.util.EntitySaxReader.writeValues(EntitySaxReader.java:256) > org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:238) > org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:195) > org.ofbiz.entity.util.EntityDataLoader.loadData(EntityDataLoader.java:223) > org.ofbiz.entityext.data.EntityDataLoadContainer.start(EntityDataLoadContainer.java:266) > org.ofbiz.base.container.ContainerLoader.start(ContainerLoader.java:80) > org.ofbiz.base.start.Start.startStartLoaders(Start.java:263) > org.ofbiz.base.start.Start.startServer(Start.java:314) > org.ofbiz.base.start.Start.start(Start.java:318) > org.ofbiz.base.start.Start.main(Start.java:404) > com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException: Column > 'PARTY_ID' in where clause is ambiguous > ..... > 2007-04-16 09:49:39,265 (main) [EntityDataLoadContainer.java:286:INFO ] The > following errors occured in the data load: > 2007-04-16 09:49:39,265 (main) [EntityDataLoadContainer.java:289:INFO ] > [install.loadData]: Error loading XML Resource > "file:/.../applications/accounting/data/DemoOrganizationData.xml"; Error was: > A transaction error occurred reading data > 2007-04-16 09:49:39,265 (main) [EntityDataLoadContainer.java:289:INFO ] > [install.loadData]: Error loading XML Resource > "file:/../applications/accounting/data/PaymentsInvoices.xml"; Error was: A > transaction error occurred reading data > 2007-04-16 09:49:39,296 (main) [EntityDataLoadContainer.java:289:INFO ] > [install.loadData]: Error loading XML Resource > "file:/.../applications/ecommerce/data/DemoProduct.xml"; Error was: A > transaction error occurred reading data > 2007-04-16 09:49:39,296 (main) [EntityDataLoadContainer.java:289:INFO ] > [install.loadData]: Error loading XML Resource > "file:/.../applications/ecommerce/data/DemoSurvey.xml"; Error was: A > transaction error occurred reading data > 2007-04-16 09:49:39,328 (main) [EntityDataLoadContainer.java:289:INFO ] > [install.loadData]: Error loading XML Resource > "file:/.../applications/ecommerce/data/DemoRentalShipping.xml"; Error was: A > transaction error occurred reading data > 2007-04-16 09:49:39,328 (main) [EntityDataLoadContainer.java:289:INFO ] > [install.loadData]: Error loading XML Resource > "file:/.../applications/ecommerce/data/DemoShipping.xml"; Error was: A > transaction error occurred reading data > 2007-04-16 09:49:39,343 (main) [EntityDataLoadContainer.java:289:INFO ] > [install.loadData]: Error loading XML Resource > "file:/.../applications/ecommerce/data/DemoConfigurator.xml"; Error was: A > transaction error occurred reading data > 2007-04-16 09:49:39,343 (main) [EntityDataLoadContainer.java:289:INFO ] > [install.loadData]: Error loading XML Resource > "file:/.../applications/ecommerce/data/DemoRentalProduct.xml"; Error was: A > transaction error occurred reading data > 2007-04-16 09:49:39,359 (main) [EntityDataLoadContainer.java:289:INFO ] > [install.loadData]: Error loading XML Resource > "file:/.../applications/ecommerce/data/DemoTaxAuthority.xml"; Error was: A > transaction error occurred reading data > 2007-04-16 09:49:39,359 (main) [EntityDataLoadContainer.java:289:INFO ] > [install.loadData]: Error loading XML Resource > "file:/.../applications/ecommerce/data/DemoOrderPeopleData.xml"; Error was: A > transaction error occurred reading data > 2007-04-16 09:49:39,390 (main) [EntityDataLoadContainer.java:289:INFO ] > [install.loadData]: Error loading XML Resource > "file:/.../applications/ecommerce/data/DemoMarketing.xml"; Error was: A > transaction error occurred reading data > 2007-04-16 09:49:39,390 (main) [EntityDataLoadContainer.java:289:INFO ] > [install.loadData]: Error loading XML Resource > "file:/.../applications/ecommerce/data/DemoPurchasing.xml"; Error was: A > transaction error occurred reading data > 2007-04-16 09:49:39,406 (main) [EntityDataLoadContainer.java:289:INFO ] > [install.loadData]: Error loading XML Resource > "file:/.../applications/ecommerce/data/DemoStandardCosting.xml"; Error was: A > transaction error occurred reading data > 2007-04-16 09:49:39,406 (main) [EntityDataLoadContainer.java:289:INFO ] > [install.loadData]: Error loading XML Resource > "file:/.../applications/ecommerce/data/DemoStoreGiftCertificateSettings.xml"; > Error was: A transaction error occurred reading data > 2007-04-16 09:49:39,421 (main) [EntityDataLoadContainer.java:289:INFO ] > [install.loadData]: Error loading XML Resource > "file:/.../applications/ecommerce/data/DemoFinAccount.xml"; Error was: A > transaction error occurred reading data > 2007-04-16 09:49:39,421 (main) [EntityDataLoadContainer.java:289:INFO ] > [install.loadData]: Error loading XML Resource > "file:/.../applications/ecommerce/data/DemoProductI18nData.xml"; Error was: A > transaction error occurred reading data > 2007-04-16 09:49:39,453 (main) [EntityDataLoadContainer.java:289:INFO ] > [install.loadData]: Error loading XML Resource > "file:/.../applications/ecommerce/data/DemoProductCategoriesI18nData.xml"; > Error was: A transaction error occurred reading data > 2007-04-16 09:49:39,453 (main) [EntityDataLoadContainer.java:289:INFO ] > [install.loadData]: Error loading XML Resource > "file:/.../specialpurpose/pos/data/DemoRetail.xml"; Error was: A transaction > error occurred reading data > 2007-04-16 09:49:39,468 (main) [EntityDataLoadContainer.java:289:INFO ] > [install.loadData]: Error loading XML Resource > "file:/.../hot-deploy/crmsfa/data/CRMSFADemoData.xml"; Error was: A > transaction error occurred reading data > 2007-04-16 09:49:39,468 (main) [EntityDataLoadContainer.java:289:INFO ] > [install.loadData]: Error loading XML Resource > "file:/...hot-deploy/crmsfa/data/CRMSFADemoCatalogRequest.xml"; Error was: A > transaction error occurred reading data > 2007-04-16 09:49:39,484 (main) [EntityDataLoadContainer.java:289:INFO ] > [install.loadData]: Error loading XML Resource > "file:/.../hot-deploy/financials/data/DemoOrganizations.xml"; Error was: A > transaction error occurred reading data > 2007-04-16 09:49:39,484 (main) [EntityDataLoadContainer.java:289:INFO ] > [install.loadData]: Error loading XML Resource > "file:/../hot-deploy/financials/data/DemoOrgChartOfAccount.xml"; Error was: A > transaction error occurred reading data > 2007-04-16 09:49:39,515 (main) [EntityDataLoadContainer.java:289:INFO ] > [install.loadData]: Error loading XML Resource > "file:/.../hot-deploy/financials/data/DemoOrgBalanceSheet.xml"; Error was: A > transaction error occurred reading data -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.