ofbiz-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Boyden, Timothy" <tboy...@Electroswitch.com>
Subject Party export error
Date Sat, 23 Dec 2017 19:46:17 GMT
Using Release 16.11.03...

When exporting Party records from my work PC this morning, I got the following error:

ERROR rendering error page [/error/error.jsp], but here is the error text: org.apache.ofbiz.widget.renderer.ScreenRenderException:
Error rendering screen [component://webtools/widget/EntityScreens.xml#xmldsdump]: org.apache.ofbiz.widget.renderer.ScreenRenderException:
Error rendering screen [component://webtools/widget/CommonScreens.xml#CommonImportExportDecorator]:
org.apache.ofbiz.entity.transaction.GenericTransactionException: The current transaction is
marked for rollback, not beginning a new transaction and aborting current operation; the rollbackOnly
was caused by: [1] [xxx] Error when writing Party: org.apache.ofbiz.entity.GenericDataSourceException:
SQL Exception while executing the following:SELECT DISTINCT PARTY_ID, PARTY_TYPE_ID, EXTERNAL_ID,
PREFERRED_CURRENCY_UOM_ID, DESCRIPTION, STATUS_ID, CREATED_DATE, CREATED_BY_USER_LOGIN, LAST_MODIFIED_DATE,
LAST_MODIFIED_BY_USER_LOGIN, DATA_SOURCE_ID, IS_UNREAD, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP,
CREATED_STAMP, CREATED_TX_STAMP FROM dbo.PARTY ORDER BY PARTY_ID ASC (The text data type cannot
be selected as DISTINCT because it is not comparable.)org.apache.ofbiz.entity.GenericDataSourceException:
SQL Exception while executing the following:SELECT DISTINCT PARTY_ID, PARTY_TYPE_ID, EXTERNAL_ID,
PREFERRED_CURRENCY_UOM_ID, DESCRIPTION, STATUS_ID, CREATED_DATE, CREATED_BY_USER_LOGIN, LAST_MODIFIED_DATE,
LAST_MODIFIED_BY_USER_LOGIN, DATA_SOURCE_ID, IS_UNREAD, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP,
CREATED_STAMP, CREATED_TX_STAMP FROM dbo.PARTY ORDER BY PARTY_ID ASC (The text data type cannot
be selected as DISTINCT because it is not comparable.) (SQL Exception while executing the
following:SELECT DISTINCT PARTY_ID, PARTY_TYPE_ID, EXTERNAL_ID, PREFERRED_CURRENCY_UOM_ID,
DESCRIPTION, STATUS_ID, CREATED_DATE, CREATED_BY_USER_LOGIN, LAST_MODIFIED_DATE, LAST_MODIFIED_BY_USER_LOGIN,
DATA_SOURCE_ID, IS_UNREAD, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP
FROM dbo.PARTY ORDER BY PARTY_ID ASC (The text data type cannot be selected as DISTINCT because
it is not comparable.)) (The current transaction is marked for rollback, not beginning a new
transaction and aborting current operation; the rollbackOnly was caused by: [1] [xxx] Error
when writing Party: org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception while
executing the following:SELECT DISTINCT PARTY_ID, PARTY_TYPE_ID, EXTERNAL_ID, PREFERRED_CURRENCY_UOM_ID,
DESCRIPTION, STATUS_ID, CREATED_DATE, CREATED_BY_USER_LOGIN, LAST_MODIFIED_DATE, LAST_MODIFIED_BY_USER_LOGIN,
DATA_SOURCE_ID, IS_UNREAD, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP
FROM dbo.PARTY ORDER BY PARTY_ID ASC (The text data type cannot be selected as DISTINCT because
it is not comparable.)org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception while
executing the following:SELECT DISTINCT PARTY_ID, PARTY_TYPE_ID, EXTERNAL_ID, PREFERRED_CURRENCY_UOM_ID,
DESCRIPTION, STATUS_ID, CREATED_DATE, CREATED_BY_USER_LOGIN, LAST_MODIFIED_DATE, LAST_MODIFIED_BY_USER_LOGIN,
DATA_SOURCE_ID, IS_UNREAD, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP
FROM dbo.PARTY ORDER BY PARTY_ID ASC (The text data type cannot be selected as DISTINCT because
it is not comparable.) (SQL Exception while executing the following:SELECT DISTINCT PARTY_ID,
PARTY_TYPE_ID, EXTERNAL_ID, PREFERRED_CURRENCY_UOM_ID, DESCRIPTION, STATUS_ID, CREATED_DATE,
CREATED_BY_USER_LOGIN, LAST_MODIFIED_DATE, LAST_MODIFIED_BY_USER_LOGIN, DATA_SOURCE_ID, IS_UNREAD,
LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM dbo.PARTY
ORDER BY PARTY_ID ASC (The text data type cannot be selected as DISTINCT because it is not
comparable.))) (Error rendering screen [component://webtools/widget/CommonScreens.xml#CommonImportExportDecorator]:
org.apache.ofbiz.entity.transaction.GenericTransactionException: The current transaction is
marked for rollback, not beginning a new transaction and aborting current operation; the rollbackOnly
was caused by: [1] [xxx] Error when writing Party: org.apache.ofbiz.entity.GenericDataSourceException:
SQL Exception while executing the following:SELECT DISTINCT PARTY_ID, PARTY_TYPE_ID, EXTERNAL_ID,
PREFERRED_CURRENCY_UOM_ID, DESCRIPTION, STATUS_ID, CREATED_DATE, CREATED_BY_USER_LOGIN, LAST_MODIFIED_DATE,
LAST_MODIFIED_BY_USER_LOGIN, DATA_SOURCE_ID, IS_UNREAD, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP,
CREATED_STAMP, CREATED_TX_STAMP FROM dbo.PARTY ORDER BY PARTY_ID ASC (The text data type cannot
be selected as DISTINCT because it is not comparable.)org.apache.ofbiz.entity.GenericDataSourceException:
SQL Exception while executing the following:SELECT DISTINCT PARTY_ID, PARTY_TYPE_ID, EXTERNAL_ID,
PREFERRED_CURRENCY_UOM_ID, DESCRIPTION, STATUS_ID, CREATED_DATE, CREATED_BY_USER_LOGIN, LAST_MODIFIED_DATE,
LAST_MODIFIED_BY_USER_LOGIN, DATA_SOURCE_ID, IS_UNREAD, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP,
CREATED_STAMP, CREATED_TX_STAMP FROM dbo.PARTY ORDER BY PARTY_ID ASC (The text data type cannot
be selected as DISTINCT because it is not comparable.) (SQL Exception while executing the
following:SELECT DISTINCT PARTY_ID, PARTY_TYPE_ID, EXTERNAL_ID, PREFERRED_CURRENCY_UOM_ID,
DESCRIPTION, STATUS_ID, CREATED_DATE, CREATED_BY_USER_LOGIN, LAST_MODIFIED_DATE, LAST_MODIFIED_BY_USER_LOGIN,
DATA_SOURCE_ID, IS_UNREAD, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP
FROM dbo.PARTY ORDER BY PARTY_ID ASC (The text data type cannot be selected as DISTINCT because
it is not comparable.)) (The current transaction is marked for rollback, not beginning a new
transaction and aborting current operation; the rollbackOnly was caused by: [1] [xxx] Error
when writing Party: org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception while
executing the following:SELECT DISTINCT PARTY_ID, PARTY_TYPE_ID, EXTERNAL_ID, PREFERRED_CURRENCY_UOM_ID,
DESCRIPTION, STATUS_ID, CREATED_DATE, CREATED_BY_USER_LOGIN, LAST_MODIFIED_DATE, LAST_MODIFIED_BY_USER_LOGIN,
DATA_SOURCE_ID, IS_UNREAD, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP
FROM dbo.PARTY ORDER BY PARTY_ID ASC (The text data type cannot be selected as DISTINCT because
it is not comparable.)org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception while
executing the following:SELECT DISTINCT PARTY_ID, PARTY_TYPE_ID, EXTERNAL_ID, PREFERRED_CURRENCY_UOM_ID,
DESCRIPTION, STATUS_ID, CREATED_DATE, CREATED_BY_USER_LOGIN, LAST_MODIFIED_DATE, LAST_MODIFIED_BY_USER_LOGIN,
DATA_SOURCE_ID, IS_UNREAD, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP
FROM dbo.PARTY ORDER BY PARTY_ID ASC (The text data type cannot be selected as DISTINCT because
it is not comparable.) (SQL Exception while executing the following:SELECT DISTINCT PARTY_ID,
PARTY_TYPE_ID, EXTERNAL_ID, PREFERRED_CURRENCY_UOM_ID, DESCRIPTION, STATUS_ID, CREATED_DATE,
CREATED_BY_USER_LOGIN, LAST_MODIFIED_DATE, LAST_MODIFIED_BY_USER_LOGIN, DATA_SOURCE_ID, IS_UNREAD,
LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM dbo.PARTY
ORDER BY PARTY_ID ASC (The text data type cannot be selected as DISTINCT because it is not
comparable.))))

I was able to get an export of Party, by using the Programmable Export feature. However, that
tool did not generate a valid UTF Entity XML Representation. When I tried to import the file,
I got this error:


The Following Errors Occurred:

ERROR: parsing file: ERROR parsing Entity Xml file: org.xml.sax.SAXException: A transaction
error occurred reading data<br/>org.xml.sax.SAXException: Fatal Error reading XML on
line 5, column 415<br/>org.xml.sax.SAXParseException; lineNumber: 5; columnNumber: 415;
Invalid byte 1 of 1-byte UTF-8 sequence.
When I copy and pasted the text into the Import Text box and clicked the Import Text button,
I was able to import the Party records.

Thanks,

Tim

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message