EGL9.2 - Receive Error "Cannot Insert The Value NULL Into Column 'EOAW_PUSH_EXURL' " While Performing Data Conversion (Doc ID 1965524.1)

Last updated on MARCH 14, 2017

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

Issue:
-------
Data Conversion abended during Upgrade.

Error Message:
----------------------

File: e:\pt85317c-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1625 Error Position: 0 Return: 8601 - [Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot insert the value NULL into column 'EOAW_PUSH_EXURL', table 'FS92TR3.dbo.PS_EOAW_NOT_USER'; column does not allow nulls. INSERT fails.
[Microsoft][SQL Server Native Client 10.0][SQL Server]The s
Failed SQL stmt: INSERT INTO PS_EOAW_NOT_USER (EOAWPRCS_ID , EOAWLEVEL , EOAWEVENT , EOAWPARTICIPANT , EOAWUSER_LIST_ID , EOAWCHANNEL , WL_TEMPLATE_ID , MENUNAME , EOAWAPPR_COMPONENT , PAGE_NAME , EOAWMENU_ACTION , SQLID , WL_PRIORITY , EOAWNUMBER_HOURS , EOAWNOTIFY_INTERVL , EOAWMAX_SEND) SELECT PTAFPRCS_ID , PTAFLEVEL , PTAFEVENT , PTAFPARTICIPANT , PTAFUSER_LIST_ID , PTAFCHANNEL , WL_TEMPLATE_ID , ' ' , ' ' , ' ' , 'U' , ' ' , '2' , 0 , 0 , 1 FROM PS_PTAFAW_NOT_USER

Process 867161 ABENDED at Step UPG_SAC_SPR.Registry.Step01 (SQL) -- RC = 8601 (108,524)
Process %s ABENDED at Step %s.%s.%s (Action %s) -- RC = %s

Steps:
---------
Run Data Conversion

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