Unable to apply filter on Virtual Date Table

Sakshi

Hi,

We are facing a problem in NAV 2015 CU 8. Your help will be much appreciated.
I don’t know, it is due to some code bug or some NST bug.

But sometime, NAV is not able to apply filter out data on the Date Table. It is always picking first entry from Date Table.
Rest virtual tables are working fine.
And the common thing is, every time Memory utilisation of NAV Application servers reaches to 99%.
But after NAV Application server memory utilisation restore back to normal. Still this issue persists.

Frequency of this issue is not very high. But every time we have to restart NAV services to get it back to normal and it impacts user Business.

Code:

Date.RESET;
Date.SETRANGE("Period Type",RecDate."Period Type"::Year);
Date.SETRANGE("Period Start",FromDate,ToDate);
IF Date.FINDSET THEN REPEAT
InsertIntBuf(Contr."Contract No.",Date."Period Start",Date."Period Start");
UNTIL Date.NEXT=0;

Error:







Can someone help regarding this issue.

AndreasThorwesten

If "From Date" is a Date Type Field, then "03/01/0001" is clearly outside the allowed range of dates.

"Denotes a date ranging from January 1, 1753 to December 31, 9999."

https://docs.microsoft.com/en-us/dynamics-nav/date-data-type

Sakshi

Thanks Andreas.

But "From Date" is a valid date but still not able apply the filter.

Also, if we are simply making a page of the Date table and applying filter on "Period Type" and "Period Start" still not able apply the filters.