Real-Time Indexing Stuck Off

This alert triggers when Real-Time Indexing has been switched off for a search definition in PTSF_RTI_STATUS and no index build is running.
Categories:
New to psLens? This page documents one specific alert. To see how it appears on the dashboard, what operators investigate, and how teams tune it, start with a live walkthrough.
Book a Demo Browse Alerts
Tailored Operational Context
  • Target Database: —
  • Context Type: —
  • Alert Severity: —
  • Triggered Time: —
  • Firing Context: —
  • Contextual SQL: 
    —

Real-Time Indexing Stuck Off Alert

Alert ID: rti_stuck_disabled Category: Search Framework Default threshold: 60 minutes Runs: every 15 minutes

What This Alert Detects

A search definition with Real-Time Indexing configured has a switch in PTSF_RTI_STATUS that turns it off temporarily. An index build turns the switch off while it runs and back on when it finishes. A batch job can do the same around a bulk change.

This alert triggers when the switch has been off for longer than the threshold and no index build is queued or running. That usually means a job turned Real-Time Indexing off and ended before turning it back on. Until someone turns it on again, changes to the indexed records do not reach the search engine.

Severity Logic

ConditionSeverity
Switched off for at least thresholdMinutes, and no PTSF_GENFEED request is activeWarning

There is one alert item per search definition.

What Gets Checked

  1. PTSF_RTI_STATUS rows with PTRTISTATUS = 0.
  2. Of those, the definitions that have Real-Time Indexing configured on (PTSF_INDEX.PTSF_RTI = 'Y'). A definition that does not use Real-Time Indexing is ignored.
  3. The time since PTRTISWDTTM, measured against the database server’s clock.
  4. Whether a PTSF_GENFEED process request is queued, running, or pending in PSPRCSRQST. If one is, the alert stays quiet.

Alert Details

Each alert item includes:

  • The search definition
  • When Real-Time Indexing was switched off, and how many minutes ago
  • A link to the search definition’s detail page

Configuration

alerts:
  checks:
    rti_stuck_disabled:
      enabled: true
      thresholdMinutes: 60    # Minutes switched off before alerting
SettingDefaultDescription
thresholdMinutes60Minutes Real-Time Indexing can stay switched off before alerting

Raise the threshold if your batch window turns Real-Time Indexing off for longer than an hour without running an index build.

How to Respond

  1. Open the search definition and switch on Real-Time & Incremental Indexing to confirm the status.
  2. Check Process Monitor for an index build or batch job that failed around the time shown in the alert.
  3. Turn Real-Time Indexing back on for the definition in PeopleSoft.
  4. Run an incremental index build for the definition. Changes made while Real-Time Indexing was off were not queued.

Required Tables

PTSF_RTI_STATUS and PTSF_INDEX. Without either the alert is inactive.