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

Products

• 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 and above

Component : CA SERVICE CATALOG

Resolution

1. Stop Service Catalog services

2. Delete translets from USM_HOME\view\translets (backup the USM_HOME\view\translets first)

3. Start Service Catalog services

Additional Information

Information stored in the usm_offering table of MDB database for Service Management application