Jump to content

Raffaele.Rusconi

Approved members
  • Posts

    1
  • Joined

  • Last visited

Posts posted by Raffaele.Rusconi

  1. 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)

×
×
  • Create New...