EDS Designer Preview errors on tables with "ResultsViewAPI_append_resultset_error possible args: {0}, {1}, {2}, {3}"

Solution Verified - Updated -

Issue

  • I've run the import from JDBC and am using Preview to look at the tables and an error occurs on some:
"ResultsViewAPI_append_resultset_error possible args: {0}, {1}, {2}, {3}"
org.teiid.jdbc.TeiidSQLException: Unable to transform the column value org.teiid.core.types... to a String.
    at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:113)
    at org.teiid.jdbc.DataTypeTransformer.transform(DataTypeTransformer.java:77)
    at org.teiid.jdbc.DataTypeTransformer.transform(DataTypeTransformer.java:62)
    at org.teiid.jdbc.DataTypeTransformer.getString(DataTypeTransformer.java:239)
    at org.teiid.jdbc.ResultSetImpl.getString(ResultSetImpl.java:823)
    at org.eclipse.datatools.sqltools.result.internal.utils.SQLUtil.getObjectByTypeCoercion(SQLUtil.java:173)
    at org.eclipse.datatools.sqltools.result.ResultSetObject.<init>(ResultSetObject.java:150)
    at org.eclipse.datatools.sqltools.result.internal.model.ResultInstanceFactory.createResultSetObject(ResultInstanceFactory.java:79)
    at org.eclipse.datatools.sqltools.result.internal.model.ResultInstance.moreResultSet(ResultInstance.java:127)
    at org.eclipse.datatools.sqltools.result.ResultsViewAPI.appendResultSet(ResultsViewAPI.java:353)
    at org.teiid.datatools.connectivity.ui.TeiidAdHocScriptRunnable.loopThroughResults(TeiidAdHocScriptRunnable.java:427)
    at org.eclipse.datatools.sqltools.editor.core.result.ResultSupportRunnable.handleSuccess(ResultSupportRunnable.java:419)
    at org.teiid.datatools.connectivity.ui.TeiidAdHocScriptRunnable.access$7(TeiidAdHocScriptRunnable.java:1)
    at org.teiid.datatools.connectivity.ui.TeiidAdHocScriptRunnable$HandleSuccessJob.run(TeiidAdHocScriptRunnable.java:360)
    at org.eclipse.core.internal.jobs.Worker.run(Worker.java:54)
Caused by: org.teiid.core.types.TransformationException: Invalid conversion from type class org.teiid.core.types.BlobType with value 'org.teiid.core.types.BlobImpl@250c4b29' to type class java.lang.String
    at org.teiid.core.types.DataTypeManager.transformValue(DataTypeManager.java:859)
    at org.teiid.core.types.DataTypeManager.transformValue(DataTypeManager.java:846)
    at org.teiid.jdbc.DataTypeTransformer.transform(DataTypeTransformer.java:70)
    ... 13 more

Environment

  • Red Hat JBoss Data Services (EDS) 5.3.1

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.

Current Customers and Partners

Log in for full access

Log In