2010-10-19 10:50:22.933 (3) [main]: Debug Level set to 5 2010-10-19 10:50:22.937 (3) [main]: No licensing config file found, assuming TSA production environment 2010-10-19 10:50:22.940 (5) [main]: yesterday: month=10, day=18, year=2010 2010-10-19 10:50:24.262 (3) [main]: Configured properties according to file :: /var/local/tsa/datafeedConfig/RightMedia.xml 2010-10-19 10:50:24.266 (5) [main]: parseInteger->[17] 2010-10-19 10:50:24.285 (5) [main]: parseInteger<-[17] 2010-10-19 10:50:24.318 (4) [main]: no account, or instance for databaseInstance, skipping lookup... 2010-10-19 10:50:25.317 (4) [main]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2010-10-19 10:50:25.322 (4) [main]: null key, and no data, unable to build condition 2010-10-19 10:50:25.332 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-19 10:50:25.334 (4) [main]: spike: SQL->[select * from `tsacommon`.`accounts` limit 1] 2010-10-19 10:50:25.377 (5) [main]: recordAsSubs("db", 44, "main") 2010-10-19 10:50:25.378 (5) [main]: ProfilerRec.end("db", true): ret=44 2010-10-19 10:50:25.378 (4) [main]: time=0.044 2010-10-19 10:50:25.378 (4) [main]: Query executed in 0.044s 2010-10-19 10:50:25.381 (5) [main]: loading 19 columns from result set: 2010-10-19 10:50:25.381 (5) [main]: loaded column: accounts.id->1 2010-10-19 10:50:25.382 (5) [main]: loaded column: accounts.description->Admin Account 2010-10-19 10:50:25.383 (5) [main]: loaded column: accounts.tier->3 2010-10-19 10:50:25.384 (5) [main]: loaded column: accounts.priority->50 2010-10-19 10:50:25.384 (5) [main]: loaded column: accounts.reportClicksOut->false 2010-10-19 10:50:25.384 (5) [main]: loaded column: accounts.reportConversions->false 2010-10-19 10:50:25.385 (5) [main]: loaded column: accounts.conversionTypes-> 2010-10-19 10:50:25.385 (5) [main]: loaded column: accounts.isBidManaged->false 2010-10-19 10:50:25.385 (5) [main]: loaded column: accounts.isActive->false 2010-10-19 10:50:25.386 (5) [main]: loaded column: accounts.perfMetric->cpa 2010-10-19 10:50:25.386 (5) [main]: loaded column: accounts.providesConversionData->true 2010-10-19 10:50:25.386 (5) [main]: loaded column: accounts.addConversionData->false 2010-10-19 10:50:25.387 (5) [main]: loaded column: accounts.fractionalConversionCounts->false 2010-10-19 10:50:25.387 (5) [main]: loaded column: accounts.hideNullSources->false 2010-10-19 10:50:25.388 (5) [main]: loaded column: accounts.nowTime->null 2010-10-19 10:50:25.389 (5) [main]: skipping invalid column: accounts.warehouseDatabase 2010-10-19 10:50:25.389 (5) [main]: loaded column: accounts.databaseInstance->1 2010-10-19 10:50:25.389 (5) [main]: loaded column: accounts.warehouseInstance->2 2010-10-19 10:50:25.390 (5) [main]: loaded column: accounts.isOnline->true 2010-10-19 10:50:25.390 (4) [main]: Record Loaded 2010-10-19 10:50:25.390 (4) [main]: DataCache: put key acct-st-tracker null 2010-10-19 10:50:25.395 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-19 10:50:25.395 (4) [main]: spike: SQL->[select * from `tsacommon`.`databaseInstances` where ((`type`="mysql") and (`name`="acct-st-tracker-1")) limit 1] 2010-10-19 10:50:25.398 (5) [main]: recordAsSubs("db", 3, "main") 2010-10-19 10:50:25.398 (5) [main]: ProfilerRec.end("db", true): ret=3 2010-10-19 10:50:25.398 (4) [main]: time=0.0030 2010-10-19 10:50:25.399 (4) [main]: Query executed in 0.003s 2010-10-19 10:50:25.399 (5) [main]: loading 8 columns from result set: 2010-10-19 10:50:25.399 (5) [main]: loaded column: databaseInstances.id->15 2010-10-19 10:50:25.399 (5) [main]: loaded column: databaseInstances.name->acct-st-tracker-1 2010-10-19 10:50:25.400 (5) [main]: loaded column: databaseInstances.description->Account-specific Catch-all database 2010-10-19 10:50:25.400 (5) [main]: loaded column: databaseInstances.type->mysql 2010-10-19 10:50:25.400 (5) [main]: loaded column: databaseInstances.database->st-tracker 2010-10-19 10:50:25.400 (5) [main]: loaded column: databaseInstances.host->acctdb-01-write 2010-10-19 10:50:25.401 (5) [main]: loaded column: databaseInstances.port->3306 2010-10-19 10:50:25.401 (5) [main]: loaded column: databaseInstances.access->rw 2010-10-19 10:50:25.401 (4) [main]: Record Loaded 2010-10-19 10:50:25.401 (4) [main]: DataCache: put key acct-st-tracker-1 2010-10-19 10:50:25.403 (4) [main]: closed [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2010-10-19 10:50:25.407 (3) [main]: DatabasePool with a limit of 80 created 2010-10-19 10:50:25.409 (4) [ConnectionCloser]: Starting DatabasePool ConnectionCloserThread 2010-10-19 10:50:25.455 (4) [main]: opened [jdbc:mysql://acctdb-01-write:3306/st-tracker?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2010-10-19 10:50:25.455 (4) [main]: Created new Object 2010-10-19 10:50:25.456 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-19 10:50:25.456 (4) [main]: spike: SQL->[select @@version] 2010-10-19 10:50:25.458 (5) [main]: recordAsSubs("db", 2, "main") 2010-10-19 10:50:25.458 (5) [main]: ProfilerRec.end("db", true): ret=2 2010-10-19 10:50:25.458 (4) [main]: time=0.0020 2010-10-19 10:50:25.458 (4) [main]: Query executed in 0.002s 2010-10-19 10:50:25.459 (4) [main]: test query succeeded, returned "5.1.49-rel11.3" 2010-10-19 10:50:25.469 (4) [main]: no account, or instance for databaseInstance, skipping lookup... 2010-10-19 10:50:25.470 (3) [main]: DatabasePool with a limit of 80 created 2010-10-19 10:50:25.496 (4) [main]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2010-10-19 10:50:25.496 (4) [main]: Created new Object 2010-10-19 10:50:25.497 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-19 10:50:25.497 (4) [main]: spike: SQL->[select @@version] 2010-10-19 10:50:25.499 (5) [main]: recordAsSubs("db", 1, "main") 2010-10-19 10:50:25.499 (5) [main]: ProfilerRec.end("db", true): ret=1 2010-10-19 10:50:25.499 (4) [main]: time=0.0010 2010-10-19 10:50:25.499 (4) [main]: Query executed in 0.001s 2010-10-19 10:50:25.499 (4) [main]: test query succeeded, returned "5.0.30-enterprise-gpl" 2010-10-19 10:50:25.505 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2010-10-19 10:50:25.505 (4) [main]: spike: SQL->[select * from `tsacommon`.`accountDistributionMap` where ((`accountID`="17") and (`distributionID`="180")) limit 1] 2010-10-19 10:50:25.507 (5) [main]: recordAsSubs("db", 2, "main") 2010-10-19 10:50:25.508 (5) [main]: ProfilerRec.end("db", true): ret=2 2010-10-19 10:50:25.508 (4) [main]: time=0.0020 2010-10-19 10:50:25.508 (4) [main]: Query executed in 0.002s Exception in thread "main" java.lang.NullPointerException at com.thesearchagency.datafeeds.generic.PublisherGenericDataFeed.init(PublisherGenericDataFeed.java:122) at com.thesearchagency.datafeeds.generic.PublisherGenericDataFeed.main(PublisherGenericDataFeed.java:75)