My Oracle Support Banner

E-UPG: MSSNEWTYPE_ALTER.SQL Error: Cannot insert the value NULL into column 'ADDR_LN2', table (Doc ID 1320470.1)

Last updated on APRIL 26, 2018

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.50 and later
Information in this document applies to any platform.

Symptoms


 

Upgrading from version 9.0 application to 9.1 application, in the (test) move to production pass

When attempting to run the Microsoft Conversion script MSSNEWTYPE_ALTER.SQL,
the an error similar to the following occurs:

ERROR
-----------------------
Cannot insert the value NULL into column 'ADDR_LN2', table
'FS9PRD.dbo.PSYBI_EXTRCT'; column does not allow nulls. INSERT fails.



The script,  MSSNEWTYPE_ALTER.SQL, has the purpose to alter the records in the MSSNEWTYPE
project. The generated script will alter the tables with the new data types.

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!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.