Table hl7listenerlog Is Too Large - HL7 Module - English - Foundation 22.1 - OnBase - Premier - external - Standard - Essential - Premier - Standard - Essential

HL7 Module
Platform
OnBase
Product
HL7 Module
Release
Foundation 22.1
License
Premier
Standard
Essential

The database table hl7listenerlog logs all messages received by the system. Depending on your environment, this table can grow to be very large. You can manage the size of the table by setting a limit on how long to retain logs.

CAUTION:

The process of setting a retention period and purging old logs can take a long time and may be highly resource intensive. Contact your first line of support before proceeding.

To configure the listener log retention period:

  1. In OnBase Configuration, select Medical | HL7 | Settings.
  2. In the Number of days to retain listener log field, enter the number of days after which old logs will be deleted. The entered value must be 0, 30, or greater than 30, because logs must be retained for at least 30 days. The default value is 365, meaning logs are retained for a year.
    Note:

    If you have upgraded from a version older than OnBase 17, the default value of the Number of days to retain listener log field is 0, meaning logs are retained indefinitely.

  3. Click Save. A message warns that enabling the listener log retention period may take a while to complete and can impact system performance.
  4. Click Yes to proceed and purge existing logs older than the retention period, or click No to exit without saving settings.
    Future logs will be automatically deleted after the configured retention period has passed.