E-AD:Errors Validating Or Resolving Meta SQL In Views On PeopleTools 8.55x (Doc ID 2140356.1)

Last updated on JULY 09, 2017

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 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


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

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