Jump to content

No stats after upgrade

FvLW

By FvLW
in Managing Revive Adserver

 Share

Recommended Posts

FvLW Newbie

FvLW

Posted
Posted

Hi,

today I realized that theer no stats any more since I upgraded from revice 3.0.2 to revive 3.2.1 on July 13th 2015

A snapshot from the actual debug.log looks like this:

Nov 13 13:05:00 +0100 OX-5645d1ec5c9ae [     info]  Automatic Maintenance Task not run: could not acquire lock
Nov 13 13:05:00 +0100 OX-maintenance-5645d1ec2ac5e [     info]  Task complete: OX_Maintenance_Statistics_Task_ManageCampaigns
Nov 13 13:05:00 +0100 OX-maintenance-5645d1ec2ac5e [     info]  Maintenance Statistics Engine Completed (Started at 2015-11-13 12:05:00 UTC)
Nov 13 13:05:00 +0100 OX-maintenance-5645d1ec2ac5e [     info]  Running Maintenance Priority Engine
Nov 13 13:05:00 +0100 OX-maintenance-5645d1ec2ac5e [     info]  Task begin: OA_Maintenance_Priority_AdServer_Task_GetRequiredAdImpressionsLifetime
Nov 13 13:05:00 +0100 OX-maintenance-5645d1ec2ac5e [     info]  Task complete: OA_Maintenance_Priority_AdServer_Task_GetRequiredAdImpressionsLifetime
Nov 13 13:05:00 +0100 OX-maintenance-5645d1ec2ac5e [     info]  Task begin: OA_Maintenance_Priority_AdServer_Task_GetRequiredAdImpressionsDaily
Nov 13 13:05:00 +0100 OX-maintenance-5645d1ec2ac5e [     info]  Task complete: OA_Maintenance_Priority_AdServer_Task_GetRequiredAdImpressionsDaily
Nov 13 13:05:00 +0100 OX-maintenance-5645d1ec2ac5e [     info]  Task begin: OA_Maintenance_Priority_AdServer_Task_AllocateZoneImpressions
Nov 13 13:05:00 +0100 OX-maintenance-5645d1ec2ac5e [     info]    - Selecting Zones forecasts for all managers for OI from 2015-11-13 12:00:00 to 2015-11-13 12:59:59
Nov 13 13:05:00 +0100 OX-maintenance-5645d1ec2ac5e [     info]  Inserted 182 rows in the table tmp_ad_zone_impression
Nov 13 13:05:00 +0100 OX-maintenance-5645d1ec2ac5e [     info]  Task complete: OA_Maintenance_Priority_AdServer_Task_AllocateZoneImpressions
Nov 13 13:05:00 +0100 OX-maintenance-5645d1ec2ac5e [     info]  Task begin: OA_Maintenance_Priority_AdServer_Task_PriorityCompensation
Nov 13 13:05:00 +0100 OX-maintenance-5645d1ec2ac5e [     info]    - Selecting Zones forecasts for all managers for OI from 2015-11-13 12:00:00 to 2015-11-13 12:59:59
Nov 13 13:05:01 +0100 OX-maintenance-5645d1ec2ac5e [     info]  Task complete: OA_Maintenance_Priority_AdServer_Task_PriorityCompensation
Nov 13 13:05:01 +0100 OX-maintenance-5645d1ec2ac5e [     info]  Task begin: OA_Maintenance_Priority_AdServer_Task_ECPMforContract
Nov 13 13:05:01 +0100 OX-maintenance-5645d1ec2ac5e [     info]  - Selecting All Managers
Nov 13 13:05:01 +0100 OX-maintenance-5645d1ec2ac5e [     info]    - Selecting active campaigns with priority = '9' for manager 1
Nov 13 13:05:01 +0100 OX-maintenance-5645d1ec2ac5e [     info]    - Selecting active campaigns with priority = '8' for manager 1
Nov 13 13:05:01 +0100 OX-maintenance-5645d1ec2ac5e [     info]    - Selecting active campaigns with priority = '7' for manager 1
Nov 13 13:05:01 +0100 OX-maintenance-5645d1ec2ac5e [     info]    - Selecting active campaigns with priority = '6' for manager 1
Nov 13 13:05:01 +0100 OX-maintenance-5645d1ec2ac5e [     info]  Task complete: OA_Maintenance_Priority_AdServer_Task_ECPMforContract
Nov 13 13:05:01 +0100 OX-maintenance-5645d1ec2ac5e [     info]  Task begin: OA_Maintenance_Priority_AdServer_Task_ECPMforRemnant
Nov 13 13:05:01 +0100 OX-maintenance-5645d1ec2ac5e [     info]  - Selecting Managers with ECPM priority campaigns running
Nov 13 13:05:01 +0100 OX-maintenance-5645d1ec2ac5e [     info]  Task complete: OA_Maintenance_Priority_AdServer_Task_ECPMforRemnant
Nov 13 13:05:01 +0100 OX-maintenance-5645d1ec2ac5e [     info]  Maintenance Priority Engine Completed (Started at 2015-11-13 12:05:00 UTC)
Nov 13 13:05:01 +0100 OX-maintenance-5645d1ec2ac5e [     info]  Maintenance Engine Completed (Started at 2015-11-13 12:05:00 UTC, taking 00:00:01)
Nov 13 13:05:01 +0100 OX-5645d1ec2ac5e [     info]  Automatic Maintenance Task Completed

Are there any ideas what can be happened and how to get the ststistics up and running again?

Regards
Michael

FvLW Newbie

FvLW

Posted
  • Author
Posted

Hi,

after some try & error word the debug.log looks as follows:

Nov 13 17:05:08 +0100 OX-56460a34c9739 [     info]  Running Automatic Maintenance Task


Nov 13 17:05:09 +0100 OX-maintenance-56460a34c9739 [     info]  Running Maintenance Engine
Nov 13 17:05:09 +0100 OX-maintenance-56460a34c9739 [     info]  Running Maintenance Statistics Engine
Nov 13 17:05:09 +0100 OX-maintenance-56460a34c9739 [     info]  Task begin: OX_Maintenance_Statistics_Task_SetUpdateRequirements
Nov 13 17:05:09 +0100 OX-maintenance-56460a34c9739 [     info]  - Maintenance statistics will be run
Nov 13 17:05:09 +0100 OX-maintenance-56460a34c9739 [     info]  - The intermediate table statistics will be updated
Nov 13 17:05:09 +0100 OX-maintenance-56460a34c9739 [     info]  - The final table statistics will be updated
Nov 13 17:05:09 +0100 OX-maintenance-56460a34c9739 [     info]  Task complete: OX_Maintenance_Statistics_Task_SetUpdateRequirements
Nov 13 17:05:09 +0100 OX-maintenance-56460a34c9739 [     info]  Task begin: OX_Maintenance_Statistics_Task_MigrateBucketData
Nov 13 17:05:09 +0100 OX-maintenance-56460a34c9739 [     info]  Task complete: OX_Maintenance_Statistics_Task_MigrateBucketData
Nov 13 17:05:09 +0100 OX-maintenance-56460a34c9739 [     info]  Task begin: OX_Maintenance_Statistics_Task_DeDuplicateConversions
Nov 13 17:05:09 +0100 OX-maintenance-56460a34c9739 [     info]  Task complete: OX_Maintenance_Statistics_Task_DeDuplicateConversions
Nov 13 17:05:09 +0100 OX-maintenance-56460a34c9739 [     info]  Task begin: OX_Maintenance_Statistics_Task_ManageConversions
Nov 13 17:05:09 +0100 OX-maintenance-56460a34c9739 [     info]  Task complete: OX_Maintenance_Statistics_Task_ManageConversions
Nov 13 17:05:09 +0100 OX-maintenance-56460a34c9739 [     info]  Task begin: OX_Maintenance_Statistics_Task_SummariseFinal
Nov 13 17:05:09 +0100 OX-maintenance-56460a34c9739 [     info]  Task complete: OX_Maintenance_Statistics_Task_SummariseFinal
Nov 13 17:05:09 +0100 OX-maintenance-56460a34c9739 [     info]  Task begin: OX_Maintenance_Statistics_Task_LogCompletion
Nov 13 17:05:09 +0100 OX-maintenance-56460a34c9739 [     info]  Task complete: OX_Maintenance_Statistics_Task_LogCompletion
Nov 13 17:05:09 +0100 OX-maintenance-56460a34c9739 [     info]  Task begin: OX_Maintenance_Statistics_Task_ManageCampaigns
Nov 13 17:05:09 +0100 OX-maintenance-56460a34c9739 [     info]  - Managing (activating/deactivating) campaigns
Nov 13 17:05:09 +0100 OX-maintenance-56460a34c9739 [     info]  Task complete: OX_Maintenance_Statistics_Task_ManageCampaigns
Nov 13 17:05:09 +0100 OX-maintenance-56460a34c9739 [     info]  Maintenance Statistics Engine Completed (Started at 2015-11-13 16:05:09 UTC)
Nov 13 17:05:09 +0100 OX-maintenance-56460a34c9739 [     info]  Running Maintenance Priority Engine
Nov 13 17:05:09 +0100 OX-maintenance-56460a34c9739 [     info]  Task begin: OA_Maintenance_Priority_AdServer_Task_GetRequiredAdImpressionsLifetime
Nov 13 17:05:09 +0100 OX-maintenance-56460a34c9739 [     info]  Task complete: OA_Maintenance_Priority_AdServer_Task_GetRequiredAdImpressionsLifetime
Nov 13 17:05:09 +0100 OX-maintenance-56460a34c9739 [     info]  Task begin: OA_Maintenance_Priority_AdServer_Task_GetRequiredAdImpressionsDaily
Nov 13 17:05:09 +0100 OX-maintenance-56460a34c9739 [     info]  Task complete: OA_Maintenance_Priority_AdServer_Task_GetRequiredAdImpressionsDaily
Nov 13 17:05:09 +0100 OX-maintenance-56460a34c9739 [     info]  Task begin: OA_Maintenance_Priority_AdServer_Task_AllocateZoneImpressions
Nov 13 17:05:09 +0100 OX-maintenance-56460a34c9739 [     info]    - Selecting Zones forecasts for all managers for OI from 2015-11-13 16:00:00 to 2015-11-13 16:59:59
Nov 13 17:05:09 +0100 OX-maintenance-56460a34c9739 [     info]  Inserted 182 rows in the table tmp_ad_zone_impression
Nov 13 17:05:09 +0100 OX-maintenance-56460a34c9739 [     info]  Task complete: OA_Maintenance_Priority_AdServer_Task_AllocateZoneImpressions
Nov 13 17:05:09 +0100 OX-maintenance-56460a34c9739 [     info]  Task begin: OA_Maintenance_Priority_AdServer_Task_PriorityCompensation
Nov 13 17:05:09 +0100 OX-maintenance-56460a34c9739 [     info]    - Selecting Zones forecasts for all managers for OI from 2015-11-13 16:00:00 to 2015-11-13 16:59:59
Nov 13 17:05:09 +0100 OX-maintenance-56460a34c9739 [     info]  Task complete: OA_Maintenance_Priority_AdServer_Task_PriorityCompensation
Nov 13 17:05:09 +0100 OX-maintenance-56460a34c9739 [     info]  Task begin: OA_Maintenance_Priority_AdServer_Task_ECPMforContract
Nov 13 17:05:09 +0100 OX-maintenance-56460a34c9739 [     info]  - Selecting All Managers
Nov 13 17:05:09 +0100 OX-maintenance-56460a34c9739 [     info]    - Selecting active campaigns with priority = '9' for manager 1
Nov 13 17:05:09 +0100 OX-maintenance-56460a34c9739 [     info]    - Selecting active campaigns with priority = '8' for manager 1
Nov 13 17:05:09 +0100 OX-maintenance-56460a34c9739 [     info]    - Selecting active campaigns with priority = '7' for manager 1
Nov 13 17:05:09 +0100 OX-maintenance-56460a34c9739 [     info]    - Selecting active campaigns with priority = '6' for manager 1
Nov 13 17:05:09 +0100 OX-maintenance-56460a34c9739 [     info]  Task complete: OA_Maintenance_Priority_AdServer_Task_ECPMforContract
Nov 13 17:05:09 +0100 OX-maintenance-56460a34c9739 [     info]  Task begin: OA_Maintenance_Priority_AdServer_Task_ECPMforRemnant
Nov 13 17:05:09 +0100 OX-maintenance-56460a34c9739 [     info]  - Selecting Managers with ECPM priority campaigns running
Nov 13 17:05:09 +0100 OX-maintenance-56460a34c9739 [     info]  Task complete: OA_Maintenance_Priority_AdServer_Task_ECPMforRemnant
Nov 13 17:05:09 +0100 OX-maintenance-56460a34c9739 [     info]  Maintenance Priority Engine Completed (Started at 2015-11-13 16:05:09 UTC)
Nov 13 17:05:09 +0100 OX-maintenance-56460a34c9739 [     info]  Maintenance Engine Completed (Started at 2015-11-13 16:05:09 UTC, taking 00:00:00)
Nov 13 17:05:09 +0100 OX-56460a34c9739 [     info]  Automatic Maintenance Task Completed

but there are still no stats fore the time after July 13 available :-(

Any ideas or hints?

Michael

 

 

FvLW Newbie

FvLW

Posted
  • Author
Posted

Hi,

after some additional try & error work (e.g. reinstalling the plugins) new stats are available, but not the older ones.
So there is a gap starting 2015-07-13 19:00 and ending 2015-11-13 17:59

Is there a realistic chance to recover these missing values?

Regards
Michael

 

 

 

 

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.

×
 Share
Go to topic listing


×
×
  • Create New...