t Information: 1220 :   9|15:37:59.9597|||Get Configuration Values:
t Information: 1220 :   9|15:37:59.9597|||	AdminPassEnc, default: , value: ffqjrn0leKv4Lj2YJHe2dw==.
t Information: 1220 :   9|15:37:59.9597|||	EncryptedPasswords, default: false, value: true.
t Information: 1220 :   9|15:37:59.9597|||	OraConnectionString, default: , value: Server=TECHM;User Id=imfx;Password=xxxxx;Unicode=true;.
t Information: 1220 :   9|15:37:59.9597|||	SecondTimezone, default: , value: .
t Information: 1220 :   9|15:37:59.9597|||	UseActiveDirectoryAuth, default: false, value: false.
t Information: 1220 :   9|15:37:59.9597|||	ReportingServiceUrl, default: , value: http://localhost:92/ReportingService.svc.
t Information: 1220 :   9|15:37:59.9753|||	ReportsPath, default: , value: .
t Information: 1220 :   9|15:37:59.9753|||	ReportsURL, default: , value: .
t Information: 1220 :   9|15:37:59.9753|||	TapeServiceUrl, default: , value: .
t Information: 1220 :   9|15:37:59.9753|||	GatekeeperUrl, default: , value: .
t Information: 1220 :   9|15:37:59.9753|||	ValuationUrl, default: , value: .
t Information: 1220 :   9|15:37:59.9753|||	QueueManagerDelay, default: 30, value: 30.
t Information: 1220 :   9|15:37:59.9753|||	QueueManagerFullRefresh, default: 90, value: 90.
t Information: 1220 :   9|15:37:59.9753|||	AudioLoopDuration, default: 0, value: 150.
t Information: 1220 :   9|15:37:59.9753|||	AudioLoopsCount, default: 0, value: 0.
t Information: 1220 :   9|15:37:59.9753|||	PlayerFakeStep, default: 500, value: 500.
t Information: 1220 :   9|15:37:59.9753|||	PlayerForceRatio, default: 0, value: 1.
t Information: 1220 :   9|15:37:59.9753|||	CheckVersionsInProd, default: false, value: True.
t Information: 1220 :   9|15:37:59.9753|||	MaxResults, default: 3000, value: 10000.
t Information: 1220 :   9|15:37:59.9753|||	NetworkRestriction, default: false, value: True.
t Information: 1220 :   9|15:37:59.9753|||	TEReportID, default: 0, value: 0.
t Information: 1220 :   9|15:37:59.9753|||	ClosedCaptionsCache, default: , value: C:\inetpub\wwwroot\imfxcore\timedtextcache\.
t Information: 1220 :   9|15:37:59.9753|||	ClosedCaptionsStorage, default: , value: c:\Mediaflex\subs.
t Information: 1220 :   9|15:37:59.9753|||	TimeCodeFormat, default: , value: pal.
t Information: 1220 :   9|15:37:59.9753|||	RceMediaPath, default: , value: C:\edl\.
t Information: 1220 :   9|15:37:59.9753|||	RceMediaPath, default: , value: C:\edl\.
t Information: 1220 :   9|15:37:59.9753|||	RceCsmOutputPath, default: , value: C:\Inetpub\wwwroot\csm\.
t Information: 1220 :   9|15:37:59.9753|||	RceCsmUrl, default: , value: http://localhost/csm/.
t Information: 1220 :   9|15:37:59.9753|||	RceMediaSelection, default: , value: miLinkIdMatch.
t Information: 1220 :   9|15:37:59.9753|||	RequestBrowseJobPresetName, default: , value: .
t Information: 1220 :   9|15:37:59.9753|||	DontExtendDuration, default: false, value: False.
t Information: 1220 :   9|15:37:59.9753|||	V3ConfigUrl, default: , value: .
t Information: 1220 :   9|15:37:59.9753|||	StopWords, default: , value: .
t Information: 1220 :   9|15:37:59.9753|||	MisrTxFormat, default: G, value: G.
t Information: 1220 :   9|15:37:59.9753|||	ApiServer, default: , value: http://192.168.120.10:85.
t Information: 1220 :   9|15:37:59.9753|||	ApiTimeout, default: 120, value: 120.
t Information: 1220 :   9|15:37:59.9753|||	ApiWorkers, default: 10, value: 10.
t Information: 1220 :   9|15:37:59.9753|||	UsePerfCounters, default: false, value: false.
t Information: 1220 :   9|15:37:59.9753|||	StatsdAddress, default: , value: .
t Information: 1220 :   9|15:37:59.9753|||	LogGetCurrentUser, default: true, value: true.
t Information: 1220 :   9|15:37:59.9753|||	LogInternalApi, default: true, value: true.
t Information: 1220 :   9|15:37:59.9753|||	ThumbnailServer, default: , value: .
t Information: 1220 :   9|15:37:59.9753|||	LocationFilter, default: , value: .
t Information: 1220 :   9|15:37:59.9753|||	SvUtilServiceUrl, default: , value: .
t Information: 1220 :   9|15:37:59.9753|||	SolrConnection, default: , value: http://192.168.120.14:8983/solr.
t Information: 1220 :   9|15:37:59.9753|||	UseIndexServerSearch, default: false, value: True.
t Information: 1220 :   9|15:37:59.9753|||	SolrIndexVersion, default: 1, value: 6.
t Information: 1220 :   9|15:37:59.9753|||	SolrConnection, default: , value: http://192.168.120.14:8983/solr.
t Information: 1220 :   9|15:37:59.9753|||	FacetsGroups, default: , value: owners,season_id, series_id,version_key,item_type,media_type,media_format,episode_number.
t Information: 1220 :   9|15:37:59.9753|||	FacetsGroupsVersion, default: , value: owners,season_id, series_id,version_key,episode_number.
t Information: 1220 :   9|15:37:59.9910|||	FacetsGroupsChameleon, default: , value: season_id, series_id,genre,prod_year,version_key.
t Information: 1220 :   9|15:37:59.9910|||	PreviewPreset, default: , value: .
t Information: 1220 :   9|15:37:59.9910|||	DevMode, default: false, value: false.
t Information: 1220 :   9|15:37:59.9910|||	DisableSysMan, default: false, value: false.
t Information: 1220 :   9|15:37:59.9910|||	TimeCodeFormat, default: , value: pal.
t Information: 1220 :   9|15:37:59.9910|||	FileCatalystStorageDevice, default: , value: .
t Information: 1220 :   9|15:37:59.9910|||	UseResponsibilityTracking, default: true, value: True.
t Information: 1220 :   9|15:37:59.9910|||	SubtitleDeviceFilter, default: , value: .
t Information: 1220 :   9|15:37:59.9910|||	SystemMonitorNamedPipe, default: , value: .
t Information: 1220 :   9|15:37:59.9910|||	OracleMonitorEnable, default: false, value: False.
t Information: 1220 :   9|15:37:59.9910|||	ArcApiHost, default: , value: .
t Information: 1220 :   9|15:37:59.9910|||	RabbitMqUrl, default: , value: amqp://192.168.120.14:5672.
t Information: 1220 :   9|15:37:59.9910|||	SolrTimedTextSearch, default: false, value: false.
t Information: 1220 :   9|15:37:59.9910|||	ProductionDurationUsageID, default: 1, value: 1.
t Information: 1220 :   9|15:38:00.1941|||GetStreamServers..
t Information: 1220 :   9|15:38:00.6003|||	https://demo.tmd.tv/CBR Video/ |CBR Video| False  
t Information: 1220 :   9|15:38:00.6003|||	https://demo.tmd.tv/CBR Images/ |CBR Images| False  
t Information: 1220 :   9|15:38:00.6003|||	https://demo.tmd.tv/CBR Audio/ |CBR Audio| False  
t Information: 1220 :   9|15:38:00.6003|||	https://demo.tmd.tv/Temp Upload/ |TEMP_UPLOAD| False  
t Information: 1220 :   9|15:38:00.6003|||	http://localhost:82/images/ |IMAGES| False  
t Information: 1220 :   9|15:38:00.6003|||	http://192.168.91.73/smoothcloud/ |SMOOTH_CLOUD| False  
t Information: 1220 :   9|15:38:00.6003|||	http://192.168.91.73/cloudstore/ |CLOUD_STORE| False  
t Information: 1220 :   9|15:38:00.6003|||	http://192.168.91.73/editsystemin/ |EDIT_SYSTEM_IN| False  
t Information: 1220 :   9|15:38:00.6003|||	http://192.168.91.27:89/APPLEPROXY/ |APPLE_PROXY| False  
t Information: 1220 :   9|15:38:00.6003|||	http://localhost:82/video/ |FILESTORE_VIDEO| False  
t Information: 1220 :   9|15:38:00.6003|||	https://imfxv3tm.tmd.tv/streaming/ |Streaming| False  
t Information: 1220 :   9|15:38:00.6003|||	https://imfxv3tm.tmd.tv/VideoServer/ |Video| False  
t Information: 1220 :   9|15:38:00.6003|||	https://imfxv3tm.tmd.tv/AdobeIn/ |Adobe Premiere Pro In| False  
t Information: 1220 :   9|15:38:00.6003|||	https://imfxv3tm.tmd.tv/AudioServer/ |Audio| False  
t Information: 1220 :   9|15:38:00.6003|||	https://imfxv3tm.tmd.tv/ImageServer/ |Image| False  
t Information: 1220 :   9|15:38:00.6003|||	https://imfxv3tm.tmd.tv/DocsServer/ |Docs| False  
t Information: 1220 :   9|15:38:00.6003|||	https://imfxv3tm.tmd.tv/AmazonLabs/ |TEST HOUSE| False  
t Information: 1220 :   9|15:38:00.6003|||	SolrConnectionUms, default: http://192.168.120.14:8983/solr, value: http://192.168.120.14:8983/solr.
t Information: 1220 :   9|15:38:00.6003|||	LogWebApi, default: false, value: false.
t Information: 1220 :   9|15:38:00.6003|||	EmbeddedRceUrl, default: , value: .
t Information: 1220 :   9|15:38:00.6003|||	InstallMode, default: , value: .
t Information: 1220 :   9|15:38:00.6003|||	SamlRequestAddress, default: , value: .
t Information: 1220 :   9|15:38:00.6003|||	SamlTrustedIssuer, default: , value: .
t Information: 1220 :   9|15:38:00.6003|||	SamlLoginRedirect, default: , value: .
t Information: 1220 :   9|15:38:00.6003|||	NaturalLangSearch, default: false, value: True.
t Information: 1220 :   9|15:38:00.6003|||	OktaLoginField, default: , value: .
t Information: 1220 :   9|15:38:00.6003|||	AuthenticationTypes, default: , value: Native,PublicApiKey.
t Information: 1220 :   9|15:38:00.6003|||OrabitWatcherBasic. Initialize.
t Information: 1220 :   9|15:38:00.6003|||FillDictionaryCache.
t Information: 1220 :   9|15:38:03.9129|||GetSupportedOperators
t Information: 1220 :   9|15:38:04.3347|||CacheTechReports.
t Information: 1220 :   9|15:38:04.3347|||& Cache update. Server (global) filled with timestamp 03:04:04.2566623. types null
t Information: 1220 :   9|15:38:04.3347|||InitializeFromDatabase.
  'Server=TECHM;User Id=imfx;password=..;Unicode=true;'
  direct False, home , timeout 15
t Information: 1220 :   9|15:38:04.3347|||FillDictionaryCache.
t Information: 1220 :   9|15:38:04.3347|||& Cache update. Server (global) filled with timestamp 03:04:04.2722844. types FriendlyNames, DatabaseSearchFieldData
t Information: 1220 :   9|15:38:04.9441|||==========================================================================
t Information: 1220 :   9|15:38:04.9441|||IMFX CORE SERVER APPLICATION START.
t Information: 1220 :   9|15:38:04.9441|||DLL VERSION: 2.5.0.2610.
t Information: 1220 :   9|15:38:04.9441|||IS TIMER HIGH RESOULTION : True.
t Information: 1220 :   9|15:38:04.9441|||	UmsDev, default: False, value: False.
t Information: 1220 :   9|15:38:05.5535|||OrabitWatcherBasic trying to connect..
t Information: 1220 :   9|15:38:05.5535|||OrabitWatcherBasic connected.
t Information: 1220 :   9|15:38:05.5535|||OrabitWatcherBasic queue created tmd.cfg.in.5f908275-bbce-4a17-96e9-b62e87c6eb48
t Information: 1220 :   9|15:38:07.3973|1QqhYK|DANIEL|GetUserProfile. Id: 30000
t Transfer: 1220 :      9|15:38:07.3973|1QqhYK|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|15:38:07.3973|1QqhYK|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|15:38:07.3973|1QqhYK|DANIEL|    user DANIEL.
t Transfer: 1220 :      9|15:38:26.3035|X4808t|DANIEL|OAuth: /api/settings/user/uploadSettings?_dc=1585751906250
t Transfer: 1220 :      9|15:38:26.3035|X4808t|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|15:38:26.3035|X4808t|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|15:38:26.3035|X4808t|DANIEL|    user DANIEL.
t Verbose: 1220 :       9|15:38:26.3035|X4808t|DANIEL|OAuth. User logged in: DANIEL
t Transfer: 1220 :      9|15:38:26.3035|X4808t|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|15:38:26.3035|X4808t|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|15:38:26.3035|X4808t|DANIEL|    user DANIEL.
t Verbose: 1220 :       9|15:38:26.3035|X4808t|DANIEL|imfx v3 API took 0.012s '/api/settings/user/uploadSettings?_dc=1585751906250'
t Information: 1220 :   9|15:38:27.1160|lW_o5m|DANIEL|GetUserProfile. Id: 0
t Transfer: 1220 :      9|15:38:27.1160|lW_o5m|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|15:38:27.1160|lW_o5m|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|15:38:27.1160|lW_o5m|DANIEL|    user DANIEL.
t Transfer: 1220 :      9|15:38:28.3347|nRVNoz|DANIEL|OAuth: /api/view/searchinfo/Job?_dc=1585751908218
t Transfer: 1220 :      9|15:38:28.3347|nRVNoz|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|15:38:28.3347|nRVNoz|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|15:38:28.3347|nRVNoz|DANIEL|    user DANIEL.
t Verbose: 1220 :       9|15:38:28.3347|nRVNoz|DANIEL|OAuth. User logged in: DANIEL
t Information: 1220 :   9|15:38:28.3347|nRVNoz|DANIEL|GetAdvSearchColumns. search type Job grid .
t Transfer: 1220 :      9|15:38:28.3347|cl6eFl|DANIEL|OAuth: /api/user-preferences?keys=adv.recent.searches.workflow&_dc=1585751908223
t Transfer: 1220 :      9|15:38:28.3347|cl6eFl|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|15:38:28.3347|cl6eFl|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|15:38:28.3347|cl6eFl|DANIEL|    user DANIEL.
t Verbose: 1220 :       9|15:38:28.3347|cl6eFl|DANIEL|OAuth. User logged in: DANIEL
t Information: 1220 :   9|15:38:28.3347|cl6eFl|DANIEL|GetUserDataByKeys: adv.recent.searches.workflow
t Transfer: 1220 :      9|15:38:28.3347|cl6eFl|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|15:38:28.3347|cl6eFl|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|15:38:28.3347|cl6eFl|DANIEL|    user DANIEL.
t Verbose: 1220 :       9|15:38:28.3347|nRVNoz|DANIEL|imfx v3 API took 0.014s '/api/view/searchinfo/Job?_dc=1585751908218'
t Verbose: 1220 :       9|15:38:28.3347|cl6eFl|DANIEL|imfx v3 API took 0.015s '/api/user-preferences?keys=adv.recent.searches.workflow&_dc=1585751908223'
t Transfer: 1220 :      9|15:38:28.5379|0aeldo|DANIEL|OAuth: /api/view/searches/Job?_dc=1585751908315
t Transfer: 1220 :      9|15:38:28.5379|0aeldo|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|15:38:28.5379|0aeldo|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|15:38:28.5379|0aeldo|DANIEL|    user DANIEL.
t Verbose: 1220 :       9|15:38:28.5379|0aeldo|DANIEL|OAuth. User logged in: DANIEL
t Information: 1220 :   9|15:38:28.5379|0aeldo|DANIEL|GetSavedSearchNames. search type Job.
t Transfer: 1220 :      9|15:38:28.5379|0aeldo|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|15:38:28.5379|0aeldo|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|15:38:28.5379|0aeldo|DANIEL|    user DANIEL.
t Verbose: 1220 :       9|15:38:28.5379|0aeldo|DANIEL|imfx v3 API took 0.016s '/api/view/searches/Job?_dc=1585751908315'
t Transfer: 1220 :      9|15:38:32.3972|aclNEi|DANIEL|OAuth: /api/v3/search/workflow?_dc=1585751912207
t Transfer: 1220 :      9|15:38:32.3972|aclNEi|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|15:38:32.3972|aclNEi|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|15:38:32.3972|aclNEi|DANIEL|    user DANIEL.
t Verbose: 1220 :       9|15:38:32.3972|aclNEi|DANIEL|OAuth. User logged in: DANIEL
t Information: 1220 :   9|15:38:32.3972|aclNEi|DANIEL|V3Api.SearchWorkflows
t Information: 1220 :   9|15:38:32.3972|aclNEi|DANIEL|V3Api.SearchGeneric
t Transfer: 1220 :      9|15:38:32.3972|aclNEi|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|15:38:32.3972|aclNEi|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|15:38:32.3972|aclNEi|DANIEL|    user DANIEL.
t Information: 1220 :   9|15:38:32.3972|aclNEi|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   not ( j.CMB_STAT = 19 and j.J_FAILURE_RESOLVED > 0 )   and j.J_CREATED >= to_date('01/04/2020','DD/MM/YYYY')   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 :   9|15:38:32.3972|aclNEi|DANIEL|    jobs returned 10, searched in 00:00:00.0123640
t Information: 1220 :   9|15:38:32.3972|aclNEi|DANIEL|TechReports is not found. ID: 1300.
t Information: 1220 :   9|15:38:32.3972|aclNEi|DANIEL|TechReports is not found. ID: 672.
t Information: 1220 :   9|15:38:32.3972|aclNEi|DANIEL|TechReports is not found. ID: 116.
t Information: 1220 :   9|15:38:32.3972|aclNEi|DANIEL|TechReports is not found. ID: 41.
t Information: 1220 :   9|15:38:32.3972|aclNEi|DANIEL|TechReports is not found. ID: 673.
t Information: 1220 :   9|15:38:32.3972|aclNEi|DANIEL|TechReports is not found. ID: 1301.
t Information: 1220 :   9|15:38:32.3972|aclNEi|DANIEL|    tasks returned 10, searched in 00:00:00.0221275
t Verbose: 1220 :       9|15:38:32.3972|aclNEi|DANIEL|imfx v3 API took 0.047s '/api/v3/search/workflow?_dc=1585751912207'
t Transfer: 1220 :      9|15:38:32.8035|P4k6~4|DANIEL|OAuth: /api/user-preferences?_dc=1585751912586
t Transfer: 1220 :      9|15:38:32.8035|P4k6~4|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|15:38:32.8035|P4k6~4|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|15:38:32.8035|P4k6~4|DANIEL|    user DANIEL.
t Verbose: 1220 :       9|15:38:32.8035|P4k6~4|DANIEL|OAuth. User logged in: DANIEL
t Verbose: 1220 :       9|15:38:32.8035|P4k6~4|DANIEL|StoreUserDataByKeys..
t Transfer: 1220 :      9|15:38:32.8035|P4k6~4|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|15:38:32.8035|P4k6~4|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|15:38:32.8035|P4k6~4|DANIEL|    user DANIEL.
t Verbose: 1220 :       9|15:38:32.8035|P4k6~4|DANIEL|imfx v3 API took 0.058s '/api/user-preferences?_dc=1585751912586'
t Transfer: 1220 :      9|15:38:37.2723|NTg23c|DANIEL|OAuth: /api/v3/task/componentqc/110186?_dc=1585751917057
t Transfer: 1220 :      9|15:38:37.2723|NTg23c|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|15:38:37.2723|NTg23c|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|15:38:37.2723|NTg23c|DANIEL|    user DANIEL.
t Verbose: 1220 :       9|15:38:37.2723|NTg23c|DANIEL|OAuth. User logged in: DANIEL
t Information: 1220 :   9|15:38:37.2723|NTg23c|DANIEL|V3Api. GetComponentQc task: 110186
t Information: 1220 :   9|15:38:37.4910|NTg23c|DANIEL|SubtitleQcTask. LoadFromDb got Job 110185 and Subtitles 2.
t Information: 1220 :   9|15:38:37.4910|NTg23c|DANIEL|SubtitleQcTask. LoadFromDb processing Media 299079.
t Information: 1220 :   9|15:38:37.4910|NTg23c|DANIEL|SubtitleQcTask. LoadFromDb processing Media 299080.
t Information: 1220 :   9|15:38:37.4910|NTg23c|DANIEL|LoadSubtitlesById. filename MRR28-1.scc device TimedText frame rate Pal
t Information: 1220 :   9|15:38:37.4910|NTg23c|DANIEL|LoadSubtitlesById. Filename: MRR28-1.scc. Device TimedText. Timecode format Pal. Media ID 0.
t Information: 1220 :   9|15:38:37.4910|NTg23c|DANIEL|GetCaptions. Start. Filename: MRR28-1.scc. Cache path C:\inetpub\wwwroot\imfxcore\timedtextcache\. Storage path \\192.168.120.254\DemoFS\Digital Assets\TimedText. Last Modified 1/1/0001 12:00:00 AM
t Information: 1220 :   9|15:38:37.4910|NTg23c|DANIEL|GetCaptions. Convert required. Som 00:00:00. From: \\192.168.120.254\DemoFS\Digital Assets\TimedText\MRR28-1.scc to: C:\inetpub\wwwroot\imfxcore\timedtextcache\MRR28-1.scc_pal_0.xml
t Information: 1220 :   9|15:38:37.4910|NTg23c|DANIEL|GetCaptions. Convertor lock aquired.
t Information: 1220 :   9|15:38:38.1004|NTg23c|DANIEL|GetCaptions. File converted: \\192.168.120.254\DemoFS\Digital Assets\TimedText\MRR28-1.scc. Result: True
t Information: 1220 :   9|15:38:38.1004|NTg23c|DANIEL|GetCaptions. In cache. Filename: C:\inetpub\wwwroot\imfxcore\timedtextcache\MRR28-1.scc_pal_0.xml
t Information: 1220 :   9|15:38:38.1004|NTg23c|DANIEL|LoadSubtitlesById. Convertor lock acquired.
t Information: 1220 :   9|15:38:38.1004|NTg23c|DANIEL|LoadSubtitlesById got 43 lines.
t Information: 1220 :   9|15:38:38.1004|NTg23c|DANIEL|TM_MIS. LoadSubtitles for ID: 299079
t Information: 1220 :   9|15:38:38.1004|NTg23c|DANIEL|TM_MIS. LoadSubtitles for ID: 299079. SQL: 'select id, m_ctnr_id, m_ctnr_loc, modified_dt, tv_std, m_ctnr_fmt_id, 
    nvl((select max(l.language) from tm_audio l where l.miid=m.id),aud_language_id) aud_language_id
  from tm_mis m where m.id in (299080)'
t Information: 1220 :   9|15:38:38.1004|NTg23c|DANIEL|    Subtitles added for ID: 299079, 299080 Unknown [0] : 'https://imfxv3tm.tmd.tv/getcaptions.aspx?f=MRR28-1.scc&som=00:00:00:00&storage=TimedText&modified=637213461660000000&tcf=0&id=299080&tmp=0'.
t Information: 1220 :   9|15:38:38.1004|NTg23c|DANIEL|SubtitleQcTask. LoadFromDb finished.
t Verbose: 1220 :       9|15:38:38.1004|NTg23c|DANIEL|imfx v3 API took 0.973s '/api/v3/task/componentqc/110186?_dc=1585751917057'
t Transfer: 1220 :      9|15:38:38.5066|NTg23c|DANIEL|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\N0001876.mpd subfolder 
t Transfer: 1220 :      9|15:38:38.5066|NTg23c|DANIEL|  GetFileName result https://imfxv3tm.tmd.tv/VideoServer/N0001876.mpd
t Transfer: 1220 :      9|15:38:38.5066|NTg23c|DANIEL|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/N0001876.mpd
t Transfer: 1220 :      9|15:38:38.5066|NTg23c|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|15:38:38.5066|NTg23c|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|15:38:38.5066|NTg23c|DANIEL|    user DANIEL.
t Transfer: 1220 :      9|15:38:38.5066|3DbY8a|DANIEL|OAuth: /api/v3/detailsview/Job/0?lang=en-GB&_dc=1585751918445
t Transfer: 1220 :      9|15:38:38.5066|3DbY8a|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|15:38:38.5066|3DbY8a|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|15:38:38.5066|3DbY8a|DANIEL|    user DANIEL.
t Verbose: 1220 :       9|15:38:38.5066|3DbY8a|DANIEL|OAuth. User logged in: DANIEL
t Verbose: 1220 :       9|15:38:38.7098|3DbY8a|DANIEL|imfx v3 API took 0.041s '/api/v3/detailsview/Job/0?lang=en-GB&_dc=1585751918445'
t Transfer: 1220 :      9|15:38:38.7098|LcL71U|DANIEL|OAuth: /api/v3/layout/default/9?_dc=1585751918550
t Transfer: 1220 :      9|15:38:38.7098|LcL71U|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|15:38:38.7098|LcL71U|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|15:38:38.7098|LcL71U|DANIEL|    user DANIEL.
t Verbose: 1220 :       9|15:38:38.7098|LcL71U|DANIEL|OAuth. User logged in: DANIEL
t Information: 1220 :   9|15:38:38.7098|LcL71U|DANIEL|LoadDefaultDashboard.
t Transfer: 1220 :      9|15:38:38.7098|LcL71U|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|15:38:38.7098|LcL71U|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|15:38:38.7098|LcL71U|DANIEL|    user DANIEL.
t Verbose: 1220 :       9|15:38:38.7098|LcL71U|DANIEL|imfx v3 API took 0.050s '/api/v3/layout/default/9?_dc=1585751918550'
t Transfer: 1220 :      9|15:38:39.3191|lO12DP|DANIEL|OAuth: /api/user-group-preferences?globals=htmlplayerhotkeys,audioOnFrameForward&_dc=1585751919186
t Transfer: 1220 :      9|15:38:39.3191|lO12DP|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|15:38:39.3191|lO12DP|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|15:38:39.3191|lO12DP|DANIEL|    user DANIEL.
t Verbose: 1220 :       9|15:38:39.3191|lO12DP|DANIEL|OAuth. User logged in: DANIEL
t Transfer: 1220 :      9|15:38:39.3191|lO12DP|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|15:38:39.3191|lO12DP|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|15:38:39.3191|lO12DP|DANIEL|    user DANIEL.
t Verbose: 1220 :       9|15:38:39.3191|lO12DP|DANIEL|imfx v3 API took 0.005s '/api/user-group-preferences?globals=htmlplayerhotkeys,audioOnFrameForward&_dc=1585751919186'
t Information: 1220 :   9|15:39:03.6941|X9HbzG|DANIEL|GetUserProfile. Id: 30000
t Transfer: 1220 :      9|15:39:03.6941|X9HbzG|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|15:39:03.6941|X9HbzG|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|15:39:03.6941|X9HbzG|DANIEL|    user DANIEL.
t Transfer: 1220 :      9|15:39:31.9285|Fia6WJ|DANIEL|OAuth: /api/settings/user/uploadSettings?_dc=1585751971662
t Transfer: 1220 :      9|15:39:31.9285|Fia6WJ|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|15:39:31.9285|Fia6WJ|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|15:39:31.9285|Fia6WJ|DANIEL|    user DANIEL.
t Verbose: 1220 :       9|15:39:31.9285|Fia6WJ|DANIEL|OAuth. User logged in: DANIEL
t Transfer: 1220 :      9|15:39:31.9285|Fia6WJ|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|15:39:31.9285|Fia6WJ|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|15:39:31.9285|Fia6WJ|DANIEL|    user DANIEL.
t Verbose: 1220 :       9|15:39:31.9285|Fia6WJ|DANIEL|imfx v3 API took 0.004s '/api/settings/user/uploadSettings?_dc=1585751971662'
t Information: 1220 :   9|15:39:32.5378|3K0bf0|DANIEL|GetUserProfile. Id: 0
t Transfer: 1220 :      9|15:39:32.5378|3K0bf0|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|15:39:32.5378|3K0bf0|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|15:39:32.5378|3K0bf0|DANIEL|    user DANIEL.
t Transfer: 1220 :      9|15:39:34.5691|xgtbbN|DANIEL|OAuth: /api/v3/task/componentqc/110186?_dc=1585751974438
t Transfer: 1220 :      9|15:39:34.5691|xgtbbN|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|15:39:34.5691|xgtbbN|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|15:39:34.5691|xgtbbN|DANIEL|    user DANIEL.
t Verbose: 1220 :       9|15:39:34.5691|xgtbbN|DANIEL|OAuth. User logged in: DANIEL
t Information: 1220 :   9|15:39:34.5691|xgtbbN|DANIEL|V3Api. GetComponentQc task: 110186
t Information: 1220 :   9|15:39:34.5691|xgtbbN|DANIEL|SubtitleQcTask. LoadFromDb got Job 110185 and Subtitles 2.
t Information: 1220 :   9|15:39:34.5691|xgtbbN|DANIEL|SubtitleQcTask. LoadFromDb processing Media 299079.
t Information: 1220 :   9|15:39:34.5691|xgtbbN|DANIEL|SubtitleQcTask. LoadFromDb processing Media 299080.
t Information: 1220 :   9|15:39:34.5691|xgtbbN|DANIEL|LoadSubtitlesById. filename MRR28-1.scc device TimedText frame rate Pal
t Information: 1220 :   9|15:39:34.5691|xgtbbN|DANIEL|LoadSubtitlesById. Filename: MRR28-1.scc. Device TimedText. Timecode format Pal. Media ID 0.
t Information: 1220 :   9|15:39:34.5691|xgtbbN|DANIEL|GetCaptions. Start. Filename: MRR28-1.scc. Cache path C:\inetpub\wwwroot\imfxcore\timedtextcache\. Storage path \\192.168.120.254\DemoFS\Digital Assets\TimedText. Last Modified 1/1/0001 12:00:00 AM
t Information: 1220 :   9|15:39:34.5691|xgtbbN|DANIEL|GetCaptions. Convert required. Som 00:00:00. From: \\192.168.120.254\DemoFS\Digital Assets\TimedText\MRR28-1.scc to: C:\inetpub\wwwroot\imfxcore\timedtextcache\MRR28-1.scc_pal_0.xml
t Information: 1220 :   9|15:39:34.5691|xgtbbN|DANIEL|GetCaptions. Convertor lock aquired.
t Information: 1220 :   9|15:39:34.7878|xgtbbN|DANIEL|GetCaptions. File converted: \\192.168.120.254\DemoFS\Digital Assets\TimedText\MRR28-1.scc. Result: True
t Information: 1220 :   9|15:39:34.7878|xgtbbN|DANIEL|GetCaptions. In cache. Filename: C:\inetpub\wwwroot\imfxcore\timedtextcache\MRR28-1.scc_pal_0.xml
t Information: 1220 :   9|15:39:34.7878|xgtbbN|DANIEL|LoadSubtitlesById. Convertor lock acquired.
t Information: 1220 :   9|15:39:34.7878|xgtbbN|DANIEL|LoadSubtitlesById got 43 lines.
t Information: 1220 :   9|15:39:34.7878|xgtbbN|DANIEL|TM_MIS. LoadSubtitles for ID: 299079
t Information: 1220 :   9|15:39:34.7878|xgtbbN|DANIEL|TM_MIS. LoadSubtitles for ID: 299079. SQL: 'select id, m_ctnr_id, m_ctnr_loc, modified_dt, tv_std, m_ctnr_fmt_id, 
    nvl((select max(l.language) from tm_audio l where l.miid=m.id),aud_language_id) aud_language_id
  from tm_mis m where m.id in (299080)'
t Information: 1220 :   9|15:39:34.7878|xgtbbN|DANIEL|    Subtitles added for ID: 299079, 299080 Unknown [0] : 'https://imfxv3tm.tmd.tv/getcaptions.aspx?f=MRR28-1.scc&som=00:00:00:00&storage=TimedText&modified=637213461660000000&tcf=0&id=299080&tmp=0'.
t Information: 1220 :   9|15:39:34.7878|xgtbbN|DANIEL|SubtitleQcTask. LoadFromDb finished.
t Verbose: 1220 :       9|15:39:34.7878|xgtbbN|DANIEL|imfx v3 API took 0.134s '/api/v3/task/componentqc/110186?_dc=1585751974438'
t Transfer: 1220 :      9|15:39:34.7878|xgtbbN|DANIEL|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\N0001876.mpd subfolder 
t Transfer: 1220 :      9|15:39:34.7878|xgtbbN|DANIEL|  GetFileName result https://imfxv3tm.tmd.tv/VideoServer/N0001876.mpd
t Transfer: 1220 :      9|15:39:34.7878|xgtbbN|DANIEL|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/N0001876.mpd
t Transfer: 1220 :      9|15:39:34.7878|xgtbbN|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|15:39:34.7878|xgtbbN|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|15:39:34.7878|xgtbbN|DANIEL|    user DANIEL.
t Transfer: 1220 :      9|15:39:34.7878|6pGFHB|DANIEL|OAuth: /api/v3/detailsview/Job/0?lang=en-GB&_dc=1585751974675
t Transfer: 1220 :      9|15:39:34.7878|6pGFHB|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|15:39:34.7878|6pGFHB|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|15:39:34.7878|6pGFHB|DANIEL|    user DANIEL.
t Verbose: 1220 :       9|15:39:34.7878|6pGFHB|DANIEL|OAuth. User logged in: DANIEL
t Verbose: 1220 :       9|15:39:34.7878|6pGFHB|DANIEL|imfx v3 API took 0.002s '/api/v3/detailsview/Job/0?lang=en-GB&_dc=1585751974675'
t Transfer: 1220 :      9|15:39:34.9910|QZG8ve|DANIEL|OAuth: /api/v3/layout/default/9?_dc=1585751974782
t Transfer: 1220 :      9|15:39:34.9910|QZG8ve|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|15:39:34.9910|QZG8ve|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|15:39:34.9910|QZG8ve|DANIEL|    user DANIEL.
t Verbose: 1220 :       9|15:39:34.9910|QZG8ve|DANIEL|OAuth. User logged in: DANIEL
t Information: 1220 :   9|15:39:34.9910|QZG8ve|DANIEL|LoadDefaultDashboard.
t Transfer: 1220 :      9|15:39:34.9910|QZG8ve|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|15:39:34.9910|QZG8ve|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|15:39:34.9910|QZG8ve|DANIEL|    user DANIEL.
t Verbose: 1220 :       9|15:39:34.9910|QZG8ve|DANIEL|imfx v3 API took 0.004s '/api/v3/layout/default/9?_dc=1585751974782'
t Transfer: 1220 :      9|15:39:36.2097|eog7f4|DANIEL|OAuth: /api/user-group-preferences?globals=htmlplayerhotkeys,audioOnFrameForward&_dc=1585751976138
t Transfer: 1220 :      9|15:39:36.2097|eog7f4|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|15:39:36.2097|eog7f4|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|15:39:36.2097|eog7f4|DANIEL|    user DANIEL.
t Verbose: 1220 :       9|15:39:36.2097|eog7f4|DANIEL|OAuth. User logged in: DANIEL
t Transfer: 1220 :      9|15:39:36.2097|eog7f4|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|15:39:36.2097|eog7f4|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|15:39:36.2097|eog7f4|DANIEL|    user DANIEL.
t Verbose: 1220 :       9|15:39:36.2097|eog7f4|DANIEL|imfx v3 API took 0.003s '/api/user-group-preferences?globals=htmlplayerhotkeys,audioOnFrameForward&_dc=1585751976138'
t Information: 1220 :   9|15:39:47.7879|5_Vpwp|DANIEL|GetUserProfile. Id: 0
t Transfer: 1220 :      9|15:39:47.7879|5_Vpwp|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|15:39:47.7879|5_Vpwp|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|15:39:47.7879|5_Vpwp|DANIEL|    user DANIEL.
t Transfer: 1220 :      9|15:39:49.0066|E~u~zo|DANIEL|OAuth: /api/settings/user/defaultSearch?_dc=1585751988891
t Transfer: 1220 :      9|15:39:49.0066|E~u~zo|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|15:39:49.0066|E~u~zo|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|15:39:49.0066|E~u~zo|DANIEL|    user DANIEL.
t Verbose: 1220 :       9|15:39:49.0066|E~u~zo|DANIEL|OAuth. User logged in: DANIEL
t Transfer: 1220 :      9|15:39:49.0066|E~u~zo|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|15:39:49.0066|E~u~zo|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|15:39:49.0066|E~u~zo|DANIEL|    user DANIEL.
t Verbose: 1220 :       9|15:39:49.0066|E~u~zo|DANIEL|imfx v3 API took 0.003s '/api/settings/user/defaultSearch?_dc=1585751988891'
t Transfer: 1220 :      9|15:39:49.0066|nmJqNy|DANIEL|OAuth: /api/settings/user/startSearch?_dc=1585751988893
t Transfer: 1220 :      9|15:39:49.0066|nmJqNy|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|15:39:49.0066|nmJqNy|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|15:39:49.0066|nmJqNy|DANIEL|    user DANIEL.
t Verbose: 1220 :       9|15:39:49.0066|nmJqNy|DANIEL|OAuth. User logged in: DANIEL
t Transfer: 1220 :      9|15:39:49.0066|nmJqNy|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|15:39:49.0066|nmJqNy|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|15:39:49.0066|nmJqNy|DANIEL|    user DANIEL.
t Verbose: 1220 :       9|15:39:49.0066|nmJqNy|DANIEL|imfx v3 API took 0.003s '/api/settings/user/startSearch?_dc=1585751988893'
t Transfer: 1220 :      9|15:39:49.0066|gKS35T|DANIEL|OAuth: /api/user-preferences?keys=consumer.recent.data&_dc=1585751988939
t Transfer: 1220 :      9|15:39:49.0066|gKS35T|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|15:39:49.0066|gKS35T|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|15:39:49.0066|gKS35T|DANIEL|    user DANIEL.
t Verbose: 1220 :       9|15:39:49.0066|gKS35T|DANIEL|OAuth. User logged in: DANIEL
t Information: 1220 :   9|15:39:49.0066|gKS35T|DANIEL|GetUserDataByKeys: consumer.recent.data
t Transfer: 1220 :      9|15:39:49.0066|gKS35T|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|15:39:49.0066|gKS35T|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|15:39:49.0066|gKS35T|DANIEL|    user DANIEL.
t Verbose: 1220 :       9|15:39:49.0066|gKS35T|DANIEL|imfx v3 API took 0.006s '/api/user-preferences?keys=consumer.recent.data&_dc=1585751988939'
t Transfer: 1220 :      9|15:39:49.2097|Ub4AL5|DANIEL|OAuth: /api/user-preferences?keys=adv.recent.searches.consumer&_dc=1585751989013
t Transfer: 1220 :      9|15:39:49.2097|Ub4AL5|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|15:39:49.2097|Ub4AL5|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|15:39:49.2097|Ub4AL5|DANIEL|    user DANIEL.
t Verbose: 1220 :       9|15:39:49.2097|Ub4AL5|DANIEL|OAuth. User logged in: DANIEL
t Information: 1220 :   9|15:39:49.2097|Ub4AL5|DANIEL|GetUserDataByKeys: adv.recent.searches.consumer
t Transfer: 1220 :      9|15:39:49.2097|Ub4AL5|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|15:39:49.2097|Ub4AL5|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|15:39:49.2097|Ub4AL5|DANIEL|    user DANIEL.
t Verbose: 1220 :       9|15:39:49.2097|Ub4AL5|DANIEL|imfx v3 API took 0.006s '/api/user-preferences?keys=adv.recent.searches.consumer&_dc=1585751989013'
t Information: 1220 :   9|15:39:49.4129|lLB1rb|DANIEL|GetUserProfile. Id: 0
t Transfer: 1220 :      9|15:39:49.4129|lLB1rb|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|15:39:49.4129|lLB1rb|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|15:39:49.4129|lLB1rb|DANIEL|    user DANIEL.
t Transfer: 1220 :      9|15:39:49.8191|k06FUC|DANIEL|OAuth: /api/settings/user/defaultSearch?_dc=1585751989386
t Transfer: 1220 :      9|15:39:49.8191|k06FUC|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|15:39:49.8191|k06FUC|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|15:39:49.8191|k06FUC|DANIEL|    user DANIEL.
t Verbose: 1220 :       9|15:39:49.8191|k06FUC|DANIEL|OAuth. User logged in: DANIEL
t Transfer: 1220 :      9|15:39:49.8191|k06FUC|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|15:39:49.8191|k06FUC|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|15:39:49.8191|k06FUC|DANIEL|    user DANIEL.
t Transfer: 1220 :      9|15:39:49.8191|A8HFFH|DANIEL|OAuth: /api/settings/user/startSearch?_dc=1585751989387
t Transfer: 1220 :      9|15:39:49.8191|A8HFFH|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|15:39:49.8191|A8HFFH|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|15:39:49.8191|A8HFFH|DANIEL|    user DANIEL.
t Verbose: 1220 :       9|15:39:49.8191|A8HFFH|DANIEL|OAuth. User logged in: DANIEL
t Transfer: 1220 :      9|15:39:49.8191|A8HFFH|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|15:39:49.8191|A8HFFH|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|15:39:49.8191|A8HFFH|DANIEL|    user DANIEL.
t Verbose: 1220 :       9|15:39:49.8191|A8HFFH|DANIEL|imfx v3 API took 0.003s '/api/settings/user/startSearch?_dc=1585751989387'
t Verbose: 1220 :       9|15:39:49.8191|k06FUC|DANIEL|imfx v3 API took 0.004s '/api/settings/user/defaultSearch?_dc=1585751989386'
t Transfer: 1220 :      9|15:39:49.8191|UGCX9c|DANIEL|OAuth: /api/user-preferences?keys=consumer.recent.data&_dc=1585751989656
t Transfer: 1220 :      9|15:39:49.8191|UGCX9c|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|15:39:49.8191|UGCX9c|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|15:39:49.8191|UGCX9c|DANIEL|    user DANIEL.
t Verbose: 1220 :       9|15:39:49.8191|UGCX9c|DANIEL|OAuth. User logged in: DANIEL
t Information: 1220 :   9|15:39:49.8191|UGCX9c|DANIEL|GetUserDataByKeys: consumer.recent.data
t Transfer: 1220 :      9|15:39:49.8191|UGCX9c|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|15:39:49.8191|UGCX9c|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|15:39:49.8191|UGCX9c|DANIEL|    user DANIEL.
t Verbose: 1220 :       9|15:39:49.8191|UGCX9c|DANIEL|imfx v3 API took 0.004s '/api/user-preferences?keys=consumer.recent.data&_dc=1585751989656'
t Transfer: 1220 :      9|15:39:49.8191|OzoeG0|DANIEL|OAuth: /api/user-preferences?keys=adv.recent.searches.consumer&_dc=1585751989675
t Transfer: 1220 :      9|15:39:49.8191|OzoeG0|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|15:39:49.8191|OzoeG0|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|15:39:49.8191|OzoeG0|DANIEL|    user DANIEL.
t Verbose: 1220 :       9|15:39:49.8191|OzoeG0|DANIEL|OAuth. User logged in: DANIEL
t Information: 1220 :   9|15:39:49.8191|OzoeG0|DANIEL|GetUserDataByKeys: adv.recent.searches.consumer
t Transfer: 1220 :      9|15:39:49.8191|OzoeG0|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|15:39:49.8191|OzoeG0|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|15:39:49.8191|OzoeG0|DANIEL|    user DANIEL.
t Verbose: 1220 :       9|15:39:49.8191|OzoeG0|DANIEL|imfx v3 API took 0.004s '/api/user-preferences?keys=adv.recent.searches.consumer&_dc=1585751989675'
t Transfer: 1220 :      9|15:39:52.0535|dlvh5N|DANIEL|OAuth: /api/view/searchinfo/Job?_dc=1585751991874
t Transfer: 1220 :      9|15:39:52.0535|dlvh5N|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|15:39:52.0535|dlvh5N|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|15:39:52.0535|dlvh5N|DANIEL|    user DANIEL.
t Verbose: 1220 :       9|15:39:52.0535|dlvh5N|DANIEL|OAuth. User logged in: DANIEL
t Information: 1220 :   9|15:39:52.0535|dlvh5N|DANIEL|GetAdvSearchColumns. search type Job grid .
t Verbose: 1220 :       9|15:39:52.0535|dlvh5N|DANIEL|imfx v3 API took 0.000s '/api/view/searchinfo/Job?_dc=1585751991874'
t Transfer: 1220 :      9|15:39:52.0535|sRqGty|DANIEL|OAuth: /api/user-preferences?keys=adv.recent.searches.workflow&_dc=1585751991880
t Transfer: 1220 :      9|15:39:52.0535|sRqGty|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|15:39:52.0535|sRqGty|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|15:39:52.0535|sRqGty|DANIEL|    user DANIEL.
t Verbose: 1220 :       9|15:39:52.0535|sRqGty|DANIEL|OAuth. User logged in: DANIEL
t Information: 1220 :   9|15:39:52.0535|sRqGty|DANIEL|GetUserDataByKeys: adv.recent.searches.workflow
t Transfer: 1220 :      9|15:39:52.0535|sRqGty|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|15:39:52.0535|sRqGty|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|15:39:52.0535|sRqGty|DANIEL|    user DANIEL.
t Verbose: 1220 :       9|15:39:52.0535|sRqGty|DANIEL|imfx v3 API took 0.004s '/api/user-preferences?keys=adv.recent.searches.workflow&_dc=1585751991880'
t Transfer: 1220 :      9|15:39:52.0535|BENoh4|DANIEL|OAuth: /api/view/searches/Job?_dc=1585751991997
t Transfer: 1220 :      9|15:39:52.0535|BENoh4|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|15:39:52.0535|BENoh4|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|15:39:52.0535|BENoh4|DANIEL|    user DANIEL.
t Verbose: 1220 :       9|15:39:52.0535|BENoh4|DANIEL|OAuth. User logged in: DANIEL
t Information: 1220 :   9|15:39:52.0535|BENoh4|DANIEL|GetSavedSearchNames. search type Job.
t Transfer: 1220 :      9|15:39:52.0535|BENoh4|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|15:39:52.0535|BENoh4|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|15:39:52.0535|BENoh4|DANIEL|    user DANIEL.
t Verbose: 1220 :       9|15:39:52.0535|BENoh4|DANIEL|imfx v3 API took 0.004s '/api/view/searches/Job?_dc=1585751991997'
t Transfer: 1220 :      9|15:39:55.3035|YMudcU|DANIEL|OAuth: /api/v3/search/workflow?_dc=1585751995226
t Transfer: 1220 :      9|15:39:55.3035|YMudcU|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|15:39:55.3035|YMudcU|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|15:39:55.3035|YMudcU|DANIEL|    user DANIEL.
t Verbose: 1220 :       9|15:39:55.3035|YMudcU|DANIEL|OAuth. User logged in: DANIEL
t Information: 1220 :   9|15:39:55.3035|YMudcU|DANIEL|V3Api.SearchWorkflows
t Information: 1220 :   9|15:39:55.3035|YMudcU|DANIEL|V3Api.SearchGeneric
t Transfer: 1220 :      9|15:39:55.3035|YMudcU|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|15:39:55.3035|YMudcU|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|15:39:55.3035|YMudcU|DANIEL|    user DANIEL.
t Information: 1220 :   9|15:39:55.3035|YMudcU|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   not ( j.CMB_STAT = 19 and j.J_FAILURE_RESOLVED > 0 )   and j.J_CREATED >= to_date('01/04/2020','DD/MM/YYYY')   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 :   9|15:39:55.3035|YMudcU|DANIEL|    jobs returned 10, searched in 00:00:00.0102691
t Information: 1220 :   9|15:39:55.3035|YMudcU|DANIEL|TechReports is not found. ID: 1300.
t Information: 1220 :   9|15:39:55.3035|YMudcU|DANIEL|TechReports is not found. ID: 672.
t Information: 1220 :   9|15:39:55.3035|YMudcU|DANIEL|TechReports is not found. ID: 116.
t Information: 1220 :   9|15:39:55.3035|YMudcU|DANIEL|TechReports is not found. ID: 41.
t Information: 1220 :   9|15:39:55.3035|YMudcU|DANIEL|TechReports is not found. ID: 673.
t Information: 1220 :   9|15:39:55.3035|YMudcU|DANIEL|TechReports is not found. ID: 1301.
t Information: 1220 :   9|15:39:55.3035|YMudcU|DANIEL|    tasks returned 10, searched in 00:00:00.0073521
t Verbose: 1220 :       9|15:39:55.3035|YMudcU|DANIEL|imfx v3 API took 0.024s '/api/v3/search/workflow?_dc=1585751995226'
t Transfer: 1220 :      9|15:39:55.5066|MmBqfi|DANIEL|OAuth: /api/user-preferences?_dc=1585751995351
t Transfer: 1220 :      9|15:39:55.5066|MmBqfi|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|15:39:55.5066|MmBqfi|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|15:39:55.5066|MmBqfi|DANIEL|    user DANIEL.
t Verbose: 1220 :       9|15:39:55.5066|MmBqfi|DANIEL|OAuth. User logged in: DANIEL
t Verbose: 1220 :       9|15:39:55.5066|MmBqfi|DANIEL|StoreUserDataByKeys..
t Transfer: 1220 :      9|15:39:55.5066|MmBqfi|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|15:39:55.5066|MmBqfi|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|15:39:55.5066|MmBqfi|DANIEL|    user DANIEL.
t Verbose: 1220 :       9|15:39:55.5066|MmBqfi|DANIEL|imfx v3 API took 0.023s '/api/user-preferences?_dc=1585751995351'
t Transfer: 1220 :      9|15:39:58.5535|T471uz|DANIEL|OAuth: /api/v3/task/componentqc/110182?_dc=1585751998371
t Transfer: 1220 :      9|15:39:58.5535|T471uz|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|15:39:58.5535|T471uz|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|15:39:58.5535|T471uz|DANIEL|    user DANIEL.
t Verbose: 1220 :       9|15:39:58.5535|T471uz|DANIEL|OAuth. User logged in: DANIEL
t Information: 1220 :   9|15:39:58.5535|T471uz|DANIEL|V3Api. GetComponentQc task: 110182
t Information: 1220 :   9|15:39:58.5535|T471uz|DANIEL|SubtitleQcTask. LoadFromDb got Job 110181 and Subtitles 1.
t Verbose: 1220 :       9|15:39:58.5535|T471uz|DANIEL|imfx v3 API took 0.018s '/api/v3/task/componentqc/110182?_dc=1585751998371'
t Information: 1220 :   9|15:39:58.5847|T471uz|DANIEL|V3 Api exception handler: System.Collections.Generic.KeyNotFoundException: The given key was not present in the dictionary.
   at System.Collections.Generic.Dictionary`2.get_Item(TKey key)
   at xMfxModel.TM_MIS.ParseCustomStatuses() in C:\BuildAgent2\work\405c64e443a47d83\Server\xMfxDataLogic\Logic\TM_MIS.cs:line 440
   at xMfxDataLogic.ServiceLogic.Implementation.SubtitlesQcTaskLoad(Decimal taskId) in C:\BuildAgent2\work\405c64e443a47d83\Server\xMfxDataLogic\Logic\ServiceLogic\SubtitleQc.cs:line 68
   at iMfxServerCore.Api.v3.SubtitleQcTaskController.GetComponentQcTask(Int32 id) in C:\BuildAgent2\work\405c64e443a47d83\Server\iMfxServerCore\api\controllers\v3\Tasks\SubtitleQcTaskController.cs:line 44
   at lambda_method(Closure , Object , Object[] )
   at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ActionExecutor.<>c__DisplayClass6_2.<GetExecutor>b__2(Object instance, Object[] methodParameters)
   at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ActionExecutor.Execute(Object instance, Object[] arguments)
   at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ExecuteAsync(HttpControllerContext controllerContext, IDictionary`2 arguments, CancellationToken cancellationToken)
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Web.Http.Controllers.ApiControllerActionInvoker.<InvokeActionAsyncCore>d__1.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Web.Http.Filters.ActionFilterAttribute.<CallOnActionExecutedAsync>d__6.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Web.Http.Filters.ActionFilterAttribute.<CallOnActionExecutedAsync>d__6.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Web.Http.Filters.ActionFilterAttribute.<ExecuteActionFilterAsyncCore>d__5.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Web.Http.Filters.ActionFilterAttribute.<CallOnActionExecutedAsync>d__6.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Web.Http.Filters.ActionFilterAttribute.<CallOnActionExecutedAsync>d__6.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Web.Http.Filters.ActionFilterAttribute.<ExecuteActionFilterAsyncCore>d__5.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Web.Http.Controllers.ActionFilterResult.<ExecuteAsync>d__5.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Web.Http.Filters.AuthorizationFilterAttribute.<ExecuteAuthorizationFilterAsyncCore>d__3.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Web.Http.Controllers.ExceptionFilterResult.<ExecuteAsync>d__6.MoveNext()
  [GET] https://imfxv3tm.tmd.tv/api/v3/task/componentqc/110182?_dc=1585751998371
  System.Web.Http.Routing.HttpRoute
t Information: 1220 :   9|15:40:03.6785|nxdjTs|DANIEL|GetUserProfile. Id: 30000
t Transfer: 1220 :      9|15:40:03.6785|nxdjTs|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|15:40:03.6785|nxdjTs|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|15:40:03.6785|nxdjTs|DANIEL|    user DANIEL.
t Information: 1220 :   9|15:41:05.4285|Dkfk5h|DANIEL|GetUserProfile. Id: 30000
t Transfer: 1220 :      9|15:41:05.4285|Dkfk5h|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|15:41:05.4285|Dkfk5h|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|15:41:05.4285|Dkfk5h|DANIEL|    user DANIEL.
t Transfer: 1220 :      9|15:41:55.8035|ZuI2n1|DANIEL|OAuth: /api/v3/search/workflow?_dc=1585752115613
t Transfer: 1220 :      9|15:41:55.8035|ZuI2n1|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|15:41:55.8035|ZuI2n1|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|15:41:55.8035|ZuI2n1|DANIEL|    user DANIEL.
t Verbose: 1220 :       9|15:41:55.8035|ZuI2n1|DANIEL|OAuth. User logged in: DANIEL
t Information: 1220 :   9|15:41:55.8035|ZuI2n1|DANIEL|V3Api.SearchWorkflows
t Information: 1220 :   9|15:41:55.8035|ZuI2n1|DANIEL|V3Api.SearchGeneric
t Transfer: 1220 :      9|15:41:55.8035|ZuI2n1|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|15:41:55.8035|ZuI2n1|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|15:41:55.8035|ZuI2n1|DANIEL|    user DANIEL.
t Information: 1220 :   9|15:41:55.8035|ZuI2n1|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=110181   order by j.J_COMPL_BY, j.id desc, j.id ) a where rownum <= 50) where rnum >= 1 order by rnum
t Information: 1220 :   9|15:41:55.8035|ZuI2n1|DANIEL|    jobs returned 1, searched in 00:00:00.0051583
t Information: 1220 :   9|15:41:55.8035|ZuI2n1|DANIEL|    tasks returned 1, searched in 00:00:00.0069916
t Verbose: 1220 :       9|15:41:55.8035|ZuI2n1|DANIEL|imfx v3 API took 0.018s '/api/v3/search/workflow?_dc=1585752115613'
t Transfer: 1220 :      9|15:41:59.4597|4lGzvS|DANIEL|OAuth: /api/view/searchinfo/TitleSearch?_dc=1585752119269
t Transfer: 1220 :      9|15:41:59.4597|4lGzvS|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|15:41:59.4597|4lGzvS|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|15:41:59.4597|4lGzvS|DANIEL|    user DANIEL.
t Verbose: 1220 :       9|15:41:59.4597|4lGzvS|DANIEL|OAuth. User logged in: DANIEL
t Information: 1220 :   9|15:41:59.4597|4lGzvS|DANIEL|GetAdvSearchColumns. search type TitleSearch grid .
t Verbose: 1220 :       9|15:41:59.4597|4lGzvS|DANIEL|imfx v3 API took 0.000s '/api/view/searchinfo/TitleSearch?_dc=1585752119269'
t Transfer: 1220 :      9|15:41:59.4597|Vb8lSU|DANIEL|OAuth: /api/user-preferences?keys=adv.recent.searches.titles&_dc=1585752119287
t Transfer: 1220 :      9|15:41:59.4597|Vb8lSU|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|15:41:59.4597|Vb8lSU|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|15:41:59.4597|Vb8lSU|DANIEL|    user DANIEL.
t Verbose: 1220 :       9|15:41:59.4597|Vb8lSU|DANIEL|OAuth. User logged in: DANIEL
t Information: 1220 :   9|15:41:59.4597|Vb8lSU|DANIEL|GetUserDataByKeys: adv.recent.searches.titles
t Transfer: 1220 :      9|15:41:59.4597|Vb8lSU|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|15:41:59.4597|Vb8lSU|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|15:41:59.4597|Vb8lSU|DANIEL|    user DANIEL.
t Verbose: 1220 :       9|15:41:59.4597|Vb8lSU|DANIEL|imfx v3 API took 0.004s '/api/user-preferences?keys=adv.recent.searches.titles&_dc=1585752119287'
t Transfer: 1220 :      9|15:41:59.6629|SxzPs_|DANIEL|OAuth: /api/view/searches/TitleSearch?_dc=1585752119435
t Transfer: 1220 :      9|15:41:59.6629|SxzPs_|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|15:41:59.6629|SxzPs_|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|15:41:59.6629|SxzPs_|DANIEL|    user DANIEL.
t Verbose: 1220 :       9|15:41:59.6629|SxzPs_|DANIEL|OAuth. User logged in: DANIEL
t Information: 1220 :   9|15:41:59.6629|SxzPs_|DANIEL|GetSavedSearchNames. search type TitleSearch.
t Transfer: 1220 :      9|15:41:59.6629|SxzPs_|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|15:41:59.6629|SxzPs_|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|15:41:59.6629|SxzPs_|DANIEL|    user DANIEL.
t Verbose: 1220 :       9|15:41:59.6629|SxzPs_|DANIEL|imfx v3 API took 0.004s '/api/view/searches/TitleSearch?_dc=1585752119435'
t Transfer: 1220 :      9|15:42:00.4753|LRzEA7|DANIEL|OAuth: /api/settings/user/uploadSettings?_dc=1585752120248
t Transfer: 1220 :      9|15:42:00.4753|LRzEA7|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|15:42:00.4753|LRzEA7|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|15:42:00.4753|LRzEA7|DANIEL|    user DANIEL.
t Verbose: 1220 :       9|15:42:00.4753|LRzEA7|DANIEL|OAuth. User logged in: DANIEL
t Transfer: 1220 :      9|15:42:00.4753|LRzEA7|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|15:42:00.4753|LRzEA7|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|15:42:00.4753|LRzEA7|DANIEL|    user DANIEL.
t Verbose: 1220 :       9|15:42:00.4753|LRzEA7|DANIEL|imfx v3 API took 0.003s '/api/settings/user/uploadSettings?_dc=1585752120248'
t Transfer: 1220 :      9|15:42:04.7410|G_Nh~F|DANIEL|OAuth: /api/v3/search-suggestion/?_dc=1585752124662
t Transfer: 1220 :      9|15:42:04.7410|G_Nh~F|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|15:42:04.7410|G_Nh~F|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|15:42:04.7410|G_Nh~F|DANIEL|    user DANIEL.
t Verbose: 1220 :       9|15:42:04.7410|G_Nh~F|DANIEL|OAuth. User logged in: DANIEL
t Transfer: 1220 :      9|15:42:04.7410|G_Nh~F|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|15:42:04.7410|G_Nh~F|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|15:42:04.7410|G_Nh~F|DANIEL|    user DANIEL.
t Transfer: 1220 :      9|15:42:05.1472|Ej~ZYB|DANIEL|OAuth: /api/v3/search-suggestion/?_dc=1585752124965
t Transfer: 1220 :      9|15:42:05.1472|Ej~ZYB|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|15:42:05.1472|Ej~ZYB|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|15:42:05.1472|Ej~ZYB|DANIEL|    user DANIEL.
t Verbose: 1220 :       9|15:42:05.1472|Ej~ZYB|DANIEL|OAuth. User logged in: DANIEL
t Transfer: 1220 :      9|15:42:05.1472|Ej~ZYB|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|15:42:05.1472|Ej~ZYB|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|15:42:05.1472|Ej~ZYB|DANIEL|    user DANIEL.
t Transfer: 1220 :      9|15:42:05.1472|~qa8ND|DANIEL|OAuth: /api/v3/search-suggestion/?_dc=1585752125044
t Transfer: 1220 :      9|15:42:05.1472|~qa8ND|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|15:42:05.1472|~qa8ND|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|15:42:05.1472|~qa8ND|DANIEL|    user DANIEL.
t Verbose: 1220 :       9|15:42:05.1472|~qa8ND|DANIEL|OAuth. User logged in: DANIEL
t Transfer: 1220 :      9|15:42:05.1472|~qa8ND|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|15:42:05.1472|~qa8ND|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|15:42:05.1472|~qa8ND|DANIEL|    user DANIEL.
t Verbose: 1220 :       9|15:42:05.1472|Ej~ZYB|DANIEL|imfx v3 API took 0.152s '/api/v3/search-suggestion/?_dc=1585752124965'
t Verbose: 1220 :       9|15:42:05.3660|G_Nh~F|DANIEL|imfx v3 API took 0.503s '/api/v3/search-suggestion/?_dc=1585752124662'
t Verbose: 1220 :       9|15:42:05.3660|~qa8ND|DANIEL|imfx v3 API took 0.078s '/api/v3/search-suggestion/?_dc=1585752125044'
t Transfer: 1220 :      9|15:42:05.3660|ybI~Mk|DANIEL|OAuth: /api/v3/search-suggestion/?_dc=1585752125260
t Transfer: 1220 :      9|15:42:05.3660|ybI~Mk|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|15:42:05.3660|ybI~Mk|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|15:42:05.3660|ybI~Mk|DANIEL|    user DANIEL.
t Verbose: 1220 :       9|15:42:05.3660|ybI~Mk|DANIEL|OAuth. User logged in: DANIEL
t Transfer: 1220 :      9|15:42:05.3660|ybI~Mk|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|15:42:05.3660|ybI~Mk|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|15:42:05.3660|ybI~Mk|DANIEL|    user DANIEL.
t Verbose: 1220 :       9|15:42:05.3660|ybI~Mk|DANIEL|imfx v3 API took 0.011s '/api/v3/search-suggestion/?_dc=1585752125260'
t Transfer: 1220 :      9|15:42:05.5691|B8zxcS|DANIEL|OAuth: /api/v3/search-suggestion/?_dc=1585752125501
t Transfer: 1220 :      9|15:42:05.5691|B8zxcS|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|15:42:05.5691|B8zxcS|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|15:42:05.5691|B8zxcS|DANIEL|    user DANIEL.
t Verbose: 1220 :       9|15:42:05.5691|B8zxcS|DANIEL|OAuth. User logged in: DANIEL
t Transfer: 1220 :      9|15:42:05.5691|B8zxcS|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|15:42:05.5691|B8zxcS|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|15:42:05.5691|B8zxcS|DANIEL|    user DANIEL.
t Verbose: 1220 :       9|15:42:05.5691|B8zxcS|DANIEL|imfx v3 API took 0.008s '/api/v3/search-suggestion/?_dc=1585752125501'
t Transfer: 1220 :      9|15:42:05.7722|D4YEyb|DANIEL|OAuth: /api/v3/search-suggestion/?_dc=1585752125661
t Transfer: 1220 :      9|15:42:05.7722|D4YEyb|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|15:42:05.7722|D4YEyb|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|15:42:05.7722|D4YEyb|DANIEL|    user DANIEL.
t Verbose: 1220 :       9|15:42:05.7722|D4YEyb|DANIEL|OAuth. User logged in: DANIEL
t Transfer: 1220 :      9|15:42:05.7722|D4YEyb|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|15:42:05.7722|D4YEyb|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|15:42:05.7722|D4YEyb|DANIEL|    user DANIEL.
t Verbose: 1220 :       9|15:42:05.7722|D4YEyb|DANIEL|imfx v3 API took 0.006s '/api/v3/search-suggestion/?_dc=1585752125661'
t Transfer: 1220 :      9|15:42:06.1785|kviGf_|DANIEL|OAuth: /api/v3/search/title?_dc=1585752125948
t Transfer: 1220 :      9|15:42:06.1785|kviGf_|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|15:42:06.1785|kviGf_|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|15:42:06.1785|kviGf_|DANIEL|    user DANIEL.
t Verbose: 1220 :       9|15:42:06.1785|kviGf_|DANIEL|OAuth. User logged in: DANIEL
t Information: 1220 :   9|15:42:06.1785|kviGf_|DANIEL|V3Api.SearchTitles
t Information: 1220 :   9|15:42:06.1785|kviGf_|DANIEL|V3Api.SearchGeneric
t Transfer: 1220 :      9|15:42:06.1785|kviGf_|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|15:42:06.1785|kviGf_|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|15:42:06.1785|kviGf_|DANIEL|    user DANIEL.
t Transfer: 1220 :      9|15:42:06.1785|kviGf_|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|15:42:06.1785|kviGf_|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|15:42:06.1785|kviGf_|DANIEL|    user DANIEL.
t Information: 1220 :   9|15:42:06.1785|kviGf_|DANIEL|SearchTitle SQL:
with 
 v as (
    SELECT 
        abs.*
       ,decode(ITEM_TYPE,
                 1010,SER_ABS_ID,
                 1020,CASE WHEN SER_ABS2_ID > 0 THEN SER_ABS2_ID ELSE SER_ABS_ID END
              ) xparent_id
      FROM TMDDBA.TM_PG_ABS abs
     WHERE abs.id in (
          select a.id
          FROM TMDDBA.TM_PG_ABS a
          where ABS_DELETED = 0  AND (CONTAINS(CTX_TEXT_COL,'mr robot') > 0 OR CONTAINS(CTX_IDS_COL,'mr robot') > 0 ) AND ROWNUM < 25000   )
      
 )
,v_missing_parent_ids as (
    select xparent_id from v
    minus
    select id from v
 )
,v_missing_parents as (
    SELECT 
        distinct a.*
       ,decode(ITEM_TYPE,
                 1010,SER_ABS_ID,
                 1020,CASE WHEN SER_ABS2_ID > 0 THEN SER_ABS2_ID ELSE SER_ABS_ID END
              ) xparent_id
      FROM TMDDBA.TM_PG_ABS a
    START WITH ID IN (select xparent_id from v_missing_parent_ids)
    CONNECT BY
           CASE PRIOR ITEM_TYPE
             WHEN 1010 THEN PRIOR SER_ABS_ID
             WHEN 1020 THEN 
               CASE WHEN NVL(PRIOR SER_ABS2_ID, 0) > 0 THEN PRIOR SER_ABS2_ID ELSE PRIOR SER_ABS_ID END
             END = ID
 )
,v_all as (
   select x.*, count(*) over() RowCount
   from (
     select * from v_missing_parents
     union 
     select * from v
   ) x
 )
,v_top as (
   select id
   from (select id, row_number()over(order by upper(ser_title),upper(title),ser_num,ser_ep_num, SER_EP_SQ_NUM ) rnk -- sort roots
         from v_all 
         where  xparent_id is null)
   where rnk between (:page_number-1)*50+1 and :page_number*50
)
,v_tree as (
   select level lvl, a.*
   from v_all a
   start with id in (select id from v_top)
   connect by xparent_id = prior ID
   order siblings by upper(ser_title),ser_num,ser_ep_num, SER_EP_SQ_NUM,upper(title) -- sort children
 )
select *
from v_tree 
--where rnk <= 50
t Verbose: 1220 :       9|15:42:06.1785|kviGf_|DANIEL|imfx v3 API took 0.050s '/api/v3/search/title?_dc=1585752125948'
t Transfer: 1220 :      9|15:42:06.1785|9rA7K7|DANIEL|OAuth: /api/v3/title/298904/versions?_dc=1585752126136
t Transfer: 1220 :      9|15:42:06.1785|9rA7K7|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|15:42:06.1785|9rA7K7|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|15:42:06.1785|9rA7K7|DANIEL|    user DANIEL.
t Verbose: 1220 :       9|15:42:06.1785|9rA7K7|DANIEL|OAuth. User logged in: DANIEL
t Information: 1220 :   9|15:42:06.1785|9rA7K7|DANIEL|V3Api.SearchGeneric
t Transfer: 1220 :      9|15:42:06.1785|9rA7K7|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|15:42:06.1785|9rA7K7|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|15:42:06.1785|9rA7K7|DANIEL|    user DANIEL.
t Transfer: 1220 :      9|15:42:06.3816|9rA7K7|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|15:42:06.3816|9rA7K7|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|15:42:06.3816|9rA7K7|DANIEL|    user DANIEL.
t Transfer: 1220 :      9|15:42:06.3816|Se49JI|DANIEL|OAuth: /api/user-preferences?_dc=1585752126141
t Transfer: 1220 :      9|15:42:06.3816|Se49JI|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|15:42:06.3816|Se49JI|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|15:42:06.3816|Se49JI|DANIEL|    user DANIEL.
t Verbose: 1220 :       9|15:42:06.3816|Se49JI|DANIEL|OAuth. User logged in: DANIEL
t Verbose: 1220 :       9|15:42:06.3816|Se49JI|DANIEL|StoreUserDataByKeys..
t Transfer: 1220 :      9|15:42:06.3816|Se49JI|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|15:42:06.3816|Se49JI|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|15:42:06.3816|Se49JI|DANIEL|    user DANIEL.
t Information: 1220 :   9|15:42:06.3816|9rA7K7|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=298904 
 order by m.title,m.id) a where rownum <= 9999) r where rnum >=1 order by rnum
t Information: 1220 :   9|15:42:06.3816|9rA7K7|DANIEL|Running version search. User: 342    Simple Search: 
Running Oracle search.
Running Oracle search for COUNT
Oracle count completed in: 1ms.  Returned lines: 0

t Verbose: 1220 :       9|15:42:06.3816|9rA7K7|DANIEL|imfx v3 API took 0.022s '/api/v3/title/298904/versions?_dc=1585752126136'
t Verbose: 1220 :       9|15:42:06.3816|Se49JI|DANIEL|imfx v3 API took 0.008s '/api/user-preferences?_dc=1585752126141'
t Information: 1220 :   9|15:42:06.3816|SGDdWr|DANIEL|GetUserProfile. Id: 30000
t Transfer: 1220 :      9|15:42:06.3816|SGDdWr|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|15:42:06.3816|SGDdWr|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|15:42:06.3816|SGDdWr|DANIEL|    user DANIEL.
t Transfer: 1220 :      9|15:42:08.4128|WhwjqW|DANIEL|OAuth: /api/v3/title/298905/versions?_dc=1585752128170
t Transfer: 1220 :      9|15:42:08.4128|WhwjqW|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|15:42:08.4128|WhwjqW|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|15:42:08.4128|WhwjqW|DANIEL|    user DANIEL.
t Verbose: 1220 :       9|15:42:08.4128|WhwjqW|DANIEL|OAuth. User logged in: DANIEL
t Information: 1220 :   9|15:42:08.4128|WhwjqW|DANIEL|V3Api.SearchGeneric
t Transfer: 1220 :      9|15:42:08.4128|WhwjqW|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|15:42:08.4128|WhwjqW|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|15:42:08.4128|WhwjqW|DANIEL|    user DANIEL.
t Transfer: 1220 :      9|15:42:08.4128|WhwjqW|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|15:42:08.4128|WhwjqW|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|15:42:08.4128|WhwjqW|DANIEL|    user DANIEL.
t Information: 1220 :   9|15:42:08.4128|WhwjqW|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=298905 
 order by m.title,m.id) a where rownum <= 9999) r where rnum >=1 order by rnum
t Information: 1220 :   9|15:42:08.4128|WhwjqW|DANIEL|Running version search. User: 342    Simple Search: 
Running Oracle search.
Running Oracle search for COUNT
Oracle count completed in: 1ms.  Returned lines: 2
Oracle version search timing: 38ms.
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=298905 
 order by m.title,m.id) a where rownum <= 9999) r where rnum >=1 order by rnum

t Verbose: 1220 :       9|15:42:08.4128|WhwjqW|DANIEL|imfx v3 API took 0.045s '/api/v3/title/298905/versions?_dc=1585752128170'
t Transfer: 1220 :      9|15:42:08.4128|_3orVz|DANIEL|OAuth: /api/v3/version/298906/media?_dc=1585752128346
t Transfer: 1220 :      9|15:42:08.4128|_3orVz|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|15:42:08.4128|_3orVz|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|15:42:08.4128|_3orVz|DANIEL|    user DANIEL.
t Verbose: 1220 :       9|15:42:08.4128|_3orVz|DANIEL|OAuth. User logged in: DANIEL
t Information: 1220 :   9|15:42:08.4128|_3orVz|DANIEL|V3Api.SearchGeneric
t Transfer: 1220 :      9|15:42:08.4128|_3orVz|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|15:42:08.4128|_3orVz|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|15:42:08.4128|_3orVz|DANIEL|    user DANIEL.
t Information: 1220 :   9|15:42:08.4128|_3orVz|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: 298906
t Information: 1220 :   9|15:42:08.6160|_3orVz|DANIEL|    timing: 00:00:00.0223863
t Verbose: 1220 :       9|15:42:08.6160|_3orVz|DANIEL|imfx v3 API took 0.048s '/api/v3/version/298906/media?_dc=1585752128346'
t Transfer: 1220 :      9|15:42:08.6160|_3orVz|DANIEL|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\MRR28-1.mov subfolder 
t Transfer: 1220 :      9|15:42:08.6160|_3orVz|DANIEL|  GetFileName result https://imfxv3tm.tmd.tv/VideoServer/MRR28-1.mov
t Transfer: 1220 :      9|15:42:08.6160|_3orVz|DANIEL|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/MRR28-1.mov
t Transfer: 1220 :      9|15:42:08.6160|_3orVz|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|15:42:08.6160|_3orVz|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|15:42:08.6160|_3orVz|DANIEL|    user DANIEL.
t Transfer: 1220 :      9|15:42:08.6160|_3orVz|DANIEL|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\N0001876.mpd subfolder 
t Transfer: 1220 :      9|15:42:08.6160|_3orVz|DANIEL|  GetFileName result https://imfxv3tm.tmd.tv/VideoServer/N0001876.mpd
t Transfer: 1220 :      9|15:42:08.6160|_3orVz|DANIEL|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/N0001876.mpd
t Transfer: 1220 :      9|15:42:08.6160|_3orVz|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|15:42:08.6160|_3orVz|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|15:42:08.6160|_3orVz|DANIEL|    user DANIEL.
t Transfer: 1220 :      9|15:42:12.4754|FTGceb|DANIEL|OAuth: /api/v3/media-details/299080?_dc=1585752132396
t Transfer: 1220 :      9|15:42:12.4754|FTGceb|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|15:42:12.4754|FTGceb|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|15:42:12.4754|FTGceb|DANIEL|    user DANIEL.
t Verbose: 1220 :       9|15:42:12.4754|FTGceb|DANIEL|OAuth. User logged in: DANIEL
t Transfer: 1220 :      9|15:42:12.4754|FTGceb|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|15:42:12.4754|FTGceb|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|15:42:12.4754|FTGceb|DANIEL|    user DANIEL.
t Information: 1220 :   9|15:42:12.8816|||TM_MIS. LoadSubtitles for ID: 299080
t Information: 1220 :   9|15:42:12.8816|||TM_MIS. LoadSubtitles for ID: 299080. SQL: 'select id, m_ctnr_id, m_ctnr_loc, modified_dt, tv_std, m_ctnr_fmt_id, 
    nvl((select max(l.language) from tm_audio l where l.miid=m.id),aud_language_id) aud_language_id
  from tm_mis m where mi_deleted=0 and item_type>0 and media_type=101 and PGM_PARENT_ID=298906'
t Information: 1220 :   9|15:42:12.8816|||    Subtitles added for ID: 299080, 299080 Unknown [0] : 'https://imfxv3tm.tmd.tv/getcaptions.aspx?f=MRR28-1.scc&som=00:00:00:00&storage=TimedText&modified=637213461660000000&tcf=0&id=299080&tmp=0'.
t Verbose: 1220 :       9|15:42:13.0847|FTGceb|DANIEL|imfx v3 API took 0.489s '/api/v3/media-details/299080?_dc=1585752132396'
t Transfer: 1220 :      9|15:42:13.0847|MjQi4S|DANIEL|OAuth: /api/v3/detailsview/MediaDetails/6?lang=en-GB&_dc=1585752132979
t Transfer: 1220 :      9|15:42:13.0847|MjQi4S|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|15:42:13.0847|MjQi4S|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|15:42:13.0847|MjQi4S|DANIEL|    user DANIEL.
t Verbose: 1220 :       9|15:42:13.0847|MjQi4S|DANIEL|OAuth. User logged in: DANIEL
t Verbose: 1220 :       9|15:42:13.0847|MjQi4S|DANIEL|imfx v3 API took 0.004s '/api/v3/detailsview/MediaDetails/6?lang=en-GB&_dc=1585752132979'
t Transfer: 1220 :      9|15:42:13.0847|3Qn8BJ|DANIEL|OAuth: /api/v3/subtitles/299080?_dc=1585752133018
t Transfer: 1220 :      9|15:42:13.0847|3Qn8BJ|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|15:42:13.0847|3Qn8BJ|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|15:42:13.0847|3Qn8BJ|DANIEL|    user DANIEL.
t Verbose: 1220 :       9|15:42:13.0847|3Qn8BJ|DANIEL|OAuth. User logged in: DANIEL
t Information: 1220 :   9|15:42:13.0847|3Qn8BJ|DANIEL|V3 api. GetSubtitles: 299080
t Information: 1220 :   9|15:42:13.0847|3Qn8BJ|DANIEL|SubtitlesQcLoadSubtitles. ID 299080
t Information: 1220 :   9|15:42:13.0847|3Qn8BJ|DANIEL|LoadSubtitlesById. filename MRR28-1.scc device TimedText frame rate Pal
t Information: 1220 :   9|15:42:13.0847|3Qn8BJ|DANIEL|LoadSubtitlesById. Filename: MRR28-1.scc. Device TimedText. Timecode format Pal. Media ID 299080.
t Information: 1220 :   9|15:42:13.0847|3Qn8BJ|DANIEL|GetCaptions. Start. Filename: MRR28-1.scc. Cache path C:\inetpub\wwwroot\imfxcore\timedtextcache\. Storage path \\192.168.120.254\DemoFS\Digital Assets\TimedText. Last Modified 1/1/0001 12:00:00 AM
t Information: 1220 :   9|15:42:13.0847|3Qn8BJ|DANIEL|GetCaptions. Convert required. Som 00:00:00. From: \\192.168.120.254\DemoFS\Digital Assets\TimedText\MRR28-1.scc to: C:\inetpub\wwwroot\imfxcore\timedtextcache\MRR28-1.scc_pal_299080.xml
t Information: 1220 :   9|15:42:13.0847|3Qn8BJ|DANIEL|GetCaptions. Convertor lock aquired.
t Information: 1220 :   9|15:42:13.2878|3Qn8BJ|DANIEL|GetCaptions. File converted: \\192.168.120.254\DemoFS\Digital Assets\TimedText\MRR28-1.scc. Result: True
t Information: 1220 :   9|15:42:13.2878|3Qn8BJ|DANIEL|GetCaptions. In cache. Filename: C:\inetpub\wwwroot\imfxcore\timedtextcache\MRR28-1.scc_pal_299080.xml
t Information: 1220 :   9|15:42:13.2878|3Qn8BJ|DANIEL|LoadSubtitlesById. Convertor lock acquired.
t Information: 1220 :   9|15:42:13.2878|3Qn8BJ|DANIEL|LoadSubtitlesById got 43 lines.
t Verbose: 1220 :       9|15:42:13.2878|3Qn8BJ|DANIEL|imfx v3 API took 0.059s '/api/v3/subtitles/299080?_dc=1585752133018'
t Transfer: 1220 :      9|15:42:13.6941|hO~AcH|DANIEL|OAuth: /api/v3/attachments/4000/299080?_dc=1585752133497
t Transfer: 1220 :      9|15:42:13.6941|hO~AcH|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|15:42:13.6941|hO~AcH|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|15:42:13.6941|hO~AcH|DANIEL|    user DANIEL.
t Verbose: 1220 :       9|15:42:13.6941|hO~AcH|DANIEL|OAuth. User logged in: DANIEL
t Verbose: 1220 :       9|15:42:13.6941|hO~AcH|DANIEL|imfx v3 API took 0.016s '/api/v3/attachments/4000/299080?_dc=1585752133497'
t Information: 1220 :   9|15:43:07.9285|5WYHgR|DANIEL|GetUserProfile. Id: 30000
t Transfer: 1220 :      9|15:43:07.9285|5WYHgR|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|15:43:07.9285|5WYHgR|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|15:43:07.9285|5WYHgR|DANIEL|    user DANIEL.
t Information: 1220 :   9|15:44:08.2566|jGnqzd|DANIEL|GetUserProfile. Id: 30000
t Transfer: 1220 :      9|15:44:08.2566|jGnqzd|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|15:44:08.2566|jGnqzd|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|15:44:08.2566|jGnqzd|DANIEL|    user DANIEL.
t Information: 1220 :   9|15:44:42.6004|||OrabitWatcherBasic. Disposing.
t Information: 1220 :   9|15:44:42.6004|||OrabitWatcherBasic. Disposed.
t Information: 1220 :   9|15:44:42.6004|||==========================================================================
t Information: 1220 :   9|15:44:42.6004|||IMFX CORE SERVER APPLICATION END.