Attachment 939096 Details for Bug 1144256 – log for oracle 10

log for oracle 10

server_ora10.log (text/plain), 18.45 KB, created by Juraj Duráni on 2014-09-19 06:03:51 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Juraj Duráni

Created: 2014-09-19 06:03:51 UTC

Size: 18.45 KB

patch

obsolete

>09:37:49,694 DEBUG [org.teiid.TRANSPORT] (New I/O worker #3) processing message:MessageHolder: key=0 contents=[B@5444bcfd
>09:37:49,696 DEBUG [org.teiid.SECURITY] (New I/O worker #3) authenticateUser jdurani JDBC
>09:37:49,728 DEBUG [org.teiid.SECURITY] (New I/O worker #3) Logon successful for " jdurani "
>09:37:49,729 DEBUG [org.teiid.SECURITY] (New I/O worker #3) Logon successful, created session: sessionid=2nazs+xORyW5; userName=jdurani@teiid-security; vdbName=QT_Ora10ds_Push; vdbVersion=1; createdTime=Tue Sep 16 09:37:49 CEST 2014; applicationName=JDBC; clientHostName=localhost; clientHardwareAddress=null; IPAddress=127.0.0.1; securityDomain=teiid-security; lastPingTime=Tue Sep 16 09:37:49 CEST 2014
>09:37:49,733 DEBUG [org.teiid.TRANSPORT] (New I/O worker #3) send message: MessageHolder: key=0 contents=[B@25d88680
>09:37:49,773 DEBUG [org.teiid.TRANSPORT] (New I/O worker #3) processing message:MessageHolder: key=1 contents=Invoke interface org.teiid.client.DQP.executeRequest
>09:37:49,785 DEBUG [org.teiid.COMMAND_LOG] (New I/O worker #3) 	START USER COMMAND:	startTime=2014-09-16 09:37:49.785	requestID=2nazs+xORyW5.0	txID=null	sessionID=2nazs+xORyW5	applicationName=JDBC	principal=jdurani@teiid-security	vdbName=QT_Ora10ds_Push	vdbVersion=1	sql=SELECT INTKEY, (SELECT DOUBLENUM FROM BQT1.SMALLA WHERE CONVERT(LONGNUM, DOUBLE) = -24) FROM BQT1.SMALLA ORDER BY Intkey
>09:37:49,787 DEBUG [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue0) Request Thread 2nazs+xORyW5.0 with state NEW
>09:37:49,787 DEBUG [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue0) 2nazs+xORyW5.0 Non-cachable command.
>09:37:49,788 DEBUG [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue0) 2nazs+xORyW5.0 executing prepared SELECT INTKEY, (SELECT DOUBLENUM FROM BQT1.SMALLA WHERE CONVERT(LONGNUM, DOUBLE) = -24) FROM BQT1.SMALLA ORDER BY Intkey
>09:37:49,913 DEBUG [org.jboss.jca.core.connectionmanager.pool.idle.IdleRemover] (Worker0_QueryProcessorQueue0) Register pool: SemaphoreArrayListManagedConnectionPool@495d401[pool=Oracle10DS] (interval=1800000)
>09:37:49,913 DEBUG [org.jboss.jca.core.connectionmanager.pool.strategy.OnePool] (Worker0_QueryProcessorQueue0) Oracle10DS: getConnection(null, WrappedConnectionRequestInfo@8919001[userName=bqt2_ro]) [0/20]
>09:37:49,914 DEBUG [org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory] (Worker0_QueryProcessorQueue0) Driver loaded and instance created:oracle.jdbc.OracleDriver@7d9f543f
>09:37:52,743 INFO  [org.teiid.CONNECTOR] (Worker0_QueryProcessorQueue0) OracleExecutionFactory Commit=true;DatabaseProductName=Oracle;DatabaseProductVersion=Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production
>With the Partitioning, OLAP and Data Mining options;DriverMajorVersion=11;DriverMajorVersion=1;DriverName=Oracle JDBC driver;DriverVersion=11.1.0.7.0-Production;IsolationLevel=2
>09:37:52,743 DEBUG [org.teiid.CONNECTOR] (Worker0_QueryProcessorQueue0) Initializing the capabilities for oracle
>09:37:52,744 DEBUG [org.teiid.CONNECTOR] (Worker0_QueryProcessorQueue0) Setting the database version to Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production
>With the Partitioning, OLAP and Data Mining options
>09:37:52,744 DEBUG [org.jboss.jca.core.connectionmanager.pool.strategy.OnePool] (Worker0_QueryProcessorQueue0) Oracle10DS: returnConnection(523d1add, false) [0/20]
>09:37:52,786 DEBUG [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue0) ProcessTree for 2nazs+xORyW5.0 AccessNode(1) output=[convert(SMALLA__2.INTKEY, integer), (SELECT convert(g_0.DOUBLENUM, double) AS c_0 FROM Source.BQT2_RO.SMALLA AS g_0 WHERE CONVERT(convert(g_0.LONGNUM, long), DOUBLE) = -24.0)] SELECT convert(g_0.INTKEY, integer) AS c_0, (SELECT convert(g_1.DOUBLENUM, double) FROM Source.BQT2_RO.SMALLA AS g_1 WHERE CONVERT(convert(g_1.LONGNUM, long), DOUBLE) = -24.0) AS c_1 FROM Source.BQT2_RO.SMALLA AS g_0 ORDER BY c_0
>
>09:37:52,803 DEBUG [org.teiid.TXN_LOG] (Worker0_QueryProcessorQueue0) before getOrCreateTransactionContext:org.teiid.dqp.internal.process.TransactionServerImpl@143078c3(2nazs+xORyW5)
>09:37:52,803 DEBUG [org.teiid.TXN_LOG] (Worker0_QueryProcessorQueue0) after getOrCreateTransactionContext : 2nazs+xORyW5 NONE ID:NONE
>09:37:52,809 DEBUG [org.teiid.BUFFER_MGR] (Worker0_QueryProcessorQueue0) Creating TupleBuffer: 0 [BQT1.SmallA.IntKey, (SELECT BQT1.SmallA.DoubleNum FROM BQT1.SmallA WHERE CONVERT(BQT1.SmallA.LongNum, DOUBLE) = -24.0 LIMIT 2)] [class java.lang.Integer, class java.lang.Double] batch size 2048 of type PROCESSOR
>09:37:52,812 DEBUG [org.teiid.CONNECTOR] (Worker0_QueryProcessorQueue0) 2nazs+xORyW5.0.1.0 Create State
>09:37:52,824 DEBUG [org.teiid.BUFFER_MGR] (Worker0_QueryProcessorQueue0) 2nazs+xORyW5.0.1.0 Blocking on source query 2nazs+xORyW5.0.1.0
>09:37:52,825 DEBUG [org.teiid.BUFFER_MGR] (Worker0_QueryProcessorQueue0) 2nazs+xORyW5.0 Blocking on source request(s).
>09:37:52,825 DEBUG [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue0) Request Thread 2nazs+xORyW5.0 - processor blocked
>09:37:52,825 DEBUG [org.teiid.PROCESSOR] (Worker1_QueryProcessorQueue1) Running task for parent thread Worker0_QueryProcessorQueue0
>09:37:52,825 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue1) 2nazs+xORyW5.0.1.0 Processing NEW request: SELECT convert(g_0.INTKEY, integer) AS c_0, (SELECT convert(g_1.DOUBLENUM, double) FROM Source.BQT2_RO.SMALLA AS g_1 WHERE CONVERT(convert(g_1.LONGNUM, long), DOUBLE) = -24.0) AS c_1 FROM Source.BQT2_RO.SMALLA AS g_0 ORDER BY c_0
>09:37:52,826 DEBUG [org.jboss.jca.core.connectionmanager.pool.strategy.OnePool] (Worker1_QueryProcessorQueue1) Oracle10DS: getConnection(null, WrappedConnectionRequestInfo@8919001[userName=bqt2_ro]) [0/20]
>09:37:52,829 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue1) 2nazs+xORyW5.0.1.0 Obtained execution
>09:37:52,829 DEBUG [org.teiid.COMMAND_LOG] (Worker1_QueryProcessorQueue1) 	START DATA SRC COMMAND:	startTime=2014-09-16 09:37:52.829	requestID=2nazs+xORyW5.0	sourceCommandID=1	executionID=0	txID=null	modelName=Source	translatorName=oracle	sessionID=2nazs+xORyW5	principal=jdurani@teiid-security	sql=SELECT convert(g_0.INTKEY, integer) AS c_0, (SELECT convert(g_1.DOUBLENUM, double) FROM Source.BQT2_RO.SMALLA AS g_1 WHERE CONVERT(convert(g_1.LONGNUM, long), DOUBLE) = -24.0) AS c_1 FROM Source.BQT2_RO.SMALLA AS g_0 ORDER BY c_0
>09:37:52,833 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue1) Source-specific command: SELECT trunc(g_0.INTKEY) AS c_0, (SELECT g_1.DOUBLENUM FROM "BQT2_RO"."SMALLA" g_1 WHERE trunc(g_1.LONGNUM) = -24,0) AS c_1 FROM "BQT2_RO"."SMALLA" g_0 ORDER BY c_0
>09:37:53,218 DEBUG [org.teiid.COMMAND_LOG] (Worker1_QueryProcessorQueue1) 	ERROR SRC COMMAND:	endTime=2014-09-16 09:37:53.218	requestID=2nazs+xORyW5.0	sourceCommandID=1	executionID=0	txID=null	modelName=Source	translatorName=oracle	sessionID=2nazs+xORyW5	principal=jdurani@teiid-security	finalRowCount=null
>09:37:53,219 WARN  [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue1) Connector worker process failed for atomic-request=2nazs+xORyW5.0.1.0: org.teiid.translator.jdbc.JDBCExecutionException: 907 TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values: [] SQL: SELECT trunc(g_0.INTKEY) AS c_0, (SELECT g_1.DOUBLENUM FROM "BQT2_RO"."SMALLA" g_1 WHERE trunc(g_1.LONGNUM) = -24,0) AS c_1 FROM "BQT2_RO"."SMALLA" g_0 ORDER BY c_0]
>	at org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:131)
>	at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:325) [teiid-engine-8.7.1.redhat-2.jar:8.7.1.redhat-2]
>	at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:298) [teiid-engine-8.7.1.redhat-2.jar:8.7.1.redhat-2]
>	at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:110) [teiid-engine-8.7.1.redhat-2.jar:8.7.1.redhat-2]
>	at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:107) [teiid-engine-8.7.1.redhat-2.jar:8.7.1.redhat-2]
>	at java.util.concurrent.FutureTask.run(FutureTask.java:262) [rt.jar:1.7.0_60]
>	at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:58) [teiid-engine-8.7.1.redhat-2.jar:8.7.1.redhat-2]
>	at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:274) [teiid-engine-8.7.1.redhat-2.jar:8.7.1.redhat-2]
>	at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.7.1.redhat-2.jar:8.7.1.redhat-2]
>	at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:214) [teiid-engine-8.7.1.redhat-2.jar:8.7.1.redhat-2]
>	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_60]
>	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_60]
>	at java.lang.Thread.run(Thread.java:745) [rt.jar:1.7.0_60]
>Caused by: java.sql.SQLSyntaxErrorException: ORA-00907: missing right parenthesis
>
>	at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:91)
>	at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)
>	at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206)
>	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
>	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
>	at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1034)
>	at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:194)
>	at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:791)
>	at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:866)
>	at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1186)
>	at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3387)
>	at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3431)
>	at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1491)
>	at org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:462)
>	at org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:123)
>	... 12 more
>
>09:37:53,222 DEBUG [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue2) Request Thread 2nazs+xORyW5.0 with state PROCESSING
>09:37:53,222 DEBUG [org.teiid.CONNECTOR] (Worker0_QueryProcessorQueue2) 2nazs+xORyW5.0.1.0 Remove State
>09:37:53,222 DEBUG [org.teiid.CONNECTOR] (Worker0_QueryProcessorQueue2) 2nazs+xORyW5.0.1.0 Processing Close : SELECT convert(g_0.INTKEY, integer) AS c_0, (SELECT convert(g_1.DOUBLENUM, double) FROM Source.BQT2_RO.SMALLA AS g_1 WHERE CONVERT(convert(g_1.LONGNUM, long), DOUBLE) = -24.0) AS c_1 FROM Source.BQT2_RO.SMALLA AS g_0 ORDER BY c_0
>09:37:53,222 DEBUG [org.teiid.CONNECTOR] (Worker0_QueryProcessorQueue2) 2nazs+xORyW5.0.1.0 Closed execution
>09:37:53,223 DEBUG [org.jboss.jca.core.connectionmanager.pool.strategy.OnePool] (Worker0_QueryProcessorQueue2) Oracle10DS: returnConnection(523d1add, false) [0/20]
>09:37:53,223 DEBUG [org.teiid.CONNECTOR] (Worker0_QueryProcessorQueue2) 2nazs+xORyW5.0.1.0 Closed connection
>09:37:53,223 DEBUG [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue2) QueryProcessor: closing processor
>09:37:53,223 DEBUG [org.teiid.COMMAND_LOG] (Worker0_QueryProcessorQueue2) 	ERROR USER COMMAND:	endTime=2014-09-16 09:37:53.223	requestID=2nazs+xORyW5.0	txID=null	sessionID=2nazs+xORyW5	principal=jdurani@teiid-security	vdbName=QT_Ora10ds_Push	vdbVersion=1	finalRowCount=null
>09:37:53,224 WARN  [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue2) TEIID30020 Processing exception for request 2nazs+xORyW5.0 'TEIID30504 Source: 907 TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values: [] SQL: SELECT trunc(g_0.INTKEY) AS c_0, (SELECT g_1.DOUBLENUM FROM "BQT2_RO"."SMALLA" g_1 WHERE trunc(g_1.LONGNUM) = -24,0) AS c_1 FROM "BQT2_RO"."SMALLA" g_0 ORDER BY c_0]'. Originally TeiidProcessingException 'ORA-00907: missing right parenthesis
>' SQLStateMapping.java:91.: org.teiid.core.TeiidProcessingException: TEIID30504 Source: 907 TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values: [] SQL: SELECT trunc(g_0.INTKEY) AS c_0, (SELECT g_1.DOUBLENUM FROM "BQT2_RO"."SMALLA" g_1 WHERE trunc(g_1.LONGNUM) = -24,0) AS c_1 FROM "BQT2_RO"."SMALLA" g_0 ORDER BY c_0]
>	at org.teiid.dqp.internal.process.DataTierTupleSource.exceptionOccurred(DataTierTupleSource.java:381) [teiid-engine-8.7.1.redhat-2.jar:8.7.1.redhat-2]
>	at org.teiid.dqp.internal.process.DataTierTupleSource.nextTuple(DataTierTupleSource.java:154) [teiid-engine-8.7.1.redhat-2.jar:8.7.1.redhat-2]
>	at org.teiid.query.processor.relational.AccessNode.nextBatchDirect(AccessNode.java:369) [teiid-engine-8.7.1.redhat-2.jar:8.7.1.redhat-2]
>	at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) [teiid-engine-8.7.1.redhat-2.jar:8.7.1.redhat-2]
>	at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:136) [teiid-engine-8.7.1.redhat-2.jar:8.7.1.redhat-2]
>	at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:151) [teiid-engine-8.7.1.redhat-2.jar:8.7.1.redhat-2]
>	at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:114) [teiid-engine-8.7.1.redhat-2.jar:8.7.1.redhat-2]
>	at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:159) [teiid-engine-8.7.1.redhat-2.jar:8.7.1.redhat-2]
>	at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:141) [teiid-engine-8.7.1.redhat-2.jar:8.7.1.redhat-2]
>	at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:444) [teiid-engine-8.7.1.redhat-2.jar:8.7.1.redhat-2]
>	at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:326) [teiid-engine-8.7.1.redhat-2.jar:8.7.1.redhat-2]
>	at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51) [teiid-engine-8.7.1.redhat-2.jar:8.7.1.redhat-2]
>	at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:254) [teiid-engine-8.7.1.redhat-2.jar:8.7.1.redhat-2]
>	at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:274) [teiid-engine-8.7.1.redhat-2.jar:8.7.1.redhat-2]
>	at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.7.1.redhat-2.jar:8.7.1.redhat-2]
>	at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:214) [teiid-engine-8.7.1.redhat-2.jar:8.7.1.redhat-2]
>	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_60]
>	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_60]
>	at java.lang.Thread.run(Thread.java:745) [rt.jar:1.7.0_60]
>Caused by: org.teiid.translator.jdbc.JDBCExecutionException: 907 TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values: [] SQL: SELECT trunc(g_0.INTKEY) AS c_0, (SELECT g_1.DOUBLENUM FROM "BQT2_RO"."SMALLA" g_1 WHERE trunc(g_1.LONGNUM) = -24,0) AS c_1 FROM "BQT2_RO"."SMALLA" g_0 ORDER BY c_0]
>	at org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:131)
>	at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:325) [teiid-engine-8.7.1.redhat-2.jar:8.7.1.redhat-2]
>	at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:298) [teiid-engine-8.7.1.redhat-2.jar:8.7.1.redhat-2]
>	at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:110) [teiid-engine-8.7.1.redhat-2.jar:8.7.1.redhat-2]
>	at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:107) [teiid-engine-8.7.1.redhat-2.jar:8.7.1.redhat-2]
>	at java.util.concurrent.FutureTask.run(FutureTask.java:262) [rt.jar:1.7.0_60]
>	at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:58) [teiid-engine-8.7.1.redhat-2.jar:8.7.1.redhat-2]
>	... 6 more
>Caused by: java.sql.SQLSyntaxErrorException: ORA-00907: missing right parenthesis
>
>	at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:91)
>	at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)
>	at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206)
>	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
>	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
>	at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1034)
>	at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:194)
>	at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:791)
>	at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:866)
>	at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1186)
>	at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3387)
>	at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3431)
>	at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1491)
>	at org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:462)
>	at org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:123)
>	... 12 more
>
>09:37:53,226 DEBUG [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue2) Removing tuplesource for the request 2nazs+xORyW5.0
>09:37:53,226 DEBUG [org.teiid.BUFFER_MGR] (Worker0_QueryProcessorQueue2) Removing TupleBuffer: 0
>09:37:53,227 DEBUG [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue2) org.teiid.core.TeiidProcessingException: TEIID30504 Source: 907 TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values: [] SQL: SELECT trunc(g_0.INTKEY) AS c_0, (SELECT g_1.DOUBLENUM FROM "BQT2_RO"."SMALLA" g_1 WHERE trunc(g_1.LONGNUM) = -24,0) AS c_1 FROM "BQT2_RO"."SMALLA" g_0 ORDER BY c_0] Sending error to client 2nazs+xORyW5.0
>09:37:53,228 DEBUG [org.teiid.TRANSPORT] (Worker0_QueryProcessorQueue2) send message: MessageHolder: key=1 contents=ResultsMessage rowCount=0 finalRow=-1
>09:37:53,296 DEBUG [org.teiid.TRANSPORT] (New I/O worker #3) processing message:MessageHolder: key=2 contents=Invoke interface org.teiid.client.security.ILogon.logoff
>09:37:53,296 DEBUG [org.teiid.SECURITY] (New I/O worker #3) closeSession 2nazs+xORyW5
>09:37:53,297 DEBUG [org.teiid.TXN_LOG] (New I/O worker #3) before cancelTransactions:org.teiid.dqp.internal.process.TransactionServerImpl@143078c3(2nazs+xORyW5,false)
>09:37:53,297 DEBUG [org.teiid.TXN_LOG] (New I/O worker #3) after cancelTransactions : null
>09:37:53,297 DEBUG [org.teiid.TRANSPORT] (New I/O worker #3) send message: MessageHolder: key=2 contents=null
>09:37:53,326 DEBUG [org.teiid.TRANSPORT] (New I/O worker #3) Channel closed

Actions: View

Attachments on bug 1144256: 939095 | 939096