[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
