[JBoss JIRA] (TEIID-3117) NullPointerException while creating source model from Excel table
- First Post
- Replies
- Stats
-
Go to
- ----- 2025 -----
- January
- ----- 2024 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2023 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2022 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2021 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2020 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2019 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2018 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2017 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2016 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2015 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2014 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2013 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2012 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2011 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2010 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2009 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
[
https://issues.jboss.org/browse/TEIID-3117?page=com.atlassian.jira.plugin...
]
Ramesh Reddy resolved TEIID-3117.
---------------------------------
Labels: Beta1 (was: )
Fix Version/s: 8.7.1
8.9
Resolution: Done
The issue here is during the metadata building, the translator looks at the data row
configured to sniff out the data types. If the given data row has a empty cell, the above
exception occurs.
As workaround, when a cell is empty, I have added code to look for non empty cell in the
next available row, it that 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.
NullPointerException while creating source model from Excel table
-----------------------------------------------------------------
Key: TEIID-3117
URL: https://issues.jboss.org/browse/TEIID-3117
Project: Teiid
Issue Type: Bug
Affects Versions: 8.7
Environment: Fedora 20, data virtualization 6.1.0.ER1
Reporter: Juraj Duráni
Assignee: Ramesh Reddy
Labels: Beta1
Fix For: 8.7.1, 8.9
Attachments: ExcelDynamic-vdb.xml, Server.log, smalla.xlsx, smalla_raw.xlsx
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"/>).
--
This message was sent by Atlassian JIRA
(v6.3.1#6329)
3780
days inactive
3780
days old
0 comments
1 participants
tags (0)
participants (1)
-
Ramesh Reddy (JIRA)