User profiles could not be updated with list of deleted SAP users - Event 5007 (Duet Enterprise)

 

Applies to: Duet Enterprise for Microsoft SharePoint and SAP Server 2.0

Alert Name:   User profiles could not be updated with list of deleted SAP users

Event ID:   5007

Summary

Microsoft Business Connectivity Services provides a connector for communication between SharePoint Server and the SAP environment. The Duet Enterprise Profile Synchronization timer job uses the Business Data Connectivity service to retrieve the list of deleted SAP users from the SAP system and subsequently update the User Profile store by clearing the SAP Roles property for the deleted SAP users. Business Connectivity Services could not retrieve the list of deleted SAP users.

Symptoms

The following symptoms might appear:

  • The Duet Enterprise Profile Synchronization timer job fails.

  • This event appears in the event log:

    Event ID: 5007 Description: Could not retrieve deleted users information from backend. The exception message is <message>.

Cause

One or more of the following might be the cause:

  • Transient connectivity problems that are caused by high server load on the SAP system.

  • The process account for the SharePoint 2010 Timer (SPTimerV4) service does not have Execute permissions on the BDC UserRoles model.

Resolution

Grant permissions on the BDC UserRoles model

  1. Verify that you have the following administrative credentials:

    • You must be a member of the Farm Administrators group.
  2. Follow the instructions in Manage user access to BDC models (https://go.microsoft.com/fwlink/?LinkID=201163) to grant the process account for the SharePoint 2010 Timer service Execute permissions on the BDC UserRoles model.

Synchronize user profile information

  1. Follow the instructions in Start profile synchronization manually (SharePoint Server 2010) (https://go.microsoft.com/fwlink/?LinkID=201163) to synchronize user profile information between Active Directory Domain Services (AD DS) and SharePoint Server 2010.

    Configure the following:

    1. Verify that you have the following administrative credentials:

      • You must be a member of the Farm Administrators group or administrator of the User Profile Service Application.
    2. On the User Profile Service Application page, in the Synchronization section, click Start Profile Synchronization.

    3. On the Start Profile Synchronization page, select whether you want to perform an incremental or full synchronization, and then click OK.