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

[Steven Hawkins (Resolved) (JIRA)]

     [ https://issues.jboss.org/browse/TEIID-1808?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steven Hawkins resolved TEIID-1808.
-----------------------------------

    Resolution: Rejected


>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}

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira