Error:
You receive the following error after installing SmartFill.
Unhandled database exception: A get/change first operation on table 'SF_Object_MSTR' failed accessing SQL data. Number of results columns doesnt match table definition. EXCEPTION_CLASS_DB DB_ERR_SQL_DATA_ACCESS_ERR
Cause:
This error can occur when an incorrect version of SmartFill is installed with Dynamics GP. For example, installing SmartFill build for GP2013 in your GP2015 environment.
Resolution:
- Download the correct SmartFill build from https://www.rocktonsoftware.com/gp/resources/product-downloads and copy the .zip file contents into your GP application folder.
- Click Yes to replace any files that already exist.
- Launch GP and log in as ‘sa’.
- Click Yes to install new code
- When the SmartFill wizard window opens, click Cancel.
- Open the SQL Maintenance window under Maintenance | SQL.
- In the Database field, select Dynamics.
- In the Product field, select SmartFill.
- Select all tables (including ones ending in Old) and mark the Drop Table and Drop Auto Procedure.
- Click Process.
- Select all tables (including ones ending in Old) and check the Create Table and Create Auto Procedure.
- Click Process.
- Close the SQL Maintenance window.
- Log out of GP and log back in.
- Go to Dynamics GP | Tools | Setup | SmartFill | SmartFill Setup window.
- Click Install/Upgrade SmartFill from the Setup tab.
It should now install without errors.