When the user tried to create a source model from an Excel file (and set property "Header Row Number" to 1 (using Teiid Designer), a NullPointerException occurs. This happened because, during the metadata building, the translator looked at the data row configured to detect the data types. If the given data row had an empty cell, the exception occurred. To fix this, when a cell is empty, the code is now programmed to look for a non-empty cell in the next available row. If that too, is empty, it will forward cursor until it finds a non-null cell value. If all the values are null then it will choose the data type as string. As a result, users will no longer encounter this exception.
Created attachment 934776[details]
dynamic vdb
Description of problem:
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"/>).
How reproducible:
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
Additional info:
exception, excel files, dynamic vdb in attachment
Comment 2JBoss JIRA Server
2014-09-05 21:03:41 UTC
Ramesh Reddy <rareddy> updated the status of jira TEIID-3117 to Resolved
Comment 3JBoss JIRA Server
2014-11-19 18:37:31 UTC
Steven Hawkins <shawkins> updated the status of jira TEIID-3117 to Closed
Created attachment 934776 [details] dynamic vdb Description of problem: 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"/>). How reproducible: 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 Additional info: exception, excel files, dynamic vdb in attachment