SES Search Index-Unique Constraint Error for LS_LM_ACT_CI,LS_LM_PRG

(Doc ID 2053202.1)

Last updated on FEBRUARY 23, 2017

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 attempting to Run LS_LM_ACT_CI,LS_LM_PRG the following error occurs.

ERROR

Starting program PTSF_GENFEED (35,36)

Process PTFPSESARCH completed successfully. (158,2801)

'CrseDel' 'Step01' 0 rows deleted on 'PS_PS_LM_SRCH_CICG_TB' (18030,6)

'CrseDel' 'Step02' 0 rows deleted on 'PS_PS_LM_SRCH_CICGLTB' (18030,6)

File: /vob/peopletools/src/psappeng/aedebug.hSQL error. Stmt #: 1623 Error Position: 0 Return: 805 - ORA-00001: unique constraint (SYSADM.PS_LM_SRCH_CICG_TB) violated
Failed SQL stmt: INSERT INTO PS_LM_SRCH_CICG_TB (LM_CI_ID, LM_CATG_ID, LM_CATG_ID_1, LM_CATG_ID_2, LM_CATG_ID_3, LM_CATG_ID_4, LM_CATG_ID_5, LM_CATG_ID_6, LM_CATG_ID_7, LM_CATG_ID_8, LM_CATG_ID_9, LM_CATG_NAME_ALL) SELECT LVW.LM_CI_ID, LVW.LM_CATG_ID, LVW.LM_CATG_ID_1, LVW.LM_CATG_ID_2, LVW.LM_CATG_ID_3, LVW.LM_CATG_ID_4, LVW.LM_CATG_ID_5, LVW.LM_CATG_ID_6, LVW.LM_CATG_ID_7, LVW.LM_CATG_ID_8, LVW.LM_CATG_ID_9, LVW.LM_CATG_NAME_ALL FROM PS_LM_SRCGCI_0X_VW LVW WHERE EXISTS ( SELECT 1 FROM PS_LM_CI_CTG_TAO1 X WHERE LVW.LM_CI_ID = X.LM_CI_ID )

Process 5957 ABENDED at Step LM_CATG_LVL.CrseBASE.NoCatg (SQL) -- RC = 805 (108,524)

Process %s ABENDED at Step %s.%s.%s (Action %s) -- RC = %s

PSAESRV completed service request at 09.46.11 2015-04-28



Cause

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 hundreds of Community platforms