| Summary: | teiid VDB inconsistent behavior | ||||||
|---|---|---|---|---|---|---|---|
| Product: | [JBoss] JBoss Enterprise SOA Platform 5 | Reporter: | Aleksandar Kostadinov <akostadinov> | ||||
| Component: | EDS | Assignee: | Default User <jbpapp-maint> | ||||
| Status: | CLOSED NEXTRELEASE | QA Contact: | |||||
| Severity: | high | Docs Contact: | |||||
| Priority: | high | ||||||
| Version: | 5.1.0.dev2 | Keywords: | TestBlocker | ||||
| Target Milestone: | --- | ||||||
| Target Release: | 5.1.0.ER2 | ||||||
| Hardware: | Unspecified | ||||||
| OS: | Unspecified | ||||||
| URL: | http://jira.jboss.org/jira/browse/SOA-2253 | ||||||
| Whiteboard: | |||||||
| Fixed In Version: | Doc Type: | Bug Fix | |||||
| Doc Text: | Story Points: | --- | |||||
| Clone Of: | Environment: |
RHEL5, openjdk, SOA-P 5.1.0.dev3
|
|||||
| Last Closed: | 2010-10-11 05:27:21 UTC | Type: | Bug | ||||
| Regression: | --- | Mount Type: | --- | ||||
| Documentation: | --- | CRM: | |||||
| Verified Versions: | Category: | --- | |||||
| oVirt Team: | --- | RHEL 7.3 requirements from Atomic Host: | |||||
| Cloudforms Team: | --- | Target Upstream Version: | |||||
| Attachments: |
|
||||||
Attachment: Added: teiid-text-example.tgz Link: Added: This issue depends TEIID-1242 Teiid has resolved this issue. verified in ER1 and ER2 |
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.