My Oracle Support Banner

E-ORA: Oracle 12.2 Alert log Shows "WARNING: too many parse errors" (Doc ID 2446840.1)

Last updated on DECEMBER 09, 2019

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.