Turbo212 Posted August 1, 2018 Report Posted August 1, 2018 (edited) Hello Folks, Well, I am officially stumped. I followed all of the instructions posted on the Revive website, edited the RV.php file as suggested by some others, set the proper permissions to all maintenance scripts and folder (even went so far as to chmod 777 just to see if I could work backwards) and absolutely nothing works to generate my statistics. I went into phpMyAdmin and checked the database tables, and they all have the correct data placed in them. I also set up a cronjob to access the maintenance script and despite a successful access, no statistics can be seen in the UI. All other functionality of Revive works perfect. I am running v4.1.4 on Apache 2.4.33, PHP 7.0.30 and MySQL 5.5.60-0ubuntu0.14.04.1-log. MySQL tables: http://shorebeat.com/ads/mysql.png The only issue I found is in my debug log, which outputs the following: Aug 01 17:15:31 +0000 OX-maintenance-5b61eab3b7c67 [ info] Running Maintenance Engine Aug 01 17:15:31 +0000 OX-maintenance-5b61eab3b7c67 [ info] Running Maintenance Statistics Engine Aug 01 17:15:31 +0000 OX-maintenance-5b61eab3b7c67 [ info] Task begin: OX_Maintenance_Statistics_Task_SetUpdateRequirements Aug 01 17:15:31 +0000 OX-maintenance-5b61eab3b7c67 [ info] - Maintenance statistics will NOT be run It then goes on to output the following for the remainder of the maintenance: Aug 01 17:15:31 +0000 OX-maintenance-5b61eab3b7c67 [ info] Task complete: OX_Maintenance_Statistics_Task_SetUpdateRequirements Aug 01 17:15:31 +0000 OX-maintenance-5b61eab3b7c67 [ info] Task begin: OX_Maintenance_Statistics_Task_MigrateBucketData Aug 01 17:15:31 +0000 OX-maintenance-5b61eab3b7c67 [ info] Task complete: OX_Maintenance_Statistics_Task_MigrateBucketData Aug 01 17:15:31 +0000 OX-maintenance-5b61eab3b7c67 [ info] Task begin: OX_Maintenance_Statistics_Task_DeDuplicateConversions Aug 01 17:15:31 +0000 OX-maintenance-5b61eab3b7c67 [ info] Task complete: OX_Maintenance_Statistics_Task_DeDuplicateConversions Aug 01 17:15:31 +0000 OX-maintenance-5b61eab3b7c67 [ info] Task begin: OX_Maintenance_Statistics_Task_ManageConversions Aug 01 17:15:31 +0000 OX-maintenance-5b61eab3b7c67 [ info] Task complete: OX_Maintenance_Statistics_Task_ManageConversions Aug 01 17:15:31 +0000 OX-maintenance-5b61eab3b7c67 [ info] Task begin: OX_Maintenance_Statistics_Task_SummariseFinal Aug 01 17:15:31 +0000 OX-maintenance-5b61eab3b7c67 [ info] Task complete: OX_Maintenance_Statistics_Task_SummariseFinal Aug 01 17:15:31 +0000 OX-maintenance-5b61eab3b7c67 [ info] Task begin: OX_Maintenance_Statistics_Task_LogCompletion Aug 01 17:15:31 +0000 OX-maintenance-5b61eab3b7c67 [ info] Task complete: OX_Maintenance_Statistics_Task_LogCompletion Aug 01 17:15:31 +0000 OX-maintenance-5b61eab3b7c67 [ info] Task begin: OX_Maintenance_Statistics_Task_ManageCampaigns Aug 01 17:15:31 +0000 OX-maintenance-5b61eab3b7c67 [ info] Task complete: OX_Maintenance_Statistics_Task_ManageCampaigns Aug 01 17:15:31 +0000 OX-maintenance-5b61eab3b7c67 [ info] Maintenance Statistics Engine Completed (Started at 2018-08-01 17:15:31 UTC) Aug 01 17:15:31 +0000 OX-maintenance-5b61eab3b7c67 [ info] Running Maintenance Priority Engine Aug 01 17:15:31 +0000 OX-maintenance-5b61eab3b7c67 [ info] Task begin: OA_Maintenance_Priority_AdServer_Task_GetRequiredAdImpressionsLifetime Aug 01 17:15:31 +0000 OX-maintenance-5b61eab3b7c67 [ info] Task complete: OA_Maintenance_Priority_AdServer_Task_GetRequiredAdImpressionsLifetime Aug 01 17:15:31 +0000 OX-maintenance-5b61eab3b7c67 [ info] Task begin: OA_Maintenance_Priority_AdServer_Task_GetRequiredAdImpressionsDaily Aug 01 17:15:31 +0000 OX-maintenance-5b61eab3b7c67 [ info] Task complete: OA_Maintenance_Priority_AdServer_Task_GetRequiredAdImpressionsDaily Aug 01 17:15:31 +0000 OX-maintenance-5b61eab3b7c67 [ info] Task begin: OA_Maintenance_Priority_AdServer_Task_AllocateZoneImpressions Aug 01 17:15:31 +0000 OX-maintenance-5b61eab3b7c67 [ info] - Selecting Zones forecasts for all managers for OI from 2018-08-01 17:00:00 to 2018-08-01 17:59:59 Aug 01 17:15:31 +0000 OX-maintenance-5b61eab3b7c67 [ info] Task complete: OA_Maintenance_Priority_AdServer_Task_AllocateZoneImpressions Aug 01 17:15:31 +0000 OX-maintenance-5b61eab3b7c67 [ info] Task begin: OA_Maintenance_Priority_AdServer_Task_PriorityCompensation Aug 01 17:15:31 +0000 OX-maintenance-5b61eab3b7c67 [ info] - Selecting Zones forecasts for all managers for OI from 2018-08-01 17:00:00 to 2018-08-01 17:59:59 Aug 01 17:15:31 +0000 OX-maintenance-5b61eab3b7c67 [ info] Task complete: OA_Maintenance_Priority_AdServer_Task_PriorityCompensation Aug 01 17:15:31 +0000 OX-maintenance-5b61eab3b7c67 [ info] Task begin: OA_Maintenance_Priority_AdServer_Task_ECPMforContract Aug 01 17:15:31 +0000 OX-maintenance-5b61eab3b7c67 [ info] - Selecting All Managers Aug 01 17:15:31 +0000 OX-maintenance-5b61eab3b7c67 [ info] - Selecting active campaigns with priority = '9' for manager 1 Aug 01 17:15:31 +0000 OX-maintenance-5b61eab3b7c67 [ info] - Selecting active campaigns with priority = '8' for manager 1 Aug 01 17:15:31 +0000 OX-maintenance-5b61eab3b7c67 [ info] - Selecting active campaigns with priority = '7' for manager 1 Aug 01 17:15:31 +0000 OX-maintenance-5b61eab3b7c67 [ info] - Selecting active campaigns with priority = '6' for manager 1 Aug 01 17:15:31 +0000 OX-maintenance-5b61eab3b7c67 [ info] Task complete: OA_Maintenance_Priority_AdServer_Task_ECPMforContract Aug 01 17:15:31 +0000 OX-maintenance-5b61eab3b7c67 [ info] Task begin: OA_Maintenance_Priority_AdServer_Task_ECPMforRemnant Aug 01 17:15:31 +0000 OX-maintenance-5b61eab3b7c67 [ info] - Selecting Managers with ECPM priority campaigns running Aug 01 17:15:31 +0000 OX-maintenance-5b61eab3b7c67 [ info] Task complete: OA_Maintenance_Priority_AdServer_Task_ECPMforRemnant Aug 01 17:15:31 +0000 OX-maintenance-5b61eab3b7c67 [ info] Maintenance Priority Engine Completed (Started at 2018-08-01 17:15:31 UTC) Aug 01 17:15:31 +0000 OX-maintenance-5b61eab3b7c67 [ info] Maintenance Engine Completed (Started at 2018-08-01 17:15:31 UTC, taking 00:00:00) I am begging for help from anyone who might have a solution. Been trying every option under the sun for a week and simply cannot get the stats to load. Thanks! Edited August 1, 2018 by Turbo212 Quote
bald Posted August 2, 2018 Report Posted August 2, 2018 I have similar issue. I installed the newest version two days ago. Since then I don't have any statistics. Moreover there is no rv_data_bkt_m table in my database. Quote
andrewatfornax Posted August 3, 2018 Report Posted August 3, 2018 https://documentation.revive-adserver.com/display/DOCS/Revive+Adserver+Broken https://documentation.revive-adserver.com/display/DOCS/No+Statistics ? In addition to the above, @Turbo212, I notice that your oxcd_data_bkt_m table is MyISAM. This table type only supports table level locking. If you're under high load, it's possible that the table will be locked by delivery processes queued up to write their data when the hourly maintenance process wants to lock the table to make updates. Are you sure that's not happening? Your MySQL logs might give you more information on this. Ryan G 1 Quote
Turbo212 Posted August 4, 2018 Author Report Posted August 4, 2018 23 hours ago, andrewatfornax said: https://documentation.revive-adserver.com/display/DOCS/Revive+Adserver+Broken https://documentation.revive-adserver.com/display/DOCS/No+Statistics ? In addition to the above, @Turbo212, I notice that your oxcd_data_bkt_m table is MyISAM. This table type only supports table level locking. If you're under high load, it's possible that the table will be locked by delivery processes queued up to write their data when the hourly maintenance process wants to lock the table to make updates. Are you sure that's not happening? Your MySQL logs might give you more information on this. I did notice that and thought it was odd, which is what led me to my next step. Did not think it was able to be salvaged, and since the install was only a week old, no harm no foul. I did a fresh install on a spare server I had, confirmed it was working well and logging stats, then moved it over to my live server and gave Revive its own subdomain. Now all is working great! Quote
andrewatfornax Posted August 7, 2018 Report Posted August 7, 2018 Great, glad it's all working now! Quote
Ryan G Posted April 25, 2020 Report Posted April 25, 2020 Thanks for this documentation @andrewatfornax - I was able to address this issue on my end. Was related to my plugins issue: https://forum.revive-adserver.com/topic/5683-upgrade-error-unable-to-locate-one-or-more-plugin-files/?tab=comments#comment-14335 andrewatfornax 1 Quote
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.