Hi people.

We have updated our SDP distribution from version 7611 to 8110 (OS linux, embedded mysql server).

After this update we noticed that users without SDAdmin role are unable to run lots of reports.

After digging this situation i found the reason of that issue.

Such reports have value of 2 in REPORTTYPE_ID field of CustomReport_Details table

Your ReportHome view shows links to this kind of reports like that:

<A class=publicReport onmouseout=parent.closeDialog() onclick="parent.closeDialog();javascript:runReport('module=run_query_editor_query&amp;report_id=30006',30006)" href="javascript:void(0)"> .... </A>

When user clicks this link your CustomReportHandler class returns auth error in handleRequest method if user has not SDAdmin role.

Here is this code, near 158 line

    if (("run_query_editor_query".equals(operation)) && (!ServiceDeskUtil.getInstance().isUserContainsRole("SDAdmin"))) {
      canModify = Boolean.valueOf(false);
      canDelete = Boolean.valueOf(false);
      return "AuthError";
    }

This code appeared after some of 8xxx build, version 7611 worked fine.

Can you please explain what is that ?