t Information: 1220 : 10|16:21:06.1898|||Get Configuration Values: t Information: 1220 : 10|16:21:06.1898||| AdminPassEnc, default: , value: ffqjrn0leKv4Lj2YJHe2dw==. t Information: 1220 : 10|16:21:06.1898||| EncryptedPasswords, default: false, value: true. t Information: 1220 : 10|16:21:06.1898||| OraConnectionString, default: , value: Server=TECHM;User Id=imfx;Password=xxxxx;Unicode=true;. t Information: 1220 : 10|16:21:06.1898||| SecondTimezone, default: , value: . t Information: 1220 : 10|16:21:06.1898||| UseActiveDirectoryAuth, default: false, value: false. t Information: 1220 : 10|16:21:06.1898||| ReportingServiceUrl, default: , value: http://localhost:92/ReportingService.svc. t Information: 1220 : 10|16:21:06.1898||| ReportsPath, default: , value: . t Information: 1220 : 10|16:21:06.1898||| ReportsURL, default: , value: . t Information: 1220 : 10|16:21:06.1898||| TapeServiceUrl, default: , value: . t Information: 1220 : 10|16:21:06.1898||| GatekeeperUrl, default: , value: . t Information: 1220 : 10|16:21:06.1898||| ValuationUrl, default: , value: . t Information: 1220 : 10|16:21:06.1898||| QueueManagerDelay, default: 30, value: 30. t Information: 1220 : 10|16:21:06.1898||| QueueManagerFullRefresh, default: 90, value: 90. t Information: 1220 : 10|16:21:06.1898||| AudioLoopDuration, default: 0, value: 150. t Information: 1220 : 10|16:21:06.1898||| AudioLoopsCount, default: 0, value: 0. t Information: 1220 : 10|16:21:06.1898||| PlayerFakeStep, default: 500, value: 500. t Information: 1220 : 10|16:21:06.1898||| PlayerForceRatio, default: 0, value: 1. t Information: 1220 : 10|16:21:06.1898||| CheckVersionsInProd, default: false, value: True. t Information: 1220 : 10|16:21:06.1898||| MaxResults, default: 3000, value: 10000. t Information: 1220 : 10|16:21:06.1898||| TEReportID, default: 0, value: 0. t Information: 1220 : 10|16:21:06.1898||| ClosedCaptionsCache, default: , value: C:\inetpub\wwwroot\imfxcore\timedtextcache\. t Information: 1220 : 10|16:21:06.1898||| ClosedCaptionsStorage, default: , value: c:\Mediaflex\subs. t Information: 1220 : 10|16:21:06.2054||| TimeCodeFormat, default: , value: pal. t Information: 1220 : 10|16:21:06.2054||| RceMediaPath, default: , value: C:\edl\. t Information: 1220 : 10|16:21:06.2054||| RceMediaPath, default: , value: C:\edl\. t Information: 1220 : 10|16:21:06.2054||| RceCsmOutputPath, default: , value: C:\Inetpub\wwwroot\csm\. t Information: 1220 : 10|16:21:06.2054||| RceCsmUrl, default: , value: http://localhost/csm/. t Information: 1220 : 10|16:21:06.2054||| RceMediaSelection, default: , value: miLinkIdMatch. t Information: 1220 : 10|16:21:06.2054||| RequestBrowseJobPresetName, default: , value: . t Information: 1220 : 10|16:21:06.2054||| DontExtendDuration, default: false, value: False. t Information: 1220 : 10|16:21:06.2054||| V3ConfigUrl, default: , value: . t Information: 1220 : 10|16:21:06.2054||| StopWords, default: , value: . t Information: 1220 : 10|16:21:06.2054||| MisrTxFormat, default: G, value: G. t Information: 1220 : 10|16:21:06.2054||| ApiServer, default: , value: http://192.168.120.10:85. t Information: 1220 : 10|16:21:06.2054||| ApiTimeout, default: 120, value: 120. t Information: 1220 : 10|16:21:06.2054||| ApiWorkers, default: 10, value: 10. t Information: 1220 : 10|16:21:06.2054||| UsePerfCounters, default: false, value: false. t Information: 1220 : 10|16:21:06.2054||| LogGetCurrentUser, default: true, value: true. t Information: 1220 : 10|16:21:06.2054||| LogInternalApi, default: true, value: true. t Information: 1220 : 10|16:21:06.2054||| ThumbnailServer, default: , value: . t Information: 1220 : 10|16:21:06.2054||| LocationFilter, default: , value: . t Information: 1220 : 10|16:21:06.2054||| SvUtilServiceUrl, default: , value: . t Information: 1220 : 10|16:21:06.2054||| SolrConnection, default: , value: http://192.168.120.14:8983/solr. t Information: 1220 : 10|16:21:06.2054||| UseIndexServerSearch, default: false, value: True. t Information: 1220 : 10|16:21:06.2054||| SolrIndexVersion, default: 1, value: 6. t Information: 1220 : 10|16:21:06.2054||| SolrConnection, default: , value: http://192.168.120.14:8983/solr. t Information: 1220 : 10|16:21:06.2054||| FacetsGroups, default: , value: owners,season_id, series_id,version_key,item_type,media_type,media_format,episode_number. t Information: 1220 : 10|16:21:06.2054||| FacetsGroupsVersion, default: , value: owners,season_id, series_id,version_key,episode_number. t Information: 1220 : 10|16:21:06.2054||| FacetsGroupsChameleon, default: , value: season_id, series_id,genre,prod_year,version_key. t Information: 1220 : 10|16:21:06.2054||| PreviewPreset, default: , value: . t Information: 1220 : 10|16:21:06.2054||| DevMode, default: false, value: false. t Information: 1220 : 10|16:21:06.2054||| DisableSysMan, default: false, value: false. t Information: 1220 : 10|16:21:06.2054||| TimeCodeFormat, default: , value: pal. t Information: 1220 : 10|16:21:06.2054||| FileCatalystStorageDevice, default: , value: . t Information: 1220 : 10|16:21:06.2054||| UseResponsibilityTracking, default: true, value: True. t Information: 1220 : 10|16:21:06.2054||| SubtitleDeviceFilter, default: , value: . t Information: 1220 : 10|16:21:06.2054||| SystemMonitorNamedPipe, default: , value: . t Information: 1220 : 10|16:21:06.2054||| OracleMonitorEnable, default: false, value: False. t Information: 1220 : 10|16:21:06.2054||| ArcApiHost, default: , value: . t Information: 1220 : 10|16:21:06.2054||| RabbitMqUrl, default: , value: amqp://192.168.120.14:5672. t Information: 1220 : 10|16:21:06.2054||| SolrTimedTextSearch, default: false, value: false. t Information: 1220 : 10|16:21:06.2054||| ProductionDurationUsageID, default: 1, value: 1. t Information: 1220 : 10|16:21:06.4241|||GetStreamServers.. t Information: 1220 : 10|16:21:06.8304||| https://demo.tmd.tv/CBR Video/ |CBR Video| False t Information: 1220 : 10|16:21:06.8304||| https://demo.tmd.tv/CBR Images/ |CBR Images| False t Information: 1220 : 10|16:21:06.8304||| https://demo.tmd.tv/CBR Audio/ |CBR Audio| False t Information: 1220 : 10|16:21:06.8304||| https://demo.tmd.tv/Temp Upload/ |TEMP_UPLOAD| False t Information: 1220 : 10|16:21:06.8304||| http://localhost:82/images/ |IMAGES| False t Information: 1220 : 10|16:21:06.8304||| http://192.168.91.73/smoothcloud/ |SMOOTH_CLOUD| False t Information: 1220 : 10|16:21:06.8304||| http://192.168.91.73/cloudstore/ |CLOUD_STORE| False t Information: 1220 : 10|16:21:06.8304||| http://192.168.91.73/editsystemin/ |EDIT_SYSTEM_IN| False t Information: 1220 : 10|16:21:06.8304||| http://192.168.91.27:89/APPLEPROXY/ |APPLE_PROXY| False t Information: 1220 : 10|16:21:06.8304||| http://localhost:82/video/ |FILESTORE_VIDEO| False t Information: 1220 : 10|16:21:06.8304||| https://imfxv3tm.tmd.tv/streaming/ |Streaming| False t Information: 1220 : 10|16:21:06.8304||| https://imfxv3tm.tmd.tv/VideoServer/ |Video| False t Information: 1220 : 10|16:21:06.8304||| https://imfxv3tm.tmd.tv/AdobeIn/ |Adobe Premiere Pro In| False t Information: 1220 : 10|16:21:06.8304||| https://imfxv3tm.tmd.tv/AudioServer/ |Audio| False t Information: 1220 : 10|16:21:06.8304||| https://imfxv3tm.tmd.tv/ImageServer/ |Image| False t Information: 1220 : 10|16:21:06.8304||| https://imfxv3tm.tmd.tv/DocsServer/ |Docs| False t Information: 1220 : 10|16:21:06.8304||| https://imfxv3tm.tmd.tv/AmazonLabs/ |TEST HOUSE| False t Information: 1220 : 10|16:21:06.8304||| SolrConnectionUms, default: http://192.168.120.14:8983/solr, value: http://192.168.120.14:8983/solr. t Information: 1220 : 10|16:21:06.8304||| LogWebApi, default: false, value: false. t Information: 1220 : 10|16:21:06.8304||| EmbeddedRceUrl, default: , value: . t Information: 1220 : 10|16:21:06.8304||| InstallMode, default: , value: . t Information: 1220 : 10|16:21:06.8304||| SamlRequestAddress, default: , value: . t Information: 1220 : 10|16:21:06.8304||| SamlTrustedIssuer, default: , value: . t Information: 1220 : 10|16:21:06.8304||| SamlLoginRedirect, default: , value: . t Information: 1220 : 10|16:21:06.8304||| NaturalLangSearch, default: false, value: True. t Information: 1220 : 10|16:21:06.8304||| LocalUploadExpirationHours, default: 0, value: 0. t Information: 1220 : 10|16:21:06.8304||| OktaLoginField, default: , value: . t Information: 1220 : 10|16:21:06.8304||| AuthenticationTypes, default: , value: Native,PublicApiKey. t Information: 1220 : 10|16:21:06.8304|||OrabitWatcherBasic. Initialize. t Information: 1220 : 10|16:21:06.8304|||FillDictionaryCache. t Information: 1220 : 10|16:21:10.3929|||GetSupportedOperators t Information: 1220 : 10|16:21:10.5960|||CacheTechReports. t Information: 1220 : 10|16:21:10.7991|||& Cache update. Server (global) filled with timestamp 04:06:10.6585816. types null t Information: 1220 : 10|16:21:10.7991|||InitializeFromDatabase. 'Server=TECHM;User Id=imfx;password=..;Unicode=true;' direct False, home , timeout 15 t Information: 1220 : 10|16:21:10.7991|||FillDictionaryCache. t Information: 1220 : 10|16:21:10.7991|||& Cache update. Server (global) filled with timestamp 04:06:10.6741889. types FriendlyNames, DatabaseSearchFieldData t Information: 1220 : 10|16:21:11.4085|||========================================================================== t Information: 1220 : 10|16:21:11.4085|||IMFX CORE SERVER APPLICATION START. t Information: 1220 : 10|16:21:11.4085|||DLL VERSION: 2.5.0.2752. t Information: 1220 : 10|16:21:11.4085|||IS TIMER HIGH RESOULTION : True. t Information: 1220 : 10|16:21:11.4085||| UmsDev, default: False, value: False. t Information: 1220 : 10|16:21:11.8148|||OrabitWatcherBasic trying to connect.. t Information: 1220 : 10|16:21:11.8148|||OrabitWatcherBasic connected. t Information: 1220 : 10|16:21:11.8148|||OrabitWatcherBasic queue created tmd.cfg.in.e605e91b-8988-4133-b280-36c972a6932b t Transfer: 1220 : 10|16:21:16.9085|OAA88t||GetAppInfo. DB: TMDDEMO. Install mode: . Auth types: Native, PublicApiKey t Information: 1220 : 10|16:21:17.1116|6iA8bF||GetCache. t Information: 1220 : 10|16:21:17.1116|6iA8bF||GetCache. Found: C:\inetpub\wwwroot\imfxcore\VisualAssetsCache\4_2_M6I_N7.png t Information: 1220 : 10|16:21:17.1116|6iA8bF||GetCache. Data read: 461845 t Verbose: 1220 : 10|16:21:17.1116|6iA8bF||imfx v3 API took 0.034s '/api/v3/visual-asset/group/M6I_N7/2/image' t Verbose: 1220 : 10|16:21:18.9398|eCYSoh||Oauth validating.. t Verbose: 1220 : 10|16:21:18.9398|eCYSoh||GrantResourceOwnerCredentials. t Verbose: 1220 : 10|16:21:18.9398|eCYSoh||LoginUser. tmddba, login type OAuth, encrypt password True t Information: 1220 : 10|16:21:18.9398|eCYSoh||TryLoginUser. tmddba, login type OAuth, check password True, check hash False, encrypt password True, load user data False t Information: 1220 : 10|16:21:19.1429|eCYSoh|| oauth token 00000000-0000-0000-0000-000000000000 t Information: 1220 : 10|16:21:19.1429|eCYSoh||TryLoginUser. Logged in.. t Information: 1220 : 10|16:21:19.1429|eCYSoh||GetPasswordPolicy. WARNING: Policy not found for system Imediaflex. Validation disabled. t Verbose: 1220 : 10|16:21:19.1429|eCYSoh||LoginUser. Adding history. User Id 1, result TMDDBA, host 192.168.127.7 t Verbose: 1220 : 10|16:21:19.1429|eCYSoh||GrantResourceOwnerCredentials. Try login finished. Logged: True t Transfer: 1220 : 10|16:21:19.1429|qfxoRn|TMDDBA|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,helpdeskUrl&globals=isDebugMode,htmlplayerhotkeys,versionCreationSettings,associate.advanced_search.version.setups,associate.advanced_search.media.setups,associate.wfrise.setups,supplier_portal.advanced_search.version.setups,helpdeskUrl&_dc=1591629678795 t Transfer: 1220 : 10|16:21:19.1429|qfxoRn|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:21:19.1429|qfxoRn|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:21:19.1429|qfxoRn|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:21:19.1429|qfxoRn|TMDDBA|OAuth. User logged in: TMDDBA t Transfer: 1220 : 10|16:21:19.1429|qfxoRn|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:21:19.1429|qfxoRn|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:21:19.1429|qfxoRn|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:21:19.3460|qfxoRn|TMDDBA|imfx v3 API took 0.030s '/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,helpdeskUrl&globals=isDebugMode,htmlplayerhotkeys,versionCreationSettings,associate.advanced_search.version.setups,associate.advanced_search.media.setups,associate.wfrise.setups,supplier_portal.advanced_search.version.setups,helpdeskUrl&_dc=1591629678795' t Transfer: 1220 : 10|16:21:19.3460|I8t5~R|TMDDBA|OAuth: /api/user-preferences?keys=personal_settings;basket;default_page;color_schema;media.basket.data;defaultSearch&_dc=1591629678889 t Transfer: 1220 : 10|16:21:19.3460|I8t5~R|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:21:19.3460|I8t5~R|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:21:19.3460|I8t5~R|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:21:19.3460|I8t5~R|TMDDBA|OAuth. User logged in: TMDDBA t Information: 1220 : 10|16:21:19.3460|I8t5~R|TMDDBA|GetUserDataByKeys: personal_settings;basket;default_page;color_schema;media.basket.data;defaultSearch t Transfer: 1220 : 10|16:21:19.3460|I8t5~R|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:21:19.3460|I8t5~R|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:21:19.3460|I8t5~R|TMDDBA| user TMDDBA. t Transfer: 1220 : 10|16:21:19.3460|DKnyP0|TMDDBA|OAuth: /api/lookups/MediaStatus?_dc=1591629678892 t Transfer: 1220 : 10|16:21:19.3460|DKnyP0|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:21:19.3460|DKnyP0|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:21:19.3460|DKnyP0|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:21:19.3460|DKnyP0|TMDDBA|OAuth. User logged in: TMDDBA t Transfer: 1220 : 10|16:21:19.3460|yi7R9X|TMDDBA|OAuth: /api/lookups/PgmStatus?_dc=1591629678895 t Transfer: 1220 : 10|16:21:19.3460|yi7R9X|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:21:19.3460|yi7R9X|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:21:19.3460|yi7R9X|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:21:19.3460|yi7R9X|TMDDBA|OAuth. User logged in: TMDDBA t Verbose: 1220 : 10|16:21:19.3460|I8t5~R|TMDDBA|imfx v3 API took 0.019s '/api/user-preferences?keys=personal_settings;basket;default_page;color_schema;media.basket.data;defaultSearch&_dc=1591629678889' t Verbose: 1220 : 10|16:21:19.3460|yi7R9X|TMDDBA|imfx v3 API took 0.014s '/api/lookups/PgmStatus?_dc=1591629678895' t Verbose: 1220 : 10|16:21:19.3460|DKnyP0|TMDDBA|imfx v3 API took 0.015s '/api/lookups/MediaStatus?_dc=1591629678892' t Information: 1220 : 10|16:21:19.3460|CmekvO|TMDDBA|GetUserProfile. Id: 0 t Transfer: 1220 : 10|16:21:19.3460|CmekvO|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:21:19.3460|CmekvO|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:21:19.3460|CmekvO|TMDDBA| user TMDDBA. t Transfer: 1220 : 10|16:21:19.5491|5wNUJT|TMDDBA|OAuth: /api/settings/user/uploadSettings?_dc=1591629679096 t Transfer: 1220 : 10|16:21:19.5491|5wNUJT|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:21:19.5491|5wNUJT|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:21:19.5491|5wNUJT|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:21:19.5491|5wNUJT|TMDDBA|OAuth. User logged in: TMDDBA t Transfer: 1220 : 10|16:21:19.5491|5wNUJT|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:21:19.5491|5wNUJT|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:21:19.5491|5wNUJT|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:21:19.5491|5wNUJT|TMDDBA|imfx v3 API took 0.009s '/api/settings/user/uploadSettings?_dc=1591629679096' t Information: 1220 : 10|16:21:19.5491|w_t8W8||GetCache. t Information: 1220 : 10|16:21:19.5491|w_t8W8||GetCache. Found: C:\inetpub\wwwroot\imfxcore\VisualAssetsCache\1_0_M6I_N7.png t Information: 1220 : 10|16:21:19.5491|w_t8W8||GetCache. Data read: 58299 t Verbose: 1220 : 10|16:21:19.5491|w_t8W8||imfx v3 API took 0.004s '/api/v3/visual-asset/group/M6I_N7/0/image' t Transfer: 1220 : 10|16:21:19.5491|n1ijwI|TMDDBA|OAuth: /api/settings/user/defaultHomePage?_dc=1591629679167 t Transfer: 1220 : 10|16:21:19.5491|n1ijwI|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:21:19.5491|n1ijwI|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:21:19.5491|n1ijwI|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:21:19.5491|n1ijwI|TMDDBA|OAuth. User logged in: TMDDBA t Transfer: 1220 : 10|16:21:19.5491|n1ijwI|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:21:19.5491|n1ijwI|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:21:19.5491|n1ijwI|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:21:19.5491|n1ijwI|TMDDBA|imfx v3 API took 0.004s '/api/settings/user/defaultHomePage?_dc=1591629679167' t Information: 1220 : 10|16:21:19.5491|ThoXV6||GetCache. t Information: 1220 : 10|16:21:19.5491|ThoXV6||GetCache. Found: C:\inetpub\wwwroot\imfxcore\VisualAssetsCache\2_1_M6I_N7.png t Information: 1220 : 10|16:21:19.5491|ThoXV6||GetCache. Data read: 58299 t Verbose: 1220 : 10|16:21:19.5491|ThoXV6||imfx v3 API took 0.003s '/api/v3/visual-asset/group/M6I_N7/1/image' t Transfer: 1220 : 10|16:21:20.3616|_PXQcf|TMDDBA|OAuth: /api/settings/user/consumer?_dc=1591629679888 t Transfer: 1220 : 10|16:21:20.3616|_PXQcf|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:21:20.3616|_PXQcf|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:21:20.3616|_PXQcf|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:21:20.3616|_PXQcf|TMDDBA|OAuth. User logged in: TMDDBA t Transfer: 1220 : 10|16:21:20.3616|_PXQcf|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:21:20.3616|_PXQcf|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:21:20.3616|_PXQcf|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:21:20.3616|_PXQcf|TMDDBA|imfx v3 API took 0.005s '/api/settings/user/consumer?_dc=1591629679888' t Transfer: 1220 : 10|16:21:20.3616|9ZDW~3|TMDDBA|OAuth: /api/user-preferences?keys=consumer.recent.data&_dc=1591629679928 t Transfer: 1220 : 10|16:21:20.3616|9ZDW~3|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:21:20.3616|9ZDW~3|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:21:20.3616|9ZDW~3|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:21:20.3616|9ZDW~3|TMDDBA|OAuth. User logged in: TMDDBA t Information: 1220 : 10|16:21:20.3616|9ZDW~3|TMDDBA|GetUserDataByKeys: consumer.recent.data t Transfer: 1220 : 10|16:21:20.3616|9ZDW~3|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:21:20.3616|9ZDW~3|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:21:20.3616|9ZDW~3|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:21:20.3616|9ZDW~3|TMDDBA|imfx v3 API took 0.005s '/api/user-preferences?keys=consumer.recent.data&_dc=1591629679928' t Transfer: 1220 : 10|16:21:20.3616|4j1L1q|TMDDBA|OAuth: /api/settings/user/startSearch?_dc=1591629680034 t Transfer: 1220 : 10|16:21:20.3616|4j1L1q|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:21:20.3616|4j1L1q|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:21:20.3616|4j1L1q|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:21:20.3616|4j1L1q|TMDDBA|OAuth. User logged in: TMDDBA t Transfer: 1220 : 10|16:21:20.3616|7pD~e8|TMDDBA|OAuth: /api/settings/user/defaultSearch?_dc=1591629680033 t Transfer: 1220 : 10|16:21:20.3616|7pD~e8|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:21:20.3616|7pD~e8|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:21:20.3616|7pD~e8|TMDDBA| user TMDDBA. t Transfer: 1220 : 10|16:21:20.3616|4j1L1q|TMDDBA|GetCurrentUser.. t Verbose: 1220 : 10|16:21:20.3616|7pD~e8|TMDDBA|OAuth. User logged in: TMDDBA t Transfer: 1220 : 10|16:21:20.3616|4j1L1q|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:21:20.3616|4j1L1q|TMDDBA| user TMDDBA. t Transfer: 1220 : 10|16:21:20.3616|7pD~e8|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:21:20.3616|7pD~e8|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:21:20.3616|7pD~e8|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:21:20.3616|4j1L1q|TMDDBA|imfx v3 API took 0.004s '/api/settings/user/startSearch?_dc=1591629680034' t Verbose: 1220 : 10|16:21:20.3616|7pD~e8|TMDDBA|imfx v3 API took 0.004s '/api/settings/user/defaultSearch?_dc=1591629680033' t Information: 1220 : 10|16:21:20.5648|oTqMHE||GetCache. t Information: 1220 : 10|16:21:20.5648|oTqMHE||GetCache. Found: C:\inetpub\wwwroot\imfxcore\VisualAssetsCache\5_3_M6I_N7.png t Information: 1220 : 10|16:21:20.5648|oTqMHE||GetCache. Data read: 461845 t Verbose: 1220 : 10|16:21:20.5648|oTqMHE||imfx v3 API took 0.007s '/api/v3/visual-asset/group/M6I_N7/3/image' t Transfer: 1220 : 10|16:21:20.5648|__SHuu|TMDDBA|OAuth: /api/user-preferences?keys=consumer.recent.data&_dc=1591629680089 t Transfer: 1220 : 10|16:21:20.5648|__SHuu|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:21:20.5648|__SHuu|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:21:20.5648|__SHuu|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:21:20.5648|__SHuu|TMDDBA|OAuth. User logged in: TMDDBA t Information: 1220 : 10|16:21:20.5648|__SHuu|TMDDBA|GetUserDataByKeys: consumer.recent.data t Transfer: 1220 : 10|16:21:20.5648|__SHuu|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:21:20.5648|__SHuu|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:21:20.5648|__SHuu|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:21:20.5648|__SHuu|TMDDBA|imfx v3 API took 0.004s '/api/user-preferences?keys=consumer.recent.data&_dc=1591629680089' t Transfer: 1220 : 10|16:21:20.5648|wXxE~x|TMDDBA|OAuth: /api/user-group-preferences?globals=htmlplayerhotkeys,audioOnFrameForward&_dc=1591629680256 t Transfer: 1220 : 10|16:21:20.5648|wXxE~x|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:21:20.5648|wXxE~x|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:21:20.5648|wXxE~x|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:21:20.5648|wXxE~x|TMDDBA|OAuth. User logged in: TMDDBA t Transfer: 1220 : 10|16:21:20.5648|wXxE~x|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:21:20.5648|wXxE~x|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:21:20.5648|wXxE~x|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:21:20.7679|wXxE~x|TMDDBA|imfx v3 API took 0.007s '/api/user-group-preferences?globals=htmlplayerhotkeys,audioOnFrameForward&_dc=1591629680256' t Transfer: 1220 : 10|16:21:20.7679|H8fzPg|TMDDBA|OAuth: /api/v3/mediavideo/278678?_dc=1591629680273 t Transfer: 1220 : 10|16:21:20.7679|H8fzPg|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:21:20.7679|H8fzPg|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:21:20.7679|H8fzPg|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:21:20.7679|H8fzPg|TMDDBA|OAuth. User logged in: TMDDBA t Verbose: 1220 : 10|16:21:20.7679|H8fzPg|TMDDBA|imfx v3 API took 0.050s '/api/v3/mediavideo/278678?_dc=1591629680273' t Transfer: 1220 : 10|16:21:21.5804|talPbA|TMDDBA|OAuth: /api/v3/search-suggestion/?_dc=1591629681254 t Transfer: 1220 : 10|16:21:21.5804|talPbA|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:21:21.5804|talPbA|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:21:21.5804|talPbA|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:21:21.5804|talPbA|TMDDBA|OAuth. User logged in: TMDDBA t Transfer: 1220 : 10|16:21:21.5804|talPbA|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:21:21.5804|talPbA|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:21:21.5804|talPbA|TMDDBA| user TMDDBA. t Transfer: 1220 : 10|16:21:21.7836|pnH~wR|TMDDBA|OAuth: /api/v3/search-suggestion/?_dc=1591629681401 t Transfer: 1220 : 10|16:21:21.7836|pnH~wR|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:21:21.7836|pnH~wR|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:21:21.7836|pnH~wR|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:21:21.7836|pnH~wR|TMDDBA|OAuth. User logged in: TMDDBA t Transfer: 1220 : 10|16:21:21.7836|pnH~wR|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:21:21.7836|pnH~wR|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:21:21.7836|pnH~wR|TMDDBA| user TMDDBA. t Transfer: 1220 : 10|16:21:21.9866|cnq7PW|TMDDBA|OAuth: /api/v3/search-suggestion/?_dc=1591629681649 t Transfer: 1220 : 10|16:21:21.9866|cnq7PW|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:21:21.9866|cnq7PW|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:21:21.9866|cnq7PW|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:21:21.9866|cnq7PW|TMDDBA|OAuth. User logged in: TMDDBA t Transfer: 1220 : 10|16:21:21.9866|cnq7PW|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:21:21.9866|cnq7PW|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:21:21.9866|cnq7PW|TMDDBA| user TMDDBA. t Transfer: 1220 : 10|16:21:22.1898|tuqG4N|TMDDBA|OAuth: /api/v3/search-suggestion/?_dc=1591629681871 t Transfer: 1220 : 10|16:21:22.1898|tuqG4N|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:21:22.1898|tuqG4N|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:21:22.1898|tuqG4N|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:21:22.1898|tuqG4N|TMDDBA|OAuth. User logged in: TMDDBA t Transfer: 1220 : 10|16:21:22.1898|tuqG4N|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:21:22.1898|tuqG4N|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:21:22.1898|tuqG4N|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:21:22.3929|cnq7PW|TMDDBA|imfx v3 API took 0.264s '/api/v3/search-suggestion/?_dc=1591629681649' t Verbose: 1220 : 10|16:21:22.3929|tuqG4N|TMDDBA|imfx v3 API took 0.040s '/api/v3/search-suggestion/?_dc=1591629681871' t Verbose: 1220 : 10|16:21:22.3929|pnH~wR|TMDDBA|imfx v3 API took 0.515s '/api/v3/search-suggestion/?_dc=1591629681401' t Verbose: 1220 : 10|16:21:22.3929|talPbA|TMDDBA|imfx v3 API took 0.687s '/api/v3/search-suggestion/?_dc=1591629681254' t Transfer: 1220 : 10|16:21:22.3929|79oe58|TMDDBA|OAuth: /api/v3/mediavideo/278678?_dc=1591629682039 t Transfer: 1220 : 10|16:21:22.3929|79oe58|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:21:22.3929|79oe58|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:21:22.3929|79oe58|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:21:22.3929|79oe58|TMDDBA|OAuth. User logged in: TMDDBA t Verbose: 1220 : 10|16:21:22.3929|79oe58|TMDDBA|imfx v3 API took 0.003s '/api/v3/mediavideo/278678?_dc=1591629682039' t Transfer: 1220 : 10|16:21:24.0179|ZbAmOJ|TMDDBA|OAuth: /api/settings/user/consumer?_dc=1591629683534 t Transfer: 1220 : 10|16:21:24.0179|ZbAmOJ|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:21:24.0179|ZbAmOJ|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:21:24.0179|ZbAmOJ|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:21:24.0179|ZbAmOJ|TMDDBA|OAuth. User logged in: TMDDBA t Transfer: 1220 : 10|16:21:24.0179|ZbAmOJ|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:21:24.0179|ZbAmOJ|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:21:24.0179|ZbAmOJ|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:21:24.0179|ZbAmOJ|TMDDBA|imfx v3 API took 0.005s '/api/settings/user/consumer?_dc=1591629683534' t Transfer: 1220 : 10|16:21:24.0179|9YvnQC|TMDDBA|OAuth: /api/unifiedsearch/?_dc=1591629683608 t Transfer: 1220 : 10|16:21:24.0179|9YvnQC|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:21:24.0179|9YvnQC|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:21:24.0179|9YvnQC|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:21:24.0179|9YvnQC|TMDDBA|OAuth. User logged in: TMDDBA t Transfer: 1220 : 10|16:21:24.0179|fwMa3s|TMDDBA|OAuth: /api/user-preferences?keys=consumer.recent.data&_dc=1591629683609 t Transfer: 1220 : 10|16:21:24.0179|fwMa3s|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:21:24.0179|fwMa3s|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:21:24.0179|fwMa3s|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:21:24.0179|fwMa3s|TMDDBA|OAuth. User logged in: TMDDBA t Information: 1220 : 10|16:21:24.0179|fwMa3s|TMDDBA|GetUserDataByKeys: consumer.recent.data t Transfer: 1220 : 10|16:21:24.0179|fwMa3s|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:21:24.0179|fwMa3s|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:21:24.0179|fwMa3s|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:21:24.0179|fwMa3s|TMDDBA|imfx v3 API took 0.005s '/api/user-preferences?keys=consumer.recent.data&_dc=1591629683609' t Transfer: 1220 : 10|16:21:24.0179|9YvnQC|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:21:24.0179|9YvnQC|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:21:24.0179|9YvnQC|TMDDBA| user TMDDBA. t Transfer: 1220 : 10|16:21:24.0179|9YvnQC|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:21:24.0179|9YvnQC|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:21:24.0179|9YvnQC|TMDDBA| user TMDDBA. t Information: 1220 : 10|16:21:24.0179|9YvnQC|TMDDBA|Running solr search: [q, (((title:(senate && floor && proceedings && 1 && 08 && 02 && 2017 && 09 && 50 && 23 && 55))^2 OR series:(senate && floor && proceedings && 1 && 08 && 02 && 2017 && 09 && 50 && 23 && 55) OR (titleMergedNgram:senatefloorproceedings10802201709502355*)^10 OR versionid1:(senate\ floor\ proceedings\ 1\ 08/02/2017\ 09\:50\ \-\ 23\:55) OR progid1:(senate\ floor\ proceedings\ 1\ 08/02/2017\ 09\:50\ \-\ 23\:55)) AND deleted_flag:(0) AND (owners:((03BO) OR (03GD) OR (03GO) OR (03HA) OR (03JO) OR (03LI) OR (03NB) OR (03NM) OR (03NO) OR (03OR) OR (03SB) OR (03SC) OR (03SE) OR (03SG) OR (03SK) OR (03SM) OR (03SN) OR (03SS) OR (03SY) OR (03UP) OR (03VA) OR (03VB) OR (03VL) OR (03VT) OR (3\+ES) OR (3PD) OR (3PLV) OR (AECHD) OR (AECSD) OR (AL) OR (AMAY) OR (AMC) OR (ATP) OR (BBC) OR (CENT) OR (CS) OR (CTCB) OR (CTCE) OR (DAVI) OR (DMA) OR (DMF) OR (DMY) OR (DTV) OR (EST) OR (EUROSPORT) OR (HDC1) OR (HDP1) OR (HDP2) OR (HUB) OR (ITV) OR (KNL2) OR (KNVA) OR (LMH) OR (LNT) OR (MBNS) OR (MED) OR (MM) OR (MTG) OR (NAA) OR (NICK) OR (NVA) OR (OSP) OR (PBOY) OR (PMS) OR (PPL) OR (PSP) OR (Play) OR (RTR) OR (SFP1) OR (SFP2) OR (SPG) OR (SPTV) OR (T3LT) OR (T3LV) OR (T6LT) OR (T6LV) OR (T8LT) OR (TECHM) OR (TMD) OR (TV10) OR (TV1A) OR (TV1B) OR (TV1C) OR (TV1D) OR (TV1E) OR (TV1F) OR (TV1K) OR (TV1N) OR (TV1P) OR (TV1S) OR (TV2S) OR (TV3D) OR (TV3N) OR (TV3S) OR (TV5L) OR (TV6E) OR (TV6H) OR (TV6N) OR (TV6S) OR (TV8) OR (TVAE) OR (TVDP) OR (TVPB) OR (TVPU) OR (TVSL) OR (V1G) OR (V1TZ) OR (V3H) OR (V4N) OR (VEC) OR (VEPL) OR (VEPO) OR (VEXE) OR (VEXR) OR (VHIS) OR (VHPO) OR (VNC) OR (VNE) OR (VNH) OR (VNHD) OR (VNPO) OR (VODD) OR (VODE) OR (VODF) OR (VODN) OR (VODS) OR (VS2) OR (VS3) OR (VSAT) OR (VSD) OR (VSD2) OR (VSE) OR (VSG) OR (VSHD) OR (VSS) OR (WCIU) OR ("YLE TV1") OR (ZTVS))))] t Information: 1220 : 10|16:21:24.2210|9YvnQC|TMDDBA|Solr query returned: 1 in 15ms t Information: 1220 : 10|16:21:24.2210|9YvnQC|TMDDBA|SearchVersion SQL: select * from (select a.*, rownum rnum from ( select m.*, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID, BUILD_PGRL_FULLTITLE(item_type, title, ser_name, ser_title) FULLTITLE ,(select UTL_RAW.CAST_TO_VARCHAR2(DBMS_LOB.SUBSTR(data2, 2000,1)) from tm_txt_obj where type_id=5021083 and pgm_rl_id=m.id and rownum=1) SYNOPSIS ,(select m_ctnr_loc || '^' || m_ctnr_id from tm_mis mis join tm_cfg_media_file_types t on t.id=mis.m_ctnr_fmt_id and t.imfx_disable_playback<>1 where mis.pgm_parent_id=m.id /*and mis.m_ctnr_fmt_id in (2,4,54,52,98,57,62)*/ and mis.item_type>0 and mis.mi_deleted=0 and mis.media_type=100 and not mis.m_ctnr_id is null and mis.m_ctnr_loc is not null and rownum=1) PROXY_MEDIA from tmddba.tm_pg_rl m left outer join (select text_id, text_data_path, text_data_filename, text_ref_object from tmddba.tm_text) t on t.text_id = m.primary_thumb_id,(select /*+ cardinality(4) */ rownum rn, column_value id from table(:ids)) ids where item_type>0 and rl_deleted=0 and m.id = ids.id order by ids.rn ) a where rownum <= 10000) r where rnum >=1 order by rnum t Information: 1220 : 10|16:21:24.4241|9YvnQC|TMDDBA|Running version search. User: 1 Simple Search: SENATE FLOOR PROCEEDINGS 1 08/02/2017 09:50 - 23:55 Trying to use Solr Search... Solr completed in: 127ms. Returned lines: 1 Running Oracle search. Oracle version search timing: 145ms. SQL run: select * from (select a.*, rownum rnum from ( select m.*, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID, BUILD_PGRL_FULLTITLE(item_type, title, ser_name, ser_title) FULLTITLE ,(select UTL_RAW.CAST_TO_VARCHAR2(DBMS_LOB.SUBSTR(data2, 2000,1)) from tm_txt_obj where type_id=5021083 and pgm_rl_id=m.id and rownum=1) SYNOPSIS ,(select m_ctnr_loc || '^' || m_ctnr_id from tm_mis mis join tm_cfg_media_file_types t on t.id=mis.m_ctnr_fmt_id and t.imfx_disable_playback<>1 where mis.pgm_parent_id=m.id /*and mis.m_ctnr_fmt_id in (2,4,54,52,98,57,62)*/ and mis.item_type>0 and mis.mi_deleted=0 and mis.media_type=100 and not mis.m_ctnr_id is null and mis.m_ctnr_loc is not null and rownum=1) PROXY_MEDIA from tmddba.tm_pg_rl m left outer join (select text_id, text_data_path, text_data_filename, text_ref_object from tmddba.tm_text) t on t.text_id = m.primary_thumb_id,(select /*+ cardinality(4) */ rownum rn, column_value id from table(:ids)) ids where item_type>0 and rl_deleted=0 and m.id = ids.id order by ids.rn ) a where rownum <= 10000) r where rnum >=1 order by rnum t Transfer: 1220 : 10|16:21:24.4241|9YvnQC|TMDDBA|GetUrl. Storage |Video| filename I:\Video\L0640430.mp4 subfolder t Transfer: 1220 : 10|16:21:24.4241|9YvnQC|TMDDBA| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/L0640430.mp4 t Transfer: 1220 : 10|16:21:24.4241|9YvnQC|TMDDBA|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/L0640430.mp4 t Verbose: 1220 : 10|16:21:24.4241|9YvnQC|TMDDBA|imfx v3 API took 0.307s '/api/unifiedsearch/?_dc=1591629683608' t Transfer: 1220 : 10|16:21:24.4241|N9kA5W|TMDDBA|OAuth: /api/user-preferences?keys=adv.recent.searches.consumer&_dc=1591629683982 t Transfer: 1220 : 10|16:21:24.4241|N9kA5W|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:21:24.4241|N9kA5W|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:21:24.4241|N9kA5W|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:21:24.4241|N9kA5W|TMDDBA|OAuth. User logged in: TMDDBA t Information: 1220 : 10|16:21:24.4241|N9kA5W|TMDDBA|GetUserDataByKeys: adv.recent.searches.consumer t Transfer: 1220 : 10|16:21:24.4241|N9kA5W|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:21:24.4241|N9kA5W|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:21:24.4241|N9kA5W|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:21:24.4241|N9kA5W|TMDDBA|imfx v3 API took 0.008s '/api/user-preferences?keys=adv.recent.searches.consumer&_dc=1591629683982' t Transfer: 1220 : 10|16:21:24.4241|qcWPIT|TMDDBA|OAuth: /api/user-preferences?_dc=1591629684007 t Transfer: 1220 : 10|16:21:24.4241|qcWPIT|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:21:24.4241|qcWPIT|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:21:24.4241|qcWPIT|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:21:24.4241|qcWPIT|TMDDBA|OAuth. User logged in: TMDDBA t Verbose: 1220 : 10|16:21:24.4241|qcWPIT|TMDDBA|StoreUserDataByKeys.. t Transfer: 1220 : 10|16:21:24.4241|qcWPIT|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:21:24.4241|qcWPIT|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:21:24.4241|qcWPIT|TMDDBA| user TMDDBA. t Transfer: 1220 : 10|16:21:24.4241|NBi8RL|TMDDBA|OAuth: /api/user-group-preferences?globals=htmlplayerhotkeys,audioOnFrameForward&_dc=1591629684048 t Transfer: 1220 : 10|16:21:24.4241|NBi8RL|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:21:24.4241|NBi8RL|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:21:24.4241|NBi8RL|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:21:24.4241|NBi8RL|TMDDBA|OAuth. User logged in: TMDDBA t Transfer: 1220 : 10|16:21:24.4241|NBi8RL|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:21:24.4241|NBi8RL|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:21:24.4241|NBi8RL|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:21:24.4241|NBi8RL|TMDDBA|imfx v3 API took 0.003s '/api/user-group-preferences?globals=htmlplayerhotkeys,audioOnFrameForward&_dc=1591629684048' t Verbose: 1220 : 10|16:21:24.4241|qcWPIT|TMDDBA|imfx v3 API took 0.037s '/api/user-preferences?_dc=1591629684007' t Transfer: 1220 : 10|16:21:24.4241|HrQXys|TMDDBA|OAuth: /api/v3/versionvideo/291740?info=smudge&_dc=1591629684069 t Transfer: 1220 : 10|16:21:24.4241|HrQXys|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:21:24.4241|HrQXys|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:21:24.4241|HrQXys|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:21:24.4241|HrQXys|TMDDBA|OAuth. User logged in: TMDDBA t Transfer: 1220 : 10|16:21:24.4241|HrQXys|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:21:24.4241|HrQXys|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:21:24.4241|HrQXys|TMDDBA| user TMDDBA. t Transfer: 1220 : 10|16:21:24.4241|b6Vda9|TMDDBA|OAuth: /api/user-group-preferences?globals=htmlplayerhotkeys,audioOnFrameForward&_dc=1591629684106 t Transfer: 1220 : 10|16:21:24.4241|b6Vda9|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:21:24.4241|b6Vda9|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:21:24.4241|b6Vda9|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:21:24.4241|b6Vda9|TMDDBA|OAuth. User logged in: TMDDBA t Transfer: 1220 : 10|16:21:24.4241|b6Vda9|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:21:24.4241|b6Vda9|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:21:24.4241|b6Vda9|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:21:24.4241|b6Vda9|TMDDBA|imfx v3 API took 0.004s '/api/user-group-preferences?globals=htmlplayerhotkeys,audioOnFrameForward&_dc=1591629684106' t Transfer: 1220 : 10|16:21:24.4241|PPWewl|TMDDBA|OAuth: /api/v3/versionvideo/291740?_dc=1591629684119 t Transfer: 1220 : 10|16:21:24.4241|PPWewl|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:21:24.4241|PPWewl|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:21:24.4241|PPWewl|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:21:24.4241|PPWewl|TMDDBA|OAuth. User logged in: TMDDBA t Transfer: 1220 : 10|16:21:24.4241|PPWewl|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:21:24.4241|PPWewl|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:21:24.4241|PPWewl|TMDDBA| user TMDDBA. t Transfer: 1220 : 10|16:21:24.6429|olGSQF|TMDDBA|OAuth: /api/user-preferences?keys=adv.recent.searches.consumer&_dc=1591629684131 t Transfer: 1220 : 10|16:21:24.6429|olGSQF|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:21:24.6429|olGSQF|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:21:24.6429|olGSQF|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:21:24.6429|olGSQF|TMDDBA|OAuth. User logged in: TMDDBA t Information: 1220 : 10|16:21:24.6429|olGSQF|TMDDBA|GetUserDataByKeys: adv.recent.searches.consumer t Transfer: 1220 : 10|16:21:24.6429|olGSQF|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:21:24.6429|olGSQF|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:21:24.6429|olGSQF|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:21:24.6429|olGSQF|TMDDBA|imfx v3 API took 0.005s '/api/user-preferences?keys=adv.recent.searches.consumer&_dc=1591629684131' t Transfer: 1220 : 10|16:21:24.6429|VXV0KD|TMDDBA|OAuth: /api/user-preferences?_dc=1591629684222 t Transfer: 1220 : 10|16:21:24.6429|VXV0KD|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:21:24.6429|VXV0KD|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:21:24.6429|VXV0KD|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:21:24.6429|VXV0KD|TMDDBA|OAuth. User logged in: TMDDBA t Verbose: 1220 : 10|16:21:24.6429|VXV0KD|TMDDBA|StoreUserDataByKeys.. t Transfer: 1220 : 10|16:21:24.6429|VXV0KD|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:21:24.6429|VXV0KD|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:21:24.6429|VXV0KD|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:21:24.6429|VXV0KD|TMDDBA|imfx v3 API took 0.013s '/api/user-preferences?_dc=1591629684222' t Transfer: 1220 : 10|16:21:24.6429|PPWewl|TMDDBA|GetUrl. Storage |Video| filename I:\Video\L0640430.mp4 subfolder t Transfer: 1220 : 10|16:21:24.6429|PPWewl|TMDDBA| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/L0640430.mp4 t Transfer: 1220 : 10|16:21:24.6429|PPWewl|TMDDBA|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/L0640430.mp4 t Transfer: 1220 : 10|16:21:24.6429|PPWewl|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:21:24.6429|PPWewl|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:21:24.6429|PPWewl|TMDDBA| user TMDDBA. t Transfer: 1220 : 10|16:21:24.6429|HrQXys|TMDDBA|GetUrl. Storage |Video| filename I:\Video\L0640430.mp4 subfolder t Transfer: 1220 : 10|16:21:24.6429|HrQXys|TMDDBA| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/L0640430.mp4 t Transfer: 1220 : 10|16:21:24.6429|HrQXys|TMDDBA|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/L0640430.mp4 t Transfer: 1220 : 10|16:21:24.6429|HrQXys|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:21:24.6429|HrQXys|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:21:24.6429|HrQXys|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:21:24.8460|PPWewl|TMDDBA|imfx v3 API took 0.290s '/api/v3/versionvideo/291740?_dc=1591629684119' t Verbose: 1220 : 10|16:21:24.8460|HrQXys|TMDDBA|imfx v3 API took 0.402s '/api/v3/versionvideo/291740?info=smudge&_dc=1591629684069' t Transfer: 1220 : 10|16:21:26.6741|TqBt_~|TMDDBA|OAuth: /api/v3/media-captions/291740?_dc=1591629686144 t Transfer: 1220 : 10|16:21:26.6741|TqBt_~|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:21:26.6741|TqBt_~|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:21:26.6741|TqBt_~|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:21:26.6741|TqBt_~|TMDDBA|OAuth. User logged in: TMDDBA t Verbose: 1220 : 10|16:21:26.6741|TqBt_~|TMDDBA|imfx v3 API took 0.042s '/api/v3/media-captions/291740?_dc=1591629686144' t Transfer: 1220 : 10|16:21:26.6741|0D1NOl|TMDDBA|OAuth: /api/v3/versionvideo/291740?_dc=1591629686254 t Transfer: 1220 : 10|16:21:26.6741|0D1NOl|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:21:26.6741|0D1NOl|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:21:26.6741|0D1NOl|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:21:26.6741|0D1NOl|TMDDBA|OAuth. User logged in: TMDDBA t Transfer: 1220 : 10|16:21:26.6741|0D1NOl|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:21:26.6741|0D1NOl|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:21:26.6741|0D1NOl|TMDDBA| user TMDDBA. t Transfer: 1220 : 10|16:21:26.6741|0D1NOl|TMDDBA|GetUrl. Storage |Video| filename I:\Video\L0640430.mp4 subfolder t Transfer: 1220 : 10|16:21:26.6741|0D1NOl|TMDDBA| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/L0640430.mp4 t Transfer: 1220 : 10|16:21:26.6741|0D1NOl|TMDDBA|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/L0640430.mp4 t Transfer: 1220 : 10|16:21:26.6741|0D1NOl|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:21:26.6741|0D1NOl|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:21:26.6741|0D1NOl|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:21:26.6741|0D1NOl|TMDDBA|imfx v3 API took 0.024s '/api/v3/versionvideo/291740?_dc=1591629686254' t Transfer: 1220 : 10|16:21:30.7367|NRtmk1|TMDDBA|OAuth: /api/view/searchinfo/Media?_dc=1591629690365 t Transfer: 1220 : 10|16:21:30.7367|NRtmk1|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:21:30.7367|NRtmk1|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:21:30.7367|NRtmk1|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:21:30.7367|NRtmk1|TMDDBA|OAuth. User logged in: TMDDBA t Information: 1220 : 10|16:21:30.7367|NRtmk1|TMDDBA|GetAdvSearchColumns. search type Media grid . t Transfer: 1220 : 10|16:21:30.7367|pcvejD|TMDDBA|OAuth: /api/user-preferences?keys=adv.recent.searches.media&_dc=1591629690367 t Transfer: 1220 : 10|16:21:30.7367|pcvejD|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:21:30.7367|pcvejD|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:21:30.7367|pcvejD|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:21:30.7367|pcvejD|TMDDBA|OAuth. User logged in: TMDDBA t Information: 1220 : 10|16:21:30.7367|pcvejD|TMDDBA|GetUserDataByKeys: adv.recent.searches.media t Transfer: 1220 : 10|16:21:30.7367|pcvejD|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:21:30.7367|pcvejD|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:21:30.7367|pcvejD|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:21:30.7367|pcvejD|TMDDBA|imfx v3 API took 0.005s '/api/user-preferences?keys=adv.recent.searches.media&_dc=1591629690367' t Verbose: 1220 : 10|16:21:30.7367|NRtmk1|TMDDBA|imfx v3 API took 0.016s '/api/view/searchinfo/Media?_dc=1591629690365' t Transfer: 1220 : 10|16:21:30.7367|b9gG94|TMDDBA|OAuth: /api/lookups/SearchSupportedOperators?_dc=1591629690366 t Transfer: 1220 : 10|16:21:30.7367|b9gG94|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:21:30.7367|b9gG94|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:21:30.7367|b9gG94|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:21:30.7367|b9gG94|TMDDBA|OAuth. User logged in: TMDDBA t Verbose: 1220 : 10|16:21:30.7367|b9gG94|TMDDBA|imfx v3 API took 0.000s '/api/lookups/SearchSupportedOperators?_dc=1591629690366' t Transfer: 1220 : 10|16:21:30.7367|f0DuUS|TMDDBA|OAuth: /api/view/info/MediaGrid?lang=en-GB&_dc=1591629690410 t Transfer: 1220 : 10|16:21:30.7367|f0DuUS|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:21:30.7367|f0DuUS|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:21:30.7367|f0DuUS|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:21:30.7367|f0DuUS|TMDDBA|OAuth. User logged in: TMDDBA t Transfer: 1220 : 10|16:21:30.7367|kXqXdj|TMDDBA|OAuth: /api/view/searches/Media?_dc=1591629690404 t Transfer: 1220 : 10|16:21:30.7367|kXqXdj|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:21:30.7367|kXqXdj|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:21:30.7367|kXqXdj|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:21:30.7367|kXqXdj|TMDDBA|OAuth. User logged in: TMDDBA t Information: 1220 : 10|16:21:30.7367|f0DuUS|TMDDBA|GetGridViewBuilder. builder type MediaGrid. t Transfer: 1220 : 10|16:21:30.7367|f0DuUS|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:21:30.7367|f0DuUS|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:21:30.7367|f0DuUS|TMDDBA| user TMDDBA. t Information: 1220 : 10|16:21:30.7367|kXqXdj|TMDDBA|GetSavedSearchNames. search type Media. t Transfer: 1220 : 10|16:21:30.7367|kXqXdj|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:21:30.7367|kXqXdj|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:21:30.7367|kXqXdj|TMDDBA| user TMDDBA. t Information: 1220 : 10|16:21:30.7367|f0DuUS|TMDDBA|UserGridView. LoadView. ID 311, Name Default. t Transfer: 1220 : 10|16:21:30.7367|f0DuUS|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:21:30.7367|f0DuUS|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:21:30.7367|f0DuUS|TMDDBA| user TMDDBA. t Transfer: 1220 : 10|16:21:30.7367|kSOV5~|TMDDBA|OAuth: /api/settings/user/searchLayoutConfig?_dc=1591629690412 t Transfer: 1220 : 10|16:21:30.7367|kSOV5~|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:21:30.7367|kSOV5~|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:21:30.7367|kSOV5~|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:21:30.7367|kSOV5~|TMDDBA|OAuth. User logged in: TMDDBA t Transfer: 1220 : 10|16:21:30.7367|kSOV5~|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:21:30.7367|kSOV5~|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:21:30.7367|kSOV5~|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:21:30.7367|kSOV5~|TMDDBA|imfx v3 API took 0.006s '/api/settings/user/searchLayoutConfig?_dc=1591629690412' t Transfer: 1220 : 10|16:21:30.7367|f0DuUS|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:21:30.7367|f0DuUS|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:21:30.7367|f0DuUS|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:21:30.7367|kXqXdj|TMDDBA|imfx v3 API took 0.018s '/api/view/searches/Media?_dc=1591629690404' t Verbose: 1220 : 10|16:21:30.7367|f0DuUS|TMDDBA|imfx v3 API took 0.021s '/api/view/info/MediaGrid?lang=en-GB&_dc=1591629690410' t Transfer: 1220 : 10|16:21:31.7679|MinTBh|TMDDBA|OAuth: /api/v3/search-suggestion/?_dc=1591629691459 t Transfer: 1220 : 10|16:21:31.7679|MinTBh|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:21:31.7679|MinTBh|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:21:31.7679|MinTBh|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:21:31.7679|MinTBh|TMDDBA|OAuth. User logged in: TMDDBA t Transfer: 1220 : 10|16:21:31.7679|MinTBh|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:21:31.7679|MinTBh|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:21:31.7679|MinTBh|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:21:31.9710|MinTBh|TMDDBA|imfx v3 API took 0.028s '/api/v3/search-suggestion/?_dc=1591629691459' t Transfer: 1220 : 10|16:21:31.9710|Ip6zHQ|TMDDBA|OAuth: /api/v3/search-suggestion/?_dc=1591629691572 t Transfer: 1220 : 10|16:21:31.9710|Ip6zHQ|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:21:31.9710|Ip6zHQ|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:21:31.9710|Ip6zHQ|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:21:31.9710|Ip6zHQ|TMDDBA|OAuth. User logged in: TMDDBA t Transfer: 1220 : 10|16:21:31.9710|Ip6zHQ|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:21:31.9710|Ip6zHQ|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:21:31.9710|Ip6zHQ|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:21:31.9710|Ip6zHQ|TMDDBA|imfx v3 API took 0.010s '/api/v3/search-suggestion/?_dc=1591629691572' t Transfer: 1220 : 10|16:21:32.1741|Jl3yhN|TMDDBA|OAuth: /api/v3/search-suggestion/?_dc=1591629691770 t Transfer: 1220 : 10|16:21:32.1741|Jl3yhN|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:21:32.1741|Jl3yhN|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:21:32.1741|Jl3yhN|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:21:32.1741|Jl3yhN|TMDDBA|OAuth. User logged in: TMDDBA t Transfer: 1220 : 10|16:21:32.1741|Jl3yhN|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:21:32.1741|Jl3yhN|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:21:32.1741|Jl3yhN|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:21:32.1741|Jl3yhN|TMDDBA|imfx v3 API took 0.010s '/api/v3/search-suggestion/?_dc=1591629691770' t Transfer: 1220 : 10|16:21:32.3772|ZUyR1D|TMDDBA|OAuth: /api/v3/search-suggestion/?_dc=1591629691949 t Transfer: 1220 : 10|16:21:32.3772|ZUyR1D|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:21:32.3772|ZUyR1D|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:21:32.3772|ZUyR1D|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:21:32.3772|ZUyR1D|TMDDBA|OAuth. User logged in: TMDDBA t Transfer: 1220 : 10|16:21:32.3772|ZUyR1D|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:21:32.3772|ZUyR1D|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:21:32.3772|ZUyR1D|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:21:32.3772|ZUyR1D|TMDDBA|imfx v3 API took 0.010s '/api/v3/search-suggestion/?_dc=1591629691949' t Transfer: 1220 : 10|16:21:32.5804|CJzCvI|TMDDBA|OAuth: /api/v3/search-suggestion/?_dc=1591629692098 t Transfer: 1220 : 10|16:21:32.5804|CJzCvI|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:21:32.5804|CJzCvI|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:21:32.5804|CJzCvI|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:21:32.5804|CJzCvI|TMDDBA|OAuth. User logged in: TMDDBA t Transfer: 1220 : 10|16:21:32.5804|CJzCvI|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:21:32.5804|CJzCvI|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:21:32.5804|CJzCvI|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:21:32.5804|CJzCvI|TMDDBA|imfx v3 API took 0.007s '/api/v3/search-suggestion/?_dc=1591629692098' t Transfer: 1220 : 10|16:21:32.7835|q74huR|TMDDBA|OAuth: /api/v3/search-suggestion/?_dc=1591629692286 t Transfer: 1220 : 10|16:21:32.7835|q74huR|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:21:32.7835|q74huR|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:21:32.7835|q74huR|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:21:32.7835|q74huR|TMDDBA|OAuth. User logged in: TMDDBA t Transfer: 1220 : 10|16:21:32.7835|q74huR|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:21:32.7835|q74huR|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:21:32.7835|q74huR|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:21:32.7835|q74huR|TMDDBA|imfx v3 API took 0.009s '/api/v3/search-suggestion/?_dc=1591629692286' t Transfer: 1220 : 10|16:21:32.7835|HCpXbe|TMDDBA|OAuth: /api/v3/search-suggestion/?_dc=1591629692410 t Transfer: 1220 : 10|16:21:32.7835|HCpXbe|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:21:32.7835|HCpXbe|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:21:32.7835|HCpXbe|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:21:32.7835|HCpXbe|TMDDBA|OAuth. User logged in: TMDDBA t Transfer: 1220 : 10|16:21:32.7835|HCpXbe|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:21:32.7835|HCpXbe|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:21:32.7835|HCpXbe|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:21:32.7835|HCpXbe|TMDDBA|imfx v3 API took 0.008s '/api/v3/search-suggestion/?_dc=1591629692410' t Transfer: 1220 : 10|16:21:32.9866|MmGQEt|TMDDBA|OAuth: /api/v3/search-suggestion/?_dc=1591629692578 t Transfer: 1220 : 10|16:21:32.9866|MmGQEt|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:21:32.9866|MmGQEt|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:21:32.9866|MmGQEt|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:21:32.9866|MmGQEt|TMDDBA|OAuth. User logged in: TMDDBA t Transfer: 1220 : 10|16:21:32.9866|MmGQEt|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:21:32.9866|MmGQEt|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:21:32.9866|MmGQEt|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:21:32.9866|MmGQEt|TMDDBA|imfx v3 API took 0.008s '/api/v3/search-suggestion/?_dc=1591629692578' t Transfer: 1220 : 10|16:21:33.1897|fmk0xc|TMDDBA|OAuth: /api/v3/search-suggestion/?_dc=1591629692733 t Transfer: 1220 : 10|16:21:33.1897|fmk0xc|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:21:33.1897|fmk0xc|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:21:33.1897|fmk0xc|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:21:33.1897|fmk0xc|TMDDBA|OAuth. User logged in: TMDDBA t Transfer: 1220 : 10|16:21:33.1897|fmk0xc|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:21:33.1897|fmk0xc|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:21:33.1897|fmk0xc|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:21:33.1897|fmk0xc|TMDDBA|imfx v3 API took 0.008s '/api/v3/search-suggestion/?_dc=1591629692733' t Transfer: 1220 : 10|16:21:33.1897|1vhaHt|TMDDBA|OAuth: /api/v3/search-suggestion/?_dc=1591629692814 t Transfer: 1220 : 10|16:21:33.1897|1vhaHt|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:21:33.1897|1vhaHt|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:21:33.1897|1vhaHt|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:21:33.1897|1vhaHt|TMDDBA|OAuth. User logged in: TMDDBA t Transfer: 1220 : 10|16:21:33.1897|1vhaHt|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:21:33.1897|1vhaHt|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:21:33.1897|1vhaHt|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:21:33.1897|1vhaHt|TMDDBA|imfx v3 API took 0.007s '/api/v3/search-suggestion/?_dc=1591629692814' t Transfer: 1220 : 10|16:21:34.4085|i6vo99|TMDDBA|OAuth: /api/v3/search/Media?_dc=1591629694077 t Transfer: 1220 : 10|16:21:34.4085|i6vo99|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:21:34.4085|i6vo99|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:21:34.4085|i6vo99|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:21:34.4085|i6vo99|TMDDBA|OAuth. User logged in: TMDDBA t Information: 1220 : 10|16:21:34.4085|i6vo99|TMDDBA|V3Api.SearchMedia t Information: 1220 : 10|16:21:34.6116|i6vo99|TMDDBA|V3Api.SearchGeneric t Transfer: 1220 : 10|16:21:34.6116|i6vo99|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:21:34.6116|i6vo99|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:21:34.6116|i6vo99|TMDDBA| user TMDDBA. t Information: 1220 : 10|16:21:34.6116|i6vo99|TMDDBA|Running solr search: [q, (((title:(09 && 50 && 23 && 55))^2 OR series:(09 && 50 && 23 && 55) OR (titleMergedNgram:09502355*)^10 OR miid1:(09\:50\ \-\ 23\:55) OR miid2:(09\:50\ \-\ 23\:55) OR versionid1:(09\:50\ \-\ 23\:55) OR progid1:(09\:50\ \-\ 23\:55)) AND ((owners:sfp1)) AND deleted_flag:(0) AND (owners:((03BO) OR (03GD) OR (03GO) OR (03HA) OR (03JO) OR (03LI) OR (03NB) OR (03NM) OR (03NO) OR (03OR) OR (03SB) OR (03SC) OR (03SE) OR (03SG) OR (03SK) OR (03SM) OR (03SN) OR (03SS) OR (03SY) OR (03UP) OR (03VA) OR (03VB) OR (03VL) OR (03VT) OR (3\+ES) OR (3PD) OR (3PLV) OR (AECHD) OR (AECSD) OR (AL) OR (AMAY) OR (AMC) OR (ATP) OR (BBC) OR (CENT) OR (CS) OR (CTCB) OR (CTCE) OR (DAVI) OR (DMA) OR (DMF) OR (DMY) OR (DTV) OR (EST) OR (EUROSPORT) OR (HDC1) OR (HDP1) OR (HDP2) OR (HUB) OR (ITV) OR (KNL2) OR (KNVA) OR (LMH) OR (LNT) OR (MBNS) OR (MED) OR (MM) OR (MTG) OR (NAA) OR (NICK) OR (NVA) OR (OSP) OR (PBOY) OR (PMS) OR (PPL) OR (PSP) OR (Play) OR (RTR) OR (SFP1) OR (SFP2) OR (SPG) OR (SPTV) OR (T3LT) OR (T3LV) OR (T6LT) OR (T6LV) OR (T8LT) OR (TECHM) OR (TMD) OR (TV10) OR (TV1A) OR (TV1B) OR (TV1C) OR (TV1D) OR (TV1E) OR (TV1F) OR (TV1K) OR (TV1N) OR (TV1P) OR (TV1S) OR (TV2S) OR (TV3D) OR (TV3N) OR (TV3S) OR (TV5L) OR (TV6E) OR (TV6H) OR (TV6N) OR (TV6S) OR (TV8) OR (TVAE) OR (TVDP) OR (TVPB) OR (TVPU) OR (TVSL) OR (V1G) OR (V1TZ) OR (V3H) OR (V4N) OR (VEC) OR (VEPL) OR (VEPO) OR (VEXE) OR (VEXR) OR (VHIS) OR (VHPO) OR (VNC) OR (VNE) OR (VNH) OR (VNHD) OR (VNPO) OR (VODD) OR (VODE) OR (VODF) OR (VODN) OR (VODS) OR (VS2) OR (VS3) OR (VSAT) OR (VSD) OR (VSD2) OR (VSE) OR (VSG) OR (VSHD) OR (VSS) OR (WCIU) OR ("YLE TV1") OR (ZTVS))))] t Information: 1220 : 10|16:21:34.6116|i6vo99|TMDDBA|Solr query returned: 2 in 3ms t Information: 1220 : 10|16:21:34.6116|i6vo99|TMDDBA|MediaSearch SQL: select r.*, nvl((select TMD_STR_AGG(c.u_id_pfix ) from tm_ctnrs c, tm_mi_tpi_lnx l where l.miid=r.id and c.u_id=l.tpiid and r.media_type=1),'') BARCODE, nvl(lnk.lib_loc_ext_id,0) lib_loc_ext_id, nvl(lnk.ctnr_loan_stat,0) ctnr_loan_status, nvl(lnk.ctnr_stat,0) ctnr_stat, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID , (select tmd_str_agg_pipe(cms.status_type_id ||',' ||cms.status_id) from tm_mi_cust_med_stat_lnx cms where cms.media_id=r.id) "CustomStatusesRaw", GETMEDIALOC(r.id, r.media_type, r.compil, r.m_ctnr_int_o_loc, r.m_ctnr_ext_o_loc, r.m_ctnr_loc) LOCATION, nvl(dfl.fSOM,0) FILE_SOM, nvl(dfl.fEOM,0) FILE_EOM, dfl.fos_fname FILENAME, dfl.DFILE_LINK_GUID, dfl.OS_GUID, dfl.SUB_FOLDER, dfl.ORIGINAL_FILENAME from (select a.*, rownum rnum from (select m.*, coalesce(m.primary_thumb_id, (select v.primary_thumb_id from tm_pg_rl v where v.id=m.pgm_parent_id)) primary_thumb_id2 from tmddba.tm_mis m ,(select /*+ cardinality(4) */ rownum rn, column_value id from table(:ids)) ids where media_type>0 and item_type>0 and m.id = ids.id order by ids.rn ) a where rownum <= 10000) r ,lateral( select l.miid, max(c.C_EXT_OUT_LOC) lib_loc_ext_id, max(c.C_STAT) ctnr_stat, max(c.loan_stat) ctnr_loan_stat from tm_mi_tpi_lnx l, tm_ctnrs c where c.u_id=l.tpiid and l.miid=r.id and r.media_type=1 group by l.miid)(+) lnk ,lateral(select tt.* from tm_text tt where tt.text_id = r.primary_thumb_id2)(+) t ,lateral(select /*+ NO_DECORRELATE */ d.som fsom, d.eom feom, dl.mi_id fmi_id, d.os_fname fos_fname, d.DFILE_LINK_GUID, d.OS_GUID, d.SUB_FOLDER, dl.dfile_id, d.original_filename FROM tm_dfile d, tm_mi_dfile_lnx dl where d.id=dl.dfile_id and r.id=dl.mi_id and rownum=1)(+) dfl where rnum >= 1 order by rnum t Information: 1220 : 10|16:21:34.8147|i6vo99|TMDDBA| timing: 00:00:00.1900879 t Verbose: 1220 : 10|16:21:34.8147|i6vo99|TMDDBA|imfx v3 API took 0.251s '/api/v3/search/Media?_dc=1591629694077' t Transfer: 1220 : 10|16:21:34.8147|i6vo99|TMDDBA|GetUrl. Storage |Video| filename I:\Video\L0640430.mp4 subfolder t Transfer: 1220 : 10|16:21:34.8147|i6vo99|TMDDBA| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/L0640430.mp4 t Transfer: 1220 : 10|16:21:34.8147|i6vo99|TMDDBA|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/L0640430.mp4 t Transfer: 1220 : 10|16:21:34.8147|i6vo99|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:21:34.8147|i6vo99|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:21:34.8147|i6vo99|TMDDBA| user TMDDBA. t Transfer: 1220 : 10|16:21:35.0179|i6vo99|TMDDBA|GetUrl. Storage |Video| filename I:\Video\L0640441.mp4 subfolder t Transfer: 1220 : 10|16:21:35.0179|i6vo99|TMDDBA| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/L0640441.mp4 t Transfer: 1220 : 10|16:21:35.0179|i6vo99|TMDDBA|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/L0640441.mp4 t Transfer: 1220 : 10|16:21:35.0179|i6vo99|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:21:35.0179|i6vo99|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:21:35.0179|i6vo99|TMDDBA| user TMDDBA. t Transfer: 1220 : 10|16:21:35.0179|LbrchW|TMDDBA|OAuth: /api/user-preferences?_dc=1591629694632 t Transfer: 1220 : 10|16:21:35.0179|LbrchW|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:21:35.0179|LbrchW|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:21:35.0179|LbrchW|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:21:35.0179|LbrchW|TMDDBA|OAuth. User logged in: TMDDBA t Verbose: 1220 : 10|16:21:35.0179|LbrchW|TMDDBA|StoreUserDataByKeys.. t Transfer: 1220 : 10|16:21:35.0179|LbrchW|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:21:35.0179|LbrchW|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:21:35.0179|LbrchW|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:21:35.0179|LbrchW|TMDDBA|imfx v3 API took 0.007s '/api/user-preferences?_dc=1591629694632' t Transfer: 1220 : 10|16:21:37.8616|Y2sJ5G|TMDDBA|OAuth: /api/lookups/FriendlyNames?_dc=1591629697436 t Transfer: 1220 : 10|16:21:37.8616|Y2sJ5G|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:21:37.8616|Y2sJ5G|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:21:37.8616|Y2sJ5G|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:21:37.8616|Y2sJ5G|TMDDBA|OAuth. User logged in: TMDDBA t Verbose: 1220 : 10|16:21:37.8616|Y2sJ5G|TMDDBA|imfx v3 API took 0.000s '/api/lookups/FriendlyNames?_dc=1591629697436' t Transfer: 1220 : 10|16:21:37.8616|xm56X8|TMDDBA|OAuth: /api/v3/search/Media?_dc=1591629697437 t Transfer: 1220 : 10|16:21:37.8616|xm56X8|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:21:37.8616|xm56X8|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:21:37.8616|xm56X8|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:21:37.8616|xm56X8|TMDDBA|OAuth. User logged in: TMDDBA t Information: 1220 : 10|16:21:37.8616|xm56X8|TMDDBA|V3Api.SearchMedia t Information: 1220 : 10|16:21:37.8616|xm56X8|TMDDBA|V3Api.SearchGeneric t Transfer: 1220 : 10|16:21:37.8616|xm56X8|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:21:37.8616|xm56X8|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:21:37.8616|xm56X8|TMDDBA| user TMDDBA. t Information: 1220 : 10|16:21:37.8616|xm56X8|TMDDBA|MediaSearch SQL: select r.*, nvl((select TMD_STR_AGG(c.u_id_pfix ) from tm_ctnrs c, tm_mi_tpi_lnx l where l.miid=r.id and c.u_id=l.tpiid and r.media_type=1),'') BARCODE, nvl(lnk.lib_loc_ext_id,0) lib_loc_ext_id, nvl(lnk.ctnr_loan_stat,0) ctnr_loan_status, nvl(lnk.ctnr_stat,0) ctnr_stat, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID , (select tmd_str_agg_pipe(cms.status_type_id ||',' ||cms.status_id) from tm_mi_cust_med_stat_lnx cms where cms.media_id=r.id) "CustomStatusesRaw", GETMEDIALOC(r.id, r.media_type, r.compil, r.m_ctnr_int_o_loc, r.m_ctnr_ext_o_loc, r.m_ctnr_loc) LOCATION, nvl(dfl.fSOM,0) FILE_SOM, nvl(dfl.fEOM,0) FILE_EOM, dfl.fos_fname FILENAME, dfl.DFILE_LINK_GUID, dfl.OS_GUID, dfl.SUB_FOLDER, dfl.ORIGINAL_FILENAME from (select a.*, rownum rnum from (select m.*, coalesce(m.primary_thumb_id, (select v.primary_thumb_id from tm_pg_rl v where v.id=m.pgm_parent_id)) primary_thumb_id2 from tmddba.tm_mis m where media_type>0 and item_type>0 AND m.ID=291742 and m.mi_deleted=0 AND (INSTR(m.OWNERS,'|03BO|')>0 OR INSTR(m.OWNERS,'|03GD|')>0 OR INSTR(m.OWNERS,'|03GO|')>0 OR INSTR(m.OWNERS,'|03HA|')>0 OR INSTR(m.OWNERS,'|03JO|')>0 OR INSTR(m.OWNERS,'|03LI|')>0 OR INSTR(m.OWNERS,'|03NB|')>0 OR INSTR(m.OWNERS,'|03NM|')>0 OR INSTR(m.OWNERS,'|03NO|')>0 OR INSTR(m.OWNERS,'|03OR|')>0 OR INSTR(m.OWNERS,'|03SB|')>0 OR INSTR(m.OWNERS,'|03SC|')>0 OR INSTR(m.OWNERS,'|03SE|')>0 OR INSTR(m.OWNERS,'|03SG|')>0 OR INSTR(m.OWNERS,'|03SK|')>0 OR INSTR(m.OWNERS,'|03SM|')>0 OR INSTR(m.OWNERS,'|03SN|')>0 OR INSTR(m.OWNERS,'|03SS|')>0 OR INSTR(m.OWNERS,'|03SY|')>0 OR INSTR(m.OWNERS,'|03UP|')>0 OR INSTR(m.OWNERS,'|03VA|')>0 OR INSTR(m.OWNERS,'|03VB|')>0 OR INSTR(m.OWNERS,'|03VL|')>0 OR INSTR(m.OWNERS,'|03VT|')>0 OR INSTR(m.OWNERS,'|3+ES|')>0 OR INSTR(m.OWNERS,'|3PD|')>0 OR INSTR(m.OWNERS,'|3PLV|')>0 OR INSTR(m.OWNERS,'|AECHD|')>0 OR INSTR(m.OWNERS,'|AECSD|')>0 OR INSTR(m.OWNERS,'|AL|')>0 OR INSTR(m.OWNERS,'|AMAY|')>0 OR INSTR(m.OWNERS,'|AMC|')>0 OR INSTR(m.OWNERS,'|ATP|')>0 OR INSTR(m.OWNERS,'|BBC|')>0 OR INSTR(m.OWNERS,'|CENT|')>0 OR INSTR(m.OWNERS,'|CS|')>0 OR INSTR(m.OWNERS,'|CTCB|')>0 OR INSTR(m.OWNERS,'|CTCE|')>0 OR INSTR(m.OWNERS,'|DAVI|')>0 OR INSTR(m.OWNERS,'|DMA|')>0 OR INSTR(m.OWNERS,'|DMF|')>0 OR INSTR(m.OWNERS,'|DMY|')>0 OR INSTR(m.OWNERS,'|DTV|')>0 OR INSTR(m.OWNERS,'|EST|')>0 OR INSTR(m.OWNERS,'|EUROSPORT|')>0 OR INSTR(m.OWNERS,'|HDC1|')>0 OR INSTR(m.OWNERS,'|HDP1|')>0 OR INSTR(m.OWNERS,'|HDP2|')>0 OR INSTR(m.OWNERS,'|HUB|')>0 OR INSTR(m.OWNERS,'|ITV|')>0 OR INSTR(m.OWNERS,'|KNL2|')>0 OR INSTR(m.OWNERS,'|KNVA|')>0 OR INSTR(m.OWNERS,'|LMH|')>0 OR INSTR(m.OWNERS,'|LNT|')>0 OR INSTR(m.OWNERS,'|MBNS|')>0 OR INSTR(m.OWNERS,'|MED|')>0 OR INSTR(m.OWNERS,'|MM|')>0 OR INSTR(m.OWNERS,'|MTG|')>0 OR INSTR(m.OWNERS,'|NAA|')>0 OR INSTR(m.OWNERS,'|NICK|')>0 OR INSTR(m.OWNERS,'|NVA|')>0 OR INSTR(m.OWNERS,'|OSP|')>0 OR INSTR(m.OWNERS,'|PBOY|')>0 OR INSTR(m.OWNERS,'|PMS|')>0 OR INSTR(m.OWNERS,'|PPL|')>0 OR INSTR(m.OWNERS,'|PSP|')>0 OR INSTR(m.OWNERS,'|Play|')>0 OR INSTR(m.OWNERS,'|RTR|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|SPG|')>0 OR INSTR(m.OWNERS,'|SPTV|')>0 OR INSTR(m.OWNERS,'|T3LT|')>0 OR INSTR(m.OWNERS,'|T3LV|')>0 OR INSTR(m.OWNERS,'|T6LT|')>0 OR INSTR(m.OWNERS,'|T6LV|')>0 OR INSTR(m.OWNERS,'|T8LT|')>0 OR INSTR(m.OWNERS,'|TECHM|')>0 OR INSTR(m.OWNERS,'|TMD|')>0 OR INSTR(m.OWNERS,'|TV10|')>0 OR INSTR(m.OWNERS,'|TV1A|')>0 OR INSTR(m.OWNERS,'|TV1B|')>0 OR INSTR(m.OWNERS,'|TV1C|')>0 OR INSTR(m.OWNERS,'|TV1D|')>0 OR INSTR(m.OWNERS,'|TV1E|')>0 OR INSTR(m.OWNERS,'|TV1F|')>0 OR INSTR(m.OWNERS,'|TV1K|')>0 OR INSTR(m.OWNERS,'|TV1N|')>0 OR INSTR(m.OWNERS,'|TV1P|')>0 OR INSTR(m.OWNERS,'|TV1S|')>0 OR INSTR(m.OWNERS,'|TV2S|')>0 OR INSTR(m.OWNERS,'|TV3D|')>0 OR INSTR(m.OWNERS,'|TV3N|')>0 OR INSTR(m.OWNERS,'|TV3S|')>0 OR INSTR(m.OWNERS,'|TV5L|')>0 OR INSTR(m.OWNERS,'|TV6E|')>0 OR INSTR(m.OWNERS,'|TV6H|')>0 OR INSTR(m.OWNERS,'|TV6N|')>0 OR INSTR(m.OWNERS,'|TV6S|')>0 OR INSTR(m.OWNERS,'|TV8|')>0 OR INSTR(m.OWNERS,'|TVAE|')>0 OR INSTR(m.OWNERS,'|TVDP|')>0 OR INSTR(m.OWNERS,'|TVPB|')>0 OR INSTR(m.OWNERS,'|TVPU|')>0 OR INSTR(m.OWNERS,'|TVSL|')>0 OR INSTR(m.OWNERS,'|V1G|')>0 OR INSTR(m.OWNERS,'|V1TZ|')>0 OR INSTR(m.OWNERS,'|V3H|')>0 OR INSTR(m.OWNERS,'|V4N|')>0 OR INSTR(m.OWNERS,'|VEC|')>0 OR INSTR(m.OWNERS,'|VEPL|')>0 OR INSTR(m.OWNERS,'|VEPO|')>0 OR INSTR(m.OWNERS,'|VEXE|')>0 OR INSTR(m.OWNERS,'|VEXR|')>0 OR INSTR(m.OWNERS,'|VHIS|')>0 OR INSTR(m.OWNERS,'|VHPO|')>0 OR INSTR(m.OWNERS,'|VNC|')>0 OR INSTR(m.OWNERS,'|VNE|')>0 OR INSTR(m.OWNERS,'|VNH|')>0 OR INSTR(m.OWNERS,'|VNHD|')>0 OR INSTR(m.OWNERS,'|VNPO|')>0 OR INSTR(m.OWNERS,'|VODD|')>0 OR INSTR(m.OWNERS,'|VODE|')>0 OR INSTR(m.OWNERS,'|VODF|')>0 OR INSTR(m.OWNERS,'|VODN|')>0 OR INSTR(m.OWNERS,'|VODS|')>0 OR INSTR(m.OWNERS,'|VS2|')>0 OR INSTR(m.OWNERS,'|VS3|')>0 OR INSTR(m.OWNERS,'|VSAT|')>0 OR INSTR(m.OWNERS,'|VSD|')>0 OR INSTR(m.OWNERS,'|VSD2|')>0 OR INSTR(m.OWNERS,'|VSE|')>0 OR INSTR(m.OWNERS,'|VSG|')>0 OR INSTR(m.OWNERS,'|VSHD|')>0 OR INSTR(m.OWNERS,'|VSS|')>0 OR INSTR(m.OWNERS,'|WCIU|')>0 OR INSTR(m.OWNERS,'|YLE TV1|')>0 OR INSTR(m.OWNERS,'|ZTVS|')>0) order by upper(m.title), m.media_type, m.ec_som, m.id ) a where rownum <= 50) r ,lateral( select l.miid, max(c.C_EXT_OUT_LOC) lib_loc_ext_id, max(c.C_STAT) ctnr_stat, max(c.loan_stat) ctnr_loan_stat from tm_mi_tpi_lnx l, tm_ctnrs c where c.u_id=l.tpiid and l.miid=r.id and r.media_type=1 group by l.miid)(+) lnk ,lateral(select tt.* from tm_text tt where tt.text_id = r.primary_thumb_id2)(+) t ,lateral(select /*+ NO_DECORRELATE */ d.som fsom, d.eom feom, dl.mi_id fmi_id, d.os_fname fos_fname, d.DFILE_LINK_GUID, d.OS_GUID, d.SUB_FOLDER, dl.dfile_id, d.original_filename FROM tm_dfile d, tm_mi_dfile_lnx dl where d.id=dl.dfile_id and r.id=dl.mi_id and rownum=1)(+) dfl where rnum >= 1 order by rnum t Transfer: 1220 : 10|16:21:37.8616|ZpBTf~|TMDDBA|OAuth: /api/user-group-preferences?globals=htmlplayerhotkeys,audioOnFrameForward&_dc=1591629697458 t Transfer: 1220 : 10|16:21:37.8616|ZpBTf~|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:21:37.8616|ZpBTf~|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:21:37.8616|ZpBTf~|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:21:37.8616|ZpBTf~|TMDDBA|OAuth. User logged in: TMDDBA t Transfer: 1220 : 10|16:21:37.8616|ZpBTf~|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:21:37.8616|ZpBTf~|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:21:37.8616|ZpBTf~|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:21:37.8616|ZpBTf~|TMDDBA|imfx v3 API took 0.004s '/api/user-group-preferences?globals=htmlplayerhotkeys,audioOnFrameForward&_dc=1591629697458' t Information: 1220 : 10|16:21:38.0647|xm56X8|TMDDBA| timing: 00:00:00.1122037 t Verbose: 1220 : 10|16:21:38.0647|xm56X8|TMDDBA|imfx v3 API took 0.112s '/api/v3/search/Media?_dc=1591629697437' t Transfer: 1220 : 10|16:21:38.0647|xm56X8|TMDDBA|GetUrl. Storage |Video| filename I:\Video\L0640430.mp4 subfolder t Transfer: 1220 : 10|16:21:38.0647|xm56X8|TMDDBA| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/L0640430.mp4 t Transfer: 1220 : 10|16:21:38.0647|xm56X8|TMDDBA|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/L0640430.mp4 t Transfer: 1220 : 10|16:21:38.0647|xm56X8|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:21:38.0647|xm56X8|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:21:38.0647|xm56X8|TMDDBA| user TMDDBA. t Transfer: 1220 : 10|16:21:38.0647|kgwxoW|TMDDBA|OAuth: /api/lookups/FriendlyNames?_dc=1591629697560 t Transfer: 1220 : 10|16:21:38.0647|kgwxoW|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:21:38.0647|kgwxoW|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:21:38.0647|kgwxoW|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:21:38.0647|kgwxoW|TMDDBA|OAuth. User logged in: TMDDBA t Verbose: 1220 : 10|16:21:38.0647|kgwxoW|TMDDBA|imfx v3 API took 0.000s '/api/lookups/FriendlyNames?_dc=1591629697560' t Transfer: 1220 : 10|16:21:38.0647|kYc65c|TMDDBA|OAuth: /api/v3/detailsview/MediaDetails/5?lang=en-GB&_dc=1591629697560 t Transfer: 1220 : 10|16:21:38.0647|kYc65c|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:21:38.0647|kYc65c|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:21:38.0647|kYc65c|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:21:38.0647|kYc65c|TMDDBA|OAuth. User logged in: TMDDBA t Transfer: 1220 : 10|16:21:38.0647|124ETu|TMDDBA|OAuth: /api/v3/media-captions/291742?_dc=1591629697562 t Transfer: 1220 : 10|16:21:38.0647|124ETu|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:21:38.0647|124ETu|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:21:38.0647|124ETu|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:21:38.0647|124ETu|TMDDBA|OAuth. User logged in: TMDDBA t Information: 1220 : 10|16:21:38.0647|kiqSdV|TMDDBA|V3Api.GetMediaTagging t Verbose: 1220 : 10|16:21:38.0647|124ETu|TMDDBA|imfx v3 API took 0.016s '/api/v3/media-captions/291742?_dc=1591629697562' t Verbose: 1220 : 10|16:21:38.0647|kYc65c|TMDDBA|imfx v3 API took 0.048s '/api/v3/detailsview/MediaDetails/5?lang=en-GB&_dc=1591629697560' t Transfer: 1220 : 10|16:21:38.0647|ob_mGL|TMDDBA|OAuth: /api/v3/mediavideo/291742?info=smudge&_dc=1591629697567 t Transfer: 1220 : 10|16:21:38.0647|ob_mGL|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:21:38.0647|ob_mGL|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:21:38.0647|ob_mGL|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:21:38.0647|ob_mGL|TMDDBA|OAuth. User logged in: TMDDBA t Transfer: 1220 : 10|16:21:38.0647|ob_mGL|TMDDBA|GetUrl. Storage |Video| filename I:\Video\L0640430.mp4 subfolder t Transfer: 1220 : 10|16:21:38.0647|ob_mGL|TMDDBA| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/L0640430.mp4 t Transfer: 1220 : 10|16:21:38.0647|ob_mGL|TMDDBA|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/L0640430.mp4 t Transfer: 1220 : 10|16:21:38.0647|ob_mGL|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:21:38.0647|ob_mGL|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:21:38.0647|ob_mGL|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:21:38.0647|ob_mGL|TMDDBA|imfx v3 API took 0.014s '/api/v3/mediavideo/291742?info=smudge&_dc=1591629697567' t Transfer: 1220 : 10|16:21:38.0647|ztxst0|TMDDBA|OAuth: /api/v3/search/Media?_dc=1591629697654 t Transfer: 1220 : 10|16:21:38.0647|ztxst0|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:21:38.0647|ztxst0|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:21:38.0647|ztxst0|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:21:38.0647|ztxst0|TMDDBA|OAuth. User logged in: TMDDBA t Information: 1220 : 10|16:21:38.0647|ztxst0|TMDDBA|V3Api.SearchMedia t Information: 1220 : 10|16:21:38.0647|ztxst0|TMDDBA|V3Api.SearchGeneric t Transfer: 1220 : 10|16:21:38.0647|ztxst0|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:21:38.0647|ztxst0|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:21:38.0647|ztxst0|TMDDBA| user TMDDBA. t Information: 1220 : 10|16:21:38.0647|ztxst0|TMDDBA|MediaSearch SQL: select r.*, nvl((select TMD_STR_AGG(c.u_id_pfix ) from tm_ctnrs c, tm_mi_tpi_lnx l where l.miid=r.id and c.u_id=l.tpiid and r.media_type=1),'') BARCODE, nvl(lnk.lib_loc_ext_id,0) lib_loc_ext_id, nvl(lnk.ctnr_loan_stat,0) ctnr_loan_status, nvl(lnk.ctnr_stat,0) ctnr_stat, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID , (select tmd_str_agg_pipe(cms.status_type_id ||',' ||cms.status_id) from tm_mi_cust_med_stat_lnx cms where cms.media_id=r.id) "CustomStatusesRaw", GETMEDIALOC(r.id, r.media_type, r.compil, r.m_ctnr_int_o_loc, r.m_ctnr_ext_o_loc, r.m_ctnr_loc) LOCATION, nvl(dfl.fSOM,0) FILE_SOM, nvl(dfl.fEOM,0) FILE_EOM, dfl.fos_fname FILENAME, dfl.DFILE_LINK_GUID, dfl.OS_GUID, dfl.SUB_FOLDER, dfl.ORIGINAL_FILENAME from (select a.*, rownum rnum from (select m.*, coalesce(m.primary_thumb_id, (select v.primary_thumb_id from tm_pg_rl v where v.id=m.pgm_parent_id)) primary_thumb_id2 from tmddba.tm_mis m where media_type>0 and item_type>0 AND m.ID=291742 and m.mi_deleted=0 AND (INSTR(m.OWNERS,'|03BO|')>0 OR INSTR(m.OWNERS,'|03GD|')>0 OR INSTR(m.OWNERS,'|03GO|')>0 OR INSTR(m.OWNERS,'|03HA|')>0 OR INSTR(m.OWNERS,'|03JO|')>0 OR INSTR(m.OWNERS,'|03LI|')>0 OR INSTR(m.OWNERS,'|03NB|')>0 OR INSTR(m.OWNERS,'|03NM|')>0 OR INSTR(m.OWNERS,'|03NO|')>0 OR INSTR(m.OWNERS,'|03OR|')>0 OR INSTR(m.OWNERS,'|03SB|')>0 OR INSTR(m.OWNERS,'|03SC|')>0 OR INSTR(m.OWNERS,'|03SE|')>0 OR INSTR(m.OWNERS,'|03SG|')>0 OR INSTR(m.OWNERS,'|03SK|')>0 OR INSTR(m.OWNERS,'|03SM|')>0 OR INSTR(m.OWNERS,'|03SN|')>0 OR INSTR(m.OWNERS,'|03SS|')>0 OR INSTR(m.OWNERS,'|03SY|')>0 OR INSTR(m.OWNERS,'|03UP|')>0 OR INSTR(m.OWNERS,'|03VA|')>0 OR INSTR(m.OWNERS,'|03VB|')>0 OR INSTR(m.OWNERS,'|03VL|')>0 OR INSTR(m.OWNERS,'|03VT|')>0 OR INSTR(m.OWNERS,'|3+ES|')>0 OR INSTR(m.OWNERS,'|3PD|')>0 OR INSTR(m.OWNERS,'|3PLV|')>0 OR INSTR(m.OWNERS,'|AECHD|')>0 OR INSTR(m.OWNERS,'|AECSD|')>0 OR INSTR(m.OWNERS,'|AL|')>0 OR INSTR(m.OWNERS,'|AMAY|')>0 OR INSTR(m.OWNERS,'|AMC|')>0 OR INSTR(m.OWNERS,'|ATP|')>0 OR INSTR(m.OWNERS,'|BBC|')>0 OR INSTR(m.OWNERS,'|CENT|')>0 OR INSTR(m.OWNERS,'|CS|')>0 OR INSTR(m.OWNERS,'|CTCB|')>0 OR INSTR(m.OWNERS,'|CTCE|')>0 OR INSTR(m.OWNERS,'|DAVI|')>0 OR INSTR(m.OWNERS,'|DMA|')>0 OR INSTR(m.OWNERS,'|DMF|')>0 OR INSTR(m.OWNERS,'|DMY|')>0 OR INSTR(m.OWNERS,'|DTV|')>0 OR INSTR(m.OWNERS,'|EST|')>0 OR INSTR(m.OWNERS,'|EUROSPORT|')>0 OR INSTR(m.OWNERS,'|HDC1|')>0 OR INSTR(m.OWNERS,'|HDP1|')>0 OR INSTR(m.OWNERS,'|HDP2|')>0 OR INSTR(m.OWNERS,'|HUB|')>0 OR INSTR(m.OWNERS,'|ITV|')>0 OR INSTR(m.OWNERS,'|KNL2|')>0 OR INSTR(m.OWNERS,'|KNVA|')>0 OR INSTR(m.OWNERS,'|LMH|')>0 OR INSTR(m.OWNERS,'|LNT|')>0 OR INSTR(m.OWNERS,'|MBNS|')>0 OR INSTR(m.OWNERS,'|MED|')>0 OR INSTR(m.OWNERS,'|MM|')>0 OR INSTR(m.OWNERS,'|MTG|')>0 OR INSTR(m.OWNERS,'|NAA|')>0 OR INSTR(m.OWNERS,'|NICK|')>0 OR INSTR(m.OWNERS,'|NVA|')>0 OR INSTR(m.OWNERS,'|OSP|')>0 OR INSTR(m.OWNERS,'|PBOY|')>0 OR INSTR(m.OWNERS,'|PMS|')>0 OR INSTR(m.OWNERS,'|PPL|')>0 OR INSTR(m.OWNERS,'|PSP|')>0 OR INSTR(m.OWNERS,'|Play|')>0 OR INSTR(m.OWNERS,'|RTR|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|SPG|')>0 OR INSTR(m.OWNERS,'|SPTV|')>0 OR INSTR(m.OWNERS,'|T3LT|')>0 OR INSTR(m.OWNERS,'|T3LV|')>0 OR INSTR(m.OWNERS,'|T6LT|')>0 OR INSTR(m.OWNERS,'|T6LV|')>0 OR INSTR(m.OWNERS,'|T8LT|')>0 OR INSTR(m.OWNERS,'|TECHM|')>0 OR INSTR(m.OWNERS,'|TMD|')>0 OR INSTR(m.OWNERS,'|TV10|')>0 OR INSTR(m.OWNERS,'|TV1A|')>0 OR INSTR(m.OWNERS,'|TV1B|')>0 OR INSTR(m.OWNERS,'|TV1C|')>0 OR INSTR(m.OWNERS,'|TV1D|')>0 OR INSTR(m.OWNERS,'|TV1E|')>0 OR INSTR(m.OWNERS,'|TV1F|')>0 OR INSTR(m.OWNERS,'|TV1K|')>0 OR INSTR(m.OWNERS,'|TV1N|')>0 OR INSTR(m.OWNERS,'|TV1P|')>0 OR INSTR(m.OWNERS,'|TV1S|')>0 OR INSTR(m.OWNERS,'|TV2S|')>0 OR INSTR(m.OWNERS,'|TV3D|')>0 OR INSTR(m.OWNERS,'|TV3N|')>0 OR INSTR(m.OWNERS,'|TV3S|')>0 OR INSTR(m.OWNERS,'|TV5L|')>0 OR INSTR(m.OWNERS,'|TV6E|')>0 OR INSTR(m.OWNERS,'|TV6H|')>0 OR INSTR(m.OWNERS,'|TV6N|')>0 OR INSTR(m.OWNERS,'|TV6S|')>0 OR INSTR(m.OWNERS,'|TV8|')>0 OR INSTR(m.OWNERS,'|TVAE|')>0 OR INSTR(m.OWNERS,'|TVDP|')>0 OR INSTR(m.OWNERS,'|TVPB|')>0 OR INSTR(m.OWNERS,'|TVPU|')>0 OR INSTR(m.OWNERS,'|TVSL|')>0 OR INSTR(m.OWNERS,'|V1G|')>0 OR INSTR(m.OWNERS,'|V1TZ|')>0 OR INSTR(m.OWNERS,'|V3H|')>0 OR INSTR(m.OWNERS,'|V4N|')>0 OR INSTR(m.OWNERS,'|VEC|')>0 OR INSTR(m.OWNERS,'|VEPL|')>0 OR INSTR(m.OWNERS,'|VEPO|')>0 OR INSTR(m.OWNERS,'|VEXE|')>0 OR INSTR(m.OWNERS,'|VEXR|')>0 OR INSTR(m.OWNERS,'|VHIS|')>0 OR INSTR(m.OWNERS,'|VHPO|')>0 OR INSTR(m.OWNERS,'|VNC|')>0 OR INSTR(m.OWNERS,'|VNE|')>0 OR INSTR(m.OWNERS,'|VNH|')>0 OR INSTR(m.OWNERS,'|VNHD|')>0 OR INSTR(m.OWNERS,'|VNPO|')>0 OR INSTR(m.OWNERS,'|VODD|')>0 OR INSTR(m.OWNERS,'|VODE|')>0 OR INSTR(m.OWNERS,'|VODF|')>0 OR INSTR(m.OWNERS,'|VODN|')>0 OR INSTR(m.OWNERS,'|VODS|')>0 OR INSTR(m.OWNERS,'|VS2|')>0 OR INSTR(m.OWNERS,'|VS3|')>0 OR INSTR(m.OWNERS,'|VSAT|')>0 OR INSTR(m.OWNERS,'|VSD|')>0 OR INSTR(m.OWNERS,'|VSD2|')>0 OR INSTR(m.OWNERS,'|VSE|')>0 OR INSTR(m.OWNERS,'|VSG|')>0 OR INSTR(m.OWNERS,'|VSHD|')>0 OR INSTR(m.OWNERS,'|VSS|')>0 OR INSTR(m.OWNERS,'|WCIU|')>0 OR INSTR(m.OWNERS,'|YLE TV1|')>0 OR INSTR(m.OWNERS,'|ZTVS|')>0) order by upper(m.title), m.media_type, m.ec_som, m.id ) a where rownum <= 50) r ,lateral( select l.miid, max(c.C_EXT_OUT_LOC) lib_loc_ext_id, max(c.C_STAT) ctnr_stat, max(c.loan_stat) ctnr_loan_stat from tm_mi_tpi_lnx l, tm_ctnrs c where c.u_id=l.tpiid and l.miid=r.id and r.media_type=1 group by l.miid)(+) lnk ,lateral(select tt.* from tm_text tt where tt.text_id = r.primary_thumb_id2)(+) t ,lateral(select /*+ NO_DECORRELATE */ d.som fsom, d.eom feom, dl.mi_id fmi_id, d.os_fname fos_fname, d.DFILE_LINK_GUID, d.OS_GUID, d.SUB_FOLDER, dl.dfile_id, d.original_filename FROM tm_dfile d, tm_mi_dfile_lnx dl where d.id=dl.dfile_id and r.id=dl.mi_id and rownum=1)(+) dfl where rnum >= 1 order by rnum t Information: 1220 : 10|16:21:38.0647|ztxst0|TMDDBA| timing: 00:00:00.0151358 t Verbose: 1220 : 10|16:21:38.0647|ztxst0|TMDDBA|imfx v3 API took 0.015s '/api/v3/search/Media?_dc=1591629697654' t Transfer: 1220 : 10|16:21:38.0647|ztxst0|TMDDBA|GetUrl. Storage |Video| filename I:\Video\L0640430.mp4 subfolder t Transfer: 1220 : 10|16:21:38.0647|ztxst0|TMDDBA| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/L0640430.mp4 t Transfer: 1220 : 10|16:21:38.0647|ztxst0|TMDDBA|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/L0640430.mp4 t Transfer: 1220 : 10|16:21:38.0647|ztxst0|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:21:38.0647|ztxst0|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:21:38.0647|ztxst0|TMDDBA| user TMDDBA. t Transfer: 1220 : 10|16:21:43.1585|4KMHiy|TMDDBA|OAuth: /api/v3/media-details/291742?_dc=1591629702694 t Transfer: 1220 : 10|16:21:43.1585|4KMHiy|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:21:43.1585|4KMHiy|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:21:43.1585|4KMHiy|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:21:43.1585|4KMHiy|TMDDBA|OAuth. User logged in: TMDDBA t Transfer: 1220 : 10|16:21:43.1585|4KMHiy|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:21:43.1585|4KMHiy|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:21:43.1585|4KMHiy|TMDDBA| user TMDDBA. t Information: 1220 : 10|16:21:43.7679|||TM_MIS. LoadSubtitles for ID: 291742 t Information: 1220 : 10|16:21:43.7679|||TM_MIS. LoadSubtitles for ID: 291742. SQL: 'select id, m_ctnr_id, m_ctnr_loc, modified_dt, tv_std, m_ctnr_fmt_id, nvl((select max(l.language) from tm_audio l where l.miid=m.id),aud_language_id) aud_language_id from tm_mis m where mi_deleted=0 and item_type>0 and media_type=101 and PGM_PARENT_ID=291740' t Information: 1220 : 10|16:21:43.7679|||TM_MIS. LoadSubtitles for ID: 291742 found no subtitles. t Verbose: 1220 : 10|16:21:43.7679|4KMHiy|TMDDBA|imfx v3 API took 0.715s '/api/v3/media-details/291742?_dc=1591629702694' t Transfer: 1220 : 10|16:21:43.7679|4KMHiy|TMDDBA|GetUrl. Storage |Video| filename I:\Video\L0640430.mp4 subfolder t Transfer: 1220 : 10|16:21:43.7679|4KMHiy|TMDDBA| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/L0640430.mp4 t Transfer: 1220 : 10|16:21:43.7679|4KMHiy|TMDDBA|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/L0640430.mp4 t Transfer: 1220 : 10|16:21:43.7679|4KMHiy|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:21:43.7679|4KMHiy|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:21:43.7679|4KMHiy|TMDDBA| user TMDDBA. t Transfer: 1220 : 10|16:21:43.9710|AJ3S8D|TMDDBA|OAuth: /api/v3/media-captions/291742?_dc=1591629703469 t Transfer: 1220 : 10|16:21:43.9710|AJ3S8D|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:21:43.9710|AJ3S8D|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:21:43.9710|AJ3S8D|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:21:43.9710|AJ3S8D|TMDDBA|OAuth. User logged in: TMDDBA t Verbose: 1220 : 10|16:21:43.9710|AJ3S8D|TMDDBA|imfx v3 API took 0.007s '/api/v3/media-captions/291742?_dc=1591629703469' t Transfer: 1220 : 10|16:21:43.9710|wyII7C|TMDDBA|OAuth: /api/v3/mediavideo/291742?info=smudge,scene,audiovolume&_dc=1591629703583 t Transfer: 1220 : 10|16:21:43.9710|wyII7C|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:21:43.9710|wyII7C|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:21:43.9710|wyII7C|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:21:43.9710|wyII7C|TMDDBA|OAuth. User logged in: TMDDBA t Transfer: 1220 : 10|16:21:43.9710|wyII7C|TMDDBA|GetUrl. Storage |Video| filename I:\Video\L0640430.mp4 subfolder t Transfer: 1220 : 10|16:21:43.9710|wyII7C|TMDDBA| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/L0640430.mp4 t Transfer: 1220 : 10|16:21:43.9710|wyII7C|TMDDBA|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/L0640430.mp4 t Transfer: 1220 : 10|16:21:43.9710|wyII7C|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:21:43.9710|wyII7C|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:21:43.9710|wyII7C|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:21:43.9710|wyII7C|TMDDBA|imfx v3 API took 0.023s '/api/v3/mediavideo/291742?info=smudge,scene,audiovolume&_dc=1591629703583' t Transfer: 1220 : 10|16:21:44.3772|gAA3es|TMDDBA|OAuth: /api/user-group-preferences?globals=htmlplayerhotkeys,audioOnFrameForward&_dc=1591629703921 t Transfer: 1220 : 10|16:21:44.3772|gAA3es|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:21:44.3772|gAA3es|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:21:44.3772|gAA3es|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:21:44.3772|gAA3es|TMDDBA|OAuth. User logged in: TMDDBA t Transfer: 1220 : 10|16:21:44.3772|gAA3es|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:21:44.3772|gAA3es|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:21:44.3772|gAA3es|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:21:44.3772|gAA3es|TMDDBA|imfx v3 API took 0.004s '/api/user-group-preferences?globals=htmlplayerhotkeys,audioOnFrameForward&_dc=1591629703921' t Transfer: 1220 : 10|16:21:44.7835|gP9Ion|TMDDBA|OAuth: /api/v3/ai-tags/291742?_dc=1591629704358 t Transfer: 1220 : 10|16:21:44.7835|gP9Ion|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:21:44.7835|gP9Ion|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:21:44.7835|gP9Ion|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:21:44.7835|gP9Ion|TMDDBA|OAuth. User logged in: TMDDBA t Information: 1220 : 10|16:21:44.7835|gP9Ion|TMDDBA|V3Api.GetMediaAiTags t Transfer: 1220 : 10|16:21:44.7835|nLX5iw|TMDDBA|OAuth: /api/v3/mediavideo/291742?info=smudge&_dc=1591629704362 t Transfer: 1220 : 10|16:21:44.7835|nLX5iw|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:21:44.7835|nLX5iw|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:21:44.7835|nLX5iw|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:21:44.7835|nLX5iw|TMDDBA|OAuth. User logged in: TMDDBA t Transfer: 1220 : 10|16:21:44.7835|nLX5iw|TMDDBA|GetUrl. Storage |Video| filename I:\Video\L0640430.mp4 subfolder t Transfer: 1220 : 10|16:21:44.7835|nLX5iw|TMDDBA| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/L0640430.mp4 t Transfer: 1220 : 10|16:21:44.7835|nLX5iw|TMDDBA|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/L0640430.mp4 t Transfer: 1220 : 10|16:21:44.7835|nLX5iw|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:21:44.7835|nLX5iw|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:21:44.7835|nLX5iw|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:21:44.7835|nLX5iw|TMDDBA|imfx v3 API took 0.014s '/api/v3/mediavideo/291742?info=smudge&_dc=1591629704362' t Transfer: 1220 : 10|16:21:44.7835|ziAzha|TMDDBA|OAuth: /api/metadata/4000/291742?_dc=1591629704393 t Transfer: 1220 : 10|16:21:44.7835|ziAzha|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:21:44.7835|ziAzha|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:21:44.7835|ziAzha|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:21:44.7835|ziAzha|TMDDBA|OAuth. User logged in: TMDDBA t Verbose: 1220 : 10|16:21:44.9867|ziAzha|TMDDBA|imfx v3 API took 0.259s '/api/metadata/4000/291742?_dc=1591629704393' t Verbose: 1220 : 10|16:21:46.0022|gP9Ion|TMDDBA|imfx v3 API took 1.155s '/api/v3/ai-tags/291742?_dc=1591629704358' t Transfer: 1220 : 10|16:22:07.1272|FLjWnw|TMDDBA|OAuth: /api/v3/media-details/291743?_dc=1591629726792 t Transfer: 1220 : 10|16:22:07.1272|FLjWnw|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:22:07.1272|FLjWnw|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:22:07.1272|FLjWnw|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:22:07.1272|FLjWnw|TMDDBA|OAuth. User logged in: TMDDBA t Transfer: 1220 : 10|16:22:07.1272|FLjWnw|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:22:07.1272|FLjWnw|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:22:07.1272|FLjWnw|TMDDBA| user TMDDBA. t Information: 1220 : 10|16:22:07.1272|||TM_MIS. LoadSubtitles for ID: 291743 t Information: 1220 : 10|16:22:07.1272|||TM_MIS. LoadSubtitles for ID: 291743. SQL: 'select id, m_ctnr_id, m_ctnr_loc, modified_dt, tv_std, m_ctnr_fmt_id, nvl((select max(l.language) from tm_audio l where l.miid=m.id),aud_language_id) aud_language_id from tm_mis m where mi_deleted=0 and item_type>0 and media_type=101 and PGM_PARENT_ID=291740' t Information: 1220 : 10|16:22:07.3460|||TM_MIS. LoadSubtitles for ID: 291743 found no subtitles. t Verbose: 1220 : 10|16:22:07.3460|FLjWnw|TMDDBA|imfx v3 API took 0.033s '/api/v3/media-details/291743?_dc=1591629726792' t Transfer: 1220 : 10|16:22:07.3460|FLjWnw|TMDDBA|GetUrl. Storage |Video| filename I:\Video\L0640441.mp4 subfolder t Transfer: 1220 : 10|16:22:07.3460|FLjWnw|TMDDBA| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/L0640441.mp4 t Transfer: 1220 : 10|16:22:07.3460|FLjWnw|TMDDBA|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/L0640441.mp4 t Transfer: 1220 : 10|16:22:07.3460|FLjWnw|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:22:07.3460|FLjWnw|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:22:07.3460|FLjWnw|TMDDBA| user TMDDBA. t Transfer: 1220 : 10|16:22:07.3460|K0gVbK|TMDDBA|OAuth: /api/v3/media-captions/291743?_dc=1591629726885 t Transfer: 1220 : 10|16:22:07.3460|K0gVbK|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:22:07.3460|K0gVbK|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:22:07.3460|K0gVbK|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:22:07.3460|K0gVbK|TMDDBA|OAuth. User logged in: TMDDBA t Verbose: 1220 : 10|16:22:07.3460|K0gVbK|TMDDBA|imfx v3 API took 0.015s '/api/v3/media-captions/291743?_dc=1591629726885' t Transfer: 1220 : 10|16:22:07.3460|osVHeo|TMDDBA|OAuth: /api/v3/mediavideo/291743?info=smudge,scene,audiovolume&_dc=1591629726930 t Transfer: 1220 : 10|16:22:07.3460|osVHeo|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:22:07.3460|osVHeo|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:22:07.3460|osVHeo|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:22:07.3460|osVHeo|TMDDBA|OAuth. User logged in: TMDDBA t Transfer: 1220 : 10|16:22:07.3460|osVHeo|TMDDBA|GetUrl. Storage |Video| filename I:\Video\L0640441.mp4 subfolder t Transfer: 1220 : 10|16:22:07.3460|osVHeo|TMDDBA| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/L0640441.mp4 t Transfer: 1220 : 10|16:22:07.3460|osVHeo|TMDDBA|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/L0640441.mp4 t Transfer: 1220 : 10|16:22:07.3460|osVHeo|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:22:07.3460|osVHeo|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:22:07.3460|osVHeo|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:22:07.3460|osVHeo|TMDDBA|imfx v3 API took 0.021s '/api/v3/mediavideo/291743?info=smudge,scene,audiovolume&_dc=1591629726930' t Transfer: 1220 : 10|16:22:07.7522|hrGNKQ|TMDDBA|OAuth: /api/user-group-preferences?globals=htmlplayerhotkeys,audioOnFrameForward&_dc=1591629727312 t Transfer: 1220 : 10|16:22:07.7522|hrGNKQ|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:22:07.7522|hrGNKQ|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:22:07.7522|hrGNKQ|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:22:07.7522|hrGNKQ|TMDDBA|OAuth. User logged in: TMDDBA t Transfer: 1220 : 10|16:22:07.7522|hrGNKQ|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:22:07.7522|hrGNKQ|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:22:07.7522|hrGNKQ|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:22:07.7522|hrGNKQ|TMDDBA|imfx v3 API took 0.003s '/api/user-group-preferences?globals=htmlplayerhotkeys,audioOnFrameForward&_dc=1591629727312' t Transfer: 1220 : 10|16:22:08.1585|1hT_6W|TMDDBA|OAuth: /api/v3/ai-tags/291743?_dc=1591629727752 t Transfer: 1220 : 10|16:22:08.1585|1hT_6W|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:22:08.1585|1hT_6W|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:22:08.1585|1hT_6W|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:22:08.1585|1hT_6W|TMDDBA|OAuth. User logged in: TMDDBA t Information: 1220 : 10|16:22:08.1585|1hT_6W|TMDDBA|V3Api.GetMediaAiTags t Verbose: 1220 : 10|16:22:08.1585|1hT_6W|TMDDBA|imfx v3 API took 0.004s '/api/v3/ai-tags/291743?_dc=1591629727752' t Transfer: 1220 : 10|16:22:08.1585|PezY2U|TMDDBA|OAuth: /api/v3/mediavideo/291743?info=smudge&_dc=1591629727755 t Transfer: 1220 : 10|16:22:08.1585|PezY2U|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:22:08.1585|PezY2U|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:22:08.1585|PezY2U|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:22:08.1585|PezY2U|TMDDBA|OAuth. User logged in: TMDDBA t Transfer: 1220 : 10|16:22:08.1585|PezY2U|TMDDBA|GetUrl. Storage |Video| filename I:\Video\L0640441.mp4 subfolder t Transfer: 1220 : 10|16:22:08.1585|PezY2U|TMDDBA| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/L0640441.mp4 t Transfer: 1220 : 10|16:22:08.1585|PezY2U|TMDDBA|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/L0640441.mp4 t Transfer: 1220 : 10|16:22:08.1585|PezY2U|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:22:08.1585|PezY2U|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:22:08.1585|PezY2U|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:22:08.1585|PezY2U|TMDDBA|imfx v3 API took 0.009s '/api/v3/mediavideo/291743?info=smudge&_dc=1591629727755' t Transfer: 1220 : 10|16:22:08.1585|3IYamh|TMDDBA|OAuth: /api/v3/search/Media?_dc=1591629727777 t Transfer: 1220 : 10|16:22:08.1585|3IYamh|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:22:08.1585|3IYamh|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:22:08.1585|3IYamh|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:22:08.1585|3IYamh|TMDDBA|OAuth. User logged in: TMDDBA t Information: 1220 : 10|16:22:08.1585|3IYamh|TMDDBA|V3Api.SearchMedia t Information: 1220 : 10|16:22:08.1585|3IYamh|TMDDBA|V3Api.SearchGeneric t Transfer: 1220 : 10|16:22:08.1585|3IYamh|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:22:08.1585|3IYamh|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:22:08.1585|3IYamh|TMDDBA| user TMDDBA. t Information: 1220 : 10|16:22:08.1585|3IYamh|TMDDBA|MediaSearch SQL: select r.*, nvl((select TMD_STR_AGG(c.u_id_pfix ) from tm_ctnrs c, tm_mi_tpi_lnx l where l.miid=r.id and c.u_id=l.tpiid and r.media_type=1),'') BARCODE, nvl(lnk.lib_loc_ext_id,0) lib_loc_ext_id, nvl(lnk.ctnr_loan_stat,0) ctnr_loan_status, nvl(lnk.ctnr_stat,0) ctnr_stat, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID , (select tmd_str_agg_pipe(cms.status_type_id ||',' ||cms.status_id) from tm_mi_cust_med_stat_lnx cms where cms.media_id=r.id) "CustomStatusesRaw", GETMEDIALOC(r.id, r.media_type, r.compil, r.m_ctnr_int_o_loc, r.m_ctnr_ext_o_loc, r.m_ctnr_loc) LOCATION, nvl(dfl.fSOM,0) FILE_SOM, nvl(dfl.fEOM,0) FILE_EOM, dfl.fos_fname FILENAME, dfl.DFILE_LINK_GUID, dfl.OS_GUID, dfl.SUB_FOLDER, dfl.ORIGINAL_FILENAME from (select a.*, rownum rnum from (select m.*, coalesce(m.primary_thumb_id, (select v.primary_thumb_id from tm_pg_rl v where v.id=m.pgm_parent_id)) primary_thumb_id2 from tmddba.tm_mis m where media_type>0 and item_type>0 AND m.ID=291743 and m.mi_deleted=0 AND (INSTR(m.OWNERS,'|03BO|')>0 OR INSTR(m.OWNERS,'|03GD|')>0 OR INSTR(m.OWNERS,'|03GO|')>0 OR INSTR(m.OWNERS,'|03HA|')>0 OR INSTR(m.OWNERS,'|03JO|')>0 OR INSTR(m.OWNERS,'|03LI|')>0 OR INSTR(m.OWNERS,'|03NB|')>0 OR INSTR(m.OWNERS,'|03NM|')>0 OR INSTR(m.OWNERS,'|03NO|')>0 OR INSTR(m.OWNERS,'|03OR|')>0 OR INSTR(m.OWNERS,'|03SB|')>0 OR INSTR(m.OWNERS,'|03SC|')>0 OR INSTR(m.OWNERS,'|03SE|')>0 OR INSTR(m.OWNERS,'|03SG|')>0 OR INSTR(m.OWNERS,'|03SK|')>0 OR INSTR(m.OWNERS,'|03SM|')>0 OR INSTR(m.OWNERS,'|03SN|')>0 OR INSTR(m.OWNERS,'|03SS|')>0 OR INSTR(m.OWNERS,'|03SY|')>0 OR INSTR(m.OWNERS,'|03UP|')>0 OR INSTR(m.OWNERS,'|03VA|')>0 OR INSTR(m.OWNERS,'|03VB|')>0 OR INSTR(m.OWNERS,'|03VL|')>0 OR INSTR(m.OWNERS,'|03VT|')>0 OR INSTR(m.OWNERS,'|3+ES|')>0 OR INSTR(m.OWNERS,'|3PD|')>0 OR INSTR(m.OWNERS,'|3PLV|')>0 OR INSTR(m.OWNERS,'|AECHD|')>0 OR INSTR(m.OWNERS,'|AECSD|')>0 OR INSTR(m.OWNERS,'|AL|')>0 OR INSTR(m.OWNERS,'|AMAY|')>0 OR INSTR(m.OWNERS,'|AMC|')>0 OR INSTR(m.OWNERS,'|ATP|')>0 OR INSTR(m.OWNERS,'|BBC|')>0 OR INSTR(m.OWNERS,'|CENT|')>0 OR INSTR(m.OWNERS,'|CS|')>0 OR INSTR(m.OWNERS,'|CTCB|')>0 OR INSTR(m.OWNERS,'|CTCE|')>0 OR INSTR(m.OWNERS,'|DAVI|')>0 OR INSTR(m.OWNERS,'|DMA|')>0 OR INSTR(m.OWNERS,'|DMF|')>0 OR INSTR(m.OWNERS,'|DMY|')>0 OR INSTR(m.OWNERS,'|DTV|')>0 OR INSTR(m.OWNERS,'|EST|')>0 OR INSTR(m.OWNERS,'|EUROSPORT|')>0 OR INSTR(m.OWNERS,'|HDC1|')>0 OR INSTR(m.OWNERS,'|HDP1|')>0 OR INSTR(m.OWNERS,'|HDP2|')>0 OR INSTR(m.OWNERS,'|HUB|')>0 OR INSTR(m.OWNERS,'|ITV|')>0 OR INSTR(m.OWNERS,'|KNL2|')>0 OR INSTR(m.OWNERS,'|KNVA|')>0 OR INSTR(m.OWNERS,'|LMH|')>0 OR INSTR(m.OWNERS,'|LNT|')>0 OR INSTR(m.OWNERS,'|MBNS|')>0 OR INSTR(m.OWNERS,'|MED|')>0 OR INSTR(m.OWNERS,'|MM|')>0 OR INSTR(m.OWNERS,'|MTG|')>0 OR INSTR(m.OWNERS,'|NAA|')>0 OR INSTR(m.OWNERS,'|NICK|')>0 OR INSTR(m.OWNERS,'|NVA|')>0 OR INSTR(m.OWNERS,'|OSP|')>0 OR INSTR(m.OWNERS,'|PBOY|')>0 OR INSTR(m.OWNERS,'|PMS|')>0 OR INSTR(m.OWNERS,'|PPL|')>0 OR INSTR(m.OWNERS,'|PSP|')>0 OR INSTR(m.OWNERS,'|Play|')>0 OR INSTR(m.OWNERS,'|RTR|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|SPG|')>0 OR INSTR(m.OWNERS,'|SPTV|')>0 OR INSTR(m.OWNERS,'|T3LT|')>0 OR INSTR(m.OWNERS,'|T3LV|')>0 OR INSTR(m.OWNERS,'|T6LT|')>0 OR INSTR(m.OWNERS,'|T6LV|')>0 OR INSTR(m.OWNERS,'|T8LT|')>0 OR INSTR(m.OWNERS,'|TECHM|')>0 OR INSTR(m.OWNERS,'|TMD|')>0 OR INSTR(m.OWNERS,'|TV10|')>0 OR INSTR(m.OWNERS,'|TV1A|')>0 OR INSTR(m.OWNERS,'|TV1B|')>0 OR INSTR(m.OWNERS,'|TV1C|')>0 OR INSTR(m.OWNERS,'|TV1D|')>0 OR INSTR(m.OWNERS,'|TV1E|')>0 OR INSTR(m.OWNERS,'|TV1F|')>0 OR INSTR(m.OWNERS,'|TV1K|')>0 OR INSTR(m.OWNERS,'|TV1N|')>0 OR INSTR(m.OWNERS,'|TV1P|')>0 OR INSTR(m.OWNERS,'|TV1S|')>0 OR INSTR(m.OWNERS,'|TV2S|')>0 OR INSTR(m.OWNERS,'|TV3D|')>0 OR INSTR(m.OWNERS,'|TV3N|')>0 OR INSTR(m.OWNERS,'|TV3S|')>0 OR INSTR(m.OWNERS,'|TV5L|')>0 OR INSTR(m.OWNERS,'|TV6E|')>0 OR INSTR(m.OWNERS,'|TV6H|')>0 OR INSTR(m.OWNERS,'|TV6N|')>0 OR INSTR(m.OWNERS,'|TV6S|')>0 OR INSTR(m.OWNERS,'|TV8|')>0 OR INSTR(m.OWNERS,'|TVAE|')>0 OR INSTR(m.OWNERS,'|TVDP|')>0 OR INSTR(m.OWNERS,'|TVPB|')>0 OR INSTR(m.OWNERS,'|TVPU|')>0 OR INSTR(m.OWNERS,'|TVSL|')>0 OR INSTR(m.OWNERS,'|V1G|')>0 OR INSTR(m.OWNERS,'|V1TZ|')>0 OR INSTR(m.OWNERS,'|V3H|')>0 OR INSTR(m.OWNERS,'|V4N|')>0 OR INSTR(m.OWNERS,'|VEC|')>0 OR INSTR(m.OWNERS,'|VEPL|')>0 OR INSTR(m.OWNERS,'|VEPO|')>0 OR INSTR(m.OWNERS,'|VEXE|')>0 OR INSTR(m.OWNERS,'|VEXR|')>0 OR INSTR(m.OWNERS,'|VHIS|')>0 OR INSTR(m.OWNERS,'|VHPO|')>0 OR INSTR(m.OWNERS,'|VNC|')>0 OR INSTR(m.OWNERS,'|VNE|')>0 OR INSTR(m.OWNERS,'|VNH|')>0 OR INSTR(m.OWNERS,'|VNHD|')>0 OR INSTR(m.OWNERS,'|VNPO|')>0 OR INSTR(m.OWNERS,'|VODD|')>0 OR INSTR(m.OWNERS,'|VODE|')>0 OR INSTR(m.OWNERS,'|VODF|')>0 OR INSTR(m.OWNERS,'|VODN|')>0 OR INSTR(m.OWNERS,'|VODS|')>0 OR INSTR(m.OWNERS,'|VS2|')>0 OR INSTR(m.OWNERS,'|VS3|')>0 OR INSTR(m.OWNERS,'|VSAT|')>0 OR INSTR(m.OWNERS,'|VSD|')>0 OR INSTR(m.OWNERS,'|VSD2|')>0 OR INSTR(m.OWNERS,'|VSE|')>0 OR INSTR(m.OWNERS,'|VSG|')>0 OR INSTR(m.OWNERS,'|VSHD|')>0 OR INSTR(m.OWNERS,'|VSS|')>0 OR INSTR(m.OWNERS,'|WCIU|')>0 OR INSTR(m.OWNERS,'|YLE TV1|')>0 OR INSTR(m.OWNERS,'|ZTVS|')>0) order by upper(m.title), m.media_type, m.ec_som, m.id ) a where rownum <= 50) r ,lateral( select l.miid, max(c.C_EXT_OUT_LOC) lib_loc_ext_id, max(c.C_STAT) ctnr_stat, max(c.loan_stat) ctnr_loan_stat from tm_mi_tpi_lnx l, tm_ctnrs c where c.u_id=l.tpiid and l.miid=r.id and r.media_type=1 group by l.miid)(+) lnk ,lateral(select tt.* from tm_text tt where tt.text_id = r.primary_thumb_id2)(+) t ,lateral(select /*+ NO_DECORRELATE */ d.som fsom, d.eom feom, dl.mi_id fmi_id, d.os_fname fos_fname, d.DFILE_LINK_GUID, d.OS_GUID, d.SUB_FOLDER, dl.dfile_id, d.original_filename FROM tm_dfile d, tm_mi_dfile_lnx dl where d.id=dl.dfile_id and r.id=dl.mi_id and rownum=1)(+) dfl where rnum >= 1 order by rnum t Transfer: 1220 : 10|16:22:08.1585|GU6qBq|TMDDBA|OAuth: /api/v3/media-captions/291743?_dc=1591629727780 t Transfer: 1220 : 10|16:22:08.1585|GU6qBq|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:22:08.1585|GU6qBq|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:22:08.1585|GU6qBq|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:22:08.1585|GU6qBq|TMDDBA|OAuth. User logged in: TMDDBA t Information: 1220 : 10|16:22:08.1585|6hVfL_|TMDDBA|V3Api.GetMediaTagging t Verbose: 1220 : 10|16:22:08.1585|GU6qBq|TMDDBA|imfx v3 API took 0.036s '/api/v3/media-captions/291743?_dc=1591629727780' t Transfer: 1220 : 10|16:22:08.3772|Mt1JU6|TMDDBA|OAuth: /api/metadata/4000/291743?_dc=1591629727825 t Transfer: 1220 : 10|16:22:08.3772|Mt1JU6|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:22:08.3772|Mt1JU6|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:22:08.3772|Mt1JU6|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:22:08.3772|Mt1JU6|TMDDBA|OAuth. User logged in: TMDDBA t Verbose: 1220 : 10|16:22:08.3772|Mt1JU6|TMDDBA|imfx v3 API took 0.004s '/api/metadata/4000/291743?_dc=1591629727825' t Information: 1220 : 10|16:22:08.3772|3IYamh|TMDDBA| timing: 00:00:00.1123322 t Verbose: 1220 : 10|16:22:08.3772|3IYamh|TMDDBA|imfx v3 API took 0.112s '/api/v3/search/Media?_dc=1591629727777' t Transfer: 1220 : 10|16:22:08.3772|3IYamh|TMDDBA|GetUrl. Storage |Video| filename I:\Video\L0640441.mp4 subfolder t Transfer: 1220 : 10|16:22:08.3772|3IYamh|TMDDBA| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/L0640441.mp4 t Transfer: 1220 : 10|16:22:08.3772|3IYamh|TMDDBA|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/L0640441.mp4 t Transfer: 1220 : 10|16:22:08.3772|3IYamh|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:22:08.3772|3IYamh|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:22:08.3772|3IYamh|TMDDBA| user TMDDBA. t Transfer: 1220 : 10|16:23:58.4710|KBXdUP|TMDDBA|OAuth: /api/v3/media/related/291743/audio?_dc=1591629837936 t Transfer: 1220 : 10|16:23:58.4710|KBXdUP|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:23:58.4710|KBXdUP|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:23:58.4710|KBXdUP|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:23:58.4710|KBXdUP|TMDDBA|OAuth. User logged in: TMDDBA t Verbose: 1220 : 10|16:23:58.4710|KBXdUP|TMDDBA|imfx v3 API took 0.099s '/api/v3/media/related/291743/audio?_dc=1591629837936' t Transfer: 1220 : 10|16:24:02.3304|1kKPCA|TMDDBA|OAuth: /api/v3/history/8/291743?_dc=1591629841882 t Transfer: 1220 : 10|16:24:02.3304|1kKPCA|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:24:02.3304|1kKPCA|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:24:02.3304|1kKPCA|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:24:02.3304|1kKPCA|TMDDBA|OAuth. User logged in: TMDDBA t Verbose: 1220 : 10|16:24:02.3304|1kKPCA|TMDDBA|imfx v3 API took 0.058s '/api/v3/history/8/291743?_dc=1591629841882' t Transfer: 1220 : 10|16:24:03.3460|SlpS80|TMDDBA|OAuth: /api/v3/media-reports/291743?_dc=1591629842832 t Transfer: 1220 : 10|16:24:03.3460|SlpS80|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:24:03.3460|SlpS80|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:24:03.3460|SlpS80|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:24:03.3460|SlpS80|TMDDBA|OAuth. User logged in: TMDDBA t Verbose: 1220 : 10|16:24:03.3460|SlpS80|TMDDBA|imfx v3 API took 0.062s '/api/v3/media-reports/291743?_dc=1591629842832' t Transfer: 1220 : 10|16:24:09.8460|m5O9Vu|TMDDBA|OAuth: /api/lookups/AvFaultType?_dc=1591629849420 t Transfer: 1220 : 10|16:24:09.8460|m5O9Vu|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:24:09.8460|m5O9Vu|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:24:09.8460|m5O9Vu|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:24:09.8460|m5O9Vu|TMDDBA|OAuth. User logged in: TMDDBA t Verbose: 1220 : 10|16:24:09.8460|m5O9Vu|TMDDBA|imfx v3 API took 0.020s '/api/lookups/AvFaultType?_dc=1591629849420' t Information: 1220 : 10|16:24:11.2991|05V9PE|TMDDBA|V3 Api exception handler: Devart.Data.Oracle.OracleException (0x80004005): ORA-04088: error during execution of trigger 'SYS.TRG_ERROR_LOGGING' ORA-00604: error occurred at recursive SQL level 1 ORA-01653: unable to extend table SYS.ERROR_LOG by 8192 in tablespace SYSTEM ORA-06512: at line 17 ORA-00942: table or view does not exist at Devart.Data.Oracle.bq.d(Int32 A_0) at Devart.Data.Oracle.d0.a(Int32 A_0, ek A_1) at Devart.Data.Oracle.OracleCommand.InternalExecute(CommandBehavior behavior, IDisposable disposable, Int32 startRecord, Int32 maxRecords, Boolean nonQuery) at Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior, Boolean nonQuery) at Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior) at Devart.Data.Oracle.OracleCommand.ExecuteReader() at iMfxServerCore.Api.v3.MediaDetailsController.GetMediaGeoLocation(Int32 id) in C:\BuildAgent2\work\405c64e443a47d83\Server\iMfxServerCore\api\controllers\v3\MediaDetailsController.cs:line 162 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.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.Controllers.ExceptionFilterResult.d__6.MoveNext() [GET] https://imfxv3tm.tmd.tv/api/v3/media/291743/geolocation?_dc=1591629850833 System.Web.Http.Routing.HttpRoute t Transfer: 1220 : 10|16:26:24.5960|dx5fZS||GetAppInfo. DB: TMDDEMO. Install mode: . Auth types: Native, PublicApiKey t Information: 1220 : 10|16:26:24.5960|SAhccO||GetCache. t Information: 1220 : 10|16:26:24.5960|SAhccO||GetCache. Found: C:\inetpub\wwwroot\imfxcore\VisualAssetsCache\4_2_M6I_N7.png t Information: 1220 : 10|16:26:24.5960|SAhccO||GetCache. Data read: 461845 t Verbose: 1220 : 10|16:26:24.5960|SAhccO||imfx v3 API took 0.008s '/api/v3/visual-asset/group/M6I_N7/2/image' t Verbose: 1220 : 10|16:26:26.2210|vsL5vQ||Oauth validating.. t Verbose: 1220 : 10|16:26:26.2210|vsL5vQ||GrantResourceOwnerCredentials. t Verbose: 1220 : 10|16:26:26.2210|vsL5vQ||LoginUser. tmddba, login type OAuth, encrypt password True t Information: 1220 : 10|16:26:26.2210|vsL5vQ||TryLoginUser. tmddba, login type OAuth, check password True, check hash False, encrypt password True, load user data False t Information: 1220 : 10|16:26:26.2210|vsL5vQ|| oauth token 00000000-0000-0000-0000-000000000000 t Information: 1220 : 10|16:26:26.2210|vsL5vQ||TryLoginUser. Logged in.. t Verbose: 1220 : 10|16:26:26.2210|vsL5vQ||LoginUser. Adding history. User Id 1, result TMDDBA, host 192.168.127.7 t Verbose: 1220 : 10|16:26:26.2210|vsL5vQ||GrantResourceOwnerCredentials. Try login finished. Logged: True t Transfer: 1220 : 10|16:26:26.4241|PHmYrI|TMDDBA|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,helpdeskUrl&globals=isDebugMode,htmlplayerhotkeys,versionCreationSettings,associate.advanced_search.version.setups,associate.advanced_search.media.setups,associate.wfrise.setups,supplier_portal.advanced_search.version.setups,helpdeskUrl&_dc=1591629985339 t Transfer: 1220 : 10|16:26:26.4241|PHmYrI|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:26:26.4241|PHmYrI|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:26:26.4241|PHmYrI|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:26:26.4241|PHmYrI|TMDDBA|OAuth. User logged in: TMDDBA t Transfer: 1220 : 10|16:26:26.4241|PHmYrI|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:26:26.4241|PHmYrI|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:26:26.4241|PHmYrI|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:26:26.4241|PHmYrI|TMDDBA|imfx v3 API took 0.027s '/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,helpdeskUrl&globals=isDebugMode,htmlplayerhotkeys,versionCreationSettings,associate.advanced_search.version.setups,associate.advanced_search.media.setups,associate.wfrise.setups,supplier_portal.advanced_search.version.setups,helpdeskUrl&_dc=1591629985339' t Transfer: 1220 : 10|16:26:26.4241|jGw1XY|TMDDBA|OAuth: /api/user-preferences?keys=personal_settings;basket;default_page;color_schema;media.basket.data;defaultSearch&_dc=1591629985452 t Transfer: 1220 : 10|16:26:26.4241|jGw1XY|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:26:26.4241|jGw1XY|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:26:26.4241|jGw1XY|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:26:26.4241|jGw1XY|TMDDBA|OAuth. User logged in: TMDDBA t Information: 1220 : 10|16:26:26.4241|jGw1XY|TMDDBA|GetUserDataByKeys: personal_settings;basket;default_page;color_schema;media.basket.data;defaultSearch t Transfer: 1220 : 10|16:26:26.4241|jGw1XY|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:26:26.4241|jGw1XY|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:26:26.4241|jGw1XY|TMDDBA| user TMDDBA. t Transfer: 1220 : 10|16:26:26.4241|pMX2c_|TMDDBA|OAuth: /api/lookups/MediaStatus?_dc=1591629985453 t Transfer: 1220 : 10|16:26:26.4241|pMX2c_|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:26:26.4241|pMX2c_|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:26:26.4241|pMX2c_|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:26:26.4241|pMX2c_|TMDDBA|OAuth. User logged in: TMDDBA t Verbose: 1220 : 10|16:26:26.4241|pMX2c_|TMDDBA|imfx v3 API took 0.000s '/api/lookups/MediaStatus?_dc=1591629985453' t Transfer: 1220 : 10|16:26:26.4241|GR~kjp|TMDDBA|OAuth: /api/lookups/PgmStatus?_dc=1591629985453 t Transfer: 1220 : 10|16:26:26.4241|GR~kjp|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:26:26.4241|GR~kjp|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:26:26.4241|GR~kjp|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:26:26.4241|GR~kjp|TMDDBA|OAuth. User logged in: TMDDBA t Verbose: 1220 : 10|16:26:26.4241|GR~kjp|TMDDBA|imfx v3 API took 0.000s '/api/lookups/PgmStatus?_dc=1591629985453' t Verbose: 1220 : 10|16:26:26.4241|jGw1XY|TMDDBA|imfx v3 API took 0.016s '/api/user-preferences?keys=personal_settings;basket;default_page;color_schema;media.basket.data;defaultSearch&_dc=1591629985452' t Information: 1220 : 10|16:26:26.6272|ayDubH|TMDDBA|GetUserProfile. Id: 0 t Transfer: 1220 : 10|16:26:26.6272|ayDubH|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:26:26.6272|ayDubH|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:26:26.6272|ayDubH|TMDDBA| user TMDDBA. t Transfer: 1220 : 10|16:26:26.6272|0Y2fGI|TMDDBA|OAuth: /api/settings/user/uploadSettings?_dc=1591629985662 t Transfer: 1220 : 10|16:26:26.6272|0Y2fGI|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:26:26.6272|0Y2fGI|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:26:26.6272|0Y2fGI|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:26:26.6272|0Y2fGI|TMDDBA|OAuth. User logged in: TMDDBA t Transfer: 1220 : 10|16:26:26.6272|0Y2fGI|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:26:26.6272|0Y2fGI|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:26:26.6272|0Y2fGI|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:26:26.6272|0Y2fGI|TMDDBA|imfx v3 API took 0.003s '/api/settings/user/uploadSettings?_dc=1591629985662' t Transfer: 1220 : 10|16:26:26.6272|g~ygLX|TMDDBA|OAuth: /api/settings/user/defaultHomePage?_dc=1591629985676 t Transfer: 1220 : 10|16:26:26.6272|g~ygLX|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:26:26.6272|g~ygLX|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:26:26.6272|g~ygLX|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:26:26.6272|g~ygLX|TMDDBA|OAuth. User logged in: TMDDBA t Transfer: 1220 : 10|16:26:26.6272|g~ygLX|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:26:26.6272|g~ygLX|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:26:26.6272|g~ygLX|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:26:26.6272|g~ygLX|TMDDBA|imfx v3 API took 0.003s '/api/settings/user/defaultHomePage?_dc=1591629985676' t Information: 1220 : 10|16:26:26.8304|rsGmpV||GetCache. t Information: 1220 : 10|16:26:26.8304|rsGmpV||GetCache. Found: C:\inetpub\wwwroot\imfxcore\VisualAssetsCache\2_1_M6I_N7.png t Information: 1220 : 10|16:26:26.8304|rsGmpV||GetCache. Data read: 58299 t Verbose: 1220 : 10|16:26:26.8304|rsGmpV||imfx v3 API took 0.082s '/api/v3/visual-asset/group/M6I_N7/1/image' t Information: 1220 : 10|16:26:26.8304|5Rd9oH||GetCache. t Information: 1220 : 10|16:26:26.8304|5Rd9oH||GetCache. Found: C:\inetpub\wwwroot\imfxcore\VisualAssetsCache\1_0_M6I_N7.png t Information: 1220 : 10|16:26:26.8304|5Rd9oH||GetCache. Data read: 58299 t Verbose: 1220 : 10|16:26:26.8304|5Rd9oH||imfx v3 API took 0.086s '/api/v3/visual-asset/group/M6I_N7/0/image' t Transfer: 1220 : 10|16:26:27.8460|ReYxxt|TMDDBA|OAuth: /api/v3/media-details/291743?_dc=1591629986795 t Transfer: 1220 : 10|16:26:27.8460|ReYxxt|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:26:27.8460|ReYxxt|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:26:27.8460|ReYxxt|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:26:27.8460|ReYxxt|TMDDBA|OAuth. User logged in: TMDDBA t Transfer: 1220 : 10|16:26:27.8460|ReYxxt|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:26:27.8460|ReYxxt|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:26:27.8460|ReYxxt|TMDDBA| user TMDDBA. t Information: 1220 : 10|16:26:27.8460|||TM_MIS. LoadSubtitles for ID: 291743 t Information: 1220 : 10|16:26:27.8460|||TM_MIS. LoadSubtitles for ID: 291743. SQL: 'select id, m_ctnr_id, m_ctnr_loc, modified_dt, tv_std, m_ctnr_fmt_id, nvl((select max(l.language) from tm_audio l where l.miid=m.id),aud_language_id) aud_language_id from tm_mis m where mi_deleted=0 and item_type>0 and media_type=101 and PGM_PARENT_ID=291740' t Information: 1220 : 10|16:26:27.8460|||TM_MIS. LoadSubtitles for ID: 291743 found no subtitles. t Verbose: 1220 : 10|16:26:27.8460|ReYxxt|TMDDBA|imfx v3 API took 0.089s '/api/v3/media-details/291743?_dc=1591629986795' t Transfer: 1220 : 10|16:26:27.8460|ReYxxt|TMDDBA|GetUrl. Storage |Video| filename I:\Video\L0640441.mp4 subfolder t Transfer: 1220 : 10|16:26:27.8460|ReYxxt|TMDDBA| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/L0640441.mp4 t Transfer: 1220 : 10|16:26:27.8460|ReYxxt|TMDDBA|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/L0640441.mp4 t Transfer: 1220 : 10|16:26:27.8460|ReYxxt|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:26:27.8460|ReYxxt|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:26:27.8460|ReYxxt|TMDDBA| user TMDDBA. t Transfer: 1220 : 10|16:26:28.0491|5qef1z|TMDDBA|OAuth: /api/v3/detailsview/MediaDetails/5?lang=en-GB&_dc=1591629986978 t Transfer: 1220 : 10|16:26:28.0491|5qef1z|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:26:28.0491|5qef1z|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:26:28.0491|5qef1z|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:26:28.0491|5qef1z|TMDDBA|OAuth. User logged in: TMDDBA t Verbose: 1220 : 10|16:26:28.0491|5qef1z|TMDDBA|imfx v3 API took 0.002s '/api/v3/detailsview/MediaDetails/5?lang=en-GB&_dc=1591629986978' t Transfer: 1220 : 10|16:26:28.0491|W95FNc|TMDDBA|OAuth: /api/v3/media-captions/291743?_dc=1591629987071 t Transfer: 1220 : 10|16:26:28.0491|W95FNc|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:26:28.0491|W95FNc|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:26:28.0491|W95FNc|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:26:28.0491|W95FNc|TMDDBA|OAuth. User logged in: TMDDBA t Verbose: 1220 : 10|16:26:28.0491|W95FNc|TMDDBA|imfx v3 API took 0.029s '/api/v3/media-captions/291743?_dc=1591629987071' t Transfer: 1220 : 10|16:26:28.0491|ba6TeJ|TMDDBA|OAuth: /api/v3/mediavideo/291743?info=smudge,scene,audiovolume&_dc=1591629987131 t Transfer: 1220 : 10|16:26:28.0491|ba6TeJ|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:26:28.0491|ba6TeJ|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:26:28.0491|ba6TeJ|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:26:28.0491|ba6TeJ|TMDDBA|OAuth. User logged in: TMDDBA t Transfer: 1220 : 10|16:26:28.0491|ba6TeJ|TMDDBA|GetUrl. Storage |Video| filename I:\Video\L0640441.mp4 subfolder t Transfer: 1220 : 10|16:26:28.0491|ba6TeJ|TMDDBA| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/L0640441.mp4 t Transfer: 1220 : 10|16:26:28.0491|ba6TeJ|TMDDBA|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/L0640441.mp4 t Transfer: 1220 : 10|16:26:28.0491|ba6TeJ|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:26:28.0491|ba6TeJ|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:26:28.0491|ba6TeJ|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:26:28.2523|ba6TeJ|TMDDBA|imfx v3 API took 0.028s '/api/v3/mediavideo/291743?info=smudge,scene,audiovolume&_dc=1591629987131' t Transfer: 1220 : 10|16:26:28.2523|CSAw3k|TMDDBA|OAuth: /api/lookups/FriendlyNames?_dc=1591629987278 t Transfer: 1220 : 10|16:26:28.2523|CSAw3k|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:26:28.2523|CSAw3k|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:26:28.2523|CSAw3k|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:26:28.2523|CSAw3k|TMDDBA|OAuth. User logged in: TMDDBA t Verbose: 1220 : 10|16:26:28.2523|CSAw3k|TMDDBA|imfx v3 API took 0.000s '/api/lookups/FriendlyNames?_dc=1591629987278' t Transfer: 1220 : 10|16:26:28.2523|0FiZFb|TMDDBA|OAuth: /api/user-group-preferences?globals=htmlplayerhotkeys,audioOnFrameForward&_dc=1591629987317 t Transfer: 1220 : 10|16:26:28.2523|0FiZFb|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:26:28.2523|0FiZFb|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:26:28.2523|0FiZFb|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:26:28.2523|0FiZFb|TMDDBA|OAuth. User logged in: TMDDBA t Transfer: 1220 : 10|16:26:28.2523|0FiZFb|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:26:28.2523|0FiZFb|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:26:28.2523|0FiZFb|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:26:28.2523|0FiZFb|TMDDBA|imfx v3 API took 0.003s '/api/user-group-preferences?globals=htmlplayerhotkeys,audioOnFrameForward&_dc=1591629987317' t Transfer: 1220 : 10|16:26:28.6585|lk35aW|TMDDBA|OAuth: /api/v3/ai-tags/291743?_dc=1591629987647 t Transfer: 1220 : 10|16:26:28.6585|lk35aW|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:26:28.6585|lk35aW|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:26:28.6585|lk35aW|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:26:28.6585|lk35aW|TMDDBA|OAuth. User logged in: TMDDBA t Information: 1220 : 10|16:26:28.6585|lk35aW|TMDDBA|V3Api.GetMediaAiTags t Transfer: 1220 : 10|16:26:28.6585|sRPede|TMDDBA|OAuth: /api/v3/mediavideo/291743?info=smudge&_dc=1591629987649 t Transfer: 1220 : 10|16:26:28.6585|sRPede|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:26:28.6585|sRPede|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:26:28.6585|sRPede|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:26:28.6585|sRPede|TMDDBA|OAuth. User logged in: TMDDBA t Transfer: 1220 : 10|16:26:28.6585|sRPede|TMDDBA|GetUrl. Storage |Video| filename I:\Video\L0640441.mp4 subfolder t Transfer: 1220 : 10|16:26:28.6585|sRPede|TMDDBA| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/L0640441.mp4 t Transfer: 1220 : 10|16:26:28.6585|sRPede|TMDDBA|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/L0640441.mp4 t Transfer: 1220 : 10|16:26:28.6585|sRPede|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:26:28.6585|sRPede|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:26:28.6585|sRPede|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:26:28.6585|lk35aW|TMDDBA|imfx v3 API took 0.005s '/api/v3/ai-tags/291743?_dc=1591629987647' t Verbose: 1220 : 10|16:26:28.6585|sRPede|TMDDBA|imfx v3 API took 0.011s '/api/v3/mediavideo/291743?info=smudge&_dc=1591629987649' t Transfer: 1220 : 10|16:26:28.6585|CcWeAF|TMDDBA|OAuth: /api/metadata/4000/291743?_dc=1591629987681 t Transfer: 1220 : 10|16:26:28.6585|CcWeAF|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:26:28.6585|CcWeAF|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:26:28.6585|CcWeAF|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:26:28.6585|CcWeAF|TMDDBA|OAuth. User logged in: TMDDBA t Verbose: 1220 : 10|16:26:28.6585|CcWeAF|TMDDBA|imfx v3 API took 0.003s '/api/metadata/4000/291743?_dc=1591629987681' t Transfer: 1220 : 10|16:26:47.9554|ZX~baE|TMDDBA|OAuth: /api/view/searchinfo/Media?_dc=1591630006974 t Transfer: 1220 : 10|16:26:47.9554|ZX~baE|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:26:47.9554|ZX~baE|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:26:47.9554|ZX~baE|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:26:47.9554|ZX~baE|TMDDBA|OAuth. User logged in: TMDDBA t Information: 1220 : 10|16:26:47.9554|ZX~baE|TMDDBA|GetAdvSearchColumns. search type Media grid . t Verbose: 1220 : 10|16:26:47.9554|ZX~baE|TMDDBA|imfx v3 API took 0.000s '/api/view/searchinfo/Media?_dc=1591630006974' t Transfer: 1220 : 10|16:26:47.9554|uYoWkR|TMDDBA|OAuth: /api/lookups/SearchSupportedOperators?_dc=1591630006974 t Transfer: 1220 : 10|16:26:47.9554|uYoWkR|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:26:47.9554|uYoWkR|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:26:47.9554|uYoWkR|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:26:47.9554|uYoWkR|TMDDBA|OAuth. User logged in: TMDDBA t Verbose: 1220 : 10|16:26:47.9554|uYoWkR|TMDDBA|imfx v3 API took 0.000s '/api/lookups/SearchSupportedOperators?_dc=1591630006974' t Transfer: 1220 : 10|16:26:47.9554|EM5UAH|TMDDBA|OAuth: /api/user-preferences?keys=adv.recent.searches.media&_dc=1591630006975 t Transfer: 1220 : 10|16:26:47.9554|EM5UAH|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:26:47.9554|EM5UAH|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:26:47.9554|EM5UAH|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:26:47.9554|EM5UAH|TMDDBA|OAuth. User logged in: TMDDBA t Information: 1220 : 10|16:26:47.9554|EM5UAH|TMDDBA|GetUserDataByKeys: adv.recent.searches.media t Transfer: 1220 : 10|16:26:47.9554|EM5UAH|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:26:47.9554|EM5UAH|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:26:47.9554|EM5UAH|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:26:47.9554|EM5UAH|TMDDBA|imfx v3 API took 0.006s '/api/user-preferences?keys=adv.recent.searches.media&_dc=1591630006975' t Transfer: 1220 : 10|16:26:47.9554|bXzZMR|TMDDBA|OAuth: /api/view/searches/Media?_dc=1591630006996 t Transfer: 1220 : 10|16:26:47.9554|bXzZMR|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:26:47.9554|bXzZMR|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:26:47.9554|bXzZMR|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:26:47.9554|bXzZMR|TMDDBA|OAuth. User logged in: TMDDBA t Information: 1220 : 10|16:26:47.9554|bXzZMR|TMDDBA|GetSavedSearchNames. search type Media. t Transfer: 1220 : 10|16:26:47.9554|bXzZMR|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:26:47.9554|bXzZMR|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:26:47.9554|bXzZMR|TMDDBA| user TMDDBA. t Transfer: 1220 : 10|16:26:47.9554|iymdOg|TMDDBA|OAuth: /api/view/info/MediaGrid?lang=en-GB&_dc=1591630006998 t Transfer: 1220 : 10|16:26:47.9554|iymdOg|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:26:47.9554|iymdOg|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:26:47.9554|iymdOg|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:26:47.9554|iymdOg|TMDDBA|OAuth. User logged in: TMDDBA t Information: 1220 : 10|16:26:47.9554|iymdOg|TMDDBA|GetGridViewBuilder. builder type MediaGrid. t Transfer: 1220 : 10|16:26:47.9554|iymdOg|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:26:47.9554|iymdOg|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:26:47.9554|iymdOg|TMDDBA| user TMDDBA. t Information: 1220 : 10|16:26:47.9554|iymdOg|TMDDBA|UserGridView. LoadView. ID 311, Name Default. t Transfer: 1220 : 10|16:26:47.9554|iymdOg|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:26:47.9554|iymdOg|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:26:47.9554|iymdOg|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:26:47.9554|bXzZMR|TMDDBA|imfx v3 API took 0.005s '/api/view/searches/Media?_dc=1591630006996' t Transfer: 1220 : 10|16:26:47.9554|iymdOg|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:26:47.9554|iymdOg|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:26:47.9554|iymdOg|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:26:47.9554|iymdOg|TMDDBA|imfx v3 API took 0.007s '/api/view/info/MediaGrid?lang=en-GB&_dc=1591630006998' t Transfer: 1220 : 10|16:26:47.9554|ki8t5d|TMDDBA|OAuth: /api/settings/user/searchLayoutConfig?_dc=1591630006998 t Transfer: 1220 : 10|16:26:47.9554|ki8t5d|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:26:47.9554|ki8t5d|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:26:47.9554|ki8t5d|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:26:47.9554|ki8t5d|TMDDBA|OAuth. User logged in: TMDDBA t Transfer: 1220 : 10|16:26:47.9554|ki8t5d|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:26:47.9554|ki8t5d|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:26:47.9554|ki8t5d|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:26:48.1741|ki8t5d|TMDDBA|imfx v3 API took 0.003s '/api/settings/user/searchLayoutConfig?_dc=1591630006998' t Transfer: 1220 : 10|16:26:53.6585|FnOnKE|TMDDBA|OAuth: /api/v3/search/Media?_dc=1591630012635 t Transfer: 1220 : 10|16:26:53.6585|FnOnKE|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:26:53.6585|FnOnKE|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:26:53.6585|FnOnKE|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:26:53.6585|FnOnKE|TMDDBA|OAuth. User logged in: TMDDBA t Information: 1220 : 10|16:26:53.6585|FnOnKE|TMDDBA|V3Api.SearchMedia t Information: 1220 : 10|16:26:53.6585|FnOnKE|TMDDBA|V3Api.SearchGeneric t Transfer: 1220 : 10|16:26:53.6585|FnOnKE|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:26:53.6585|FnOnKE|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:26:53.6585|FnOnKE|TMDDBA| user TMDDBA. t Information: 1220 : 10|16:26:53.6585|FnOnKE|TMDDBA|MediaSearch SQL: select r.*, nvl((select TMD_STR_AGG(c.u_id_pfix ) from tm_ctnrs c, tm_mi_tpi_lnx l where l.miid=r.id and c.u_id=l.tpiid and r.media_type=1),'') BARCODE, nvl(lnk.lib_loc_ext_id,0) lib_loc_ext_id, nvl(lnk.ctnr_loan_stat,0) ctnr_loan_status, nvl(lnk.ctnr_stat,0) ctnr_stat, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID , (select tmd_str_agg_pipe(cms.status_type_id ||',' ||cms.status_id) from tm_mi_cust_med_stat_lnx cms where cms.media_id=r.id) "CustomStatusesRaw", GETMEDIALOC(r.id, r.media_type, r.compil, r.m_ctnr_int_o_loc, r.m_ctnr_ext_o_loc, r.m_ctnr_loc) LOCATION, nvl(dfl.fSOM,0) FILE_SOM, nvl(dfl.fEOM,0) FILE_EOM, dfl.fos_fname FILENAME, dfl.DFILE_LINK_GUID, dfl.OS_GUID, dfl.SUB_FOLDER, dfl.ORIGINAL_FILENAME from (select a.*, rownum rnum from (select m.*, coalesce(m.primary_thumb_id, (select v.primary_thumb_id from tm_pg_rl v where v.id=m.pgm_parent_id)) primary_thumb_id2 from tmddba.tm_mis m where media_type>0 and item_type>0 AND m.ID=291743 and m.mi_deleted=0 AND (INSTR(m.OWNERS,'|03BO|')>0 OR INSTR(m.OWNERS,'|03GD|')>0 OR INSTR(m.OWNERS,'|03GO|')>0 OR INSTR(m.OWNERS,'|03HA|')>0 OR INSTR(m.OWNERS,'|03JO|')>0 OR INSTR(m.OWNERS,'|03LI|')>0 OR INSTR(m.OWNERS,'|03NB|')>0 OR INSTR(m.OWNERS,'|03NM|')>0 OR INSTR(m.OWNERS,'|03NO|')>0 OR INSTR(m.OWNERS,'|03OR|')>0 OR INSTR(m.OWNERS,'|03SB|')>0 OR INSTR(m.OWNERS,'|03SC|')>0 OR INSTR(m.OWNERS,'|03SE|')>0 OR INSTR(m.OWNERS,'|03SG|')>0 OR INSTR(m.OWNERS,'|03SK|')>0 OR INSTR(m.OWNERS,'|03SM|')>0 OR INSTR(m.OWNERS,'|03SN|')>0 OR INSTR(m.OWNERS,'|03SS|')>0 OR INSTR(m.OWNERS,'|03SY|')>0 OR INSTR(m.OWNERS,'|03UP|')>0 OR INSTR(m.OWNERS,'|03VA|')>0 OR INSTR(m.OWNERS,'|03VB|')>0 OR INSTR(m.OWNERS,'|03VL|')>0 OR INSTR(m.OWNERS,'|03VT|')>0 OR INSTR(m.OWNERS,'|3+ES|')>0 OR INSTR(m.OWNERS,'|3PD|')>0 OR INSTR(m.OWNERS,'|3PLV|')>0 OR INSTR(m.OWNERS,'|AECHD|')>0 OR INSTR(m.OWNERS,'|AECSD|')>0 OR INSTR(m.OWNERS,'|AL|')>0 OR INSTR(m.OWNERS,'|AMAY|')>0 OR INSTR(m.OWNERS,'|AMC|')>0 OR INSTR(m.OWNERS,'|ATP|')>0 OR INSTR(m.OWNERS,'|BBC|')>0 OR INSTR(m.OWNERS,'|CENT|')>0 OR INSTR(m.OWNERS,'|CS|')>0 OR INSTR(m.OWNERS,'|CTCB|')>0 OR INSTR(m.OWNERS,'|CTCE|')>0 OR INSTR(m.OWNERS,'|DAVI|')>0 OR INSTR(m.OWNERS,'|DMA|')>0 OR INSTR(m.OWNERS,'|DMF|')>0 OR INSTR(m.OWNERS,'|DMY|')>0 OR INSTR(m.OWNERS,'|DTV|')>0 OR INSTR(m.OWNERS,'|EST|')>0 OR INSTR(m.OWNERS,'|EUROSPORT|')>0 OR INSTR(m.OWNERS,'|HDC1|')>0 OR INSTR(m.OWNERS,'|HDP1|')>0 OR INSTR(m.OWNERS,'|HDP2|')>0 OR INSTR(m.OWNERS,'|HUB|')>0 OR INSTR(m.OWNERS,'|ITV|')>0 OR INSTR(m.OWNERS,'|KNL2|')>0 OR INSTR(m.OWNERS,'|KNVA|')>0 OR INSTR(m.OWNERS,'|LMH|')>0 OR INSTR(m.OWNERS,'|LNT|')>0 OR INSTR(m.OWNERS,'|MBNS|')>0 OR INSTR(m.OWNERS,'|MED|')>0 OR INSTR(m.OWNERS,'|MM|')>0 OR INSTR(m.OWNERS,'|MTG|')>0 OR INSTR(m.OWNERS,'|NAA|')>0 OR INSTR(m.OWNERS,'|NICK|')>0 OR INSTR(m.OWNERS,'|NVA|')>0 OR INSTR(m.OWNERS,'|OSP|')>0 OR INSTR(m.OWNERS,'|PBOY|')>0 OR INSTR(m.OWNERS,'|PMS|')>0 OR INSTR(m.OWNERS,'|PPL|')>0 OR INSTR(m.OWNERS,'|PSP|')>0 OR INSTR(m.OWNERS,'|Play|')>0 OR INSTR(m.OWNERS,'|RTR|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|SPG|')>0 OR INSTR(m.OWNERS,'|SPTV|')>0 OR INSTR(m.OWNERS,'|T3LT|')>0 OR INSTR(m.OWNERS,'|T3LV|')>0 OR INSTR(m.OWNERS,'|T6LT|')>0 OR INSTR(m.OWNERS,'|T6LV|')>0 OR INSTR(m.OWNERS,'|T8LT|')>0 OR INSTR(m.OWNERS,'|TECHM|')>0 OR INSTR(m.OWNERS,'|TMD|')>0 OR INSTR(m.OWNERS,'|TV10|')>0 OR INSTR(m.OWNERS,'|TV1A|')>0 OR INSTR(m.OWNERS,'|TV1B|')>0 OR INSTR(m.OWNERS,'|TV1C|')>0 OR INSTR(m.OWNERS,'|TV1D|')>0 OR INSTR(m.OWNERS,'|TV1E|')>0 OR INSTR(m.OWNERS,'|TV1F|')>0 OR INSTR(m.OWNERS,'|TV1K|')>0 OR INSTR(m.OWNERS,'|TV1N|')>0 OR INSTR(m.OWNERS,'|TV1P|')>0 OR INSTR(m.OWNERS,'|TV1S|')>0 OR INSTR(m.OWNERS,'|TV2S|')>0 OR INSTR(m.OWNERS,'|TV3D|')>0 OR INSTR(m.OWNERS,'|TV3N|')>0 OR INSTR(m.OWNERS,'|TV3S|')>0 OR INSTR(m.OWNERS,'|TV5L|')>0 OR INSTR(m.OWNERS,'|TV6E|')>0 OR INSTR(m.OWNERS,'|TV6H|')>0 OR INSTR(m.OWNERS,'|TV6N|')>0 OR INSTR(m.OWNERS,'|TV6S|')>0 OR INSTR(m.OWNERS,'|TV8|')>0 OR INSTR(m.OWNERS,'|TVAE|')>0 OR INSTR(m.OWNERS,'|TVDP|')>0 OR INSTR(m.OWNERS,'|TVPB|')>0 OR INSTR(m.OWNERS,'|TVPU|')>0 OR INSTR(m.OWNERS,'|TVSL|')>0 OR INSTR(m.OWNERS,'|V1G|')>0 OR INSTR(m.OWNERS,'|V1TZ|')>0 OR INSTR(m.OWNERS,'|V3H|')>0 OR INSTR(m.OWNERS,'|V4N|')>0 OR INSTR(m.OWNERS,'|VEC|')>0 OR INSTR(m.OWNERS,'|VEPL|')>0 OR INSTR(m.OWNERS,'|VEPO|')>0 OR INSTR(m.OWNERS,'|VEXE|')>0 OR INSTR(m.OWNERS,'|VEXR|')>0 OR INSTR(m.OWNERS,'|VHIS|')>0 OR INSTR(m.OWNERS,'|VHPO|')>0 OR INSTR(m.OWNERS,'|VNC|')>0 OR INSTR(m.OWNERS,'|VNE|')>0 OR INSTR(m.OWNERS,'|VNH|')>0 OR INSTR(m.OWNERS,'|VNHD|')>0 OR INSTR(m.OWNERS,'|VNPO|')>0 OR INSTR(m.OWNERS,'|VODD|')>0 OR INSTR(m.OWNERS,'|VODE|')>0 OR INSTR(m.OWNERS,'|VODF|')>0 OR INSTR(m.OWNERS,'|VODN|')>0 OR INSTR(m.OWNERS,'|VODS|')>0 OR INSTR(m.OWNERS,'|VS2|')>0 OR INSTR(m.OWNERS,'|VS3|')>0 OR INSTR(m.OWNERS,'|VSAT|')>0 OR INSTR(m.OWNERS,'|VSD|')>0 OR INSTR(m.OWNERS,'|VSD2|')>0 OR INSTR(m.OWNERS,'|VSE|')>0 OR INSTR(m.OWNERS,'|VSG|')>0 OR INSTR(m.OWNERS,'|VSHD|')>0 OR INSTR(m.OWNERS,'|VSS|')>0 OR INSTR(m.OWNERS,'|WCIU|')>0 OR INSTR(m.OWNERS,'|YLE TV1|')>0 OR INSTR(m.OWNERS,'|ZTVS|')>0) order by upper(m.title), m.media_type, m.ec_som, m.id ) a where rownum <= 50) r ,lateral( select l.miid, max(c.C_EXT_OUT_LOC) lib_loc_ext_id, max(c.C_STAT) ctnr_stat, max(c.loan_stat) ctnr_loan_stat from tm_mi_tpi_lnx l, tm_ctnrs c where c.u_id=l.tpiid and l.miid=r.id and r.media_type=1 group by l.miid)(+) lnk ,lateral(select tt.* from tm_text tt where tt.text_id = r.primary_thumb_id2)(+) t ,lateral(select /*+ NO_DECORRELATE */ d.som fsom, d.eom feom, dl.mi_id fmi_id, d.os_fname fos_fname, d.DFILE_LINK_GUID, d.OS_GUID, d.SUB_FOLDER, dl.dfile_id, d.original_filename FROM tm_dfile d, tm_mi_dfile_lnx dl where d.id=dl.dfile_id and r.id=dl.mi_id and rownum=1)(+) dfl where rnum >= 1 order by rnum t Information: 1220 : 10|16:26:53.6585|FnOnKE|TMDDBA| timing: 00:00:00.0143705 t Verbose: 1220 : 10|16:26:53.6585|FnOnKE|TMDDBA|imfx v3 API took 0.015s '/api/v3/search/Media?_dc=1591630012635' t Transfer: 1220 : 10|16:26:53.6585|FnOnKE|TMDDBA|GetUrl. Storage |Video| filename I:\Video\L0640441.mp4 subfolder t Transfer: 1220 : 10|16:26:53.6585|FnOnKE|TMDDBA| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/L0640441.mp4 t Transfer: 1220 : 10|16:26:53.6585|FnOnKE|TMDDBA|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/L0640441.mp4 t Transfer: 1220 : 10|16:26:53.6585|FnOnKE|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:26:53.6585|FnOnKE|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:26:53.6585|FnOnKE|TMDDBA| user TMDDBA. t Transfer: 1220 : 10|16:26:53.6585|gDQMgI|TMDDBA|OAuth: /api/user-preferences?_dc=1591630012741 t Transfer: 1220 : 10|16:26:53.6585|gDQMgI|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:26:53.6585|gDQMgI|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:26:53.6585|gDQMgI|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:26:53.6585|gDQMgI|TMDDBA|OAuth. User logged in: TMDDBA t Verbose: 1220 : 10|16:26:53.6585|gDQMgI|TMDDBA|StoreUserDataByKeys.. t Transfer: 1220 : 10|16:26:53.6585|gDQMgI|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:26:53.6585|gDQMgI|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:26:53.6585|gDQMgI|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:26:53.6585|gDQMgI|TMDDBA|imfx v3 API took 0.007s '/api/user-preferences?_dc=1591630012741' t Transfer: 1220 : 10|16:26:57.3148|e0B_tc|TMDDBA|OAuth: /api/v3/search/Media?_dc=1591630016250 t Transfer: 1220 : 10|16:26:57.3148|e0B_tc|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:26:57.3148|e0B_tc|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:26:57.3148|e0B_tc|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:26:57.3148|e0B_tc|TMDDBA|OAuth. User logged in: TMDDBA t Information: 1220 : 10|16:26:57.3148|e0B_tc|TMDDBA|V3Api.SearchMedia t Information: 1220 : 10|16:26:57.3148|e0B_tc|TMDDBA|V3Api.SearchGeneric t Transfer: 1220 : 10|16:26:57.3148|e0B_tc|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:26:57.3148|e0B_tc|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:26:57.3148|e0B_tc|TMDDBA| user TMDDBA. t Information: 1220 : 10|16:26:57.3148|e0B_tc|TMDDBA|MediaSearch SQL: select r.*, nvl((select TMD_STR_AGG(c.u_id_pfix ) from tm_ctnrs c, tm_mi_tpi_lnx l where l.miid=r.id and c.u_id=l.tpiid and r.media_type=1),'') BARCODE, nvl(lnk.lib_loc_ext_id,0) lib_loc_ext_id, nvl(lnk.ctnr_loan_stat,0) ctnr_loan_status, nvl(lnk.ctnr_stat,0) ctnr_stat, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID , (select tmd_str_agg_pipe(cms.status_type_id ||',' ||cms.status_id) from tm_mi_cust_med_stat_lnx cms where cms.media_id=r.id) "CustomStatusesRaw", GETMEDIALOC(r.id, r.media_type, r.compil, r.m_ctnr_int_o_loc, r.m_ctnr_ext_o_loc, r.m_ctnr_loc) LOCATION, nvl(dfl.fSOM,0) FILE_SOM, nvl(dfl.fEOM,0) FILE_EOM, dfl.fos_fname FILENAME, dfl.DFILE_LINK_GUID, dfl.OS_GUID, dfl.SUB_FOLDER, dfl.ORIGINAL_FILENAME from (select a.*, rownum rnum from (select m.*, coalesce(m.primary_thumb_id, (select v.primary_thumb_id from tm_pg_rl v where v.id=m.pgm_parent_id)) primary_thumb_id2 from tmddba.tm_mis m where media_type>0 and item_type>0 AND m.ID=291743 and m.mi_deleted=0 AND (INSTR(m.OWNERS,'|03BO|')>0 OR INSTR(m.OWNERS,'|03GD|')>0 OR INSTR(m.OWNERS,'|03GO|')>0 OR INSTR(m.OWNERS,'|03HA|')>0 OR INSTR(m.OWNERS,'|03JO|')>0 OR INSTR(m.OWNERS,'|03LI|')>0 OR INSTR(m.OWNERS,'|03NB|')>0 OR INSTR(m.OWNERS,'|03NM|')>0 OR INSTR(m.OWNERS,'|03NO|')>0 OR INSTR(m.OWNERS,'|03OR|')>0 OR INSTR(m.OWNERS,'|03SB|')>0 OR INSTR(m.OWNERS,'|03SC|')>0 OR INSTR(m.OWNERS,'|03SE|')>0 OR INSTR(m.OWNERS,'|03SG|')>0 OR INSTR(m.OWNERS,'|03SK|')>0 OR INSTR(m.OWNERS,'|03SM|')>0 OR INSTR(m.OWNERS,'|03SN|')>0 OR INSTR(m.OWNERS,'|03SS|')>0 OR INSTR(m.OWNERS,'|03SY|')>0 OR INSTR(m.OWNERS,'|03UP|')>0 OR INSTR(m.OWNERS,'|03VA|')>0 OR INSTR(m.OWNERS,'|03VB|')>0 OR INSTR(m.OWNERS,'|03VL|')>0 OR INSTR(m.OWNERS,'|03VT|')>0 OR INSTR(m.OWNERS,'|3+ES|')>0 OR INSTR(m.OWNERS,'|3PD|')>0 OR INSTR(m.OWNERS,'|3PLV|')>0 OR INSTR(m.OWNERS,'|AECHD|')>0 OR INSTR(m.OWNERS,'|AECSD|')>0 OR INSTR(m.OWNERS,'|AL|')>0 OR INSTR(m.OWNERS,'|AMAY|')>0 OR INSTR(m.OWNERS,'|AMC|')>0 OR INSTR(m.OWNERS,'|ATP|')>0 OR INSTR(m.OWNERS,'|BBC|')>0 OR INSTR(m.OWNERS,'|CENT|')>0 OR INSTR(m.OWNERS,'|CS|')>0 OR INSTR(m.OWNERS,'|CTCB|')>0 OR INSTR(m.OWNERS,'|CTCE|')>0 OR INSTR(m.OWNERS,'|DAVI|')>0 OR INSTR(m.OWNERS,'|DMA|')>0 OR INSTR(m.OWNERS,'|DMF|')>0 OR INSTR(m.OWNERS,'|DMY|')>0 OR INSTR(m.OWNERS,'|DTV|')>0 OR INSTR(m.OWNERS,'|EST|')>0 OR INSTR(m.OWNERS,'|EUROSPORT|')>0 OR INSTR(m.OWNERS,'|HDC1|')>0 OR INSTR(m.OWNERS,'|HDP1|')>0 OR INSTR(m.OWNERS,'|HDP2|')>0 OR INSTR(m.OWNERS,'|HUB|')>0 OR INSTR(m.OWNERS,'|ITV|')>0 OR INSTR(m.OWNERS,'|KNL2|')>0 OR INSTR(m.OWNERS,'|KNVA|')>0 OR INSTR(m.OWNERS,'|LMH|')>0 OR INSTR(m.OWNERS,'|LNT|')>0 OR INSTR(m.OWNERS,'|MBNS|')>0 OR INSTR(m.OWNERS,'|MED|')>0 OR INSTR(m.OWNERS,'|MM|')>0 OR INSTR(m.OWNERS,'|MTG|')>0 OR INSTR(m.OWNERS,'|NAA|')>0 OR INSTR(m.OWNERS,'|NICK|')>0 OR INSTR(m.OWNERS,'|NVA|')>0 OR INSTR(m.OWNERS,'|OSP|')>0 OR INSTR(m.OWNERS,'|PBOY|')>0 OR INSTR(m.OWNERS,'|PMS|')>0 OR INSTR(m.OWNERS,'|PPL|')>0 OR INSTR(m.OWNERS,'|PSP|')>0 OR INSTR(m.OWNERS,'|Play|')>0 OR INSTR(m.OWNERS,'|RTR|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|SPG|')>0 OR INSTR(m.OWNERS,'|SPTV|')>0 OR INSTR(m.OWNERS,'|T3LT|')>0 OR INSTR(m.OWNERS,'|T3LV|')>0 OR INSTR(m.OWNERS,'|T6LT|')>0 OR INSTR(m.OWNERS,'|T6LV|')>0 OR INSTR(m.OWNERS,'|T8LT|')>0 OR INSTR(m.OWNERS,'|TECHM|')>0 OR INSTR(m.OWNERS,'|TMD|')>0 OR INSTR(m.OWNERS,'|TV10|')>0 OR INSTR(m.OWNERS,'|TV1A|')>0 OR INSTR(m.OWNERS,'|TV1B|')>0 OR INSTR(m.OWNERS,'|TV1C|')>0 OR INSTR(m.OWNERS,'|TV1D|')>0 OR INSTR(m.OWNERS,'|TV1E|')>0 OR INSTR(m.OWNERS,'|TV1F|')>0 OR INSTR(m.OWNERS,'|TV1K|')>0 OR INSTR(m.OWNERS,'|TV1N|')>0 OR INSTR(m.OWNERS,'|TV1P|')>0 OR INSTR(m.OWNERS,'|TV1S|')>0 OR INSTR(m.OWNERS,'|TV2S|')>0 OR INSTR(m.OWNERS,'|TV3D|')>0 OR INSTR(m.OWNERS,'|TV3N|')>0 OR INSTR(m.OWNERS,'|TV3S|')>0 OR INSTR(m.OWNERS,'|TV5L|')>0 OR INSTR(m.OWNERS,'|TV6E|')>0 OR INSTR(m.OWNERS,'|TV6H|')>0 OR INSTR(m.OWNERS,'|TV6N|')>0 OR INSTR(m.OWNERS,'|TV6S|')>0 OR INSTR(m.OWNERS,'|TV8|')>0 OR INSTR(m.OWNERS,'|TVAE|')>0 OR INSTR(m.OWNERS,'|TVDP|')>0 OR INSTR(m.OWNERS,'|TVPB|')>0 OR INSTR(m.OWNERS,'|TVPU|')>0 OR INSTR(m.OWNERS,'|TVSL|')>0 OR INSTR(m.OWNERS,'|V1G|')>0 OR INSTR(m.OWNERS,'|V1TZ|')>0 OR INSTR(m.OWNERS,'|V3H|')>0 OR INSTR(m.OWNERS,'|V4N|')>0 OR INSTR(m.OWNERS,'|VEC|')>0 OR INSTR(m.OWNERS,'|VEPL|')>0 OR INSTR(m.OWNERS,'|VEPO|')>0 OR INSTR(m.OWNERS,'|VEXE|')>0 OR INSTR(m.OWNERS,'|VEXR|')>0 OR INSTR(m.OWNERS,'|VHIS|')>0 OR INSTR(m.OWNERS,'|VHPO|')>0 OR INSTR(m.OWNERS,'|VNC|')>0 OR INSTR(m.OWNERS,'|VNE|')>0 OR INSTR(m.OWNERS,'|VNH|')>0 OR INSTR(m.OWNERS,'|VNHD|')>0 OR INSTR(m.OWNERS,'|VNPO|')>0 OR INSTR(m.OWNERS,'|VODD|')>0 OR INSTR(m.OWNERS,'|VODE|')>0 OR INSTR(m.OWNERS,'|VODF|')>0 OR INSTR(m.OWNERS,'|VODN|')>0 OR INSTR(m.OWNERS,'|VODS|')>0 OR INSTR(m.OWNERS,'|VS2|')>0 OR INSTR(m.OWNERS,'|VS3|')>0 OR INSTR(m.OWNERS,'|VSAT|')>0 OR INSTR(m.OWNERS,'|VSD|')>0 OR INSTR(m.OWNERS,'|VSD2|')>0 OR INSTR(m.OWNERS,'|VSE|')>0 OR INSTR(m.OWNERS,'|VSG|')>0 OR INSTR(m.OWNERS,'|VSHD|')>0 OR INSTR(m.OWNERS,'|VSS|')>0 OR INSTR(m.OWNERS,'|WCIU|')>0 OR INSTR(m.OWNERS,'|YLE TV1|')>0 OR INSTR(m.OWNERS,'|ZTVS|')>0) order by upper(m.title), m.media_type, m.ec_som, m.id ) a where rownum <= 50) r ,lateral( select l.miid, max(c.C_EXT_OUT_LOC) lib_loc_ext_id, max(c.C_STAT) ctnr_stat, max(c.loan_stat) ctnr_loan_stat from tm_mi_tpi_lnx l, tm_ctnrs c where c.u_id=l.tpiid and l.miid=r.id and r.media_type=1 group by l.miid)(+) lnk ,lateral(select tt.* from tm_text tt where tt.text_id = r.primary_thumb_id2)(+) t ,lateral(select /*+ NO_DECORRELATE */ d.som fsom, d.eom feom, dl.mi_id fmi_id, d.os_fname fos_fname, d.DFILE_LINK_GUID, d.OS_GUID, d.SUB_FOLDER, dl.dfile_id, d.original_filename FROM tm_dfile d, tm_mi_dfile_lnx dl where d.id=dl.dfile_id and r.id=dl.mi_id and rownum=1)(+) dfl where rnum >= 1 order by rnum t Information: 1220 : 10|16:26:57.3148|e0B_tc|TMDDBA| timing: 00:00:00.0167862 t Verbose: 1220 : 10|16:26:57.3148|e0B_tc|TMDDBA|imfx v3 API took 0.017s '/api/v3/search/Media?_dc=1591630016250' t Transfer: 1220 : 10|16:26:57.3148|e0B_tc|TMDDBA|GetUrl. Storage |Video| filename I:\Video\L0640441.mp4 subfolder t Transfer: 1220 : 10|16:26:57.3148|e0B_tc|TMDDBA| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/L0640441.mp4 t Transfer: 1220 : 10|16:26:57.3148|e0B_tc|TMDDBA|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/L0640441.mp4 t Transfer: 1220 : 10|16:26:57.3148|e0B_tc|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:26:57.3148|e0B_tc|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:26:57.3148|e0B_tc|TMDDBA| user TMDDBA. t Transfer: 1220 : 10|16:26:57.3148|SH98m1|TMDDBA|OAuth: /api/user-group-preferences?globals=htmlplayerhotkeys,audioOnFrameForward&_dc=1591630016315 t Transfer: 1220 : 10|16:26:57.3148|SH98m1|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:26:57.3148|SH98m1|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:26:57.3148|SH98m1|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:26:57.3148|SH98m1|TMDDBA|OAuth. User logged in: TMDDBA t Transfer: 1220 : 10|16:26:57.3148|SH98m1|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:26:57.3148|SH98m1|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:26:57.3148|SH98m1|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:26:57.3148|SH98m1|TMDDBA|imfx v3 API took 0.004s '/api/user-group-preferences?globals=htmlplayerhotkeys,audioOnFrameForward&_dc=1591630016315' t Transfer: 1220 : 10|16:26:57.3148|IMGTFN|TMDDBA|OAuth: /api/v3/search/Media?_dc=1591630016416 t Transfer: 1220 : 10|16:26:57.3148|IMGTFN|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:26:57.3148|IMGTFN|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:26:57.3148|IMGTFN|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:26:57.3148|IMGTFN|TMDDBA|OAuth. User logged in: TMDDBA t Information: 1220 : 10|16:26:57.3148|IMGTFN|TMDDBA|V3Api.SearchMedia t Information: 1220 : 10|16:26:57.3148|IMGTFN|TMDDBA|V3Api.SearchGeneric t Transfer: 1220 : 10|16:26:57.5179|IMGTFN|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:26:57.5179|IMGTFN|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:26:57.5179|IMGTFN|TMDDBA| user TMDDBA. t Transfer: 1220 : 10|16:26:57.5179|tpCls8|TMDDBA|OAuth: /api/lookups/FriendlyNames?_dc=1591630016421 t Transfer: 1220 : 10|16:26:57.5179|tpCls8|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:26:57.5179|tpCls8|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:26:57.5179|tpCls8|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:26:57.5179|tpCls8|TMDDBA|OAuth. User logged in: TMDDBA t Verbose: 1220 : 10|16:26:57.5179|tpCls8|TMDDBA|imfx v3 API took 0.000s '/api/lookups/FriendlyNames?_dc=1591630016421' t Information: 1220 : 10|16:26:57.5179|IMGTFN|TMDDBA|MediaSearch SQL: select r.*, nvl((select TMD_STR_AGG(c.u_id_pfix ) from tm_ctnrs c, tm_mi_tpi_lnx l where l.miid=r.id and c.u_id=l.tpiid and r.media_type=1),'') BARCODE, nvl(lnk.lib_loc_ext_id,0) lib_loc_ext_id, nvl(lnk.ctnr_loan_stat,0) ctnr_loan_status, nvl(lnk.ctnr_stat,0) ctnr_stat, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID , (select tmd_str_agg_pipe(cms.status_type_id ||',' ||cms.status_id) from tm_mi_cust_med_stat_lnx cms where cms.media_id=r.id) "CustomStatusesRaw", GETMEDIALOC(r.id, r.media_type, r.compil, r.m_ctnr_int_o_loc, r.m_ctnr_ext_o_loc, r.m_ctnr_loc) LOCATION, nvl(dfl.fSOM,0) FILE_SOM, nvl(dfl.fEOM,0) FILE_EOM, dfl.fos_fname FILENAME, dfl.DFILE_LINK_GUID, dfl.OS_GUID, dfl.SUB_FOLDER, dfl.ORIGINAL_FILENAME from (select a.*, rownum rnum from (select m.*, coalesce(m.primary_thumb_id, (select v.primary_thumb_id from tm_pg_rl v where v.id=m.pgm_parent_id)) primary_thumb_id2 from tmddba.tm_mis m where media_type>0 and item_type>0 AND m.ID=291743 and m.mi_deleted=0 AND (INSTR(m.OWNERS,'|03BO|')>0 OR INSTR(m.OWNERS,'|03GD|')>0 OR INSTR(m.OWNERS,'|03GO|')>0 OR INSTR(m.OWNERS,'|03HA|')>0 OR INSTR(m.OWNERS,'|03JO|')>0 OR INSTR(m.OWNERS,'|03LI|')>0 OR INSTR(m.OWNERS,'|03NB|')>0 OR INSTR(m.OWNERS,'|03NM|')>0 OR INSTR(m.OWNERS,'|03NO|')>0 OR INSTR(m.OWNERS,'|03OR|')>0 OR INSTR(m.OWNERS,'|03SB|')>0 OR INSTR(m.OWNERS,'|03SC|')>0 OR INSTR(m.OWNERS,'|03SE|')>0 OR INSTR(m.OWNERS,'|03SG|')>0 OR INSTR(m.OWNERS,'|03SK|')>0 OR INSTR(m.OWNERS,'|03SM|')>0 OR INSTR(m.OWNERS,'|03SN|')>0 OR INSTR(m.OWNERS,'|03SS|')>0 OR INSTR(m.OWNERS,'|03SY|')>0 OR INSTR(m.OWNERS,'|03UP|')>0 OR INSTR(m.OWNERS,'|03VA|')>0 OR INSTR(m.OWNERS,'|03VB|')>0 OR INSTR(m.OWNERS,'|03VL|')>0 OR INSTR(m.OWNERS,'|03VT|')>0 OR INSTR(m.OWNERS,'|3+ES|')>0 OR INSTR(m.OWNERS,'|3PD|')>0 OR INSTR(m.OWNERS,'|3PLV|')>0 OR INSTR(m.OWNERS,'|AECHD|')>0 OR INSTR(m.OWNERS,'|AECSD|')>0 OR INSTR(m.OWNERS,'|AL|')>0 OR INSTR(m.OWNERS,'|AMAY|')>0 OR INSTR(m.OWNERS,'|AMC|')>0 OR INSTR(m.OWNERS,'|ATP|')>0 OR INSTR(m.OWNERS,'|BBC|')>0 OR INSTR(m.OWNERS,'|CENT|')>0 OR INSTR(m.OWNERS,'|CS|')>0 OR INSTR(m.OWNERS,'|CTCB|')>0 OR INSTR(m.OWNERS,'|CTCE|')>0 OR INSTR(m.OWNERS,'|DAVI|')>0 OR INSTR(m.OWNERS,'|DMA|')>0 OR INSTR(m.OWNERS,'|DMF|')>0 OR INSTR(m.OWNERS,'|DMY|')>0 OR INSTR(m.OWNERS,'|DTV|')>0 OR INSTR(m.OWNERS,'|EST|')>0 OR INSTR(m.OWNERS,'|EUROSPORT|')>0 OR INSTR(m.OWNERS,'|HDC1|')>0 OR INSTR(m.OWNERS,'|HDP1|')>0 OR INSTR(m.OWNERS,'|HDP2|')>0 OR INSTR(m.OWNERS,'|HUB|')>0 OR INSTR(m.OWNERS,'|ITV|')>0 OR INSTR(m.OWNERS,'|KNL2|')>0 OR INSTR(m.OWNERS,'|KNVA|')>0 OR INSTR(m.OWNERS,'|LMH|')>0 OR INSTR(m.OWNERS,'|LNT|')>0 OR INSTR(m.OWNERS,'|MBNS|')>0 OR INSTR(m.OWNERS,'|MED|')>0 OR INSTR(m.OWNERS,'|MM|')>0 OR INSTR(m.OWNERS,'|MTG|')>0 OR INSTR(m.OWNERS,'|NAA|')>0 OR INSTR(m.OWNERS,'|NICK|')>0 OR INSTR(m.OWNERS,'|NVA|')>0 OR INSTR(m.OWNERS,'|OSP|')>0 OR INSTR(m.OWNERS,'|PBOY|')>0 OR INSTR(m.OWNERS,'|PMS|')>0 OR INSTR(m.OWNERS,'|PPL|')>0 OR INSTR(m.OWNERS,'|PSP|')>0 OR INSTR(m.OWNERS,'|Play|')>0 OR INSTR(m.OWNERS,'|RTR|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|SPG|')>0 OR INSTR(m.OWNERS,'|SPTV|')>0 OR INSTR(m.OWNERS,'|T3LT|')>0 OR INSTR(m.OWNERS,'|T3LV|')>0 OR INSTR(m.OWNERS,'|T6LT|')>0 OR INSTR(m.OWNERS,'|T6LV|')>0 OR INSTR(m.OWNERS,'|T8LT|')>0 OR INSTR(m.OWNERS,'|TECHM|')>0 OR INSTR(m.OWNERS,'|TMD|')>0 OR INSTR(m.OWNERS,'|TV10|')>0 OR INSTR(m.OWNERS,'|TV1A|')>0 OR INSTR(m.OWNERS,'|TV1B|')>0 OR INSTR(m.OWNERS,'|TV1C|')>0 OR INSTR(m.OWNERS,'|TV1D|')>0 OR INSTR(m.OWNERS,'|TV1E|')>0 OR INSTR(m.OWNERS,'|TV1F|')>0 OR INSTR(m.OWNERS,'|TV1K|')>0 OR INSTR(m.OWNERS,'|TV1N|')>0 OR INSTR(m.OWNERS,'|TV1P|')>0 OR INSTR(m.OWNERS,'|TV1S|')>0 OR INSTR(m.OWNERS,'|TV2S|')>0 OR INSTR(m.OWNERS,'|TV3D|')>0 OR INSTR(m.OWNERS,'|TV3N|')>0 OR INSTR(m.OWNERS,'|TV3S|')>0 OR INSTR(m.OWNERS,'|TV5L|')>0 OR INSTR(m.OWNERS,'|TV6E|')>0 OR INSTR(m.OWNERS,'|TV6H|')>0 OR INSTR(m.OWNERS,'|TV6N|')>0 OR INSTR(m.OWNERS,'|TV6S|')>0 OR INSTR(m.OWNERS,'|TV8|')>0 OR INSTR(m.OWNERS,'|TVAE|')>0 OR INSTR(m.OWNERS,'|TVDP|')>0 OR INSTR(m.OWNERS,'|TVPB|')>0 OR INSTR(m.OWNERS,'|TVPU|')>0 OR INSTR(m.OWNERS,'|TVSL|')>0 OR INSTR(m.OWNERS,'|V1G|')>0 OR INSTR(m.OWNERS,'|V1TZ|')>0 OR INSTR(m.OWNERS,'|V3H|')>0 OR INSTR(m.OWNERS,'|V4N|')>0 OR INSTR(m.OWNERS,'|VEC|')>0 OR INSTR(m.OWNERS,'|VEPL|')>0 OR INSTR(m.OWNERS,'|VEPO|')>0 OR INSTR(m.OWNERS,'|VEXE|')>0 OR INSTR(m.OWNERS,'|VEXR|')>0 OR INSTR(m.OWNERS,'|VHIS|')>0 OR INSTR(m.OWNERS,'|VHPO|')>0 OR INSTR(m.OWNERS,'|VNC|')>0 OR INSTR(m.OWNERS,'|VNE|')>0 OR INSTR(m.OWNERS,'|VNH|')>0 OR INSTR(m.OWNERS,'|VNHD|')>0 OR INSTR(m.OWNERS,'|VNPO|')>0 OR INSTR(m.OWNERS,'|VODD|')>0 OR INSTR(m.OWNERS,'|VODE|')>0 OR INSTR(m.OWNERS,'|VODF|')>0 OR INSTR(m.OWNERS,'|VODN|')>0 OR INSTR(m.OWNERS,'|VODS|')>0 OR INSTR(m.OWNERS,'|VS2|')>0 OR INSTR(m.OWNERS,'|VS3|')>0 OR INSTR(m.OWNERS,'|VSAT|')>0 OR INSTR(m.OWNERS,'|VSD|')>0 OR INSTR(m.OWNERS,'|VSD2|')>0 OR INSTR(m.OWNERS,'|VSE|')>0 OR INSTR(m.OWNERS,'|VSG|')>0 OR INSTR(m.OWNERS,'|VSHD|')>0 OR INSTR(m.OWNERS,'|VSS|')>0 OR INSTR(m.OWNERS,'|WCIU|')>0 OR INSTR(m.OWNERS,'|YLE TV1|')>0 OR INSTR(m.OWNERS,'|ZTVS|')>0) order by upper(m.title), m.media_type, m.ec_som, m.id ) a where rownum <= 50) r ,lateral( select l.miid, max(c.C_EXT_OUT_LOC) lib_loc_ext_id, max(c.C_STAT) ctnr_stat, max(c.loan_stat) ctnr_loan_stat from tm_mi_tpi_lnx l, tm_ctnrs c where c.u_id=l.tpiid and l.miid=r.id and r.media_type=1 group by l.miid)(+) lnk ,lateral(select tt.* from tm_text tt where tt.text_id = r.primary_thumb_id2)(+) t ,lateral(select /*+ NO_DECORRELATE */ d.som fsom, d.eom feom, dl.mi_id fmi_id, d.os_fname fos_fname, d.DFILE_LINK_GUID, d.OS_GUID, d.SUB_FOLDER, dl.dfile_id, d.original_filename FROM tm_dfile d, tm_mi_dfile_lnx dl where d.id=dl.dfile_id and r.id=dl.mi_id and rownum=1)(+) dfl where rnum >= 1 order by rnum t Transfer: 1220 : 10|16:26:57.5179|1NHUxb|TMDDBA|OAuth: /api/v3/media-captions/291743?_dc=1591630016427 t Transfer: 1220 : 10|16:26:57.5179|1NHUxb|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:26:57.5179|1NHUxb|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:26:57.5179|1NHUxb|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:26:57.5179|1NHUxb|TMDDBA|OAuth. User logged in: TMDDBA t Information: 1220 : 10|16:26:57.5179|t6rAF5|TMDDBA|V3Api.GetMediaTagging t Information: 1220 : 10|16:26:57.5179|IMGTFN|TMDDBA| timing: 00:00:00.0223741 t Verbose: 1220 : 10|16:26:57.5179|IMGTFN|TMDDBA|imfx v3 API took 0.022s '/api/v3/search/Media?_dc=1591630016416' t Transfer: 1220 : 10|16:26:57.5179|IMGTFN|TMDDBA|GetUrl. Storage |Video| filename I:\Video\L0640441.mp4 subfolder t Transfer: 1220 : 10|16:26:57.5179|IMGTFN|TMDDBA| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/L0640441.mp4 t Transfer: 1220 : 10|16:26:57.5179|IMGTFN|TMDDBA|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/L0640441.mp4 t Transfer: 1220 : 10|16:26:57.5179|IMGTFN|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:26:57.5179|IMGTFN|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:26:57.5179|IMGTFN|TMDDBA| user TMDDBA. t Transfer: 1220 : 10|16:26:57.5179|TgvlM3|TMDDBA|OAuth: /api/v3/mediavideo/291743?info=smudge&_dc=1591630016431 t Transfer: 1220 : 10|16:26:57.5179|TgvlM3|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:26:57.5179|TgvlM3|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:26:57.5179|TgvlM3|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:26:57.5179|TgvlM3|TMDDBA|OAuth. User logged in: TMDDBA t Transfer: 1220 : 10|16:26:57.5179|TgvlM3|TMDDBA|GetUrl. Storage |Video| filename I:\Video\L0640441.mp4 subfolder t Transfer: 1220 : 10|16:26:57.5179|TgvlM3|TMDDBA| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/L0640441.mp4 t Transfer: 1220 : 10|16:26:57.5179|TgvlM3|TMDDBA|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/L0640441.mp4 t Transfer: 1220 : 10|16:26:57.5179|TgvlM3|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:26:57.5179|TgvlM3|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:26:57.5179|TgvlM3|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:26:57.5179|1NHUxb|TMDDBA|imfx v3 API took 0.026s '/api/v3/media-captions/291743?_dc=1591630016427' t Verbose: 1220 : 10|16:26:57.5179|TgvlM3|TMDDBA|imfx v3 API took 0.016s '/api/v3/mediavideo/291743?info=smudge&_dc=1591630016431' t Transfer: 1220 : 10|16:27:10.9397|4ZSP3L|TMDDBA|OAuth: /api/user-group-preferences?globals=htmlplayerhotkeys,audioOnFrameForward&_dc=1591630029836 t Transfer: 1220 : 10|16:27:10.9397|4ZSP3L|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:27:10.9397|4ZSP3L|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:27:10.9397|4ZSP3L|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:27:10.9397|4ZSP3L|TMDDBA|OAuth. User logged in: TMDDBA t Transfer: 1220 : 10|16:27:10.9397|4ZSP3L|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|16:27:10.9397|4ZSP3L|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|16:27:10.9397|4ZSP3L|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|16:27:10.9397|4ZSP3L|TMDDBA|imfx v3 API took 0.003s '/api/user-group-preferences?globals=htmlplayerhotkeys,audioOnFrameForward&_dc=1591630029836' t Information: 1220 : 10|16:48:06.0962|||OrabitWatcherBasic. Disposing. t Information: 1220 : 10|16:48:06.0962|||OrabitWatcherBasic. Disposed. t Information: 1220 : 10|16:48:06.0962|||========================================================================== t Information: 1220 : 10|16:48:06.0962|||IMFX CORE SERVER APPLICATION END.