ELM 9.2: Upgrade Data Conversion Fails Cannot Insert Null, Step UPG_LM90.HCLML003.InsCtnr (Doc ID 2091715.1)

Last updated on JULY 03, 2017

Applies to:

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

Symptoms

 ELM 9.2 Upgrade Data Conversion Fails; Cannot Insert Null, Step UPG_LM90.HCLML003.InsCtnr

 

Error:

PeopleTools 8.54.09 - Application Engine Server
Copyright (c) 1988-2015 Oracle and/or its affiliates.
All Rights Reserved

PSAESRV started service request at 15.47.05 2015-12-09

'PTIADATACONV' RunID: 2 ThreadID: 2 started at 2015-12-09-15.47.05.000000 (274,2)

'HCLML003' 'InsTaoA' 0 rows inserted into 'PS_UPG_LMLPDTTAO' (18030,4)

'HCLML003' 'InsTaoB' 0 rows inserted into 'PS_UPG_LMLPDTTAO' (18030,4)

'HCLML003' 'InsTaoC' 0 rows inserted into 'PS_UPG_LMLPDTTAO' (18030,4)

'HCLML003' 'InsLPLN' 0 rows inserted into 'PS_LM_LPLN' (18030,4)

'HCLML003' 'InsLpLrn' 0 rows inserted into 'PS_LM_LPLN_LRN' (18030,4)

'HCLML003' 'UpLPLNID' 0 rows updated on 'PS_UPG_LMLPDTTAO' (18030,3)

'HCLML003' 'UpdAsgBy' 0 rows updated on 'PS_UPG_LMLPDTTAO' (18030,3)

'HCLML003' 'InLpDTL' 0 rows inserted into 'PS_LM_LPLN_DTL' (18030,4)

File: /vob/peopletools/src/psappeng/aedebug.hSQL error. Stmt #: 1703 Error Position: 47 Return: 1400 - ORA-01400: cannot insert NULL into ("SYSADM"."PS_LM_LPLN_CTR"."LM_LPLN_ID")
Failed SQL stmt: INSERT INTO PS_LM_LPLN_CTR (LM_LPLN_ID) SELECT MAX(LM_LPLN_ID) FROM PS_LM_LPLN

Process 198260 ABENDED at Step UPG_LM90.HCLML003.InsCtnr (SQL) -- RC = 1400 (108,524)

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

PSAESRV completed service request at 15.47.08 2015-12-09

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