[svn:p5ee] r6504 - p5ee/trunk/App-WorkQueue/t
[email protected] Wed, 14 Jun 2006 11:30:09 -0700 (PDT)
Newsgroups
perl.cvs.p5ee
Message-ID
<[email protected] >
Author: spadkins
Date: Wed Jun 14 11:30:09 2006
New Revision: 6504
Added:
p5ee/trunk/App-WorkQueue/t/queue-db-refill.t (contents, props changed)
Log:
fixed a bug that occurs during _refill_buffer()
Added: p5ee/trunk/App-WorkQueue/t/queue-db-refill.t
==============================================================================
--- (empty file)
+++ p5ee/trunk/App-WorkQueue/t/queue-db-refill.t Wed Jun 14 11:30:09 2006
@@ -0,0 +1,3060 @@
+#!/usr/local/bin/perl -w
+
+use App::Options (
+ options => [qw(dbdriver dbclass dbhost dbname dbuser dbpass)],
+ option => {
+ dbclass => { default => "App::Repository::MySQL", },
+ dbdriver => { default => "mysql", },
+ dbhost => { default => "localhost", },
+ dbname => { default => "test", },
+ dbuser => { default => "", },
+ dbpass => { default => "", },
+ log_level => { default => 0, },
+ },
+);
+
+use Test::More qw(no_plan);
+use lib "../App-Context/lib";
+use lib "../../App-Context/lib";
+use lib "../App-Repository/lib";
+use lib "../../App-Repository/lib";
+use lib "lib";
+use lib "../lib";
+
+use App;
+use App::Repository;
+use strict;
+
+my $t_dir = (-d "t") ? "t" : ".";
+
+use App::WorkQueue::Repository;
+
+if (! -f "$t_dir/app.conf") {
+ ok(1, "No dbuser given. Tests assumed OK. (add dbname=abc, dbuser=xxx, and dbpass=yyy to app.conf in 't' directory)");
+ exit(0);
+}
+
+my $context = App->context(
+ conf_file => "",
+ conf => {
+ Repository => {
+ default => {
+ class => $App::options{dbclass},
+ dbdriver => $App::options{dbdriver},
+ dbhost => $App::options{dbhost},
+ dbname => $App::options{dbname},
+ dbuser => $App::options{dbuser},
+ dbpass => $App::options{dbpass},
+ #table => {
+ # test_person => {
+ # primary_key => ["person_id"],
+ # },
+ #},
+ },
+ },
+ SessionObject => {
+ foo => {
+ class => "Foo",
+ },
+ },
+ },
+ context_class => "App::Context::ClusterController",
+ debug_sql => $App::options{debug_sql},
+ log_level => $App::options{log_level},
+);
+
+{
+ my $db = $context->repository();
+ #cheating... I know its a DBI, but I have to set up the test somehow
+ my $dbh = $db->{dbh};
+ eval { $dbh->do("drop table t_hotel_subrequest"); };
+ my $ddl = <<EOF;
+create table t_hotel_subrequest (
+ subrequest_id integer not null auto_increment primary key,
+ shop_request_id integer not null,
+ org_id integer not null,
+
+ prop_id integer not null,
+ shop_data_source varchar(255) not null,
+ shop_currency_cd varchar(3) not null,
+ shop_pos_cd varchar(255) not null,
+ los integer not null,
+ guests integer not null,
+ begin_arv_dt date not null,
+ end_arv_dt date not null,
+ dow varchar(13) null,
+ comp_id varchar(255) null,
+
+ scheduled_dttm datetime null,
+ start_dttm datetime null,
+ complete_dttm datetime null,
+ change_dttm datetime null,
+ request_status char(1) null,
+ client_userid varchar(99) null,
+ client_system_cd varchar(5) null,
+ server_system_cd varchar(5) null,
+ work_units integer null,
+ work_units_complete integer null,
+ work_units_error integer not null default 0,
+ work_units_blank integer not null default 0,
+ work_units_skipped integer not null default 0,
+ request_msg varchar(255) null,
+ email_notify varchar(255) null,
+ email_type varchar(24) null,
+ shop_units integer null,
+ profile varchar(255) null,
+
+ display_option varchar(99) null,
+ view_data_sources varchar(255) null,
+ date_sense varchar(5) null,
+ comp_prod_id varchar(255) null,
+ rm_type varchar(12) null,
+ accom varchar(16) null,
+ prev_day_compare varchar(10) null,
+ compare_options varchar(24) null,
+ cell_drilldown varchar(5) null,
+ highlight_ind varchar(3) null,
+ rate_details varchar(20) null,
+ shop_data_age varchar(10) null,
+
+ shop_host varchar(32) null,
+ shop_priority integer not null default 2,
+ shop_fresh_mins integer not null default 1080,
+ file_output_ind char(1) null,
+ override_data_source char(3) default NULL,
+ comp_strat_cd varchar(16) not null default 'none',
+ mkt_keyword varchar(255) null, -- or "city_nm, state_cd, US" or "city_nm, country_cd"
+ shop_level integer null, -- number of pages deep to go in a mkt shop
+
+ finish_in_subprocess varchar(3) null,
+ actual_data_source varchar(11) null,
+ report_units integer not null default 0,
+
+ group_data_source varchar(11) null,
+ q_client_id varchar(32) null,
+ est_cpu_util_pct integer null,
+ est_mem_mb integer null,
+ cpu_time_ms integer null,
+ run_time_ms integer null,
+ start_mem_mb integer null,
+ end_mem_mb integer null,
+
+ unique hotel_subrequest_ak1 (shop_request_id, comp_id, begin_arv_dt, shop_data_source, los, email_type),
+ index hotel_subrequest_ie2 (request_status, email_type),
+ index hotel_subrequest_ie3 (request_status, change_dttm),
+ index hotel_subrequest_ie4 (request_status, group_data_source, actual_data_source, comp_id, complete_dttm),
+ index hotel_subrequest_ie5 (shop_request_id, request_status)
+) TYPE=InnoDB
+EOF
+ $dbh->do($ddl);
+}
+
+{
+ &run("hotel_subrequest");
+ #&run("hotel_subrequest2", 1);
+}
+
+sub run {
+ my ($qname, $rerun) = @_;
+ my $db = $context->repository();
+ my $table = "t_hotel_subrequest";
+
+ my ($errmsg, %colidx);
+ #my $columns = [qw(
+ # shop_request_id
+ # org_id prop_id shop_data_source
+ # shop_currency_cd shop_pos_cd los guests
+ # begin_arv_dt end_arv_dt dow comp_id comp_prod_id
+ # scheduled_dttm start_dttm complete_dttm change_dttm
+ # request_status client_userid client_system_cd server_system_cd
+ # work_units work_units_complete
+ # request_msg email_notify email_type shop_units profile
+ # work_units_error work_units_blank shop_host shop_priority shop_fresh_mins
+ # actual_data_source file_output_ind work_units_skipped override_data_source
+ # display_option prev_day_compare mkt_keyword shop_level
+ #)];
+ #for (my $i = 0; $i <= $#$columns; $i++) {
+ # $colidx{$columns->[$i]} = $i;
+ #}
+ my %state = (
+ num_reports => 0,
+ max_reports => 8,
+ );
+
+ my $q = $context->work_queue($qname,
+ queue_type => "HASH",
+ class => "App::WorkQueue::Repository",
+ table => $table,
+ id_attrib => "shop_request_id,comp_id,begin_arv_dt,shop_data_source,los",
+ auto_id_attrib => "subrequest_id",
+ status_attrib => "request_status",
+ sort_spec => "N-shop_priority,N+shop_request_id,subrequest_id",
+ client_id_attrib => "q_client_id",
+ client_id => "$App::options{host}:$qname",
+ STATUS_UNBUFFERED => "W",
+ STATUS_UNACQUIRED => "W",
+ STATUS_ACQUIRED => "R",
+ STATUS_RELEASED => "S",
+ BUFFER_SIZE => 20,
+ params => {
+ email_type => "SugOnly,ReportOnly,FileOnly,NotifyOnly,FileNotify,ReportFile",
+ },
+ );
+ isa_ok($q, "App::WorkQueue");
+ isa_ok($q, "App::WorkQueue::Repository");
+
+ my (%num_workers_ds, %max_workers_ds);
+ $max_workers_ds{EXP} = 5;
+
+ eval {
+ $q->set_global_constraint(\%state, \%state, "num_reports", "max_reports");
+ ok(1, "set_global_constraint(...)");
+ $q->set_constraint(\%num_workers_ds, \%max_workers_ds, "shop_data_source");
+ ok(1, "set_constraint(shop_data_source)");
+ };
+ ok(!$@, "No errors [$@]");
+
+ &load_test_data($db, $q);
+
+ &test_status_counts($q, 0, 42, 0, 0);
+ &test_resource_buffer_counts($q, "EXP", 20, 42);
+
+ my ($e, @e, $e1, $e2, $e3, $e4);
+
+ $e1 = $q->acquire();
+ #$q->print();
+ &test_status_counts($q, 0, 41, 1, 0);
+ &test_resource_buffer_counts($q, "EXP", 39, 41);
+
+ $e2 = $q->acquire();
+ #$q->print();
+ &test_status_counts($q, 0, 40, 2, 0);
+ &test_resource_buffer_counts($q, "EXP", 38, 40);
+
+ $e3 = $q->acquire();
+ #$q->print();
+ &test_status_counts($q, 0, 39, 3, 0);
+ &test_resource_buffer_counts($q, "EXP", 37, 39);
+
+ $e4 = $q->acquire();
+ #$q->print();
+ &test_status_counts($q, 0, 38, 4, 0);
+ &test_resource_buffer_counts($q, "EXP", 36, 38);
+
+ $q->release($e1);
+ $q->release($e2);
+ $q->release($e3);
+ $q->release($e4);
+ #$q->print();
+ &test_status_counts($q, 0, 38, 0, 4);
+ &test_resource_buffer_counts($q, "EXP", 36, 38);
+
+ $e1 = $q->acquire(); &test_status_counts($q, 0, 37, 1, 4); &test_resource_buffer_counts($q, "EXP", 35, 37);
+ $e2 = $q->acquire(); &test_status_counts($q, 0, 36, 2, 4); &test_resource_buffer_counts($q, "EXP", 34, 36);
+ $e3 = $q->acquire(); &test_status_counts($q, 0, 35, 3, 4); &test_resource_buffer_counts($q, "EXP", 33, 35);
+ $e4 = $q->acquire(); &test_status_counts($q, 0, 34, 4, 4); &test_resource_buffer_counts($q, "EXP", 32, 34);
+ $q->release($e1);
+ $q->release($e2);
+ $q->release($e3);
+ $q->release($e4); &test_status_counts($q, 0, 34, 0, 8); &test_resource_buffer_counts($q, "EXP", 32, 34);
+
+ $e1 = $q->acquire(); &test_status_counts($q, 0, 33, 1, 8); &test_resource_buffer_counts($q, "EXP", 31, 33);
+ $e2 = $q->acquire(); &test_status_counts($q, 0, 32, 2, 8); &test_resource_buffer_counts($q, "EXP", 30, 32);
+ $e3 = $q->acquire(); &test_status_counts($q, 0, 31, 3, 8); &test_resource_buffer_counts($q, "EXP", 29, 31);
+ $e4 = $q->acquire(); &test_status_counts($q, 0, 30, 4, 8); &test_resource_buffer_counts($q, "EXP", 28, 30);
+ $q->release($e1);
+ $q->release($e2);
+ $q->release($e3);
+ $q->release($e4); &test_status_counts($q, 0, 30, 0,12); &test_resource_buffer_counts($q, "EXP", 28, 30);
+
+ $e1 = $q->acquire(); &test_status_counts($q, 0, 29, 1,12); &test_resource_buffer_counts($q, "EXP", 27, 29);
+ $e2 = $q->acquire(); &test_status_counts($q, 0, 28, 2,12); &test_resource_buffer_counts($q, "EXP", 26, 28);
+ $e3 = $q->acquire(); &test_status_counts($q, 0, 27, 3,12); &test_resource_buffer_counts($q, "EXP", 25, 27);
+ $e4 = $q->acquire(); &test_status_counts($q, 0, 26, 4,12); &test_resource_buffer_counts($q, "EXP", 24, 26);
+ $q->release($e1);
+ $q->release($e2);
+ $q->release($e3);
+ $q->release($e4); &test_status_counts($q, 0, 26, 0,16); &test_resource_buffer_counts($q, "EXP", 24, 26);
+
+ $e1 = $q->acquire(); &test_status_counts($q, 0, 25, 1,16); &test_resource_buffer_counts($q, "EXP", 23, 25);
+ $e2 = $q->acquire(); &test_status_counts($q, 0, 24, 2,16); &test_resource_buffer_counts($q, "EXP", 22, 24);
+ $e3 = $q->acquire(); &test_status_counts($q, 0, 23, 3,16); &test_resource_buffer_counts($q, "EXP", 21, 23);
+ $e4 = $q->acquire(); &test_status_counts($q, 0, 22, 4,16); &test_resource_buffer_counts($q, "EXP", 20, 22);
+ $q->release($e1);
+ $q->release($e2);
+ $q->release($e3);
+ $q->release($e4); &test_status_counts($q, 0, 22, 0,20); &test_resource_buffer_counts($q, "EXP", 20, 22);
+
+ $e1 = $q->acquire(); &test_status_counts($q, 0, 21, 1,20); &test_resource_buffer_counts($q, "EXP", 21, 21);
+ $e2 = $q->acquire(); &test_status_counts($q, 0, 20, 2,20); &test_resource_buffer_counts($q, "EXP", 20, 20);
+ $e3 = $q->acquire(); &test_status_counts($q, 0, 19, 3,20); &test_resource_buffer_counts($q, "EXP", 19, 19);
+ $e4 = $q->acquire(); &test_status_counts($q, 0, 18, 4,20); &test_resource_buffer_counts($q, "EXP", 18, 18);
+ $q->release($e1);
+ $q->release($e2);
+ $q->release($e3);
+ $q->release($e4); &test_status_counts($q, 0, 18, 0,24); &test_resource_buffer_counts($q, "EXP", 18, 18);
+
+ exit(0);
+ $e = $q->acquire();
+ &test_status_counts($q, 0, 40, 2, 0);
+ $e = $q->acquire();
+ &test_status_counts($q, 0, 39, 3, 0);
+ $e = $q->acquire();
+ &test_status_counts($q, 0, 38, 4, 0);
+ $e = $q->acquire();
+ &test_status_counts($q, 0, 37, 5, 0);
+ $e = $q->acquire();
+ &test_status_counts($q, 0, 36, 6, 0);
+ $e = $q->acquire();
+ &test_status_counts($q, 0, 35, 7, 0);
+ $e = $q->acquire();
+ &test_status_counts($q, 0, 34, 8, 0);
+ $e = $q->acquire();
+ is($e, undef, "throttle full");
+ &test_status_counts($q, 0, 34, 8, 0);
+}
+
+sub test_status_counts {
+ my ($q, $N_count, $W_count, $R_count, $S_count) = @_;
+ my ($count);
+ if (defined $N_count) {
+ $count = $q->num_entries("N");
+ is($count, $N_count, "N count is $N_count");
+ }
+ if (defined $W_count) {
+ $count = $q->num_entries("W");
+ is($count, $W_count, "W count is $W_count");
+ }
+ if (defined $R_count) {
+ $count = $q->num_entries("R");
+ is($count, $R_count, "R count is $R_count");
+ }
+ if (defined $S_count) {
+ $count = $q->num_entries("S");
+ is($count, $S_count, "S count is $S_count");
+ }
+}
+
+sub test_resource_buffer_counts {
+ my ($q, $resource_key, $buffer, $total) = @_;
+ my $resource_counts = $q->_resource_counts();
+ is($resource_counts->{buffer}{$resource_key}||0, $buffer, "$resource_key buffer count is $buffer");
+ is($resource_counts->{total}{$resource_key}||0, $total, "$resource_key total count is $total");
+}
+
+sub load_test_data {
+ my ($db, $q) = @_;
+ my $table = "t_hotel_subrequest";
+ #$db->delete($table,{});
+ my $data = &data();
+ foreach my $row (@$data) {
+ $row->{subrequest_id} = undef;
+ $row->{request_status} = "W";
+ $row->{q_client_id} = undef;
+ #$db->insert($table, $row);
+ $q->push($row);
+ #$q->print();
+ }
+}
+
+sub data {
+ my $VAR1 = [
+ {
+ 'profile' => 'RT03: Reports compare.arv_dt.html',
+ 'cpu_time_ms' => '820',
+ 'group_data_source' => undef,
+ 'shop_data_age' => '7',
+ 'file_output_ind' => undef,
+ 'work_units_skipped' => '0',
+ 'scheduled_dttm' => '2006-06-03 19:00:59',
+ 'shop_level' => '10',
+ 'shop_host' => undef,
+ 'comp_strat_cd' => 'none',
+ 'work_units_error' => '0',
+ 'shop_fresh_mins' => '1080',
+ 'end_mem_mb' => '48416',
+ 'client_system_cd' => 'MV',
+ 'override_data_source' => undef,
+ 'end_arv_dt' => '2006-06-18',
+ 'prop_id' => '128',
+ 'work_units_complete' => '0',
+ 'client_userid' => 'spadkins',
+ 'finish_in_subprocess' => undef,
+ 'cell_drilldown' => 'Y',
+ 'start_dttm' => '2006-06-03 19:01:39',
+ 'begin_arv_dt' => '2006-06-03',
+ 'rm_type' => '',
+ 'est_cpu_util_pct' => undef,
+ 'shop_priority' => '1',
+ 'shop_request_id' => '5702',
+ 'shop_units' => '0',
+ 'server_system_cd' => 'MV',
+ 'compare_options' => 'PrevRateAndDirection',
+ 'view_data_sources' => 'EXP',
+ 'shop_data_source' => 'EXP',
+ 'work_units_blank' => '0',
+ 'prev_day_compare' => 'None',
+ 'request_msg' => '',
+ 'run_time_ms' => '7311',
+ 'dow' => '1,2,3,4,5,6,7',
+ 'q_client_id' => 'frento:q-hotel_compute',
+ 'complete_dttm' => '2006-06-03 19:01:46',
+ 'display_option' => 'compare.arv_dt.html',
+ 'start_mem_mb' => '38912',
+ 'mkt_keyword' => '',
+ 'actual_data_source' => undef,
+ 'rate_details' => 'Rate',
+ 'comp_prod_id' => '1',
+ 'email_notify' => '[email protected] ',
+ 'highlight_ind' => 'Y',
+ 'date_sense' => 'Auto',
+ 'org_id' => '1',
+ 'report_units' => '0',
+ 'email_type' => 'ReportOnly',
+ 'los' => '1',
+ 'guests' => '1',
+ 'shop_currency_cd' => 'USD',
+ 'subrequest_id' => '891',
+ 'change_dttm' => '2006-06-03 19:01:46',
+ 'request_status' => 'W',
+ 'comp_id' => '132,128,133,129,130',
+ 'est_mem_mb' => undef,
+ 'accom' => '',
+ 'shop_pos_cd' => 'US',
+ 'work_units' => '0'
+ },
+ {
+ 'profile' => 'RT03: Reports compare.car_type_cd.html',
+ 'cpu_time_ms' => '630',
+ 'group_data_source' => undef,
+ 'shop_data_age' => '7',
+ 'file_output_ind' => undef,
+ 'work_units_skipped' => '0',
+ 'scheduled_dttm' => '2006-06-03 19:01:00',
+ 'shop_level' => '10',
+ 'shop_host' => undef,
+ 'comp_strat_cd' => 'none',
+ 'work_units_error' => '0',
+ 'shop_fresh_mins' => '1080',
+ 'end_mem_mb' => '47856',
+ 'client_system_cd' => 'MV',
+ 'override_data_source' => undef,
+ 'end_arv_dt' => '2006-06-09',
+ 'prop_id' => '128',
+ 'work_units_complete' => '0',
+ 'client_userid' => 'spadkins',
+ 'finish_in_subprocess' => undef,
+ 'cell_drilldown' => 'Y',
+ 'start_dttm' => '2006-06-03 19:01:40',
+ 'begin_arv_dt' => '2006-06-03',
+ 'rm_type' => '',
+ 'est_cpu_util_pct' => undef,
+ 'shop_priority' => '1',
+ 'shop_request_id' => '5703',
+ 'shop_units' => '0',
+ 'server_system_cd' => 'MV',
+ 'compare_options' => 'PrevRateAndDirection',
+ 'view_data_sources' => 'EXP',
+ 'shop_data_source' => 'EXP',
+ 'work_units_blank' => '0',
+ 'prev_day_compare' => 'None',
+ 'request_msg' => '',
+ 'run_time_ms' => '3270',
+ 'dow' => '1,2,3,4,5,6,7',
+ 'q_client_id' => 'frento:q-hotel_compute',
+ 'complete_dttm' => '2006-06-03 19:01:42',
+ 'display_option' => 'compare.car_type_cd.html',
+ 'start_mem_mb' => '38924',
+ 'mkt_keyword' => '',
+ 'actual_data_source' => undef,
+ 'rate_details' => 'Rate',
+ 'comp_prod_id' => '1',
+ 'email_notify' => '[email protected] ',
+ 'highlight_ind' => 'Y',
+ 'date_sense' => 'Auto',
+ 'org_id' => '1',
+ 'report_units' => '0',
+ 'email_type' => 'ReportOnly',
+ 'los' => '1',
+ 'guests' => '1',
+ 'shop_currency_cd' => 'USD',
+ 'subrequest_id' => '892',
+ 'change_dttm' => '2006-06-03 19:01:42',
+ 'request_status' => 'W',
+ 'comp_id' => '132,128,133,129,130',
+ 'est_mem_mb' => undef,
+ 'accom' => '',
+ 'shop_pos_cd' => 'US',
+ 'work_units' => '0'
+ },
+ {
+ 'profile' => 'RT03: Reports compare.arv_dt_car_type.html',
+ 'cpu_time_ms' => '650',
+ 'group_data_source' => undef,
+ 'shop_data_age' => '7',
+ 'file_output_ind' => undef,
+ 'work_units_skipped' => '0',
+ 'scheduled_dttm' => '2006-06-03 19:01:00',
+ 'shop_level' => '10',
+ 'shop_host' => undef,
+ 'comp_strat_cd' => 'none',
+ 'work_units_error' => '0',
+ 'shop_fresh_mins' => '1080',
+ 'end_mem_mb' => '47816',
+ 'client_system_cd' => 'MV',
+ 'override_data_source' => undef,
+ 'end_arv_dt' => '2006-06-09',
+ 'prop_id' => '128',
+ 'work_units_complete' => '0',
+ 'client_userid' => 'spadkins',
+ 'finish_in_subprocess' => undef,
+ 'cell_drilldown' => 'Y',
+ 'start_dttm' => '2006-06-03 19:01:39',
+ 'begin_arv_dt' => '2006-06-03',
+ 'rm_type' => '',
+ 'est_cpu_util_pct' => undef,
+ 'shop_priority' => '1',
+ 'shop_request_id' => '5704',
+ 'shop_units' => '0',
+ 'server_system_cd' => 'MV',
+ 'compare_options' => 'PrevRateAndDirection',
+ 'view_data_sources' => 'EXP',
+ 'shop_data_source' => 'EXP',
+ 'work_units_blank' => '0',
+ 'prev_day_compare' => 'None',
+ 'request_msg' => '',
+ 'run_time_ms' => '5526',
+ 'dow' => '1,2,3,4,5,6,7',
+ 'q_client_id' => 'frento:q-hotel_compute',
+ 'complete_dttm' => '2006-06-03 19:01:44',
+ 'display_option' => 'compare.arv_dt_car_type.html',
+ 'start_mem_mb' => '38920',
+ 'mkt_keyword' => '',
+ 'actual_data_source' => undef,
+ 'rate_details' => 'Rate',
+ 'comp_prod_id' => '1',
+ 'email_notify' => '[email protected] ',
+ 'highlight_ind' => 'Y',
+ 'date_sense' => 'Auto',
+ 'org_id' => '1',
+ 'report_units' => '0',
+ 'email_type' => 'ReportOnly',
+ 'los' => '1',
+ 'guests' => '1',
+ 'shop_currency_cd' => 'USD',
+ 'subrequest_id' => '893',
+ 'change_dttm' => '2006-06-03 19:01:44',
+ 'request_status' => 'W',
+ 'comp_id' => '132,128,133,129,130',
+ 'est_mem_mb' => undef,
+ 'accom' => '',
+ 'shop_pos_cd' => 'US',
+ 'work_units' => '0'
+ },
+ {
+ 'profile' => 'RT03: Reports detail',
+ 'cpu_time_ms' => '570',
+ 'group_data_source' => undef,
+ 'shop_data_age' => '7',
+ 'file_output_ind' => undef,
+ 'work_units_skipped' => '0',
+ 'scheduled_dttm' => '2006-06-03 19:01:00',
+ 'shop_level' => '10',
+ 'shop_host' => undef,
+ 'comp_strat_cd' => 'none',
+ 'work_units_error' => '0',
+ 'shop_fresh_mins' => '1080',
+ 'end_mem_mb' => '47620',
+ 'client_system_cd' => 'MV',
+ 'override_data_source' => undef,
+ 'end_arv_dt' => '2006-06-03',
+ 'prop_id' => '128',
+ 'work_units_complete' => '0',
+ 'client_userid' => 'spadkins',
+ 'finish_in_subprocess' => undef,
+ 'cell_drilldown' => 'Y',
+ 'start_dttm' => '2006-06-03 19:01:39',
+ 'begin_arv_dt' => '2006-06-03',
+ 'rm_type' => '',
+ 'est_cpu_util_pct' => undef,
+ 'shop_priority' => '1',
+ 'shop_request_id' => '5705',
+ 'shop_units' => '0',
+ 'server_system_cd' => 'MV',
+ 'compare_options' => 'PrevRateAndDirection',
+ 'view_data_sources' => 'EXP',
+ 'shop_data_source' => 'EXP',
+ 'work_units_blank' => '0',
+ 'prev_day_compare' => 'None',
+ 'request_msg' => '',
+ 'run_time_ms' => '2733',
+ 'dow' => '1,2,3,4,5,6,7',
+ 'q_client_id' => 'frento:q-hotel_compute',
+ 'complete_dttm' => '2006-06-03 19:01:41',
+ 'display_option' => 'detail',
+ 'start_mem_mb' => '38924',
+ 'mkt_keyword' => '',
+ 'actual_data_source' => undef,
+ 'rate_details' => 'Rate',
+ 'comp_prod_id' => '1',
+ 'email_notify' => '[email protected] ',
+ 'highlight_ind' => 'Y',
+ 'date_sense' => 'Auto',
+ 'org_id' => '1',
+ 'report_units' => '0',
+ 'email_type' => 'ReportOnly',
+ 'los' => '1',
+ 'guests' => '1',
+ 'shop_currency_cd' => 'USD',
+ 'subrequest_id' => '894',
+ 'change_dttm' => '2006-06-03 19:01:41',
+ 'request_status' => 'W',
+ 'comp_id' => '132,128,133,129,130',
+ 'est_mem_mb' => undef,
+ 'accom' => '',
+ 'shop_pos_cd' => 'US',
+ 'work_units' => '0'
+ },
+ {
+ 'profile' => 'RT03: Reports detail.ALLRATES',
+ 'cpu_time_ms' => '610',
+ 'group_data_source' => undef,
+ 'shop_data_age' => '7',
+ 'file_output_ind' => undef,
+ 'work_units_skipped' => '0',
+ 'scheduled_dttm' => '2006-06-03 19:01:00',
+ 'shop_level' => '10',
+ 'shop_host' => undef,
+ 'comp_strat_cd' => 'none',
+ 'work_units_error' => '0',
+ 'shop_fresh_mins' => '1080',
+ 'end_mem_mb' => '47628',
+ 'client_system_cd' => 'MV',
+ 'override_data_source' => undef,
+ 'end_arv_dt' => '2006-06-03',
+ 'prop_id' => '128',
+ 'work_units_complete' => '0',
+ 'client_userid' => 'spadkins',
+ 'finish_in_subprocess' => undef,
+ 'cell_drilldown' => 'Y',
+ 'start_dttm' => '2006-06-03 19:01:39',
+ 'begin_arv_dt' => '2006-06-03',
+ 'rm_type' => '',
+ 'est_cpu_util_pct' => undef,
+ 'shop_priority' => '1',
+ 'shop_request_id' => '5706',
+ 'shop_units' => '0',
+ 'server_system_cd' => 'MV',
+ 'compare_options' => 'PrevRateAndDirection',
+ 'view_data_sources' => 'EXP',
+ 'shop_data_source' => 'EXP',
+ 'work_units_blank' => '0',
+ 'prev_day_compare' => 'None',
+ 'request_msg' => '',
+ 'run_time_ms' => '3394',
+ 'dow' => '1,2,3,4,5,6,7',
+ 'q_client_id' => 'frento:q-hotel_compute',
+ 'complete_dttm' => '2006-06-03 19:01:42',
+ 'display_option' => 'detail.ALLRATES',
+ 'start_mem_mb' => '38924',
+ 'mkt_keyword' => '',
+ 'actual_data_source' => undef,
+ 'rate_details' => 'Rate',
+ 'comp_prod_id' => '1',
+ 'email_notify' => '[email protected] ',
+ 'highlight_ind' => 'Y',
+ 'date_sense' => 'Auto',
+ 'org_id' => '1',
+ 'report_units' => '0',
+ 'email_type' => 'ReportOnly',
+ 'los' => '1',
+ 'guests' => '1',
+ 'shop_currency_cd' => 'USD',
+ 'subrequest_id' => '895',
+ 'change_dttm' => '2006-06-03 19:01:42',
+ 'request_status' => 'W',
+ 'comp_id' => '132,128,133,129,130',
+ 'est_mem_mb' => undef,
+ 'accom' => '',
+ 'shop_pos_cd' => 'US',
+ 'work_units' => '0'
+ },
+ {
+ 'profile' => 'RT03: Reports compare.arv_dt.pdf',
+ 'cpu_time_ms' => '740',
+ 'group_data_source' => undef,
+ 'shop_data_age' => '7',
+ 'file_output_ind' => undef,
+ 'work_units_skipped' => '0',
+ 'scheduled_dttm' => '2006-06-03 19:01:00',
+ 'shop_level' => '10',
+ 'shop_host' => undef,
+ 'comp_strat_cd' => 'none',
+ 'work_units_error' => '0',
+ 'shop_fresh_mins' => '1080',
+ 'end_mem_mb' => '48300',
+ 'client_system_cd' => 'MV',
+ 'override_data_source' => undef,
+ 'end_arv_dt' => '2006-06-18',
+ 'prop_id' => '128',
+ 'work_units_complete' => '0',
+ 'client_userid' => 'spadkins',
+ 'finish_in_subprocess' => undef,
+ 'cell_drilldown' => 'Y',
+ 'start_dttm' => '2006-06-03 19:01:40',
+ 'begin_arv_dt' => '2006-06-03',
+ 'rm_type' => '',
+ 'est_cpu_util_pct' => undef,
+ 'shop_priority' => '1',
+ 'shop_request_id' => '5707',
+ 'shop_units' => '0',
+ 'server_system_cd' => 'MV',
+ 'compare_options' => 'PrevRateAndDirection',
+ 'view_data_sources' => 'EXP',
+ 'shop_data_source' => 'EXP',
+ 'work_units_blank' => '0',
+ 'prev_day_compare' => 'None',
+ 'request_msg' => '',
+ 'run_time_ms' => '4506',
+ 'dow' => '1,2,3,4,5,6,7',
+ 'q_client_id' => 'frento:q-hotel_compute',
+ 'complete_dttm' => '2006-06-03 19:01:43',
+ 'display_option' => 'compare.arv_dt.pdf',
+ 'start_mem_mb' => '38924',
+ 'mkt_keyword' => '',
+ 'actual_data_source' => undef,
+ 'rate_details' => 'Rate',
+ 'comp_prod_id' => '1',
+ 'email_notify' => '[email protected] ',
+ 'highlight_ind' => 'Y',
+ 'date_sense' => 'Auto',
+ 'org_id' => '1',
+ 'report_units' => '0',
+ 'email_type' => 'ReportOnly',
+ 'los' => '1',
+ 'guests' => '1',
+ 'shop_currency_cd' => 'USD',
+ 'subrequest_id' => '896',
+ 'change_dttm' => '2006-06-03 19:01:43',
+ 'request_status' => 'W',
+ 'comp_id' => '132,128,133,129,130',
+ 'est_mem_mb' => undef,
+ 'accom' => '',
+ 'shop_pos_cd' => 'US',
+ 'work_units' => '0'
+ },
+ {
+ 'profile' => 'RT03: Reports compare.car_type_cd.pdf',
+ 'cpu_time_ms' => '690',
+ 'group_data_source' => undef,
+ 'shop_data_age' => '7',
+ 'file_output_ind' => undef,
+ 'work_units_skipped' => '0',
+ 'scheduled_dttm' => '2006-06-03 19:01:00',
+ 'shop_level' => '10',
+ 'shop_host' => undef,
+ 'comp_strat_cd' => 'none',
+ 'work_units_error' => '0',
+ 'shop_fresh_mins' => '1080',
+ 'end_mem_mb' => '47784',
+ 'client_system_cd' => 'MV',
+ 'override_data_source' => undef,
+ 'end_arv_dt' => '2006-06-09',
+ 'prop_id' => '128',
+ 'work_units_complete' => '0',
+ 'client_userid' => 'spadkins',
+ 'finish_in_subprocess' => undef,
+ 'cell_drilldown' => 'Y',
+ 'start_dttm' => '2006-06-03 19:01:39',
+ 'begin_arv_dt' => '2006-06-03',
+ 'rm_type' => '',
+ 'est_cpu_util_pct' => undef,
+ 'shop_priority' => '1',
+ 'shop_request_id' => '5708',
+ 'shop_units' => '0',
+ 'server_system_cd' => 'MV',
+ 'compare_options' => 'PrevRateAndDirection',
+ 'view_data_sources' => 'EXP',
+ 'shop_data_source' => 'EXP',
+ 'work_units_blank' => '0',
+ 'prev_day_compare' => 'None',
+ 'request_msg' => '',
+ 'run_time_ms' => '3574',
+ 'dow' => '1,2,3,4,5,6,7',
+ 'q_client_id' => 'frento:q-hotel_compute',
+ 'complete_dttm' => '2006-06-03 19:01:42',
+ 'display_option' => 'compare.car_type_cd.pdf',
+ 'start_mem_mb' => '38928',
+ 'mkt_keyword' => '',
+ 'actual_data_source' => undef,
+ 'rate_details' => 'Rate',
+ 'comp_prod_id' => '1',
+ 'email_notify' => '[email protected] ',
+ 'highlight_ind' => 'Y',
+ 'date_sense' => 'Auto',
+ 'org_id' => '1',
+ 'report_units' => '0',
+ 'email_type' => 'ReportOnly',
+ 'los' => '1',
+ 'guests' => '1',
+ 'shop_currency_cd' => 'USD',
+ 'subrequest_id' => '897',
+ 'change_dttm' => '2006-06-03 19:01:42',
+ 'request_status' => 'W',
+ 'comp_id' => '132,128,133,129,130',
+ 'est_mem_mb' => undef,
+ 'accom' => '',
+ 'shop_pos_cd' => 'US',
+ 'work_units' => '0'
+ },
+ {
+ 'profile' => 'RT03: Reports compare.arv_dt.csv',
+ 'cpu_time_ms' => '820',
+ 'group_data_source' => undef,
+ 'shop_data_age' => '7',
+ 'file_output_ind' => undef,
+ 'work_units_skipped' => '0',
+ 'scheduled_dttm' => '2006-06-03 19:01:00',
+ 'shop_level' => '10',
+ 'shop_host' => undef,
+ 'comp_strat_cd' => 'none',
+ 'work_units_error' => '0',
+ 'shop_fresh_mins' => '1080',
+ 'end_mem_mb' => '48280',
+ 'client_system_cd' => 'MV',
+ 'override_data_source' => undef,
+ 'end_arv_dt' => '2006-06-18',
+ 'prop_id' => '128',
+ 'work_units_complete' => '0',
+ 'client_userid' => 'spadkins',
+ 'finish_in_subprocess' => undef,
+ 'cell_drilldown' => 'Y',
+ 'start_dttm' => '2006-06-03 19:01:40',
+ 'begin_arv_dt' => '2006-06-03',
+ 'rm_type' => '',
+ 'est_cpu_util_pct' => undef,
+ 'shop_priority' => '1',
+ 'shop_request_id' => '5709',
+ 'shop_units' => '0',
+ 'server_system_cd' => 'MV',
+ 'compare_options' => 'PrevRateAndDirection',
+ 'view_data_sources' => 'EXP',
+ 'shop_data_source' => 'EXP',
+ 'work_units_blank' => '0',
+ 'prev_day_compare' => 'None',
+ 'request_msg' => '',
+ 'run_time_ms' => '4457',
+ 'dow' => '1,2,3,4,5,6,7',
+ 'q_client_id' => 'frento:q-hotel_compute',
+ 'complete_dttm' => '2006-06-03 19:01:43',
+ 'display_option' => 'compare.arv_dt.csv',
+ 'start_mem_mb' => '38928',
+ 'mkt_keyword' => '',
+ 'actual_data_source' => undef,
+ 'rate_details' => 'Rate',
+ 'comp_prod_id' => '1',
+ 'email_notify' => '[email protected] ',
+ 'highlight_ind' => 'Y',
+ 'date_sense' => 'Auto',
+ 'org_id' => '1',
+ 'report_units' => '0',
+ 'email_type' => 'ReportOnly',
+ 'los' => '1',
+ 'guests' => '1',
+ 'shop_currency_cd' => 'USD',
+ 'subrequest_id' => '898',
+ 'change_dttm' => '2006-06-03 19:01:43',
+ 'request_status' => 'W',
+ 'comp_id' => '132,128,133,129,130',
+ 'est_mem_mb' => undef,
+ 'accom' => '',
+ 'shop_pos_cd' => 'US',
+ 'work_units' => '0'
+ },
+ {
+ 'profile' => 'RT03: Reports compare.product.html',
+ 'cpu_time_ms' => '830',
+ 'group_data_source' => undef,
+ 'shop_data_age' => '7',
+ 'file_output_ind' => undef,
+ 'work_units_skipped' => '0',
+ 'scheduled_dttm' => '2006-06-03 19:01:00',
+ 'shop_level' => '10',
+ 'shop_host' => undef,
+ 'comp_strat_cd' => 'none',
+ 'work_units_error' => '0',
+ 'shop_fresh_mins' => '1080',
+ 'end_mem_mb' => '48524',
+ 'client_system_cd' => 'MV',
+ 'override_data_source' => undef,
+ 'end_arv_dt' => '2006-06-18',
+ 'prop_id' => '128',
+ 'work_units_complete' => '0',
+ 'client_userid' => 'spadkins',
+ 'finish_in_subprocess' => undef,
+ 'cell_drilldown' => 'Y',
+ 'start_dttm' => '2006-06-03 19:01:39',
+ 'begin_arv_dt' => '2006-06-03',
+ 'rm_type' => '',
+ 'est_cpu_util_pct' => undef,
+ 'shop_priority' => '1',
+ 'shop_request_id' => '5710',
+ 'shop_units' => '0',
+ 'server_system_cd' => 'MV',
+ 'compare_options' => 'PrevRateAndDirection',
+ 'view_data_sources' => 'EXP',
+ 'shop_data_source' => 'EXP',
+ 'work_units_blank' => '0',
+ 'prev_day_compare' => 'None',
+ 'request_msg' => '',
+ 'run_time_ms' => '4979',
+ 'dow' => '1,2,3,4,5,6,7',
+ 'q_client_id' => 'frento:q-hotel_compute',
+ 'complete_dttm' => '2006-06-03 19:01:44',
+ 'display_option' => 'compare.product.html',
+ 'start_mem_mb' => '38932',
+ 'mkt_keyword' => '',
+ 'actual_data_source' => undef,
+ 'rate_details' => 'Rate',
+ 'comp_prod_id' => '1',
+ 'email_notify' => '[email protected] ',
+ 'highlight_ind' => 'Y',
+ 'date_sense' => 'Auto',
+ 'org_id' => '1',
+ 'report_units' => '0',
+ 'email_type' => 'ReportOnly',
+ 'los' => '1',
+ 'guests' => '1',
+ 'shop_currency_cd' => 'USD',
+ 'subrequest_id' => '899',
+ 'change_dttm' => '2006-06-03 19:01:44',
+ 'request_status' => 'W',
+ 'comp_id' => '132,128,133,129,130',
+ 'est_mem_mb' => undef,
+ 'accom' => '',
+ 'shop_pos_cd' => 'US',
+ 'work_units' => '0'
+ },
+ {
+ 'profile' => 'RT03: Reports compare.ckey.los.html',
+ 'cpu_time_ms' => '770',
+ 'group_data_source' => undef,
+ 'shop_data_age' => '7',
+ 'file_output_ind' => undef,
+ 'work_units_skipped' => '0',
+ 'scheduled_dttm' => '2006-06-03 19:01:00',
+ 'shop_level' => '10',
+ 'shop_host' => undef,
+ 'comp_strat_cd' => 'none',
+ 'work_units_error' => '0',
+ 'shop_fresh_mins' => '1080',
+ 'end_mem_mb' => '48452',
+ 'client_system_cd' => 'MV',
+ 'override_data_source' => undef,
+ 'end_arv_dt' => '2006-06-18',
+ 'prop_id' => '128',
+ 'work_units_complete' => '0',
+ 'client_userid' => 'spadkins',
+ 'finish_in_subprocess' => undef,
+ 'cell_drilldown' => 'Y',
+ 'start_dttm' => '2006-06-03 19:01:41',
+ 'begin_arv_dt' => '2006-06-03',
+ 'rm_type' => '',
+ 'est_cpu_util_pct' => undef,
+ 'shop_priority' => '1',
+ 'shop_request_id' => '5711',
+ 'shop_units' => '0',
+ 'server_system_cd' => 'MV',
+ 'compare_options' => 'PrevRateAndDirection',
+ 'view_data_sources' => 'EXP',
+ 'shop_data_source' => 'EXP',
+ 'work_units_blank' => '0',
+ 'prev_day_compare' => 'None',
+ 'request_msg' => '',
+ 'run_time_ms' => '3903',
+ 'dow' => '1,2,3,4,5,6,7',
+ 'q_client_id' => 'frento:q-hotel_compute',
+ 'complete_dttm' => '2006-06-03 19:01:43',
+ 'display_option' => 'compare.ckey.los.html',
+ 'start_mem_mb' => '38932',
+ 'mkt_keyword' => '',
+ 'actual_data_source' => undef,
+ 'rate_details' => 'Rate',
+ 'comp_prod_id' => '1',
+ 'email_notify' => '[email protected] ',
+ 'highlight_ind' => 'Y',
+ 'date_sense' => 'Auto',
+ 'org_id' => '1',
+ 'report_units' => '0',
+ 'email_type' => 'ReportOnly',
+ 'los' => '1',
+ 'guests' => '1',
+ 'shop_currency_cd' => 'USD',
+ 'subrequest_id' => '900',
+ 'change_dttm' => '2006-06-03 19:01:43',
+ 'request_status' => 'W',
+ 'comp_id' => '132,128,133,129,130',
+ 'est_mem_mb' => undef,
+ 'accom' => '',
+ 'shop_pos_cd' => 'US',
+ 'work_units' => '0'
+ },
+ {
+ 'profile' => 'RT03: Reports compare.ckey.data_source.html',
+ 'cpu_time_ms' => '2900',
+ 'group_data_source' => undef,
+ 'shop_data_age' => '7',
+ 'file_output_ind' => undef,
+ 'work_units_skipped' => '0',
+ 'scheduled_dttm' => '2006-06-03 19:01:00',
+ 'shop_level' => '10',
+ 'shop_host' => undef,
+ 'comp_strat_cd' => 'none',
+ 'work_units_error' => '0',
+ 'shop_fresh_mins' => '1080',
+ 'end_mem_mb' => '57728',
+ 'client_system_cd' => 'MV',
+ 'override_data_source' => undef,
+ 'end_arv_dt' => '2006-06-18',
+ 'prop_id' => '128',
+ 'work_units_complete' => '0',
+ 'client_userid' => 'spadkins',
+ 'finish_in_subprocess' => undef,
+ 'cell_drilldown' => 'Y',
+ 'start_dttm' => '2006-06-03 19:01:41',
+ 'begin_arv_dt' => '2006-06-03',
+ 'rm_type' => '',
+ 'est_cpu_util_pct' => undef,
+ 'shop_priority' => '1',
+ 'shop_request_id' => '5712',
+ 'shop_units' => '0',
+ 'server_system_cd' => 'MV',
+ 'compare_options' => 'PrevRateAndDirection',
+ 'view_data_sources' => 'EXP',
+ 'shop_data_source' => 'EXP',
+ 'work_units_blank' => '0',
+ 'prev_day_compare' => 'None',
+ 'request_msg' => '',
+ 'run_time_ms' => '8434',
+ 'dow' => '1,2,3,4,5,6,7',
+ 'q_client_id' => 'frento:q-hotel_compute',
+ 'complete_dttm' => '2006-06-03 19:01:47',
+ 'display_option' => 'compare.ckey.data_source.html',
+ 'start_mem_mb' => '38932',
+ 'mkt_keyword' => '',
+ 'actual_data_source' => undef,
+ 'rate_details' => 'Rate',
+ 'comp_prod_id' => '1',
+ 'email_notify' => '[email protected] ',
+ 'highlight_ind' => 'Y',
+ 'date_sense' => 'Auto',
+ 'org_id' => '1',
+ 'report_units' => '0',
+ 'email_type' => 'ReportOnly',
+ 'los' => '1',
+ 'guests' => '1',
+ 'shop_currency_cd' => 'USD',
+ 'subrequest_id' => '901',
+ 'change_dttm' => '2006-06-03 19:01:47',
+ 'request_status' => 'W',
+ 'comp_id' => '132,128,133,129,130',
+ 'est_mem_mb' => undef,
+ 'accom' => '',
+ 'shop_pos_cd' => 'US',
+ 'work_units' => '0'
+ },
+ {
+ 'profile' => 'RT03: Reports compare.ckey.data_source.comparison.html',
+ 'cpu_time_ms' => '3080',
+ 'group_data_source' => undef,
+ 'shop_data_age' => '7',
+ 'file_output_ind' => undef,
+ 'work_units_skipped' => '0',
+ 'scheduled_dttm' => '2006-06-03 19:01:00',
+ 'shop_level' => '10',
+ 'shop_host' => undef,
+ 'comp_strat_cd' => 'none',
+ 'work_units_error' => '0',
+ 'shop_fresh_mins' => '1080',
+ 'end_mem_mb' => '57732',
+ 'client_system_cd' => 'MV',
+ 'override_data_source' => undef,
+ 'end_arv_dt' => '2006-06-18',
+ 'prop_id' => '128',
+ 'work_units_complete' => '0',
+ 'client_userid' => 'spadkins',
+ 'finish_in_subprocess' => undef,
+ 'cell_drilldown' => 'Y',
+ 'start_dttm' => '2006-06-03 19:01:39',
+ 'begin_arv_dt' => '2006-06-03',
+ 'rm_type' => '',
+ 'est_cpu_util_pct' => undef,
+ 'shop_priority' => '1',
+ 'shop_request_id' => '5713',
+ 'shop_units' => '0',
+ 'server_system_cd' => 'MV',
+ 'compare_options' => 'PrevRateAndDirection',
+ 'view_data_sources' => 'EXP',
+ 'shop_data_source' => 'EXP',
+ 'work_units_blank' => '0',
+ 'prev_day_compare' => 'None',
+ 'request_msg' => '',
+ 'run_time_ms' => '14293',
+ 'dow' => '1,2,3,4,5,6,7',
+ 'q_client_id' => 'frento:q-hotel_compute',
+ 'complete_dttm' => '2006-06-03 19:01:53',
+ 'display_option' => 'compare.ckey.data_source.comparison.html',
+ 'start_mem_mb' => '38936',
+ 'mkt_keyword' => '',
+ 'actual_data_source' => undef,
+ 'rate_details' => 'Rate',
+ 'comp_prod_id' => '1',
+ 'email_notify' => '[email protected] ',
+ 'highlight_ind' => 'Y',
+ 'date_sense' => 'Auto',
+ 'org_id' => '1',
+ 'report_units' => '0',
+ 'email_type' => 'ReportOnly',
+ 'los' => '1',
+ 'guests' => '1',
+ 'shop_currency_cd' => 'USD',
+ 'subrequest_id' => '902',
+ 'change_dttm' => '2006-06-03 19:01:53',
+ 'request_status' => 'W',
+ 'comp_id' => '132,128,133,129,130',
+ 'est_mem_mb' => undef,
+ 'accom' => '',
+ 'shop_pos_cd' => 'US',
+ 'work_units' => '0'
+ },
+ {
+ 'profile' => 'RT03: Reports compare.ckey.data_source.comparison.pdf',
+ 'cpu_time_ms' => '3170',
+ 'group_data_source' => undef,
+ 'shop_data_age' => '7',
+ 'file_output_ind' => undef,
+ 'work_units_skipped' => '0',
+ 'scheduled_dttm' => '2006-06-03 19:01:00',
+ 'shop_level' => '10',
+ 'shop_host' => undef,
+ 'comp_strat_cd' => 'none',
+ 'work_units_error' => '0',
+ 'shop_fresh_mins' => '1080',
+ 'end_mem_mb' => '57184',
+ 'client_system_cd' => 'MV',
+ 'override_data_source' => undef,
+ 'end_arv_dt' => '2006-06-18',
+ 'prop_id' => '128',
+ 'work_units_complete' => '0',
+ 'client_userid' => 'spadkins',
+ 'finish_in_subprocess' => undef,
+ 'cell_drilldown' => 'Y',
+ 'start_dttm' => '2006-06-03 19:01:40',
+ 'begin_arv_dt' => '2006-06-03',
+ 'rm_type' => '',
+ 'est_cpu_util_pct' => undef,
+ 'shop_priority' => '1',
+ 'shop_request_id' => '5714',
+ 'shop_units' => '0',
+ 'server_system_cd' => 'MV',
+ 'compare_options' => 'PrevRateAndDirection',
+ 'view_data_sources' => 'EXP',
+ 'shop_data_source' => 'EXP',
+ 'work_units_blank' => '0',
+ 'prev_day_compare' => 'None',
+ 'request_msg' => '',
+ 'run_time_ms' => '13268',
+ 'dow' => '1,2,3,4,5,6,7',
+ 'q_client_id' => 'frento:q-hotel_compute',
+ 'complete_dttm' => '2006-06-03 19:01:53',
+ 'display_option' => 'compare.ckey.data_source.comparison.pdf',
+ 'start_mem_mb' => '38940',
+ 'mkt_keyword' => '',
+ 'actual_data_source' => undef,
+ 'rate_details' => 'Rate',
+ 'comp_prod_id' => '1',
+ 'email_notify' => '[email protected] ',
+ 'highlight_ind' => 'Y',
+ 'date_sense' => 'Auto',
+ 'org_id' => '1',
+ 'report_units' => '0',
+ 'email_type' => 'ReportOnly',
+ 'los' => '1',
+ 'guests' => '1',
+ 'shop_currency_cd' => 'USD',
+ 'subrequest_id' => '903',
+ 'change_dttm' => '2006-06-03 19:01:53',
+ 'request_status' => 'W',
+ 'comp_id' => '132,128,133,129,130',
+ 'est_mem_mb' => undef,
+ 'accom' => '',
+ 'shop_pos_cd' => 'US',
+ 'work_units' => '0'
+ },
+ {
+ 'profile' => 'RT03: Reports compare.ckey.data_source.comparison.xls',
+ 'cpu_time_ms' => '3760',
+ 'group_data_source' => undef,
+ 'shop_data_age' => '7',
+ 'file_output_ind' => undef,
+ 'work_units_skipped' => '0',
+ 'scheduled_dttm' => '2006-06-03 19:01:00',
+ 'shop_level' => '10',
+ 'shop_host' => undef,
+ 'comp_strat_cd' => 'none',
+ 'work_units_error' => '0',
+ 'shop_fresh_mins' => '1080',
+ 'end_mem_mb' => '59372',
+ 'client_system_cd' => 'MV',
+ 'override_data_source' => undef,
+ 'end_arv_dt' => '2006-06-18',
+ 'prop_id' => '128',
+ 'work_units_complete' => '0',
+ 'client_userid' => 'spadkins',
+ 'finish_in_subprocess' => undef,
+ 'cell_drilldown' => 'Y',
+ 'start_dttm' => '2006-06-03 19:01:41',
+ 'begin_arv_dt' => '2006-06-03',
+ 'rm_type' => '',
+ 'est_cpu_util_pct' => undef,
+ 'shop_priority' => '1',
+ 'shop_request_id' => '5715',
+ 'shop_units' => '0',
+ 'server_system_cd' => 'MV',
+ 'compare_options' => 'PrevRateAndDirection',
+ 'view_data_sources' => 'EXP',
+ 'shop_data_source' => 'EXP',
+ 'work_units_blank' => '0',
+ 'prev_day_compare' => 'None',
+ 'request_msg' => '',
+ 'run_time_ms' => '23679',
+ 'dow' => '1,2,3,4,5,6,7',
+ 'q_client_id' => 'frento:q-hotel_compute',
+ 'complete_dttm' => '2006-06-03 19:02:03',
+ 'display_option' => 'compare.ckey.data_source.comparison.xls',
+ 'start_mem_mb' => '38940',
+ 'mkt_keyword' => '',
+ 'actual_data_source' => undef,
+ 'rate_details' => 'Rate',
+ 'comp_prod_id' => '1',
+ 'email_notify' => '[email protected] ',
+ 'highlight_ind' => 'Y',
+ 'date_sense' => 'Auto',
+ 'org_id' => '1',
+ 'report_units' => '0',
+ 'email_type' => 'ReportOnly',
+ 'los' => '1',
+ 'guests' => '1',
+ 'shop_currency_cd' => 'USD',
+ 'subrequest_id' => '904',
+ 'change_dttm' => '2006-06-03 19:02:03',
+ 'request_status' => 'W',
+ 'comp_id' => '132,128,133,129,130',
+ 'est_mem_mb' => undef,
+ 'accom' => '',
+ 'shop_pos_cd' => 'US',
+ 'work_units' => '0'
+ },
+ {
+ 'profile' => 'RT03: Reports compare.ckey.data_source_los.html',
+ 'cpu_time_ms' => '2590',
+ 'group_data_source' => undef,
+ 'shop_data_age' => '7',
+ 'file_output_ind' => undef,
+ 'work_units_skipped' => '0',
+ 'scheduled_dttm' => '2006-06-03 19:01:00',
+ 'shop_level' => '10',
+ 'shop_host' => undef,
+ 'comp_strat_cd' => 'none',
+ 'work_units_error' => '0',
+ 'shop_fresh_mins' => '1080',
+ 'end_mem_mb' => '57196',
+ 'client_system_cd' => 'MV',
+ 'override_data_source' => undef,
+ 'end_arv_dt' => '2006-06-18',
+ 'prop_id' => '128',
+ 'work_units_complete' => '0',
+ 'client_userid' => 'spadkins',
+ 'finish_in_subprocess' => undef,
+ 'cell_drilldown' => 'Y',
+ 'start_dttm' => '2006-06-03 19:01:43',
+ 'begin_arv_dt' => '2006-06-03',
+ 'rm_type' => '',
+ 'est_cpu_util_pct' => undef,
+ 'shop_priority' => '1',
+ 'shop_request_id' => '5716',
+ 'shop_units' => '0',
+ 'server_system_cd' => 'MV',
+ 'compare_options' => 'PrevRateAndDirection',
+ 'view_data_sources' => 'EXP',
+ 'shop_data_source' => 'EXP',
+ 'work_units_blank' => '0',
+ 'prev_day_compare' => 'None',
+ 'request_msg' => '',
+ 'run_time_ms' => '17584',
+ 'dow' => '1,2,3,4,5,6,7',
+ 'q_client_id' => 'frento:q-hotel_compute',
+ 'complete_dttm' => '2006-06-03 19:02:00',
+ 'display_option' => 'compare.ckey.data_source_los.html',
+ 'start_mem_mb' => '38944',
+ 'mkt_keyword' => '',
+ 'actual_data_source' => undef,
+ 'rate_details' => 'Rate',
+ 'comp_prod_id' => '1',
+ 'email_notify' => '[email protected] ',
+ 'highlight_ind' => 'Y',
+ 'date_sense' => 'Auto',
+ 'org_id' => '1',
+ 'report_units' => '0',
+ 'email_type' => 'ReportOnly',
+ 'los' => '1',
+ 'guests' => '1',
+ 'shop_currency_cd' => 'USD',
+ 'subrequest_id' => '905',
+ 'change_dttm' => '2006-06-03 19:02:00',
+ 'request_status' => 'W',
+ 'comp_id' => '132,128,133,129,130',
+ 'est_mem_mb' => undef,
+ 'accom' => '',
+ 'shop_pos_cd' => 'US',
+ 'work_units' => '0'
+ },
+ {
+ 'profile' => 'RT03: Reports compare.ckey.data_source_los.xls',
+ 'cpu_time_ms' => '2610',
+ 'group_data_source' => undef,
+ 'shop_data_age' => '7',
+ 'file_output_ind' => undef,
+ 'work_units_skipped' => '0',
+ 'scheduled_dttm' => '2006-06-03 19:01:00',
+ 'shop_level' => '10',
+ 'shop_host' => undef,
+ 'comp_strat_cd' => 'none',
+ 'work_units_error' => '0',
+ 'shop_fresh_mins' => '1080',
+ 'end_mem_mb' => '57180',
+ 'client_system_cd' => 'MV',
+ 'override_data_source' => undef,
+ 'end_arv_dt' => '2006-06-18',
+ 'prop_id' => '128',
+ 'work_units_complete' => '0',
+ 'client_userid' => 'spadkins',
+ 'finish_in_subprocess' => undef,
+ 'cell_drilldown' => 'Y',
+ 'start_dttm' => '2006-06-03 19:01:43',
+ 'begin_arv_dt' => '2006-06-03',
+ 'rm_type' => '',
+ 'est_cpu_util_pct' => undef,
+ 'shop_priority' => '1',
+ 'shop_request_id' => '5717',
+ 'shop_units' => '0',
+ 'server_system_cd' => 'MV',
+ 'compare_options' => 'PrevRateAndDirection',
+ 'view_data_sources' => 'EXP',
+ 'shop_data_source' => 'EXP',
+ 'work_units_blank' => '0',
+ 'prev_day_compare' => 'None',
+ 'request_msg' => 'ERROR: /usr/rubicon/test/htdocs/temp/20060603-190143-32178-1.xls: not readable
+',
+ 'run_time_ms' => '18472',
+ 'dow' => '1,2,3,4,5,6,7',
+ 'q_client_id' => 'frento:q-hotel_compute',
+ 'complete_dttm' => '2006-06-03 19:02:01',
+ 'display_option' => 'compare.ckey.data_source_los.xls',
+ 'start_mem_mb' => '38940',
+ 'mkt_keyword' => '',
+ 'actual_data_source' => undef,
+ 'rate_details' => 'Rate',
+ 'comp_prod_id' => '1',
+ 'email_notify' => '[email protected] ',
+ 'highlight_ind' => 'Y',
+ 'date_sense' => 'Auto',
+ 'org_id' => '1',
+ 'report_units' => '0',
+ 'email_type' => 'ReportOnly',
+ 'los' => '1',
+ 'guests' => '1',
+ 'shop_currency_cd' => 'USD',
+ 'subrequest_id' => '906',
+ 'change_dttm' => '2006-06-03 19:02:01',
+ 'request_status' => 'W',
+ 'comp_id' => '132,128,133,129,130',
+ 'est_mem_mb' => undef,
+ 'accom' => '',
+ 'shop_pos_cd' => 'US',
+ 'work_units' => '0'
+ },
+ {
+ 'profile' => 'RT03: Reports compare.mkt.arv_dt_product.html',
+ 'cpu_time_ms' => '760',
+ 'group_data_source' => undef,
+ 'shop_data_age' => '7',
+ 'file_output_ind' => undef,
+ 'work_units_skipped' => '0',
+ 'scheduled_dttm' => '2006-06-03 19:01:00',
+ 'shop_level' => '10',
+ 'shop_host' => undef,
+ 'comp_strat_cd' => 'none',
+ 'work_units_error' => '0',
+ 'shop_fresh_mins' => '1080',
+ 'end_mem_mb' => '48472',
+ 'client_system_cd' => 'MV',
+ 'override_data_source' => undef,
+ 'end_arv_dt' => '2006-06-18',
+ 'prop_id' => '128',
+ 'work_units_complete' => '0',
+ 'client_userid' => 'spadkins',
+ 'finish_in_subprocess' => undef,
+ 'cell_drilldown' => 'Y',
+ 'start_dttm' => '2006-06-03 19:01:43',
+ 'begin_arv_dt' => '2006-06-03',
+ 'rm_type' => '',
+ 'est_cpu_util_pct' => undef,
+ 'shop_priority' => '1',
+ 'shop_request_id' => '5718',
+ 'shop_units' => '0',
+ 'server_system_cd' => 'MV',
+ 'compare_options' => 'PrevRateAndDirection',
+ 'view_data_sources' => 'EXP',
+ 'shop_data_source' => 'EXP',
+ 'work_units_blank' => '0',
+ 'prev_day_compare' => 'None',
+ 'request_msg' => '',
+ 'run_time_ms' => '4947',
+ 'dow' => '1,2,3,4,5,6,7',
+ 'q_client_id' => 'frento:q-hotel_compute',
+ 'complete_dttm' => '2006-06-03 19:01:47',
+ 'display_option' => 'compare.mkt.arv_dt_product.html',
+ 'start_mem_mb' => '38952',
+ 'mkt_keyword' => '',
+ 'actual_data_source' => undef,
+ 'rate_details' => 'Rate',
+ 'comp_prod_id' => '1',
+ 'email_notify' => '[email protected] ',
+ 'highlight_ind' => 'Y',
+ 'date_sense' => 'Auto',
+ 'org_id' => '1',
+ 'report_units' => '0',
+ 'email_type' => 'ReportOnly',
+ 'los' => '1',
+ 'guests' => '1',
+ 'shop_currency_cd' => 'USD',
+ 'subrequest_id' => '907',
+ 'change_dttm' => '2006-06-03 19:01:47',
+ 'request_status' => 'W',
+ 'comp_id' => '132,128,133,129,130',
+ 'est_mem_mb' => undef,
+ 'accom' => '',
+ 'shop_pos_cd' => 'US',
+ 'work_units' => '0'
+ },
+ {
+ 'profile' => 'RT03: Reports compare.mkt.arv_dt_los.html',
+ 'cpu_time_ms' => '750',
+ 'group_data_source' => undef,
+ 'shop_data_age' => '7',
+ 'file_output_ind' => undef,
+ 'work_units_skipped' => '0',
+ 'scheduled_dttm' => '2006-06-03 19:01:00',
+ 'shop_level' => '10',
+ 'shop_host' => undef,
+ 'comp_strat_cd' => 'none',
+ 'work_units_error' => '0',
+ 'shop_fresh_mins' => '1080',
+ 'end_mem_mb' => '48464',
+ 'client_system_cd' => 'MV',
+ 'override_data_source' => undef,
+ 'end_arv_dt' => '2006-06-18',
+ 'prop_id' => '128',
+ 'work_units_complete' => '0',
+ 'client_userid' => 'spadkins',
+ 'finish_in_subprocess' => undef,
+ 'cell_drilldown' => 'Y',
+ 'start_dttm' => '2006-06-03 19:01:43',
+ 'begin_arv_dt' => '2006-06-03',
+ 'rm_type' => '',
+ 'est_cpu_util_pct' => undef,
+ 'shop_priority' => '1',
+ 'shop_request_id' => '5719',
+ 'shop_units' => '0',
+ 'server_system_cd' => 'MV',
+ 'compare_options' => 'PrevRateAndDirection',
+ 'view_data_sources' => 'EXP',
+ 'shop_data_source' => 'EXP',
+ 'work_units_blank' => '0',
+ 'prev_day_compare' => 'None',
+ 'request_msg' => '',
+ 'run_time_ms' => '4450',
+ 'dow' => '1,2,3,4,5,6,7',
+ 'q_client_id' => 'frento:q-hotel_compute',
+ 'complete_dttm' => '2006-06-03 19:01:47',
+ 'display_option' => 'compare.mkt.arv_dt_los.html',
+ 'start_mem_mb' => '38940',
+ 'mkt_keyword' => '',
+ 'actual_data_source' => undef,
+ 'rate_details' => 'Rate',
+ 'comp_prod_id' => '1',
+ 'email_notify' => '[email protected] ',
+ 'highlight_ind' => 'Y',
+ 'date_sense' => 'Auto',
+ 'org_id' => '1',
+ 'report_units' => '0',
+ 'email_type' => 'ReportOnly',
+ 'los' => '1',
+ 'guests' => '1',
+ 'shop_currency_cd' => 'USD',
+ 'subrequest_id' => '908',
+ 'change_dttm' => '2006-06-03 19:01:47',
+ 'request_status' => 'W',
+ 'comp_id' => '132,128,133,129,130',
+ 'est_mem_mb' => undef,
+ 'accom' => '',
+ 'shop_pos_cd' => 'US',
+ 'work_units' => '0'
+ },
+ {
+ 'profile' => 'RT03: Reports compare.mkt.arv_dt_data_source.html',
+ 'cpu_time_ms' => '3100',
+ 'group_data_source' => undef,
+ 'shop_data_age' => '7',
+ 'file_output_ind' => undef,
+ 'work_units_skipped' => '0',
+ 'scheduled_dttm' => '2006-06-03 19:01:00',
+ 'shop_level' => '10',
+ 'shop_host' => undef,
+ 'comp_strat_cd' => 'none',
+ 'work_units_error' => '0',
+ 'shop_fresh_mins' => '1080',
+ 'end_mem_mb' => '57760',
+ 'client_system_cd' => 'MV',
+ 'override_data_source' => undef,
+ 'end_arv_dt' => '2006-06-18',
+ 'prop_id' => '128',
+ 'work_units_complete' => '0',
+ 'client_userid' => 'spadkins',
+ 'finish_in_subprocess' => undef,
+ 'cell_drilldown' => 'Y',
+ 'start_dttm' => '2006-06-03 19:01:45',
+ 'begin_arv_dt' => '2006-06-03',
+ 'rm_type' => '',
+ 'est_cpu_util_pct' => undef,
+ 'shop_priority' => '1',
+ 'shop_request_id' => '5720',
+ 'shop_units' => '0',
+ 'server_system_cd' => 'MV',
+ 'compare_options' => 'PrevRateAndDirection',
+ 'view_data_sources' => 'EXP',
+ 'shop_data_source' => 'EXP',
+ 'work_units_blank' => '0',
+ 'prev_day_compare' => 'None',
+ 'request_msg' => '',
+ 'run_time_ms' => '7722',
+ 'dow' => '1,2,3,4,5,6,7',
+ 'q_client_id' => 'frento:q-hotel_compute',
+ 'complete_dttm' => '2006-06-03 19:01:52',
+ 'display_option' => 'compare.mkt.arv_dt_data_source.html',
+ 'start_mem_mb' => '38952',
+ 'mkt_keyword' => '',
+ 'actual_data_source' => undef,
+ 'rate_details' => 'Rate',
+ 'comp_prod_id' => '1',
+ 'email_notify' => '[email protected] ',
+ 'highlight_ind' => 'Y',
+ 'date_sense' => 'Auto',
+ 'org_id' => '1',
+ 'report_units' => '0',
+ 'email_type' => 'ReportOnly',
+ 'los' => '1',
+ 'guests' => '1',
+ 'shop_currency_cd' => 'USD',
+ 'subrequest_id' => '909',
+ 'change_dttm' => '2006-06-03 19:01:52',
+ 'request_status' => 'W',
+ 'comp_id' => '132,128,133,129,130',
+ 'est_mem_mb' => undef,
+ 'accom' => '',
+ 'shop_pos_cd' => 'US',
+ 'work_units' => '0'
+ },
+ {
+ 'profile' => 'RT03: Reports compare.mkt.arv_dt_product.xls',
+ 'cpu_time_ms' => '910',
+ 'group_data_source' => undef,
+ 'shop_data_age' => '7',
+ 'file_output_ind' => undef,
+ 'work_units_skipped' => '0',
+ 'scheduled_dttm' => '2006-06-03 19:01:00',
+ 'shop_level' => '10',
+ 'shop_host' => undef,
+ 'comp_strat_cd' => 'none',
+ 'work_units_error' => '0',
+ 'shop_fresh_mins' => '1080',
+ 'end_mem_mb' => '50948',
+ 'client_system_cd' => 'MV',
+ 'override_data_source' => undef,
+ 'end_arv_dt' => '2006-06-18',
+ 'prop_id' => '128',
+ 'work_units_complete' => '0',
+ 'client_userid' => 'spadkins',
+ 'finish_in_subprocess' => undef,
+ 'cell_drilldown' => 'Y',
+ 'start_dttm' => '2006-06-03 19:01:45',
+ 'begin_arv_dt' => '2006-06-03',
+ 'rm_type' => '',
+ 'est_cpu_util_pct' => undef,
+ 'shop_priority' => '1',
+ 'shop_request_id' => '5721',
+ 'shop_units' => '0',
+ 'server_system_cd' => 'MV',
+ 'compare_options' => 'PrevRateAndDirection',
+ 'view_data_sources' => 'EXP',
+ 'shop_data_source' => 'EXP',
+ 'work_units_blank' => '0',
+ 'prev_day_compare' => 'None',
+ 'request_msg' => 'ERROR: Can\'t locate object method "_render_cell_mkt" via package "Rubicon::HotelRateView::XLS" at /usr/rubicon/test/src/mv-lib/lib/Rubicon/HotelRateView.pm line 1493.
+ (in cleanup) Can\'t use an undefined value as a HASH reference at /usr/local/lib/perl5/',
+ 'run_time_ms' => '2356',
+ 'dow' => '1,2,3,4,5,6,7',
+ 'q_client_id' => 'frento:q-hotel_compute',
+ 'complete_dttm' => '2006-06-03 19:01:46',
+ 'display_option' => 'compare.mkt.arv_dt_product.xls',
+ 'start_mem_mb' => '38940',
+ 'mkt_keyword' => '',
+ 'actual_data_source' => undef,
+ 'rate_details' => 'Rate',
+ 'comp_prod_id' => '1',
+ 'email_notify' => '[email protected] ',
+ 'highlight_ind' => 'Y',
+ 'date_sense' => 'Auto',
+ 'org_id' => '1',
+ 'report_units' => '0',
+ 'email_type' => 'ReportOnly',
+ 'los' => '1',
+ 'guests' => '1',
+ 'shop_currency_cd' => 'USD',
+ 'subrequest_id' => '910',
+ 'change_dttm' => '2006-06-03 19:01:46',
+ 'request_status' => 'W',
+ 'comp_id' => '132,128,133,129,130',
+ 'est_mem_mb' => undef,
+ 'accom' => '',
+ 'shop_pos_cd' => 'US',
+ 'work_units' => '0'
+ },
+ {
+ 'profile' => 'RT03: Reports compare.mkt.arv_dt_los.xls',
+ 'cpu_time_ms' => '880',
+ 'group_data_source' => undef,
+ 'shop_data_age' => '7',
+ 'file_output_ind' => undef,
+ 'work_units_skipped' => '0',
+ 'scheduled_dttm' => '2006-06-03 19:01:00',
+ 'shop_level' => '10',
+ 'shop_host' => undef,
+ 'comp_strat_cd' => 'none',
+ 'work_units_error' => '0',
+ 'shop_fresh_mins' => '1080',
+ 'end_mem_mb' => '50968',
+ 'client_system_cd' => 'MV',
+ 'override_data_source' => undef,
+ 'end_arv_dt' => '2006-06-18',
+ 'prop_id' => '128',
+ 'work_units_complete' => '0',
+ 'client_userid' => 'spadkins',
+ 'finish_in_subprocess' => undef,
+ 'cell_drilldown' => 'Y',
+ 'start_dttm' => '2006-06-03 19:01:47',
+ 'begin_arv_dt' => '2006-06-03',
+ 'rm_type' => '',
+ 'est_cpu_util_pct' => undef,
+ 'shop_priority' => '1',
+ 'shop_request_id' => '5722',
+ 'shop_units' => '0',
+ 'server_system_cd' => 'MV',
+ 'compare_options' => 'PrevRateAndDirection',
+ 'view_data_sources' => 'EXP',
+ 'shop_data_source' => 'EXP',
+ 'work_units_blank' => '0',
+ 'prev_day_compare' => 'None',
+ 'request_msg' => 'ERROR: Can\'t locate object method "_render_cell_mkt" via package "Rubicon::HotelRateView::XLS" at /usr/rubicon/test/src/mv-lib/lib/Rubicon/HotelRateView.pm line 1493.
+ (in cleanup) Can\'t use an undefined value as a HASH reference at /usr/local/lib/perl5/',
+ 'run_time_ms' => '2520',
+ 'dow' => '1,2,3,4,5,6,7',
+ 'q_client_id' => 'frento:q-hotel_compute',
+ 'complete_dttm' => '2006-06-03 19:01:49',
+ 'display_option' => 'compare.mkt.arv_dt_los.xls',
+ 'start_mem_mb' => '38952',
+ 'mkt_keyword' => '',
+ 'actual_data_source' => undef,
+ 'rate_details' => 'Rate',
+ 'comp_prod_id' => '1',
+ 'email_notify' => '[email protected] ',
+ 'highlight_ind' => 'Y',
+ 'date_sense' => 'Auto',
+ 'org_id' => '1',
+ 'report_units' => '0',
+ 'email_type' => 'ReportOnly',
+ 'los' => '1',
+ 'guests' => '1',
+ 'shop_currency_cd' => 'USD',
+ 'subrequest_id' => '911',
+ 'change_dttm' => '2006-06-03 19:01:49',
+ 'request_status' => 'W',
+ 'comp_id' => '132,128,133,129,130',
+ 'est_mem_mb' => undef,
+ 'accom' => '',
+ 'shop_pos_cd' => 'US',
+ 'work_units' => '0'
+ },
+ {
+ 'profile' => 'RT03: Reports compare.mkt.arv_dt_data_source.xls',
+ 'cpu_time_ms' => '2890',
+ 'group_data_source' => undef,
+ 'shop_data_age' => '7',
+ 'file_output_ind' => undef,
+ 'work_units_skipped' => '0',
+ 'scheduled_dttm' => '2006-06-03 19:01:00',
+ 'shop_level' => '10',
+ 'shop_host' => undef,
+ 'comp_strat_cd' => 'none',
+ 'work_units_error' => '0',
+ 'shop_fresh_mins' => '1080',
+ 'end_mem_mb' => '59068',
+ 'client_system_cd' => 'MV',
+ 'override_data_source' => undef,
+ 'end_arv_dt' => '2006-06-18',
+ 'prop_id' => '128',
+ 'work_units_complete' => '0',
+ 'client_userid' => 'spadkins',
+ 'finish_in_subprocess' => undef,
+ 'cell_drilldown' => 'Y',
+ 'start_dttm' => '2006-06-03 19:01:44',
+ 'begin_arv_dt' => '2006-06-03',
+ 'rm_type' => '',
+ 'est_cpu_util_pct' => undef,
+ 'shop_priority' => '1',
+ 'shop_request_id' => '5723',
+ 'shop_units' => '0',
+ 'server_system_cd' => 'MV',
+ 'compare_options' => 'PrevRateAndDirection',
+ 'view_data_sources' => 'EXP',
+ 'shop_data_source' => 'EXP',
+ 'work_units_blank' => '0',
+ 'prev_day_compare' => 'None',
+ 'request_msg' => 'ERROR: Can\'t locate object method "_render_cell_mkt" via package "Rubicon::HotelRateView::XLS" at /usr/rubicon/test/src/mv-lib/lib/Rubicon/HotelRateView.pm line 1493.
+ (in cleanup) Can\'t use an undefined value as a HASH reference at /usr/local/lib/perl5/',
+ 'run_time_ms' => '5068',
+ 'dow' => '1,2,3,4,5,6,7',
+ 'q_client_id' => 'frento:q-hotel_compute',
+ 'complete_dttm' => '2006-06-03 19:01:49',
+ 'display_option' => 'compare.mkt.arv_dt_data_source.xls',
+ 'start_mem_mb' => '38952',
+ 'mkt_keyword' => '',
+ 'actual_data_source' => undef,
+ 'rate_details' => 'Rate',
+ 'comp_prod_id' => '1',
+ 'email_notify' => '[email protected] ',
+ 'highlight_ind' => 'Y',
+ 'date_sense' => 'Auto',
+ 'org_id' => '1',
+ 'report_units' => '0',
+ 'email_type' => 'ReportOnly',
+ 'los' => '1',
+ 'guests' => '1',
+ 'shop_currency_cd' => 'USD',
+ 'subrequest_id' => '912',
+ 'change_dttm' => '2006-06-03 19:01:49',
+ 'request_status' => 'W',
+ 'comp_id' => '132,128,133,129,130',
+ 'est_mem_mb' => undef,
+ 'accom' => '',
+ 'shop_pos_cd' => 'US',
+ 'work_units' => '0'
+ },
+ {
+ 'profile' => 'RT03: Reports compare.parity.xls',
+ 'cpu_time_ms' => '9880',
+ 'group_data_source' => undef,
+ 'shop_data_age' => '7',
+ 'file_output_ind' => undef,
+ 'work_units_skipped' => '0',
+ 'scheduled_dttm' => '2006-06-03 19:01:00',
+ 'shop_level' => '10',
+ 'shop_host' => undef,
+ 'comp_strat_cd' => 'none',
+ 'work_units_error' => '0',
+ 'shop_fresh_mins' => '1080',
+ 'end_mem_mb' => '79028',
+ 'client_system_cd' => 'MV',
+ 'override_data_source' => undef,
+ 'end_arv_dt' => '2006-06-18',
+ 'prop_id' => '128',
+ 'work_units_complete' => '0',
+ 'client_userid' => 'spadkins',
+ 'finish_in_subprocess' => undef,
+ 'cell_drilldown' => 'Y',
+ 'start_dttm' => '2006-06-03 19:01:45',
+ 'begin_arv_dt' => '2006-06-03',
+ 'rm_type' => '',
+ 'est_cpu_util_pct' => undef,
+ 'shop_priority' => '1',
+ 'shop_request_id' => '5724',
+ 'shop_units' => '0',
+ 'server_system_cd' => 'MV',
+ 'compare_options' => 'PrevRateAndDirection',
+ 'view_data_sources' => 'EXP',
+ 'shop_data_source' => 'EXP',
+ 'work_units_blank' => '0',
+ 'prev_day_compare' => 'None',
+ 'request_msg' => '',
+ 'run_time_ms' => '21775',
+ 'dow' => '1,2,3,4,5,6,7',
+ 'q_client_id' => 'frento:q-hotel_compute',
+ 'complete_dttm' => '2006-06-03 19:02:06',
+ 'display_option' => 'compare.parity.xls',
+ 'start_mem_mb' => '38944',
+ 'mkt_keyword' => '',
+ 'actual_data_source' => undef,
+ 'rate_details' => 'Rate',
+ 'comp_prod_id' => '1',
+ 'email_notify' => '[email protected] ',
+ 'highlight_ind' => 'Y',
+ 'date_sense' => 'Auto',
+ 'org_id' => '1',
+ 'report_units' => '0',
+ 'email_type' => 'ReportOnly',
+ 'los' => '1',
+ 'guests' => '1',
+ 'shop_currency_cd' => 'USD',
+ 'subrequest_id' => '913',
+ 'change_dttm' => '2006-06-03 19:02:06',
+ 'request_status' => 'W',
+ 'comp_id' => '132,128,133,129,130',
+ 'est_mem_mb' => undef,
+ 'accom' => '',
+ 'shop_pos_cd' => 'US',
+ 'work_units' => '0'
+ },
+ {
+ 'profile' => 'RT03: Reports compare.history.html',
+ 'cpu_time_ms' => '9410',
+ 'group_data_source' => undef,
+ 'shop_data_age' => '7',
+ 'file_output_ind' => undef,
+ 'work_units_skipped' => '0',
+ 'scheduled_dttm' => '2006-06-03 19:01:00',
+ 'shop_level' => '10',
+ 'shop_host' => undef,
+ 'comp_strat_cd' => 'none',
+ 'work_units_error' => '0',
+ 'shop_fresh_mins' => '1080',
+ 'end_mem_mb' => '54380',
+ 'client_system_cd' => 'MV',
+ 'override_data_source' => undef,
+ 'end_arv_dt' => '2006-06-18',
+ 'prop_id' => '128',
+ 'work_units_complete' => '0',
+ 'client_userid' => 'spadkins',
+ 'finish_in_subprocess' => undef,
+ 'cell_drilldown' => 'Y',
+ 'start_dttm' => '2006-06-03 19:01:48',
+ 'begin_arv_dt' => '2006-06-03',
+ 'rm_type' => '',
+ 'est_cpu_util_pct' => undef,
+ 'shop_priority' => '1',
+ 'shop_request_id' => '5725',
+ 'shop_units' => '0',
+ 'server_system_cd' => 'MV',
+ 'compare_options' => 'PrevRateAndDirection',
+ 'view_data_sources' => 'EXP',
+ 'shop_data_source' => 'EXP',
+ 'work_units_blank' => '0',
+ 'prev_day_compare' => 'None',
+ 'request_msg' => '',
+ 'run_time_ms' => '18558',
+ 'dow' => '1,2,3,4,5,6,7',
+ 'q_client_id' => 'frento:q-hotel_compute',
+ 'complete_dttm' => '2006-06-03 19:02:06',
+ 'display_option' => 'compare.history.html',
+ 'start_mem_mb' => '38944',
+ 'mkt_keyword' => '',
+ 'actual_data_source' => undef,
+ 'rate_details' => 'Rate',
+ 'comp_prod_id' => '1',
+ 'email_notify' => '[email protected] ',
+ 'highlight_ind' => 'Y',
+ 'date_sense' => 'Auto',
+ 'org_id' => '1',
+ 'report_units' => '0',
+ 'email_type' => 'ReportOnly',
+ 'los' => '1',
+ 'guests' => '1',
+ 'shop_currency_cd' => 'USD',
+ 'subrequest_id' => '914',
+ 'change_dttm' => '2006-06-03 19:02:06',
+ 'request_status' => 'W',
+ 'comp_id' => '132,128,133,129,130',
+ 'est_mem_mb' => undef,
+ 'accom' => '',
+ 'shop_pos_cd' => 'US',
+ 'work_units' => '0'
+ },
+ {
+ 'profile' => 'RT03: Reports compare.history.csv',
+ 'cpu_time_ms' => '7430',
+ 'group_data_source' => undef,
+ 'shop_data_age' => '7',
+ 'file_output_ind' => undef,
+ 'work_units_skipped' => '0',
+ 'scheduled_dttm' => '2006-06-03 19:01:00',
+ 'shop_level' => '10',
+ 'shop_host' => undef,
+ 'comp_strat_cd' => 'none',
+ 'work_units_error' => '0',
+ 'shop_fresh_mins' => '1080',
+ 'end_mem_mb' => '52188',
+ 'client_system_cd' => 'MV',
+ 'override_data_source' => undef,
+ 'end_arv_dt' => '2006-06-18',
+ 'prop_id' => '128',
+ 'work_units_complete' => '0',
+ 'client_userid' => 'spadkins',
+ 'finish_in_subprocess' => undef,
+ 'cell_drilldown' => 'Y',
+ 'start_dttm' => '2006-06-03 19:01:48',
+ 'begin_arv_dt' => '2006-06-03',
+ 'rm_type' => '',
+ 'est_cpu_util_pct' => undef,
+ 'shop_priority' => '1',
+ 'shop_request_id' => '5726',
+ 'shop_units' => '0',
+ 'server_system_cd' => 'MV',
+ 'compare_options' => 'PrevRateAndDirection',
+ 'view_data_sources' => 'EXP',
+ 'shop_data_source' => 'EXP',
+ 'work_units_blank' => '0',
+ 'prev_day_compare' => 'None',
+ 'request_msg' => '',
+ 'run_time_ms' => '18698',
+ 'dow' => '1,2,3,4,5,6,7',
+ 'q_client_id' => 'frento:q-hotel_compute',
+ 'complete_dttm' => '2006-06-03 19:02:06',
+ 'display_option' => 'compare.history.csv',
+ 'start_mem_mb' => '38956',
+ 'mkt_keyword' => '',
+ 'actual_data_source' => undef,
+ 'rate_details' => 'Rate',
+ 'comp_prod_id' => '1',
+ 'email_notify' => '[email protected] ',
+ 'highlight_ind' => 'Y',
+ 'date_sense' => 'Auto',
+ 'org_id' => '1',
+ 'report_units' => '0',
+ 'email_type' => 'ReportOnly',
+ 'los' => '1',
+ 'guests' => '1',
+ 'shop_currency_cd' => 'USD',
+ 'subrequest_id' => '915',
+ 'change_dttm' => '2006-06-03 19:02:06',
+ 'request_status' => 'W',
+ 'comp_id' => '132,128,133,129,130',
+ 'est_mem_mb' => undef,
+ 'accom' => '',
+ 'shop_pos_cd' => 'US',
+ 'work_units' => '0'
+ },
+ {
+ 'profile' => 'RT03: Reports compare.history.xml',
+ 'cpu_time_ms' => '4230',
+ 'group_data_source' => undef,
+ 'shop_data_age' => '7',
+ 'file_output_ind' => undef,
+ 'work_units_skipped' => '0',
+ 'scheduled_dttm' => '2006-06-03 19:01:00',
+ 'shop_level' => '10',
+ 'shop_host' => undef,
+ 'comp_strat_cd' => 'none',
+ 'work_units_error' => '0',
+ 'shop_fresh_mins' => '1080',
+ 'end_mem_mb' => '52572',
+ 'client_system_cd' => 'MV',
+ 'override_data_source' => undef,
+ 'end_arv_dt' => '2006-06-18',
+ 'prop_id' => '128',
+ 'work_units_complete' => '0',
+ 'client_userid' => 'spadkins',
+ 'finish_in_subprocess' => undef,
+ 'cell_drilldown' => 'Y',
+ 'start_dttm' => '2006-06-03 19:01:50',
+ 'begin_arv_dt' => '2006-06-03',
+ 'rm_type' => '',
+ 'est_cpu_util_pct' => undef,
+ 'shop_priority' => '1',
+ 'shop_request_id' => '5727',
+ 'shop_units' => '0',
+ 'server_system_cd' => 'MV',
+ 'compare_options' => 'PrevRateAndDirection',
+ 'view_data_sources' => 'EXP',
+ 'shop_data_source' => 'EXP',
+ 'work_units_blank' => '0',
+ 'prev_day_compare' => 'None',
+ 'request_msg' => '',
+ 'run_time_ms' => '12776',
+ 'dow' => '1,2,3,4,5,6,7',
+ 'q_client_id' => 'frento:q-hotel_compute',
+ 'complete_dttm' => '2006-06-03 19:02:02',
+ 'display_option' => 'compare.history.xml',
+ 'start_mem_mb' => '38944',
+ 'mkt_keyword' => '',
+ 'actual_data_source' => undef,
+ 'rate_details' => 'Rate',
+ 'comp_prod_id' => '1',
+ 'email_notify' => '[email protected] ',
+ 'highlight_ind' => 'Y',
+ 'date_sense' => 'Auto',
+ 'org_id' => '1',
+ 'report_units' => '0',
+ 'email_type' => 'ReportOnly',
+ 'los' => '1',
+ 'guests' => '1',
+ 'shop_currency_cd' => 'USD',
+ 'subrequest_id' => '916',
+ 'change_dttm' => '2006-06-03 19:02:02',
+ 'request_status' => 'W',
+ 'comp_id' => '132,128,133,129,130',
+ 'est_mem_mb' => undef,
+ 'accom' => '',
+ 'shop_pos_cd' => 'US',
+ 'work_units' => '0'
+ },
+ {
+ 'profile' => 'RT03: Reports compare.history.xls',
+ 'cpu_time_ms' => '8480',
+ 'group_data_source' => undef,
+ 'shop_data_age' => '7',
+ 'file_output_ind' => undef,
+ 'work_units_skipped' => '0',
+ 'scheduled_dttm' => '2006-06-03 19:01:00',
+ 'shop_level' => '10',
+ 'shop_host' => undef,
+ 'comp_strat_cd' => 'none',
+ 'work_units_error' => '0',
+ 'shop_fresh_mins' => '1080',
+ 'end_mem_mb' => '61540',
+ 'client_system_cd' => 'MV',
+ 'override_data_source' => undef,
+ 'end_arv_dt' => '2006-06-18',
+ 'prop_id' => '128',
+ 'work_units_complete' => '0',
+ 'client_userid' => 'spadkins',
+ 'finish_in_subprocess' => undef,
+ 'cell_drilldown' => 'Y',
+ 'start_dttm' => '2006-06-03 19:01:50',
+ 'begin_arv_dt' => '2006-06-03',
+ 'rm_type' => '',
+ 'est_cpu_util_pct' => undef,
+ 'shop_priority' => '1',
+ 'shop_request_id' => '5728',
+ 'shop_units' => '0',
+ 'server_system_cd' => 'MV',
+ 'compare_options' => 'PrevRateAndDirection',
+ 'view_data_sources' => 'EXP',
+ 'shop_data_source' => 'EXP',
+ 'work_units_blank' => '0',
+ 'prev_day_compare' => 'None',
+ 'request_msg' => 'ERROR: Maximum Spreadsheet::WriteExcel filesize, 7087104 bytes, exceeded. To create files bigger than this limit please refer to the "Spreadsheet::WriteExcel::Big" documentation.
+ at /usr/rubicon/test/src/mv-lib/lib/Rubicon/HotelRateView/XLS.pm line 164
+',
+ 'run_time_ms' => '19254',
+ 'dow' => '1,2,3,4,5,6,7',
+ 'q_client_id' => 'frento:q-hotel_compute',
+ 'complete_dttm' => '2006-06-03 19:02:09',
+ 'display_option' => 'compare.history.xls',
+ 'start_mem_mb' => '38956',
+ 'mkt_keyword' => '',
+ 'actual_data_source' => undef,
+ 'rate_details' => 'Rate',
+ 'comp_prod_id' => '1',
+ 'email_notify' => '[email protected] ',
+ 'highlight_ind' => 'Y',
+ 'date_sense' => 'Auto',
+ 'org_id' => '1',
+ 'report_units' => '0',
+ 'email_type' => 'ReportOnly',
+ 'los' => '1',
+ 'guests' => '1',
+ 'shop_currency_cd' => 'USD',
+ 'subrequest_id' => '917',
+ 'change_dttm' => '2006-06-03 19:02:09',
+ 'request_status' => 'W',
+ 'comp_id' => '132,128,133,129,130',
+ 'est_mem_mb' => undef,
+ 'accom' => '',
+ 'shop_pos_cd' => 'US',
+ 'work_units' => '0'
+ },
+ {
+ 'profile' => 'RT03: Reports compare.history.pdf',
+ 'cpu_time_ms' => '7750',
+ 'group_data_source' => undef,
+ 'shop_data_age' => '7',
+ 'file_output_ind' => undef,
+ 'work_units_skipped' => '0',
+ 'scheduled_dttm' => '2006-06-03 19:01:00',
+ 'shop_level' => '10',
+ 'shop_host' => undef,
+ 'comp_strat_cd' => 'none',
+ 'work_units_error' => '0',
+ 'shop_fresh_mins' => '1080',
+ 'end_mem_mb' => '52472',
+ 'client_system_cd' => 'MV',
+ 'override_data_source' => undef,
+ 'end_arv_dt' => '2006-06-18',
+ 'prop_id' => '128',
+ 'work_units_complete' => '0',
+ 'client_userid' => 'spadkins',
+ 'finish_in_subprocess' => undef,
+ 'cell_drilldown' => 'Y',
+ 'start_dttm' => '2006-06-03 19:01:52',
+ 'begin_arv_dt' => '2006-06-03',
+ 'rm_type' => '',
+ 'est_cpu_util_pct' => undef,
+ 'shop_priority' => '1',
+ 'shop_request_id' => '5729',
+ 'shop_units' => '0',
+ 'server_system_cd' => 'MV',
+ 'compare_options' => 'PrevRateAndDirection',
+ 'view_data_sources' => 'EXP',
+ 'shop_data_source' => 'EXP',
+ 'work_units_blank' => '0',
+ 'prev_day_compare' => 'None',
+ 'request_msg' => '',
+ 'run_time_ms' => '19612',
+ 'dow' => '1,2,3,4,5,6,7',
+ 'q_client_id' => 'frento:q-hotel_compute',
+ 'complete_dttm' => '2006-06-03 19:02:11',
+ 'display_option' => 'compare.history.pdf',
+ 'start_mem_mb' => '38944',
+ 'mkt_keyword' => '',
+ 'actual_data_source' => undef,
+ 'rate_details' => 'Rate',
+ 'comp_prod_id' => '1',
+ 'email_notify' => '[email protected] ',
+ 'highlight_ind' => 'Y',
+ 'date_sense' => 'Auto',
+ 'org_id' => '1',
+ 'report_units' => '0',
+ 'email_type' => 'ReportOnly',
+ 'los' => '1',
+ 'guests' => '1',
+ 'shop_currency_cd' => 'USD',
+ 'subrequest_id' => '918',
+ 'change_dttm' => '2006-06-03 19:02:11',
+ 'request_status' => 'W',
+ 'comp_id' => '132,128,133,129,130',
+ 'est_mem_mb' => undef,
+ 'accom' => '',
+ 'shop_pos_cd' => 'US',
+ 'work_units' => '0'
+ },
+ {
+ 'profile' => 'RT03: Reports compare.product.pdf',
+ 'cpu_time_ms' => '750',
+ 'group_data_source' => undef,
+ 'shop_data_age' => '7',
+ 'file_output_ind' => undef,
+ 'work_units_skipped' => '0',
+ 'scheduled_dttm' => '2006-06-03 19:01:00',
+ 'shop_level' => '10',
+ 'shop_host' => undef,
+ 'comp_strat_cd' => 'none',
+ 'work_units_error' => '0',
+ 'shop_fresh_mins' => '1080',
+ 'end_mem_mb' => '48332',
+ 'client_system_cd' => 'MV',
+ 'override_data_source' => undef,
+ 'end_arv_dt' => '2006-06-18',
+ 'prop_id' => '128',
+ 'work_units_complete' => '0',
+ 'client_userid' => 'spadkins',
+ 'finish_in_subprocess' => undef,
+ 'cell_drilldown' => 'Y',
+ 'start_dttm' => '2006-06-03 19:01:53',
+ 'begin_arv_dt' => '2006-06-03',
+ 'rm_type' => '',
+ 'est_cpu_util_pct' => undef,
+ 'shop_priority' => '1',
+ 'shop_request_id' => '5730',
+ 'shop_units' => '0',
+ 'server_system_cd' => 'MV',
+ 'compare_options' => 'PrevRateAndDirection',
+ 'view_data_sources' => 'EXP',
+ 'shop_data_source' => 'EXP',
+ 'work_units_blank' => '0',
+ 'prev_day_compare' => 'None',
+ 'request_msg' => '',
+ 'run_time_ms' => '1931',
+ 'dow' => '1,2,3,4,5,6,7',
+ 'q_client_id' => 'frento:q-hotel_compute',
+ 'complete_dttm' => '2006-06-03 19:01:55',
+ 'display_option' => 'compare.product.pdf',
+ 'start_mem_mb' => '38956',
+ 'mkt_keyword' => '',
+ 'actual_data_source' => undef,
+ 'rate_details' => 'Rate',
+ 'comp_prod_id' => '1',
+ 'email_notify' => '[email protected] ',
+ 'highlight_ind' => 'Y',
+ 'date_sense' => 'Auto',
+ 'org_id' => '1',
+ 'report_units' => '0',
+ 'email_type' => 'ReportOnly',
+ 'los' => '1',
+ 'guests' => '1',
+ 'shop_currency_cd' => 'USD',
+ 'subrequest_id' => '919',
+ 'change_dttm' => '2006-06-03 19:01:55',
+ 'request_status' => 'W',
+ 'comp_id' => '132,128,133,129,130',
+ 'est_mem_mb' => undef,
+ 'accom' => '',
+ 'shop_pos_cd' => 'US',
+ 'work_units' => '0'
+ },
+ {
+ 'profile' => 'RT03: Reports compare.ckey.los.pdf',
+ 'cpu_time_ms' => '780',
+ 'group_data_source' => undef,
+ 'shop_data_age' => '7',
+ 'file_output_ind' => undef,
+ 'work_units_skipped' => '0',
+ 'scheduled_dttm' => '2006-06-03 19:01:00',
+ 'shop_level' => '10',
+ 'shop_host' => undef,
+ 'comp_strat_cd' => 'none',
+ 'work_units_error' => '0',
+ 'shop_fresh_mins' => '1080',
+ 'end_mem_mb' => '48324',
+ 'client_system_cd' => 'MV',
+ 'override_data_source' => undef,
+ 'end_arv_dt' => '2006-06-18',
+ 'prop_id' => '128',
+ 'work_units_complete' => '0',
+ 'client_userid' => 'spadkins',
+ 'finish_in_subprocess' => undef,
+ 'cell_drilldown' => 'Y',
+ 'start_dttm' => '2006-06-03 19:01:55',
+ 'begin_arv_dt' => '2006-06-03',
+ 'rm_type' => '',
+ 'est_cpu_util_pct' => undef,
+ 'shop_priority' => '1',
+ 'shop_request_id' => '5731',
+ 'shop_units' => '0',
+ 'server_system_cd' => 'MV',
+ 'compare_options' => 'PrevRateAndDirection',
+ 'view_data_sources' => 'EXP',
+ 'shop_data_source' => 'EXP',
+ 'work_units_blank' => '0',
+ 'prev_day_compare' => 'None',
+ 'request_msg' => '',
+ 'run_time_ms' => '2061',
+ 'dow' => '1,2,3,4,5,6,7',
+ 'q_client_id' => 'frento:q-hotel_compute',
+ 'complete_dttm' => '2006-06-03 19:01:57',
+ 'display_option' => 'compare.ckey.los.pdf',
+ 'start_mem_mb' => '38948',
+ 'mkt_keyword' => '',
+ 'actual_data_source' => undef,
+ 'rate_details' => 'Rate',
+ 'comp_prod_id' => '1',
+ 'email_notify' => '[email protected] ',
+ 'highlight_ind' => 'Y',
+ 'date_sense' => 'Auto',
+ 'org_id' => '1',
+ 'report_units' => '0',
+ 'email_type' => 'ReportOnly',
+ 'los' => '1',
+ 'guests' => '1',
+ 'shop_currency_cd' => 'USD',
+ 'subrequest_id' => '920',
+ 'change_dttm' => '2006-06-03 19:01:57',
+ 'request_status' => 'W',
+ 'comp_id' => '132,128,133,129,130',
+ 'est_mem_mb' => undef,
+ 'accom' => '',
+ 'shop_pos_cd' => 'US',
+ 'work_units' => '0'
+ },
+ {
+ 'profile' => 'RT03: Reports compare.ckey.data_source.pdf',
+ 'cpu_time_ms' => '2880',
+ 'group_data_source' => undef,
+ 'shop_data_age' => '7',
+ 'file_output_ind' => undef,
+ 'work_units_skipped' => '0',
+ 'scheduled_dttm' => '2006-06-03 19:01:00',
+ 'shop_level' => '10',
+ 'shop_host' => undef,
+ 'comp_strat_cd' => 'none',
+ 'work_units_error' => '0',
+ 'shop_fresh_mins' => '1080',
+ 'end_mem_mb' => '57176',
+ 'client_system_cd' => 'MV',
+ 'override_data_source' => undef,
+ 'end_arv_dt' => '2006-06-18',
+ 'prop_id' => '128',
+ 'work_units_complete' => '0',
+ 'client_userid' => 'spadkins',
+ 'finish_in_subprocess' => undef,
+ 'cell_drilldown' => 'Y',
+ 'start_dttm' => '2006-06-03 19:01:57',
+ 'begin_arv_dt' => '2006-06-03',
+ 'rm_type' => '',
+ 'est_cpu_util_pct' => undef,
+ 'shop_priority' => '1',
+ 'shop_request_id' => '5732',
+ 'shop_units' => '0',
+ 'server_system_cd' => 'MV',
+ 'compare_options' => 'PrevRateAndDirection',
+ 'view_data_sources' => 'EXP',
+ 'shop_data_source' => 'EXP',
+ 'work_units_blank' => '0',
+ 'prev_day_compare' => 'None',
+ 'request_msg' => '',
+ 'run_time_ms' => '7720',
+ 'dow' => '1,2,3,4,5,6,7',
+ 'q_client_id' => 'frento:q-hotel_compute',
+ 'complete_dttm' => '2006-06-03 19:02:04',
+ 'display_option' => 'compare.ckey.data_source.pdf',
+ 'start_mem_mb' => '38956',
+ 'mkt_keyword' => '',
+ 'actual_data_source' => undef,
+ 'rate_details' => 'Rate',
+ 'comp_prod_id' => '1',
+ 'email_notify' => '[email protected] ',
+ 'highlight_ind' => 'Y',
+ 'date_sense' => 'Auto',
+ 'org_id' => '1',
+ 'report_units' => '0',
+ 'email_type' => 'ReportOnly',
+ 'los' => '1',
+ 'guests' => '1',
+ 'shop_currency_cd' => 'USD',
+ 'subrequest_id' => '921',
+ 'change_dttm' => '2006-06-03 19:02:04',
+ 'request_status' => 'W',
+ 'comp_id' => '132,128,133,129,130',
+ 'est_mem_mb' => undef,
+ 'accom' => '',
+ 'shop_pos_cd' => 'US',
+ 'work_units' => '0'
+ },
+ {
+ 'profile' => 'RT03: Reports compare.arv_dt.xls',
+ 'cpu_time_ms' => '1110',
+ 'group_data_source' => undef,
+ 'shop_data_age' => '7',
+ 'file_output_ind' => undef,
+ 'work_units_skipped' => '0',
+ 'scheduled_dttm' => '2006-06-03 19:01:00',
+ 'shop_level' => '10',
+ 'shop_host' => undef,
+ 'comp_strat_cd' => 'none',
+ 'work_units_error' => '0',
+ 'shop_fresh_mins' => '1080',
+ 'end_mem_mb' => '51256',
+ 'client_system_cd' => 'MV',
+ 'override_data_source' => undef,
+ 'end_arv_dt' => '2006-06-18',
+ 'prop_id' => '128',
+ 'work_units_complete' => '0',
+ 'client_userid' => 'spadkins',
+ 'finish_in_subprocess' => undef,
+ 'cell_drilldown' => 'Y',
+ 'start_dttm' => '2006-06-03 19:02:00',
+ 'begin_arv_dt' => '2006-06-03',
+ 'rm_type' => '',
+ 'est_cpu_util_pct' => undef,
+ 'shop_priority' => '1',
+ 'shop_request_id' => '5733',
+ 'shop_units' => '0',
+ 'server_system_cd' => 'MV',
+ 'compare_options' => 'PrevRateAndDirection',
+ 'view_data_sources' => 'EXP',
+ 'shop_data_source' => 'EXP',
+ 'work_units_blank' => '0',
+ 'prev_day_compare' => 'None',
+ 'request_msg' => '',
+ 'run_time_ms' => '2729',
+ 'dow' => '1,2,3,4,5,6,7',
+ 'q_client_id' => 'frento:q-hotel_compute',
+ 'complete_dttm' => '2006-06-03 19:02:02',
+ 'display_option' => 'compare.arv_dt.xls',
+ 'start_mem_mb' => '38948',
+ 'mkt_keyword' => '',
+ 'actual_data_source' => undef,
+ 'rate_details' => 'Rate',
+ 'comp_prod_id' => '1',
+ 'email_notify' => '[email protected] ',
+ 'highlight_ind' => 'Y',
+ 'date_sense' => 'Auto',
+ 'org_id' => '1',
+ 'report_units' => '0',
+ 'email_type' => 'ReportOnly',
+ 'los' => '1',
+ 'guests' => '1',
+ 'shop_currency_cd' => 'USD',
+ 'subrequest_id' => '922',
+ 'change_dttm' => '2006-06-03 19:02:02',
+ 'request_status' => 'W',
+ 'comp_id' => '132,128,133,129,130',
+ 'est_mem_mb' => undef,
+ 'accom' => '',
+ 'shop_pos_cd' => 'US',
+ 'work_units' => '0'
+ },
+ {
+ 'profile' => 'RT03: Reports compare.product.xls',
+ 'cpu_time_ms' => '1260',
+ 'group_data_source' => undef,
+ 'shop_data_age' => '7',
+ 'file_output_ind' => undef,
+ 'work_units_skipped' => '0',
+ 'scheduled_dttm' => '2006-06-03 19:01:00',
+ 'shop_level' => '10',
+ 'shop_host' => undef,
+ 'comp_strat_cd' => 'none',
+ 'work_units_error' => '0',
+ 'shop_fresh_mins' => '1080',
+ 'end_mem_mb' => '51396',
+ 'client_system_cd' => 'MV',
+ 'override_data_source' => undef,
+ 'end_arv_dt' => '2006-06-18',
+ 'prop_id' => '128',
+ 'work_units_complete' => '0',
+ 'client_userid' => 'spadkins',
+ 'finish_in_subprocess' => undef,
+ 'cell_drilldown' => 'Y',
+ 'start_dttm' => '2006-06-03 19:02:02',
+ 'begin_arv_dt' => '2006-06-03',
+ 'rm_type' => '',
+ 'est_cpu_util_pct' => undef,
+ 'shop_priority' => '1',
+ 'shop_request_id' => '5734',
+ 'shop_units' => '0',
+ 'server_system_cd' => 'MV',
+ 'compare_options' => 'PrevRateAndDirection',
+ 'view_data_sources' => 'EXP',
+ 'shop_data_source' => 'EXP',
+ 'work_units_blank' => '0',
+ 'prev_day_compare' => 'None',
+ 'request_msg' => '',
+ 'run_time_ms' => '8209',
+ 'dow' => '1,2,3,4,5,6,7',
+ 'q_client_id' => 'frento:q-hotel_compute',
+ 'complete_dttm' => '2006-06-03 19:02:10',
+ 'display_option' => 'compare.product.xls',
+ 'start_mem_mb' => '38956',
+ 'mkt_keyword' => '',
+ 'actual_data_source' => undef,
+ 'rate_details' => 'Rate',
+ 'comp_prod_id' => '1',
+ 'email_notify' => '[email protected] ',
+ 'highlight_ind' => 'Y',
+ 'date_sense' => 'Auto',
+ 'org_id' => '1',
+ 'report_units' => '0',
+ 'email_type' => 'ReportOnly',
+ 'los' => '1',
+ 'guests' => '1',
+ 'shop_currency_cd' => 'USD',
+ 'subrequest_id' => '923',
+ 'change_dttm' => '2006-06-03 19:02:10',
+ 'request_status' => 'W',
+ 'comp_id' => '132,128,133,129,130',
+ 'est_mem_mb' => undef,
+ 'accom' => '',
+ 'shop_pos_cd' => 'US',
+ 'work_units' => '0'
+ },
+ {
+ 'profile' => 'RT03: Reports compare.ckey.los.xls',
+ 'cpu_time_ms' => '1080',
+ 'group_data_source' => undef,
+ 'shop_data_age' => '7',
+ 'file_output_ind' => undef,
+ 'work_units_skipped' => '0',
+ 'scheduled_dttm' => '2006-06-03 19:01:00',
+ 'shop_level' => '10',
+ 'shop_host' => undef,
+ 'comp_strat_cd' => 'none',
+ 'work_units_error' => '0',
+ 'shop_fresh_mins' => '1080',
+ 'end_mem_mb' => '51252',
+ 'client_system_cd' => 'MV',
+ 'override_data_source' => undef,
+ 'end_arv_dt' => '2006-06-18',
+ 'prop_id' => '128',
+ 'work_units_complete' => '0',
+ 'client_userid' => 'spadkins',
+ 'finish_in_subprocess' => undef,
+ 'cell_drilldown' => 'Y',
+ 'start_dttm' => '2006-06-03 19:02:03',
+ 'begin_arv_dt' => '2006-06-03',
+ 'rm_type' => '',
+ 'est_cpu_util_pct' => undef,
+ 'shop_priority' => '1',
+ 'shop_request_id' => '5735',
+ 'shop_units' => '0',
+ 'server_system_cd' => 'MV',
+ 'compare_options' => 'PrevRateAndDirection',
+ 'view_data_sources' => 'EXP',
+ 'shop_data_source' => 'EXP',
+ 'work_units_blank' => '0',
+ 'prev_day_compare' => 'None',
+ 'request_msg' => '',
+ 'run_time_ms' => '2752',
+ 'dow' => '1,2,3,4,5,6,7',
+ 'q_client_id' => 'frento:q-hotel_compute',
+ 'complete_dttm' => '2006-06-03 19:02:05',
+ 'display_option' => 'compare.ckey.los.xls',
+ 'start_mem_mb' => '38948',
+ 'mkt_keyword' => '',
+ 'actual_data_source' => undef,
+ 'rate_details' => 'Rate',
+ 'comp_prod_id' => '1',
+ 'email_notify' => '[email protected] ',
+ 'highlight_ind' => 'Y',
+ 'date_sense' => 'Auto',
+ 'org_id' => '1',
+ 'report_units' => '0',
+ 'email_type' => 'ReportOnly',
+ 'los' => '1',
+ 'guests' => '1',
+ 'shop_currency_cd' => 'USD',
+ 'subrequest_id' => '924',
+ 'change_dttm' => '2006-06-03 19:02:05',
+ 'request_status' => 'W',
+ 'comp_id' => '132,128,133,129,130',
+ 'est_mem_mb' => undef,
+ 'accom' => '',
+ 'shop_pos_cd' => 'US',
+ 'work_units' => '0'
+ },
+ {
+ 'profile' => 'RT03: Reports compare.ckey.data_source.xls',
+ 'cpu_time_ms' => '2870',
+ 'group_data_source' => undef,
+ 'shop_data_age' => '7',
+ 'file_output_ind' => undef,
+ 'work_units_skipped' => '0',
+ 'scheduled_dttm' => '2006-06-03 19:01:00',
+ 'shop_level' => '10',
+ 'shop_host' => undef,
+ 'comp_strat_cd' => 'none',
+ 'work_units_error' => '0',
+ 'shop_fresh_mins' => '1080',
+ 'end_mem_mb' => '59348',
+ 'client_system_cd' => 'MV',
+ 'override_data_source' => undef,
+ 'end_arv_dt' => '2006-06-18',
+ 'prop_id' => '128',
+ 'work_units_complete' => '0',
+ 'client_userid' => 'spadkins',
+ 'finish_in_subprocess' => undef,
+ 'cell_drilldown' => 'Y',
+ 'start_dttm' => '2006-06-03 19:02:41',
+ 'begin_arv_dt' => '2006-06-03',
+ 'rm_type' => '',
+ 'est_cpu_util_pct' => undef,
+ 'shop_priority' => '1',
+ 'shop_request_id' => '5736',
+ 'shop_units' => '0',
+ 'server_system_cd' => 'MV',
+ 'compare_options' => 'PrevRateAndDirection',
+ 'view_data_sources' => 'EXP',
+ 'shop_data_source' => 'EXP',
+ 'work_units_blank' => '0',
+ 'prev_day_compare' => 'None',
+ 'request_msg' => '',
+ 'run_time_ms' => '4016',
+ 'dow' => '1,2,3,4,5,6,7',
+ 'q_client_id' => 'frento:q-hotel_compute',
+ 'complete_dttm' => '2006-06-03 19:02:45',
+ 'display_option' => 'compare.ckey.data_source.xls',
+ 'start_mem_mb' => '38956',
+ 'mkt_keyword' => '',
+ 'actual_data_source' => undef,
+ 'rate_details' => 'Rate',
+ 'comp_prod_id' => '1',
+ 'email_notify' => '[email protected] ',
+ 'highlight_ind' => 'Y',
+ 'date_sense' => 'Auto',
+ 'org_id' => '1',
+ 'report_units' => '0',
+ 'email_type' => 'ReportOnly',
+ 'los' => '1',
+ 'guests' => '1',
+ 'shop_currency_cd' => 'USD',
+ 'subrequest_id' => '925',
+ 'change_dttm' => '2006-06-03 19:02:45',
+ 'request_status' => 'W',
+ 'comp_id' => '132,128,133,129,130',
+ 'est_mem_mb' => undef,
+ 'accom' => '',
+ 'shop_pos_cd' => 'US',
+ 'work_units' => '0'
+ },
+ {
+ 'profile' => 'RT03: Reports compare.los.csv',
+ 'cpu_time_ms' => '800',
+ 'group_data_source' => undef,
+ 'shop_data_age' => '7',
+ 'file_output_ind' => undef,
+ 'work_units_skipped' => '0',
+ 'scheduled_dttm' => '2006-06-03 19:01:00',
+ 'shop_level' => '10',
+ 'shop_host' => undef,
+ 'comp_strat_cd' => 'none',
+ 'work_units_error' => '0',
+ 'shop_fresh_mins' => '1080',
+ 'end_mem_mb' => '48272',
+ 'client_system_cd' => 'MV',
+ 'override_data_source' => undef,
+ 'end_arv_dt' => '2006-06-18',
+ 'prop_id' => '128',
+ 'work_units_complete' => '0',
+ 'client_userid' => 'spadkins',
+ 'finish_in_subprocess' => undef,
+ 'cell_drilldown' => 'Y',
+ 'start_dttm' => '2006-06-03 19:02:41',
+ 'begin_arv_dt' => '2006-06-03',
+ 'rm_type' => '',
+ 'est_cpu_util_pct' => undef,
+ 'shop_priority' => '1',
+ 'shop_request_id' => '5737',
+ 'shop_units' => '0',
+ 'server_system_cd' => 'MV',
+ 'compare_options' => 'PrevRateAndDirection',
+ 'view_data_sources' => 'EXP',
+ 'shop_data_source' => 'EXP',
+ 'work_units_blank' => '0',
+ 'prev_day_compare' => 'None',
+ 'request_msg' => '',
+ 'run_time_ms' => '2161',
+ 'dow' => '1,2,3,4,5,6,7',
+ 'q_client_id' => 'frento:q-hotel_compute',
+ 'complete_dttm' => '2006-06-03 19:02:43',
+ 'display_option' => 'compare.los.csv',
+ 'start_mem_mb' => '38948',
+ 'mkt_keyword' => '',
+ 'actual_data_source' => undef,
+ 'rate_details' => 'Rate',
+ 'comp_prod_id' => '1',
+ 'email_notify' => '[email protected] ',
+ 'highlight_ind' => 'Y',
+ 'date_sense' => 'Auto',
+ 'org_id' => '1',
+ 'report_units' => '0',
+ 'email_type' => 'ReportOnly',
+ 'los' => '1',
+ 'guests' => '1',
+ 'shop_currency_cd' => 'USD',
+ 'subrequest_id' => '926',
+ 'change_dttm' => '2006-06-03 19:02:43',
+ 'request_status' => 'W',
+ 'comp_id' => '132,128,133,129,130',
+ 'est_mem_mb' => undef,
+ 'accom' => '',
+ 'shop_pos_cd' => 'US',
+ 'work_units' => '0'
+ },
+ {
+ 'profile' => 'RT03: Reports compare.data_source.csv',
+ 'cpu_time_ms' => '2450',
+ 'group_data_source' => undef,
+ 'shop_data_age' => '7',
+ 'file_output_ind' => undef,
+ 'work_units_skipped' => '0',
+ 'scheduled_dttm' => '2006-06-03 19:01:00',
+ 'shop_level' => '10',
+ 'shop_host' => undef,
+ 'comp_strat_cd' => 'none',
+ 'work_units_error' => '0',
+ 'shop_fresh_mins' => '1080',
+ 'end_mem_mb' => '57164',
+ 'client_system_cd' => 'MV',
+ 'override_data_source' => undef,
+ 'end_arv_dt' => '2006-06-18',
+ 'prop_id' => '128',
+ 'work_units_complete' => '0',
+ 'client_userid' => 'spadkins',
+ 'finish_in_subprocess' => undef,
+ 'cell_drilldown' => 'Y',
+ 'start_dttm' => '2006-06-03 19:02:41',
+ 'begin_arv_dt' => '2006-06-03',
+ 'rm_type' => '',
+ 'est_cpu_util_pct' => undef,
+ 'shop_priority' => '1',
+ 'shop_request_id' => '5738',
+ 'shop_units' => '0',
+ 'server_system_cd' => 'MV',
+ 'compare_options' => 'PrevRateAndDirection',
+ 'view_data_sources' => 'EXP',
+ 'shop_data_source' => 'EXP',
+ 'work_units_blank' => '0',
+ 'prev_day_compare' => 'None',
+ 'request_msg' => '',
+ 'run_time_ms' => '4022',
+ 'dow' => '1,2,3,4,5,6,7',
+ 'q_client_id' => 'frento:q-hotel_compute',
+ 'complete_dttm' => '2006-06-03 19:02:45',
+ 'display_option' => 'compare.data_source.csv',
+ 'start_mem_mb' => '38956',
+ 'mkt_keyword' => '',
+ 'actual_data_source' => undef,
+ 'rate_details' => 'Rate',
+ 'comp_prod_id' => '1',
+ 'email_notify' => '[email protected] ',
+ 'highlight_ind' => 'Y',
+ 'date_sense' => 'Auto',
+ 'org_id' => '1',
+ 'report_units' => '0',
+ 'email_type' => 'ReportOnly',
+ 'los' => '1',
+ 'guests' => '1',
+ 'shop_currency_cd' => 'USD',
+ 'subrequest_id' => '927',
+ 'change_dttm' => '2006-06-03 19:02:45',
+ 'request_status' => 'W',
+ 'comp_id' => '132,128,133,129,130',
+ 'est_mem_mb' => undef,
+ 'accom' => '',
+ 'shop_pos_cd' => 'US',
+ 'work_units' => '0'
+ },
+ {
+ 'profile' => 'RT03: Reports compare.arv_dt.all.csv',
+ 'cpu_time_ms' => '870',
+ 'group_data_source' => undef,
+ 'shop_data_age' => '7',
+ 'file_output_ind' => undef,
+ 'work_units_skipped' => '0',
+ 'scheduled_dttm' => '2006-06-03 19:01:00',
+ 'shop_level' => '10',
+ 'shop_host' => undef,
+ 'comp_strat_cd' => 'none',
+ 'work_units_error' => '0',
+ 'shop_fresh_mins' => '1080',
+ 'end_mem_mb' => '48280',
+ 'client_system_cd' => 'MV',
+ 'override_data_source' => undef,
+ 'end_arv_dt' => '2006-06-18',
+ 'prop_id' => '128',
+ 'work_units_complete' => '0',
+ 'client_userid' => 'spadkins',
+ 'finish_in_subprocess' => undef,
+ 'cell_drilldown' => 'Y',
+ 'start_dttm' => '2006-06-03 19:02:41',
+ 'begin_arv_dt' => '2006-06-03',
+ 'rm_type' => '',
+ 'est_cpu_util_pct' => undef,
+ 'shop_priority' => '1',
+ 'shop_request_id' => '5739',
+ 'shop_units' => '0',
+ 'server_system_cd' => 'MV',
+ 'compare_options' => 'PrevRateAndDirection',
+ 'view_data_sources' => 'EXP',
+ 'shop_data_source' => 'EXP',
+ 'work_units_blank' => '0',
+ 'prev_day_compare' => 'None',
+ 'request_msg' => '',
+ 'run_time_ms' => '2239',
+ 'dow' => '1,2,3,4,5,6,7',
+ 'q_client_id' => 'frento:q-hotel_compute',
+ 'complete_dttm' => '2006-06-03 19:02:43',
+ 'display_option' => 'compare.arv_dt.all.csv',
+ 'start_mem_mb' => '38948',
+ 'mkt_keyword' => '',
+ 'actual_data_source' => undef,
+ 'rate_details' => 'Rate',
+ 'comp_prod_id' => '1',
+ 'email_notify' => '[email protected] ',
+ 'highlight_ind' => 'Y',
+ 'date_sense' => 'Auto',
+ 'org_id' => '1',
+ 'report_units' => '0',
+ 'email_type' => 'ReportOnly',
+ 'los' => '1',
+ 'guests' => '1',
+ 'shop_currency_cd' => 'USD',
+ 'subrequest_id' => '928',
+ 'change_dttm' => '2006-06-03 19:02:43',
+ 'request_status' => 'W',
+ 'comp_id' => '132,128,133,129,130',
+ 'est_mem_mb' => undef,
+ 'accom' => '',
+ 'shop_pos_cd' => 'US',
+ 'work_units' => '0'
+ },
+ {
+ 'profile' => 'RT03: Reports compare.data_source.los.csv',
+ 'cpu_time_ms' => '2210',
+ 'group_data_source' => undef,
+ 'shop_data_age' => '7',
+ 'file_output_ind' => undef,
+ 'work_units_skipped' => '0',
+ 'scheduled_dttm' => '2006-06-03 19:01:00',
+ 'shop_level' => '10',
+ 'shop_host' => undef,
+ 'comp_strat_cd' => 'none',
+ 'work_units_error' => '0',
+ 'shop_fresh_mins' => '1080',
+ 'end_mem_mb' => '57172',
+ 'client_system_cd' => 'MV',
+ 'override_data_source' => undef,
+ 'end_arv_dt' => '2006-06-18',
+ 'prop_id' => '128',
+ 'work_units_complete' => '0',
+ 'client_userid' => 'spadkins',
+ 'finish_in_subprocess' => undef,
+ 'cell_drilldown' => 'Y',
+ 'start_dttm' => '2006-06-03 19:02:42',
+ 'begin_arv_dt' => '2006-06-03',
+ 'rm_type' => '',
+ 'est_cpu_util_pct' => undef,
+ 'shop_priority' => '1',
+ 'shop_request_id' => '5740',
+ 'shop_units' => '0',
+ 'server_system_cd' => 'MV',
+ 'compare_options' => 'PrevRateAndDirection',
+ 'view_data_sources' => 'EXP',
+ 'shop_data_source' => 'EXP',
+ 'work_units_blank' => '0',
+ 'prev_day_compare' => 'None',
+ 'request_msg' => '',
+ 'run_time_ms' => '4409',
+ 'dow' => '1,2,3,4,5,6,7',
+ 'q_client_id' => 'frento:q-hotel_compute',
+ 'complete_dttm' => '2006-06-03 19:02:46',
+ 'display_option' => 'compare.data_source.los.csv',
+ 'start_mem_mb' => '38956',
+ 'mkt_keyword' => '',
+ 'actual_data_source' => undef,
+ 'rate_details' => 'Rate',
+ 'comp_prod_id' => '1',
+ 'email_notify' => '[email protected] ',
+ 'highlight_ind' => 'Y',
+ 'date_sense' => 'Auto',
+ 'org_id' => '1',
+ 'report_units' => '0',
+ 'email_type' => 'ReportOnly',
+ 'los' => '1',
+ 'guests' => '1',
+ 'shop_currency_cd' => 'USD',
+ 'subrequest_id' => '929',
+ 'change_dttm' => '2006-06-03 19:02:46',
+ 'request_status' => 'W',
+ 'comp_id' => '132,128,133,129,130',
+ 'est_mem_mb' => undef,
+ 'accom' => '',
+ 'shop_pos_cd' => 'US',
+ 'work_units' => '0'
+ },
+ {
+ 'profile' => 'RT03: Reports compare.text',
+ 'cpu_time_ms' => '680',
+ 'group_data_source' => undef,
+ 'shop_data_age' => '7',
+ 'file_output_ind' => undef,
+ 'work_units_skipped' => '0',
+ 'scheduled_dttm' => '2006-06-03 19:01:00',
+ 'shop_level' => '10',
+ 'shop_host' => undef,
+ 'comp_strat_cd' => 'none',
+ 'work_units_error' => '0',
+ 'shop_fresh_mins' => '1080',
+ 'end_mem_mb' => '48208',
+ 'client_system_cd' => 'MV',
+ 'override_data_source' => undef,
+ 'end_arv_dt' => '2006-06-18',
+ 'prop_id' => '128',
+ 'work_units_complete' => '0',
+ 'client_userid' => 'spadkins',
+ 'finish_in_subprocess' => undef,
+ 'cell_drilldown' => 'Y',
+ 'start_dttm' => '2006-06-03 19:02:41',
+ 'begin_arv_dt' => '2006-06-03',
+ 'rm_type' => '',
+ 'est_cpu_util_pct' => undef,
+ 'shop_priority' => '1',
+ 'shop_request_id' => '5741',
+ 'shop_units' => '0',
+ 'server_system_cd' => 'MV',
+ 'compare_options' => 'PrevRateAndDirection',
+ 'view_data_sources' => 'EXP',
+ 'shop_data_source' => 'EXP',
+ 'work_units_blank' => '0',
+ 'prev_day_compare' => 'None',
+ 'request_msg' => 'ERROR: Can\'t call method "_render_3d_basic" on an undefined value at /usr/rubicon/test/src/mv-lib/lib/Rubicon/HotelRateSet.pm line 557.
+',
+ 'run_time_ms' => '1118',
+ 'dow' => '1,2,3,4,5,6,7',
+ 'q_client_id' => 'frento:q-hotel_compute',
+ 'complete_dttm' => '2006-06-03 19:02:42',
+ 'display_option' => 'compare.text',
+ 'start_mem_mb' => '38948',
+ 'mkt_keyword' => '',
+ 'actual_data_source' => undef,
+ 'rate_details' => 'Rate',
+ 'comp_prod_id' => '1',
+ 'email_notify' => '[email protected] ',
+ 'highlight_ind' => 'Y',
+ 'date_sense' => 'Auto',
+ 'org_id' => '1',
+ 'report_units' => '0',
+ 'email_type' => 'ReportOnly',
+ 'los' => '1',
+ 'guests' => '1',
+ 'shop_currency_cd' => 'USD',
+ 'subrequest_id' => '930',
+ 'change_dttm' => '2006-06-03 19:02:42',
+ 'request_status' => 'W',
+ 'comp_id' => '132,128,133,129,130',
+ 'est_mem_mb' => undef,
+ 'accom' => '',
+ 'shop_pos_cd' => 'US',
+ 'work_units' => '0'
+ },
+ {
+ 'profile' => 'RT03: Reports compare.xml',
+ 'cpu_time_ms' => '480',
+ 'group_data_source' => undef,
+ 'shop_data_age' => '7',
+ 'file_output_ind' => undef,
+ 'work_units_skipped' => '0',
+ 'scheduled_dttm' => '2006-06-03 19:01:00',
+ 'shop_level' => '10',
+ 'shop_host' => undef,
+ 'comp_strat_cd' => 'none',
+ 'work_units_error' => '0',
+ 'shop_fresh_mins' => '1080',
+ 'end_mem_mb' => '48464',
+ 'client_system_cd' => 'MV',
+ 'override_data_source' => undef,
+ 'end_arv_dt' => '2006-06-18',
+ 'prop_id' => '128',
+ 'work_units_complete' => '0',
+ 'client_userid' => 'spadkins',
+ 'finish_in_subprocess' => undef,
+ 'cell_drilldown' => 'Y',
+ 'start_dttm' => '2006-06-05 11:25:56',
+ 'begin_arv_dt' => '2006-06-03',
+ 'rm_type' => '',
+ 'est_cpu_util_pct' => undef,
+ 'shop_priority' => '1',
+ 'shop_request_id' => '5742',
+ 'shop_units' => '0',
+ 'server_system_cd' => 'MV',
+ 'compare_options' => 'PrevRateAndDirection',
+ 'view_data_sources' => 'EXP',
+ 'shop_data_source' => 'EXP',
+ 'work_units_blank' => '0',
+ 'prev_day_compare' => 'None',
+ 'request_msg' => '',
+ 'run_time_ms' => '18031',
+ 'dow' => '1,2,3,4,5,6,7',
+ 'q_client_id' => 'frento:q-hotel_compute',
+ 'complete_dttm' => '2006-06-05 11:26:13',
+ 'display_option' => 'compare.xml',
+ 'start_mem_mb' => '38924',
+ 'mkt_keyword' => '',
+ 'actual_data_source' => undef,
+ 'rate_details' => 'Rate',
+ 'comp_prod_id' => '1',
+ 'email_notify' => '[email protected] ',
+ 'highlight_ind' => 'Y',
+ 'date_sense' => 'Auto',
+ 'org_id' => '1',
+ 'report_units' => '0',
+ 'email_type' => 'ReportOnly',
+ 'los' => '1',
+ 'guests' => '1',
+ 'shop_currency_cd' => 'USD',
+ 'subrequest_id' => '931',
+ 'change_dttm' => '2006-06-05 11:26:13',
+ 'request_status' => 'W',
+ 'comp_id' => '132,128,133,129,130',
+ 'est_mem_mb' => undef,
+ 'accom' => '',
+ 'shop_pos_cd' => 'US',
+ 'work_units' => '0'
+ },
+ {
+ 'profile' => 'RT03: Reports compare.all.xml',
+ 'cpu_time_ms' => '520',
+ 'group_data_source' => undef,
+ 'shop_data_age' => '7',
+ 'file_output_ind' => undef,
+ 'work_units_skipped' => '0',
+ 'scheduled_dttm' => '2006-06-03 19:01:00',
+ 'shop_level' => '10',
+ 'shop_host' => undef,
+ 'comp_strat_cd' => 'none',
+ 'work_units_error' => '0',
+ 'shop_fresh_mins' => '1080',
+ 'end_mem_mb' => '48628',
+ 'client_system_cd' => 'MV',
+ 'override_data_source' => undef,
+ 'end_arv_dt' => '2006-06-18',
+ 'prop_id' => '128',
+ 'work_units_complete' => '0',
+ 'client_userid' => 'spadkins',
+ 'finish_in_subprocess' => undef,
+ 'cell_drilldown' => 'Y',
+ 'start_dttm' => '2006-06-05 11:25:56',
+ 'begin_arv_dt' => '2006-06-03',
+ 'rm_type' => '',
+ 'est_cpu_util_pct' => undef,
+ 'shop_priority' => '1',
+ 'shop_request_id' => '5743',
+ 'shop_units' => '0',
+ 'server_system_cd' => 'MV',
+ 'compare_options' => 'PrevRateAndDirection',
+ 'view_data_sources' => 'EXP',
+ 'shop_data_source' => 'EXP',
+ 'work_units_blank' => '0',
+ 'prev_day_compare' => 'None',
+ 'request_msg' => '',
+ 'run_time_ms' => '7773',
+ 'dow' => '1,2,3,4,5,6,7',
+ 'q_client_id' => 'frento:q-hotel_compute',
+ 'complete_dttm' => '2006-06-05 11:26:03',
+ 'display_option' => 'compare.all.xml',
+ 'start_mem_mb' => '38928',
+ 'mkt_keyword' => '',
+ 'actual_data_source' => undef,
+ 'rate_details' => 'Rate',
+ 'comp_prod_id' => '1',
+ 'email_notify' => '[email protected] ',
+ 'highlight_ind' => 'Y',
+ 'date_sense' => 'Auto',
+ 'org_id' => '1',
+ 'report_units' => '0',
+ 'email_type' => 'ReportOnly',
+ 'los' => '1',
+ 'guests' => '1',
+ 'shop_currency_cd' => 'USD',
+ 'subrequest_id' => '932',
+ 'change_dttm' => '2006-06-05 11:26:03',
+ 'request_status' => 'W',
+ 'comp_id' => '132,128,133,129,130',
+ 'est_mem_mb' => undef,
+ 'accom' => '',
+ 'shop_pos_cd' => 'US',
+ 'work_units' => '0'
+ }
+ ];
+ return($VAR1);
+}
+