EAP: Performance Issues Running EP_AP_VOUCHER Elastic Search Index on Tools 8.58
(Doc ID 2749174.1)
Last updated on MARCH 02, 2023
Applies to:
PeopleSoft Enterprise FIN Payables - Version 9.2 to 9.2 [Release 9]Information in this document applies to any platform.
Symptoms
Unable to complete the indexing on vouchers into Elastic Search due to complexities of the queries and the amount of data. Until the indexes created, unable to use Kibana analytics on vouchers on PT 8.58.05, ES 7.0
There are approximately 27 million rows of voucher documents. Trying to index the vouchers the Elastic Search times out. Creating the indexes once was successful but it took 3 days. However, have not been able to subsequently recreate the index (limited the search definition to limit the data to the last 10 days but it still has not been able to finish the index).
Tried to index EP_AP_VOUCHER to Only Last 1 day. This took 1.5 hours and only indexed 13 rows.
STEPS
1. Setup indexing for EP_AP_VOUCHER = Last 1 day
2. Process took 1.5 hours and only indexed 13 rows
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 |