A "Violation of PRIMARY KEY constraint 'PK_Delegates'." Error Occurs When Configuring Delegates in Agenda Manager 8.

March 5, 2010 | KB: 1012537
Agenda Manager 8

Summary

When assigning delegates, you may receive an error similar to the following error message:

    AMServer.User.1 error '80040e2f'

    Violation of PRIMARY KEY constraint 'PK_Delegates'. Cannot insert duplicate key in object 'dbo.Delegates'.

    /amserver/ConfigurePersonalDelegates.asp, line 43

Another symptom of the same root issue may prevent the Configure Delegates page from properly loading. When browsing to the Configure Delegates page, you may receive the following message:

    Message: 'null' is null or not an object
    Line: 17
    Char: 14
    Code: 0
    URI: http://YourAgendaManagerSite/amserver/ConfigureDelegates.asp

Cause

This issue can occur when the Configure Delegates page encounters the ASP script timeout limit.

Workaround

Increase the ASP script timeout setting in IIS for Agenda Manager Server.

To increase the ASP script timeout setting in IIS 6

  1. Load the Internet Information Services (IIS) Manager.
  2. Expand the Default Web Site and select AMServer.
  3. From the Actions menu, select Properties.
  4. On the Virtual Directory tab, click Configuration.
  5. In the Application Configuration dialog box, click the Options tab and modify the ASP script timeout setting. By default, the value is set at 90 seconds.
  6. Click OK to save your change.

To increase the ASP script timeout setting in IIS 7

  1. Load the Internet Information Services (IIS) Manager.
  2. Expand the Default Web Site and select AMServer.
  3. Double-click the ASP item in the Features View pane.
  4. In the Behavior section, expand Limits Properties, and increase the value for the Script Time-out setting. By default, the value is set to 1 minute and 30 seconds.
  5. After modifying the value, click Apply in the Actions pane.