search cancel

How to clean-up failed CA Business Intelligence (CABI) report instances programmatically?

book

Article ID: 42068

calendar_today

Updated On:

Products

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

Issue/Introduction

Question

How to clean-up failed CA Business Intelligence (CABI) 3.x report instances programmatically?

Answer

Be sure to backup the CABI CMS database and CABI server prior to performing these steps.  The script provided will query the CMS database for all instances that have a SI_SCHEDULE_STATUS = 3 (3 being failed).  It then loops through all the found instances and deletes them in batches as specified in the 'int batchSize' setting.  The script outputs to the web browser the instances names and IDs of what is being deleted.

1.  Download and extract the deleteFailedInstancesV3.zip file to the "/<Tomcat>/webapps/InfoViewApp/" directory on the CABI Server

2.  Edit the JSP file using a text editor

3.  At the top of the file, change the username, password, and CMSName values to be appropriate for your environment.  You can also change the batch deletion size by modifying the 'ini batchSize' value.

String userName = "Administrator";

Sting password = "Password123";

String CMSName = "CABIServer:6400";

int bathSize = 1000;

4.  Save changes

5.  Run the script by access htt[://<CABI ServerName>:<Tomcat Port>/InfoViewApp/deleteFailedInstancesV3.jsp from a web browser.  For example http://CABI123:8080/InfoViewApp/deleteFailedInstancesV3.jsp

deleteFailedInstancesV3.zip

Environment

Release: SDMU0M99000-14.1-Service Desk Manager-Full License
Component:

Attachments

1558534462632TEC1305932.zip get_app