func100 Posted August 7, 2014 Report Share Posted August 7, 2014 Apologies in advance if this subject has been covered, but i am in desperate need of some help. I upgraded from openx to revive and moved server at the same time, everything appears to working fine other than the statistics, I have the historic data from the database which i updated, the stats are being collected in the database but I cannot fathom why they will not show in the interface. I have set up a cron to supersede the automated maintenance option, ensured the cache has been emptied and it feels like i have tried every conceivable option with no success. Could somebody please help/give suggestions before I lose the remaining hair I have. many thanks in advance rcreader 1 Quote Link to comment Share on other sites More sharing options...
rcreader Posted December 7, 2014 Report Share Posted December 7, 2014 Having similar circumstances, appreciate you posting this issue in the forum! Quote Link to comment Share on other sites More sharing options...
andrewatfornax Posted April 6, 2017 Report Share Posted April 6, 2017 https://documentation.revive-adserver.com/display/DOCS/No+Statistics Quote Link to comment Share on other sites More sharing options...
wslymsgrv Posted April 19, 2017 Report Share Posted April 19, 2017 I'm having this same issue. I followed all the steps on https://documentation.revive-adserver.com/display/DOCS/No+Statistics. I confirmed that `SELECT * FROM rv_data_bkt_m;` is returning recently logged events. I confirmed that automated maintenance is running by checking Global Settings > Maintenance. I also verified that the proper statistics columns are enabled on the user interface settings. I also confirmed the debug.log file on my new server contains recent events. My server switch happened on 2/22/17. On my new server, the revive code was copied over. It's still using the same database server. When I navigate to Preferences > User Log > Maintenance log, the most recent events are from before 2/22/17. So the maintenance log report on my new server seems to be pulling it's information from the old server. This issue also shows up on the Statistics page itself where if I filter by a date older than 2/22/17, I can see statistics, but everything after that is empty. This behavior doesn't match up with the database query results or all the other configuration settings and debug.log file. After the server switch, I updated my config file to the new web root. Am I missing another configuration setting that would tell the Statistics and Maintenance log to pull from the new server instead of the old server??? Quote Link to comment Share on other sites More sharing options...
andrewatfornax Posted June 14, 2017 Report Share Posted June 14, 2017 Hi @wslymsgrv, Did you shut down the old server, to ensure that maintenance is not accidentally being run on the old server, and summarising the (no) statistics on the old server, before the new server with the statistics does so? If the old server gets in first, it will be the one that has the stats there. 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.