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.
Posts
