Bug 1138697 - NullPointerException while creating source model from Excel table
Summary: NullPointerException while creating source model from Excel table
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: JBoss Data Virtualization 6
Classification: JBoss
Component: Teiid
Version: 6.1.0
Hardware: x86_64
OS: Linux
unspecified
unspecified
Target Milestone: ER3
: 6.1.0
Assignee: Van Halbert
QA Contact:
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2014-09-05 13:19 UTC by Juraj Duráni
Modified: 2016-02-10 08:49 UTC (History)
3 users (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
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.
Clone Of:
Environment:
Last Closed: 2016-02-10 08:49:05 UTC
Type: Bug
Embargoed:

Attachments (Terms of Use)
dynamic vdb (497 bytes, text/plain)
2014-09-05 13:19 UTC, Juraj Duráni 		no flags Details
View All


Links
System ID Private Priority Status Summary Last Updated
Red Hat Issue Tracker TEIID-3026 0 Major Closed NPE using Excel translator 2016-01-26 13:22:42 UTC
Red Hat Issue Tracker TEIID-3117 0 Major Closed NullPointerException while creating source model from Excel table 2016-01-26 13:22:42 UTC

Description Juraj Duráni 2014-09-05 13:19:59 UTC 
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 2 JBoss JIRA Server 2014-09-05 21:03:41 UTC 
Ramesh Reddy <rareddy> updated the status of jira TEIID-3117 to Resolved
Comment 3 JBoss JIRA Server 2014-11-19 18:37:31 UTC 
Steven Hawkins <shawkins> updated the status of jira TEIID-3117 to Closed
Note You need to log in before you can comment on or make changes to this bug.