Duplicate rows in Data Sources in Unified Self-Service

Products

• CA Service Management - Asset Portfolio Management
• CA Service Management - Service Desk Manager

Issue/Introduction

Duplicate items in USS Data Sources:

 

<Please see attached file for image>

Environment

Unified Self-Service 17.0

Cause

Duplicate rows in os_ExternalSource and os_ExternalSourceProperties tables in the USS_mdb database.

Resolution

To solve this issue there are 2 options:

 

1. Remove duplicate rows in os_ExternalSource table and references through sourceID in os_ExternalSourceProperties table in the USS_mdb database.

2. Uninstall USS and perform a new USS installation so a new database is created.  More information about uninstalling USS:

 

https://docops.ca.com/ca-service-management/14-1/en/implementing/implementing-ca-service-management-14-1/uninstall-ca-service-management-14-1/uninstall-unified-self-service