t Information: 1220 : 1|16:11:54.1014||Get Configuration Values: t Information: 1220 : 1|16:11:54.1014|| AdminPassEnc, default: , value: ffqjrn0leKv4Lj2YJHe2dw==. t Information: 1220 : 1|16:11:54.1014|| EncryptedPasswords, default: false, value: true. t Information: 1220 : 1|16:11:54.1014|| OraConnectionString, default: , value: Server=TECHM;User Id=imfx;Password=;Unicode=true;. t Information: 1220 : 1|16:11:54.1014|| SecondTimezone, default: , value: . t Information: 1220 : 1|16:11:54.1014|| UseActiveDirectoryAuth, default: false, value: false. t Information: 1220 : 1|16:11:54.1014|| ReportingServiceUrl, default: , value: http://localhost:92/ReportingService.svc. t Information: 1220 : 1|16:11:54.1014|| ReportsPath, default: , value: . t Information: 1220 : 1|16:11:54.1014|| ReportsURL, default: , value: . t Information: 1220 : 1|16:11:54.1014|| TapeServiceUrl, default: , value: . t Information: 1220 : 1|16:11:54.1014|| GatekeeperUrl, default: , value: . t Information: 1220 : 1|16:11:54.1014|| ValuationUrl, default: , value: . t Information: 1220 : 1|16:11:54.1014|| QueueManagerDelay, default: 30, value: 30. t Information: 1220 : 1|16:11:54.1014|| QueueManagerFullRefresh, default: 90, value: 90. t Information: 1220 : 1|16:11:54.1014|| AudioLoopDuration, default: 0, value: 150. t Information: 1220 : 1|16:11:54.1014|| AudioLoopsCount, default: 0, value: 0. t Information: 1220 : 1|16:11:54.1170|| PlayerFakeStep, default: 500, value: 500. t Information: 1220 : 1|16:11:54.1170|| PlayerForceRatio, default: 0, value: 1. t Information: 1220 : 1|16:11:54.1170|| CheckVersionsInProd, default: false, value: True. t Information: 1220 : 1|16:11:54.1170|| MaxResults, default: 3000, value: 10000. t Information: 1220 : 1|16:11:54.1170|| NetworkRestriction, default: false, value: True. t Information: 1220 : 1|16:11:54.1170|| TEReportID, default: 0, value: 0. t Information: 1220 : 1|16:11:54.1170|| ClosedCaptionsCache, default: , value: C:\inetpub\wwwroot\imfxcore\timedtextcache\. t Information: 1220 : 1|16:11:54.1170|| ClosedCaptionsStorage, default: , value: c:\Mediaflex\subs. t Information: 1220 : 1|16:11:54.1170|| TimeCodeFormat, default: , value: pal. t Information: 1220 : 1|16:11:54.1170|| RceMediaPath, default: , value: C:\edl\. t Information: 1220 : 1|16:11:54.1170|| RceMediaPath, default: , value: C:\edl\. t Information: 1220 : 1|16:11:54.1170|| RceCsmOutputPath, default: , value: C:\Inetpub\wwwroot\csm\. t Information: 1220 : 1|16:11:54.1170|| RceCsmUrl, default: , value: http://localhost/csm/. t Information: 1220 : 1|16:11:54.1170|| RceMediaSelection, default: , value: miLinkIdMatch. t Information: 1220 : 1|16:11:54.1170|| RequestBrowseJobPresetName, default: , value: . t Information: 1220 : 1|16:11:54.1170|| DontExtendDuration, default: false, value: False. t Information: 1220 : 1|16:11:54.1170|| V3ConfigUrl, default: , value: . t Information: 1220 : 1|16:11:54.1170|| ApiServer, default: , value: http://192.168.120.10:85. t Information: 1220 : 1|16:11:54.1170|| StopWords, default: , value: . t Information: 1220 : 1|16:11:54.1170|| MisrTxFormat, default: G, value: G. t Information: 1220 : 1|16:11:54.1170|| ThumbnailServer, default: , value: . t Information: 1220 : 1|16:11:54.1170|| LocationFilter, default: , value: . t Information: 1220 : 1|16:11:54.1170|| SvUtilServiceUrl, default: , value: . t Information: 1220 : 1|16:11:54.1170|| SolrConnection, default: , value: http://192.168.120.14:8983/solr. t Information: 1220 : 1|16:11:54.1170|| UseIndexServerSearch, default: false, value: True. t Information: 1220 : 1|16:11:54.1170|| SolrIndexVersion, default: 1, value: 6. t Information: 1220 : 1|16:11:54.1170|| SolrConnection, default: , value: http://192.168.120.14:8983/solr. t Information: 1220 : 1|16:11:54.1170|| FacetsGroups, default: , value: owners,season_id, series_id,version_key,item_type,media_type,media_format,episode_number. t Information: 1220 : 1|16:11:54.1170|| FacetsGroupsVersion, default: , value: owners,season_id, series_id,version_key,episode_number. t Information: 1220 : 1|16:11:54.1170|| FacetsGroupsChameleon, default: , value: season_id, series_id,genre,prod_year,version_key. t Information: 1220 : 1|16:11:54.1170|| PreviewPreset, default: , value: . t Information: 1220 : 1|16:11:54.1170|| DevMode, default: false, value: false. t Information: 1220 : 1|16:11:54.1170|| DisableSysMan, default: false, value: false. t Information: 1220 : 1|16:11:54.1170|| TimeCodeFormat, default: , value: pal. t Information: 1220 : 1|16:11:54.1170|| FileCatalystStorageDevice, default: , value: . t Information: 1220 : 1|16:11:54.1170|| UseResponsibilityTracking, default: true, value: True. t Information: 1220 : 1|16:11:54.1170|| SubtitleDeviceFilter, default: , value: . t Information: 1220 : 1|16:11:54.1170|| SystemMonitorNamedPipe, default: , value: . t Information: 1220 : 1|16:11:54.1170|| OracleMonitorEnable, default: false, value: False. t Information: 1220 : 1|16:11:54.1170|| ArcApiHost, default: , value: . t Information: 1220 : 1|16:11:54.1170|| RabbitMqUrl, default: , value: amqp://192.168.120.14:5672. t Information: 1220 : 1|16:11:54.1170|| SolrTimedTextSearch, default: false, value: false. t Information: 1220 : 1|16:11:54.1170|| ProductionDurationUsageID, default: 1, value: 1. t Information: 1220 : 1|16:11:54.3982||GetStreamServers.. t Information: 1220 : 1|16:11:55.0857|| https://demo.tmd.tv/CBR Video/ |CBR Video| False t Information: 1220 : 1|16:11:55.0857|| https://demo.tmd.tv/CBR Images/ |CBR Images| False t Information: 1220 : 1|16:11:55.0857|| https://demo.tmd.tv/CBR Audio/ |CBR Audio| False t Information: 1220 : 1|16:11:55.0857|| https://demo.tmd.tv/Temp Upload/ |TEMP_UPLOAD| False t Information: 1220 : 1|16:11:55.0857|| http://localhost:82/images/ |IMAGES| False t Information: 1220 : 1|16:11:55.0857|| http://192.168.91.73/smoothcloud/ |SMOOTH_CLOUD| False t Information: 1220 : 1|16:11:55.0857|| http://192.168.91.73/cloudstore/ |CLOUD_STORE| False t Information: 1220 : 1|16:11:55.0857|| http://192.168.91.73/editsystemin/ |EDIT_SYSTEM_IN| False t Information: 1220 : 1|16:11:55.0857|| http://192.168.91.27:89/APPLEPROXY/ |APPLE_PROXY| False t Information: 1220 : 1|16:11:55.0857|| http://localhost:82/video/ |FILESTORE_VIDEO| False t Information: 1220 : 1|16:11:55.0857|| https://imfxv3tm.tmd.tv/streaming/ |Streaming| False t Information: 1220 : 1|16:11:55.0857|| https://imfxv3tm.tmd.tv/VideoServer/ |Video| False t Information: 1220 : 1|16:11:55.0857|| https://imfxv3tm.tmd.tv/AdobeIn/ |Adobe Premiere Pro In| False t Information: 1220 : 1|16:11:55.0857|| https://imfxv3tm.tmd.tv/AudioServer/ |Audio| False t Information: 1220 : 1|16:11:55.0857|| https://imfxv3tm.tmd.tv/ImageServer/ |Image| False t Information: 1220 : 1|16:11:55.0857|| https://imfxv3tm.tmd.tv/DocsServer/ |Docs| False t Information: 1220 : 1|16:11:55.0857|| https://imfxv3tm.tmd.tv/AmazonLabs/ |TEST HOUSE| False t Information: 1220 : 1|16:11:55.0857|| SolrConnectionUms, default: http://192.168.120.14:8983/solr, value: http://192.168.120.14:8983/solr. t Information: 1220 : 1|16:11:55.0857|| ApiLog, default: false, value: false. t Information: 1220 : 1|16:11:55.0857|| EmbeddedRceUrl, default: , value: . t Information: 1220 : 1|16:11:55.0857|| InstallMode, default: , value: . t Information: 1220 : 1|16:11:55.0857|| SamlRequestAddress, default: , value: . t Information: 1220 : 1|16:11:55.0857|| SamlTrustedIssuer, default: , value: . t Information: 1220 : 1|16:11:55.0857|| SamlLoginRedirect, default: , value: . t Information: 1220 : 1|16:11:55.0857|| NaturalLangSearch, default: false, value: True. t Information: 1220 : 1|16:11:55.0857|| OktaLoginField, default: , value: . t Information: 1220 : 1|16:11:55.0857|| AuthenticationTypes, default: , value: Native,PublicApiKey. t Information: 1220 : 1|16:11:55.0857||OrabitWatcherBasic. Initialize. t Information: 1220 : 1|16:11:55.1639||FillDictionaryCache. t Information: 1220 : 1|16:11:58.3669||GetSupportedOperators t Information: 1220 : 11|16:11:58.6170||CacheTechReports. t Information: 1220 : 1|16:11:58.7107||& Cache update. Server (global) filled with timestamp 04:12:58.7107715. types null t Information: 1220 : 1|16:11:58.7107||InitializeFromDatabase. 'Server=TECHM;User Id=imfx;password=..;Unicode=true;' direct False, home , timeout 15 t Information: 1220 : 1|16:11:58.7107||FillDictionaryCache. t Information: 1220 : 1|16:11:58.7264||& Cache update. Server (global) filled with timestamp 04:12:58.7264035. types FriendlyNames, DatabaseSearchFieldData t Information: 1220 : 1|16:11:59.0232||========================================================================== t Information: 1220 : 1|16:11:59.0232||IMFX CORE SERVER APPLICATION START. t Information: 1220 : 1|16:11:59.0232||DLL VERSION: 2.5.0.2322. t Information: 1220 : 11|16:11:59.0232|| UmsDev, default: False, value: False. t Information: 1220 : 1|16:11:59.1170|| ApiLog, default: false, value: false. t Information: 1220 : 12|16:12:00.1013||OrabitWatcherBasic trying to connect.. t Information: 1220 : 12|16:12:00.1013||OrabitWatcherBasic connected. t Information: 1220 : 12|16:12:00.1170||OrabitWatcherBasic queue created tmd.cfg.in.80a12670-bc27-47f2-ad94-6c126156ad7b t Transfer: 1220 : 13|16:12:00.3670||IsUserAuthenticated: /api/user-preferences?keys=associate_media_workflow&_dc=1575994312904 t Transfer: 1220 : 13|16:12:00.3826||GetCurrentUser.. t Transfer: 1220 : 13|16:12:00.3826|| OAuth authenticated t Verbose: 1220 : 13|16:12:00.3826|| uid claim is missing.. t Verbose: 1220 : 13|16:12:00.3826||AutoLogin not possible identity type WindowsIdentity t Information: 1220 : 11|16:12:00.3826||GetAppInfo t Information: 1220 : 11|16:12:00.3826|| db: TMDDEMO install mode: auth types: Native, PublicApiKey t Information: 1220 : 35|16:30:33.6952||GetAppInfo t Information: 1220 : 35|16:30:33.7733|| db: TMDDEMO install mode: auth types: Native, PublicApiKey t Information: 1220 : 35|16:30:37.2420||Oauth validating.. t Verbose: 1220 : 35|16:30:37.2420||GrantResourceOwnerCredentials. t Verbose: 1220 : 35|16:30:37.2420||LoginUser. tony, login type OAuth, encrypt password True t Information: 1220 : 35|16:30:37.2420||TryLoginUser. tony, login type OAuth, check password True, check hash False, encrypt password True, load user data True t Information: 1220 : 35|16:30:37.3045||TryLoginUser. Password is incorrect. t Verbose: 1220 : 35|16:30:37.3045||GrantResourceOwnerCredentials. Try login finished. Logged: False t Information: 1220 : 35|16:30:49.8983||Oauth validating.. t Verbose: 1220 : 35|16:30:49.8983||GrantResourceOwnerCredentials. t Verbose: 1220 : 35|16:30:49.8983||LoginUser. tony, login type OAuth, encrypt password True t Information: 1220 : 35|16:30:49.8983||TryLoginUser. tony, login type OAuth, check password True, check hash False, encrypt password True, load user data True t Information: 1220 : 35|16:30:49.9765||InitialiseLogin t Information: 1220 : 35|16:30:49.9921|| oauth token 00000000-0000-0000-0000-000000000000 t Information: 1220 : 35|16:30:49.9921||TryLoginUser. Logged in.. t Information: 1220 : 35|16:30:50.0233||GetPasswordPolicy. WARNING: Policy not found for system Imediaflex. Validation disabled. t Verbose: 1220 : 35|16:30:50.0233||LoginUser. Adding history. User Id 522, result TONY, host t Verbose: 1220 : 35|16:30:50.0233||GrantResourceOwnerCredentials. Try login finished. Logged: True t Transfer: 1220 : 29|16:30:50.3358||IsUserAuthenticated: /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,logoImage&globals=isDebugMode,htmlplayerhotkeys,versionCreationSettings,associate.advanced_search.version.setups,associate.advanced_search.media.setups,associate.wfrise.setups,supplier_portal.advanced_search.version.setups&_dc=1575995419696 t Transfer: 1220 : 29|16:30:50.3358||GetCurrentUser.. t Transfer: 1220 : 29|16:30:50.3358|| OAuth authenticated t Transfer: 1220 : 29|16:30:50.3358|| user TONY. t Transfer: 1220 : 29|16:30:50.3358||api user: TONY t Information: 1220 : 29|16:30:50.3671||V3Api.GetUserSettings t Transfer: 1220 : 29|16:30:50.3671||GetCurrentUser.. t Transfer: 1220 : 29|16:30:50.3671|| OAuth authenticated t Transfer: 1220 : 29|16:30:50.3671|| user TONY. t Transfer: 1220 : 62|16:30:50.6483||IsUserAuthenticated: /api/lookups/PgmStatus?_dc=1575995420019 t Transfer: 1220 : 62|16:30:50.6483||GetCurrentUser.. t Transfer: 1220 : 55|16:30:50.6483||IsUserAuthenticated: /api/user-preferences?keys=personal_settings;basket;default_page;color_schema;media.basket.data;defaultSearch&_dc=1575995420017 t Transfer: 1220 : 55|16:30:50.6483||GetCurrentUser.. t Transfer: 1220 : 55|16:30:50.6483|| OAuth authenticated t Transfer: 1220 : 55|16:30:50.6483|| user TONY. t Transfer: 1220 : 55|16:30:50.6483||api user: TONY t Transfer: 1220 : 62|16:30:50.6483|| OAuth authenticated t Transfer: 1220 : 62|16:30:50.6483|| user TONY. t Transfer: 1220 : 62|16:30:50.6483||api user: TONY t Information: 1220 : 55|16:30:50.6483||GetUserDataByKeys: personal_settings;basket;default_page;color_schema;media.basket.data;defaultSearch t Transfer: 1220 : 55|16:30:50.6483||GetCurrentUser.. t Transfer: 1220 : 55|16:30:50.6483|| OAuth authenticated t Transfer: 1220 : 55|16:30:50.6483|| user TONY. t Transfer: 1220 : 59|16:30:50.6483||IsUserAuthenticated: /api/lookups/MediaStatus?_dc=1575995420018 t Transfer: 1220 : 59|16:30:50.6483||GetCurrentUser.. t Transfer: 1220 : 59|16:30:50.6483|| OAuth authenticated t Transfer: 1220 : 59|16:30:50.6483|| user TONY. t Transfer: 1220 : 59|16:30:50.6483||api user: TONY t Information: 1220 : 58|16:30:50.9295||GetUserProfile. Id: 0 t Transfer: 1220 : 58|16:30:50.9295||GetCurrentUser.. t Transfer: 1220 : 58|16:30:50.9295|| OAuth authenticated t Transfer: 1220 : 58|16:30:50.9295|| user TONY. t Transfer: 1220 : 52|16:30:52.0702||IsUserAuthenticated: /api/user-preferences?keys=adv.recent.searches.titles&_dc=1575995421437 t Transfer: 1220 : 52|16:30:52.0702||GetCurrentUser.. t Transfer: 1220 : 52|16:30:52.0702|| OAuth authenticated t Transfer: 1220 : 52|16:30:52.0702|| user TONY. t Transfer: 1220 : 52|16:30:52.0702||api user: TONY t Information: 1220 : 52|16:30:52.0702||GetUserDataByKeys: adv.recent.searches.titles t Transfer: 1220 : 52|16:30:52.0702||GetCurrentUser.. t Transfer: 1220 : 52|16:30:52.0702|| OAuth authenticated t Transfer: 1220 : 52|16:30:52.0702|| user TONY. t Transfer: 1220 : 59|16:30:52.0702||IsUserAuthenticated: /api/lookups/SearchSupportedOperators?_dc=1575995421434 t Transfer: 1220 : 59|16:30:52.0702||GetCurrentUser.. t Transfer: 1220 : 59|16:30:52.0702|| OAuth authenticated t Transfer: 1220 : 59|16:30:52.0702|| user TONY. t Transfer: 1220 : 59|16:30:52.0702||api user: TONY t Transfer: 1220 : 60|16:30:52.0702||IsUserAuthenticated: /api/view/searchinfo/TitleSearch?_dc=1575995421433 t Transfer: 1220 : 60|16:30:52.0702||GetCurrentUser.. t Transfer: 1220 : 60|16:30:52.0702|| OAuth authenticated t Transfer: 1220 : 60|16:30:52.0702|| user TONY. t Transfer: 1220 : 60|16:30:52.0702||api user: TONY t Information: 1220 : 60|16:30:52.0858||GetAdvSearchColumns. search type TitleSearch grid . t Transfer: 1220 : 58|16:30:52.0858||IsUserAuthenticated: /api/view/info/TitleTree?lang=en-GB&_dc=1575995421456 t Transfer: 1220 : 58|16:30:52.0858||GetCurrentUser.. t Transfer: 1220 : 58|16:30:52.0858|| OAuth authenticated t Transfer: 1220 : 58|16:30:52.0858|| user TONY. t Transfer: 1220 : 58|16:30:52.0858||api user: TONY t Information: 1220 : 58|16:30:52.0858||GetGridViewBuilder. builder type TitleTree. t Transfer: 1220 : 58|16:30:52.0858||GetCurrentUser.. t Transfer: 1220 : 58|16:30:52.0858|| OAuth authenticated t Transfer: 1220 : 58|16:30:52.0858|| user TONY. t Information: 1220 : 58|16:30:52.1015||UserGridView. LoadView. ID 1281, Name Default. t Transfer: 1220 : 58|16:30:52.1015||GetCurrentUser.. t Transfer: 1220 : 58|16:30:52.1015|| OAuth authenticated t Transfer: 1220 : 58|16:30:52.1015|| user TONY. t Transfer: 1220 : 61|16:30:52.1015||IsUserAuthenticated: /api/view/searches/TitleSearch?_dc=1575995421468 t Transfer: 1220 : 61|16:30:52.1015||GetCurrentUser.. t Transfer: 1220 : 61|16:30:52.1015|| OAuth authenticated t Transfer: 1220 : 61|16:30:52.1015|| user TONY. t Transfer: 1220 : 61|16:30:52.1015||api user: TONY t Transfer: 1220 : 58|16:30:52.1015||GetCurrentUser.. t Transfer: 1220 : 58|16:30:52.1015|| OAuth authenticated t Transfer: 1220 : 58|16:30:52.1015|| user TONY. t Information: 1220 : 61|16:30:52.1015||GetSavedSearchNames. search type TitleSearch. t Transfer: 1220 : 61|16:30:52.1015||GetCurrentUser.. t Transfer: 1220 : 61|16:30:52.1015|| OAuth authenticated t Transfer: 1220 : 61|16:30:52.1015|| user TONY. t Transfer: 1220 : 52|16:30:52.1015||IsUserAuthenticated: /api/view/info/VersionGrid?lang=en-GB&_dc=1575995421477 t Transfer: 1220 : 52|16:30:52.1015||GetCurrentUser.. t Transfer: 1220 : 52|16:30:52.1015|| OAuth authenticated t Transfer: 1220 : 52|16:30:52.1015|| user TONY. t Transfer: 1220 : 52|16:30:52.1015||api user: TONY t Information: 1220 : 52|16:30:52.1015||GetGridViewBuilder. builder type VersionGrid. t Transfer: 1220 : 52|16:30:52.1015||GetCurrentUser.. t Transfer: 1220 : 52|16:30:52.1015|| OAuth authenticated t Transfer: 1220 : 52|16:30:52.1015|| user TONY. t Information: 1220 : 52|16:30:52.2264||UserGridView. LoadView. ID -1, Name Default. t Transfer: 1220 : 52|16:30:52.2264||GetCurrentUser.. t Transfer: 1220 : 52|16:30:52.2264|| OAuth authenticated t Transfer: 1220 : 52|16:30:52.2264|| user TONY. t Transfer: 1220 : 52|16:30:52.2420||GetCurrentUser.. t Transfer: 1220 : 52|16:30:52.2420|| OAuth authenticated t Transfer: 1220 : 52|16:30:52.2420|| user TONY. t Transfer: 1220 : 59|16:30:52.5389||IsUserAuthenticated: /api/view/info/MediaGrid?lang=en-GB&_dc=1575995421533 t Transfer: 1220 : 59|16:30:52.5389||GetCurrentUser.. t Transfer: 1220 : 59|16:30:52.5389|| OAuth authenticated t Transfer: 1220 : 59|16:30:52.5389|| user TONY. t Transfer: 1220 : 59|16:30:52.5389||api user: TONY t Information: 1220 : 59|16:30:52.5389||GetGridViewBuilder. builder type MediaGrid. t Transfer: 1220 : 59|16:30:52.5389||GetCurrentUser.. t Transfer: 1220 : 59|16:30:52.5389|| OAuth authenticated t Transfer: 1220 : 59|16:30:52.5389|| user TONY. t Information: 1220 : 59|16:30:52.5389||UserGridView. LoadView. ID 1282, Name Default. t Transfer: 1220 : 59|16:30:52.5389||GetCurrentUser.. t Transfer: 1220 : 59|16:30:52.5389|| OAuth authenticated t Transfer: 1220 : 59|16:30:52.5389|| user TONY. t Transfer: 1220 : 59|16:30:52.5546||GetCurrentUser.. t Transfer: 1220 : 59|16:30:52.5546|| OAuth authenticated t Transfer: 1220 : 59|16:30:52.5546|| user TONY. t Transfer: 1220 : 29|16:31:33.7733||IsUserAuthenticated: /api/SearchSuggestion/?_dc=1575995463124 t Transfer: 1220 : 29|16:31:33.7733||GetCurrentUser.. t Transfer: 1220 : 29|16:31:33.7733|| OAuth authenticated t Transfer: 1220 : 29|16:31:33.7733|| user TONY. t Transfer: 1220 : 29|16:31:33.7733||api user: TONY t Transfer: 1220 : 29|16:31:33.8671||GetCurrentUser.. t Transfer: 1220 : 29|16:31:33.8671|| OAuth authenticated t Transfer: 1220 : 29|16:31:33.8671|| user TONY. t Transfer: 1220 : 56|16:31:36.0233||IsUserAuthenticated: /api/search/title?_dc=1575995465352 t Transfer: 1220 : 56|16:31:36.0233||GetCurrentUser.. t Transfer: 1220 : 56|16:31:36.0233|| OAuth authenticated t Transfer: 1220 : 56|16:31:36.0233|| user TONY. t Transfer: 1220 : 56|16:31:36.0233||api user: TONY t Information: 1220 : 56|16:31:36.0545||V3Api.SearchTitles t Information: 1220 : 56|16:31:36.0545||V3Api.SearchGeneric t Transfer: 1220 : 56|16:31:36.0702||GetCurrentUser.. t Transfer: 1220 : 56|16:31:36.0702|| OAuth authenticated t Transfer: 1220 : 56|16:31:36.0702|| user TONY. t Transfer: 1220 : 56|16:31:36.0702||GetCurrentUser.. t Transfer: 1220 : 56|16:31:36.0702|| OAuth authenticated t Transfer: 1220 : 56|16:31:36.0702|| user TONY. t Information: 1220 : 56|16:31:36.0702||SearchTitle SQL: with v as ( SELECT abs.* ,decode(ITEM_TYPE, 1010,SER_ABS_ID, 1020,CASE WHEN SER_ABS2_ID > 0 THEN SER_ABS2_ID ELSE SER_ABS_ID END ) xparent_id FROM TMDDBA.TM_PG_ABS abs WHERE abs.id in ( select a.id FROM TMDDBA.TM_PG_ABS a where ABS_DELETED = 0 AND a.ser_abs_id=298401 AND ROWNUM < 25000 ) ) ,v_missing_parent_ids as ( select xparent_id from v minus select id from v ) ,v_missing_parents as ( SELECT distinct a.* ,decode(ITEM_TYPE, 1010,SER_ABS_ID, 1020,CASE WHEN SER_ABS2_ID > 0 THEN SER_ABS2_ID ELSE SER_ABS_ID END ) xparent_id FROM TMDDBA.TM_PG_ABS a START WITH ID IN (select xparent_id from v_missing_parent_ids) CONNECT BY CASE PRIOR ITEM_TYPE WHEN 1010 THEN PRIOR SER_ABS_ID WHEN 1020 THEN CASE WHEN NVL(PRIOR SER_ABS2_ID, 0) > 0 THEN PRIOR SER_ABS2_ID ELSE PRIOR SER_ABS_ID END END = ID ) ,v_all as ( select x.*, count(*) over() RowCount from ( select * from v_missing_parents union select * from v ) x ) ,v_top as ( select id from (select id, row_number()over(order by upper(ser_title),upper(title),ser_num,ser_ep_num, SER_EP_SQ_NUM ) rnk -- sort roots from v_all where xparent_id is null) where rnk between (:page_number-1)*50+1 and :page_number*50 ) ,v_tree as ( select level lvl, a.* from v_all a start with id in (select id from v_top) connect by xparent_id = prior ID order siblings by upper(ser_title),ser_num,ser_ep_num, SER_EP_SQ_NUM,upper(title) -- sort children ) select * from v_tree --where rnk <= 50 t Transfer: 1220 : 61|16:31:36.8202||IsUserAuthenticated: /api/int/title/298401/versions?_dc=1575995466185 t Transfer: 1220 : 61|16:31:36.8202||GetCurrentUser.. t Transfer: 1220 : 61|16:31:36.8202|| OAuth authenticated t Transfer: 1220 : 61|16:31:36.8202|| user TONY. t Transfer: 1220 : 61|16:31:36.8202||api user: TONY t Information: 1220 : 61|16:31:36.8202||V3Api.GetVersionsByTitleIdAdv t Information: 1220 : 61|16:31:36.8202||V3Api.SearchGeneric t Transfer: 1220 : 52|16:31:36.8358||IsUserAuthenticated: /api/user-preferences?_dc=1575995466189 t Transfer: 1220 : 52|16:31:36.8358||GetCurrentUser.. t Transfer: 1220 : 52|16:31:36.8358|| OAuth authenticated t Transfer: 1220 : 52|16:31:36.8358|| user TONY. t Transfer: 1220 : 52|16:31:36.8358||api user: TONY t Transfer: 1220 : 61|16:31:36.8358||GetCurrentUser.. t Transfer: 1220 : 61|16:31:36.8358|| OAuth authenticated t Transfer: 1220 : 61|16:31:36.8358|| user TONY. t Transfer: 1220 : 61|16:31:36.8358||GetCurrentUser.. t Transfer: 1220 : 61|16:31:36.8358|| OAuth authenticated t Transfer: 1220 : 61|16:31:36.8358|| user TONY. t Verbose: 1220 : 52|16:31:36.8358||StoreUserDataByKeys.. t Transfer: 1220 : 52|16:31:36.8358||GetCurrentUser.. t Transfer: 1220 : 52|16:31:36.8358|| OAuth authenticated t Transfer: 1220 : 52|16:31:36.8358|| user TONY. t Information: 1220 : 61|16:31:36.8515||SearchVersion SQL: select * from (select a.*, rownum rnum from ( select m.*, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID, BUILD_PGRL_FULLTITLE(item_type, title, ser_name, ser_title) FULLTITLE from tmddba.tm_pg_rl m left outer join (select text_id, text_data_path, text_data_filename, text_ref_object from tmddba.tm_text) t on t.text_id = m.primary_thumb_id where item_type>0 and rl_deleted=0 and m.PGM_ABS_ID=298401 order by m.title, m.id ) a where rownum <= 9999) r where rnum >=1 order by rnum t Information: 1220 : 61|16:31:36.8827||Running version search. User: 522 Simple Search: Running Oracle search for COUNT Oracle count completed in: 7ms. Returned lines: 0 Running Oracle search. Oracle version search timing: 34ms. SQL run: select * from (select a.*, rownum rnum from ( select m.*, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID, BUILD_PGRL_FULLTITLE(item_type, title, ser_name, ser_title) FULLTITLE from tmddba.tm_pg_rl m left outer join (select text_id, text_data_path, text_data_filename, text_ref_object from tmddba.tm_text) t on t.text_id = m.primary_thumb_id where item_type>0 and rl_deleted=0 and m.PGM_ABS_ID=298401 order by m.title, m.id ) a where rownum <= 9999) r where rnum >=1 order by rnum t Transfer: 1220 : 55|16:31:40.2733||IsUserAuthenticated: /api/int/title/298443/versions?_dc=1575995469647 t Transfer: 1220 : 55|16:31:40.2733||GetCurrentUser.. t Transfer: 1220 : 55|16:31:40.2733|| OAuth authenticated t Transfer: 1220 : 55|16:31:40.2733|| user TONY. t Transfer: 1220 : 55|16:31:40.2733||api user: TONY t Information: 1220 : 55|16:31:40.2733||V3Api.GetVersionsByTitleIdAdv t Information: 1220 : 55|16:31:40.2733||V3Api.SearchGeneric t Transfer: 1220 : 55|16:31:40.2733||GetCurrentUser.. t Transfer: 1220 : 55|16:31:40.2733|| OAuth authenticated t Transfer: 1220 : 55|16:31:40.2733|| user TONY. t Transfer: 1220 : 55|16:31:40.2733||GetCurrentUser.. t Transfer: 1220 : 55|16:31:40.2733|| OAuth authenticated t Transfer: 1220 : 55|16:31:40.2733|| user TONY. t Information: 1220 : 55|16:31:40.2889||SearchVersion SQL: select * from (select a.*, rownum rnum from ( select m.*, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID, BUILD_PGRL_FULLTITLE(item_type, title, ser_name, ser_title) FULLTITLE from tmddba.tm_pg_rl m left outer join (select text_id, text_data_path, text_data_filename, text_ref_object from tmddba.tm_text) t on t.text_id = m.primary_thumb_id where item_type>0 and rl_deleted=0 and m.PGM_ABS_ID=298443 order by m.title, m.id ) a where rownum <= 9999) r where rnum >=1 order by rnum t Information: 1220 : 55|16:31:40.3800||Running version search. User: 522 Simple Search: Running Oracle search for COUNT Oracle count completed in: 5ms. Returned lines: 1 Running Oracle search. Oracle version search timing: 85ms. SQL run: select * from (select a.*, rownum rnum from ( select m.*, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID, BUILD_PGRL_FULLTITLE(item_type, title, ser_name, ser_title) FULLTITLE from tmddba.tm_pg_rl m left outer join (select text_id, text_data_path, text_data_filename, text_ref_object from tmddba.tm_text) t on t.text_id = m.primary_thumb_id where item_type>0 and rl_deleted=0 and m.PGM_ABS_ID=298443 order by m.title, m.id ) a where rownum <= 9999) r where rnum >=1 order by rnum t Transfer: 1220 : 51|16:31:40.7264||IsUserAuthenticated: /api/int/version/298444/media?_dc=1575995470104 t Transfer: 1220 : 51|16:31:40.7264||GetCurrentUser.. t Transfer: 1220 : 51|16:31:40.7264|| OAuth authenticated t Transfer: 1220 : 51|16:31:40.7264|| user TONY. t Transfer: 1220 : 51|16:31:40.7421||api user: TONY t Information: 1220 : 51|16:31:40.7421||V3Api.GetMediaByVersionIdAdv t Information: 1220 : 51|16:31:40.7421||V3Api.SearchGeneric t Transfer: 1220 : 51|16:31:40.7577||GetCurrentUser.. t Transfer: 1220 : 51|16:31:40.7577|| OAuth authenticated t Transfer: 1220 : 51|16:31:40.7577|| user TONY. t Information: 1220 : 51|16:31:40.7733||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 where media_type>0 and item_type>0 AND PGM_PARENT_ID=:pgm_parent_id_1 and m.mi_deleted=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 Param: pgm_parent_id_1: 298444 t Information: 1220 : 51|16:31:40.8201|| timing: 00:00:00.0643229 t Verbose: 1220 : 51|16:31:40.9921||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\England v Bangladesh Match Group A.mp4 subfolder t Verbose: 1220 : 51|16:31:40.9921|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/England v Bangladesh Match Group A.mp4 t Verbose: 1220 : 51|16:31:40.9921||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/England v Bangladesh Match Group A.mp4 t Transfer: 1220 : 51|16:31:40.9921||GetCurrentUser.. t Transfer: 1220 : 51|16:31:40.9921|| OAuth authenticated t Transfer: 1220 : 51|16:31:40.9921|| user TONY. t Transfer: 1220 : 52|16:31:44.2577||IsUserAuthenticated: /api/title-details/298401?_dc=1575995473620 t Transfer: 1220 : 52|16:31:44.2577||GetCurrentUser.. t Transfer: 1220 : 52|16:31:44.2577|| OAuth authenticated t Transfer: 1220 : 52|16:31:44.2577|| user TONY. t Transfer: 1220 : 52|16:31:44.2577||api user: TONY t Transfer: 1220 : 29|16:31:44.5545||IsUserAuthenticated: /api/v3/detailsview/TitleDetails/0?lang=en-GB&_dc=1575995473918 t Transfer: 1220 : 29|16:31:44.5545||GetCurrentUser.. t Transfer: 1220 : 29|16:31:44.5545|| OAuth authenticated t Transfer: 1220 : 29|16:31:44.5545|| user TONY. t Transfer: 1220 : 29|16:31:44.5545||api user: TONY t Transfer: 1220 : 46|16:31:44.8983||IsUserAuthenticated: /api/lookups/FriendlyNames?_dc=1575995474268 t Transfer: 1220 : 46|16:31:44.8983||GetCurrentUser.. t Transfer: 1220 : 46|16:31:44.8983|| OAuth authenticated t Transfer: 1220 : 46|16:31:44.8983|| user TONY. t Transfer: 1220 : 46|16:31:44.8983||api user: TONY t Transfer: 1220 : 29|16:31:44.9920||IsUserAuthenticated: /api/search/title?_dc=1575995474339 t Transfer: 1220 : 29|16:31:44.9920||GetCurrentUser.. t Transfer: 1220 : 29|16:31:44.9920|| OAuth authenticated t Transfer: 1220 : 29|16:31:44.9920|| user TONY. t Transfer: 1220 : 29|16:31:44.9920||api user: TONY t Information: 1220 : 29|16:31:44.9920||V3Api.SearchTitles t Information: 1220 : 29|16:31:44.9920||V3Api.SearchGeneric t Transfer: 1220 : 29|16:31:44.9920||GetCurrentUser.. t Transfer: 1220 : 29|16:31:44.9920|| OAuth authenticated t Transfer: 1220 : 29|16:31:44.9920|| user TONY. t Transfer: 1220 : 29|16:31:44.9920||GetCurrentUser.. t Transfer: 1220 : 29|16:31:44.9920|| OAuth authenticated t Transfer: 1220 : 29|16:31:44.9920|| user TONY. t Information: 1220 : 29|16:31:44.9920||SearchTitle SQL: with v as ( SELECT abs.* ,decode(ITEM_TYPE, 1010,SER_ABS_ID, 1020,CASE WHEN SER_ABS2_ID > 0 THEN SER_ABS2_ID ELSE SER_ABS_ID END ) xparent_id FROM TMDDBA.TM_PG_ABS abs WHERE abs.id in ( select a.id FROM TMDDBA.TM_PG_ABS a where ABS_DELETED = 0 AND Upper(a.ID) = Upper('298401') AND ROWNUM < 25000 ) ) ,v_missing_parent_ids as ( select xparent_id from v minus select id from v ) ,v_missing_parents as ( SELECT distinct a.* ,decode(ITEM_TYPE, 1010,SER_ABS_ID, 1020,CASE WHEN SER_ABS2_ID > 0 THEN SER_ABS2_ID ELSE SER_ABS_ID END ) xparent_id FROM TMDDBA.TM_PG_ABS a START WITH ID IN (select xparent_id from v_missing_parent_ids) CONNECT BY CASE PRIOR ITEM_TYPE WHEN 1010 THEN PRIOR SER_ABS_ID WHEN 1020 THEN CASE WHEN NVL(PRIOR SER_ABS2_ID, 0) > 0 THEN PRIOR SER_ABS2_ID ELSE PRIOR SER_ABS_ID END END = ID ) ,v_all as ( select x.*, count(*) over() RowCount from ( select * from v_missing_parents union select * from v ) x ) ,v_top as ( select id from (select id, row_number()over(order by upper(ser_title),upper(title),ser_num,ser_ep_num, SER_EP_SQ_NUM ) rnk -- sort roots from v_all where xparent_id is null) where rnk between (:page_number-1)*50+1 and :page_number*50 ) ,v_tree as ( select level lvl, a.* from v_all a start with id in (select id from v_top) connect by xparent_id = prior ID order siblings by upper(ser_title),ser_num,ser_ep_num, SER_EP_SQ_NUM,upper(title) -- sort children ) select * from v_tree --where rnk <= 50 t Transfer: 1220 : 55|16:31:45.1327||IsUserAuthenticated: /api/search/title?_dc=1575995474498 t Transfer: 1220 : 55|16:31:45.1327||GetCurrentUser.. t Transfer: 1220 : 55|16:31:45.1327|| OAuth authenticated t Transfer: 1220 : 55|16:31:45.1327|| user TONY. t Transfer: 1220 : 55|16:31:45.1327||api user: TONY t Information: 1220 : 55|16:31:45.1327||V3Api.SearchTitles t Information: 1220 : 55|16:31:45.1327||V3Api.SearchGeneric t Transfer: 1220 : 55|16:31:45.1327||GetCurrentUser.. t Transfer: 1220 : 55|16:31:45.1327|| OAuth authenticated t Transfer: 1220 : 55|16:31:45.1327|| user TONY. t Transfer: 1220 : 55|16:31:45.1327||GetCurrentUser.. t Transfer: 1220 : 55|16:31:45.1327|| OAuth authenticated t Transfer: 1220 : 55|16:31:45.1327|| user TONY. t Information: 1220 : 55|16:31:45.1327||SearchTitle SQL: with v as ( SELECT abs.* ,decode(ITEM_TYPE, 1010,SER_ABS_ID, 1020,CASE WHEN SER_ABS2_ID > 0 THEN SER_ABS2_ID ELSE SER_ABS_ID END ) xparent_id FROM TMDDBA.TM_PG_ABS abs WHERE abs.id in ( select a.id FROM TMDDBA.TM_PG_ABS a where ABS_DELETED = 0 AND Upper(a.ID) = Upper('298401') AND ROWNUM < 25000 ) ) ,v_missing_parent_ids as ( select xparent_id from v minus select id from v ) ,v_missing_parents as ( SELECT distinct a.* ,decode(ITEM_TYPE, 1010,SER_ABS_ID, 1020,CASE WHEN SER_ABS2_ID > 0 THEN SER_ABS2_ID ELSE SER_ABS_ID END ) xparent_id FROM TMDDBA.TM_PG_ABS a START WITH ID IN (select xparent_id from v_missing_parent_ids) CONNECT BY CASE PRIOR ITEM_TYPE WHEN 1010 THEN PRIOR SER_ABS_ID WHEN 1020 THEN CASE WHEN NVL(PRIOR SER_ABS2_ID, 0) > 0 THEN PRIOR SER_ABS2_ID ELSE PRIOR SER_ABS_ID END END = ID ) ,v_all as ( select x.*, count(*) over() RowCount from ( select * from v_missing_parents union select * from v ) x ) ,v_top as ( select id from (select id, row_number()over(order by upper(ser_title),upper(title),ser_num,ser_ep_num, SER_EP_SQ_NUM ) rnk -- sort roots from v_all where xparent_id is null) where rnk between (:page_number-1)*50+1 and :page_number*50 ) ,v_tree as ( select level lvl, a.* from v_all a start with id in (select id from v_top) connect by xparent_id = prior ID order siblings by upper(ser_title),ser_num,ser_ep_num, SER_EP_SQ_NUM,upper(title) -- sort children ) select * from v_tree --where rnk <= 50 t Transfer: 1220 : 52|16:31:52.3983||IsUserAuthenticated: /api/settings/groups/?_dc=1575995481770 t Transfer: 1220 : 52|16:31:52.3983||GetCurrentUser.. t Transfer: 1220 : 52|16:31:52.3983|| OAuth authenticated t Transfer: 1220 : 52|16:31:52.3983|| user TONY. t Transfer: 1220 : 52|16:31:52.3983||api user: TONY t Information: 1220 : 52|16:31:52.3983||V3Api.GetSettingsGroupsNames t Transfer: 1220 : 55|16:31:52.9139||IsUserAuthenticated: /api/v3/config/servicexml/types?_dc=1575995481733 t Transfer: 1220 : 55|16:31:52.9139||GetCurrentUser.. t Transfer: 1220 : 55|16:31:52.9139|| OAuth authenticated t Transfer: 1220 : 55|16:31:52.9139|| user TONY. t Transfer: 1220 : 55|16:31:52.9139||api user: TONY t Transfer: 1220 : 52|16:32:00.9139||IsUserAuthenticated: /api/settings/group/110?_dc=1575995490289 t Transfer: 1220 : 52|16:32:00.9139||GetCurrentUser.. t Transfer: 1220 : 52|16:32:00.9139|| OAuth authenticated t Transfer: 1220 : 52|16:32:00.9139|| user TONY. t Transfer: 1220 : 52|16:32:00.9139||api user: TONY t Information: 1220 : 52|16:32:00.9139||V3Api.GetSettingsGroup t Transfer: 1220 : 51|16:32:01.4139||IsUserAuthenticated: /api/search/search-fields/?_dc=1575995490777 t Transfer: 1220 : 51|16:32:01.4139||GetCurrentUser.. t Transfer: 1220 : 51|16:32:01.4139|| OAuth authenticated t Transfer: 1220 : 51|16:32:01.4139|| user TONY. t Transfer: 1220 : 51|16:32:01.4139||api user: TONY t Information: 1220 : 51|16:32:01.4139||V3Api.GetSearchFieldsAll t Transfer: 1220 : 47|16:32:01.4139||IsUserAuthenticated: /api/view/searchinfo/Media?_dc=1575995490778 t Transfer: 1220 : 47|16:32:01.4139||GetCurrentUser.. t Transfer: 1220 : 47|16:32:01.4139|| OAuth authenticated t Transfer: 1220 : 47|16:32:01.4139|| user TONY. t Transfer: 1220 : 47|16:32:01.4139||api user: TONY t Transfer: 1220 : 48|16:32:01.4139||IsUserAuthenticated: /api/search/facets/?_dc=1575995490780 t Transfer: 1220 : 48|16:32:01.4139||GetCurrentUser.. t Transfer: 1220 : 48|16:32:01.4139|| OAuth authenticated t Transfer: 1220 : 48|16:32:01.4139|| user TONY. t Transfer: 1220 : 48|16:32:01.4139||api user: TONY t Information: 1220 : 47|16:32:01.4139||GetAdvSearchColumns. search type Media grid . t Information: 1220 : 48|16:32:01.4139||V3Api.GetFacetsAll t Transfer: 1220 : 56|16:32:01.4764||IsUserAuthenticated: /api/settings/user/defaultSearch?_dc=1575995490848 t Transfer: 1220 : 56|16:32:01.4764||GetCurrentUser.. t Transfer: 1220 : 56|16:32:01.4764|| OAuth authenticated t Transfer: 1220 : 56|16:32:01.4764|| user TONY. t Transfer: 1220 : 56|16:32:01.4764||api user: TONY t Information: 1220 : 56|16:32:01.4764||V3Api.GetUserSettings t Transfer: 1220 : 56|16:32:01.4764||GetCurrentUser.. t Transfer: 1220 : 56|16:32:01.4764|| OAuth authenticated t Transfer: 1220 : 56|16:32:01.4764|| user TONY. t Transfer: 1220 : 29|16:32:01.5077||IsUserAuthenticated: /api/lookups/UsageTypes?_dc=1575995490881 t Transfer: 1220 : 29|16:32:01.5077||GetCurrentUser.. t Transfer: 1220 : 29|16:32:01.5077|| OAuth authenticated t Transfer: 1220 : 29|16:32:01.5077|| user TONY. t Transfer: 1220 : 29|16:32:01.5077||api user: TONY t Transfer: 1220 : 52|16:32:01.5233||IsUserAuthenticated: /api/lookups/ItemTypes?_dc=1575995490891 t Transfer: 1220 : 52|16:32:01.5233||GetCurrentUser.. t Transfer: 1220 : 52|16:32:01.5233|| OAuth authenticated t Transfer: 1220 : 52|16:32:01.5233|| user TONY. t Transfer: 1220 : 52|16:32:01.5233||api user: TONY t Transfer: 1220 : 61|16:32:01.5233||IsUserAuthenticated: /api/view/searchinfo/Version?_dc=1575995490896 t Transfer: 1220 : 61|16:32:01.5233||GetCurrentUser.. t Transfer: 1220 : 61|16:32:01.5233|| OAuth authenticated t Transfer: 1220 : 61|16:32:01.5233|| user TONY. t Transfer: 1220 : 61|16:32:01.5233||api user: TONY t Information: 1220 : 61|16:32:01.5233||GetAdvSearchColumns. search type Version grid . t Transfer: 1220 : 51|16:32:01.5702||IsUserAuthenticated: /api/view/searches/Media?_dc=1575995490916 t Transfer: 1220 : 51|16:32:01.5702||GetCurrentUser.. t Transfer: 1220 : 51|16:32:01.5702|| OAuth authenticated t Transfer: 1220 : 51|16:32:01.5702|| user TONY. t Transfer: 1220 : 51|16:32:01.5702||api user: TONY t Information: 1220 : 51|16:32:01.5702||GetSavedSearchNames. search type Media. t Transfer: 1220 : 51|16:32:01.5702||GetCurrentUser.. t Transfer: 1220 : 51|16:32:01.5702|| OAuth authenticated t Transfer: 1220 : 51|16:32:01.5702|| user TONY. t Transfer: 1220 : 56|16:32:01.6170||IsUserAuthenticated: /api/view/searches/Version?_dc=1575995490909 t Transfer: 1220 : 56|16:32:01.6170||GetCurrentUser.. t Transfer: 1220 : 56|16:32:01.6170|| OAuth authenticated t Transfer: 1220 : 56|16:32:01.6170|| user TONY. t Transfer: 1220 : 56|16:32:01.6170||api user: TONY t Information: 1220 : 56|16:32:01.6170||GetSavedSearchNames. search type Version. t Transfer: 1220 : 56|16:32:01.6170||GetCurrentUser.. t Transfer: 1220 : 56|16:32:01.6170|| OAuth authenticated t Transfer: 1220 : 56|16:32:01.6170|| user TONY. t Transfer: 1220 : 61|16:32:01.7733||IsUserAuthenticated: /api/user-preferences?keys=consumer.recent.data&_dc=1575995491139 t Transfer: 1220 : 61|16:32:01.7733||GetCurrentUser.. t Transfer: 1220 : 61|16:32:01.7733|| OAuth authenticated t Transfer: 1220 : 61|16:32:01.7733|| user TONY. t Transfer: 1220 : 61|16:32:01.7733||api user: TONY t Information: 1220 : 61|16:32:01.7733||GetUserDataByKeys: consumer.recent.data t Transfer: 1220 : 61|16:32:01.7733||GetCurrentUser.. t Transfer: 1220 : 61|16:32:01.7733|| OAuth authenticated t Transfer: 1220 : 61|16:32:01.7733|| user TONY. t Transfer: 1220 : 48|16:32:01.8826||IsUserAuthenticated: /api/xml-schemas/?_dc=1575995490870 t Transfer: 1220 : 48|16:32:01.8826||GetCurrentUser.. t Transfer: 1220 : 48|16:32:01.8826|| OAuth authenticated t Transfer: 1220 : 48|16:32:01.8826|| user TONY. t Transfer: 1220 : 48|16:32:01.8826||api user: TONY t Transfer: 1220 : 56|16:32:01.8983||IsUserAuthenticated: /api/view/info/ChameleonSearch?_dc=1575995490855 t Transfer: 1220 : 56|16:32:01.8983||GetCurrentUser.. t Transfer: 1220 : 56|16:32:01.8983|| OAuth authenticated t Transfer: 1220 : 56|16:32:01.8983|| user TONY. t Transfer: 1220 : 56|16:32:01.8983||api user: TONY t Information: 1220 : 56|16:32:01.8983||GetGridViewBuilder. builder type ChameleonSearch. t Transfer: 1220 : 56|16:32:01.8983||GetCurrentUser.. t Transfer: 1220 : 56|16:32:01.8983|| OAuth authenticated t Transfer: 1220 : 56|16:32:01.8983|| user TONY. t Information: 1220 : 56|16:32:01.8983||UserGridView. LoadView. ID -1, Name Default. t Transfer: 1220 : 56|16:32:01.8983||GetCurrentUser.. t Transfer: 1220 : 56|16:32:01.8983|| OAuth authenticated t Transfer: 1220 : 56|16:32:01.8983|| user TONY. t Transfer: 1220 : 54|16:32:01.8983||IsUserAuthenticated: /api/view/info/ChameleonSearch?_dc=1575995490862 t Transfer: 1220 : 54|16:32:01.8983||GetCurrentUser.. t Transfer: 1220 : 54|16:32:01.8983|| OAuth authenticated t Transfer: 1220 : 54|16:32:01.8983|| user TONY. t Transfer: 1220 : 56|16:32:01.8983||GetCurrentUser.. t Transfer: 1220 : 56|16:32:01.8983|| OAuth authenticated t Transfer: 1220 : 56|16:32:01.8983|| user TONY. t Transfer: 1220 : 54|16:32:01.8983||api user: TONY t Information: 1220 : 54|16:32:01.8983||GetGridViewBuilder. builder type ChameleonSearch. t Transfer: 1220 : 54|16:32:01.8983||GetCurrentUser.. t Transfer: 1220 : 54|16:32:01.8983|| OAuth authenticated t Transfer: 1220 : 54|16:32:01.8983|| user TONY. t Information: 1220 : 54|16:32:01.9140||UserGridView. LoadView. ID -1, Name Default. t Transfer: 1220 : 54|16:32:01.9140||GetCurrentUser.. t Transfer: 1220 : 54|16:32:01.9140|| OAuth authenticated t Transfer: 1220 : 54|16:32:01.9140|| user TONY. t Transfer: 1220 : 54|16:32:01.9140||GetCurrentUser.. t Transfer: 1220 : 54|16:32:01.9140|| OAuth authenticated t Transfer: 1220 : 54|16:32:01.9140|| user TONY. t Transfer: 1220 : 52|16:32:01.9608||IsUserAuthenticated: /api/view/searchinfo/Media?_dc=1575995490898 t Transfer: 1220 : 52|16:32:01.9608||GetCurrentUser.. t Transfer: 1220 : 52|16:32:01.9608|| OAuth authenticated t Transfer: 1220 : 52|16:32:01.9608|| user TONY. t Transfer: 1220 : 52|16:32:01.9608||api user: TONY t Information: 1220 : 52|16:32:01.9608||GetAdvSearchColumns. search type Media grid . t Transfer: 1220 : 47|16:32:01.9608||IsUserAuthenticated: /api/order-presets?_dc=1575995490892 t Transfer: 1220 : 47|16:32:01.9608||GetCurrentUser.. t Transfer: 1220 : 47|16:32:01.9608|| OAuth authenticated t Transfer: 1220 : 47|16:32:01.9608|| user TONY. t Transfer: 1220 : 47|16:32:01.9608||api user: TONY t Transfer: 1220 : 47|16:32:01.9764||GetCurrentUser.. t Transfer: 1220 : 47|16:32:01.9764|| OAuth authenticated t Transfer: 1220 : 47|16:32:01.9764|| user TONY. t Transfer: 1220 : 52|16:32:02.0233||IsUserAuthenticated: /api/view/searchinfo/Version?_dc=1575995490779 t Transfer: 1220 : 52|16:32:02.0233||GetCurrentUser.. t Transfer: 1220 : 52|16:32:02.0233|| OAuth authenticated t Transfer: 1220 : 52|16:32:02.0233|| user TONY. t Transfer: 1220 : 52|16:32:02.0233||api user: TONY t Information: 1220 : 52|16:32:02.0233||GetAdvSearchColumns. search type Version grid . t Transfer: 1220 : 55|16:32:02.2108||IsUserAuthenticated: /api/view/searchinfo/Version?_dc=1575995490917 t Transfer: 1220 : 55|16:32:02.2108||GetCurrentUser.. t Transfer: 1220 : 55|16:32:02.2108|| OAuth authenticated t Transfer: 1220 : 55|16:32:02.2108|| user TONY. t Transfer: 1220 : 55|16:32:02.2108||api user: TONY t Information: 1220 : 55|16:32:02.2108||GetAdvSearchColumns. search type Version grid . t Transfer: 1220 : 52|16:32:02.2577||IsUserAuthenticated: /api/view/searches/Version?_dc=1575995490924 t Transfer: 1220 : 52|16:32:02.2577||GetCurrentUser.. t Transfer: 1220 : 52|16:32:02.2577|| OAuth authenticated t Transfer: 1220 : 52|16:32:02.2577|| user TONY. t Transfer: 1220 : 52|16:32:02.2577||api user: TONY t Information: 1220 : 52|16:32:02.2577||GetSavedSearchNames. search type Version. t Transfer: 1220 : 52|16:32:02.2577||GetCurrentUser.. t Transfer: 1220 : 52|16:32:02.2577|| OAuth authenticated t Transfer: 1220 : 52|16:32:02.2577|| user TONY. t Transfer: 1220 : 51|16:32:06.5233||IsUserAuthenticated: /api/order-presets?_dc=1575995490892 t Transfer: 1220 : 51|16:32:06.5233||GetCurrentUser.. t Transfer: 1220 : 51|16:32:06.5233|| OAuth authenticated t Transfer: 1220 : 51|16:32:06.5233|| user TONY. t Transfer: 1220 : 51|16:32:06.5233||api user: TONY t Transfer: 1220 : 51|16:32:06.5233||GetCurrentUser.. t Transfer: 1220 : 51|16:32:06.5233|| OAuth authenticated t Transfer: 1220 : 51|16:32:06.5233|| user TONY. t Transfer: 1220 : 60|16:34:26.3826||IsUserAuthenticated: /api/settings/group/110?_dc=1575995635180 t Transfer: 1220 : 60|16:34:26.3826||GetCurrentUser.. t Transfer: 1220 : 60|16:34:26.3826|| OAuth authenticated t Transfer: 1220 : 60|16:34:26.3826|| user TONY. t Transfer: 1220 : 60|16:34:26.3826||api user: TONY t Information: 1220 : 60|16:34:26.4139||V3Api.UpdateSettingsGroup t Transfer: 1220 : 52|16:34:27.9139||IsUserAuthenticated: /api/settings/user/defaultSearchColumnsVersion?_dc=1575995636639 t Transfer: 1220 : 52|16:34:27.9296||GetCurrentUser.. t Transfer: 1220 : 52|16:34:27.9296|| OAuth authenticated t Transfer: 1220 : 52|16:34:27.9296|| user TONY. t Transfer: 1220 : 52|16:34:27.9296||api user: TONY t Information: 1220 : 52|16:34:27.9296||V3Api.GetUserSettings t Transfer: 1220 : 52|16:34:27.9296||GetCurrentUser.. t Transfer: 1220 : 52|16:34:27.9296|| OAuth authenticated t Transfer: 1220 : 52|16:34:27.9296|| user TONY. t Transfer: 1220 : 45|16:34:27.9608||IsUserAuthenticated: /api/user-preferences?_dc=1575995636643 t Transfer: 1220 : 45|16:34:27.9608||GetCurrentUser.. t Transfer: 1220 : 45|16:34:27.9608|| OAuth authenticated t Transfer: 1220 : 45|16:34:27.9608|| user TONY. t Transfer: 1220 : 45|16:34:27.9608||api user: TONY t Verbose: 1220 : 45|16:34:27.9608||StoreUserDataByKeys.. t Transfer: 1220 : 45|16:34:27.9608||GetCurrentUser.. t Transfer: 1220 : 45|16:34:27.9608|| OAuth authenticated t Transfer: 1220 : 45|16:34:27.9608|| user TONY. t Transfer: 1220 : 60|16:34:27.9608||IsUserAuthenticated: /api/settings/user/defaultSearchMisrDetailsMediaColumns?_dc=1575995636640 t Transfer: 1220 : 60|16:34:27.9608||GetCurrentUser.. t Transfer: 1220 : 60|16:34:27.9608|| OAuth authenticated t Transfer: 1220 : 60|16:34:27.9608|| user TONY. t Transfer: 1220 : 60|16:34:27.9608||api user: TONY t Information: 1220 : 60|16:34:27.9608||V3Api.GetUserSettings t Transfer: 1220 : 60|16:34:27.9608||GetCurrentUser.. t Transfer: 1220 : 60|16:34:27.9608|| OAuth authenticated t Transfer: 1220 : 60|16:34:27.9608|| user TONY. t Transfer: 1220 : 51|16:34:27.9764||IsUserAuthenticated: /api/settings/user/defaultSearchColumnsMedia?_dc=1575995636638 t Transfer: 1220 : 51|16:34:27.9764||GetCurrentUser.. t Transfer: 1220 : 51|16:34:27.9764|| OAuth authenticated t Transfer: 1220 : 51|16:34:27.9764|| user TONY. t Transfer: 1220 : 51|16:34:27.9764||api user: TONY t Information: 1220 : 51|16:34:27.9764||V3Api.GetUserSettings t Transfer: 1220 : 51|16:34:27.9764||GetCurrentUser.. t Transfer: 1220 : 51|16:34:27.9764|| OAuth authenticated t Transfer: 1220 : 51|16:34:27.9764|| user TONY. t Transfer: 1220 : 52|16:34:27.9764||IsUserAuthenticated: /api/settings/user/defaultSearchColumnsSimple?_dc=1575995636639 t Transfer: 1220 : 52|16:34:27.9764||GetCurrentUser.. t Transfer: 1220 : 52|16:34:27.9764|| OAuth authenticated t Transfer: 1220 : 52|16:34:27.9764|| user TONY. t Transfer: 1220 : 52|16:34:27.9764||api user: TONY t Information: 1220 : 52|16:34:27.9764||V3Api.GetUserSettings t Transfer: 1220 : 52|16:34:27.9764||GetCurrentUser.. t Transfer: 1220 : 52|16:34:27.9764|| OAuth authenticated t Transfer: 1220 : 52|16:34:27.9764|| user TONY. t Transfer: 1220 : 42|16:34:27.9921||IsUserAuthenticated: /api/settings/user/versionCreationSettings?_dc=1575995636642 t Transfer: 1220 : 42|16:34:27.9921||GetCurrentUser.. t Transfer: 1220 : 42|16:34:27.9921|| OAuth authenticated t Transfer: 1220 : 42|16:34:27.9921|| user TONY. t Transfer: 1220 : 42|16:34:27.9921||api user: TONY t Information: 1220 : 42|16:34:27.9921||V3Api.GetUserSettings t Transfer: 1220 : 42|16:34:27.9921||GetCurrentUser.. t Transfer: 1220 : 42|16:34:27.9921|| OAuth authenticated t Transfer: 1220 : 42|16:34:27.9921|| user TONY. t Transfer: 1220 : 51|16:34:38.3670||IsUserAuthenticated: /api/v3/config/location-views?_dc=1575995647736 t Transfer: 1220 : 51|16:34:38.3670||GetCurrentUser.. t Transfer: 1220 : 51|16:34:38.3670|| OAuth authenticated t Transfer: 1220 : 51|16:34:38.3670|| user TONY. t Transfer: 1220 : 51|16:34:38.3670||api user: TONY t Information: 1220 : 51|16:34:38.3670||Get location views t Information: 1220 : 51|16:34:38.3670||GetLocationDefaultViews. t Transfer: 1220 : 56|16:35:37.1952||IsUserAuthenticated: /api/v3/config/users?showDisabled=true&_dc=1575995706567 t Transfer: 1220 : 56|16:35:37.1952||GetCurrentUser.. t Transfer: 1220 : 56|16:35:37.1952|| OAuth authenticated t Transfer: 1220 : 56|16:35:37.1952|| user TONY. t Transfer: 1220 : 56|16:35:37.1952||api user: TONY t Information: 1220 : 56|16:35:37.1952||GetUsersFiltered t Transfer: 1220 : 50|16:35:55.3827||IsUserAuthenticated: /api/lookups/Departments?_dc=1575995724744 t Transfer: 1220 : 50|16:35:55.3827||GetCurrentUser.. t Transfer: 1220 : 50|16:35:55.3827|| OAuth authenticated t Transfer: 1220 : 50|16:35:55.3983|| user TONY. t Transfer: 1220 : 50|16:35:55.3983||api user: TONY t Transfer: 1220 : 52|16:35:55.4452||IsUserAuthenticated: /api/v3/config/user/522?_dc=1575995724816 t Transfer: 1220 : 52|16:35:55.4452||GetCurrentUser.. t Transfer: 1220 : 52|16:35:55.4452|| OAuth authenticated t Transfer: 1220 : 52|16:35:55.4452|| user TONY. t Transfer: 1220 : 52|16:35:55.4452||api user: TONY t Information: 1220 : 52|16:35:55.4608||GetUserById 522 t Transfer: 1220 : 56|16:35:55.8671||IsUserAuthenticated: /api/settings/groups/?_dc=1575995724817 t Transfer: 1220 : 56|16:35:55.8671||GetCurrentUser.. t Transfer: 1220 : 56|16:35:55.8671|| OAuth authenticated t Transfer: 1220 : 56|16:35:55.8671|| user TONY. t Transfer: 1220 : 56|16:35:55.8671||api user: TONY t Information: 1220 : 56|16:35:55.8671||V3Api.GetSettingsGroupsNames t Transfer: 1220 : 44|16:35:56.0233||IsUserAuthenticated: /api/lookups/Devices?_dc=1575995724746 t Transfer: 1220 : 44|16:35:56.0233||GetCurrentUser.. t Transfer: 1220 : 44|16:35:56.0233|| OAuth authenticated t Transfer: 1220 : 44|16:35:56.0233|| user TONY. t Transfer: 1220 : 44|16:35:56.0233||api user: TONY t Information: 1220 : 52|16:35:56.1483||GetUserDbaMode t Information: 1220 : 52|16:35:56.1483||GetUserOracleStatus t Transfer: 1220 : 50|16:35:56.8670||IsUserAuthenticated: /api/lookup/locations/search/?_dc=1575995726239 t Transfer: 1220 : 50|16:35:56.8670||GetCurrentUser.. t Transfer: 1220 : 50|16:35:56.8670|| OAuth authenticated t Transfer: 1220 : 50|16:35:56.8670|| user TONY. t Transfer: 1220 : 50|16:35:56.8670||api user: TONY t Transfer: 1220 : 50|16:36:38.0233||IsUserAuthenticated: /api/user-preferences?keys=adv.recent.searches.media&_dc=1575995767401 t Transfer: 1220 : 50|16:36:38.0233||GetCurrentUser.. t Transfer: 1220 : 50|16:36:38.0233|| OAuth authenticated t Transfer: 1220 : 50|16:36:38.0233|| user TONY. t Transfer: 1220 : 50|16:36:38.0233||api user: TONY t Information: 1220 : 50|16:36:38.0233||GetUserDataByKeys: adv.recent.searches.media t Transfer: 1220 : 50|16:36:38.0233||GetCurrentUser.. t Transfer: 1220 : 50|16:36:38.0233|| OAuth authenticated t Transfer: 1220 : 50|16:36:38.0233|| user TONY. t Transfer: 1220 : 35|16:36:38.6483||IsUserAuthenticated: /api/settings/user/searchLayoutConfig?_dc=1575995767405 t Transfer: 1220 : 35|16:36:38.6483||GetCurrentUser.. t Transfer: 1220 : 35|16:36:38.6483|| OAuth authenticated t Transfer: 1220 : 35|16:36:38.6483|| user TONY. t Transfer: 1220 : 35|16:36:38.6483||api user: TONY t Information: 1220 : 35|16:36:38.6483||V3Api.GetUserSettings t Transfer: 1220 : 35|16:36:38.6483||GetCurrentUser.. t Transfer: 1220 : 35|16:36:38.6483|| OAuth authenticated t Transfer: 1220 : 35|16:36:38.6483|| user TONY. t Transfer: 1220 : 56|16:36:41.2577||IsUserAuthenticated: /api/SearchSuggestion/?_dc=1575995770635 t Transfer: 1220 : 56|16:36:41.2577||GetCurrentUser.. t Transfer: 1220 : 56|16:36:41.2577|| OAuth authenticated t Transfer: 1220 : 56|16:36:41.2577|| user TONY. t Transfer: 1220 : 56|16:36:41.2577||api user: TONY t Transfer: 1220 : 56|16:36:41.2577||GetCurrentUser.. t Transfer: 1220 : 56|16:36:41.2577|| OAuth authenticated t Transfer: 1220 : 56|16:36:41.2577|| user TONY. t Transfer: 1220 : 55|16:36:42.4295||IsUserAuthenticated: /api/search/Media?_dc=1575995771810 t Transfer: 1220 : 55|16:36:42.4295||GetCurrentUser.. t Transfer: 1220 : 55|16:36:42.4295|| OAuth authenticated t Transfer: 1220 : 55|16:36:42.4295|| user TONY. t Transfer: 1220 : 55|16:36:42.4295||api user: TONY t Information: 1220 : 55|16:36:42.4452||V3Api.SearchMedia t Information: 1220 : 55|16:36:42.4920||V3Api.SearchGeneric t Transfer: 1220 : 55|16:36:42.5077||GetCurrentUser.. t Transfer: 1220 : 55|16:36:42.5077|| OAuth authenticated t Transfer: 1220 : 55|16:36:42.5077|| user TONY. t Information: 1220 : 55|16:36:42.5702||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 Information: 1220 : 55|16:36:42.6327|| timing: 00:00:00.1422972 t Verbose: 1220 : 55|16:36:42.6327||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\England v Bangladesh Match Group A.mp4 subfolder t Verbose: 1220 : 55|16:36:42.6327|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/England v Bangladesh Match Group A.mp4 t Verbose: 1220 : 55|16:36:42.6327||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/England v Bangladesh Match Group A.mp4 t Transfer: 1220 : 55|16:36:42.6327||GetCurrentUser.. t Transfer: 1220 : 55|16:36:42.6327|| OAuth authenticated t Transfer: 1220 : 55|16:36:42.6327|| user TONY. t Verbose: 1220 : 55|16:36:42.6327||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\ICC 360 Cricket for Change.mp4 subfolder t Verbose: 1220 : 55|16:36:42.6327|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/ICC 360 Cricket for Change.mp4 t Verbose: 1220 : 55|16:36:42.6327||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/ICC 360 Cricket for Change.mp4 t Transfer: 1220 : 55|16:36:42.6327||GetCurrentUser.. t Transfer: 1220 : 55|16:36:42.6327|| OAuth authenticated t Transfer: 1220 : 55|16:36:42.6327|| user TONY. t Verbose: 1220 : 55|16:36:42.6327||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Australia vs South Africa Match 45.mp4 subfolder t Verbose: 1220 : 55|16:36:42.6327|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Australia vs South Africa Match 45.mp4 t Verbose: 1220 : 55|16:36:42.6327||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/Australia vs South Africa Match 45.mp4 t Transfer: 1220 : 55|16:36:42.6327||GetCurrentUser.. t Transfer: 1220 : 55|16:36:42.6327|| OAuth authenticated t Transfer: 1220 : 55|16:36:42.6327|| user TONY. t Verbose: 1220 : 55|16:36:42.6327||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\England vs South Africa Match 1.mp4 subfolder t Verbose: 1220 : 55|16:36:42.6327|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/England vs South Africa Match 1.mp4 t Verbose: 1220 : 55|16:36:42.6327||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/England vs South Africa Match 1.mp4 t Transfer: 1220 : 55|16:36:42.6327||GetCurrentUser.. t Transfer: 1220 : 55|16:36:42.6327|| OAuth authenticated t Transfer: 1220 : 55|16:36:42.6327|| user TONY. t Verbose: 1220 : 55|16:36:42.6327||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\West Indies vs Pakistan Match 2.mp4 subfolder t Verbose: 1220 : 55|16:36:42.6327|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/West Indies vs Pakistan Match 2.mp4 t Verbose: 1220 : 55|16:36:42.6327||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/West Indies vs Pakistan Match 2.mp4 t Transfer: 1220 : 55|16:36:42.6327||GetCurrentUser.. t Transfer: 1220 : 55|16:36:42.6327|| OAuth authenticated t Transfer: 1220 : 55|16:36:42.6327|| user TONY. t Verbose: 1220 : 55|16:36:42.6327||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\New Zealand vs England Final.mp4 subfolder t Verbose: 1220 : 55|16:36:42.6327|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/New Zealand vs England Final.mp4 t Verbose: 1220 : 55|16:36:42.6327||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/New Zealand vs England Final.mp4 t Transfer: 1220 : 55|16:36:42.6327||GetCurrentUser.. t Transfer: 1220 : 55|16:36:42.6327|| OAuth authenticated t Transfer: 1220 : 55|16:36:42.6327|| user TONY. t Verbose: 1220 : 55|16:36:42.6327||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Australia vs England Short Semi Final 2.mp4 subfolder t Verbose: 1220 : 55|16:36:42.6327|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Australia vs England Short Semi Final 2.mp4 t Verbose: 1220 : 55|16:36:42.6327||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/Australia vs England Short Semi Final 2.mp4 t Transfer: 1220 : 55|16:36:42.6327||GetCurrentUser.. t Transfer: 1220 : 55|16:36:42.6327|| OAuth authenticated t Transfer: 1220 : 55|16:36:42.6483|| user TONY. t Verbose: 1220 : 55|16:36:42.6483||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\India vs New Zealand Semi Final 1.mp4 subfolder t Verbose: 1220 : 55|16:36:42.6483|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/India vs New Zealand Semi Final 1.mp4 t Verbose: 1220 : 55|16:36:42.6483||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/India vs New Zealand Semi Final 1.mp4 t Transfer: 1220 : 55|16:36:42.6483||GetCurrentUser.. t Transfer: 1220 : 55|16:36:42.6483|| OAuth authenticated t Transfer: 1220 : 55|16:36:42.6483|| user TONY. t Verbose: 1220 : 55|16:36:42.6483||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Scotland vs Oman 5th Place Play Off.mp4 subfolder t Verbose: 1220 : 55|16:36:42.6483|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Scotland vs Oman 5th Place Play Off.mp4 t Verbose: 1220 : 55|16:36:42.6483||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/Scotland vs Oman 5th Place Play Off.mp4 t Transfer: 1220 : 55|16:36:42.6483||GetCurrentUser.. t Transfer: 1220 : 55|16:36:42.6483|| OAuth authenticated t Transfer: 1220 : 55|16:36:42.6483|| user TONY. t Verbose: 1220 : 55|16:36:42.6483||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\South Africa vs Bangladesh Match 5 .mp4 subfolder t Verbose: 1220 : 55|16:36:42.6483|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/South Africa vs Bangladesh Match 5 .mp4 t Verbose: 1220 : 55|16:36:42.6483||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/South Africa vs Bangladesh Match 5 .mp4 t Transfer: 1220 : 55|16:36:42.6483||GetCurrentUser.. t Transfer: 1220 : 55|16:36:42.6483|| OAuth authenticated t Transfer: 1220 : 55|16:36:42.6483|| user TONY. t Verbose: 1220 : 55|16:36:42.6483||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\New Zealand vs Sri Lanka Match 3.mp4 subfolder t Verbose: 1220 : 55|16:36:42.6483|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/New Zealand vs Sri Lanka Match 3.mp4 t Verbose: 1220 : 55|16:36:42.6483||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/New Zealand vs Sri Lanka Match 3.mp4 t Transfer: 1220 : 55|16:36:42.6483||GetCurrentUser.. t Transfer: 1220 : 55|16:36:42.6483|| OAuth authenticated t Transfer: 1220 : 55|16:36:42.6483|| user TONY. t Verbose: 1220 : 55|16:36:42.6483||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Afghanistan vs Australia Match 4.mp4 subfolder t Verbose: 1220 : 55|16:36:42.6483|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Afghanistan vs Australia Match 4.mp4 t Verbose: 1220 : 55|16:36:42.6483||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/Afghanistan vs Australia Match 4.mp4 t Transfer: 1220 : 55|16:36:42.6483||GetCurrentUser.. t Transfer: 1220 : 55|16:36:42.6483|| OAuth authenticated t Transfer: 1220 : 55|16:36:42.6483|| user TONY. t Verbose: 1220 : 55|16:36:42.6483||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Bangladesh vs New Zealand Match 9.mp4 subfolder t Verbose: 1220 : 55|16:36:42.6483|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Bangladesh vs New Zealand Match 9.mp4 t Verbose: 1220 : 55|16:36:42.6483||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/Bangladesh vs New Zealand Match 9.mp4 t Transfer: 1220 : 55|16:36:42.6483||GetCurrentUser.. t Transfer: 1220 : 55|16:36:42.6483|| OAuth authenticated t Transfer: 1220 : 55|16:36:42.6483|| user TONY. t Verbose: 1220 : 55|16:36:42.6483||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Afghanistan vs Sri Lanka Match 7.mp4 subfolder t Verbose: 1220 : 55|16:36:42.6483|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Afghanistan vs Sri Lanka Match 7.mp4 t Verbose: 1220 : 55|16:36:42.6483||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/Afghanistan vs Sri Lanka Match 7.mp4 t Transfer: 1220 : 55|16:36:42.6483||GetCurrentUser.. t Transfer: 1220 : 55|16:36:42.6483|| OAuth authenticated t Transfer: 1220 : 55|16:36:42.6483|| user TONY. t Verbose: 1220 : 55|16:36:42.6483||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Australia vs West Indies Match 10.mp4 subfolder t Verbose: 1220 : 55|16:36:42.6483|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Australia vs West Indies Match 10.mp4 t Verbose: 1220 : 55|16:36:42.6483||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/Australia vs West Indies Match 10.mp4 t Transfer: 1220 : 55|16:36:42.6483||GetCurrentUser.. t Transfer: 1220 : 55|16:36:42.6483|| OAuth authenticated t Transfer: 1220 : 55|16:36:42.6483|| user TONY. t Verbose: 1220 : 55|16:36:42.6483||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\South Africa vs India Match 8.mp4 subfolder t Verbose: 1220 : 55|16:36:42.6483|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/South Africa vs India Match 8.mp4 t Verbose: 1220 : 55|16:36:42.6483||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/South Africa vs India Match 8.mp4 t Transfer: 1220 : 55|16:36:42.6483||GetCurrentUser.. t Transfer: 1220 : 55|16:36:42.6483|| OAuth authenticated t Transfer: 1220 : 55|16:36:42.6483|| user TONY. t Verbose: 1220 : 55|16:36:42.6483||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\England vs Pakistan Match 6.mp4 subfolder t Verbose: 1220 : 55|16:36:42.6483|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/England vs Pakistan Match 6.mp4 t Verbose: 1220 : 55|16:36:42.6483||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/England vs Pakistan Match 6.mp4 t Transfer: 1220 : 55|16:36:42.6483||GetCurrentUser.. t Transfer: 1220 : 55|16:36:42.6483|| OAuth authenticated t Transfer: 1220 : 55|16:36:42.6483|| user TONY. t Verbose: 1220 : 55|16:36:42.6483||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Pakistan vs Sri Lanka Match 11.mp4 subfolder t Verbose: 1220 : 55|16:36:42.6483|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Pakistan vs Sri Lanka Match 11.mp4 t Verbose: 1220 : 55|16:36:42.6483||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/Pakistan vs Sri Lanka Match 11.mp4 t Transfer: 1220 : 55|16:36:42.6483||GetCurrentUser.. t Transfer: 1220 : 55|16:36:42.6483|| OAuth authenticated t Transfer: 1220 : 55|16:36:42.6483|| user TONY. t Transfer: 1220 : 51|16:36:43.4920||IsUserAuthenticated: /api/user-preferences?_dc=1575995772860 t Transfer: 1220 : 51|16:36:43.4920||GetCurrentUser.. t Transfer: 1220 : 51|16:36:43.4920|| OAuth authenticated t Transfer: 1220 : 51|16:36:43.4920|| user TONY. t Transfer: 1220 : 51|16:36:43.4920||api user: TONY t Verbose: 1220 : 51|16:36:43.4920||StoreUserDataByKeys.. t Transfer: 1220 : 51|16:36:43.4920||GetCurrentUser.. t Transfer: 1220 : 51|16:36:43.4920|| OAuth authenticated t Transfer: 1220 : 51|16:36:43.4920|| user TONY. t Transfer: 1220 : 42|16:36:44.2264||IsUserAuthenticated: /api/user-group-preferences?globals=htmlplayerhotkeys,audioOnFrameForward&_dc=1575995773606 t Transfer: 1220 : 42|16:36:44.2264||GetCurrentUser.. t Transfer: 1220 : 42|16:36:44.2264|| OAuth authenticated t Transfer: 1220 : 42|16:36:44.2264|| user TONY. t Transfer: 1220 : 42|16:36:44.2264||api user: TONY t Information: 1220 : 42|16:36:44.2264||V3Api.GetUserSettings t Transfer: 1220 : 42|16:36:44.2264||GetCurrentUser.. t Transfer: 1220 : 42|16:36:44.2264|| OAuth authenticated t Transfer: 1220 : 42|16:36:44.2264|| user TONY. t Information: 1220 : 50|16:36:44.3983||V3Api.GetMediaTagging t Transfer: 1220 : 56|16:36:44.3983||IsUserAuthenticated: /api/lookups/FriendlyNames?_dc=1575995773761 t Transfer: 1220 : 56|16:36:44.3983||GetCurrentUser.. t Transfer: 1220 : 56|16:36:44.3983|| OAuth authenticated t Transfer: 1220 : 56|16:36:44.3983|| user TONY. t Transfer: 1220 : 56|16:36:44.3983||api user: TONY t Transfer: 1220 : 50|16:36:44.6483||IsUserAuthenticated: /api/search/Media?_dc=1575995773465 t Transfer: 1220 : 50|16:36:44.6483||GetCurrentUser.. t Transfer: 1220 : 50|16:36:44.6483|| OAuth authenticated t Transfer: 1220 : 50|16:36:44.6483|| user TONY. t Transfer: 1220 : 50|16:36:44.6483||api user: TONY t Information: 1220 : 50|16:36:44.6483||V3Api.SearchMedia t Information: 1220 : 50|16:36:44.6483||V3Api.SearchGeneric t Transfer: 1220 : 50|16:36:44.6483||GetCurrentUser.. t Transfer: 1220 : 50|16:36:44.6483|| OAuth authenticated t Transfer: 1220 : 50|16:36:44.6483|| user TONY. t Transfer: 1220 : 44|16:36:44.6483||IsUserAuthenticated: /api/lookups/FriendlyNames?_dc=1575995773464 t Transfer: 1220 : 44|16:36:44.6483||GetCurrentUser.. t Transfer: 1220 : 44|16:36:44.6483|| OAuth authenticated t Transfer: 1220 : 44|16:36:44.6483|| user TONY. t Transfer: 1220 : 44|16:36:44.6483||api user: TONY t Information: 1220 : 50|16:36:44.6483||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 where media_type>0 and item_type>0 AND m.ID=298524 and m.mi_deleted=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 : 50|16:36:44.7264|| timing: 00:00:00.0787592 t Verbose: 1220 : 50|16:36:44.7264||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\England v Bangladesh Match Group A.mp4 subfolder t Verbose: 1220 : 50|16:36:44.7264|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/England v Bangladesh Match Group A.mp4 t Verbose: 1220 : 50|16:36:44.7264||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/England v Bangladesh Match Group A.mp4 t Transfer: 1220 : 50|16:36:44.7264||GetCurrentUser.. t Transfer: 1220 : 50|16:36:44.7264|| OAuth authenticated t Transfer: 1220 : 50|16:36:44.7264|| user TONY. t Transfer: 1220 : 56|16:36:44.7577||IsUserAuthenticated: /api/v3/detailsview/MediaDetails/5?lang=en-GB&_dc=1575995773759 t Transfer: 1220 : 56|16:36:44.7577||GetCurrentUser.. t Transfer: 1220 : 56|16:36:44.7577|| OAuth authenticated t Transfer: 1220 : 56|16:36:44.7577|| user TONY. t Transfer: 1220 : 56|16:36:44.7577||api user: TONY t Transfer: 1220 : 56|16:36:44.7733||IsUserAuthenticated: /api/media-captions/298524?_dc=1575995773765 t Transfer: 1220 : 56|16:36:44.7733||GetCurrentUser.. t Transfer: 1220 : 56|16:36:44.7733|| OAuth authenticated t Transfer: 1220 : 56|16:36:44.7733|| user TONY. t Transfer: 1220 : 56|16:36:44.7733||api user: TONY t Transfer: 1220 : 44|16:36:44.7733||IsUserAuthenticated: /api/mediavideo/298524?info=smudge&_dc=1575995773772 t Transfer: 1220 : 44|16:36:44.7733||GetCurrentUser.. t Transfer: 1220 : 44|16:36:44.7733|| OAuth authenticated t Transfer: 1220 : 44|16:36:44.7733|| user TONY. t Transfer: 1220 : 44|16:36:44.7733||api user: TONY t Verbose: 1220 : 44|16:36:44.7889||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\England v Bangladesh Match Group A.mp4 subfolder t Verbose: 1220 : 44|16:36:44.7889|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/England v Bangladesh Match Group A.mp4 t Verbose: 1220 : 44|16:36:44.7889||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/England v Bangladesh Match Group A.mp4 t Transfer: 1220 : 44|16:36:44.7889||GetCurrentUser.. t Transfer: 1220 : 44|16:36:44.7889|| OAuth authenticated t Transfer: 1220 : 44|16:36:44.7889|| user TONY. t Transfer: 1220 : 42|16:36:45.2108||IsUserAuthenticated: /api/search/Media?_dc=1575995774574 t Transfer: 1220 : 42|16:36:45.2108||GetCurrentUser.. t Transfer: 1220 : 42|16:36:45.2108|| OAuth authenticated t Transfer: 1220 : 42|16:36:45.2108|| user TONY. t Transfer: 1220 : 42|16:36:45.2108||api user: TONY t Information: 1220 : 42|16:36:45.2108||V3Api.SearchMedia t Information: 1220 : 42|16:36:45.2108||V3Api.SearchGeneric t Transfer: 1220 : 42|16:36:45.2108||GetCurrentUser.. t Transfer: 1220 : 42|16:36:45.2108|| OAuth authenticated t Transfer: 1220 : 42|16:36:45.2108|| user TONY. t Information: 1220 : 42|16:36:45.2108||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 where media_type>0 and item_type>0 AND m.ID=298524 and m.mi_deleted=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 : 42|16:36:45.2264|| timing: 00:00:00.0121646 t Verbose: 1220 : 42|16:36:45.2264||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\England v Bangladesh Match Group A.mp4 subfolder t Verbose: 1220 : 42|16:36:45.2264|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/England v Bangladesh Match Group A.mp4 t Verbose: 1220 : 42|16:36:45.2264||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/England v Bangladesh Match Group A.mp4 t Transfer: 1220 : 42|16:36:45.2264||GetCurrentUser.. t Transfer: 1220 : 42|16:36:45.2264|| OAuth authenticated t Transfer: 1220 : 42|16:36:45.2264|| user TONY. t Transfer: 1220 : 44|16:36:49.0077||IsUserAuthenticated: /api/title-details/298401?_dc=1575995778385 t Transfer: 1220 : 44|16:36:49.0077||GetCurrentUser.. t Transfer: 1220 : 44|16:36:49.0077|| OAuth authenticated t Transfer: 1220 : 44|16:36:49.0077|| user TONY. t Transfer: 1220 : 44|16:36:49.0077||api user: TONY t Transfer: 1220 : 56|16:36:56.9139||IsUserAuthenticated: /api/search/title?_dc=1575995786283 t Transfer: 1220 : 56|16:36:56.9139||GetCurrentUser.. t Transfer: 1220 : 56|16:36:56.9139|| OAuth authenticated t Transfer: 1220 : 56|16:36:56.9139|| user TONY. t Transfer: 1220 : 56|16:36:56.9139||api user: TONY t Information: 1220 : 56|16:36:56.9139||V3Api.SearchTitles t Information: 1220 : 56|16:36:56.9139||V3Api.SearchGeneric t Transfer: 1220 : 56|16:36:56.9139||GetCurrentUser.. t Transfer: 1220 : 56|16:36:56.9139|| OAuth authenticated t Transfer: 1220 : 56|16:36:56.9139|| user TONY. t Transfer: 1220 : 56|16:36:56.9139||GetCurrentUser.. t Transfer: 1220 : 56|16:36:56.9139|| OAuth authenticated t Transfer: 1220 : 56|16:36:56.9139|| user TONY. t Information: 1220 : 56|16:36:56.9139||SearchTitle SQL: with v as ( SELECT abs.* ,decode(ITEM_TYPE, 1010,SER_ABS_ID, 1020,CASE WHEN SER_ABS2_ID > 0 THEN SER_ABS2_ID ELSE SER_ABS_ID END ) xparent_id FROM TMDDBA.TM_PG_ABS abs WHERE abs.id in ( select a.id FROM TMDDBA.TM_PG_ABS a where ABS_DELETED = 0 AND Upper(a.ID) = Upper('298401') AND ROWNUM < 25000 ) ) ,v_missing_parent_ids as ( select xparent_id from v minus select id from v ) ,v_missing_parents as ( SELECT distinct a.* ,decode(ITEM_TYPE, 1010,SER_ABS_ID, 1020,CASE WHEN SER_ABS2_ID > 0 THEN SER_ABS2_ID ELSE SER_ABS_ID END ) xparent_id FROM TMDDBA.TM_PG_ABS a START WITH ID IN (select xparent_id from v_missing_parent_ids) CONNECT BY CASE PRIOR ITEM_TYPE WHEN 1010 THEN PRIOR SER_ABS_ID WHEN 1020 THEN CASE WHEN NVL(PRIOR SER_ABS2_ID, 0) > 0 THEN PRIOR SER_ABS2_ID ELSE PRIOR SER_ABS_ID END END = ID ) ,v_all as ( select x.*, count(*) over() RowCount from ( select * from v_missing_parents union select * from v ) x ) ,v_top as ( select id from (select id, row_number()over(order by upper(ser_title),upper(title),ser_num,ser_ep_num, SER_EP_SQ_NUM ) rnk -- sort roots from v_all where xparent_id is null) where rnk between (:page_number-1)*50+1 and :page_number*50 ) ,v_tree as ( select level lvl, a.* from v_all a start with id in (select id from v_top) connect by xparent_id = prior ID order siblings by upper(ser_title),ser_num,ser_ep_num, SER_EP_SQ_NUM,upper(title) -- sort children ) select * from v_tree --where rnk <= 50 t Transfer: 1220 : 42|16:36:57.1014||IsUserAuthenticated: /api/search/title?_dc=1575995786467 t Transfer: 1220 : 42|16:36:57.1014||GetCurrentUser.. t Transfer: 1220 : 42|16:36:57.1014|| OAuth authenticated t Transfer: 1220 : 42|16:36:57.1014|| user TONY. t Transfer: 1220 : 42|16:36:57.1014||api user: TONY t Information: 1220 : 42|16:36:57.1014||V3Api.SearchTitles t Information: 1220 : 42|16:36:57.1014||V3Api.SearchGeneric t Transfer: 1220 : 42|16:36:57.1014||GetCurrentUser.. t Transfer: 1220 : 42|16:36:57.1014|| OAuth authenticated t Transfer: 1220 : 42|16:36:57.1014|| user TONY. t Transfer: 1220 : 42|16:36:57.1014||GetCurrentUser.. t Transfer: 1220 : 42|16:36:57.1014|| OAuth authenticated t Transfer: 1220 : 42|16:36:57.1014|| user TONY. t Information: 1220 : 42|16:36:57.1014||SearchTitle SQL: with v as ( SELECT abs.* ,decode(ITEM_TYPE, 1010,SER_ABS_ID, 1020,CASE WHEN SER_ABS2_ID > 0 THEN SER_ABS2_ID ELSE SER_ABS_ID END ) xparent_id FROM TMDDBA.TM_PG_ABS abs WHERE abs.id in ( select a.id FROM TMDDBA.TM_PG_ABS a where ABS_DELETED = 0 AND Upper(a.ID) = Upper('298401') AND ROWNUM < 25000 ) ) ,v_missing_parent_ids as ( select xparent_id from v minus select id from v ) ,v_missing_parents as ( SELECT distinct a.* ,decode(ITEM_TYPE, 1010,SER_ABS_ID, 1020,CASE WHEN SER_ABS2_ID > 0 THEN SER_ABS2_ID ELSE SER_ABS_ID END ) xparent_id FROM TMDDBA.TM_PG_ABS a START WITH ID IN (select xparent_id from v_missing_parent_ids) CONNECT BY CASE PRIOR ITEM_TYPE WHEN 1010 THEN PRIOR SER_ABS_ID WHEN 1020 THEN CASE WHEN NVL(PRIOR SER_ABS2_ID, 0) > 0 THEN PRIOR SER_ABS2_ID ELSE PRIOR SER_ABS_ID END END = ID ) ,v_all as ( select x.*, count(*) over() RowCount from ( select * from v_missing_parents union select * from v ) x ) ,v_top as ( select id from (select id, row_number()over(order by upper(ser_title),upper(title),ser_num,ser_ep_num, SER_EP_SQ_NUM ) rnk -- sort roots from v_all where xparent_id is null) where rnk between (:page_number-1)*50+1 and :page_number*50 ) ,v_tree as ( select level lvl, a.* from v_all a start with id in (select id from v_top) connect by xparent_id = prior ID order siblings by upper(ser_title),ser_num,ser_ep_num, SER_EP_SQ_NUM,upper(title) -- sort children ) select * from v_tree --where rnk <= 50 t Transfer: 1220 : 55|16:37:02.1795||IsUserAuthenticated: /api/user-group-preferences?globals=htmlplayerhotkeys,audioOnFrameForward&_dc=1575995791546 t Transfer: 1220 : 55|16:37:02.1795||GetCurrentUser.. t Transfer: 1220 : 55|16:37:02.1795|| OAuth authenticated t Transfer: 1220 : 55|16:37:02.1795|| user TONY. t Transfer: 1220 : 55|16:37:02.1795||api user: TONY t Information: 1220 : 55|16:37:02.1795||V3Api.GetUserSettings t Transfer: 1220 : 55|16:37:02.1795||GetCurrentUser.. t Transfer: 1220 : 55|16:37:02.1795|| OAuth authenticated t Transfer: 1220 : 55|16:37:02.1795|| user TONY. t Transfer: 1220 : 44|16:37:03.6327||IsUserAuthenticated: /api/media-captions/298503?_dc=1575995793008 t Transfer: 1220 : 44|16:37:03.6327||GetCurrentUser.. t Transfer: 1220 : 44|16:37:03.6327|| OAuth authenticated t Transfer: 1220 : 44|16:37:03.6327|| user TONY. t Transfer: 1220 : 44|16:37:03.6327||api user: TONY t Transfer: 1220 : 35|16:37:03.6639||IsUserAuthenticated: /api/mediavideo/298503?info=smudge&_dc=1575995793029 t Transfer: 1220 : 35|16:37:03.6639||GetCurrentUser.. t Transfer: 1220 : 35|16:37:03.6639|| OAuth authenticated t Transfer: 1220 : 35|16:37:03.6639|| user TONY. t Transfer: 1220 : 35|16:37:03.6639||api user: TONY t Verbose: 1220 : 35|16:37:03.6639||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\ICC 360 Cricket for Change.mp4 subfolder t Verbose: 1220 : 35|16:37:03.6639|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/ICC 360 Cricket for Change.mp4 t Verbose: 1220 : 35|16:37:03.6639||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/ICC 360 Cricket for Change.mp4 t Transfer: 1220 : 35|16:37:03.6639||GetCurrentUser.. t Transfer: 1220 : 35|16:37:03.6639|| OAuth authenticated t Transfer: 1220 : 35|16:37:03.6639|| user TONY. t Transfer: 1220 : 51|16:37:04.0233||IsUserAuthenticated: /api/search/Media?_dc=1575995793004 t Transfer: 1220 : 51|16:37:04.0233||GetCurrentUser.. t Transfer: 1220 : 51|16:37:04.0233|| OAuth authenticated t Transfer: 1220 : 51|16:37:04.0233|| user TONY. t Transfer: 1220 : 51|16:37:04.0233||api user: TONY t Information: 1220 : 51|16:37:04.0233||V3Api.SearchMedia t Information: 1220 : 51|16:37:04.0233||V3Api.SearchGeneric t Transfer: 1220 : 51|16:37:04.0233||GetCurrentUser.. t Transfer: 1220 : 51|16:37:04.0233|| OAuth authenticated t Transfer: 1220 : 51|16:37:04.0233|| user TONY. t Information: 1220 : 51|16:37:04.0233||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 where media_type>0 and item_type>0 AND m.ID=298503 and m.mi_deleted=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 : 51|16:37:04.1014|| timing: 00:00:00.0770879 t Verbose: 1220 : 51|16:37:04.1014||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\ICC 360 Cricket for Change.mp4 subfolder t Verbose: 1220 : 51|16:37:04.1014|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/ICC 360 Cricket for Change.mp4 t Verbose: 1220 : 51|16:37:04.1014||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/ICC 360 Cricket for Change.mp4 t Transfer: 1220 : 51|16:37:04.1014||GetCurrentUser.. t Transfer: 1220 : 51|16:37:04.1014|| OAuth authenticated t Transfer: 1220 : 51|16:37:04.1014|| user TONY. t Information: 1220 : 35|16:37:04.2108||V3Api.GetMediaTagging t Transfer: 1220 : 44|16:37:04.7264||IsUserAuthenticated: /api/title-details/298387?_dc=1575995794107 t Transfer: 1220 : 44|16:37:04.7420||GetCurrentUser.. t Transfer: 1220 : 44|16:37:04.7420|| OAuth authenticated t Transfer: 1220 : 44|16:37:04.7420|| user TONY. t Transfer: 1220 : 44|16:37:04.7420||api user: TONY t Transfer: 1220 : 55|16:37:13.8827||IsUserAuthenticated: /api/search/title?_dc=1575995803259 t Transfer: 1220 : 55|16:37:13.8827||GetCurrentUser.. t Transfer: 1220 : 55|16:37:13.8827|| OAuth authenticated t Transfer: 1220 : 55|16:37:13.8827|| user TONY. t Transfer: 1220 : 55|16:37:13.8827||api user: TONY t Information: 1220 : 55|16:37:13.8827||V3Api.SearchTitles t Information: 1220 : 55|16:37:13.8827||V3Api.SearchGeneric t Transfer: 1220 : 55|16:37:13.8827||GetCurrentUser.. t Transfer: 1220 : 55|16:37:13.8827|| OAuth authenticated t Transfer: 1220 : 55|16:37:13.8827|| user TONY. t Transfer: 1220 : 55|16:37:13.8827||GetCurrentUser.. t Transfer: 1220 : 55|16:37:13.8827|| OAuth authenticated t Transfer: 1220 : 55|16:37:13.8827|| user TONY. t Information: 1220 : 55|16:37:13.8983||SearchTitle SQL: with v as ( SELECT abs.* ,decode(ITEM_TYPE, 1010,SER_ABS_ID, 1020,CASE WHEN SER_ABS2_ID > 0 THEN SER_ABS2_ID ELSE SER_ABS_ID END ) xparent_id FROM TMDDBA.TM_PG_ABS abs WHERE abs.id in ( select a.id FROM TMDDBA.TM_PG_ABS a where ABS_DELETED = 0 AND Upper(a.ID) = Upper('298387') AND ROWNUM < 25000 ) ) ,v_missing_parent_ids as ( select xparent_id from v minus select id from v ) ,v_missing_parents as ( SELECT distinct a.* ,decode(ITEM_TYPE, 1010,SER_ABS_ID, 1020,CASE WHEN SER_ABS2_ID > 0 THEN SER_ABS2_ID ELSE SER_ABS_ID END ) xparent_id FROM TMDDBA.TM_PG_ABS a START WITH ID IN (select xparent_id from v_missing_parent_ids) CONNECT BY CASE PRIOR ITEM_TYPE WHEN 1010 THEN PRIOR SER_ABS_ID WHEN 1020 THEN CASE WHEN NVL(PRIOR SER_ABS2_ID, 0) > 0 THEN PRIOR SER_ABS2_ID ELSE PRIOR SER_ABS_ID END END = ID ) ,v_all as ( select x.*, count(*) over() RowCount from ( select * from v_missing_parents union select * from v ) x ) ,v_top as ( select id from (select id, row_number()over(order by upper(ser_title),upper(title),ser_num,ser_ep_num, SER_EP_SQ_NUM ) rnk -- sort roots from v_all where xparent_id is null) where rnk between (:page_number-1)*50+1 and :page_number*50 ) ,v_tree as ( select level lvl, a.* from v_all a start with id in (select id from v_top) connect by xparent_id = prior ID order siblings by upper(ser_title),ser_num,ser_ep_num, SER_EP_SQ_NUM,upper(title) -- sort children ) select * from v_tree --where rnk <= 50 t Transfer: 1220 : 42|16:37:14.0702||IsUserAuthenticated: /api/search/title?_dc=1575995803422 t Transfer: 1220 : 42|16:37:14.0702||GetCurrentUser.. t Transfer: 1220 : 42|16:37:14.0702|| OAuth authenticated t Transfer: 1220 : 42|16:37:14.0702|| user TONY. t Transfer: 1220 : 42|16:37:14.0702||api user: TONY t Information: 1220 : 42|16:37:14.0702||V3Api.SearchTitles t Information: 1220 : 42|16:37:14.0702||V3Api.SearchGeneric t Transfer: 1220 : 42|16:37:14.0702||GetCurrentUser.. t Transfer: 1220 : 42|16:37:14.0702|| OAuth authenticated t Transfer: 1220 : 42|16:37:14.0702|| user TONY. t Transfer: 1220 : 42|16:37:14.0702||GetCurrentUser.. t Transfer: 1220 : 42|16:37:14.0702|| OAuth authenticated t Transfer: 1220 : 42|16:37:14.0702|| user TONY. t Information: 1220 : 42|16:37:14.0702||SearchTitle SQL: with v as ( SELECT abs.* ,decode(ITEM_TYPE, 1010,SER_ABS_ID, 1020,CASE WHEN SER_ABS2_ID > 0 THEN SER_ABS2_ID ELSE SER_ABS_ID END ) xparent_id FROM TMDDBA.TM_PG_ABS abs WHERE abs.id in ( select a.id FROM TMDDBA.TM_PG_ABS a where ABS_DELETED = 0 AND Upper(a.ID) = Upper('298387') AND ROWNUM < 25000 ) ) ,v_missing_parent_ids as ( select xparent_id from v minus select id from v ) ,v_missing_parents as ( SELECT distinct a.* ,decode(ITEM_TYPE, 1010,SER_ABS_ID, 1020,CASE WHEN SER_ABS2_ID > 0 THEN SER_ABS2_ID ELSE SER_ABS_ID END ) xparent_id FROM TMDDBA.TM_PG_ABS a START WITH ID IN (select xparent_id from v_missing_parent_ids) CONNECT BY CASE PRIOR ITEM_TYPE WHEN 1010 THEN PRIOR SER_ABS_ID WHEN 1020 THEN CASE WHEN NVL(PRIOR SER_ABS2_ID, 0) > 0 THEN PRIOR SER_ABS2_ID ELSE PRIOR SER_ABS_ID END END = ID ) ,v_all as ( select x.*, count(*) over() RowCount from ( select * from v_missing_parents union select * from v ) x ) ,v_top as ( select id from (select id, row_number()over(order by upper(ser_title),upper(title),ser_num,ser_ep_num, SER_EP_SQ_NUM ) rnk -- sort roots from v_all where xparent_id is null) where rnk between (:page_number-1)*50+1 and :page_number*50 ) ,v_tree as ( select level lvl, a.* from v_all a start with id in (select id from v_top) connect by xparent_id = prior ID order siblings by upper(ser_title),ser_num,ser_ep_num, SER_EP_SQ_NUM,upper(title) -- sort children ) select * from v_tree --where rnk <= 50 t Information: 1220 : 35|16:37:34.1014||GetAppInfo t Information: 1220 : 35|16:37:34.1014|| db: TMDDEMO install mode: auth types: Native, PublicApiKey t Information: 1220 : 53|16:37:47.7264||Oauth validating.. t Verbose: 1220 : 53|16:37:47.7264||GrantResourceOwnerCredentials. t Verbose: 1220 : 53|16:37:47.7264||LoginUser. tmddba, login type OAuth, encrypt password True t Information: 1220 : 53|16:37:47.7264||TryLoginUser. tmddba, login type OAuth, check password True, check hash False, encrypt password True, load user data True t Information: 1220 : 53|16:37:47.7420||InitialiseLogin t Information: 1220 : 53|16:37:47.7420|| oauth token 00000000-0000-0000-0000-000000000000 t Information: 1220 : 53|16:37:47.7420||TryLoginUser. Logged in.. t Verbose: 1220 : 53|16:37:47.7420||LoginUser. Adding history. User Id 1, result TMDDBA, host t Verbose: 1220 : 53|16:37:47.7577||GrantResourceOwnerCredentials. Try login finished. Logged: True t Transfer: 1220 : 42|16:37:48.0545||IsUserAuthenticated: /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,logoImage&globals=isDebugMode,htmlplayerhotkeys,versionCreationSettings,associate.advanced_search.version.setups,associate.advanced_search.media.setups,associate.wfrise.setups,supplier_portal.advanced_search.version.setups&_dc=1575995837424 t Transfer: 1220 : 42|16:37:48.0545||GetCurrentUser.. t Transfer: 1220 : 42|16:37:48.0545|| OAuth authenticated t Transfer: 1220 : 42|16:37:48.0545|| user TMDDBA. t Transfer: 1220 : 42|16:37:48.0545||api user: TMDDBA t Information: 1220 : 42|16:37:48.0545||V3Api.GetUserSettings t Transfer: 1220 : 42|16:37:48.0545||GetCurrentUser.. t Transfer: 1220 : 42|16:37:48.0545|| OAuth authenticated t Transfer: 1220 : 42|16:37:48.0545|| user TMDDBA. t Transfer: 1220 : 48|16:37:48.3827||IsUserAuthenticated: /api/user-preferences?keys=personal_settings;basket;default_page;color_schema;media.basket.data;defaultSearch&_dc=1575995837725 t Transfer: 1220 : 48|16:37:48.3827||GetCurrentUser.. t Transfer: 1220 : 48|16:37:48.3827|| OAuth authenticated t Transfer: 1220 : 48|16:37:48.3827|| user TMDDBA. t Transfer: 1220 : 48|16:37:48.3827||api user: TMDDBA t Information: 1220 : 48|16:37:48.3827||GetUserDataByKeys: personal_settings;basket;default_page;color_schema;media.basket.data;defaultSearch t Transfer: 1220 : 48|16:37:48.3827||GetCurrentUser.. t Transfer: 1220 : 48|16:37:48.3827|| OAuth authenticated t Transfer: 1220 : 48|16:37:48.3827|| user TMDDBA. t Information: 1220 : 56|16:37:48.7264||GetUserProfile. Id: 0 t Transfer: 1220 : 56|16:37:48.7264||GetCurrentUser.. t Transfer: 1220 : 56|16:37:48.7264|| OAuth authenticated t Transfer: 1220 : 56|16:37:48.7264|| user TMDDBA. t Transfer: 1220 : 53|16:37:48.8045||IsUserAuthenticated: /api/lookups/MediaStatus?_dc=1575995837726 t Transfer: 1220 : 53|16:37:48.8045||GetCurrentUser.. t Transfer: 1220 : 53|16:37:48.8045|| OAuth authenticated t Transfer: 1220 : 53|16:37:48.8045|| user TMDDBA. t Transfer: 1220 : 53|16:37:48.8045||api user: TMDDBA t Transfer: 1220 : 55|16:37:48.8671||IsUserAuthenticated: /api/lookups/PgmStatus?_dc=1575995837727 t Transfer: 1220 : 55|16:37:48.8671||GetCurrentUser.. t Transfer: 1220 : 55|16:37:48.8671|| OAuth authenticated t Transfer: 1220 : 55|16:37:48.8671|| user TMDDBA. t Transfer: 1220 : 55|16:37:48.8671||api user: TMDDBA t Transfer: 1220 : 35|16:37:50.5702||IsUserAuthenticated: /api/settings/group/0?_dc=1575995839945 t Transfer: 1220 : 35|16:37:50.5702||GetCurrentUser.. t Transfer: 1220 : 35|16:37:50.5702|| OAuth authenticated t Transfer: 1220 : 35|16:37:50.5702|| user TMDDBA. t Transfer: 1220 : 35|16:37:50.5702||api user: TMDDBA t Information: 1220 : 35|16:37:50.5702||V3Api.GetSettingsGroup t Transfer: 1220 : 35|16:37:50.8358||IsUserAuthenticated: /api/view/searches/Job?_dc=1575995840213 t Transfer: 1220 : 35|16:37:50.8358||GetCurrentUser.. t Transfer: 1220 : 35|16:37:50.8358|| OAuth authenticated t Transfer: 1220 : 35|16:37:50.8358|| user TMDDBA. t Transfer: 1220 : 35|16:37:50.8358||api user: TMDDBA t Information: 1220 : 35|16:37:50.8358||GetSavedSearchNames. search type Job. t Transfer: 1220 : 35|16:37:50.8358||GetCurrentUser.. t Transfer: 1220 : 35|16:37:50.8358|| OAuth authenticated t Transfer: 1220 : 35|16:37:50.8358|| user TMDDBA. t Transfer: 1220 : 51|16:37:54.1171||IsUserAuthenticated: /api/v3/layout/default/3?_dc=1575995843482 t Transfer: 1220 : 51|16:37:54.1171||GetCurrentUser.. t Transfer: 1220 : 51|16:37:54.1171|| OAuth authenticated t Transfer: 1220 : 51|16:37:54.1171|| user TMDDBA. t Transfer: 1220 : 51|16:37:54.1171||api user: TMDDBA t Information: 1220 : 51|16:37:54.1171||LoadDefaultDashboard. t Transfer: 1220 : 51|16:37:54.1171||GetCurrentUser.. t Transfer: 1220 : 51|16:37:54.1171|| OAuth authenticated t Transfer: 1220 : 51|16:37:54.1171|| user TMDDBA. t Transfer: 1220 : 51|16:37:54.1639||GetCurrentUser.. t Transfer: 1220 : 51|16:37:54.1639|| OAuth authenticated t Transfer: 1220 : 51|16:37:54.1639|| user TMDDBA. t Transfer: 1220 : 42|16:37:57.5233||IsUserAuthenticated: /api/settings/user/searchLayoutConfig?_dc=1575995846884 t Transfer: 1220 : 42|16:37:57.5233||GetCurrentUser.. t Transfer: 1220 : 42|16:37:57.5233|| OAuth authenticated t Transfer: 1220 : 42|16:37:57.5233|| user TMDDBA. t Transfer: 1220 : 42|16:37:57.5233||api user: TMDDBA t Information: 1220 : 42|16:37:57.5233||V3Api.GetUserSettings t Transfer: 1220 : 42|16:37:57.5233||GetCurrentUser.. t Transfer: 1220 : 42|16:37:57.5233|| OAuth authenticated t Transfer: 1220 : 42|16:37:57.5233|| user TMDDBA. t Transfer: 1220 : 51|16:37:57.5233||IsUserAuthenticated: /api/view/searchinfo/Media?_dc=1575995846875 t Transfer: 1220 : 51|16:37:57.5233||GetCurrentUser.. t Transfer: 1220 : 51|16:37:57.5233|| OAuth authenticated t Transfer: 1220 : 51|16:37:57.5233|| user TMDDBA. t Transfer: 1220 : 51|16:37:57.5233||api user: TMDDBA t Information: 1220 : 51|16:37:57.5233||GetAdvSearchColumns. search type Media grid . t Transfer: 1220 : 35|16:37:57.5233||IsUserAuthenticated: /api/lookups/SearchSupportedOperators?_dc=1575995846877 t Transfer: 1220 : 35|16:37:57.5233||GetCurrentUser.. t Transfer: 1220 : 35|16:37:57.5233|| OAuth authenticated t Transfer: 1220 : 35|16:37:57.5233|| user TMDDBA. t Transfer: 1220 : 35|16:37:57.5233||api user: TMDDBA t Transfer: 1220 : 51|16:37:57.5389||IsUserAuthenticated: /api/view/searches/Media?_dc=1575995846908 t Transfer: 1220 : 51|16:37:57.5389||GetCurrentUser.. t Transfer: 1220 : 51|16:37:57.5389|| OAuth authenticated t Transfer: 1220 : 51|16:37:57.5389|| user TMDDBA. t Transfer: 1220 : 51|16:37:57.5389||api user: TMDDBA t Information: 1220 : 51|16:37:57.5389||GetSavedSearchNames. search type Media. t Transfer: 1220 : 51|16:37:57.5389||GetCurrentUser.. t Transfer: 1220 : 51|16:37:57.5389|| OAuth authenticated t Transfer: 1220 : 51|16:37:57.5389|| user TMDDBA. t Transfer: 1220 : 44|16:37:57.5389||IsUserAuthenticated: /api/user-preferences?keys=adv.recent.searches.media&_dc=1575995846879 t Transfer: 1220 : 44|16:37:57.5389||GetCurrentUser.. t Transfer: 1220 : 44|16:37:57.5389|| OAuth authenticated t Transfer: 1220 : 44|16:37:57.5389|| user TMDDBA. t Transfer: 1220 : 44|16:37:57.5389||api user: TMDDBA t Information: 1220 : 44|16:37:57.5389||GetUserDataByKeys: adv.recent.searches.media t Transfer: 1220 : 44|16:37:57.5389||GetCurrentUser.. t Transfer: 1220 : 44|16:37:57.5389|| OAuth authenticated t Transfer: 1220 : 44|16:37:57.5389|| user TMDDBA. t Transfer: 1220 : 35|16:37:57.5389||IsUserAuthenticated: /api/view/info/MediaGrid?lang=en-GB&_dc=1575995846893 t Transfer: 1220 : 35|16:37:57.5389||GetCurrentUser.. t Transfer: 1220 : 35|16:37:57.5389|| OAuth authenticated t Transfer: 1220 : 35|16:37:57.5389|| user TMDDBA. t Transfer: 1220 : 35|16:37:57.5389||api user: TMDDBA t Information: 1220 : 35|16:37:57.5389||GetGridViewBuilder. builder type MediaGrid. t Transfer: 1220 : 35|16:37:57.5389||GetCurrentUser.. t Transfer: 1220 : 35|16:37:57.5389|| OAuth authenticated t Transfer: 1220 : 35|16:37:57.5389|| user TMDDBA. t Information: 1220 : 35|16:37:57.6170||UserGridView. LoadView. ID 311, Name Default. t Transfer: 1220 : 35|16:37:57.6170||GetCurrentUser.. t Transfer: 1220 : 35|16:37:57.6170|| OAuth authenticated t Transfer: 1220 : 35|16:37:57.6170|| user TMDDBA. t Transfer: 1220 : 35|16:37:57.6170||GetCurrentUser.. t Transfer: 1220 : 35|16:37:57.6170|| OAuth authenticated t Transfer: 1220 : 35|16:37:57.6170|| user TMDDBA. t Transfer: 1220 : 56|16:38:00.0858||IsUserAuthenticated: /api/SearchSuggestion/?_dc=1575995849419 t Transfer: 1220 : 56|16:38:00.0858||GetCurrentUser.. t Transfer: 1220 : 56|16:38:00.0858|| OAuth authenticated t Transfer: 1220 : 56|16:38:00.0858|| user TMDDBA. t Transfer: 1220 : 56|16:38:00.0858||api user: TMDDBA t Transfer: 1220 : 56|16:38:00.0858||GetCurrentUser.. t Transfer: 1220 : 56|16:38:00.0858|| OAuth authenticated t Transfer: 1220 : 56|16:38:00.0858|| user TMDDBA. t Transfer: 1220 : 55|16:38:00.4295||IsUserAuthenticated: /api/search/Media?_dc=1575995849809 t Transfer: 1220 : 55|16:38:00.4295||GetCurrentUser.. t Transfer: 1220 : 55|16:38:00.4295|| OAuth authenticated t Transfer: 1220 : 55|16:38:00.4295|| user TMDDBA. t Transfer: 1220 : 55|16:38:00.4295||api user: TMDDBA t Information: 1220 : 55|16:38:00.4452||V3Api.SearchMedia t Information: 1220 : 55|16:38:00.4452||V3Api.SearchGeneric t Transfer: 1220 : 55|16:38:00.4452||GetCurrentUser.. t Transfer: 1220 : 55|16:38:00.4452|| OAuth authenticated t Transfer: 1220 : 55|16:38:00.4452|| user TMDDBA. t Information: 1220 : 55|16:38:00.4608||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 min(status.description) from TM_CFG_PGM_STATUS status where r.status = status.id) PGM_STATUS_TEXT, GETMEDIALOC(r.id, r.media_type, r.compil, r.m_ctnr_int_o_loc, r.m_ctnr_ext_o_loc, r.m_ctnr_loc) LOCATION, nvl(dfl.fSOM,0) FILE_SOM, nvl(dfl.fEOM,0) FILE_EOM, dfl.fos_fname FILENAME, dfl.DFILE_LINK_GUID, dfl.OS_GUID, dfl.SUB_FOLDER, dfl.ORIGINAL_FILENAME from (select a.*, rownum rnum from (select m.*, coalesce(m.primary_thumb_id, (select v.primary_thumb_id from tm_pg_rl v where v.id=m.pgm_parent_id)) primary_thumb_id2 from tmddba.tm_mis m ,(select /*+ cardinality(4) */ rownum rn, column_value id from table(:ids)) ids where media_type>0 and item_type>0 and m.id = ids.id order by ids.rn ) a where rownum <= 10000) r ,lateral( select l.miid, max(c.C_EXT_OUT_LOC) lib_loc_ext_id, max(c.C_STAT) ctnr_stat, max(c.loan_stat) ctnr_loan_stat from tm_mi_tpi_lnx l, tm_ctnrs c where c.u_id=l.tpiid and l.miid=r.id and r.media_type=1 group by l.miid)(+) lnk ,lateral(select tt.* from tm_text tt where tt.text_id = r.primary_thumb_id2)(+) t ,lateral(select /*+ NO_DECORRELATE */ d.som fsom, d.eom feom, dl.mi_id fmi_id, d.os_fname fos_fname, d.DFILE_LINK_GUID, d.OS_GUID, d.SUB_FOLDER, dl.dfile_id, d.original_filename FROM tm_dfile d, tm_mi_dfile_lnx dl where d.id=dl.dfile_id and r.id=dl.mi_id and rownum=1)(+) dfl where rnum >= 1 order by rnum t Information: 1220 : 55|16:38:00.5545|| timing: 00:00:00.1126848 t Verbose: 1220 : 55|16:38:00.5545||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\England v Bangladesh Match Group A.mp4 subfolder t Verbose: 1220 : 55|16:38:00.5545|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/England v Bangladesh Match Group A.mp4 t Verbose: 1220 : 55|16:38:00.5545||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/England v Bangladesh Match Group A.mp4 t Transfer: 1220 : 55|16:38:00.5545||GetCurrentUser.. t Transfer: 1220 : 55|16:38:00.5545|| OAuth authenticated t Transfer: 1220 : 55|16:38:00.5545|| user TMDDBA. t Verbose: 1220 : 55|16:38:00.5545||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\ICC 360 Cricket for Change.mp4 subfolder t Verbose: 1220 : 55|16:38:00.5545|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/ICC 360 Cricket for Change.mp4 t Verbose: 1220 : 55|16:38:00.5545||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/ICC 360 Cricket for Change.mp4 t Transfer: 1220 : 55|16:38:00.5545||GetCurrentUser.. t Transfer: 1220 : 55|16:38:00.5545|| OAuth authenticated t Transfer: 1220 : 55|16:38:00.5545|| user TMDDBA. t Verbose: 1220 : 55|16:38:00.5545||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Australia vs South Africa Match 45.mp4 subfolder t Verbose: 1220 : 55|16:38:00.5545|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Australia vs South Africa Match 45.mp4 t Verbose: 1220 : 55|16:38:00.5545||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/Australia vs South Africa Match 45.mp4 t Transfer: 1220 : 55|16:38:00.5545||GetCurrentUser.. t Transfer: 1220 : 55|16:38:00.5545|| OAuth authenticated t Transfer: 1220 : 55|16:38:00.5545|| user TMDDBA. t Verbose: 1220 : 55|16:38:00.5545||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\England vs South Africa Match 1.mp4 subfolder t Verbose: 1220 : 55|16:38:00.5545|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/England vs South Africa Match 1.mp4 t Verbose: 1220 : 55|16:38:00.5545||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/England vs South Africa Match 1.mp4 t Transfer: 1220 : 55|16:38:00.5545||GetCurrentUser.. t Transfer: 1220 : 55|16:38:00.5545|| OAuth authenticated t Transfer: 1220 : 55|16:38:00.5545|| user TMDDBA. t Verbose: 1220 : 55|16:38:00.5545||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\West Indies vs Pakistan Match 2.mp4 subfolder t Verbose: 1220 : 55|16:38:00.5545|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/West Indies vs Pakistan Match 2.mp4 t Verbose: 1220 : 55|16:38:00.5545||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/West Indies vs Pakistan Match 2.mp4 t Transfer: 1220 : 55|16:38:00.5545||GetCurrentUser.. t Transfer: 1220 : 55|16:38:00.5545|| OAuth authenticated t Transfer: 1220 : 55|16:38:00.5545|| user TMDDBA. t Verbose: 1220 : 55|16:38:00.5545||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\New Zealand vs England Final.mp4 subfolder t Verbose: 1220 : 55|16:38:00.5545|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/New Zealand vs England Final.mp4 t Verbose: 1220 : 55|16:38:00.5545||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/New Zealand vs England Final.mp4 t Transfer: 1220 : 55|16:38:00.5545||GetCurrentUser.. t Transfer: 1220 : 55|16:38:00.5702|| OAuth authenticated t Transfer: 1220 : 55|16:38:00.5702|| user TMDDBA. t Verbose: 1220 : 55|16:38:00.5702||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Australia vs England Short Semi Final 2.mp4 subfolder t Verbose: 1220 : 55|16:38:00.5702|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Australia vs England Short Semi Final 2.mp4 t Verbose: 1220 : 55|16:38:00.5702||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/Australia vs England Short Semi Final 2.mp4 t Transfer: 1220 : 55|16:38:00.5702||GetCurrentUser.. t Transfer: 1220 : 55|16:38:00.5702|| OAuth authenticated t Transfer: 1220 : 55|16:38:00.5702|| user TMDDBA. t Verbose: 1220 : 55|16:38:00.5702||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\India vs New Zealand Semi Final 1.mp4 subfolder t Verbose: 1220 : 55|16:38:00.5702|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/India vs New Zealand Semi Final 1.mp4 t Verbose: 1220 : 55|16:38:00.5702||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/India vs New Zealand Semi Final 1.mp4 t Transfer: 1220 : 55|16:38:00.5702||GetCurrentUser.. t Transfer: 1220 : 55|16:38:00.5702|| OAuth authenticated t Transfer: 1220 : 55|16:38:00.5702|| user TMDDBA. t Verbose: 1220 : 55|16:38:00.5702||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Scotland vs Oman 5th Place Play Off.mp4 subfolder t Verbose: 1220 : 55|16:38:00.5702|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Scotland vs Oman 5th Place Play Off.mp4 t Verbose: 1220 : 55|16:38:00.5702||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/Scotland vs Oman 5th Place Play Off.mp4 t Transfer: 1220 : 55|16:38:00.5702||GetCurrentUser.. t Transfer: 1220 : 55|16:38:00.5702|| OAuth authenticated t Transfer: 1220 : 55|16:38:00.5702|| user TMDDBA. t Verbose: 1220 : 55|16:38:00.5702||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\South Africa vs Bangladesh Match 5 .mp4 subfolder t Verbose: 1220 : 55|16:38:00.5702|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/South Africa vs Bangladesh Match 5 .mp4 t Verbose: 1220 : 55|16:38:00.5702||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/South Africa vs Bangladesh Match 5 .mp4 t Transfer: 1220 : 55|16:38:00.5702||GetCurrentUser.. t Transfer: 1220 : 55|16:38:00.5702|| OAuth authenticated t Transfer: 1220 : 55|16:38:00.5702|| user TMDDBA. t Verbose: 1220 : 55|16:38:00.5702||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\New Zealand vs Sri Lanka Match 3.mp4 subfolder t Verbose: 1220 : 55|16:38:00.5702|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/New Zealand vs Sri Lanka Match 3.mp4 t Verbose: 1220 : 55|16:38:00.5702||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/New Zealand vs Sri Lanka Match 3.mp4 t Transfer: 1220 : 55|16:38:00.5702||GetCurrentUser.. t Transfer: 1220 : 55|16:38:00.5702|| OAuth authenticated t Transfer: 1220 : 55|16:38:00.5702|| user TMDDBA. t Verbose: 1220 : 55|16:38:00.5702||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Afghanistan vs Australia Match 4.mp4 subfolder t Verbose: 1220 : 55|16:38:00.5702|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Afghanistan vs Australia Match 4.mp4 t Verbose: 1220 : 55|16:38:00.5702||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/Afghanistan vs Australia Match 4.mp4 t Transfer: 1220 : 55|16:38:00.5702||GetCurrentUser.. t Transfer: 1220 : 55|16:38:00.5702|| OAuth authenticated t Transfer: 1220 : 55|16:38:00.5702|| user TMDDBA. t Verbose: 1220 : 55|16:38:00.5702||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Bangladesh vs New Zealand Match 9.mp4 subfolder t Verbose: 1220 : 55|16:38:00.5702|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Bangladesh vs New Zealand Match 9.mp4 t Verbose: 1220 : 55|16:38:00.5702||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/Bangladesh vs New Zealand Match 9.mp4 t Transfer: 1220 : 55|16:38:00.5702||GetCurrentUser.. t Transfer: 1220 : 55|16:38:00.5702|| OAuth authenticated t Transfer: 1220 : 55|16:38:00.5702|| user TMDDBA. t Verbose: 1220 : 55|16:38:00.5702||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Afghanistan vs Sri Lanka Match 7.mp4 subfolder t Verbose: 1220 : 55|16:38:00.5702|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Afghanistan vs Sri Lanka Match 7.mp4 t Verbose: 1220 : 55|16:38:00.5702||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/Afghanistan vs Sri Lanka Match 7.mp4 t Transfer: 1220 : 55|16:38:00.5702||GetCurrentUser.. t Transfer: 1220 : 55|16:38:00.5702|| OAuth authenticated t Transfer: 1220 : 55|16:38:00.5702|| user TMDDBA. t Verbose: 1220 : 55|16:38:00.5702||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Australia vs West Indies Match 10.mp4 subfolder t Verbose: 1220 : 55|16:38:00.5702|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Australia vs West Indies Match 10.mp4 t Verbose: 1220 : 55|16:38:00.5702||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/Australia vs West Indies Match 10.mp4 t Transfer: 1220 : 55|16:38:00.5702||GetCurrentUser.. t Transfer: 1220 : 55|16:38:00.5702|| OAuth authenticated t Transfer: 1220 : 55|16:38:00.5702|| user TMDDBA. t Verbose: 1220 : 55|16:38:00.5702||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\South Africa vs India Match 8.mp4 subfolder t Verbose: 1220 : 55|16:38:00.5702|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/South Africa vs India Match 8.mp4 t Verbose: 1220 : 55|16:38:00.5702||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/South Africa vs India Match 8.mp4 t Transfer: 1220 : 55|16:38:00.5702||GetCurrentUser.. t Transfer: 1220 : 55|16:38:00.5702|| OAuth authenticated t Transfer: 1220 : 55|16:38:00.5702|| user TMDDBA. t Verbose: 1220 : 55|16:38:00.5702||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\England vs Pakistan Match 6.mp4 subfolder t Verbose: 1220 : 55|16:38:00.5702|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/England vs Pakistan Match 6.mp4 t Verbose: 1220 : 55|16:38:00.5702||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/England vs Pakistan Match 6.mp4 t Transfer: 1220 : 55|16:38:00.5702||GetCurrentUser.. t Transfer: 1220 : 55|16:38:00.5702|| OAuth authenticated t Transfer: 1220 : 55|16:38:00.5702|| user TMDDBA. t Verbose: 1220 : 55|16:38:00.5702||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Pakistan vs Sri Lanka Match 11.mp4 subfolder t Verbose: 1220 : 55|16:38:00.5702|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Pakistan vs Sri Lanka Match 11.mp4 t Verbose: 1220 : 55|16:38:00.5702||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/Pakistan vs Sri Lanka Match 11.mp4 t Transfer: 1220 : 55|16:38:00.5702||GetCurrentUser.. t Transfer: 1220 : 55|16:38:00.5702|| OAuth authenticated t Transfer: 1220 : 55|16:38:00.5702|| user TMDDBA. t Transfer: 1220 : 42|16:38:01.0858||IsUserAuthenticated: /api/user-preferences?_dc=1575995850442 t Transfer: 1220 : 42|16:38:01.0858||GetCurrentUser.. t Transfer: 1220 : 42|16:38:01.0858|| OAuth authenticated t Transfer: 1220 : 42|16:38:01.0858|| user TMDDBA. t Transfer: 1220 : 42|16:38:01.0858||api user: TMDDBA t Verbose: 1220 : 42|16:38:01.0858||StoreUserDataByKeys.. t Transfer: 1220 : 42|16:38:01.0858||GetCurrentUser.. t Transfer: 1220 : 42|16:38:01.0858|| OAuth authenticated t Transfer: 1220 : 42|16:38:01.0858|| user TMDDBA. t Transfer: 1220 : 55|16:38:01.6952||IsUserAuthenticated: /api/lookups/FriendlyNames?_dc=1575995851043 t Transfer: 1220 : 55|16:38:01.6952||GetCurrentUser.. t Transfer: 1220 : 55|16:38:01.6952|| OAuth authenticated t Transfer: 1220 : 55|16:38:01.6952|| user TMDDBA. t Transfer: 1220 : 55|16:38:01.6952||api user: TMDDBA t Transfer: 1220 : 53|16:38:01.6952||IsUserAuthenticated: /api/user-group-preferences?globals=htmlplayerhotkeys,audioOnFrameForward&_dc=1575995851066 t Transfer: 1220 : 53|16:38:01.6952||GetCurrentUser.. t Transfer: 1220 : 53|16:38:01.6952|| OAuth authenticated t Transfer: 1220 : 53|16:38:01.6952|| user TMDDBA. t Transfer: 1220 : 53|16:38:01.6952||api user: TMDDBA t Information: 1220 : 53|16:38:01.6952||V3Api.GetUserSettings t Transfer: 1220 : 53|16:38:01.6952||GetCurrentUser.. t Transfer: 1220 : 53|16:38:01.6952|| OAuth authenticated t Transfer: 1220 : 53|16:38:01.6952|| user TMDDBA. t Transfer: 1220 : 44|16:38:01.7108||IsUserAuthenticated: /api/search/Media?_dc=1575995851044 t Transfer: 1220 : 44|16:38:01.7108||GetCurrentUser.. t Transfer: 1220 : 44|16:38:01.7108|| OAuth authenticated t Transfer: 1220 : 44|16:38:01.7108|| user TMDDBA. t Transfer: 1220 : 44|16:38:01.7108||api user: TMDDBA t Information: 1220 : 44|16:38:01.7108||V3Api.SearchMedia t Information: 1220 : 44|16:38:01.7108||V3Api.SearchGeneric t Transfer: 1220 : 44|16:38:01.7108||GetCurrentUser.. t Transfer: 1220 : 44|16:38:01.7108|| OAuth authenticated t Transfer: 1220 : 44|16:38:01.7108|| user TMDDBA. t Information: 1220 : 44|16:38:01.7108||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 min(status.description) from TM_CFG_PGM_STATUS status where r.status = status.id) PGM_STATUS_TEXT, 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=298524 and m.mi_deleted=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 : 44|16:38:01.7733|| timing: 00:00:00.0619182 t Verbose: 1220 : 44|16:38:01.7733||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\England v Bangladesh Match Group A.mp4 subfolder t Verbose: 1220 : 44|16:38:01.7733|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/England v Bangladesh Match Group A.mp4 t Verbose: 1220 : 44|16:38:01.7733||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/England v Bangladesh Match Group A.mp4 t Transfer: 1220 : 44|16:38:01.7733||GetCurrentUser.. t Transfer: 1220 : 44|16:38:01.7733|| OAuth authenticated t Transfer: 1220 : 44|16:38:01.7733|| user TMDDBA. t Transfer: 1220 : 55|16:38:01.9452||IsUserAuthenticated: /api/mediavideo/298524?info=smudge&_dc=1575995851308 t Transfer: 1220 : 55|16:38:01.9452||GetCurrentUser.. t Transfer: 1220 : 55|16:38:01.9452|| OAuth authenticated t Transfer: 1220 : 55|16:38:01.9452|| user TMDDBA. t Transfer: 1220 : 55|16:38:01.9452||api user: TMDDBA t Verbose: 1220 : 55|16:38:01.9608||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\England v Bangladesh Match Group A.mp4 subfolder t Transfer: 1220 : 41|16:38:01.9608||IsUserAuthenticated: /api/v3/detailsview/MediaDetails/5?lang=en-GB&_dc=1575995851297 t Transfer: 1220 : 41|16:38:01.9608||GetCurrentUser.. t Transfer: 1220 : 41|16:38:01.9608|| OAuth authenticated t Transfer: 1220 : 41|16:38:01.9608|| user TMDDBA. t Verbose: 1220 : 55|16:38:01.9608|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/England v Bangladesh Match Group A.mp4 t Verbose: 1220 : 55|16:38:01.9608||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/England v Bangladesh Match Group A.mp4 t Transfer: 1220 : 55|16:38:01.9608||GetCurrentUser.. t Transfer: 1220 : 55|16:38:01.9608|| OAuth authenticated t Transfer: 1220 : 55|16:38:01.9608|| user TMDDBA. t Transfer: 1220 : 41|16:38:01.9608||api user: TMDDBA t Information: 1220 : 35|16:38:01.9608||V3Api.GetMediaTagging t Transfer: 1220 : 44|16:38:01.9608||IsUserAuthenticated: /api/lookups/FriendlyNames?_dc=1575995851298 t Transfer: 1220 : 44|16:38:01.9608||GetCurrentUser.. t Transfer: 1220 : 44|16:38:01.9608|| OAuth authenticated t Transfer: 1220 : 44|16:38:01.9608|| user TMDDBA. t Transfer: 1220 : 44|16:38:01.9608||api user: TMDDBA t Transfer: 1220 : 48|16:38:01.9765||IsUserAuthenticated: /api/media-captions/298524?_dc=1575995851302 t Transfer: 1220 : 48|16:38:01.9765||GetCurrentUser.. t Transfer: 1220 : 48|16:38:01.9765|| OAuth authenticated t Transfer: 1220 : 48|16:38:01.9765|| user TMDDBA. t Transfer: 1220 : 48|16:38:01.9765||api user: TMDDBA t Transfer: 1220 : 42|16:38:02.5858||IsUserAuthenticated: /api/search/Media?_dc=1575995851955 t Transfer: 1220 : 42|16:38:02.5858||GetCurrentUser.. t Transfer: 1220 : 42|16:38:02.5858|| OAuth authenticated t Transfer: 1220 : 42|16:38:02.5858|| user TMDDBA. t Transfer: 1220 : 42|16:38:02.5858||api user: TMDDBA t Information: 1220 : 42|16:38:02.5858||V3Api.SearchMedia t Information: 1220 : 42|16:38:02.5858||V3Api.SearchGeneric t Transfer: 1220 : 42|16:38:02.5858||GetCurrentUser.. t Transfer: 1220 : 42|16:38:02.5858|| OAuth authenticated t Transfer: 1220 : 42|16:38:02.5858|| user TMDDBA. t Information: 1220 : 42|16:38:02.5858||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 min(status.description) from TM_CFG_PGM_STATUS status where r.status = status.id) PGM_STATUS_TEXT, 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=298524 and m.mi_deleted=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 : 42|16:38:02.6014|| timing: 00:00:00.0225181 t Verbose: 1220 : 42|16:38:02.6014||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\England v Bangladesh Match Group A.mp4 subfolder t Verbose: 1220 : 42|16:38:02.6014|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/England v Bangladesh Match Group A.mp4 t Verbose: 1220 : 42|16:38:02.6014||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/England v Bangladesh Match Group A.mp4 t Transfer: 1220 : 42|16:38:02.6014||GetCurrentUser.. t Transfer: 1220 : 42|16:38:02.6014|| OAuth authenticated t Transfer: 1220 : 42|16:38:02.6014|| user TMDDBA. t Transfer: 1220 : 55|16:38:11.4452||IsUserAuthenticated: /api/view/MediaGrid/760?_dc=1575995860440 t Transfer: 1220 : 55|16:38:11.4452||GetCurrentUser.. t Transfer: 1220 : 55|16:38:11.4452|| OAuth authenticated t Transfer: 1220 : 55|16:38:11.4452|| user TMDDBA. t Transfer: 1220 : 55|16:38:11.4452||api user: TMDDBA t Information: 1220 : 55|16:38:11.4452||UserGridView. LoadView. ID 760, Name . t Transfer: 1220 : 55|16:38:11.4452||GetCurrentUser.. t Transfer: 1220 : 55|16:38:11.4452|| OAuth authenticated t Transfer: 1220 : 55|16:38:11.4452|| user TMDDBA. t Transfer: 1220 : 35|16:38:15.6014||IsUserAuthenticated: /api/view/MediaGrid/1303?_dc=1575995864955 t Transfer: 1220 : 35|16:38:15.6014||GetCurrentUser.. t Transfer: 1220 : 35|16:38:15.6014|| OAuth authenticated t Transfer: 1220 : 35|16:38:15.6014|| user TMDDBA. t Transfer: 1220 : 35|16:38:15.6014||api user: TMDDBA t Information: 1220 : 35|16:38:15.6014||UserGridView. LoadView. ID 1303, Name . t Transfer: 1220 : 35|16:38:15.6014||GetCurrentUser.. t Transfer: 1220 : 35|16:38:15.6014|| OAuth authenticated t Transfer: 1220 : 35|16:38:15.6014|| user TMDDBA. t Transfer: 1220 : 48|16:38:18.7108||IsUserAuthenticated: /api/view/MediaGrid/860?_dc=1575995868076 t Transfer: 1220 : 48|16:38:18.7108||GetCurrentUser.. t Transfer: 1220 : 48|16:38:18.7108|| OAuth authenticated t Transfer: 1220 : 48|16:38:18.7108|| user TMDDBA. t Transfer: 1220 : 48|16:38:18.7108||api user: TMDDBA t Information: 1220 : 48|16:38:18.7108||UserGridView. LoadView. ID 860, Name . t Transfer: 1220 : 48|16:38:18.7108||GetCurrentUser.. t Transfer: 1220 : 48|16:38:18.7108|| OAuth authenticated t Transfer: 1220 : 48|16:38:18.7108|| user TMDDBA. t Transfer: 1220 : 44|16:38:21.6795||IsUserAuthenticated: /api/view/MediaGrid/1521?_dc=1575995871046 t Transfer: 1220 : 44|16:38:21.6795||GetCurrentUser.. t Transfer: 1220 : 44|16:38:21.6795|| OAuth authenticated t Transfer: 1220 : 44|16:38:21.6795|| user TMDDBA. t Transfer: 1220 : 44|16:38:21.6795||api user: TMDDBA t Information: 1220 : 44|16:38:21.6795||UserGridView. LoadView. ID 1521, Name . t Transfer: 1220 : 44|16:38:21.6795||GetCurrentUser.. t Transfer: 1220 : 44|16:38:21.6795|| OAuth authenticated t Transfer: 1220 : 44|16:38:21.6795|| user TMDDBA. t Transfer: 1220 : 35|16:38:24.0702||IsUserAuthenticated: /api/search/Media?_dc=1575995873441 t Transfer: 1220 : 35|16:38:24.0702||GetCurrentUser.. t Transfer: 1220 : 35|16:38:24.0702|| OAuth authenticated t Transfer: 1220 : 35|16:38:24.0702|| user TMDDBA. t Transfer: 1220 : 35|16:38:24.0702||api user: TMDDBA t Information: 1220 : 35|16:38:24.0702||V3Api.SearchMedia t Information: 1220 : 35|16:38:24.0702||V3Api.SearchGeneric t Transfer: 1220 : 35|16:38:24.0702||GetCurrentUser.. t Transfer: 1220 : 35|16:38:24.0702|| OAuth authenticated t Transfer: 1220 : 35|16:38:24.0702|| user TMDDBA. t Information: 1220 : 35|16:38:24.1327||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 t.name from TM_CFG_MI_FMT_TYP t where t.id = r.mi_fmt_type) ITEM_FORMAT_TEXT, GETMEDIALOC(r.id, r.media_type, r.compil, r.m_ctnr_int_o_loc, r.m_ctnr_ext_o_loc, r.m_ctnr_loc) LOCATION, nvl(dfl.fSOM,0) FILE_SOM, nvl(dfl.fEOM,0) FILE_EOM, dfl.fos_fname FILENAME, dfl.DFILE_LINK_GUID, dfl.OS_GUID, dfl.SUB_FOLDER, dfl.ORIGINAL_FILENAME from (select a.*, rownum rnum from (select m.*, coalesce(m.primary_thumb_id, (select v.primary_thumb_id from tm_pg_rl v where v.id=m.pgm_parent_id)) primary_thumb_id2 from tmddba.tm_mis m ,(select /*+ cardinality(4) */ rownum rn, column_value id from table(:ids)) ids where media_type>0 and item_type>0 and m.id = ids.id order by ids.rn ) a where rownum <= 10000) r ,lateral( select l.miid, max(c.C_EXT_OUT_LOC) lib_loc_ext_id, max(c.C_STAT) ctnr_stat, max(c.loan_stat) ctnr_loan_stat from tm_mi_tpi_lnx l, tm_ctnrs c where c.u_id=l.tpiid and l.miid=r.id and r.media_type=1 group by l.miid)(+) lnk ,lateral(select tt.* from tm_text tt where tt.text_id = r.primary_thumb_id2)(+) t ,lateral(select /*+ NO_DECORRELATE */ d.som fsom, d.eom feom, dl.mi_id fmi_id, d.os_fname fos_fname, d.DFILE_LINK_GUID, d.OS_GUID, d.SUB_FOLDER, dl.dfile_id, d.original_filename FROM tm_dfile d, tm_mi_dfile_lnx dl where d.id=dl.dfile_id and r.id=dl.mi_id and rownum=1)(+) dfl where rnum >= 1 order by rnum t Information: 1220 : 35|16:38:24.2108|| timing: 00:00:00.1394554 t Verbose: 1220 : 35|16:38:24.2108||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\England v Bangladesh Match Group A.mp4 subfolder t Verbose: 1220 : 35|16:38:24.2108|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/England v Bangladesh Match Group A.mp4 t Verbose: 1220 : 35|16:38:24.2108||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/England v Bangladesh Match Group A.mp4 t Transfer: 1220 : 35|16:38:24.2108||GetCurrentUser.. t Transfer: 1220 : 35|16:38:24.2108|| OAuth authenticated t Transfer: 1220 : 35|16:38:24.2108|| user TMDDBA. t Verbose: 1220 : 35|16:38:24.2108||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\ICC 360 Cricket for Change.mp4 subfolder t Verbose: 1220 : 35|16:38:24.2108|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/ICC 360 Cricket for Change.mp4 t Verbose: 1220 : 35|16:38:24.2108||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/ICC 360 Cricket for Change.mp4 t Transfer: 1220 : 35|16:38:24.2108||GetCurrentUser.. t Transfer: 1220 : 35|16:38:24.2108|| OAuth authenticated t Transfer: 1220 : 35|16:38:24.2108|| user TMDDBA. t Verbose: 1220 : 35|16:38:24.2108||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Australia vs South Africa Match 45.mp4 subfolder t Verbose: 1220 : 35|16:38:24.2108|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Australia vs South Africa Match 45.mp4 t Verbose: 1220 : 35|16:38:24.2108||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/Australia vs South Africa Match 45.mp4 t Transfer: 1220 : 35|16:38:24.2108||GetCurrentUser.. t Transfer: 1220 : 35|16:38:24.2108|| OAuth authenticated t Transfer: 1220 : 35|16:38:24.2108|| user TMDDBA. t Verbose: 1220 : 35|16:38:24.2108||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\England vs South Africa Match 1.mp4 subfolder t Verbose: 1220 : 35|16:38:24.2108|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/England vs South Africa Match 1.mp4 t Verbose: 1220 : 35|16:38:24.2108||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/England vs South Africa Match 1.mp4 t Transfer: 1220 : 35|16:38:24.2108||GetCurrentUser.. t Transfer: 1220 : 35|16:38:24.2108|| OAuth authenticated t Transfer: 1220 : 35|16:38:24.2108|| user TMDDBA. t Verbose: 1220 : 35|16:38:24.2265||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\West Indies vs Pakistan Match 2.mp4 subfolder t Verbose: 1220 : 35|16:38:24.2265|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/West Indies vs Pakistan Match 2.mp4 t Verbose: 1220 : 35|16:38:24.2265||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/West Indies vs Pakistan Match 2.mp4 t Transfer: 1220 : 35|16:38:24.2265||GetCurrentUser.. t Transfer: 1220 : 35|16:38:24.2265|| OAuth authenticated t Transfer: 1220 : 35|16:38:24.2265|| user TMDDBA. t Verbose: 1220 : 35|16:38:24.2265||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\New Zealand vs England Final.mp4 subfolder t Verbose: 1220 : 35|16:38:24.2265|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/New Zealand vs England Final.mp4 t Verbose: 1220 : 35|16:38:24.2265||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/New Zealand vs England Final.mp4 t Transfer: 1220 : 35|16:38:24.2265||GetCurrentUser.. t Transfer: 1220 : 35|16:38:24.2265|| OAuth authenticated t Transfer: 1220 : 35|16:38:24.2265|| user TMDDBA. t Verbose: 1220 : 35|16:38:24.2265||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Australia vs England Short Semi Final 2.mp4 subfolder t Verbose: 1220 : 35|16:38:24.2265|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Australia vs England Short Semi Final 2.mp4 t Verbose: 1220 : 35|16:38:24.2265||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/Australia vs England Short Semi Final 2.mp4 t Transfer: 1220 : 35|16:38:24.2265||GetCurrentUser.. t Transfer: 1220 : 35|16:38:24.2265|| OAuth authenticated t Transfer: 1220 : 35|16:38:24.2265|| user TMDDBA. t Verbose: 1220 : 35|16:38:24.2265||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\India vs New Zealand Semi Final 1.mp4 subfolder t Verbose: 1220 : 35|16:38:24.2265|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/India vs New Zealand Semi Final 1.mp4 t Verbose: 1220 : 35|16:38:24.2265||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/India vs New Zealand Semi Final 1.mp4 t Transfer: 1220 : 35|16:38:24.2265||GetCurrentUser.. t Transfer: 1220 : 35|16:38:24.2265|| OAuth authenticated t Transfer: 1220 : 35|16:38:24.2265|| user TMDDBA. t Verbose: 1220 : 35|16:38:24.2265||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Scotland vs Oman 5th Place Play Off.mp4 subfolder t Verbose: 1220 : 35|16:38:24.2265|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Scotland vs Oman 5th Place Play Off.mp4 t Verbose: 1220 : 35|16:38:24.2265||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/Scotland vs Oman 5th Place Play Off.mp4 t Transfer: 1220 : 35|16:38:24.2265||GetCurrentUser.. t Transfer: 1220 : 35|16:38:24.2265|| OAuth authenticated t Transfer: 1220 : 35|16:38:24.2265|| user TMDDBA. t Verbose: 1220 : 35|16:38:24.2265||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\South Africa vs Bangladesh Match 5 .mp4 subfolder t Verbose: 1220 : 35|16:38:24.2265|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/South Africa vs Bangladesh Match 5 .mp4 t Verbose: 1220 : 35|16:38:24.2265||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/South Africa vs Bangladesh Match 5 .mp4 t Transfer: 1220 : 35|16:38:24.2265||GetCurrentUser.. t Transfer: 1220 : 35|16:38:24.2265|| OAuth authenticated t Transfer: 1220 : 35|16:38:24.2265|| user TMDDBA. t Verbose: 1220 : 35|16:38:24.2265||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\New Zealand vs Sri Lanka Match 3.mp4 subfolder t Verbose: 1220 : 35|16:38:24.2265|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/New Zealand vs Sri Lanka Match 3.mp4 t Verbose: 1220 : 35|16:38:24.2265||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/New Zealand vs Sri Lanka Match 3.mp4 t Transfer: 1220 : 35|16:38:24.2265||GetCurrentUser.. t Transfer: 1220 : 35|16:38:24.2265|| OAuth authenticated t Transfer: 1220 : 35|16:38:24.2265|| user TMDDBA. t Verbose: 1220 : 35|16:38:24.2265||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Afghanistan vs Australia Match 4.mp4 subfolder t Verbose: 1220 : 35|16:38:24.2265|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Afghanistan vs Australia Match 4.mp4 t Verbose: 1220 : 35|16:38:24.2265||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/Afghanistan vs Australia Match 4.mp4 t Transfer: 1220 : 35|16:38:24.2265||GetCurrentUser.. t Transfer: 1220 : 35|16:38:24.2265|| OAuth authenticated t Transfer: 1220 : 35|16:38:24.2265|| user TMDDBA. t Verbose: 1220 : 35|16:38:24.2421||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Bangladesh vs New Zealand Match 9.mp4 subfolder t Verbose: 1220 : 35|16:38:24.2421|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Bangladesh vs New Zealand Match 9.mp4 t Verbose: 1220 : 35|16:38:24.2421||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/Bangladesh vs New Zealand Match 9.mp4 t Transfer: 1220 : 35|16:38:24.2421||GetCurrentUser.. t Transfer: 1220 : 35|16:38:24.2421|| OAuth authenticated t Transfer: 1220 : 35|16:38:24.2421|| user TMDDBA. t Verbose: 1220 : 35|16:38:24.2421||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Afghanistan vs Sri Lanka Match 7.mp4 subfolder t Verbose: 1220 : 35|16:38:24.2421|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Afghanistan vs Sri Lanka Match 7.mp4 t Verbose: 1220 : 35|16:38:24.2421||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/Afghanistan vs Sri Lanka Match 7.mp4 t Transfer: 1220 : 35|16:38:24.2421||GetCurrentUser.. t Transfer: 1220 : 35|16:38:24.2421|| OAuth authenticated t Transfer: 1220 : 35|16:38:24.2421|| user TMDDBA. t Verbose: 1220 : 35|16:38:24.2421||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Australia vs West Indies Match 10.mp4 subfolder t Verbose: 1220 : 35|16:38:24.2421|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Australia vs West Indies Match 10.mp4 t Verbose: 1220 : 35|16:38:24.2421||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/Australia vs West Indies Match 10.mp4 t Transfer: 1220 : 35|16:38:24.2421||GetCurrentUser.. t Transfer: 1220 : 35|16:38:24.2421|| OAuth authenticated t Transfer: 1220 : 35|16:38:24.2421|| user TMDDBA. t Verbose: 1220 : 35|16:38:24.2421||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\South Africa vs India Match 8.mp4 subfolder t Verbose: 1220 : 35|16:38:24.2421|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/South Africa vs India Match 8.mp4 t Verbose: 1220 : 35|16:38:24.2421||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/South Africa vs India Match 8.mp4 t Transfer: 1220 : 35|16:38:24.2421||GetCurrentUser.. t Transfer: 1220 : 35|16:38:24.2421|| OAuth authenticated t Transfer: 1220 : 35|16:38:24.2421|| user TMDDBA. t Verbose: 1220 : 35|16:38:24.2421||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\England vs Pakistan Match 6.mp4 subfolder t Verbose: 1220 : 35|16:38:24.2421|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/England vs Pakistan Match 6.mp4 t Verbose: 1220 : 35|16:38:24.2421||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/England vs Pakistan Match 6.mp4 t Transfer: 1220 : 35|16:38:24.2421||GetCurrentUser.. t Transfer: 1220 : 35|16:38:24.2421|| OAuth authenticated t Transfer: 1220 : 35|16:38:24.2421|| user TMDDBA. t Verbose: 1220 : 35|16:38:24.2421||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Pakistan vs Sri Lanka Match 11.mp4 subfolder t Verbose: 1220 : 35|16:38:24.2421|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Pakistan vs Sri Lanka Match 11.mp4 t Verbose: 1220 : 35|16:38:24.2421||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/Pakistan vs Sri Lanka Match 11.mp4 t Transfer: 1220 : 35|16:38:24.2421||GetCurrentUser.. t Transfer: 1220 : 35|16:38:24.2421|| OAuth authenticated t Transfer: 1220 : 35|16:38:24.2421|| user TMDDBA. t Transfer: 1220 : 56|16:38:28.4920||IsUserAuthenticated: /api/view/MediaGrid/860?_dc=1575995877865 t Transfer: 1220 : 56|16:38:28.4920||GetCurrentUser.. t Transfer: 1220 : 56|16:38:28.4920|| OAuth authenticated t Transfer: 1220 : 56|16:38:28.4920|| user TMDDBA. t Transfer: 1220 : 56|16:38:28.4920||api user: TMDDBA t Information: 1220 : 56|16:38:28.4920||UserGridView. LoadView. ID 860, Name . t Transfer: 1220 : 56|16:38:28.4920||GetCurrentUser.. t Transfer: 1220 : 56|16:38:28.4920|| OAuth authenticated t Transfer: 1220 : 56|16:38:28.4920|| user TMDDBA. t Transfer: 1220 : 56|16:38:29.2889||IsUserAuthenticated: /api/search/Media?_dc=1575995878666 t Transfer: 1220 : 56|16:38:29.2889||GetCurrentUser.. t Transfer: 1220 : 56|16:38:29.2889|| OAuth authenticated t Transfer: 1220 : 56|16:38:29.2889|| user TMDDBA. t Transfer: 1220 : 56|16:38:29.2889||api user: TMDDBA t Information: 1220 : 56|16:38:29.2889||V3Api.SearchMedia t Information: 1220 : 56|16:38:29.2889||V3Api.SearchGeneric t Transfer: 1220 : 56|16:38:29.2889||GetCurrentUser.. t Transfer: 1220 : 56|16:38:29.2889|| OAuth authenticated t Transfer: 1220 : 56|16:38:29.2889|| user TMDDBA. t Information: 1220 : 56|16:38:29.3202||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 min(status.ACCESS_STATUS_NAME) FROM TMDDBA.TM_ACCESS_STATUS statusLnx, TM_CFG_ACCESS_STATUS status WHERE statusLnx.Media_Id = r.id and statusLnx.Status_Id = status.id) ACCESS_STATUS , (select min(acq.alt_id1) from tm_acq acq, tm_acq_object obj where r.miid2 = obj.object_id and obj.acq_id = acq.id) TRANSFER_NUMBER , (select min(DISPOSAL_NAME) from TM_ACQ_DISPOSAL status, tm_disposal_records records where status.id = records.disposal_status_id and records.miid = r.id) DISPOSAL_STATUS , (select min(class.class_number) from TM_ACQ_DISPOSAL status, tm_disposal_records records, tm_disposal_classes class where status.id = records.disposal_status_id and records.miid = r.id and class.id = records.disposal_class_id) DISPOSAL_CLASS, (select min(names.concat_search_name) from tm_acq acq, tm_acq_object obj, tm_entities ctx, tm_names names where r.miid2 = obj.object_id and obj.acq_id = acq.id and acq.source = ctx.id and ctx.preferred_name = names.id) AGENCY, (select min(ctx.ITFC_CODE) from tm_mis mis, tm_mi_tpi_lnx links, tm_acq acq, tm_acq_object obj, tm_entities ctx, tm_names names where mis.id = r.id and links.miid = mis.id and mis.miid2 = obj.object_id and obj.acq_id = acq.id and acq.source = ctx.id and ctx.preferred_name = names.id) AGENCY_NUMBER, GETMEDIALOC(r.id, r.media_type, r.compil, r.m_ctnr_int_o_loc, r.m_ctnr_ext_o_loc, r.m_ctnr_loc) LOCATION, nvl(dfl.fSOM,0) FILE_SOM, nvl(dfl.fEOM,0) FILE_EOM, dfl.fos_fname FILENAME, dfl.DFILE_LINK_GUID, dfl.OS_GUID, dfl.SUB_FOLDER, dfl.ORIGINAL_FILENAME from (select a.*, rownum rnum from (select m.*, coalesce(m.primary_thumb_id, (select v.primary_thumb_id from tm_pg_rl v where v.id=m.pgm_parent_id)) primary_thumb_id2 from tmddba.tm_mis m ,(select /*+ cardinality(4) */ rownum rn, column_value id from table(:ids)) ids where media_type>0 and item_type>0 and m.id = ids.id order by ids.rn ) a where rownum <= 10000) r ,lateral( select l.miid, max(c.C_EXT_OUT_LOC) lib_loc_ext_id, max(c.C_STAT) ctnr_stat, max(c.loan_stat) ctnr_loan_stat from tm_mi_tpi_lnx l, tm_ctnrs c where c.u_id=l.tpiid and l.miid=r.id and r.media_type=1 group by l.miid)(+) lnk ,lateral(select tt.* from tm_text tt where tt.text_id = r.primary_thumb_id2)(+) t ,lateral(select /*+ NO_DECORRELATE */ d.som fsom, d.eom feom, dl.mi_id fmi_id, d.os_fname fos_fname, d.DFILE_LINK_GUID, d.OS_GUID, d.SUB_FOLDER, dl.dfile_id, d.original_filename FROM tm_dfile d, tm_mi_dfile_lnx dl where d.id=dl.dfile_id and r.id=dl.mi_id and rownum=1)(+) dfl where rnum >= 1 order by rnum t Information: 1220 : 56|16:38:29.4452|| timing: 00:00:00.1442084 t Verbose: 1220 : 56|16:38:29.4452||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\England v Bangladesh Match Group A.mp4 subfolder t Verbose: 1220 : 56|16:38:29.4452|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/England v Bangladesh Match Group A.mp4 t Verbose: 1220 : 56|16:38:29.4452||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/England v Bangladesh Match Group A.mp4 t Transfer: 1220 : 56|16:38:29.4452||GetCurrentUser.. t Transfer: 1220 : 56|16:38:29.4452|| OAuth authenticated t Transfer: 1220 : 56|16:38:29.4452|| user TMDDBA. t Verbose: 1220 : 56|16:38:29.4452||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\ICC 360 Cricket for Change.mp4 subfolder t Verbose: 1220 : 56|16:38:29.4452|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/ICC 360 Cricket for Change.mp4 t Verbose: 1220 : 56|16:38:29.4452||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/ICC 360 Cricket for Change.mp4 t Transfer: 1220 : 56|16:38:29.4452||GetCurrentUser.. t Transfer: 1220 : 56|16:38:29.4452|| OAuth authenticated t Transfer: 1220 : 56|16:38:29.4452|| user TMDDBA. t Verbose: 1220 : 56|16:38:29.4452||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Australia vs South Africa Match 45.mp4 subfolder t Verbose: 1220 : 56|16:38:29.4452|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Australia vs South Africa Match 45.mp4 t Verbose: 1220 : 56|16:38:29.4452||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/Australia vs South Africa Match 45.mp4 t Transfer: 1220 : 56|16:38:29.4452||GetCurrentUser.. t Transfer: 1220 : 56|16:38:29.4452|| OAuth authenticated t Transfer: 1220 : 56|16:38:29.4452|| user TMDDBA. t Verbose: 1220 : 56|16:38:29.4452||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\England vs South Africa Match 1.mp4 subfolder t Verbose: 1220 : 56|16:38:29.4452|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/England vs South Africa Match 1.mp4 t Verbose: 1220 : 56|16:38:29.4452||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/England vs South Africa Match 1.mp4 t Transfer: 1220 : 56|16:38:29.4452||GetCurrentUser.. t Transfer: 1220 : 56|16:38:29.4452|| OAuth authenticated t Transfer: 1220 : 56|16:38:29.4452|| user TMDDBA. t Verbose: 1220 : 56|16:38:29.4452||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\West Indies vs Pakistan Match 2.mp4 subfolder t Verbose: 1220 : 56|16:38:29.4452|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/West Indies vs Pakistan Match 2.mp4 t Verbose: 1220 : 56|16:38:29.4452||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/West Indies vs Pakistan Match 2.mp4 t Transfer: 1220 : 56|16:38:29.4452||GetCurrentUser.. t Transfer: 1220 : 56|16:38:29.4452|| OAuth authenticated t Transfer: 1220 : 56|16:38:29.4452|| user TMDDBA. t Verbose: 1220 : 56|16:38:29.4452||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\New Zealand vs England Final.mp4 subfolder t Verbose: 1220 : 56|16:38:29.4452|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/New Zealand vs England Final.mp4 t Verbose: 1220 : 56|16:38:29.4452||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/New Zealand vs England Final.mp4 t Transfer: 1220 : 56|16:38:29.4452||GetCurrentUser.. t Transfer: 1220 : 56|16:38:29.4452|| OAuth authenticated t Transfer: 1220 : 56|16:38:29.4452|| user TMDDBA. t Verbose: 1220 : 56|16:38:29.4452||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Australia vs England Short Semi Final 2.mp4 subfolder t Verbose: 1220 : 56|16:38:29.4452|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Australia vs England Short Semi Final 2.mp4 t Verbose: 1220 : 56|16:38:29.4452||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/Australia vs England Short Semi Final 2.mp4 t Transfer: 1220 : 56|16:38:29.4452||GetCurrentUser.. t Transfer: 1220 : 56|16:38:29.4452|| OAuth authenticated t Transfer: 1220 : 56|16:38:29.4452|| user TMDDBA. t Verbose: 1220 : 56|16:38:29.4452||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\India vs New Zealand Semi Final 1.mp4 subfolder t Verbose: 1220 : 56|16:38:29.4452|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/India vs New Zealand Semi Final 1.mp4 t Verbose: 1220 : 56|16:38:29.4452||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/India vs New Zealand Semi Final 1.mp4 t Transfer: 1220 : 56|16:38:29.4452||GetCurrentUser.. t Transfer: 1220 : 56|16:38:29.4452|| OAuth authenticated t Transfer: 1220 : 56|16:38:29.4452|| user TMDDBA. t Verbose: 1220 : 56|16:38:29.4608||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Scotland vs Oman 5th Place Play Off.mp4 subfolder t Verbose: 1220 : 56|16:38:29.4608|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Scotland vs Oman 5th Place Play Off.mp4 t Verbose: 1220 : 56|16:38:29.4608||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/Scotland vs Oman 5th Place Play Off.mp4 t Transfer: 1220 : 56|16:38:29.4608||GetCurrentUser.. t Transfer: 1220 : 56|16:38:29.4608|| OAuth authenticated t Transfer: 1220 : 56|16:38:29.4608|| user TMDDBA. t Verbose: 1220 : 56|16:38:29.4608||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\South Africa vs Bangladesh Match 5 .mp4 subfolder t Verbose: 1220 : 56|16:38:29.4608|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/South Africa vs Bangladesh Match 5 .mp4 t Verbose: 1220 : 56|16:38:29.4608||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/South Africa vs Bangladesh Match 5 .mp4 t Transfer: 1220 : 56|16:38:29.4608||GetCurrentUser.. t Transfer: 1220 : 56|16:38:29.4608|| OAuth authenticated t Transfer: 1220 : 56|16:38:29.4608|| user TMDDBA. t Verbose: 1220 : 56|16:38:29.4608||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\New Zealand vs Sri Lanka Match 3.mp4 subfolder t Verbose: 1220 : 56|16:38:29.4608|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/New Zealand vs Sri Lanka Match 3.mp4 t Verbose: 1220 : 56|16:38:29.4608||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/New Zealand vs Sri Lanka Match 3.mp4 t Transfer: 1220 : 56|16:38:29.4608||GetCurrentUser.. t Transfer: 1220 : 56|16:38:29.4608|| OAuth authenticated t Transfer: 1220 : 56|16:38:29.4608|| user TMDDBA. t Verbose: 1220 : 56|16:38:29.4608||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Afghanistan vs Australia Match 4.mp4 subfolder t Verbose: 1220 : 56|16:38:29.4608|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Afghanistan vs Australia Match 4.mp4 t Verbose: 1220 : 56|16:38:29.4608||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/Afghanistan vs Australia Match 4.mp4 t Transfer: 1220 : 56|16:38:29.4608||GetCurrentUser.. t Transfer: 1220 : 56|16:38:29.4608|| OAuth authenticated t Transfer: 1220 : 56|16:38:29.4608|| user TMDDBA. t Verbose: 1220 : 56|16:38:29.4608||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Bangladesh vs New Zealand Match 9.mp4 subfolder t Verbose: 1220 : 56|16:38:29.4608|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Bangladesh vs New Zealand Match 9.mp4 t Verbose: 1220 : 56|16:38:29.4608||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/Bangladesh vs New Zealand Match 9.mp4 t Transfer: 1220 : 56|16:38:29.4608||GetCurrentUser.. t Transfer: 1220 : 56|16:38:29.4608|| OAuth authenticated t Transfer: 1220 : 56|16:38:29.4608|| user TMDDBA. t Verbose: 1220 : 56|16:38:29.4608||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Afghanistan vs Sri Lanka Match 7.mp4 subfolder t Verbose: 1220 : 56|16:38:29.4608|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Afghanistan vs Sri Lanka Match 7.mp4 t Verbose: 1220 : 56|16:38:29.4608||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/Afghanistan vs Sri Lanka Match 7.mp4 t Transfer: 1220 : 56|16:38:29.4608||GetCurrentUser.. t Transfer: 1220 : 56|16:38:29.4608|| OAuth authenticated t Transfer: 1220 : 56|16:38:29.4608|| user TMDDBA. t Verbose: 1220 : 56|16:38:29.4608||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Australia vs West Indies Match 10.mp4 subfolder t Verbose: 1220 : 56|16:38:29.4608|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Australia vs West Indies Match 10.mp4 t Verbose: 1220 : 56|16:38:29.4608||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/Australia vs West Indies Match 10.mp4 t Transfer: 1220 : 56|16:38:29.4608||GetCurrentUser.. t Transfer: 1220 : 56|16:38:29.4608|| OAuth authenticated t Transfer: 1220 : 56|16:38:29.4608|| user TMDDBA. t Verbose: 1220 : 56|16:38:29.4608||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\South Africa vs India Match 8.mp4 subfolder t Verbose: 1220 : 56|16:38:29.4608|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/South Africa vs India Match 8.mp4 t Verbose: 1220 : 56|16:38:29.4608||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/South Africa vs India Match 8.mp4 t Transfer: 1220 : 56|16:38:29.4608||GetCurrentUser.. t Transfer: 1220 : 56|16:38:29.4608|| OAuth authenticated t Transfer: 1220 : 56|16:38:29.4608|| user TMDDBA. t Verbose: 1220 : 56|16:38:29.4608||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\England vs Pakistan Match 6.mp4 subfolder t Verbose: 1220 : 56|16:38:29.4608|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/England vs Pakistan Match 6.mp4 t Verbose: 1220 : 56|16:38:29.4608||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/England vs Pakistan Match 6.mp4 t Transfer: 1220 : 56|16:38:29.4608||GetCurrentUser.. t Transfer: 1220 : 56|16:38:29.4608|| OAuth authenticated t Transfer: 1220 : 56|16:38:29.4608|| user TMDDBA. t Verbose: 1220 : 56|16:38:29.4765||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Pakistan vs Sri Lanka Match 11.mp4 subfolder t Verbose: 1220 : 56|16:38:29.4765|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Pakistan vs Sri Lanka Match 11.mp4 t Verbose: 1220 : 56|16:38:29.4765||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/Pakistan vs Sri Lanka Match 11.mp4 t Transfer: 1220 : 56|16:38:29.4765||GetCurrentUser.. t Transfer: 1220 : 56|16:38:29.4765|| OAuth authenticated t Transfer: 1220 : 56|16:38:29.4765|| user TMDDBA. t Transfer: 1220 : 56|16:38:39.8202||IsUserAuthenticated: /api/user-preferences?_dc=1575995889173 t Transfer: 1220 : 56|16:38:39.8202||GetCurrentUser.. t Transfer: 1220 : 56|16:38:39.8202|| OAuth authenticated t Transfer: 1220 : 56|16:38:39.8202|| user TMDDBA. t Transfer: 1220 : 56|16:38:39.8202||api user: TMDDBA t Verbose: 1220 : 56|16:38:39.8202||StoreUserDataByKeys.. t Transfer: 1220 : 56|16:38:39.8202||GetCurrentUser.. t Transfer: 1220 : 56|16:38:39.8202|| OAuth authenticated t Transfer: 1220 : 56|16:38:39.8202|| user TMDDBA. t Transfer: 1220 : 44|16:38:42.5858||IsUserAuthenticated: /api/search/Media?_dc=1575995891952 t Transfer: 1220 : 44|16:38:42.5858||GetCurrentUser.. t Transfer: 1220 : 44|16:38:42.5858|| OAuth authenticated t Transfer: 1220 : 44|16:38:42.5858|| user TMDDBA. t Transfer: 1220 : 44|16:38:42.5858||api user: TMDDBA t Information: 1220 : 44|16:38:42.5858||V3Api.SearchMedia t Information: 1220 : 44|16:38:42.5858||V3Api.SearchGeneric t Transfer: 1220 : 44|16:38:42.5858||GetCurrentUser.. t Transfer: 1220 : 44|16:38:42.5858|| OAuth authenticated t Transfer: 1220 : 44|16:38:42.5858|| user TMDDBA. t Information: 1220 : 44|16:38:42.5858||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 where media_type>0 and item_type>0 AND m.ID=298533 and m.mi_deleted=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 : 56|16:38:42.6014||IsUserAuthenticated: /api/media-captions/298533?_dc=1575995891956 t Transfer: 1220 : 56|16:38:42.6014||GetCurrentUser.. t Transfer: 1220 : 56|16:38:42.6014|| OAuth authenticated t Transfer: 1220 : 56|16:38:42.6014|| user TMDDBA. t Transfer: 1220 : 56|16:38:42.6014||api user: TMDDBA t Information: 1220 : 61|16:38:42.6014||V3Api.GetMediaTagging t Information: 1220 : 44|16:38:42.6639|| timing: 00:00:00.0844602 t Verbose: 1220 : 44|16:38:42.6639||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Australia vs South Africa Match 45.mp4 subfolder t Verbose: 1220 : 44|16:38:42.6639|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Australia vs South Africa Match 45.mp4 t Verbose: 1220 : 44|16:38:42.6639||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/Australia vs South Africa Match 45.mp4 t Transfer: 1220 : 44|16:38:42.6639||GetCurrentUser.. t Transfer: 1220 : 44|16:38:42.6639|| OAuth authenticated t Transfer: 1220 : 44|16:38:42.6639|| user TMDDBA. t Transfer: 1220 : 44|16:38:43.0233||IsUserAuthenticated: /api/mediavideo/298533?info=smudge&_dc=1575995891980 t Transfer: 1220 : 44|16:38:43.0233||GetCurrentUser.. t Transfer: 1220 : 44|16:38:43.0233|| OAuth authenticated t Transfer: 1220 : 44|16:38:43.0233|| user TMDDBA. t Transfer: 1220 : 44|16:38:43.0233||api user: TMDDBA t Verbose: 1220 : 44|16:38:43.0233||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Australia vs South Africa Match 45.mp4 subfolder t Verbose: 1220 : 44|16:38:43.0233|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Australia vs South Africa Match 45.mp4 t Verbose: 1220 : 44|16:38:43.0233||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/Australia vs South Africa Match 45.mp4 t Transfer: 1220 : 44|16:38:43.0233||GetCurrentUser.. t Transfer: 1220 : 44|16:38:43.0233|| OAuth authenticated t Transfer: 1220 : 44|16:38:43.0233|| user TMDDBA. t Transfer: 1220 : 44|16:38:50.3827||IsUserAuthenticated: /api/media-details/298533?_dc=1575995899757 t Transfer: 1220 : 44|16:38:50.3827||GetCurrentUser.. t Transfer: 1220 : 44|16:38:50.3827|| OAuth authenticated t Transfer: 1220 : 44|16:38:50.3827|| user TMDDBA. t Transfer: 1220 : 44|16:38:50.3827||api user: TMDDBA t Transfer: 1220 : 44|16:38:50.3983||GetCurrentUser.. t Transfer: 1220 : 44|16:38:50.3983|| OAuth authenticated t Transfer: 1220 : 44|16:38:50.3983|| user TMDDBA. t Information: 1220 : 44|16:38:50.4920||TM_MIS. LoadSubtitles for ID: 298533. t Information: 1220 : 44|16:38:50.4920||TM_MIS. LoadSubtitles for ID: 298533. 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=298372' t Information: 1220 : 44|16:38:50.4920||TM_MIS. LoadSubtitles for ID: 298533 found no subtitles. t Verbose: 1220 : 44|16:38:50.6327||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Australia vs South Africa Match 45.mp4 subfolder t Verbose: 1220 : 44|16:38:50.6327|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Australia vs South Africa Match 45.mp4 t Verbose: 1220 : 44|16:38:50.6327||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/Australia vs South Africa Match 45.mp4 t Transfer: 1220 : 44|16:38:50.6327||GetCurrentUser.. t Transfer: 1220 : 44|16:38:50.6327|| OAuth authenticated t Transfer: 1220 : 44|16:38:50.6327|| user TMDDBA. t Transfer: 1220 : 44|16:38:50.9295||IsUserAuthenticated: /api/media-captions/298533?_dc=1575995900290 t Transfer: 1220 : 44|16:38:50.9295||GetCurrentUser.. t Transfer: 1220 : 44|16:38:50.9295|| OAuth authenticated t Transfer: 1220 : 44|16:38:50.9295|| user TMDDBA. t Transfer: 1220 : 44|16:38:50.9295||api user: TMDDBA t Transfer: 1220 : 44|16:38:51.0077||IsUserAuthenticated: /api/user-group-preferences?globals=htmlplayerhotkeys,audioOnFrameForward&_dc=1575995900377 t Transfer: 1220 : 44|16:38:51.0077||GetCurrentUser.. t Transfer: 1220 : 44|16:38:51.0077|| OAuth authenticated t Transfer: 1220 : 44|16:38:51.0077|| user TMDDBA. t Transfer: 1220 : 44|16:38:51.0077||api user: TMDDBA t Information: 1220 : 44|16:38:51.0077||V3Api.GetUserSettings t Transfer: 1220 : 44|16:38:51.0077||GetCurrentUser.. t Transfer: 1220 : 44|16:38:51.0077|| OAuth authenticated t Transfer: 1220 : 44|16:38:51.0077|| user TMDDBA. t Transfer: 1220 : 61|16:38:51.0545||IsUserAuthenticated: /api/lookups/MediaEventTypes?_dc=1575995900420 t Transfer: 1220 : 61|16:38:51.0545||GetCurrentUser.. t Transfer: 1220 : 61|16:38:51.0545|| OAuth authenticated t Transfer: 1220 : 61|16:38:51.0545|| user TMDDBA. t Transfer: 1220 : 61|16:38:51.0545||api user: TMDDBA t Transfer: 1220 : 56|16:38:51.1952||IsUserAuthenticated: /api/v3/media/related/298533/audio?_dc=1575995900562 t Transfer: 1220 : 56|16:38:51.1952||GetCurrentUser.. t Transfer: 1220 : 56|16:38:51.1952|| OAuth authenticated t Transfer: 1220 : 56|16:38:51.1952|| user TMDDBA. t Transfer: 1220 : 56|16:38:51.1952||api user: TMDDBA t Transfer: 1220 : 55|16:38:51.2108||IsUserAuthenticated: /api/mediavideo/298533?info=smudge,scene,audiovolume&_dc=1575995900581 t Transfer: 1220 : 55|16:38:51.2108||GetCurrentUser.. t Transfer: 1220 : 55|16:38:51.2108|| OAuth authenticated t Transfer: 1220 : 55|16:38:51.2108|| user TMDDBA. t Transfer: 1220 : 55|16:38:51.2108||api user: TMDDBA t Verbose: 1220 : 55|16:38:51.2108||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Australia vs South Africa Match 45.mp4 subfolder t Verbose: 1220 : 55|16:38:51.2108|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Australia vs South Africa Match 45.mp4 t Verbose: 1220 : 55|16:38:51.2108||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/Australia vs South Africa Match 45.mp4 t Transfer: 1220 : 55|16:38:51.2108||GetCurrentUser.. t Transfer: 1220 : 55|16:38:51.2108|| OAuth authenticated t Transfer: 1220 : 55|16:38:51.2108|| user TMDDBA. t Transfer: 1220 : 53|16:38:51.2264||IsUserAuthenticated: /api/v3/ai-tags/298533?_dc=1575995900604 t Transfer: 1220 : 53|16:38:51.2264||GetCurrentUser.. t Transfer: 1220 : 53|16:38:51.2264|| OAuth authenticated t Transfer: 1220 : 53|16:38:51.2264|| user TMDDBA. t Transfer: 1220 : 53|16:38:51.2264||api user: TMDDBA t Information: 1220 : 53|16:38:51.2264||V3Api.GetMediaAiTags t Transfer: 1220 : 61|16:38:51.6327||IsUserAuthenticated: /api/mediavideo/298533?info=smudge&_dc=1575995901007 t Transfer: 1220 : 61|16:38:51.6327||GetCurrentUser.. t Transfer: 1220 : 61|16:38:51.6327|| OAuth authenticated t Transfer: 1220 : 61|16:38:51.6327|| user TMDDBA. t Transfer: 1220 : 61|16:38:51.6327||api user: TMDDBA t Verbose: 1220 : 61|16:38:51.6327||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Australia vs South Africa Match 45.mp4 subfolder t Verbose: 1220 : 61|16:38:51.6327|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Australia vs South Africa Match 45.mp4 t Verbose: 1220 : 61|16:38:51.6327||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/Australia vs South Africa Match 45.mp4 t Transfer: 1220 : 61|16:38:51.6327||GetCurrentUser.. t Transfer: 1220 : 61|16:38:51.6327|| OAuth authenticated t Transfer: 1220 : 61|16:38:51.6327|| user TMDDBA. t Transfer: 1220 : 44|16:38:51.7577||IsUserAuthenticated: /api/metadata/4000/298533?_dc=1575995901140 t Transfer: 1220 : 44|16:38:51.7733||GetCurrentUser.. t Transfer: 1220 : 44|16:38:51.7733|| OAuth authenticated t Transfer: 1220 : 44|16:38:51.7733|| user TMDDBA. t Transfer: 1220 : 44|16:38:51.7733||api user: TMDDBA t Transfer: 1220 : 43|16:39:33.9451||IsUserAuthenticated: /api/view/MediaGrid/900?_dc=1575995943308 t Transfer: 1220 : 43|16:39:33.9608||GetCurrentUser.. t Transfer: 1220 : 43|16:39:33.9608|| OAuth authenticated t Transfer: 1220 : 43|16:39:33.9608|| user TMDDBA. t Transfer: 1220 : 43|16:39:33.9608||api user: TMDDBA t Information: 1220 : 43|16:39:33.9608||UserGridView. LoadView. ID 900, Name . t Transfer: 1220 : 43|16:39:33.9608||GetCurrentUser.. t Transfer: 1220 : 43|16:39:33.9608|| OAuth authenticated t Transfer: 1220 : 43|16:39:33.9608|| user TMDDBA. t Transfer: 1220 : 42|16:39:43.3201||IsUserAuthenticated: /api/search/Media?_dc=1575995952695 t Transfer: 1220 : 42|16:39:43.3201||GetCurrentUser.. t Transfer: 1220 : 42|16:39:43.3201|| OAuth authenticated t Transfer: 1220 : 42|16:39:43.3201|| user TMDDBA. t Transfer: 1220 : 42|16:39:43.3201||api user: TMDDBA t Information: 1220 : 42|16:39:43.3201||V3Api.SearchMedia t Information: 1220 : 42|16:39:43.3201||V3Api.SearchGeneric t Transfer: 1220 : 42|16:39:43.3201||GetCurrentUser.. t Transfer: 1220 : 42|16:39:43.3201|| OAuth authenticated t Transfer: 1220 : 42|16:39:43.3201|| user TMDDBA. t Information: 1220 : 42|16:39:43.3514||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 min(status.ACCESS_STATUS_NAME) FROM TMDDBA.TM_ACCESS_STATUS statusLnx, TM_CFG_ACCESS_STATUS status WHERE statusLnx.Media_Id = r.id and statusLnx.Status_Id = status.id) ACCESS_STATUS , (select min(names.concat_search_name) from tm_acq acq, tm_acq_object obj, tm_entities ctx, tm_names names where r.miid2 = obj.object_id and obj.acq_id = acq.id and acq.source = ctx.id and ctx.preferred_name = names.id) AGENCY, GETMEDIALOC(r.id, r.media_type, r.compil, r.m_ctnr_int_o_loc, r.m_ctnr_ext_o_loc, r.m_ctnr_loc) LOCATION, nvl(dfl.fSOM,0) FILE_SOM, nvl(dfl.fEOM,0) FILE_EOM, dfl.fos_fname FILENAME, dfl.DFILE_LINK_GUID, dfl.OS_GUID, dfl.SUB_FOLDER, dfl.ORIGINAL_FILENAME from (select a.*, rownum rnum from (select m.*, coalesce(m.primary_thumb_id, (select v.primary_thumb_id from tm_pg_rl v where v.id=m.pgm_parent_id)) primary_thumb_id2 from tmddba.tm_mis m ,(select /*+ cardinality(4) */ rownum rn, column_value id from table(:ids)) ids where media_type>0 and item_type>0 and m.id = ids.id order by ids.rn ) a where rownum <= 10000) r ,lateral( select l.miid, max(c.C_EXT_OUT_LOC) lib_loc_ext_id, max(c.C_STAT) ctnr_stat, max(c.loan_stat) ctnr_loan_stat from tm_mi_tpi_lnx l, tm_ctnrs c where c.u_id=l.tpiid and l.miid=r.id and r.media_type=1 group by l.miid)(+) lnk ,lateral(select tt.* from tm_text tt where tt.text_id = r.primary_thumb_id2)(+) t ,lateral(select /*+ NO_DECORRELATE */ d.som fsom, d.eom feom, dl.mi_id fmi_id, d.os_fname fos_fname, d.DFILE_LINK_GUID, d.OS_GUID, d.SUB_FOLDER, dl.dfile_id, d.original_filename FROM tm_dfile d, tm_mi_dfile_lnx dl where d.id=dl.dfile_id and r.id=dl.mi_id and rownum=1)(+) dfl where rnum >= 1 order by rnum t Information: 1220 : 42|16:39:43.4295|| timing: 00:00:00.1084556 t Verbose: 1220 : 42|16:39:43.4295||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\England v Bangladesh Match Group A.mp4 subfolder t Verbose: 1220 : 42|16:39:43.4295|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/England v Bangladesh Match Group A.mp4 t Verbose: 1220 : 42|16:39:43.4295||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/England v Bangladesh Match Group A.mp4 t Transfer: 1220 : 42|16:39:43.4295||GetCurrentUser.. t Transfer: 1220 : 42|16:39:43.4295|| OAuth authenticated t Transfer: 1220 : 42|16:39:43.4295|| user TMDDBA. t Verbose: 1220 : 42|16:39:43.4295||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\ICC 360 Cricket for Change.mp4 subfolder t Verbose: 1220 : 42|16:39:43.4295|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/ICC 360 Cricket for Change.mp4 t Verbose: 1220 : 42|16:39:43.4295||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/ICC 360 Cricket for Change.mp4 t Transfer: 1220 : 42|16:39:43.4295||GetCurrentUser.. t Transfer: 1220 : 42|16:39:43.4295|| OAuth authenticated t Transfer: 1220 : 42|16:39:43.4295|| user TMDDBA. t Verbose: 1220 : 42|16:39:43.4295||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Australia vs South Africa Match 45.mp4 subfolder t Verbose: 1220 : 42|16:39:43.4295|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Australia vs South Africa Match 45.mp4 t Verbose: 1220 : 42|16:39:43.4295||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/Australia vs South Africa Match 45.mp4 t Transfer: 1220 : 42|16:39:43.4295||GetCurrentUser.. t Transfer: 1220 : 42|16:39:43.4295|| OAuth authenticated t Transfer: 1220 : 42|16:39:43.4295|| user TMDDBA. t Verbose: 1220 : 42|16:39:43.4295||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\England vs South Africa Match 1.mp4 subfolder t Verbose: 1220 : 42|16:39:43.4295|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/England vs South Africa Match 1.mp4 t Verbose: 1220 : 42|16:39:43.4295||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/England vs South Africa Match 1.mp4 t Transfer: 1220 : 42|16:39:43.4295||GetCurrentUser.. t Transfer: 1220 : 42|16:39:43.4452|| OAuth authenticated t Transfer: 1220 : 42|16:39:43.4452|| user TMDDBA. t Verbose: 1220 : 42|16:39:43.4452||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\West Indies vs Pakistan Match 2.mp4 subfolder t Verbose: 1220 : 42|16:39:43.4452|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/West Indies vs Pakistan Match 2.mp4 t Verbose: 1220 : 42|16:39:43.4452||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/West Indies vs Pakistan Match 2.mp4 t Transfer: 1220 : 42|16:39:43.4452||GetCurrentUser.. t Transfer: 1220 : 42|16:39:43.4452|| OAuth authenticated t Transfer: 1220 : 42|16:39:43.4452|| user TMDDBA. t Verbose: 1220 : 42|16:39:43.4452||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\New Zealand vs England Final.mp4 subfolder t Verbose: 1220 : 42|16:39:43.4452|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/New Zealand vs England Final.mp4 t Verbose: 1220 : 42|16:39:43.4452||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/New Zealand vs England Final.mp4 t Transfer: 1220 : 42|16:39:43.4452||GetCurrentUser.. t Transfer: 1220 : 42|16:39:43.4452|| OAuth authenticated t Transfer: 1220 : 42|16:39:43.4452|| user TMDDBA. t Verbose: 1220 : 42|16:39:43.4452||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Australia vs England Short Semi Final 2.mp4 subfolder t Verbose: 1220 : 42|16:39:43.4452|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Australia vs England Short Semi Final 2.mp4 t Verbose: 1220 : 42|16:39:43.4452||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/Australia vs England Short Semi Final 2.mp4 t Transfer: 1220 : 42|16:39:43.4452||GetCurrentUser.. t Transfer: 1220 : 42|16:39:43.4452|| OAuth authenticated t Transfer: 1220 : 42|16:39:43.4452|| user TMDDBA. t Verbose: 1220 : 42|16:39:43.4452||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\India vs New Zealand Semi Final 1.mp4 subfolder t Verbose: 1220 : 42|16:39:43.4452|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/India vs New Zealand Semi Final 1.mp4 t Verbose: 1220 : 42|16:39:43.4452||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/India vs New Zealand Semi Final 1.mp4 t Transfer: 1220 : 42|16:39:43.4452||GetCurrentUser.. t Transfer: 1220 : 42|16:39:43.4452|| OAuth authenticated t Transfer: 1220 : 42|16:39:43.4452|| user TMDDBA. t Verbose: 1220 : 42|16:39:43.4452||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Scotland vs Oman 5th Place Play Off.mp4 subfolder t Verbose: 1220 : 42|16:39:43.4452|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Scotland vs Oman 5th Place Play Off.mp4 t Verbose: 1220 : 42|16:39:43.4452||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/Scotland vs Oman 5th Place Play Off.mp4 t Transfer: 1220 : 42|16:39:43.4452||GetCurrentUser.. t Transfer: 1220 : 42|16:39:43.4452|| OAuth authenticated t Transfer: 1220 : 42|16:39:43.4452|| user TMDDBA. t Verbose: 1220 : 42|16:39:43.4452||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\South Africa vs Bangladesh Match 5 .mp4 subfolder t Verbose: 1220 : 42|16:39:43.4452|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/South Africa vs Bangladesh Match 5 .mp4 t Verbose: 1220 : 42|16:39:43.4452||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/South Africa vs Bangladesh Match 5 .mp4 t Transfer: 1220 : 42|16:39:43.4452||GetCurrentUser.. t Transfer: 1220 : 42|16:39:43.4452|| OAuth authenticated t Transfer: 1220 : 42|16:39:43.4452|| user TMDDBA. t Verbose: 1220 : 42|16:39:43.4452||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\New Zealand vs Sri Lanka Match 3.mp4 subfolder t Verbose: 1220 : 42|16:39:43.4452|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/New Zealand vs Sri Lanka Match 3.mp4 t Verbose: 1220 : 42|16:39:43.4452||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/New Zealand vs Sri Lanka Match 3.mp4 t Transfer: 1220 : 42|16:39:43.4452||GetCurrentUser.. t Transfer: 1220 : 42|16:39:43.4452|| OAuth authenticated t Transfer: 1220 : 42|16:39:43.4452|| user TMDDBA. t Verbose: 1220 : 42|16:39:43.4452||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Afghanistan vs Australia Match 4.mp4 subfolder t Verbose: 1220 : 42|16:39:43.4608|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Afghanistan vs Australia Match 4.mp4 t Verbose: 1220 : 42|16:39:43.4608||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/Afghanistan vs Australia Match 4.mp4 t Transfer: 1220 : 42|16:39:43.4608||GetCurrentUser.. t Transfer: 1220 : 42|16:39:43.4608|| OAuth authenticated t Transfer: 1220 : 42|16:39:43.4608|| user TMDDBA. t Verbose: 1220 : 42|16:39:43.4608||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Bangladesh vs New Zealand Match 9.mp4 subfolder t Verbose: 1220 : 42|16:39:43.4608|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Bangladesh vs New Zealand Match 9.mp4 t Verbose: 1220 : 42|16:39:43.4608||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/Bangladesh vs New Zealand Match 9.mp4 t Transfer: 1220 : 42|16:39:43.4608||GetCurrentUser.. t Transfer: 1220 : 42|16:39:43.4608|| OAuth authenticated t Transfer: 1220 : 42|16:39:43.4608|| user TMDDBA. t Verbose: 1220 : 42|16:39:43.4608||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Afghanistan vs Sri Lanka Match 7.mp4 subfolder t Verbose: 1220 : 42|16:39:43.4608|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Afghanistan vs Sri Lanka Match 7.mp4 t Verbose: 1220 : 42|16:39:43.4608||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/Afghanistan vs Sri Lanka Match 7.mp4 t Transfer: 1220 : 42|16:39:43.4608||GetCurrentUser.. t Transfer: 1220 : 42|16:39:43.4608|| OAuth authenticated t Transfer: 1220 : 42|16:39:43.4608|| user TMDDBA. t Verbose: 1220 : 42|16:39:43.4608||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Australia vs West Indies Match 10.mp4 subfolder t Verbose: 1220 : 42|16:39:43.4608|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Australia vs West Indies Match 10.mp4 t Verbose: 1220 : 42|16:39:43.4608||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/Australia vs West Indies Match 10.mp4 t Transfer: 1220 : 42|16:39:43.4608||GetCurrentUser.. t Transfer: 1220 : 42|16:39:43.4608|| OAuth authenticated t Transfer: 1220 : 42|16:39:43.4608|| user TMDDBA. t Verbose: 1220 : 42|16:39:43.4608||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\South Africa vs India Match 8.mp4 subfolder t Verbose: 1220 : 42|16:39:43.4608|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/South Africa vs India Match 8.mp4 t Verbose: 1220 : 42|16:39:43.4608||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/South Africa vs India Match 8.mp4 t Transfer: 1220 : 42|16:39:43.4608||GetCurrentUser.. t Transfer: 1220 : 42|16:39:43.4608|| OAuth authenticated t Transfer: 1220 : 42|16:39:43.4608|| user TMDDBA. t Verbose: 1220 : 42|16:39:43.4608||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\England vs Pakistan Match 6.mp4 subfolder t Verbose: 1220 : 42|16:39:43.4608|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/England vs Pakistan Match 6.mp4 t Verbose: 1220 : 42|16:39:43.4608||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/England vs Pakistan Match 6.mp4 t Transfer: 1220 : 42|16:39:43.4608||GetCurrentUser.. t Transfer: 1220 : 42|16:39:43.4608|| OAuth authenticated t Transfer: 1220 : 42|16:39:43.4608|| user TMDDBA. t Verbose: 1220 : 42|16:39:43.4608||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Pakistan vs Sri Lanka Match 11.mp4 subfolder t Verbose: 1220 : 42|16:39:43.4608|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Pakistan vs Sri Lanka Match 11.mp4 t Verbose: 1220 : 42|16:39:43.4608||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/Pakistan vs Sri Lanka Match 11.mp4 t Transfer: 1220 : 42|16:39:43.4608||GetCurrentUser.. t Transfer: 1220 : 42|16:39:43.4608|| OAuth authenticated t Transfer: 1220 : 42|16:39:43.4608|| user TMDDBA. t Transfer: 1220 : 53|16:39:43.5702||IsUserAuthenticated: /api/view/info/TitleTree?lang=en-GB&_dc=1575995952947 t Transfer: 1220 : 53|16:39:43.5702||GetCurrentUser.. t Transfer: 1220 : 53|16:39:43.5702|| OAuth authenticated t Transfer: 1220 : 53|16:39:43.5702|| user TMDDBA. t Transfer: 1220 : 53|16:39:43.5702||api user: TMDDBA t Information: 1220 : 53|16:39:43.5702||GetGridViewBuilder. builder type TitleTree. t Transfer: 1220 : 53|16:39:43.5702||GetCurrentUser.. t Transfer: 1220 : 53|16:39:43.5702|| OAuth authenticated t Transfer: 1220 : 53|16:39:43.5702|| user TMDDBA. t Information: 1220 : 53|16:39:43.5858||UserGridView. LoadView. ID 796, Name Default. t Transfer: 1220 : 53|16:39:43.5858||GetCurrentUser.. t Transfer: 1220 : 53|16:39:43.5858|| OAuth authenticated t Transfer: 1220 : 53|16:39:43.5858|| user TMDDBA. t Transfer: 1220 : 53|16:39:43.5858||GetCurrentUser.. t Transfer: 1220 : 53|16:39:43.5858|| OAuth authenticated t Transfer: 1220 : 53|16:39:43.5858|| user TMDDBA. t Transfer: 1220 : 56|16:39:43.5858||IsUserAuthenticated: /api/view/searches/TitleSearch?_dc=1575995952959 t Transfer: 1220 : 56|16:39:43.5858||GetCurrentUser.. t Transfer: 1220 : 56|16:39:43.5858|| OAuth authenticated t Transfer: 1220 : 56|16:39:43.5858|| user TMDDBA. t Transfer: 1220 : 56|16:39:43.5858||api user: TMDDBA t Information: 1220 : 56|16:39:43.5858||GetSavedSearchNames. search type TitleSearch. t Transfer: 1220 : 56|16:39:43.5858||GetCurrentUser.. t Transfer: 1220 : 56|16:39:43.5858|| OAuth authenticated t Transfer: 1220 : 56|16:39:43.5858|| user TMDDBA. t Transfer: 1220 : 35|16:39:43.9764||IsUserAuthenticated: /api/view/searchinfo/TitleSearch?_dc=1575995952927 t Transfer: 1220 : 35|16:39:43.9764||GetCurrentUser.. t Transfer: 1220 : 35|16:39:43.9764|| OAuth authenticated t Transfer: 1220 : 35|16:39:43.9764|| user TMDDBA. t Transfer: 1220 : 35|16:39:43.9764||api user: TMDDBA t Information: 1220 : 35|16:39:43.9764||GetAdvSearchColumns. search type TitleSearch grid . t Transfer: 1220 : 44|16:39:43.9764||IsUserAuthenticated: /api/view/info/VersionGrid?lang=en-GB&_dc=1575995952969 t Transfer: 1220 : 44|16:39:43.9764||GetCurrentUser.. t Transfer: 1220 : 44|16:39:43.9764|| OAuth authenticated t Transfer: 1220 : 44|16:39:43.9764|| user TMDDBA. t Transfer: 1220 : 44|16:39:43.9764||api user: TMDDBA t Information: 1220 : 44|16:39:43.9764||GetGridViewBuilder. builder type VersionGrid. t Transfer: 1220 : 44|16:39:43.9764||GetCurrentUser.. t Transfer: 1220 : 44|16:39:43.9764|| OAuth authenticated t Transfer: 1220 : 44|16:39:43.9764|| user TMDDBA. t Transfer: 1220 : 56|16:39:43.9764||IsUserAuthenticated: /api/user-preferences?keys=adv.recent.searches.titles&_dc=1575995952932 t Transfer: 1220 : 56|16:39:43.9764||GetCurrentUser.. t Transfer: 1220 : 56|16:39:43.9764|| OAuth authenticated t Transfer: 1220 : 56|16:39:43.9764|| user TMDDBA. t Transfer: 1220 : 56|16:39:43.9764||api user: TMDDBA t Information: 1220 : 56|16:39:43.9764||GetUserDataByKeys: adv.recent.searches.titles t Transfer: 1220 : 56|16:39:43.9764||GetCurrentUser.. t Transfer: 1220 : 56|16:39:43.9764|| OAuth authenticated t Transfer: 1220 : 56|16:39:43.9764|| user TMDDBA. t Information: 1220 : 44|16:39:43.9764||UserGridView. LoadView. ID 899, Name Default. t Transfer: 1220 : 44|16:39:43.9764||GetCurrentUser.. t Transfer: 1220 : 44|16:39:43.9764|| OAuth authenticated t Transfer: 1220 : 44|16:39:43.9764|| user TMDDBA. t Transfer: 1220 : 44|16:39:43.9764||GetCurrentUser.. t Transfer: 1220 : 44|16:39:43.9764|| OAuth authenticated t Transfer: 1220 : 44|16:39:43.9764|| user TMDDBA. t Transfer: 1220 : 35|16:39:47.9139||IsUserAuthenticated: /api/SearchSuggestion/?_dc=1575995957273 t Transfer: 1220 : 35|16:39:47.9139||GetCurrentUser.. t Transfer: 1220 : 35|16:39:47.9139|| OAuth authenticated t Transfer: 1220 : 35|16:39:47.9139|| user TMDDBA. t Transfer: 1220 : 35|16:39:47.9139||api user: TMDDBA t Transfer: 1220 : 35|16:39:47.9139||GetCurrentUser.. t Transfer: 1220 : 35|16:39:47.9139|| OAuth authenticated t Transfer: 1220 : 35|16:39:47.9139|| user TMDDBA. t Transfer: 1220 : 35|16:39:48.6014||IsUserAuthenticated: /api/search/title?_dc=1575995957974 t Transfer: 1220 : 35|16:39:48.6014||GetCurrentUser.. t Transfer: 1220 : 35|16:39:48.6014|| OAuth authenticated t Transfer: 1220 : 35|16:39:48.6014|| user TMDDBA. t Transfer: 1220 : 35|16:39:48.6014||api user: TMDDBA t Information: 1220 : 35|16:39:48.6014||V3Api.SearchTitles t Information: 1220 : 35|16:39:48.6014||V3Api.SearchGeneric t Transfer: 1220 : 35|16:39:48.6014||GetCurrentUser.. t Transfer: 1220 : 35|16:39:48.6014|| OAuth authenticated t Transfer: 1220 : 35|16:39:48.6014|| user TMDDBA. t Transfer: 1220 : 35|16:39:48.6014||GetCurrentUser.. t Transfer: 1220 : 35|16:39:48.6014|| OAuth authenticated t Transfer: 1220 : 35|16:39:48.6014|| user TMDDBA. t Information: 1220 : 35|16:39:48.6171||SearchTitle SQL: with v as ( SELECT abs.* ,decode(ITEM_TYPE, 1010,SER_ABS_ID, 1020,CASE WHEN SER_ABS2_ID > 0 THEN SER_ABS2_ID ELSE SER_ABS_ID END ) xparent_id FROM TMDDBA.TM_PG_ABS abs WHERE abs.id in ( select a.id FROM TMDDBA.TM_PG_ABS a where ABS_DELETED = 0 AND (CONTAINS(CTX_TEXT_COL,'icc') > 0 OR CONTAINS(CTX_IDS_COL,'icc') > 0 ) AND ROWNUM < 25000 ) ) ,v_missing_parent_ids as ( select xparent_id from v minus select id from v ) ,v_missing_parents as ( SELECT distinct a.* ,decode(ITEM_TYPE, 1010,SER_ABS_ID, 1020,CASE WHEN SER_ABS2_ID > 0 THEN SER_ABS2_ID ELSE SER_ABS_ID END ) xparent_id FROM TMDDBA.TM_PG_ABS a START WITH ID IN (select xparent_id from v_missing_parent_ids) CONNECT BY CASE PRIOR ITEM_TYPE WHEN 1010 THEN PRIOR SER_ABS_ID WHEN 1020 THEN CASE WHEN NVL(PRIOR SER_ABS2_ID, 0) > 0 THEN PRIOR SER_ABS2_ID ELSE PRIOR SER_ABS_ID END END = ID ) ,v_all as ( select x.*, count(*) over() RowCount from ( select * from v_missing_parents union select * from v ) x ) ,v_top as ( select id from (select id, row_number()over(order by upper(ser_title),upper(title),ser_num,ser_ep_num, SER_EP_SQ_NUM ) rnk -- sort roots from v_all where xparent_id is null) where rnk between (:page_number-1)*50+1 and :page_number*50 ) ,v_tree as ( select level lvl, a.* from v_all a start with id in (select id from v_top) connect by xparent_id = prior ID order siblings by upper(ser_title),ser_num,ser_ep_num, SER_EP_SQ_NUM,upper(title) -- sort children ) select * from v_tree --where rnk <= 50 t Transfer: 1220 : 56|16:39:53.8045||IsUserAuthenticated: /api/user-preferences?_dc=1575995963170 t Transfer: 1220 : 56|16:39:53.8045||GetCurrentUser.. t Transfer: 1220 : 56|16:39:53.8045|| OAuth authenticated t Transfer: 1220 : 56|16:39:53.8045|| user TMDDBA. t Transfer: 1220 : 56|16:39:53.8045||api user: TMDDBA t Verbose: 1220 : 56|16:39:53.8045||StoreUserDataByKeys.. t Transfer: 1220 : 56|16:39:53.8045||GetCurrentUser.. t Transfer: 1220 : 56|16:39:53.8045|| OAuth authenticated t Transfer: 1220 : 56|16:39:53.8045|| user TMDDBA. t Transfer: 1220 : 35|16:39:58.9139||IsUserAuthenticated: /api/user-preferences?_dc=1575995968250 t Transfer: 1220 : 35|16:39:58.9139||GetCurrentUser.. t Transfer: 1220 : 35|16:39:58.9139|| OAuth authenticated t Transfer: 1220 : 35|16:39:58.9139|| user TMDDBA. t Transfer: 1220 : 35|16:39:58.9139||api user: TMDDBA t Verbose: 1220 : 35|16:39:58.9139||StoreUserDataByKeys.. t Transfer: 1220 : 35|16:39:58.9139||GetCurrentUser.. t Transfer: 1220 : 35|16:39:58.9139|| OAuth authenticated t Transfer: 1220 : 35|16:39:58.9139|| user TMDDBA. t Transfer: 1220 : 55|16:39:59.3358||IsUserAuthenticated: /api/int/title/298401/versions?_dc=1575995968248 t Transfer: 1220 : 55|16:39:59.3358||GetCurrentUser.. t Transfer: 1220 : 55|16:39:59.3358|| OAuth authenticated t Transfer: 1220 : 55|16:39:59.3358|| user TMDDBA. t Transfer: 1220 : 55|16:39:59.3358||api user: TMDDBA t Information: 1220 : 55|16:39:59.3358||V3Api.GetVersionsByTitleIdAdv t Information: 1220 : 55|16:39:59.3358||V3Api.SearchGeneric t Transfer: 1220 : 55|16:39:59.3358||GetCurrentUser.. t Transfer: 1220 : 55|16:39:59.3358|| OAuth authenticated t Transfer: 1220 : 55|16:39:59.3358|| user TMDDBA. t Transfer: 1220 : 55|16:39:59.3358||GetCurrentUser.. t Transfer: 1220 : 55|16:39:59.3358|| OAuth authenticated t Transfer: 1220 : 55|16:39:59.3358|| user TMDDBA. t Information: 1220 : 55|16:39:59.3358||SearchVersion SQL: select * from (select a.*, rownum rnum from ( select m.*, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID, BUILD_PGRL_FULLTITLE(item_type, title, ser_name, ser_title) FULLTITLE from tmddba.tm_pg_rl m left outer join (select text_id, text_data_path, text_data_filename, text_ref_object from tmddba.tm_text) t on t.text_id = m.primary_thumb_id where item_type>0 and rl_deleted=0 and m.PGM_ABS_ID=298401 order by m.title, m.id ) a where rownum <= 9999) r where rnum >=1 order by rnum t Information: 1220 : 55|16:39:59.3358||Running version search. User: 1 Simple Search: Running Oracle search for COUNT Oracle count completed in: 1ms. Returned lines: 0 Running Oracle search. Oracle version search timing: 3ms. SQL run: select * from (select a.*, rownum rnum from ( select m.*, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID, BUILD_PGRL_FULLTITLE(item_type, title, ser_name, ser_title) FULLTITLE from tmddba.tm_pg_rl m left outer join (select text_id, text_data_path, text_data_filename, text_ref_object from tmddba.tm_text) t on t.text_id = m.primary_thumb_id where item_type>0 and rl_deleted=0 and m.PGM_ABS_ID=298401 order by m.title, m.id ) a where rownum <= 9999) r where rnum >=1 order by rnum t Information: 1220 : 58|16:40:16.8670||GetAppInfo t Information: 1220 : 58|16:40:16.8670|| db: TMDDEMO install mode: auth types: Native, PublicApiKey t Information: 1220 : 71|17:00:54.3043||OrabitWatcherBasic. Disposing. t Information: 1220 : 71|17:00:54.3043||OrabitWatcherBasic. Disposed. t Information: 1220 : 71|17:00:54.3043||========================================================================== t Information: 1220 : 71|17:00:54.3043||IMFX CORE SERVER APPLICATION END. t Information: 1220 : 2|17:00:55.5231||OrabitWatcherBasic disposing.. t Information: 1220 : 2|17:00:55.5231||OrabitWatcherBasic disposed.