Alternatives to View Journal

Question

Question

Arto Alatalo · Mar 10, 2022

Is View Journal of Cache Management Portal the only way to search in Cache journals? I need a way to define several search conditions and Portal often breaks on http timeout.

Discussion (6)3

Log in or sign up to continue

Hans-Peter Iten · Mar 14, 2022

You could also use the class %SYS.Journal.File

Example:
Set JournalFile = ##class(%SYS.Journal.File).%OpenId(EXISTING_JOURNAL_FILE)
Set JournalRecord = JournalFile.FirstRecordGet()
While (JournalRecord '= "") {
Here you can program your search criteria example:
If JournalRecord.%IsA("%SYS.Journal.SetKillRecord") {
insert your code
}
}

Check documentation for further hints.

2 0

score 1 · Answer 1 · 2022-03-10T06:04:49-05:00

Robert Cemper · Mar 10, 2022

in namespace %SYS you may run DO ^JRNDUMP from the terminal prompt

1 0

score 0 · Answer 2 · 2022-03-10T06:44:15-05:00

Arto Alatalo · Mar 10, 2022

Hi Robert,

JRNDUMP does solve the timeout issue, but searching with it looks really challenging.

0 0

score 1 · Answer 3 · 2022-03-10T07:31:34-05:00

There's documentation and examples for searching using JRNDUMP here. Using SELECT^JRNDUMP is very handy to find a specific address(es) which you can then jump straight to in the Management Portal to get a view of what else was going on around that particular entry.

score 0 · Answer 4 · 2022-03-10T07:35:50-05:00

Arto Alatalo · Mar 10, 2022

Oh, thank you, that looks promising

0 0

score 0 · Answer 5 · 2022-03-14T11:13:11-04:00

Journal files are also exposed as SQL (readonly) tables. In theory, you could write SQL statements to search/filter.