2010-04-08 04:27:07.656 (3) [main]: Debug Level set to 3 log4j:WARN No appenders could be found for logger (org.apache.axis.i18n.ProjectResourceBundle). log4j:WARN Please initialize the log4j system properly. 2010-04-08 04:27:17.513 (3) [main]: getAbsolutePath() returned /tmp/abtl46558.csv 2010-04-08 04:27:17.521 (3) [main]: Connected to URL "http://tvvm-staging-svc2:8080//reports/1/report_177404.csv" 2010-04-08 04:27:17.768 (3) [main]: getAbsolutePath() returned /tmp/abtl46558.csv 2010-04-08 04:27:18.266 (3) [main]: DatabasePool with a limit of 80 created 2010-04-08 04:27:18.314 (3) [main]: getAbsolutePath() returned /tmp/abtl46558.csv 2010-04-08 04:27:18.404 (3) [main]: Writing file to /var/local/tsa/datachecker/2010-04-08-tsa-DiscrepancyReport-D147.csv 2010-04-08 04:27:18.419 (3) [main]: ... done 2010-04-08 04:27:18.419 (3) [main]: Report generated successfully at following location /var/local/tsa/datachecker/2010-04-08-tsa-DiscrepancyReport-D147.csv 2010-04-08 04:27:18.455 (3) [main]: DatabasePool with a limit of 80 created 2010-04-08 04:27:18.545 (3) [main]: =============== Starting Data Checker Discrepancy Resolver ================ 2010-04-08 04:27:18.546 (3) [main]: ----------------Data Checker Discrepancy Resolver starting 2010-04-08 04:27:18.631 (3) [P1T1]: Running Data Checker Discrepancies Resolver for Account ID::289 2010-04-08 04:27:18.631 (3) [P1T1]: DatabasePool with a limit of 80 created 2010-04-08 04:27:18.664 (3) [P1T1]: Getting distinct Discrepancies dates 2010-04-08 04:27:18.664 (3) [P1T1]: DatabasePool with a limit of 80 created 2010-04-08 04:27:18.743 (3) [P1T1]: Rerun Staging for Resolving Discrepancies for date:2010-04-06 2010-04-08 04:27:18.751 (3) [P1T1]: Debug Level set to 3 2010-04-08 04:27:18.751 (3) [P1T1]: =============== Starting Stage MSN ================ 2010-04-08 04:27:18.752 (3) [P1T1]: ----------------Stage MSN starting 2010-04-08 04:27:18.838 (3) [P2T1]: === Starting user #689, Legalzoom === 2010-04-08 04:27:19.082 (3) [P2T1]: Created shared sesystem connection ro 2010-04-08 04:27:19.759 (3) [P2T1]: Getting report "/var/local/tsa/sedata/msn/tsa-msn-report-2010-04-06-U689.csv.zip" 2010-04-08 04:27:19.760 (3) [P2T1]: Overrwriting local copy of "/var/local/tsa/sedata/msn/tsa-msn-report-2010-04-06-U689.csv.zip" 2010-04-08 04:27:19.771 (3) [P2T1]: Scheduling Report "/var/local/tsa/sedata/msn/tsa-msn-report-2010-04-06-U689.csv.zip" 2010-04-08 04:27:23.314 (3) [P2T1]: Created shared sesystem connection rw 2010-04-08 04:27:33.073 (3) [P2T1]: Report Ready, Success 2010-04-08 04:27:33.073 (3) [P2T1]: Downloading /var/local/tsa/sedata/msn/tsa-msn-report-2010-04-06-U689.csv.zip... 2010-04-08 04:27:33.073 (3) [P2T1]: URL: https://Adcenterapidownload.microsoft.com/AdCenterAPIDownload.aspx?q=D5A226F15402A0997B8C2403D50293A208D671291569716044B891C9BC73032612D646ABC7135444503526BC8458B20A1D8969409832A80A051E1E439C483958BE639FE9F62261DFFF32DE320D8C7BF9BC00F97ACAFE69040D1992CBE53DAB2575DD9F6434E1E7AA9AF52F1FFF558E06A4281D20678E5EE2AEA5EA79564E84BEC9A17C667564A696B188D7D2602504DEBB282ABFFDC85396506E8A3FB93955CDD1C516983269F0BA7AEB20AE7FA75672464CF26D51C79F609A3B68B3FE3E58CA4610 2010-04-08 04:27:33.709 (3) [P2T1]: Connected to URL "https://Adcenterapidownload.microsoft.com/AdCenterAPIDownload.aspx?q=D5A226F15402A0997B8C2403D50293A208D671291569716044B891C9BC73032612D646ABC7135444503526BC8458B20A1D8969409832A80A051E1E439C483958BE639FE9F62261DFFF32DE320D8C7BF9BC00F97ACAFE69040D1992CBE53DAB2575DD9F6434E1E7AA9AF52F1FFF558E06A4281D20678E5EE2AEA5EA79564E84BEC9A17C667564A696B188D7D2602504DEBB282ABFFDC85396506E8A3FB93955CDD1C516983269F0BA7AEB20AE7FA75672464CF26D51C79F609A3B68B3FE3E58CA4610" 2010-04-08 04:27:34.741 (3) [P2T1]: ... Download Complete 2010-04-08 04:27:34.742 (3) [P2T1]: Parsing /var/local/tsa/sedata/msn/tsa-msn-report-2010-04-06-U689.csv.zip... 2010-04-08 04:27:37.625 (3) [P2T1]: DatabasePool with a limit of 8 created 2010-04-08 04:27:37.905 (3) [P2T1]: Deleting existing records for seuser #689 where ((`GregorianDate`="2010-04-06 00:00:00")) 2010-04-08 04:27:40.323 (3) [P2T1]: ...Done Parsing 2010-04-08 04:27:40.324 (3) [P2T1]: === Completed user #689, Legalzoom === 2010-04-08 04:27:40.325 (3) [P1T1]: ------------Stage MSN done 2010-04-08 04:27:40.325 (3) [P1T1]: =============== Completed Stage MSN ================ 2010-04-08 04:27:40.328 (3) [P1T1]: Stage MSN: 21.574s 2010-04-08 04:27:40.328 (3) [P1T1]: by key: 2010-04-08 04:27:40.328 (3) [P1T1]: db: 2.777s 2010-04-08 04:27:40.328 (3) [P1T1]: by thread: 2010-04-08 04:27:40.329 (3) [P1T1]: P2T1: 2.773s 2010-04-08 04:27:40.329 (3) [P1T1]: P1T1: 0.004s 2010-04-08 04:27:40.329 (3) [P1T1]: msn: 5.877s 2010-04-08 04:27:40.329 (3) [P1T1]: other: 12.920s 2010-04-08 04:27:40.329 (3) [P1T1]: Rerun SESUMM for Resolving Discrepancies for date:2010-04-06 2010-04-08 04:27:40.335 (3) [P1T1]: DatabasePool with a limit of 38 created 2010-04-08 04:27:40.352 (3) [P1T1]: SESUMM: Rerunning specified seUsers (null) or seAccounts ((13959)) 2010-04-08 04:27:40.356 (3) [P1T1]: Debug Level set to 3 2010-04-08 04:27:40.357 (3) [P1T1]: =============== Starting Search Engine Summarizer for Tue Apr 06 00:00:00 PDT 2010 ================ 2010-04-08 04:27:40.950 (3) [P3T1]: DatabasePool with a limit of 105 created 2010-04-08 04:27:41.555 (3) [P3T1]: DatabasePool with a limit of 105 created 2010-04-08 04:27:44.148 (3) [P3T1]: SESUMM: Handling Account (13959) "Wills" for user (689) "Legalzoom" 2010-04-08 04:27:44.190 (3) [P3T1]: DatabasePool with a limit of 105 created 2010-04-08 04:28:18.637 (3) [main]: Waiting for tasks to be done 2010-04-08 04:28:27.180 (2) [P3T1]: Warning(s) detected in statement [LOAD DATA LOCAL INFILE '/tmp/sesummAct1395946561.csv' REPLACE INTO TABLE `tmp`.`searchEngineActivitySummary201004_acct289` FIELDS TERMINATED BY '\t' ESCAPED BY '\\' (`sourceID`,`searchEngineListingID`,`siteID`,`startTime`,`resolution`,`count`,`impressions`,`cost`,`avgPosition`,`avgCTR`,`conversions`,`value`,`qualityScore`)] executed by user [spike] 2010-04-08 04:28:27.203 (2) [P3T1]: SQL Warning: Column was set to data type implicit default; NULL supplied for NOT NULL column 'avgCTR' at row 1 (code:1263) 2010-04-08 04:28:27.203 (2) [P3T1]: SQL Warning: Column was set to data type implicit default; NULL supplied for NOT NULL column 'avgCTR' at row 2 (code:1263) 2010-04-08 04:28:27.203 (2) [P3T1]: SQL Warning: Column was set to data type implicit default; NULL supplied for NOT NULL column 'avgCTR' at row 3 (code:1263) 2010-04-08 04:28:27.203 (2) [P3T1]: SQL Warning: Column was set to data type implicit default; NULL supplied for NOT NULL column 'avgCTR' at row 4 (code:1263) 2010-04-08 04:28:27.203 (2) [P3T1]: SQL Warning: Column was set to data type implicit default; NULL supplied for NOT NULL column 'avgCTR' at row 5 (code:1263) 2010-04-08 04:28:27.203 (2) [P3T1]: SQL Warning: Column was set to data type implicit default; NULL supplied for NOT NULL column 'avgCTR' at row 6 (code:1263) 2010-04-08 04:28:27.203 (2) [P3T1]: SQL Warning: Column was set to data type implicit default; NULL supplied for NOT NULL column 'avgCTR' at row 7 (code:1263) 2010-04-08 04:28:27.203 (2) [P3T1]: SQL Warning: Column was set to data type implicit default; NULL supplied for NOT NULL column 'avgCTR' at row 8 (code:1263) 2010-04-08 04:28:27.203 (2) [P3T1]: SQL Warning: Column was set to data type implicit default; NULL supplied for NOT NULL column 'avgCTR' at row 9 (code:1263) 2010-04-08 04:28:27.203 (2) [P3T1]: SQL Warning: Column was set to data type implicit default; NULL supplied for NOT NULL column 'avgCTR' at row 10 (code:1263) 2010-04-08 04:28:27.203 (2) [P3T1]: SQL Warning: Column was set to data type implicit default; NULL supplied for NOT NULL column 'avgCTR' at row 11 (code:1263) 2010-04-08 04:28:27.204 (2) [P3T1]: SQL Warning: Column was set to data type implicit default; NULL supplied for NOT NULL column 'avgCTR' at row 12 (code:1263) 2010-04-08 04:28:27.204 (2) [P3T1]: SQL Warning: Column was set to data type implicit default; NULL supplied for NOT NULL column 'avgCTR' at row 13 (code:1263) 2010-04-08 04:28:27.204 (2) [P3T1]: SQL Warning: Column was set to data type implicit default; NULL supplied for NOT NULL column 'avgCTR' at row 14 (code:1263) 2010-04-08 04:28:27.204 (2) [P3T1]: SQL Warning: Column was set to data type implicit default; NULL supplied for NOT NULL column 'avgCTR' at row 15 (code:1263) 2010-04-08 04:28:27.204 (2) [P3T1]: SQL Warning: Column was set to data type implicit default; NULL supplied for NOT NULL column 'avgCTR' at row 16 (code:1263) 2010-04-08 04:28:27.204 (2) [P3T1]: SQL Warning: Column was set to data type implicit default; NULL supplied for NOT NULL column 'avgCTR' at row 17 (code:1263) 2010-04-08 04:28:27.204 (2) [P3T1]: SQL Warning: Column was set to data type implicit default; NULL supplied for NOT NULL column 'avgCTR' at row 18 (code:1263) 2010-04-08 04:28:27.204 (2) [P3T1]: SQL Warning: Column was set to data type implicit default; NULL supplied for NOT NULL column 'avgCTR' at row 19 (code:1263) 2010-04-08 04:28:27.204 (2) [P3T1]: SQL Warning: Column was set to data type implicit default; NULL supplied for NOT NULL column 'avgCTR' at row 20 (code:1263) 2010-04-08 04:28:27.204 (2) [P3T1]: SQL Warning: Column was set to data type implicit default; NULL supplied for NOT NULL column 'avgCTR' at row 21 (code:1263) 2010-04-08 04:28:27.204 (2) [P3T1]: SQL Warning: Column was set to data type implicit default; NULL supplied for NOT NULL column 'avgCTR' at row 22 (code:1263) 2010-04-08 04:28:27.204 (2) [P3T1]: SQL Warning: Column was set to data type implicit default; NULL supplied for NOT NULL column 'avgCTR' at row 23 (code:1263) 2010-04-08 04:28:27.204 (2) [P3T1]: SQL Warning: Column was set to data type implicit default; NULL supplied for NOT NULL column 'avgCTR' at row 24 (code:1263) 2010-04-08 04:28:27.204 (2) [P3T1]: SQL Warning: Column was set to data type implicit default; NULL supplied for NOT NULL column 'avgCTR' at row 25 (code:1263) 2010-04-08 04:28:27.204 (2) [P3T1]: SQL Warning: Column was set to data type implicit default; NULL supplied for NOT NULL column 'avgCTR' at row 26 (code:1263) 2010-04-08 04:28:27.228 (2) [P3T1]: SQL Warning: Column was set to data type implicit default; NULL supplied for NOT NULL column 'avgCTR' at row 27 (code:1263) 2010-04-08 04:28:27.228 (2) [P3T1]: SQL Warning: Column was set to data type implicit default; NULL supplied for NOT NULL column 'avgCTR' at row 28 (code:1263) 2010-04-08 04:28:27.228 (2) [P3T1]: SQL Warning: Column was set to data type implicit default; NULL supplied for NOT NULL column 'avgCTR' at row 29 (code:1263) 2010-04-08 04:28:27.228 (2) [P3T1]: SQL Warning: Column was set to data type implicit default; NULL supplied for NOT NULL column 'avgCTR' at row 30 (code:1263) 2010-04-08 04:28:27.228 (2) [P3T1]: SQL Warning: Column was set to data type implicit default; NULL supplied for NOT NULL column 'avgCTR' at row 31 (code:1263) 2010-04-08 04:28:27.228 (2) [P3T1]: SQL Warning: Column was set to data type implicit default; NULL supplied for NOT NULL column 'avgCTR' at row 32 (code:1263) 2010-04-08 04:28:27.228 (2) [P3T1]: SQL Warning: Column was set to data type implicit default; NULL supplied for NOT NULL column 'avgCTR' at row 33 (code:1263) 2010-04-08 04:28:27.228 (2) [P3T1]: SQL Warning: Column was set to data type implicit default; NULL supplied for NOT NULL column 'avgCTR' at row 34 (code:1263) 2010-04-08 04:28:27.228 (2) [P3T1]: SQL Warning: Column was set to data type implicit default; NULL supplied for NOT NULL column 'avgCTR' at row 35 (code:1263) 2010-04-08 04:28:27.240 (2) [P3T1]: SQL Warning: Column was set to data type implicit default; NULL supplied for NOT NULL column 'avgCTR' at row 36 (code:1263) 2010-04-08 04:28:27.240 (2) [P3T1]: SQL Warning: Column was set to data type implicit default; NULL supplied for NOT NULL column 'avgCTR' at row 37 (code:1263) 2010-04-08 04:28:27.240 (2) [P3T1]: SQL Warning: Column was set to data type implicit default; NULL supplied for NOT NULL column 'avgCTR' at row 38 (code:1263) 2010-04-08 04:28:27.240 (2) [P3T1]: SQL Warning: Column was set to data type implicit default; NULL supplied for NOT NULL column 'avgCTR' at row 39 (code:1263) 2010-04-08 04:28:27.240 (2) [P3T1]: SQL Warning: Column was set to data type implicit default; NULL supplied for NOT NULL column 'avgCTR' at row 40 (code:1263) 2010-04-08 04:28:27.240 (2) [P3T1]: SQL Warning: Column was set to data type implicit default; NULL supplied for NOT NULL column 'avgCTR' at row 41 (code:1263) 2010-04-08 04:28:27.240 (2) [P3T1]: SQL Warning: Column was set to data type implicit default; NULL supplied for NOT NULL column 'avgCTR' at row 42 (code:1263) 2010-04-08 04:28:27.240 (2) [P3T1]: SQL Warning: Column was set to data type implicit default; NULL supplied for NOT NULL column 'avgCTR' at row 43 (code:1263) 2010-04-08 04:28:27.240 (2) [P3T1]: SQL Warning: Column was set to data type implicit default; NULL supplied for NOT NULL column 'avgCTR' at row 44 (code:1263) 2010-04-08 04:28:27.240 (2) [P3T1]: SQL Warning: Column was set to data type implicit default; NULL supplied for NOT NULL column 'avgCTR' at row 45 (code:1263) 2010-04-08 04:28:27.244 (2) [P3T1]: SQL Warning: Column was set to data type implicit default; NULL supplied for NOT NULL column 'avgCTR' at row 46 (code:1263) 2010-04-08 04:28:27.244 (2) [P3T1]: SQL Warning: Column was set to data type implicit default; NULL supplied for NOT NULL column 'avgCTR' at row 47 (code:1263) 2010-04-08 04:28:27.244 (2) [P3T1]: SQL Warning: Column was set to data type implicit default; NULL supplied for NOT NULL column 'avgCTR' at row 48 (code:1263) 2010-04-08 04:28:27.244 (2) [P3T1]: SQL Warning: Column was set to data type implicit default; NULL supplied for NOT NULL column 'avgCTR' at row 49 (code:1263) 2010-04-08 04:28:27.244 (2) [P3T1]: SQL Warning: Column was set to data type implicit default; NULL supplied for NOT NULL column 'avgCTR' at row 50 (code:1263) 2010-04-08 04:28:27.244 (2) [P3T1]: SQL Warning: Column was set to data type implicit default; NULL supplied for NOT NULL column 'avgCTR' at row 51 (code:1263) 2010-04-08 04:28:27.244 (2) [P3T1]: SQL Warning: Column was set to data type implicit default; NULL supplied for NOT NULL column 'avgCTR' at row 52 (code:1263) 2010-04-08 04:28:27.244 (2) [P3T1]: SQL Warning: Column was set to data type implicit default; NULL supplied for NOT NULL column 'avgCTR' at row 53 (code:1263) 2010-04-08 04:28:27.244 (2) [P3T1]: SQL Warning: Column was set to data type implicit default; NULL supplied for NOT NULL column 'avgCTR' at row 54 (code:1263) 2010-04-08 04:28:27.244 (2) [P3T1]: SQL Warning: Column was set to data type implicit default; NULL supplied for NOT NULL column 'avgCTR' at row 55 (code:1263) 2010-04-08 04:28:27.244 (2) [P3T1]: SQL Warning: Column was set to data type implicit default; NULL supplied for NOT NULL column 'avgCTR' at row 56 (code:1263) 2010-04-08 04:28:27.244 (2) [P3T1]: SQL Warning: Column was set to data type implicit default; NULL supplied for NOT NULL column 'avgCTR' at row 57 (code:1263) 2010-04-08 04:28:27.244 (2) [P3T1]: SQL Warning: Column was set to data type implicit default; NULL supplied for NOT NULL column 'avgCTR' at row 58 (code:1263) 2010-04-08 04:28:27.244 (2) [P3T1]: SQL Warning: Column was set to data type implicit default; NULL supplied for NOT NULL column 'avgCTR' at row 59 (code:1263) 2010-04-08 04:28:27.256 (2) [P3T1]: SQL Warning: Column was set to data type implicit default; NULL supplied for NOT NULL column 'avgCTR' at row 60 (code:1263) 2010-04-08 04:28:27.256 (2) [P3T1]: SQL Warning: Column was set to data type implicit default; NULL supplied for NOT NULL column 'avgCTR' at row 61 (code:1263) 2010-04-08 04:28:27.256 (2) [P3T1]: SQL Warning: Column was set to data type implicit default; NULL supplied for NOT NULL column 'avgCTR' at row 62 (code:1263) 2010-04-08 04:28:27.256 (2) [P3T1]: SQL Warning: Column was set to data type implicit default; NULL supplied for NOT NULL column 'avgCTR' at row 63 (code:1263) 2010-04-08 04:28:27.256 (2) [P3T1]: SQL Warning: Column was set to data type implicit default; NULL supplied for NOT NULL column 'avgCTR' at row 64 (code:1263) 2010-04-08 04:28:27.834 (3) [P3T1]: SESUMM: Completed Account (13959) "Wills" for user (689), 515 Standard Report Row(s) and 0 Product Conversion Report Row(s) processed 2010-04-08 04:28:27.836 (3) [P1T1]: After joining threads, calling doPostJoinActions 2010-04-08 04:28:27.836 (3) [P1T1]: =============== Completed Search Engine Summarizer ================ 2010-04-08 04:28:27.836 (3) [P1T1]: Stage MSN: 21.574s 2010-04-08 04:28:27.836 (3) [P1T1]: by key: 2010-04-08 04:28:27.837 (3) [P1T1]: db: 2.777s 2010-04-08 04:28:27.837 (3) [P1T1]: by thread: 2010-04-08 04:28:27.837 (3) [P1T1]: P2T1: 2.773s 2010-04-08 04:28:27.837 (3) [P1T1]: P1T1: 0.004s 2010-04-08 04:28:27.838 (3) [P1T1]: msn: 5.877s 2010-04-08 04:28:27.838 (3) [P1T1]: other: 12.920s 2010-04-08 04:28:27.838 (3) [P1T1]: Rerun WHSUMM for Resolving Discrepancies for date:2010-04-06 2010-04-08 04:28:27.846 (3) [P1T1]: Debug Level set to 3 2010-04-08 04:28:27.846 (2) [P1T1]: No granularity given, all 2010-04-08 04:28:27.846 (3) [P1T1]: =============== Starting Warehouse Summarizer ================ 2010-04-08 04:28:27.847 (3) [P1T1]: ----------------Warehouse Summarizer starting 2010-04-08 04:28:27.901 (3) [P4T1]: DatabasePool with a limit of 80 created 2010-04-08 04:28:27.921 (3) [P4T1]: DatabasePool with a limit of 80 created 2010-04-08 04:28:28.081 (3) [P4T1]: DatabasePool with a limit of 80 created 2010-04-08 04:28:28.143 (3) [P4T1]: Skipping sync of dimensions for acct #289 (last sync was at 2010-04-08 03:00:43.0) 2010-04-08 04:28:28.144 (3) [P4T1]: Starting daily for Account #289 LegalZoom for Tue Apr 06 00:00:00 PDT 2010 2010-04-08 04:28:29.534 (3) [P4T1]: Processing Search Engine Activity... 2010-04-08 04:28:49.285 (3) [P4T1]: ... done processing Search Engine Activity 2010-04-08 04:28:49.285 (3) [P4T1]: Processing Search Engine Products by Source... 2010-04-08 04:28:49.466 (3) [P4T1]: ...done processing Search Engine Products by Source 2010-04-08 04:28:49.467 (3) [P4T1]: Updating perf rows that don't have a bidTargetID, but should... for Dist(s) (147) 2010-04-08 04:28:52.286 (2) [P4T1]: ... unable to update bidTargetIDs of 51 perf records! 2010-04-08 04:28:52.286 (3) [P4T1]: Updating perf totals... 2010-04-08 04:28:53.382 (3) [P4T1]: Updating conversion totals... 2010-04-08 04:28:53.465 (3) [P4T1]: accountID[289] has no datafeed config... do regular processing 2010-04-08 04:28:53.496 (3) [P4T1]: Finished daily for Account #289 LegalZoom on Tue Apr 06 00:00:00 PDT 2010 2010-04-08 04:28:53.550 (3) [P4T1]: Starting Account #289 LegalZoom aggregates for Tue Apr 06 00:00:00 PDT 2010 to