Uploaded image for project: 'i2b2 Core Software'
  1. i2b2 Core Software
  2. CORE-384

"PM Error reported by CRC web Service Session Invalid" error

    XMLWordPrintable

Details

    • Improvement
    • Status: New
    • Major
    • Resolution: Unresolved
    • 1.7.12
    • None
    • Install
    • None
    • Amazon Linux 2
    • Rank:
      0|s000co:
    • Session Timeout
    • SQL Server
    • All Web Browsers

    Description

      Hello all

      I have been configuring version 1.7.12 of the i2b2 web client on a virtual machine against a SQL Server Database. I am able to navigate to the web client and log in successfully with the demo user account credentials. Upon logging in, I am greeted with four error messages saying "An error has occurred in the cell's AJAX library. Press F12 for more Information". Pressing F12 does not provide any more information other than that the server sends no XML response.

      wildfly has a much more interesting error message in the form of a warning.

      {code:bash}
       PM Error reported by CRC web Service Session invalid
      [ERROR] edu.harvard.i2b2.common.exception.I2B2Exception: PM Error reported by CRC web Service Session invalid
      [ERROR] at edu.harvard.i2b2.crc.delegate.pm.CallPMUtil.getUserProjectFromResponse(CallPMUtil.java:245)
      [...]
      18:12:03,160 WARN [org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory] (ConnectionValidator) IJ030027: Destroying connection that is not valid, due to the following exception: ConnectionID:2 ClientConnectionId: f1118223-4b86-4abb-90f7-b3a40b6d4d6f: java.sql.SQLException: pingDatabase failed
              at org.jboss.jca.adapters.jdbc.extensions.oracle.OracleValidConnectionChecker.isValidConnection(OracleValidConnectionChecker.java:72)
              at org.jboss.jca.adapters.jdbc.BaseWrapperManagedConnectionFactory.isValidConnection(BaseWrapperManagedConnectionFactory.java:1297)
              at org.jboss.jca.adapters.jdbc.BaseWrapperManagedConnectionFactory.getInvalidConnections(BaseWrapperManagedConnectionFactory.java:1098)
              at org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreConcurrentLinkedDequeManagedConnectionPool.validateConnections(SemaphoreConcurrentLinkedDequeManagedConnectionPool.java:1447)
              at org.jboss.jca.core.connectionmanager.pool.validator.ConnectionValidator$ConnectionValidatorRunner.run(ConnectionValidator.java:277)
              at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
              at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
              at java.lang.Thread.run(Thread.java:748)
      Caused by: java.lang.NoSuchMethodException: com.microsoft.sqlserver.jdbc.SQLServerConnection.pingDatabase()
              at java.lang.Class.getMethod(Class.java:1786)
              at org.jboss.jca.adapters.jdbc.extensions.oracle.SecurityActions.getMethod(SecurityActions.java:144)
              at org.jboss.jca.adapters.jdbc.extensions.oracle.OracleValidConnectionChecker.isValidConnection(OracleValidConnectionChecker.java:61)
              ... 7 more
      {code}

      I may be misinterpreting this error message, but it looks like there is no such method pingDatabase( ) in the com.microsoft.sqlserver.jdbc.SQLServerConnection class. This error message makes the web client unusable.

      Attachments

        Activity

          People

            Unassigned Unassigned
            mzd2016 Marcos Davila
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated: