A knowledge reindex fails with miscellaneous database error

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

Issue:

When running the command pdm_k_reindex +f to reindex Service Desk Manager knowledge content an error may be received "miscellaneous database error".

Environment:

A Service Desk Manager environment configured to connect to a database that has database replication configured against the knowledge content tables

Cause:

If Database Replication is configured against the knowledge index tables this error may be seen.

Resolution:

If Database Replication will be enabled, it should be completed following the guidelines outlined here:

https://docops.ca.com/ca-service-management/14-1/en/administering/administering-ca-service-management/offline-reporting-through-microsoft-sql-server-database-replication/implement-replication/manual-configuration

Once the knowledge tables are excluded from the replication process, the knowledge index should complete successfully.