TSA_Pixel_Tracking: For Conversion scenario 3** > Mysql exception -Exception [Account #17 Catch All ]:com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: ...

For Conversion scenario 3** > Mysql exception -Exception Account #17 Catch All:com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: ...

***1)Entry on Organic Link (LP Hit Window Unlimited)

2)Close Session (by clearing ONLY the session cookie, not the visitor cookie or by waiting

4 hours for the session cookie to expire)

3)Re-enter on Paid Search Link

4)Close Session

5)Re-enter on Type In

6)Convert

7))Pixel log file is generated on Pixel server, now Pixelsync ***Log file is attached

8)Run Pixel playback

./v2pixel_playback.sh -d 3 -a 17 2>&1| tee /tmp/pixelplayback_Conv003_12May.log **** attached

9)./lastpaidhitsummarizer.sh -a 17 -d3 -T 2011-01-15

6)./v2whsumm.sh --pixels --highgran -a 17 -d 3 -T 2011-01-15

tsaapp@tvvm-staging-xml1:/usr/local/tsa/bidmgr$ ./v2whsumm.sh --pixels --highgran -a 17 -d 3 -T 2011-01-15

2011-05-12 02:15:22.446 (3) [main]: Debug Level set to 3

2011-05-12 02:15:22.482 (3) [main]: =============== Starting Warehouse Summarizer ================

2011-05-12 02:15:22.484 (3) [main]: ----------------Warehouse Summarizer starting

2011-05-12 02:15:24.631 (3) [P1T1]: DatabasePool with a limit of 80 created

2011-05-12 02:15:25.263 (3) [P1T1]: DatabasePool with a limit of 80 created

2011-05-12 02:15:25.771 (3) [P1T1]: DatabasePool with a limit of 80 created

2011-05-12 02:15:26.231 (3) [P1T1]: Skipping sync of dimensions for acct #17 (last sync was at 2011-05-12 01:39:30.0)

2011-05-12 02:15:26.251 (3) [P1T1]: Starting daily for Account #17 WWMW - Cellular Safety Commission for Sat Jan 15 00:00:00 PST 2011

2011-05-12 02:15:26.999 (3) [P1T1]: (not) Processing Pixel Impressions by Source...

2011-05-12 02:15:27.001 (3) [P1T1]: ... done (not) processing Pixel Impressions by Source...

2011-05-12 02:15:27.001 (3) [P1T1]: Processing Pixel Clicks by Source...

2011-05-12 02:15:27.476 (3) [P1T1]: ... done processing Pixel Clicks by Source...

2011-05-12 02:15:27.476 (3) [P1T1]: Processing Pixel Conversions by Source...

2011-05-12 02:15:28.711 (3) [P1T1]: ...done processing Pixel Conversions by Source

2011-05-12 02:15:28.713 (3) [P1T1]: Updating perf rows that don't have a bidTargetID, but should...

2011-05-12 02:15:28.753 (3) [P1T1]: Updating perf totals...

2011-05-12 02:15:29.209 (1) [P1T1]: Exception Account #17 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,177")))), `whDailySourcePerf`.`seAdCost`, `whDailySourcePerf`.`pixAdCost`),' 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)