-
1. Re: Internal Materialized Views
klsateesh May 15, 2012 1:25 PM (in response to klsateesh)As per the documentation for Teiid Designer 7.7 one should be able to create a Materialzied by doing:
Right-click on one or more view tables in the Section 10.2.1, “Model Explorer View” and select the Modeling > Create Materialized Views action.
How ever when i right click on the BaseTables i have created in by VDB or right click on any of the new Siblings i have created out of those "BaseTables" i only see the option of "Creating Web Service" as shown below.
Thanks
Sateesh
-
-
3. Re: Internal Materialized Views
klsateesh May 15, 2012 2:39 PM (in response to rareddy)Hi Ramesh,
Thanks for the info.
I cannot edit the property "Materialized" for any of the Tables in my Model. I can change the values of other properties (Materialized Table, System, Supports Update, Name In Source etc) without any Problems.
when i doubel click on that cell nothing happens.It seems it is read only.
It is mentioned in that article that Materialization is not allowed on Dynamic VDBs. But the one i created using the Designer is not Dynamic.
Not sure why i cannot edit this property !!
Thanks
Sateesh -
4. Re: Internal Materialized Views
rareddy May 15, 2012 2:44 PM (in response to klsateesh)Sateesh,
Materialization is only allowed on View (tables in view model) tables, not on source tables(tables in source model). In 8.0, materialization in Dynamic VDBs also supported however you must define the metadata for for your VDB using DDL.
Ramesh..
-
5. Re: Internal Materialized Views
klsateesh May 15, 2012 4:10 PM (in response to rareddy)Hi Ramesh,
Thanks for your help.
I created a View Model and able to transform the Model Elements from Source Model to View Model and able to set the Materialize property to true for all the Tables.
When i validate the Model in Designer it says no Errors.
How ever when i deploy the newly created .vdb to JBoss AS then i am seeing the following Errors in the console.
15:46:16,732 INFO [org.jboss.as.server] (DeploymentScanner-threads - 1) JBAS018565: Replaced deployment "ViewModel.vdb" with deployment "ViewModel.vdb"
15:46:16,732 INFO [org.teiid.RUNTIME] (teiid-async-threads - 1) TEIID50030 VDB PREVIEW_6214b956-7884-4cac-a010-0cfdd2c5bd18_MyTeiidProject_schemas_ViewModel.1 model "ViewModel" metadata loaded. End Time: 5/15/12 3:46 PM
15:46:16,732 INFO [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 1) TEIID31080 View ViewModel.SCHEMA_NAME.TABLE1 validation error: [QueryResolverException]Group does not exist: DHS2D_NEW.SCHEMA_NAME.TABLE1
15:46:16,872 INFO [org.teiid.RUNTIME] (teiid-async-threads - 1) TEIID40073 The metadata for the VDB PREVIEW_6214b956-7884-4cac-a010-0cfdd2c5bd18_MyTeiidProject_schemas_ViewModel.1 is loaded, however it is not valid. Check models for errors. Correct the metadata and re-deploy.
15:46:16,872 INFO [org.teiid.RUNTIME] (teiid-async-threads - 1) TEIID40006 VDB PREVIEW_6214b956-7884-4cac-a010-0cfdd2c5bd18_MyTeiidProject_schemas_ViewModel.1 is set to "inactive".
When i checked the View Model and Select the Specific Table to view the Query that's beeen used to created the Table (in View Model).
SELECT
*
FROM
DHS2D_NEW.SCHEMA_NAME.TABLE1
The Validation Erros JBoss is complaining about are because i used the same name in Source and View Model ?? I tried changing the name but got the same error..
And when i clicked on "Validate Transformations" on the View Model it didn't return any errors..
Thanks
Sateesh
-
6. Re: Internal Materialized Views
klsateesh May 15, 2012 5:06 PM (in response to klsateesh)Hi,
I am able to resolve the validation error by creating a new VDB and adding the Source and View Model to it and deploying the newly created VDB.
How ever when i tried to run the Queries asgainst the View Model there seems to be some ambiguity in the group name.
17:00:03,465 INFO [org.teiid.RUNTIME] (MSC service thread 1-1) TEIID50029 VDB FinalVDB.1 model "DHS2D_NEW" metadata is currently being loaded. Start Time: 5/15/12 5:00 PM
17:00:03,471 INFO [org.teiid.RUNTIME] (MSC service thread 1-1) TEIID50029 VDB FinalVDB.1 model "ViewModel" metadata is currently being loaded. Start Time: 5/15/12 5:00 PM
17:00:03,544 INFO [org.teiid.RUNTIME] (teiid-async-threads - 2) TEIID50030 VDB FinalVDB.1 model "DHS2D_NEW" metadata loaded. End Time: 5/15/12 5:00 PM
17:00:03,544 INFO [org.teiid.RUNTIME] (teiid-async-threads - 3) TEIID50030 VDB FinalVDB.1 model "ViewModel" metadata loaded. End Time: 5/15/12 5:00 PM
17:00:03,555 INFO [org.jboss.as.server] (DeploymentScanner-threads - 2) JBAS018565: Replaced deployment "FinalVDB.vdb" with deployment "FinalVDB.vdb"
17:00:03,575 INFO [org.teiid.RUNTIME] (teiid-async-threads - 3) TEIID40003 VDB FinalVDB.1 is set to "active"
17:00:33,398 WARN [org.teiid.PROCESSOR] (Worker6_QueryProcessorQueue31) TEIID30020 Processing exception 'Group specified is ambiguous, resubmit the query by fully qualifying the group name:SCHEMA_NAME.TABLE1' for request CXfcT+xOjEwL.0. Exception type org.teiid.api.excep
tion.query.QueryResolverException thrown from org.teiid.query.resolver.util.ResolverUtil.handleUnresolvedGroup(ResolverUtil.java:779). Enable more detailed logging to see the entire stacktrace.
17:00:58,808 ERROR [org.teiid.PROCESSOR] (Worker6_QueryProcessorQueue32) TEIID30019 Unexpected exception for request 8waFyQR1nfVn.0: java.lang.NullPointerException
at org.teiid.query.optimizer.relational.RelationalPlanner.resolveVirtualGroup(RelationalPlanner.java:1233) [teiid-engine-8.0.0.Final.jar:8.0.0.Final]
at org.teiid.query.optimizer.relational.RelationalPlanner.buildTree(RelationalPlanner.java:836) [teiid-engine-8.0.0.Final.jar:8.0.0.Final]
at org.teiid.query.optimizer.relational.RelationalPlanner.createQueryPlan(RelationalPlanner.java:737) [teiid-engine-8.0.0.Final.jar:8.0.0.Final]
at org.teiid.query.optimizer.relational.RelationalPlanner.createQueryPlan(RelationalPlanner.java:696) [teiid-engine-8.0.0.Final.jar:8.0.0.Final]
at org.teiid.query.optimizer.relational.RelationalPlanner.generatePlan(RelationalPlanner.java:490) [teiid-engine-8.0.0.Final.jar:8.0.0.Final]
at org.teiid.query.optimizer.relational.RelationalPlanner.optimize(RelationalPlanner.java:180) [teiid-engine-8.0.0.Final.jar:8.0.0.Final]
at org.teiid.query.optimizer.QueryOptimizer.optimizePlan(QueryOptimizer.java:188) [teiid-engine-8.0.0.Final.jar:8.0.0.Final]
at org.teiid.dqp.internal.process.Request.generatePlan(Request.java:429) [teiid-engine-8.0.0.Final.jar:8.0.0.Final]
at org.teiid.dqp.internal.process.Request.processRequest(Request.java:449) [teiid-engine-8.0.0.Final.jar:8.0.0.Final]
at org.teiid.dqp.internal.process.RequestWorkItem.processNew(RequestWorkItem.java:534) [teiid-engine-8.0.0.Final.jar:8.0.0.Final]
at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:278) [teiid-engine-8.0.0.Final.jar:8.0.0.Final]
at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:49) [teiid-engine-8.0.0.Final.jar:8.0.0.Final]
at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:217) [teiid-engine-8.0.0.Final.jar:8.0.0.Final]
at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:241) [teiid-engine-8.0.0.Final.jar:8.0.0.Final]
at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:118) [teiid-engine-8.0.0.Final.jar:8.0.0.Final]
at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:288) [teiid-engine-8.0.0.Final.jar:8.0.0.Final]
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:885) [rt.jar:1.6.0_05]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:907) [rt.jar:1.6.0_05]
Thanks
Sateesh -
7. Re: Internal Materialized Views
rareddy May 15, 2012 5:13 PM (in response to klsateesh)Use fully qualified names for tables like select * from "viewname"."tablename".
-
8. Re: Internal Materialized Views
klsateesh May 15, 2012 5:47 PM (in response to rareddy)Hi Ramesh,
Here is the VDB and the Model names in it.
VDB Name : FinalVDB.vdb
It has the Source Model "DSH2D_New.xmi" and the View Model "ViewModel.xml"
There is a table "SCHEMA_NAME.TABLE1" in Source Model "DSH2D_New.xmi"
<relational:BaseTable xmi:uuid="mmuuid:b751e716-ed1e-41fc-8661-eeb948076287" name="SCHEMA_NAME.TABLE1" nameInSource=""SCHEMA_NAME"."TABLE1"">
<columns xmi:uuid="mmuuid:5d4ea9e9-3bdb-4700-8591-a11c6ec2a94d" name="EMP_ID" nameInSource="EMP_ID" nativeType="VARCHAR2" length="33" nullable="NO_NULLS">
<type href="http://www.w3.org/2001/XMLSchema#string"/>
</columns>
<columns xmi:uuid="mmuuid:be27e861-b493-4c3a-88a1-ea55ba05c083" name="EMP_NAME" nameInSource="EMP_NAME" nativeType="VARCHAR2" length="4000">
<type href="http://www.w3.org/2001/XMLSchema#string"/>
</columns>
</relational:BaseTable>
The above Table is called TABLE1 in View Model which is defined using the following SQL:
SELECT * FROM DHS2D_NEW.SCHEMA_NAME.TABLE1
After successful deployment of FinalVDB.vdb (This is the only vdb file i am deploying to JBoss) My Client code succeeds only if the Table Name is DHS2D_NEW.SCHEMA_NAME.TABLE1
All the following are failing:
SELECT * FROM ViewModel.TABLE1 (Caused by: java.lang.NullPointerException at org.teiid.query.optimizer.relational.RelationalPlanner.resolveVirtualGroup(RelationalPlanner.java:1233))
SELECT * FROM FinalVDB.TABLE1 ( Group does not exist: FinalVDB.TABLE1)
SELECT * FROM TABLE1 (Succeeds) It looks like i don't need to preced this with View Name !!.
I hope the Query against Table DHS2D_NEW.SCHEMA_NAME.TABLE1 goes to the Table in Oracle where as the one against TABLE1 is going against the Cached Materialized View in Teiid.
Thanks
Sateesh -
9. Re: Internal Materialized Views
rareddy May 16, 2012 8:13 AM (in response to klsateesh)Sateesh,
Any of these forms are correct.
- select * from <vdb-name>.<model-name>.<table-name>
- select * from <model-name>.<table-name>
- select * from <table-name>
If there are same named table in multiple models, then only 1 or 2 are allowed, otherwise 1, 2 and 3 is allowed.
This is wrong
select * from <vdb-name>.<table-name>
Given that, show us the full exception from
SELECT * FROM ViewModel.TABLE1 (Caused by: java.lang.NullPointerException at org.teiid.query.optimizer.relational.RelationalPlanner.resolveVirtualGroup(RelationalPlanner.java:1233))
this should have succeeded.
Ramesh..
-
10. Re: Internal Materialized Views
klsateesh May 16, 2012 10:31 AM (in response to rareddy)Hi Ramesh,
Here is the complete stack trace from Server Log.
10:22:23,456 DEBUG [org.teiid.TRANSPORT] (New I/O server worker #1-1) processing message:MessageHolder: contents=org.teiid.net.socket.ServiceInvocationStruct@5d661c
10:22:23,468 DEBUG [org.teiid.SECURITY] (New I/O server worker #1-1) authenticateUser user JDBC
10:22:23,508 DEBUG [org.teiid.SECURITY] (New I/O server worker #1-1) Logon successful for " user "
10:22:23,512 DEBUG [org.teiid.SECURITY] (New I/O server worker #1-1) Logon successful, created session: sessionid=DCZLrQHFkxwY; userName=user@teiid-security; vdbName=FinalVDB; vdbVersion=1; createdTime=Wed May 16 10:22:23 EDT 2012; applicationName=JDBC; clientHostName=2SRDBM1; clientHardwareAddress=0024D69C272A; IPAddress=127.0.0.1; securityDomain=teiid-security; lastPingTime=Wed May 16 10:22:23 EDT 2012
10:22:23,524 DEBUG [org.teiid.TRANSPORT] (New I/O server worker #1-1) message: MessageHolder: contents=org.teiid.client.security.LogonResult@1c1e97f for message:0
10:22:23,577 DEBUG [org.teiid.TRANSPORT] (New I/O server worker #1-1) processing message:MessageHolder: contents=org.teiid.net.socket.ServiceInvocationStruct@cf601c
10:22:23,593 DEBUG [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue0) Request Thread DCZLrQHFkxwY.0 with state NEW
10:22:23,597 DEBUG [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue0) DCZLrQHFkxwY.0 Non-cachable command.
10:22:23,600 DEBUG [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue0) DCZLrQHFkxwY.0 executing SELECT COUNT(*) FROM ViewModel.TABLE1
10:22:23,657 DEBUG [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue0) Request Thread DCZLrQHFkxwY.0 - error occurred: java.lang.NullPointerException
at org.teiid.query.optimizer.relational.RelationalPlanner.resolveVirtualGroup(RelationalPlanner.java:1233) [teiid-engine-8.0.0.Final.jar:8.0.0.Final]
at org.teiid.query.optimizer.relational.RelationalPlanner.buildTree(RelationalPlanner.java:836) [teiid-engine-8.0.0.Final.jar:8.0.0.Final]
at org.teiid.query.optimizer.relational.RelationalPlanner.createQueryPlan(RelationalPlanner.java:737) [teiid-engine-8.0.0.Final.jar:8.0.0.Final]
at org.teiid.query.optimizer.relational.RelationalPlanner.createQueryPlan(RelationalPlanner.java:696) [teiid-engine-8.0.0.Final.jar:8.0.0.Final]
at org.teiid.query.optimizer.relational.RelationalPlanner.generatePlan(RelationalPlanner.java:490) [teiid-engine-8.0.0.Final.jar:8.0.0.Final]
at org.teiid.query.optimizer.relational.RelationalPlanner.optimize(RelationalPlanner.java:180) [teiid-engine-8.0.0.Final.jar:8.0.0.Final]
at org.teiid.query.optimizer.QueryOptimizer.optimizePlan(QueryOptimizer.java:188) [teiid-engine-8.0.0.Final.jar:8.0.0.Final]
at org.teiid.dqp.internal.process.Request.generatePlan(Request.java:429) [teiid-engine-8.0.0.Final.jar:8.0.0.Final]
at org.teiid.dqp.internal.process.Request.processRequest(Request.java:449) [teiid-engine-8.0.0.Final.jar:8.0.0.Final]
at org.teiid.dqp.internal.process.RequestWorkItem.processNew(RequestWorkItem.java:534) [teiid-engine-8.0.0.Final.jar:8.0.0.Final]
at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:278) [teiid-engine-8.0.0.Final.jar:8.0.0.Final]
at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:49) [teiid-engine-8.0.0.Final.jar:8.0.0.Final]
at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:217) [teiid-engine-8.0.0.Final.jar:8.0.0.Final]
at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:241) [teiid-engine-8.0.0.Final.jar:8.0.0.Final]
at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:118) [teiid-engine-8.0.0.Final.jar:8.0.0.Final]
at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:288) [teiid-engine-8.0.0.Final.jar:8.0.0.Final]
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:885) [rt.jar:1.6.0_05]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:907) [rt.jar:1.6.0_05]
at java.lang.Thread.run(Thread.java:619) [rt.jar:1.6.0_05]
10:22:23,733 ERROR [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue0) TEIID30019 Unexpected exception for request DCZLrQHFkxwY.0: java.lang.NullPointerException
at org.teiid.query.optimizer.relational.RelationalPlanner.resolveVirtualGroup(RelationalPlanner.java:1233) [teiid-engine-8.0.0.Final.jar:8.0.0.Final]
at org.teiid.query.optimizer.relational.RelationalPlanner.buildTree(RelationalPlanner.java:836) [teiid-engine-8.0.0.Final.jar:8.0.0.Final]
at org.teiid.query.optimizer.relational.RelationalPlanner.createQueryPlan(RelationalPlanner.java:737) [teiid-engine-8.0.0.Final.jar:8.0.0.Final]
at org.teiid.query.optimizer.relational.RelationalPlanner.createQueryPlan(RelationalPlanner.java:696) [teiid-engine-8.0.0.Final.jar:8.0.0.Final]
at org.teiid.query.optimizer.relational.RelationalPlanner.generatePlan(RelationalPlanner.java:490) [teiid-engine-8.0.0.Final.jar:8.0.0.Final]
at org.teiid.query.optimizer.relational.RelationalPlanner.optimize(RelationalPlanner.java:180) [teiid-engine-8.0.0.Final.jar:8.0.0.Final]
at org.teiid.query.optimizer.QueryOptimizer.optimizePlan(QueryOptimizer.java:188) [teiid-engine-8.0.0.Final.jar:8.0.0.Final]
at org.teiid.dqp.internal.process.Request.generatePlan(Request.java:429) [teiid-engine-8.0.0.Final.jar:8.0.0.Final]
at org.teiid.dqp.internal.process.Request.processRequest(Request.java:449) [teiid-engine-8.0.0.Final.jar:8.0.0.Final]
at org.teiid.dqp.internal.process.RequestWorkItem.processNew(RequestWorkItem.java:534) [teiid-engine-8.0.0.Final.jar:8.0.0.Final]
at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:278) [teiid-engine-8.0.0.Final.jar:8.0.0.Final]
at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:49) [teiid-engine-8.0.0.Final.jar:8.0.0.Final]
at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:217) [teiid-engine-8.0.0.Final.jar:8.0.0.Final]
at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:241) [teiid-engine-8.0.0.Final.jar:8.0.0.Final]
at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:118) [teiid-engine-8.0.0.Final.jar:8.0.0.Final]
at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:288) [teiid-engine-8.0.0.Final.jar:8.0.0.Final]
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:885) [rt.jar:1.6.0_05]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:907) [rt.jar:1.6.0_05]
at java.lang.Thread.run(Thread.java:619) [rt.jar:1.6.0_05]
10:22:23,860 DEBUG [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue0) Sending error to client DCZLrQHFkxwY.0: java.lang.NullPointerException
at org.teiid.query.optimizer.relational.RelationalPlanner.resolveVirtualGroup(RelationalPlanner.java:1233) [teiid-engine-8.0.0.Final.jar:8.0.0.Final]
at org.teiid.query.optimizer.relational.RelationalPlanner.buildTree(RelationalPlanner.java:836) [teiid-engine-8.0.0.Final.jar:8.0.0.Final]
at org.teiid.query.optimizer.relational.RelationalPlanner.createQueryPlan(RelationalPlanner.java:737) [teiid-engine-8.0.0.Final.jar:8.0.0.Final]
at org.teiid.query.optimizer.relational.RelationalPlanner.createQueryPlan(RelationalPlanner.java:696) [teiid-engine-8.0.0.Final.jar:8.0.0.Final]
at org.teiid.query.optimizer.relational.RelationalPlanner.generatePlan(RelationalPlanner.java:490) [teiid-engine-8.0.0.Final.jar:8.0.0.Final]
at org.teiid.query.optimizer.relational.RelationalPlanner.optimize(RelationalPlanner.java:180) [teiid-engine-8.0.0.Final.jar:8.0.0.Final]
at org.teiid.query.optimizer.QueryOptimizer.optimizePlan(QueryOptimizer.java:188) [teiid-engine-8.0.0.Final.jar:8.0.0.Final]
at org.teiid.dqp.internal.process.Request.generatePlan(Request.java:429) [teiid-engine-8.0.0.Final.jar:8.0.0.Final]
at org.teiid.dqp.internal.process.Request.processRequest(Request.java:449) [teiid-engine-8.0.0.Final.jar:8.0.0.Final]
at org.teiid.dqp.internal.process.RequestWorkItem.processNew(RequestWorkItem.java:534) [teiid-engine-8.0.0.Final.jar:8.0.0.Final]
at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:278) [teiid-engine-8.0.0.Final.jar:8.0.0.Final]
at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:49) [teiid-engine-8.0.0.Final.jar:8.0.0.Final]
at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:217) [teiid-engine-8.0.0.Final.jar:8.0.0.Final]
at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:241) [teiid-engine-8.0.0.Final.jar:8.0.0.Final]
at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:118) [teiid-engine-8.0.0.Final.jar:8.0.0.Final]
at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:288) [teiid-engine-8.0.0.Final.jar:8.0.0.Final]
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:885) [rt.jar:1.6.0_05]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:907) [rt.jar:1.6.0_05]
at java.lang.Thread.run(Thread.java:619) [rt.jar:1.6.0_05]
And here is what the Client is logging out:
connection =[org.teiid.jdbc.ConnectionImpl@139b78e]
org.teiid.jdbc.TeiidSQLException: org.teiid.core.TeiidException
at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:113)
at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:70)
at org.teiid.jdbc.StatementImpl.postReceiveResults(StatementImpl.java:654)
at org.teiid.jdbc.StatementImpl.access$100(StatementImpl.java:62)
at org.teiid.jdbc.StatementImpl$2.onCompletion(StatementImpl.java:565)
at org.teiid.client.util.ResultsFuture.done(ResultsFuture.java:130)
at org.teiid.client.util.ResultsFuture.access$200(ResultsFuture.java:37)
at org.teiid.client.util.ResultsFuture$1.receiveResults(ResultsFuture.java:75)
at org.teiid.net.socket.SocketServerInstanceImpl.receivedMessage(SocketServerInstanceImpl.java:222)
at org.teiid.net.socket.SocketServerInstanceImpl.read(SocketServerInstanceImpl.java:257)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.teiid.net.socket.SocketServerConnectionFactory$ShutdownHandler.invoke(SocketServerConnectionFactory.java:102)
at $Proxy1.read(Unknown Source)
at org.teiid.net.socket.SocketServerInstanceImpl$RemoteInvocationHandler$1.get(SocketServerInstanceImpl.java:356)
at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:574)
at org.teiid.jdbc.StatementImpl.executeQuery(StatementImpl.java:336)
at teiid.TeiidClient.main(TeiidClient.java:32)
Caused by: [TeiidException]
1 [NullPointerException]
at org.teiid.client.ResultsMessage.setException(ResultsMessage.java:172)
at org.teiid.dqp.internal.process.RequestWorkItem.sendError(RequestWorkItem.java:763)
at org.teiid.dqp.internal.process.RequestWorkItem.close(RequestWorkItem.java:488)
at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:316)
at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:49)
at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:217)
at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:241)
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:885)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:907)
at java.lang.Thread.run(Thread.java:619)
Caused by: java.lang.NullPointerException
at org.teiid.query.optimizer.relational.RelationalPlanner.resolveVirtualGroup(RelationalPlanner.java:1233)
at org.teiid.query.optimizer.relational.RelationalPlanner.buildTree(RelationalPlanner.java:836)
at org.teiid.query.optimizer.relational.RelationalPlanner.createQueryPlan(RelationalPlanner.java:737)
at org.teiid.query.optimizer.relational.RelationalPlanner.createQueryPlan(RelationalPlanner.java:696)
at org.teiid.query.optimizer.relational.RelationalPlanner.generatePlan(RelationalPlanner.java:490)
at org.teiid.query.optimizer.relational.RelationalPlanner.optimize(RelationalPlanner.java:180)
at org.teiid.query.optimizer.QueryOptimizer.optimizePlan(QueryOptimizer.java:188)
at org.teiid.dqp.internal.process.Request.generatePlan(Request.java:429)
at org.teiid.dqp.internal.process.Request.processRequest(Request.java:449)
at org.teiid.dqp.internal.process.RequestWorkItem.processNew(RequestWorkItem.java:534)
at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:278)
... 8 more
Thanks
Sateesh
-
11. Re: Internal Materialized Views
rareddy May 16, 2012 10:38 AM (in response to klsateesh)Sateesh,
Logged https://issues.jboss.org/browse/TEIID-2049 for the NPE issue above.
Thank you.
Ramesh.. -
12. Re: Internal Materialized Views
klsateesh May 16, 2012 11:16 AM (in response to rareddy)Hi Ramesh,
It looks like for the Internalized Materialized Views unless a query is executed against them the Results are not cached ??
The documentation talks about refreshing them / invalidating them either using the Query or Admin Console.
Is there a way to configure these Internalized MViews so that they get loaded into Memory when the JBoss Server starts ??
In the default standalone-teiid.xml i see the followingb settings..
<cache-container name="teiid" default-cache="resultset">
<local-cache name="resultset">
<eviction strategy="LRU" max-entries="1024"/>
<expiration lifespan="7200000"/>
</local-cache>
</cache-container>
Is this the only configuration setting which dictates how the Teiid Internal Materialized View Results are cached ??
Another thing i noticed after going through the Server logs is when ever a Query/call is made to Teiid i see the following exception after successful completion of the Query/client call. I have changed the logging settings to DEBUG mode.
11:10:18,425 DEBUG [org.teiid.CONNECTOR] (Worker3_QueryProcessorQueue5533) BNm1i90DXQop.1.0.3 Closed connection
11:10:18,443 DEBUG [org.teiid.TRANSPORT] (New I/O server worker #1-2) processing message:MessageHolder: contents=org.teiid.net.socket.ServiceInvocationStruct@166576a
11:10:18,448 DEBUG [org.teiid.PROCESSOR] (New I/O server worker #1-2) closeQuery for requestID=BNm1i90DXQop.1
11:10:18,451 DEBUG [org.teiid.TRANSPORT] (New I/O server worker #1-2) message: MessageHolder: contents=null for message:4006
11:10:18,451 DEBUG [org.teiid.PROCESSOR] (Worker3_QueryProcessorQueue5534) Request Thread BNm1i90DXQop.1 with state PROCESSING
11:10:18,455 DEBUG [org.teiid.TRANSPORT] (New I/O server worker #1-2) processing message:MessageHolder: contents=org.teiid.net.socket.ServiceInvocationStruct@1069bef
11:10:18,457 DEBUG [org.teiid.PROCESSOR] (Worker3_QueryProcessorQueue5534) Removing tuplesource for the request BNm1i90DXQop.1
11:10:18,461 DEBUG [org.teiid.SECURITY] (New I/O server worker #1-2) closeSession BNm1i90DXQop
11:10:18,464 DEBUG [org.teiid.BUFFER_MGR] (Worker3_QueryProcessorQueue5534) Removing TupleBuffer: 3
11:10:18,466 DEBUG [org.teiid.PROCESSOR] (New I/O server worker #1-2) cancelQuery for requestID=BNm1i90DXQop.1
11:10:18,472 DEBUG [org.teiid.PROCESSOR] (New I/O server worker #1-2) Failed to Cancel request, as request already finished processing
11:10:18,475 DEBUG [org.teiid.TXN_LOG] (New I/O server worker #1-2) before cancelTransactions:org.teiid.dqp.internal.process.TransactionServerImpl@1193d1e(BNm1i90DXQop,false)
11:10:18,480 DEBUG [org.teiid.TXN_LOG] (New I/O server worker #1-2) after cancelTransactions : null
11:10:18,482 DEBUG [org.teiid.TRANSPORT] (New I/O server worker #1-2) message: MessageHolder: contents=null for message:4007
11:10:18,493 DEBUG [org.teiid.TRANSPORT] (New I/O server worker #1-1) Unhandled exception, closing client instance: java.io.IOException: An existing connection was forcibly closed by the remote host
at sun.nio.ch.SocketDispatcher.read0(Native Method) [rt.jar:1.6.0_05]
at sun.nio.ch.SocketDispatcher.read(SocketDispatcher.java:25) [rt.jar:1.6.0_05]
at sun.nio.ch.IOUtil.readIntoNativeBuffer(IOUtil.java:233) [rt.jar:1.6.0_05]
at sun.nio.ch.IOUtil.read(IOUtil.java:200) [rt.jar:1.6.0_05]
at sun.nio.ch.SocketChannelImpl.read(SocketChannelImpl.java:236) [rt.jar:1.6.0_05]
at org.jboss.netty.channel.socket.nio.NioWorker.read(NioWorker.java:323) [netty-3.2.6.Final.jar:]
at org.jboss.netty.channel.socket.nio.NioWorker.processSelectedKeys(NioWorker.java:282) [netty-3.2.6.Final.jar:]
at org.jboss.netty.channel.socket.nio.NioWorker.run(NioWorker.java:202) [netty-3.2.6.Final.jar:]
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:885) [rt.jar:1.6.0_05]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:907) [rt.jar:1.6.0_05]
at java.lang.Thread.run(Thread.java:619) [rt.jar:1.6.0_05]
11:10:18,525 DEBUG [org.teiid.TRANSPORT] (New I/O server worker #1-1) Channel closed
11:10:18,495 DEBUG [org.teiid.TRANSPORT] (New I/O server worker #1-2) Unhandled exception, closing client instance: java.io.IOException: An existing connection was forcibly closed by the remote host
at sun.nio.ch.SocketDispatcher.read0(Native Method) [rt.jar:1.6.0_05]
at sun.nio.ch.SocketDispatcher.read(SocketDispatcher.java:25) [rt.jar:1.6.0_05]
at sun.nio.ch.IOUtil.readIntoNativeBuffer(IOUtil.java:233) [rt.jar:1.6.0_05]
at sun.nio.ch.IOUtil.read(IOUtil.java:200) [rt.jar:1.6.0_05]
at sun.nio.ch.SocketChannelImpl.read(SocketChannelImpl.java:236) [rt.jar:1.6.0_05]
at org.jboss.netty.channel.socket.nio.NioWorker.read(NioWorker.java:323) [netty-3.2.6.Final.jar:]
at org.jboss.netty.channel.socket.nio.NioWorker.processSelectedKeys(NioWorker.java:282) [netty-3.2.6.Final.jar:]
at org.jboss.netty.channel.socket.nio.NioWorker.run(NioWorker.java:202) [netty-3.2.6.Final.jar:]
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:885) [rt.jar:1.6.0_05]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:907) [rt.jar:1.6.0_05]
at java.lang.Thread.run(Thread.java:619) [rt.jar:1.6.0_05]
Thnks
Sateesh -
13. Re: Internal Materialized Views
klsateesh May 16, 2012 11:58 AM (in response to klsateesh)Hi Ramesh,
I have updated the Teiid Configuration File as listed below. i.e, no expiration and no eviction.
<cache-container name="teiid" default-cache="resultset">
<local-cache name="resultset"/>
</cache-container>
And when i ran the Query "SELECT * FROM TABLE1" i see the following in the Server Log... (trying to understand how the Internalized MView Internals w.r.to caching)..
11:36:33,986 DEBUG [org.teiid.TRANSPORT] (New I/O server worker #2-1) processing message:MessageHolder: contents=org.teiid.net.socket.ServiceInvocationStruct@23ed31
11:36:33,997 DEBUG [org.teiid.SECURITY] (New I/O server worker #2-1) authenticateUser user JDBC
11:36:34,023 DEBUG [org.teiid.SECURITY] (New I/O server worker #2-1) Logon successful for " user "
11:36:34,027 DEBUG [org.teiid.SECURITY] (New I/O server worker #2-1) Logon successful, created session: sessionid=JOGvPYsbxx2Q; userName=user@teiid-security; vdbName=FinalVDB; vdbVersion=1; createdTime=Wed May 16 11:36:34 EDT 2012; applicationName=JDBC; clientHostName=2SRDBM1; clientHardwareAddress=XXX; IPAddress=127.0.0.1; securityDomain=teiid-security; lastPingTime=Wed May 16 11:36:34 EDT 2012
11:36:34,037 DEBUG [org.teiid.TRANSPORT] (New I/O server worker #2-1) message: MessageHolder: contents=org.teiid.client.security.LogonResult@1589559 for message:0
11:36:34,077 DEBUG [org.teiid.TRANSPORT] (New I/O server worker #2-1) processing message:MessageHolder: contents=org.teiid.net.socket.ServiceInvocationStruct@1be6f3c
11:36:34,095 DEBUG [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue0) Request Thread JOGvPYsbxx2Q.0 with state NEW
11:36:34,098 DEBUG [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue0) JOGvPYsbxx2Q.0 Non-cachable command.
11:36:34,100 DEBUG [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue0) JOGvPYsbxx2Q.0 executing SELECT * FROM TABLE1
11:36:34,408 DEBUG [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue0) ProcessTree for JOGvPYsbxx2Q.0 AccessNode(0) output=[DHS2D_NEW.SCHEMA_NAME.TABLE1.EMP_ID, DHS2D_NEW.SCHEMA_NAME.TABLE1.EMP_NAME FROM DHS2D_NEW.SCHEMA_NAME.TABLE1 AS g_0
11:36:34,961 DEBUG [org.teiid.TXN_LOG] (Worker0_QueryProcessorQueue0) before getOrCreateTransactionContext:org.teiid.dqp.internal.process.TransactionServerImpl@8bd6e8(JOGvPYsbxx2Q)
11:36:34,967 DEBUG [org.teiid.TXN_LOG] (Worker0_QueryProcessorQueue0) after getOrCreateTransactionContext : JOGvPYsbxx2Q NONE ID:NONE
11:36:34,979 DEBUG [org.teiid.BUFFER_MGR] (Worker0_QueryProcessorQueue0) Creating FileStore: 0_lobs
11:36:34,987 DEBUG [org.teiid.BUFFER_MGR] (Worker0_QueryProcessorQueue0) Creating TupleBuffer: 0 [DHS2D_NEW.SCHEMA_NAME.TABLE1.EMP_ID, DHS2D_NEW.SCHEMA_NAME.TABLE1.EMP_NAME] [class java.lang.String, class java.lang.String] of type PROCESSOR
11:36:35,584 DEBUG [org.teiid.CONNECTOR] (Worker0_QueryProcessorQueue0) JOGvPYsbxx2Q.0.0.0 Create State
11:36:35,592 DEBUG [org.teiid.BUFFER_MGR] (Worker0_QueryProcessorQueue0) JOGvPYsbxx2Q.0.0.0 Blocking on source query
11:36:35,593 DEBUG [org.teiid.PROCESSOR] (Worker1_QueryProcessorQueue1) Running task for parent thread Worker0_QueryProcessorQueue0
11:36:35,598 DEBUG [org.teiid.BUFFER_MGR] (Worker0_QueryProcessorQueue0) JOGvPYsbxx2Q.0 Blocking on source request(s).
11:36:35,608 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue1) JOGvPYsbxx2Q.0.0.0 Processing NEW request: SELECT g_0.EMP_ID, g_0.EMP_NAME FROM DHS2D_NEW.SCHEMA_NAME.TABLE1 AS g_0
11:36:35,611 DEBUG [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue0) Request Thread JOGvPYsbxx2Q.0 - processor blocked
11:36:35,747 DEBUG [org.jboss.jca.core.connectionmanager.pool.idle.IdleRemover] (Worker1_QueryProcessorQueue1) Register pool: SemaphoreArrayListManagedConnectionPool@1c82121[pool=test] (interval=1800000)
11:36:35,752 DEBUG [org.jboss.jca.core.connectionmanager.pool.idle.IdleRemover] (Worker1_QueryProcessorQueue1) About to notify thread: old next: 1337183495752, new next: 1337183495752
11:36:35,757 DEBUG [org.jboss.jca.core.connectionmanager.pool.idle.IdleRemover] (IdleRemover) Notifying pools, interval: 900000
11:36:35,759 DEBUG [org.jboss.jca.core.connectionmanager.pool.strategy.OnePool] (Worker1_QueryProcessorQueue1) test: getConnection(null, null) [0/20]
11:36:35,767 DEBUG [org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory] (Worker1_QueryProcessorQueue1) Driver loaded and instance created:oracle.jdbc.OracleDriver@1002a9d
11:36:36,207 DEBUG [org.jboss.jca.adapters.jdbc.WrapperDataSource] (Worker1_QueryProcessorQueue1) UserTransaction not found
11:36:36,211 INFO [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue1) OracleExecutionFactory Commit=true;DatabaseProductName=Oracle;DatabaseProductVersion=Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options;DriverMajorVersion=11;DriverMajorVersion=2;DriverName=Oracle JDBC driver;DriverVersion=11.2.0.1.0;IsolationLevel=2
11:36:36,224 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue1) JOGvPYsbxx2Q.0.0.0 Obtained execution
11:36:36,230 DEBUG [org.teiid.COMMAND_LOG] (Worker1_QueryProcessorQueue1) START DATA SRC COMMAND: startTime=2012-05-16 11:36:36.229 requestID=JOGvPYsbxx2Q.0 sourceCommandID=0 txID=null modelName=DHS2D_NEW translatorName=oracle sessionID=JOGvPYsbxx2Q principal=user@teiid-security sql=SELECT g_0.EMP_ID, g_0.EMP_NAME FROM DHS2D_NEW.SCHEMA_NAME.TABLE1 AS g_0
11:36:36,432 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue1) Source-specific command: SELECT g_0.EMP_ID, g_0.EMP_NAME FROM "SCHEMA_NAME"."TABLE1" AS g_0
11:36:37,347 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue1) JOGvPYsbxx2Q.0.0.0 Executed command
11:36:37,350 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue1) JOGvPYsbxx2Q.0.0.0 Getting results from connector
11:36:37,432 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue1) JOGvPYsbxx2Q.0.0.0 Obtained results from connector, current row count: 512
11:36:37,440 DEBUG [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue2) Request Thread JOGvPYsbxx2Q.0 with state PROCESSING
11:36:37,451 DEBUG [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue2) [RequestWorkItem.sendResultsIfNeeded] requestID: JOGvPYsbxx2Q.0 resultsID: 0 done: false
11:36:37,451 DEBUG [org.teiid.PROCESSOR] (Worker1_QueryProcessorQueue3) Running task for parent thread Worker0_QueryProcessorQueue2
11:36:37,459 DEBUG [org.teiid.TRANSPORT] (Worker0_QueryProcessorQueue2) message: MessageHolder: contents=ResultsMessage rowCount=128 finalRow=-1 for message:1
11:36:37,461 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue3) JOGvPYsbxx2Q.0.0.0 Processing MORE request
11:36:37,540 DEBUG [org.teiid.BUFFER_MGR] (Worker0_QueryProcessorQueue2) JOGvPYsbxx2Q.0.0.0 Blocking on source query
11:36:37,545 DEBUG [org.teiid.BUFFER_MGR] (Worker0_QueryProcessorQueue2) JOGvPYsbxx2Q.0 Blocking on source request(s).
11:36:37,541 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue3) JOGvPYsbxx2Q.0.0.0 Getting results from connector
11:36:37,626 DEBUG [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue2) Request Thread JOGvPYsbxx2Q.0 - processor blocked
11:36:37,737 DEBUG [org.teiid.TRANSPORT] (New I/O server worker #2-1) processing message:MessageHolder: contents=org.teiid.net.socket.ServiceInvocationStruct@1f3305e
11:36:37,770 DEBUG [org.teiid.PROCESSOR] (New I/O server worker #2-1) closeQuery for requestID=JOGvPYsbxx2Q.0
11:36:37,774 DEBUG [org.teiid.CONNECTOR] (New I/O server worker #2-1) JOGvPYsbxx2Q.0.0.0 Processing CANCEL request
11:36:37,778 DEBUG [org.teiid.COMMAND_LOG] (New I/O server worker #2-1) CANCEL SRC COMMAND: endTime=2012-05-16 11:36:37.777 requestID=JOGvPYsbxx2Q.0 sourceCommandID=0 txID=null modelName=DHS2D_NEW translatorName=oracle sessionID=JOGvPYsbxx2Q principal=user@teiid-security finalRowCount=-1
11:36:37,787 DEBUG [org.teiid.CONNECTOR] (New I/O server worker #2-1) The atomic request JOGvPYsbxx2Q.0.0.0 has been canceled.
11:36:37,790 DEBUG [org.teiid.TXN_LOG] (New I/O server worker #2-1) before cancelTransactions:org.teiid.dqp.internal.process.TransactionServerImpl@8bd6e8(JOGvPYsbxx2Q,true)
11:36:37,765 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue3) JOGvPYsbxx2Q.0.0.0 Obtained results from connector, current row count: 1024
11:36:37,799 DEBUG [org.teiid.TXN_LOG] (New I/O server worker #2-1) after cancelTransactions : null
11:36:37,803 DEBUG [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue4) Request Thread JOGvPYsbxx2Q.0 with state PROCESSING
11:36:37,817 DEBUG [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue4) QueryProcessor: closing processor
11:36:37,821 DEBUG [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue4) Removing tuplesource for the request JOGvPYsbxx2Q.0
11:36:37,825 DEBUG [org.teiid.BUFFER_MGR] (Worker0_QueryProcessorQueue4) Removing TupleBuffer: 0
11:36:37,821 DEBUG [org.teiid.PROCESSOR] (Worker1_QueryProcessorQueue5) Running task for parent thread Worker0_QueryProcessorQueue4
11:36:37,807 DEBUG [org.teiid.TRANSPORT] (New I/O server worker #2-1) message: MessageHolder: contents=null for message:2
11:36:37,844 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue5) JOGvPYsbxx2Q.0.0.0 Remove State
11:36:37,853 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue5) JOGvPYsbxx2Q.0.0.0 Processing Close : SELECT g_0.EMP_ID, g_0.EMP_NAME FROM DHS2D_NEW.SCHEMA_NAME.TABLE1 AS g_0
It looks like it still is cahcing 1024 Rows from the above logs!! Is it the default settings ??
Thanks
Sateesh
-
14. Re: Internal Materialized Views
shawkins May 16, 2012 9:57 PM (in response to klsateesh)Here's answers to questions from the previous two posts.
> It looks like for the Internalized Materialized Views unless a query is executed against them the Results are not cached ??
Yes that is correct.
> Is there a way to configure these Internalized MViews so that they get loaded into Memory when the JBoss Server starts ??
Not currently. An internal mat view table load happens in the context of an authenticated user. In the initial design we did not want to require adding a system account to the configuration for view loads. That can be requested as an enhancement.
> Is this the only configuration setting which dictates how the Teiid Internal Materialized View Results are cached ??
Materialization does not interact with the caching configuration. Once a materialization table is created it should be invalidated/reloaded via system calls - https://docs.jboss.org/author/display/teiid80final/Internal+Materialization or by adding ttl metadata to the view cache hint - https://docs.jboss.org/author/display/teiid80final/Hints+and+Options
> It looks like it still is cahcing 1024 Rows from the above logs!! Is it the default settings ??
I don't see result set caching or materialization being utilized from that log snippet. What is your expectation?