Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-4388

If model fails to load native metadata, VDB has still status LOADING

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Won't Do
    • Icon: Major Major
    • None
    • 8.12.5
    • None
    • None
    • Hide

      Data sources:

      • ora - accessible
      • my5 - accessible
      • pg - inaccessible (invalid URL)
      VDB
      <vdb name="test" version="1">
          <model name="Source1" type="PHYSICAL">
              <source name="ora" translator-name="oracle" connection-jndi-name="java:/Oracle12_PushDS"/>
              <metadata type="DDL"><![CDATA[...]]></metadata>
          </model>
          <model name="Source2" type="PHYSICAL">
              <source name="pg" translator-name="postgresql" connection-jndi-name="java:/postgres92"/>
              <metadata type="NATIVE"/>
          </model>
          <model name="Source3" type="PHYSICAL">
              <source name="my5" translator-name="mysql5" connection-jndi-name="java:/MySQL55_PushDS"/>
              <metadata type="NATIVE"/>
          </model>
      </vdb>
      
      Show
      Data sources: ora - accessible my5 - accessible pg - inaccessible (invalid URL) VDB <vdb name= "test" version= "1" > <model name= "Source1" type= "PHYSICAL" > <source name= "ora" translator-name= "oracle" connection-jndi-name= "java:/Oracle12_PushDS" /> <metadata type= "DDL" > <![CDATA[...]]> </metadata> </model> <model name= "Source2" type= "PHYSICAL" > <source name= "pg" translator-name= "postgresql" connection-jndi-name= "java:/postgres92" /> <metadata type= "NATIVE" /> </model> <model name= "Source3" type= "PHYSICAL" > <source name= "my5" translator-name= "mysql5" connection-jndi-name= "java:/MySQL55_PushDS" /> <metadata type= "NATIVE" /> </model> </vdb>

      If one model fails to load native metadata, VDB's status is still LOADING.

      CLI status
      Unable to find source-code formatter for language: plain. Available languages are: actionscript, ada, applescript, bash, c, c#, c++, cpp, css, erlang, go, groovy, haskell, html, java, javascript, js, json, lua, none, nyan, objc, perl, php, python, r, rainbow, ruby, scala, sh, sql, swift, visualbasic, xml, yaml
      [standalone@localhost:9999 /] /subsystem=teiid:get-vdb(vdb-name=test,vdb-version=1)
      {
          "outcome" => "success",
          "result" => {
              "vdb-name" => "test",
              "status" => "LOADING",
              "vdb-version" => 1,
              ...
              "models" => [
                  {
                      "model-name" => "Source1",
                      ...
                      "metadata-status" => "LOADED"
                  },
                  {
                      "model-name" => "Source2",
                      ...
                      "validity-errors" => [
                          {
                              "severity" => "INFO",
                              "message" => "TEIID50029 VDB test.1 model \"Source2\" metadata is currently being loaded. Start Time: 8/17/16 7:41 AM"
                          },
                          {
                              "severity" => "ERROR",
                              "message" => "TEIID31178 Could not obtain connection for schema Source2, but one is required for metadata load. "
                          }
                      ],
                      ...
                      "metadata-status" => "FAILED"
                  },
                  {
                      "model-name" => "Source3",
                      ...
                      "metadata-status" => "LOADED"
                  }
              ]
          }
      }
      

              rhn-engineering-shawkins Steven Hawkins
              jdurani Juraj DurĂ¡ni (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Created:
                Updated:
                Resolved: