Service offerings are missing in Service Catalog after renaming some of the offerings

Products

• CA Service Management - Service Desk Manager
• CA Service Catalog

Issue/Introduction

After renaming offerings, all items disappeared from the Catalog tab > Service Offerings > Offerings. Checking the usm_offering there are several items with status 1 (available) and date_unavailable set to NULL 

 

Environment

Release : 17.3

Component : CA SERVICE CATALOG

Cause

unknown cause

Resolution

Workaround:

1. Stop Service Catalog services

2. Delete translets from USM_HOME\view\translets

3. Start Service Catalog services

Additional Information

What information is stored in the usm_offering table of MDB database for Service Management application?