Table 5339 Integration Synch. Job Errors

Base Application, Microsoft.Integration.SyncEngine

src/Layers/W1/BaseApp/Integration/SynchEngine/IntegrationSynchJobErrors.Table.al257 lines, Copyright (c) Microsoft Corporation. MIT

// ------------------------------------------------------------------------------------------------// Copyright (c) Microsoft Corporation. All rights reserved.// Licensed under the MIT License. See License.txt in the project root for license information.// ------------------------------------------------------------------------------------------------namespace Microsoft.Integration.SyncEngine;using Microsoft.Integration.Dataverse;using System.Reflection;table 5339 "Integration Synch. Job Errors"{    Caption = 'Integration Synch. Job Errors';    ReplicateData = false;    DataClassification = CustomerContent;    fields    {        field(1; "No."; Integer)        {            AutoIncrement = true;            Caption = 'No.';            ToolTip = 'Specifies the number of the involved entry or record, according to the specified number series.';        }        field(2; "Integration Synch. Job ID"; Guid)        {            Caption = 'Integration Synch. Job ID';            TableRelation = "Integration Synch. Job".ID;        }        field(3; "Source Record ID"; RecordID)        {            Caption = 'Source Record ID';            DataClassification = CustomerContent;        }        field(4; "Destination Record ID"; RecordID)        {            Caption = 'Destination Record ID';            DataClassification = CustomerContent;        }        field(5; Message; Text[250])        {            Caption = 'Message';        }        field(6; "Date/Time"; DateTime)        {            Caption = 'Date/Time';            ToolTip = 'Specifies the date and time that the error in the integration synchronization job occurred.';        }        field(7; "Exception Detail"; BLOB)        {            Caption = 'Exception Detail';            ToolTip = 'Specifies the exception that occurred in the integration synchronization job.';        }        field(8; "Error Message"; Text[2048])        {            Caption = 'Error Message';        }    }    keys    {        key(Key1; "No.")        {            Clustered = true;        }        key(Key2; "Integration Synch. Job ID", "Date/Time")        {        }        key(Key3; "Date/Time", "Integration Synch. Job ID")        {        }        key(Key4; "Integration Synch. Job ID")        {        }        key(Key5; "Destination Record ID", "Integration Synch. Job ID")        {        }        key(Key6; "Source Record ID", "Integration Synch. Job ID")        {        }    }    fieldgroups    {    }    var        DeleteEntriesQst: Label 'Are you sure that you want to delete the %1 entries?', Comment = '%1 = Integration Synch. Job Errors caption';    procedure DeleteEntries(DaysOld: Integer)    begin        if not Confirm(StrSubstNo(DeleteEntriesQst, TableCaption)) then            exit;        SetFilter("Date/Time", '<=%1', CreateDateTime(Today - DaysOld, Time));        DeleteAll();        SetRange("Date/Time");    end;    procedure LogSynchError(IntegrationSynchJobId: Guid; SourceRecordId: RecordID; DestinationRecordId: RecordID; ErrorMessage: Text)    var        IntegrationSynchJobErrors: Record "Integration Synch. Job Errors";        StackTraceOutStream: OutStream;    begin        IntegrationSynchJobErrors.Init();        IntegrationSynchJobErrors."Integration Synch. Job ID" := IntegrationSynchJobId;        IntegrationSynchJobErrors."Source Record ID" := SourceRecordId;        IntegrationSynchJobErrors."Destination Record ID" := DestinationRecordId;        IntegrationSynchJobErrors."Date/Time" := CurrentDateTime;        IntegrationSynchJobErrors.Message := CopyStr(ErrorMessage, 1, MaxStrLen(IntegrationSynchJobErrors.Message));        IntegrationSynchJobErrors."Error Message" := CopyStr(ErrorMessage, 1, MaxStrLen(IntegrationSynchJobErrors."Error Message"));        IntegrationSynchJobErrors."Exception Detail".CreateOutStream(StackTraceOutStream);        StackTraceOutStream.Write(GetLastErrorCallstack);        IntegrationSynchJobErrors.Insert(true);        OnAfterLogSynchError(Rec);    end;    procedure SetDataIntegrationUIElementsVisible(var DataIntegrationCuesVisible: Boolean)    begin        OnIsDataIntegrationEnabled(DataIntegrationCuesVisible);    end;    procedure ForceSynchronizeDataIntegration(LocalRecordID: RecordID; var SynchronizeHandled: Boolean)    begin        OnForceSynchronizeDataIntegration(LocalRecordID, SynchronizeHandled);    end;    [Scope('OnPrem')]    procedure ForceSynchronizeDataIntegration(var LocalRecordIdList: List of [RecordId]; var SynchronizeHandled: Boolean)    begin        OnForceSynchronizeRecords(LocalRecordIdList, SynchronizeHandled);    end;    [Scope('OnPrem')]    procedure DeleteCouplings()    begin        DeleteCouplings(Rec);    end;    local procedure DeleteCouplings(var IntegrationSynchJobErrors: Record "Integration Synch. Job Errors")    var        TempCRMSynchConflictBuffer: Record "CRM Synch. Conflict Buffer" temporary;    begin        if CollectLocalRecords(IntegrationSynchJobErrors, TempCRMSynchConflictBuffer) then            UncoupleLocalRecords(TempCRMSynchConflictBuffer);    end;    local procedure CollectLocalRecords(var IntegrationSynchJobErrors: Record "Integration Synch. Job Errors"; var TempCRMSynchConflictBuffer: Record "CRM Synch. Conflict Buffer" temporary): Boolean    var        LocalRecordRef: RecordRef;        LocalRecordId: RecordId;        LocalSystemId: Guid;        RecordCount: Integer;        RecordIdDictionary: Dictionary of [RecordId, Boolean];    begin        if not IntegrationSynchJobErrors.FindSet() then            exit(false);        RecordCount := 0;        repeat            if GetLocalRecordId(IntegrationSynchJobErrors, LocalRecordId) then                if not RecordIdDictionary.ContainsKey(LocalRecordId) then begin                    LocalRecordRef.Close();                    LocalRecordRef.Open(LocalRecordId.TableNo());                    if LocalRecordRef.Get(LocalRecordId) then begin                        LocalSystemId := LocalRecordRef.Field(LocalRecordRef.SystemIdNo()).Value();                        if not IsNullGuid(LocalSystemId) then begin                            TempCRMSynchConflictBuffer."Entry No." := RecordCount + 1;                            TempCRMSynchConflictBuffer."Table ID" := LocalRecordId.TableNo();                            TempCRMSynchConflictBuffer."Integration ID" := LocalSystemId;                            TempCRMSynchConflictBuffer.Insert();                            RecordCount += 1;                        end;                    end;                end;        until IntegrationSynchJobErrors.Next() = 0;        exit(RecordCount > 0);    end;    local procedure UncoupleLocalRecords(var TempCRMSynchConflictBuffer: Record "CRM Synch. Conflict Buffer" temporary)    var        LocalTableID: Integer;        PrevLocalTableID: Integer;        LocalIdList: List of [Guid];    begin        TempCRMSynchConflictBuffer.SetCurrentKey("Table ID");        if not TempCRMSynchConflictBuffer.FindSet() then            exit;        PrevLocalTableID := 0;        repeat            LocalTableID := TempCRMSynchConflictBuffer."Table ID";            if LocalTableID <> PrevLocalTableID then begin                if PrevLocalTableID <> 0 then begin                    UncoupleLocalRecords(PrevLocalTableID, LocalIdList);                    LocalIdList.RemoveRange(1, LocalIdList.Count());                end;                PrevLocalTableID := TempCRMSynchConflictBuffer."Table ID";            end;            LocalIdList.Add(TempCRMSynchConflictBuffer."Integration ID");        until TempCRMSynchConflictBuffer.Next() = 0;        UncoupleLocalRecords(PrevLocalTableID, LocalIdList);    end;    local procedure UncoupleLocalRecords(LocalTableId: Integer; var LocalIdList: List of [Guid])    var        CRMIntegrationManagement: Codeunit "CRM Integration Management";    begin        if LocalTableId = 0 then            exit;        if LocalIdList.Count() = 0 then            exit;        CRMIntegrationManagement.RemoveCoupling(LocalTableId, LocalIdList);    end;    local procedure GetLocalRecordId(var IntegrationSynchJobErrors: Record "Integration Synch. Job Errors"; var LocalRecordID: RecordID): Boolean    var        TableMetadata: Record "Table Metadata";    begin        LocalRecordID := IntegrationSynchJobErrors."Source Record ID";        if LocalRecordID.TableNo() = 0 then            exit(false);        if not TableMetadata.Get(LocalRecordID.TableNo()) then            exit(false);        if TableMetadata.TableType = TableMetadata.TableType::Normal then            exit(true);        LocalRecordID := IntegrationSynchJobErrors."Destination Record ID";        if LocalRecordID.TableNo() = 0 then            exit(false);        exit(true);    end;    [IntegrationEvent(false, false)]    local procedure OnIsDataIntegrationEnabled(var IsIntegrationEnabled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnForceSynchronizeDataIntegration(LocalRecordID: RecordID; var SynchronizeHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    procedure OnForceSynchronizeRecords(var LocalRecordIdList: List of [RecordId]; var SynchronizeHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnAfterLogSynchError(IntegrationSynchJobErrors: Record "Integration Synch. Job Errors")    begin    end;}