nimf92 Posted May 30, 2015 Report Share Posted May 30, 2015 Hello! I want to change refresh interval of statistics in my Revive. Impressions and clicks are counted after 1h. How to change this process? I would like to accelerate this process to hmm 1 minute per refresh? Is it possible? Does this sth common with task scheduler? I configured crontab on my adserver: */1 * * * * /usr/bin/php5 /var/www/html/adserver/revive/scripts/maintenance/maintenance.php root version: You are currently using Revive Adserver v3.2.0 Example of my last maintenance.php script: May 30 10:32:01 +0000 OX-maintenance-556991a168b75 [ info] Running Maintenance Engine May 30 10:32:01 +0000 OX-maintenance-556991a168b75 [ info] Running Maintenance Statistics Engine May 30 10:32:01 +0000 OX-maintenance-556991a168b75 [ info] Task begin: OX_Maintenance_Statistics_Task_SetUpdateRequirements May 30 10:32:01 +0000 OX-maintenance-556991a168b75 [ info] - Maintenance statistics will NOT be run May 30 10:32:01 +0000 OX-maintenance-556991a168b75 [ info] Task complete: OX_Maintenance_Statistics_Task_SetUpdateRequirements May 30 10:32:01 +0000 OX-maintenance-556991a168b75 [ info] Task begin: OX_Maintenance_Statistics_Task_MigrateBucketData May 30 10:32:01 +0000 OX-maintenance-556991a168b75 [ info] Task complete: OX_Maintenance_Statistics_Task_MigrateBucketData May 30 10:32:01 +0000 OX-maintenance-556991a168b75 [ info] Task begin: OX_Maintenance_Statistics_Task_DeDuplicateConversions May 30 10:32:01 +0000 OX-maintenance-556991a168b75 [ info] Task complete: OX_Maintenance_Statistics_Task_DeDuplicateConversions May 30 10:32:01 +0000 OX-maintenance-556991a168b75 [ info] Task begin: OX_Maintenance_Statistics_Task_ManageConversions May 30 10:32:01 +0000 OX-maintenance-556991a168b75 [ info] Task complete: OX_Maintenance_Statistics_Task_ManageConversions May 30 10:32:01 +0000 OX-maintenance-556991a168b75 [ info] Task begin: OX_Maintenance_Statistics_Task_SummariseFinal May 30 10:32:01 +0000 OX-maintenance-556991a168b75 [ info] Task complete: OX_Maintenance_Statistics_Task_SummariseFinal May 30 10:32:01 +0000 OX-maintenance-556991a168b75 [ info] Task begin: OX_Maintenance_Statistics_Task_LogCompletion May 30 10:32:01 +0000 OX-maintenance-556991a168b75 [ info] Task complete: OX_Maintenance_Statistics_Task_LogCompletion May 30 10:32:01 +0000 OX-maintenance-556991a168b75 [ info] Task begin: OX_Maintenance_Statistics_Task_ManageCampaigns May 30 10:32:01 +0000 OX-maintenance-556991a168b75 [ info] Task complete: OX_Maintenance_Statistics_Task_ManageCampaigns May 30 10:32:01 +0000 OX-maintenance-556991a168b75 [ info] Maintenance Statistics Engine Completed (Started at 2015-05-30 10:32:01 UTC) May 30 10:32:01 +0000 OX-maintenance-556991a168b75 [ info] Running Maintenance Priority Engine May 30 10:32:01 +0000 OX-maintenance-556991a168b75 [ info] Task begin: OA_Maintenance_Priority_AdServer_Task_GetRequiredAdImpressionsLifetime May 30 10:32:01 +0000 OX-maintenance-556991a168b75 [ info] Task complete: OA_Maintenance_Priority_AdServer_Task_GetRequiredAdImpressionsLifetime May 30 10:32:01 +0000 OX-maintenance-556991a168b75 [ info] Task begin: OA_Maintenance_Priority_AdServer_Task_GetRequiredAdImpressionsDaily May 30 10:32:01 +0000 OX-maintenance-556991a168b75 [ info] Task complete: OA_Maintenance_Priority_AdServer_Task_GetRequiredAdImpressionsDaily May 30 10:32:01 +0000 OX-maintenance-556991a168b75 [ info] Task begin: OA_Maintenance_Priority_AdServer_Task_AllocateZoneImpressions May 30 10:32:01 +0000 OX-maintenance-556991a168b75 [ info] - Selecting Zones forecasts for all managers for OI from 2015-05-30 10:00:00 to 2015-05-30 10:59:59 May 30 10:32:01 +0000 OX-maintenance-556991a168b75 [ info] LOAD DATA INFILE / COPY failed or not supported, falling back to INSERTing data by looping over each record... May 30 10:32:01 +0000 OX-maintenance-556991a168b75 [ info] Inserted 16 rows in the table tmp_ad_zone_impression May 30 10:32:01 +0000 OX-maintenance-556991a168b75 [ info] Task complete: OA_Maintenance_Priority_AdServer_Task_AllocateZoneImpressions May 30 10:32:01 +0000 OX-maintenance-556991a168b75 [ info] Task begin: OA_Maintenance_Priority_AdServer_Task_PriorityCompensation May 30 10:32:01 +0000 OX-maintenance-556991a168b75 [ info] - Selecting Zones forecasts for all managers for OI from 2015-05-30 10:00:00 to 2015-05-30 10:59:59 May 30 10:32:01 +0000 OX-maintenance-556991a168b75 [ info] Task complete: OA_Maintenance_Priority_AdServer_Task_PriorityCompensation May 30 10:32:01 +0000 OX-maintenance-556991a168b75 [ info] Task begin: OA_Maintenance_Priority_AdServer_Task_ECPMforContract May 30 10:32:01 +0000 OX-maintenance-556991a168b75 [ info] - Selecting All Managers May 30 10:32:01 +0000 OX-maintenance-556991a168b75 [ info] - Selecting active campaigns with priority = '9' for manager 1 May 30 10:32:01 +0000 OX-maintenance-556991a168b75 [ info] - Selecting active campaigns with priority = '8' for manager 1 May 30 10:32:01 +0000 OX-maintenance-556991a168b75 [ info] - Selecting active campaigns with priority = '7' for manager 1 May 30 10:32:01 +0000 OX-maintenance-556991a168b75 [ info] - Selecting active campaigns with priority = '6' for manager 1 May 30 10:32:01 +0000 OX-maintenance-556991a168b75 [ info] - Selecting active campaigns with priority = '9' for manager 2 May 30 10:32:01 +0000 OX-maintenance-556991a168b75 [ info] - Selecting active campaigns with priority = '8' for manager 2 May 30 10:32:01 +0000 OX-maintenance-556991a168b75 [ info] - Selecting active campaigns with priority = '7' for manager 2 May 30 10:32:01 +0000 OX-maintenance-556991a168b75 [ info] - Selecting active campaigns with priority = '6' for manager 2 May 30 10:32:01 +0000 OX-maintenance-556991a168b75 [ info] Task complete: OA_Maintenance_Priority_AdServer_Task_ECPMforContract May 30 10:32:01 +0000 OX-maintenance-556991a168b75 [ info] Task begin: OA_Maintenance_Priority_AdServer_Task_ECPMforRemnant May 30 10:32:01 +0000 OX-maintenance-556991a168b75 [ info] - Selecting Managers with ECPM priority campaigns running May 30 10:32:01 +0000 OX-maintenance-556991a168b75 [ info] Task complete: OA_Maintenance_Priority_AdServer_Task_ECPMforRemnant May 30 10:32:01 +0000 OX-maintenance-556991a168b75 [ info] Maintenance Priority Engine Completed (Started at 2015-05-30 10:32:01 UTC) May 30 10:32:01 +0000 OX-maintenance-556991a168b75 [ info] Maintenance Engine Completed (Started at 2015-05-30 10:32:01 UTC, taking 00:00:00) In my opinion it's sth with: OX_Maintenance_Statistics_Task_SetUpdateRequirements this is only running 1 time in hour. Should I change time of this to 1 minutes? How to do this? Waiting for any advice Quote Link to comment Share on other sites More sharing options...
Erik Geurts Posted May 30, 2015 Report Share Posted May 30, 2015 The software had been designed to update the statistics once per hour. This can not be changed. andrewatfornax and nimf92 2 Quote Link to comment Share on other sites More sharing options...
nimf92 Posted May 31, 2015 Author Report Share Posted May 31, 2015 Ok thx for replay Quote Link to comment Share on other sites More sharing options...
Raffaele.Rusconi Posted September 29, 2015 Report Share Posted September 29, 2015 Hello. I have some problem with this script.I'm not sure this is the right topic.My goal is to run the report.I followed the guide and the only thing that seems to work is not just the maintenance scriptsDoes anyone have any idea why it does not work?This is the log:Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ info] Running Maintenance EngineSep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ info] Running Maintenance Statistics EngineSep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ info] Task begin: OX_Maintenance_Statistics_Task_SetUpdateRequirementsSep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ debug] - Maintenance start run time is 2015-09-29 12:43:00 UTCSep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ debug] - Getting the details of when maintenance statistics last ran on the basis of the operation intervalSep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ debug] - Maintenance statistics has never been run before, and no logged delivery data was located in Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ debug] the database, so maintenance statistics will not be run for the intermediate tablesSep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ debug] - Getting the details of when maintenance statistics last ran on the basis of the hourSep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ debug] - Maintenance statistics has never been run before, and no logged delivery data was located in Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ debug] the database, so maintenance statistics will not be run for the final tablesSep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ info] - Maintenance statistics will NOT be runSep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ info] Task complete: OX_Maintenance_Statistics_Task_SetUpdateRequirementsSep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ info] Task begin: OX_Maintenance_Statistics_Task_MigrateBucketDataSep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ info] Task complete: OX_Maintenance_Statistics_Task_MigrateBucketDataSep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ info] Task begin: OX_Maintenance_Statistics_Task_DeDuplicateConversionsSep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ info] Task complete: OX_Maintenance_Statistics_Task_DeDuplicateConversionsSep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ info] Task begin: OX_Maintenance_Statistics_Task_ManageConversionsSep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ info] Task complete: OX_Maintenance_Statistics_Task_ManageConversionsSep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ info] Task begin: OX_Maintenance_Statistics_Task_SummariseFinalSep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ info] Task complete: OX_Maintenance_Statistics_Task_SummariseFinalSep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ info] Task begin: OX_Maintenance_Statistics_Task_LogCompletionSep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ debug] - Logging the completion of the maintenance statistics runSep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ info] Task complete: OX_Maintenance_Statistics_Task_LogCompletionSep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ info] Task begin: OX_Maintenance_Statistics_Task_ManageCampaignsSep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ info] Task complete: OX_Maintenance_Statistics_Task_ManageCampaignsSep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ info] Maintenance Statistics Engine Completed (Started at 2015-09-29 12:43:00 UTC)Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ info] Running Maintenance Priority EngineSep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ info] Task begin: OA_Maintenance_Priority_AdServer_Task_GetRequiredAdImpressionsLifetimeSep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ debug] Running Maintenance Priority Engine: Get Required Ad Impressions for High Priority CampaignsSep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ debug] - Where campaign lifetime target(s) and end date are setSep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ info] Task complete: OA_Maintenance_Priority_AdServer_Task_GetRequiredAdImpressionsLifetimeSep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ info] Task begin: OA_Maintenance_Priority_AdServer_Task_GetRequiredAdImpressionsDailySep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ debug] Running Maintenance Priority Engine: Get Required Ad Impressions for High Priority CampaignsSep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ debug] - Where a daily target is setSep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ info] Task complete: OA_Maintenance_Priority_AdServer_Task_GetRequiredAdImpressionsDailySep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ info] Task begin: OA_Maintenance_Priority_AdServer_Task_AllocateZoneImpressionsSep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ debug] Running Maintenance Priority Engine: Allocate Zone ImpressionsSep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ debug] - Getting the impression inventory data for all zonesSep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ info] - Selecting Zones forecasts for all managers for OI from 2015-09-29 12:00:00 to 2015-09-29 12:59:59Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ debug] - Found that Zone ID 0 is inactive: Using default forecastSep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ debug] - Found that Zone ID 6 is inactive: Using default forecastSep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ debug] - Found that Zone ID 7 is inactive: Using default forecastSep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ debug] - Found that Zone ID 8 is inactive: Using default forecastSep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ debug] - Found that Zone ID 9 is inactive: Using default forecastSep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ debug] - Found that Zone ID 10 is inactive: Using default forecastSep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ debug] - Found that Zone ID 11 is inactive: Using default forecastSep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ debug] - Creating the tmp_ad_zone_impression tableSep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ info] Inserted 8 rows in the table tmp_ad_zone_impressionSep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ info] Task complete: OA_Maintenance_Priority_AdServer_Task_AllocateZoneImpressionsSep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ info] Task begin: OA_Maintenance_Priority_AdServer_Task_PriorityCompensationSep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ debug] Running Maintenance Priority Engine: Priority CompensationSep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ debug] - Obtaining maintenance process run information from rv_log_maintenance_prioritySep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ debug] - Building zone and creative objectsSep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ debug] - Getting the impression inventory data for all zonesSep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ info] - Selecting Zones forecasts for all managers for OI from 2015-09-29 12:00:00 to 2015-09-29 12:59:59Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ debug] - Getting all of the zones with ad impressions allocatedSep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ debug] - Getting all creatives where delivery limitations have changedSep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ debug] - Getting details of previous creative/zone deliverySep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ debug] - Getting details of contract campaign creative/zone pairs that delivered last OISep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ debug] - Getting details of contract campaign creative/zone pairs that did not deliver last OI (but should have)Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ debug] - Found 0 contract campaign creative/zone pairs that did not deliver last OI (but should have)Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ debug] - Finding contract campaign creative/zone pairs set to deliver, but with no past data yetSep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ debug] - Calculating priority values for creative/zone pairsSep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ debug] - Calculating priority values for creatives in Zone ID 0: BasicSep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ debug] - Calculating priority values for creatives in Zone ID 6: CompensatedSep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ debug] - Calculating priority values for creatives in Zone ID 7: CompensatedSep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ debug] - Calculating priority values for creatives in Zone ID 8: CompensatedSep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ debug] - Calculating priority values for creatives in Zone ID 9: CompensatedSep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ debug] - Calculating priority values for creatives in Zone ID 10: CompensatedSep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ debug] - Calculating priority values for creatives in Zone ID 11: CompensatedSep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ debug] - Updating prioritiesSep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ debug] - Zeroing category-based prioritiesSep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ debug] - Saving calculated priorities WITHOUT transaction supportSep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ debug] - Getting all existing ad/zone pairs with prioritiesSep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ debug] - Calculating which existing ad/zone pair priorities need to be zeroedSep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ debug] - Zeroing required existing ad/zone pair prioritiesSep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ debug] - Updating required existing ad/zone pair prioritiesSep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ debug] - Epiring old priority values in data_summary_ad_zone_assocSep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ debug] - Adding new priority values to data_summary_ad_zone_assocSep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ debug] - Recording completion of the Priority Compensation taskSep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ debug] - Logging maintenance process run information into rv_log_maintenance_prioritySep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ info] Task complete: OA_Maintenance_Priority_AdServer_Task_PriorityCompensationSep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ info] Task begin: OA_Maintenance_Priority_AdServer_Task_ECPMforContractSep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ debug] Running Maintenance Priority Engine: ECPM value calculationSep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ debug] - Obtaining maintenance process run information from rv_log_maintenance_prioritySep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ info] - Selecting All ManagersSep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ info] - Selecting active campaigns with priority = '9' for manager 1Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ info] - Selecting active campaigns with priority = '8' for manager 1Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ info] - Selecting active campaigns with priority = '7' for manager 1Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ info] - Selecting active campaigns with priority = '6' for manager 1Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ debug] - Recording completion of the ECPM value calculationSep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ debug] - Logging maintenance process run information into rv_log_maintenance_prioritySep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ info] Task complete: OA_Maintenance_Priority_AdServer_Task_ECPMforContractSep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ info] Task begin: OA_Maintenance_Priority_AdServer_Task_ECPMforRemnantSep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ debug] Running Maintenance Priority Engine: ECPM for RemnantSep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ debug] - Obtaining maintenance process run information from rv_log_maintenance_prioritySep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ info] - Selecting Managers with ECPM priority campaigns runningSep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ debug] - Recording completion of the ECPM for RemnantSep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ debug] - Logging maintenance process run information into rv_log_maintenance_prioritySep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ info] Task complete: OA_Maintenance_Priority_AdServer_Task_ECPMforRemnantSep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ info] Maintenance Priority Engine Completed (Started at 2015-09-29 12:43:00 UTC)Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ info] Maintenance Engine Completed (Started at 2015-09-29 12:43:00 UTC, taking 00:00:00) 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.