Guidance on Inactivating Resources Directly via the Database

Products

• CA Business Service Insight

Issue/Introduction

Users may need to inactivate multiple resource names within CA Business Service Insight (BSI) simultaneously, especially when a related contract has expired or the resources are no longer required for calculations.

Manually updating each resource one at a time via the Resource tab in the BSI UI is time-consuming.

Is it possible to execute a direct SQL query to change the status of several resource names to 'Inactive'?

Environment

Product: CA Business Service Insight (BSI)
Version: All Supported Versions

Resolution

Direct modification of resource statuses via a database SQL script is not recommended and is considered unsafe.

Why Database Modification is Avoided

Resources in BSI have complex interdependencies, including:

• Metric/SLA associations
• Resource Group relations
• Business Logic registration
• Contract effective dates

Manually altering the database state can lead to data inconsistency, calculation errors or orphaned records.

Recommended Action

Always use the provided BSI User Interface (UI) options to manage resource statuses. This ensures that all internal application logic and dependency checks are correctly executed.

1. Login to the BSI UI as an Administrator
2. Navigate to the Resource tab.
3. Locate the resources associated with the expired contract.
4. Ensure the dependent contracts are set to ineffective (e.g., by setting the effective-end-date).
5. Manually update and commit each resource status.

Additional Information

Before inactivating resources, verify the following:

• Dependencies: Confirm that the resources are not registered for any other currently effective metrics.
• Resource Groups: Verify if the resources have existing relations with resource groups that might be impacted.
• Calculation Integrity: Ensure that the metrics related to these resources have 0 volume reported or are otherwise ready for decommissioning.