[JBoss JIRA] (TEIIDDES-3075) teiid designer fails to import excel file
by Michael Echevarria (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-3075?page=com.atlassian.jira.plu... ]
Michael Echevarria updated TEIIDDES-3075:
-----------------------------------------
Steps to Reproduce:
file -> import -> teiid connection >> source model
create new datasource
driver: file
location: folder of excel file /home/mechevar/git/jdv-test/assets/excel
next
select excel translator
Data Row number: 2
Excel file: colors.xlsx
Header Row number: 1
next, gave file name, did not uncheck any boxes
ddl in prompt:
SET NAMESPACE 'http://www.teiid.org/translator/excel/2014' AS teiid_excel;
CREATE FOREIGN TABLE Sheet1 (
ROW_ID integer OPTIONS (SEARCHABLE 'All_Except_Like', "teiid_excel:CELL_NUMBER" 'ROW_ID'),
id double OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '1'),
color string OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '2'),
CONSTRAINT PK0 PRIMARY KEY(ROW_ID)
) OPTIONS (NAMEINSOURCE 'Sheet1', "teiid_excel:FILE" 'colors.xlsx', "teiid_excel:FIRST_DATA_ROW_NUMBER" '2');
afterwards set length property to 255 for color column
attempt to preview data:
org.teiid.runtime.client.TeiidClientException: java.lang.RuntimeException: Remote org.teiid.core.TeiidProcessingException: TEIID30504 excel_ds: TEIID23007 OPTIONS property CELL_NUMBER is required and it not defined on column ROW_ID
was:
file -> import -> teiid connection >> source model
create new datasource
driver: file
location: folder of excel file /home/mechevar/git/jdv-test/assets/excel
next
select excel translator
Data Row number: 2
Excel file: colors.xlsx
Header Row number: 1
next, gave file name, did not uncheck any boxes
ddl in prompt:
SET NAMESPACE 'http://www.teiid.org/translator/excel/2014' AS teiid_excel;
CREATE FOREIGN TABLE Sheet1 (
ROW_ID integer OPTIONS (SEARCHABLE 'All_Except_Like', "teiid_excel:CELL_NUMBER" 'ROW_ID'),
id double OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '1'),
color string OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '2'),
CONSTRAINT PK0 PRIMARY KEY(ROW_ID)
) OPTIONS (NAMEINSOURCE 'Sheet1', "teiid_excel:FILE" 'colors.xlsx', "teiid_excel:FIRST_DATA_ROW_NUMBER" '2');
afterwards set length property to 255 for color property
attempt to preview data:
org.teiid.runtime.client.TeiidClientException: java.lang.RuntimeException: Remote org.teiid.core.TeiidProcessingException: TEIID30504 excel_ds: TEIID23007 OPTIONS property CELL_NUMBER is required and it not defined on column ROW_ID
> teiid designer fails to import excel file
> -----------------------------------------
>
> Key: TEIIDDES-3075
> URL: https://issues.jboss.org/browse/TEIIDDES-3075
> Project: Teiid Designer
> Issue Type: Bug
> Components: Import/Export
> Affects Versions: 11.0.1
> Environment: JBoss Developer Studio 10.3.0 with teiid designer 11.0.1 on Linux
> Reporter: Michael Echevarria
> Attachments: colors.xlsx
>
>
> After importing an excel file, attempting to preview the data results in the following error:
> Connector worker process failed for atomic-request=9241FCRcB/yA.0.0.1: org.teiid.translator.TranslatorException: TEIID23007 OPTIONS property CELL_NUMBER is required and it not defined on column ROW_ID
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)