Error: Unhandled database exception: A get/change first operation on table ‘SF_Object_MSTR_OLD’ failed accessing SQL data. Number of results columns doesnt match table definition

Error:

 When upgrading from Dynamics GP 10 to Dynamics GP 2013, the following error appears:

Unhandled database exception: A get/change first operation on table ‘SF_Object_MSTR_OLD’ failed accessing SQL data. Number of results columns doesnt match table definition.

Cause:

There are some table columns changes between Dynamics GP 10.0 and Dynamics GP 2013 in SmartFill. This issue has been documented as a software bug.  

Resolution:

This bug is currently not resolved. In the meantime, here are the steps to resolve this error message and successfully install SmartFill:

Make a complete restorable backup of your DYNAMICS database and GP 2013 application folder. The usual path is C:\Program Files (x86)\Microsoft Dynamics\GP2013.

  1. In GP, open the SmartFill Objects window and select all Objects.
  2. Click Actions and mark Export Objects.
  3. Download the SmartFill for Microsoft Dynamics GP 2013 build from https://www.rocktonsoftware.com/gp/resources/product-downloads.
  4. Copy the *.zip file contents into your Dynamics GP 2013 application folder and click Yes to replace any existing files.
  5. Start GP by right clicking on the GP 2013 shortcut and then choose Run as Administrator.
  6. Click Yes when prompted with a message similar to this: New code must be included in the :C:Programs Files (x86(/Microsoft Dynamics/Gp2013/Dynamics.set dictionary. Do you wish to include new code now?
  7. Click OK when prompted with this message: If this is your first workstation install of SmartFill, you must log in as system administrator. Also make sure you properly install SmartFill Objects according to the documentation.
  8. Log in as sa.
  9. When the SmartFill Install Welcome window opens, click Cancel.
  10. Go to Microsoft Dynamics GP | Maintenance | SQL.
  11. Select the following options:
    1. Database: DYNAMICS.
    2. Product: SmartFill.
  12. Mark the following checkboxes:
    1. Drop Table.
    2. Create Table.
    3. Drop Auto Procedure.
    4. Create Auto Procedure.
  13. Select all of the tables (Ctrl + A) and then click Process.
  14. Click Yes when prompted with this message: You have selected to drop tables; this will delete any data in them. Are you sure you want to continue?
  15. Close SQL Maintenance window.
  16. Close GP.
  17. Start GP by right clicking on the GP 2013 shortcut and then choose Run as Administrator.
  18. Go to Microsoft Dynamics GP | Tools | Setup | SmartFill | SmartFill Setup.
  19. In the SmartFill Setup window, click Install/Upgrade SmartFill and run the SmartFill Installation Wizard.
  20. In the SmartFill Objects window, click Import and import the SmartFill Objects.

Note:

Ensure you have the full version of Microsoft .NET 4 or higher version installed. You can look in your Programs for Microsoft .NET 4.0 Extended and Client Profile. If you see both, you have the full version installed. If you do not see both, then install the full version of Microsoft .NET Framework 4. You can download it for free at https://www.microsoft.com/en-us/download/details.aspx?id=17851.