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

book

Article ID: 198723

calendar_today

Updated On:

Products

CA Service Management - Service Desk Manager CA Service Desk Manager

Issue/Introduction

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.

Environment

Service Desk Manager 17.x

JasperSoft 7.x

Resolution

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:

@NX_SESSION_OBJECT_DELETE_DELAY=200

Please also reference below for instructions on how to apply this value:

https://knowledge.broadcom.com/external/article?articleId=39873