t Information: 1220 :  10|12:05:33.5789|||Get Configuration Values:
t Information: 1220 :  10|12:05:33.5789|||	AdminPassEnc, default: , value: ffqjrn0leKv4Lj2YJHe2dw==.
t Information: 1220 :  10|12:05:33.5789|||	EncryptedPasswords, default: false, value: true.
t Information: 1220 :  10|12:05:33.5789|||	OraConnectionString, default: , value: Server=TECHM;User Id=imfx;Password=xxxxx;Unicode=true;.
t Information: 1220 :  10|12:05:33.5789|||	SecondTimezone, default: , value: .
t Information: 1220 :  10|12:05:33.5789|||	UseActiveDirectoryAuth, default: false, value: false.
t Information: 1220 :  10|12:05:33.5789|||	ReportingServiceUrl, default: , value: http://localhost:92/ReportingService.svc.
t Information: 1220 :  10|12:05:33.5789|||	ReportsPath, default: , value: .
t Information: 1220 :  10|12:05:33.5789|||	ReportsURL, default: , value: .
t Information: 1220 :  10|12:05:33.5789|||	TapeServiceUrl, default: , value: .
t Information: 1220 :  10|12:05:33.5789|||	GatekeeperUrl, default: , value: .
t Information: 1220 :  10|12:05:33.5789|||	ValuationUrl, default: , value: .
t Information: 1220 :  10|12:05:33.5789|||	QueueManagerDelay, default: 30, value: 30.
t Information: 1220 :  10|12:05:33.5789|||	QueueManagerFullRefresh, default: 90, value: 90.
t Information: 1220 :  10|12:05:33.5789|||	AudioLoopDuration, default: 0, value: 150.
t Information: 1220 :  10|12:05:33.5789|||	AudioLoopsCount, default: 0, value: 0.
t Information: 1220 :  10|12:05:33.5789|||	PlayerFakeStep, default: 500, value: 500.
t Information: 1220 :  10|12:05:33.5789|||	PlayerForceRatio, default: 0, value: 1.
t Information: 1220 :  10|12:05:33.5789|||	CheckVersionsInProd, default: false, value: True.
t Information: 1220 :  10|12:05:33.5789|||	MaxResults, default: 3000, value: 10000.
t Information: 1220 :  10|12:05:33.5789|||	TEReportID, default: 0, value: 0.
t Information: 1220 :  10|12:05:33.5789|||	ClosedCaptionsCache, default: , value: C:\inetpub\wwwroot\imfxcore\timedtextcache\.
t Information: 1220 :  10|12:05:33.5789|||	ClosedCaptionsStorage, default: , value: c:\Mediaflex\subs.
t Information: 1220 :  10|12:05:33.5789|||	TimeCodeFormat, default: , value: pal.
t Information: 1220 :  10|12:05:33.5789|||	RceMediaPath, default: , value: C:\edl\.
t Information: 1220 :  10|12:05:33.5789|||	RceMediaPath, default: , value: C:\edl\.
t Information: 1220 :  10|12:05:33.5789|||	RceCsmOutputPath, default: , value: C:\Inetpub\wwwroot\csm\.
t Information: 1220 :  10|12:05:33.5789|||	RceCsmUrl, default: , value: http://localhost/csm/.
t Information: 1220 :  10|12:05:33.5789|||	RceMediaSelection, default: , value: miLinkIdMatch.
t Information: 1220 :  10|12:05:33.5789|||	RequestBrowseJobPresetName, default: , value: .
t Information: 1220 :  10|12:05:33.5789|||	DontExtendDuration, default: false, value: False.
t Information: 1220 :  10|12:05:33.5789|||	V3ConfigUrl, default: , value: .
t Information: 1220 :  10|12:05:33.5789|||	StopWords, default: , value: .
t Information: 1220 :  10|12:05:33.5789|||	MisrTxFormat, default: G, value: G.
t Information: 1220 :  10|12:05:33.5789|||	ApiServer, default: , value: http://192.168.120.10:85.
t Information: 1220 :  10|12:05:33.5789|||	ApiTimeout, default: 120, value: 120.
t Information: 1220 :  10|12:05:33.5789|||	ApiWorkers, default: 10, value: 10.
t Information: 1220 :  10|12:05:33.5789|||	UsePerfCounters, default: false, value: false.
t Information: 1220 :  10|12:05:33.5789|||	LogGetCurrentUser, default: true, value: true.
t Information: 1220 :  10|12:05:33.5789|||	LogInternalApi, default: true, value: true.
t Information: 1220 :  10|12:05:33.5789|||	ThumbnailServer, default: , value: .
t Information: 1220 :  10|12:05:33.5789|||	LocationFilter, default: , value: .
t Information: 1220 :  10|12:05:33.5789|||	SvUtilServiceUrl, default: , value: .
t Information: 1220 :  10|12:05:33.5789|||	SolrConnection, default: , value: http://192.168.120.14:8983/solr.
t Information: 1220 :  10|12:05:33.5789|||	UseIndexServerSearch, default: false, value: True.
t Information: 1220 :  10|12:05:33.5789|||	SolrIndexVersion, default: 1, value: 6.
t Information: 1220 :  10|12:05:33.5789|||	SolrConnection, default: , value: http://192.168.120.14:8983/solr.
t Information: 1220 :  10|12:05:33.5789|||	FacetsGroups, default: , value: owners,season_id, series_id,version_key,item_type,media_type,media_format,episode_number.
t Information: 1220 :  10|12:05:33.5789|||	FacetsGroupsVersion, default: , value: owners,season_id, series_id,version_key,episode_number.
t Information: 1220 :  10|12:05:33.5789|||	FacetsGroupsChameleon, default: , value: season_id, series_id,genre,prod_year,version_key.
t Information: 1220 :  10|12:05:33.5789|||	PreviewPreset, default: , value: .
t Information: 1220 :  10|12:05:33.5789|||	DevMode, default: false, value: false.
t Information: 1220 :  10|12:05:33.5789|||	DisableSysMan, default: false, value: false.
t Information: 1220 :  10|12:05:33.5789|||	TimeCodeFormat, default: , value: pal.
t Information: 1220 :  10|12:05:33.5789|||	FileCatalystStorageDevice, default: , value: .
t Information: 1220 :  10|12:05:33.5789|||	UseResponsibilityTracking, default: true, value: True.
t Information: 1220 :  10|12:05:33.5789|||	SubtitleDeviceFilter, default: , value: .
t Information: 1220 :  10|12:05:33.5789|||	SystemMonitorNamedPipe, default: , value: .
t Information: 1220 :  10|12:05:33.5789|||	OracleMonitorEnable, default: false, value: False.
t Information: 1220 :  10|12:05:33.5789|||	ArcApiHost, default: , value: .
t Information: 1220 :  10|12:05:33.5789|||	RabbitMqUrl, default: , value: amqp://192.168.120.14:5672.
t Information: 1220 :  10|12:05:33.5789|||	SolrTimedTextSearch, default: false, value: false.
t Information: 1220 :  10|12:05:33.5789|||	ProductionDurationUsageID, default: 1, value: 1.
t Information: 1220 :  10|12:05:33.7976|||GetStreamServers..
t Information: 1220 :  10|12:05:34.2039|||	https://demo.tmd.tv/CBR Video/ |CBR Video| False  
t Information: 1220 :  10|12:05:34.2039|||	https://demo.tmd.tv/CBR Images/ |CBR Images| False  
t Information: 1220 :  10|12:05:34.2039|||	https://demo.tmd.tv/CBR Audio/ |CBR Audio| False  
t Information: 1220 :  10|12:05:34.2039|||	https://demo.tmd.tv/Temp Upload/ |TEMP_UPLOAD| False  
t Information: 1220 :  10|12:05:34.2039|||	http://localhost:82/images/ |IMAGES| False  
t Information: 1220 :  10|12:05:34.2039|||	http://192.168.91.73/smoothcloud/ |SMOOTH_CLOUD| False  
t Information: 1220 :  10|12:05:34.2039|||	http://192.168.91.73/cloudstore/ |CLOUD_STORE| False  
t Information: 1220 :  10|12:05:34.2039|||	http://192.168.91.73/editsystemin/ |EDIT_SYSTEM_IN| False  
t Information: 1220 :  10|12:05:34.2039|||	http://192.168.91.27:89/APPLEPROXY/ |APPLE_PROXY| False  
t Information: 1220 :  10|12:05:34.2039|||	http://localhost:82/video/ |FILESTORE_VIDEO| False  
t Information: 1220 :  10|12:05:34.2039|||	https://imfxv3tm.tmd.tv/streaming/ |Streaming| False  
t Information: 1220 :  10|12:05:34.2039|||	https://imfxv3tm.tmd.tv/VideoServer/ |Video| False  
t Information: 1220 :  10|12:05:34.2039|||	https://imfxv3tm.tmd.tv/AdobeIn/ |Adobe Premiere Pro In| False  
t Information: 1220 :  10|12:05:34.2039|||	https://imfxv3tm.tmd.tv/AudioServer/ |Audio| False  
t Information: 1220 :  10|12:05:34.2039|||	https://imfxv3tm.tmd.tv/ImageServer/ |Image| False  
t Information: 1220 :  10|12:05:34.2039|||	https://imfxv3tm.tmd.tv/DocsServer/ |Docs| False  
t Information: 1220 :  10|12:05:34.2039|||	https://imfxv3tm.tmd.tv/AmazonLabs/ |TEST HOUSE| False  
t Information: 1220 :  10|12:05:34.2039|||	SolrConnectionUms, default: http://192.168.120.14:8983/solr, value: http://192.168.120.14:8983/solr.
t Information: 1220 :  10|12:05:34.2039|||	LogWebApi, default: false, value: false.
t Information: 1220 :  10|12:05:34.2039|||	EmbeddedRceUrl, default: , value: .
t Information: 1220 :  10|12:05:34.2039|||	InstallMode, default: , value: .
t Information: 1220 :  10|12:05:34.2039|||	SamlRequestAddress, default: , value: .
t Information: 1220 :  10|12:05:34.2039|||	SamlTrustedIssuer, default: , value: .
t Information: 1220 :  10|12:05:34.2039|||	SamlLoginRedirect, default: , value: .
t Information: 1220 :  10|12:05:34.2039|||	NaturalLangSearch, default: false, value: True.
t Information: 1220 :  10|12:05:34.2039|||	LocalUploadExpirationHours, default: 0, value: 0.
t Information: 1220 :  10|12:05:34.2039|||	OktaLoginField, default: , value: .
t Information: 1220 :  10|12:05:34.2039|||	AuthenticationTypes, default: , value: Native,PublicApiKey.
t Information: 1220 :  10|12:05:34.2039|||OrabitWatcherBasic. Initialize.
t Information: 1220 :  10|12:05:34.2039|||FillDictionaryCache.
t Information: 1220 :  10|12:05:37.7664|||GetSupportedOperators
t Information: 1220 :  10|12:05:37.9695|||CacheTechReports.
t Information: 1220 :  10|12:05:37.9695|||& Cache update. Server (global) filled with timestamp 12:06:37.9539073. types null
t Information: 1220 :  10|12:05:37.9695|||InitializeFromDatabase.
  'Server=TECHM;User Id=imfx;password=..;Unicode=true;'
  direct False, home , timeout 15
t Information: 1220 :  10|12:05:38.1883|||FillDictionaryCache.
t Information: 1220 :  10|12:05:38.1883|||& Cache update. Server (global) filled with timestamp 12:06:38.0164101. types FriendlyNames, DatabaseSearchFieldData
t Information: 1220 :  10|12:05:38.7976|||==========================================================================
t Information: 1220 :  10|12:05:38.7976|||IMFX CORE SERVER APPLICATION START.
t Information: 1220 :  10|12:05:38.7976|||DLL VERSION: 2.5.0.2780.
t Information: 1220 :  10|12:05:38.7976|||IS TIMER HIGH RESOULTION : True.
t Information: 1220 :  10|12:05:38.7976|||	UmsDev, default: False, value: False.
t Information: 1220 :  10|12:05:39.2039|||OrabitWatcherBasic trying to connect..
t Information: 1220 :  10|12:05:39.2039|||OrabitWatcherBasic connected.
t Information: 1220 :  10|12:05:39.2039|||OrabitWatcherBasic queue created tmd.cfg.in.a162c879-c5ba-46e2-ae40-a0c7d6d66a0a
t Transfer: 1220 :     10|12:05:41.4382|Pl9eOU|DANIEL|OAuth: /api/v3/title/293744/versions?_dc=1592219141094
t Transfer: 1220 :     10|12:05:41.4382|hKtxpm|DANIEL|OAuth: /api/v3/title/278626/versions?_dc=1592219140625
t Transfer: 1220 :     10|12:05:41.4382|Pl9eOU|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|12:05:41.4382|Pl9eOU|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|12:05:41.4382|hKtxpm|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|12:05:41.4382|hKtxpm|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|12:05:41.4382|Pl9eOU|DANIEL|    user DANIEL.
t Transfer: 1220 :     10|12:05:41.4382|hKtxpm|DANIEL|    user DANIEL.
t Verbose: 1220 :      10|12:05:41.4382|Pl9eOU|DANIEL|OAuth. User logged in: DANIEL
t Verbose: 1220 :      10|12:05:41.4382|hKtxpm|DANIEL|OAuth. User logged in: DANIEL
t Information: 1220 :  10|12:05:41.6414|Pl9eOU|DANIEL|V3Api.SearchGeneric
t Information: 1220 :  10|12:05:41.6414|hKtxpm|DANIEL|V3Api.SearchGeneric
t Transfer: 1220 :     10|12:05:41.6414|hKtxpm|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|12:05:41.6414|hKtxpm|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|12:05:41.6414|Pl9eOU|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|12:05:41.6414|hKtxpm|DANIEL|    user DANIEL.
t Transfer: 1220 :     10|12:05:41.6414|Pl9eOU|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|12:05:41.6414|Pl9eOU|DANIEL|    user DANIEL.
t Transfer: 1220 :     10|12:05:41.8445|Pl9eOU|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|12:05:41.8445|Pl9eOU|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|12:05:41.8445|Pl9eOU|DANIEL|    user DANIEL.
t Transfer: 1220 :     10|12:05:41.8445|hKtxpm|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|12:05:41.8445|hKtxpm|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|12:05:41.8445|hKtxpm|DANIEL|    user DANIEL.
t Information: 1220 :  10|12:05:41.8445|Pl9eOU|DANIEL|SearchVersion SQL:
 select * from (select a.*, rownum rnum  from ( select  m.*, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE,  nvl(t.text_id,-1) THUMBID, BUILD_PGRL_FULLTITLE(item_type, title, ser_name, ser_title) FULLTITLE     from tmddba.tm_pg_rl m 
        left outer join (select text_id, text_data_path, text_data_filename, text_ref_object from tmddba.tm_text) t on t.text_id = m.primary_thumb_id
 where item_type>0 and rl_deleted=0  and m.PGM_ABS_ID=293744 
 order by m.title,m.id) a where rownum <= 9999) r where rnum >=1 order by rnum
t Information: 1220 :  10|12:05:41.8445|hKtxpm|DANIEL|SearchVersion SQL:
 select * from (select a.*, rownum rnum  from ( select  m.*, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE,  nvl(t.text_id,-1) THUMBID, BUILD_PGRL_FULLTITLE(item_type, title, ser_name, ser_title) FULLTITLE     from tmddba.tm_pg_rl m 
        left outer join (select text_id, text_data_path, text_data_filename, text_ref_object from tmddba.tm_text) t on t.text_id = m.primary_thumb_id
 where item_type>0 and rl_deleted=0  and m.PGM_ABS_ID=278626 
 order by m.title,m.id) a where rownum <= 9999) r where rnum >=1 order by rnum
t Information: 1220 :  10|12:05:41.8445|hKtxpm|DANIEL|Running version search. User: 342    Simple Search: 
Running Oracle search.
Running Oracle search for COUNT
Oracle count completed in: 18ms.  Returned lines: 0

t Verbose: 1220 :      10|12:05:41.8445|hKtxpm|DANIEL|imfx v3 API took 0.143s '/api/v3/title/278626/versions?_dc=1592219140625'
t Information: 1220 :  10|12:05:41.8445|Pl9eOU|DANIEL|Running version search. User: 342    Simple Search: 
Running Oracle search.
Running Oracle search for COUNT
Oracle count completed in: 9ms.  Returned lines: 1
Oracle version search timing: 99ms.
SQL run:
 select * from (select a.*, rownum rnum  from ( select  m.*, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE,  nvl(t.text_id,-1) THUMBID, BUILD_PGRL_FULLTITLE(item_type, title, ser_name, ser_title) FULLTITLE     from tmddba.tm_pg_rl m 
        left outer join (select text_id, text_data_path, text_data_filename, text_ref_object from tmddba.tm_text) t on t.text_id = m.primary_thumb_id
 where item_type>0 and rl_deleted=0  and m.PGM_ABS_ID=293744 
 order by m.title,m.id) a where rownum <= 9999) r where rnum >=1 order by rnum

t Verbose: 1220 :      10|12:05:41.8445|Pl9eOU|DANIEL|imfx v3 API took 0.205s '/api/v3/title/293744/versions?_dc=1592219141094'
t Transfer: 1220 :     10|12:05:42.2508|OlbHvi|DANIEL|OAuth: /api/v3/version/293745/media?_dc=1592219150548
t Transfer: 1220 :     10|12:05:42.2508|OlbHvi|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|12:05:42.2508|OlbHvi|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|12:05:42.2508|OlbHvi|DANIEL|    user DANIEL.
t Verbose: 1220 :      10|12:05:42.2508|OlbHvi|DANIEL|OAuth. User logged in: DANIEL
t Information: 1220 :  10|12:05:42.2508|OlbHvi|DANIEL|V3Api.SearchGeneric
t Transfer: 1220 :     10|12:05:42.2508|OlbHvi|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|12:05:42.2508|OlbHvi|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|12:05:42.2508|OlbHvi|DANIEL|    user DANIEL.
t Information: 1220 :  10|12:05:42.2508|OlbHvi|DANIEL|MediaSearch SQL:
select r.*,
    nvl((select TMD_STR_AGG(c.u_id_pfix ) from tm_ctnrs c, tm_mi_tpi_lnx l where l.miid=r.id and c.u_id=l.tpiid and r.media_type=1),'') BARCODE,
    nvl(lnk.lib_loc_ext_id,0) lib_loc_ext_id, nvl(lnk.ctnr_loan_stat,0) ctnr_loan_status, nvl(lnk.ctnr_stat,0) ctnr_stat,
    nvl(t.text_data_path,'') THUMBSERVER, 
    nvl(t.text_data_filename,'') THUMBFILE,
    nvl(t.text_id,-1) THUMBID , 
    GETMEDIALOC(r.id, r.media_type, r.compil, r.m_ctnr_int_o_loc, r.m_ctnr_ext_o_loc, r.m_ctnr_loc) LOCATION,
    nvl(dfl.fSOM,0) FILE_SOM, nvl(dfl.fEOM,0) FILE_EOM, dfl.fos_fname FILENAME, dfl.DFILE_LINK_GUID, dfl.OS_GUID, dfl.SUB_FOLDER, dfl.ORIGINAL_FILENAME 

    from (select a.*, rownum rnum from 
      (select  m.*,
     coalesce(m.primary_thumb_id, (select v.primary_thumb_id from tm_pg_rl v where v.id=m.pgm_parent_id)) primary_thumb_id2 
      from tmddba.tm_mis m 
 where media_type>0 and item_type>0  AND  PGM_PARENT_ID=:pgm_parent_id_1  and m.mi_deleted=0  
 order by upper(m.title), m.media_type, m.ec_som, m.id ) a where rownum <= 50) r 
    ,lateral( select l.miid, max(c.C_EXT_OUT_LOC) lib_loc_ext_id, max(c.C_STAT) ctnr_stat, max(c.loan_stat) ctnr_loan_stat  from tm_mi_tpi_lnx l, tm_ctnrs c where c.u_id=l.tpiid and l.miid=r.id and r.media_type=1 group by l.miid)(+) lnk 
    ,lateral(select tt.* from tm_text tt where tt.text_id = r.primary_thumb_id2)(+) t
    ,lateral(select /*+ NO_DECORRELATE */  d.som fsom, d.eom feom, dl.mi_id fmi_id, d.os_fname fos_fname, d.DFILE_LINK_GUID, d.OS_GUID, d.SUB_FOLDER, dl.dfile_id, d.original_filename
        FROM tm_dfile d, tm_mi_dfile_lnx dl where d.id=dl.dfile_id and r.id=dl.mi_id and rownum=1)(+) dfl 
    
    where rnum >= 1 order by rnum
Param: pgm_parent_id_1: 293745
t Information: 1220 :  10|12:05:42.4538|OlbHvi|DANIEL|    timing: 00:00:00.2056799
t Verbose: 1220 :      10|12:05:42.4538|OlbHvi|DANIEL|imfx v3 API took 0.231s '/api/v3/version/293745/media?_dc=1592219150548'
t Transfer: 1220 :     10|12:05:42.6570|OlbHvi|DANIEL|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\gotspecialspromo10secaction.mp4 subfolder 
t Transfer: 1220 :     10|12:05:42.6570|OlbHvi|DANIEL|  GetFileName result https://imfxv3tm.tmd.tv/VideoServer/gotspecialspromo10secaction.mp4
t Transfer: 1220 :     10|12:05:42.6570|OlbHvi|DANIEL|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/gotspecialspromo10secaction.mp4
t Transfer: 1220 :     10|12:05:42.6570|OlbHvi|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|12:05:42.6570|OlbHvi|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|12:05:42.6570|OlbHvi|DANIEL|    user DANIEL.
t Transfer: 1220 :     10|12:05:42.6570|OlbHvi|DANIEL|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\gotspecialspromo20seccharacter.mp4 subfolder 
t Transfer: 1220 :     10|12:05:42.6570|OlbHvi|DANIEL|  GetFileName result https://imfxv3tm.tmd.tv/VideoServer/gotspecialspromo20seccharacter.mp4
t Transfer: 1220 :     10|12:05:42.6570|OlbHvi|DANIEL|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/gotspecialspromo20seccharacter.mp4
t Transfer: 1220 :     10|12:05:42.6570|OlbHvi|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|12:05:42.6570|OlbHvi|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|12:05:42.6570|OlbHvi|DANIEL|    user DANIEL.
t Transfer: 1220 :     10|12:05:42.6570|OlbHvi|DANIEL|GetUrl. Storage |Image| filename \\192.168.120.254\DemoFS\Digital Assets\Image\gotspecialspromosimage.jpg subfolder 
t Transfer: 1220 :     10|12:05:42.6570|OlbHvi|DANIEL|  GetFileName result https://imfxv3tm.tmd.tv/ImageServer/gotspecialspromosimage.jpg
t Transfer: 1220 :     10|12:05:42.6570|OlbHvi|DANIEL|GetUrl. result https://imfxv3tm.tmd.tv/ImageServer/gotspecialspromosimage.jpg
t Transfer: 1220 :     10|12:05:42.6570|OlbHvi|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|12:05:42.6570|OlbHvi|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|12:05:42.6570|OlbHvi|DANIEL|    user DANIEL.
t Transfer: 1220 :     10|12:05:42.6570|OlbHvi|DANIEL|GetUrl. Storage |TEMP_UPLOAD| filename \\192.168.120.254\DemoFS\Digital Assets\TEMP_UPLOAD\68add84afa7b\Animation Sample1.mp4 subfolder 68add84afa7b\
t Transfer: 1220 :     10|12:05:42.6570|OlbHvi|DANIEL|  GetFileName result https://demo.tmd.tv/Temp Upload/Animation%20Sample1.mp4
t Transfer: 1220 :     10|12:05:42.6570|OlbHvi|DANIEL|GetUrl. result https://demo.tmd.tv/Temp Upload/Animation%20Sample1.mp4
t Transfer: 1220 :     10|12:05:42.6570|OlbHvi|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|12:05:42.6570|OlbHvi|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|12:05:42.6570|OlbHvi|DANIEL|    user DANIEL.
t Transfer: 1220 :     10|12:05:42.6570|OlbHvi|DANIEL|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Example 06052020.mp4 subfolder 
t Transfer: 1220 :     10|12:05:42.6570|OlbHvi|DANIEL|  GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Example%2006052020.mp4
t Transfer: 1220 :     10|12:05:42.6570|OlbHvi|DANIEL|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/Example%2006052020.mp4
t Transfer: 1220 :     10|12:05:42.6570|OlbHvi|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|12:05:42.6570|OlbHvi|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|12:05:42.6570|OlbHvi|DANIEL|    user DANIEL.
t Transfer: 1220 :     10|12:05:42.6570|OlbHvi|DANIEL|GetUrl. Storage |Audio| filename \\192.168.120.254\DemoFS\Digital Assets\Audio\PMH_portugese - Copy.wav subfolder 
t Transfer: 1220 :     10|12:05:42.6570|OlbHvi|DANIEL|  GetFileName result https://imfxv3tm.tmd.tv/AudioServer/PMH_portugese%20-%20Copy.wav
t Transfer: 1220 :     10|12:05:42.6570|OlbHvi|DANIEL|GetUrl. result https://imfxv3tm.tmd.tv/AudioServer/PMH_portugese%20-%20Copy.wav
t Transfer: 1220 :     10|12:05:42.6570|OlbHvi|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|12:05:42.6570|OlbHvi|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|12:05:42.6570|OlbHvi|DANIEL|    user DANIEL.
t Transfer: 1220 :     10|12:05:42.6570|OlbHvi|DANIEL|GetUrl. Storage |Audio| filename \\192.168.120.254\DemoFS\Digital Assets\Audio\gotspecialspromosaudio.wav subfolder 
t Transfer: 1220 :     10|12:05:42.6570|OlbHvi|DANIEL|  GetFileName result https://imfxv3tm.tmd.tv/AudioServer/gotspecialspromosaudio.wav
t Transfer: 1220 :     10|12:05:42.6570|OlbHvi|DANIEL|GetUrl. result https://imfxv3tm.tmd.tv/AudioServer/gotspecialspromosaudio.wav
t Transfer: 1220 :     10|12:05:42.6570|OlbHvi|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|12:05:42.6570|OlbHvi|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|12:05:42.6570|OlbHvi|DANIEL|    user DANIEL.
t Transfer: 1220 :     10|12:05:48.3445|wrgHMM|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|12:05:48.3445|wrgHMM|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|12:05:48.3445|wrgHMM|DANIEL|    user DANIEL.
t Transfer: 1220 :     10|12:05:48.3445|hgqiO7|DANIEL|OAuth: /api/view/info/Job?lang=en-GB&_dc=1592219156800
t Transfer: 1220 :     10|12:05:48.3445|hgqiO7|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|12:05:48.3445|hgqiO7|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|12:05:48.3445|hgqiO7|DANIEL|    user DANIEL.
t Verbose: 1220 :      10|12:05:48.3445|hgqiO7|DANIEL|OAuth. User logged in: DANIEL
t Information: 1220 :  10|12:05:48.3445|hgqiO7|DANIEL|GetGridViewBuilder. builder type Job.
t Transfer: 1220 :     10|12:05:48.3445|hgqiO7|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|12:05:48.3445|hgqiO7|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|12:05:48.3445|hgqiO7|DANIEL|    user DANIEL.
t Information: 1220 :  10|12:05:48.3445|hgqiO7|DANIEL|UserGridView. LoadView. ID 862, Name Default.
t Transfer: 1220 :     10|12:05:48.3445|hgqiO7|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|12:05:48.3445|hgqiO7|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|12:05:48.3445|hgqiO7|DANIEL|    user DANIEL.
t Transfer: 1220 :     10|12:05:48.3445|hgqiO7|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|12:05:48.3445|hgqiO7|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|12:05:48.3445|hgqiO7|DANIEL|    user DANIEL.
t Verbose: 1220 :      10|12:05:48.5476|hgqiO7|DANIEL|imfx v3 API took 0.032s '/api/view/info/Job?lang=en-GB&_dc=1592219156800'
t Transfer: 1220 :     10|12:05:48.5476|hY2Nuy|DANIEL|OAuth: /api/v3/search/workflow/media?_dc=1592219156856
t Transfer: 1220 :     10|12:05:48.5476|hY2Nuy|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|12:05:48.5476|hY2Nuy|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|12:05:48.5476|hY2Nuy|DANIEL|    user DANIEL.
t Verbose: 1220 :      10|12:05:48.5476|hY2Nuy|DANIEL|OAuth. User logged in: DANIEL
t Information: 1220 :  10|12:05:48.5476|hY2Nuy|DANIEL|V3Api.SearchWorkflowsWithMedia
t Transfer: 1220 :     10|12:05:48.5476|hY2Nuy|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|12:05:48.5476|hY2Nuy|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|12:05:48.5476|hY2Nuy|DANIEL|    user DANIEL.
t Information: 1220 :  10|12:05:48.7507|hY2Nuy|DANIEL|SearchJob SQL:
 select * from (select a.*, rownum rnum  from ( select  /*+ INDEX(j JB_CMBST_IDX) */ j.*
    ,p.pname
    ,mi.tv_std
    ,mi.MIID1, mi.MIID2, mi.MIID3, mi.VERSIONID1, mi.VERSIONID2, mi.PROGID1, mi.PROGID2 
    ,txd.NEXT_TX_DATE
  FROM tm_mjob j 
    left join tm_mjob_pset p on j.j_sched_indx=p.id
    left join (select  j_id, TMD_str_agg(distinct miid1) MIID1, TMD_str_agg(distinct miid2) MIID2, TMD_str_agg(distinct miid3) MIID3, TMD_str_agg(distinct versionid1) VERSIONID1, TMD_str_agg(distinct versionid2) VERSIONID2, TMD_str_agg(distinct progid1) PROGID1, TMD_str_agg(distinct progid2) PROGID2, TMD_str_agg(distinct m.tv_std) TV_STD from tm_mis m, tm_mtsk_it i 
      where m.id=i.mi_id and i.src_dest in (2,3) group by j_id) mi on mi.j_id=j.id 
    LEFT JOIN (
        SELECT it.j_id, min(sch.tx_tm_st) NEXT_TX_DATE FROM TM_MTSK_IT it, TM_MIS m, hr_sched sch
          WHERE m.id = it.MI_ID AND (sch.prod_num = m.PROGID2 OR sch.prod_num = (select rl.VERSIONID1 from TM_PG_RL rl where rl.ID = m.PGM_PARENT_ID)) AND sch.tx_tm_st > sysdate
            GROUP BY J_ID) txd ON txd.j_id = j.id 
   where 1=1  AND   j.id in (
    select v.id from TM_MJOB v
      where v.id in (
        select t.j_id from TM_MTSK_IT t where t.mi_id in (293746) and t.src_dest in (2, 3)
        UNION
        select m.cret_job from TM_MIS m where m.id in (293746)) and (v.cmb_stat not in (15, 18, 19, 23) or (v.CMB_STAT = 19 and v.J_FAILURE_RESOLVED = 0)
      )
    )
   and  j.cmb_stat not in (15,18,23)    order by j.J_COMPL_BY, j.id desc, j.id ) a where rownum <= 50) where rnum >= 1 order by rnum
t Information: 1220 :  10|12:05:49.1570|hY2Nuy|DANIEL|    jobs returned 5, searched in 00:00:00.4538628
t Information: 1220 :  10|12:05:49.1570|hY2Nuy|DANIEL|TechReports is not found. ID: 96.
t Information: 1220 :  10|12:05:49.1570|hY2Nuy|DANIEL|TechReports is not found. ID: 41.
t Information: 1220 :  10|12:05:49.1570|hY2Nuy|DANIEL|TechReports is not found. ID: 116.
t Information: 1220 :  10|12:05:49.1570|hY2Nuy|DANIEL|TechReports is not found. ID: 672.
t Information: 1220 :  10|12:05:49.1570|hY2Nuy|DANIEL|TechReports is not found. ID: 27.
t Information: 1220 :  10|12:05:49.1570|hY2Nuy|DANIEL|    tasks returned 5, searched in 00:00:00.0706811
t Verbose: 1220 :      10|12:05:49.1570|hY2Nuy|DANIEL|imfx v3 API took 0.661s '/api/v3/search/workflow/media?_dc=1592219156856'
t Transfer: 1220 :     10|12:05:49.7663|ezmVXd|DANIEL|OAuth: /api/v3/search/workflow/media?_dc=1592219158177
t Transfer: 1220 :     10|12:05:49.7663|ezmVXd|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|12:05:49.7663|ezmVXd|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|12:05:49.7663|ezmVXd|DANIEL|    user DANIEL.
t Verbose: 1220 :      10|12:05:49.7663|ezmVXd|DANIEL|OAuth. User logged in: DANIEL
t Information: 1220 :  10|12:05:49.7663|ezmVXd|DANIEL|V3Api.SearchWorkflowsWithMedia
t Transfer: 1220 :     10|12:05:49.7663|ezmVXd|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|12:05:49.7663|ezmVXd|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|12:05:49.7663|ezmVXd|DANIEL|    user DANIEL.
t Information: 1220 :  10|12:05:49.9694|ezmVXd|DANIEL|SearchJob SQL:
 select * from (select a.*, rownum rnum  from ( select  /*+ INDEX(j JB_CMBST_IDX) */ j.*
    ,p.pname
    ,mi.tv_std
    ,mi.MIID1, mi.MIID2, mi.MIID3, mi.VERSIONID1, mi.VERSIONID2, mi.PROGID1, mi.PROGID2 
    ,txd.NEXT_TX_DATE
  FROM tm_mjob j 
    left join tm_mjob_pset p on j.j_sched_indx=p.id
    left join (select  j_id, TMD_str_agg(distinct miid1) MIID1, TMD_str_agg(distinct miid2) MIID2, TMD_str_agg(distinct miid3) MIID3, TMD_str_agg(distinct versionid1) VERSIONID1, TMD_str_agg(distinct versionid2) VERSIONID2, TMD_str_agg(distinct progid1) PROGID1, TMD_str_agg(distinct progid2) PROGID2, TMD_str_agg(distinct m.tv_std) TV_STD from tm_mis m, tm_mtsk_it i 
      where m.id=i.mi_id and i.src_dest in (2,3) group by j_id) mi on mi.j_id=j.id 
    LEFT JOIN (
        SELECT it.j_id, min(sch.tx_tm_st) NEXT_TX_DATE FROM TM_MTSK_IT it, TM_MIS m, hr_sched sch
          WHERE m.id = it.MI_ID AND (sch.prod_num = m.PROGID2 OR sch.prod_num = (select rl.VERSIONID1 from TM_PG_RL rl where rl.ID = m.PGM_PARENT_ID)) AND sch.tx_tm_st > sysdate
            GROUP BY J_ID) txd ON txd.j_id = j.id 
   where 1=1  AND   j.id in (
    select v.id from TM_MJOB v
      where v.id in (
        select t.j_id from TM_MTSK_IT t where t.mi_id in (293746) and t.src_dest in (2, 3)
        UNION
        select m.cret_job from TM_MIS m where m.id in (293746)) and (v.cmb_stat not in (15, 18, 19, 23) or (v.CMB_STAT = 19 and v.J_FAILURE_RESOLVED = 0)
      )
    )
   and  j.cmb_stat not in (15,18,23)    order by j.J_COMPL_BY, j.id desc, j.id ) a where rownum <= 50) where rnum >= 1 order by rnum
t Information: 1220 :  10|12:05:50.3757|ezmVXd|DANIEL|    jobs returned 5, searched in 00:00:00.3937690
t Information: 1220 :  10|12:05:50.3757|ezmVXd|DANIEL|TechReports is not found. ID: 96.
t Information: 1220 :  10|12:05:50.3757|ezmVXd|DANIEL|TechReports is not found. ID: 41.
t Information: 1220 :  10|12:05:50.3757|ezmVXd|DANIEL|TechReports is not found. ID: 116.
t Information: 1220 :  10|12:05:50.3757|ezmVXd|DANIEL|TechReports is not found. ID: 672.
t Information: 1220 :  10|12:05:50.3757|ezmVXd|DANIEL|TechReports is not found. ID: 27.
t Information: 1220 :  10|12:05:50.3757|ezmVXd|DANIEL|    tasks returned 5, searched in 00:00:00.0129991
t Verbose: 1220 :      10|12:05:50.3757|ezmVXd|DANIEL|imfx v3 API took 0.480s '/api/v3/search/workflow/media?_dc=1592219158177'
t Transfer: 1220 :     10|12:05:52.2039|0sISPO|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|12:05:52.2039|0sISPO|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|12:05:52.2039|0sISPO|DANIEL|    user DANIEL.
t Information: 1220 :  10|12:26:33.3442|||OrabitWatcherBasic. Disposing.
t Information: 1220 :  10|12:26:33.3442|||OrabitWatcherBasic. Disposed.
t Information: 1220 :  10|12:26:33.3442|||==========================================================================
t Information: 1220 :  10|12:26:33.3442|||IMFX CORE SERVER APPLICATION END.