Details
-
Type: Bug
-
Status: Closed
-
Priority: Minor
-
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
http://jira.ri.thesearchagency.com/browse/DF-33
Getting the "failed to parse time (/20101026) Unparseable date: "/20101026"" errors without trailing slash.
refdate="2010-10-26" && /usr/local/tsa/bidmgr/load-publisher.sh -L /var/local/tsa/publishers/17/177 -d 3 --date $refdate -XN Facebook.xml -XL /var/local/tsa/datafeedConfig/
refdate="2010-10-26" && /usr/local/tsa/bidmgr/load-publisher.sh -L /var/local/tsa/publishers/17/177 -d 3 --date $refdate -XN Facebook.xml -XL /var/local/tsa/datafeedConfig/
2010-10-27 09:29:43.023 (3) [main]: Debug Level set to 3
2010-10-27 09:29:44.362 (3) [main]: Configured properties according to file :: /var/local/tsa/datafeedConfig/Facebook.xml
2010-10-27 09:29:46.101 (3) [main]: DatabasePool with a limit of 80 created
2010-10-27 09:29:46.205 (3) [main]: DatabasePool with a limit of 80 created
2010-10-27 09:29:46.249 (3) [main]: Distribution status is [ACTIVE] for accountID[17], distributionID[177]
2010-10-27 09:29:46.264 (3) [main]: =============== Starting Publisher Generic Data Feed Facebook ================
2010-10-27 09:29:46.482 (3) [main]: Found 1 Facebook file(s)...
2010-10-27 09:29:46.483 (3) [main]: Files... [/var/local/tsa/publishers/17/177/17_177_20101026.csv]
2010-10-27 09:29:46.483 (3) [main]: Loading file /var/local/tsa/publishers/17/177/17_177_20101026.csv
2010-10-27 09:29:46.486 (3) [main]: Attempt[0] – file[/var/local/tsa/publishers/17/177/17_177_20101026.csv] oldFileSize[0] currFileSize[547]
2010-10-27 09:29:46.486 (3) [main]: file upload/download Complete? false
... sleeping 60000 ms before checking again
2010-10-27 09:30:46.492 (3) [main]: Attempt[1] – file[/var/local/tsa/publishers/17/177/17_177_20101026.csv] oldFileSize[547] currFileSize[547]
2010-10-27 09:30:46.493 (3) [main]: file upload/download Complete? true
2010-10-27 09:30:46.760 (2) [main]: Warning(s) detected in statement [replace into `dataAvailability` (`override`,`dataSourceID`,`status`,`date`,`updated`) values ("false","223001","in progress","2010-10-26 03:00:00","2010-10-27 09:30:46")] executed by user [spike]
2010-10-27 09:30:46.762 (2) [main]: SQL Note: Data truncated for column 'date' at row 1 (code:1265)
2010-10-27 09:30:46.769 (2) [main]: Warning(s) detected in statement [insert into `dataAvailabilityHistory` (`override`,`dataSourceID`,`status`,`date`,`updated`) values ("false","223001","in progress","2010-10-26 03:00:00","2010-10-27 09:30:46")] executed by user [spike]
2010-10-27 09:30:46.770 (2) [main]: SQL Note: Data truncated for column 'date' at row 1 (code:1265)
2010-10-27 09:30:46.771 (3) [main]: loading "/var/local/tsa/publishers/17/177/17_177_20101026.csv"...
2010-10-27 09:30:46.771 (3) [main]: Account [17]: deleting old publisher data (2010-10-26 00:00:00)
java.text.ParseException: Unparseable date: "/20101026"
at java.text.DateFormat.parse(DateFormat.java:335)
at com.thesearchagency.datafeeds.BaseDataFeed.formatSQLTime(BaseDataFeed.java:1630)
at com.thesearchagency.datafeeds.BaseDataFeed.formatSQLTime(BaseDataFeed.java:1611)
at com.thesearchagency.datafeeds.generic.PublisherGenericDataFeed.getTimeDayFormat(PublisherGenericDataFeed.java:478)
at com.thesearchagency.datafeeds.generic.PublisherGenericDataFeed.processArray(PublisherGenericDataFeed.java:255)
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)
java.text.ParseException: Unparseable date: "/20101026"