[teiid-designer-issues] [JBoss JIRA] Created: (TEIIDDES-609) Teiid QueryValidatorException opening VDB schema in Data Source Explorer for model with "hidden" table.
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