E-UPG/E-CA: Alter failed due to an unknown column type (NVARCHAR) found for field (76,22) (Doc ID 1596808.1)

Last updated on JUNE 15, 2016

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.53 and later
Information in this document applies to any platform.
***Checked for relevance on 02-Jun-2015***

Goal

During a PeopleTools upgrade from PT 8.51.09 to PT 8.53.04, in step to Generate the Updated PeopleTools Script, receiving an error: 

 

Alter failed due to an unknown column type (NVARCHAR) found for field.


The upgrade for two previous environments did not give this error.  We are receiving this error for approximately 370 tables.  When we check the data type of particular column in the Application Designer, it is not NVARCHAR rather it is CHAR.   We also tried to alter the individual record directly in Application Designer and received the same error message. 

Log files show the following

Alter failed due to an unknown column type (NVARCHAR) found for field PTADSNAME. (76,22)...

 

LOG FILE
   -----------------------
   Filename =BuildPPLTLS84CURTables.log
   See the following error:
QL Build process began on 10/09/2013 at 10:27:50 AM for database FS853UAT.
Warning: MCF_IM_DEMO_REC.MCF_IMUSERID - Default record.field MCF_IM_DEMO_REC.USER_OPRID has no rows, field type default used. (76,66)
Error: PSADSDEFN - Alter failed due to an unknown column type (NVARCHAR) found for field PTADSNAME. (76,22)
Error: Fatal error in function BldAlter on call to function GetOldRecDefn.  Return code = 1. (76,6)
Error: PSADSDEFNITEM - Alter failed due to an unknown column type (NVARCHAR) found for field PTADSNAME. (76,22)
Error: Fatal error in function BldAlter on call to function GetOldRecDefn.  Return code = 1. (76,6)


Solution

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