Wednesday, September 3, 2014

PeopleSoft PeopleTools Upgrade from 8.51 to 8.53 - Issues

1. Running PeopleTools Data Conversion:
     *****************************
Beginning upgrade for feed definition ADMN_TL_APP2 (219,3336)
 Message Set Number: 219
 Message Number: 3336
 Message Reason: Beginning upgrade for feed definition ADMN_TL_APP2 (219,3336)
Upgrade for feed definition ADMN_TL_APP2 succeeded (219,3337)
 Message Set Number: 219
 Message Number: 3337
 Message Reason: Upgrade for feed definition ADMN_TL_APP2 succeeded (219,3337)
Section - UPD_MRO,  Step - UPD_SO,  0 rows updated on PSOPERATION (226,3)
 Message Set Number: 226
 Message Number: 3
 Message Reason: Section - UPD_MRO,  Step - UPD_SO,  0 rows updated on PSOPERATION (226,3)
'UPGPT852PTFP' Program Completed (226,5)
UPGPT852PTFP MAIN completed at 2014-05-18-00.33.00.000000 (226,35)
UPGPT851DBC MAIN completed at 2014-05-18-00.33.01.000000 (226,35)
File: E:\pt85312b-retail\peopletools\src\pssys\pcmget.cppSQL error. Stmt #: 2757  Error Position: 0  Return: 1653 - ORA-01653: unable to extend table SYSADM.PSPCMTXT by 1024 in tablespace PSIMAGE2

Failed SQL stmt: INSERT INTO PSPCMTXT (HASH_SIGNATURE, OBJECTID1, OBJECTVALUE1, OBJECTID2, OBJECTVALUE2, OBJECTID3,         OBJECTVALUE3, OBJECTID4, OBJECTVALUE4, OBJECTID5, OBJECTVALUE5, OBJECTID6, OBJECTVALUE6,         OBJECTID7, OBJECTVALUE7, PROGSEQ, PCTEXT) VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12,         :13, :14, :15, :16, :17)
 Message Set Number: 200
 Message Number: 0
 Message Reason: File: E:\pt85312b-retail\peopletools\src\pssys\pcmget.cppSQL error. Stmt #: 2757  Error Position: 0  Return: 1653 - ORA-01653: unable to extend table SYSADM.PSPCMTXT by 1024 in tablespace PSIMAGE2
Failed SQL stmt: INSERT INTO PSPCMTXT (HASH_SIGNATURE, OBJECTID1, OBJECTVALUE1, OBJECTID2, OBJECTVALUE2, OBJECTID3,         OBJECTVALUE3, OBJECTID4, OBJECTVALUE4, OBJECTID5, OBJECTVALUE5, OBJECTID6, OBJECTVALUE6,         OBJECTID7, OBJECTVALUE7, PROGSEQ, PCTEXT) VALUES (:1, :2, :3, :4, :5, :6, :7, :8 (200,0)

Process 473427 ABENDED at Step UPGPTHASH.Hash.Step01 (PeopleCode) -- RC = ? (108,524)
 Message Set Number: 108
 Message Number: 524
 Message Reason: Process 473427 ABENDED at Step UPGPTHASH.Hash.Step01 (PeopleCode) -- RC = ? (108,524)
Process %s ABENDED at Step %s.%s.%s (Action %s) -- RC = %s


Solution:
==========
alter database datafile '/u01/app/oracle/product/11.2.0/pshint/dbs/psimage2_01.dbf' AUTOEXTEND ON MAXSIZE 5000M;

^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
2.

No comments :

Post a Comment