[TSAApp@aq-qa2-core1 bidmgr]$ ./sedatacheck.sh -d3 -U273 -T2016-04-22 -E2016-04-26
------- Loaded DatabaseAccounts properties from file:/usr/local/tsa/bidmgr-distribution-2.9.1-RC2-dev-t20160509-2152/libs/deployment-bidmgr-shaded-jar-2.9.1-RC2.jar!/core-jdb-datasource.properties -------
{datasource-user=spike, datasource-password=tar63t}
2016-05-10 15:03:15.575 (3) [main]: Debug Level set to 3
2016-05-10 15:03:15.602 (3) [main]: Licensing environment detected, loading configuration.
2016-05-10 15:03:15.606 (3) [main]: Loaded property: distribution-service-url=http://aq-qa2-front1:8080/distribution
2016-05-10 15:03:15.607 (3) [main]: Loaded property: distribution-service-username=readwrite
2016-05-10 15:03:15.607 (3) [main]: Loaded property: distribution-service-password=readwrite
2016-05-10 15:03:15.607 (3) [main]: Loaded property: sapi-auth-url=http://aq-qa2-front1:8080/sapi/rest/security/tokens
2016-05-10 15:03:15.608 (3) [main]: Loaded property: sapi-merchant-service-url=http://aq-qa2-front1:8080/sapi/rest/merchants
2016-05-10 15:03:15.608 (3) [main]: Loaded property: sapi-reseller-service-url=http://aq-qa2-front1:8080/sapi/rest/resellers
2016-05-10 15:03:15.609 (3) [main]: Loaded property: sapi-username=admin+tsa@thesearchagency.com
2016-05-10 15:03:15.609 (3) [main]: Loaded property: sapi-password=admin
2016-05-10 15:03:15.609 (3) [main]: Loaded property: sapi-realm=thesearchagency
2016-05-10 15:03:15.610 (3) [main]: Loaded property: tsa.google.mcc.developerToken=ojCnjZaM6RD1h0yt_DOJZg
2016-05-10 15:03:15.610 (3) [main]: Loaded property: tsa.google.mcc.isReseller=true
2016-05-10 15:03:15.611 (3) [main]: Loaded property: tsa.timezone=UTC
2016-05-10 15:03:16.302 (3) [main]: DatabasePool with a limit of 7 created
2016-05-10 15:03:16.890 (3) [main]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver)
2016-05-10 15:03:16.936 (3) [main]: Debug Level set to 3
2016-05-10 15:03:16.937 (3) [main]: =============== Starting Search Engine Data Checker ================
2016-05-10 15:03:16.937 (3) [main]: ---------------- Distribution Dispatcher for Search Engine Data Checker starting
2016-05-10 15:03:16.988 (3) [P1T1]: Starting Distribution 147
2016-05-10 15:03:16.988 (3) [P1T1]: ----------------Search Engine Data Checker - Distribution Worker starting
2016-05-10 15:03:17.041 (3) [P1T1]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver)
2016-05-10 15:03:17.055 (3) [P2T1]: Starting User (273) "bb9971f9-36db-47fa-a079-c4b1d3d5699d_1_orange_Performance_Account_1"
2016-05-10 15:03:17.107 (3) [P2T1]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver)
2016-05-10 15:03:20 INFO  [P2T1] com.thesearchagency.services.client.bing.impl.BingAdsServiceFactory:52 - USING PRODUCTION ENVIRONMENT
2016-05-10 15:03:21 INFO  [P2T1] org.apache.cxf.wsdl.service.factory.ReflectionServiceFactoryBean:434 - Creating Service {https://bingads.microsoft.com/Reporting/v9}ReportingService from class com.microsoft.bingads.reporting.IReportingService
2016-05-10 15:03:24 INFO  [P2T1] org.apache.cxf.wsdl.service.factory.ReflectionServiceFactoryBean:434 - Creating Service {https://bingads.microsoft.com/Reporting/v9}ReportingService from class com.microsoft.bingads.reporting.IReportingService
2016-05-10 15:03:27 INFO  [P2T1] org.apache.cxf.services.ReportingService.IReportingServicePort.IReportingService:253 - Outbound Message
---------------------------
ID: 1
Address: https://api.bingads.microsoft.com/Api/Advertiser/Reporting/v9/ReportingService.svc
Encoding: UTF-8
Http-Method: POST
Content-Type: text/xml
Headers: {Accept=[*/*], SOAPAction=[SubmitGenerateReport]}
Payload: <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Header><CustomerAccountId xmlns="https://bingads.microsoft.com/Reporting/v9">79071449</CustomerAccountId><CustomerId xmlns="https://bingads.microsoft.com/Reporting/v9">50168750</CustomerId><DeveloperToken xmlns="https://bingads.microsoft.com/Reporting/v9">DN8ELHL3</DeveloperToken><UserName xmlns="https://bingads.microsoft.com/Reporting/v9">API_TheSearchAgency</UserName><Password xmlns="https://bingads.microsoft.com/Reporting/v9">Pa55w0rd</Password></soap:Header><soap:Body><SubmitGenerateReportRequest xmlns="https://bingads.microsoft.com/Reporting/v9" xmlns:ns2="https://adapi.microsoft.com" xmlns:ns3="http://schemas.microsoft.com/2003/10/Serialization/Arrays" xmlns:ns4="http://schemas.microsoft.com/2003/10/Serialization/"><ReportRequest xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="CampaignPerformanceReportRequest"><Format>Xml</Format><Language>English</Language><ReportName>Bing Data Check</ReportName><ReturnOnlyCompleteData xsi:nil="true"/><Aggregation>Daily</Aggregation><Columns><CampaignPerformanceReportColumn>TimePeriod</CampaignPerformanceReportColumn><CampaignPerformanceReportColumn>CampaignId</CampaignPerformanceReportColumn><CampaignPerformanceReportColumn>CampaignName</CampaignPerformanceReportColumn><CampaignPerformanceReportColumn>Impressions</CampaignPerformanceReportColumn><CampaignPerformanceReportColumn>Clicks</CampaignPerformanceReportColumn><CampaignPerformanceReportColumn>Spend</CampaignPerformanceReportColumn></Columns><Filter xsi:nil="true"/><Scope><AccountIds><ns3:long>79071449</ns3:long></AccountIds><Campaigns xsi:nil="true"/></Scope><Time><CustomDateRangeEnd><Day>26</Day><Month>4</Month><Year>2016</Year></CustomDateRangeEnd><CustomDateRangeStart><Day>22</Day><Month>4</Month><Year>2016</Year></CustomDateRangeStart><PredefinedTime xsi:nil="true"/></Time></ReportRequest></SubmitGenerateReportRequest></soap:Body></soap:Envelope>
--------------------------------------
2016-05-10 15:03:33 INFO  [P2T1] org.apache.cxf.services.ReportingService.IReportingServicePort.IReportingService:253 - Inbound Message
----------------------------
ID: 1
Response-Code: 200
Encoding: UTF-8
Content-Type: text/xml; charset=utf-8
Headers: {Content-Length=[396], content-type=[text/xml; charset=utf-8], Date=[Tue, 10 May 2016 15:03:32 GMT], Server=[Microsoft-IIS/8.0], X-Powered-By=[ASP.NET]}
Payload: <s:Envelope xmlns:s="http://schemas.xmlsoap.org/soap/envelope/"><s:Header><h:TrackingId xmlns:h="https://bingads.microsoft.com/Reporting/v9">1e56f39f-24fa-46db-b80f-b70a14426821</h:TrackingId></s:Header><s:Body><SubmitGenerateReportResponse xmlns="https://bingads.microsoft.com/Reporting/v9"><ReportRequestId>3000002244595630</ReportRequestId></SubmitGenerateReportResponse></s:Body></s:Envelope>
--------------------------------------
2016-05-10 15:03:33 INFO  [P2T1] com.thesearchagency.services.client.bing.impl.serviceclient.ReportServiceClient:96 - Successfully submitted generate report request for reportType: DATA_CHECK, accounts:[79071449]
2016-05-10 15:03:33 INFO  [P2T1] org.apache.cxf.services.ReportingService.IReportingServicePort.IReportingService:253 - Outbound Message
---------------------------
ID: 2
Address: https://api.bingads.microsoft.com/Api/Advertiser/Reporting/v9/ReportingService.svc
Encoding: UTF-8
Http-Method: POST
Content-Type: text/xml
Headers: {Accept=[*/*], SOAPAction=[PollGenerateReport]}
Payload: <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Header><CustomerAccountId xmlns="https://bingads.microsoft.com/Reporting/v9">79071449</CustomerAccountId><CustomerId xmlns="https://bingads.microsoft.com/Reporting/v9">50168750</CustomerId><DeveloperToken xmlns="https://bingads.microsoft.com/Reporting/v9">DN8ELHL3</DeveloperToken><UserName xmlns="https://bingads.microsoft.com/Reporting/v9">API_TheSearchAgency</UserName><Password xmlns="https://bingads.microsoft.com/Reporting/v9">Pa55w0rd</Password></soap:Header><soap:Body><PollGenerateReportRequest xmlns="https://bingads.microsoft.com/Reporting/v9" xmlns:ns2="https://adapi.microsoft.com" xmlns:ns3="http://schemas.microsoft.com/2003/10/Serialization/Arrays" xmlns:ns4="http://schemas.microsoft.com/2003/10/Serialization/"><ReportRequestId>3000002244595630</ReportRequestId></PollGenerateReportRequest></soap:Body></soap:Envelope>
--------------------------------------
2016-05-10 15:03:39 INFO  [P2T1] org.apache.cxf.services.ReportingService.IReportingServicePort.IReportingService:253 - Inbound Message
----------------------------
ID: 2
Response-Code: 200
Encoding: UTF-8
Content-Type: text/xml; charset=utf-8
Headers: {Content-Length=[1001], content-type=[text/xml; charset=utf-8], Date=[Tue, 10 May 2016 15:03:38 GMT], Server=[Microsoft-IIS/8.0], X-Powered-By=[ASP.NET]}
Payload: <s:Envelope xmlns:s="http://schemas.xmlsoap.org/soap/envelope/"><s:Header><h:TrackingId xmlns:h="https://bingads.microsoft.com/Reporting/v9">a82876f2-3dc9-4fdd-8336-2118aefb8bab</h:TrackingId></s:Header><s:Body><PollGenerateReportResponse xmlns="https://bingads.microsoft.com/Reporting/v9"><ReportRequestStatus xmlns:i="http://www.w3.org/2001/XMLSchema-instance"><ReportDownloadUrl>https://dvsrdl.api.bingads.microsoft.com/ReportDownload/Download.aspx?q=oAFfP5MgzAeHjoyl1BYMcQ52nYwCP1vly5sEjyxEg0KLPr8N42KIxEbhlSDuGQUgBIFzf%2fUuXKzrPaImn7kHhiq8yrjVg8l%2f1%2bbOaWMwUxXuD36fpa%2fKIb0Vli1BnQUI9Bv9gjCtPkgmyj4Nrl5qow4OVMYB%2fqGQFtl8Wpa2VrbmURtIYp1HfdMTWaG506VxMvsrmUnZXjRcaFHjYLQ7yPUgND38aQXFLdVLHASOfZ80lJfDmVA3edUZIrf9miIBY48LWT7fh17iA2BVxMBAMea6KHWbx8R8%2boNFSdP7zI1BN%2be4mvmbRgbZn7h7FNz2ShHaMxOIK18UUG949kNiRyd8uXAuwAFeuG9OuxgNTs5j%2fNPeTEKt%2fHp9HpUhX4Z%2fFuD8w7t9ENgfePAvqgHFfqY%3d</ReportDownloadUrl><Status>Success</Status></ReportRequestStatus></PollGenerateReportResponse></s:Body></s:Envelope>
--------------------------------------
2016-05-10 15:03:39 INFO  [P2T1] com.thesearchagency.services.client.bing.impl.serviceclient.ReportServiceClient:146 - Successfully polled report request for report ID: 3000002244595630
2016-05-10 15:03:40.510 (3) [P2T1]: Parsing /var/local/tsa/sedata/bing/tsa-check-report-daily-2016-04-22-2016-04-26-U273.xml.zip into staging database
2016-05-10 15:03:40.606 (3) [P2T1]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver)
2016-05-10 15:03:40.613 (3) [P2T1]: DatabasePool with a limit of 7 created
2016-05-10 15:03:40.663 (3) [P2T1]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver)
2016-05-10 15:03:40.677 (3) [P2T1]:   Deleting existing records where ((`date`>="2016-04-22") and (`date`<"2016-04-26") and (`campaignid` in ("248595311","248595312","248600313","248600314")))
2016-05-10 15:03:40.685 (3) [P2T1]:   Inserting new data into `staging`.`bingDailyCheck`
2016-05-10 15:03:40.802 (3) [P2T1]: Finished User (273) "bb9971f9-36db-47fa-a079-c4b1d3d5699d_1_orange_Performance_Account_1"
2016-05-10 15:03:40.836 (3) [P1T1]: ------------Search Engine Data Checker - Distribution Worker done
2016-05-10 15:03:40.837 (3) [main]: ------------ Distribution Dispatcher for Search Engine Data Checker done
2016-05-10 15:03:40.837 (3) [main]: =============== Completed Search Engine Data Checker ================
2016-05-10 15:03:40.838 (3) [main]: Search Engine Data Checker: 23.901s
2016-05-10 15:03:40.838 (3) [main]:     by key:
2016-05-10 15:03:40.839 (3) [main]:         db: 0.033s
2016-05-10 15:03:40.839 (3) [main]:             by thread:
2016-05-10 15:03:40.839 (3) [main]:                 P2T1:       0.028s
2016-05-10 15:03:40.839 (3) [main]:                 P1T1:       0.003s
2016-05-10 15:03:40.839 (3) [main]:                 main:       0.002s
2016-05-10 15:03:40.839 (3) [main]:         other:      23.868s