[teiid-issues] [JBoss JIRA] (TEIID-3117) NullPointerException while creating source model from Excel table

[Ramesh Reddy (JIRA)]

     [ https://issues.jboss.org/browse/TEIID-3117?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

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)