The Orchestrate system is running slowly with many users have been complaining about the length of time to do imports and saving the plan.
Task planner responding slowly to searches for specific tasks.
Taking ages to open plan or save the plan, stuck with the not responding message.
If the overall application or using the plan is taking too long, the functionality has been enhanced in Orchestrate version 7.77.
If your plan is taking too long to open, the functionality has been enhanced in Orchestrate version 7.77 hotfix 10.
If saving the plan is taking too long, the functionality has been enhanced in Orchestrate version 7.80.
Orchestrate version 7.80 hotfix 10 contains enhancements to prevent transactions becoming uncommittable when another database operation would occur that is trying to use the same connection. This prevents blocking of transactions within the database.
Orchestrate version 7.80 hotfix 20 contains an enhancement to speed up full shuffling when planning works orders. This prevents new transactions to attempt using already-allocated connections, resulting in blocking.
An enhancement has been made to skip full shuffling when planning works orders. Unnecessary checks removed when recalculating KPIs and Plots. This enhancement will be part of Orchestrate version 7.81. This will improve plan and application performance significantly. Please upgrade to this version or above.
If the issue continues to occur, it is likely to be an environmental issue causing the SQL server to run slowly or network speed to run slowly e.g. missing Windows or Security updates.
Initial steps users can take to resolve this issue are (you may need to speak to their IT department for assistance):
Enquire if any changes have be made to the SQL server prior to the system running slowly (New Antivirus/Firewall, changes to an existing Antivirus/Firewall. Windows update etc).
Test if undoing any potential changes speeds up Orchestrate.
Restart the SQL Server Orchestrate Service on the SQL server.
Check the Network speed.
Archive all completed tasks or within a specific date range.
Upgrade to the latest version of Orchestrate
Delete old plans from Plan Explorer sub-directories e.g. Saved Plans (select file, plan explorer).
If you use the Demand Planner to look at the Stock Plot, then change the Look Ahead Day to something smaller (like 30 days) which will make the plan load a lot faster.
Create views with less resources in them, otherwise Orchestrate needs to load everything into memory (hide some of the resources if they aren't necessarily required to show).
Move Orchestrate Virtual Machine server to SSD hard drives.
Install the full SQL server Engine and not the Express Edition.
If you are still having performance issues, please raise a new case online and reference the title of this article.