2010-10-27 02:52:38.556 (3) [main]: Debug Level set to 3
2010-10-27 02:52:38.560 (3) [main]: No licensing config file found, assuming TSA production environment
2010-10-27 02:52:39.842 (3) [main]: Configured properties according to file :: /var/local/tsa/datafeedConfig/Facebook.xml
2010-10-27 02:52:41.268 (3) [main]: DatabasePool with a limit of 80 created
2010-10-27 02:52:41.614 (3) [main]: DatabasePool with a limit of 80 created
2010-10-27 02:52:41.652 (3) [main]: Distribution status is [ACTIVE] for accountID[17], distributionID[177]
2010-10-27 02:52:41.683 (3) [main]: =============== Starting Publisher Generic Data Feed Facebook ================
2010-10-27 02:52:41.720 (3) [main]: Found 1 Facebook file(s)...
2010-10-27 02:52:41.720 (3) [main]: Files... [/var/local/tsa/publishers/17/177/17_177_20101024.csv]
2010-10-27 02:52:41.720 (3) [main]: Loading file /var/local/tsa/publishers/17/177/17_177_20101024.csv
2010-10-27 02:52:41.724 (3) [main]: Attempt[0] -- file[/var/local/tsa/publishers/17/177/17_177_20101024.csv] oldFileSize[0] currFileSize[541]
2010-10-27 02:52:41.724 (3) [main]: file upload/download Complete? false
... sleeping 60000 ms before checking again
2010-10-27 02:53:41.728 (3) [main]: Attempt[1] -- file[/var/local/tsa/publishers/17/177/17_177_20101024.csv] oldFileSize[541] currFileSize[541]
2010-10-27 02:53:41.728 (3) [main]: file upload/download Complete? true
2010-10-27 02:53:41.904 (2) [main]: Warning(s) detected in statement [replace into `dataAvailability` (`override`,`dataSourceID`,`status`,`date`,`updated`) values ("false","223001","in progress","2010-10-25 03:00:00","2010-10-27 02:53:41")] executed by user [spike]
2010-10-27 02:53:41.906 (2) [main]: SQL Note: Data truncated for column 'date' at row 1 (code:1265)
2010-10-27 02:53:41.914 (2) [main]: Warning(s) detected in statement [insert into `dataAvailabilityHistory` (`override`,`dataSourceID`,`status`,`date`,`updated`) values ("false","223001","in progress","2010-10-25 03:00:00","2010-10-27 02:53:41")] executed by user [spike]
2010-10-27 02:53:41.916 (2) [main]: SQL Note: Data truncated for column 'date' at row 1 (code:1265)
2010-10-27 02:53:41.917 (3) [main]: loading "/var/local/tsa/publishers/17/177/17_177_20101024.csv"...
2010-10-27 02:53:41.918 (3) [main]: Account [17]: deleting old publisher data (2010-10-24 00:00:00)
2010-10-27 02:53:43.891 (2) [main]: Warning(s) detected in statement [replace into `dataAvailability` (`override`,`dataSourceID`,`status`,`date`,`updated`) values ("false","223001","success","2010-10-25 03:00:00","2010-10-27 02:53:43")] executed by user [spike]
2010-10-27 02:53:43.893 (2) [main]: SQL Note: Data truncated for column 'date' at row 1 (code:1265)
2010-10-27 02:53:43.896 (2) [main]: Warning(s) detected in statement [insert into `dataAvailabilityHistory` (`override`,`dataSourceID`,`status`,`date`,`updated`) values ("false","223001","success","2010-10-25 03:00:00","2010-10-27 02:53:43")] executed by user [spike]
2010-10-27 02:53:43.898 (2) [main]: SQL Note: Data truncated for column 'date' at row 1 (code:1265)
2010-10-27 02:53:43.899 (3) [main]: ...calling warehouse summarization with args:  --debug 3 --accountid 17 --distribution 177 --date 2010-10-24 --publisher
2010-10-27 02:53:43.909 (3) [main]: Debug Level set to 3
2010-10-27 02:53:43.909 (2) [main]: No granularity given, all
2010-10-27 02:53:43.911 (3) [main]: =============== Starting Warehouse Summarizer ================
2010-10-27 02:53:43.911 (3) [main]: ----------------Warehouse Summarizer starting
2010-10-27 02:53:44.608 (3) [P1T1]: DatabasePool with a limit of 80 created
2010-10-27 02:53:44.665 (3) [P1T1]: DatabasePool with a limit of 80 created
2010-10-27 02:53:44.769 (3) [P1T1]: DatabasePool with a limit of 80 created
2010-10-27 02:53:44.847 (3) [P1T1]: Skipping sync of dimensions for acct #17 (last sync was at 2010-10-27 02:16:22.0)
2010-10-27 02:53:44.850 (3) [P1T1]: Starting daily for Account #17 WWMW - Cellular Safety Commission for Sun Oct 24 03:00:00 EDT 2010
2010-10-27 02:53:44.851 (3) [P1T1]: Updating perf rows that don't have a bidTargetID, but should... for Dist(s) (177)
2010-10-27 02:53:44.876 (3) [P1T1]: no publisher data for account #17 in dist (177)
2010-10-27 02:53:44.876 (3) [P1T1]: Finished daily for Account #17 WWMW - Cellular Safety Commission on Sun Oct 24 03:00:00 EDT 2010
2010-10-27 02:53:44.888 (2) [P1T1]: Warning(s) detected in statement [replace into `dataAvailability` (`override`,`dataSourceID`,`status`,`date`,`updated`) values ("false","8602","in progress","2010-10-24 03:00:00","2010-10-27 02:53:44")] executed by user [perfsum]
2010-10-27 02:53:44.890 (2) [P1T1]: SQL Note: Data truncated for column 'date' at row 1 (code:1265)
2010-10-27 02:53:45.083 (2) [P1T1]: Warning(s) detected in statement [insert into `dataAvailabilityHistory` (`override`,`dataSourceID`,`status`,`date`,`updated`) values ("false","8602","in progress","2010-10-24 03:00:00","2010-10-27 02:53:44")] executed by user [perfsum]
2010-10-27 02:53:45.084 (2) [P1T1]: SQL Note: Data truncated for column 'date' at row 1 (code:1265)
2010-10-27 02:53:45.085 (3) [P1T1]: Starting Account #17 WWMW - Cellular Safety Commission aggregates for Sun Oct 24 03:00:00 EDT 2010 to <Mon Oct 25 03:00:00 EDT 2010
2010-10-27 02:53:45.273 (3) [P1T1]: ... 13 Weekly Source Perf Records Inserted
2010-10-27 02:53:45.289 (3) [P1T1]: ... 18 Weekly Source Conversion Records Inserted
2010-10-27 02:53:45.303 (3) [P1T1]: ... 13 Weekly Source Attribute Records Inserted
2010-10-27 02:53:45.684 (3) [P1T1]: ... 35 Monthly Source Perf Records Inserted
2010-10-27 02:53:45.694 (3) [P1T1]: ... 21 Monthly Source Conversion Records Inserted
2010-10-27 02:53:45.731 (3) [P1T1]: ... 34 Monthly Source Attribute Records Inserted
2010-10-27 02:53:45.823 (3) [P1T1]: ... 0 Daily Group Perf Records Inserted
2010-10-27 02:53:45.832 (3) [P1T1]: ... 0 Daily Group Conversion Records Inserted
2010-10-27 02:53:45.839 (3) [P1T1]: ... 0 Daily Group Attribute Records Inserted
2010-10-27 02:53:45.897 (3) [P1T1]: ... 9 Weekly Group Perf Records Inserted
2010-10-27 02:53:45.907 (3) [P1T1]: ... 10 Weekly Group Conversion Records Inserted
2010-10-27 02:53:45.916 (3) [P1T1]: ... 9 Weekly Group Attribute Records Inserted
2010-10-27 02:53:46.128 (3) [P1T1]: ... 17 Monthly Group Perf Records Inserted
2010-10-27 02:53:46.169 (3) [P1T1]: ... 13 Monthly Group Conversion Records Inserted
2010-10-27 02:53:46.179 (3) [P1T1]: ... 16 Monthly Group Attribute Records Inserted
2010-10-27 02:53:46.186 (3) [P1T1]: Finished Account #17 WWMW - Cellular Safety Commission aggregates for Sun Oct 24 03:00:00 EDT 2010 to <Mon Oct 25 03:00:00 EDT 2010
2010-10-27 02:53:46.194 (2) [P1T1]: Warning(s) detected in statement [replace into `dataAvailability` (`override`,`dataSourceID`,`status`,`date`,`updated`) values ("false","8602","success","2010-10-24 03:00:00","2010-10-27 02:53:46")] executed by user [perfsum]
2010-10-27 02:53:46.195 (2) [P1T1]: SQL Note: Data truncated for column 'date' at row 1 (code:1265)
2010-10-27 02:53:46.199 (2) [P1T1]: Warning(s) detected in statement [insert into `dataAvailabilityHistory` (`override`,`dataSourceID`,`status`,`date`,`updated`) values ("false","8602","success","2010-10-24 03:00:00","2010-10-27 02:53:46")] executed by user [perfsum]
2010-10-27 02:53:46.201 (2) [P1T1]: SQL Note: Data truncated for column 'date' at row 1 (code:1265)
2010-10-27 02:53:46.203 (3) [main]: ------------Warehouse Summarizer done
2010-10-27 02:53:46.203 (3) [main]: =============== Completed Warehouse Summarizer ================
2010-10-27 02:53:46.204 (3) [main]:  -- Renamed file [17_177_20101024.csv] to [17_177_20101024.csv.done] ? true
2010-10-27 02:53:46.204 (3) [main]: =============== Completed Publisher Generic Data Feed Facebook, 4 products processed and 2 lines processed ================