Reindexing resulting in a critical error reported

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

When running pdm_reindex, an error may present indicating "The program was not successful due to a critical error. Please see the log files for further details."

The logging will indicate:

12/06 21:09:34.33 SERVER1 sqlagt:CREATE_IND 5100 ERROR sql_common.c 422 DROP INDEX returned 11 [Microsoft OLE DB Provider for SQL Server] [ SQL Code=0 SQL State=08S01] Connection failure

12/06 21:09:34.49 SERVER1 sqlagt:CREATE_IND 5100 ERROR sql_common.c 423 DROP INDEX EBR_FULLTEXT_ADM.ebr_fulltext_adm_x0

12/06 21:09:34.49 SERVER1 sqlagt:CREATE_IND 5100 ERROR sqlsrvr.c 651 Execution failed. MISC_DB_ERROR

12/06 21:09:34.49 SERVER1 bpvirtdb_srvr 8508 ERROR vdbsql.c 5937 DROP INDEX agent got database error 15



12/06 21:12:30.16 SERVER1 sqlagt:CREATE_IND 5100 ERROR sql_common.c 302 CREATE INDEX returned 11 [Microsoft OLE DB Provider for SQL Server] [ SQL Code=0 SQL State=08S01] Connection failure

12/06 21:12:30.16 SERVER1 sqlagt:CREATE_IND 5100 ERROR sql_common.c 303 CREATE UNIQUE INDEX "ebr_fulltext_adm_x0" ON "ebr_fulltext_adm" ( "id" ASC )

12/06 21:12:30.16 SERVER1 sqlagt:CREATE_IND 5100 ERROR sqlsrvr.c 651 Execution failed. MISC_DB_ERROR

12/06 21:12:30.16 SERVER1 bpvirtdb_srvr 8508 ERROR vdbsql.c 5791 CREATE INDEX agent got database error 15

12/06 21:12:30.71 SERVER1 pdm_k_reindex 9628 SEVERE_ERROR BPebrReindex.c 634 EBR::REINDEX::EBR::BPebrReindex::recvmsg::in "MTH::EBR::REINDEX::create_indexes_reply::EBR_FULLTEXT_ADM" method. Error: 15: AHD04115:An unexpected error occurred. Contact your administrator.


 

Resolution:

Normally a restart of SDM would address such issue.  However, one can try the following to see if the issue would clear up.

The following actions will result in termination of certain background processes and will also require administrative access to the SDM Server. Please plan accordingly.

Open an admin command prompt and run the following on the SDM primary or BG server:

WMIC PROCESS WHERE "commandLine LIKE '%ebr%' AND caption LIKE 'sql_agent_nxd.exe'" get ProcessID, caption

You'll see output like below (7956 is the processID of the process that we need to kill (you can kill via task manager)

Caption ProcessId
sql_agent_nxd.exe 7956


Now next command:
WMIC PROCESS WHERE "commandLine LIKE '%create%' AND caption LIKE 'sql_agent_nxd.exe'" get ProcessID, caption

You'll see output like below (6196 is the processID of the process that we need to kill (you can kill via task manager)

Caption ProcessId
sql_agent_nxd.exe 6196

Please see if killing these two specific processes (identify by the PID in task manager!) will enable reindex to work.  The above processes would  regenerate once they have been cycled.