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
book
Article ID: 102379
calendar_today
Updated On:
Products
CA Service Management - Asset Portfolio ManagementCA Service Management - Service Desk Manager
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