Hide Forgot
project_key: SOA A dynamic VDB doesn't work properly on first server startup. One needs to restart server once to get a proper query result. To reproduce: cd jbossas/server cp -a all dataservices cd dataservices unzip teiid-7.1.0.Final-jboss-dist.zip tar xvfz teiid-text-example.tgz #see the file attached 1. setup jbossas config with teiid and VDB 2. start server 3. connect & query => ERROR org.teiid.jdbc.TeiidSQLException: Remote org.teiid.api.exception.query.QueryResolverException: interoperability does not exist. 4. restart server 5. connect & query => result retrieved test query I used through adminshell: "SELECT fullname, price FROM (EXEC Interoperability.getTextFiles('Company.txt') ) AS ff, TEXTTABLE(ff.file COLUMNS symbol string, fullname string, price string) AS c" When query is failing I see this in server log: 05:00:18,225 WARN [PROCESSOR] Processing exception 'interoperability does not exist.' for request 87zeTL/KvEF6.0. Exception type org.teiid.api.exception.query.QueryResolverException thrown from org.teiid.query.metadata.CompositeMetadataStore.getSchema(CompositeMetadataStore.java:65). Enable more detailed logging to see the entire stacktrace.
Attachment: Added: teiid-text-example.tgz
Link: Added: This issue depends TEIID-1242
Teiid has resolved this issue.
verified in ER1 and ER2