ELM 9.2:PTSF_GENFEED is Going Intermittently No Success with the Error Message "ORA-00001: unique constraint (SYSADM.PS_LM_SRCH_PGCG_TB) violated"
(Doc ID 3036384.1)
Last updated on JULY 26, 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
PTSF_GENFEED process is failing intermittently in ELM.
This happens for several days where instances of the process PTSF_GENFEED generated a no success result, with this happening to two different run controls and always at the same hour.
File: E:\PT859P04B_2108160501-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1811 Error Position: 0 Return: 805 - ORA-00001: unique constraint (SYSADM.PS_LM_SRCH_PGCG_TB) violated
Failed SQL stmt: INSERT INTO PS_LM_SRCH_PGCG_TB (LM_PRG_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_PRG_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_SRCGPG_0X_VW LVW WHERE EXISTS ( SELECT 1 FROM PS_LM_PG_CTG_TAO2 X WHERE LVW.LM_PRG_ID = X.LM_PRG_ID )
Process 77322 ABENDED at Step LM_CATG_LVL.ProgBASE.NoCatg (SQL) -- RC = 805 (108,524)
Process %s ABENDED at Step %s.%s.%s (Action %s) -- RC = %s
PSAESRV completed service request at 23.00.08 2024-06-24
Failed SQL stmt: INSERT INTO PS_LM_SRCH_PGCG_TB (LM_PRG_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_PRG_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_SRCGPG_0X_VW LVW WHERE EXISTS ( SELECT 1 FROM PS_LM_PG_CTG_TAO2 X WHERE LVW.LM_PRG_ID = X.LM_PRG_ID )
Process 77322 ABENDED at Step LM_CATG_LVL.ProgBASE.NoCatg (SQL) -- RC = 805 (108,524)
Process %s ABENDED at Step %s.%s.%s (Action %s) -- RC = %s
PSAESRV completed service request at 23.00.08 2024-06-24
Steps to reproduce the issue:
1. Check the Process Monitor page.
PeopleTools > Process Scheduler > Process Monitor.
2. Notice a instance of the PTSF_GENFEED has Status No Success.
3. The next instances have the Status Success.
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 |
| Cause |
| Solution |