thread-3 working on jpg mapping, since there is no title able, it's put into unmapped/WON/
so, next node is to get unmapped content path, so, thread-3 drop off, put the token back to exectuion queue.

then thread-3, took another request on another queue, asking for Create Unmapped Directory

06 Sep 2014 23:46:39,304  INFO [CMS] [token-thread-3] GetUnamappedContentPath.execute() - Input contentFileName: poster1UPG44-001410039786M.jpg
06 Sep 2014 23:46:41,039  INFO [CMS] [token-thread-3] GetUnamappedContentPath.execute() - Scan result: NO FILE FOUND
06 Sep 2014 23:46:41,039  INFO [CMS] [token-thread-3] GetUnamappedContentPath.execute() - Output unmappedContentPath: /content/unmapped/WON/
06 Sep 2014 23:46:41,040  INFO [CMS] [token-thread-3] AbstractTaskNode.leave() - [Process] [6099387:6671362] BUSY (Get Unmapped Content Path)
06 Sep 2014 23:46:41,051  INFO [CMS] [token-thread-3] CustomToken.setStatus() - [6099387:6671362] BUSY -> RUNNING
06 Sep 2014 23:46:41,115  INFO [CMS] [token-thread-3] CustomToken.setStatus() - [6099387:6671362] RUNNING -> QUEUED
06 Sep 2014 23:46:41,182  INFO [CMS] [token-thread-3] RequestResource.execute() - [6099387:6671362] QUEUED (Create Unmapped Directory) trying to acquire resource


start time: 12:40 PM, Sep 11, 

French time: 9:40 PM, Sep 11 

select to_char(createdate,'yyyymmdd hh24') as ingest_master_Hr, count(*) as ingest_master_count
from wfs.pmm_title t
where t.createdate between to_date('09/11/2014 21:40:00','mm/dd/yyyy hh24:mi:ss') and to_date('09/12/2014 23:00:00','mm/dd/yyyy hh24:mi:ss')
and t.originaltitle_id is null
group by to_char(createdate,'yyyymmdd hh24') 
order by 1;


select to_char(status_updated_time,'mm/dd/yyyy hh24') as distributed_hr, count(*) as distributed_count
from wfs.pmm_title t, wfs.sites_distsitetitle dst
where dst.status_updated_time between to_date('09/11/2014 21:40:00','mm/dd/yyyy hh24:mi:ss') and to_date('09/12/2014 23:00:00','mm/dd/yyyy hh24:mi:ss')
  and t.id_ = dst.titleid
  and dst.status = 3
group by to_char(status_updated_time,'mm/dd/yyyy hh24')
order by 1;


select to_char(status_updated_time,'mm/dd/yyyy hh24') as all_dist_status_hr, count(*) as all_site_count
from wfs.pmm_title t, wfs.sites_distsitetitle dst
where dst.status_updated_time between to_date('09/11/2014 21:40:00','mm/dd/yyyy hh24:mi:ss') and to_date('09/12/2014 23:00:00','mm/dd/yyyy hh24:mi:ss')
  and t.id_ = dst.titleid
group by to_char(status_updated_time,'mm/dd/yyyy hh24')
order by 1;


select dst.status as all_dist_status, count(*) as all_title_count
from wfs.pmm_title t, wfs.sites_distsitetitle dst
where dst.status_updated_time between to_date('09/11/2014 21:40:00','mm/dd/yyyy hh24:mi:ss') and to_date('09/12/2014 23:00:00','mm/dd/yyyy hh24:mi:ss')
  and t.id_ = dst.titleid
group by dst.status
order by 1;



0;"TARGETED"
1;"READY_FOR_DISTRIBUTION"
2;"IN_PROGRESS"
3;"DISTRIBUTED"
4;"FAILED"




========================


select to_char(createdate,'yyyymmdd hh24') as ingest_all_Hr, count(*) as ingest_all_count
from wfs.pmm_title t
where t.createdate between to_date('09/30/2014 00:00:00','mm/dd/yyyy hh24:mi:ss') and to_date('10/02/2014 23:00:00','mm/dd/yyyy hh24:mi:ss')
group by to_char(createdate,'yyyymmdd hh24') 
order by 1;

select to_char(createdate,'yyyymmdd hh24') as ingest_master_Hr, count(*) as ingest_master_count
from wfs.pmm_title t
where t.createdate between to_date('09/30/2014 00:00:00','mm/dd/yyyy hh24:mi:ss') and to_date('10/02/2014 23:00:00','mm/dd/yyyy hh24:mi:ss')
and t.originaltitle_id is null
group by to_char(createdate,'yyyymmdd hh24') 
order by 1;

select to_char(status_updated_time,'mm/dd/yyyy hh24') as distributed_hr, count(*) as distributed_count
from wfs.pmm_title t, wfs.sites_distsitetitle dst
where dst.status_updated_time between to_date('09/08/2014 13:00:00','mm/dd/yyyy hh24:mi:ss') and to_date('09/10/2014 23:00:00','mm/dd/yyyy hh24:mi:ss')
  and t.id_ = dst.titleid
  and dst.status = 3
group by to_char(status_updated_time,'mm/dd/yyyy hh24')
order by 1;

select dst.status as distributed_status, count(*) as all_title_count
from wfs.pmm_title t, wfs.sites_distsitetitle dst
where dst.status_updated_time between to_date('09/08/2014 13:00:00','mm/dd/yyyy hh24:mi:ss') and to_date('09/10/2014 23:00:00','mm/dd/yyyy hh24:mi:ss')
  and t.id_ = dst.titleid
group by dst.status
order by 1;



select t1.id_ as site_titleId, t2.id_ as master_titleId, dst.status, t2.createdate as mastertitle_createTime, dst.status_updated_time, age(dst.status_updated_time,t2.createdate) as duration
from pmm_title t1, pmm_title t2, sites_distsitetitle dst
where dst.titleid = t1.id_ 
and t1.originaltitle_id = t2.id_
and t1.originaltitle_id is not null
and dst.status = 3
and dst.status_updated_time between to_date('09/08/2014 13:00:00','mm/dd/yyyy hh24:mi:ss') and to_date('09/09/2014 03:00:00','mm/dd/yyyy hh24:mi:ss');



-----------------------------

select dst.status as distributed_status, count(*) as all_title_count
from wfs.pmm_title t, wfs.sites_distsitetitle dst
where dst.status_updated_time between to_date('09/08/2014 18:00:00','mm/dd/yyyy hh24:mi:ss') and to_date('09/08/2014 19:00:00','mm/dd/yyyy hh24:mi:ss')
  and t.id_ = dst.titleid
group by dst.status
order by 1;



select dst.status as distributed_status, count(*) as all_title_count
from wfs.pmm_title t, wfs.sites_distsitetitle dst
where dst.status_updated_time between to_date('09/08/2014 19:00:00','mm/dd/yyyy hh24:mi:ss') and to_date('09/08/2014 20:00:00','mm/dd/yyyy hh24:mi:ss')
  and t.id_ = dst.titleid
group by dst.status
order by 1;


select dst.status as distributed_status, count(*) as all_title_count
from wfs.pmm_title t, wfs.sites_distsitetitle dst
where dst.status_updated_time between to_date('09/08/2014 20:00:00','mm/dd/yyyy hh24:mi:ss') and to_date('09/08/2014 21:00:00','mm/dd/yyyy hh24:mi:ss')
  and t.id_ = dst.titleid
group by dst.status
order by 1;
=========


select dst.status as distributed_status, count(*) as title_count
from wfs.pmm_title t, wfs.sites_distsitetitle dst
where dst.status_updated_time between to_date('09/08/2014 13:00:00','mm/dd/yyyy hh24:mi:ss') and to_date('09/08/2014 14:00:00','mm/dd/yyyy hh24:mi:ss')
  and t.id_ = dst.titleid
group by dst.status
order by 1;

select dst.status as distributed_status, count(*) as title_count
from wfs.pmm_title t, wfs.sites_distsitetitle dst
where dst.status_updated_time between to_date('09/08/2014 14:00:00','mm/dd/yyyy hh24:mi:ss') and to_date('09/08/2014 15:00:00','mm/dd/yyyy hh24:mi:ss')
  and t.id_ = dst.titleid
group by dst.status
order by 1;

select dst.status as distributed_status, count(*) as title_count
from wfs.pmm_title t, wfs.sites_distsitetitle dst
where dst.status_updated_time between to_date('09/08/2014 15:00:00','mm/dd/yyyy hh24:mi:ss') and to_date('09/08/2014 16:00:00','mm/dd/yyyy hh24:mi:ss')
  and t.id_ = dst.titleid
group by dst.status
order by 1;

select dst.status as distributed_status, count(*) as title_count
from wfs.pmm_title t, wfs.sites_distsitetitle dst
where dst.status_updated_time between to_date('09/08/2014 16:00:00','mm/dd/yyyy hh24:mi:ss') and to_date('09/08/2014 17:00:00','mm/dd/yyyy hh24:mi:ss')
  and t.id_ = dst.titleid
group by dst.status
order by 1;

select dst.status as distributed_status, count(*) as title_count
from wfs.pmm_title t, wfs.sites_distsitetitle dst
where dst.status_updated_time between to_date('09/08/2014 17:00:00','mm/dd/yyyy hh24:mi:ss') and to_date('09/08/2014 18:00:00','mm/dd/yyyy hh24:mi:ss')
  and t.id_ = dst.titleid
group by dst.status
order by 1;


select dst.status as distributed_status, count(*) as title_count
from wfs.pmm_title t, wfs.sites_distsitetitle dst
where dst.status_updated_time between to_date('09/08/2014 18:00:00','mm/dd/yyyy hh24:mi:ss') and to_date('09/08/2014 19:00:00','mm/dd/yyyy hh24:mi:ss')
  and t.id_ = dst.titleid
group by dst.status
order by 1;

=======



select to_char(createdate,'yyyymmdd hh24') as Ingest_all_Hr, count(*) 
from wfs.pmm_title t
where t.createdate between to_date('09/07/2014 06:00:00','mm/dd/yyyy hh24:mi:ss') and to_date('09/07/2014 11:00:00','mm/dd/yyyy hh24:mi:ss')
and t.originaltitle_id is null
group by to_char(createdate,'yyyymmdd hh24') 
order by 1;

select to_char(status_updated_time,'mm/dd/yyyy hh24') as distributed_hr, count(*) as title_count
from wfs.pmm_title t, wfs.sites_distsitetitle dst
where dst.status_updated_time between to_date('09/06/2014','mm/dd/yyyy') and to_date('09/08/2014','mm/dd/yyyy')
  and t.id_ = dst.titleid
  and dst.status = 3
group by to_char(status_updated_time,'mm/dd/yyyy hh24')
order by 1;




select to_char(status_updated_time,'mm/dd/yyyy hh24') as distributed_hr, count(*) as title_count
from wfs.pmm_title t, wfs.sites_distsitetitle dst
where dst.status_updated_time between to_date('09/07/2014 06:00:00','mm/dd/yyyy hh24:mi:ss') and to_date('09/07/2014 11:00:00','mm/dd/yyyy hh24:mi:ss')
  and t.id_ = dst.titleid
  and dst.status = 3
group by to_char(status_updated_time,'mm/dd/yyyy hh24')
order by 1;