General discussion
Thread display: Collapse - |
All Comments
Start or search
Create a new discussion
If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.
Citrix and Database Connections on 2003 Server
When clients try to connect to the citrix server they have a problem executing the application attached to the database. This problem only begins happening after maybe 4 hours sometimes clients can connect throughout the day (8 - 5) and about the last hour or so start having issues where clients are kicked out of the application. The issue is not a connection to the citrix server because at any point during the day the clients can connect to the citrix server but the execution of the application associated with the Dbase is the problem that will not start. If I reboot the server (Citrix) everyone can connect again no problem for again the same period of time if all users are logging in. I have 2 servers and about 50 users split between the two. If users were to connect to the Citrix boxes during this problem time all other applications will run lightning speed but this particular app. with the Pervasive SQL dbase will not. If will not kick or lock the citrix users all at one time but almost one by one. The systems are clean from any virus or spyware, they are firewalled to only allow necessary ports from the outside. If I try to run the application locally on the Citrix machines during this problematic time the application still will not open or will take forever to even open (timed at 14 minutes on one instance). If I start logging people off the server one by one the application will eventually come up faster. Meanwhile as I mentioned the servers are more than capable of handling the load ... my cpu using when everyone is logged into the server is about 7 to 15% (max) and the 15 is when I have more than half on one machine. I have work with the application designer (Mom and Pop type company) but their programmers have only concluded that the problem is with something holding up the database from starting. Citrix says it is a Pervasive issue and Pervasive wants to point fingers at Citrix (typical). The servers are running CA antivirus and I have made the application exempt for the AV to prevent scanning of the app and the dbase. All the updates are done on the servers so everything is up to date there. The version of Pervasive is 8. The server also have static addresses assigned on the same private network. Hopefully this is enough info for anyone who might have experienced a similar incident and has any ideas. Thanks guys and gals.