We are running 8.4.2 and after moving to Oracle 19c, we are getting below error in our log files frequently. These errors are not appearing on application running the same pega version but Oracle 12.2 DB. Any suggestion?
[8/12/20 16:15:38:164 CEST] 0000008e SystemOut O 2020-08-12 16:15:38,163 [ WebContainer : 0] [TABTHREAD0] [ ] [SESBPricing:01.01.01] (al.access.PerformanceProcessor) ERROR lx67249.sbcore.net|srv68975.fspa.myntet.se Anand - Unable to apply pre processing for performance optimization
[8/12/20 16:15:38:175 CEST] 0000008e SystemOut O 2020-08-12 16:15:38,174 [ WebContainer : 0] [TABTHREAD0] [ ] [SESBPricing:01.01.01] (al.access.PerformanceProcessor) ERROR lx67249.sbcore.net|srv68975.fspa.myntet.se Anand - Unable to apply post processing for performance optimization
It appears Pega requires "Alter Session" privilege for for Admin user which was not mentioned in the installation guide. Raised incident (INC-140393) with GCS and below was the response from the product team:--
"Pega data tier sets the value, but it requires the session level privilege.
Pega already does that, it's just not well documented the privilege to do 'alter session'
Pega data tier code set that value at session level for relevant queries. But failed due to the missing 'alter session' privilege"
The error does not appear after providing the privilege. Documentation BUG-590486 to add the Alter session privilege to Admin User has been created.