Uploaded image for project: 'Teiid Designer'
  1. Teiid Designer
  2. TEIIDDES-1918

JDBC importer adds wrong column type for columns of type integer, when importing(Reusing) VDB

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Critical
    • 8.3
    • 8.3
    • Import/Export
    • None

    Description

      When a VDB is imported(reused) by another VDB and the imported VDB contains table with column of type integer, then the importing VDB will throw validation error.

      Steps to reproduce:
      1. Create loopback VDB, add table DATA with two columns, one of type integer and one of the string
      2. Deploy the loopback VDB
      3. Reuse the looback VDB
      3.1. Import the loopback VDB through JDBC importer
      "Import as VDB source model" have to be checked
      3.2 Create view model, use table DATA in the view model
      3.3 Create and deploy new VDB

      When deploying the VDB, error occures:

      TEIID31080 View data validation error: QueryValidatorException-The definition for data has the wrong type for column 1. Expected bigdecimal, but was biginteger.
      15:57:48,718 INFO [org.teiid.RUNTIME] (teiid-async-threads - 1) TEIID40073 The metadata for the VDB aaa.1 is loaded, however it is not valid. Check models for errors. Correct the metadata and re-deploy.
      15:57:48,719 INFO [org.teiid.RUNTIME] (teiid-async-threads - 1) TEIID40003 VDB aaa.1 is set to FAILED

      Attachments

        Activity

          People

            mdrillin1@redhat.com Mark Drilling (Inactive)
            van.halbert Van Halbert (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: