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: [EMAIL PROTECTED] > To: [email protected] > 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 > > > > > > > > > > > > >
