Event Detail show 'MS actions in progress' for a Knowledge Script that triggered an Action Knowledge (NETIQKB14099)

  • 7714099
  • 02-Feb-2007
  • 02-Jun-2011

Environment

NetIQ AppManager 6.x
NetIQ AppManager 7.0.x

Situation

Management Server actions in progress in the console.

MS actions do occur although the message 'MS action in progress' appears in the operator console.

RPLIB.LOG contains many of the following errors:

10/14/02 20:56:33 (NetIQms-4.3.20.10 pid 1760, th# 3532) {?=call dbo.msUpdateEventAction (?,?,?,?)}
10/14/02 20:56:33 (NetIQms-4.3.20.10 pid 1760, th# 3532) SQLSTATE=23000, native error=547, msg='[Microsoft][ODBC SQL Server Driver][SQL Server]INSERT statement conflicted with COLUMN FOREIGN KEY constraint 'EventDetailAction_Detail_fk'. The conflict occurred in database 'QDB', table 'EventDetail', column 'EventID'.'
SQLSTATE=01000, native error=3621, msg='[Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated.'
SQLSTATE=37000, native error=50000, msg='[Microsoft][ODBC SQL Server Driver][SQL Server]msUpdateEventAction: failed to insert new EventDetailAction for eventid 7249651, actionidx 3'

10/14/02 20:56:33 (NetIQms-4.3.20.10 pid 1760, th# 3532) {?=call dbo.msUpdateEventAction (?,?,?,?)}
10/14/02 20:56:33 (NetIQms-4.3.20.10 pid 1760, th# 3532) SQLSTATE=23000, native error=547, msg='[Microsoft][ODBC SQL Server Driver][SQL Server]INSERT statement conflicted with COLUMN FOREIGN KEY constraint 'EventDetailAction_Detail_fk'. The conflict occurred in database 'QDB', table 'EventDetail', column 'EventID'.'
SQLSTATE=01000, native error=3621, msg='[Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated.'
SQLSTATE=37000, native error=50000, msg='[Microsoft][ODBC SQL Server Driver][SQL Server]msUpdateEventAction: failed to insert new EventDetailAction for eventid 7249651, actionidx 1'

10/14/02 20:56:33 (NetIQms-4.3.20.10 pid 1760, th# 3532) {?=call dbo.msUpdateEventAction (?,?,?,?)}
10/14/02 20:56:33 (NetIQms-4.3.20.10 pid 1760, th# 3532) SQLSTATE=23000, native error=547, msg='[Microsoft][ODBC SQL Server Driver][SQL Server]INSERT statement conflicted with COLUMN FOREIGN KEY const

Resolution

Reduce the number of MS Actions by either moving their location to be MC or Proxy based. Continue to allow the Management Server to run, eventually the these 'MS action in progress' messages should go away.

Cause

Due to the very high volume of MS action jobs being executed, the Agent on the MS is being overloaded

Additional Information

Formerly known as NETIQKB14099