IBM Support

DataMartExtractionJob exception for a job that does not exist on the Central Manager in IBM Security Guardium Central Manager

Troubleshooting


Problem

IBM InfoSphere Security Guardium Central Manager (CM) generates an exception similar to the one below for a non existent job: DataMartExtractionJob_20000 trigger: DataMartExtractionJobGroup. DataMartExtractionJob_20000. Unable to run datamart extraction job due to error. Failed to select one and only one row.

Symptom

An exception similar to this one is reported by the IBM InfoSphere Security Guardium Central Manager (CM):

DataMartExtractionJob_20000 trigger: DataMartExtractionJobGroup.
DataMartExtractionJob_20000. Unable to run datamart extraction job due to error. Failed to select one and only one row.

however:

- A Datamart with that name does not exist on the Central Manager
- a scheduled job with that name does not exist in the Scheduled Jobs Report on the Central Manager

Note: The number in the job name may be different, for example DataMartExtractionJob_20008 or other instead of DataMartExtractionJob_20000.

[{"Product":{"code":"SSMPHH","label":"IBM Security Guardium"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Guardium Appliances","Platform":[{"code":"PF016","label":"Linux"}],"Version":"10.0;10.0.1;10.1;10.1.2;10.1.3;9.0;9.1;9.5","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

Modified date:
16 June 2018

UID

swg22008480

Page Feedback