Search Option inconsistent with the newly imported service offering

Products

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

Issue/Introduction

Previously in SC we had few words which we were not getting any results when we search like "Find", "Software" etc...
However after Test fix (T6D9145) the issue was resolved.

Now the newly imported service offering is not getting any search results. Created a new service offering on QA Environment and extracted that service offering including the service option group, service option and form. we import that service offering to PROD which got imported properly and the workflow is also working however when we search for service offering zero search results showed. 

Environment

CA SERVICE CATALOG 14.1
CA SERVICE CATALOG 17.1

Cause

The newly importer service offering, we are not getting any search results for that item.We created a new service offering on QA Env. and we have extracted that service offering including the service option group and service option and form, we import that service offering to PROD which got imported properly and the work flow is also working but when we search for that service offering we are not getting any search results. 

Resolution

Note***: Work around cursor update has been provided to client to solve the issue temporarily
==================================================== 

DECLARE @rateplanid INT, @ratecol INT, @raterow INT, @cnt INT 

DECLARE cursorName CURSOR 
FOR SELECT rate_plan_id, rate_col, rate_row, COUNT(rate_plan_id) as cnt FROM usm_rate_definition where status =1group by rate_plan_id, rate_col, rate_row order by cnt desc 
OPEN cursorName -- open the cursor 
FETCH NEXT FROM cursorName INTO @rateplanid, @ratecol, @raterow, @cnt 
WHILE @@FETCH_STATUS = 0 
BEGIN 
IF @cnt > 1 
BEGIN 
DECLARE @item_id INT 
DECLARE InnercursorName CURSOR 
FOR SELECT item_id FROM usm_rate_definition where rate_plan_id =@rateplanid and rate_row=@raterow and rate_col=@ratecol and status=1 ORDER BY item_id desc 
OPEN InnercursorName -- open the cursor 
FETCH NEXT FROM InnercursorName INTO @item_id 
WHILE @@FETCH_STATUS = 0 
BEGIN 
WHILE @cnt > 1 BEGIN 
UPDATE usm_rate_definition set status =0 where item_id =@item_id SET @cnt = @cnt-1 
FETCH NEXT FROM InnercursorName INTO @item_id 
END 
FETCH NEXT FROM InnercursorName INTO @item_id 
END 
CLOSE InnercursorName -- close the cursor 
DEALLOCATE InnercursorName -- Deallocate the cursor 
END 
FETCH NEXT FROM cursorName INTO @rateplanid, @ratecol, @raterow, @cnt 
END 
CLOSE cursorName -- close the cursor 
DEALLOCATE cursorName -- Deallocate the cursor 

IMP***: This was provided to a client on a specific issue and if the exact same match is identified in any other environment please open a case with CA
Confirm if this is related to your environment and the same cursor solution is applicable and only then implement the solution.