Service Desk performance is very poor when Service Catalog is integrated

Document ID : KB000109914
Last Modified Date : 07/08/2018
Show Technical Document Details
Issue:
Service Desk performance is very poor in all the application, Service Catalog (SC) was integrated but SC is not being used, the following messages are recorded in the logs:
SIGNIFICANT prov_base.c 1010 SQL Query has returned (5000) rows for (domsrvr/). Clause (SELECT usp_itsm_msg_queue.retries, usp_itsm_msg_queue.id FROM usp_itsm_msg_queue WHERE ( usp_itsm_msg_queue.status = 0 AND usp_itsm_msg_queue.retries < 20 ) OR ( usp_itsm_msg_queue.status = 1 AND usp_itsm_msg_queue.timestamp <= 1529019751 )) Input ( )

catalogsync.log ERROR CatalogServiceProcessor 119 Error synching Attachment to Catalog. ; nested exception is: \n java.net.ConnectException: Connection refused: connect
Environment:
Service Management 14.1 or higher
 
Cause:
Service Desk (SD) is not able to connect to Service Catalog, since the integration is active the synchronization between both will keep going, creating new records for sync but the process will not send any data from SD to SC and it will keep retrying every 15 minutes. This will overload SD vdbagents causing slow performance in the application
Resolution:
If Service Catalog is not functional the integration must be disabled and the data must be cleared:

1. Set all the Service Catalog options in Service Desk to "Not Installed" under Administration > Options Manager > CA Service Catalog > Stop Service Desk  services.
2. Backup current usp_itsm_msg_queue table in SQL Server:
    select * into usp_itsm_msg_queue_BKP from usp_itsm_msg_queue;
3. Truncate the contents of existing table:
    TRUNCATE TABLE usp_itsm_msg_queue
4. Start Service Desk services.
 
Additional Information:
CA Service Catalog Options:

https://docops.ca.com/ca-service-management/14-1/en/administering/administering-ca-service-desk-manager/options-manager#OptionsManager-CAServiceCatalogOptions