t Information: 1220 : 12|10:13:13.5455|||Get Configuration Values: t Information: 1220 : 12|10:13:13.5455||| AdminPassEnc, default: , value: ffqjrn0leKv4Lj2YJHe2dw==. t Information: 1220 : 12|10:13:13.5455||| EncryptedPasswords, default: false, value: true. t Information: 1220 : 12|10:13:13.5455||| OraConnectionString, default: , value: Server=TECHM;User Id=imfx;Password=xxxxx;Unicode=true;. t Information: 1220 : 12|10:13:13.5455||| SecondTimezone, default: , value: . t Information: 1220 : 12|10:13:13.5455||| UseActiveDirectoryAuth, default: false, value: false. t Information: 1220 : 12|10:13:13.5455||| ReportingServiceUrl, default: , value: http://localhost:92/ReportingService.svc. t Information: 1220 : 12|10:13:13.5455||| ReportsPath, default: , value: . t Information: 1220 : 12|10:13:13.5455||| ReportsURL, default: , value: . t Information: 1220 : 12|10:13:13.5455||| TapeServiceUrl, default: , value: . t Information: 1220 : 12|10:13:13.5455||| GatekeeperUrl, default: , value: . t Information: 1220 : 12|10:13:13.5455||| ValuationUrl, default: , value: . t Information: 1220 : 12|10:13:13.5455||| QueueManagerDelay, default: 30, value: 30. t Information: 1220 : 12|10:13:13.5455||| QueueManagerFullRefresh, default: 90, value: 90. t Information: 1220 : 12|10:13:13.5455||| AudioLoopDuration, default: 0, value: 150. t Information: 1220 : 12|10:13:13.5455||| AudioLoopsCount, default: 0, value: 0. t Information: 1220 : 12|10:13:13.5455||| PlayerFakeStep, default: 500, value: 500. t Information: 1220 : 12|10:13:13.5455||| PlayerForceRatio, default: 0, value: 1. t Information: 1220 : 12|10:13:13.5455||| CheckVersionsInProd, default: false, value: True. t Information: 1220 : 12|10:13:13.5455||| MaxResults, default: 3000, value: 10000. t Information: 1220 : 12|10:13:13.5455||| NetworkRestriction, default: false, value: True. t Information: 1220 : 12|10:13:13.5455||| TEReportID, default: 0, value: 0. t Information: 1220 : 12|10:13:13.5455||| ClosedCaptionsCache, default: , value: C:\inetpub\wwwroot\imfxcore\timedtextcache\. t Information: 1220 : 12|10:13:13.5455||| ClosedCaptionsStorage, default: , value: c:\Mediaflex\subs. t Information: 1220 : 12|10:13:13.5455||| TimeCodeFormat, default: , value: pal. t Information: 1220 : 12|10:13:13.5455||| RceMediaPath, default: , value: C:\edl\. t Information: 1220 : 12|10:13:13.5455||| RceMediaPath, default: , value: C:\edl\. t Information: 1220 : 12|10:13:13.5455||| RceCsmOutputPath, default: , value: C:\Inetpub\wwwroot\csm\. t Information: 1220 : 12|10:13:13.5455||| RceCsmUrl, default: , value: http://localhost/csm/. t Information: 1220 : 12|10:13:13.5455||| RceMediaSelection, default: , value: miLinkIdMatch. t Information: 1220 : 12|10:13:13.5455||| RequestBrowseJobPresetName, default: , value: . t Information: 1220 : 12|10:13:13.5455||| DontExtendDuration, default: false, value: False. t Information: 1220 : 12|10:13:13.5455||| V3ConfigUrl, default: , value: . t Information: 1220 : 12|10:13:13.5455||| StopWords, default: , value: . t Information: 1220 : 12|10:13:13.5455||| MisrTxFormat, default: G, value: G. t Information: 1220 : 12|10:13:13.5455||| ApiServer, default: , value: http://192.168.120.10:85. t Information: 1220 : 12|10:13:13.5455||| ApiTimeout, default: 120, value: 120. t Information: 1220 : 12|10:13:13.5455||| ApiWorkers, default: 10, value: 10. t Information: 1220 : 12|10:13:13.5455||| UsePerfCounters, default: false, value: false. t Information: 1220 : 12|10:13:13.5455||| StatsdAddress, default: , value: . t Information: 1220 : 12|10:13:13.5455||| LogGetCurrentUser, default: true, value: true. t Information: 1220 : 12|10:13:13.5455||| LogInternalApi, default: true, value: true. t Information: 1220 : 12|10:13:13.5455||| ThumbnailServer, default: , value: . t Information: 1220 : 12|10:13:13.5455||| LocationFilter, default: , value: . t Information: 1220 : 12|10:13:13.5455||| SvUtilServiceUrl, default: , value: . t Information: 1220 : 12|10:13:13.5455||| SolrConnection, default: , value: http://192.168.120.14:8983/solr. t Information: 1220 : 12|10:13:13.5455||| UseIndexServerSearch, default: false, value: True. t Information: 1220 : 12|10:13:13.5455||| SolrIndexVersion, default: 1, value: 6. t Information: 1220 : 12|10:13:13.5455||| SolrConnection, default: , value: http://192.168.120.14:8983/solr. t Information: 1220 : 12|10:13:13.5455||| FacetsGroups, default: , value: owners,season_id, series_id,version_key,item_type,media_type,media_format,episode_number. t Information: 1220 : 12|10:13:13.5455||| FacetsGroupsVersion, default: , value: owners,season_id, series_id,version_key,episode_number. t Information: 1220 : 12|10:13:13.5455||| FacetsGroupsChameleon, default: , value: season_id, series_id,genre,prod_year,version_key. t Information: 1220 : 12|10:13:13.5455||| PreviewPreset, default: , value: . t Information: 1220 : 12|10:13:13.5455||| DevMode, default: false, value: false. t Information: 1220 : 12|10:13:13.5455||| DisableSysMan, default: false, value: false. t Information: 1220 : 12|10:13:13.5455||| TimeCodeFormat, default: , value: pal. t Information: 1220 : 12|10:13:13.5612||| FileCatalystStorageDevice, default: , value: . t Information: 1220 : 12|10:13:13.5612||| UseResponsibilityTracking, default: true, value: True. t Information: 1220 : 12|10:13:13.5612||| SubtitleDeviceFilter, default: , value: . t Information: 1220 : 12|10:13:13.5612||| SystemMonitorNamedPipe, default: , value: . t Information: 1220 : 12|10:13:13.5612||| OracleMonitorEnable, default: false, value: False. t Information: 1220 : 12|10:13:13.5612||| ArcApiHost, default: , value: . t Information: 1220 : 12|10:13:13.5612||| RabbitMqUrl, default: , value: amqp://192.168.120.14:5672. t Information: 1220 : 12|10:13:13.5612||| SolrTimedTextSearch, default: false, value: false. t Information: 1220 : 12|10:13:13.5612||| ProductionDurationUsageID, default: 1, value: 1. t Information: 1220 : 12|10:13:13.7643|||GetStreamServers.. t Information: 1220 : 12|10:13:14.1705||| https://demo.tmd.tv/CBR Video/ |CBR Video| False t Information: 1220 : 12|10:13:14.1705||| https://demo.tmd.tv/CBR Images/ |CBR Images| False t Information: 1220 : 12|10:13:14.1705||| https://demo.tmd.tv/CBR Audio/ |CBR Audio| False t Information: 1220 : 12|10:13:14.1705||| https://demo.tmd.tv/Temp Upload/ |TEMP_UPLOAD| False t Information: 1220 : 12|10:13:14.1705||| http://localhost:82/images/ |IMAGES| False t Information: 1220 : 12|10:13:14.1705||| http://192.168.91.73/smoothcloud/ |SMOOTH_CLOUD| False t Information: 1220 : 12|10:13:14.1705||| http://192.168.91.73/cloudstore/ |CLOUD_STORE| False t Information: 1220 : 12|10:13:14.1705||| http://192.168.91.73/editsystemin/ |EDIT_SYSTEM_IN| False t Information: 1220 : 12|10:13:14.1705||| http://192.168.91.27:89/APPLEPROXY/ |APPLE_PROXY| False t Information: 1220 : 12|10:13:14.1705||| http://localhost:82/video/ |FILESTORE_VIDEO| False t Information: 1220 : 12|10:13:14.1705||| https://imfxv3tm.tmd.tv/streaming/ |Streaming| False t Information: 1220 : 12|10:13:14.1705||| https://imfxv3tm.tmd.tv/VideoServer/ |Video| False t Information: 1220 : 12|10:13:14.1705||| https://imfxv3tm.tmd.tv/AdobeIn/ |Adobe Premiere Pro In| False t Information: 1220 : 12|10:13:14.1705||| https://imfxv3tm.tmd.tv/AudioServer/ |Audio| False t Information: 1220 : 12|10:13:14.1705||| https://imfxv3tm.tmd.tv/ImageServer/ |Image| False t Information: 1220 : 12|10:13:14.1705||| https://imfxv3tm.tmd.tv/DocsServer/ |Docs| False t Information: 1220 : 12|10:13:14.1705||| https://imfxv3tm.tmd.tv/AmazonLabs/ |TEST HOUSE| False t Information: 1220 : 12|10:13:14.1705||| SolrConnectionUms, default: http://192.168.120.14:8983/solr, value: http://192.168.120.14:8983/solr. t Information: 1220 : 12|10:13:14.1705||| LogWebApi, default: false, value: false. t Information: 1220 : 12|10:13:14.1705||| EmbeddedRceUrl, default: , value: . t Information: 1220 : 12|10:13:14.1705||| InstallMode, default: , value: . t Information: 1220 : 12|10:13:14.1705||| SamlRequestAddress, default: , value: . t Information: 1220 : 12|10:13:14.1705||| SamlTrustedIssuer, default: , value: . t Information: 1220 : 12|10:13:14.1705||| SamlLoginRedirect, default: , value: . t Information: 1220 : 12|10:13:14.1705||| NaturalLangSearch, default: false, value: True. t Information: 1220 : 12|10:13:14.1705||| OktaLoginField, default: , value: . t Information: 1220 : 12|10:13:14.1705||| AuthenticationTypes, default: , value: Native,PublicApiKey. t Information: 1220 : 12|10:13:14.1705|||OrabitWatcherBasic. Initialize. t Information: 1220 : 12|10:13:14.1705|||FillDictionaryCache. t Information: 1220 : 12|10:13:17.6237|||GetSupportedOperators t Information: 1220 : 12|10:13:17.8268|||CacheTechReports. t Information: 1220 : 12|10:13:18.0456|||& Cache update. Server (global) filled with timestamp 10:04:17.8737246. types null t Information: 1220 : 12|10:13:18.0456|||InitializeFromDatabase. 'Server=TECHM;User Id=imfx;password=..;Unicode=true;' direct False, home , timeout 15 t Information: 1220 : 12|10:13:18.0456|||FillDictionaryCache. t Information: 1220 : 12|10:13:18.0456|||& Cache update. Server (global) filled with timestamp 10:04:17.9049863. types FriendlyNames, DatabaseSearchFieldData t Information: 1220 : 12|10:13:18.6549|||========================================================================== t Information: 1220 : 12|10:13:18.6549|||IMFX CORE SERVER APPLICATION START. t Information: 1220 : 12|10:13:18.6549|||DLL VERSION: 2.5.0.2610. t Information: 1220 : 12|10:13:18.6549|||IS TIMER HIGH RESOULTION : True. t Information: 1220 : 12|10:13:18.6549||| UmsDev, default: False, value: False. t Information: 1220 : 12|10:13:19.0612|||OrabitWatcherBasic trying to connect.. t Information: 1220 : 12|10:13:19.2643|||OrabitWatcherBasic connected. t Information: 1220 : 12|10:13:19.2643|||OrabitWatcherBasic queue created tmd.cfg.in.4d8531fc-44f4-48a6-b82a-3d07fc6de32d t Transfer: 1220 : 12|10:13:28.8111|omUZQh|DANIEL|OAuth: /api/settings/user/uploadSettings?_dc=1585732408699 t Transfer: 1220 : 12|10:13:28.8111|omUZQh|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|10:13:28.8111|omUZQh|DANIEL| OAuth authenticated t Transfer: 1220 : 12|10:13:28.8111|omUZQh|DANIEL| user DANIEL. t Verbose: 1220 : 12|10:13:28.8111|omUZQh|DANIEL|OAuth. User logged in: DANIEL t Transfer: 1220 : 12|10:13:28.8111|omUZQh|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|10:13:28.8111|omUZQh|DANIEL| OAuth authenticated t Transfer: 1220 : 12|10:13:28.8111|omUZQh|DANIEL| user DANIEL. t Verbose: 1220 : 12|10:13:29.0143|omUZQh|DANIEL|imfx v3 API took 0.070s '/api/settings/user/uploadSettings?_dc=1585732408699' t Information: 1220 : 12|10:13:29.4205|FnCWX2|DANIEL|GetUserProfile. Id: 0 t Transfer: 1220 : 12|10:13:29.4205|FnCWX2|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|10:13:29.4205|FnCWX2|DANIEL| OAuth authenticated t Transfer: 1220 : 12|10:13:29.4205|FnCWX2|DANIEL| user DANIEL. t Transfer: 1220 : 12|10:13:30.4362|WrrZ0B|DANIEL|OAuth: /api/view/searchinfo/Job?_dc=1585732410306 t Transfer: 1220 : 12|10:13:30.4362|WrrZ0B|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|10:13:30.4362|WrrZ0B|DANIEL| OAuth authenticated t Transfer: 1220 : 12|10:13:30.4362|WrrZ0B|DANIEL| user DANIEL. t Verbose: 1220 : 12|10:13:30.4362|WrrZ0B|DANIEL|OAuth. User logged in: DANIEL t Information: 1220 : 12|10:13:30.4362|WrrZ0B|DANIEL|GetAdvSearchColumns. search type Job grid . t Transfer: 1220 : 12|10:13:30.4362|JhDWG5|DANIEL|OAuth: /api/user-preferences?keys=adv.recent.searches.workflow&_dc=1585732410310 t Transfer: 1220 : 12|10:13:30.4362|JhDWG5|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|10:13:30.4362|JhDWG5|DANIEL| OAuth authenticated t Transfer: 1220 : 12|10:13:30.4362|JhDWG5|DANIEL| user DANIEL. t Verbose: 1220 : 12|10:13:30.4362|JhDWG5|DANIEL|OAuth. User logged in: DANIEL t Information: 1220 : 12|10:13:30.4362|JhDWG5|DANIEL|GetUserDataByKeys: adv.recent.searches.workflow t Transfer: 1220 : 12|10:13:30.4362|JhDWG5|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|10:13:30.4362|JhDWG5|DANIEL| OAuth authenticated t Transfer: 1220 : 12|10:13:30.4362|JhDWG5|DANIEL| user DANIEL. t Verbose: 1220 : 12|10:13:30.4362|WrrZ0B|DANIEL|imfx v3 API took 0.014s '/api/view/searchinfo/Job?_dc=1585732410306' t Verbose: 1220 : 12|10:13:30.4362|JhDWG5|DANIEL|imfx v3 API took 0.017s '/api/user-preferences?keys=adv.recent.searches.workflow&_dc=1585732410310' t Transfer: 1220 : 12|10:13:30.4362|JDOW99|DANIEL|OAuth: /api/view/searches/Job?_dc=1585732410398 t Transfer: 1220 : 12|10:13:30.4362|JDOW99|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|10:13:30.4362|JDOW99|DANIEL| OAuth authenticated t Transfer: 1220 : 12|10:13:30.4362|JDOW99|DANIEL| user DANIEL. t Verbose: 1220 : 12|10:13:30.4362|JDOW99|DANIEL|OAuth. User logged in: DANIEL t Information: 1220 : 12|10:13:30.4362|JDOW99|DANIEL|GetSavedSearchNames. search type Job. t Transfer: 1220 : 12|10:13:30.4362|JDOW99|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|10:13:30.4362|JDOW99|DANIEL| OAuth authenticated t Transfer: 1220 : 12|10:13:30.4362|JDOW99|DANIEL| user DANIEL. t Verbose: 1220 : 12|10:13:30.6393|JDOW99|DANIEL|imfx v3 API took 0.033s '/api/view/searches/Job?_dc=1585732410398' t Transfer: 1220 : 12|10:13:46.0768|NpkWKX|DANIEL|OAuth: /api/view/search/Job/1311?name=RECENT%20JOBS&_dc=1585732426025 t Transfer: 1220 : 12|10:13:46.0768|NpkWKX|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|10:13:46.0768|NpkWKX|DANIEL| OAuth authenticated t Transfer: 1220 : 12|10:13:46.0768|NpkWKX|DANIEL| user DANIEL. t Verbose: 1220 : 12|10:13:46.0768|NpkWKX|DANIEL|OAuth. User logged in: DANIEL t Information: 1220 : 12|10:13:46.2799|NpkWKX|DANIEL|SaveSearchItem. search type Job name RECENT JOBS items 1. t Transfer: 1220 : 12|10:13:46.2799|NpkWKX|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|10:13:46.2799|NpkWKX|DANIEL| OAuth authenticated t Transfer: 1220 : 12|10:13:46.2799|NpkWKX|DANIEL| user DANIEL. t Verbose: 1220 : 12|10:13:46.2799|NpkWKX|DANIEL|imfx v3 API took 0.059s '/api/view/search/Job/1311?name=RECENT%20JOBS&_dc=1585732426025' t Transfer: 1220 : 12|10:13:48.1080|S9HA3k|DANIEL|OAuth: /api/v3/search/workflow?_dc=1585732427997 t Transfer: 1220 : 12|10:13:48.1080|S9HA3k|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|10:13:48.1080|S9HA3k|DANIEL| OAuth authenticated t Transfer: 1220 : 12|10:13:48.1080|S9HA3k|DANIEL| user DANIEL. t Verbose: 1220 : 12|10:13:48.1080|S9HA3k|DANIEL|OAuth. User logged in: DANIEL t Information: 1220 : 12|10:13:48.1080|S9HA3k|DANIEL|V3Api.SearchWorkflows t Information: 1220 : 12|10:13:48.1080|S9HA3k|DANIEL|V3Api.SearchGeneric t Transfer: 1220 : 12|10:13:48.1080|S9HA3k|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|10:13:48.1080|S9HA3k|DANIEL| OAuth authenticated t Transfer: 1220 : 12|10:13:48.1080|S9HA3k|DANIEL| user DANIEL. t Information: 1220 : 12|10:13:48.1080|S9HA3k|DANIEL|SearchJob SQL: select * from (select a.*, rownum rnum from ( select /*+ INDEX(j JB_CMBST_IDX) */ j.* ,p.pname ,mi.tv_std ,mi.MIID1, mi.MIID2, mi.MIID3, mi.VERSIONID1, mi.VERSIONID2, mi.PROGID1, mi.PROGID2 ,txd.NEXT_TX_DATE FROM tm_mjob j left join tm_mjob_pset p on j.j_sched_indx=p.id left join (select j_id, TMD_str_agg(distinct miid1) MIID1, TMD_str_agg(distinct miid2) MIID2, TMD_str_agg(distinct miid3) MIID3, TMD_str_agg(distinct versionid1) VERSIONID1, TMD_str_agg(distinct versionid2) VERSIONID2, TMD_str_agg(distinct progid1) PROGID1, TMD_str_agg(distinct progid2) PROGID2, TMD_str_agg(distinct m.tv_std) TV_STD from tm_mis m, tm_mtsk_it i where m.id=i.mi_id and i.src_dest in (2,3) group by j_id) mi on mi.j_id=j.id LEFT JOIN ( SELECT it.j_id, min(sch.tx_tm_st) NEXT_TX_DATE FROM TM_MTSK_IT it, TM_MIS m, hr_sched sch WHERE m.id = it.MI_ID AND (sch.prod_num = m.PROGID2 OR sch.prod_num = (select rl.VERSIONID1 from TM_PG_RL rl where rl.ID = m.PGM_PARENT_ID)) AND sch.tx_tm_st > sysdate GROUP BY J_ID) txd ON txd.j_id = j.id where 1=1 AND not ( j.CMB_STAT = 19 and j.J_FAILURE_RESOLVED > 0 ) and j.J_CREATED >= to_date('01/04/2020','DD/MM/YYYY') and j.cmb_stat not in (15,18,23) order by j.J_COMPL_BY, j.id desc, j.id ) a where rownum <= 50) where rnum >= 1 order by rnum t Information: 1220 : 12|10:13:48.3112|S9HA3k|DANIEL| jobs returned 2, searched in 00:00:00.0651648 t Information: 1220 : 12|10:13:48.3112|S9HA3k|DANIEL| tasks returned 2, searched in 00:00:00.0332116 t Verbose: 1220 : 12|10:13:48.3112|S9HA3k|DANIEL|imfx v3 API took 0.138s '/api/v3/search/workflow?_dc=1585732427997' t Transfer: 1220 : 12|10:13:48.5143|tX7qh7|DANIEL|OAuth: /api/user-preferences?_dc=1585732428393 t Transfer: 1220 : 12|10:13:48.5143|tX7qh7|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|10:13:48.5143|tX7qh7|DANIEL| OAuth authenticated t Transfer: 1220 : 12|10:13:48.5143|tX7qh7|DANIEL| user DANIEL. t Verbose: 1220 : 12|10:13:48.5143|tX7qh7|DANIEL|OAuth. User logged in: DANIEL t Verbose: 1220 : 12|10:13:48.5143|tX7qh7|DANIEL|StoreUserDataByKeys.. t Transfer: 1220 : 12|10:13:48.5143|tX7qh7|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|10:13:48.5143|tX7qh7|DANIEL| OAuth authenticated t Transfer: 1220 : 12|10:13:48.5143|tX7qh7|DANIEL| user DANIEL. t Verbose: 1220 : 12|10:13:48.5143|tX7qh7|DANIEL|imfx v3 API took 0.027s '/api/user-preferences?_dc=1585732428393' t Transfer: 1220 : 12|10:13:51.7643|DGlIGj|DANIEL|OAuth: /api/v3/task/componentqc/109468?_dc=1585732431736 t Transfer: 1220 : 12|10:13:51.7643|DGlIGj|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|10:13:51.7643|DGlIGj|DANIEL| OAuth authenticated t Transfer: 1220 : 12|10:13:51.7643|DGlIGj|DANIEL| user DANIEL. t Verbose: 1220 : 12|10:13:51.7643|DGlIGj|DANIEL|OAuth. User logged in: DANIEL t Information: 1220 : 12|10:13:51.7643|DGlIGj|DANIEL|V3Api. GetComponentQc task: 109468 t Information: 1220 : 12|10:13:51.9674|DGlIGj|DANIEL|SubtitleQcTask. LoadFromDb got Job 109452 and Subtitles 1. t Verbose: 1220 : 12|10:13:51.9674|DGlIGj|DANIEL|imfx v3 API took 0.153s '/api/v3/task/componentqc/109468?_dc=1585732431736' t Information: 1220 : 12|10:13:51.9987|DGlIGj|DANIEL|V3 Api exception handler: System.Collections.Generic.KeyNotFoundException: The given key was not present in the dictionary. at System.Collections.Generic.Dictionary`2.get_Item(TKey key) at xMfxModel.TM_MIS.ParseCustomStatuses() in C:\BuildAgent2\work\405c64e443a47d83\Server\xMfxDataLogic\Logic\TM_MIS.cs:line 440 at xMfxDataLogic.ServiceLogic.Implementation.SubtitlesQcTaskLoad(Decimal taskId) in C:\BuildAgent2\work\405c64e443a47d83\Server\xMfxDataLogic\Logic\ServiceLogic\SubtitleQc.cs:line 68 at iMfxServerCore.Api.v3.SubtitleQcTaskController.GetComponentQcTask(Int32 id) in C:\BuildAgent2\work\405c64e443a47d83\Server\iMfxServerCore\api\controllers\v3\Tasks\SubtitleQcTaskController.cs:line 44 at lambda_method(Closure , Object , Object[] ) at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ActionExecutor.<>c__DisplayClass6_2.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/109468?_dc=1585732431736 System.Web.Http.Routing.HttpRoute t Transfer: 1220 : 12|10:13:54.0455|UsT2cW|DANIEL|OAuth: /api/v3/search/workflow?_dc=1585732433890 t Transfer: 1220 : 12|10:13:54.0455|UsT2cW|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|10:13:54.0455|UsT2cW|DANIEL| OAuth authenticated t Transfer: 1220 : 12|10:13:54.0455|UsT2cW|DANIEL| user DANIEL. t Verbose: 1220 : 12|10:13:54.0455|UsT2cW|DANIEL|OAuth. User logged in: DANIEL t Information: 1220 : 12|10:13:54.0455|UsT2cW|DANIEL|V3Api.SearchWorkflows t Information: 1220 : 12|10:13:54.0455|UsT2cW|DANIEL|V3Api.SearchGeneric t Transfer: 1220 : 12|10:13:54.0455|UsT2cW|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|10:13:54.0455|UsT2cW|DANIEL| OAuth authenticated t Transfer: 1220 : 12|10:13:54.0455|UsT2cW|DANIEL| user DANIEL. t Information: 1220 : 12|10:13:54.0455|UsT2cW|DANIEL|SearchJob SQL: select * from (select a.*, rownum rnum from ( select /*+ INDEX(j JB_CMBST_IDX) */ j.* ,p.pname ,mi.tv_std ,mi.MIID1, mi.MIID2, mi.MIID3, mi.VERSIONID1, mi.VERSIONID2, mi.PROGID1, mi.PROGID2 ,txd.NEXT_TX_DATE FROM tm_mjob j left join tm_mjob_pset p on j.j_sched_indx=p.id left join (select j_id, TMD_str_agg(distinct miid1) MIID1, TMD_str_agg(distinct miid2) MIID2, TMD_str_agg(distinct miid3) MIID3, TMD_str_agg(distinct versionid1) VERSIONID1, TMD_str_agg(distinct versionid2) VERSIONID2, TMD_str_agg(distinct progid1) PROGID1, TMD_str_agg(distinct progid2) PROGID2, TMD_str_agg(distinct m.tv_std) TV_STD from tm_mis m, tm_mtsk_it i where m.id=i.mi_id and i.src_dest in (2,3) group by j_id) mi on mi.j_id=j.id LEFT JOIN ( SELECT it.j_id, min(sch.tx_tm_st) NEXT_TX_DATE FROM TM_MTSK_IT it, TM_MIS m, hr_sched sch WHERE m.id = it.MI_ID AND (sch.prod_num = m.PROGID2 OR sch.prod_num = (select rl.VERSIONID1 from TM_PG_RL rl where rl.ID = m.PGM_PARENT_ID)) AND sch.tx_tm_st > sysdate GROUP BY J_ID) txd ON txd.j_id = j.id where 1=1 AND j.ID=109452 order by j.J_COMPL_BY, j.id desc, j.id ) a where rownum <= 50) where rnum >= 1 order by rnum t Information: 1220 : 12|10:13:54.0455|UsT2cW|DANIEL| jobs returned 1, searched in 00:00:00.0067881 t Information: 1220 : 12|10:13:54.0455|UsT2cW|DANIEL| tasks returned 1, searched in 00:00:00.0030473 t Verbose: 1220 : 12|10:13:54.0455|UsT2cW|DANIEL|imfx v3 API took 0.015s '/api/v3/search/workflow?_dc=1585732433890' t Transfer: 1220 : 12|10:15:20.1861|nkd29h|DANIEL|OAuth: /api/v3/search/workflow?_dc=1585732520048 t Transfer: 1220 : 12|10:15:20.1861|nkd29h|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|10:15:20.1861|nkd29h|DANIEL| OAuth authenticated t Transfer: 1220 : 12|10:15:20.1861|nkd29h|DANIEL| user DANIEL. t Verbose: 1220 : 12|10:15:20.1861|nkd29h|DANIEL|OAuth. User logged in: DANIEL t Information: 1220 : 12|10:15:20.1861|nkd29h|DANIEL|V3Api.SearchWorkflows t Information: 1220 : 12|10:15:20.1861|nkd29h|DANIEL|V3Api.SearchGeneric t Transfer: 1220 : 12|10:15:20.1861|nkd29h|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|10:15:20.1861|nkd29h|DANIEL| OAuth authenticated t Transfer: 1220 : 12|10:15:20.1861|nkd29h|DANIEL| user DANIEL. t Information: 1220 : 12|10:15:20.1861|nkd29h|DANIEL|SearchJob SQL: select * from (select a.*, rownum rnum from ( select /*+ INDEX(j JB_CMBST_IDX) */ j.* ,p.pname ,mi.tv_std ,mi.MIID1, mi.MIID2, mi.MIID3, mi.VERSIONID1, mi.VERSIONID2, mi.PROGID1, mi.PROGID2 ,txd.NEXT_TX_DATE FROM tm_mjob j left join tm_mjob_pset p on j.j_sched_indx=p.id left join (select j_id, TMD_str_agg(distinct miid1) MIID1, TMD_str_agg(distinct miid2) MIID2, TMD_str_agg(distinct miid3) MIID3, TMD_str_agg(distinct versionid1) VERSIONID1, TMD_str_agg(distinct versionid2) VERSIONID2, TMD_str_agg(distinct progid1) PROGID1, TMD_str_agg(distinct progid2) PROGID2, TMD_str_agg(distinct m.tv_std) TV_STD from tm_mis m, tm_mtsk_it i where m.id=i.mi_id and i.src_dest in (2,3) group by j_id) mi on mi.j_id=j.id LEFT JOIN ( SELECT it.j_id, min(sch.tx_tm_st) NEXT_TX_DATE FROM TM_MTSK_IT it, TM_MIS m, hr_sched sch WHERE m.id = it.MI_ID AND (sch.prod_num = m.PROGID2 OR sch.prod_num = (select rl.VERSIONID1 from TM_PG_RL rl where rl.ID = m.PGM_PARENT_ID)) AND sch.tx_tm_st > sysdate GROUP BY J_ID) txd ON txd.j_id = j.id where 1=1 AND not ( j.CMB_STAT = 19 and j.J_FAILURE_RESOLVED > 0 ) and j.J_CREATED >= to_date('01/04/2020','DD/MM/YYYY') and j.cmb_stat not in (15,18,23) order by j.J_COMPL_BY, j.id desc, j.id ) a where rownum <= 50) where rnum >= 1 order by rnum t Information: 1220 : 12|10:15:20.1861|nkd29h|DANIEL| jobs returned 3, searched in 00:00:00.0071632 t Information: 1220 : 12|10:15:20.1861|nkd29h|DANIEL| tasks returned 3, searched in 00:00:00.0249309 t Verbose: 1220 : 12|10:15:20.1861|nkd29h|DANIEL|imfx v3 API took 0.038s '/api/v3/search/workflow?_dc=1585732520048' t Transfer: 1220 : 12|10:15:20.1861|J~YL7r|DANIEL|OAuth: /api/user-preferences?_dc=1585732520152 t Transfer: 1220 : 12|10:15:20.1861|J~YL7r|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|10:15:20.1861|J~YL7r|DANIEL| OAuth authenticated t Transfer: 1220 : 12|10:15:20.1861|J~YL7r|DANIEL| user DANIEL. t Verbose: 1220 : 12|10:15:20.1861|J~YL7r|DANIEL|OAuth. User logged in: DANIEL t Verbose: 1220 : 12|10:15:20.1861|J~YL7r|DANIEL|StoreUserDataByKeys.. t Transfer: 1220 : 12|10:15:20.1861|J~YL7r|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|10:15:20.1861|J~YL7r|DANIEL| OAuth authenticated t Transfer: 1220 : 12|10:15:20.1861|J~YL7r|DANIEL| user DANIEL. t Verbose: 1220 : 12|10:15:20.1861|J~YL7r|DANIEL|imfx v3 API took 0.008s '/api/user-preferences?_dc=1585732520152' t Transfer: 1220 : 12|10:15:22.6237|u8dUcj|DANIEL|OAuth: /api/v3/task/componentqc/109473?_dc=1585732522477 t Transfer: 1220 : 12|10:15:22.6237|u8dUcj|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|10:15:22.6237|u8dUcj|DANIEL| OAuth authenticated t Transfer: 1220 : 12|10:15:22.6237|u8dUcj|DANIEL| user DANIEL. t Verbose: 1220 : 12|10:15:22.6237|u8dUcj|DANIEL|OAuth. User logged in: DANIEL t Information: 1220 : 12|10:15:22.6237|u8dUcj|DANIEL|V3Api. GetComponentQc task: 109473 t Information: 1220 : 12|10:15:22.6237|u8dUcj|DANIEL|SubtitleQcTask. LoadFromDb got Job 109472 and Subtitles 1. t Verbose: 1220 : 12|10:15:22.6237|u8dUcj|DANIEL|imfx v3 API took 0.095s '/api/v3/task/componentqc/109473?_dc=1585732522477' t Information: 1220 : 12|10:15:22.6237|u8dUcj|DANIEL|V3 Api exception handler: System.Collections.Generic.KeyNotFoundException: The given key was not present in the dictionary. at System.Collections.Generic.Dictionary`2.get_Item(TKey key) at xMfxModel.TM_MIS.ParseCustomStatuses() in C:\BuildAgent2\work\405c64e443a47d83\Server\xMfxDataLogic\Logic\TM_MIS.cs:line 440 at xMfxDataLogic.ServiceLogic.Implementation.SubtitlesQcTaskLoad(Decimal taskId) in C:\BuildAgent2\work\405c64e443a47d83\Server\xMfxDataLogic\Logic\ServiceLogic\SubtitleQc.cs:line 68 at iMfxServerCore.Api.v3.SubtitleQcTaskController.GetComponentQcTask(Int32 id) in C:\BuildAgent2\work\405c64e443a47d83\Server\iMfxServerCore\api\controllers\v3\Tasks\SubtitleQcTaskController.cs:line 44 at lambda_method(Closure , Object , Object[] ) at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ActionExecutor.<>c__DisplayClass6_2.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/109473?_dc=1585732522477 System.Web.Http.Routing.HttpRoute t Transfer: 1220 : 12|10:15:25.6705|zUXHJu|DANIEL|OAuth: /api/v3/search/workflow?_dc=1585732525639 t Transfer: 1220 : 12|10:15:25.6705|zUXHJu|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|10:15:25.6705|zUXHJu|DANIEL| OAuth authenticated t Transfer: 1220 : 12|10:15:25.6705|zUXHJu|DANIEL| user DANIEL. t Verbose: 1220 : 12|10:15:25.6705|zUXHJu|DANIEL|OAuth. User logged in: DANIEL t Information: 1220 : 12|10:15:25.6705|zUXHJu|DANIEL|V3Api.SearchWorkflows t Information: 1220 : 12|10:15:25.6705|zUXHJu|DANIEL|V3Api.SearchGeneric t Transfer: 1220 : 12|10:15:25.6705|zUXHJu|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|10:15:25.6705|zUXHJu|DANIEL| OAuth authenticated t Transfer: 1220 : 12|10:15:25.6705|zUXHJu|DANIEL| user DANIEL. t Information: 1220 : 12|10:15:25.8736|zUXHJu|DANIEL|SearchJob SQL: select * from (select a.*, rownum rnum from ( select /*+ INDEX(j JB_CMBST_IDX) */ j.* ,p.pname ,mi.tv_std ,mi.MIID1, mi.MIID2, mi.MIID3, mi.VERSIONID1, mi.VERSIONID2, mi.PROGID1, mi.PROGID2 ,txd.NEXT_TX_DATE FROM tm_mjob j left join tm_mjob_pset p on j.j_sched_indx=p.id left join (select j_id, TMD_str_agg(distinct miid1) MIID1, TMD_str_agg(distinct miid2) MIID2, TMD_str_agg(distinct miid3) MIID3, TMD_str_agg(distinct versionid1) VERSIONID1, TMD_str_agg(distinct versionid2) VERSIONID2, TMD_str_agg(distinct progid1) PROGID1, TMD_str_agg(distinct progid2) PROGID2, TMD_str_agg(distinct m.tv_std) TV_STD from tm_mis m, tm_mtsk_it i where m.id=i.mi_id and i.src_dest in (2,3) group by j_id) mi on mi.j_id=j.id LEFT JOIN ( SELECT it.j_id, min(sch.tx_tm_st) NEXT_TX_DATE FROM TM_MTSK_IT it, TM_MIS m, hr_sched sch WHERE m.id = it.MI_ID AND (sch.prod_num = m.PROGID2 OR sch.prod_num = (select rl.VERSIONID1 from TM_PG_RL rl where rl.ID = m.PGM_PARENT_ID)) AND sch.tx_tm_st > sysdate GROUP BY J_ID) txd ON txd.j_id = j.id where 1=1 AND j.ID=109472 order by j.J_COMPL_BY, j.id desc, j.id ) a where rownum <= 50) where rnum >= 1 order by rnum t Information: 1220 : 12|10:15:25.8736|zUXHJu|DANIEL| jobs returned 1, searched in 00:00:00.1422519 t Information: 1220 : 12|10:15:25.8736|zUXHJu|DANIEL| tasks returned 1, searched in 00:00:00.0224047 t Verbose: 1220 : 12|10:15:25.8736|zUXHJu|DANIEL|imfx v3 API took 0.178s '/api/v3/search/workflow?_dc=1585732525639' t Transfer: 1220 : 12|10:16:30.4826|O5_12T|DANIEL|OAuth: /api/v3/task/componentqc/109473?_dc=1585732590385 t Transfer: 1220 : 12|10:16:30.4826|O5_12T|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|10:16:30.4826|O5_12T|DANIEL| OAuth authenticated t Transfer: 1220 : 12|10:16:30.4826|O5_12T|DANIEL| user DANIEL. t Verbose: 1220 : 12|10:16:30.4826|O5_12T|DANIEL|OAuth. User logged in: DANIEL t Information: 1220 : 12|10:16:30.4826|O5_12T|DANIEL|V3Api. GetComponentQc task: 109473 t Information: 1220 : 12|10:16:30.4826|O5_12T|DANIEL|SubtitleQcTask. LoadFromDb got Job 109472 and Subtitles 1. t Verbose: 1220 : 12|10:16:30.4826|O5_12T|DANIEL|imfx v3 API took 0.018s '/api/v3/task/componentqc/109473?_dc=1585732590385' t Information: 1220 : 12|10:16:30.4826|O5_12T|DANIEL|V3 Api exception handler: System.Collections.Generic.KeyNotFoundException: The given key was not present in the dictionary. at System.Collections.Generic.Dictionary`2.get_Item(TKey key) at xMfxModel.TM_MIS.ParseCustomStatuses() in C:\BuildAgent2\work\405c64e443a47d83\Server\xMfxDataLogic\Logic\TM_MIS.cs:line 440 at xMfxDataLogic.ServiceLogic.Implementation.SubtitlesQcTaskLoad(Decimal taskId) in C:\BuildAgent2\work\405c64e443a47d83\Server\xMfxDataLogic\Logic\ServiceLogic\SubtitleQc.cs:line 68 at iMfxServerCore.Api.v3.SubtitleQcTaskController.GetComponentQcTask(Int32 id) in C:\BuildAgent2\work\405c64e443a47d83\Server\iMfxServerCore\api\controllers\v3\Tasks\SubtitleQcTaskController.cs:line 44 at lambda_method(Closure , Object , Object[] ) at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ActionExecutor.<>c__DisplayClass6_2.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/109473?_dc=1585732590385 System.Web.Http.Routing.HttpRoute t Transfer: 1220 : 12|10:16:32.3107|4PYmNK|DANIEL|OAuth: /api/v3/search/workflow?_dc=1585732592238 t Transfer: 1220 : 12|10:16:32.3107|4PYmNK|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|10:16:32.3107|4PYmNK|DANIEL| OAuth authenticated t Transfer: 1220 : 12|10:16:32.3107|4PYmNK|DANIEL| user DANIEL. t Verbose: 1220 : 12|10:16:32.3107|4PYmNK|DANIEL|OAuth. User logged in: DANIEL t Information: 1220 : 12|10:16:32.3107|4PYmNK|DANIEL|V3Api.SearchWorkflows t Information: 1220 : 12|10:16:32.3107|4PYmNK|DANIEL|V3Api.SearchGeneric t Transfer: 1220 : 12|10:16:32.3107|4PYmNK|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|10:16:32.3107|4PYmNK|DANIEL| OAuth authenticated t Transfer: 1220 : 12|10:16:32.3107|4PYmNK|DANIEL| user DANIEL. t Information: 1220 : 12|10:16:32.3107|4PYmNK|DANIEL|SearchJob SQL: select * from (select a.*, rownum rnum from ( select /*+ INDEX(j JB_CMBST_IDX) */ j.* ,p.pname ,mi.tv_std ,mi.MIID1, mi.MIID2, mi.MIID3, mi.VERSIONID1, mi.VERSIONID2, mi.PROGID1, mi.PROGID2 ,txd.NEXT_TX_DATE FROM tm_mjob j left join tm_mjob_pset p on j.j_sched_indx=p.id left join (select j_id, TMD_str_agg(distinct miid1) MIID1, TMD_str_agg(distinct miid2) MIID2, TMD_str_agg(distinct miid3) MIID3, TMD_str_agg(distinct versionid1) VERSIONID1, TMD_str_agg(distinct versionid2) VERSIONID2, TMD_str_agg(distinct progid1) PROGID1, TMD_str_agg(distinct progid2) PROGID2, TMD_str_agg(distinct m.tv_std) TV_STD from tm_mis m, tm_mtsk_it i where m.id=i.mi_id and i.src_dest in (2,3) group by j_id) mi on mi.j_id=j.id LEFT JOIN ( SELECT it.j_id, min(sch.tx_tm_st) NEXT_TX_DATE FROM TM_MTSK_IT it, TM_MIS m, hr_sched sch WHERE m.id = it.MI_ID AND (sch.prod_num = m.PROGID2 OR sch.prod_num = (select rl.VERSIONID1 from TM_PG_RL rl where rl.ID = m.PGM_PARENT_ID)) AND sch.tx_tm_st > sysdate GROUP BY J_ID) txd ON txd.j_id = j.id where 1=1 AND j.ID=109472 order by j.J_COMPL_BY, j.id desc, j.id ) a where rownum <= 50) where rnum >= 1 order by rnum t Information: 1220 : 12|10:16:32.3107|4PYmNK|DANIEL| jobs returned 1, searched in 00:00:00.0046214 t Information: 1220 : 12|10:16:32.3107|4PYmNK|DANIEL| tasks returned 1, searched in 00:00:00.0027435 t Verbose: 1220 : 12|10:16:32.3107|4PYmNK|DANIEL|imfx v3 API took 0.013s '/api/v3/search/workflow?_dc=1585732592238' t Transfer: 1220 : 12|10:16:56.6857|6rOQYh|DANIEL|OAuth: /api/v3/search/workflow?_dc=1585732616533 t Transfer: 1220 : 12|10:16:56.6857|6rOQYh|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|10:16:56.6857|6rOQYh|DANIEL| OAuth authenticated t Transfer: 1220 : 12|10:16:56.6857|6rOQYh|DANIEL| user DANIEL. t Verbose: 1220 : 12|10:16:56.6857|6rOQYh|DANIEL|OAuth. User logged in: DANIEL t Information: 1220 : 12|10:16:56.6857|6rOQYh|DANIEL|V3Api.SearchWorkflows t Information: 1220 : 12|10:16:56.6857|6rOQYh|DANIEL|V3Api.SearchGeneric t Transfer: 1220 : 12|10:16:56.6857|6rOQYh|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|10:16:56.6857|6rOQYh|DANIEL| OAuth authenticated t Transfer: 1220 : 12|10:16:56.6857|6rOQYh|DANIEL| user DANIEL. t Information: 1220 : 12|10:16:56.6857|6rOQYh|DANIEL|SearchJob SQL: select * from (select a.*, rownum rnum from ( select /*+ INDEX(j JB_CMBST_IDX) */ j.* ,p.pname ,mi.tv_std ,mi.MIID1, mi.MIID2, mi.MIID3, mi.VERSIONID1, mi.VERSIONID2, mi.PROGID1, mi.PROGID2 ,txd.NEXT_TX_DATE FROM tm_mjob j left join tm_mjob_pset p on j.j_sched_indx=p.id left join (select j_id, TMD_str_agg(distinct miid1) MIID1, TMD_str_agg(distinct miid2) MIID2, TMD_str_agg(distinct miid3) MIID3, TMD_str_agg(distinct versionid1) VERSIONID1, TMD_str_agg(distinct versionid2) VERSIONID2, TMD_str_agg(distinct progid1) PROGID1, TMD_str_agg(distinct progid2) PROGID2, TMD_str_agg(distinct m.tv_std) TV_STD from tm_mis m, tm_mtsk_it i where m.id=i.mi_id and i.src_dest in (2,3) group by j_id) mi on mi.j_id=j.id LEFT JOIN ( SELECT it.j_id, min(sch.tx_tm_st) NEXT_TX_DATE FROM TM_MTSK_IT it, TM_MIS m, hr_sched sch WHERE m.id = it.MI_ID AND (sch.prod_num = m.PROGID2 OR sch.prod_num = (select rl.VERSIONID1 from TM_PG_RL rl where rl.ID = m.PGM_PARENT_ID)) AND sch.tx_tm_st > sysdate GROUP BY J_ID) txd ON txd.j_id = j.id where 1=1 AND not ( j.CMB_STAT = 19 and j.J_FAILURE_RESOLVED > 0 ) and j.J_CREATED >= to_date('01/04/2020','DD/MM/YYYY') and j.cmb_stat not in (15,18,23) order by j.J_COMPL_BY, j.id desc, j.id ) a where rownum <= 50) where rnum >= 1 order by rnum t Information: 1220 : 12|10:16:56.6857|6rOQYh|DANIEL| jobs returned 4, searched in 00:00:00.0062470 t Information: 1220 : 12|10:16:56.6857|6rOQYh|DANIEL| tasks returned 4, searched in 00:00:00.0217395 t Verbose: 1220 : 12|10:16:56.6857|6rOQYh|DANIEL|imfx v3 API took 0.035s '/api/v3/search/workflow?_dc=1585732616533' t Transfer: 1220 : 12|10:16:56.6857|_s8uO7|DANIEL|OAuth: /api/user-preferences?_dc=1585732616654 t Transfer: 1220 : 12|10:16:56.6857|_s8uO7|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|10:16:56.6857|_s8uO7|DANIEL| OAuth authenticated t Transfer: 1220 : 12|10:16:56.6857|_s8uO7|DANIEL| user DANIEL. t Verbose: 1220 : 12|10:16:56.6857|_s8uO7|DANIEL|OAuth. User logged in: DANIEL t Verbose: 1220 : 12|10:16:56.6857|_s8uO7|DANIEL|StoreUserDataByKeys.. t Transfer: 1220 : 12|10:16:56.6857|_s8uO7|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|10:16:56.6857|_s8uO7|DANIEL| OAuth authenticated t Transfer: 1220 : 12|10:16:56.6857|_s8uO7|DANIEL| user DANIEL. t Verbose: 1220 : 12|10:16:56.8888|_s8uO7|DANIEL|imfx v3 API took 0.009s '/api/user-preferences?_dc=1585732616654' t Transfer: 1220 : 12|10:16:59.3263|50Fk38|DANIEL|OAuth: /api/v3/task/componentqc/109477?_dc=1585732619213 t Transfer: 1220 : 12|10:16:59.3263|50Fk38|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|10:16:59.3263|50Fk38|DANIEL| OAuth authenticated t Transfer: 1220 : 12|10:16:59.3263|50Fk38|DANIEL| user DANIEL. t Verbose: 1220 : 12|10:16:59.3263|50Fk38|DANIEL|OAuth. User logged in: DANIEL t Information: 1220 : 12|10:16:59.3263|50Fk38|DANIEL|V3Api. GetComponentQc task: 109477 t Information: 1220 : 12|10:16:59.3263|50Fk38|DANIEL|SubtitleQcTask. LoadFromDb got Job 109476 and Subtitles 1. t Verbose: 1220 : 12|10:16:59.3263|50Fk38|DANIEL|imfx v3 API took 0.031s '/api/v3/task/componentqc/109477?_dc=1585732619213' t Information: 1220 : 12|10:16:59.3263|50Fk38|DANIEL|V3 Api exception handler: System.Collections.Generic.KeyNotFoundException: The given key was not present in the dictionary. at System.Collections.Generic.Dictionary`2.get_Item(TKey key) at xMfxModel.TM_MIS.ParseCustomStatuses() in C:\BuildAgent2\work\405c64e443a47d83\Server\xMfxDataLogic\Logic\TM_MIS.cs:line 440 at xMfxDataLogic.ServiceLogic.Implementation.SubtitlesQcTaskLoad(Decimal taskId) in C:\BuildAgent2\work\405c64e443a47d83\Server\xMfxDataLogic\Logic\ServiceLogic\SubtitleQc.cs:line 68 at iMfxServerCore.Api.v3.SubtitleQcTaskController.GetComponentQcTask(Int32 id) in C:\BuildAgent2\work\405c64e443a47d83\Server\iMfxServerCore\api\controllers\v3\Tasks\SubtitleQcTaskController.cs:line 44 at lambda_method(Closure , Object , Object[] ) at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ActionExecutor.<>c__DisplayClass6_2.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/109477?_dc=1585732619213 System.Web.Http.Routing.HttpRoute t Transfer: 1220 : 12|10:17:01.1544|zXRke3|DANIEL|OAuth: /api/v3/search/workflow?_dc=1585732621044 t Transfer: 1220 : 12|10:17:01.1544|zXRke3|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|10:17:01.1544|zXRke3|DANIEL| OAuth authenticated t Transfer: 1220 : 12|10:17:01.1544|zXRke3|DANIEL| user DANIEL. t Verbose: 1220 : 12|10:17:01.1544|zXRke3|DANIEL|OAuth. User logged in: DANIEL t Information: 1220 : 12|10:17:01.1544|zXRke3|DANIEL|V3Api.SearchWorkflows t Information: 1220 : 12|10:17:01.1544|zXRke3|DANIEL|V3Api.SearchGeneric t Transfer: 1220 : 12|10:17:01.1544|zXRke3|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|10:17:01.1544|zXRke3|DANIEL| OAuth authenticated t Transfer: 1220 : 12|10:17:01.1544|zXRke3|DANIEL| user DANIEL. t Information: 1220 : 12|10:17:01.1544|zXRke3|DANIEL|SearchJob SQL: select * from (select a.*, rownum rnum from ( select /*+ INDEX(j JB_CMBST_IDX) */ j.* ,p.pname ,mi.tv_std ,mi.MIID1, mi.MIID2, mi.MIID3, mi.VERSIONID1, mi.VERSIONID2, mi.PROGID1, mi.PROGID2 ,txd.NEXT_TX_DATE FROM tm_mjob j left join tm_mjob_pset p on j.j_sched_indx=p.id left join (select j_id, TMD_str_agg(distinct miid1) MIID1, TMD_str_agg(distinct miid2) MIID2, TMD_str_agg(distinct miid3) MIID3, TMD_str_agg(distinct versionid1) VERSIONID1, TMD_str_agg(distinct versionid2) VERSIONID2, TMD_str_agg(distinct progid1) PROGID1, TMD_str_agg(distinct progid2) PROGID2, TMD_str_agg(distinct m.tv_std) TV_STD from tm_mis m, tm_mtsk_it i where m.id=i.mi_id and i.src_dest in (2,3) group by j_id) mi on mi.j_id=j.id LEFT JOIN ( SELECT it.j_id, min(sch.tx_tm_st) NEXT_TX_DATE FROM TM_MTSK_IT it, TM_MIS m, hr_sched sch WHERE m.id = it.MI_ID AND (sch.prod_num = m.PROGID2 OR sch.prod_num = (select rl.VERSIONID1 from TM_PG_RL rl where rl.ID = m.PGM_PARENT_ID)) AND sch.tx_tm_st > sysdate GROUP BY J_ID) txd ON txd.j_id = j.id where 1=1 AND j.ID=109476 order by j.J_COMPL_BY, j.id desc, j.id ) a where rownum <= 50) where rnum >= 1 order by rnum t Information: 1220 : 12|10:17:01.3576|zXRke3|DANIEL| jobs returned 1, searched in 00:00:00.1526396 t Information: 1220 : 12|10:17:01.3576|zXRke3|DANIEL| tasks returned 1, searched in 00:00:00.0271076 t Verbose: 1220 : 12|10:17:01.3576|zXRke3|DANIEL|imfx v3 API took 0.193s '/api/v3/search/workflow?_dc=1585732621044' t Transfer: 1220 : 12|10:18:18.1388|8Hy5Hi|DANIEL|OAuth: /api/v3/search/workflow?_dc=1585732697925 t Transfer: 1220 : 12|10:18:18.1388|8Hy5Hi|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|10:18:18.1388|8Hy5Hi|DANIEL| OAuth authenticated t Transfer: 1220 : 12|10:18:18.1388|8Hy5Hi|DANIEL| user DANIEL. t Verbose: 1220 : 12|10:18:18.1388|8Hy5Hi|DANIEL|OAuth. User logged in: DANIEL t Information: 1220 : 12|10:18:18.1388|8Hy5Hi|DANIEL|V3Api.SearchWorkflows t Information: 1220 : 12|10:18:18.1388|8Hy5Hi|DANIEL|V3Api.SearchGeneric t Transfer: 1220 : 12|10:18:18.1388|8Hy5Hi|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|10:18:18.1388|8Hy5Hi|DANIEL| OAuth authenticated t Transfer: 1220 : 12|10:18:18.1388|8Hy5Hi|DANIEL| user DANIEL. t Information: 1220 : 12|10:18:18.1388|8Hy5Hi|DANIEL|SearchJob SQL: select * from (select a.*, rownum rnum from ( select /*+ INDEX(j JB_CMBST_IDX) */ j.* ,p.pname ,mi.tv_std ,mi.MIID1, mi.MIID2, mi.MIID3, mi.VERSIONID1, mi.VERSIONID2, mi.PROGID1, mi.PROGID2 ,txd.NEXT_TX_DATE FROM tm_mjob j left join tm_mjob_pset p on j.j_sched_indx=p.id left join (select j_id, TMD_str_agg(distinct miid1) MIID1, TMD_str_agg(distinct miid2) MIID2, TMD_str_agg(distinct miid3) MIID3, TMD_str_agg(distinct versionid1) VERSIONID1, TMD_str_agg(distinct versionid2) VERSIONID2, TMD_str_agg(distinct progid1) PROGID1, TMD_str_agg(distinct progid2) PROGID2, TMD_str_agg(distinct m.tv_std) TV_STD from tm_mis m, tm_mtsk_it i where m.id=i.mi_id and i.src_dest in (2,3) group by j_id) mi on mi.j_id=j.id LEFT JOIN ( SELECT it.j_id, min(sch.tx_tm_st) NEXT_TX_DATE FROM TM_MTSK_IT it, TM_MIS m, hr_sched sch WHERE m.id = it.MI_ID AND (sch.prod_num = m.PROGID2 OR sch.prod_num = (select rl.VERSIONID1 from TM_PG_RL rl where rl.ID = m.PGM_PARENT_ID)) AND sch.tx_tm_st > sysdate GROUP BY J_ID) txd ON txd.j_id = j.id where 1=1 AND not ( j.CMB_STAT = 19 and j.J_FAILURE_RESOLVED > 0 ) and j.J_CREATED >= to_date('01/04/2020','DD/MM/YYYY') and j.cmb_stat not in (15,18,23) order by j.J_COMPL_BY, j.id desc, j.id ) a where rownum <= 50) where rnum >= 1 order by rnum t Information: 1220 : 12|10:18:18.1388|8Hy5Hi|DANIEL| jobs returned 5, searched in 00:00:00.0064841 t Information: 1220 : 12|10:18:18.1388|8Hy5Hi|DANIEL| tasks returned 5, searched in 00:00:00.0268993 t Verbose: 1220 : 12|10:18:18.1388|8Hy5Hi|DANIEL|imfx v3 API took 0.040s '/api/v3/search/workflow?_dc=1585732697925' t Transfer: 1220 : 12|10:18:18.1388|K8mKNl|DANIEL|OAuth: /api/user-preferences?_dc=1585732698029 t Transfer: 1220 : 12|10:18:18.1388|K8mKNl|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|10:18:18.1388|K8mKNl|DANIEL| OAuth authenticated t Transfer: 1220 : 12|10:18:18.1388|K8mKNl|DANIEL| user DANIEL. t Verbose: 1220 : 12|10:18:18.1388|K8mKNl|DANIEL|OAuth. User logged in: DANIEL t Verbose: 1220 : 12|10:18:18.1388|K8mKNl|DANIEL|StoreUserDataByKeys.. t Transfer: 1220 : 12|10:18:18.1388|K8mKNl|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|10:18:18.1388|K8mKNl|DANIEL| OAuth authenticated t Transfer: 1220 : 12|10:18:18.1388|K8mKNl|DANIEL| user DANIEL. t Verbose: 1220 : 12|10:18:18.1388|K8mKNl|DANIEL|imfx v3 API took 0.009s '/api/user-preferences?_dc=1585732698029' t Transfer: 1220 : 12|10:18:20.1701|L_wphR|DANIEL|OAuth: /api/v3/task/componentqc/109481?_dc=1585732700102 t Transfer: 1220 : 12|10:18:20.1701|L_wphR|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|10:18:20.1701|L_wphR|DANIEL| OAuth authenticated t Transfer: 1220 : 12|10:18:20.1701|L_wphR|DANIEL| user DANIEL. t Verbose: 1220 : 12|10:18:20.1701|L_wphR|DANIEL|OAuth. User logged in: DANIEL t Information: 1220 : 12|10:18:20.1701|L_wphR|DANIEL|V3Api. GetComponentQc task: 109481 t Information: 1220 : 12|10:18:20.1701|L_wphR|DANIEL|SubtitleQcTask. LoadFromDb got Job 109480 and Subtitles 2. t Verbose: 1220 : 12|10:18:20.1701|L_wphR|DANIEL|imfx v3 API took 0.036s '/api/v3/task/componentqc/109481?_dc=1585732700102' t Information: 1220 : 12|10:18:20.1701|L_wphR|DANIEL|V3 Api exception handler: System.Collections.Generic.KeyNotFoundException: The given key was not present in the dictionary. at System.Collections.Generic.Dictionary`2.get_Item(TKey key) at xMfxModel.TM_MIS.ParseCustomStatuses() in C:\BuildAgent2\work\405c64e443a47d83\Server\xMfxDataLogic\Logic\TM_MIS.cs:line 440 at xMfxDataLogic.ServiceLogic.Implementation.SubtitlesQcTaskLoad(Decimal taskId) in C:\BuildAgent2\work\405c64e443a47d83\Server\xMfxDataLogic\Logic\ServiceLogic\SubtitleQc.cs:line 68 at iMfxServerCore.Api.v3.SubtitleQcTaskController.GetComponentQcTask(Int32 id) in C:\BuildAgent2\work\405c64e443a47d83\Server\iMfxServerCore\api\controllers\v3\Tasks\SubtitleQcTaskController.cs:line 44 at lambda_method(Closure , Object , Object[] ) at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ActionExecutor.<>c__DisplayClass6_2.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/109481?_dc=1585732700102 System.Web.Http.Routing.HttpRoute t Transfer: 1220 : 12|10:18:23.6388|lUhTw1|DANIEL|OAuth: /api/v3/search/workflow?_dc=1585732703601 t Transfer: 1220 : 12|10:18:23.6388|lUhTw1|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|10:18:23.6388|lUhTw1|DANIEL| OAuth authenticated t Transfer: 1220 : 12|10:18:23.6388|lUhTw1|DANIEL| user DANIEL. t Verbose: 1220 : 12|10:18:23.6388|lUhTw1|DANIEL|OAuth. User logged in: DANIEL t Information: 1220 : 12|10:18:23.6388|lUhTw1|DANIEL|V3Api.SearchWorkflows t Information: 1220 : 12|10:18:23.6388|lUhTw1|DANIEL|V3Api.SearchGeneric t Transfer: 1220 : 12|10:18:23.6388|lUhTw1|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|10:18:23.6388|lUhTw1|DANIEL| OAuth authenticated t Transfer: 1220 : 12|10:18:23.6388|lUhTw1|DANIEL| user DANIEL. t Information: 1220 : 12|10:18:23.6388|lUhTw1|DANIEL|SearchJob SQL: select * from (select a.*, rownum rnum from ( select /*+ INDEX(j JB_CMBST_IDX) */ j.* ,p.pname ,mi.tv_std ,mi.MIID1, mi.MIID2, mi.MIID3, mi.VERSIONID1, mi.VERSIONID2, mi.PROGID1, mi.PROGID2 ,txd.NEXT_TX_DATE FROM tm_mjob j left join tm_mjob_pset p on j.j_sched_indx=p.id left join (select j_id, TMD_str_agg(distinct miid1) MIID1, TMD_str_agg(distinct miid2) MIID2, TMD_str_agg(distinct miid3) MIID3, TMD_str_agg(distinct versionid1) VERSIONID1, TMD_str_agg(distinct versionid2) VERSIONID2, TMD_str_agg(distinct progid1) PROGID1, TMD_str_agg(distinct progid2) PROGID2, TMD_str_agg(distinct m.tv_std) TV_STD from tm_mis m, tm_mtsk_it i where m.id=i.mi_id and i.src_dest in (2,3) group by j_id) mi on mi.j_id=j.id LEFT JOIN ( SELECT it.j_id, min(sch.tx_tm_st) NEXT_TX_DATE FROM TM_MTSK_IT it, TM_MIS m, hr_sched sch WHERE m.id = it.MI_ID AND (sch.prod_num = m.PROGID2 OR sch.prod_num = (select rl.VERSIONID1 from TM_PG_RL rl where rl.ID = m.PGM_PARENT_ID)) AND sch.tx_tm_st > sysdate GROUP BY J_ID) txd ON txd.j_id = j.id where 1=1 AND j.ID=109480 order by j.J_COMPL_BY, j.id desc, j.id ) a where rownum <= 50) where rnum >= 1 order by rnum t Information: 1220 : 12|10:18:23.8419|lUhTw1|DANIEL| jobs returned 1, searched in 00:00:00.1631032 t Information: 1220 : 12|10:18:23.8419|lUhTw1|DANIEL| tasks returned 1, searched in 00:00:00.0246492 t Verbose: 1220 : 12|10:18:23.8419|lUhTw1|DANIEL|imfx v3 API took 0.201s '/api/v3/search/workflow?_dc=1585732703601' t Transfer: 1220 : 12|10:20:26.3576|DKMPnq|DANIEL|OAuth: /api/v3/search/workflow?_dc=1585732826116 t Transfer: 1220 : 12|10:20:26.3576|DKMPnq|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|10:20:26.3576|DKMPnq|DANIEL| OAuth authenticated t Transfer: 1220 : 12|10:20:26.3576|DKMPnq|DANIEL| user DANIEL. t Verbose: 1220 : 12|10:20:26.3576|DKMPnq|DANIEL|OAuth. User logged in: DANIEL t Information: 1220 : 12|10:20:26.3576|DKMPnq|DANIEL|V3Api.SearchWorkflows t Information: 1220 : 12|10:20:26.3576|DKMPnq|DANIEL|V3Api.SearchGeneric t Transfer: 1220 : 12|10:20:26.3576|DKMPnq|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|10:20:26.3576|DKMPnq|DANIEL| OAuth authenticated t Transfer: 1220 : 12|10:20:26.3576|DKMPnq|DANIEL| user DANIEL. t Information: 1220 : 12|10:20:26.3576|DKMPnq|DANIEL|SearchJob SQL: select * from (select a.*, rownum rnum from ( select /*+ INDEX(j JB_CMBST_IDX) */ j.* ,p.pname ,mi.tv_std ,mi.MIID1, mi.MIID2, mi.MIID3, mi.VERSIONID1, mi.VERSIONID2, mi.PROGID1, mi.PROGID2 ,txd.NEXT_TX_DATE FROM tm_mjob j left join tm_mjob_pset p on j.j_sched_indx=p.id left join (select j_id, TMD_str_agg(distinct miid1) MIID1, TMD_str_agg(distinct miid2) MIID2, TMD_str_agg(distinct miid3) MIID3, TMD_str_agg(distinct versionid1) VERSIONID1, TMD_str_agg(distinct versionid2) VERSIONID2, TMD_str_agg(distinct progid1) PROGID1, TMD_str_agg(distinct progid2) PROGID2, TMD_str_agg(distinct m.tv_std) TV_STD from tm_mis m, tm_mtsk_it i where m.id=i.mi_id and i.src_dest in (2,3) group by j_id) mi on mi.j_id=j.id LEFT JOIN ( SELECT it.j_id, min(sch.tx_tm_st) NEXT_TX_DATE FROM TM_MTSK_IT it, TM_MIS m, hr_sched sch WHERE m.id = it.MI_ID AND (sch.prod_num = m.PROGID2 OR sch.prod_num = (select rl.VERSIONID1 from TM_PG_RL rl where rl.ID = m.PGM_PARENT_ID)) AND sch.tx_tm_st > sysdate GROUP BY J_ID) txd ON txd.j_id = j.id where 1=1 AND not ( j.CMB_STAT = 19 and j.J_FAILURE_RESOLVED > 0 ) and j.J_CREATED >= to_date('01/04/2020','DD/MM/YYYY') and j.cmb_stat not in (15,18,23) order by j.J_COMPL_BY, j.id desc, j.id ) a where rownum <= 50) where rnum >= 1 order by rnum t Information: 1220 : 12|10:20:26.3576|DKMPnq|DANIEL| jobs returned 7, searched in 00:00:00.0076716 t Information: 1220 : 12|10:20:26.3576|DKMPnq|DANIEL| tasks returned 7, searched in 00:00:00.0810791 t Verbose: 1220 : 12|10:20:26.3576|DKMPnq|DANIEL|imfx v3 API took 0.096s '/api/v3/search/workflow?_dc=1585732826116' t Transfer: 1220 : 12|10:20:26.5763|tNCKHG|DANIEL|OAuth: /api/user-preferences?_dc=1585732826415 t Transfer: 1220 : 12|10:20:26.5763|tNCKHG|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|10:20:26.5763|tNCKHG|DANIEL| OAuth authenticated t Transfer: 1220 : 12|10:20:26.5763|tNCKHG|DANIEL| user DANIEL. t Verbose: 1220 : 12|10:20:26.5763|tNCKHG|DANIEL|OAuth. User logged in: DANIEL t Verbose: 1220 : 12|10:20:26.5763|tNCKHG|DANIEL|StoreUserDataByKeys.. t Transfer: 1220 : 12|10:20:26.5763|tNCKHG|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|10:20:26.5763|tNCKHG|DANIEL| OAuth authenticated t Transfer: 1220 : 12|10:20:26.5763|tNCKHG|DANIEL| user DANIEL. t Verbose: 1220 : 12|10:20:26.5763|tNCKHG|DANIEL|imfx v3 API took 0.010s '/api/user-preferences?_dc=1585732826415' t Transfer: 1220 : 12|10:20:30.4357|kVbQaF|DANIEL|OAuth: /api/v3/task/componentqc/109487?_dc=1585732830294 t Transfer: 1220 : 12|10:20:30.4357|kVbQaF|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|10:20:30.4357|kVbQaF|DANIEL| OAuth authenticated t Transfer: 1220 : 12|10:20:30.4357|kVbQaF|DANIEL| user DANIEL. t Verbose: 1220 : 12|10:20:30.4357|kVbQaF|DANIEL|OAuth. User logged in: DANIEL t Information: 1220 : 12|10:20:30.4357|kVbQaF|DANIEL|V3Api. GetComponentQc task: 109487 t Information: 1220 : 12|10:20:30.4357|kVbQaF|DANIEL|SubtitleQcTask. LoadFromDb got Job 109486 and Subtitles 2. t Verbose: 1220 : 12|10:20:30.4357|kVbQaF|DANIEL|imfx v3 API took 0.029s '/api/v3/task/componentqc/109487?_dc=1585732830294' t Information: 1220 : 12|10:20:30.4357|kVbQaF|DANIEL|V3 Api exception handler: System.Collections.Generic.KeyNotFoundException: The given key was not present in the dictionary. at System.Collections.Generic.Dictionary`2.get_Item(TKey key) at xMfxModel.TM_MIS.ParseCustomStatuses() in C:\BuildAgent2\work\405c64e443a47d83\Server\xMfxDataLogic\Logic\TM_MIS.cs:line 440 at xMfxDataLogic.ServiceLogic.Implementation.SubtitlesQcTaskLoad(Decimal taskId) in C:\BuildAgent2\work\405c64e443a47d83\Server\xMfxDataLogic\Logic\ServiceLogic\SubtitleQc.cs:line 68 at iMfxServerCore.Api.v3.SubtitleQcTaskController.GetComponentQcTask(Int32 id) in C:\BuildAgent2\work\405c64e443a47d83\Server\iMfxServerCore\api\controllers\v3\Tasks\SubtitleQcTaskController.cs:line 44 at lambda_method(Closure , Object , Object[] ) at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ActionExecutor.<>c__DisplayClass6_2.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/109487?_dc=1585732830294 System.Web.Http.Routing.HttpRoute t Transfer: 1220 : 12|10:20:32.0607|MmeUQV|DANIEL|OAuth: /api/v3/search/workflow?_dc=1585732831981 t Transfer: 1220 : 12|10:20:32.0607|MmeUQV|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|10:20:32.0607|MmeUQV|DANIEL| OAuth authenticated t Transfer: 1220 : 12|10:20:32.0607|MmeUQV|DANIEL| user DANIEL. t Verbose: 1220 : 12|10:20:32.0607|MmeUQV|DANIEL|OAuth. User logged in: DANIEL t Information: 1220 : 12|10:20:32.0607|MmeUQV|DANIEL|V3Api.SearchWorkflows t Information: 1220 : 12|10:20:32.0607|MmeUQV|DANIEL|V3Api.SearchGeneric t Transfer: 1220 : 12|10:20:32.0607|MmeUQV|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|10:20:32.0607|MmeUQV|DANIEL| OAuth authenticated t Transfer: 1220 : 12|10:20:32.0607|MmeUQV|DANIEL| user DANIEL. t Information: 1220 : 12|10:20:32.0607|MmeUQV|DANIEL|SearchJob SQL: select * from (select a.*, rownum rnum from ( select /*+ INDEX(j JB_CMBST_IDX) */ j.* ,p.pname ,mi.tv_std ,mi.MIID1, mi.MIID2, mi.MIID3, mi.VERSIONID1, mi.VERSIONID2, mi.PROGID1, mi.PROGID2 ,txd.NEXT_TX_DATE FROM tm_mjob j left join tm_mjob_pset p on j.j_sched_indx=p.id left join (select j_id, TMD_str_agg(distinct miid1) MIID1, TMD_str_agg(distinct miid2) MIID2, TMD_str_agg(distinct miid3) MIID3, TMD_str_agg(distinct versionid1) VERSIONID1, TMD_str_agg(distinct versionid2) VERSIONID2, TMD_str_agg(distinct progid1) PROGID1, TMD_str_agg(distinct progid2) PROGID2, TMD_str_agg(distinct m.tv_std) TV_STD from tm_mis m, tm_mtsk_it i where m.id=i.mi_id and i.src_dest in (2,3) group by j_id) mi on mi.j_id=j.id LEFT JOIN ( SELECT it.j_id, min(sch.tx_tm_st) NEXT_TX_DATE FROM TM_MTSK_IT it, TM_MIS m, hr_sched sch WHERE m.id = it.MI_ID AND (sch.prod_num = m.PROGID2 OR sch.prod_num = (select rl.VERSIONID1 from TM_PG_RL rl where rl.ID = m.PGM_PARENT_ID)) AND sch.tx_tm_st > sysdate GROUP BY J_ID) txd ON txd.j_id = j.id where 1=1 AND j.ID=109486 order by j.J_COMPL_BY, j.id desc, j.id ) a where rownum <= 50) where rnum >= 1 order by rnum t Information: 1220 : 12|10:20:32.2638|MmeUQV|DANIEL| jobs returned 1, searched in 00:00:00.1805557 t Information: 1220 : 12|10:20:32.2638|MmeUQV|DANIEL| tasks returned 1, searched in 00:00:00.0187916 t Verbose: 1220 : 12|10:20:32.2638|MmeUQV|DANIEL|imfx v3 API took 0.216s '/api/v3/search/workflow?_dc=1585732831981' t Transfer: 1220 : 12|10:20:34.0920|DAq0zA|DANIEL|OAuth: /api/v3/task/componentqc/109492?_dc=1585732834036 t Transfer: 1220 : 12|10:20:34.0920|DAq0zA|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|10:20:34.0920|DAq0zA|DANIEL| OAuth authenticated t Transfer: 1220 : 12|10:20:34.0920|DAq0zA|DANIEL| user DANIEL. t Verbose: 1220 : 12|10:20:34.0920|DAq0zA|DANIEL|OAuth. User logged in: DANIEL t Information: 1220 : 12|10:20:34.0920|DAq0zA|DANIEL|V3Api. GetComponentQc task: 109492 t Information: 1220 : 12|10:20:34.0920|DAq0zA|DANIEL|SubtitleQcTask. LoadFromDb got Job 109491 and Subtitles 2. t Verbose: 1220 : 12|10:20:34.0920|DAq0zA|DANIEL|imfx v3 API took 0.018s '/api/v3/task/componentqc/109492?_dc=1585732834036' t Information: 1220 : 12|10:20:34.0920|DAq0zA|DANIEL|V3 Api exception handler: System.Collections.Generic.KeyNotFoundException: The given key was not present in the dictionary. at System.Collections.Generic.Dictionary`2.get_Item(TKey key) at xMfxModel.TM_MIS.ParseCustomStatuses() in C:\BuildAgent2\work\405c64e443a47d83\Server\xMfxDataLogic\Logic\TM_MIS.cs:line 440 at xMfxDataLogic.ServiceLogic.Implementation.SubtitlesQcTaskLoad(Decimal taskId) in C:\BuildAgent2\work\405c64e443a47d83\Server\xMfxDataLogic\Logic\ServiceLogic\SubtitleQc.cs:line 68 at iMfxServerCore.Api.v3.SubtitleQcTaskController.GetComponentQcTask(Int32 id) in C:\BuildAgent2\work\405c64e443a47d83\Server\iMfxServerCore\api\controllers\v3\Tasks\SubtitleQcTaskController.cs:line 44 at lambda_method(Closure , Object , Object[] ) at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ActionExecutor.<>c__DisplayClass6_2.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/109492?_dc=1585732834036 System.Web.Http.Routing.HttpRoute t Transfer: 1220 : 12|10:20:36.5295|MgMwsx|DANIEL|OAuth: /api/v3/search/workflow?_dc=1585732836480 t Transfer: 1220 : 12|10:20:36.5295|MgMwsx|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|10:20:36.5295|MgMwsx|DANIEL| OAuth authenticated t Transfer: 1220 : 12|10:20:36.5295|MgMwsx|DANIEL| user DANIEL. t Verbose: 1220 : 12|10:20:36.5295|MgMwsx|DANIEL|OAuth. User logged in: DANIEL t Information: 1220 : 12|10:20:36.5295|MgMwsx|DANIEL|V3Api.SearchWorkflows t Information: 1220 : 12|10:20:36.5295|MgMwsx|DANIEL|V3Api.SearchGeneric t Transfer: 1220 : 12|10:20:36.5295|MgMwsx|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|10:20:36.5295|MgMwsx|DANIEL| OAuth authenticated t Transfer: 1220 : 12|10:20:36.5295|MgMwsx|DANIEL| user DANIEL. t Information: 1220 : 12|10:20:36.5295|MgMwsx|DANIEL|SearchJob SQL: select * from (select a.*, rownum rnum from ( select /*+ INDEX(j JB_CMBST_IDX) */ j.* ,p.pname ,mi.tv_std ,mi.MIID1, mi.MIID2, mi.MIID3, mi.VERSIONID1, mi.VERSIONID2, mi.PROGID1, mi.PROGID2 ,txd.NEXT_TX_DATE FROM tm_mjob j left join tm_mjob_pset p on j.j_sched_indx=p.id left join (select j_id, TMD_str_agg(distinct miid1) MIID1, TMD_str_agg(distinct miid2) MIID2, TMD_str_agg(distinct miid3) MIID3, TMD_str_agg(distinct versionid1) VERSIONID1, TMD_str_agg(distinct versionid2) VERSIONID2, TMD_str_agg(distinct progid1) PROGID1, TMD_str_agg(distinct progid2) PROGID2, TMD_str_agg(distinct m.tv_std) TV_STD from tm_mis m, tm_mtsk_it i where m.id=i.mi_id and i.src_dest in (2,3) group by j_id) mi on mi.j_id=j.id LEFT JOIN ( SELECT it.j_id, min(sch.tx_tm_st) NEXT_TX_DATE FROM TM_MTSK_IT it, TM_MIS m, hr_sched sch WHERE m.id = it.MI_ID AND (sch.prod_num = m.PROGID2 OR sch.prod_num = (select rl.VERSIONID1 from TM_PG_RL rl where rl.ID = m.PGM_PARENT_ID)) AND sch.tx_tm_st > sysdate GROUP BY J_ID) txd ON txd.j_id = j.id where 1=1 AND j.ID=109491 order by j.J_COMPL_BY, j.id desc, j.id ) a where rownum <= 50) where rnum >= 1 order by rnum t Information: 1220 : 12|10:20:36.7326|MgMwsx|DANIEL| jobs returned 1, searched in 00:00:00.1405094 t Information: 1220 : 12|10:20:36.7326|MgMwsx|DANIEL| tasks returned 1, searched in 00:00:00.0199120 t Verbose: 1220 : 12|10:20:36.7326|MgMwsx|DANIEL|imfx v3 API took 0.174s '/api/v3/search/workflow?_dc=1585732836480' t Transfer: 1220 : 12|10:22:19.3107|NvLwS~|DANIEL|OAuth: /api/v3/config/servicexml/types?_dc=1585732939200 t Transfer: 1220 : 12|10:22:19.3107|NvLwS~|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|10:22:19.3107|NvLwS~|DANIEL| OAuth authenticated t Transfer: 1220 : 12|10:22:19.3107|NvLwS~|DANIEL| user DANIEL. t Verbose: 1220 : 12|10:22:19.3107|NvLwS~|DANIEL|OAuth. User logged in: DANIEL t Verbose: 1220 : 12|10:22:19.3107|NvLwS~|DANIEL|imfx v3 API took 0.005s '/api/v3/config/servicexml/types?_dc=1585732939200' t Transfer: 1220 : 12|10:22:19.3107|Z0If5C|DANIEL|OAuth: /api/settings/groups/?_dc=1585732939283 t Transfer: 1220 : 12|10:22:19.3107|Z0If5C|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|10:22:19.3107|Z0If5C|DANIEL| OAuth authenticated t Transfer: 1220 : 12|10:22:19.3107|Z0If5C|DANIEL| user DANIEL. t Verbose: 1220 : 12|10:22:19.3107|Z0If5C|DANIEL|OAuth. User logged in: DANIEL t Verbose: 1220 : 12|10:22:19.5138|Z0If5C|DANIEL|imfx v3 API took 0.015s '/api/settings/groups/?_dc=1585732939283' t Transfer: 1220 : 12|10:22:21.7482|pMuS7A|DANIEL|OAuth: /api/v3/config-tables?_dc=1585732941637 t Transfer: 1220 : 12|10:22:21.7482|pMuS7A|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|10:22:21.7482|pMuS7A|DANIEL| OAuth authenticated t Transfer: 1220 : 12|10:22:21.7482|pMuS7A|DANIEL| user DANIEL. t Verbose: 1220 : 12|10:22:21.7482|pMuS7A|DANIEL|OAuth. User logged in: DANIEL t Verbose: 1220 : 12|10:22:21.7482|pMuS7A|DANIEL|imfx v3 API took 0.010s '/api/v3/config-tables?_dc=1585732941637' t Information: 1220 : 12|10:22:25.6076|OjvrCd|DANIEL|GetConfig TM_CFG_MEDIA_FILE_TYPES. t Verbose: 1220 : 12|10:22:25.8107|OjvrCd|DANIEL|imfx v3 API took 0.097s '/api/v3/config-table/TM_CFG_MEDIA_FILE_TYPES?_dc=1585732945513' t Transfer: 1220 : 12|10:23:36.2951|0tP2yb|DANIEL|OAuth: /api/v3/search/workflow?_dc=1585733016207 t Transfer: 1220 : 12|10:23:36.2951|0tP2yb|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|10:23:36.2951|0tP2yb|DANIEL| OAuth authenticated t Transfer: 1220 : 12|10:23:36.2951|0tP2yb|DANIEL| user DANIEL. t Verbose: 1220 : 12|10:23:36.2951|0tP2yb|DANIEL|OAuth. User logged in: DANIEL t Information: 1220 : 12|10:23:36.2951|0tP2yb|DANIEL|V3Api.SearchWorkflows t Information: 1220 : 12|10:23:36.2951|0tP2yb|DANIEL|V3Api.SearchGeneric t Transfer: 1220 : 12|10:23:36.2951|0tP2yb|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|10:23:36.2951|0tP2yb|DANIEL| OAuth authenticated t Transfer: 1220 : 12|10:23:36.2951|0tP2yb|DANIEL| user DANIEL. t Information: 1220 : 12|10:23:36.2951|0tP2yb|DANIEL|SearchJob SQL: select * from (select a.*, rownum rnum from ( select /*+ INDEX(j JB_CMBST_IDX) */ j.* ,p.pname ,mi.tv_std ,mi.MIID1, mi.MIID2, mi.MIID3, mi.VERSIONID1, mi.VERSIONID2, mi.PROGID1, mi.PROGID2 ,txd.NEXT_TX_DATE FROM tm_mjob j left join tm_mjob_pset p on j.j_sched_indx=p.id left join (select j_id, TMD_str_agg(distinct miid1) MIID1, TMD_str_agg(distinct miid2) MIID2, TMD_str_agg(distinct miid3) MIID3, TMD_str_agg(distinct versionid1) VERSIONID1, TMD_str_agg(distinct versionid2) VERSIONID2, TMD_str_agg(distinct progid1) PROGID1, TMD_str_agg(distinct progid2) PROGID2, TMD_str_agg(distinct m.tv_std) TV_STD from tm_mis m, tm_mtsk_it i where m.id=i.mi_id and i.src_dest in (2,3) group by j_id) mi on mi.j_id=j.id LEFT JOIN ( SELECT it.j_id, min(sch.tx_tm_st) NEXT_TX_DATE FROM TM_MTSK_IT it, TM_MIS m, hr_sched sch WHERE m.id = it.MI_ID AND (sch.prod_num = m.PROGID2 OR sch.prod_num = (select rl.VERSIONID1 from TM_PG_RL rl where rl.ID = m.PGM_PARENT_ID)) AND sch.tx_tm_st > sysdate GROUP BY J_ID) txd ON txd.j_id = j.id where 1=1 AND j.ID=109491 order by j.J_COMPL_BY, j.id desc, j.id ) a where rownum <= 50) where rnum >= 1 order by rnum t Information: 1220 : 12|10:23:36.2951|0tP2yb|DANIEL| jobs returned 1, searched in 00:00:00.0055295 t Information: 1220 : 12|10:23:36.2951|0tP2yb|DANIEL| tasks returned 1, searched in 00:00:00.0062226 t Verbose: 1220 : 12|10:23:36.2951|0tP2yb|DANIEL|imfx v3 API took 0.018s '/api/v3/search/workflow?_dc=1585733016207' t Transfer: 1220 : 12|10:24:10.8263|vode2f|DANIEL|OAuth: /api/lookups/Presets?_dc=1585733050697 t Transfer: 1220 : 12|10:24:10.8263|vode2f|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|10:24:10.8263|vode2f|DANIEL| OAuth authenticated t Transfer: 1220 : 12|10:24:10.8263|vode2f|DANIEL| user DANIEL. t Verbose: 1220 : 12|10:24:10.8263|vode2f|DANIEL|OAuth. User logged in: DANIEL t Transfer: 1220 : 12|10:24:10.8263|vode2f|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|10:24:10.8263|vode2f|DANIEL| OAuth authenticated t Transfer: 1220 : 12|10:24:10.8263|vode2f|DANIEL| user DANIEL. t Verbose: 1220 : 12|10:24:10.8263|vode2f|DANIEL|imfx v3 API took 0.029s '/api/lookups/Presets?_dc=1585733050697' t Transfer: 1220 : 12|10:24:17.9357|vQLevP|DANIEL|OAuth: /api/v3/search/workflow?_dc=1585733057866 t Transfer: 1220 : 12|10:24:17.9357|vQLevP|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|10:24:17.9357|vQLevP|DANIEL| OAuth authenticated t Transfer: 1220 : 12|10:24:17.9357|vQLevP|DANIEL| user DANIEL. t Verbose: 1220 : 12|10:24:17.9357|vQLevP|DANIEL|OAuth. User logged in: DANIEL t Information: 1220 : 12|10:24:17.9357|vQLevP|DANIEL|V3Api.SearchWorkflows t Information: 1220 : 12|10:24:17.9357|vQLevP|DANIEL|V3Api.SearchGeneric t Transfer: 1220 : 12|10:24:17.9357|vQLevP|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|10:24:17.9357|vQLevP|DANIEL| OAuth authenticated t Transfer: 1220 : 12|10:24:17.9357|vQLevP|DANIEL| user DANIEL. t Information: 1220 : 12|10:24:17.9357|vQLevP|DANIEL|SearchJob SQL: select * from (select a.*, rownum rnum from ( select /*+ INDEX(j JB_CMBST_IDX) */ j.* ,p.pname ,mi.tv_std ,mi.MIID1, mi.MIID2, mi.MIID3, mi.VERSIONID1, mi.VERSIONID2, mi.PROGID1, mi.PROGID2 ,txd.NEXT_TX_DATE FROM tm_mjob j left join tm_mjob_pset p on j.j_sched_indx=p.id left join (select j_id, TMD_str_agg(distinct miid1) MIID1, TMD_str_agg(distinct miid2) MIID2, TMD_str_agg(distinct miid3) MIID3, TMD_str_agg(distinct versionid1) VERSIONID1, TMD_str_agg(distinct versionid2) VERSIONID2, TMD_str_agg(distinct progid1) PROGID1, TMD_str_agg(distinct progid2) PROGID2, TMD_str_agg(distinct m.tv_std) TV_STD from tm_mis m, tm_mtsk_it i where m.id=i.mi_id and i.src_dest in (2,3) group by j_id) mi on mi.j_id=j.id LEFT JOIN ( SELECT it.j_id, min(sch.tx_tm_st) NEXT_TX_DATE FROM TM_MTSK_IT it, TM_MIS m, hr_sched sch WHERE m.id = it.MI_ID AND (sch.prod_num = m.PROGID2 OR sch.prod_num = (select rl.VERSIONID1 from TM_PG_RL rl where rl.ID = m.PGM_PARENT_ID)) AND sch.tx_tm_st > sysdate GROUP BY J_ID) txd ON txd.j_id = j.id where 1=1 AND not ( j.CMB_STAT = 19 and j.J_FAILURE_RESOLVED > 0 ) and j.j_sched_indx in (2311) and j.cmb_stat not in (15,18,23) order by j.J_COMPL_BY, j.id desc, j.id ) a where rownum <= 50) where rnum >= 1 order by rnum t Information: 1220 : 12|10:24:18.1388|vQLevP|DANIEL| jobs returned 10, searched in 00:00:00.1849460 t Information: 1220 : 12|10:24:18.1388|vQLevP|DANIEL| tasks returned 10, searched in 00:00:00.0258778 t Verbose: 1220 : 12|10:24:18.1388|vQLevP|DANIEL|imfx v3 API took 0.226s '/api/v3/search/workflow?_dc=1585733057866' t Transfer: 1220 : 12|10:24:18.3420|DY5eBc|DANIEL|OAuth: /api/user-preferences?_dc=1585733058190 t Transfer: 1220 : 12|10:24:18.3420|DY5eBc|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|10:24:18.3420|DY5eBc|DANIEL| OAuth authenticated t Transfer: 1220 : 12|10:24:18.3420|DY5eBc|DANIEL| user DANIEL. t Verbose: 1220 : 12|10:24:18.3420|DY5eBc|DANIEL|OAuth. User logged in: DANIEL t Verbose: 1220 : 12|10:24:18.3420|DY5eBc|DANIEL|StoreUserDataByKeys.. t Transfer: 1220 : 12|10:24:18.3420|DY5eBc|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|10:24:18.3420|DY5eBc|DANIEL| OAuth authenticated t Transfer: 1220 : 12|10:24:18.3420|DY5eBc|DANIEL| user DANIEL. t Verbose: 1220 : 12|10:24:18.3420|DY5eBc|DANIEL|imfx v3 API took 0.008s '/api/user-preferences?_dc=1585733058190' t Transfer: 1220 : 12|10:25:37.1544|HuZBZ9|DANIEL|OAuth: /api/v3/task/componentqc/109492?_dc=1585733136977 t Transfer: 1220 : 12|10:25:37.1544|HuZBZ9|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|10:25:37.1544|HuZBZ9|DANIEL| OAuth authenticated t Transfer: 1220 : 12|10:25:37.1544|HuZBZ9|DANIEL| user DANIEL. t Verbose: 1220 : 12|10:25:37.1544|HuZBZ9|DANIEL|OAuth. User logged in: DANIEL t Information: 1220 : 12|10:25:37.1544|HuZBZ9|DANIEL|V3Api. GetComponentQc task: 109492 t Information: 1220 : 12|10:25:37.1544|HuZBZ9|DANIEL|SubtitleQcTask. LoadFromDb got Job 109491 and Subtitles 2. t Verbose: 1220 : 12|10:25:37.1544|HuZBZ9|DANIEL|imfx v3 API took 0.027s '/api/v3/task/componentqc/109492?_dc=1585733136977' t Information: 1220 : 12|10:25:37.1544|HuZBZ9|DANIEL|V3 Api exception handler: System.Collections.Generic.KeyNotFoundException: The given key was not present in the dictionary. at System.Collections.Generic.Dictionary`2.get_Item(TKey key) at xMfxModel.TM_MIS.ParseCustomStatuses() in C:\BuildAgent2\work\405c64e443a47d83\Server\xMfxDataLogic\Logic\TM_MIS.cs:line 440 at xMfxDataLogic.ServiceLogic.Implementation.SubtitlesQcTaskLoad(Decimal taskId) in C:\BuildAgent2\work\405c64e443a47d83\Server\xMfxDataLogic\Logic\ServiceLogic\SubtitleQc.cs:line 68 at iMfxServerCore.Api.v3.SubtitleQcTaskController.GetComponentQcTask(Int32 id) in C:\BuildAgent2\work\405c64e443a47d83\Server\iMfxServerCore\api\controllers\v3\Tasks\SubtitleQcTaskController.cs:line 44 at lambda_method(Closure , Object , Object[] ) at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ActionExecutor.<>c__DisplayClass6_2.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/109492?_dc=1585733136977 System.Web.Http.Routing.HttpRoute t Transfer: 1220 : 12|10:25:42.6388|1XjiwZ|DANIEL|OAuth: /api/v3/search/workflow?_dc=1585733142608 t Transfer: 1220 : 12|10:25:42.6388|1XjiwZ|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|10:25:42.6388|1XjiwZ|DANIEL| OAuth authenticated t Transfer: 1220 : 12|10:25:42.6388|1XjiwZ|DANIEL| user DANIEL. t Verbose: 1220 : 12|10:25:42.6388|1XjiwZ|DANIEL|OAuth. User logged in: DANIEL t Information: 1220 : 12|10:25:42.6388|1XjiwZ|DANIEL|V3Api.SearchWorkflows t Information: 1220 : 12|10:25:42.6388|1XjiwZ|DANIEL|V3Api.SearchGeneric t Transfer: 1220 : 12|10:25:42.6388|1XjiwZ|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|10:25:42.6388|1XjiwZ|DANIEL| OAuth authenticated t Transfer: 1220 : 12|10:25:42.6388|1XjiwZ|DANIEL| user DANIEL. t Information: 1220 : 12|10:25:42.8419|1XjiwZ|DANIEL|SearchJob SQL: select * from (select a.*, rownum rnum from ( select /*+ INDEX(j JB_CMBST_IDX) */ j.* ,p.pname ,mi.tv_std ,mi.MIID1, mi.MIID2, mi.MIID3, mi.VERSIONID1, mi.VERSIONID2, mi.PROGID1, mi.PROGID2 ,txd.NEXT_TX_DATE FROM tm_mjob j left join tm_mjob_pset p on j.j_sched_indx=p.id left join (select j_id, TMD_str_agg(distinct miid1) MIID1, TMD_str_agg(distinct miid2) MIID2, TMD_str_agg(distinct miid3) MIID3, TMD_str_agg(distinct versionid1) VERSIONID1, TMD_str_agg(distinct versionid2) VERSIONID2, TMD_str_agg(distinct progid1) PROGID1, TMD_str_agg(distinct progid2) PROGID2, TMD_str_agg(distinct m.tv_std) TV_STD from tm_mis m, tm_mtsk_it i where m.id=i.mi_id and i.src_dest in (2,3) group by j_id) mi on mi.j_id=j.id LEFT JOIN ( SELECT it.j_id, min(sch.tx_tm_st) NEXT_TX_DATE FROM TM_MTSK_IT it, TM_MIS m, hr_sched sch WHERE m.id = it.MI_ID AND (sch.prod_num = m.PROGID2 OR sch.prod_num = (select rl.VERSIONID1 from TM_PG_RL rl where rl.ID = m.PGM_PARENT_ID)) AND sch.tx_tm_st > sysdate GROUP BY J_ID) txd ON txd.j_id = j.id where 1=1 AND j.ID=109491 order by j.J_COMPL_BY, j.id desc, j.id ) a where rownum <= 50) where rnum >= 1 order by rnum t Information: 1220 : 12|10:25:42.8419|1XjiwZ|DANIEL| jobs returned 1, searched in 00:00:00.0046030 t Information: 1220 : 12|10:25:42.8419|1XjiwZ|DANIEL| tasks returned 1, searched in 00:00:00.0062545 t Verbose: 1220 : 12|10:25:42.8419|1XjiwZ|DANIEL|imfx v3 API took 0.018s '/api/v3/search/workflow?_dc=1585733142608' t Transfer: 1220 : 12|10:25:44.2638|aX2glH|DANIEL|OAuth: /api/v3/task/componentqc/109492?_dc=1585733144098 t Transfer: 1220 : 12|10:25:44.2638|aX2glH|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|10:25:44.2638|aX2glH|DANIEL| OAuth authenticated t Transfer: 1220 : 12|10:25:44.2638|aX2glH|DANIEL| user DANIEL. t Verbose: 1220 : 12|10:25:44.2638|aX2glH|DANIEL|OAuth. User logged in: DANIEL t Information: 1220 : 12|10:25:44.2638|aX2glH|DANIEL|V3Api. GetComponentQc task: 109492 t Information: 1220 : 12|10:25:44.2638|aX2glH|DANIEL|SubtitleQcTask. LoadFromDb got Job 109491 and Subtitles 2. t Verbose: 1220 : 12|10:25:44.2638|aX2glH|DANIEL|imfx v3 API took 0.019s '/api/v3/task/componentqc/109492?_dc=1585733144098' t Information: 1220 : 12|10:25:44.2638|aX2glH|DANIEL|V3 Api exception handler: System.Collections.Generic.KeyNotFoundException: The given key was not present in the dictionary. at System.Collections.Generic.Dictionary`2.get_Item(TKey key) at xMfxModel.TM_MIS.ParseCustomStatuses() in C:\BuildAgent2\work\405c64e443a47d83\Server\xMfxDataLogic\Logic\TM_MIS.cs:line 440 at xMfxDataLogic.ServiceLogic.Implementation.SubtitlesQcTaskLoad(Decimal taskId) in C:\BuildAgent2\work\405c64e443a47d83\Server\xMfxDataLogic\Logic\ServiceLogic\SubtitleQc.cs:line 68 at iMfxServerCore.Api.v3.SubtitleQcTaskController.GetComponentQcTask(Int32 id) in C:\BuildAgent2\work\405c64e443a47d83\Server\iMfxServerCore\api\controllers\v3\Tasks\SubtitleQcTaskController.cs:line 44 at lambda_method(Closure , Object , Object[] ) at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ActionExecutor.<>c__DisplayClass6_2.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/109492?_dc=1585733144098 System.Web.Http.Routing.HttpRoute t Transfer: 1220 : 12|10:25:50.1544|_AJEYh|DANIEL|OAuth: /api/v3/search/workflow?_dc=1585733149951 t Transfer: 1220 : 12|10:25:50.1544|_AJEYh|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|10:25:50.1544|_AJEYh|DANIEL| OAuth authenticated t Transfer: 1220 : 12|10:25:50.1544|_AJEYh|DANIEL| user DANIEL. t Verbose: 1220 : 12|10:25:50.1544|_AJEYh|DANIEL|OAuth. User logged in: DANIEL t Information: 1220 : 12|10:25:50.1544|_AJEYh|DANIEL|V3Api.SearchWorkflows t Information: 1220 : 12|10:25:50.1544|_AJEYh|DANIEL|V3Api.SearchGeneric t Transfer: 1220 : 12|10:25:50.1544|_AJEYh|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|10:25:50.1544|_AJEYh|DANIEL| OAuth authenticated t Transfer: 1220 : 12|10:25:50.1544|_AJEYh|DANIEL| user DANIEL. t Information: 1220 : 12|10:25:50.1544|_AJEYh|DANIEL|SearchJob SQL: select * from (select a.*, rownum rnum from ( select /*+ INDEX(j JB_CMBST_IDX) */ j.* ,p.pname ,mi.tv_std ,mi.MIID1, mi.MIID2, mi.MIID3, mi.VERSIONID1, mi.VERSIONID2, mi.PROGID1, mi.PROGID2 ,txd.NEXT_TX_DATE FROM tm_mjob j left join tm_mjob_pset p on j.j_sched_indx=p.id left join (select j_id, TMD_str_agg(distinct miid1) MIID1, TMD_str_agg(distinct miid2) MIID2, TMD_str_agg(distinct miid3) MIID3, TMD_str_agg(distinct versionid1) VERSIONID1, TMD_str_agg(distinct versionid2) VERSIONID2, TMD_str_agg(distinct progid1) PROGID1, TMD_str_agg(distinct progid2) PROGID2, TMD_str_agg(distinct m.tv_std) TV_STD from tm_mis m, tm_mtsk_it i where m.id=i.mi_id and i.src_dest in (2,3) group by j_id) mi on mi.j_id=j.id LEFT JOIN ( SELECT it.j_id, min(sch.tx_tm_st) NEXT_TX_DATE FROM TM_MTSK_IT it, TM_MIS m, hr_sched sch WHERE m.id = it.MI_ID AND (sch.prod_num = m.PROGID2 OR sch.prod_num = (select rl.VERSIONID1 from TM_PG_RL rl where rl.ID = m.PGM_PARENT_ID)) AND sch.tx_tm_st > sysdate GROUP BY J_ID) txd ON txd.j_id = j.id where 1=1 AND j.ID=109491 order by j.J_COMPL_BY, j.id desc, j.id ) a where rownum <= 50) where rnum >= 1 order by rnum t Information: 1220 : 12|10:25:50.1544|_AJEYh|DANIEL| jobs returned 1, searched in 00:00:00.0044967 t Information: 1220 : 12|10:25:50.1544|_AJEYh|DANIEL| tasks returned 1, searched in 00:00:00.0028262 t Verbose: 1220 : 12|10:25:50.1544|_AJEYh|DANIEL|imfx v3 API took 0.013s '/api/v3/search/workflow?_dc=1585733149951' t Transfer: 1220 : 12|10:29:56.7950|qjoXee|DANIEL|OAuth: /api/user-preferences?keys=media.basket.data&_dc=1585733396697 t Transfer: 1220 : 12|10:29:56.7950|qjoXee|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|10:29:56.7950|qjoXee|DANIEL| OAuth authenticated t Transfer: 1220 : 12|10:29:56.7950|qjoXee|DANIEL| user DANIEL. t Verbose: 1220 : 12|10:29:56.7950|qjoXee|DANIEL|OAuth. User logged in: DANIEL t Information: 1220 : 12|10:29:56.7950|qjoXee|DANIEL|GetUserDataByKeys: media.basket.data t Transfer: 1220 : 12|10:29:56.7950|qjoXee|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|10:29:56.7950|qjoXee|DANIEL| OAuth authenticated t Transfer: 1220 : 12|10:29:56.7950|qjoXee|DANIEL| user DANIEL. t Verbose: 1220 : 12|10:29:56.7950|qjoXee|DANIEL|imfx v3 API took 0.010s '/api/user-preferences?keys=media.basket.data&_dc=1585733396697' t Transfer: 1220 : 12|10:29:56.9982|ZMhmm3|DANIEL|OAuth: /api/settings/user/uploadSettings?_dc=1585733396808 t Transfer: 1220 : 12|10:29:56.9982|ZMhmm3|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|10:29:56.9982|ZMhmm3|DANIEL| OAuth authenticated t Transfer: 1220 : 12|10:29:56.9982|ZMhmm3|DANIEL| user DANIEL. t Verbose: 1220 : 12|10:29:56.9982|ZMhmm3|DANIEL|OAuth. User logged in: DANIEL t Transfer: 1220 : 12|10:29:56.9982|ZMhmm3|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|10:29:56.9982|ZMhmm3|DANIEL| OAuth authenticated t Transfer: 1220 : 12|10:29:56.9982|ZMhmm3|DANIEL| user DANIEL. t Verbose: 1220 : 12|10:29:56.9982|ZMhmm3|DANIEL|imfx v3 API took 0.004s '/api/settings/user/uploadSettings?_dc=1585733396808' t Transfer: 1220 : 12|10:29:56.9982|2jGUdX|DANIEL|OAuth: /api/settings/user/defaultHomePage?_dc=1585733396702 t Transfer: 1220 : 12|10:29:56.9982|2jGUdX|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|10:29:56.9982|2jGUdX|DANIEL| OAuth authenticated t Transfer: 1220 : 12|10:29:56.9982|2jGUdX|DANIEL| user DANIEL. t Verbose: 1220 : 12|10:29:56.9982|2jGUdX|DANIEL|OAuth. User logged in: DANIEL t Transfer: 1220 : 12|10:29:56.9982|2jGUdX|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|10:29:56.9982|2jGUdX|DANIEL| OAuth authenticated t Transfer: 1220 : 12|10:29:56.9982|2jGUdX|DANIEL| user DANIEL. t Verbose: 1220 : 12|10:29:56.9982|2jGUdX|DANIEL|imfx v3 API took 0.003s '/api/settings/user/defaultHomePage?_dc=1585733396702' t Transfer: 1220 : 12|10:29:56.9982|xCVm4P|DANIEL|OAuth: /api/user-preferences?keys=color_schema&_dc=1585733396714 t Transfer: 1220 : 12|10:29:56.9982|xCVm4P|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|10:29:56.9982|xCVm4P|DANIEL| OAuth authenticated t Transfer: 1220 : 12|10:29:56.9982|xCVm4P|DANIEL| user DANIEL. t Verbose: 1220 : 12|10:29:56.9982|xCVm4P|DANIEL|OAuth. User logged in: DANIEL t Information: 1220 : 12|10:29:56.9982|xCVm4P|DANIEL|GetUserDataByKeys: color_schema t Transfer: 1220 : 12|10:29:56.9982|xCVm4P|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|10:29:56.9982|xCVm4P|DANIEL| OAuth authenticated t Transfer: 1220 : 12|10:29:56.9982|xCVm4P|DANIEL| user DANIEL. t Verbose: 1220 : 12|10:29:56.9982|xCVm4P|DANIEL|imfx v3 API took 0.004s '/api/user-preferences?keys=color_schema&_dc=1585733396714' t Transfer: 1220 : 12|10:29:56.9982|MXno50|DANIEL|OAuth: /api/user-preferences?keys=media.basket.data&_dc=1585733396837 t Transfer: 1220 : 12|10:29:56.9982|MXno50|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|10:29:56.9982|MXno50|DANIEL| OAuth authenticated t Transfer: 1220 : 12|10:29:56.9982|MXno50|DANIEL| user DANIEL. t Verbose: 1220 : 12|10:29:56.9982|MXno50|DANIEL|OAuth. User logged in: DANIEL t Information: 1220 : 12|10:29:56.9982|MXno50|DANIEL|GetUserDataByKeys: media.basket.data t Transfer: 1220 : 12|10:29:56.9982|MXno50|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|10:29:56.9982|MXno50|DANIEL| OAuth authenticated t Transfer: 1220 : 12|10:29:56.9982|MXno50|DANIEL| user DANIEL. t Verbose: 1220 : 12|10:29:56.9982|MXno50|DANIEL|imfx v3 API took 0.004s '/api/user-preferences?keys=media.basket.data&_dc=1585733396837' t Transfer: 1220 : 12|10:29:56.9982|K2NsMp|DANIEL|OAuth: /api/user-group-preferences?keys=logoImage&_dc=1585733396931 t Transfer: 1220 : 12|10:29:56.9982|K2NsMp|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|10:29:56.9982|K2NsMp|DANIEL| OAuth authenticated t Transfer: 1220 : 12|10:29:56.9982|K2NsMp|DANIEL| user DANIEL. t Verbose: 1220 : 12|10:29:56.9982|K2NsMp|DANIEL|OAuth. User logged in: DANIEL t Transfer: 1220 : 12|10:29:56.9982|K2NsMp|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|10:29:56.9982|K2NsMp|DANIEL| OAuth authenticated t Transfer: 1220 : 12|10:29:56.9982|K2NsMp|DANIEL| user DANIEL. t Verbose: 1220 : 12|10:29:56.9982|K2NsMp|DANIEL|imfx v3 API took 0.006s '/api/user-group-preferences?keys=logoImage&_dc=1585733396931' t Information: 1220 : 12|10:29:57.4200|LWs59_|DANIEL|GetUserProfile. Id: 0 t Transfer: 1220 : 12|10:29:57.4200|LWs59_|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|10:29:57.4200|LWs59_|DANIEL| OAuth authenticated t Transfer: 1220 : 12|10:29:57.4200|LWs59_|DANIEL| user DANIEL. t Transfer: 1220 : 12|10:29:57.4200|15YmIL|DANIEL|OAuth: /api/user-preferences?keys=personal_settings&_dc=1585733397341 t Transfer: 1220 : 12|10:29:57.4200|15YmIL|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|10:29:57.4200|15YmIL|DANIEL| OAuth authenticated t Transfer: 1220 : 12|10:29:57.4200|15YmIL|DANIEL| user DANIEL. t Verbose: 1220 : 12|10:29:57.4200|15YmIL|DANIEL|OAuth. User logged in: DANIEL t Information: 1220 : 12|10:29:57.4200|15YmIL|DANIEL|GetUserDataByKeys: personal_settings t Transfer: 1220 : 12|10:29:57.4200|15YmIL|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|10:29:57.4200|15YmIL|DANIEL| OAuth authenticated t Transfer: 1220 : 12|10:29:57.4200|15YmIL|DANIEL| user DANIEL. t Verbose: 1220 : 12|10:29:57.4200|15YmIL|DANIEL|imfx v3 API took 0.003s '/api/user-preferences?keys=personal_settings&_dc=1585733397341' t Transfer: 1220 : 12|10:34:24.7639|rlHhTj||GetAppInfo. DB: TMDDEMO. Install mode: . Auth types: Native, PublicApiKey t Information: 1220 : 12|10:55:13.4362|||OrabitWatcherBasic. Disposing. t Information: 1220 : 12|10:55:13.4362|||OrabitWatcherBasic. Disposed. t Information: 1220 : 12|10:55:13.4362|||========================================================================== t Information: 1220 : 12|10:55:13.4362|||IMFX CORE SERVER APPLICATION END.