Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. Error message in eConnect for Microsoft Dynamics GP: "Error Number = 3761 Record already exists, cannot insert"

Error message in eConnect for Microsoft Dynamics GP: "Error Number = 3761 Record already exists, cannot insert"

SYMPTOMS

When you try to use eConnect to pass in a transactional document, eConnect for Microsoft Dynamics GP logs the following error message:

Error Number = 3761
"Record already exists, cannot insert"

This problem occurs if multidimensional analysis (MDA) is not registered.

CAUSE

This problem occurs because MDA data exists in the company database. This can occur when the Registration window is used to turn off MDA after transactions have already been created that contain MDA records.

RESOLUTION

To resolve this problem, follow these steps:
1. Make a backup of the company database.
2.

Start the Support Administrator Console, Microsoft SQL Query Analyzer, or Microsoft SQL Server Management Studio. To do this, use one of the following methods, depending on the program that you are using.

• SQL Server Desktop Engine (also known as MSDE 2000): Start the Support Administrator Console. To do this, click Start , click All Programs , click Microsoft Administrator Console , and then click Support Administrator Console .
• SQL Server 2000: Start SQL Query Analyzer . To do this, click Start , click All Programs , click Microsoft SQL Server , and then click Query Analyzer .
• SQL Server 2005: Start SQL Server Management Studio . To do this, click Start , click All Programs , click Microsoft SQL Server 2005 , and then click SQL Server Management Studio .



     
3. Run the following SQL statements against the company database: 
delete DTA00100
delete DTA00200
delete DTA00300
delete DTA00301
delete DTA00700
delete DTA10100
delete DTA10200

↑ Back to the top

Keywords: kb, kbnosurvey, kberrmsg, kbinfo, kbprb, kbtshoot, kbMBSPartner, kbMBSMigrate, BemisKB954009

↑ Back to the top

Article Info
Article ID : 954009
Revision : 1
Created on : 3/7/2017
Published on : 3/7/2017
Exists online : False
Views : 83