2011-06-27 00:59:55.848 (3) [main]: Debug Level set to 3 2011-06-27 00:59:55.900 (3) [main]: =============== Starting Google MCC Report ================ 2011-06-27 00:59:55.902 (3) [main]: ----------------Google MCC Report starting 2011-06-27 00:59:58.489 (3) [P1T1]: === Starting user #8, WWMW - Cellular Safety Commission === 2011-06-27 00:59:58.494 (3) [P1T1]: Using filename: /var/local/tsa/sedata/google/tsa-mcc-report-2011-06-28-U8.xml.gz 2011-06-27 01:00:00.109 (3) [P1T1]: Created shared sesystem connection rw 2011-06-27 01:00:07.001 (3) [P1T1]: Downloading MCC report... 2011-06-27 01:00:07.017 (3) [P1T1]: Scheduling report attempt 1: name=tsamccreport_2011-06-28_otto@worldwidemediaworks.com_31 with id=null 2011-06-27 01:00:07.029 (3) [P1T1]: validating report job... 2011-06-27 01:00:12.673 (3) [P1T1]: ...success 2011-06-27 01:00:14.943 (3) [P1T1]: Scheduled report. Report Job ID = 1641453731 2011-06-27 01:00:58.491 (3) [main]: Waiting for tasks to be done 2011-06-27 01:09:05.779 (3) [P1T1]: Downloading report attempt 1: name=/var/local/tsa/sedata/google/tsa-mcc-report-2011-06-28-U8.xml.gz with id=1641453731 from url https://adwords.google.com/api/adwords/ReportDownload?t=AAAAAGHWmKMAAAEw9LAC_QEAAAAB65l4V7I68exyyRG8D0rxz5Tcure69NNJ 2011-06-27 01:09:06.429 (3) [P1T1]: Connected to URL "https://adwords.google.com/api/adwords/ReportDownload?t=AAAAAGHWmKMAAAEw9LAC_QEAAAAB65l4V7I68exyyRG8D0rxz5Tcure69NNJ" 2011-06-27 01:09:08.393 (3) [P1T1]: MCC report download (Tue Jun 28 00:00:00 PDT 2011, "/var/local/tsa/sedata/google/tsa-mcc-report-2011-06-28-U8.xml.gz") -> success:true 2011-06-27 01:09:08.395 (3) [P1T1]: Parsing MCC report into staging database... 2011-06-27 01:09:08.617 (3) [P1T1]: DatabasePool with a limit of 3 created 2011-06-27 01:09:09.008 (3) [P1T1]: Finding column names... 2011-06-27 01:09:09.008 (3) [P1T1]: Report saving to /tmp/go2011-06-2836320.tmp 2011-06-27 01:09:09.011 (2) [P1T1]: campaignid 2011-06-27 01:09:09.012 (2) [P1T1]: adgroupid 2011-06-27 01:09:09.013 (2) [P1T1]: keywordid 2011-06-27 01:09:09.013 (2) [P1T1]: kwSite 2011-06-27 01:09:09.013 (2) [P1T1]: kwSiteType 2011-06-27 01:09:09.013 (2) [P1T1]: firstPageCpc 2011-06-27 01:09:09.013 (2) [P1T1]: qualityScore 2011-06-27 01:09:09.013 (2) [P1T1]: creativeid 2011-06-27 01:09:09.013 (2) [P1T1]: adwordsType 2011-06-27 01:09:09.013 (2) [P1T1]: maxCpc 2011-06-27 01:09:09.013 (2) [P1T1]: maxCpm 2011-06-27 01:09:09.016 (2) [P1T1]: kwDestUrl 2011-06-27 01:09:09.016 (2) [P1T1]: imps 2011-06-27 01:09:09.017 (2) [P1T1]: clicks 2011-06-27 01:09:09.017 (2) [P1T1]: cost 2011-06-27 01:09:09.017 (2) [P1T1]: pos 2011-06-27 01:09:09.017 (2) [P1T1]: conv 2011-06-27 01:09:09.020 (2) [P1T1]: transactions 2011-06-27 01:09:09.020 (2) [P1T1]: purchases 2011-06-27 01:09:09.020 (2) [P1T1]: purchaseValue 2011-06-27 01:09:09.020 (2) [P1T1]: leads 2011-06-27 01:09:09.020 (2) [P1T1]: leadValue 2011-06-27 01:09:09.020 (2) [P1T1]: signups 2011-06-27 01:09:09.021 (2) [P1T1]: signupValue 2011-06-27 01:09:09.021 (2) [P1T1]: pageviews 2011-06-27 01:09:09.021 (2) [P1T1]: pageviewValue 2011-06-27 01:09:09.023 (2) [P1T1]: defaultConv 2011-06-27 01:09:09.023 (2) [P1T1]: defaultConvValue 2011-06-27 01:09:09.032 (3) [P1T1]: Writing temp infile... 2011-06-27 01:09:09.229 (3) [P1T1]: Deleting existing records where ((`startTime`="2011-06-28 00:00:00")) 2011-06-27 01:09:09.251 (3) [P1T1]: Loading data infile into temp table... 2011-06-27 01:09:09.275 (2) [P1T1]: campaignid 2011-06-27 01:09:09.275 (2) [P1T1]: adgroupid 2011-06-27 01:09:09.275 (2) [P1T1]: keywordid 2011-06-27 01:09:09.275 (2) [P1T1]: kwSite 2011-06-27 01:09:09.275 (2) [P1T1]: kwSiteType 2011-06-27 01:09:09.276 (2) [P1T1]: firstPageCpc 2011-06-27 01:09:09.276 (2) [P1T1]: qualityScore 2011-06-27 01:09:09.276 (2) [P1T1]: creativeid 2011-06-27 01:09:09.277 (2) [P1T1]: adwordsType 2011-06-27 01:09:09.277 (2) [P1T1]: maxCpc 2011-06-27 01:09:09.277 (2) [P1T1]: maxCpm 2011-06-27 01:09:09.277 (2) [P1T1]: kwDestUrl 2011-06-27 01:09:09.277 (2) [P1T1]: imps 2011-06-27 01:09:09.277 (2) [P1T1]: clicks 2011-06-27 01:09:09.277 (2) [P1T1]: cost 2011-06-27 01:09:09.277 (2) [P1T1]: pos 2011-06-27 01:09:09.277 (2) [P1T1]: conv 2011-06-27 01:09:09.280 (2) [P1T1]: transactions 2011-06-27 01:09:09.280 (2) [P1T1]: purchases 2011-06-27 01:09:09.280 (2) [P1T1]: purchaseValue 2011-06-27 01:09:09.280 (2) [P1T1]: leads 2011-06-27 01:09:09.280 (2) [P1T1]: leadValue 2011-06-27 01:09:09.280 (2) [P1T1]: signups 2011-06-27 01:09:09.280 (2) [P1T1]: signupValue 2011-06-27 01:09:09.281 (2) [P1T1]: pageviews 2011-06-27 01:09:09.281 (2) [P1T1]: pageviewValue 2011-06-27 01:09:09.281 (2) [P1T1]: defaultConv 2011-06-27 01:09:09.284 (2) [P1T1]: defaultConvValue 2011-06-27 01:09:09.289 (1) [P1T1]: Exception [ Error parsing /var/local/tsa/sedata/google/tsa-mcc-report-2011-06-28-U8.xml.gz]:com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column 'keyword' in 'field list' at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665) at com.mysql.jdbc.Connection.execSQL(Connection.java:3170) at com.mysql.jdbc.Connection.execSQL(Connection.java:3099) at com.mysql.jdbc.Statement.execute(Statement.java:695) at com.carldunham.jst.db.Database.execute(Database.java:274) at com.thesearchagency.searchengines.google.GoogleAPISearchEngine.parseReport(GoogleAPISearchEngine.java:1714) at com.thesearchagency.searchengines.google.GoogleAPISearchEngine.parseReport(GoogleAPISearchEngine.java:1545) at com.thesearchagency.searchengines.google.GoogleMCCReport$SearchEngineUserWorker.run(GoogleMCCReport.java:512) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269) at java.util.concurrent.FutureTask.run(FutureTask.java:123) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at java.lang.Thread.run(Thread.java:595) 2011-06-27 01:09:09.289 (3) [P1T1]: ...done 2011-06-27 01:09:09.292 (3) [P1T1]: === Completed user #8, WWMW - Cellular Safety Commission === 2011-06-27 01:09:18.595 (3) [main]: ------------Google MCC Report done 2011-06-27 01:09:18.607 (3) [main]: =============== Completed Google MCC Report ================ 2011-06-27 01:09:18.616 (3) [main]: Google MCC Report: 9m 22.713s 2011-06-27 01:09:18.618 (3) [main]: by key: 2011-06-27 01:09:18.618 (3) [main]: google: 25.161s 2011-06-27 01:09:18.618 (3) [main]: db: 2.789s 2011-06-27 01:09:18.619 (3) [main]: by thread: 2011-06-27 01:09:18.619 (3) [main]: main: 0.287s 2011-06-27 01:09:18.620 (3) [main]: P1T1: 2.502s 2011-06-27 01:09:18.620 (3) [main]: other: 8m 54.763s