[JBoss JIRA] (TEIIDDES-2167) Cannot find registered translator "file" when deploying or executing VDB; preview works
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2167?page=com.atlassian.jira.plu... ]
Barry LaFond resolved TEIIDDES-2167.
------------------------------------
Resolution: Incomplete Description
Thinking this might be related to TEIIDDES-2288 where the Teiid server wasn't fully loaded/started. This might cause the behavior or only 1 translator registered.
Also need Designer log attached to determine if it was something else.
Marking as Incomplete Descirption
> Cannot find registered translator "file" when deploying or executing VDB; preview works
> ---------------------------------------------------------------------------------------
>
> Key: TEIIDDES-2167
> URL: https://issues.jboss.org/browse/TEIIDDES-2167
> Project: Teiid Designer
> Issue Type: Bug
> Security Level: Public(Everyone can see)
> Components: Teiid Integration
> Affects Versions: 8.5
> Environment: Windows 7
> Eclipse Kepler with Designer 8.5.0.Alpha2
> JBoss EAP 6.1.0 Final
> JBoss Teiid 8.6.0 Final standalone (localhost)
> Reporter: John Muller
> Assignee: Mark Drilling
> Labels: FileConnector, translator
> Fix For: 8.6
>
> Attachments: standalone-teiid.xml, TEIIDDES-2167_console.log, TEIIDDES-2167_project.zip
>
> Original Estimate: 1 week
> Remaining Estimate: 1 week
>
> After modeling a simple CSV file using the "Create source model from local flat file source" and creating a Preview VDB deployed to a local standalone, unclustered Teiid 8.6 final box, the Preview VDB works. However, attempting to deploy the actual VDB fails with:
> "One or more models in VDB "zipFlatFileVDB" are either missing a translator name or have a translator name that is not found on the current Teiid Instance. These translator problems must be fixed before you can deploy the VDB".
> The source model's connection info is below in name -> value pairs:
> connectionProfileProviderId -> org.eclipse.datatools.connectivity.oda.flatfile
> ParentDirectory -> C:\Users\jmuller\Documents
> connectionProfileInstanceID -> 16447210-df7c-11e3-ad0b-97d7f7ba1428
> translator name -> file
> connectionProfileCategory -> org.eclipse.datatools.connectivity.oda.flatfile
> connectionProfileName -> zipFileSource
> connectionProfileDescription ->
> The FileManagedConnectionFactory datasource for the source model was created prior to attempting to deploy the VDB.
--
This message was sent by Atlassian JIRA
(v6.3.1#6329)
11 years, 3 months
[JBoss JIRA] (TEIIDDES-2152) Adding source table with quoted name results in wrong generated SQL statement
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2152?page=com.atlassian.jira.plu... ]
Barry LaFond updated TEIIDDES-2152:
-----------------------------------
Fix Version/s: 8.7
(was: 8.6)
(was: 8.3.4)
> Adding source table with quoted name results in wrong generated SQL statement
> -----------------------------------------------------------------------------
>
> Key: TEIIDDES-2152
> URL: https://issues.jboss.org/browse/TEIIDDES-2152
> Project: Teiid Designer
> Issue Type: Bug
> Security Level: Public(Everyone can see)
> Components: Transformations
> Affects Versions: 8.5
> Reporter: Barry LaFond
> Assignee: Paul Richardson
> Fix For: 8.7
>
>
> 1) Created source model with simple table named "My.Quoted.Table" (including quotes
> 2) Created simple virtual table and pasted: SELECT * FROM "My.Quoted.Table"
> 3) Parser returned a command resulting in the SQL: SELECT * FROM My.Quoted."Table"
> Parser should be able to handle quoted names properly. In this case the SQL should have been valid as is.
--
This message was sent by Atlassian JIRA
(v6.3.1#6329)
11 years, 3 months
[JBoss JIRA] (TEIIDDES-2222) Verify Teiid version discovery with remote servers
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2222?page=com.atlassian.jira.plu... ]
Barry LaFond updated TEIIDDES-2222:
-----------------------------------
Fix Version/s: 8.7
8.6.1
(was: 8.6)
> Verify Teiid version discovery with remote servers
> --------------------------------------------------
>
> Key: TEIIDDES-2222
> URL: https://issues.jboss.org/browse/TEIIDDES-2222
> Project: Teiid Designer
> Issue Type: Task
> Security Level: Public(Everyone can see)
> Components: Teiid Integration
> Affects Versions: 8.5
> Reporter: Mark Drilling
> Assignee: Paul Richardson
> Fix For: 8.7, 8.6.1
>
>
> Description of problem from Jason Stokes below. Need to test teiid version discovery with remote servers.
> We had a problem connecting to a TEIID/DV 6.0 instance on Amazon AWS via Jboss Dev Studio. (Never fully figured out why.) So we FTP'd our VDB we created in Teiid designer 8.5 and deployed it via the Jboss console. I
> forget the error, but something about incompatible versions.
> For whatever reason, JB Dev studio 7.1.1 (with 8.5 teiid designer) was
> reporting that the TEIID version of the AWS server was 8.6, even though it
> was 8.4. (As far as I know, they didn't do anything different but install
> it.) So the consensus was there was a mismatch between the fact we created a TEIID 8.4 version VDB and were trying to deploy it on the AWS server. (The local server I was testing with reported the correct version of TEIID 8.4 in dev studio.) Technically both installs should have been the same version though (8.4) so not sure what was going on.
--
This message was sent by Atlassian JIRA
(v6.3.1#6329)
11 years, 3 months
[JBoss JIRA] (TEIIDDES-1779) Designer error when trying to read a remote server configuration that's running in domain mode
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-1779?page=com.atlassian.jira.plu... ]
Barry LaFond updated TEIIDDES-1779:
-----------------------------------
Fix Version/s: 8.7
(was: 8.6)
> Designer error when trying to read a remote server configuration that's running in domain mode
> ----------------------------------------------------------------------------------------------
>
> Key: TEIIDDES-1779
> URL: https://issues.jboss.org/browse/TEIIDDES-1779
> Project: Teiid Designer
> Issue Type: Bug
> Security Level: Public(Everyone can see)
> Components: Teiid Integration
> Affects Versions: 8.2
> Reporter: Van Halbert
> Assignee: Paul Richardson
> Priority: Blocker
> Fix For: 8.7
>
>
> org.jboss.ide.eclipse.as.management.core.JBoss7ManangerException: org.jboss.ide.eclipse.as.management.core.JBoss7ManangerException: Could not execute "read-attribute" for [{"subsystem" => "teiid"}]. Failure was "JBAS014883: No resource definition is registered for address [(\"subsystem\" => \"teiid\")]".
> at org.jboss.ide.eclipse.as.internal.management.as71.AS71Manager.execute(AS71Manager.java:336)
> at org.jboss.ide.eclipse.as.internal.management.as71.JBoss71ManagerService.execute(JBoss71ManagerService.java:171)
> at org.jboss.ide.eclipse.as.management.core.JBoss7ManagerServiceProxy.execute(JBoss7ManagerServiceProxy.java:87)
> at org.teiid.designer.runtime.adapter.JBoss7ServerUtil.executeRequest(JBoss7ServerUtil.java:58)
> at org.teiid.designer.runtime.adapter.JBoss7ServerUtil.getTeiidRuntimeVersion(JBoss7ServerUtil.java:172)
> at org.teiid.designer.runtime.adapter.TeiidServerAdapterFactory.createJboss7TeiidServer(TeiidServerAdapterFactory.java:204)
> at org.teiid.designer.runtime.adapter.TeiidServerAdapterFactory.adaptJBoss7Server(TeiidServerAdapterFactory.java:185)
> at org.teiid.designer.runtime.adapter.TeiidServerAdapterFactory.adaptServer(TeiidServerAdapterFactory.java:78)
> at org.teiid.designer.runtime.TeiidParentServerListener.serverChanged(TeiidParentServerListener.java:66)
> at org.eclipse.wst.server.core.internal.ResourceManager.fireServerEvent(ResourceManager.java:560)
> at org.eclipse.wst.server.core.internal.ResourceManager.addServer(ResourceManager.java:712)
> at org.eclipse.wst.server.core.internal.Server.saveToMetadata(Server.java:474)
> at org.eclipse.wst.server.core.internal.Base.doSave(Base.java:266)
> at org.eclipse.wst.server.core.internal.Server.doSave(Server.java:463)
> at org.eclipse.wst.server.core.internal.ServerWorkingCopy.save(ServerWorkingCopy.java:432)
> at org.eclipse.wst.server.ui.internal.editor.ServerEditor.doSave(ServerEditor.java:389)
> at org.eclipse.ui.internal.DefaultSaveable.doSave(DefaultSaveable.java:54)
> at org.eclipse.ui.Saveable.doSave(Saveable.java:214)
> at org.eclipse.ui.internal.SaveableHelper.doSaveModel(SaveableHelper.java:348)
> at org.eclipse.ui.internal.WorkbenchPage$11.run(WorkbenchPage.java:3633)
> at org.eclipse.ui.internal.SaveableHelper$5.run(SaveableHelper.java:276)
> at org.eclipse.jface.operation.ModalContext.runInCurrentThread(ModalContext.java:464)
> at org.eclipse.jface.operation.ModalContext.run(ModalContext.java:372)
> at org.eclipse.ui.internal.WorkbenchWindow$13.run(WorkbenchWindow.java:1812)
> at org.eclipse.swt.custom.BusyIndicator.showWhile(BusyIndicator.java:70)
> at org.eclipse.ui.internal.WorkbenchWindow.run(WorkbenchWindow.java:1809)
> at org.eclipse.ui.internal.SaveableHelper.runProgressMonitorOperation(SaveableHelper.java:284)
> at org.eclipse.ui.internal.WorkbenchPage.saveAll(WorkbenchPage.java:3644)
> at org.eclipse.ui.internal.WorkbenchPage.saveAllEditors(WorkbenchPage.java:3440)
> at org.eclipse.ui.internal.handlers.SaveAllHandler.execute(SaveAllHandler.java:47)
> at org.eclipse.ui.internal.handlers.HandlerProxy.execute(HandlerProxy.java:290)
> at org.eclipse.ui.internal.handlers.E4HandlerProxy.execute(E4HandlerProxy.java:90)
> at sun.reflect.GeneratedMethodAccessor80.invoke(Unknown Source)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:597)
> at org.eclipse.e4.core.internal.di.MethodRequestor.execute(MethodRequestor.java:56)
> at org.eclipse.e4.core.internal.di.InjectorImpl.invokeUsingClass(InjectorImpl.java:243)
> at org.eclipse.e4.core.internal.di.InjectorImpl.invoke(InjectorImpl.java:224)
> at org.eclipse.e4.core.contexts.ContextInjectionFactory.invoke(ContextInjectionFactory.java:132)
> at org.eclipse.e4.core.commands.internal.HandlerServiceHandler.execute(HandlerServiceHandler.java:167)
> at org.eclipse.core.commands.Command.executeWithChecks(Command.java:499)
> at org.eclipse.core.commands.ParameterizedCommand.executeWithChecks(ParameterizedCommand.java:508)
> at org.eclipse.e4.core.commands.internal.HandlerServiceImpl.executeHandler(HandlerServiceImpl.java:213)
> at org.eclipse.ui.internal.handlers.LegacyHandlerService.executeCommand(LegacyHandlerService.java:420)
> at org.eclipse.ui.internal.actions.CommandAction.runWithEvent(CommandAction.java:157)
> at org.eclipse.jface.action.ActionContributionItem.handleWidgetSelection(ActionContributionItem.java:584)
> at org.eclipse.jface.action.ActionContributionItem.access$2(ActionContributionItem.java:501)
> at org.eclipse.jface.action.ActionContributionItem$6.handleEvent(ActionContributionItem.java:452)
> at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)
> at org.eclipse.swt.widgets.Display.sendEvent(Display.java:4166)
> at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1466)
> at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1489)
> at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1474)
> at org.eclipse.swt.widgets.Widget.notifyListeners(Widget.java:1279)
> at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:4012)
> at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3651)
> at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine$9.run(PartRenderingEngine.java:1113)
> at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332)
> at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine.run(PartRenderingEngine.java:997)
> at org.eclipse.e4.ui.internal.workbench.E4Workbench.createAndRunUI(E4Workbench.java:138)
> at org.eclipse.ui.internal.Workbench$5.run(Workbench.java:610)
> at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332)
> at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:567)
> at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:150)
> at org.eclipse.ui.internal.ide.application.IDEApplication.start(IDEApplication.java:124)
> at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196)
> at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:110)
> at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:79)
> at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:354)
> at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:181)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:597)
> at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:636)
> at org.eclipse.equinox.launcher.Main.basicRun(Main.java:591)
> at org.eclipse.equinox.launcher.Main.run(Main.java:1450)
> Caused by: org.jboss.ide.eclipse.as.management.core.JBoss7ManangerException: Could not execute "read-attribute" for [{"subsystem" => "teiid"}]. Failure was "JBAS014883: No resource definition is registered for address [(\"subsystem\" => \"teiid\")]".
> at org.jboss.ide.eclipse.as.internal.management.as71.AS71Manager.execute(AS71Manager.java:327)
> ... 76 more
--
This message was sent by Atlassian JIRA
(v6.3.1#6329)
11 years, 3 months
[JBoss JIRA] (TEIIDDES-2253) Adding a model to VDB results in exception
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2253?page=com.atlassian.jira.plu... ]
Barry LaFond resolved TEIIDDES-2253.
------------------------------------
Resolution: Incomplete Description
> Adding a model to VDB results in exception
> ------------------------------------------
>
> Key: TEIIDDES-2253
> URL: https://issues.jboss.org/browse/TEIIDDES-2253
> Project: Teiid Designer
> Issue Type: Bug
> Security Level: Public(Everyone can see)
> Components: Teiid Integration
> Affects Versions: 8.5
> Reporter: Tom Johnston
> Assignee: Paul Richardson
> Fix For: 8.6
>
>
> 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.vdb.ui.editor.VdbEditor$26.selected(VdbEditor.java:2096)
> at org.teiid.designer.ui.common.table.TableAndToolBar$2.run(TableAndToolBar.java:81)
> at org.eclipse.jface.action.Action.runWithEvent(Action.java:499)
> at org.eclipse.jface.action.ActionContributionItem.handleWidgetSelection(ActionContributionItem.java:584)
> at org.eclipse.jface.action.ActionContributionItem.access$2(ActionContributionItem.java:501)
> at org.eclipse.jface.action.ActionContributionItem$6.handleEvent(ActionContributionItem.java:452)
> at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)
> at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1057)
> at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:4170)
> at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3759)
> at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine$9.run(PartRenderingEngine.java:1113)
> at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332)
> at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine.run(PartRenderingEngine.java:997)
> at org.eclipse.e4.ui.internal.workbench.E4Workbench.createAndRunUI(E4Workbench.java:140)
> at org.eclipse.ui.internal.Workbench$5.run(Workbench.java:611)
> at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332)
> at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:567)
> at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:150)
> at org.eclipse.ui.internal.ide.application.IDEApplication.start(IDEApplication.java:124)
> at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196)
> at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:110)
> at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:79)
> at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:354)
> at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:181)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
> at java.lang.reflect.Method.invoke(Unknown Source)
> at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:636)
> at org.eclipse.equinox.launcher.Main.basicRun(Main.java:591)
> at org.eclipse.equinox.launcher.Main.run(Main.java:1450)
> at org.eclipse.equinox.launcher.Main.main(Main.java:1426)
> Contains: * null
--
This message was sent by Atlassian JIRA
(v6.3.1#6329)
11 years, 3 months
[JBoss JIRA] (TEIIDDES-2287) Error Generating REST Transformation with Teiid Reserved Word
by Ted Jones (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2287?page=com.atlassian.jira.plu... ]
Ted Jones updated TEIIDDES-2287:
--------------------------------
Fix Version/s: 8.7
8.6.1
(was: 8.6)
> Error Generating REST Transformation with Teiid Reserved Word
> -------------------------------------------------------------
>
> Key: TEIIDDES-2287
> URL: https://issues.jboss.org/browse/TEIIDDES-2287
> Project: Teiid Designer
> Issue Type: Bug
> Security Level: Public(Everyone can see)
> Components: Transformations
> Affects Versions: 8.6
> Reporter: Ted Jones
> Assignee: Ted Jones
> Fix For: 8.7, 8.6.1
>
>
> The following procedure transformation generated for a REST source is invalid due to using the OUTPUT Teiid reserved word as a column.
> BEGIN
> DECLARE STRING VARIABLES.qp = QUERYSTRING('http://www.google.com/complete/search', ViewModel.google."output" AS output, ViewModel.google.q AS q);
> SELECT A.data AS data FROM (EXEC SourceModel.invokeHttp('GET', null, VARIABLES.qp, 'TRUE')) AS f, XMLTABLE('/toplevel/CompleteSuggestion' PASSING XMLPARSE(DOCUMENT f.result) COLUMNS data string PATH '/suggestion/@data') AS A;
> END
> The word output should be in double quotes: BEGIN
> DECLARE STRING VARIABLES.qp = QUERYSTRING('http://www.google.com/complete/search', ViewModel.google."output" AS "output", ViewModel.google.q AS q);
> SELECT A.data AS data FROM (EXEC SourceModel.invokeHttp('GET', null, VARIABLES.qp, 'TRUE')) AS f, XMLTABLE('/toplevel/CompleteSuggestion' PASSING XMLPARSE(DOCUMENT f.result) COLUMNS data string PATH '/suggestion/@data') AS A;
> END
--
This message was sent by Atlassian JIRA
(v6.3.1#6329)
11 years, 3 months
[JBoss JIRA] (TEIIDDES-2284) Preview Error for REST Web Service Source
by Ted Jones (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2284?page=com.atlassian.jira.plu... ]
Ted Jones updated TEIIDDES-2284:
--------------------------------
Fix Version/s: 8.7
8.6.1
(was: 8.6)
> Preview Error for REST Web Service Source
> -----------------------------------------
>
> Key: TEIIDDES-2284
> URL: https://issues.jboss.org/browse/TEIIDDES-2284
> Project: Teiid Designer
> Issue Type: Bug
> Security Level: Public(Everyone can see)
> Components: Data Preview
> Affects Versions: 8.6
> Reporter: Ted Jones
> Assignee: Ted Jones
> Priority: Blocker
> Fix For: 8.7, 8.6.1
>
>
> When previewing a procedure that invokes a REST web service source, I get the following error:
> select * from ( exec "ViewModel"."google"('toolbar','reciever') ) AS X_X
> org.teiid.runtime.client.TeiidClientException: java.lang.RuntimeException: Remote org.teiid.core.TeiidProcessingException: TEIID30152 Failed to evaluate XQuery expression; Please check the query and correct errors in syntax or usage.
> However, if I add the view procedure to a VDB and deploy, I am able to execute without error.
--
This message was sent by Atlassian JIRA
(v6.3.1#6329)
11 years, 3 months
[JBoss JIRA] (TEIIDDES-2316) Excel import creates wrong datatype for ROW_ID column
by Ramesh Reddy (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2316?page=com.atlassian.jira.plu... ]
Ramesh Reddy commented on TEIIDDES-2316:
----------------------------------------
This is due to [https://issues.jboss.org/browse/TEIIDDES-2256]
It should be noted that if the Teiid Schema is defined the type as "integer" based on [https://docs.jboss.org/author/display/TEIID/DDL+Metadata] it should be parsed as design time "int". This issued came up few times. This needs to be a blocker issue IMO.
> Excel import creates wrong datatype for ROW_ID column
> -----------------------------------------------------
>
> Key: TEIIDDES-2316
> URL: https://issues.jboss.org/browse/TEIIDDES-2316
> Project: Teiid Designer
> Issue Type: Bug
> Security Level: Public(Everyone can see)
> Components: Import/Export, Modeling, Teiid Integration
> Affects Versions: 8.6
> Environment: Teiid Designer 8.6.0.Alpha1
> Teiid 8.7.1
> Reporter: Andrej Šmigala
>
> Following https://community.jboss.org/wiki/MicrosoftExcelDocumentIntoRelationalTable (Option 1 using Teiid Designer), the imported model has the ROW_ID column modeled with datatype "integer", which results in BigInteger runtime datatype. After adding this model to a vdb and deploying, the following queries work ok:
> {code:sql}
> SELECT * FROM Sheet1
> SELECT * FROM Sheet1 WHERE row_id > 2
> {code}
> but the following query fails:
> {code:sql}
> SELECT * FROM Sheet1 WHERE row_id = 2
> {code}
> The error is
> bq. org.teiid.runtime.client.TeiidClientException: java.lang.RuntimeException: Remote org.teiid.core.TeiidException: java.math.BigInteger cannot be cast to java.lang.Integer
> After changing the datatype to "int : xs:long" and redeploying, the above query works as expected.
> However, if I copy the generated dynamic vdb (attached) and deploy it on the server (without using Designer), running the query against that works.
> The DDL for import 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'),
> FirstName string OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '1'),
> LastName string OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '2'),
> Age double OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '3'),
> CONSTRAINT PK0 PRIMARY KEY(ROW_ID)
> ) OPTIONS ("teiid_excel:FILE" 'names.xlsx', "teiid_excel:FIRST_DATA_ROW_NUMBER" '2');
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.1#6329)
11 years, 3 months