Econnect Integration for Bank Transactions

  • Econnect Integration for Bank Transactions

    Posted by DSC Communities on January 18, 2017 at 2:52 pm
    • Sam Suire


      January 18, 2017 at 2:52 PM

      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


      January 19, 2017 at 8:19 AM

      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
      Indianapolis IN

    • Guillaume Simard


      January 19, 2017 at 9:27 AM

      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)



      Guillaume Simard
      Negotium Technologies Inc.
      Montréal QC

    DSC Communities replied 6 years, 8 months ago 1 Member · 0 Replies
  • 0 Replies

Sorry, there were no replies found.

Log in to reply.

Welcome to our new site!

Here you will find a wealth of information created for people  that are on a mission to redefine business models with cloud techinologies, AI, automation, low code / no code applications, data, security & more to compete in the Acceleration Economy!