Dynamics 365 F&O/AX Dynamics 365 CE / CRM Dynamics GP Business Central / NAV UG Dynamics SL Power Platform Fabric UG MS Copilot UG

[Sam Suire]

i”m trying to import Bank Transactions into GP with Econnect Node.  I continue to get the following error when importing.

Server was unable to process request. —> Microsoft.Dynamics.GP.eConnect.eConnectException: Violation of PRIMARY KEY constraint ‘PKCM20200’.

 Cannot insert duplicate key in object ‘dbo.CM20200’. The duplicate key value is (252573.00000).

The statement has been terminated.
Attached is the xml file we are using  any help would be greatly appreciated.  

——————————
Sam Suire
Dorado Solutions
West Chester PA
——————————

[Thomas Weyer]

Sounds like the eConnect SP found a primary key from the import XML already in the CM20200 table. Look for 252573.00000 in CM20200 and evaluate for duplicates. 

——————————
Thomas Weyer
Application Engineer III
TriMedx
Indianapolis IN
——————————
——————————————-

[Guillaume Simard]

The XML doesn’t contain any duplicate key.
The value 252573.00000 comes from the dbo.CM40102 table. 

You can check your next number by calling the following command in SQL :
   DBCC CHECKIDENT (‘dbo.CM40102’, NORESEED)
The output should be something like :
  Checking identity information: current identity value ‘252572’

If that’s the case, you could correct it by running the following :
  DECLARE @CMRECNUM numeric(19,5)

  SELECT @CMRECNUM = max(CMRECNUM) FROM CM20200

  DBCC CHECKIDENT (‘dbo.CM40102’, RESEED, @CMRECNUM)

——————————
Guillaume Simard
Negotium Technologies Inc.
Montréal QC
——————————
——————————————-