Unable to download transaction usage report

Products

• Service Virtualization

Issue/Introduction

Unable to extract transaction usage data from enterprise dashboard, it prompts error as "An error has occurred while downloading the selected report.".

Environment

DevTest 10.x

Cause

Below exception in the logs that suggests that the IO usage limit for the ED DB user profile is exhausting when trying to pull the large amount of data in the excel report. 

=======================================================

2025-11-21T09:20:09,813Z (17:20) [http-nio-1506-exec-1] ERROR com.ca.dradis.controller.LicensingController - Could not export Excel file. 
java.sql.SQLException: ORA-02395: exceeded call limit on IO usage

========================================================

Resolution

There is an option to increase this limit by updating the parameter 'LOGICAL_READS_PER_CALL' on the Database side to a higher value( could set to UNLIMITED as well) for ED user profile. This has to be done by the DBA.