Tool to FindOut Cache Creation Time

Sample cache file

NQS_XYZ_733536_60898_00000071.TBL

these files usually resides under .\OracleBIData\cache or Cache folder specified in Config file(NQSConfig.INI -- >DATA_STORAGE_PATHS =’abc folder full path’)

XYZ is BI Server running Machine Name

733536 is Days elapsed since 12:00:00 midnight, January 1, 0001(millenium start date)

40458 is Seconds passed since 00:00:00 Hours

00000071 is Incremental number since active BI server session:

If cache file physically present in cache directories then its simple to find out cache creation date by checking modified date property in folder or using administration-cache menu check for creation date.

But if you want to analyze cache related errors under Usage track, its hard to find out when it got created so I have build a GUI which can aids in knowing cache creation date.

ho ho ...its shows exactly +3 days of creation date, in horry i have not properly coded,I will try to upload new GUI.