000032074 - How to troubleshoot a hung calculation job in RSA Archer 5.5.2 and above

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

Article Content

Article Number000032074
Applies ToRSA Product Set: Archer
RSA Version/Condition:  5.5.2 or later
IssueThe job engine manager lists a physical calculation job that has been running for hours or days.  How can you find out what this job is doing?
ResolutionCopy the job ID from the Job Engine Manager.
In SQL Server Management Studio, run the following query against the instance database:
SELECT jobid,JobType,named_arguments
FROM tblAsyncInstrumentation
WHERE JobId = '[job id]'

Click the link in the named_arguments column. 
Look for the section that includes ContentIdsWithCalculatedFieldIds as shown below.

<key z:Id="8">ContentIdsWithCalculatedFieldIds</key>

Just below that is a section containing field IDs for the fields that are being calculated by this job:

<KeyValuePairOfArrayOfintArrayOfint0dMmj3_Sh xmlns="http://schemas.datacontract.org/2004/07/System.Collections.Generic">
<key xmlns:d7p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays" z:Id="14">
<d7p1:_items z:Id="15" z:Size="4">

In this case, the field IDs are 5680,9701 and 10240.
Open a new query window in SQL Server Management Studio.  Input the field IDs in the query below.

SELECT ft.field_id,ft.field_name,mt.module_name
FROM tblFieldTranslation ft
JOIN tblIVFieldDef fd on fd.field_id=ft.field_id
JOIN tbllevel l on l.level_id=fd.level_id
JOIN tblmodule m on m.module_id=l.module_id
JOIN tblModuleTranslation mt on mt.module_id=m.module_id
WHERE ft.field_id IN (5680,9701,10240)

In this case, the query returns the following calculated fields that are being processed by this job:

5680Audit StatusAudit Entity
9701Next Audit DateAudit Entity
10240Days Since Last AuditAudit Entity

Directly below the field IDs in the named arguments is a list of content IDs being processed by the job.  In the example below there is only one content ID: 212724
<value xmlns:d7p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays" z:Id="16">
<d7p1:_items z:Id="17" z:Size="4">