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."
The stored procedure
[MArcAudit_MArcAuditCreateTrace] does not exist, or it has been removed from the
Log in to SQL Management Studio using a sysadmin login.
Open a query window and execute the following query:
CREATE PROCEDURE [dbo].[MArcAudit_MArcAuditCreateTrace] AS EXEC
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.