[teiid-issues] [JBoss JIRA] (TEIID-1808) Cannot load metadata for dynamic VDB on oracle10g

From the soa jira, you are loading the metadata for a recycle bin table: SOAESB1.BIN$mbjj432fhyLgQCIK4iBmlQ==$0. This table must be reported twice in the metadata, which is odd, but not entirely out of the realm of possibility since you are not limiting what metadata the importer should fetch. As the reference states you should be setting schema/table name patterns, etc. to appropriately limit the metadata.

Cannot load metadata for dynamic VDB on oracle10g ------------------------------------------------- Key: TEIID-1808 URL: https://issues.jboss.org/browse/TEIID-1808 Project: Teiid Issue Type: Bug Components: Server Affects Versions: 7.4.1 Reporter: Filip Nguyen Assignee: Steven Hawkins Attachments: mytext-ds.xml, myvdb-vdb.xml, server.log There seems to be a problem with deploying dynamic VDB (attachment) which loads metadata from Oracle10g. It works on any other database supported by SOA P (including Oracle11g). When I deploy the VDB I get: {code:title=Server.log|borderStyle=solid} 2011-11-03 10:32:26,306 INFO [org.teiid.RUNTIME] (JBoss System Threads(1)-7) VDB myvdb.1 model EMPLOYEES metadata is currently being loaded. Start Time: 11/3/11 10:32 AM 2011-11-03 10:32:26,306 INFO [org.teiid.RUNTIME] (JBoss System Threads(1)-8) VDB myvdb.1 model TextFileData metadata is currently being loaded. Start Time: 11/3/11 10:32 AM 2011-11-03 10:32:26,307 INFO [org.teiid.RUNTIME] (HDScanner) VDB "myvdb.1[EMPLOYEES[oracle-connector/oracle/java:DefaultDS], TextFileData[text-connector/file/java:TxtFileDS]]" deployed in inactive state. 2011-11-03 10:32:26,307 DEBUG [org.jboss.deployers.plugins.deployers.DeployersImpl] (HDScanner) Fully Deployed vfsfile:/home/fnguyen/work/soaplatform/products/esb/jboss-as/server/oracle10g/deploy/myvdb-vdb.xml 2011-11-03 10:32:26,323 INFO [org.teiid.RUNTIME] (JBoss System Threads(1)-8) VDB myvdb.1 model TextFileData metadata is currently being loaded. .... .... 2011-11-03 10:35:04,832 WARN [org.teiid.RUNTIME] (JBoss System Threads(1)-7) myvdb.1 is now "incomplete", because model "EMPLOYEES" can not retrieve metadata. Please fix any errors and re-deploy relevant DataSources and/or the VDB. {code} In web console VDB is not active and contains following errors: {code:title=Web console|borderStyle=solid} ERROR VDB myvdb.1 model employees metadata is currently being loaded. Start Time: 11/3/11 10:54 AM ERROR myvdb.1 is now "incomplete", because model "employees" can not retrieve metadata. Please fix any errors and re-deploy relevant DataSources and/or the VDB. ERROR Teiid runtime names, which are case insensitive, for the imported metadata are not unique. If not already set, use the setting importer.useFullSchemaName to create Teiid names that include the source schema. {code} It looks like there is a problem with content of the database, but I only created one database table: {code:title=Employees table|borderStyle=solid} -------------------------------------------------------- -- DDL for Table employees -------------------------------------------------------- CREATE TABLE "SOAESB1"."employees" ( "ID" NUMBER(19,0), "NAME" VARCHAR2(255 CHAR), "SURNAME" VARCHAR2(255 CHAR), "SYMBOL" VARCHAR2(255 CHAR) ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "USERS" ; -------------------------------------------------------- -- DDL for Index SYS_C00330055 -------------------------------------------------------- CREATE UNIQUE INDEX "SOAESB1"."SYS_C00330055" ON "SOAESB1"."employees" ("ID") PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "USERS" ; -------------------------------------------------------- -- Constraints for Table employees -------------------------------------------------------- ALTER TABLE "SOAESB1"."employees" MODIFY ("ID" NOT NULL ENABLE); ALTER TABLE "SOAESB1"."employees" ADD PRIMARY KEY ("ID") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "USERS" ENABLE; {code}