Error conection SQL -  Report SLA Smart Reporting

Version 2
    Share:|

    This document contains official content from the BMC Software Knowledge Base. It is automatically updated when the knowledge article is modified.


    PRODUCT:

    Remedy AR System Server


    APPLIES TO:

    Smart Reporting 9.1



    PROBLEM:

    When entering the SLA compliance report per user from smart Reporting, connection error appears database.


    CAUSE:

    User is not able to access OOTB SLM reports with the below error when running the reports: "SLA Compliance incidence per user assigned Report showing the details of the SLA attached to each incident, along with the assigned user, the status of


    SOLUTION:

    Create new report based on SLM View using single field and confirm that user does not have access to any SLM form in Remedy. Eg. SLM:SLADefinition

    There should be an exception ERROR .: (353): It does not have access to the form .; SLM:SLADefinition. Please check the SQL syntax and try again.

    Soln: Kindly provide the access/permission to SLM Form & then verify the output.


    Article Number:

    000124458


    Article Type:

    Solutions to a Product Problem



      Looking for additional information?    Search BMC Support  or  Browse Knowledge Articles