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

NullPointerException while creating source model from Excel table

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Major
    • 8.7.1, 8.9
    • 8.7
    • None
    • Hide

      Teiid Designer:
      1. Create/user Teiid Model Project
      2. Import... -> Teiid Connection >> Source Model
      3. Create/use data source with file driver
      4. Select "excel" translator
      5. Set Data Rov Number = 2; Header Row Number = 1; Excel File = <name-of-excel-file>
      6.Set name of source model

      Next procedure ends with error:
      Error deploying "importVDB" - please check the server log.
      Please check the server log for more details.

      Dynamic VDB:
      deploy ExcelDynamic-vdb.xml

      Show
      Teiid Designer: 1. Create/user Teiid Model Project 2. Import... -> Teiid Connection >> Source Model 3. Create/use data source with file driver 4. Select "excel" translator 5. Set Data Rov Number = 2; Header Row Number = 1; Excel File = <name-of-excel-file> 6.Set name of source model Next procedure ends with error: Error deploying "importVDB" - please check the server log. Please check the server log for more details. Dynamic VDB: deploy ExcelDynamic-vdb.xml

    Description

      I am trying to create source model from Excel file (.xlsx). When I set property "Header Row Number" to 1 (using Teiid Designer), creating ends with NullPointerException. Setting "Header Row Number" to 0 executes with no problems.

      Same problem (and same exception) with dynamic VDB (only with <property name="importer.headerRowNumber" value="1"/>).

      Attachments

        1. ExcelDynamic-vdb.xml
          0.5 kB
        2. Server.log
          2 kB
        3. smalla_raw.xlsx
          14 kB
        4. smalla.xlsx
          17 kB

        Activity

          People

            rhn-engineering-rareddy Ramesh Reddy
            jdurani Juraj Duráni (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: