You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ofbiz.apache.org by "Krzysztof Podejma (JIRA)" <ji...@apache.org> on 2007/04/16 10:16:15 UTC
[jira] Created: (OFBIZ-895) Failure in findByCondition operation
for entity [PartyContactWithPurpose] in run-install on mysql
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.
[jira] Closed: (OFBIZ-895) Failure in findByCondition operation for
entity [PartyContactWithPurpose] in run-install on mysql
Posted by "David E. Jones (JIRA)" <ji...@apache.org>.
[ 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.
[jira] Commented: (OFBIZ-895) Failure in findByCondition operation
for entity [PartyContactWithPurpose] in run-install on mysql
Posted by "David Garrett (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OFBIZ-895?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12489147 ]
David Garrett commented on OFBIZ-895:
-------------------------------------
I have the same problem for an initial install.
The problem appears to be MySql is not accepting the column alias in the where clause as per the simplified select statement below. In my case the problem comes from a findByCondition on a view ...Failure in findByCondition operation for entity [ContentAssocDataResourceViewTo].
simplified SQL:
SELECT
CA.CONTENT_ID AS aaa,
CA.CONTENT_ASSOC_TYPE_ID AS abc,
CA.FROM_DATE AS ddd
FROM CONTENT_ASSOC CA
WHERE
abc ='XXX'
AND CA.CONTENT_ID = 'XXX'
ORDER BY ddd DESC;
The (different) detailed error I receive is as below
2007-04-17 01:34:01,291 (main) [ EntitySaxReader.java:194:INFO ] Beginning import from URL: file:/C:/DG2/dev/ofbiz-master-cced/applications/ecommerce/data/DemoProduct.xml
2007-04-17 01:34:01,291 (main) [ EntitySaxReader.java:232:INFO ] Transaction Timeout set to 2 hours (7200 seconds)
2007-04-17 01:34:01,502 (main) [ EntityEcaRule.java:111:INFO ] Running Entity ECA Service: indexProductKeywords, triggered by rule on Entity: Product
2007-04-17 01:34:01,552 (main) [ AbstractEngine.java:75 :INFO ] Loaded Service Locations : [main-rmi=rmi://localhost:1099/RMIDispatcher, main-http=http://localhost:8080/webtools/control/httpService, entity-sync-rmi=rmi://localhost:1099/RMIDispatcher, entity-sync-http=http://localhost:8080/webtools/control/httpService, rita-rmi=rmi://localhost:1099/RMIDispatcher, eedcc-test=http://localhost:8080/webtools/control/httpService]
2007-04-17 01:34:02,052 (main) [ UtilXml.java:243:DEBUG] XML Read 0.4s: file:/C:/DG2/dev/ofbiz-master-cced/applications/product/script/org/ofbiz/product/product/ProductServices.xml
2007-04-17 01:34:02,753 (main) [ ServiceDispatcher.java:459:DEBUG] Sync service [entity-default/indexProductKeywords] finished in [1231] milliseconds
2007-04-17 01:34:02,753 (main) [ EntityEcaRule.java:111:INFO ] Running Entity ECA Service: indexProductKeywords, triggered by rule on Entity: Product
2007-04-17 01:34:02,814 (main) [ EntityEcaRule.java:111:INFO ] Running Entity ECA Service: indexProductKeywords, triggered by rule on Entity: Product
2007-04-17 01:34:02,854 (main) [ EntityEcaRule.java:111:INFO ] Running Entity ECA Service: indexProductKeywords, triggered by rule on Entity: Product
2007-04-17 01:34:02,914 (main) [ EntityEcaRule.java:111:INFO ] Running Entity ECA Service: indexProductKeywords, triggered by rule on Entity: ProductContent
2007-04-17 01:34:03,134 (main) [ GenericDelegator.java:1701:ERROR]
---- exception report ----------------------------------------------------------
Failure in findByCondition operation for entity [ContentAssocDataResourceViewTo]: org.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT CA.CONTENT_ID AS CONTENT_ID_START, CA.CONTENT_ID AS CA_CONTENT_ID, CA.CONTENT_ID_TO AS CA_CONTENT_ID_TO, CA.CONTENT_ASSOC_TYPE_ID AS CA_CONTENT_ASSOC_TYPE_ID, CA.FROM_DATE AS CA_FROM_DATE, CA.THRU_DATE AS CA_THRU_DATE, CA.CONTENT_ASSOC_PREDICATE_ID AS CA_CONTENT_ASSOC_PREDICATE_ID, CA.DATA_SOURCE_ID AS CA_DATA_SOURCE_ID, CA.SEQUENCE_NUM AS CA_SEQUENCE_NUM, CA.MAP_KEY AS CA_MAP_KEY, CA.UPPER_COORDINATE AS CA_UPPER_COORDINATE, CA.LEFT_COORDINATE AS CA_LEFT_COORDINATE, CA.CREATED_DATE AS CA_CREATED_DATE, CA.CREATED_BY_USER_LOGIN AS CA_CREATED_BY_USER_LOGIN, CA.LAST_MODIFIED_DATE AS CA_LAST_MODIFIED_DATE, CA.LAST_MODIFIED_BY_USER_LOGIN AS CA_LAST_MODIFIED_BY_USER_LOGIN, CO.CONTENT_ID AS CONTENT_ID, CO.CONTENT_TYPE_ID AS CONTENT_TYPE_ID, CO.OWNER_CONTENT_ID AS OWNER_CONTENT_ID, CO.DECORATOR_CONTENT_ID AS DECORATOR_CONTENT_ID, CO.INSTANCE_OF_CONTENT_ID AS INSTANCE_OF_CONTENT_ID, CO.DATA_RESOURCE_ID AS DATA_RESOURCE_ID, CO.TEMPLATE_DATA_RESOURCE_ID AS TEMPLATE_DATA_RESOURCE_ID, CO.DATA_SOURCE_ID AS DATA_SOURCE_ID, CO.STATUS_ID AS STATUS_ID, CO.PRIVILEGE_ENUM_ID AS PRIVILEGE_ENUM_ID, CO.SERVICE_NAME AS SERVICE_NAME, CO.CONTENT_NAME AS CONTENT_NAME, CO.DESCRIPTION AS DESCRIPTION, CO.LOCALE_STRING AS LOCALE_STRING, CO.MIME_TYPE_ID AS MIME_TYPE_ID, CO.CHARACTER_SET_ID AS CHARACTER_SET_ID, CO.CHILD_LEAF_COUNT AS CHILD_LEAF_COUNT, CO.CHILD_BRANCH_COUNT AS CHILD_BRANCH_COUNT, CO.CREATED_DATE AS CREATED_DATE, CO.CREATED_BY_USER_LOGIN AS CREATED_BY_USER_LOGIN, CO.LAST_MODIFIED_DATE AS LAST_MODIFIED_DATE, CO.LAST_MODIFIED_BY_USER_LOGIN AS LAST_MODIFIED_BY_USER_LOGIN, DR.DATA_RESOURCE_ID AS DR_DATA_RESOURCE_ID, DR.DATA_RESOURCE_TYPE_ID AS DR_DATA_RESOURCE_TYPE_ID, DR.DATA_TEMPLATE_TYPE_ID AS DR_DATA_TEMPLATE_TYPE_ID, DR.DATA_CATEGORY_ID AS DR_DATA_CATEGORY_ID, DR.DATA_SOURCE_ID AS DR_DATA_SOURCE_ID, DR.STATUS_ID AS DR_STATUS_ID, DR.DATA_RESOURCE_NAME AS DR_DATA_RESOURCE_NAME, DR.LOCALE_STRING AS DR_LOCALE_STRING, DR.MIME_TYPE_ID AS DR_MIME_TYPE_ID, DR.CHARACTER_SET_ID AS DR_CHARACTER_SET_ID, DR.OBJECT_INFO AS DR_OBJECT_INFO, DR.RELATED_DETAIL_ID AS DR_RELATED_DETAIL_ID, DR.IS_PUBLIC AS DR_IS_PUBLIC, DR.CREATED_DATE AS DR_CREATED_DATE, DR.CREATED_BY_USER_LOGIN AS DR_CREATED_BY_USER_LOGIN, DR.LAST_MODIFIED_DATE AS DR_LAST_MODIFIED_DATE, DR.LAST_MODIFIED_BY_USER_LOGIN AS DR_LAST_MODIFIED_BY_USER_LOGIN FROM CONTENT_ASSOC CA LEFT OUTER JOIN CONTENT CO ON CA.CONTENT_ID_TO = CO.CONTENT_ID LEFT OUTER JOIN DATA_RESOURCE DR ON CO.DATA_RESOURCE_ID = DR.DATA_RESOURCE_ID WHERE (CA_CONTENT_ASSOC_TYPE_ID = ? AND CONTENT_ID_START = ?) ORDER BY CA_FROM_DATE DESC (Unknown column 'CA_CONTENT_ASSOC_TYPE_ID' in 'where clause'). Rolling back transaction.
Exception: org.ofbiz.entity.GenericDataSourceException
Message: SQL Exception while executing the following:SELECT CA.CONTENT_ID AS CONTENT_ID_START, CA.CONTENT_ID AS CA_CONTENT_ID, CA.CONTENT_ID_TO AS CA_CONTENT_ID_TO, CA.CONTENT_ASSOC_TYPE_ID AS CA_CONTENT_ASSOC_TYPE_ID, CA.FROM_DATE AS CA_FROM_DATE, CA.THRU_DATE AS CA_THRU_DATE, CA.CONTENT_ASSOC_PREDICATE_ID AS CA_CONTENT_ASSOC_PREDICATE_ID, CA.DATA_SOURCE_ID AS CA_DATA_SOURCE_ID, CA.SEQUENCE_NUM AS CA_SEQUENCE_NUM, CA.MAP_KEY AS CA_MAP_KEY, CA.UPPER_COORDINATE AS CA_UPPER_COORDINATE, CA.LEFT_COORDINATE AS CA_LEFT_COORDINATE, CA.CREATED_DATE AS CA_CREATED_DATE, CA.CREATED_BY_USER_LOGIN AS CA_CREATED_BY_USER_LOGIN, CA.LAST_MODIFIED_DATE AS CA_LAST_MODIFIED_DATE, CA.LAST_MODIFIED_BY_USER_LOGIN AS CA_LAST_MODIFIED_BY_USER_LOGIN, CO.CONTENT_ID AS CONTENT_ID, CO.CONTENT_TYPE_ID AS CONTENT_TYPE_ID, CO.OWNER_CONTENT_ID AS OWNER_CONTENT_ID, CO.DECORATOR_CONTENT_ID AS DECORATOR_CONTENT_ID, CO.INSTANCE_OF_CONTENT_ID AS INSTANCE_OF_CONTENT_ID, CO.DATA_RESOURCE_ID AS DATA_RESOURCE_ID, CO.TEMPLATE_DATA_RESOURCE_ID AS TEMPLATE_DATA_RESOURCE_ID, CO.DATA_SOURCE_ID AS DATA_SOURCE_ID, CO.STATUS_ID AS STATUS_ID, CO.PRIVILEGE_ENUM_ID AS PRIVILEGE_ENUM_ID, CO.SERVICE_NAME AS SERVICE_NAME, CO.CONTENT_NAME AS CONTENT_NAME, CO.DESCRIPTION AS DESCRIPTION, CO.LOCALE_STRING AS LOCALE_STRING, CO.MIME_TYPE_ID AS MIME_TYPE_ID, CO.CHARACTER_SET_ID AS CHARACTER_SET_ID, CO.CHILD_LEAF_COUNT AS CHILD_LEAF_COUNT, CO.CHILD_BRANCH_COUNT AS CHILD_BRANCH_COUNT, CO.CREATED_DATE AS CREATED_DATE, CO.CREATED_BY_USER_LOGIN AS CREATED_BY_USER_LOGIN, CO.LAST_MODIFIED_DATE AS LAST_MODIFIED_DATE, CO.LAST_MODIFIED_BY_USER_LOGIN AS LAST_MODIFIED_BY_USER_LOGIN, DR.DATA_RESOURCE_ID AS DR_DATA_RESOURCE_ID, DR.DATA_RESOURCE_TYPE_ID AS DR_DATA_RESOURCE_TYPE_ID, DR.DATA_TEMPLATE_TYPE_ID AS DR_DATA_TEMPLATE_TYPE_ID, DR.DATA_CATEGORY_ID AS DR_DATA_CATEGORY_ID, DR.DATA_SOURCE_ID AS DR_DATA_SOURCE_ID, DR.STATUS_ID AS DR_STATUS_ID, DR.DATA_RESOURCE_NAME AS DR_DATA_RESOURCE_NAME, DR.LOCALE_STRING AS DR_LOCALE_STRING, DR.MIME_TYPE_ID AS DR_MIME_TYPE_ID, DR.CHARACTER_SET_ID AS DR_CHARACTER_SET_ID, DR.OBJECT_INFO AS DR_OBJECT_INFO, DR.RELATED_DETAIL_ID AS DR_RELATED_DETAIL_ID, DR.IS_PUBLIC AS DR_IS_PUBLIC, DR.CREATED_DATE AS DR_CREATED_DATE, DR.CREATED_BY_USER_LOGIN AS DR_CREATED_BY_USER_LOGIN, DR.LAST_MODIFIED_DATE AS DR_LAST_MODIFIED_DATE, DR.LAST_MODIFIED_BY_USER_LOGIN AS DR_LAST_MODIFIED_BY_USER_LOGIN FROM CONTENT_ASSOC CA LEFT OUTER JOIN CONTENT CO ON CA.CONTENT_ID_TO = CO.CONTENT_ID LEFT OUTER JOIN DATA_RESOURCE DR ON CO.DATA_RESOURCE_ID = DR.DATA_RESOURCE_ID WHERE (CA_CONTENT_ASSOC_TYPE_ID = ? AND CONTENT_ID_START = ?) ORDER BY CA_FROM_DATE DESC (Unknown column 'CA_CONTENT_ASSOC_TYPE_ID' in 'where clause')
---- stack trace ---------------------------------------------------------------
org.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT CA.CONTENT_ID AS CONTENT_ID_START, CA.CONTENT_ID AS CA_CONTENT_ID, CA.CONTENT_ID_TO AS CA_CONTENT_ID_TO, CA.CONTENT_ASSOC_TYPE_ID AS CA_CONTENT_ASSOC_TYPE_ID, CA.FROM_DATE AS CA_FROM_DATE, CA.THRU_DATE AS CA_THRU_DATE, CA.CONTENT_ASSOC_PREDICATE_ID AS CA_CONTENT_ASSOC_PREDICATE_ID, CA.DATA_SOURCE_ID AS CA_DATA_SOURCE_ID, CA.SEQUENCE_NUM AS CA_SEQUENCE_NUM, CA.MAP_KEY AS CA_MAP_KEY, CA.UPPER_COORDINATE AS CA_UPPER_COORDINATE, CA.LEFT_COORDINATE AS CA_LEFT_COORDINATE, CA.CREATED_DATE AS CA_CREATED_DATE, CA.CREATED_BY_USER_LOGIN AS CA_CREATED_BY_USER_LOGIN, CA.LAST_MODIFIED_DATE AS CA_LAST_MODIFIED_DATE, CA.LAST_MODIFIED_BY_USER_LOGIN AS CA_LAST_MODIFIED_BY_USER_LOGIN, CO.CONTENT_ID AS CONTENT_ID, CO.CONTENT_TYPE_ID AS CONTENT_TYPE_ID, CO.OWNER_CONTENT_ID AS OWNER_CONTENT_ID, CO.DECORATOR_CONTENT_ID AS DECORATOR_CONTENT_ID, CO.INSTANCE_OF_CONTENT_ID AS INSTANCE_OF_CONTENT_ID, CO.DATA_RESOURCE_ID AS DATA_RESOURCE_ID, CO.TEMPLATE_DATA_RESOURCE_ID AS TEMPLATE_DATA_RESOURCE_ID, CO.DATA_SOURCE_ID AS DATA_SOURCE_ID, CO.STATUS_ID AS STATUS_ID, CO.PRIVILEGE_ENUM_ID AS PRIVILEGE_ENUM_ID, CO.SERVICE_NAME AS SERVICE_NAME, CO.CONTENT_NAME AS CONTENT_NAME, CO.DESCRIPTION AS DESCRIPTION, CO.LOCALE_STRING AS LOCALE_STRING, CO.MIME_TYPE_ID AS MIME_TYPE_ID, CO.CHARACTER_SET_ID AS CHARACTER_SET_ID, CO.CHILD_LEAF_COUNT AS CHILD_LEAF_COUNT, CO.CHILD_BRANCH_COUNT AS CHILD_BRANCH_COUNT, CO.CREATED_DATE AS CREATED_DATE, CO.CREATED_BY_USER_LOGIN AS CREATED_BY_USER_LOGIN, CO.LAST_MODIFIED_DATE AS LAST_MODIFIED_DATE, CO.LAST_MODIFIED_BY_USER_LOGIN AS LAST_MODIFIED_BY_USER_LOGIN, DR.DATA_RESOURCE_ID AS DR_DATA_RESOURCE_ID, DR.DATA_RESOURCE_TYPE_ID AS DR_DATA_RESOURCE_TYPE_ID, DR.DATA_TEMPLATE_TYPE_ID AS DR_DATA_TEMPLATE_TYPE_ID, DR.DATA_CATEGORY_ID AS DR_DATA_CATEGORY_ID, DR.DATA_SOURCE_ID AS DR_DATA_SOURCE_ID, DR.STATUS_ID AS DR_STATUS_ID, DR.DATA_RESOURCE_NAME AS DR_DATA_RESOURCE_NAME, DR.LOCALE_STRING AS DR_LOCALE_STRING, DR.MIME_TYPE_ID AS DR_MIME_TYPE_ID, DR.CHARACTER_SET_ID AS DR_CHARACTER_SET_ID, DR.OBJECT_INFO AS DR_OBJECT_INFO, DR.RELATED_DETAIL_ID AS DR_RELATED_DETAIL_ID, DR.IS_PUBLIC AS DR_IS_PUBLIC, DR.CREATED_DATE AS DR_CREATED_DATE, DR.CREATED_BY_USER_LOGIN AS DR_CREATED_BY_USER_LOGIN, DR.LAST_MODIFIED_DATE AS DR_LAST_MODIFIED_DATE, DR.LAST_MODIFIED_BY_USER_LOGIN AS DR_LAST_MODIFIED_BY_USER_LOGIN FROM CONTENT_ASSOC CA LEFT OUTER JOIN CONTENT CO ON CA.CONTENT_ID_TO = CO.CONTENT_ID LEFT OUTER JOIN DATA_RESOURCE DR ON CO.DATA_RESOURCE_ID = DR.DATA_RESOURCE_ID WHERE (CA_CONTENT_ASSOC_TYPE_ID = ? AND CONTENT_ID_START = ?) ORDER BY CA_FROM_DATE DESC (Unknown column 'CA_CONTENT_ASSOC_TYPE_ID' in 'where clause')
org.ofbiz.entity.jdbc.SQLProcessor.executeQuery(SQLProcessor.java:399)
etc ...
> 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.