Product: Dynamics GP (Enterprise)
Article Link: http://help.truecommerce.com/en/articles/6811490-dynamics-gp-enterprise-sql-maintenace
SQL Maintenance is a built in tool for Dynamics GP that can be used to recreate needed SQL Tables or Stored Procedures that may no longer be properly working. This can result in unexpected and strange behavior, or unusual error messages during operations that previously worked.
Sometimes after performing a new install of any of the TrueCommerce modules, a SQL Server Move, or a Dynamics GP upgrade you may run into some strange behavior such as receiving errors such as 'Unhandled script', 'Object has no reference' or 'EXCEPTION_CLASS_SCRIPT_BAD_PARAM'
These can all indicate that various Tables, or Stored Procedures are missing. Running the SQL Maintenance utility can solve these issues
WARNING
While this is a recommendation - TrueCommerce is not responsible for your company's data and incorrectly running this operation could erase your data. Always perform a Backup of your company database and always have someone from your system's administration, IT department, or VAR run these operations.
Running SQL Maintenance
In order to run SQL Maintenance you'll need to be logged in as your System Admin (sa) user into Dynamics GP to ensure the scripts are executed properly, as more often than not the reason they failed during the initial setup was due to lack of permissions.
WARNING
NEVER SELECT DROP TABLE OR DROP AUTO PROCEDURE - THIS WILL RESULT IN A LOSS OF YOUR DATA
Launch SQL Maintenance
Navigate: Microsoft Dynamics GP → Maintenance → SQL
Sales Order Process (SOP) Module
Set Database: Select your Dynamics GP Company
Set Product: EDI for Dynamics
Select All: (Ctrl+A) Procedures
Check: Create Table & Create Auto Procedure
Select: Process
SOP Module Maintenance
Purchase Order Process (POP) Module
Set Database: Select your Dynamics GP Company
Set Product: EDI POP for Dynamics
Select All: (Ctrl+A) Procedures
Check: Create Table & Create Auto Procedure
Select: Process
POP Module Maintenance
Warehouse (WHS) Module
Set Database: Select your Dynamics GP Company
Set Product: EDI Warehouse Integration
Select All: (Ctrl+A) Procedures
Check: Create Table & Create Auto Procedure
Select: Process
WHS Module Maintenance
Processing
The System will begin creating any missing Tables or Procedures - once it's complete run the problematic operation again (while in sa) to ensure the issue has been resolved before switching back to your regular user.
rev 12/9/22