Archive.sh Error "not such data in the Archive"?


(stefan) #1

Hello together,

every time i will run “archive.sh” I get this error "You are requesting a precise subTable but there is not such data in the Archive"
Can somebody help me to solve this problem?

Another Problem is the allowed memory size.
in DataTable.php i set ini_set(“memory_limit”,“512M”) but i always get an error on the webinterface:
“Fatal error: Allowed memory size of 536870912 bytes exhausted (tried to allocate 12582912 bytes) in /var/www/piwik/piwik/core/DataTable.php on line 936”

Thanks in advance!


(Matthieu Aubry) #2

What traffic do you have in your Piwik setup? How many websites?

Can you try the patch in: http://dev.piwik.org/trac/changeset/2025 and see if it helps?

Also, make sure to set

[General]
time_before_today_archive_considered_outdated = 3600

in your config.ini.php (1 hour or less, but not 10 s)


(stefan) #3

Hello Matthieu!

first thanks!!! it Works! now archive.sh runs without any error!

i set DataTable.php -> memory_limit to 1024M!!!
Now i can view stats for months and years!
But it seems to need to much memory!!!
I have only 12 pages with about 50 visitors a day per page
and 1 page with about 1400 visitors a day.

Thanks a lot!