[teiid-issues] [JBoss JIRA] Closed: (TEIID-1242) teiid VDB inconsistent behavior

teiid VDB inconsistent behavior ------------------------------- Key: TEIID-1242 URL: https://jira.jboss.org/browse/TEIID-1242 Project: Teiid Issue Type: Bug Components: Server Affects Versions: 7.1 Environment: RHEL5, openjdk, SOA-P 5.1.0.dev3 Reporter: Aleksandar Kostadinov Assignee: Ramesh Reddy Attachments: teiid-text-example.tgz 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.