2 Replies Latest reply on Nov 24, 2010 10:50 AM by m.ardito

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

    m.ardito

      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

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

          Marco,

           

          You need to edit the "portfolio-ds.xml", and add in details about your "derby" server. Default the configuration in there it could not make the connection to your Derby database. Once that is fixed, just touch the "portfolio-vdb.xml" file to start the re-deploy.

           

          Dynamic VDB retrives the metadata of the sources at the time of deployment, the error is saying that it failed to retrive metadata, thus deployment failed or VDB inactive. Creating the "-ds.xml" to define a data source is nothing different than creating a datasource in JBoss for any data access purpose. Teiid defines the "-vdb.xml" file, to define the Dynamic VDB. Check the Reference Guide, to know the details of the XML format and usage.

           

          Thanks for using Teiid. Please let us how we can help.

           

          Ramesh..

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

            perfect! i just edited the xml file you indicated, changing from the default

            <xa-datasource-property name="ServerName">localhost</xa-datasource-property>

            to

            <xa-datasource-property name="ServerName">192.168.3.70</xa-datasource-property>

            (being that the test machine static ip)

            and the status changed to UP, with no errors.

             

            now i have a warning trying the odbc connection, but i'm going to open another thread for that, since it's not related to this one

             

            Thanks Ramesh!