ELM 9.2: When Building KIBANA Indices (Indexes) LM_ACT_ENRLMNTS, LM_DR_LEARNING, LM_DR_RGSTNS and LM_PRG_RGSTNS with Database MS SQL Server, Receive Error Message: 'GREATEST' is Not a Recognized Built-in Function Name.
(Doc ID 2902344.1)
Last updated on SEPTEMBER 19, 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.
Symptoms
When building KIBANA indices (Indexes) LM_ACT_ENRLMNTS, LM_DR_LEARNING, LM_DR_RGSTNS and LM_PRG_RGSTNS using Application Engine PTSF_GENFEED, the job abends with an error message.
The issue can be reproduced at will with the following steps:
1. Log in as a PS Administrator and ensure that the indices LM_ACT_ENRLMNTS, LM_DR_LEARNING, LM_DR_RGSTNS and LM_PRG_RGSTNS are deployed:
Navigation: Peopletools > Search Framework > Administration >Deploy Search Objects
2. Navigate to Peopletools > Search Framework > Administration >Schedule Search Index
and then add a run control for the Index such as LM_ACT_ENRLMNTS
3. {check} Index Type checkbox - Full index and Language Option - Base Language and click Run.
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 |