DATAFED: Business Area Performance Summary report doesn't show the correct data in the reports.

Business Area Performance Summary report doesn't show the correct data in the reports.

Steps:

1.Generate the data by processing Pixels and calldatafeeds.

2.Send SOAP request

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:dat="http://www.thesearchagency.com/smb/DataFeedService/">

<soapenv:Header/>

<soapenv:Body>

<dat:executeJobFromFileSystemRepository>

<!-Optional:->

<job name="Job 1">

<!-Optional:->

<variables>

<!-Zero or more repetitions:->

<variable key="START_DATE" value="2012-02-17"/>

<variable key="END_DATE" value="2012-02-22"/>

</variables>

</job>

</dat:executeJobFromFileSystemRepository>

</soapenv:Body>

</soapenv:Envelope>

3. Check the generated outbound report to '/home/optus/datafeeds'

[gsingh@optus-qa-agency1 datafeeds]$ ls -lrt

total 28

drwxr-xr-x 2 root root 12288 Feb 24 21:02 old

rw-rr- 1 root root 561 Feb 24 21:06 AcctPerfSum_2012-02-17_2012-02-22.zip

rw-rr- 1 root root 384 Feb 24 21:06 AcctPerfDist_2012-02-17_2012-02-22.zip

rw-rr- 1 root root 465 Feb 24 21:06 CampStatus_2012-02-17_2012-02-22.zip

rw-rr- 1 root root 344 Feb 24 21:06 BusAreaPerf_2012-02-17_2012-02-22.zip

rw-rr- 1 root root 0 Feb 24 21:09 CampStatus_2012-02-17_2012-02-22.done

rw-rr- 1 root root 0 Feb 24 21:09 BusAreaPerf_2012-02-17_2012-02-22.done

rw-rr- 1 root root 0 Feb 24 21:09 AcctPerfSum_2012-02-17_2012-02-22.done

rw-rr- 1 root root 0 Feb 24 21:09 AcctPerfDist_2012-02-17_2012-02-22.done

4.sudo unzip BusAreaPerf_2012-02-17_2012-02-22.zip

Archive: BusAreaPerf_2012-02-17_2012-02-22.zip

inflating: BusAreaPerf_2012-02-17_2012-02-22.csv

[gsingh@optus-qa-agency1 datafeeds]$ cat BusAreaPerf_2012-02-17_2012-02-22.csv

Date,BusinessAreaID,Impressions,Clicks,Spend,Nominal_Budget,Pageviews,SocialMediaClicks,WebsiteClicks,ContactUsLeads

2012-02-17 00:00:00.0,2000062,0,0,0.0,594.0,0,0,0,0

2012-02-18 00:00:00.0,2000062,0,0,0.0,594.0,0,0,0,0

2012-02-19 00:00:00.0,2000062,0,0,0.0,594.0,0,0,0,0

2012-02-20 00:00:00.0,2000062,0,0,0.0,594.0,0,0,0,0

2012-02-21 00:00:00.0,2000062,0,0,0.0,594.0,0,0,0,0

2012-02-22 00:00:00.0,2000062,0,0,0.0,594.0,0,0,0,0

Also accountPerfSum_rsData shows ZERO values for "searchEngineAccountID "

mysql> select * from accountPerfSum_rsData;

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

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

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

2 rows in set (0.00 sec)