How to kill system connections in CE 10?

[breixo]

Hi guys,

Does anyone know how to kill system connections in Crystal Enterprise v.10? I know how to kill user connections but I have to reboot the server every so often because the system connections reach the limit authorized by the application and nobody can logon afterwards.

 

[Turkbear]

Hi,
Connections to what?
The server(s) running the CE services ( pageserver, etc)?
The database server used for the CMS?

By killing the CMS connection(s) you risk losing or corrupting vital data that can make your system unstable or worse..

The CE stuff should be running on a separate server ( or servers) from any applications.





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[breixo]

Well, definitely not the connections to the database server used for the CMS. On Crystal Management Console > settings > metrics I see the account activity. One of them is 'System Connection' so I can see the amount of System Connections logged on. The number of system connection logged on increases up to the point in which users accounts cannot log on. What I would need is to kill those system connections logged on.I hope the explanation clarifies my problem. Any help still?

Cheers

 

[Turkbear]

Hi,
Sorry, but I have never encountered that problem..My surrent system connections are at 14 ( in the last 10 minutes they have moved between 9 and 16)and I see no limit to them set anywhere..





To Paraphrase:"The Help you get is proportional to the Help you give.."