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 scripts Does 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 Engine Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ info] Running Maintenance Statistics Engine Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ info] Task begin: OX_Maintenance_Statistics_Task_SetUpdateRequirements Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ debug] - Maintenance start run time is 2015-09-29 12:43:00 UTC Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ debug] - Getting the details of when maintenance statistics last ran on the basis of the operation interval Sep 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 tables Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ debug] - Getting the details of when maintenance statistics last ran on the basis of the hour Sep 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 tables Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ info] - Maintenance statistics will NOT be run Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ info] Task complete: OX_Maintenance_Statistics_Task_SetUpdateRequirements Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ info] Task begin: OX_Maintenance_Statistics_Task_MigrateBucketData Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ info] Task complete: OX_Maintenance_Statistics_Task_MigrateBucketData Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ info] Task begin: OX_Maintenance_Statistics_Task_DeDuplicateConversions Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ info] Task complete: OX_Maintenance_Statistics_Task_DeDuplicateConversions Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ info] Task begin: OX_Maintenance_Statistics_Task_ManageConversions Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ info] Task complete: OX_Maintenance_Statistics_Task_ManageConversions Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ info] Task begin: OX_Maintenance_Statistics_Task_SummariseFinal Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ info] Task complete: OX_Maintenance_Statistics_Task_SummariseFinal Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ info] Task begin: OX_Maintenance_Statistics_Task_LogCompletion Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ debug] - Logging the completion of the maintenance statistics run Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ info] Task complete: OX_Maintenance_Statistics_Task_LogCompletion Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ info] Task begin: OX_Maintenance_Statistics_Task_ManageCampaigns Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ info] Task complete: OX_Maintenance_Statistics_Task_ManageCampaigns Sep 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 Engine Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ info] Task begin: OA_Maintenance_Priority_AdServer_Task_GetRequiredAdImpressionsLifetime Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ debug] Running Maintenance Priority Engine: Get Required Ad Impressions for High Priority Campaigns Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ debug] - Where campaign lifetime target(s) and end date are set Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ info] Task complete: OA_Maintenance_Priority_AdServer_Task_GetRequiredAdImpressionsLifetime Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ info] Task begin: OA_Maintenance_Priority_AdServer_Task_GetRequiredAdImpressionsDaily Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ debug] Running Maintenance Priority Engine: Get Required Ad Impressions for High Priority Campaigns Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ debug] - Where a daily target is set Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ info] Task complete: OA_Maintenance_Priority_AdServer_Task_GetRequiredAdImpressionsDaily Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ info] Task begin: OA_Maintenance_Priority_AdServer_Task_AllocateZoneImpressions Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ debug] Running Maintenance Priority Engine: Allocate Zone Impressions Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ debug] - Getting the impression inventory data for all zones Sep 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:59 Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ debug] - Found that Zone ID 0 is inactive: Using default forecast Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ debug] - Found that Zone ID 6 is inactive: Using default forecast Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ debug] - Found that Zone ID 7 is inactive: Using default forecast Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ debug] - Found that Zone ID 8 is inactive: Using default forecast Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ debug] - Found that Zone ID 9 is inactive: Using default forecast Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ debug] - Found that Zone ID 10 is inactive: Using default forecast Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ debug] - Found that Zone ID 11 is inactive: Using default forecast Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ debug] - Creating the tmp_ad_zone_impression table Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ info] Inserted 8 rows in the table tmp_ad_zone_impression Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ info] Task complete: OA_Maintenance_Priority_AdServer_Task_AllocateZoneImpressions Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ info] Task begin: OA_Maintenance_Priority_AdServer_Task_PriorityCompensation Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ debug] Running Maintenance Priority Engine: Priority Compensation Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ debug] - Obtaining maintenance process run information from rv_log_maintenance_priority Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ debug] - Building zone and creative objects Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ debug] - Getting the impression inventory data for all zones Sep 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:59 Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ debug] - Getting all of the zones with ad impressions allocated Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ debug] - Getting all creatives where delivery limitations have changed Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ debug] - Getting details of previous creative/zone delivery Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ debug] - Getting details of contract campaign creative/zone pairs that delivered last OI Sep 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 yet Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ debug] - Calculating priority values for creative/zone pairs Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ debug] - Calculating priority values for creatives in Zone ID 0: Basic Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ debug] - Calculating priority values for creatives in Zone ID 6: Compensated Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ debug] - Calculating priority values for creatives in Zone ID 7: Compensated Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ debug] - Calculating priority values for creatives in Zone ID 8: Compensated Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ debug] - Calculating priority values for creatives in Zone ID 9: Compensated Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ debug] - Calculating priority values for creatives in Zone ID 10: Compensated Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ debug] - Calculating priority values for creatives in Zone ID 11: Compensated Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ debug] - Updating priorities Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ debug] - Zeroing category-based priorities Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ debug] - Saving calculated priorities WITHOUT transaction support Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ debug] - Getting all existing ad/zone pairs with priorities Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ debug] - Calculating which existing ad/zone pair priorities need to be zeroed Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ debug] - Zeroing required existing ad/zone pair priorities Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ debug] - Updating required existing ad/zone pair priorities Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ debug] - Epiring old priority values in data_summary_ad_zone_assoc Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ debug] - Adding new priority values to data_summary_ad_zone_assoc Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ debug] - Recording completion of the Priority Compensation task Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ debug] - Logging maintenance process run information into rv_log_maintenance_priority Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ info] Task complete: OA_Maintenance_Priority_AdServer_Task_PriorityCompensation Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ info] Task begin: OA_Maintenance_Priority_AdServer_Task_ECPMforContract Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ debug] Running Maintenance Priority Engine: ECPM value calculation Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ debug] - Obtaining maintenance process run information from rv_log_maintenance_priority Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ info] - Selecting All Managers Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ info] - Selecting active campaigns with priority = '9' for manager 1 Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ info] - Selecting active campaigns with priority = '8' for manager 1 Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ info] - Selecting active campaigns with priority = '7' for manager 1 Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ info] - Selecting active campaigns with priority = '6' for manager 1 Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ debug] - Recording completion of the ECPM value calculation Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ debug] - Logging maintenance process run information into rv_log_maintenance_priority Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ info] Task complete: OA_Maintenance_Priority_AdServer_Task_ECPMforContract Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ info] Task begin: OA_Maintenance_Priority_AdServer_Task_ECPMforRemnant Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ debug] Running Maintenance Priority Engine: ECPM for Remnant Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ debug] - Obtaining maintenance process run information from rv_log_maintenance_priority Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ info] - Selecting Managers with ECPM priority campaigns running Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ debug] - Recording completion of the ECPM for Remnant Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ debug] - Logging maintenance process run information into rv_log_maintenance_priority Sep 29 12:43:00 +0000 OX-maintenance-560a87541035f [ info] Task complete: OA_Maintenance_Priority_AdServer_Task_ECPMforRemnant Sep 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)
