000014525 - SQLException in entitlement server when performing searches using the admin API

Document created by RSA Customer Support Employee on Jun 16, 2016Last modified by RSA Customer Support Employee on Apr 21, 2017
Version 2Show Document
  • View in full screen mode

Article Content

Article Number000014525
Applies ToRSA Access Manager 6.0.4
RSA Access Manager 6.0.2
Oracle Database
Issue
 SQLException in entitlement server when performing searches using the admin API

API log shows SQLException:

16:11:49:828 [*] [APIClientProxy-2597] - <<< Preparing Statment >>>:SELECT

count(DISTINCT T0.ID) FROM PASSWORD T1,USER_PROPERTY T2,USERS T0 WHERE

(T0.NAME LIKE ? ESCAPE '#' ) AND (T1.USER_ID=T0.ID) AND

(T2.USER_ID(+)=T0.ID)

16:11:49:849 [*] [APIClientProxy-2597] - Not a DB fatal exception code

16:11:49:849 [*] [APIClientProxy-2597] - Database Exception Message :

SQLException : Code:1000;TextORA-01000: maximum open cursors exceeded

Cause
When performing user search with sort options using Admin API, the SQL DAL code creates a prepared statement and fetches the information from the database.
After fetching the information it does not close the prepared statement/result set. After multiple "getByRange" calls the searches will fail because of the cursors left open from prior searches.
ResolutionThis problem has been resolved in hotfix 6.0.4.14 for ClearTrust 6.x. Please contact RSA Customer support and request this hotfix or the latest hotfix for this version.
Legacy Article IDa44529

Attachments

    Outcomes