E-AD: Errors Validating Or Resolving Meta SQL On PeopleTools 8.55.xx

(Doc ID 2140356.1)

Last updated on JANUARY 16, 2018

Applies to:

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

Symptoms


On : 8.55 version

When attempting to resolve / validate Meta SQL, the following error occurs.

ERROR
-----------------------
1. Getting out of memory errors on bldcreat.cpp when validating the SQL of views with meta SQL in them
2. When resolving meta SQL for views with meta SQL we get the message "Resolve Meta SQL failed to complete successfully"
3. When trying to create a view with the meta SQL in it we get the error "'EFFDTCHECK: Cannot create RDM manager'"
4. When using a date function that worked in the previous version of tools we now get a "The string representation of a datetime value is out of range" error message
5. When resolving/validating Application Engine Meta-SQL Constructs, get Error executing prepare.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Getting out of memory errors on bldcreat.cpp when validating the SQL of views with meta SQL in them
2. When resolving meta SQL for views with meta SQL we get the message "Resolve Meta SQL failed to complete successfully"
3. When trying to create a view with the meta SQL in it we get the error "'EFFDTCHECK: Cannot create RDM manager'"
4. When using a date function that worked in the previous version of tools we now get a "The string representation of a datetime value is out of range" error message
5. When trying to resolve or validate Application Engine Meta-SQL Constructs, get Error executing prepare.

Changes

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms