Integration Manager 2018 Scripts causes Error 50001

  • Integration Manager 2018 Scripts causes Error 50001

    Posted by David Morinello on February 16, 2023 at 9:27 am
    • David Morinello

      Member

      February 16, 2023 at 9:27 AM

      I have been moving Integration Manager 2013 integrations to 2018 and have one pair of integrations that hang in 2018.  The same Integrations work ok in 2013

      I then built them from scratch and they still fail. I uninstalled IM and reinstalled, same issue.

      GP 2018 R2 18.00.0727

      I narrowed it down to a script in Mapping. If the script exists, it fails. No script it works but the expected custom distributions are incorrect. 

      Event Log

      *****************************

      The program Microsoft.Dynamics.GP.IntegrationManager.exe version 18.0.641.0 stopped interacting with Windows and was closed. To see if more information about the problem is available, check the problem history in the Security and Maintenance control panel.
       Process ID: e20
       Start Time: 01d9420f758e77dd
       Termination Time: 4294967295
       Application Path: C:Program Files (x86)Microsoft DynamicsIntegration Manager 18Microsoft.Dynamics.GP.IntegrationManager.exe
       Report Id: df6b75db-ae02-11ed-abcc-06f66a63a338
       Faulting package full name: 
       Faulting package-relative application ID: 

      *****************************

      Thought, comments?

      ——————————
      David Morinello
      Senior Developer
      TruckPro LLC
      Cordova TN
      ——————————

    • Chris Donnelly

      Member

      February 17, 2023 at 8:10 AM

      Can you share the contents of the script?  I bet there is a connection to another dataset that doesn’t match your GP2018 data (i.e. your GP2013 data).

      Chris

      ——————————
      Chris Donnelly
      Director of Business Applications
      Healthmark Industries
      ——————————
      ——————————————-

    • David Morinello

      Member

      February 17, 2023 at 8:28 AM

      Below is the Script for the Debit Integration. 

      The Credit script is the same except for the first line.

      Account = trim(SourceFields(“CM Receivables-Header.GL Account”))
      Store = left(SourceFields(“CM Receivables-Header.Customer ID”),3)
      Distribution = “”

      ***Debit  Distibution Script*********************************************************************************

      Account = trim(SourceFields(“_DM Receivables-Header.GL Account”))
      Store = left(SourceFields(“_DM Receivables-Header.Customer ID”),3)
      Distribution = “”

      Select Case Account
      Case “1INT”
          Distribution = “800-000-13400”
      Case “BDR”
          Distribution = Store + “-000-13410”
      Case “BDRF”
          Distribution = Store + “-000-13410”
      Case “BDWO5”
          Distribution = Store + “-000-13410”
      Case “BDWO”
          Distribution = Store + “-000-13410”
      Case “BDWOC”
          Distribution = Store + “-000-13410”
      Case “BDWOB”
          Distribution = Store + “-000-13410”
      Case “BDWOD”
          Distribution = Store + “-000-13410”
      Case “CAR”
          Distribution = Store + “-000-10000”
      Case “OS”
          Distribution = Store + “-010-51020”
      Case “CCRA”
          Distribution = “800-000-10311”
      Case “CCRD”
          Distribution = “800-000-10312”
      Case “CCRVM”
          Distribution = “800-000-10313”
      Case “CHGB”
          Distribution = “800-000-13404”
      Case “CHGBWO”
          Distribution = Store + “-000-13410”
      Case “CODR”
          Distribution = Store + “-000-13410”
      Case “CODWO”
          Distribution = Store + “-000-13410”
      Case “CE”
          Distribution = Store + “-000-13410”
      Case “CORER”
          Distribution = Store + “-000-13410”
      Case “CORWO”
          Distribution = Store + “-000-13410”
      Case “CW”
          Distribution = Store + “-000-13410”
      Case “DC”
          Distribution = Store + “-010-44707”
      Case “DELC”
          Distribution = Store + “-000-13402”
      Case “DELR”
          Distribution = Store + “-000-13402”
      Case “FR”
          Distribution = Store + “-010-54750”
      Case “FSC”
          Distribution = Store + “-010-38100”
      Case “IMPRT”
          Distribution = “800-000-10215”
      Case “INV”
          Distribution = Store + “-000-14200”
      Case “MC”
          Distribution = Store + “-000-13400”
      Case “NSF”
          Distribution = “800-000-13405”
      Case “NSFR”
          Distribution = Store + “-000-13410”
      Case “NSFSC”
          Distribution = Store + “-000-13410”
      Case “NSFWO”
          Distribution = Store + “-000-13410”
      Case “SC”
          Distribution = “800-870-51500”
      Case “SCR”
          Distribution = Store + “-000-13401”
      Case “TE”
          Distribution = Store + “-000-13400”
      Case “TX”
          Distribution = Store + “-000-23600”
      Case “ZOFF”
          Distribution = “800-000-13400”
      Case “ZSR”
          Distribution = “800-000-10431”
      Case Else
          Distribution = Store + “-000-13410”
      End Select

      CurrentField = Distribution

      *****************************************************

      ——————————
      David Morinello
      Senior Developer
      TruckPro LLC
      Cordova TN
      ——————————
      ——————————————-

    • Chris Donnelly

      Member

      February 17, 2023 at 8:52 AM

      Hmmm.  No connections.  Are your input files still named CM Receivables-Header and _DM Receivables-Header?

      Chris

      ——————————
      Chris Donnelly
      Director of Business Applications
      Healthmark Industries
      ——————————
      ——————————————-

    • David Morinello

      Member

      February 17, 2023 at 12:28 PM

      Yes

      ——————————
      David Morinello
      Senior Developer
      TruckPro LLC
      Cordova TN
      ——————————
      ——————————————-

    • Chris Donnelly

      Member

      February 17, 2023 at 12:47 PM

      Cool.  Next thing…   look at the file definitions (ODBC on the machine?)…   Is the column named “Account” defined as a numeric?  It should be defined as a string.

      Chris

      ——————————
      Chris Donnelly
      Director of Business Applications
      Healthmark Industries
      ——————————
      ——————————————-

    David Morinello replied 1 year 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!