2011-05-13 07:18:24.568 (3) [main]: Debug Level set to 3
2011-05-13 07:18:24.653 (3) [main]: =============== Starting Warehouse Summarizer ================
2011-05-13 07:18:24.661 (3) [main]: ----------------Warehouse Summarizer starting
2011-05-13 07:18:28.386 (3) [P1T1]: DatabasePool with a limit of 80 created
2011-05-13 07:18:30.849 (3) [P1T1]: DatabasePool with a limit of 80 created
2011-05-13 07:18:32.187 (3) [P1T1]: DatabasePool with a limit of 80 created
2011-05-13 07:18:32.675 (3) [P1T1]: Syncing searchEngineListings...
2011-05-13 07:18:33.087 (3) [P1T1]: Syncing 11 rows in accountChannelMap...
2011-05-13 07:18:33.115 (3) [P1T1]: Syncing 0 to 10000 of 11
2011-05-13 07:18:33.301 (3) [P1T1]: Syncing 6 rows in campaigns...
2011-05-13 07:18:33.312 (3) [P1T1]: Syncing 0 to 10000 of 6
2011-05-13 07:18:33.381 (3) [P1T1]: Syncing 14 rows in products...
2011-05-13 07:18:33.396 (3) [P1T1]: Syncing 0 to 10000 of 14
2011-05-13 07:18:33.793 (3) [P1T1]: Syncing 1 rows in searchEngineConversionTypeProductMap...
2011-05-13 07:18:33.804 (3) [P1T1]: Syncing 0 to 10000 of 1
2011-05-13 07:18:33.833 (3) [P1T1]: Syncing 0 rows in searchEngineGroups...
2011-05-13 07:18:33.860 (3) [P1T1]: Starting daily for Account #541 TSA - Martian Tourism for Thu May 05 00:00:00 PDT 2011
2011-05-13 07:18:34.216 (3) [P1T1]: (not) Processing Pixel Impressions by Source...
2011-05-13 07:18:34.216 (3) [P1T1]: ... done (not) processing Pixel Impressions by Source...
2011-05-13 07:18:34.217 (3) [P1T1]: Processing Pixel Clicks by Source...
2011-05-13 07:18:34.633 (3) [P1T1]: ... done processing Pixel Clicks by Source...
2011-05-13 07:18:34.633 (3) [P1T1]: Processing Pixel Conversions by Source...
2011-05-13 07:18:34.957 (3) [P1T1]: ...done processing Pixel Conversions by Source
2011-05-13 07:18:34.957 (3) [P1T1]: Updating perf rows that don't have a bidTargetID, but should...
2011-05-13 07:18:34.995 (3) [P1T1]: Updating perf totals...
2011-05-13 07:18:35.097 (1) [P1T1]: Exception [Account #541 Catch All ]:com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '"177")))), `whDailySourcePerf`.`seAdCost`, `whDailySourcePerf`.`pixAdCost`),`cli' at line 1
	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.Statement.executeUpdate(Statement.java:1316)
	at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1235)
	at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1388)
	at com.carldunham.jst.db.Database.executeUpdate(Database.java:401)
	at com.carldunham.jst.db.JoinTable.update(JoinTable.java:324)
	at com.carldunham.jst.db.JoinTable.update(JoinTable.java:305)
	at com.thesearchagency.perf.V2WarehouseSummarizer$AccountWorker.setTotals(V2WarehouseSummarizer.java:2543)
	at com.thesearchagency.perf.V2WarehouseSummarizer$AccountWorker.run(V2WarehouseSummarizer.java:660)
	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-05-13 07:18:35.106 (2) [P1T1]: Warning(s) detected in statement [SELECT RELEASE_LOCK('WarehouseSummarizer.summarize.541')] executed by user [perfsum]
2011-05-13 07:18:35.125 (2) [P1T1]: SQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '"177")))), `whDailySourcePerf`.`seAdCost`, `whDailySourcePerf`.`pixAdCost`),`cli' at line 1 (code:1064)
2011-05-13 07:18:35.132 (3) [main]: ------------Warehouse Summarizer done
2011-05-13 07:18:35.132 (3) [main]: =============== Completed Warehouse Summarizer ================