2010-10-28 03:20:28.735 (3) [main]: Debug Level set to 3 2010-10-28 03:20:28.740 (3) [main]: No licensing config file found, assuming TSA production environment 2010-10-28 03:20:30.293 (3) [main]: Configured properties according to file :: /var/local/tsa/datafeedConfig/Kontera.xml 2010-10-28 03:20:31.632 (3) [main]: DatabasePool with a limit of 80 created 2010-10-28 03:20:31.848 (3) [main]: DatabasePool with a limit of 80 created 2010-10-28 03:20:31.895 (3) [main]: Distribution status is [ACTIVE] for accountID[17], distributionID[188] 2010-10-28 03:20:31.956 (3) [main]: =============== Starting Publisher Generic Data Feed Kontera ================ 2010-10-28 03:20:32.070 (3) [main]: Found 2 Kontera file(s)... 2010-10-28 03:20:32.070 (3) [main]: Files... [/var/local/tsa/publishers/17/188/17_188_20101004.csv, /var/local/tsa/publishers/17/188/17_188_20101010.csv] 2010-10-28 03:20:32.070 (3) [main]: Loading file /var/local/tsa/publishers/17/188/17_188_20101004.csv 2010-10-28 03:20:32.074 (3) [main]: Attempt[0] -- file[/var/local/tsa/publishers/17/188/17_188_20101004.csv] oldFileSize[0] currFileSize[248] 2010-10-28 03:20:32.074 (3) [main]: file upload/download Complete? false ... sleeping 60000 ms before checking again 2010-10-28 03:21:32.085 (3) [main]: Attempt[1] -- file[/var/local/tsa/publishers/17/188/17_188_20101004.csv] oldFileSize[248] currFileSize[248] 2010-10-28 03:21:32.085 (3) [main]: file upload/download Complete? true 2010-10-28 03:21:32.368 (2) [main]: Warning(s) detected in statement [replace into `dataAvailability` (`override`,`dataSourceID`,`status`,`date`,`updated`) values ("false","223021","in progress","2010-10-26 03:00:00","2010-10-28 03:21:32")] executed by user [spike] 2010-10-28 03:21:32.370 (2) [main]: SQL Note: Data truncated for column 'date' at row 1 (code:1265) 2010-10-28 03:21:32.377 (2) [main]: Warning(s) detected in statement [insert into `dataAvailabilityHistory` (`override`,`dataSourceID`,`status`,`date`,`updated`) values ("false","223021","in progress","2010-10-26 03:00:00","2010-10-28 03:21:32")] executed by user [spike] 2010-10-28 03:21:32.379 (2) [main]: SQL Note: Data truncated for column 'date' at row 1 (code:1265) 2010-10-28 03:21:32.379 (3) [main]: loading "/var/local/tsa/publishers/17/188/17_188_20101004.csv"... 2010-10-28 03:21:32.380 (3) [main]: Account [17]: deleting old publisher data (2010-10-04 00:00:00) 2010-10-28 03:21:33.207 (2) [main]: Warning(s) detected in statement [replace into `dataAvailability` (`override`,`dataSourceID`,`status`,`date`,`updated`) values ("false","223021","success","2010-10-26 03:00:00","2010-10-28 03:21:33")] executed by user [spike] 2010-10-28 03:21:33.209 (2) [main]: SQL Note: Data truncated for column 'date' at row 1 (code:1265) 2010-10-28 03:21:33.214 (2) [main]: Warning(s) detected in statement [insert into `dataAvailabilityHistory` (`override`,`dataSourceID`,`status`,`date`,`updated`) values ("false","223021","success","2010-10-26 03:00:00","2010-10-28 03:21:33")] executed by user [spike] 2010-10-28 03:21:33.227 (2) [main]: SQL Note: Data truncated for column 'date' at row 1 (code:1265) 2010-10-28 03:21:33.228 (3) [main]: Loading file /var/local/tsa/publishers/17/188/17_188_20101010.csv 2010-10-28 03:21:33.230 (3) [main]: Attempt[0] -- file[/var/local/tsa/publishers/17/188/17_188_20101010.csv] oldFileSize[0] currFileSize[406] 2010-10-28 03:21:33.230 (3) [main]: file upload/download Complete? false ... sleeping 60000 ms before checking again 2010-10-28 03:22:33.236 (3) [main]: Attempt[1] -- file[/var/local/tsa/publishers/17/188/17_188_20101010.csv] oldFileSize[406] currFileSize[406] 2010-10-28 03:22:33.236 (3) [main]: file upload/download Complete? true 2010-10-28 03:22:33.236 (3) [main]: loading "/var/local/tsa/publishers/17/188/17_188_20101010.csv"... 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.(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) 2010-10-28 03:22:33.241 (1) [main]: Exception [Catch all ]:java.lang.NullPointerException 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) 2010-10-28 03:22:33.254 (2) [main]: Warning(s) detected in statement [replace into `dataAvailability` (`statusText`,`override`,`dataSourceID`,`status`,`date`,`updated`) values ("unable to process data file","false","223021","failure","2010-10-26 03:00:00","2010-10-28 03:22:33")] executed by user [spike] 2010-10-28 03:22:33.256 (2) [main]: SQL Note: Data truncated for column 'date' at row 1 (code:1265) 2010-10-28 03:22:33.261 (2) [main]: Warning(s) detected in statement [insert into `dataAvailabilityHistory` (`statusText`,`override`,`dataSourceID`,`status`,`date`,`updated`) values ("unable to process data file","false","223021","failure","2010-10-26 03:00:00","2010-10-28 03:22:33")] executed by user [spike] 2010-10-28 03:22:33.262 (2) [main]: SQL Note: Data truncated for column 'date' at row 1 (code:1265) 2010-10-28 03:22:33.263 (2) [main]: exiting: unable to process data file