When applying bundle, get ORA-12899: value too large for column Error "SYSADM"."PSPNLCNTRLDATA"."PTHDGROWACTBTNS" (actual: 3, maximum: 1) (Doc ID 1917677.1)

Last updated on AUGUST 08, 2017

Applies to:

PeopleSoft Enterprise CS Student Records - Version 9 to 9.2 [Release 9]
PeopleSoft Enterprise CS Campus Community - Version 9 to 9.2 [Release 9]
PeopleSoft Enterprise CS Student Administration - Version 9 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

ISSUE STATEMENT
---------------
Applying Bundle #33 to 8.52.11 installation. CopyUpdateProject errors with
 
ERROR
---------------
File: E:\pt85211b-retail\peopletools\src\pssys\pdmupd.cppSQL error. Stmt #: 2007 Error Position: 569 Return: 12899 - ORA-12899: value too large for column "SYSADM"."PSPNLCNTRLDATA"."PTHDGROWACTBTNS" (actual: 3, maximum: 1)
Failed SQL stmt:INSERT INTO PSPNLCNTRLDATA (PNLNAME, PNLFLDID, PTFINDSTRING, PTHDGSHOW, PTHDGROWACTBTNS, PTHDGROWACTALGN, PTHDGNAVBARBTNS , PTHDGNAVBARALGN, PTBAREASTYLENAME, PTBAREAROWACTALGN, PTBAREAHIDEROWSEP, PTBAREASHWGRDLINES , PTFTGSHOW, PTFTGSTYLENAME, PTFTGSHOWROWACT, PTFTGROWACTALGN, PTFTGSHOWNAVBAR, PTFTGNAVBARALGN , PTSEPSTARTOFFSET, PTSEPOCCURSOFFSET, PTBTNSTARTOFFSET, PTBTNOCCURSOFFSET, ALLOWMULTIROWINS, PTGRDLAYOUT, PTGRDSCROLLBAR , GRIDROWS, PTSMRYDFLTTOTITLE, PTSMRYLBLTYPE, PTSMRYMSGSET, PTSMRYMSGNUM, PTSMRYDSPLFORMAT, PTSUMMARYATTRIBUTE ) VALUES (:1,:2,'O',:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13,:14,:15,:16,:17,:18,:19,:20,:21,:22,:23,:24,:25,:26,:27,:28,:29,:30,:31)
System Error : PagesSSS_RS_CONS_TASK
Error - failure during Copy From File process.

WHAT IS WORKING
---------------
Issue seems to occur with just one Page.
 
ENVIRONMENT
---------------
DB Platform - N/A
Tools Version - 8.52
Application & Version - PeopleSoft Enterprise Campus Solutions release 9
System Name - N/A
 
STEPS
---------------
The issue can be reproduced with the following steps:
1. Apply Bundle #33 to a unicode environment.
2. Notice the above mentioned error occurs.
 
IMPACT
---------------
Bundle implementation impacted.

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