2 Replies Latest reply on Nov 24, 2010 10:50 AM by Marco Ardito

    Help! Status: DOWN Errors: ** There are 3 errors reported for this VDB. See the Configuration tab for details. **

    Marco Ardito Master

      Hi, i'm moving first steps around jboss as and teiid.

       

      i installed derby on the same server where teiid is and i'm trying to follow steps from the quickstart,

      "2.2. Create the Relational Database's schema and load the sample data" (done)

       

      and got:

      ===================================

      jbadmin@jbossas01:~/derby/db-derby$ ./bin/ij
      Versione ij 10.6
      ij> CONNECT 'jdbc:derby://localhost:1527/teiid/accounts;create=true;';
      ij> show tables;
      TABLE_SCHEM         |TABLE_NAME                    |REMARKS
      ------------------------------------------------------------------------
      SYS                 |SYSALIASES                    |

      ...

      (cut)

      ...

      SYSIBM              |SYSDUMMY1                     |
      APP                 |ACCOUNT                       |
      APP                 |CUSTOMER                      |
      APP                 |HOLDINGS                      |
      APP                 |PRODUCT                       |

      ===================================

      so i assume everything ok here...

       

      then, as for  "3.1. Building Dynamic VDB"

      i've left the provided portfolio-vdb.xml as it was, and copied it and the "connnections" xml into the right "deploy" folder:

      ===================================

      jbadmin@jbossas01:~/jboss/server/default/deploy$ ls -l port*
      -rw-r--r-- 1 jbadmin jbadmin  870 2010-11-23 16:08 portfolio-ds.xml
      -rw-r--r-- 1 jbadmin jbadmin 1926 2010-11-23 16:29 portfolio-vdb.xml
      jbadmin@jbossas01:~/jboss/server/default/deploy$ ls -l mark*
      -rw-r--r-- 1 jbadmin jbadmin 729 2010-11-23 16:08 marketdata-file-ds.xml

      ===================================

       

      now, from the jboss as admin console i see for:

      "jbossas01.apiform.to.it>JBossAS Servers>JBoss AS 5 (default)>Data Services>Virtual Database (VDB)s>DynamicPortfolio.1"

       

      this summary message:

      ===================================

      General Properties
      Name:DynamicPortfolio.1
      Version:1
      Description:Teiid Virtual Database (VDB)
      Traits
      Status: DOWN
      Errors: ** There are 3 errors reported for this VDB. See the Configuration tab for details. **

      ===================================

       

      and the configuration tab shows:

      ===================================

      Error List            VDB Errors
      Severity     Message     Actions
      ERROR     VDB "DynamicPortfolio-1" - "Accounts" model metadata is currently being loaded. Start Time: 23/11/10 16.29    
      Edit
      ERROR     "DynamicPortfolio-1" is now "incomplete", because model "Accounts" can not retrieve metadata. Fix errors and re-deploy the VDB.    
      Edit
      ERROR     Error Code:0 Message:Unable to get managed connection for PortfolioDS; - nested throwable: (javax.resource.ResourceException: Unable to get managed connection for PortfolioDS)    
      Edit

      ===================================

       

      ...where i failed? what am i missing... a bit confused by all this xml around, i'm just not used...

       

      Marco