Hello Community!

Here are the steps to resolve the following error messages being received in Integration Manager:

“The provider could not determine the Object value. For example, the row was just created, the default for the Object column was not available, and the consumer had not yet set a new Object value.”

"Unable to cast object of type 'System.String' to type 'System.Byte[]'

To resolve this error message you can try the following steps after making a backup of your Integration Manager Database:

A.      Compact and Repair the Integration Manager Database using Access.

  1. Open Microsoft Access on the workstation. 
  2. Point to File and select Open. 
  3. Locate your integration database and select Open. You may have to change the file type to ‘All Types’ to see the integration database. 
  4. Use one of the following according to your Office Version: Access 2000, 2002 & 2003 Click Tools, point to Database Utilities and select Compact and Repair Database Access 2007 Click the Microsoft Office Button, point to Manage, and then, under Manage this database, click Compact and Repair Database.  For Access 2010 click the Database Tools tab and in the toolbar click the Compact and Repair Database button.
  5. Exit Access and then open Integration Manager to see whether the issue continues.

B.      Repair both IM and Dynamics GP installations.

  1. Do this by going to Start | Control Panel | Programs and Features.
  2. Then right click on Integration Manager for Dynamics GP and click change and then click repair. 
  3. This repairs Integration Manager.
  4. Do the same steps for Dynamics GP, right click change and then click repair. 
  5. This repairs GP.
  6. Open Integration Manager to see if the issue continues.

C.      Convert their Integration Manager Database using the following steps.

  1. Open Integration Manager using your old IMD file.
  2. Click Tools > Convert Database.
  3. Click the Convert Database Button, this will run the process.
  4. You will then have a new, converted IM Database named Converted_XXXX.IMD (XXXX is the original name of your old IM Database).
  5. The converted IM Database will be saved in the same location as the old IM Database.
  6. There will also be a Converted_XXXX.IMD.log file in the same location that will have more details regarding what converted.
  7. If the Conversion Result is “Invalid Format”, most likely that integration will need to be deleted, recreated or edited.
  8. Next click Tools, Options. Change the path here to point to the new converted database you just created.
  9. Close and restart Integration Manager.
  10. Reopen Integration Manager; you will be pointing to your new converted database now.
  11. See if the issue continues.

D.      Create a new, blank Integration Manager database using Integration Manager. 

  1. This is done by going to Tools, Create Database within Integration Manager.
  2. When this dialogue box opens, click the button to the right of the text field; this will allow you to choose the folder to create the new database in.
  3. Use the filename field to name the new database. NOTE: Be sure to include the file extension when entering the filename.
  4. Click Save and you will see the full path and filename listed in the Create New Database window.
  5. Click Create.
  6. Next click Tools, Options. Change the path here to point to the new database you just created.
  7. Close and restart Integration Manager.
  8. Reopen Integration Manager; you will be pointing to your new database now.
  9. Click File, Import Integrations to import the integrations you wish to save from your old database.
  10. See if the issue continues.