XML Export from DataSource From SQL server -- error

[Alexandre Vaillancourt <av...@foret-divine.com>]

[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