[JBoss JIRA] Created: (TEIIDDES-609) Teiid QueryValidatorException opening VDB schema in Data Source Explorer for model with "hidden" table.
by Barry LaFond (JIRA)
Teiid QueryValidatorException opening VDB schema in Data Source Explorer for model with "hidden" table.
-------------------------------------------------------------------------------------------------------
Key: TEIIDDES-609
URL: https://jira.jboss.org/browse/TEIIDDES-609
Project: Teiid Designer
Issue Type: Bug
Components: VDB & Execution
Affects Versions: 7.1
Reporter: Barry LaFond
Assignee: John Doyle
Priority: Blocker
Fix For: 7.1.1
After creating a data role for PartsSupplier VDB where the CRUD for one table was turned OFF (i.e. create/read/update/delete = FALSE) and deploying to Teiid, I deployed and executed the VDB.
But on trying to view the contents in DTP, an exception occured.
org.teiid.jdbc.TeiidSQLException: Error trying to obtain schema metadata info on this connection: Remote org.teiid.api.exception.query.QueryValidatorException: User <Hcs7WsIzrd4G> is not entitled to action <Read> for 1 or more of the groups/elements/procedures..
at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:102)
at org.teiid.jdbc.DatabaseMetaDataImpl.getSchemas(DatabaseMetaDataImpl.java:2361)
at org.teiid.jdbc.DatabaseMetaDataImpl.getSchemas(DatabaseMetaDataImpl.java:1298)
at org.eclipse.datatools.connectivity.sqm.loader.JDBCSchemaLoader.createResultSet(JDBCSchemaLoader.java:174)
at org.eclipse.datatools.connectivity.sqm.loader.JDBCSchemaLoader.loadSchemas(JDBCSchemaLoader.java:110)
at org.eclipse.datatools.connectivity.sqm.core.rte.jdbc.JDBCCatalog.loadSchemas(JDBCCatalog.java:101)
at org.eclipse.datatools.connectivity.sqm.core.rte.jdbc.JDBCCatalog.getSchemas(JDBCCatalog.java:64)
at org.eclipse.datatools.connectivity.sqm.server.internal.ui.explorer.providers.content.layout.vnode.ServerExplorerVNodeContentProviderNav.displaySchemaNodeChildren(ServerExplorerVNodeContentProviderNav.java:126)
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
15 years, 2 months
[JBoss JIRA] Created: (TEIIDDES-644) Books example has incorrect transformation SQL in XML document model
by Paul Nittel (JIRA)
Books example has incorrect transformation SQL in XML document model
--------------------------------------------------------------------
Key: TEIIDDES-644
URL: https://jira.jboss.org/browse/TEIIDDES-644
Project: Teiid Designer
Issue Type: Bug
Affects Versions: 7.1.1
Environment: JBDS 4.0.0 M2, Designer bulid H280
Reporter: Paul Nittel
Fix For: 7.1.1
I imported the Books Project into my workspace and found the XML document model had errors, Checking, I found the transformation SQL referenced the wrong models. For example,
SELECT
Books_Oracle.AUTHORS.LASTNAME AS author
FROM
Books_SQLServer.BOOK_AUTHORS, Books_Oracle.AUTHORS
WHERE
("input".isbn = Books_SQLServer.BOOK_AUTHORS.ISBN) AND (Books_SQLServer.BOOK_AUTHORS.AUTHOR_ID = Books_Oracle.AUTHORS.AUTHOR_ID)
should reference Books_SourceA and Books_SourceB rather than Books_SQLServer and Books_Oracle.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
15 years, 2 months
[JBoss JIRA] Created: (TEIIDDES-643) Create data source from Teiid view gets [AdminComponentException]The specified session ID "null" is invalid.
by Paul Nittel (JIRA)
Create data source from Teiid view gets [AdminComponentException]The specified session ID "null" is invalid.
------------------------------------------------------------------------------------------------------------
Key: TEIIDDES-643
URL: https://jira.jboss.org/browse/TEIIDDES-643
Project: Teiid Designer
Issue Type: Bug
Components: Teiid Integration
Affects Versions: 7.1.1
Environment: JBDS 4.0.0 M2, Designer build H280, Teiid in SOA-P 5.1 ER2
Reporter: Paul Nittel
Fix For: 7.1.1
I tried to create a data source from the Teiid view and got this instead:
Error 2010-09-30 15:03:38.187 Error creating data source for model {0}
[AdminComponentException]The specified session ID "null" is invalid. It cannot be found in the userbase.
1 [AdminProcessingException]The specified session ID "null" is invalid. It cannot be found in the userbase.
2 [InvalidSessionException]The specified session ID "null" is invalid. It cannot be found in the userbase.
at org.teiid.client.util.ExceptionUtil.convertException(ExceptionUtil.java:72)
at org.teiid.net.socket.SocketServerInstanceImpl$RemoteInvocationHandler.invoke(SocketServerInstanceImpl.java:365)
at org.teiid.net.socket.SocketServerConnection$1.invoke(SocketServerConnection.java:216)
at $Proxy2.createDataSource(Unknown Source)
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.teiid.adminapi.AdminFactory$AdminProxy.invoke(AdminFactory.java:80)
at $Proxy2.createDataSource(Unknown Source)
at org.teiid.designer.runtime.ExecutionAdmin.getOrCreateDataSource(ExecutionAdmin.java:197)
at org.teiid.designer.runtime.ui.connection.CreateDataSourceAction.run(CreateDataSourceAction.java:142)
at com.metamatrix.modeler.internal.dqp.ui.workspace.TeiidView$15.run(TeiidView.java:759)
at org.eclipse.jface.action.Action.runWithEvent(Action.java:498)
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:1258)
at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3552)
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3171)
at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:2629)
at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:2593)
at org.eclipse.ui.internal.Workbench.access$4(Workbench.java:2427)
at org.eclipse.ui.internal.Workbench$7.run(Workbench.java:670)
at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332)
at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:663)
at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:149)
at org.eclipse.ui.internal.ide.application.IDEApplication.start(IDEApplication.java:115)
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:369)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:179)
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:619)
at org.eclipse.equinox.launcher.Main.basicRun(Main.java:574)
at org.eclipse.equinox.launcher.Main.run(Main.java:1407)
Caused by: [AdminProcessingException]The specified session ID "null" is invalid. It cannot be found in the userbase.
1 [InvalidSessionException]The specified session ID "null" is invalid. It cannot be found in the userbase.
at org.teiid.client.util.ExceptionUtil.convertException(ExceptionUtil.java:70)
at org.teiid.jboss.deployers.RuntimeEngineDeployer$2.invoke(RuntimeEngineDeployer.java:287)
at $Proxy358.createDataSource(Unknown Source)
at sun.reflect.GeneratedMethodAccessor945.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.teiid.transport.ServerWorkItem.run(ServerWorkItem.java:81)
at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:189)
at org.teiid.transport.SocketClientInstance.processMessagePacket(SocketClientInstance.java:160)
at org.teiid.transport.SocketClientInstance.receivedMessage(SocketClientInstance.java:149)
at org.teiid.transport.SSLAwareChannelHandler.messageReceived(SSLAwareChannelHandler.java:210)
at org.jboss.netty.channel.SimpleChannelHandler.handleUpstream(SimpleChannelHandler.java:100)
at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:545)
at org.jboss.netty.channel.DefaultChannelPipeline$DefaultChannelHandlerContext.sendUpstream(DefaultChannelPipeline.java:754)
at org.jboss.netty.handler.stream.ChunkedWriteHandler.handleUpstream(ChunkedWriteHandler.java:144)
at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:545)
at org.jboss.netty.channel.DefaultChannelPipeline$DefaultChannelHandlerContext.sendUpstream(DefaultChannelPipeline.java:754)
at org.jboss.netty.channel.Channels.fireMessageReceived(Channels.java:302)
at org.jboss.netty.handler.codec.frame.FrameDecoder.unfoldAndFireMessageReceived(FrameDecoder.java:317)
at org.jboss.netty.handler.codec.frame.FrameDecoder.callDecode(FrameDecoder.java:299)
at org.jboss.netty.handler.codec.frame.FrameDecoder.messageReceived(FrameDecoder.java:216)
at org.jboss.netty.channel.SimpleChannelUpstreamHandler.handleUpstream(SimpleChannelUpstreamHandler.java:80)
at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:545)
at org.jboss.netty.channel.DefaultChannelPipeline$DefaultChannelHandlerContext.sendUpstream(DefaultChannelPipeline.java:754)
at org.jboss.netty.channel.Channels.fireMessageReceived(Channels.java:302)
at org.jboss.netty.handler.codec.frame.FrameDecoder.unfoldAndFireMessageReceived(FrameDecoder.java:317)
at org.jboss.netty.handler.codec.frame.FrameDecoder.callDecode(FrameDecoder.java:299)
at org.jboss.netty.handler.codec.frame.FrameDecoder.messageReceived(FrameDecoder.java:216)
at org.jboss.netty.channel.SimpleChannelUpstreamHandler.handleUpstream(SimpleChannelUpstreamHandler.java:80)
at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:545)
at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:540)
at org.jboss.netty.channel.Channels.fireMessageReceived(Channels.java:274)
at org.jboss.netty.channel.Channels.fireMessageReceived(Channels.java:261)
at org.jboss.netty.channel.socket.nio.NioWorker.read(NioWorker.java:349)
at org.jboss.netty.channel.socket.nio.NioWorker.processSelectedKeys(NioWorker.java:281)
at org.jboss.netty.channel.socket.nio.NioWorker.run(NioWorker.java:201)
at org.jboss.netty.util.ThreadRenamingRunnable.run(ThreadRenamingRunnable.java:108)
at org.jboss.netty.util.internal.IoWorkerRunnable.run(IoWorkerRunnable.java:46)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:619)
Caused by: [InvalidSessionException]The specified session ID "null" is invalid. It cannot be found in the userbase.
at org.teiid.services.SessionServiceImpl.getSessionInfo(SessionServiceImpl.java:306)
at org.teiid.services.SessionServiceImpl.validateSession(SessionServiceImpl.java:299)
at org.teiid.jboss.deployers.RuntimeEngineDeployer$2.invoke(RuntimeEngineDeployer.java:280)
... 39 more
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
15 years, 2 months
[JBoss JIRA] Created: (TEIIDDES-555) Could not start Designer with Parts Examples project and perform Preview Data
by Barry LaFond (JIRA)
Could not start Designer with Parts Examples project and perform Preview Data
-----------------------------------------------------------------------------
Key: TEIIDDES-555
URL: https://jira.jboss.org/browse/TEIIDDES-555
Project: Teiid Designer
Issue Type: Bug
Reporter: Barry LaFond
Assignee: Dan Florian
Priority: Critical
Fix For: 7.1
1) Installed CR2 (08/13/2010) and opened Parts example project
2) Created Oracle DTP connection profile
3) Set Connection Profile on both models to this Oracle CP
4) Created Teiid Server instance
5) Select table in source or view model and tried to "Preview Data"
6) Got errors and it did NOT query
NOTE: I closed the project, started from scratch with "import Parts", then preview data worked immediately.
Maybe we aren't setting something correctly in the "Set Connection Profile" action?
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
15 years, 2 months
[JBoss JIRA] Resolved: (TEIIDDES-651) WARN [org.teiid.SECURITY] (New I/O server worker #2-1) Processing exception logged repeatedly
by Barry LaFond (JIRA)
[ https://jira.jboss.org/browse/TEIIDDES-651?page=com.atlassian.jira.plugin... ]
Barry LaFond resolved TEIIDDES-651.
-----------------------------------
Assignee: Barry LaFond
Resolution: Done
Added a new Server.testPing() method which closes the admin api method and sets the "admin" object to null.
This prevents a "stale" connection to be created every time someone hits the "Test" button on the New Teiid server wizard.
> WARN [org.teiid.SECURITY] (New I/O server worker #2-1) Processing exception logged repeatedly
> ----------------------------------------------------------------------------------------------
>
> Key: TEIIDDES-651
> URL: https://jira.jboss.org/browse/TEIIDDES-651
> Project: Teiid Designer
> Issue Type: Bug
> Components: VDB & Execution
> Affects Versions: 7.1.1
> Reporter: Len DiMaggio
> Assignee: Barry LaFond
>
> Seeing this warning repeatedly logged - this is after a clean install - no VDBs deployed.
> 2010-10-04 11:28:26,550 WARN [org.teiid.SECURITY] (New I/O server worker #2-1) Processing exception 'The specified session ID "XtF+rUkZ98v5" is invalid. It cannot be found in the userbase.' for session null. Exception type org.teiid.client.security.InvalidSessionException thrown from org.teiid.services.SessionServiceImpl.getSessionInfo(SessionServiceImpl.java:310).
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
15 years, 2 months