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.
If this does not resolve your issue, you may want to view another potential solution - TEC607752