On IRC Pedro Igor posted this stacktrace:

type Exception report

message javax.el.ELException: org.picketlink.idm.IdentityManagementException: PLIDM000500: Could not query Relationship using query [org.picketlink.idm.query.internal.DefaultRelationshipQuery@774f6104].

description The server encountered an internal error that prevented it from fulfilling this request.

exception

javax.servlet.ServletException: javax.el.ELException: org.picketlink.idm.IdentityManagementException: PLIDM000500: Could not query Relationship using query [org.picketlink.idm.query.internal.DefaultRelationshipQuery@774f6104].
	javax.faces.webapp.FacesServlet.service(FacesServlet.java:229)
	org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)
root cause

org.apache.myfaces.view.facelets.el.ContextAwareELException: javax.el.ELException: org.picketlink.idm.IdentityManagementException: PLIDM000500: Could not query Relationship using query [org.picketlink.idm.query.internal.DefaultRelationshipQuery@774f6104].
	org.apache.myfaces.view.facelets.el.ContextAwareTagValueExpression.getValue(ContextAwareTagValueExpression.java:104)
	javax.faces.component._DeltaStateHelper.eval(_DeltaStateHelper.java:266)
	javax.faces.component.UIComponentBase.isRendered(UIComponentBase.java:1185)
	org.apache.myfaces.view.facelets.tag.ui.ComponentRef.isRendered(ComponentRef.java:47)
	javax.faces.component.UIComponentBase.encodeAll(UIComponentBase.java:494)
	javax.faces.component.UIComponentBase.encodeAll(UIComponentBase.java:541)
	javax.faces.component.UIComponentBase.encodeAll(UIComponentBase.java:541)
	org.apache.myfaces.view.facelets.FaceletViewDeclarationLanguage.renderView(FaceletViewDeclarationLanguage.java:1981)
	org.apache.myfaces.application.ViewHandlerImpl.renderView(ViewHandlerImpl.java:305)
	javax.faces.application.ViewHandlerWrapper.renderView(ViewHandlerWrapper.java:59)
	org.apache.myfaces.lifecycle.RenderResponseExecutor.execute(RenderResponseExecutor.java:116)
	org.apache.myfaces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:241)
	javax.faces.webapp.FacesServlet.service(FacesServlet.java:199)
	org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)
root cause

javax.el.ELException: org.picketlink.idm.IdentityManagementException: PLIDM000500: Could not query Relationship using query [org.picketlink.idm.query.internal.DefaultRelationshipQuery@774f6104].
	javax.el.BeanELResolver.invoke(BeanELResolver.java:456)
	javax.el.CompositeELResolver.invoke(CompositeELResolver.java:225)
	org.apache.el.parser.AstValue.getValue(AstValue.java:173)
	org.apache.el.ValueExpressionImpl.getValue(ValueExpressionImpl.java:185)
	org.apache.webbeans.el22.WrappedValueExpression.getValue(WrappedValueExpression.java:70)
	org.apache.myfaces.view.facelets.el.ContextAwareTagValueExpression.getValue(ContextAwareTagValueExpression.java:96)
	javax.faces.component._DeltaStateHelper.eval(_DeltaStateHelper.java:266)
	javax.faces.component.UIComponentBase.isRendered(UIComponentBase.java:1185)
	org.apache.myfaces.view.facelets.tag.ui.ComponentRef.isRendered(ComponentRef.java:47)
	javax.faces.component.UIComponentBase.encodeAll(UIComponentBase.java:494)
	javax.faces.component.UIComponentBase.encodeAll(UIComponentBase.java:541)
	javax.faces.component.UIComponentBase.encodeAll(UIComponentBase.java:541)
	org.apache.myfaces.view.facelets.FaceletViewDeclarationLanguage.renderView(FaceletViewDeclarationLanguage.java:1981)
	org.apache.myfaces.application.ViewHandlerImpl.renderView(ViewHandlerImpl.java:305)
	javax.faces.application.ViewHandlerWrapper.renderView(ViewHandlerWrapper.java:59)
	org.apache.myfaces.lifecycle.RenderResponseExecutor.execute(RenderResponseExecutor.java:116)
	org.apache.myfaces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:241)
	javax.faces.webapp.FacesServlet.service(FacesServlet.java:199)
	org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)
root cause

org.picketlink.idm.IdentityManagementException: PLIDM000500: Could not query Relationship using query [org.picketlink.idm.query.internal.DefaultRelationshipQuery@774f6104].
	org.picketlink.idm.query.internal.DefaultRelationshipQuery.getResultList(DefaultRelationshipQuery.java:140)
	org.picketlink.idm.model.basic.BasicModel.hasRole(BasicModel.java:447)
	org.jboss.as.quickstarts.picketlink.authorization.idm.jpa.AuthorizationChecker.hasApplicationRole(AuthorizationChecker.java:52)
	sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
	sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	java.lang.reflect.Method.invoke(Method.java:606)
	javax.el.BeanELResolver.invoke(BeanELResolver.java:450)
	javax.el.CompositeELResolver.invoke(CompositeELResolver.java:225)
	org.apache.el.parser.AstValue.getValue(AstValue.java:173)
	org.apache.el.ValueExpressionImpl.getValue(ValueExpressionImpl.java:185)
	org.apache.webbeans.el22.WrappedValueExpression.getValue(WrappedValueExpression.java:70)
	org.apache.myfaces.view.facelets.el.ContextAwareTagValueExpression.getValue(ContextAwareTagValueExpression.java:96)
	javax.faces.component._DeltaStateHelper.eval(_DeltaStateHelper.java:266)
	javax.faces.component.UIComponentBase.isRendered(UIComponentBase.java:1185)
	org.apache.myfaces.view.facelets.tag.ui.ComponentRef.isRendered(ComponentRef.java:47)
	javax.faces.component.UIComponentBase.encodeAll(UIComponentBase.java:494)
	javax.faces.component.UIComponentBase.encodeAll(UIComponentBase.java:541)
	javax.faces.component.UIComponentBase.encodeAll(UIComponentBase.java:541)
	org.apache.myfaces.view.facelets.FaceletViewDeclarationLanguage.renderView(FaceletViewDeclarationLanguage.java:1981)
	org.apache.myfaces.application.ViewHandlerImpl.renderView(ViewHandlerImpl.java:305)
	javax.faces.application.ViewHandlerWrapper.renderView(ViewHandlerWrapper.java:59)
	org.apache.myfaces.lifecycle.RenderResponseExecutor.execute(RenderResponseExecutor.java:116)
	org.apache.myfaces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:241)
	javax.faces.webapp.FacesServlet.service(FacesServlet.java:199)
	org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)
root cause

<openjpa-2.3.0-nonfinal-1540826-r422266:1542644 fatal general error> org.apache.openjpa.persistence.PersistenceException: user lacks privilege or object not found: T9.ID {SELECT t4.id, t3.id, t3.typeName FROM RelationshipTypeEntity t3 INNER JOIN AttributedTypeEntity t4 ON t3.id = t4.id WHERE (t3.typeName = ? AND t4.id IN (SELECT t2.id FROM RelationshipIdentityTypeEntity t0 INNER JOIN IdentityTypeEntity t8 ON t0.IDENTITYTYPE_ID = t8.id INNER JOIN RelationshipTypeEntity t1 ON t0.OWNER_ID = t1.id INNER JOIN AttributedTypeEntity t11 ON t8.id = t11.id INNER JOIN AttributedTypeEntity t2 ON t1.id = t2.id INNER JOIN AttributedTypeEntity t10 ON t9.id = t10.id, RelationshipTypeEntity t9 WHERE (t0.descriptor = ? AND t11.id = ? AND t11.id IS NOT NULL)) AND t4.id IN (SELECT t7.id FROM RelationshipIdentityTypeEntity t5 INNER JOIN IdentityTypeEntity t12 ON t5.IDENTITYTYPE_ID = t12.id INNER JOIN RelationshipTypeEntity t6 ON t5.OWNER_ID = t6.id INNER JOIN AttributedTypeEntity t15 ON t12.id = t15.id INNER JOIN AttributedTypeEntity t7 ON t6.id = t7.id INNER JOIN AttributedTypeEntity t14 ON t13.id = t14.id, RelationshipTypeEntity t13 WHERE (t5.descriptor = ? AND t15.id = ? AND t15.id IS NOT NULL)))} [code=-5501, state=42501]
	org.apache.openjpa.jdbc.sql.DBDictionary.narrow(DBDictionary.java:4974)
	org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:4934)
	org.apache.openjpa.jdbc.sql.HSQLDictionary.newStoreException(HSQLDictionary.java:402)
	org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:134)
	org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:116)
	org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:68)
	org.apache.openjpa.jdbc.kernel.SelectResultObjectProvider.handleCheckedException(SelectResultObjectProvider.java:155)
	org.apache.openjpa.kernel.QueryImpl$PackingResultObjectProvider.handleCheckedException(QueryImpl.java:2111)
	org.apache.openjpa.lib.rop.EagerResultList.<init>(EagerResultList.java:40)
	org.apache.openjpa.kernel.QueryImpl.toResult(QueryImpl.java:1251)
	org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:1007)
	org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:863)
	org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:794)
	org.apache.openjpa.kernel.DelegatingQuery.execute(DelegatingQuery.java:542)
	org.apache.openjpa.persistence.QueryImpl.execute(QueryImpl.java:275)
	org.apache.openjpa.persistence.QueryImpl.getResultList(QueryImpl.java:291)
	org.apache.openejb.persistence.JtaQuery.getResultList(JtaQuery.java:82)
	org.apache.openejb.persistence.JtaTypedQuery.getResultList(JtaTypedQuery.java:49)
	org.picketlink.idm.jpa.internal.JPAIdentityStore.fetchQueryResults(JPAIdentityStore.java:669)
	org.picketlink.idm.query.internal.DefaultRelationshipQuery.getResultList(DefaultRelationshipQuery.java:112)
	org.picketlink.idm.model.basic.BasicModel.hasRole(BasicModel.java:447)
	org.jboss.as.quickstarts.picketlink.authorization.idm.jpa.AuthorizationChecker.hasApplicationRole(AuthorizationChecker.java:52)
	sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
	sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	java.lang.reflect.Method.invoke(Method.java:606)
	javax.el.BeanELResolver.invoke(BeanELResolver.java:450)
	javax.el.CompositeELResolver.invoke(CompositeELResolver.java:225)
	org.apache.el.parser.AstValue.getValue(AstValue.java:173)
	org.apache.el.ValueExpressionImpl.getValue(ValueExpressionImpl.java:185)
	org.apache.webbeans.el22.WrappedValueExpression.getValue(WrappedValueExpression.java:70)
	org.apache.myfaces.view.facelets.el.ContextAwareTagValueExpression.getValue(ContextAwareTagValueExpression.java:96)
	javax.faces.component._DeltaStateHelper.eval(_DeltaStateHelper.java:266)
	javax.faces.component.UIComponentBase.isRendered(UIComponentBase.java:1185)
	org.apache.myfaces.view.facelets.tag.ui.ComponentRef.isRendered(ComponentRef.java:47)
	javax.faces.component.UIComponentBase.encodeAll(UIComponentBase.java:494)
	javax.faces.component.UIComponentBase.encodeAll(UIComponentBase.java:541)
	javax.faces.component.UIComponentBase.encodeAll(UIComponentBase.java:541)
	org.apache.myfaces.view.facelets.FaceletViewDeclarationLanguage.renderView(FaceletViewDeclarationLanguage.java:1981)
	org.apache.myfaces.application.ViewHandlerImpl.renderView(ViewHandlerImpl.java:305)
	javax.faces.application.ViewHandlerWrapper.renderView(ViewHandlerWrapper.java:59)
	org.apache.myfaces.lifecycle.RenderResponseExecutor.execute(RenderResponseExecutor.java:116)
	org.apache.myfaces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:241)
	javax.faces.webapp.FacesServlet.service(FacesServlet.java:199)
	org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)
root cause

org.apache.openjpa.lib.jdbc.ReportingSQLException: user lacks privilege or object not found: T9.ID {SELECT t4.id, t3.id, t3.typeName FROM RelationshipTypeEntity t3 INNER JOIN AttributedTypeEntity t4 ON t3.id = t4.id WHERE (t3.typeName = ? AND t4.id IN (SELECT t2.id FROM RelationshipIdentityTypeEntity t0 INNER JOIN IdentityTypeEntity t8 ON t0.IDENTITYTYPE_ID = t8.id INNER JOIN RelationshipTypeEntity t1 ON t0.OWNER_ID = t1.id INNER JOIN AttributedTypeEntity t11 ON t8.id = t11.id INNER JOIN AttributedTypeEntity t2 ON t1.id = t2.id INNER JOIN AttributedTypeEntity t10 ON t9.id = t10.id, RelationshipTypeEntity t9 WHERE (t0.descriptor = ? AND t11.id = ? AND t11.id IS NOT NULL)) AND t4.id IN (SELECT t7.id FROM RelationshipIdentityTypeEntity t5 INNER JOIN IdentityTypeEntity t12 ON t5.IDENTITYTYPE_ID = t12.id INNER JOIN RelationshipTypeEntity t6 ON t5.OWNER_ID = t6.id INNER JOIN AttributedTypeEntity t15 ON t12.id = t15.id INNER JOIN AttributedTypeEntity t7 ON t6.id = t7.id INNER JOIN AttributedTypeEntity t14 ON t13.id = t14.id, RelationshipTypeEntity t13 WHERE (t5.descriptor = ? AND t15.id = ? AND t15.id IS NOT NULL)))} [code=-5501, state=42501]
	org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:219)
	org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:199)
	org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$000(LoggingConnectionDecorator.java:59)
	org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection.prepareStatement(LoggingConnectionDecorator.java:251)
	org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:133)
	org.apache.openjpa.lib.jdbc.ConfiguringConnectionDecorator$ConfiguringConnection.prepareStatement(ConfiguringConnectionDecorator.java:140)
	org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:133)
	org.apache.openjpa.jdbc.kernel.JDBCStoreManager$RefCountConnection.prepareStatement(JDBCStoreManager.java:1643)
	org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:122)
	org.apache.openjpa.jdbc.sql.SQLBuffer.prepareStatement(SQLBuffer.java:508)
	org.apache.openjpa.jdbc.sql.SQLBuffer.prepareStatement(SQLBuffer.java:488)
	org.apache.openjpa.jdbc.sql.SelectImpl.prepareStatement(SelectImpl.java:481)
	org.apache.openjpa.jdbc.sql.SelectImpl.execute(SelectImpl.java:422)
	org.apache.openjpa.jdbc.sql.SelectImpl.execute(SelectImpl.java:393)
	org.apache.openjpa.jdbc.sql.LogicalUnion$UnionSelect.execute(LogicalUnion.java:427)
	org.apache.openjpa.jdbc.sql.LogicalUnion.execute(LogicalUnion.java:230)
	org.apache.openjpa.jdbc.sql.LogicalUnion.execute(LogicalUnion.java:220)
	org.apache.openjpa.jdbc.kernel.SelectResultObjectProvider.open(SelectResultObjectProvider.java:94)
	org.apache.openjpa.kernel.QueryImpl$PackingResultObjectProvider.open(QueryImpl.java:2070)
	org.apache.openjpa.lib.rop.EagerResultList.<init>(EagerResultList.java:34)
	org.apache.openjpa.kernel.QueryImpl.toResult(QueryImpl.java:1251)
	org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:1007)
	org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:863)
	org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:794)
	org.apache.openjpa.kernel.DelegatingQuery.execute(DelegatingQuery.java:542)
	org.apache.openjpa.persistence.QueryImpl.execute(QueryImpl.java:275)
	org.apache.openjpa.persistence.QueryImpl.getResultList(QueryImpl.java:291)
	org.apache.openejb.persistence.JtaQuery.getResultList(JtaQuery.java:82)
	org.apache.openejb.persistence.JtaTypedQuery.getResultList(JtaTypedQuery.java:49)
	org.picketlink.idm.jpa.internal.JPAIdentityStore.fetchQueryResults(JPAIdentityStore.java:669)
	org.picketlink.idm.query.internal.DefaultRelationshipQuery.getResultList(DefaultRelationshipQuery.java:112)
	org.picketlink.idm.model.basic.BasicModel.hasRole(BasicModel.java:447)
	org.jboss.as.quickstarts.picketlink.authorization.idm.jpa.AuthorizationChecker.hasApplicationRole(AuthorizationChecker.java:52)
	sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
	sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	java.lang.reflect.Method.invoke(Method.java:606)
	javax.el.BeanELResolver.invoke(BeanELResolver.java:450)
	javax.el.CompositeELResolver.invoke(CompositeELResolver.java:225)
	org.apache.el.parser.AstValue.getValue(AstValue.java:173)
	org.apache.el.ValueExpressionImpl.getValue(ValueExpressionImpl.java:185)
	org.apache.webbeans.el22.WrappedValueExpression.getValue(WrappedValueExpression.java:70)
	org.apache.myfaces.view.facelets.el.ContextAwareTagValueExpression.getValue(ContextAwareTagValueExpression.java:96)
	javax.faces.component._DeltaStateHelper.eval(_DeltaStateHelper.java:266)
	javax.faces.component.UIComponentBase.isRendered(UIComponentBase.java:1185)
	org.apache.myfaces.view.facelets.tag.ui.ComponentRef.isRendered(ComponentRef.java:47)
	javax.faces.component.UIComponentBase.encodeAll(UIComponentBase.java:494)
	javax.faces.component.UIComponentBase.encodeAll(UIComponentBase.java:541)
	javax.faces.component.UIComponentBase.encodeAll(UIComponentBase.java:541)
	org.apache.myfaces.view.facelets.FaceletViewDeclarationLanguage.renderView(FaceletViewDeclarationLanguage.java:1981)
	org.apache.myfaces.application.ViewHandlerImpl.renderView(ViewHandlerImpl.java:305)
	javax.faces.application.ViewHandlerWrapper.renderView(ViewHandlerWrapper.java:59)
	org.apache.myfaces.lifecycle.RenderResponseExecutor.execute(RenderResponseExecutor.java:116)
	org.apache.myfaces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:241)
	javax.faces.webapp.FacesServlet.service(FacesServlet.java:199)
	org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)
note The full stack trace of the root cause is available in the Apache Tomcat (TomEE)/7.0.47 (1.6.0) logs.

Apache Tomcat (TomEE)/7.0.47 (1.6.0)

Looks like the following part of the query is responsible for the bug/error:

 INNER JOIN AttributedTypeEntity t10 ON t9.id = t10.id, RelationshipTypeEntity t9
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