tsaapp@tvvm-staging-xml1:/usr/local/tsa/bidmgr$ ./googlemcc.sh -d3 -T2011-06-22 -U8
2011-06-28 12:10:42.331 (3) [main]: Debug Level set to 3
2011-06-28 12:10:42.388 (3) [main]: =============== Starting Google MCC Report ================
2011-06-28 12:10:42.391 (3) [main]: ----------------Google MCC Report starting
2011-06-28 12:10:45.804 (3) [P1T1]: === Starting user #8, WWMW - Cellular Safety Commission ===
2011-06-28 12:10:45.816 (3) [P1T1]: Using filename: /var/local/tsa/sedata/google/tsa-mcc-report-2011-06-22-U8.xml.gz
2011-06-28 12:10:48.157 (3) [P1T1]: Created shared sesystem connection rw
2011-06-28 12:10:56.480 (3) [P1T1]: Local copy of report found, skipping download...
2011-06-28 12:10:56.481 (3) [P1T1]: Parsing MCC report into staging database...
2011-06-28 12:10:56.589 (3) [P1T1]: DatabasePool with a limit of 3 created
2011-06-28 12:10:56.877 (3) [P1T1]:   Finding column names...
2011-06-28 12:10:56.910 (3) [P1T1]:   Writing temp infile...
2011-06-28 12:10:56.921 (2) [P1T1]:  Adding Campaign: 35709401
2011-06-28 12:10:57.804 (2) [P1T1]:  Adding Campaign: 31372391
2011-06-28 12:10:57.816 (3) [P1T1]:   Deleting existing records where ((`startTime`="2011-06-22 00:00:00"))
2011-06-28 12:10:57.828 (3) [P1T1]:   Loading data infile into temp table...
2011-06-28 12:10:57.879 (1) [P1T1]: Exception [  Error parsing /var/local/tsa/sedata/google/tsa-mcc-report-2011-06-22-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:1701)
        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-28 12:10:57.881 (3) [P1T1]: ...done
2011-06-28 12:10:57.884 (3) [P1T1]: === Completed user #8, WWMW - Cellular Safety Commission ===
2011-06-28 12:10:57.888 (3) [main]: ------------Google MCC Report done
2011-06-28 12:10:57.888 (3) [main]: =============== Completed Google MCC Report ================
2011-06-28 12:10:57.896 (3) [main]: Google MCC Report:  15.504s
2011-06-28 12:10:57.897 (3) [main]:     by key:
2011-06-28 12:10:57.900 (3) [main]:         db: 0.217s
2011-06-28 12:10:57.900 (3) [main]:             by thread:
2011-06-28 12:10:57.900 (3) [main]:                 main:       0.125s
2011-06-28 12:10:57.904 (3) [main]:                 P1T1:       0.092s
2011-06-28 12:10:57.904 (3) [main]:         other:      15.287s