User creates a JasperSoft dashboard with two ad hoc reports. The dashboard is set to reload every 5 minutes.
After a period of time (5-30 minutes), the dashboard reloads and both reports show an error: “An unexplained error has occurred and the operation failed”.
Error in jasper log:
202 ERROR JDBCPreparedStatement,Thread-7240:131 - Exception occured in the JBDCPreparedStatement com.ca.sdm.dal.PersistenceException: com.ca.sdm.bop.BPMessagingException: com.ca.sdm.bop.BPMessagingException: 10 register_session_user failed; cannnot find session with id 1406181816 and userid ServiceDesk Closing the jdbc connection
211 ERROR BaseJdbcDataSource,pool-6-thread-77:62 - Error closing connection.
java.sql.SQLException: Already closed.
Service Desk Manager 17.x
Please install the following option on all Service Desk Manager (SDM) servers, then recycle the SDM service as well as the JasperSoft service.
SESSION_OBJECT_DELETE_DELAY is the number of seconds BOPLOGIN delays before deleting information for a completed session. Retaining the session allows residual messages referencing the session to complete without error. The default value is 60 seconds.
pdm_options_mgr -c -s SESSION_OBJECT_DELETE_DELAY -v 200 -a pdm_option.inst
pdm_options_mgr -c -s SESSION_OBJECT_DELETE_DELAY -v 200 -a pdm_option.inst -t
Once the option is installed, verify the SDM NX.env file has the variable below:
Please also reference below for instructions on how to apply this value: