Details
-
Type:
Bug
-
Status: Closed
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: Gingersnap
-
Fix Version/s: Gingersnap
-
Component/s: Other / Misc.
-
Labels:None
-
Environment:
bidmgr-distribution-2.8.6-SNAPSHOT-dev-t20160323175922-bin.tar.gz
smb-ear-2.8.6-SNAPSHOT-b472-t20160323-181259-CI.ear
aml-sapi-2.8.6-gingersnap-20160323.180708-11.war
QA3
Description
1. Create a merchant and deploy an order .
2 . Wait till the deployed account have some performance data.
3. Run googlemcc and sedatacheck scripts for the account .(./googlemcc.sh -T 2016-03-28 -d3 -U 243)
Actual Behavior
Exceptions are observed (Kindly find the attached log)
Snippet of log:
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)
.
.
.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)
Expected Behavior
The scripts should run successfully and the performance data should be inserted to respected tables in database .
