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

NullPointerException while creating source model from Excel table

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Major 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

      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"/>).

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

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

                Created:
                Updated:
                Resolved: