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