06-01-2010 07:47 AM
I just recently upgraded from act! 2007 to Act 2009 and have run in to an issue with the reporting functionality from Act For Web.
Environment Details -
ACT! by Sage Premium 2009 (11.0) Version 18.104.22.168, Hotfix 4
Split server setup - 1 Server running the database for client users and the other server running the web front end for web users (IIS is dedicated to ACTWEB)
Both Servers have -
- Server 2003 r2 x86
- AMD Quad Core opteron processor 2.41 GHz
- 2GB of ram
When running reports directly from the primary database server i get the report preview within about 2 seconds, regardless of the report being run. However, When i run the exact same report from the web, it takes up to about 20 minutes for that report to be generated. While the report is being run from the web, i can see on the webserver that w3wp.exe is running and taking anywhere from 40% to 80% of the CPU resources, and on the sql server i can see that the sqlserver.exe service is running at about 30 to 70% for the entire duration of the report being generated.
When running the report locally, the CPU resources consumed are about half (between 15% and 30%) and the report finishes within seconds.
I have read through many post that suggest that the database may need to be reindexed and repaired for errors, but after doing so i still get the same results. I also just recently updated to HotFix4 to see if there were any fixes for my particular error, but i still get the same results.
Any insight or nudges in the right direction would be much appreciated! Let me know if there is any other information needed to aid in troubleshooting.
06-01-2010 08:02 AM
" You may be able to work around this issue by turning off the "Print Spooler" from the Services console on your web server. Note that this action will prevent the machine from being used as a print server."
This refers to servers with a 64 bit os,
06-01-2010 08:10 AM
My apologies, i forgot to mention that i have already applied that suggested fix as well, yet it had no effect on the reporting functionality.
06-03-2010 01:44 PM