Planning was somehow interrupted and the temp tables were not cleared and won’t clear.
NOTE: Confirm all users are out of SL and that recent SQL backups of the SL databases exist before proceeding.
- Run the following against your SL application database in SQL Server Management Studio:Select * from inupdateqty_wrk
- If there are over 2,000 rows returned, stop Process Manager, then run the following:Truncate table inupdateqty_wrk
- Restart Process Manager.