Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

MBAM 2.0 Enterprise Reports are not refreshed in MBAM 2.0 Standalone topology due to SQL job CreateCache failure


View products that this article applies to.

Symptoms

When you run MBAM 2.0 in a Stand-alone environment, the Enterprise Reports is not updated as SQL “Create Cache Job” fails. When you open the SQL Job output and select the row where job failed, you may notice the following error message:

Executed as user: DomainName\UserName. Arithmetic Overflow error converting IDENTITY to data type int. [SQLSTATE 42000] (Error 50000).
NOTE: The Step was retried the requested number of times (5) without succeeding. The step failed.

↑ Back to the top


Cause

This is a known issue in the product.

↑ Back to the top


Resolution

To resolve the problem, follow the below steps:
  1. Take back up of SQL MBAM Compliance DB using Backup software or native SQL backup.

    For more information on Backup Overview, visit the following web page:
    http://msdn.microsoft.com/en-us/library/ms175477(v=sql.105).aspx
  2. Connect to SQL Server where MBAM DB is installed.
  3. Open SQL Management Studio and run the below query and execute it.

    USE [MBAM Compliance Status]
    GO
    /****** Object: StoredProcedure [ComplianceCore].[UpdateCache] ******/
    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO
    ALTER PROCEDURE [ComplianceCore].[UpdateCache]
    WITH EXECUTE AS OWNER
    AS
    BEGIN
    SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
    DECLARE @OrigTranCount int
    SET @OrigTranCount = @@TRANCOUNT
    IF @OrigTranCount > 0
    SAVE TRAN myTran
    ELSE
    BEGIN TRAN
    BEGIN TRY
    DELETE
    FROM ComplianceCore.MachineCompliance
    DBCC CHECKIDENT('ComplianceCore.MachineCompliance', RESEED, 0)
    INSERT INTO ComplianceCore.MachineCompliance (LatestEntry, Name,
    DomainName, ErrorInfoName, ExemptionStatusId, IsCompliant, MachinesUsersNames)
    SELECT ComplianceCore.MachinesComplianceView.LatestEntry,
    ComplianceCore.MachinesComplianceView.Name,
    ComplianceCore.MachinesComplianceView.DomainName,
    ComplianceCore.MachinesComplianceView.ErrorInfoName,
    ComplianceCore.MachinesComplianceView.ExemptionStatusId,
    ComplianceCore.MachinesComplianceView.IsCompliant,
    N''
    FROM ComplianceCore.MachinesComplianceView
    IF @OrigTranCount = 0
    COMMIT TRAN
    END TRY
    BEGIN CATCH
    IF @OrigTranCount = 0
    ROLLBACK TRAN
    ELSE
    IF XACT_STATE() <> -1
    ROLLBACK TRAN myTran
    DECLARE @ErrorMessage1 NVARCHAR(4000);
    DECLARE @ErrorSeverity1 INT;
    DECLARE @ErrorState1 INT;
    SELECT @ErrorMessage1 = ERROR_MESSAGE();
    SELECT @ErrorSeverity1 = ERROR_SEVERITY();
    SELECT @ErrorState1 = ERROR_STATE();
    RAISERROR (@ErrorMessage1, -- Message text.
    @ErrorSeverity1, -- Severity.
    @ErrorState1 -- State.
    );
    END CATCH

    END
Note: The SQL query updates ComplianceCore.UpdateCache stored procedure in MBAM 2.0 standalone system.


↑ Back to the top


More Information

If SQL Create Cache Job is missing after you upgrade MBAM 1.0 to MBAM 2.0 Standalone, then follow steps in below article to resolve the issue.
http://technet.microsoft.com/en-us/library/dn145071.aspx

↑ Back to the top


Keywords: kbtshoot, kb

↑ Back to the top

Article Info
Article ID : 2870839
Revision : 1
Created on : 1/7/2017
Published on : 3/6/2015
Exists online : False
Views : 617