OFBiz › OFBiz - User

Postgres OLAP

‹ Previous Topic Next Topic ›
 
classic Classic list List threaded Threaded
♦
♦
 6 messages Options
Brendan Vogt
Reply | Threaded
Open this post in threaded view
♦
♦
|

Postgres OLAP

Brendan Vogt
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

Vince Clark
Reply | Threaded
Open this post in threaded view
♦
♦
|

Re: Postgres OLAP

Vince Clark
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" <[hidden email]>
To: [hidden email]
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

Brendan Vogt
Reply | Threaded
Open this post in threaded view
♦
♦
|

RE: Postgres OLAP

Brendan Vogt
Thanks I was just curious.


-----Original Message-----
From: Vince M. Clark [mailto:[hidden email]]
Sent: Saturday, December 08, 2007 5:50 PM
To: [hidden email]
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" <[hidden email]>
To: [hidden email]
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


Calum Miller-2
Reply | Threaded
Open this post in threaded view
♦
♦
|

Disable OLAP component

Calum Miller-2
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



BJ Freeman
Reply | Threaded
Open this post in threaded view
♦
♦
|

Re: Disable OLAP component

BJ Freeman
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
>
>
>
>
>
>

Christopher L
Reply | Threaded
Open this post in threaded view
♦
♦
|

RE: Disable OLAP component

Christopher L
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: [hidden email]
> To: [hidden email]
> 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
> >
> >
> >
> >
> >
> >
>
Free forum by Nabble Edit this page