Regarding the error “Error 500 - Failed to connect to reporting database. Data source rejected establishment of connection, message from server: "Too many connections"”
One more thing I notice even after increasing the connection to 600 we see the error reason being the Registry DB is taking up all the threads and they are in SLEEP status.
The Registry DB has only 7 monitors running every 30mins. Not sure why so many connections is taken up. Even if I kill the process after a second there will be a process with Calisa_registry DB. Even reducing the interactive_timeout is not effective because as soon a process is killed calisa_registry would create one more.
Release : 10.5
Component : CA Service Virtualization
Open a support case and refer to defect DE465805.