SiS 11.24 to SIS 11.31 Database Query Migration Error

Current environment is 11.24 and I'm migrating monitors to our new 11.31 environment.  In the 11.24 env, I've got a Database Query monitor that's running w/ no issues.  Settings are:

  • Database Connection URL: jdbc:mercury:sqlserver://<SERVERNAME>:1433;DatabaseName=<DBNAME>
  • Driver: com.mercury.jdbc.sqlserver.SQLServerDriver
  • Database user name: blank (using MS SQL Authentation
  • Database password: blank (using MS SQL Authentation
  • Query: Select count(*) from TABLEName

When I migrate that monitor to 11.31 I get the following error:

Step 1:Attempting to Locate Driver Class...
Driver Class: com.mercury.jdbc.sqlserver.SQLServerDriver LOCATED SUCCESSFULLY!

Step 2:Attempting to Load Driver Class...
Driver Class: LOADED SUCCESSFULLY!

Step 3: Attempting to Connect to Database...
***ERROR***: ***ERROR***:
Exception Message: java.lang.NoClassDefFoundError: sun/io/MalformedInputException

Tags:

  • Hello James,

    Could you please set this monitor into debug mode, in the logging options of the monitor, and send us the error.log and runmonitor.log to double check the issue.

    Mauricio Fernandez | SW Support Engineer

    SiteScope

    Mail: mauricio.fernandez.villegas@hpe.com

      

    If you find that this or any other post resolvers your issue, please be sure to mark it as an accepted solution. If you are satisfied with anyone's response please remeber to give them a KUDOS by clicking on the STAR at the bottom left of the post and show your appreciation

     

  • Here's the debug info.

    2016-03-23 07:36:03,253 [DB SQL nice_qa(1224811401/2) ] (WriterAppender.java:162) INFO  - **************************** START MONITOR RUN *****************************
    2016-03-23 07:36:03,253 [DB SQL nice_qa(1224811401/2) ] (AtomicMonitor.java:2345) DEBUG - alertDebug: cdcd0b7 'STARTING MONITOR: DB SQL nice_qa
    '
    2016-03-23 07:36:03,253 [DB SQL nice_qa(1224811401/2) ] (AtomicMonitor.java:2119) INFO  - Running the monitor DB SQL nice_qa
    2016-03-23 07:36:03,268 [DB SQL nice_qa(1224811401/2) ] (DBMonitorBase.java:440) ERROR - Database error 1, connect, /__SiteScopeRoot__/1224811401/2/: DB SQL nice_qa, java.lang.NoClassDefFoundError: sun/io/MalformedInputException, 0, null
    2016-03-23 07:36:03,268 [DB SQL nice_qa(1224811401/2) ] (AtomicMonitor.java:2074) DEBUG - alertDebug: Running own rules if not blank: ''
    2016-03-23 07:36:03,268 [DB SQL nice_qa(1224811401/2) ] (AtomicMonitor.java:2450) DEBUG - alertDebug: cdcd0b7 Running classifiers (GOOD/WARNING/ERROR/NODATA): 'checking thresholds...'
    2016-03-23 07:36:03,268 [DB SQL nice_qa(1224811401/2) ] (AtomicMonitor.java:5928) DEBUG - alertDebug: cdcd0b7 Rules Disabled?: 'false'
    2016-03-23 07:36:03,268 [DB SQL nice_qa(1224811401/2) ] (AtomicMonitor.java:5942) DEBUG - alertDebug: cdcd0b7 rule check: 1224811408 CON=DB SQL nice_qa  status != 200 error
    2016-03-23 07:36:03,268 [DB SQL nice_qa(1224811401/2) ] (AtomicMonitor.java:5948) DEBUG - alertDebug: cdcd0b7 rule match: 1224811408 CON=DB SQL nice_qa  status != 200 error
    2016-03-23 07:36:03,268 [DB SQL nice_qa(1224811401/2) ] (AtomicMonitor.java:2074) DEBUG - alertDebug: Running own rules if not blank: ''
    2016-03-23 07:36:03,284 [DB SQL nice_qa(1224811401/2) ] (AtomicMonitor.java:2074) DEBUG - alertDebug: Running own rules if not blank: ''
    2016-03-23 07:36:03,284 [DB SQL nice_qa(1224811401/2) ] (AtomicMonitor.java:2575) DEBUG - alertDebug: cdcd0b7 Running runActionRules: 'checking for alerts...'
    2016-03-23 07:36:03,284 [DB SQL nice_qa(1224811401/2) ] (AtomicMonitor.java:5502) DEBUG - alertDebug: cdcd0b7 isAlertTemporarilyDisabled?: 'false'
    2016-03-23 07:36:03,284 [DB SQL nice_qa(1224811401/2) ] (AtomicMonitor.java:5505) DEBUG - alertDebug: cdcd0b7 isAlertInDowntime?: 'false'
    2016-03-23 07:36:03,284 [DB SQL nice_qa(1224811401/2) ] (AtomicMonitor.java:2658) DEBUG - alertDebug: cdcd0b7 END OF THIS MONITOR

  • Hi All,

     

    Can we get the fix for this issue?

     

    thanks,

     

  • I'm just asking this since I ran into a similar issue myself - when you say migrating, does that mean you performed a config export on 11.24 and import into 11.31? Please do mind that custom SQL drivers do not, atleast in our case, get migrated that way.
    I'd deem it possible that you have a newer SQL driver on the old system than the one your 11.31 is running - you might want to check that.