Ben74 Posted May 27, 2016 Report Share Posted May 27, 2016 Hello guys, I'm struggling (to say the least) to get Revive to show stats... I tried this : http://documentation.revive-adserver.com/display/DOCS/No+Statistics Didn't work. I'm running manually the maintenance script http://myserverinstall.com/maintenance/maintenance.php doesn't seem to help much. I even tried setting the Maintenance Settings / Maintenance Operation Interval (minutes) to 5 minutes... I checked in the DB and I have my impressions recorded : My Banner logging settings are the defaults: My debug log doesn't seem especially buggy to me: https://dropshare-files.s3-eu-west-1.amazonaws.com/debug-hV4VIksx7s.log I am CLUELESS... Any tips / ideas maybe ? Thanks guys, CHeers, Quote Link to comment Share on other sites More sharing options...
Snoork Hosting Posted May 27, 2016 Report Share Posted May 27, 2016 Make sure your database user is added to your database name and has proper ownership permission. Have you tried running the maintenance via SSH (server console) and see if the statistics then update? Quote Link to comment Share on other sites More sharing options...
Ben74 Posted May 27, 2016 Author Report Share Posted May 27, 2016 @Snoork Hosting The database settings are fine, or the install script wouldn't have worked. Also it seems like data is written in data_bkt_m correctly. Regarding the maintenance script, if I decypher the log correctly, it seems to work, isn't it ? Or is there another way to see of the maintenance script is successful or not ? Cheers, Quote Link to comment Share on other sites More sharing options...
Ben74 Posted May 29, 2016 Author Report Share Posted May 29, 2016 OK, so the way the Stats are working are weird / unclear at least. Somehow I can get the Stats from yesterday to appear but I'll ALWAYS have the Stats of the current day empty and/or with a gigantic delay (despite the cron running like every 10 minutes + me triggering the script manually from the browser).... Also I don't know how/why but it doesn't really seems like triggering the maintenance script does things instantly, and I can't see any correlation between manual of cron triggering and the Stats getting magically updated "at one point in time"... so basically I'm more or less getting my stats but why and how they are generated is a complete mystery... e.g. I trigger some pageloads / banners impressions... then I run the maintenance script manually... then god knows what happens but my stats get refreshed "someday" (clearly not in the 5 10 minutes after launching the maintenance script... for just 10 impressions it shouldn't take ages to refresh the stats) Anyone can help me understand this mystery ?? Thanks, Cheers, Quote Link to comment Share on other sites More sharing options...
Ian Posted May 30, 2016 Report Share Posted May 30, 2016 Did you check your apache/nginx/php-fpm error logs ? Quote Link to comment Share on other sites More sharing options...
Ben74 Posted June 3, 2016 Author Report Share Posted June 3, 2016 Yes no errors. Could someone tell me how the stats update process work ? It's not straight-forward at all... Clearly it's not instant, even for very low clicks/impressions and on a VPS. Quote Link to comment Share on other sites More sharing options...
Erik Geurts Posted June 4, 2016 Report Share Posted June 4, 2016 (edited) Delivery data is logged in so-called 'bkt' (short for bucket) tables during the hour. Logging is by banner by zone. It is about requests (if you've enabled that), impressions, clicks, and conversions. At the top of the new hour, a maintenance process runs that collects that raw delivery data and summarizes it into another set of tables. We recommend using job to trigger the maintenance process (this is called Scheduled maintenance), but if you can't setup a cron job you can also use the substitute (which is called Automatic maintenance), being triggered by a banner being delivered in the new hour. Your database user must have "all privileges" on the database in order to be able to create and delete some temporary tables during the maintenance process. So in short: no, statistics don't appear in real time, but they should update once per hour. More information about your issue may be here: http://documentation.revive-adserver.com/display/DOCS/No+Statistics Edited June 4, 2016 by Erik Geurts Documentation link added Quote Link to comment Share on other sites More sharing options...
Ben74 Posted June 5, 2016 Author Report Share Posted June 5, 2016 OK thanks for the help. It's working on production, somehow the weird way it was working on a test site made it very confusing... especially since I would have expected that running the CRON at let's say 10:30 would get me updated data at 10:35 but never did... No matter if you use CRON or even manually calling the maintenance URL, apparently there is always a delay in stats generation (and I didn't expect this to be the case, especially to compute stats of 20 impressions). Quote Link to comment Share on other sites More sharing options...
Erik Geurts Posted June 5, 2016 Report Share Posted June 5, 2016 Maintenance is designed to calculate the statistics for the previous hour only. Running at more than once an hour doesn't do anything for the current hour. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.