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-
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
—————————— -
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
——————————
——————————————- -
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 SelectCurrentField = Distribution
*****************************************************
——————————
David Morinello
Senior Developer
TruckPro LLC
Cordova TN
——————————
——————————————- -
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
——————————
——————————————- -
-
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, 3 months ago 1 Member · 0 Replies -
-
0 Replies
Sorry, there were no replies found.
The discussion ‘Integration Manager 2018 Scripts causes Error 50001’ is closed to new replies.