CA Service Desk Manager (CA SDM) Pdm_k_reindex utility/command is hanging

Document ID : KB000039812
Last Modified Date : 14/02/2018
Show Technical Document Details

Summary

When running the CA Service Desk Manager (CA SDM) pdm_k_reindex utility/command on a regular basis, it will hang intermittently.   Errors similar to the one below will appear in the CA SDM STDLOGs:

sqlagt:CREATE_IND 6004 ERROR sql_common.c 302 CREATE INDEX returned 11 [Microsoft OLE DB Provider for SQL Server] [ SQL Code=0 SQL State=08S01] Connection failure 
<hostname> sqlagt:CREATE_IND 6004 ERROR sql_common.c 303 CREATE UNIQUE INDEX "ebr_fulltext_x0" ON "ebr_fulltext" ( "id" ASC ) 

Recycling the CA SDM service may resolve this issue.

Instructions

If you are experiencing this issue, it is recommended that you run the "pdm_k_reindex -ml" command.  The extra argument should address the root cause of the reindex hanging.

Additional Information

If this does not resolve your issue, you may want to view another potential solution - TEC607752