2011-11-03 08:06:58.309 (3) [main]: Debug Level set to 4
2011-11-03 08:06:58.334 (3) [main]: SOURCE_LOCATION[/tmp/yellraybeamreport/]
2011-11-03 08:06:58.335 (3) [main]: FILE_NAME_PREFIX[TSA_YELLCOM_SEM_]
2011-11-03 08:06:58.335 (3) [main]: DONE_NAME_PREFIX[TSA_rowcounts_]
2011-11-03 08:06:58.336 (3) [main]: MAX_TIME_TO_WAIT[180]
2011-11-03 08:06:58.389 (4) [main]: In createFile
2011-11-03 08:06:58.421 (4) [main]: no account, or instance for databaseInstance, skipping lookup...
2011-11-03 08:06:58.426 (3) [main]: DatabasePool with a limit of 80 created
2011-11-03 08:06:58.466 (4) [ConnectionCloser]: Starting DatabasePool ConnectionCloserThread
2011-11-03 08:06:58.901 (4) [main]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false]
2011-11-03 08:06:58.902 (4) [main]: Created new Object
2011-11-03 08:06:58.907 (4) [main]: spike: SQL->[select @@version]
2011-11-03 08:06:58.960 (4) [main]: time=0.053
2011-11-03 08:06:58.967 (4) [main]: Query executed in 0.053s
2011-11-03 08:06:58.968 (4) [main]: test query succeeded, returned "5.0.30-enterprise-gpl"
2011-11-03 08:06:58.984 (4) [main]: spike: SQL->[select id from `tsacommon`.`accounts` where ((`description` like "yell%") and (`isActive`="true"))]
2011-11-03 08:06:58.988 (4) [main]: time=0.0040
2011-11-03 08:06:58.989 (4) [main]: Query executed in 0.004s
2011-11-03 08:06:58.990 (4) [main]: Returning Object to Pool
2011-11-03 08:06:58.993 (4) [main]: no account, or instance for databaseInstance, skipping lookup...
2011-11-03 08:06:58.994 (3) [main]: DatabasePool with a limit of 80 created
2011-11-03 08:06:59.164 (4) [main]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false]
2011-11-03 08:06:59.168 (4) [main]: Created new Object
2011-11-03 08:06:59.208 (4) [main]: spike: SQL->[select @@version]
2011-11-03 08:06:59.280 (4) [main]: time=0.068
2011-11-03 08:06:59.304 (4) [main]: Query executed in 0.068s
2011-11-03 08:06:59.320 (4) [main]: test query succeeded, returned "5.0.30-enterprise-gpl"
2011-11-03 08:06:59.331 (4) [main]: spike: SQL->[select * from `tsacommon`.`accounts` where (`tsacommon`.`accounts`.`id`=580) limit 1]
2011-11-03 08:06:59.341 (4) [main]: time=0.0090
2011-11-03 08:06:59.344 (4) [main]: Query executed in 0.009s
2011-11-03 08:06:59.363 (4) [main]:   Record Loaded
2011-11-03 08:06:59.364 (4) [main]: Returning Object to Pool
2011-11-03 08:06:59.365 (4) [main]: no account, or instance for databaseInstance, skipping lookup...
2011-11-03 08:06:59.365 (4) [main]: Took Existing Object from Pool
2011-11-03 08:06:59.366 (4) [main]: spike: SQL->[select @@version]
2011-11-03 08:06:59.369 (4) [main]: time=0.0020
2011-11-03 08:06:59.369 (4) [main]: Query executed in 0.002s
2011-11-03 08:06:59.370 (4) [main]: test query succeeded, returned "5.0.30-enterprise-gpl"
2011-11-03 08:06:59.371 (4) [main]: spike: SQL->[select * from `tsacommon`.`accounts` where (`tsacommon`.`accounts`.`id`=521) limit 1]
2011-11-03 08:06:59.374 (4) [main]: time=0.0030
2011-11-03 08:06:59.375 (4) [main]: Query executed in 0.003s
2011-11-03 08:06:59.378 (4) [main]:   Record Loaded
2011-11-03 08:06:59.379 (4) [main]: Returning Object to Pool
2011-11-03 08:07:03.687 (4) [main]: In download()
2011-11-03 08:07:03.702 (4) [main]: no account, or instance for databaseInstance, skipping lookup...
2011-11-03 08:07:03.702 (3) [main]: DatabasePool with a limit of 80 created
2011-11-03 08:07:03.789 (4) [main]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false]
2011-11-03 08:07:03.789 (4) [main]: Created new Object
2011-11-03 08:07:03.790 (4) [main]: spike: SQL->[select @@version]
2011-11-03 08:07:03.819 (4) [main]: time=0.029
2011-11-03 08:07:03.820 (4) [main]: Query executed in 0.029s
2011-11-03 08:07:03.820 (4) [main]: test query succeeded, returned "5.0.30-enterprise-gpl"
2011-11-03 08:07:03.821 (4) [main]: spike: SQL->[select id from `tsacommon`.`accounts` where ((`description` like "yell%") and (`isActive`="true"))]
2011-11-03 08:07:03.824 (4) [main]: time=0.0030
2011-11-03 08:07:03.824 (4) [main]: Query executed in 0.003s
2011-11-03 08:07:03.825 (4) [main]: Returning Object to Pool
2011-11-03 08:07:10.358 (3) [main]: Report #354540 finished and is located at http://tvvm-staging-svc2:8080//reports/1/report_354540.csv
2011-11-03 08:07:10.359 (4) [main]: url= http://tvvm-staging-svc2:8080//reports/1/report_354540.csv
2011-11-03 08:07:10.359 (3) [main]: getAbsolutePath() returned /tmp/yellraybeam16678.csv
2011-11-03 08:07:10.369 (3) [main]: Connected to URL "http://tvvm-staging-svc2:8080//reports/1/report_354540.csv"
2011-11-03 08:07:10.553 (4) [main]: In download()
2011-11-03 08:07:10.554 (4) [main]: no account, or instance for databaseInstance, skipping lookup...
2011-11-03 08:07:10.555 (3) [main]: DatabasePool with a limit of 80 created
2011-11-03 08:07:10.578 (4) [main]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false]
2011-11-03 08:07:10.578 (4) [main]: Created new Object
2011-11-03 08:07:10.578 (4) [main]: spike: SQL->[select @@version]
2011-11-03 08:07:10.580 (4) [main]: time=0.0020
2011-11-03 08:07:10.580 (4) [main]: Query executed in 0.002s
2011-11-03 08:07:10.580 (4) [main]: test query succeeded, returned "5.0.30-enterprise-gpl"
2011-11-03 08:07:10.621 (4) [main]: spike: SQL->[select id from `tsacommon`.`accounts` where ((`description` like "yell%") and (`isActive`="true"))]
2011-11-03 08:07:10.625 (4) [main]: time=0.0040
2011-11-03 08:07:10.625 (4) [main]: Query executed in 0.004s
2011-11-03 08:07:10.625 (4) [main]: Returning Object to Pool
2011-11-03 08:07:21.350 (3) [main]: Report #27 finished and is located at http://tvvm-staging-svc2:8080/TargetingService/reports/1/report_27.xml
2011-11-03 08:07:21.351 (4) [main]: url= http://tvvm-staging-svc2:8080/TargetingService/reports/1/report_27.xml
2011-11-03 08:07:21.351 (3) [main]: getAbsolutePath() returned /tmp/yellraybeamreport/test5.log
2011-11-03 08:07:24.351 (3) [main]: Connected to URL "http://tvvm-staging-svc2:8080/TargetingService/reports/1/report_27.xml"
2011-11-03 08:07:24.564 (3) [main]: getAbsolutePath() returned /tmp/yellraybeam16678.csv
2011-11-03 08:07:24.565 (4) [main]: no account, or instance for databaseInstance, skipping lookup...
2011-11-03 08:07:24.594 (4) [main]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false]
2011-11-03 08:07:24.599 (4) [main]: spike: SQL->[select * from `tsacommon`.`databaseInstances` where ((`type`="mysql") and (`name`="global-clients")) limit 1]
2011-11-03 08:07:24.602 (4) [main]: time=0.0020
2011-11-03 08:07:24.602 (4) [main]: Query executed in 0.002s
2011-11-03 08:07:24.603 (4) [main]:   Record Loaded
2011-11-03 08:07:24.603 (4) [main]: DataCache: put key global-clients
2011-11-03 08:07:24.604 (4) [main]: closed [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false]
2011-11-03 08:07:24.605 (3) [main]: DatabasePool with a limit of 80 created
2011-11-03 08:07:24.628 (4) [main]: opened [jdbc:mysql://clients-01-write:3306/clients?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false]
2011-11-03 08:07:24.629 (4) [main]: Created new Object
2011-11-03 08:07:24.629 (4) [main]: spike: SQL->[select @@version]
2011-11-03 08:07:24.631 (4) [main]: time=0.0010
2011-11-03 08:07:24.631 (4) [main]: Query executed in 0.001s
2011-11-03 08:07:24.631 (4) [main]: test query succeeded, returned "5.0.30-enterprise-gpl"
2011-11-03 08:07:24.636 (4) [main]: spike: SQL->[create temporary table `tmp`.`tmp1` (`DateID` varchar(31) NOT NULL default '',`AccountName` varchar(255) NOT NULL default '',`ChannelDescription` varchar(127) NOT NULL default '',`SearchEngineName` varchar(255) NOT NULL default '',`CampaignId` varchar(63) NOT NULL default '',`CampaignName` varchar(255) NOT NULL,`AdGroupName` varchar(255) NOT NULL default '',`TSAlistingID` int(11) NOT NULL default 0,`Keyword` varchar(255) character set utf8 NOT NULL default '',`MatchType` enum('exact','phrase','broad','advanced','local','content','unknown') NOT NULL default 'unknown',`RefCd` varchar(255) character set utf8 NOT NULL default '',`SearchEngineId` char(2) NOT NULL default '',`AccountId` varchar(63) NOT NULL default '',`ChannelId` tinyint(3) unsigned NOT NULL default '0',`BudgetAmount` double NOT NULL default '0',`BudgetPeriod` varchar(63) default NULL,`CampaignStatus` varchar(127) NOT NULL default '',`AdGroupId` varchar(255) NOT NULL default '',`AdGroupStatus` varchar(127) NOT NULL default '',`TSACr` varchar(255) NOT NULL default '',`AdId` int(11) NOT NULL default '0',`AdType` varchar(31) NOT NULL default '',`AdName` varchar(255) NOT NULL default '',`Description1` varchar(255) NOT NULL default '',`Description2` varchar(255) NOT NULL default '',`DispURL` varchar(255) NOT NULL default '',`AdStatus` varchar(255) NOT NULL default '',`KeywordId` varchar(255) NOT NULL default '',`DestURL` varchar(255) NOT NULL default '',`FirstPageCpc` double NOT NULL default '0',`QualityScore` int(11) NOT NULL default '0',`PositionAvg` double NOT NULL default '0',`CpcAvg` double NOT NULL default '0',`CpmAvg` double NOT NULL default '0',`CTR` double NOT NULL default '0',`Clicks` int(11) NOT NULL default '0',`Impressions` int(11) NOT NULL default '0',`Cost` double NOT NULL default '0',`MaxCpm` varchar(31) NOT NULL default '',`MaxCpc` varchar(31) NOT NULL default '',`KeywordStatus` varchar(255) NOT NULL default '',`minCpc` double NOT NULL default '0',`Unique_AdvertId` varchar(255) NOT NULL default '') engine=myisam character set latin1 collate latin1_swedish_ci ]
2011-11-03 08:07:24.640 (4) [main]: time=0.0040
2011-11-03 08:07:24.641 (4) [main]: Query executed in 0.004s
2011-11-03 08:07:24.641 (4) [main]: spike: SQL->[SHOW CREATE TABLE `tmp`.`tmp1`]
2011-11-03 08:07:24.644 (4) [main]: time=0.0030
2011-11-03 08:07:24.644 (4) [main]: Query executed in 0.003s
2011-11-03 08:07:24.645 (4) [main]: CREATE TEMPORARY TABLE `tmp1` (
  `DateID` varchar(31) NOT NULL default '',
  `AccountName` varchar(255) NOT NULL default '',
  `ChannelDescription` varchar(127) NOT NULL default '',
  `SearchEngineName` varchar(255) NOT NULL default '',
  `CampaignId` varchar(63) NOT NULL default '',
  `CampaignName` varchar(255) NOT NULL,
  `AdGroupName` varchar(255) NOT NULL default '',
  `TSAlistingID` int(11) NOT NULL default '0',
  `Keyword` varchar(255) character set utf8 NOT NULL default '',
  `MatchType` enum('exact','phrase','broad','advanced','local','content','unknown') NOT NULL default 'unknown',
  `RefCd` varchar(255) character set utf8 NOT NULL default '',
  `SearchEngineId` char(2) NOT NULL default '',
  `AccountId` varchar(63) NOT NULL default '',
  `ChannelId` tinyint(3) unsigned NOT NULL default '0',
  `BudgetAmount` double NOT NULL default '0',
  `BudgetPeriod` varchar(63) default NULL,
  `CampaignStatus` varchar(127) NOT NULL default '',
  `AdGroupId` varchar(255) NOT NULL default '',
  `AdGroupStatus` varchar(127) NOT NULL default '',
  `TSACr` varchar(255) NOT NULL default '',
  `AdId` int(11) NOT NULL default '0',
  `AdType` varchar(31) NOT NULL default '',
  `AdName` varchar(255) NOT NULL default '',
  `Description1` varchar(255) NOT NULL default '',
  `Description2` varchar(255) NOT NULL default '',
  `DispURL` varchar(255) NOT NULL default '',
  `AdStatus` varchar(255) NOT NULL default '',
  `KeywordId` varchar(255) NOT NULL default '',
  `DestURL` varchar(255) NOT NULL default '',
  `FirstPageCpc` double NOT NULL default '0',
  `QualityScore` int(11) NOT NULL default '0',
  `PositionAvg` double NOT NULL default '0',
  `CpcAvg` double NOT NULL default '0',
  `CpmAvg` double NOT NULL default '0',
  `CTR` double NOT NULL default '0',
  `Clicks` int(11) NOT NULL default '0',
  `Impressions` int(11) NOT NULL default '0',
  `Cost` double NOT NULL default '0',
  `MaxCpm` varchar(31) NOT NULL default '',
  `MaxCpc` varchar(31) NOT NULL default '',
  `KeywordStatus` varchar(255) NOT NULL default '',
  `minCpc` double NOT NULL default '0',
  `Unique_AdvertId` varchar(255) NOT NULL default ''
) ENGINE=MyISAM DEFAULT CHARSET=latin1
2011-11-03 08:07:24.645 (3) [main]: getAbsolutePath() returned /tmp/yellraybeam16678.csv
2011-11-03 08:07:24.645 (4) [main]: spike: SQL->[LOAD DATA LOCAL INFILE "/tmp/yellraybeam16678.csv" INTO TABLE `tmp`.`tmp1` FIELDS TERMINATED BY ',' ENCLOSED BY '"' IGNORE 1 LINES (`DateID`, `AccountName`, `ChannelDescription`, `SearchEngineName`, `CampaignId`, `CampaignName`, `AdGroupName`, `TSAlistingID`, `Keyword`, `MatchType`, `RefCd`, `SearchEngineId`, `AccountId`, `ChannelId`, `BudgetAmount`, `BudgetPeriod`, `CampaignStatus`, `AdGroupId`, `AdGroupStatus`, `TSACr`, `AdId`, `AdType`, `AdName`, `Description1`, `Description2`, `DispURL`, `AdStatus`, `KeywordId`, `DestURL`, `FirstPageCpc`, `QualityScore`, `PositionAvg`, `CpcAvg`, `CpmAvg`, `CTR`, `Clicks`, `Impressions`, `Cost`, `MaxCpm`, `MaxCpc`, `KeywordStatus`, `minCpc`)]
2011-11-03 08:07:24.657 (4) [main]: time=0.011
2011-11-03 08:07:24.657 (4) [main]: Query executed in 0.011s
2011-11-03 08:07:24.664 (4) [main]: spike: SQL->[select `tmp`.`tmp1`.`DateID`,`tmp`.`tmp1`.`RefCd`,`tmp`.`tmp1`.`Unique_AdvertId`,`tmp`.`tmp1`.`SearchEngineId`,`tmp`.`tmp1`.`SearchEngineName`,`tmp`.`tmp1`.`AccountId`,`tmp`.`tmp1`.`AccountName`,`tmp`.`tmp1`.`ChannelId`,`tmp`.`tmp1`.`ChannelDescription`,`tmp`.`tmp1`.`CampaignId`,`tmp`.`tmp1`.`CampaignName`,`tmp`.`tmp1`.`BudgetAmount`,`tmp`.`tmp1`.`BudgetPeriod`,`tmp`.`tmp1`.`CampaignStatus`,`tmp`.`tmp1`.`AdGroupId`,`tmp`.`tmp1`.`AdGroupName`,`tmp`.`tmp1`.`AdGroupStatus`,`tmp`.`tmp1`.`MaxCpm`,`tmp`.`tmp1`.`TSACr`,`tmp`.`tmp1`.`AdId`,`tmp`.`tmp1`.`AdType`,`tmp`.`tmp1`.`AdName`,`tmp`.`tmp1`.`Description1`,`tmp`.`tmp1`.`Description2`,`tmp`.`tmp1`.`DispURL`,`tmp`.`tmp1`.`AdStatus`,`tmp`.`tmp1`.`KeywordId`,`tmp`.`tmp1`.`Keyword`,`tmp`.`tmp1`.`DestURL`,`tmp`.`tmp1`.`MatchType`,`tmp`.`tmp1`.`minCpc`,`tmp`.`tmp1`.`FirstPageCpc`,`tmp`.`tmp1`.`QualityScore`,`tmp`.`tmp1`.`MaxCpc`,`tmp`.`tmp1`.`KeywordStatus`,`tmp`.`tmp1`.`PositionAvg`,`tmp`.`tmp1`.`CpcAvg`,`tmp`.`tmp1`.`CpmAvg`,`tmp`.`tmp1`.`CTR`,`tmp`.`tmp1`.`Clicks`,`tmp`.`tmp1`.`Impressions`,`tmp`.`tmp1`.`Cost` from `tmp`.`tmp1`]
2011-11-03 08:07:24.678 (4) [main]: time=0.014
2011-11-03 08:07:24.679 (4) [main]: Query executed in 0.014s
2011-11-03 08:07:24.679 (3) [main]: Writing file to /tmp/yellraybeamreport/test5.log
2011-11-03 08:07:24.682 (3) [main]: ... done
2011-11-03 08:07:24.682 (3) [main]: getAbsolutePath() returned /tmp/yellraybeamreport/test5.log
2011-11-03 08:07:24.683 (3) [main]: getAbsolutePath() returned /tmp/yellraybeamreport/test5.log
2011-11-03 08:07:24.683 (3) [main]: getAbsolutePath() returned /tmp/yellraybeam16678.csv
2011-11-03 08:07:24.683 (3) [main]: done file to /tmp/yellraybeamreport/test5.log
2011-11-03 08:07:24.684 (4) [main]: Returning Object to Pool