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

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


    • Type: Improvement
    • Status: New
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 1.7.12
    • Fix Version/s: None
    • Component/s: Install
    • Labels:
    • Environment:
      Amazon Linux 2
    • Rank:
    • i2b2 Feature/s:
      Session Timeout
    • Affects Database/s:
      SQL Server
    • Affects Web Browser/s:
      All Web Browsers


      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.

       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

      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.




            • Assignee:
              mzd2016 Marcos Davila
            • Votes:
              0 Vote for this issue
              1 Start watching this issue


              • Created:

                Git Source Code