t Information: 1220 : 12|11:38:52.8109|||Get Configuration Values: t Information: 1220 : 12|11:38:52.8109||| AdminPassEnc, default: , value: ffqjrn0leKv4Lj2YJHe2dw==. t Information: 1220 : 12|11:38:52.8109||| EncryptedPasswords, default: false, value: true. t Information: 1220 : 12|11:38:52.8109||| OraConnectionString, default: , value: Server=TECHM;User Id=imfx;Password=xxxxx;Unicode=true;. t Information: 1220 : 12|11:38:52.8109||| SecondTimezone, default: , value: . t Information: 1220 : 12|11:38:52.8109||| UseActiveDirectoryAuth, default: false, value: false. t Information: 1220 : 12|11:38:52.8109||| ReportingServiceUrl, default: , value: http://localhost:92/ReportingService.svc. t Information: 1220 : 12|11:38:52.8109||| ReportsPath, default: , value: . t Information: 1220 : 12|11:38:52.8109||| ReportsURL, default: , value: . t Information: 1220 : 12|11:38:52.8109||| TapeServiceUrl, default: , value: . t Information: 1220 : 12|11:38:52.8109||| GatekeeperUrl, default: , value: . t Information: 1220 : 12|11:38:52.8109||| ValuationUrl, default: , value: . t Information: 1220 : 12|11:38:52.8109||| QueueManagerDelay, default: 30, value: 30. t Information: 1220 : 12|11:38:52.8109||| QueueManagerFullRefresh, default: 90, value: 90. t Information: 1220 : 12|11:38:52.8109||| AudioLoopDuration, default: 0, value: 150. t Information: 1220 : 12|11:38:52.8109||| AudioLoopsCount, default: 0, value: 0. t Information: 1220 : 12|11:38:52.8109||| PlayerFakeStep, default: 500, value: 500. t Information: 1220 : 12|11:38:52.8109||| PlayerForceRatio, default: 0, value: 1. t Information: 1220 : 12|11:38:52.8109||| CheckVersionsInProd, default: false, value: True. t Information: 1220 : 12|11:38:52.8109||| MaxResults, default: 3000, value: 10000. t Information: 1220 : 12|11:38:52.8109||| NetworkRestriction, default: false, value: True. t Information: 1220 : 12|11:38:52.8109||| TEReportID, default: 0, value: 0. t Information: 1220 : 12|11:38:52.8109||| ClosedCaptionsCache, default: , value: C:\inetpub\wwwroot\imfxcore\timedtextcache\. t Information: 1220 : 12|11:38:52.8109||| ClosedCaptionsStorage, default: , value: c:\Mediaflex\subs. t Information: 1220 : 12|11:38:52.8109||| TimeCodeFormat, default: , value: pal. t Information: 1220 : 12|11:38:52.8109||| RceMediaPath, default: , value: C:\edl\. t Information: 1220 : 12|11:38:52.8109||| RceMediaPath, default: , value: C:\edl\. t Information: 1220 : 12|11:38:52.8109||| RceCsmOutputPath, default: , value: C:\Inetpub\wwwroot\csm\. t Information: 1220 : 12|11:38:52.8109||| RceCsmUrl, default: , value: http://localhost/csm/. t Information: 1220 : 12|11:38:52.8109||| RceMediaSelection, default: , value: miLinkIdMatch. t Information: 1220 : 12|11:38:52.8109||| RequestBrowseJobPresetName, default: , value: . t Information: 1220 : 12|11:38:52.8109||| DontExtendDuration, default: false, value: False. t Information: 1220 : 12|11:38:52.8109||| V3ConfigUrl, default: , value: . t Information: 1220 : 12|11:38:52.8109||| StopWords, default: , value: . t Information: 1220 : 12|11:38:52.8109||| MisrTxFormat, default: G, value: G. t Information: 1220 : 12|11:38:52.8109||| ApiServer, default: , value: http://192.168.120.10:85. t Information: 1220 : 12|11:38:52.8109||| ApiTimeout, default: 120, value: 120. t Information: 1220 : 12|11:38:52.8109||| ApiWorkers, default: 10, value: 10. t Information: 1220 : 12|11:38:52.8109||| UsePerfCounters, default: false, value: false. t Information: 1220 : 12|11:38:52.8109||| StatsdAddress, default: , value: . t Information: 1220 : 12|11:38:52.8109||| LogGetCurrentUser, default: true, value: true. t Information: 1220 : 12|11:38:52.8109||| LogInternalApi, default: true, value: true. t Information: 1220 : 12|11:38:52.8109||| ThumbnailServer, default: , value: . t Information: 1220 : 12|11:38:52.8109||| LocationFilter, default: , value: . t Information: 1220 : 12|11:38:52.8109||| SvUtilServiceUrl, default: , value: . t Information: 1220 : 12|11:38:52.8109||| SolrConnection, default: , value: http://192.168.120.14:8983/solr. t Information: 1220 : 12|11:38:52.8109||| UseIndexServerSearch, default: false, value: True. t Information: 1220 : 12|11:38:52.8109||| SolrIndexVersion, default: 1, value: 6. t Information: 1220 : 12|11:38:52.8109||| SolrConnection, default: , value: http://192.168.120.14:8983/solr. t Information: 1220 : 12|11:38:52.8109||| FacetsGroups, default: , value: owners,season_id, series_id,version_key,item_type,media_type,media_format,episode_number. t Information: 1220 : 12|11:38:52.8109||| FacetsGroupsVersion, default: , value: owners,season_id, series_id,version_key,episode_number. t Information: 1220 : 12|11:38:52.8109||| FacetsGroupsChameleon, default: , value: season_id, series_id,genre,prod_year,version_key. t Information: 1220 : 12|11:38:52.8109||| PreviewPreset, default: , value: . t Information: 1220 : 12|11:38:52.8109||| DevMode, default: false, value: false. t Information: 1220 : 12|11:38:52.8109||| DisableSysMan, default: false, value: false. t Information: 1220 : 12|11:38:52.8109||| TimeCodeFormat, default: , value: pal. t Information: 1220 : 12|11:38:52.8109||| FileCatalystStorageDevice, default: , value: . t Information: 1220 : 12|11:38:52.8109||| UseResponsibilityTracking, default: true, value: True. t Information: 1220 : 12|11:38:52.8109||| SubtitleDeviceFilter, default: , value: . t Information: 1220 : 12|11:38:52.8109||| SystemMonitorNamedPipe, default: , value: . t Information: 1220 : 12|11:38:52.8109||| OracleMonitorEnable, default: false, value: False. t Information: 1220 : 12|11:38:52.8109||| ArcApiHost, default: , value: . t Information: 1220 : 12|11:38:52.8109||| RabbitMqUrl, default: , value: amqp://192.168.120.14:5672. t Information: 1220 : 12|11:38:52.8109||| SolrTimedTextSearch, default: false, value: false. t Information: 1220 : 12|11:38:52.8109||| ProductionDurationUsageID, default: 1, value: 1. t Information: 1220 : 12|11:38:53.0296|||GetStreamServers.. t Information: 1220 : 12|11:38:53.8421||| https://demo.tmd.tv/CBR Video/ |CBR Video| False t Information: 1220 : 12|11:38:53.8421||| https://demo.tmd.tv/CBR Images/ |CBR Images| False t Information: 1220 : 12|11:38:53.8421||| https://demo.tmd.tv/CBR Audio/ |CBR Audio| False t Information: 1220 : 12|11:38:53.8421||| https://demo.tmd.tv/Temp Upload/ |TEMP_UPLOAD| False t Information: 1220 : 12|11:38:53.8421||| http://localhost:82/images/ |IMAGES| False t Information: 1220 : 12|11:38:53.8421||| http://192.168.91.73/smoothcloud/ |SMOOTH_CLOUD| False t Information: 1220 : 12|11:38:53.8421||| http://192.168.91.73/cloudstore/ |CLOUD_STORE| False t Information: 1220 : 12|11:38:53.8421||| http://192.168.91.73/editsystemin/ |EDIT_SYSTEM_IN| False t Information: 1220 : 12|11:38:53.8421||| http://192.168.91.27:89/APPLEPROXY/ |APPLE_PROXY| False t Information: 1220 : 12|11:38:53.8421||| http://localhost:82/video/ |FILESTORE_VIDEO| False t Information: 1220 : 12|11:38:53.8421||| https://imfxv3tm.tmd.tv/streaming/ |Streaming| False t Information: 1220 : 12|11:38:53.8421||| https://imfxv3tm.tmd.tv/VideoServer/ |Video| False t Information: 1220 : 12|11:38:53.8421||| https://imfxv3tm.tmd.tv/AdobeIn/ |Adobe Premiere Pro In| False t Information: 1220 : 12|11:38:53.8421||| https://imfxv3tm.tmd.tv/AudioServer/ |Audio| False t Information: 1220 : 12|11:38:53.8421||| https://imfxv3tm.tmd.tv/ImageServer/ |Image| False t Information: 1220 : 12|11:38:53.8421||| https://imfxv3tm.tmd.tv/DocsServer/ |Docs| False t Information: 1220 : 12|11:38:53.8421||| https://imfxv3tm.tmd.tv/AmazonLabs/ |TEST HOUSE| False t Information: 1220 : 12|11:38:53.8421||| SolrConnectionUms, default: http://192.168.120.14:8983/solr, value: http://192.168.120.14:8983/solr. t Information: 1220 : 12|11:38:53.8421||| LogWebApi, default: false, value: false. t Information: 1220 : 12|11:38:53.8421||| EmbeddedRceUrl, default: , value: . t Information: 1220 : 12|11:38:53.8421||| InstallMode, default: , value: . t Information: 1220 : 12|11:38:53.8421||| SamlRequestAddress, default: , value: . t Information: 1220 : 12|11:38:53.8421||| SamlTrustedIssuer, default: , value: . t Information: 1220 : 12|11:38:53.8421||| SamlLoginRedirect, default: , value: . t Information: 1220 : 12|11:38:53.8421||| NaturalLangSearch, default: false, value: True. t Information: 1220 : 12|11:38:53.8421||| OktaLoginField, default: , value: . t Information: 1220 : 12|11:38:53.8421||| AuthenticationTypes, default: , value: Native,PublicApiKey. t Information: 1220 : 12|11:38:53.8421|||OrabitWatcherBasic. Initialize. t Information: 1220 : 12|11:38:53.8421|||FillDictionaryCache. t Information: 1220 : 12|11:38:57.5140|||GetSupportedOperators t Information: 1220 : 12|11:38:57.7193|||CacheTechReports. t Information: 1220 : 12|11:38:57.7193|||& Cache update. Server (global) filled with timestamp 11:04:57.7015544. types null t Information: 1220 : 12|11:38:57.7193|||InitializeFromDatabase. 'Server=TECHM;User Id=imfx;password=..;Unicode=true;' direct False, home , timeout 15 t Information: 1220 : 12|11:38:57.9203|||FillDictionaryCache. t Information: 1220 : 12|11:38:57.9203|||& Cache update. Server (global) filled with timestamp 11:04:57.7193629. types FriendlyNames, DatabaseSearchFieldData t Information: 1220 : 12|11:38:58.5296|||========================================================================== t Information: 1220 : 12|11:38:58.5296|||IMFX CORE SERVER APPLICATION START. t Information: 1220 : 12|11:38:58.5296|||DLL VERSION: 2.5.0.2610. t Information: 1220 : 12|11:38:58.5296|||IS TIMER HIGH RESOULTION : True. t Information: 1220 : 12|11:38:58.5296||| UmsDev, default: False, value: False. t Information: 1220 : 12|11:38:58.9359|||OrabitWatcherBasic trying to connect.. t Information: 1220 : 12|11:38:58.9359|||OrabitWatcherBasic connected. t Information: 1220 : 12|11:38:58.9359|||OrabitWatcherBasic queue created tmd.cfg.in.ce945c4f-9dc0-437b-a21f-61d39992dbac t Transfer: 1220 : 12|11:39:01.1703|ERHEzf||GetAppInfo. DB: TMDDEMO. Install mode: . Auth types: Native, PublicApiKey t Transfer: 1220 : 12|11:43:23.2171|Zy0qy9||GetAppInfo. DB: TMDDEMO. Install mode: . Auth types: Native, PublicApiKey t Transfer: 1220 : 12|11:48:27.0923|l5XDkx||GetAppInfo. DB: TMDDEMO. Install mode: . Auth types: Native, PublicApiKey t Verbose: 1220 : 12|11:48:33.9985|h5Y1~V||Oauth validating.. t Verbose: 1220 : 12|11:48:33.9985|h5Y1~V||GrantResourceOwnerCredentials. t Verbose: 1220 : 12|11:48:33.9985|h5Y1~V||LoginUser. daniel, login type OAuth, encrypt password True t Information: 1220 : 12|11:48:33.9985|h5Y1~V||TryLoginUser. daniel, login type OAuth, check password True, check hash False, encrypt password True, load user data False t Information: 1220 : 12|11:48:34.2017|h5Y1~V|| oauth token 00000000-0000-0000-0000-000000000000 t Information: 1220 : 12|11:48:34.2017|h5Y1~V||TryLoginUser. Logged in.. t Information: 1220 : 12|11:48:34.2017|h5Y1~V||GetPasswordPolicy. WARNING: Policy not found for system Imediaflex. Validation disabled. t Verbose: 1220 : 12|11:48:34.2017|h5Y1~V||LoginUser. Adding history. User Id 342, result DANIEL, host 192.168.127.6 t Verbose: 1220 : 12|11:48:34.2017|h5Y1~V||GrantResourceOwnerCredentials. Try login finished. Logged: True t Transfer: 1220 : 12|11:48:34.2017|chxiel|DANIEL|OAuth: /api/user-group-preferences?keys=defaultSearchColumnsMedia,defaultSearchColumnsVersion,defaultSearchColumnsSimple,defaultSearchMisrDetailsMediaColumns,versionCreationSettings,associate.advanced_search.version.setups,associate.advanced_search.media.setups,associate.wfrise.setups,supplier_portal.advanced_search.version.setups,supplier_portal.version_complete.setups,logoImage,uploadSettings&globals=isDebugMode,htmlplayerhotkeys,versionCreationSettings,associate.advanced_search.version.setups,associate.advanced_search.media.setups,associate.wfrise.setups,supplier_portal.advanced_search.version.setups&_dc=1585738114387 t Transfer: 1220 : 12|11:48:34.2017|chxiel|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|11:48:34.2017|chxiel|DANIEL| OAuth authenticated t Transfer: 1220 : 12|11:48:34.2017|chxiel|DANIEL| user DANIEL. t Verbose: 1220 : 12|11:48:34.2017|chxiel|DANIEL|OAuth. User logged in: DANIEL t Transfer: 1220 : 12|11:48:34.2017|chxiel|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|11:48:34.2017|chxiel|DANIEL| OAuth authenticated t Transfer: 1220 : 12|11:48:34.2017|chxiel|DANIEL| user DANIEL. t Verbose: 1220 : 12|11:48:34.4048|chxiel|DANIEL|imfx v3 API took 0.031s '/api/user-group-preferences?keys=defaultSearchColumnsMedia,defaultSearchColumnsVersion,defaultSearchColumnsSimple,defaultSearchMisrDetailsMediaColumns,versionCreationSettings,associate.advanced_search.version.setups,associate.advanced_search.media.setups,associate.wfrise.setups,supplier_portal.advanced_search.version.setups,supplier_portal.version_complete.setups,logoImage,uploadSettings&globals=isDebugMode,htmlplayerhotkeys,versionCreationSettings,associate.advanced_search.version.setups,associate.advanced_search.media.setups,associate.wfrise.setups,supplier_portal.advanced_search.version.setups&_dc=1585738114387' t Transfer: 1220 : 12|11:48:34.4048|ow7jqi|DANIEL|OAuth: /api/user-preferences?keys=personal_settings;basket;default_page;color_schema;media.basket.data;defaultSearch&_dc=1585738114459 t Transfer: 1220 : 12|11:48:34.4048|ow7jqi|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|11:48:34.4048|ow7jqi|DANIEL| OAuth authenticated t Transfer: 1220 : 12|11:48:34.4048|ow7jqi|DANIEL| user DANIEL. t Verbose: 1220 : 12|11:48:34.4048|ow7jqi|DANIEL|OAuth. User logged in: DANIEL t Information: 1220 : 12|11:48:34.4048|ow7jqi|DANIEL|GetUserDataByKeys: personal_settings;basket;default_page;color_schema;media.basket.data;defaultSearch t Transfer: 1220 : 12|11:48:34.4048|ow7jqi|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|11:48:34.4048|ow7jqi|DANIEL| OAuth authenticated t Transfer: 1220 : 12|11:48:34.4048|ow7jqi|DANIEL| user DANIEL. t Verbose: 1220 : 12|11:48:34.4048|ow7jqi|DANIEL|imfx v3 API took 0.019s '/api/user-preferences?keys=personal_settings;basket;default_page;color_schema;media.basket.data;defaultSearch&_dc=1585738114459' t Information: 1220 : 12|11:48:34.4048|UcVb1u|DANIEL|GetUserProfile. Id: 0 t Transfer: 1220 : 12|11:48:34.4048|UcVb1u|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|11:48:34.4048|UcVb1u|DANIEL| OAuth authenticated t Transfer: 1220 : 12|11:48:34.4048|UcVb1u|DANIEL| user DANIEL. t Transfer: 1220 : 12|11:48:34.4048|iPU8Tt|DANIEL|OAuth: /api/lookups/MediaStatus?_dc=1585738114461 t Transfer: 1220 : 12|11:48:34.4048|iPU8Tt|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|11:48:34.4048|iPU8Tt|DANIEL| OAuth authenticated t Transfer: 1220 : 12|11:48:34.4048|iPU8Tt|DANIEL| user DANIEL. t Verbose: 1220 : 12|11:48:34.4048|iPU8Tt|DANIEL|OAuth. User logged in: DANIEL t Transfer: 1220 : 12|11:48:34.4048|8~w7jE|DANIEL|OAuth: /api/lookups/PgmStatus?_dc=1585738114463 t Transfer: 1220 : 12|11:48:34.4048|8~w7jE|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|11:48:34.4048|8~w7jE|DANIEL| OAuth authenticated t Transfer: 1220 : 12|11:48:34.4048|8~w7jE|DANIEL| user DANIEL. t Verbose: 1220 : 12|11:48:34.4048|8~w7jE|DANIEL|OAuth. User logged in: DANIEL t Verbose: 1220 : 12|11:48:34.4048|8~w7jE|DANIEL|imfx v3 API took 0.025s '/api/lookups/PgmStatus?_dc=1585738114463' t Verbose: 1220 : 12|11:48:34.4048|iPU8Tt|DANIEL|imfx v3 API took 0.032s '/api/lookups/MediaStatus?_dc=1585738114461' t Transfer: 1220 : 12|11:48:34.4048|d5m7LS|DANIEL|OAuth: /api/settings/user/defaultHomePage?_dc=1585738114592 t Transfer: 1220 : 12|11:48:34.4048|d5m7LS|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|11:48:34.4048|d5m7LS|DANIEL| OAuth authenticated t Transfer: 1220 : 12|11:48:34.4048|d5m7LS|DANIEL| user DANIEL. t Verbose: 1220 : 12|11:48:34.4048|d5m7LS|DANIEL|OAuth. User logged in: DANIEL t Transfer: 1220 : 12|11:48:34.4048|d5m7LS|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|11:48:34.4048|d5m7LS|DANIEL| OAuth authenticated t Transfer: 1220 : 12|11:48:34.4048|d5m7LS|DANIEL| user DANIEL. t Verbose: 1220 : 12|11:48:34.4048|d5m7LS|DANIEL|imfx v3 API took 0.009s '/api/settings/user/defaultHomePage?_dc=1585738114592' t Transfer: 1220 : 12|11:48:35.4204|grKF12|DANIEL|OAuth: /api/settings/user/consumer?_dc=1585738115588 t Transfer: 1220 : 12|11:48:35.4204|grKF12|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|11:48:35.4204|grKF12|DANIEL| OAuth authenticated t Transfer: 1220 : 12|11:48:35.4204|grKF12|DANIEL| user DANIEL. t Verbose: 1220 : 12|11:48:35.4204|grKF12|DANIEL|OAuth. User logged in: DANIEL t Transfer: 1220 : 12|11:48:35.4204|grKF12|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|11:48:35.4204|grKF12|DANIEL| OAuth authenticated t Transfer: 1220 : 12|11:48:35.4204|grKF12|DANIEL| user DANIEL. t Verbose: 1220 : 12|11:48:35.4204|grKF12|DANIEL|imfx v3 API took 0.004s '/api/settings/user/consumer?_dc=1585738115588' t Transfer: 1220 : 12|11:48:35.6235|21Gpj8|DANIEL|OAuth: /api/settings/user/uploadSettings?_dc=1585738115713 t Transfer: 1220 : 12|11:48:35.6235|21Gpj8|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|11:48:35.6235|21Gpj8|DANIEL| OAuth authenticated t Transfer: 1220 : 12|11:48:35.6235|21Gpj8|DANIEL| user DANIEL. t Verbose: 1220 : 12|11:48:35.6235|21Gpj8|DANIEL|OAuth. User logged in: DANIEL t Transfer: 1220 : 12|11:48:35.6235|21Gpj8|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|11:48:35.6235|21Gpj8|DANIEL| OAuth authenticated t Transfer: 1220 : 12|11:48:35.6235|21Gpj8|DANIEL| user DANIEL. t Verbose: 1220 : 12|11:48:35.6235|21Gpj8|DANIEL|imfx v3 API took 0.003s '/api/settings/user/uploadSettings?_dc=1585738115713' t Transfer: 1220 : 12|11:48:35.8267|1VE4_e|DANIEL|OAuth: /api/user-preferences?keys=consumer.recent.data&_dc=1585738115836 t Transfer: 1220 : 12|11:48:35.8267|1VE4_e|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|11:48:35.8267|1VE4_e|DANIEL| OAuth authenticated t Transfer: 1220 : 12|11:48:35.8267|1VE4_e|DANIEL| user DANIEL. t Verbose: 1220 : 12|11:48:35.8267|1VE4_e|DANIEL|OAuth. User logged in: DANIEL t Information: 1220 : 12|11:48:35.8267|1VE4_e|DANIEL|GetUserDataByKeys: consumer.recent.data t Transfer: 1220 : 12|11:48:35.8267|1VE4_e|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|11:48:35.8267|1VE4_e|DANIEL| OAuth authenticated t Transfer: 1220 : 12|11:48:35.8267|1VE4_e|DANIEL| user DANIEL. t Verbose: 1220 : 12|11:48:35.8267|1VE4_e|DANIEL|imfx v3 API took 0.006s '/api/user-preferences?keys=consumer.recent.data&_dc=1585738115836' t Transfer: 1220 : 12|11:48:36.0298|qhCu6k|DANIEL|OAuth: /api/settings/user/defaultSearch?_dc=1585738116046 t Transfer: 1220 : 12|11:48:36.0298|qhCu6k|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|11:48:36.0298|qhCu6k|DANIEL| OAuth authenticated t Transfer: 1220 : 12|11:48:36.0298|qhCu6k|DANIEL| user DANIEL. t Verbose: 1220 : 12|11:48:36.0298|qhCu6k|DANIEL|OAuth. User logged in: DANIEL t Transfer: 1220 : 12|11:48:36.0298|qhCu6k|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|11:48:36.0298|qhCu6k|DANIEL| OAuth authenticated t Transfer: 1220 : 12|11:48:36.0298|qhCu6k|DANIEL| user DANIEL. t Verbose: 1220 : 12|11:48:36.0298|qhCu6k|DANIEL|imfx v3 API took 0.004s '/api/settings/user/defaultSearch?_dc=1585738116046' t Transfer: 1220 : 12|11:48:36.0298|wNH2vB|DANIEL|OAuth: /api/settings/user/startSearch?_dc=1585738116048 t Transfer: 1220 : 12|11:48:36.0298|wNH2vB|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|11:48:36.0298|wNH2vB|DANIEL| OAuth authenticated t Transfer: 1220 : 12|11:48:36.0298|wNH2vB|DANIEL| user DANIEL. t Verbose: 1220 : 12|11:48:36.0298|wNH2vB|DANIEL|OAuth. User logged in: DANIEL t Transfer: 1220 : 12|11:48:36.0298|wNH2vB|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|11:48:36.0298|wNH2vB|DANIEL| OAuth authenticated t Transfer: 1220 : 12|11:48:36.0298|wNH2vB|DANIEL| user DANIEL. t Verbose: 1220 : 12|11:48:36.0298|wNH2vB|DANIEL|imfx v3 API took 0.004s '/api/settings/user/startSearch?_dc=1585738116048' t Transfer: 1220 : 12|11:48:36.0298|_UNR5S|DANIEL|OAuth: /api/user-preferences?keys=consumer.recent.data&_dc=1585738116086 t Transfer: 1220 : 12|11:48:36.0298|_UNR5S|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|11:48:36.0298|_UNR5S|DANIEL| OAuth authenticated t Transfer: 1220 : 12|11:48:36.0298|_UNR5S|DANIEL| user DANIEL. t Verbose: 1220 : 12|11:48:36.0298|_UNR5S|DANIEL|OAuth. User logged in: DANIEL t Information: 1220 : 12|11:48:36.0298|_UNR5S|DANIEL|GetUserDataByKeys: consumer.recent.data t Transfer: 1220 : 12|11:48:36.0298|_UNR5S|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|11:48:36.0298|_UNR5S|DANIEL| OAuth authenticated t Transfer: 1220 : 12|11:48:36.0298|_UNR5S|DANIEL| user DANIEL. t Verbose: 1220 : 12|11:48:36.0298|_UNR5S|DANIEL|imfx v3 API took 0.005s '/api/user-preferences?keys=consumer.recent.data&_dc=1585738116086' t Transfer: 1220 : 12|11:48:43.7485|A~nA5q|DANIEL|OAuth: /api/view/searchinfo/Job?_dc=1585738123857 t Transfer: 1220 : 12|11:48:43.7485|A~nA5q|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|11:48:43.7485|A~nA5q|DANIEL| OAuth authenticated t Transfer: 1220 : 12|11:48:43.7485|A~nA5q|DANIEL| user DANIEL. t Verbose: 1220 : 12|11:48:43.7485|A~nA5q|DANIEL|OAuth. User logged in: DANIEL t Transfer: 1220 : 12|11:48:43.7485|DcHgPL|DANIEL|OAuth: /api/lookups/SearchSupportedOperators?_dc=1585738123859 t Transfer: 1220 : 12|11:48:43.7485|DcHgPL|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|11:48:43.7485|DcHgPL|DANIEL| OAuth authenticated t Transfer: 1220 : 12|11:48:43.7485|DcHgPL|DANIEL| user DANIEL. t Information: 1220 : 12|11:48:43.7485|A~nA5q|DANIEL|GetAdvSearchColumns. search type Job grid . t Verbose: 1220 : 12|11:48:43.7485|DcHgPL|DANIEL|OAuth. User logged in: DANIEL t Verbose: 1220 : 12|11:48:43.7485|DcHgPL|DANIEL|imfx v3 API took 0.000s '/api/lookups/SearchSupportedOperators?_dc=1585738123859' t Transfer: 1220 : 12|11:48:43.7485|q8wWtM|DANIEL|OAuth: /api/user-preferences?keys=adv.recent.searches.workflow&_dc=1585738123866 t Transfer: 1220 : 12|11:48:43.7485|q8wWtM|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|11:48:43.7485|q8wWtM|DANIEL| OAuth authenticated t Transfer: 1220 : 12|11:48:43.7485|q8wWtM|DANIEL| user DANIEL. t Verbose: 1220 : 12|11:48:43.7485|q8wWtM|DANIEL|OAuth. User logged in: DANIEL t Information: 1220 : 12|11:48:43.7485|q8wWtM|DANIEL|GetUserDataByKeys: adv.recent.searches.workflow t Transfer: 1220 : 12|11:48:43.7485|q8wWtM|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|11:48:43.7485|q8wWtM|DANIEL| OAuth authenticated t Transfer: 1220 : 12|11:48:43.7485|q8wWtM|DANIEL| user DANIEL. t Verbose: 1220 : 12|11:48:43.7485|q8wWtM|DANIEL|imfx v3 API took 0.006s '/api/user-preferences?keys=adv.recent.searches.workflow&_dc=1585738123866' t Verbose: 1220 : 12|11:48:43.7485|A~nA5q|DANIEL|imfx v3 API took 0.017s '/api/view/searchinfo/Job?_dc=1585738123857' t Transfer: 1220 : 12|11:48:43.7485|rQCt4p|DANIEL|OAuth: /api/view/info/Job?lang=en-GB&_dc=1585738123921 t Transfer: 1220 : 12|11:48:43.7485|rQCt4p|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|11:48:43.7485|rQCt4p|DANIEL| OAuth authenticated t Transfer: 1220 : 12|11:48:43.7485|rQCt4p|DANIEL| user DANIEL. t Verbose: 1220 : 12|11:48:43.7485|rQCt4p|DANIEL|OAuth. User logged in: DANIEL t Information: 1220 : 12|11:48:43.7485|rQCt4p|DANIEL|GetGridViewBuilder. builder type Job. t Transfer: 1220 : 12|11:48:43.7485|rQCt4p|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|11:48:43.7485|rQCt4p|DANIEL| OAuth authenticated t Transfer: 1220 : 12|11:48:43.7485|rQCt4p|DANIEL| user DANIEL. t Information: 1220 : 12|11:48:43.7485|rQCt4p|DANIEL|UserGridView. LoadView. ID 862, Name Default. t Transfer: 1220 : 12|11:48:43.7485|rQCt4p|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|11:48:43.7485|rQCt4p|DANIEL| OAuth authenticated t Transfer: 1220 : 12|11:48:43.7485|rQCt4p|DANIEL| user DANIEL. t Transfer: 1220 : 12|11:48:43.7485|rQCt4p|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|11:48:43.7485|rQCt4p|DANIEL| OAuth authenticated t Transfer: 1220 : 12|11:48:43.7485|rQCt4p|DANIEL| user DANIEL. t Verbose: 1220 : 12|11:48:43.9673|rQCt4p|DANIEL|imfx v3 API took 0.031s '/api/view/info/Job?lang=en-GB&_dc=1585738123921' t Transfer: 1220 : 12|11:48:43.9673|EaPnRG|DANIEL|OAuth: /api/view/searches/Job?_dc=1585738123957 t Transfer: 1220 : 12|11:48:43.9673|EaPnRG|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|11:48:43.9673|EaPnRG|DANIEL| OAuth authenticated t Transfer: 1220 : 12|11:48:43.9673|EaPnRG|DANIEL| user DANIEL. t Verbose: 1220 : 12|11:48:43.9673|EaPnRG|DANIEL|OAuth. User logged in: DANIEL t Information: 1220 : 12|11:48:43.9673|EaPnRG|DANIEL|GetSavedSearchNames. search type Job. t Transfer: 1220 : 12|11:48:43.9673|EaPnRG|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|11:48:43.9673|EaPnRG|DANIEL| OAuth authenticated t Transfer: 1220 : 12|11:48:43.9673|EaPnRG|DANIEL| user DANIEL. t Verbose: 1220 : 12|11:48:43.9673|EaPnRG|DANIEL|imfx v3 API took 0.034s '/api/view/searches/Job?_dc=1585738123957' t Transfer: 1220 : 12|11:48:43.9673|N12_j7|DANIEL|OAuth: /api/lookup/job-schedule-nodes/search/?_dc=1585738124050 t Transfer: 1220 : 12|11:48:43.9673|N12_j7|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|11:48:43.9673|N12_j7|DANIEL| OAuth authenticated t Transfer: 1220 : 12|11:48:43.9673|N12_j7|DANIEL| user DANIEL. t Verbose: 1220 : 12|11:48:43.9673|N12_j7|DANIEL|OAuth. User logged in: DANIEL t Verbose: 1220 : 12|11:48:43.9673|N12_j7|DANIEL|imfx v3 API took 0.043s '/api/lookup/job-schedule-nodes/search/?_dc=1585738124050' t Transfer: 1220 : 12|11:48:47.2173|ymHSqI|DANIEL|OAuth: /api/view/search/Job/1311?_dc=1585738127377 t Transfer: 1220 : 12|11:48:47.2173|ymHSqI|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|11:48:47.2173|ymHSqI|DANIEL| OAuth authenticated t Transfer: 1220 : 12|11:48:47.2173|ymHSqI|DANIEL| user DANIEL. t Verbose: 1220 : 12|11:48:47.2173|ymHSqI|DANIEL|OAuth. User logged in: DANIEL t Information: 1220 : 12|11:48:47.2173|ymHSqI|DANIEL|GetSearchItem. search type Job id 1311. t Transfer: 1220 : 12|11:48:47.2173|vu42ay|DANIEL|OAuth: /api/view/search/Job/1311?_dc=1585738127389 t Transfer: 1220 : 12|11:48:47.2173|vu42ay|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|11:48:47.2173|vu42ay|DANIEL| OAuth authenticated t Transfer: 1220 : 12|11:48:47.2173|vu42ay|DANIEL| user DANIEL. t Verbose: 1220 : 12|11:48:47.2173|vu42ay|DANIEL|OAuth. User logged in: DANIEL t Information: 1220 : 12|11:48:47.2173|vu42ay|DANIEL|GetSearchItem. search type Job id 1311. t Verbose: 1220 : 12|11:48:47.4204|ymHSqI|DANIEL|imfx v3 API took 0.035s '/api/view/search/Job/1311?_dc=1585738127377' t Verbose: 1220 : 12|11:48:47.4204|vu42ay|DANIEL|imfx v3 API took 0.081s '/api/view/search/Job/1311?_dc=1585738127389' t Transfer: 1220 : 12|11:48:48.4361|W7RwxE|DANIEL|OAuth: /api/v3/search/workflow?_dc=1585738128559 t Transfer: 1220 : 12|11:48:48.4361|W7RwxE|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|11:48:48.4361|W7RwxE|DANIEL| OAuth authenticated t Transfer: 1220 : 12|11:48:48.4361|W7RwxE|DANIEL| user DANIEL. t Verbose: 1220 : 12|11:48:48.4361|W7RwxE|DANIEL|OAuth. User logged in: DANIEL t Information: 1220 : 12|11:48:48.4361|W7RwxE|DANIEL|V3Api.SearchWorkflows t Information: 1220 : 12|11:48:48.4361|W7RwxE|DANIEL|V3Api.SearchGeneric t Transfer: 1220 : 12|11:48:48.4361|W7RwxE|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|11:48:48.4361|W7RwxE|DANIEL| OAuth authenticated t Transfer: 1220 : 12|11:48:48.4361|W7RwxE|DANIEL| user DANIEL. t Information: 1220 : 12|11:48:48.4361|W7RwxE|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|11:48:48.4361|W7RwxE|DANIEL| jobs returned 7, searched in 00:00:00.0110135 t Information: 1220 : 12|11:48:48.4361|W7RwxE|DANIEL| tasks returned 7, searched in 00:00:00.0183094 t Verbose: 1220 : 12|11:48:48.4361|W7RwxE|DANIEL|imfx v3 API took 0.042s '/api/v3/search/workflow?_dc=1585738128559' t Transfer: 1220 : 12|11:48:48.8423|RIvywV|DANIEL|OAuth: /api/user-preferences?_dc=1585738128891 t Transfer: 1220 : 12|11:48:48.8423|RIvywV|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|11:48:48.8423|RIvywV|DANIEL| OAuth authenticated t Transfer: 1220 : 12|11:48:48.8423|RIvywV|DANIEL| user DANIEL. t Verbose: 1220 : 12|11:48:48.8423|RIvywV|DANIEL|OAuth. User logged in: DANIEL t Verbose: 1220 : 12|11:48:48.8423|RIvywV|DANIEL|StoreUserDataByKeys.. t Transfer: 1220 : 12|11:48:48.8423|RIvywV|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|11:48:48.8423|RIvywV|DANIEL| OAuth authenticated t Transfer: 1220 : 12|11:48:48.8423|RIvywV|DANIEL| user DANIEL. t Verbose: 1220 : 12|11:48:48.8423|RIvywV|DANIEL|imfx v3 API took 0.028s '/api/user-preferences?_dc=1585738128891' t Transfer: 1220 : 12|11:48:52.0923|RQB0JO|DANIEL|OAuth: /api/v3/task/componentqc/109492?_dc=1585738132106 t Transfer: 1220 : 12|11:48:52.0923|RQB0JO|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|11:48:52.0923|RQB0JO|DANIEL| OAuth authenticated t Transfer: 1220 : 12|11:48:52.0923|RQB0JO|DANIEL| user DANIEL. t Verbose: 1220 : 12|11:48:52.0923|RQB0JO|DANIEL|OAuth. User logged in: DANIEL t Information: 1220 : 12|11:48:52.0923|RQB0JO|DANIEL|V3Api. GetComponentQc task: 109492 t Information: 1220 : 12|11:48:52.2954|RQB0JO|DANIEL|SubtitleQcTask. LoadFromDb got Job 109491 and Subtitles 2. t Verbose: 1220 : 12|11:48:52.2954|RQB0JO|DANIEL|imfx v3 API took 0.182s '/api/v3/task/componentqc/109492?_dc=1585738132106' t Information: 1220 : 12|11:48:52.3267|RQB0JO|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=1585738132106 System.Web.Http.Routing.HttpRoute t Transfer: 1220 : 12|11:48:53.9673|IHPpZ7|DANIEL|OAuth: /api/v3/search/workflow?_dc=1585738134110 t Transfer: 1220 : 12|11:48:53.9673|IHPpZ7|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|11:48:53.9673|IHPpZ7|DANIEL| OAuth authenticated t Transfer: 1220 : 12|11:48:53.9673|IHPpZ7|DANIEL| user DANIEL. t Verbose: 1220 : 12|11:48:53.9673|IHPpZ7|DANIEL|OAuth. User logged in: DANIEL t Information: 1220 : 12|11:48:53.9673|IHPpZ7|DANIEL|V3Api.SearchWorkflows t Information: 1220 : 12|11:48:53.9673|IHPpZ7|DANIEL|V3Api.SearchGeneric t Transfer: 1220 : 12|11:48:53.9673|IHPpZ7|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|11:48:53.9673|IHPpZ7|DANIEL| OAuth authenticated t Transfer: 1220 : 12|11:48:53.9673|IHPpZ7|DANIEL| user DANIEL. t Information: 1220 : 12|11:48:53.9673|IHPpZ7|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|11:48:53.9673|IHPpZ7|DANIEL| jobs returned 1, searched in 00:00:00.0063117 t Information: 1220 : 12|11:48:53.9673|IHPpZ7|DANIEL| tasks returned 1, searched in 00:00:00.0113119 t Verbose: 1220 : 12|11:48:53.9673|IHPpZ7|DANIEL|imfx v3 API took 0.024s '/api/v3/search/workflow?_dc=1585738134110' t Transfer: 1220 : 12|11:49:01.8892|4QauyB|DANIEL|OAuth: /api/v3/jobs/delete?_dc=1585738141935 t Transfer: 1220 : 12|11:49:01.8892|4QauyB|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|11:49:01.8892|4QauyB|DANIEL| OAuth authenticated t Transfer: 1220 : 12|11:49:01.8892|4QauyB|DANIEL| user DANIEL. t Verbose: 1220 : 12|11:49:01.8892|4QauyB|DANIEL|OAuth. User logged in: DANIEL t Transfer: 1220 : 12|11:49:01.8892|4QauyB|DANIEL| semaphore enter at: 4/1/2020 11:49:01 AM count: 9 thread: 33 t Transfer: 1220 : 12|11:49:01.8892|4QauyB|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|11:49:01.8892|4QauyB|DANIEL| OAuth authenticated t Transfer: 1220 : 12|11:49:01.8892|4QauyB|DANIEL| user DANIEL. t Information: 1220 : 12|11:49:01.8892|4QauyB|DANIEL|CallApi. In. Trace-id: lC~SIJ Msg: deleteWorkflow. User: DANIEL. Rights: False. t Information: 1220 : 12|11:49:02.4985|4QauyB|DANIEL|CallApi. Out. Trace-id: lC~SIJ 548.5ms. t Information: 1220 : 12|11:49:02.4985|4QauyB|DANIEL| 1 200 t Transfer: 1220 : 12|11:49:02.4985|4QauyB|DANIEL| semaphore release at: 4/1/2020 11:49:02 AM count: 9 thread: 33 t Transfer: 1220 : 12|11:49:02.4985|4QauyB|DANIEL| semaphore enter at: 4/1/2020 11:49:02 AM count: 9 thread: 33 t Transfer: 1220 : 12|11:49:02.4985|4QauyB|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|11:49:02.4985|4QauyB|DANIEL| OAuth authenticated t Transfer: 1220 : 12|11:49:02.4985|4QauyB|DANIEL| user DANIEL. t Information: 1220 : 12|11:49:02.4985|4QauyB|DANIEL|CallApi. In. Trace-id: qS4o8S Msg: deleteWorkflow. User: DANIEL. Rights: False. t Information: 1220 : 12|11:49:02.4985|4QauyB|DANIEL|CallApi. Out. Trace-id: qS4o8S 99.5ms. t Information: 1220 : 12|11:49:02.4985|4QauyB|DANIEL| 1 200 t Transfer: 1220 : 12|11:49:02.4985|4QauyB|DANIEL| semaphore release at: 4/1/2020 11:49:02 AM count: 9 thread: 33 t Transfer: 1220 : 12|11:49:02.4985|4QauyB|DANIEL| semaphore enter at: 4/1/2020 11:49:02 AM count: 9 thread: 33 t Transfer: 1220 : 12|11:49:02.4985|4QauyB|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|11:49:02.4985|4QauyB|DANIEL| OAuth authenticated t Transfer: 1220 : 12|11:49:02.4985|4QauyB|DANIEL| user DANIEL. t Information: 1220 : 12|11:49:02.4985|4QauyB|DANIEL|CallApi. In. Trace-id: D0qm0Q Msg: deleteWorkflow. User: DANIEL. Rights: False. t Information: 1220 : 12|11:49:02.7016|4QauyB|DANIEL|CallApi. Out. Trace-id: D0qm0Q 92.1ms. t Information: 1220 : 12|11:49:02.7016|4QauyB|DANIEL| 1 200 t Transfer: 1220 : 12|11:49:02.7016|4QauyB|DANIEL| semaphore release at: 4/1/2020 11:49:02 AM count: 9 thread: 33 t Transfer: 1220 : 12|11:49:02.7016|4QauyB|DANIEL| semaphore enter at: 4/1/2020 11:49:02 AM count: 9 thread: 33 t Transfer: 1220 : 12|11:49:02.7016|4QauyB|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|11:49:02.7016|4QauyB|DANIEL| OAuth authenticated t Transfer: 1220 : 12|11:49:02.7016|4QauyB|DANIEL| user DANIEL. t Information: 1220 : 12|11:49:02.7016|4QauyB|DANIEL|CallApi. In. Trace-id: 7uahlK Msg: deleteWorkflow. User: DANIEL. Rights: False. t Information: 1220 : 12|11:49:02.7016|4QauyB|DANIEL|CallApi. Out. Trace-id: 7uahlK 79.9ms. t Information: 1220 : 12|11:49:02.7016|4QauyB|DANIEL| 1 200 t Transfer: 1220 : 12|11:49:02.7016|4QauyB|DANIEL| semaphore release at: 4/1/2020 11:49:02 AM count: 9 thread: 33 t Transfer: 1220 : 12|11:49:02.7016|4QauyB|DANIEL| semaphore enter at: 4/1/2020 11:49:02 AM count: 9 thread: 33 t Transfer: 1220 : 12|11:49:02.7016|4QauyB|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|11:49:02.7016|4QauyB|DANIEL| OAuth authenticated t Transfer: 1220 : 12|11:49:02.7016|4QauyB|DANIEL| user DANIEL. t Information: 1220 : 12|11:49:02.7016|4QauyB|DANIEL|CallApi. In. Trace-id: Zh_JrY Msg: deleteWorkflow. User: DANIEL. Rights: False. t Information: 1220 : 12|11:49:02.7016|4QauyB|DANIEL|CallApi. Out. Trace-id: Zh_JrY 85.9ms. t Information: 1220 : 12|11:49:02.7016|4QauyB|DANIEL| 1 200 t Transfer: 1220 : 12|11:49:02.7016|4QauyB|DANIEL| semaphore release at: 4/1/2020 11:49:02 AM count: 9 thread: 33 t Transfer: 1220 : 12|11:49:02.7016|4QauyB|DANIEL| semaphore enter at: 4/1/2020 11:49:02 AM count: 9 thread: 33 t Transfer: 1220 : 12|11:49:02.7016|4QauyB|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|11:49:02.7016|4QauyB|DANIEL| OAuth authenticated t Transfer: 1220 : 12|11:49:02.7016|4QauyB|DANIEL| user DANIEL. t Information: 1220 : 12|11:49:02.7016|4QauyB|DANIEL|CallApi. In. Trace-id: eYKjDj Msg: deleteWorkflow. User: DANIEL. Rights: False. t Information: 1220 : 12|11:49:02.9048|4QauyB|DANIEL|CallApi. Out. Trace-id: eYKjDj 86.7ms. t Information: 1220 : 12|11:49:02.9048|4QauyB|DANIEL| 1 200 t Transfer: 1220 : 12|11:49:02.9048|4QauyB|DANIEL| semaphore release at: 4/1/2020 11:49:02 AM count: 9 thread: 33 t Transfer: 1220 : 12|11:49:02.9048|4QauyB|DANIEL| semaphore enter at: 4/1/2020 11:49:02 AM count: 9 thread: 33 t Transfer: 1220 : 12|11:49:02.9048|4QauyB|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|11:49:02.9048|4QauyB|DANIEL| OAuth authenticated t Transfer: 1220 : 12|11:49:02.9048|4QauyB|DANIEL| user DANIEL. t Information: 1220 : 12|11:49:02.9048|4QauyB|DANIEL|CallApi. In. Trace-id: V~8sAs Msg: deleteWorkflow. User: DANIEL. Rights: False. t Information: 1220 : 12|11:49:02.9048|4QauyB|DANIEL|CallApi. Out. Trace-id: V~8sAs 97.6ms. t Information: 1220 : 12|11:49:02.9048|4QauyB|DANIEL| 1 200 t Transfer: 1220 : 12|11:49:02.9048|4QauyB|DANIEL| semaphore release at: 4/1/2020 11:49:02 AM count: 9 thread: 33 t Verbose: 1220 : 12|11:49:02.9048|4QauyB|DANIEL|imfx v3 API took 1.110s '/api/v3/jobs/delete?_dc=1585738141935' t Transfer: 1220 : 12|11:51:01.5298|JU9ycZ|DANIEL|OAuth: /api/v3/search/workflow?_dc=1585738261483 t Transfer: 1220 : 12|11:51:01.5298|JU9ycZ|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|11:51:01.5298|JU9ycZ|DANIEL| OAuth authenticated t Transfer: 1220 : 12|11:51:01.5298|JU9ycZ|DANIEL| user DANIEL. t Verbose: 1220 : 12|11:51:01.5298|JU9ycZ|DANIEL|OAuth. User logged in: DANIEL t Information: 1220 : 12|11:51:01.5298|JU9ycZ|DANIEL|V3Api.SearchWorkflows t Information: 1220 : 12|11:51:01.5298|JU9ycZ|DANIEL|V3Api.SearchGeneric t Transfer: 1220 : 12|11:51:01.5298|JU9ycZ|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|11:51:01.5298|JU9ycZ|DANIEL| OAuth authenticated t Transfer: 1220 : 12|11:51:01.5298|JU9ycZ|DANIEL| user DANIEL. t Information: 1220 : 12|11:51:01.5298|JU9ycZ|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|11:51:01.5298|JU9ycZ|DANIEL| jobs returned 1, searched in 00:00:00.0048230 t Information: 1220 : 12|11:51:01.7329|JU9ycZ|DANIEL| tasks returned 1, searched in 00:00:00.0333661 t Verbose: 1220 : 12|11:51:01.7329|JU9ycZ|DANIEL|imfx v3 API took 0.045s '/api/v3/search/workflow?_dc=1585738261483' t Transfer: 1220 : 12|11:51:01.7329|HJPAn3|DANIEL|OAuth: /api/user-preferences?_dc=1585738261691 t Transfer: 1220 : 12|11:51:01.7329|HJPAn3|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|11:51:01.7329|HJPAn3|DANIEL| OAuth authenticated t Transfer: 1220 : 12|11:51:01.7329|HJPAn3|DANIEL| user DANIEL. t Verbose: 1220 : 12|11:51:01.7329|HJPAn3|DANIEL|OAuth. User logged in: DANIEL t Verbose: 1220 : 12|11:51:01.7329|HJPAn3|DANIEL|StoreUserDataByKeys.. t Transfer: 1220 : 12|11:51:01.7329|HJPAn3|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|11:51:01.7329|HJPAn3|DANIEL| OAuth authenticated t Transfer: 1220 : 12|11:51:01.7329|HJPAn3|DANIEL| user DANIEL. t Verbose: 1220 : 12|11:51:01.7329|HJPAn3|DANIEL|imfx v3 API took 0.009s '/api/user-preferences?_dc=1585738261691' t Transfer: 1220 : 12|11:51:03.3579|b3Sgua|DANIEL|OAuth: /api/v3/task/componentqc/109497?_dc=1585738263318 t Transfer: 1220 : 12|11:51:03.3579|b3Sgua|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|11:51:03.3579|b3Sgua|DANIEL| OAuth authenticated t Transfer: 1220 : 12|11:51:03.3579|b3Sgua|DANIEL| user DANIEL. t Verbose: 1220 : 12|11:51:03.3579|b3Sgua|DANIEL|OAuth. User logged in: DANIEL t Information: 1220 : 12|11:51:03.3579|b3Sgua|DANIEL|V3Api. GetComponentQc task: 109497 t Information: 1220 : 12|11:51:03.3579|b3Sgua|DANIEL|SubtitleQcTask. LoadFromDb got Job 109496 and Subtitles 1. t Verbose: 1220 : 12|11:51:03.3579|b3Sgua|DANIEL|imfx v3 API took 0.029s '/api/v3/task/componentqc/109497?_dc=1585738263318' t Information: 1220 : 12|11:51:03.3579|b3Sgua|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/109497?_dc=1585738263318 System.Web.Http.Routing.HttpRoute t Transfer: 1220 : 12|11:51:05.1860|kYbYAa|DANIEL|OAuth: /api/v3/search/workflow?_dc=1585738265166 t Transfer: 1220 : 12|11:51:05.1860|kYbYAa|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|11:51:05.1860|kYbYAa|DANIEL| OAuth authenticated t Transfer: 1220 : 12|11:51:05.1860|kYbYAa|DANIEL| user DANIEL. t Verbose: 1220 : 12|11:51:05.1860|kYbYAa|DANIEL|OAuth. User logged in: DANIEL t Information: 1220 : 12|11:51:05.1860|kYbYAa|DANIEL|V3Api.SearchWorkflows t Information: 1220 : 12|11:51:05.1860|kYbYAa|DANIEL|V3Api.SearchGeneric t Transfer: 1220 : 12|11:51:05.1860|kYbYAa|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|11:51:05.1860|kYbYAa|DANIEL| OAuth authenticated t Transfer: 1220 : 12|11:51:05.1860|kYbYAa|DANIEL| user DANIEL. t Information: 1220 : 12|11:51:05.1860|kYbYAa|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=109496 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|11:51:05.3892|kYbYAa|DANIEL| jobs returned 1, searched in 00:00:00.1414934 t Information: 1220 : 12|11:51:05.3892|kYbYAa|DANIEL| tasks returned 1, searched in 00:00:00.0067720 t Verbose: 1220 : 12|11:51:05.3892|kYbYAa|DANIEL|imfx v3 API took 0.162s '/api/v3/search/workflow?_dc=1585738265166' t Transfer: 1220 : 12|11:52:19.3266|7Un6H1|DANIEL|OAuth: /api/v3/search/workflow?_dc=1585738339270 t Transfer: 1220 : 12|11:52:19.3266|7Un6H1|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|11:52:19.3266|7Un6H1|DANIEL| OAuth authenticated t Transfer: 1220 : 12|11:52:19.3266|7Un6H1|DANIEL| user DANIEL. t Verbose: 1220 : 12|11:52:19.3266|7Un6H1|DANIEL|OAuth. User logged in: DANIEL t Information: 1220 : 12|11:52:19.3266|7Un6H1|DANIEL|V3Api.SearchWorkflows t Information: 1220 : 12|11:52:19.3266|7Un6H1|DANIEL|V3Api.SearchGeneric t Transfer: 1220 : 12|11:52:19.3266|7Un6H1|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|11:52:19.3266|7Un6H1|DANIEL| OAuth authenticated t Transfer: 1220 : 12|11:52:19.3266|7Un6H1|DANIEL| user DANIEL. t Information: 1220 : 12|11:52:19.3266|7Un6H1|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|11:52:19.3266|7Un6H1|DANIEL| jobs returned 2, searched in 00:00:00.0065243 t Information: 1220 : 12|11:52:19.3266|7Un6H1|DANIEL| tasks returned 2, searched in 00:00:00.0208678 t Verbose: 1220 : 12|11:52:19.3266|7Un6H1|DANIEL|imfx v3 API took 0.033s '/api/v3/search/workflow?_dc=1585738339270' t Transfer: 1220 : 12|11:52:19.5298|IFkjPH|DANIEL|OAuth: /api/user-preferences?_dc=1585738339367 t Transfer: 1220 : 12|11:52:19.5298|IFkjPH|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|11:52:19.5298|IFkjPH|DANIEL| OAuth authenticated t Transfer: 1220 : 12|11:52:19.5298|IFkjPH|DANIEL| user DANIEL. t Verbose: 1220 : 12|11:52:19.5298|IFkjPH|DANIEL|OAuth. User logged in: DANIEL t Verbose: 1220 : 12|11:52:19.5298|IFkjPH|DANIEL|StoreUserDataByKeys.. t Transfer: 1220 : 12|11:52:19.5298|IFkjPH|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|11:52:19.5298|IFkjPH|DANIEL| OAuth authenticated t Transfer: 1220 : 12|11:52:19.5298|IFkjPH|DANIEL| user DANIEL. t Verbose: 1220 : 12|11:52:19.5298|IFkjPH|DANIEL|imfx v3 API took 0.017s '/api/user-preferences?_dc=1585738339367' t Transfer: 1220 : 12|11:52:21.1548|Ba512Z|DANIEL|OAuth: /api/v3/task/componentqc/109501?_dc=1585738340993 t Transfer: 1220 : 12|11:52:21.1548|Ba512Z|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|11:52:21.1548|Ba512Z|DANIEL| OAuth authenticated t Transfer: 1220 : 12|11:52:21.1548|Ba512Z|DANIEL| user DANIEL. t Verbose: 1220 : 12|11:52:21.1548|Ba512Z|DANIEL|OAuth. User logged in: DANIEL t Information: 1220 : 12|11:52:21.1548|Ba512Z|DANIEL|V3Api. GetComponentQc task: 109501 t Information: 1220 : 12|11:52:21.1548|Ba512Z|DANIEL|SubtitleQcTask. LoadFromDb got Job 109500 and Subtitles 1. t Information: 1220 : 12|11:52:21.1548|Ba512Z|DANIEL|SubtitleQcTask. LoadFromDb processing Media 298919. t Information: 1220 : 12|11:52:21.1548|Ba512Z|DANIEL|SubtitleQcTask. LoadFromDb finished. t Verbose: 1220 : 12|11:52:21.1548|Ba512Z|DANIEL|imfx v3 API took 0.051s '/api/v3/task/componentqc/109501?_dc=1585738340993' t Transfer: 1220 : 12|11:52:21.3580|Ba512Z|DANIEL|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\PmH_Demo001.mp4 subfolder t Transfer: 1220 : 12|11:52:21.3580|Ba512Z|DANIEL| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/PmH_Demo001.mp4 t Transfer: 1220 : 12|11:52:21.3580|Ba512Z|DANIEL|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/PmH_Demo001.mp4 t Transfer: 1220 : 12|11:52:21.3580|Ba512Z|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|11:52:21.3580|Ba512Z|DANIEL| OAuth authenticated t Transfer: 1220 : 12|11:52:21.3580|Ba512Z|DANIEL| user DANIEL. t Transfer: 1220 : 12|11:52:21.5610|8UlH89|DANIEL|OAuth: /api/v3/detailsview/Job/0?lang=en-GB&_dc=1585738341508 t Transfer: 1220 : 12|11:52:21.5610|8UlH89|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|11:52:21.5610|8UlH89|DANIEL| OAuth authenticated t Transfer: 1220 : 12|11:52:21.5610|8UlH89|DANIEL| user DANIEL. t Verbose: 1220 : 12|11:52:21.5610|8UlH89|DANIEL|OAuth. User logged in: DANIEL t Verbose: 1220 : 12|11:52:21.5610|8UlH89|DANIEL|imfx v3 API took 0.031s '/api/v3/detailsview/Job/0?lang=en-GB&_dc=1585738341508' t Transfer: 1220 : 12|11:52:30.0923|Ip5Y8d|DANIEL|OAuth: /api/v3/search/workflow?_dc=1585738350068 t Transfer: 1220 : 12|11:52:30.0923|Ip5Y8d|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|11:52:30.0923|Ip5Y8d|DANIEL| OAuth authenticated t Transfer: 1220 : 12|11:52:30.0923|Ip5Y8d|DANIEL| user DANIEL. t Verbose: 1220 : 12|11:52:30.0923|Ip5Y8d|DANIEL|OAuth. User logged in: DANIEL t Information: 1220 : 12|11:52:30.0923|Ip5Y8d|DANIEL|V3Api.SearchWorkflows t Information: 1220 : 12|11:52:30.0923|Ip5Y8d|DANIEL|V3Api.SearchGeneric t Transfer: 1220 : 12|11:52:30.0923|Ip5Y8d|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|11:52:30.0923|Ip5Y8d|DANIEL| OAuth authenticated t Transfer: 1220 : 12|11:52:30.0923|Ip5Y8d|DANIEL| user DANIEL. t Information: 1220 : 12|11:52:30.0923|Ip5Y8d|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=109500 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|11:52:30.2954|Ip5Y8d|DANIEL| jobs returned 1, searched in 00:00:00.2234202 t Information: 1220 : 12|11:52:30.4985|Ip5Y8d|DANIEL| tasks returned 1, searched in 00:00:00.0232304 t Verbose: 1220 : 12|11:52:30.4985|Ip5Y8d|DANIEL|imfx v3 API took 0.263s '/api/v3/search/workflow?_dc=1585738350068' t Transfer: 1220 : 12|11:52:33.1391|GlKZr8|DANIEL|OAuth: /api/v3/task/componentqc/109497?_dc=1585738352972 t Transfer: 1220 : 12|11:52:33.1391|GlKZr8|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|11:52:33.1391|GlKZr8|DANIEL| OAuth authenticated t Transfer: 1220 : 12|11:52:33.1391|GlKZr8|DANIEL| user DANIEL. t Verbose: 1220 : 12|11:52:33.1391|GlKZr8|DANIEL|OAuth. User logged in: DANIEL t Information: 1220 : 12|11:52:33.1391|GlKZr8|DANIEL|V3Api. GetComponentQc task: 109497 t Information: 1220 : 12|11:52:33.1391|GlKZr8|DANIEL|SubtitleQcTask. LoadFromDb got Job 109496 and Subtitles 1. t Verbose: 1220 : 12|11:52:33.1391|GlKZr8|DANIEL|imfx v3 API took 0.030s '/api/v3/task/componentqc/109497?_dc=1585738352972' t Information: 1220 : 12|11:52:33.1391|GlKZr8|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/109497?_dc=1585738352972 System.Web.Http.Routing.HttpRoute t Transfer: 1220 : 12|11:52:34.9829|lA1OtY|DANIEL|OAuth: /api/v3/search/workflow?_dc=1585738354889 t Transfer: 1220 : 12|11:52:34.9829|lA1OtY|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|11:52:34.9829|lA1OtY|DANIEL| OAuth authenticated t Transfer: 1220 : 12|11:52:34.9829|lA1OtY|DANIEL| user DANIEL. t Verbose: 1220 : 12|11:52:34.9829|lA1OtY|DANIEL|OAuth. User logged in: DANIEL t Information: 1220 : 12|11:52:34.9829|lA1OtY|DANIEL|V3Api.SearchWorkflows t Information: 1220 : 12|11:52:34.9829|lA1OtY|DANIEL|V3Api.SearchGeneric t Transfer: 1220 : 12|11:52:34.9829|lA1OtY|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|11:52:34.9829|lA1OtY|DANIEL| OAuth authenticated t Transfer: 1220 : 12|11:52:34.9829|lA1OtY|DANIEL| user DANIEL. t Information: 1220 : 12|11:52:34.9829|lA1OtY|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=109496 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|11:52:34.9829|lA1OtY|DANIEL| jobs returned 1, searched in 00:00:00.0046775 t Information: 1220 : 12|11:52:34.9829|lA1OtY|DANIEL| tasks returned 1, searched in 00:00:00.0054386 t Verbose: 1220 : 12|11:52:34.9829|lA1OtY|DANIEL|imfx v3 API took 0.016s '/api/v3/search/workflow?_dc=1585738354889' t Transfer: 1220 : 12|11:52:38.8423|KsfBWK|DANIEL|OAuth: /api/v3/job/109500?_dc=1585738358592 t Transfer: 1220 : 12|11:52:38.8423|KsfBWK|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|11:52:38.8423|KsfBWK|DANIEL| OAuth authenticated t Transfer: 1220 : 12|11:52:38.8423|KsfBWK|DANIEL| user DANIEL. t Verbose: 1220 : 12|11:52:38.8423|KsfBWK|DANIEL|OAuth. User logged in: DANIEL t Verbose: 1220 : 12|11:52:39.0455|KsfBWK|DANIEL|imfx v3 API took 0.241s '/api/v3/job/109500?_dc=1585738358592' t Transfer: 1220 : 12|11:52:39.0455|KsfBWK|DANIEL|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\PmH_Demo001.mp4 subfolder t Transfer: 1220 : 12|11:52:39.0455|KsfBWK|DANIEL| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/PmH_Demo001.mp4 t Transfer: 1220 : 12|11:52:39.0455|KsfBWK|DANIEL|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/PmH_Demo001.mp4 t Transfer: 1220 : 12|11:52:39.0455|KsfBWK|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|11:52:39.0455|KsfBWK|DANIEL| OAuth authenticated t Transfer: 1220 : 12|11:52:39.0455|KsfBWK|DANIEL| user DANIEL. t Transfer: 1220 : 12|11:52:43.3110|qrLepT|DANIEL|OAuth: /api/v3/task/109501/history?_dc=1585738363139 t Transfer: 1220 : 12|11:52:43.3110|qrLepT|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|11:52:43.3110|qrLepT|DANIEL| OAuth authenticated t Transfer: 1220 : 12|11:52:43.3110|qrLepT|DANIEL| user DANIEL. t Verbose: 1220 : 12|11:52:43.3110|qrLepT|DANIEL|OAuth. User logged in: DANIEL t Information: 1220 : 12|11:52:43.3110|qrLepT|DANIEL|V3Api. GetTaskStatusHistory. t Verbose: 1220 : 12|11:52:43.3110|qrLepT|DANIEL|imfx v3 API took 0.018s '/api/v3/task/109501/history?_dc=1585738363139' t Transfer: 1220 : 12|11:52:44.7329|wk66Td|DANIEL|OAuth: /api/v3/search/workflow?_dc=1585738364578 t Transfer: 1220 : 12|11:52:44.7329|wk66Td|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|11:52:44.7329|wk66Td|DANIEL| OAuth authenticated t Transfer: 1220 : 12|11:52:44.7329|wk66Td|DANIEL| user DANIEL. t Verbose: 1220 : 12|11:52:44.7329|wk66Td|DANIEL|OAuth. User logged in: DANIEL t Information: 1220 : 12|11:52:44.7329|wk66Td|DANIEL|V3Api.SearchWorkflows t Information: 1220 : 12|11:52:44.7329|wk66Td|DANIEL|V3Api.SearchGeneric t Transfer: 1220 : 12|11:52:44.7329|wk66Td|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|11:52:44.7329|wk66Td|DANIEL| OAuth authenticated t Transfer: 1220 : 12|11:52:44.7329|wk66Td|DANIEL| user DANIEL. t Information: 1220 : 12|11:52:44.7329|wk66Td|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=109500 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|11:52:44.7329|wk66Td|DANIEL| jobs returned 1, searched in 00:00:00.0047950 t Information: 1220 : 12|11:52:44.7329|wk66Td|DANIEL| tasks returned 1, searched in 00:00:00.0089457 t Verbose: 1220 : 12|11:52:44.7329|wk66Td|DANIEL|imfx v3 API took 0.021s '/api/v3/search/workflow?_dc=1585738364578' t Transfer: 1220 : 12|11:52:46.3579|ydjxHs|DANIEL|OAuth: /api/v3/task/componentqc/109501?_dc=1585738366257 t Transfer: 1220 : 12|11:52:46.3579|ydjxHs|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|11:52:46.3579|ydjxHs|DANIEL| OAuth authenticated t Transfer: 1220 : 12|11:52:46.3579|ydjxHs|DANIEL| user DANIEL. t Verbose: 1220 : 12|11:52:46.3579|ydjxHs|DANIEL|OAuth. User logged in: DANIEL t Information: 1220 : 12|11:52:46.3579|ydjxHs|DANIEL|V3Api. GetComponentQc task: 109501 t Information: 1220 : 12|11:52:46.3579|ydjxHs|DANIEL|SubtitleQcTask. LoadFromDb got Job 109500 and Subtitles 1. t Information: 1220 : 12|11:52:46.3579|ydjxHs|DANIEL|SubtitleQcTask. LoadFromDb processing Media 298919. t Information: 1220 : 12|11:52:46.3579|ydjxHs|DANIEL|SubtitleQcTask. LoadFromDb finished. t Verbose: 1220 : 12|11:52:46.3579|ydjxHs|DANIEL|imfx v3 API took 0.025s '/api/v3/task/componentqc/109501?_dc=1585738366257' t Transfer: 1220 : 12|11:52:46.3579|ydjxHs|DANIEL|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\PmH_Demo001.mp4 subfolder t Transfer: 1220 : 12|11:52:46.3579|ydjxHs|DANIEL| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/PmH_Demo001.mp4 t Transfer: 1220 : 12|11:52:46.3579|ydjxHs|DANIEL|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/PmH_Demo001.mp4 t Transfer: 1220 : 12|11:52:46.3579|ydjxHs|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|11:52:46.3579|ydjxHs|DANIEL| OAuth authenticated t Transfer: 1220 : 12|11:52:46.3579|ydjxHs|DANIEL| user DANIEL. t Transfer: 1220 : 12|11:52:46.3579|XlbDxG|DANIEL|OAuth: /api/v3/detailsview/Job/0?lang=en-GB&_dc=1585738366344 t Transfer: 1220 : 12|11:52:46.3579|XlbDxG|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|11:52:46.3579|XlbDxG|DANIEL| OAuth authenticated t Transfer: 1220 : 12|11:52:46.3579|XlbDxG|DANIEL| user DANIEL. t Verbose: 1220 : 12|11:52:46.3579|XlbDxG|DANIEL|OAuth. User logged in: DANIEL t Verbose: 1220 : 12|11:52:46.3579|XlbDxG|DANIEL|imfx v3 API took 0.004s '/api/v3/detailsview/Job/0?lang=en-GB&_dc=1585738366344' t Transfer: 1220 : 12|11:52:49.4048|V7Km2Q|DANIEL|OAuth: /api/v3/search/workflow?_dc=1585738369262 t Transfer: 1220 : 12|11:52:49.4048|V7Km2Q|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|11:52:49.4048|V7Km2Q|DANIEL| OAuth authenticated t Transfer: 1220 : 12|11:52:49.4048|V7Km2Q|DANIEL| user DANIEL. t Verbose: 1220 : 12|11:52:49.4048|V7Km2Q|DANIEL|OAuth. User logged in: DANIEL t Information: 1220 : 12|11:52:49.4048|V7Km2Q|DANIEL|V3Api.SearchWorkflows t Information: 1220 : 12|11:52:49.4048|V7Km2Q|DANIEL|V3Api.SearchGeneric t Transfer: 1220 : 12|11:52:49.4048|V7Km2Q|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|11:52:49.4048|V7Km2Q|DANIEL| OAuth authenticated t Transfer: 1220 : 12|11:52:49.4048|V7Km2Q|DANIEL| user DANIEL. t Information: 1220 : 12|11:52:49.4048|V7Km2Q|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=109500 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|11:52:49.4048|V7Km2Q|DANIEL| jobs returned 1, searched in 00:00:00.0047227 t Information: 1220 : 12|11:52:49.4048|V7Km2Q|DANIEL| tasks returned 1, searched in 00:00:00.0026417 t Verbose: 1220 : 12|11:52:49.4048|V7Km2Q|DANIEL|imfx v3 API took 0.013s '/api/v3/search/workflow?_dc=1585738369262' t Transfer: 1220 : 12|11:53:27.5923|8DNdi0|DANIEL|OAuth: /api/v3/search/workflow?_dc=1585738407503 t Transfer: 1220 : 12|11:53:27.5923|8DNdi0|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|11:53:27.5923|8DNdi0|DANIEL| OAuth authenticated t Transfer: 1220 : 12|11:53:27.5923|8DNdi0|DANIEL| user DANIEL. t Verbose: 1220 : 12|11:53:27.5923|8DNdi0|DANIEL|OAuth. User logged in: DANIEL t Information: 1220 : 12|11:53:27.5923|8DNdi0|DANIEL|V3Api.SearchWorkflows t Information: 1220 : 12|11:53:27.5923|8DNdi0|DANIEL|V3Api.SearchGeneric t Transfer: 1220 : 12|11:53:27.5923|8DNdi0|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|11:53:27.5923|8DNdi0|DANIEL| OAuth authenticated t Transfer: 1220 : 12|11:53:27.5923|8DNdi0|DANIEL| user DANIEL. t Information: 1220 : 12|11:53:27.5923|8DNdi0|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|11:53:27.5923|8DNdi0|DANIEL| jobs returned 3, searched in 00:00:00.0057889 t Information: 1220 : 12|11:53:27.5923|8DNdi0|DANIEL| tasks returned 3, searched in 00:00:00.0245949 t Verbose: 1220 : 12|11:53:27.5923|8DNdi0|DANIEL|imfx v3 API took 0.036s '/api/v3/search/workflow?_dc=1585738407503' t Transfer: 1220 : 12|11:53:27.7954|n6MZS9|DANIEL|OAuth: /api/user-preferences?_dc=1585738407606 t Transfer: 1220 : 12|11:53:27.7954|n6MZS9|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|11:53:27.7954|n6MZS9|DANIEL| OAuth authenticated t Transfer: 1220 : 12|11:53:27.7954|n6MZS9|DANIEL| user DANIEL. t Verbose: 1220 : 12|11:53:27.7954|n6MZS9|DANIEL|OAuth. User logged in: DANIEL t Verbose: 1220 : 12|11:53:27.7954|n6MZS9|DANIEL|StoreUserDataByKeys.. t Transfer: 1220 : 12|11:53:27.7954|n6MZS9|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|11:53:27.7954|n6MZS9|DANIEL| OAuth authenticated t Transfer: 1220 : 12|11:53:27.7954|n6MZS9|DANIEL| user DANIEL. t Verbose: 1220 : 12|11:53:27.7954|n6MZS9|DANIEL|imfx v3 API took 0.009s '/api/user-preferences?_dc=1585738407606' t Transfer: 1220 : 12|11:53:29.4204|SEP1Dt|DANIEL|OAuth: /api/v3/task/componentqc/109505?_dc=1585738409389 t Transfer: 1220 : 12|11:53:29.4204|SEP1Dt|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|11:53:29.4204|SEP1Dt|DANIEL| OAuth authenticated t Transfer: 1220 : 12|11:53:29.4204|SEP1Dt|DANIEL| user DANIEL. t Verbose: 1220 : 12|11:53:29.4204|SEP1Dt|DANIEL|OAuth. User logged in: DANIEL t Information: 1220 : 12|11:53:29.4204|SEP1Dt|DANIEL|V3Api. GetComponentQc task: 109505 t Information: 1220 : 12|11:53:29.6392|SEP1Dt|DANIEL|SubtitleQcTask. LoadFromDb got Job 109504 and Subtitles 2. t Information: 1220 : 12|11:53:29.6392|SEP1Dt|DANIEL|SubtitleQcTask. LoadFromDb processing Media 298919. t Information: 1220 : 12|11:53:29.6392|SEP1Dt|DANIEL|SubtitleQcTask. LoadFromDb processing Media 298927. t Information: 1220 : 12|11:53:29.6392|SEP1Dt|DANIEL|LoadSubtitlesById. filename PMH_s1ep1_pt1.scc device TimedText frame rate NTCS_DF t Information: 1220 : 12|11:53:29.6392|SEP1Dt|DANIEL|LoadSubtitlesById. Filename: PMH_s1ep1_pt1.scc. Device TimedText. Timecode format NTCS_DF. Media ID 0. t Information: 1220 : 12|11:53:29.6392|SEP1Dt|DANIEL|GetCaptions. Start. Filename: PMH_s1ep1_pt1.scc. Cache path C:\inetpub\wwwroot\imfxcore\timedtextcache\. Storage path \\192.168.120.254\DemoFS\Digital Assets\TimedText. Last Modified 1/1/0001 12:00:00 AM t Information: 1220 : 12|11:53:29.6392|SEP1Dt|DANIEL|GetCaptions. Convert required. Som 00:00:00. From: \\192.168.120.254\DemoFS\Digital Assets\TimedText\PMH_s1ep1_pt1.scc to: C:\inetpub\wwwroot\imfxcore\timedtextcache\PMH_s1ep1_pt1.scc_ntcs_df_0.xml t Information: 1220 : 12|11:53:29.6392|SEP1Dt|DANIEL|GetCaptions. Convertor lock aquired. t Information: 1220 : 12|11:53:30.2485|SEP1Dt|DANIEL|GetCaptions. File converted: \\192.168.120.254\DemoFS\Digital Assets\TimedText\PMH_s1ep1_pt1.scc. Result: True t Information: 1220 : 12|11:53:30.2485|SEP1Dt|DANIEL|GetCaptions. In cache. Filename: C:\inetpub\wwwroot\imfxcore\timedtextcache\PMH_s1ep1_pt1.scc_ntcs_df_0.xml t Information: 1220 : 12|11:53:30.2485|SEP1Dt|DANIEL|LoadSubtitlesById. Convertor lock acquired. t Information: 1220 : 12|11:53:30.2485|SEP1Dt|DANIEL|LoadSubtitlesById got 43 lines. t Information: 1220 : 12|11:53:30.2485|SEP1Dt|DANIEL|TM_MIS. LoadSubtitles for ID: 298919 t Information: 1220 : 12|11:53:30.2485|SEP1Dt|DANIEL|TM_MIS. LoadSubtitles for ID: 298919. SQL: 'select id, m_ctnr_id, m_ctnr_loc, modified_dt, tv_std, m_ctnr_fmt_id, nvl((select max(l.language) from tm_audio l where l.miid=m.id),aud_language_id) aud_language_id from tm_mis m where m.id in (298927)' t Information: 1220 : 12|11:53:30.2485|SEP1Dt|DANIEL| Subtitles added for ID: 298919, 298927 Unknown [0] : 'https://imfxv3tm.tmd.tv/getcaptions.aspx?f=PMH_s1ep1_pt1.scc&som=00:00:00:00&storage=TimedText&modified=637188427300000000&tcf=3&id=298927&tmp=0'. t Information: 1220 : 12|11:53:30.2485|SEP1Dt|DANIEL|SubtitleQcTask. LoadFromDb finished. t Verbose: 1220 : 12|11:53:30.2485|SEP1Dt|DANIEL|imfx v3 API took 0.790s '/api/v3/task/componentqc/109505?_dc=1585738409389' t Transfer: 1220 : 12|11:53:30.2485|SEP1Dt|DANIEL|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\PmH_Demo001.mp4 subfolder t Transfer: 1220 : 12|11:53:30.2485|SEP1Dt|DANIEL| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/PmH_Demo001.mp4 t Transfer: 1220 : 12|11:53:30.2485|SEP1Dt|DANIEL|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/PmH_Demo001.mp4 t Transfer: 1220 : 12|11:53:30.2485|SEP1Dt|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|11:53:30.2485|SEP1Dt|DANIEL| OAuth authenticated t Transfer: 1220 : 12|11:53:30.2485|SEP1Dt|DANIEL| user DANIEL. t Transfer: 1220 : 12|11:53:30.2485|aZSdXd|DANIEL|OAuth: /api/v3/detailsview/Job/0?lang=en-GB&_dc=1585738410230 t Transfer: 1220 : 12|11:53:30.2485|aZSdXd|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|11:53:30.2485|aZSdXd|DANIEL| OAuth authenticated t Transfer: 1220 : 12|11:53:30.2485|aZSdXd|DANIEL| user DANIEL. t Verbose: 1220 : 12|11:53:30.2485|aZSdXd|DANIEL|OAuth. User logged in: DANIEL t Verbose: 1220 : 12|11:53:30.2485|aZSdXd|DANIEL|imfx v3 API took 0.005s '/api/v3/detailsview/Job/0?lang=en-GB&_dc=1585738410230' t Transfer: 1220 : 12|11:53:30.4517|5du59i|DANIEL|OAuth: /api/v3/detailsview/MediaDetails/[object Object]?lang=en-GB&_dc=1585738410264 t Transfer: 1220 : 12|11:53:30.4517|5du59i|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|11:53:30.4517|5du59i|DANIEL| OAuth authenticated t Transfer: 1220 : 12|11:53:30.4517|5du59i|DANIEL| user DANIEL. t Verbose: 1220 : 12|11:53:30.4517|5du59i|DANIEL|OAuth. User logged in: DANIEL t Verbose: 1220 : 12|11:53:30.4517|5du59i|DANIEL|imfx v3 API took 0.003s '/api/v3/detailsview/MediaDetails/%5Bobject%20Object%5D?lang=en-GB&_dc=1585738410264' t Transfer: 1220 : 12|11:53:30.4517|9AhgyG|DANIEL|OAuth: /api/v3/layout/default/10?_dc=1585738410326 t Transfer: 1220 : 12|11:53:30.4517|9AhgyG|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|11:53:30.4517|9AhgyG|DANIEL| OAuth authenticated t Transfer: 1220 : 12|11:53:30.4517|9AhgyG|DANIEL| user DANIEL. t Verbose: 1220 : 12|11:53:30.4517|9AhgyG|DANIEL|OAuth. User logged in: DANIEL t Information: 1220 : 12|11:53:30.4517|9AhgyG|DANIEL|LoadDefaultDashboard. t Transfer: 1220 : 12|11:53:30.4517|9AhgyG|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|11:53:30.4517|9AhgyG|DANIEL| OAuth authenticated t Transfer: 1220 : 12|11:53:30.4517|9AhgyG|DANIEL| user DANIEL. t Verbose: 1220 : 12|11:53:30.4517|9AhgyG|DANIEL|imfx v3 API took 0.049s '/api/v3/layout/default/10?_dc=1585738410326' t Transfer: 1220 : 12|11:53:30.4517|HKvjAA|DANIEL|OAuth: /api/lookups/FriendlyNames?_dc=1585738410428 t Transfer: 1220 : 12|11:53:30.4517|HKvjAA|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|11:53:30.4517|HKvjAA|DANIEL| OAuth authenticated t Transfer: 1220 : 12|11:53:30.4517|HKvjAA|DANIEL| user DANIEL. t Verbose: 1220 : 12|11:53:30.4517|HKvjAA|DANIEL|OAuth. User logged in: DANIEL t Verbose: 1220 : 12|11:53:30.4517|HKvjAA|DANIEL|imfx v3 API took 0.000s '/api/lookups/FriendlyNames?_dc=1585738410428' t Transfer: 1220 : 12|11:53:30.6548|XzKSmj|DANIEL|OAuth: /api/lookups/FriendlyNames?_dc=1585738410452 t Transfer: 1220 : 12|11:53:30.6548|XzKSmj|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|11:53:30.6548|XzKSmj|DANIEL| OAuth authenticated t Transfer: 1220 : 12|11:53:30.6548|XzKSmj|DANIEL| user DANIEL. t Verbose: 1220 : 12|11:53:30.6548|XzKSmj|DANIEL|OAuth. User logged in: DANIEL t Verbose: 1220 : 12|11:53:30.6548|XzKSmj|DANIEL|imfx v3 API took 0.000s '/api/lookups/FriendlyNames?_dc=1585738410452' t Transfer: 1220 : 12|11:53:30.6548|sUuRCV|DANIEL|OAuth: /api/lookups/Languages?_dc=1585738410470 t Transfer: 1220 : 12|11:53:30.6548|sUuRCV|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|11:53:30.6548|sUuRCV|DANIEL| OAuth authenticated t Transfer: 1220 : 12|11:53:30.6548|sUuRCV|DANIEL| user DANIEL. t Verbose: 1220 : 12|11:53:30.6548|sUuRCV|DANIEL|OAuth. User logged in: DANIEL t Verbose: 1220 : 12|11:53:30.6548|sUuRCV|DANIEL|imfx v3 API took 0.000s '/api/lookups/Languages?_dc=1585738410470' t Transfer: 1220 : 12|11:53:31.4673|zWhjZ5|DANIEL|OAuth: /api/user-group-preferences?globals=htmlplayerhotkeys,audioOnFrameForward&_dc=1585738411292 t Transfer: 1220 : 12|11:53:31.4673|zWhjZ5|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|11:53:31.4673|zWhjZ5|DANIEL| OAuth authenticated t Transfer: 1220 : 12|11:53:31.4673|zWhjZ5|DANIEL| user DANIEL. t Verbose: 1220 : 12|11:53:31.4673|zWhjZ5|DANIEL|OAuth. User logged in: DANIEL t Transfer: 1220 : 12|11:53:31.4673|zWhjZ5|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|11:53:31.4673|zWhjZ5|DANIEL| OAuth authenticated t Transfer: 1220 : 12|11:53:31.4673|zWhjZ5|DANIEL| user DANIEL. t Verbose: 1220 : 12|11:53:31.4673|zWhjZ5|DANIEL|imfx v3 API took 0.004s '/api/user-group-preferences?globals=htmlplayerhotkeys,audioOnFrameForward&_dc=1585738411292' t Transfer: 1220 : 12|11:53:31.4673|6ixeQI|DANIEL|OAuth: /api/v3/mediavideo/298919?info=smudge&_dc=1585738411364 t Transfer: 1220 : 12|11:53:31.4673|6ixeQI|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|11:53:31.4673|6ixeQI|DANIEL| OAuth authenticated t Transfer: 1220 : 12|11:53:31.4673|6ixeQI|DANIEL| user DANIEL. t Verbose: 1220 : 12|11:53:31.4673|6ixeQI|DANIEL|OAuth. User logged in: DANIEL t Transfer: 1220 : 12|11:53:31.4673|6ixeQI|DANIEL|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\PmH_Demo001.mp4 subfolder t Transfer: 1220 : 12|11:53:31.4673|6ixeQI|DANIEL| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/PmH_Demo001.mp4 t Transfer: 1220 : 12|11:53:31.4673|6ixeQI|DANIEL|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/PmH_Demo001.mp4 t Transfer: 1220 : 12|11:53:31.4673|6ixeQI|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|11:53:31.4673|6ixeQI|DANIEL| OAuth authenticated t Transfer: 1220 : 12|11:53:31.4673|6ixeQI|DANIEL| user DANIEL. t Verbose: 1220 : 12|11:53:31.6704|6ixeQI|DANIEL|imfx v3 API took 0.077s '/api/v3/mediavideo/298919?info=smudge&_dc=1585738411364' t Information: 1220 : 12|11:53:31.6704|TlG9ku||GetCaptionsForWeb. Filename: PMH_s1ep1_pt1.scc. Device TimedText. Format WebVTT. Timecode format FPS24. Media ID 298927. Last Modified 3/3/2020 2:32:10 PM t Information: 1220 : 12|11:53:31.6704|TlG9ku||GetCaptions. Start. Filename: PMH_s1ep1_pt1.scc. Cache path C:\inetpub\wwwroot\imfxcore\timedtextcache\. Storage path \\192.168.120.254\DemoFS\Digital Assets\TimedText. Last Modified 3/3/2020 2:32:10 PM t Information: 1220 : 12|11:53:31.6704|TlG9ku||GetCaptions. No refresh needed. Filename: C:\inetpub\wwwroot\imfxcore\timedtextcache\PMH_s1ep1_pt1.scc_fps24_298927.vtt t Information: 1220 : 12|11:53:31.6704|TlG9ku||GetCaptions. In cache. Filename: C:\inetpub\wwwroot\imfxcore\timedtextcache\PMH_s1ep1_pt1.scc_fps24_298927.vtt t Transfer: 1220 : 12|11:56:12.9517|KdrBDg|DANIEL|OAuth: /api/v3/search/workflow?_dc=1585738572841 t Transfer: 1220 : 12|11:56:12.9517|KdrBDg|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|11:56:12.9517|KdrBDg|DANIEL| OAuth authenticated t Transfer: 1220 : 12|11:56:12.9517|KdrBDg|DANIEL| user DANIEL. t Verbose: 1220 : 12|11:56:12.9517|KdrBDg|DANIEL|OAuth. User logged in: DANIEL t Information: 1220 : 12|11:56:12.9517|KdrBDg|DANIEL|V3Api.SearchWorkflows t Information: 1220 : 12|11:56:12.9517|KdrBDg|DANIEL|V3Api.SearchGeneric t Transfer: 1220 : 12|11:56:12.9517|KdrBDg|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|11:56:12.9517|KdrBDg|DANIEL| OAuth authenticated t Transfer: 1220 : 12|11:56:12.9517|KdrBDg|DANIEL| user DANIEL. t Information: 1220 : 12|11:56:12.9517|KdrBDg|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=109504 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|11:56:13.1548|KdrBDg|DANIEL| jobs returned 1, searched in 00:00:00.1390018 t Information: 1220 : 12|11:56:13.1548|KdrBDg|DANIEL| tasks returned 1, searched in 00:00:00.0269527 t Verbose: 1220 : 12|11:56:13.1548|KdrBDg|DANIEL|imfx v3 API took 0.180s '/api/v3/search/workflow?_dc=1585738572841' t Transfer: 1220 : 12|11:56:14.1704|oiyDhT|DANIEL|OAuth: /api/v3/search/workflow?_dc=1585738574029 t Transfer: 1220 : 12|11:56:14.1704|oiyDhT|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|11:56:14.1704|oiyDhT|DANIEL| OAuth authenticated t Transfer: 1220 : 12|11:56:14.1704|oiyDhT|DANIEL| user DANIEL. t Verbose: 1220 : 12|11:56:14.1704|oiyDhT|DANIEL|OAuth. User logged in: DANIEL t Information: 1220 : 12|11:56:14.1704|oiyDhT|DANIEL|V3Api.SearchWorkflows t Information: 1220 : 12|11:56:14.1704|oiyDhT|DANIEL|V3Api.SearchGeneric t Transfer: 1220 : 12|11:56:14.1704|oiyDhT|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|11:56:14.1704|oiyDhT|DANIEL| OAuth authenticated t Transfer: 1220 : 12|11:56:14.1704|oiyDhT|DANIEL| user DANIEL. t Information: 1220 : 12|11:56:14.1704|oiyDhT|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|11:56:14.1704|oiyDhT|DANIEL| jobs returned 4, searched in 00:00:00.0076637 t Information: 1220 : 12|11:56:14.1704|oiyDhT|DANIEL| tasks returned 4, searched in 00:00:00.0363451 t Verbose: 1220 : 12|11:56:14.1704|oiyDhT|DANIEL|imfx v3 API took 0.052s '/api/v3/search/workflow?_dc=1585738574029' t Transfer: 1220 : 12|11:56:14.3736|_YlpcS|DANIEL|OAuth: /api/user-preferences?_dc=1585738574170 t Transfer: 1220 : 12|11:56:14.3736|_YlpcS|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|11:56:14.3736|_YlpcS|DANIEL| OAuth authenticated t Transfer: 1220 : 12|11:56:14.3736|_YlpcS|DANIEL| user DANIEL. t Verbose: 1220 : 12|11:56:14.3736|_YlpcS|DANIEL|OAuth. User logged in: DANIEL t Verbose: 1220 : 12|11:56:14.3736|_YlpcS|DANIEL|StoreUserDataByKeys.. t Transfer: 1220 : 12|11:56:14.3736|_YlpcS|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|11:56:14.3736|_YlpcS|DANIEL| OAuth authenticated t Transfer: 1220 : 12|11:56:14.3736|_YlpcS|DANIEL| user DANIEL. t Verbose: 1220 : 12|11:56:14.3736|_YlpcS|DANIEL|imfx v3 API took 0.011s '/api/user-preferences?_dc=1585738574170' t Transfer: 1220 : 12|11:56:16.6079|DtZ1~0|DANIEL|OAuth: /api/v3/task/componentqc/109510?_dc=1585738576539 t Transfer: 1220 : 12|11:56:16.6079|DtZ1~0|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|11:56:16.6079|DtZ1~0|DANIEL| OAuth authenticated t Transfer: 1220 : 12|11:56:16.6079|DtZ1~0|DANIEL| user DANIEL. t Verbose: 1220 : 12|11:56:16.6079|DtZ1~0|DANIEL|OAuth. User logged in: DANIEL t Information: 1220 : 12|11:56:16.6079|DtZ1~0|DANIEL|V3Api. GetComponentQc task: 109510 t Information: 1220 : 12|11:56:18.0454|DtZ1~0|DANIEL|SubtitleQcTask. LoadFromDb got Job 109509 and Subtitles 2. t Information: 1220 : 12|11:56:18.0454|DtZ1~0|DANIEL|SubtitleQcTask. LoadFromDb processing Media 298919. t Information: 1220 : 12|11:56:18.0454|DtZ1~0|DANIEL|SubtitleQcTask. LoadFromDb processing Media 298927. t Information: 1220 : 12|11:56:18.0454|DtZ1~0|DANIEL|LoadSubtitlesById. filename PMH_s1ep1_pt1.scc device TimedText frame rate NTCS_DF t Information: 1220 : 12|11:56:18.0454|DtZ1~0|DANIEL|LoadSubtitlesById. Filename: PMH_s1ep1_pt1.scc. Device TimedText. Timecode format NTCS_DF. Media ID 0. t Information: 1220 : 12|11:56:18.0454|DtZ1~0|DANIEL|GetCaptions. Start. Filename: PMH_s1ep1_pt1.scc. Cache path C:\inetpub\wwwroot\imfxcore\timedtextcache\. Storage path \\192.168.120.254\DemoFS\Digital Assets\TimedText. Last Modified 1/1/0001 12:00:00 AM t Information: 1220 : 12|11:56:18.0454|DtZ1~0|DANIEL|GetCaptions. Convert required. Som 00:00:00. From: \\192.168.120.254\DemoFS\Digital Assets\TimedText\PMH_s1ep1_pt1.scc to: C:\inetpub\wwwroot\imfxcore\timedtextcache\PMH_s1ep1_pt1.scc_ntcs_df_0.xml t Information: 1220 : 12|11:56:18.0454|DtZ1~0|DANIEL|GetCaptions. Convertor lock aquired. t Information: 1220 : 12|11:56:18.0454|DtZ1~0|DANIEL|GetCaptions. File converted: \\192.168.120.254\DemoFS\Digital Assets\TimedText\PMH_s1ep1_pt1.scc. Result: True t Information: 1220 : 12|11:56:18.0454|DtZ1~0|DANIEL|GetCaptions. In cache. Filename: C:\inetpub\wwwroot\imfxcore\timedtextcache\PMH_s1ep1_pt1.scc_ntcs_df_0.xml t Information: 1220 : 12|11:56:18.0454|DtZ1~0|DANIEL|LoadSubtitlesById. Convertor lock acquired. t Information: 1220 : 12|11:56:18.0454|DtZ1~0|DANIEL|LoadSubtitlesById got 43 lines. t Information: 1220 : 12|11:56:18.0454|DtZ1~0|DANIEL|TM_MIS. LoadSubtitles for ID: 298919 t Information: 1220 : 12|11:56:18.0454|DtZ1~0|DANIEL|TM_MIS. LoadSubtitles for ID: 298919. SQL: 'select id, m_ctnr_id, m_ctnr_loc, modified_dt, tv_std, m_ctnr_fmt_id, nvl((select max(l.language) from tm_audio l where l.miid=m.id),aud_language_id) aud_language_id from tm_mis m where m.id in (298927)' t Information: 1220 : 12|11:56:18.0454|DtZ1~0|DANIEL| Subtitles added for ID: 298919, 298927 Unknown [0] : 'https://imfxv3tm.tmd.tv/getcaptions.aspx?f=PMH_s1ep1_pt1.scc&som=00:00:00:00&storage=TimedText&modified=637188427300000000&tcf=3&id=298927&tmp=0'. t Information: 1220 : 12|11:56:18.0454|DtZ1~0|DANIEL|SubtitleQcTask. LoadFromDb finished. t Verbose: 1220 : 12|11:56:18.0454|DtZ1~0|DANIEL|imfx v3 API took 1.359s '/api/v3/task/componentqc/109510?_dc=1585738576539' t Transfer: 1220 : 12|11:56:18.0454|DtZ1~0|DANIEL|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\PmH_Demo001.mp4 subfolder t Transfer: 1220 : 12|11:56:18.0454|DtZ1~0|DANIEL| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/PmH_Demo001.mp4 t Transfer: 1220 : 12|11:56:18.0454|DtZ1~0|DANIEL|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/PmH_Demo001.mp4 t Transfer: 1220 : 12|11:56:18.0454|DtZ1~0|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|11:56:18.0454|DtZ1~0|DANIEL| OAuth authenticated t Transfer: 1220 : 12|11:56:18.0454|DtZ1~0|DANIEL| user DANIEL. t Transfer: 1220 : 12|11:56:18.0454|Ujj0TL|DANIEL|OAuth: /api/v3/detailsview/Job/0?lang=en-GB&_dc=1585738577948 t Transfer: 1220 : 12|11:56:18.0454|Ujj0TL|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|11:56:18.0454|Ujj0TL|DANIEL| OAuth authenticated t Transfer: 1220 : 12|11:56:18.0454|Ujj0TL|DANIEL| user DANIEL. t Verbose: 1220 : 12|11:56:18.0454|Ujj0TL|DANIEL|OAuth. User logged in: DANIEL t Verbose: 1220 : 12|11:56:18.0454|Ujj0TL|DANIEL|imfx v3 API took 0.005s '/api/v3/detailsview/Job/0?lang=en-GB&_dc=1585738577948' t Transfer: 1220 : 12|11:56:18.0454|5hO8Pw|DANIEL|OAuth: /api/v3/layout/default/10?_dc=1585738577990 t Transfer: 1220 : 12|11:56:18.0454|5hO8Pw|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|11:56:18.0454|5hO8Pw|DANIEL| OAuth authenticated t Transfer: 1220 : 12|11:56:18.0454|5hO8Pw|DANIEL| user DANIEL. t Verbose: 1220 : 12|11:56:18.0454|5hO8Pw|DANIEL|OAuth. User logged in: DANIEL t Information: 1220 : 12|11:56:18.0454|5hO8Pw|DANIEL|LoadDefaultDashboard. t Transfer: 1220 : 12|11:56:18.0454|5hO8Pw|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|11:56:18.0454|5hO8Pw|DANIEL| OAuth authenticated t Transfer: 1220 : 12|11:56:18.0454|5hO8Pw|DANIEL| user DANIEL. t Verbose: 1220 : 12|11:56:18.0454|5hO8Pw|DANIEL|imfx v3 API took 0.006s '/api/v3/layout/default/10?_dc=1585738577990' t Transfer: 1220 : 12|11:56:18.4673|EwVHqi|DANIEL|OAuth: /api/user-group-preferences?globals=htmlplayerhotkeys,audioOnFrameForward&_dc=1585738578407 t Transfer: 1220 : 12|11:56:18.4673|EwVHqi|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|11:56:18.4673|EwVHqi|DANIEL| OAuth authenticated t Transfer: 1220 : 12|11:56:18.4673|EwVHqi|DANIEL| user DANIEL. t Verbose: 1220 : 12|11:56:18.4673|EwVHqi|DANIEL|OAuth. User logged in: DANIEL t Transfer: 1220 : 12|11:56:18.4673|EwVHqi|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|11:56:18.4673|EwVHqi|DANIEL| OAuth authenticated t Transfer: 1220 : 12|11:56:18.4673|EwVHqi|DANIEL| user DANIEL. t Verbose: 1220 : 12|11:56:18.4673|EwVHqi|DANIEL|imfx v3 API took 0.004s '/api/user-group-preferences?globals=htmlplayerhotkeys,audioOnFrameForward&_dc=1585738578407' t Transfer: 1220 : 12|11:56:18.6705|KF3n_D|DANIEL|OAuth: /api/v3/mediavideo/298919?info=smudge&_dc=1585738578435 t Transfer: 1220 : 12|11:56:18.6705|KF3n_D|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|11:56:18.6705|KF3n_D|DANIEL| OAuth authenticated t Transfer: 1220 : 12|11:56:18.6705|KF3n_D|DANIEL| user DANIEL. t Verbose: 1220 : 12|11:56:18.6705|KF3n_D|DANIEL|OAuth. User logged in: DANIEL t Transfer: 1220 : 12|11:56:18.6705|KF3n_D|DANIEL|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\PmH_Demo001.mp4 subfolder t Transfer: 1220 : 12|11:56:18.6705|KF3n_D|DANIEL| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/PmH_Demo001.mp4 t Transfer: 1220 : 12|11:56:18.6705|KF3n_D|DANIEL|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/PmH_Demo001.mp4 t Transfer: 1220 : 12|11:56:18.6705|KF3n_D|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|11:56:18.6705|KF3n_D|DANIEL| OAuth authenticated t Transfer: 1220 : 12|11:56:18.6705|KF3n_D|DANIEL| user DANIEL. t Verbose: 1220 : 12|11:56:18.6705|KF3n_D|DANIEL|imfx v3 API took 0.019s '/api/v3/mediavideo/298919?info=smudge&_dc=1585738578435' t Information: 1220 : 12|11:56:18.6705|89Fy4F||GetCaptionsForWeb. Filename: PMH_s1ep1_pt1.scc. Device TimedText. Format WebVTT. Timecode format FPS24. Media ID 298927. Last Modified 3/3/2020 2:32:10 PM t Information: 1220 : 12|11:56:18.6705|89Fy4F||GetCaptions. Start. Filename: PMH_s1ep1_pt1.scc. Cache path C:\inetpub\wwwroot\imfxcore\timedtextcache\. Storage path \\192.168.120.254\DemoFS\Digital Assets\TimedText. Last Modified 3/3/2020 2:32:10 PM t Information: 1220 : 12|11:56:18.6705|89Fy4F||GetCaptions. No refresh needed. Filename: C:\inetpub\wwwroot\imfxcore\timedtextcache\PMH_s1ep1_pt1.scc_fps24_298927.vtt t Information: 1220 : 12|11:56:18.6705|89Fy4F||GetCaptions. In cache. Filename: C:\inetpub\wwwroot\imfxcore\timedtextcache\PMH_s1ep1_pt1.scc_fps24_298927.vtt t Transfer: 1220 : 12|11:56:31.0610|~JdriV|DANIEL|OAuth: /api/v3/search/workflow?_dc=1585738590847 t Transfer: 1220 : 12|11:56:31.0610|~JdriV|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|11:56:31.0610|~JdriV|DANIEL| OAuth authenticated t Transfer: 1220 : 12|11:56:31.0610|~JdriV|DANIEL| user DANIEL. t Verbose: 1220 : 12|11:56:31.0610|~JdriV|DANIEL|OAuth. User logged in: DANIEL t Information: 1220 : 12|11:56:31.0610|~JdriV|DANIEL|V3Api.SearchWorkflows t Information: 1220 : 12|11:56:31.0610|~JdriV|DANIEL|V3Api.SearchGeneric t Transfer: 1220 : 12|11:56:31.0610|~JdriV|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|11:56:31.0610|~JdriV|DANIEL| OAuth authenticated t Transfer: 1220 : 12|11:56:31.0610|~JdriV|DANIEL| user DANIEL. t Information: 1220 : 12|11:56:31.0610|~JdriV|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=109509 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|11:56:31.2642|~JdriV|DANIEL| jobs returned 1, searched in 00:00:00.1580066 t Information: 1220 : 12|11:56:31.2642|~JdriV|DANIEL| tasks returned 1, searched in 00:00:00.0242558 t Verbose: 1220 : 12|11:56:31.2642|~JdriV|DANIEL|imfx v3 API took 0.195s '/api/v3/search/workflow?_dc=1585738590847' t Transfer: 1220 : 12|11:56:39.3892|yoFd70|DANIEL|OAuth: /api/v3/task/componentqc/109510?_dc=1585738599243 t Transfer: 1220 : 12|11:56:39.3892|yoFd70|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|11:56:39.3892|yoFd70|DANIEL| OAuth authenticated t Transfer: 1220 : 12|11:56:39.3892|yoFd70|DANIEL| user DANIEL. t Verbose: 1220 : 12|11:56:39.3892|yoFd70|DANIEL|OAuth. User logged in: DANIEL t Information: 1220 : 12|11:56:39.3892|yoFd70|DANIEL|V3Api. GetComponentQc task: 109510 t Information: 1220 : 12|11:56:39.3892|yoFd70|DANIEL|SubtitleQcTask. LoadFromDb got Job 109509 and Subtitles 2. t Information: 1220 : 12|11:56:39.3892|yoFd70|DANIEL|SubtitleQcTask. LoadFromDb processing Media 298919. t Information: 1220 : 12|11:56:39.3892|yoFd70|DANIEL|SubtitleQcTask. LoadFromDb processing Media 298927. t Information: 1220 : 12|11:56:39.3892|yoFd70|DANIEL|LoadSubtitlesById. filename PMH_s1ep1_pt1.scc device TimedText frame rate NTCS_DF t Information: 1220 : 12|11:56:39.3892|yoFd70|DANIEL|LoadSubtitlesById. Filename: PMH_s1ep1_pt1.scc. Device TimedText. Timecode format NTCS_DF. Media ID 0. t Information: 1220 : 12|11:56:39.3892|yoFd70|DANIEL|GetCaptions. Start. Filename: PMH_s1ep1_pt1.scc. Cache path C:\inetpub\wwwroot\imfxcore\timedtextcache\. Storage path \\192.168.120.254\DemoFS\Digital Assets\TimedText. Last Modified 1/1/0001 12:00:00 AM t Information: 1220 : 12|11:56:39.3892|yoFd70|DANIEL|GetCaptions. Convert required. Som 00:00:00. From: \\192.168.120.254\DemoFS\Digital Assets\TimedText\PMH_s1ep1_pt1.scc to: C:\inetpub\wwwroot\imfxcore\timedtextcache\PMH_s1ep1_pt1.scc_ntcs_df_0.xml t Information: 1220 : 12|11:56:39.3892|yoFd70|DANIEL|GetCaptions. Convertor lock aquired. t Information: 1220 : 12|11:56:39.3892|yoFd70|DANIEL|GetCaptions. File converted: \\192.168.120.254\DemoFS\Digital Assets\TimedText\PMH_s1ep1_pt1.scc. Result: True t Information: 1220 : 12|11:56:39.3892|yoFd70|DANIEL|GetCaptions. In cache. Filename: C:\inetpub\wwwroot\imfxcore\timedtextcache\PMH_s1ep1_pt1.scc_ntcs_df_0.xml t Information: 1220 : 12|11:56:39.3892|yoFd70|DANIEL|LoadSubtitlesById. Convertor lock acquired. t Information: 1220 : 12|11:56:39.5923|yoFd70|DANIEL|LoadSubtitlesById got 43 lines. t Information: 1220 : 12|11:56:39.5923|yoFd70|DANIEL|TM_MIS. LoadSubtitles for ID: 298919 t Information: 1220 : 12|11:56:39.5923|yoFd70|DANIEL|TM_MIS. LoadSubtitles for ID: 298919. SQL: 'select id, m_ctnr_id, m_ctnr_loc, modified_dt, tv_std, m_ctnr_fmt_id, nvl((select max(l.language) from tm_audio l where l.miid=m.id),aud_language_id) aud_language_id from tm_mis m where m.id in (298927)' t Information: 1220 : 12|11:56:39.5923|yoFd70|DANIEL| Subtitles added for ID: 298919, 298927 Unknown [0] : 'https://imfxv3tm.tmd.tv/getcaptions.aspx?f=PMH_s1ep1_pt1.scc&som=00:00:00:00&storage=TimedText&modified=637188427300000000&tcf=3&id=298927&tmp=0'. t Information: 1220 : 12|11:56:39.5923|yoFd70|DANIEL|SubtitleQcTask. LoadFromDb finished. t Verbose: 1220 : 12|11:56:39.5923|yoFd70|DANIEL|imfx v3 API took 0.129s '/api/v3/task/componentqc/109510?_dc=1585738599243' t Transfer: 1220 : 12|11:56:39.5923|yoFd70|DANIEL|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\PmH_Demo001.mp4 subfolder t Transfer: 1220 : 12|11:56:39.5923|yoFd70|DANIEL| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/PmH_Demo001.mp4 t Transfer: 1220 : 12|11:56:39.5923|yoFd70|DANIEL|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/PmH_Demo001.mp4 t Transfer: 1220 : 12|11:56:39.5923|yoFd70|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|11:56:39.5923|yoFd70|DANIEL| OAuth authenticated t Transfer: 1220 : 12|11:56:39.5923|yoFd70|DANIEL| user DANIEL. t Transfer: 1220 : 12|11:56:39.5923|5R8qah|DANIEL|OAuth: /api/v3/detailsview/Job/0?lang=en-GB&_dc=1585738599427 t Transfer: 1220 : 12|11:56:39.5923|5R8qah|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|11:56:39.5923|5R8qah|DANIEL| OAuth authenticated t Transfer: 1220 : 12|11:56:39.5923|5R8qah|DANIEL| user DANIEL. t Verbose: 1220 : 12|11:56:39.5923|5R8qah|DANIEL|OAuth. User logged in: DANIEL t Verbose: 1220 : 12|11:56:39.5923|5R8qah|DANIEL|imfx v3 API took 0.004s '/api/v3/detailsview/Job/0?lang=en-GB&_dc=1585738599427' t Transfer: 1220 : 12|11:56:39.5923|xx2ril|DANIEL|OAuth: /api/v3/layout/default/10?_dc=1585738599476 t Transfer: 1220 : 12|11:56:39.5923|xx2ril|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|11:56:39.5923|xx2ril|DANIEL| OAuth authenticated t Transfer: 1220 : 12|11:56:39.5923|xx2ril|DANIEL| user DANIEL. t Verbose: 1220 : 12|11:56:39.5923|xx2ril|DANIEL|OAuth. User logged in: DANIEL t Information: 1220 : 12|11:56:39.5923|xx2ril|DANIEL|LoadDefaultDashboard. t Transfer: 1220 : 12|11:56:39.5923|xx2ril|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|11:56:39.5923|xx2ril|DANIEL| OAuth authenticated t Transfer: 1220 : 12|11:56:39.5923|xx2ril|DANIEL| user DANIEL. t Verbose: 1220 : 12|11:56:39.5923|xx2ril|DANIEL|imfx v3 API took 0.004s '/api/v3/layout/default/10?_dc=1585738599476' t Transfer: 1220 : 12|11:56:39.9986|xg9WsK|DANIEL|OAuth: /api/user-group-preferences?globals=htmlplayerhotkeys,audioOnFrameForward&_dc=1585738599852 t Transfer: 1220 : 12|11:56:39.9986|xg9WsK|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|11:56:39.9986|xg9WsK|DANIEL| OAuth authenticated t Transfer: 1220 : 12|11:56:39.9986|xg9WsK|DANIEL| user DANIEL. t Verbose: 1220 : 12|11:56:39.9986|xg9WsK|DANIEL|OAuth. User logged in: DANIEL t Transfer: 1220 : 12|11:56:39.9986|xg9WsK|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|11:56:39.9986|xg9WsK|DANIEL| OAuth authenticated t Transfer: 1220 : 12|11:56:39.9986|xg9WsK|DANIEL| user DANIEL. t Verbose: 1220 : 12|11:56:39.9986|xg9WsK|DANIEL|imfx v3 API took 0.003s '/api/user-group-preferences?globals=htmlplayerhotkeys,audioOnFrameForward&_dc=1585738599852' t Transfer: 1220 : 12|11:56:39.9986|68d996|DANIEL|OAuth: /api/v3/mediavideo/298919?info=smudge&_dc=1585738599878 t Transfer: 1220 : 12|11:56:39.9986|68d996|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|11:56:39.9986|68d996|DANIEL| OAuth authenticated t Transfer: 1220 : 12|11:56:39.9986|68d996|DANIEL| user DANIEL. t Verbose: 1220 : 12|11:56:39.9986|68d996|DANIEL|OAuth. User logged in: DANIEL t Transfer: 1220 : 12|11:56:39.9986|68d996|DANIEL|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\PmH_Demo001.mp4 subfolder t Transfer: 1220 : 12|11:56:39.9986|68d996|DANIEL| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/PmH_Demo001.mp4 t Transfer: 1220 : 12|11:56:39.9986|68d996|DANIEL|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/PmH_Demo001.mp4 t Transfer: 1220 : 12|11:56:39.9986|68d996|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|11:56:39.9986|68d996|DANIEL| OAuth authenticated t Transfer: 1220 : 12|11:56:39.9986|68d996|DANIEL| user DANIEL. t Verbose: 1220 : 12|11:56:39.9986|68d996|DANIEL|imfx v3 API took 0.010s '/api/v3/mediavideo/298919?info=smudge&_dc=1585738599878' t Information: 1220 : 12|11:56:40.2017|JOD0J2||GetCaptionsForWeb. Filename: PMH_s1ep1_pt1.scc. Device TimedText. Format WebVTT. Timecode format FPS24. Media ID 298927. Last Modified 3/3/2020 2:32:10 PM t Information: 1220 : 12|11:56:40.2017|JOD0J2||GetCaptions. Start. Filename: PMH_s1ep1_pt1.scc. Cache path C:\inetpub\wwwroot\imfxcore\timedtextcache\. Storage path \\192.168.120.254\DemoFS\Digital Assets\TimedText. Last Modified 3/3/2020 2:32:10 PM t Information: 1220 : 12|11:56:40.2017|JOD0J2||GetCaptions. No refresh needed. Filename: C:\inetpub\wwwroot\imfxcore\timedtextcache\PMH_s1ep1_pt1.scc_fps24_298927.vtt t Information: 1220 : 12|11:56:40.2017|JOD0J2||GetCaptions. In cache. Filename: C:\inetpub\wwwroot\imfxcore\timedtextcache\PMH_s1ep1_pt1.scc_fps24_298927.vtt t Transfer: 1220 : 12|11:56:52.5923|Th83i9|DANIEL|OAuth: /api/v3/search/workflow?_dc=1585738612388 t Transfer: 1220 : 12|11:56:52.5923|Th83i9|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|11:56:52.5923|Th83i9|DANIEL| OAuth authenticated t Transfer: 1220 : 12|11:56:52.5923|Th83i9|DANIEL| user DANIEL. t Verbose: 1220 : 12|11:56:52.5923|Th83i9|DANIEL|OAuth. User logged in: DANIEL t Information: 1220 : 12|11:56:52.5923|Th83i9|DANIEL|V3Api.SearchWorkflows t Information: 1220 : 12|11:56:52.5923|Th83i9|DANIEL|V3Api.SearchGeneric t Transfer: 1220 : 12|11:56:52.5923|Th83i9|DANIEL|GetCurrentUser.. t Transfer: 1220 : 12|11:56:52.5923|Th83i9|DANIEL| OAuth authenticated t Transfer: 1220 : 12|11:56:52.5923|Th83i9|DANIEL| user DANIEL. t Information: 1220 : 12|11:56:52.5923|Th83i9|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=109509 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|11:56:52.5923|Th83i9|DANIEL| jobs returned 1, searched in 00:00:00.0052343 t Information: 1220 : 12|11:56:52.5923|Th83i9|DANIEL| tasks returned 1, searched in 00:00:00.0106111 t Verbose: 1220 : 12|11:56:52.5923|Th83i9|DANIEL|imfx v3 API took 0.021s '/api/v3/search/workflow?_dc=1585738612388' t Information: 1220 : 12|11:57:09.2642|||OrabitWatcherBasic. Disposing. t Information: 1220 : 12|11:57:09.2642|||OrabitWatcherBasic. Disposed. t Information: 1220 : 12|11:57:09.2642|||========================================================================== t Information: 1220 : 12|11:57:09.2642|||IMFX CORE SERVER APPLICATION END.