Search Option inconsistent with the newly imported service offering
Article ID: 115648
CA Service Management - Asset Portfolio ManagementCA Service Management - Service Desk Manager
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.
CA SERVICE CATALOG 14.1 CA SERVICE CATALOG 17.1
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.
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.