t Information: 1220 : 9|20:57:37.3577|||Get Configuration Values: t Information: 1220 : 9|20:57:37.3577||| AdminPassEnc, default: , value: ffqjrn0leKv4Lj2YJHe2dw==. t Information: 1220 : 9|20:57:37.3577||| EncryptedPasswords, default: false, value: true. t Information: 1220 : 9|20:57:37.3577||| OraConnectionString, default: , value: Server=TECHM;User Id=imfx;Password=xxxxx;Unicode=true;. t Information: 1220 : 9|20:57:37.3577||| SecondTimezone, default: , value: . t Information: 1220 : 9|20:57:37.3577||| UseActiveDirectoryAuth, default: false, value: false. t Information: 1220 : 9|20:57:37.3577||| ReportingServiceUrl, default: , value: http://localhost:92/ReportingService.svc. t Information: 1220 : 9|20:57:37.3577||| ReportsPath, default: , value: . t Information: 1220 : 9|20:57:37.3577||| ReportsURL, default: , value: . t Information: 1220 : 9|20:57:37.3577||| TapeServiceUrl, default: , value: . t Information: 1220 : 9|20:57:37.3577||| GatekeeperUrl, default: , value: . t Information: 1220 : 9|20:57:37.3577||| ValuationUrl, default: , value: . t Information: 1220 : 9|20:57:37.3577||| QueueManagerDelay, default: 30, value: 30. t Information: 1220 : 9|20:57:37.3577||| QueueManagerFullRefresh, default: 90, value: 90. t Information: 1220 : 9|20:57:37.3577||| AudioLoopDuration, default: 0, value: 150. t Information: 1220 : 9|20:57:37.3577||| AudioLoopsCount, default: 0, value: 0. t Information: 1220 : 9|20:57:37.3577||| PlayerFakeStep, default: 500, value: 500. t Information: 1220 : 9|20:57:37.3577||| PlayerForceRatio, default: 0, value: 1. t Information: 1220 : 9|20:57:37.3577||| CheckVersionsInProd, default: false, value: True. t Information: 1220 : 9|20:57:37.3577||| MaxResults, default: 3000, value: 10000. t Information: 1220 : 9|20:57:37.3577||| NetworkRestriction, default: false, value: True. t Information: 1220 : 9|20:57:37.3577||| TEReportID, default: 0, value: 0. t Information: 1220 : 9|20:57:37.3577||| ClosedCaptionsCache, default: , value: C:\inetpub\wwwroot\imfxcore\timedtextcache\. t Information: 1220 : 9|20:57:37.3577||| ClosedCaptionsStorage, default: , value: c:\Mediaflex\subs. t Information: 1220 : 9|20:57:37.3577||| TimeCodeFormat, default: , value: pal. t Information: 1220 : 9|20:57:37.3577||| RceMediaPath, default: , value: C:\edl\. t Information: 1220 : 9|20:57:37.3577||| RceMediaPath, default: , value: C:\edl\. t Information: 1220 : 9|20:57:37.3577||| RceCsmOutputPath, default: , value: C:\Inetpub\wwwroot\csm\. t Information: 1220 : 9|20:57:37.3577||| RceCsmUrl, default: , value: http://localhost/csm/. t Information: 1220 : 9|20:57:37.3577||| RceMediaSelection, default: , value: miLinkIdMatch. t Information: 1220 : 9|20:57:37.3577||| RequestBrowseJobPresetName, default: , value: . t Information: 1220 : 9|20:57:37.3577||| DontExtendDuration, default: false, value: False. t Information: 1220 : 9|20:57:37.3577||| V3ConfigUrl, default: , value: . t Information: 1220 : 9|20:57:37.3577||| StopWords, default: , value: . t Information: 1220 : 9|20:57:37.3577||| MisrTxFormat, default: G, value: G. t Information: 1220 : 9|20:57:37.3577||| ApiServer, default: , value: http://192.168.120.10:85. t Information: 1220 : 9|20:57:37.3577||| ApiTimeout, default: 120, value: 120. t Information: 1220 : 9|20:57:37.3577||| ApiWorkers, default: 10, value: 10. t Information: 1220 : 9|20:57:37.3577||| UsePerfCounters, default: false, value: false. t Information: 1220 : 9|20:57:37.3577||| StatsdAddress, default: , value: . t Information: 1220 : 9|20:57:37.3577||| LogGetCurrentUser, default: true, value: true. t Information: 1220 : 9|20:57:37.3577||| LogInternalApi, default: true, value: true. t Information: 1220 : 9|20:57:37.3577||| ThumbnailServer, default: , value: . t Information: 1220 : 9|20:57:37.3577||| LocationFilter, default: , value: . t Information: 1220 : 9|20:57:37.3577||| SvUtilServiceUrl, default: , value: . t Information: 1220 : 9|20:57:37.3577||| SolrConnection, default: , value: http://192.168.120.14:8983/solr. t Information: 1220 : 9|20:57:37.3577||| UseIndexServerSearch, default: false, value: True. t Information: 1220 : 9|20:57:37.3577||| SolrIndexVersion, default: 1, value: 6. t Information: 1220 : 9|20:57:37.3577||| SolrConnection, default: , value: http://192.168.120.14:8983/solr. t Information: 1220 : 9|20:57:37.3577||| FacetsGroups, default: , value: owners,season_id, series_id,version_key,item_type,media_type,media_format,episode_number. t Information: 1220 : 9|20:57:37.3577||| FacetsGroupsVersion, default: , value: owners,season_id, series_id,version_key,episode_number. t Information: 1220 : 9|20:57:37.3577||| FacetsGroupsChameleon, default: , value: season_id, series_id,genre,prod_year,version_key. t Information: 1220 : 9|20:57:37.3577||| PreviewPreset, default: , value: . t Information: 1220 : 9|20:57:37.3577||| DevMode, default: false, value: false. t Information: 1220 : 9|20:57:37.3577||| DisableSysMan, default: false, value: false. t Information: 1220 : 9|20:57:37.3577||| TimeCodeFormat, default: , value: pal. t Information: 1220 : 9|20:57:37.3577||| FileCatalystStorageDevice, default: , value: . t Information: 1220 : 9|20:57:37.3577||| UseResponsibilityTracking, default: true, value: True. t Information: 1220 : 9|20:57:37.3577||| SubtitleDeviceFilter, default: , value: . t Information: 1220 : 9|20:57:37.3577||| SystemMonitorNamedPipe, default: , value: . t Information: 1220 : 9|20:57:37.3577||| OracleMonitorEnable, default: false, value: False. t Information: 1220 : 9|20:57:37.3577||| ArcApiHost, default: , value: . t Information: 1220 : 9|20:57:37.3577||| RabbitMqUrl, default: , value: amqp://192.168.120.14:5672. t Information: 1220 : 9|20:57:37.3577||| SolrTimedTextSearch, default: false, value: false. t Information: 1220 : 9|20:57:37.3577||| ProductionDurationUsageID, default: 1, value: 1. t Information: 1220 : 9|20:57:37.5764|||GetStreamServers.. t Information: 1220 : 9|20:57:38.3889||| https://demo.tmd.tv/CBR Video/ |CBR Video| False t Information: 1220 : 9|20:57:38.3889||| https://demo.tmd.tv/CBR Images/ |CBR Images| False t Information: 1220 : 9|20:57:38.3889||| https://demo.tmd.tv/CBR Audio/ |CBR Audio| False t Information: 1220 : 9|20:57:38.3889||| https://demo.tmd.tv/Temp Upload/ |TEMP_UPLOAD| False t Information: 1220 : 9|20:57:38.3889||| http://localhost:82/images/ |IMAGES| False t Information: 1220 : 9|20:57:38.3889||| http://192.168.91.73/smoothcloud/ |SMOOTH_CLOUD| False t Information: 1220 : 9|20:57:38.3889||| http://192.168.91.73/cloudstore/ |CLOUD_STORE| False t Information: 1220 : 9|20:57:38.3889||| http://192.168.91.73/editsystemin/ |EDIT_SYSTEM_IN| False t Information: 1220 : 9|20:57:38.3889||| http://192.168.91.27:89/APPLEPROXY/ |APPLE_PROXY| False t Information: 1220 : 9|20:57:38.3889||| http://localhost:82/video/ |FILESTORE_VIDEO| False t Information: 1220 : 9|20:57:38.3889||| https://imfxv3tm.tmd.tv/streaming/ |Streaming| False t Information: 1220 : 9|20:57:38.3889||| https://imfxv3tm.tmd.tv/VideoServer/ |Video| False t Information: 1220 : 9|20:57:38.3889||| https://imfxv3tm.tmd.tv/AdobeIn/ |Adobe Premiere Pro In| False t Information: 1220 : 9|20:57:38.3889||| https://imfxv3tm.tmd.tv/AudioServer/ |Audio| False t Information: 1220 : 9|20:57:38.3889||| https://imfxv3tm.tmd.tv/ImageServer/ |Image| False t Information: 1220 : 9|20:57:38.3889||| https://imfxv3tm.tmd.tv/DocsServer/ |Docs| False t Information: 1220 : 9|20:57:38.3889||| https://imfxv3tm.tmd.tv/AmazonLabs/ |TEST HOUSE| False t Information: 1220 : 9|20:57:38.3889||| SolrConnectionUms, default: http://192.168.120.14:8983/solr, value: http://192.168.120.14:8983/solr. t Information: 1220 : 9|20:57:38.3889||| LogWebApi, default: false, value: false. t Information: 1220 : 9|20:57:38.3889||| EmbeddedRceUrl, default: , value: . t Information: 1220 : 9|20:57:38.3889||| InstallMode, default: , value: . t Information: 1220 : 9|20:57:38.3889||| SamlRequestAddress, default: , value: . t Information: 1220 : 9|20:57:38.3889||| SamlTrustedIssuer, default: , value: . t Information: 1220 : 9|20:57:38.3889||| SamlLoginRedirect, default: , value: . t Information: 1220 : 9|20:57:38.3889||| NaturalLangSearch, default: false, value: True. t Information: 1220 : 9|20:57:38.3889||| OktaLoginField, default: , value: . t Information: 1220 : 9|20:57:38.3889||| AuthenticationTypes, default: , value: Native,PublicApiKey. t Information: 1220 : 9|20:57:38.3889|||OrabitWatcherBasic. Initialize. t Information: 1220 : 9|20:57:38.5921|||FillDictionaryCache. t Information: 1220 : 9|20:57:41.9671|||GetSupportedOperators t Information: 1220 : 9|20:57:42.3733|||CacheTechReports. t Information: 1220 : 9|20:57:42.3733|||& Cache update. Server (global) filled with timestamp 08:03:42.2795803. types null t Information: 1220 : 9|20:57:42.3733|||InitializeFromDatabase. 'Server=TECHM;User Id=imfx;password=..;Unicode=true;' direct False, home , timeout 15 t Information: 1220 : 9|20:57:42.3733|||FillDictionaryCache. t Information: 1220 : 9|20:57:42.3733|||& Cache update. Server (global) filled with timestamp 08:03:42.2951988. types FriendlyNames, DatabaseSearchFieldData t Information: 1220 : 9|20:57:42.9827|||========================================================================== t Information: 1220 : 9|20:57:42.9827|||IMFX CORE SERVER APPLICATION START. t Information: 1220 : 9|20:57:42.9827|||DLL VERSION: 2.5.0.2610. t Information: 1220 : 9|20:57:42.9827|||IS TIMER HIGH RESOULTION : True. t Information: 1220 : 9|20:57:42.9827||| UmsDev, default: False, value: False. t Information: 1220 : 9|20:57:43.3889|||OrabitWatcherBasic trying to connect.. t Information: 1220 : 9|20:57:43.5920|||OrabitWatcherBasic connected. t Information: 1220 : 9|20:57:43.5920|||OrabitWatcherBasic queue created tmd.cfg.in.c6b915a7-9196-42ab-a505-00322e8b3382 t Information: 1220 : 9|20:58:09.1858|9xhY0j|TMDDBA|GetUserProfile. Id: 30000 t Transfer: 1220 : 9|20:58:09.1858|9xhY0j|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 9|20:58:09.1858|9xhY0j|TMDDBA| OAuth authenticated t Transfer: 1220 : 9|20:58:09.1858|9xhY0j|TMDDBA| user TMDDBA. t Transfer: 1220 : 9|20:58:25.8421|w_tlr7|TMDDBA|OAuth: /api/v3/search/workflow?_dc=1585684705717 t Transfer: 1220 : 9|20:58:25.8421|w_tlr7|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 9|20:58:25.8421|w_tlr7|TMDDBA| OAuth authenticated t Transfer: 1220 : 9|20:58:25.8421|w_tlr7|TMDDBA| user TMDDBA. t Verbose: 1220 : 9|20:58:25.8421|w_tlr7|TMDDBA|OAuth. User logged in: TMDDBA t Information: 1220 : 9|20:58:25.8421|w_tlr7|TMDDBA|V3Api.SearchWorkflows t Information: 1220 : 9|20:58:25.8421|w_tlr7|TMDDBA|V3Api.SearchGeneric t Transfer: 1220 : 9|20:58:25.8421|w_tlr7|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 9|20:58:25.8421|w_tlr7|TMDDBA| OAuth authenticated t Transfer: 1220 : 9|20:58:25.8421|w_tlr7|TMDDBA| user TMDDBA. t Information: 1220 : 9|20:58:25.8421|w_tlr7|TMDDBA|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=108992 AND j.J_CLI_CODE in ('03BO' , '03GD' , '03GO' , '03HA' , '03JO' , '03LI' , '03NB' , '03NM' , '03NO' , '03OR' , '03SB' , '03SC' , '03SE' , '03SG' , '03SK' , '03SM' , '03SN' , '03SS' , '03SY' , '03UP' , '03VA' , '03VB' , '03VL' , '03VT' , '3+ES' , '3PD' , '3PLV' , 'AECHD' , 'AECSD' , 'AL' , 'AMAY' , 'AMC' , 'ATP' , 'CENT' , 'CS' , 'CTCB' , 'CTCE' , 'DAVI' , 'DMA' , 'DMF' , 'DMY' , 'DTV' , 'EST' , 'EUROSPORT' , 'HDC1' , 'HDP1' , 'HDP2' , 'HUB' , 'KNL2' , 'KNVA' , 'LMH' , 'LNT' , 'MBNS' , 'MED' , 'MM' , 'MTG' , 'NAA' , 'NICK' , 'NVA' , 'OSP' , 'PBOY' , 'PMS' , 'PPL' , 'PSP' , 'Play' , 'RTR' , 'SFP1' , 'SFP2' , 'SPG' , 'SPTV' , 'T3LT' , 'T3LV' , 'T6LT' , 'T6LV' , 'T8LT' , 'TECHM' , 'TMD' , 'TV10' , 'TV1A' , 'TV1B' , 'TV1C' , 'TV1D' , 'TV1E' , 'TV1F' , 'TV1K' , 'TV1N' , 'TV1P' , 'TV1S' , 'TV2S' , 'TV3D' , 'TV3N' , 'TV3S' , 'TV5L' , 'TV6E' , 'TV6H' , 'TV6N' , 'TV6S' , 'TV8' , 'TVAE' , 'TVDP' , 'TVPB' , 'TVPU' , 'TVSL' , 'V1G' , 'V1TZ' , 'V3H' , 'V4N' , 'VEC' , 'VEPL' , 'VEPO' , 'VEXE' , 'VEXR' , 'VHIS' , 'VHPO' , 'VNC' , 'VNE' , 'VNH' , 'VNHD' , 'VNPO' , 'VODD' , 'VODE' , 'VODF' , 'VODN' , 'VODS' , 'VS2' , 'VS3' , 'VSAT' , 'VSD' , 'VSD2' , 'VSE' , 'VSG' , 'VSHD' , 'VSS' , 'WCIU' , 'YLE TV1' , 'ZTVS') 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|20:58:25.8421|w_tlr7|TMDDBA| jobs returned 1, searched in 00:00:00.0076899 t Information: 1220 : 9|20:58:25.8421|w_tlr7|TMDDBA| tasks returned 1, searched in 00:00:00.0104792 t Verbose: 1220 : 9|20:58:25.8421|w_tlr7|TMDDBA|imfx v3 API took 0.034s '/api/v3/search/workflow?_dc=1585684705717' t Transfer: 1220 : 9|20:58:26.8577|4ZlGCK|TMDDBA|OAuth: /api/v3/search/workflow?_dc=1585684706718 t Transfer: 1220 : 9|20:58:26.8577|4ZlGCK|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 9|20:58:26.8577|4ZlGCK|TMDDBA| OAuth authenticated t Transfer: 1220 : 9|20:58:26.8577|4ZlGCK|TMDDBA| user TMDDBA. t Verbose: 1220 : 9|20:58:26.8577|4ZlGCK|TMDDBA|OAuth. User logged in: TMDDBA t Information: 1220 : 9|20:58:26.8577|4ZlGCK|TMDDBA|V3Api.SearchWorkflows t Information: 1220 : 9|20:58:26.8577|4ZlGCK|TMDDBA|V3Api.SearchGeneric t Transfer: 1220 : 9|20:58:26.8577|4ZlGCK|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 9|20:58:26.8577|4ZlGCK|TMDDBA| OAuth authenticated t Transfer: 1220 : 9|20:58:26.8577|4ZlGCK|TMDDBA| user TMDDBA. t Information: 1220 : 9|20:58:26.8577|4ZlGCK|TMDDBA|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('31/03/2020','DD/MM/YYYY') and j.cmb_stat not in (15,18,23) AND j.J_CLI_CODE in ('03BO' , '03GD' , '03GO' , '03HA' , '03JO' , '03LI' , '03NB' , '03NM' , '03NO' , '03OR' , '03SB' , '03SC' , '03SE' , '03SG' , '03SK' , '03SM' , '03SN' , '03SS' , '03SY' , '03UP' , '03VA' , '03VB' , '03VL' , '03VT' , '3+ES' , '3PD' , '3PLV' , 'AECHD' , 'AECSD' , 'AL' , 'AMAY' , 'AMC' , 'ATP' , 'CENT' , 'CS' , 'CTCB' , 'CTCE' , 'DAVI' , 'DMA' , 'DMF' , 'DMY' , 'DTV' , 'EST' , 'EUROSPORT' , 'HDC1' , 'HDP1' , 'HDP2' , 'HUB' , 'KNL2' , 'KNVA' , 'LMH' , 'LNT' , 'MBNS' , 'MED' , 'MM' , 'MTG' , 'NAA' , 'NICK' , 'NVA' , 'OSP' , 'PBOY' , 'PMS' , 'PPL' , 'PSP' , 'Play' , 'RTR' , 'SFP1' , 'SFP2' , 'SPG' , 'SPTV' , 'T3LT' , 'T3LV' , 'T6LT' , 'T6LV' , 'T8LT' , 'TECHM' , 'TMD' , 'TV10' , 'TV1A' , 'TV1B' , 'TV1C' , 'TV1D' , 'TV1E' , 'TV1F' , 'TV1K' , 'TV1N' , 'TV1P' , 'TV1S' , 'TV2S' , 'TV3D' , 'TV3N' , 'TV3S' , 'TV5L' , 'TV6E' , 'TV6H' , 'TV6N' , 'TV6S' , 'TV8' , 'TVAE' , 'TVDP' , 'TVPB' , 'TVPU' , 'TVSL' , 'V1G' , 'V1TZ' , 'V3H' , 'V4N' , 'VEC' , 'VEPL' , 'VEPO' , 'VEXE' , 'VEXR' , 'VHIS' , 'VHPO' , 'VNC' , 'VNE' , 'VNH' , 'VNHD' , 'VNPO' , 'VODD' , 'VODE' , 'VODF' , 'VODN' , 'VODS' , 'VS2' , 'VS3' , 'VSAT' , 'VSD' , 'VSD2' , 'VSE' , 'VSG' , 'VSHD' , 'VSS' , 'WCIU' , 'YLE TV1' , 'ZTVS') 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|20:58:26.8577|4ZlGCK|TMDDBA| jobs returned 15, searched in 00:00:00.0128535 t Information: 1220 : 9|20:58:26.8577|4ZlGCK|TMDDBA|TechReports is not found. ID: 96. t Information: 1220 : 9|20:58:26.8577|4ZlGCK|TMDDBA|TechReports is not found. ID: 41. t Information: 1220 : 9|20:58:26.8577|4ZlGCK|TMDDBA|TechReports is not found. ID: 1633. t Information: 1220 : 9|20:58:26.8577|4ZlGCK|TMDDBA|TechReports is not found. ID: 1300. t Information: 1220 : 9|20:58:26.8577|4ZlGCK|TMDDBA|TechReports is not found. ID: 116. t Information: 1220 : 9|20:58:26.8577|4ZlGCK|TMDDBA|TechReports is not found. ID: 673. t Information: 1220 : 9|20:58:26.8577|4ZlGCK|TMDDBA|TechReports is not found. ID: 1301. t Information: 1220 : 9|20:58:26.8577|4ZlGCK|TMDDBA| tasks returned 15, searched in 00:00:00.0439620 t Verbose: 1220 : 9|20:58:26.8577|4ZlGCK|TMDDBA|imfx v3 API took 0.063s '/api/v3/search/workflow?_dc=1585684706718' t Transfer: 1220 : 9|20:58:27.0608|b~hk6_|TMDDBA|OAuth: /api/user-preferences?_dc=1585684706909 t Transfer: 1220 : 9|20:58:27.0608|b~hk6_|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 9|20:58:27.0608|b~hk6_|TMDDBA| OAuth authenticated t Transfer: 1220 : 9|20:58:27.0608|b~hk6_|TMDDBA| user TMDDBA. t Verbose: 1220 : 9|20:58:27.0608|b~hk6_|TMDDBA|OAuth. User logged in: TMDDBA t Verbose: 1220 : 9|20:58:27.0608|b~hk6_|TMDDBA|StoreUserDataByKeys.. t Transfer: 1220 : 9|20:58:27.0608|b~hk6_|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 9|20:58:27.0608|b~hk6_|TMDDBA| OAuth authenticated t Transfer: 1220 : 9|20:58:27.0608|b~hk6_|TMDDBA| user TMDDBA. t Verbose: 1220 : 9|20:58:27.0608|b~hk6_|TMDDBA|imfx v3 API took 0.031s '/api/user-preferences?_dc=1585684706909' t Transfer: 1220 : 9|20:58:29.2952|M9cKfc|TMDDBA|OAuth: /api/v3/task/componentqc/109038?_dc=1585684709091 t Transfer: 1220 : 9|20:58:29.2952|M9cKfc|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 9|20:58:29.2952|M9cKfc|TMDDBA| OAuth authenticated t Transfer: 1220 : 9|20:58:29.2952|M9cKfc|TMDDBA| user TMDDBA. t Verbose: 1220 : 9|20:58:29.2952|M9cKfc|TMDDBA|OAuth. User logged in: TMDDBA t Information: 1220 : 9|20:58:29.2952|M9cKfc|TMDDBA|V3Api. GetComponentQc task: 109038 t Information: 1220 : 9|20:58:29.2952|M9cKfc|TMDDBA|SubtitleQcTask. LoadFromDb got Job 109037 and Subtitles 1. t Verbose: 1220 : 9|20:58:29.2952|M9cKfc|TMDDBA|imfx v3 API took 0.154s '/api/v3/task/componentqc/109038?_dc=1585684709091' t Information: 1220 : 9|20:58:29.3264|M9cKfc|TMDDBA|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.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.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.d__6.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Web.Http.Filters.ActionFilterAttribute.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.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.d__6.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Web.Http.Filters.ActionFilterAttribute.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.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.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.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.d__6.MoveNext() [GET] https://imfxv3tm.tmd.tv/api/v3/task/componentqc/109038?_dc=1585684709091 System.Web.Http.Routing.HttpRoute t Transfer: 1220 : 9|20:58:34.8264|DzX6vy|TMDDBA|OAuth: /api/v3/search/workflow?_dc=1585684714750 t Transfer: 1220 : 9|20:58:34.8264|DzX6vy|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 9|20:58:34.8264|DzX6vy|TMDDBA| OAuth authenticated t Transfer: 1220 : 9|20:58:34.8264|DzX6vy|TMDDBA| user TMDDBA. t Verbose: 1220 : 9|20:58:34.8264|DzX6vy|TMDDBA|OAuth. User logged in: TMDDBA t Information: 1220 : 9|20:58:34.8264|DzX6vy|TMDDBA|V3Api.SearchWorkflows t Information: 1220 : 9|20:58:34.8264|DzX6vy|TMDDBA|V3Api.SearchGeneric t Transfer: 1220 : 9|20:58:34.8264|DzX6vy|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 9|20:58:34.8264|DzX6vy|TMDDBA| OAuth authenticated t Transfer: 1220 : 9|20:58:34.8264|DzX6vy|TMDDBA| user TMDDBA. t Information: 1220 : 9|20:58:34.8264|DzX6vy|TMDDBA|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=109037 AND j.J_CLI_CODE in ('03BO' , '03GD' , '03GO' , '03HA' , '03JO' , '03LI' , '03NB' , '03NM' , '03NO' , '03OR' , '03SB' , '03SC' , '03SE' , '03SG' , '03SK' , '03SM' , '03SN' , '03SS' , '03SY' , '03UP' , '03VA' , '03VB' , '03VL' , '03VT' , '3+ES' , '3PD' , '3PLV' , 'AECHD' , 'AECSD' , 'AL' , 'AMAY' , 'AMC' , 'ATP' , 'CENT' , 'CS' , 'CTCB' , 'CTCE' , 'DAVI' , 'DMA' , 'DMF' , 'DMY' , 'DTV' , 'EST' , 'EUROSPORT' , 'HDC1' , 'HDP1' , 'HDP2' , 'HUB' , 'KNL2' , 'KNVA' , 'LMH' , 'LNT' , 'MBNS' , 'MED' , 'MM' , 'MTG' , 'NAA' , 'NICK' , 'NVA' , 'OSP' , 'PBOY' , 'PMS' , 'PPL' , 'PSP' , 'Play' , 'RTR' , 'SFP1' , 'SFP2' , 'SPG' , 'SPTV' , 'T3LT' , 'T3LV' , 'T6LT' , 'T6LV' , 'T8LT' , 'TECHM' , 'TMD' , 'TV10' , 'TV1A' , 'TV1B' , 'TV1C' , 'TV1D' , 'TV1E' , 'TV1F' , 'TV1K' , 'TV1N' , 'TV1P' , 'TV1S' , 'TV2S' , 'TV3D' , 'TV3N' , 'TV3S' , 'TV5L' , 'TV6E' , 'TV6H' , 'TV6N' , 'TV6S' , 'TV8' , 'TVAE' , 'TVDP' , 'TVPB' , 'TVPU' , 'TVSL' , 'V1G' , 'V1TZ' , 'V3H' , 'V4N' , 'VEC' , 'VEPL' , 'VEPO' , 'VEXE' , 'VEXR' , 'VHIS' , 'VHPO' , 'VNC' , 'VNE' , 'VNH' , 'VNHD' , 'VNPO' , 'VODD' , 'VODE' , 'VODF' , 'VODN' , 'VODS' , 'VS2' , 'VS3' , 'VSAT' , 'VSD' , 'VSD2' , 'VSE' , 'VSG' , 'VSHD' , 'VSS' , 'WCIU' , 'YLE TV1' , 'ZTVS') 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|20:58:35.0295|DzX6vy|TMDDBA| jobs returned 1, searched in 00:00:00.2000224 t Information: 1220 : 9|20:58:35.2327|DzX6vy|TMDDBA| tasks returned 1, searched in 00:00:00.0271775 t Verbose: 1220 : 9|20:58:35.2327|DzX6vy|TMDDBA|imfx v3 API took 0.260s '/api/v3/search/workflow?_dc=1585684714750' t Transfer: 1220 : 9|20:58:43.1545|UbZRM~|TMDDBA|OAuth: /api/lookups/Presets?_dc=1585684723074 t Transfer: 1220 : 9|20:58:43.1545|UbZRM~|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 9|20:58:43.1545|UbZRM~|TMDDBA| OAuth authenticated t Transfer: 1220 : 9|20:58:43.1545|UbZRM~|TMDDBA| user TMDDBA. t Verbose: 1220 : 9|20:58:43.1545|UbZRM~|TMDDBA|OAuth. User logged in: TMDDBA t Transfer: 1220 : 9|20:58:43.1545|UbZRM~|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 9|20:58:43.1545|UbZRM~|TMDDBA| OAuth authenticated t Transfer: 1220 : 9|20:58:43.1545|UbZRM~|TMDDBA| user TMDDBA. t Verbose: 1220 : 9|20:58:43.1545|UbZRM~|TMDDBA|imfx v3 API took 0.039s '/api/lookups/Presets?_dc=1585684723074' t Transfer: 1220 : 9|20:58:51.0764|cX7xzO|TMDDBA|OAuth: /api/v3/search/workflow?_dc=1585684730850 t Transfer: 1220 : 9|20:58:51.0764|cX7xzO|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 9|20:58:51.0764|cX7xzO|TMDDBA| OAuth authenticated t Transfer: 1220 : 9|20:58:51.0764|cX7xzO|TMDDBA| user TMDDBA. t Verbose: 1220 : 9|20:58:51.0764|cX7xzO|TMDDBA|OAuth. User logged in: TMDDBA t Information: 1220 : 9|20:58:51.0764|cX7xzO|TMDDBA|V3Api.SearchWorkflows t Information: 1220 : 9|20:58:51.0764|cX7xzO|TMDDBA|V3Api.SearchGeneric t Transfer: 1220 : 9|20:58:51.0764|cX7xzO|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 9|20:58:51.0764|cX7xzO|TMDDBA| OAuth authenticated t Transfer: 1220 : 9|20:58:51.0764|cX7xzO|TMDDBA| user TMDDBA. t Information: 1220 : 9|20:58:51.0764|cX7xzO|TMDDBA|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_sched_indx in (2311) and j.cmb_stat not in (15,18,23) AND j.J_CLI_CODE in ('03BO' , '03GD' , '03GO' , '03HA' , '03JO' , '03LI' , '03NB' , '03NM' , '03NO' , '03OR' , '03SB' , '03SC' , '03SE' , '03SG' , '03SK' , '03SM' , '03SN' , '03SS' , '03SY' , '03UP' , '03VA' , '03VB' , '03VL' , '03VT' , '3+ES' , '3PD' , '3PLV' , 'AECHD' , 'AECSD' , 'AL' , 'AMAY' , 'AMC' , 'ATP' , 'CENT' , 'CS' , 'CTCB' , 'CTCE' , 'DAVI' , 'DMA' , 'DMF' , 'DMY' , 'DTV' , 'EST' , 'EUROSPORT' , 'HDC1' , 'HDP1' , 'HDP2' , 'HUB' , 'KNL2' , 'KNVA' , 'LMH' , 'LNT' , 'MBNS' , 'MED' , 'MM' , 'MTG' , 'NAA' , 'NICK' , 'NVA' , 'OSP' , 'PBOY' , 'PMS' , 'PPL' , 'PSP' , 'Play' , 'RTR' , 'SFP1' , 'SFP2' , 'SPG' , 'SPTV' , 'T3LT' , 'T3LV' , 'T6LT' , 'T6LV' , 'T8LT' , 'TECHM' , 'TMD' , 'TV10' , 'TV1A' , 'TV1B' , 'TV1C' , 'TV1D' , 'TV1E' , 'TV1F' , 'TV1K' , 'TV1N' , 'TV1P' , 'TV1S' , 'TV2S' , 'TV3D' , 'TV3N' , 'TV3S' , 'TV5L' , 'TV6E' , 'TV6H' , 'TV6N' , 'TV6S' , 'TV8' , 'TVAE' , 'TVDP' , 'TVPB' , 'TVPU' , 'TVSL' , 'V1G' , 'V1TZ' , 'V3H' , 'V4N' , 'VEC' , 'VEPL' , 'VEPO' , 'VEXE' , 'VEXR' , 'VHIS' , 'VHPO' , 'VNC' , 'VNE' , 'VNH' , 'VNHD' , 'VNPO' , 'VODD' , 'VODE' , 'VODF' , 'VODN' , 'VODS' , 'VS2' , 'VS3' , 'VSAT' , 'VSD' , 'VSD2' , 'VSE' , 'VSG' , 'VSHD' , 'VSS' , 'WCIU' , 'YLE TV1' , 'ZTVS') 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|20:58:51.0764|cX7xzO|TMDDBA| jobs returned 1, searched in 00:00:00.0057296 t Information: 1220 : 9|20:58:51.0764|cX7xzO|TMDDBA| tasks returned 1, searched in 00:00:00.0057983 t Verbose: 1220 : 9|20:58:51.0764|cX7xzO|TMDDBA|imfx v3 API took 0.018s '/api/v3/search/workflow?_dc=1585684730850' t Transfer: 1220 : 9|20:58:51.0764|x4HudJ|TMDDBA|OAuth: /api/user-preferences?_dc=1585684730933 t Transfer: 1220 : 9|20:58:51.0764|x4HudJ|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 9|20:58:51.0764|x4HudJ|TMDDBA| OAuth authenticated t Transfer: 1220 : 9|20:58:51.0764|x4HudJ|TMDDBA| user TMDDBA. t Verbose: 1220 : 9|20:58:51.0764|x4HudJ|TMDDBA|OAuth. User logged in: TMDDBA t Verbose: 1220 : 9|20:58:51.0764|x4HudJ|TMDDBA|StoreUserDataByKeys.. t Transfer: 1220 : 9|20:58:51.0764|x4HudJ|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 9|20:58:51.0764|x4HudJ|TMDDBA| OAuth authenticated t Transfer: 1220 : 9|20:58:51.0764|x4HudJ|TMDDBA| user TMDDBA. t Verbose: 1220 : 9|20:58:51.0764|x4HudJ|TMDDBA|imfx v3 API took 0.012s '/api/user-preferences?_dc=1585684730933' t Transfer: 1220 : 9|20:58:55.5452|BlDR~T|TMDDBA|OAuth: /api/v3/task/componentqc/107019?_dc=1585684735419 t Transfer: 1220 : 9|20:58:55.5452|BlDR~T|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 9|20:58:55.5452|BlDR~T|TMDDBA| OAuth authenticated t Transfer: 1220 : 9|20:58:55.5452|BlDR~T|TMDDBA| user TMDDBA. t Verbose: 1220 : 9|20:58:55.5452|BlDR~T|TMDDBA|OAuth. User logged in: TMDDBA t Information: 1220 : 9|20:58:55.5452|BlDR~T|TMDDBA|V3Api. GetComponentQc task: 107019 t Information: 1220 : 9|20:58:55.5452|BlDR~T|TMDDBA|SubtitleQcTask. LoadFromDb got Job 107018 and Subtitles 2. t Information: 1220 : 9|20:58:55.5452|BlDR~T|TMDDBA|SubtitleQcTask. LoadFromDb processing Media 298919. t Information: 1220 : 9|20:58:55.5452|BlDR~T|TMDDBA|SubtitleQcTask. LoadFromDb processing Media 298924. t Information: 1220 : 9|20:58:55.5452|BlDR~T|TMDDBA|LoadSubtitlesById. filename PMH_s1ep1_pt.scc device TimedText frame rate NTCS_DF t Information: 1220 : 9|20:58:55.5452|BlDR~T|TMDDBA|LoadSubtitlesById. Filename: PMH_s1ep1_pt.scc. Device TimedText. Timecode format NTCS_DF. Media ID 0. t Information: 1220 : 9|20:58:55.5452|BlDR~T|TMDDBA|GetCaptions. Start. Filename: PMH_s1ep1_pt.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|20:58:55.7483|BlDR~T|TMDDBA|GetCaptions. Convert required. Som 00:00:00. From: \\192.168.120.254\DemoFS\Digital Assets\TimedText\PMH_s1ep1_pt.scc to: C:\inetpub\wwwroot\imfxcore\timedtextcache\PMH_s1ep1_pt.scc_ntcs_df_0.xml t Information: 1220 : 9|20:58:55.7483|BlDR~T|TMDDBA|GetCaptions. Convertor lock aquired. t Information: 1220 : 9|20:58:56.1545|BlDR~T|TMDDBA|GetCaptions. File converted: \\192.168.120.254\DemoFS\Digital Assets\TimedText\PMH_s1ep1_pt.scc. Result: True t Information: 1220 : 9|20:58:56.1545|BlDR~T|TMDDBA|GetCaptions. In cache. Filename: C:\inetpub\wwwroot\imfxcore\timedtextcache\PMH_s1ep1_pt.scc_ntcs_df_0.xml t Information: 1220 : 9|20:58:56.1545|BlDR~T|TMDDBA|LoadSubtitlesById. Convertor lock acquired. t Information: 1220 : 9|20:58:56.3577|BlDR~T|TMDDBA|LoadSubtitlesById got 43 lines. t Information: 1220 : 9|20:58:56.3577|BlDR~T|TMDDBA|TM_MIS. LoadSubtitles for ID: 298919 t Information: 1220 : 9|20:58:56.3577|BlDR~T|TMDDBA|TM_MIS. LoadSubtitles for ID: 298919. 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 (298924)' t Information: 1220 : 9|20:58:56.3577|BlDR~T|TMDDBA| Subtitles added for ID: 298919, 298924 Unknown [0] : 'https://imfxv3tm.tmd.tv/getcaptions.aspx?f=PMH_s1ep1_pt.scc&som=00:00:00:00&storage=TimedText&modified=637188412040000000&tcf=3&id=298924&tmp=0'. t Information: 1220 : 9|20:58:56.3577|BlDR~T|TMDDBA|SubtitleQcTask. LoadFromDb finished. t Verbose: 1220 : 9|20:58:56.3577|BlDR~T|TMDDBA|imfx v3 API took 0.807s '/api/v3/task/componentqc/107019?_dc=1585684735419' t Transfer: 1220 : 9|20:58:56.7639|BlDR~T|TMDDBA|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\PmH_Demo001.mp4 subfolder t Transfer: 1220 : 9|20:58:56.7639|BlDR~T|TMDDBA| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/PmH_Demo001.mp4 t Transfer: 1220 : 9|20:58:56.7639|BlDR~T|TMDDBA|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/PmH_Demo001.mp4 t Transfer: 1220 : 9|20:58:56.7639|BlDR~T|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 9|20:58:56.7639|BlDR~T|TMDDBA| OAuth authenticated t Transfer: 1220 : 9|20:58:56.7639|BlDR~T|TMDDBA| user TMDDBA. t Transfer: 1220 : 9|20:58:56.7639|LELdpp|TMDDBA|OAuth: /api/v3/detailsview/Job/0?lang=en-GB&_dc=1585684736673 t Transfer: 1220 : 9|20:58:56.7639|LELdpp|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 9|20:58:56.7639|LELdpp|TMDDBA| OAuth authenticated t Transfer: 1220 : 9|20:58:56.7639|LELdpp|TMDDBA| user TMDDBA. t Verbose: 1220 : 9|20:58:56.7639|LELdpp|TMDDBA|OAuth. User logged in: TMDDBA t Verbose: 1220 : 9|20:58:56.7639|LELdpp|TMDDBA|imfx v3 API took 0.044s '/api/v3/detailsview/Job/0?lang=en-GB&_dc=1585684736673' t Transfer: 1220 : 9|20:58:56.9670|sI6ib1|TMDDBA|OAuth: /api/v3/detailsview/MediaDetails/[object Object]?lang=en-GB&_dc=1585684736759 t Transfer: 1220 : 9|20:58:56.9670|sI6ib1|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 9|20:58:56.9670|sI6ib1|TMDDBA| OAuth authenticated t Transfer: 1220 : 9|20:58:56.9670|sI6ib1|TMDDBA| user TMDDBA. t Verbose: 1220 : 9|20:58:56.9670|sI6ib1|TMDDBA|OAuth. User logged in: TMDDBA t Verbose: 1220 : 9|20:58:56.9670|sI6ib1|TMDDBA|imfx v3 API took 0.004s '/api/v3/detailsview/MediaDetails/%5Bobject%20Object%5D?lang=en-GB&_dc=1585684736759' t Transfer: 1220 : 9|20:58:56.9670|J~bvHC|TMDDBA|OAuth: /api/v3/layout/default/10?_dc=1585684736820 t Transfer: 1220 : 9|20:58:56.9670|J~bvHC|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 9|20:58:56.9670|J~bvHC|TMDDBA| OAuth authenticated t Transfer: 1220 : 9|20:58:56.9670|J~bvHC|TMDDBA| user TMDDBA. t Verbose: 1220 : 9|20:58:56.9670|J~bvHC|TMDDBA|OAuth. User logged in: TMDDBA t Information: 1220 : 9|20:58:56.9670|J~bvHC|TMDDBA|LoadDefaultDashboard. t Transfer: 1220 : 9|20:58:56.9670|J~bvHC|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 9|20:58:56.9670|J~bvHC|TMDDBA| OAuth authenticated t Transfer: 1220 : 9|20:58:56.9670|J~bvHC|TMDDBA| user TMDDBA. t Verbose: 1220 : 9|20:58:56.9670|J~bvHC|TMDDBA|imfx v3 API took 0.049s '/api/v3/layout/default/10?_dc=1585684736820' t Transfer: 1220 : 9|20:58:56.9670|cgA5j5|TMDDBA|OAuth: /api/lookups/FriendlyNames?_dc=1585684736926 t Transfer: 1220 : 9|20:58:56.9670|cgA5j5|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 9|20:58:56.9670|cgA5j5|TMDDBA| OAuth authenticated t Transfer: 1220 : 9|20:58:56.9670|cgA5j5|TMDDBA| user TMDDBA. t Verbose: 1220 : 9|20:58:56.9670|cgA5j5|TMDDBA|OAuth. User logged in: TMDDBA t Verbose: 1220 : 9|20:58:56.9670|cgA5j5|TMDDBA|imfx v3 API took 0.000s '/api/lookups/FriendlyNames?_dc=1585684736926' t Transfer: 1220 : 9|20:58:57.1702|WY_OlE|TMDDBA|OAuth: /api/lookups/FriendlyNames?_dc=1585684736968 t Transfer: 1220 : 9|20:58:57.1702|WY_OlE|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 9|20:58:57.1702|WY_OlE|TMDDBA| OAuth authenticated t Transfer: 1220 : 9|20:58:57.1702|WY_OlE|TMDDBA| user TMDDBA. t Verbose: 1220 : 9|20:58:57.1702|WY_OlE|TMDDBA|OAuth. User logged in: TMDDBA t Verbose: 1220 : 9|20:58:57.1702|WY_OlE|TMDDBA|imfx v3 API took 0.000s '/api/lookups/FriendlyNames?_dc=1585684736968' t Transfer: 1220 : 9|20:58:57.1702|BX5p_P|TMDDBA|OAuth: /api/lookups/Languages?_dc=1585684736986 t Transfer: 1220 : 9|20:58:57.1702|BX5p_P|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 9|20:58:57.1702|BX5p_P|TMDDBA| OAuth authenticated t Transfer: 1220 : 9|20:58:57.1702|BX5p_P|TMDDBA| user TMDDBA. t Verbose: 1220 : 9|20:58:57.1702|BX5p_P|TMDDBA|OAuth. User logged in: TMDDBA t Verbose: 1220 : 9|20:58:57.1702|BX5p_P|TMDDBA|imfx v3 API took 0.000s '/api/lookups/Languages?_dc=1585684736986' t Transfer: 1220 : 9|20:58:57.7795|6o_Ply|TMDDBA|OAuth: /api/user-group-preferences?globals=htmlplayerhotkeys,audioOnFrameForward&_dc=1585684737672 t Transfer: 1220 : 9|20:58:57.7795|6o_Ply|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 9|20:58:57.7795|6o_Ply|TMDDBA| OAuth authenticated t Transfer: 1220 : 9|20:58:57.7795|6o_Ply|TMDDBA| user TMDDBA. t Verbose: 1220 : 9|20:58:57.7795|6o_Ply|TMDDBA|OAuth. User logged in: TMDDBA t Transfer: 1220 : 9|20:58:57.7795|6o_Ply|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 9|20:58:57.7795|6o_Ply|TMDDBA| OAuth authenticated t Transfer: 1220 : 9|20:58:57.7795|6o_Ply|TMDDBA| user TMDDBA. t Verbose: 1220 : 9|20:58:57.7795|6o_Ply|TMDDBA|imfx v3 API took 0.011s '/api/user-group-preferences?globals=htmlplayerhotkeys,audioOnFrameForward&_dc=1585684737672' t Transfer: 1220 : 9|20:58:57.9827|8GU1oJ|TMDDBA|OAuth: /api/v3/mediavideo/298919?info=smudge&_dc=1585684737754 t Transfer: 1220 : 9|20:58:57.9827|8GU1oJ|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 9|20:58:57.9827|8GU1oJ|TMDDBA| OAuth authenticated t Transfer: 1220 : 9|20:58:57.9827|8GU1oJ|TMDDBA| user TMDDBA. t Verbose: 1220 : 9|20:58:57.9827|8GU1oJ|TMDDBA|OAuth. User logged in: TMDDBA t Transfer: 1220 : 9|20:58:57.9827|8GU1oJ|TMDDBA|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\PmH_Demo001.mp4 subfolder t Transfer: 1220 : 9|20:58:57.9827|8GU1oJ|TMDDBA| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/PmH_Demo001.mp4 t Transfer: 1220 : 9|20:58:57.9827|8GU1oJ|TMDDBA|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/PmH_Demo001.mp4 t Transfer: 1220 : 9|20:58:57.9827|8GU1oJ|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 9|20:58:57.9827|8GU1oJ|TMDDBA| OAuth authenticated t Transfer: 1220 : 9|20:58:57.9827|8GU1oJ|TMDDBA| user TMDDBA. t Verbose: 1220 : 9|20:58:57.9827|8GU1oJ|TMDDBA|imfx v3 API took 0.062s '/api/v3/mediavideo/298919?info=smudge&_dc=1585684737754' t Information: 1220 : 9|20:58:58.1858|IFWG8H||GetCaptionsForWeb. Filename: PMH_s1ep1_pt.scc. Device TimedText. Format WebVTT. Timecode format FPS24. Media ID 298924. Last Modified 3/3/2020 2:06:44 PM t Information: 1220 : 9|20:58:58.1858|IFWG8H||GetCaptions. Start. Filename: PMH_s1ep1_pt.scc. Cache path C:\inetpub\wwwroot\imfxcore\timedtextcache\. Storage path \\192.168.120.254\DemoFS\Digital Assets\TimedText. Last Modified 3/3/2020 2:06:44 PM t Information: 1220 : 9|20:58:58.1858|IFWG8H||GetCaptions. No refresh needed. Filename: C:\inetpub\wwwroot\imfxcore\timedtextcache\PMH_s1ep1_pt.scc_fps24_298924.vtt t Information: 1220 : 9|20:58:58.1858|IFWG8H||GetCaptions. In cache. Filename: C:\inetpub\wwwroot\imfxcore\timedtextcache\PMH_s1ep1_pt.scc_fps24_298924.vtt t Information: 1220 : 9|20:59:10.7795|uidGl8|TMDDBA|GetUserProfile. Id: 30000 t Transfer: 1220 : 9|20:59:10.7795|uidGl8|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 9|20:59:10.7795|uidGl8|TMDDBA| OAuth authenticated t Transfer: 1220 : 9|20:59:10.7795|uidGl8|TMDDBA| user TMDDBA. t Information: 1220 : 9|21:00:12.5295|MxVbjF|TMDDBA|GetUserProfile. Id: 30000 t Transfer: 1220 : 9|21:00:12.5295|MxVbjF|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 9|21:00:12.5295|MxVbjF|TMDDBA| OAuth authenticated t Transfer: 1220 : 9|21:00:12.5295|MxVbjF|TMDDBA| user TMDDBA. t Transfer: 1220 : 9|21:00:54.7795|mTAgi_|TMDDBA|OAuth: /api/v3/search/workflow?_dc=1585684854607 t Transfer: 1220 : 9|21:00:54.7795|mTAgi_|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 9|21:00:54.7795|mTAgi_|TMDDBA| OAuth authenticated t Transfer: 1220 : 9|21:00:54.7795|mTAgi_|TMDDBA| user TMDDBA. t Verbose: 1220 : 9|21:00:54.7795|mTAgi_|TMDDBA|OAuth. User logged in: TMDDBA t Information: 1220 : 9|21:00:54.7795|mTAgi_|TMDDBA|V3Api.SearchWorkflows t Information: 1220 : 9|21:00:54.7795|mTAgi_|TMDDBA|V3Api.SearchGeneric t Transfer: 1220 : 9|21:00:54.7795|mTAgi_|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 9|21:00:54.7795|mTAgi_|TMDDBA| OAuth authenticated t Transfer: 1220 : 9|21:00:54.7795|mTAgi_|TMDDBA| user TMDDBA. t Information: 1220 : 9|21:00:54.7795|mTAgi_|TMDDBA|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=107018 AND j.J_CLI_CODE in ('03BO' , '03GD' , '03GO' , '03HA' , '03JO' , '03LI' , '03NB' , '03NM' , '03NO' , '03OR' , '03SB' , '03SC' , '03SE' , '03SG' , '03SK' , '03SM' , '03SN' , '03SS' , '03SY' , '03UP' , '03VA' , '03VB' , '03VL' , '03VT' , '3+ES' , '3PD' , '3PLV' , 'AECHD' , 'AECSD' , 'AL' , 'AMAY' , 'AMC' , 'ATP' , 'CENT' , 'CS' , 'CTCB' , 'CTCE' , 'DAVI' , 'DMA' , 'DMF' , 'DMY' , 'DTV' , 'EST' , 'EUROSPORT' , 'HDC1' , 'HDP1' , 'HDP2' , 'HUB' , 'KNL2' , 'KNVA' , 'LMH' , 'LNT' , 'MBNS' , 'MED' , 'MM' , 'MTG' , 'NAA' , 'NICK' , 'NVA' , 'OSP' , 'PBOY' , 'PMS' , 'PPL' , 'PSP' , 'Play' , 'RTR' , 'SFP1' , 'SFP2' , 'SPG' , 'SPTV' , 'T3LT' , 'T3LV' , 'T6LT' , 'T6LV' , 'T8LT' , 'TECHM' , 'TMD' , 'TV10' , 'TV1A' , 'TV1B' , 'TV1C' , 'TV1D' , 'TV1E' , 'TV1F' , 'TV1K' , 'TV1N' , 'TV1P' , 'TV1S' , 'TV2S' , 'TV3D' , 'TV3N' , 'TV3S' , 'TV5L' , 'TV6E' , 'TV6H' , 'TV6N' , 'TV6S' , 'TV8' , 'TVAE' , 'TVDP' , 'TVPB' , 'TVPU' , 'TVSL' , 'V1G' , 'V1TZ' , 'V3H' , 'V4N' , 'VEC' , 'VEPL' , 'VEPO' , 'VEXE' , 'VEXR' , 'VHIS' , 'VHPO' , 'VNC' , 'VNE' , 'VNH' , 'VNHD' , 'VNPO' , 'VODD' , 'VODE' , 'VODF' , 'VODN' , 'VODS' , 'VS2' , 'VS3' , 'VSAT' , 'VSD' , 'VSD2' , 'VSE' , 'VSG' , 'VSHD' , 'VSS' , 'WCIU' , 'YLE TV1' , 'ZTVS') 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|21:00:54.7795|mTAgi_|TMDDBA| jobs returned 1, searched in 00:00:00.0075152 t Information: 1220 : 9|21:00:54.7795|mTAgi_|TMDDBA| tasks returned 1, searched in 00:00:00.0031740 t Verbose: 1220 : 9|21:00:54.7795|mTAgi_|TMDDBA|imfx v3 API took 0.025s '/api/v3/search/workflow?_dc=1585684854607' t Transfer: 1220 : 9|21:01:09.6077|prb_Fr|TMDDBA|OAuth: /api/v3/search/workflow?_dc=1585684869541 t Transfer: 1220 : 9|21:01:09.6077|prb_Fr|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 9|21:01:09.6077|prb_Fr|TMDDBA| OAuth authenticated t Transfer: 1220 : 9|21:01:09.6077|prb_Fr|TMDDBA| user TMDDBA. t Verbose: 1220 : 9|21:01:09.6077|prb_Fr|TMDDBA|OAuth. User logged in: TMDDBA t Information: 1220 : 9|21:01:09.6077|prb_Fr|TMDDBA|V3Api.SearchWorkflows t Information: 1220 : 9|21:01:09.6077|prb_Fr|TMDDBA|V3Api.SearchGeneric t Transfer: 1220 : 9|21:01:09.6077|prb_Fr|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 9|21:01:09.6077|prb_Fr|TMDDBA| OAuth authenticated t Transfer: 1220 : 9|21:01:09.6077|prb_Fr|TMDDBA| user TMDDBA. t Information: 1220 : 9|21:01:09.6077|prb_Fr|TMDDBA|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('31/03/2020','DD/MM/YYYY') and j.cmb_stat not in (15,18,23) AND j.J_CLI_CODE in ('03BO' , '03GD' , '03GO' , '03HA' , '03JO' , '03LI' , '03NB' , '03NM' , '03NO' , '03OR' , '03SB' , '03SC' , '03SE' , '03SG' , '03SK' , '03SM' , '03SN' , '03SS' , '03SY' , '03UP' , '03VA' , '03VB' , '03VL' , '03VT' , '3+ES' , '3PD' , '3PLV' , 'AECHD' , 'AECSD' , 'AL' , 'AMAY' , 'AMC' , 'ATP' , 'CENT' , 'CS' , 'CTCB' , 'CTCE' , 'DAVI' , 'DMA' , 'DMF' , 'DMY' , 'DTV' , 'EST' , 'EUROSPORT' , 'HDC1' , 'HDP1' , 'HDP2' , 'HUB' , 'KNL2' , 'KNVA' , 'LMH' , 'LNT' , 'MBNS' , 'MED' , 'MM' , 'MTG' , 'NAA' , 'NICK' , 'NVA' , 'OSP' , 'PBOY' , 'PMS' , 'PPL' , 'PSP' , 'Play' , 'RTR' , 'SFP1' , 'SFP2' , 'SPG' , 'SPTV' , 'T3LT' , 'T3LV' , 'T6LT' , 'T6LV' , 'T8LT' , 'TECHM' , 'TMD' , 'TV10' , 'TV1A' , 'TV1B' , 'TV1C' , 'TV1D' , 'TV1E' , 'TV1F' , 'TV1K' , 'TV1N' , 'TV1P' , 'TV1S' , 'TV2S' , 'TV3D' , 'TV3N' , 'TV3S' , 'TV5L' , 'TV6E' , 'TV6H' , 'TV6N' , 'TV6S' , 'TV8' , 'TVAE' , 'TVDP' , 'TVPB' , 'TVPU' , 'TVSL' , 'V1G' , 'V1TZ' , 'V3H' , 'V4N' , 'VEC' , 'VEPL' , 'VEPO' , 'VEXE' , 'VEXR' , 'VHIS' , 'VHPO' , 'VNC' , 'VNE' , 'VNH' , 'VNHD' , 'VNPO' , 'VODD' , 'VODE' , 'VODF' , 'VODN' , 'VODS' , 'VS2' , 'VS3' , 'VSAT' , 'VSD' , 'VSD2' , 'VSE' , 'VSG' , 'VSHD' , 'VSS' , 'WCIU' , 'YLE TV1' , 'ZTVS') 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|21:01:09.6077|prb_Fr|TMDDBA| jobs returned 16, searched in 00:00:00.0128054 t Information: 1220 : 9|21:01:09.8108|prb_Fr|TMDDBA|TechReports is not found. ID: 96. t Information: 1220 : 9|21:01:09.8108|prb_Fr|TMDDBA|TechReports is not found. ID: 41. t Information: 1220 : 9|21:01:09.8108|prb_Fr|TMDDBA|TechReports is not found. ID: 1633. t Information: 1220 : 9|21:01:09.8108|prb_Fr|TMDDBA|TechReports is not found. ID: 1300. t Information: 1220 : 9|21:01:09.8108|prb_Fr|TMDDBA|TechReports is not found. ID: 116. t Information: 1220 : 9|21:01:09.8108|prb_Fr|TMDDBA|TechReports is not found. ID: 673. t Information: 1220 : 9|21:01:09.8108|prb_Fr|TMDDBA|TechReports is not found. ID: 1301. t Information: 1220 : 9|21:01:09.8108|prb_Fr|TMDDBA| tasks returned 16, searched in 00:00:00.0435227 t Verbose: 1220 : 9|21:01:09.8108|prb_Fr|TMDDBA|imfx v3 API took 0.062s '/api/v3/search/workflow?_dc=1585684869541' t Transfer: 1220 : 9|21:01:09.8108|LHRqFg|TMDDBA|OAuth: /api/user-preferences?_dc=1585684869734 t Transfer: 1220 : 9|21:01:09.8108|LHRqFg|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 9|21:01:09.8108|LHRqFg|TMDDBA| OAuth authenticated t Transfer: 1220 : 9|21:01:09.8108|LHRqFg|TMDDBA| user TMDDBA. t Verbose: 1220 : 9|21:01:09.8108|LHRqFg|TMDDBA|OAuth. User logged in: TMDDBA t Verbose: 1220 : 9|21:01:09.8108|LHRqFg|TMDDBA|StoreUserDataByKeys.. t Transfer: 1220 : 9|21:01:09.8108|LHRqFg|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 9|21:01:09.8108|LHRqFg|TMDDBA| OAuth authenticated t Transfer: 1220 : 9|21:01:09.8108|LHRqFg|TMDDBA| user TMDDBA. t Verbose: 1220 : 9|21:01:09.8108|LHRqFg|TMDDBA|imfx v3 API took 0.013s '/api/user-preferences?_dc=1585684869734' t Transfer: 1220 : 9|21:01:12.2483|1Br_9W|TMDDBA|OAuth: /api/v3/task/componentqc/109042?_dc=1585684872153 t Transfer: 1220 : 9|21:01:12.2483|1Br_9W|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 9|21:01:12.2483|1Br_9W|TMDDBA| OAuth authenticated t Transfer: 1220 : 9|21:01:12.2483|1Br_9W|TMDDBA| user TMDDBA. t Verbose: 1220 : 9|21:01:12.2483|1Br_9W|TMDDBA|OAuth. User logged in: TMDDBA t Information: 1220 : 9|21:01:12.2483|1Br_9W|TMDDBA|V3Api. GetComponentQc task: 109042 t Information: 1220 : 9|21:01:12.2483|1Br_9W|TMDDBA|SubtitleQcTask. LoadFromDb got Job 109041 and Subtitles 2. t Verbose: 1220 : 9|21:01:12.2483|1Br_9W|TMDDBA|imfx v3 API took 0.028s '/api/v3/task/componentqc/109042?_dc=1585684872153' t Information: 1220 : 9|21:01:12.2483|1Br_9W|TMDDBA|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.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.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.d__6.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Web.Http.Filters.ActionFilterAttribute.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.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.d__6.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Web.Http.Filters.ActionFilterAttribute.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.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.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.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.d__6.MoveNext() [GET] https://imfxv3tm.tmd.tv/api/v3/task/componentqc/109042?_dc=1585684872153 System.Web.Http.Routing.HttpRoute t Transfer: 1220 : 9|21:01:14.2952|1CEtqN|TMDDBA|OAuth: /api/v3/search/workflow?_dc=1585684874149 t Transfer: 1220 : 9|21:01:14.2952|1CEtqN|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 9|21:01:14.2952|1CEtqN|TMDDBA| OAuth authenticated t Transfer: 1220 : 9|21:01:14.2952|1CEtqN|TMDDBA| user TMDDBA. t Verbose: 1220 : 9|21:01:14.2952|1CEtqN|TMDDBA|OAuth. User logged in: TMDDBA t Information: 1220 : 9|21:01:14.2952|1CEtqN|TMDDBA|V3Api.SearchWorkflows t Information: 1220 : 9|21:01:14.2952|1CEtqN|TMDDBA|V3Api.SearchGeneric t Transfer: 1220 : 9|21:01:14.2952|1CEtqN|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 9|21:01:14.2952|1CEtqN|TMDDBA| OAuth authenticated t Transfer: 1220 : 9|21:01:14.2952|1CEtqN|TMDDBA| user TMDDBA. t Information: 1220 : 9|21:01:14.2952|yNDklk|TMDDBA|GetUserProfile. Id: 30000 t Transfer: 1220 : 9|21:01:14.2952|yNDklk|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 9|21:01:14.2952|yNDklk|TMDDBA| OAuth authenticated t Transfer: 1220 : 9|21:01:14.2952|yNDklk|TMDDBA| user TMDDBA. t Information: 1220 : 9|21:01:14.4983|1CEtqN|TMDDBA|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=109041 AND j.J_CLI_CODE in ('03BO' , '03GD' , '03GO' , '03HA' , '03JO' , '03LI' , '03NB' , '03NM' , '03NO' , '03OR' , '03SB' , '03SC' , '03SE' , '03SG' , '03SK' , '03SM' , '03SN' , '03SS' , '03SY' , '03UP' , '03VA' , '03VB' , '03VL' , '03VT' , '3+ES' , '3PD' , '3PLV' , 'AECHD' , 'AECSD' , 'AL' , 'AMAY' , 'AMC' , 'ATP' , 'CENT' , 'CS' , 'CTCB' , 'CTCE' , 'DAVI' , 'DMA' , 'DMF' , 'DMY' , 'DTV' , 'EST' , 'EUROSPORT' , 'HDC1' , 'HDP1' , 'HDP2' , 'HUB' , 'KNL2' , 'KNVA' , 'LMH' , 'LNT' , 'MBNS' , 'MED' , 'MM' , 'MTG' , 'NAA' , 'NICK' , 'NVA' , 'OSP' , 'PBOY' , 'PMS' , 'PPL' , 'PSP' , 'Play' , 'RTR' , 'SFP1' , 'SFP2' , 'SPG' , 'SPTV' , 'T3LT' , 'T3LV' , 'T6LT' , 'T6LV' , 'T8LT' , 'TECHM' , 'TMD' , 'TV10' , 'TV1A' , 'TV1B' , 'TV1C' , 'TV1D' , 'TV1E' , 'TV1F' , 'TV1K' , 'TV1N' , 'TV1P' , 'TV1S' , 'TV2S' , 'TV3D' , 'TV3N' , 'TV3S' , 'TV5L' , 'TV6E' , 'TV6H' , 'TV6N' , 'TV6S' , 'TV8' , 'TVAE' , 'TVDP' , 'TVPB' , 'TVPU' , 'TVSL' , 'V1G' , 'V1TZ' , 'V3H' , 'V4N' , 'VEC' , 'VEPL' , 'VEPO' , 'VEXE' , 'VEXR' , 'VHIS' , 'VHPO' , 'VNC' , 'VNE' , 'VNH' , 'VNHD' , 'VNPO' , 'VODD' , 'VODE' , 'VODF' , 'VODN' , 'VODS' , 'VS2' , 'VS3' , 'VSAT' , 'VSD' , 'VSD2' , 'VSE' , 'VSG' , 'VSHD' , 'VSS' , 'WCIU' , 'YLE TV1' , 'ZTVS') 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|21:01:14.7014|1CEtqN|TMDDBA| jobs returned 1, searched in 00:00:00.2829239 t Information: 1220 : 9|21:01:14.7014|1CEtqN|TMDDBA| tasks returned 1, searched in 00:00:00.0268791 t Verbose: 1220 : 9|21:01:14.7014|1CEtqN|TMDDBA|imfx v3 API took 0.419s '/api/v3/search/workflow?_dc=1585684874149' t Transfer: 1220 : 9|21:01:52.4827|ldyR4s|TMDDBA|OAuth: /api/v3/search/workflow?_dc=1585684912403 t Transfer: 1220 : 9|21:01:52.4827|ldyR4s|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 9|21:01:52.4827|ldyR4s|TMDDBA| OAuth authenticated t Transfer: 1220 : 9|21:01:52.4827|ldyR4s|TMDDBA| user TMDDBA. t Verbose: 1220 : 9|21:01:52.4827|ldyR4s|TMDDBA|OAuth. User logged in: TMDDBA t Information: 1220 : 9|21:01:52.4827|ldyR4s|TMDDBA|V3Api.SearchWorkflows t Information: 1220 : 9|21:01:52.4827|ldyR4s|TMDDBA|V3Api.SearchGeneric t Transfer: 1220 : 9|21:01:52.4827|ldyR4s|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 9|21:01:52.4827|ldyR4s|TMDDBA| OAuth authenticated t Transfer: 1220 : 9|21:01:52.4827|ldyR4s|TMDDBA| user TMDDBA. t Information: 1220 : 9|21:01:52.4827|ldyR4s|TMDDBA|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('31/03/2020','DD/MM/YYYY') and j.cmb_stat not in (15,18,23) AND j.J_CLI_CODE in ('03BO' , '03GD' , '03GO' , '03HA' , '03JO' , '03LI' , '03NB' , '03NM' , '03NO' , '03OR' , '03SB' , '03SC' , '03SE' , '03SG' , '03SK' , '03SM' , '03SN' , '03SS' , '03SY' , '03UP' , '03VA' , '03VB' , '03VL' , '03VT' , '3+ES' , '3PD' , '3PLV' , 'AECHD' , 'AECSD' , 'AL' , 'AMAY' , 'AMC' , 'ATP' , 'CENT' , 'CS' , 'CTCB' , 'CTCE' , 'DAVI' , 'DMA' , 'DMF' , 'DMY' , 'DTV' , 'EST' , 'EUROSPORT' , 'HDC1' , 'HDP1' , 'HDP2' , 'HUB' , 'KNL2' , 'KNVA' , 'LMH' , 'LNT' , 'MBNS' , 'MED' , 'MM' , 'MTG' , 'NAA' , 'NICK' , 'NVA' , 'OSP' , 'PBOY' , 'PMS' , 'PPL' , 'PSP' , 'Play' , 'RTR' , 'SFP1' , 'SFP2' , 'SPG' , 'SPTV' , 'T3LT' , 'T3LV' , 'T6LT' , 'T6LV' , 'T8LT' , 'TECHM' , 'TMD' , 'TV10' , 'TV1A' , 'TV1B' , 'TV1C' , 'TV1D' , 'TV1E' , 'TV1F' , 'TV1K' , 'TV1N' , 'TV1P' , 'TV1S' , 'TV2S' , 'TV3D' , 'TV3N' , 'TV3S' , 'TV5L' , 'TV6E' , 'TV6H' , 'TV6N' , 'TV6S' , 'TV8' , 'TVAE' , 'TVDP' , 'TVPB' , 'TVPU' , 'TVSL' , 'V1G' , 'V1TZ' , 'V3H' , 'V4N' , 'VEC' , 'VEPL' , 'VEPO' , 'VEXE' , 'VEXR' , 'VHIS' , 'VHPO' , 'VNC' , 'VNE' , 'VNH' , 'VNHD' , 'VNPO' , 'VODD' , 'VODE' , 'VODF' , 'VODN' , 'VODS' , 'VS2' , 'VS3' , 'VSAT' , 'VSD' , 'VSD2' , 'VSE' , 'VSG' , 'VSHD' , 'VSS' , 'WCIU' , 'YLE TV1' , 'ZTVS') 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|21:01:52.4983|ldyR4s|TMDDBA| jobs returned 17, searched in 00:00:00.0124415 t Information: 1220 : 9|21:01:52.7014|ldyR4s|TMDDBA|TechReports is not found. ID: 96. t Information: 1220 : 9|21:01:52.7014|ldyR4s|TMDDBA|TechReports is not found. ID: 41. t Information: 1220 : 9|21:01:52.7014|ldyR4s|TMDDBA|TechReports is not found. ID: 1633. t Information: 1220 : 9|21:01:52.7014|ldyR4s|TMDDBA|TechReports is not found. ID: 1300. t Information: 1220 : 9|21:01:52.7014|ldyR4s|TMDDBA|TechReports is not found. ID: 116. t Information: 1220 : 9|21:01:52.7014|ldyR4s|TMDDBA|TechReports is not found. ID: 673. t Information: 1220 : 9|21:01:52.7014|ldyR4s|TMDDBA|TechReports is not found. ID: 1301. t Information: 1220 : 9|21:01:52.7014|ldyR4s|TMDDBA| tasks returned 17, searched in 00:00:00.0453816 t Verbose: 1220 : 9|21:01:52.7014|ldyR4s|TMDDBA|imfx v3 API took 0.064s '/api/v3/search/workflow?_dc=1585684912403' t Transfer: 1220 : 9|21:01:52.7014|s_dFxP|TMDDBA|OAuth: /api/user-preferences?_dc=1585684912622 t Transfer: 1220 : 9|21:01:52.7014|s_dFxP|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 9|21:01:52.7014|s_dFxP|TMDDBA| OAuth authenticated t Transfer: 1220 : 9|21:01:52.7014|s_dFxP|TMDDBA| user TMDDBA. t Verbose: 1220 : 9|21:01:52.7014|s_dFxP|TMDDBA|OAuth. User logged in: TMDDBA t Verbose: 1220 : 9|21:01:52.7014|s_dFxP|TMDDBA|StoreUserDataByKeys.. t Transfer: 1220 : 9|21:01:52.7014|s_dFxP|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 9|21:01:52.7014|s_dFxP|TMDDBA| OAuth authenticated t Transfer: 1220 : 9|21:01:52.7014|s_dFxP|TMDDBA| user TMDDBA. t Verbose: 1220 : 9|21:01:52.7014|s_dFxP|TMDDBA|imfx v3 API took 0.014s '/api/user-preferences?_dc=1585684912622' t Transfer: 1220 : 9|21:01:55.7483|fVUu~j|TMDDBA|OAuth: /api/v3/task/componentqc/109047?_dc=1585684915588 t Transfer: 1220 : 9|21:01:55.7483|fVUu~j|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 9|21:01:55.7483|fVUu~j|TMDDBA| OAuth authenticated t Transfer: 1220 : 9|21:01:55.7483|fVUu~j|TMDDBA| user TMDDBA. t Verbose: 1220 : 9|21:01:55.7483|fVUu~j|TMDDBA|OAuth. User logged in: TMDDBA t Information: 1220 : 9|21:01:55.7483|fVUu~j|TMDDBA|V3Api. GetComponentQc task: 109047 t Information: 1220 : 9|21:01:55.7483|fVUu~j|TMDDBA|SubtitleQcTask. LoadFromDb got Job 109046 and Subtitles 2. t Verbose: 1220 : 9|21:01:55.7483|fVUu~j|TMDDBA|imfx v3 API took 0.018s '/api/v3/task/componentqc/109047?_dc=1585684915588' t Information: 1220 : 9|21:01:55.7483|fVUu~j|TMDDBA|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.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.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.d__6.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Web.Http.Filters.ActionFilterAttribute.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.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.d__6.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Web.Http.Filters.ActionFilterAttribute.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.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.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.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.d__6.MoveNext() [GET] https://imfxv3tm.tmd.tv/api/v3/task/componentqc/109047?_dc=1585684915588 System.Web.Http.Routing.HttpRoute t Transfer: 1220 : 9|21:01:58.9983|e5o7ZN|TMDDBA|OAuth: /api/v3/search/workflow?_dc=1585684918884 t Transfer: 1220 : 9|21:01:58.9983|e5o7ZN|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 9|21:01:58.9983|e5o7ZN|TMDDBA| OAuth authenticated t Transfer: 1220 : 9|21:01:58.9983|e5o7ZN|TMDDBA| user TMDDBA. t Verbose: 1220 : 9|21:01:58.9983|e5o7ZN|TMDDBA|OAuth. User logged in: TMDDBA t Information: 1220 : 9|21:01:58.9983|e5o7ZN|TMDDBA|V3Api.SearchWorkflows t Information: 1220 : 9|21:01:58.9983|e5o7ZN|TMDDBA|V3Api.SearchGeneric t Transfer: 1220 : 9|21:01:58.9983|e5o7ZN|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 9|21:01:58.9983|e5o7ZN|TMDDBA| OAuth authenticated t Transfer: 1220 : 9|21:01:58.9983|e5o7ZN|TMDDBA| user TMDDBA. t Information: 1220 : 9|21:01:58.9983|e5o7ZN|TMDDBA|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=109046 AND j.J_CLI_CODE in ('03BO' , '03GD' , '03GO' , '03HA' , '03JO' , '03LI' , '03NB' , '03NM' , '03NO' , '03OR' , '03SB' , '03SC' , '03SE' , '03SG' , '03SK' , '03SM' , '03SN' , '03SS' , '03SY' , '03UP' , '03VA' , '03VB' , '03VL' , '03VT' , '3+ES' , '3PD' , '3PLV' , 'AECHD' , 'AECSD' , 'AL' , 'AMAY' , 'AMC' , 'ATP' , 'CENT' , 'CS' , 'CTCB' , 'CTCE' , 'DAVI' , 'DMA' , 'DMF' , 'DMY' , 'DTV' , 'EST' , 'EUROSPORT' , 'HDC1' , 'HDP1' , 'HDP2' , 'HUB' , 'KNL2' , 'KNVA' , 'LMH' , 'LNT' , 'MBNS' , 'MED' , 'MM' , 'MTG' , 'NAA' , 'NICK' , 'NVA' , 'OSP' , 'PBOY' , 'PMS' , 'PPL' , 'PSP' , 'Play' , 'RTR' , 'SFP1' , 'SFP2' , 'SPG' , 'SPTV' , 'T3LT' , 'T3LV' , 'T6LT' , 'T6LV' , 'T8LT' , 'TECHM' , 'TMD' , 'TV10' , 'TV1A' , 'TV1B' , 'TV1C' , 'TV1D' , 'TV1E' , 'TV1F' , 'TV1K' , 'TV1N' , 'TV1P' , 'TV1S' , 'TV2S' , 'TV3D' , 'TV3N' , 'TV3S' , 'TV5L' , 'TV6E' , 'TV6H' , 'TV6N' , 'TV6S' , 'TV8' , 'TVAE' , 'TVDP' , 'TVPB' , 'TVPU' , 'TVSL' , 'V1G' , 'V1TZ' , 'V3H' , 'V4N' , 'VEC' , 'VEPL' , 'VEPO' , 'VEXE' , 'VEXR' , 'VHIS' , 'VHPO' , 'VNC' , 'VNE' , 'VNH' , 'VNHD' , 'VNPO' , 'VODD' , 'VODE' , 'VODF' , 'VODN' , 'VODS' , 'VS2' , 'VS3' , 'VSAT' , 'VSD' , 'VSD2' , 'VSE' , 'VSG' , 'VSHD' , 'VSS' , 'WCIU' , 'YLE TV1' , 'ZTVS') 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|21:01:59.2014|e5o7ZN|TMDDBA| jobs returned 1, searched in 00:00:00.2081131 t Information: 1220 : 9|21:01:59.2014|e5o7ZN|TMDDBA| tasks returned 1, searched in 00:00:00.0188199 t Verbose: 1220 : 9|21:01:59.2014|e5o7ZN|TMDDBA|imfx v3 API took 0.258s '/api/v3/search/workflow?_dc=1585684918884' t Information: 1220 : 9|21:02:16.0609|Jf6l7T|TMDDBA|GetUserProfile. Id: 30000 t Transfer: 1220 : 9|21:02:16.0609|Jf6l7T|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 9|21:02:16.0609|Jf6l7T|TMDDBA| OAuth authenticated t Transfer: 1220 : 9|21:02:16.0609|Jf6l7T|TMDDBA| user TMDDBA. t Transfer: 1220 : 9|21:02:54.0452|FZP_44|TMDDBA|OAuth: /api/v3/search/workflow?_dc=1585684973853 t Transfer: 1220 : 9|21:02:54.0452|FZP_44|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 9|21:02:54.0452|FZP_44|TMDDBA| OAuth authenticated t Transfer: 1220 : 9|21:02:54.0452|FZP_44|TMDDBA| user TMDDBA. t Verbose: 1220 : 9|21:02:54.0452|FZP_44|TMDDBA|OAuth. User logged in: TMDDBA t Information: 1220 : 9|21:02:54.0452|FZP_44|TMDDBA|V3Api.SearchWorkflows t Information: 1220 : 9|21:02:54.0452|FZP_44|TMDDBA|V3Api.SearchGeneric t Transfer: 1220 : 9|21:02:54.0452|FZP_44|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 9|21:02:54.0452|FZP_44|TMDDBA| OAuth authenticated t Transfer: 1220 : 9|21:02:54.0452|FZP_44|TMDDBA| user TMDDBA. t Information: 1220 : 9|21:02:54.0452|FZP_44|TMDDBA|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('31/03/2020','DD/MM/YYYY') and j.cmb_stat not in (15,18,23) AND j.J_CLI_CODE in ('03BO' , '03GD' , '03GO' , '03HA' , '03JO' , '03LI' , '03NB' , '03NM' , '03NO' , '03OR' , '03SB' , '03SC' , '03SE' , '03SG' , '03SK' , '03SM' , '03SN' , '03SS' , '03SY' , '03UP' , '03VA' , '03VB' , '03VL' , '03VT' , '3+ES' , '3PD' , '3PLV' , 'AECHD' , 'AECSD' , 'AL' , 'AMAY' , 'AMC' , 'ATP' , 'CENT' , 'CS' , 'CTCB' , 'CTCE' , 'DAVI' , 'DMA' , 'DMF' , 'DMY' , 'DTV' , 'EST' , 'EUROSPORT' , 'HDC1' , 'HDP1' , 'HDP2' , 'HUB' , 'KNL2' , 'KNVA' , 'LMH' , 'LNT' , 'MBNS' , 'MED' , 'MM' , 'MTG' , 'NAA' , 'NICK' , 'NVA' , 'OSP' , 'PBOY' , 'PMS' , 'PPL' , 'PSP' , 'Play' , 'RTR' , 'SFP1' , 'SFP2' , 'SPG' , 'SPTV' , 'T3LT' , 'T3LV' , 'T6LT' , 'T6LV' , 'T8LT' , 'TECHM' , 'TMD' , 'TV10' , 'TV1A' , 'TV1B' , 'TV1C' , 'TV1D' , 'TV1E' , 'TV1F' , 'TV1K' , 'TV1N' , 'TV1P' , 'TV1S' , 'TV2S' , 'TV3D' , 'TV3N' , 'TV3S' , 'TV5L' , 'TV6E' , 'TV6H' , 'TV6N' , 'TV6S' , 'TV8' , 'TVAE' , 'TVDP' , 'TVPB' , 'TVPU' , 'TVSL' , 'V1G' , 'V1TZ' , 'V3H' , 'V4N' , 'VEC' , 'VEPL' , 'VEPO' , 'VEXE' , 'VEXR' , 'VHIS' , 'VHPO' , 'VNC' , 'VNE' , 'VNH' , 'VNHD' , 'VNPO' , 'VODD' , 'VODE' , 'VODF' , 'VODN' , 'VODS' , 'VS2' , 'VS3' , 'VSAT' , 'VSD' , 'VSD2' , 'VSE' , 'VSG' , 'VSHD' , 'VSS' , 'WCIU' , 'YLE TV1' , 'ZTVS') 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|21:02:54.0452|FZP_44|TMDDBA| jobs returned 18, searched in 00:00:00.0129972 t Information: 1220 : 9|21:02:54.0452|FZP_44|TMDDBA|TechReports is not found. ID: 96. t Information: 1220 : 9|21:02:54.0452|FZP_44|TMDDBA|TechReports is not found. ID: 41. t Information: 1220 : 9|21:02:54.0452|FZP_44|TMDDBA|TechReports is not found. ID: 1633. t Information: 1220 : 9|21:02:54.0452|FZP_44|TMDDBA|TechReports is not found. ID: 1300. t Information: 1220 : 9|21:02:54.0452|FZP_44|TMDDBA|TechReports is not found. ID: 116. t Information: 1220 : 9|21:02:54.0452|FZP_44|TMDDBA|TechReports is not found. ID: 673. t Information: 1220 : 9|21:02:54.0452|FZP_44|TMDDBA|TechReports is not found. ID: 1301. t Information: 1220 : 9|21:02:54.0452|FZP_44|TMDDBA| tasks returned 18, searched in 00:00:00.0486317 t Verbose: 1220 : 9|21:02:54.0452|FZP_44|TMDDBA|imfx v3 API took 0.068s '/api/v3/search/workflow?_dc=1585684973853' t Transfer: 1220 : 9|21:02:54.2483|D7fcup|TMDDBA|OAuth: /api/user-preferences?_dc=1585684974032 t Transfer: 1220 : 9|21:02:54.2483|D7fcup|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 9|21:02:54.2483|D7fcup|TMDDBA| OAuth authenticated t Transfer: 1220 : 9|21:02:54.2483|D7fcup|TMDDBA| user TMDDBA. t Verbose: 1220 : 9|21:02:54.2483|D7fcup|TMDDBA|OAuth. User logged in: TMDDBA t Verbose: 1220 : 9|21:02:54.2483|D7fcup|TMDDBA|StoreUserDataByKeys.. t Transfer: 1220 : 9|21:02:54.2483|D7fcup|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 9|21:02:54.2483|D7fcup|TMDDBA| OAuth authenticated t Transfer: 1220 : 9|21:02:54.2483|D7fcup|TMDDBA| user TMDDBA. t Verbose: 1220 : 9|21:02:54.2483|D7fcup|TMDDBA|imfx v3 API took 0.010s '/api/user-preferences?_dc=1585684974032' t Transfer: 1220 : 9|21:02:56.4827|RMgJQJ|TMDDBA|OAuth: /api/v3/task/componentqc/109052?_dc=1585684976296 t Transfer: 1220 : 9|21:02:56.4827|RMgJQJ|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 9|21:02:56.4827|RMgJQJ|TMDDBA| OAuth authenticated t Transfer: 1220 : 9|21:02:56.4827|RMgJQJ|TMDDBA| user TMDDBA. t Verbose: 1220 : 9|21:02:56.4827|RMgJQJ|TMDDBA|OAuth. User logged in: TMDDBA t Information: 1220 : 9|21:02:56.4827|RMgJQJ|TMDDBA|V3Api. GetComponentQc task: 109052 t Information: 1220 : 9|21:02:56.4827|RMgJQJ|TMDDBA|SubtitleQcTask. LoadFromDb got Job 109051 and Subtitles 2. t Verbose: 1220 : 9|21:02:56.4827|RMgJQJ|TMDDBA|imfx v3 API took 0.022s '/api/v3/task/componentqc/109052?_dc=1585684976296' t Information: 1220 : 9|21:02:56.4827|RMgJQJ|TMDDBA|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.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.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.d__6.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Web.Http.Filters.ActionFilterAttribute.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.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.d__6.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Web.Http.Filters.ActionFilterAttribute.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.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.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.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.d__6.MoveNext() [GET] https://imfxv3tm.tmd.tv/api/v3/task/componentqc/109052?_dc=1585684976296 System.Web.Http.Routing.HttpRoute t Transfer: 1220 : 9|21:02:59.5295|TXGG0K|TMDDBA|OAuth: /api/v3/search/workflow?_dc=1585684979407 t Transfer: 1220 : 9|21:02:59.5295|TXGG0K|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 9|21:02:59.5295|TXGG0K|TMDDBA| OAuth authenticated t Transfer: 1220 : 9|21:02:59.5295|TXGG0K|TMDDBA| user TMDDBA. t Verbose: 1220 : 9|21:02:59.5295|TXGG0K|TMDDBA|OAuth. User logged in: TMDDBA t Information: 1220 : 9|21:02:59.5295|TXGG0K|TMDDBA|V3Api.SearchWorkflows t Information: 1220 : 9|21:02:59.5295|TXGG0K|TMDDBA|V3Api.SearchGeneric t Transfer: 1220 : 9|21:02:59.5295|TXGG0K|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 9|21:02:59.5295|TXGG0K|TMDDBA| OAuth authenticated t Transfer: 1220 : 9|21:02:59.5295|TXGG0K|TMDDBA| user TMDDBA. t Information: 1220 : 9|21:02:59.5295|TXGG0K|TMDDBA|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=109051 AND j.J_CLI_CODE in ('03BO' , '03GD' , '03GO' , '03HA' , '03JO' , '03LI' , '03NB' , '03NM' , '03NO' , '03OR' , '03SB' , '03SC' , '03SE' , '03SG' , '03SK' , '03SM' , '03SN' , '03SS' , '03SY' , '03UP' , '03VA' , '03VB' , '03VL' , '03VT' , '3+ES' , '3PD' , '3PLV' , 'AECHD' , 'AECSD' , 'AL' , 'AMAY' , 'AMC' , 'ATP' , 'CENT' , 'CS' , 'CTCB' , 'CTCE' , 'DAVI' , 'DMA' , 'DMF' , 'DMY' , 'DTV' , 'EST' , 'EUROSPORT' , 'HDC1' , 'HDP1' , 'HDP2' , 'HUB' , 'KNL2' , 'KNVA' , 'LMH' , 'LNT' , 'MBNS' , 'MED' , 'MM' , 'MTG' , 'NAA' , 'NICK' , 'NVA' , 'OSP' , 'PBOY' , 'PMS' , 'PPL' , 'PSP' , 'Play' , 'RTR' , 'SFP1' , 'SFP2' , 'SPG' , 'SPTV' , 'T3LT' , 'T3LV' , 'T6LT' , 'T6LV' , 'T8LT' , 'TECHM' , 'TMD' , 'TV10' , 'TV1A' , 'TV1B' , 'TV1C' , 'TV1D' , 'TV1E' , 'TV1F' , 'TV1K' , 'TV1N' , 'TV1P' , 'TV1S' , 'TV2S' , 'TV3D' , 'TV3N' , 'TV3S' , 'TV5L' , 'TV6E' , 'TV6H' , 'TV6N' , 'TV6S' , 'TV8' , 'TVAE' , 'TVDP' , 'TVPB' , 'TVPU' , 'TVSL' , 'V1G' , 'V1TZ' , 'V3H' , 'V4N' , 'VEC' , 'VEPL' , 'VEPO' , 'VEXE' , 'VEXR' , 'VHIS' , 'VHPO' , 'VNC' , 'VNE' , 'VNH' , 'VNHD' , 'VNPO' , 'VODD' , 'VODE' , 'VODF' , 'VODN' , 'VODS' , 'VS2' , 'VS3' , 'VSAT' , 'VSD' , 'VSD2' , 'VSE' , 'VSG' , 'VSHD' , 'VSS' , 'WCIU' , 'YLE TV1' , 'ZTVS') 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|21:02:59.7327|TXGG0K|TMDDBA| jobs returned 1, searched in 00:00:00.2050544 t Information: 1220 : 9|21:02:59.7327|TXGG0K|TMDDBA| tasks returned 1, searched in 00:00:00.0226030 t Verbose: 1220 : 9|21:02:59.7327|TXGG0K|TMDDBA|imfx v3 API took 0.259s '/api/v3/search/workflow?_dc=1585684979407' t Transfer: 1220 : 9|21:03:11.3108|ZpfC52|TMDDBA|OAuth: /api/user-preferences?_dc=1585684991099 t Transfer: 1220 : 9|21:03:11.3108|ZpfC52|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 9|21:03:11.3108|ZpfC52|TMDDBA| OAuth authenticated t Transfer: 1220 : 9|21:03:11.3108|ZpfC52|TMDDBA| user TMDDBA. t Verbose: 1220 : 9|21:03:11.3108|ZpfC52|TMDDBA|OAuth. User logged in: TMDDBA t Verbose: 1220 : 9|21:03:11.3108|ZpfC52|TMDDBA|StoreUserDataByKeys.. t Transfer: 1220 : 9|21:03:11.3108|ZpfC52|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 9|21:03:11.3108|ZpfC52|TMDDBA| OAuth authenticated t Transfer: 1220 : 9|21:03:11.3108|ZpfC52|TMDDBA| user TMDDBA. t Verbose: 1220 : 9|21:03:11.3108|ZpfC52|TMDDBA|imfx v3 API took 0.004s '/api/user-preferences?_dc=1585684991099' t Information: 1220 : 9|21:03:16.1858|cymCW4|TMDDBA|GetUserProfile. Id: 30000 t Transfer: 1220 : 9|21:03:16.1858|cymCW4|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 9|21:03:16.1858|cymCW4|TMDDBA| OAuth authenticated t Transfer: 1220 : 9|21:03:16.1858|cymCW4|TMDDBA| user TMDDBA. t Transfer: 1220 : 9|21:03:18.4202|pYWADw|TMDDBA|OAuth: /api/user-preferences?keys=ums.splitter.dashboard.details&_dc=1585684998341 t Transfer: 1220 : 9|21:03:18.4202|pYWADw|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 9|21:03:18.4202|pYWADw|TMDDBA| OAuth authenticated t Transfer: 1220 : 9|21:03:18.4202|pYWADw|TMDDBA| user TMDDBA. t Verbose: 1220 : 9|21:03:18.4202|pYWADw|TMDDBA|OAuth. User logged in: TMDDBA t Information: 1220 : 9|21:03:18.4202|pYWADw|TMDDBA|GetUserDataByKeys: ums.splitter.dashboard.details t Transfer: 1220 : 9|21:03:18.4202|pYWADw|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 9|21:03:18.4202|pYWADw|TMDDBA| OAuth authenticated t Transfer: 1220 : 9|21:03:18.4202|pYWADw|TMDDBA| user TMDDBA. t Verbose: 1220 : 9|21:03:18.4202|pYWADw|TMDDBA|imfx v3 API took 0.005s '/api/user-preferences?keys=ums.splitter.dashboard.details&_dc=1585684998341' t Transfer: 1220 : 9|21:03:22.0764|R25~WP|TMDDBA|OAuth: /api/user-preferences?keys=ums.splitter.dashboard.details&_dc=1585685001993 t Transfer: 1220 : 9|21:03:22.0764|R25~WP|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 9|21:03:22.0764|R25~WP|TMDDBA| OAuth authenticated t Transfer: 1220 : 9|21:03:22.0764|R25~WP|TMDDBA| user TMDDBA. t Verbose: 1220 : 9|21:03:22.0764|R25~WP|TMDDBA|OAuth. User logged in: TMDDBA t Information: 1220 : 9|21:03:22.0764|R25~WP|TMDDBA|GetUserDataByKeys: ums.splitter.dashboard.details t Transfer: 1220 : 9|21:03:22.0764|R25~WP|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 9|21:03:22.0764|R25~WP|TMDDBA| OAuth authenticated t Transfer: 1220 : 9|21:03:22.0764|R25~WP|TMDDBA| user TMDDBA. t Verbose: 1220 : 9|21:03:22.0764|R25~WP|TMDDBA|imfx v3 API took 0.004s '/api/user-preferences?keys=ums.splitter.dashboard.details&_dc=1585685001993' t Transfer: 1220 : 9|21:03:28.9827|uaWD3c|TMDDBA|OAuth: /api/user-preferences?keys=ums.splitter.dashboard.details&_dc=1585685008940 t Transfer: 1220 : 9|21:03:28.9827|uaWD3c|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 9|21:03:28.9827|uaWD3c|TMDDBA| OAuth authenticated t Transfer: 1220 : 9|21:03:28.9827|uaWD3c|TMDDBA| user TMDDBA. t Verbose: 1220 : 9|21:03:28.9827|uaWD3c|TMDDBA|OAuth. User logged in: TMDDBA t Information: 1220 : 9|21:03:28.9827|uaWD3c|TMDDBA|GetUserDataByKeys: ums.splitter.dashboard.details t Transfer: 1220 : 9|21:03:28.9827|uaWD3c|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 9|21:03:28.9827|uaWD3c|TMDDBA| OAuth authenticated t Transfer: 1220 : 9|21:03:28.9827|uaWD3c|TMDDBA| user TMDDBA. t Verbose: 1220 : 9|21:03:28.9827|uaWD3c|TMDDBA|imfx v3 API took 0.003s '/api/user-preferences?keys=ums.splitter.dashboard.details&_dc=1585685008940' t Transfer: 1220 : 9|21:03:29.1858|cXSdRR|TMDDBA|OAuth: /api/settings/group/0?_dc=1585685009113 t Transfer: 1220 : 9|21:03:29.1858|cXSdRR|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 9|21:03:29.1858|cXSdRR|TMDDBA| OAuth authenticated t Transfer: 1220 : 9|21:03:29.1858|cXSdRR|TMDDBA| user TMDDBA. t Verbose: 1220 : 9|21:03:29.1858|cXSdRR|TMDDBA|OAuth. User logged in: TMDDBA t Transfer: 1220 : 9|21:03:29.1858|VQwXK2|TMDDBA|OAuth: /api/settings/group/0?_dc=1585685009143 t Transfer: 1220 : 9|21:03:29.1858|VQwXK2|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 9|21:03:29.1858|VQwXK2|TMDDBA| OAuth authenticated t Transfer: 1220 : 9|21:03:29.1858|VQwXK2|TMDDBA| user TMDDBA. t Verbose: 1220 : 9|21:03:29.1858|VQwXK2|TMDDBA|OAuth. User logged in: TMDDBA t Verbose: 1220 : 9|21:03:29.5920|VQwXK2|TMDDBA|imfx v3 API took 0.235s '/api/settings/group/0?_dc=1585685009143' t Verbose: 1220 : 9|21:03:29.5920|cXSdRR|TMDDBA|imfx v3 API took 0.248s '/api/settings/group/0?_dc=1585685009113' t Transfer: 1220 : 9|21:03:33.4514|ZI2T3y|TMDDBA|OAuth: /api/user-preferences?keys=ums.splitter.dashboard.details&_dc=1585685013278 t Transfer: 1220 : 9|21:03:33.4514|ZI2T3y|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 9|21:03:33.4514|ZI2T3y|TMDDBA| OAuth authenticated t Transfer: 1220 : 9|21:03:33.4514|ZI2T3y|TMDDBA| user TMDDBA. t Verbose: 1220 : 9|21:03:33.4514|ZI2T3y|TMDDBA|OAuth. User logged in: TMDDBA t Information: 1220 : 9|21:03:33.4514|ZI2T3y|TMDDBA|GetUserDataByKeys: ums.splitter.dashboard.details t Transfer: 1220 : 9|21:03:33.4514|ZI2T3y|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 9|21:03:33.4514|ZI2T3y|TMDDBA| OAuth authenticated t Transfer: 1220 : 9|21:03:33.4514|ZI2T3y|TMDDBA| user TMDDBA. t Verbose: 1220 : 9|21:03:33.4514|ZI2T3y|TMDDBA|imfx v3 API took 0.003s '/api/user-preferences?keys=ums.splitter.dashboard.details&_dc=1585685013278' t Transfer: 1220 : 9|21:03:39.3420|nQtgUq|TMDDBA|OAuth: /api/ums/controller/ecd234d0-1269-4777-8e77-0ec96dd31205/restart-all?_dc=1585685019292 t Transfer: 1220 : 9|21:03:39.3420|nQtgUq|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 9|21:03:39.3420|nQtgUq|TMDDBA| OAuth authenticated t Transfer: 1220 : 9|21:03:39.3420|nQtgUq|TMDDBA| user TMDDBA. t Verbose: 1220 : 9|21:03:39.3420|nQtgUq|TMDDBA|OAuth. User logged in: TMDDBA t Transfer: 1220 : 9|21:03:39.3420|nQtgUq|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 9|21:03:39.3420|nQtgUq|TMDDBA| OAuth authenticated t Transfer: 1220 : 9|21:03:39.3420|nQtgUq|TMDDBA| user TMDDBA. t Information: 1220 : 9|21:03:39.3420|nQtgUq|TMDDBA|Request to restart all services on controller: ecd234d0-1269-4777-8e77-0ec96dd31205 - TMDDEMO-APPS/Controller received from User: TMDDBA IP: 192.168.127.6 t Transfer: 1220 : 9|21:03:39.3420|nQtgUq|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 9|21:03:39.3420|nQtgUq|TMDDBA| OAuth authenticated t Transfer: 1220 : 9|21:03:39.3420|nQtgUq|TMDDBA| user TMDDBA. t Verbose: 1220 : 9|21:03:39.5452|nQtgUq|TMDDBA|imfx v3 API took 0.038s '/api/ums/controller/ecd234d0-1269-4777-8e77-0ec96dd31205/restart-all?_dc=1585685019292' t Transfer: 1220 : 9|21:04:07.5764|0Rm5_d|TMDDBA|OAuth: /api/ums/controller/76d1f853-a2f3-4ec6-a56e-dba2dfa4f01c/restart-all?_dc=1585685047345 t Transfer: 1220 : 9|21:04:07.5764|0Rm5_d|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 9|21:04:07.5764|0Rm5_d|TMDDBA| OAuth authenticated t Transfer: 1220 : 9|21:04:07.5764|0Rm5_d|TMDDBA| user TMDDBA. t Verbose: 1220 : 9|21:04:07.5764|0Rm5_d|TMDDBA|OAuth. User logged in: TMDDBA t Transfer: 1220 : 9|21:04:07.5764|0Rm5_d|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 9|21:04:07.5764|0Rm5_d|TMDDBA| OAuth authenticated t Transfer: 1220 : 9|21:04:07.5764|0Rm5_d|TMDDBA| user TMDDBA. t Information: 1220 : 9|21:04:07.5764|0Rm5_d|TMDDBA|Request to restart all services on controller: 76d1f853-a2f3-4ec6-a56e-dba2dfa4f01c - TMDDEMO-IIS/Controller received from User: TMDDBA IP: 192.168.127.6 t Transfer: 1220 : 9|21:04:07.5764|0Rm5_d|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 9|21:04:07.5764|0Rm5_d|TMDDBA| OAuth authenticated t Transfer: 1220 : 9|21:04:07.5764|0Rm5_d|TMDDBA| user TMDDBA. t Verbose: 1220 : 9|21:04:07.5764|0Rm5_d|TMDDBA|imfx v3 API took 0.027s '/api/ums/controller/76d1f853-a2f3-4ec6-a56e-dba2dfa4f01c/restart-all?_dc=1585685047345' t Transfer: 1220 : 9|21:04:14.5295|MnT9_T|TMDDBA|OAuth: /api/v3/task/componentqc/109052?_dc=1585685054324 t Transfer: 1220 : 9|21:04:14.5295|MnT9_T|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 9|21:04:14.5295|MnT9_T|TMDDBA| OAuth authenticated t Transfer: 1220 : 9|21:04:14.5295|MnT9_T|TMDDBA| user TMDDBA. t Verbose: 1220 : 9|21:04:14.5295|MnT9_T|TMDDBA|OAuth. User logged in: TMDDBA t Information: 1220 : 9|21:04:14.5295|MnT9_T|TMDDBA|V3Api. GetComponentQc task: 109052 t Information: 1220 : 9|21:04:14.5295|MnT9_T|TMDDBA|SubtitleQcTask. LoadFromDb got Job 109051 and Subtitles 2. t Verbose: 1220 : 9|21:04:14.5295|MnT9_T|TMDDBA|imfx v3 API took 0.032s '/api/v3/task/componentqc/109052?_dc=1585685054324' t Information: 1220 : 9|21:04:14.5295|MnT9_T|TMDDBA|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.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.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.d__6.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Web.Http.Filters.ActionFilterAttribute.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.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.d__6.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Web.Http.Filters.ActionFilterAttribute.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.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.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.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.d__6.MoveNext() [GET] https://imfxv3tm.tmd.tv/api/v3/task/componentqc/109052?_dc=1585685054324 System.Web.Http.Routing.HttpRoute t Transfer: 1220 : 9|21:04:16.3576|VpKM6M|TMDDBA|OAuth: /api/v3/search/workflow?_dc=1585685056110 t Transfer: 1220 : 9|21:04:16.3576|VpKM6M|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 9|21:04:16.3576|VpKM6M|TMDDBA| OAuth authenticated t Transfer: 1220 : 9|21:04:16.3576|VpKM6M|TMDDBA| user TMDDBA. t Verbose: 1220 : 9|21:04:16.3576|VpKM6M|TMDDBA|OAuth. User logged in: TMDDBA t Information: 1220 : 9|21:04:16.3576|VpKM6M|TMDDBA|V3Api.SearchWorkflows t Information: 1220 : 9|21:04:16.3576|VpKM6M|TMDDBA|V3Api.SearchGeneric t Transfer: 1220 : 9|21:04:16.3576|VpKM6M|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 9|21:04:16.3576|VpKM6M|TMDDBA| OAuth authenticated t Transfer: 1220 : 9|21:04:16.3576|VpKM6M|TMDDBA| user TMDDBA. t Information: 1220 : 9|21:04:16.3576|VpKM6M|TMDDBA|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=109051 AND j.J_CLI_CODE in ('03BO' , '03GD' , '03GO' , '03HA' , '03JO' , '03LI' , '03NB' , '03NM' , '03NO' , '03OR' , '03SB' , '03SC' , '03SE' , '03SG' , '03SK' , '03SM' , '03SN' , '03SS' , '03SY' , '03UP' , '03VA' , '03VB' , '03VL' , '03VT' , '3+ES' , '3PD' , '3PLV' , 'AECHD' , 'AECSD' , 'AL' , 'AMAY' , 'AMC' , 'ATP' , 'CENT' , 'CS' , 'CTCB' , 'CTCE' , 'DAVI' , 'DMA' , 'DMF' , 'DMY' , 'DTV' , 'EST' , 'EUROSPORT' , 'HDC1' , 'HDP1' , 'HDP2' , 'HUB' , 'KNL2' , 'KNVA' , 'LMH' , 'LNT' , 'MBNS' , 'MED' , 'MM' , 'MTG' , 'NAA' , 'NICK' , 'NVA' , 'OSP' , 'PBOY' , 'PMS' , 'PPL' , 'PSP' , 'Play' , 'RTR' , 'SFP1' , 'SFP2' , 'SPG' , 'SPTV' , 'T3LT' , 'T3LV' , 'T6LT' , 'T6LV' , 'T8LT' , 'TECHM' , 'TMD' , 'TV10' , 'TV1A' , 'TV1B' , 'TV1C' , 'TV1D' , 'TV1E' , 'TV1F' , 'TV1K' , 'TV1N' , 'TV1P' , 'TV1S' , 'TV2S' , 'TV3D' , 'TV3N' , 'TV3S' , 'TV5L' , 'TV6E' , 'TV6H' , 'TV6N' , 'TV6S' , 'TV8' , 'TVAE' , 'TVDP' , 'TVPB' , 'TVPU' , 'TVSL' , 'V1G' , 'V1TZ' , 'V3H' , 'V4N' , 'VEC' , 'VEPL' , 'VEPO' , 'VEXE' , 'VEXR' , 'VHIS' , 'VHPO' , 'VNC' , 'VNE' , 'VNH' , 'VNHD' , 'VNPO' , 'VODD' , 'VODE' , 'VODF' , 'VODN' , 'VODS' , 'VS2' , 'VS3' , 'VSAT' , 'VSD' , 'VSD2' , 'VSE' , 'VSG' , 'VSHD' , 'VSS' , 'WCIU' , 'YLE TV1' , 'ZTVS') 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|21:04:16.3576|VpKM6M|TMDDBA| jobs returned 1, searched in 00:00:00.0048927 t Information: 1220 : 9|21:04:16.3576|VpKM6M|TMDDBA| tasks returned 1, searched in 00:00:00.0110847 t Verbose: 1220 : 9|21:04:16.3576|VpKM6M|TMDDBA|imfx v3 API took 0.024s '/api/v3/search/workflow?_dc=1585685056110' t Information: 1220 : 9|21:04:20.8265|y4NLoK|TMDDBA|GetUserProfile. Id: 30000 t Transfer: 1220 : 9|21:04:20.8265|y4NLoK|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 9|21:04:20.8265|y4NLoK|TMDDBA| OAuth authenticated t Transfer: 1220 : 9|21:04:20.8265|y4NLoK|TMDDBA| user TMDDBA. t Transfer: 1220 : 9|21:05:09.9827|vgm0Bh|TMDDBA|OAuth: /api/v3/search/workflow?_dc=1585685109859 t Transfer: 1220 : 9|21:05:09.9827|vgm0Bh|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 9|21:05:09.9827|vgm0Bh|TMDDBA| OAuth authenticated t Transfer: 1220 : 9|21:05:09.9827|vgm0Bh|TMDDBA| user TMDDBA. t Verbose: 1220 : 9|21:05:09.9827|vgm0Bh|TMDDBA|OAuth. User logged in: TMDDBA t Information: 1220 : 9|21:05:09.9827|vgm0Bh|TMDDBA|V3Api.SearchWorkflows t Information: 1220 : 9|21:05:09.9827|vgm0Bh|TMDDBA|V3Api.SearchGeneric t Transfer: 1220 : 9|21:05:09.9827|vgm0Bh|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 9|21:05:09.9827|vgm0Bh|TMDDBA| OAuth authenticated t Transfer: 1220 : 9|21:05:09.9827|vgm0Bh|TMDDBA| user TMDDBA. t Information: 1220 : 9|21:05:09.9827|vgm0Bh|TMDDBA|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('31/03/2020','DD/MM/YYYY') and j.cmb_stat not in (15,18,23) AND j.J_CLI_CODE in ('03BO' , '03GD' , '03GO' , '03HA' , '03JO' , '03LI' , '03NB' , '03NM' , '03NO' , '03OR' , '03SB' , '03SC' , '03SE' , '03SG' , '03SK' , '03SM' , '03SN' , '03SS' , '03SY' , '03UP' , '03VA' , '03VB' , '03VL' , '03VT' , '3+ES' , '3PD' , '3PLV' , 'AECHD' , 'AECSD' , 'AL' , 'AMAY' , 'AMC' , 'ATP' , 'CENT' , 'CS' , 'CTCB' , 'CTCE' , 'DAVI' , 'DMA' , 'DMF' , 'DMY' , 'DTV' , 'EST' , 'EUROSPORT' , 'HDC1' , 'HDP1' , 'HDP2' , 'HUB' , 'KNL2' , 'KNVA' , 'LMH' , 'LNT' , 'MBNS' , 'MED' , 'MM' , 'MTG' , 'NAA' , 'NICK' , 'NVA' , 'OSP' , 'PBOY' , 'PMS' , 'PPL' , 'PSP' , 'Play' , 'RTR' , 'SFP1' , 'SFP2' , 'SPG' , 'SPTV' , 'T3LT' , 'T3LV' , 'T6LT' , 'T6LV' , 'T8LT' , 'TECHM' , 'TMD' , 'TV10' , 'TV1A' , 'TV1B' , 'TV1C' , 'TV1D' , 'TV1E' , 'TV1F' , 'TV1K' , 'TV1N' , 'TV1P' , 'TV1S' , 'TV2S' , 'TV3D' , 'TV3N' , 'TV3S' , 'TV5L' , 'TV6E' , 'TV6H' , 'TV6N' , 'TV6S' , 'TV8' , 'TVAE' , 'TVDP' , 'TVPB' , 'TVPU' , 'TVSL' , 'V1G' , 'V1TZ' , 'V3H' , 'V4N' , 'VEC' , 'VEPL' , 'VEPO' , 'VEXE' , 'VEXR' , 'VHIS' , 'VHPO' , 'VNC' , 'VNE' , 'VNH' , 'VNHD' , 'VNPO' , 'VODD' , 'VODE' , 'VODF' , 'VODN' , 'VODS' , 'VS2' , 'VS3' , 'VSAT' , 'VSD' , 'VSD2' , 'VSE' , 'VSG' , 'VSHD' , 'VSS' , 'WCIU' , 'YLE TV1' , 'ZTVS') 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|21:05:09.9827|vgm0Bh|TMDDBA| jobs returned 18, searched in 00:00:00.0130375 t Information: 1220 : 9|21:05:09.9827|vgm0Bh|TMDDBA|TechReports is not found. ID: 96. t Information: 1220 : 9|21:05:09.9827|vgm0Bh|TMDDBA|TechReports is not found. ID: 41. t Information: 1220 : 9|21:05:09.9827|vgm0Bh|TMDDBA|TechReports is not found. ID: 1633. t Information: 1220 : 9|21:05:09.9827|vgm0Bh|TMDDBA|TechReports is not found. ID: 1300. t Information: 1220 : 9|21:05:09.9827|vgm0Bh|TMDDBA|TechReports is not found. ID: 116. t Information: 1220 : 9|21:05:09.9827|vgm0Bh|TMDDBA|TechReports is not found. ID: 673. t Information: 1220 : 9|21:05:09.9827|vgm0Bh|TMDDBA|TechReports is not found. ID: 1301. t Information: 1220 : 9|21:05:09.9827|vgm0Bh|TMDDBA| tasks returned 18, searched in 00:00:00.0221038 t Verbose: 1220 : 9|21:05:09.9827|vgm0Bh|TMDDBA|imfx v3 API took 0.041s '/api/v3/search/workflow?_dc=1585685109859' t Transfer: 1220 : 9|21:05:10.1858|AuJ_HE|TMDDBA|OAuth: /api/user-preferences?_dc=1585685110019 t Transfer: 1220 : 9|21:05:10.1858|AuJ_HE|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 9|21:05:10.1858|AuJ_HE|TMDDBA| OAuth authenticated t Transfer: 1220 : 9|21:05:10.1858|AuJ_HE|TMDDBA| user TMDDBA. t Verbose: 1220 : 9|21:05:10.1858|AuJ_HE|TMDDBA|OAuth. User logged in: TMDDBA t Verbose: 1220 : 9|21:05:10.1858|AuJ_HE|TMDDBA|StoreUserDataByKeys.. t Transfer: 1220 : 9|21:05:10.1858|AuJ_HE|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 9|21:05:10.1858|AuJ_HE|TMDDBA| OAuth authenticated t Transfer: 1220 : 9|21:05:10.1858|AuJ_HE|TMDDBA| user TMDDBA. t Verbose: 1220 : 9|21:05:10.1858|AuJ_HE|TMDDBA|imfx v3 API took 0.010s '/api/user-preferences?_dc=1585685110019' t Transfer: 1220 : 9|21:05:12.4202|J7sHhH|TMDDBA|OAuth: /api/v3/task/componentqc/109052?_dc=1585685112306 t Transfer: 1220 : 9|21:05:12.4202|J7sHhH|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 9|21:05:12.4202|J7sHhH|TMDDBA| OAuth authenticated t Transfer: 1220 : 9|21:05:12.4202|J7sHhH|TMDDBA| user TMDDBA. t Verbose: 1220 : 9|21:05:12.4202|J7sHhH|TMDDBA|OAuth. User logged in: TMDDBA t Information: 1220 : 9|21:05:12.4202|J7sHhH|TMDDBA|V3Api. GetComponentQc task: 109052 t Information: 1220 : 9|21:05:12.4202|J7sHhH|TMDDBA|SubtitleQcTask. LoadFromDb got Job 109051 and Subtitles 2. t Verbose: 1220 : 9|21:05:12.4202|J7sHhH|TMDDBA|imfx v3 API took 0.039s '/api/v3/task/componentqc/109052?_dc=1585685112306' t Information: 1220 : 9|21:05:12.4202|J7sHhH|TMDDBA|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.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.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.d__6.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Web.Http.Filters.ActionFilterAttribute.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.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.d__6.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Web.Http.Filters.ActionFilterAttribute.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.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.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.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.d__6.MoveNext() [GET] https://imfxv3tm.tmd.tv/api/v3/task/componentqc/109052?_dc=1585685112306 System.Web.Http.Routing.HttpRoute t Transfer: 1220 : 9|21:05:16.2796|e8xTXl|TMDDBA|OAuth: /api/v3/search/workflow?_dc=1585685116080 t Transfer: 1220 : 9|21:05:16.2796|e8xTXl|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 9|21:05:16.2796|e8xTXl|TMDDBA| OAuth authenticated t Transfer: 1220 : 9|21:05:16.2796|e8xTXl|TMDDBA| user TMDDBA. t Verbose: 1220 : 9|21:05:16.2796|e8xTXl|TMDDBA|OAuth. User logged in: TMDDBA t Information: 1220 : 9|21:05:16.2796|e8xTXl|TMDDBA|V3Api.SearchWorkflows t Information: 1220 : 9|21:05:16.2796|e8xTXl|TMDDBA|V3Api.SearchGeneric t Transfer: 1220 : 9|21:05:16.2796|e8xTXl|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 9|21:05:16.2796|e8xTXl|TMDDBA| OAuth authenticated t Transfer: 1220 : 9|21:05:16.2796|e8xTXl|TMDDBA| user TMDDBA. t Information: 1220 : 9|21:05:16.2796|e8xTXl|TMDDBA|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=109051 AND j.J_CLI_CODE in ('03BO' , '03GD' , '03GO' , '03HA' , '03JO' , '03LI' , '03NB' , '03NM' , '03NO' , '03OR' , '03SB' , '03SC' , '03SE' , '03SG' , '03SK' , '03SM' , '03SN' , '03SS' , '03SY' , '03UP' , '03VA' , '03VB' , '03VL' , '03VT' , '3+ES' , '3PD' , '3PLV' , 'AECHD' , 'AECSD' , 'AL' , 'AMAY' , 'AMC' , 'ATP' , 'CENT' , 'CS' , 'CTCB' , 'CTCE' , 'DAVI' , 'DMA' , 'DMF' , 'DMY' , 'DTV' , 'EST' , 'EUROSPORT' , 'HDC1' , 'HDP1' , 'HDP2' , 'HUB' , 'KNL2' , 'KNVA' , 'LMH' , 'LNT' , 'MBNS' , 'MED' , 'MM' , 'MTG' , 'NAA' , 'NICK' , 'NVA' , 'OSP' , 'PBOY' , 'PMS' , 'PPL' , 'PSP' , 'Play' , 'RTR' , 'SFP1' , 'SFP2' , 'SPG' , 'SPTV' , 'T3LT' , 'T3LV' , 'T6LT' , 'T6LV' , 'T8LT' , 'TECHM' , 'TMD' , 'TV10' , 'TV1A' , 'TV1B' , 'TV1C' , 'TV1D' , 'TV1E' , 'TV1F' , 'TV1K' , 'TV1N' , 'TV1P' , 'TV1S' , 'TV2S' , 'TV3D' , 'TV3N' , 'TV3S' , 'TV5L' , 'TV6E' , 'TV6H' , 'TV6N' , 'TV6S' , 'TV8' , 'TVAE' , 'TVDP' , 'TVPB' , 'TVPU' , 'TVSL' , 'V1G' , 'V1TZ' , 'V3H' , 'V4N' , 'VEC' , 'VEPL' , 'VEPO' , 'VEXE' , 'VEXR' , 'VHIS' , 'VHPO' , 'VNC' , 'VNE' , 'VNH' , 'VNHD' , 'VNPO' , 'VODD' , 'VODE' , 'VODF' , 'VODN' , 'VODS' , 'VS2' , 'VS3' , 'VSAT' , 'VSD' , 'VSD2' , 'VSE' , 'VSG' , 'VSHD' , 'VSS' , 'WCIU' , 'YLE TV1' , 'ZTVS') 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|21:05:16.2796|e8xTXl|TMDDBA| jobs returned 1, searched in 00:00:00.0057706 t Information: 1220 : 9|21:05:16.2796|e8xTXl|TMDDBA| tasks returned 1, searched in 00:00:00.0070026 t Verbose: 1220 : 9|21:05:16.2796|e8xTXl|TMDDBA|imfx v3 API took 0.026s '/api/v3/search/workflow?_dc=1585685116080' t Information: 1220 : 9|21:05:20.9514|ZezVyT|TMDDBA|GetUserProfile. Id: 30000 t Transfer: 1220 : 9|21:05:20.9514|ZezVyT|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 9|21:05:20.9514|ZezVyT|TMDDBA| OAuth authenticated t Transfer: 1220 : 9|21:05:20.9514|ZezVyT|TMDDBA| user TMDDBA. t Transfer: 1220 : 9|21:05:25.4202|Krb6tz|TMDDBA|OAuth: /api/user-preferences?keys=ums.splitter.dashboard.details&_dc=1585685125245 t Transfer: 1220 : 9|21:05:25.4202|Krb6tz|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 9|21:05:25.4202|Krb6tz|TMDDBA| OAuth authenticated t Transfer: 1220 : 9|21:05:25.4202|Krb6tz|TMDDBA| user TMDDBA. t Verbose: 1220 : 9|21:05:25.4202|Krb6tz|TMDDBA|OAuth. User logged in: TMDDBA t Information: 1220 : 9|21:05:25.4202|Krb6tz|TMDDBA|GetUserDataByKeys: ums.splitter.dashboard.details t Transfer: 1220 : 9|21:05:25.4202|Krb6tz|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 9|21:05:25.4202|Krb6tz|TMDDBA| OAuth authenticated t Transfer: 1220 : 9|21:05:25.4202|Krb6tz|TMDDBA| user TMDDBA. t Verbose: 1220 : 9|21:05:25.4202|Krb6tz|TMDDBA|imfx v3 API took 0.003s '/api/user-preferences?keys=ums.splitter.dashboard.details&_dc=1585685125245' t Transfer: 1220 : 9|21:05:31.7170|MStQuN|TMDDBA|OAuth: /api/user-preferences?keys=ums.splitter.dashboard.details&_dc=1585685131632 t Transfer: 1220 : 9|21:05:31.7170|MStQuN|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 9|21:05:31.7170|MStQuN|TMDDBA| OAuth authenticated t Transfer: 1220 : 9|21:05:31.7170|MStQuN|TMDDBA| user TMDDBA. t Verbose: 1220 : 9|21:05:31.7170|MStQuN|TMDDBA|OAuth. User logged in: TMDDBA t Information: 1220 : 9|21:05:31.7170|MStQuN|TMDDBA|GetUserDataByKeys: ums.splitter.dashboard.details t Transfer: 1220 : 9|21:05:31.7170|MStQuN|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 9|21:05:31.7170|MStQuN|TMDDBA| OAuth authenticated t Transfer: 1220 : 9|21:05:31.7170|MStQuN|TMDDBA| user TMDDBA. t Verbose: 1220 : 9|21:05:31.7170|MStQuN|TMDDBA|imfx v3 API took 0.003s '/api/user-preferences?keys=ums.splitter.dashboard.details&_dc=1585685131632' t Information: 1220 : 9|21:25:36.9359|||OrabitWatcherBasic. Disposing. t Information: 1220 : 9|21:25:36.9359|||OrabitWatcherBasic. Disposed. t Information: 1220 : 9|21:25:36.9359|||========================================================================== t Information: 1220 : 9|21:25:36.9359|||IMFX CORE SERVER APPLICATION END.