E-CA: PeopleSoft Campus Solutions 9.0 To 9.2 Image 3 Upgrade REL854N Script Error - There is already an object named 'PSADSGROUP' in the database (Doc ID 2237160.1)

Last updated on FEBRUARY 27, 2017

Applies to:

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

Symptoms


PeopleSoft Campus Solutions 9.0 to 9.2 Image 3 Upgrade REL854N Script Issue

In the middle of performing the initial pass of the 9.0 to 9.2 upgrade which is also upgrading tools from 8.53.25 to 8.55.13 an error is occurring while running REL854N.SQL script in the change assistant job
 

ERROR
-----------------------
Msg 2714, Level 16, State 6, Server UMESPS92DB1, Line 2
There is already an object named 'PSADSGROUP' in the database.

There is already an object named 'PSADSGROUP' in the database.




STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Performing the tools upgrade from 8.53.25 to 8.55.13 during initial pass of the 9.0 to 9.2 upgrade
2. Running REL854N.SQL script in the change assistant job based on Task 3-2-8: Updating PeopleTools System Tables

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot complete the initial pass of the 9.0 to 9.2 upgrade while also upgrading tools from 8.53.25 to 8.55.13

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