CS 9.0 Bundle 33 UPD905422_MSG_I.DMS Load Fails With ORA-12899 (Doc ID 1913537.1)

Last updated on NOVEMBER 25, 2015

Applies to:

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

Symptoms

While loading Bundle 33, fails at import message catalog step with the following error:


ERROR
--------
SQL Error. Error Position: 119 Return: 12899 - ORA-12899: value too large for column "SYSADM"."PSMSGCATDEFN"."MESSAGE_TEXT" (actual: 101, maximum: 100)
INSERT INTO PSMSGCATDEFN (MESSAGE_SET_NBR, MESSAGE_NBR, MESSAGE_TEXT, MSG_SEVERITY, LAST_UPDATE_DTTM) VALUES (:1, :2, :3, :4, TO_TIMESTAMP(:5,'YYYY-MM-DD-HH24.MI.SS.FF'))
Error: Unable to insert row 226
Error: SQL execute error for PSMSGCATDEFN

STEPS
-------
The issue can be reproduced at will with the following steps:
upd905422_msg_i.dms / upd905422_msg.dat
1. SET LOG \upd905422_msg_i.log;
2. SET INPUT \data\upd905422_msg.dat;
3. SET UPDATE_DUPS;
4. IMPORT *;
5. UPDATE PSMSGSETDEFN SET VERSION = 1 WHERE VERSION >
 (SELECT VERSION from PSVERSION WHERE OBJECTTYPENAME = 'PPC');
6. UPDATE PSSTATUS SET LASTREFRESHDTTM = %currentdatetimein;

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