Environment
NetIQ AppManager 6.x
NetIQ AppManager 7.0.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
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