Open Forum

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 Dynamics\Integration Manager 18\Microsoft.Dynamics.GP.IntegrationManager.exe
 Report Id: df6b75db-ae02-11ed-abcc-06f66a63a338
 Faulting package full name: 
 Faulting package-relative application ID: 

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

Thought, comments?

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

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 Dynamics\Integration Manager 18\Microsoft.Dynamics.GP.IntegrationManager.exe
 Report Id: df6b75db-ae02-11ed-abcc-06f66a63a338
 Faulting package full name: 
 Faulting package-relative application ID: 

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

Thought, comments?

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

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

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

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 Dynamics\Integration Manager 18\Microsoft.Dynamics.GP.IntegrationManager.exe
 Report Id: df6b75db-ae02-11ed-abcc-06f66a63a338
 Faulting package full name: 
 Faulting package-relative application ID: 

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

Thought, comments?

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

Chris

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

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

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

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 Dynamics\Integration Manager 18\Microsoft.Dynamics.GP.IntegrationManager.exe
 Report Id: df6b75db-ae02-11ed-abcc-06f66a63a338
 Faulting package full name: 
 Faulting package-relative application ID: 

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

Thought, comments?

Yes

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

Chris

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

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

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

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 Dynamics\Integration Manager 18\Microsoft.Dynamics.GP.IntegrationManager.exe
 Report Id: df6b75db-ae02-11ed-abcc-06f66a63a338
 Faulting package full name: 
 Faulting package-relative application ID: 

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

Thought, comments?