My Oracle Support Banner

ELM 9.2: PTSF_GENFEED (LS_LM_ACT_CI Search Defn) Failing with Unique Constraint Error Message (Doc ID 2416289.1)

Last updated on JULY 16, 2018

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

After ELM 9.2 PUM #17,  Rebuild Index Incremental  LS_LM_ACT_CI search definition (AE PTSF_GENFEED), failing  with Unique constraint error message.
 

ERROR

SQL error. Stmt #: 1725  Error Position: 0  Return: 805 - ORA-00001: unique constraint (SYSADM.PS_LM_SRCH_DT1_TBL) violated Failed SQL stmt: INSERT INTO PS_LM_SRCH_DT1_TBL (LM_ACT_ID , LM_CI_ID , LM_ROW_MAINT_DTTM) SELECT EL G.LM_ACT_ID , ELG.LM_CI_ID , CAST(SYSSTAMP AS TIMESTAMP) FROM PS_LM_SRCH_EVENTVW ELG WHERE ELG.L M_UPCOMING_DAYS > 0 AND NOT EXISTS ( SELECT 1 FROM PS_LM_SRCHLSTRUNVW SRC WHERE SRC.LM_ACT_ID = ELG. LM_ACT_ID AND SRC.LM_UPCOMING_DAYS = ELG.LM_UPCOMING_DAYS) AND NOT EXISTS ( SELECT 'X' FROM PS_LM_SR CH_DT1_TBL DT1 WHERE DT1.LM_ACT_ID = ELG.LM_ACT_ID AND DT1.LM_CI_ID = ELG.LM_CI_ID)



Steps to Replicate Issue: 

1. Log in as Administrator
2. Navigate to Main Menu> Enterprise Learning > Catalog > Rebuild Index
3. Create a run control  for Incremental LS_LM_ACT_CI search definition
4.  Submit Run for Process AE PTSF_GENFEED and fail with error message.

Changes

What specific scenario that is causing the issue has not been identified

 

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!


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