Clarity: First time enabling of audit trail on an object with a large number of existing records can result in application timeouts and/or cause a java.lang.OutOfMemory error

Document ID : KB000020585
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

As part of the setting up an audit trail, existing object records that were created before auditing was enabled are stored in referenced records in the tables ODF_AUD_OBJ_INST_CONTEXT and ODF_AUD_OBJ_INST_MAPPINGS.

The method in which these tables are populated results in a large memory, network, and processor overhead on the Clarity application server.

Symptoms include:

  1. The web browser failing to return a response or a 'page cannot be displayed' error due to the time taken, whilst data is still changing in the back end.

  2. The application server performance deteriorating.

  3. The application server hanging with or without a java.lang.OutOfMemory exception error.

    For example, if you have 2 million task records, then as the auditing is being switched on for the first time on this object, it is trying to hold 2 million records in memory whilst posting this quantity each into the two tables mentioned.

Steps to Reproduce:

  1. Use a large Clarity installation where you have millions of task records and auditing has not been enabled before (or insert millions of tasks distributed to >20,000 projects using XOG)

  2. Navigate to Admin Tool > Studio > Objects > Task > Audit Trail

  3. In the first column, select Charge Code and move it to the Selected column for auditing

  4. Place 60 in the Days box for purging old audit information

  5. Click 'Save' button

Expected Result: Progress of audit trail enabling to display ongoing until completion and without impact to app service uptime.

Actual Result: Web browser will time out before server responds, server performance will decrease, and the app service will likely go down due to java.lang.OutOfMemory error.

Solution:

WORKAROUND:

None.

STATUS/RESOLUTION:

Resolved in Clarity 12.1.1 Generic Patch. Reference TEC553491

Resolved in Clarity 12.1.3 Generic Patch. Reference TEC570813

Issue is still reproduced in Clarity 13.0, 13.1 - status pending

Keywords:CLARITYKB, CLRT-69692, clarity12resolved, clarity13resolved, clarity132resolved.