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


Article ID: 39812


Updated On:


SUPPORT AUTOMATION- SERVER CA Service Desk Manager - Unified Self Service KNOWLEDGE TOOLS CA Service Management - Asset Portfolio Management CA Service Management - Service Desk Manager



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.


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


Release: SDMU0M99000-14.1-Service Desk Manager-Full License