Issue: When running prepare data in sage for SQL we received this error message:

 

mceclip0.png

Cause: During the install/upgrade of Sage the tables were not setup in the database.

 

Resolution: The SO_SalesOrderDetail table had to have its “SQL: Create Table” checkbox selected in Data Dictionary Maintenance.

mceclip1.png

 

Then re-migrate and converted a third time and I am able to see all of the tables and run Prepare Data without errors.