[
https://jira.jboss.org/browse/TEIID-1205?page=com.atlassian.jira.plugin.s...
]
Ramesh Reddy commented on TEIID-1205:
-------------------------------------
If you are not working from scratch, when you deployed the CR2, did you delete the
"teiid" directory in the "<jboss-as>/server/default/data"
directory? This directory keeps the old cached vdb metadata files between the server
restarts. When a version upgrade happens, the file names of the VDB metadata may be same
but internal structure of these files may be different. This will pass the check of if
metadata needs to reload from the source as false, but loading this file into an metadata
object might fail and can lead to above error.
Does any of this apply to your case?
First deployment of weather example fails to query and requires
restarting JBoss AS (weather does not exist)
------------------------------------------------------------------------------------------------------------
Key: TEIID-1205
URL:
https://jira.jboss.org/browse/TEIID-1205
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 7.1
Environment: Fedora 12, Teiid 7.1 CR2
Reporter: Paul Nittel
Assignee: Steve Hawkins
I started by installing JBoss AS and Teiid 7.1CR2 (plus JDBC drivers). After starting
JBoss AS, I deployed the weather-ds and weather-vdb files. After seeing the VDB was
"active" I used the simpleclient to execute this query:
./run.sh localhost 31000 weather "select t.* from (call
weather.invoke(action='GET', endpoint=querystring('', '63017
10530' as zipCodeList, 'glance' as product, '2010-08-12T14:00:00' as
\"begin\", '2010-08-12T14:00:00' as \"end\", 'maxt' as
maxt, 'mint' as mint) )) w, XMLTABLE('/dwml/data/parameters' passing
w.result columns Location string path '@applicable-location', TempName string
path 'temperature/name', TempValue string path 'temperature/value' )
t"
The result was:
[QueryMetadataException]weather does not exist.
at org.teiid.query.resolver.QueryResolver.resolveCommand(QueryResolver.java:176)
at
org.teiid.query.resolver.command.SimpleQueryResolver$QueryResolverVisitor.resolveSubQuery(SimpleQueryResolver.java:208)
at
org.teiid.query.resolver.command.SimpleQueryResolver$QueryResolverVisitor.visit(SimpleQueryResolver.java:362)
at
org.teiid.query.sql.lang.SubqueryFromClause.acceptVisitor(SubqueryFromClause.java:127)
at org.teiid.query.sql.navigator.AbstractNavigator.visitNode(AbstractNavigator.java:62)
at
org.teiid.query.sql.navigator.AbstractNavigator.visitNodes(AbstractNavigator.java:73)
at
org.teiid.query.sql.navigator.PreOrPostOrderNavigator.visit(PreOrPostOrderNavigator.java:259)
at
org.teiid.query.resolver.command.SimpleQueryResolver$QueryResolverVisitor.visit(SimpleQueryResolver.java:523)
at org.teiid.query.sql.lang.From.acceptVisitor(From.java:144)
at org.teiid.query.sql.navigator.AbstractNavigator.visitNode(AbstractNavigator.java:62)
at
org.teiid.query.resolver.command.SimpleQueryResolver$QueryResolverVisitor.visit(SimpleQueryResolver.java:186)
at
org.teiid.query.resolver.command.SimpleQueryResolver.resolveCommand(SimpleQueryResolver.java:103)
at org.teiid.query.resolver.QueryResolver.resolveCommand(QueryResolver.java:174)
at org.teiid.query.resolver.QueryResolver.resolveCommand(QueryResolver.java:126)
at org.teiid.query.resolver.QueryResolver.resolveCommand(QueryResolver.java:100)
at org.teiid.dqp.internal.process.Request.resolveCommand(Request.java:277)
at org.teiid.dqp.internal.process.Request.generatePlan(Request.java:378)
at org.teiid.dqp.internal.process.Request.processRequest(Request.java:437)
at org.teiid.dqp.internal.process.RequestWorkItem.processNew(RequestWorkItem.java:351)
at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:174)
at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:49)
at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:188)
at
org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:116)
at
org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:290)
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:619)
Caused by: [QueryMetadataException]weather does not exist.
at
org.teiid.query.metadata.CompositeMetadataStore.getSchema(CompositeMetadataStore.java:65)
at
org.teiid.query.metadata.CompositeMetadataStore.getStoredProcedure(CompositeMetadataStore.java:108)
at
org.teiid.query.metadata.TransformationMetadata.getStoredProcedureInfoForProcedure(TransformationMetadata.java:300)
at
org.teiid.query.metadata.BasicQueryMetadataWrapper.getStoredProcedureInfoForProcedure(BasicQueryMetadataWrapper.java:273)
at
org.teiid.query.metadata.BasicQueryMetadataWrapper.getStoredProcedureInfoForProcedure(BasicQueryMetadataWrapper.java:273)
at
org.teiid.query.resolver.command.ExecResolver.findCommandMetadata(ExecResolver.java:79)
at
org.teiid.query.resolver.command.ExecResolver.resolveProceduralCommand(ExecResolver.java:246)
at
org.teiid.query.resolver.ProcedureContainerResolver.resolveCommand(ProcedureContainerResolver.java:195)
at org.teiid.query.resolver.QueryResolver.resolveCommand(QueryResolver.java:174)
... 26 more
I shut down JBoss AS and restarted it and was able to execute the same query
successfully.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira