Performance issues with Actian Zen after upgrade (Reports, ODBC, and General Performance)

After upgrading to 24.2 or later, reports aren’t running or taking longer to run. ODBC connections from Excel, Access and other applications retrieve data slower. Application Performance is slow on clients but is normal on the server.

1. Have the user close out of Sage completely on their workstation. If this is an RDS/Terminal Server Environment, all users need to exit out of Sage.
2. Actian Performance Configuration:
   1. On the machine having the issues, go to Windows Start button, Actian Zen, Zen Control Center & Documentation.
   2. Once the window opens, click Configure Microkernel Router.
   3. This opens the Properties for Microkernel Router window.
   4. Click Performance tuning on the left.
   5. Check the box for Use Cache Engine.
   6. Click Apply, then Close.
   7. Reboot the machine.
   8. Don't reopen Sage 300 CRE when the machine loads.
3. Post PSQL Installation:
   1. Open File Explorer.
   2. Browse to \\CustomersServerName\Timberline Office\9.5\ACCOUNTING\WinInst\Prerequisites\Post PSQL Install.
   3. Right-click PostPSQLInstall.exe and select Run as administrator.
4. Test performance.

 

Note: There can be performance issues in virtual environments outside of Sage configurations. Sage is unable to assist with performance causes outside of Sage products. Contact your IT staff for assistance with these types of performance issues.

See more information on support limitations in virtual environments.