Unable To See Apr 09 Data In Worksheet Even Though Date Range Specified. ERROR The Given Record Date is not Valid for the Query (Doc ID 878932.1)

Last updated on MARCH 28, 2016

Applies to:

Oracle Demantra Demand Management - Version 7.2 and later
Information in this document applies to any platform.
***Checked for relevance on 25-Jan-2012***


Symptoms

On 7.2.0 in Production:
Client observed the following message in the back end Collaborator.log:

2009-06-16 16:24:31,703 [Query_Execution_163] ERROR appserver.error:
com.demantra.applicationServer.appServerExceptions.DateNotExistException: The given record
date is not valid for the query [Tue Mar 31 23:00:00 CST 2009].16177_512 at....

Note that the exact scenario for this particular client was as follows:

    ISSUE CLARIFICATION
    ====================
    On 7.2.0 in Production:
    Find that when the Worksheet Time range is set to monthly from 01/01/09 to 04/01/09., users are
    NOT able to see the Apr 09 data and could only see Jan09 to Mar09, even though the date range is
    Jan09 to Apr09 as above.
   
    However, If the Time range is set to monthly from 01/01/09 to 05/01/09, users are able to see the
    Jan09 to May09 data in the worksheet including April.
   
   
    Enabling enhanced logging shows the following error in the collaboraror logs:
   
     2009-06-16 16:24:31,703 [Query_Execution_163] ERROR appserver.error:
        com.demantra.applicationServer.appServerExceptions.DateNotExistException: The given record
    date is not valid for the query [Tue Mar 31 23:00:00 CST 2009].16177_512 at
   
   
    EXPECTED BEHAVIOR
    -----------------------
    Expect that the date for April be also reflected.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms