TSA_Pixel_Tracking: Mysql exception [: Exception [Account #17 Catch All ]:com.mysql.jdbc.exceptions.MySQLSyntaxErrorException:]while running v2whsumm for an account for which publisher feed is upload and processed with particluar day.

Mysql exception [: Exception Account #17 Catch All:com.mysql.jdbc.exceptions.MySQLSyntaxErrorException:] while running v2whsumm for an account having uploaded publisher feed with particular day.

Steps followed:

1)INSERT INTO `accountDistributionMap`(`accountID`,`distributionID`,`status`,`configFile`) VALUES (541,177,'ACTIVE','x'); to database staging-db5.tsacommon

2)Now upload the publisher feed (541_177_20110505.csv)** for TSA-martian tourism. ** attached

3) On staging-xml01 . keychain ~/.ssh/id_rsa_new_filepush ; /opt/publishers-filepull.sh which moves publisher feed from client-st

staging-xml01 - /var/local/tsa/publisherfeedConfig

4)Then run ./load-publisher.sh -d3 -F -XN TSA_Martain-T_Facebook.xml -XL /var/local/tsa/publisherfeedConfig/ 2>&1|tee /tmp/publisher_tsa.log

5)Generate the report R318-412 **attached

6)Now place pixel log** of the same day i.e. 2011-05-05 on staging-xml1 directory :/usr/local/share/tsa/logs/spike-v2/working/ ** Pixel log attached

7) Run ./v2pixel_playback.sh -d 3 -a 541 2>&1| tee /tmp/publisher_Pixel_1.log

8).Run ./lastpaidhitsummarizer.sh -a 541 -d3 -T 2011-05-05

9) Run ./v2whsumm.sh --pixels --highgran -a 541 -d 3 -T 2011-05-05 -dsrt 10 2>&1| tee /tmp/PublisherfeedandPixellog.log ****Attached

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)