IBM Support

Report error "Query start date is earlier than the system allowed" when trying to show more than 14 days worth of data

Troubleshooting


Problem

When running a report for a date range of 1 to (for example) 14 days, data is returned as expected in the report. 
When you try to run the report for greater than 14 days, no data is returned and you receive the following message at the top of the report window: 

Query start date is earlier than the system allowed. User can use audit process to generate report for query start date earlier than YYYY-MM-DD

Symptom

In the Guardium UI, running a report for a range of up to 14 days can return the following message but no data: 

Query start date is earlier than the system allowed. User can use audit process to generate report for query start date earlier than YYYY-MM-DD

Document Location

Worldwide

[{"Type":"MASTER","Line of Business":{"code":"LOB76","label":"Data Platform"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSMPHH","label":"IBM Security Guardium"},"ARM Category":[{"code":"a8m0z000000Gp0LAAS","label":"AGGREGATION"},{"code":"a8m0z0000001erNAAQ","label":"REPORTS"}],"ARM Case Number":"TS014431045","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions"}]

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.

Historical Number

TS014431045

Document Information

Modified date:
17 October 2023

UID

ibm17053424