Cant search user by Role in users screen

Support
#1

Hey,
Please have a look at the bellow. it happens when I choose a role. any role.

Any idea?

image

java.lang.RuntimeException: Join mixing failed. Cannot find selected entity with name com.haulmont.cuba.core.sys.jpql.transform.VariableEntityReference@163b1441
	at com.haulmont.cuba.core.sys.jpql.transform.QueryTreeTransformer.mixinJoinIntoTree(QueryTreeTransformer.java:109)
	at com.haulmont.cuba.core.sys.jpql.transform.QueryTransformerAstBased.addJoinAndWhere(QueryTransformerAstBased.java:163)
	at com.haulmont.cuba.core.global.filter.QueryFilter.processQuery(QueryFilter.java:76)
	at com.haulmont.cuba.gui.data.impl.AbstractCollectionDatasource.getJPQLQuery(AbstractCollectionDatasource.java:334)
	at com.haulmont.cuba.gui.data.impl.AbstractCollectionDatasource.createDataQuery(AbstractCollectionDatasource.java:521)
	at com.haulmont.cuba.gui.data.impl.CollectionDatasourceImpl.beforeLoadData(CollectionDatasourceImpl.java:634)
	at com.haulmont.cuba.gui.data.impl.CollectionDatasourceImpl.loadData(CollectionDatasourceImpl.java:608)
	at com.haulmont.cuba.gui.data.impl.CollectionDatasourceImpl.refresh(CollectionDatasourceImpl.java:161)
	at com.haulmont.cuba.gui.data.impl.CollectionDatasourceImpl.refreshIfNotSuspended(CollectionDatasourceImpl.java:112)
	at com.haulmont.cuba.gui.components.filter.FilterDelegateImpl.refreshDatasource(FilterDelegateImpl.java:1644)
	at com.haulmont.cuba.gui.components.filter.FilterDelegateImpl.apply(FilterDelegateImpl.java:1488)
	at com.haulmont.cuba.gui.components.filter.FilterDelegateImpl$1.actionPerform(FilterDelegateImpl.java:289)
	at com.haulmont.cuba.web.gui.components.WebButton.performAction(WebButton.java:46)
	at com.haulmont.cuba.web.gui.components.WebButton.lambda$new$61446b05$1(WebButton.java:38)
	at sun.reflect.GeneratedMethodAccessor475.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

Thanks

#2

Hi,

How did you create this Role condition? Is it custom? What JPQL did you use?

#3

I dont understand, in the UI I went to users -> filter by role -> choose a role -> exveption…
Zero code, all core features.
Thanks

#4

Did you setup any security constraints or session attributes?

Also, what platform version do you use? Unfortunately, bug reports without details are nearly useless.

#5

Hi,
I did not setup any constraints or session attributes.
Im using tenant management
platform-6.10.0
Thanks

#7

Hi Avi,

Thank you for your prompt response and sorry for our delay reply. We are still checking this issue.

#8

Hello Avi,

We could not reproduce the error. Please send a test project where the error is reproduced.
Thank you!