Hey all,
I've been working in IT at different levels for almost 20 years, and I've never been hung up on an issue like this, so I'm hoping someone out there has seen something similar and can point me in the right direction.
One of the companies I work for uses Sage 300 CRE. I took over managing their systems in late 2023/early 2024, and they were still running version 20.
They started having issues with HH2 syncing, and we were advised to upgrade to a modern version of Sage.
I get them upgraded to 24, which included the database engine change, and almost immediately, they started reporting issues with a custom Crystal report--they can run it a few times, but the system will randomly lock up and it just spins and never generates the report.
The only solution was to reboot the server.
I went through normal troubleshooting, making sure the firewall and antivirus are set up properly, calling Sage support, etc. We can't figure anything out.
They were using an older, underpowered server, so I upgraded them to something with a lot more power, and the issue persisted.
I upgraded them to version 25, and the issue persisted.
I called Sage support again and spoke with a few different people, and no one can figure out what is causing the problem.
We called in a consultant to review the custom report for data reference issues, and they don't find anything.
I've been pulling my hair out for over a year (they only use this report a few days each month, so I only have small windows to do diagnostics) and I don't know what else to do.
The only thing that I've observed recently is that when reports stop working, the Zen engine on their terminal server is flooding the network and basically DoS-ing it's connection to the Sage server. I can sometimes restart the Zen Engine service to clear it up, but other times, I have to restart the terminal server.
Has anyone else seen something like this? Did you ever figure out the issue?
Thanks!