[
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)