You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by "Vince M. Clark" <vc...@globalera.com> on 2007/12/08 16:49:58 UTC
Re: Postgres OLAP
Brendan
The olap feature is pretty new and I know very little about it. The second <group-map> for org.ofbiz.olap used to not exist in entityconfig.xm.. I always set both group-maps to the same datasource and everything seems to work fine.
----- Original Message -----
From: "Brendan Vogt" <br...@gmail.com>
To: user@ofbiz.apache.org
Sent: Saturday, December 8, 2007 8:52:49 AM (GMT-0700) America/Chihuahua
Subject: Postgres OLAP
Hi,
Please check the following piece of code:
<delegator name="default" entity-model-reader="main"
entity-group-reader="main" entity-eca-reader="main"
distributed-cache-clear-enabled="false">
<group-map group-name="org.ofbiz" datasource-name="localpostgres"/>
<group-map group-name="org.ofbiz.olap" datasource-name="localderby"/>
</delegator>
I am using Postgres database. I just want to know what I need to do about
<group-map group-name="org.ofbiz.olap" datasource-name="localderby"/>??
Should I leave it as is? Or should I change it? Does Postgres support
OLAP? Can this be implemented at a later stage?
Brendan
RE: Disable OLAP component
Posted by Christopher L <cl...@hotmail.com>.
YEAR_MONTH is a reserved keyword in MySql.
I believe I already fixed this issue and it has been applied in rev 593448.
https://issues.apache.org/jira/browse/OFBIZ-1391
"svn up" should help you. Wipe your DB and run "ant run-install" afterward.
Chris Lombardi
> Date: Mon, 10 Dec 2007 15:57:17 -0800
> From: bjfree@free-man.net
> To: user@ofbiz.apache.org
> Subject: Re: Disable OLAP component
>
> remove
> <load-component component-location="bi"/>
> from the specialpurpose/component-load.xml
>
> Calum Miller sent the following on 12/10/2007 3:33 PM:
> > Hi,
> >
> > Can I disable the OLAP component by just removing the "org.ofbiz.olap"
> > entry from the entityengine.xml?
> >
> > <delegator name="default" entity-model-reader="main"
> > entity-group-reader="main" entity-eca-reader="main"
> > distributed-cache-clear-enabled="false">
> > <group-map group-name="org.ofbiz" datasource-name="localmysql"/>
> > <group-map group-name="org.ofbiz.olap"
> > datasource-name="localmysql"/>
> > </delegator>
> >
> > I am using mysql and get the following error when "Quick Ship Entire
> > Order" is pressed, which I think may be related to the OLAP module.
> >
> > The Following Errors Occurred:
> >
> > Error trying to begin transaction, could not process method: The current
> > transaction is marked for rollback, not beginning a new transaction and
> > aborting current operation; the rollbackOnly was caused by: Failure in
> > findByCondition operation for entity [DateDimension]:
> > org.ofbiz.entity.GenericDataSourceException: SQL Exception while
> > executing the following:SELECT DIMENSION_ID, DATE_VALUE, DESCRIPTION,
> > DAY_NAME, DAY_OF_MONTH, DAY_OF_YEAR, MONTH_NAME, MONTH_OF_YEAR,
> > YEAR_NAME, WEEK_OF_MONTH, WEEK_OF_YEAR, YEAR_MONTH_DAY, YEAR_MONTH,
> > WEEKDAY_TYPE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP,
> > CREATED_TX_STAMP FROM DATE_DIMENSION WHERE (DATE_VALUE = ?) ORDER BY
> > CREATED_TX_STAMP DESC (Syntax error or access violation message from
> > server: "You have an error in your SQL syntax; check the manual that
> > corresponds to your MySQL server version for the right syntax to use
> > near 'YEAR_MONTH, WEEKDAY_TYPE, LAST_UPDATED_STAMP,
> > LAST_UPDATED_TX_STAMP, CREATED_STA' at line 1"). Rolling back
> > transaction.org.ofbiz.entity.GenericDataSourceException: SQL Exception
> > while executing the following:SELECT DIMENSION_ID, DATE_VALUE,
> > DESCRIPTION, DAY_NAME, DAY_OF_MONTH, DAY_OF_YEAR, MONTH_NAME,
> > MONTH_OF_YEAR, YEAR_NAME, WEEK_OF_MONTH, WEEK_OF_YEAR, YEAR_MONTH_DAY,
> > YEAR_MONTH, WEEKDAY_TYPE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP,
> > CREATED_STAMP, CREATED_TX_STAMP FROM DATE_DIMENSION WHERE (DATE_VALUE =
> > ?) ORDER BY CREATED_TX_STAMP DESC (Syntax error or access violation
> > message from server: "You have an error in your SQL syntax; check the
> > manual that corresponds to your MySQL server version for the right
> > syntax to use near 'YEAR_MONTH, WEEKDAY_TYPE, LAST_UPDATED_STAMP,
> > LAST_UPDATED_TX_STAMP, CREATED_STA' at line 1") (SQL Exception while
> > executing the following:SELECT DIMENSION_ID, DATE_VALUE, DESCRIPTION,
> > DAY_NAME, DAY_OF_MONTH, DAY_OF_YEAR, MONTH_NAME, MONTH_OF_YEAR,
> > YEAR_NAME, WEEK_OF_MONTH, WEEK_OF_YEAR, YEAR_MONTH_DAY, YEAR_MONTH,
> > WEEKDAY_TYPE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP,
> > CREATED_TX_STAMP FROM DATE_DIMENSION WHERE (DATE_VALUE = ?) ORDER BY
> > CREATED_TX_STAMP DESC (Syntax error or access violation message from
> > server: "You have an error in your SQL syntax; check the manual that
> > corresponds to your MySQL server version for the right syntax to use
> > near 'YEAR_MONTH, WEEKDAY_TYPE, LAST_UPDATED_STAMP,
> > LAST_UPDATED_TX_STAMP, CREATED_STA' at line 1")) calling service
> > updateShipment in createShipmentForFacilityAndShipGroup
> >
> >
> >
> >
> >
> >
>
Re: Disable OLAP component
Posted by BJ Freeman <bj...@free-man.net>.
remove
<load-component component-location="bi"/>
from the specialpurpose/component-load.xml
Calum Miller sent the following on 12/10/2007 3:33 PM:
> Hi,
>
> Can I disable the OLAP component by just removing the "org.ofbiz.olap"
> entry from the entityengine.xml?
>
> <delegator name="default" entity-model-reader="main"
> entity-group-reader="main" entity-eca-reader="main"
> distributed-cache-clear-enabled="false">
> <group-map group-name="org.ofbiz" datasource-name="localmysql"/>
> <group-map group-name="org.ofbiz.olap"
> datasource-name="localmysql"/>
> </delegator>
>
> I am using mysql and get the following error when "Quick Ship Entire
> Order" is pressed, which I think may be related to the OLAP module.
>
> The Following Errors Occurred:
>
> Error trying to begin transaction, could not process method: The current
> transaction is marked for rollback, not beginning a new transaction and
> aborting current operation; the rollbackOnly was caused by: Failure in
> findByCondition operation for entity [DateDimension]:
> org.ofbiz.entity.GenericDataSourceException: SQL Exception while
> executing the following:SELECT DIMENSION_ID, DATE_VALUE, DESCRIPTION,
> DAY_NAME, DAY_OF_MONTH, DAY_OF_YEAR, MONTH_NAME, MONTH_OF_YEAR,
> YEAR_NAME, WEEK_OF_MONTH, WEEK_OF_YEAR, YEAR_MONTH_DAY, YEAR_MONTH,
> WEEKDAY_TYPE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP,
> CREATED_TX_STAMP FROM DATE_DIMENSION WHERE (DATE_VALUE = ?) ORDER BY
> CREATED_TX_STAMP DESC (Syntax error or access violation message from
> server: "You have an error in your SQL syntax; check the manual that
> corresponds to your MySQL server version for the right syntax to use
> near 'YEAR_MONTH, WEEKDAY_TYPE, LAST_UPDATED_STAMP,
> LAST_UPDATED_TX_STAMP, CREATED_STA' at line 1"). Rolling back
> transaction.org.ofbiz.entity.GenericDataSourceException: SQL Exception
> while executing the following:SELECT DIMENSION_ID, DATE_VALUE,
> DESCRIPTION, DAY_NAME, DAY_OF_MONTH, DAY_OF_YEAR, MONTH_NAME,
> MONTH_OF_YEAR, YEAR_NAME, WEEK_OF_MONTH, WEEK_OF_YEAR, YEAR_MONTH_DAY,
> YEAR_MONTH, WEEKDAY_TYPE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP,
> CREATED_STAMP, CREATED_TX_STAMP FROM DATE_DIMENSION WHERE (DATE_VALUE =
> ?) ORDER BY CREATED_TX_STAMP DESC (Syntax error or access violation
> message from server: "You have an error in your SQL syntax; check the
> manual that corresponds to your MySQL server version for the right
> syntax to use near 'YEAR_MONTH, WEEKDAY_TYPE, LAST_UPDATED_STAMP,
> LAST_UPDATED_TX_STAMP, CREATED_STA' at line 1") (SQL Exception while
> executing the following:SELECT DIMENSION_ID, DATE_VALUE, DESCRIPTION,
> DAY_NAME, DAY_OF_MONTH, DAY_OF_YEAR, MONTH_NAME, MONTH_OF_YEAR,
> YEAR_NAME, WEEK_OF_MONTH, WEEK_OF_YEAR, YEAR_MONTH_DAY, YEAR_MONTH,
> WEEKDAY_TYPE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP,
> CREATED_TX_STAMP FROM DATE_DIMENSION WHERE (DATE_VALUE = ?) ORDER BY
> CREATED_TX_STAMP DESC (Syntax error or access violation message from
> server: "You have an error in your SQL syntax; check the manual that
> corresponds to your MySQL server version for the right syntax to use
> near 'YEAR_MONTH, WEEKDAY_TYPE, LAST_UPDATED_STAMP,
> LAST_UPDATED_TX_STAMP, CREATED_STA' at line 1")) calling service
> updateShipment in createShipmentForFacilityAndShipGroup
>
>
>
>
>
>
Disable OLAP component
Posted by Calum Miller <ca...@yahoo.com>.
Hi,
Can I disable the OLAP component by just removing the "org.ofbiz.olap"
entry from the entityengine.xml?
<delegator name="default" entity-model-reader="main"
entity-group-reader="main" entity-eca-reader="main"
distributed-cache-clear-enabled="false">
<group-map group-name="org.ofbiz" datasource-name="localmysql"/>
<group-map group-name="org.ofbiz.olap"
datasource-name="localmysql"/>
</delegator>
I am using mysql and get the following error when "Quick Ship Entire
Order" is pressed, which I think may be related to the OLAP module.
The Following Errors Occurred:
Error trying to begin transaction, could not process method: The current
transaction is marked for rollback, not beginning a new transaction and
aborting current operation; the rollbackOnly was caused by: Failure in
findByCondition operation for entity [DateDimension]:
org.ofbiz.entity.GenericDataSourceException: SQL Exception while
executing the following:SELECT DIMENSION_ID, DATE_VALUE, DESCRIPTION,
DAY_NAME, DAY_OF_MONTH, DAY_OF_YEAR, MONTH_NAME, MONTH_OF_YEAR,
YEAR_NAME, WEEK_OF_MONTH, WEEK_OF_YEAR, YEAR_MONTH_DAY, YEAR_MONTH,
WEEKDAY_TYPE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP,
CREATED_TX_STAMP FROM DATE_DIMENSION WHERE (DATE_VALUE = ?) ORDER BY
CREATED_TX_STAMP DESC (Syntax error or access violation message from
server: "You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use
near 'YEAR_MONTH, WEEKDAY_TYPE, LAST_UPDATED_STAMP,
LAST_UPDATED_TX_STAMP, CREATED_STA' at line 1"). Rolling back
transaction.org.ofbiz.entity.GenericDataSourceException: SQL Exception
while executing the following:SELECT DIMENSION_ID, DATE_VALUE,
DESCRIPTION, DAY_NAME, DAY_OF_MONTH, DAY_OF_YEAR, MONTH_NAME,
MONTH_OF_YEAR, YEAR_NAME, WEEK_OF_MONTH, WEEK_OF_YEAR, YEAR_MONTH_DAY,
YEAR_MONTH, WEEKDAY_TYPE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP,
CREATED_STAMP, CREATED_TX_STAMP FROM DATE_DIMENSION WHERE (DATE_VALUE =
?) ORDER BY CREATED_TX_STAMP DESC (Syntax error or access violation
message from server: "You have an error in your SQL syntax; check the
manual that corresponds to your MySQL server version for the right
syntax to use near 'YEAR_MONTH, WEEKDAY_TYPE, LAST_UPDATED_STAMP,
LAST_UPDATED_TX_STAMP, CREATED_STA' at line 1") (SQL Exception while
executing the following:SELECT DIMENSION_ID, DATE_VALUE, DESCRIPTION,
DAY_NAME, DAY_OF_MONTH, DAY_OF_YEAR, MONTH_NAME, MONTH_OF_YEAR,
YEAR_NAME, WEEK_OF_MONTH, WEEK_OF_YEAR, YEAR_MONTH_DAY, YEAR_MONTH,
WEEKDAY_TYPE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP,
CREATED_TX_STAMP FROM DATE_DIMENSION WHERE (DATE_VALUE = ?) ORDER BY
CREATED_TX_STAMP DESC (Syntax error or access violation message from
server: "You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use
near 'YEAR_MONTH, WEEKDAY_TYPE, LAST_UPDATED_STAMP,
LAST_UPDATED_TX_STAMP, CREATED_STA' at line 1")) calling service
updateShipment in createShipmentForFacilityAndShipGroup
RE: Postgres OLAP
Posted by Brendan Vogt <br...@gmail.com>.
Thanks I was just curious.
-----Original Message-----
From: Vince M. Clark [mailto:vclark@globalera.com]
Sent: Saturday, December 08, 2007 5:50 PM
To: user@ofbiz.apache.org
Subject: Re: Postgres OLAP
Brendan
The olap feature is pretty new and I know very little about it. The second
<group-map> for org.ofbiz.olap used to not exist in entityconfig.xm.. I
always set both group-maps to the same datasource and everything seems to
work fine.
----- Original Message -----
From: "Brendan Vogt" <br...@gmail.com>
To: user@ofbiz.apache.org
Sent: Saturday, December 8, 2007 8:52:49 AM (GMT-0700) America/Chihuahua
Subject: Postgres OLAP
Hi,
Please check the following piece of code:
<delegator name="default" entity-model-reader="main"
entity-group-reader="main" entity-eca-reader="main"
distributed-cache-clear-enabled="false">
<group-map group-name="org.ofbiz" datasource-name="localpostgres"/>
<group-map group-name="org.ofbiz.olap" datasource-name="localderby"/>
</delegator>
I am using Postgres database. I just want to know what I need to do about
<group-map group-name="org.ofbiz.olap" datasource-name="localderby"/>??
Should I leave it as is? Or should I change it? Does Postgres support
OLAP? Can this be implemented at a later stage?
Brendan