[
https://issues.jboss.org/browse/TEIID-3026?page=com.atlassian.jira.plugin...
]
Ramesh Reddy resolved TEIID-3026.
---------------------------------
Fix Version/s: 8.7.1
8.8
Resolution: Done
There couple issues I found
- When there is empty sheet next to correct sheet, the translator tries to read metadata
at header row defined, however that always returns a null, thus NPE. Added validation to
check for null.
- Also, when header is not found the translator scans the rows to find the header row, and
there is no max how many row this will scan. So, the code was scanning rows well after 1M+
giving impression the thread is locked. Limited the header row scan to 10K. If the header
is not found in first 10K rows the scan is aborted
- The header and data row numbers in POI is zero indexed, in excel sheet they are 1 based.
Added code such that if user incorrectly used 0 based, translator does not compute
negative values
NPE using Excel translator
--------------------------
Key: TEIID-3026
URL:
https://issues.jboss.org/browse/TEIID-3026
Project: Teiid
Issue Type: Bug
Security Level: Public(Everyone can see)
Reporter: Ramesh Reddy
Assignee: Ramesh Reddy
Fix For: 8.7.1, 8.8
{code}
10:48:26,620 WARN [org.teiid.RUNTIME] (teiid-async-threads - 3) TEIID50036 VDB
importVDB.1 model "importVDBSrcModel" metadata failed to load.
Reason:java.lang.NullPointerException: java.lang.NullPointerException
at
org.teiid.translator.excel.ExcelMetadataProcessor.addTable(ExcelMetadataProcessor.java:106)
at org.teiid.translator.excel.ExcelMetadataProcessor.process(ExcelMetadataP
rocessor.java:87)
at
org.teiid.translator.excel.ExcelMetadataProcessor.process(ExcelMetadataProcessor.java:45)
at org.teiid.translator.ExecutionFactory.getMetadata(ExecutionFactory.java:915)
[teiid-api-8.7.0.Final.jar:8.7.0.Final]
at
org.teiid.query.metadata.NativeMetadataRepository.loadMetadata(NativeMetadataRepository.java:73)
[teiid-engine-8.7.0.Final.jar:8.7.0.Final]
at
org.teiid.query.metadata.ChainingMetadataRepository.loadMetadata(ChainingMetadataRepository.java:55)
[teiid-engine-8.7.0.Final.jar:8.7.0.Final]
at org.teiid.jboss.VDBService$6.run(VDBService.java:395)
[teiid-jboss-integration-8.7.0.Final.jar:8.7.0.Final]
at org.teiid.jboss.VDBService$7.run(VDBService.java:442)
[teiid-jboss-integration-8.7.0.Final.jar:8.7.0.Final]
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895)
[rt.jar:1.6.0_45]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918)
[rt.jar:1.6.0_45]
at java.lang.Thread.run(Thread.java:662) [rt.jar:1.6.0_45]
at org.jboss.threads.JBossThread.run(JBossThread.java:122)
{code}
--
This message was sent by Atlassian JIRA
(v6.2.6#6264)