KPI Module/Group Security page of the Roles/User Browser in Security Management of Administrator module is showing wrong information. How can it be corrected?

KPI Module/Group Security page of the Roles/User Browser in Security Management of Administrator module is showing wrong information. How can it be corrected?

To correct the information, replace the query 'SECURITY_USER_ROLE' with the query as provided below in the admin_mysql_admin.xml file: SECURITY_USER_ROLE SELECT DISTINCT B.MODULE_ID,B.GROUP_ID,B.KPI_ID,C.VIEW_ID,F.MODULE_NAME,E.GROUP_NAME,D.KPI_NAME,C.VIEW_NAME,A.GRANT_FLAG FROM ADMIN_KPI_GROUP_MODULE B JOIN ADMIN_MODULELIST F ON F.MODULE_ID = B.MODULE_ID JOIN ADMIN_KPI_GROUPS E ON E.ID = B.GROUP_ID JOIN ADMIN_KPI D ON D.KPI_ID =B.KPI_ID LEFT JOIN ADMIN_KPIVIEWDETAIL C ON C.KPI_ID=B.KPI_ID AND C.KPI_ID>0 JOIN ADMIN_MAP_DEP_ROLE_USER_PRIV A ON #param# WHERE A.MODULE_ID>0 AND A.MAX_LEVEL=? AND A.ROLE_ID IN (SELECT DISTINCT ROLE_ID FROM ADMIN_MAP_DEPARTMENT_ROLE_USER WHERE USER_ID=?) AND B.KPI_ID>0 ORDER BY B.MODULE_ID . After changing the query, re-cache changes so that the changes made comes to effect.