E-ES: Real Time Indexing (RTI) Does Not Work for Indexes That Have the 'Include Attachments' Checkbox Selected and There Are Attachments Added to the Transaction Tables
(Doc ID 2927967.1)
Last updated on NOVEMBER 30, 2023
Applies to:
PeopleSoft Enterprise PT PeopleTools - Version 8.59 to 8.59 [Release 8.4]Information in this document applies to any platform.
Symptoms
Real Time Indexing (RTI) does not work for indexes that have the 'Include Attachments' checkbox selected in RTI Configuration (PeopleTools > Search Framework > Real Time Indexing > Configure Real Time Indexing), and there are attachments added to the transaction tables.
When the Search Definition is configured for RTI and the 'Include Attachments' is selected, if there are attachments in the corresponding application's attachments table, regardless if the attachments are related or not to the document being indexed, RTI errors out and the results in Global Search are not current (reflecting recent updates).
It does seem that, when processing the attachments, RTI is getting all the attachments in the tables, regardless if they are related to the document being indexed.
The issue is reproduced in the customer environment with the steps below:
[Note: In the example below, the impacted index is EP_AP_VENDOR]
1. Setup RTI for index EP_AP_VENDOR.
2. Add a new vendor or modify an existing one.
3. Go to Homepage and use the Global Search field to perform a search for that vendor.
4. Note that the new vendor does not show up on the search results.
In the log file APPSRV_MMDD.LOG for PSRTISRV (<PS_CFG_HOME>/appserv/prcs/<domain_name>/LOGS/APPSRV_mmdd.log), for one of the documents being indexed, the following error is logged:
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |