Error Code:99999 Message:Unexpected exception while translating results: Stream has already been closed

[virtualdatabase]

Towards the end of processing a rather long executing query  I  get Error Code:99999 Message:Unexpected exception while translating results: Stream has already been closed

Any thouhgts??

More of the stack trace:

at org.teiid.translator.jdbc.JDBCQueryExecution.next(JDBCQueryExecution.java:110)

at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.handleBatch(ConnectorWorkItem.java:294)

at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:279)

at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:354)

at org.teiid.dqp.internal.process.DataTierTupleSource.nextTuple(DataTierTupleSource.java:232)

at org.teiid.query.processor.relational.AccessNode.nextBatchDirect(AccessNode.java:271)

at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:280)

at org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:155)

at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:280)

at org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:155)

at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:280)

at org.teiid.query.processor.relational.ProjectIntoNode.nextBatchDirect(ProjectIntoNode.java:129)

at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:280)

at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:176)

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:375)

at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:288)

at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:49)

at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:216)

at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:244)

at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:122)

at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:292)

at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)

at java.lang.Thread.run(Thread.java:722)

Caused by: java.sql.SQLException: Stream has already been closed

looks like an issue on the database side (Oracle) but am not sure and don't see anything there..

[shawkins]

It may have something to do with long / long raw columns similar to : https://forums.oracle.com/forums/thread.jspa?messageID=10202113

What are the source and teiid types involved?

[virtualdatabase]

The source is long so I understand the connection to the other message you reference...

However, the TeiiD type is clob.

Up to now, everything has been working when using these LONG columns, modeled as CLOB including the wrapping of a UDF to decompress the long contents..

The only thing different is I was performing a INSERT into SELECT.. where I'm inserting into a table (materizliation) of the aforementioned view...

Now, I'm perofroming a SELECT into #TEMP first then INSERTING as I'm suspecting some sort of tie back reference to the long has expired/closed....

I'll let  you know the  results of that method..

[virtualdatabase]

as I suspected... when I performed the identical query into #TEMP then inserted from #TEMP all worked as expected...