Unable to locate Service catalog offering under service point.

Products

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

Issue/Introduction

After Upgrade of CA Servicedesk Manager and Service Catalog. 
Under Service Point unable to locate Service Catalog Offerings. 

Excerpt from Initial_load.log:
======================
[10:58:33,971][INFO ][loader.source ][main] Checking whether Service Catalog is installed in this Deployment.
[10:58:34,112][INFO ][loader.source ][main] Status of Service Catalog installation :
[10:58:34,112][INFO ][loader ][main] Skipping catalog

Environment

Release : 17.3

Component : CA Service Catalog

Cause

Missing Entry in al_cdb_configurationparameter : 
SELECT * FROM al_cdb_configurationparameters where configkey='slcm.hostname'

Resolution

#Followed these below troubleshooting steps :
1) access ElasicSearch server through Chrome Addon  and deleted all the indexes. 
2) Stopped Search Server. 
3)Take the backup of al_cdb_configurationparameters
4) Added the missing table entry, replace [NAME OF CATALOG SERVER] with the correct server name: 

USE [mdb]
GO

INSERT INTO [dbo].[al_cdb_configurationparameters]
([componentkey]
,[machinename]
,[configkey]
,[configvalue]
,[productcode]
,[last_update_date])
VALUES
('ITSM','common','slcm.hostname','[NAME OF CATALOG SERVER]',9,1552577972583)
GO

5)Build meta data now: pdm_es_build_index_metadata.bat
C:\Program Files\CA\SC\CASearchServer\search\bin> pdm_es_build_index_metadata.bat
6)Build Initial Load: 
C:\Program Files\CA\SC\CASearchServer\search\bin>pdm_es_initial_load.bat