Process Manager is VERY Slow; No Errors Received

plumbline consulting

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.

  1. Run the following against your SL application database in SQL Server Management Studio:Select * from inupdateqty_wrk
  2. If there are over 2,000 rows returned, stop Process Manager, then run the following:Truncate table inupdateqty_wrk
  3. Restart Process Manager.