My Oracle Support Banner

E-SEC: DYNROLE_PUBL Failed For LDAP Role Rule With Error: SQL.Fetch: object isn't open on a select. (2,288) DYNROLE_PUBL.MAIN.GBL. (Doc ID 2705047.1)

Last updated on AUGUST 26, 2020

Applies to:

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

Symptoms

Customer has multiple Dynamic Role rules enabled. When executing dynamic role rules from the role this will work for query role rules but is failing for LDAP role rules.

The process scheduler shows the DYNROLE_PUBL process ran to No Success Status

Error:

SQL.Fetch: object isn't open on a select. (2,288) DYNROLE_PUBL.MAIN.GBL.default.1900-01-01.Step03.OnExecute PCPC:2251 Statement:23

Process 1452504 ABENDED at Step DYNROLE_PUBL.MAIN.Step03 (PeopleCode) -- RC = 24 (108,524)
Process %s ABENDED at Step %s.%s.%s (Action %s) -- RC = %s
PSAESRV completed service request at 10.01.13 2020-08-25


Changes

 

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.