My Oracle Support Banner

E-DB2: SQR Fails SQL0805N Package "ABC.SQR.A12.123" was not found. (Doc ID 2514590.1)

Last updated on NOVEMBER 25, 2019

Applies to:

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

Symptoms

On : 8.57 version, Upgrade

When Upgrading PT 8.55.15 to PT 8.57.04 for PeopleSoft HCM 9.2 on DB2 11.1, z/OS 2.1, Windows 2016, DBTSFIX fails
 

ERROR
-----------------------

(SQR 5528) DB2 SQL OPEN/EXECUTE error -805 in cursor 1:
  SQL0805N Package "ABC.SQR.A12.123" was not found.

SQLSTATE=51002


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run upgrade job
2. Observe error at DBTSFIX step


Changes

 

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
Changes
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.