Posted by
Alexandre Vaillancourt on
Jul 21, 2006; 5:46pm
URL: http://ofbiz.116.s1.nabble.com/Order-Qty-Increments-tp140841p140843.html
[XML Export from DataSource From SQL server -- error]
Hi!
I'm trying to export data from our MS SQL Server database (2000). With the
export webtool.
On many tables, I get an error like this one:
[13] [xxx] Error when writing AgreementItem:
org.ofbiz.entity.GenericDataSourceException: SQL Exception while executing
the following:SELECT DISTINCT AGREEMENT_ID, AGREEMENT_ITEM_SEQ_ID,
AGREEMENT_ITEM_TYPE_ID, CURRENCY_UOM_ID, AGREEMENT_TEXT, AGREEMENT_IMAGE,
LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP
FROM dbo.AGREEMENT_ITEM ORDER BY AGREEMENT_ID ASC, AGREEMENT_ITEM_SEQ_ID ASC
(The text, ntext, or image data type cannot be selected as DISTINCT.)
I've searched the mailing lists about that and the only thing I found is
http://lists.ofbiz.org/pipermail/jira/2006-January/002573.html.
Anyone know if there's a workaround for that? I think you can understand
that I wouldn't want to have to re-enter all my parties, products, etc...
Thanks a lot!
Alexandre Vaillancourt