E-ORA: Oracle 12.2 Alert log Shows "WARNING: too many parse errors"
(Doc ID 2446840.1)
Last updated on JULY 04, 2024
Applies to:
PeopleSoft Enterprise PT PeopleTools - Version 8.54 to 8.55 [Release 8.4]Information in this document applies to any platform.
Symptoms
After upgrading from 11gR2 to 12cR2 following WARNING is noticed in the Oracle alert.log.
WARNING: too many parse errors, count=100 SQL hash=0xd4d35a8b
PARSE ERROR: ospid=16577, error=942 for statement:
SELECT COUNT(*) FROM PSOPTIONS WHERE COLLATION_TYPE != '000'
Additional information: hd=0x16e84ce90 phd=0x16e962728 flg=0x20 cisid=110 sid=110 ciuid=110 uid=110
WARNING: too many parse errors, count=100 SQL hash=0x080f8933
PARSE ERROR: ospid=16577, error=942 for statement:
SELECT UNICODE_ENABLED FROM PSSTATUS WHERE UNICODE_ENABLED = 1
Changes
Upgrade HCM 9.2/PeopleTools 8.55 from Oracle 11gR2 to 12cR2
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 |