IBM Support

Knowledge Collection: Scheduled Jobs Exception in Guardium

Troubleshooting


Problem

This document is a collection of articles on what to do when Scheduled Jobs Exceptions occur in IBM InfoSphere Guardium

Diagnosing The Problem

In the GUI->Guardium Monitor->Scheduled Job Exceptions (v8 and 9) or GUI->Manage->Maintenance->General->Scheduled Job Exceptions (v10) check to see if the Exception Description is similar to any of the following:

  1. java.lang.ArrayIndexOutOfBoundsException: Array index out of range: 30
  2. Guard Report Generator Error: Table 'AGGREGATOR_ACTIVITY_LOG' is marked as crashed and should be repaired
  3. wait merge flag Could not find value for: '5' in: 'com.guardium.audittasks.AuditResources'
  4. customTableDataUpload_105 trigger:
    customTableJobGroup.customTableDataUpload_105 29 total inserts. Error
    occurred while upload on datasource: <collector/aggregator hostname> :
    Communications link failure due to underlying exception: ** BEGIN
    NESTED EXCEPTION **
  5. Error retrieving list of members. Invalid value for getInt() - 'null'
  6. java.lang.NumberFormatException: empty String
  7. aliasIpJob trigger: aliasGenerationJobGroup.aliasIpJob HostName IP Alias creation: An error occured java.lang.RuntimeException: DB retrieval error on SQL: select distinct GDM_EXCEPTION.SOURCE_IP as CLIENT, GDM_EXCEPTION.TARGET_IP as SERVER FROM GDM_EXCEPTION
  8. Merge required, delay executing Process

Resolving The Problem

Please refer to the links below for the relevant Technote that will help solve the related Scheduled Jobs Exception in Guardium.

  1. ArrayIndexOutOfBoundsException Error in Correlation Alerts
  2. Aggregator/Archive log cannot be viewed
  3. Error "wait merge flag Could not find value for: '5' " in an aggregator
  4. Failure due to underlying exception - customTableDataUpload
  5. Invalid value for getInt() - 'null' Exception while Flattening Hierarchical Groups
  6. Guardium Scheduled Job Exceptions at regular intervals
  7. Scheduled Jobs Exception: Merge required, delay executing Process

For issues that are not listed here, please gather essential diagnostics as described in this document.

[{"Product":{"code":"SSMPHH","label":"IBM Security Guardium"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"--","Platform":[{"code":"PF016","label":"Linux"}],"Version":"9.1;9.0;8.2","Edition":"","Line of Business":{"code":"LOB24","label":"Security Software"}}]

Document Information

Modified date:
16 June 2018

UID

swg21700554

Page Feedback