Troubleshooting
Problem
Administrators who create scheduled reports that include AQL lookups or mathematical functions can experience issues where reports do not display column data correctly or duplicate or incorrect data. This issue is caused by AQL functions where accumulated data in the report would require a lookup of data, instead of displaying a static value. The accumulator, which is used to draw graphs and reports for charts references static data. This article is intended to advise administrators on AQL functions that ought to be excluded from reports or time series graphs and is associated to APAR IJ25142.
Symptom
When AQL issue occurs, administrators might experience the following issues when reports are generated:
- Scheduled reports on AQL searches can show incorrect column name and column data
- AQL-based reports does not show calculated value
- Reports generating with duplicated column and incorrect column data
Document Location
Worldwide
[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSBQAC","label":"IBM Security QRadar SIEM"},"ARM Category":[{"code":"a8m0z000000GnblAAC","label":"QRadar-\u003ESearch"}],"ARM Case Number":"","Platform":[{"code":"PF016","label":"Linux"}],"Version":"All Version(s)","Line of Business":{"code":"LOB77","label":"Automation 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.
Was this topic helpful?
Document Information
Modified date:
24 June 2020
UID
ibm16221278