Error message in Integration Manager for Microsoft Dynamics GP: "Input string was not in a correct format"

Article ID: 2012471 - View products that this article applies to.
Expand all | Collapse all

Symptoms

You receive the error message "Input string was not in a correct format."  in the following scenarios

Scenario 1

When you run an integration in Integration Manager for Microsoft Dynamics GP that uses the eConnect Destination adapters.

Scenario 2 

When you do not have sufficient permissions on the machine running the integration

Cause

Scenario 1

This error occurs after you upgrade to Integration Manager for Microsoft Dynamics GP 2010 or for Microsoft Dynamics GP 10.0 from an earlier version and the Shift Decimal Point property on a numeric field did not upgrade correctly and leaves the value blank.  This can occur on any integration that uses an eConnect destination adapter that contains a numeric field that has the Shift Decimal Point property.  For example the Debit Amount, Credit Amount or Quantity fields.

Scenario 2

When you install Integration Manager, you did not install as an Administrator and run the first integration.  This allows the required .xml files to get created on the machine.

Resolution

Scenario 1

To resolve this problem, open the Destination Mapping window and check the Debit Amount, Credit Amount and Quantity fields for the destination adapter that you are using.  Select one field at a time and look in the properties window in the lower-left corner of the Destination Mapping window.  Make sure that the Shift Decimal Point property is not blank.  In most cases the value for this property is zero ('0').  If you find a field where this property is blank, type a zero and then save the integration.

Scenario 2

To resolve this problem, log into the machine as Administrator and run the integration.  Once the integration is run the first time, you can run integrations as another user.  The user must have full control to the following registry keys:

Warning Serious problems might occur if you modify the registry incorrectly by using Registry Editor or by using another method. These problems might require that you reinstall the operating system. Microsoft cannot guarantee that these problems can be solved. Modify the registry at your own risk. 

1. Click Start, click Run, type Regedt32 in the Open dialog box, and then click OK. This will open Registry Editor.

2. The four registry keys that must have the security changed are:


32-bit

HKEY_CLASSES_ROOT\Interface
HKEY_CLASSES_ROOT\CLSID
HKEY_CLASSES_ROOT\TypeLib
HKEY_LOCAL_MACHINE\Software\Classes\CLSID
 
64-bit
 
HKEY_CLASSES_ROOT\Wow6432Node\Interface
HKEY_CLASSES_ROOT\ Wow6432Node\CLSID
HKEY_CLASSES_ROOT\ Wow6432Node\TypeLib
HKEY_LOCAL_MACHINE\Software\Classes\Wow6432Node\CLSID
HKEY_LOCAL_MACHINE\Software\Classes\CLSID


3. Select one of the folders listed in step 2, click Security from the menu and then click Permissions.

4. Make sure the user groups that use Integration Manager have Read and Full Control marked.

5. Repeat steps 3 and 4 for all four registry entries listed in step 2.

Note This is a "FAST PUBLISH" article created directly from within the Microsoft support organization. The information contained herein is provided as-is in response to emerging issues. As a result of the speed in making it available, the materials may include typographical errors and may be revised at any time without notice. See Terms of Use for other considerations.

Properties

Article ID: 2012471 - Last Review: August 4, 2011 - Revision: 10.0
APPLIES TO
  • Microsoft Dynamics GP 2010
  • Microsoft Dynamics GP 10.0, when used with:
    • Integration Manager
Keywords: 
kbmbsmigrate KB2012471

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com