Relationship-based permissions - give sql error - 5.2.2.0

Posted by Lisette Dekker on 08-Oct-2018 11:33

Since an update to version 5.2.2.0

There is a problem with the relationship-base permissions. Whenever I use any of them the list view does not load, just gives "Error in SQL Query ListView=18338"

Following error code shows up in de system logs;

Error in SQL Query ListView=18338

SELECT COUNT(*) FROM (SELECT A.OBJ_ID FROM RB_OBJ_DATA A LEFT OUTER JOIN RB_RELATIONSHIP Q ON Q.OBJ1_ID=A.OBJ_ID WHERE A.OBJ_DEF_ID=17441 AND (( A.CREATED_BY=36015 ) OR (Q.OBJ2_ID=36015 AND Q.RELATIONSHIP_ID=17954 AND )) )

The last bit seems the problem there is nothing following the last AND.

Anything I can do, besides making views circumventing this issue?

All Replies

Posted by Santosh Patel on 08-Oct-2018 14:49

5.2.3.0 was released for this very issue. Check here www.progress.com/.../release-5.2.3-private-cloud

The issue occurs when non-admin users visit views that have relationship based permissions. Please upgrade to 5.2.3 to resolve the issue.

This thread is closed