E-UPG PT8.55.14: TLSUPGNONCOMP.DMS Fails (Doc ID 2259580.1)

Last updated on MAY 03, 2017

Applies to:

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

Symptoms

We are in the process of upgrading to tools 8.55.14.  The upgrade job fails at this step

     Loading non comparable objects

 

with following SQL error


ENV:
====
APSP EPM 9.1
8.55.14
Tools only upgrade
Loading non comparable objects> Script TLSUPGNONCOMP


ERROR:
======
SQL Error. Error Position: 12  Return: 600 - ORA-00600: internal error code, arguments: [qkaffsindex1], [], [], [], [], [], [], [], [], [], [], []
DELETE FROM PSTREELEVEL WHERE EXISTS (SELECT 'X' FROM PSPROJECTITEM B WHERE B.PROJECTNAME='TLSUPGNONCOMP' AND B.OBJECTTYPE=12 AND PSTREELEVEL.SETID = B.OBJECTVALUE1 AND PSTREELEVEL.SETCNTRLVALUE = B.OBJECTVALUE2 AND PSTREELEVEL.TREE_NAME = B.OBJECTVALUE3 AND TO_CHAR(PSTREELEVEL.EFFDT,'YYYY-MM-DD') = B.OBJECTVALUE4)
Error: SQL execute error for DELETE FROM PSTREELEVEL WHERE EXISTS (SELECT 'X' FROM PSPROJECTITEM B WHERE B.PROJECTNAME='TLSUPGNONCOMP' AND B.OBJECTTYPE=12 AND PSTREELEVEL.SETID = B.OBJECTVALUE1 AND PSTREELEVEL.SETCNTRLVALUE = B.OBJECTVALUE2 AND PSTREELEVEL.TREE_NAME = B.OBJECTVALUE3 AND %dateout(PSTREELEVEL.EFFDT) = B.OBJECTVALUE4)
Ended: Wed Apr 26 11:01:23 2017


 

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