Generic Dashboard is slow to load and eventually reports a timeout error message
Problem
When opening the generic dashboard at System Settings > Dashboards > Generic Dashboard, a timeout message is displayed after an extended wait.
Solution
1. Run the attached SQL Script (written for a Jiwa version 7.0.157 database - Performance Tuning for Dashboard.sql)
2. Replace the JiwaDashboardUI.dll in the Jiwa deploy folder (default is C:\Program Files (x86)\Jiwa Financials\Jiwa 7) - the dll is contained in JiwaDashboardUI.rar. Download the rar file and unzip the included dll.
Advance SQL Programming skills required
Completing this troubleshooting article requires advanced SQL Programming ability.
Downloads
Performance Tuning for Dashboard.sql