Summation collector error information not listed in the collection error report

SYMPTOMS

In order to list the Summation error collection information you have to adjust the database view.

CAUSE

Initially the collection error report only applies to the file system collector.

RESOLUTION

• Open SQL Management studio and select the view section.
• Select the dbo.CollectionErrors view.
• Specify the correct PerformerType: WHERE (dbo.Action.PerformerType = 0)
• Open the 'design mode'
• In the CollectionErrors view configuration apply the view for the correct (summation) collector.
• PerformerType = 0 applies to all performers

- Example -

SELECT dbo.Action.Id AS ActionId, dbo.Action.DocumentId, dbo.Action.MachineName, dbo.ActionError.Message AS ErrorMessage, dbo.ActionError.TimeError,
dbo.ActionError.FileOrFolderName, dbo.ActionError.IsFile, dbo.Performer.Name AS PerformerName, dbo.Action.Status AS ActionStatus, dbo.Performer.MatterId
FROM dbo.ActionError INNER JOIN
dbo.Action ON dbo.ActionError.ActionId = dbo.Action.Id INNER JOIN
dbo.Performer ON dbo.Action.PerformerId = dbo.Performer.Id
WHERE (dbo.Action.PerformerType = 0)

APPLIES TO

3.6; 3.7