You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ofbiz.apache.org by "David E. Jones (JIRA)" <ji...@apache.org> on 2007/04/16 20:52:15 UTC
[jira] Closed: (OFBIZ-895) Failure in findByCondition operation for
entity [PartyContactWithPurpose] in run-install on mysql
[ 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.