21 Dec 2011 11:22:29,248 CST DEBUG [org.teiid.TRANSPORT] (New I/O server worker #1-1) processing message:MessageHolder: contents=org.teiid.net.socket.ServiceInvocationStruct@39a495a6 21 Dec 2011 11:22:29,249 CST DEBUG [org.teiid.SECURITY] (New I/O server worker #1-1) authenticateUser admin JDBC 21 Dec 2011 11:22:29,250 CST DEBUG [org.teiid.SECURITY] (New I/O server worker #1-1) Logon successful, created session: sessionid=tdfLszERtd3T; userName=admin@teiid-security; vdbName=Chorus; vdbVersion=1; createdTime=Wed Dec 21 11:22:29 CST 2011; applicationName=JDBC; clientHostName=ROKAN01.ca.com; clientHardwareAddress=0027136A79BC; IPAddress=130.200.19.71; securityDomain=teiid-security; lastPingTime=Wed Dec 21 11:22:29 CST 2011 21 Dec 2011 11:22:29,250 CST DEBUG [org.teiid.TRANSPORT] (New I/O server worker #1-1) message: MessageHolder: contents=org.teiid.client.security.LogonResult@56468917 for message:649 21 Dec 2011 11:22:29,443 CST DEBUG [org.teiid.TRANSPORT] (New I/O server worker #1-1) processing message:MessageHolder: contents=org.teiid.net.socket.ServiceInvocationStruct@61bbb8a4 21 Dec 2011 11:22:29,443 CST DEBUG [org.teiid.COMMAND_LOG] (New I/O server worker #1-1) START USER COMMAND: startTime=2011-12-21 11:22:29.443 requestID=tdfLszERtd3T.0 txID=null sessionID=tdfLszERtd3T applicationName=JDBC principal=admin@teiid-security vdbName=Chorus vdbVersion=1 sql=select * from chorus_metadata.property 21 Dec 2011 11:22:29,445 CST DEBUG [org.teiid.PROCESSOR] (Worker11_QueryProcessorQueue39) Request Thread tdfLszERtd3T.0 with state NEW 21 Dec 2011 11:22:29,445 CST DEBUG [org.teiid.PROCESSOR] (Worker11_QueryProcessorQueue39) tdfLszERtd3T.0 No cache directive 21 Dec 2011 11:22:29,445 CST DEBUG [org.teiid.PROCESSOR] (Worker11_QueryProcessorQueue39) tdfLszERtd3T.0 executing select * from chorus_metadata.property 21 Dec 2011 11:22:29,447 CST INFO [org.teiid.PLANNER] (Worker11_QueryProcessorQueue39) ============================================================================ USER COMMAND: SELECT * FROM chorus_metadata.property ---------------------------------------------------------------------------- OPTIMIZE: SELECT * FROM chorus_metadata.property ---------------------------------------------------------------------------- GENERATE CANONICAL: SELECT * FROM chorus_metadata.property 21 Dec 2011 11:22:29,447 CST DEBUG [org.teiid.PROCESSOR] (Worker11_QueryProcessorQueue39) Request Thread tdfLszERtd3T.0 - error occurred [QueryPlannerException]Group does not exist: chorus_metadata.property_CHORUS_NON_MAT_VIEW 1 [QueryResolverException]Group does not exist: chorus_metadata.property_CHORUS_NON_MAT_VIEW at org.teiid.query.optimizer.relational.RelationalPlanner.optimize(RelationalPlanner.java:232) at org.teiid.query.optimizer.QueryOptimizer.optimizePlan(QueryOptimizer.java:190) at org.teiid.dqp.internal.process.Request.generatePlan(Request.java:436) at org.teiid.dqp.internal.process.Request.processRequest(Request.java:459) at org.teiid.dqp.internal.process.RequestWorkItem.processNew(RequestWorkItem.java:506) at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:276) 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$Worker.runTask(ThreadPoolExecutor.java:886) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) at java.lang.Thread.run(Thread.java:662) Caused by: [QueryResolverException]Group does not exist: chorus_metadata.property_CHORUS_NON_MAT_VIEW at org.teiid.query.resolver.util.ResolverUtil.handleUnresolvedGroup(ResolverUtil.java:834) at org.teiid.query.resolver.util.ResolverUtil.resolveGroup(ResolverUtil.java:921) at org.teiid.query.resolver.QueryResolver.isXMLQuery(QueryResolver.java:372) at org.teiid.query.resolver.QueryResolver.chooseResolver(QueryResolver.java:317) at org.teiid.query.resolver.QueryResolver.resolveCommand(QueryResolver.java:291) at org.teiid.query.resolver.QueryResolver.resolveView(QueryResolver.java:457) at org.teiid.query.tempdata.GlobalTableStoreImpl.updateCacheHint(GlobalTableStoreImpl.java:259) at org.teiid.query.tempdata.GlobalTableStoreImpl.getGlobalTempTableMetadataId(GlobalTableStoreImpl.java:228) at org.teiid.query.optimizer.relational.RelationalPlanner.resolveVirtualGroup(RelationalPlanner.java:1267) at org.teiid.query.optimizer.relational.RelationalPlanner.buildTree(RelationalPlanner.java:870) at org.teiid.query.optimizer.relational.RelationalPlanner.createQueryPlan(RelationalPlanner.java:771) at org.teiid.query.optimizer.relational.RelationalPlanner.createQueryPlan(RelationalPlanner.java:730) at org.teiid.query.optimizer.relational.RelationalPlanner.generatePlan(RelationalPlanner.java:525) at org.teiid.query.optimizer.relational.RelationalPlanner.optimize(RelationalPlanner.java:230) ... 13 more 21 Dec 2011 11:22:29,447 CST DEBUG [org.teiid.COMMAND_LOG] (Worker11_QueryProcessorQueue39) ERROR USER COMMAND: endTime=2011-12-21 11:22:29.447 requestID=tdfLszERtd3T.0 txID=null sessionID=tdfLszERtd3T principal=admin@teiid-security vdbName=Chorus vdbVersion=1 finalRowCount=null 21 Dec 2011 11:22:29,448 CST WARN [org.teiid.PROCESSOR] (Worker11_QueryProcessorQueue39) Processing exception 'Group does not exist: chorus_metadata.property_CHORUS_NON_MAT_VIEW' for request tdfLszERtd3T.0. Exception type org.teiid.api.exception.query.QueryPlannerException thrown from org.teiid.query.resolver.util.ResolverUtil.handleUnresolvedGroup(ResolverUtil.java:834). Enable more detailed logging to see the entire stacktrace. 21 Dec 2011 11:22:29,449 CST DEBUG [org.teiid.PROCESSOR] (Worker11_QueryProcessorQueue39) Sending error to client tdfLszERtd3T.0 [QueryPlannerException]Group does not exist: chorus_metadata.property_CHORUS_NON_MAT_VIEW 1 [QueryResolverException]Group does not exist: chorus_metadata.property_CHORUS_NON_MAT_VIEW at org.teiid.query.optimizer.relational.RelationalPlanner.optimize(RelationalPlanner.java:232) at org.teiid.query.optimizer.QueryOptimizer.optimizePlan(QueryOptimizer.java:190) at org.teiid.dqp.internal.process.Request.generatePlan(Request.java:436) at org.teiid.dqp.internal.process.Request.processRequest(Request.java:459) at org.teiid.dqp.internal.process.RequestWorkItem.processNew(RequestWorkItem.java:506) at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:276) 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$Worker.runTask(ThreadPoolExecutor.java:886) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) at java.lang.Thread.run(Thread.java:662) Caused by: [QueryResolverException]Group does not exist: chorus_metadata.property_CHORUS_NON_MAT_VIEW at org.teiid.query.resolver.util.ResolverUtil.handleUnresolvedGroup(ResolverUtil.java:834) at org.teiid.query.resolver.util.ResolverUtil.resolveGroup(ResolverUtil.java:921) at org.teiid.query.resolver.QueryResolver.isXMLQuery(QueryResolver.java:372) at org.teiid.query.resolver.QueryResolver.chooseResolver(QueryResolver.java:317) at org.teiid.query.resolver.QueryResolver.resolveCommand(QueryResolver.java:291) at org.teiid.query.resolver.QueryResolver.resolveView(QueryResolver.java:457) at org.teiid.query.tempdata.GlobalTableStoreImpl.updateCacheHint(GlobalTableStoreImpl.java:259) at org.teiid.query.tempdata.GlobalTableStoreImpl.getGlobalTempTableMetadataId(GlobalTableStoreImpl.java:228) at org.teiid.query.optimizer.relational.RelationalPlanner.resolveVirtualGroup(RelationalPlanner.java:1267) at org.teiid.query.optimizer.relational.RelationalPlanner.buildTree(RelationalPlanner.java:870) at org.teiid.query.optimizer.relational.RelationalPlanner.createQueryPlan(RelationalPlanner.java:771) at org.teiid.query.optimizer.relational.RelationalPlanner.createQueryPlan(RelationalPlanner.java:730) at org.teiid.query.optimizer.relational.RelationalPlanner.generatePlan(RelationalPlanner.java:525) at org.teiid.query.optimizer.relational.RelationalPlanner.optimize(RelationalPlanner.java:230) ... 13 more 21 Dec 2011 11:22:29,453 CST DEBUG [org.teiid.TRANSPORT] (Worker11_QueryProcessorQueue39) message: MessageHolder: contents=ResultsMessage rowCount=0 finalRow=-1 for message:650 21 Dec 2011 11:22:29,486 CST DEBUG [org.teiid.TRANSPORT] (New I/O server worker #1-1) processing message:MessageHolder: contents=org.teiid.net.socket.ServiceInvocationStruct@1b52d01a 21 Dec 2011 11:22:29,486 CST DEBUG [org.teiid.SECURITY] (New I/O server worker #1-1) closeSession tdfLszERtd3T 21 Dec 2011 11:22:29,486 CST DEBUG [org.teiid.TXN_LOG] (New I/O server worker #1-1) before cancelTransactions:org.teiid.dqp.internal.process.TransactionServerImpl@24bf0ce(tdfLszERtd3T,false) 21 Dec 2011 11:22:29,486 CST DEBUG [org.teiid.TXN_LOG] (New I/O server worker #1-1) after cancelTransactions : null 21 Dec 2011 11:22:29,487 CST DEBUG [org.teiid.TRANSPORT] (New I/O server worker #1-1) message: MessageHolder: contents=null for message:651