t Information: 1220 : 10|13:06:12.5810|||Get Configuration Values: t Information: 1220 : 10|13:06:12.5810||| AdminPassEnc, default: , value: ffqjrn0leKv4Lj2YJHe2dw==. t Information: 1220 : 10|13:06:12.5810||| EncryptedPasswords, default: false, value: true. t Information: 1220 : 10|13:06:12.5810||| OraConnectionString, default: , value: Server=TECHM;User Id=imfx;Password=xxxxx;Unicode=true;. t Information: 1220 : 10|13:06:12.5810||| SecondTimezone, default: , value: . t Information: 1220 : 10|13:06:12.5810||| UseActiveDirectoryAuth, default: false, value: false. t Information: 1220 : 10|13:06:12.5810||| ReportingServiceUrl, default: , value: http://localhost:92/ReportingService.svc. t Information: 1220 : 10|13:06:12.5810||| ReportsPath, default: , value: . t Information: 1220 : 10|13:06:12.5810||| ReportsURL, default: , value: . t Information: 1220 : 10|13:06:12.5810||| TapeServiceUrl, default: , value: . t Information: 1220 : 10|13:06:12.5810||| GatekeeperUrl, default: , value: . t Information: 1220 : 10|13:06:12.5810||| ValuationUrl, default: , value: . t Information: 1220 : 10|13:06:12.5810||| QueueManagerDelay, default: 30, value: 30. t Information: 1220 : 10|13:06:12.5810||| QueueManagerFullRefresh, default: 90, value: 90. t Information: 1220 : 10|13:06:12.5810||| AudioLoopDuration, default: 0, value: 150. t Information: 1220 : 10|13:06:12.5810||| AudioLoopsCount, default: 0, value: 0. t Information: 1220 : 10|13:06:12.5810||| PlayerFakeStep, default: 500, value: 500. t Information: 1220 : 10|13:06:12.5810||| PlayerForceRatio, default: 0, value: 1. t Information: 1220 : 10|13:06:12.5810||| CheckVersionsInProd, default: false, value: True. t Information: 1220 : 10|13:06:12.5810||| MaxResults, default: 3000, value: 10000. t Information: 1220 : 10|13:06:12.5810||| TEReportID, default: 0, value: 0. t Information: 1220 : 10|13:06:12.5810||| ClosedCaptionsCache, default: , value: C:\inetpub\wwwroot\imfxcore\timedtextcache\. t Information: 1220 : 10|13:06:12.5810||| ClosedCaptionsStorage, default: , value: c:\Mediaflex\subs. t Information: 1220 : 10|13:06:12.5810||| TimeCodeFormat, default: , value: pal. t Information: 1220 : 10|13:06:12.5810||| RceMediaPath, default: , value: C:\edl\. t Information: 1220 : 10|13:06:12.5810||| RceMediaPath, default: , value: C:\edl\. t Information: 1220 : 10|13:06:12.5810||| RceCsmOutputPath, default: , value: C:\Inetpub\wwwroot\csm\. t Information: 1220 : 10|13:06:12.5810||| RceCsmUrl, default: , value: http://localhost/csm/. t Information: 1220 : 10|13:06:12.5810||| RceMediaSelection, default: , value: miLinkIdMatch. t Information: 1220 : 10|13:06:12.5810||| RequestBrowseJobPresetName, default: , value: . t Information: 1220 : 10|13:06:12.5810||| DontExtendDuration, default: false, value: False. t Information: 1220 : 10|13:06:12.5810||| V3ConfigUrl, default: , value: . t Information: 1220 : 10|13:06:12.5810||| StopWords, default: , value: . t Information: 1220 : 10|13:06:12.5810||| MisrTxFormat, default: G, value: G. t Information: 1220 : 10|13:06:12.5810||| ApiServer, default: , value: http://192.168.120.10:85. t Information: 1220 : 10|13:06:12.5810||| ApiTimeout, default: 120, value: 120. t Information: 1220 : 10|13:06:12.5810||| ApiWorkers, default: 10, value: 10. t Information: 1220 : 10|13:06:12.5810||| UsePerfCounters, default: false, value: false. t Information: 1220 : 10|13:06:12.5810||| LogGetCurrentUser, default: true, value: true. t Information: 1220 : 10|13:06:12.5810||| LogInternalApi, default: true, value: true. t Information: 1220 : 10|13:06:12.5810||| ThumbnailServer, default: , value: . t Information: 1220 : 10|13:06:12.5810||| LocationFilter, default: , value: . t Information: 1220 : 10|13:06:12.5810||| SvUtilServiceUrl, default: , value: . t Information: 1220 : 10|13:06:12.5810||| SolrConnection, default: , value: http://192.168.120.14:8983/solr. t Information: 1220 : 10|13:06:12.5810||| UseIndexServerSearch, default: false, value: True. t Information: 1220 : 10|13:06:12.5810||| SolrIndexVersion, default: 1, value: 6. t Information: 1220 : 10|13:06:12.5810||| SolrConnection, default: , value: http://192.168.120.14:8983/solr. t Information: 1220 : 10|13:06:12.5810||| FacetsGroups, default: , value: owners,season_id, series_id,version_key,item_type,media_type,media_format,episode_number. t Information: 1220 : 10|13:06:12.5810||| FacetsGroupsVersion, default: , value: owners,season_id, series_id,version_key,episode_number. t Information: 1220 : 10|13:06:12.5810||| FacetsGroupsChameleon, default: , value: season_id, series_id,genre,prod_year,version_key. t Information: 1220 : 10|13:06:12.5810||| PreviewPreset, default: , value: . t Information: 1220 : 10|13:06:12.5810||| DevMode, default: false, value: false. t Information: 1220 : 10|13:06:12.5810||| DisableSysMan, default: false, value: false. t Information: 1220 : 10|13:06:12.5810||| TimeCodeFormat, default: , value: pal. t Information: 1220 : 10|13:06:12.5810||| FileCatalystStorageDevice, default: , value: . t Information: 1220 : 10|13:06:12.5810||| UseResponsibilityTracking, default: true, value: True. t Information: 1220 : 10|13:06:12.5810||| SubtitleDeviceFilter, default: , value: . t Information: 1220 : 10|13:06:12.5810||| SystemMonitorNamedPipe, default: , value: . t Information: 1220 : 10|13:06:12.5810||| OracleMonitorEnable, default: false, value: False. t Information: 1220 : 10|13:06:12.5810||| ArcApiHost, default: , value: . t Information: 1220 : 10|13:06:12.5810||| SolrTimedTextSearch, default: false, value: false. t Information: 1220 : 10|13:06:12.5810||| ProductionDurationUsageID, default: 1, value: 1. t Information: 1220 : 10|13:06:12.7998|||GetStreamServers.. t Information: 1220 : 10|13:06:13.6122||| https://demo.tmd.tv/CBR Video/ |CBR Video| False t Information: 1220 : 10|13:06:13.6122||| https://demo.tmd.tv/CBR Images/ |CBR Images| False t Information: 1220 : 10|13:06:13.6122||| https://demo.tmd.tv/CBR Audio/ |CBR Audio| False t Information: 1220 : 10|13:06:13.6122||| https://demo.tmd.tv/Temp Upload/ |TEMP_UPLOAD| False t Information: 1220 : 10|13:06:13.6122||| http://localhost:82/images/ |IMAGES| False t Information: 1220 : 10|13:06:13.6122||| http://192.168.91.73/smoothcloud/ |SMOOTH_CLOUD| False t Information: 1220 : 10|13:06:13.6122||| http://192.168.91.73/cloudstore/ |CLOUD_STORE| False t Information: 1220 : 10|13:06:13.6122||| http://192.168.91.73/editsystemin/ |EDIT_SYSTEM_IN| False t Information: 1220 : 10|13:06:13.6122||| http://192.168.91.27:89/APPLEPROXY/ |APPLE_PROXY| False t Information: 1220 : 10|13:06:13.6122||| http://localhost:82/video/ |FILESTORE_VIDEO| False t Information: 1220 : 10|13:06:13.6122||| https://imfxv3tm.tmd.tv/streaming/ |Streaming| False t Information: 1220 : 10|13:06:13.6122||| https://imfxv3tm.tmd.tv/VideoServer/ |Video| False t Information: 1220 : 10|13:06:13.6122||| https://imfxv3tm.tmd.tv/AdobeIn/ |Adobe Premiere Pro In| False t Information: 1220 : 10|13:06:13.6122||| https://imfxv3tm.tmd.tv/AudioServer/ |Audio| False t Information: 1220 : 10|13:06:13.6122||| https://imfxv3tm.tmd.tv/ImageServer/ |Image| False t Information: 1220 : 10|13:06:13.6122||| https://imfxv3tm.tmd.tv/DocsServer/ |Docs| False t Information: 1220 : 10|13:06:13.6122||| https://imfxv3tm.tmd.tv/AmazonLabs/ |TEST HOUSE| False t Information: 1220 : 10|13:06:13.6122||| SolrConnectionUms, default: http://192.168.120.14:8983/solr, value: http://192.168.120.14:8983/solr. t Information: 1220 : 10|13:06:13.6122||| LogWebApi, default: false, value: false. t Information: 1220 : 10|13:06:13.6122||| EmbeddedRceUrl, default: , value: . t Information: 1220 : 10|13:06:13.6122||| InstallMode, default: , value: . t Information: 1220 : 10|13:06:13.6122||| SamlRequestAddress, default: , value: . t Information: 1220 : 10|13:06:13.6122||| SamlTrustedIssuer, default: , value: . t Information: 1220 : 10|13:06:13.6122||| SamlLoginRedirect, default: , value: . t Information: 1220 : 10|13:06:13.6122||| NaturalLangSearch, default: false, value: True. t Information: 1220 : 10|13:06:13.6122||| LocalUploadExpirationHours, default: 0, value: 0. t Information: 1220 : 10|13:06:13.6122||| LocalUploadDeviceId, default: 0, value: 0. t Information: 1220 : 10|13:06:13.6122||| VideosFileFormatIds, default: , value: . t Information: 1220 : 10|13:06:13.6122||| VideosStorageIds, default: , value: . t Information: 1220 : 10|13:06:13.6122||| OktaLoginField, default: , value: . t Information: 1220 : 10|13:06:13.6122||| AuthenticationTypes, default: , value: Native,PublicApiKey. t Information: 1220 : 10|13:06:13.6122|||OrabitWatcherBasic. Initialize. t Information: 1220 : 10|13:06:13.8168|||FillDictionaryCache. t Information: 1220 : 10|13:06:17.3189|||GetSupportedOperators t Information: 1220 : 10|13:06:17.5221|||CacheTechReports. t Information: 1220 : 10|13:06:17.7252|||& Cache update. Server (global) filled with timestamp 01:12:17.6001832. types null t Information: 1220 : 10|13:06:17.7252|||InitializeFromDatabase. 'Server=TECHM;User Id=imfx;password=..;Unicode=true;' direct False, home , timeout 15 t Information: 1220 : 10|13:06:17.7252|||FillDictionaryCache. t Information: 1220 : 10|13:06:17.7252|||& Cache update. Server (global) filled with timestamp 01:12:17.6314502. types FriendlyNames, DatabaseSearchFieldData t Information: 1220 : 10|13:06:18.3346|||========================================================================== t Information: 1220 : 10|13:06:18.3346|||IMFX CORE SERVER APPLICATION START. t Information: 1220 : 10|13:06:18.3346|||DLL VERSION: 3.0.0.111. t Information: 1220 : 10|13:06:18.3346|||IS TIMER HIGH RESOLUTION : True. t Information: 1220 : 10|13:06:18.3346||| UmsDev, default: False, value: False. t Information: 1220 : 10|13:06:18.7407|||OrabitWatcherBasic trying to connect.. t Information: 1220 : 10|13:06:18.7407|||OrabitWatcherBasic connected. t Information: 1220 : 10|13:06:18.7407|||OrabitWatcherBasic queue created tmd.cfg.in.11845fad-b006-4adf-887a-eafc0f92d133 t Transfer: 1220 : 10|13:06:21.1783|uXBZBB||GetAppInfo. DB: TMDDEMO. Install mode: . Auth types: Native, PublicApiKey t Information: 1220 : 10|13:06:21.5845|XMG4p8||GetCache. t Information: 1220 : 10|13:06:21.5845|XMG4p8||GetCache. Found: C:\inetpub\wwwroot\imfxcore\VisualAssetsCache\108_2_PnqJC_.png t Information: 1220 : 10|13:06:21.5845|XMG4p8||GetCache. Data read: 40477 t Verbose: 1220 : 10|13:06:21.5845|XMG4p8||imfx v3 API took 0.065s '/api/v3/visual-asset/group/PnqJC_/2/image' t Verbose: 1220 : 10|13:06:36.6337|W9o9Ff||Oauth validating.. t Verbose: 1220 : 10|13:06:36.6337|W9o9Ff||GrantResourceOwnerCredentials. t Verbose: 1220 : 10|13:06:36.6337|W9o9Ff||LoginUser. daniel, login type OAuth, encrypt password True t Information: 1220 : 10|13:06:36.6337|W9o9Ff||TryLoginUser. daniel, login type OAuth, check password True, check hash False, encrypt password True, load user data False t Information: 1220 : 10|13:06:36.8369|W9o9Ff|| oauth token 00000000-0000-0000-0000-000000000000 t Information: 1220 : 10|13:06:36.8369|W9o9Ff||TryLoginUser. Logged in.. t Information: 1220 : 10|13:06:36.8369|W9o9Ff||GetPasswordPolicy. WARNING: Policy not found for system Imediaflex. Validation disabled. t Verbose: 1220 : 10|13:06:36.8369|W9o9Ff||LoginUser. Adding history. User Id 342, result DANIEL, host 192.168.127.7 t Verbose: 1220 : 10|13:06:37.0400|W9o9Ff||GrantResourceOwnerCredentials. Try login finished. Logged: True t Transfer: 1220 : 10|13:06:37.0400|i9Fkun|DANIEL|OAuth: /api/user-group-preferences?keys=defaultSearchColumnsMedia,defaultSearchColumnsVersion,defaultSearchColumnsSimple,defaultSearchMisrDetailsMediaColumns,versionCreationSettings,associate.advanced_search.version.setups,associate.advanced_search.media.setups,associate.wfrise.setups,supplier_portal.advanced_search.version.setups,supplier_portal.version_complete.setups,logoImage,uploadSettings,helpdeskUrl,customLabels&globals=isDebugMode,htmlplayerhotkeys,versionCreationSettings,associate.advanced_search.version.setups,associate.advanced_search.media.setups,associate.wfrise.setups,supplier_portal.advanced_search.version.setups,helpdeskUrl,customLabels&_dc=1608037608178 t Transfer: 1220 : 10|13:06:37.0400|i9Fkun|DANIEL|GetCurrentUser.. t Transfer: 1220 : 10|13:06:37.0400|i9Fkun|DANIEL| OAuth authenticated t Transfer: 1220 : 10|13:06:37.0400|i9Fkun|DANIEL| user DANIEL. t Verbose: 1220 : 10|13:06:37.0400|i9Fkun|DANIEL|OAuth. User logged in: DANIEL t Transfer: 1220 : 10|13:06:37.0400|i9Fkun|DANIEL|GetCurrentUser.. t Transfer: 1220 : 10|13:06:37.0400|i9Fkun|DANIEL| OAuth authenticated t Transfer: 1220 : 10|13:06:37.0400|i9Fkun|DANIEL| user DANIEL. t Verbose: 1220 : 10|13:06:37.2431|i9Fkun|DANIEL|imfx v3 API took 0.052s '/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,customLabels&globals=isDebugMode,htmlplayerhotkeys,versionCreationSettings,associate.advanced_search.version.setups,associate.advanced_search.media.setups,associate.wfrise.setups,supplier_portal.advanced_search.version.setups,helpdeskUrl,customLabels&_dc=1608037608178' t Transfer: 1220 : 10|13:06:37.2431|yOGeqN|DANIEL|OAuth: /api/user-preferences?keys=personal_settings;basket;default_page;color_schema;media.basket.data;defaultSearch&_dc=1608037608300 t Transfer: 1220 : 10|13:06:37.2431|yOGeqN|DANIEL|GetCurrentUser.. t Transfer: 1220 : 10|13:06:37.2431|yOGeqN|DANIEL| OAuth authenticated t Transfer: 1220 : 10|13:06:37.2431|yOGeqN|DANIEL| user DANIEL. t Verbose: 1220 : 10|13:06:37.2431|yOGeqN|DANIEL|OAuth. User logged in: DANIEL t Information: 1220 : 10|13:06:37.2431|yOGeqN|DANIEL|GetUserDataByKeys: personal_settings;basket;default_page;color_schema;media.basket.data;defaultSearch t Transfer: 1220 : 10|13:06:37.2431|yOGeqN|DANIEL|GetCurrentUser.. t Transfer: 1220 : 10|13:06:37.2431|yOGeqN|DANIEL| OAuth authenticated t Transfer: 1220 : 10|13:06:37.2431|yOGeqN|DANIEL| user DANIEL. t Transfer: 1220 : 10|13:06:37.2431|59KLr~|DANIEL|OAuth: /api/lookups/MediaStatus?_dc=1608037608301 t Transfer: 1220 : 10|13:06:37.2431|59KLr~|DANIEL|GetCurrentUser.. t Transfer: 1220 : 10|13:06:37.2431|59KLr~|DANIEL| OAuth authenticated t Transfer: 1220 : 10|13:06:37.2431|59KLr~|DANIEL| user DANIEL. t Verbose: 1220 : 10|13:06:37.2431|59KLr~|DANIEL|OAuth. User logged in: DANIEL t Transfer: 1220 : 10|13:06:37.2431|vkynd1|DANIEL|OAuth: /api/lookups/PgmStatus?_dc=1608037608304 t Transfer: 1220 : 10|13:06:37.2431|vkynd1|DANIEL|GetCurrentUser.. t Transfer: 1220 : 10|13:06:37.2431|vkynd1|DANIEL| OAuth authenticated t Transfer: 1220 : 10|13:06:37.2431|vkynd1|DANIEL| user DANIEL. t Verbose: 1220 : 10|13:06:37.2431|vkynd1|DANIEL|OAuth. User logged in: DANIEL t Verbose: 1220 : 10|13:06:37.2431|yOGeqN|DANIEL|imfx v3 API took 0.034s '/api/user-preferences?keys=personal_settings;basket;default_page;color_schema;media.basket.data;defaultSearch&_dc=1608037608300' t Verbose: 1220 : 10|13:06:37.2431|59KLr~|DANIEL|imfx v3 API took 0.032s '/api/lookups/MediaStatus?_dc=1608037608301' t Verbose: 1220 : 10|13:06:37.2431|vkynd1|DANIEL|imfx v3 API took 0.030s '/api/lookups/PgmStatus?_dc=1608037608304' t Information: 1220 : 10|13:06:37.2431|J5lNOV|DANIEL|GetUserProfile. Id: 0 t Transfer: 1220 : 10|13:06:37.2431|J5lNOV|DANIEL|GetCurrentUser.. t Transfer: 1220 : 10|13:06:37.2431|J5lNOV|DANIEL| OAuth authenticated t Transfer: 1220 : 10|13:06:37.2431|J5lNOV|DANIEL| user DANIEL. t Transfer: 1220 : 10|13:06:37.4463|eiz4jZ|DANIEL|OAuth: /api/settings/group/0?_dc=1608037608508 t Transfer: 1220 : 10|13:06:37.4463|eiz4jZ|DANIEL|GetCurrentUser.. t Transfer: 1220 : 10|13:06:37.4463|eiz4jZ|DANIEL| OAuth authenticated t Transfer: 1220 : 10|13:06:37.4463|eiz4jZ|DANIEL| user DANIEL. t Verbose: 1220 : 10|13:06:37.4463|eiz4jZ|DANIEL|OAuth. User logged in: DANIEL t Transfer: 1220 : 10|13:06:37.4463|ZAcOan|DANIEL|OAuth: /api/settings/user/uploadSettings?_dc=1608037608533 t Transfer: 1220 : 10|13:06:37.4463|ZAcOan|DANIEL|GetCurrentUser.. t Transfer: 1220 : 10|13:06:37.4463|ZAcOan|DANIEL| OAuth authenticated t Transfer: 1220 : 10|13:06:37.4463|ZAcOan|DANIEL| user DANIEL. t Verbose: 1220 : 10|13:06:37.4463|ZAcOan|DANIEL|OAuth. User logged in: DANIEL t Transfer: 1220 : 10|13:06:37.4463|ZAcOan|DANIEL|GetCurrentUser.. t Transfer: 1220 : 10|13:06:37.4463|ZAcOan|DANIEL| OAuth authenticated t Transfer: 1220 : 10|13:06:37.4463|ZAcOan|DANIEL| user DANIEL. t Verbose: 1220 : 10|13:06:37.4463|ZAcOan|DANIEL|imfx v3 API took 0.015s '/api/settings/user/uploadSettings?_dc=1608037608533' t Information: 1220 : 10|13:06:37.4463|wtWuzf||GetCache. t Information: 1220 : 10|13:06:37.4463|wtWuzf||GetCache. Found: C:\inetpub\wwwroot\imfxcore\VisualAssetsCache\2_1_M6I_N7.png t Information: 1220 : 10|13:06:37.4463|wtWuzf||GetCache. Data read: 129086 t Verbose: 1220 : 10|13:06:37.4463|wtWuzf||imfx v3 API took 0.004s '/api/v3/visual-asset/group/M6I_N7/1/image' t Transfer: 1220 : 10|13:06:37.6494|pAIoFW|DANIEL|OAuth: /api/settings/group/0?_dc=1608037608658 t Transfer: 1220 : 10|13:06:37.6494|pAIoFW|DANIEL|GetCurrentUser.. t Transfer: 1220 : 10|13:06:37.6494|pAIoFW|DANIEL| OAuth authenticated t Transfer: 1220 : 10|13:06:37.6494|pAIoFW|DANIEL| user DANIEL. t Verbose: 1220 : 10|13:06:37.6494|pAIoFW|DANIEL|OAuth. User logged in: DANIEL t Transfer: 1220 : 10|13:06:37.6494|hvWERo|DANIEL|OAuth: /api/settings/user/defaultHomePage?_dc=1608037608704 t Transfer: 1220 : 10|13:06:37.6494|hvWERo|DANIEL|GetCurrentUser.. t Transfer: 1220 : 10|13:06:37.6494|hvWERo|DANIEL| OAuth authenticated t Transfer: 1220 : 10|13:06:37.6494|hvWERo|DANIEL| user DANIEL. t Verbose: 1220 : 10|13:06:37.6494|hvWERo|DANIEL|OAuth. User logged in: DANIEL t Transfer: 1220 : 10|13:06:37.6494|hvWERo|DANIEL|GetCurrentUser.. t Transfer: 1220 : 10|13:06:37.6494|hvWERo|DANIEL| OAuth authenticated t Transfer: 1220 : 10|13:06:37.6494|hvWERo|DANIEL| user DANIEL. t Verbose: 1220 : 10|13:06:37.6494|eiz4jZ|DANIEL|imfx v3 API took 0.299s '/api/settings/group/0?_dc=1608037608508' t Verbose: 1220 : 10|13:06:37.6494|pAIoFW|DANIEL|imfx v3 API took 0.160s '/api/settings/group/0?_dc=1608037608658' t Verbose: 1220 : 10|13:06:37.6494|2b0m~8||imfx v3 API took 0.057s '/api/v3/visual-asset/group/M6I_N7/0/image' t Verbose: 1220 : 10|13:06:37.6494|hvWERo|DANIEL|imfx v3 API took 0.117s '/api/settings/user/defaultHomePage?_dc=1608037608704' t Transfer: 1220 : 10|13:06:38.6806|O0Rmng|DANIEL|OAuth: /api/settings/user/consumer?_dc=1608037609670 t Transfer: 1220 : 10|13:06:38.6806|O0Rmng|DANIEL|GetCurrentUser.. t Transfer: 1220 : 10|13:06:38.6806|O0Rmng|DANIEL| OAuth authenticated t Transfer: 1220 : 10|13:06:38.6806|O0Rmng|DANIEL| user DANIEL. t Verbose: 1220 : 10|13:06:38.6806|O0Rmng|DANIEL|OAuth. User logged in: DANIEL t Transfer: 1220 : 10|13:06:38.6806|O0Rmng|DANIEL|GetCurrentUser.. t Transfer: 1220 : 10|13:06:38.6806|O0Rmng|DANIEL| OAuth authenticated t Transfer: 1220 : 10|13:06:38.6806|O0Rmng|DANIEL| user DANIEL. t Verbose: 1220 : 10|13:06:38.6806|O0Rmng|DANIEL|imfx v3 API took 0.007s '/api/settings/user/consumer?_dc=1608037609670' t Transfer: 1220 : 10|13:06:38.6806|NXABsk|DANIEL|OAuth: /api/user-preferences?keys=consumer.recent.data&_dc=1608037609837 t Transfer: 1220 : 10|13:06:38.6806|NXABsk|DANIEL|GetCurrentUser.. t Transfer: 1220 : 10|13:06:38.6806|NXABsk|DANIEL| OAuth authenticated t Transfer: 1220 : 10|13:06:38.6806|NXABsk|DANIEL| user DANIEL. t Verbose: 1220 : 10|13:06:38.6806|NXABsk|DANIEL|OAuth. User logged in: DANIEL t Information: 1220 : 10|13:06:38.6806|NXABsk|DANIEL|GetUserDataByKeys: consumer.recent.data t Transfer: 1220 : 10|13:06:38.6806|NXABsk|DANIEL|GetCurrentUser.. t Transfer: 1220 : 10|13:06:38.6806|NXABsk|DANIEL| OAuth authenticated t Transfer: 1220 : 10|13:06:38.6806|NXABsk|DANIEL| user DANIEL. t Verbose: 1220 : 10|13:06:38.6806|NXABsk|DANIEL|imfx v3 API took 0.004s '/api/user-preferences?keys=consumer.recent.data&_dc=1608037609837' t Transfer: 1220 : 10|13:06:39.0869|WQ76ZE|DANIEL|OAuth: /api/settings/user/defaultSearch?_dc=1608037610083 t Transfer: 1220 : 10|13:06:39.0869|WQ76ZE|DANIEL|GetCurrentUser.. t Transfer: 1220 : 10|13:06:39.0869|WQ76ZE|DANIEL| OAuth authenticated t Transfer: 1220 : 10|13:06:39.0869|WQ76ZE|DANIEL| user DANIEL. t Verbose: 1220 : 10|13:06:39.0869|WQ76ZE|DANIEL|OAuth. User logged in: DANIEL t Transfer: 1220 : 10|13:06:39.0869|WQ76ZE|DANIEL|GetCurrentUser.. t Transfer: 1220 : 10|13:06:39.0869|WQ76ZE|DANIEL| OAuth authenticated t Transfer: 1220 : 10|13:06:39.0869|WQ76ZE|DANIEL| user DANIEL. t Verbose: 1220 : 10|13:06:39.0869|WQ76ZE|DANIEL|imfx v3 API took 0.007s '/api/settings/user/defaultSearch?_dc=1608037610083' t Transfer: 1220 : 10|13:06:39.0869|DqTTNp|DANIEL|OAuth: /api/settings/user/startSearch?_dc=1608037610084 t Transfer: 1220 : 10|13:06:39.0869|DqTTNp|DANIEL|GetCurrentUser.. t Transfer: 1220 : 10|13:06:39.0869|DqTTNp|DANIEL| OAuth authenticated t Transfer: 1220 : 10|13:06:39.0869|DqTTNp|DANIEL| user DANIEL. t Verbose: 1220 : 10|13:06:39.0869|DqTTNp|DANIEL|OAuth. User logged in: DANIEL t Transfer: 1220 : 10|13:06:39.0869|DqTTNp|DANIEL|GetCurrentUser.. t Transfer: 1220 : 10|13:06:39.0869|DqTTNp|DANIEL| OAuth authenticated t Transfer: 1220 : 10|13:06:39.0869|DqTTNp|DANIEL| user DANIEL. t Verbose: 1220 : 10|13:06:39.0869|DqTTNp|DANIEL|imfx v3 API took 0.006s '/api/settings/user/startSearch?_dc=1608037610084' t Transfer: 1220 : 10|13:06:39.0869|2KkoM~|DANIEL|OAuth: /api/user-preferences?keys=consumer.recent.data&_dc=1608037610130 t Transfer: 1220 : 10|13:06:39.0869|2KkoM~|DANIEL|GetCurrentUser.. t Transfer: 1220 : 10|13:06:39.0869|2KkoM~|DANIEL| OAuth authenticated t Transfer: 1220 : 10|13:06:39.0869|2KkoM~|DANIEL| user DANIEL. t Verbose: 1220 : 10|13:06:39.0869|2KkoM~|DANIEL|OAuth. User logged in: DANIEL t Information: 1220 : 10|13:06:39.0869|2KkoM~|DANIEL|GetUserDataByKeys: consumer.recent.data t Transfer: 1220 : 10|13:06:39.0869|2KkoM~|DANIEL|GetCurrentUser.. t Transfer: 1220 : 10|13:06:39.0869|2KkoM~|DANIEL| OAuth authenticated t Transfer: 1220 : 10|13:06:39.0869|2KkoM~|DANIEL| user DANIEL. t Verbose: 1220 : 10|13:06:39.0869|2KkoM~|DANIEL|imfx v3 API took 0.004s '/api/user-preferences?keys=consumer.recent.data&_dc=1608037610130' t Information: 1220 : 10|13:06:39.0869|F2NbSi||GetCache. t Information: 1220 : 10|13:06:39.0869|F2NbSi||GetCache. Found: C:\inetpub\wwwroot\imfxcore\VisualAssetsCache\5_3_M6I_N7.png t Information: 1220 : 10|13:06:39.0869|F2NbSi||GetCache. Data read: 0 t Verbose: 1220 : 10|13:06:39.0869|F2NbSi||imfx v3 API took 0.003s '/api/v3/visual-asset/group/M6I_N7/3/image' t Transfer: 1220 : 10|13:06:40.3213|hx2m_A|DANIEL|OAuth: /api/user-group-preferences?globals=htmlplayerhotkeys,audioOnFrameForward&_dc=1608037611445 t Transfer: 1220 : 10|13:06:40.3213|hx2m_A|DANIEL|GetCurrentUser.. t Transfer: 1220 : 10|13:06:40.3213|hx2m_A|DANIEL| OAuth authenticated t Transfer: 1220 : 10|13:06:40.3213|hx2m_A|DANIEL| user DANIEL. t Verbose: 1220 : 10|13:06:40.3213|hx2m_A|DANIEL|OAuth. User logged in: DANIEL t Transfer: 1220 : 10|13:06:40.3213|hx2m_A|DANIEL|GetCurrentUser.. t Transfer: 1220 : 10|13:06:40.3213|hx2m_A|DANIEL| OAuth authenticated t Transfer: 1220 : 10|13:06:40.3213|hx2m_A|DANIEL| user DANIEL. t Verbose: 1220 : 10|13:06:40.3213|hx2m_A|DANIEL|imfx v3 API took 0.007s '/api/user-group-preferences?globals=htmlplayerhotkeys,audioOnFrameForward&_dc=1608037611445' t Transfer: 1220 : 10|13:06:40.3213|fwebjU|DANIEL|OAuth: /api/v3/versionvideo/299543?_dc=1608037611500 t Transfer: 1220 : 10|13:06:40.3213|fwebjU|DANIEL|GetCurrentUser.. t Transfer: 1220 : 10|13:06:40.3213|fwebjU|DANIEL| OAuth authenticated t Transfer: 1220 : 10|13:06:40.3213|fwebjU|DANIEL| user DANIEL. t Verbose: 1220 : 10|13:06:40.3213|fwebjU|DANIEL|OAuth. User logged in: DANIEL t Transfer: 1220 : 10|13:06:40.3213|fwebjU|DANIEL|GetCurrentUser.. t Transfer: 1220 : 10|13:06:40.3213|fwebjU|DANIEL| OAuth authenticated t Transfer: 1220 : 10|13:06:40.3213|fwebjU|DANIEL| user DANIEL. t Transfer: 1220 : 10|13:06:40.9307|fwebjU|DANIEL|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\GOPR0156.mp4 subfolder t Transfer: 1220 : 10|13:06:40.9307|fwebjU|DANIEL| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/GOPR0156.mp4 t Transfer: 1220 : 10|13:06:40.9307|fwebjU|DANIEL|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/GOPR0156.mp4 t Transfer: 1220 : 10|13:06:40.9307|fwebjU|DANIEL|GetCurrentUser.. t Transfer: 1220 : 10|13:06:40.9307|fwebjU|DANIEL| OAuth authenticated t Transfer: 1220 : 10|13:06:40.9307|fwebjU|DANIEL| user DANIEL. t Verbose: 1220 : 10|13:06:40.9307|fwebjU|DANIEL|imfx v3 API took 0.512s '/api/v3/versionvideo/299543?_dc=1608037611500' t Transfer: 1220 : 10|13:06:43.7744|xZBAOh|DANIEL|OAuth: /api/view/searchinfo/Media?_dc=1608037614840 t Transfer: 1220 : 10|13:06:43.7744|xZBAOh|DANIEL|GetCurrentUser.. t Transfer: 1220 : 10|13:06:43.7744|xZBAOh|DANIEL| OAuth authenticated t Transfer: 1220 : 10|13:06:43.7744|xZBAOh|DANIEL| user DANIEL. t Verbose: 1220 : 10|13:06:43.7744|xZBAOh|DANIEL|OAuth. User logged in: DANIEL t Information: 1220 : 10|13:06:43.7744|xZBAOh|DANIEL|GetAdvSearchColumns. search type Media grid . t Transfer: 1220 : 10|13:06:43.7744|rbPl7q|DANIEL|OAuth: /api/user-preferences?keys=adv.recent.searches.media&_dc=1608037614852 t Transfer: 1220 : 10|13:06:43.7744|r8u9rW|DANIEL|OAuth: /api/lookups/SearchSupportedOperators?_dc=1608037614843 t Transfer: 1220 : 10|13:06:43.7744|r8u9rW|DANIEL|GetCurrentUser.. t Transfer: 1220 : 10|13:06:43.7744|rbPl7q|DANIEL|GetCurrentUser.. t Transfer: 1220 : 10|13:06:43.7744|rbPl7q|DANIEL| OAuth authenticated t Transfer: 1220 : 10|13:06:43.7744|r8u9rW|DANIEL| OAuth authenticated t Transfer: 1220 : 10|13:06:43.7744|rbPl7q|DANIEL| user DANIEL. t Transfer: 1220 : 10|13:06:43.7744|r8u9rW|DANIEL| user DANIEL. t Verbose: 1220 : 10|13:06:43.7744|r8u9rW|DANIEL|OAuth. User logged in: DANIEL t Verbose: 1220 : 10|13:06:43.7744|rbPl7q|DANIEL|OAuth. User logged in: DANIEL t Information: 1220 : 10|13:06:43.7744|rbPl7q|DANIEL|GetUserDataByKeys: adv.recent.searches.media t Transfer: 1220 : 10|13:06:43.7744|rbPl7q|DANIEL|GetCurrentUser.. t Transfer: 1220 : 10|13:06:43.7744|rbPl7q|DANIEL| OAuth authenticated t Transfer: 1220 : 10|13:06:43.7744|rbPl7q|DANIEL| user DANIEL. t Verbose: 1220 : 10|13:06:43.7744|r8u9rW|DANIEL|imfx v3 API took 0.000s '/api/lookups/SearchSupportedOperators?_dc=1608037614843' t Verbose: 1220 : 10|13:06:43.7744|rbPl7q|DANIEL|imfx v3 API took 0.005s '/api/user-preferences?keys=adv.recent.searches.media&_dc=1608037614852' t Verbose: 1220 : 10|13:06:43.7744|xZBAOh|DANIEL|imfx v3 API took 0.015s '/api/view/searchinfo/Media?_dc=1608037614840' t Transfer: 1220 : 10|13:06:43.7744|mHcj7Q|DANIEL|OAuth: /api/view/searches/Media?_dc=1608037614941 t Transfer: 1220 : 10|13:06:43.7744|mHcj7Q|DANIEL|GetCurrentUser.. t Transfer: 1220 : 10|13:06:43.7744|mHcj7Q|DANIEL| OAuth authenticated t Transfer: 1220 : 10|13:06:43.7744|mHcj7Q|DANIEL| user DANIEL. t Verbose: 1220 : 10|13:06:43.7744|mHcj7Q|DANIEL|OAuth. User logged in: DANIEL t Information: 1220 : 10|13:06:43.7744|mHcj7Q|DANIEL|GetSavedSearchNames. search type Media. t Transfer: 1220 : 10|13:06:43.7744|mHcj7Q|DANIEL|GetCurrentUser.. t Transfer: 1220 : 10|13:06:43.7744|mHcj7Q|DANIEL| OAuth authenticated t Transfer: 1220 : 10|13:06:43.7744|mHcj7Q|DANIEL| user DANIEL. t Transfer: 1220 : 10|13:06:43.7744|x0bkia|DANIEL|OAuth: /api/view/info/MediaGrid?lang=en-GB&_dc=1608037614952 t Transfer: 1220 : 10|13:06:43.7744|x0bkia|DANIEL|GetCurrentUser.. t Transfer: 1220 : 10|13:06:43.7744|x0bkia|DANIEL| OAuth authenticated t Transfer: 1220 : 10|13:06:43.7744|x0bkia|DANIEL| user DANIEL. t Verbose: 1220 : 10|13:06:43.7744|x0bkia|DANIEL|OAuth. User logged in: DANIEL t Information: 1220 : 10|13:06:43.7744|x0bkia|DANIEL|GetGridViewBuilder. builder type MediaGrid. t Transfer: 1220 : 10|13:06:43.7744|KdKuft|DANIEL|OAuth: /api/settings/user/searchLayoutConfig?_dc=1608037614954 t Transfer: 1220 : 10|13:06:43.7744|KdKuft|DANIEL|GetCurrentUser.. t Transfer: 1220 : 10|13:06:43.7744|KdKuft|DANIEL| OAuth authenticated t Transfer: 1220 : 10|13:06:43.7744|KdKuft|DANIEL| user DANIEL. t Verbose: 1220 : 10|13:06:43.7744|KdKuft|DANIEL|OAuth. User logged in: DANIEL t Transfer: 1220 : 10|13:06:43.7744|KdKuft|DANIEL|GetCurrentUser.. t Transfer: 1220 : 10|13:06:43.7744|KdKuft|DANIEL| OAuth authenticated t Transfer: 1220 : 10|13:06:43.7744|KdKuft|DANIEL| user DANIEL. t Transfer: 1220 : 10|13:06:43.7744|x0bkia|DANIEL|GetCurrentUser.. t Transfer: 1220 : 10|13:06:43.7744|x0bkia|DANIEL| OAuth authenticated t Transfer: 1220 : 10|13:06:43.7744|x0bkia|DANIEL| user DANIEL. t Verbose: 1220 : 10|13:06:43.7744|KdKuft|DANIEL|imfx v3 API took 0.009s '/api/settings/user/searchLayoutConfig?_dc=1608037614954' t Information: 1220 : 10|13:06:43.7744|x0bkia|DANIEL|UserGridView. LoadView. ID 760, Name Default. t Transfer: 1220 : 10|13:06:43.7744|x0bkia|DANIEL|GetCurrentUser.. t Transfer: 1220 : 10|13:06:43.7744|x0bkia|DANIEL| OAuth authenticated t Transfer: 1220 : 10|13:06:43.7744|x0bkia|DANIEL| user DANIEL. t Verbose: 1220 : 10|13:06:43.9931|mHcj7Q|DANIEL|imfx v3 API took 0.044s '/api/view/searches/Media?_dc=1608037614941' t Transfer: 1220 : 10|13:06:43.9931|x0bkia|DANIEL|GetCurrentUser.. t Transfer: 1220 : 10|13:06:43.9931|x0bkia|DANIEL| OAuth authenticated t Transfer: 1220 : 10|13:06:43.9931|x0bkia|DANIEL| user DANIEL. t Verbose: 1220 : 10|13:06:43.9931|x0bkia|DANIEL|imfx v3 API took 0.059s '/api/view/info/MediaGrid?lang=en-GB&_dc=1608037614952' t Transfer: 1220 : 10|13:06:49.0797|YB9Mwa|DANIEL|OAuth: /api/lookups/AccessStatuses?_dc=1608037620263 t Transfer: 1220 : 10|13:06:49.0797|YB9Mwa|DANIEL|GetCurrentUser.. t Transfer: 1220 : 10|13:06:49.0797|YB9Mwa|DANIEL| OAuth authenticated t Transfer: 1220 : 10|13:06:49.0797|YB9Mwa|DANIEL| user DANIEL. t Verbose: 1220 : 10|13:06:49.0797|YB9Mwa|DANIEL|OAuth. User logged in: DANIEL t Verbose: 1220 : 10|13:06:49.0797|YB9Mwa|DANIEL|imfx v3 API took 0.000s '/api/lookups/AccessStatuses?_dc=1608037620263' t Transfer: 1220 : 10|13:07:01.6914|7Y5Xwy|DANIEL|OAuth: /api/lookups/MediaFileTypes?_dc=1608037632765 t Transfer: 1220 : 10|13:07:01.6914|7Y5Xwy|DANIEL|GetCurrentUser.. t Transfer: 1220 : 10|13:07:01.6914|7Y5Xwy|DANIEL| OAuth authenticated t Transfer: 1220 : 10|13:07:01.6914|7Y5Xwy|DANIEL| user DANIEL. t Verbose: 1220 : 10|13:07:01.6914|7Y5Xwy|DANIEL|OAuth. User logged in: DANIEL t Verbose: 1220 : 10|13:07:01.6914|7Y5Xwy|DANIEL|imfx v3 API took 0.000s '/api/lookups/MediaFileTypes?_dc=1608037632765' t Transfer: 1220 : 10|13:07:11.2653|lvooqT|DANIEL|OAuth: /api/v3/search/Media?_dc=1608037642360 t Transfer: 1220 : 10|13:07:11.2653|lvooqT|DANIEL|GetCurrentUser.. t Transfer: 1220 : 10|13:07:11.2653|lvooqT|DANIEL| OAuth authenticated t Transfer: 1220 : 10|13:07:11.2653|lvooqT|DANIEL| user DANIEL. t Verbose: 1220 : 10|13:07:11.2653|lvooqT|DANIEL|OAuth. User logged in: DANIEL t Information: 1220 : 10|13:07:11.4685|lvooqT|DANIEL|V3Api.SearchMedia t Information: 1220 : 10|13:07:11.4685|lvooqT|DANIEL|V3Api.SearchGeneric t Transfer: 1220 : 10|13:07:11.4694|lvooqT|DANIEL|GetCurrentUser.. t Transfer: 1220 : 10|13:07:11.4694|lvooqT|DANIEL| OAuth authenticated t Transfer: 1220 : 10|13:07:11.4694|lvooqT|DANIEL| user DANIEL. t Information: 1220 : 10|13:07:11.6735|lvooqT|DANIEL|Running solr search: [q, ((((media_format:((61) OR (62) OR (101))))) 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 (ANTV) OR (ATP) OR (BBC) OR (BEDIG) 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 (ICCCTY) OR (ICCCWC) OR (ICCCWL2) OR (ICCICC) OR (ICCTWT) OR (ICCU19CWC) OR (ICCWCCL) OR (ICCWCL) OR (ICCWCP) OR (ICCWTC) OR (ICCWTT) OR (ICCWWC) 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 (TVONE) 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 (VIVA) 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|13:07:11.6735|lvooqT|DANIEL|Solr query returned: 5 in 18ms t Information: 1220 : 10|13:07:11.8766|lvooqT|DANIEL|MediaSearch SQL: select r.*, nvl((select TMD_STR_AGG(c.u_id_pfix ) from tm_ctnrs c, tm_mi_tpi_lnx l where l.miid=r.id and c.u_id=l.tpiid and r.media_type=1),'') BARCODE, nvl(lnk.lib_loc_ext_id,0) lib_loc_ext_id, nvl(lnk.ctnr_loan_stat,0) ctnr_loan_status, nvl(lnk.ctnr_stat,0) ctnr_stat, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID , GETMEDIALOC(r.id, r.media_type, r.compil, r.m_ctnr_int_o_loc, r.m_ctnr_ext_o_loc, r.m_ctnr_loc) LOCATION, nvl(dfl.fSOM,0) FILE_SOM, nvl(dfl.fEOM,0) FILE_EOM, dfl.fos_fname FILENAME, dfl.DFILE_LINK_GUID, dfl.OS_GUID, dfl.SUB_FOLDER, dfl.ORIGINAL_FILENAME from (select a.*, rownum rnum from (select m.*, coalesce(m.primary_thumb_id, (select v.primary_thumb_id from tm_pg_rl v where v.id=m.pgm_parent_id)) primary_thumb_id2 from tmddba.tm_mis m ,(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 Verbose: 1220 : 10|13:07:12.0797|lvooqT|DANIEL|Custom xml fields query: select * from (select m.id, m.pgm_abs_id, m.pgm_parent_id from TM_MIS m where id in ( (select /*+ cardinality(4) */ column_value id from table(:ids)) ) ) r ,lateral (select z.x0 from tm_xml_metadata x ,xmltable('/*:Details[1]' passing x.xml_data columns x0 varchar2(500) path '/Details[1]/PONumber[1]')(+) z where ( x.miid = r.id ) and x.schema_typ = 12064 order by x.id desc fetch first 1 rows only)(+) ,lateral (select z.x1 from tm_xml_metadata x ,xmltable('/*:Rights[1]' passing x.xml_data columns x1 varchar2(500) path '/Rights[1]/PriceGroup[1]')(+) z where ( x.miid = r.id ) and x.schema_typ = 22066 order by x.id desc fetch first 1 rows only)(+) t Information: 1220 : 10|13:07:12.0797|lvooqT|DANIEL| timing: 00:00:00.7146074 t Verbose: 1220 : 10|13:07:12.0797|lvooqT|DANIEL|imfx v3 API took 0.751s '/api/v3/search/Media?_dc=1608037642360' t Transfer: 1220 : 10|13:07:12.2828|lvooqT|DANIEL|GetUrl. Storage |Audio| filename I:\Audio\piano.mp3 subfolder t Transfer: 1220 : 10|13:07:12.2828|lvooqT|DANIEL| GetFileName result https://imfxv3tm.tmd.tv/AudioServer/piano.mp3 t Transfer: 1220 : 10|13:07:12.2828|lvooqT|DANIEL|GetUrl. result https://imfxv3tm.tmd.tv/AudioServer/piano.mp3 t Transfer: 1220 : 10|13:07:12.2828|lvooqT|DANIEL|GetCurrentUser.. t Transfer: 1220 : 10|13:07:12.2828|lvooqT|DANIEL| OAuth authenticated t Transfer: 1220 : 10|13:07:12.2828|lvooqT|DANIEL| user DANIEL. t Transfer: 1220 : 10|13:07:12.2828|lvooqT|DANIEL|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\N0001764.ts subfolder t Transfer: 1220 : 10|13:07:12.2828|lvooqT|DANIEL| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/N0001764.ts t Transfer: 1220 : 10|13:07:12.2828|lvooqT|DANIEL|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/N0001764.ts t Transfer: 1220 : 10|13:07:12.2828|lvooqT|DANIEL|GetCurrentUser.. t Transfer: 1220 : 10|13:07:12.2828|lvooqT|DANIEL| OAuth authenticated t Transfer: 1220 : 10|13:07:12.2828|lvooqT|DANIEL| user DANIEL. t Transfer: 1220 : 10|13:07:12.2828|lvooqT|DANIEL|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\N0001765.ts subfolder t Transfer: 1220 : 10|13:07:12.2828|lvooqT|DANIEL| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/N0001765.ts t Transfer: 1220 : 10|13:07:12.2828|lvooqT|DANIEL|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/N0001765.ts t Transfer: 1220 : 10|13:07:12.2828|lvooqT|DANIEL|GetCurrentUser.. t Transfer: 1220 : 10|13:07:12.2828|lvooqT|DANIEL| OAuth authenticated t Transfer: 1220 : 10|13:07:12.2828|lvooqT|DANIEL| user DANIEL. t Transfer: 1220 : 10|13:07:12.2828|lvooqT|DANIEL|GetUrl. Storage |TEMP_UPLOAD| filename \\192.168.120.254\DemoFS\Digital Assets\TEMP_UPLOAD\b74c1499b96a\5.mp3 subfolder b74c1499b96a\ t Transfer: 1220 : 10|13:07:12.2828|lvooqT|DANIEL| GetFileName result https://demo.tmd.tv/Temp Upload/5.mp3 t Transfer: 1220 : 10|13:07:12.2828|lvooqT|DANIEL|GetUrl. result https://demo.tmd.tv/Temp Upload/5.mp3 t Transfer: 1220 : 10|13:07:12.2828|lvooqT|DANIEL|GetCurrentUser.. t Transfer: 1220 : 10|13:07:12.2828|lvooqT|DANIEL| OAuth authenticated t Transfer: 1220 : 10|13:07:12.2828|lvooqT|DANIEL| user DANIEL. t Transfer: 1220 : 10|13:07:12.2828|lvooqT|DANIEL|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\fl1.mp1 subfolder t Transfer: 1220 : 10|13:07:12.2828|lvooqT|DANIEL| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/fl1.mp1 t Transfer: 1220 : 10|13:07:12.2828|lvooqT|DANIEL|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/fl1.mp1 t Transfer: 1220 : 10|13:07:12.2828|lvooqT|DANIEL|GetCurrentUser.. t Transfer: 1220 : 10|13:07:12.2828|lvooqT|DANIEL| OAuth authenticated t Transfer: 1220 : 10|13:07:12.2828|lvooqT|DANIEL| user DANIEL. t Transfer: 1220 : 10|13:07:12.4859|sDSlDO|DANIEL|OAuth: /api/user-preferences?_dc=1608037643522 t Transfer: 1220 : 10|13:07:12.4859|sDSlDO|DANIEL|GetCurrentUser.. t Transfer: 1220 : 10|13:07:12.4859|sDSlDO|DANIEL| OAuth authenticated t Transfer: 1220 : 10|13:07:12.4859|sDSlDO|DANIEL| user DANIEL. t Verbose: 1220 : 10|13:07:12.4859|sDSlDO|DANIEL|OAuth. User logged in: DANIEL t Verbose: 1220 : 10|13:07:12.4859|sDSlDO|DANIEL|StoreUserDataByKeys.. t Transfer: 1220 : 10|13:07:12.4859|sDSlDO|DANIEL|GetCurrentUser.. t Transfer: 1220 : 10|13:07:12.4859|sDSlDO|DANIEL| OAuth authenticated t Transfer: 1220 : 10|13:07:12.4859|sDSlDO|DANIEL| user DANIEL. t Verbose: 1220 : 10|13:07:12.4859|sDSlDO|DANIEL|imfx v3 API took 0.031s '/api/user-preferences?_dc=1608037643522' t Transfer: 1220 : 10|13:07:13.0953|67QKqE|DANIEL|OAuth: /api/lookups/FriendlyNames?_dc=1608037644135 t Transfer: 1220 : 10|13:07:13.0953|67QKqE|DANIEL|GetCurrentUser.. t Transfer: 1220 : 10|13:07:13.0953|67QKqE|DANIEL| OAuth authenticated t Transfer: 1220 : 10|13:07:13.0953|67QKqE|DANIEL| user DANIEL. t Verbose: 1220 : 10|13:07:13.0953|67QKqE|DANIEL|OAuth. User logged in: DANIEL t Verbose: 1220 : 10|13:07:13.0953|67QKqE|DANIEL|imfx v3 API took 0.000s '/api/lookups/FriendlyNames?_dc=1608037644135' t Transfer: 1220 : 10|13:07:13.0953|CywWEx|DANIEL|OAuth: /api/v3/search/Media?_dc=1608037644138 t Transfer: 1220 : 10|13:07:13.0953|CywWEx|DANIEL|GetCurrentUser.. t Transfer: 1220 : 10|13:07:13.0953|CywWEx|DANIEL| OAuth authenticated t Transfer: 1220 : 10|13:07:13.0953|CywWEx|DANIEL| user DANIEL. t Verbose: 1220 : 10|13:07:13.0953|CywWEx|DANIEL|OAuth. User logged in: DANIEL t Information: 1220 : 10|13:07:13.0953|CywWEx|DANIEL|V3Api.SearchMedia t Information: 1220 : 10|13:07:13.0953|CywWEx|DANIEL|V3Api.SearchGeneric t Transfer: 1220 : 10|13:07:13.0953|CywWEx|DANIEL|GetCurrentUser.. t Transfer: 1220 : 10|13:07:13.0953|CywWEx|DANIEL| OAuth authenticated t Transfer: 1220 : 10|13:07:13.0953|CywWEx|DANIEL| user DANIEL. t Information: 1220 : 10|13:07:13.0953|CywWEx|DANIEL|MediaSearch SQL: select r.*, nvl((select TMD_STR_AGG(c.u_id_pfix ) from tm_ctnrs c, tm_mi_tpi_lnx l where l.miid=r.id and c.u_id=l.tpiid and r.media_type=1),'') BARCODE, nvl(lnk.lib_loc_ext_id,0) lib_loc_ext_id, nvl(lnk.ctnr_loan_stat,0) ctnr_loan_status, nvl(lnk.ctnr_stat,0) ctnr_stat, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID , (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=290812 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,'|ANTV|')>0 OR INSTR(m.OWNERS,'|ATP|')>0 OR INSTR(m.OWNERS,'|BBC|')>0 OR INSTR(m.OWNERS,'|BEDIG|')>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,'|ICCCTY|')>0 OR INSTR(m.OWNERS,'|ICCCWC|')>0 OR INSTR(m.OWNERS,'|ICCCWL2|')>0 OR INSTR(m.OWNERS,'|ICCICC|')>0 OR INSTR(m.OWNERS,'|ICCTWT|')>0 OR INSTR(m.OWNERS,'|ICCU19CWC|')>0 OR INSTR(m.OWNERS,'|ICCWCCL|')>0 OR INSTR(m.OWNERS,'|ICCWCL|')>0 OR INSTR(m.OWNERS,'|ICCWCP|')>0 OR INSTR(m.OWNERS,'|ICCWTC|')>0 OR INSTR(m.OWNERS,'|ICCWTT|')>0 OR INSTR(m.OWNERS,'|ICCWWC|')>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,'|TVONE|')>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,'|VIVA|')>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|13:07:13.0953|hQM1c_|DANIEL|OAuth: /api/v3/detailsview/MediaDetails/0?lang=en-GB&_dc=1608037644219 t Transfer: 1220 : 10|13:07:13.0953|hQM1c_|DANIEL|GetCurrentUser.. t Transfer: 1220 : 10|13:07:13.0953|hQM1c_|DANIEL| OAuth authenticated t Transfer: 1220 : 10|13:07:13.0953|hQM1c_|DANIEL| user DANIEL. t Verbose: 1220 : 10|13:07:13.0953|hQM1c_|DANIEL|OAuth. User logged in: DANIEL t Transfer: 1220 : 10|13:07:13.0953|hQM1c_|DANIEL|GetCurrentUser.. t Transfer: 1220 : 10|13:07:13.0953|hQM1c_|DANIEL| OAuth authenticated t Transfer: 1220 : 10|13:07:13.0953|hQM1c_|DANIEL| user DANIEL. t Transfer: 1220 : 10|13:07:13.0953|LR4dzo|DANIEL|OAuth: /api/lookups/FriendlyNames?_dc=1608037644221 t Transfer: 1220 : 10|13:07:13.0953|LR4dzo|DANIEL|GetCurrentUser.. t Transfer: 1220 : 10|13:07:13.0953|LR4dzo|DANIEL| OAuth authenticated t Transfer: 1220 : 10|13:07:13.0953|LR4dzo|DANIEL| user DANIEL. t Verbose: 1220 : 10|13:07:13.0953|LR4dzo|DANIEL|OAuth. User logged in: DANIEL t Verbose: 1220 : 10|13:07:13.0953|LR4dzo|DANIEL|imfx v3 API took 0.000s '/api/lookups/FriendlyNames?_dc=1608037644221' t Information: 1220 : 10|13:07:13.0953|hQM1c_|DANIEL|GetSystemPref. Pref: DetailsView, Type: -4013, subType: 0 t Information: 1220 : 10|13:07:13.0953|hQM1c_|DANIEL|GetSystemPref. Pref: DetailsView, Type: -4013, subType: 0 t Information: 1220 : 10|13:07:13.0953|CywWEx|DANIEL| timing: 00:00:00.1491415 t Verbose: 1220 : 10|13:07:13.0953|CywWEx|DANIEL|imfx v3 API took 0.149s '/api/v3/search/Media?_dc=1608037644138' t Transfer: 1220 : 10|13:07:13.0953|CywWEx|DANIEL|GetUrl. Storage |Audio| filename I:\Audio\piano.mp3 subfolder t Transfer: 1220 : 10|13:07:13.0953|CywWEx|DANIEL| GetFileName result https://imfxv3tm.tmd.tv/AudioServer/piano.mp3 t Transfer: 1220 : 10|13:07:13.0953|CywWEx|DANIEL|GetUrl. result https://imfxv3tm.tmd.tv/AudioServer/piano.mp3 t Transfer: 1220 : 10|13:07:13.0953|CywWEx|DANIEL|GetCurrentUser.. t Transfer: 1220 : 10|13:07:13.0953|CywWEx|DANIEL| OAuth authenticated t Transfer: 1220 : 10|13:07:13.0953|CywWEx|DANIEL| user DANIEL. t Verbose: 1220 : 10|13:07:13.3141|hQM1c_|DANIEL|imfx v3 API took 0.087s '/api/v3/detailsview/MediaDetails/0?lang=en-GB&_dc=1608037644219' t Transfer: 1220 : 10|13:07:13.3141|nXns2S|DANIEL|OAuth: /api/v3/mediavideo/290812?info=waveform&_dc=1608037644273 t Transfer: 1220 : 10|13:07:13.3141|nXns2S|DANIEL|GetCurrentUser.. t Transfer: 1220 : 10|13:07:13.3141|nXns2S|DANIEL| OAuth authenticated t Transfer: 1220 : 10|13:07:13.3141|nXns2S|DANIEL| user DANIEL. t Verbose: 1220 : 10|13:07:13.3141|nXns2S|DANIEL|OAuth. User logged in: DANIEL t Transfer: 1220 : 10|13:07:13.3141|SmylFo|DANIEL|OAuth: /api/v3/search/Media?_dc=1608037644354 t Transfer: 1220 : 10|13:07:13.3141|SmylFo|DANIEL|GetCurrentUser.. t Transfer: 1220 : 10|13:07:13.3141|SmylFo|DANIEL| OAuth authenticated t Transfer: 1220 : 10|13:07:13.3141|SmylFo|DANIEL| user DANIEL. t Verbose: 1220 : 10|13:07:13.3141|SmylFo|DANIEL|OAuth. User logged in: DANIEL t Information: 1220 : 10|13:07:13.3141|SmylFo|DANIEL|V3Api.SearchMedia t Information: 1220 : 10|13:07:13.3141|SmylFo|DANIEL|V3Api.SearchGeneric t Transfer: 1220 : 10|13:07:13.3141|SmylFo|DANIEL|GetCurrentUser.. t Transfer: 1220 : 10|13:07:13.3141|SmylFo|DANIEL| OAuth authenticated t Transfer: 1220 : 10|13:07:13.3141|SmylFo|DANIEL| user DANIEL. t Information: 1220 : 10|13:07:13.3141|SmylFo|DANIEL|MediaSearch SQL: select r.*, nvl((select TMD_STR_AGG(c.u_id_pfix ) from tm_ctnrs c, tm_mi_tpi_lnx l where l.miid=r.id and c.u_id=l.tpiid and r.media_type=1),'') BARCODE, nvl(lnk.lib_loc_ext_id,0) lib_loc_ext_id, nvl(lnk.ctnr_loan_stat,0) ctnr_loan_status, nvl(lnk.ctnr_stat,0) ctnr_stat, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID , (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=290812 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,'|ANTV|')>0 OR INSTR(m.OWNERS,'|ATP|')>0 OR INSTR(m.OWNERS,'|BBC|')>0 OR INSTR(m.OWNERS,'|BEDIG|')>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,'|ICCCTY|')>0 OR INSTR(m.OWNERS,'|ICCCWC|')>0 OR INSTR(m.OWNERS,'|ICCCWL2|')>0 OR INSTR(m.OWNERS,'|ICCICC|')>0 OR INSTR(m.OWNERS,'|ICCTWT|')>0 OR INSTR(m.OWNERS,'|ICCU19CWC|')>0 OR INSTR(m.OWNERS,'|ICCWCCL|')>0 OR INSTR(m.OWNERS,'|ICCWCL|')>0 OR INSTR(m.OWNERS,'|ICCWCP|')>0 OR INSTR(m.OWNERS,'|ICCWTC|')>0 OR INSTR(m.OWNERS,'|ICCWTT|')>0 OR INSTR(m.OWNERS,'|ICCWWC|')>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,'|TVONE|')>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,'|VIVA|')>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|13:07:13.3141|SmylFo|DANIEL| timing: 00:00:00.0129465 t Verbose: 1220 : 10|13:07:13.3141|SmylFo|DANIEL|imfx v3 API took 0.013s '/api/v3/search/Media?_dc=1608037644354' t Transfer: 1220 : 10|13:07:13.3141|SmylFo|DANIEL|GetUrl. Storage |Audio| filename I:\Audio\piano.mp3 subfolder t Transfer: 1220 : 10|13:07:13.3141|SmylFo|DANIEL| GetFileName result https://imfxv3tm.tmd.tv/AudioServer/piano.mp3 t Transfer: 1220 : 10|13:07:13.3141|SmylFo|DANIEL|GetUrl. result https://imfxv3tm.tmd.tv/AudioServer/piano.mp3 t Transfer: 1220 : 10|13:07:13.3141|SmylFo|DANIEL|GetCurrentUser.. t Transfer: 1220 : 10|13:07:13.3141|SmylFo|DANIEL| OAuth authenticated t Transfer: 1220 : 10|13:07:13.3141|SmylFo|DANIEL| user DANIEL. t Transfer: 1220 : 10|13:07:13.3141|nXns2S|DANIEL|GetUrl. Storage |Audio| filename I:\Audio\piano.mp3 subfolder t Transfer: 1220 : 10|13:07:13.3141|nXns2S|DANIEL| GetFileName result https://imfxv3tm.tmd.tv/AudioServer/piano.mp3 t Transfer: 1220 : 10|13:07:13.3141|nXns2S|DANIEL|GetUrl. result https://imfxv3tm.tmd.tv/AudioServer/piano.mp3 t Transfer: 1220 : 10|13:07:13.3141|nXns2S|DANIEL|GetCurrentUser.. t Transfer: 1220 : 10|13:07:13.3141|nXns2S|DANIEL| OAuth authenticated t Transfer: 1220 : 10|13:07:13.3141|nXns2S|DANIEL| user DANIEL. t Verbose: 1220 : 10|13:07:13.3141|nXns2S|DANIEL|imfx v3 API took 0.042s '/api/v3/mediavideo/290812?info=waveform&_dc=1608037644273' t Transfer: 1220 : 10|13:07:14.9562|BoirLz|DANIEL|OAuth: /api/v3/detailsview/MediaDetails/5?lang=en-GB&_dc=1608037646121 t Transfer: 1220 : 10|13:07:14.9562|BoirLz|DANIEL|GetCurrentUser.. t Transfer: 1220 : 10|13:07:14.9562|BoirLz|DANIEL| OAuth authenticated t Transfer: 1220 : 10|13:07:14.9562|BoirLz|DANIEL| user DANIEL. t Verbose: 1220 : 10|13:07:14.9562|BoirLz|DANIEL|OAuth. User logged in: DANIEL t Transfer: 1220 : 10|13:07:14.9562|BoirLz|DANIEL|GetCurrentUser.. t Transfer: 1220 : 10|13:07:14.9562|BoirLz|DANIEL| OAuth authenticated t Transfer: 1220 : 10|13:07:14.9562|BoirLz|DANIEL| user DANIEL. t Transfer: 1220 : 10|13:07:14.9562|1Ggr6Q|DANIEL|OAuth: /api/v3/media-captions/298982?_dc=1608037646124 t Transfer: 1220 : 10|13:07:14.9562|1Ggr6Q|DANIEL|GetCurrentUser.. t Transfer: 1220 : 10|13:07:14.9562|1Ggr6Q|DANIEL| OAuth authenticated t Transfer: 1220 : 10|13:07:14.9562|1Ggr6Q|DANIEL| user DANIEL. t Verbose: 1220 : 10|13:07:14.9562|1Ggr6Q|DANIEL|OAuth. User logged in: DANIEL t Information: 1220 : 10|13:07:14.9562|BoirLz|DANIEL|GetSystemPref. Pref: DetailsView, Type: -4013, subType: 5 t Information: 1220 : 10|13:07:14.9562|6qbsRn|DANIEL|V3Api.GetMediaTagging t Information: 1220 : 10|13:07:14.9562|BoirLz|DANIEL|GetSystemPref. Pref: DetailsView, Type: -4013, subType: 0 t Information: 1220 : 10|13:07:14.9562|BoirLz|DANIEL|GetSystemPref. Pref: DetailsView, Type: -4013, subType: 5 t Information: 1220 : 10|13:07:14.9562|BoirLz|DANIEL|GetSystemPref. Pref: DetailsView, Type: -4013, subType: 0 t Verbose: 1220 : 10|13:07:15.1694|BoirLz|DANIEL|imfx v3 API took 0.045s '/api/v3/detailsview/MediaDetails/5?lang=en-GB&_dc=1608037646121' t Verbose: 1220 : 10|13:07:15.1694|1Ggr6Q|DANIEL|imfx v3 API took 0.045s '/api/v3/media-captions/298982?_dc=1608037646124' t Transfer: 1220 : 10|13:07:15.1694|JU8bYK|DANIEL|OAuth: /api/v3/mediavideo/298982?info=smudge&_dc=1608037646263 t Transfer: 1220 : 10|13:07:15.1694|JU8bYK|DANIEL|GetCurrentUser.. t Transfer: 1220 : 10|13:07:15.1694|JU8bYK|DANIEL| OAuth authenticated t Transfer: 1220 : 10|13:07:15.1694|JU8bYK|DANIEL| user DANIEL. t Verbose: 1220 : 10|13:07:15.1694|JU8bYK|DANIEL|OAuth. User logged in: DANIEL t Transfer: 1220 : 10|13:07:15.1694|JU8bYK|DANIEL|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\N0001764.ts subfolder t Transfer: 1220 : 10|13:07:15.1694|JU8bYK|DANIEL| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/N0001764.ts t Transfer: 1220 : 10|13:07:15.1694|JU8bYK|DANIEL|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/N0001764.ts t Transfer: 1220 : 10|13:07:15.1694|JU8bYK|DANIEL|GetCurrentUser.. t Transfer: 1220 : 10|13:07:15.1694|JU8bYK|DANIEL| OAuth authenticated t Transfer: 1220 : 10|13:07:15.1694|JU8bYK|DANIEL| user DANIEL. t Verbose: 1220 : 10|13:07:15.1694|JU8bYK|DANIEL|imfx v3 API took 0.031s '/api/v3/mediavideo/298982?info=smudge&_dc=1608037646263' t Transfer: 1220 : 10|13:07:15.1694|SLvV3S|DANIEL|OAuth: /api/v3/search/Media?_dc=1608037646313 t Transfer: 1220 : 10|13:07:15.1694|SLvV3S|DANIEL|GetCurrentUser.. t Transfer: 1220 : 10|13:07:15.1694|SLvV3S|DANIEL| OAuth authenticated t Transfer: 1220 : 10|13:07:15.1694|SLvV3S|DANIEL| user DANIEL. t Verbose: 1220 : 10|13:07:15.1694|SLvV3S|DANIEL|OAuth. User logged in: DANIEL t Information: 1220 : 10|13:07:15.1694|SLvV3S|DANIEL|V3Api.SearchMedia t Information: 1220 : 10|13:07:15.1694|SLvV3S|DANIEL|V3Api.SearchGeneric t Transfer: 1220 : 10|13:07:15.1694|SLvV3S|DANIEL|GetCurrentUser.. t Transfer: 1220 : 10|13:07:15.1694|SLvV3S|DANIEL| OAuth authenticated t Transfer: 1220 : 10|13:07:15.1694|SLvV3S|DANIEL| user DANIEL. t Information: 1220 : 10|13:07:15.1694|SLvV3S|DANIEL|MediaSearch SQL: select r.*, nvl((select TMD_STR_AGG(c.u_id_pfix ) from tm_ctnrs c, tm_mi_tpi_lnx l where l.miid=r.id and c.u_id=l.tpiid and r.media_type=1),'') BARCODE, nvl(lnk.lib_loc_ext_id,0) lib_loc_ext_id, nvl(lnk.ctnr_loan_stat,0) ctnr_loan_status, nvl(lnk.ctnr_stat,0) ctnr_stat, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID , (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=298982 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,'|ANTV|')>0 OR INSTR(m.OWNERS,'|ATP|')>0 OR INSTR(m.OWNERS,'|BBC|')>0 OR INSTR(m.OWNERS,'|BEDIG|')>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,'|ICCCTY|')>0 OR INSTR(m.OWNERS,'|ICCCWC|')>0 OR INSTR(m.OWNERS,'|ICCCWL2|')>0 OR INSTR(m.OWNERS,'|ICCICC|')>0 OR INSTR(m.OWNERS,'|ICCTWT|')>0 OR INSTR(m.OWNERS,'|ICCU19CWC|')>0 OR INSTR(m.OWNERS,'|ICCWCCL|')>0 OR INSTR(m.OWNERS,'|ICCWCL|')>0 OR INSTR(m.OWNERS,'|ICCWCP|')>0 OR INSTR(m.OWNERS,'|ICCWTC|')>0 OR INSTR(m.OWNERS,'|ICCWTT|')>0 OR INSTR(m.OWNERS,'|ICCWWC|')>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,'|TVONE|')>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,'|VIVA|')>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|13:07:15.3725|SLvV3S|DANIEL| timing: 00:00:00.1017343 t Verbose: 1220 : 10|13:07:15.3725|SLvV3S|DANIEL|imfx v3 API took 0.102s '/api/v3/search/Media?_dc=1608037646313' t Transfer: 1220 : 10|13:07:15.3725|SLvV3S|DANIEL|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\N0001764.ts subfolder t Transfer: 1220 : 10|13:07:15.3725|SLvV3S|DANIEL| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/N0001764.ts t Transfer: 1220 : 10|13:07:15.3725|SLvV3S|DANIEL|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/N0001764.ts t Transfer: 1220 : 10|13:07:15.3725|SLvV3S|DANIEL|GetCurrentUser.. t Transfer: 1220 : 10|13:07:15.3725|SLvV3S|DANIEL| OAuth authenticated t Transfer: 1220 : 10|13:07:15.3725|SLvV3S|DANIEL| user DANIEL. t Transfer: 1220 : 10|13:07:18.8291|~wBYro|DANIEL|OAuth: /api/v3/search/Media?_dc=1608037649892 t Transfer: 1220 : 10|13:07:18.8291|~wBYro|DANIEL|GetCurrentUser.. t Transfer: 1220 : 10|13:07:18.8291|~wBYro|DANIEL| OAuth authenticated t Transfer: 1220 : 10|13:07:18.8291|~wBYro|DANIEL| user DANIEL. t Verbose: 1220 : 10|13:07:18.8291|~wBYro|DANIEL|OAuth. User logged in: DANIEL t Information: 1220 : 10|13:07:18.8291|~wBYro|DANIEL|V3Api.SearchMedia t Information: 1220 : 10|13:07:18.8291|~wBYro|DANIEL|V3Api.SearchGeneric t Transfer: 1220 : 10|13:07:18.8291|~wBYro|DANIEL|GetCurrentUser.. t Transfer: 1220 : 10|13:07:18.8291|~wBYro|DANIEL| OAuth authenticated t Transfer: 1220 : 10|13:07:18.8291|~wBYro|DANIEL| user DANIEL. t Transfer: 1220 : 10|13:07:18.8291|rU66bi|DANIEL|OAuth: /api/v3/media-captions/298983?_dc=1608037649896 t Transfer: 1220 : 10|13:07:18.8291|rU66bi|DANIEL|GetCurrentUser.. t Transfer: 1220 : 10|13:07:18.8291|rU66bi|DANIEL| OAuth authenticated t Transfer: 1220 : 10|13:07:18.8291|rU66bi|DANIEL| user DANIEL. t Verbose: 1220 : 10|13:07:18.8291|rU66bi|DANIEL|OAuth. User logged in: DANIEL t Information: 1220 : 10|13:07:18.8291|~wBYro|DANIEL|MediaSearch SQL: select r.*, nvl((select TMD_STR_AGG(c.u_id_pfix ) from tm_ctnrs c, tm_mi_tpi_lnx l where l.miid=r.id and c.u_id=l.tpiid and r.media_type=1),'') BARCODE, nvl(lnk.lib_loc_ext_id,0) lib_loc_ext_id, nvl(lnk.ctnr_loan_stat,0) ctnr_loan_status, nvl(lnk.ctnr_stat,0) ctnr_stat, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID , (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=298983 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,'|ANTV|')>0 OR INSTR(m.OWNERS,'|ATP|')>0 OR INSTR(m.OWNERS,'|BBC|')>0 OR INSTR(m.OWNERS,'|BEDIG|')>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,'|ICCCTY|')>0 OR INSTR(m.OWNERS,'|ICCCWC|')>0 OR INSTR(m.OWNERS,'|ICCCWL2|')>0 OR INSTR(m.OWNERS,'|ICCICC|')>0 OR INSTR(m.OWNERS,'|ICCTWT|')>0 OR INSTR(m.OWNERS,'|ICCU19CWC|')>0 OR INSTR(m.OWNERS,'|ICCWCCL|')>0 OR INSTR(m.OWNERS,'|ICCWCL|')>0 OR INSTR(m.OWNERS,'|ICCWCP|')>0 OR INSTR(m.OWNERS,'|ICCWTC|')>0 OR INSTR(m.OWNERS,'|ICCWTT|')>0 OR INSTR(m.OWNERS,'|ICCWWC|')>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,'|TVONE|')>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,'|VIVA|')>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 Verbose: 1220 : 10|13:07:18.8291|rU66bi|DANIEL|imfx v3 API took 0.004s '/api/v3/media-captions/298983?_dc=1608037649896' t Information: 1220 : 10|13:07:18.8291|7wQNlC|DANIEL|V3Api.GetMediaTagging t Transfer: 1220 : 10|13:07:18.8291|r_MATm|DANIEL|OAuth: /api/v3/mediavideo/298983?info=smudge&_dc=1608037649954 t Transfer: 1220 : 10|13:07:18.8291|r_MATm|DANIEL|GetCurrentUser.. t Transfer: 1220 : 10|13:07:18.8291|r_MATm|DANIEL| OAuth authenticated t Transfer: 1220 : 10|13:07:18.8291|r_MATm|DANIEL| user DANIEL. t Verbose: 1220 : 10|13:07:18.8291|r_MATm|DANIEL|OAuth. User logged in: DANIEL t Transfer: 1220 : 10|13:07:18.8291|r_MATm|DANIEL|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\N0001765.ts subfolder t Transfer: 1220 : 10|13:07:18.8291|r_MATm|DANIEL| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/N0001765.ts t Transfer: 1220 : 10|13:07:18.8291|r_MATm|DANIEL|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/N0001765.ts t Transfer: 1220 : 10|13:07:18.8291|r_MATm|DANIEL|GetCurrentUser.. t Transfer: 1220 : 10|13:07:18.8291|r_MATm|DANIEL| OAuth authenticated t Transfer: 1220 : 10|13:07:18.8291|r_MATm|DANIEL| user DANIEL. t Verbose: 1220 : 10|13:07:18.8291|r_MATm|DANIEL|imfx v3 API took 0.008s '/api/v3/mediavideo/298983?info=smudge&_dc=1608037649954' t Information: 1220 : 10|13:07:18.8291|~wBYro|DANIEL| timing: 00:00:00.1213382 t Verbose: 1220 : 10|13:07:18.8291|~wBYro|DANIEL|imfx v3 API took 0.121s '/api/v3/search/Media?_dc=1608037649892' t Transfer: 1220 : 10|13:07:18.8291|~wBYro|DANIEL|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\N0001765.ts subfolder t Transfer: 1220 : 10|13:07:18.8291|~wBYro|DANIEL| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/N0001765.ts t Transfer: 1220 : 10|13:07:18.8291|~wBYro|DANIEL|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/N0001765.ts t Transfer: 1220 : 10|13:07:18.8291|~wBYro|DANIEL|GetCurrentUser.. t Transfer: 1220 : 10|13:07:18.8291|~wBYro|DANIEL| OAuth authenticated t Transfer: 1220 : 10|13:07:18.8291|~wBYro|DANIEL| user DANIEL. t Transfer: 1220 : 10|13:07:22.5010|g_HPQ~|DANIEL|OAuth: /api/v3/search/Media?_dc=1608037653540 t Transfer: 1220 : 10|13:07:22.5010|g_HPQ~|DANIEL|GetCurrentUser.. t Transfer: 1220 : 10|13:07:22.5010|g_HPQ~|DANIEL| OAuth authenticated t Transfer: 1220 : 10|13:07:22.5010|g_HPQ~|DANIEL| user DANIEL. t Verbose: 1220 : 10|13:07:22.5010|g_HPQ~|DANIEL|OAuth. User logged in: DANIEL t Information: 1220 : 10|13:07:22.5010|g_HPQ~|DANIEL|V3Api.SearchMedia t Information: 1220 : 10|13:07:22.5010|g_HPQ~|DANIEL|V3Api.SearchGeneric t Transfer: 1220 : 10|13:07:22.5010|g_HPQ~|DANIEL|GetCurrentUser.. t Transfer: 1220 : 10|13:07:22.5010|g_HPQ~|DANIEL| OAuth authenticated t Transfer: 1220 : 10|13:07:22.5010|g_HPQ~|DANIEL| user DANIEL. t Information: 1220 : 10|13:07:22.5010|g_HPQ~|DANIEL|MediaSearch SQL: select r.*, nvl((select TMD_STR_AGG(c.u_id_pfix ) from tm_ctnrs c, tm_mi_tpi_lnx l where l.miid=r.id and c.u_id=l.tpiid and r.media_type=1),'') BARCODE, nvl(lnk.lib_loc_ext_id,0) lib_loc_ext_id, nvl(lnk.ctnr_loan_stat,0) ctnr_loan_status, nvl(lnk.ctnr_stat,0) ctnr_stat, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID , (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=298004 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,'|ANTV|')>0 OR INSTR(m.OWNERS,'|ATP|')>0 OR INSTR(m.OWNERS,'|BBC|')>0 OR INSTR(m.OWNERS,'|BEDIG|')>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,'|ICCCTY|')>0 OR INSTR(m.OWNERS,'|ICCCWC|')>0 OR INSTR(m.OWNERS,'|ICCCWL2|')>0 OR INSTR(m.OWNERS,'|ICCICC|')>0 OR INSTR(m.OWNERS,'|ICCTWT|')>0 OR INSTR(m.OWNERS,'|ICCU19CWC|')>0 OR INSTR(m.OWNERS,'|ICCWCCL|')>0 OR INSTR(m.OWNERS,'|ICCWCL|')>0 OR INSTR(m.OWNERS,'|ICCWCP|')>0 OR INSTR(m.OWNERS,'|ICCWTC|')>0 OR INSTR(m.OWNERS,'|ICCWTT|')>0 OR INSTR(m.OWNERS,'|ICCWWC|')>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,'|TVONE|')>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,'|VIVA|')>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|13:07:22.5010|3YCFrA|DANIEL|OAuth: /api/v3/mediavideo/298004?info=waveform&_dc=1608037653621 t Transfer: 1220 : 10|13:07:22.5010|3YCFrA|DANIEL|GetCurrentUser.. t Transfer: 1220 : 10|13:07:22.5010|3YCFrA|DANIEL| OAuth authenticated t Transfer: 1220 : 10|13:07:22.5010|3YCFrA|DANIEL| user DANIEL. t Verbose: 1220 : 10|13:07:22.5010|3YCFrA|DANIEL|OAuth. User logged in: DANIEL t Transfer: 1220 : 10|13:07:22.5010|3YCFrA|DANIEL|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\fl1.mp1 subfolder t Transfer: 1220 : 10|13:07:22.5010|3YCFrA|DANIEL| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/fl1.mp1 t Transfer: 1220 : 10|13:07:22.5010|3YCFrA|DANIEL|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/fl1.mp1 t Transfer: 1220 : 10|13:07:22.5010|3YCFrA|DANIEL|GetCurrentUser.. t Transfer: 1220 : 10|13:07:22.5010|3YCFrA|DANIEL| OAuth authenticated t Transfer: 1220 : 10|13:07:22.5010|3YCFrA|DANIEL| user DANIEL. t Verbose: 1220 : 10|13:07:22.5010|3YCFrA|DANIEL|imfx v3 API took 0.010s '/api/v3/mediavideo/298004?info=waveform&_dc=1608037653621' t Information: 1220 : 10|13:07:22.5010|g_HPQ~|DANIEL| timing: 00:00:00.1040410 t Verbose: 1220 : 10|13:07:22.5010|g_HPQ~|DANIEL|imfx v3 API took 0.104s '/api/v3/search/Media?_dc=1608037653540' t Transfer: 1220 : 10|13:07:22.5010|g_HPQ~|DANIEL|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\fl1.mp1 subfolder t Transfer: 1220 : 10|13:07:22.5010|g_HPQ~|DANIEL| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/fl1.mp1 t Transfer: 1220 : 10|13:07:22.5010|g_HPQ~|DANIEL|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/fl1.mp1 t Transfer: 1220 : 10|13:07:22.5010|g_HPQ~|DANIEL|GetCurrentUser.. t Transfer: 1220 : 10|13:07:22.5010|g_HPQ~|DANIEL| OAuth authenticated t Transfer: 1220 : 10|13:07:22.5010|g_HPQ~|DANIEL| user DANIEL. t Transfer: 1220 : 10|13:07:24.9385|F_zn1y|DANIEL|OAuth: /api/v3/search/Media?_dc=1608037656057 t Transfer: 1220 : 10|13:07:24.9385|F_zn1y|DANIEL|GetCurrentUser.. t Transfer: 1220 : 10|13:07:24.9385|F_zn1y|DANIEL| OAuth authenticated t Transfer: 1220 : 10|13:07:24.9385|F_zn1y|DANIEL| user DANIEL. t Verbose: 1220 : 10|13:07:24.9385|F_zn1y|DANIEL|OAuth. User logged in: DANIEL t Information: 1220 : 10|13:07:24.9385|F_zn1y|DANIEL|V3Api.SearchMedia t Information: 1220 : 10|13:07:24.9385|F_zn1y|DANIEL|V3Api.SearchGeneric t Transfer: 1220 : 10|13:07:24.9385|F_zn1y|DANIEL|GetCurrentUser.. t Transfer: 1220 : 10|13:07:24.9385|F_zn1y|DANIEL| OAuth authenticated t Transfer: 1220 : 10|13:07:24.9385|F_zn1y|DANIEL| user DANIEL. t Information: 1220 : 10|13:07:24.9385|F_zn1y|DANIEL|MediaSearch SQL: select r.*, nvl((select TMD_STR_AGG(c.u_id_pfix ) from tm_ctnrs c, tm_mi_tpi_lnx l where l.miid=r.id and c.u_id=l.tpiid and r.media_type=1),'') BARCODE, nvl(lnk.lib_loc_ext_id,0) lib_loc_ext_id, nvl(lnk.ctnr_loan_stat,0) ctnr_loan_status, nvl(lnk.ctnr_stat,0) ctnr_stat, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID , (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=290812 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,'|ANTV|')>0 OR INSTR(m.OWNERS,'|ATP|')>0 OR INSTR(m.OWNERS,'|BBC|')>0 OR INSTR(m.OWNERS,'|BEDIG|')>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,'|ICCCTY|')>0 OR INSTR(m.OWNERS,'|ICCCWC|')>0 OR INSTR(m.OWNERS,'|ICCCWL2|')>0 OR INSTR(m.OWNERS,'|ICCICC|')>0 OR INSTR(m.OWNERS,'|ICCTWT|')>0 OR INSTR(m.OWNERS,'|ICCU19CWC|')>0 OR INSTR(m.OWNERS,'|ICCWCCL|')>0 OR INSTR(m.OWNERS,'|ICCWCL|')>0 OR INSTR(m.OWNERS,'|ICCWCP|')>0 OR INSTR(m.OWNERS,'|ICCWTC|')>0 OR INSTR(m.OWNERS,'|ICCWTT|')>0 OR INSTR(m.OWNERS,'|ICCWWC|')>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,'|TVONE|')>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,'|VIVA|')>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|13:07:24.9385|F_zn1y|DANIEL| timing: 00:00:00.0168077 t Verbose: 1220 : 10|13:07:24.9385|F_zn1y|DANIEL|imfx v3 API took 0.017s '/api/v3/search/Media?_dc=1608037656057' t Transfer: 1220 : 10|13:07:24.9385|F_zn1y|DANIEL|GetUrl. Storage |Audio| filename I:\Audio\piano.mp3 subfolder t Transfer: 1220 : 10|13:07:24.9385|F_zn1y|DANIEL| GetFileName result https://imfxv3tm.tmd.tv/AudioServer/piano.mp3 t Transfer: 1220 : 10|13:07:24.9385|F_zn1y|DANIEL|GetUrl. result https://imfxv3tm.tmd.tv/AudioServer/piano.mp3 t Transfer: 1220 : 10|13:07:24.9385|F_zn1y|DANIEL|GetCurrentUser.. t Transfer: 1220 : 10|13:07:24.9385|F_zn1y|DANIEL| OAuth authenticated t Transfer: 1220 : 10|13:07:24.9385|F_zn1y|DANIEL| user DANIEL. t Transfer: 1220 : 10|13:07:24.9385|hCsQUb|DANIEL|OAuth: /api/v3/mediavideo/290812?info=waveform&_dc=1608037656128 t Transfer: 1220 : 10|13:07:24.9385|hCsQUb|DANIEL|GetCurrentUser.. t Transfer: 1220 : 10|13:07:24.9385|hCsQUb|DANIEL| OAuth authenticated t Transfer: 1220 : 10|13:07:24.9385|hCsQUb|DANIEL| user DANIEL. t Verbose: 1220 : 10|13:07:24.9385|hCsQUb|DANIEL|OAuth. User logged in: DANIEL t Transfer: 1220 : 10|13:07:24.9385|hCsQUb|DANIEL|GetUrl. Storage |Audio| filename I:\Audio\piano.mp3 subfolder t Transfer: 1220 : 10|13:07:24.9385|hCsQUb|DANIEL| GetFileName result https://imfxv3tm.tmd.tv/AudioServer/piano.mp3 t Transfer: 1220 : 10|13:07:24.9385|hCsQUb|DANIEL|GetUrl. result https://imfxv3tm.tmd.tv/AudioServer/piano.mp3 t Transfer: 1220 : 10|13:07:24.9385|hCsQUb|DANIEL|GetCurrentUser.. t Transfer: 1220 : 10|13:07:24.9385|hCsQUb|DANIEL| OAuth authenticated t Transfer: 1220 : 10|13:07:24.9385|hCsQUb|DANIEL| user DANIEL. t Verbose: 1220 : 10|13:07:24.9385|hCsQUb|DANIEL|imfx v3 API took 0.004s '/api/v3/mediavideo/290812?info=waveform&_dc=1608037656128' t Transfer: 1220 : 10|13:07:27.1817|v4aidV|DANIEL|OAuth: /api/v3/search/Media?_dc=1608037658220 t Transfer: 1220 : 10|13:07:27.1817|v4aidV|DANIEL|GetCurrentUser.. t Transfer: 1220 : 10|13:07:27.1817|v4aidV|DANIEL| OAuth authenticated t Transfer: 1220 : 10|13:07:27.1817|v4aidV|DANIEL| user DANIEL. t Verbose: 1220 : 10|13:07:27.1817|v4aidV|DANIEL|OAuth. User logged in: DANIEL t Information: 1220 : 10|13:07:27.1817|v4aidV|DANIEL|V3Api.SearchMedia t Information: 1220 : 10|13:07:27.1817|v4aidV|DANIEL|V3Api.SearchGeneric t Transfer: 1220 : 10|13:07:27.1817|v4aidV|DANIEL|GetCurrentUser.. t Transfer: 1220 : 10|13:07:27.1817|v4aidV|DANIEL| OAuth authenticated t Transfer: 1220 : 10|13:07:27.1817|v4aidV|DANIEL| user DANIEL. t Information: 1220 : 10|13:07:27.1817|v4aidV|DANIEL|MediaSearch SQL: select r.*, nvl((select TMD_STR_AGG(c.u_id_pfix ) from tm_ctnrs c, tm_mi_tpi_lnx l where l.miid=r.id and c.u_id=l.tpiid and r.media_type=1),'') BARCODE, nvl(lnk.lib_loc_ext_id,0) lib_loc_ext_id, nvl(lnk.ctnr_loan_stat,0) ctnr_loan_status, nvl(lnk.ctnr_stat,0) ctnr_stat, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID , (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=298600 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,'|ANTV|')>0 OR INSTR(m.OWNERS,'|ATP|')>0 OR INSTR(m.OWNERS,'|BBC|')>0 OR INSTR(m.OWNERS,'|BEDIG|')>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,'|ICCCTY|')>0 OR INSTR(m.OWNERS,'|ICCCWC|')>0 OR INSTR(m.OWNERS,'|ICCCWL2|')>0 OR INSTR(m.OWNERS,'|ICCICC|')>0 OR INSTR(m.OWNERS,'|ICCTWT|')>0 OR INSTR(m.OWNERS,'|ICCU19CWC|')>0 OR INSTR(m.OWNERS,'|ICCWCCL|')>0 OR INSTR(m.OWNERS,'|ICCWCL|')>0 OR INSTR(m.OWNERS,'|ICCWCP|')>0 OR INSTR(m.OWNERS,'|ICCWTC|')>0 OR INSTR(m.OWNERS,'|ICCWTT|')>0 OR INSTR(m.OWNERS,'|ICCWWC|')>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,'|TVONE|')>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,'|VIVA|')>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|13:07:27.1817|6qUQsI|DANIEL|OAuth: /api/v3/mediavideo/298600?info=waveform&_dc=1608037658286 t Transfer: 1220 : 10|13:07:27.1817|6qUQsI|DANIEL|GetCurrentUser.. t Transfer: 1220 : 10|13:07:27.1817|6qUQsI|DANIEL| OAuth authenticated t Transfer: 1220 : 10|13:07:27.1817|6qUQsI|DANIEL| user DANIEL. t Verbose: 1220 : 10|13:07:27.1817|6qUQsI|DANIEL|OAuth. User logged in: DANIEL t Transfer: 1220 : 10|13:07:27.1817|6qUQsI|DANIEL|GetUrl. Storage |TEMP_UPLOAD| filename \\192.168.120.254\DemoFS\Digital Assets\TEMP_UPLOAD\b74c1499b96a\5.mp3 subfolder b74c1499b96a\ t Transfer: 1220 : 10|13:07:27.1817|6qUQsI|DANIEL| GetFileName result https://demo.tmd.tv/Temp Upload/5.mp3 t Transfer: 1220 : 10|13:07:27.1817|6qUQsI|DANIEL|GetUrl. result https://demo.tmd.tv/Temp Upload/5.mp3 t Transfer: 1220 : 10|13:07:27.1817|6qUQsI|DANIEL|GetCurrentUser.. t Transfer: 1220 : 10|13:07:27.1817|6qUQsI|DANIEL| OAuth authenticated t Transfer: 1220 : 10|13:07:27.1817|6qUQsI|DANIEL| user DANIEL. t Verbose: 1220 : 10|13:07:27.1817|6qUQsI|DANIEL|imfx v3 API took 0.003s '/api/v3/mediavideo/298600?info=waveform&_dc=1608037658286' t Information: 1220 : 10|13:07:27.1817|v4aidV|DANIEL| timing: 00:00:00.1040162 t Verbose: 1220 : 10|13:07:27.1817|v4aidV|DANIEL|imfx v3 API took 0.104s '/api/v3/search/Media?_dc=1608037658220' t Transfer: 1220 : 10|13:07:27.1817|v4aidV|DANIEL|GetUrl. Storage |TEMP_UPLOAD| filename \\192.168.120.254\DemoFS\Digital Assets\TEMP_UPLOAD\b74c1499b96a\5.mp3 subfolder b74c1499b96a\ t Transfer: 1220 : 10|13:07:27.1817|v4aidV|DANIEL| GetFileName result https://demo.tmd.tv/Temp Upload/5.mp3 t Transfer: 1220 : 10|13:07:27.1817|v4aidV|DANIEL|GetUrl. result https://demo.tmd.tv/Temp Upload/5.mp3 t Transfer: 1220 : 10|13:07:27.1817|v4aidV|DANIEL|GetCurrentUser.. t Transfer: 1220 : 10|13:07:27.1817|v4aidV|DANIEL| OAuth authenticated t Transfer: 1220 : 10|13:07:27.1817|v4aidV|DANIEL| user DANIEL. t Transfer: 1220 : 10|13:07:31.8551|YT3633|DANIEL|OAuth: /api/v3/search/Media?_dc=1608037662986 t Transfer: 1220 : 10|13:07:31.8551|YT3633|DANIEL|GetCurrentUser.. t Transfer: 1220 : 10|13:07:31.8551|YT3633|DANIEL| OAuth authenticated t Transfer: 1220 : 10|13:07:31.8551|YT3633|DANIEL| user DANIEL. t Verbose: 1220 : 10|13:07:31.8551|YT3633|DANIEL|OAuth. User logged in: DANIEL t Information: 1220 : 10|13:07:31.8551|YT3633|DANIEL|V3Api.SearchMedia t Information: 1220 : 10|13:07:31.8551|YT3633|DANIEL|V3Api.SearchGeneric t Transfer: 1220 : 10|13:07:31.8551|YT3633|DANIEL|GetCurrentUser.. t Transfer: 1220 : 10|13:07:31.8551|YT3633|DANIEL| OAuth authenticated t Transfer: 1220 : 10|13:07:31.8551|YT3633|DANIEL| user DANIEL. t Information: 1220 : 10|13:07:31.8551|YT3633|DANIEL|MediaSearch SQL: select r.*, nvl((select TMD_STR_AGG(c.u_id_pfix ) from tm_ctnrs c, tm_mi_tpi_lnx l where l.miid=r.id and c.u_id=l.tpiid and r.media_type=1),'') BARCODE, nvl(lnk.lib_loc_ext_id,0) lib_loc_ext_id, nvl(lnk.ctnr_loan_stat,0) ctnr_loan_status, nvl(lnk.ctnr_stat,0) ctnr_stat, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID , (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=298004 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,'|ANTV|')>0 OR INSTR(m.OWNERS,'|ATP|')>0 OR INSTR(m.OWNERS,'|BBC|')>0 OR INSTR(m.OWNERS,'|BEDIG|')>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,'|ICCCTY|')>0 OR INSTR(m.OWNERS,'|ICCCWC|')>0 OR INSTR(m.OWNERS,'|ICCCWL2|')>0 OR INSTR(m.OWNERS,'|ICCICC|')>0 OR INSTR(m.OWNERS,'|ICCTWT|')>0 OR INSTR(m.OWNERS,'|ICCU19CWC|')>0 OR INSTR(m.OWNERS,'|ICCWCCL|')>0 OR INSTR(m.OWNERS,'|ICCWCL|')>0 OR INSTR(m.OWNERS,'|ICCWCP|')>0 OR INSTR(m.OWNERS,'|ICCWTC|')>0 OR INSTR(m.OWNERS,'|ICCWTT|')>0 OR INSTR(m.OWNERS,'|ICCWWC|')>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,'|TVONE|')>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,'|VIVA|')>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|13:07:31.8551|YT3633|DANIEL| timing: 00:00:00.0128894 t Verbose: 1220 : 10|13:07:31.8551|YT3633|DANIEL|imfx v3 API took 0.013s '/api/v3/search/Media?_dc=1608037662986' t Transfer: 1220 : 10|13:07:31.8551|YT3633|DANIEL|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\fl1.mp1 subfolder t Transfer: 1220 : 10|13:07:31.8551|YT3633|DANIEL| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/fl1.mp1 t Transfer: 1220 : 10|13:07:31.8551|YT3633|DANIEL|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/fl1.mp1 t Transfer: 1220 : 10|13:07:31.8551|YT3633|DANIEL|GetCurrentUser.. t Transfer: 1220 : 10|13:07:31.8551|YT3633|DANIEL| OAuth authenticated t Transfer: 1220 : 10|13:07:31.8551|YT3633|DANIEL| user DANIEL. t Transfer: 1220 : 10|13:07:32.0582|Xt4F8B|DANIEL|OAuth: /api/v3/mediavideo/298004?info=waveform&_dc=1608037663071 t Transfer: 1220 : 10|13:07:32.0582|Xt4F8B|DANIEL|GetCurrentUser.. t Transfer: 1220 : 10|13:07:32.0582|Xt4F8B|DANIEL| OAuth authenticated t Transfer: 1220 : 10|13:07:32.0582|Xt4F8B|DANIEL| user DANIEL. t Verbose: 1220 : 10|13:07:32.0582|Xt4F8B|DANIEL|OAuth. User logged in: DANIEL t Transfer: 1220 : 10|13:07:32.0582|Xt4F8B|DANIEL|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\fl1.mp1 subfolder t Transfer: 1220 : 10|13:07:32.0582|Xt4F8B|DANIEL| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/fl1.mp1 t Transfer: 1220 : 10|13:07:32.0582|Xt4F8B|DANIEL|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/fl1.mp1 t Transfer: 1220 : 10|13:07:32.0582|Xt4F8B|DANIEL|GetCurrentUser.. t Transfer: 1220 : 10|13:07:32.0582|Xt4F8B|DANIEL| OAuth authenticated t Transfer: 1220 : 10|13:07:32.0582|Xt4F8B|DANIEL| user DANIEL. t Verbose: 1220 : 10|13:07:32.0582|Xt4F8B|DANIEL|imfx v3 API took 0.004s '/api/v3/mediavideo/298004?info=waveform&_dc=1608037663071' t Transfer: 1220 : 10|13:07:33.8864|E4ZPUG|DANIEL|OAuth: /api/v3/search/Media?_dc=1608037665009 t Transfer: 1220 : 10|13:07:33.8864|E4ZPUG|DANIEL|GetCurrentUser.. t Transfer: 1220 : 10|13:07:33.8864|E4ZPUG|DANIEL| OAuth authenticated t Transfer: 1220 : 10|13:07:33.8864|E4ZPUG|DANIEL| user DANIEL. t Verbose: 1220 : 10|13:07:33.8864|E4ZPUG|DANIEL|OAuth. User logged in: DANIEL t Information: 1220 : 10|13:07:33.8864|E4ZPUG|DANIEL|V3Api.SearchMedia t Information: 1220 : 10|13:07:33.8864|E4ZPUG|DANIEL|V3Api.SearchGeneric t Transfer: 1220 : 10|13:07:33.8864|E4ZPUG|DANIEL|GetCurrentUser.. t Transfer: 1220 : 10|13:07:33.8864|E4ZPUG|DANIEL| OAuth authenticated t Transfer: 1220 : 10|13:07:33.8864|E4ZPUG|DANIEL| user DANIEL. t Information: 1220 : 10|13:07:33.8864|E4ZPUG|DANIEL|MediaSearch SQL: select r.*, nvl((select TMD_STR_AGG(c.u_id_pfix ) from tm_ctnrs c, tm_mi_tpi_lnx l where l.miid=r.id and c.u_id=l.tpiid and r.media_type=1),'') BARCODE, nvl(lnk.lib_loc_ext_id,0) lib_loc_ext_id, nvl(lnk.ctnr_loan_stat,0) ctnr_loan_status, nvl(lnk.ctnr_stat,0) ctnr_stat, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID , (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=290812 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,'|ANTV|')>0 OR INSTR(m.OWNERS,'|ATP|')>0 OR INSTR(m.OWNERS,'|BBC|')>0 OR INSTR(m.OWNERS,'|BEDIG|')>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,'|ICCCTY|')>0 OR INSTR(m.OWNERS,'|ICCCWC|')>0 OR INSTR(m.OWNERS,'|ICCCWL2|')>0 OR INSTR(m.OWNERS,'|ICCICC|')>0 OR INSTR(m.OWNERS,'|ICCTWT|')>0 OR INSTR(m.OWNERS,'|ICCU19CWC|')>0 OR INSTR(m.OWNERS,'|ICCWCCL|')>0 OR INSTR(m.OWNERS,'|ICCWCL|')>0 OR INSTR(m.OWNERS,'|ICCWCP|')>0 OR INSTR(m.OWNERS,'|ICCWTC|')>0 OR INSTR(m.OWNERS,'|ICCWTT|')>0 OR INSTR(m.OWNERS,'|ICCWWC|')>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,'|TVONE|')>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,'|VIVA|')>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|13:07:33.8864|E4ZPUG|DANIEL| timing: 00:00:00.0128430 t Verbose: 1220 : 10|13:07:33.8864|E4ZPUG|DANIEL|imfx v3 API took 0.013s '/api/v3/search/Media?_dc=1608037665009' t Transfer: 1220 : 10|13:07:33.8864|E4ZPUG|DANIEL|GetUrl. Storage |Audio| filename I:\Audio\piano.mp3 subfolder t Transfer: 1220 : 10|13:07:33.8864|E4ZPUG|DANIEL| GetFileName result https://imfxv3tm.tmd.tv/AudioServer/piano.mp3 t Transfer: 1220 : 10|13:07:33.8864|E4ZPUG|DANIEL|GetUrl. result https://imfxv3tm.tmd.tv/AudioServer/piano.mp3 t Transfer: 1220 : 10|13:07:33.8864|E4ZPUG|DANIEL|GetCurrentUser.. t Transfer: 1220 : 10|13:07:33.8864|E4ZPUG|DANIEL| OAuth authenticated t Transfer: 1220 : 10|13:07:33.8864|E4ZPUG|DANIEL| user DANIEL. t Transfer: 1220 : 10|13:07:33.8864|uG5fVM|DANIEL|OAuth: /api/v3/mediavideo/290812?info=waveform&_dc=1608037665059 t Transfer: 1220 : 10|13:07:33.8864|uG5fVM|DANIEL|GetCurrentUser.. t Transfer: 1220 : 10|13:07:33.8864|uG5fVM|DANIEL| OAuth authenticated t Transfer: 1220 : 10|13:07:33.8864|uG5fVM|DANIEL| user DANIEL. t Verbose: 1220 : 10|13:07:33.8864|uG5fVM|DANIEL|OAuth. User logged in: DANIEL t Transfer: 1220 : 10|13:07:33.8864|uG5fVM|DANIEL|GetUrl. Storage |Audio| filename I:\Audio\piano.mp3 subfolder t Transfer: 1220 : 10|13:07:33.8864|uG5fVM|DANIEL| GetFileName result https://imfxv3tm.tmd.tv/AudioServer/piano.mp3 t Transfer: 1220 : 10|13:07:33.8864|uG5fVM|DANIEL|GetUrl. result https://imfxv3tm.tmd.tv/AudioServer/piano.mp3 t Transfer: 1220 : 10|13:07:33.8864|uG5fVM|DANIEL|GetCurrentUser.. t Transfer: 1220 : 10|13:07:33.8864|uG5fVM|DANIEL| OAuth authenticated t Transfer: 1220 : 10|13:07:33.8864|uG5fVM|DANIEL| user DANIEL. t Verbose: 1220 : 10|13:07:33.8864|uG5fVM|DANIEL|imfx v3 API took 0.004s '/api/v3/mediavideo/290812?info=waveform&_dc=1608037665059' t Transfer: 1220 : 10|13:07:45.0881|QLvi81|DANIEL|OAuth: /api/v3/search/Media?_dc=1608037676106 t Transfer: 1220 : 10|13:07:45.0881|QLvi81|DANIEL|GetCurrentUser.. t Transfer: 1220 : 10|13:07:45.0881|QLvi81|DANIEL| OAuth authenticated t Transfer: 1220 : 10|13:07:45.0881|QLvi81|DANIEL| user DANIEL. t Verbose: 1220 : 10|13:07:45.0881|QLvi81|DANIEL|OAuth. User logged in: DANIEL t Information: 1220 : 10|13:07:45.0881|QLvi81|DANIEL|V3Api.SearchMedia t Information: 1220 : 10|13:07:45.0881|QLvi81|DANIEL|V3Api.SearchGeneric t Transfer: 1220 : 10|13:07:45.0881|QLvi81|DANIEL|GetCurrentUser.. t Transfer: 1220 : 10|13:07:45.0881|QLvi81|DANIEL| OAuth authenticated t Transfer: 1220 : 10|13:07:45.0881|QLvi81|DANIEL| user DANIEL. t Information: 1220 : 10|13:07:45.0881|QLvi81|DANIEL|MediaSearch SQL: select r.*, nvl((select TMD_STR_AGG(c.u_id_pfix ) from tm_ctnrs c, tm_mi_tpi_lnx l where l.miid=r.id and c.u_id=l.tpiid and r.media_type=1),'') BARCODE, nvl(lnk.lib_loc_ext_id,0) lib_loc_ext_id, nvl(lnk.ctnr_loan_stat,0) ctnr_loan_status, nvl(lnk.ctnr_stat,0) ctnr_stat, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID , (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=298982 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,'|ANTV|')>0 OR INSTR(m.OWNERS,'|ATP|')>0 OR INSTR(m.OWNERS,'|BBC|')>0 OR INSTR(m.OWNERS,'|BEDIG|')>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,'|ICCCTY|')>0 OR INSTR(m.OWNERS,'|ICCCWC|')>0 OR INSTR(m.OWNERS,'|ICCCWL2|')>0 OR INSTR(m.OWNERS,'|ICCICC|')>0 OR INSTR(m.OWNERS,'|ICCTWT|')>0 OR INSTR(m.OWNERS,'|ICCU19CWC|')>0 OR INSTR(m.OWNERS,'|ICCWCCL|')>0 OR INSTR(m.OWNERS,'|ICCWCL|')>0 OR INSTR(m.OWNERS,'|ICCWCP|')>0 OR INSTR(m.OWNERS,'|ICCWTC|')>0 OR INSTR(m.OWNERS,'|ICCWTT|')>0 OR INSTR(m.OWNERS,'|ICCWWC|')>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,'|TVONE|')>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,'|VIVA|')>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|13:07:45.0881|QLvi81|DANIEL| timing: 00:00:00.0120721 t Verbose: 1220 : 10|13:07:45.0881|QLvi81|DANIEL|imfx v3 API took 0.012s '/api/v3/search/Media?_dc=1608037676106' t Transfer: 1220 : 10|13:07:45.0881|QLvi81|DANIEL|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\N0001764.ts subfolder t Transfer: 1220 : 10|13:07:45.0881|QLvi81|DANIEL| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/N0001764.ts t Transfer: 1220 : 10|13:07:45.0881|QLvi81|DANIEL|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/N0001764.ts t Transfer: 1220 : 10|13:07:45.0881|QLvi81|DANIEL|GetCurrentUser.. t Transfer: 1220 : 10|13:07:45.0881|QLvi81|DANIEL| OAuth authenticated t Transfer: 1220 : 10|13:07:45.0881|QLvi81|DANIEL| user DANIEL. t Transfer: 1220 : 10|13:07:45.0881|hpihFZ|DANIEL|OAuth: /api/v3/media-captions/298982?_dc=1608037676128 t Transfer: 1220 : 10|13:07:45.0881|hpihFZ|DANIEL|GetCurrentUser.. t Transfer: 1220 : 10|13:07:45.0881|hpihFZ|DANIEL| OAuth authenticated t Transfer: 1220 : 10|13:07:45.0881|hpihFZ|DANIEL| user DANIEL. t Verbose: 1220 : 10|13:07:45.0881|hpihFZ|DANIEL|OAuth. User logged in: DANIEL t Verbose: 1220 : 10|13:07:45.0881|hpihFZ|DANIEL|imfx v3 API took 0.004s '/api/v3/media-captions/298982?_dc=1608037676128' t Information: 1220 : 10|13:07:45.0881|ua9oua|DANIEL|V3Api.GetMediaTagging t Transfer: 1220 : 10|13:07:45.0881|YfxPV_|DANIEL|OAuth: /api/v3/mediavideo/298982?info=smudge&_dc=1608037676194 t Transfer: 1220 : 10|13:07:45.0881|YfxPV_|DANIEL|GetCurrentUser.. t Transfer: 1220 : 10|13:07:45.0881|YfxPV_|DANIEL| OAuth authenticated t Transfer: 1220 : 10|13:07:45.0881|YfxPV_|DANIEL| user DANIEL. t Verbose: 1220 : 10|13:07:45.0881|YfxPV_|DANIEL|OAuth. User logged in: DANIEL t Transfer: 1220 : 10|13:07:45.0881|YfxPV_|DANIEL|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\N0001764.ts subfolder t Transfer: 1220 : 10|13:07:45.0881|YfxPV_|DANIEL| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/N0001764.ts t Transfer: 1220 : 10|13:07:45.0881|YfxPV_|DANIEL|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/N0001764.ts t Transfer: 1220 : 10|13:07:45.0881|YfxPV_|DANIEL|GetCurrentUser.. t Transfer: 1220 : 10|13:07:45.0881|YfxPV_|DANIEL| OAuth authenticated t Transfer: 1220 : 10|13:07:45.0881|YfxPV_|DANIEL| user DANIEL. t Verbose: 1220 : 10|13:07:45.0881|YfxPV_|DANIEL|imfx v3 API took 0.005s '/api/v3/mediavideo/298982?info=smudge&_dc=1608037676194' t Transfer: 1220 : 10|13:07:52.4329|wiMEWb|DANIEL|OAuth: /api/v3/media-details/298982?_dc=1608037683609 t Transfer: 1220 : 10|13:07:52.4329|wiMEWb|DANIEL|GetCurrentUser.. t Transfer: 1220 : 10|13:07:52.4329|wiMEWb|DANIEL| OAuth authenticated t Transfer: 1220 : 10|13:07:52.4329|wiMEWb|DANIEL| user DANIEL. t Verbose: 1220 : 10|13:07:52.4329|wiMEWb|DANIEL|OAuth. User logged in: DANIEL t Transfer: 1220 : 10|13:07:52.4329|wiMEWb|DANIEL|GetCurrentUser.. t Transfer: 1220 : 10|13:07:52.4329|wiMEWb|DANIEL| OAuth authenticated t Transfer: 1220 : 10|13:07:52.4329|wiMEWb|DANIEL| user DANIEL. t Information: 1220 : 10|13:07:53.2453|||TM_MIS. LoadSubtitles for ID: 298982 t Information: 1220 : 10|13:07:53.2453|||TM_MIS. LoadSubtitles for ID: 298982. 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=120961' t Information: 1220 : 10|13:07:53.2453|||TM_MIS. LoadSubtitles for ID: 298982 found no subtitles. t Verbose: 1220 : 10|13:07:53.2453|wiMEWb|DANIEL|imfx v3 API took 0.793s '/api/v3/media-details/298982?_dc=1608037683609' t Transfer: 1220 : 10|13:07:53.2453|wiMEWb|DANIEL|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\N0001764.ts subfolder t Transfer: 1220 : 10|13:07:53.2453|wiMEWb|DANIEL| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/N0001764.ts t Transfer: 1220 : 10|13:07:53.2453|wiMEWb|DANIEL|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/N0001764.ts t Transfer: 1220 : 10|13:07:53.2453|wiMEWb|DANIEL|GetCurrentUser.. t Transfer: 1220 : 10|13:07:53.2453|wiMEWb|DANIEL| OAuth authenticated t Transfer: 1220 : 10|13:07:53.2453|wiMEWb|DANIEL| user DANIEL. t Transfer: 1220 : 10|13:07:53.4485|Ctzigi|DANIEL|OAuth: /api/v3/media-captions/298982?_dc=1608037684456 t Transfer: 1220 : 10|13:07:53.4485|Ctzigi|DANIEL|GetCurrentUser.. t Transfer: 1220 : 10|13:07:53.4485|Ctzigi|DANIEL| OAuth authenticated t Transfer: 1220 : 10|13:07:53.4485|Ctzigi|DANIEL| user DANIEL. t Verbose: 1220 : 10|13:07:53.4485|Ctzigi|DANIEL|OAuth. User logged in: DANIEL t Verbose: 1220 : 10|13:07:53.4485|Ctzigi|DANIEL|imfx v3 API took 0.003s '/api/v3/media-captions/298982?_dc=1608037684456' t Transfer: 1220 : 10|13:07:53.4485|9ol2ZJ|DANIEL|OAuth: /api/v3/mediavideo/298982?info=smudge,scene,audiovolume&_dc=1608037684612 t Transfer: 1220 : 10|13:07:53.4485|9ol2ZJ|DANIEL|GetCurrentUser.. t Transfer: 1220 : 10|13:07:53.4485|9ol2ZJ|DANIEL| OAuth authenticated t Transfer: 1220 : 10|13:07:53.4485|9ol2ZJ|DANIEL| user DANIEL. t Verbose: 1220 : 10|13:07:53.4485|9ol2ZJ|DANIEL|OAuth. User logged in: DANIEL t Transfer: 1220 : 10|13:07:53.4485|9ol2ZJ|DANIEL|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\N0001764.ts subfolder t Transfer: 1220 : 10|13:07:53.4485|9ol2ZJ|DANIEL| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/N0001764.ts t Transfer: 1220 : 10|13:07:53.4485|9ol2ZJ|DANIEL|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/N0001764.ts t Transfer: 1220 : 10|13:07:53.4485|9ol2ZJ|DANIEL|GetCurrentUser.. t Transfer: 1220 : 10|13:07:53.4485|9ol2ZJ|DANIEL| OAuth authenticated t Transfer: 1220 : 10|13:07:53.4485|9ol2ZJ|DANIEL| user DANIEL. t Verbose: 1220 : 10|13:07:53.4485|9ol2ZJ|DANIEL|imfx v3 API took 0.013s '/api/v3/mediavideo/298982?info=smudge,scene,audiovolume&_dc=1608037684612' t Transfer: 1220 : 10|13:07:54.2610|UXp~Vt|DANIEL|OAuth: /api/v3/ai-tags/298982?_dc=1608037685368 t Transfer: 1220 : 10|13:07:54.2610|UXp~Vt|DANIEL|GetCurrentUser.. t Transfer: 1220 : 10|13:07:54.2610|UXp~Vt|DANIEL| OAuth authenticated t Transfer: 1220 : 10|13:07:54.2610|UXp~Vt|DANIEL| user DANIEL. t Verbose: 1220 : 10|13:07:54.2610|UXp~Vt|DANIEL|OAuth. User logged in: DANIEL t Information: 1220 : 10|13:07:54.2610|UXp~Vt|DANIEL|V3Api.GetMediaAiTags t Transfer: 1220 : 10|13:07:54.2610|75NV8p|DANIEL|OAuth: /api/v3/mediavideo/298982?info=smudge&_dc=1608037685377 t Transfer: 1220 : 10|13:07:54.2610|75NV8p|DANIEL|GetCurrentUser.. t Transfer: 1220 : 10|13:07:54.2610|75NV8p|DANIEL| OAuth authenticated t Transfer: 1220 : 10|13:07:54.2610|75NV8p|DANIEL| user DANIEL. t Verbose: 1220 : 10|13:07:54.2610|75NV8p|DANIEL|OAuth. User logged in: DANIEL t Transfer: 1220 : 10|13:07:54.2610|75NV8p|DANIEL|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\N0001764.ts subfolder t Transfer: 1220 : 10|13:07:54.2610|75NV8p|DANIEL| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/N0001764.ts t Transfer: 1220 : 10|13:07:54.2610|75NV8p|DANIEL|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/N0001764.ts t Transfer: 1220 : 10|13:07:54.2610|75NV8p|DANIEL|GetCurrentUser.. t Transfer: 1220 : 10|13:07:54.2610|75NV8p|DANIEL| OAuth authenticated t Transfer: 1220 : 10|13:07:54.2610|75NV8p|DANIEL| user DANIEL. t Verbose: 1220 : 10|13:07:54.2610|75NV8p|DANIEL|imfx v3 API took 0.006s '/api/v3/mediavideo/298982?info=smudge&_dc=1608037685377' t Verbose: 1220 : 10|13:07:54.2610|UXp~Vt|DANIEL|imfx v3 API took 0.035s '/api/v3/ai-tags/298982?_dc=1608037685368' t Transfer: 1220 : 10|13:07:54.4641|Q1qLmR|DANIEL|OAuth: /api/metadata/4000/298982?_dc=1608037685598 t Transfer: 1220 : 10|13:07:54.4641|Q1qLmR|DANIEL|GetCurrentUser.. t Transfer: 1220 : 10|13:07:54.4641|Q1qLmR|DANIEL| OAuth authenticated t Transfer: 1220 : 10|13:07:54.4641|Q1qLmR|DANIEL| user DANIEL. t Verbose: 1220 : 10|13:07:54.4641|Q1qLmR|DANIEL|OAuth. User logged in: DANIEL t Verbose: 1220 : 10|13:07:54.4641|Q1qLmR|DANIEL|imfx v3 API took 0.049s '/api/metadata/4000/298982?_dc=1608037685598' t Information: 1220 : 10|13:28:07.6204|||OrabitWatcherBasic. Disposing. t Information: 1220 : 10|13:28:07.6204|||OrabitWatcherBasic. Disposed. t Information: 1220 : 10|13:28:07.6204|||========================================================================== t Information: 1220 : 10|13:28:07.6204|||IMFX CORE SERVER APPLICATION END.