Uploaded image for project: 'AdMax'
  1. AdMax
  2. ADMAX-2440

Extended Unified Datafeed: date parsing depends on location parameter passed in (See DF #33)

    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"

        Attachments

          Activity

            People

            • Assignee:
              mtolety Murty Tolety (Inactive)
              Reporter:
              atul.sanagar Atul Sanagar (Inactive)
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: