ELM 9.2: Elastic Search Is Not Working for Find Learning: "Search Exception: Recovered [0] indices/types (262,2018)" and in the Application Engine Log: "ORA-00942: table or view does not exist Failed SQL stmt: INSERT INTO PS_LM_SRCH_CICG_TB"
(Doc ID 2913933.1)
Last updated on AUGUST 01, 2024
Applies to:
PeopleSoft Enterprise ELM Enterprise Learning Management - Version 9.2 to 9.2 [Release 9]Information in this document applies to any platform.
Symptoms
When running the Full Search Index LS_LM_ACT_CI_FL, the below error message is captured in the Application Engine PTSF_GENFEED Log File :
The issue can be reproduced at will with the following steps:
1. Log in as a Learner.
2. Navigate to Menu -> Learning Home -> Click Find Learning.
3. Receive an error message.
4. Then, log in as User with Learning Environment Administrator role.
5. Navigate to Enterprise Learning > Catalog > Rebuild Indexes > {add run control to rebuild index full index for LS_LM_ACT_CI_FL}.
6. Run Process AE PTSF_GENFEED and receive SQL error message in the AE Log File
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 |