UIM - CABI Reports take 10+ minutes to return data. There was an error on the server. Try again or contact site administrators. (Error UID: a4e91ca6-d550-4770-a230-bbeab01c78ff)

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

This technical article documents an issue faced where out of the box CABI reports would not run or would take 10+ minutes to populate data (spinning icon in OC or CABI JRS). 

Symptoms of the issue: 

1. Out of the box CABI reports in both the Operator Console and Jasper Report Server Console continue to spin for 10-20 minutes before loading data. 

2. Out of the box CABI reports do not finish loading data and report the below error: 

There was an error on the server. Try again or contact site administrators. (Error UID: a4e91ca6-d550-4770-a230-bbeab01c78ff)

Environment

Release : 20.3

Component : UIM - CABI

CABI Bundles and External 

Cause

Large volume of data in the UIM Database (RN,HN,DN and BN_QOS * tables) and DB fragmentation. 

Resolution

The below articles and documentation related to the data_engine, and database should be reviewed:  

CA UIM (Nimsoft) Database Best Practices for MS SQL Server
https://ca-broadcom.wolkenservicedesk.com/external/article?articleId=33680

How does data_engine maintenance and retention work?
https://knowledge.broadcom.com/external/article?articleId=33704

data_engine probe : Data Maintenance and Index Maintenance job recommendations
https://knowledge.broadcom.com/external/article?articleId=131511

Verifying that data_engine is deleting old raw and historic data properly from the database
https://knowledge.broadcom.com/external/article?articleId=34940

UIM (NimsoftSLM) Database has Grown to an Unmanageble Size
https://ca-broadcom.wolkenservicedesk.com/external/article?articleId=34941

How to find the TOP 10 largest tables in your UIM Database
https://ca-broadcom.wolkenservicedesk.com/external/article?articleId=10095