My Oracle Support Banner

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.