[TSAApp@aml-qa3-core1 bidmgr]$ ./googlemcc.sh -T 2016-03-28 -d3 -U 243
2016-03-29 07:33:50.854 (3) [main]: Debug Level set to 3
2016-03-29 07:33:50.856 (3) [main]: Licensing environment detected, loading configuration.
2016-03-29 07:33:50.857 (3) [main]: Loaded property: tsa.google.mcc.clientId=52743837274-afi7bmlos17ebmjcl0vm0hcn7bg6vbpj.apps.googleusercontent.com
2016-03-29 07:33:50.857 (3) [main]: Loaded property: tsa.google.mcc.clientSecret=jI2Y0Xgn4_dXV8mgb6o1hLc0
2016-03-29 07:33:50.857 (3) [main]: Loaded property: tsa.google.mcc.refreshToken=1/JAnPzJJCbj0OfnOZubIzr0i4KYxZAKVnsnArlp40k4w
2016-03-29 07:33:50.857 (3) [main]: Loaded property: tsa.google.mcc.developerToken=ojCnjZaM6RD1h0yt_DOJZg
2016-03-29 07:33:50.858 (3) [main]: Loaded property: tsa.google.mcc.isReseller=true
2016-03-29 07:33:50.858 (3) [main]: Loaded property: tsa.google.mcc.userAgent=AdMaxLocal AdWords Software TSA QA
2016-03-29 07:33:50.858 (3) [main]: Loaded property: tsa.timezone=UTC
2016-03-29 07:33:50.876 (3) [main]: Debug Level set to 3
2016-03-29 07:33:50.957 (3) [main]: =============== Starting Google MCC Report ================
2016-03-29 07:33:50.957 (3) [main]: ----------------Google MCC Report starting
2016-03-29 07:33:51.228 (3) [main]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver)
2016-03-29 07:33:51.279 (3) [P1T1]: === Starting user #243, 38610cc9-de5e-47c0-bacd-57fea3af1926_1 ===
2016-03-29 07:33:51.279 (3) [P1T1]: Using filename: /var/local/tsa/sedata/google/tsa-mcc-report-2016-03-28-U243_7230771065.xml.gz
2016-03-29 07:33:51.477 (3) [P1T1]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver)
2016-03-29 07:33:51.506 (3) [P1T1]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver)
2016-03-29 07:33:51.573 (3) [P1T1]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver)
2016-03-29 07:33:51.573 (3) [P1T1]: Created shared sesystem connection rw
2016-03-29 07:33:51.592 (3) [P1T1]: [oauth] Creating new OAuthService component
2016-03-29 07:33:51,953 [P1T1] INFO  c.t.s.o.core.OAuthServiceComponent - [oauth] Creating new OAuthServiceComponent
2016-03-29 07:33:52,167 [P1T1] INFO  c.t.s.o.core.OAuthServiceComponent - [oauth] Getting new access token
2016-03-29 07:33:53,377 [P1T1] INFO  c.t.s.o.core.OAuthServiceComponent - [oauth] Return OAuth credential. Access token = ya29.tAIzfa7Jfh5Niz7O92FDgrAe8o2d7S_PIIYEGBJWo7qXSmgmxQgH5iTGUR_7GZjqW4Ib4G8
2016-03-29 07:33:53.377 (3) [P1T1]: [oauth] Returning access token from OAuth service: ya29.tAIzfa7Jfh5Niz7O92FDgrAe8o2d7S_PIIYEGBJWo7qXSmgmxQgH5iTGUR_7GZjqW4Ib4G8
2016-03-29 07:33:53,378 [P1T1] INFO  c.t.s.o.core.OAuthServiceComponent - [oauth] Return OAuth credential. Access token = ya29.tAIzfa7Jfh5Niz7O92FDgrAe8o2d7S_PIIYEGBJWo7qXSmgmxQgH5iTGUR_7GZjqW4Ib4G8
2016-03-29 07:33:53.378 (3) [P1T1]: [oauth] Returning access token from OAuth service: ya29.tAIzfa7Jfh5Niz7O92FDgrAe8o2d7S_PIIYEGBJWo7qXSmgmxQgH5iTGUR_7GZjqW4Ib4G8
2016-03-29 07:33:53.378 (3) [P1T1]: Downloading MCC report...
2016-03-29 07:33:54,291 [P1T1] INFO  c.g.a.a.a.lib.utils.report_download - Request made: POST https://adwords.google.com//api/adwords/reportdownload/v201601

2016-03-29 07:33:54,293 [P1T1] INFO  c.g.a.a.a.lib.utils.report_download - accept-encoding: [gzip]
authorization: REDACTED
user-agent: [AdMaxLocal AdWords Software TSA QA (AwApi-Java, Common-Java/2.11.0, Java/1.6.0_27, maven)]
developertoken: REDACTED
clientcustomerid: 7230771065

Parameters:
__fmt: GZIPPED_XML
__rdquery: SELECT CampaignId,AdGroupId,KeywordId,Id,AdNetworkType1,Impressions,Clicks,Cost,AveragePosition,Conversions FROM AD_PERFORMANCE_REPORT WHERE Impressions > 0 DURING 20160328,20160328

2016-03-29 07:33:54,293 [P1T1] INFO  c.g.a.a.a.lib.utils.report_download - Response received with status code 200 and message: OK

2016-03-29 07:33:54.294 (3) [P1T1]: Got OK response from google, trying to output the file /var/local/tsa/sedata/google/tsa-mcc-report-adperformance-2016-03-28-U243_7230771065.xml.gz
2016-03-29 07:33:54,654 [P1T1] INFO  c.g.a.a.a.lib.utils.report_download - Request made: POST https://adwords.google.com//api/adwords/reportdownload/v201601

2016-03-29 07:33:54,656 [P1T1] INFO  c.g.a.a.a.lib.utils.report_download - accept-encoding: [gzip]
authorization: REDACTED
user-agent: [AdMaxLocal AdWords Software TSA QA (AwApi-Java, Common-Java/2.11.0, Java/1.6.0_27, maven)]
developertoken: REDACTED
clientcustomerid: 7230771065

Parameters:
__fmt: GZIPPED_XML
__rdquery: SELECT CampaignId,AdGroupId,Id,KeywordMatchType,QualityScore,FirstPageCpc,CpcBid,CpcBidSource,Impressions FROM KEYWORDS_PERFORMANCE_REPORT WHERE Impressions > 0 DURING 20160328,20160328

2016-03-29 07:33:54,656 [P1T1] INFO  c.g.a.a.a.lib.utils.report_download - Response received with status code 200 and message: OK

2016-03-29 07:33:54.656 (3) [P1T1]: Got OK response from google, trying to output the file /var/local/tsa/sedata/google/tsa-mcc-report-kwperformance-2016-03-28-U243_7230771065.xml.gz
2016-03-29 07:33:55,191 [P1T1] INFO  c.g.a.a.a.lib.utils.report_download - Request made: POST https://adwords.google.com//api/adwords/reportdownload/v201601

2016-03-29 07:33:55,192 [P1T1] INFO  c.g.a.a.a.lib.utils.report_download - accept-encoding: [gzip]
authorization: REDACTED
user-agent: [AdMaxLocal AdWords Software TSA QA (AwApi-Java, Common-Java/2.11.0, Java/1.6.0_27, maven)]
developertoken: REDACTED
clientcustomerid: 7230771065

Parameters:
__fmt: GZIPPED_XML
__rdquery: SELECT CampaignId,AdGroupId,CriteriaId,CreativeId,AdNetworkType1,GclId,ClickType,Device FROM CLICK_PERFORMANCE_REPORT DURING 20160328,20160328

2016-03-29 07:33:55,193 [P1T1] INFO  c.g.a.a.a.lib.utils.report_download - Response received with status code 200 and message: OK

2016-03-29 07:33:55.193 (3) [P1T1]: Got OK response from google, trying to output the file /var/local/tsa/sedata/google/tsa-mcc-report-clickperformance-2016-03-28-U243_7230771065.xml.gz
2016-03-29 07:33:55.196 (3) [P1T1]: MCC report download (Mon Mar 28 00:00:00 UTC 2016, "/var/local/tsa/sedata/google/tsa-mcc-report-2016-03-28-U243_7230771065.xml.gz") -> success:true
2016-03-29 07:33:55.196 (3) [P1T1]: Parsing AdPerformance MCC report into staging database...
2016-03-29 07:33:55.197 (3) [P1T1]:   Finding column names...
2016-03-29 07:33:55.223 (3) [P1T1]:   Writing temp infile...
2016-03-29 07:33:55.263 (3) [P1T1]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver)
2016-03-29 07:33:55.269 (3) [P1T1]: DatabasePool with a limit of 12 created
2016-03-29 07:33:55.290 (3) [P1T1]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver)
2016-03-29 07:33:55.301 (3) [P1T1]:   Deleted 0 existing records where ((`startTime`="2016-03-28 00:00:00") and (`campaignid` in ("358192473","358192593")))
2016-03-29 07:33:55.301 (3) [P1T1]:   Loading data infile into temp table...
2016-03-29 07:33:55.386 (1) [P1T1]: Exception [Error on line 1: 2016-03-28      358192473       27801156393     24337746785     89201238393     Search Only     1       0       0       7.0     0.0]:java.lang.NumberFormatException: For input string: "0.0"
        at java.lang.NumberFormatException.forInputString(NumberFormatException.java:48)
        at java.lang.Integer.parseInt(Integer.java:458)
        at java.lang.Integer.valueOf(Integer.java:554)
        at com.thesearchagency.db.util.BatchInsertUtil.getTypeValue(BatchInsertUtil.java:409)
        at com.thesearchagency.db.util.BatchInsertUtil.parseFileUsingSplit(BatchInsertUtil.java:327)
        at com.thesearchagency.db.util.BatchInsertUtil.batchInsertFromFile(BatchInsertUtil.java:156)
        at com.thesearchagency.db.util.BatchInsertUtil.batchInsertFromFile(BatchInsertUtil.java:83)
        at com.thesearchagency.db.util.BatchInsertUtil.batchInsertFromFile(BatchInsertUtil.java:60)
        at com.thesearchagency.searchengines.google.GoogleAPISearchEngine.parseAdPerformanceReport(GoogleAPISearchEngine.java:2026)
        at com.thesearchagency.searchengines.google.GoogleAPISearchEngine.parseGoogleMCCReport(GoogleAPISearchEngine.java:1834)
        at com.thesearchagency.searchengines.google.GoogleMCCReport$SearchEngineUserWorker.call(GoogleMCCReport.java:369)
        at com.thesearchagency.searchengines.google.GoogleMCCReport$SearchEngineUserWorker.call(GoogleMCCReport.java:295)
        at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
        at java.util.concurrent.FutureTask.run(FutureTask.java:138)
        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
        at java.lang.Thread.run(Thread.java:662)

2016-03-29 07:33:55.386 (1) [P1T1]: Exception [error inserting SQL rows into `tmp`.`tmp1` from file /tmp/goAd2016-03-282913757141372393294.tmp]:java.lang.NumberFormatException: For input string: "0.0"
        at java.lang.NumberFormatException.forInputString(NumberFormatException.java:48)
        at java.lang.Integer.parseInt(Integer.java:458)
        at java.lang.Integer.valueOf(Integer.java:554)
        at com.thesearchagency.db.util.BatchInsertUtil.getTypeValue(BatchInsertUtil.java:409)
        at com.thesearchagency.db.util.BatchInsertUtil.parseFileUsingSplit(BatchInsertUtil.java:327)
        at com.thesearchagency.db.util.BatchInsertUtil.batchInsertFromFile(BatchInsertUtil.java:156)
        at com.thesearchagency.db.util.BatchInsertUtil.batchInsertFromFile(BatchInsertUtil.java:83)
        at com.thesearchagency.db.util.BatchInsertUtil.batchInsertFromFile(BatchInsertUtil.java:60)
        at com.thesearchagency.searchengines.google.GoogleAPISearchEngine.parseAdPerformanceReport(GoogleAPISearchEngine.java:2026)
        at com.thesearchagency.searchengines.google.GoogleAPISearchEngine.parseGoogleMCCReport(GoogleAPISearchEngine.java:1834)
        at com.thesearchagency.searchengines.google.GoogleMCCReport$SearchEngineUserWorker.call(GoogleMCCReport.java:369)
        at com.thesearchagency.searchengines.google.GoogleMCCReport$SearchEngineUserWorker.call(GoogleMCCReport.java:295)
        at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
        at java.util.concurrent.FutureTask.run(FutureTask.java:138)
        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
        at java.lang.Thread.run(Thread.java:662)

2016-03-29 07:33:55.387 (3) [P1T1]: ...done
2016-03-29 07:33:55.387 (3) [P1T1]: Parsing KeywordPerformance MCC report into staging database...
2016-03-29 07:33:55.388 (3) [P1T1]:   Finding column names...
2016-03-29 07:33:55.392 (3) [P1T1]:   Writing temp infile...
2016-03-29 07:33:55.411 (3) [P1T1]:   Loading data infile into temp table...
2016-03-29 07:33:55.457 (3) [P1T1]:   Inserting into staging database...
2016-03-29 07:33:55.463 (3) [P1T1]: ...done
2016-03-29 07:33:55.463 (3) [P1T1]: Parsing click performance report into staging database...
2016-03-29 07:33:55.463 (3) [P1T1]:   Finding column names...
2016-03-29 07:33:55.465 (3) [P1T1]:   Writing temp infile...
2016-03-29 07:33:55.483 (3) [P1T1]:   Deleted 0 existing records where ((`startTime`="2016-03-28 00:00:00") and (`campaignid` in ("358192473","358192593")))
2016-03-29 07:33:55.483 (3) [P1T1]:   Loading data infile into temp table...
2016-03-29 07:33:55.488 (3) [P1T1]: ...done
2016-03-29 07:33:55.488 (3) [P1T1]: === Completed user #243, 38610cc9-de5e-47c0-bacd-57fea3af1926_1 ===
2016-03-29 07:33:55.489 (3) [main]: ------------Google MCC Report done
2016-03-29 07:33:55.489 (3) [main]: =============== Completed Google MCC Report ================
2016-03-29 07:33:55.490 (3) [main]: Google MCC Report:  4.533s
2016-03-29 07:33:55.490 (3) [main]:     by key:
2016-03-29 07:33:55.490 (3) [main]:         db: 0.098s
2016-03-29 07:33:55.490 (3) [main]:             by thread:
2016-03-29 07:33:55.490 (3) [main]:                 P1T1:       0.095s
2016-03-29 07:33:55.490 (3) [main]:                 main:       0.003s
2016-03-29 07:33:55.490 (3) [main]:         other:      4.435s
[TSAApp@aml-qa3-core1 bidmgr]$ ./googlemcc.sh -T 2016-03-28 -d3 -U 243^C
[TSAApp@aml-qa3-core1 bidmgr]$ ^C






Sedatacheck
______________________







[TSAApp@aml-qa3-core1 bidmgr]$ ./sedatacheck.sh -T 2016-03-28 -d 3 -U 243
2016-03-29 07:38:38.077 (3) [main]: Debug Level set to 3
2016-03-29 07:38:38.079 (3) [main]: Licensing environment detected, loading configuration.
2016-03-29 07:38:38.079 (3) [main]: Loaded property: tsa.google.mcc.clientId=52743837274-afi7bmlos17ebmjcl0vm0hcn7bg6vbpj.apps.googleusercontent.com
2016-03-29 07:38:38.079 (3) [main]: Loaded property: tsa.google.mcc.clientSecret=jI2Y0Xgn4_dXV8mgb6o1hLc0
2016-03-29 07:38:38.080 (3) [main]: Loaded property: tsa.google.mcc.refreshToken=1/JAnPzJJCbj0OfnOZubIzr0i4KYxZAKVnsnArlp40k4w
2016-03-29 07:38:38.080 (3) [main]: Loaded property: tsa.google.mcc.developerToken=ojCnjZaM6RD1h0yt_DOJZg
2016-03-29 07:38:38.080 (3) [main]: Loaded property: tsa.google.mcc.isReseller=true
2016-03-29 07:38:38.080 (3) [main]: Loaded property: tsa.google.mcc.userAgent=AdMaxLocal AdWords Software TSA QA
2016-03-29 07:38:38.080 (3) [main]: Loaded property: tsa.timezone=UTC
2016-03-29 07:38:38.193 (3) [main]: DatabasePool with a limit of 7 created
2016-03-29 07:38:38.497 (3) [main]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver)
2016-03-29 07:38:38.527 (3) [main]: Debug Level set to 3
2016-03-29 07:38:38.527 (3) [main]: =============== Starting Search Engine Data Checker ================
2016-03-29 07:38:38.527 (3) [main]: ---------------- Distribution Dispatcher for Search Engine Data Checker starting
2016-03-29 07:38:38.549 (3) [P1T1]: Starting Distribution 3
2016-03-29 07:38:38.549 (3) [P1T1]: ----------------Search Engine Data Checker - Distribution Worker starting
2016-03-29 07:38:38.577 (3) [P1T1]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver)
2016-03-29 07:38:38.588 (3) [P2T1]: Starting User (243) "38610cc9-de5e-47c0-bacd-57fea3af1926_1"
2016-03-29 07:38:38.625 (3) [P2T1]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver)
2016-03-29 07:38:38.828 (3) [P2T1]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver)
2016-03-29 07:38:38.854 (3) [P2T1]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver)
2016-03-29 07:38:38.883 (3) [P2T1]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver)
2016-03-29 07:38:38.883 (3) [P2T1]: Created shared sesystem connection rw
2016-03-29 07:38:38.900 (3) [P2T1]: [oauth] Creating new OAuthService component
2016-03-29 07:38:39,237 [P2T1] INFO  c.t.s.o.core.OAuthServiceComponent - [oauth] Creating new OAuthServiceComponent
2016-03-29 07:38:39,440 [P2T1] INFO  c.t.s.o.core.OAuthServiceComponent - [oauth] Getting new access token
2016-03-29 07:38:40,606 [P2T1] INFO  c.t.s.o.core.OAuthServiceComponent - [oauth] Return OAuth credential. Access token = ya29.tAKN4Xu3UfRMWEur7aq2zJ3E0Lp16fZifeBsuWTSnNayou-cZwm4H_aWKCN7mqeuikei3jg
2016-03-29 07:38:40.606 (3) [P2T1]: [oauth] Returning access token from OAuth service: ya29.tAKN4Xu3UfRMWEur7aq2zJ3E0Lp16fZifeBsuWTSnNayou-cZwm4H_aWKCN7mqeuikei3jg
2016-03-29 07:38:40,607 [P2T1] INFO  c.t.s.o.core.OAuthServiceComponent - [oauth] Return OAuth credential. Access token = ya29.tAKN4Xu3UfRMWEur7aq2zJ3E0Lp16fZifeBsuWTSnNayou-cZwm4H_aWKCN7mqeuikei3jg
2016-03-29 07:38:40.607 (3) [P2T1]: [oauth] Returning access token from OAuth service: ya29.tAKN4Xu3UfRMWEur7aq2zJ3E0Lp16fZifeBsuWTSnNayou-cZwm4H_aWKCN7mqeuikei3jg
2016-03-29 07:38:40.635 (3) [P2T1]: Downloading check report...
2016-03-29 07:38:41,252 [P2T1] INFO  c.g.a.a.a.lib.utils.report_download - Request made: POST https://adwords.google.com//api/adwords/reportdownload/v201601

2016-03-29 07:38:41,254 [P2T1] INFO  c.g.a.a.a.lib.utils.report_download - accept-encoding: [gzip]
authorization: REDACTED
user-agent: [AdMaxLocal AdWords Software TSA QA (AwApi-Java, Common-Java/2.11.0, Java/1.6.0_27, maven)]
developertoken: REDACTED
clientcustomerid: 7230771065

Parameters:
__fmt: GZIPPED_XML
__rdquery: SELECT Date,CampaignId,CampaignName,Clicks,Impressions,Cost,Conversions FROM CAMPAIGN_PERFORMANCE_REPORT WHERE Impressions > 0 AND CampaignStatus IN ['ENABLED','PAUSED','REMOVED'] DURING 20160328,20160328

2016-03-29 07:38:41,254 [P2T1] INFO  c.g.a.a.a.lib.utils.report_download - Response received with status code 200 and message: OK

2016-03-29 07:38:41.255 (3) [P2T1]: Got OK response from google, trying to output the file /var/local/tsa/sedata/google/tsa-check-report-daily-2016-03-28-U243.xml.gz
2016-03-29 07:38:41.259 (3) [P2T1]: check report download (Mon Mar 28 00:00:00 UTC 2016, "/var/local/tsa/sedata/google/tsa-check-report-daily-2016-03-28-U243.xml.gz") -> success:true
2016-03-29 07:38:41.259 (3) [P2T1]: Parsing daily check report into staging database...
2016-03-29 07:38:41.261 (3) [P2T1]:   Finding column names...
2016-03-29 07:38:41.263 (3) [P2T1]:   Writing temp infile...
2016-03-29 07:38:41.301 (3) [P2T1]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver)
2016-03-29 07:38:41.304 (3) [P2T1]: DatabasePool with a limit of 7 created
2016-03-29 07:38:41.335 (3) [P2T1]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver)
2016-03-29 07:38:41.372 (3) [P2T1]:   Deleted 0 existing records where ((`date`="2016-03-28 00:00:00") and (`campaignid` in ("358192473","358192593")))
2016-03-29 07:38:41.372 (3) [P2T1]:   Inserting into staging database [`staging`.`googleDailyCheck`]...
2016-03-29 07:38:41.388 (1) [P2T1]: Exception [Error on line 1: 2016-03-28      358192593       38610cc9-de5e-47c0-bacd-57fea3af1926_211091_500001_204_GM       1       34      560000  0.0]:java.lang.NumberFormatException: For input string: "0.0"
        at java.lang.NumberFormatException.forInputString(NumberFormatException.java:48)
        at java.lang.Integer.parseInt(Integer.java:458)
        at java.lang.Integer.valueOf(Integer.java:554)
        at com.thesearchagency.db.util.BatchInsertUtil.getTypeValue(BatchInsertUtil.java:409)
        at com.thesearchagency.db.util.BatchInsertUtil.parseFileUsingSplit(BatchInsertUtil.java:327)
        at com.thesearchagency.db.util.BatchInsertUtil.batchInsertFromFile(BatchInsertUtil.java:156)
        at com.thesearchagency.db.util.BatchInsertUtil.batchInsertFromFile(BatchInsertUtil.java:83)
        at com.thesearchagency.db.util.BatchInsertUtil.batchInsertFromFile(BatchInsertUtil.java:60)
        at com.thesearchagency.searchengines.google.GoogleAPISearchEngine.parseDataCheckReport(GoogleAPISearchEngine.java:1449)
        at com.thesearchagency.searchengines.google.GoogleAPISearchEngine.runDataCheck(GoogleAPISearchEngine.java:1311)
        at com.thesearchagency.searchengines.google.GoogleAPISearchEngine.runDataCheck(GoogleAPISearchEngine.java:1270)
        at com.thesearchagency.searchengines.SearchEngineDataChecker$DistributionWorker$SearchEngineUserWorker.call(SearchEngineDataChecker.java:412)
        at com.thesearchagency.searchengines.SearchEngineDataChecker$DistributionWorker$SearchEngineUserWorker.call(SearchEngineDataChecker.java:373)
        at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
        at java.util.concurrent.FutureTask.run(FutureTask.java:138)
        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
        at java.lang.Thread.run(Thread.java:662)

2016-03-29 07:38:41.388 (1) [P2T1]: Exception [error inserting SQL rows into `staging`.`googleDailyCheck` from file /tmp/go2016-03-28698104330717272208.tmp]:java.lang.NumberFormatException: For input string: "0.0"
        at java.lang.NumberFormatException.forInputString(NumberFormatException.java:48)
        at java.lang.Integer.parseInt(Integer.java:458)
        at java.lang.Integer.valueOf(Integer.java:554)
        at com.thesearchagency.db.util.BatchInsertUtil.getTypeValue(BatchInsertUtil.java:409)
        at com.thesearchagency.db.util.BatchInsertUtil.parseFileUsingSplit(BatchInsertUtil.java:327)
        at com.thesearchagency.db.util.BatchInsertUtil.batchInsertFromFile(BatchInsertUtil.java:156)
        at com.thesearchagency.db.util.BatchInsertUtil.batchInsertFromFile(BatchInsertUtil.java:83)
        at com.thesearchagency.db.util.BatchInsertUtil.batchInsertFromFile(BatchInsertUtil.java:60)
        at com.thesearchagency.searchengines.google.GoogleAPISearchEngine.parseDataCheckReport(GoogleAPISearchEngine.java:1449)
        at com.thesearchagency.searchengines.google.GoogleAPISearchEngine.runDataCheck(GoogleAPISearchEngine.java:1311)
        at com.thesearchagency.searchengines.google.GoogleAPISearchEngine.runDataCheck(GoogleAPISearchEngine.java:1270)
        at com.thesearchagency.searchengines.SearchEngineDataChecker$DistributionWorker$SearchEngineUserWorker.call(SearchEngineDataChecker.java:412)
        at com.thesearchagency.searchengines.SearchEngineDataChecker$DistributionWorker$SearchEngineUserWorker.call(SearchEngineDataChecker.java:373)
        at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
        at java.util.concurrent.FutureTask.run(FutureTask.java:138)
        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
        at java.lang.Thread.run(Thread.java:662)

2016-03-29 07:38:41.389 (3) [P2T1]: ...done
2016-03-29 07:38:41.390 (3) [P2T1]: Finished User (243) "38610cc9-de5e-47c0-bacd-57fea3af1926_1"
2016-03-29 07:38:41.390 (3) [P1T1]: ------------Search Engine Data Checker - Distribution Worker done
2016-03-29 07:38:41.390 (3) [main]: ------------ Distribution Dispatcher for Search Engine Data Checker done
2016-03-29 07:38:41.390 (3) [main]: =============== Completed Search Engine Data Checker ================
2016-03-29 07:38:41.391 (3) [main]: Search Engine Data Checker: 2.863s
2016-03-29 07:38:41.391 (3) [main]:     by key:
2016-03-29 07:38:41.392 (3) [main]:         db: 0.042s
2016-03-29 07:38:41.392 (3) [main]:             by thread:
2016-03-29 07:38:41.392 (3) [main]:                 P2T1:       0.039s
2016-03-29 07:38:41.392 (3) [main]:                 P1T1:       0.002s
2016-03-29 07:38:41.392 (3) [main]:                 main:       0.001s
2016-03-29 07:38:41.392 (3) [main]:         other:      2.821s