Uploaded image for project: 'AdMax'
  1. AdMax
  2. ADMAX-2661

hourly data is not making it into warehouse

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: TSA Tracking
    • Labels:
      None
    • Environment:

      dc1bos production

      bidmgr trunk build 418

      Description

      mysql> select sum(pixClicks ) from whDailyGroupPerf where accountid=759 and startTime ='2011-05-18';

      -----------------

      sum(pixClicks )

      -----------------

      30467

      -----------------

      1 row in set (0.04 sec)

      mysql> select sum(pixClicks ) from whHourlyGroupPerf where accountid=759 and startTime ='2011-05-18';

      -----------------

      sum(pixClicks )

      -----------------

      NULL

      -----------------

      1 row in set (0.67 sec)

      mysql> select sum(pixClicks ) from whHourlySourcePerf where accountid=759 and startTime ='2011-05-18';

      -----------------

      sum(pixClicks )

      -----------------

      NULL

      -----------------

      1 row in set (1.66 sec)

        Attachments

          Activity

            People

            • Assignee:
              therouxj Jeff Theroux
              Reporter:
              therouxj Jeff Theroux
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: