2011-06-14 00:08:07.695 (3) [main]: Debug Level set to 3 2011-06-14 00:08:07.762 (3) [main]: Listings flag set, implying groups flag as well. 2011-06-14 00:08:07.799 (3) [main]: DatabasePool with a limit of 80 created 2011-06-14 00:08:09.247 (3) [main]: getSEUserIDs distID=3, seUserID=null, accounts=(17) returned 8,965,1525,3201 2011-06-14 00:08:09.313 (3) [main]: =============== Starting Search Engine Updater ================ 2011-06-14 00:08:09.317 (3) [main]: ----------------Search Engine Updater starting 2011-06-14 00:08:10.475 (3) [main]: Passed null searchEngineUser, connecting user TSA master username/password 2011-06-14 00:08:10.775 (3) [main]: No licensing config file found, assuming TSA production environment 2011-06-14 00:08:11.564 (3) [main]: Created shared sesystem connection rw log4j:WARN No appenders could be found for logger (org.apache.axis.AxisEngine). log4j:WARN Please initialize the log4j system properly. 2011-06-14 00:08:16.016 (3) [P1T1]: Starting com.thesearchagency.searchengines.google.GoogleAPISearchEngine 2011-06-14 00:09:17.665 (3) [main]: Waiting for tasks to be done 2011-06-14 00:09:27.856 (3) [P1T1]: isExpired(): Unexpected null value for lastInMcc - unknown date, assuming not expired 2011-06-14 00:09:27.858 (3) [P1T1]: SEUser #88 is missing from MCC but has not expired. 2011-06-14 00:09:27.984 (3) [P1T1]: seUser 244 is already disabled 2011-06-14 00:09:28.070 (3) [P1T1]: seUser 298 is already disabled 2011-06-14 00:09:28.432 (3) [P1T1]: isExpired(): Unexpected null value for lastInMcc - unknown date, assuming not expired 2011-06-14 00:09:28.434 (3) [P1T1]: SEUser #409 is missing from MCC but has not expired. 2011-06-14 00:09:28.602 (3) [P1T1]: isExpired(): Unexpected null value for lastInMcc - unknown date, assuming not expired 2011-06-14 00:09:28.603 (3) [P1T1]: SEUser #587 is missing from MCC but has not expired. 2011-06-14 00:09:28.746 (3) [P1T1]: isExpired(): Unexpected null value for lastInMcc - unknown date, assuming not expired 2011-06-14 00:09:28.750 (3) [P1T1]: SEUser #410 is missing from MCC but has not expired. 2011-06-14 00:09:28.872 (3) [P1T1]: seUser 147 is already disabled 2011-06-14 00:09:29.794 (3) [P1T1]: isExpired(): Unexpected null value for lastInMcc - unknown date, assuming not expired 2011-06-14 00:09:29.794 (3) [P1T1]: SEUser #75 is missing from MCC but has not expired. 2011-06-14 00:09:30.330 (3) [P1T1]: isExpired(): Unexpected null value for lastInMcc - unknown date, assuming not expired 2011-06-14 00:09:30.331 (3) [P1T1]: SEUser #480 is missing from MCC but has not expired. 2011-06-14 00:09:30.356 (3) [P1T1]: isExpired(): Unexpected null value for lastInMcc - unknown date, assuming not expired 2011-06-14 00:09:30.358 (3) [P1T1]: SEUser #55 is missing from MCC but has not expired. 2011-06-14 00:09:31.928 (3) [P1T1]: seUser 107 is already disabled 2011-06-14 00:09:32.225 (3) [P1T1]: isExpired(): Unexpected null value for lastInMcc - unknown date, assuming not expired 2011-06-14 00:09:32.229 (3) [P1T1]: SEUser #447 is missing from MCC but has not expired. 2011-06-14 00:09:32.531 (3) [P1T1]: seUser 512 is already disabled 2011-06-14 00:09:32.538 (3) [P1T1]: isExpired(): Unexpected null value for lastInMcc - unknown date, assuming not expired 2011-06-14 00:09:32.539 (3) [P1T1]: SEUser #645 is missing from MCC but has not expired. 2011-06-14 00:09:32.566 (3) [P1T1]: isExpired(): Unexpected null value for lastInMcc - unknown date, assuming not expired 2011-06-14 00:09:32.566 (3) [P1T1]: SEUser #646 is missing from MCC but has not expired. 2011-06-14 00:09:32.731 (3) [P1T1]: isExpired(): Unexpected null value for lastInMcc - unknown date, assuming not expired 2011-06-14 00:09:32.731 (3) [P1T1]: SEUser #598 is missing from MCC but has not expired. 2011-06-14 00:09:32.914 (3) [P1T1]: isExpired(): Unexpected null value for lastInMcc - unknown date, assuming not expired 2011-06-14 00:09:32.914 (3) [P1T1]: SEUser #225 is missing from MCC but has not expired. 2011-06-14 00:09:32.968 (3) [P1T1]: seUser 397 is already disabled 2011-06-14 00:09:33.091 (3) [P1T1]: isExpired(): Unexpected null value for lastInMcc - unknown date, assuming not expired 2011-06-14 00:09:33.095 (3) [P1T1]: SEUser #404 is missing from MCC but has not expired. 2011-06-14 00:09:33.378 (3) [P1T1]: Search Engine Login google8@1800dentist.com no longer in MCC and has no seaccts; deleting 2011-06-14 00:09:33.504 (3) [P1T1]: isExpired(): Unexpected null value for lastInMcc - unknown date, assuming not expired 2011-06-14 00:09:33.504 (3) [P1T1]: SEUser #411 is missing from MCC but has not expired. 2011-06-14 00:09:34.138 (3) [P1T1]: isExpired(): Unexpected null value for lastInMcc - unknown date, assuming not expired 2011-06-14 00:09:34.140 (3) [P1T1]: SEUser #417 is missing from MCC but has not expired. 2011-06-14 00:09:34.176 (3) [P1T1]: seUser 89 is already disabled 2011-06-14 00:09:34.398 (3) [P1T1]: seUser 395 is already disabled 2011-06-14 00:09:34.488 (3) [P1T1]: isExpired(): Unexpected null value for lastInMcc - unknown date, assuming not expired 2011-06-14 00:09:34.488 (3) [P1T1]: SEUser #650 is missing from MCC but has not expired. 2011-06-14 00:09:34.513 (3) [P1T1]: seUser 412 is already disabled 2011-06-14 00:09:34.672 (3) [P1T1]: seUser 399 is already disabled 2011-06-14 00:09:34.828 (3) [P1T1]: isExpired(): Unexpected null value for lastInMcc - unknown date, assuming not expired 2011-06-14 00:09:34.828 (3) [P1T1]: SEUser #403 is missing from MCC but has not expired. 2011-06-14 00:09:34.909 (3) [P1T1]: isExpired(): Unexpected null value for lastInMcc - unknown date, assuming not expired 2011-06-14 00:09:34.910 (3) [P1T1]: SEUser #472 is missing from MCC but has not expired. 2011-06-14 00:09:35.328 (3) [P1T1]: seUser 396 is already disabled 2011-06-14 00:09:35.521 (3) [P1T1]: seUser 384 is already disabled 2011-06-14 00:09:35.557 (3) [P1T1]: isExpired(): Unexpected null value for lastInMcc - unknown date, assuming not expired 2011-06-14 00:09:35.557 (3) [P1T1]: SEUser #430 is missing from MCC but has not expired. 2011-06-14 00:09:35.833 (3) [P1T1]: isExpired(): Unexpected null value for lastInMcc - unknown date, assuming not expired 2011-06-14 00:09:35.833 (3) [P1T1]: SEUser #505 is missing from MCC but has not expired. 2011-06-14 00:09:36.256 (3) [P1T1]: Search Engine Login JRobertsMCC@teleflora.com no longer in MCC and has no seaccts; deleting 2011-06-14 00:09:36.577 (3) [P1T1]: seUser 270 is already disabled 2011-06-14 00:09:36.601 (3) [P1T1]: isExpired(): Unexpected null value for lastInMcc - unknown date, assuming not expired 2011-06-14 00:09:36.601 (3) [P1T1]: SEUser #442 is missing from MCC but has not expired. 2011-06-14 00:09:36.713 (3) [P1T1]: isExpired(): Unexpected null value for lastInMcc - unknown date, assuming not expired 2011-06-14 00:09:36.713 (3) [P1T1]: SEUser #570 is missing from MCC but has not expired. 2011-06-14 00:09:36.772 (3) [P1T1]: isExpired(): Unexpected null value for lastInMcc - unknown date, assuming not expired 2011-06-14 00:09:36.773 (3) [P1T1]: SEUser #433 is missing from MCC but has not expired. 2011-06-14 00:09:36.805 (3) [P1T1]: isExpired(): Unexpected null value for lastInMcc - unknown date, assuming not expired 2011-06-14 00:09:36.806 (3) [P1T1]: SEUser #413 is missing from MCC but has not expired. 2011-06-14 00:09:37.048 (3) [P1T1]: seUser 444 is already disabled 2011-06-14 00:09:37.488 (3) [P1T1]: seUser 373 is already disabled 2011-06-14 00:09:37.541 (3) [P1T1]: isExpired(): Unexpected null value for lastInMcc - unknown date, assuming not expired 2011-06-14 00:09:37.541 (3) [P1T1]: SEUser #632 is missing from MCC but has not expired. 2011-06-14 00:09:37.613 (3) [P1T1]: isExpired(): Unexpected null value for lastInMcc - unknown date, assuming not expired 2011-06-14 00:09:37.617 (3) [P1T1]: SEUser #382 is missing from MCC but has not expired. 2011-06-14 00:09:37.637 (3) [P1T1]: seUser 477 is already disabled 2011-06-14 00:09:37.813 (3) [P1T1]: isExpired(): Unexpected null value for lastInMcc - unknown date, assuming not expired 2011-06-14 00:09:37.817 (3) [P1T1]: SEUser #525 is missing from MCC but has not expired. 2011-06-14 00:09:38.265 (3) [P1T1]: isExpired(): Unexpected null value for lastInMcc - unknown date, assuming not expired 2011-06-14 00:09:38.265 (3) [P1T1]: SEUser #665 is missing from MCC but has not expired. 2011-06-14 00:09:38.521 (3) [P1T1]: isExpired(): Unexpected null value for lastInMcc - unknown date, assuming not expired 2011-06-14 00:09:38.521 (3) [P1T1]: SEUser #441 is missing from MCC but has not expired. 2011-06-14 00:09:38.809 (3) [P1T1]: isExpired(): Unexpected null value for lastInMcc - unknown date, assuming not expired 2011-06-14 00:09:38.809 (3) [P1T1]: SEUser #578 is missing from MCC but has not expired. 2011-06-14 00:09:38.845 (3) [P1T1]: isExpired(): Unexpected null value for lastInMcc - unknown date, assuming not expired 2011-06-14 00:09:38.845 (3) [P1T1]: SEUser #617 is missing from MCC but has not expired. 2011-06-14 00:09:38.918 (3) [P1T1]: isExpired(): Unexpected null value for lastInMcc - unknown date, assuming not expired 2011-06-14 00:09:38.918 (3) [P1T1]: SEUser #408 is missing from MCC but has not expired. 2011-06-14 00:09:39.185 (3) [P1T1]: seUser 1525 is already disabled 2011-06-14 00:09:39.201 (3) [P1T1]: isExpired(): Unexpected null value for lastInMcc - unknown date, assuming not expired 2011-06-14 00:09:39.201 (3) [P1T1]: SEUser #459 is missing from MCC but has not expired. 2011-06-14 00:09:39.473 (3) [P1T1]: seUser 398 is already disabled 2011-06-14 00:09:39.561 (3) [P1T1]: seUser 273 is already disabled 2011-06-14 00:09:39.605 (3) [P1T1]: isExpired(): Unexpected null value for lastInMcc - unknown date, assuming not expired 2011-06-14 00:09:39.605 (3) [P1T1]: SEUser #649 is missing from MCC but has not expired. 2011-06-14 00:09:39.661 (3) [P1T1]: isExpired(): Unexpected null value for lastInMcc - unknown date, assuming not expired 2011-06-14 00:09:39.661 (3) [P1T1]: SEUser #614 is missing from MCC but has not expired. 2011-06-14 00:09:39.781 (3) [P1T1]: isExpired(): Unexpected null value for lastInMcc - unknown date, assuming not expired 2011-06-14 00:09:39.781 (3) [P1T1]: SEUser #507 is missing from MCC but has not expired. 2011-06-14 00:09:39.840 (3) [P1T1]: isExpired(): Unexpected null value for lastInMcc - unknown date, assuming not expired 2011-06-14 00:09:39.841 (3) [P1T1]: SEUser #228 is missing from MCC but has not expired. 2011-06-14 00:09:40.077 (3) [P1T1]: isExpired(): Unexpected null value for lastInMcc - unknown date, assuming not expired 2011-06-14 00:09:40.077 (3) [P1T1]: SEUser #616 is missing from MCC but has not expired. 2011-06-14 00:09:40.526 (1) [P1T1]: Exception [Error saving record]:com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException: Duplicate entry '3-' for key 2 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.Statement.executeUpdate(Statement.java:1316) at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1235) at com.carldunham.jst.db.Database.executeUpdate(Database.java:401) at com.carldunham.jst.db.BaseDatabaseTable.insert(BaseDatabaseTable.java:345) at com.carldunham.jst.db.BaseDatabaseTableRow.save(BaseDatabaseTableRow.java:490) at com.carldunham.jst.db.BaseDatabaseTableRow.save(BaseDatabaseTableRow.java:424) at com.thesearchagency.searchengines.SearchEngineUpdater$DistributionWorker.syncUsers(SearchEngineUpdater.java:1014) at com.thesearchagency.searchengines.SearchEngineUpdater$DistributionWorker.run(SearchEngineUpdater.java:722) 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-14 00:09:41.172 (1) [P1T1]: Exception [Error saving record]:com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException: Duplicate entry '3-' for key 2 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.Statement.executeUpdate(Statement.java:1316) at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1235) at com.carldunham.jst.db.Database.executeUpdate(Database.java:401) at com.carldunham.jst.db.BaseDatabaseTable.insert(BaseDatabaseTable.java:345) at com.carldunham.jst.db.BaseDatabaseTableRow.save(BaseDatabaseTableRow.java:490) at com.carldunham.jst.db.BaseDatabaseTableRow.save(BaseDatabaseTableRow.java:424) at com.thesearchagency.searchengines.SearchEngineUpdater$DistributionWorker.syncUsers(SearchEngineUpdater.java:1014) at com.thesearchagency.searchengines.SearchEngineUpdater$DistributionWorker.run(SearchEngineUpdater.java:722) 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-14 00:09:41.512 (1) [P1T1]: Exception [Error saving record]:com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException: Duplicate entry '3-' for key 2 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.Statement.executeUpdate(Statement.java:1316) at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1235) at com.carldunham.jst.db.Database.executeUpdate(Database.java:401) at com.carldunham.jst.db.BaseDatabaseTable.insert(BaseDatabaseTable.java:345) at com.carldunham.jst.db.BaseDatabaseTableRow.save(BaseDatabaseTableRow.java:490) at com.carldunham.jst.db.BaseDatabaseTableRow.save(BaseDatabaseTableRow.java:424) at com.thesearchagency.searchengines.SearchEngineUpdater$DistributionWorker.syncUsers(SearchEngineUpdater.java:1014) at com.thesearchagency.searchengines.SearchEngineUpdater$DistributionWorker.run(SearchEngineUpdater.java:722) 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-14 00:09:41.636 (3) [P1T1]: Accounts: 41 added, 587 modified 2011-06-14 00:09:41.637 (3) [P1T1]: Accounts: 0 disabled, 2 deleted 2011-06-14 00:09:57.674 (3) [main]: ------------Search Engine Updater done 2011-06-14 00:09:57.674 (3) [main]: ----------------Search Engine Updater starting 2011-06-14 00:09:57.906 (3) [P2T1]: Starting User (8) "WWMW - Cellular Safety Commission" 2011-06-14 00:10:06.766 (2) [P2T1]: Empty account list returned from search engine, assuming an error, not a disabled account 2011-06-14 00:10:06.780 (3) [P2T1]: Finished User (8) "WWMW - Cellular Safety Commission" 2011-06-14 00:10:06.784 (3) [main]: ------------Search Engine Updater done 2011-06-14 00:10:06.784 (3) [main]: ----------------SearchEngineSyncUserWorker starting 2011-06-14 00:10:10.955 (3) [P3T1]: DatabasePool with a limit of 80 created 2011-06-14 00:10:11.062 (3) [P3T2]: DatabasePool with a limit of 80 created 2011-06-14 00:10:11.390 (3) [P3T1]: -- Bulk downloads supported. 2011-06-14 00:10:11.391 (3) [P3T1]: -- Begining search engine sync for user: (3201) "Martian Tourism" 2011-06-14 00:10:12.714 (3) [P3T2]: -- Bulk downloads supported. 2011-06-14 00:10:12.730 (3) [P3T2]: -- Begining search engine sync for user: (8) "WWMW - Cellular Safety Commission" 2011-06-14 00:10:12.951 (3) [P3T1]: DatabasePool with a limit of 80 created 2011-06-14 00:10:13.663 (3) [P3T1]: DatabasePool with a limit of 80 created 2011-06-14 00:10:13.722 (3) [P3T2]: DatabasePool with a limit of 80 created 2011-06-14 00:10:13.795 (2) [P3T1]: Created KeywordStructureSyncCriterion, db is googleKeywords 2011-06-14 00:10:13.796 (2) [P3T1]: Created CreativeStructureSyncCriterion 2011-06-14 00:10:13.799 (2) [P3T1]: googleKeywords 2011-06-14 00:10:13.827 (2) [P3T1]: Added Keyword Performance Report AdGroupId to secondaryKeys 2011-06-14 00:10:13.827 (2) [P3T1]: Added Adgroup Performance Report AdGroupId to secondaryKeys 2011-06-14 00:10:13.827 (2) [P3T1]: Added Managed Placement Performance Report AdGroupId to secondaryKeys 2011-06-14 00:10:13.827 (2) [P3T1]: Getting columns for : Managed Placement Performance Report 2011-06-14 00:10:13.828 (2) [P3T1]: Got : CampaignId 2011-06-14 00:10:13.828 (2) [P3T1]: Got : AdGroupId 2011-06-14 00:10:13.828 (2) [P3T1]: Got : AdGroupStatus 2011-06-14 00:10:13.828 (2) [P3T1]: Got : MaxCpc 2011-06-14 00:10:13.828 (2) [P3T1]: Got : MaxCpm 2011-06-14 00:10:13.828 (2) [P3T1]: Got : KeywordMatchType 2011-06-14 00:10:13.828 (2) [P3T1]: Got : Status 2011-06-14 00:10:13.828 (2) [P3T1]: Got : DestinationUrl 2011-06-14 00:10:13.828 (2) [P3T1]: Got : IsNegative 2011-06-14 00:10:13.828 (2) [P3T1]: Got : PlacementUrl 2011-06-14 00:10:13.831 (2) [P3T1]: Got : Id 2011-06-14 00:10:13.836 (2) [P3T1]: YESTERDAYMANAGED_PLACEMENTS_PERFORMANCE_REPORTCampaignIdAdGroupIdAdGroupStatusMaxCpcMaxCpmKeywordMatchTypeStatusDestinationUrlIsNegativePlacementUrlId -484d3bf959c59d54610f8b25330785be 2011-06-14 00:10:13.848 (1) [P3T1]: Error looking up reportDefinition in database: Table 'sesystem.googleReportDefinitions' doesn't exist 2011-06-14 00:10:13.851 (2) [P3T1]: Definition found in db: false for hash: -484d3bf959c59d54610f8b25330785be and account: 9547283525 2011-06-14 00:10:14.188 (2) [P3T2]: Created KeywordStructureSyncCriterion, db is googleKeywords 2011-06-14 00:10:14.191 (2) [P3T2]: Created CreativeStructureSyncCriterion 2011-06-14 00:10:14.191 (2) [P3T2]: googleKeywords 2011-06-14 00:10:14.192 (2) [P3T2]: Added Keyword Performance Report AdGroupId to secondaryKeys 2011-06-14 00:10:14.192 (2) [P3T2]: Added Adgroup Performance Report AdGroupId to secondaryKeys 2011-06-14 00:10:14.195 (2) [P3T2]: Added Managed Placement Performance Report AdGroupId to secondaryKeys 2011-06-14 00:10:14.195 (2) [P3T2]: Getting columns for : Managed Placement Performance Report 2011-06-14 00:10:14.195 (2) [P3T2]: Got : CampaignId 2011-06-14 00:10:14.195 (2) [P3T2]: Got : AdGroupId 2011-06-14 00:10:14.195 (2) [P3T2]: Got : AdGroupStatus 2011-06-14 00:10:14.195 (2) [P3T2]: Got : MaxCpc 2011-06-14 00:10:14.195 (2) [P3T2]: Got : MaxCpm 2011-06-14 00:10:14.195 (2) [P3T2]: Got : KeywordMatchType 2011-06-14 00:10:14.195 (2) [P3T2]: Got : Status 2011-06-14 00:10:14.195 (2) [P3T2]: Got : DestinationUrl 2011-06-14 00:10:14.195 (2) [P3T2]: Got : IsNegative 2011-06-14 00:10:14.195 (2) [P3T2]: Got : PlacementUrl 2011-06-14 00:10:14.195 (2) [P3T2]: Got : Id 2011-06-14 00:10:14.199 (2) [P3T2]: YESTERDAYMANAGED_PLACEMENTS_PERFORMANCE_REPORTCampaignIdAdGroupIdAdGroupStatusMaxCpcMaxCpmKeywordMatchTypeStatusDestinationUrlIsNegativePlacementUrlId -484d3bf959c59d54610f8b25330785be 2011-06-14 00:10:14.203 (1) [P3T2]: Error looking up reportDefinition in database: Table 'sesystem.googleReportDefinitions' doesn't exist 2011-06-14 00:10:14.203 (2) [P3T2]: Definition found in db: false for hash: -484d3bf959c59d54610f8b25330785be and account: 4191136789 2011-06-14 00:10:15.860 (2) [P3T1]: Report definition for MANAGED_PLACEMENTS_PERFORMANCE_REPORT is valid? true 2011-06-14 00:10:15.863 (2) [P3T2]: Report definition for MANAGED_PLACEMENTS_PERFORMANCE_REPORT is valid? true 2011-06-14 00:10:17.875 (1) [P3T1]: Error inserting reportDefinition into database: Table 'sesystem.googleReportDefinitions' doesn't exist 2011-06-14 00:10:17.875 (2) [P3T1]: Getting columns for : Adgroup Performance Report 2011-06-14 00:10:17.875 (2) [P3T1]: Got : AdGroupName 2011-06-14 00:10:17.875 (2) [P3T1]: Got : KeywordContentMaxCpc 2011-06-14 00:10:17.875 (2) [P3T1]: Got : ProxyKeywordMaxCpc 2011-06-14 00:10:17.875 (2) [P3T1]: Got : MaxCpm 2011-06-14 00:10:17.875 (2) [P3T1]: Got : SiteMaxCpc 2011-06-14 00:10:17.875 (2) [P3T1]: Got : AdGroupId 2011-06-14 00:10:17.876 (2) [P3T1]: YESTERDAYADGROUP_PERFORMANCE_REPORTAdGroupNameKeywordContentMaxCpcProxyKeywordMaxCpcMaxCpmSiteMaxCpcAdGroupId 14ccfec5d95fbfdfc5160479d0dc93c3 2011-06-14 00:10:17.919 (1) [P3T1]: Error looking up reportDefinition in database: Table 'sesystem.googleReportDefinitions' doesn't exist 2011-06-14 00:10:17.927 (2) [P3T1]: Definition found in db: false for hash: 14ccfec5d95fbfdfc5160479d0dc93c3 and account: 9547283525 2011-06-14 00:10:18.171 (1) [P3T2]: Error inserting reportDefinition into database: Table 'sesystem.googleReportDefinitions' doesn't exist 2011-06-14 00:10:18.191 (2) [P3T2]: Getting columns for : Adgroup Performance Report 2011-06-14 00:10:18.195 (2) [P3T2]: Got : AdGroupName 2011-06-14 00:10:18.195 (2) [P3T2]: Got : KeywordContentMaxCpc 2011-06-14 00:10:18.195 (2) [P3T2]: Got : ProxyKeywordMaxCpc 2011-06-14 00:10:18.195 (2) [P3T2]: Got : MaxCpm 2011-06-14 00:10:18.195 (2) [P3T2]: Got : SiteMaxCpc 2011-06-14 00:10:18.195 (2) [P3T2]: Got : AdGroupId 2011-06-14 00:10:18.211 (2) [P3T2]: YESTERDAYADGROUP_PERFORMANCE_REPORTAdGroupNameKeywordContentMaxCpcProxyKeywordMaxCpcMaxCpmSiteMaxCpcAdGroupId 14ccfec5d95fbfdfc5160479d0dc93c3 2011-06-14 00:10:18.218 (1) [P3T2]: Error looking up reportDefinition in database: Table 'sesystem.googleReportDefinitions' doesn't exist 2011-06-14 00:10:18.219 (2) [P3T2]: Definition found in db: false for hash: 14ccfec5d95fbfdfc5160479d0dc93c3 and account: 4191136789 2011-06-14 00:10:19.798 (2) [P3T2]: Report definition for ADGROUP_PERFORMANCE_REPORT is valid? true 2011-06-14 00:10:19.854 (2) [P3T1]: Report definition for ADGROUP_PERFORMANCE_REPORT is valid? true 2011-06-14 00:10:20.957 (1) [P3T2]: Error inserting reportDefinition into database: Table 'sesystem.googleReportDefinitions' doesn't exist 2011-06-14 00:10:20.965 (2) [P3T2]: Getting columns for : Keyword Performance Report 2011-06-14 00:10:20.965 (2) [P3T2]: Got : CampaignId 2011-06-14 00:10:20.965 (2) [P3T2]: Got : AdGroupId 2011-06-14 00:10:20.969 (2) [P3T2]: Got : AdGroupStatus 2011-06-14 00:10:20.969 (2) [P3T2]: Got : MaxCpc 2011-06-14 00:10:20.969 (2) [P3T2]: Got : MaxCpm 2011-06-14 00:10:20.973 (2) [P3T2]: Got : KeywordMatchType 2011-06-14 00:10:20.973 (2) [P3T2]: Got : Status 2011-06-14 00:10:20.973 (2) [P3T2]: Got : DestinationUrl 2011-06-14 00:10:20.977 (2) [P3T2]: Got : IsNegative 2011-06-14 00:10:20.977 (2) [P3T2]: Got : KeywordText 2011-06-14 00:10:20.977 (2) [P3T2]: Got : Id 2011-06-14 00:10:20.985 (2) [P3T2]: YESTERDAYKEYWORDS_PERFORMANCE_REPORTCampaignIdAdGroupIdAdGroupStatusMaxCpcMaxCpmKeywordMatchTypeStatusDestinationUrlIsNegativeKeywordTextId 296d860661f7b19d8997e600e5c20868 2011-06-14 00:10:21.001 (1) [P3T2]: Error looking up reportDefinition in database: Table 'sesystem.googleReportDefinitions' doesn't exist 2011-06-14 00:10:21.002 (2) [P3T2]: Definition found in db: false for hash: 296d860661f7b19d8997e600e5c20868 and account: 4191136789 2011-06-14 00:10:21.578 (1) [P3T1]: Error inserting reportDefinition into database: Table 'sesystem.googleReportDefinitions' doesn't exist 2011-06-14 00:10:21.579 (2) [P3T1]: Getting columns for : Keyword Performance Report 2011-06-14 00:10:21.579 (2) [P3T1]: Got : CampaignId 2011-06-14 00:10:21.579 (2) [P3T1]: Got : AdGroupId 2011-06-14 00:10:21.581 (2) [P3T1]: Got : AdGroupStatus 2011-06-14 00:10:21.581 (2) [P3T1]: Got : MaxCpc 2011-06-14 00:10:21.581 (2) [P3T1]: Got : MaxCpm 2011-06-14 00:10:21.581 (2) [P3T1]: Got : KeywordMatchType 2011-06-14 00:10:21.581 (2) [P3T1]: Got : Status 2011-06-14 00:10:21.581 (2) [P3T1]: Got : DestinationUrl 2011-06-14 00:10:21.581 (2) [P3T1]: Got : IsNegative 2011-06-14 00:10:21.581 (2) [P3T1]: Got : KeywordText 2011-06-14 00:10:21.581 (2) [P3T1]: Got : Id 2011-06-14 00:10:21.583 (2) [P3T1]: YESTERDAYKEYWORDS_PERFORMANCE_REPORTCampaignIdAdGroupIdAdGroupStatusMaxCpcMaxCpmKeywordMatchTypeStatusDestinationUrlIsNegativeKeywordTextId 296d860661f7b19d8997e600e5c20868 2011-06-14 00:10:21.586 (1) [P3T1]: Error looking up reportDefinition in database: Table 'sesystem.googleReportDefinitions' doesn't exist 2011-06-14 00:10:21.587 (2) [P3T1]: Definition found in db: false for hash: 296d860661f7b19d8997e600e5c20868 and account: 9547283525 2011-06-14 00:10:22.863 (2) [P3T1]: Report definition for KEYWORDS_PERFORMANCE_REPORT is valid? true 2011-06-14 00:10:22.865 (2) [P3T2]: Report definition for KEYWORDS_PERFORMANCE_REPORT is valid? true 2011-06-14 00:10:24.047 (1) [P3T2]: Error inserting reportDefinition into database: Table 'sesystem.googleReportDefinitions' doesn't exist 2011-06-14 00:10:24.065 (1) [P3T1]: Error inserting reportDefinition into database: Table 'sesystem.googleReportDefinitions' doesn't exist 2011-06-14 00:10:24.081 (2) [DownloaderT1]: Downloading report : Managed Placement Performance Report 2011-06-14 00:10:24.081 (3) [DownloaderT1]: Scheduling report attempt 1: ReportID=55245778 2011-06-14 00:10:24.097 (2) [DownloaderT1]: Downloading report : Managed Placement Performance Report 2011-06-14 00:10:24.097 (3) [DownloaderT1]: Scheduling report attempt 1: ReportID=41616731 2011-06-14 00:10:24.129 (2) [DownloaderT2]: Downloading report : Adgroup Performance Report 2011-06-14 00:10:24.129 (3) [DownloaderT2]: Scheduling report attempt 1: ReportID=55246378 2011-06-14 00:10:24.131 (2) [DownloaderT3]: Downloading report : Keyword Performance Report 2011-06-14 00:10:24.889 (2) [DownloaderT3]: Downloading report : Keyword Performance Report 2011-06-14 00:10:24.889 (3) [DownloaderT3]: Scheduling report attempt 1: ReportID=41616971 2011-06-14 00:10:24.891 (2) [DownloaderT2]: Downloading report : Adgroup Performance Report 2011-06-14 00:10:24.891 (3) [DownloaderT2]: Scheduling report attempt 1: ReportID=41616851 2011-06-14 00:10:24.893 (3) [DownloaderT3]: Scheduling report attempt 1: ReportID=55246498 2011-06-14 00:10:25.723 (2) [DownloaderT2]: OK 2011-06-14 00:10:25.751 (2) [DownloaderT2]: Report : Adgroup Performance Report downloaded. 2011-06-14 00:10:25.817 (2) [DownloaderT2]: Report : Adgroup Performance Report is valid : true 2011-06-14 00:10:26.015 (2) [DownloaderT1]: OK 2011-06-14 00:10:26.017 (2) [DownloaderT1]: Report : Managed Placement Performance Report downloaded. 2011-06-14 00:10:26.037 (2) [DownloaderT1]: Report : Managed Placement Performance Report is valid : true 2011-06-14 00:10:26.265 (2) [DownloaderT3]: OK 2011-06-14 00:10:26.267 (2) [DownloaderT3]: Report : Keyword Performance Report downloaded. 2011-06-14 00:10:26.309 (2) [DownloaderT3]: Report : Keyword Performance Report is valid : true 2011-06-14 00:10:26.469 (2) [P3T1]: Downloaded and validated Managed Placement Performance Report 1104 bytes. 2011-06-14 00:10:26.469 (2) [P3T1]: Downloaded and validated Adgroup Performance Report 910 bytes. 2011-06-14 00:10:26.469 (2) [P3T1]: Downloaded and validated Keyword Performance Report 2593 bytes. 2011-06-14 00:10:26.471 (2) [P3T1]: Parsing report as secondary report: Adgroup Performance Report 2011-06-14 00:10:26.477 (3) [P3T1]: parsing columns for Adgroup Performance Report 2011-06-14 00:10:26.493 (3) [P3T1]: parsing rows for Adgroup Performance Report 2011-06-14 00:10:26.512 (2) [P3T1]: Finished parsing report: Adgroup Performance Report 2011-06-14 00:10:26.516 (2) [P3T1]: Parsing report as primary report: Managed Placement Performance Report with 203552120 bytes free 2011-06-14 00:10:26.571 (3) [P3T1]: parsing columns for Managed Placement Performance Report 2011-06-14 00:10:26.575 (3) [P3T1]: Columns already defined 2011-06-14 00:10:26.588 (3) [P3T1]: parsing rows for Managed Placement Performance Report 2011-06-14 00:10:26.608 (2) [P3T1]: Waiting for workers to die. 2011-06-14 00:10:26.673 (2) [MergeT1]: fixing an auto google inserted : auto: 0.70 2011-06-14 00:10:26.676 (2) [MergeT1]: fixing an auto google inserted : auto: 0.70 2011-06-14 00:10:26.788 (2) [DownloaderT2]: OK 2011-06-14 00:10:26.800 (2) [DownloaderT2]: Report : Adgroup Performance Report downloaded. 2011-06-14 00:10:26.864 (2) [DownloaderT1]: OK 2011-06-14 00:10:26.876 (2) [DownloaderT3]: OK 2011-06-14 00:10:26.888 (2) [DownloaderT1]: Report : Managed Placement Performance Report downloaded. 2011-06-14 00:10:26.997 (2) [DownloaderT2]: Report : Adgroup Performance Report is valid : true 2011-06-14 00:10:27.032 (2) [DownloaderT1]: Report : Managed Placement Performance Report is valid : true 2011-06-14 00:10:27.501 (2) [P3T1]: Waiting for workers to die. 2011-06-14 00:10:27.505 (2) [DownloaderT3]: Report : Keyword Performance Report downloaded. 2011-06-14 00:10:27.793 (2) [DownloaderT3]: Report : Keyword Performance Report is valid : true 2011-06-14 00:10:28.003 (2) [P3T1]: Finished parsing report: Managed Placement Performance Report 2011-06-14 00:10:28.011 (2) [P3T1]: Parsing report as primary report: Keyword Performance Report with 201225568 bytes free 2011-06-14 00:10:28.023 (2) [P3T2]: Downloaded and validated Managed Placement Performance Report 4168 bytes. 2011-06-14 00:10:28.027 (2) [P3T2]: Downloaded and validated Adgroup Performance Report 1847 bytes. 2011-06-14 00:10:28.031 (2) [P3T2]: Downloaded and validated Keyword Performance Report 12605 bytes. 2011-06-14 00:10:28.035 (2) [P3T2]: Parsing report as secondary report: Adgroup Performance Report 2011-06-14 00:10:28.143 (3) [P3T2]: parsing columns for Adgroup Performance Report 2011-06-14 00:10:28.292 (3) [P3T2]: parsing rows for Adgroup Performance Report 2011-06-14 00:10:28.365 (2) [P3T2]: Finished parsing report: Adgroup Performance Report 2011-06-14 00:10:28.368 (2) [P3T2]: Parsing report as primary report: Managed Placement Performance Report with 204976608 bytes free 2011-06-14 00:10:28.396 (3) [P3T1]: parsing columns for Keyword Performance Report 2011-06-14 00:10:28.400 (3) [P3T1]: Columns already defined 2011-06-14 00:10:28.441 (3) [P3T1]: parsing rows for Keyword Performance Report 2011-06-14 00:10:28.507 (2) [P3T1]: Waiting for workers to die. 2011-06-14 00:10:28.567 (3) [P3T2]: parsing columns for Managed Placement Performance Report 2011-06-14 00:10:28.579 (3) [P3T2]: Columns already defined 2011-06-14 00:10:28.696 (3) [P3T2]: parsing rows for Managed Placement Performance Report 2011-06-14 00:10:29.012 (2) [P3T1]: Waiting for workers to die. 2011-06-14 00:10:29.251 (2) [P3T2]: Waiting for workers to die. 2011-06-14 00:10:29.536 (2) [P3T1]: Waiting for workers to die. 2011-06-14 00:10:29.648 (2) [MergeT1]: fixing an auto google inserted : auto: 0.70 2011-06-14 00:10:29.652 (2) [MergeT1]: fixing an auto google inserted : auto: 0.70 2011-06-14 00:10:29.776 (2) [P3T2]: Waiting for workers to die. 2011-06-14 00:10:29.781 (2) [MergeT2]: fixing an auto google inserted : auto: 0.70 2011-06-14 00:10:29.792 (2) [MergeT1]: fixing an auto google inserted : auto: 0.70 2011-06-14 00:10:29.793 (2) [MergeT1]: fixing an auto google inserted : auto: 0.70 2011-06-14 00:10:29.797 (2) [MergeT1]: fixing an auto google inserted : auto: 0.70 2011-06-14 00:10:29.824 (2) [MergeT2]: fixing an auto google inserted : auto: 0.70 2011-06-14 00:10:29.860 (2) [MergeT2]: fixing an auto google inserted : auto: 0.70 2011-06-14 00:10:29.884 (2) [MergeT2]: fixing an auto google inserted : auto: 0.70 2011-06-14 00:10:29.920 (2) [MergeT1]: fixing an auto google inserted : auto: 0.70 2011-06-14 00:10:30.039 (2) [P3T1]: Waiting for workers to die. 2011-06-14 00:10:30.287 (2) [P3T2]: Waiting for workers to die. 2011-06-14 00:10:30.551 (2) [P3T1]: Waiting for workers to die. 2011-06-14 00:10:30.796 (2) [P3T2]: Waiting for workers to die. 2011-06-14 00:10:30.972 (2) [MergeT1]: fixing an auto google inserted : auto: 0.05 2011-06-14 00:10:30.973 (2) [MergeT1]: fixing an auto google inserted : auto: 0.05 2011-06-14 00:10:30.992 (2) [MergeT1]: fixing an auto google inserted : auto: 0.05 2011-06-14 00:10:31.060 (2) [P3T1]: Finished parsing report: Keyword Performance Report 2011-06-14 00:10:32.636 (2) [P3T2]: Waiting for workers to die. 2011-06-14 00:10:32.636 (2) [MergeT1]: fixing an auto google inserted : auto: 0.05 2011-06-14 00:10:32.637 (2) [MergeT1]: fixing an auto google inserted : auto: 0.05 2011-06-14 00:10:32.640 (2) [MergeT1]: fixing an auto google inserted : auto: 0.05 2011-06-14 00:10:33.140 (2) [P3T2]: Finished parsing report: Managed Placement Performance Report 2011-06-14 00:10:33.140 (2) [P3T2]: Parsing report as primary report: Keyword Performance Report with 238231568 bytes free 2011-06-14 00:10:33.169 (3) [P3T2]: parsing columns for Keyword Performance Report 2011-06-14 00:10:33.172 (3) [P3T2]: Columns already defined 2011-06-14 00:10:33.953 (3) [P3T2]: parsing rows for Keyword Performance Report 2011-06-14 00:10:34.960 (2) [P3T2]: Waiting for workers to die. 2011-06-14 00:10:35.467 (2) [P3T2]: Waiting for workers to die. 2011-06-14 00:10:35.660 (2) [P3T1]: Created temp file: /var/local/tsa/google_sync_files/tsa-keyword-structure-report--3201-2011-06-14 00:10:131822.tmp 2011-06-14 00:10:35.660 (2) [P3T1]: googleAds 2011-06-14 00:10:35.663 (2) [P3T1]: Getting columns for : Ad Performance Report 2011-06-14 00:10:35.663 (2) [P3T1]: Got : CampaignId 2011-06-14 00:10:35.664 (2) [P3T1]: Got : AdGroupId 2011-06-14 00:10:35.664 (2) [P3T1]: Got : Headline 2011-06-14 00:10:35.664 (2) [P3T1]: Got : Description1 2011-06-14 00:10:35.664 (2) [P3T1]: Got : Description2 2011-06-14 00:10:35.664 (2) [P3T1]: Got : DisplayUrl 2011-06-14 00:10:35.664 (2) [P3T1]: Got : Id 2011-06-14 00:10:35.664 (2) [P3T1]: Got : AdType 2011-06-14 00:10:35.664 (2) [P3T1]: Got : Status 2011-06-14 00:10:35.665 (2) [P3T1]: Got : CreativeDestinationUrl 2011-06-14 00:10:35.665 (2) [P3T1]: YESTERDAYAD_PERFORMANCE_REPORTCampaignIdAdGroupIdHeadlineDescription1Description2DisplayUrlIdAdTypeStatusCreativeDestinationUrl -5ecc211c13cec065600706929725b2b8 2011-06-14 00:10:35.684 (1) [P3T1]: Error looking up reportDefinition in database: Table 'sesystem.googleReportDefinitions' doesn't exist 2011-06-14 00:10:35.684 (2) [P3T1]: Definition found in db: false for hash: -5ecc211c13cec065600706929725b2b8 and account: 9547283525 2011-06-14 00:10:35.995 (2) [P3T2]: Waiting for workers to die. 2011-06-14 00:10:36.503 (2) [P3T2]: Waiting for workers to die. 2011-06-14 00:10:36.796 (2) [P3T1]: Report definition for AD_PERFORMANCE_REPORT is valid? true 2011-06-14 00:10:37.014 (2) [P3T2]: Waiting for workers to die. 2011-06-14 00:10:37.538 (2) [P3T2]: Waiting for workers to die. 2011-06-14 00:10:38.039 (2) [P3T2]: Waiting for workers to die. 2011-06-14 00:10:38.326 (1) [P3T1]: Error inserting reportDefinition into database: Table 'sesystem.googleReportDefinitions' doesn't exist 2011-06-14 00:10:38.460 (2) [MergeT2]: fixing an auto google inserted : auto: 1.00 2011-06-14 00:10:38.464 (2) [MergeT2]: fixing an auto google inserted : auto: 1.00 2011-06-14 00:10:38.468 (2) [MergeT2]: fixing an auto google inserted : auto: 1.00 2011-06-14 00:10:38.471 (2) [MergeT2]: fixing an auto google inserted : auto: 1.00 2011-06-14 00:10:38.474 (2) [MergeT2]: fixing an auto google inserted : auto: 1.00 2011-06-14 00:10:38.478 (2) [MergeT2]: fixing an auto google inserted : auto: 1.00 2011-06-14 00:10:38.482 (2) [MergeT2]: fixing an auto google inserted : auto: 1.00 2011-06-14 00:10:38.486 (2) [MergeT2]: fixing an auto google inserted : auto: 1.00 2011-06-14 00:10:38.488 (2) [MergeT2]: fixing an auto google inserted : auto: 1.00 2011-06-14 00:10:38.492 (2) [MergeT2]: fixing an auto google inserted : auto: 1.00 2011-06-14 00:10:38.496 (2) [MergeT2]: fixing an auto google inserted : auto: 1.00 2011-06-14 00:10:38.498 (2) [MergeT2]: fixing an auto google inserted : auto: 1.00 2011-06-14 00:10:38.502 (2) [MergeT2]: fixing an auto google inserted : auto: 1.00 2011-06-14 00:10:38.504 (2) [MergeT2]: fixing an auto google inserted : auto: 1.00 2011-06-14 00:10:38.508 (2) [MergeT2]: fixing an auto google inserted : auto: 1.00 2011-06-14 00:10:38.512 (2) [MergeT2]: fixing an auto google inserted : auto: 1.00 2011-06-14 00:10:38.520 (2) [MergeT1]: fixing an auto google inserted : auto: 1.00 2011-06-14 00:10:38.522 (2) [MergeT1]: fixing an auto google inserted : auto: 1.00 2011-06-14 00:10:38.526 (2) [MergeT1]: fixing an auto google inserted : auto: 1.00 2011-06-14 00:10:38.530 (2) [MergeT1]: fixing an auto google inserted : auto: 1.00 2011-06-14 00:10:38.534 (2) [MergeT1]: fixing an auto google inserted : auto: 1.00 2011-06-14 00:10:38.536 (2) [MergeT1]: fixing an auto google inserted : auto: 1.00 2011-06-14 00:10:38.540 (2) [MergeT1]: fixing an auto google inserted : auto: 1.00 2011-06-14 00:10:38.544 (2) [MergeT1]: fixing an auto google inserted : auto: 1.00 2011-06-14 00:10:38.547 (2) [MergeT1]: fixing an auto google inserted : auto: 1.00 2011-06-14 00:10:38.550 (2) [MergeT1]: fixing an auto google inserted : auto: 1.00 2011-06-14 00:10:38.554 (2) [MergeT1]: fixing an auto google inserted : auto: 1.00 2011-06-14 00:10:38.556 (2) [MergeT1]: fixing an auto google inserted : auto: 1.00 2011-06-14 00:10:38.560 (2) [MergeT1]: fixing an auto google inserted : auto: 1.00 2011-06-14 00:10:38.562 (2) [P3T2]: Waiting for workers to die. 2011-06-14 00:10:38.564 (2) [MergeT1]: fixing an auto google inserted : auto: 1.00 2011-06-14 00:10:38.568 (2) [MergeT1]: fixing an auto google inserted : auto: 1.00 2011-06-14 00:10:38.570 (2) [MergeT1]: fixing an auto google inserted : auto: 1.00 2011-06-14 00:10:38.574 (2) [MergeT1]: fixing an auto google inserted : auto: 1.00 2011-06-14 00:10:38.576 (2) [MergeT1]: fixing an auto google inserted : auto: 1.00 2011-06-14 00:10:38.580 (2) [MergeT1]: fixing an auto google inserted : auto: 1.00 2011-06-14 00:10:38.584 (2) [MergeT1]: fixing an auto google inserted : auto: 1.00 2011-06-14 00:10:39.066 (2) [P3T2]: Waiting for workers to die. 2011-06-14 00:10:39.568 (2) [P3T2]: Waiting for workers to die. 2011-06-14 00:10:39.812 (2) [MergeT1]: fixing an auto google inserted : auto: 0.05 2011-06-14 00:10:39.820 (2) [MergeT1]: fixing an auto google inserted : auto: 0.05 2011-06-14 00:10:39.822 (2) [MergeT1]: fixing an auto google inserted : auto: 0.05 2011-06-14 00:10:39.824 (2) [MergeT1]: fixing an auto google inserted : auto: 0.05 2011-06-14 00:10:39.828 (2) [MergeT1]: fixing an auto google inserted : auto: 0.05 2011-06-14 00:10:39.830 (2) [MergeT1]: fixing an auto google inserted : auto: 0.05 2011-06-14 00:10:39.832 (2) [MergeT1]: fixing an auto google inserted : auto: 0.05 2011-06-14 00:10:39.834 (2) [MergeT2]: fixing an auto google inserted : auto: 0.05 2011-06-14 00:10:39.836 (2) [MergeT2]: fixing an auto google inserted : auto: 0.05 2011-06-14 00:10:39.840 (2) [MergeT1]: fixing an auto google inserted : auto: 0.05 2011-06-14 00:10:39.842 (2) [MergeT1]: fixing an auto google inserted : auto: 0.05 2011-06-14 00:10:39.848 (2) [MergeT2]: fixing an auto google inserted : auto: 0.05 2011-06-14 00:10:40.006 (2) [MergeT1]: fixing an auto google inserted : auto: 0.05 2011-06-14 00:10:40.022 (2) [MergeT1]: fixing an auto google inserted : auto: 0.05 2011-06-14 00:10:40.024 (2) [MergeT1]: fixing an auto google inserted : auto: 0.05 2011-06-14 00:10:40.102 (2) [P3T2]: Waiting for workers to die. 2011-06-14 00:10:40.110 (2) [DownloaderT1]: Downloading report : Ad Performance Report 2011-06-14 00:10:40.110 (3) [DownloaderT1]: Scheduling report attempt 1: ReportID=55246858 2011-06-14 00:10:40.608 (2) [P3T2]: Finished parsing report: Keyword Performance Report 2011-06-14 00:10:42.504 (2) [DownloaderT1]: OK 2011-06-14 00:10:42.572 (2) [DownloaderT1]: Report : Ad Performance Report downloaded. 2011-06-14 00:10:42.677 (2) [DownloaderT1]: Report : Ad Performance Report is valid : true 2011-06-14 00:10:42.797 (2) [P3T1]: Downloaded and validated Ad Performance Report 1507 bytes. 2011-06-14 00:10:42.800 (2) [P3T1]: Parsing report as primary report: Ad Performance Report with 238022584 bytes free 2011-06-14 00:10:42.836 (3) [P3T1]: parsing columns for Ad Performance Report 2011-06-14 00:10:42.861 (3) [P3T1]: parsing rows for Ad Performance Report 2011-06-14 00:10:43.166 (2) [P3T1]: Waiting for workers to die. 2011-06-14 00:10:43.758 (2) [P3T1]: Waiting for workers to die. 2011-06-14 00:10:44.265 (2) [P3T1]: Finished parsing report: Ad Performance Report 2011-06-14 00:10:44.286 (2) [P3T2]: Created temp file: /var/local/tsa/google_sync_files/tsa-keyword-structure-report--8-2011-06-14 00:10:141823.tmp 2011-06-14 00:10:44.286 (2) [P3T2]: googleAds 2011-06-14 00:10:44.290 (2) [P3T2]: Getting columns for : Ad Performance Report 2011-06-14 00:10:44.290 (2) [P3T2]: Got : CampaignId 2011-06-14 00:10:44.290 (2) [P3T2]: Got : AdGroupId 2011-06-14 00:10:44.290 (2) [P3T2]: Got : Headline 2011-06-14 00:10:44.290 (2) [P3T2]: Got : Description1 2011-06-14 00:10:44.290 (2) [P3T2]: Got : Description2 2011-06-14 00:10:44.290 (2) [P3T2]: Got : DisplayUrl 2011-06-14 00:10:44.290 (2) [P3T2]: Got : Id 2011-06-14 00:10:44.292 (2) [P3T2]: Got : AdType 2011-06-14 00:10:44.292 (2) [P3T2]: Got : Status 2011-06-14 00:10:44.292 (2) [P3T2]: Got : CreativeDestinationUrl 2011-06-14 00:10:44.293 (2) [P3T2]: YESTERDAYAD_PERFORMANCE_REPORTCampaignIdAdGroupIdHeadlineDescription1Description2DisplayUrlIdAdTypeStatusCreativeDestinationUrl -5ecc211c13cec065600706929725b2b8 2011-06-14 00:10:44.298 (1) [P3T2]: Error looking up reportDefinition in database: Table 'sesystem.googleReportDefinitions' doesn't exist 2011-06-14 00:10:44.298 (2) [P3T2]: Definition found in db: false for hash: -5ecc211c13cec065600706929725b2b8 and account: 4191136789 2011-06-14 00:10:45.797 (2) [P3T2]: Report definition for AD_PERFORMANCE_REPORT is valid? true 2011-06-14 00:10:46.273 (2) [P3T1]: Created temp file: /var/local/tsa/google_sync_files/tsa-creative-structure-report--3201-2011-06-14 00:10:131824.tmp 2011-06-14 00:10:46.274 (3) [P3T1]: -- Data staging complete for seuser ((3201) "Martian Tourism") 2011-06-14 00:10:46.536 (3) [P3T1]: Loading data infile into temp table... 2011-06-14 00:10:46.562 (2) [P3T1]: Trying to load : /var/local/tsa/google_sync_files/tsa-keyword-structure-report--3201-2011-06-14 00:10:131822.tmp into `tmp`.`tmp1` 2011-06-14 00:10:46.626 (2) [P3T1]: Trying to load : /var/local/tsa/google_sync_files/tsa-creative-structure-report--3201-2011-06-14 00:10:131824.tmp into `tmp`.`tmp2` 2011-06-14 00:10:46.649 (3) [P3T1]: LOAD TEMP SYNC TABLES COMPLETED 2011-06-14 00:10:46.670 (3) [P3T1]: Campaigns with new items:([]) 2011-06-14 00:10:46.670 (3) [P3T1]: DETECTION OF NEW CAMPAIGN ITEMS COMPLETED 2011-06-14 00:10:46.769 (3) [P3T1]: Campaigns with deleted items:([]) 2011-06-14 00:10:46.773 (3) [P3T1]: DETECTION OF DELETED CAMPAIGN ITEMS COMPLETED 2011-06-14 00:10:46.841 (3) [P3T1]: Campaigns with updated items:([]) 2011-06-14 00:10:46.842 (3) [P3T1]: DETECTION OF UPDATED CAMPAIGN ITEMS COMPLETED 2011-06-14 00:10:46.857 (3) [P3T1]: 126 keyword records removed before re-loading staging table. 2011-06-14 00:10:46.958 (3) [P3T1]: 126 keyword records loaded into staging table. 2011-06-14 00:10:46.969 (3) [P3T1]: 26 creative ad records removed from staging table before re-loading. 2011-06-14 00:10:46.980 (3) [P3T1]: 26 creative ad records loaded into staging table. 2011-06-14 00:10:46.981 (3) [P3T1]: UPDATE OF STAGING TABLES COMPLETED 2011-06-14 00:10:46.981 (3) [P3T1]: Passing seUserAcctId: 618 and seAcctAcctId: 17 2011-06-14 00:10:47.093 (3) [P3T1]: Replicating 16 rows... 2011-06-14 00:10:47.349 (3) [P3T1]: Change Detected - Campaign(s) with no previous sync history:(SEUserID: 3201 | AcctID: 618) 2011-06-14 00:10:47.350 (3) [P3T1]: CampaignIDs:([32411, 43, 32955]) 2011-06-14 00:10:47.350 (3) [P3T1]: DETECTION OF CAMPAIGNS NEEDING FIRST SYNC COMPLETED 2011-06-14 00:10:47.382 (3) [P3T1]: DETECTION OF CAMPAIGNS WITH CONTENT/NETWORK CHANGES COMPLETED 2011-06-14 00:10:47.385 (3) [P3T1]: -- Account-level operations complete for seuser ((3201) "Martian Tourism") and seAccount(17) 2011-06-14 00:10:48.005 (3) [P3T1]: Keyword-level bidType changes: 0 2011-06-14 00:10:48.008 (3) [P3T1]: Keyword-level bidAmount changes: 0 2011-06-14 00:10:48.008 (3) [P3T1]: COMPLETED KEYWORD-LEVEL BID DETECTION FOR: seUser (3201) and seAccount(17) 2011-06-14 00:10:48.048 (1) [P3T2]: Error inserting reportDefinition into database: Table 'sesystem.googleReportDefinitions' doesn't exist 2011-06-14 00:10:48.049 (2) [DownloaderT1]: Downloading report : Ad Performance Report 2011-06-14 00:10:48.049 (3) [DownloaderT1]: Scheduling report attempt 1: ReportID=41617091 2011-06-14 00:10:48.401 (3) [P3T1]: Adgroup-level bidType changes: 0 2011-06-14 00:10:48.404 (3) [P3T1]: Adgroup-level bidAmount changes: 0 2011-06-14 00:10:48.404 (3) [P3T1]: COMPLETED ADGROUP-LEVEL BID DETECTION FOR: seUser (3201) and seAccount(17) 2011-06-14 00:10:48.404 (3) [P3T1]: -- Bid amount difference checks complete for seuser ((3201) "Martian Tourism") and seAccount(17) 2011-06-14 00:10:48.405 (3) [P3T1]: -- Out of sync seaccts found for se user: (3201) "Martian Tourism" : [43, 32411, 32955] 2011-06-14 00:10:48.520 (3) [P3T1]: -- Keyword/Creative difference checks complete for seuser ((3201) "Martian Tourism") 2011-06-14 00:10:48.536 (3) [P3T1]: SE Acct Id Set size :: 3 2011-06-14 00:10:49.620 (2) [DownloaderT1]: OK 2011-06-14 00:10:49.644 (2) [DownloaderT1]: Report : Ad Performance Report downloaded. 2011-06-14 00:10:49.692 (2) [DownloaderT1]: Report : Ad Performance Report is valid : true 2011-06-14 00:10:49.852 (2) [P3T2]: Downloaded and validated Ad Performance Report 4246 bytes. 2011-06-14 00:10:49.868 (2) [P3T2]: Parsing report as primary report: Ad Performance Report with 235971088 bytes free 2011-06-14 00:10:49.940 (3) [P3T2]: parsing columns for Ad Performance Report 2011-06-14 00:10:49.965 (3) [P3T2]: parsing rows for Ad Performance Report 2011-06-14 00:10:50.125 (2) [P3T2]: Waiting for workers to die. 2011-06-14 00:10:50.636 (2) [P3T2]: Waiting for workers to die. 2011-06-14 00:10:51.142 (2) [P3T2]: Finished parsing report: Ad Performance Report 2011-06-14 00:10:53.196 (2) [P3T2]: Created temp file: /var/local/tsa/google_sync_files/tsa-creative-structure-report--8-2011-06-14 00:10:141825.tmp 2011-06-14 00:10:53.204 (3) [P3T2]: -- Data staging complete for seuser ((8) "WWMW - Cellular Safety Commission") 2011-06-14 00:10:53.464 (3) [P3T2]: Loading data infile into temp table... 2011-06-14 00:10:53.477 (2) [P3T2]: Trying to load : /var/local/tsa/google_sync_files/tsa-keyword-structure-report--8-2011-06-14 00:10:141823.tmp into `tmp`.`tmp6` 2011-06-14 00:10:53.797 (2) [P3T2]: Trying to load : /var/local/tsa/google_sync_files/tsa-creative-structure-report--8-2011-06-14 00:10:141825.tmp into `tmp`.`tmp7` 2011-06-14 00:10:53.864 (3) [P3T2]: LOAD TEMP SYNC TABLES COMPLETED 2011-06-14 00:10:53.889 (3) [P3T2]: Change Detected - 1 Campaigns With New Keyword Items:(SEUserID: 8 | AcctID: 17) 2011-06-14 00:10:53.903 (3) [P3T2]: Change Detected - 1 Campaigns With New Creative Items:(SEUserID: 8 | AcctID: 17) 2011-06-14 00:10:53.904 (3) [P3T2]: Campaigns with new items:([54988811]) 2011-06-14 00:10:53.904 (3) [P3T2]: DETECTION OF NEW CAMPAIGN ITEMS COMPLETED 2011-06-14 00:10:53.945 (3) [P3T2]: Campaigns with deleted items:([]) 2011-06-14 00:10:53.945 (3) [P3T2]: DETECTION OF DELETED CAMPAIGN ITEMS COMPLETED 2011-06-14 00:10:54.029 (3) [P3T2]: Change Detected - 1 Campaigns With Updated Creative Items:(SEUserID: 8 | AcctID: 17) 2011-06-14 00:10:54.029 (3) [P3T2]: Campaigns with updated items:([3568841]) 2011-06-14 00:10:54.029 (3) [P3T2]: DETECTION OF UPDATED CAMPAIGN ITEMS COMPLETED 2011-06-14 00:10:54.069 (3) [P3T2]: 900 keyword records removed before re-loading staging table. 2011-06-14 00:10:54.164 (3) [P3T2]: 901 keyword records loaded into staging table. 2011-06-14 00:10:54.177 (3) [P3T2]: 127 creative ad records removed from staging table before re-loading. 2011-06-14 00:10:54.201 (3) [P3T2]: 128 creative ad records loaded into staging table. 2011-06-14 00:10:54.204 (3) [P3T2]: UPDATE OF STAGING TABLES COMPLETED 2011-06-14 00:10:54.215 (3) [P3T2]: Owning Account IDs: ("69") 2011-06-14 00:10:54.216 (3) [P3T2]: Passing seUserAcctId: 17 and seAcctAcctId: 17 2011-06-14 00:10:54.321 (3) [P3T2]: Replicating 894 rows... 2011-06-14 00:10:59.771 (3) [P3T2]: Change Detected - Campaign(s) with no previous sync history:(SEUserID: 8 | AcctID: 17) 2011-06-14 00:10:59.775 (3) [P3T2]: CampaignIDs:([32411, 43, 32955]) 2011-06-14 00:10:59.779 (3) [P3T2]: DETECTION OF CAMPAIGNS NEEDING FIRST SYNC COMPLETED 2011-06-14 00:11:00.017 (3) [P3T2]: DETECTION OF CAMPAIGNS WITH CONTENT/NETWORK CHANGES COMPLETED 2011-06-14 00:11:00.018 (3) [P3T2]: -- Account-level operations complete for seuser ((8) "WWMW - Cellular Safety Commission") and seAccount(17) 2011-06-14 00:11:00.977 (3) [P3T2]: Keyword-level bidType changes: 0 2011-06-14 00:11:00.981 (3) [P3T2]: Keyword-level bidAmount changes: 0 2011-06-14 00:11:00.985 (3) [P3T2]: COMPLETED KEYWORD-LEVEL BID DETECTION FOR: seUser (8) and seAccount(17) 2011-06-14 00:11:01.614 (3) [P3T2]: Adgroup-level bidType changes: 0 2011-06-14 00:11:01.614 (3) [P3T2]: Adgroup-level bidAmount changes: 0 2011-06-14 00:11:01.614 (3) [P3T2]: COMPLETED ADGROUP-LEVEL BID DETECTION FOR: seUser (8) and seAccount(17) 2011-06-14 00:11:01.615 (3) [P3T2]: -- Bid amount difference checks complete for seuser ((8) "WWMW - Cellular Safety Commission") and seAccount(17) 2011-06-14 00:11:01.617 (3) [P3T2]: -- Out of sync seaccts found for se user: (8) "WWMW - Cellular Safety Commission" : [43, 32411, 32955, 69] 2011-06-14 00:11:01.638 (3) [P3T2]: -- Keyword/Creative difference checks complete for seuser ((8) "WWMW - Cellular Safety Commission") 2011-06-14 00:11:01.639 (3) [P3T2]: SE Acct Id Set size :: 4 2011-06-14 00:11:01.642 (3) [main]: ------------SearchEngineSyncUserWorker done 2011-06-14 00:11:01.643 (3) [main]: detected search engine accounts with differences ("32411","43","32955","69")... 2011-06-14 00:11:01.643 (3) [main]: proceeding with listings sync... 2011-06-14 00:11:01.855 (3) [P4T1]: Starting Account (69) "Campaign #2" for user (8) "WWMW - Cellular Safety Commission" 2011-06-14 00:11:01.857 (3) [P4T1]: Sync Flag: true - syncing groups and listings for (69) "Campaign #2" for user (8) "WWMW - Cellular Safety Commission" 2011-06-14 00:11:01.875 (2) [P4T1]: Getting groups for : 3568841 ManualCPC 2011-06-14 00:11:01.877 (2) [P4T1]: =-=-=-= Getting adGroups for campaign : 3568841 2011-06-14 00:11:04.245 (3) [P4T1]: Groups: 0 added, 0 modified, 0 disabled. 2011-06-14 00:11:04.246 (3) [P4T1]: theListingsFlag true 2011-06-14 00:11:04.506 (2) [P4T1]: =-=-=-= Getting ads for campaignID : 3568841 2011-06-14 00:11:06.171 (3) [P4T1]: No ads were found 2011-06-14 00:11:06.217 (3) [P4T1]: No Creatives Found 2011-06-14 00:11:12.122 (3) [P4T1]: Sources: 0 added, 0 modified, 0 disabled. 2011-06-14 00:11:12.126 (3) [P4T1]: Listings: 0 added, 0 modified, 0 disabled. 2011-06-14 00:11:12.126 (3) [P4T1]: Bid Targets: 0 added, 0 modified. 2011-06-14 00:11:12.126 (3) [P4T1]: Source/Listing Map: 0 added, 0 modified, 0 deleted. 2011-06-14 00:11:12.126 (3) [P4T1]: SourceBidTypes: 0 added, 0 modified. 2011-06-14 00:11:12.126 (3) [P4T1]: Bid Target CPMs: 0 added, 0 modified 2011-06-14 00:11:12.374 (3) [P4T1]: DatabasePool with a limit of 80 created 2011-06-14 00:11:12.658 (3) [P4T1]: Finished Account (69) "Campaign #2" for user (8) "WWMW - Cellular Safety Commission" 2011-06-14 00:11:12.658 (3) [main]: After joining threads, calling doPostJoinActions 2011-06-14 00:11:12.660 (3) [main]: =============== Completed Search Engine Updater ================ 2011-06-14 00:11:12.666 (3) [main]: Search Engine Updater: 3m 3.347s 2011-06-14 00:11:12.666 (3) [main]: by key: 2011-06-14 00:11:12.668 (3) [main]: parsing: 20.015s 2011-06-14 00:11:12.668 (3) [main]: by thread: 2011-06-14 00:11:12.668 (3) [main]: P3T1: 6.058s 2011-06-14 00:11:12.670 (3) [main]: P3T2: 13.957s 2011-06-14 00:11:12.670 (3) [main]: google: 1m 37.149s 2011-06-14 00:11:12.670 (3) [main]: by thread: 2011-06-14 00:11:12.670 (3) [main]: P2T1: 7.864s 2011-06-14 00:11:12.670 (3) [main]: P3T1: 19.779s 2011-06-14 00:11:12.670 (3) [main]: P1T1: 46.280s 2011-06-14 00:11:12.670 (3) [main]: P4T1: 3.824s 2011-06-14 00:11:12.670 (3) [main]: P3T2: 19.402s 2011-06-14 00:11:12.670 (3) [main]: db: 35.397s 2011-06-14 00:11:12.672 (3) [main]: by thread: 2011-06-14 00:11:12.672 (3) [main]: P2T1: 0.147s 2011-06-14 00:11:12.672 (3) [main]: main: 0.371s 2011-06-14 00:11:12.674 (3) [main]: P3T1: 1.662s 2011-06-14 00:11:12.674 (3) [main]: P1T1: 25.668s 2011-06-14 00:11:12.674 (3) [main]: P4T1: 4.793s 2011-06-14 00:11:12.674 (3) [main]: P3T2: 2.756s 2011-06-14 00:11:12.674 (3) [main]: other: 30.786s