[ http://jira.undersunconsulting.com/browse/OFBIZ-362?page=all ]
Jacopo Cappellato closed OFBIZ-362:
-----------------------------------
Resolution: Won't Fix
> SQL Server error when trying to export (xmldsdump.jsp) the Product entity
> -------------------------------------------------------------------------
>
> Key: OFBIZ-362
> URL: http://jira.undersunconsulting.com/browse/OFBIZ-362
> Project: [OFBiz] Open For Business
> Type: Bug
> Components: entity
> Environment: DB: Microsoft SQL Server
> Reporter: Jacopo Cappellato
> Assignee: Jira Administrator
> Priority: Minor
>
>
> When trying to export the Product entity thru the Webtools "XML export" page
> we get the following error message (when running "SQL Server" as the db):
> Results:
> [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, REQUIREMENT_METHOD_ENUM_ID, TOTAL_QUANTITY_ORDERED,
> TOTAL_TIMES_VIEWED, AVERAGE_CUSTOMER_RATING, BILL_OF_MATERIAL_LEVEL,
> SHIPMENT_BOX_TYPE_ID, 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 dbo.PRODUCT ORDER BY PRODUCT_ID ASC (The
> text, ntext, or image data type cannot be selected as DISTINCT.)
> Any hints?
> Thanks,
> Jacopo
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://jira.undersunconsulting.com/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
