KNOWN ISSUE: Error occurred displaying report or Permission errors in the Ensemble logs

Article:TECH122347  |  Created: 2010-03-17  |  Updated: 2010-05-07  |  Article URL
NOTE: If you are experiencing this particular known issue, we recommend that you Subscribe to receive email notification each time this article is updated. Subscribers will be the first to learn about any releases, status changes, workarounds or decisions made.
Article Type
Technical Solution


After logging into the Servicedesk console(Process Manager) reports and view are getting the error "“Error occurred displaying report”  or you may see Permission errors in the Ensemble logs.


Servicedesk MR1 and earlier, or Workflow 7 SP1 or Earlier. 


There is a master reference table which stores all the assigned permissions.  If at any time there is a problem updating this table those updates will not complete correctly and leave the permission orphaned or missing.


Download the attached zip file, extract the 2 SQL scripts and run them against the Servicedesk/Workflow database.  Please note that it does not matter which script is ran first.  Please note that running the procedures the first time does nothing more than alter the procedure definition in the database.  For the permissions to be reset, and actually adjusted, the stored proc must be executed.  Inside of SQl Manangement Studio, simply right-click on the name of the procedure, and select "Execute Stored Procedure..."

For reference, the two procedures affected are

SP_UserReferenceIDLookup.sql - This resets permissions for all users and groups

SP_UserReferenceIDLookupWithReferenceID.sql - This resets specific group or USERID permissions only.

Attachments (1 kBytes)

Supplemental Materials

ValueETK 1984472
DescriptionLogged in Etrack (Symantec) database

Legacy ID


Article URL

Terms of use for this information are found in Legal Notices