Overview
This article provides the steps required to solve an issue that may occur when you are trying to enable auditing, which fails due to a duplicate <BackEndServer> node in the server.
Information
When you are trying to enable auditing, the attempt fails, and the following error is displayed in the wizard:
Failed during: ConfigTracingStep
Details: Start Server Trace Failed: The read operation failed, see inner exception.
Root Cause Analysis
The configuration file, MArcSettings.xml, contains a duplicate <BackEndServer>
node for the Microsoft SQL Server instance, which refers to an old/outdated or non-existent marc_admin login.
Diagnosis
The debug log ..\Store\DebugLogs\AuditProviders.log
reads:
"info ","AuditProviders","SqlException Error: (MSSql) ConfigMArcAdminForAudit [SQLSERVER\INSTANCE]. Error execute: 'marc_admin_20130718055157' is not a valid login or you do not have permission.
;User or role 'marc_admin_20130718055157' does not exist in this database."
The following is true for the configuration file ..\Core\Data\MArcSettings.xml
:
- The nodes
<MailArchiverSettings>
,<ArchiveStoreProfiles>
, and<BackEndServers>
, contain multiple<BackEndServer>
sub-nodes for the same Microsoft SQL Server instance (duplicates). - One of them contains a reference to an old/outdated or non-existent
marc_admin
login (For example:<Login>marc_admin_20130718055157</Login>
).
Solution
Warning: This procedure requires to edit files manually. If the files are edited incorrectly, it can leave the server in a non-operational state. Please create backups of any file that is edited throughout this procedure before saving any changes to them.
- Stop all GFI Archiver services.
- Open the
..\Core\Data\MArcSettings.xml
file in a text editor (preferably one with syntax highlighting, like Notepad++ or XML Marker). - In the XML file, locate the following nodes:
<MailArchiverSettings>
<ArchiveStoreProfiles>
<BackEndServers>
- Check each
<BackEndServer>
subnode and find the one that contains the<Login>
element which refers to the old/outdated or non-existentmarc_admin
login.- From the example above:
<Login>marc_admin_20130718055157</Login>
- From the example above:
- Remove the identified duplicate of the
<BackEndServer>
subnode (but not other ones). - Save the file.
- Start all GFI Archiver services.
- Try to enable auditing again.
- While going through the wizard, choose Microsoft SQL Server authentication and authenticate with the SA (SysAdmin) login.
Confirmation
Auditing was successfully enabled, and no error messages were displayed.
Priyanka Bhotika
Comments