2011-07-20 23:05:21.919 (3) [main]: Debug Level set to 3 2011-07-20 23:05:21.949 (3) [main]: Listings flag set, implying groups flag as well. 2011-07-20 23:05:21.979 (3) [main]: DatabasePool with a limit of 80 created 2011-07-20 23:05:23.335 (3) [main]: getSEUserIDs distID=null, seUserID=8, accounts=(17) returned 8 2011-07-20 23:05:23.345 (3) [main]: =============== Starting Search Engine Updater ================ 2011-07-20 23:05:23.349 (3) [main]: ----------------Search Engine Updater starting 2011-07-20 23:05:25.079 (3) [main]: No licensing config file found, assuming TSA production environment 2011-07-20 23:05:25.957 (3) [main]: Created shared sesystem connection rw 2011-07-20 23:05:31.355 (3) [P1T1]: Starting User (8) "WWMW - Cellular Safety Commission" 2011-07-20 23:05:49.788 (2) [P1T1]: Campaign : #9765BF - CSC BF with Cost | #993BT - Was Camp #1 - Test found in google! 2011-07-20 23:05:49.791 (2) [P1T1]: Campaign : Campaign #2 found in google! 2011-07-20 23:05:49.792 (2) [P1T1]: Campaign : Campaign #3 found in google! 2011-07-20 23:05:49.795 (2) [P1T1]: Campaign : Campaign #4 -- Site Targeted found in google! 2011-07-20 23:05:49.795 (2) [P1T1]: Campaign : Sharon Test found in google! 2011-07-20 23:05:49.795 (2) [P1T1]: Campaign : Dave C. Testing found in google! 2011-07-20 23:05:49.795 (2) [P1T1]: Campaign : Campaign #5: CPM content with keywords found in google! 2011-07-20 23:05:49.796 (2) [P1T1]: Campaign : Campaign #6 found in google! 2011-07-20 23:05:49.796 (2) [P1T1]: Campaign : Campaign #7 found in google! 2011-07-20 23:05:49.796 (2) [P1T1]: Campaign : Campaign #8 found in google! 2011-07-20 23:05:49.799 (2) [P1T1]: Campaign : Dave C Testing Copy found in google! 2011-07-20 23:05:49.799 (2) [P1T1]: Campaign : Campaign #9 found in google! 2011-07-20 23:05:49.799 (2) [P1T1]: Campaign : Ross's Test Campaign found in google! 2011-07-20 23:05:49.800 (2) [P1T1]: Campaign : Campaign #10 found in google! 2011-07-20 23:05:49.800 (2) [P1T1]: Campaign : Campaign Sync #1 found in google! 2011-07-20 23:05:49.800 (2) [P1T1]: Campaign : Campaign #12 found in google! 2011-07-20 23:05:49.803 (2) [P1T1]: Campaign : Campaign #13 found in google! 2011-07-20 23:05:49.803 (2) [P1T1]: Campaign : bizFunc=1000000001,bizLoc=100004,advertId=324289 found in google! 2011-07-20 23:05:49.803 (2) [P1T1]: Campaign : Campaign Sync Test #2 (CPM) found in google! 2011-07-20 23:05:49.803 (2) [P1T1]: Campaign : Campaign #15 found in google! 2011-07-20 23:05:49.804 (2) [P1T1]: Campaign : Tom's NC Test Campaign found in google! 2011-07-20 23:05:49.807 (2) [P1T1]: Campaign : Campaign #16 found in google! 2011-07-20 23:05:49.807 (2) [P1T1]: Campaign : Campaign #17 found in google! 2011-07-20 23:05:49.807 (2) [P1T1]: Campaign : Campaign Sync Test #3 found in google! 2011-07-20 23:05:49.807 (2) [P1T1]: Campaign : Campaign with Keywords found in google! 2011-07-20 23:05:49.808 (2) [P1T1]: Campaign : Campaign with placements CPM found in google! 2011-07-20 23:05:49.811 (2) [P1T1]: Campaign : Campaign Sync Test #4 found in google! 2011-07-20 23:05:49.811 (2) [P1T1]: Campaign : Yet another Campaign found in google! 2011-07-20 23:05:49.811 (2) [P1T1]: Campaign : Campaign 100 found in google! 2011-07-20 23:05:49.811 (2) [P1T1]: Campaign : Campaign #19-test found in google! 2011-07-20 23:05:49.812 (2) [P1T1]: Campaign : Campaign #19-test2 found in google! 2011-07-20 23:05:49.812 (2) [P1T1]: Campaign : 1 Test Sync found in google! 2011-07-20 23:05:49.812 (2) [P1T1]: Campaign : 2 Test Sync found in google! 2011-07-20 23:05:49.815 (2) [P1T1]: Campaign : BugfixCampaign found in google! 2011-07-20 23:05:49.815 (2) [P1T1]: Campaign : Campaign #20 - keywords found in google! 2011-07-20 23:05:49.815 (2) [P1T1]: Campaign : Campaign #20 placements found in google! 2011-07-20 23:05:49.815 (2) [P1T1]: Campaign : New Campaign #20 found in google! 2011-07-20 23:05:49.816 (2) [P1T1]: Campaign : Campaign #20 found in google! 2011-07-20 23:05:49.819 (2) [P1T1]: Campaign : Campaign #30 CPM found in google! 2011-07-20 23:05:49.819 (2) [P1T1]: Campaign : Campaign #31 CPM found in google! 2011-07-20 23:05:49.819 (2) [P1T1]: Campaign : Campaign #22 - auto bidding found in google! 2011-07-20 23:05:49.819 (2) [P1T1]: Campaign : TestSyncCPC2CPM found in google! 2011-07-20 23:05:49.819 (2) [P1T1]: Campaign : BO Campaign found in google! 2011-07-20 23:05:49.820 (2) [P1T1]: Campaign : Campaign #22 found in google! 2011-07-20 23:05:49.820 (2) [P1T1]: Campaign : Campaign #23 found in google! 2011-07-20 23:05:49.823 (2) [P1T1]: Campaign : Campaign #24 found in google! 2011-07-20 23:05:49.823 (2) [P1T1]: Campaign : testapi11#25 found in google! 2011-07-20 23:05:49.823 (2) [P1T1]: Campaign : Campaign: Campaign_key_cpc found in google! 2011-07-20 23:05:49.823 (2) [P1T1]: Campaign : Campaign #25 found in google! 2011-07-20 23:05:49.852 (2) [P1T1]: Campaign : Campaign #26 found in google! 2011-07-20 23:06:31.701 (3) [main]: Waiting for tasks to be done 2011-07-20 23:06:39.630 (3) [P1T1]: DatabasePool with a limit of 80 created 2011-07-20 23:06:40.302 (3) [P1T1]: Synchronized 4 targets for campaign ID 20487: 4 updated, 0 added, 0 deleted 2011-07-20 23:06:40.474 (3) [P1T1]: Synchronized 4 targets for campaign ID 20489: 4 updated, 0 added, 0 deleted 2011-07-20 23:06:40.622 (3) [P1T1]: Synchronized 4 targets for campaign ID 20490: 4 updated, 0 added, 0 deleted 2011-07-20 23:06:40.766 (3) [P1T1]: Synchronized 5 targets for campaign ID 32934: 5 updated, 0 added, 0 deleted 2011-07-20 23:06:40.997 (3) [P1T1]: Synchronized 5 targets for campaign ID 32409: 5 updated, 0 added, 0 deleted 2011-07-20 23:06:41.086 (3) [P1T1]: Synchronized 5 targets for campaign ID 33986: 5 updated, 0 added, 0 deleted 2011-07-20 23:06:41.385 (3) [P1T1]: Synchronized 8 targets for campaign ID 332: 8 updated, 0 added, 0 deleted 2011-07-20 23:06:41.470 (3) [P1T1]: Synchronized 4 targets for campaign ID 32954: 4 updated, 0 added, 0 deleted 2011-07-20 23:06:41.593 (3) [P1T1]: Synchronized 4 targets for campaign ID 33651: 4 updated, 0 added, 0 deleted 2011-07-20 23:06:41.766 (3) [P1T1]: Synchronized 4 targets for campaign ID 37339: 4 updated, 0 added, 0 deleted 2011-07-20 23:06:41.958 (3) [P1T1]: Synchronized 5 targets for campaign ID 69: 5 updated, 0 added, 0 deleted 2011-07-20 23:06:42.094 (3) [P1T1]: Synchronized 4 targets for campaign ID 20491: 4 updated, 0 added, 0 deleted 2011-07-20 23:06:42.377 (3) [P1T1]: Synchronized 5 targets for campaign ID 32362: 5 updated, 0 added, 0 deleted 2011-07-20 23:06:42.486 (3) [P1T1]: Synchronized 4 targets for campaign ID 33657: 4 updated, 0 added, 0 deleted 2011-07-20 23:06:42.658 (3) [P1T1]: Synchronized 4 targets for campaign ID 33697: 4 updated, 0 added, 0 deleted 2011-07-20 23:06:42.885 (3) [P1T1]: Synchronized 5 targets for campaign ID 40202: 5 updated, 0 added, 0 deleted 2011-07-20 23:06:43.054 (3) [P1T1]: Synchronized 5 targets for campaign ID 32408: 5 updated, 0 added, 0 deleted 2011-07-20 23:06:43.177 (3) [P1T1]: Synchronized 3 targets for campaign ID 20488: 3 updated, 0 added, 0 deleted 2011-07-20 23:06:43.379 (3) [P1T1]: Synchronized 4 targets for campaign ID 49441: 4 updated, 0 added, 0 deleted 2011-07-20 23:06:43.511 (3) [P1T1]: Synchronized 2 targets for campaign ID 32952: 2 updated, 0 added, 0 deleted 2011-07-20 23:06:43.697 (3) [P1T1]: Synchronized 4 targets for campaign ID 49463: 4 updated, 0 added, 0 deleted 2011-07-20 23:06:43.826 (3) [P1T1]: Synchronized 5 targets for campaign ID 40232: 5 updated, 0 added, 0 deleted 2011-07-20 23:06:43.926 (3) [P1T1]: Synchronized 4 targets for campaign ID 5287: 4 updated, 0 added, 0 deleted 2011-07-20 23:06:44.138 (3) [P1T1]: Synchronized 4 targets for campaign ID 20493: 4 updated, 0 added, 0 deleted 2011-07-20 23:06:44.239 (3) [P1T1]: Synchronized 5 targets for campaign ID 37338: 5 updated, 0 added, 0 deleted 2011-07-20 23:06:44.334 (3) [P1T1]: Synchronized 5 targets for campaign ID 40222: 5 updated, 0 added, 0 deleted 2011-07-20 23:06:44.485 (3) [P1T1]: Synchronized 3 targets for campaign ID 49440: 3 updated, 0 added, 0 deleted 2011-07-20 23:06:44.694 (3) [P1T1]: Synchronized 4 targets for campaign ID 33769: 4 updated, 0 added, 0 deleted 2011-07-20 23:06:44.854 (3) [P1T1]: Synchronized 5 targets for campaign ID 33985: 5 updated, 0 added, 0 deleted 2011-07-20 23:06:45.086 (3) [P1T1]: Synchronized 4 targets for campaign ID 33695: 4 updated, 0 added, 0 deleted 2011-07-20 23:06:45.372 (3) [P1T1]: Synchronized 4 targets for campaign ID 40223: 4 updated, 0 added, 0 deleted 2011-07-20 23:06:45.493 (3) [P1T1]: Synchronized 4 targets for campaign ID 4465: 4 updated, 0 added, 0 deleted 2011-07-20 23:06:45.587 (3) [P1T1]: Synchronized 5 targets for campaign ID 32704: 5 updated, 0 added, 0 deleted 2011-07-20 23:06:45.661 (3) [P1T1]: Synchronized 4 targets for campaign ID 49443: 4 updated, 0 added, 0 deleted 2011-07-20 23:06:46.033 (3) [P1T1]: Synchronized 16 targets for campaign ID 43: 16 updated, 0 added, 0 deleted 2011-07-20 23:06:46.105 (3) [P1T1]: Synchronized 3 targets for campaign ID 8813: 3 updated, 0 added, 0 deleted 2011-07-20 23:06:46.302 (3) [P1T1]: Synchronized 5 targets for campaign ID 33984: 5 updated, 0 added, 0 deleted 2011-07-20 23:06:46.388 (3) [P1T1]: Synchronized 5 targets for campaign ID 40311: 5 updated, 0 added, 0 deleted 2011-07-20 23:06:46.470 (3) [P1T1]: Synchronized 3 targets for campaign ID 32951: 3 updated, 0 added, 0 deleted 2011-07-20 23:06:46.748 (3) [P1T1]: Synchronized 3 targets for campaign ID 33770: 3 updated, 0 added, 0 deleted 2011-07-20 23:06:46.832 (3) [P1T1]: Synchronized 4 targets for campaign ID 33696: 4 updated, 0 added, 0 deleted 2011-07-20 23:06:46.916 (3) [P1T1]: Synchronized 5 targets for campaign ID 33861: 5 updated, 0 added, 0 deleted 2011-07-20 23:06:47.130 (3) [P1T1]: Synchronized 4 targets for campaign ID 33656: 4 updated, 0 added, 0 deleted 2011-07-20 23:06:47.223 (3) [P1T1]: Synchronized 5 targets for campaign ID 40593: 5 updated, 0 added, 0 deleted 2011-07-20 23:06:47.402 (3) [P1T1]: Synchronized 5 targets for campaign ID 36285: 5 updated, 0 added, 0 deleted 2011-07-20 23:06:47.547 (3) [P1T1]: Synchronized 3 targets for campaign ID 33652: 3 updated, 0 added, 0 deleted 2011-07-20 23:06:47.753 (3) [P1T1]: Synchronized 5 targets for campaign ID 33903: 5 updated, 0 added, 0 deleted 2011-07-20 23:06:48.016 (3) [P1T1]: DatabasePool with a limit of 80 created 2011-07-20 23:06:48.780 (3) [P1T1]: Synchronized 5 targets for campaign ID 40498: 5 updated, 0 added, 0 deleted 2011-07-20 23:06:48.968 (3) [P1T1]: Synchronized 5 targets for campaign ID 40339: 5 updated, 0 added, 0 deleted 2011-07-20 23:06:49.180 (3) [P1T1]: Accounts: 0 added, 0 modified, 0 disabled. 2011-07-20 23:06:49.244 (3) [P1T1]: Finished User (8) "WWMW - Cellular Safety Commission" 2011-07-20 23:06:51.719 (3) [main]: ------------Search Engine Updater done 2011-07-20 23:06:51.731 (3) [main]: ----------------SearchEngineSyncUserWorker starting 2011-07-20 23:06:52.527 (3) [P2T1]: DatabasePool with a limit of 80 created 2011-07-20 23:06:52.756 (3) [P2T1]: -- Bulk downloads supported. 2011-07-20 23:06:52.758 (3) [P2T1]: -- Begining search engine sync for user: (8) "WWMW - Cellular Safety Commission" 2011-07-20 23:06:53.275 (3) [P2T1]: DatabasePool with a limit of 80 created 2011-07-20 23:06:53.615 (2) [P2T1]: Created KeywordStructureSyncCriterion, db is googleKeywords 2011-07-20 23:06:53.627 (2) [P2T1]: Created CreativeStructureSyncCriterion 2011-07-20 23:06:53.639 (2) [P2T1]: googleKeywords 2011-07-20 23:06:54.027 (2) [P2T1]: Added Keyword Performance Report AdGroupId to secondaryKeys 2011-07-20 23:06:54.027 (2) [P2T1]: Added Adgroup Performance Report AdGroupId to secondaryKeys 2011-07-20 23:06:54.027 (2) [P2T1]: Added Managed Placement Performance Report AdGroupId to secondaryKeys 2011-07-20 23:06:54.027 (2) [P2T1]: Getting columns for : Managed Placement Performance Report 2011-07-20 23:06:54.027 (2) [P2T1]: Got : CampaignId 2011-07-20 23:06:54.027 (2) [P2T1]: Got : AdGroupId 2011-07-20 23:06:54.031 (2) [P2T1]: Got : AdGroupStatus 2011-07-20 23:06:54.031 (2) [P2T1]: Got : MaxCpc 2011-07-20 23:06:54.031 (2) [P2T1]: Got : MaxCpm 2011-07-20 23:06:54.031 (2) [P2T1]: Got : KeywordMatchType 2011-07-20 23:06:54.031 (2) [P2T1]: Got : Status 2011-07-20 23:06:54.031 (2) [P2T1]: Got : DestinationUrl 2011-07-20 23:06:54.031 (2) [P2T1]: Got : IsNegative 2011-07-20 23:06:54.031 (2) [P2T1]: Got : PlacementUrl 2011-07-20 23:06:54.031 (2) [P2T1]: Got : Id 2011-07-20 23:06:54.043 (2) [P2T1]: YESTERDAYMANAGED_PLACEMENTS_PERFORMANCE_REPORTCampaignIdAdGroupIdAdGroupStatusMaxCpcMaxCpmKeywordMatchTypeStatusDestinationUrlIsNegativePlacementUrlId -484d3bf959c59d54610f8b25330785be 2011-07-20 23:06:54.071 (2) [P2T1]: Definition found in db: true for hash: -484d3bf959c59d54610f8b25330785be and account: 4191136789 2011-07-20 23:06:54.575 (2) [P2T1]: Getting columns for : Keyword Performance Report 2011-07-20 23:06:54.575 (2) [P2T1]: Got : CampaignId 2011-07-20 23:06:54.575 (2) [P2T1]: Got : AdGroupId 2011-07-20 23:06:54.575 (2) [P2T1]: Got : AdGroupStatus 2011-07-20 23:06:54.575 (2) [P2T1]: Got : MaxCpc 2011-07-20 23:06:54.575 (2) [P2T1]: Got : MaxCpm 2011-07-20 23:06:54.575 (2) [P2T1]: Got : KeywordMatchType 2011-07-20 23:06:54.575 (2) [P2T1]: Got : Status 2011-07-20 23:06:54.578 (2) [P2T1]: Got : DestinationUrl 2011-07-20 23:06:54.578 (2) [P2T1]: Got : IsNegative 2011-07-20 23:06:54.578 (2) [P2T1]: Got : KeywordText 2011-07-20 23:06:54.579 (2) [P2T1]: Got : Id 2011-07-20 23:06:54.579 (2) [P2T1]: YESTERDAYKEYWORDS_PERFORMANCE_REPORTCampaignIdAdGroupIdAdGroupStatusMaxCpcMaxCpmKeywordMatchTypeStatusDestinationUrlIsNegativeKeywordTextId 296d860661f7b19d8997e600e5c20868 2011-07-20 23:06:54.607 (2) [P2T1]: Definition found in db: true for hash: 296d860661f7b19d8997e600e5c20868 and account: 4191136789 2011-07-20 23:06:55.067 (2) [P2T1]: Getting columns for : Adgroup Performance Report 2011-07-20 23:06:55.067 (2) [P2T1]: Got : AdGroupName 2011-07-20 23:06:55.067 (2) [P2T1]: Got : KeywordContentMaxCpc 2011-07-20 23:06:55.067 (2) [P2T1]: Got : ProxyKeywordMaxCpc 2011-07-20 23:06:55.067 (2) [P2T1]: Got : MaxCpm 2011-07-20 23:06:55.070 (2) [P2T1]: Got : SiteMaxCpc 2011-07-20 23:06:55.070 (2) [P2T1]: Got : AdGroupId 2011-07-20 23:06:55.071 (2) [P2T1]: YESTERDAYADGROUP_PERFORMANCE_REPORTAdGroupNameKeywordContentMaxCpcProxyKeywordMaxCpcMaxCpmSiteMaxCpcAdGroupId 14ccfec5d95fbfdfc5160479d0dc93c3 2011-07-20 23:06:55.095 (2) [P2T1]: Definition found in db: true for hash: 14ccfec5d95fbfdfc5160479d0dc93c3 and account: 4191136789 2011-07-20 23:06:55.591 (2) [DownloaderT1]: Downloading report : Managed Placement Performance Report 2011-07-20 23:06:55.591 (3) [DownloaderT1]: Scheduling report attempt 1: ReportID=59466851 2011-07-20 23:06:55.627 (2) [DownloaderT2]: Downloading report : Keyword Performance Report 2011-07-20 23:06:55.627 (3) [DownloaderT2]: Scheduling report attempt 1: ReportID=50467811 2011-07-20 23:06:55.663 (2) [DownloaderT3]: Downloading report : Adgroup Performance Report 2011-07-20 23:06:55.663 (3) [DownloaderT3]: Scheduling report attempt 1: ReportID=50377331 2011-07-20 23:06:56.539 (2) [DownloaderT1]: OK 2011-07-20 23:06:56.543 (2) [DownloaderT2]: OK 2011-07-20 23:06:56.547 (2) [DownloaderT3]: OK 2011-07-20 23:06:56.551 (2) [DownloaderT3]: Report : Adgroup Performance Report downloaded. 2011-07-20 23:06:56.599 (2) [DownloaderT3]: Report : Adgroup Performance Report is valid : true 2011-07-20 23:06:56.599 (2) [DownloaderT1]: Report : Managed Placement Performance Report downloaded. 2011-07-20 23:06:56.679 (2) [DownloaderT1]: Report : Managed Placement Performance Report is valid : true 2011-07-20 23:06:56.859 (2) [DownloaderT2]: Report : Keyword Performance Report downloaded. 2011-07-20 23:06:57.143 (2) [DownloaderT2]: Report : Keyword Performance Report is valid : true 2011-07-20 23:06:57.194 (2) [P2T1]: Downloaded and validated Managed Placement Performance Report 3426 bytes. 2011-07-20 23:06:57.195 (2) [P2T1]: Downloaded and validated Keyword Performance Report 13070 bytes. 2011-07-20 23:06:57.195 (2) [P2T1]: Downloaded and validated Adgroup Performance Report 1980 bytes. 2011-07-20 23:06:57.207 (2) [P2T1]: Parsing report as secondary report: Adgroup Performance Report 2011-07-20 23:06:57.219 (3) [P2T1]: parsing columns for Adgroup Performance Report 2011-07-20 23:06:57.251 (3) [P2T1]: parsing rows for Adgroup Performance Report 2011-07-20 23:06:57.350 (2) [P2T1]: Finished parsing report: Adgroup Performance Report 2011-07-20 23:06:57.359 (2) [P2T1]: Parsing report as primary report: Managed Placement Performance Report with 113382568 bytes free 2011-07-20 23:06:57.390 (3) [P2T1]: parsing columns for Managed Placement Performance Report 2011-07-20 23:06:57.395 (3) [P2T1]: Columns already defined 2011-07-20 23:06:57.458 (3) [P2T1]: parsing rows for Managed Placement Performance Report 2011-07-20 23:06:57.487 (2) [MergeT1]: null or "--" to be inserted in report, GoogleReportingTool.getTSVReportStream 2011-07-20 23:06:57.491 (2) [MergeT1]: null or "--" to be inserted in report, GoogleReportingTool.getTSVReportStream 2011-07-20 23:06:57.498 (2) [MergeT1]: null or "--" to be inserted in report, GoogleReportingTool.getTSVReportStream 2011-07-20 23:06:57.503 (2) [MergeT1]: null or "--" to be inserted in report, GoogleReportingTool.getTSVReportStream 2011-07-20 23:06:57.507 (2) [MergeT1]: null or "--" to be inserted in report, GoogleReportingTool.getTSVReportStream 2011-07-20 23:06:57.514 (2) [MergeT1]: null or "--" to be inserted in report, GoogleReportingTool.getTSVReportStream 2011-07-20 23:06:57.518 (2) [MergeT1]: null or "--" to be inserted in report, GoogleReportingTool.getTSVReportStream 2011-07-20 23:06:57.523 (2) [MergeT1]: null or "--" to be inserted in report, GoogleReportingTool.getTSVReportStream 2011-07-20 23:06:57.547 (2) [MergeT1]: null or "--" to be inserted in report, GoogleReportingTool.getTSVReportStream 2011-07-20 23:06:57.554 (2) [MergeT1]: null or "--" to be inserted in report, GoogleReportingTool.getTSVReportStream 2011-07-20 23:06:57.559 (2) [MergeT1]: null or "--" to be inserted in report, GoogleReportingTool.getTSVReportStream 2011-07-20 23:06:57.578 (2) [MergeT1]: null or "--" to be inserted in report, GoogleReportingTool.getTSVReportStream 2011-07-20 23:06:57.583 (2) [MergeT1]: null or "--" to be inserted in report, GoogleReportingTool.getTSVReportStream 2011-07-20 23:06:57.587 (2) [MergeT1]: null or "--" to be inserted in report, GoogleReportingTool.getTSVReportStream 2011-07-20 23:06:57.591 (2) [MergeT1]: null or "--" to be inserted in report, GoogleReportingTool.getTSVReportStream 2011-07-20 23:06:57.598 (2) [MergeT1]: null or "--" to be inserted in report, GoogleReportingTool.getTSVReportStream 2011-07-20 23:06:57.602 (2) [MergeT1]: null or "--" to be inserted in report, GoogleReportingTool.getTSVReportStream 2011-07-20 23:06:57.607 (2) [MergeT1]: null or "--" to be inserted in report, GoogleReportingTool.getTSVReportStream 2011-07-20 23:06:57.611 (2) [MergeT1]: null or "--" to be inserted in report, GoogleReportingTool.getTSVReportStream 2011-07-20 23:06:57.615 (2) [MergeT1]: null or "--" to be inserted in report, GoogleReportingTool.getTSVReportStream 2011-07-20 23:06:57.622 (2) [MergeT1]: null or "--" to be inserted in report, GoogleReportingTool.getTSVReportStream 2011-07-20 23:06:57.628 (2) [MergeT1]: null or "--" to be inserted in report, GoogleReportingTool.getTSVReportStream 2011-07-20 23:06:57.631 (2) [MergeT1]: null or "--" to be inserted in report, GoogleReportingTool.getTSVReportStream 2011-07-20 23:06:57.638 (2) [MergeT1]: null or "--" to be inserted in report, GoogleReportingTool.getTSVReportStream 2011-07-20 23:06:57.639 (2) [MergeT1]: null or "--" to be inserted in report, GoogleReportingTool.getTSVReportStream 2011-07-20 23:06:57.643 (2) [MergeT1]: null or "--" to be inserted in report, GoogleReportingTool.getTSVReportStream 2011-07-20 23:06:57.647 (2) [MergeT1]: null or "--" to be inserted in report, GoogleReportingTool.getTSVReportStream 2011-07-20 23:06:57.651 (2) [MergeT1]: null or "--" to be inserted in report, GoogleReportingTool.getTSVReportStream 2011-07-20 23:06:57.654 (2) [MergeT1]: null or "--" to be inserted in report, GoogleReportingTool.getTSVReportStream 2011-07-20 23:06:57.659 (2) [MergeT1]: null or "--" to be inserted in report, GoogleReportingTool.getTSVReportStream 2011-07-20 23:06:57.664 (2) [MergeT1]: null or "--" to be inserted in report, GoogleReportingTool.getTSVReportStream 2011-07-20 23:06:57.667 (2) [MergeT1]: null or "--" to be inserted in report, GoogleReportingTool.getTSVReportStream 2011-07-20 23:06:57.674 (2) [MergeT1]: null or "--" to be inserted in report, GoogleReportingTool.getTSVReportStream 2011-07-20 23:06:57.675 (2) [MergeT1]: null or "--" to be inserted in report, GoogleReportingTool.getTSVReportStream 2011-07-20 23:06:57.679 (2) [MergeT1]: null or "--" to be inserted in report, GoogleReportingTool.getTSVReportStream 2011-07-20 23:06:57.683 (2) [MergeT1]: null or "--" to be inserted in report, GoogleReportingTool.getTSVReportStream 2011-07-20 23:06:57.687 (2) [MergeT1]: null or "--" to be inserted in report, GoogleReportingTool.getTSVReportStream 2011-07-20 23:06:57.690 (2) [MergeT1]: null or "--" to be inserted in report, GoogleReportingTool.getTSVReportStream 2011-07-20 23:06:57.695 (2) [MergeT1]: null or "--" to be inserted in report, GoogleReportingTool.getTSVReportStream 2011-07-20 23:06:57.699 (2) [MergeT1]: null or "--" to be inserted in report, GoogleReportingTool.getTSVReportStream 2011-07-20 23:06:57.702 (2) [MergeT1]: null or "--" to be inserted in report, GoogleReportingTool.getTSVReportStream 2011-07-20 23:06:57.707 (2) [MergeT1]: null or "--" to be inserted in report, GoogleReportingTool.getTSVReportStream 2011-07-20 23:06:57.712 (2) [MergeT1]: null or "--" to be inserted in report, GoogleReportingTool.getTSVReportStream 2011-07-20 23:06:57.718 (2) [MergeT1]: null or "--" to be inserted in report, GoogleReportingTool.getTSVReportStream 2011-07-20 23:06:57.722 (2) [MergeT1]: null or "--" to be inserted in report, GoogleReportingTool.getTSVReportStream 2011-07-20 23:06:57.723 (2) [MergeT1]: null or "--" to be inserted in report, GoogleReportingTool.getTSVReportStream 2011-07-20 23:06:57.727 (2) [MergeT1]: null or "--" to be inserted in report, GoogleReportingTool.getTSVReportStream 2011-07-20 23:06:57.731 (2) [MergeT1]: null or "--" to be inserted in report, GoogleReportingTool.getTSVReportStream 2011-07-20 23:06:57.735 (2) [MergeT1]: null or "--" to be inserted in report, GoogleReportingTool.getTSVReportStream 2011-07-20 23:06:57.736 (2) [MergeT1]: null or "--" to be inserted in report, GoogleReportingTool.getTSVReportStream 2011-07-20 23:06:57.742 (2) [MergeT1]: null or "--" to be inserted in report, GoogleReportingTool.getTSVReportStream 2011-07-20 23:06:57.746 (2) [MergeT1]: null or "--" to be inserted in report, GoogleReportingTool.getTSVReportStream 2011-07-20 23:06:57.748 (2) [MergeT1]: null or "--" to be inserted in report, GoogleReportingTool.getTSVReportStream 2011-07-20 23:06:57.751 (2) [MergeT1]: null or "--" to be inserted in report, GoogleReportingTool.getTSVReportStream 2011-07-20 23:06:57.802 (2) [P2T1]: Waiting for workers to die. 2011-07-20 23:06:57.862 (2) [MergeT1]: null or "--" to be inserted in report, GoogleReportingTool.getTSVReportStream 2011-07-20 23:06:57.866 (2) [MergeT1]: null or "--" to be inserted in report, GoogleReportingTool.getTSVReportStream 2011-07-20 23:06:57.868 (2) [MergeT1]: null or "--" to be inserted in report, GoogleReportingTool.getTSVReportStream 2011-07-20 23:06:57.871 (2) [MergeT1]: null or "--" to be inserted in report, GoogleReportingTool.getTSVReportStream 2011-07-20 23:06:57.878 (2) [MergeT1]: null or "--" to be inserted in report, GoogleReportingTool.getTSVReportStream 2011-07-20 23:06:57.879 (2) [MergeT1]: null or "--" to be inserted in report, GoogleReportingTool.getTSVReportStream 2011-07-20 23:06:57.883 (2) [MergeT1]: null or "--" to be inserted in report, GoogleReportingTool.getTSVReportStream 2011-07-20 23:06:57.891 (2) [MergeT1]: null or "--" to be inserted in report, GoogleReportingTool.getTSVReportStream 2011-07-20 23:06:57.892 (2) [MergeT1]: null or "--" to be inserted in report, GoogleReportingTool.getTSVReportStream 2011-07-20 23:06:57.898 (2) [MergeT1]: null or "--" to be inserted in report, GoogleReportingTool.getTSVReportStream 2011-07-20 23:06:57.902 (2) [MergeT1]: null or "--" to be inserted in report, GoogleReportingTool.getTSVReportStream 2011-07-20 23:06:57.904 (2) [MergeT1]: null or "--" to be inserted in report, GoogleReportingTool.getTSVReportStream 2011-07-20 23:06:57.910 (2) [MergeT1]: null or "--" to be inserted in report, GoogleReportingTool.getTSVReportStream 2011-07-20 23:06:57.914 (2) [MergeT1]: null or "--" to be inserted in report, GoogleReportingTool.getTSVReportStream 2011-07-20 23:06:57.916 (2) [MergeT1]: null or "--" to be inserted in report, GoogleReportingTool.getTSVReportStream 2011-07-20 23:06:57.919 (2) [MergeT1]: null or "--" to be inserted in report, GoogleReportingTool.getTSVReportStream 2011-07-20 23:06:57.926 (2) [MergeT1]: null or "--" to be inserted in report, GoogleReportingTool.getTSVReportStream 2011-07-20 23:06:57.928 (2) [MergeT1]: null or "--" to be inserted in report, GoogleReportingTool.getTSVReportStream 2011-07-20 23:06:57.931 (2) [MergeT1]: null or "--" to be inserted in report, GoogleReportingTool.getTSVReportStream 2011-07-20 23:06:57.947 (2) [MergeT1]: null or "--" to be inserted in report, GoogleReportingTool.getTSVReportStream 2011-07-20 23:06:57.950 (2) [MergeT1]: null or "--" to be inserted in report, GoogleReportingTool.getTSVReportStream 2011-07-20 23:06:57.952 (2) [MergeT1]: null or "--" to be inserted in report, GoogleReportingTool.getTSVReportStream 2011-07-20 23:06:57.958 (2) [MergeT1]: null or "--" to be inserted in report, GoogleReportingTool.getTSVReportStream 2011-07-20 23:06:57.962 (2) [MergeT1]: null or "--" to be inserted in report, GoogleReportingTool.getTSVReportStream 2011-07-20 23:06:57.975 (2) [MergeT1]: null or "--" to be inserted in report, GoogleReportingTool.getTSVReportStream 2011-07-20 23:06:57.983 (2) [MergeT1]: null or "--" to be inserted in report, GoogleReportingTool.getTSVReportStream 2011-07-20 23:06:57.987 (2) [MergeT1]: null or "--" to be inserted in report, GoogleReportingTool.getTSVReportStream 2011-07-20 23:06:57.991 (2) [MergeT1]: null or "--" to be inserted in report, GoogleReportingTool.getTSVReportStream 2011-07-20 23:06:57.995 (2) [MergeT1]: null or "--" to be inserted in report, GoogleReportingTool.getTSVReportStream 2011-07-20 23:06:57.999 (2) [MergeT1]: null or "--" to be inserted in report, GoogleReportingTool.getTSVReportStream 2011-07-20 23:06:58.010 (2) [MergeT1]: null or "--" to be inserted in report, GoogleReportingTool.getTSVReportStream 2011-07-20 23:06:58.014 (2) [MergeT1]: null or "--" to be inserted in report, GoogleReportingTool.getTSVReportStream 2011-07-20 23:06:58.034 (2) [MergeT1]: null or "--" to be inserted in report, GoogleReportingTool.getTSVReportStream 2011-07-20 23:06:58.047 (2) [MergeT1]: null or "--" to be inserted in report, GoogleReportingTool.getTSVReportStream 2011-07-20 23:06:58.050 (2) [MergeT1]: null or "--" to be inserted in report, GoogleReportingTool.getTSVReportStream 2011-07-20 23:06:58.055 (2) [MergeT1]: null or "--" to be inserted in report, GoogleReportingTool.getTSVReportStream 2011-07-20 23:06:58.060 (2) [MergeT1]: null or "--" to be inserted in report, GoogleReportingTool.getTSVReportStream 2011-07-20 23:06:58.070 (2) [MergeT1]: null or "--" to be inserted in report, GoogleReportingTool.getTSVReportStream 2011-07-20 23:06:58.072 (2) [MergeT1]: null or "--" to be inserted in report, GoogleReportingTool.getTSVReportStream 2011-07-20 23:06:58.078 (2) [MergeT1]: null or "--" to be inserted in report, GoogleReportingTool.getTSVReportStream 2011-07-20 23:06:58.082 (2) [MergeT1]: null or "--" to be inserted in report, GoogleReportingTool.getTSVReportStream 2011-07-20 23:06:58.086 (2) [MergeT1]: null or "--" to be inserted in report, GoogleReportingTool.getTSVReportStream 2011-07-20 23:06:58.102 (2) [MergeT1]: null or "--" to be inserted in report, GoogleReportingTool.getTSVReportStream 2011-07-20 23:06:58.106 (2) [MergeT1]: null or "--" to be inserted in report, GoogleReportingTool.getTSVReportStream 2011-07-20 23:06:58.108 (2) [MergeT1]: null or "--" to be inserted in report, GoogleReportingTool.getTSVReportStream 2011-07-20 23:06:58.114 (2) [MergeT1]: null or "--" to be inserted in report, GoogleReportingTool.getTSVReportStream 2011-07-20 23:06:58.118 (2) [MergeT1]: null or "--" to be inserted in report, GoogleReportingTool.getTSVReportStream 2011-07-20 23:06:58.119 (2) [MergeT1]: null or "--" to be inserted in report, GoogleReportingTool.getTSVReportStream 2011-07-20 23:06:58.123 (2) [MergeT1]: fixing an auto google inserted : auto: 0.05 2011-07-20 23:06:58.123 (2) [MergeT1]: null or "--" to be inserted in report, GoogleReportingTool.getTSVReportStream 2011-07-20 23:06:58.126 (2) [MergeT1]: fixing an auto google inserted : auto: 0.05 2011-07-20 23:06:58.127 (2) [MergeT1]: fixing an auto google inserted : auto: 0.05 2011-07-20 23:06:58.130 (2) [MergeT1]: null or "--" to be inserted in report, GoogleReportingTool.getTSVReportStream 2011-07-20 23:06:58.132 (2) [MergeT1]: null or "--" to be inserted in report, GoogleReportingTool.getTSVReportStream 2011-07-20 23:06:58.138 (2) [MergeT1]: null or "--" to be inserted in report, GoogleReportingTool.getTSVReportStream 2011-07-20 23:06:58.144 (2) [MergeT1]: null or "--" to be inserted in report, GoogleReportingTool.getTSVReportStream 2011-07-20 23:06:58.147 (2) [MergeT1]: null or "--" to be inserted in report, GoogleReportingTool.getTSVReportStream 2011-07-20 23:06:58.154 (2) [MergeT1]: null or "--" to be inserted in report, GoogleReportingTool.getTSVReportStream 2011-07-20 23:06:58.155 (2) [MergeT1]: null or "--" to be inserted in report, GoogleReportingTool.getTSVReportStream 2011-07-20 23:06:58.159 (2) [MergeT1]: null or "--" to be inserted in report, GoogleReportingTool.getTSVReportStream 2011-07-20 23:06:58.166 (2) [MergeT1]: null or "--" to be inserted in report, GoogleReportingTool.getTSVReportStream 2011-07-20 23:06:58.168 (2) [MergeT1]: null or "--" to be inserted in report, GoogleReportingTool.getTSVReportStream 2011-07-20 23:06:58.171 (2) [MergeT1]: null or "--" to be inserted in report, GoogleReportingTool.getTSVReportStream 2011-07-20 23:06:58.178 (2) [MergeT1]: null or "--" to be inserted in report, GoogleReportingTool.getTSVReportStream 2011-07-20 23:06:58.180 (2) [MergeT1]: null or "--" to be inserted in report, GoogleReportingTool.getTSVReportStream 2011-07-20 23:06:58.183 (2) [MergeT1]: null or "--" to be inserted in report, GoogleReportingTool.getTSVReportStream 2011-07-20 23:06:58.190 (2) [MergeT1]: null or "--" to be inserted in report, GoogleReportingTool.getTSVReportStream 2011-07-20 23:06:58.192 (2) [MergeT1]: null or "--" to be inserted in report, GoogleReportingTool.getTSVReportStream 2011-07-20 23:06:58.195 (2) [MergeT1]: null or "--" to be inserted in report, GoogleReportingTool.getTSVReportStream 2011-07-20 23:06:58.199 (2) [MergeT1]: fixing an auto google inserted : auto: 0.05 2011-07-20 23:06:58.202 (2) [MergeT1]: null or "--" to be inserted in report, GoogleReportingTool.getTSVReportStream 2011-07-20 23:06:58.202 (2) [MergeT1]: fixing an auto google inserted : auto: 0.05 2011-07-20 23:06:58.203 (2) [MergeT1]: fixing an auto google inserted : auto: 0.05 2011-07-20 23:06:58.206 (2) [MergeT1]: null or "--" to be inserted in report, GoogleReportingTool.getTSVReportStream 2011-07-20 23:06:58.212 (2) [MergeT1]: null or "--" to be inserted in report, GoogleReportingTool.getTSVReportStream 2011-07-20 23:06:58.218 (2) [MergeT1]: null or "--" to be inserted in report, GoogleReportingTool.getTSVReportStream 2011-07-20 23:06:58.223 (2) [MergeT1]: null or "--" to be inserted in report, GoogleReportingTool.getTSVReportStream 2011-07-20 23:06:58.227 (2) [MergeT1]: null or "--" to be inserted in report, GoogleReportingTool.getTSVReportStream 2011-07-20 23:06:58.235 (2) [MergeT1]: null or "--" to be inserted in report, GoogleReportingTool.getTSVReportStream 2011-07-20 23:06:58.306 (2) [P2T1]: Finished parsing report: Managed Placement Performance Report 2011-07-20 23:06:58.307 (2) [P2T1]: Parsing report as primary report: Keyword Performance Report with 108221104 bytes free 2011-07-20 23:06:58.331 (3) [P2T1]: parsing columns for Keyword Performance Report 2011-07-20 23:06:58.335 (3) [P2T1]: Columns already defined 2011-07-20 23:06:58.651 (3) [P2T1]: parsing rows for Keyword Performance Report 2011-07-20 23:07:01.312 (2) [P2T1]: Waiting for workers to die. 2011-07-20 23:07:01.843 (2) [P2T1]: Waiting for workers to die. 2011-07-20 23:07:01.887 (2) [MergeT2]: fixing an auto google inserted : auto: 1.00 2011-07-20 23:07:01.895 (2) [MergeT2]: fixing an auto google inserted : auto: 1.00 2011-07-20 23:07:01.899 (2) [MergeT1]: fixing an auto google inserted : auto: 1.00 2011-07-20 23:07:01.899 (2) [MergeT1]: fixing an auto google inserted : auto: 1.00 2011-07-20 23:07:01.903 (2) [MergeT1]: fixing an auto google inserted : auto: 1.00 2011-07-20 23:07:01.907 (2) [MergeT2]: fixing an auto google inserted : auto: 1.00 2011-07-20 23:07:01.907 (2) [MergeT2]: fixing an auto google inserted : auto: 1.00 2011-07-20 23:07:01.911 (2) [MergeT2]: fixing an auto google inserted : auto: 1.00 2011-07-20 23:07:01.915 (2) [MergeT1]: fixing an auto google inserted : auto: 1.00 2011-07-20 23:07:01.919 (2) [MergeT1]: fixing an auto google inserted : auto: 1.00 2011-07-20 23:07:01.923 (2) [MergeT2]: fixing an auto google inserted : auto: 1.00 2011-07-20 23:07:01.927 (2) [MergeT2]: fixing an auto google inserted : auto: 1.00 2011-07-20 23:07:01.931 (2) [MergeT1]: fixing an auto google inserted : auto: 1.00 2011-07-20 23:07:01.935 (2) [MergeT1]: fixing an auto google inserted : auto: 1.00 2011-07-20 23:07:01.935 (2) [MergeT1]: fixing an auto google inserted : auto: 1.00 2011-07-20 23:07:01.939 (2) [MergeT2]: fixing an auto google inserted : auto: 1.00 2011-07-20 23:07:01.943 (2) [MergeT2]: fixing an auto google inserted : auto: 1.00 2011-07-20 23:07:01.943 (2) [MergeT2]: fixing an auto google inserted : auto: 1.00 2011-07-20 23:07:01.947 (2) [MergeT1]: fixing an auto google inserted : auto: 1.00 2011-07-20 23:07:01.951 (2) [MergeT1]: fixing an auto google inserted : auto: 1.00 2011-07-20 23:07:01.955 (2) [MergeT2]: fixing an auto google inserted : auto: 1.00 2011-07-20 23:07:01.959 (2) [MergeT2]: fixing an auto google inserted : auto: 1.00 2011-07-20 23:07:01.963 (2) [MergeT1]: fixing an auto google inserted : auto: 1.00 2011-07-20 23:07:01.967 (2) [MergeT1]: fixing an auto google inserted : auto: 1.00 2011-07-20 23:07:01.971 (2) [MergeT2]: fixing an auto google inserted : auto: 1.00 2011-07-20 23:07:01.975 (2) [MergeT2]: fixing an auto google inserted : auto: 1.00 2011-07-20 23:07:01.979 (2) [MergeT1]: fixing an auto google inserted : auto: 1.00 2011-07-20 23:07:01.979 (2) [MergeT1]: fixing an auto google inserted : auto: 1.00 2011-07-20 23:07:01.983 (2) [MergeT1]: fixing an auto google inserted : auto: 1.00 2011-07-20 23:07:01.987 (2) [MergeT2]: fixing an auto google inserted : auto: 1.00 2011-07-20 23:07:01.991 (2) [MergeT2]: fixing an auto google inserted : auto: 1.00 2011-07-20 23:07:01.992 (2) [MergeT2]: fixing an auto google inserted : auto: 1.00 2011-07-20 23:07:01.995 (2) [MergeT2]: fixing an auto google inserted : auto: 1.00 2011-07-20 23:07:01.999 (2) [MergeT1]: fixing an auto google inserted : auto: 1.00 2011-07-20 23:07:02.003 (2) [MergeT1]: fixing an auto google inserted : auto: 1.00 2011-07-20 23:07:02.015 (2) [MergeT1]: fixing an auto google inserted : auto: 1.00 2011-07-20 23:07:02.548 (2) [P2T1]: Waiting for workers to die. 2011-07-20 23:07:03.057 (2) [P2T1]: Waiting for workers to die. 2011-07-20 23:07:03.078 (2) [MergeT1]: fixing an auto google inserted : auto: 0.05 2011-07-20 23:07:03.082 (2) [MergeT2]: fixing an auto google inserted : auto: 0.05 2011-07-20 23:07:03.084 (2) [MergeT2]: fixing an auto google inserted : auto: 0.05 2011-07-20 23:07:03.084 (2) [MergeT2]: fixing an auto google inserted : auto: 0.05 2011-07-20 23:07:03.087 (2) [MergeT2]: fixing an auto google inserted : auto: 0.05 2011-07-20 23:07:03.090 (2) [MergeT1]: fixing an auto google inserted : auto: 0.05 2011-07-20 23:07:03.090 (2) [MergeT1]: fixing an auto google inserted : auto: 0.05 2011-07-20 23:07:03.094 (2) [MergeT1]: fixing an auto google inserted : auto: 0.05 2011-07-20 23:07:03.096 (2) [MergeT1]: fixing an auto google inserted : auto: 0.05 2011-07-20 23:07:03.096 (2) [MergeT1]: fixing an auto google inserted : auto: 0.05 2011-07-20 23:07:03.099 (2) [MergeT2]: fixing an auto google inserted : auto: 0.05 2011-07-20 23:07:03.100 (2) [MergeT2]: fixing an auto google inserted : auto: 0.05 2011-07-20 23:07:03.216 (2) [MergeT2]: fixing an auto google inserted : auto: 0.05 2011-07-20 23:07:03.226 (2) [MergeT2]: fixing an auto google inserted : auto: 0.05 2011-07-20 23:07:03.227 (2) [MergeT2]: fixing an auto google inserted : auto: 0.05 2011-07-20 23:07:03.559 (2) [P2T1]: Finished parsing report: Keyword Performance Report 2011-07-20 23:07:06.573 (2) [P2T1]: Created temp file: /var/local/tsa/google_sync_files/tsa-keyword-structure-report--8-2011-07-20 23:06:5348287.tmp 2011-07-20 23:07:06.577 (2) [P2T1]: googleAds 2011-07-20 23:07:06.581 (2) [P2T1]: Getting columns for : Ad Performance Report 2011-07-20 23:07:06.581 (2) [P2T1]: Got : CampaignId 2011-07-20 23:07:06.582 (2) [P2T1]: Got : AdGroupId 2011-07-20 23:07:06.585 (2) [P2T1]: Got : Headline 2011-07-20 23:07:06.585 (2) [P2T1]: Got : Description1 2011-07-20 23:07:06.585 (2) [P2T1]: Got : Description2 2011-07-20 23:07:06.585 (2) [P2T1]: Got : DisplayUrl 2011-07-20 23:07:06.585 (2) [P2T1]: Got : Id 2011-07-20 23:07:06.585 (2) [P2T1]: Got : AdType 2011-07-20 23:07:06.585 (2) [P2T1]: Got : Status 2011-07-20 23:07:06.585 (2) [P2T1]: Got : CreativeDestinationUrl 2011-07-20 23:07:06.589 (2) [P2T1]: YESTERDAYAD_PERFORMANCE_REPORTCampaignIdAdGroupIdHeadlineDescription1Description2DisplayUrlIdAdTypeStatusCreativeDestinationUrl -5ecc211c13cec065600706929725b2b8 2011-07-20 23:07:06.621 (2) [P2T1]: Definition found in db: true for hash: -5ecc211c13cec065600706929725b2b8 and account: 4191136789 2011-07-20 23:07:07.527 (2) [DownloaderT1]: Downloading report : Ad Performance Report 2011-07-20 23:07:07.531 (3) [DownloaderT1]: Scheduling report attempt 1: ReportID=50378531 2011-07-20 23:07:08.127 (2) [DownloaderT1]: OK 2011-07-20 23:07:08.131 (2) [DownloaderT1]: Report : Ad Performance Report downloaded. 2011-07-20 23:07:08.188 (2) [DownloaderT1]: Report : Ad Performance Report is valid : true 2011-07-20 23:07:08.295 (2) [P2T1]: Downloaded and validated Ad Performance Report 4545 bytes. 2011-07-20 23:07:08.299 (2) [P2T1]: Parsing report as primary report: Ad Performance Report with 114004032 bytes free 2011-07-20 23:07:08.307 (3) [P2T1]: parsing columns for Ad Performance Report 2011-07-20 23:07:08.359 (3) [P2T1]: parsing rows for Ad Performance Report 2011-07-20 23:07:08.587 (2) [P2T1]: Waiting for workers to die. 2011-07-20 23:07:09.092 (2) [P2T1]: Finished parsing report: Ad Performance Report 2011-07-20 23:07:11.100 (2) [P2T1]: Created temp file: /var/local/tsa/google_sync_files/tsa-creative-structure-report--8-2011-07-20 23:06:5348288.tmp 2011-07-20 23:07:11.100 (3) [P2T1]: -- Data staging complete for seuser ((8) "WWMW - Cellular Safety Commission") 2011-07-20 23:07:11.396 (3) [P2T1]: Loading data infile into temp table... 2011-07-20 23:07:11.428 (2) [P2T1]: Trying to load : /var/local/tsa/google_sync_files/tsa-keyword-structure-report--8-2011-07-20 23:06:5348287.tmp into `tmp`.`tmp3` 2011-07-20 23:07:11.696 (2) [P2T1]: Trying to load : /var/local/tsa/google_sync_files/tsa-creative-structure-report--8-2011-07-20 23:06:5348288.tmp into `tmp`.`tmp4` 2011-07-20 23:07:11.816 (3) [P2T1]: LOAD TEMP SYNC TABLES COMPLETED 2011-07-20 23:07:11.897 (3) [P2T1]: Campaigns with new items:([]) 2011-07-20 23:07:11.897 (3) [P2T1]: DETECTION OF NEW CAMPAIGN ITEMS COMPLETED 2011-07-20 23:07:11.936 (3) [P2T1]: Campaigns with deleted items:([]) 2011-07-20 23:07:11.936 (3) [P2T1]: DETECTION OF DELETED CAMPAIGN ITEMS COMPLETED 2011-07-20 23:07:12.040 (3) [P2T1]: Campaigns with updated items:([]) 2011-07-20 23:07:12.041 (3) [P2T1]: DETECTION OF UPDATED CAMPAIGN ITEMS COMPLETED 2011-07-20 23:07:12.092 (3) [P2T1]: 927 keyword records removed before re-loading staging table. 2011-07-20 23:07:12.120 (3) [P2T1]: 927 keyword records loaded into staging table. 2011-07-20 23:07:12.164 (3) [P2T1]: 144 creative ad records removed from staging table before re-loading. 2011-07-20 23:07:12.216 (3) [P2T1]: 144 creative ad records loaded into staging table. 2011-07-20 23:07:12.216 (3) [P2T1]: UPDATE OF STAGING TABLES COMPLETED 2011-07-20 23:07:12.220 (3) [P2T1]: Passing seUserAcctId: 17 and seAcctAcctId: 17 2011-07-20 23:07:12.492 (3) [P2T1]: Replicating 920 rows... 2011-07-20 23:07:12.760 (2) [P2T1]: Warning(s) detected in statement [SELECT RELEASE_LOCK('com.thesearchagency.searchengines.google.GoogleStructureSync.searchEngineUserID.8')] executed by user [spike] 2011-07-20 23:07:12.765 (2) [P2T1]: SQL Warning: Some non-transactional changed tables couldn't be rolled back (code:1196) com.carldunham.jst.db.transaction.TransactionException: error in GoogleStructureSync transaction at com.thesearchagency.searchengines.google.GoogleStructureSync$LoadTransaction.databaseCalls(GoogleStructureSync.java:2411) at com.carldunham.jst.db.SQLTransaction.execute(SQLTransaction.java:68) at com.thesearchagency.searchengines.google.GoogleStructureSync.getSearchEngineAccountsWithDifferences(GoogleStructureSync.java:280) at com.thesearchagency.searchengines.google.GoogleAPISearchEngine.getSearchEngineAccountsWithDifferences(GoogleAPISearchEngine.java:2216) at com.thesearchagency.searchengines.SearchEngineUpdater$SearchEngineSyncUserWorker.run(SearchEngineUpdater.java:3458) 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) Caused by: java.lang.NumberFormatException: null at java.lang.Integer.parseInt(Integer.java:415) at java.lang.Integer.(Integer.java:620) at com.thesearchagency.searchengines.google.GoogleStructureSync.replicateKeywordTable(GoogleStructureSync.java:1340) at com.thesearchagency.searchengines.google.GoogleStructureSync.access$1900(GoogleStructureSync.java:68) at com.thesearchagency.searchengines.google.GoogleStructureSync$LoadTransaction.performTableReplication(GoogleStructureSync.java:2521) at com.thesearchagency.searchengines.google.GoogleStructureSync$LoadTransaction.performDifferenceChecks(GoogleStructureSync.java:2493) at com.thesearchagency.searchengines.google.GoogleStructureSync$LoadTransaction.databaseCallsImplementation(GoogleStructureSync.java:2434) at com.thesearchagency.searchengines.google.GoogleStructureSync$LoadTransaction.databaseCalls(GoogleStructureSync.java:2408) ... 10 more 2011-07-20 23:07:12.784 (3) [P2T1]: Google Sync: -- Change Detection FAILED for acctID: 17 2011-07-20 23:07:12.808 (1) [P2T1]: Exception [Error syncing seaccounts for seacct: 17]:com.thesearchagency.searchengines.SearchEngineCommandException: java.lang.NumberFormatException: null at com.thesearchagency.searchengines.google.GoogleStructureSync.getSearchEngineAccountsWithDifferences(GoogleStructureSync.java:303) at com.thesearchagency.searchengines.google.GoogleAPISearchEngine.getSearchEngineAccountsWithDifferences(GoogleAPISearchEngine.java:2216) at com.thesearchagency.searchengines.SearchEngineUpdater$SearchEngineSyncUserWorker.run(SearchEngineUpdater.java:3458) 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) Caused by: java.lang.NumberFormatException: null at java.lang.Integer.parseInt(Integer.java:415) at java.lang.Integer.(Integer.java:620) at com.thesearchagency.searchengines.google.GoogleStructureSync.replicateKeywordTable(GoogleStructureSync.java:1340) at com.thesearchagency.searchengines.google.GoogleStructureSync.access$1900(GoogleStructureSync.java:68) at com.thesearchagency.searchengines.google.GoogleStructureSync$LoadTransaction.performTableReplication(GoogleStructureSync.java:2521) at com.thesearchagency.searchengines.google.GoogleStructureSync$LoadTransaction.performDifferenceChecks(GoogleStructureSync.java:2493) at com.thesearchagency.searchengines.google.GoogleStructureSync$LoadTransaction.databaseCallsImplementation(GoogleStructureSync.java:2434) at com.thesearchagency.searchengines.google.GoogleStructureSync$LoadTransaction.databaseCalls(GoogleStructureSync.java:2408) at com.carldunham.jst.db.SQLTransaction.execute(SQLTransaction.java:68) at com.thesearchagency.searchengines.google.GoogleStructureSync.getSearchEngineAccountsWithDifferences(GoogleStructureSync.java:280) ... 8 more 2011-07-20 23:07:12.808 (1) [P2T1]: Exception [Failure in retieving out-of-sync SE accounts: ]:com.thesearchagency.searchengines.SearchEngineCommandException: java.lang.NumberFormatException: null at com.thesearchagency.searchengines.google.GoogleStructureSync.getSearchEngineAccountsWithDifferences(GoogleStructureSync.java:303) at com.thesearchagency.searchengines.google.GoogleAPISearchEngine.getSearchEngineAccountsWithDifferences(GoogleAPISearchEngine.java:2216) at com.thesearchagency.searchengines.SearchEngineUpdater$SearchEngineSyncUserWorker.run(SearchEngineUpdater.java:3458) 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) Caused by: java.lang.NumberFormatException: null at java.lang.Integer.parseInt(Integer.java:415) at java.lang.Integer.(Integer.java:620) at com.thesearchagency.searchengines.google.GoogleStructureSync.replicateKeywordTable(GoogleStructureSync.java:1340) at com.thesearchagency.searchengines.google.GoogleStructureSync.access$1900(GoogleStructureSync.java:68) at com.thesearchagency.searchengines.google.GoogleStructureSync$LoadTransaction.performTableReplication(GoogleStructureSync.java:2521) at com.thesearchagency.searchengines.google.GoogleStructureSync$LoadTransaction.performDifferenceChecks(GoogleStructureSync.java:2493) at com.thesearchagency.searchengines.google.GoogleStructureSync$LoadTransaction.databaseCallsImplementation(GoogleStructureSync.java:2434) at com.thesearchagency.searchengines.google.GoogleStructureSync$LoadTransaction.databaseCalls(GoogleStructureSync.java:2408) at com.carldunham.jst.db.SQLTransaction.execute(SQLTransaction.java:68) at com.thesearchagency.searchengines.google.GoogleStructureSync.getSearchEngineAccountsWithDifferences(GoogleStructureSync.java:280) ... 8 more 2011-07-20 23:07:12.812 (3) [main]: ------------SearchEngineSyncUserWorker done 2011-07-20 23:07:12.812 (3) [main]: No accounts to sync. 2011-07-20 23:07:12.812 (3) [main]: =============== Completed Search Engine Updater ================ 2011-07-20 23:07:12.816 (3) [main]: Search Engine Updater: 1m 49.467s 2011-07-20 23:07:12.820 (3) [main]: by key: 2011-07-20 23:07:12.820 (3) [main]: parsing: 7.155s 2011-07-20 23:07:12.820 (3) [main]: google: 57.920s 2011-07-20 23:07:12.820 (3) [main]: by thread: 2011-07-20 23:07:12.820 (3) [main]: P2T1: 4.882s 2011-07-20 23:07:12.820 (3) [main]: P1T1: 53.038s 2011-07-20 23:07:12.820 (3) [main]: db: 15.046s 2011-07-20 23:07:12.820 (3) [main]: by thread: 2011-07-20 23:07:12.821 (3) [main]: P2T1: 1.511s 2011-07-20 23:07:12.821 (3) [main]: main: 0.156s 2011-07-20 23:07:12.821 (3) [main]: P1T1: 13.379s 2011-07-20 23:07:12.821 (3) [main]: other: 29.346s