Bug 779894 (SOA-2253) - teiid VDB inconsistent behavior
Summary: teiid VDB inconsistent behavior
Keywords:
Status: CLOSED NEXTRELEASE
Alias: SOA-2253
Product: JBoss Enterprise SOA Platform 5
Classification: JBoss
Component: EDS
Version: 5.1.0.dev2
Hardware: Unspecified
OS: Unspecified
high
high
Target Milestone: ---
: 5.1.0.ER2
Assignee: Default User
QA Contact:
URL: http://jira.jboss.org/jira/browse/SOA...
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2010-09-03 09:32 UTC by Aleksandar Kostadinov
Modified: 2010-10-11 05:27 UTC (History)
0 users

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
RHEL5, openjdk, SOA-P 5.1.0.dev3
Last Closed: 2010-10-11 05:27:21 UTC
Type: Bug


Attachments (Terms of Use)
teiid-text-example.tgz (1.14 KB, application/x-gtar)
2010-09-03 09:36 UTC, Aleksandar Kostadinov
no flags Details


Links
System ID Private Priority Status Summary Last Updated
Red Hat Issue Tracker SOA-2253 0 None None None Never

Description Aleksandar Kostadinov 2010-09-03 09:32:05 UTC
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.

Comment 1 Aleksandar Kostadinov 2010-09-03 09:36:54 UTC
Attachment: Added: teiid-text-example.tgz


Comment 2 Aleksandar Kostadinov 2010-09-03 09:41:44 UTC
Link: Added: This issue depends TEIID-1242


Comment 3 Van Halbert 2010-09-16 18:58:12 UTC
Teiid has resolved this issue.

Comment 4 Aleksandar Kostadinov 2010-10-11 05:27:21 UTC
verified in ER1 and ER2


Note You need to log in before you can comment on or make changes to this bug.