[
https://issues.jboss.org/browse/TEIIDDES-2182?page=com.atlassian.jira.plu...
]
Ramesh Reddy commented on TEIIDDES-2182:
----------------------------------------
[~mdrillin] Is that all the DDL you received from Teiid Server? If yes, in that case there
may be an issue with the DDL generation on the Teiid side, is should have included
{code}
SET NAMESPACE 'http://www.teiid.org/translator/excel/2014' AS teiid_excel
{code}
if not that is an error IMO. You can open JIRA if that is the case, will fix on the Teiid
side. When/If available, you can check this against the namespace in the Designer side to
match up with names. Otherwise we will never be in sync.
Issues with Excel import
------------------------
Key: TEIIDDES-2182
URL:
https://issues.jboss.org/browse/TEIIDDES-2182
Project: Teiid Designer
Issue Type: Bug
Components: Import/Export
Affects Versions: 8.5
Reporter: Mark Drilling
Assignee: Mark Drilling
Fix For: 8.5
Attachments: excelSheet.ddl
See comment on this community thread -
https://community.jboss.org/wiki/MicrosoftExcelDocumentIntoRelationalTable
There are a couple of issues with this scenario in Designer:
1)
{code}
org.eclipse.core.runtime.CoreException: An exception occurred while performing an
operation
at org.teiid.designer.ui.util.ErrorHandler.toCoreException(ErrorHandler.java:68)
at org.teiid.designer.ui.util.ErrorHandler.toExceptionDialog(ErrorHandler.java:115)
at
org.teiid.designer.teiidimporter.ui.wizard.TeiidImportManager.saveUsingDdlDiffReport(TeiidImportManager.java:818)
at
org.teiid.designer.teiidimporter.ui.wizard.TeiidImportWizard.finish(TeiidImportWizard.java:197)
at
org.teiid.designer.ui.common.wizard.AbstractWizard.performFinish(AbstractWizard.java:356)
at org.eclipse.jface.wizard.WizardDialog.finishPressed(WizardDialog.java:827)
at org.eclipse.jface.wizard.WizardDialog.buttonPressed(WizardDialog.java:432)
{code}
This is a bug with the array init on line 791 of TeiidImportManager
2) The "CELL_NUMBER" issue is due to Designer not processing the extension
properties for excel properly. The incoming namespace on the DDL options (teiid_excel)
does not match it's MED namespace in Designer (excel). Need to resolve this
disconnect.
--
This message was sent by Atlassian JIRA
(v6.2.3#6260)