Posted by
jitender.garg on
URL: http://ofbiz.116.s1.nabble.com/RE-Users-XML-Export-tp136723.html
Hi All,
I get the following error when I try to export data from the product entity. I am using oracle and the longDescription field is clob.
[1] [xxx] Error when writing Product: org.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT DISTINCT PRODUCT_ID, PRODUCT_TYPE_ID, PRIMARY_PRODUCT_CATEGORY_ID, MANUFACTURER_PARTY_ID, FACILITY_ID, INTRODUCTION_DATE, SUPPORT_DISCONTINUATION_DATE, SALES_DISCONTINUATION_DATE, SALES_DISC_WHEN_NOT_AVAIL, INTERNAL_NAME, BRAND_NAME, COMMENTS, PRODUCT_NAME, DESCRIPTION, LONG_DESCRIPTION, SMALL_IMAGE_URL, MEDIUM_IMAGE_URL, LARGE_IMAGE_URL, DETAIL_IMAGE_URL, DETAIL_SCREEN, INVENTORY_MESSAGE, REQUIRE_INVENTORY, QUANTITY_UOM_ID, QUANTITY_INCLUDED, PIECES_INCLUDED, REQUIRE_AMOUNT, AMOUNT_UOM_TYPE_ID, WEIGHT_UOM_ID, WEIGHT, HEIGHT_UOM_ID, PRODUCT_HEIGHT, SHIPPING_HEIGHT, WIDTH_UOM_ID, PRODUCT_WIDTH, SHIPPING_WIDTH, DEPTH_UOM_ID, PRODUCT_DEPTH, SHIPPING_DEPTH, PRODUCT_RATING, RATING_TYPE_ENUM, RETURNABLE, TAXABLE, TAX_CATEGORY, TAX_VAT_CODE, TAX_DUTY_CODE, CHARGE_SHIPPING, AUTO_CREATE_KEYWORDS, INCLUDE_IN_PROMOTIONS, IS_VIRTUAL, IS_VARIANT, REQUIREME!
NT_METHOD_ENUM_ID, BILL_OF_MATERIAL_LEVEL, IS_COMPLEX, RESERV_MAX_PERSONS, RESERV2ND_P_P_PERC, RESERV_NTH_P_P_PERC, CREATED_DATE, CREATED_BY_USER_LOGIN, LAST_MODIFIED_DATE, LAST_MODIFIED_BY_USER_LOGIN, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ.PRODUCT ORDER BY PRODUCT_ID ASC (ORA-00932: inconsistent datatypes: expected - got CLOB )
It seems to be failign due to the field being clob.
Any ideas what mistake I am making.
regards,
Jitender
_______________________________________________
Users mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/users