[JBoss JIRA] (TEIIDDES-2776) Preview fails for file source table after a Server stop and restart
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2776?page=com.atlassian.jira.plu... ]
Barry LaFond updated TEIIDDES-2776:
-----------------------------------
Fix Version/s: (was: 9.0.7)
> Preview fails for file source table after a Server stop and restart
> -------------------------------------------------------------------
>
> Key: TEIIDDES-2776
> URL: https://issues.jboss.org/browse/TEIIDDES-2776
> Project: Teiid Designer
> Issue Type: Bug
> Components: Data Preview, Patch Release
> Affects Versions: 9.0.3
> Reporter: Debbie Steigner
> Assignee: Paul Richardson
> Fix For: 10.0.2
>
> Attachments: testcsv.csv, TestModelProjectSet.zip
>
>
> I have only seen this with a flat file source, standard jdbc database tables only need the "Refresh/Reconnect Teiid Instance Connection" button to refresh and have previews work again.
> Setup a Remote Server in JBDS
> select Server externally managed
> Remote and Remote Management Commands
> * Create a new model project, add a File source
> * Create a view model and do a preview on the view table
> That works! Great.
> Then:
> * We right-click the server and press Stop. Then press Start
> * Now when you try to preview again, it fails. The EAP server is in a reload-required state and the below error is shown in Designer log and a pop-up:
> !ENTRY org.teiid.designer.dqp.ui 4 0 2016-02-05 13:37:38.436
> !MESSAGE JBAS010473: Failed to load module for RA [org.jboss.teiid.resource-adapter.file]
> !STACK 0
> org.teiid.adminapi.AdminProcessingException: JBAS010473: Failed to load module for RA [org.jboss.teiid.resource-adapter.file]
> at org.teiid.runtime.client.admin.v8.Admin8Factory$ResultCallback.onFailure(Admin8Factory.java:202)
> at org.teiid.runtime.client.admin.v8.Admin8Factory$AdminImpl.cliCall(Admin8Factory.java:1591)
> at org.teiid.runtime.client.admin.v8.Admin8Factory$AdminImpl.addModuleResourceAdapter(Admin8Factory.java:397)
> at org.teiid.runtime.client.admin.v8.Admin8Factory$AdminImpl.createConnectionFactory(Admin8Factory.java:303)
> at org.teiid.runtime.client.admin.v8.Admin8Factory$AdminImpl.createDataSource(Admin8Factory.java:497)
> at org.teiid.runtime.client.admin.ExecutionAdmin.getOrCreateDataSource(ExecutionAdmin.java:373)
> at org.teiid.designer.runtime.TeiidServer.getOrCreateDataSource(TeiidServer.java:614)
> at org.teiid.designer.runtime.TeiidDataSourceFactory.createDataSource(TeiidDataSourceFactory.java:177)
> at org.teiid.designer.runtime.preview.PreviewManager.ensureConnectionInfoIsValid(PreviewManager.java:527)
> at org.teiid.designer.runtime.preview.PreviewManager.previewSetup(PreviewManager.java:1365)
> at org.teiid.designer.runtime.ui.preview.PreviewDataWorker$1.run(PreviewDataWorker.java:233)
> at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:119)
> !ENTRY org.teiid.designer.ui 4 0 2016-02-05 13:37:38.863
> !MESSAGE Error running preview. See log for more information.
> !STACK 1
> org.eclipse.core.runtime.CoreException: Error running preview. See log for more information.
> at org.teiid.designer.ui.util.ErrorHandler.toCoreException(ErrorHandler.java:68)
> at org.teiid.designer.ui.util.ErrorHandler.toExceptionDialog(ErrorHandler.java:106)
> at org.teiid.designer.runtime.ui.preview.PreviewDataWorker.run(PreviewDataWorker.java:255)
> at org.teiid.designer.runtime.ui.preview.PreviewTableDataContextAction.run(PreviewTableDataContextAction.java:99)
> at org.eclipse.jface.action.Action.runWithEvent(Action.java:473)
> at org.eclipse.jface.action.ActionContributionItem.handleWidgetSelection(ActionContributionItem.java:595)
> at org.eclipse.jface.action.ActionContributionItem.access$2(ActionContributionItem.java:511)
> at org.eclipse.jface.action.ActionContributionItem$6.handleEvent(ActionContributionItem.java:462)
> at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)
> at org.eclipse.swt.widgets.Display.sendEvent(Display.java:4481)
> at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1329)
> at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3819)
> at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3430)
> at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine$4.run(PartRenderingEngine.java:1127)
> at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:337)
> at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine.run(PartRenderingEngine.java:1018)
> at org.eclipse.e4.ui.internal.workbench.E4Workbench.createAndRunUI(E4Workbench.java:156)
> at org.eclipse.ui.internal.Workbench$5.run(Workbench.java:654)
> at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:337)
> at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:598)
> at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:150)
> at org.eclipse.ui.internal.ide.application.IDEApplication.start(IDEApplication.java:139)
> at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196)
> at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:134)
> at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:104)
> at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:380)
> at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:235)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:497)
> at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:669)
> at org.eclipse.equinox.launcher.Main.basicRun(Main.java:608)
> at org.eclipse.equinox.launcher.Main.run(Main.java:1515)
> at org.eclipse.equinox.launcher.Main.main(Main.java:1488)
> Contains: * JBAS010473: Failed to load module for RA [org.jboss.teiid.resource-adapter.file]
> !SUBENTRY 1 org.teiid.designer.ui 4 4 2016-02-05 13:37:38.864
> !MESSAGE Error running preview. See log for more information.
> !SUBENTRY 2 org.teiid.designer.ui 4 0 2016-02-05 13:37:38.864
> !MESSAGE * JBAS010473: Failed to load module for RA [org.jboss.teiid.resource-adapter.file]
> To fix it:
> * We run a :reload on the EAP server with jboss-cli
> * Then preview works again.
> So, desired fix, when the server is in a reload-required state, reload the server or at least prompt for it instead of erroring out.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 8 months
[JBoss JIRA] (TEIIDDES-2776) Preview fails for file source table after a Server stop and restart
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2776?page=com.atlassian.jira.plu... ]
Barry LaFond commented on TEIIDDES-2776:
----------------------------------------
dropping 9.0.7 target. Will implement in 10.0.2 Mars
> Preview fails for file source table after a Server stop and restart
> -------------------------------------------------------------------
>
> Key: TEIIDDES-2776
> URL: https://issues.jboss.org/browse/TEIIDDES-2776
> Project: Teiid Designer
> Issue Type: Bug
> Components: Data Preview, Patch Release
> Affects Versions: 9.0.3
> Reporter: Debbie Steigner
> Assignee: Paul Richardson
> Fix For: 9.0.7, 10.0.2
>
> Attachments: testcsv.csv, TestModelProjectSet.zip
>
>
> I have only seen this with a flat file source, standard jdbc database tables only need the "Refresh/Reconnect Teiid Instance Connection" button to refresh and have previews work again.
> Setup a Remote Server in JBDS
> select Server externally managed
> Remote and Remote Management Commands
> * Create a new model project, add a File source
> * Create a view model and do a preview on the view table
> That works! Great.
> Then:
> * We right-click the server and press Stop. Then press Start
> * Now when you try to preview again, it fails. The EAP server is in a reload-required state and the below error is shown in Designer log and a pop-up:
> !ENTRY org.teiid.designer.dqp.ui 4 0 2016-02-05 13:37:38.436
> !MESSAGE JBAS010473: Failed to load module for RA [org.jboss.teiid.resource-adapter.file]
> !STACK 0
> org.teiid.adminapi.AdminProcessingException: JBAS010473: Failed to load module for RA [org.jboss.teiid.resource-adapter.file]
> at org.teiid.runtime.client.admin.v8.Admin8Factory$ResultCallback.onFailure(Admin8Factory.java:202)
> at org.teiid.runtime.client.admin.v8.Admin8Factory$AdminImpl.cliCall(Admin8Factory.java:1591)
> at org.teiid.runtime.client.admin.v8.Admin8Factory$AdminImpl.addModuleResourceAdapter(Admin8Factory.java:397)
> at org.teiid.runtime.client.admin.v8.Admin8Factory$AdminImpl.createConnectionFactory(Admin8Factory.java:303)
> at org.teiid.runtime.client.admin.v8.Admin8Factory$AdminImpl.createDataSource(Admin8Factory.java:497)
> at org.teiid.runtime.client.admin.ExecutionAdmin.getOrCreateDataSource(ExecutionAdmin.java:373)
> at org.teiid.designer.runtime.TeiidServer.getOrCreateDataSource(TeiidServer.java:614)
> at org.teiid.designer.runtime.TeiidDataSourceFactory.createDataSource(TeiidDataSourceFactory.java:177)
> at org.teiid.designer.runtime.preview.PreviewManager.ensureConnectionInfoIsValid(PreviewManager.java:527)
> at org.teiid.designer.runtime.preview.PreviewManager.previewSetup(PreviewManager.java:1365)
> at org.teiid.designer.runtime.ui.preview.PreviewDataWorker$1.run(PreviewDataWorker.java:233)
> at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:119)
> !ENTRY org.teiid.designer.ui 4 0 2016-02-05 13:37:38.863
> !MESSAGE Error running preview. See log for more information.
> !STACK 1
> org.eclipse.core.runtime.CoreException: Error running preview. See log for more information.
> at org.teiid.designer.ui.util.ErrorHandler.toCoreException(ErrorHandler.java:68)
> at org.teiid.designer.ui.util.ErrorHandler.toExceptionDialog(ErrorHandler.java:106)
> at org.teiid.designer.runtime.ui.preview.PreviewDataWorker.run(PreviewDataWorker.java:255)
> at org.teiid.designer.runtime.ui.preview.PreviewTableDataContextAction.run(PreviewTableDataContextAction.java:99)
> at org.eclipse.jface.action.Action.runWithEvent(Action.java:473)
> at org.eclipse.jface.action.ActionContributionItem.handleWidgetSelection(ActionContributionItem.java:595)
> at org.eclipse.jface.action.ActionContributionItem.access$2(ActionContributionItem.java:511)
> at org.eclipse.jface.action.ActionContributionItem$6.handleEvent(ActionContributionItem.java:462)
> at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)
> at org.eclipse.swt.widgets.Display.sendEvent(Display.java:4481)
> at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1329)
> at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3819)
> at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3430)
> at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine$4.run(PartRenderingEngine.java:1127)
> at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:337)
> at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine.run(PartRenderingEngine.java:1018)
> at org.eclipse.e4.ui.internal.workbench.E4Workbench.createAndRunUI(E4Workbench.java:156)
> at org.eclipse.ui.internal.Workbench$5.run(Workbench.java:654)
> at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:337)
> at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:598)
> at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:150)
> at org.eclipse.ui.internal.ide.application.IDEApplication.start(IDEApplication.java:139)
> at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196)
> at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:134)
> at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:104)
> at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:380)
> at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:235)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:497)
> at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:669)
> at org.eclipse.equinox.launcher.Main.basicRun(Main.java:608)
> at org.eclipse.equinox.launcher.Main.run(Main.java:1515)
> at org.eclipse.equinox.launcher.Main.main(Main.java:1488)
> Contains: * JBAS010473: Failed to load module for RA [org.jboss.teiid.resource-adapter.file]
> !SUBENTRY 1 org.teiid.designer.ui 4 4 2016-02-05 13:37:38.864
> !MESSAGE Error running preview. See log for more information.
> !SUBENTRY 2 org.teiid.designer.ui 4 0 2016-02-05 13:37:38.864
> !MESSAGE * JBAS010473: Failed to load module for RA [org.jboss.teiid.resource-adapter.file]
> To fix it:
> * We run a :reload on the EAP server with jboss-cli
> * Then preview works again.
> So, desired fix, when the server is in a reload-required state, reload the server or at least prompt for it instead of erroring out.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 8 months
[JBoss JIRA] (TEIIDDES-2522) VDB Role Editor does not show when added
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2522?page=com.atlassian.jira.plu... ]
Barry LaFond commented on TEIIDDES-2522:
----------------------------------------
Pushing to 10.0.2 only
> VDB Role Editor does not show when added
> ----------------------------------------
>
> Key: TEIIDDES-2522
> URL: https://issues.jboss.org/browse/TEIIDDES-2522
> Project: Teiid Designer
> Issue Type: Bug
> Components: Editors, Patch Release, VDB & Execution
> Affects Versions: 9.0
> Environment: Mac
> JBDS Version: 8.0.0.GA
> Build id: GA-v20141020-1042-B317
> Teiid Designer version: 9.0.1.Final-v20150211-1407-B643
> Reporter: Marc Shirley
> Assignee: Ted Jones
> Fix For: 10.0.2
>
>
> Newly added roles do not show up, but instead require the editor to be switched off of the Role view and then back to the Role view in order to view changes.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 8 months
[JBoss JIRA] (TEIIDDES-2522) VDB Role Editor does not show when added
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2522?page=com.atlassian.jira.plu... ]
Barry LaFond updated TEIIDDES-2522:
-----------------------------------
Fix Version/s: (was: 9.0.7)
> VDB Role Editor does not show when added
> ----------------------------------------
>
> Key: TEIIDDES-2522
> URL: https://issues.jboss.org/browse/TEIIDDES-2522
> Project: Teiid Designer
> Issue Type: Bug
> Components: Editors, Patch Release, VDB & Execution
> Affects Versions: 9.0
> Environment: Mac
> JBDS Version: 8.0.0.GA
> Build id: GA-v20141020-1042-B317
> Teiid Designer version: 9.0.1.Final-v20150211-1407-B643
> Reporter: Marc Shirley
> Assignee: Ted Jones
> Fix For: 10.0.2
>
>
> Newly added roles do not show up, but instead require the editor to be switched off of the Role view and then back to the Role view in order to view changes.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 8 months
[JBoss JIRA] (TEIIDDES-2838) Setting connection profile to imported model won't set data source (issues with Preview)
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2838?page=com.atlassian.jira.plu... ]
Barry LaFond updated TEIIDDES-2838:
-----------------------------------
Fix Version/s: 10.0.2
> Setting connection profile to imported model won't set data source (issues with Preview)
> ----------------------------------------------------------------------------------------
>
> Key: TEIIDDES-2838
> URL: https://issues.jboss.org/browse/TEIIDDES-2838
> Project: Teiid Designer
> Issue Type: Bug
> Affects Versions: 10.0.1
> Reporter: Matus Makovy
> Priority: Blocker
> Fix For: 10.0.2
>
> Attachments: Screen Shot 2016-05-09 at 16.35.06.png, Screen Shot 2016-05-09 at 16.54.45.png
>
>
> I imported an existing project into TD with 2 source models and 1 view model.
> After I set a connection profile to source model (via Modeling -> Set connection profile) it appears that Data Source is not set. As a result of this when I hit preview (Modeling -> Preview data) on some table in this model, it fails. Because the jndi-name in the dynamic vdb is set to null.
> See screenshots
> I am setting the priority to critical, because this used to work before.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 8 months
[JBoss JIRA] (TEIIDDES-2838) Setting connection profile to imported model won't set data source (issues with Preview)
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2838?page=com.atlassian.jira.plu... ]
Barry LaFond reassigned TEIIDDES-2838:
--------------------------------------
Assignee: Barry LaFond
> Setting connection profile to imported model won't set data source (issues with Preview)
> ----------------------------------------------------------------------------------------
>
> Key: TEIIDDES-2838
> URL: https://issues.jboss.org/browse/TEIIDDES-2838
> Project: Teiid Designer
> Issue Type: Bug
> Affects Versions: 10.0.1
> Reporter: Matus Makovy
> Assignee: Barry LaFond
> Priority: Blocker
> Fix For: 10.0.2
>
> Attachments: Screen Shot 2016-05-09 at 16.35.06.png, Screen Shot 2016-05-09 at 16.54.45.png
>
>
> I imported an existing project into TD with 2 source models and 1 view model.
> After I set a connection profile to source model (via Modeling -> Set connection profile) it appears that Data Source is not set. As a result of this when I hit preview (Modeling -> Preview data) on some table in this model, it fails. Because the jndi-name in the dynamic vdb is set to null.
> See screenshots
> I am setting the priority to critical, because this used to work before.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 8 months
[JBoss JIRA] (TEIIDDES-2683) Importing Excel file using Teiid Connection does not import extension properties
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2683?page=com.atlassian.jira.plu... ]
Barry LaFond reassigned TEIIDDES-2683:
--------------------------------------
Assignee: Barry LaFond
> Importing Excel file using Teiid Connection does not import extension properties
> --------------------------------------------------------------------------------
>
> Key: TEIIDDES-2683
> URL: https://issues.jboss.org/browse/TEIIDDES-2683
> Project: Teiid Designer
> Issue Type: Bug
> Components: Import/Export
> Affects Versions: 9.0.4
> Reporter: Andrej Šmigala
> Assignee: Barry LaFond
> Fix For: 10.0.2
>
>
> When importing an excel file using Teiid Connection, the extension properties are silently discarded. This results in invalid model, which, when deployed and queried, causes the following error in the server log:
> bq. Connector worker process failed for atomic-request=AVU37BnZoOUS.0.0.0: org.teiid.translator.TranslatorException: TEIID23007 OPTIONS property CELL_NUMBER is required and it not defined on column ROW_ID
> The DDL obtained from the server is
> {code:sql}
> 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'),
> StringNum string OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '1'),
> CharValue string OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '2'),
> DoubleNum double OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '3'),
> BigIntegerValue double OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '4'),
> ShortValue double OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '5'),
> FloatNum double OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '6'),
> ObjectValue string OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '7'),
> IntNum double OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '8'),
> BigDecimalValue double OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '9'),
> LongNum double OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '10'),
> BooleanValue boolean OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '11'),
> TimestampValue double OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '12'),
> ByteNum double OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '13'),
> IntKey double OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '14'),
> StringKey string OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '15'),
> TimeValue double OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '16'),
> DateValue double OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '17'),
> CONSTRAINT PK0 PRIMARY KEY(ROW_ID)
> ) OPTIONS ("teiid_excel:FILE" 'smalla.xlsx', "teiid_excel:FIRST_DATA_ROW_NUMBER" '2');
> {code}
> When trying to import the same DDL using the DDL import wizard, a warning dialog is shown stating that the extension properties could not be processed and the Model Extension Definition should be registered
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 8 months
[JBoss JIRA] (TEIIDDES-2683) Importing Excel file using Teiid Connection does not import extension properties
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2683?page=com.atlassian.jira.plu... ]
Barry LaFond updated TEIIDDES-2683:
-----------------------------------
Fix Version/s: 10.0.2
(was: 9.0.7)
> Importing Excel file using Teiid Connection does not import extension properties
> --------------------------------------------------------------------------------
>
> Key: TEIIDDES-2683
> URL: https://issues.jboss.org/browse/TEIIDDES-2683
> Project: Teiid Designer
> Issue Type: Bug
> Components: Import/Export
> Affects Versions: 9.0.4
> Reporter: Andrej Šmigala
> Fix For: 10.0.2
>
>
> When importing an excel file using Teiid Connection, the extension properties are silently discarded. This results in invalid model, which, when deployed and queried, causes the following error in the server log:
> bq. Connector worker process failed for atomic-request=AVU37BnZoOUS.0.0.0: org.teiid.translator.TranslatorException: TEIID23007 OPTIONS property CELL_NUMBER is required and it not defined on column ROW_ID
> The DDL obtained from the server is
> {code:sql}
> 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'),
> StringNum string OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '1'),
> CharValue string OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '2'),
> DoubleNum double OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '3'),
> BigIntegerValue double OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '4'),
> ShortValue double OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '5'),
> FloatNum double OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '6'),
> ObjectValue string OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '7'),
> IntNum double OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '8'),
> BigDecimalValue double OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '9'),
> LongNum double OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '10'),
> BooleanValue boolean OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '11'),
> TimestampValue double OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '12'),
> ByteNum double OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '13'),
> IntKey double OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '14'),
> StringKey string OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '15'),
> TimeValue double OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '16'),
> DateValue double OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '17'),
> CONSTRAINT PK0 PRIMARY KEY(ROW_ID)
> ) OPTIONS ("teiid_excel:FILE" 'smalla.xlsx', "teiid_excel:FIRST_DATA_ROW_NUMBER" '2');
> {code}
> When trying to import the same DDL using the DDL import wizard, a warning dialog is shown stating that the extension properties could not be processed and the Model Extension Definition should be registered
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 8 months
[JBoss JIRA] (TEIIDDES-2683) Importing Excel file using Teiid Connection does not import extension properties
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2683?page=com.atlassian.jira.plu... ]
Barry LaFond edited comment on TEIIDDES-2683 at 5/12/16 12:15 PM:
------------------------------------------------------------------
I tested with both 10.0 and 9.0.7 branches and this import works as long as:
1) Teiid Dialect is selected in 9.0.7 version
* in Designer 10.0 there's a separate Import Teiid DDL wizard
2) A Server has been defined and connected.
* The Excel Extensions are defined in the server and discovered via the Teiid API and stored locally in a user's .metadata in a MED registry. I did replicate the error for a new workspace with NO server defined. Looks like there's a bug that can't locate the *excel* MED until user has connected to server, then exited and restarted Designer. So there is a work-around.
Pushing to 10.0.2 only.
was (Author: blafond):
I tested with both 10.0 and 9.0.7 branches and this import works as long as:
1) Teiid Dialect is selected in 9.0.7 version
* in Designer 10.0 there's a separate Import Teiid DDL wizard
2) A Server has been defined and connected.
* The Excel Extensions are defined in the server and discovered via the Teiid API and stored locally in a user's .metadata in a MED registry. I did replicate the error for a new workspace with NO server defined. Looks like there's a bug that can't locate the *excel* MED until user has connected to server, then exited and restarted Designer. So there is a work-around.
Pushing to 10.0.2 only.
> Importing Excel file using Teiid Connection does not import extension properties
> --------------------------------------------------------------------------------
>
> Key: TEIIDDES-2683
> URL: https://issues.jboss.org/browse/TEIIDDES-2683
> Project: Teiid Designer
> Issue Type: Bug
> Components: Import/Export
> Affects Versions: 9.0.4
> Reporter: Andrej Šmigala
> Fix For: 9.0.7
>
>
> When importing an excel file using Teiid Connection, the extension properties are silently discarded. This results in invalid model, which, when deployed and queried, causes the following error in the server log:
> bq. Connector worker process failed for atomic-request=AVU37BnZoOUS.0.0.0: org.teiid.translator.TranslatorException: TEIID23007 OPTIONS property CELL_NUMBER is required and it not defined on column ROW_ID
> The DDL obtained from the server is
> {code:sql}
> 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'),
> StringNum string OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '1'),
> CharValue string OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '2'),
> DoubleNum double OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '3'),
> BigIntegerValue double OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '4'),
> ShortValue double OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '5'),
> FloatNum double OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '6'),
> ObjectValue string OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '7'),
> IntNum double OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '8'),
> BigDecimalValue double OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '9'),
> LongNum double OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '10'),
> BooleanValue boolean OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '11'),
> TimestampValue double OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '12'),
> ByteNum double OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '13'),
> IntKey double OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '14'),
> StringKey string OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '15'),
> TimeValue double OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '16'),
> DateValue double OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '17'),
> CONSTRAINT PK0 PRIMARY KEY(ROW_ID)
> ) OPTIONS ("teiid_excel:FILE" 'smalla.xlsx', "teiid_excel:FIRST_DATA_ROW_NUMBER" '2');
> {code}
> When trying to import the same DDL using the DDL import wizard, a warning dialog is shown stating that the extension properties could not be processed and the Model Extension Definition should be registered
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 8 months
[JBoss JIRA] (TEIIDDES-2683) Importing Excel file using Teiid Connection does not import extension properties
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2683?page=com.atlassian.jira.plu... ]
Barry LaFond commented on TEIIDDES-2683:
----------------------------------------
I tested with both 10.0 and 9.0.7 branches and this import works as long as:
1) Teiid Dialect is selected in 9.0.7 version
* in Designer 10.0 there's a separate Import Teiid DDL wizard
2) A Server has been defined and connected.
* The Excel Extensions are defined in the server and discovered via the Teiid API and stored locally in a user's .metadata in a MED registry. I did replicate the error for a new workspace with NO server defined. Looks like there's a bug that can't locate the *excel* MED until user has connected to server, then exited and restarted Designer. So there is a work-around.
Pushing to 10.0.2 only.
> Importing Excel file using Teiid Connection does not import extension properties
> --------------------------------------------------------------------------------
>
> Key: TEIIDDES-2683
> URL: https://issues.jboss.org/browse/TEIIDDES-2683
> Project: Teiid Designer
> Issue Type: Bug
> Components: Import/Export
> Affects Versions: 9.0.4
> Reporter: Andrej Šmigala
> Fix For: 9.0.7
>
>
> When importing an excel file using Teiid Connection, the extension properties are silently discarded. This results in invalid model, which, when deployed and queried, causes the following error in the server log:
> bq. Connector worker process failed for atomic-request=AVU37BnZoOUS.0.0.0: org.teiid.translator.TranslatorException: TEIID23007 OPTIONS property CELL_NUMBER is required and it not defined on column ROW_ID
> The DDL obtained from the server is
> {code:sql}
> 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'),
> StringNum string OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '1'),
> CharValue string OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '2'),
> DoubleNum double OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '3'),
> BigIntegerValue double OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '4'),
> ShortValue double OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '5'),
> FloatNum double OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '6'),
> ObjectValue string OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '7'),
> IntNum double OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '8'),
> BigDecimalValue double OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '9'),
> LongNum double OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '10'),
> BooleanValue boolean OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '11'),
> TimestampValue double OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '12'),
> ByteNum double OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '13'),
> IntKey double OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '14'),
> StringKey string OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '15'),
> TimeValue double OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '16'),
> DateValue double OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '17'),
> CONSTRAINT PK0 PRIMARY KEY(ROW_ID)
> ) OPTIONS ("teiid_excel:FILE" 'smalla.xlsx', "teiid_excel:FIRST_DATA_ROW_NUMBER" '2');
> {code}
> When trying to import the same DDL using the DDL import wizard, a warning dialog is shown stating that the extension properties could not be processed and the Model Extension Definition should be registered
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 8 months