000034794 - RSA Identity Governance & 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 on Jun 26, 2018
Version 3Show Document
  • View in full screen mode

Article Content

Article Number000034794
Applies ToRSA Product Set: RSA Identity Governance & Lifecycle 
RSA Product/Service Type: Enterprise Software
RSA Version/Condition: 6.8.1, 6.9.1, 7.x
Platform: Linux
Oracle database versions affected: to
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.

For customers using the RSA-supplied Oracle database software

The Oracle database Patch 19678658 is included in the Appliance Update, starting with the December 2017 version.  Please check for the latest RSA Identity Governance and Lifecycle Updater, for your platform.

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

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: