Error in COM access layer: number: 8007202F, description: A constraint violation occurred

Hello,

OneIM Version 8.1.4

Our client is creating users manually through the manager tool. They don't have an authoritative application. They have around 10 login user accounts through which they usually create users in the Manager Tool and users get provision into AD, Microsoft Exchange 2013.

For few users, provisioning is working fine; for few users, we are getting below error. 

[1777018] Error executing synchronization project (Active Directory Domain (DC=YYY,DC=COM))'s workflow (Provisioning).
[1777124] Error executing projection step (user) of projection configuration (Provisioning (Provisioning)).
[1777219] Error executing synchronization step (user)!
[1777004] Method (Insert object (Insert)) could not be executed successfully.
[System.Exception] Error committing object CN=TestUser,OU=TestOU BRANCH,OU=XXX,DC=YYY,DC=com.(Error: Method Commit() was called on object CN=TestUser,OU=TestOU BRANCH,OU=XXX,DC=YYY,DC=com.
Property url is set.
Method Commit() was called on object CN=TestUser,OU=TestOU BRANCH,OU=XXX,DC=YYY,DC=com.
Property otherTelephone is set.
Method Commit() was called on object CN=TestUser,OU=TestOU BRANCH,OU=XXX,DC=YYY,DC=com.
Property otherPager is set.
Method Commit() was called on object CN=TestUser,OU=TestOU BRANCH,OU=XXX,DC=YYY,DC=com.
Property otherMobile is set.
Method Commit() was called on object CN=TestUser,OU=TestOU BRANCH,OU=XXX,DC=YYY,DC=com.
Property otherMailbox is set.
Method Commit() was called on object CN=TestUser,OU=TestOU BRANCH,OU=XXX,DC=YYY,DC=com.
Property otherIpPhone is set.
Method Commit() was called on object CN=TestUser,OU=TestOU BRANCH,OU=XXX,DC=YYY,DC=com.
Property otherHomePhone is set.
Method Commit() was called on object CN=TestUser,OU=TestOU BRANCH,OU=XXX,DC=YYY,DC=com.
Property otherFacsimileTelephoneNumber is set.
Method Commit() was called on object CN=TestUser,OU=TestOU BRANCH,OU=XXX,DC=YYY,DC=com.
Property msRADIUSFramedRoute is set.
Method Commit() was called on object CN=TestUser,OU=TestOU BRANCH,OU=XXX,DC=YYY,DC=com.
Property extensionData is set.
Method Commit() was called on object CN=TestUser,OU=TestOU BRANCH,OU=XXX,DC=YYY,DC=com.
Property wWWHomePage not changed because value is already set.
Method Commit() was called on object CN=TestUser,OU=TestOU BRANCH,OU=XXX,DC=YYY,DC=com.
Property vrtPassword is set.
Method Commit() was called on object CN=TestUser,OU=TestOU BRANCH,OU=XXX,DC=YYY,DC=com.
Property manager is set.
Method Commit() was called on object CN=TestUser,OU=TestOU BRANCH,OU=XXX,DC=YYY,DC=com.
Property co is set.
Method Commit() was called on object CN=TestUser,OU=TestOU BRANCH,OU=XXX,DC=YYY,DC=com.
Property c is set.
Method Commit() was called on object CN=TestUser,OU=TestOU BRANCH,OU=XXX,DC=YYY,DC=com.
Property vrtPrimaryGroupID is set.
Method Commit() was called on object CN=TestUser,OU=TestOU BRANCH,OU=XXX,DC=YYY,DC=com.
Property countryCode is set.
Method Commit() was called on object CN=TestUser,OU=TestOU BRANCH,OU=XXX,DC=YYY,DC=com.
Property userPrincipalName is set.
Method Commit() was called on object CN=TestUser,OU=TestOU BRANCH,OU=XXX,DC=YYY,DC=com.
Property pwdLastSet is set.
Method Commit() was called on object CN=TestUser,OU=TestOU BRANCH,OU=XXX,DC=YYY,DC=com.
Property vrtuserCannotChangePassword not changed because value is already set.
Method Commit() was called on object CN=TestUser,OU=TestOU BRANCH,OU=XXX,DC=YYY,DC=com.
Property vrtparentDn not changed because value is already set.
Method Commit() was called on object CN=TestUser,OU=TestOU BRANCH,OU=XXX,DC=YYY,DC=com.
Property TSWorkingDirectory not changed because value is already set.
Method Commit() was called on object CN=TestUser,OU=TestOU BRANCH,OU=XXX,DC=YYY,DC=com.
Property TSTimeoutSetIdle not changed because value is already set.
Method Commit() was called on object CN=TestUser,OU=TestOU BRANCH,OU=XXX,DC=YYY,DC=com.
Property TSTimeoutSetDisconnections not changed because value is already set.
Method Commit() was called on object CN=TestUser,OU=TestOU BRANCH,OU=XXX,DC=YYY,DC=com.
Property TSTimeoutSetConnections not changed because value is already set.
Method Commit() was called on object CN=TestUser,OU=TestOU BRANCH,OU=XXX,DC=YYY,DC=com.
Property TSRemoteViewSession not changed because value is already set.
Method Commit() was called on object CN=TestUser,OU=TestOU BRANCH,OU=XXX,DC=YYY,DC=com.
Property TSRemotePermissionRequired not changed because value is already set.
Method Commit() was called on object CN=TestUser,OU=TestOU BRANCH,OU=XXX,DC=YYY,DC=com.
Property TSRemoteInteractWithSession not changed because value is already set.
Method Commit() was called on object CN=TestUser,OU=TestOU BRANCH,OU=XXX,DC=YYY,DC=com.
Property TSRemoteEnable is set.
Method Commit() was called on object CN=TestUser,OU=TestOU BRANCH,OU=XXX,DC=YYY,DC=com.
Property TSReconnectSet not changed because value is already set.
Method Commit() was called on object CN=TestUser,OU=TestOU BRANCH,OU=XXX,DC=YYY,DC=com.
Property TSInitialProgram not changed because value is already set.
Method Commit() was called on object CN=TestUser,OU=TestOU BRANCH,OU=XXX,DC=YYY,DC=com.
Property TSInheritInitialProgram not changed because value is already set.
Method Commit() was called on object CN=TestUser,OU=TestOU BRANCH,OU=XXX,DC=YYY,DC=com.
Property TSDeviceClientPrinters not changed because value is already set.
Method Commit() was called on object CN=TestUser,OU=TestOU BRANCH,OU=XXX,DC=YYY,DC=com.
Property TSDeviceClientDrives not changed because value is already set.
Method Commit() was called on object CN=TestUser,OU=TestOU BRANCH,OU=XXX,DC=YYY,DC=com.
Property TSDeviceClientDefaultPrinter not changed because value is already set.
Method Commit() was called on object CN=TestUser,OU=TestOU BRANCH,OU=XXX,DC=YYY,DC=com.
Property TSBrokenTimeoutSet not changed because value is already set.
Method Commit() was called on object CN=TestUser,OU=TestOU BRANCH,OU=XXX,DC=YYY,DC=com.
Property title not changed because value is already set.
Method Commit() was called on object CN=TestUser,OU=TestOU BRANCH,OU=XXX,DC=YYY,DC=com.
Property TSTerminalServerProfilePath not changed because value is already set.
Method Commit() was called on object CN=TestUser,OU=TestOU BRANCH,OU=XXX,DC=YYY,DC=com.
Property TSTerminalServerHomeDirDrive not changed because value is already set.
Method Commit() was called on object CN=TestUser,OU=TestOU BRANCH,OU=XXX,DC=YYY,DC=com.
Property TSTerminalServerHomeDir not changed because value is already set.
Method Commit() was called on object CN=TestUser,OU=TestOU BRANCH,OU=XXX,DC=YYY,DC=com.
Property telephoneNumber not changed because value is already set.
Method Commit() was called on object CN=TestUser,OU=TestOU BRANCH,OU=XXX,DC=YYY,DC=com.
Property sn is set.
Method Commit() was called on object CN=TestUser,OU=TestOU BRANCH,OU=XXX,DC=YYY,DC=com.
Property streetAddress is set.
Method Commit() was called on object CN=TestUser,OU=TestOU BRANCH,OU=XXX,DC=YYY,DC=com.
Property st not changed because value is already set.
Method Commit() was called on object CN=TestUser,OU=TestOU BRANCH,OU=XXX,DC=YYY,DC=com.
Property scriptPath not changed because value is already set.
Method Commit() was called on object CN=TestUser,OU=TestOU BRANCH,OU=XXX,DC=YYY,DC=com.
Property profilePath not changed because value is already set.
Method Commit() was called on object CN=TestUser,OU=TestOU BRANCH,OU=XXX,DC=YYY,DC=com.
Property postalCode not changed because value is already set.
Method Commit() was called on object CN=TestUser,OU=TestOU BRANCH,OU=XXX,DC=YYY,DC=com.
Property physicalDeliveryOfficeName not changed because value is already set.
Method Commit() was called on object CN=TestUser,OU=TestOU BRANCH,OU=XXX,DC=YYY,DC=com.
Property personalTitle not changed because value is already set.
Method Commit() was called on object CN=TestUser,OU=TestOU BRANCH,OU=XXX,DC=YYY,DC=com.
Property vrtPasswordNeverExpires not changed because value is already set.
Method Commit() was called on object CN=TestUser,OU=TestOU BRANCH,OU=XXX,DC=YYY,DC=com.
Property pager not changed because value is already set.
Method Commit() was called on object CN=TestUser,OU=TestOU BRANCH,OU=XXX,DC=YYY,DC=com.
Property vrtobjectClass is set.
Method Commit() was called on object CN=TestUser,OU=TestOU BRANCH,OU=XXX,DC=YYY,DC=com.
Property msRADIUSServiceType not changed because value is already set.
Method Commit() was called on object CN=TestUser,OU=TestOU BRANCH,OU=XXX,DC=YYY,DC=com.
Property msRADIUSFramedIPAddress not changed because value is already set.
Method Commit() was called on object CN=TestUser,OU=TestOU BRANCH,OU=XXX,DC=YYY,DC=com.
Property msRADIUSCallbackNumber not changed because value is already set.
Method Commit() was called on object CN=TestUser,OU=TestOU BRANCH,OU=XXX,DC=YYY,DC=com.
Property mS-DS-ConsistencyGuid is set.
Method Commit() was called on object CN=TestUser,OU=TestOU BRANCH,OU=XXX,DC=YYY,DC=com.
Property mobile not changed because value is already set.
Method Commit() was called on object CN=TestUser,OU=TestOU BRANCH,OU=XXX,DC=YYY,DC=com.
Property mail is set.
Method Commit() was called on object CN=TestUser,OU=TestOU BRANCH,OU=XXX,DC=YYY,DC=com.
Property userWorkstations not changed because value is already set.
Method Commit() was called on object CN=TestUser,OU=TestOU BRANCH,OU=XXX,DC=YYY,DC=com.
Property logonHours is set.
Method Commit() was called on object CN=TestUser,OU=TestOU BRANCH,OU=XXX,DC=YYY,DC=com.
Property l is set.
Method Commit() was called on object CN=TestUser,OU=TestOU BRANCH,OU=XXX,DC=YYY,DC=com.
Property ipPhone not changed because value is already set.
A constraint violation occurred.

Error in COM access layer: number: 8007202F, description: A constraint violation occurred.

Method Commit() was called on object CN=TestUser,OU=TestOU BRANCH,OU=XXX,DC=YYY,DC=com.
Property initials is set.
Method Commit() was called on object CN=TestUser,OU=TestOU BRANCH,OU=XXX,DC=YYY,DC=com.
Property info not changed because value is already set.
Method Commit() was called on object CN=TestUser,OU=TestOU BRANCH,OU=XXX,DC=YYY,DC=com.
Property homePhone not changed because value is already set.
Method Commit() was called on object CN=TestUser,OU=TestOU BRANCH,OU=XXX,DC=YYY,DC=com.
Property homeDrive not changed because value is already set.
Method Commit() was called on object CN=TestUser,OU=TestOU BRANCH,OU=XXX,DC=YYY,DC=com.
Property homeDirectory not changed because value is already set.
Method Commit() was called on object CN=TestUser,OU=TestOU BRANCH,OU=XXX,DC=YYY,DC=com.
Property givenName is set.
Method Commit() was called on object CN=TestUser,OU=TestOU BRANCH,OU=XXX,DC=YYY,DC=com.
Property facsimileTelephoneNumber not changed because value is already set.
Method Commit() was called on object CN=TestUser,OU=TestOU BRANCH,OU=XXX,DC=YYY,DC=com.
Property extensionAttribute9 not changed because value is already set.
Method Commit() was called on object CN=TestUser,OU=TestOU BRANCH,OU=XXX,DC=YYY,DC=com.
Property extensionAttribute8 not changed because value is already set.
Method Commit() was called on object CN=TestUser,OU=TestOU BRANCH,OU=XXX,DC=YYY,DC=com.
Property extensionAttribute7 not changed because value is already set.
Method Commit() was called on object CN=TestUser,OU=TestOU BRANCH,OU=XXX,DC=YYY,DC=com.
Property extensionAttribute6 not changed because value is already set.
Method Commit() was called on object CN=TestUser,OU=TestOU BRANCH,OU=XXX,DC=YYY,DC=com.
Property extensionAttribute5 not changed because value is already set.
Method Commit() was called on object CN=TestUser,OU=TestOU BRANCH,OU=XXX,DC=YYY,DC=com.
Property extensionAttribute4 not changed because value is already set.
Method Commit() was called on object CN=TestUser,OU=TestOU BRANCH,OU=XXX,DC=YYY,DC=com.
Property extensionAttribute3 not changed because value is already set.
Method Commit() was called on object CN=TestUser,OU=TestOU BRANCH,OU=XXX,DC=YYY,DC=com.
Property extensionAttribute2 not changed because value is already set.
Method Commit() was called on object CN=TestUser,OU=TestOU BRANCH,OU=XXX,DC=YYY,DC=com.
Property extensionAttribute15 not changed because value is already set.
Method Commit() was called on object CN=TestUser,OU=TestOU BRANCH,OU=XXX,DC=YYY,DC=com.
Property extensionAttribute14 not changed because value is already set.
Method Commit() was called on object CN=TestUser,OU=TestOU BRANCH,OU=XXX,DC=YYY,DC=com.
Property extensionAttribute13 not changed because value is already set.
Method Commit() was called on object CN=TestUser,OU=TestOU BRANCH,OU=XXX,DC=YYY,DC=com.
Property extensionAttribute12 not changed because value is already set.
Method Commit() was called on object CN=TestUser,OU=TestOU BRANCH,OU=XXX,DC=YYY,DC=com.
Property extensionAttribute11 not changed because value is already set.
Method Commit() was called on object CN=TestUser,OU=TestOU BRANCH,OU=XXX,DC=YYY,DC=com.
Property extensionAttribute10 not changed because value is already set.
Method Commit() was called on object CN=TestUser,OU=TestOU BRANCH,OU=XXX,DC=YYY,DC=com.
Property extensionAttribute1 not changed because value is already set.
Method Commit() was called on object CN=TestUser,OU=TestOU BRANCH,OU=XXX,DC=YYY,DC=com.
Property employeeType not changed because value is already set.
Method Commit() was called on object CN=TestUser,OU=TestOU BRANCH,OU=XXX,DC=YYY,DC=com.
Property employeeNumber not changed because value is already set.
Method Commit() was called on object CN=TestUser,OU=TestOU BRANCH,OU=XXX,DC=YYY,DC=com.
Property employeeID not changed because value is already set.
Method Commit() was called on object CN=TestUser,OU=TestOU BRANCH,OU=XXX,DC=YYY,DC=com.
Property vrtdistinguishedName not changed because value is already set.
Method Commit() was called on object CN=TestUser,OU=TestOU BRANCH,OU=XXX,DC=YYY,DC=com.
Property displayName is set.
Method Commit() was called on object CN=TestUser,OU=TestOU BRANCH,OU=XXX,DC=YYY,DC=com.
Property department not changed because value is already set.
Method Commit() was called on object CN=TestUser,OU=TestOU BRANCH,OU=XXX,DC=YYY,DC=com.
Property company not changed because value is already set.
Method Commit() was called on object CN=TestUser,OU=TestOU BRANCH,OU=XXX,DC=YYY,DC=com.
Property vrtName not changed because value is already set.
Method Commit() was called on object CN=TestUser,OU=TestOU BRANCH,OU=XXX,DC=YYY,DC=com.
Property TSAllowLogonTerminalServer is set.
Method Commit() was called on object CN=TestUser,OU=TestOU BRANCH,OU=XXX,DC=YYY,DC=com.
Property vrtIsAccountLocked not changed because value is already set.
Method Commit() was called on object CN=TestUser,OU=TestOU BRANCH,OU=XXX,DC=YYY,DC=com.
Property accountExpires is set.
Method Commit() was called on object CN=TestUser,OU=TestOU BRANCH,OU=XXX,DC=YYY,DC=com.
Property userAccountControl is set.
Method Commit() was called on object CN=TestUser,OU=TestOU BRANCH,OU=XXX,DC=YYY,DC=com.
Property sAMAccountName not changed because value is already set.
Property objectClass is set.
Property cn not changed because value is already set.
New object created for a commit retry.
)

I need your assistance.

Thanks,

  • Hello,

    This error has come up in the forum before, so do a search for possible solutions, but this seems to be the issue:

    Property ipPhone not changed because value is already set.
    A constraint violation occurred.

    Error in COM access layer: number: 8007202F, description: A constraint violation occurred.

    Check the mapping, permissions, etc.

    Trevor