000034794 - RSA Identity Governance and Lifecycle Aveksa System Report (ASR) is not generated due to ORA-04030 (qmxlu subheap,qmemNextBuf:alloc)

Document created by RSA Customer Support Employee on Mar 29, 2017Last modified by RSA Customer Support Employee on Apr 5, 2017
Version 2Show Document
  • View in full screen mode

Article Content

Article Number000034794
Applies ToRSA Product Set: RSA Identity Governance and Lifecycle (RSA G&L)
RSA Product/Service Type: Enterprise Software
RSA Version/Condition: 6.8.1, 6.9.1, 7.x
Platform: Linux
Oracle database versions affected: 11.2.0.3 to 12.1.0.2
 
IssueWhen attempting to create an Aveksa System Report (ASR), it fails to generate.  An examination of the Aveksa server log file shows an ORA-04030 error, as does the Oracle database alert log.


Aveksa server log


To access the Aveksa server log file,
  1. Login to the UI as the administrator.
  2. Navigate to Admin > System > Server Nodes (tab) > Logs (column)
  3. The per Node Name row has links to the migrate.log, reporting-user-synonyms.log, aveksaServer.log, aveksaServerInfo.log and WorkPoint.log file.
From the aveksaServer.log

... 
01/12/2017 16:17:21.735 ERROR (GuiSystemReportObjectStore) [com.aveksa.server.db.persistence.PersistenceServiceProvider] Executing Procedure:
java.sql.SQLException: ORA-00603: ORACLE server session terminated by fatal error 
ORA-27102: out of memory 
Linux-x86_64 Error: 12: Cannot allocate memory 
Additional information: 108 
Additional information: 1835008 
ORA-04030: out of process memory when trying to allocate 1032 bytes (qmxlu subheap,qmemNextBuf:alloc) 

... 
FAILED method=runStoredProcedure System_Report.Run, [ProcedureParameter[direction = IN name = null value = <SECTION REFERENCE='101'> 
...


Oracle database alert log


To examine the Oracle database alert log,
  1. Login as the owner of the Oracle home.
  2. Issue the following command to find the log: 
find . -name alert_AVDB.log -print

From the alert_AVDB.log


Thu Dec 08 13:15:21 2016 
Errors in file /u01/app/oracle/diag/rdbms/avdb/AVDB/trace/AVDB_ora_7081.trc (incident=180976): 
ORA-04030: out of process memory when trying to allocate 1032 bytes (qmxlu subheap,qmemNextBuf:alloc) 
Incident details in: /u01/app/oracle/diag/rdbms/avdb/AVDB/incident/incdir_180976/AVDB_ora_7081_i180976.trc
CauseThe ORA-04030 error is caused by Oracle database Bug 19678658, that is a memory leak when using XML data.
Resolution

For customers using the RSA-supplied Oracle database software


If the RSA Identity Governance and Lifecycle software uses the Oracle database software supplied by RSA, then please check if Oracle database Patch 19678658 is included in the latest RSA Identity Governance and Lifecycle Updater.  This is because at the time of writing, it is yet to be made available.  Please click here to check for the latest RSA Identity Governance and Lifecycle Updater.

For customers using their own Oracle database software


Download and apply Oracle database Patch 19678658 from the Oracle Support portal, for your specific Operating System and version of Oracle database software.


Checking if Oracle database patch 19678658 has been applied


To check if the patch has been applied, perform the following steps.
  1. Login as the owner of the Oracle home.
  2. Navigate to $ORACLE_HOME/Opatch
  3. Run the following command:
opatch lsinventory

In a typical RSA Identity Governance and Lifecycle installation, the results would look similar to the following.

--------------------------------------------------------------------------------
Installed Top-level Products (1):
Oracle Database 12c                                                  12.1.0.2.0
There are 1 products installed in this Oracle Home.

Interim patches (2) :
Patch  19678658     : applied on Mon Mar 20 22:13:50 EDT 2017
Unique Patch ID:  19261499
   Created on 20 Aug 2015, 14:51:46 hrs PST8PDT
   Bugs fixed:
     19678658
Patch  19509982     : applied on Mon Oct 03 12:49:01 EDT 2016
Unique Patch ID:  18265206
   Created on 11 Feb 2015, 14:07:42 hrs PST8PDT
   Bugs fixed:
     19509982

--------------------------------------------------------------------------------

Attachments

    Outcomes