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

Prepared statement for SOURCE_NAME in multi-source mode throws exception Message:Unable to evaluate

    XMLWordPrintable

Details

    • Hide

      1. Create a database 'office' which contains a table emp.
      2. Create another database 'office1' which contains a table emp.
      3. Create data sources for the databases.
      4. Create a Virtual database.
      5. Add a multisource model to the VDB.
      6. Deploy the datasources and the VDB.
      7. Run a prepared statement against the VDB.
      8. You will see the exception.

      Show
      1. Create a database 'office' which contains a table emp. 2. Create another database 'office1' which contains a table emp. 3. Create data sources for the databases. 4. Create a Virtual database. 5. Add a multisource model to the VDB. 6. Deploy the datasources and the VDB. 7. Run a prepared statement against the VDB. 8. You will see the exception.

    Description

      I have a VDB which has a multi-source model. I have a prepared statement for which SOURCE_NAME is passed as a parameter. When this prepared statement is executed, I get an exception

      [TeiidComponentException] ERR.015.006.0033: Error Code:ERR.015.006.0033 Message:Unable to evaluate ?: No value was available

      This exception does not occur when I specify other conditions in combination with SOURCE_NAME. Also, the query works fine when SOURCE_NAME value is not a parameter, that is, its value is provided in the query.

      Attachments

        1. office-ds.xml
          0.3 kB
        2. office1-ds.xml
          0.3 kB
        3. emp-vdb.xml
          0.5 kB
        4. MultisourceModel.java
          2 kB
        5. server.log
          3 kB

        Activity

          People

            rhn-engineering-shawkins Steven Hawkins
            ganeshkumar_jira Ganesh Kumar (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: