ERROR animator_nxd.c 1839 AHD04199:An unexpected error occurred. Contact your administrator. %1 in animator ANI:2362993 (cr:409454) for atev:432465 in method examine_lock

Issue/Introduction:

Our test environment has begun generating a lot of database errors in Service Desk Manager and the system is nearly unusable due to delayed server response errors and other systems are not loading since they cannot connect with Service Desk Manager. stdlog says:
06/18 09:21:03.31 server-name sqlagt:Procedure0 9416 ERROR sqlclass.c 1010 SQL Execute failed: [Microsoft SQL Server Native Client 10.0] Unspecified error
06/18 09:21:03.31 servername animator_nxd 10960 ERROR animator_nxd.c 1839 AHD04199:An unexpected error occurred. Contact your administrator. %1 in animator ANI:2362993 (cr:409454) for atev:432465 in method examine_lock_list
06/18 09:21:03.31 servername sqlagt:Procedure0 9416 ERROR sqlclass.c 1011 Clause ({ ? = call dbo.usp_lock_acquire;1( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) }) Input (Animator|2321372|26136|domsrvr|(NULL)|superuser|ANI|cr:420280|1529328063|630)
06/18 09:21:03.31 servername sqlagt:Procedure0 9416 ERROR sqlsrvr.c 2616 Execution failed. MISC_DB_ERROR: Clause ({ ? = call dbo.usp_lock_acquire;1( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) }) Input (Animator|2321372|26136|domsrvr|(NULL)|superuser|ANI|cr:420280|1529328063|630)
06/18 09:21:03.31 servername bpvirtdb_srvr 9432 ERROR vdbmisc.c 688 Miscellaneous Database error occured :[Microsoft SQL Server Native Client 10.0] Unspecified error
06/18 09:21:03.32 servername bpvirtdb_srvr 9432 ERROR i18nMsg.c 582 Asking for index [0], number args sent [0], for message: AHD04199:An unexpected error occurred. Contact your administrator. %1 0

Cause:

The mdb anima table is un-synced with events and locks

Environment:

Service Desk/CMDB 17.1 on Windows/Unix/Linux

Resolution:

Follow these steps
1. shutdown SDM/CMDB
2. delete all records in anima table from DBMS side for mdb database
3. start SDM/CMDB