2010-10-22 06:02:06.447 (3) [main]: Debug Level set to 5 2010-10-22 06:02:06.452 (3) [main]: No licensing config file found, assuming TSA production environment 2010-10-22 06:02:06.455 (5) [main]: yesterday: month=10, day=21, year=2010 2010-10-22 06:02:07.684 (3) [main]: Configured properties according to file :: /var/local/tsa/datafeedConfig/ZipFacebook.xml 2010-10-22 06:02:07.689 (5) [main]: parseInteger->[17] 2010-10-22 06:02:07.714 (5) [main]: parseInteger<-[17] 2010-10-22 06:02:07.752 (4) [main]: no account, or instance for databaseInstance, skipping lookup... 2010-10-22 06:02:08.335 (4) [main]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2010-10-22 06:02:08.341 (4) [main]: null key, and no data, unable to build condition 2010-10-22 06:02:08.351 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-22 06:02:08.353 (4) [main]: spike: SQL->[select * from `tsacommon`.`accounts` limit 1] 2010-10-22 06:02:08.394 (5) [main]: recordAsSubs("db", 42, "main") 2010-10-22 06:02:08.395 (5) [main]: ProfilerRec.end("db", true): ret=42 2010-10-22 06:02:08.395 (4) [main]: time=0.042 2010-10-22 06:02:08.396 (4) [main]: Query executed in 0.042s 2010-10-22 06:02:08.398 (5) [main]: loading 19 columns from result set: 2010-10-22 06:02:08.399 (5) [main]: loaded column: accounts.id->1 2010-10-22 06:02:08.399 (5) [main]: loaded column: accounts.description->Admin Account 2010-10-22 06:02:08.401 (5) [main]: loaded column: accounts.tier->3 2010-10-22 06:02:08.401 (5) [main]: loaded column: accounts.priority->50 2010-10-22 06:02:08.402 (5) [main]: loaded column: accounts.reportClicksOut->false 2010-10-22 06:02:08.402 (5) [main]: loaded column: accounts.reportConversions->false 2010-10-22 06:02:08.403 (5) [main]: loaded column: accounts.conversionTypes-> 2010-10-22 06:02:08.403 (5) [main]: loaded column: accounts.isBidManaged->false 2010-10-22 06:02:08.404 (5) [main]: loaded column: accounts.isActive->false 2010-10-22 06:02:08.404 (5) [main]: loaded column: accounts.perfMetric->cpa 2010-10-22 06:02:08.404 (5) [main]: loaded column: accounts.providesConversionData->true 2010-10-22 06:02:08.405 (5) [main]: loaded column: accounts.addConversionData->false 2010-10-22 06:02:08.405 (5) [main]: loaded column: accounts.fractionalConversionCounts->false 2010-10-22 06:02:08.406 (5) [main]: loaded column: accounts.hideNullSources->false 2010-10-22 06:02:08.407 (5) [main]: loaded column: accounts.nowTime->null 2010-10-22 06:02:08.408 (5) [main]: skipping invalid column: accounts.warehouseDatabase 2010-10-22 06:02:08.408 (5) [main]: loaded column: accounts.databaseInstance->1 2010-10-22 06:02:08.409 (5) [main]: loaded column: accounts.warehouseInstance->2 2010-10-22 06:02:08.409 (5) [main]: loaded column: accounts.isOnline->true 2010-10-22 06:02:08.409 (4) [main]: Record Loaded 2010-10-22 06:02:08.410 (4) [main]: DataCache: put key acct-st-tracker null 2010-10-22 06:02:08.415 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-22 06:02:08.415 (4) [main]: spike: SQL->[select * from `tsacommon`.`databaseInstances` where ((`type`="mysql") and (`name`="acct-st-tracker-1")) limit 1] 2010-10-22 06:02:08.418 (5) [main]: recordAsSubs("db", 3, "main") 2010-10-22 06:02:08.418 (5) [main]: ProfilerRec.end("db", true): ret=3 2010-10-22 06:02:08.419 (4) [main]: time=0.0030 2010-10-22 06:02:08.419 (4) [main]: Query executed in 0.003s 2010-10-22 06:02:08.419 (5) [main]: loading 8 columns from result set: 2010-10-22 06:02:08.420 (5) [main]: loaded column: databaseInstances.id->15 2010-10-22 06:02:08.420 (5) [main]: loaded column: databaseInstances.name->acct-st-tracker-1 2010-10-22 06:02:08.421 (5) [main]: loaded column: databaseInstances.description->Account-specific Catch-all database 2010-10-22 06:02:08.421 (5) [main]: loaded column: databaseInstances.type->mysql 2010-10-22 06:02:08.421 (5) [main]: loaded column: databaseInstances.database->st-tracker 2010-10-22 06:02:08.422 (5) [main]: loaded column: databaseInstances.host->acctdb-01-write 2010-10-22 06:02:08.422 (5) [main]: loaded column: databaseInstances.port->3306 2010-10-22 06:02:08.423 (5) [main]: loaded column: databaseInstances.access->rw 2010-10-22 06:02:08.423 (4) [main]: Record Loaded 2010-10-22 06:02:08.423 (4) [main]: DataCache: put key acct-st-tracker-1 2010-10-22 06:02:08.425 (4) [main]: closed [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2010-10-22 06:02:08.431 (3) [main]: DatabasePool with a limit of 80 created 2010-10-22 06:02:08.434 (4) [ConnectionCloser]: Starting DatabasePool ConnectionCloserThread 2010-10-22 06:02:08.474 (4) [main]: opened [jdbc:mysql://acctdb-01-write:3306/st-tracker?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2010-10-22 06:02:08.475 (4) [main]: Created new Object 2010-10-22 06:02:08.475 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-22 06:02:08.476 (4) [main]: spike: SQL->[select @@version] 2010-10-22 06:02:08.478 (5) [main]: recordAsSubs("db", 3, "main") 2010-10-22 06:02:08.478 (5) [main]: ProfilerRec.end("db", true): ret=3 2010-10-22 06:02:08.478 (4) [main]: time=0.0030 2010-10-22 06:02:08.479 (4) [main]: Query executed in 0.003s 2010-10-22 06:02:08.490 (4) [main]: test query succeeded, returned "5.1.49-rel11.3" 2010-10-22 06:02:08.490 (4) [main]: no account, or instance for databaseInstance, skipping lookup... 2010-10-22 06:02:08.491 (3) [main]: DatabasePool with a limit of 80 created 2010-10-22 06:02:08.518 (4) [main]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2010-10-22 06:02:08.519 (4) [main]: Created new Object 2010-10-22 06:02:08.519 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-22 06:02:08.519 (4) [main]: spike: SQL->[select @@version] 2010-10-22 06:02:08.521 (5) [main]: recordAsSubs("db", 2, "main") 2010-10-22 06:02:08.522 (5) [main]: ProfilerRec.end("db", true): ret=2 2010-10-22 06:02:08.522 (4) [main]: time=0.0020 2010-10-22 06:02:08.522 (4) [main]: Query executed in 0.002s 2010-10-22 06:02:08.523 (4) [main]: test query succeeded, returned "5.0.30-enterprise-gpl" 2010-10-22 06:02:08.528 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-22 06:02:08.529 (4) [main]: spike: SQL->[select * from `tsacommon`.`accountDistributionMap` where ((`accountID`="17") and (`distributionID`="177")) limit 1] 2010-10-22 06:02:08.531 (5) [main]: recordAsSubs("db", 2, "main") 2010-10-22 06:02:08.532 (5) [main]: ProfilerRec.end("db", true): ret=2 2010-10-22 06:02:08.532 (4) [main]: time=0.0020 2010-10-22 06:02:08.532 (4) [main]: Query executed in 0.002s 2010-10-22 06:02:08.533 (3) [main]: Distribution status is [ACTIVE] for accountID[17], distributionID[177] 2010-10-22 06:02:08.536 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-22 06:02:08.536 (4) [main]: spike: SQL->[select * from `tsacommon`.`distribution` where ((`id`="177") and (`description`="Facebook") and (`shortCode`="FB")) limit 1] 2010-10-22 06:02:08.539 (5) [main]: recordAsSubs("db", 3, "main") 2010-10-22 06:02:08.539 (5) [main]: ProfilerRec.end("db", true): ret=3 2010-10-22 06:02:08.539 (4) [main]: time=0.0030 2010-10-22 06:02:08.540 (4) [main]: Query executed in 0.003s 2010-10-22 06:02:08.541 (5) [main]: loading 19 columns from result set: 2010-10-22 06:02:08.541 (5) [main]: loaded column: distribution.id->177 2010-10-22 06:02:08.542 (5) [main]: loaded column: distribution.accountID->0 2010-10-22 06:02:08.542 (5) [main]: loaded column: distribution.siteID->0 2010-10-22 06:02:08.543 (5) [main]: loaded column: distribution.type->paid search 2010-10-22 06:02:08.543 (5) [main]: loaded column: distribution.channelID->5 2010-10-22 06:02:08.544 (5) [main]: loaded column: distribution.showStats->1 2010-10-22 06:02:08.544 (5) [main]: loaded column: distribution.bidMatchTypes->null 2010-10-22 06:02:08.544 (5) [main]: loaded column: distribution.trackMatchTypes->null 2010-10-22 06:02:08.545 (5) [main]: loaded column: distribution.mergeMatchTypeStats->false 2010-10-22 06:02:08.545 (5) [main]: loaded column: distribution.rollupMatchTypes->null 2010-10-22 06:02:08.546 (5) [main]: loaded column: distribution.positionalBidding->false 2010-10-22 06:02:08.546 (5) [main]: loaded column: distribution.description->Facebook 2010-10-22 06:02:08.546 (5) [main]: loaded column: distribution.shortCode->fb 2010-10-22 06:02:08.547 (5) [main]: loaded column: distribution.searchEngineClass->null 2010-10-22 06:02:08.547 (5) [main]: loaded column: distribution.bidMinCPC->null 2010-10-22 06:02:08.563 (5) [main]: loaded column: distribution.bidCapCPC->null 2010-10-22 06:02:08.564 (5) [main]: loaded column: distribution.bidMinCPM->null 2010-10-22 06:02:08.564 (5) [main]: loaded column: distribution.bidCapCPM->null 2010-10-22 06:02:08.565 (5) [main]: skipping invalid column: distribution.obsolete 2010-10-22 06:02:08.566 (5) [main]: quoteValue(), nothing special about it=>[17], type=class java.lang.Integer 2010-10-22 06:02:08.567 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-22 06:02:08.568 (4) [main]: spike: SQL->[select id from `tsacommon`.`sites` where ((`accountID`=17)) limit 1] 2010-10-22 06:02:08.570 (5) [main]: recordAsSubs("db", 2, "main") 2010-10-22 06:02:08.570 (5) [main]: ProfilerRec.end("db", true): ret=2 2010-10-22 06:02:08.571 (4) [main]: time=0.0020 2010-10-22 06:02:08.571 (4) [main]: Query executed in 0.002s 2010-10-22 06:02:08.572 (4) [main]: in getSiteID()... siteID[35] 2010-10-22 06:02:08.572 (4) [main]: -- Source Map 2010-10-22 06:02:08.573 (4) [main]: Map= 2010-10-22 06:02:08.573 (4) [main]: Ad Name [class java.lang.String] => altKey [class java.lang.String] 2010-10-22 06:02:08.573 (4) [main]: -- SourceBidType Map 2010-10-22 06:02:08.574 (4) [main]: Map= 2010-10-22 06:02:08.574 (4) [main]: -- Campaign Map 2010-10-22 06:02:08.574 (4) [main]: Map= 2010-10-22 06:02:08.574 (4) [main]: Campaign Name [class java.lang.String] => description [class java.lang.String] 2010-10-22 06:02:08.575 (4) [main]: -- Publishser Activity Map 2010-10-22 06:02:08.575 (4) [main]: Map= 2010-10-22 06:02:08.575 (4) [main]: Clicks [class java.lang.String] => count [class java.lang.String] 2010-10-22 06:02:08.576 (4) [main]: Impressions [class java.lang.String] => impressions [class java.lang.String] 2010-10-22 06:02:08.576 (4) [main]: -- Publishser Product Map 2010-10-22 06:02:08.576 (4) [main]: Map= 2010-10-22 06:02:08.576 (4) [main]: Conversions [class java.lang.String] => count [class java.lang.String] 2010-10-22 06:02:09.350 (4) [main]: -- XMLDataFeedProperties:XMLDataFeedProperties DataFeedAccountInfo toString Information Account Description :: CSC Id Behavior Type :: ConfigFileIdBehavior Distribution Name :: Facebook Distribution Short Code:: FB Distribution Id :: 177 Id Map :: 17 :: 17 DataFeedFileInfo toString Information FileBehaviorType :: MultipleDaysFileBehavior ColumnDatePattern :: yyyy-MM-dd HH:mm FileDatePattern :: yyyyMMdd FileHourPattern :: yyyy-MM-dd HH:mm FileDelimiter :: , FileDirectory :: /var/local/tsa/publishers/17/177/ FileExtension :: .zip FilePrefix :: 17_ FileSuffix :: TruncateLeadingZero :: false UseSpacePadding :: true Header Behavior Type :: DefaultHeaderBehavior List of header names :: headers :: Date delimiter :: null headers :: Campaign Name delimiter :: null headers :: Campaign ID delimiter :: null headers :: Ad Name delimiter :: null headers :: Ad ID delimiter :: null headers :: Impressions delimiter :: null headers :: Clicks delimiter :: null headers :: Click Rate delimiter :: null headers :: Actions delimiter :: null headers :: Action Rate delimiter :: null headers :: Conversions delimiter :: null headers :: Cost Per Conversion delimiter :: null headers :: CPC delimiter :: null headers :: CPM delimiter :: null headers :: Spent (USD) delimiter :: null headers :: Unique Impressions delimiter :: null headers :: Unique Clicks delimiter :: null headers :: Unique Click Rate delimiter :: null dfColumn :: Ad Name dbTable :: sources dbColumn :: altKey values :: null dfColumn :: Impressions dbTable :: publisherActivitySummary dbColumn :: impressions values :: null dfColumn :: Clicks dbTable :: publisherActivitySummary dbColumn :: count values :: null dfColumn :: Conversions dbTable :: publisherProductSummary dbColumn :: count values :: null dfColumn :: Campaign Name dbTable :: campaigns dbColumn :: description values :: null Product Behavior Type :: ProductByRowBehavior DataFeedProduct Column Mappings Id :: AltKey :: Ad Name Creative :: tsacr Date :: Hour :: DataFeedProduct Column Mappings Product Code:: null Cost :: Count :: Unique Impressions Revenue :: Product Saving Settings Key :: productCode && value :: Unique Impressions - feed Key :: countConversions && value :: false Key :: showData && value :: false Key :: showCost && value :: false Key :: showConv && value :: true Key :: showRev && value :: false Key :: columnLabel && value :: Unique Impressions - feed DataFeedProduct Column Mappings Product Code:: null Cost :: Count :: Unique Clicks Revenue :: Product Saving Settings Key :: productCode && value :: Unique Clicks - feed Key :: countConversions && value :: false Key :: showData && value :: false Key :: showCost && value :: false Key :: showConv && value :: true Key :: showRev && value :: false Key :: columnLabel && value :: Unique Clicks - feed DataFeed Date Info Header Behavior Type :: FileNameDateBehavior Date Offset ::0 Creative Behavior :: CreativeByDatabaseBehavior Refcd Behavior :: RefcdByColumnAndPositionBehavior Refcd refcdColumnName :: Ad Name Refcd delimiter :: | Refcd position :: 1 Description position :: 2 2010-10-22 06:02:09.351 (4) [main]: -- theHeaderDetails: 2010-10-22 06:02:09.351 (4) [main]: List= 2010-10-22 06:02:09.352 (4) [main]: 0: dfColumn :: Ad Name, dbTable :: sources, dbColumn :: altKey, values :: null [class com.thesearchagency.datafeeds.generic.data.DataFeedHeaderDetail] 2010-10-22 06:02:09.352 (4) [main]: 1: dfColumn :: Impressions, dbTable :: publisherActivitySummary, dbColumn :: impressions, values :: null [class com.thesearchagency.datafeeds.generic.data.DataFeedHeaderDetail] 2010-10-22 06:02:09.353 (4) [main]: 2: dfColumn :: Clicks, dbTable :: publisherActivitySummary, dbColumn :: count, values :: null [class com.thesearchagency.datafeeds.generic.data.DataFeedHeaderDetail] 2010-10-22 06:02:09.353 (4) [main]: 3: dfColumn :: Conversions, dbTable :: publisherProductSummary, dbColumn :: count, values :: null [class com.thesearchagency.datafeeds.generic.data.DataFeedHeaderDetail] 2010-10-22 06:02:09.353 (4) [main]: 4: dfColumn :: Campaign Name, dbTable :: campaigns, dbColumn :: description, values :: null [class com.thesearchagency.datafeeds.generic.data.DataFeedHeaderDetail] 2010-10-22 06:02:09.354 (4) [main]: -- theDistributionName: Facebook 2010-10-22 06:02:09.354 (4) [main]: -- theDistributionId: 177 2010-10-22 06:02:09.354 (4) [main]: -- theDistributionShortCode: FB 2010-10-22 06:02:09.355 (4) [main]: -- distributionTableRow: Data= trackMatchTypes => null channelID [class java.lang.Integer] => 5 rollupMatchTypes => null type [class com.carldunham.jst.db.SQLLiteral] => paid search bidMinCPC => null positionalBidding [class com.carldunham.jst.db.SQLLiteral] => false bidCapCPC => null id [class java.lang.Integer] => 177 mergeMatchTypeStats [class com.carldunham.jst.db.SQLLiteral] => false accountID [class java.lang.Integer] => 0 bidMatchTypes => null showStats [class java.lang.Integer] => 1 description [class com.carldunham.jst.db.SQLLiteral] => Facebook bidMinCPM => null siteID [class java.lang.Integer] => 0 searchEngineClass => null bidCapCPM => null shortCode [class com.carldunham.jst.db.SQLLiteral] => fb Modified= 2010-10-22 06:02:09.356 (3) [main]: =============== Starting Publisher Generic Data Feed /177/ ================ 2010-10-22 06:02:09.357 (4) [main]: no account, or instance for databaseInstance, skipping lookup... 2010-10-22 06:02:09.401 (4) [main]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2010-10-22 06:02:09.401 (4) [main]: Created new Object 2010-10-22 06:02:09.401 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-22 06:02:09.402 (4) [main]: spike: SQL->[select @@version] 2010-10-22 06:02:09.404 (5) [main]: recordAsSubs("db", 2, "main") 2010-10-22 06:02:09.404 (5) [main]: ProfilerRec.end("db", true): ret=2 2010-10-22 06:02:09.404 (4) [main]: time=0.0020 2010-10-22 06:02:09.405 (4) [main]: Query executed in 0.002s 2010-10-22 06:02:09.405 (4) [main]: test query succeeded, returned "5.0.30-enterprise-gpl" 2010-10-22 06:02:09.406 (5) [main]: quoteValue(), nothing special about it=>[17], type=class java.lang.Integer 2010-10-22 06:02:09.406 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-22 06:02:09.406 (4) [main]: spike: SQL->[select * from `tsacommon`.`accounts` where (`tsacommon`.`accounts`.`id`=17) limit 1] 2010-10-22 06:02:09.409 (5) [main]: recordAsSubs("db", 3, "main") 2010-10-22 06:02:09.410 (5) [main]: ProfilerRec.end("db", true): ret=3 2010-10-22 06:02:09.410 (4) [main]: time=0.0030 2010-10-22 06:02:09.410 (4) [main]: Query executed in 0.003s 2010-10-22 06:02:09.411 (5) [main]: loading 19 columns from result set: 2010-10-22 06:02:09.411 (5) [main]: loaded column: accounts.id->17 2010-10-22 06:02:09.411 (5) [main]: loaded column: accounts.description->WWMW - Cellular Safety Commission 2010-10-22 06:02:09.412 (5) [main]: loaded column: accounts.tier->2 2010-10-22 06:02:09.412 (5) [main]: loaded column: accounts.priority->60 2010-10-22 06:02:09.412 (5) [main]: loaded column: accounts.reportClicksOut->false 2010-10-22 06:02:09.413 (5) [main]: loaded column: accounts.reportConversions->true 2010-10-22 06:02:09.413 (5) [main]: loaded column: accounts.conversionTypes-> 2010-10-22 06:02:09.414 (5) [main]: loaded column: accounts.isBidManaged->true 2010-10-22 06:02:09.414 (5) [main]: loaded column: accounts.isActive->true 2010-10-22 06:02:09.415 (5) [main]: loaded column: accounts.perfMetric->roi 2010-10-22 06:02:09.415 (5) [main]: loaded column: accounts.providesConversionData->true 2010-10-22 06:02:09.415 (5) [main]: loaded column: accounts.addConversionData->false 2010-10-22 06:02:09.416 (5) [main]: loaded column: accounts.fractionalConversionCounts->false 2010-10-22 06:02:09.416 (5) [main]: loaded column: accounts.hideNullSources->false 2010-10-22 06:02:09.416 (5) [main]: loaded column: accounts.nowTime->null 2010-10-22 06:02:09.417 (5) [main]: skipping invalid column: accounts.warehouseDatabase 2010-10-22 06:02:09.417 (5) [main]: loaded column: accounts.databaseInstance->1 2010-10-22 06:02:09.417 (5) [main]: loaded column: accounts.warehouseInstance->1 2010-10-22 06:02:09.435 (5) [main]: loaded column: accounts.isOnline->true 2010-10-22 06:02:09.435 (4) [main]: Record Loaded 2010-10-22 06:02:09.436 (4) [main]: Returning Object to Pool 2010-10-22 06:02:09.436 (3) [main]: Found 1 file(s)... 2010-10-22 06:02:09.436 (3) [main]: Files... [/var/local/tsa/publishers/17/177/17_FB_20101002.zip] 2010-10-22 06:02:09.437 (3) [main]: Loading file /var/local/tsa/publishers/17/177/17_FB_20101002.zip 2010-10-22 06:02:09.439 (3) [main]: Account [17]: deleting old publisher data (2010-10-02 00:00:00) 2010-10-22 06:02:09.441 (4) [main]: no account, or instance for databaseInstance, skipping lookup... 2010-10-22 06:02:09.472 (4) [main]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2010-10-22 06:02:09.473 (5) [main]: quoteValue(), nothing special about it=>[17], type=class java.lang.Integer 2010-10-22 06:02:09.473 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-22 06:02:09.473 (4) [main]: spike: SQL->[select * from `tsacommon`.`accounts` where (`id`=17) limit 1] 2010-10-22 06:02:09.476 (5) [main]: recordAsSubs("db", 3, "main") 2010-10-22 06:02:09.477 (5) [main]: ProfilerRec.end("db", true): ret=3 2010-10-22 06:02:09.477 (4) [main]: time=0.0030 2010-10-22 06:02:09.477 (4) [main]: Query executed in 0.003s 2010-10-22 06:02:09.478 (5) [main]: loading 19 columns from result set: 2010-10-22 06:02:09.478 (5) [main]: loaded column: accounts.id->17 2010-10-22 06:02:09.478 (5) [main]: loaded column: accounts.description->WWMW - Cellular Safety Commission 2010-10-22 06:02:09.479 (5) [main]: loaded column: accounts.tier->2 2010-10-22 06:02:09.479 (5) [main]: loaded column: accounts.priority->60 2010-10-22 06:02:09.479 (5) [main]: loaded column: accounts.reportClicksOut->false 2010-10-22 06:02:09.480 (5) [main]: loaded column: accounts.reportConversions->true 2010-10-22 06:02:09.480 (5) [main]: loaded column: accounts.conversionTypes-> 2010-10-22 06:02:09.480 (5) [main]: loaded column: accounts.isBidManaged->true 2010-10-22 06:02:09.481 (5) [main]: loaded column: accounts.isActive->true 2010-10-22 06:02:09.481 (5) [main]: loaded column: accounts.perfMetric->roi 2010-10-22 06:02:09.482 (5) [main]: loaded column: accounts.providesConversionData->true 2010-10-22 06:02:09.482 (5) [main]: loaded column: accounts.addConversionData->false 2010-10-22 06:02:09.482 (5) [main]: loaded column: accounts.fractionalConversionCounts->false 2010-10-22 06:02:09.483 (5) [main]: loaded column: accounts.hideNullSources->false 2010-10-22 06:02:09.483 (5) [main]: loaded column: accounts.nowTime->null 2010-10-22 06:02:09.483 (5) [main]: skipping invalid column: accounts.warehouseDatabase 2010-10-22 06:02:09.484 (5) [main]: loaded column: accounts.databaseInstance->1 2010-10-22 06:02:09.484 (5) [main]: loaded column: accounts.warehouseInstance->1 2010-10-22 06:02:09.484 (5) [main]: loaded column: accounts.isOnline->true 2010-10-22 06:02:09.484 (4) [main]: Record Loaded 2010-10-22 06:02:09.485 (4) [main]: DataCache: put key acct-st-tracker 17 2010-10-22 06:02:09.485 (4) [main]: DataCache: Found key acct-st-tracker-1 2010-10-22 06:02:09.486 (4) [main]: closed [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2010-10-22 06:02:09.557 (4) [main]: opened [jdbc:mysql://acctdb-01-write:3306/st-tracker?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2010-10-22 06:02:09.558 (4) [main]: Created new Object 2010-10-22 06:02:09.558 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-22 06:02:09.558 (4) [main]: spike: SQL->[select @@version] 2010-10-22 06:02:09.560 (5) [main]: recordAsSubs("db", 2, "main") 2010-10-22 06:02:09.561 (5) [main]: ProfilerRec.end("db", true): ret=2 2010-10-22 06:02:09.561 (4) [main]: time=0.0020 2010-10-22 06:02:09.561 (4) [main]: Query executed in 0.002s 2010-10-22 06:02:09.562 (4) [main]: test query succeeded, returned "5.1.49-rel11.3" 2010-10-22 06:02:09.562 (5) [main]: quoteValue(), nothing special about it=>[17], type=class java.lang.Integer 2010-10-22 06:02:09.564 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-22 06:02:09.564 (4) [main]: spike: SQL->[delete from `publisherActivitySummary` where ((`publisherActivitySummary`.`accountID`=17) and (`publisherActivitySummary`.`distributionID`="177") and (`publisherActivitySummary`.`startTime`>="2010-10-02 00:00:00") and (`publisherActivitySummary`.`startTime`<="2010-10-02 23:59:59"))], genflags=no 2010-10-22 06:02:09.566 (5) [main]: recordAsSubs("db", 2, "main") 2010-10-22 06:02:09.567 (5) [main]: ProfilerRec.end("db", true): ret=2 2010-10-22 06:02:09.567 (4) [main]: time=0.0020 2010-10-22 06:02:09.567 (4) [main]: Query executed in 0.002s, 0 row(s) affected 2010-10-22 06:02:09.569 (5) [main]: quoteValue(), nothing special about it=>[17], type=class java.lang.Integer 2010-10-22 06:02:09.570 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-22 06:02:09.571 (4) [main]: spike: SQL->[delete from `publisherProductSummary` where ((`publisherProductSummary`.`accountID`=17) and (`publisherProductSummary`.`distributionID`="177") and (`publisherProductSummary`.`startTime`>="2010-10-02 00:00:00") and (`publisherProductSummary`.`startTime`<="2010-10-02 23:59:59"))], genflags=no 2010-10-22 06:02:09.573 (5) [main]: recordAsSubs("db", 2, "main") 2010-10-22 06:02:09.573 (5) [main]: ProfilerRec.end("db", true): ret=2 2010-10-22 06:02:09.573 (4) [main]: time=0.0020 2010-10-22 06:02:09.574 (4) [main]: Query executed in 0.002s, 0 row(s) affected 2010-10-22 06:02:09.623 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-22 06:02:09.623 (4) [main]: spike: SQL->[select * from `dataSources` where ((`accountID`="17") and (`type`="publisher") and (`typeID`="177")) limit 1] 2010-10-22 06:02:09.625 (5) [main]: recordAsSubs("db", 2, "main") 2010-10-22 06:02:09.625 (5) [main]: ProfilerRec.end("db", true): ret=2 2010-10-22 06:02:09.626 (4) [main]: time=0.0020 2010-10-22 06:02:09.626 (4) [main]: Query executed in 0.002s 2010-10-22 06:02:09.626 (5) [main]: loading 4 columns from result set: 2010-10-22 06:02:09.626 (5) [main]: loaded column: dataSources.id->223001 2010-10-22 06:02:09.627 (5) [main]: loaded column: dataSources.type->publisher 2010-10-22 06:02:09.627 (5) [main]: loaded column: dataSources.typeID->177 2010-10-22 06:02:09.627 (5) [main]: loaded column: dataSources.accountID->17 2010-10-22 06:02:09.628 (4) [main]: Record Loaded 2010-10-22 06:02:09.631 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-22 06:02:09.631 (4) [main]: spike: SQL->[select * from `dataAvailability` where ((`dataSourceID`="223001") and (`date`="2010-10-20 03:00:00")) limit 1] 2010-10-22 06:02:09.634 (5) [main]: recordAsSubs("db", 3, "main") 2010-10-22 06:02:09.634 (5) [main]: ProfilerRec.end("db", true): ret=3 2010-10-22 06:02:09.634 (4) [main]: time=0.0030 2010-10-22 06:02:09.634 (4) [main]: Query executed in 0.003s 2010-10-22 06:02:09.634 (4) [main]: Record Not Found 2010-10-22 06:02:09.636 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-22 06:02:09.636 (4) [main]: spike: SQL->[replace into `dataAvailability` (`override`,`dataSourceID`,`status`,`date`,`updated`) values ("false","223001","in progress","2010-10-20 03:00:00","2010-10-22 06:02:09")], genflags=yes 2010-10-22 06:02:09.639 (2) [main]: Warning(s) detected in statement [replace into `dataAvailability` (`override`,`dataSourceID`,`status`,`date`,`updated`) values ("false","223001","in progress","2010-10-20 03:00:00","2010-10-22 06:02:09")] executed by user [spike] 2010-10-22 06:02:09.641 (2) [main]: SQL Note: Data truncated for column 'date' at row 1 (code:1265) 2010-10-22 06:02:09.641 (5) [main]: recordAsSubs("db", 5, "main") 2010-10-22 06:02:09.641 (5) [main]: ProfilerRec.end("db", true): ret=5 2010-10-22 06:02:09.641 (4) [main]: time=0.0050 2010-10-22 06:02:09.642 (4) [main]: Query executed in 0.005s, 1 row(s) affected 2010-10-22 06:02:09.732 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-22 06:02:09.733 (4) [main]: spike: SQL->[insert into `dataAvailabilityHistory` (`override`,`dataSourceID`,`status`,`date`,`updated`) values ("false","223001","in progress","2010-10-20 03:00:00","2010-10-22 06:02:09")], genflags=yes 2010-10-22 06:02:09.736 (2) [main]: Warning(s) detected in statement [insert into `dataAvailabilityHistory` (`override`,`dataSourceID`,`status`,`date`,`updated`) values ("false","223001","in progress","2010-10-20 03:00:00","2010-10-22 06:02:09")] executed by user [spike] 2010-10-22 06:02:09.737 (2) [main]: SQL Note: Data truncated for column 'date' at row 1 (code:1265) 2010-10-22 06:02:09.737 (5) [main]: recordAsSubs("db", 4, "main") 2010-10-22 06:02:09.737 (5) [main]: ProfilerRec.end("db", true): ret=4 2010-10-22 06:02:09.737 (4) [main]: time=0.0040 2010-10-22 06:02:09.738 (4) [main]: Query executed in 0.004s, 1 row(s) affected 2010-10-22 06:02:09.738 (3) [main]: loading "/var/local/tsa/publishers/17/177/17_FB_20101002.zip"... 2010-10-22 06:02:09.738 (3) [main]: Account [17]: deleting old publisher data (2010-10-20 00:00:00) 2010-10-22 06:02:09.739 (5) [main]: quoteValue(), nothing special about it=>[17], type=class java.lang.Integer 2010-10-22 06:02:09.740 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-22 06:02:09.740 (4) [main]: spike: SQL->[delete from `publisherActivitySummary` where ((`publisherActivitySummary`.`accountID`=17) and (`publisherActivitySummary`.`distributionID`="177") and (`publisherActivitySummary`.`startTime`>="2010-10-20 00:00:00") and (`publisherActivitySummary`.`startTime`<="2010-10-20 23:59:59"))], genflags=no 2010-10-22 06:02:09.742 (5) [main]: recordAsSubs("db", 2, "main") 2010-10-22 06:02:09.742 (5) [main]: ProfilerRec.end("db", true): ret=2 2010-10-22 06:02:09.743 (4) [main]: time=0.0020 2010-10-22 06:02:09.743 (4) [main]: Query executed in 0.002s, 0 row(s) affected 2010-10-22 06:02:09.743 (5) [main]: quoteValue(), nothing special about it=>[17], type=class java.lang.Integer 2010-10-22 06:02:09.744 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-22 06:02:09.744 (4) [main]: spike: SQL->[delete from `publisherProductSummary` where ((`publisherProductSummary`.`accountID`=17) and (`publisherProductSummary`.`distributionID`="177") and (`publisherProductSummary`.`startTime`>="2010-10-20 00:00:00") and (`publisherProductSummary`.`startTime`<="2010-10-20 23:59:59"))], genflags=no 2010-10-22 06:02:09.756 (5) [main]: recordAsSubs("db", 12, "main") 2010-10-22 06:02:09.756 (5) [main]: ProfilerRec.end("db", true): ret=12 2010-10-22 06:02:09.756 (4) [main]: time=0.012 2010-10-22 06:02:09.757 (4) [main]: Query executed in 0.012s, 0 row(s) affected 2010-10-22 06:02:09.758 (2) [main]: getDefaultFileLocation() not implemented 2010-10-22 06:02:09.760 (5) [main]: No custom filter, returning FileInputStream 2010-10-22 06:02:09.769 (5) [main]: parseDouble->[0] 2010-10-22 06:02:09.769 (5) [main]: parseDouble<-[0.0] 2010-10-22 06:02:09.769 (5) [main]: parseDouble->[70472] 2010-10-22 06:02:09.769 (5) [main]: parseDouble<-[70472.0] 2010-10-22 06:02:09.770 (5) [main]: parseDouble->[39] 2010-10-22 06:02:09.770 (5) [main]: parseDouble<-[39.0] 2010-10-22 06:02:09.770 (5) [main]: parseDouble->[1.0] 2010-10-22 06:02:09.770 (5) [main]: parseDouble<-[1.0] 2010-10-22 06:02:09.770 (5) [main]: parseDouble->[0.0] 2010-10-22 06:02:09.770 (5) [main]: parseDouble<-[0.0] 2010-10-22 06:02:09.770 (5) [main]: parseDouble->[0.0] 2010-10-22 06:02:09.771 (5) [main]: parseDouble<-[0.0] 2010-10-22 06:02:09.771 (5) [main]: parseDouble->[0.0] 2010-10-22 06:02:09.771 (5) [main]: parseDouble<-[0.0] 2010-10-22 06:02:09.771 (5) [main]: parseDouble->[0.0] 2010-10-22 06:02:09.771 (5) [main]: parseDouble<-[0.0] 2010-10-22 06:02:09.771 (5) [main]: parseDouble->[70472.0] 2010-10-22 06:02:09.771 (5) [main]: parseDouble<-[70472.0] 2010-10-22 06:02:09.771 (5) [main]: parseDouble->[39.0] 2010-10-22 06:02:09.771 (5) [main]: parseDouble<-[39.0] 2010-10-22 06:02:09.772 (5) [main]: parseDouble->[0.0] 2010-10-22 06:02:09.772 (5) [main]: parseDouble<-[0.0] 2010-10-22 06:02:09.772 (5) [main]: parseDouble->[0.0] 2010-10-22 06:02:09.780 (5) [main]: parseDouble<-[0.0] 2010-10-22 06:02:09.780 (4) [main]: Publisher Datafeed Conversion INFO Values: Alt key[FB23411005174] Creative Key[null] Date key[FB_20101002] Cost Key[0.0] Count key[1.0] Revenue Key[0.0] Account Key[17] seConv[0] seValue[0.0] seImps: 70472] seClicks[39] seAvgPos: 0.0 2010-10-22 06:02:09.781 (4) [main]: Publisher conversion object created for [FB23411005174], product= null for FB_20101002 with account id 17 2010-10-22 06:02:09.782 (5) [main]: quoteValue(), nothing special about it=>[17], type=class java.lang.Integer 2010-10-22 06:02:09.783 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-22 06:02:09.783 (4) [main]: spike: SQL->[select id from `campaigns` where ((`description`="Test Camapign ZIP test 22Oct") and (`accountID`=17)) limit 1] 2010-10-22 06:02:09.786 (5) [main]: recordAsSubs("db", 3, "main") 2010-10-22 06:02:09.786 (5) [main]: ProfilerRec.end("db", true): ret=3 2010-10-22 06:02:09.786 (4) [main]: time=0.0030 2010-10-22 06:02:09.786 (4) [main]: Query executed in 0.003s 2010-10-22 06:02:09.786 (4) [main]: in getPublisherCampaign()... CampaignID[461] 2010-10-22 06:02:09.787 (4) [main]: -- refcd: FB23411005174, keyword: Class of 80s - 80 color - 6/18 Expand test12 2010-10-22 06:02:09.787 (5) [main]: parseInteger->[177] 2010-10-22 06:02:09.787 (5) [main]: parseInteger<-[177] 2010-10-22 06:02:09.799 (4) [main]: no account, or instance for databaseInstance, skipping lookup... 2010-10-22 06:02:09.824 (4) [main]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2010-10-22 06:02:09.825 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-22 06:02:09.825 (4) [main]: spike: SQL->[select `id`,`shortCode` from distribution where ((`searchEngineClass` is not null) and (`searchEngineClass`!=""))] 2010-10-22 06:02:09.843 (5) [main]: recordAsSubs("db", 18, "main") 2010-10-22 06:02:09.843 (5) [main]: ProfilerRec.end("db", true): ret=18 2010-10-22 06:02:09.843 (4) [main]: time=0.018 2010-10-22 06:02:09.843 (4) [main]: Query executed in 0.018s 2010-10-22 06:02:09.845 (4) [main]: closed [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2010-10-22 06:02:09.858 (5) [main]: parseInteger->[17] 2010-10-22 06:02:09.858 (5) [main]: parseInteger<-[17] 2010-10-22 06:02:09.859 (5) [main]: parseInteger->[177] 2010-10-22 06:02:09.859 (5) [main]: parseInteger<-[177] 2010-10-22 06:02:09.859 (5) [main]: parseInteger->[1] 2010-10-22 06:02:09.859 (5) [main]: parseInteger<-[1] 2010-10-22 06:02:09.861 (5) [main]: quoteValue(), nothing special about it=>[17], type=class java.lang.Integer 2010-10-22 06:02:09.861 (5) [main]: quoteValue(), nothing special about it=>[177], type=class java.lang.Integer 2010-10-22 06:02:09.861 (5) [main]: quoteValue(), nothing special about it=>[1], type=class java.lang.Integer 2010-10-22 06:02:09.864 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-22 06:02:09.864 (4) [main]: spike: SQL->[select * from `sources` where ((`sources`.`accountID`=17) and (`sources`.`distributionID`=177) and (((`sources`.`type`=1))) and (((`sources`.`altKey`="fb23411005174"))) and (((`sources`.`keyword`="class of 80s - 80 color - 6/18 expand test12")))) order by `sources`.`id`] 2010-10-22 06:02:09.869 (5) [main]: recordAsSubs("db", 5, "main") 2010-10-22 06:02:09.870 (5) [main]: ProfilerRec.end("db", true): ret=5 2010-10-22 06:02:09.870 (4) [main]: time=0.0050 2010-10-22 06:02:09.870 (4) [main]: Query executed in 0.005s 2010-10-22 06:02:09.870 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-22 06:02:09.871 (4) [main]: spike: SQL->[select * from `sources` where ((`sources`.`accountID`=17) and (`sources`.`distributionID`=177) and (((`sources`.`type`=1) or (`sources`.`type`="0"))) and (((`sources`.`altKey`="fb23411005174") or (((`sources`.`keyword`="class of 80s - 80 color - 6/18 expand test12") and (((`sources`.`altKey` is null) or (`sources`.`altKey`="class of 80s - 80 color - 6/18 expand test12") or (`sources`.`altKey`="AUTO_class_of_80s_-_80_color_-_6/18_expand_test12")))))))) order by `sources`.`id`] 2010-10-22 06:02:09.876 (5) [main]: recordAsSubs("db", 5, "main") 2010-10-22 06:02:09.876 (5) [main]: ProfilerRec.end("db", true): ret=5 2010-10-22 06:02:09.876 (4) [main]: time=0.0050 2010-10-22 06:02:09.877 (4) [main]: Query executed in 0.005s 2010-10-22 06:02:09.877 (4) [main]: Unable to find source for keyword "class of 80s - 80 color - 6/18 expand test12", altkey "fb23411005174", identifier "null" (match type: null) 2010-10-22 06:02:09.877 (5) [main]: parseInteger->[17] 2010-10-22 06:02:09.877 (5) [main]: parseInteger<-[17] 2010-10-22 06:02:09.877 (5) [main]: parseInteger->[177] 2010-10-22 06:02:09.877 (5) [main]: parseInteger<-[177] 2010-10-22 06:02:09.877 (5) [main]: parseInteger->[1] 2010-10-22 06:02:09.878 (5) [main]: parseInteger<-[1] 2010-10-22 06:02:09.878 (5) [main]: quoteValue(), nothing special about it=>[17], type=class java.lang.Integer 2010-10-22 06:02:09.878 (5) [main]: quoteValue(), nothing special about it=>[177], type=class java.lang.Integer 2010-10-22 06:02:09.878 (5) [main]: quoteValue(), nothing special about it=>[1], type=class java.lang.Integer 2010-10-22 06:02:09.881 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-22 06:02:09.881 (4) [main]: spike: SQL->[select * from `sources` where ((`sources`.`accountID`=17) and (`sources`.`distributionID`=177) and (((`sources`.`type`=1))) and (((`sources`.`altKey`="17_fb_0f91d0bbfe289e715e81dfc0b3fd3001"))) and (((`sources`.`keyword`="class of 80s - 80 color - 6/18 expand test12")))) order by `sources`.`id`] 2010-10-22 06:02:09.899 (5) [main]: recordAsSubs("db", 18, "main") 2010-10-22 06:02:09.899 (5) [main]: ProfilerRec.end("db", true): ret=18 2010-10-22 06:02:09.899 (4) [main]: time=0.018 2010-10-22 06:02:09.901 (4) [main]: Query executed in 0.018s 2010-10-22 06:02:09.901 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-22 06:02:09.909 (4) [main]: spike: SQL->[select * from `sources` where ((`sources`.`accountID`=17) and (`sources`.`distributionID`=177) and (((`sources`.`type`=1) or (`sources`.`type`="0"))) and (((`sources`.`altKey`="17_fb_0f91d0bbfe289e715e81dfc0b3fd3001") or (((`sources`.`keyword`="class of 80s - 80 color - 6/18 expand test12") and (((`sources`.`altKey` is null) or (`sources`.`altKey`="class of 80s - 80 color - 6/18 expand test12") or (`sources`.`altKey`="AUTO_class_of_80s_-_80_color_-_6/18_expand_test12")))))))) order by `sources`.`id`] 2010-10-22 06:02:09.926 (5) [main]: recordAsSubs("db", 17, "main") 2010-10-22 06:02:09.926 (5) [main]: ProfilerRec.end("db", true): ret=17 2010-10-22 06:02:09.927 (4) [main]: time=0.017 2010-10-22 06:02:09.927 (4) [main]: Query executed in 0.017s 2010-10-22 06:02:09.927 (4) [main]: Unable to find source for keyword "class of 80s - 80 color - 6/18 expand test12", altkey "17_fb_0f91d0bbfe289e715e81dfc0b3fd3001", identifier "null" (match type: null) 2010-10-22 06:02:09.927 (4) [main]: -- No source with the altKey or generated altKey -- create new 2010-10-22 06:02:09.927 (5) [main]: parseInteger->[17] 2010-10-22 06:02:09.927 (5) [main]: parseInteger<-[17] 2010-10-22 06:02:09.927 (5) [main]: parseInteger->[177] 2010-10-22 06:02:09.928 (5) [main]: parseInteger<-[177] 2010-10-22 06:02:09.928 (5) [main]: parseInteger->[1] 2010-10-22 06:02:09.928 (5) [main]: parseInteger<-[1] 2010-10-22 06:02:10.429 (5) [main]: quoteValue(), nothing special about it=>[17], type=class java.lang.Integer 2010-10-22 06:02:10.467 (5) [main]: quoteValue(), nothing special about it=>[177], type=class java.lang.Integer 2010-10-22 06:02:10.467 (5) [main]: quoteValue(), nothing special about it=>[1], type=class java.lang.Integer 2010-10-22 06:02:10.482 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-22 06:02:10.482 (4) [main]: spike: SQL->[select * from `sources` where ((`sources`.`accountID`=17) and (`sources`.`distributionID`=177) and (((`sources`.`type`=1))) and (((`sources`.`altKey`="fb23411005174"))) and (((`sources`.`keyword`="class of 80s - 80 color - 6/18 expand test12")))) order by `sources`.`id`] 2010-10-22 06:02:10.490 (5) [main]: recordAsSubs("db", 8, "main") 2010-10-22 06:02:10.491 (5) [main]: ProfilerRec.end("db", true): ret=8 2010-10-22 06:02:10.491 (4) [main]: time=0.0080 2010-10-22 06:02:10.492 (4) [main]: Query executed in 0.008s 2010-10-22 06:02:10.492 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-22 06:02:10.493 (4) [main]: spike: SQL->[select * from `sources` where ((`sources`.`accountID`=17) and (`sources`.`distributionID`=177) and (((`sources`.`type`=1) or (`sources`.`type`="0"))) and (((`sources`.`altKey`="fb23411005174") or (((`sources`.`keyword`="class of 80s - 80 color - 6/18 expand test12") and (((`sources`.`altKey` is null) or (`sources`.`altKey`="class of 80s - 80 color - 6/18 expand test12") or (`sources`.`altKey`="AUTO_class_of_80s_-_80_color_-_6/18_expand_test12")))))))) order by `sources`.`id`] 2010-10-22 06:02:10.498 (5) [main]: recordAsSubs("db", 6, "main") 2010-10-22 06:02:10.498 (5) [main]: ProfilerRec.end("db", true): ret=6 2010-10-22 06:02:10.499 (4) [main]: time=0.0060 2010-10-22 06:02:10.499 (4) [main]: Query executed in 0.006s 2010-10-22 06:02:10.499 (4) [main]: Unable to find source for keyword "class of 80s - 80 color - 6/18 expand test12", altkey "fb23411005174", identifier "null" (match type: null) 2010-10-22 06:02:10.501 (5) [main]: quoteValue(), nothing special about it=>[17], type=class java.lang.Integer 2010-10-22 06:02:10.501 (5) [main]: quoteValue(), nothing special about it=>[177], type=class java.lang.Integer 2010-10-22 06:02:10.502 (5) [main]: quoteValue(), nothing special about it=>[1], type=class java.lang.Integer 2010-10-22 06:02:10.502 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-22 06:02:10.503 (4) [main]: spike: SQL->[insert into `sources` (`accountID`,`keyword`,`distributionID`,`type`,`description`,`altKey`,`landingURL`) values (17,"class of 80s - 80 color - 6/18 expand test12",177,1,"Class of 80s - 80 color - 6/18 Expand test12","fb23411005174","")], genflags=yes 2010-10-22 06:02:10.705 (5) [main]: recordAsSubs("db", 201, "main") 2010-10-22 06:02:10.706 (5) [main]: ProfilerRec.end("db", true): ret=201 2010-10-22 06:02:10.706 (4) [main]: time=0.201 2010-10-22 06:02:10.706 (4) [main]: Query executed in 0.201s, 1 row(s) affected 2010-10-22 06:02:10.707 (4) [main]: New source created for keyword "class of 80s - 80 color - 6/18 expand test12", altkey "fb23411005174", identifier "null" (match type: null) id=558002251 2010-10-22 06:02:10.708 (5) [main]: quoteValue(), nothing special about it=>[558002251], type=class java.lang.Integer 2010-10-22 06:02:10.709 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-22 06:02:10.709 (4) [main]: spike: SQL->[update `sources` set `searchEngineStatus`="ok" where (`id`=558002251) limit 1], genflags=no 2010-10-22 06:02:10.727 (5) [main]: recordAsSubs("db", 17, "main") 2010-10-22 06:02:10.727 (5) [main]: ProfilerRec.end("db", true): ret=17 2010-10-22 06:02:10.727 (4) [main]: time=0.017 2010-10-22 06:02:10.727 (4) [main]: Query executed in 0.017s, 1 row(s) affected 2010-10-22 06:02:10.728 (4) [main]: -- source updated successfully 2010-10-22 06:02:10.728 (4) [main]: in getSource()... source is Data= accountID [class java.lang.Integer] => 17 keyword [class com.carldunham.jst.db.SQLLiteral] => class of 80s - 80 color - 6/18 expand test12 searchEngineStatus [class com.thesearchagency.db.SourceTable$SearchEngineStatusValue] => ok distributionID [class java.lang.Integer] => 177 type [class java.lang.Integer] => 1 description [class com.carldunham.jst.db.SQLLiteral] => Class of 80s - 80 color - 6/18 Expand test12 altKey [class com.carldunham.jst.db.SQLLiteral] => fb23411005174 landingURL [class com.carldunham.jst.db.SQLLiteral] => id [class java.lang.Integer] => 558002251 Modified= 2010-10-22 06:02:10.729 (5) [main]: parseInteger->[558002251] 2010-10-22 06:02:10.729 (5) [main]: parseInteger<-[558002251] 2010-10-22 06:02:10.731 (5) [main]: quoteValue(), nothing special about it=>[558002251], type=class java.lang.Integer 2010-10-22 06:02:10.731 (5) [main]: quoteValue(), nothing special about it=>[1], type=class java.lang.Integer 2010-10-22 06:02:10.732 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-22 06:02:10.732 (4) [main]: spike: SQL->[insert into `sourceBidType` (`sourceBidType`.`sourceID`,`sourceBidType`.`bidTypeID`) values (558002251,1) on duplicate key update `sourceBidType`.`bidTypeID`=1], genflags=no 2010-10-22 06:02:10.734 (5) [main]: recordAsSubs("db", 2, "main") 2010-10-22 06:02:10.734 (5) [main]: ProfilerRec.end("db", true): ret=2 2010-10-22 06:02:10.735 (4) [main]: time=0.0020 2010-10-22 06:02:10.735 (4) [main]: Query executed in 0.002s, 1 row(s) affected 2010-10-22 06:02:10.735 (4) [main]: Inserted/Updated 1 row(s) in table `sourceBidType` 2010-10-22 06:02:10.735 (5) [main]: parseInteger->[177] 2010-10-22 06:02:10.736 (5) [main]: parseInteger<-[177] java.text.ParseException: Unparseable date: "FB_20101002" at java.text.DateFormat.parse(DateFormat.java:335) at com.thesearchagency.datafeeds.BaseDataFeed.formatSQLTime(BaseDataFeed.java:1618) at com.thesearchagency.datafeeds.BaseDataFeed.formatSQLTime(BaseDataFeed.java:1599) at com.thesearchagency.datafeeds.generic.PublisherGenericDataFeed.getTimeDayFormat(PublisherGenericDataFeed.java:474) at com.thesearchagency.datafeeds.generic.PublisherGenericDataFeed.processArray(PublisherGenericDataFeed.java:254) at com.thesearchagency.datafeeds.generic.PublisherGenericDataFeed.process(PublisherGenericDataFeed.java:548) at com.thesearchagency.datafeeds.BaseDataFeed.processZipFile(BaseDataFeed.java:984) at com.thesearchagency.datafeeds.BaseDataFeed.processDataFile(BaseDataFeed.java:798) at com.thesearchagency.datafeeds.generic.PublisherGenericDataFeed.processDataFile(PublisherGenericDataFeed.java:422) at com.thesearchagency.datafeeds.BaseDataFeed.run(BaseDataFeed.java:378) at com.thesearchagency.datafeeds.generic.PublisherGenericDataFeed.main(PublisherGenericDataFeed.java:77) 2010-10-22 06:02:10.740 (5) [main]: quoteValue(), nothing special about it=>[17], type=class java.lang.Integer 2010-10-22 06:02:10.741 (5) [main]: quoteValue(), nothing special about it=>[177], type=class java.lang.Integer 2010-10-22 06:02:10.741 (5) [main]: quoteValue(), nothing special about it=>[0], type=class java.lang.Integer 2010-10-22 06:02:10.741 (5) [main]: quoteValue(), nothing special about it=>[35], type=class java.lang.Integer 2010-10-22 06:02:10.742 (5) [main]: quoteValue(), nothing special about it=>[86400], type=class java.lang.Integer 2010-10-22 06:02:10.742 (5) [main]: quoteValue(), nothing special about it=>[558002251], type=class java.lang.Integer 2010-10-22 06:02:10.742 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-22 06:02:10.742 (4) [main]: spike: SQL->[select * from `publisherProductSummary` where ((`accountID`=17) and (`distributionID`=177) and (`productID`=0) and (`siteID`=35) and (`resolution`=86400) and (`sourceID`=558002251)) limit 1] 2010-10-22 06:02:10.745 (5) [main]: recordAsSubs("db", 3, "main") 2010-10-22 06:02:10.745 (5) [main]: ProfilerRec.end("db", true): ret=3 2010-10-22 06:02:10.746 (4) [main]: time=0.0030 2010-10-22 06:02:10.746 (4) [main]: Query executed in 0.003s 2010-10-22 06:02:10.746 (4) [main]: Record Not Found 2010-10-22 06:02:10.747 (5) [main]: quoteValue(), nothing special about it=>[17], type=class java.lang.Integer 2010-10-22 06:02:10.747 (5) [main]: quoteValue(), nothing special about it=>[0.0], type=class java.lang.Double 2010-10-22 06:02:10.747 (5) [main]: quoteValue(), nothing special about it=>[177], type=class java.lang.Integer 2010-10-22 06:02:11.099 (5) [main]: quoteValue(), nothing special about it=>[0], type=class java.lang.Integer 2010-10-22 06:02:11.101 (5) [main]: quoteValue(), nothing special about it=>[35], type=class java.lang.Integer 2010-10-22 06:02:11.101 (5) [main]: quoteValue(), nothing special about it=>[86400], type=class java.lang.Integer 2010-10-22 06:02:11.102 (5) [main]: quoteValue(), nothing special about it=>[0.0], type=class java.lang.Double 2010-10-22 06:02:11.102 (5) [main]: quoteValue(), nothing special about it=>[558002251], type=class java.lang.Integer 2010-10-22 06:02:11.103 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-22 06:02:11.103 (4) [main]: spike: SQL->[replace into `publisherProductSummary` (`accountID`,`value`,`distributionID`,`productID`,`siteID`,`resolution`,`count`,`sourceID`) values (17,0.0,177,0,35,86400,0.0,558002251)], genflags=yes 2010-10-22 06:02:11.107 (5) [main]: recordAsSubs("db", 4, "main") 2010-10-22 06:02:11.108 (5) [main]: ProfilerRec.end("db", true): ret=4 2010-10-22 06:02:11.108 (4) [main]: time=0.0040 2010-10-22 06:02:11.109 (4) [main]: Query executed in 0.004s, 1 row(s) affected 2010-10-22 06:02:11.109 (4) [main]: saved publisher product summary for source [558002251] count(seConv) = 0.0 value(seValue) = 0.0 2010-10-22 06:02:11.110 (5) [main]: parseInteger->[177] 2010-10-22 06:02:11.110 (5) [main]: parseInteger<-[177] java.text.ParseException: Unparseable date: "FB_20101002" at java.text.DateFormat.parse(DateFormat.java:335) at com.thesearchagency.datafeeds.BaseDataFeed.formatSQLTime(BaseDataFeed.java:1618) at com.thesearchagency.datafeeds.BaseDataFeed.formatSQLTime(BaseDataFeed.java:1599) at com.thesearchagency.datafeeds.generic.PublisherGenericDataFeed.getTimeDayFormat(PublisherGenericDataFeed.java:474) at com.thesearchagency.datafeeds.generic.PublisherGenericDataFeed.processArray(PublisherGenericDataFeed.java:261) at com.thesearchagency.datafeeds.generic.PublisherGenericDataFeed.process(PublisherGenericDataFeed.java:548) at com.thesearchagency.datafeeds.BaseDataFeed.processZipFile(BaseDataFeed.java:984) at com.thesearchagency.datafeeds.BaseDataFeed.processDataFile(BaseDataFeed.java:798) at com.thesearchagency.datafeeds.generic.PublisherGenericDataFeed.processDataFile(PublisherGenericDataFeed.java:422) at com.thesearchagency.datafeeds.BaseDataFeed.run(BaseDataFeed.java:378) at com.thesearchagency.datafeeds.generic.PublisherGenericDataFeed.main(PublisherGenericDataFeed.java:77) 2010-10-22 06:02:11.116 (5) [main]: quoteValue(), nothing special about it=>[17], type=class java.lang.Integer 2010-10-22 06:02:11.116 (5) [main]: quoteValue(), nothing special about it=>[177], type=class java.lang.Integer 2010-10-22 06:02:11.117 (5) [main]: quoteValue(), nothing special about it=>[35], type=class java.lang.Integer 2010-10-22 06:02:11.117 (5) [main]: quoteValue(), nothing special about it=>[86400], type=class java.lang.Integer 2010-10-22 06:02:11.118 (5) [main]: quoteValue(), nothing special about it=>[558002251], type=class java.lang.Integer 2010-10-22 06:02:11.118 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-22 06:02:11.119 (4) [main]: spike: SQL->[select * from `publisherActivitySummary` where ((`accountID`=17) and (`distributionID`=177) and (`siteID`=35) and (`resolution`=86400) and (`sourceID`=558002251)) limit 1] 2010-10-22 06:02:11.122 (5) [main]: recordAsSubs("db", 3, "main") 2010-10-22 06:02:11.122 (5) [main]: ProfilerRec.end("db", true): ret=3 2010-10-22 06:02:11.123 (4) [main]: time=0.0030 2010-10-22 06:02:11.123 (4) [main]: Query executed in 0.003s 2010-10-22 06:02:11.123 (4) [main]: Record Not Found 2010-10-22 06:02:11.124 (5) [main]: quoteValue(), nothing special about it=>[17], type=class java.lang.Integer 2010-10-22 06:02:11.124 (5) [main]: quoteValue(), nothing special about it=>[177], type=class java.lang.Integer 2010-10-22 06:02:11.125 (5) [main]: quoteValue(), nothing special about it=>[0.0], type=class java.lang.Double 2010-10-22 06:02:11.125 (5) [main]: quoteValue(), nothing special about it=>[35], type=class java.lang.Integer 2010-10-22 06:02:11.125 (5) [main]: quoteValue(), nothing special about it=>[86400], type=class java.lang.Integer 2010-10-22 06:02:11.126 (5) [main]: quoteValue(), nothing special about it=>[0.0], type=class java.lang.Double 2010-10-22 06:02:11.126 (5) [main]: quoteValue(), nothing special about it=>[39.0], type=class java.lang.Double 2010-10-22 06:02:11.126 (5) [main]: quoteValue(), nothing special about it=>[558002251], type=class java.lang.Integer 2010-10-22 06:02:11.127 (5) [main]: quoteValue(), nothing special about it=>[70472], type=class java.lang.Integer 2010-10-22 06:02:11.127 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-22 06:02:11.127 (4) [main]: spike: SQL->[replace into `publisherActivitySummary` (`accountID`,`distributionID`,`avgPosition`,`siteID`,`resolution`,`cost`,`count`,`sourceID`,`impressions`) values (17,177,0.0,35,86400,0.0,39.0,558002251,70472)], genflags=yes 2010-10-22 06:02:11.130 (5) [main]: recordAsSubs("db", 3, "main") 2010-10-22 06:02:11.130 (5) [main]: ProfilerRec.end("db", true): ret=3 2010-10-22 06:02:11.131 (4) [main]: time=0.0030 2010-10-22 06:02:11.131 (4) [main]: Query executed in 0.003s, 1 row(s) affected 2010-10-22 06:02:11.132 (4) [main]: saved publisher activity summary for source [558002251] count = 39.0 impressions(seImps) = 70472 cost = 0.0 avgpos = 0.0 2010-10-22 06:02:11.133 (4) [main]: Checking refcd=[FB23411005174] 2010-10-22 06:02:11.134 (5) [main]: parseDouble->[25572] 2010-10-22 06:02:11.135 (5) [main]: parseDouble<-[25572.0] 2010-10-22 06:02:11.135 (5) [main]: parseDouble->[0] 2010-10-22 06:02:11.136 (5) [main]: parseDouble<-[0.0] 2010-10-22 06:02:11.136 (5) [main]: parseDouble->[70472] 2010-10-22 06:02:11.137 (5) [main]: parseDouble<-[70472.0] 2010-10-22 06:02:11.137 (5) [main]: parseDouble->[39] 2010-10-22 06:02:11.138 (5) [main]: parseDouble<-[39.0] 2010-10-22 06:02:11.138 (5) [main]: parseDouble->[25572.0] 2010-10-22 06:02:11.138 (5) [main]: parseDouble<-[25572.0] 2010-10-22 06:02:11.139 (5) [main]: parseDouble->[0.0] 2010-10-22 06:02:11.139 (5) [main]: parseDouble<-[0.0] 2010-10-22 06:02:11.139 (5) [main]: parseDouble->[0.0] 2010-10-22 06:02:11.627 (5) [main]: parseDouble<-[0.0] 2010-10-22 06:02:11.628 (5) [main]: parseDouble->[0.0] 2010-10-22 06:02:11.629 (5) [main]: parseDouble<-[0.0] 2010-10-22 06:02:11.629 (5) [main]: parseDouble->[0.0] 2010-10-22 06:02:11.630 (5) [main]: parseDouble<-[0.0] 2010-10-22 06:02:11.630 (5) [main]: parseDouble->[70472.0] 2010-10-22 06:02:11.630 (5) [main]: parseDouble<-[70472.0] 2010-10-22 06:02:11.630 (5) [main]: parseDouble->[39.0] 2010-10-22 06:02:11.630 (5) [main]: parseDouble<-[39.0] 2010-10-22 06:02:11.630 (5) [main]: parseDouble->[0.0] 2010-10-22 06:02:11.631 (5) [main]: parseDouble<-[0.0] 2010-10-22 06:02:11.631 (5) [main]: parseDouble->[0.0] 2010-10-22 06:02:11.631 (5) [main]: parseDouble<-[0.0] 2010-10-22 06:02:11.631 (4) [main]: Publisher Datafeed Conversion INFO Values: Alt key[FB23411005174] Creative Key[null] Date key[FB_20101002] Cost Key[0.0] Count key[25572.0] Revenue Key[0.0] Account Key[17] seConv[0] seValue[0.0] seImps: 70472] seClicks[39] seAvgPos: 0.0 2010-10-22 06:02:11.632 (4) [main]: Publisher conversion object created for [FB23411005174], product= Unique Impressions - feed for FB_20101002 with account id 17 2010-10-22 06:02:11.634 (5) [main]: quoteValue(), nothing special about it=>[17], type=class java.lang.Integer 2010-10-22 06:02:11.635 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-22 06:02:11.635 (4) [main]: spike: SQL->[select * from `products` where ((`accountID`=17) and (`productCode`="Unique Impressions - feed")) limit 1] 2010-10-22 06:02:11.639 (5) [main]: recordAsSubs("db", 4, "main") 2010-10-22 06:02:11.639 (5) [main]: ProfilerRec.end("db", true): ret=4 2010-10-22 06:02:11.639 (4) [main]: time=0.0040 2010-10-22 06:02:11.639 (4) [main]: Query executed in 0.004s 2010-10-22 06:02:11.640 (5) [main]: loading 15 columns from result set: 2010-10-22 06:02:11.640 (5) [main]: loaded column: products.id->66851 2010-10-22 06:02:11.640 (5) [main]: loaded column: products.productCode->Unique Impressions - feed 2010-10-22 06:02:11.641 (5) [main]: loaded column: products.accountID->17 2010-10-22 06:02:11.641 (5) [main]: loaded column: products.siteID->0 2010-10-22 06:02:11.641 (5) [main]: loaded column: products.description-> 2010-10-22 06:02:11.652 (5) [main]: loaded column: products.countConversions->false 2010-10-22 06:02:11.653 (5) [main]: loaded column: products.columnLabel->Unique Impressions - feed 2010-10-22 06:02:11.653 (5) [main]: loaded column: products.showData->true 2010-10-22 06:02:11.654 (5) [main]: loaded column: products.fractionalCount->false 2010-10-22 06:02:11.654 (5) [main]: loaded column: products.countPercent->100.0 2010-10-22 06:02:11.654 (5) [main]: loaded column: products.order->0 2010-10-22 06:02:11.655 (5) [main]: loaded column: products.isSystemProduct->false 2010-10-22 06:02:11.655 (5) [main]: loaded column: products.showConv->true 2010-10-22 06:02:11.657 (5) [main]: loaded column: products.showCost->false 2010-10-22 06:02:11.657 (5) [main]: loaded column: products.showRev->false 2010-10-22 06:02:11.657 (4) [main]: Record Loaded 2010-10-22 06:02:11.657 (5) [main]: parseInteger->[66851] 2010-10-22 06:02:11.658 (5) [main]: parseInteger<-[66851] 2010-10-22 06:02:11.658 (4) [main]: -- productCode[Unique Impressions - feed] prodID[66851] 2010-10-22 06:02:11.658 (5) [main]: parseInteger->[177] 2010-10-22 06:02:11.658 (5) [main]: parseInteger<-[177] java.text.ParseException: Unparseable date: "FB_20101002" at java.text.DateFormat.parse(DateFormat.java:335) at com.thesearchagency.datafeeds.BaseDataFeed.formatSQLTime(BaseDataFeed.java:1618) at com.thesearchagency.datafeeds.BaseDataFeed.formatSQLTime(BaseDataFeed.java:1599) at com.thesearchagency.datafeeds.generic.PublisherGenericDataFeed.getTimeDayFormat(PublisherGenericDataFeed.java:474) at com.thesearchagency.datafeeds.generic.PublisherGenericDataFeed.processArray(PublisherGenericDataFeed.java:298) at com.thesearchagency.datafeeds.generic.PublisherGenericDataFeed.process(PublisherGenericDataFeed.java:548) at com.thesearchagency.datafeeds.BaseDataFeed.processZipFile(BaseDataFeed.java:984) at com.thesearchagency.datafeeds.BaseDataFeed.processDataFile(BaseDataFeed.java:798) at com.thesearchagency.datafeeds.generic.PublisherGenericDataFeed.processDataFile(PublisherGenericDataFeed.java:422) at com.thesearchagency.datafeeds.BaseDataFeed.run(BaseDataFeed.java:378) at com.thesearchagency.datafeeds.generic.PublisherGenericDataFeed.main(PublisherGenericDataFeed.java:77) 2010-10-22 06:02:11.663 (5) [main]: quoteValue(), nothing special about it=>[17], type=class java.lang.Integer 2010-10-22 06:02:11.663 (5) [main]: quoteValue(), nothing special about it=>[177], type=class java.lang.Integer 2010-10-22 06:02:11.663 (5) [main]: quoteValue(), nothing special about it=>[66851], type=class java.lang.Integer 2010-10-22 06:02:11.664 (5) [main]: quoteValue(), nothing special about it=>[35], type=class java.lang.Integer 2010-10-22 06:02:11.664 (5) [main]: quoteValue(), nothing special about it=>[86400], type=class java.lang.Integer 2010-10-22 06:02:11.665 (5) [main]: quoteValue(), nothing special about it=>[558002251], type=class java.lang.Integer 2010-10-22 06:02:11.665 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-22 06:02:11.665 (4) [main]: spike: SQL->[select * from `publisherProductSummary` where ((`accountID`=17) and (`distributionID`=177) and (`productID`=66851) and (`siteID`=35) and (`resolution`=86400) and (`sourceID`=558002251)) limit 1] 2010-10-22 06:02:11.668 (5) [main]: recordAsSubs("db", 3, "main") 2010-10-22 06:02:11.668 (5) [main]: ProfilerRec.end("db", true): ret=3 2010-10-22 06:02:11.669 (4) [main]: time=0.0030 2010-10-22 06:02:11.669 (4) [main]: Query executed in 0.003s 2010-10-22 06:02:11.669 (4) [main]: Record Not Found 2010-10-22 06:02:11.669 (5) [main]: quoteValue(), nothing special about it=>[17], type=class java.lang.Integer 2010-10-22 06:02:11.670 (5) [main]: quoteValue(), nothing special about it=>[0.0], type=class java.lang.Double 2010-10-22 06:02:11.670 (5) [main]: quoteValue(), nothing special about it=>[177], type=class java.lang.Integer 2010-10-22 06:02:11.670 (5) [main]: quoteValue(), nothing special about it=>[66851], type=class java.lang.Integer 2010-10-22 06:02:11.670 (5) [main]: quoteValue(), nothing special about it=>[35], type=class java.lang.Integer 2010-10-22 06:02:11.671 (5) [main]: quoteValue(), nothing special about it=>[86400], type=class java.lang.Integer 2010-10-22 06:02:11.671 (5) [main]: quoteValue(), nothing special about it=>[25572.0], type=class java.lang.Double 2010-10-22 06:02:11.671 (5) [main]: quoteValue(), nothing special about it=>[558002251], type=class java.lang.Integer 2010-10-22 06:02:11.671 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-22 06:02:11.672 (4) [main]: spike: SQL->[replace into `publisherProductSummary` (`accountID`,`value`,`distributionID`,`productID`,`siteID`,`resolution`,`count`,`sourceID`) values (17,0.0,177,66851,35,86400,25572.0,558002251)], genflags=yes 2010-10-22 06:02:11.674 (5) [main]: recordAsSubs("db", 2, "main") 2010-10-22 06:02:11.674 (5) [main]: ProfilerRec.end("db", true): ret=2 2010-10-22 06:02:11.675 (4) [main]: time=0.0020 2010-10-22 06:02:11.675 (4) [main]: Query executed in 0.002s, 1 row(s) affected 2010-10-22 06:02:11.675 (4) [main]: saved publisher product summary for source [558002251] count(seConv) = 25572.0 value(seValue) = 0.0 2010-10-22 06:02:11.676 (4) [main]: Checking refcd=[FB23411005174] 2010-10-22 06:02:11.678 (5) [main]: parseDouble->[39] 2010-10-22 06:02:11.678 (5) [main]: parseDouble<-[39.0] 2010-10-22 06:02:11.678 (5) [main]: parseDouble->[0] 2010-10-22 06:02:11.679 (5) [main]: parseDouble<-[0.0] 2010-10-22 06:02:11.679 (5) [main]: parseDouble->[70472] 2010-10-22 06:02:11.679 (5) [main]: parseDouble<-[70472.0] 2010-10-22 06:02:11.680 (5) [main]: parseDouble->[39] 2010-10-22 06:02:11.680 (5) [main]: parseDouble<-[39.0] 2010-10-22 06:02:11.680 (5) [main]: parseDouble->[39.0] 2010-10-22 06:02:11.681 (5) [main]: parseDouble<-[39.0] 2010-10-22 06:02:11.681 (5) [main]: parseDouble->[0.0] 2010-10-22 06:02:11.681 (5) [main]: parseDouble<-[0.0] 2010-10-22 06:02:11.681 (5) [main]: parseDouble->[0.0] 2010-10-22 06:02:11.682 (5) [main]: parseDouble<-[0.0] 2010-10-22 06:02:11.682 (5) [main]: parseDouble->[0.0] 2010-10-22 06:02:11.682 (5) [main]: parseDouble<-[0.0] 2010-10-22 06:02:11.682 (5) [main]: parseDouble->[0.0] 2010-10-22 06:02:11.682 (5) [main]: parseDouble<-[0.0] 2010-10-22 06:02:11.683 (5) [main]: parseDouble->[70472.0] 2010-10-22 06:02:11.683 (5) [main]: parseDouble<-[70472.0] 2010-10-22 06:02:11.683 (5) [main]: parseDouble->[39.0] 2010-10-22 06:02:11.683 (5) [main]: parseDouble<-[39.0] 2010-10-22 06:02:11.684 (5) [main]: parseDouble->[0.0] 2010-10-22 06:02:11.684 (5) [main]: parseDouble<-[0.0] 2010-10-22 06:02:11.684 (5) [main]: parseDouble->[0.0] 2010-10-22 06:02:11.684 (5) [main]: parseDouble<-[0.0] 2010-10-22 06:02:11.685 (4) [main]: Publisher Datafeed Conversion INFO Values: Alt key[FB23411005174] Creative Key[null] Date key[FB_20101002] Cost Key[0.0] Count key[39.0] Revenue Key[0.0] Account Key[17] seConv[0] seValue[0.0] seImps: 70472] seClicks[39] seAvgPos: 0.0 2010-10-22 06:02:11.685 (4) [main]: Publisher conversion object created for [FB23411005174], product= Unique Clicks - feed for FB_20101002 with account id 17 2010-10-22 06:02:11.685 (5) [main]: quoteValue(), nothing special about it=>[17], type=class java.lang.Integer 2010-10-22 06:02:11.686 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-22 06:02:11.686 (4) [main]: spike: SQL->[select * from `products` where ((`accountID`=17) and (`productCode`="Unique Clicks - feed")) limit 1] 2010-10-22 06:02:11.701 (5) [main]: recordAsSubs("db", 15, "main") 2010-10-22 06:02:11.702 (5) [main]: ProfilerRec.end("db", true): ret=15 2010-10-22 06:02:11.702 (4) [main]: time=0.015 2010-10-22 06:02:11.702 (4) [main]: Query executed in 0.015s 2010-10-22 06:02:11.703 (5) [main]: loading 15 columns from result set: 2010-10-22 06:02:11.703 (5) [main]: loaded column: products.id->66861 2010-10-22 06:02:11.704 (5) [main]: loaded column: products.productCode->Unique Clicks - feed 2010-10-22 06:02:11.704 (5) [main]: loaded column: products.accountID->17 2010-10-22 06:02:11.704 (5) [main]: loaded column: products.siteID->0 2010-10-22 06:02:11.705 (5) [main]: loaded column: products.description-> 2010-10-22 06:02:11.705 (5) [main]: loaded column: products.countConversions->false 2010-10-22 06:02:11.705 (5) [main]: loaded column: products.columnLabel->Unique Clicks - feed 2010-10-22 06:02:11.706 (5) [main]: loaded column: products.showData->true 2010-10-22 06:02:11.706 (5) [main]: loaded column: products.fractionalCount->false 2010-10-22 06:02:11.706 (5) [main]: loaded column: products.countPercent->100.0 2010-10-22 06:02:11.707 (5) [main]: loaded column: products.order->0 2010-10-22 06:02:11.707 (5) [main]: loaded column: products.isSystemProduct->false 2010-10-22 06:02:11.707 (5) [main]: loaded column: products.showConv->true 2010-10-22 06:02:11.708 (5) [main]: loaded column: products.showCost->false 2010-10-22 06:02:11.708 (5) [main]: loaded column: products.showRev->false 2010-10-22 06:02:11.708 (4) [main]: Record Loaded 2010-10-22 06:02:11.709 (5) [main]: parseInteger->[66861] 2010-10-22 06:02:11.709 (5) [main]: parseInteger<-[66861] 2010-10-22 06:02:11.709 (4) [main]: -- productCode[Unique Clicks - feed] prodID[66861] 2010-10-22 06:02:11.709 (5) [main]: parseInteger->[177] 2010-10-22 06:02:11.709 (5) [main]: parseInteger<-[177] java.text.ParseException: Unparseable date: "FB_20101002" at java.text.DateFormat.parse(DateFormat.java:335) at com.thesearchagency.datafeeds.BaseDataFeed.formatSQLTime(BaseDataFeed.java:1618) at com.thesearchagency.datafeeds.BaseDataFeed.formatSQLTime(BaseDataFeed.java:1599) at com.thesearchagency.datafeeds.generic.PublisherGenericDataFeed.getTimeDayFormat(PublisherGenericDataFeed.java:474) at com.thesearchagency.datafeeds.generic.PublisherGenericDataFeed.processArray(PublisherGenericDataFeed.java:298) at com.thesearchagency.datafeeds.generic.PublisherGenericDataFeed.process(PublisherGenericDataFeed.java:548) at com.thesearchagency.datafeeds.BaseDataFeed.processZipFile(BaseDataFeed.java:984) at com.thesearchagency.datafeeds.BaseDataFeed.processDataFile(BaseDataFeed.java:798) at com.thesearchagency.datafeeds.generic.PublisherGenericDataFeed.processDataFile(PublisherGenericDataFeed.java:422) at com.thesearchagency.datafeeds.BaseDataFeed.run(BaseDataFeed.java:378) at com.thesearchagency.datafeeds.generic.PublisherGenericDataFeed.main(PublisherGenericDataFeed.java:77) 2010-10-22 06:02:11.712 (5) [main]: quoteValue(), nothing special about it=>[17], type=class java.lang.Integer 2010-10-22 06:02:11.712 (5) [main]: quoteValue(), nothing special about it=>[177], type=class java.lang.Integer 2010-10-22 06:02:11.712 (5) [main]: quoteValue(), nothing special about it=>[66861], type=class java.lang.Integer 2010-10-22 06:02:11.713 (5) [main]: quoteValue(), nothing special about it=>[35], type=class java.lang.Integer 2010-10-22 06:02:11.713 (5) [main]: quoteValue(), nothing special about it=>[86400], type=class java.lang.Integer 2010-10-22 06:02:11.713 (5) [main]: quoteValue(), nothing special about it=>[558002251], type=class java.lang.Integer 2010-10-22 06:02:11.713 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-22 06:02:11.713 (4) [main]: spike: SQL->[select * from `publisherProductSummary` where ((`accountID`=17) and (`distributionID`=177) and (`productID`=66861) and (`siteID`=35) and (`resolution`=86400) and (`sourceID`=558002251)) limit 1] 2010-10-22 06:02:11.716 (5) [main]: recordAsSubs("db", 3, "main") 2010-10-22 06:02:11.716 (5) [main]: ProfilerRec.end("db", true): ret=3 2010-10-22 06:02:11.716 (4) [main]: time=0.0030 2010-10-22 06:02:11.717 (4) [main]: Query executed in 0.003s 2010-10-22 06:02:11.717 (4) [main]: Record Not Found 2010-10-22 06:02:11.717 (5) [main]: quoteValue(), nothing special about it=>[17], type=class java.lang.Integer 2010-10-22 06:02:11.717 (5) [main]: quoteValue(), nothing special about it=>[0.0], type=class java.lang.Double 2010-10-22 06:02:11.717 (5) [main]: quoteValue(), nothing special about it=>[177], type=class java.lang.Integer 2010-10-22 06:02:11.717 (5) [main]: quoteValue(), nothing special about it=>[66861], type=class java.lang.Integer 2010-10-22 06:02:11.718 (5) [main]: quoteValue(), nothing special about it=>[35], type=class java.lang.Integer 2010-10-22 06:02:11.718 (5) [main]: quoteValue(), nothing special about it=>[86400], type=class java.lang.Integer 2010-10-22 06:02:11.718 (5) [main]: quoteValue(), nothing special about it=>[39.0], type=class java.lang.Double 2010-10-22 06:02:11.718 (5) [main]: quoteValue(), nothing special about it=>[558002251], type=class java.lang.Integer 2010-10-22 06:02:11.718 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-22 06:02:11.718 (4) [main]: spike: SQL->[replace into `publisherProductSummary` (`accountID`,`value`,`distributionID`,`productID`,`siteID`,`resolution`,`count`,`sourceID`) values (17,0.0,177,66861,35,86400,39.0,558002251)], genflags=yes 2010-10-22 06:02:11.720 (5) [main]: recordAsSubs("db", 2, "main") 2010-10-22 06:02:11.721 (5) [main]: ProfilerRec.end("db", true): ret=2 2010-10-22 06:02:11.721 (4) [main]: time=0.0020 2010-10-22 06:02:11.721 (4) [main]: Query executed in 0.002s, 1 row(s) affected 2010-10-22 06:02:11.721 (4) [main]: saved publisher product summary for source [558002251] count(seConv) = 39.0 value(seValue) = 0.0 2010-10-22 06:02:11.723 (5) [main]: parseDouble->[0] 2010-10-22 06:02:11.723 (5) [main]: parseDouble<-[0.0] 2010-10-22 06:02:11.723 (5) [main]: parseDouble->[32449] 2010-10-22 06:02:11.723 (5) [main]: parseDouble<-[32449.0] 2010-10-22 06:02:11.723 (5) [main]: parseDouble->[16] 2010-10-22 06:02:11.724 (5) [main]: parseDouble<-[16.0] 2010-10-22 06:02:11.724 (5) [main]: parseDouble->[1.0] 2010-10-22 06:02:11.724 (5) [main]: parseDouble<-[1.0] 2010-10-22 06:02:11.724 (5) [main]: parseDouble->[0.0] 2010-10-22 06:02:11.724 (5) [main]: parseDouble<-[0.0] 2010-10-22 06:02:11.725 (5) [main]: parseDouble->[0.0] 2010-10-22 06:02:11.725 (5) [main]: parseDouble<-[0.0] 2010-10-22 06:02:11.725 (5) [main]: parseDouble->[0.0] 2010-10-22 06:02:11.725 (5) [main]: parseDouble<-[0.0] 2010-10-22 06:02:11.725 (5) [main]: parseDouble->[0.0] 2010-10-22 06:02:11.725 (5) [main]: parseDouble<-[0.0] 2010-10-22 06:02:11.725 (5) [main]: parseDouble->[32449.0] 2010-10-22 06:02:11.725 (5) [main]: parseDouble<-[32449.0] 2010-10-22 06:02:11.725 (5) [main]: parseDouble->[16.0] 2010-10-22 06:02:11.818 (5) [main]: parseDouble<-[16.0] 2010-10-22 06:02:11.818 (5) [main]: parseDouble->[0.0] 2010-10-22 06:02:11.818 (5) [main]: parseDouble<-[0.0] 2010-10-22 06:02:11.818 (5) [main]: parseDouble->[0.0] 2010-10-22 06:02:11.818 (5) [main]: parseDouble<-[0.0] 2010-10-22 06:02:11.818 (4) [main]: Publisher Datafeed Conversion INFO Values: Alt key[FB230511050184] Creative Key[null] Date key[FB_20101002] Cost Key[0.0] Count key[1.0] Revenue Key[0.0] Account Key[17] seConv[0] seValue[0.0] seImps: 32449] seClicks[16] seAvgPos: 0.0 2010-10-22 06:02:11.818 (4) [main]: Publisher conversion object created for [FB230511050184], product= null for FB_20101002 with account id 17 2010-10-22 06:02:11.819 (5) [main]: quoteValue(), nothing special about it=>[17], type=class java.lang.Integer 2010-10-22 06:02:11.819 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-22 06:02:11.819 (4) [main]: spike: SQL->[select id from `campaigns` where ((`description`="Test Camapign ZIP test 22Oct") and (`accountID`=17)) limit 1] 2010-10-22 06:02:11.821 (5) [main]: recordAsSubs("db", 2, "main") 2010-10-22 06:02:11.822 (5) [main]: ProfilerRec.end("db", true): ret=2 2010-10-22 06:02:11.822 (4) [main]: time=0.0020 2010-10-22 06:02:11.822 (4) [main]: Query executed in 0.002s 2010-10-22 06:02:11.822 (4) [main]: in getPublisherCampaign()... CampaignID[461] 2010-10-22 06:02:11.822 (4) [main]: -- refcd: FB230511050184, keyword: Class of 80s - 81 Metro - 7/12 Expand test12 2010-10-22 06:02:11.822 (5) [main]: parseInteger->[177] 2010-10-22 06:02:11.822 (5) [main]: parseInteger<-[177] 2010-10-22 06:02:11.823 (5) [main]: parseInteger->[17] 2010-10-22 06:02:11.823 (5) [main]: parseInteger<-[17] 2010-10-22 06:02:11.823 (5) [main]: parseInteger->[177] 2010-10-22 06:02:11.823 (5) [main]: parseInteger<-[177] 2010-10-22 06:02:11.823 (5) [main]: parseInteger->[1] 2010-10-22 06:02:11.823 (5) [main]: parseInteger<-[1] 2010-10-22 06:02:11.823 (5) [main]: quoteValue(), nothing special about it=>[17], type=class java.lang.Integer 2010-10-22 06:02:11.824 (5) [main]: quoteValue(), nothing special about it=>[177], type=class java.lang.Integer 2010-10-22 06:02:11.824 (5) [main]: quoteValue(), nothing special about it=>[1], type=class java.lang.Integer 2010-10-22 06:02:11.837 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-22 06:02:11.837 (4) [main]: spike: SQL->[select * from `sources` where ((`sources`.`accountID`=17) and (`sources`.`distributionID`=177) and (((`sources`.`type`=1))) and (((`sources`.`altKey`="fb230511050184"))) and (((`sources`.`keyword`="class of 80s - 81 metro - 7/12 expand test12")))) order by `sources`.`id`] 2010-10-22 06:02:11.848 (5) [main]: recordAsSubs("db", 11, "main") 2010-10-22 06:02:11.849 (5) [main]: ProfilerRec.end("db", true): ret=11 2010-10-22 06:02:11.849 (4) [main]: time=0.011 2010-10-22 06:02:11.849 (4) [main]: Query executed in 0.011s 2010-10-22 06:02:11.849 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-22 06:02:11.849 (4) [main]: spike: SQL->[select * from `sources` where ((`sources`.`accountID`=17) and (`sources`.`distributionID`=177) and (((`sources`.`type`=1) or (`sources`.`type`="0"))) and (((`sources`.`altKey`="fb230511050184") or (((`sources`.`keyword`="class of 80s - 81 metro - 7/12 expand test12") and (((`sources`.`altKey` is null) or (`sources`.`altKey`="class of 80s - 81 metro - 7/12 expand test12") or (`sources`.`altKey`="AUTO_class_of_80s_-_81_metro_-_7/12_expand_test12")))))))) order by `sources`.`id`] 2010-10-22 06:02:11.855 (5) [main]: recordAsSubs("db", 6, "main") 2010-10-22 06:02:11.855 (5) [main]: ProfilerRec.end("db", true): ret=6 2010-10-22 06:02:11.855 (4) [main]: time=0.0060 2010-10-22 06:02:11.855 (4) [main]: Query executed in 0.006s 2010-10-22 06:02:11.855 (4) [main]: Unable to find source for keyword "class of 80s - 81 metro - 7/12 expand test12", altkey "fb230511050184", identifier "null" (match type: null) 2010-10-22 06:02:11.855 (5) [main]: parseInteger->[17] 2010-10-22 06:02:11.855 (5) [main]: parseInteger<-[17] 2010-10-22 06:02:11.855 (5) [main]: parseInteger->[177] 2010-10-22 06:02:11.855 (5) [main]: parseInteger<-[177] 2010-10-22 06:02:11.855 (5) [main]: parseInteger->[1] 2010-10-22 06:02:11.856 (5) [main]: parseInteger<-[1] 2010-10-22 06:02:11.856 (5) [main]: quoteValue(), nothing special about it=>[17], type=class java.lang.Integer 2010-10-22 06:02:11.856 (5) [main]: quoteValue(), nothing special about it=>[177], type=class java.lang.Integer 2010-10-22 06:02:11.856 (5) [main]: quoteValue(), nothing special about it=>[1], type=class java.lang.Integer 2010-10-22 06:02:11.858 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-22 06:02:11.858 (4) [main]: spike: SQL->[select * from `sources` where ((`sources`.`accountID`=17) and (`sources`.`distributionID`=177) and (((`sources`.`type`=1))) and (((`sources`.`altKey`="17_fb_5a65d275fe20c1a6abf420edbcf753a3"))) and (((`sources`.`keyword`="class of 80s - 81 metro - 7/12 expand test12")))) order by `sources`.`id`] 2010-10-22 06:02:11.863 (5) [main]: recordAsSubs("db", 5, "main") 2010-10-22 06:02:11.863 (5) [main]: ProfilerRec.end("db", true): ret=5 2010-10-22 06:02:11.863 (4) [main]: time=0.0050 2010-10-22 06:02:11.864 (4) [main]: Query executed in 0.005s 2010-10-22 06:02:11.864 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-22 06:02:11.864 (4) [main]: spike: SQL->[select * from `sources` where ((`sources`.`accountID`=17) and (`sources`.`distributionID`=177) and (((`sources`.`type`=1) or (`sources`.`type`="0"))) and (((`sources`.`altKey`="17_fb_5a65d275fe20c1a6abf420edbcf753a3") or (((`sources`.`keyword`="class of 80s - 81 metro - 7/12 expand test12") and (((`sources`.`altKey` is null) or (`sources`.`altKey`="class of 80s - 81 metro - 7/12 expand test12") or (`sources`.`altKey`="AUTO_class_of_80s_-_81_metro_-_7/12_expand_test12")))))))) order by `sources`.`id`] 2010-10-22 06:02:11.870 (5) [main]: recordAsSubs("db", 6, "main") 2010-10-22 06:02:11.870 (5) [main]: ProfilerRec.end("db", true): ret=6 2010-10-22 06:02:11.870 (4) [main]: time=0.0060 2010-10-22 06:02:11.870 (4) [main]: Query executed in 0.006s 2010-10-22 06:02:11.870 (4) [main]: Unable to find source for keyword "class of 80s - 81 metro - 7/12 expand test12", altkey "17_fb_5a65d275fe20c1a6abf420edbcf753a3", identifier "null" (match type: null) 2010-10-22 06:02:11.870 (4) [main]: -- No source with the altKey or generated altKey -- create new 2010-10-22 06:02:11.870 (5) [main]: parseInteger->[17] 2010-10-22 06:02:11.870 (5) [main]: parseInteger<-[17] 2010-10-22 06:02:11.870 (5) [main]: parseInteger->[177] 2010-10-22 06:02:11.870 (5) [main]: parseInteger<-[177] 2010-10-22 06:02:11.870 (5) [main]: parseInteger->[1] 2010-10-22 06:02:11.871 (5) [main]: parseInteger<-[1] 2010-10-22 06:02:11.871 (5) [main]: quoteValue(), nothing special about it=>[17], type=class java.lang.Integer 2010-10-22 06:02:11.871 (5) [main]: quoteValue(), nothing special about it=>[177], type=class java.lang.Integer 2010-10-22 06:02:11.871 (5) [main]: quoteValue(), nothing special about it=>[1], type=class java.lang.Integer 2010-10-22 06:02:11.873 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-22 06:02:11.873 (4) [main]: spike: SQL->[select * from `sources` where ((`sources`.`accountID`=17) and (`sources`.`distributionID`=177) and (((`sources`.`type`=1))) and (((`sources`.`altKey`="fb230511050184"))) and (((`sources`.`keyword`="class of 80s - 81 metro - 7/12 expand test12")))) order by `sources`.`id`] 2010-10-22 06:02:11.878 (5) [main]: recordAsSubs("db", 5, "main") 2010-10-22 06:02:11.878 (5) [main]: ProfilerRec.end("db", true): ret=5 2010-10-22 06:02:11.879 (4) [main]: time=0.0050 2010-10-22 06:02:11.879 (4) [main]: Query executed in 0.005s 2010-10-22 06:02:11.879 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-22 06:02:11.879 (4) [main]: spike: SQL->[select * from `sources` where ((`sources`.`accountID`=17) and (`sources`.`distributionID`=177) and (((`sources`.`type`=1) or (`sources`.`type`="0"))) and (((`sources`.`altKey`="fb230511050184") or (((`sources`.`keyword`="class of 80s - 81 metro - 7/12 expand test12") and (((`sources`.`altKey` is null) or (`sources`.`altKey`="class of 80s - 81 metro - 7/12 expand test12") or (`sources`.`altKey`="AUTO_class_of_80s_-_81_metro_-_7/12_expand_test12")))))))) order by `sources`.`id`] 2010-10-22 06:02:11.885 (5) [main]: recordAsSubs("db", 6, "main") 2010-10-22 06:02:11.885 (5) [main]: ProfilerRec.end("db", true): ret=6 2010-10-22 06:02:11.885 (4) [main]: time=0.0060 2010-10-22 06:02:11.885 (4) [main]: Query executed in 0.006s 2010-10-22 06:02:11.885 (4) [main]: Unable to find source for keyword "class of 80s - 81 metro - 7/12 expand test12", altkey "fb230511050184", identifier "null" (match type: null) 2010-10-22 06:02:11.885 (5) [main]: quoteValue(), nothing special about it=>[17], type=class java.lang.Integer 2010-10-22 06:02:11.886 (5) [main]: quoteValue(), nothing special about it=>[177], type=class java.lang.Integer 2010-10-22 06:02:11.886 (5) [main]: quoteValue(), nothing special about it=>[1], type=class java.lang.Integer 2010-10-22 06:02:11.886 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-22 06:02:11.886 (4) [main]: spike: SQL->[insert into `sources` (`accountID`,`keyword`,`distributionID`,`type`,`description`,`altKey`,`landingURL`) values (17,"class of 80s - 81 metro - 7/12 expand test12",177,1,"Class of 80s - 81 Metro - 7/12 Expand test12","fb230511050184","")], genflags=yes 2010-10-22 06:02:11.888 (5) [main]: recordAsSubs("db", 2, "main") 2010-10-22 06:02:11.889 (5) [main]: ProfilerRec.end("db", true): ret=2 2010-10-22 06:02:11.889 (4) [main]: time=0.0020 2010-10-22 06:02:11.889 (4) [main]: Query executed in 0.002s, 1 row(s) affected 2010-10-22 06:02:11.889 (4) [main]: New source created for keyword "class of 80s - 81 metro - 7/12 expand test12", altkey "fb230511050184", identifier "null" (match type: null) id=558002261 2010-10-22 06:02:11.890 (5) [main]: quoteValue(), nothing special about it=>[558002261], type=class java.lang.Integer 2010-10-22 06:02:11.891 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-22 06:02:11.891 (4) [main]: spike: SQL->[update `sources` set `searchEngineStatus`="ok" where (`id`=558002261) limit 1], genflags=no 2010-10-22 06:02:11.893 (5) [main]: recordAsSubs("db", 2, "main") 2010-10-22 06:02:11.893 (5) [main]: ProfilerRec.end("db", true): ret=2 2010-10-22 06:02:11.893 (4) [main]: time=0.0020 2010-10-22 06:02:11.893 (4) [main]: Query executed in 0.002s, 1 row(s) affected 2010-10-22 06:02:11.893 (4) [main]: -- source updated successfully 2010-10-22 06:02:11.894 (4) [main]: in getSource()... source is Data= accountID [class java.lang.Integer] => 17 keyword [class com.carldunham.jst.db.SQLLiteral] => class of 80s - 81 metro - 7/12 expand test12 searchEngineStatus [class com.thesearchagency.db.SourceTable$SearchEngineStatusValue] => ok distributionID [class java.lang.Integer] => 177 type [class java.lang.Integer] => 1 description [class com.carldunham.jst.db.SQLLiteral] => Class of 80s - 81 Metro - 7/12 Expand test12 altKey [class com.carldunham.jst.db.SQLLiteral] => fb230511050184 landingURL [class com.carldunham.jst.db.SQLLiteral] => id [class java.lang.Integer] => 558002261 Modified= 2010-10-22 06:02:11.894 (5) [main]: parseInteger->[558002261] 2010-10-22 06:02:11.894 (5) [main]: parseInteger<-[558002261] 2010-10-22 06:02:11.894 (5) [main]: quoteValue(), nothing special about it=>[558002261], type=class java.lang.Integer 2010-10-22 06:02:11.894 (5) [main]: quoteValue(), nothing special about it=>[1], type=class java.lang.Integer 2010-10-22 06:02:11.894 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-22 06:02:11.895 (4) [main]: spike: SQL->[insert into `sourceBidType` (`sourceBidType`.`sourceID`,`sourceBidType`.`bidTypeID`) values (558002261,1) on duplicate key update `sourceBidType`.`bidTypeID`=1], genflags=no 2010-10-22 06:02:11.897 (5) [main]: recordAsSubs("db", 2, "main") 2010-10-22 06:02:11.897 (5) [main]: ProfilerRec.end("db", true): ret=2 2010-10-22 06:02:11.897 (4) [main]: time=0.0020 2010-10-22 06:02:11.897 (4) [main]: Query executed in 0.002s, 1 row(s) affected 2010-10-22 06:02:11.897 (4) [main]: Inserted/Updated 1 row(s) in table `sourceBidType` 2010-10-22 06:02:11.897 (5) [main]: parseInteger->[177] 2010-10-22 06:02:11.897 (5) [main]: parseInteger<-[177] java.text.ParseException: Unparseable date: "FB_20101002" at java.text.DateFormat.parse(DateFormat.java:335) at com.thesearchagency.datafeeds.BaseDataFeed.formatSQLTime(BaseDataFeed.java:1618) at com.thesearchagency.datafeeds.BaseDataFeed.formatSQLTime(BaseDataFeed.java:1599) at com.thesearchagency.datafeeds.generic.PublisherGenericDataFeed.getTimeDayFormat(PublisherGenericDataFeed.java:474) at com.thesearchagency.datafeeds.generic.PublisherGenericDataFeed.processArray(PublisherGenericDataFeed.java:254) at com.thesearchagency.datafeeds.generic.PublisherGenericDataFeed.process(PublisherGenericDataFeed.java:548) at com.thesearchagency.datafeeds.BaseDataFeed.processZipFile(BaseDataFeed.java:984) at com.thesearchagency.datafeeds.BaseDataFeed.processDataFile(BaseDataFeed.java:798) at com.thesearchagency.datafeeds.generic.PublisherGenericDataFeed.processDataFile(PublisherGenericDataFeed.java:422) at com.thesearchagency.datafeeds.BaseDataFeed.run(BaseDataFeed.java:378) at com.thesearchagency.datafeeds.generic.PublisherGenericDataFeed.main(PublisherGenericDataFeed.java:77) 2010-10-22 06:02:11.899 (5) [main]: quoteValue(), nothing special about it=>[17], type=class java.lang.Integer 2010-10-22 06:02:11.899 (5) [main]: quoteValue(), nothing special about it=>[177], type=class java.lang.Integer 2010-10-22 06:02:11.899 (5) [main]: quoteValue(), nothing special about it=>[0], type=class java.lang.Integer 2010-10-22 06:02:11.899 (5) [main]: quoteValue(), nothing special about it=>[35], type=class java.lang.Integer 2010-10-22 06:02:11.900 (5) [main]: quoteValue(), nothing special about it=>[86400], type=class java.lang.Integer 2010-10-22 06:02:11.900 (5) [main]: quoteValue(), nothing special about it=>[558002261], type=class java.lang.Integer 2010-10-22 06:02:11.900 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-22 06:02:11.900 (4) [main]: spike: SQL->[select * from `publisherProductSummary` where ((`accountID`=17) and (`distributionID`=177) and (`productID`=0) and (`siteID`=35) and (`resolution`=86400) and (`sourceID`=558002261)) limit 1] 2010-10-22 06:02:11.903 (5) [main]: recordAsSubs("db", 3, "main") 2010-10-22 06:02:11.903 (5) [main]: ProfilerRec.end("db", true): ret=3 2010-10-22 06:02:11.903 (4) [main]: time=0.0030 2010-10-22 06:02:11.903 (4) [main]: Query executed in 0.003s 2010-10-22 06:02:11.903 (4) [main]: Record Not Found 2010-10-22 06:02:11.903 (5) [main]: quoteValue(), nothing special about it=>[17], type=class java.lang.Integer 2010-10-22 06:02:11.903 (5) [main]: quoteValue(), nothing special about it=>[0.0], type=class java.lang.Double 2010-10-22 06:02:11.904 (5) [main]: quoteValue(), nothing special about it=>[177], type=class java.lang.Integer 2010-10-22 06:02:11.904 (5) [main]: quoteValue(), nothing special about it=>[0], type=class java.lang.Integer 2010-10-22 06:02:11.904 (5) [main]: quoteValue(), nothing special about it=>[35], type=class java.lang.Integer 2010-10-22 06:02:11.904 (5) [main]: quoteValue(), nothing special about it=>[86400], type=class java.lang.Integer 2010-10-22 06:02:11.904 (5) [main]: quoteValue(), nothing special about it=>[0.0], type=class java.lang.Double 2010-10-22 06:02:11.904 (5) [main]: quoteValue(), nothing special about it=>[558002261], type=class java.lang.Integer 2010-10-22 06:02:11.904 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-22 06:02:11.904 (4) [main]: spike: SQL->[replace into `publisherProductSummary` (`accountID`,`value`,`distributionID`,`productID`,`siteID`,`resolution`,`count`,`sourceID`) values (17,0.0,177,0,35,86400,0.0,558002261)], genflags=yes 2010-10-22 06:02:11.906 (5) [main]: recordAsSubs("db", 2, "main") 2010-10-22 06:02:11.906 (5) [main]: ProfilerRec.end("db", true): ret=2 2010-10-22 06:02:11.906 (4) [main]: time=0.0020 2010-10-22 06:02:11.906 (4) [main]: Query executed in 0.002s, 1 row(s) affected 2010-10-22 06:02:11.907 (4) [main]: saved publisher product summary for source [558002261] count(seConv) = 0.0 value(seValue) = 0.0 2010-10-22 06:02:11.907 (5) [main]: parseInteger->[177] 2010-10-22 06:02:11.907 (5) [main]: parseInteger<-[177] java.text.ParseException: Unparseable date: "FB_20101002" at java.text.DateFormat.parse(DateFormat.java:335) at com.thesearchagency.datafeeds.BaseDataFeed.formatSQLTime(BaseDataFeed.java:1618) at com.thesearchagency.datafeeds.BaseDataFeed.formatSQLTime(BaseDataFeed.java:1599) at com.thesearchagency.datafeeds.generic.PublisherGenericDataFeed.getTimeDayFormat(PublisherGenericDataFeed.java:474) at com.thesearchagency.datafeeds.generic.PublisherGenericDataFeed.processArray(PublisherGenericDataFeed.java:261) at com.thesearchagency.datafeeds.generic.PublisherGenericDataFeed.process(PublisherGenericDataFeed.java:548) at com.thesearchagency.datafeeds.BaseDataFeed.processZipFile(BaseDataFeed.java:984) at com.thesearchagency.datafeeds.BaseDataFeed.processDataFile(BaseDataFeed.java:798) at com.thesearchagency.datafeeds.generic.PublisherGenericDataFeed.processDataFile(PublisherGenericDataFeed.java:422) at com.thesearchagency.datafeeds.BaseDataFeed.run(BaseDataFeed.java:378) at com.thesearchagency.datafeeds.generic.PublisherGenericDataFeed.main(PublisherGenericDataFeed.java:77) 2010-10-22 06:02:11.909 (5) [main]: quoteValue(), nothing special about it=>[17], type=class java.lang.Integer 2010-10-22 06:02:11.909 (5) [main]: quoteValue(), nothing special about it=>[177], type=class java.lang.Integer 2010-10-22 06:02:11.909 (5) [main]: quoteValue(), nothing special about it=>[35], type=class java.lang.Integer 2010-10-22 06:02:11.909 (5) [main]: quoteValue(), nothing special about it=>[86400], type=class java.lang.Integer 2010-10-22 06:02:11.909 (5) [main]: quoteValue(), nothing special about it=>[558002261], type=class java.lang.Integer 2010-10-22 06:02:11.910 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-22 06:02:11.964 (4) [main]: spike: SQL->[select * from `publisherActivitySummary` where ((`accountID`=17) and (`distributionID`=177) and (`siteID`=35) and (`resolution`=86400) and (`sourceID`=558002261)) limit 1] 2010-10-22 06:02:11.969 (5) [main]: recordAsSubs("db", 6, "main") 2010-10-22 06:02:11.969 (5) [main]: ProfilerRec.end("db", true): ret=6 2010-10-22 06:02:11.969 (4) [main]: time=0.0060 2010-10-22 06:02:11.969 (4) [main]: Query executed in 0.006s 2010-10-22 06:02:11.969 (4) [main]: Record Not Found 2010-10-22 06:02:11.969 (5) [main]: quoteValue(), nothing special about it=>[17], type=class java.lang.Integer 2010-10-22 06:02:11.970 (5) [main]: quoteValue(), nothing special about it=>[177], type=class java.lang.Integer 2010-10-22 06:02:11.970 (5) [main]: quoteValue(), nothing special about it=>[0.0], type=class java.lang.Double 2010-10-22 06:02:11.970 (5) [main]: quoteValue(), nothing special about it=>[35], type=class java.lang.Integer 2010-10-22 06:02:11.970 (5) [main]: quoteValue(), nothing special about it=>[86400], type=class java.lang.Integer 2010-10-22 06:02:11.970 (5) [main]: quoteValue(), nothing special about it=>[0.0], type=class java.lang.Double 2010-10-22 06:02:11.970 (5) [main]: quoteValue(), nothing special about it=>[16.0], type=class java.lang.Double 2010-10-22 06:02:11.970 (5) [main]: quoteValue(), nothing special about it=>[558002261], type=class java.lang.Integer 2010-10-22 06:02:11.970 (5) [main]: quoteValue(), nothing special about it=>[32449], type=class java.lang.Integer 2010-10-22 06:02:11.970 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-22 06:02:11.970 (4) [main]: spike: SQL->[replace into `publisherActivitySummary` (`accountID`,`distributionID`,`avgPosition`,`siteID`,`resolution`,`cost`,`count`,`sourceID`,`impressions`) values (17,177,0.0,35,86400,0.0,16.0,558002261,32449)], genflags=yes 2010-10-22 06:02:11.972 (5) [main]: recordAsSubs("db", 2, "main") 2010-10-22 06:02:11.973 (5) [main]: ProfilerRec.end("db", true): ret=2 2010-10-22 06:02:11.973 (4) [main]: time=0.0020 2010-10-22 06:02:11.973 (4) [main]: Query executed in 0.002s, 1 row(s) affected 2010-10-22 06:02:11.973 (4) [main]: saved publisher activity summary for source [558002261] count = 16.0 impressions(seImps) = 32449 cost = 0.0 avgpos = 0.0 2010-10-22 06:02:11.973 (4) [main]: Checking refcd=[FB230511050184] 2010-10-22 06:02:11.975 (5) [main]: parseDouble->[12745] 2010-10-22 06:02:11.975 (5) [main]: parseDouble<-[12745.0] 2010-10-22 06:02:11.975 (5) [main]: parseDouble->[0] 2010-10-22 06:02:11.975 (5) [main]: parseDouble<-[0.0] 2010-10-22 06:02:11.975 (5) [main]: parseDouble->[32449] 2010-10-22 06:02:11.975 (5) [main]: parseDouble<-[32449.0] 2010-10-22 06:02:11.975 (5) [main]: parseDouble->[16] 2010-10-22 06:02:11.976 (5) [main]: parseDouble<-[16.0] 2010-10-22 06:02:11.976 (5) [main]: parseDouble->[12745.0] 2010-10-22 06:02:11.976 (5) [main]: parseDouble<-[12745.0] 2010-10-22 06:02:11.976 (5) [main]: parseDouble->[0.0] 2010-10-22 06:02:11.976 (5) [main]: parseDouble<-[0.0] 2010-10-22 06:02:11.976 (5) [main]: parseDouble->[0.0] 2010-10-22 06:02:11.976 (5) [main]: parseDouble<-[0.0] 2010-10-22 06:02:11.976 (5) [main]: parseDouble->[0.0] 2010-10-22 06:02:11.976 (5) [main]: parseDouble<-[0.0] 2010-10-22 06:02:11.976 (5) [main]: parseDouble->[0.0] 2010-10-22 06:02:11.977 (5) [main]: parseDouble<-[0.0] 2010-10-22 06:02:11.977 (5) [main]: parseDouble->[32449.0] 2010-10-22 06:02:11.977 (5) [main]: parseDouble<-[32449.0] 2010-10-22 06:02:11.977 (5) [main]: parseDouble->[16.0] 2010-10-22 06:02:11.977 (5) [main]: parseDouble<-[16.0] 2010-10-22 06:02:11.977 (5) [main]: parseDouble->[0.0] 2010-10-22 06:02:11.977 (5) [main]: parseDouble<-[0.0] 2010-10-22 06:02:11.977 (5) [main]: parseDouble->[0.0] 2010-10-22 06:02:11.977 (5) [main]: parseDouble<-[0.0] 2010-10-22 06:02:11.977 (4) [main]: Publisher Datafeed Conversion INFO Values: Alt key[FB230511050184] Creative Key[null] Date key[FB_20101002] Cost Key[0.0] Count key[12745.0] Revenue Key[0.0] Account Key[17] seConv[0] seValue[0.0] seImps: 32449] seClicks[16] seAvgPos: 0.0 2010-10-22 06:02:11.977 (4) [main]: Publisher conversion object created for [FB230511050184], product= Unique Impressions - feed for FB_20101002 with account id 17 2010-10-22 06:02:11.977 (5) [main]: parseInteger->[66851] 2010-10-22 06:02:11.977 (5) [main]: parseInteger<-[66851] 2010-10-22 06:02:11.977 (4) [main]: -- productCode[Unique Impressions - feed] prodID[66851] 2010-10-22 06:02:11.978 (5) [main]: parseInteger->[177] 2010-10-22 06:02:11.978 (5) [main]: parseInteger<-[177] java.text.ParseException: Unparseable date: "FB_20101002" at java.text.DateFormat.parse(DateFormat.java:335) at com.thesearchagency.datafeeds.BaseDataFeed.formatSQLTime(BaseDataFeed.java:1618) at com.thesearchagency.datafeeds.BaseDataFeed.formatSQLTime(BaseDataFeed.java:1599) at com.thesearchagency.datafeeds.generic.PublisherGenericDataFeed.getTimeDayFormat(PublisherGenericDataFeed.java:474) at com.thesearchagency.datafeeds.generic.PublisherGenericDataFeed.processArray(PublisherGenericDataFeed.java:298) at com.thesearchagency.datafeeds.generic.PublisherGenericDataFeed.process(PublisherGenericDataFeed.java:548) at com.thesearchagency.datafeeds.BaseDataFeed.processZipFile(BaseDataFeed.java:984) at com.thesearchagency.datafeeds.BaseDataFeed.processDataFile(BaseDataFeed.java:798) at com.thesearchagency.datafeeds.generic.PublisherGenericDataFeed.processDataFile(PublisherGenericDataFeed.java:422) at com.thesearchagency.datafeeds.BaseDataFeed.run(BaseDataFeed.java:378) at com.thesearchagency.datafeeds.generic.PublisherGenericDataFeed.main(PublisherGenericDataFeed.java:77) 2010-10-22 06:02:12.160 (5) [main]: quoteValue(), nothing special about it=>[17], type=class java.lang.Integer 2010-10-22 06:02:12.160 (5) [main]: quoteValue(), nothing special about it=>[177], type=class java.lang.Integer 2010-10-22 06:02:12.160 (5) [main]: quoteValue(), nothing special about it=>[66851], type=class java.lang.Integer 2010-10-22 06:02:12.161 (5) [main]: quoteValue(), nothing special about it=>[35], type=class java.lang.Integer 2010-10-22 06:02:12.161 (5) [main]: quoteValue(), nothing special about it=>[86400], type=class java.lang.Integer 2010-10-22 06:02:12.161 (5) [main]: quoteValue(), nothing special about it=>[558002261], type=class java.lang.Integer 2010-10-22 06:02:12.161 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-22 06:02:12.161 (4) [main]: spike: SQL->[select * from `publisherProductSummary` where ((`accountID`=17) and (`distributionID`=177) and (`productID`=66851) and (`siteID`=35) and (`resolution`=86400) and (`sourceID`=558002261)) limit 1] 2010-10-22 06:02:12.165 (5) [main]: recordAsSubs("db", 4, "main") 2010-10-22 06:02:12.165 (5) [main]: ProfilerRec.end("db", true): ret=4 2010-10-22 06:02:12.165 (4) [main]: time=0.0040 2010-10-22 06:02:12.166 (4) [main]: Query executed in 0.004s 2010-10-22 06:02:12.166 (4) [main]: Record Not Found 2010-10-22 06:02:12.166 (5) [main]: quoteValue(), nothing special about it=>[17], type=class java.lang.Integer 2010-10-22 06:02:12.166 (5) [main]: quoteValue(), nothing special about it=>[0.0], type=class java.lang.Double 2010-10-22 06:02:12.167 (5) [main]: quoteValue(), nothing special about it=>[177], type=class java.lang.Integer 2010-10-22 06:02:12.167 (5) [main]: quoteValue(), nothing special about it=>[66851], type=class java.lang.Integer 2010-10-22 06:02:12.167 (5) [main]: quoteValue(), nothing special about it=>[35], type=class java.lang.Integer 2010-10-22 06:02:12.167 (5) [main]: quoteValue(), nothing special about it=>[86400], type=class java.lang.Integer 2010-10-22 06:02:12.167 (5) [main]: quoteValue(), nothing special about it=>[12745.0], type=class java.lang.Double 2010-10-22 06:02:12.167 (5) [main]: quoteValue(), nothing special about it=>[558002261], type=class java.lang.Integer 2010-10-22 06:02:12.168 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-22 06:02:12.168 (4) [main]: spike: SQL->[replace into `publisherProductSummary` (`accountID`,`value`,`distributionID`,`productID`,`siteID`,`resolution`,`count`,`sourceID`) values (17,0.0,177,66851,35,86400,12745.0,558002261)], genflags=yes 2010-10-22 06:02:12.170 (5) [main]: recordAsSubs("db", 2, "main") 2010-10-22 06:02:12.170 (5) [main]: ProfilerRec.end("db", true): ret=2 2010-10-22 06:02:12.171 (4) [main]: time=0.0020 2010-10-22 06:02:12.171 (4) [main]: Query executed in 0.002s, 1 row(s) affected 2010-10-22 06:02:12.171 (4) [main]: saved publisher product summary for source [558002261] count(seConv) = 12745.0 value(seValue) = 0.0 2010-10-22 06:02:12.172 (4) [main]: Checking refcd=[FB230511050184] 2010-10-22 06:02:12.173 (5) [main]: parseDouble->[16] 2010-10-22 06:02:12.174 (5) [main]: parseDouble<-[16.0] 2010-10-22 06:02:12.174 (5) [main]: parseDouble->[0] 2010-10-22 06:02:12.174 (5) [main]: parseDouble<-[0.0] 2010-10-22 06:02:12.174 (5) [main]: parseDouble->[32449] 2010-10-22 06:02:12.174 (5) [main]: parseDouble<-[32449.0] 2010-10-22 06:02:12.177 (5) [main]: parseDouble->[16] 2010-10-22 06:02:12.178 (5) [main]: parseDouble<-[16.0] 2010-10-22 06:02:12.178 (5) [main]: parseDouble->[16.0] 2010-10-22 06:02:12.178 (5) [main]: parseDouble<-[16.0] 2010-10-22 06:02:12.178 (5) [main]: parseDouble->[0.0] 2010-10-22 06:02:12.178 (5) [main]: parseDouble<-[0.0] 2010-10-22 06:02:12.178 (5) [main]: parseDouble->[0.0] 2010-10-22 06:02:12.178 (5) [main]: parseDouble<-[0.0] 2010-10-22 06:02:12.179 (5) [main]: parseDouble->[0.0] 2010-10-22 06:02:12.179 (5) [main]: parseDouble<-[0.0] 2010-10-22 06:02:12.179 (5) [main]: parseDouble->[0.0] 2010-10-22 06:02:12.179 (5) [main]: parseDouble<-[0.0] 2010-10-22 06:02:12.179 (5) [main]: parseDouble->[32449.0] 2010-10-22 06:02:12.179 (5) [main]: parseDouble<-[32449.0] 2010-10-22 06:02:12.179 (5) [main]: parseDouble->[16.0] 2010-10-22 06:02:12.179 (5) [main]: parseDouble<-[16.0] 2010-10-22 06:02:12.179 (5) [main]: parseDouble->[0.0] 2010-10-22 06:02:12.179 (5) [main]: parseDouble<-[0.0] 2010-10-22 06:02:12.180 (5) [main]: parseDouble->[0.0] 2010-10-22 06:02:12.180 (5) [main]: parseDouble<-[0.0] 2010-10-22 06:02:12.180 (4) [main]: Publisher Datafeed Conversion INFO Values: Alt key[FB230511050184] Creative Key[null] Date key[FB_20101002] Cost Key[0.0] Count key[16.0] Revenue Key[0.0] Account Key[17] seConv[0] seValue[0.0] seImps: 32449] seClicks[16] seAvgPos: 0.0 2010-10-22 06:02:12.180 (4) [main]: Publisher conversion object created for [FB230511050184], product= Unique Clicks - feed for FB_20101002 with account id 17 2010-10-22 06:02:12.180 (5) [main]: parseInteger->[66861] 2010-10-22 06:02:12.180 (5) [main]: parseInteger<-[66861] 2010-10-22 06:02:12.180 (4) [main]: -- productCode[Unique Clicks - feed] prodID[66861] 2010-10-22 06:02:12.180 (5) [main]: parseInteger->[177] 2010-10-22 06:02:12.181 (5) [main]: parseInteger<-[177] java.text.ParseException: Unparseable date: "FB_20101002" at java.text.DateFormat.parse(DateFormat.java:335) at com.thesearchagency.datafeeds.BaseDataFeed.formatSQLTime(BaseDataFeed.java:1618) at com.thesearchagency.datafeeds.BaseDataFeed.formatSQLTime(BaseDataFeed.java:1599) at com.thesearchagency.datafeeds.generic.PublisherGenericDataFeed.getTimeDayFormat(PublisherGenericDataFeed.java:474) at com.thesearchagency.datafeeds.generic.PublisherGenericDataFeed.processArray(PublisherGenericDataFeed.java:298) at com.thesearchagency.datafeeds.generic.PublisherGenericDataFeed.process(PublisherGenericDataFeed.java:548) at com.thesearchagency.datafeeds.BaseDataFeed.processZipFile(BaseDataFeed.java:984) at com.thesearchagency.datafeeds.BaseDataFeed.processDataFile(BaseDataFeed.java:798) at com.thesearchagency.datafeeds.generic.PublisherGenericDataFeed.processDataFile(PublisherGenericDataFeed.java:422) at com.thesearchagency.datafeeds.BaseDataFeed.run(BaseDataFeed.java:378) at com.thesearchagency.datafeeds.generic.PublisherGenericDataFeed.main(PublisherGenericDataFeed.java:77) 2010-10-22 06:02:12.182 (5) [main]: quoteValue(), nothing special about it=>[17], type=class java.lang.Integer 2010-10-22 06:02:12.183 (5) [main]: quoteValue(), nothing special about it=>[177], type=class java.lang.Integer 2010-10-22 06:02:12.183 (5) [main]: quoteValue(), nothing special about it=>[66861], type=class java.lang.Integer 2010-10-22 06:02:12.183 (5) [main]: quoteValue(), nothing special about it=>[35], type=class java.lang.Integer 2010-10-22 06:02:12.183 (5) [main]: quoteValue(), nothing special about it=>[86400], type=class java.lang.Integer 2010-10-22 06:02:12.183 (5) [main]: quoteValue(), nothing special about it=>[558002261], type=class java.lang.Integer 2010-10-22 06:02:12.184 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-22 06:02:12.184 (4) [main]: spike: SQL->[select * from `publisherProductSummary` where ((`accountID`=17) and (`distributionID`=177) and (`productID`=66861) and (`siteID`=35) and (`resolution`=86400) and (`sourceID`=558002261)) limit 1] 2010-10-22 06:02:12.187 (5) [main]: recordAsSubs("db", 3, "main") 2010-10-22 06:02:12.187 (5) [main]: ProfilerRec.end("db", true): ret=3 2010-10-22 06:02:12.187 (4) [main]: time=0.0030 2010-10-22 06:02:12.187 (4) [main]: Query executed in 0.003s 2010-10-22 06:02:12.188 (4) [main]: Record Not Found 2010-10-22 06:02:12.188 (5) [main]: quoteValue(), nothing special about it=>[17], type=class java.lang.Integer 2010-10-22 06:02:12.188 (5) [main]: quoteValue(), nothing special about it=>[0.0], type=class java.lang.Double 2010-10-22 06:02:12.188 (5) [main]: quoteValue(), nothing special about it=>[177], type=class java.lang.Integer 2010-10-22 06:02:12.188 (5) [main]: quoteValue(), nothing special about it=>[66861], type=class java.lang.Integer 2010-10-22 06:02:12.189 (5) [main]: quoteValue(), nothing special about it=>[35], type=class java.lang.Integer 2010-10-22 06:02:12.189 (5) [main]: quoteValue(), nothing special about it=>[86400], type=class java.lang.Integer 2010-10-22 06:02:12.189 (5) [main]: quoteValue(), nothing special about it=>[16.0], type=class java.lang.Double 2010-10-22 06:02:12.189 (5) [main]: quoteValue(), nothing special about it=>[558002261], type=class java.lang.Integer 2010-10-22 06:02:12.189 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-22 06:02:12.189 (4) [main]: spike: SQL->[replace into `publisherProductSummary` (`accountID`,`value`,`distributionID`,`productID`,`siteID`,`resolution`,`count`,`sourceID`) values (17,0.0,177,66861,35,86400,16.0,558002261)], genflags=yes 2010-10-22 06:02:12.191 (5) [main]: recordAsSubs("db", 2, "main") 2010-10-22 06:02:12.192 (5) [main]: ProfilerRec.end("db", true): ret=2 2010-10-22 06:02:12.192 (4) [main]: time=0.0020 2010-10-22 06:02:12.192 (4) [main]: Query executed in 0.002s, 1 row(s) affected 2010-10-22 06:02:12.192 (4) [main]: saved publisher product summary for source [558002261] count(seConv) = 16.0 value(seValue) = 0.0 2010-10-22 06:02:12.194 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-22 06:02:12.194 (4) [main]: spike: SQL->[select * from `dataAvailability` where ((`dataSourceID`="223001") and (`date`="2010-10-20 03:00:00")) limit 1] 2010-10-22 06:02:12.289 (5) [main]: recordAsSubs("db", 94, "main") 2010-10-22 06:02:12.291 (5) [main]: ProfilerRec.end("db", true): ret=94 2010-10-22 06:02:12.292 (4) [main]: time=0.094 2010-10-22 06:02:12.292 (4) [main]: Query executed in 0.094s 2010-10-22 06:02:12.292 (4) [main]: Record Not Found 2010-10-22 06:02:12.293 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-22 06:02:12.293 (4) [main]: spike: SQL->[replace into `dataAvailability` (`override`,`dataSourceID`,`status`,`date`,`updated`) values ("false","223001","success","2010-10-20 03:00:00","2010-10-22 06:02:12")], genflags=yes 2010-10-22 06:02:12.296 (2) [main]: Warning(s) detected in statement [replace into `dataAvailability` (`override`,`dataSourceID`,`status`,`date`,`updated`) values ("false","223001","success","2010-10-20 03:00:00","2010-10-22 06:02:12")] executed by user [spike] 2010-10-22 06:02:12.297 (2) [main]: SQL Note: Data truncated for column 'date' at row 1 (code:1265) 2010-10-22 06:02:12.297 (5) [main]: recordAsSubs("db", 4, "main") 2010-10-22 06:02:12.297 (5) [main]: ProfilerRec.end("db", true): ret=4 2010-10-22 06:02:12.297 (4) [main]: time=0.0040 2010-10-22 06:02:12.297 (4) [main]: Query executed in 0.004s, 1 row(s) affected 2010-10-22 06:02:12.298 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-22 06:02:12.299 (4) [main]: spike: SQL->[insert into `dataAvailabilityHistory` (`override`,`dataSourceID`,`status`,`date`,`updated`) values ("false","223001","success","2010-10-20 03:00:00","2010-10-22 06:02:12")], genflags=yes 2010-10-22 06:02:12.301 (2) [main]: Warning(s) detected in statement [insert into `dataAvailabilityHistory` (`override`,`dataSourceID`,`status`,`date`,`updated`) values ("false","223001","success","2010-10-20 03:00:00","2010-10-22 06:02:12")] executed by user [spike] 2010-10-22 06:02:12.302 (2) [main]: SQL Note: Data truncated for column 'date' at row 1 (code:1265) 2010-10-22 06:02:12.302 (5) [main]: recordAsSubs("db", 3, "main") 2010-10-22 06:02:12.302 (5) [main]: ProfilerRec.end("db", true): ret=3 2010-10-22 06:02:12.303 (4) [main]: time=0.0030 2010-10-22 06:02:12.303 (4) [main]: Query executed in 0.003s, 1 row(s) affected 2010-10-22 06:02:12.304 (3) [main]: calling warehouse summarization with args: --debug 5 --accountid 17 --distribution 177 --date 2010-10-02 --publisher 2010-10-22 06:02:12.336 (3) [main]: Debug Level set to 5 2010-10-22 06:02:12.336 (4) [main]: limited to Distribution(s) (177) 2010-10-22 06:02:12.336 (2) [main]: No granularity given, all 2010-10-22 06:02:12.337 (3) [main]: =============== Starting Warehouse Summarizer ================ 2010-10-22 06:02:12.337 (4) [main]: no account, or instance for databaseInstance, skipping lookup... 2010-10-22 06:02:12.337 (3) [main]: ----------------Warehouse Summarizer starting 2010-10-22 06:02:12.370 (4) [main]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2010-10-22 06:02:12.371 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-22 06:02:12.371 (4) [main]: spike: SQL->[select * from `tsacommon`.`accounts` where ((`tsacommon`.`accounts`.`id` in (17))) order by `tsacommon`.`accounts`.`tier` asc,`tsacommon`.`accounts`.`priority` asc,`tsacommon`.`accounts`.`id` desc] 2010-10-22 06:02:12.374 (5) [main]: recordAsSubs("db", 3, "main") 2010-10-22 06:02:12.374 (5) [main]: ProfilerRec.end("db", true): ret=3 2010-10-22 06:02:12.374 (4) [main]: time=0.0030 2010-10-22 06:02:12.374 (4) [main]: Query executed in 0.003s 2010-10-22 06:02:12.374 (5) [main]: loading 19 columns from result set: 2010-10-22 06:02:12.375 (5) [main]: loaded column: accounts.id->17 2010-10-22 06:02:12.375 (5) [main]: loaded column: accounts.description->WWMW - Cellular Safety Commission 2010-10-22 06:02:12.375 (5) [main]: loaded column: accounts.tier->2 2010-10-22 06:02:12.375 (5) [main]: loaded column: accounts.priority->60 2010-10-22 06:02:12.375 (5) [main]: loaded column: accounts.reportClicksOut->false 2010-10-22 06:02:12.376 (5) [main]: loaded column: accounts.reportConversions->true 2010-10-22 06:02:12.376 (5) [main]: loaded column: accounts.conversionTypes-> 2010-10-22 06:02:12.376 (5) [main]: loaded column: accounts.isBidManaged->true 2010-10-22 06:02:12.376 (5) [main]: loaded column: accounts.isActive->true 2010-10-22 06:02:12.376 (5) [main]: loaded column: accounts.perfMetric->roi 2010-10-22 06:02:12.377 (5) [main]: loaded column: accounts.providesConversionData->true 2010-10-22 06:02:12.377 (5) [main]: loaded column: accounts.addConversionData->false 2010-10-22 06:02:12.377 (5) [main]: loaded column: accounts.fractionalConversionCounts->false 2010-10-22 06:02:12.377 (5) [main]: loaded column: accounts.hideNullSources->false 2010-10-22 06:02:12.377 (5) [main]: loaded column: accounts.nowTime->null 2010-10-22 06:02:12.377 (5) [main]: skipping invalid column: accounts.warehouseDatabase 2010-10-22 06:02:12.377 (5) [main]: loaded column: accounts.databaseInstance->1 2010-10-22 06:02:12.378 (5) [main]: loaded column: accounts.warehouseInstance->1 2010-10-22 06:02:12.378 (5) [main]: loaded column: accounts.isOnline->true 2010-10-22 06:02:12.378 (4) [main]: DataCache: put key dwh 17 2010-10-22 06:02:12.378 (4) [main]: no account, or instance for databaseInstance, skipping lookup... 2010-10-22 06:02:12.475 (4) [main]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2010-10-22 06:02:12.475 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-22 06:02:12.476 (4) [main]: spike: SQL->[select * from `tsacommon`.`databaseInstances` where ((`type`="mysql") and (`name`="dwh-1")) limit 1] 2010-10-22 06:02:12.478 (5) [main]: recordAsSubs("db", 2, "main") 2010-10-22 06:02:12.478 (5) [main]: ProfilerRec.end("db", true): ret=2 2010-10-22 06:02:12.478 (4) [main]: time=0.0020 2010-10-22 06:02:12.478 (4) [main]: Query executed in 0.002s 2010-10-22 06:02:12.478 (5) [main]: loading 8 columns from result set: 2010-10-22 06:02:12.478 (5) [main]: loaded column: databaseInstances.id->8 2010-10-22 06:02:12.479 (5) [main]: loaded column: databaseInstances.name->dwh-1 2010-10-22 06:02:12.479 (5) [main]: loaded column: databaseInstances.description->Account-specific Warehouse 01 2010-10-22 06:02:12.487 (5) [main]: loaded column: databaseInstances.type->mysql 2010-10-22 06:02:12.487 (5) [main]: loaded column: databaseInstances.database->warehouse_1 2010-10-22 06:02:12.487 (5) [main]: loaded column: databaseInstances.host->dwh-01-write 2010-10-22 06:02:12.488 (5) [main]: loaded column: databaseInstances.port->3306 2010-10-22 06:02:12.488 (5) [main]: loaded column: databaseInstances.access->rw 2010-10-22 06:02:12.488 (4) [main]: Record Loaded 2010-10-22 06:02:12.489 (4) [main]: closed [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2010-10-22 06:02:12.489 (4) [main]: DatabaseAccounts.getDatabaseName() returning "warehouse_1" 2010-10-22 06:02:12.523 (4) [P1T1]: no account, or instance for databaseInstance, skipping lookup... 2010-10-22 06:02:12.523 (3) [P1T1]: DatabasePool with a limit of 80 created 2010-10-22 06:02:12.578 (4) [P1T1]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2010-10-22 06:02:12.578 (4) [P1T1]: Created new Object 2010-10-22 06:02:12.578 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-22 06:02:12.578 (4) [P1T1]: perfsum: SQL->[select @@version] 2010-10-22 06:02:12.581 (5) [P1T1]: recordAsSubs("db", 3, "P1T1") 2010-10-22 06:02:12.581 (5) [P1T1]: ProfilerRec.end("db", true): ret=3 2010-10-22 06:02:12.581 (4) [P1T1]: time=0.0030 2010-10-22 06:02:12.582 (4) [P1T1]: Query executed in 0.003s 2010-10-22 06:02:12.582 (4) [P1T1]: test query succeeded, returned "5.0.30-enterprise-gpl" 2010-10-22 06:02:12.582 (5) [P1T1]: quoteValue(), nothing special about it=>[17], type=class java.lang.Integer 2010-10-22 06:02:12.582 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-22 06:02:12.582 (4) [P1T1]: perfsum: SQL->[select * from `tsacommon`.`accounts` where (`tsacommon`.`accounts`.`id`=17) limit 1] 2010-10-22 06:02:12.585 (5) [P1T1]: recordAsSubs("db", 3, "P1T1") 2010-10-22 06:02:12.585 (5) [P1T1]: ProfilerRec.end("db", true): ret=3 2010-10-22 06:02:12.585 (4) [P1T1]: time=0.0030 2010-10-22 06:02:12.585 (4) [P1T1]: Query executed in 0.003s 2010-10-22 06:02:12.585 (5) [P1T1]: loading 19 columns from result set: 2010-10-22 06:02:12.585 (5) [P1T1]: loaded column: accounts.id->17 2010-10-22 06:02:12.586 (5) [P1T1]: loaded column: accounts.description->WWMW - Cellular Safety Commission 2010-10-22 06:02:12.586 (5) [P1T1]: loaded column: accounts.tier->2 2010-10-22 06:02:12.586 (5) [P1T1]: loaded column: accounts.priority->60 2010-10-22 06:02:12.586 (5) [P1T1]: loaded column: accounts.reportClicksOut->false 2010-10-22 06:02:12.586 (5) [P1T1]: loaded column: accounts.reportConversions->true 2010-10-22 06:02:12.587 (5) [P1T1]: loaded column: accounts.conversionTypes-> 2010-10-22 06:02:12.587 (5) [P1T1]: loaded column: accounts.isBidManaged->true 2010-10-22 06:02:12.587 (5) [P1T1]: loaded column: accounts.isActive->true 2010-10-22 06:02:12.587 (5) [P1T1]: loaded column: accounts.perfMetric->roi 2010-10-22 06:02:12.587 (5) [P1T1]: loaded column: accounts.providesConversionData->true 2010-10-22 06:02:12.587 (5) [P1T1]: loaded column: accounts.addConversionData->false 2010-10-22 06:02:12.588 (5) [P1T1]: loaded column: accounts.fractionalConversionCounts->false 2010-10-22 06:02:12.588 (5) [P1T1]: loaded column: accounts.hideNullSources->false 2010-10-22 06:02:12.588 (5) [P1T1]: loaded column: accounts.nowTime->null 2010-10-22 06:02:12.588 (5) [P1T1]: skipping invalid column: accounts.warehouseDatabase 2010-10-22 06:02:12.588 (5) [P1T1]: loaded column: accounts.databaseInstance->1 2010-10-22 06:02:12.589 (5) [P1T1]: loaded column: accounts.warehouseInstance->1 2010-10-22 06:02:12.589 (5) [P1T1]: loaded column: accounts.isOnline->true 2010-10-22 06:02:12.589 (4) [P1T1]: Record Loaded 2010-10-22 06:02:12.589 (4) [P1T1]: Returning Object to Pool 2010-10-22 06:02:12.589 (5) [P1T1]: yesterday: month=10, day=21, year=2010 2010-10-22 06:02:12.589 (4) [P1T1]: isYesterday = false 2010-10-22 06:02:12.590 (4) [P1T1]: DataCache: Found key acct-st-tracker 17 2010-10-22 06:02:12.590 (4) [P1T1]: DataCache: Found key acct-st-tracker-1 2010-10-22 06:02:12.590 (3) [P1T1]: DatabasePool with a limit of 80 created 2010-10-22 06:02:12.642 (4) [P1T1]: opened [jdbc:mysql://acctdb-01-write:3306/st-tracker?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2010-10-22 06:02:12.642 (4) [P1T1]: Created new Object 2010-10-22 06:02:12.642 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-22 06:02:12.642 (4) [P1T1]: perfsum: SQL->[select @@version] 2010-10-22 06:02:12.644 (5) [P1T1]: recordAsSubs("db", 2, "P1T1") 2010-10-22 06:02:12.645 (5) [P1T1]: ProfilerRec.end("db", true): ret=2 2010-10-22 06:02:12.645 (4) [P1T1]: time=0.0020 2010-10-22 06:02:12.645 (4) [P1T1]: Query executed in 0.002s 2010-10-22 06:02:12.645 (4) [P1T1]: test query succeeded, returned "5.1.49-rel11.3" 2010-10-22 06:02:12.645 (4) [P1T1]: DataCache: Found key dwh 17 2010-10-22 06:02:12.645 (4) [P1T1]: no account, or instance for databaseInstance, skipping lookup... 2010-10-22 06:02:12.671 (4) [P1T1]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2010-10-22 06:02:12.672 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-22 06:02:12.672 (4) [P1T1]: spike: SQL->[select * from `tsacommon`.`databaseInstances` where ((`type`="mysql") and (`name`="dwh-1")) limit 1] 2010-10-22 06:02:12.703 (5) [P1T1]: recordAsSubs("db", 31, "P1T1") 2010-10-22 06:02:12.704 (5) [P1T1]: ProfilerRec.end("db", true): ret=31 2010-10-22 06:02:12.704 (4) [P1T1]: time=0.031 2010-10-22 06:02:12.704 (4) [P1T1]: Query executed in 0.031s 2010-10-22 06:02:12.704 (5) [P1T1]: loading 8 columns from result set: 2010-10-22 06:02:12.704 (5) [P1T1]: loaded column: databaseInstances.id->8 2010-10-22 06:02:12.705 (5) [P1T1]: loaded column: databaseInstances.name->dwh-1 2010-10-22 06:02:12.705 (5) [P1T1]: loaded column: databaseInstances.description->Account-specific Warehouse 01 2010-10-22 06:02:12.705 (5) [P1T1]: loaded column: databaseInstances.type->mysql 2010-10-22 06:02:12.705 (5) [P1T1]: loaded column: databaseInstances.database->warehouse_1 2010-10-22 06:02:12.705 (5) [P1T1]: loaded column: databaseInstances.host->dwh-01-write 2010-10-22 06:02:12.705 (5) [P1T1]: loaded column: databaseInstances.port->3306 2010-10-22 06:02:12.705 (5) [P1T1]: loaded column: databaseInstances.access->rw 2010-10-22 06:02:12.705 (4) [P1T1]: Record Loaded 2010-10-22 06:02:12.705 (4) [P1T1]: DataCache: put key dwh-1 2010-10-22 06:02:12.706 (4) [P1T1]: closed [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2010-10-22 06:02:12.706 (3) [P1T1]: DatabasePool with a limit of 80 created 2010-10-22 06:02:12.748 (4) [P1T1]: opened [jdbc:mysql://dwh-01-write:3306/warehouse_1?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2010-10-22 06:02:12.748 (4) [P1T1]: Created new Object 2010-10-22 06:02:12.748 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-22 06:02:12.748 (4) [P1T1]: perfsum: SQL->[select @@version] 2010-10-22 06:02:12.750 (5) [P1T1]: recordAsSubs("db", 2, "P1T1") 2010-10-22 06:02:12.751 (5) [P1T1]: ProfilerRec.end("db", true): ret=2 2010-10-22 06:02:12.751 (4) [P1T1]: time=0.0020 2010-10-22 06:02:12.751 (4) [P1T1]: Query executed in 0.002s 2010-10-22 06:02:12.751 (4) [P1T1]: test query succeeded, returned "5.1.49-rel11.3" 2010-10-22 06:02:12.751 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-22 06:02:12.751 (4) [P1T1]: perfsum: SQL->[set net_read_timeout = 36000] 2010-10-22 06:02:12.753 (5) [P1T1]: recordAsSubs("db", 2, "P1T1") 2010-10-22 06:02:12.753 (5) [P1T1]: ProfilerRec.end("db", true): ret=2 2010-10-22 06:02:12.753 (4) [P1T1]: time=0.0020 2010-10-22 06:02:12.753 (4) [P1T1]: Query executed in 0.002s 2010-10-22 06:02:12.753 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-22 06:02:12.753 (4) [P1T1]: perfsum: SQL->[set net_write_timeout = 36000] 2010-10-22 06:02:12.755 (5) [P1T1]: recordAsSubs("db", 2, "P1T1") 2010-10-22 06:02:12.755 (5) [P1T1]: ProfilerRec.end("db", true): ret=2 2010-10-22 06:02:12.755 (4) [P1T1]: time=0.0020 2010-10-22 06:02:12.755 (4) [P1T1]: Query executed in 0.002s 2010-10-22 06:02:12.755 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-22 06:02:12.755 (4) [P1T1]: perfsum: SQL->[set net_read_timeout = 36000] 2010-10-22 06:02:12.757 (5) [P1T1]: recordAsSubs("db", 2, "P1T1") 2010-10-22 06:02:12.757 (5) [P1T1]: ProfilerRec.end("db", true): ret=2 2010-10-22 06:02:12.757 (4) [P1T1]: time=0.0020 2010-10-22 06:02:12.757 (4) [P1T1]: Query executed in 0.002s 2010-10-22 06:02:12.757 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-22 06:02:12.757 (4) [P1T1]: perfsum: SQL->[set net_write_timeout = 36000] 2010-10-22 06:02:12.759 (5) [P1T1]: recordAsSubs("db", 2, "P1T1") 2010-10-22 06:02:12.759 (5) [P1T1]: ProfilerRec.end("db", true): ret=2 2010-10-22 06:02:12.759 (4) [P1T1]: time=0.0020 2010-10-22 06:02:12.759 (4) [P1T1]: Query executed in 0.002s 2010-10-22 06:02:12.759 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-22 06:02:12.759 (4) [P1T1]: perfsum: SQL->[SELECT GET_LOCK('WarehouseSummarizer.syncDimensions.17', 300)] 2010-10-22 06:02:12.761 (5) [P1T1]: recordAsSubs("db", 2, "P1T1") 2010-10-22 06:02:12.761 (5) [P1T1]: ProfilerRec.end("db", true): ret=2 2010-10-22 06:02:12.761 (4) [P1T1]: time=0.0020 2010-10-22 06:02:12.761 (4) [P1T1]: Query executed in 0.002s 2010-10-22 06:02:12.763 (5) [P1T1]: quoteValue(), nothing special about it=>[17], type=class java.lang.Integer 2010-10-22 06:02:12.763 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-22 06:02:12.763 (4) [P1T1]: perfsum: SQL->[select * from `whDimensionSyncStatus` where (`accountID`=17) limit 1] 2010-10-22 06:02:12.782 (5) [P1T1]: recordAsSubs("db", 19, "P1T1") 2010-10-22 06:02:12.782 (5) [P1T1]: ProfilerRec.end("db", true): ret=19 2010-10-22 06:02:12.782 (4) [P1T1]: time=0.019 2010-10-22 06:02:12.782 (4) [P1T1]: Query executed in 0.019s 2010-10-22 06:02:12.782 (5) [P1T1]: loading 2 columns from result set: 2010-10-22 06:02:12.782 (5) [P1T1]: loaded column: whDimensionSyncStatus.accountID->17 2010-10-22 06:02:12.791 (5) [P1T1]: loaded column: whDimensionSyncStatus.syncTime->2010-10-22 05:40:48.0 2010-10-22 06:02:12.791 (4) [P1T1]: Record Loaded 2010-10-22 06:02:12.791 (3) [P1T1]: Skipping sync of dimensions for acct #17 (last sync was at 2010-10-22 05:40:48.0) 2010-10-22 06:02:12.792 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-22 06:02:12.792 (4) [P1T1]: perfsum: SQL->[SELECT RELEASE_LOCK('WarehouseSummarizer.syncDimensions.17')] 2010-10-22 06:02:12.794 (5) [P1T1]: recordAsSubs("db", 2, "P1T1") 2010-10-22 06:02:12.794 (5) [P1T1]: ProfilerRec.end("db", true): ret=2 2010-10-22 06:02:12.794 (4) [P1T1]: time=0.0020 2010-10-22 06:02:12.794 (4) [P1T1]: Query executed in 0.002s 2010-10-22 06:02:12.795 (3) [P1T1]: Starting daily for Account #17 WWMW - Cellular Safety Commission for Sat Oct 02 03:00:00 EDT 2010 2010-10-22 06:02:12.795 (3) [P1T1]: Updating perf rows that don't have a bidTargetID, but should... for Dist(s) (177) 2010-10-22 06:02:12.797 (5) [P1T1]: quoteValue(), nothing special about it=>[17], type=class java.lang.Integer 2010-10-22 06:02:12.809 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-22 06:02:12.809 (4) [P1T1]: perfsum: SQL->[select `whDailySourcePerf`.`id`,`whDailySourcePerf`.`distributionID`,`whDailySourcePerf`.`searchEngineAccountID`,`whDailySourcePerf`.`searchEngineGroupID`,`whDailySourcePerf`.`searchEngineMatchType`,`whIdentifiers`.`searchEngineIdentifier`,`whDescriptions`.`description` from `warehouse_1`.`whDailySourcePerf` inner join `tsacommon`.`distribution` on ((`whDailySourcePerf`.`distributionID`=`tsacommon`.`distribution`.`id`)) left outer join `warehouse_1`.`whDescriptions` on ((`whDailySourcePerf`.`descriptionID`=`whDescriptions`.`id`)) left outer join `warehouse_1`.`whIdentifiers` on ((`whDailySourcePerf`.`identifierID`=`whIdentifiers`.`id`)) where ((((((`whDailySourcePerf`.`startTime`="2010-10-02 03:00:00")) and (`whDailySourcePerf`.`accountID`=17) and (`whDailySourcePerf`.`bidTargetID`<"1") and (`whDailySourcePerf`.`searchEngineAccountID`>"0") and (`tsacommon`.`distribution`.`searchEngineClass` is not null) and (`whDailySourcePerf`.`distributionID` in (177)))) and (((((`whIdentifiers`.`searchEngineIdentifier` is not null)) or ((`whDescriptions`.`description` is not null)))))))] 2010-10-22 06:02:12.858 (5) [P1T1]: recordAsSubs("db", 48, "P1T1") 2010-10-22 06:02:12.858 (5) [P1T1]: ProfilerRec.end("db", true): ret=48 2010-10-22 06:02:12.858 (4) [P1T1]: time=0.048 2010-10-22 06:02:12.858 (4) [P1T1]: Query executed in 0.048s 2010-10-22 06:02:12.859 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-22 06:02:12.859 (4) [P1T1]: perfsum: SQL->[select COUNT(*) from `warehouse_1`.`whDailySourcePerf` inner join `tsacommon`.`distribution` on ((`whDailySourcePerf`.`distributionID`=`tsacommon`.`distribution`.`id`)) where (((`whDailySourcePerf`.`startTime`="2010-10-02 03:00:00")) and (`whDailySourcePerf`.`accountID`=17) and (`whDailySourcePerf`.`bidTargetID`<"1") and (`whDailySourcePerf`.`searchEngineAccountID`>"0") and (`tsacommon`.`distribution`.`searchEngineClass` is not null) and (`whDailySourcePerf`.`distributionID` in (177)))] 2010-10-22 06:02:12.861 (5) [P1T1]: recordAsSubs("db", 2, "P1T1") 2010-10-22 06:02:12.861 (5) [P1T1]: ProfilerRec.end("db", true): ret=2 2010-10-22 06:02:12.861 (4) [P1T1]: time=0.0020 2010-10-22 06:02:12.862 (4) [P1T1]: Query executed in 0.002s 2010-10-22 06:02:12.865 (5) [P1T1]: quoteValue(), nothing special about it=>[86400], type=class java.lang.Integer 2010-10-22 06:02:12.865 (5) [P1T1]: quoteValue(), nothing special about it=>[17], type=class java.lang.Integer 2010-10-22 06:02:12.866 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-22 06:02:12.866 (4) [P1T1]: perfsum: SQL->[select * from `publisherActivitySummary` join `sources` on ((`sources`.`id`=`publisherActivitySummary`.`sourceID`)) where (((`publisherActivitySummary`.`startTime`="2010-10-02 03:00:00")) and (`publisherActivitySummary`.`resolution`=86400) and (`publisherActivitySummary`.`accountID`=17) and (`sources`.`distributionID` in (177))) limit 1] 2010-10-22 06:02:12.869 (5) [P1T1]: recordAsSubs("db", 3, "P1T1") 2010-10-22 06:02:12.869 (5) [P1T1]: ProfilerRec.end("db", true): ret=3 2010-10-22 06:02:12.869 (4) [P1T1]: time=0.0030 2010-10-22 06:02:12.870 (4) [P1T1]: Query executed in 0.003s 2010-10-22 06:02:12.870 (3) [P1T1]: no publisher data for account #17 in dist (177) 2010-10-22 06:02:12.870 (3) [P1T1]: Finished daily for Account #17 WWMW - Cellular Safety Commission on Sat Oct 02 03:00:00 EDT 2010 2010-10-22 06:02:12.871 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-22 06:02:12.871 (4) [P1T1]: perfsum: SQL->[select * from `dataSources` where ((`accountID`="17") and (`type`="wh_lowgran")) limit 1] 2010-10-22 06:02:12.874 (5) [P1T1]: recordAsSubs("db", 3, "P1T1") 2010-10-22 06:02:12.874 (5) [P1T1]: ProfilerRec.end("db", true): ret=3 2010-10-22 06:02:12.874 (4) [P1T1]: time=0.0030 2010-10-22 06:02:12.874 (4) [P1T1]: Query executed in 0.003s 2010-10-22 06:02:12.874 (5) [P1T1]: loading 4 columns from result set: 2010-10-22 06:02:12.874 (5) [P1T1]: loaded column: dataSources.id->8602 2010-10-22 06:02:12.874 (5) [P1T1]: loaded column: dataSources.type->wh_lowgran 2010-10-22 06:02:12.875 (5) [P1T1]: loaded column: dataSources.typeID->null 2010-10-22 06:02:12.875 (5) [P1T1]: loaded column: dataSources.accountID->17 2010-10-22 06:02:12.875 (4) [P1T1]: Record Loaded 2010-10-22 06:02:12.876 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-22 06:02:12.877 (4) [P1T1]: perfsum: SQL->[select * from `dataAvailability` where ((`dataSourceID`="8602") and (`date`="2010-10-02 03:00:00")) limit 1] 2010-10-22 06:02:12.879 (5) [P1T1]: recordAsSubs("db", 2, "P1T1") 2010-10-22 06:02:12.879 (5) [P1T1]: ProfilerRec.end("db", true): ret=2 2010-10-22 06:02:12.879 (4) [P1T1]: time=0.0020 2010-10-22 06:02:12.879 (4) [P1T1]: Query executed in 0.002s 2010-10-22 06:02:12.879 (4) [P1T1]: Record Not Found 2010-10-22 06:02:12.881 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-22 06:02:12.881 (4) [P1T1]: perfsum: SQL->[select * from `dataAvailability` where ((`dataSourceID`="8602") and (`date`="2010-10-02 03:00:00")) limit 1] 2010-10-22 06:02:12.883 (5) [P1T1]: recordAsSubs("db", 2, "P1T1") 2010-10-22 06:02:12.883 (5) [P1T1]: ProfilerRec.end("db", true): ret=2 2010-10-22 06:02:12.883 (4) [P1T1]: time=0.0020 2010-10-22 06:02:12.883 (4) [P1T1]: Query executed in 0.002s 2010-10-22 06:02:12.883 (4) [P1T1]: Record Not Found 2010-10-22 06:02:12.885 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-22 06:02:12.885 (4) [P1T1]: perfsum: SQL->[replace into `dataAvailability` (`override`,`dataSourceID`,`status`,`date`,`updated`) values ("false","8602","in progress","2010-10-02 03:00:00","2010-10-22 06:02:12")], genflags=yes 2010-10-22 06:02:12.887 (2) [P1T1]: Warning(s) detected in statement [replace into `dataAvailability` (`override`,`dataSourceID`,`status`,`date`,`updated`) values ("false","8602","in progress","2010-10-02 03:00:00","2010-10-22 06:02:12")] executed by user [perfsum] 2010-10-22 06:02:12.889 (2) [P1T1]: SQL Note: Data truncated for column 'date' at row 1 (code:1265) 2010-10-22 06:02:12.889 (5) [P1T1]: recordAsSubs("db", 4, "P1T1") 2010-10-22 06:02:12.889 (5) [P1T1]: ProfilerRec.end("db", true): ret=4 2010-10-22 06:02:12.889 (4) [P1T1]: time=0.0040 2010-10-22 06:02:12.889 (4) [P1T1]: Query executed in 0.004s, 1 row(s) affected 2010-10-22 06:02:12.891 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-22 06:02:12.891 (4) [P1T1]: perfsum: SQL->[insert into `dataAvailabilityHistory` (`override`,`dataSourceID`,`status`,`date`,`updated`) values ("false","8602","in progress","2010-10-02 03:00:00","2010-10-22 06:02:12")], genflags=yes 2010-10-22 06:02:12.923 (2) [P1T1]: Warning(s) detected in statement [insert into `dataAvailabilityHistory` (`override`,`dataSourceID`,`status`,`date`,`updated`) values ("false","8602","in progress","2010-10-02 03:00:00","2010-10-22 06:02:12")] executed by user [perfsum] 2010-10-22 06:02:12.924 (2) [P1T1]: SQL Note: Data truncated for column 'date' at row 1 (code:1265) 2010-10-22 06:02:12.925 (5) [P1T1]: recordAsSubs("db", 33, "P1T1") 2010-10-22 06:02:12.925 (5) [P1T1]: ProfilerRec.end("db", true): ret=33 2010-10-22 06:02:12.925 (4) [P1T1]: time=0.033 2010-10-22 06:02:12.925 (4) [P1T1]: Query executed in 0.033s, 1 row(s) affected 2010-10-22 06:02:12.925 (3) [P1T1]: Starting Account #17 WWMW - Cellular Safety Commission aggregates for Sat Oct 02 03:00:00 EDT 2010 to [17], type=class java.lang.Integer 2010-10-22 06:02:13.593 (5) [P1T1]: quoteValue(), nothing special about it=>[17], type=class java.lang.Integer 2010-10-22 06:02:13.595 (5) [P1T1]: quoteValue(), nothing special about it=>[17], type=class java.lang.Integer 2010-10-22 06:02:13.605 (5) [P1T1]: quoteValue(), nothing special about it=>[0], type=class java.lang.Integer 2010-10-22 06:02:13.605 (5) [P1T1]: quoteValue(), nothing special about it=>[5], type=class java.lang.Integer 2010-10-22 06:02:14.052 (4) [P1T1]: DB IsolationLevel -> 8 2010-10-22 06:02:14.053 (4) [P1T1]: DB AutoCommit -> false 2010-10-22 06:02:14.054 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-22 06:02:14.054 (4) [P1T1]: perfsum: SQL->[delete from `warehouse_1`.`whWeeklySourceConv` where ((`accountID`=17) and ((((`startTime`>=STR_TO_DATE(CONCAT(DATE_FORMAT("2010-10-02 03:00:00","%x%v")," Monday"),"%x%v %W"))) and ((`startTime`[delete from `warehouse_1`.`whWeeklySourcePerf` where ((`accountID`=17) and ((((`startTime`>=STR_TO_DATE(CONCAT(DATE_FORMAT("2010-10-02 03:00:00","%x%v")," Monday"),"%x%v %W"))) and ((`startTime`[delete from `warehouse_1`.`whWeeklySourceAttr` where ((`accountID`=17) and ((((`startTime`>=STR_TO_DATE(CONCAT(DATE_FORMAT("2010-10-02 03:00:00","%x%v")," Monday"),"%x%v %W"))) and ((`startTime`[insert into `warehouse_1`.`whWeeklySourcePerf` (`accountID`,`startTime`,`distributionID`,`campaignID`,`searchEngineAccountID`,`searchEngineGroupID`,`searchEngineListingID`,`searchEngineMatchType`,`type`,`identifierID`,`descriptionID`,`altKeyID`,`bidTargetID`,`nonSearchTag`,`pixImpressions`,`seImpressions`,`impressions`,`pixClicks`,`seClicks`,`clicks`,`pixAdCost`,`seAdCost`,`adCost`,`avgPosition`,`id`) select `accountID`,STR_TO_DATE(CONCAT(DATE_FORMAT(`startTime`,"%x%v")," Monday"),"%x%v %W") AS `startTime`,`distributionID`,`campaignID`,`searchEngineAccountID`,`searchEngineGroupID`,`searchEngineListingID`,`searchEngineMatchType`,`type`,`identifierID`,`descriptionID`,`altKeyID`,`bidTargetID`,`nonSearchTag`,ifnull(SUM(`whDailySourcePerf`.`pixImpressions`), 0) AS `pixImpressions`,ifnull(SUM(`whDailySourcePerf`.`seImpressions`), 0) AS `seImpressions`,ifnull(SUM(`whDailySourcePerf`.`impressions`), 0) AS `impressions`,ifnull(SUM(`whDailySourcePerf`.`pixClicks`), 0) AS `pixClicks`,ifnull(SUM(`whDailySourcePerf`.`seClicks`), 0) AS `seClicks`,ifnull(SUM(`whDailySourcePerf`.`clicks`), 0) AS `clicks`,ifnull(SUM(`whDailySourcePerf`.`pixAdCost`), 0) AS `pixAdCost`,ifnull(SUM(`whDailySourcePerf`.`seAdCost`), 0) AS `seAdCost`,ifnull(SUM(`whDailySourcePerf`.`adCost`), 0) AS `adCost`,ifnull(if(`whDailySourcePerf`.`distributionID` in (86,101,122),AVG(if(`avgPosition`=0,null,`avgPosition`)),IF((SUM(`seImpressions`)>0), ROUND(SUM(`avgPosition` * `seImpressions`) / SUM(`seImpressions`),5), 0)),0) AS `avgPosition`,MAX(`whDailySourcePerf`.`id`) AS `id` from `warehouse_1`.`whDailySourcePerf` where ((`accountID`=17) and ((((`startTime`>=STR_TO_DATE(CONCAT(DATE_FORMAT("2010-10-02 03:00:00","%x%v")," Monday"),"%x%v %W"))) and ((`startTime`[create temporary table `tmp`.`tmp1` engine=myisam character set latin1 collate latin1_swedish_ci select `whDailySourcePerf`.`accountID`,STR_TO_DATE(CONCAT(DATE_FORMAT(`whDailySourcePerf`.`startTime`,"%x%v")," Monday"),"%x%v %W") AS `startTime`,`whDailySourcePerf`.`distributionID`,`whDailySourcePerf`.`campaignID`,`whDailySourcePerf`.`searchEngineAccountID`,`whDailySourcePerf`.`searchEngineGroupID`,`whDailySourcePerf`.`searchEngineListingID`,`whDailySourcePerf`.`searchEngineMatchType`,`whDailySourcePerf`.`type`,`whDailySourcePerf`.`identifierID`,`whDailySourcePerf`.`descriptionID`,`whDailySourcePerf`.`altKeyID`,`whDailySourcePerf`.`bidTargetID`,`whDailySourcePerf`.`nonSearchTag`,`whDailySourceConv`.`scope`,`whDailySourceConv`.`productID`,ifnull(SUM(`whDailySourceConv`.`pixFulfillCost`), 0) AS `pixFulfillCost`,ifnull(SUM(`whDailySourceConv`.`clFulfillCost`), 0) AS `clFulfillCost`,ifnull(SUM(`whDailySourceConv`.`fulfillCost`), 0) AS `fulfillCost`,ifnull(SUM(`whDailySourceConv`.`pixConversions`), 0) AS `pixConversions`,ifnull(SUM(`whDailySourceConv`.`seConversions`), 0) AS `seConversions`,ifnull(SUM(`whDailySourceConv`.`clConversions`), 0) AS `clConversions`,ifnull(SUM(`whDailySourceConv`.`conversions`), 0) AS `conversions`,ifnull(SUM(`whDailySourceConv`.`pixValue`), 0) AS `pixValue`,ifnull(SUM(`whDailySourceConv`.`seValue`), 0) AS `seValue`,ifnull(SUM(`whDailySourceConv`.`clValue`), 0) AS `clValue`,ifnull(SUM(`whDailySourceConv`.`value`), 0) AS `value` from `warehouse_1`.`whDailySourceConv` inner join `warehouse_1`.`whDailySourcePerf` on ((`whDailySourceConv`.`perfID`=`whDailySourcePerf`.`id`)) where ((`whDailySourceConv`.`accountID`=17) and ((((`whDailySourceConv`.`startTime`>=STR_TO_DATE(CONCAT(DATE_FORMAT("2010-10-02 03:00:00","%x%v")," Monday"),"%x%v %W"))) and ((`whDailySourceConv`.`startTime`[insert into `warehouse_1`.`whWeeklySourceConv` (`startTime`,`accountID`,`perfID`,`scope`,`productID`,`pixFulfillCost`,`clFulfillCost`,`fulfillCost`,`pixConversions`,`seConversions`,`clConversions`,`conversions`,`pixValue`,`seValue`,`clValue`,`value`) select `tmp`.`tmp1`.`startTime`,`tmp`.`tmp1`.`accountID`,`whWeeklySourcePerf`.`id`,`tmp`.`tmp1`.`scope`,`tmp`.`tmp1`.`productID`,`tmp`.`tmp1`.`pixFulfillCost`,`tmp`.`tmp1`.`clFulfillCost`,`tmp`.`tmp1`.`fulfillCost`,`tmp`.`tmp1`.`pixConversions`,`tmp`.`tmp1`.`seConversions`,`tmp`.`tmp1`.`clConversions`,`tmp`.`tmp1`.`conversions`,`tmp`.`tmp1`.`pixValue`,`tmp`.`tmp1`.`seValue`,`tmp`.`tmp1`.`clValue`,`tmp`.`tmp1`.`value` from `warehouse_1`.`whWeeklySourcePerf` inner join `tmp`.`tmp1` on (((`whWeeklySourcePerf`.`accountID`=`tmp`.`tmp1`.`accountID`) and (`whWeeklySourcePerf`.`startTime`=`tmp`.`tmp1`.`startTime`) and (`whWeeklySourcePerf`.`distributionID`=`tmp`.`tmp1`.`distributionID`) and (`whWeeklySourcePerf`.`campaignID`=`tmp`.`tmp1`.`campaignID`) and (`whWeeklySourcePerf`.`searchEngineAccountID`=`tmp`.`tmp1`.`searchEngineAccountID`) and (`whWeeklySourcePerf`.`searchEngineGroupID`=`tmp`.`tmp1`.`searchEngineGroupID`) and (`whWeeklySourcePerf`.`searchEngineListingID`=`tmp`.`tmp1`.`searchEngineListingID`) and (`whWeeklySourcePerf`.`searchEngineMatchType`=`tmp`.`tmp1`.`searchEngineMatchType`) and (`whWeeklySourcePerf`.`type`=`tmp`.`tmp1`.`type`) and (`whWeeklySourcePerf`.`identifierID`=`tmp`.`tmp1`.`identifierID`) and (`whWeeklySourcePerf`.`descriptionID`=`tmp`.`tmp1`.`descriptionID`) and (`whWeeklySourcePerf`.`altKeyID`=`tmp`.`tmp1`.`altKeyID`)))], genflags=no 2010-10-22 06:02:15.061 (5) [P1T1]: recordAsSubs("db", 3, "P1T1") 2010-10-22 06:02:15.061 (5) [P1T1]: ProfilerRec.end("db", true): ret=3 2010-10-22 06:02:15.062 (4) [P1T1]: time=0.0030 2010-10-22 06:02:15.062 (4) [P1T1]: Query executed in 0.003s, 0 row(s) affected 2010-10-22 06:02:15.062 (3) [P1T1]: ... 0 Weekly Source Conversion Records Inserted 2010-10-22 06:02:15.063 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-22 06:02:15.063 (4) [P1T1]: perfsum: SQL->[create temporary table `tmp`.`tmp2` engine=myisam character set latin1 collate latin1_swedish_ci select `whDailySourcePerf`.`accountID`,STR_TO_DATE(CONCAT(DATE_FORMAT(`whDailySourcePerf`.`startTime`,"%x%v")," Monday"),"%x%v %W") AS `startTime`,`whDailySourcePerf`.`distributionID`,`whDailySourcePerf`.`campaignID`,`whDailySourcePerf`.`searchEngineAccountID`,`whDailySourcePerf`.`searchEngineGroupID`,`whDailySourcePerf`.`searchEngineListingID`,`whDailySourcePerf`.`searchEngineMatchType`,`whDailySourcePerf`.`type`,`whDailySourcePerf`.`identifierID`,`whDailySourcePerf`.`descriptionID`,`whDailySourcePerf`.`altKeyID`,`whDailySourcePerf`.`bidTargetID`,`whDailySourcePerf`.`nonSearchTag`,cast(if(mod(avg(bidTypeID),1.0) > 0, 3, avg(bidTypeID)) as unsigned) AS `bidTypeID`,AVG(`whDailySourceAttr`.`qualityScore`) AS `qualityScore` from `warehouse_1`.`whDailySourceAttr` inner join `warehouse_1`.`whDailySourcePerf` on ((`whDailySourceAttr`.`perfID`=`whDailySourcePerf`.`id`)) where ((`whDailySourceAttr`.`accountID`=17) and ((((`whDailySourceAttr`.`startTime`>=STR_TO_DATE(CONCAT(DATE_FORMAT("2010-10-02 03:00:00","%x%v")," Monday"),"%x%v %W"))) and ((`whDailySourceAttr`.`startTime`[insert into `warehouse_1`.`whWeeklySourceAttr` (`startTime`,`accountID`,`perfID`,`bidTypeID`,`qualityScore`) select `tmp`.`tmp2`.`startTime`,`tmp`.`tmp2`.`accountID`,`whWeeklySourcePerf`.`id`,`tmp`.`tmp2`.`bidTypeID`,`tmp`.`tmp2`.`qualityScore` from `warehouse_1`.`whWeeklySourcePerf` inner join `tmp`.`tmp2` on (((`whWeeklySourcePerf`.`accountID`=`tmp`.`tmp2`.`accountID`) and (`whWeeklySourcePerf`.`startTime`=`tmp`.`tmp2`.`startTime`) and (`whWeeklySourcePerf`.`distributionID`=`tmp`.`tmp2`.`distributionID`) and (`whWeeklySourcePerf`.`campaignID`=`tmp`.`tmp2`.`campaignID`) and (`whWeeklySourcePerf`.`searchEngineAccountID`=`tmp`.`tmp2`.`searchEngineAccountID`) and (`whWeeklySourcePerf`.`searchEngineGroupID`=`tmp`.`tmp2`.`searchEngineGroupID`) and (`whWeeklySourcePerf`.`searchEngineListingID`=`tmp`.`tmp2`.`searchEngineListingID`) and (`whWeeklySourcePerf`.`searchEngineMatchType`=`tmp`.`tmp2`.`searchEngineMatchType`) and (`whWeeklySourcePerf`.`type`=`tmp`.`tmp2`.`type`) and (`whWeeklySourcePerf`.`identifierID`=`tmp`.`tmp2`.`identifierID`) and (`whWeeklySourcePerf`.`descriptionID`=`tmp`.`tmp2`.`descriptionID`) and (`whWeeklySourcePerf`.`altKeyID`=`tmp`.`tmp2`.`altKeyID`)))], genflags=no 2010-10-22 06:02:15.146 (5) [P1T1]: recordAsSubs("db", 4, "P1T1") 2010-10-22 06:02:15.146 (5) [P1T1]: ProfilerRec.end("db", true): ret=4 2010-10-22 06:02:15.147 (4) [P1T1]: time=0.0040 2010-10-22 06:02:15.147 (4) [P1T1]: Query executed in 0.004s, 38 row(s) affected 2010-10-22 06:02:15.147 (3) [P1T1]: ... 38 Weekly Source Attribute Records Inserted 2010-10-22 06:02:15.148 (4) [P1T1]: perfsum: SQL->[commit] 2010-10-22 06:02:15.148 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-22 06:02:15.149 (5) [P1T1]: recordAsSubs("db", 1, "P1T1") 2010-10-22 06:02:15.149 (5) [P1T1]: ProfilerRec.end("db", true): ret=1 2010-10-22 06:02:15.150 (4) [P1T1]: time=0.0010 2010-10-22 06:02:15.150 (4) [P1T1]: Query executed in 0.001s 2010-10-22 06:02:15.150 (4) [P1T1]: DB AutoCommit -> true 2010-10-22 06:02:15.151 (4) [P1T1]: DB IsolationLevel -> 4 2010-10-22 06:02:15.184 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-22 06:02:15.185 (4) [P1T1]: perfsum: SQL->[drop table `tmp`.`tmp1`] 2010-10-22 06:02:15.187 (5) [P1T1]: recordAsSubs("db", 2, "P1T1") 2010-10-22 06:02:15.187 (5) [P1T1]: ProfilerRec.end("db", true): ret=2 2010-10-22 06:02:15.188 (4) [P1T1]: time=0.0020 2010-10-22 06:02:15.188 (4) [P1T1]: Query executed in 0.002s 2010-10-22 06:02:15.188 (5) [P1T1]: SQL execute() returned false 2010-10-22 06:02:15.189 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-22 06:02:15.189 (4) [P1T1]: perfsum: SQL->[drop table `tmp`.`tmp2`] 2010-10-22 06:02:15.191 (5) [P1T1]: recordAsSubs("db", 2, "P1T1") 2010-10-22 06:02:15.191 (5) [P1T1]: ProfilerRec.end("db", true): ret=2 2010-10-22 06:02:15.191 (4) [P1T1]: time=0.0020 2010-10-22 06:02:15.192 (4) [P1T1]: Query executed in 0.002s 2010-10-22 06:02:15.192 (5) [P1T1]: SQL execute() returned false 2010-10-22 06:02:15.192 (5) [P1T1]: quoteValue(), nothing special about it=>[17], type=class java.lang.Integer 2010-10-22 06:02:15.193 (5) [P1T1]: quoteValue(), nothing special about it=>[17], type=class java.lang.Integer 2010-10-22 06:02:15.195 (5) [P1T1]: quoteValue(), nothing special about it=>[17], type=class java.lang.Integer 2010-10-22 06:02:15.347 (5) [P1T1]: quoteValue(), nothing special about it=>[0], type=class java.lang.Integer 2010-10-22 06:02:15.348 (5) [P1T1]: quoteValue(), nothing special about it=>[5], type=class java.lang.Integer 2010-10-22 06:02:15.459 (4) [P1T1]: DB IsolationLevel -> 8 2010-10-22 06:02:15.460 (4) [P1T1]: DB AutoCommit -> false 2010-10-22 06:02:15.461 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-22 06:02:15.461 (4) [P1T1]: perfsum: SQL->[delete from `warehouse_1`.`whMonthlySourceConv` where ((`accountID`=17) and ((((`startTime`>=DATE_FORMAT("2010-10-02 03:00:00","%Y-%m-01"))) and ((`startTime`[delete from `warehouse_1`.`whMonthlySourcePerf` where ((`accountID`=17) and ((((`startTime`>=DATE_FORMAT("2010-10-02 03:00:00","%Y-%m-01"))) and ((`startTime`[delete from `warehouse_1`.`whMonthlySourceAttr` where ((`accountID`=17) and ((((`startTime`>=DATE_FORMAT("2010-10-02 03:00:00","%Y-%m-01"))) and ((`startTime`[insert into `warehouse_1`.`whMonthlySourcePerf` (`accountID`,`startTime`,`distributionID`,`campaignID`,`searchEngineAccountID`,`searchEngineGroupID`,`searchEngineListingID`,`searchEngineMatchType`,`type`,`identifierID`,`descriptionID`,`altKeyID`,`bidTargetID`,`nonSearchTag`,`pixImpressions`,`seImpressions`,`impressions`,`pixClicks`,`seClicks`,`clicks`,`pixAdCost`,`seAdCost`,`adCost`,`avgPosition`,`id`) select `accountID`,DATE_FORMAT(`startTime`,"%Y-%m-01") AS `startTime`,`distributionID`,`campaignID`,`searchEngineAccountID`,`searchEngineGroupID`,`searchEngineListingID`,`searchEngineMatchType`,`type`,`identifierID`,`descriptionID`,`altKeyID`,`bidTargetID`,`nonSearchTag`,ifnull(SUM(`whDailySourcePerf`.`pixImpressions`), 0) AS `pixImpressions`,ifnull(SUM(`whDailySourcePerf`.`seImpressions`), 0) AS `seImpressions`,ifnull(SUM(`whDailySourcePerf`.`impressions`), 0) AS `impressions`,ifnull(SUM(`whDailySourcePerf`.`pixClicks`), 0) AS `pixClicks`,ifnull(SUM(`whDailySourcePerf`.`seClicks`), 0) AS `seClicks`,ifnull(SUM(`whDailySourcePerf`.`clicks`), 0) AS `clicks`,ifnull(SUM(`whDailySourcePerf`.`pixAdCost`), 0) AS `pixAdCost`,ifnull(SUM(`whDailySourcePerf`.`seAdCost`), 0) AS `seAdCost`,ifnull(SUM(`whDailySourcePerf`.`adCost`), 0) AS `adCost`,ifnull(if(`whDailySourcePerf`.`distributionID` in (86,101,122),AVG(if(`avgPosition`=0,null,`avgPosition`)),IF((SUM(`seImpressions`)>0), ROUND(SUM(`avgPosition` * `seImpressions`) / SUM(`seImpressions`),5), 0)),0) AS `avgPosition`,MAX(`whDailySourcePerf`.`id`) AS `id` from `warehouse_1`.`whDailySourcePerf` where ((`accountID`=17) and ((((`startTime`>=DATE_FORMAT("2010-10-02 03:00:00","%Y-%m-01"))) and ((`startTime`[create temporary table `tmp`.`tmp3` engine=myisam character set latin1 collate latin1_swedish_ci select `whDailySourcePerf`.`accountID`,DATE_FORMAT(`whDailySourcePerf`.`startTime`,"%Y-%m-01") AS `startTime`,`whDailySourcePerf`.`distributionID`,`whDailySourcePerf`.`campaignID`,`whDailySourcePerf`.`searchEngineAccountID`,`whDailySourcePerf`.`searchEngineGroupID`,`whDailySourcePerf`.`searchEngineListingID`,`whDailySourcePerf`.`searchEngineMatchType`,`whDailySourcePerf`.`type`,`whDailySourcePerf`.`identifierID`,`whDailySourcePerf`.`descriptionID`,`whDailySourcePerf`.`altKeyID`,`whDailySourcePerf`.`bidTargetID`,`whDailySourcePerf`.`nonSearchTag`,`whDailySourceConv`.`scope`,`whDailySourceConv`.`productID`,ifnull(SUM(`whDailySourceConv`.`pixFulfillCost`), 0) AS `pixFulfillCost`,ifnull(SUM(`whDailySourceConv`.`clFulfillCost`), 0) AS `clFulfillCost`,ifnull(SUM(`whDailySourceConv`.`fulfillCost`), 0) AS `fulfillCost`,ifnull(SUM(`whDailySourceConv`.`pixConversions`), 0) AS `pixConversions`,ifnull(SUM(`whDailySourceConv`.`seConversions`), 0) AS `seConversions`,ifnull(SUM(`whDailySourceConv`.`clConversions`), 0) AS `clConversions`,ifnull(SUM(`whDailySourceConv`.`conversions`), 0) AS `conversions`,ifnull(SUM(`whDailySourceConv`.`pixValue`), 0) AS `pixValue`,ifnull(SUM(`whDailySourceConv`.`seValue`), 0) AS `seValue`,ifnull(SUM(`whDailySourceConv`.`clValue`), 0) AS `clValue`,ifnull(SUM(`whDailySourceConv`.`value`), 0) AS `value` from `warehouse_1`.`whDailySourceConv` inner join `warehouse_1`.`whDailySourcePerf` on ((`whDailySourceConv`.`perfID`=`whDailySourcePerf`.`id`)) where ((`whDailySourceConv`.`accountID`=17) and ((((`whDailySourceConv`.`startTime`>=DATE_FORMAT("2010-10-02 03:00:00","%Y-%m-01"))) and ((`whDailySourceConv`.`startTime`[insert into `warehouse_1`.`whMonthlySourceConv` (`startTime`,`accountID`,`perfID`,`scope`,`productID`,`pixFulfillCost`,`clFulfillCost`,`fulfillCost`,`pixConversions`,`seConversions`,`clConversions`,`conversions`,`pixValue`,`seValue`,`clValue`,`value`) select `tmp`.`tmp3`.`startTime`,`tmp`.`tmp3`.`accountID`,`whMonthlySourcePerf`.`id`,`tmp`.`tmp3`.`scope`,`tmp`.`tmp3`.`productID`,`tmp`.`tmp3`.`pixFulfillCost`,`tmp`.`tmp3`.`clFulfillCost`,`tmp`.`tmp3`.`fulfillCost`,`tmp`.`tmp3`.`pixConversions`,`tmp`.`tmp3`.`seConversions`,`tmp`.`tmp3`.`clConversions`,`tmp`.`tmp3`.`conversions`,`tmp`.`tmp3`.`pixValue`,`tmp`.`tmp3`.`seValue`,`tmp`.`tmp3`.`clValue`,`tmp`.`tmp3`.`value` from `warehouse_1`.`whMonthlySourcePerf` inner join `tmp`.`tmp3` on (((`whMonthlySourcePerf`.`accountID`=`tmp`.`tmp3`.`accountID`) and (`whMonthlySourcePerf`.`startTime`=`tmp`.`tmp3`.`startTime`) and (`whMonthlySourcePerf`.`distributionID`=`tmp`.`tmp3`.`distributionID`) and (`whMonthlySourcePerf`.`campaignID`=`tmp`.`tmp3`.`campaignID`) and (`whMonthlySourcePerf`.`searchEngineAccountID`=`tmp`.`tmp3`.`searchEngineAccountID`) and (`whMonthlySourcePerf`.`searchEngineGroupID`=`tmp`.`tmp3`.`searchEngineGroupID`) and (`whMonthlySourcePerf`.`searchEngineListingID`=`tmp`.`tmp3`.`searchEngineListingID`) and (`whMonthlySourcePerf`.`searchEngineMatchType`=`tmp`.`tmp3`.`searchEngineMatchType`) and (`whMonthlySourcePerf`.`type`=`tmp`.`tmp3`.`type`) and (`whMonthlySourcePerf`.`identifierID`=`tmp`.`tmp3`.`identifierID`) and (`whMonthlySourcePerf`.`descriptionID`=`tmp`.`tmp3`.`descriptionID`) and (`whMonthlySourcePerf`.`altKeyID`=`tmp`.`tmp3`.`altKeyID`)))], genflags=no 2010-10-22 06:02:15.976 (5) [P1T1]: recordAsSubs("db", 3, "P1T1") 2010-10-22 06:02:15.976 (5) [P1T1]: ProfilerRec.end("db", true): ret=3 2010-10-22 06:02:15.976 (4) [P1T1]: time=0.0030 2010-10-22 06:02:15.976 (4) [P1T1]: Query executed in 0.003s, 3 row(s) affected 2010-10-22 06:02:15.977 (3) [P1T1]: ... 3 Monthly Source Conversion Records Inserted 2010-10-22 06:02:15.977 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-22 06:02:15.977 (4) [P1T1]: perfsum: SQL->[create temporary table `tmp`.`tmp4` engine=myisam character set latin1 collate latin1_swedish_ci select `whDailySourcePerf`.`accountID`,DATE_FORMAT(`whDailySourcePerf`.`startTime`,"%Y-%m-01") AS `startTime`,`whDailySourcePerf`.`distributionID`,`whDailySourcePerf`.`campaignID`,`whDailySourcePerf`.`searchEngineAccountID`,`whDailySourcePerf`.`searchEngineGroupID`,`whDailySourcePerf`.`searchEngineListingID`,`whDailySourcePerf`.`searchEngineMatchType`,`whDailySourcePerf`.`type`,`whDailySourcePerf`.`identifierID`,`whDailySourcePerf`.`descriptionID`,`whDailySourcePerf`.`altKeyID`,`whDailySourcePerf`.`bidTargetID`,`whDailySourcePerf`.`nonSearchTag`,cast(if(mod(avg(bidTypeID),1.0) > 0, 3, avg(bidTypeID)) as unsigned) AS `bidTypeID`,AVG(`whDailySourceAttr`.`qualityScore`) AS `qualityScore` from `warehouse_1`.`whDailySourceAttr` inner join `warehouse_1`.`whDailySourcePerf` on ((`whDailySourceAttr`.`perfID`=`whDailySourcePerf`.`id`)) where ((`whDailySourceAttr`.`accountID`=17) and ((((`whDailySourceAttr`.`startTime`>=DATE_FORMAT("2010-10-02 03:00:00","%Y-%m-01"))) and ((`whDailySourceAttr`.`startTime`[insert into `warehouse_1`.`whMonthlySourceAttr` (`startTime`,`accountID`,`perfID`,`bidTypeID`,`qualityScore`) select `tmp`.`tmp4`.`startTime`,`tmp`.`tmp4`.`accountID`,`whMonthlySourcePerf`.`id`,`tmp`.`tmp4`.`bidTypeID`,`tmp`.`tmp4`.`qualityScore` from `warehouse_1`.`whMonthlySourcePerf` inner join `tmp`.`tmp4` on (((`whMonthlySourcePerf`.`accountID`=`tmp`.`tmp4`.`accountID`) and (`whMonthlySourcePerf`.`startTime`=`tmp`.`tmp4`.`startTime`) and (`whMonthlySourcePerf`.`distributionID`=`tmp`.`tmp4`.`distributionID`) and (`whMonthlySourcePerf`.`campaignID`=`tmp`.`tmp4`.`campaignID`) and (`whMonthlySourcePerf`.`searchEngineAccountID`=`tmp`.`tmp4`.`searchEngineAccountID`) and (`whMonthlySourcePerf`.`searchEngineGroupID`=`tmp`.`tmp4`.`searchEngineGroupID`) and (`whMonthlySourcePerf`.`searchEngineListingID`=`tmp`.`tmp4`.`searchEngineListingID`) and (`whMonthlySourcePerf`.`searchEngineMatchType`=`tmp`.`tmp4`.`searchEngineMatchType`) and (`whMonthlySourcePerf`.`type`=`tmp`.`tmp4`.`type`) and (`whMonthlySourcePerf`.`identifierID`=`tmp`.`tmp4`.`identifierID`) and (`whMonthlySourcePerf`.`descriptionID`=`tmp`.`tmp4`.`descriptionID`) and (`whMonthlySourcePerf`.`altKeyID`=`tmp`.`tmp4`.`altKeyID`)))], genflags=no 2010-10-22 06:02:16.053 (5) [P1T1]: recordAsSubs("db", 15, "P1T1") 2010-10-22 06:02:16.053 (5) [P1T1]: ProfilerRec.end("db", true): ret=15 2010-10-22 06:02:16.053 (4) [P1T1]: time=0.015 2010-10-22 06:02:16.053 (4) [P1T1]: Query executed in 0.015s, 25 row(s) affected 2010-10-22 06:02:16.053 (3) [P1T1]: ... 25 Monthly Source Attribute Records Inserted 2010-10-22 06:02:16.053 (4) [P1T1]: perfsum: SQL->[commit] 2010-10-22 06:02:16.054 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-22 06:02:16.060 (5) [P1T1]: recordAsSubs("db", 6, "P1T1") 2010-10-22 06:02:16.061 (5) [P1T1]: ProfilerRec.end("db", true): ret=6 2010-10-22 06:02:16.061 (4) [P1T1]: time=0.0060 2010-10-22 06:02:16.061 (4) [P1T1]: Query executed in 0.006s 2010-10-22 06:02:16.061 (4) [P1T1]: DB AutoCommit -> true 2010-10-22 06:02:16.068 (4) [P1T1]: DB IsolationLevel -> 4 2010-10-22 06:02:16.076 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-22 06:02:16.077 (4) [P1T1]: perfsum: SQL->[drop table `tmp`.`tmp3`] 2010-10-22 06:02:16.092 (5) [P1T1]: recordAsSubs("db", 15, "P1T1") 2010-10-22 06:02:16.093 (5) [P1T1]: ProfilerRec.end("db", true): ret=15 2010-10-22 06:02:16.093 (4) [P1T1]: time=0.015 2010-10-22 06:02:16.093 (4) [P1T1]: Query executed in 0.015s 2010-10-22 06:02:16.093 (5) [P1T1]: SQL execute() returned false 2010-10-22 06:02:16.093 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-22 06:02:16.093 (4) [P1T1]: perfsum: SQL->[drop table `tmp`.`tmp4`] 2010-10-22 06:02:16.097 (5) [P1T1]: recordAsSubs("db", 4, "P1T1") 2010-10-22 06:02:16.097 (5) [P1T1]: ProfilerRec.end("db", true): ret=4 2010-10-22 06:02:16.097 (4) [P1T1]: time=0.0040 2010-10-22 06:02:16.097 (4) [P1T1]: Query executed in 0.004s 2010-10-22 06:02:16.097 (5) [P1T1]: SQL execute() returned false 2010-10-22 06:02:16.098 (5) [P1T1]: quoteValue(), nothing special about it=>[17], type=class java.lang.Integer 2010-10-22 06:02:16.099 (5) [P1T1]: quoteValue(), nothing special about it=>[17], type=class java.lang.Integer 2010-10-22 06:02:16.100 (5) [P1T1]: quoteValue(), nothing special about it=>[17], type=class java.lang.Integer 2010-10-22 06:02:16.105 (5) [P1T1]: quoteValue(), nothing special about it=>[0], type=class java.lang.Integer 2010-10-22 06:02:16.105 (5) [P1T1]: quoteValue(), nothing special about it=>[5], type=class java.lang.Integer 2010-10-22 06:02:16.296 (4) [P1T1]: DB IsolationLevel -> 8 2010-10-22 06:02:16.416 (4) [P1T1]: DB AutoCommit -> false 2010-10-22 06:02:16.434 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-22 06:02:16.434 (4) [P1T1]: perfsum: SQL->[delete from `warehouse_1`.`whDailyGroupConv` where ((`accountID`=17) and ((((`startTime`>="2010-10-02 03:00:00")) and ((`startTime`<"2010-10-03 00:00:00")))))], genflags=no 2010-10-22 06:02:16.465 (5) [P1T1]: recordAsSubs("db", 31, "P1T1") 2010-10-22 06:02:16.466 (5) [P1T1]: ProfilerRec.end("db", true): ret=31 2010-10-22 06:02:16.466 (4) [P1T1]: time=0.031 2010-10-22 06:02:16.466 (4) [P1T1]: Query executed in 0.031s, 0 row(s) affected 2010-10-22 06:02:16.466 (4) [P1T1]: ... 0 Daily Group Conversion Records Cleared 2010-10-22 06:02:16.466 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-22 06:02:16.466 (4) [P1T1]: perfsum: SQL->[delete from `warehouse_1`.`whDailyGroupPerf` where ((`accountID`=17) and ((((`startTime`>="2010-10-02 03:00:00")) and ((`startTime`<"2010-10-03 00:00:00")))))], genflags=no 2010-10-22 06:02:16.542 (5) [P1T1]: recordAsSubs("db", 76, "P1T1") 2010-10-22 06:02:16.543 (5) [P1T1]: ProfilerRec.end("db", true): ret=76 2010-10-22 06:02:16.543 (4) [P1T1]: time=0.076 2010-10-22 06:02:16.543 (4) [P1T1]: Query executed in 0.076s, 0 row(s) affected 2010-10-22 06:02:16.543 (4) [P1T1]: .... 0 Perf Records Cleared 2010-10-22 06:02:16.543 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-22 06:02:16.543 (4) [P1T1]: perfsum: SQL->[delete from `warehouse_1`.`whDailyGroupAttr` where ((`accountID`=17) and ((((`startTime`>="2010-10-02 03:00:00")) and ((`startTime`<"2010-10-03 00:00:00")))))], genflags=no 2010-10-22 06:02:16.558 (5) [P1T1]: recordAsSubs("db", 15, "P1T1") 2010-10-22 06:02:16.559 (5) [P1T1]: ProfilerRec.end("db", true): ret=15 2010-10-22 06:02:16.559 (4) [P1T1]: time=0.015 2010-10-22 06:02:16.559 (4) [P1T1]: Query executed in 0.015s, 0 row(s) affected 2010-10-22 06:02:16.559 (4) [P1T1]: .... 0 Attr Records Cleared 2010-10-22 06:02:16.559 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-22 06:02:16.559 (4) [P1T1]: perfsum: SQL->[insert into `warehouse_1`.`whDailyGroupPerf` (`accountID`,`startTime`,`distributionID`,`campaignID`,`searchEngineAccountID`,`searchEngineGroupID`,`searchEngineListingID`,`searchEngineMatchType`,`type`,`nonSearchTag`,`pixImpressions`,`seImpressions`,`impressions`,`pixClicks`,`seClicks`,`clicks`,`pixAdCost`,`seAdCost`,`adCost`,`avgPosition`,`id`) select `accountID`,`startTime` AS `startTime`,`distributionID`,`campaignID`,`searchEngineAccountID`,`searchEngineGroupID`,`searchEngineListingID`,`searchEngineMatchType`,`type`,`nonSearchTag`,ifnull(SUM(`whDailySourcePerf`.`pixImpressions`), 0) AS `pixImpressions`,ifnull(SUM(`whDailySourcePerf`.`seImpressions`), 0) AS `seImpressions`,ifnull(SUM(`whDailySourcePerf`.`impressions`), 0) AS `impressions`,ifnull(SUM(`whDailySourcePerf`.`pixClicks`), 0) AS `pixClicks`,ifnull(SUM(`whDailySourcePerf`.`seClicks`), 0) AS `seClicks`,ifnull(SUM(`whDailySourcePerf`.`clicks`), 0) AS `clicks`,ifnull(SUM(`whDailySourcePerf`.`pixAdCost`), 0) AS `pixAdCost`,ifnull(SUM(`whDailySourcePerf`.`seAdCost`), 0) AS `seAdCost`,ifnull(SUM(`whDailySourcePerf`.`adCost`), 0) AS `adCost`,ifnull(if(`whDailySourcePerf`.`distributionID` in (86,101,122),AVG(if(`avgPosition`=0,null,`avgPosition`)),IF((SUM(`seImpressions`)>0), ROUND(SUM(`avgPosition` * `seImpressions`) / SUM(`seImpressions`),5), 0)),0) AS `avgPosition`,MAX(`whDailySourcePerf`.`id`) AS `id` from `warehouse_1`.`whDailySourcePerf` where ((`accountID`=17) and ((((`startTime`>="2010-10-02 03:00:00")) and ((`startTime`<"2010-10-03 00:00:00"))))) group by `whDailySourcePerf`.`accountID`,`whDailySourcePerf`.`startTime`,`whDailySourcePerf`.`distributionID`,`whDailySourcePerf`.`campaignID`,`whDailySourcePerf`.`searchEngineAccountID`,`whDailySourcePerf`.`searchEngineGroupID`,`whDailySourcePerf`.`searchEngineListingID`,`whDailySourcePerf`.`searchEngineMatchType`,`whDailySourcePerf`.`type`,`whDailySourcePerf`.`nonSearchTag`], genflags=no 2010-10-22 06:02:16.562 (5) [P1T1]: recordAsSubs("db", 3, "P1T1") 2010-10-22 06:02:16.562 (5) [P1T1]: ProfilerRec.end("db", true): ret=3 2010-10-22 06:02:16.563 (4) [P1T1]: time=0.0030 2010-10-22 06:02:16.563 (4) [P1T1]: Query executed in 0.003s, 0 row(s) affected 2010-10-22 06:02:16.563 (3) [P1T1]: ... 0 Daily Group Perf Records Inserted 2010-10-22 06:02:16.563 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-22 06:02:16.563 (4) [P1T1]: perfsum: SQL->[create temporary table `tmp`.`tmp5` engine=myisam character set latin1 collate latin1_swedish_ci select `whDailySourcePerf`.`accountID`,`whDailySourcePerf`.`startTime` AS `startTime`,`whDailySourcePerf`.`distributionID`,`whDailySourcePerf`.`campaignID`,`whDailySourcePerf`.`searchEngineAccountID`,`whDailySourcePerf`.`searchEngineGroupID`,`whDailySourcePerf`.`searchEngineListingID`,`whDailySourcePerf`.`searchEngineMatchType`,`whDailySourcePerf`.`type`,`whDailySourcePerf`.`nonSearchTag`,`whDailySourceConv`.`scope`,`whDailySourceConv`.`productID`,ifnull(SUM(`whDailySourceConv`.`pixFulfillCost`), 0) AS `pixFulfillCost`,ifnull(SUM(`whDailySourceConv`.`clFulfillCost`), 0) AS `clFulfillCost`,ifnull(SUM(`whDailySourceConv`.`fulfillCost`), 0) AS `fulfillCost`,ifnull(SUM(`whDailySourceConv`.`pixConversions`), 0) AS `pixConversions`,ifnull(SUM(`whDailySourceConv`.`seConversions`), 0) AS `seConversions`,ifnull(SUM(`whDailySourceConv`.`clConversions`), 0) AS `clConversions`,ifnull(SUM(`whDailySourceConv`.`conversions`), 0) AS `conversions`,ifnull(SUM(`whDailySourceConv`.`pixValue`), 0) AS `pixValue`,ifnull(SUM(`whDailySourceConv`.`seValue`), 0) AS `seValue`,ifnull(SUM(`whDailySourceConv`.`clValue`), 0) AS `clValue`,ifnull(SUM(`whDailySourceConv`.`value`), 0) AS `value` from `warehouse_1`.`whDailySourceConv` inner join `warehouse_1`.`whDailySourcePerf` on ((`whDailySourceConv`.`perfID`=`whDailySourcePerf`.`id`)) where ((`whDailySourceConv`.`accountID`=17) and ((((`whDailySourceConv`.`startTime`>="2010-10-02 03:00:00")) and ((`whDailySourceConv`.`startTime`<"2010-10-03 00:00:00"))))) group by `accountID`,`startTime`,`distributionID`,`campaignID`,`searchEngineAccountID`,`searchEngineGroupID`,`searchEngineListingID`,`searchEngineMatchType`,`type`,`nonSearchTag`,`whDailySourceConv`.`scope`,`whDailySourceConv`.`productID`] 2010-10-22 06:02:16.567 (5) [P1T1]: recordAsSubs("db", 4, "P1T1") 2010-10-22 06:02:16.568 (5) [P1T1]: ProfilerRec.end("db", true): ret=4 2010-10-22 06:02:16.568 (4) [P1T1]: time=0.0040 2010-10-22 06:02:16.568 (4) [P1T1]: Query executed in 0.004s 2010-10-22 06:02:16.568 (5) [P1T1]: SQL execute() returned false 2010-10-22 06:02:16.568 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-22 06:02:16.568 (4) [P1T1]: perfsum: SQL->[insert into `warehouse_1`.`whDailyGroupConv` (`startTime`,`accountID`,`perfID`,`scope`,`productID`,`pixFulfillCost`,`clFulfillCost`,`fulfillCost`,`pixConversions`,`seConversions`,`clConversions`,`conversions`,`pixValue`,`seValue`,`clValue`,`value`) select `tmp`.`tmp5`.`startTime`,`tmp`.`tmp5`.`accountID`,`whDailyGroupPerf`.`id`,`tmp`.`tmp5`.`scope`,`tmp`.`tmp5`.`productID`,`tmp`.`tmp5`.`pixFulfillCost`,`tmp`.`tmp5`.`clFulfillCost`,`tmp`.`tmp5`.`fulfillCost`,`tmp`.`tmp5`.`pixConversions`,`tmp`.`tmp5`.`seConversions`,`tmp`.`tmp5`.`clConversions`,`tmp`.`tmp5`.`conversions`,`tmp`.`tmp5`.`pixValue`,`tmp`.`tmp5`.`seValue`,`tmp`.`tmp5`.`clValue`,`tmp`.`tmp5`.`value` from `warehouse_1`.`whDailyGroupPerf` inner join `tmp`.`tmp5` on (((`whDailyGroupPerf`.`accountID`=`tmp`.`tmp5`.`accountID`) and (`whDailyGroupPerf`.`startTime`=`tmp`.`tmp5`.`startTime`) and (`whDailyGroupPerf`.`distributionID`=`tmp`.`tmp5`.`distributionID`) and (`whDailyGroupPerf`.`campaignID`=`tmp`.`tmp5`.`campaignID`) and (`whDailyGroupPerf`.`searchEngineAccountID`=`tmp`.`tmp5`.`searchEngineAccountID`) and (`whDailyGroupPerf`.`searchEngineGroupID`=`tmp`.`tmp5`.`searchEngineGroupID`) and (`whDailyGroupPerf`.`searchEngineListingID`=`tmp`.`tmp5`.`searchEngineListingID`) and (`whDailyGroupPerf`.`searchEngineMatchType`=`tmp`.`tmp5`.`searchEngineMatchType`) and (`whDailyGroupPerf`.`type`=`tmp`.`tmp5`.`type`) and (`whDailyGroupPerf`.`nonSearchTag`=`tmp`.`tmp5`.`nonSearchTag`)))], genflags=no 2010-10-22 06:02:16.571 (5) [P1T1]: recordAsSubs("db", 3, "P1T1") 2010-10-22 06:02:16.571 (5) [P1T1]: ProfilerRec.end("db", true): ret=3 2010-10-22 06:02:16.572 (4) [P1T1]: time=0.0030 2010-10-22 06:02:16.572 (4) [P1T1]: Query executed in 0.003s, 0 row(s) affected 2010-10-22 06:02:16.572 (3) [P1T1]: ... 0 Daily Group Conversion Records Inserted 2010-10-22 06:02:16.572 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-22 06:02:16.572 (4) [P1T1]: perfsum: SQL->[create temporary table `tmp`.`tmp6` engine=myisam character set latin1 collate latin1_swedish_ci select `whDailySourcePerf`.`accountID`,`whDailySourcePerf`.`startTime` AS `startTime`,`whDailySourcePerf`.`distributionID`,`whDailySourcePerf`.`campaignID`,`whDailySourcePerf`.`searchEngineAccountID`,`whDailySourcePerf`.`searchEngineGroupID`,`whDailySourcePerf`.`searchEngineListingID`,`whDailySourcePerf`.`searchEngineMatchType`,`whDailySourcePerf`.`type`,`whDailySourcePerf`.`nonSearchTag`,cast(if(mod(avg(bidTypeID),1.0) > 0, 3, avg(bidTypeID)) as unsigned) AS `bidTypeID`,AVG(`whDailySourceAttr`.`qualityScore`) AS `qualityScore` from `warehouse_1`.`whDailySourceAttr` inner join `warehouse_1`.`whDailySourcePerf` on ((`whDailySourceAttr`.`perfID`=`whDailySourcePerf`.`id`)) where ((`whDailySourceAttr`.`accountID`=17) and ((((`whDailySourceAttr`.`startTime`>="2010-10-02 03:00:00")) and ((`whDailySourceAttr`.`startTime`<"2010-10-03 00:00:00"))))) group by `accountID`,`startTime`,`distributionID`,`campaignID`,`searchEngineAccountID`,`searchEngineGroupID`,`searchEngineListingID`,`searchEngineMatchType`,`type`,`nonSearchTag`] 2010-10-22 06:02:16.576 (5) [P1T1]: recordAsSubs("db", 4, "P1T1") 2010-10-22 06:02:16.576 (5) [P1T1]: ProfilerRec.end("db", true): ret=4 2010-10-22 06:02:16.576 (4) [P1T1]: time=0.0040 2010-10-22 06:02:16.576 (4) [P1T1]: Query executed in 0.004s 2010-10-22 06:02:16.576 (5) [P1T1]: SQL execute() returned false 2010-10-22 06:02:16.576 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-22 06:02:16.577 (4) [P1T1]: perfsum: SQL->[insert into `warehouse_1`.`whDailyGroupAttr` (`startTime`,`accountID`,`perfID`,`bidTypeID`,`qualityScore`) select `tmp`.`tmp6`.`startTime`,`tmp`.`tmp6`.`accountID`,`whDailyGroupPerf`.`id`,`tmp`.`tmp6`.`bidTypeID`,`tmp`.`tmp6`.`qualityScore` from `warehouse_1`.`whDailyGroupPerf` inner join `tmp`.`tmp6` on (((`whDailyGroupPerf`.`accountID`=`tmp`.`tmp6`.`accountID`) and (`whDailyGroupPerf`.`startTime`=`tmp`.`tmp6`.`startTime`) and (`whDailyGroupPerf`.`distributionID`=`tmp`.`tmp6`.`distributionID`) and (`whDailyGroupPerf`.`campaignID`=`tmp`.`tmp6`.`campaignID`) and (`whDailyGroupPerf`.`searchEngineAccountID`=`tmp`.`tmp6`.`searchEngineAccountID`) and (`whDailyGroupPerf`.`searchEngineGroupID`=`tmp`.`tmp6`.`searchEngineGroupID`) and (`whDailyGroupPerf`.`searchEngineListingID`=`tmp`.`tmp6`.`searchEngineListingID`) and (`whDailyGroupPerf`.`searchEngineMatchType`=`tmp`.`tmp6`.`searchEngineMatchType`) and (`whDailyGroupPerf`.`type`=`tmp`.`tmp6`.`type`) and (`whDailyGroupPerf`.`nonSearchTag`=`tmp`.`tmp6`.`nonSearchTag`)))], genflags=no 2010-10-22 06:02:16.579 (5) [P1T1]: recordAsSubs("db", 3, "P1T1") 2010-10-22 06:02:16.579 (5) [P1T1]: ProfilerRec.end("db", true): ret=3 2010-10-22 06:02:16.579 (4) [P1T1]: time=0.0030 2010-10-22 06:02:16.580 (4) [P1T1]: Query executed in 0.003s, 0 row(s) affected 2010-10-22 06:02:16.580 (3) [P1T1]: ... 0 Daily Group Attribute Records Inserted 2010-10-22 06:02:16.580 (4) [P1T1]: perfsum: SQL->[commit] 2010-10-22 06:02:16.580 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-22 06:02:16.581 (5) [P1T1]: recordAsSubs("db", 1, "P1T1") 2010-10-22 06:02:16.581 (5) [P1T1]: ProfilerRec.end("db", true): ret=1 2010-10-22 06:02:16.581 (4) [P1T1]: time=0.0010 2010-10-22 06:02:16.581 (4) [P1T1]: Query executed in 0.001s 2010-10-22 06:02:16.582 (4) [P1T1]: DB AutoCommit -> true 2010-10-22 06:02:16.583 (4) [P1T1]: DB IsolationLevel -> 4 2010-10-22 06:02:16.584 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-22 06:02:16.584 (4) [P1T1]: perfsum: SQL->[drop table `tmp`.`tmp5`] 2010-10-22 06:02:16.586 (5) [P1T1]: recordAsSubs("db", 2, "P1T1") 2010-10-22 06:02:16.586 (5) [P1T1]: ProfilerRec.end("db", true): ret=2 2010-10-22 06:02:16.587 (4) [P1T1]: time=0.0020 2010-10-22 06:02:16.587 (4) [P1T1]: Query executed in 0.002s 2010-10-22 06:02:16.587 (5) [P1T1]: SQL execute() returned false 2010-10-22 06:02:16.587 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-22 06:02:16.587 (4) [P1T1]: perfsum: SQL->[drop table `tmp`.`tmp6`] 2010-10-22 06:02:16.589 (5) [P1T1]: recordAsSubs("db", 2, "P1T1") 2010-10-22 06:02:16.590 (5) [P1T1]: ProfilerRec.end("db", true): ret=2 2010-10-22 06:02:16.590 (4) [P1T1]: time=0.0020 2010-10-22 06:02:16.590 (4) [P1T1]: Query executed in 0.002s 2010-10-22 06:02:16.590 (5) [P1T1]: SQL execute() returned false 2010-10-22 06:02:16.590 (5) [P1T1]: quoteValue(), nothing special about it=>[17], type=class java.lang.Integer 2010-10-22 06:02:16.591 (5) [P1T1]: quoteValue(), nothing special about it=>[17], type=class java.lang.Integer 2010-10-22 06:02:16.592 (5) [P1T1]: quoteValue(), nothing special about it=>[17], type=class java.lang.Integer 2010-10-22 06:02:16.597 (5) [P1T1]: quoteValue(), nothing special about it=>[0], type=class java.lang.Integer 2010-10-22 06:02:16.597 (5) [P1T1]: quoteValue(), nothing special about it=>[5], type=class java.lang.Integer 2010-10-22 06:02:16.620 (4) [P1T1]: DB IsolationLevel -> 8 2010-10-22 06:02:16.621 (4) [P1T1]: DB AutoCommit -> false 2010-10-22 06:02:16.622 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-22 06:02:16.622 (4) [P1T1]: perfsum: SQL->[delete from `warehouse_1`.`whWeeklyGroupConv` where ((`accountID`=17) and ((((`startTime`>=STR_TO_DATE(CONCAT(DATE_FORMAT("2010-10-02 03:00:00","%x%v")," Monday"),"%x%v %W"))) and ((`startTime`[delete from `warehouse_1`.`whWeeklyGroupPerf` where ((`accountID`=17) and ((((`startTime`>=STR_TO_DATE(CONCAT(DATE_FORMAT("2010-10-02 03:00:00","%x%v")," Monday"),"%x%v %W"))) and ((`startTime`[delete from `warehouse_1`.`whWeeklyGroupAttr` where ((`accountID`=17) and ((((`startTime`>=STR_TO_DATE(CONCAT(DATE_FORMAT("2010-10-02 03:00:00","%x%v")," Monday"),"%x%v %W"))) and ((`startTime`[insert into `warehouse_1`.`whWeeklyGroupPerf` (`accountID`,`startTime`,`distributionID`,`campaignID`,`searchEngineAccountID`,`searchEngineGroupID`,`searchEngineListingID`,`searchEngineMatchType`,`type`,`nonSearchTag`,`pixImpressions`,`seImpressions`,`impressions`,`pixClicks`,`seClicks`,`clicks`,`pixAdCost`,`seAdCost`,`adCost`,`avgPosition`,`id`) select `accountID`,STR_TO_DATE(CONCAT(DATE_FORMAT(`startTime`,"%x%v")," Monday"),"%x%v %W") AS `startTime`,`distributionID`,`campaignID`,`searchEngineAccountID`,`searchEngineGroupID`,`searchEngineListingID`,`searchEngineMatchType`,`type`,`nonSearchTag`,ifnull(SUM(`whDailyGroupPerf`.`pixImpressions`), 0) AS `pixImpressions`,ifnull(SUM(`whDailyGroupPerf`.`seImpressions`), 0) AS `seImpressions`,ifnull(SUM(`whDailyGroupPerf`.`impressions`), 0) AS `impressions`,ifnull(SUM(`whDailyGroupPerf`.`pixClicks`), 0) AS `pixClicks`,ifnull(SUM(`whDailyGroupPerf`.`seClicks`), 0) AS `seClicks`,ifnull(SUM(`whDailyGroupPerf`.`clicks`), 0) AS `clicks`,ifnull(SUM(`whDailyGroupPerf`.`pixAdCost`), 0) AS `pixAdCost`,ifnull(SUM(`whDailyGroupPerf`.`seAdCost`), 0) AS `seAdCost`,ifnull(SUM(`whDailyGroupPerf`.`adCost`), 0) AS `adCost`,ifnull(if(`whDailyGroupPerf`.`distributionID` in (86,101,122),AVG(if(`avgPosition`=0,null,`avgPosition`)),IF((SUM(`seImpressions`)>0), ROUND(SUM(`avgPosition` * `seImpressions`) / SUM(`seImpressions`),5), 0)),0) AS `avgPosition`,MAX(`whDailyGroupPerf`.`id`) AS `id` from `warehouse_1`.`whDailyGroupPerf` where ((`accountID`=17) and ((((`startTime`>=STR_TO_DATE(CONCAT(DATE_FORMAT("2010-10-02 03:00:00","%x%v")," Monday"),"%x%v %W"))) and ((`startTime`[create temporary table `tmp`.`tmp7` engine=myisam character set latin1 collate latin1_swedish_ci select `whDailyGroupPerf`.`accountID`,STR_TO_DATE(CONCAT(DATE_FORMAT(`whDailyGroupPerf`.`startTime`,"%x%v")," Monday"),"%x%v %W") AS `startTime`,`whDailyGroupPerf`.`distributionID`,`whDailyGroupPerf`.`campaignID`,`whDailyGroupPerf`.`searchEngineAccountID`,`whDailyGroupPerf`.`searchEngineGroupID`,`whDailyGroupPerf`.`searchEngineListingID`,`whDailyGroupPerf`.`searchEngineMatchType`,`whDailyGroupPerf`.`type`,`whDailyGroupPerf`.`nonSearchTag`,`whDailyGroupConv`.`scope`,`whDailyGroupConv`.`productID`,ifnull(SUM(`whDailyGroupConv`.`pixFulfillCost`), 0) AS `pixFulfillCost`,ifnull(SUM(`whDailyGroupConv`.`clFulfillCost`), 0) AS `clFulfillCost`,ifnull(SUM(`whDailyGroupConv`.`fulfillCost`), 0) AS `fulfillCost`,ifnull(SUM(`whDailyGroupConv`.`pixConversions`), 0) AS `pixConversions`,ifnull(SUM(`whDailyGroupConv`.`seConversions`), 0) AS `seConversions`,ifnull(SUM(`whDailyGroupConv`.`clConversions`), 0) AS `clConversions`,ifnull(SUM(`whDailyGroupConv`.`conversions`), 0) AS `conversions`,ifnull(SUM(`whDailyGroupConv`.`pixValue`), 0) AS `pixValue`,ifnull(SUM(`whDailyGroupConv`.`seValue`), 0) AS `seValue`,ifnull(SUM(`whDailyGroupConv`.`clValue`), 0) AS `clValue`,ifnull(SUM(`whDailyGroupConv`.`value`), 0) AS `value` from `warehouse_1`.`whDailyGroupConv` inner join `warehouse_1`.`whDailyGroupPerf` on ((`whDailyGroupConv`.`perfID`=`whDailyGroupPerf`.`id`)) where ((`whDailyGroupConv`.`accountID`=17) and ((((`whDailyGroupConv`.`startTime`>=STR_TO_DATE(CONCAT(DATE_FORMAT("2010-10-02 03:00:00","%x%v")," Monday"),"%x%v %W"))) and ((`whDailyGroupConv`.`startTime`[insert into `warehouse_1`.`whWeeklyGroupConv` (`startTime`,`accountID`,`perfID`,`scope`,`productID`,`pixFulfillCost`,`clFulfillCost`,`fulfillCost`,`pixConversions`,`seConversions`,`clConversions`,`conversions`,`pixValue`,`seValue`,`clValue`,`value`) select `tmp`.`tmp7`.`startTime`,`tmp`.`tmp7`.`accountID`,`whWeeklyGroupPerf`.`id`,`tmp`.`tmp7`.`scope`,`tmp`.`tmp7`.`productID`,`tmp`.`tmp7`.`pixFulfillCost`,`tmp`.`tmp7`.`clFulfillCost`,`tmp`.`tmp7`.`fulfillCost`,`tmp`.`tmp7`.`pixConversions`,`tmp`.`tmp7`.`seConversions`,`tmp`.`tmp7`.`clConversions`,`tmp`.`tmp7`.`conversions`,`tmp`.`tmp7`.`pixValue`,`tmp`.`tmp7`.`seValue`,`tmp`.`tmp7`.`clValue`,`tmp`.`tmp7`.`value` from `warehouse_1`.`whWeeklyGroupPerf` inner join `tmp`.`tmp7` on (((`whWeeklyGroupPerf`.`accountID`=`tmp`.`tmp7`.`accountID`) and (`whWeeklyGroupPerf`.`startTime`=`tmp`.`tmp7`.`startTime`) and (`whWeeklyGroupPerf`.`distributionID`=`tmp`.`tmp7`.`distributionID`) and (`whWeeklyGroupPerf`.`campaignID`=`tmp`.`tmp7`.`campaignID`) and (`whWeeklyGroupPerf`.`searchEngineAccountID`=`tmp`.`tmp7`.`searchEngineAccountID`) and (`whWeeklyGroupPerf`.`searchEngineGroupID`=`tmp`.`tmp7`.`searchEngineGroupID`) and (`whWeeklyGroupPerf`.`searchEngineListingID`=`tmp`.`tmp7`.`searchEngineListingID`) and (`whWeeklyGroupPerf`.`searchEngineMatchType`=`tmp`.`tmp7`.`searchEngineMatchType`) and (`whWeeklyGroupPerf`.`type`=`tmp`.`tmp7`.`type`) and (`whWeeklyGroupPerf`.`nonSearchTag`=`tmp`.`tmp7`.`nonSearchTag`)))], genflags=no 2010-10-22 06:02:16.805 (5) [P1T1]: recordAsSubs("db", 3, "P1T1") 2010-10-22 06:02:16.806 (5) [P1T1]: ProfilerRec.end("db", true): ret=3 2010-10-22 06:02:16.806 (4) [P1T1]: time=0.0030 2010-10-22 06:02:16.806 (4) [P1T1]: Query executed in 0.003s, 0 row(s) affected 2010-10-22 06:02:16.806 (3) [P1T1]: ... 0 Weekly Group Conversion Records Inserted 2010-10-22 06:02:16.806 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-22 06:02:16.806 (4) [P1T1]: perfsum: SQL->[create temporary table `tmp`.`tmp8` engine=myisam character set latin1 collate latin1_swedish_ci select `whDailyGroupPerf`.`accountID`,STR_TO_DATE(CONCAT(DATE_FORMAT(`whDailyGroupPerf`.`startTime`,"%x%v")," Monday"),"%x%v %W") AS `startTime`,`whDailyGroupPerf`.`distributionID`,`whDailyGroupPerf`.`campaignID`,`whDailyGroupPerf`.`searchEngineAccountID`,`whDailyGroupPerf`.`searchEngineGroupID`,`whDailyGroupPerf`.`searchEngineListingID`,`whDailyGroupPerf`.`searchEngineMatchType`,`whDailyGroupPerf`.`type`,`whDailyGroupPerf`.`nonSearchTag`,cast(if(mod(avg(bidTypeID),1.0) > 0, 3, avg(bidTypeID)) as unsigned) AS `bidTypeID`,AVG(`whDailyGroupAttr`.`qualityScore`) AS `qualityScore` from `warehouse_1`.`whDailyGroupAttr` inner join `warehouse_1`.`whDailyGroupPerf` on ((`whDailyGroupAttr`.`perfID`=`whDailyGroupPerf`.`id`)) where ((`whDailyGroupAttr`.`accountID`=17) and ((((`whDailyGroupAttr`.`startTime`>=STR_TO_DATE(CONCAT(DATE_FORMAT("2010-10-02 03:00:00","%x%v")," Monday"),"%x%v %W"))) and ((`whDailyGroupAttr`.`startTime`[insert into `warehouse_1`.`whWeeklyGroupAttr` (`startTime`,`accountID`,`perfID`,`bidTypeID`,`qualityScore`) select `tmp`.`tmp8`.`startTime`,`tmp`.`tmp8`.`accountID`,`whWeeklyGroupPerf`.`id`,`tmp`.`tmp8`.`bidTypeID`,`tmp`.`tmp8`.`qualityScore` from `warehouse_1`.`whWeeklyGroupPerf` inner join `tmp`.`tmp8` on (((`whWeeklyGroupPerf`.`accountID`=`tmp`.`tmp8`.`accountID`) and (`whWeeklyGroupPerf`.`startTime`=`tmp`.`tmp8`.`startTime`) and (`whWeeklyGroupPerf`.`distributionID`=`tmp`.`tmp8`.`distributionID`) and (`whWeeklyGroupPerf`.`campaignID`=`tmp`.`tmp8`.`campaignID`) and (`whWeeklyGroupPerf`.`searchEngineAccountID`=`tmp`.`tmp8`.`searchEngineAccountID`) and (`whWeeklyGroupPerf`.`searchEngineGroupID`=`tmp`.`tmp8`.`searchEngineGroupID`) and (`whWeeklyGroupPerf`.`searchEngineListingID`=`tmp`.`tmp8`.`searchEngineListingID`) and (`whWeeklyGroupPerf`.`searchEngineMatchType`=`tmp`.`tmp8`.`searchEngineMatchType`) and (`whWeeklyGroupPerf`.`type`=`tmp`.`tmp8`.`type`) and (`whWeeklyGroupPerf`.`nonSearchTag`=`tmp`.`tmp8`.`nonSearchTag`)))], genflags=no 2010-10-22 06:02:16.825 (5) [P1T1]: recordAsSubs("db", 5, "P1T1") 2010-10-22 06:02:16.826 (5) [P1T1]: ProfilerRec.end("db", true): ret=5 2010-10-22 06:02:16.826 (4) [P1T1]: time=0.0050 2010-10-22 06:02:16.826 (4) [P1T1]: Query executed in 0.005s, 10 row(s) affected 2010-10-22 06:02:16.826 (3) [P1T1]: ... 10 Weekly Group Attribute Records Inserted 2010-10-22 06:02:16.826 (4) [P1T1]: perfsum: SQL->[commit] 2010-10-22 06:02:16.826 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-22 06:02:16.827 (5) [P1T1]: recordAsSubs("db", 1, "P1T1") 2010-10-22 06:02:16.827 (5) [P1T1]: ProfilerRec.end("db", true): ret=1 2010-10-22 06:02:16.827 (4) [P1T1]: time=0.0010 2010-10-22 06:02:16.828 (4) [P1T1]: Query executed in 0.001s 2010-10-22 06:02:16.828 (4) [P1T1]: DB AutoCommit -> true 2010-10-22 06:02:16.829 (4) [P1T1]: DB IsolationLevel -> 4 2010-10-22 06:02:16.830 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-22 06:02:16.830 (4) [P1T1]: perfsum: SQL->[drop table `tmp`.`tmp7`] 2010-10-22 06:02:16.833 (5) [P1T1]: recordAsSubs("db", 3, "P1T1") 2010-10-22 06:02:16.834 (5) [P1T1]: ProfilerRec.end("db", true): ret=3 2010-10-22 06:02:16.834 (4) [P1T1]: time=0.0030 2010-10-22 06:02:16.834 (4) [P1T1]: Query executed in 0.003s 2010-10-22 06:02:16.834 (5) [P1T1]: SQL execute() returned false 2010-10-22 06:02:16.834 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-22 06:02:16.834 (4) [P1T1]: perfsum: SQL->[drop table `tmp`.`tmp8`] 2010-10-22 06:02:16.836 (5) [P1T1]: recordAsSubs("db", 2, "P1T1") 2010-10-22 06:02:16.836 (5) [P1T1]: ProfilerRec.end("db", true): ret=2 2010-10-22 06:02:16.836 (4) [P1T1]: time=0.0020 2010-10-22 06:02:16.836 (4) [P1T1]: Query executed in 0.002s 2010-10-22 06:02:16.837 (5) [P1T1]: SQL execute() returned false 2010-10-22 06:02:16.837 (5) [P1T1]: quoteValue(), nothing special about it=>[17], type=class java.lang.Integer 2010-10-22 06:02:16.838 (5) [P1T1]: quoteValue(), nothing special about it=>[17], type=class java.lang.Integer 2010-10-22 06:02:16.838 (5) [P1T1]: quoteValue(), nothing special about it=>[17], type=class java.lang.Integer 2010-10-22 06:02:16.842 (5) [P1T1]: quoteValue(), nothing special about it=>[0], type=class java.lang.Integer 2010-10-22 06:02:16.842 (5) [P1T1]: quoteValue(), nothing special about it=>[5], type=class java.lang.Integer 2010-10-22 06:02:16.872 (4) [P1T1]: DB IsolationLevel -> 8 2010-10-22 06:02:16.873 (4) [P1T1]: DB AutoCommit -> false 2010-10-22 06:02:16.874 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-22 06:02:16.874 (4) [P1T1]: perfsum: SQL->[delete from `warehouse_1`.`whMonthlyGroupConv` where ((`accountID`=17) and ((((`startTime`>=DATE_FORMAT("2010-10-02 03:00:00","%Y-%m-01"))) and ((`startTime`[delete from `warehouse_1`.`whMonthlyGroupPerf` where ((`accountID`=17) and ((((`startTime`>=DATE_FORMAT("2010-10-02 03:00:00","%Y-%m-01"))) and ((`startTime`[delete from `warehouse_1`.`whMonthlyGroupAttr` where ((`accountID`=17) and ((((`startTime`>=DATE_FORMAT("2010-10-02 03:00:00","%Y-%m-01"))) and ((`startTime`[insert into `warehouse_1`.`whMonthlyGroupPerf` (`accountID`,`startTime`,`distributionID`,`campaignID`,`searchEngineAccountID`,`searchEngineGroupID`,`searchEngineListingID`,`searchEngineMatchType`,`type`,`nonSearchTag`,`pixImpressions`,`seImpressions`,`impressions`,`pixClicks`,`seClicks`,`clicks`,`pixAdCost`,`seAdCost`,`adCost`,`avgPosition`,`id`) select `accountID`,DATE_FORMAT(`startTime`,"%Y-%m-01") AS `startTime`,`distributionID`,`campaignID`,`searchEngineAccountID`,`searchEngineGroupID`,`searchEngineListingID`,`searchEngineMatchType`,`type`,`nonSearchTag`,ifnull(SUM(`whDailyGroupPerf`.`pixImpressions`), 0) AS `pixImpressions`,ifnull(SUM(`whDailyGroupPerf`.`seImpressions`), 0) AS `seImpressions`,ifnull(SUM(`whDailyGroupPerf`.`impressions`), 0) AS `impressions`,ifnull(SUM(`whDailyGroupPerf`.`pixClicks`), 0) AS `pixClicks`,ifnull(SUM(`whDailyGroupPerf`.`seClicks`), 0) AS `seClicks`,ifnull(SUM(`whDailyGroupPerf`.`clicks`), 0) AS `clicks`,ifnull(SUM(`whDailyGroupPerf`.`pixAdCost`), 0) AS `pixAdCost`,ifnull(SUM(`whDailyGroupPerf`.`seAdCost`), 0) AS `seAdCost`,ifnull(SUM(`whDailyGroupPerf`.`adCost`), 0) AS `adCost`,ifnull(if(`whDailyGroupPerf`.`distributionID` in (86,101,122),AVG(if(`avgPosition`=0,null,`avgPosition`)),IF((SUM(`seImpressions`)>0), ROUND(SUM(`avgPosition` * `seImpressions`) / SUM(`seImpressions`),5), 0)),0) AS `avgPosition`,MAX(`whDailyGroupPerf`.`id`) AS `id` from `warehouse_1`.`whDailyGroupPerf` where ((`accountID`=17) and ((((`startTime`>=DATE_FORMAT("2010-10-02 03:00:00","%Y-%m-01"))) and ((`startTime`[create temporary table `tmp`.`tmp9` engine=myisam character set latin1 collate latin1_swedish_ci select `whDailyGroupPerf`.`accountID`,DATE_FORMAT(`whDailyGroupPerf`.`startTime`,"%Y-%m-01") AS `startTime`,`whDailyGroupPerf`.`distributionID`,`whDailyGroupPerf`.`campaignID`,`whDailyGroupPerf`.`searchEngineAccountID`,`whDailyGroupPerf`.`searchEngineGroupID`,`whDailyGroupPerf`.`searchEngineListingID`,`whDailyGroupPerf`.`searchEngineMatchType`,`whDailyGroupPerf`.`type`,`whDailyGroupPerf`.`nonSearchTag`,`whDailyGroupConv`.`scope`,`whDailyGroupConv`.`productID`,ifnull(SUM(`whDailyGroupConv`.`pixFulfillCost`), 0) AS `pixFulfillCost`,ifnull(SUM(`whDailyGroupConv`.`clFulfillCost`), 0) AS `clFulfillCost`,ifnull(SUM(`whDailyGroupConv`.`fulfillCost`), 0) AS `fulfillCost`,ifnull(SUM(`whDailyGroupConv`.`pixConversions`), 0) AS `pixConversions`,ifnull(SUM(`whDailyGroupConv`.`seConversions`), 0) AS `seConversions`,ifnull(SUM(`whDailyGroupConv`.`clConversions`), 0) AS `clConversions`,ifnull(SUM(`whDailyGroupConv`.`conversions`), 0) AS `conversions`,ifnull(SUM(`whDailyGroupConv`.`pixValue`), 0) AS `pixValue`,ifnull(SUM(`whDailyGroupConv`.`seValue`), 0) AS `seValue`,ifnull(SUM(`whDailyGroupConv`.`clValue`), 0) AS `clValue`,ifnull(SUM(`whDailyGroupConv`.`value`), 0) AS `value` from `warehouse_1`.`whDailyGroupConv` inner join `warehouse_1`.`whDailyGroupPerf` on ((`whDailyGroupConv`.`perfID`=`whDailyGroupPerf`.`id`)) where ((`whDailyGroupConv`.`accountID`=17) and ((((`whDailyGroupConv`.`startTime`>=DATE_FORMAT("2010-10-02 03:00:00","%Y-%m-01"))) and ((`whDailyGroupConv`.`startTime`[insert into `warehouse_1`.`whMonthlyGroupConv` (`startTime`,`accountID`,`perfID`,`scope`,`productID`,`pixFulfillCost`,`clFulfillCost`,`fulfillCost`,`pixConversions`,`seConversions`,`clConversions`,`conversions`,`pixValue`,`seValue`,`clValue`,`value`) select `tmp`.`tmp9`.`startTime`,`tmp`.`tmp9`.`accountID`,`whMonthlyGroupPerf`.`id`,`tmp`.`tmp9`.`scope`,`tmp`.`tmp9`.`productID`,`tmp`.`tmp9`.`pixFulfillCost`,`tmp`.`tmp9`.`clFulfillCost`,`tmp`.`tmp9`.`fulfillCost`,`tmp`.`tmp9`.`pixConversions`,`tmp`.`tmp9`.`seConversions`,`tmp`.`tmp9`.`clConversions`,`tmp`.`tmp9`.`conversions`,`tmp`.`tmp9`.`pixValue`,`tmp`.`tmp9`.`seValue`,`tmp`.`tmp9`.`clValue`,`tmp`.`tmp9`.`value` from `warehouse_1`.`whMonthlyGroupPerf` inner join `tmp`.`tmp9` on (((`whMonthlyGroupPerf`.`accountID`=`tmp`.`tmp9`.`accountID`) and (`whMonthlyGroupPerf`.`startTime`=`tmp`.`tmp9`.`startTime`) and (`whMonthlyGroupPerf`.`distributionID`=`tmp`.`tmp9`.`distributionID`) and (`whMonthlyGroupPerf`.`campaignID`=`tmp`.`tmp9`.`campaignID`) and (`whMonthlyGroupPerf`.`searchEngineAccountID`=`tmp`.`tmp9`.`searchEngineAccountID`) and (`whMonthlyGroupPerf`.`searchEngineGroupID`=`tmp`.`tmp9`.`searchEngineGroupID`) and (`whMonthlyGroupPerf`.`searchEngineListingID`=`tmp`.`tmp9`.`searchEngineListingID`) and (`whMonthlyGroupPerf`.`searchEngineMatchType`=`tmp`.`tmp9`.`searchEngineMatchType`) and (`whMonthlyGroupPerf`.`type`=`tmp`.`tmp9`.`type`) and (`whMonthlyGroupPerf`.`nonSearchTag`=`tmp`.`tmp9`.`nonSearchTag`)))], genflags=no 2010-10-22 06:02:17.103 (5) [P1T1]: recordAsSubs("db", 3, "P1T1") 2010-10-22 06:02:17.104 (5) [P1T1]: ProfilerRec.end("db", true): ret=3 2010-10-22 06:02:17.104 (4) [P1T1]: time=0.0030 2010-10-22 06:02:17.104 (4) [P1T1]: Query executed in 0.003s, 3 row(s) affected 2010-10-22 06:02:17.104 (3) [P1T1]: ... 3 Monthly Group Conversion Records Inserted 2010-10-22 06:02:17.104 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-22 06:02:17.104 (4) [P1T1]: perfsum: SQL->[create temporary table `tmp`.`tmp10` engine=myisam character set latin1 collate latin1_swedish_ci select `whDailyGroupPerf`.`accountID`,DATE_FORMAT(`whDailyGroupPerf`.`startTime`,"%Y-%m-01") AS `startTime`,`whDailyGroupPerf`.`distributionID`,`whDailyGroupPerf`.`campaignID`,`whDailyGroupPerf`.`searchEngineAccountID`,`whDailyGroupPerf`.`searchEngineGroupID`,`whDailyGroupPerf`.`searchEngineListingID`,`whDailyGroupPerf`.`searchEngineMatchType`,`whDailyGroupPerf`.`type`,`whDailyGroupPerf`.`nonSearchTag`,cast(if(mod(avg(bidTypeID),1.0) > 0, 3, avg(bidTypeID)) as unsigned) AS `bidTypeID`,AVG(`whDailyGroupAttr`.`qualityScore`) AS `qualityScore` from `warehouse_1`.`whDailyGroupAttr` inner join `warehouse_1`.`whDailyGroupPerf` on ((`whDailyGroupAttr`.`perfID`=`whDailyGroupPerf`.`id`)) where ((`whDailyGroupAttr`.`accountID`=17) and ((((`whDailyGroupAttr`.`startTime`>=DATE_FORMAT("2010-10-02 03:00:00","%Y-%m-01"))) and ((`whDailyGroupAttr`.`startTime`[insert into `warehouse_1`.`whMonthlyGroupAttr` (`startTime`,`accountID`,`perfID`,`bidTypeID`,`qualityScore`) select `tmp`.`tmp10`.`startTime`,`tmp`.`tmp10`.`accountID`,`whMonthlyGroupPerf`.`id`,`tmp`.`tmp10`.`bidTypeID`,`tmp`.`tmp10`.`qualityScore` from `warehouse_1`.`whMonthlyGroupPerf` inner join `tmp`.`tmp10` on (((`whMonthlyGroupPerf`.`accountID`=`tmp`.`tmp10`.`accountID`) and (`whMonthlyGroupPerf`.`startTime`=`tmp`.`tmp10`.`startTime`) and (`whMonthlyGroupPerf`.`distributionID`=`tmp`.`tmp10`.`distributionID`) and (`whMonthlyGroupPerf`.`campaignID`=`tmp`.`tmp10`.`campaignID`) and (`whMonthlyGroupPerf`.`searchEngineAccountID`=`tmp`.`tmp10`.`searchEngineAccountID`) and (`whMonthlyGroupPerf`.`searchEngineGroupID`=`tmp`.`tmp10`.`searchEngineGroupID`) and (`whMonthlyGroupPerf`.`searchEngineListingID`=`tmp`.`tmp10`.`searchEngineListingID`) and (`whMonthlyGroupPerf`.`searchEngineMatchType`=`tmp`.`tmp10`.`searchEngineMatchType`) and (`whMonthlyGroupPerf`.`type`=`tmp`.`tmp10`.`type`) and (`whMonthlyGroupPerf`.`nonSearchTag`=`tmp`.`tmp10`.`nonSearchTag`)))], genflags=no 2010-10-22 06:02:17.116 (5) [P1T1]: recordAsSubs("db", 3, "P1T1") 2010-10-22 06:02:17.116 (5) [P1T1]: ProfilerRec.end("db", true): ret=3 2010-10-22 06:02:17.116 (4) [P1T1]: time=0.0030 2010-10-22 06:02:17.117 (4) [P1T1]: Query executed in 0.003s, 11 row(s) affected 2010-10-22 06:02:17.117 (3) [P1T1]: ... 11 Monthly Group Attribute Records Inserted 2010-10-22 06:02:17.117 (4) [P1T1]: perfsum: SQL->[commit] 2010-10-22 06:02:17.117 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-22 06:02:17.118 (5) [P1T1]: recordAsSubs("db", 1, "P1T1") 2010-10-22 06:02:17.118 (5) [P1T1]: ProfilerRec.end("db", true): ret=1 2010-10-22 06:02:17.118 (4) [P1T1]: time=0.0010 2010-10-22 06:02:17.119 (4) [P1T1]: Query executed in 0.001s 2010-10-22 06:02:17.119 (4) [P1T1]: DB AutoCommit -> true 2010-10-22 06:02:17.120 (4) [P1T1]: DB IsolationLevel -> 4 2010-10-22 06:02:17.121 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-22 06:02:17.121 (4) [P1T1]: perfsum: SQL->[drop table `tmp`.`tmp9`] 2010-10-22 06:02:17.124 (5) [P1T1]: recordAsSubs("db", 3, "P1T1") 2010-10-22 06:02:17.124 (5) [P1T1]: ProfilerRec.end("db", true): ret=3 2010-10-22 06:02:17.125 (4) [P1T1]: time=0.0030 2010-10-22 06:02:17.125 (4) [P1T1]: Query executed in 0.003s 2010-10-22 06:02:17.125 (5) [P1T1]: SQL execute() returned false 2010-10-22 06:02:17.125 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-22 06:02:17.125 (4) [P1T1]: perfsum: SQL->[drop table `tmp`.`tmp10`] 2010-10-22 06:02:17.127 (5) [P1T1]: recordAsSubs("db", 2, "P1T1") 2010-10-22 06:02:17.128 (5) [P1T1]: ProfilerRec.end("db", true): ret=2 2010-10-22 06:02:17.128 (4) [P1T1]: time=0.0020 2010-10-22 06:02:17.128 (4) [P1T1]: Query executed in 0.002s 2010-10-22 06:02:17.128 (5) [P1T1]: SQL execute() returned false 2010-10-22 06:02:17.128 (3) [P1T1]: Finished Account #17 WWMW - Cellular Safety Commission aggregates for Sat Oct 02 03:00:00 EDT 2010 to [select * from `dataAvailability` where ((`dataSourceID`="8602") and (`date`="2010-10-02 03:00:00")) limit 1] 2010-10-22 06:02:17.131 (5) [P1T1]: recordAsSubs("db", 2, "P1T1") 2010-10-22 06:02:17.132 (5) [P1T1]: ProfilerRec.end("db", true): ret=2 2010-10-22 06:02:17.132 (4) [P1T1]: time=0.0020 2010-10-22 06:02:17.132 (4) [P1T1]: Query executed in 0.002s 2010-10-22 06:02:17.132 (4) [P1T1]: Record Not Found 2010-10-22 06:02:17.133 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-22 06:02:17.133 (4) [P1T1]: perfsum: SQL->[replace into `dataAvailability` (`override`,`dataSourceID`,`status`,`date`,`updated`) values ("false","8602","success","2010-10-02 03:00:00","2010-10-22 06:02:17")], genflags=yes 2010-10-22 06:02:17.136 (2) [P1T1]: Warning(s) detected in statement [replace into `dataAvailability` (`override`,`dataSourceID`,`status`,`date`,`updated`) values ("false","8602","success","2010-10-02 03:00:00","2010-10-22 06:02:17")] executed by user [perfsum] 2010-10-22 06:02:17.138 (2) [P1T1]: SQL Note: Data truncated for column 'date' at row 1 (code:1265) 2010-10-22 06:02:17.138 (5) [P1T1]: recordAsSubs("db", 5, "P1T1") 2010-10-22 06:02:17.138 (5) [P1T1]: ProfilerRec.end("db", true): ret=5 2010-10-22 06:02:17.138 (4) [P1T1]: time=0.0050 2010-10-22 06:02:17.138 (4) [P1T1]: Query executed in 0.005s, 1 row(s) affected 2010-10-22 06:02:17.139 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2010-10-22 06:02:17.139 (4) [P1T1]: perfsum: SQL->[insert into `dataAvailabilityHistory` (`override`,`dataSourceID`,`status`,`date`,`updated`) values ("false","8602","success","2010-10-02 03:00:00","2010-10-22 06:02:17")], genflags=yes 2010-10-22 06:02:17.142 (2) [P1T1]: Warning(s) detected in statement [insert into `dataAvailabilityHistory` (`override`,`dataSourceID`,`status`,`date`,`updated`) values ("false","8602","success","2010-10-02 03:00:00","2010-10-22 06:02:17")] executed by user [perfsum] 2010-10-22 06:02:17.144 (2) [P1T1]: SQL Note: Data truncated for column 'date' at row 1 (code:1265) 2010-10-22 06:02:17.144 (5) [P1T1]: recordAsSubs("db", 5, "P1T1") 2010-10-22 06:02:17.144 (5) [P1T1]: ProfilerRec.end("db", true): ret=5 2010-10-22 06:02:17.144 (4) [P1T1]: time=0.0050 2010-10-22 06:02:17.144 (4) [P1T1]: Query executed in 0.005s, 1 row(s) affected 2010-10-22 06:02:17.144 (4) [P1T1]: Returning Object to Pool 2010-10-22 06:02:17.145 (4) [P1T1]: Returning Object to Pool 2010-10-22 06:02:18.304 (4) [main]: closed [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2010-10-22 06:02:18.305 (3) [main]: ------------Warehouse Summarizer done 2010-10-22 06:02:18.305 (3) [main]: =============== Completed Warehouse Summarizer ================ 2010-10-22 06:02:18.308 (3) [main]: -- Renamed file 17_FB_20101002.zip to 17_FB_20101002.zip.done ? true 2010-10-22 06:02:18.309 (3) [main]: =============== Completed Publisher Generic Data Feed /177/, 2 products processed and 2 lines processed ================