E-PORTAL: Running 'UPD869230_01_imp.dms' for Portal Upgrade Errors Out (Doc ID 1682504.1)

Last updated on JUNE 16, 2014

Applies to:

PeopleSoft Enterprise PRTL Interaction Hub - Version 9.1 and later
Information in this document applies to any platform.

Symptoms

Customer is running the template PS910_MP2 to update the portal database.  In the step for "Additional Step 02", one script failed during the execution:

UPD869230_01_imp.dms when executed had the following problem:

=================================================
File: Data MoverSQL error. Stmt #: 0  Error Position: 0  Return: 1400 - ORA-01400: cannot insert NULL into ("SYSADM"."PS_PTAI_LIST"."OBJECTOWNERID")
Failed SQL stmt: INSERT INTO PS_PTAI_LIST  (PTAI_LIST_ID, PORTAL_NAME, PTAI_LABEL, PTAI_DESCRLONG, PTAI_NOTIFY_TYPE, PTAI_ACTIVE_FLG, CREATED_DTTM, CREATEOPRID, LAST_UPDATE_DTTM, LASTUPDOPRID, PTAI_IS_TMPL, PTAI_PARENT_TMPL, PTAI_LIST_STATUS, PACKAGEROOT, QUALIFYPATH, APPCLASSID, APPCLASSMETHOD, PTAI_INST_PKGROOT, PTAI_INST_QUALPATH, PTAI_INST_CLASSID, URL, PTAI_REOPEN_ITEM, PTAI_PGLT_EXCL, PTAI_FIELD1_LBL, PTAI_FIELD2_LBL, PTAI_FIELD3_LBL, PTAI_FIELD4_LBL, PTAI_FIELD5_LBL, PTAI_FIELD6_LBL, PTAI_FIELD7_LBL, PTAI_FIELD8_LBL, PTAI_FIELD9_LBL, PTAI_FIELD10_LBL, PTAI_PGLT_EXIT, PTAI_PREPROC_METH, PTAI_PGLT_SAVE, PTAI_INST_PROC) VALUES (:1, :2, :3, :4, :5, :6, TO_TIMESTAMP(:7,'YYYY-MM-DD-HH24.MI.SS.FF'), :8, TO_TIMESTAMP(:9,'YYYY-MM-DD-HH24.MI.SS.FF'), :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25, :26, :27, :28, :29, :30, :31, :32, :33, :34, :35, :36, :37)

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