[Progress Communities] [Progress OpenEdge ABL] Forum Post: Relationship-based permissions - give sql error - 5.2.2.0

  • Thread starter Thread starter Lisette Dekker
  • Start date Start date
Status
Not open for further replies.
L

Lisette Dekker

Guest
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?

Continue reading...
 
Status
Not open for further replies.
Back
Top