2010-10-26 03:31:17.870 (3) [main]: Debug Level set to 3 2010-10-26 03:31:17.875 (3) [main]: No licensing config file found, assuming TSA production environment 2010-10-26 03:31:19.181 (3) [main]: Configured properties according to file :: /var/local/tsa/datafeedConfig/Facebook_VikingRiver.xml 2010-10-26 03:31:20.656 (3) [main]: DatabasePool with a limit of 80 created 2010-10-26 03:31:20.907 (3) [main]: DatabasePool with a limit of 80 created 2010-10-26 03:31:21.061 (3) [main]: Distribution status is [ACTIVE] for accountID[299], distributionID[177] 2010-10-26 03:31:21.107 (3) [main]: =============== Starting Publisher Generic Data Feed Facebook ================ 2010-10-26 03:31:21.139 (3) [main]: Found 1 Facebook file(s)... 2010-10-26 03:31:21.140 (3) [main]: Files... [/var/local/tsa/publishers/299/177/299_177_20101022.csv] 2010-10-26 03:31:21.140 (3) [main]: Loading file /var/local/tsa/publishers/299/177/299_177_20101022.csv 2010-10-26 03:31:21.143 (3) [main]: Attempt[0] -- file[/var/local/tsa/publishers/299/177/299_177_20101022.csv] oldFileSize[0] currFileSize[895] 2010-10-26 03:31:21.143 (3) [main]: file upload/download Complete? false ... sleeping 60000 ms before checking again 2010-10-26 03:32:21.151 (3) [main]: Attempt[1] -- file[/var/local/tsa/publishers/299/177/299_177_20101022.csv] oldFileSize[895] currFileSize[895] 2010-10-26 03:32:21.151 (3) [main]: file upload/download Complete? true 2010-10-26 03:32:21.348 (2) [main]: Warning(s) detected in statement [replace into `dataAvailability` (`override`,`dataSourceID`,`status`,`date`,`updated`) values ("false","223041","in progress","2010-10-24 03:00:00","2010-10-26 03:32:21")] executed by user [spike] 2010-10-26 03:32:21.350 (2) [main]: SQL Note: Data truncated for column 'date' at row 1 (code:1265) 2010-10-26 03:32:21.356 (2) [main]: Warning(s) detected in statement [insert into `dataAvailabilityHistory` (`override`,`dataSourceID`,`status`,`date`,`updated`) values ("false","223041","in progress","2010-10-24 03:00:00","2010-10-26 03:32:21")] executed by user [spike] 2010-10-26 03:32:21.358 (2) [main]: SQL Note: Data truncated for column 'date' at row 1 (code:1265) 2010-10-26 03:32:21.359 (3) [main]: loading "/var/local/tsa/publishers/299/177/299_177_20101022.csv"... 2010-10-26 03:32:21.359 (3) [main]: Account [299]: deleting old publisher data (2010-10-22 00:00:00) 2010-10-26 03:32:22.803 (2) [main]: Warning(s) detected in statement [replace into `dataAvailability` (`override`,`dataSourceID`,`status`,`date`,`updated`) values ("false","223041","success","2010-10-24 03:00:00","2010-10-26 03:32:22")] executed by user [spike] 2010-10-26 03:32:22.806 (2) [main]: SQL Note: Data truncated for column 'date' at row 1 (code:1265) 2010-10-26 03:32:22.814 (2) [main]: Warning(s) detected in statement [insert into `dataAvailabilityHistory` (`override`,`dataSourceID`,`status`,`date`,`updated`) values ("false","223041","success","2010-10-24 03:00:00","2010-10-26 03:32:22")] executed by user [spike] 2010-10-26 03:32:22.816 (2) [main]: SQL Note: Data truncated for column 'date' at row 1 (code:1265) 2010-10-26 03:32:22.817 (3) [main]: ...calling warehouse summarization with args: --debug 3 --accountid 299 --distribution 177 --date 2010-10-22 --publisher 2010-10-26 03:32:22.827 (3) [main]: Debug Level set to 3 2010-10-26 03:32:22.827 (2) [main]: No granularity given, all 2010-10-26 03:32:22.828 (3) [main]: =============== Starting Warehouse Summarizer ================ 2010-10-26 03:32:22.829 (3) [main]: ----------------Warehouse Summarizer starting 2010-10-26 03:32:24.109 (3) [P1T1]: DatabasePool with a limit of 80 created 2010-10-26 03:32:24.133 (3) [P1T1]: DatabasePool with a limit of 80 created 2010-10-26 03:32:24.198 (3) [P1T1]: DatabasePool with a limit of 80 created 2010-10-26 03:32:24.382 (3) [P1T1]: Skipping sync of dimensions for acct #299 (last sync was at 2010-10-26 03:14:58.0) 2010-10-26 03:32:24.385 (3) [P1T1]: Starting daily for Account #299 VikingRiverCruises for Fri Oct 22 03:00:00 EDT 2010 2010-10-26 03:32:24.385 (3) [P1T1]: Updating perf rows that don't have a bidTargetID, but should... for Dist(s) (177) 2010-10-26 03:32:24.411 (3) [P1T1]: no publisher data for account #299 in dist (177) 2010-10-26 03:32:24.411 (3) [P1T1]: Finished daily for Account #299 VikingRiverCruises on Fri Oct 22 03:00:00 EDT 2010 2010-10-26 03:32:24.448 (2) [P1T1]: Warning(s) detected in statement [replace into `dataAvailability` (`override`,`dataSourceID`,`status`,`date`,`updated`) values ("false","16069","in progress","2010-10-22 03:00:00","2010-10-26 03:32:24")] executed by user [perfsum] 2010-10-26 03:32:24.449 (2) [P1T1]: SQL Note: Data truncated for column 'date' at row 1 (code:1265) 2010-10-26 03:32:24.458 (2) [P1T1]: Warning(s) detected in statement [insert into `dataAvailabilityHistory` (`override`,`dataSourceID`,`status`,`date`,`updated`) values ("false","16069","in progress","2010-10-22 03:00:00","2010-10-26 03:32:24")] executed by user [perfsum] 2010-10-26 03:32:24.459 (2) [P1T1]: SQL Note: Data truncated for column 'date' at row 1 (code:1265) 2010-10-26 03:32:24.459 (3) [P1T1]: Starting Account #299 VikingRiverCruises aggregates for Fri Oct 22 03:00:00 EDT 2010 to