1 Reply Latest reply on Jun 29, 2016 7:54 AM by Waldy

    Error in Time To Resolution Report

    dunnsu Apprentice

      Hello -

       

      I need to be able to run the Time To Resolution report and am getting the following error:

      TTR Error.JPG

       

      Our database is SQL and I ran these scripts:

      Duration Functions_SQL.sql

      vw_IncidentDuration_SQL.sql

      vw_Max_Resolution_SQL.sql

       

      We're running Service Desk 2016.  Anyone else encountered this?

       

      Thanks,  Susan

        • 1. Re: Error in Time To Resolution Report
          Waldy Employee

          Hi Susan,

                         the only database reference in the WorkTimeFormatted function is the vw_IncidentDuration view.  Can you actually do a SQL select on the view and get rows returned without receiving an error?  There may be a permissions issue on the calculation functions.