Table 474 Job Queue Log Entry

Base Application, System.Threading

src/Layers/W1/BaseApp/Modules/System/JobQueue/JobQueueLogEntry.Table.al269 lines, Copyright (c) Microsoft Corporation. MIT

namespace System.Threading;using System.Reflection;using System.Security.AccessControl;using System.Utilities;table 474 "Job Queue Log Entry"{    Caption = 'Job Queue Log Entry';    ReplicateData = false;    CompressionType = Page;    DataClassification = CustomerContent;    fields    {        field(1; "Entry No."; Integer)        {            AutoIncrement = true;            Caption = 'Entry No.';        }        field(2; ID; Guid)        {            Caption = 'ID';        }        field(3; "User ID"; Text[65])        {            Caption = 'User ID';            DataClassification = EndUserIdentifiableInformation;            TableRelation = User."User Name";        }        field(4; "Start Date/Time"; DateTime)        {            Caption = 'Start Date/Time';        }        field(5; "End Date/Time"; DateTime)        {            Caption = 'End Date/Time';        }        field(6; "Object Type to Run"; Option)        {            Caption = 'Object Type to Run';            OptionCaption = ',,,Report,,Codeunit';            OptionMembers = ,,,"Report",,"Codeunit";        }        field(7; "Object ID to Run"; Integer)        {            Caption = 'Object ID to Run';        }        field(8; "Object Caption to Run"; Text[250])        {            CalcFormula = lookup(AllObjWithCaption."Object Caption" where("Object Type" = field("Object Type to Run"),                                                                           "Object ID" = field("Object ID to Run")));            Caption = 'Object Caption to Run';            FieldClass = FlowField;        }        field(9; Status; Option)        {            Caption = 'Status';            OptionCaption = 'Success,In Process,Error';            OptionMembers = Success,"In Process",Error;        }        field(10; Description; Text[250])        {            Caption = 'Description';        }        field(11; "Error Message"; Text[2048])        {            Caption = 'Error Message';        }        field(17; "Job Queue Category Code"; Code[10])        {            Caption = 'Job Queue Category Code';            TableRelation = "Job Queue Category";            ValidateTableRelation = false;        }        field(18; "Error Call Stack"; BLOB)        {            Caption = 'Error Call Stack';            DataClassification = SystemMetadata;        }        field(19; "Parameter String"; Text[250])        {            Caption = 'Parameter String';        }        field(20; "Error Message Register Id"; Guid)        {            Caption = 'Error Message Register Id';            DataClassification = SystemMetadata;            TableRelation = "Error Message Register".ID;        }        field(21; "XML"; Blob)        {            Caption = 'XML';        }        field(22; "System Task Id"; Guid)        {            Caption = 'System Task Id';            DataClassification = SystemMetadata;        }        field(32; "User Session ID"; Integer)        {            Caption = 'User Session ID';            DataClassification = EndUserPseudonymousIdentifiers;        }        field(40; "User Service Instance ID"; Integer)        {            Caption = 'User Service Instance ID';            DataClassification = EndUserPseudonymousIdentifiers;        }    }    keys    {        key(Key1; "Entry No.")        {            Clustered = true;        }        key(Key2; ID, Status)        {        }        key(Key3; "Start Date/Time", ID)        {        }        key(Key4; Status)        {        }        key(Key5; "Object Type to Run", "Object ID to Run", Status)        {        }    }    fieldgroups    {    }    var        NoErrorMessageTxt: Label 'There is no error message.';        ConfirmDeletingEntriesQst: Label 'Are you sure that you want to delete job queue log entries?';        ErrorMessageMarkedByTxt: Label 'Marked as an error by %1.', Comment = '%1 = User id';        OnlyEntriesInProgressCanBeMarkedErr: Label 'Only entries with the status In Progress can be marked as errors.';        DeletingMsg: Label 'Deleting Entries...';        DeletedMsg: Label 'Entries have been deleted.';        Window: Dialog;    procedure DeleteEntries(DaysOld: Integer)    var        SkipConfirm: Boolean;    begin        SkipConfirm := false;        OnBeforeDeleteEntries(Rec, SkipConfirm);        if not SkipConfirm then            if not Confirm(ConfirmDeletingEntriesQst) then                exit;        Window.Open(DeletingMsg);        SetFilter(Status, '<>%1', Status::"In Process");        if DaysOld > 0 then            SetFilter("End Date/Time", '<=%1', CreateDateTime(Today - DaysOld, Time));        OnDeleteEntriesOnBeforeDeleteAll(Rec);        DeleteAll();        Window.Close();        SetRange("End Date/Time");        SetRange(Status);        Message(DeletedMsg);    end;    procedure ShowErrorMessage()    var        ErrorMessage: Record "Error Message";        ErrorMessages: Page "Error Messages";    begin        ErrorMessage.SetRange("Register ID", "Error Message Register Id");        if ErrorMessage.FindSet() then begin            ErrorMessages.SetRecords(ErrorMessage);            ErrorMessages.Run();        end else            if "Error Message" = '' then                Message(NoErrorMessageTxt)            else                Message("Error Message");    end;    procedure ShowErrorCallStack()    begin        if Status = Status::Error then            Message(GetErrorCallStack());    end;    procedure MarkAsError()    var        JobQueueEntry: Record "Job Queue Entry";        ErrorMessage: Text;    begin        if Status <> Status::"In Process" then            Error(OnlyEntriesInProgressCanBeMarkedErr);        ErrorMessage := StrSubstNo(ErrorMessageMarkedByTxt, UserId);        OnBeforeMarkAsError(Rec, JobQueueEntry, ErrorMessage);        if JobQueueEntry.Get(ID) then            JobQueueEntry.SetError(ErrorMessage);        Status := Status::Error;        "Error Message" := CopyStr(ErrorMessage, 1, 2048);        Modify();    end;    procedure Duration(): Duration    begin        if ("Start Date/Time" = 0DT) or ("End Date/Time" = 0DT) then            exit(0);        exit(Round("End Date/Time" - "Start Date/Time", 100));    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeDeleteEntries(var JobQueueLogEntry: Record "Job Queue Log Entry"; var SkipConfirm: Boolean);    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeMarkAsError(var JobQueueLogEntry: Record "Job Queue Log Entry"; var JobQueueEntry: Record "Job Queue Entry"; var ErrorMessage: Text)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnDeleteEntriesOnBeforeDeleteAll(var JobQueueLogEntry: Record "Job Queue Log Entry");    begin    end;    procedure SetErrorCallStack(NewCallStack: Text)    var        OutStream: OutStream;    begin        "Error Call Stack".CreateOutStream(OutStream, TEXTENCODING::Windows);        OutStream.Write(NewCallStack);    end;    procedure GetErrorCallStack(): Text    var        TempBlob: Codeunit "Temp Blob";        InStream: InStream;    begin        TempBlob.FromRecord(Rec, FieldNo("Error Call Stack"));        TempBlob.CreateInStream(InStream, TEXTENCODING::Windows);        exit(ReadAsTextWithSeparator(InStream));    end;    local procedure ReadAsTextWithSeparator(InStream: InStream): Text    var        Tb: TextBuilder;        ContentLine: Text;        LineSeparator: Text;        CRLF: Text[2];    begin        CRLF[1] := 13; // Carriage return, '\r'        CRLF[2] := 10; // Line feed, '\n'        InStream.ReadText(ContentLine);        Tb.Append(ContentLine);        while not InStream.EOS do begin            InStream.ReadText(ContentLine);            Tb.Append(LineSeparator);            Tb.Append(ContentLine);        end;        exit(Tb.ToText());    end;}