search cancel

JasperSoft Dashboard Throws Error: “An unexplained error has occurred and the operation failed”


Article ID: 198723


Updated On:


CA Service Management - Service Desk Manager CA Service Desk Manager


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 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

JasperSoft 7.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: