Table 474 Job Queue Log Entry
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;}