Environment
NetIQ AppManager Control Center 7.0.x
Situation
[SQL COMMAND: exec dbo.SyncManagementGroup SQLSERVER\INSTANCE.DB NAME' ] Cannot use SAVE TRANSACTION within a distributed transaction.
Cannot use SAVE TRANSACTION within a distributed transaction.
SyncManagementGroup: execute exec @rc =[SQLSERVER\INSTANCE].[DB NAME].dbo.CC_RemoveMemberFromManagementGroup @managementgroupid, @viewservergroupid,@type failed.
SyncManagementGroup: execute exec @rc =[SQLSERVER\INSTANCE].[DB NAME].dbo.CC_RemoveMemberFromManagementGroup @managementgroupid, @viewservergroupid,@type failed. (SQL severity 16).
Cannot use SAVE TRANSACTION within a distributed transaction.
SyncManagementGroup: execute exec @rc =[SQLSERVER\INSTANCE].[DB NAME].dbo.CC_RemoveMemberFromManagementGroup @managementgroupid, @viewservergroupid,@type failed.
SyncManagementGroup: execute exec @rc =[SQLSERVER\INSTANCE].[DB NAME].dbo.CC_RemoveMemberFromManagementGroup @managementgroupid, @viewservergroupid,@type failed. (SQL severity 16).
Resolution
This issue will self correct on the next scheduled iteration of the Control Center database's SQL Server Agent jobs.
If this issue persists, please contact NetIQ Technical Support.
Cause
This Cache Manager error is a transient failure, as some SQL tasks require additional wait time before other SQL tasks can be completed successfully.
Additional Information
Formerly known as NETIQKB73258