[JBoss JIRA] (TEIID-1881) With Teradata, querying XQT document fails with Failed to convert org.teiid.core.types.ClobType into java.lang.String
9:58 p.m.
With Teradata, querying XQT document fails with Failed to convert
org.teiid.core.types.ClobType into java.lang.String
---------------------------------------------------------------------------------------------------------------------
Key: TEIID-1881
URL: https://issues.jboss.org/browse/TEIID-1881
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 7.6
Reporter: Paul Nittel
Assignee: Steven Hawkins
Attachments: QT_teradata12_Push.vdb
The query in question is: SELECT * FROM XQTDoc.BQTDocTestDocument. No form of convert
appears to help. The underlying database is Teradata.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
9:58 p.m.
[
https://issues.jboss.org/browse/TEIID-1881?page=com.atlassian.jira.plugin...
]
Paul Nittel updated TEIID-1881:
-------------------------------
Attachment: QT_teradata12_Push.vdb
With Teradata, querying XQT document fails with Failed to convert
org.teiid.core.types.ClobType into java.lang.String
---------------------------------------------------------------------------------------------------------------------
Key: TEIID-1881
URL: https://issues.jboss.org/browse/TEIID-1881
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 7.6
Reporter: Paul Nittel
Assignee: Steven Hawkins
Attachments: QT_teradata12_Push.vdb
The query in question is: SELECT * FROM XQTDoc.BQTDocTestDocument. No form of convert
appears to help. The underlying database is Teradata.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
10:04 p.m.
[
https://issues.jboss.org/browse/TEIID-1881?page=com.atlassian.jira.plugin...
]
Steven Hawkins commented on TEIID-1881:
---------------------------------------
Do you have a stacktrace?
With Teradata, querying XQT document fails with Failed to convert
org.teiid.core.types.ClobType into java.lang.String
---------------------------------------------------------------------------------------------------------------------
Key: TEIID-1881
URL: https://issues.jboss.org/browse/TEIID-1881
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 7.6
Reporter: Paul Nittel
Assignee: Steven Hawkins
Attachments: QT_teradata12_Push.vdb
The query in question is: SELECT * FROM XQTDoc.BQTDocTestDocument. No form of convert
appears to help. The underlying database is Teradata.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
10:04 p.m.
[
https://issues.jboss.org/browse/TEIID-1881?page=com.atlassian.jira.plugin...
]
Van Halbert updated TEIID-1881:
-------------------------------
Comment: was deleted
(was: I think this issue is a known issue and is documented as a known issue.)
With Teradata, querying XQT document fails with Failed to convert
org.teiid.core.types.ClobType into java.lang.String
---------------------------------------------------------------------------------------------------------------------
Key: TEIID-1881
URL: https://issues.jboss.org/browse/TEIID-1881
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 7.6
Reporter: Paul Nittel
Assignee: Steven Hawkins
Attachments: QT_teradata12_Push.vdb
The query in question is: SELECT * FROM XQTDoc.BQTDocTestDocument. No form of convert
appears to help. The underlying database is Teradata.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
10:10 p.m.
[
https://issues.jboss.org/browse/TEIID-1881?page=com.atlassian.jira.plugin...
]
Paul Nittel commented on TEIID-1881:
------------------------------------
Here's the stacktrace from the server.log file.
[TransformationException]Failed to convert org.teiid.core.types.ClobType into
java.lang.String
1 [IOException][Teradata Database] [TeraJDBC 13.00.00.06] [Error 5766] [SQLState HY000]
The Locator is invalid because the response spool has been dropped.
at
org.teiid.core.types.basic.ClobToStringTransform.transformDirect(ClobToStringTransform.java:68)
at org.teiid.core.types.Transform.transform(Transform.java:47)
at org.teiid.core.types.DataTypeManager.transformValue(DataTypeManager.java:851)
at org.teiid.core.types.DataTypeManager.transformValue(DataTypeManager.java:836)
at
org.teiid.query.processor.xml.XMLValueTranslator.defaultTranslation(XMLValueTranslator.java:184)
at
org.teiid.query.processor.xml.XMLValueTranslator.translateToXMLValue(XMLValueTranslator.java:118)
at org.teiid.query.processor.xml.AddNodeInstruction.process(AddNodeInstruction.java:118)
at org.teiid.query.processor.xml.XMLPlan.nextBatch(XMLPlan.java:162)
at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:139)
at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:105)
at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:147)
at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:370)
at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:287)
at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:49)
at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:215)
at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:232)
at
org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:118)
at
org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:288)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
at java.lang.Thread.run(Thread.java:679)
Caused by: java.io.IOException: [Teradata Database] [TeraJDBC 13.00.00.06] [Error 5766]
[SQLState HY000] The Locator is invalid because the response spool has been dropped.
at
com.teradata.jdbc.jdbc_4.ifsupport.ClobStreamReader.getNewString(ClobStreamReader.java:129)
at
com.teradata.jdbc.jdbc_4.ifsupport.ClobStreamReader.readStringData(ClobStreamReader.java:85)
at com.teradata.jdbc.jdbc_4.ifsupport.ClobStreamReader.read(ClobStreamReader.java:66)
at com.teradata.jdbc.jdbc_4.ifsupport.LobReader.read(LobReader.java:51)
at java.io.BufferedReader.fill(BufferedReader.java:153)
at java.io.BufferedReader.read(BufferedReader.java:174)
at
org.teiid.core.types.basic.ClobToStringTransform.transformDirect(ClobToStringTransform.java:57)
... 20 more
With Teradata, querying XQT document fails with Failed to convert
org.teiid.core.types.ClobType into java.lang.String
---------------------------------------------------------------------------------------------------------------------
Key: TEIID-1881
URL: https://issues.jboss.org/browse/TEIID-1881
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 7.6
Reporter: Paul Nittel
Assignee: Steven Hawkins
Attachments: QT_teradata12_Push.vdb
The query in question is: SELECT * FROM XQTDoc.BQTDocTestDocument. No form of convert
appears to help. The underlying database is Teradata.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
10:10 p.m.
[
https://issues.jboss.org/browse/TEIID-1881?page=com.atlassian.jira.plugin...
]
Steven Hawkins resolved TEIID-1881.
-----------------------------------
Resolution: Duplicate Issue
Van is correct, TEIID-1648 details Teradata lob issues. There is still no easy workaround
except for the embedded case in serial mode.
With Teradata, querying XQT document fails with Failed to convert
org.teiid.core.types.ClobType into java.lang.String
---------------------------------------------------------------------------------------------------------------------
Key: TEIID-1881
URL: https://issues.jboss.org/browse/TEIID-1881
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 7.6
Reporter: Paul Nittel
Assignee: Steven Hawkins
Attachments: QT_teradata12_Push.vdb
The query in question is: SELECT * FROM XQTDoc.BQTDocTestDocument. No form of convert
appears to help. The underlying database is Teradata.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
10:21 p.m.
[
https://issues.jboss.org/browse/TEIID-1881?page=com.atlassian.jira.plugin...
]
Steven Hawkins commented on TEIID-1881:
---------------------------------------
I should add that with 7.6 lob inlining small lobs in a serial mode for even a
non-embedded client will also be fine.
With Teradata, querying XQT document fails with Failed to convert
org.teiid.core.types.ClobType into java.lang.String
---------------------------------------------------------------------------------------------------------------------
Key: TEIID-1881
URL: https://issues.jboss.org/browse/TEIID-1881
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 7.6
Reporter: Paul Nittel
Assignee: Steven Hawkins
Attachments: QT_teradata12_Push.vdb
The query in question is: SELECT * FROM XQTDoc.BQTDocTestDocument. No form of convert
appears to help. The underlying database is Teradata.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
4:06 p.m.
[
https://issues.jboss.org/browse/TEIID-1881?page=com.atlassian.jira.plugin...
]
Steven Hawkins closed TEIID-1881.
---------------------------------
With Teradata, querying XQT document fails with Failed to convert
org.teiid.core.types.ClobType into java.lang.String
---------------------------------------------------------------------------------------------------------------------
Key: TEIID-1881
URL: https://issues.jboss.org/browse/TEIID-1881
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 7.6
Reporter: Paul Nittel
Assignee: Steven Hawkins
Attachments: QT_teradata12_Push.vdb
The query in question is: SELECT * FROM XQTDoc.BQTDocTestDocument. No form of convert
appears to help. The underlying database is Teradata.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
4496
days inactive
4560
days old
7 comments
7 participants
participants (7)
-
Paul Nittel (Commented) (JIRA) -
Paul Nittel (Created) (JIRA)
-
Paul Nittel (Updated) (JIRA)
-
Steven Hawkins (Commented) (JIRA)
-
Steven Hawkins (JIRA)
-
Steven Hawkins (Resolved) (JIRA)
-
Van Halbert (Updated) (JIRA)