Highlighted
Super Contributor.
Super Contributor.
1395 views

DB Query monitor error after upgrade to 11.31

Jump to solution

We just migrated from 11.30 to 11.31 today and after the upgrade, all DB query monitors are failing with the following error:

The following properties had verification errors:
Failed to load driver sun.jdbc.odbc.JdbcOdbcDriver. Please check if the driver exists in the SiteScope class path. Refer to SiteScope documentation and/or Release Notes for further information.

I verified the files still exist in \SiteScope\java\lib\ext

Labels (2)
0 Likes
1 Solution

Accepted Solutions
Highlighted
Super Contributor.
Super Contributor.

Turn out SiteScope uses Java 8.

The odbc bridge was included in the java Runtime, starting from java 8 Oracle no longer includes the odbc driver within their architecture:  http://stackoverflow.com/questions/14229072/removal-of-jdbc-odbc-bridge-in-java-8 ,

Here is what I did to resolve this.

1. Download sqljdbc_6.0.7130.100_enu.exe from https://www.microsoft.com/en-us/download/details.aspx?id=11774
2. Stop SiteScope
3. Copy sqljdbc_auth.dll to \SiteScope\bin
4. Copy sqljdbc4.jar to \SiteScope\WEB-INF\lib and remove sqljdbc.jar from the same location
5. Start Sitescope
6. Configure Db monitors as such:
driver class "com.microsoft.sqlserver.jdbc.SQLServerDriver"
connnectionURL " jdbc:sqlserver://%dbservername%:%dbport%;databaseName=%dbname%;integratedSecurity=true;"

View solution in original post

4 Replies
Highlighted
Absent Member.. Absent Member..
Absent Member..

Do you try replacing the drivers? maybe with the upgrade the files get corrupted.

0 Likes
Highlighted
Super Contributor.
Super Contributor.

Turn out SiteScope uses Java 8.

The odbc bridge was included in the java Runtime, starting from java 8 Oracle no longer includes the odbc driver within their architecture:  http://stackoverflow.com/questions/14229072/removal-of-jdbc-odbc-bridge-in-java-8 ,

Here is what I did to resolve this.

1. Download sqljdbc_6.0.7130.100_enu.exe from https://www.microsoft.com/en-us/download/details.aspx?id=11774
2. Stop SiteScope
3. Copy sqljdbc_auth.dll to \SiteScope\bin
4. Copy sqljdbc4.jar to \SiteScope\WEB-INF\lib and remove sqljdbc.jar from the same location
5. Start Sitescope
6. Configure Db monitors as such:
driver class "com.microsoft.sqlserver.jdbc.SQLServerDriver"
connnectionURL " jdbc:sqlserver://%dbservername%:%dbport%;databaseName=%dbname%;integratedSecurity=true;"

View solution in original post

Highlighted
Trusted Contributor.. Trusted Contributor..
Trusted Contributor..

 We have the same issues in our sitescope 11.32 where we are unable to run database querry monitors;

Our scenario is;

1. Freshly installed sitescope 11.32 on windows 2008 R2 64 bit server

2. And created a SYSTEM DSN in sitescope servers ODBC data sources by name CompanyOrders . (this is a MS SQL Database)

3. Now trying to create a database query monitors with following parameters;

Database connection URL : jdbc:odbc: CompanyOrders

Database driver : sun.jdbc.odbc.JdbcOdbcDriver

And a Query

But this is not connecting getting the same error “Failed to load driver sun.jdbc.odbc.JdbcOdbcDriver. Please check if the driver exists in the SiteScope class path. Refer to SiteScope documentation and/or Release Notes for further information”” But the thing is that same setup was working in sitescope 11.30 and 11.24 earlier. Went through many options still could not figure out the issue. Can you please help us on this?

Regards

Roopesh Shetty

0 Likes
Highlighted
Micro Focus Frequent Contributor
Micro Focus Frequent Contributor

The solution and root cause about this behaviour for this issue is already provided by ericmorris .

If you check the update before you it explains why this happens and how to resolve it. There is no other option as this is outside SiteScope

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.