Error: "Duplicate key value during insert of the [record name] record..." (corrupt Windows user profile)

Solution Properties

Solution ID:

225924250080807

Last Modified Date:

Mon May 02 23:33:04 UTC 2022

Taxonomy Path:

Category//Performance//Connectivity

Author:

[email protected]

Error: "Duplicate key value during insert of the [record name] record..." (corrupt Windows user profile)

Description

Cause

Corrupt Windows user profile.

How to confirm if it is a Windows profile issue:

The error occurs on one workstation and in any database.
Have the user with the issue log into another workstation using their windows profile and see if the issue follows.
Have another user log into the problem workstation with their windows profile and see if the issue can be re-created.

If the user in question is also having issues on a different machine, but a different user is not having the same issue on the problem workstation, please refer to your IT person to look into the user's windows profile.

Note: If the error occurs in one database on any workstation for any user, refer to article ID 21466 "Error: Duplicate key value during insert of the [record name] record..." (records were added via ODBC)"

Resolution

CAUTION: This solution requires advanced knowledge of Windows security and network settings. Sage isn't responsible for any issues that arise from changes to these settings. Ensure you back up all system and application databases necessary for a complete restoration. It's advisable to contact a certified consultant or your system administrator for assistance.

CAUTION: This solution needs advanced Operating System knowledge. Consult your system administrator for help. Sage isn't liable for issues caused by improper changes to the Windows Registry. Always back up your data before applying advanced solutions.

CAUTION: Sage support can't assist with third-party products, hardware, report customizations, or state and federal tax questions. Refer to our Scope of Support for more info. Contact your Sage business partner, network administrator, or accountant for assistance.
Contact your Network Administrator to create a new Windows user profile account.DocLink: Error: "Duplicate key value during insert of the [record name] record..." (records were added via ODBC)

Steps to duplicate