The dashboard and or reports do not load and fail with an error
search cancel

The dashboard and or reports do not load and fail with an error


Article ID: 131722


Updated On:


SUPPORT AUTOMATION- SERVER CA Service Desk Manager - Unified Self Service CA Service Desk Manager CA Service Management - Asset Portfolio Management CA Service Management - Service Desk Manager


Some users are getting an error message when accessing the Jasper Reports dashboards.

An unknown error occur and the operation failed. 

These issues occur after the users stop working for some time in the Jasper GUI.


Service Desk 14.1 or higher
Jasper Reports 6.3.0 or higher


The jasperserver.log files show the cause of the issue:

ERROR AsyncJasperPrintAccessor,pool-6-thread-750:321 - Error during report execution net.sf.jasperreports.engine.JRException: Error preparing statement for executing the report query:
Caused by: java.sql.SQLException: [DataDirect][OpenAccess SDK JDBC Driver][OpenAccess SDK SQL Engine]AHD12033:Request cannot be processed. The session was timeout, after 60 minutes of inactivity

Basically the end user left the Jasper session opened, the session timeout is higher than the ODBC timeout so when it tried to access the dash board it failed as the ODBC session was already ended.


Increase the ODBC timeout from default 60 min to whatever you require via the NX_ROOT\bopcfg\www\web.cfg file.
Within the file, find and change the line below:

! OdbcTimeout 60

to the following:

OdbcTimeout 120

The value indicated is in minutes. So in the example above, the timeout would be set for two hours. Make the same change to the NX_ROOT\bopcfg\www\web.cfg.tpl file so the changes will not be lost when a pdm_configure is executed. After making and saving the change to the WEB.CFG file, a recycle of the SD service is required for the change to take effect.