Hi all,
I try to export the table PRODUCT_CATEGORY with the XML Data Export module of the webtools application. But I had this ofbiz error
org.ofbiz.widget.screen.ScreenRenderException:
Error rendering screen
[component://webtools/widget/CommonScreens.xml#main-decorator]:
org.ofbiz.entity.transaction.GenericTransactionException: The current
transaction is marked for rollback, not beginning a new transaction and
aborting current operation; the rollbackOnly was caused by: [1] [xxx]
Error when writing ProductCategory:
org.ofbiz.entity.GenericDataSourceException: SQL Exception while
executing the following:SELECT DISTINCT PRODUCT_CATEGORY_ID,
PRODUCT_CATEGORY_TYPE_ID, PRIMARY_PARENT_CATEGORY_ID, CATEGORY_NAME,
DESCRIPTION, LONG_DESCRIPTION, CATEGORY_IMAGE_URL, LINK_ONE_IMAGE_URL,
LINK_TWO_IMAGE_URL, DETAIL_SCREEN, SHOW_IN_SELECT, LAST_UPDATED_STAMP,
LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM
OFBIZ.PRODUCT_CATEGORY ORDER BY PRODUCT_CATEGORY_ID ASC (ORA-00932:
types de données incohérents ; attendu : - ; obtenu : CLOB
)org.ofbiz.entity.GenericDataSourceException:
SQL Exception while executing the following:SELECT DISTINCT
PRODUCT_CATEGORY_ID, PRODUCT_CATEGORY_TYPE_ID,
PRIMARY_PARENT_CATEGORY_ID, CATEGORY_NAME, DESCRIPTION,
LONG_DESCRIPTION, CATEGORY_IMAGE_URL, LINK_ONE_IMAGE_URL,
LINK_TWO_IMAGE_URL, DETAIL_SCREEN, SHOW_IN_SELECT, LAST_UPDATED_STAMP,
LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM
OFBIZ.PRODUCT_CATEGORY ORDER BY PRODUCT_CATEGORY_ID ASC (ORA-00932:
types de données incohérents ; attendu : - ; obtenu : CLOB
) (SQL
Exception while executing the following:SELECT DISTINCT
PRODUCT_CATEGORY_ID, PRODUCT_CATEGORY_TYPE_ID,
PRIMARY_PARENT_CATEGORY_ID, CATEGORY_NAME, DESCRIPTION,
LONG_DESCRIPTION, CATEGORY_IMAGE_URL, LINK_ONE_IMAGE_URL,
LINK_TWO_IMAGE_URL, DETAIL_SCREEN, SHOW_IN_SELECT, LAST_UPDATED_STAMP,
LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM
OFBIZ.PRODUCT_CATEGORY ORDER BY PRODUCT_CATEGORY_ID ASC (ORA-00932:
types de données incohérents ; attendu : - ; obtenu : CLOB
)) (The
current transaction is marked for rollback, not beginning a new
transaction and aborting current operation; the rollbackOnly was caused
by: [1] [xxx] Error when writing ProductCategory:
org.ofbiz.entity.GenericDataSourceException: SQL Exception while
executing the following:SELECT DISTINCT PRODUCT_CATEGORY_ID,
PRODUCT_CATEGORY_TYPE_ID, PRIMARY_PARENT_CATEGORY_ID, CATEGORY_NAME,
DESCRIPTION, LONG_DESCRIPTION, CATEGORY_IMAGE_URL, LINK_ONE_IMAGE_URL,
LINK_TWO_IMAGE_URL, DETAIL_SCREEN, SHOW_IN_SELECT, LAST_UPDATED_STAMP,
LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM
OFBIZ.PRODUCT_CATEGORY ORDER BY PRODUCT_CATEGORY_ID ASC (ORA-00932:
types de données incohérents ; attendu : - ; obtenu : CLOB
The Oracle error message, ORA-00932, are in french (since I'm using a french version of Oracle Database 10g : SQL Oracle Developer) but It means that the data type are incoherents. Date type '-' is waited and CLOB is acquired. The only one CLOB attribute of the table is LONG_DESCRIPTION.
Is this error known when exporting the PRODUCT_CATEGORY table ? Is there a solution ?
I had the same trouble when I try to export PRODUCT table...
Thanks for any help !
Amine
_________________________________________________________________
Retouchez, classez et partagez vos photos gratuitement avec le logiciel Galerie de Photos !
http://www.windowslive.fr/galerie/
Locked
