2012-01-08 15:35:01.867 (3) [main]: Debug Level set to 3 2012-01-08 15:35:01.972 (3) [main]: Listings flag set, implying groups flag as well. 2012-01-08 15:35:01.978 (3) [main]: DatabasePool with a limit of 80 created 2012-01-08 15:35:02.271 (3) [main]: getSEUserIDs distID=3, seUserID=null, accounts=(521) returned 1554,1642,1555,1500,1502,1503 2012-01-08 15:35:02.274 (3) [main]: =============== Starting Search Engine Updater ================ 2012-01-08 15:35:02.274 (3) [main]: ----------------SearchEngineSyncUserWorker starting 2012-01-08 15:35:02.345 (3) [main]: Service URL: http://svc-useracctv2.svc.thesearchagency.com:8080/svc-useracctv2.0/UserAccountService2.0?wsdl Jan 8, 2012 3:35:02 PM org.apache.cxf.bus.spring.BusApplicationContext getConfigResources INFO: No cxf.xml configuration file detected, relying on defaults. Jan 8, 2012 3:35:05 PM org.apache.cxf.service.factory.ReflectionServiceFactoryBean buildServiceFromWSDL INFO: Creating Service {urn:v2.UserAccountService.services.thesearchagency.com}UserAccountService2.0 from WSDL: http://svc-useracctv2.svc.thesearchagency.com:8080/svc-useracctv2.0/UserAccountService2.0?wsdl 2012-01-08 15:35:06.576 (3) [main]: Got UserAccountServiceEndPoint object. 2012-01-08 15:35:06.923 (3) [main]: Instantiating a DateUtil object for time zone Europe/London 2012-01-08 15:35:07.106 (3) [main]: No licensing config file found, assuming TSA production environment 2012-01-08 15:35:07.208 (3) [main]: Created shared sesystem connection rw 2012-01-08 15:35:08.062 (3) [main]: DatabasePool with a limit of 80 created 2012-01-08 15:35:08.219 (3) [P1T1]: DatabasePool with a limit of 80 created 2012-01-08 15:35:08.378 (3) [P1T1]: -- Bulk downloads supported. 2012-01-08 15:35:08.379 (3) [P1T1]: -- Begining search engine sync for user: (1642) "#006BT - Hotels" 2012-01-08 15:35:08.704 (3) [P1T2]: -- Bulk downloads supported. 2012-01-08 15:35:08.705 (3) [P1T2]: -- Begining search engine sync for user: (1555) "#005BT - Dentists" 2012-01-08 15:35:08.708 (3) [P1T1]: DatabasePool with a limit of 80 created 2012-01-08 15:35:09.059 (3) [P1T1]: DatabasePool with a limit of 80 created 2012-01-08 15:35:09.166 (3) [P1T3]: -- Bulk downloads supported. 2012-01-08 15:35:09.167 (3) [P1T3]: -- Begining search engine sync for user: (1554) "#004BT - Builders" 2012-01-08 15:35:09.375 (2) [P1T1]: Created KeywordStructureSyncCriterion, db is googleKeywords 2012-01-08 15:35:09.376 (2) [P1T1]: Created CreativeStructureSyncCriterion 2012-01-08 15:35:09.376 (2) [P1T1]: googleKeywords 2012-01-08 15:35:09.400 (2) [P1T1]: Added Keyword Performance Report AdGroupId to secondaryKeys 2012-01-08 15:35:09.400 (2) [P1T1]: Added Adgroup Performance Report AdGroupId to secondaryKeys 2012-01-08 15:35:09.400 (2) [P1T1]: Added Managed Placement Performance Report AdGroupId to secondaryKeys 2012-01-08 15:35:09.400 (2) [P1T1]: Getting columns for : Adgroup Performance Report 2012-01-08 15:35:09.401 (2) [P1T1]: Got : AdGroupName 2012-01-08 15:35:09.401 (2) [P1T1]: Got : KeywordContentMaxCpc 2012-01-08 15:35:09.401 (2) [P1T1]: Got : ProxyKeywordMaxCpc 2012-01-08 15:35:09.401 (2) [P1T1]: Got : MaxCpm 2012-01-08 15:35:09.401 (2) [P1T1]: Got : SiteMaxCpc 2012-01-08 15:35:09.401 (2) [P1T1]: Got : AdGroupId 2012-01-08 15:35:09.405 (2) [P1T1]: YESTERDAYADGROUP_PERFORMANCE_REPORTAdGroupNameKeywordContentMaxCpcProxyKeywordMaxCpcMaxCpmSiteMaxCpcAdGroupId 14ccfec5d95fbfdfc5160479d0dc93c3 2012-01-08 15:35:09.407 (2) [P1T1]: Definition found in db: true for hash: 14ccfec5d95fbfdfc5160479d0dc93c3 and account: 6231565829 2012-01-08 15:35:10.795 (2) [P1T2]: Created KeywordStructureSyncCriterion, db is googleKeywords 2012-01-08 15:35:10.796 (2) [P1T2]: Created CreativeStructureSyncCriterion 2012-01-08 15:35:10.796 (2) [P1T2]: googleKeywords 2012-01-08 15:35:11.069 (2) [P1T2]: Added Keyword Performance Report AdGroupId to secondaryKeys 2012-01-08 15:35:11.070 (2) [P1T2]: Added Adgroup Performance Report AdGroupId to secondaryKeys 2012-01-08 15:35:11.070 (2) [P1T2]: Added Managed Placement Performance Report AdGroupId to secondaryKeys 2012-01-08 15:35:11.070 (2) [P1T2]: Getting columns for : Adgroup Performance Report 2012-01-08 15:35:11.070 (2) [P1T2]: Got : AdGroupName 2012-01-08 15:35:11.070 (2) [P1T2]: Got : KeywordContentMaxCpc 2012-01-08 15:35:11.070 (2) [P1T2]: Got : ProxyKeywordMaxCpc 2012-01-08 15:35:11.070 (2) [P1T2]: Got : MaxCpm 2012-01-08 15:35:11.070 (2) [P1T2]: Got : SiteMaxCpc 2012-01-08 15:35:11.071 (2) [P1T2]: Got : AdGroupId 2012-01-08 15:35:11.095 (2) [P1T2]: YESTERDAYADGROUP_PERFORMANCE_REPORTAdGroupNameKeywordContentMaxCpcProxyKeywordMaxCpcMaxCpmSiteMaxCpcAdGroupId 14ccfec5d95fbfdfc5160479d0dc93c3 2012-01-08 15:35:11.096 (2) [P1T2]: Definition found in db: true for hash: 14ccfec5d95fbfdfc5160479d0dc93c3 and account: 1458205980 2012-01-08 15:35:11.126 (2) [P1T3]: Created KeywordStructureSyncCriterion, db is googleKeywords 2012-01-08 15:35:11.126 (2) [P1T3]: Created CreativeStructureSyncCriterion 2012-01-08 15:35:11.126 (2) [P1T3]: googleKeywords 2012-01-08 15:35:11.127 (2) [P1T3]: Added Keyword Performance Report AdGroupId to secondaryKeys 2012-01-08 15:35:11.127 (2) [P1T3]: Added Adgroup Performance Report AdGroupId to secondaryKeys 2012-01-08 15:35:11.127 (2) [P1T3]: Added Managed Placement Performance Report AdGroupId to secondaryKeys 2012-01-08 15:35:11.127 (2) [P1T3]: Getting columns for : Adgroup Performance Report 2012-01-08 15:35:11.127 (2) [P1T3]: Got : AdGroupName 2012-01-08 15:35:11.128 (2) [P1T3]: Got : KeywordContentMaxCpc 2012-01-08 15:35:11.128 (2) [P1T3]: Got : ProxyKeywordMaxCpc 2012-01-08 15:35:11.128 (2) [P1T3]: Got : MaxCpm 2012-01-08 15:35:11.128 (2) [P1T3]: Got : SiteMaxCpc 2012-01-08 15:35:11.128 (2) [P1T3]: Got : AdGroupId 2012-01-08 15:35:11.128 (2) [P1T3]: YESTERDAYADGROUP_PERFORMANCE_REPORTAdGroupNameKeywordContentMaxCpcProxyKeywordMaxCpcMaxCpmSiteMaxCpcAdGroupId 14ccfec5d95fbfdfc5160479d0dc93c3 2012-01-08 15:35:11.129 (2) [P1T3]: Definition found in db: true for hash: 14ccfec5d95fbfdfc5160479d0dc93c3 and account: 7179261774 2012-01-08 15:35:13.206 (2) [P1T2]: Getting columns for : Keyword Performance Report 2012-01-08 15:35:13.207 (2) [P1T2]: Got : CampaignId 2012-01-08 15:35:13.207 (2) [P1T2]: Got : AdGroupId 2012-01-08 15:35:13.207 (2) [P1T2]: Got : AdGroupStatus 2012-01-08 15:35:13.207 (2) [P1T2]: Got : MaxCpc 2012-01-08 15:35:13.207 (2) [P1T2]: Got : MaxCpm 2012-01-08 15:35:13.207 (2) [P1T2]: Got : KeywordMatchType 2012-01-08 15:35:13.207 (2) [P1T2]: Got : Status 2012-01-08 15:35:13.207 (2) [P1T2]: Got : DestinationUrl 2012-01-08 15:35:13.208 (2) [P1T2]: Got : IsNegative 2012-01-08 15:35:13.208 (2) [P1T2]: Got : KeywordText 2012-01-08 15:35:13.208 (2) [P1T2]: Got : Id 2012-01-08 15:35:13.208 (2) [P1T2]: YESTERDAYKEYWORDS_PERFORMANCE_REPORTCampaignIdAdGroupIdAdGroupStatusMaxCpcMaxCpmKeywordMatchTypeStatusDestinationUrlIsNegativeKeywordTextId 296d860661f7b19d8997e600e5c20868 2012-01-08 15:35:13.222 (2) [P1T1]: Getting columns for : Keyword Performance Report 2012-01-08 15:35:13.222 (2) [P1T1]: Got : CampaignId 2012-01-08 15:35:13.222 (2) [P1T1]: Got : AdGroupId 2012-01-08 15:35:13.222 (2) [P1T1]: Got : AdGroupStatus 2012-01-08 15:35:13.223 (2) [P1T1]: Got : MaxCpc 2012-01-08 15:35:13.223 (2) [P1T1]: Got : MaxCpm 2012-01-08 15:35:13.223 (2) [P1T1]: Got : KeywordMatchType 2012-01-08 15:35:13.223 (2) [P1T1]: Got : Status 2012-01-08 15:35:13.223 (2) [P1T1]: Got : DestinationUrl 2012-01-08 15:35:13.223 (2) [P1T1]: Got : IsNegative 2012-01-08 15:35:13.223 (2) [P1T1]: Got : KeywordText 2012-01-08 15:35:13.223 (2) [P1T1]: Got : Id 2012-01-08 15:35:13.224 (2) [P1T1]: YESTERDAYKEYWORDS_PERFORMANCE_REPORTCampaignIdAdGroupIdAdGroupStatusMaxCpcMaxCpmKeywordMatchTypeStatusDestinationUrlIsNegativeKeywordTextId 296d860661f7b19d8997e600e5c20868 2012-01-08 15:35:13.229 (2) [P1T3]: Getting columns for : Keyword Performance Report 2012-01-08 15:35:13.229 (2) [P1T3]: Got : CampaignId 2012-01-08 15:35:13.229 (2) [P1T3]: Got : AdGroupId 2012-01-08 15:35:13.230 (2) [P1T3]: Got : AdGroupStatus 2012-01-08 15:35:13.230 (2) [P1T3]: Got : MaxCpc 2012-01-08 15:35:13.230 (2) [P1T3]: Got : MaxCpm 2012-01-08 15:35:13.230 (2) [P1T3]: Got : KeywordMatchType 2012-01-08 15:35:13.230 (2) [P1T3]: Got : Status 2012-01-08 15:35:13.230 (2) [P1T3]: Got : DestinationUrl 2012-01-08 15:35:13.230 (2) [P1T3]: Got : IsNegative 2012-01-08 15:35:13.230 (2) [P1T3]: Got : KeywordText 2012-01-08 15:35:13.231 (2) [P1T3]: Got : Id 2012-01-08 15:35:13.231 (2) [P1T3]: YESTERDAYKEYWORDS_PERFORMANCE_REPORTCampaignIdAdGroupIdAdGroupStatusMaxCpcMaxCpmKeywordMatchTypeStatusDestinationUrlIsNegativeKeywordTextId 296d860661f7b19d8997e600e5c20868 2012-01-08 15:35:13.232 (2) [P1T2]: Definition found in db: true for hash: 296d860661f7b19d8997e600e5c20868 and account: 1458205980 2012-01-08 15:35:13.236 (2) [P1T3]: Definition found in db: true for hash: 296d860661f7b19d8997e600e5c20868 and account: 7179261774 2012-01-08 15:35:13.241 (2) [P1T1]: Definition found in db: true for hash: 296d860661f7b19d8997e600e5c20868 and account: 6231565829 2012-01-08 15:35:14.635 (2) [P1T2]: Getting columns for : Managed Placement Performance Report 2012-01-08 15:35:14.635 (2) [P1T2]: Got : CampaignId 2012-01-08 15:35:14.636 (2) [P1T2]: Got : AdGroupId 2012-01-08 15:35:14.636 (2) [P1T2]: Got : AdGroupStatus 2012-01-08 15:35:14.636 (2) [P1T2]: Got : MaxCpc 2012-01-08 15:35:14.636 (2) [P1T2]: Got : MaxCpm 2012-01-08 15:35:14.636 (2) [P1T2]: Got : KeywordMatchType 2012-01-08 15:35:14.636 (2) [P1T2]: Got : Status 2012-01-08 15:35:14.636 (2) [P1T2]: Got : DestinationUrl 2012-01-08 15:35:14.636 (2) [P1T2]: Got : IsNegative 2012-01-08 15:35:14.636 (2) [P1T2]: Got : PlacementUrl 2012-01-08 15:35:14.637 (2) [P1T2]: Got : Id 2012-01-08 15:35:14.637 (2) [P1T2]: YESTERDAYMANAGED_PLACEMENTS_PERFORMANCE_REPORTCampaignIdAdGroupIdAdGroupStatusMaxCpcMaxCpmKeywordMatchTypeStatusDestinationUrlIsNegativePlacementUrlId -484d3bf959c59d54610f8b25330785be 2012-01-08 15:35:14.711 (2) [P1T2]: Definition found in db: true for hash: -484d3bf959c59d54610f8b25330785be and account: 1458205980 2012-01-08 15:35:15.064 (2) [P1T3]: Getting columns for : Managed Placement Performance Report 2012-01-08 15:35:15.064 (2) [P1T3]: Got : CampaignId 2012-01-08 15:35:15.064 (2) [P1T3]: Got : AdGroupId 2012-01-08 15:35:15.064 (2) [P1T3]: Got : AdGroupStatus 2012-01-08 15:35:15.065 (2) [P1T3]: Got : MaxCpc 2012-01-08 15:35:15.065 (2) [P1T3]: Got : MaxCpm 2012-01-08 15:35:15.065 (2) [P1T3]: Got : KeywordMatchType 2012-01-08 15:35:15.065 (2) [P1T3]: Got : Status 2012-01-08 15:35:15.065 (2) [P1T3]: Got : DestinationUrl 2012-01-08 15:35:15.065 (2) [P1T3]: Got : IsNegative 2012-01-08 15:35:15.065 (2) [P1T3]: Got : PlacementUrl 2012-01-08 15:35:15.065 (2) [P1T3]: Got : Id 2012-01-08 15:35:15.066 (2) [P1T3]: YESTERDAYMANAGED_PLACEMENTS_PERFORMANCE_REPORTCampaignIdAdGroupIdAdGroupStatusMaxCpcMaxCpmKeywordMatchTypeStatusDestinationUrlIsNegativePlacementUrlId -484d3bf959c59d54610f8b25330785be 2012-01-08 15:35:15.075 (2) [P1T3]: Definition found in db: true for hash: -484d3bf959c59d54610f8b25330785be and account: 7179261774 2012-01-08 15:35:15.119 (2) [P1T1]: Getting columns for : Managed Placement Performance Report 2012-01-08 15:35:15.120 (2) [P1T1]: Got : CampaignId 2012-01-08 15:35:15.120 (2) [P1T1]: Got : AdGroupId 2012-01-08 15:35:15.120 (2) [P1T1]: Got : AdGroupStatus 2012-01-08 15:35:15.120 (2) [P1T1]: Got : MaxCpc 2012-01-08 15:35:15.120 (2) [P1T1]: Got : MaxCpm 2012-01-08 15:35:15.120 (2) [P1T1]: Got : KeywordMatchType 2012-01-08 15:35:15.120 (2) [P1T1]: Got : Status 2012-01-08 15:35:15.120 (2) [P1T1]: Got : DestinationUrl 2012-01-08 15:35:15.120 (2) [P1T1]: Got : IsNegative 2012-01-08 15:35:15.120 (2) [P1T1]: Got : PlacementUrl 2012-01-08 15:35:15.121 (2) [P1T1]: Got : Id 2012-01-08 15:35:15.121 (2) [P1T1]: YESTERDAYMANAGED_PLACEMENTS_PERFORMANCE_REPORTCampaignIdAdGroupIdAdGroupStatusMaxCpcMaxCpmKeywordMatchTypeStatusDestinationUrlIsNegativePlacementUrlId -484d3bf959c59d54610f8b25330785be 2012-01-08 15:35:15.135 (2) [P1T1]: Definition found in db: true for hash: -484d3bf959c59d54610f8b25330785be and account: 6231565829 2012-01-08 15:35:16.484 (2) [DownloaderT1]: Downloading report : Adgroup Performance Report 2012-01-08 15:35:16.485 (2) [DownloaderT3]: Downloading report : Managed Placement Performance Report 2012-01-08 15:35:16.485 (3) [DownloaderT1]: Scheduling report attempt 1: ReportID=60527660 2012-01-08 15:35:16.485 (3) [DownloaderT3]: Scheduling report attempt 1: ReportID=259899860 2012-01-08 15:35:16.485 (2) [DownloaderT2]: Downloading report : Keyword Performance Report 2012-01-08 15:35:16.486 (3) [DownloaderT2]: Scheduling report attempt 1: ReportID=60527780 2012-01-08 15:35:16.791 (2) [DownloaderT1]: Downloading report : Adgroup Performance Report 2012-01-08 15:35:16.791 (2) [DownloaderT3]: Downloading report : Managed Placement Performance Report 2012-01-08 15:35:16.791 (3) [DownloaderT1]: Scheduling report attempt 1: ReportID=103900988 2012-01-08 15:35:16.791 (3) [DownloaderT3]: Scheduling report attempt 1: ReportID=103900868 2012-01-08 15:35:16.792 (2) [DownloaderT2]: Downloading report : Keyword Performance Report 2012-01-08 15:35:16.792 (3) [DownloaderT2]: Scheduling report attempt 1: ReportID=103901108 2012-01-08 15:35:16.832 (2) [DownloaderT1]: Downloading report : Adgroup Performance Report 2012-01-08 15:35:16.832 (3) [DownloaderT1]: Scheduling report attempt 1: ReportID=102923592 2012-01-08 15:35:16.855 (2) [DownloaderT2]: Downloading report : Keyword Performance Report 2012-01-08 15:35:16.855 (3) [DownloaderT2]: Scheduling report attempt 1: ReportID=102923712 2012-01-08 15:35:16.880 (2) [DownloaderT3]: Downloading report : Managed Placement Performance Report 2012-01-08 15:35:16.881 (3) [DownloaderT3]: Scheduling report attempt 1: ReportID=102923472 2012-01-08 15:35:22.642 (2) [DownloaderT1]: OK 2012-01-08 15:35:22.643 (2) [DownloaderT1]: Report : Adgroup Performance Report downloaded. 2012-01-08 15:35:22.734 (2) [DownloaderT1]: Report : Adgroup Performance Report is valid : true 2012-01-08 15:35:24.421 (2) [DownloaderT3]: OK 2012-01-08 15:35:24.469 (2) [DownloaderT1]: OK 2012-01-08 15:35:24.726 (2) [DownloaderT1]: Report : Adgroup Performance Report downloaded. 2012-01-08 15:35:24.790 (2) [DownloaderT1]: Report : Adgroup Performance Report is valid : true 2012-01-08 15:35:25.500 (2) [DownloaderT3]: Report : Managed Placement Performance Report downloaded. 2012-01-08 15:35:25.727 (2) [DownloaderT3]: Report : Managed Placement Performance Report is valid : true 2012-01-08 15:35:25.997 (2) [DownloaderT1]: OK 2012-01-08 15:35:26.288 (2) [DownloaderT1]: Report : Adgroup Performance Report downloaded. 2012-01-08 15:35:26.306 (2) [DownloaderT1]: Report : Adgroup Performance Report is valid : true 2012-01-08 15:35:27.331 (2) [DownloaderT3]: OK 2012-01-08 15:35:27.837 (2) [DownloaderT3]: Report : Managed Placement Performance Report downloaded. 2012-01-08 15:35:27.893 (2) [DownloaderT3]: Report : Managed Placement Performance Report is valid : true 2012-01-08 15:35:32.677 (2) [DownloaderT3]: OK 2012-01-08 15:35:32.678 (2) [DownloaderT3]: Report : Managed Placement Performance Report downloaded. 2012-01-08 15:35:32.680 (2) [DownloaderT3]: Report : Managed Placement Performance Report is valid : true 2012-01-08 15:35:34.857 (2) [DownloaderT2]: OK 2012-01-08 15:35:47.577 (2) [DownloaderT2]: Report : Keyword Performance Report downloaded. 2012-01-08 15:35:52.519 (2) [DownloaderT2]: OK 2012-01-08 15:35:58.077 (2) [DownloaderT2]: Report : Keyword Performance Report is valid : true 2012-01-08 15:35:58.180 (2) [P1T1]: Downloaded and validated Adgroup Performance Report 4577 bytes. 2012-01-08 15:35:58.181 (2) [P1T1]: Downloaded and validated Keyword Performance Report 10389107 bytes. 2012-01-08 15:35:58.181 (2) [P1T1]: Downloaded and validated Managed Placement Performance Report 317 bytes. 2012-01-08 15:35:58.181 (2) [P1T1]: Parsing report as secondary report: Adgroup Performance Report 2012-01-08 15:35:58.183 (3) [P1T1]: parsing columns for Adgroup Performance Report 2012-01-08 15:35:58.188 (3) [P1T1]: parsing rows for Adgroup Performance Report 2012-01-08 15:35:58.238 (2) [P1T1]: Finished parsing report: Adgroup Performance Report 2012-01-08 15:35:58.239 (2) [P1T1]: Parsing report as primary report: Keyword Performance Report with 155833472 bytes free 2012-01-08 15:35:58.244 (3) [P1T1]: parsing columns for Keyword Performance Report 2012-01-08 15:35:58.245 (3) [P1T1]: Columns already defined 2012-01-08 15:36:10.317 (3) [P1T1]: parsing rows for Keyword Performance Report 2012-01-08 15:36:11.715 (3) [main]: Waiting for tasks to be done 2012-01-08 15:36:15.499 (2) [DownloaderT2]: Report : Keyword Performance Report downloaded. 2012-01-08 15:36:19.392 (2) [DownloaderT2]: OK 2012-01-08 15:37:05.420 (2) [P1T1]: PrimaryReportRowHandler Parsing row: 100000 2012-01-08 15:37:11.341 (2) [DownloaderT2]: Report : Keyword Performance Report downloaded. 2012-01-08 15:37:35.372 (2) [P1T1]: PrimaryReportRowHandler Parsing row: 200000 2012-01-08 15:37:36.527 (2) [DownloaderT2]: Report : Keyword Performance Report is valid : true 2012-01-08 15:37:36.725 (2) [P1T3]: Downloaded and validated Adgroup Performance Report 13201 bytes. 2012-01-08 15:37:36.725 (2) [P1T3]: Downloaded and validated Keyword Performance Report 25524583 bytes. 2012-01-08 15:37:36.725 (2) [P1T3]: Downloaded and validated Managed Placement Performance Report 147566 bytes. 2012-01-08 15:37:36.726 (2) [P1T3]: Parsing report as secondary report: Adgroup Performance Report 2012-01-08 15:37:36.727 (3) [P1T3]: parsing columns for Adgroup Performance Report 2012-01-08 15:37:36.872 (3) [P1T3]: parsing rows for Adgroup Performance Report 2012-01-08 15:37:36.950 (2) [P1T3]: Finished parsing report: Adgroup Performance Report 2012-01-08 15:37:36.951 (2) [P1T3]: Parsing report as primary report: Keyword Performance Report with 45560640 bytes free 2012-01-08 15:37:37.303 (3) [P1T3]: parsing columns for Keyword Performance Report 2012-01-08 15:37:37.304 (3) [P1T3]: Columns already defined 2012-01-08 15:38:02.659 (2) [P1T1]: PrimaryReportRowHandler Parsing row: 300000 2012-01-08 15:38:22.644 (2) [P1T1]: Finished parsing report: Keyword Performance Report 2012-01-08 15:38:22.644 (2) [P1T1]: Parsing report as primary report: Managed Placement Performance Report with 85913024 bytes free 2012-01-08 15:38:22.762 (3) [P1T1]: parsing columns for Managed Placement Performance Report 2012-01-08 15:38:22.763 (3) [P1T1]: Columns already defined 2012-01-08 15:38:22.763 (3) [P1T1]: parsing rows for Managed Placement Performance Report 2012-01-08 15:38:22.860 (2) [P1T1]: Finished parsing report: Managed Placement Performance Report 2012-01-08 15:38:27.175 (3) [P1T3]: parsing rows for Keyword Performance Report 2012-01-08 15:38:33.946 (2) [P1T1]: Created temp file: /var/local/tsa/google_sync_files/tsa-keyword-structure-report--1642-2012-01-08 15:35:0919729.tmp 2012-01-08 15:38:33.946 (2) [P1T1]: googleAds 2012-01-08 15:38:33.947 (2) [P1T1]: Getting columns for : Ad Performance Report 2012-01-08 15:38:33.947 (2) [P1T1]: Got : CampaignId 2012-01-08 15:38:33.947 (2) [P1T1]: Got : AdGroupId 2012-01-08 15:38:33.947 (2) [P1T1]: Got : Headline 2012-01-08 15:38:33.947 (2) [P1T1]: Got : Description1 2012-01-08 15:38:33.947 (2) [P1T1]: Got : Description2 2012-01-08 15:38:33.947 (2) [P1T1]: Got : DisplayUrl 2012-01-08 15:38:33.947 (2) [P1T1]: Got : Id 2012-01-08 15:38:33.948 (2) [P1T1]: Got : AdType 2012-01-08 15:38:33.948 (2) [P1T1]: Got : Status 2012-01-08 15:38:33.948 (2) [P1T1]: Got : CreativeDestinationUrl 2012-01-08 15:38:33.948 (2) [P1T1]: YESTERDAYAD_PERFORMANCE_REPORTCampaignIdAdGroupIdHeadlineDescription1Description2DisplayUrlIdAdTypeStatusCreativeDestinationUrl -5ecc211c13cec065600706929725b2b8 2012-01-08 15:38:33.949 (2) [P1T1]: Definition found in db: true for hash: -5ecc211c13cec065600706929725b2b8 and account: 6231565829 2012-01-08 15:38:35.966 (2) [DownloaderT1]: Downloading report : Ad Performance Report 2012-01-08 15:38:35.967 (3) [DownloaderT1]: Scheduling report attempt 1: ReportID=102930072 2012-01-08 15:38:37.490 (2) [DownloaderT1]: OK 2012-01-08 15:38:38.128 (2) [DownloaderT1]: Report : Ad Performance Report downloaded. 2012-01-08 15:38:38.298 (2) [DownloaderT1]: Report : Ad Performance Report is valid : true 2012-01-08 15:38:38.392 (2) [P1T1]: Downloaded and validated Ad Performance Report 37967 bytes. 2012-01-08 15:38:38.392 (2) [P1T1]: Parsing report as primary report: Ad Performance Report with 188652456 bytes free 2012-01-08 15:38:38.417 (3) [P1T1]: parsing columns for Ad Performance Report 2012-01-08 15:38:38.542 (3) [P1T1]: parsing rows for Ad Performance Report Exception in thread "MergeT2" java.lang.NullPointerException at com.thesearchagency.searchengines.google.GoogleReportingTool$PrimaryReportRowHandler$RowMergeWorker.run(GoogleReportingTool.java:1321) 2012-01-08 15:38:39.284 (2) [P1T1]: Finished parsing report: Ad Performance Report 2012-01-08 15:38:41.305 (2) [P1T1]: Created temp file: /var/local/tsa/google_sync_files/tsa-creative-structure-report--1642-2012-01-08 15:35:0919733.tmp 2012-01-08 15:38:41.305 (3) [P1T1]: -- Data staging complete for seuser ((1642) "#006BT - Hotels") 2012-01-08 15:38:41.500 (3) [P1T1]: Loading data infile into temp table... 2012-01-08 15:38:42.087 (2) [DownloaderT2]: Report : Keyword Performance Report is valid : true 2012-01-08 15:38:42.097 (2) [P1T2]: Downloaded and validated Adgroup Performance Report 16510 bytes. 2012-01-08 15:38:42.098 (2) [P1T2]: Downloaded and validated Keyword Performance Report 44885043 bytes. 2012-01-08 15:38:42.098 (2) [P1T2]: Downloaded and validated Managed Placement Performance Report 45057 bytes. 2012-01-08 15:38:42.098 (2) [P1T2]: Parsing report as secondary report: Adgroup Performance Report 2012-01-08 15:38:42.100 (3) [P1T2]: parsing columns for Adgroup Performance Report 2012-01-08 15:38:42.127 (3) [P1T2]: parsing rows for Adgroup Performance Report 2012-01-08 15:38:42.222 (2) [P1T2]: Finished parsing report: Adgroup Performance Report 2012-01-08 15:38:42.223 (2) [P1T2]: Parsing report as primary report: Keyword Performance Report with 151612656 bytes free 2012-01-08 15:38:42.439 (3) [P1T2]: parsing columns for Keyword Performance Report 2012-01-08 15:38:42.440 (3) [P1T2]: Columns already defined 2012-01-08 15:38:44.982 (2) [P1T1]: Trying to load : /var/local/tsa/google_sync_files/tsa-keyword-structure-report--1642-2012-01-08 15:35:0919729.tmp into `tmp`.`tmp1` 2012-01-08 15:38:49.115 (2) [P1T3]: PrimaryReportRowHandler Parsing row: 100000 2012-01-08 15:39:11.868 (2) [P1T3]: PrimaryReportRowHandler Parsing row: 200000 2012-01-08 15:39:12.405 (2) [P1T1]: Trying to load : /var/local/tsa/google_sync_files/tsa-creative-structure-report--1642-2012-01-08 15:35:0919733.tmp into `tmp`.`tmp2` 2012-01-08 15:39:12.813 (3) [P1T1]: LOAD TEMP SYNC TABLES COMPLETED 2012-01-08 15:39:32.925 (2) [P1T3]: PrimaryReportRowHandler Parsing row: 300000 2012-01-08 15:40:04.067 (3) [P1T1]: Campaigns with new items:([]) 2012-01-08 15:40:04.067 (3) [P1T1]: DETECTION OF NEW CAMPAIGN ITEMS COMPLETED 2012-01-08 15:40:11.334 (3) [P1T1]: Campaigns with deleted items:([]) 2012-01-08 15:40:11.335 (3) [P1T1]: DETECTION OF DELETED CAMPAIGN ITEMS COMPLETED 2012-01-08 15:40:15.788 (3) [P1T2]: parsing rows for Keyword Performance Report 2012-01-08 15:40:26.966 (2) [P1T3]: PrimaryReportRowHandler Parsing row: 400000 2012-01-08 15:40:30.316 (3) [P1T1]: Campaigns with updated items:([]) 2012-01-08 15:40:30.316 (3) [P1T1]: DETECTION OF UPDATED CAMPAIGN ITEMS COMPLETED 2012-01-08 15:40:39.967 (3) [P1T1]: 366969 keyword records removed before re-loading staging table. 2012-01-08 15:40:59.553 (2) [P1T2]: PrimaryReportRowHandler Parsing row: 100000 2012-01-08 15:41:04.324 (2) [P1T3]: PrimaryReportRowHandler Parsing row: 500000 2012-01-08 15:41:35.501 (2) [P1T2]: PrimaryReportRowHandler Parsing row: 200000 2012-01-08 15:41:39.374 (2) [P1T3]: PrimaryReportRowHandler Parsing row: 600000 2012-01-08 15:41:45.973 (3) [P1T1]: 366969 keyword records loaded into staging table. 2012-01-08 15:41:46.047 (3) [P1T1]: 1468 creative ad records removed from staging table before re-loading. 2012-01-08 15:41:46.271 (3) [P1T1]: 1468 creative ad records loaded into staging table. 2012-01-08 15:41:46.271 (3) [P1T1]: UPDATE OF STAGING TABLES COMPLETED 2012-01-08 15:41:46.272 (3) [P1T1]: Passing seUserAcctId: 561 and seAcctAcctId: 521 2012-01-08 15:41:46.661 (3) [P1T1]: Replicating 30561 rows... 2012-01-08 15:42:19.778 (2) [P1T2]: PrimaryReportRowHandler Parsing row: 300000 2012-01-08 15:42:24.806 (2) [P1T3]: PrimaryReportRowHandler Parsing row: 700000 2012-01-08 15:43:07.071 (2) [P1T2]: PrimaryReportRowHandler Parsing row: 400000 2012-01-08 15:43:11.933 (2) [P1T3]: PrimaryReportRowHandler Parsing row: 800000 2012-01-08 15:43:52.865 (2) [P1T2]: PrimaryReportRowHandler Parsing row: 500000 2012-01-08 15:43:55.426 (2) [P1T3]: Finished parsing report: Keyword Performance Report 2012-01-08 15:43:55.427 (2) [P1T3]: Parsing report as primary report: Managed Placement Performance Report with 493409536 bytes free 2012-01-08 15:43:55.596 (3) [P1T3]: parsing columns for Managed Placement Performance Report 2012-01-08 15:43:55.597 (3) [P1T3]: Columns already defined 2012-01-08 15:43:56.102 (3) [P1T3]: parsing rows for Managed Placement Performance Report 2012-01-08 15:44:00.449 (2) [P1T3]: Finished parsing report: Managed Placement Performance Report 2012-01-08 15:44:25.062 (2) [P1T2]: PrimaryReportRowHandler Parsing row: 600000 2012-01-08 15:44:26.751 (2) [P1T3]: Created temp file: /var/local/tsa/google_sync_files/tsa-keyword-structure-report--1554-2012-01-08 15:35:1119732.tmp 2012-01-08 15:44:26.751 (2) [P1T3]: googleAds 2012-01-08 15:44:26.752 (2) [P1T3]: Getting columns for : Ad Performance Report 2012-01-08 15:44:26.752 (2) [P1T3]: Got : CampaignId 2012-01-08 15:44:26.752 (2) [P1T3]: Got : AdGroupId 2012-01-08 15:44:26.752 (2) [P1T3]: Got : Headline 2012-01-08 15:44:26.752 (2) [P1T3]: Got : Description1 2012-01-08 15:44:26.752 (2) [P1T3]: Got : Description2 2012-01-08 15:44:26.752 (2) [P1T3]: Got : DisplayUrl 2012-01-08 15:44:26.752 (2) [P1T3]: Got : Id 2012-01-08 15:44:26.752 (2) [P1T3]: Got : AdType 2012-01-08 15:44:26.753 (2) [P1T3]: Got : Status 2012-01-08 15:44:26.753 (2) [P1T3]: Got : CreativeDestinationUrl 2012-01-08 15:44:26.753 (2) [P1T3]: YESTERDAYAD_PERFORMANCE_REPORTCampaignIdAdGroupIdHeadlineDescription1Description2DisplayUrlIdAdTypeStatusCreativeDestinationUrl -5ecc211c13cec065600706929725b2b8 2012-01-08 15:44:26.761 (2) [P1T3]: Definition found in db: false for hash: -5ecc211c13cec065600706929725b2b8 and account: 7179261774 2012-01-08 15:44:29.344 (2) [P1T3]: Report definition for AD_PERFORMANCE_REPORT is valid? true 2012-01-08 15:44:30.922 (1) [P1T3]: Error inserting reportDefinition into database: Duplicate entry '7179261774--5ecc211c13cec065600706929725b2b8' for key 'theKey' 2012-01-08 15:44:30.990 (2) [DownloaderT1]: Downloading report : Ad Performance Report 2012-01-08 15:44:30.990 (3) [DownloaderT1]: Scheduling report attempt 1: ReportID=456270068 2012-01-08 15:44:38.351 (2) [DownloaderT1]: OK 2012-01-08 15:44:39.661 (2) [DownloaderT1]: Report : Ad Performance Report downloaded. 2012-01-08 15:44:39.869 (2) [DownloaderT1]: Report : Ad Performance Report is valid : true 2012-01-08 15:44:39.914 (2) [P1T3]: Downloaded and validated Ad Performance Report 117772 bytes. 2012-01-08 15:44:39.915 (2) [P1T3]: Parsing report as primary report: Ad Performance Report with 70169856 bytes free 2012-01-08 15:44:40.078 (3) [P1T3]: parsing columns for Ad Performance Report 2012-01-08 15:44:40.374 (3) [P1T3]: parsing rows for Ad Performance Report 2012-01-08 15:44:41.666 (2) [P1T3]: Finished parsing report: Ad Performance Report 2012-01-08 15:44:48.825 (2) [P1T3]: Created temp file: /var/local/tsa/google_sync_files/tsa-creative-structure-report--1554-2012-01-08 15:35:1119734.tmp 2012-01-08 15:44:48.826 (3) [P1T3]: -- Data staging complete for seuser ((1554) "#004BT - Builders") 2012-01-08 15:45:07.020 (3) [P1T3]: Loading data infile into temp table... 2012-01-08 15:45:13.317 (2) [P1T3]: Trying to load : /var/local/tsa/google_sync_files/tsa-keyword-structure-report--1554-2012-01-08 15:35:1119732.tmp into `tmp`.`tmp4` 2012-01-08 15:53:05.662 (2) [P1T2]: PrimaryReportRowHandler Parsing row: 700000 2012-01-08 16:11:16.672 (3) [P1T1]: Change Detected - Campaign(s) with no previous sync history:(SEUserID: 1642 | AcctID: 561) 2012-01-08 16:11:16.672 (3) [P1T1]: CampaignIDs:([47130, 47131]) 2012-01-08 16:11:16.672 (3) [P1T1]: DETECTION OF CAMPAIGNS NEEDING FIRST SYNC COMPLETED 2012-01-08 16:11:19.348 (3) [P1T1]: DETECTION OF CAMPAIGNS WITH CONTENT/NETWORK CHANGES COMPLETED 2012-01-08 16:11:19.349 (3) [P1T1]: -- Account-level operations complete for seuser ((1642) "#006BT - Hotels") and seAccount(521) 2012-01-08 16:14:30.914 (2) [P1T2]: PrimaryReportRowHandler Parsing row: 800000 2012-01-08 16:16:12.831 (2) [P1T3]: Trying to load : /var/local/tsa/google_sync_files/tsa-creative-structure-report--1554-2012-01-08 15:35:1119734.tmp into `tmp`.`tmp6` 2012-01-08 16:16:17.038 (3) [P1T3]: LOAD TEMP SYNC TABLES COMPLETED 2012-01-08 16:17:16.290 (3) [P1T3]: Campaigns with new items:([]) 2012-01-08 16:17:16.290 (3) [P1T3]: DETECTION OF NEW CAMPAIGN ITEMS COMPLETED 2012-01-08 16:17:32.256 (3) [P1T3]: Campaigns with deleted items:([]) 2012-01-08 16:17:32.256 (3) [P1T3]: DETECTION OF DELETED CAMPAIGN ITEMS COMPLETED 2012-01-08 16:17:55.544 (2) [P1T2]: PrimaryReportRowHandler Parsing row: 900000 2012-01-08 16:18:13.883 (3) [P1T3]: Campaigns with updated items:([]) 2012-01-08 16:18:13.883 (3) [P1T3]: DETECTION OF UPDATED CAMPAIGN ITEMS COMPLETED 2012-01-08 16:18:16.247 (2) [P1T2]: PrimaryReportRowHandler Parsing row: 1000000 2012-01-08 16:18:36.141 (2) [P1T2]: PrimaryReportRowHandler Parsing row: 1100000 2012-01-08 16:18:41.976 (3) [P1T3]: 899233 keyword records removed before re-loading staging table. 2012-01-08 16:18:58.772 (2) [P1T2]: PrimaryReportRowHandler Parsing row: 1200000 2012-01-08 16:19:17.567 (2) [P1T2]: PrimaryReportRowHandler Parsing row: 1300000 2012-01-08 16:19:36.380 (2) [P1T2]: PrimaryReportRowHandler Parsing row: 1400000 2012-01-08 16:19:55.737 (2) [P1T2]: PrimaryReportRowHandler Parsing row: 1500000 2012-01-08 16:20:10.575 (2) [P1T2]: Finished parsing report: Keyword Performance Report 2012-01-08 16:20:10.576 (2) [P1T2]: Parsing report as primary report: Managed Placement Performance Report with 213222432 bytes free 2012-01-08 16:20:10.601 (3) [P1T2]: parsing columns for Managed Placement Performance Report 2012-01-08 16:20:10.602 (3) [P1T2]: Columns already defined 2012-01-08 16:20:10.649 (3) [P1T2]: parsing rows for Managed Placement Performance Report 2012-01-08 16:20:11.217 (2) [P1T2]: Finished parsing report: Managed Placement Performance Report 2012-01-08 16:20:25.265 (3) [P1T3]: 899233 keyword records loaded into staging table. 2012-01-08 16:20:25.327 (3) [P1T3]: 4193 creative ad records removed from staging table before re-loading. 2012-01-08 16:20:25.525 (3) [P1T3]: 4193 creative ad records loaded into staging table. 2012-01-08 16:20:25.525 (3) [P1T3]: UPDATE OF STAGING TABLES COMPLETED 2012-01-08 16:20:25.526 (3) [P1T3]: Passing seUserAcctId: 521 and seAcctAcctId: 521 2012-01-08 16:20:27.378 (3) [P1T3]: Replicating 899194 rows... 2012-01-08 16:20:54.108 (2) [P1T2]: Created temp file: /var/local/tsa/google_sync_files/tsa-keyword-structure-report--1555-2012-01-08 15:35:1019731.tmp 2012-01-08 16:20:54.108 (2) [P1T2]: googleAds 2012-01-08 16:20:57.573 (2) [P1T2]: Getting columns for : Ad Performance Report 2012-01-08 16:20:57.573 (2) [P1T2]: Got : CampaignId 2012-01-08 16:20:57.573 (2) [P1T2]: Got : AdGroupId 2012-01-08 16:20:57.573 (2) [P1T2]: Got : Headline 2012-01-08 16:20:57.573 (2) [P1T2]: Got : Description1 2012-01-08 16:20:57.573 (2) [P1T2]: Got : Description2 2012-01-08 16:20:57.573 (2) [P1T2]: Got : DisplayUrl 2012-01-08 16:20:57.573 (2) [P1T2]: Got : Id 2012-01-08 16:20:57.573 (2) [P1T2]: Got : AdType 2012-01-08 16:20:57.574 (2) [P1T2]: Got : Status 2012-01-08 16:20:57.574 (2) [P1T2]: Got : CreativeDestinationUrl 2012-01-08 16:20:57.574 (2) [P1T2]: YESTERDAYAD_PERFORMANCE_REPORTCampaignIdAdGroupIdHeadlineDescription1Description2DisplayUrlIdAdTypeStatusCreativeDestinationUrl -5ecc211c13cec065600706929725b2b8 2012-01-08 16:20:57.575 (2) [P1T2]: Warning(s) detected in statement [select definitionId from sesystem.googleReportDefinitions where theAdWordsUserId=1458205980 and definitionHash like "-5ecc211c13cec065600706929725b2b8"] executed by user [sesystem] 2012-01-08 16:20:57.576 (2) [P1T2]: SQL Error: Duplicate entry '7179261774--5ecc211c13cec065600706929725b2b8' for key 'theKey' (code:1062) 2012-01-08 16:20:57.576 (2) [P1T2]: Definition found in db: true for hash: -5ecc211c13cec065600706929725b2b8 and account: 1458205980 2012-01-08 16:20:59.286 (2) [DownloaderT1]: Downloading report : Ad Performance Report 2012-01-08 16:20:59.286 (3) [DownloaderT1]: Scheduling report attempt 1: ReportID=60537380 2012-01-08 16:21:06.790 (2) [DownloaderT1]: OK 2012-01-08 16:21:08.226 (2) [DownloaderT1]: Report : Ad Performance Report downloaded. 2012-01-08 16:21:08.439 (2) [DownloaderT1]: Report : Ad Performance Report is valid : true 2012-01-08 16:21:08.513 (2) [P1T2]: Downloaded and validated Ad Performance Report 211374 bytes. 2012-01-08 16:21:08.514 (2) [P1T2]: Parsing report as primary report: Ad Performance Report with 1116868160 bytes free 2012-01-08 16:21:08.516 (3) [P1T2]: parsing columns for Ad Performance Report 2012-01-08 16:21:08.714 (3) [P1T2]: parsing rows for Ad Performance Report 2012-01-08 16:21:09.848 (2) [P1T2]: Finished parsing report: Ad Performance Report 2012-01-08 16:21:11.929 (2) [P1T2]: Created temp file: /var/local/tsa/google_sync_files/tsa-creative-structure-report--1555-2012-01-08 15:35:1019735.tmp 2012-01-08 16:21:11.929 (3) [P1T2]: -- Data staging complete for seuser ((1555) "#005BT - Dentists") 2012-01-08 16:21:11.971 (3) [P1T2]: Loading data infile into temp table... 2012-01-08 16:21:11.975 (2) [P1T2]: Trying to load : /var/local/tsa/google_sync_files/tsa-keyword-structure-report--1555-2012-01-08 15:35:1019731.tmp into `tmp`.`tmp8` 2012-01-08 16:23:41.102 (2) [P1T2]: Trying to load : /var/local/tsa/google_sync_files/tsa-creative-structure-report--1555-2012-01-08 15:35:1019735.tmp into `tmp`.`tmp9` 2012-01-08 16:23:43.141 (3) [P1T2]: LOAD TEMP SYNC TABLES COMPLETED 2012-01-08 16:25:26.258 (3) [P1T2]: Campaigns with new items:([]) 2012-01-08 16:25:26.259 (3) [P1T2]: DETECTION OF NEW CAMPAIGN ITEMS COMPLETED 2012-01-08 16:25:57.351 (3) [P1T2]: Campaigns with deleted items:([]) 2012-01-08 16:25:57.351 (3) [P1T2]: DETECTION OF DELETED CAMPAIGN ITEMS COMPLETED 2012-01-08 16:27:02.749 (3) [P1T2]: Campaigns with updated items:([]) 2012-01-08 16:27:02.750 (3) [P1T2]: DETECTION OF UPDATED CAMPAIGN ITEMS COMPLETED 2012-01-08 16:28:00.148 (3) [P1T2]: 1573830 keyword records removed before re-loading staging table. 2012-01-08 16:31:00.566 (3) [P1T2]: 1573830 keyword records loaded into staging table. 2012-01-08 16:31:00.758 (3) [P1T2]: 10180 creative ad records removed from staging table before re-loading. 2012-01-08 16:31:01.361 (3) [P1T2]: 10180 creative ad records loaded into staging table. 2012-01-08 16:31:01.361 (3) [P1T2]: UPDATE OF STAGING TABLES COMPLETED 2012-01-08 16:31:01.361 (3) [P1T2]: Passing seUserAcctId: 522 and seAcctAcctId: 521 2012-01-08 16:31:01.457 (3) [P1T2]: Replicating 30962 rows... 2012-01-08 16:31:19.654 (3) [P1T1]: Keyword-level bidType changes: 0 2012-01-08 16:31:19.655 (3) [P1T1]: Keyword-level bidAmount changes: 25 2012-01-08 16:31:19.655 (3) [P1T1]: COMPLETED KEYWORD-LEVEL BID DETECTION FOR: seUser (1642) and seAccount(521) 2012-01-08 16:31:21.587 (3) [P1T2]: Change Detected - Campaign(s) with no previous sync history:(SEUserID: 1555 | AcctID: 522) 2012-01-08 16:31:21.587 (3) [P1T2]: CampaignIDs:([47130, 47131]) 2012-01-08 16:31:21.588 (3) [P1T2]: DETECTION OF CAMPAIGNS NEEDING FIRST SYNC COMPLETED 2012-01-08 16:31:21.591 (3) [P1T2]: DETECTION OF CAMPAIGNS WITH CONTENT/NETWORK CHANGES COMPLETED 2012-01-08 16:31:21.591 (3) [P1T2]: -- Account-level operations complete for seuser ((1555) "#005BT - Dentists") and seAccount(521) 2012-01-08 16:36:57.027 (3) [P1T3]: Change Detected - Campaign(s) with no previous sync history:(SEUserID: 1554 | AcctID: 521) 2012-01-08 16:36:57.027 (3) [P1T3]: CampaignIDs:([47130, 47131]) 2012-01-08 16:36:57.027 (3) [P1T3]: DETECTION OF CAMPAIGNS NEEDING FIRST SYNC COMPLETED 2012-01-08 16:36:57.033 (3) [P1T3]: DETECTION OF CAMPAIGNS WITH CONTENT/NETWORK CHANGES COMPLETED 2012-01-08 16:36:57.033 (3) [P1T3]: -- Account-level operations complete for seuser ((1554) "#004BT - Builders") and seAccount(521) 2012-01-08 16:49:46.422 (3) [P1T2]: Keyword-level bidType changes: 0 2012-01-08 16:49:46.422 (3) [P1T2]: Keyword-level bidAmount changes: 0 2012-01-08 16:49:46.423 (3) [P1T2]: COMPLETED KEYWORD-LEVEL BID DETECTION FOR: seUser (1555) and seAccount(521) 2012-01-08 16:51:09.140 (3) [P1T1]: Adgroup-level bidType changes: 0 2012-01-08 16:51:09.140 (3) [P1T1]: Adgroup-level bidAmount changes: 0 2012-01-08 16:51:09.140 (3) [P1T1]: COMPLETED ADGROUP-LEVEL BID DETECTION FOR: seUser (1642) and seAccount(521) 2012-01-08 16:51:09.143 (3) [P1T1]: Owning Account IDs: ("37263") 2012-01-08 16:51:09.143 (3) [P1T1]: -- Bid amount difference checks complete for seuser ((1642) "#006BT - Hotels") and seAccount(521) 2012-01-08 16:51:09.143 (3) [P1T1]: -- Out of sync seaccts found for se user: (1642) "#006BT - Hotels" : [37263, 47130, 47131] 2012-01-08 16:51:09.626 (3) [P1T1]: -- Keyword/Creative difference checks complete for seuser ((1642) "#006BT - Hotels") 2012-01-08 16:51:09.626 (3) [P1T1]: SE Acct Id Set size :: 3 2012-01-08 16:51:09.650 (3) [P1T1]: -- Bulk downloads supported. 2012-01-08 16:51:09.650 (3) [P1T1]: -- Begining search engine sync for user: (1500) "#003BT - Solicitors" 2012-01-08 16:51:09.682 (2) [P1T1]: Created KeywordStructureSyncCriterion, db is googleKeywords 2012-01-08 16:51:09.682 (2) [P1T1]: Created CreativeStructureSyncCriterion 2012-01-08 16:51:09.682 (2) [P1T1]: googleKeywords 2012-01-08 16:51:09.684 (2) [P1T1]: Added Keyword Performance Report AdGroupId to secondaryKeys 2012-01-08 16:51:09.684 (2) [P1T1]: Added Adgroup Performance Report AdGroupId to secondaryKeys 2012-01-08 16:51:09.684 (2) [P1T1]: Added Managed Placement Performance Report AdGroupId to secondaryKeys 2012-01-08 16:51:09.684 (2) [P1T1]: Getting columns for : Adgroup Performance Report 2012-01-08 16:51:09.684 (2) [P1T1]: Got : AdGroupName 2012-01-08 16:51:09.684 (2) [P1T1]: Got : KeywordContentMaxCpc 2012-01-08 16:51:09.684 (2) [P1T1]: Got : ProxyKeywordMaxCpc 2012-01-08 16:51:09.684 (2) [P1T1]: Got : MaxCpm 2012-01-08 16:51:09.685 (2) [P1T1]: Got : SiteMaxCpc 2012-01-08 16:51:09.685 (2) [P1T1]: Got : AdGroupId 2012-01-08 16:51:09.685 (2) [P1T1]: YESTERDAYADGROUP_PERFORMANCE_REPORTAdGroupNameKeywordContentMaxCpcProxyKeywordMaxCpcMaxCpmSiteMaxCpcAdGroupId 14ccfec5d95fbfdfc5160479d0dc93c3 2012-01-08 16:51:09.686 (2) [P1T1]: Warning(s) detected in statement [select definitionId from sesystem.googleReportDefinitions where theAdWordsUserId=3610362231 and definitionHash like "14ccfec5d95fbfdfc5160479d0dc93c3"] executed by user [sesystem] 2012-01-08 16:51:09.686 (2) [P1T1]: SQL Error: Duplicate entry '7179261774--5ecc211c13cec065600706929725b2b8' for key 'theKey' (code:1062) 2012-01-08 16:51:09.686 (2) [P1T1]: Definition found in db: false for hash: 14ccfec5d95fbfdfc5160479d0dc93c3 and account: 3610362231 2012-01-08 16:51:11.089 (2) [P1T1]: Report definition for ADGROUP_PERFORMANCE_REPORT is valid? true 2012-01-08 16:51:12.497 (1) [P1T1]: Error inserting reportDefinition into database: Duplicate entry '3610362231-14ccfec5d95fbfdfc5160479d0dc93c3' for key 'theKey' 2012-01-08 16:51:12.498 (2) [P1T1]: Getting columns for : Keyword Performance Report 2012-01-08 16:51:12.498 (2) [P1T1]: Got : CampaignId 2012-01-08 16:51:12.498 (2) [P1T1]: Got : AdGroupId 2012-01-08 16:51:12.498 (2) [P1T1]: Got : AdGroupStatus 2012-01-08 16:51:12.498 (2) [P1T1]: Got : MaxCpc 2012-01-08 16:51:12.498 (2) [P1T1]: Got : MaxCpm 2012-01-08 16:51:12.498 (2) [P1T1]: Got : KeywordMatchType 2012-01-08 16:51:12.498 (2) [P1T1]: Got : Status 2012-01-08 16:51:12.498 (2) [P1T1]: Got : DestinationUrl 2012-01-08 16:51:12.498 (2) [P1T1]: Got : IsNegative 2012-01-08 16:51:12.498 (2) [P1T1]: Got : KeywordText 2012-01-08 16:51:12.499 (2) [P1T1]: Got : Id 2012-01-08 16:51:12.499 (2) [P1T1]: YESTERDAYKEYWORDS_PERFORMANCE_REPORTCampaignIdAdGroupIdAdGroupStatusMaxCpcMaxCpmKeywordMatchTypeStatusDestinationUrlIsNegativeKeywordTextId 296d860661f7b19d8997e600e5c20868 2012-01-08 16:51:12.500 (2) [P1T1]: Warning(s) detected in statement [select definitionId from sesystem.googleReportDefinitions where theAdWordsUserId=3610362231 and definitionHash like "296d860661f7b19d8997e600e5c20868"] executed by user [sesystem] 2012-01-08 16:51:12.500 (2) [P1T1]: SQL Error: Duplicate entry '3610362231-14ccfec5d95fbfdfc5160479d0dc93c3' for key 'theKey' (code:1062) 2012-01-08 16:51:12.500 (2) [P1T1]: Definition found in db: false for hash: 296d860661f7b19d8997e600e5c20868 and account: 3610362231 2012-01-08 16:51:13.851 (2) [P1T1]: Report definition for KEYWORDS_PERFORMANCE_REPORT is valid? true 2012-01-08 16:51:15.304 (1) [P1T1]: Error inserting reportDefinition into database: Duplicate entry '3610362231-296d860661f7b19d8997e600e5c20868' for key 'theKey' 2012-01-08 16:51:15.304 (2) [P1T1]: Getting columns for : Managed Placement Performance Report 2012-01-08 16:51:15.305 (2) [P1T1]: Got : CampaignId 2012-01-08 16:51:15.305 (2) [P1T1]: Got : AdGroupId 2012-01-08 16:51:15.305 (2) [P1T1]: Got : AdGroupStatus 2012-01-08 16:51:15.305 (2) [P1T1]: Got : MaxCpc 2012-01-08 16:51:15.305 (2) [P1T1]: Got : MaxCpm 2012-01-08 16:51:15.305 (2) [P1T1]: Got : KeywordMatchType 2012-01-08 16:51:15.305 (2) [P1T1]: Got : Status 2012-01-08 16:51:15.305 (2) [P1T1]: Got : DestinationUrl 2012-01-08 16:51:15.305 (2) [P1T1]: Got : IsNegative 2012-01-08 16:51:15.305 (2) [P1T1]: Got : PlacementUrl 2012-01-08 16:51:15.305 (2) [P1T1]: Got : Id 2012-01-08 16:51:15.306 (2) [P1T1]: YESTERDAYMANAGED_PLACEMENTS_PERFORMANCE_REPORTCampaignIdAdGroupIdAdGroupStatusMaxCpcMaxCpmKeywordMatchTypeStatusDestinationUrlIsNegativePlacementUrlId -484d3bf959c59d54610f8b25330785be 2012-01-08 16:51:15.306 (2) [P1T1]: Warning(s) detected in statement [select definitionId from sesystem.googleReportDefinitions where theAdWordsUserId=3610362231 and definitionHash like "-484d3bf959c59d54610f8b25330785be"] executed by user [sesystem] 2012-01-08 16:51:15.307 (2) [P1T1]: SQL Error: Duplicate entry '3610362231-296d860661f7b19d8997e600e5c20868' for key 'theKey' (code:1062) 2012-01-08 16:51:15.307 (2) [P1T1]: Definition found in db: false for hash: -484d3bf959c59d54610f8b25330785be and account: 3610362231 2012-01-08 16:51:16.626 (2) [P1T1]: Report definition for MANAGED_PLACEMENTS_PERFORMANCE_REPORT is valid? true 2012-01-08 16:51:17.972 (1) [P1T1]: Error inserting reportDefinition into database: Duplicate entry '3610362231--484d3bf959c59d54610f8b25330785be' for key 'theKey' 2012-01-08 16:51:17.972 (2) [DownloaderT1]: Downloading report : Adgroup Performance Report 2012-01-08 16:51:17.973 (2) [DownloaderT2]: Downloading report : Keyword Performance Report 2012-01-08 16:51:17.973 (3) [DownloaderT1]: Scheduling report attempt 1: ReportID=286501344 2012-01-08 16:51:17.973 (3) [DownloaderT2]: Scheduling report attempt 1: ReportID=286501464 2012-01-08 16:51:17.974 (2) [DownloaderT3]: Downloading report : Managed Placement Performance Report 2012-01-08 16:51:17.974 (3) [DownloaderT3]: Scheduling report attempt 1: ReportID=286501584 2012-01-08 16:51:24.613 (2) [DownloaderT1]: OK 2012-01-08 16:51:25.122 (2) [DownloaderT1]: Report : Adgroup Performance Report downloaded. 2012-01-08 16:51:25.140 (2) [DownloaderT1]: Report : Adgroup Performance Report is valid : true 2012-01-08 16:52:17.929 (2) [DownloaderT2]: OK 2012-01-08 16:52:19.380 (2) [DownloaderT3]: OK 2012-01-08 16:52:20.127 (2) [DownloaderT3]: Report : Managed Placement Performance Report downloaded. 2012-01-08 16:52:20.218 (2) [DownloaderT3]: Report : Managed Placement Performance Report is valid : true 2012-01-08 16:52:42.485 (2) [DownloaderT2]: Report : Keyword Performance Report downloaded. 2012-01-08 16:53:10.582 (2) [DownloaderT2]: Report : Keyword Performance Report is valid : true 2012-01-08 16:53:10.829 (2) [P1T1]: Downloaded and validated Adgroup Performance Report 19616 bytes. 2012-01-08 16:53:10.829 (2) [P1T1]: Downloaded and validated Keyword Performance Report 34290336 bytes. 2012-01-08 16:53:10.830 (2) [P1T1]: Downloaded and validated Managed Placement Performance Report 58145 bytes. 2012-01-08 16:53:10.830 (2) [P1T1]: Parsing report as secondary report: Adgroup Performance Report 2012-01-08 16:53:10.831 (3) [P1T1]: parsing columns for Adgroup Performance Report 2012-01-08 16:53:10.892 (3) [P1T1]: parsing rows for Adgroup Performance Report 2012-01-08 16:53:10.926 (2) [P1T1]: Finished parsing report: Adgroup Performance Report 2012-01-08 16:53:10.927 (2) [P1T1]: Parsing report as primary report: Keyword Performance Report with 968116808 bytes free 2012-01-08 16:53:10.929 (3) [P1T1]: parsing columns for Keyword Performance Report 2012-01-08 16:53:10.930 (3) [P1T1]: Columns already defined 2012-01-08 16:53:38.669 (3) [P1T1]: parsing rows for Keyword Performance Report 2012-01-08 16:53:57.694 (2) [P1T1]: PrimaryReportRowHandler Parsing row: 100000 2012-01-08 16:54:18.588 (2) [P1T1]: PrimaryReportRowHandler Parsing row: 200000 2012-01-08 16:54:37.964 (2) [P1T1]: PrimaryReportRowHandler Parsing row: 300000 2012-01-08 16:54:57.226 (2) [P1T1]: PrimaryReportRowHandler Parsing row: 400000 2012-01-08 16:55:16.592 (2) [P1T1]: PrimaryReportRowHandler Parsing row: 500000 2012-01-08 16:55:34.992 (2) [P1T1]: PrimaryReportRowHandler Parsing row: 600000 2012-01-08 16:55:53.470 (2) [P1T1]: PrimaryReportRowHandler Parsing row: 700000 2012-01-08 16:56:11.722 (2) [P1T1]: PrimaryReportRowHandler Parsing row: 800000 2012-01-08 16:56:29.962 (2) [P1T1]: PrimaryReportRowHandler Parsing row: 900000 2012-01-08 16:56:47.835 (2) [P1T1]: PrimaryReportRowHandler Parsing row: 1000000 2012-01-08 16:57:07.038 (2) [P1T1]: PrimaryReportRowHandler Parsing row: 1100000 2012-01-08 16:57:10.188 (2) [P1T1]: Finished parsing report: Keyword Performance Report 2012-01-08 16:57:10.188 (2) [P1T1]: Parsing report as primary report: Managed Placement Performance Report with 1391032032 bytes free 2012-01-08 16:57:10.196 (3) [P1T1]: parsing columns for Managed Placement Performance Report 2012-01-08 16:57:10.197 (3) [P1T1]: Columns already defined 2012-01-08 16:57:10.385 (3) [P1T1]: parsing rows for Managed Placement Performance Report 2012-01-08 16:57:12.394 (2) [P1T1]: Finished parsing report: Managed Placement Performance Report 2012-01-08 16:57:28.247 (2) [P1T1]: Created temp file: /var/local/tsa/google_sync_files/tsa-keyword-structure-report--1500-2012-01-08 16:51:0919736.tmp 2012-01-08 16:57:28.248 (2) [P1T1]: googleAds 2012-01-08 16:57:28.248 (2) [P1T1]: Getting columns for : Ad Performance Report 2012-01-08 16:57:28.248 (2) [P1T1]: Got : CampaignId 2012-01-08 16:57:28.248 (2) [P1T1]: Got : AdGroupId 2012-01-08 16:57:28.249 (2) [P1T1]: Got : Headline 2012-01-08 16:57:28.249 (2) [P1T1]: Got : Description1 2012-01-08 16:57:28.249 (2) [P1T1]: Got : Description2 2012-01-08 16:57:28.249 (2) [P1T1]: Got : DisplayUrl 2012-01-08 16:57:28.249 (2) [P1T1]: Got : Id 2012-01-08 16:57:28.249 (2) [P1T1]: Got : AdType 2012-01-08 16:57:28.249 (2) [P1T1]: Got : Status 2012-01-08 16:57:28.249 (2) [P1T1]: Got : CreativeDestinationUrl 2012-01-08 16:57:28.250 (2) [P1T1]: YESTERDAYAD_PERFORMANCE_REPORTCampaignIdAdGroupIdHeadlineDescription1Description2DisplayUrlIdAdTypeStatusCreativeDestinationUrl -5ecc211c13cec065600706929725b2b8 2012-01-08 16:57:28.250 (2) [P1T1]: Warning(s) detected in statement [select definitionId from sesystem.googleReportDefinitions where theAdWordsUserId=3610362231 and definitionHash like "-5ecc211c13cec065600706929725b2b8"] executed by user [sesystem] 2012-01-08 16:57:28.251 (2) [P1T1]: SQL Error: Duplicate entry '3610362231--484d3bf959c59d54610f8b25330785be' for key 'theKey' (code:1062) 2012-01-08 16:57:28.251 (2) [P1T1]: Definition found in db: true for hash: -5ecc211c13cec065600706929725b2b8 and account: 3610362231 2012-01-08 16:57:29.833 (2) [DownloaderT1]: Downloading report : Ad Performance Report 2012-01-08 16:57:29.833 (3) [DownloaderT1]: Scheduling report attempt 1: ReportID=48105624 2012-01-08 16:57:31.780 (2) [DownloaderT1]: OK 2012-01-08 16:57:32.872 (2) [DownloaderT1]: Report : Ad Performance Report downloaded. 2012-01-08 16:57:33.002 (2) [DownloaderT1]: Report : Ad Performance Report is valid : true 2012-01-08 16:57:33.158 (2) [P1T1]: Downloaded and validated Ad Performance Report 155938 bytes. 2012-01-08 16:57:33.158 (2) [P1T1]: Parsing report as primary report: Ad Performance Report with 1593989864 bytes free 2012-01-08 16:57:33.160 (3) [P1T1]: parsing columns for Ad Performance Report 2012-01-08 16:57:33.301 (3) [P1T1]: parsing rows for Ad Performance Report 2012-01-08 16:57:34.080 (2) [P1T1]: Finished parsing report: Ad Performance Report 2012-01-08 16:57:36.131 (2) [P1T1]: Created temp file: /var/local/tsa/google_sync_files/tsa-creative-structure-report--1500-2012-01-08 16:51:0919737.tmp 2012-01-08 16:57:36.131 (3) [P1T1]: -- Data staging complete for seuser ((1500) "#003BT - Solicitors") 2012-01-08 16:57:36.144 (3) [P1T1]: Loading data infile into temp table... 2012-01-08 16:57:36.983 (2) [P1T1]: Trying to load : /var/local/tsa/google_sync_files/tsa-keyword-structure-report--1500-2012-01-08 16:51:0919736.tmp into `tmp`.`tmp15` 2012-01-08 17:00:00.479 (2) [P1T1]: Trying to load : /var/local/tsa/google_sync_files/tsa-creative-structure-report--1500-2012-01-08 16:51:0919737.tmp into `tmp`.`tmp16` 2012-01-08 17:00:01.253 (3) [P1T1]: LOAD TEMP SYNC TABLES COMPLETED 2012-01-08 17:00:39.220 (3) [P1T1]: Campaigns with new items:([]) 2012-01-08 17:00:39.220 (3) [P1T1]: DETECTION OF NEW CAMPAIGN ITEMS COMPLETED 2012-01-08 17:01:02.253 (3) [P1T1]: Campaigns with deleted items:([]) 2012-01-08 17:01:02.253 (3) [P1T1]: DETECTION OF DELETED CAMPAIGN ITEMS COMPLETED 2012-01-08 17:01:44.736 (3) [P1T3]: Keyword-level bidType changes: 0 2012-01-08 17:01:44.736 (3) [P1T3]: Keyword-level bidAmount changes: 0 2012-01-08 17:01:44.736 (3) [P1T3]: COMPLETED KEYWORD-LEVEL BID DETECTION FOR: seUser (1554) and seAccount(521) 2012-01-08 17:01:50.995 (3) [P1T1]: Campaigns with updated items:([]) 2012-01-08 17:01:50.995 (3) [P1T1]: DETECTION OF UPDATED CAMPAIGN ITEMS COMPLETED 2012-01-08 17:02:21.359 (3) [P1T1]: 1111898 keyword records removed before re-loading staging table. 2012-01-08 17:04:12.522 (3) [P1T1]: 1111898 keyword records loaded into staging table. 2012-01-08 17:04:12.634 (3) [P1T1]: 7246 creative ad records removed from staging table before re-loading. 2012-01-08 17:04:12.986 (3) [P1T1]: 7246 creative ad records loaded into staging table. 2012-01-08 17:04:12.987 (3) [P1T1]: UPDATE OF STAGING TABLES COMPLETED 2012-01-08 17:04:12.987 (3) [P1T1]: Passing seUserAcctId: 488 and seAcctAcctId: 521 2012-01-08 17:04:13.059 (3) [P1T1]: Replicating 22971 rows... 2012-01-08 17:04:25.469 (3) [P1T1]: Change Detected - Campaign(s) with no previous sync history:(SEUserID: 1500 | AcctID: 488) 2012-01-08 17:04:25.470 (3) [P1T1]: CampaignIDs:([47130, 47131]) 2012-01-08 17:04:25.470 (3) [P1T1]: DETECTION OF CAMPAIGNS NEEDING FIRST SYNC COMPLETED 2012-01-08 17:04:25.473 (3) [P1T1]: DETECTION OF CAMPAIGNS WITH CONTENT/NETWORK CHANGES COMPLETED 2012-01-08 17:04:25.473 (3) [P1T1]: -- Account-level operations complete for seuser ((1500) "#003BT - Solicitors") and seAccount(521) 2012-01-08 17:14:55.894 (3) [P1T2]: Adgroup-level bidType changes: 0 2012-01-08 17:14:55.894 (3) [P1T2]: Adgroup-level bidAmount changes: 0 2012-01-08 17:14:55.894 (3) [P1T2]: COMPLETED ADGROUP-LEVEL BID DETECTION FOR: seUser (1555) and seAccount(521) 2012-01-08 17:14:55.894 (3) [P1T2]: -- Bid amount difference checks complete for seuser ((1555) "#005BT - Dentists") and seAccount(521) 2012-01-08 17:14:55.894 (3) [P1T2]: -- Out of sync seaccts found for se user: (1555) "#005BT - Dentists" : [47130, 47131] 2012-01-08 17:14:57.601 (3) [P1T2]: -- Keyword/Creative difference checks complete for seuser ((1555) "#005BT - Dentists") 2012-01-08 17:14:57.601 (3) [P1T2]: SE Acct Id Set size :: 3 2012-01-08 17:14:57.613 (3) [P1T2]: -- Bulk downloads supported. 2012-01-08 17:14:57.614 (3) [P1T2]: -- Begining search engine sync for user: (1502) "#002BT - Beauty Salons" 2012-01-08 17:14:57.645 (2) [P1T2]: Created KeywordStructureSyncCriterion, db is googleKeywords 2012-01-08 17:14:57.645 (2) [P1T2]: Created CreativeStructureSyncCriterion 2012-01-08 17:14:57.645 (2) [P1T2]: googleKeywords 2012-01-08 17:14:57.656 (2) [P1T2]: Added Keyword Performance Report AdGroupId to secondaryKeys 2012-01-08 17:14:57.656 (2) [P1T2]: Added Adgroup Performance Report AdGroupId to secondaryKeys 2012-01-08 17:14:57.656 (2) [P1T2]: Added Managed Placement Performance Report AdGroupId to secondaryKeys 2012-01-08 17:14:57.656 (2) [P1T2]: Getting columns for : Adgroup Performance Report 2012-01-08 17:14:57.656 (2) [P1T2]: Got : AdGroupName 2012-01-08 17:14:57.657 (2) [P1T2]: Got : KeywordContentMaxCpc 2012-01-08 17:14:57.657 (2) [P1T2]: Got : ProxyKeywordMaxCpc 2012-01-08 17:14:57.657 (2) [P1T2]: Got : MaxCpm 2012-01-08 17:14:57.657 (2) [P1T2]: Got : SiteMaxCpc 2012-01-08 17:14:57.657 (2) [P1T2]: Got : AdGroupId 2012-01-08 17:14:57.657 (2) [P1T2]: YESTERDAYADGROUP_PERFORMANCE_REPORTAdGroupNameKeywordContentMaxCpcProxyKeywordMaxCpcMaxCpmSiteMaxCpcAdGroupId 14ccfec5d95fbfdfc5160479d0dc93c3 2012-01-08 17:14:57.658 (2) [P1T2]: Warning(s) detected in statement [select definitionId from sesystem.googleReportDefinitions where theAdWordsUserId=9528222137 and definitionHash like "14ccfec5d95fbfdfc5160479d0dc93c3"] executed by user [sesystem] 2012-01-08 17:14:57.658 (2) [P1T2]: SQL Error: Duplicate entry '3610362231--484d3bf959c59d54610f8b25330785be' for key 'theKey' (code:1062) 2012-01-08 17:14:57.659 (2) [P1T2]: Definition found in db: false for hash: 14ccfec5d95fbfdfc5160479d0dc93c3 and account: 9528222137 2012-01-08 17:14:59.242 (2) [P1T2]: Report definition for ADGROUP_PERFORMANCE_REPORT is valid? true 2012-01-08 17:15:00.996 (1) [P1T2]: Error inserting reportDefinition into database: Duplicate entry '9528222137-14ccfec5d95fbfdfc5160479d0dc93c3' for key 'theKey' 2012-01-08 17:15:00.997 (2) [P1T2]: Getting columns for : Keyword Performance Report 2012-01-08 17:15:00.997 (2) [P1T2]: Got : CampaignId 2012-01-08 17:15:00.997 (2) [P1T2]: Got : AdGroupId 2012-01-08 17:15:00.997 (2) [P1T2]: Got : AdGroupStatus 2012-01-08 17:15:00.997 (2) [P1T2]: Got : MaxCpc 2012-01-08 17:15:00.997 (2) [P1T2]: Got : MaxCpm 2012-01-08 17:15:00.997 (2) [P1T2]: Got : KeywordMatchType 2012-01-08 17:15:00.997 (2) [P1T2]: Got : Status 2012-01-08 17:15:00.997 (2) [P1T2]: Got : DestinationUrl 2012-01-08 17:15:00.997 (2) [P1T2]: Got : IsNegative 2012-01-08 17:15:00.997 (2) [P1T2]: Got : KeywordText 2012-01-08 17:15:00.997 (2) [P1T2]: Got : Id 2012-01-08 17:15:00.998 (2) [P1T2]: YESTERDAYKEYWORDS_PERFORMANCE_REPORTCampaignIdAdGroupIdAdGroupStatusMaxCpcMaxCpmKeywordMatchTypeStatusDestinationUrlIsNegativeKeywordTextId 296d860661f7b19d8997e600e5c20868 2012-01-08 17:15:00.998 (2) [P1T2]: Warning(s) detected in statement [select definitionId from sesystem.googleReportDefinitions where theAdWordsUserId=9528222137 and definitionHash like "296d860661f7b19d8997e600e5c20868"] executed by user [sesystem] 2012-01-08 17:15:00.999 (2) [P1T2]: SQL Error: Duplicate entry '9528222137-14ccfec5d95fbfdfc5160479d0dc93c3' for key 'theKey' (code:1062) 2012-01-08 17:15:00.999 (2) [P1T2]: Definition found in db: false for hash: 296d860661f7b19d8997e600e5c20868 and account: 9528222137 2012-01-08 17:15:02.838 (2) [P1T2]: Report definition for KEYWORDS_PERFORMANCE_REPORT is valid? true 2012-01-08 17:15:04.613 (1) [P1T2]: Error inserting reportDefinition into database: Duplicate entry '9528222137-296d860661f7b19d8997e600e5c20868' for key 'theKey' 2012-01-08 17:15:04.613 (2) [P1T2]: Getting columns for : Managed Placement Performance Report 2012-01-08 17:15:04.614 (2) [P1T2]: Got : CampaignId 2012-01-08 17:15:04.614 (2) [P1T2]: Got : AdGroupId 2012-01-08 17:15:04.614 (2) [P1T2]: Got : AdGroupStatus 2012-01-08 17:15:04.614 (2) [P1T2]: Got : MaxCpc 2012-01-08 17:15:04.614 (2) [P1T2]: Got : MaxCpm 2012-01-08 17:15:04.614 (2) [P1T2]: Got : KeywordMatchType 2012-01-08 17:15:04.614 (2) [P1T2]: Got : Status 2012-01-08 17:15:04.614 (2) [P1T2]: Got : DestinationUrl 2012-01-08 17:15:04.614 (2) [P1T2]: Got : IsNegative 2012-01-08 17:15:04.614 (2) [P1T2]: Got : PlacementUrl 2012-01-08 17:15:04.614 (2) [P1T2]: Got : Id 2012-01-08 17:15:04.615 (2) [P1T2]: YESTERDAYMANAGED_PLACEMENTS_PERFORMANCE_REPORTCampaignIdAdGroupIdAdGroupStatusMaxCpcMaxCpmKeywordMatchTypeStatusDestinationUrlIsNegativePlacementUrlId -484d3bf959c59d54610f8b25330785be 2012-01-08 17:15:04.616 (2) [P1T2]: Warning(s) detected in statement [select definitionId from sesystem.googleReportDefinitions where theAdWordsUserId=9528222137 and definitionHash like "-484d3bf959c59d54610f8b25330785be"] executed by user [sesystem] 2012-01-08 17:15:04.616 (2) [P1T2]: SQL Error: Duplicate entry '9528222137-296d860661f7b19d8997e600e5c20868' for key 'theKey' (code:1062) 2012-01-08 17:15:04.616 (2) [P1T2]: Definition found in db: false for hash: -484d3bf959c59d54610f8b25330785be and account: 9528222137 2012-01-08 17:15:06.401 (2) [P1T2]: Report definition for MANAGED_PLACEMENTS_PERFORMANCE_REPORT is valid? true 2012-01-08 17:15:08.295 (1) [P1T2]: Error inserting reportDefinition into database: Duplicate entry '9528222137--484d3bf959c59d54610f8b25330785be' for key 'theKey' 2012-01-08 17:15:08.295 (2) [DownloaderT1]: Downloading report : Adgroup Performance Report 2012-01-08 17:15:08.296 (2) [DownloaderT3]: Downloading report : Managed Placement Performance Report 2012-01-08 17:15:08.296 (3) [DownloaderT1]: Scheduling report attempt 1: ReportID=477673154 2012-01-08 17:15:08.296 (3) [DownloaderT3]: Scheduling report attempt 1: ReportID=477673394 2012-01-08 17:15:08.297 (2) [DownloaderT2]: Downloading report : Keyword Performance Report 2012-01-08 17:15:08.297 (3) [DownloaderT2]: Scheduling report attempt 1: ReportID=477673274 2012-01-08 17:15:10.984 (2) [DownloaderT1]: OK 2012-01-08 17:15:11.493 (2) [DownloaderT1]: Report : Adgroup Performance Report downloaded. 2012-01-08 17:15:11.515 (2) [DownloaderT1]: Report : Adgroup Performance Report is valid : true 2012-01-08 17:15:46.271 (2) [DownloaderT2]: OK 2012-01-08 17:15:47.477 (2) [DownloaderT3]: OK 2012-01-08 17:15:47.478 (2) [DownloaderT3]: Report : Managed Placement Performance Report downloaded. 2012-01-08 17:15:47.480 (2) [DownloaderT3]: Report : Managed Placement Performance Report is valid : true 2012-01-08 17:16:10.160 (2) [DownloaderT2]: Report : Keyword Performance Report downloaded. 2012-01-08 17:16:32.574 (2) [DownloaderT2]: Report : Keyword Performance Report is valid : true 2012-01-08 17:16:32.633 (2) [P1T2]: Downloaded and validated Adgroup Performance Report 31687 bytes. 2012-01-08 17:16:32.633 (2) [P1T2]: Downloaded and validated Keyword Performance Report 32746479 bytes. 2012-01-08 17:16:32.633 (2) [P1T2]: Downloaded and validated Managed Placement Performance Report 317 bytes. 2012-01-08 17:16:32.633 (2) [P1T2]: Parsing report as secondary report: Adgroup Performance Report 2012-01-08 17:16:32.635 (3) [P1T2]: parsing columns for Adgroup Performance Report 2012-01-08 17:16:32.655 (3) [P1T2]: parsing rows for Adgroup Performance Report 2012-01-08 17:16:32.720 (2) [P1T2]: Finished parsing report: Adgroup Performance Report 2012-01-08 17:16:32.720 (2) [P1T2]: Parsing report as primary report: Keyword Performance Report with 1475702360 bytes free 2012-01-08 17:16:32.722 (3) [P1T2]: parsing columns for Keyword Performance Report 2012-01-08 17:16:32.723 (3) [P1T2]: Columns already defined 2012-01-08 17:16:55.292 (3) [P1T2]: parsing rows for Keyword Performance Report 2012-01-08 17:17:08.982 (2) [P1T2]: PrimaryReportRowHandler Parsing row: 100000 2012-01-08 17:17:09.272 (2) [P1T2]: Exception [afterExecute: exception thrown from thread in threadpool]:java.util.concurrent.ExecutionException: java.lang.OutOfMemoryError: Java heap space at java.util.concurrent.FutureTask$Sync.innerGet(Unknown Source) at java.util.concurrent.FutureTask.get(Unknown Source) at com.carldunham.jst.concurrency.ThreadPool$CachedFixedThreadPool.afterExecute(ThreadPool.java:252) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source) Caused by: java.lang.OutOfMemoryError: Java heap space 2012-01-08 17:17:09.432 (3) [P1T2]: -- Bulk downloads supported. 2012-01-08 17:17:09.432 (3) [P1T2]: -- Begining search engine sync for user: (1503) "#001BT - Accountants" 2012-01-08 17:17:09.689 (2) [P1T2]: Created KeywordStructureSyncCriterion, db is googleKeywords 2012-01-08 17:17:09.690 (2) [P1T2]: Created CreativeStructureSyncCriterion 2012-01-08 17:17:09.690 (2) [P1T2]: googleKeywords 2012-01-08 17:17:09.690 (2) [P1T2]: Added Keyword Performance Report AdGroupId to secondaryKeys 2012-01-08 17:17:09.690 (2) [P1T2]: Added Adgroup Performance Report AdGroupId to secondaryKeys 2012-01-08 17:17:09.691 (2) [P1T2]: Added Managed Placement Performance Report AdGroupId to secondaryKeys 2012-01-08 17:17:09.691 (2) [P1T2]: Getting columns for : Adgroup Performance Report 2012-01-08 17:17:09.691 (2) [P1T2]: Got : AdGroupName 2012-01-08 17:17:09.691 (2) [P1T2]: Got : KeywordContentMaxCpc 2012-01-08 17:17:09.691 (2) [P1T2]: Got : ProxyKeywordMaxCpc 2012-01-08 17:17:09.691 (2) [P1T2]: Got : MaxCpm 2012-01-08 17:17:09.691 (2) [P1T2]: Got : SiteMaxCpc 2012-01-08 17:17:09.691 (2) [P1T2]: Got : AdGroupId 2012-01-08 17:17:09.691 (2) [P1T2]: YESTERDAYADGROUP_PERFORMANCE_REPORTAdGroupNameKeywordContentMaxCpcProxyKeywordMaxCpcMaxCpmSiteMaxCpcAdGroupId 14ccfec5d95fbfdfc5160479d0dc93c3 2012-01-08 17:17:09.692 (2) [P1T2]: Warning(s) detected in statement [select definitionId from sesystem.googleReportDefinitions where theAdWordsUserId=5894935392 and definitionHash like "14ccfec5d95fbfdfc5160479d0dc93c3"] executed by user [sesystem] 2012-01-08 17:17:09.693 (2) [P1T2]: SQL Error: Duplicate entry '9528222137--484d3bf959c59d54610f8b25330785be' for key 'theKey' (code:1062) 2012-01-08 17:17:09.693 (2) [P1T2]: Definition found in db: false for hash: 14ccfec5d95fbfdfc5160479d0dc93c3 and account: 5894935392 2012-01-08 17:17:11.391 (2) [P1T2]: Report definition for ADGROUP_PERFORMANCE_REPORT is valid? true 2012-01-08 17:17:12.817 (1) [P1T2]: Error inserting reportDefinition into database: Duplicate entry '5894935392-14ccfec5d95fbfdfc5160479d0dc93c3' for key 'theKey' 2012-01-08 17:17:12.818 (2) [P1T2]: Getting columns for : Keyword Performance Report 2012-01-08 17:17:12.818 (2) [P1T2]: Got : CampaignId 2012-01-08 17:17:12.818 (2) [P1T2]: Got : AdGroupId 2012-01-08 17:17:12.818 (2) [P1T2]: Got : AdGroupStatus 2012-01-08 17:17:12.818 (2) [P1T2]: Got : MaxCpc 2012-01-08 17:17:12.818 (2) [P1T2]: Got : MaxCpm 2012-01-08 17:17:12.818 (2) [P1T2]: Got : KeywordMatchType 2012-01-08 17:17:12.818 (2) [P1T2]: Got : Status 2012-01-08 17:17:12.818 (2) [P1T2]: Got : DestinationUrl 2012-01-08 17:17:12.818 (2) [P1T2]: Got : IsNegative 2012-01-08 17:17:12.818 (2) [P1T2]: Got : KeywordText 2012-01-08 17:17:12.818 (2) [P1T2]: Got : Id 2012-01-08 17:17:12.819 (2) [P1T2]: YESTERDAYKEYWORDS_PERFORMANCE_REPORTCampaignIdAdGroupIdAdGroupStatusMaxCpcMaxCpmKeywordMatchTypeStatusDestinationUrlIsNegativeKeywordTextId 296d860661f7b19d8997e600e5c20868 2012-01-08 17:17:12.819 (2) [P1T2]: Warning(s) detected in statement [select definitionId from sesystem.googleReportDefinitions where theAdWordsUserId=5894935392 and definitionHash like "296d860661f7b19d8997e600e5c20868"] executed by user [sesystem] 2012-01-08 17:17:12.827 (2) [P1T2]: SQL Error: Duplicate entry '5894935392-14ccfec5d95fbfdfc5160479d0dc93c3' for key 'theKey' (code:1062) 2012-01-08 17:17:12.827 (2) [P1T2]: Definition found in db: false for hash: 296d860661f7b19d8997e600e5c20868 and account: 5894935392 2012-01-08 17:17:14.204 (2) [P1T2]: Report definition for KEYWORDS_PERFORMANCE_REPORT is valid? true 2012-01-08 17:17:16.287 (1) [P1T2]: Error inserting reportDefinition into database: Duplicate entry '5894935392-296d860661f7b19d8997e600e5c20868' for key 'theKey' 2012-01-08 17:17:16.287 (2) [P1T2]: Getting columns for : Managed Placement Performance Report 2012-01-08 17:17:16.287 (2) [P1T2]: Got : CampaignId 2012-01-08 17:17:16.287 (2) [P1T2]: Got : AdGroupId 2012-01-08 17:17:16.288 (2) [P1T2]: Got : AdGroupStatus 2012-01-08 17:17:16.288 (2) [P1T2]: Got : MaxCpc 2012-01-08 17:17:16.288 (2) [P1T2]: Got : MaxCpm 2012-01-08 17:17:16.288 (2) [P1T2]: Got : KeywordMatchType 2012-01-08 17:17:16.288 (2) [P1T2]: Got : Status 2012-01-08 17:17:16.288 (2) [P1T2]: Got : DestinationUrl 2012-01-08 17:17:16.288 (2) [P1T2]: Got : IsNegative 2012-01-08 17:17:16.288 (2) [P1T2]: Got : PlacementUrl 2012-01-08 17:17:16.288 (2) [P1T2]: Got : Id 2012-01-08 17:17:16.289 (2) [P1T2]: YESTERDAYMANAGED_PLACEMENTS_PERFORMANCE_REPORTCampaignIdAdGroupIdAdGroupStatusMaxCpcMaxCpmKeywordMatchTypeStatusDestinationUrlIsNegativePlacementUrlId -484d3bf959c59d54610f8b25330785be 2012-01-08 17:17:16.289 (2) [P1T2]: Warning(s) detected in statement [select definitionId from sesystem.googleReportDefinitions where theAdWordsUserId=5894935392 and definitionHash like "-484d3bf959c59d54610f8b25330785be"] executed by user [sesystem] 2012-01-08 17:17:16.290 (2) [P1T2]: SQL Error: Duplicate entry '5894935392-296d860661f7b19d8997e600e5c20868' for key 'theKey' (code:1062) 2012-01-08 17:17:16.290 (2) [P1T2]: Definition found in db: false for hash: -484d3bf959c59d54610f8b25330785be and account: 5894935392 2012-01-08 17:17:18.029 (2) [P1T2]: Report definition for MANAGED_PLACEMENTS_PERFORMANCE_REPORT is valid? true 2012-01-08 17:17:19.401 (1) [P1T2]: Error inserting reportDefinition into database: Duplicate entry '5894935392--484d3bf959c59d54610f8b25330785be' for key 'theKey' 2012-01-08 17:17:19.402 (2) [DownloaderT1]: Downloading report : Adgroup Performance Report 2012-01-08 17:17:19.402 (2) [DownloaderT3]: Downloading report : Managed Placement Performance Report 2012-01-08 17:17:19.402 (3) [DownloaderT1]: Scheduling report attempt 1: ReportID=341868499 2012-01-08 17:17:19.402 (3) [DownloaderT3]: Scheduling report attempt 1: ReportID=341868739 2012-01-08 17:17:19.403 (2) [DownloaderT2]: Downloading report : Keyword Performance Report 2012-01-08 17:17:19.403 (3) [DownloaderT2]: Scheduling report attempt 1: ReportID=341868619 2012-01-08 17:17:27.218 (2) [DownloaderT3]: OK 2012-01-08 17:17:27.682 (2) [DownloaderT1]: OK 2012-01-08 17:17:28.692 (2) [DownloaderT1]: Report : Adgroup Performance Report downloaded. 2012-01-08 17:17:28.757 (2) [DownloaderT1]: Report : Adgroup Performance Report is valid : true 2012-01-08 17:17:29.067 (2) [DownloaderT3]: Report : Managed Placement Performance Report downloaded. 2012-01-08 17:17:29.537 (2) [DownloaderT3]: Report : Managed Placement Performance Report is valid : true 2012-01-08 17:19:00.723 (2) [DownloaderT2]: OK 2012-01-08 17:19:35.715 (2) [DownloaderT2]: Report : Keyword Performance Report downloaded. 2012-01-08 17:20:22.381 (2) [DownloaderT2]: Report : Keyword Performance Report is valid : true 2012-01-08 17:20:22.416 (2) [P1T2]: Downloaded and validated Adgroup Performance Report 85615 bytes. 2012-01-08 17:20:22.417 (2) [P1T2]: Downloaded and validated Keyword Performance Report 59715475 bytes. 2012-01-08 17:20:22.417 (2) [P1T2]: Downloaded and validated Managed Placement Performance Report 377113 bytes. 2012-01-08 17:20:22.417 (2) [P1T2]: Parsing report as secondary report: Adgroup Performance Report 2012-01-08 17:20:22.419 (3) [P1T2]: parsing columns for Adgroup Performance Report 2012-01-08 17:20:22.471 (3) [P1T2]: parsing rows for Adgroup Performance Report 2012-01-08 17:20:22.662 (2) [P1T2]: Finished parsing report: Adgroup Performance Report 2012-01-08 17:20:22.663 (2) [P1T2]: Parsing report as primary report: Keyword Performance Report with 1010589696 bytes free 2012-01-08 17:20:22.665 (3) [P1T2]: parsing columns for Keyword Performance Report 2012-01-08 17:20:22.666 (3) [P1T2]: Columns already defined 2012-01-08 17:21:09.201 (3) [P1T2]: parsing rows for Keyword Performance Report 2012-01-08 17:21:22.868 (3) [main]: ThreadPool finished 3/6 tasks, 3 active tasks, 3 active threads. 3 tasks remaining. 2012-01-08 17:21:26.450 (2) [P1T2]: PrimaryReportRowHandler Parsing row: 100000 2012-01-08 17:21:45.314 (2) [P1T2]: PrimaryReportRowHandler Parsing row: 200000 2012-01-08 17:22:04.779 (2) [P1T2]: PrimaryReportRowHandler Parsing row: 300000 2012-01-08 17:22:22.998 (3) [main]: ThreadPool finished 3/6 tasks, 3 active tasks, 3 active threads. 3 tasks remaining. 2012-01-08 17:22:25.659 (2) [P1T2]: PrimaryReportRowHandler Parsing row: 400000 2012-01-08 17:22:35.293 (2) [Finalizer]: AccountDatabases: finalize: unloading connections - app may need updates? 2012-01-08 17:22:47.908 (2) [P1T2]: PrimaryReportRowHandler Parsing row: 500000 2012-01-08 17:23:09.129 (2) [P1T2]: PrimaryReportRowHandler Parsing row: 600000 2012-01-08 17:23:23.064 (3) [main]: ThreadPool finished 3/6 tasks, 3 active tasks, 3 active threads. 3 tasks remaining. 2012-01-08 17:23:30.523 (2) [P1T2]: PrimaryReportRowHandler Parsing row: 700000 2012-01-08 17:23:51.661 (2) [P1T2]: PrimaryReportRowHandler Parsing row: 800000 2012-01-08 17:24:13.076 (2) [P1T2]: PrimaryReportRowHandler Parsing row: 900000 2012-01-08 17:24:23.112 (3) [main]: ThreadPool finished 3/6 tasks, 3 active tasks, 3 active threads. 3 tasks remaining. 2012-01-08 17:24:34.774 (2) [P1T2]: PrimaryReportRowHandler Parsing row: 1000000 2012-01-08 17:24:55.783 (2) [P1T2]: PrimaryReportRowHandler Parsing row: 1100000 2012-01-08 17:25:17.437 (2) [P1T2]: PrimaryReportRowHandler Parsing row: 1200000 2012-01-08 17:25:23.196 (3) [main]: ThreadPool finished 3/6 tasks, 3 active tasks, 3 active threads. 3 tasks remaining. 2012-01-08 17:25:38.703 (2) [P1T2]: PrimaryReportRowHandler Parsing row: 1300000 2012-01-08 17:25:59.846 (2) [P1T2]: PrimaryReportRowHandler Parsing row: 1400000 2012-01-08 17:26:21.108 (2) [P1T2]: PrimaryReportRowHandler Parsing row: 1500000 2012-01-08 17:26:23.252 (3) [main]: ThreadPool finished 3/6 tasks, 3 active tasks, 3 active threads. 3 tasks remaining. 2012-01-08 17:26:42.066 (2) [P1T2]: PrimaryReportRowHandler Parsing row: 1600000 2012-01-08 17:27:02.881 (2) [P1T2]: PrimaryReportRowHandler Parsing row: 1700000 2012-01-08 17:27:23.279 (3) [main]: ThreadPool finished 3/6 tasks, 3 active tasks, 3 active threads. 3 tasks remaining. 2012-01-08 17:27:25.892 (2) [P1T2]: PrimaryReportRowHandler Parsing row: 1800000 2012-01-08 17:27:48.739 (2) [P1T2]: PrimaryReportRowHandler Parsing row: 1900000 2012-01-08 17:28:12.304 (2) [P1T2]: PrimaryReportRowHandler Parsing row: 2000000 2012-01-08 17:28:23.338 (3) [main]: ThreadPool finished 3/6 tasks, 3 active tasks, 3 active threads. 3 tasks remaining. 2012-01-08 17:28:34.735 (2) [P1T2]: PrimaryReportRowHandler Parsing row: 2100000 2012-01-08 17:28:40.723 (2) [P1T2]: Finished parsing report: Keyword Performance Report 2012-01-08 17:28:40.723 (2) [P1T2]: Parsing report as primary report: Managed Placement Performance Report with 654891400 bytes free 2012-01-08 17:28:40.725 (3) [P1T2]: parsing columns for Managed Placement Performance Report 2012-01-08 17:28:40.726 (3) [P1T2]: Columns already defined 2012-01-08 17:28:41.221 (3) [P1T2]: parsing rows for Managed Placement Performance Report 2012-01-08 17:28:47.686 (2) [P1T2]: Finished parsing report: Managed Placement Performance Report 2012-01-08 17:29:11.584 (2) [P1T2]: Created temp file: /var/local/tsa/google_sync_files/tsa-keyword-structure-report--1503-2012-01-08 17:17:0919739.tmp 2012-01-08 17:29:24.889 (2) [P1T2]: googleAds 2012-01-08 17:29:24.895 (3) [main]: ThreadPool finished 3/6 tasks, 3 active tasks, 3 active threads. 3 tasks remaining. 2012-01-08 17:29:24.935 (2) [P1T2]: Getting columns for : Ad Performance Report 2012-01-08 17:29:24.935 (2) [P1T2]: Got : CampaignId 2012-01-08 17:29:24.935 (2) [P1T2]: Got : AdGroupId 2012-01-08 17:29:24.935 (2) [P1T2]: Got : Headline 2012-01-08 17:29:24.935 (2) [P1T2]: Got : Description1 2012-01-08 17:29:24.936 (2) [P1T2]: Got : Description2 2012-01-08 17:29:24.936 (2) [P1T2]: Got : DisplayUrl 2012-01-08 17:29:24.936 (2) [P1T2]: Got : Id 2012-01-08 17:29:24.936 (2) [P1T2]: Got : AdType 2012-01-08 17:29:24.936 (2) [P1T2]: Got : Status 2012-01-08 17:29:24.936 (2) [P1T2]: Got : CreativeDestinationUrl 2012-01-08 17:29:24.936 (2) [P1T2]: YESTERDAYAD_PERFORMANCE_REPORTCampaignIdAdGroupIdHeadlineDescription1Description2DisplayUrlIdAdTypeStatusCreativeDestinationUrl -5ecc211c13cec065600706929725b2b8 2012-01-08 17:29:24.937 (2) [P1T2]: Warning(s) detected in statement [select definitionId from sesystem.googleReportDefinitions where theAdWordsUserId=5894935392 and definitionHash like "-5ecc211c13cec065600706929725b2b8"] executed by user [sesystem] 2012-01-08 17:29:24.937 (2) [P1T2]: SQL Error: Duplicate entry '5894935392--484d3bf959c59d54610f8b25330785be' for key 'theKey' (code:1062) 2012-01-08 17:29:24.938 (2) [P1T2]: Definition found in db: true for hash: -5ecc211c13cec065600706929725b2b8 and account: 5894935392 2012-01-08 17:29:26.518 (2) [DownloaderT1]: Downloading report : Ad Performance Report 2012-01-08 17:29:26.519 (3) [DownloaderT1]: Scheduling report attempt 1: ReportID=67134139 2012-01-08 17:29:35.481 (2) [DownloaderT1]: OK 2012-01-08 17:29:38.621 (2) [DownloaderT1]: Report : Ad Performance Report downloaded. 2012-01-08 17:29:39.222 (2) [DownloaderT1]: Report : Ad Performance Report is valid : true 2012-01-08 17:29:39.318 (2) [P1T2]: Downloaded and validated Ad Performance Report 971908 bytes. 2012-01-08 17:29:39.319 (2) [P1T2]: Parsing report as primary report: Ad Performance Report with 1549092064 bytes free 2012-01-08 17:29:39.320 (3) [P1T2]: parsing columns for Ad Performance Report 2012-01-08 17:29:39.957 (3) [P1T2]: parsing rows for Ad Performance Report 2012-01-08 17:29:40.478 (3) [P1T3]: Adgroup-level bidType changes: 0 2012-01-08 17:29:40.478 (3) [P1T3]: Adgroup-level bidAmount changes: 0 2012-01-08 17:29:40.478 (3) [P1T3]: COMPLETED ADGROUP-LEVEL BID DETECTION FOR: seUser (1554) and seAccount(521) 2012-01-08 17:29:40.478 (3) [P1T3]: -- Bid amount difference checks complete for seuser ((1554) "#004BT - Builders") and seAccount(521) 2012-01-08 17:29:40.478 (3) [P1T3]: -- Out of sync seaccts found for se user: (1554) "#004BT - Builders" : [47130, 47131] 2012-01-08 17:29:41.680 (3) [P1T3]: -- Keyword/Creative difference checks complete for seuser ((1554) "#004BT - Builders") 2012-01-08 17:29:41.680 (3) [P1T3]: SE Acct Id Set size :: 3 2012-01-08 17:29:43.105 (2) [P1T2]: Finished parsing report: Ad Performance Report 2012-01-08 17:29:45.329 (2) [P1T2]: Created temp file: /var/local/tsa/google_sync_files/tsa-creative-structure-report--1503-2012-01-08 17:17:0919740.tmp 2012-01-08 17:29:45.330 (3) [P1T2]: -- Data staging complete for seuser ((1503) "#001BT - Accountants") 2012-01-08 17:29:45.345 (3) [P1T2]: Loading data infile into temp table... 2012-01-08 17:29:45.356 (2) [P1T2]: Trying to load : /var/local/tsa/google_sync_files/tsa-keyword-structure-report--1503-2012-01-08 17:17:0919739.tmp into `tmp`.`tmp20` 2012-01-08 17:30:24.909 (3) [main]: ThreadPool finished 4/6 tasks, 2 active tasks, 2 active threads. 2 tasks remaining. 2012-01-08 17:31:24.920 (3) [main]: ThreadPool finished 4/6 tasks, 2 active tasks, 2 active threads. 2 tasks remaining. 2012-01-08 17:32:24.934 (3) [main]: ThreadPool finished 4/6 tasks, 2 active tasks, 2 active threads. 2 tasks remaining. 2012-01-08 17:32:35.728 (3) [P1T1]: Keyword-level bidType changes: 0 2012-01-08 17:32:35.728 (3) [P1T1]: Keyword-level bidAmount changes: 0 2012-01-08 17:32:35.729 (3) [P1T1]: COMPLETED KEYWORD-LEVEL BID DETECTION FOR: seUser (1500) and seAccount(521) 2012-01-08 17:33:22.134 (2) [P1T2]: Trying to load : /var/local/tsa/google_sync_files/tsa-creative-structure-report--1503-2012-01-08 17:17:0919740.tmp into `tmp`.`tmp22` 2012-01-08 17:33:24.948 (3) [main]: ThreadPool finished 4/6 tasks, 2 active tasks, 2 active threads. 2 tasks remaining. 2012-01-08 17:33:25.085 (3) [P1T2]: LOAD TEMP SYNC TABLES COMPLETED 2012-01-08 17:34:16.092 (3) [P1T2]: Campaigns with new items:([]) 2012-01-08 17:34:16.093 (3) [P1T2]: DETECTION OF NEW CAMPAIGN ITEMS COMPLETED 2012-01-08 17:34:24.961 (3) [main]: ThreadPool finished 4/6 tasks, 2 active tasks, 2 active threads. 2 tasks remaining. 2012-01-08 17:34:52.933 (3) [P1T2]: Campaigns with deleted items:([]) 2012-01-08 17:34:52.934 (3) [P1T2]: DETECTION OF DELETED CAMPAIGN ITEMS COMPLETED 2012-01-08 17:35:24.977 (3) [main]: ThreadPool finished 4/6 tasks, 2 active tasks, 2 active threads. 2 tasks remaining. 2012-01-08 17:36:22.134 (3) [P1T2]: Campaigns with updated items:([]) 2012-01-08 17:36:22.134 (3) [P1T2]: DETECTION OF UPDATED CAMPAIGN ITEMS COMPLETED 2012-01-08 17:36:24.993 (3) [main]: ThreadPool finished 4/6 tasks, 2 active tasks, 2 active threads. 2 tasks remaining. 2012-01-08 17:37:16.815 (3) [P1T2]: 2151494 keyword records removed before re-loading staging table. 2012-01-08 17:37:25.006 (3) [main]: ThreadPool finished 4/6 tasks, 2 active tasks, 2 active threads. 2 tasks remaining. 2012-01-08 17:38:25.018 (3) [main]: ThreadPool finished 4/6 tasks, 2 active tasks, 2 active threads. 2 tasks remaining. 2012-01-08 17:39:11.069 (3) [P1T2]: 2151494 keyword records loaded into staging table. 2012-01-08 17:39:11.775 (3) [P1T2]: 33415 creative ad records removed from staging table before re-loading. 2012-01-08 17:39:13.295 (3) [P1T2]: 33415 creative ad records loaded into staging table. 2012-01-08 17:39:13.295 (3) [P1T2]: UPDATE OF STAGING TABLES COMPLETED 2012-01-08 17:39:13.296 (3) [P1T2]: Passing seUserAcctId: 485 and seAcctAcctId: 521 2012-01-08 17:39:13.381 (3) [P1T2]: Replicating 32286 rows... 2012-01-08 17:39:25.031 (3) [main]: ThreadPool finished 4/6 tasks, 2 active tasks, 2 active threads. 2 tasks remaining. 2012-01-08 17:39:30.540 (3) [P1T2]: Change Detected - Campaign(s) with no previous sync history:(SEUserID: 1503 | AcctID: 485) 2012-01-08 17:39:30.540 (3) [P1T2]: CampaignIDs:([47130, 47131]) 2012-01-08 17:39:30.540 (3) [P1T2]: DETECTION OF CAMPAIGNS NEEDING FIRST SYNC COMPLETED 2012-01-08 17:39:30.544 (3) [P1T2]: DETECTION OF CAMPAIGNS WITH CONTENT/NETWORK CHANGES COMPLETED 2012-01-08 17:39:30.544 (3) [P1T2]: -- Account-level operations complete for seuser ((1503) "#001BT - Accountants") and seAccount(521) 2012-01-08 17:40:25.043 (3) [main]: ThreadPool finished 4/6 tasks, 2 active tasks, 2 active threads. 2 tasks remaining. 2012-01-08 17:41:25.055 (3) [main]: ThreadPool finished 4/6 tasks, 2 active tasks, 2 active threads. 2 tasks remaining. 2012-01-08 17:42:25.067 (3) [main]: ThreadPool finished 4/6 tasks, 2 active tasks, 2 active threads. 2 tasks remaining. 2012-01-08 17:43:25.079 (3) [main]: ThreadPool finished 4/6 tasks, 2 active tasks, 2 active threads. 2 tasks remaining. 2012-01-08 17:44:25.090 (3) [main]: ThreadPool finished 4/6 tasks, 2 active tasks, 2 active threads. 2 tasks remaining. 2012-01-08 17:45:25.103 (3) [main]: ThreadPool finished 4/6 tasks, 2 active tasks, 2 active threads. 2 tasks remaining. 2012-01-08 17:46:25.114 (3) [main]: ThreadPool finished 4/6 tasks, 2 active tasks, 2 active threads. 2 tasks remaining. 2012-01-08 17:47:25.128 (3) [main]: ThreadPool finished 4/6 tasks, 2 active tasks, 2 active threads. 2 tasks remaining. 2012-01-08 17:48:25.138 (3) [main]: ThreadPool finished 4/6 tasks, 2 active tasks, 2 active threads. 2 tasks remaining. 2012-01-08 17:49:25.150 (3) [main]: ThreadPool finished 4/6 tasks, 2 active tasks, 2 active threads. 2 tasks remaining. 2012-01-08 17:50:25.162 (3) [main]: ThreadPool finished 4/6 tasks, 2 active tasks, 2 active threads. 2 tasks remaining. 2012-01-08 17:51:25.174 (3) [main]: ThreadPool finished 4/6 tasks, 2 active tasks, 2 active threads. 2 tasks remaining. 2012-01-08 17:52:25.187 (3) [main]: ThreadPool finished 4/6 tasks, 2 active tasks, 2 active threads. 2 tasks remaining. 2012-01-08 17:53:25.198 (3) [main]: ThreadPool finished 4/6 tasks, 2 active tasks, 2 active threads. 2 tasks remaining. 2012-01-08 17:54:25.213 (3) [main]: ThreadPool finished 4/6 tasks, 2 active tasks, 2 active threads. 2 tasks remaining. 2012-01-08 17:55:25.226 (3) [main]: ThreadPool finished 4/6 tasks, 2 active tasks, 2 active threads. 2 tasks remaining. 2012-01-08 17:56:25.241 (3) [main]: ThreadPool finished 4/6 tasks, 2 active tasks, 2 active threads. 2 tasks remaining. 2012-01-08 17:57:25.253 (3) [main]: ThreadPool finished 4/6 tasks, 2 active tasks, 2 active threads. 2 tasks remaining. 2012-01-08 17:58:25.264 (3) [main]: ThreadPool finished 4/6 tasks, 2 active tasks, 2 active threads. 2 tasks remaining. 2012-01-08 17:59:25.288 (3) [main]: ThreadPool finished 4/6 tasks, 2 active tasks, 2 active threads. 2 tasks remaining. 2012-01-08 18:00:25.299 (3) [main]: ThreadPool finished 4/6 tasks, 2 active tasks, 2 active threads. 2 tasks remaining. 2012-01-08 18:01:25.310 (3) [main]: ThreadPool finished 4/6 tasks, 2 active tasks, 2 active threads. 2 tasks remaining. 2012-01-08 18:02:25.324 (3) [main]: ThreadPool finished 4/6 tasks, 2 active tasks, 2 active threads. 2 tasks remaining. 2012-01-08 18:03:25.334 (3) [main]: ThreadPool finished 4/6 tasks, 2 active tasks, 2 active threads. 2 tasks remaining. 2012-01-08 18:04:25.349 (3) [main]: ThreadPool finished 4/6 tasks, 2 active tasks, 2 active threads. 2 tasks remaining. 2012-01-08 18:05:26.670 (3) [main]: ThreadPool finished 4/6 tasks, 2 active tasks, 2 active threads. 2 tasks remaining. 2012-01-08 18:06:09.055 (3) [P1T2]: Keyword-level bidType changes: 0 2012-01-08 18:06:09.055 (3) [P1T2]: Keyword-level bidAmount changes: 374 2012-01-08 18:06:09.055 (3) [P1T2]: COMPLETED KEYWORD-LEVEL BID DETECTION FOR: seUser (1503) and seAccount(521) 2012-01-08 18:06:26.683 (3) [main]: ThreadPool finished 4/6 tasks, 2 active tasks, 2 active threads. 2 tasks remaining. 2012-01-08 18:06:42.473 (3) [P1T1]: Adgroup-level bidType changes: 0 2012-01-08 18:06:42.473 (3) [P1T1]: Adgroup-level bidAmount changes: 0 2012-01-08 18:06:42.473 (3) [P1T1]: COMPLETED ADGROUP-LEVEL BID DETECTION FOR: seUser (1500) and seAccount(521) 2012-01-08 18:06:42.473 (3) [P1T1]: -- Bid amount difference checks complete for seuser ((1500) "#003BT - Solicitors") and seAccount(521) 2012-01-08 18:06:42.474 (3) [P1T1]: -- Out of sync seaccts found for se user: (1500) "#003BT - Solicitors" : [47130, 47131] 2012-01-08 18:06:43.689 (3) [P1T1]: -- Keyword/Creative difference checks complete for seuser ((1500) "#003BT - Solicitors") 2012-01-08 18:06:43.689 (3) [P1T1]: SE Acct Id Set size :: 3 2012-01-08 18:07:26.696 (3) [main]: ThreadPool finished 5/6 tasks, 1 active tasks, 1 active threads. 1 tasks remaining. 2012-01-08 18:08:26.707 (3) [main]: ThreadPool finished 5/6 tasks, 1 active tasks, 1 active threads. 1 tasks remaining. 2012-01-08 18:09:26.719 (3) [main]: ThreadPool finished 5/6 tasks, 1 active tasks, 1 active threads. 1 tasks remaining. 2012-01-08 18:10:26.734 (3) [main]: ThreadPool finished 5/6 tasks, 1 active tasks, 1 active threads. 1 tasks remaining. 2012-01-08 18:11:26.751 (3) [main]: ThreadPool finished 5/6 tasks, 1 active tasks, 1 active threads. 1 tasks remaining. 2012-01-08 18:12:26.786 (3) [main]: ThreadPool finished 5/6 tasks, 1 active tasks, 1 active threads. 1 tasks remaining. 2012-01-08 18:13:26.824 (3) [main]: ThreadPool finished 5/6 tasks, 1 active tasks, 1 active threads. 1 tasks remaining. 2012-01-08 18:14:26.839 (3) [main]: ThreadPool finished 5/6 tasks, 1 active tasks, 1 active threads. 1 tasks remaining. 2012-01-08 18:15:26.852 (3) [main]: ThreadPool finished 5/6 tasks, 1 active tasks, 1 active threads. 1 tasks remaining. 2012-01-08 18:16:26.862 (3) [main]: ThreadPool finished 5/6 tasks, 1 active tasks, 1 active threads. 1 tasks remaining. 2012-01-08 18:17:26.878 (3) [main]: ThreadPool finished 5/6 tasks, 1 active tasks, 1 active threads. 1 tasks remaining. 2012-01-08 18:18:26.890 (3) [main]: ThreadPool finished 5/6 tasks, 1 active tasks, 1 active threads. 1 tasks remaining. 2012-01-08 18:19:26.902 (3) [main]: ThreadPool finished 5/6 tasks, 1 active tasks, 1 active threads. 1 tasks remaining. 2012-01-08 18:20:27.340 (3) [main]: ThreadPool finished 5/6 tasks, 1 active tasks, 1 active threads. 1 tasks remaining. 2012-01-08 18:21:27.350 (3) [main]: ThreadPool finished 5/6 tasks, 1 active tasks, 1 active threads. 1 tasks remaining. 2012-01-08 18:22:27.365 (3) [main]: ThreadPool finished 5/6 tasks, 1 active tasks, 1 active threads. 1 tasks remaining. 2012-01-08 18:23:27.379 (3) [main]: ThreadPool finished 5/6 tasks, 1 active tasks, 1 active threads. 1 tasks remaining. 2012-01-08 18:24:27.393 (3) [main]: ThreadPool finished 5/6 tasks, 1 active tasks, 1 active threads. 1 tasks remaining. 2012-01-08 18:25:27.425 (3) [main]: ThreadPool finished 5/6 tasks, 1 active tasks, 1 active threads. 1 tasks remaining. 2012-01-08 18:26:27.437 (3) [main]: ThreadPool finished 5/6 tasks, 1 active tasks, 1 active threads. 1 tasks remaining. 2012-01-08 18:27:27.447 (3) [main]: ThreadPool finished 5/6 tasks, 1 active tasks, 1 active threads. 1 tasks remaining. 2012-01-08 18:28:27.461 (3) [main]: ThreadPool finished 5/6 tasks, 1 active tasks, 1 active threads. 1 tasks remaining. 2012-01-08 18:29:27.470 (3) [main]: ThreadPool finished 5/6 tasks, 1 active tasks, 1 active threads. 1 tasks remaining. 2012-01-08 18:30:27.483 (3) [main]: ThreadPool finished 5/6 tasks, 1 active tasks, 1 active threads. 1 tasks remaining. 2012-01-08 18:31:27.498 (3) [main]: ThreadPool finished 5/6 tasks, 1 active tasks, 1 active threads. 1 tasks remaining. 2012-01-08 18:32:27.510 (3) [main]: ThreadPool finished 5/6 tasks, 1 active tasks, 1 active threads. 1 tasks remaining. 2012-01-08 18:33:27.522 (3) [main]: ThreadPool finished 5/6 tasks, 1 active tasks, 1 active threads. 1 tasks remaining. 2012-01-08 18:34:01.170 (3) [P1T2]: Adgroup-level bidType changes: 0 2012-01-08 18:34:01.170 (3) [P1T2]: Adgroup-level bidAmount changes: 0 2012-01-08 18:34:01.170 (3) [P1T2]: COMPLETED ADGROUP-LEVEL BID DETECTION FOR: seUser (1503) and seAccount(521) 2012-01-08 18:34:01.171 (3) [P1T2]: Owning Account IDs: ("38757","38763","38748","38765") 2012-01-08 18:34:01.172 (3) [P1T2]: -- Bid amount difference checks complete for seuser ((1503) "#001BT - Accountants") and seAccount(521) 2012-01-08 18:34:01.172 (3) [P1T2]: -- Out of sync seaccts found for se user: (1503) "#001BT - Accountants" : [38757, 38763, 47130, 38748, 47131, 38765] 2012-01-08 18:34:02.235 (3) [P1T2]: -- Keyword/Creative difference checks complete for seuser ((1503) "#001BT - Accountants") 2012-01-08 18:34:02.235 (3) [P1T2]: SE Acct Id Set size :: 7 2012-01-08 18:34:07.532 (3) [main]: ------------SearchEngineSyncUserWorker done 2012-01-08 18:34:07.533 (3) [main]: detected search engine accounts with differences ("38757","38763","37263","47130","38748","38765","47131")... 2012-01-08 18:34:07.533 (3) [main]: proceeding with listings sync... 2012-01-08 18:34:07.569 (3) [main]: After joining threads, calling doPostJoinActions 2012-01-08 18:34:07.569 (3) [main]: =============== Completed Search Engine Updater ================ 2012-01-08 18:34:07.578 (3) [main]: Search Engine Updater: 2h 59m 5.296s 2012-01-08 18:34:07.578 (3) [main]: by key: 2012-01-08 18:34:07.579 (3) [main]: parsing: 1h 2m 54.017s 2012-01-08 18:34:07.579 (3) [main]: by thread: 2012-01-08 18:34:07.579 (3) [main]: P1T2: 49m 59.926s 2012-01-08 18:34:07.579 (3) [main]: P1T3: 6m 25.761s 2012-01-08 18:34:07.580 (3) [main]: P1T1: 6m 28.330s 2012-01-08 18:34:07.580 (3) [main]: google: 14m 22.097s 2012-01-08 18:34:07.580 (3) [main]: by thread: 2012-01-08 18:34:07.580 (3) [main]: P1T2: 8m 44.055s 2012-01-08 18:34:07.580 (3) [main]: P1T3: 2m 38.760s 2012-01-08 18:34:07.581 (3) [main]: P1T1: 2m 59.282s 2012-01-08 18:34:07.581 (3) [main]: db: 5h 25m 49.697s 2012-01-08 18:34:07.581 (3) [main]: by thread: 2012-01-08 18:34:07.581 (3) [main]: P1T2: 1h 57m 25.542s 2012-01-08 18:34:07.581 (3) [main]: main: 0.092s 2012-01-08 18:34:07.582 (3) [main]: P1T3: 1h 36m 25.316s 2012-01-08 18:34:07.582 (3) [main]: P1T1: 1h 51m 58.747s 2012-01-08 18:34:07.582 (3) [main]: other: -13,440.515s