Return
-
Title
Error: “[2262003] Error executing task MaintainOtherSid.” -
Description
As reported in KB article 234876:
ErrorMessages = (2018-08-28 22:02:45.603) Executed on: syncserver_eu11corp[2262003] Error executing process task "MaintainOtherSid".[System.ArgumentException] An item with the same key has already been added.at StdioProcessor.StdioProcessor._Execute(Job job)at VI.Projector.ADS.JobComponent.Tasks.MaintainOtherSid.Execute()---- Start of Inner Exception ----at VI.Projector.ADS.JobComponent.Tasks.MaintainOtherSid.Execute()at VI.Projector.ADS.JobComponent.Tasks.MaintainOtherSid._Execute()at VI.Projector.ADS.JobComponent.Tasks.MaintainOtherSid._LoadKnownSids()at System.Linq.Enumerable.ToDictionary[TSource,TKey,TElement](IEnumerable`1 source, Func`2 keySelector, Func`2 elementSelector, IEqualityComparer`1 comparer)at System.Collections.Generic.Dictionary`2.Insert(TKey key, TValue value, Boolean add)at System.ThrowHelper.ThrowArgumentException(ExceptionResource resource)
-
Cause
This is a new defect (apart from 29115). It is caused by duplicates in ADSOtherSID caused by parallel running of the ADSJobComponent task MaintainOtherSid.
This task first loads all already known ObjectSIDs from this table and in case it has a new ObjectSID found in the DPR Attached Data Store it creates a new row in ADSOtherSID.
When this is done simultaneously by two instances, the result is duplicates. -
Resolution
WORKAROUND
Identity and delete those duplicates:
select ObjectSID, DistinguishedName, Ident_ADSOtherSID, XDateInserted, XDateUpdated, XMarkedForDeletion, UID_ADSOtherSIDfrom ADSOtherSIDwhere ObjectSID in(select ObjectSIDfrom ADSOtherSIDgroup by ObjectSIDhaving count(ObjectSID) > 1)order by ObjectSID, DistinguishedName
Delete ONE row of each pair by its UID_ADSOtherSID using this cmd:
delete ADSOtherSID where UID_ADSOtherSID = ...
STATUS
This issue has been resolved in versions 7.1.5, 8.03 and 8.1. For earlier versions a hotfix is available from Support. Please request hotfix for defect 30552. -
Change Request
30552