Error when trying to access the Audit Trail Report

Error when trying to access the Audit Trail Report

Comments

  • Hi,

    I am getting below screen and error when trying to access Audit Trail Report. Can you help me to find the issue here?

    Thanks

    [Exception]:System.Exception: Error executing database command: select top 500 [url=http://audit_entity.id/]audit_entity.id[/url] as id, audit_entity.account_email as account_email, audit_entity.entity_id as entity_id, audit_entity.entity_name as entity_name, audit_entity.entity_type_name as entity_type_name, audit_entity.notes as notes, audit_entity.time_of_change as time_of_change, audit_entity.type_of_change as type_of_change from audit_entity Order by audit_entity.time_of_change DESC , [url=http://audit_entity.id/]audit_entity.id[/url] ASC Error message: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.Data.SqlClient.SqlException: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.ComponentModel.Win32Exception: The wait operation timed out

    [img]att1[/img]

  • Hi,

    [color=rgb(34, 34, 34)][font=Arial, Helvetica, sans-serif]You need to increase the "DefaultDatabaseQueryTimeout" value in Settings.xml file and restart service host manager.[/font][/color]
    [color=rgb(34, 34, 34)][font=Arial, Helvetica, sans-serif]
    [/font][/color]
    [color=rgb(34, 34, 34)][font=Arial, Helvetica, sans-serif]Settings.xml file default path: C:Program FilesDecisionsDecisions Services Manager [/font][/color]
    [color=rgb(34, 34, 34)][font=Arial, Helvetica, sans-serif]
    [/font][/color]
    [color=rgb(34, 34, 34)][font=Arial, Helvetica, sans-serif][url=https://documentation.decisions.com/docs/restart-service-host-manager]How to Restart Service Host Manager[/url][/font][/color]

    [color=rgb(34, 34, 34)][font=Arial, Helvetica, sans-serif]
    [/font][/color]
    [color=rgb(34, 34, 34)][font=Arial, Helvetica, sans-serif][img]att1[/img][/font][/color]
    [i]edited by kenan@decisions.com on 12/12/2019[/i]

Sign In or Register to comment.