21 Dec 2011 11:03:32,408 CST INFO [com.ca.chorus.server.teiid.bootstrap.TeiidBootstrap] (pool-6-thread-1) Eagerly loading materialized views 21 Dec 2011 11:03:37,408 CST DEBUG [org.teiid.SECURITY] (pool-6-thread-1) authenticateUser admin JDBC 21 Dec 2011 11:03:37,410 CST DEBUG [org.teiid.SECURITY] (pool-6-thread-1) Logon successful, created session: sessionid=JgniNnZ0ZmY+; userName=admin@teiid-security; vdbName=Chorus; vdbVersion=1; createdTime=Wed Dec 21 11:03:37 CST 2011; applicationName=JDBC; clientHostName=null; clientHardwareAddress=null; IPAddress=null; securityDomain=teiid-security; lastPingTime=Wed Dec 21 11:03:37 CST 2011 21 Dec 2011 11:03:37,410 CST FINE [org.teiid.jdbc] (pool-6-thread-1) Successfully obtained a session. 21 Dec 2011 11:03:37,411 CST FINE [org.teiid.jdbc] (pool-6-thread-1) Connection Url=jdbc:teiid:Chorus;PassthroughAuthentication=false;fetchSize=2048;ApplicationName=JDBC;user=admin;password=***;;VirtualDatabaseName=Chorus 21 Dec 2011 11:03:37,411 CST FINE [org.teiid.jdbc] (pool-6-thread-1) PassthroughAuthentication=false 21 Dec 2011 11:03:37,411 CST FINE [org.teiid.jdbc] (pool-6-thread-1) fetchSize=2048 21 Dec 2011 11:03:37,411 CST FINE [org.teiid.jdbc] (pool-6-thread-1) ApplicationName=JDBC 21 Dec 2011 11:03:37,411 CST FINE [org.teiid.jdbc] (pool-6-thread-1) user=admin 21 Dec 2011 11:03:37,411 CST FINE [org.teiid.jdbc] (pool-6-thread-1) VirtualDatabaseName=Chorus 21 Dec 2011 11:03:37,411 CST FINE [org.teiid.jdbc] (pool-6-thread-1) The JDBC Driver successfully obtained a connection. 21 Dec 2011 11:03:37,413 CST DEBUG [org.teiid.COMMAND_LOG] (pool-6-thread-1) START USER COMMAND: startTime=2011-12-21 11:03:37.413 requestID=JgniNnZ0ZmY+.0 txID=null sessionID=JgniNnZ0ZmY+ applicationName=JDBC principal=admin@teiid-security vdbName=Chorus vdbVersion=1 sql=select SchemaName, Name from sys.tables where isMaterialized=true and isSystem=false 21 Dec 2011 11:03:37,413 CST DEBUG [org.teiid.PROCESSOR] (pool-6-thread-1) Request Thread JgniNnZ0ZmY+.0 with state NEW 21 Dec 2011 11:03:37,413 CST DEBUG [org.teiid.PROCESSOR] (pool-6-thread-1) JgniNnZ0ZmY+.0 No cache directive 21 Dec 2011 11:03:37,413 CST DEBUG [org.teiid.PROCESSOR] (pool-6-thread-1) JgniNnZ0ZmY+.0 executing prepared select SchemaName, Name from sys.tables where isMaterialized=true and isSystem=false 21 Dec 2011 11:03:37,415 CST DEBUG [org.teiid.PROCESSOR] (pool-6-thread-1) ProcessTree for JgniNnZ0ZmY+.0 ProjectNode(0) output=[SchemaName, Name] [SchemaName, Name] SelectNode(1) output=[SchemaName, Name] (isSystem = FALSE) AND (isMaterialized = TRUE) ProjectNode(3) output=[isSystem, isMaterialized, SchemaName, Name] [isSystem, isMaterialized, SchemaName, Name] AccessNode(2) output=[sys.tables.VDBName, sys.tables.SchemaName, sys.tables.Name, sys.tables.Type, sys.tables.NameInSource, sys.tables.IsPhysical, sys.tables.SupportsUpdates, sys.tables.UID, sys.tables.Cardinality, sys.tables.Description, sys.tables.IsSystem, sys.tables.IsMaterialized, sys.tables.OID] SELECT sys.tables.isSystem, sys.tables.isMaterialized, sys.tables.SchemaName, sys.tables.Name FROM sys.tables 21 Dec 2011 11:03:37,416 CST DEBUG [org.teiid.TXN_LOG] (pool-6-thread-1) before getOrCreateTransactionContext:org.teiid.dqp.internal.process.TransactionServerImpl@24bf0ce(JgniNnZ0ZmY+) 21 Dec 2011 11:03:37,416 CST DEBUG [org.teiid.TXN_LOG] (pool-6-thread-1) after getOrCreateTransactionContext : JgniNnZ0ZmY+ NONE ID:NONE 21 Dec 2011 11:03:37,416 CST DEBUG [org.teiid.BUFFER_MGR] (pool-6-thread-1) Creating TupleBuffer: 65 [SchemaName, Name] [class java.lang.String, class java.lang.String] of type PROCESSOR 21 Dec 2011 11:03:37,417 CST DEBUG [org.teiid.PROCESSOR] (pool-6-thread-1) QueryProcessor: closing processor 21 Dec 2011 11:03:37,417 CST DEBUG [org.teiid.PROCESSOR] (pool-6-thread-1) [RequestWorkItem.sendResultsIfNeeded] requestID: JgniNnZ0ZmY+.0 resultsID: 65 done: true 21 Dec 2011 11:03:37,417 CST FINE [org.teiid.jdbc] (pool-6-thread-1) Successfully executed a query select SchemaName, Name from sys.tables where isMaterialized=true and isSystem=false and obtained results 21 Dec 2011 11:03:37,419 CST DEBUG [org.teiid.COMMAND_LOG] (pool-6-thread-1) START USER COMMAND: startTime=2011-12-21 11:03:37.419 requestID=JgniNnZ0ZmY+.1 txID=null sessionID=JgniNnZ0ZmY+ applicationName=JDBC principal=admin@teiid-security vdbName=Chorus vdbVersion=1 sql=CALL SYSADMIN.refreshMatView(viewname=>?, invalidate=>?) 21 Dec 2011 11:03:37,420 CST DEBUG [org.teiid.PROCESSOR] (pool-6-thread-1) Request Thread JgniNnZ0ZmY+.1 with state NEW 21 Dec 2011 11:03:37,420 CST DEBUG [org.teiid.PROCESSOR] (pool-6-thread-1) JgniNnZ0ZmY+.1 No cache directive 21 Dec 2011 11:03:37,420 CST DEBUG [org.teiid.PROCESSOR] (pool-6-thread-1) JgniNnZ0ZmY+.1 executing prepared CALL SYSADMIN.refreshMatView(viewname=>?, invalidate=>?) 21 Dec 2011 11:03:37,421 CST DEBUG [org.teiid.PROCESSOR] (pool-6-thread-1) ProcessTree for JgniNnZ0ZmY+.1 ProjectNode(0) output=[SYSADMIN.refreshMatView.RowsUpdated] [SYSADMIN.refreshMatView.RowsUpdated] AccessNode(1) output=[SYSADMIN.refreshMatView.RowsUpdated] EXEC SYSADMIN.refreshMatView(?, ?) 21 Dec 2011 11:03:37,421 CST DEBUG [org.teiid.TXN_LOG] (pool-6-thread-1) before getOrCreateTransactionContext:org.teiid.dqp.internal.process.TransactionServerImpl@24bf0ce(JgniNnZ0ZmY+) 21 Dec 2011 11:03:37,421 CST DEBUG [org.teiid.TXN_LOG] (pool-6-thread-1) after getOrCreateTransactionContext : JgniNnZ0ZmY+ NONE ID:NONE 21 Dec 2011 11:03:37,421 CST DEBUG [org.teiid.BUFFER_MGR] (pool-6-thread-1) Creating TupleBuffer: 66 [SYSADMIN.refreshMatView.RowsUpdated] [class java.lang.Integer] of type PROCESSOR 21 Dec 2011 11:03:37,426 CST DEBUG [org.teiid.PROCESSOR] (pool-6-thread-1) QueryProcessor: closing processor 21 Dec 2011 11:03:37,426 CST DEBUG [org.teiid.PROCESSOR] (pool-6-thread-1) Request Thread JgniNnZ0ZmY+.1 - error occurred [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.tempdata.TempTableDataManager.handleSystemProcedures(TempTableDataManager.java:283) at org.teiid.query.tempdata.TempTableDataManager.registerRequest(TempTableDataManager.java:154) at org.teiid.query.tempdata.TempTableDataManager.registerRequest(TempTableDataManager.java:133) at org.teiid.query.processor.relational.AccessNode.registerRequest(AccessNode.java:367) at org.teiid.query.processor.relational.AccessNode.open(AccessNode.java:156) at org.teiid.query.processor.relational.RelationalNode.open(RelationalNode.java:255) at org.teiid.query.processor.relational.RelationalPlan.open(RelationalPlan.java:167) at org.teiid.query.processor.QueryProcessor.init(QueryProcessor.java:182) at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:126) 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.DQPCore.executeRequest(DQPCore.java:386) at sun.reflect.GeneratedMethodAccessor347.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.teiid.logging.LogManager$LoggingProxy.invoke(LogManager.java:121) at org.teiid.jboss.deployers.RuntimeEngineDeployer$3.invoke(RuntimeEngineDeployer.java:388) at $Proxy304.executeRequest(Unknown Source) at sun.reflect.GeneratedMethodAccessor347.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.teiid.transport.LocalServerConnection$1$1.call(LocalServerConnection.java:112) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) at java.util.concurrent.FutureTask.run(FutureTask.java:138) at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:232) at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:220) at org.teiid.transport.LocalServerConnection$1.invoke(LocalServerConnection.java:110) at $Proxy304.executeRequest(Unknown Source) at org.teiid.jdbc.StatementImpl.execute(StatementImpl.java:592) at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:531) at org.teiid.jdbc.PreparedStatementImpl.execute(PreparedStatementImpl.java:211) at com.ca.chorus.db.DbExecutor$10.call(DbExecutor.java:427) at com.ca.chorus.db.DbExecutor$10.call(DbExecutor.java:414) at com.ca.chorus.aop.guice.IPerfTracer$1.trace(IPerfTracer.java:25) at com.ca.chorus.db.DbExecutor.execute(DbExecutor.java:413) at com.ca.chorus.db.DbExecutor.execute(DbExecutor.java:407) at com.ca.chorus.server.teiid.bootstrap.TeiidBootstrap$5.next(TeiidBootstrap.java:308) at com.ca.chorus.db.DbExecutor.withResultSet(DbExecutor.java:299) at com.ca.chorus.server.teiid.bootstrap.TeiidBootstrap.refreshMaterializedViews(TeiidBootstrap.java:298) at com.ca.chorus.server.teiid.bootstrap.TeiidBootstrap.run(TeiidBootstrap.java:276) at com.ca.chorus.extension.ServiceStarter.call(ServiceStarter.java:94) at com.ca.chorus.server.startup.ChorusPrimordialJbossBean$1.call(ChorusPrimordialJbossBean.java:96) at com.ca.chorus.server.startup.ChorusPrimordialJbossBean$1.call(ChorusPrimordialJbossBean.java:92) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) at java.util.concurrent.FutureTask.run(FutureTask.java:138) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:98) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:206) 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) 21 Dec 2011 11:03:37,429 CST DEBUG [org.teiid.COMMAND_LOG] (pool-6-thread-1) ERROR USER COMMAND: endTime=2011-12-21 11:03:37.429 requestID=JgniNnZ0ZmY+.1 txID=null sessionID=JgniNnZ0ZmY+ principal=admin@teiid-security vdbName=Chorus vdbVersion=1 finalRowCount=null 21 Dec 2011 11:03:37,429 CST WARN [org.teiid.PROCESSOR] (pool-6-thread-1) Processing exception 'Group does not exist: chorus_metadata.property_CHORUS_NON_MAT_VIEW' for request JgniNnZ0ZmY+.1. Exception type org.teiid.api.exception.query.QueryResolverException 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:03:37,429 CST DEBUG [org.teiid.PROCESSOR] (pool-6-thread-1) Removing tuplesource for the request JgniNnZ0ZmY+.1 21 Dec 2011 11:03:37,429 CST DEBUG [org.teiid.BUFFER_MGR] (pool-6-thread-1) Removing TupleBuffer: 66 21 Dec 2011 11:03:37,429 CST DEBUG [org.teiid.PROCESSOR] (pool-6-thread-1) Sending error to client JgniNnZ0ZmY+.1 [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.tempdata.TempTableDataManager.handleSystemProcedures(TempTableDataManager.java:283) at org.teiid.query.tempdata.TempTableDataManager.registerRequest(TempTableDataManager.java:154) at org.teiid.query.tempdata.TempTableDataManager.registerRequest(TempTableDataManager.java:133) at org.teiid.query.processor.relational.AccessNode.registerRequest(AccessNode.java:367) at org.teiid.query.processor.relational.AccessNode.open(AccessNode.java:156) at org.teiid.query.processor.relational.RelationalNode.open(RelationalNode.java:255) at org.teiid.query.processor.relational.RelationalPlan.open(RelationalPlan.java:167) at org.teiid.query.processor.QueryProcessor.init(QueryProcessor.java:182) at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:126) 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.DQPCore.executeRequest(DQPCore.java:386) at sun.reflect.GeneratedMethodAccessor347.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.teiid.logging.LogManager$LoggingProxy.invoke(LogManager.java:121) at org.teiid.jboss.deployers.RuntimeEngineDeployer$3.invoke(RuntimeEngineDeployer.java:388) at $Proxy304.executeRequest(Unknown Source) at sun.reflect.GeneratedMethodAccessor347.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.teiid.transport.LocalServerConnection$1$1.call(LocalServerConnection.java:112) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) at java.util.concurrent.FutureTask.run(FutureTask.java:138) at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:232) at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:220) at org.teiid.transport.LocalServerConnection$1.invoke(LocalServerConnection.java:110) at $Proxy304.executeRequest(Unknown Source) at org.teiid.jdbc.StatementImpl.execute(StatementImpl.java:592) at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:531) at org.teiid.jdbc.PreparedStatementImpl.execute(PreparedStatementImpl.java:211) at com.ca.chorus.db.DbExecutor$10.call(DbExecutor.java:427) at com.ca.chorus.db.DbExecutor$10.call(DbExecutor.java:414) at com.ca.chorus.aop.guice.IPerfTracer$1.trace(IPerfTracer.java:25) at com.ca.chorus.db.DbExecutor.execute(DbExecutor.java:413) at com.ca.chorus.db.DbExecutor.execute(DbExecutor.java:407) at com.ca.chorus.server.teiid.bootstrap.TeiidBootstrap$5.next(TeiidBootstrap.java:308) at com.ca.chorus.db.DbExecutor.withResultSet(DbExecutor.java:299) at com.ca.chorus.server.teiid.bootstrap.TeiidBootstrap.refreshMaterializedViews(TeiidBootstrap.java:298) at com.ca.chorus.server.teiid.bootstrap.TeiidBootstrap.run(TeiidBootstrap.java:276) at com.ca.chorus.extension.ServiceStarter.call(ServiceStarter.java:94) at com.ca.chorus.server.startup.ChorusPrimordialJbossBean$1.call(ChorusPrimordialJbossBean.java:96) at com.ca.chorus.server.startup.ChorusPrimordialJbossBean$1.call(ChorusPrimordialJbossBean.java:92) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) at java.util.concurrent.FutureTask.run(FutureTask.java:138) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:98) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:206) 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) 21 Dec 2011 11:03:37,432 CST FINE [org.teiid.jdbc] (pool-6-thread-1) Statement closed successfully. 21 Dec 2011 11:03:37,433 CST DEBUG [org.teiid.PROCESSOR] (pool-6-thread-1) closeQuery for requestID=JgniNnZ0ZmY+.0 21 Dec 2011 11:03:37,433 CST DEBUG [org.teiid.PROCESSOR] (pool-6-thread-1) Restarting processing using the calling thread JgniNnZ0ZmY+.0 21 Dec 2011 11:03:37,433 CST DEBUG [org.teiid.PROCESSOR] (pool-6-thread-1) Request Thread JgniNnZ0ZmY+.0 with state PROCESSING 21 Dec 2011 11:03:37,433 CST DEBUG [org.teiid.PROCESSOR] (pool-6-thread-1) Removing tuplesource for the request JgniNnZ0ZmY+.0 21 Dec 2011 11:03:37,433 CST DEBUG [org.teiid.BUFFER_MGR] (pool-6-thread-1) Removing TupleBuffer: 65 21 Dec 2011 11:03:37,433 CST DEBUG [org.teiid.COMMAND_LOG] (pool-6-thread-1) END USER COMMAND: endTime=2011-12-21 11:03:37.433 requestID=JgniNnZ0ZmY+.0 txID=null sessionID=JgniNnZ0ZmY+ principal=admin@teiid-security vdbName=Chorus vdbVersion=1 finalRowCount=0 21 Dec 2011 11:03:37,433 CST FINE [org.teiid.jdbc] (pool-6-thread-1) Statement closed successfully. 21 Dec 2011 11:03:37,433 CST DEBUG [com.ca.chorus.server.teiid.bootstrap.TeiidBootstrap] (pool-6-thread-1) Error:java.lang.Exception: Exception java.lang.Exception: Exception org.teiid.jdbc.TeiidSQLException: Group does not exist: chorus_metadata.property_CHORUS_NON_MAT_VIEW occurred on statement CALL SYSADMIN.refreshMatView(viewname=>?, invalidate=>?) occurred on statement select SchemaName, Name from sys.tables where isMaterialized=true and isSystem=false 21 Dec 2011 11:03:37,434 CST DEBUG [org.teiid.SECURITY] (pool-6-thread-1) closeSession JgniNnZ0ZmY+ 21 Dec 2011 11:03:37,434 CST DEBUG [org.teiid.TXN_LOG] (pool-6-thread-1) before cancelTransactions:org.teiid.dqp.internal.process.TransactionServerImpl@24bf0ce(JgniNnZ0ZmY+,false) 21 Dec 2011 11:03:37,434 CST DEBUG [org.teiid.TXN_LOG] (pool-6-thread-1) after cancelTransactions : null 21 Dec 2011 11:03:37,434 CST FINE [org.teiid.jdbc] (pool-6-thread-1) Connection successfully closed. 21 Dec 2011 11:03:37,434 CST INFO [com.ca.chorus.server.teiid.bootstrap.TeiidBootstrap] (pool-6-thread-1) Teiid bootstrap procedure completed