Java HotSpot(TM) 64-Bit Server VM warning: Can't detect initial thread stack location - find_vma failed 2010-05-10 14:55:28.199 (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-05-10 14:55:34.119 (3) [main]: getAbsolutePath() returned /tmp/abtl24661.csv 2010-05-10 14:55:34.132 (3) [main]: Connected to URL "http://yell-ec-xml:8080//reports/1/report_7441.csv" 2010-05-10 14:55:34.178 (3) [main]: getAbsolutePath() returned /tmp/abtl24661.csv 2010-05-10 14:55:34.673 (3) [main]: DatabasePool with a limit of 80 created 2010-05-10 14:55:34.709 (3) [main]: getAbsolutePath() returned /tmp/abtl24661.csv 2010-05-10 14:55:34.742 (3) [main]: Writing file to /var/local/tsa/datachecker/2010-05-10-tsa-DiscrepancyReport-D3.csv 2010-05-10 14:55:34.889 (3) [main]: ... done 2010-05-10 14:55:34.889 (3) [main]: Report generated successfully at following location /var/local/tsa/datachecker/2010-05-10-tsa-DiscrepancyReport-D3.csv 2010-05-10 14:55:34.941 (3) [main]: DatabasePool with a limit of 80 created 2010-05-10 14:55:34.980 (3) [main]: Getting distinct Discrepancies accounts 2010-05-10 14:55:34.981 (3) [main]: DatabasePool with a limit of 80 created 2010-05-10 14:55:35.010 (3) [main]: =============== Starting Data Checker Discrepancy Resolver ================ 2010-05-10 14:55:35.010 (3) [main]: ----------------Data Checker Discrepancy Resolver starting 2010-05-10 14:55:35.095 (3) [P1T1]: Running Data Checker Discrepancies Resolver for Account ID::3611 2010-05-10 14:55:35.096 (3) [P1T1]: DatabasePool with a limit of 80 created 2010-05-10 14:55:35.152 (3) [P1T1]: Getting distinct Discrepancies dates 2010-05-10 14:55:35.152 (3) [P1T1]: DatabasePool with a limit of 80 created 2010-05-10 14:55:35.216 (3) [P1T1]: Rerun Staging for Resolving Discrepancies for date:2010-04-18 2010-05-10 14:55:35.221 (3) [P1T1]: Debug Level set to 3 2010-05-10 14:55:35.224 (3) [P1T1]: =============== Starting Google MCC Report ================ 2010-05-10 14:55:35.225 (3) [P1T1]: ----------------Google MCC Report starting 2010-05-10 14:55:35.332 (3) [P2T1]: === Starting user #4071, === 2010-05-10 14:55:35.333 (3) [P2T1]: Using filename: /var/local/tsa/sedata/google/tsa-mcc-report-2010-04-18-U4071.xml.gz 2010-05-10 14:55:35.424 (3) [P2T1]: GoogleAdWordsAPI.setSandbox(false) 2010-05-10 14:55:35.566 (3) [P2T1]: Created shared sesystem connection rw 2010-05-10 14:55:36.181 (3) [P2T1]: Downloading MCC report... 2010-05-10 14:55:36.186 (3) [P2T1]: Scheduling report attempt 1: name=tsamccreport_2010-04-18_mmsclientaccount+3008@gmail.com with id=null 2010-05-10 14:55:36.186 (3) [P2T1]: validating report job... 2010-05-10 14:55:49.828 (2) [P2T1]: Report validation failed: Code 30 - The following columns are not supported by the Report Type Creative : [Conversions, Transactions, SalesCount, SalesValue, LeadCount, LeadValue, SignupCount, SignupValue, PageViewCount, PageViewValue, DefaultCount, DefaultValue] 2010-05-10 14:55:49.829 (3) [P2T1]: Trying to remove unsupported columns for trigger [ The following columns are not supported by the Report Type Creative : [Conversions, Transactions, SalesCount, SalesValue, LeadCount, LeadValue, SignupCount, SignupValue, PageViewCount, PageViewValue, DefaultCount, DefaultValue]] 2010-05-10 14:55:54.706 (3) [P2T1]: ...success 2010-05-10 14:56:00.990 (3) [P2T1]: Scheduled report. Report Job ID = 1213301067 2010-05-10 14:56:14.436 (3) [P2T1]: Downloading report attempt 1: name=/var/local/tsa/sedata/google/tsa-mcc-report-2010-04-18-U4071.xml.gz with id=1213301067 from url https://adwords.google.com/api/adwords/ReportDownload?t=AAAAAEhRgUsAAAEogoBtSwEAAAACDCJ_sroAIgIH1oBxOY9umD1S_f6VJIDu 2010-05-10 14:56:17.581 (3) [P2T1]: Connected to URL "https://adwords.google.com/api/adwords/ReportDownload?t=AAAAAEhRgUsAAAEogoBtSwEAAAACDCJ_sroAIgIH1oBxOY9umD1S_f6VJIDu" 2010-05-10 14:56:25.921 (3) [P2T1]: MCC report download (Sun Apr 18 00:00:00 BST 2010, "/var/local/tsa/sedata/google/tsa-mcc-report-2010-04-18-U4071.xml.gz") -> success:true 2010-05-10 14:56:25.921 (3) [P2T1]: Parsing MCC report into staging database... 2010-05-10 14:56:25.921 (3) [P2T1]: DatabasePool with a limit of 3 created 2010-05-10 14:56:26.040 (3) [P2T1]: Finding column names... 2010-05-10 14:56:26.071 (3) [P2T1]: Writing temp infile... 2010-05-10 14:56:26.323 (3) [P2T1]: Deleting existing records where ((`startTime`="2010-04-18 00:00:00")) 2010-05-10 14:56:26.345 (3) [P2T1]: Loading data infile into temp table... 2010-05-10 14:56:26.356 (3) [P2T1]: Inserting into staging database... 2010-05-10 14:56:26.376 (3) [P2T1]: ...done 2010-05-10 14:56:26.377 (3) [P2T1]: === Completed user #4071, === 2010-05-10 14:56:27.218 (3) [P1T1]: ------------Google MCC Report done 2010-05-10 14:56:27.219 (3) [P1T1]: =============== Completed Google MCC Report ================ 2010-05-10 14:56:27.221 (3) [P1T1]: Google MCC Report: 51.995s 2010-05-10 14:56:27.221 (3) [P1T1]: by key: 2010-05-10 14:56:27.221 (3) [P1T1]: google: 29.286s 2010-05-10 14:56:27.222 (3) [P1T1]: db: 0.461s 2010-05-10 14:56:27.222 (3) [P1T1]: by thread: 2010-05-10 14:56:27.222 (3) [P1T1]: P2T1: 0.460s 2010-05-10 14:56:27.259 (3) [P1T1]: P1T1: 0.001s 2010-05-10 14:56:27.259 (3) [P1T1]: other: 22.248s 2010-05-10 14:56:27.260 (3) [P1T1]: Rerun SESUMM for Resolving Discrepancies for date:2010-04-18 2010-05-10 14:56:27.266 (3) [P1T1]: DatabasePool with a limit of 38 created 2010-05-10 14:56:27.288 (3) [P1T1]: SESUMM: Rerunning specified seUsers (4071) or seAccounts ((11781,11791,11801,11811,11831,11841,11861,11871)) 2010-05-10 14:56:27.291 (3) [P1T1]: Debug Level set to 3 2010-05-10 14:56:27.291 (3) [P1T1]: =============== Starting Search Engine Summarizer for Sun Apr 18 00:00:00 BST 2010 ================ 2010-05-10 14:56:27.461 (3) [P3T1]: DatabasePool with a limit of 105 created 2010-05-10 14:56:27.568 (3) [P3T1]: GoogleAdWordsAPI.setSandbox(false) 2010-05-10 14:56:28.422 (3) [P3T1]: DatabasePool with a limit of 105 created 2010-05-10 14:56:28.464 (3) [P3T1]: SESUMM: Handling Account (11871) "0016034650_1000000410_1040_101862_GM" for user (4071) "" 2010-05-10 14:56:28.493 (3) [P3T1]: DatabasePool with a limit of 105 created 2010-05-10 14:56:28.645 (3) [P3T3]: GoogleAdWordsAPI.setSandbox(false) 2010-05-10 14:56:28.950 (3) [P3T3]: SESUMM: Handling Account (11801) "0016034650_1000000049_1040_101861_GT" for user (4071) "" 2010-05-10 14:56:29.665 (3) [P3T1]: SESUMM: Completed Account (11871) "0016034650_1000000410_1040_101862_GM" for user (4071), 11 Standard Report Row(s) and 0 Product Conversion Report Row(s) processed 2010-05-10 14:56:29.673 (3) [P3T1]: GoogleAdWordsAPI.setSandbox(false) 2010-05-10 14:56:29.891 (3) [P3T1]: SESUMM: Handling Account (11791) "0016034650_1000001006_1040_101860_GT" for user (4071) "" 2010-05-10 14:56:30.468 (3) [P3T1]: SESUMM: Completed Account (11791) "0016034650_1000001006_1040_101860_GT" for user (4071), 13 Standard Report Row(s) and 0 Product Conversion Report Row(s) processed 2010-05-10 14:56:30.486 (3) [P3T1]: GoogleAdWordsAPI.setSandbox(false) 2010-05-10 14:56:30.643 (3) [P3T1]: SESUMM: Handling Account (11841) "0016034650_1000001006_1040_101860_GM" for user (4071) "" 2010-05-10 14:56:30.825 (3) [P3T1]: SESUMM: Completed Account (11841) "0016034650_1000001006_1040_101860_GM" for user (4071), 1 Standard Report Row(s) and 0 Product Conversion Report Row(s) processed 2010-05-10 14:56:30.876 (3) [P3T1]: GoogleAdWordsAPI.setSandbox(false) 2010-05-10 14:56:30.901 (3) [P3T3]: SESUMM: Completed Account (11801) "0016034650_1000000049_1040_101861_GT" for user (4071), 34 Standard Report Row(s) and 0 Product Conversion Report Row(s) processed 2010-05-10 14:56:30.922 (3) [P3T3]: GoogleAdWordsAPI.setSandbox(false) 2010-05-10 14:56:31.336 (3) [P3T3]: SESUMM: Handling Account (11831) "0016034650_1000000044_1040_101863_GT" for user (4071) "" 2010-05-10 14:56:31.971 (3) [P3T3]: SESUMM: Completed Account (11831) "0016034650_1000000044_1040_101863_GT" for user (4071), 25 Standard Report Row(s) and 0 Product Conversion Report Row(s) processed 2010-05-10 14:56:31.978 (3) [P3T3]: GoogleAdWordsAPI.setSandbox(false) 2010-05-10 14:56:32.038 (3) [P3T3]: SESUMM: Handling Account (11861) "0016034650_1000000049_1040_101861_GM" for user (4071) "" 2010-05-10 14:56:32.138 (3) [P3T3]: SESUMM: Completed Account (11861) "0016034650_1000000049_1040_101861_GM" for user (4071), 1 Standard Report Row(s) and 0 Product Conversion Report Row(s) processed 2010-05-10 14:56:33.334 (3) [P3T2]: GoogleAdWordsAPI.setSandbox(false) 2010-05-10 14:56:33.390 (3) [P3T2]: SESUMM: Handling Account (11811) "0016034650_1000000496_1040_101864_GT" for user (4071) "" 2010-05-10 14:56:33.629 (3) [P3T2]: SESUMM: Completed Account (11811) "0016034650_1000000496_1040_101864_GT" for user (4071), 26 Standard Report Row(s) and 0 Product Conversion Report Row(s) processed 2010-05-10 14:56:35.169 (3) [P3T1]: SESUMM: Handling Account (11781) "0016034650_1000000410_1040_101862_GT" for user (4071) "" 2010-05-10 14:56:35.229 (3) [main]: Waiting for tasks to be done 2010-05-10 14:56:35.768 (3) [P3T1]: SESUMM: Completed Account (11781) "0016034650_1000000410_1040_101862_GT" for user (4071), 62 Standard Report Row(s) and 0 Product Conversion Report Row(s) processed 2010-05-10 14:56:36.169 (3) [P1T1]: After joining threads, calling doPostJoinActions 2010-05-10 14:56:36.170 (3) [P1T1]: =============== Completed Search Engine Summarizer ================ 2010-05-10 14:56:36.171 (3) [P1T1]: Google MCC Report: 51.995s 2010-05-10 14:56:36.171 (3) [P1T1]: by key: 2010-05-10 14:56:36.171 (3) [P1T1]: google: 29.286s 2010-05-10 14:56:36.172 (3) [P1T1]: db: 0.461s 2010-05-10 14:56:36.172 (3) [P1T1]: by thread: 2010-05-10 14:56:36.172 (3) [P1T1]: P2T1: 0.460s 2010-05-10 14:56:36.172 (3) [P1T1]: P1T1: 0.001s 2010-05-10 14:56:36.173 (3) [P1T1]: other: 22.248s 2010-05-10 14:56:36.173 (3) [P1T1]: Rerun WHSUMM for Resolving Discrepancies for date:2010-04-18 2010-05-10 14:56:36.179 (3) [P1T1]: Debug Level set to 3 2010-05-10 14:56:36.179 (2) [P1T1]: No granularity given, all 2010-05-10 14:56:36.180 (3) [P1T1]: =============== Starting Warehouse Summarizer ================ 2010-05-10 14:56:36.180 (3) [P1T1]: ----------------Warehouse Summarizer starting 2010-05-10 14:56:37.548 (3) [P4T1]: DatabasePool with a limit of 80 created 2010-05-10 14:56:37.744 (3) [P4T1]: DatabasePool with a limit of 80 created 2010-05-10 14:56:37.969 (3) [P4T1]: DatabasePool with a limit of 80 created 2010-05-10 14:56:37.994 (3) [P4T1]: Skipping sync of dimensions for acct #3611 (last sync was at 2010-05-10 12:08:41.0) 2010-05-10 14:56:37.996 (3) [P4T1]: Starting daily for Account #3611 qdtest9 for Sun Apr 18 00:00:00 BST 2010 2010-05-10 14:56:38.015 (3) [P4T1]: Processing Search Engine Activity... 2010-05-10 14:56:38.256 (3) [P4T1]: ... done processing Search Engine Activity 2010-05-10 14:56:38.257 (3) [P4T1]: Processing Search Engine Products by Source... 2010-05-10 14:56:38.288 (3) [P4T1]: ...done processing Search Engine Products by Source 2010-05-10 14:56:38.289 (3) [P4T1]: Updating perf rows that don't have a bidTargetID, but should... for Dist(s) (3) 2010-05-10 14:56:38.296 (3) [P4T1]: Updating perf totals... 2010-05-10 14:56:38.304 (3) [P4T1]: Updating conversion totals... 2010-05-10 14:56:38.309 (3) [P4T1]: Finished daily for Account #3611 qdtest9 on Sun Apr 18 00:00:00 BST 2010 2010-05-10 14:56:38.322 (3) [P4T1]: Starting Account #3611 qdtest9 aggregates for Sun Apr 18 00:00:00 BST 2010 to success:true 2010-05-10 14:57:56.200 (3) [P5T1]: Parsing MCC report into staging database... 2010-05-10 14:57:56.201 (3) [P5T1]: DatabasePool with a limit of 3 created 2010-05-10 14:57:56.256 (3) [P5T1]: Finding column names... 2010-05-10 14:57:56.262 (3) [P5T1]: Writing temp infile... 2010-05-10 14:57:56.292 (3) [P5T1]: Deleting existing records where ((`startTime`="2010-04-20 00:00:00")) 2010-05-10 14:57:56.294 (3) [P5T1]: Loading data infile into temp table... 2010-05-10 14:57:56.332 (3) [P5T1]: Inserting into staging database... 2010-05-10 14:57:56.374 (3) [P5T1]: ...done 2010-05-10 14:57:56.375 (3) [P5T1]: === Completed user #4071, === 2010-05-10 14:57:58.716 (3) [P1T1]: ------------Google MCC Report done 2010-05-10 14:57:58.718 (3) [P1T1]: =============== Completed Google MCC Report ================ 2010-05-10 14:57:58.718 (3) [P1T1]: Google MCC Report: 51.995s 2010-05-10 14:57:58.718 (3) [P1T1]: by key: 2010-05-10 14:57:58.718 (3) [P1T1]: google: 29.286s 2010-05-10 14:57:58.718 (3) [P1T1]: db: 0.461s 2010-05-10 14:57:58.718 (3) [P1T1]: by thread: 2010-05-10 14:57:58.718 (3) [P1T1]: P2T1: 0.460s 2010-05-10 14:57:58.719 (3) [P1T1]: P1T1: 0.001s 2010-05-10 14:57:58.720 (3) [P1T1]: other: 22.248s 2010-05-10 14:57:58.720 (3) [P1T1]: Rerun SESUMM for Resolving Discrepancies for date:2010-04-20 2010-05-10 14:57:58.722 (3) [P1T1]: DatabasePool with a limit of 38 created 2010-05-10 14:57:58.770 (3) [P1T1]: SESUMM: Rerunning specified seUsers (4071) or seAccounts ((11781,11791,11801,11811,11831,11841,11861,11871)) 2010-05-10 14:57:58.772 (3) [P1T1]: Debug Level set to 3 2010-05-10 14:57:58.772 (3) [P1T1]: =============== Starting Search Engine Summarizer for Tue Apr 20 00:00:00 BST 2010 ================ 2010-05-10 14:57:58.802 (3) [P6T1]: DatabasePool with a limit of 105 created 2010-05-10 14:57:59.065 (3) [P6T2]: GoogleAdWordsAPI.setSandbox(false) 2010-05-10 14:57:59.194 (3) [P6T2]: DatabasePool with a limit of 105 created 2010-05-10 14:57:59.254 (3) [P6T2]: SESUMM: Handling Account (11811) "0016034650_1000000496_1040_101864_GT" for user (4071) "" 2010-05-10 14:57:59.256 (3) [P6T2]: DatabasePool with a limit of 105 created 2010-05-10 14:57:59.920 (3) [P6T2]: SESUMM: Completed Account (11811) "0016034650_1000000496_1040_101864_GT" for user (4071), 17 Standard Report Row(s) and 0 Product Conversion Report Row(s) processed 2010-05-10 14:57:59.965 (3) [P6T1]: GoogleAdWordsAPI.setSandbox(false) 2010-05-10 14:57:59.984 (3) [P6T2]: GoogleAdWordsAPI.setSandbox(false) 2010-05-10 14:57:59.987 (3) [P6T3]: GoogleAdWordsAPI.setSandbox(false) 2010-05-10 14:58:00.247 (3) [P6T1]: SESUMM: Handling Account (11871) "0016034650_1000000410_1040_101862_GM" for user (4071) "" 2010-05-10 14:58:00.261 (3) [P6T2]: SESUMM: Handling Account (11791) "0016034650_1000001006_1040_101860_GT" for user (4071) "" 2010-05-10 14:58:00.425 (3) [P6T3]: SESUMM: Handling Account (11801) "0016034650_1000000049_1040_101861_GT" for user (4071) "" 2010-05-10 14:58:01.192 (3) [P6T2]: SESUMM: Completed Account (11791) "0016034650_1000001006_1040_101860_GT" for user (4071), 20 Standard Report Row(s) and 0 Product Conversion Report Row(s) processed 2010-05-10 14:58:01.201 (3) [P6T1]: SESUMM: Completed Account (11871) "0016034650_1000000410_1040_101862_GM" for user (4071), 7 Standard Report Row(s) and 0 Product Conversion Report Row(s) processed 2010-05-10 14:58:01.206 (3) [P6T1]: GoogleAdWordsAPI.setSandbox(false) 2010-05-10 14:58:01.244 (3) [P6T2]: GoogleAdWordsAPI.setSandbox(false) 2010-05-10 14:58:01.305 (3) [P6T1]: SESUMM: Handling Account (11781) "0016034650_1000000410_1040_101862_GT" for user (4071) "" 2010-05-10 14:58:01.324 (3) [P6T2]: SESUMM: Handling Account (11841) "0016034650_1000001006_1040_101860_GM" for user (4071) "" 2010-05-10 14:58:01.401 (3) [P6T2]: SESUMM: Completed Account (11841) "0016034650_1000001006_1040_101860_GM" for user (4071), 2 Standard Report Row(s) and 0 Product Conversion Report Row(s) processed 2010-05-10 14:58:01.407 (3) [P6T2]: GoogleAdWordsAPI.setSandbox(false) 2010-05-10 14:58:01.479 (3) [P6T2]: SESUMM: Handling Account (11831) "0016034650_1000000044_1040_101863_GT" for user (4071) "" 2010-05-10 14:58:01.876 (3) [P6T2]: SESUMM: Completed Account (11831) "0016034650_1000000044_1040_101863_GT" for user (4071), 18 Standard Report Row(s) and 0 Product Conversion Report Row(s) processed 2010-05-10 14:58:01.884 (3) [P6T2]: GoogleAdWordsAPI.setSandbox(false) 2010-05-10 14:58:01.953 (3) [P6T2]: SESUMM: Handling Account (11861) "0016034650_1000000049_1040_101861_GM" for user (4071) "" 2010-05-10 14:58:01.981 (3) [P6T3]: SESUMM: Completed Account (11801) "0016034650_1000000049_1040_101861_GT" for user (4071), 37 Standard Report Row(s) and 0 Product Conversion Report Row(s) processed 2010-05-10 14:58:02.060 (3) [P6T2]: SESUMM: Completed Account (11861) "0016034650_1000000049_1040_101861_GM" for user (4071), 1 Standard Report Row(s) and 0 Product Conversion Report Row(s) processed 2010-05-10 14:58:02.535 (3) [P6T1]: SESUMM: Completed Account (11781) "0016034650_1000000410_1040_101862_GT" for user (4071), 72 Standard Report Row(s) and 0 Product Conversion Report Row(s) processed 2010-05-10 14:58:02.536 (3) [P1T1]: After joining threads, calling doPostJoinActions 2010-05-10 14:58:02.536 (3) [P1T1]: =============== Completed Search Engine Summarizer ================ 2010-05-10 14:58:02.536 (3) [P1T1]: Google MCC Report: 51.995s 2010-05-10 14:58:02.536 (3) [P1T1]: by key: 2010-05-10 14:58:02.536 (3) [P1T1]: google: 29.286s 2010-05-10 14:58:02.536 (3) [P1T1]: db: 0.461s 2010-05-10 14:58:02.536 (3) [P1T1]: by thread: 2010-05-10 14:58:02.536 (3) [P1T1]: P2T1: 0.460s 2010-05-10 14:58:02.537 (3) [P1T1]: P1T1: 0.001s 2010-05-10 14:58:02.537 (3) [P1T1]: other: 22.248s 2010-05-10 14:58:02.537 (3) [P1T1]: Rerun WHSUMM for Resolving Discrepancies for date:2010-04-20 2010-05-10 14:58:02.538 (3) [P1T1]: Debug Level set to 3 2010-05-10 14:58:02.538 (2) [P1T1]: No granularity given, all 2010-05-10 14:58:02.538 (3) [P1T1]: =============== Starting Warehouse Summarizer ================ 2010-05-10 14:58:02.538 (3) [P1T1]: ----------------Warehouse Summarizer starting 2010-05-10 14:58:03.880 (3) [P7T1]: DatabasePool with a limit of 80 created 2010-05-10 14:58:05.982 (3) [P7T1]: DatabasePool with a limit of 80 created 2010-05-10 14:58:06.111 (3) [P7T1]: DatabasePool with a limit of 80 created 2010-05-10 14:58:06.125 (3) [P7T1]: Skipping sync of dimensions for acct #3611 (last sync was at 2010-05-10 12:08:41.0) 2010-05-10 14:58:06.126 (3) [P7T1]: Starting daily for Account #3611 qdtest9 for Tue Apr 20 00:00:00 BST 2010 2010-05-10 14:58:06.148 (3) [P7T1]: Processing Search Engine Activity... 2010-05-10 14:58:06.301 (3) [P7T1]: ... done processing Search Engine Activity 2010-05-10 14:58:06.302 (3) [P7T1]: Processing Search Engine Products by Source... 2010-05-10 14:58:06.323 (3) [P7T1]: ...done processing Search Engine Products by Source 2010-05-10 14:58:06.324 (3) [P7T1]: Updating perf rows that don't have a bidTargetID, but should... for Dist(s) (3) 2010-05-10 14:58:06.327 (3) [P7T1]: Updating perf totals... 2010-05-10 14:58:06.333 (3) [P7T1]: Updating conversion totals... 2010-05-10 14:58:06.336 (3) [P7T1]: Finished daily for Account #3611 qdtest9 on Tue Apr 20 00:00:00 BST 2010 2010-05-10 14:58:06.343 (3) [P7T1]: Starting Account #3611 qdtest9 aggregates for Tue Apr 20 00:00:00 BST 2010 to success:true 2010-05-10 14:58:34.307 (3) [P8T1]: Parsing MCC report into staging database... 2010-05-10 14:58:34.307 (3) [P8T1]: DatabasePool with a limit of 3 created 2010-05-10 14:58:34.319 (3) [P8T1]: Finding column names... 2010-05-10 14:58:34.324 (3) [P8T1]: Writing temp infile... 2010-05-10 14:58:34.345 (3) [P8T1]: Deleting existing records where ((`startTime`="2010-04-19 00:00:00")) 2010-05-10 14:58:34.498 (3) [P8T1]: Loading data infile into temp table... 2010-05-10 14:58:34.509 (3) [P8T1]: Inserting into staging database... 2010-05-10 14:58:34.535 (3) [P8T1]: ...done 2010-05-10 14:58:34.536 (3) [P8T1]: === Completed user #4071, === 2010-05-10 14:58:34.537 (3) [P1T1]: ------------Google MCC Report done 2010-05-10 14:58:34.537 (3) [P1T1]: =============== Completed Google MCC Report ================ 2010-05-10 14:58:34.537 (3) [P1T1]: Google MCC Report: 51.995s 2010-05-10 14:58:34.537 (3) [P1T1]: by key: 2010-05-10 14:58:34.537 (3) [P1T1]: google: 29.286s 2010-05-10 14:58:34.537 (3) [P1T1]: db: 0.461s 2010-05-10 14:58:34.537 (3) [P1T1]: by thread: 2010-05-10 14:58:34.537 (3) [P1T1]: P2T1: 0.460s 2010-05-10 14:58:34.537 (3) [P1T1]: P1T1: 0.001s 2010-05-10 14:58:34.537 (3) [P1T1]: other: 22.248s 2010-05-10 14:58:34.538 (3) [P1T1]: Rerun SESUMM for Resolving Discrepancies for date:2010-04-19 2010-05-10 14:58:34.538 (3) [P1T1]: DatabasePool with a limit of 38 created 2010-05-10 14:58:34.552 (3) [P1T1]: SESUMM: Rerunning specified seUsers (4071) or seAccounts ((11871)) 2010-05-10 14:58:34.552 (3) [P1T1]: Debug Level set to 3 2010-05-10 14:58:34.552 (3) [P1T1]: =============== Starting Search Engine Summarizer for Mon Apr 19 00:00:00 BST 2010 ================ 2010-05-10 14:58:34.555 (3) [P9T1]: DatabasePool with a limit of 105 created 2010-05-10 14:58:34.567 (3) [P9T1]: GoogleAdWordsAPI.setSandbox(false) 2010-05-10 14:58:34.591 (3) [P9T1]: DatabasePool with a limit of 105 created 2010-05-10 14:58:34.607 (3) [P9T1]: SESUMM: Handling Account (11871) "0016034650_1000000410_1040_101862_GM" for user (4071) "" 2010-05-10 14:58:34.609 (3) [P9T1]: DatabasePool with a limit of 105 created 2010-05-10 14:58:34.804 (3) [P9T1]: SESUMM: Completed Account (11871) "0016034650_1000000410_1040_101862_GM" for user (4071), 20 Standard Report Row(s) and 0 Product Conversion Report Row(s) processed 2010-05-10 14:58:34.805 (3) [P1T1]: After joining threads, calling doPostJoinActions 2010-05-10 14:58:34.805 (3) [P1T1]: =============== Completed Search Engine Summarizer ================ 2010-05-10 14:58:34.805 (3) [P1T1]: Google MCC Report: 51.995s 2010-05-10 14:58:34.805 (3) [P1T1]: by key: 2010-05-10 14:58:34.805 (3) [P1T1]: google: 29.286s 2010-05-10 14:58:34.805 (3) [P1T1]: db: 0.461s 2010-05-10 14:58:34.805 (3) [P1T1]: by thread: 2010-05-10 14:58:34.805 (3) [P1T1]: P2T1: 0.460s 2010-05-10 14:58:34.805 (3) [P1T1]: P1T1: 0.001s 2010-05-10 14:58:34.806 (3) [P1T1]: other: 22.248s 2010-05-10 14:58:34.806 (3) [P1T1]: Rerun WHSUMM for Resolving Discrepancies for date:2010-04-19 2010-05-10 14:58:34.806 (3) [P1T1]: Debug Level set to 3 2010-05-10 14:58:34.806 (2) [P1T1]: No granularity given, all 2010-05-10 14:58:34.806 (3) [P1T1]: =============== Starting Warehouse Summarizer ================ 2010-05-10 14:58:34.806 (3) [P1T1]: ----------------Warehouse Summarizer starting 2010-05-10 14:58:34.850 (3) [P10T1]: DatabasePool with a limit of 80 created 2010-05-10 14:58:34.865 (3) [P10T1]: DatabasePool with a limit of 80 created 2010-05-10 14:58:34.875 (3) [P10T1]: DatabasePool with a limit of 80 created 2010-05-10 14:58:34.887 (3) [P10T1]: Skipping sync of dimensions for acct #3611 (last sync was at 2010-05-10 12:08:41.0) 2010-05-10 14:58:34.888 (3) [P10T1]: Starting daily for Account #3611 qdtest9 for Mon Apr 19 00:00:00 BST 2010 2010-05-10 14:58:34.901 (3) [P10T1]: Processing Search Engine Activity... 2010-05-10 14:58:35.082 (3) [P10T1]: ... done processing Search Engine Activity 2010-05-10 14:58:35.082 (3) [P10T1]: Processing Search Engine Products by Source... 2010-05-10 14:58:35.098 (3) [P10T1]: ...done processing Search Engine Products by Source 2010-05-10 14:58:35.099 (3) [P10T1]: Updating perf rows that don't have a bidTargetID, but should... for Dist(s) (3) 2010-05-10 14:58:35.102 (3) [P10T1]: Updating perf totals... 2010-05-10 14:58:35.107 (3) [P10T1]: Updating conversion totals... 2010-05-10 14:58:35.109 (3) [P10T1]: Finished daily for Account #3611 qdtest9 on Mon Apr 19 00:00:00 BST 2010 2010-05-10 14:58:35.121 (3) [P10T1]: Starting Account #3611 qdtest9 aggregates for Mon Apr 19 00:00:00 BST 2010 to