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:
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.