Cannot save data to cache file

Avatar
  • updated
I've been seeing this error show up more frequently in my logs. "Analysis: Cannot save data to cache file" with the name and location of the file. The odd part is that it can. If I restart the report it'll either pick up where it left off or start again and not error.

Image 25
Avatar
Michael
What version of the program do you use? Do you create static HTML/PDF/CSV or dynamic HTML reports?
Avatar
Matt Crognale
I'm running 8.1 and I'm creating dynamic HTML reports for this particular report.
Avatar
Michael
You should check that there is enough disk space available. Databases in version 8 may become quite large if the "Include detailed log data" setting is enabled in Profile Properties > Report.

If there is enough disk space, I still recommend you to disable this option and check if the error appears again.
Avatar
Matt Crognale
I have around 35G free in that partition. What do I lose in the reports if I deselect that option?
Avatar
Michael
This option allows you to use filters in the dynamic reports and view the "Log Details" reports on hits and visitors.
Avatar
David Hadfield
Sorry to re-open an old thread but I am also seeing this behaviour on one of our profiles (likely more to follow given there are other sites we are analysing with similar volumes of traffic, and more still taking into account there is only 3 months of data involved so far)

The drive being written to has around 3TB free so no issues there.

We could try switching off the "Log Details" although that was one of the primary factors in choosing weblog in the first place so losing it would almost defeat the object of the analysis.

Also presumably even if disabled, this might seems to suggest that we might hit a point where the data fails to write.

Is there actually a known issue here relating to the size of cache being written? and if so is there any active development work being down to work around it? (either upping the limit or allowing the data to be split over multiple files etc?)
Avatar
David Hadfield
Sorry, extra information.

Windows Server 2012 R2
WebLog Expert 8.6 Enterprise
Output to Web Server
Avatar
Michael
We are not aware of any size limitations for the cache, so unfortunately I don't have any specific suggestions yet.

Does the problem always occurs when you analyze this profile? Does it occur if you limit the analysis to one month only? What is the total size of logs you analyze?
Avatar
David Hadfield
If I limit the analysis it will complete, but serves no purpose to me unfortunately.

If I attempt to run on the full set of data (Currently around 9 weeks (1st Jan 2015 to Yesterday)) it fails every time at the same point as it writes the final data back.

I tried last night, removing the option to "include detailed log data" and the report completed successfully.

So in summary only seems to be an issue with the detailed data included and only happens on large volumes of data and at the very end of the analysis (does that make sense? is the write back of the detailed data something which happens at the very end of the analysis?)

The particular site being analysed by this profile produces IIS logs of around 6GB per day uncompressed (2 web servers load balanced producing 3GBs of logs each) the logs are bz2 compressed for shipping and analysis coming down to around 300MB per day per server.

My concerns here are that we need to achieve a rolling 12 month analysis, so while for the bigger profiles we could drop the detailed data, I am still nervous that we are going to hit another point in time where the output fails due to size (unless it is the case that the apparent limitation only applies to the detailed data)
Avatar
David Hadfield
If the issue is limited to detailed data then we could leave it disabled by default and produce an ad-hoc report including it when we need to drill down further.

An alternative which would probably suit us 99% of the time would be to have an extra option to include "some" detailed data. so that whenever the data is analysed the last 7days or adjustable period of detailed data is there but not for the older data.

This would allow us to dig deeper over the most recent content but still retain the lighter version of the historic data without having to have multiple profiles per site? (We have around 60 sites to report on, of which maybe 10-15 are of similar or even greater volume than the one in this case)