I received the error "ME_Enhanced_Security failed accessing SQL data...Number of results columns doesn't match table definition." when running the table conversion upgrade.

June 19, 2019 482 162

To resolve the issue you can drop and rebuild the Enhanced Security table and its Stored Procedure using the SQL Maintenance screen. Complete the following steps:

1.       Log in to GP as "sa" and select Microsoft Dynamics GP > Maintenance > SQL. On the SQL Maintenance screen, select the company database.

2.       Set the Product   field to "Mekorma MICR" and select the Mekorma MICR Enhanced  Security   table from the list. 

3.       Check the Drop Table, Create Table, Drop Auto Procedure  , and  Create Auto Procedure   options and click  Process.

4.       Re-run the table maintenance update for Mekorma.

Important Note: After recreating the table, you will need to go to the Mekorma MICR Security screen and reconfigure your security settings. We strongly recommend only database administrators apply this information.