Overview

This article resolves an issue where, upon editing Audit Configuration in Archiver, the below error message is generated:

Failed during: ConfigTracingStep Details: Start Server Trace Failed: The read operation failed, see inner exception.

When checking the AuditProviders.log file, under \GFI\Archiver\Store\DebugLogs\, the following error message is observed:

2014-06-19,14:03:30,562,1,"#00000EFC","#00000015","info ","AuditProviders","SqlException Error: (MSSql)
ConfigMArcAdminForAudit [SQLINSTANCENAME]. Error execute: Cannot find the object 'MArcAudit_MArcAuditCreateTrace', because it does not exist or you do not have permission."

Information

Root Cause

The stored procedure [MArcAudit_MArcAuditCreateTrace] does not exist, or it has been removed from the [master] database.

Process 

1. Log in to SQL Management Studio using a sysadmin login.

2. Open a query window and execute the following query:

   USE [master]; 
   GO 
   CREATE PROCEDURE [dbo].[MArcAudit_MArcAuditCreateTrace] AS EXEC 
   [MArcAudit].dbo.CreateTrace; 
   GO

Note: The above query assumes the audit database has the default name of MArcAudit. If the database was named differently, make sure to change the appropriate section of the query to use the custom name.