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