My Oracle Support Banner

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 FEBRUARY 07, 2023

Applies to:

PeopleSoft Enterprise ELM Enterprise Learning Management - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.


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




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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.