ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

ElasticSearch doesnt list Service catalog index

book

Article ID: 213993

calendar_today

Updated On:

Products

CA Service Catalog

Issue/Introduction

After rebuilding an Environment with SDM  and Catalog  , ElasticSearch doesnt list out Catalog Index. 

 

 

Cause

slcm.hostname entry will be missing from al_cdb_configurationparameter table. 

Environment

Release : 17.3

Component : CA SERVICE CATALOG

Resolution

1 ) Stop CA Search Server service
2 )Manually create the record in the database, something like:
componentkey machinename configkey configvalue productcode last_update_date
itsm common slcm.hostname Catalog_Real_hostName 9 1552577972583
USE [mdb]
GO

INSERT INTO [dbo].[al_cdb_configurationparameters]
([componentkey]
,[machinename]
,[configkey]
,[configvalue]
,[productcode]
,[last_update_date])
VALUES
('ITSM','common','slcm.hostname','Catalog_Real_hostName',9,1552577972583)
GO
Note: replace Catalog_Real_hostName with catalog server name
get the last_update_date from https://www.epochconverter.com/
3)Restart CA Search Server service
4)Re-run the pdm_es_build_index_metadata.bat
5)Re-run the pdm_es_initial_load.bat
6)now check whether the indexes are created or not by launching elastic server url in the chrome browser.

Attachments