nohup: appending output to `nohup.out'
2012-12-04 10:24:31.501 (3) [main]: Debug Level set to 5
2012-12-04 10:24:32.116 (3) [main]: Listings flag set, implying groups flag as well.
2012-12-04 10:24:32.119 (4) [main]: no account, or instance for databaseInstance, skipping lookup...
2012-12-04 10:24:32.124 (3) [main]: DatabasePool with a limit of 80 created
2012-12-04 10:24:32.371 (4) [ConnectionCloser]: Starting DatabasePool ConnectionCloserThread
2012-12-04 10:24:37.477 (4) [main]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false]
2012-12-04 10:24:37.482 (4) [main]: Created new Object
2012-12-04 10:24:37.524 (5) [main]: ProfilerRec.start("db",true) in Thread [main]
2012-12-04 10:24:37.541 (4) [main]: spike: SQL->[select @@version]
2012-12-04 10:24:37.671 (5) [main]: recordAsSubs("db", 143, "main")
2012-12-04 10:24:37.672 (5) [main]: ProfilerRec.end("db", true): ret=143
2012-12-04 10:24:37.674 (4) [main]: time=0.143
2012-12-04 10:24:37.680 (4) [main]: Query executed in 0.143s
2012-12-04 10:24:37.681 (4) [main]: test query succeeded, returned "5.1.49-rel11.3-log"
2012-12-04 10:24:37.718 (5) [main]: ProfilerRec.start("db",true) in Thread [main]
2012-12-04 10:24:37.725 (4) [main]: spike: SQL->[select distinct searchEngineUserID from `tsacommon`.`searchEngineAccounts` where ((`accountID` in ("898")) and (`distributionID` in ("3")))]
2012-12-04 10:24:37.735 (5) [main]: recordAsSubs("db", 8, "main")
2012-12-04 10:24:37.735 (5) [main]: ProfilerRec.end("db", true): ret=8
2012-12-04 10:24:37.737 (4) [main]: time=0.0080
2012-12-04 10:24:37.739 (4) [main]: Query executed in 0.008s
2012-12-04 10:24:37.744 (3) [main]: getSEUserIDs distID=3, seUserID=null, accounts=(898) returned 3177
2012-12-04 10:24:37.764 (5) [main]: ProfilerRec.start("Search Engine Updater",false) in Thread [main]
2012-12-04 10:24:37.765 (3) [main]: =============== Starting Search Engine Updater ================
2012-12-04 10:24:37.769 (3) [main]: No licensing config file found, assuming TSA production environment
2012-12-04 10:24:37.770 (3) [main]: ----------------SearchEngineSyncUserWorker starting
2012-12-04 10:24:37.770 (4) [main]: no account, or instance for databaseInstance, skipping lookup...
2012-12-04 10:24:39.448 (4) [main]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false]
2012-12-04 10:24:41.103 (5) [main]: ProfilerRec.start("db",true) in Thread [main]
2012-12-04 10:24:41.103 (4) [main]: spike: SQL->[select * from `searchEngineUsers` join `accounts` on ((`tsacommon`.`accounts`.`id`=`tsacommon`.`searchEngineUsers`.`accountID`)) where ((`enabled`="true") and (`tsacommon`.`accounts`.`isActive`="true") and (`tsacommon`.`searchEngineUsers`.`id` in ("3177")) and (`tsacommon`.`searchEngineUsers`.`distributionID`="3")) order by `tsacommon`.`accounts`.`tier` asc,`tsacommon`.`accounts`.`priority` asc,`tsacommon`.`accounts`.`id` desc]
2012-12-04 10:24:41.106 (5) [main]: recordAsSubs("db", 3, "main")
2012-12-04 10:24:41.107 (5) [main]: addSub("db")
2012-12-04 10:24:41.107 (5) [main]: ProfilerRec.end("db", true): ret=3
2012-12-04 10:24:41.107 (4) [main]: time=0.0030
2012-12-04 10:24:41.108 (4) [main]: Query executed in 0.003s
2012-12-04 10:24:41.115 (5) [main]: loading 35 columns from result set:
2012-12-04 10:24:41.117 (5) [main]: 	loaded column: searchEngineUsers.id->3177
2012-12-04 10:24:41.117 (5) [main]: 	loaded column: searchEngineUsers.accountID->898
2012-12-04 10:24:41.117 (5) [main]: 	loaded column: searchEngineUsers.distributionID->3
2012-12-04 10:24:41.118 (5) [main]: 	loaded column: searchEngineUsers.searchEngineIdentifier->9001082081
2012-12-04 10:24:41.118 (5) [main]: 	loaded column: searchEngineUsers.description->AT&T Pan Asian Youth Campaign
2012-12-04 10:24:41.118 (5) [main]: 	loaded column: searchEngineUsers.username->
2012-12-04 10:24:41.118 (5) [main]: 	loaded column: searchEngineUsers.password->
2012-12-04 10:24:41.119 (5) [main]: 	loaded column: searchEngineUsers.enabled->true
2012-12-04 10:24:41.119 (5) [main]: 	loaded column: searchEngineUsers.inTsaMcc->true
2012-12-04 10:24:41.119 (5) [main]: 	loaded column: searchEngineUsers.apiKey->
2012-12-04 10:24:41.120 (5) [main]: 	loaded column: searchEngineUsers.managerUsernames->null
2012-12-04 10:24:41.120 (5) [main]: 	loaded column: searchEngineUsers.managerIDs->1752475908,9136835500,9050076625
2012-12-04 10:24:41.137 (5) [main]: 	loaded column: searchEngineUsers.lastChecked->2012-12-04 09:52:27.0
2012-12-04 10:24:41.138 (5) [main]: 	loaded column: searchEngineUsers.lastInMcc->2012-12-04 08:20:17.0
2012-12-04 10:24:41.138 (5) [main]: 	skipping invalid column: searchEngineUsers.hidden
2012-12-04 10:24:41.138 (5) [main]: 	skipping invalid column: accounts.id
2012-12-04 10:24:41.138 (5) [main]: 	skipping invalid column: accounts.description
2012-12-04 10:24:41.138 (5) [main]: 	skipping invalid column: accounts.tier
2012-12-04 10:24:41.139 (5) [main]: 	skipping invalid column: accounts.priority
2012-12-04 10:24:41.139 (5) [main]: 	skipping invalid column: accounts.reportClicksOut
2012-12-04 10:24:41.139 (5) [main]: 	skipping invalid column: accounts.reportConversions
2012-12-04 10:24:41.139 (5) [main]: 	skipping invalid column: accounts.conversionTypes
2012-12-04 10:24:41.139 (5) [main]: 	skipping invalid column: accounts.isBidManaged
2012-12-04 10:24:41.139 (5) [main]: 	skipping invalid column: accounts.isActive
2012-12-04 10:24:41.140 (5) [main]: 	skipping invalid column: accounts.perfMetric
2012-12-04 10:24:41.140 (5) [main]: 	skipping invalid column: accounts.providesConversionData
2012-12-04 10:24:41.140 (5) [main]: 	skipping invalid column: accounts.addConversionData
2012-12-04 10:24:41.140 (5) [main]: 	skipping invalid column: accounts.fractionalConversionCounts
2012-12-04 10:24:41.140 (5) [main]: 	skipping invalid column: accounts.hideNullSources
2012-12-04 10:24:41.140 (5) [main]: 	skipping invalid column: accounts.nowTime
2012-12-04 10:24:41.141 (5) [main]: 	skipping invalid column: accounts.warehouseDatabase
2012-12-04 10:24:41.141 (5) [main]: 	skipping invalid column: accounts.databaseInstance
2012-12-04 10:24:41.141 (5) [main]: 	skipping invalid column: accounts.warehouseInstance
2012-12-04 10:24:41.141 (5) [main]: 	skipping invalid column: accounts.isOnline
2012-12-04 10:24:41.141 (5) [main]: 	skipping invalid column: accounts.timeZoneID
2012-12-04 10:24:41.148 (3) [main]: Service URL: http://svc-useracctv2.svc.thesearchagency.com:8080/svc-useracctv2.0/UserAccountService2.0?wsdl
Dec 4, 2012 10:24:43 AM org.apache.cxf.bus.spring.BusApplicationContext getConfigResources
INFO: No cxf.xml configuration file detected, relying on defaults.
Dec 4, 2012 10:24:55 AM 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-12-04 10:25:03.759 (4) [ConnectionCloser]: 1 DatabasePools remaining : 0 pending closure
2012-12-04 10:25:04.057 (3) [main]: Got UserAccountServiceEndPoint object.
2012-12-04 10:25:06.491 (3) [main]: Instantiating a DateUtil object for time zone America/Denver
2012-12-04 10:25:06.495 (4) [main]: no account, or instance for databaseInstance, skipping lookup...
2012-12-04 10:25:06.712 (4) [main]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false]
2012-12-04 10:25:06.712 (4) [main]: Created new Object
2012-12-04 10:25:06.712 (5) [main]: ProfilerRec.start("db",true) in Thread [main]
2012-12-04 10:25:06.713 (4) [main]: spike: SQL->[select @@version]
2012-12-04 10:25:06.752 (5) [main]: recordAsSubs("db", 39, "main")
2012-12-04 10:25:06.753 (5) [main]: addSub("db")
2012-12-04 10:25:06.753 (5) [main]: ProfilerRec.end("db", true): ret=39
2012-12-04 10:25:06.753 (4) [main]: time=0.039
2012-12-04 10:25:06.754 (4) [main]: Query executed in 0.039s
2012-12-04 10:25:06.754 (4) [main]: test query succeeded, returned "5.1.49-rel11.3-log"
2012-12-04 10:25:06.758 (5) [main]: quoteValue(), nothing special about it=>[3], type=class java.lang.Integer
2012-12-04 10:25:06.759 (5) [main]: ProfilerRec.start("db",true) in Thread [main]
2012-12-04 10:25:06.759 (4) [main]: spike: SQL->[select * from `tsacommon`.`distribution` where (`id`=3) limit 1]
2012-12-04 10:25:06.796 (5) [main]: recordAsSubs("db", 37, "main")
2012-12-04 10:25:06.797 (5) [main]: addSub("db")
2012-12-04 10:25:06.797 (5) [main]: ProfilerRec.end("db", true): ret=37
2012-12-04 10:25:06.797 (4) [main]: time=0.037
2012-12-04 10:25:06.797 (4) [main]: Query executed in 0.037s
2012-12-04 10:25:06.797 (5) [main]: loading 19 columns from result set:
2012-12-04 10:25:06.798 (5) [main]: 	loaded column: distribution.id->3
2012-12-04 10:25:06.798 (5) [main]: 	loaded column: distribution.accountID->0
2012-12-04 10:25:06.798 (5) [main]: 	loaded column: distribution.siteID->0
2012-12-04 10:25:06.799 (5) [main]: 	loaded column: distribution.type->paid search
2012-12-04 10:25:06.799 (5) [main]: 	loaded column: distribution.channelID->1
2012-12-04 10:25:06.799 (5) [main]: 	loaded column: distribution.showStats->1
2012-12-04 10:25:06.799 (5) [main]: 	loaded column: distribution.bidMatchTypes->exact,phrase,broad,content
2012-12-04 10:25:06.800 (5) [main]: 	loaded column: distribution.trackMatchTypes->exact,phrase,broad,content
2012-12-04 10:25:06.800 (5) [main]: 	loaded column: distribution.mergeMatchTypeStats->false
2012-12-04 10:25:06.800 (5) [main]: 	loaded column: distribution.rollupMatchTypes->content
2012-12-04 10:25:06.800 (5) [main]: 	loaded column: distribution.positionalBidding->false
2012-12-04 10:25:06.801 (5) [main]: 	loaded column: distribution.description->Google AdWords
2012-12-04 10:25:06.801 (5) [main]: 	loaded column: distribution.shortCode->GO
2012-12-04 10:25:06.801 (5) [main]: 	loaded column: distribution.searchEngineClass->com.thesearchagency.searchengines.google.GoogleAPISearchEngine
2012-12-04 10:25:06.801 (5) [main]: 	loaded column: distribution.bidMinCPC->0.01
2012-12-04 10:25:06.806 (5) [main]: 	loaded column: distribution.bidCapCPC->100.0
2012-12-04 10:25:06.807 (5) [main]: 	loaded column: distribution.bidMinCPM->0.25
2012-12-04 10:25:06.807 (5) [main]: 	loaded column: distribution.bidCapCPM->500.0
2012-12-04 10:25:06.807 (5) [main]: 	skipping invalid column: distribution.obsolete
2012-12-04 10:25:06.807 (4) [main]:   Record Loaded
2012-12-04 10:25:06.807 (5) [main]: class name is "com.thesearchagency.searchengines.google.GoogleAPISearchEngine"
2012-12-04 10:25:06.892 (4) [main]: User  in TSA MCC, connecting using master username/password
2012-12-04 10:25:06.894 (4) [main]: client customer id = 9001082081
2012-12-04 10:25:06.897 (5) [main]: parseInteger->[3177]
2012-12-04 10:25:06.897 (5) [main]: parseInteger<-[3177]
2012-12-04 10:25:07.080 (4) [main]: no account, or instance for databaseInstance, skipping lookup...
2012-12-04 10:25:07.114 (4) [main]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false]
2012-12-04 10:25:07.205 (5) [main]: ProfilerRec.start("db",true) in Thread [main]
2012-12-04 10:25:07.206 (4) [main]: spike: SQL->[select `id`,`shortCode` from distribution where ((`searchEngineClass` is not null) and (`searchEngineClass`!=""))]
2012-12-04 10:25:07.228 (5) [main]: recordAsSubs("db", 22, "main")
2012-12-04 10:25:07.229 (5) [main]: addSub("db")
2012-12-04 10:25:07.229 (5) [main]: ProfilerRec.end("db", true): ret=22
2012-12-04 10:25:07.229 (4) [main]: time=0.022
2012-12-04 10:25:07.230 (4) [main]: Query executed in 0.022s
2012-12-04 10:25:07.234 (4) [main]: closed [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false]
2012-12-04 10:25:07.236 (4) [main]: no account, or instance for databaseInstance, skipping lookup...
2012-12-04 10:25:09.578 (4) [main]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false]
2012-12-04 10:25:09.593 (5) [main]: ProfilerRec.start("db",true) in Thread [main]
2012-12-04 10:25:09.594 (4) [main]: spike: SQL->[select * from `tsacommon`.`databaseInstances` where ((`type`="mysql") and (`name`="global-sesystem")) limit 1]
2012-12-04 10:25:09.642 (5) [main]: recordAsSubs("db", 48, "main")
2012-12-04 10:25:09.642 (5) [main]: addSub("db")
2012-12-04 10:25:09.642 (5) [main]: ProfilerRec.end("db", true): ret=48
2012-12-04 10:25:09.643 (4) [main]: time=0.048
2012-12-04 10:25:09.643 (4) [main]: Query executed in 0.048s
2012-12-04 10:25:09.643 (5) [main]: loading 8 columns from result set:
2012-12-04 10:25:09.644 (5) [main]: 	loaded column: databaseInstances.id->2
2012-12-04 10:25:09.644 (5) [main]: 	loaded column: databaseInstances.name->global-sesystem
2012-12-04 10:25:09.644 (5) [main]: 	loaded column: databaseInstances.description->Global Search Engine API system tables
2012-12-04 10:25:09.644 (5) [main]: 	loaded column: databaseInstances.type->mysql
2012-12-04 10:25:09.645 (5) [main]: 	loaded column: databaseInstances.database->sesystem
2012-12-04 10:25:09.645 (5) [main]: 	loaded column: databaseInstances.host->sesystem-01-write
2012-12-04 10:25:09.645 (5) [main]: 	loaded column: databaseInstances.port->3307
2012-12-04 10:25:09.645 (5) [main]: 	loaded column: databaseInstances.access->rw
2012-12-04 10:25:09.645 (4) [main]:   Record Loaded
2012-12-04 10:25:09.646 (4) [main]: DataCache: put key global-sesystem
2012-12-04 10:25:09.646 (4) [main]: closed [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false]
2012-12-04 10:25:10.786 (4) [main]: opened [jdbc:mysql://sesystem-01-write:3307/sesystem?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false]
2012-12-04 10:25:10.786 (3) [main]: Created shared sesystem connection rw
2012-12-04 10:25:10.789 (5) [main]: quoteValue(), nothing special about it=>[0], type=class java.lang.Integer
2012-12-04 10:25:10.793 (5) [main]: ProfilerRec.start("db",true) in Thread [main]
2012-12-04 10:25:10.793 (4) [main]: sesystem: SQL->[select `authToken`,`date` from `sesystem`.`googleAuthToken` where ((`seUserID`=0))]
2012-12-04 10:25:10.794 (5) [main]: recordAsSubs("db", 1, "main")
2012-12-04 10:25:10.794 (5) [main]: addSub("db")
2012-12-04 10:25:10.794 (5) [main]: ProfilerRec.end("db", true): ret=1
2012-12-04 10:25:10.795 (4) [main]: time=0.0010
2012-12-04 10:25:10.795 (4) [main]: Query executed in 0.001s
2012-12-04 10:25:10.796 (4) [main]: MasterAuthToken retrieved from database [DQAAAJUAAABblTkk4samFeeIPZeA4b44C3w9CSZUFxB_1PKkgTJgM5Lgsa8hTds5kjeMJGa6cExwQnnIDV7Ug-KEY3tqzcq509ufM18E690NozMrYI1_ThysElNbsxM95UmDsdGckBnxsx2_W0beOdRfookxPexOo_l8H3BAtqbFpIIwgTH98LxImDZ0EQfjCTiZ49NAuNh3TJ7XbYd-0CN-WJfEw85Z] for search engine user ID[0]
2012-12-04 10:25:10.798 (4) [main]: seuserid[3177] username[null] password[null] customerID[9001082081]
2012-12-04 10:25:10.875 (4) [main]: ClearConnections called at: Tue Dec 04 10:25:10 PST 2012	Timer: 0
2012-12-04 10:25:10.878 (5) [main]: quoteValue(), nothing special about it=>[3], type=class java.lang.Integer
2012-12-04 10:25:10.879 (5) [main]: ProfilerRec.start("db",true) in Thread [main]
2012-12-04 10:25:10.879 (4) [main]: sesystem: SQL->[update `sesystem`.`searchEngineConnections` set `inUse`="false",`holder`="",`timeStamp`="2012-12-04 10:25:10",`holderIdentifier`="" where ((`sesystem`.`searchEngineConnections`.`distributionID`=3) and (`sesystem`.`searchEngineConnections`.`inUse`="true") and (`sesystem`.`searchEngineConnections`.`timeStamp`<="2012-12-04 10:20:10")) limit 1], genflags=no
2012-12-04 10:25:10.881 (5) [main]: recordAsSubs("db", 2, "main")
2012-12-04 10:25:10.881 (5) [main]: addSub("db")
2012-12-04 10:25:10.881 (5) [main]: ProfilerRec.end("db", true): ret=2
2012-12-04 10:25:10.882 (4) [main]: time=0.0020
2012-12-04 10:25:10.882 (4) [main]: Query executed in 0.002s, 0 row(s) affected
2012-12-04 10:25:10.918 (4) [main]: Setting AuthToken [DQAAAJUAAABblTkk4samFeeIPZeA4b44C3w9CSZUFxB_1PKkgTJgM5Lgsa8hTds5kjeMJGa6cExwQnnIDV7Ug-KEY3tqzcq509ufM18E690NozMrYI1_ThysElNbsxM95UmDsdGckBnxsx2_W0beOdRfookxPexOo_l8H3BAtqbFpIIwgTH98LxImDZ0EQfjCTiZ49NAuNh3TJ7XbYd-0CN-WJfEw85Z] to AdWordsUser object for username[google@thesearchagency.com]
2012-12-04 10:25:14.713 (4) [main]: Returning Object to Pool
2012-12-04 10:25:14.718 (4) [P1T1]: no account, or instance for databaseInstance, skipping lookup...
2012-12-04 10:25:15.441 (4) [P1T1]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false]
2012-12-04 10:25:15.443 (5) [P1T1]: quoteValue(), nothing special about it=>[898], type=class java.lang.Integer
2012-12-04 10:25:15.443 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1]
2012-12-04 10:25:15.443 (4) [P1T1]: spike: SQL->[select * from `tsacommon`.`accounts` where (`id`=898) limit 1]
2012-12-04 10:25:15.445 (5) [P1T1]: recordAsSubs("db", 2, "P1T1")
2012-12-04 10:25:15.445 (5) [P1T1]: addSub("db")
2012-12-04 10:25:15.445 (5) [P1T1]: ProfilerRec.end("db", true): ret=2
2012-12-04 10:25:15.445 (4) [P1T1]: time=0.0020
2012-12-04 10:25:15.445 (4) [P1T1]: Query executed in 0.002s
2012-12-04 10:25:15.446 (5) [P1T1]: loading 20 columns from result set:
2012-12-04 10:25:15.446 (5) [P1T1]: 	loaded column: accounts.id->898
2012-12-04 10:25:15.446 (5) [P1T1]: 	loaded column: accounts.description->Rezonate - AT&T
2012-12-04 10:25:15.446 (5) [P1T1]: 	loaded column: accounts.tier->2
2012-12-04 10:25:15.447 (5) [P1T1]: 	loaded column: accounts.priority->50
2012-12-04 10:25:15.447 (5) [P1T1]: 	loaded column: accounts.reportClicksOut->false
2012-12-04 10:25:15.447 (5) [P1T1]: 	loaded column: accounts.reportConversions->false
2012-12-04 10:25:15.447 (5) [P1T1]: 	loaded column: accounts.conversionTypes->
2012-12-04 10:25:15.447 (5) [P1T1]: 	loaded column: accounts.isBidManaged->true
2012-12-04 10:25:15.447 (5) [P1T1]: 	loaded column: accounts.isActive->true
2012-12-04 10:25:15.448 (5) [P1T1]: 	loaded column: accounts.perfMetric->cpa
2012-12-04 10:25:15.448 (5) [P1T1]: 	loaded column: accounts.providesConversionData->false
2012-12-04 10:25:15.448 (5) [P1T1]: 	loaded column: accounts.addConversionData->false
2012-12-04 10:25:15.448 (5) [P1T1]: 	loaded column: accounts.fractionalConversionCounts->false
2012-12-04 10:25:15.448 (5) [P1T1]: 	loaded column: accounts.hideNullSources->false
2012-12-04 10:25:15.450 (5) [P1T1]: 	loaded column: accounts.nowTime->null
2012-12-04 10:25:15.450 (5) [P1T1]: 	loaded column: accounts.warehouseDatabase->warehouse_4
2012-12-04 10:25:15.450 (5) [P1T1]: 	loaded column: accounts.databaseInstance->5
2012-12-04 10:25:15.451 (5) [P1T1]: 	loaded column: accounts.warehouseInstance->7
2012-12-04 10:25:15.451 (5) [P1T1]: 	loaded column: accounts.isOnline->true
2012-12-04 10:25:15.451 (5) [P1T1]: 	loaded column: accounts.timeZoneID->2
2012-12-04 10:25:15.451 (4) [P1T1]:   Record Loaded
2012-12-04 10:25:15.451 (4) [P1T1]: DataCache: put key acct-sync-google 898
2012-12-04 10:25:15.452 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1]
2012-12-04 10:25:15.452 (4) [P1T1]: spike: SQL->[select * from `tsacommon`.`databaseInstances` where ((`type`="mysql") and (`name`="acct-sync-google-5")) limit 1]
2012-12-04 10:25:15.495 (5) [P1T1]: recordAsSubs("db", 43, "P1T1")
2012-12-04 10:25:15.496 (5) [P1T1]: addSub("db")
2012-12-04 10:25:15.496 (5) [P1T1]: ProfilerRec.end("db", true): ret=43
2012-12-04 10:25:15.496 (4) [P1T1]: time=0.043
2012-12-04 10:25:15.496 (4) [P1T1]: Query executed in 0.043s
2012-12-04 10:25:15.496 (5) [P1T1]: loading 8 columns from result set:
2012-12-04 10:25:15.497 (5) [P1T1]: 	loaded column: databaseInstances.id->46
2012-12-04 10:25:15.497 (5) [P1T1]: 	loaded column: databaseInstances.name->acct-sync-google-5
2012-12-04 10:25:15.497 (5) [P1T1]: 	loaded column: databaseInstances.description->Account-specific Google sync tables (based on seUser accountID)
2012-12-04 10:25:15.499 (5) [P1T1]: 	loaded column: databaseInstances.type->mysql
2012-12-04 10:25:15.500 (5) [P1T1]: 	loaded column: databaseInstances.database->sync_google
2012-12-04 10:25:15.500 (5) [P1T1]: 	loaded column: databaseInstances.host->acctdb-05-write
2012-12-04 10:25:15.500 (5) [P1T1]: 	loaded column: databaseInstances.port->3309
2012-12-04 10:25:15.500 (5) [P1T1]: 	loaded column: databaseInstances.access->rw
2012-12-04 10:25:15.500 (4) [P1T1]:   Record Loaded
2012-12-04 10:25:15.500 (4) [P1T1]: DataCache: put key acct-sync-google-5
2012-12-04 10:25:15.501 (4) [P1T1]: closed [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false]
2012-12-04 10:25:15.501 (3) [P1T1]: DatabasePool with a limit of 80 created
2012-12-04 10:25:16.469 (4) [P1T1]: opened [jdbc:mysql://acctdb-05-write:3309/sync_google?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false]
2012-12-04 10:25:16.470 (4) [P1T1]: Created new Object
2012-12-04 10:25:16.470 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1]
2012-12-04 10:25:16.471 (4) [P1T1]: spike: SQL->[select @@version]
2012-12-04 10:25:16.546 (5) [P1T1]: recordAsSubs("db", 75, "P1T1")
2012-12-04 10:25:16.547 (5) [P1T1]: addSub("db")
2012-12-04 10:25:16.547 (5) [P1T1]: ProfilerRec.end("db", true): ret=75
2012-12-04 10:25:16.547 (4) [P1T1]: time=0.075
2012-12-04 10:25:16.548 (4) [P1T1]: Query executed in 0.075s
2012-12-04 10:25:16.548 (4) [P1T1]: test query succeeded, returned "5.1.61-rel13.2"
2012-12-04 10:25:16.548 (4) [P1T1]: no account, or instance for databaseInstance, skipping lookup...
2012-12-04 10:25:16.548 (4) [P1T1]: Took Existing Object from Pool
2012-12-04 10:25:16.549 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1]
2012-12-04 10:25:16.549 (4) [P1T1]: spike: SQL->[select @@version]
2012-12-04 10:25:16.626 (5) [P1T1]: recordAsSubs("db", 76, "P1T1")
2012-12-04 10:25:16.626 (5) [P1T1]: addSub("db")
2012-12-04 10:25:16.626 (5) [P1T1]: ProfilerRec.end("db", true): ret=76
2012-12-04 10:25:16.627 (4) [P1T1]: time=0.076
2012-12-04 10:25:16.627 (4) [P1T1]: Query executed in 0.076s
2012-12-04 10:25:16.627 (4) [P1T1]: test query succeeded, returned "5.1.49-rel11.3-log"
2012-12-04 10:25:16.628 (3) [P1T1]: -- Bulk downloads supported.
2012-12-04 10:25:16.628 (3) [P1T1]: -- Begining search engine sync for user: (3177) "AT&T Pan Asian Youth Campaign"
2012-12-04 10:25:16.657 (4) [P1T1]: no account, or instance for databaseInstance, skipping lookup...
2012-12-04 10:25:17.174 (4) [P1T1]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false]
2012-12-04 10:25:17.176 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1]
2012-12-04 10:25:17.176 (4) [P1T1]: spike: SQL->[select * from `tsacommon`.`databaseInstances` where ((`type`="mysql") and (`name`="global-logging")) limit 1]
2012-12-04 10:25:17.206 (5) [P1T1]: recordAsSubs("db", 30, "P1T1")
2012-12-04 10:25:17.207 (5) [P1T1]: addSub("db")
2012-12-04 10:25:17.207 (5) [P1T1]: ProfilerRec.end("db", true): ret=30
2012-12-04 10:25:17.208 (4) [P1T1]: time=0.03
2012-12-04 10:25:17.208 (4) [P1T1]: Query executed in 0.030s
2012-12-04 10:25:17.208 (5) [P1T1]: loading 8 columns from result set:
2012-12-04 10:25:17.208 (5) [P1T1]: 	loaded column: databaseInstances.id->4
2012-12-04 10:25:17.209 (5) [P1T1]: 	loaded column: databaseInstances.name->global-logging
2012-12-04 10:25:17.209 (5) [P1T1]: 	loaded column: databaseInstances.description->Global Logging Tables
2012-12-04 10:25:17.209 (5) [P1T1]: 	loaded column: databaseInstances.type->mysql
2012-12-04 10:25:17.209 (5) [P1T1]: 	loaded column: databaseInstances.database->logging
2012-12-04 10:25:17.209 (5) [P1T1]: 	loaded column: databaseInstances.host->tsacommon-01-write
2012-12-04 10:25:17.209 (5) [P1T1]: 	loaded column: databaseInstances.port->3306
2012-12-04 10:25:17.210 (5) [P1T1]: 	loaded column: databaseInstances.access->rw
2012-12-04 10:25:17.210 (4) [P1T1]:   Record Loaded
2012-12-04 10:25:17.210 (4) [P1T1]: DataCache: put key global-logging
2012-12-04 10:25:17.210 (4) [P1T1]: closed [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false]
2012-12-04 10:25:17.210 (3) [P1T1]: DatabasePool with a limit of 80 created
2012-12-04 10:25:17.541 (4) [P1T1]: opened [jdbc:mysql://tsacommon-01-write:3306/logging?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false]
2012-12-04 10:25:17.542 (4) [P1T1]: Created new Object
2012-12-04 10:25:17.542 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1]
2012-12-04 10:25:17.542 (4) [P1T1]: spike: SQL->[select @@version]
2012-12-04 10:25:17.566 (5) [P1T1]: recordAsSubs("db", 24, "P1T1")
2012-12-04 10:25:17.566 (5) [P1T1]: addSub("db")
2012-12-04 10:25:17.566 (5) [P1T1]: ProfilerRec.end("db", true): ret=24
2012-12-04 10:25:17.567 (4) [P1T1]: time=0.024
2012-12-04 10:25:17.567 (4) [P1T1]: Query executed in 0.024s
2012-12-04 10:25:17.567 (4) [P1T1]: test query succeeded, returned "5.1.49-rel11.3-log"
2012-12-04 10:25:17.567 (4) [P1T1]: no account, or instance for databaseInstance, skipping lookup...
2012-12-04 10:25:25.157 (4) [P1T1]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false]
2012-12-04 10:25:25.158 (4) [P1T1]: Created new Object
2012-12-04 10:25:25.158 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1]
2012-12-04 10:25:25.158 (4) [P1T1]: spike: SQL->[select @@version]
2012-12-04 10:25:25.160 (5) [P1T1]: recordAsSubs("db", 2, "P1T1")
2012-12-04 10:25:25.161 (5) [P1T1]: addSub("db")
2012-12-04 10:25:25.161 (5) [P1T1]: ProfilerRec.end("db", true): ret=2
2012-12-04 10:25:25.161 (4) [P1T1]: time=0.0020
2012-12-04 10:25:25.161 (4) [P1T1]: Query executed in 0.002s
2012-12-04 10:25:25.162 (4) [P1T1]: test query succeeded, returned "5.1.49-rel11.3-log"
2012-12-04 10:25:25.162 (4) [P1T1]: no account, or instance for databaseInstance, skipping lookup...
2012-12-04 10:25:25.457 (4) [P1T1]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false]
2012-12-04 10:25:25.458 (5) [P1T1]: quoteValue(), nothing special about it=>[898], type=class java.lang.Integer
2012-12-04 10:25:25.459 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1]
2012-12-04 10:25:25.459 (4) [P1T1]: spike: SQL->[select * from `tsacommon`.`accounts` where (`id`=898) limit 1]
2012-12-04 10:25:25.460 (5) [P1T1]: recordAsSubs("db", 1, "P1T1")
2012-12-04 10:25:25.460 (5) [P1T1]: addSub("db")
2012-12-04 10:25:25.460 (5) [P1T1]: ProfilerRec.end("db", true): ret=1
2012-12-04 10:25:25.461 (4) [P1T1]: time=0.0010
2012-12-04 10:25:25.461 (4) [P1T1]: Query executed in 0.001s
2012-12-04 10:25:25.461 (5) [P1T1]: loading 20 columns from result set:
2012-12-04 10:25:25.461 (5) [P1T1]: 	loaded column: accounts.id->898
2012-12-04 10:25:25.462 (5) [P1T1]: 	loaded column: accounts.description->Rezonate - AT&T
2012-12-04 10:25:25.462 (5) [P1T1]: 	loaded column: accounts.tier->2
2012-12-04 10:25:25.462 (5) [P1T1]: 	loaded column: accounts.priority->50
2012-12-04 10:25:25.462 (5) [P1T1]: 	loaded column: accounts.reportClicksOut->false
2012-12-04 10:25:25.462 (5) [P1T1]: 	loaded column: accounts.reportConversions->false
2012-12-04 10:25:25.463 (5) [P1T1]: 	loaded column: accounts.conversionTypes->
2012-12-04 10:25:25.463 (5) [P1T1]: 	loaded column: accounts.isBidManaged->true
2012-12-04 10:25:25.463 (5) [P1T1]: 	loaded column: accounts.isActive->true
2012-12-04 10:25:25.463 (5) [P1T1]: 	loaded column: accounts.perfMetric->cpa
2012-12-04 10:25:25.463 (5) [P1T1]: 	loaded column: accounts.providesConversionData->false
2012-12-04 10:25:25.464 (5) [P1T1]: 	loaded column: accounts.addConversionData->false
2012-12-04 10:25:25.464 (5) [P1T1]: 	loaded column: accounts.fractionalConversionCounts->false
2012-12-04 10:25:25.627 (5) [P1T1]: 	loaded column: accounts.hideNullSources->false
2012-12-04 10:25:25.628 (5) [P1T1]: 	loaded column: accounts.nowTime->null
2012-12-04 10:25:25.628 (5) [P1T1]: 	loaded column: accounts.warehouseDatabase->warehouse_4
2012-12-04 10:25:25.628 (5) [P1T1]: 	loaded column: accounts.databaseInstance->5
2012-12-04 10:25:25.628 (5) [P1T1]: 	loaded column: accounts.warehouseInstance->7
2012-12-04 10:25:25.629 (5) [P1T1]: 	loaded column: accounts.isOnline->true
2012-12-04 10:25:25.629 (5) [P1T1]: 	loaded column: accounts.timeZoneID->2
2012-12-04 10:25:25.629 (4) [P1T1]:   Record Loaded
2012-12-04 10:25:25.629 (4) [P1T1]: DataCache: put key acct-st-tracker 898
2012-12-04 10:25:25.630 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1]
2012-12-04 10:25:25.630 (4) [P1T1]: spike: SQL->[select * from `tsacommon`.`databaseInstances` where ((`type`="mysql") and (`name`="acct-st-tracker-5")) limit 1]
2012-12-04 10:25:25.672 (5) [P1T1]: recordAsSubs("db", 42, "P1T1")
2012-12-04 10:25:25.673 (5) [P1T1]: addSub("db")
2012-12-04 10:25:25.673 (5) [P1T1]: ProfilerRec.end("db", true): ret=42
2012-12-04 10:25:25.673 (4) [P1T1]: time=0.042
2012-12-04 10:25:25.674 (4) [P1T1]: Query executed in 0.042s
2012-12-04 10:25:25.674 (5) [P1T1]: loading 8 columns from result set:
2012-12-04 10:25:25.674 (5) [P1T1]: 	loaded column: databaseInstances.id->36
2012-12-04 10:25:25.675 (5) [P1T1]: 	loaded column: databaseInstances.name->acct-st-tracker-5
2012-12-04 10:25:25.675 (5) [P1T1]: 	loaded column: databaseInstances.description->Account-specific Catch-all database 05
2012-12-04 10:25:25.675 (5) [P1T1]: 	loaded column: databaseInstances.type->mysql
2012-12-04 10:25:25.675 (5) [P1T1]: 	loaded column: databaseInstances.database->st-tracker
2012-12-04 10:25:25.675 (5) [P1T1]: 	loaded column: databaseInstances.host->acctdb-05-write
2012-12-04 10:25:25.676 (5) [P1T1]: 	loaded column: databaseInstances.port->3309
2012-12-04 10:25:25.676 (5) [P1T1]: 	loaded column: databaseInstances.access->rw
2012-12-04 10:25:25.676 (4) [P1T1]:   Record Loaded
2012-12-04 10:25:25.676 (4) [P1T1]: DataCache: put key acct-st-tracker-5
2012-12-04 10:25:25.676 (4) [P1T1]: closed [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false]
2012-12-04 10:25:25.677 (3) [P1T1]: DatabasePool with a limit of 80 created
2012-12-04 10:25:25.939 (4) [P1T1]: opened [jdbc:mysql://acctdb-05-write:3309/st-tracker?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false]
2012-12-04 10:25:25.940 (4) [P1T1]: Created new Object
2012-12-04 10:25:25.940 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1]
2012-12-04 10:25:25.940 (4) [P1T1]: spike: SQL->[select @@version]
2012-12-04 10:25:25.971 (5) [P1T1]: recordAsSubs("db", 31, "P1T1")
2012-12-04 10:25:25.972 (5) [P1T1]: addSub("db")
2012-12-04 10:25:25.972 (5) [P1T1]: ProfilerRec.end("db", true): ret=31
2012-12-04 10:25:25.972 (4) [P1T1]: time=0.031
2012-12-04 10:25:25.973 (4) [P1T1]: Query executed in 0.031s
2012-12-04 10:25:25.973 (4) [P1T1]: test query succeeded, returned "5.1.61-rel13.2"
2012-12-04 10:25:25.998 (2) [P1T1]: Created KeywordStructureSyncCriterion, db is googleKeywords
2012-12-04 10:25:25.999 (2) [P1T1]: Created CreativeStructureSyncCriterion
2012-12-04 10:25:25.999 (2) [P1T1]: googleKeywords
2012-12-04 10:25:26.379 (2) [P1T1]: Added Keyword Performance Report AdGroupId to secondaryKeys
2012-12-04 10:25:26.379 (2) [P1T1]: Added Adgroup Performance Report AdGroupId to secondaryKeys
2012-12-04 10:25:26.379 (2) [P1T1]: Added Criteria Performance Report AdGroupId to secondaryKeys
2012-12-04 10:25:26.380 (5) [P1T1]: ProfilerRec.start("google",true) in Thread [P1T1]
2012-12-04 10:25:26.382 (2) [P1T1]: Getting columns for : Criteria Performance Report
2012-12-04 10:25:26.382 (2) [P1T1]: Got : CampaignId
2012-12-04 10:25:26.383 (2) [P1T1]: Got : AdGroupId
2012-12-04 10:25:26.383 (2) [P1T1]: Got : Id
2012-12-04 10:25:26.383 (2) [P1T1]: Got : AdGroupStatus
2012-12-04 10:25:26.383 (2) [P1T1]: Got : MaxCpc
2012-12-04 10:25:26.383 (2) [P1T1]: Got : MaxCpm
2012-12-04 10:25:26.383 (2) [P1T1]: Got : CriteriaType
2012-12-04 10:25:26.384 (2) [P1T1]: Got : Status
2012-12-04 10:25:26.384 (2) [P1T1]: Got : CriteriaDestinationUrl
2012-12-04 10:25:26.384 (2) [P1T1]: Got : IsNegative
2012-12-04 10:25:26.384 (2) [P1T1]: Got : Criteria
2012-12-04 10:25:26.546 (2) [P1T1]: Getting columns for : Keyword Performance Report
2012-12-04 10:25:26.546 (2) [P1T1]: Got : CampaignId
2012-12-04 10:25:26.547 (2) [P1T1]: Got : AdGroupId
2012-12-04 10:25:26.547 (2) [P1T1]: Got : Id
2012-12-04 10:25:26.547 (2) [P1T1]: Got : AdGroupStatus
2012-12-04 10:25:26.547 (2) [P1T1]: Got : MaxCpc
2012-12-04 10:25:26.547 (2) [P1T1]: Got : MaxCpm
2012-12-04 10:25:26.548 (2) [P1T1]: Got : KeywordMatchType
2012-12-04 10:25:26.548 (2) [P1T1]: Got : Status
2012-12-04 10:25:26.548 (2) [P1T1]: Got : DestinationUrl
2012-12-04 10:25:26.548 (2) [P1T1]: Got : IsNegative
2012-12-04 10:25:26.548 (2) [P1T1]: Got : KeywordText
2012-12-04 10:25:26.573 (2) [P1T1]: Getting columns for : Adgroup Performance Report
2012-12-04 10:25:26.573 (2) [P1T1]: Got : AdGroupName
2012-12-04 10:25:26.573 (2) [P1T1]: Got : KeywordContentMaxCpc
2012-12-04 10:25:26.573 (2) [P1T1]: Got : ProxyKeywordMaxCpc
2012-12-04 10:25:26.573 (2) [P1T1]: Got : MaxCpm
2012-12-04 10:25:26.573 (2) [P1T1]: Got : KeywordMaxCpc
2012-12-04 10:25:26.574 (2) [P1T1]: Got : AdGroupId
2012-12-04 10:25:26.605 (2) [DownloaderT1]: Downloading report : Criteria Performance Report
2012-12-04 10:25:26.611 (3) [DownloaderT1]: Downloading report attempt 1: Customer Client ID: 9001082081
2012-12-04 10:25:26.644 (2) [DownloaderT2]: Downloading report : Keyword Performance Report
2012-12-04 10:25:26.645 (3) [DownloaderT2]: Downloading report attempt 1: Customer Client ID: 9001082081
2012-12-04 10:25:26.650 (2) [DownloaderT3]: Downloading report : Adgroup Performance Report
2012-12-04 10:25:26.650 (3) [DownloaderT3]: Downloading report attempt 1: Customer Client ID: 9001082081
2012-12-04 10:25:33.580 (4) [DownloaderT2]: XML-><reportDefinition><selector><fields>CampaignId</fields><fields>AdGroupId</fields><fields>Id</fields><fields>AdGroupStatus</fields><fields>MaxCpc</fields><fields>MaxCpm</fields><fields>KeywordMatchType</fields><fields>Status</fields><fields>DestinationUrl</fields><fields>IsNegative</fields><fields>KeywordText</fields></selector><reportName>Keyword Performance Report</reportName><reportType>KEYWORDS_PERFORMANCE_REPORT</reportType><dateRangeType>YESTERDAY</dateRangeType><downloadFormat>GZIPPED_XML</downloadFormat><includeZeroImpressions>true</includeZeroImpressions></reportDefinition>
2012-12-04 10:25:33.609 (4) [DownloaderT3]: XML-><reportDefinition><selector><fields>AdGroupName</fields><fields>KeywordContentMaxCpc</fields><fields>ProxyKeywordMaxCpc</fields><fields>MaxCpm</fields><fields>KeywordMaxCpc</fields><fields>AdGroupId</fields></selector><reportName>Adgroup Performance Report</reportName><reportType>ADGROUP_PERFORMANCE_REPORT</reportType><dateRangeType>YESTERDAY</dateRangeType><downloadFormat>GZIPPED_XML</downloadFormat><includeZeroImpressions>true</includeZeroImpressions></reportDefinition>
2012-12-04 10:25:33.613 (4) [DownloaderT1]: XML-><reportDefinition><selector><fields>CampaignId</fields><fields>AdGroupId</fields><fields>Id</fields><fields>AdGroupStatus</fields><fields>MaxCpc</fields><fields>MaxCpm</fields><fields>CriteriaType</fields><fields>Status</fields><fields>CriteriaDestinationUrl</fields><fields>IsNegative</fields><fields>Criteria</fields><predicates><field>CriteriaType</field><operator>IN</operator><values>VERTICAL</values><values>PLACEMENT</values></predicates></selector><reportName>Criteria Performance Report</reportName><reportType>CRITERIA_PERFORMANCE_REPORT</reportType><dateRangeType>YESTERDAY</dateRangeType><downloadFormat>GZIPPED_XML</downloadFormat><includeZeroImpressions>true</includeZeroImpressions></reportDefinition>
2012-12-04 10:25:33.764 (4) [ConnectionCloser]: 4 DatabasePools remaining : 0 pending closure
2012-12-04 10:25:45.067 (2) [P1T1]: Downloaded and validated Criteria Performance Report 79469 bytes.
2012-12-04 10:25:45.068 (2) [P1T1]: Downloaded and validated Keyword Performance Report 118733 bytes.
2012-12-04 10:25:45.068 (2) [P1T1]: Downloaded and validated Adgroup Performance Report 10225 bytes.
2012-12-04 10:25:45.068 (5) [P1T1]: recordAsSubs("google", 18688, "P1T1")
2012-12-04 10:25:45.068 (5) [P1T1]: addSub("google")
2012-12-04 10:25:45.069 (5) [P1T1]: ProfilerRec.end("google", true): ret=18688
2012-12-04 10:25:45.069 (5) [P1T1]: ProfilerRec.start("parsing",true) in Thread [P1T1]
2012-12-04 10:25:45.069 (2) [P1T1]: Parsing report as secondary report: Adgroup Performance Report
2012-12-04 10:25:45.073 (3) [P1T1]:   parsing columns for Adgroup Performance Report
2012-12-04 10:25:45.075 (4) [P1T1]: Found column 'adGroup'
2012-12-04 10:25:45.076 (4) [P1T1]: Ignoring attribute display=Ad group
2012-12-04 10:25:45.076 (4) [P1T1]: Found column 'displayNetworkMaxCPC'
2012-12-04 10:25:45.076 (4) [P1T1]: Ignoring attribute display=Display Network max. CPC
2012-12-04 10:25:45.076 (4) [P1T1]: Found column 'defaultMaxCPC'
2012-12-04 10:25:45.076 (4) [P1T1]: Ignoring attribute display=Default max. CPC
2012-12-04 10:25:45.076 (4) [P1T1]: Found column 'maxCPM'
2012-12-04 10:25:45.076 (4) [P1T1]: Ignoring attribute display=Max. CPM
2012-12-04 10:25:45.076 (4) [P1T1]: Found column 'adGroupID'
2012-12-04 10:25:45.077 (4) [P1T1]: Ignoring attribute display=Ad group ID
2012-12-04 10:25:45.111 (3) [P1T1]:   parsing rows for Adgroup Performance Report
2012-12-04 10:25:49.130 (2) [P1T1]: Finished parsing report: Adgroup Performance Report
2012-12-04 10:25:49.198 (2) [P1T1]: Parsing report as primary report: Criteria Performance Report with 248268184 bytes free 
2012-12-04 10:25:50.521 (3) [P1T1]:   parsing columns for Criteria Performance Report
2012-12-04 10:25:50.526 (3) [P1T1]: Columns already defined
2012-12-04 10:25:50.526 (4) [P1T1]: Found column 'campaignID'
2012-12-04 10:25:50.526 (4) [P1T1]: Ignoring attribute display=Campaign ID
2012-12-04 10:25:50.526 (4) [P1T1]: Found column 'adGroupID'
2012-12-04 10:25:50.526 (4) [P1T1]: Ignoring attribute display=Ad group ID
2012-12-04 10:25:50.526 (4) [P1T1]: Found column 'keywordID'
2012-12-04 10:25:50.527 (4) [P1T1]: Ignoring attribute display=Keyword ID
2012-12-04 10:25:50.527 (4) [P1T1]: Found column 'adGroupState'
2012-12-04 10:25:50.527 (4) [P1T1]: Ignoring attribute display=Ad group state
2012-12-04 10:25:50.527 (4) [P1T1]: Found column 'maxCPC'
2012-12-04 10:25:50.527 (4) [P1T1]: Ignoring attribute display=Max. CPC
2012-12-04 10:25:50.527 (4) [P1T1]: Found column 'maxCPM'
2012-12-04 10:25:50.527 (4) [P1T1]: Ignoring attribute display=Max. CPM
2012-12-04 10:25:50.527 (4) [P1T1]: Found column 'criteriaType'
2012-12-04 10:25:50.527 (4) [P1T1]: Ignoring attribute display=Criteria Type
2012-12-04 10:25:50.528 (4) [P1T1]: Found column 'keywordPlacementState'
2012-12-04 10:25:50.528 (4) [P1T1]: Ignoring attribute display=Keyword/Placement state
2012-12-04 10:25:50.528 (4) [P1T1]: Found column 'keywordPlacementDestinationURL'
2012-12-04 10:25:50.528 (4) [P1T1]: Ignoring attribute display=Keyword/Placement destination URL
2012-12-04 10:25:50.528 (4) [P1T1]: Found column 'isNegative'
2012-12-04 10:25:50.528 (4) [P1T1]: Ignoring attribute display=Is negative
2012-12-04 10:25:50.528 (4) [P1T1]: Found column 'keywordPlacement'
2012-12-04 10:25:50.528 (4) [P1T1]: Ignoring attribute display=Keyword / Placement
2012-12-04 10:25:50.694 (3) [P1T1]:   parsing rows for Criteria Performance Report
2012-12-04 10:26:03.796 (4) [ConnectionCloser]: 4 DatabasePools remaining : 0 pending closure
2012-12-04 10:26:05.237 (2) [P1T1]: Finished parsing report: Criteria Performance Report
2012-12-04 10:26:05.238 (2) [P1T1]: Parsing report as primary report: Keyword Performance Report with 236595928 bytes free 
2012-12-04 10:26:05.274 (3) [P1T1]:   parsing columns for Keyword Performance Report
2012-12-04 10:26:05.276 (3) [P1T1]: Columns already defined
2012-12-04 10:26:05.278 (4) [P1T1]: Found column 'campaignID'
2012-12-04 10:26:05.278 (4) [P1T1]: Ignoring attribute display=Campaign ID
2012-12-04 10:26:05.278 (4) [P1T1]: Found column 'adGroupID'
2012-12-04 10:26:05.278 (4) [P1T1]: Ignoring attribute display=Ad group ID
2012-12-04 10:26:05.278 (4) [P1T1]: Found column 'keywordID'
2012-12-04 10:26:05.278 (4) [P1T1]: Ignoring attribute display=Keyword ID
2012-12-04 10:26:05.278 (4) [P1T1]: Found column 'adGroupState'
2012-12-04 10:26:05.278 (4) [P1T1]: Ignoring attribute display=Ad group state
2012-12-04 10:26:05.279 (4) [P1T1]: Found column 'maxCPC'
2012-12-04 10:26:05.279 (4) [P1T1]: Ignoring attribute display=Max. CPC
2012-12-04 10:26:05.279 (4) [P1T1]: Found column 'maxCPM'
2012-12-04 10:26:05.279 (4) [P1T1]: Ignoring attribute display=Max. CPM
2012-12-04 10:26:05.279 (4) [P1T1]: Found column 'matchType'
2012-12-04 10:26:05.279 (4) [P1T1]: Ignoring attribute display=Match type
2012-12-04 10:26:05.279 (4) [P1T1]: Found column 'keywordState'
2012-12-04 10:26:05.279 (4) [P1T1]: Ignoring attribute display=Keyword state
2012-12-04 10:26:05.280 (4) [P1T1]: Found column 'destinationURL'
2012-12-04 10:26:05.280 (4) [P1T1]: Ignoring attribute display=Destination URL
2012-12-04 10:26:05.280 (4) [P1T1]: Found column 'isNegative'
2012-12-04 10:26:05.280 (4) [P1T1]: Ignoring attribute display=Is negative
2012-12-04 10:26:05.280 (4) [P1T1]: Found column 'keyword'
2012-12-04 10:26:05.280 (4) [P1T1]: Ignoring attribute display=Keyword
2012-12-04 10:26:05.920 (3) [P1T1]:   parsing rows for Keyword Performance Report
2012-12-04 10:26:16.975 (3) [main]: Waiting for tasks to be done
2012-12-04 10:26:18.720 (2) [P1T1]: Finished parsing report: Keyword Performance Report
2012-12-04 10:26:18.729 (5) [P1T1]: recordAsSubs("parsing", 33660, "P1T1")
2012-12-04 10:26:18.730 (5) [P1T1]: addSub("parsing")
2012-12-04 10:26:18.730 (5) [P1T1]: ProfilerRec.end("parsing", true): ret=33660
2012-12-04 10:26:22.398 (2) [P1T1]: Created temp file: /var/local/tsa/google_sync_files/tsa-keyword-structure-report--3177-2012-12-04 10:25:2560540.tmp
2012-12-04 10:26:22.398 (2) [P1T1]: googleAds
2012-12-04 10:26:22.400 (5) [P1T1]: ProfilerRec.start("google",true) in Thread [P1T1]
2012-12-04 10:26:22.400 (2) [P1T1]: Getting columns for : Ad Performance Report
2012-12-04 10:26:22.401 (2) [P1T1]: Got : CampaignId
2012-12-04 10:26:22.401 (2) [P1T1]: Got : AdGroupId
2012-12-04 10:26:22.401 (2) [P1T1]: Got : Headline
2012-12-04 10:26:22.401 (2) [P1T1]: Got : Description1
2012-12-04 10:26:22.401 (2) [P1T1]: Got : Description2
2012-12-04 10:26:22.401 (2) [P1T1]: Got : DisplayUrl
2012-12-04 10:26:22.401 (2) [P1T1]: Got : Id
2012-12-04 10:26:22.401 (2) [P1T1]: Got : AdType
2012-12-04 10:26:22.402 (2) [P1T1]: Got : Status
2012-12-04 10:26:22.402 (2) [P1T1]: Got : CreativeDestinationUrl
2012-12-04 10:26:22.664 (2) [DownloaderT1]: Downloading report : Ad Performance Report
2012-12-04 10:26:22.664 (3) [DownloaderT1]: Downloading report attempt 1: Customer Client ID: 9001082081
2012-12-04 10:26:23.319 (4) [DownloaderT1]: XML-><reportDefinition><selector><fields>CampaignId</fields><fields>AdGroupId</fields><fields>Headline</fields><fields>Description1</fields><fields>Description2</fields><fields>DisplayUrl</fields><fields>Id</fields><fields>AdType</fields><fields>Status</fields><fields>CreativeDestinationUrl</fields></selector><reportName>Ad Performance Report</reportName><reportType>AD_PERFORMANCE_REPORT</reportType><dateRangeType>YESTERDAY</dateRangeType><downloadFormat>GZIPPED_XML</downloadFormat><includeZeroImpressions>true</includeZeroImpressions></reportDefinition>
2012-12-04 10:26:31.826 (2) [P1T1]: Downloaded and validated Ad Performance Report 240923 bytes.
2012-12-04 10:26:31.827 (5) [P1T1]: recordAsSubs("google", 9427, "P1T1")
2012-12-04 10:26:31.827 (5) [P1T1]: addSub("google")
2012-12-04 10:26:31.827 (5) [P1T1]: ProfilerRec.end("google", true): ret=9427
2012-12-04 10:26:31.827 (5) [P1T1]: ProfilerRec.start("parsing",true) in Thread [P1T1]
2012-12-04 10:26:31.829 (2) [P1T1]: Parsing report as primary report: Ad Performance Report with 244939656 bytes free 
2012-12-04 10:26:31.884 (3) [P1T1]:   parsing columns for Ad Performance Report
2012-12-04 10:26:31.903 (4) [P1T1]: Found column 'campaignID'
2012-12-04 10:26:31.904 (4) [P1T1]: Ignoring attribute display=Campaign ID
2012-12-04 10:26:31.904 (4) [P1T1]: Found column 'adGroupID'
2012-12-04 10:26:31.905 (4) [P1T1]: Ignoring attribute display=Ad group ID
2012-12-04 10:26:31.905 (4) [P1T1]: Found column 'ad'
2012-12-04 10:26:31.905 (4) [P1T1]: Ignoring attribute display=Ad
2012-12-04 10:26:31.905 (4) [P1T1]: Found column 'descriptionLine1'
2012-12-04 10:26:31.905 (4) [P1T1]: Ignoring attribute display=Description line 1
2012-12-04 10:26:31.905 (4) [P1T1]: Found column 'descriptionLine2'
2012-12-04 10:26:31.905 (4) [P1T1]: Ignoring attribute display=Description line 2
2012-12-04 10:26:31.905 (4) [P1T1]: Found column 'displayURL'
2012-12-04 10:26:31.905 (4) [P1T1]: Ignoring attribute display=Display URL
2012-12-04 10:26:31.905 (4) [P1T1]: Found column 'adID'
2012-12-04 10:26:31.905 (4) [P1T1]: Ignoring attribute display=Ad ID
2012-12-04 10:26:31.906 (4) [P1T1]: Found column 'adType'
2012-12-04 10:26:31.906 (4) [P1T1]: Ignoring attribute display=Ad type
2012-12-04 10:26:31.906 (4) [P1T1]: Found column 'adState'
2012-12-04 10:26:31.906 (4) [P1T1]: Ignoring attribute display=Ad state
2012-12-04 10:26:31.906 (4) [P1T1]: Found column 'destinationURL'
2012-12-04 10:26:31.907 (4) [P1T1]: Ignoring attribute display=Destination URL
2012-12-04 10:26:33.340 (3) [P1T1]:   parsing rows for Ad Performance Report
2012-12-04 10:26:33.801 (4) [ConnectionCloser]: 4 DatabasePools remaining : 0 pending closure
2012-12-04 10:26:42.703 (2) [P1T1]: Finished parsing report: Ad Performance Report
2012-12-04 10:26:42.707 (5) [P1T1]: recordAsSubs("parsing", 10880, "P1T1")
2012-12-04 10:26:42.708 (5) [P1T1]: addSub("parsing")
2012-12-04 10:26:42.708 (5) [P1T1]: ProfilerRec.end("parsing", true): ret=10880
2012-12-04 10:26:44.802 (2) [P1T1]: Created temp file: /var/local/tsa/google_sync_files/tsa-creative-structure-report--3177-2012-12-04 10:25:2560541.tmp
2012-12-04 10:26:44.803 (3) [P1T1]: -- Data staging complete for seuser ((3177) "AT&T Pan Asian Youth Campaign")
2012-12-04 10:26:44.804 (5) [P1T1]: quoteValue(), nothing special about it=>[3177], type=class java.lang.Integer
2012-12-04 10:26:44.805 (5) [P1T1]: quoteValue(), nothing special about it=>[3], type=class java.lang.Integer
2012-12-04 10:26:44.805 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1]
2012-12-04 10:26:44.806 (4) [P1T1]: spike: SQL->[select distinct `tsacommon`.`searchEngineUsers`.`accountID` AS `seUser_acctID`,`tsacommon`.`searchEngineAccounts`.`accountID` AS `seAcct_acctID` from `searchEngineAccounts` join `accounts` on ((`tsacommon`.`accounts`.`id`=`tsacommon`.`searchEngineAccounts`.`accountID`)) join `searchEngineUsers` on ((`tsacommon`.`searchEngineUsers`.`id`=`tsacommon`.`searchEngineAccounts`.`searchEngineUserID`)) where ((`tsacommon`.`searchEngineUsers`.`id`=3177) and (`tsacommon`.`accounts`.`id` in (898)) and (`tsacommon`.`searchEngineUsers`.`enabled`="true") and (`tsacommon`.`accounts`.`isActive`="true") and (`tsacommon`.`searchEngineUsers`.`distributionID`=3))]
2012-12-04 10:26:44.812 (5) [P1T1]: recordAsSubs("db", 6, "P1T1")
2012-12-04 10:26:44.812 (5) [P1T1]: addSub("db")
2012-12-04 10:26:44.812 (5) [P1T1]: ProfilerRec.end("db", true): ret=6
2012-12-04 10:26:44.812 (4) [P1T1]: time=0.0060
2012-12-04 10:26:44.813 (4) [P1T1]: Query executed in 0.006s
2012-12-04 10:26:44.818 (4) [P1T1]: DataCache: Found key acct-sync-google 898
2012-12-04 10:26:44.819 (4) [P1T1]: DataCache: Found key acct-sync-google-5
2012-12-04 10:26:45.004 (4) [P1T1]: opened [jdbc:mysql://acctdb-05-write:3309/sync_google?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false]
2012-12-04 10:26:45.009 (4) [P1T1]: Created new Object
2012-12-04 10:26:45.009 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1]
2012-12-04 10:26:45.009 (4) [P1T1]: spike: SQL->[select @@version]
2012-12-04 10:26:45.062 (5) [P1T1]: recordAsSubs("db", 53, "P1T1")
2012-12-04 10:26:45.063 (5) [P1T1]: addSub("db")
2012-12-04 10:26:45.063 (5) [P1T1]: ProfilerRec.end("db", true): ret=53
2012-12-04 10:26:45.063 (4) [P1T1]: time=0.053
2012-12-04 10:26:45.063 (4) [P1T1]: Query executed in 0.053s
2012-12-04 10:26:45.064 (4) [P1T1]: test query succeeded, returned "5.1.61-rel13.2"
2012-12-04 10:26:45.064 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1]
2012-12-04 10:26:45.064 (4) [P1T1]: spike: SQL->[SELECT GET_LOCK('com.thesearchagency.searchengines.google.GoogleStructureSync.searchEngineUserID.3177', 10800)]
2012-12-04 10:26:45.065 (5) [P1T1]: recordAsSubs("db", 1, "P1T1")
2012-12-04 10:26:45.065 (5) [P1T1]: addSub("db")
2012-12-04 10:26:45.065 (5) [P1T1]: ProfilerRec.end("db", true): ret=1
2012-12-04 10:26:45.066 (4) [P1T1]: time=0.0010
2012-12-04 10:26:45.066 (4) [P1T1]: Query executed in 0.001s
2012-12-04 10:26:45.073 (4) [P1T1]: DB IsolationLevel -> 4
2012-12-04 10:26:45.074 (4) [P1T1]: DB AutoCommit -> false
2012-12-04 10:26:45.074 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1]
2012-12-04 10:26:45.075 (4) [P1T1]: spike: SQL->[start transaction]
2012-12-04 10:26:45.075 (5) [P1T1]: recordAsSubs("db", 0, "P1T1")
2012-12-04 10:26:45.076 (5) [P1T1]: addSub("db")
2012-12-04 10:26:45.076 (5) [P1T1]: ProfilerRec.end("db", true): ret=0
2012-12-04 10:26:45.076 (4) [P1T1]: time=0.0
2012-12-04 10:26:45.076 (4) [P1T1]: Query executed in 0.000s
2012-12-04 10:26:45.076 (5) [P1T1]: SQL execute() returned false
2012-12-04 10:26:45.076 (3) [P1T1]:   Loading data infile into temp table...
2012-12-04 10:26:45.082 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1]
2012-12-04 10:26:45.082 (4) [P1T1]: spike: SQL->[create temporary table `tmp`.`tmp1` (index(searchEngineUserID,campaignid,adgroupid,keywordid)) engine=myisam character set latin1 collate latin1_swedish_ci select * from `sync_google`.`googleKeywords` where (0)]
2012-12-04 10:26:45.085 (5) [P1T1]: recordAsSubs("db", 3, "P1T1")
2012-12-04 10:26:45.085 (5) [P1T1]: addSub("db")
2012-12-04 10:26:45.085 (5) [P1T1]: ProfilerRec.end("db", true): ret=3
2012-12-04 10:26:45.085 (4) [P1T1]: time=0.0030
2012-12-04 10:26:45.086 (4) [P1T1]: Query executed in 0.003s
2012-12-04 10:26:45.086 (5) [P1T1]: SQL execute() returned false
2012-12-04 10:26:45.086 (2) [P1T1]: Trying to load : /var/local/tsa/google_sync_files/tsa-keyword-structure-report--3177-2012-12-04 10:25:2560540.tmp into `tmp`.`tmp1`
2012-12-04 10:26:45.087 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1]
2012-12-04 10:26:45.087 (4) [P1T1]: spike: SQL->[LOAD DATA LOCAL INFILE "/var/local/tsa/google_sync_files/tsa-keyword-structure-report--3177-2012-12-04 10:25:2560540.tmp" INTO TABLE `tmp`.`tmp1` ( campaignId, adgroupId, keywordid, adgroup, agStatus, maxCpc, maxCpm, kwType, kwStatus, kwDestUrl, kwisnegative, keyword, maxContentCpc, adGroupMaxCpc, adGroupMaxContentCpc, adGroupMaxCpm, adGroupSiteMaxCpc )]
2012-12-04 10:26:45.773 (5) [P1T1]: recordAsSubs("db", 686, "P1T1")
2012-12-04 10:26:45.774 (5) [P1T1]: addSub("db")
2012-12-04 10:26:45.774 (5) [P1T1]: ProfilerRec.end("db", true): ret=686
2012-12-04 10:26:45.774 (4) [P1T1]: time=0.686
2012-12-04 10:26:45.774 (4) [P1T1]: Query executed in 0.686s
2012-12-04 10:26:45.775 (5) [P1T1]: SQL execute() returned false
2012-12-04 10:26:45.775 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1]
2012-12-04 10:26:45.775 (4) [P1T1]: spike: SQL->[UPDATE `tmp`.`tmp1` set searchEngineUserID= 3177]
2012-12-04 10:26:46.022 (5) [P1T1]: recordAsSubs("db", 247, "P1T1")
2012-12-04 10:26:46.023 (5) [P1T1]: addSub("db")
2012-12-04 10:26:46.023 (5) [P1T1]: ProfilerRec.end("db", true): ret=247
2012-12-04 10:26:46.023 (4) [P1T1]: time=0.247
2012-12-04 10:26:46.024 (4) [P1T1]: Query executed in 0.247s
2012-12-04 10:26:46.024 (5) [P1T1]: SQL execute() returned false
2012-12-04 10:26:46.024 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1]
2012-12-04 10:26:46.024 (4) [P1T1]: spike: SQL->[create temporary table `tmp`.`tmp2` (index(searchEngineUserID,campaignid,creativeid,adgroupid)) engine=myisam character set latin1 collate latin1_swedish_ci select * from `sync_google`.`googleAds` where (0)]
2012-12-04 10:26:46.465 (5) [P1T1]: recordAsSubs("db", 441, "P1T1")
2012-12-04 10:26:46.465 (5) [P1T1]: addSub("db")
2012-12-04 10:26:46.466 (5) [P1T1]: ProfilerRec.end("db", true): ret=441
2012-12-04 10:26:46.466 (4) [P1T1]: time=0.441
2012-12-04 10:26:46.466 (4) [P1T1]: Query executed in 0.441s
2012-12-04 10:26:46.466 (5) [P1T1]: SQL execute() returned false
2012-12-04 10:26:46.466 (2) [P1T1]: Trying to load : /var/local/tsa/google_sync_files/tsa-creative-structure-report--3177-2012-12-04 10:25:2560541.tmp into `tmp`.`tmp2`
2012-12-04 10:26:46.467 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1]
2012-12-04 10:26:46.467 (4) [P1T1]: spike: SQL->[LOAD DATA LOCAL INFILE "/var/local/tsa/google_sync_files/tsa-creative-structure-report--3177-2012-12-04 10:25:2560541.tmp" INTO TABLE `tmp`.`tmp2` (`campaignid`,`adgroupid`,`headline`,`desc1`,`desc2`,`creativeVisUrl`,`creativeid`,`creativeType`,`creativeStatus`,`creativeDestUrl`)]
2012-12-04 10:26:47.028 (5) [P1T1]: recordAsSubs("db", 560, "P1T1")
2012-12-04 10:26:47.028 (5) [P1T1]: addSub("db")
2012-12-04 10:26:47.028 (5) [P1T1]: ProfilerRec.end("db", true): ret=560
2012-12-04 10:26:47.029 (4) [P1T1]: time=0.56
2012-12-04 10:26:47.029 (4) [P1T1]: Query executed in 0.560s
2012-12-04 10:26:47.029 (5) [P1T1]: SQL execute() returned false
2012-12-04 10:26:47.029 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1]
2012-12-04 10:26:47.029 (4) [P1T1]: spike: SQL->[UPDATE `tmp`.`tmp2` set searchEngineUserID= 3177]
2012-12-04 10:26:47.647 (5) [P1T1]: recordAsSubs("db", 618, "P1T1")
2012-12-04 10:26:47.648 (5) [P1T1]: addSub("db")
2012-12-04 10:26:47.648 (5) [P1T1]: ProfilerRec.end("db", true): ret=618
2012-12-04 10:26:47.648 (4) [P1T1]: time=0.618
2012-12-04 10:26:47.648 (4) [P1T1]: Query executed in 0.618s
2012-12-04 10:26:47.648 (5) [P1T1]: SQL execute() returned false
2012-12-04 10:26:47.649 (3) [P1T1]: LOAD TEMP SYNC TABLES COMPLETED
2012-12-04 10:26:47.650 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1]
2012-12-04 10:26:47.650 (4) [P1T1]: spike: SQL->[select distinct `tmp`.`tmp1`.campaignid from `tmp`.`tmp1` left join `sync_google`.`googleKeywords` on (((`sync_google`.`googleKeywords`.`searchEngineUserID`=`tmp`.`tmp1`.`searchEngineUserID`) and (`sync_google`.`googleKeywords`.`adgroupid`=`tmp`.`tmp1`.`adgroupid`) and (`sync_google`.`googleKeywords`.`campaignid`=`tmp`.`tmp1`.`campaignid`) and (`sync_google`.`googleKeywords`.`keywordid`=`tmp`.`tmp1`.`keywordid`))) where ((`sync_google`.`googleKeywords`.`campaignid` is null))]
2012-12-04 10:26:47.839 (5) [P1T1]: recordAsSubs("db", 189, "P1T1")
2012-12-04 10:26:47.840 (5) [P1T1]: addSub("db")
2012-12-04 10:26:47.840 (5) [P1T1]: ProfilerRec.end("db", true): ret=189
2012-12-04 10:26:47.840 (4) [P1T1]: time=0.189
2012-12-04 10:26:47.841 (4) [P1T1]: Query executed in 0.189s
2012-12-04 10:26:47.842 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1]
2012-12-04 10:26:47.842 (4) [P1T1]: spike: SQL->[select distinct `tmp`.`tmp2`.campaignid from `tmp`.`tmp2` left join `sync_google`.`googleAds` on (((`sync_google`.`googleAds`.`searchEngineUserID`=`tmp`.`tmp2`.`searchEngineUserID`) and (`sync_google`.`googleAds`.`adgroupid`=`tmp`.`tmp2`.`adgroupid`) and (`sync_google`.`googleAds`.`campaignid`=`tmp`.`tmp2`.`campaignid`) and (`sync_google`.`googleAds`.`creativeid`=`tmp`.`tmp2`.`creativeid`))) where ((`sync_google`.`googleAds`.`campaignid` is null))]
2012-12-04 10:26:48.095 (5) [P1T1]: recordAsSubs("db", 253, "P1T1")
2012-12-04 10:26:48.095 (5) [P1T1]: addSub("db")
2012-12-04 10:26:48.096 (5) [P1T1]: ProfilerRec.end("db", true): ret=253
2012-12-04 10:26:48.096 (4) [P1T1]: time=0.253
2012-12-04 10:26:48.096 (4) [P1T1]: Query executed in 0.253s
2012-12-04 10:26:48.097 (3) [P1T1]: Campaigns with new items:([])
2012-12-04 10:26:48.097 (3) [P1T1]: DETECTION OF NEW CAMPAIGN ITEMS COMPLETED
2012-12-04 10:26:48.097 (5) [P1T1]: quoteValue(), nothing special about it=>[3177], type=class java.lang.Integer
2012-12-04 10:26:48.098 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1]
2012-12-04 10:26:48.098 (4) [P1T1]: spike: SQL->[select `sync_google`.`googleKeywords`.searchEngineUserID,`sync_google`.`googleKeywords`.campaignid,`sync_google`.`googleKeywords`.adgroupid,`sync_google`.`googleKeywords`.keywordid from `sync_google`.`googleKeywords` left join `tmp`.`tmp1` on (((`sync_google`.`googleKeywords`.`searchEngineUserID`=`tmp`.`tmp1`.`searchEngineUserID`) and (`sync_google`.`googleKeywords`.`adgroupid`=`tmp`.`tmp1`.`adgroupid`) and (`sync_google`.`googleKeywords`.`campaignid`=`tmp`.`tmp1`.`campaignid`) and (`sync_google`.`googleKeywords`.`keywordid`=`tmp`.`tmp1`.`keywordid`))) where ((`tmp`.`tmp1`.campaignid is null) and (`sync_google`.`googleKeywords`.`searchEngineUserID`=3177))]
2012-12-04 10:26:48.152 (5) [P1T1]: recordAsSubs("db", 54, "P1T1")
2012-12-04 10:26:48.153 (5) [P1T1]: addSub("db")
2012-12-04 10:26:48.153 (5) [P1T1]: ProfilerRec.end("db", true): ret=54
2012-12-04 10:26:48.153 (4) [P1T1]: time=0.054
2012-12-04 10:26:48.153 (4) [P1T1]: Query executed in 0.054s
2012-12-04 10:26:48.154 (5) [P1T1]: quoteValue(), nothing special about it=>[3177], type=class java.lang.Integer
2012-12-04 10:26:48.154 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1]
2012-12-04 10:26:48.155 (4) [P1T1]: spike: SQL->[select `sync_google`.`googleAds`.searchEngineUserID,`sync_google`.`googleAds`.campaignid,`sync_google`.`googleAds`.adgroupid,`sync_google`.`googleAds`.creativeid from `sync_google`.`googleAds` left join `tmp`.`tmp2` on (((`sync_google`.`googleAds`.`searchEngineUserID`=`tmp`.`tmp2`.`searchEngineUserID`) and (`sync_google`.`googleAds`.`adgroupid`=`tmp`.`tmp2`.`adgroupid`) and (`sync_google`.`googleAds`.`campaignid`=`tmp`.`tmp2`.`campaignid`) and (`sync_google`.`googleAds`.`creativeid`=`tmp`.`tmp2`.`creativeid`))) where ((`sync_google`.`googleAds`.`campaignid` is null) and (`sync_google`.`googleAds`.`searchEngineUserID`=3177))]
2012-12-04 10:26:48.156 (5) [P1T1]: recordAsSubs("db", 1, "P1T1")
2012-12-04 10:26:48.156 (5) [P1T1]: addSub("db")
2012-12-04 10:26:48.156 (5) [P1T1]: ProfilerRec.end("db", true): ret=1
2012-12-04 10:26:48.156 (4) [P1T1]: time=0.0010
2012-12-04 10:26:48.156 (4) [P1T1]: Query executed in 0.001s
2012-12-04 10:26:48.157 (3) [P1T1]: Campaigns with deleted items:([])
2012-12-04 10:26:48.157 (3) [P1T1]: DETECTION OF DELETED CAMPAIGN ITEMS COMPLETED
2012-12-04 10:26:48.158 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1]
2012-12-04 10:26:48.158 (4) [P1T1]: spike: SQL->[select distinct `tmp`.`tmp1`.campaignid from `tmp`.`tmp1` inner join `sync_google`.`googleKeywords` on (((`sync_google`.`googleKeywords`.`searchEngineUserID`=`tmp`.`tmp1`.`searchEngineUserID`) and (`sync_google`.`googleKeywords`.`adgroupid`=`tmp`.`tmp1`.`adgroupid`) and (`sync_google`.`googleKeywords`.`campaignid`=`tmp`.`tmp1`.`campaignid`) and (`sync_google`.`googleKeywords`.`keywordid`=`tmp`.`tmp1`.`keywordid`))) where (((`sync_google`.`googleKeywords`.`keyword`!=`tmp`.`tmp1`.`keyword`) or (`sync_google`.`googleKeywords`.`kwType`!=`tmp`.`tmp1`.`kwType`) or (`sync_google`.`googleKeywords`.`kwStatus`!=`tmp`.`tmp1`.`kwStatus`) or (`sync_google`.`googleKeywords`.`kwDestUrl`!=`tmp`.`tmp1`.`kwDestUrl`) or (`sync_google`.`googleKeywords`.`agStatus`!=`tmp`.`tmp1`.`agStatus`) or (`sync_google`.`googleKeywords`.`kwisnegative`!=`tmp`.`tmp1`.`kwisnegative`)))]
2012-12-04 10:26:48.352 (5) [P1T1]: recordAsSubs("db", 193, "P1T1")
2012-12-04 10:26:48.352 (5) [P1T1]: addSub("db")
2012-12-04 10:26:48.352 (5) [P1T1]: ProfilerRec.end("db", true): ret=193
2012-12-04 10:26:48.352 (4) [P1T1]: time=0.193
2012-12-04 10:26:48.353 (4) [P1T1]: Query executed in 0.193s
2012-12-04 10:26:48.355 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1]
2012-12-04 10:26:48.355 (4) [P1T1]: spike: SQL->[select distinct `tmp`.`tmp2`.campaignid from `tmp`.`tmp2` inner join `sync_google`.`googleAds` on (((`sync_google`.`googleAds`.`searchEngineUserID`=`tmp`.`tmp2`.`searchEngineUserID`) and (`sync_google`.`googleAds`.`campaignid`=`tmp`.`tmp2`.`campaignid`) and (`sync_google`.`googleAds`.`adgroupid`=`tmp`.`tmp2`.`adgroupid`) and (`sync_google`.`googleAds`.`creativeid`=`tmp`.`tmp2`.`creativeid`))) where (((`sync_google`.`googleAds`.`headline`!=`tmp`.`tmp2`.`headline`) or (`sync_google`.`googleAds`.`desc1`!=`tmp`.`tmp2`.`desc1`) or (`sync_google`.`googleAds`.`desc2`!=`tmp`.`tmp2`.`desc2`) or (`sync_google`.`googleAds`.`creativeVisUrl`!=`tmp`.`tmp2`.`creativeVisUrl`) or (`sync_google`.`googleAds`.`creativeType`!=`tmp`.`tmp2`.`creativeType`) or (`sync_google`.`googleAds`.`creativeStatus`!=`tmp`.`tmp2`.`creativeStatus`) or (`sync_google`.`googleAds`.`creativeDestUrl`!=`tmp`.`tmp2`.`creativeDestUrl`)))]
2012-12-04 10:26:48.793 (5) [P1T1]: recordAsSubs("db", 438, "P1T1")
2012-12-04 10:26:48.794 (5) [P1T1]: addSub("db")
2012-12-04 10:26:48.794 (5) [P1T1]: ProfilerRec.end("db", true): ret=438
2012-12-04 10:26:48.794 (4) [P1T1]: time=0.438
2012-12-04 10:26:48.794 (4) [P1T1]: Query executed in 0.438s
2012-12-04 10:26:48.795 (3) [P1T1]: Campaigns with updated items:([])
2012-12-04 10:26:48.795 (3) [P1T1]: DETECTION OF UPDATED CAMPAIGN ITEMS COMPLETED
2012-12-04 10:26:48.795 (5) [P1T1]: quoteValue(), nothing special about it=>[3177], type=class java.lang.Integer
2012-12-04 10:26:48.796 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1]
2012-12-04 10:26:48.796 (4) [P1T1]: spike: SQL->[delete from `sync_google`.`googleKeywords` where ((`searchEngineUserID`=3177))], genflags=no
2012-12-04 10:26:48.884 (5) [P1T1]: recordAsSubs("db", 88, "P1T1")
2012-12-04 10:26:48.884 (5) [P1T1]: addSub("db")
2012-12-04 10:26:48.884 (5) [P1T1]: ProfilerRec.end("db", true): ret=88
2012-12-04 10:26:48.885 (4) [P1T1]: time=0.088
2012-12-04 10:26:48.885 (4) [P1T1]: Query executed in 0.088s, 12666 row(s) affected
2012-12-04 10:26:48.885 (3) [P1T1]: 12666 keyword records removed before re-loading staging table.
2012-12-04 10:26:48.888 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1]
2012-12-04 10:26:48.888 (4) [P1T1]: spike: SQL->[insert into `sync_google`.`googleKeywords` (`searchEngineUserID`,`campaignid`,`adgroupid`,`keywordid`,`keyword`,`kwType`,`kwStatus`,`maxCpc`,`maxCpm`,`maxContentCpc`,`kwDestUrl`,`kwisnegative`,`agStatus`,`adGroupMaxContentCpc`,`adGroupMaxCpc`,`adGroupMaxCpm`,`adGroupSiteMaxCpc`,`adgroup`)  select `searchEngineUserID`,`campaignid`,`adgroupid`,`keywordid`,`keyword`,`kwType`,`kwStatus`,`maxCpc`,`maxCpm`,`maxContentCpc`,`kwDestUrl`,`kwisnegative`,`agStatus`,`adGroupMaxContentCpc`,`adGroupMaxCpc`,`adGroupMaxCpm`,`adGroupSiteMaxCpc`,`adgroup` from `tmp`.`tmp1` where ((`searchEngineUserID`=3177))], genflags=no
2012-12-04 10:26:49.190 (5) [P1T1]: recordAsSubs("db", 301, "P1T1")
2012-12-04 10:26:49.190 (5) [P1T1]: addSub("db")
2012-12-04 10:26:49.190 (5) [P1T1]: ProfilerRec.end("db", true): ret=301
2012-12-04 10:26:49.191 (4) [P1T1]: time=0.301
2012-12-04 10:26:49.191 (4) [P1T1]: Query executed in 0.301s, 12666 row(s) affected
2012-12-04 10:26:49.191 (3) [P1T1]: 12666 keyword records loaded into staging table.
2012-12-04 10:26:49.192 (5) [P1T1]: quoteValue(), nothing special about it=>[3177], type=class java.lang.Integer
2012-12-04 10:26:49.192 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1]
2012-12-04 10:26:49.192 (4) [P1T1]: spike: SQL->[delete from `sync_google`.`googleAds` where ((`searchEngineUserID`=3177))], genflags=no
2012-12-04 10:26:49.364 (5) [P1T1]: recordAsSubs("db", 172, "P1T1")
2012-12-04 10:26:49.365 (5) [P1T1]: addSub("db")
2012-12-04 10:26:49.365 (5) [P1T1]: ProfilerRec.end("db", true): ret=172
2012-12-04 10:26:49.365 (4) [P1T1]: time=0.172
2012-12-04 10:26:49.365 (4) [P1T1]: Query executed in 0.172s, 29524 row(s) affected
2012-12-04 10:26:49.365 (3) [P1T1]: 29524 creative ad records removed from staging table before re-loading.
2012-12-04 10:26:49.366 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1]
2012-12-04 10:26:49.367 (4) [P1T1]: spike: SQL->[insert into `sync_google`.`googleAds` (`searchEngineUserID`,`campaignid`,`adgroupid`,`headline`,`desc1`,`desc2`,`creativeVisUrl`,`creativeid`,`creativeType`,`creativeStatus`,`creativeDestUrl`)  select `searchEngineUserID`,`campaignid`,`adgroupid`,`headline`,`desc1`,`desc2`,`creativeVisUrl`,`creativeid`,`creativeType`,`creativeStatus`,`creativeDestUrl` from `tmp`.`tmp2` where ((`searchEngineUserID`=3177))], genflags=no
2012-12-04 10:26:49.905 (5) [P1T1]: recordAsSubs("db", 538, "P1T1")
2012-12-04 10:26:49.906 (5) [P1T1]: addSub("db")
2012-12-04 10:26:49.906 (5) [P1T1]: ProfilerRec.end("db", true): ret=538
2012-12-04 10:26:49.906 (4) [P1T1]: time=0.538
2012-12-04 10:26:49.906 (4) [P1T1]: Query executed in 0.538s, 29524 row(s) affected
2012-12-04 10:26:49.907 (3) [P1T1]: 29524 creative ad records loaded into staging table.
2012-12-04 10:26:49.907 (3) [P1T1]: UPDATE OF STAGING TABLES COMPLETED
2012-12-04 10:26:49.908 (3) [P1T1]: Passing seUserAcctId: 898 and seAcctAcctId: 898
2012-12-04 10:26:49.908 (4) [P1T1]: DataCache: Found key acct-st-tracker 898
2012-12-04 10:26:49.908 (4) [P1T1]: DataCache: Found key acct-st-tracker-5
2012-12-04 10:26:49.921 (4) [P1T1]: opened [jdbc:mysql://acctdb-05-write:3309/st-tracker?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false]
2012-12-04 10:26:49.922 (4) [P1T1]: Created new Object
2012-12-04 10:26:49.922 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1]
2012-12-04 10:26:49.922 (4) [P1T1]: spike: SQL->[select @@version]
2012-12-04 10:26:49.923 (5) [P1T1]: recordAsSubs("db", 1, "P1T1")
2012-12-04 10:26:49.923 (5) [P1T1]: addSub("db")
2012-12-04 10:26:49.923 (5) [P1T1]: ProfilerRec.end("db", true): ret=1
2012-12-04 10:26:49.923 (4) [P1T1]: time=0.0010
2012-12-04 10:26:49.924 (4) [P1T1]: Query executed in 0.001s
2012-12-04 10:26:49.924 (4) [P1T1]: test query succeeded, returned "5.1.61-rel13.2"
2012-12-04 10:26:49.924 (5) [P1T1]: quoteValue(), nothing special about it=>[3], type=class java.lang.Integer
2012-12-04 10:26:49.925 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1]
2012-12-04 10:26:49.925 (4) [P1T1]: spike: SQL->[select `searchEngineIdentifier` from `tsacommon`.`searchEngineAccounts` where ((`tsacommon`.`searchEngineAccounts`.`accountID`="898") and (`tsacommon`.`searchEngineAccounts`.`searchEngineUserID`="3177") and (`tsacommon`.`searchEngineAccounts`.`distributionID`=3))]
2012-12-04 10:26:49.927 (5) [P1T1]: recordAsSubs("db", 2, "P1T1")
2012-12-04 10:26:49.927 (5) [P1T1]: addSub("db")
2012-12-04 10:26:49.927 (5) [P1T1]: ProfilerRec.end("db", true): ret=2
2012-12-04 10:26:49.927 (4) [P1T1]: time=0.0020
2012-12-04 10:26:49.928 (4) [P1T1]: Query executed in 0.002s
2012-12-04 10:26:49.933 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1]
2012-12-04 10:26:49.933 (4) [P1T1]: spike: SQL->[select COUNT(*) from googleKeywords where ((`searchEngineUserID`="3177") and (`campaignid` in ("86452850","86453090","86453930","86454890","86452730","86453690","86453810","86453330","86455130","86453570","86454170","86454770","86454650","86452250","86454050","86453450","86452970","86454410","86452370","86454530","88317170","86452130","86455370","86455010","86453210","86452610","86454290","86452490","86455250","109102010","109102370","109102130","109562330","109562210")))]
2012-12-04 10:26:49.944 (5) [P1T1]: recordAsSubs("db", 11, "P1T1")
2012-12-04 10:26:49.945 (5) [P1T1]: addSub("db")
2012-12-04 10:26:49.945 (5) [P1T1]: ProfilerRec.end("db", true): ret=11
2012-12-04 10:26:49.945 (4) [P1T1]: time=0.011
2012-12-04 10:26:49.945 (4) [P1T1]: Query executed in 0.011s
2012-12-04 10:26:49.946 (3) [P1T1]: Replicating 11370 rows...
2012-12-04 10:26:49.946 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1]
2012-12-04 10:26:49.946 (4) [P1T1]: spike: SQL->[select * from googleKeywords where ((`searchEngineUserID`="3177") and (`campaignid` in ("86452850","86453090","86453930","86454890","86452730","86453690","86453810","86453330","86455130","86453570","86454170","86454770","86454650","86452250","86454050","86453450","86452970","86454410","86452370","86454530","88317170","86452130","86455370","86455010","86453210","86452610","86454290","86452490","86455250","109102010","109102370","109102130","109562330","109562210"))) limit 0, 10000]
2012-12-04 10:26:50.405 (5) [P1T1]: recordAsSubs("db", 459, "P1T1")
2012-12-04 10:26:50.406 (5) [P1T1]: addSub("db")
2012-12-04 10:26:50.407 (5) [P1T1]: ProfilerRec.end("db", true): ret=459
2012-12-04 10:26:50.408 (4) [P1T1]: time=0.459
2012-12-04 10:26:50.409 (4) [P1T1]: Query executed in 0.459s
2012-12-04 10:26:50.412 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1]
2012-12-04 10:26:50.412 (4) [P1T1]: spike: SQL->[show create table `sync_google`.`googleKeywords`]
2012-12-04 10:26:50.437 (5) [P1T1]: recordAsSubs("db", 24, "P1T1")
2012-12-04 10:26:50.441 (5) [P1T1]: addSub("db")
2012-12-04 10:26:50.455 (5) [P1T1]: ProfilerRec.end("db", true): ret=24
2012-12-04 10:26:50.467 (4) [P1T1]: time=0.024
2012-12-04 10:26:50.469 (4) [P1T1]: Query executed in 0.024s
2012-12-04 10:26:50.472 (4) [P1T1]: convertCreateTableToTemp: source: CREATE TABLE `googleKeywords` (
  `searchEngineUserID` int(11) NOT NULL DEFAULT '0',
  `campaignid` bigint(20) NOT NULL DEFAULT '0',
  `adgroupid` bigint(20) NOT NULL DEFAULT '0',
  `keywordid` bigint(20) NOT NULL DEFAULT '0',
  `keyword` varchar(255) NOT NULL DEFAULT '',
  `kwType` varchar(25) NOT NULL DEFAULT 'unknown',
  `kwStatus` varchar(25) NOT NULL DEFAULT 'unknown',
  `maxCpc` double NOT NULL DEFAULT '0',
  `maxCpm` double NOT NULL DEFAULT '0',
  `maxContentCpc` double NOT NULL DEFAULT '0',
  `kwDestUrl` text NOT NULL,
  `kwisnegative` enum('false','true') NOT NULL DEFAULT 'false',
  `agStatus` varchar(25) NOT NULL DEFAULT 'unknown',
  `adGroupMaxContentCpc` double NOT NULL DEFAULT '0',
  `adGroupMaxCpc` double NOT NULL DEFAULT '0',
  `adGroupMaxCpm` double NOT NULL DEFAULT '0',
  `adGroupSiteMaxCpc` double NOT NULL DEFAULT '0',
  `adgroup` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`searchEngineUserID`,`campaignid`,`adgroupid`,`keywordid`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8
2012-12-04 10:26:50.481 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1]
2012-12-04 10:26:50.482 (4) [P1T1]: spike: SQL->[CREATE TEMPORARY TABLE `st-tracker`.`tmp3` (  `searchEngineUserID` int(11)  DEFAULT '0',  `campaignid` bigint(20)  DEFAULT '0',  `adgroupid` bigint(20)  DEFAULT '0',  `keywordid` bigint(20)  DEFAULT '0',  `keyword` varchar(255)  DEFAULT '',  `kwType` varchar(25)  DEFAULT 'unknown',  `kwStatus` varchar(25)  DEFAULT 'unknown',  `maxCpc` double  DEFAULT '0',  `maxCpm` double  DEFAULT '0',  `maxContentCpc` double  DEFAULT '0',  `kwDestUrl` text ,  `kwisnegative` enum('false','true')  DEFAULT 'false',  `agStatus` varchar(25)  DEFAULT 'unknown',  `adGroupMaxContentCpc` double  DEFAULT '0',  `adGroupMaxCpc` double  DEFAULT '0',  `adGroupMaxCpm` double  DEFAULT '0',  `adGroupSiteMaxCpc` double  DEFAULT '0',  `adgroup` varchar(255)  DEFAULT '',  PRIMARY KEY (`searchEngineUserID`,`campaignid`,`adgroupid`,`keywordid`) )]
2012-12-04 10:26:50.486 (5) [P1T1]: recordAsSubs("db", 4, "P1T1")
2012-12-04 10:26:50.487 (5) [P1T1]: addSub("db")
2012-12-04 10:26:50.487 (5) [P1T1]: ProfilerRec.end("db", true): ret=4
2012-12-04 10:26:50.487 (4) [P1T1]: time=0.0040
2012-12-04 10:26:50.487 (4) [P1T1]: Query executed in 0.004s
2012-12-04 10:26:50.487 (5) [P1T1]: SQL execute() returned false
2012-12-04 10:26:50.489 (4) [P1T1]: preparing SQL statement [insert into `st-tracker`.`tmp3` (`searchEngineUserID`, `campaignid`, `adgroupid`, `keywordid`, `keyword`, `kwType`, `kwStatus`, `maxCpc`, `maxCpm`, `maxContentCpc`, `kwDestUrl`, `kwisnegative`, `agStatus`, `adGroupMaxContentCpc`, `adGroupMaxCpc`, `adGroupMaxCpm`, `adGroupSiteMaxCpc`, `adgroup`) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)]
2012-12-04 10:26:58.496 (4) [P1T1]: replicated 10000 rows to `st-tracker`.`tmp3`
2012-12-04 10:26:58.497 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1]
2012-12-04 10:26:58.497 (4) [P1T1]: spike: SQL->[select * from googleKeywords where ((`searchEngineUserID`="3177") and (`campaignid` in ("86452850","86453090","86453930","86454890","86452730","86453690","86453810","86453330","86455130","86453570","86454170","86454770","86454650","86452250","86454050","86453450","86452970","86454410","86452370","86454530","88317170","86452130","86455370","86455010","86453210","86452610","86454290","86452490","86455250","109102010","109102370","109102130","109562330","109562210"))) limit 10000, 10000]
2012-12-04 10:26:58.551 (5) [P1T1]: recordAsSubs("db", 54, "P1T1")
2012-12-04 10:26:58.552 (5) [P1T1]: addSub("db")
2012-12-04 10:26:58.552 (5) [P1T1]: ProfilerRec.end("db", true): ret=54
2012-12-04 10:26:58.552 (4) [P1T1]: time=0.054
2012-12-04 10:26:58.552 (4) [P1T1]: Query executed in 0.054s
2012-12-04 10:26:58.554 (4) [P1T1]: preparing SQL statement [insert into `st-tracker`.`tmp3` (`searchEngineUserID`, `campaignid`, `adgroupid`, `keywordid`, `keyword`, `kwType`, `kwStatus`, `maxCpc`, `maxCpm`, `maxContentCpc`, `kwDestUrl`, `kwisnegative`, `agStatus`, `adGroupMaxContentCpc`, `adGroupMaxCpc`, `adGroupMaxCpm`, `adGroupSiteMaxCpc`, `adgroup`) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)]
2012-12-04 10:27:00.205 (4) [P1T1]: replicated 1370 rows to `st-tracker`.`tmp3`
2012-12-04 10:27:00.206 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1]
2012-12-04 10:27:00.206 (4) [P1T1]: spike: SQL->[select COUNT(*) from `st-tracker`.`tmp3` where ((`searchEngineUserID`="3177") and (`campaignid` in ("86452850","86453090","86453930","86454890","86452730","86453690","86453810","86453330","86455130","86453570","86454170","86454770","86454650","86452250","86454050","86453450","86452970","86454410","86452370","86454530","88317170","86452130","86455370","86455010","86453210","86452610","86454290","86452490","86455250","109102010","109102370","109102130","109562330","109562210")))]
2012-12-04 10:27:00.248 (5) [P1T1]: recordAsSubs("db", 42, "P1T1")
2012-12-04 10:27:00.248 (5) [P1T1]: addSub("db")
2012-12-04 10:27:00.249 (5) [P1T1]: ProfilerRec.end("db", true): ret=42
2012-12-04 10:27:00.249 (4) [P1T1]: time=0.042
2012-12-04 10:27:00.249 (4) [P1T1]: Query executed in 0.042s
2012-12-04 10:27:00.250 (5) [P1T1]: quoteValue(), nothing special about it=>[3], type=class java.lang.Integer
2012-12-04 10:27:00.250 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1]
2012-12-04 10:27:00.251 (4) [P1T1]: spike: SQL->[select `tsacommon`.`searchEngineAccounts`.`id` from `tsacommon`.`searchEngineAccounts` where ((`tsacommon`.`searchEngineAccounts`.`lastChecked` is null) and (`tsacommon`.`searchEngineAccounts`.`accountID`="898") and (`tsacommon`.`searchEngineAccounts`.`distributionID`=3))]
2012-12-04 10:27:00.252 (5) [P1T1]: recordAsSubs("db", 2, "P1T1")
2012-12-04 10:27:00.252 (5) [P1T1]: addSub("db")
2012-12-04 10:27:00.252 (5) [P1T1]: ProfilerRec.end("db", true): ret=2
2012-12-04 10:27:00.252 (4) [P1T1]: time=0.0020
2012-12-04 10:27:00.253 (4) [P1T1]: Query executed in 0.002s
2012-12-04 10:27:00.253 (3) [P1T1]: DETECTION OF CAMPAIGNS NEEDING FIRST SYNC COMPLETED
2012-12-04 10:27:00.256 (5) [P1T1]: quoteValue(), nothing special about it=>[3], type=class java.lang.Integer
2012-12-04 10:27:00.256 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1]
2012-12-04 10:27:00.257 (4) [P1T1]: spike: SQL->[select distinct `tsacommon`.`searchEngineAccounts`.`id` from `tsacommon`.`searchEngineAccounts` where ((`tsacommon`.`searchEngineAccounts`.`accountID`="898") and (`tsacommon`.`searchEngineAccounts`.`searchEngineUserID`="3177") and (`tsacommon`.`searchEngineAccounts`.`distributionID`=3))]
2012-12-04 10:27:00.266 (5) [P1T1]: recordAsSubs("db", 9, "P1T1")
2012-12-04 10:27:00.267 (5) [P1T1]: addSub("db")
2012-12-04 10:27:00.267 (5) [P1T1]: ProfilerRec.end("db", true): ret=9
2012-12-04 10:27:00.267 (4) [P1T1]: time=0.0090
2012-12-04 10:27:00.267 (4) [P1T1]: Query executed in 0.009s
2012-12-04 10:27:00.277 (5) [P1T1]: quoteValue(), nothing special about it=>[3], type=class java.lang.Integer
2012-12-04 10:27:00.278 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1]
2012-12-04 10:27:00.279 (4) [P1T1]: spike: SQL->[select distinct `tsacommon`.`searchEngineAccounts`.`id` from `logging`.`searchEngineAccountChanges` left join `tsacommon`.`searchEngineAccounts` on ((`logging`.`searchEngineAccountChanges`.`searchEngineAccountID`=`tsacommon`.`searchEngineAccounts`.`id`)) where ((`logging`.`searchEngineAccountChanges`.`searchEngineAccountID` in ("63540","63541","63542","63543","63544","63545","63546","63547","63548","63549","63550","63551","63552","63553","63554","63555","63556","63557","63558","63559","63560","63561","63562","63563","63564","63565","63566","63567","63568","69733","69735","69737","69752","69753")) and (`logging`.`searchEngineAccountChanges`.`changeTime`>`tsacommon`.`searchEngineAccounts`.`lastChecked`) and (((`logging`.`searchEngineAccountChanges`.`column`="networkType") or (`logging`.`searchEngineAccountChanges`.`column`="contentType") or (`logging`.`searchEngineAccountChanges`.`column`="biddingStrategy"))) and (`tsacommon`.`searchEngineAccounts`.`accountID`="898") and (`tsacommon`.`searchEngineAccounts`.`enabled`="true") and (`tsacommon`.`searchEngineAccounts`.`searchEngineStatus`="ok") and (`tsacommon`.`searchEngineAccounts`.`distributionID`=3))]
2012-12-04 10:27:00.359 (5) [P1T1]: recordAsSubs("db", 79, "P1T1")
2012-12-04 10:27:00.359 (5) [P1T1]: addSub("db")
2012-12-04 10:27:00.359 (5) [P1T1]: ProfilerRec.end("db", true): ret=79
2012-12-04 10:27:00.360 (4) [P1T1]: time=0.079
2012-12-04 10:27:00.360 (4) [P1T1]: Query executed in 0.079s
2012-12-04 10:27:00.360 (3) [P1T1]: DETECTION OF CAMPAIGNS WITH CONTENT/NETWORK CHANGES COMPLETED
2012-12-04 10:27:00.360 (3) [P1T1]: -- Account-level operations complete for seuser ((3177) "AT&T Pan Asian Youth Campaign") and seAccount(898)
2012-12-04 10:27:00.371 (5) [P1T1]: quoteValue(), nothing special about it=>[3177], type=class java.lang.Integer
2012-12-04 10:27:00.377 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1]
2012-12-04 10:27:00.378 (4) [P1T1]: spike: SQL->[create temporary table `tmp`.`tmp4` engine=myisam character set latin1 collate latin1_swedish_ci select `tsacommon`.`searchEngineAccounts`.`searchEngineUserID` AS `a_searchEngineUserID`,`tsacommon`.`searchEngineAccounts`.`searchEngineIdentifier` AS `a_campaignid`,`st-tracker`.`searchEngineGroups`.`searchEngineIdentifier` AS `a_adgroupid`,`sources`.`searchEngineIdentifier` AS `a_keywordid`,`sources`.`cost`,`sources`.`type`,`sources`.`searchEngineIdentifier`,`sources`.`searchEngineGroupIdentifier`,`sourceBidType`.`bidTypeID` from `tsacommon`.`searchEngineAccounts` join `st-tracker`.`searchEngineGroups` on ((`st-tracker`.`searchEngineGroups`.`searchEngineAccountID`=`tsacommon`.`searchEngineAccounts`.`id`)) join `st-tracker`.`sources` on (((((`st-tracker`.`searchEngineGroups`.`searchEngineAccountID`=`sources`.`searchEngineAccountID`)) and ((`sources`.`searchEngineGroupID`=`st-tracker`.`searchEngineGroups`.`id`))))) join `st-tracker`.`sourceBidType` on ((`sourceBidType`.`sourceID`=`sources`.`id`)) where ((`searchEngineUserID`=3177) and (`isBiddable`="true") and (`sources`.`searchEngineStatus` in ("ok","disabled")) and (`tsacommon`.`searchEngineAccounts`.`searchEngineStatus` in ("ok","disabled")) and (`st-tracker`.`searchEngineGroups`.`searchEngineStatus` in ("ok","disabled")) and (`type` in (1,9)))]
2012-12-04 10:27:03.806 (4) [ConnectionCloser]: 4 DatabasePools remaining : 0 pending closure
2012-12-04 10:27:33.813 (4) [ConnectionCloser]: 2 DatabasePools remaining : 0 pending closure
2012-12-04 10:28:03.831 (4) [ConnectionCloser]: 2 DatabasePools remaining : 0 pending closure
2012-12-04 10:28:33.852 (4) [ConnectionCloser]: 2 DatabasePools remaining : 0 pending closure
2012-12-04 10:29:03.859 (4) [ConnectionCloser]: 0 DatabasePools remaining : 0 pending closure
2012-12-04 10:29:03.859 (4) [ConnectionCloser]: Stopping DatabasePool ConnectionCloserThread
2012-12-04 10:33:45.547 (5) [P1T1]: recordAsSubs("db", 405169, "P1T1")
2012-12-04 10:33:45.548 (5) [P1T1]: addSub("db")
2012-12-04 10:33:45.548 (5) [P1T1]: ProfilerRec.end("db", true): ret=405169
2012-12-04 10:33:45.548 (4) [P1T1]: time=405.169
2012-12-04 10:33:45.549 (4) [P1T1]: Query executed in 6m 45.169s
2012-12-04 10:33:45.549 (5) [P1T1]: SQL execute() returned false
2012-12-04 10:33:45.549 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1]
2012-12-04 10:33:45.549 (4) [P1T1]: spike: SQL->[ALTER TABLE `tmp`.`tmp4` modify a_searchEngineUserID int(11) NOT NULL default '0', modify a_campaignid int(11) NOT NULL default '0', modify a_adgroupid bigint(20) NOT NULL default '0', modify a_keywordid bigint(20) NOT NULL default '0', ADD INDEX joinIndex (a_searchEngineUserID, a_campaignid, a_adgroupid, a_keywordid)]
2012-12-04 10:33:45.583 (5) [P1T1]: recordAsSubs("db", 34, "P1T1")
2012-12-04 10:33:45.583 (5) [P1T1]: addSub("db")
2012-12-04 10:33:45.583 (5) [P1T1]: ProfilerRec.end("db", true): ret=34
2012-12-04 10:33:45.584 (4) [P1T1]: time=0.034
2012-12-04 10:33:45.584 (4) [P1T1]: Query executed in 0.034s
2012-12-04 10:33:45.584 (5) [P1T1]: SQL execute() returned false
2012-12-04 10:33:45.586 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1]
2012-12-04 10:33:45.586 (4) [P1T1]: spike: SQL->[select COUNT(*) from `st-tracker`.`tmp3` where ((`searchEngineUserID`="3177") and (`campaignid` in ("86452850","86453090","86453930","86454890","86452730","86453690","86453810","86453330","86455130","86453570","86454170","86454770","86454650","86452250","86454050","86453450","86452970","86454410","86452370","86454530","88317170","86452130","86455370","86455010","86453210","86452610","86454290","86452490","86455250","109102010","109102370","109102130","109562330","109562210")))]
2012-12-04 10:33:45.593 (5) [P1T1]: recordAsSubs("db", 7, "P1T1")
2012-12-04 10:33:45.593 (5) [P1T1]: addSub("db")
2012-12-04 10:33:45.593 (5) [P1T1]: ProfilerRec.end("db", true): ret=7
2012-12-04 10:33:45.594 (4) [P1T1]: time=0.0070
2012-12-04 10:33:45.594 (4) [P1T1]: Query executed in 0.007s
2012-12-04 10:33:45.594 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1]
2012-12-04 10:33:45.594 (4) [P1T1]: spike: SQL->[select * from `st-tracker`.`tmp3` where ((`searchEngineUserID`="3177") and (`campaignid` in ("86452850","86453090","86453930","86454890","86452730","86453690","86453810","86453330","86455130","86453570","86454170","86454770","86454650","86452250","86454050","86453450","86452970","86454410","86452370","86454530","88317170","86452130","86455370","86455010","86453210","86452610","86454290","86452490","86455250","109102010","109102370","109102130","109562330","109562210"))) limit 0, 10000]
2012-12-04 10:33:46.240 (5) [P1T1]: recordAsSubs("db", 646, "P1T1")
2012-12-04 10:33:46.240 (5) [P1T1]: addSub("db")
2012-12-04 10:33:46.240 (5) [P1T1]: ProfilerRec.end("db", true): ret=646
2012-12-04 10:33:46.241 (4) [P1T1]: time=0.646
2012-12-04 10:33:46.241 (4) [P1T1]: Query executed in 0.646s
2012-12-04 10:33:46.243 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1]
2012-12-04 10:33:46.243 (4) [P1T1]: spike: SQL->[select `st-tracker`.`tmp3`.campaignid,`st-tracker`.`tmp3`.adgroupid,`st-tracker`.`tmp3`.keywordid,`st-tracker`.`tmp3`.kwType,`st-tracker`.`tmp3`.maxCpc,`st-tracker`.`tmp3`.maxCpm,`st-tracker`.`tmp3`.maxContentCpc,`tmp`.`tmp4`.cost,`tmp`.`tmp4`.type,`tmp`.`tmp4`.bidTypeID,`tmp`.`tmp4`.searchEngineIdentifier,`tmp`.`tmp4`.searchEngineGroupIdentifier from `st-tracker`.`tmp3` inner join `tmp`.`tmp4` on (((`tmp`.`tmp4`.a_searchEngineUserID=`st-tracker`.`tmp3`.`searchEngineUserID`) and (`tmp`.`tmp4`.a_campaignid=`st-tracker`.`tmp3`.`campaignid`) and (`tmp`.`tmp4`.a_adgroupid=`st-tracker`.`tmp3`.`adgroupid`) and (`tmp`.`tmp4`.a_keywordid=`st-tracker`.`tmp3`.`keywordid`))) where ((`st-tracker`.`tmp3`.`kwisnegative`="false") and (`st-tracker`.`tmp3`.`agStatus`="ENABLED"))]
2012-12-04 10:33:46.387 (5) [P1T1]: recordAsSubs("db", 144, "P1T1")
2012-12-04 10:33:46.388 (5) [P1T1]: addSub("db")
2012-12-04 10:33:46.388 (5) [P1T1]: ProfilerRec.end("db", true): ret=144
2012-12-04 10:33:46.388 (4) [P1T1]: time=0.144
2012-12-04 10:33:46.388 (4) [P1T1]: Query executed in 0.144s
2012-12-04 10:33:49.379 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1]
2012-12-04 10:33:49.380 (4) [P1T1]: spike: SQL->[delete from `st-tracker`.`tmp3` where ((`searchEngineUserID`="3177") and (`campaignid` in ("86452850","86453090","86453930","86454890","86452730","86453690","86453810","86453330","86455130","86453570","86454170","86454770","86454650","86452250","86454050","86453450","86452970","86454410","86452370","86454530","88317170","86452130","86455370","86455010","86453210","86452610","86454290","86452490","86455250","109102010","109102370","109102130","109562330","109562210")))], genflags=no
2012-12-04 10:33:49.525 (5) [P1T1]: recordAsSubs("db", 145, "P1T1")
2012-12-04 10:33:49.526 (5) [P1T1]: addSub("db")
2012-12-04 10:33:49.526 (5) [P1T1]: ProfilerRec.end("db", true): ret=145
2012-12-04 10:33:49.526 (4) [P1T1]: time=0.145
2012-12-04 10:33:49.526 (4) [P1T1]: Query executed in 0.145s, 11370 row(s) affected
2012-12-04 10:33:49.527 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1]
2012-12-04 10:33:49.527 (4) [P1T1]: spike: SQL->[select * from `st-tracker`.`tmp3` where ((`searchEngineUserID`="3177") and (`campaignid` in ("86452850","86453090","86453930","86454890","86452730","86453690","86453810","86453330","86455130","86453570","86454170","86454770","86454650","86452250","86454050","86453450","86452970","86454410","86452370","86454530","88317170","86452130","86455370","86455010","86453210","86452610","86454290","86452490","86455250","109102010","109102370","109102130","109562330","109562210"))) limit 10000, 10000]
2012-12-04 10:33:49.904 (5) [P1T1]: recordAsSubs("db", 377, "P1T1")
2012-12-04 10:33:49.905 (5) [P1T1]: addSub("db")
2012-12-04 10:33:49.905 (5) [P1T1]: ProfilerRec.end("db", true): ret=377
2012-12-04 10:33:49.905 (4) [P1T1]: time=0.377
2012-12-04 10:33:49.905 (4) [P1T1]: Query executed in 0.377s
2012-12-04 10:33:49.906 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1]
2012-12-04 10:33:49.906 (4) [P1T1]: spike: SQL->[select `st-tracker`.`tmp3`.campaignid,`st-tracker`.`tmp3`.adgroupid,`st-tracker`.`tmp3`.keywordid,`st-tracker`.`tmp3`.kwType,`st-tracker`.`tmp3`.maxCpc,`st-tracker`.`tmp3`.maxCpm,`st-tracker`.`tmp3`.maxContentCpc,`tmp`.`tmp4`.cost,`tmp`.`tmp4`.type,`tmp`.`tmp4`.bidTypeID,`tmp`.`tmp4`.searchEngineIdentifier,`tmp`.`tmp4`.searchEngineGroupIdentifier from `st-tracker`.`tmp3` inner join `tmp`.`tmp4` on (((`tmp`.`tmp4`.a_searchEngineUserID=`st-tracker`.`tmp3`.`searchEngineUserID`) and (`tmp`.`tmp4`.a_campaignid=`st-tracker`.`tmp3`.`campaignid`) and (`tmp`.`tmp4`.a_adgroupid=`st-tracker`.`tmp3`.`adgroupid`) and (`tmp`.`tmp4`.a_keywordid=`st-tracker`.`tmp3`.`keywordid`))) where ((`st-tracker`.`tmp3`.`kwisnegative`="false") and (`st-tracker`.`tmp3`.`agStatus`="ENABLED"))]
2012-12-04 10:33:49.907 (5) [P1T1]: recordAsSubs("db", 1, "P1T1")
2012-12-04 10:33:49.908 (5) [P1T1]: addSub("db")
2012-12-04 10:33:49.908 (5) [P1T1]: ProfilerRec.end("db", true): ret=1
2012-12-04 10:33:49.908 (4) [P1T1]: time=0.0010
2012-12-04 10:33:49.908 (4) [P1T1]: Query executed in 0.001s
2012-12-04 10:33:49.908 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1]
2012-12-04 10:33:49.908 (4) [P1T1]: spike: SQL->[delete from `st-tracker`.`tmp3` where ((`searchEngineUserID`="3177") and (`campaignid` in ("86452850","86453090","86453930","86454890","86452730","86453690","86453810","86453330","86455130","86453570","86454170","86454770","86454650","86452250","86454050","86453450","86452970","86454410","86452370","86454530","88317170","86452130","86455370","86455010","86453210","86452610","86454290","86452490","86455250","109102010","109102370","109102130","109562330","109562210")))], genflags=no
2012-12-04 10:33:49.909 (5) [P1T1]: recordAsSubs("db", 1, "P1T1")
2012-12-04 10:33:49.909 (5) [P1T1]: addSub("db")
2012-12-04 10:33:49.909 (5) [P1T1]: ProfilerRec.end("db", true): ret=1
2012-12-04 10:33:49.910 (4) [P1T1]: time=0.0010
2012-12-04 10:33:49.910 (4) [P1T1]: Query executed in 0.001s, 0 row(s) affected
2012-12-04 10:33:49.910 (3) [P1T1]: Keyword-level bidType changes: 0
2012-12-04 10:33:49.910 (3) [P1T1]: Keyword-level bidAmount changes: 0
2012-12-04 10:33:49.910 (3) [P1T1]: COMPLETED KEYWORD-LEVEL BID DETECTION FOR: seUser (3177) and seAccount(898)
2012-12-04 10:33:49.912 (5) [P1T1]: quoteValue(), nothing special about it=>[3177], type=class java.lang.Integer
2012-12-04 10:33:49.913 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1]
2012-12-04 10:33:49.913 (4) [P1T1]: spike: SQL->[create temporary table `tmp`.`tmp5` engine=myisam character set latin1 collate latin1_swedish_ci select `tsacommon`.`searchEngineAccounts`.`searchEngineUserID` AS `a_searchEngineUserID`,`tsacommon`.`searchEngineAccounts`.`searchEngineIdentifier` AS `a_campaignid`,`st-tracker`.`searchEngineGroups`.`searchEngineIdentifier` AS `a_adgroupid`,`sources`.`searchEngineIdentifier` AS `a_keywordid`,`sources`.`cost`,`sources`.`type`,`sources`.`searchEngineIdentifier`,`sources`.`searchEngineGroupIdentifier`,`sourceBidType`.`bidTypeID` from `tsacommon`.`searchEngineAccounts` join `st-tracker`.`searchEngineGroups` on ((`st-tracker`.`searchEngineGroups`.`searchEngineAccountID`=`tsacommon`.`searchEngineAccounts`.`id`)) join `st-tracker`.`sources` on (((((`st-tracker`.`searchEngineGroups`.`searchEngineAccountID`=`sources`.`searchEngineAccountID`)) and ((`sources`.`searchEngineGroupID`=`st-tracker`.`searchEngineGroups`.`id`))))) join `st-tracker`.`sourceBidType` on ((`sourceBidType`.`sourceID`=`sources`.`id`)) where ((`searchEngineUserID`=3177) and (`isBiddable`="true") and (`type` in (7)))]
2012-12-04 10:39:42.886 (5) [P1T1]: recordAsSubs("db", 352973, "P1T1")
2012-12-04 10:39:42.887 (5) [P1T1]: addSub("db")
2012-12-04 10:39:42.887 (5) [P1T1]: ProfilerRec.end("db", true): ret=352973
2012-12-04 10:39:42.887 (4) [P1T1]: time=352.973
2012-12-04 10:39:42.887 (4) [P1T1]: Query executed in 5m 52.973s
2012-12-04 10:39:42.887 (5) [P1T1]: SQL execute() returned false
2012-12-04 10:39:42.887 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1]
2012-12-04 10:39:42.888 (4) [P1T1]: spike: SQL->[ALTER TABLE `tmp`.`tmp5` modify a_searchEngineUserID int(11) NOT NULL default '0', modify a_campaignid int(11) NOT NULL default '0', modify a_adgroupid bigint(20) NOT NULL default '0', ADD INDEX joinIndex (a_searchEngineUserID, a_campaignid, a_adgroupid)]
2012-12-04 10:39:42.890 (5) [P1T1]: recordAsSubs("db", 2, "P1T1")
2012-12-04 10:39:42.891 (5) [P1T1]: addSub("db")
2012-12-04 10:39:42.891 (5) [P1T1]: ProfilerRec.end("db", true): ret=2
2012-12-04 10:39:42.891 (4) [P1T1]: time=0.0020
2012-12-04 10:39:42.891 (4) [P1T1]: Query executed in 0.002s
2012-12-04 10:39:42.891 (5) [P1T1]: SQL execute() returned false
2012-12-04 10:39:42.893 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1]
2012-12-04 10:39:42.893 (4) [P1T1]: spike: SQL->[select COUNT(*) from `st-tracker`.`tmp3` where ((`searchEngineUserID`="3177") and (`campaignid` in ("86452850","86453090","86453930","86454890","86452730","86453690","86453810","86453330","86455130","86453570","86454170","86454770","86454650","86452250","86454050","86453450","86452970","86454410","86452370","86454530","88317170","86452130","86455370","86455010","86453210","86452610","86454290","86452490","86455250","109102010","109102370","109102130","109562330","109562210")))]
2012-12-04 10:39:42.894 (5) [P1T1]: recordAsSubs("db", 1, "P1T1")
2012-12-04 10:39:42.894 (5) [P1T1]: addSub("db")
2012-12-04 10:39:42.894 (5) [P1T1]: ProfilerRec.end("db", true): ret=1
2012-12-04 10:39:42.894 (4) [P1T1]: time=0.0010
2012-12-04 10:39:42.894 (4) [P1T1]: Query executed in 0.001s
2012-12-04 10:39:42.894 (3) [P1T1]: Adgroup-level bidType changes: 0
2012-12-04 10:39:42.894 (3) [P1T1]: Adgroup-level bidAmount changes: 0
2012-12-04 10:39:42.895 (3) [P1T1]: COMPLETED ADGROUP-LEVEL BID DETECTION FOR: seUser (3177) and seAccount(898)
2012-12-04 10:39:42.895 (3) [P1T1]: -- Bid amount difference checks complete for seuser ((3177) "AT&T Pan Asian Youth Campaign") and seAccount(898)
2012-12-04 10:39:42.895 (3) [P1T1]: -- No out of sync seaccts found for se user: (3177) "AT&T Pan Asian Youth Campaign"
2012-12-04 10:39:42.895 (4) [P1T1]: spike: SQL->[commit]
2012-12-04 10:39:42.895 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1]
2012-12-04 10:39:42.896 (5) [P1T1]: recordAsSubs("db", 1, "P1T1")
2012-12-04 10:39:42.896 (5) [P1T1]: addSub("db")
2012-12-04 10:39:42.896 (5) [P1T1]: ProfilerRec.end("db", true): ret=1
2012-12-04 10:39:42.896 (4) [P1T1]: time=0.0010
2012-12-04 10:39:42.896 (4) [P1T1]: Query executed in 0.001s
2012-12-04 10:39:42.897 (4) [P1T1]: DB AutoCommit -> true
2012-12-04 10:39:42.897 (4) [P1T1]: DB IsolationLevel -> 4
2012-12-04 10:39:42.897 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1]
2012-12-04 10:39:42.897 (4) [P1T1]: spike: SQL->[SELECT RELEASE_LOCK('com.thesearchagency.searchengines.google.GoogleStructureSync.searchEngineUserID.3177')]
2012-12-04 10:39:42.898 (5) [P1T1]: recordAsSubs("db", 1, "P1T1")
2012-12-04 10:39:42.898 (5) [P1T1]: addSub("db")
2012-12-04 10:39:42.898 (5) [P1T1]: ProfilerRec.end("db", true): ret=1
2012-12-04 10:39:42.898 (4) [P1T1]: time=0.0010
2012-12-04 10:39:42.899 (4) [P1T1]: Query executed in 0.001s
2012-12-04 10:39:42.899 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1]
2012-12-04 10:39:42.899 (4) [P1T1]: spike: SQL->[drop table `tmp`.`tmp1`]
2012-12-04 10:39:42.903 (5) [P1T1]: recordAsSubs("db", 4, "P1T1")
2012-12-04 10:39:42.903 (5) [P1T1]: addSub("db")
2012-12-04 10:39:42.903 (5) [P1T1]: ProfilerRec.end("db", true): ret=4
2012-12-04 10:39:42.903 (4) [P1T1]: time=0.0040
2012-12-04 10:39:42.903 (4) [P1T1]: Query executed in 0.004s
2012-12-04 10:39:42.903 (5) [P1T1]: SQL execute() returned false
2012-12-04 10:39:42.907 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1]
2012-12-04 10:39:42.908 (4) [P1T1]: spike: SQL->[drop table `tmp`.`tmp2`]
2012-12-04 10:39:42.913 (5) [P1T1]: recordAsSubs("db", 6, "P1T1")
2012-12-04 10:39:42.913 (5) [P1T1]: addSub("db")
2012-12-04 10:39:42.913 (5) [P1T1]: ProfilerRec.end("db", true): ret=6
2012-12-04 10:39:42.913 (4) [P1T1]: time=0.0060
2012-12-04 10:39:42.914 (4) [P1T1]: Query executed in 0.006s
2012-12-04 10:39:42.914 (5) [P1T1]: SQL execute() returned false
2012-12-04 10:39:42.914 (3) [P1T1]: -- Keyword/Creative difference checks complete for seuser ((3177) "AT&T Pan Asian Youth Campaign")
2012-12-04 10:39:42.914 (3) [P1T1]: SE Acct Id Set size :: 0
2012-12-04 10:39:42.915 (4) [P1T1]: Returning Object to Pool
2012-12-04 10:39:42.915 (4) [ConnectionCloser]: Starting DatabasePool ConnectionCloserThread
2012-12-04 10:39:42.916 (4) [P1T1]: Returning Object to Pool
2012-12-04 10:39:42.916 (4) [P1T1]: Returning Object to Pool
2012-12-04 10:39:42.917 (4) [P1T1]: Returning Object to Pool
2012-12-04 10:39:58.297 (4) [main]: closed [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false]
2012-12-04 10:39:58.298 (3) [main]: ------------SearchEngineSyncUserWorker done
2012-12-04 10:39:58.298 (3) [main]: No accounts to sync.
2012-12-04 10:39:58.302 (5) [main]: ProfilerRec.start("db",true) in Thread [main]
2012-12-04 10:39:58.303 (4) [main]: spike: SQL->[select * from `tsacommon`.`searchEngineAccounts` inner join `tsacommon`.`searchEngineUsers` on (((`tsacommon`.`searchEngineAccounts`.`searchEngineUserID`=`tsacommon`.`searchEngineUsers`.`id`))) inner join `tsacommon`.`accounts` on ((`tsacommon`.`accounts`.`id`=`tsacommon`.`searchEngineAccounts`.`accountID`)) where (((((`tsacommon`.`searchEngineAccounts`.`enabled`="true") and (((`tsacommon`.`searchEngineAccounts`.`searchEngineStatus`="ok") or (((`tsacommon`.`searchEngineAccounts`.`searchEngineStatus`="disabled") and (`tsacommon`.`searchEngineAccounts`.`paused`="true"))))) and (`tsacommon`.`searchEngineAccounts`.`accountID` in (898)) and (`tsacommon`.`searchEngineAccounts`.`distributionID`="3"))) and (((`tsacommon`.`searchEngineUsers`.`enabled`="true"))))) order by `tsacommon`.`accounts`.`tier` asc,`tsacommon`.`accounts`.`priority` asc,`tsacommon`.`accounts`.`id` desc,`tsacommon`.`searchEngineAccounts`.`lastChecked` asc]
2012-12-04 10:39:58.307 (5) [main]: recordAsSubs("db", 4, "main")
2012-12-04 10:39:58.308 (5) [main]: addSub("db")
2012-12-04 10:39:58.308 (5) [main]: ProfilerRec.end("db", true): ret=4
2012-12-04 10:39:58.308 (4) [main]: time=0.0040
2012-12-04 10:39:58.309 (4) [main]: Query executed in 0.004s
2012-12-04 10:39:58.311 (5) [main]: loading 56 columns from result set:
2012-12-04 10:39:58.312 (5) [main]: 	loaded column: searchEngineAccounts.id->69735
2012-12-04 10:39:58.312 (5) [main]: 	loaded column: searchEngineAccounts.accountID->898
2012-12-04 10:39:58.312 (5) [main]: 	loaded column: searchEngineAccounts.distributionID->3
2012-12-04 10:39:58.312 (5) [main]: 	loaded column: searchEngineAccounts.searchEngineUserID->3177
2012-12-04 10:39:58.313 (5) [main]: 	loaded column: searchEngineAccounts.description->ATT-WIC|Youtube Overlay|Contextual-Desktop
2012-12-04 10:39:58.313 (5) [main]: 	loaded column: searchEngineAccounts.shortCode->null
2012-12-04 10:39:58.313 (5) [main]: 	loaded column: searchEngineAccounts.paused->false
2012-12-04 10:39:58.313 (5) [main]: 	loaded column: searchEngineAccounts.searchEngineIdentifier->109102370
2012-12-04 10:39:58.313 (5) [main]: 	loaded column: searchEngineAccounts.searchEngineScope->
2012-12-04 10:39:58.313 (5) [main]: 	loaded column: searchEngineAccounts.inContent->true
2012-12-04 10:39:58.313 (5) [main]: 	loaded column: searchEngineAccounts.enabled->true
2012-12-04 10:39:58.314 (5) [main]: 	loaded column: searchEngineAccounts.useConversionData->false
2012-12-04 10:39:58.314 (5) [main]: 	loaded column: searchEngineAccounts.searchEngineStatus->ok
2012-12-04 10:39:58.314 (5) [main]: 	loaded column: searchEngineAccounts.searchEngineStatusText->SERVING
2012-12-04 10:39:58.314 (5) [main]: 	loaded column: searchEngineAccounts.budgetType->dailyDivide
2012-12-04 10:39:58.315 (5) [main]: 	loaded column: searchEngineAccounts.budgetAmount->150.0
2012-12-04 10:39:58.316 (5) [main]: 	loaded column: searchEngineAccounts.lastChecked->2012-12-03 15:46:14.0
2012-12-04 10:39:58.316 (5) [main]: 	loaded column: searchEngineAccounts.networkType->CONTENT_NETWORK
2012-12-04 10:39:58.316 (5) [main]: 	loaded column: searchEngineAccounts.contentType->CONTENT_NETWORK
2012-12-04 10:39:58.316 (5) [main]: 	loaded column: searchEngineAccounts.biddingStrategy->ManualCPC
2012-12-04 10:39:58.316 (5) [main]: 	loaded column: searchEngineAccounts.hidden->false
2012-12-04 10:39:58.316 (5) [main]: 	skipping invalid column: searchEngineUsers.id
2012-12-04 10:39:58.316 (5) [main]: 	skipping invalid column: searchEngineUsers.accountID
2012-12-04 10:39:58.317 (5) [main]: 	skipping invalid column: searchEngineUsers.distributionID
2012-12-04 10:39:58.317 (5) [main]: 	skipping invalid column: searchEngineUsers.searchEngineIdentifier
2012-12-04 10:39:58.317 (5) [main]: 	skipping invalid column: searchEngineUsers.description
2012-12-04 10:39:58.317 (5) [main]: 	skipping invalid column: searchEngineUsers.username
2012-12-04 10:39:58.317 (5) [main]: 	skipping invalid column: searchEngineUsers.password
2012-12-04 10:39:58.317 (5) [main]: 	skipping invalid column: searchEngineUsers.enabled
2012-12-04 10:39:58.317 (5) [main]: 	skipping invalid column: searchEngineUsers.inTsaMcc
2012-12-04 10:39:58.317 (5) [main]: 	skipping invalid column: searchEngineUsers.apiKey
2012-12-04 10:39:58.317 (5) [main]: 	skipping invalid column: searchEngineUsers.managerUsernames
2012-12-04 10:39:58.318 (5) [main]: 	skipping invalid column: searchEngineUsers.managerIDs
2012-12-04 10:39:58.318 (5) [main]: 	skipping invalid column: searchEngineUsers.lastChecked
2012-12-04 10:39:58.318 (5) [main]: 	skipping invalid column: searchEngineUsers.lastInMcc
2012-12-04 10:39:58.318 (5) [main]: 	skipping invalid column: searchEngineUsers.hidden
2012-12-04 10:39:58.318 (5) [main]: 	skipping invalid column: accounts.id
2012-12-04 10:39:58.318 (5) [main]: 	skipping invalid column: accounts.description
2012-12-04 10:39:58.318 (5) [main]: 	skipping invalid column: accounts.tier
2012-12-04 10:39:58.318 (5) [main]: 	skipping invalid column: accounts.priority
2012-12-04 10:39:58.318 (5) [main]: 	skipping invalid column: accounts.reportClicksOut
2012-12-04 10:39:58.318 (5) [main]: 	skipping invalid column: accounts.reportConversions
2012-12-04 10:39:58.319 (5) [main]: 	skipping invalid column: accounts.conversionTypes
2012-12-04 10:39:58.319 (5) [main]: 	skipping invalid column: accounts.isBidManaged
2012-12-04 10:39:58.319 (5) [main]: 	skipping invalid column: accounts.isActive
2012-12-04 10:39:58.319 (5) [main]: 	skipping invalid column: accounts.perfMetric
2012-12-04 10:39:58.319 (5) [main]: 	skipping invalid column: accounts.providesConversionData
2012-12-04 10:39:58.319 (5) [main]: 	skipping invalid column: accounts.addConversionData
2012-12-04 10:39:58.319 (5) [main]: 	skipping invalid column: accounts.fractionalConversionCounts
2012-12-04 10:39:58.319 (5) [main]: 	skipping invalid column: accounts.hideNullSources
2012-12-04 10:39:58.320 (5) [main]: 	skipping invalid column: accounts.nowTime
2012-12-04 10:39:58.320 (5) [main]: 	skipping invalid column: accounts.warehouseDatabase
2012-12-04 10:39:58.320 (5) [main]: 	skipping invalid column: accounts.databaseInstance
2012-12-04 10:39:58.320 (5) [main]: 	skipping invalid column: accounts.warehouseInstance
2012-12-04 10:39:58.320 (5) [main]: 	skipping invalid column: accounts.isOnline
2012-12-04 10:39:58.320 (5) [main]: 	skipping invalid column: accounts.timeZoneID
2012-12-04 10:39:58.320 (5) [main]: loading 56 columns from result set:
2012-12-04 10:39:58.320 (5) [main]: 	skipping invalid column: searchEngineAccounts.id
2012-12-04 10:39:58.320 (5) [main]: 	skipping invalid column: searchEngineAccounts.accountID
2012-12-04 10:39:58.321 (5) [main]: 	skipping invalid column: searchEngineAccounts.distributionID
2012-12-04 10:39:58.321 (5) [main]: 	skipping invalid column: searchEngineAccounts.searchEngineUserID
2012-12-04 10:39:58.321 (5) [main]: 	skipping invalid column: searchEngineAccounts.description
2012-12-04 10:39:58.321 (5) [main]: 	skipping invalid column: searchEngineAccounts.shortCode
2012-12-04 10:39:58.321 (5) [main]: 	skipping invalid column: searchEngineAccounts.paused
2012-12-04 10:39:58.321 (5) [main]: 	skipping invalid column: searchEngineAccounts.searchEngineIdentifier
2012-12-04 10:39:58.321 (5) [main]: 	skipping invalid column: searchEngineAccounts.searchEngineScope
2012-12-04 10:39:58.321 (5) [main]: 	skipping invalid column: searchEngineAccounts.inContent
2012-12-04 10:39:58.321 (5) [main]: 	skipping invalid column: searchEngineAccounts.enabled
2012-12-04 10:39:58.321 (5) [main]: 	skipping invalid column: searchEngineAccounts.useConversionData
2012-12-04 10:39:58.322 (5) [main]: 	skipping invalid column: searchEngineAccounts.searchEngineStatus
2012-12-04 10:39:58.322 (5) [main]: 	skipping invalid column: searchEngineAccounts.searchEngineStatusText
2012-12-04 10:39:58.322 (5) [main]: 	skipping invalid column: searchEngineAccounts.budgetType
2012-12-04 10:39:58.322 (5) [main]: 	skipping invalid column: searchEngineAccounts.budgetAmount
2012-12-04 10:39:58.322 (5) [main]: 	skipping invalid column: searchEngineAccounts.lastChecked
2012-12-04 10:39:58.322 (5) [main]: 	skipping invalid column: searchEngineAccounts.networkType
2012-12-04 10:39:58.322 (5) [main]: 	skipping invalid column: searchEngineAccounts.contentType
2012-12-04 10:39:58.322 (5) [main]: 	skipping invalid column: searchEngineAccounts.biddingStrategy
2012-12-04 10:39:58.322 (5) [main]: 	skipping invalid column: searchEngineAccounts.hidden
2012-12-04 10:39:58.323 (5) [main]: 	loaded column: searchEngineUsers.id->3177
2012-12-04 10:39:58.324 (5) [main]: 	loaded column: searchEngineUsers.accountID->898
2012-12-04 10:39:58.324 (5) [main]: 	loaded column: searchEngineUsers.distributionID->3
2012-12-04 10:39:58.324 (5) [main]: 	loaded column: searchEngineUsers.searchEngineIdentifier->9001082081
2012-12-04 10:39:58.324 (5) [main]: 	loaded column: searchEngineUsers.description->AT&T Pan Asian Youth Campaign
2012-12-04 10:39:58.324 (5) [main]: 	loaded column: searchEngineUsers.username->
2012-12-04 10:39:58.324 (5) [main]: 	loaded column: searchEngineUsers.password->
2012-12-04 10:39:58.324 (5) [main]: 	loaded column: searchEngineUsers.enabled->true
2012-12-04 10:39:58.324 (5) [main]: 	loaded column: searchEngineUsers.inTsaMcc->true
2012-12-04 10:39:58.324 (5) [main]: 	loaded column: searchEngineUsers.apiKey->
2012-12-04 10:39:58.325 (5) [main]: 	loaded column: searchEngineUsers.managerUsernames->null
2012-12-04 10:39:58.325 (5) [main]: 	loaded column: searchEngineUsers.managerIDs->1752475908,9136835500,9050076625
2012-12-04 10:39:58.325 (5) [main]: 	loaded column: searchEngineUsers.lastChecked->2012-12-04 09:52:27.0
2012-12-04 10:39:58.325 (5) [main]: 	loaded column: searchEngineUsers.lastInMcc->2012-12-04 08:20:17.0
2012-12-04 10:39:58.325 (5) [main]: 	skipping invalid column: searchEngineUsers.hidden
2012-12-04 10:39:58.326 (5) [main]: 	skipping invalid column: accounts.id
2012-12-04 10:39:58.326 (5) [main]: 	skipping invalid column: accounts.description
2012-12-04 10:39:58.326 (5) [main]: 	skipping invalid column: accounts.tier
2012-12-04 10:39:58.326 (5) [main]: 	skipping invalid column: accounts.priority
2012-12-04 10:39:58.326 (5) [main]: 	skipping invalid column: accounts.reportClicksOut
2012-12-04 10:39:58.326 (5) [main]: 	skipping invalid column: accounts.reportConversions
2012-12-04 10:39:58.326 (5) [main]: 	skipping invalid column: accounts.conversionTypes
2012-12-04 10:39:58.326 (5) [main]: 	skipping invalid column: accounts.isBidManaged
2012-12-04 10:39:58.326 (5) [main]: 	skipping invalid column: accounts.isActive
2012-12-04 10:39:58.326 (5) [main]: 	skipping invalid column: accounts.perfMetric
2012-12-04 10:39:58.327 (5) [main]: 	skipping invalid column: accounts.providesConversionData
2012-12-04 10:39:58.327 (5) [main]: 	skipping invalid column: accounts.addConversionData
2012-12-04 10:39:58.327 (5) [main]: 	skipping invalid column: accounts.fractionalConversionCounts
2012-12-04 10:39:58.327 (5) [main]: 	skipping invalid column: accounts.hideNullSources
2012-12-04 10:39:58.327 (5) [main]: 	skipping invalid column: accounts.nowTime
2012-12-04 10:39:58.327 (5) [main]: 	skipping invalid column: accounts.warehouseDatabase
2012-12-04 10:39:58.327 (5) [main]: 	skipping invalid column: accounts.databaseInstance
2012-12-04 10:39:58.327 (5) [main]: 	skipping invalid column: accounts.warehouseInstance
2012-12-04 10:39:58.327 (5) [main]: 	skipping invalid column: accounts.isOnline
2012-12-04 10:39:58.327 (5) [main]: 	skipping invalid column: accounts.timeZoneID
2012-12-04 10:39:58.328 (5) [main]: loading 56 columns from result set:
2012-12-04 10:39:58.328 (5) [main]: 	skipping invalid column: searchEngineAccounts.id
2012-12-04 10:39:58.328 (5) [main]: 	skipping invalid column: searchEngineAccounts.accountID
2012-12-04 10:39:58.328 (5) [main]: 	skipping invalid column: searchEngineAccounts.distributionID
2012-12-04 10:39:58.328 (5) [main]: 	skipping invalid column: searchEngineAccounts.searchEngineUserID
2012-12-04 10:39:58.328 (5) [main]: 	skipping invalid column: searchEngineAccounts.description
2012-12-04 10:39:58.328 (5) [main]: 	skipping invalid column: searchEngineAccounts.shortCode
2012-12-04 10:39:58.328 (5) [main]: 	skipping invalid column: searchEngineAccounts.paused
2012-12-04 10:39:58.328 (5) [main]: 	skipping invalid column: searchEngineAccounts.searchEngineIdentifier
2012-12-04 10:39:58.328 (5) [main]: 	skipping invalid column: searchEngineAccounts.searchEngineScope
2012-12-04 10:39:58.329 (5) [main]: 	skipping invalid column: searchEngineAccounts.inContent
2012-12-04 10:39:58.329 (5) [main]: 	skipping invalid column: searchEngineAccounts.enabled
2012-12-04 10:39:58.329 (5) [main]: 	skipping invalid column: searchEngineAccounts.useConversionData
2012-12-04 10:39:58.329 (5) [main]: 	skipping invalid column: searchEngineAccounts.searchEngineStatus
2012-12-04 10:39:58.329 (5) [main]: 	skipping invalid column: searchEngineAccounts.searchEngineStatusText
2012-12-04 10:39:58.329 (5) [main]: 	skipping invalid column: searchEngineAccounts.budgetType
2012-12-04 10:39:58.329 (5) [main]: 	skipping invalid column: searchEngineAccounts.budgetAmount
2012-12-04 10:39:58.329 (5) [main]: 	skipping invalid column: searchEngineAccounts.lastChecked
2012-12-04 10:39:58.329 (5) [main]: 	skipping invalid column: searchEngineAccounts.networkType
2012-12-04 10:39:58.329 (5) [main]: 	skipping invalid column: searchEngineAccounts.contentType
2012-12-04 10:39:58.330 (5) [main]: 	skipping invalid column: searchEngineAccounts.biddingStrategy
2012-12-04 10:39:58.330 (5) [main]: 	skipping invalid column: searchEngineAccounts.hidden
2012-12-04 10:39:58.330 (5) [main]: 	skipping invalid column: searchEngineUsers.id
2012-12-04 10:39:58.330 (5) [main]: 	skipping invalid column: searchEngineUsers.accountID
2012-12-04 10:39:58.330 (5) [main]: 	skipping invalid column: searchEngineUsers.distributionID
2012-12-04 10:39:58.330 (5) [main]: 	skipping invalid column: searchEngineUsers.searchEngineIdentifier
2012-12-04 10:39:58.330 (5) [main]: 	skipping invalid column: searchEngineUsers.description
2012-12-04 10:39:58.330 (5) [main]: 	skipping invalid column: searchEngineUsers.username
2012-12-04 10:39:58.330 (5) [main]: 	skipping invalid column: searchEngineUsers.password
2012-12-04 10:39:58.330 (5) [main]: 	skipping invalid column: searchEngineUsers.enabled
2012-12-04 10:39:58.331 (5) [main]: 	skipping invalid column: searchEngineUsers.inTsaMcc
2012-12-04 10:39:58.331 (5) [main]: 	skipping invalid column: searchEngineUsers.apiKey
2012-12-04 10:39:58.331 (5) [main]: 	skipping invalid column: searchEngineUsers.managerUsernames
2012-12-04 10:39:58.331 (5) [main]: 	skipping invalid column: searchEngineUsers.managerIDs
2012-12-04 10:39:58.331 (5) [main]: 	skipping invalid column: searchEngineUsers.lastChecked
2012-12-04 10:39:58.331 (5) [main]: 	skipping invalid column: searchEngineUsers.lastInMcc
2012-12-04 10:39:58.331 (5) [main]: 	skipping invalid column: searchEngineUsers.hidden
2012-12-04 10:39:58.331 (5) [main]: 	loaded column: accounts.id->898
2012-12-04 10:39:58.331 (5) [main]: 	loaded column: accounts.description->Rezonate - AT&T
2012-12-04 10:39:58.332 (5) [main]: 	loaded column: accounts.tier->2
2012-12-04 10:39:58.332 (5) [main]: 	loaded column: accounts.priority->50
2012-12-04 10:39:58.332 (5) [main]: 	loaded column: accounts.reportClicksOut->false
2012-12-04 10:39:58.332 (5) [main]: 	loaded column: accounts.reportConversions->false
2012-12-04 10:39:58.332 (5) [main]: 	loaded column: accounts.conversionTypes->
2012-12-04 10:39:58.332 (5) [main]: 	loaded column: accounts.isBidManaged->true
2012-12-04 10:39:58.332 (5) [main]: 	loaded column: accounts.isActive->true
2012-12-04 10:39:58.333 (5) [main]: 	loaded column: accounts.perfMetric->cpa
2012-12-04 10:39:58.333 (5) [main]: 	loaded column: accounts.providesConversionData->false
2012-12-04 10:39:58.333 (5) [main]: 	loaded column: accounts.addConversionData->false
2012-12-04 10:39:58.333 (5) [main]: 	loaded column: accounts.fractionalConversionCounts->false
2012-12-04 10:39:58.333 (5) [main]: 	loaded column: accounts.hideNullSources->false
2012-12-04 10:39:58.333 (5) [main]: 	loaded column: accounts.nowTime->null
2012-12-04 10:39:58.333 (5) [main]: 	loaded column: accounts.warehouseDatabase->warehouse_4
2012-12-04 10:39:58.333 (5) [main]: 	loaded column: accounts.databaseInstance->5
2012-12-04 10:39:58.333 (5) [main]: 	loaded column: accounts.warehouseInstance->7
2012-12-04 10:39:58.334 (5) [main]: 	loaded column: accounts.isOnline->true
2012-12-04 10:39:58.334 (5) [main]: 	loaded column: accounts.timeZoneID->2
2012-12-04 10:39:58.348 (4) [main]: no account, or instance for databaseInstance, skipping lookup...
2012-12-04 10:39:58.348 (4) [main]: Took Existing Object from Pool
2012-12-04 10:39:58.348 (5) [main]: ProfilerRec.start("db",true) in Thread [main]
2012-12-04 10:39:58.349 (4) [main]: spike: SQL->[select @@version]
2012-12-04 10:39:58.350 (5) [main]: recordAsSubs("db", 1, "main")
2012-12-04 10:39:58.350 (5) [main]: addSub("db")
2012-12-04 10:39:58.350 (5) [main]: ProfilerRec.end("db", true): ret=1
2012-12-04 10:39:58.350 (4) [main]: time=0.0010
2012-12-04 10:39:58.350 (4) [main]: Query executed in 0.001s
2012-12-04 10:39:58.350 (4) [main]: test query succeeded, returned "5.1.49-rel11.3-log"
2012-12-04 10:39:58.351 (5) [main]: quoteValue(), nothing special about it=>[3], type=class java.lang.Integer
2012-12-04 10:39:58.351 (5) [main]: ProfilerRec.start("db",true) in Thread [main]
2012-12-04 10:39:58.351 (4) [main]: spike: SQL->[select * from `tsacommon`.`distribution` where (`id`=3) limit 1]
2012-12-04 10:39:58.352 (5) [main]: recordAsSubs("db", 1, "main")
2012-12-04 10:39:58.352 (5) [main]: addSub("db")
2012-12-04 10:39:58.352 (5) [main]: ProfilerRec.end("db", true): ret=1
2012-12-04 10:39:58.352 (4) [main]: time=0.0010
2012-12-04 10:39:58.353 (4) [main]: Query executed in 0.001s
2012-12-04 10:39:58.353 (5) [main]: loading 19 columns from result set:
2012-12-04 10:39:58.353 (5) [main]: 	loaded column: distribution.id->3
2012-12-04 10:39:58.353 (5) [main]: 	loaded column: distribution.accountID->0
2012-12-04 10:39:58.353 (5) [main]: 	loaded column: distribution.siteID->0
2012-12-04 10:39:58.353 (5) [main]: 	loaded column: distribution.type->paid search
2012-12-04 10:39:58.354 (5) [main]: 	loaded column: distribution.channelID->1
2012-12-04 10:39:58.354 (5) [main]: 	loaded column: distribution.showStats->1
2012-12-04 10:39:58.354 (5) [main]: 	loaded column: distribution.bidMatchTypes->exact,phrase,broad,content
2012-12-04 10:39:58.354 (5) [main]: 	loaded column: distribution.trackMatchTypes->exact,phrase,broad,content
2012-12-04 10:39:58.354 (5) [main]: 	loaded column: distribution.mergeMatchTypeStats->false
2012-12-04 10:39:58.354 (5) [main]: 	loaded column: distribution.rollupMatchTypes->content
2012-12-04 10:39:58.354 (5) [main]: 	loaded column: distribution.positionalBidding->false
2012-12-04 10:39:58.355 (5) [main]: 	loaded column: distribution.description->Google AdWords
2012-12-04 10:39:58.355 (5) [main]: 	loaded column: distribution.shortCode->GO
2012-12-04 10:39:58.355 (5) [main]: 	loaded column: distribution.searchEngineClass->com.thesearchagency.searchengines.google.GoogleAPISearchEngine
2012-12-04 10:39:58.355 (5) [main]: 	loaded column: distribution.bidMinCPC->0.01
2012-12-04 10:39:58.355 (5) [main]: 	loaded column: distribution.bidCapCPC->100.0
2012-12-04 10:39:58.355 (5) [main]: 	loaded column: distribution.bidMinCPM->0.25
2012-12-04 10:39:58.355 (5) [main]: 	loaded column: distribution.bidCapCPM->500.0
2012-12-04 10:39:58.356 (5) [main]: 	skipping invalid column: distribution.obsolete
2012-12-04 10:39:58.356 (4) [main]:   Record Loaded
2012-12-04 10:39:58.356 (5) [main]: class name is "com.thesearchagency.searchengines.google.GoogleAPISearchEngine"
2012-12-04 10:39:58.356 (4) [main]: User  in TSA MCC, connecting using master username/password
2012-12-04 10:39:58.356 (4) [main]: client customer id = 9001082081
2012-12-04 10:39:58.356 (5) [main]: parseInteger->[3177]
2012-12-04 10:39:58.356 (5) [main]: parseInteger<-[3177]
2012-12-04 10:39:58.356 (4) [main]: seuserid[3177] username[null] password[null] customerID[9001082081]
2012-12-04 10:39:58.360 (4) [main]: ClearConnections called at: Tue Dec 04 10:39:58 PST 2012	Timer: 1354645810882
2012-12-04 10:39:58.360 (5) [main]: quoteValue(), nothing special about it=>[3], type=class java.lang.Integer
2012-12-04 10:39:58.361 (5) [main]: ProfilerRec.start("db",true) in Thread [main]
2012-12-04 10:39:58.361 (4) [main]: sesystem: SQL->[update `sesystem`.`searchEngineConnections` set `inUse`="false",`holder`="",`timeStamp`="2012-12-04 10:39:58",`holderIdentifier`="" where ((`sesystem`.`searchEngineConnections`.`distributionID`=3) and (`sesystem`.`searchEngineConnections`.`inUse`="true") and (`sesystem`.`searchEngineConnections`.`timeStamp`<="2012-12-04 10:34:58")) limit 1], genflags=no
2012-12-04 10:39:58.362 (5) [main]: recordAsSubs("db", 1, "main")
2012-12-04 10:39:58.362 (5) [main]: addSub("db")
2012-12-04 10:39:58.362 (5) [main]: ProfilerRec.end("db", true): ret=1
2012-12-04 10:39:58.362 (4) [main]: time=0.0010
2012-12-04 10:39:58.363 (4) [main]: Query executed in 0.001s, 0 row(s) affected
2012-12-04 10:39:58.367 (4) [main]: Setting AuthToken [DQAAAJUAAABblTkk4samFeeIPZeA4b44C3w9CSZUFxB_1PKkgTJgM5Lgsa8hTds5kjeMJGa6cExwQnnIDV7Ug-KEY3tqzcq509ufM18E690NozMrYI1_ThysElNbsxM95UmDsdGckBnxsx2_W0beOdRfookxPexOo_l8H3BAtqbFpIIwgTH98LxImDZ0EQfjCTiZ49NAuNh3TJ7XbYd-0CN-WJfEw85Z] to AdWordsUser object for username[google@thesearchagency.com]
2012-12-04 10:39:58.469 (4) [main]: Returning Object to Pool
2012-12-04 10:39:58.470 (5) [main]: loading 56 columns from result set:
2012-12-04 10:39:58.471 (5) [main]: 	loaded column: searchEngineAccounts.id->69752
2012-12-04 10:39:58.471 (5) [main]: 	loaded column: searchEngineAccounts.accountID->898
2012-12-04 10:39:58.471 (5) [main]: 	loaded column: searchEngineAccounts.distributionID->3
2012-12-04 10:39:58.471 (5) [main]: 	loaded column: searchEngineAccounts.searchEngineUserID->3177
2012-12-04 10:39:58.471 (5) [main]: 	loaded column: searchEngineAccounts.description->ATT-WIC|Search-Mobile-Tablet|United States-English
2012-12-04 10:39:58.471 (5) [main]: 	loaded column: searchEngineAccounts.shortCode->null
2012-12-04 10:39:58.471 (5) [main]: 	loaded column: searchEngineAccounts.paused->false
2012-12-04 10:39:58.472 (5) [main]: 	loaded column: searchEngineAccounts.searchEngineIdentifier->109562330
2012-12-04 10:39:58.472 (5) [main]: 	loaded column: searchEngineAccounts.searchEngineScope->
2012-12-04 10:39:58.472 (5) [main]: 	loaded column: searchEngineAccounts.inContent->false
2012-12-04 10:39:58.472 (5) [main]: 	loaded column: searchEngineAccounts.enabled->true
2012-12-04 10:39:58.472 (5) [main]: 	loaded column: searchEngineAccounts.useConversionData->false
2012-12-04 10:39:58.472 (5) [main]: 	loaded column: searchEngineAccounts.searchEngineStatus->ok
2012-12-04 10:39:58.472 (5) [main]: 	loaded column: searchEngineAccounts.searchEngineStatusText->SERVING
2012-12-04 10:39:58.474 (5) [main]: 	loaded column: searchEngineAccounts.budgetType->dailyDivide
2012-12-04 10:39:58.475 (5) [main]: 	loaded column: searchEngineAccounts.budgetAmount->10.0
2012-12-04 10:39:58.479 (5) [main]: 	loaded column: searchEngineAccounts.lastChecked->2012-12-03 15:46:40.0
2012-12-04 10:39:58.479 (5) [main]: 	loaded column: searchEngineAccounts.networkType->GOOGLE_SEARCH,SEARCH_NETWORK
2012-12-04 10:39:58.479 (5) [main]: 	loaded column: searchEngineAccounts.contentType->
2012-12-04 10:39:58.479 (5) [main]: 	loaded column: searchEngineAccounts.biddingStrategy->ManualCPC
2012-12-04 10:39:58.480 (5) [main]: 	loaded column: searchEngineAccounts.hidden->false
2012-12-04 10:39:58.480 (5) [main]: 	skipping invalid column: searchEngineUsers.id
2012-12-04 10:39:58.480 (5) [main]: 	skipping invalid column: searchEngineUsers.accountID
2012-12-04 10:39:58.480 (5) [main]: 	skipping invalid column: searchEngineUsers.distributionID
2012-12-04 10:39:58.480 (5) [main]: 	skipping invalid column: searchEngineUsers.searchEngineIdentifier
2012-12-04 10:39:58.480 (5) [main]: 	skipping invalid column: searchEngineUsers.description
2012-12-04 10:39:58.480 (5) [main]: 	skipping invalid column: searchEngineUsers.username
2012-12-04 10:39:58.480 (5) [main]: 	skipping invalid column: searchEngineUsers.password
2012-12-04 10:39:58.481 (5) [main]: 	skipping invalid column: searchEngineUsers.enabled
2012-12-04 10:39:58.481 (5) [main]: 	skipping invalid column: searchEngineUsers.inTsaMcc
2012-12-04 10:39:58.481 (5) [main]: 	skipping invalid column: searchEngineUsers.apiKey
2012-12-04 10:39:58.482 (5) [main]: 	skipping invalid column: searchEngineUsers.managerUsernames
2012-12-04 10:39:58.482 (5) [main]: 	skipping invalid column: searchEngineUsers.managerIDs
2012-12-04 10:39:58.482 (5) [main]: 	skipping invalid column: searchEngineUsers.lastChecked
2012-12-04 10:39:58.482 (5) [main]: 	skipping invalid column: searchEngineUsers.lastInMcc
2012-12-04 10:39:58.482 (5) [main]: 	skipping invalid column: searchEngineUsers.hidden
2012-12-04 10:39:58.482 (5) [main]: 	skipping invalid column: accounts.id
2012-12-04 10:39:58.482 (5) [main]: 	skipping invalid column: accounts.description
2012-12-04 10:39:58.482 (5) [main]: 	skipping invalid column: accounts.tier
2012-12-04 10:39:58.482 (5) [main]: 	skipping invalid column: accounts.priority
2012-12-04 10:39:58.483 (5) [main]: 	skipping invalid column: accounts.reportClicksOut
2012-12-04 10:39:58.483 (5) [main]: 	skipping invalid column: accounts.reportConversions
2012-12-04 10:39:58.483 (5) [main]: 	skipping invalid column: accounts.conversionTypes
2012-12-04 10:39:58.483 (5) [main]: 	skipping invalid column: accounts.isBidManaged
2012-12-04 10:39:58.483 (5) [main]: 	skipping invalid column: accounts.isActive
2012-12-04 10:39:58.483 (5) [main]: 	skipping invalid column: accounts.perfMetric
2012-12-04 10:39:58.483 (5) [main]: 	skipping invalid column: accounts.providesConversionData
2012-12-04 10:39:58.484 (5) [main]: 	skipping invalid column: accounts.addConversionData
2012-12-04 10:39:58.484 (5) [main]: 	skipping invalid column: accounts.fractionalConversionCounts
2012-12-04 10:39:58.484 (5) [main]: 	skipping invalid column: accounts.hideNullSources
2012-12-04 10:39:58.484 (5) [main]: 	skipping invalid column: accounts.nowTime
2012-12-04 10:39:58.484 (5) [main]: 	skipping invalid column: accounts.warehouseDatabase
2012-12-04 10:39:58.484 (5) [main]: 	skipping invalid column: accounts.databaseInstance
2012-12-04 10:39:58.484 (5) [main]: 	skipping invalid column: accounts.warehouseInstance
2012-12-04 10:39:58.484 (5) [main]: 	skipping invalid column: accounts.isOnline
2012-12-04 10:39:58.485 (5) [main]: 	skipping invalid column: accounts.timeZoneID
2012-12-04 10:39:58.485 (5) [main]: loading 56 columns from result set:
2012-12-04 10:39:58.485 (5) [main]: 	skipping invalid column: searchEngineAccounts.id
2012-12-04 10:39:58.485 (5) [main]: 	skipping invalid column: searchEngineAccounts.accountID
2012-12-04 10:39:58.485 (5) [main]: 	skipping invalid column: searchEngineAccounts.distributionID
2012-12-04 10:39:58.485 (5) [main]: 	skipping invalid column: searchEngineAccounts.searchEngineUserID
2012-12-04 10:39:58.485 (5) [main]: 	skipping invalid column: searchEngineAccounts.description
2012-12-04 10:39:58.485 (5) [main]: 	skipping invalid column: searchEngineAccounts.shortCode
2012-12-04 10:39:58.486 (5) [main]: 	skipping invalid column: searchEngineAccounts.paused
2012-12-04 10:39:58.486 (5) [main]: 	skipping invalid column: searchEngineAccounts.searchEngineIdentifier
2012-12-04 10:39:58.486 (5) [main]: 	skipping invalid column: searchEngineAccounts.searchEngineScope
2012-12-04 10:39:58.486 (5) [main]: 	skipping invalid column: searchEngineAccounts.inContent
2012-12-04 10:39:58.486 (5) [main]: 	skipping invalid column: searchEngineAccounts.enabled
2012-12-04 10:39:58.486 (5) [main]: 	skipping invalid column: searchEngineAccounts.useConversionData
2012-12-04 10:39:58.486 (5) [main]: 	skipping invalid column: searchEngineAccounts.searchEngineStatus
2012-12-04 10:39:58.486 (5) [main]: 	skipping invalid column: searchEngineAccounts.searchEngineStatusText
2012-12-04 10:39:58.487 (5) [main]: 	skipping invalid column: searchEngineAccounts.budgetType
2012-12-04 10:39:58.487 (5) [main]: 	skipping invalid column: searchEngineAccounts.budgetAmount
2012-12-04 10:39:58.487 (5) [main]: 	skipping invalid column: searchEngineAccounts.lastChecked
2012-12-04 10:39:58.487 (5) [main]: 	skipping invalid column: searchEngineAccounts.networkType
2012-12-04 10:39:58.487 (5) [main]: 	skipping invalid column: searchEngineAccounts.contentType
2012-12-04 10:39:58.487 (5) [main]: 	skipping invalid column: searchEngineAccounts.biddingStrategy
2012-12-04 10:39:58.487 (5) [main]: 	skipping invalid column: searchEngineAccounts.hidden
2012-12-04 10:39:58.487 (5) [main]: 	loaded column: searchEngineUsers.id->3177
2012-12-04 10:39:58.488 (5) [main]: 	loaded column: searchEngineUsers.accountID->898
2012-12-04 10:39:58.488 (5) [main]: 	loaded column: searchEngineUsers.distributionID->3
2012-12-04 10:39:58.488 (5) [main]: 	loaded column: searchEngineUsers.searchEngineIdentifier->9001082081
2012-12-04 10:39:58.488 (5) [main]: 	loaded column: searchEngineUsers.description->AT&T Pan Asian Youth Campaign
2012-12-04 10:39:58.488 (5) [main]: 	loaded column: searchEngineUsers.username->
2012-12-04 10:39:58.488 (5) [main]: 	loaded column: searchEngineUsers.password->
2012-12-04 10:39:58.488 (5) [main]: 	loaded column: searchEngineUsers.enabled->true
2012-12-04 10:39:58.488 (5) [main]: 	loaded column: searchEngineUsers.inTsaMcc->true
2012-12-04 10:39:58.489 (5) [main]: 	loaded column: searchEngineUsers.apiKey->
2012-12-04 10:39:58.489 (5) [main]: 	loaded column: searchEngineUsers.managerUsernames->null
2012-12-04 10:39:58.489 (5) [main]: 	loaded column: searchEngineUsers.managerIDs->1752475908,9136835500,9050076625
2012-12-04 10:39:58.489 (5) [main]: 	loaded column: searchEngineUsers.lastChecked->2012-12-04 09:52:27.0
2012-12-04 10:39:58.489 (5) [main]: 	loaded column: searchEngineUsers.lastInMcc->2012-12-04 08:20:17.0
2012-12-04 10:39:58.490 (5) [main]: 	skipping invalid column: searchEngineUsers.hidden
2012-12-04 10:39:58.490 (5) [main]: 	skipping invalid column: accounts.id
2012-12-04 10:39:58.490 (5) [main]: 	skipping invalid column: accounts.description
2012-12-04 10:39:58.490 (5) [main]: 	skipping invalid column: accounts.tier
2012-12-04 10:39:58.490 (5) [main]: 	skipping invalid column: accounts.priority
2012-12-04 10:39:58.490 (5) [main]: 	skipping invalid column: accounts.reportClicksOut
2012-12-04 10:39:58.490 (5) [main]: 	skipping invalid column: accounts.reportConversions
2012-12-04 10:39:58.490 (5) [main]: 	skipping invalid column: accounts.conversionTypes
2012-12-04 10:39:58.490 (5) [main]: 	skipping invalid column: accounts.isBidManaged
2012-12-04 10:39:58.490 (5) [main]: 	skipping invalid column: accounts.isActive
2012-12-04 10:39:58.491 (5) [main]: 	skipping invalid column: accounts.perfMetric
2012-12-04 10:39:58.491 (5) [main]: 	skipping invalid column: accounts.providesConversionData
2012-12-04 10:39:58.491 (5) [main]: 	skipping invalid column: accounts.addConversionData
2012-12-04 10:39:58.491 (5) [main]: 	skipping invalid column: accounts.fractionalConversionCounts
2012-12-04 10:39:58.491 (5) [main]: 	skipping invalid column: accounts.hideNullSources
2012-12-04 10:39:58.491 (5) [main]: 	skipping invalid column: accounts.nowTime
2012-12-04 10:39:58.491 (5) [main]: 	skipping invalid column: accounts.warehouseDatabase
2012-12-04 10:39:58.491 (5) [main]: 	skipping invalid column: accounts.databaseInstance
2012-12-04 10:39:58.491 (5) [main]: 	skipping invalid column: accounts.warehouseInstance
2012-12-04 10:39:58.492 (5) [main]: 	skipping invalid column: accounts.isOnline
2012-12-04 10:39:58.492 (5) [main]: 	skipping invalid column: accounts.timeZoneID
2012-12-04 10:39:58.492 (5) [main]: loading 56 columns from result set:
2012-12-04 10:39:58.492 (5) [main]: 	skipping invalid column: searchEngineAccounts.id
2012-12-04 10:39:58.492 (5) [main]: 	skipping invalid column: searchEngineAccounts.accountID
2012-12-04 10:39:58.492 (5) [main]: 	skipping invalid column: searchEngineAccounts.distributionID
2012-12-04 10:39:58.492 (5) [main]: 	skipping invalid column: searchEngineAccounts.searchEngineUserID
2012-12-04 10:39:58.492 (5) [main]: 	skipping invalid column: searchEngineAccounts.description
2012-12-04 10:39:58.492 (5) [main]: 	skipping invalid column: searchEngineAccounts.shortCode
2012-12-04 10:39:58.492 (5) [main]: 	skipping invalid column: searchEngineAccounts.paused
2012-12-04 10:39:58.493 (5) [main]: 	skipping invalid column: searchEngineAccounts.searchEngineIdentifier
2012-12-04 10:39:58.493 (5) [main]: 	skipping invalid column: searchEngineAccounts.searchEngineScope
2012-12-04 10:39:58.493 (5) [main]: 	skipping invalid column: searchEngineAccounts.inContent
2012-12-04 10:39:58.493 (5) [main]: 	skipping invalid column: searchEngineAccounts.enabled
2012-12-04 10:39:58.493 (5) [main]: 	skipping invalid column: searchEngineAccounts.useConversionData
2012-12-04 10:39:58.493 (5) [main]: 	skipping invalid column: searchEngineAccounts.searchEngineStatus
2012-12-04 10:39:58.493 (5) [main]: 	skipping invalid column: searchEngineAccounts.searchEngineStatusText
2012-12-04 10:39:58.493 (5) [main]: 	skipping invalid column: searchEngineAccounts.budgetType
2012-12-04 10:39:58.493 (5) [main]: 	skipping invalid column: searchEngineAccounts.budgetAmount
2012-12-04 10:39:58.494 (5) [main]: 	skipping invalid column: searchEngineAccounts.lastChecked
2012-12-04 10:39:58.494 (5) [main]: 	skipping invalid column: searchEngineAccounts.networkType
2012-12-04 10:39:58.494 (5) [main]: 	skipping invalid column: searchEngineAccounts.contentType
2012-12-04 10:39:58.494 (5) [main]: 	skipping invalid column: searchEngineAccounts.biddingStrategy
2012-12-04 10:39:58.494 (5) [main]: 	skipping invalid column: searchEngineAccounts.hidden
2012-12-04 10:39:58.494 (5) [main]: 	skipping invalid column: searchEngineUsers.id
2012-12-04 10:39:58.494 (5) [main]: 	skipping invalid column: searchEngineUsers.accountID
2012-12-04 10:39:58.494 (5) [main]: 	skipping invalid column: searchEngineUsers.distributionID
2012-12-04 10:39:58.494 (5) [main]: 	skipping invalid column: searchEngineUsers.searchEngineIdentifier
2012-12-04 10:39:58.495 (5) [main]: 	skipping invalid column: searchEngineUsers.description
2012-12-04 10:39:58.495 (5) [main]: 	skipping invalid column: searchEngineUsers.username
2012-12-04 10:39:58.495 (5) [main]: 	skipping invalid column: searchEngineUsers.password
2012-12-04 10:39:58.495 (5) [main]: 	skipping invalid column: searchEngineUsers.enabled
2012-12-04 10:39:58.495 (5) [main]: 	skipping invalid column: searchEngineUsers.inTsaMcc
2012-12-04 10:39:58.495 (5) [main]: 	skipping invalid column: searchEngineUsers.apiKey
2012-12-04 10:39:58.495 (5) [main]: 	skipping invalid column: searchEngineUsers.managerUsernames
2012-12-04 10:39:58.495 (5) [main]: 	skipping invalid column: searchEngineUsers.managerIDs
2012-12-04 10:39:58.495 (5) [main]: 	skipping invalid column: searchEngineUsers.lastChecked
2012-12-04 10:39:58.495 (5) [main]: 	skipping invalid column: searchEngineUsers.lastInMcc
2012-12-04 10:39:58.496 (5) [main]: 	skipping invalid column: searchEngineUsers.hidden
2012-12-04 10:39:58.496 (5) [main]: 	loaded column: accounts.id->898
2012-12-04 10:39:58.496 (5) [main]: 	loaded column: accounts.description->Rezonate - AT&T
2012-12-04 10:39:58.496 (5) [main]: 	loaded column: accounts.tier->2
2012-12-04 10:39:58.496 (5) [main]: 	loaded column: accounts.priority->50
2012-12-04 10:39:58.496 (5) [main]: 	loaded column: accounts.reportClicksOut->false
2012-12-04 10:39:58.496 (5) [main]: 	loaded column: accounts.reportConversions->false
2012-12-04 10:39:58.497 (5) [main]: 	loaded column: accounts.conversionTypes->
2012-12-04 10:39:58.497 (5) [main]: 	loaded column: accounts.isBidManaged->true
2012-12-04 10:39:58.497 (5) [main]: 	loaded column: accounts.isActive->true
2012-12-04 10:39:58.497 (5) [main]: 	loaded column: accounts.perfMetric->cpa
2012-12-04 10:39:58.497 (5) [main]: 	loaded column: accounts.providesConversionData->false
2012-12-04 10:39:58.497 (5) [main]: 	loaded column: accounts.addConversionData->false
2012-12-04 10:39:58.497 (5) [main]: 	loaded column: accounts.fractionalConversionCounts->false
2012-12-04 10:39:58.497 (5) [main]: 	loaded column: accounts.hideNullSources->false
2012-12-04 10:39:58.498 (5) [main]: 	loaded column: accounts.nowTime->null
2012-12-04 10:39:58.498 (5) [main]: 	loaded column: accounts.warehouseDatabase->warehouse_4
2012-12-04 10:39:58.498 (5) [main]: 	loaded column: accounts.databaseInstance->5
2012-12-04 10:39:58.498 (5) [main]: 	loaded column: accounts.warehouseInstance->7
2012-12-04 10:39:58.498 (5) [main]: 	loaded column: accounts.isOnline->true
2012-12-04 10:39:58.498 (5) [main]: 	loaded column: accounts.timeZoneID->2
2012-12-04 10:39:58.504 (4) [P2T1]: no account, or instance for databaseInstance, skipping lookup...
2012-12-04 10:39:58.505 (4) [P2T1]: Took Existing Object from Pool
2012-12-04 10:39:58.505 (5) [P2T1]: ProfilerRec.start("db",true) in Thread [P2T1]
2012-12-04 10:39:58.505 (4) [P2T1]: spike: SQL->[select @@version]
2012-12-04 10:39:58.509 (5) [P2T1]: recordAsSubs("db", 4, "P2T1")
2012-12-04 10:39:58.510 (5) [P2T1]: addSub("db")
2012-12-04 10:39:58.510 (5) [P2T1]: ProfilerRec.end("db", true): ret=4
2012-12-04 10:39:58.510 (4) [P2T1]: time=0.0040
2012-12-04 10:39:58.510 (4) [P2T1]: Query executed in 0.004s
2012-12-04 10:39:58.511 (4) [P2T1]: test query succeeded, returned "5.1.49-rel11.3-log"
2012-12-04 10:39:58.511 (5) [P2T1]: quoteValue(), nothing special about it=>[898], type=class java.lang.Integer
2012-12-04 10:39:58.511 (5) [P2T1]: ProfilerRec.start("db",true) in Thread [P2T1]
2012-12-04 10:39:58.512 (4) [P2T1]: spike: SQL->[select * from `tsacommon`.`accounts` where (`tsacommon`.`accounts`.`id`=898) limit 1]
2012-12-04 10:39:58.517 (4) [main]: no account, or instance for databaseInstance, skipping lookup...
2012-12-04 10:39:58.525 (5) [P2T1]: recordAsSubs("db", 13, "P2T1")
2012-12-04 10:39:58.525 (5) [P2T1]: addSub("db")
2012-12-04 10:39:58.525 (5) [P2T1]: ProfilerRec.end("db", true): ret=13
2012-12-04 10:39:58.526 (4) [P2T1]: time=0.013
2012-12-04 10:39:58.526 (4) [P2T1]: Query executed in 0.013s
2012-12-04 10:39:58.526 (5) [P2T1]: loading 20 columns from result set:
2012-12-04 10:39:58.526 (5) [P2T1]: 	loaded column: accounts.id->898
2012-12-04 10:39:58.527 (5) [P2T1]: 	loaded column: accounts.description->Rezonate - AT&T
2012-12-04 10:39:58.527 (5) [P2T1]: 	loaded column: accounts.tier->2
2012-12-04 10:39:58.527 (5) [P2T1]: 	loaded column: accounts.priority->50
2012-12-04 10:39:58.527 (5) [P2T1]: 	loaded column: accounts.reportClicksOut->false
2012-12-04 10:39:58.527 (5) [P2T1]: 	loaded column: accounts.reportConversions->false
2012-12-04 10:39:58.527 (5) [P2T1]: 	loaded column: accounts.conversionTypes->
2012-12-04 10:39:58.528 (5) [P2T1]: 	loaded column: accounts.isBidManaged->true
2012-12-04 10:39:58.528 (5) [P2T1]: 	loaded column: accounts.isActive->true
2012-12-04 10:39:58.528 (5) [P2T1]: 	loaded column: accounts.perfMetric->cpa
2012-12-04 10:39:58.528 (5) [P2T1]: 	loaded column: accounts.providesConversionData->false
2012-12-04 10:39:58.528 (5) [P2T1]: 	loaded column: accounts.addConversionData->false
2012-12-04 10:39:58.528 (5) [P2T1]: 	loaded column: accounts.fractionalConversionCounts->false
2012-12-04 10:39:58.529 (5) [P2T1]: 	loaded column: accounts.hideNullSources->false
2012-12-04 10:39:58.529 (5) [P2T1]: 	loaded column: accounts.nowTime->null
2012-12-04 10:39:58.529 (5) [P2T1]: 	loaded column: accounts.warehouseDatabase->warehouse_4
2012-12-04 10:39:58.529 (5) [P2T1]: 	loaded column: accounts.databaseInstance->5
2012-12-04 10:39:58.529 (5) [P2T1]: 	loaded column: accounts.warehouseInstance->7
2012-12-04 10:39:58.530 (5) [P2T1]: 	loaded column: accounts.isOnline->true
2012-12-04 10:39:58.530 (5) [P2T1]: 	loaded column: accounts.timeZoneID->2
2012-12-04 10:39:58.530 (4) [P2T1]:   Record Loaded
2012-12-04 10:39:58.542 (4) [main]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false]
2012-12-04 10:39:58.542 (4) [main]: Created new Object
2012-12-04 10:39:58.542 (5) [main]: ProfilerRec.start("db",true) in Thread [main]
2012-12-04 10:39:58.543 (4) [main]: spike: SQL->[select @@version]
2012-12-04 10:39:58.543 (4) [P2T1]: Returning Object to Pool
2012-12-04 10:39:58.543 (3) [P2T1]: Starting Account (69735) "ATT-WIC|Youtube Overlay|Contextual-Desktop" for user (3177) "AT&T Pan Asian Youth Campaign"
2012-12-04 10:39:58.543 (3) [P2T1]: Sync Flag: false - syncGroups and syncListings skipped for (69735) "ATT-WIC|Youtube Overlay|Contextual-Desktop" for user (3177) "AT&T Pan Asian Youth Campaign"
2012-12-04 10:39:58.543 (3) [P2T1]: Finished Account (69735) "ATT-WIC|Youtube Overlay|Contextual-Desktop" for user (3177) "AT&T Pan Asian Youth Campaign"
2012-12-04 10:39:58.544 (5) [main]: recordAsSubs("db", 1, "main")
2012-12-04 10:39:58.544 (5) [main]: addSub("db")
2012-12-04 10:39:58.545 (5) [main]: ProfilerRec.end("db", true): ret=1
2012-12-04 10:39:58.545 (4) [main]: time=0.0010
2012-12-04 10:39:58.545 (4) [main]: Query executed in 0.001s
2012-12-04 10:39:58.545 (4) [main]: test query succeeded, returned "5.1.49-rel11.3-log"
2012-12-04 10:39:58.546 (5) [main]: quoteValue(), nothing special about it=>[3], type=class java.lang.Integer
2012-12-04 10:39:58.546 (5) [main]: ProfilerRec.start("db",true) in Thread [main]
2012-12-04 10:39:58.546 (4) [main]: spike: SQL->[select * from `tsacommon`.`distribution` where (`id`=3) limit 1]
2012-12-04 10:39:58.547 (5) [main]: recordAsSubs("db", 1, "main")
2012-12-04 10:39:58.547 (5) [main]: addSub("db")
2012-12-04 10:39:58.547 (5) [main]: ProfilerRec.end("db", true): ret=1
2012-12-04 10:39:58.548 (4) [main]: time=0.0010
2012-12-04 10:39:58.548 (4) [main]: Query executed in 0.001s
2012-12-04 10:39:58.548 (5) [main]: loading 19 columns from result set:
2012-12-04 10:39:58.548 (5) [main]: 	loaded column: distribution.id->3
2012-12-04 10:39:58.548 (5) [main]: 	loaded column: distribution.accountID->0
2012-12-04 10:39:58.548 (5) [main]: 	loaded column: distribution.siteID->0
2012-12-04 10:39:58.549 (5) [main]: 	loaded column: distribution.type->paid search
2012-12-04 10:39:58.549 (5) [main]: 	loaded column: distribution.channelID->1
2012-12-04 10:39:58.549 (5) [main]: 	loaded column: distribution.showStats->1
2012-12-04 10:39:58.549 (5) [main]: 	loaded column: distribution.bidMatchTypes->exact,phrase,broad,content
2012-12-04 10:39:58.549 (5) [main]: 	loaded column: distribution.trackMatchTypes->exact,phrase,broad,content
2012-12-04 10:39:58.549 (5) [main]: 	loaded column: distribution.mergeMatchTypeStats->false
2012-12-04 10:39:58.550 (5) [main]: 	loaded column: distribution.rollupMatchTypes->content
2012-12-04 10:39:58.550 (5) [main]: 	loaded column: distribution.positionalBidding->false
2012-12-04 10:39:58.550 (5) [main]: 	loaded column: distribution.description->Google AdWords
2012-12-04 10:39:58.550 (5) [main]: 	loaded column: distribution.shortCode->GO
2012-12-04 10:39:58.550 (5) [main]: 	loaded column: distribution.searchEngineClass->com.thesearchagency.searchengines.google.GoogleAPISearchEngine
2012-12-04 10:39:58.550 (5) [main]: 	loaded column: distribution.bidMinCPC->0.01
2012-12-04 10:39:58.550 (5) [main]: 	loaded column: distribution.bidCapCPC->100.0
2012-12-04 10:39:58.551 (5) [main]: 	loaded column: distribution.bidMinCPM->0.25
2012-12-04 10:39:58.551 (5) [main]: 	loaded column: distribution.bidCapCPM->500.0
2012-12-04 10:39:58.551 (5) [main]: 	skipping invalid column: distribution.obsolete
2012-12-04 10:39:58.551 (4) [main]:   Record Loaded
2012-12-04 10:39:58.551 (5) [main]: class name is "com.thesearchagency.searchengines.google.GoogleAPISearchEngine"
2012-12-04 10:39:58.551 (4) [main]: User  in TSA MCC, connecting using master username/password
2012-12-04 10:39:58.552 (4) [main]: client customer id = 9001082081
2012-12-04 10:39:58.552 (5) [main]: parseInteger->[3177]
2012-12-04 10:39:58.552 (5) [main]: parseInteger<-[3177]
2012-12-04 10:39:58.552 (4) [main]: seuserid[3177] username[null] password[null] customerID[9001082081]
2012-12-04 10:39:58.560 (4) [main]: Setting AuthToken [DQAAAJUAAABblTkk4samFeeIPZeA4b44C3w9CSZUFxB_1PKkgTJgM5Lgsa8hTds5kjeMJGa6cExwQnnIDV7Ug-KEY3tqzcq509ufM18E690NozMrYI1_ThysElNbsxM95UmDsdGckBnxsx2_W0beOdRfookxPexOo_l8H3BAtqbFpIIwgTH98LxImDZ0EQfjCTiZ49NAuNh3TJ7XbYd-0CN-WJfEw85Z] to AdWordsUser object for username[google@thesearchagency.com]
2012-12-04 10:39:58.583 (4) [main]: Returning Object to Pool
2012-12-04 10:39:58.587 (5) [main]: loading 56 columns from result set:
2012-12-04 10:39:58.587 (5) [main]: 	loaded column: searchEngineAccounts.id->69753
2012-12-04 10:39:58.588 (5) [main]: 	loaded column: searchEngineAccounts.accountID->898
2012-12-04 10:39:58.588 (5) [main]: 	loaded column: searchEngineAccounts.distributionID->3
2012-12-04 10:39:58.588 (5) [main]: 	loaded column: searchEngineAccounts.searchEngineUserID->3177
2012-12-04 10:39:58.588 (5) [main]: 	loaded column: searchEngineAccounts.description->ATT-WIC|Search-Desktop|United States-English
2012-12-04 10:39:58.588 (5) [main]: 	loaded column: searchEngineAccounts.shortCode->null
2012-12-04 10:39:58.589 (5) [main]: 	loaded column: searchEngineAccounts.paused->false
2012-12-04 10:39:58.589 (5) [main]: 	loaded column: searchEngineAccounts.searchEngineIdentifier->109562210
2012-12-04 10:39:58.589 (5) [main]: 	loaded column: searchEngineAccounts.searchEngineScope->
2012-12-04 10:39:58.589 (5) [main]: 	loaded column: searchEngineAccounts.inContent->false
2012-12-04 10:39:58.589 (5) [main]: 	loaded column: searchEngineAccounts.enabled->true
2012-12-04 10:39:58.589 (5) [main]: 	loaded column: searchEngineAccounts.useConversionData->false
2012-12-04 10:39:58.589 (5) [main]: 	loaded column: searchEngineAccounts.searchEngineStatus->ok
2012-12-04 10:39:58.590 (5) [main]: 	loaded column: searchEngineAccounts.searchEngineStatusText->SERVING
2012-12-04 10:39:58.590 (5) [main]: 	loaded column: searchEngineAccounts.budgetType->dailyDivide
2012-12-04 10:39:58.590 (5) [main]: 	loaded column: searchEngineAccounts.budgetAmount->10.0
2012-12-04 10:39:58.590 (5) [main]: 	loaded column: searchEngineAccounts.lastChecked->2012-12-03 15:46:51.0
2012-12-04 10:39:58.591 (5) [main]: 	loaded column: searchEngineAccounts.networkType->GOOGLE_SEARCH,SEARCH_NETWORK
2012-12-04 10:39:58.591 (5) [main]: 	loaded column: searchEngineAccounts.contentType->
2012-12-04 10:39:58.591 (5) [main]: 	loaded column: searchEngineAccounts.biddingStrategy->ManualCPC
2012-12-04 10:39:58.591 (5) [main]: 	loaded column: searchEngineAccounts.hidden->false
2012-12-04 10:39:58.591 (5) [main]: 	skipping invalid column: searchEngineUsers.id
2012-12-04 10:39:58.591 (5) [main]: 	skipping invalid column: searchEngineUsers.accountID
2012-12-04 10:39:58.591 (5) [main]: 	skipping invalid column: searchEngineUsers.distributionID
2012-12-04 10:39:58.591 (5) [main]: 	skipping invalid column: searchEngineUsers.searchEngineIdentifier
2012-12-04 10:39:58.591 (5) [main]: 	skipping invalid column: searchEngineUsers.description
2012-12-04 10:39:58.593 (5) [main]: 	skipping invalid column: searchEngineUsers.username
2012-12-04 10:39:58.593 (5) [main]: 	skipping invalid column: searchEngineUsers.password
2012-12-04 10:39:58.593 (5) [main]: 	skipping invalid column: searchEngineUsers.enabled
2012-12-04 10:39:58.593 (5) [main]: 	skipping invalid column: searchEngineUsers.inTsaMcc
2012-12-04 10:39:58.593 (5) [main]: 	skipping invalid column: searchEngineUsers.apiKey
2012-12-04 10:39:58.593 (5) [main]: 	skipping invalid column: searchEngineUsers.managerUsernames
2012-12-04 10:39:58.594 (5) [main]: 	skipping invalid column: searchEngineUsers.managerIDs
2012-12-04 10:39:58.594 (5) [main]: 	skipping invalid column: searchEngineUsers.lastChecked
2012-12-04 10:39:58.594 (5) [main]: 	skipping invalid column: searchEngineUsers.lastInMcc
2012-12-04 10:39:58.594 (5) [main]: 	skipping invalid column: searchEngineUsers.hidden
2012-12-04 10:39:58.594 (5) [main]: 	skipping invalid column: accounts.id
2012-12-04 10:39:58.594 (5) [main]: 	skipping invalid column: accounts.description
2012-12-04 10:39:58.594 (5) [main]: 	skipping invalid column: accounts.tier
2012-12-04 10:39:58.594 (5) [main]: 	skipping invalid column: accounts.priority
2012-12-04 10:39:58.594 (5) [main]: 	skipping invalid column: accounts.reportClicksOut
2012-12-04 10:39:58.594 (5) [main]: 	skipping invalid column: accounts.reportConversions
2012-12-04 10:39:58.594 (5) [main]: 	skipping invalid column: accounts.conversionTypes
2012-12-04 10:39:58.595 (5) [main]: 	skipping invalid column: accounts.isBidManaged
2012-12-04 10:39:58.595 (5) [main]: 	skipping invalid column: accounts.isActive
2012-12-04 10:39:58.595 (5) [main]: 	skipping invalid column: accounts.perfMetric
2012-12-04 10:39:58.595 (5) [main]: 	skipping invalid column: accounts.providesConversionData
2012-12-04 10:39:58.595 (5) [main]: 	skipping invalid column: accounts.addConversionData
2012-12-04 10:39:58.595 (5) [main]: 	skipping invalid column: accounts.fractionalConversionCounts
2012-12-04 10:39:58.595 (5) [main]: 	skipping invalid column: accounts.hideNullSources
2012-12-04 10:39:58.595 (5) [main]: 	skipping invalid column: accounts.nowTime
2012-12-04 10:39:58.595 (5) [main]: 	skipping invalid column: accounts.warehouseDatabase
2012-12-04 10:39:58.595 (5) [main]: 	skipping invalid column: accounts.databaseInstance
2012-12-04 10:39:58.596 (5) [main]: 	skipping invalid column: accounts.warehouseInstance
2012-12-04 10:39:58.596 (5) [main]: 	skipping invalid column: accounts.isOnline
2012-12-04 10:39:58.596 (5) [main]: 	skipping invalid column: accounts.timeZoneID
2012-12-04 10:39:58.596 (5) [main]: loading 56 columns from result set:
2012-12-04 10:39:58.596 (5) [main]: 	skipping invalid column: searchEngineAccounts.id
2012-12-04 10:39:58.596 (5) [main]: 	skipping invalid column: searchEngineAccounts.accountID
2012-12-04 10:39:58.596 (5) [main]: 	skipping invalid column: searchEngineAccounts.distributionID
2012-12-04 10:39:58.596 (5) [main]: 	skipping invalid column: searchEngineAccounts.searchEngineUserID
2012-12-04 10:39:58.597 (5) [main]: 	skipping invalid column: searchEngineAccounts.description
2012-12-04 10:39:58.597 (5) [main]: 	skipping invalid column: searchEngineAccounts.shortCode
2012-12-04 10:39:58.597 (5) [main]: 	skipping invalid column: searchEngineAccounts.paused
2012-12-04 10:39:58.597 (5) [main]: 	skipping invalid column: searchEngineAccounts.searchEngineIdentifier
2012-12-04 10:39:58.597 (5) [main]: 	skipping invalid column: searchEngineAccounts.searchEngineScope
2012-12-04 10:39:58.597 (5) [main]: 	skipping invalid column: searchEngineAccounts.inContent
2012-12-04 10:39:58.597 (5) [main]: 	skipping invalid column: searchEngineAccounts.enabled
2012-12-04 10:39:58.597 (5) [main]: 	skipping invalid column: searchEngineAccounts.useConversionData
2012-12-04 10:39:58.597 (5) [main]: 	skipping invalid column: searchEngineAccounts.searchEngineStatus
2012-12-04 10:39:58.597 (5) [main]: 	skipping invalid column: searchEngineAccounts.searchEngineStatusText
2012-12-04 10:39:58.598 (5) [main]: 	skipping invalid column: searchEngineAccounts.budgetType
2012-12-04 10:39:58.598 (5) [main]: 	skipping invalid column: searchEngineAccounts.budgetAmount
2012-12-04 10:39:58.598 (5) [main]: 	skipping invalid column: searchEngineAccounts.lastChecked
2012-12-04 10:39:58.598 (5) [main]: 	skipping invalid column: searchEngineAccounts.networkType
2012-12-04 10:39:58.598 (5) [main]: 	skipping invalid column: searchEngineAccounts.contentType
2012-12-04 10:39:58.598 (5) [main]: 	skipping invalid column: searchEngineAccounts.biddingStrategy
2012-12-04 10:39:58.598 (5) [main]: 	skipping invalid column: searchEngineAccounts.hidden
2012-12-04 10:39:58.598 (5) [main]: 	loaded column: searchEngineUsers.id->3177
2012-12-04 10:39:58.598 (5) [main]: 	loaded column: searchEngineUsers.accountID->898
2012-12-04 10:39:58.598 (5) [main]: 	loaded column: searchEngineUsers.distributionID->3
2012-12-04 10:39:58.599 (5) [main]: 	loaded column: searchEngineUsers.searchEngineIdentifier->9001082081
2012-12-04 10:39:58.599 (5) [main]: 	loaded column: searchEngineUsers.description->AT&T Pan Asian Youth Campaign
2012-12-04 10:39:58.599 (5) [main]: 	loaded column: searchEngineUsers.username->
2012-12-04 10:39:58.599 (5) [main]: 	loaded column: searchEngineUsers.password->
2012-12-04 10:39:58.599 (5) [main]: 	loaded column: searchEngineUsers.enabled->true
2012-12-04 10:39:58.599 (5) [main]: 	loaded column: searchEngineUsers.inTsaMcc->true
2012-12-04 10:39:58.599 (5) [main]: 	loaded column: searchEngineUsers.apiKey->
2012-12-04 10:39:58.599 (5) [main]: 	loaded column: searchEngineUsers.managerUsernames->null
2012-12-04 10:39:58.599 (5) [main]: 	loaded column: searchEngineUsers.managerIDs->1752475908,9136835500,9050076625
2012-12-04 10:39:58.600 (5) [main]: 	loaded column: searchEngineUsers.lastChecked->2012-12-04 09:52:27.0
2012-12-04 10:39:58.600 (5) [main]: 	loaded column: searchEngineUsers.lastInMcc->2012-12-04 08:20:17.0
2012-12-04 10:39:58.600 (5) [main]: 	skipping invalid column: searchEngineUsers.hidden
2012-12-04 10:39:58.600 (5) [main]: 	skipping invalid column: accounts.id
2012-12-04 10:39:58.600 (5) [main]: 	skipping invalid column: accounts.description
2012-12-04 10:39:58.600 (5) [main]: 	skipping invalid column: accounts.tier
2012-12-04 10:39:58.600 (5) [main]: 	skipping invalid column: accounts.priority
2012-12-04 10:39:58.601 (5) [main]: 	skipping invalid column: accounts.reportClicksOut
2012-12-04 10:39:58.601 (5) [main]: 	skipping invalid column: accounts.reportConversions
2012-12-04 10:39:58.601 (5) [main]: 	skipping invalid column: accounts.conversionTypes
2012-12-04 10:39:58.601 (5) [main]: 	skipping invalid column: accounts.isBidManaged
2012-12-04 10:39:58.601 (5) [main]: 	skipping invalid column: accounts.isActive
2012-12-04 10:39:58.601 (5) [main]: 	skipping invalid column: accounts.perfMetric
2012-12-04 10:39:58.601 (5) [main]: 	skipping invalid column: accounts.providesConversionData
2012-12-04 10:39:58.601 (5) [main]: 	skipping invalid column: accounts.addConversionData
2012-12-04 10:39:58.601 (5) [main]: 	skipping invalid column: accounts.fractionalConversionCounts
2012-12-04 10:39:58.601 (5) [main]: 	skipping invalid column: accounts.hideNullSources
2012-12-04 10:39:58.602 (5) [main]: 	skipping invalid column: accounts.nowTime
2012-12-04 10:39:58.602 (5) [main]: 	skipping invalid column: accounts.warehouseDatabase
2012-12-04 10:39:58.602 (5) [main]: 	skipping invalid column: accounts.databaseInstance
2012-12-04 10:39:58.602 (5) [main]: 	skipping invalid column: accounts.warehouseInstance
2012-12-04 10:39:58.602 (5) [main]: 	skipping invalid column: accounts.isOnline
2012-12-04 10:39:58.602 (5) [main]: 	skipping invalid column: accounts.timeZoneID
2012-12-04 10:39:58.602 (5) [main]: loading 56 columns from result set:
2012-12-04 10:39:58.602 (5) [main]: 	skipping invalid column: searchEngineAccounts.id
2012-12-04 10:39:58.602 (5) [main]: 	skipping invalid column: searchEngineAccounts.accountID
2012-12-04 10:39:58.602 (5) [main]: 	skipping invalid column: searchEngineAccounts.distributionID
2012-12-04 10:39:58.602 (5) [main]: 	skipping invalid column: searchEngineAccounts.searchEngineUserID
2012-12-04 10:39:58.603 (5) [main]: 	skipping invalid column: searchEngineAccounts.description
2012-12-04 10:39:58.603 (5) [main]: 	skipping invalid column: searchEngineAccounts.shortCode
2012-12-04 10:39:58.603 (5) [main]: 	skipping invalid column: searchEngineAccounts.paused
2012-12-04 10:39:58.603 (5) [main]: 	skipping invalid column: searchEngineAccounts.searchEngineIdentifier
2012-12-04 10:39:58.603 (5) [main]: 	skipping invalid column: searchEngineAccounts.searchEngineScope
2012-12-04 10:39:58.603 (5) [main]: 	skipping invalid column: searchEngineAccounts.inContent
2012-12-04 10:39:58.603 (5) [main]: 	skipping invalid column: searchEngineAccounts.enabled
2012-12-04 10:39:58.603 (5) [main]: 	skipping invalid column: searchEngineAccounts.useConversionData
2012-12-04 10:39:58.603 (5) [main]: 	skipping invalid column: searchEngineAccounts.searchEngineStatus
2012-12-04 10:39:58.603 (5) [main]: 	skipping invalid column: searchEngineAccounts.searchEngineStatusText
2012-12-04 10:39:58.603 (5) [main]: 	skipping invalid column: searchEngineAccounts.budgetType
2012-12-04 10:39:58.604 (5) [main]: 	skipping invalid column: searchEngineAccounts.budgetAmount
2012-12-04 10:39:58.604 (5) [main]: 	skipping invalid column: searchEngineAccounts.lastChecked
2012-12-04 10:39:58.604 (5) [main]: 	skipping invalid column: searchEngineAccounts.networkType
2012-12-04 10:39:58.604 (5) [main]: 	skipping invalid column: searchEngineAccounts.contentType
2012-12-04 10:39:58.604 (5) [main]: 	skipping invalid column: searchEngineAccounts.biddingStrategy
2012-12-04 10:39:58.604 (5) [main]: 	skipping invalid column: searchEngineAccounts.hidden
2012-12-04 10:39:58.604 (5) [main]: 	skipping invalid column: searchEngineUsers.id
2012-12-04 10:39:58.604 (5) [main]: 	skipping invalid column: searchEngineUsers.accountID
2012-12-04 10:39:58.604 (5) [main]: 	skipping invalid column: searchEngineUsers.distributionID
2012-12-04 10:39:58.604 (5) [main]: 	skipping invalid column: searchEngineUsers.searchEngineIdentifier
2012-12-04 10:39:58.605 (5) [main]: 	skipping invalid column: searchEngineUsers.description
2012-12-04 10:39:58.605 (5) [main]: 	skipping invalid column: searchEngineUsers.username
2012-12-04 10:39:58.605 (5) [main]: 	skipping invalid column: searchEngineUsers.password
2012-12-04 10:39:58.605 (5) [main]: 	skipping invalid column: searchEngineUsers.enabled
2012-12-04 10:39:58.605 (5) [main]: 	skipping invalid column: searchEngineUsers.inTsaMcc
2012-12-04 10:39:58.605 (5) [main]: 	skipping invalid column: searchEngineUsers.apiKey
2012-12-04 10:39:58.605 (5) [main]: 	skipping invalid column: searchEngineUsers.managerUsernames
2012-12-04 10:39:58.605 (5) [main]: 	skipping invalid column: searchEngineUsers.managerIDs
2012-12-04 10:39:58.605 (5) [main]: 	skipping invalid column: searchEngineUsers.lastChecked
2012-12-04 10:39:58.605 (5) [main]: 	skipping invalid column: searchEngineUsers.lastInMcc
2012-12-04 10:39:58.605 (5) [main]: 	skipping invalid column: searchEngineUsers.hidden
2012-12-04 10:39:58.606 (5) [main]: 	loaded column: accounts.id->898
2012-12-04 10:39:58.606 (5) [main]: 	loaded column: accounts.description->Rezonate - AT&T
2012-12-04 10:39:58.606 (5) [main]: 	loaded column: accounts.tier->2
2012-12-04 10:39:58.606 (5) [main]: 	loaded column: accounts.priority->50
2012-12-04 10:39:58.606 (5) [main]: 	loaded column: accounts.reportClicksOut->false
2012-12-04 10:39:58.606 (5) [main]: 	loaded column: accounts.reportConversions->false
2012-12-04 10:39:58.606 (5) [main]: 	loaded column: accounts.conversionTypes->
2012-12-04 10:39:58.606 (5) [main]: 	loaded column: accounts.isBidManaged->true
2012-12-04 10:39:58.606 (5) [main]: 	loaded column: accounts.isActive->true
2012-12-04 10:39:58.607 (5) [main]: 	loaded column: accounts.perfMetric->cpa
2012-12-04 10:39:58.607 (5) [main]: 	loaded column: accounts.providesConversionData->false
2012-12-04 10:39:58.607 (5) [main]: 	loaded column: accounts.addConversionData->false
2012-12-04 10:39:58.607 (5) [main]: 	loaded column: accounts.fractionalConversionCounts->false
2012-12-04 10:39:58.607 (5) [main]: 	loaded column: accounts.hideNullSources->false
2012-12-04 10:39:58.607 (5) [main]: 	loaded column: accounts.nowTime->null
2012-12-04 10:39:58.607 (5) [main]: 	loaded column: accounts.warehouseDatabase->warehouse_4
2012-12-04 10:39:58.607 (5) [main]: 	loaded column: accounts.databaseInstance->5
2012-12-04 10:39:58.607 (5) [main]: 	loaded column: accounts.warehouseInstance->7
2012-12-04 10:39:58.608 (5) [main]: 	loaded column: accounts.isOnline->true
2012-12-04 10:39:58.608 (5) [main]: 	loaded column: accounts.timeZoneID->2
2012-12-04 10:39:58.609 (4) [P2T2]: no account, or instance for databaseInstance, skipping lookup...
2012-12-04 10:39:58.610 (4) [P2T2]: Took Existing Object from Pool
2012-12-04 10:39:58.610 (5) [P2T2]: ProfilerRec.start("db",true) in Thread [P2T2]
2012-12-04 10:39:58.610 (4) [P2T2]: spike: SQL->[select @@version]
2012-12-04 10:39:58.612 (5) [P2T2]: recordAsSubs("db", 2, "P2T2")
2012-12-04 10:39:58.612 (5) [P2T2]: addSub("db")
2012-12-04 10:39:58.612 (5) [P2T2]: ProfilerRec.end("db", true): ret=2
2012-12-04 10:39:58.612 (4) [P2T2]: time=0.0020
2012-12-04 10:39:58.612 (4) [P2T2]: Query executed in 0.002s
2012-12-04 10:39:58.612 (4) [P2T2]: test query succeeded, returned "5.1.49-rel11.3-log"
2012-12-04 10:39:58.613 (5) [P2T2]: quoteValue(), nothing special about it=>[898], type=class java.lang.Integer
2012-12-04 10:39:58.613 (5) [P2T2]: ProfilerRec.start("db",true) in Thread [P2T2]
2012-12-04 10:39:58.613 (4) [P2T2]: spike: SQL->[select * from `tsacommon`.`accounts` where (`tsacommon`.`accounts`.`id`=898) limit 1]
2012-12-04 10:39:58.614 (5) [P2T2]: recordAsSubs("db", 1, "P2T2")
2012-12-04 10:39:58.614 (5) [P2T2]: addSub("db")
2012-12-04 10:39:58.614 (5) [P2T2]: ProfilerRec.end("db", true): ret=1
2012-12-04 10:39:58.614 (4) [P2T2]: time=0.0010
2012-12-04 10:39:58.615 (4) [P2T2]: Query executed in 0.001s
2012-12-04 10:39:58.615 (5) [P2T2]: loading 20 columns from result set:
2012-12-04 10:39:58.615 (5) [P2T2]: 	loaded column: accounts.id->898
2012-12-04 10:39:58.615 (5) [P2T2]: 	loaded column: accounts.description->Rezonate - AT&T
2012-12-04 10:39:58.615 (5) [P2T2]: 	loaded column: accounts.tier->2
2012-12-04 10:39:58.615 (5) [P2T2]: 	loaded column: accounts.priority->50
2012-12-04 10:39:58.616 (5) [P2T2]: 	loaded column: accounts.reportClicksOut->false
2012-12-04 10:39:58.616 (5) [P2T2]: 	loaded column: accounts.reportConversions->false
2012-12-04 10:39:58.616 (5) [P2T2]: 	loaded column: accounts.conversionTypes->
2012-12-04 10:39:58.616 (5) [P2T2]: 	loaded column: accounts.isBidManaged->true
2012-12-04 10:39:58.616 (5) [P2T2]: 	loaded column: accounts.isActive->true
2012-12-04 10:39:58.639 (5) [P2T2]: 	loaded column: accounts.perfMetric->cpa
2012-12-04 10:39:58.639 (5) [P2T2]: 	loaded column: accounts.providesConversionData->false
2012-12-04 10:39:58.640 (5) [P2T2]: 	loaded column: accounts.addConversionData->false
2012-12-04 10:39:58.640 (5) [P2T2]: 	loaded column: accounts.fractionalConversionCounts->false
2012-12-04 10:39:58.640 (5) [P2T2]: 	loaded column: accounts.hideNullSources->false
2012-12-04 10:39:58.640 (5) [P2T2]: 	loaded column: accounts.nowTime->null
2012-12-04 10:39:58.640 (5) [P2T2]: 	loaded column: accounts.warehouseDatabase->warehouse_4
2012-12-04 10:39:58.640 (5) [P2T2]: 	loaded column: accounts.databaseInstance->5
2012-12-04 10:39:58.640 (5) [P2T2]: 	loaded column: accounts.warehouseInstance->7
2012-12-04 10:39:58.640 (5) [P2T2]: 	loaded column: accounts.isOnline->true
2012-12-04 10:39:58.641 (5) [P2T2]: 	loaded column: accounts.timeZoneID->2
2012-12-04 10:39:58.641 (4) [P2T2]:   Record Loaded
2012-12-04 10:39:58.641 (4) [P2T2]: Returning Object to Pool
2012-12-04 10:39:58.641 (3) [P2T2]: Starting Account (69752) "ATT-WIC|Search-Mobile-Tablet|United States-English" for user (3177) "AT&T Pan Asian Youth Campaign"
2012-12-04 10:39:58.641 (3) [P2T2]: Sync Flag: false - syncGroups and syncListings skipped for (69752) "ATT-WIC|Search-Mobile-Tablet|United States-English" for user (3177) "AT&T Pan Asian Youth Campaign"
2012-12-04 10:39:58.641 (3) [P2T2]: Finished Account (69752) "ATT-WIC|Search-Mobile-Tablet|United States-English" for user (3177) "AT&T Pan Asian Youth Campaign"
2012-12-04 10:39:58.643 (4) [main]: no account, or instance for databaseInstance, skipping lookup...
2012-12-04 10:39:58.643 (4) [main]: Took Existing Object from Pool
2012-12-04 10:39:58.644 (5) [main]: ProfilerRec.start("db",true) in Thread [main]
2012-12-04 10:39:58.644 (4) [main]: spike: SQL->[select @@version]
2012-12-04 10:39:58.645 (5) [main]: recordAsSubs("db", 1, "main")
2012-12-04 10:39:58.646 (5) [main]: addSub("db")
2012-12-04 10:39:58.646 (5) [main]: ProfilerRec.end("db", true): ret=1
2012-12-04 10:39:58.646 (4) [main]: time=0.0010
2012-12-04 10:39:58.646 (4) [main]: Query executed in 0.001s
2012-12-04 10:39:58.646 (4) [main]: test query succeeded, returned "5.1.49-rel11.3-log"
2012-12-04 10:39:58.647 (5) [main]: quoteValue(), nothing special about it=>[3], type=class java.lang.Integer
2012-12-04 10:39:58.647 (5) [main]: ProfilerRec.start("db",true) in Thread [main]
2012-12-04 10:39:58.647 (4) [main]: spike: SQL->[select * from `tsacommon`.`distribution` where (`id`=3) limit 1]
2012-12-04 10:39:58.648 (5) [main]: recordAsSubs("db", 1, "main")
2012-12-04 10:39:58.648 (5) [main]: addSub("db")
2012-12-04 10:39:58.648 (5) [main]: ProfilerRec.end("db", true): ret=1
2012-12-04 10:39:58.648 (4) [main]: time=0.0010
2012-12-04 10:39:58.648 (4) [main]: Query executed in 0.001s
2012-12-04 10:39:58.649 (5) [main]: loading 19 columns from result set:
2012-12-04 10:39:58.649 (5) [main]: 	loaded column: distribution.id->3
2012-12-04 10:39:58.649 (5) [main]: 	loaded column: distribution.accountID->0
2012-12-04 10:39:58.649 (5) [main]: 	loaded column: distribution.siteID->0
2012-12-04 10:39:58.649 (5) [main]: 	loaded column: distribution.type->paid search
2012-12-04 10:39:58.649 (5) [main]: 	loaded column: distribution.channelID->1
2012-12-04 10:39:58.649 (5) [main]: 	loaded column: distribution.showStats->1
2012-12-04 10:39:58.650 (5) [main]: 	loaded column: distribution.bidMatchTypes->exact,phrase,broad,content
2012-12-04 10:39:58.650 (5) [main]: 	loaded column: distribution.trackMatchTypes->exact,phrase,broad,content
2012-12-04 10:39:58.650 (5) [main]: 	loaded column: distribution.mergeMatchTypeStats->false
2012-12-04 10:39:58.650 (5) [main]: 	loaded column: distribution.rollupMatchTypes->content
2012-12-04 10:39:58.650 (5) [main]: 	loaded column: distribution.positionalBidding->false
2012-12-04 10:39:58.650 (5) [main]: 	loaded column: distribution.description->Google AdWords
2012-12-04 10:39:58.650 (5) [main]: 	loaded column: distribution.shortCode->GO
2012-12-04 10:39:58.650 (5) [main]: 	loaded column: distribution.searchEngineClass->com.thesearchagency.searchengines.google.GoogleAPISearchEngine
2012-12-04 10:39:58.651 (5) [main]: 	loaded column: distribution.bidMinCPC->0.01
2012-12-04 10:39:58.651 (5) [main]: 	loaded column: distribution.bidCapCPC->100.0
2012-12-04 10:39:58.651 (5) [main]: 	loaded column: distribution.bidMinCPM->0.25
2012-12-04 10:39:58.651 (5) [main]: 	loaded column: distribution.bidCapCPM->500.0
2012-12-04 10:39:58.651 (5) [main]: 	skipping invalid column: distribution.obsolete
2012-12-04 10:39:58.651 (4) [main]:   Record Loaded
2012-12-04 10:39:58.651 (5) [main]: class name is "com.thesearchagency.searchengines.google.GoogleAPISearchEngine"
2012-12-04 10:39:58.652 (4) [main]: User  in TSA MCC, connecting using master username/password
2012-12-04 10:39:58.652 (4) [main]: client customer id = 9001082081
2012-12-04 10:39:58.652 (5) [main]: parseInteger->[3177]
2012-12-04 10:39:58.652 (5) [main]: parseInteger<-[3177]
2012-12-04 10:39:58.652 (4) [main]: seuserid[3177] username[null] password[null] customerID[9001082081]
2012-12-04 10:39:58.660 (4) [main]: Setting AuthToken [DQAAAJUAAABblTkk4samFeeIPZeA4b44C3w9CSZUFxB_1PKkgTJgM5Lgsa8hTds5kjeMJGa6cExwQnnIDV7Ug-KEY3tqzcq509ufM18E690NozMrYI1_ThysElNbsxM95UmDsdGckBnxsx2_W0beOdRfookxPexOo_l8H3BAtqbFpIIwgTH98LxImDZ0EQfjCTiZ49NAuNh3TJ7XbYd-0CN-WJfEw85Z] to AdWordsUser object for username[google@thesearchagency.com]
2012-12-04 10:39:58.698 (4) [main]: Returning Object to Pool
2012-12-04 10:39:58.699 (5) [main]: loading 56 columns from result set:
2012-12-04 10:39:58.699 (5) [main]: 	loaded column: searchEngineAccounts.id->69737
2012-12-04 10:39:58.699 (4) [P2T3]: no account, or instance for databaseInstance, skipping lookup...
2012-12-04 10:39:58.700 (5) [main]: 	loaded column: searchEngineAccounts.accountID->898
2012-12-04 10:39:58.700 (4) [P2T3]: Took Existing Object from Pool
2012-12-04 10:39:58.700 (5) [main]: 	loaded column: searchEngineAccounts.distributionID->3
2012-12-04 10:39:58.700 (5) [main]: 	loaded column: searchEngineAccounts.searchEngineUserID->3177
2012-12-04 10:39:58.701 (5) [P2T3]: ProfilerRec.start("db",true) in Thread [P2T3]
2012-12-04 10:39:58.701 (5) [main]: 	loaded column: searchEngineAccounts.description->ATT-WIC|GDN|Contextual-Desktop
2012-12-04 10:39:58.701 (4) [P2T3]: spike: SQL->[select @@version]
2012-12-04 10:39:58.701 (5) [main]: 	loaded column: searchEngineAccounts.shortCode->null
2012-12-04 10:39:58.702 (5) [main]: 	loaded column: searchEngineAccounts.paused->false
2012-12-04 10:39:58.702 (5) [main]: 	loaded column: searchEngineAccounts.searchEngineIdentifier->109102130
2012-12-04 10:39:58.702 (5) [main]: 	loaded column: searchEngineAccounts.searchEngineScope->
2012-12-04 10:39:58.702 (5) [main]: 	loaded column: searchEngineAccounts.inContent->true
2012-12-04 10:39:58.702 (5) [main]: 	loaded column: searchEngineAccounts.enabled->true
2012-12-04 10:39:58.702 (5) [main]: 	loaded column: searchEngineAccounts.useConversionData->false
2012-12-04 10:39:58.702 (5) [main]: 	loaded column: searchEngineAccounts.searchEngineStatus->ok
2012-12-04 10:39:58.703 (5) [P2T3]: recordAsSubs("db", 1, "P2T3")
2012-12-04 10:39:58.703 (5) [main]: 	loaded column: searchEngineAccounts.searchEngineStatusText->SERVING
2012-12-04 10:39:58.703 (5) [P2T3]: addSub("db")
2012-12-04 10:39:58.703 (5) [main]: 	loaded column: searchEngineAccounts.budgetType->dailyDivide
2012-12-04 10:39:58.704 (5) [P2T3]: ProfilerRec.end("db", true): ret=1
2012-12-04 10:39:58.704 (5) [main]: 	loaded column: searchEngineAccounts.budgetAmount->250.0
2012-12-04 10:39:58.704 (4) [P2T3]: time=0.0010
2012-12-04 10:39:58.704 (5) [main]: 	loaded column: searchEngineAccounts.lastChecked->2012-12-04 09:43:35.0
2012-12-04 10:39:58.705 (4) [P2T3]: Query executed in 0.001s
2012-12-04 10:39:58.705 (5) [main]: 	loaded column: searchEngineAccounts.networkType->CONTENT_NETWORK
2012-12-04 10:39:58.705 (4) [P2T3]: test query succeeded, returned "5.1.49-rel11.3-log"
2012-12-04 10:39:58.706 (5) [main]: 	loaded column: searchEngineAccounts.contentType->CONTENT_NETWORK
2012-12-04 10:39:58.706 (5) [P2T3]: quoteValue(), nothing special about it=>[898], type=class java.lang.Integer
2012-12-04 10:39:58.706 (5) [main]: 	loaded column: searchEngineAccounts.biddingStrategy->ManualCPC
2012-12-04 10:39:58.707 (5) [P2T3]: ProfilerRec.start("db",true) in Thread [P2T3]
2012-12-04 10:39:58.707 (5) [main]: 	loaded column: searchEngineAccounts.hidden->false
2012-12-04 10:39:58.707 (4) [P2T3]: spike: SQL->[select * from `tsacommon`.`accounts` where (`tsacommon`.`accounts`.`id`=898) limit 1]
2012-12-04 10:39:58.708 (5) [main]: 	skipping invalid column: searchEngineUsers.id
2012-12-04 10:39:58.724 (5) [main]: 	skipping invalid column: searchEngineUsers.accountID
2012-12-04 10:39:58.725 (5) [main]: 	skipping invalid column: searchEngineUsers.distributionID
2012-12-04 10:39:58.725 (5) [main]: 	skipping invalid column: searchEngineUsers.searchEngineIdentifier
2012-12-04 10:39:58.725 (5) [main]: 	skipping invalid column: searchEngineUsers.description
2012-12-04 10:39:58.725 (5) [main]: 	skipping invalid column: searchEngineUsers.username
2012-12-04 10:39:58.725 (5) [main]: 	skipping invalid column: searchEngineUsers.password
2012-12-04 10:39:58.725 (5) [main]: 	skipping invalid column: searchEngineUsers.enabled
2012-12-04 10:39:58.725 (5) [main]: 	skipping invalid column: searchEngineUsers.inTsaMcc
2012-12-04 10:39:58.725 (5) [main]: 	skipping invalid column: searchEngineUsers.apiKey
2012-12-04 10:39:58.725 (5) [main]: 	skipping invalid column: searchEngineUsers.managerUsernames
2012-12-04 10:39:58.726 (5) [main]: 	skipping invalid column: searchEngineUsers.managerIDs
2012-12-04 10:39:58.726 (5) [main]: 	skipping invalid column: searchEngineUsers.lastChecked
2012-12-04 10:39:58.726 (5) [main]: 	skipping invalid column: searchEngineUsers.lastInMcc
2012-12-04 10:39:58.726 (5) [main]: 	skipping invalid column: searchEngineUsers.hidden
2012-12-04 10:39:58.726 (5) [main]: 	skipping invalid column: accounts.id
2012-12-04 10:39:58.726 (5) [main]: 	skipping invalid column: accounts.description
2012-12-04 10:39:58.726 (5) [main]: 	skipping invalid column: accounts.tier
2012-12-04 10:39:58.726 (5) [main]: 	skipping invalid column: accounts.priority
2012-12-04 10:39:58.726 (5) [main]: 	skipping invalid column: accounts.reportClicksOut
2012-12-04 10:39:58.726 (5) [main]: 	skipping invalid column: accounts.reportConversions
2012-12-04 10:39:58.727 (5) [main]: 	skipping invalid column: accounts.conversionTypes
2012-12-04 10:39:58.727 (5) [main]: 	skipping invalid column: accounts.isBidManaged
2012-12-04 10:39:58.727 (5) [main]: 	skipping invalid column: accounts.isActive
2012-12-04 10:39:58.727 (5) [main]: 	skipping invalid column: accounts.perfMetric
2012-12-04 10:39:58.727 (5) [main]: 	skipping invalid column: accounts.providesConversionData
2012-12-04 10:39:58.727 (5) [main]: 	skipping invalid column: accounts.addConversionData
2012-12-04 10:39:58.727 (5) [main]: 	skipping invalid column: accounts.fractionalConversionCounts
2012-12-04 10:39:58.727 (5) [main]: 	skipping invalid column: accounts.hideNullSources
2012-12-04 10:39:58.727 (5) [main]: 	skipping invalid column: accounts.nowTime
2012-12-04 10:39:58.727 (5) [main]: 	skipping invalid column: accounts.warehouseDatabase
2012-12-04 10:39:58.727 (5) [main]: 	skipping invalid column: accounts.databaseInstance
2012-12-04 10:39:58.728 (5) [main]: 	skipping invalid column: accounts.warehouseInstance
2012-12-04 10:39:58.728 (5) [main]: 	skipping invalid column: accounts.isOnline
2012-12-04 10:39:58.728 (5) [main]: 	skipping invalid column: accounts.timeZoneID
2012-12-04 10:39:58.728 (5) [main]: loading 56 columns from result set:
2012-12-04 10:39:58.728 (5) [main]: 	skipping invalid column: searchEngineAccounts.id
2012-12-04 10:39:58.728 (5) [main]: 	skipping invalid column: searchEngineAccounts.accountID
2012-12-04 10:39:58.728 (5) [main]: 	skipping invalid column: searchEngineAccounts.distributionID
2012-12-04 10:39:58.728 (5) [main]: 	skipping invalid column: searchEngineAccounts.searchEngineUserID
2012-12-04 10:39:58.729 (5) [main]: 	skipping invalid column: searchEngineAccounts.description
2012-12-04 10:39:58.729 (5) [main]: 	skipping invalid column: searchEngineAccounts.shortCode
2012-12-04 10:39:58.729 (5) [main]: 	skipping invalid column: searchEngineAccounts.paused
2012-12-04 10:39:58.729 (5) [main]: 	skipping invalid column: searchEngineAccounts.searchEngineIdentifier
2012-12-04 10:39:58.729 (5) [main]: 	skipping invalid column: searchEngineAccounts.searchEngineScope
2012-12-04 10:39:58.729 (5) [main]: 	skipping invalid column: searchEngineAccounts.inContent
2012-12-04 10:39:58.729 (5) [main]: 	skipping invalid column: searchEngineAccounts.enabled
2012-12-04 10:39:58.730 (5) [main]: 	skipping invalid column: searchEngineAccounts.useConversionData
2012-12-04 10:39:58.730 (5) [main]: 	skipping invalid column: searchEngineAccounts.searchEngineStatus
2012-12-04 10:39:58.730 (5) [main]: 	skipping invalid column: searchEngineAccounts.searchEngineStatusText
2012-12-04 10:39:58.730 (5) [main]: 	skipping invalid column: searchEngineAccounts.budgetType
2012-12-04 10:39:58.730 (5) [main]: 	skipping invalid column: searchEngineAccounts.budgetAmount
2012-12-04 10:39:58.730 (5) [main]: 	skipping invalid column: searchEngineAccounts.lastChecked
2012-12-04 10:39:58.730 (5) [main]: 	skipping invalid column: searchEngineAccounts.networkType
2012-12-04 10:39:58.730 (5) [main]: 	skipping invalid column: searchEngineAccounts.contentType
2012-12-04 10:39:58.730 (5) [main]: 	skipping invalid column: searchEngineAccounts.biddingStrategy
2012-12-04 10:39:58.730 (5) [main]: 	skipping invalid column: searchEngineAccounts.hidden
2012-12-04 10:39:58.731 (5) [main]: 	loaded column: searchEngineUsers.id->3177
2012-12-04 10:39:58.731 (5) [main]: 	loaded column: searchEngineUsers.accountID->898
2012-12-04 10:39:58.731 (5) [main]: 	loaded column: searchEngineUsers.distributionID->3
2012-12-04 10:39:58.731 (5) [main]: 	loaded column: searchEngineUsers.searchEngineIdentifier->9001082081
2012-12-04 10:39:58.731 (5) [main]: 	loaded column: searchEngineUsers.description->AT&T Pan Asian Youth Campaign
2012-12-04 10:39:58.731 (5) [main]: 	loaded column: searchEngineUsers.username->
2012-12-04 10:39:58.731 (5) [main]: 	loaded column: searchEngineUsers.password->
2012-12-04 10:39:58.731 (5) [main]: 	loaded column: searchEngineUsers.enabled->true
2012-12-04 10:39:58.732 (5) [main]: 	loaded column: searchEngineUsers.inTsaMcc->true
2012-12-04 10:39:58.732 (5) [main]: 	loaded column: searchEngineUsers.apiKey->
2012-12-04 10:39:58.732 (5) [main]: 	loaded column: searchEngineUsers.managerUsernames->null
2012-12-04 10:39:58.732 (5) [main]: 	loaded column: searchEngineUsers.managerIDs->1752475908,9136835500,9050076625
2012-12-04 10:39:58.732 (5) [main]: 	loaded column: searchEngineUsers.lastChecked->2012-12-04 09:52:27.0
2012-12-04 10:39:58.733 (5) [main]: 	loaded column: searchEngineUsers.lastInMcc->2012-12-04 08:20:17.0
2012-12-04 10:39:58.733 (5) [main]: 	skipping invalid column: searchEngineUsers.hidden
2012-12-04 10:39:58.733 (5) [main]: 	skipping invalid column: accounts.id
2012-12-04 10:39:58.733 (5) [main]: 	skipping invalid column: accounts.description
2012-12-04 10:39:58.733 (5) [main]: 	skipping invalid column: accounts.tier
2012-12-04 10:39:58.733 (5) [main]: 	skipping invalid column: accounts.priority
2012-12-04 10:39:58.733 (5) [main]: 	skipping invalid column: accounts.reportClicksOut
2012-12-04 10:39:58.733 (5) [main]: 	skipping invalid column: accounts.reportConversions
2012-12-04 10:39:58.733 (5) [main]: 	skipping invalid column: accounts.conversionTypes
2012-12-04 10:39:58.733 (5) [main]: 	skipping invalid column: accounts.isBidManaged
2012-12-04 10:39:58.734 (5) [main]: 	skipping invalid column: accounts.isActive
2012-12-04 10:39:58.734 (5) [main]: 	skipping invalid column: accounts.perfMetric
2012-12-04 10:39:58.734 (5) [main]: 	skipping invalid column: accounts.providesConversionData
2012-12-04 10:39:58.734 (5) [main]: 	skipping invalid column: accounts.addConversionData
2012-12-04 10:39:58.734 (5) [main]: 	skipping invalid column: accounts.fractionalConversionCounts
2012-12-04 10:39:58.734 (5) [main]: 	skipping invalid column: accounts.hideNullSources
2012-12-04 10:39:58.734 (5) [main]: 	skipping invalid column: accounts.nowTime
2012-12-04 10:39:58.734 (5) [main]: 	skipping invalid column: accounts.warehouseDatabase
2012-12-04 10:39:58.734 (5) [main]: 	skipping invalid column: accounts.databaseInstance
2012-12-04 10:39:58.734 (5) [main]: 	skipping invalid column: accounts.warehouseInstance
2012-12-04 10:39:58.735 (5) [main]: 	skipping invalid column: accounts.isOnline
2012-12-04 10:39:58.735 (5) [main]: 	skipping invalid column: accounts.timeZoneID
2012-12-04 10:39:58.735 (5) [main]: loading 56 columns from result set:
2012-12-04 10:39:58.735 (5) [main]: 	skipping invalid column: searchEngineAccounts.id
2012-12-04 10:39:58.735 (5) [main]: 	skipping invalid column: searchEngineAccounts.accountID
2012-12-04 10:39:58.735 (5) [main]: 	skipping invalid column: searchEngineAccounts.distributionID
2012-12-04 10:39:58.735 (5) [main]: 	skipping invalid column: searchEngineAccounts.searchEngineUserID
2012-12-04 10:39:58.735 (5) [main]: 	skipping invalid column: searchEngineAccounts.description
2012-12-04 10:39:58.735 (5) [main]: 	skipping invalid column: searchEngineAccounts.shortCode
2012-12-04 10:39:58.735 (5) [main]: 	skipping invalid column: searchEngineAccounts.paused
2012-12-04 10:39:58.736 (5) [main]: 	skipping invalid column: searchEngineAccounts.searchEngineIdentifier
2012-12-04 10:39:58.736 (5) [main]: 	skipping invalid column: searchEngineAccounts.searchEngineScope
2012-12-04 10:39:58.736 (5) [main]: 	skipping invalid column: searchEngineAccounts.inContent
2012-12-04 10:39:58.736 (5) [main]: 	skipping invalid column: searchEngineAccounts.enabled
2012-12-04 10:39:58.736 (5) [main]: 	skipping invalid column: searchEngineAccounts.useConversionData
2012-12-04 10:39:58.736 (5) [main]: 	skipping invalid column: searchEngineAccounts.searchEngineStatus
2012-12-04 10:39:58.736 (5) [main]: 	skipping invalid column: searchEngineAccounts.searchEngineStatusText
2012-12-04 10:39:58.736 (5) [main]: 	skipping invalid column: searchEngineAccounts.budgetType
2012-12-04 10:39:58.736 (5) [main]: 	skipping invalid column: searchEngineAccounts.budgetAmount
2012-12-04 10:39:58.736 (5) [main]: 	skipping invalid column: searchEngineAccounts.lastChecked
2012-12-04 10:39:58.737 (5) [main]: 	skipping invalid column: searchEngineAccounts.networkType
2012-12-04 10:39:58.737 (5) [main]: 	skipping invalid column: searchEngineAccounts.contentType
2012-12-04 10:39:58.737 (5) [main]: 	skipping invalid column: searchEngineAccounts.biddingStrategy
2012-12-04 10:39:58.737 (5) [main]: 	skipping invalid column: searchEngineAccounts.hidden
2012-12-04 10:39:58.737 (5) [main]: 	skipping invalid column: searchEngineUsers.id
2012-12-04 10:39:58.737 (5) [main]: 	skipping invalid column: searchEngineUsers.accountID
2012-12-04 10:39:58.737 (5) [main]: 	skipping invalid column: searchEngineUsers.distributionID
2012-12-04 10:39:58.737 (5) [main]: 	skipping invalid column: searchEngineUsers.searchEngineIdentifier
2012-12-04 10:39:58.737 (5) [main]: 	skipping invalid column: searchEngineUsers.description
2012-12-04 10:39:58.737 (5) [main]: 	skipping invalid column: searchEngineUsers.username
2012-12-04 10:39:58.738 (5) [main]: 	skipping invalid column: searchEngineUsers.password
2012-12-04 10:39:58.738 (5) [main]: 	skipping invalid column: searchEngineUsers.enabled
2012-12-04 10:39:58.738 (5) [main]: 	skipping invalid column: searchEngineUsers.inTsaMcc
2012-12-04 10:39:58.738 (5) [main]: 	skipping invalid column: searchEngineUsers.apiKey
2012-12-04 10:39:58.738 (5) [main]: 	skipping invalid column: searchEngineUsers.managerUsernames
2012-12-04 10:39:58.738 (5) [main]: 	skipping invalid column: searchEngineUsers.managerIDs
2012-12-04 10:39:58.738 (5) [main]: 	skipping invalid column: searchEngineUsers.lastChecked
2012-12-04 10:39:58.738 (5) [main]: 	skipping invalid column: searchEngineUsers.lastInMcc
2012-12-04 10:39:58.738 (5) [main]: 	skipping invalid column: searchEngineUsers.hidden
2012-12-04 10:39:58.738 (5) [main]: 	loaded column: accounts.id->898
2012-12-04 10:39:58.739 (5) [main]: 	loaded column: accounts.description->Rezonate - AT&T
2012-12-04 10:39:58.739 (5) [main]: 	loaded column: accounts.tier->2
2012-12-04 10:39:58.739 (5) [main]: 	loaded column: accounts.priority->50
2012-12-04 10:39:58.739 (5) [main]: 	loaded column: accounts.reportClicksOut->false
2012-12-04 10:39:58.739 (5) [main]: 	loaded column: accounts.reportConversions->false
2012-12-04 10:39:58.739 (5) [main]: 	loaded column: accounts.conversionTypes->
2012-12-04 10:39:58.739 (5) [main]: 	loaded column: accounts.isBidManaged->true
2012-12-04 10:39:58.739 (5) [main]: 	loaded column: accounts.isActive->true
2012-12-04 10:39:58.739 (5) [main]: 	loaded column: accounts.perfMetric->cpa
2012-12-04 10:39:58.740 (5) [main]: 	loaded column: accounts.providesConversionData->false
2012-12-04 10:39:58.740 (5) [main]: 	loaded column: accounts.addConversionData->false
2012-12-04 10:39:58.740 (5) [main]: 	loaded column: accounts.fractionalConversionCounts->false
2012-12-04 10:39:58.740 (5) [main]: 	loaded column: accounts.hideNullSources->false
2012-12-04 10:39:58.740 (5) [main]: 	loaded column: accounts.nowTime->null
2012-12-04 10:39:58.740 (5) [main]: 	loaded column: accounts.warehouseDatabase->warehouse_4
2012-12-04 10:39:58.740 (5) [main]: 	loaded column: accounts.databaseInstance->5
2012-12-04 10:39:58.740 (5) [main]: 	loaded column: accounts.warehouseInstance->7
2012-12-04 10:39:58.740 (5) [main]: 	loaded column: accounts.isOnline->true
2012-12-04 10:39:58.741 (5) [main]: 	loaded column: accounts.timeZoneID->2
2012-12-04 10:39:58.745 (5) [P2T3]: recordAsSubs("db", 2, "P2T3")
2012-12-04 10:39:58.745 (5) [P2T3]: addSub("db")
2012-12-04 10:39:58.745 (5) [P2T3]: ProfilerRec.end("db", true): ret=2
2012-12-04 10:39:58.746 (4) [P2T3]: time=0.0020
2012-12-04 10:39:58.746 (4) [P2T3]: Query executed in 0.002s
2012-12-04 10:39:58.746 (5) [P2T3]: loading 20 columns from result set:
2012-12-04 10:39:58.746 (5) [P2T3]: 	loaded column: accounts.id->898
2012-12-04 10:39:58.747 (5) [P2T3]: 	loaded column: accounts.description->Rezonate - AT&T
2012-12-04 10:39:58.747 (5) [P2T3]: 	loaded column: accounts.tier->2
2012-12-04 10:39:58.747 (5) [P2T3]: 	loaded column: accounts.priority->50
2012-12-04 10:39:58.747 (5) [P2T3]: 	loaded column: accounts.reportClicksOut->false
2012-12-04 10:39:58.747 (5) [P2T3]: 	loaded column: accounts.reportConversions->false
2012-12-04 10:39:58.747 (5) [P2T3]: 	loaded column: accounts.conversionTypes->
2012-12-04 10:39:58.748 (5) [P2T3]: 	loaded column: accounts.isBidManaged->true
2012-12-04 10:39:58.748 (5) [P2T3]: 	loaded column: accounts.isActive->true
2012-12-04 10:39:58.748 (5) [P2T3]: 	loaded column: accounts.perfMetric->cpa
2012-12-04 10:39:58.748 (5) [P2T3]: 	loaded column: accounts.providesConversionData->false
2012-12-04 10:39:58.748 (5) [P2T3]: 	loaded column: accounts.addConversionData->false
2012-12-04 10:39:58.748 (5) [P2T3]: 	loaded column: accounts.fractionalConversionCounts->false
2012-12-04 10:39:58.753 (4) [main]: no account, or instance for databaseInstance, skipping lookup...
2012-12-04 10:39:58.754 (4) [main]: Took Existing Object from Pool
2012-12-04 10:39:58.754 (5) [main]: ProfilerRec.start("db",true) in Thread [main]
2012-12-04 10:39:58.754 (4) [main]: spike: SQL->[select @@version]
2012-12-04 10:39:58.755 (5) [P2T3]: 	loaded column: accounts.hideNullSources->false
2012-12-04 10:39:58.756 (5) [main]: recordAsSubs("db", 2, "main")
2012-12-04 10:39:58.756 (5) [main]: addSub("db")
2012-12-04 10:39:58.756 (5) [main]: ProfilerRec.end("db", true): ret=2
2012-12-04 10:39:58.756 (4) [main]: time=0.0020
2012-12-04 10:39:58.757 (4) [main]: Query executed in 0.002s
2012-12-04 10:39:58.757 (4) [main]: test query succeeded, returned "5.1.49-rel11.3-log"
2012-12-04 10:39:58.757 (5) [main]: quoteValue(), nothing special about it=>[3], type=class java.lang.Integer
2012-12-04 10:39:58.757 (5) [main]: ProfilerRec.start("db",true) in Thread [main]
2012-12-04 10:39:58.757 (4) [main]: spike: SQL->[select * from `tsacommon`.`distribution` where (`id`=3) limit 1]
2012-12-04 10:39:58.758 (5) [P2T3]: 	loaded column: accounts.nowTime->null
2012-12-04 10:39:58.759 (5) [main]: recordAsSubs("db", 2, "main")
2012-12-04 10:39:58.759 (5) [main]: addSub("db")
2012-12-04 10:39:58.759 (5) [main]: ProfilerRec.end("db", true): ret=2
2012-12-04 10:39:58.759 (4) [main]: time=0.0020
2012-12-04 10:39:58.759 (4) [main]: Query executed in 0.002s
2012-12-04 10:39:58.760 (5) [main]: loading 19 columns from result set:
2012-12-04 10:39:58.760 (5) [main]: 	loaded column: distribution.id->3
2012-12-04 10:39:58.760 (5) [main]: 	loaded column: distribution.accountID->0
2012-12-04 10:39:58.760 (5) [main]: 	loaded column: distribution.siteID->0
2012-12-04 10:39:58.760 (5) [main]: 	loaded column: distribution.type->paid search
2012-12-04 10:39:58.760 (5) [main]: 	loaded column: distribution.channelID->1
2012-12-04 10:39:58.761 (5) [main]: 	loaded column: distribution.showStats->1
2012-12-04 10:39:58.761 (5) [main]: 	loaded column: distribution.bidMatchTypes->exact,phrase,broad,content
2012-12-04 10:39:58.761 (5) [main]: 	loaded column: distribution.trackMatchTypes->exact,phrase,broad,content
2012-12-04 10:39:58.761 (5) [main]: 	loaded column: distribution.mergeMatchTypeStats->false
2012-12-04 10:39:58.761 (5) [main]: 	loaded column: distribution.rollupMatchTypes->content
2012-12-04 10:39:58.761 (5) [main]: 	loaded column: distribution.positionalBidding->false
2012-12-04 10:39:58.761 (5) [main]: 	loaded column: distribution.description->Google AdWords
2012-12-04 10:39:58.761 (5) [main]: 	loaded column: distribution.shortCode->GO
2012-12-04 10:39:58.762 (5) [main]: 	loaded column: distribution.searchEngineClass->com.thesearchagency.searchengines.google.GoogleAPISearchEngine
2012-12-04 10:39:58.762 (5) [main]: 	loaded column: distribution.bidMinCPC->0.01
2012-12-04 10:39:58.762 (5) [main]: 	loaded column: distribution.bidCapCPC->100.0
2012-12-04 10:39:58.762 (5) [main]: 	loaded column: distribution.bidMinCPM->0.25
2012-12-04 10:39:58.762 (5) [main]: 	loaded column: distribution.bidCapCPM->500.0
2012-12-04 10:39:58.762 (5) [main]: 	skipping invalid column: distribution.obsolete
2012-12-04 10:39:58.762 (4) [main]:   Record Loaded
2012-12-04 10:39:58.763 (5) [main]: class name is "com.thesearchagency.searchengines.google.GoogleAPISearchEngine"
2012-12-04 10:39:58.763 (4) [main]: User  in TSA MCC, connecting using master username/password
2012-12-04 10:39:58.763 (4) [main]: client customer id = 9001082081
2012-12-04 10:39:58.763 (5) [main]: parseInteger->[3177]
2012-12-04 10:39:58.763 (5) [main]: parseInteger<-[3177]
2012-12-04 10:39:58.763 (4) [main]: seuserid[3177] username[null] password[null] customerID[9001082081]
2012-12-04 10:39:58.775 (4) [main]: Setting AuthToken [DQAAAJUAAABblTkk4samFeeIPZeA4b44C3w9CSZUFxB_1PKkgTJgM5Lgsa8hTds5kjeMJGa6cExwQnnIDV7Ug-KEY3tqzcq509ufM18E690NozMrYI1_ThysElNbsxM95UmDsdGckBnxsx2_W0beOdRfookxPexOo_l8H3BAtqbFpIIwgTH98LxImDZ0EQfjCTiZ49NAuNh3TJ7XbYd-0CN-WJfEw85Z] to AdWordsUser object for username[google@thesearchagency.com]
2012-12-04 10:39:58.802 (4) [main]: Returning Object to Pool
2012-12-04 10:39:58.804 (5) [P2T3]: 	loaded column: accounts.warehouseDatabase->warehouse_4
2012-12-04 10:39:58.804 (5) [P2T3]: 	loaded column: accounts.databaseInstance->5
2012-12-04 10:39:58.804 (5) [P2T3]: 	loaded column: accounts.warehouseInstance->7
2012-12-04 10:39:58.804 (5) [P2T3]: 	loaded column: accounts.isOnline->true
2012-12-04 10:39:58.805 (5) [P2T3]: 	loaded column: accounts.timeZoneID->2
2012-12-04 10:39:58.805 (4) [P2T3]:   Record Loaded
2012-12-04 10:39:58.805 (4) [P2T3]: Returning Object to Pool
2012-12-04 10:39:58.805 (3) [P2T3]: Starting Account (69753) "ATT-WIC|Search-Desktop|United States-English" for user (3177) "AT&T Pan Asian Youth Campaign"
2012-12-04 10:39:58.805 (3) [P2T3]: Sync Flag: false - syncGroups and syncListings skipped for (69753) "ATT-WIC|Search-Desktop|United States-English" for user (3177) "AT&T Pan Asian Youth Campaign"
2012-12-04 10:39:58.805 (3) [P2T3]: Finished Account (69753) "ATT-WIC|Search-Desktop|United States-English" for user (3177) "AT&T Pan Asian Youth Campaign"
2012-12-04 10:39:58.805 (5) [main]: loading 56 columns from result set:
2012-12-04 10:39:58.806 (5) [main]: 	loaded column: searchEngineAccounts.id->69733
2012-12-04 10:39:58.806 (5) [main]: 	loaded column: searchEngineAccounts.accountID->898
2012-12-04 10:39:58.806 (5) [main]: 	loaded column: searchEngineAccounts.distributionID->3
2012-12-04 10:39:58.806 (5) [main]: 	loaded column: searchEngineAccounts.searchEngineUserID->3177
2012-12-04 10:39:58.806 (5) [main]: 	loaded column: searchEngineAccounts.description->ATT-WIC|GDN|Contextual-Mobile
2012-12-04 10:39:58.806 (5) [main]: 	loaded column: searchEngineAccounts.shortCode->null
2012-12-04 10:39:58.806 (5) [main]: 	loaded column: searchEngineAccounts.paused->false
2012-12-04 10:39:58.807 (5) [main]: 	loaded column: searchEngineAccounts.searchEngineIdentifier->109102010
2012-12-04 10:39:58.807 (5) [main]: 	loaded column: searchEngineAccounts.searchEngineScope->
2012-12-04 10:39:58.807 (5) [main]: 	loaded column: searchEngineAccounts.inContent->true
2012-12-04 10:39:58.807 (5) [main]: 	loaded column: searchEngineAccounts.enabled->true
2012-12-04 10:39:58.807 (5) [main]: 	loaded column: searchEngineAccounts.useConversionData->false
2012-12-04 10:39:58.807 (5) [main]: 	loaded column: searchEngineAccounts.searchEngineStatus->ok
2012-12-04 10:39:58.807 (5) [main]: 	loaded column: searchEngineAccounts.searchEngineStatusText->SERVING
2012-12-04 10:39:58.807 (5) [main]: 	loaded column: searchEngineAccounts.budgetType->dailyDivide
2012-12-04 10:39:58.808 (5) [main]: 	loaded column: searchEngineAccounts.budgetAmount->140.0
2012-12-04 10:39:58.808 (5) [main]: 	loaded column: searchEngineAccounts.lastChecked->2012-12-04 09:43:37.0
2012-12-04 10:39:58.808 (5) [main]: 	loaded column: searchEngineAccounts.networkType->CONTENT_NETWORK
2012-12-04 10:39:58.808 (5) [main]: 	loaded column: searchEngineAccounts.contentType->CONTENT_NETWORK
2012-12-04 10:39:58.809 (5) [main]: 	loaded column: searchEngineAccounts.biddingStrategy->ManualCPC
2012-12-04 10:39:58.809 (5) [main]: 	loaded column: searchEngineAccounts.hidden->false
2012-12-04 10:39:58.809 (5) [main]: 	skipping invalid column: searchEngineUsers.id
2012-12-04 10:39:58.809 (5) [main]: 	skipping invalid column: searchEngineUsers.accountID
2012-12-04 10:39:58.809 (5) [main]: 	skipping invalid column: searchEngineUsers.distributionID
2012-12-04 10:39:58.809 (5) [main]: 	skipping invalid column: searchEngineUsers.searchEngineIdentifier
2012-12-04 10:39:58.809 (5) [main]: 	skipping invalid column: searchEngineUsers.description
2012-12-04 10:39:58.809 (5) [main]: 	skipping invalid column: searchEngineUsers.username
2012-12-04 10:39:58.810 (5) [main]: 	skipping invalid column: searchEngineUsers.password
2012-12-04 10:39:58.810 (5) [main]: 	skipping invalid column: searchEngineUsers.enabled
2012-12-04 10:39:58.810 (5) [main]: 	skipping invalid column: searchEngineUsers.inTsaMcc
2012-12-04 10:39:58.810 (5) [main]: 	skipping invalid column: searchEngineUsers.apiKey
2012-12-04 10:39:58.810 (5) [main]: 	skipping invalid column: searchEngineUsers.managerUsernames
2012-12-04 10:39:58.810 (5) [main]: 	skipping invalid column: searchEngineUsers.managerIDs
2012-12-04 10:39:58.810 (5) [main]: 	skipping invalid column: searchEngineUsers.lastChecked
2012-12-04 10:39:58.810 (5) [main]: 	skipping invalid column: searchEngineUsers.lastInMcc
2012-12-04 10:39:58.810 (5) [main]: 	skipping invalid column: searchEngineUsers.hidden
2012-12-04 10:39:58.811 (5) [main]: 	skipping invalid column: accounts.id
2012-12-04 10:39:58.811 (5) [main]: 	skipping invalid column: accounts.description
2012-12-04 10:39:58.811 (5) [main]: 	skipping invalid column: accounts.tier
2012-12-04 10:39:58.811 (5) [main]: 	skipping invalid column: accounts.priority
2012-12-04 10:39:58.811 (5) [main]: 	skipping invalid column: accounts.reportClicksOut
2012-12-04 10:39:58.811 (5) [main]: 	skipping invalid column: accounts.reportConversions
2012-12-04 10:39:58.811 (5) [main]: 	skipping invalid column: accounts.conversionTypes
2012-12-04 10:39:58.812 (5) [main]: 	skipping invalid column: accounts.isBidManaged
2012-12-04 10:39:58.812 (5) [main]: 	skipping invalid column: accounts.isActive
2012-12-04 10:39:58.812 (5) [main]: 	skipping invalid column: accounts.perfMetric
2012-12-04 10:39:58.812 (5) [main]: 	skipping invalid column: accounts.providesConversionData
2012-12-04 10:39:58.812 (5) [main]: 	skipping invalid column: accounts.addConversionData
2012-12-04 10:39:58.812 (5) [main]: 	skipping invalid column: accounts.fractionalConversionCounts
2012-12-04 10:39:58.812 (5) [main]: 	skipping invalid column: accounts.hideNullSources
2012-12-04 10:39:58.812 (5) [main]: 	skipping invalid column: accounts.nowTime
2012-12-04 10:39:58.812 (5) [main]: 	skipping invalid column: accounts.warehouseDatabase
2012-12-04 10:39:58.813 (5) [main]: 	skipping invalid column: accounts.databaseInstance
2012-12-04 10:39:58.813 (5) [main]: 	skipping invalid column: accounts.warehouseInstance
2012-12-04 10:39:58.813 (5) [main]: 	skipping invalid column: accounts.isOnline
2012-12-04 10:39:58.813 (5) [main]: 	skipping invalid column: accounts.timeZoneID
2012-12-04 10:39:58.813 (5) [main]: loading 56 columns from result set:
2012-12-04 10:39:58.813 (5) [main]: 	skipping invalid column: searchEngineAccounts.id
2012-12-04 10:39:58.813 (5) [main]: 	skipping invalid column: searchEngineAccounts.accountID
2012-12-04 10:39:58.813 (5) [main]: 	skipping invalid column: searchEngineAccounts.distributionID
2012-12-04 10:39:58.813 (5) [main]: 	skipping invalid column: searchEngineAccounts.searchEngineUserID
2012-12-04 10:39:58.814 (5) [main]: 	skipping invalid column: searchEngineAccounts.description
2012-12-04 10:39:58.814 (5) [main]: 	skipping invalid column: searchEngineAccounts.shortCode
2012-12-04 10:39:58.814 (5) [main]: 	skipping invalid column: searchEngineAccounts.paused
2012-12-04 10:39:58.814 (5) [main]: 	skipping invalid column: searchEngineAccounts.searchEngineIdentifier
2012-12-04 10:39:58.814 (5) [main]: 	skipping invalid column: searchEngineAccounts.searchEngineScope
2012-12-04 10:39:58.814 (5) [main]: 	skipping invalid column: searchEngineAccounts.inContent
2012-12-04 10:39:58.814 (5) [main]: 	skipping invalid column: searchEngineAccounts.enabled
2012-12-04 10:39:58.814 (5) [main]: 	skipping invalid column: searchEngineAccounts.useConversionData
2012-12-04 10:39:58.814 (5) [main]: 	skipping invalid column: searchEngineAccounts.searchEngineStatus
2012-12-04 10:39:58.814 (5) [main]: 	skipping invalid column: searchEngineAccounts.searchEngineStatusText
2012-12-04 10:39:58.815 (5) [main]: 	skipping invalid column: searchEngineAccounts.budgetType
2012-12-04 10:39:58.815 (5) [main]: 	skipping invalid column: searchEngineAccounts.budgetAmount
2012-12-04 10:39:58.815 (5) [main]: 	skipping invalid column: searchEngineAccounts.lastChecked
2012-12-04 10:39:58.815 (5) [main]: 	skipping invalid column: searchEngineAccounts.networkType
2012-12-04 10:39:58.815 (5) [main]: 	skipping invalid column: searchEngineAccounts.contentType
2012-12-04 10:39:58.815 (5) [main]: 	skipping invalid column: searchEngineAccounts.biddingStrategy
2012-12-04 10:39:58.815 (5) [main]: 	skipping invalid column: searchEngineAccounts.hidden
2012-12-04 10:39:58.815 (5) [main]: 	loaded column: searchEngineUsers.id->3177
2012-12-04 10:39:58.815 (5) [main]: 	loaded column: searchEngineUsers.accountID->898
2012-12-04 10:39:58.815 (5) [main]: 	loaded column: searchEngineUsers.distributionID->3
2012-12-04 10:39:58.816 (5) [main]: 	loaded column: searchEngineUsers.searchEngineIdentifier->9001082081
2012-12-04 10:39:58.816 (5) [main]: 	loaded column: searchEngineUsers.description->AT&T Pan Asian Youth Campaign
2012-12-04 10:39:58.816 (5) [main]: 	loaded column: searchEngineUsers.username->
2012-12-04 10:39:58.816 (5) [main]: 	loaded column: searchEngineUsers.password->
2012-12-04 10:39:58.816 (5) [main]: 	loaded column: searchEngineUsers.enabled->true
2012-12-04 10:39:58.816 (5) [main]: 	loaded column: searchEngineUsers.inTsaMcc->true
2012-12-04 10:39:58.816 (5) [main]: 	loaded column: searchEngineUsers.apiKey->
2012-12-04 10:39:58.816 (5) [main]: 	loaded column: searchEngineUsers.managerUsernames->null
2012-12-04 10:39:58.816 (5) [main]: 	loaded column: searchEngineUsers.managerIDs->1752475908,9136835500,9050076625
2012-12-04 10:39:58.817 (5) [main]: 	loaded column: searchEngineUsers.lastChecked->2012-12-04 09:52:27.0
2012-12-04 10:39:58.817 (5) [main]: 	loaded column: searchEngineUsers.lastInMcc->2012-12-04 08:20:17.0
2012-12-04 10:39:58.817 (5) [main]: 	skipping invalid column: searchEngineUsers.hidden
2012-12-04 10:39:58.817 (5) [main]: 	skipping invalid column: accounts.id
2012-12-04 10:39:58.817 (5) [main]: 	skipping invalid column: accounts.description
2012-12-04 10:39:58.817 (5) [main]: 	skipping invalid column: accounts.tier
2012-12-04 10:39:58.818 (5) [main]: 	skipping invalid column: accounts.priority
2012-12-04 10:39:58.818 (5) [main]: 	skipping invalid column: accounts.reportClicksOut
2012-12-04 10:39:58.818 (5) [main]: 	skipping invalid column: accounts.reportConversions
2012-12-04 10:39:58.818 (5) [main]: 	skipping invalid column: accounts.conversionTypes
2012-12-04 10:39:58.818 (5) [main]: 	skipping invalid column: accounts.isBidManaged
2012-12-04 10:39:58.818 (5) [main]: 	skipping invalid column: accounts.isActive
2012-12-04 10:39:58.818 (5) [main]: 	skipping invalid column: accounts.perfMetric
2012-12-04 10:39:58.818 (5) [main]: 	skipping invalid column: accounts.providesConversionData
2012-12-04 10:39:58.818 (5) [main]: 	skipping invalid column: accounts.addConversionData
2012-12-04 10:39:58.818 (5) [main]: 	skipping invalid column: accounts.fractionalConversionCounts
2012-12-04 10:39:58.818 (5) [main]: 	skipping invalid column: accounts.hideNullSources
2012-12-04 10:39:58.819 (5) [main]: 	skipping invalid column: accounts.nowTime
2012-12-04 10:39:58.819 (5) [main]: 	skipping invalid column: accounts.warehouseDatabase
2012-12-04 10:39:58.819 (5) [main]: 	skipping invalid column: accounts.databaseInstance
2012-12-04 10:39:58.819 (5) [main]: 	skipping invalid column: accounts.warehouseInstance
2012-12-04 10:39:58.819 (5) [main]: 	skipping invalid column: accounts.isOnline
2012-12-04 10:39:58.819 (5) [main]: 	skipping invalid column: accounts.timeZoneID
2012-12-04 10:39:58.819 (5) [main]: loading 56 columns from result set:
2012-12-04 10:39:58.819 (5) [main]: 	skipping invalid column: searchEngineAccounts.id
2012-12-04 10:39:58.819 (5) [main]: 	skipping invalid column: searchEngineAccounts.accountID
2012-12-04 10:39:58.819 (5) [main]: 	skipping invalid column: searchEngineAccounts.distributionID
2012-12-04 10:39:58.819 (5) [main]: 	skipping invalid column: searchEngineAccounts.searchEngineUserID
2012-12-04 10:39:58.820 (5) [main]: 	skipping invalid column: searchEngineAccounts.description
2012-12-04 10:39:58.820 (5) [main]: 	skipping invalid column: searchEngineAccounts.shortCode
2012-12-04 10:39:58.820 (5) [main]: 	skipping invalid column: searchEngineAccounts.paused
2012-12-04 10:39:58.820 (5) [main]: 	skipping invalid column: searchEngineAccounts.searchEngineIdentifier
2012-12-04 10:39:58.820 (5) [main]: 	skipping invalid column: searchEngineAccounts.searchEngineScope
2012-12-04 10:39:58.820 (5) [main]: 	skipping invalid column: searchEngineAccounts.inContent
2012-12-04 10:39:58.820 (5) [main]: 	skipping invalid column: searchEngineAccounts.enabled
2012-12-04 10:39:58.820 (5) [main]: 	skipping invalid column: searchEngineAccounts.useConversionData
2012-12-04 10:39:58.820 (5) [main]: 	skipping invalid column: searchEngineAccounts.searchEngineStatus
2012-12-04 10:39:58.820 (5) [main]: 	skipping invalid column: searchEngineAccounts.searchEngineStatusText
2012-12-04 10:39:58.821 (5) [main]: 	skipping invalid column: searchEngineAccounts.budgetType
2012-12-04 10:39:58.821 (5) [main]: 	skipping invalid column: searchEngineAccounts.budgetAmount
2012-12-04 10:39:58.821 (5) [main]: 	skipping invalid column: searchEngineAccounts.lastChecked
2012-12-04 10:39:58.821 (5) [main]: 	skipping invalid column: searchEngineAccounts.networkType
2012-12-04 10:39:58.821 (5) [main]: 	skipping invalid column: searchEngineAccounts.contentType
2012-12-04 10:39:58.821 (5) [main]: 	skipping invalid column: searchEngineAccounts.biddingStrategy
2012-12-04 10:39:58.821 (5) [main]: 	skipping invalid column: searchEngineAccounts.hidden
2012-12-04 10:39:58.821 (5) [main]: 	skipping invalid column: searchEngineUsers.id
2012-12-04 10:39:58.821 (5) [main]: 	skipping invalid column: searchEngineUsers.accountID
2012-12-04 10:39:58.822 (5) [main]: 	skipping invalid column: searchEngineUsers.distributionID
2012-12-04 10:39:58.822 (5) [main]: 	skipping invalid column: searchEngineUsers.searchEngineIdentifier
2012-12-04 10:39:58.822 (5) [main]: 	skipping invalid column: searchEngineUsers.description
2012-12-04 10:39:58.822 (5) [main]: 	skipping invalid column: searchEngineUsers.username
2012-12-04 10:39:58.822 (5) [main]: 	skipping invalid column: searchEngineUsers.password
2012-12-04 10:39:58.822 (5) [main]: 	skipping invalid column: searchEngineUsers.enabled
2012-12-04 10:39:58.822 (5) [main]: 	skipping invalid column: searchEngineUsers.inTsaMcc
2012-12-04 10:39:58.822 (5) [main]: 	skipping invalid column: searchEngineUsers.apiKey
2012-12-04 10:39:58.822 (5) [main]: 	skipping invalid column: searchEngineUsers.managerUsernames
2012-12-04 10:39:58.822 (5) [main]: 	skipping invalid column: searchEngineUsers.managerIDs
2012-12-04 10:39:58.822 (5) [main]: 	skipping invalid column: searchEngineUsers.lastChecked
2012-12-04 10:39:58.823 (5) [main]: 	skipping invalid column: searchEngineUsers.lastInMcc
2012-12-04 10:39:58.823 (5) [main]: 	skipping invalid column: searchEngineUsers.hidden
2012-12-04 10:39:58.823 (5) [main]: 	loaded column: accounts.id->898
2012-12-04 10:39:58.823 (5) [main]: 	loaded column: accounts.description->Rezonate - AT&T
2012-12-04 10:39:58.823 (5) [main]: 	loaded column: accounts.tier->2
2012-12-04 10:39:58.823 (5) [main]: 	loaded column: accounts.priority->50
2012-12-04 10:39:58.823 (5) [main]: 	loaded column: accounts.reportClicksOut->false
2012-12-04 10:39:58.823 (5) [main]: 	loaded column: accounts.reportConversions->false
2012-12-04 10:39:58.823 (5) [main]: 	loaded column: accounts.conversionTypes->
2012-12-04 10:39:58.824 (5) [main]: 	loaded column: accounts.isBidManaged->true
2012-12-04 10:39:58.824 (5) [main]: 	loaded column: accounts.isActive->true
2012-12-04 10:39:58.824 (5) [main]: 	loaded column: accounts.perfMetric->cpa
2012-12-04 10:39:58.824 (5) [main]: 	loaded column: accounts.providesConversionData->false
2012-12-04 10:39:58.824 (5) [main]: 	loaded column: accounts.addConversionData->false
2012-12-04 10:39:58.824 (5) [main]: 	loaded column: accounts.fractionalConversionCounts->false
2012-12-04 10:39:58.824 (5) [main]: 	loaded column: accounts.hideNullSources->false
2012-12-04 10:39:58.824 (5) [main]: 	loaded column: accounts.nowTime->null
2012-12-04 10:39:58.824 (5) [main]: 	loaded column: accounts.warehouseDatabase->warehouse_4
2012-12-04 10:39:58.824 (5) [main]: 	loaded column: accounts.databaseInstance->5
2012-12-04 10:39:58.825 (5) [main]: 	loaded column: accounts.warehouseInstance->7
2012-12-04 10:39:58.825 (5) [main]: 	loaded column: accounts.isOnline->true
2012-12-04 10:39:58.825 (5) [main]: 	loaded column: accounts.timeZoneID->2
2012-12-04 10:39:58.829 (4) [P2T4]: no account, or instance for databaseInstance, skipping lookup...
2012-12-04 10:39:58.830 (4) [P2T4]: Took Existing Object from Pool
2012-12-04 10:39:58.830 (5) [P2T4]: ProfilerRec.start("db",true) in Thread [P2T4]
2012-12-04 10:39:58.830 (4) [P2T4]: spike: SQL->[select @@version]
2012-12-04 10:39:58.838 (4) [main]: no account, or instance for databaseInstance, skipping lookup...
2012-12-04 10:39:58.839 (4) [main]: Took Existing Object from Pool
2012-12-04 10:39:58.839 (5) [main]: ProfilerRec.start("db",true) in Thread [main]
2012-12-04 10:39:58.839 (4) [main]: spike: SQL->[select @@version]
2012-12-04 10:39:58.841 (5) [main]: recordAsSubs("db", 2, "main")
2012-12-04 10:39:58.841 (5) [main]: addSub("db")
2012-12-04 10:39:58.842 (5) [main]: ProfilerRec.end("db", true): ret=2
2012-12-04 10:39:58.842 (4) [main]: time=0.0020
2012-12-04 10:39:58.842 (4) [main]: Query executed in 0.002s
2012-12-04 10:39:58.842 (4) [main]: test query succeeded, returned "5.1.49-rel11.3-log"
2012-12-04 10:39:58.843 (5) [main]: quoteValue(), nothing special about it=>[3], type=class java.lang.Integer
2012-12-04 10:39:58.843 (5) [main]: ProfilerRec.start("db",true) in Thread [main]
2012-12-04 10:39:58.843 (4) [main]: spike: SQL->[select * from `tsacommon`.`distribution` where (`id`=3) limit 1]
2012-12-04 10:39:58.844 (5) [P2T4]: recordAsSubs("db", 14, "P2T4")
2012-12-04 10:39:58.844 (5) [P2T4]: addSub("db")
2012-12-04 10:39:58.844 (5) [P2T4]: ProfilerRec.end("db", true): ret=14
2012-12-04 10:39:58.844 (4) [P2T4]: time=0.014
2012-12-04 10:39:58.844 (4) [P2T4]: Query executed in 0.014s
2012-12-04 10:39:58.844 (4) [P2T4]: test query succeeded, returned "5.1.49-rel11.3-log"
2012-12-04 10:39:58.845 (5) [P2T4]: quoteValue(), nothing special about it=>[898], type=class java.lang.Integer
2012-12-04 10:39:58.845 (5) [P2T4]: ProfilerRec.start("db",true) in Thread [P2T4]
2012-12-04 10:39:58.845 (4) [P2T4]: spike: SQL->[select * from `tsacommon`.`accounts` where (`tsacommon`.`accounts`.`id`=898) limit 1]
2012-12-04 10:39:58.846 (5) [main]: recordAsSubs("db", 3, "main")
2012-12-04 10:39:58.846 (5) [main]: addSub("db")
2012-12-04 10:39:58.846 (5) [main]: ProfilerRec.end("db", true): ret=3
2012-12-04 10:39:58.846 (4) [main]: time=0.0030
2012-12-04 10:39:58.846 (4) [main]: Query executed in 0.003s
2012-12-04 10:39:58.846 (5) [main]: loading 19 columns from result set:
2012-12-04 10:39:58.847 (5) [main]: 	loaded column: distribution.id->3
2012-12-04 10:39:58.847 (5) [main]: 	loaded column: distribution.accountID->0
2012-12-04 10:39:58.847 (5) [main]: 	loaded column: distribution.siteID->0
2012-12-04 10:39:58.847 (5) [main]: 	loaded column: distribution.type->paid search
2012-12-04 10:39:58.847 (5) [main]: 	loaded column: distribution.channelID->1
2012-12-04 10:39:58.848 (5) [main]: 	loaded column: distribution.showStats->1
2012-12-04 10:39:58.848 (5) [main]: 	loaded column: distribution.bidMatchTypes->exact,phrase,broad,content
2012-12-04 10:39:58.848 (5) [main]: 	loaded column: distribution.trackMatchTypes->exact,phrase,broad,content
2012-12-04 10:39:58.848 (5) [main]: 	loaded column: distribution.mergeMatchTypeStats->false
2012-12-04 10:39:58.848 (5) [main]: 	loaded column: distribution.rollupMatchTypes->content
2012-12-04 10:39:58.848 (5) [main]: 	loaded column: distribution.positionalBidding->false
2012-12-04 10:39:58.848 (5) [main]: 	loaded column: distribution.description->Google AdWords
2012-12-04 10:39:58.849 (5) [main]: 	loaded column: distribution.shortCode->GO
2012-12-04 10:39:58.849 (5) [main]: 	loaded column: distribution.searchEngineClass->com.thesearchagency.searchengines.google.GoogleAPISearchEngine
2012-12-04 10:39:58.849 (5) [main]: 	loaded column: distribution.bidMinCPC->0.01
2012-12-04 10:39:58.849 (5) [main]: 	loaded column: distribution.bidCapCPC->100.0
2012-12-04 10:39:58.849 (5) [main]: 	loaded column: distribution.bidMinCPM->0.25
2012-12-04 10:39:58.849 (5) [main]: 	loaded column: distribution.bidCapCPM->500.0
2012-12-04 10:39:58.849 (5) [main]: 	skipping invalid column: distribution.obsolete
2012-12-04 10:39:58.849 (4) [main]:   Record Loaded
2012-12-04 10:39:58.850 (5) [main]: class name is "com.thesearchagency.searchengines.google.GoogleAPISearchEngine"
2012-12-04 10:39:58.850 (4) [main]: User  in TSA MCC, connecting using master username/password
2012-12-04 10:39:58.850 (4) [main]: client customer id = 9001082081
2012-12-04 10:39:58.850 (5) [main]: parseInteger->[3177]
2012-12-04 10:39:58.850 (5) [main]: parseInteger<-[3177]
2012-12-04 10:39:58.850 (4) [main]: seuserid[3177] username[null] password[null] customerID[9001082081]
2012-12-04 10:39:58.862 (4) [main]: Setting AuthToken [DQAAAJUAAABblTkk4samFeeIPZeA4b44C3w9CSZUFxB_1PKkgTJgM5Lgsa8hTds5kjeMJGa6cExwQnnIDV7Ug-KEY3tqzcq509ufM18E690NozMrYI1_ThysElNbsxM95UmDsdGckBnxsx2_W0beOdRfookxPexOo_l8H3BAtqbFpIIwgTH98LxImDZ0EQfjCTiZ49NAuNh3TJ7XbYd-0CN-WJfEw85Z] to AdWordsUser object for username[google@thesearchagency.com]
2012-12-04 10:39:58.893 (4) [main]: Returning Object to Pool
2012-12-04 10:39:58.895 (5) [P2T4]: recordAsSubs("db", 50, "P2T4")
2012-12-04 10:39:58.895 (5) [P2T4]: addSub("db")
2012-12-04 10:39:58.895 (5) [P2T4]: ProfilerRec.end("db", true): ret=50
2012-12-04 10:39:58.895 (4) [P2T4]: time=0.05
2012-12-04 10:39:58.896 (4) [P2T4]: Query executed in 0.050s
2012-12-04 10:39:58.896 (5) [P2T4]: loading 20 columns from result set:
2012-12-04 10:39:58.896 (5) [P2T4]: 	loaded column: accounts.id->898
2012-12-04 10:39:58.897 (5) [P2T4]: 	loaded column: accounts.description->Rezonate - AT&T
2012-12-04 10:39:58.897 (5) [P2T4]: 	loaded column: accounts.tier->2
2012-12-04 10:39:58.897 (5) [P2T4]: 	loaded column: accounts.priority->50
2012-12-04 10:39:58.897 (5) [P2T4]: 	loaded column: accounts.reportClicksOut->false
2012-12-04 10:39:58.897 (5) [P2T4]: 	loaded column: accounts.reportConversions->false
2012-12-04 10:39:58.898 (5) [P2T4]: 	loaded column: accounts.conversionTypes->
2012-12-04 10:39:58.898 (5) [P2T4]: 	loaded column: accounts.isBidManaged->true
2012-12-04 10:39:58.898 (5) [P2T4]: 	loaded column: accounts.isActive->true
2012-12-04 10:39:58.898 (5) [P2T4]: 	loaded column: accounts.perfMetric->cpa
2012-12-04 10:39:58.898 (5) [P2T4]: 	loaded column: accounts.providesConversionData->false
2012-12-04 10:39:58.898 (5) [P2T4]: 	loaded column: accounts.addConversionData->false
2012-12-04 10:39:58.898 (5) [P2T4]: 	loaded column: accounts.fractionalConversionCounts->false
2012-12-04 10:39:58.898 (5) [P2T4]: 	loaded column: accounts.hideNullSources->false
2012-12-04 10:39:58.898 (5) [P2T4]: 	loaded column: accounts.nowTime->null
2012-12-04 10:39:58.899 (5) [P2T4]: 	loaded column: accounts.warehouseDatabase->warehouse_4
2012-12-04 10:39:58.899 (5) [P2T4]: 	loaded column: accounts.databaseInstance->5
2012-12-04 10:39:58.899 (5) [P2T4]: 	loaded column: accounts.warehouseInstance->7
2012-12-04 10:39:58.899 (5) [P2T4]: 	loaded column: accounts.isOnline->true
2012-12-04 10:39:58.899 (5) [P2T4]: 	loaded column: accounts.timeZoneID->2
2012-12-04 10:39:58.899 (4) [P2T4]:   Record Loaded
2012-12-04 10:39:58.899 (4) [P2T4]: Returning Object to Pool
2012-12-04 10:39:58.899 (3) [P2T4]: Starting Account (69737) "ATT-WIC|GDN|Contextual-Desktop" for user (3177) "AT&T Pan Asian Youth Campaign"
2012-12-04 10:39:58.900 (3) [P2T4]: Sync Flag: false - syncGroups and syncListings skipped for (69737) "ATT-WIC|GDN|Contextual-Desktop" for user (3177) "AT&T Pan Asian Youth Campaign"
2012-12-04 10:39:58.900 (3) [P2T4]: Finished Account (69737) "ATT-WIC|GDN|Contextual-Desktop" for user (3177) "AT&T Pan Asian Youth Campaign"
2012-12-04 10:39:58.901 (4) [P2T5]: no account, or instance for databaseInstance, skipping lookup...
2012-12-04 10:39:58.902 (4) [P2T5]: Took Existing Object from Pool
2012-12-04 10:39:58.902 (5) [P2T5]: ProfilerRec.start("db",true) in Thread [P2T5]
2012-12-04 10:39:58.902 (4) [P2T5]: spike: SQL->[select @@version]
2012-12-04 10:39:58.903 (5) [P2T5]: recordAsSubs("db", 1, "P2T5")
2012-12-04 10:39:58.903 (5) [P2T5]: addSub("db")
2012-12-04 10:39:58.904 (5) [P2T5]: ProfilerRec.end("db", true): ret=1
2012-12-04 10:39:58.904 (4) [P2T5]: time=0.0010
2012-12-04 10:39:58.904 (4) [P2T5]: Query executed in 0.001s
2012-12-04 10:39:58.904 (4) [P2T5]: test query succeeded, returned "5.1.49-rel11.3-log"
2012-12-04 10:39:58.905 (5) [P2T5]: quoteValue(), nothing special about it=>[898], type=class java.lang.Integer
2012-12-04 10:39:58.905 (5) [P2T5]: ProfilerRec.start("db",true) in Thread [P2T5]
2012-12-04 10:39:58.905 (4) [P2T5]: spike: SQL->[select * from `tsacommon`.`accounts` where (`tsacommon`.`accounts`.`id`=898) limit 1]
2012-12-04 10:39:58.906 (5) [P2T5]: recordAsSubs("db", 1, "P2T5")
2012-12-04 10:39:58.906 (5) [P2T5]: addSub("db")
2012-12-04 10:39:58.906 (5) [P2T5]: ProfilerRec.end("db", true): ret=1
2012-12-04 10:39:58.906 (4) [P2T5]: time=0.0010
2012-12-04 10:39:58.906 (4) [P2T5]: Query executed in 0.001s
2012-12-04 10:39:58.906 (5) [P2T5]: loading 20 columns from result set:
2012-12-04 10:39:58.907 (5) [P2T5]: 	loaded column: accounts.id->898
2012-12-04 10:39:58.907 (5) [P2T5]: 	loaded column: accounts.description->Rezonate - AT&T
2012-12-04 10:39:58.907 (5) [P2T5]: 	loaded column: accounts.tier->2
2012-12-04 10:39:58.907 (5) [P2T5]: 	loaded column: accounts.priority->50
2012-12-04 10:39:58.907 (5) [P2T5]: 	loaded column: accounts.reportClicksOut->false
2012-12-04 10:39:58.907 (5) [P2T5]: 	loaded column: accounts.reportConversions->false
2012-12-04 10:39:58.908 (5) [P2T5]: 	loaded column: accounts.conversionTypes->
2012-12-04 10:39:58.908 (5) [P2T5]: 	loaded column: accounts.isBidManaged->true
2012-12-04 10:39:58.908 (5) [P2T5]: 	loaded column: accounts.isActive->true
2012-12-04 10:39:58.908 (5) [P2T5]: 	loaded column: accounts.perfMetric->cpa
2012-12-04 10:39:58.908 (5) [P2T5]: 	loaded column: accounts.providesConversionData->false
2012-12-04 10:39:58.908 (5) [P2T5]: 	loaded column: accounts.addConversionData->false
2012-12-04 10:39:58.908 (5) [P2T5]: 	loaded column: accounts.fractionalConversionCounts->false
2012-12-04 10:39:58.908 (5) [P2T5]: 	loaded column: accounts.hideNullSources->false
2012-12-04 10:39:58.909 (5) [P2T5]: 	loaded column: accounts.nowTime->null
2012-12-04 10:39:58.909 (5) [P2T5]: 	loaded column: accounts.warehouseDatabase->warehouse_4
2012-12-04 10:39:58.909 (5) [P2T5]: 	loaded column: accounts.databaseInstance->5
2012-12-04 10:39:58.909 (5) [P2T5]: 	loaded column: accounts.warehouseInstance->7
2012-12-04 10:39:58.909 (5) [P2T5]: 	loaded column: accounts.isOnline->true
2012-12-04 10:39:58.909 (5) [P2T5]: 	loaded column: accounts.timeZoneID->2
2012-12-04 10:39:58.909 (4) [P2T5]:   Record Loaded
2012-12-04 10:39:58.909 (4) [P2T5]: Returning Object to Pool
2012-12-04 10:39:58.909 (3) [P2T5]: Starting Account (69733) "ATT-WIC|GDN|Contextual-Mobile" for user (3177) "AT&T Pan Asian Youth Campaign"
2012-12-04 10:39:58.910 (3) [P2T5]: Sync Flag: false - syncGroups and syncListings skipped for (69733) "ATT-WIC|GDN|Contextual-Mobile" for user (3177) "AT&T Pan Asian Youth Campaign"
2012-12-04 10:39:58.910 (3) [P2T5]: Finished Account (69733) "ATT-WIC|GDN|Contextual-Mobile" for user (3177) "AT&T Pan Asian Youth Campaign"
2012-12-04 10:39:58.913 (3) [main]: After joining threads, calling doPostJoinActions
2012-12-04 10:39:58.913 (3) [main]: =============== Completed Search Engine Updater ================
2012-12-04 10:39:58.913 (5) [main]: ProfilerRec.end("Search Engine Updater", false): ret=921148
2012-12-04 10:39:58.913 (4) [main]: time=921.148
2012-12-04 10:39:58.914 (3) [main]: Search Engine Updater:	15m 21.148s
2012-12-04 10:39:58.914 (3) [main]:     by key:
2012-12-04 10:39:58.914 (4) [main]: time=44.54
2012-12-04 10:39:58.914 (3) [main]:         parsing:	44.540s
2012-12-04 10:39:58.915 (4) [main]: time=28.115
2012-12-04 10:39:58.915 (3) [main]:         google:	28.115s
2012-12-04 10:39:58.915 (4) [main]: time=765.628
2012-12-04 10:39:58.915 (3) [main]:         db:	12m 45.628s
2012-12-04 10:39:58.915 (3) [main]:             by thread:
2012-12-04 10:39:58.915 (4) [main]: time=0.017
2012-12-04 10:39:58.915 (3) [main]:                 P2T1:	0.017s
2012-12-04 10:39:58.916 (4) [main]: time=0.0030
2012-12-04 10:39:58.916 (3) [main]:                 P2T3:	0.003s
2012-12-04 10:39:58.916 (4) [main]: time=0.172
2012-12-04 10:39:58.916 (3) [main]:                 main:	0.172s
2012-12-04 10:39:58.916 (4) [main]: time=0.0020
2012-12-04 10:39:58.916 (3) [main]:                 P2T5:	0.002s
2012-12-04 10:39:58.917 (4) [main]: time=0.0030
2012-12-04 10:39:58.917 (3) [main]:                 P2T2:	0.003s
2012-12-04 10:39:58.917 (4) [main]: time=765.367
2012-12-04 10:39:58.917 (3) [main]:                 P1T1:	12m 45.367s
2012-12-04 10:39:58.917 (4) [main]: time=0.064
2012-12-04 10:39:58.917 (3) [main]:                 P2T4:	0.064s
2012-12-04 10:39:58.917 (4) [main]: time=82.865
2012-12-04 10:39:58.918 (3) [main]:         other:	1m 22.865s