Jump to content
Turbo212

Statistics Will Not Show No Matter What, Help Sought

Recommended Posts

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

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 by Turbo212

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites
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!

Share this post


Link to post
Share on other sites

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.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.




×
×
  • Create New...