My Oracle Support Banner

E-MSS/AE: App Engine Process Performance Slow Down After PT 8.56 Upgrade, Due to Extra "sp_describe_first_result_set" Calls on MS SQL Server (Doc ID 2450306.1)

Last updated on APRIL 15, 2020

Applies to:

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

Symptoms

On : 8.56.08 version, Database-SQL Server

After upgrade tools from PT 8.54.12 (with sql server 2014) to PT 8.56.08 (sql server 2016), some custom process taking a long time to complete,

ACTUAL BEHAVIOR
---------------
a cusotm process took 4 hours to complete

EXPECTED BEHAVIOR
-----------------------
custom process should only take 20 minute before

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.