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

Reporting: ReportService getDistributions call returns incorrect results based on date range

    Details

    • Type: Bug
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: unspecified
    • Fix Version/s: None
    • Component/s: Async Reporting
    • Labels:
      None
    • Environment:

      Operating System: Linux
      Platform: PC

      Description

      There is a distribution called ePilot that only shows up in Netquote account 311
      on 1/27-28. If you make the following web services call you get back epilot

      <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"
      xmlns:urn="urn:v2.ReportService.services.thesearchagency.com">
      <soapenv:Header/>
      <soapenv:Body>
      <urn:getDistributions>
      <!-Optional:->
      <distributionInputBean>
      <!-Zero or more repetitions:->
      <accounts>311</accounts>
      <!-Optional:->
      <channelFilter>
      <!-Zero or more repetitions:->
      <channels>1</channels>
      <in>true</in>
      <!-Optional:->
      <tagged></tagged>
      </channelFilter>
      <!-Zero or more repetitions:->
      <TSADateRange>
      <!-Optional:->
      <end>2009-01-15T23:59:59-08:00</end>
      <!-Optional:->
      <start>2009-01-01T00:00:00-08:00</start>
      </TSADateRange>
      </distributionInputBean>
      </urn:getDistributions>
      </soapenv:Body>
      </soapenv:Envelope>

      even though traffic was outside the range

      If you make the following call, you do not get back epilot

      <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"
      xmlns:urn="urn:v2.ReportService.services.thesearchagency.com">
      <soapenv:Header/>
      <soapenv:Body>
      <urn:getDistributions>
      <!-Optional:->
      <distributionInputBean>
      <!-Zero or more repetitions:->
      <accounts>311</accounts>
      <!-Optional:->
      <channelFilter>
      <!-Zero or more repetitions:->
      <channels>1</channels>
      <in>true</in>
      <!-Optional:->
      <tagged></tagged>
      </channelFilter>
      <!-Zero or more repetitions:->
      <TSADateRange>
      <!-Optional:->
      <end>2009-02-15T23:59:59-08:00</end>
      <!-Optional:->
      <start>2009-01-015T00:00:00-08:00</start>
      </TSADateRange>
      </distributionInputBean>
      </urn:getDistributions>
      </soapenv:Body>
      </soapenv:Envelope>

      even though it is inside the date range

      and the following brings back no distributions at all:

      <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"
      xmlns:urn="urn:v2.ReportService.services.thesearchagency.com">
      <soapenv:Header/>
      <soapenv:Body>
      <urn:getDistributions>
      <!-Optional:->
      <distributionInputBean>
      <!-Zero or more repetitions:->
      <accounts>311</accounts>
      <!-Optional:->
      <channelFilter>
      <!-Zero or more repetitions:->
      <channels>1</channels>
      <in>true</in>
      <!-Optional:->
      <tagged></tagged>
      </channelFilter>
      <!-Zero or more repetitions:->
      <TSADateRange>
      <!-Optional:->
      <end>2009-01-15T23:59:59-08:00</end>
      <!-Optional:->
      <start>2009-01-02T00:00:00-08:00</start>
      </TSADateRange>
      </distributionInputBean>
      </urn:getDistributions>
      </soapenv:Body>
      </soapenv:Envelope>

      It appears that the distributions are being pulled somehow based on the monthly
      data for the months in the date range that have the first in them - which is odd
      and perhaps wrong. This is causing Abhi some problems with Netquote reporting
      out in LA.

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              bduffy Bill Duffy (Inactive)
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated: