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
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.
