Details
-
Type:
Bug
-
Status: Closed
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: None
-
Fix Version/s: None
-
Component/s: Third Party Data
-
Labels:None
-
Environment:
Bid Manager Build: tsa-build-bidmgr-2010-10-25-p53-r27768
Service build : svc-channelv2.0-p480-r27768.ear
Admax Ui :AdMax-Extended-Unified-Datafeed-p10-r27798.tar
Description
load-publisher.sh exiting by showing mesage "unable to process data file" but data is inserted to the database in the following scenario.
1)Upload 2 different Kontera publisher feeds and pull the files to staging-xml1. (Publisher feeds and config.XML are attached)
2)cd /usr/local/tsa/bifmgr
Run the ./load-publisher.sh
./load-publisher.sh -d3 -F -XN Kontera.xml -XL /var/local/tsa/datafeedConfig/ >&1 | tee /tmp/Kontera_camp_map_1.log
gets the exception....
2010-10-28 03:22:33.240 (1) [main]: Exception [parsing double "Clicks", cleaned to "Clicks"]:java.lang.NumberFormatException: For input string: "Clicks"
at sun.misc.FloatingDecimal.readJavaFormatString(FloatingDecimal.java:1224)
at java.lang.Double.valueOf(Double.java:447)
at java.lang.Double.<init>(Double.java:539)
at com.carldunham.jst.util.MathUtil.parseDouble(MathUtil.java:643)
at com.thesearchagency.datafeeds.generic.PublisherConversionColumnGenerator.getPASImpressions(PublisherConversionColumnGenerator.java:161)
at com.thesearchagency.datafeeds.generic.behaviors.BehaviorFacade.getPublisherConversionInformation(BehaviorFacade.java:177)
at com.thesearchagency.datafeeds.generic.PublisherGenericDataFeed.getConversion(PublisherGenericDataFeed.java:368)
at com.thesearchagency.datafeeds.generic.PublisherGenericDataFeed.processArray(PublisherGenericDataFeed.java:225)
at com.thesearchagency.datafeeds.generic.PublisherGenericDataFeed.process(PublisherGenericDataFeed.java:552)
at com.thesearchagency.datafeeds.BaseDataFeed.processDataFile(BaseDataFeed.java:816)
at com.thesearchagency.datafeeds.generic.PublisherGenericDataFeed.processDataFile(PublisherGenericDataFeed.java:427)
at com.thesearchagency.datafeeds.BaseDataFeed.run(BaseDataFeed.java:378)
at com.thesearchagency.datafeeds.generic.PublisherGenericDataFeed.main(PublisherGenericDataFeed.java:78)
and it exits.
*Detailed Log file has attached
3)Check the table `sources` of st-tracker database;
mysql> SELECT * FROM sources WHERE altKey IN ('KT0044108484','KT0044100494');
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| id | altKey | accountID | siteID | searchEngineAccountID | keywordID | distributionID | searchEngineIdentifier | searchEngineGroupIdentifier | searchEngineMatchType | searchEngineGroupID | isBiddable | campaignID | description | type | keyword | sourceURL | cost | maxCost | waypointID | landingURL | passParams | trackPerformance | searchEngineStatus | searchEngineStatusText | lastChecked |
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| 561291821 | kt0044100494 | 17 | 0 | 0 | 0 | 188 | NULL | unknown | 0 | false | 641 | affordable webhosting | 1 | affordable webhosting | NULL | 0 | NULL | true | ok | 0000-00-00 00:00:00 |
| 561291811 | kt0044108484 | 17 | 0 | 0 | 0 | 188 | NULL | unknown | 0 | false | 641 | affordable webhosting test | 1 | affordable webhosting test | NULL | 0 | NULL | true | ok | 0000-00-00 00:00:00 |
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
2 rows in set (0.00 sec)
Even though script exits data has inserted for other publisher feed:17_188_20101004.csv
