My Oracle Support Banner

E-UPG: Step "Updating PeopleTools Patch Information" Failed with"... The SELECT permission was denied on the object 'PSACCESSPROFILE'..." (Doc ID 2510079.1)

Last updated on APRIL 26, 2021

Applies to:

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

Symptoms

On : 8.55 version, Upgrade

When upgrading PT 8.55 to 8.57 on SQL Server, the step "Updating PeopleTools Patch Information" failed with the following error:

ERROR
-----------------------
PeopleTools 8.55.27 - Data Mover
Copyright (c) 2019 PeopleSoft, Inc.
All Rights Reserved
 Message Set Number: 200
 Message Number: 0
 Message Reason: File: E:\pt85527c-retail\peopletools\src\pssys\stmget.cppSQL error. Stmt #: 2788 Error Position: 0 Return: 8601 - [Microsoft][SQL Server Native Client 11.0][SQL Server]The SELECT permission was denied on the object 'PSACCESSPROFILE', database 'HRCON1', schema 'dbo'.
[Microsoft][SQL Server Native Client 11.0][SQL Server]The metadata could not be determined because ev
Failed SQL stmt: SELECT STM_ACCESS_ID, STM_ACCESS_PSWD, ENCRYPTED, STM_ACCESS_PART1, STM_ACCESS_PART2, STM_ENCRYPTION_VER FROM P (200,0)
 Message Set Number: 0
 Message Number: 0
 Message Reason: Invalid User ID and password for signon. (0,0)
PSDMTX Error: signon

File: E:\pt85527c-retail\peopletools\src\pssys\stmget.cppSQL error. Stmt #: 2788 Error Position: 0 Return: 8601 -
[Microsoft][SQL Server Native Client 11.0][SQL Server]
The SELECT permission was denied on the object 'PSACCESSPROFILE', database 'HRCON1', schema 'dbo'.
[Microsoft][SQL Server Native Client 11.0][SQL Server]The metadata could not be determined because ev
Failed SQL stmt: SELECT STM_ACCESS_ID, STM_ACCESS_PSWD, ENCRYPTED, STM_ACCESS_PART1,
STM_ACCESS_PART2, STM_ENCRYPTION_VER FROM PSACCESSPROFILE WHERE SYMBOLICID = :1

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Setup the environment for the PeopleTools only upgrade
2. Run the step "Updating PeopleTools Patch Information" in Change Assistant

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.