[CORE-384] "PM Error reported by CRC web Service Session Invalid" error Created: 21/Feb/20 Updated: 24/Feb/20 |
|
Status: | New |
Project: | i2b2 Core Software |
Component/s: | Install |
Affects Version/s: | 1.7.12 |
Fix Version/s: | None |
Type: | Improvement | Priority: | Major |
Reporter: | Marcos Davila | Assignee: | Unassigned |
Resolution: | Unresolved | Votes: | 0 |
Labels: | None | ||
Remaining Estimate: | Not Specified | ||
Time Spent: | Not Specified | ||
Original Estimate: | Not Specified | ||
Environment: | Amazon Linux 2 |
Attachments: | i2b2 pingdb error.PNG |
Rank: | 0|s000co: |
i2b2 Feature/s: |
Session Timeout
|
Affects Database/s: |
SQL Server
|
Affects Web Browser/s: |
All Web Browsers
|
Participant/s: |
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. |
Comments |
Comment by Marcos Davila [ 24/Feb/20 ] |
You can disregard this ticket. The issue I faced was that I was using the OracleValidConnectionChecker, not the MSSQLValidConnectionChecker. |