Welcome Serena Central users! CLICK HERE
The migration of the Serena Central community is currently underway. Be sure to read THIS MESSAGE to get your new login set up to access your account.
Highlighted
WilliamWalteros Absent Member.
Absent Member.
2375 views

Sitescope - Database Query Monitor - Too many connections

Jump to solution

Hi.

 

We are experience some problems with the Database Query monitor when running a query against a MS SQL Server.

In some of the monitor execution the result is "connect error, Too many connections".

I attach a document with the configuration and the error.

Please suggest me a solution. I'll apreciate it.

 

Sitescope 11.23 on Windows Server 2008 R2

Labels (1)
0 Likes
1 Solution

Accepted Solutions
Gunnar_L Outstanding Contributor.
Outstanding Contributor.

Re: Sitescope - Database Query Monitor - Too many connections

Jump to solution

William,

 

I know that this connection is working but would you please use the SQL driver instead the Inet driver?

 

You have to use this in the driver string: com.microsoft.sqlserver.jdbc.SQLServerDriver

 

And this in the URL info:

 

jdbc:sqlserver://<database_server>:<posrt>;databaseName=<database_name>;

 

Please request the JDBC driver to your DBA and place it in SiteScope\WEB-INF\lib

 

Best Regards,

 

Gunnar López
Micro Focus Support
If you find that this or any post resolves your issue, please be sure to mark it as an accepted solution.

View solution in original post

0 Likes
5 Replies
Gunnar_L Outstanding Contributor.
Outstanding Contributor.

Re: Sitescope - Database Query Monitor - Too many connections

Jump to solution

Hi William,

 

Would you please use the DB Connection tool and post the output here?

 

Best Regards,

 

Gunnar López
Micro Focus Support
If you find that this or any post resolves your issue, please be sure to mark it as an accepted solution.
0 Likes
WilliamWalteros Absent Member.
Absent Member.

Re: Sitescope - Database Query Monitor - Too many connections

Jump to solution

Hi Gunnar,

 

Please find attached a screen - using DB Connection Tool.

 

Thanks,

 

William

0 Likes
Established Member.. kenneth.gonzale
Established Member..

Re: Sitescope - Database Query Monitor - Too many connections

Jump to solution
What about checking on MS SQL side? Maybe you reached the max connections allowed via JDBC
Kenneth Gonzalez
HP Support

If you find that this or any post resolves your issue, please be sure to mark it as an accepted solution.

If you haven’t tried it yet, come and join us in our entitled forums at Support Customer Forums
0 Likes
Gunnar_L Outstanding Contributor.
Outstanding Contributor.

Re: Sitescope - Database Query Monitor - Too many connections

Jump to solution

William,

 

I know that this connection is working but would you please use the SQL driver instead the Inet driver?

 

You have to use this in the driver string: com.microsoft.sqlserver.jdbc.SQLServerDriver

 

And this in the URL info:

 

jdbc:sqlserver://<database_server>:<posrt>;databaseName=<database_name>;

 

Please request the JDBC driver to your DBA and place it in SiteScope\WEB-INF\lib

 

Best Regards,

 

Gunnar López
Micro Focus Support
If you find that this or any post resolves your issue, please be sure to mark it as an accepted solution.

View solution in original post

0 Likes
WilliamWalteros Absent Member.
Absent Member.

Re: Sitescope - Database Query Monitor - Too many connections

Jump to solution

Gunnar!!

I used SQL driver instead the Inet driver and for any reason it works!

Now 'connection error: too many connections' no longer appear.

Thank you so much.

William.

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.