Getting An ORA-01400 Error Message When Running The LS_LM_ACT_CI Search Index (Doc ID 2188721.1)

Last updated on OCTOBER 04, 2016

Applies to:

PeopleSoft Enterprise ELM Enterprise Learning Management - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

Getting an ORA-01400 error message when running LS_LM_ACT_CI search index.

File: /vob/peopletools/src/psappeng/aedebug.hSQL error. Stmt #: 1723 Error Position: 594 Return: 1 400 - ORA-01400: cannot insert NULL into ("SYSADM"."PS_LM_CATG_ALL_TBL"."LM_CATG_NAME_LVL3") Failed SQL stmt: INSERT INTO PS_LM_CATG_ALL_TBL (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_LVL0 , LM_CATG_NAME_LVL1 , LM_CATG_NAME_LVL2 , LM_CATG_NAME_LVL3 , LM_CATG_NAME_LVL4 , LM_ CATG_NAME_LVL5 , LM_CATG_NAME_LVL6 , LM_CATG_NAME_LVL7 , LM_CATG_NAME_LVL8 , LM_CATG_NAME_LVL9) SELE CT 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_I D_6 , LM_CATG_ID_7 , LM_CATG_ID_8 , LM_CATG_ID_9 , LM_CATG_NAME_LVL0 , LM_CATG_NAME_LVL1 , LM_CATG_N AME_LVL2 , LM_CATG_NAME_LVL3 , LM_CATG_NAME_LVL4 , LM_CATG_NAME_LVL5 , LM_CATG_NAME_LVL6 , LM_CATG_N

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Logged in as Administrator
2. Rebuild the index from Navigator > Enterprise Learning > Catalog > Rebuild index
3. Search and select index LS_LM_ACT_CI
4. Enter Run Control Data and click Run button and notice Index failed with error message

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