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
