[JBoss JIRA] (TEIIDDES-1891) generation of REST WAR crashes
by Paul Richardson (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-1891?page=com.atlassian.jira.plu... ]
Paul Richardson resolved TEIIDDES-1891.
---------------------------------------
Resolution: Done
> generation of REST WAR crashes
> ------------------------------
>
> Key: TEIIDDES-1891
> URL: https://issues.jboss.org/browse/TEIIDDES-1891
> Project: Teiid Designer
> Issue Type: Bug
> Affects Versions: 8.2
> Environment: JDK 1.6.0_45, windows XP SP3, Version: Kepler Service Release 1
> Build id: 20130919-0819
> Reporter: luca gioppo
> Assignee: Paul Richardson
> Fix For: 8.3
>
>
> When I try to create a Rest WAR I get the error and in the log of eclipse I get:
> when I open the rest war dialog I get:
> !ENTRY org.eclipse.egit.ui 2 0 2013-10-21 10:29:07.968
> !MESSAGE Warning: The environment variable HOME is not set. The following directory will be used to store the Git
> user global configuration and to define the default location to store repositories: 'C:\Documents and Settings\764'. If this is
> not correct please set the HOME environment variable and restart Eclipse. Otherwise Git for Windows and
> EGit might behave differently since they see different configuration options.
> This warning can be switched off on the Team > Git > Confirmations and Warnings preference page.
> !ENTRY org.teiid.designer.dqp.ui 4 0 2013-10-21 10:29:27.421
> !MESSAGE Argument cannot be null
> !STACK 0
> java.lang.IllegalArgumentException: Argument cannot be null
> at org.eclipse.swt.SWT.error(SWT.java:4378)
> at org.eclipse.swt.SWT.error(SWT.java:4312)
> at org.eclipse.swt.SWT.error(SWT.java:4283)
> at org.eclipse.swt.widgets.Widget.error(Widget.java:472)
> at org.eclipse.swt.widgets.Text.setText(Text.java:2241)
> at org.teiid.designer.runtime.ui.wizards.webservices.RestWarDeploymentInfoPanel.loadData(RestWarDeploymentInfoPanel.java:143)
> at org.teiid.designer.runtime.ui.wizards.webservices.RestWarDeploymentInfoDialog.loadDefault(RestWarDeploymentInfoDialog.java:250)
> at org.teiid.designer.runtime.ui.wizards.webservices.RestWarDeploymentInfoDialog.createButtonsForButtonBar(RestWarDeploymentInfoDialog.java:148)
> at org.eclipse.jface.dialogs.Dialog.createButtonBar(Dialog.java:676)
> at org.eclipse.jface.dialogs.TrayDialog.createButtonBar(TrayDialog.java:243)
> at org.eclipse.jface.dialogs.TitleAreaDialog.createContents(TitleAreaDialog.java:159)
> at org.eclipse.jface.window.Window.create(Window.java:432)
> at org.eclipse.jface.dialogs.Dialog.create(Dialog.java:1104)
> at org.eclipse.jface.window.Window.open(Window.java:791)
> at org.teiid.designer.runtime.ui.wizards.webservices.RestWarDeploymentInfoDialog.open(RestWarDeploymentInfoDialog.java:186)
> at org.teiid.designer.runtime.ui.actions.GenerateRestWarAction.run(GenerateRestWarAction.java:147)
> 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$5.handleEvent(ActionContributionItem.java:411)
> 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: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)
> at org.eclipse.equinox.launcher.Main.main(Main.java:1426)
> When I execute the generation:
> !ENTRY org.teiid.designer.dqp.ui 4 0 2013-10-21 10:35:37.718
> !MESSAGE
> !STACK 0
> java.lang.NullPointerException
> at java.util.Hashtable.put(Hashtable.java:394)
> at org.teiid.designer.runtime.ui.wizards.webservices.RestWarDataserviceModel.getProperties(RestWarDataserviceModel.java:371)
> at org.teiid.designer.runtime.ui.wizards.webservices.RestWarDeploymentInfoDialog.execute(RestWarDeploymentInfoDialog.java:202)
> at org.teiid.designer.runtime.ui.wizards.webservices.RestWarDeploymentInfoDialog$1.run(RestWarDeploymentInfoDialog.java:165)
> at org.eclipse.jface.operation.ModalContext.runInCurrentThread(ModalContext.java:464)
> at org.eclipse.jface.operation.ModalContext.run(ModalContext.java:372)
> at org.eclipse.jface.dialogs.ProgressMonitorDialog.run(ProgressMonitorDialog.java:507)
> at org.teiid.designer.runtime.ui.wizards.webservices.RestWarDeploymentInfoDialog.okPressed(RestWarDeploymentInfoDialog.java:174)
> at org.eclipse.jface.dialogs.Dialog.buttonPressed(Dialog.java:476)
> at org.eclipse.jface.dialogs.Dialog$2.widgetSelected(Dialog.java:628)
> at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:248)
> 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.jface.window.Window.runEventLoop(Window.java:826)
> at org.eclipse.jface.window.Window.open(Window.java:802)
> at org.teiid.designer.runtime.ui.wizards.webservices.RestWarDeploymentInfoDialog.open(RestWarDeploymentInfoDialog.java:186)
> at org.teiid.designer.runtime.ui.actions.GenerateRestWarAction.run(GenerateRestWarAction.java:147)
> 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$5.handleEvent(ActionContributionItem.java:411)
> 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: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)
> at org.eclipse.equinox.launcher.Main.main(Main.java:1426)
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
10 years, 6 months
[JBoss JIRA] (TEIIDDES-1906) Execute VDB fails for Salesforce model
by Ramesh Reddy (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-1906?page=com.atlassian.jira.plu... ]
Ramesh Reddy commented on TEIIDDES-1906:
----------------------------------------
Now that is more obvious, check your user id, password
> Execute VDB fails for Salesforce model
> --------------------------------------
>
> Key: TEIIDDES-1906
> URL: https://issues.jboss.org/browse/TEIIDDES-1906
> Project: Teiid Designer
> Issue Type: Bug
> Affects Versions: 8.2
> Environment: Teiid Designer 8.2.0Final, JBDS 7, java 1.7 oracle, server DV 6.0.ER2 with teiid 8.4
> Reporter: Lucie Fabrikova
>
> 1. create a source model by importing from testing Salesforce account; preview data of one table (Modeling -> Preview data) - this works (select * from "sf"."salesforce"."Account")
> 2. create a VDB with the source model; deploy, execute (use the same sql query) - this results in a error:
> org.teiid.resource.adapter.file.FileConnectionImpl cannot be cast to org.teiid.translator.salesforce.SalesforceConnection
> Console output:
> 13:46:09,114 ERROR [org.teiid.CONNECTOR] (Worker5_QueryProcessorQueue18) Connector worker process failed for atomic-request=oZbg6bQY7MUO.0.0.5: java.lang.ClassCastException: org.teiid.resource.adapter.file.FileConnectionImpl cannot be cast to org.teiid.translator.salesforce.SalesforceConnection
> at org.teiid.translator.salesforce.SalesForceExecutionFactory.createResultSetExecution(SalesForceExecutionFactory.java:60)
> at org.teiid.translator.ExecutionFactory.createExecution(ExecutionFactory.java:304) [teiid-api-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:245) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:444) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:157) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:154) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334) [rt.jar:1.7.0_25]
> at java.util.concurrent.FutureTask.run(FutureTask.java:166) [rt.jar:1.7.0_25]
> at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:58) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:269) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:214) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_25]
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_25]
> at java.lang.Thread.run(Thread.java:724) [rt.jar:1.7.0_25]
> 13:46:09,116 ERROR [org.teiid.PROCESSOR] (Worker4_QueryProcessorQueue19) TEIID30019 Unexpected exception for request oZbg6bQY7MUO.0: java.lang.ClassCastException: org.teiid.resource.adapter.file.FileConnectionImpl cannot be cast to org.teiid.translator.salesforce.SalesforceConnection
> at org.teiid.translator.salesforce.SalesForceExecutionFactory.createResultSetExecution(SalesForceExecutionFactory.java:60)
> at org.teiid.translator.ExecutionFactory.createExecution(ExecutionFactory.java:304) [teiid-api-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:245) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:444) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:157) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:154) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334) [rt.jar:1.7.0_25]
> at java.util.concurrent.FutureTask.run(FutureTask.java:166) [rt.jar:1.7.0_25]
> at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:58) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:269) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:214) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_25]
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_25]
> at java.lang.Thread.run(Thread.java:724) [rt.jar:1.7.0_25]
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
10 years, 6 months
[JBoss JIRA] (TEIIDDES-1906) Execute VDB fails for Salesforce model
by Lucie Fabrikova (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-1906?page=com.atlassian.jira.plu... ]
Lucie Fabrikova commented on TEIIDDES-1906:
-------------------------------------------
I restarted the server, recreated data source and set its password (to string "password+Token"), and get different errors: TEIID30504 Remote org.teiid.core.TeiidProcessingException: TEIID30504 sf: TEIID60000 javax.resource.ResourceException: IJ000453: Unable to get managed connection for java:/sf
Console:
15:17:51,513 WARN [org.jboss.jca.core.connectionmanager.pool.strategy.OnePool] (Worker1_QueryProcessorQueue1) IJ000604: Throwable while attempting to get a new connection: null: javax.resource.ResourceException: com.sforce.soap.partner.LoginFault: INVALID_LOGIN: Invalid username, password, security token; or user locked out.
at org.teiid.resource.adapter.salesforce.SalesforceConnectionImpl.login(SalesforceConnectionImpl.java:125)
...
> Execute VDB fails for Salesforce model
> --------------------------------------
>
> Key: TEIIDDES-1906
> URL: https://issues.jboss.org/browse/TEIIDDES-1906
> Project: Teiid Designer
> Issue Type: Bug
> Affects Versions: 8.2
> Environment: Teiid Designer 8.2.0Final, JBDS 7, java 1.7 oracle, server DV 6.0.ER2 with teiid 8.4
> Reporter: Lucie Fabrikova
>
> 1. create a source model by importing from testing Salesforce account; preview data of one table (Modeling -> Preview data) - this works (select * from "sf"."salesforce"."Account")
> 2. create a VDB with the source model; deploy, execute (use the same sql query) - this results in a error:
> org.teiid.resource.adapter.file.FileConnectionImpl cannot be cast to org.teiid.translator.salesforce.SalesforceConnection
> Console output:
> 13:46:09,114 ERROR [org.teiid.CONNECTOR] (Worker5_QueryProcessorQueue18) Connector worker process failed for atomic-request=oZbg6bQY7MUO.0.0.5: java.lang.ClassCastException: org.teiid.resource.adapter.file.FileConnectionImpl cannot be cast to org.teiid.translator.salesforce.SalesforceConnection
> at org.teiid.translator.salesforce.SalesForceExecutionFactory.createResultSetExecution(SalesForceExecutionFactory.java:60)
> at org.teiid.translator.ExecutionFactory.createExecution(ExecutionFactory.java:304) [teiid-api-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:245) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:444) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:157) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:154) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334) [rt.jar:1.7.0_25]
> at java.util.concurrent.FutureTask.run(FutureTask.java:166) [rt.jar:1.7.0_25]
> at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:58) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:269) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:214) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_25]
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_25]
> at java.lang.Thread.run(Thread.java:724) [rt.jar:1.7.0_25]
> 13:46:09,116 ERROR [org.teiid.PROCESSOR] (Worker4_QueryProcessorQueue19) TEIID30019 Unexpected exception for request oZbg6bQY7MUO.0: java.lang.ClassCastException: org.teiid.resource.adapter.file.FileConnectionImpl cannot be cast to org.teiid.translator.salesforce.SalesforceConnection
> at org.teiid.translator.salesforce.SalesForceExecutionFactory.createResultSetExecution(SalesForceExecutionFactory.java:60)
> at org.teiid.translator.ExecutionFactory.createExecution(ExecutionFactory.java:304) [teiid-api-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:245) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:444) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:157) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:154) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334) [rt.jar:1.7.0_25]
> at java.util.concurrent.FutureTask.run(FutureTask.java:166) [rt.jar:1.7.0_25]
> at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:58) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:269) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:214) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_25]
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_25]
> at java.lang.Thread.run(Thread.java:724) [rt.jar:1.7.0_25]
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
10 years, 6 months
[JBoss JIRA] (TEIIDDES-1906) Execute VDB fails for Salesforce model
by Ramesh Reddy (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-1906?page=com.atlassian.jira.plu... ]
Ramesh Reddy commented on TEIIDDES-1906:
----------------------------------------
Then you need to figure out why a connection with JNDI name "SF" is pointing to a file source instead SF
> Execute VDB fails for Salesforce model
> --------------------------------------
>
> Key: TEIIDDES-1906
> URL: https://issues.jboss.org/browse/TEIIDDES-1906
> Project: Teiid Designer
> Issue Type: Bug
> Affects Versions: 8.2
> Environment: Teiid Designer 8.2.0Final, JBDS 7, java 1.7 oracle, server DV 6.0.ER2 with teiid 8.4
> Reporter: Lucie Fabrikova
>
> 1. create a source model by importing from testing Salesforce account; preview data of one table (Modeling -> Preview data) - this works (select * from "sf"."salesforce"."Account")
> 2. create a VDB with the source model; deploy, execute (use the same sql query) - this results in a error:
> org.teiid.resource.adapter.file.FileConnectionImpl cannot be cast to org.teiid.translator.salesforce.SalesforceConnection
> Console output:
> 13:46:09,114 ERROR [org.teiid.CONNECTOR] (Worker5_QueryProcessorQueue18) Connector worker process failed for atomic-request=oZbg6bQY7MUO.0.0.5: java.lang.ClassCastException: org.teiid.resource.adapter.file.FileConnectionImpl cannot be cast to org.teiid.translator.salesforce.SalesforceConnection
> at org.teiid.translator.salesforce.SalesForceExecutionFactory.createResultSetExecution(SalesForceExecutionFactory.java:60)
> at org.teiid.translator.ExecutionFactory.createExecution(ExecutionFactory.java:304) [teiid-api-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:245) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:444) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:157) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:154) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334) [rt.jar:1.7.0_25]
> at java.util.concurrent.FutureTask.run(FutureTask.java:166) [rt.jar:1.7.0_25]
> at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:58) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:269) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:214) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_25]
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_25]
> at java.lang.Thread.run(Thread.java:724) [rt.jar:1.7.0_25]
> 13:46:09,116 ERROR [org.teiid.PROCESSOR] (Worker4_QueryProcessorQueue19) TEIID30019 Unexpected exception for request oZbg6bQY7MUO.0: java.lang.ClassCastException: org.teiid.resource.adapter.file.FileConnectionImpl cannot be cast to org.teiid.translator.salesforce.SalesforceConnection
> at org.teiid.translator.salesforce.SalesForceExecutionFactory.createResultSetExecution(SalesForceExecutionFactory.java:60)
> at org.teiid.translator.ExecutionFactory.createExecution(ExecutionFactory.java:304) [teiid-api-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:245) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:444) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:157) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:154) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334) [rt.jar:1.7.0_25]
> at java.util.concurrent.FutureTask.run(FutureTask.java:166) [rt.jar:1.7.0_25]
> at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:58) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:269) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:214) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_25]
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_25]
> at java.lang.Thread.run(Thread.java:724) [rt.jar:1.7.0_25]
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
10 years, 6 months
[JBoss JIRA] (TEIIDDES-1906) Execute VDB fails for Salesforce model
by Lucie Fabrikova (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-1906?page=com.atlassian.jira.plu... ]
Lucie Fabrikova commented on TEIIDDES-1906:
-------------------------------------------
They are set this way for sf.xmi: source name "sf", translator name "salesforce", JNDI name "sf". The vdb name is "sf.vdb".
> Execute VDB fails for Salesforce model
> --------------------------------------
>
> Key: TEIIDDES-1906
> URL: https://issues.jboss.org/browse/TEIIDDES-1906
> Project: Teiid Designer
> Issue Type: Bug
> Affects Versions: 8.2
> Environment: Teiid Designer 8.2.0Final, JBDS 7, java 1.7 oracle, server DV 6.0.ER2 with teiid 8.4
> Reporter: Lucie Fabrikova
>
> 1. create a source model by importing from testing Salesforce account; preview data of one table (Modeling -> Preview data) - this works (select * from "sf"."salesforce"."Account")
> 2. create a VDB with the source model; deploy, execute (use the same sql query) - this results in a error:
> org.teiid.resource.adapter.file.FileConnectionImpl cannot be cast to org.teiid.translator.salesforce.SalesforceConnection
> Console output:
> 13:46:09,114 ERROR [org.teiid.CONNECTOR] (Worker5_QueryProcessorQueue18) Connector worker process failed for atomic-request=oZbg6bQY7MUO.0.0.5: java.lang.ClassCastException: org.teiid.resource.adapter.file.FileConnectionImpl cannot be cast to org.teiid.translator.salesforce.SalesforceConnection
> at org.teiid.translator.salesforce.SalesForceExecutionFactory.createResultSetExecution(SalesForceExecutionFactory.java:60)
> at org.teiid.translator.ExecutionFactory.createExecution(ExecutionFactory.java:304) [teiid-api-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:245) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:444) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:157) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:154) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334) [rt.jar:1.7.0_25]
> at java.util.concurrent.FutureTask.run(FutureTask.java:166) [rt.jar:1.7.0_25]
> at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:58) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:269) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:214) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_25]
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_25]
> at java.lang.Thread.run(Thread.java:724) [rt.jar:1.7.0_25]
> 13:46:09,116 ERROR [org.teiid.PROCESSOR] (Worker4_QueryProcessorQueue19) TEIID30019 Unexpected exception for request oZbg6bQY7MUO.0: java.lang.ClassCastException: org.teiid.resource.adapter.file.FileConnectionImpl cannot be cast to org.teiid.translator.salesforce.SalesforceConnection
> at org.teiid.translator.salesforce.SalesForceExecutionFactory.createResultSetExecution(SalesForceExecutionFactory.java:60)
> at org.teiid.translator.ExecutionFactory.createExecution(ExecutionFactory.java:304) [teiid-api-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:245) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:444) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:157) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:154) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334) [rt.jar:1.7.0_25]
> at java.util.concurrent.FutureTask.run(FutureTask.java:166) [rt.jar:1.7.0_25]
> at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:58) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:269) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:214) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_25]
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_25]
> at java.lang.Thread.run(Thread.java:724) [rt.jar:1.7.0_25]
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
10 years, 6 months
[JBoss JIRA] (TEIIDDES-1906) Execute VDB fails for Salesforce model
by Ramesh Reddy (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-1906?page=com.atlassian.jira.plu... ]
Ramesh Reddy commented on TEIIDDES-1906:
----------------------------------------
you said you created a VDB, when you add the source model in the VDB explorer, then in the "Source Bindings" tab, you can set the translator name and jndi name of the connection. You need to make sure they both are set correctly.
> Execute VDB fails for Salesforce model
> --------------------------------------
>
> Key: TEIIDDES-1906
> URL: https://issues.jboss.org/browse/TEIIDDES-1906
> Project: Teiid Designer
> Issue Type: Bug
> Affects Versions: 8.2
> Environment: Teiid Designer 8.2.0Final, JBDS 7, java 1.7 oracle, server DV 6.0.ER2 with teiid 8.4
> Reporter: Lucie Fabrikova
>
> 1. create a source model by importing from testing Salesforce account; preview data of one table (Modeling -> Preview data) - this works (select * from "sf"."salesforce"."Account")
> 2. create a VDB with the source model; deploy, execute (use the same sql query) - this results in a error:
> org.teiid.resource.adapter.file.FileConnectionImpl cannot be cast to org.teiid.translator.salesforce.SalesforceConnection
> Console output:
> 13:46:09,114 ERROR [org.teiid.CONNECTOR] (Worker5_QueryProcessorQueue18) Connector worker process failed for atomic-request=oZbg6bQY7MUO.0.0.5: java.lang.ClassCastException: org.teiid.resource.adapter.file.FileConnectionImpl cannot be cast to org.teiid.translator.salesforce.SalesforceConnection
> at org.teiid.translator.salesforce.SalesForceExecutionFactory.createResultSetExecution(SalesForceExecutionFactory.java:60)
> at org.teiid.translator.ExecutionFactory.createExecution(ExecutionFactory.java:304) [teiid-api-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:245) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:444) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:157) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:154) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334) [rt.jar:1.7.0_25]
> at java.util.concurrent.FutureTask.run(FutureTask.java:166) [rt.jar:1.7.0_25]
> at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:58) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:269) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:214) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_25]
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_25]
> at java.lang.Thread.run(Thread.java:724) [rt.jar:1.7.0_25]
> 13:46:09,116 ERROR [org.teiid.PROCESSOR] (Worker4_QueryProcessorQueue19) TEIID30019 Unexpected exception for request oZbg6bQY7MUO.0: java.lang.ClassCastException: org.teiid.resource.adapter.file.FileConnectionImpl cannot be cast to org.teiid.translator.salesforce.SalesforceConnection
> at org.teiid.translator.salesforce.SalesForceExecutionFactory.createResultSetExecution(SalesForceExecutionFactory.java:60)
> at org.teiid.translator.ExecutionFactory.createExecution(ExecutionFactory.java:304) [teiid-api-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:245) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:444) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:157) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:154) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334) [rt.jar:1.7.0_25]
> at java.util.concurrent.FutureTask.run(FutureTask.java:166) [rt.jar:1.7.0_25]
> at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:58) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:269) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:214) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_25]
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_25]
> at java.lang.Thread.run(Thread.java:724) [rt.jar:1.7.0_25]
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
10 years, 6 months
[JBoss JIRA] (TEIIDDES-1906) Execute VDB fails for Salesforce model
by Lucie Fabrikova (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-1906?page=com.atlassian.jira.plu... ]
Lucie Fabrikova edited comment on TEIIDDES-1906 at 10/30/13 9:46 AM:
---------------------------------------------------------------------
I am not sure how to set the JNDI name of salesforce source model so that it points to the connection - how exactly should it be named..? I have no connection to Salesforce, I imported the schema (via Import -> Salesforce >> source model).
was (Author: lfabriko):
I am not sure how to set the JNDI name of salesforce source model so that it points to the connection - how exactly should it be named..?
> Execute VDB fails for Salesforce model
> --------------------------------------
>
> Key: TEIIDDES-1906
> URL: https://issues.jboss.org/browse/TEIIDDES-1906
> Project: Teiid Designer
> Issue Type: Bug
> Affects Versions: 8.2
> Environment: Teiid Designer 8.2.0Final, JBDS 7, java 1.7 oracle, server DV 6.0.ER2 with teiid 8.4
> Reporter: Lucie Fabrikova
>
> 1. create a source model by importing from testing Salesforce account; preview data of one table (Modeling -> Preview data) - this works (select * from "sf"."salesforce"."Account")
> 2. create a VDB with the source model; deploy, execute (use the same sql query) - this results in a error:
> org.teiid.resource.adapter.file.FileConnectionImpl cannot be cast to org.teiid.translator.salesforce.SalesforceConnection
> Console output:
> 13:46:09,114 ERROR [org.teiid.CONNECTOR] (Worker5_QueryProcessorQueue18) Connector worker process failed for atomic-request=oZbg6bQY7MUO.0.0.5: java.lang.ClassCastException: org.teiid.resource.adapter.file.FileConnectionImpl cannot be cast to org.teiid.translator.salesforce.SalesforceConnection
> at org.teiid.translator.salesforce.SalesForceExecutionFactory.createResultSetExecution(SalesForceExecutionFactory.java:60)
> at org.teiid.translator.ExecutionFactory.createExecution(ExecutionFactory.java:304) [teiid-api-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:245) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:444) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:157) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:154) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334) [rt.jar:1.7.0_25]
> at java.util.concurrent.FutureTask.run(FutureTask.java:166) [rt.jar:1.7.0_25]
> at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:58) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:269) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:214) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_25]
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_25]
> at java.lang.Thread.run(Thread.java:724) [rt.jar:1.7.0_25]
> 13:46:09,116 ERROR [org.teiid.PROCESSOR] (Worker4_QueryProcessorQueue19) TEIID30019 Unexpected exception for request oZbg6bQY7MUO.0: java.lang.ClassCastException: org.teiid.resource.adapter.file.FileConnectionImpl cannot be cast to org.teiid.translator.salesforce.SalesforceConnection
> at org.teiid.translator.salesforce.SalesForceExecutionFactory.createResultSetExecution(SalesForceExecutionFactory.java:60)
> at org.teiid.translator.ExecutionFactory.createExecution(ExecutionFactory.java:304) [teiid-api-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:245) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:444) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:157) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:154) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334) [rt.jar:1.7.0_25]
> at java.util.concurrent.FutureTask.run(FutureTask.java:166) [rt.jar:1.7.0_25]
> at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:58) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:269) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:214) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_25]
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_25]
> at java.lang.Thread.run(Thread.java:724) [rt.jar:1.7.0_25]
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
10 years, 6 months
[JBoss JIRA] (TEIIDDES-1906) Execute VDB fails for Salesforce model
by Lucie Fabrikova (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-1906?page=com.atlassian.jira.plu... ]
Lucie Fabrikova commented on TEIIDDES-1906:
-------------------------------------------
I am not sure how to set the JNDI name of salesforce source model so that it points to the connection - how exactly should it be named..?
> Execute VDB fails for Salesforce model
> --------------------------------------
>
> Key: TEIIDDES-1906
> URL: https://issues.jboss.org/browse/TEIIDDES-1906
> Project: Teiid Designer
> Issue Type: Bug
> Affects Versions: 8.2
> Environment: Teiid Designer 8.2.0Final, JBDS 7, java 1.7 oracle, server DV 6.0.ER2 with teiid 8.4
> Reporter: Lucie Fabrikova
>
> 1. create a source model by importing from testing Salesforce account; preview data of one table (Modeling -> Preview data) - this works (select * from "sf"."salesforce"."Account")
> 2. create a VDB with the source model; deploy, execute (use the same sql query) - this results in a error:
> org.teiid.resource.adapter.file.FileConnectionImpl cannot be cast to org.teiid.translator.salesforce.SalesforceConnection
> Console output:
> 13:46:09,114 ERROR [org.teiid.CONNECTOR] (Worker5_QueryProcessorQueue18) Connector worker process failed for atomic-request=oZbg6bQY7MUO.0.0.5: java.lang.ClassCastException: org.teiid.resource.adapter.file.FileConnectionImpl cannot be cast to org.teiid.translator.salesforce.SalesforceConnection
> at org.teiid.translator.salesforce.SalesForceExecutionFactory.createResultSetExecution(SalesForceExecutionFactory.java:60)
> at org.teiid.translator.ExecutionFactory.createExecution(ExecutionFactory.java:304) [teiid-api-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:245) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:444) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:157) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:154) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334) [rt.jar:1.7.0_25]
> at java.util.concurrent.FutureTask.run(FutureTask.java:166) [rt.jar:1.7.0_25]
> at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:58) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:269) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:214) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_25]
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_25]
> at java.lang.Thread.run(Thread.java:724) [rt.jar:1.7.0_25]
> 13:46:09,116 ERROR [org.teiid.PROCESSOR] (Worker4_QueryProcessorQueue19) TEIID30019 Unexpected exception for request oZbg6bQY7MUO.0: java.lang.ClassCastException: org.teiid.resource.adapter.file.FileConnectionImpl cannot be cast to org.teiid.translator.salesforce.SalesforceConnection
> at org.teiid.translator.salesforce.SalesForceExecutionFactory.createResultSetExecution(SalesForceExecutionFactory.java:60)
> at org.teiid.translator.ExecutionFactory.createExecution(ExecutionFactory.java:304) [teiid-api-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:245) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:444) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:157) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:154) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334) [rt.jar:1.7.0_25]
> at java.util.concurrent.FutureTask.run(FutureTask.java:166) [rt.jar:1.7.0_25]
> at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:58) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:269) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:214) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_25]
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_25]
> at java.lang.Thread.run(Thread.java:724) [rt.jar:1.7.0_25]
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
10 years, 6 months