2011-06-07 14:49:36,627 DEBUG [org.teiid.COMMAND_LOG] (New I/O server worker #1-3) START USER COMMAND: startTime=2011-06-07 14:49:36.627 requestID=wny8EwNMRYhw.21 txID=null sessionID=wny8EwNMRYhw applicationName=JDBC principal=user@teiid-security vdbName=Sf vdbVersion=1 sql=Select Name, Communication_Preferences__c from Contact where true = includes(Communication_Preferences__c, 'Fax,Email')
2011-06-07 14:49:36,629 DEBUG [org.teiid.PROCESSOR] (Worker5_QueryProcessorQueue101) Request Thread wny8EwNMRYhw.21 with state NEW
2011-06-07 14:49:36,629 DEBUG [org.teiid.PROCESSOR] (Worker5_QueryProcessorQueue101) wny8EwNMRYhw.21 No cache directive
2011-06-07 14:49:36,629 DEBUG [org.teiid.PROCESSOR] (Worker5_QueryProcessorQueue101) wny8EwNMRYhw.21 executing Select Name, Communication_Preferences__c from Contact where true = includes(Communication_Preferences__c, 'Fax,Email')
2011-06-07 14:49:36,632 DEBUG [org.teiid.PROCESSOR] (Worker5_QueryProcessorQueue101) ProcessTree for wny8EwNMRYhw.21 ProjectNode(1) output=[Name, Communication_Preferences__c] [Name, Communication_Preferences__c]
LimitNode(2) output=[Name, Communication_Preferences__c] limit 100
SelectNode(3) output=[Name, Communication_Preferences__c] includes(Communication_Preferences__c, 'Fax,Email') = TRUE
AccessNode(4) output=[Communication_Preferences__c, Name] SELECT Contact.Communication_Preferences__c, Contact.Name FROM Contact
2011-06-07 14:49:36,633 DEBUG [org.teiid.TXN_LOG] (Worker5_QueryProcessorQueue101) before getOrCreateTransactionContext:org.teiid.dqp.internal.process.TransactionServerImpl@7bad6b5a(wny8EwNMRYhw)
2011-06-07 14:49:36,633 DEBUG [org.teiid.TXN_LOG] (Worker5_QueryProcessorQueue101) after getOrCreateTransactionContext : wny8EwNMRYhw NONE ID:NONE
2011-06-07 14:49:36,633 DEBUG [org.teiid.BUFFER_MGR] (Worker5_QueryProcessorQueue101) Creating FileStore: 32
2011-06-07 14:49:36,633 DEBUG [org.teiid.BUFFER_MGR] (Worker5_QueryProcessorQueue101) Creating TupleBuffer: 32 of type PROCESSOR
2011-06-07 14:49:36,635 DEBUG [org.teiid.CONNECTOR] (Worker5_QueryProcessorQueue101) wny8EwNMRYhw.21.4.19 Create State
2011-06-07 14:49:36,636 DEBUG [org.teiid.PROCESSOR] (Worker5_QueryProcessorQueue101) Request Thread wny8EwNMRYhw.21 - processor blocked
2011-06-07 14:49:36,636 DEBUG [org.teiid.CONNECTOR] (Worker6_QueryProcessorQueue102) wny8EwNMRYhw.21.4.19 Processing NEW request: SELECT Contact.Communication_Preferences__c, Contact.Name FROM Contact
2011-06-07 14:49:36,636 DEBUG [org.teiid.TXN_LOG] (Worker5_QueryProcessorQueue101) before suspend:org.teiid.dqp.internal.process.TransactionServerImpl@7bad6b5a(wny8EwNMRYhw NONE ID:NONE)
2011-06-07 14:49:36,636 DEBUG [org.teiid.TXN_LOG] (Worker5_QueryProcessorQueue101) after suspend : null
2011-06-07 14:49:36,636 DEBUG [org.teiid.CONNECTOR] (Worker6_QueryProcessorQueue102) wny8EwNMRYhw.21.4.19 Obtained execution
2011-06-07 14:49:36,637 DEBUG [org.teiid.COMMAND_LOG] (Worker6_QueryProcessorQueue102) START DATA SRC COMMAND: startTime=2011-06-07 14:49:36.637 requestID=wny8EwNMRYhw.21 sourceCommandID=4 txID=null modelName=sf connectorBindingName=salesforce sessionID=wny8EwNMRYhw principal=user@teiid-security sql=SELECT Contact.Communication_Preferences__c, Contact.Name FROM Contact
2011-06-07 14:49:36,637 DEBUG [org.teiid.CONNECTOR] (Worker6_QueryProcessorQueue102) sf.wny8EwNMRYhw.wny8EwNMRYhw.21.4: Incoming Query: SELECT Contact.Communication_Preferences__c, Contact.Name FROM Contact
2011-06-07 14:49:36,637 DEBUG [org.teiid.CONNECTOR] (Worker6_QueryProcessorQueue102) sf.wny8EwNMRYhw.wny8EwNMRYhw.21.4: Executing Query: SELECT Contact.Communication_Preferences__c, Contact.Name FROM Contact
2011-06-07 14:49:37,430 DEBUG [org.teiid.CONNECTOR] (Worker6_QueryProcessorQueue102) wny8EwNMRYhw.21.4.19 Executed command
2011-06-07 14:49:37,430 DEBUG [org.teiid.CONNECTOR] (Worker6_QueryProcessorQueue102) wny8EwNMRYhw.21.4.19 Getting results from connector
2011-06-07 14:49:37,431 DEBUG [org.teiid.CONNECTOR] (Worker6_QueryProcessorQueue102) SalesForce Object Name = Contact
2011-06-07 14:49:37,431 DEBUG [org.teiid.CONNECTOR] (Worker6_QueryProcessorQueue102) FieldCount = 2
2011-06-07 14:49:37,431 DEBUG [org.teiid.CONNECTOR] (Worker6_QueryProcessorQueue102) Field # 0 is Communication_Preferences__c
2011-06-07 14:49:37,431 DEBUG [org.teiid.CONNECTOR] (Worker6_QueryProcessorQueue102) Field # 1 is Name
2011-06-07 14:49:37,431 DEBUG [org.teiid.CONNECTOR] (Worker6_QueryProcessorQueue102) wny8EwNMRYhw.21.4.19 Obtained last batch, total row count: 20
2011-06-07 14:49:37,432 DEBUG [org.teiid.PROCESSOR] (Worker5_QueryProcessorQueue103) Request Thread wny8EwNMRYhw.21 with state PROCESSING
2011-06-07 14:49:37,432 DEBUG [org.teiid.CONNECTOR] (Worker6_QueryProcessorQueue104) wny8EwNMRYhw.21.4.19 Processing Close : SELECT Contact.Communication_Preferences__c, Contact.Name FROM Contact
2011-06-07 14:49:37,432 DEBUG [org.teiid.PROCESSOR] (Worker5_QueryProcessorQueue103) QueryProcessor: closing processor
2011-06-07 14:49:37,432 DEBUG [org.teiid.COMMAND_LOG] (Worker6_QueryProcessorQueue104) END SRC COMMAND: endTime=2011-06-07 14:49:37.432 requestID=wny8EwNMRYhw.21 sourceCommandID=4 txID=null modelName=sf connectorBindingName=salesforce sessionID=wny8EwNMRYhw principal=user@teiid-security finalRowCount=20
2011-06-07 14:49:37,432 DEBUG [org.teiid.PROCESSOR] (Worker5_QueryProcessorQueue103) [Ljava.lang.Object;@7d2f049c
[TeiidComponentException]Function includes is marked in the function metadata as a function that must be evaluated at the source.
at org.teiid.query.eval.Evaluator.evaluate(Evaluator.java:962)
at org.teiid.query.eval.Evaluator.internalEvaluate(Evaluator.java:630)
at org.teiid.query.eval.Evaluator.evaluate(Evaluator.java:600)
at org.teiid.query.eval.Evaluator.evaluate(Evaluator.java:276)
at org.teiid.query.eval.Evaluator.evaluateTVL(Evaluator.java:214)
at org.teiid.query.eval.Evaluator.evaluate(Evaluator.java:203)
at org.teiid.query.processor.relational.SelectNode.nextBatchDirect(SelectNode.java:102)
at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:275)
at org.teiid.query.processor.relational.LimitNode.nextBatchDirect(LimitNode.java:100)
at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:275)
at org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:162)
at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:275)
at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:162)
at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:138)
at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:104)
at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:146)
at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:306)
at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:234)
at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:56)
at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:197)
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:636)
2011-06-07 14:49:37,433 DEBUG [org.teiid.CONNECTOR] (Worker6_QueryProcessorQueue104) SynchQueryExecution.close() called
2011-06-07 14:49:37,433 DEBUG [org.teiid.COMMAND_LOG] (Worker5_QueryProcessorQueue103) ERROR USER COMMAND: endTime=2011-06-07 14:49:37.433 requestID=wny8EwNMRYhw.21 txID=null sessionID=wny8EwNMRYhw principal=user@teiid-security vdbName=Sf vdbVersion=1 finalRowCount=null
2011-06-07 14:49:37,433 DEBUG [org.teiid.CONNECTOR] (Worker6_QueryProcessorQueue104) wny8EwNMRYhw.21.4.19 Closed execution
2011-06-07 14:49:37,433 ERROR [org.teiid.PROCESSOR] (Worker5_QueryProcessorQueue103) Unexpected exception for request wny8EwNMRYhw.21
[TeiidComponentException]Function includes is marked in the function metadata as a function that must be evaluated at the source.
at org.teiid.query.eval.Evaluator.evaluate(Evaluator.java:962)
at org.teiid.query.eval.Evaluator.internalEvaluate(Evaluator.java:630)
at org.teiid.query.eval.Evaluator.evaluate(Evaluator.java:600)
at org.teiid.query.eval.Evaluator.evaluate(Evaluator.java:276)
at org.teiid.query.eval.Evaluator.evaluateTVL(Evaluator.java:214)
at org.teiid.query.eval.Evaluator.evaluate(Evaluator.java:203)
at org.teiid.query.processor.relational.SelectNode.nextBatchDirect(SelectNode.java:102)
at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:275)
at org.teiid.query.processor.relational.LimitNode.nextBatchDirect(LimitNode.java:100)
at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:275)
at org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:162)
at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:275)
at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:162)
at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:138)
at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:104)
at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:146)
at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:306)
at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:234)
at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:56)
at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:197)
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:636)
2011-06-07 14:49:37,434 DEBUG [org.teiid.PROCESSOR] (Worker5_QueryProcessorQueue103) Removing tuplesource for the request wny8EwNMRYhw.21
2011-06-07 14:49:37,434 DEBUG [org.teiid.BUFFER_MGR] (Worker5_QueryProcessorQueue103) Removing TupleBuffer: 32
2011-06-07 14:49:37,433 DEBUG [org.teiid.CONNECTOR] (Worker6_QueryProcessorQueue104) wny8EwNMRYhw.21.4.19 Remove State
2011-06-07 14:49:37,434 DEBUG [org.teiid.PROCESSOR] (Worker5_QueryProcessorQueue103) [Ljava.lang.Object;@19d7ddf9
[TeiidComponentException]Function includes is marked in the function metadata as a function that must be evaluated at the source.
at org.teiid.query.eval.Evaluator.evaluate(Evaluator.java:962)
at org.teiid.query.eval.Evaluator.internalEvaluate(Evaluator.java:630)
at org.teiid.query.eval.Evaluator.evaluate(Evaluator.java:600)
at org.teiid.query.eval.Evaluator.evaluate(Evaluator.java:276)
at org.teiid.query.eval.Evaluator.evaluateTVL(Evaluator.java:214)
at org.teiid.query.eval.Evaluator.evaluate(Evaluator.java:203)
at org.teiid.query.processor.relational.SelectNode.nextBatchDirect(SelectNode.java:102)
at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:275)
at org.teiid.query.processor.relational.LimitNode.nextBatchDirect(LimitNode.java:100)
at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:275)
at org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:162)
at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:275)
at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:162)
at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:138)
at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:104)
at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:146)
at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:306)
at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:234)
at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:56)
at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:197)
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:636)
2011-06-07 14:49:37,434 DEBUG [org.teiid.CONNECTOR] (Worker6_QueryProcessorQueue104) wny8EwNMRYhw.21.4.19 Closed connection
2011-06-07 14:49:37,436 DEBUG [org.teiid.TRANSPORT] (Worker5_QueryProcessorQueue103) message: MessageHolder: contents=ResultsMessage rowCount=0 finalRow=-1 for message:70
2011-06-07 14:49:37,438 DEBUG [org.teiid.TXN_LOG] (Worker5_QueryProcessorQueue103) before suspend:org.teiid.dqp.internal.process.TransactionServerImpl@7bad6b5a(wny8EwNMRYhw NONE ID:NONE)
2011-06-07 14:49:37,438 DEBUG [org.teiid.TXN_LOG] (Worker5_QueryProcessorQueue103) after suspend : null