OnDemand User Group

Support Forums => Other => Topic started by: JFHall on June 15, 2021, 10:24:41 PM

Title: Is System Log data stored in DB only or in Cache?
Post by: JFHall on June 15, 2021, 10:24:41 PM

Does anyone know if the System Log data is stored in the DB only?  Or does index information get stored in the DB and data in a cache file system like with a normal report application?

Title: Re: Is System Log data stored in DB only or in Cache?
Post by: Darrell Bryant on June 16, 2021, 07:19:50 AM

Any System Log message that has View = Yes has an associated data object in Cache. You should always cache the System Log for at least 1 day so that it can append multiple data objects together in cache.

Title: Re: Is System Log data stored in DB only or in Cache?
Post by: JFHall on June 16, 2021, 10:22:48 PM

I searched for %View% in the Message of the System Log for the last 6 months and got no hits.  I guess I can reasonably assume, therefore, that my installation stores all the System Log messages in the DB alone, with no data in the cache file systems.

Title: Re: Is System Log data stored in DB only or in Cache?
Post by: Darrell Bryant on June 17, 2021, 05:32:41 AM

When you open the system log in the OnDemand client, there is a column named View. If the value in that column is Yes, the message has a document associated with it.

Title: Re: Is System Log data stored in DB only or in Cache?
Post by: JFHall on June 17, 2021, 10:42:58 PM

Oh, gotcha now.  Yes, I definitely have System Log data in cache in that case.  Thank you for spelling it out for this newbie.  :-)

Title: Re: Is System Log data stored in DB only or in Cache?
Post by: Norbert Novotny on June 21, 2021, 08:08:53 AM

Just a side note: as Darrell mentioned: "Log message that has View = Yes". and this concern only the output information, not the complete system log record. Probably the most common is output of "arsload -v" or "arsmaint", but there are others as well.

However, all other (complete) information found in System log is *DB only*.
With a help of "arslog - OnDemand User Exit Logging Facility" you could push the messages to a file.

Cheers,
 N.