GoogleV2011_API_Upgrade:Running of sedatacheck script results in throwing - MySQLIntegrityConstraintViolationException: Duplicate entry '0000-00-00' exception.

Running of sedatacheck script results in throwing - MySQLIntegrityConstraintViolationException: Duplicate entry '0000-00-00' exception.

tsaapp@tvvm-staging-xml1:/usr/local/tsa/bidmgr$ ./sedatacheck.sh -d3 -T2011-05-15 -U739 --daily --force 2>&1 | tee /tmp/sedatacheck.log

.

.

.

2011-06-27 03:45:01.239 (3) [P2T1]: Inserting into staging database...

2011-06-27 03:45:01.371 (1) [P2T1]: Exception [ Error parsing /var/local/tsa/sedata/google/tsa-check-report-daily-2011-05-15-U739.xml.gz]:com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException: Duplicate entry '0000-00-00' for key 1

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:931)

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:1737)

at com.thesearchagency.searchengines.google.GoogleAPISearchEngine.runDataCheck(GoogleAPISearchEngine.java:1485)

at com.thesearchagency.searchengines.SearchEngineDataChecker$DistributionWorker$SearchEngineUserWorker.run(SearchEngineDataChecker.java:421)

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)

I copied temporary file

{/tmp/go2011-05-1548344.tmp}

which was created;

pradeep.nair@tvvm-staging-xml1:~$ cp /tmp/go2011-05-1523721.tmp /tmp/test.tmp

Find the test.tmp as attached.