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