t Information: 1220 : 1|16:16:14.1640||Get Configuration Values: t Information: 1220 : 1|16:16:14.1640|| AdminPassEnc, default: , value: ffqjrn0leKv4Lj2YJHe2dw==. t Information: 1220 : 1|16:16:14.1640|| EncryptedPasswords, default: false, value: true. t Information: 1220 : 1|16:16:14.1640|| OraConnectionString, default: , value: Server=TECHM;User Id=imfx;Password=;Unicode=true;. t Information: 1220 : 1|16:16:14.1640|| SecondTimezone, default: , value: . t Information: 1220 : 1|16:16:14.1640|| UseActiveDirectoryAuth, default: false, value: false. t Information: 1220 : 1|16:16:14.1640|| ReportingServiceUrl, default: , value: http://localhost:92/ReportingService.svc. t Information: 1220 : 1|16:16:14.1796|| ReportsPath, default: , value: . t Information: 1220 : 1|16:16:14.1796|| ReportsURL, default: , value: . t Information: 1220 : 1|16:16:14.1796|| TapeServiceUrl, default: , value: . t Information: 1220 : 1|16:16:14.1796|| GatekeeperUrl, default: , value: . t Information: 1220 : 1|16:16:14.1796|| ValuationUrl, default: , value: . t Information: 1220 : 1|16:16:14.1796|| QueueManagerDelay, default: 30, value: 30. t Information: 1220 : 1|16:16:14.1796|| QueueManagerFullRefresh, default: 90, value: 90. t Information: 1220 : 1|16:16:14.1796|| AudioLoopDuration, default: 0, value: 150. t Information: 1220 : 1|16:16:14.1796|| AudioLoopsCount, default: 0, value: 0. t Information: 1220 : 1|16:16:14.1796|| PlayerFakeStep, default: 500, value: 500. t Information: 1220 : 1|16:16:14.1796|| PlayerForceRatio, default: 0, value: 1. t Information: 1220 : 1|16:16:14.1796|| CheckVersionsInProd, default: false, value: True. t Information: 1220 : 1|16:16:14.1796|| MaxResults, default: 3000, value: 10000. t Information: 1220 : 1|16:16:14.1796|| NetworkRestriction, default: false, value: True. t Information: 1220 : 1|16:16:14.1796|| TEReportID, default: 0, value: 0. t Information: 1220 : 1|16:16:14.1796|| ClosedCaptionsCache, default: , value: C:\inetpub\wwwroot\imfxcore\timedtextcache\. t Information: 1220 : 1|16:16:14.1796|| ClosedCaptionsStorage, default: , value: c:\Mediaflex\subs. t Information: 1220 : 1|16:16:14.1796|| TimeCodeFormat, default: , value: pal. t Information: 1220 : 1|16:16:14.1796|| RceMediaPath, default: , value: C:\edl\. t Information: 1220 : 1|16:16:14.1796|| RceMediaPath, default: , value: C:\edl\. t Information: 1220 : 1|16:16:14.1796|| RceCsmOutputPath, default: , value: C:\Inetpub\wwwroot\csm\. t Information: 1220 : 1|16:16:14.1796|| RceCsmUrl, default: , value: http://localhost/csm/. t Information: 1220 : 1|16:16:14.1796|| RceMediaSelection, default: , value: miLinkIdMatch. t Information: 1220 : 1|16:16:14.1796|| RequestBrowseJobPresetName, default: , value: . t Information: 1220 : 1|16:16:14.1796|| DontExtendDuration, default: false, value: False. t Information: 1220 : 1|16:16:14.1796|| V3ConfigUrl, default: , value: . t Information: 1220 : 1|16:16:14.1796|| ApiServer, default: , value: http://192.168.120.10:85. t Information: 1220 : 1|16:16:14.1796|| StopWords, default: , value: . t Information: 1220 : 1|16:16:14.1796|| MisrTxFormat, default: G, value: G. t Information: 1220 : 1|16:16:14.1796|| ThumbnailServer, default: , value: . t Information: 1220 : 1|16:16:14.1796|| LocationFilter, default: , value: . t Information: 1220 : 1|16:16:14.1796|| SvUtilServiceUrl, default: , value: . t Information: 1220 : 1|16:16:14.1796|| SolrConnection, default: , value: http://192.168.120.14:8983/solr. t Information: 1220 : 1|16:16:14.1796|| UseIndexServerSearch, default: false, value: True. t Information: 1220 : 1|16:16:14.1796|| SolrIndexVersion, default: 1, value: 6. t Information: 1220 : 1|16:16:14.1796|| SolrConnection, default: , value: http://192.168.120.14:8983/solr. t Information: 1220 : 1|16:16:14.1796|| FacetsGroups, default: , value: owners,season_id, series_id,version_key,item_type,media_type,media_format,episode_number. t Information: 1220 : 1|16:16:14.1796|| FacetsGroupsVersion, default: , value: owners,season_id, series_id,version_key,episode_number. t Information: 1220 : 1|16:16:14.1796|| FacetsGroupsChameleon, default: , value: season_id, series_id,genre,prod_year,version_key. t Information: 1220 : 1|16:16:14.1796|| PreviewPreset, default: , value: . t Information: 1220 : 1|16:16:14.1796|| DevMode, default: false, value: false. t Information: 1220 : 1|16:16:14.1796|| DisableSysMan, default: false, value: false. t Information: 1220 : 1|16:16:14.1796|| TimeCodeFormat, default: , value: pal. t Information: 1220 : 1|16:16:14.1796|| FileCatalystStorageDevice, default: , value: . t Information: 1220 : 1|16:16:14.1796|| UseResponsibilityTracking, default: true, value: True. t Information: 1220 : 1|16:16:14.1796|| SubtitleDeviceFilter, default: , value: . t Information: 1220 : 1|16:16:14.1796|| SystemMonitorNamedPipe, default: , value: . t Information: 1220 : 1|16:16:14.1796|| OracleMonitorEnable, default: false, value: False. t Information: 1220 : 1|16:16:14.1796|| ArcApiHost, default: , value: . t Information: 1220 : 1|16:16:14.1796|| RabbitMqUrl, default: , value: amqp://192.168.120.14:5672. t Information: 1220 : 1|16:16:14.1796|| SolrTimedTextSearch, default: false, value: false. t Information: 1220 : 1|16:16:14.1796|| ProductionDurationUsageID, default: 1, value: 1. t Information: 1220 : 1|16:16:14.4296||GetStreamServers.. t Information: 1220 : 1|16:16:14.6952|| https://demo.tmd.tv/CBR Video/ |CBR Video| False t Information: 1220 : 1|16:16:14.6952|| https://demo.tmd.tv/CBR Images/ |CBR Images| False t Information: 1220 : 1|16:16:14.6952|| https://demo.tmd.tv/CBR Audio/ |CBR Audio| False t Information: 1220 : 1|16:16:14.6952|| https://demo.tmd.tv/Temp Upload/ |TEMP_UPLOAD| False t Information: 1220 : 1|16:16:14.6952|| http://localhost:82/images/ |IMAGES| False t Information: 1220 : 1|16:16:14.6952|| http://192.168.91.73/smoothcloud/ |SMOOTH_CLOUD| False t Information: 1220 : 1|16:16:14.6952|| http://192.168.91.73/cloudstore/ |CLOUD_STORE| False t Information: 1220 : 1|16:16:14.6952|| http://192.168.91.73/editsystemin/ |EDIT_SYSTEM_IN| False t Information: 1220 : 1|16:16:14.6952|| http://192.168.91.27:89/APPLEPROXY/ |APPLE_PROXY| False t Information: 1220 : 1|16:16:14.6952|| http://localhost:82/video/ |FILESTORE_VIDEO| False t Information: 1220 : 1|16:16:14.6952|| https://imfxv3tm.tmd.tv/streaming/ |Streaming| False t Information: 1220 : 1|16:16:14.6952|| https://imfxv3tm.tmd.tv/VideoServer/ |Video| False t Information: 1220 : 1|16:16:14.6952|| https://imfxv3tm.tmd.tv/AdobeIn/ |Adobe Premiere Pro In| False t Information: 1220 : 1|16:16:14.6952|| https://imfxv3tm.tmd.tv/AudioServer/ |Audio| False t Information: 1220 : 1|16:16:14.6952|| https://imfxv3tm.tmd.tv/ImageServer/ |Image| False t Information: 1220 : 1|16:16:14.6952|| https://imfxv3tm.tmd.tv/DocsServer/ |Docs| False t Information: 1220 : 1|16:16:14.6952|| https://imfxv3tm.tmd.tv/AmazonLabs/ |TEST HOUSE| False t Information: 1220 : 1|16:16:14.6952|| SolrConnectionUms, default: http://192.168.120.14:8983/solr, value: http://192.168.120.14:8983/solr. t Information: 1220 : 1|16:16:14.6952|| ApiLog, default: false, value: false. t Information: 1220 : 1|16:16:14.6952|| EmbeddedRceUrl, default: , value: . t Information: 1220 : 1|16:16:14.6952|| InstallMode, default: , value: . t Information: 1220 : 1|16:16:14.6952|| SamlRequestAddress, default: , value: . t Information: 1220 : 1|16:16:14.6952|| SamlTrustedIssuer, default: , value: . t Information: 1220 : 1|16:16:14.6952|| SamlLoginRedirect, default: , value: . t Information: 1220 : 1|16:16:14.6952|| NaturalLangSearch, default: false, value: True. t Information: 1220 : 1|16:16:14.6952|| OktaLoginField, default: , value: . t Information: 1220 : 1|16:16:14.6952|| AuthenticationTypes, default: , value: Native,PublicApiKey. t Information: 1220 : 1|16:16:14.7108||OrabitWatcherBasic. Initialize. t Information: 1220 : 1|16:16:14.7890||FillDictionaryCache. t Information: 1220 : 1|16:16:18.1171||GetSupportedOperators t Information: 1220 : 11|16:16:18.3671||CacheTechReports. t Information: 1220 : 1|16:16:18.4609||& Cache update. Server (global) filled with timestamp 04:12:18.4452700. types null t Information: 1220 : 1|16:16:18.5077||InitializeFromDatabase. 'Server=TECHM;User Id=imfx;password=..;Unicode=true;' direct False, home , timeout 15 t Information: 1220 : 1|16:16:18.5077||FillDictionaryCache. t Information: 1220 : 1|16:16:18.5234||& Cache update. Server (global) filled with timestamp 04:12:18.5234046. types FriendlyNames, DatabaseSearchFieldData t Information: 1220 : 1|16:16:18.8515||========================================================================== t Information: 1220 : 1|16:16:18.8515||IMFX CORE SERVER APPLICATION START. t Information: 1220 : 1|16:16:18.8515||DLL VERSION: 2.5.0.2322. t Information: 1220 : 11|16:16:18.8671|| UmsDev, default: False, value: False. t Information: 1220 : 1|16:16:18.9452|| ApiLog, default: false, value: false. t Information: 1220 : 12|16:16:19.7265||OrabitWatcherBasic trying to connect.. t Information: 1220 : 12|16:16:19.7265||OrabitWatcherBasic connected. t Information: 1220 : 12|16:16:19.7421||OrabitWatcherBasic queue created tmd.cfg.in.7210f670-9170-4071-ae4b-9222d3c718a8 t Transfer: 1220 : 12|16:16:20.0703||IsUserAuthenticated: /api/view/searches/TitleSearch?_dc=1576167376269 t Transfer: 1220 : 11|16:16:20.0703||IsUserAuthenticated: /api/view/info/VersionGrid?lang=en-US&_dc=1576167376278 t Transfer: 1220 : 13|16:16:20.0703||IsUserAuthenticated: /api/versionvideo/298376?_dc=1576167372785 t Transfer: 1220 : 18|16:16:20.0703||IsUserAuthenticated: /api/view/info/MediaGrid?lang=en-US&_dc=1576167376331 t Transfer: 1220 : 12|16:16:20.0703||GetCurrentUser.. t Transfer: 1220 : 13|16:16:20.0703||GetCurrentUser.. t Transfer: 1220 : 13|16:16:20.0703|| OAuth authenticated t Transfer: 1220 : 13|16:16:20.0703|| user TONY. t Transfer: 1220 : 18|16:16:20.0703||GetCurrentUser.. t Transfer: 1220 : 18|16:16:20.0703|| OAuth authenticated t Transfer: 1220 : 18|16:16:20.0703|| user TONY. t Transfer: 1220 : 18|16:16:20.0703||api user: TONY t Transfer: 1220 : 13|16:16:20.0703||api user: TONY t Transfer: 1220 : 11|16:16:20.0703||GetCurrentUser.. t Transfer: 1220 : 11|16:16:20.0703|| OAuth authenticated t Transfer: 1220 : 11|16:16:20.0703|| user TONY. t Transfer: 1220 : 11|16:16:20.0703||api user: TONY t Transfer: 1220 : 12|16:16:20.0703|| OAuth authenticated t Transfer: 1220 : 12|16:16:20.0703|| user TONY. t Transfer: 1220 : 12|16:16:20.0703||api user: TONY t Information: 1220 : 11|16:16:20.1171||GetGridViewBuilder. builder type VersionGrid. t Information: 1220 : 18|16:16:20.1171||GetGridViewBuilder. builder type MediaGrid. t Information: 1220 : 12|16:16:20.1171||GetSavedSearchNames. search type TitleSearch. t Transfer: 1220 : 12|16:16:20.1171||GetCurrentUser.. t Transfer: 1220 : 12|16:16:20.1171|| OAuth authenticated t Transfer: 1220 : 12|16:16:20.1171|| user TONY. t Transfer: 1220 : 11|16:16:20.1171||GetCurrentUser.. t Transfer: 1220 : 18|16:16:20.1171||GetCurrentUser.. t Transfer: 1220 : 18|16:16:20.1171|| OAuth authenticated t Transfer: 1220 : 18|16:16:20.1171|| user TONY. t Transfer: 1220 : 11|16:16:20.1171|| OAuth authenticated t Transfer: 1220 : 11|16:16:20.1171|| user TONY. t Transfer: 1220 : 13|16:16:20.1171||GetCurrentUser.. t Transfer: 1220 : 13|16:16:20.1171|| OAuth authenticated t Transfer: 1220 : 13|16:16:20.1171|| user TONY. t Information: 1220 : 11|16:16:20.1640||UserGridView. LoadView. ID -1, Name Default. t Transfer: 1220 : 11|16:16:20.1640||GetCurrentUser.. t Transfer: 1220 : 11|16:16:20.1796|| OAuth authenticated t Transfer: 1220 : 11|16:16:20.1796|| user TONY. t Transfer: 1220 : 11|16:16:20.2109||GetCurrentUser.. t Transfer: 1220 : 11|16:16:20.2109|| OAuth authenticated t Transfer: 1220 : 11|16:16:20.2109|| user TONY. t Information: 1220 : 18|16:16:20.2109||UserGridView. LoadView. ID 1282, Name Default. t Transfer: 1220 : 18|16:16:20.2109||GetCurrentUser.. t Transfer: 1220 : 18|16:16:20.2109|| OAuth authenticated t Transfer: 1220 : 18|16:16:20.2109|| user TONY. t Transfer: 1220 : 18|16:16:20.2109||GetCurrentUser.. t Transfer: 1220 : 18|16:16:20.2109|| OAuth authenticated t Transfer: 1220 : 18|16:16:20.2109|| user TONY. t Transfer: 1220 : 22|16:16:20.3671||IsUserAuthenticated: /api/user-preferences?keys=adv.recent.searches.titles&_dc=1576167376230 t Transfer: 1220 : 22|16:16:20.3671||GetCurrentUser.. t Transfer: 1220 : 22|16:16:20.3671|| OAuth authenticated t Transfer: 1220 : 22|16:16:20.3671|| user TONY. t Transfer: 1220 : 22|16:16:20.3671||api user: TONY t Information: 1220 : 22|16:16:20.3671||GetUserDataByKeys: adv.recent.searches.titles t Transfer: 1220 : 22|16:16:20.3671||GetCurrentUser.. t Transfer: 1220 : 22|16:16:20.3671|| OAuth authenticated t Transfer: 1220 : 22|16:16:20.3671|| user TONY. t Verbose: 1220 : 13|16:16:20.3828||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 : 13|16:16:20.3828|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Australia vs England Short Semi Final 2.mp4 t Verbose: 1220 : 13|16:16:20.3828||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/Australia vs England Short Semi Final 2.mp4 t Transfer: 1220 : 13|16:16:20.3828||GetCurrentUser.. t Transfer: 1220 : 13|16:16:20.3828|| OAuth authenticated t Transfer: 1220 : 13|16:16:20.3828|| user TONY. t Transfer: 1220 : 22|16:16:20.5077||IsUserAuthenticated: /api/view/searchinfo/TitleSearch?_dc=1576167376226 t Transfer: 1220 : 22|16:16:20.5077||GetCurrentUser.. t Transfer: 1220 : 22|16:16:20.5077|| OAuth authenticated t Transfer: 1220 : 22|16:16:20.5077|| user TONY. t Transfer: 1220 : 22|16:16:20.5077||api user: TONY t Information: 1220 : 22|16:16:20.5077||GetAdvSearchColumns. search type TitleSearch grid . t Transfer: 1220 : 12|16:16:20.5234||IsUserAuthenticated: /api/lookups/SearchSupportedOperators?_dc=1576167376227 t Transfer: 1220 : 12|16:16:20.5234||GetCurrentUser.. t Transfer: 1220 : 12|16:16:20.5234|| OAuth authenticated t Transfer: 1220 : 12|16:16:20.5234|| user TONY. t Transfer: 1220 : 12|16:16:20.5234||api user: TONY t Transfer: 1220 : 11|16:16:20.5234||IsUserAuthenticated: /api/view/info/TitleTree?lang=en-US&_dc=1576167376243 t Transfer: 1220 : 11|16:16:20.5234||GetCurrentUser.. t Transfer: 1220 : 11|16:16:20.5234|| OAuth authenticated t Transfer: 1220 : 11|16:16:20.5234|| user TONY. t Transfer: 1220 : 11|16:16:20.5234||api user: TONY t Information: 1220 : 11|16:16:20.5234||GetGridViewBuilder. builder type TitleTree. t Transfer: 1220 : 11|16:16:20.5234||GetCurrentUser.. t Transfer: 1220 : 11|16:16:20.5234|| OAuth authenticated t Transfer: 1220 : 11|16:16:20.5234|| user TONY. t Information: 1220 : 11|16:16:20.5234||UserGridView. LoadView. ID 1281, Name Default. t Transfer: 1220 : 11|16:16:20.5234||GetCurrentUser.. t Transfer: 1220 : 11|16:16:20.5234|| OAuth authenticated t Transfer: 1220 : 11|16:16:20.5234|| user TONY. t Transfer: 1220 : 11|16:16:20.5390||GetCurrentUser.. t Transfer: 1220 : 11|16:16:20.5390|| OAuth authenticated t Transfer: 1220 : 11|16:16:20.5390|| user TONY. t Transfer: 1220 : 18|16:16:20.5390||IsUserAuthenticated: /api/SearchSuggestion/?_dc=1576167379588 t Transfer: 1220 : 18|16:16:20.5390||GetCurrentUser.. t Transfer: 1220 : 18|16:16:20.5390|| OAuth authenticated t Transfer: 1220 : 18|16:16:20.5390|| user TONY. t Transfer: 1220 : 18|16:16:20.5390||api user: TONY t Transfer: 1220 : 11|16:16:20.5546||IsUserAuthenticated: /api/search/title?_dc=1576167379790 t Transfer: 1220 : 11|16:16:20.5546||GetCurrentUser.. t Transfer: 1220 : 11|16:16:20.5546|| OAuth authenticated t Transfer: 1220 : 11|16:16:20.5546|| user TONY. t Transfer: 1220 : 11|16:16:20.5546||api user: TONY t Transfer: 1220 : 18|16:16:20.6640||GetCurrentUser.. t Transfer: 1220 : 18|16:16:20.6640|| OAuth authenticated t Transfer: 1220 : 18|16:16:20.6640|| user TONY. t Information: 1220 : 11|16:16:20.6796||V3Api.SearchTitles t Information: 1220 : 11|16:16:20.6796||V3Api.SearchGeneric t Transfer: 1220 : 11|16:16:20.6952||GetCurrentUser.. t Transfer: 1220 : 11|16:16:20.6952|| OAuth authenticated t Transfer: 1220 : 11|16:16:20.6952|| user TONY. t Transfer: 1220 : 11|16:16:20.6952||GetCurrentUser.. t Transfer: 1220 : 11|16:16:20.6952|| OAuth authenticated t Transfer: 1220 : 11|16:16:20.6952|| user TONY. t Information: 1220 : 11|16:16:20.6952||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 : 18|16:16:21.1171||IsUserAuthenticated: /api/user-preferences?_dc=1576167381325 t Transfer: 1220 : 18|16:16:21.1171||GetCurrentUser.. t Transfer: 1220 : 18|16:16:21.1171|| OAuth authenticated t Transfer: 1220 : 18|16:16:21.1171|| user TONY. t Transfer: 1220 : 18|16:16:21.1171||api user: TONY t Transfer: 1220 : 22|16:16:21.1171||IsUserAuthenticated: /api/int/title/298401/versions?_dc=1576167381323 t Transfer: 1220 : 22|16:16:21.1171||GetCurrentUser.. t Transfer: 1220 : 22|16:16:21.1171|| OAuth authenticated t Transfer: 1220 : 22|16:16:21.1171|| user TONY. t Transfer: 1220 : 22|16:16:21.1171||api user: TONY t Verbose: 1220 : 18|16:16:21.1171||StoreUserDataByKeys.. t Transfer: 1220 : 18|16:16:21.1171||GetCurrentUser.. t Transfer: 1220 : 18|16:16:21.1171|| OAuth authenticated t Transfer: 1220 : 18|16:16:21.1171|| user TONY. t Information: 1220 : 22|16:16:21.1171||V3Api.GetVersionsByTitleIdAdv t Information: 1220 : 22|16:16:21.1171||V3Api.SearchGeneric t Transfer: 1220 : 22|16:16:21.1327||GetCurrentUser.. t Transfer: 1220 : 22|16:16:21.1327|| OAuth authenticated t Transfer: 1220 : 22|16:16:21.1327|| user TONY. t Transfer: 1220 : 22|16:16:21.1327||GetCurrentUser.. t Transfer: 1220 : 22|16:16:21.1327|| OAuth authenticated t Transfer: 1220 : 22|16:16:21.1327|| user TONY. t Information: 1220 : 22|16:16:21.1483||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 : 22|16:16:21.1483||Running version search. User: 522 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 Transfer: 1220 : 13|16:16:23.0389||IsUserAuthenticated: /api/int/title/298443/versions?_dc=1576167383255 t Transfer: 1220 : 13|16:16:23.0389||GetCurrentUser.. t Transfer: 1220 : 13|16:16:23.0389|| OAuth authenticated t Transfer: 1220 : 13|16:16:23.0389|| user TONY. t Transfer: 1220 : 13|16:16:23.0389||api user: TONY t Information: 1220 : 13|16:16:23.0389||V3Api.GetVersionsByTitleIdAdv t Information: 1220 : 13|16:16:23.0389||V3Api.SearchGeneric t Transfer: 1220 : 13|16:16:23.0389||GetCurrentUser.. t Transfer: 1220 : 13|16:16:23.0389|| OAuth authenticated t Transfer: 1220 : 13|16:16:23.0389|| user TONY. t Transfer: 1220 : 13|16:16:23.0389||GetCurrentUser.. t Transfer: 1220 : 13|16:16:23.0389|| OAuth authenticated t Transfer: 1220 : 13|16:16:23.0389|| user TONY. t Information: 1220 : 13|16:16:23.0546||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 : 13|16:16:23.0546||Running version search. User: 522 Simple Search: Running Oracle search for COUNT Oracle count completed in: 1ms. Returned lines: 1 Running Oracle search. Oracle version search timing: 4ms. 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 : 13|16:16:23.1171||IsUserAuthenticated: /api/int/version/298444/media?_dc=1576167383334 t Transfer: 1220 : 13|16:16:23.1171||GetCurrentUser.. t Transfer: 1220 : 13|16:16:23.1171|| OAuth authenticated t Transfer: 1220 : 13|16:16:23.1171|| user TONY. t Transfer: 1220 : 13|16:16:23.1171||api user: TONY t Information: 1220 : 13|16:16:23.1171||V3Api.GetMediaByVersionIdAdv t Information: 1220 : 13|16:16:23.1171||V3Api.SearchGeneric t Transfer: 1220 : 13|16:16:23.1483||GetCurrentUser.. t Transfer: 1220 : 13|16:16:23.1483|| OAuth authenticated t Transfer: 1220 : 13|16:16:23.1483|| user TONY. t Information: 1220 : 13|16:16:23.1483||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 : 13|16:16:23.2265|| timing: 00:00:00.0838734 t Verbose: 1220 : 13|16:16:23.3827||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\England v Bangladesh Match Group A.mp4 subfolder t Verbose: 1220 : 13|16:16:23.3827|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/England v Bangladesh Match Group A.mp4 t Verbose: 1220 : 13|16:16:23.3827||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/England v Bangladesh Match Group A.mp4 t Transfer: 1220 : 13|16:16:23.3827||GetCurrentUser.. t Transfer: 1220 : 13|16:16:23.3827|| OAuth authenticated t Transfer: 1220 : 13|16:16:23.3827|| user TONY. t Transfer: 1220 : 11|16:16:29.7421||IsUserAuthenticated: /api/title-details/298439?_dc=1576167389955 t Transfer: 1220 : 11|16:16:29.7421||GetCurrentUser.. t Transfer: 1220 : 11|16:16:29.7421|| OAuth authenticated t Transfer: 1220 : 11|16:16:29.7421|| user TONY. t Transfer: 1220 : 11|16:16:29.7421||api user: TONY t Transfer: 1220 : 23|16:16:29.8358||IsUserAuthenticated: /api/v3/detailsview/TitleDetails/0?lang=en-US&_dc=1576167390036 t Transfer: 1220 : 23|16:16:29.8358||GetCurrentUser.. t Transfer: 1220 : 23|16:16:29.8358|| OAuth authenticated t Transfer: 1220 : 23|16:16:29.8358|| user TONY. t Transfer: 1220 : 23|16:16:29.8358||api user: TONY t Transfer: 1220 : 11|16:16:30.0233||IsUserAuthenticated: /api/search/title?_dc=1576167390242 t Transfer: 1220 : 11|16:16:30.0233||GetCurrentUser.. t Transfer: 1220 : 11|16:16:30.0233|| OAuth authenticated t Transfer: 1220 : 11|16:16:30.0233|| user TONY. t Transfer: 1220 : 11|16:16:30.0233||api user: TONY t Information: 1220 : 11|16:16:30.0390||V3Api.SearchTitles t Information: 1220 : 11|16:16:30.0390||V3Api.SearchGeneric t Transfer: 1220 : 11|16:16:30.0390||GetCurrentUser.. t Transfer: 1220 : 11|16:16:30.0390|| OAuth authenticated t Transfer: 1220 : 11|16:16:30.0390|| user TONY. t Transfer: 1220 : 11|16:16:30.0390||GetCurrentUser.. t Transfer: 1220 : 11|16:16:30.0390|| OAuth authenticated t Transfer: 1220 : 11|16:16:30.0390|| user TONY. t Information: 1220 : 11|16:16:30.0390||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('298439') 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 : 12|16:16:30.0390||IsUserAuthenticated: /api/lookups/FriendlyNames?_dc=1576167390259 t Transfer: 1220 : 12|16:16:30.0390||GetCurrentUser.. t Transfer: 1220 : 12|16:16:30.0390|| OAuth authenticated t Transfer: 1220 : 12|16:16:30.0390|| user TONY. t Transfer: 1220 : 12|16:16:30.0390||api user: TONY t Transfer: 1220 : 23|16:16:30.1640||IsUserAuthenticated: /api/search/title?_dc=1576167390369 t Transfer: 1220 : 23|16:16:30.1640||GetCurrentUser.. t Transfer: 1220 : 23|16:16:30.1640|| OAuth authenticated t Transfer: 1220 : 23|16:16:30.1640|| user TONY. t Transfer: 1220 : 23|16:16:30.1640||api user: TONY t Information: 1220 : 23|16:16:30.1640||V3Api.SearchTitles t Information: 1220 : 23|16:16:30.1640||V3Api.SearchGeneric t Transfer: 1220 : 23|16:16:30.1640||GetCurrentUser.. t Transfer: 1220 : 23|16:16:30.1640|| OAuth authenticated t Transfer: 1220 : 23|16:16:30.1640|| user TONY. t Transfer: 1220 : 23|16:16:30.1640||GetCurrentUser.. t Transfer: 1220 : 23|16:16:30.1640|| OAuth authenticated t Transfer: 1220 : 23|16:16:30.1640|| user TONY. t Information: 1220 : 23|16:16:30.1640||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('298439') 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 : 18|16:16:47.0233||IsUserAuthenticated: /api/user-preferences?keys=adv.recent.searches.media&_dc=1576167407239 t Transfer: 1220 : 18|16:16:47.0233||GetCurrentUser.. t Transfer: 1220 : 18|16:16:47.0233|| OAuth authenticated t Transfer: 1220 : 18|16:16:47.0233|| user TONY. t Transfer: 1220 : 18|16:16:47.0233||api user: TONY t Information: 1220 : 18|16:16:47.0233||GetUserDataByKeys: adv.recent.searches.media t Transfer: 1220 : 18|16:16:47.0233||GetCurrentUser.. t Transfer: 1220 : 18|16:16:47.0233|| OAuth authenticated t Transfer: 1220 : 18|16:16:47.0233|| user TONY. t Transfer: 1220 : 13|16:16:47.0233||IsUserAuthenticated: /api/view/searchinfo/Media?_dc=1576167407237 t Transfer: 1220 : 13|16:16:47.0233||GetCurrentUser.. t Transfer: 1220 : 13|16:16:47.0233|| OAuth authenticated t Transfer: 1220 : 13|16:16:47.0233|| user TONY. t Transfer: 1220 : 13|16:16:47.0233||api user: TONY t Information: 1220 : 13|16:16:47.0233||GetAdvSearchColumns. search type Media grid . t Transfer: 1220 : 23|16:16:47.0233||IsUserAuthenticated: /api/settings/user/searchLayoutConfig?_dc=1576167407241 t Transfer: 1220 : 23|16:16:47.0233||GetCurrentUser.. t Transfer: 1220 : 23|16:16:47.0233|| OAuth authenticated t Transfer: 1220 : 23|16:16:47.0233|| user TONY. t Transfer: 1220 : 23|16:16:47.0233||api user: TONY t Information: 1220 : 23|16:16:47.0233||V3Api.GetUserSettings t Transfer: 1220 : 23|16:16:47.0233||GetCurrentUser.. t Transfer: 1220 : 23|16:16:47.0233|| OAuth authenticated t Transfer: 1220 : 23|16:16:47.0233|| user TONY. t Transfer: 1220 : 11|16:16:47.0546||IsUserAuthenticated: /api/view/searches/Media?_dc=1576167407274 t Transfer: 1220 : 11|16:16:47.0546||GetCurrentUser.. t Transfer: 1220 : 11|16:16:47.0546|| OAuth authenticated t Transfer: 1220 : 11|16:16:47.0546|| user TONY. t Transfer: 1220 : 11|16:16:47.0546||api user: TONY t Information: 1220 : 11|16:16:47.0546||GetSavedSearchNames. search type Media. t Transfer: 1220 : 11|16:16:47.0546||GetCurrentUser.. t Transfer: 1220 : 11|16:16:47.0546|| OAuth authenticated t Transfer: 1220 : 11|16:16:47.0546|| user TONY. t Transfer: 1220 : 23|16:16:51.3671||IsUserAuthenticated: /api/SearchSuggestion/?_dc=1576167411564 t Transfer: 1220 : 23|16:16:51.3671||GetCurrentUser.. t Transfer: 1220 : 23|16:16:51.3671|| OAuth authenticated t Transfer: 1220 : 23|16:16:51.3671|| user TONY. t Transfer: 1220 : 23|16:16:51.3671||api user: TONY t Transfer: 1220 : 23|16:16:51.3671||GetCurrentUser.. t Transfer: 1220 : 23|16:16:51.3671|| OAuth authenticated t Transfer: 1220 : 23|16:16:51.3671|| user TONY. t Transfer: 1220 : 18|16:16:51.4921||IsUserAuthenticated: /api/search/Media?_dc=1576167411716 t Transfer: 1220 : 18|16:16:51.4921||GetCurrentUser.. t Transfer: 1220 : 18|16:16:51.4921|| OAuth authenticated t Transfer: 1220 : 18|16:16:51.4921|| user TONY. t Transfer: 1220 : 18|16:16:51.4921||api user: TONY t Information: 1220 : 18|16:16:51.5077||V3Api.SearchMedia t Information: 1220 : 18|16:16:51.5389||V3Api.SearchGeneric t Transfer: 1220 : 18|16:16:51.5702||GetCurrentUser.. t Transfer: 1220 : 18|16:16:51.5702|| OAuth authenticated t Transfer: 1220 : 18|16:16:51.5702|| user TONY. t Information: 1220 : 18|16:16:51.6327||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 : 18|16:16:51.6796|| timing: 00:00:00.1311644 t Verbose: 1220 : 18|16:16:51.6796||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\England v Bangladesh Match Group A.mp4 subfolder t Verbose: 1220 : 18|16:16:51.6796|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/England v Bangladesh Match Group A.mp4 t Verbose: 1220 : 18|16:16:51.6796||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/England v Bangladesh Match Group A.mp4 t Transfer: 1220 : 18|16:16:51.6796||GetCurrentUser.. t Transfer: 1220 : 18|16:16:51.6796|| OAuth authenticated t Transfer: 1220 : 18|16:16:51.6796|| user TONY. t Verbose: 1220 : 18|16:16:51.6796||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\ICC 360 Cricket for Change.mp4 subfolder t Verbose: 1220 : 18|16:16:51.6796|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/ICC 360 Cricket for Change.mp4 t Verbose: 1220 : 18|16:16:51.6796||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/ICC 360 Cricket for Change.mp4 t Transfer: 1220 : 18|16:16:51.6796||GetCurrentUser.. t Transfer: 1220 : 18|16:16:51.6796|| OAuth authenticated t Transfer: 1220 : 18|16:16:51.6796|| user TONY. t Verbose: 1220 : 18|16:16:51.6796||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Australia vs South Africa Match 45.mp4 subfolder t Verbose: 1220 : 18|16:16:51.6796|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Australia vs South Africa Match 45.mp4 t Verbose: 1220 : 18|16:16:51.6796||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/Australia vs South Africa Match 45.mp4 t Transfer: 1220 : 18|16:16:51.6796||GetCurrentUser.. t Transfer: 1220 : 18|16:16:51.6796|| OAuth authenticated t Transfer: 1220 : 18|16:16:51.6796|| user TONY. t Verbose: 1220 : 18|16:16:51.6796||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\England vs South Africa Match 1.mp4 subfolder t Verbose: 1220 : 18|16:16:51.6796|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/England vs South Africa Match 1.mp4 t Verbose: 1220 : 18|16:16:51.6796||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/England vs South Africa Match 1.mp4 t Transfer: 1220 : 18|16:16:51.6796||GetCurrentUser.. t Transfer: 1220 : 18|16:16:51.6796|| OAuth authenticated t Transfer: 1220 : 18|16:16:51.6796|| user TONY. t Verbose: 1220 : 18|16:16:51.6796||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\West Indies vs Pakistan Match 2.mp4 subfolder t Verbose: 1220 : 18|16:16:51.6796|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/West Indies vs Pakistan Match 2.mp4 t Verbose: 1220 : 18|16:16:51.6796||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/West Indies vs Pakistan Match 2.mp4 t Transfer: 1220 : 18|16:16:51.6796||GetCurrentUser.. t Transfer: 1220 : 18|16:16:51.6796|| OAuth authenticated t Transfer: 1220 : 18|16:16:51.6796|| user TONY. t Verbose: 1220 : 18|16:16:51.6796||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\New Zealand vs England Final.mp4 subfolder t Verbose: 1220 : 18|16:16:51.6796|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/New Zealand vs England Final.mp4 t Verbose: 1220 : 18|16:16:51.6796||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/New Zealand vs England Final.mp4 t Transfer: 1220 : 18|16:16:51.6796||GetCurrentUser.. t Transfer: 1220 : 18|16:16:51.6796|| OAuth authenticated t Transfer: 1220 : 18|16:16:51.6796|| user TONY. t Verbose: 1220 : 18|16:16:51.6796||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 : 18|16:16:51.6796|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Australia vs England Short Semi Final 2.mp4 t Verbose: 1220 : 18|16:16:51.6796||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/Australia vs England Short Semi Final 2.mp4 t Transfer: 1220 : 18|16:16:51.6796||GetCurrentUser.. t Transfer: 1220 : 18|16:16:51.6796|| OAuth authenticated t Transfer: 1220 : 18|16:16:51.6796|| user TONY. t Verbose: 1220 : 18|16:16:51.6796||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 : 18|16:16:51.6796|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/India vs New Zealand Semi Final 1.mp4 t Verbose: 1220 : 18|16:16:51.6796||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/India vs New Zealand Semi Final 1.mp4 t Transfer: 1220 : 18|16:16:51.6796||GetCurrentUser.. t Transfer: 1220 : 18|16:16:51.6796|| OAuth authenticated t Transfer: 1220 : 18|16:16:51.6796|| user TONY. t Verbose: 1220 : 18|16:16:51.6952||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 : 18|16:16:51.6952|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Scotland vs Oman 5th Place Play Off.mp4 t Verbose: 1220 : 18|16:16:51.6952||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/Scotland vs Oman 5th Place Play Off.mp4 t Transfer: 1220 : 18|16:16:51.6952||GetCurrentUser.. t Transfer: 1220 : 18|16:16:51.6952|| OAuth authenticated t Transfer: 1220 : 18|16:16:51.6952|| user TONY. t Verbose: 1220 : 18|16:16:51.6952||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\South Africa vs Bangladesh Match 5 .mp4 subfolder t Verbose: 1220 : 18|16:16:51.6952|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/South Africa vs Bangladesh Match 5 .mp4 t Verbose: 1220 : 18|16:16:51.6952||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/South Africa vs Bangladesh Match 5 .mp4 t Transfer: 1220 : 18|16:16:51.6952||GetCurrentUser.. t Transfer: 1220 : 18|16:16:51.6952|| OAuth authenticated t Transfer: 1220 : 18|16:16:51.6952|| user TONY. t Verbose: 1220 : 18|16:16:51.6952||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 : 18|16:16:51.6952|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/New Zealand vs Sri Lanka Match 3.mp4 t Verbose: 1220 : 18|16:16:51.6952||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/New Zealand vs Sri Lanka Match 3.mp4 t Transfer: 1220 : 18|16:16:51.6952||GetCurrentUser.. t Transfer: 1220 : 18|16:16:51.6952|| OAuth authenticated t Transfer: 1220 : 18|16:16:51.6952|| user TONY. t Verbose: 1220 : 18|16:16:51.6952||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Afghanistan vs Australia Match 4.mp4 subfolder t Verbose: 1220 : 18|16:16:51.6952|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Afghanistan vs Australia Match 4.mp4 t Verbose: 1220 : 18|16:16:51.6952||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/Afghanistan vs Australia Match 4.mp4 t Transfer: 1220 : 18|16:16:51.6952||GetCurrentUser.. t Transfer: 1220 : 18|16:16:51.6952|| OAuth authenticated t Transfer: 1220 : 18|16:16:51.6952|| user TONY. t Verbose: 1220 : 18|16:16:51.6952||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Bangladesh vs New Zealand Match 9.mp4 subfolder t Verbose: 1220 : 18|16:16:51.6952|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Bangladesh vs New Zealand Match 9.mp4 t Verbose: 1220 : 18|16:16:51.6952||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/Bangladesh vs New Zealand Match 9.mp4 t Transfer: 1220 : 18|16:16:51.6952||GetCurrentUser.. t Transfer: 1220 : 18|16:16:51.6952|| OAuth authenticated t Transfer: 1220 : 18|16:16:51.6952|| user TONY. t Verbose: 1220 : 18|16:16:51.7109||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Afghanistan vs Sri Lanka Match 7.mp4 subfolder t Verbose: 1220 : 18|16:16:51.7109|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Afghanistan vs Sri Lanka Match 7.mp4 t Verbose: 1220 : 18|16:16:51.7109||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/Afghanistan vs Sri Lanka Match 7.mp4 t Transfer: 1220 : 18|16:16:51.7109||GetCurrentUser.. t Transfer: 1220 : 18|16:16:51.7109|| OAuth authenticated t Transfer: 1220 : 18|16:16:51.7109|| user TONY. t Verbose: 1220 : 18|16:16:51.7109||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Australia vs West Indies Match 10.mp4 subfolder t Verbose: 1220 : 18|16:16:51.7109|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Australia vs West Indies Match 10.mp4 t Verbose: 1220 : 18|16:16:51.7109||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/Australia vs West Indies Match 10.mp4 t Transfer: 1220 : 18|16:16:51.7109||GetCurrentUser.. t Transfer: 1220 : 18|16:16:51.7109|| OAuth authenticated t Transfer: 1220 : 18|16:16:51.7109|| user TONY. t Verbose: 1220 : 18|16:16:51.7109||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\South Africa vs India Match 8.mp4 subfolder t Verbose: 1220 : 18|16:16:51.7109|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/South Africa vs India Match 8.mp4 t Verbose: 1220 : 18|16:16:51.7109||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/South Africa vs India Match 8.mp4 t Transfer: 1220 : 18|16:16:51.7109||GetCurrentUser.. t Transfer: 1220 : 18|16:16:51.7109|| OAuth authenticated t Transfer: 1220 : 18|16:16:51.7109|| user TONY. t Verbose: 1220 : 18|16:16:51.7109||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\England vs Pakistan Match 6.mp4 subfolder t Verbose: 1220 : 18|16:16:51.7109|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/England vs Pakistan Match 6.mp4 t Verbose: 1220 : 18|16:16:51.7109||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/England vs Pakistan Match 6.mp4 t Transfer: 1220 : 18|16:16:51.7109||GetCurrentUser.. t Transfer: 1220 : 18|16:16:51.7109|| OAuth authenticated t Transfer: 1220 : 18|16:16:51.7109|| user TONY. t Verbose: 1220 : 18|16:16:51.7109||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Pakistan vs Sri Lanka Match 11.mp4 subfolder t Verbose: 1220 : 18|16:16:51.7109|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Pakistan vs Sri Lanka Match 11.mp4 t Verbose: 1220 : 18|16:16:51.7109||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/Pakistan vs Sri Lanka Match 11.mp4 t Transfer: 1220 : 18|16:16:51.7109||GetCurrentUser.. t Transfer: 1220 : 18|16:16:51.7109|| OAuth authenticated t Transfer: 1220 : 18|16:16:51.7109|| user TONY. t Transfer: 1220 : 7|16:16:51.8514||IsUserAuthenticated: /api/user-preferences?_dc=1576167412060 t Transfer: 1220 : 7|16:16:51.8514||GetCurrentUser.. t Transfer: 1220 : 7|16:16:51.8514|| OAuth authenticated t Transfer: 1220 : 7|16:16:51.8514|| user TONY. t Transfer: 1220 : 7|16:16:51.8514||api user: TONY t Verbose: 1220 : 7|16:16:51.8514||StoreUserDataByKeys.. t Transfer: 1220 : 7|16:16:51.8514||GetCurrentUser.. t Transfer: 1220 : 7|16:16:51.8514|| OAuth authenticated t Transfer: 1220 : 7|16:16:51.8514|| user TONY. t Transfer: 1220 : 13|16:16:57.8203||IsUserAuthenticated: /api/title-details/298387?_dc=1576167418025 t Transfer: 1220 : 13|16:16:57.8203||GetCurrentUser.. t Transfer: 1220 : 13|16:16:57.8203|| OAuth authenticated t Transfer: 1220 : 13|16:16:57.8203|| user TONY. t Transfer: 1220 : 13|16:16:57.8203||api user: TONY t Transfer: 1220 : 22|16:16:57.9296||IsUserAuthenticated: /api/search/title?_dc=1576167418152 t Transfer: 1220 : 22|16:16:57.9296||GetCurrentUser.. t Transfer: 1220 : 22|16:16:57.9296|| OAuth authenticated t Transfer: 1220 : 22|16:16:57.9296|| user TONY. t Transfer: 1220 : 22|16:16:57.9296||api user: TONY t Information: 1220 : 22|16:16:57.9296||V3Api.SearchTitles t Information: 1220 : 22|16:16:57.9296||V3Api.SearchGeneric t Transfer: 1220 : 22|16:16:57.9296||GetCurrentUser.. t Transfer: 1220 : 22|16:16:57.9296|| OAuth authenticated t Transfer: 1220 : 22|16:16:57.9296|| user TONY. t Transfer: 1220 : 22|16:16:57.9296||GetCurrentUser.. t Transfer: 1220 : 22|16:16:57.9296|| OAuth authenticated t Transfer: 1220 : 22|16:16:57.9296|| user TONY. t Information: 1220 : 22|16:16:57.9452||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 : 11|16:16:58.0233||IsUserAuthenticated: /api/search/title?_dc=1576167418242 t Transfer: 1220 : 11|16:16:58.0233||GetCurrentUser.. t Transfer: 1220 : 11|16:16:58.0233|| OAuth authenticated t Transfer: 1220 : 11|16:16:58.0233|| user TONY. t Transfer: 1220 : 11|16:16:58.0233||api user: TONY t Information: 1220 : 11|16:16:58.0233||V3Api.SearchTitles t Information: 1220 : 11|16:16:58.0233||V3Api.SearchGeneric t Transfer: 1220 : 11|16:16:58.0233||GetCurrentUser.. t Transfer: 1220 : 11|16:16:58.0233|| OAuth authenticated t Transfer: 1220 : 11|16:16:58.0233|| user TONY. t Transfer: 1220 : 11|16:16:58.0233||GetCurrentUser.. t Transfer: 1220 : 11|16:16:58.0233|| OAuth authenticated t Transfer: 1220 : 11|16:16:58.0233|| user TONY. t Information: 1220 : 11|16:16:58.0390||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 : 31|16:18:48.6640||IsUserAuthenticated: /api/user-group-preferences?globals=htmlplayerhotkeys,audioOnFrameForward&_dc=1576167528874 t Transfer: 1220 : 31|16:18:48.6640||GetCurrentUser.. t Transfer: 1220 : 31|16:18:48.6640|| OAuth authenticated t Transfer: 1220 : 31|16:18:48.6640|| user TONY. t Transfer: 1220 : 31|16:18:48.6640||api user: TONY t Information: 1220 : 31|16:18:48.6640||V3Api.GetUserSettings t Transfer: 1220 : 31|16:18:48.6640||GetCurrentUser.. t Transfer: 1220 : 31|16:18:48.6640|| OAuth authenticated t Transfer: 1220 : 31|16:18:48.6640|| user TONY. t Transfer: 1220 : 35|16:18:49.8202||IsUserAuthenticated: /api/user-group-preferences?globals=htmlplayerhotkeys,audioOnFrameForward&_dc=1576167530027 t Transfer: 1220 : 35|16:18:49.8202||GetCurrentUser.. t Transfer: 1220 : 35|16:18:49.8202|| OAuth authenticated t Transfer: 1220 : 35|16:18:49.8202|| user TONY. t Transfer: 1220 : 35|16:18:49.8202||api user: TONY t Information: 1220 : 35|16:18:49.8202||V3Api.GetUserSettings t Transfer: 1220 : 35|16:18:49.8202||GetCurrentUser.. t Transfer: 1220 : 35|16:18:49.8202|| OAuth authenticated t Transfer: 1220 : 35|16:18:49.8202|| user TONY. t Transfer: 1220 : 27|16:18:50.3514||IsUserAuthenticated: /api/user-group-preferences?globals=htmlplayerhotkeys,audioOnFrameForward&_dc=1576167530564 t Transfer: 1220 : 27|16:18:50.3514||GetCurrentUser.. t Transfer: 1220 : 27|16:18:50.3514|| OAuth authenticated t Transfer: 1220 : 27|16:18:50.3514|| user TONY. t Transfer: 1220 : 27|16:18:50.3514||api user: TONY t Information: 1220 : 27|16:18:50.3514||V3Api.GetUserSettings t Transfer: 1220 : 27|16:18:50.3514||GetCurrentUser.. t Transfer: 1220 : 27|16:18:50.3514|| OAuth authenticated t Transfer: 1220 : 27|16:18:50.3514|| user TONY. t Transfer: 1220 : 33|16:18:50.4296||IsUserAuthenticated: /api/user-group-preferences?globals=htmlplayerhotkeys,audioOnFrameForward&_dc=1576167530631 t Transfer: 1220 : 33|16:18:50.4296||GetCurrentUser.. t Transfer: 1220 : 33|16:18:50.4296|| OAuth authenticated t Transfer: 1220 : 33|16:18:50.4296|| user TONY. t Transfer: 1220 : 33|16:18:50.4296||api user: TONY t Information: 1220 : 33|16:18:50.4296||V3Api.GetUserSettings t Transfer: 1220 : 33|16:18:50.4296||GetCurrentUser.. t Transfer: 1220 : 33|16:18:50.4296|| OAuth authenticated t Transfer: 1220 : 33|16:18:50.4296|| user TONY. t Transfer: 1220 : 22|16:18:55.4608||IsUserAuthenticated: /api/title-details/298279?_dc=1576167535669 t Transfer: 1220 : 22|16:18:55.4608||GetCurrentUser.. t Transfer: 1220 : 22|16:18:55.4608|| OAuth authenticated t Transfer: 1220 : 22|16:18:55.4608|| user TONY. t Transfer: 1220 : 22|16:18:55.4608||api user: TONY t Transfer: 1220 : 28|16:18:55.6014||IsUserAuthenticated: /api/search/title?_dc=1576167535817 t Transfer: 1220 : 28|16:18:55.6014||GetCurrentUser.. t Transfer: 1220 : 28|16:18:55.6014|| OAuth authenticated t Transfer: 1220 : 28|16:18:55.6014|| user TONY. t Transfer: 1220 : 28|16:18:55.6014||api user: TONY t Information: 1220 : 28|16:18:55.6014||V3Api.SearchTitles t Information: 1220 : 28|16:18:55.6014||V3Api.SearchGeneric t Transfer: 1220 : 28|16:18:55.6014||GetCurrentUser.. t Transfer: 1220 : 28|16:18:55.6014|| OAuth authenticated t Transfer: 1220 : 28|16:18:55.6014|| user TONY. t Transfer: 1220 : 28|16:18:55.6014||GetCurrentUser.. t Transfer: 1220 : 28|16:18:55.6014|| OAuth authenticated t Transfer: 1220 : 28|16:18:55.6014|| user TONY. t Information: 1220 : 28|16:18:55.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 Upper(a.ID) = Upper('298279') 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 : 32|16:18:55.7265||IsUserAuthenticated: /api/search/title?_dc=1576167535920 t Transfer: 1220 : 32|16:18:55.7265||GetCurrentUser.. t Transfer: 1220 : 32|16:18:55.7265|| OAuth authenticated t Transfer: 1220 : 32|16:18:55.7265|| user TONY. t Transfer: 1220 : 32|16:18:55.7265||api user: TONY t Information: 1220 : 32|16:18:55.7265||V3Api.SearchTitles t Information: 1220 : 32|16:18:55.7265||V3Api.SearchGeneric t Transfer: 1220 : 32|16:18:55.7265||GetCurrentUser.. t Transfer: 1220 : 32|16:18:55.7265|| OAuth authenticated t Transfer: 1220 : 32|16:18:55.7265|| user TONY. t Transfer: 1220 : 32|16:18:55.7265||GetCurrentUser.. t Transfer: 1220 : 32|16:18:55.7265|| OAuth authenticated t Transfer: 1220 : 32|16:18:55.7265|| user TONY. t Information: 1220 : 32|16:18:55.7265||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('298279') 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 : 31|16:19:28.0702||IsUserAuthenticated: /api/SearchSuggestion/?_dc=1576167568272 t Transfer: 1220 : 31|16:19:28.0702||GetCurrentUser.. t Transfer: 1220 : 31|16:19:28.0702|| OAuth authenticated t Transfer: 1220 : 31|16:19:28.0702|| user TONY. t Transfer: 1220 : 31|16:19:28.0702||api user: TONY t Transfer: 1220 : 31|16:19:28.0702||GetCurrentUser.. t Transfer: 1220 : 31|16:19:28.0702|| OAuth authenticated t Transfer: 1220 : 31|16:19:28.0702|| user TONY. t Transfer: 1220 : 22|16:19:28.0859||IsUserAuthenticated: /api/SearchSuggestion/?_dc=1576167568259 t Transfer: 1220 : 22|16:19:28.0859||GetCurrentUser.. t Transfer: 1220 : 22|16:19:28.0859|| OAuth authenticated t Transfer: 1220 : 22|16:19:28.0859|| user TONY. t Transfer: 1220 : 22|16:19:28.0859||api user: TONY t Transfer: 1220 : 22|16:19:28.0859||GetCurrentUser.. t Transfer: 1220 : 22|16:19:28.0859|| OAuth authenticated t Transfer: 1220 : 22|16:19:28.0859|| user TONY. t Transfer: 1220 : 28|16:19:28.0859||IsUserAuthenticated: /api/SearchSuggestion/?_dc=1576167568248 t Transfer: 1220 : 28|16:19:28.0859||GetCurrentUser.. t Transfer: 1220 : 28|16:19:28.0859|| OAuth authenticated t Transfer: 1220 : 28|16:19:28.0859|| user TONY. t Transfer: 1220 : 28|16:19:28.0859||api user: TONY t Transfer: 1220 : 28|16:19:28.0859||GetCurrentUser.. t Transfer: 1220 : 28|16:19:28.0859|| OAuth authenticated t Transfer: 1220 : 28|16:19:28.0859|| user TONY. t Transfer: 1220 : 31|16:19:28.1015||IsUserAuthenticated: /api/SearchSuggestion/?_dc=1576167568265 t Transfer: 1220 : 31|16:19:28.1015||GetCurrentUser.. t Transfer: 1220 : 31|16:19:28.1015|| OAuth authenticated t Transfer: 1220 : 31|16:19:28.1015|| user TONY. t Transfer: 1220 : 31|16:19:28.1015||api user: TONY t Transfer: 1220 : 31|16:19:28.1015||GetCurrentUser.. t Transfer: 1220 : 31|16:19:28.1015|| OAuth authenticated t Transfer: 1220 : 31|16:19:28.1015|| user TONY. t Transfer: 1220 : 22|16:19:28.2265||IsUserAuthenticated: /api/SearchSuggestion/?_dc=1576167568245 t Transfer: 1220 : 22|16:19:28.2265||GetCurrentUser.. t Transfer: 1220 : 22|16:19:28.2265|| OAuth authenticated t Transfer: 1220 : 22|16:19:28.2265|| user TONY. t Transfer: 1220 : 22|16:19:28.2265||api user: TONY t Transfer: 1220 : 22|16:19:28.2265||GetCurrentUser.. t Transfer: 1220 : 22|16:19:28.2265|| OAuth authenticated t Transfer: 1220 : 22|16:19:28.2265|| user TONY. t Transfer: 1220 : 13|16:19:29.0858||IsUserAuthenticated: /api/SearchSuggestion/?_dc=1576167568255 t Transfer: 1220 : 13|16:19:29.0858||GetCurrentUser.. t Transfer: 1220 : 13|16:19:29.0858|| OAuth authenticated t Transfer: 1220 : 13|16:19:29.0858|| user TONY. t Transfer: 1220 : 13|16:19:29.0858||api user: TONY t Transfer: 1220 : 13|16:19:29.0858||GetCurrentUser.. t Transfer: 1220 : 13|16:19:29.0858|| OAuth authenticated t Transfer: 1220 : 13|16:19:29.0858|| user TONY. t Transfer: 1220 : 26|16:19:31.1014||IsUserAuthenticated: /api/SearchSuggestion/?_dc=1576167568251 t Transfer: 1220 : 26|16:19:31.1014||GetCurrentUser.. t Transfer: 1220 : 26|16:19:31.1014|| OAuth authenticated t Transfer: 1220 : 26|16:19:31.1014|| user TONY. t Transfer: 1220 : 26|16:19:31.1014||api user: TONY t Transfer: 1220 : 26|16:19:31.1014||GetCurrentUser.. t Transfer: 1220 : 26|16:19:31.1014|| OAuth authenticated t Transfer: 1220 : 26|16:19:31.1014|| user TONY. t Transfer: 1220 : 32|16:19:32.0702||IsUserAuthenticated: /api/SearchSuggestion/?_dc=1576167568264 t Transfer: 1220 : 32|16:19:32.0702||GetCurrentUser.. t Transfer: 1220 : 32|16:19:32.0702|| OAuth authenticated t Transfer: 1220 : 32|16:19:32.0702|| user TONY. t Transfer: 1220 : 32|16:19:32.0702||api user: TONY t Transfer: 1220 : 32|16:19:32.0702||GetCurrentUser.. t Transfer: 1220 : 32|16:19:32.0702|| OAuth authenticated t Transfer: 1220 : 32|16:19:32.0702|| user TONY. t Transfer: 1220 : 13|16:19:32.0859||IsUserAuthenticated: /api/SearchSuggestion/?_dc=1576167568281 t Transfer: 1220 : 13|16:19:32.0859||GetCurrentUser.. t Transfer: 1220 : 13|16:19:32.0859|| OAuth authenticated t Transfer: 1220 : 13|16:19:32.0859|| user TONY. t Transfer: 1220 : 13|16:19:32.0859||api user: TONY t Transfer: 1220 : 13|16:19:32.0859||GetCurrentUser.. t Transfer: 1220 : 13|16:19:32.1015|| OAuth authenticated t Transfer: 1220 : 13|16:19:32.1015|| user TONY. t Transfer: 1220 : 30|16:19:32.1015||IsUserAuthenticated: /api/SearchSuggestion/?_dc=1576167568275 t Transfer: 1220 : 30|16:19:32.1015||GetCurrentUser.. t Transfer: 1220 : 30|16:19:32.1015|| OAuth authenticated t Transfer: 1220 : 30|16:19:32.1015|| user TONY. t Transfer: 1220 : 30|16:19:32.1015||api user: TONY t Transfer: 1220 : 30|16:19:32.1015||GetCurrentUser.. t Transfer: 1220 : 30|16:19:32.1015|| OAuth authenticated t Transfer: 1220 : 30|16:19:32.1015|| user TONY. t Transfer: 1220 : 31|16:19:32.1015||IsUserAuthenticated: /api/SearchSuggestion/?_dc=1576167568277 t Transfer: 1220 : 31|16:19:32.1015||GetCurrentUser.. t Transfer: 1220 : 31|16:19:32.1015|| OAuth authenticated t Transfer: 1220 : 31|16:19:32.1015|| user TONY. t Transfer: 1220 : 31|16:19:32.1015||api user: TONY t Transfer: 1220 : 31|16:19:32.1015||GetCurrentUser.. t Transfer: 1220 : 31|16:19:32.1015|| OAuth authenticated t Transfer: 1220 : 31|16:19:32.1015|| user TONY. t Transfer: 1220 : 32|16:19:32.1015||IsUserAuthenticated: /api/SearchSuggestion/?_dc=1576167568282 t Transfer: 1220 : 32|16:19:32.1015||GetCurrentUser.. t Transfer: 1220 : 32|16:19:32.1015|| OAuth authenticated t Transfer: 1220 : 32|16:19:32.1015|| user TONY. t Transfer: 1220 : 32|16:19:32.1015||api user: TONY t Transfer: 1220 : 32|16:19:32.1015||GetCurrentUser.. t Transfer: 1220 : 32|16:19:32.1015|| OAuth authenticated t Transfer: 1220 : 32|16:19:32.1015|| user TONY. t Transfer: 1220 : 27|16:19:32.1171||IsUserAuthenticated: /api/SearchSuggestion/?_dc=1576167568278 t Transfer: 1220 : 27|16:19:32.1171||GetCurrentUser.. t Transfer: 1220 : 27|16:19:32.1171|| OAuth authenticated t Transfer: 1220 : 27|16:19:32.1171|| user TONY. t Transfer: 1220 : 27|16:19:32.1171||api user: TONY t Transfer: 1220 : 27|16:19:32.1171||GetCurrentUser.. t Transfer: 1220 : 27|16:19:32.1171|| OAuth authenticated t Transfer: 1220 : 27|16:19:32.1171|| user TONY. t Transfer: 1220 : 13|16:19:32.1171||IsUserAuthenticated: /api/SearchSuggestion/?_dc=1576167568260 t Transfer: 1220 : 13|16:19:32.1171||GetCurrentUser.. t Transfer: 1220 : 13|16:19:32.1171|| OAuth authenticated t Transfer: 1220 : 13|16:19:32.1171|| user TONY. t Transfer: 1220 : 13|16:19:32.1171||api user: TONY t Transfer: 1220 : 13|16:19:32.1171||GetCurrentUser.. t Transfer: 1220 : 13|16:19:32.1171|| OAuth authenticated t Transfer: 1220 : 13|16:19:32.1171|| user TONY. t Transfer: 1220 : 31|16:19:32.1171||IsUserAuthenticated: /api/SearchSuggestion/?_dc=1576167568280 t Transfer: 1220 : 31|16:19:32.1171||GetCurrentUser.. t Transfer: 1220 : 31|16:19:32.1171|| OAuth authenticated t Transfer: 1220 : 31|16:19:32.1171|| user TONY. t Transfer: 1220 : 31|16:19:32.1171||api user: TONY t Transfer: 1220 : 31|16:19:32.1171||GetCurrentUser.. t Transfer: 1220 : 31|16:19:32.1171|| OAuth authenticated t Transfer: 1220 : 31|16:19:32.1171|| user TONY. t Transfer: 1220 : 32|16:19:32.1327||IsUserAuthenticated: /api/SearchSuggestion/?_dc=1576167568274 t Transfer: 1220 : 32|16:19:32.1327||GetCurrentUser.. t Transfer: 1220 : 32|16:19:32.1327|| OAuth authenticated t Transfer: 1220 : 32|16:19:32.1327|| user TONY. t Transfer: 1220 : 32|16:19:32.1327||api user: TONY t Transfer: 1220 : 26|16:19:32.1327||IsUserAuthenticated: /api/SearchSuggestion/?_dc=1576167568256 t Transfer: 1220 : 26|16:19:32.1327||GetCurrentUser.. t Transfer: 1220 : 26|16:19:32.1327|| OAuth authenticated t Transfer: 1220 : 26|16:19:32.1327|| user TONY. t Transfer: 1220 : 26|16:19:32.1327||api user: TONY t Transfer: 1220 : 32|16:19:32.1327||GetCurrentUser.. t Transfer: 1220 : 32|16:19:32.1327|| OAuth authenticated t Transfer: 1220 : 32|16:19:32.1327|| user TONY. t Transfer: 1220 : 26|16:19:32.1327||GetCurrentUser.. t Transfer: 1220 : 26|16:19:32.1327|| OAuth authenticated t Transfer: 1220 : 26|16:19:32.1327|| user TONY. t Transfer: 1220 : 31|16:19:32.1327||IsUserAuthenticated: /api/SearchSuggestion/?_dc=1576167568257 t Transfer: 1220 : 31|16:19:32.1327||GetCurrentUser.. t Transfer: 1220 : 31|16:19:32.1327|| OAuth authenticated t Transfer: 1220 : 31|16:19:32.1327|| user TONY. t Transfer: 1220 : 31|16:19:32.1327||api user: TONY t Transfer: 1220 : 31|16:19:32.1327||GetCurrentUser.. t Transfer: 1220 : 31|16:19:32.1327|| OAuth authenticated t Transfer: 1220 : 31|16:19:32.1327|| user TONY. t Transfer: 1220 : 13|16:19:32.1327||IsUserAuthenticated: /api/SearchSuggestion/?_dc=1576167568262 t Transfer: 1220 : 13|16:19:32.1327||GetCurrentUser.. t Transfer: 1220 : 13|16:19:32.1327|| OAuth authenticated t Transfer: 1220 : 13|16:19:32.1327|| user TONY. t Transfer: 1220 : 13|16:19:32.1327||api user: TONY t Transfer: 1220 : 13|16:19:32.1327||GetCurrentUser.. t Transfer: 1220 : 13|16:19:32.1327|| OAuth authenticated t Transfer: 1220 : 13|16:19:32.1327|| user TONY. t Transfer: 1220 : 27|16:19:32.2108||IsUserAuthenticated: /api/SearchSuggestion/?_dc=1576167568271 t Transfer: 1220 : 27|16:19:32.2108||GetCurrentUser.. t Transfer: 1220 : 27|16:19:32.2108|| OAuth authenticated t Transfer: 1220 : 27|16:19:32.2108|| user TONY. t Transfer: 1220 : 27|16:19:32.2108||api user: TONY t Transfer: 1220 : 27|16:19:32.2108||GetCurrentUser.. t Transfer: 1220 : 27|16:19:32.2108|| OAuth authenticated t Transfer: 1220 : 27|16:19:32.2108|| user TONY. t Transfer: 1220 : 22|16:19:32.2265||IsUserAuthenticated: /api/SearchSuggestion/?_dc=1576167568270 t Transfer: 1220 : 22|16:19:32.2265||GetCurrentUser.. t Transfer: 1220 : 22|16:19:32.2265|| OAuth authenticated t Transfer: 1220 : 22|16:19:32.2265|| user TONY. t Transfer: 1220 : 22|16:19:32.2265||api user: TONY t Transfer: 1220 : 22|16:19:32.2265||GetCurrentUser.. t Transfer: 1220 : 22|16:19:32.2265|| OAuth authenticated t Transfer: 1220 : 22|16:19:32.2265|| user TONY. t Transfer: 1220 : 13|16:19:32.2890||IsUserAuthenticated: /api/SearchSuggestion/?_dc=1576167568276 t Transfer: 1220 : 13|16:19:32.2890||GetCurrentUser.. t Transfer: 1220 : 13|16:19:32.2890|| OAuth authenticated t Transfer: 1220 : 13|16:19:32.2890|| user TONY. t Transfer: 1220 : 13|16:19:32.2890||api user: TONY t Transfer: 1220 : 13|16:19:32.3046||GetCurrentUser.. t Transfer: 1220 : 13|16:19:32.3046|| OAuth authenticated t Transfer: 1220 : 13|16:19:32.3046|| user TONY. t Transfer: 1220 : 26|16:19:32.3046||IsUserAuthenticated: /api/title-details/298279?_dc=1576167568355 t Transfer: 1220 : 26|16:19:32.3046||GetCurrentUser.. t Transfer: 1220 : 26|16:19:32.3046|| OAuth authenticated t Transfer: 1220 : 26|16:19:32.3046|| user TONY. t Transfer: 1220 : 26|16:19:32.3046||api user: TONY t Transfer: 1220 : 26|16:19:32.4765||IsUserAuthenticated: /api/search/title?_dc=1576167572647 t Transfer: 1220 : 26|16:19:32.4765||GetCurrentUser.. t Transfer: 1220 : 26|16:19:32.4765|| OAuth authenticated t Transfer: 1220 : 26|16:19:32.4765|| user TONY. t Transfer: 1220 : 26|16:19:32.4765||api user: TONY t Information: 1220 : 26|16:19:32.4765||V3Api.SearchTitles t Information: 1220 : 26|16:19:32.4765||V3Api.SearchGeneric t Transfer: 1220 : 26|16:19:32.4765||GetCurrentUser.. t Transfer: 1220 : 26|16:19:32.4765|| OAuth authenticated t Transfer: 1220 : 26|16:19:32.4765|| user TONY. t Transfer: 1220 : 26|16:19:32.4765||GetCurrentUser.. t Transfer: 1220 : 26|16:19:32.4765|| OAuth authenticated t Transfer: 1220 : 26|16:19:32.4765|| user TONY. t Information: 1220 : 26|16:19:32.4765||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('298279') 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 : 31|16:19:32.5233||IsUserAuthenticated: /api/search/title?_dc=1576167572725 t Transfer: 1220 : 31|16:19:32.5233||GetCurrentUser.. t Transfer: 1220 : 31|16:19:32.5233|| OAuth authenticated t Transfer: 1220 : 31|16:19:32.5233|| user TONY. t Transfer: 1220 : 31|16:19:32.5233||api user: TONY t Information: 1220 : 31|16:19:32.5233||V3Api.SearchTitles t Information: 1220 : 31|16:19:32.5233||V3Api.SearchGeneric t Transfer: 1220 : 31|16:19:32.5233||GetCurrentUser.. t Transfer: 1220 : 31|16:19:32.5233|| OAuth authenticated t Transfer: 1220 : 31|16:19:32.5233|| user TONY. t Transfer: 1220 : 31|16:19:32.5233||GetCurrentUser.. t Transfer: 1220 : 31|16:19:32.5233|| OAuth authenticated t Transfer: 1220 : 31|16:19:32.5233|| user TONY. t Information: 1220 : 31|16:19:32.5233||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('298279') 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 : 31|16:20:40.9452||IsUserAuthenticated: /api/title-details/298401?_dc=1576167641162 t Transfer: 1220 : 31|16:20:40.9452||GetCurrentUser.. t Transfer: 1220 : 31|16:20:40.9452|| OAuth authenticated t Transfer: 1220 : 31|16:20:40.9452|| user TONY. t Transfer: 1220 : 31|16:20:40.9452||api user: TONY t Transfer: 1220 : 27|16:20:41.1796||IsUserAuthenticated: /api/search/title?_dc=1576167641395 t Transfer: 1220 : 27|16:20:41.1796||GetCurrentUser.. t Transfer: 1220 : 27|16:20:41.1796|| OAuth authenticated t Transfer: 1220 : 27|16:20:41.1796|| user TONY. t Transfer: 1220 : 27|16:20:41.1796||api user: TONY t Information: 1220 : 27|16:20:41.1796||V3Api.SearchTitles t Information: 1220 : 27|16:20:41.1796||V3Api.SearchGeneric t Transfer: 1220 : 27|16:20:41.1796||GetCurrentUser.. t Transfer: 1220 : 27|16:20:41.1796|| OAuth authenticated t Transfer: 1220 : 27|16:20:41.1796|| user TONY. t Transfer: 1220 : 27|16:20:41.1796||GetCurrentUser.. t Transfer: 1220 : 27|16:20:41.1796|| OAuth authenticated t Transfer: 1220 : 27|16:20:41.1796|| user TONY. t Information: 1220 : 27|16:20:41.1796||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 : 25|16:20:41.2421||IsUserAuthenticated: /api/search/title?_dc=1576167641465 t Transfer: 1220 : 25|16:20:41.2421||GetCurrentUser.. t Transfer: 1220 : 25|16:20:41.2421|| OAuth authenticated t Transfer: 1220 : 25|16:20:41.2421|| user TONY. t Transfer: 1220 : 25|16:20:41.2421||api user: TONY t Information: 1220 : 25|16:20:41.2421||V3Api.SearchTitles t Information: 1220 : 25|16:20:41.2421||V3Api.SearchGeneric t Transfer: 1220 : 25|16:20:41.2421||GetCurrentUser.. t Transfer: 1220 : 25|16:20:41.2421|| OAuth authenticated t Transfer: 1220 : 25|16:20:41.2421|| user TONY. t Transfer: 1220 : 25|16:20:41.2421||GetCurrentUser.. t Transfer: 1220 : 25|16:20:41.2421|| OAuth authenticated t Transfer: 1220 : 25|16:20:41.2421|| user TONY. t Information: 1220 : 25|16:20:41.2421||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 Information: 1220 : 43|16:21:46.2890||GetAppInfo t Information: 1220 : 43|16:21:46.2890|| db: TMDDEMO install mode: auth types: Native, PublicApiKey t Information: 1220 : 43|16:21:56.2890||Oauth validating.. t Verbose: 1220 : 43|16:21:56.2890||GrantResourceOwnerCredentials. t Verbose: 1220 : 43|16:21:56.2890||LoginUser. tmddba, login type OAuth, encrypt password True t Information: 1220 : 43|16:21:56.2890||TryLoginUser. tmddba, login type OAuth, check password True, check hash False, encrypt password True, load user data True t Information: 1220 : 43|16:21:56.3515||InitialiseLogin t Information: 1220 : 43|16:21:56.3827|| oauth token 00000000-0000-0000-0000-000000000000 t Information: 1220 : 43|16:21:56.3827||TryLoginUser. Logged in.. t Information: 1220 : 43|16:21:56.3983||GetPasswordPolicy. WARNING: Policy not found for system Imediaflex. Validation disabled. t Verbose: 1220 : 43|16:21:56.3983||LoginUser. Adding history. User Id 1, result TMDDBA, host t Verbose: 1220 : 43|16:21:56.3983||GrantResourceOwnerCredentials. Try login finished. Logged: True t Transfer: 1220 : 30|16:21:56.4296||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=1576167716348 t Transfer: 1220 : 30|16:21:56.4296||GetCurrentUser.. t Transfer: 1220 : 30|16:21:56.4296|| OAuth authenticated t Transfer: 1220 : 30|16:21:56.4296|| user TMDDBA. t Transfer: 1220 : 30|16:21:56.4296||api user: TMDDBA t Information: 1220 : 30|16:21:56.4296||V3Api.GetUserSettings t Transfer: 1220 : 30|16:21:56.4296||GetCurrentUser.. t Transfer: 1220 : 30|16:21:56.4296|| OAuth authenticated t Transfer: 1220 : 30|16:21:56.4296|| user TMDDBA. t Transfer: 1220 : 22|16:21:56.4765||IsUserAuthenticated: /api/user-preferences?keys=personal_settings;basket;default_page;color_schema;media.basket.data;defaultSearch&_dc=1576167716395 t Transfer: 1220 : 22|16:21:56.4765||GetCurrentUser.. t Transfer: 1220 : 22|16:21:56.4765|| OAuth authenticated t Transfer: 1220 : 22|16:21:56.4765|| user TMDDBA. t Transfer: 1220 : 22|16:21:56.4765||api user: TMDDBA t Information: 1220 : 22|16:21:56.4765||GetUserDataByKeys: personal_settings;basket;default_page;color_schema;media.basket.data;defaultSearch t Transfer: 1220 : 22|16:21:56.4765||GetCurrentUser.. t Transfer: 1220 : 22|16:21:56.4765|| OAuth authenticated t Transfer: 1220 : 22|16:21:56.4765|| user TMDDBA. t Transfer: 1220 : 43|16:21:56.4921||IsUserAuthenticated: /api/lookups/PgmStatus?_dc=1576167716398 t Transfer: 1220 : 43|16:21:56.4921||GetCurrentUser.. t Transfer: 1220 : 43|16:21:56.4921|| OAuth authenticated t Transfer: 1220 : 43|16:21:56.4921|| user TMDDBA. t Transfer: 1220 : 43|16:21:56.4921||api user: TMDDBA t Transfer: 1220 : 12|16:21:56.4921||IsUserAuthenticated: /api/lookups/MediaStatus?_dc=1576167716396 t Transfer: 1220 : 12|16:21:56.4921||GetCurrentUser.. t Transfer: 1220 : 12|16:21:56.4921|| OAuth authenticated t Transfer: 1220 : 12|16:21:56.4921|| user TMDDBA. t Transfer: 1220 : 12|16:21:56.4921||api user: TMDDBA t Information: 1220 : 43|16:21:56.5233||GetUserProfile. Id: 0 t Transfer: 1220 : 43|16:21:56.5233||GetCurrentUser.. t Transfer: 1220 : 43|16:21:56.5233|| OAuth authenticated t Transfer: 1220 : 43|16:21:56.5233|| user TMDDBA. t Transfer: 1220 : 30|16:21:57.1014||IsUserAuthenticated: /api/settings/group/0?_dc=1576167717008 t Transfer: 1220 : 30|16:21:57.1014||GetCurrentUser.. t Transfer: 1220 : 30|16:21:57.1014|| OAuth authenticated t Transfer: 1220 : 30|16:21:57.1014|| user TMDDBA. t Transfer: 1220 : 30|16:21:57.1014||api user: TMDDBA t Information: 1220 : 30|16:21:57.1014||V3Api.GetSettingsGroup t Transfer: 1220 : 12|16:21:57.3202||IsUserAuthenticated: /api/view/searches/Job?_dc=1576167717234 t Transfer: 1220 : 12|16:21:57.3202||GetCurrentUser.. t Transfer: 1220 : 12|16:21:57.3202|| OAuth authenticated t Transfer: 1220 : 12|16:21:57.3202|| user TMDDBA. t Transfer: 1220 : 12|16:21:57.3202||api user: TMDDBA t Information: 1220 : 12|16:21:57.3202||GetSavedSearchNames. search type Job. t Transfer: 1220 : 12|16:21:57.3202||GetCurrentUser.. t Transfer: 1220 : 12|16:21:57.3202|| OAuth authenticated t Transfer: 1220 : 12|16:21:57.3202|| user TMDDBA. t Transfer: 1220 : 22|16:21:58.1014||IsUserAuthenticated: /api/v3/layout/default/3?_dc=1576167718014 t Transfer: 1220 : 22|16:21:58.1014||GetCurrentUser.. t Transfer: 1220 : 22|16:21:58.1014|| OAuth authenticated t Transfer: 1220 : 22|16:21:58.1014|| user TMDDBA. t Transfer: 1220 : 22|16:21:58.1014||api user: TMDDBA t Information: 1220 : 22|16:21:58.1014||LoadDefaultDashboard. t Transfer: 1220 : 22|16:21:58.1014||GetCurrentUser.. t Transfer: 1220 : 22|16:21:58.1014|| OAuth authenticated t Transfer: 1220 : 22|16:21:58.1014|| user TMDDBA. t Transfer: 1220 : 22|16:21:58.1640||GetCurrentUser.. t Transfer: 1220 : 22|16:21:58.1640|| OAuth authenticated t Transfer: 1220 : 22|16:21:58.1640|| user TMDDBA. t Transfer: 1220 : 22|16:22:03.7889||IsUserAuthenticated: /api/v3/config/servicexml/types?_dc=1576167723705 t Transfer: 1220 : 22|16:22:03.7889||GetCurrentUser.. t Transfer: 1220 : 22|16:22:03.7889|| OAuth authenticated t Transfer: 1220 : 22|16:22:03.7889|| user TMDDBA. t Transfer: 1220 : 22|16:22:03.7889||api user: TMDDBA t Transfer: 1220 : 25|16:22:03.9764||IsUserAuthenticated: /api/settings/groups/?_dc=1576167723889 t Transfer: 1220 : 25|16:22:03.9764||GetCurrentUser.. t Transfer: 1220 : 25|16:22:03.9764|| OAuth authenticated t Transfer: 1220 : 25|16:22:03.9764|| user TMDDBA. t Transfer: 1220 : 25|16:22:03.9764||api user: TMDDBA t Information: 1220 : 25|16:22:03.9764||V3Api.GetSettingsGroupsNames t Transfer: 1220 : 30|16:22:08.6796||IsUserAuthenticated: /api/v3/config/detailsview/MediaDetails/Default?_dc=1576167728583 t Transfer: 1220 : 30|16:22:08.6796||GetCurrentUser.. t Transfer: 1220 : 30|16:22:08.6796|| OAuth authenticated t Transfer: 1220 : 30|16:22:08.6796|| user TMDDBA. t Transfer: 1220 : 30|16:22:08.6796||api user: TMDDBA t Transfer: 1220 : 12|16:22:11.9296||IsUserAuthenticated: /api/v3/config/detailsview/MediaDetails/Media_Tape?_dc=1576167731846 t Transfer: 1220 : 12|16:22:11.9296||GetCurrentUser.. t Transfer: 1220 : 12|16:22:11.9296|| OAuth authenticated t Transfer: 1220 : 12|16:22:11.9296|| user TMDDBA. t Transfer: 1220 : 12|16:22:11.9296||api user: TMDDBA t Transfer: 1220 : 40|16:22:14.4452||IsUserAuthenticated: /api/v3/config/detailsview/MediaDetails/Media_ServerClip?_dc=1576167734360 t Transfer: 1220 : 40|16:22:14.4452||GetCurrentUser.. t Transfer: 1220 : 40|16:22:14.4452|| OAuth authenticated t Transfer: 1220 : 40|16:22:14.4452|| user TMDDBA. t Transfer: 1220 : 40|16:22:14.4452||api user: TMDDBA t Transfer: 1220 : 30|16:22:16.3202||IsUserAuthenticated: /api/v3/config/detailsview/MediaDetails/Media_ServerArchived?_dc=1576167736215 t Transfer: 1220 : 30|16:22:16.3202||GetCurrentUser.. t Transfer: 1220 : 30|16:22:16.3202|| OAuth authenticated t Transfer: 1220 : 30|16:22:16.3202|| user TMDDBA. t Transfer: 1220 : 30|16:22:16.3202||api user: TMDDBA t Transfer: 1220 : 30|16:22:18.2265||IsUserAuthenticated: /api/v3/config/detailsview/MediaDetails/Media_DigitalImages?_dc=1576167738135 t Transfer: 1220 : 30|16:22:18.2265||GetCurrentUser.. t Transfer: 1220 : 30|16:22:18.2265|| OAuth authenticated t Transfer: 1220 : 30|16:22:18.2265|| user TMDDBA. t Transfer: 1220 : 30|16:22:18.2265||api user: TMDDBA t Transfer: 1220 : 11|16:23:32.9921||IsUserAuthenticated: /api/v3/config/detailsview/MediaDetails/Media_Subtitles?_dc=1576167812897 t Transfer: 1220 : 11|16:23:32.9921||GetCurrentUser.. t Transfer: 1220 : 11|16:23:32.9921|| OAuth authenticated t Transfer: 1220 : 11|16:23:32.9921|| user TMDDBA. t Transfer: 1220 : 11|16:23:32.9921||api user: TMDDBA t Transfer: 1220 : 38|16:23:40.9765||IsUserAuthenticated: /api/v3/config/detailsview/TitleDetails/Default?_dc=1576167820891 t Transfer: 1220 : 38|16:23:40.9765||GetCurrentUser.. t Transfer: 1220 : 38|16:23:40.9765|| OAuth authenticated t Transfer: 1220 : 38|16:23:40.9765|| user TMDDBA. t Transfer: 1220 : 38|16:23:40.9765||api user: TMDDBA t Transfer: 1220 : 42|16:23:52.7109||IsUserAuthenticated: /api/user-group-preferences?globals=htmlplayerhotkeys,audioOnFrameForward&_dc=1576167832816 t Transfer: 1220 : 42|16:23:52.7109||GetCurrentUser.. t Transfer: 1220 : 42|16:23:52.7109|| OAuth authenticated t Transfer: 1220 : 42|16:23:52.7109|| user TONY. t Transfer: 1220 : 42|16:23:52.7109||api user: TONY t Information: 1220 : 42|16:23:52.7109||V3Api.GetUserSettings t Transfer: 1220 : 42|16:23:52.7109||GetCurrentUser.. t Transfer: 1220 : 42|16:23:52.7109|| OAuth authenticated t Transfer: 1220 : 42|16:23:52.7109|| user TONY. t Transfer: 1220 : 38|16:24:26.4765||IsUserAuthenticated: /api/SearchSuggestion/?_dc=1576167866692 t Transfer: 1220 : 38|16:24:26.4765||GetCurrentUser.. t Transfer: 1220 : 38|16:24:26.4765|| OAuth authenticated t Transfer: 1220 : 38|16:24:26.4765|| user TONY. t Transfer: 1220 : 38|16:24:26.4765||api user: TONY t Transfer: 1220 : 38|16:24:26.4765||GetCurrentUser.. t Transfer: 1220 : 38|16:24:26.4765|| OAuth authenticated t Transfer: 1220 : 38|16:24:26.4765|| user TONY. t Transfer: 1220 : 40|16:24:26.5077||IsUserAuthenticated: /api/SearchSuggestion/?_dc=1576167866695 t Transfer: 1220 : 40|16:24:26.5077||GetCurrentUser.. t Transfer: 1220 : 40|16:24:26.5077|| OAuth authenticated t Transfer: 1220 : 40|16:24:26.5077|| user TONY. t Transfer: 1220 : 40|16:24:26.5077||api user: TONY t Transfer: 1220 : 40|16:24:26.5077||GetCurrentUser.. t Transfer: 1220 : 40|16:24:26.5077|| OAuth authenticated t Transfer: 1220 : 40|16:24:26.5077|| user TONY. t Transfer: 1220 : 25|16:24:26.5234||IsUserAuthenticated: /api/SearchSuggestion/?_dc=1576167866698 t Transfer: 1220 : 25|16:24:26.5234||GetCurrentUser.. t Transfer: 1220 : 25|16:24:26.5234|| OAuth authenticated t Transfer: 1220 : 25|16:24:26.5234|| user TONY. t Transfer: 1220 : 25|16:24:26.5234||api user: TONY t Transfer: 1220 : 25|16:24:26.5234||GetCurrentUser.. t Transfer: 1220 : 25|16:24:26.5234|| OAuth authenticated t Transfer: 1220 : 25|16:24:26.5234|| user TONY. t Transfer: 1220 : 23|16:24:26.5234||IsUserAuthenticated: /api/SearchSuggestion/?_dc=1576167866709 t Transfer: 1220 : 23|16:24:26.5234||GetCurrentUser.. t Transfer: 1220 : 23|16:24:26.5234|| OAuth authenticated t Transfer: 1220 : 23|16:24:26.5234|| user TONY. t Transfer: 1220 : 23|16:24:26.5234||api user: TONY t Transfer: 1220 : 23|16:24:26.5234||GetCurrentUser.. t Transfer: 1220 : 23|16:24:26.5234|| OAuth authenticated t Transfer: 1220 : 23|16:24:26.5234|| user TONY. t Transfer: 1220 : 30|16:24:26.5234||IsUserAuthenticated: /api/SearchSuggestion/?_dc=1576167866701 t Transfer: 1220 : 30|16:24:26.5234||GetCurrentUser.. t Transfer: 1220 : 30|16:24:26.5234|| OAuth authenticated t Transfer: 1220 : 30|16:24:26.5234|| user TONY. t Transfer: 1220 : 30|16:24:26.5234||api user: TONY t Transfer: 1220 : 30|16:24:26.5234||GetCurrentUser.. t Transfer: 1220 : 30|16:24:26.5234|| OAuth authenticated t Transfer: 1220 : 30|16:24:26.5234|| user TONY. t Transfer: 1220 : 31|16:24:26.5234||IsUserAuthenticated: /api/SearchSuggestion/?_dc=1576167866696 t Transfer: 1220 : 31|16:24:26.5234||GetCurrentUser.. t Transfer: 1220 : 31|16:24:26.5234|| OAuth authenticated t Transfer: 1220 : 31|16:24:26.5234|| user TONY. t Transfer: 1220 : 31|16:24:26.5234||api user: TONY t Transfer: 1220 : 31|16:24:26.5234||GetCurrentUser.. t Transfer: 1220 : 31|16:24:26.5234|| OAuth authenticated t Transfer: 1220 : 31|16:24:26.5234|| user TONY. t Transfer: 1220 : 37|16:24:26.5390||IsUserAuthenticated: /api/SearchSuggestion/?_dc=1576167866694 t Transfer: 1220 : 37|16:24:26.5390||GetCurrentUser.. t Transfer: 1220 : 37|16:24:26.5390|| OAuth authenticated t Transfer: 1220 : 37|16:24:26.5390|| user TONY. t Transfer: 1220 : 37|16:24:26.5390||api user: TONY t Transfer: 1220 : 37|16:24:26.5390||GetCurrentUser.. t Transfer: 1220 : 37|16:24:26.5390|| OAuth authenticated t Transfer: 1220 : 37|16:24:26.5390|| user TONY. t Transfer: 1220 : 18|16:24:26.5390||IsUserAuthenticated: /api/SearchSuggestion/?_dc=1576167866704 t Transfer: 1220 : 18|16:24:26.5390||GetCurrentUser.. t Transfer: 1220 : 18|16:24:26.5390|| OAuth authenticated t Transfer: 1220 : 18|16:24:26.5390|| user TONY. t Transfer: 1220 : 18|16:24:26.5390||api user: TONY t Transfer: 1220 : 18|16:24:26.5390||GetCurrentUser.. t Transfer: 1220 : 18|16:24:26.5390|| OAuth authenticated t Transfer: 1220 : 18|16:24:26.5390|| user TONY. t Transfer: 1220 : 13|16:24:26.6171||IsUserAuthenticated: /api/SearchSuggestion/?_dc=1576167866702 t Transfer: 1220 : 13|16:24:26.6171||GetCurrentUser.. t Transfer: 1220 : 13|16:24:26.6171|| OAuth authenticated t Transfer: 1220 : 13|16:24:26.6171|| user TONY. t Transfer: 1220 : 13|16:24:26.6171||api user: TONY t Transfer: 1220 : 13|16:24:26.6171||GetCurrentUser.. t Transfer: 1220 : 13|16:24:26.6171|| OAuth authenticated t Transfer: 1220 : 13|16:24:26.6171|| user TONY. t Transfer: 1220 : 10|16:24:26.6796||IsUserAuthenticated: /api/SearchSuggestion/?_dc=1576167866700 t Transfer: 1220 : 10|16:24:26.6796||GetCurrentUser.. t Transfer: 1220 : 10|16:24:26.6796|| OAuth authenticated t Transfer: 1220 : 10|16:24:26.6796|| user TONY. t Transfer: 1220 : 10|16:24:26.6796||api user: TONY t Transfer: 1220 : 8|16:24:26.6796||IsUserAuthenticated: /api/SearchSuggestion/?_dc=1576167866707 t Transfer: 1220 : 8|16:24:26.6796||GetCurrentUser.. t Transfer: 1220 : 8|16:24:26.6796|| OAuth authenticated t Transfer: 1220 : 8|16:24:26.6796|| user TONY. t Transfer: 1220 : 8|16:24:26.6796||api user: TONY t Transfer: 1220 : 10|16:24:26.6796||GetCurrentUser.. t Transfer: 1220 : 8|16:24:26.6796||GetCurrentUser.. t Transfer: 1220 : 8|16:24:26.6796|| OAuth authenticated t Transfer: 1220 : 8|16:24:26.6796|| user TONY. t Transfer: 1220 : 10|16:24:26.6796|| OAuth authenticated t Transfer: 1220 : 10|16:24:26.6796|| user TONY. t Transfer: 1220 : 10|16:24:27.2734||IsUserAuthenticated: /api/user-group-preferences?globals=htmlplayerhotkeys,audioOnFrameForward&_dc=1576167867474 t Transfer: 1220 : 10|16:24:27.2734||GetCurrentUser.. t Transfer: 1220 : 10|16:24:27.2734|| OAuth authenticated t Transfer: 1220 : 10|16:24:27.2734|| user TONY. t Transfer: 1220 : 10|16:24:27.2734||api user: TONY t Information: 1220 : 10|16:24:27.2734||V3Api.GetUserSettings t Transfer: 1220 : 10|16:24:27.2734||GetCurrentUser.. t Transfer: 1220 : 10|16:24:27.2734|| OAuth authenticated t Transfer: 1220 : 10|16:24:27.2734|| user TONY. t Transfer: 1220 : 25|16:24:28.4296||IsUserAuthenticated: /api/title-details/298279?_dc=1576167868623 t Transfer: 1220 : 25|16:24:28.4296||GetCurrentUser.. t Transfer: 1220 : 25|16:24:28.4296|| OAuth authenticated t Transfer: 1220 : 25|16:24:28.4296|| user TONY. t Transfer: 1220 : 25|16:24:28.4296||api user: TONY t Transfer: 1220 : 23|16:24:28.6171||IsUserAuthenticated: /api/search/title?_dc=1576167868819 t Transfer: 1220 : 23|16:24:28.6171||GetCurrentUser.. t Transfer: 1220 : 23|16:24:28.6171|| OAuth authenticated t Transfer: 1220 : 23|16:24:28.6171|| user TONY. t Transfer: 1220 : 23|16:24:28.6171||api user: TONY t Information: 1220 : 23|16:24:28.6171||V3Api.SearchTitles t Information: 1220 : 23|16:24:28.6171||V3Api.SearchGeneric t Transfer: 1220 : 23|16:24:28.6171||GetCurrentUser.. t Transfer: 1220 : 23|16:24:28.6171|| OAuth authenticated t Transfer: 1220 : 23|16:24:28.6171|| user TONY. t Transfer: 1220 : 23|16:24:28.6171||GetCurrentUser.. t Transfer: 1220 : 23|16:24:28.6171|| OAuth authenticated t Transfer: 1220 : 23|16:24:28.6171|| user TONY. t Information: 1220 : 23|16:24:28.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 Upper(a.ID) = Upper('298279') 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 : 41|16:24:28.7108||IsUserAuthenticated: /api/search/title?_dc=1576167868915 t Transfer: 1220 : 41|16:24:28.7108||GetCurrentUser.. t Transfer: 1220 : 41|16:24:28.7108|| OAuth authenticated t Transfer: 1220 : 41|16:24:28.7108|| user TONY. t Transfer: 1220 : 41|16:24:28.7108||api user: TONY t Information: 1220 : 41|16:24:28.7265||V3Api.SearchTitles t Information: 1220 : 41|16:24:28.7265||V3Api.SearchGeneric t Transfer: 1220 : 41|16:24:28.7265||GetCurrentUser.. t Transfer: 1220 : 41|16:24:28.7265|| OAuth authenticated t Transfer: 1220 : 41|16:24:28.7265|| user TONY. t Transfer: 1220 : 41|16:24:28.7265||GetCurrentUser.. t Transfer: 1220 : 41|16:24:28.7265|| OAuth authenticated t Transfer: 1220 : 41|16:24:28.7265|| user TONY. t Information: 1220 : 41|16:24:28.7265||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('298279') 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 : 22|16:25:27.0702||IsUserAuthenticated: /api/lookups/SearchSupportedOperators?_dc=1576167926979 t Transfer: 1220 : 22|16:25:27.0702||GetCurrentUser.. t Transfer: 1220 : 22|16:25:27.0702|| OAuth authenticated t Transfer: 1220 : 22|16:25:27.0702|| user TMDDBA. t Transfer: 1220 : 22|16:25:27.0702||api user: TMDDBA t Transfer: 1220 : 35|16:25:27.0702||IsUserAuthenticated: /api/user-preferences?keys=adv.recent.searches.media&_dc=1576167926984 t Transfer: 1220 : 35|16:25:27.0702||GetCurrentUser.. t Transfer: 1220 : 35|16:25:27.0702|| OAuth authenticated t Transfer: 1220 : 35|16:25:27.0702|| user TMDDBA. t Transfer: 1220 : 35|16:25:27.0702||api user: TMDDBA t Information: 1220 : 35|16:25:27.0702||GetUserDataByKeys: adv.recent.searches.media t Transfer: 1220 : 35|16:25:27.0702||GetCurrentUser.. t Transfer: 1220 : 35|16:25:27.0702|| OAuth authenticated t Transfer: 1220 : 35|16:25:27.0702|| user TMDDBA. t Transfer: 1220 : 31|16:25:27.0702||IsUserAuthenticated: /api/view/searchinfo/Media?_dc=1576167926977 t Transfer: 1220 : 31|16:25:27.0702||GetCurrentUser.. t Transfer: 1220 : 31|16:25:27.0702|| OAuth authenticated t Transfer: 1220 : 31|16:25:27.0702|| user TMDDBA. t Transfer: 1220 : 31|16:25:27.0702||api user: TMDDBA t Information: 1220 : 31|16:25:27.0702||GetAdvSearchColumns. search type Media grid . t Transfer: 1220 : 37|16:25:27.0702||IsUserAuthenticated: /api/settings/user/searchLayoutConfig?_dc=1576167926992 t Transfer: 1220 : 37|16:25:27.0702||GetCurrentUser.. t Transfer: 1220 : 37|16:25:27.0702|| OAuth authenticated t Transfer: 1220 : 37|16:25:27.0702|| user TMDDBA. t Transfer: 1220 : 37|16:25:27.0702||api user: TMDDBA t Information: 1220 : 37|16:25:27.0702||V3Api.GetUserSettings t Transfer: 1220 : 37|16:25:27.0702||GetCurrentUser.. t Transfer: 1220 : 37|16:25:27.0702|| OAuth authenticated t Transfer: 1220 : 37|16:25:27.0702|| user TMDDBA. t Transfer: 1220 : 13|16:25:27.0858||IsUserAuthenticated: /api/view/info/MediaGrid?lang=en-GB&_dc=1576167927012 t Transfer: 1220 : 13|16:25:27.0858||GetCurrentUser.. t Transfer: 1220 : 13|16:25:27.0858|| OAuth authenticated t Transfer: 1220 : 13|16:25:27.0858|| user TMDDBA. t Transfer: 1220 : 13|16:25:27.0858||api user: TMDDBA t Information: 1220 : 13|16:25:27.0858||GetGridViewBuilder. builder type MediaGrid. t Transfer: 1220 : 13|16:25:27.0858||GetCurrentUser.. t Transfer: 1220 : 13|16:25:27.0858|| OAuth authenticated t Transfer: 1220 : 13|16:25:27.0858|| user TMDDBA. t Information: 1220 : 13|16:25:27.0858||UserGridView. LoadView. ID 311, Name Default. t Transfer: 1220 : 13|16:25:27.0858||GetCurrentUser.. t Transfer: 1220 : 13|16:25:27.0858|| OAuth authenticated t Transfer: 1220 : 13|16:25:27.0858|| user TMDDBA. t Transfer: 1220 : 13|16:25:27.0858||GetCurrentUser.. t Transfer: 1220 : 13|16:25:27.0858|| OAuth authenticated t Transfer: 1220 : 13|16:25:27.0858|| user TMDDBA. t Transfer: 1220 : 30|16:25:27.1171||IsUserAuthenticated: /api/view/searches/Media?_dc=1576167927048 t Transfer: 1220 : 30|16:25:27.1171||GetCurrentUser.. t Transfer: 1220 : 30|16:25:27.1171|| OAuth authenticated t Transfer: 1220 : 30|16:25:27.1171|| user TMDDBA. t Transfer: 1220 : 30|16:25:27.1171||api user: TMDDBA t Information: 1220 : 30|16:25:27.1171||GetSavedSearchNames. search type Media. t Transfer: 1220 : 30|16:25:27.1171||GetCurrentUser.. t Transfer: 1220 : 30|16:25:27.1171|| OAuth authenticated t Transfer: 1220 : 30|16:25:27.1171|| user TMDDBA. t Transfer: 1220 : 44|16:25:28.7108||IsUserAuthenticated: /api/SearchSuggestion/?_dc=1576167928632 t Transfer: 1220 : 44|16:25:28.7108||GetCurrentUser.. t Transfer: 1220 : 44|16:25:28.7108|| OAuth authenticated t Transfer: 1220 : 44|16:25:28.7108|| user TMDDBA. t Transfer: 1220 : 44|16:25:28.7108||api user: TMDDBA t Transfer: 1220 : 44|16:25:28.7108||GetCurrentUser.. t Transfer: 1220 : 44|16:25:28.7108|| OAuth authenticated t Transfer: 1220 : 44|16:25:28.7108|| user TMDDBA. t Transfer: 1220 : 18|16:25:28.8514||IsUserAuthenticated: /api/search/Media?_dc=1576167928771 t Transfer: 1220 : 18|16:25:28.8514||GetCurrentUser.. t Transfer: 1220 : 18|16:25:28.8514|| OAuth authenticated t Transfer: 1220 : 18|16:25:28.8514|| user TMDDBA. t Transfer: 1220 : 18|16:25:28.8514||api user: TMDDBA t Information: 1220 : 18|16:25:28.8514||V3Api.SearchMedia t Information: 1220 : 18|16:25:28.8514||V3Api.SearchGeneric t Transfer: 1220 : 18|16:25:28.8514||GetCurrentUser.. t Transfer: 1220 : 18|16:25:28.8514|| OAuth authenticated t Transfer: 1220 : 18|16:25:28.8514|| user TMDDBA. t Information: 1220 : 18|16:25:28.8827||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 : 18|16:25:28.9608|| timing: 00:00:00.1076095 t Verbose: 1220 : 18|16:25:28.9608||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\England v Bangladesh Match Group A.mp4 subfolder t Verbose: 1220 : 18|16:25:28.9608|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/England v Bangladesh Match Group A.mp4 t Verbose: 1220 : 18|16:25:28.9608||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/England v Bangladesh Match Group A.mp4 t Transfer: 1220 : 18|16:25:28.9608||GetCurrentUser.. t Transfer: 1220 : 18|16:25:28.9608|| OAuth authenticated t Transfer: 1220 : 18|16:25:28.9608|| user TMDDBA. t Verbose: 1220 : 18|16:25:28.9608||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\ICC 360 Cricket for Change.mp4 subfolder t Verbose: 1220 : 18|16:25:28.9608|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/ICC 360 Cricket for Change.mp4 t Verbose: 1220 : 18|16:25:28.9608||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/ICC 360 Cricket for Change.mp4 t Transfer: 1220 : 18|16:25:28.9608||GetCurrentUser.. t Transfer: 1220 : 18|16:25:28.9608|| OAuth authenticated t Transfer: 1220 : 18|16:25:28.9608|| user TMDDBA. t Verbose: 1220 : 18|16:25:28.9608||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Australia vs South Africa Match 45.mp4 subfolder t Verbose: 1220 : 18|16:25:28.9608|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Australia vs South Africa Match 45.mp4 t Verbose: 1220 : 18|16:25:28.9608||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/Australia vs South Africa Match 45.mp4 t Transfer: 1220 : 18|16:25:28.9608||GetCurrentUser.. t Transfer: 1220 : 18|16:25:28.9608|| OAuth authenticated t Transfer: 1220 : 18|16:25:28.9608|| user TMDDBA. t Verbose: 1220 : 18|16:25:28.9608||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\England vs South Africa Match 1.mp4 subfolder t Verbose: 1220 : 18|16:25:28.9608|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/England vs South Africa Match 1.mp4 t Verbose: 1220 : 18|16:25:28.9608||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/England vs South Africa Match 1.mp4 t Transfer: 1220 : 18|16:25:28.9608||GetCurrentUser.. t Transfer: 1220 : 18|16:25:28.9608|| OAuth authenticated t Transfer: 1220 : 18|16:25:28.9608|| user TMDDBA. t Verbose: 1220 : 18|16:25:28.9608||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\West Indies vs Pakistan Match 2.mp4 subfolder t Verbose: 1220 : 18|16:25:28.9608|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/West Indies vs Pakistan Match 2.mp4 t Verbose: 1220 : 18|16:25:28.9608||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/West Indies vs Pakistan Match 2.mp4 t Transfer: 1220 : 18|16:25:28.9608||GetCurrentUser.. t Transfer: 1220 : 18|16:25:28.9608|| OAuth authenticated t Transfer: 1220 : 18|16:25:28.9608|| user TMDDBA. t Verbose: 1220 : 18|16:25:28.9765||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\New Zealand vs England Final.mp4 subfolder t Verbose: 1220 : 18|16:25:28.9765|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/New Zealand vs England Final.mp4 t Verbose: 1220 : 18|16:25:28.9765||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/New Zealand vs England Final.mp4 t Transfer: 1220 : 18|16:25:28.9765||GetCurrentUser.. t Transfer: 1220 : 18|16:25:28.9765|| OAuth authenticated t Transfer: 1220 : 18|16:25:28.9765|| user TMDDBA. t Verbose: 1220 : 18|16:25:28.9765||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 : 18|16:25:28.9765|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Australia vs England Short Semi Final 2.mp4 t Verbose: 1220 : 18|16:25:28.9765||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/Australia vs England Short Semi Final 2.mp4 t Transfer: 1220 : 18|16:25:28.9765||GetCurrentUser.. t Transfer: 1220 : 18|16:25:28.9765|| OAuth authenticated t Transfer: 1220 : 18|16:25:28.9765|| user TMDDBA. t Verbose: 1220 : 18|16:25:28.9765||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 : 18|16:25:28.9765|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/India vs New Zealand Semi Final 1.mp4 t Verbose: 1220 : 18|16:25:28.9765||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/India vs New Zealand Semi Final 1.mp4 t Transfer: 1220 : 18|16:25:28.9765||GetCurrentUser.. t Transfer: 1220 : 18|16:25:28.9765|| OAuth authenticated t Transfer: 1220 : 18|16:25:28.9765|| user TMDDBA. t Verbose: 1220 : 18|16:25:28.9765||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 : 18|16:25:28.9765|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Scotland vs Oman 5th Place Play Off.mp4 t Verbose: 1220 : 18|16:25:28.9765||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/Scotland vs Oman 5th Place Play Off.mp4 t Transfer: 1220 : 18|16:25:28.9765||GetCurrentUser.. t Transfer: 1220 : 18|16:25:28.9765|| OAuth authenticated t Transfer: 1220 : 18|16:25:28.9765|| user TMDDBA. t Verbose: 1220 : 18|16:25:28.9765||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\South Africa vs Bangladesh Match 5 .mp4 subfolder t Verbose: 1220 : 18|16:25:28.9765|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/South Africa vs Bangladesh Match 5 .mp4 t Verbose: 1220 : 18|16:25:28.9765||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/South Africa vs Bangladesh Match 5 .mp4 t Transfer: 1220 : 18|16:25:28.9765||GetCurrentUser.. t Transfer: 1220 : 18|16:25:28.9765|| OAuth authenticated t Transfer: 1220 : 18|16:25:28.9765|| user TMDDBA. t Verbose: 1220 : 18|16:25:28.9921||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 : 18|16:25:28.9921|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/New Zealand vs Sri Lanka Match 3.mp4 t Verbose: 1220 : 18|16:25:28.9921||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/New Zealand vs Sri Lanka Match 3.mp4 t Transfer: 1220 : 18|16:25:28.9921||GetCurrentUser.. t Transfer: 1220 : 18|16:25:28.9921|| OAuth authenticated t Transfer: 1220 : 18|16:25:28.9921|| user TMDDBA. t Verbose: 1220 : 18|16:25:28.9921||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Afghanistan vs Australia Match 4.mp4 subfolder t Verbose: 1220 : 18|16:25:28.9921|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Afghanistan vs Australia Match 4.mp4 t Verbose: 1220 : 18|16:25:28.9921||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/Afghanistan vs Australia Match 4.mp4 t Transfer: 1220 : 18|16:25:28.9921||GetCurrentUser.. t Transfer: 1220 : 18|16:25:28.9921|| OAuth authenticated t Transfer: 1220 : 18|16:25:28.9921|| user TMDDBA. t Verbose: 1220 : 18|16:25:28.9921||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Bangladesh vs New Zealand Match 9.mp4 subfolder t Verbose: 1220 : 18|16:25:28.9921|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Bangladesh vs New Zealand Match 9.mp4 t Verbose: 1220 : 18|16:25:28.9921||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/Bangladesh vs New Zealand Match 9.mp4 t Transfer: 1220 : 18|16:25:28.9921||GetCurrentUser.. t Transfer: 1220 : 18|16:25:28.9921|| OAuth authenticated t Transfer: 1220 : 18|16:25:28.9921|| user TMDDBA. t Verbose: 1220 : 18|16:25:28.9921||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Afghanistan vs Sri Lanka Match 7.mp4 subfolder t Verbose: 1220 : 18|16:25:28.9921|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Afghanistan vs Sri Lanka Match 7.mp4 t Verbose: 1220 : 18|16:25:28.9921||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/Afghanistan vs Sri Lanka Match 7.mp4 t Transfer: 1220 : 18|16:25:28.9921||GetCurrentUser.. t Transfer: 1220 : 18|16:25:28.9921|| OAuth authenticated t Transfer: 1220 : 18|16:25:28.9921|| user TMDDBA. t Verbose: 1220 : 18|16:25:28.9921||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Australia vs West Indies Match 10.mp4 subfolder t Verbose: 1220 : 18|16:25:28.9921|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Australia vs West Indies Match 10.mp4 t Verbose: 1220 : 18|16:25:28.9921||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/Australia vs West Indies Match 10.mp4 t Transfer: 1220 : 18|16:25:28.9921||GetCurrentUser.. t Transfer: 1220 : 18|16:25:28.9921|| OAuth authenticated t Transfer: 1220 : 18|16:25:28.9921|| user TMDDBA. t Verbose: 1220 : 18|16:25:28.9921||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\South Africa vs India Match 8.mp4 subfolder t Verbose: 1220 : 18|16:25:28.9921|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/South Africa vs India Match 8.mp4 t Verbose: 1220 : 18|16:25:28.9921||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/South Africa vs India Match 8.mp4 t Transfer: 1220 : 18|16:25:28.9921||GetCurrentUser.. t Transfer: 1220 : 18|16:25:28.9921|| OAuth authenticated t Transfer: 1220 : 18|16:25:28.9921|| user TMDDBA. t Verbose: 1220 : 18|16:25:28.9921||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\England vs Pakistan Match 6.mp4 subfolder t Verbose: 1220 : 18|16:25:28.9921|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/England vs Pakistan Match 6.mp4 t Verbose: 1220 : 18|16:25:28.9921||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/England vs Pakistan Match 6.mp4 t Transfer: 1220 : 18|16:25:28.9921||GetCurrentUser.. t Transfer: 1220 : 18|16:25:28.9921|| OAuth authenticated t Transfer: 1220 : 18|16:25:28.9921|| user TMDDBA. t Verbose: 1220 : 18|16:25:28.9921||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Pakistan vs Sri Lanka Match 11.mp4 subfolder t Verbose: 1220 : 18|16:25:28.9921|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Pakistan vs Sri Lanka Match 11.mp4 t Verbose: 1220 : 18|16:25:28.9921||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/Pakistan vs Sri Lanka Match 11.mp4 t Transfer: 1220 : 18|16:25:28.9921||GetCurrentUser.. t Transfer: 1220 : 18|16:25:28.9921|| OAuth authenticated t Transfer: 1220 : 18|16:25:28.9921|| user TMDDBA. t Transfer: 1220 : 18|16:25:29.0858||IsUserAuthenticated: /api/user-preferences?_dc=1576167929009 t Transfer: 1220 : 18|16:25:29.0858||GetCurrentUser.. t Transfer: 1220 : 18|16:25:29.0858|| OAuth authenticated t Transfer: 1220 : 18|16:25:29.0858|| user TMDDBA. t Transfer: 1220 : 18|16:25:29.0858||api user: TMDDBA t Verbose: 1220 : 18|16:25:29.0858||StoreUserDataByKeys.. t Transfer: 1220 : 18|16:25:29.0858||GetCurrentUser.. t Transfer: 1220 : 18|16:25:29.0858|| OAuth authenticated t Transfer: 1220 : 18|16:25:29.0858|| user TMDDBA. t Transfer: 1220 : 18|16:25:32.7889||IsUserAuthenticated: /api/media-details/298533?_dc=1576167932710 t Transfer: 1220 : 18|16:25:32.7889||GetCurrentUser.. t Transfer: 1220 : 18|16:25:32.7889|| OAuth authenticated t Transfer: 1220 : 18|16:25:32.7889|| user TMDDBA. t Transfer: 1220 : 18|16:25:32.7889||api user: TMDDBA t Transfer: 1220 : 18|16:25:32.7889||GetCurrentUser.. t Transfer: 1220 : 18|16:25:32.7889|| OAuth authenticated t Transfer: 1220 : 18|16:25:32.7889|| user TMDDBA. t Information: 1220 : 18|16:25:33.2890||TM_MIS. LoadSubtitles for ID: 298533. t Information: 1220 : 18|16:25:33.2890||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 : 18|16:25:33.2890||TM_MIS. LoadSubtitles for ID: 298533 found no subtitles. t Verbose: 1220 : 18|16:25:33.4140||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Australia vs South Africa Match 45.mp4 subfolder t Verbose: 1220 : 18|16:25:33.4140|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Australia vs South Africa Match 45.mp4 t Verbose: 1220 : 18|16:25:33.4140||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/Australia vs South Africa Match 45.mp4 t Transfer: 1220 : 18|16:25:33.4140||GetCurrentUser.. t Transfer: 1220 : 18|16:25:33.4140|| OAuth authenticated t Transfer: 1220 : 18|16:25:33.4140|| user TMDDBA. t Transfer: 1220 : 31|16:25:33.4452||IsUserAuthenticated: /api/v3/detailsview/MediaDetails/5?lang=en-GB&_dc=1576167933370 t Transfer: 1220 : 31|16:25:33.4452||GetCurrentUser.. t Transfer: 1220 : 31|16:25:33.4452|| OAuth authenticated t Transfer: 1220 : 31|16:25:33.4452|| user TMDDBA. t Transfer: 1220 : 31|16:25:33.4452||api user: TMDDBA t Transfer: 1220 : 35|16:25:33.4921||IsUserAuthenticated: /api/media-captions/298533?_dc=1576167933411 t Transfer: 1220 : 35|16:25:33.4921||GetCurrentUser.. t Transfer: 1220 : 35|16:25:33.4921|| OAuth authenticated t Transfer: 1220 : 35|16:25:33.4921|| user TMDDBA. t Transfer: 1220 : 35|16:25:33.4921||api user: TMDDBA t Transfer: 1220 : 35|16:25:33.5546||IsUserAuthenticated: /api/lookups/FriendlyNames?_dc=1576167933467 t Transfer: 1220 : 35|16:25:33.5546||GetCurrentUser.. t Transfer: 1220 : 35|16:25:33.5546|| OAuth authenticated t Transfer: 1220 : 35|16:25:33.5546|| user TMDDBA. t Transfer: 1220 : 35|16:25:33.5546||api user: TMDDBA t Transfer: 1220 : 31|16:25:33.7421||IsUserAuthenticated: /api/user-group-preferences?globals=htmlplayerhotkeys,audioOnFrameForward&_dc=1576167933659 t Transfer: 1220 : 31|16:25:33.7421||GetCurrentUser.. t Transfer: 1220 : 31|16:25:33.7421|| OAuth authenticated t Transfer: 1220 : 31|16:25:33.7421|| user TMDDBA. t Transfer: 1220 : 31|16:25:33.7421||api user: TMDDBA t Information: 1220 : 31|16:25:33.7421||V3Api.GetUserSettings t Transfer: 1220 : 31|16:25:33.7421||GetCurrentUser.. t Transfer: 1220 : 31|16:25:33.7421|| OAuth authenticated t Transfer: 1220 : 31|16:25:33.7421|| user TMDDBA. t Transfer: 1220 : 31|16:25:33.8671||IsUserAuthenticated: /api/lookups/MediaEventTypes?_dc=1576167933789 t Transfer: 1220 : 31|16:25:33.8671||GetCurrentUser.. t Transfer: 1220 : 31|16:25:33.8671|| OAuth authenticated t Transfer: 1220 : 31|16:25:33.8671|| user TMDDBA. t Transfer: 1220 : 31|16:25:33.8671||api user: TMDDBA t Transfer: 1220 : 30|16:25:34.2265||IsUserAuthenticated: /api/v3/media/related/298533/audio?_dc=1576167934154 t Transfer: 1220 : 30|16:25:34.2265||GetCurrentUser.. t Transfer: 1220 : 30|16:25:34.2265|| OAuth authenticated t Transfer: 1220 : 30|16:25:34.2265|| user TMDDBA. t Transfer: 1220 : 30|16:25:34.2265||api user: TMDDBA t Transfer: 1220 : 31|16:25:34.2733||IsUserAuthenticated: /api/mediavideo/298533?info=smudge,scene,audiovolume&_dc=1576167934200 t Transfer: 1220 : 31|16:25:34.2733||GetCurrentUser.. t Transfer: 1220 : 31|16:25:34.2733|| OAuth authenticated t Transfer: 1220 : 31|16:25:34.2733|| user TMDDBA. t Transfer: 1220 : 31|16:25:34.2733||api user: TMDDBA t Verbose: 1220 : 31|16:25:34.2890||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Australia vs South Africa Match 45.mp4 subfolder t Verbose: 1220 : 31|16:25:34.2890|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Australia vs South Africa Match 45.mp4 t Verbose: 1220 : 31|16:25:34.2890||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/Australia vs South Africa Match 45.mp4 t Transfer: 1220 : 31|16:25:34.2890||GetCurrentUser.. t Transfer: 1220 : 31|16:25:34.2890|| OAuth authenticated t Transfer: 1220 : 31|16:25:34.2890|| user TMDDBA. t Transfer: 1220 : 18|16:25:34.3515||IsUserAuthenticated: /api/v3/ai-tags/298533?_dc=1576167934260 t Transfer: 1220 : 18|16:25:34.3515||GetCurrentUser.. t Transfer: 1220 : 18|16:25:34.3515|| OAuth authenticated t Transfer: 1220 : 18|16:25:34.3515|| user TMDDBA. t Transfer: 1220 : 18|16:25:34.3515||api user: TMDDBA t Information: 1220 : 18|16:25:34.3515||V3Api.GetMediaAiTags t Transfer: 1220 : 44|16:25:35.1952||IsUserAuthenticated: /api/mediavideo/298533?info=smudge&_dc=1576167935112 t Transfer: 1220 : 44|16:25:35.1952||GetCurrentUser.. t Transfer: 1220 : 44|16:25:35.1952|| OAuth authenticated t Transfer: 1220 : 44|16:25:35.1952|| user TMDDBA. t Transfer: 1220 : 44|16:25:35.1952||api user: TMDDBA t Verbose: 1220 : 44|16:25:35.1952||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:25:35.1952|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Australia vs South Africa Match 45.mp4 t Verbose: 1220 : 44|16:25:35.1952||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/Australia vs South Africa Match 45.mp4 t Transfer: 1220 : 44|16:25:35.1952||GetCurrentUser.. t Transfer: 1220 : 44|16:25:35.1952|| OAuth authenticated t Transfer: 1220 : 44|16:25:35.1952|| user TMDDBA. t Transfer: 1220 : 30|16:25:35.5077||IsUserAuthenticated: /api/metadata/4000/298533?_dc=1576167935431 t Transfer: 1220 : 30|16:25:35.5077||GetCurrentUser.. t Transfer: 1220 : 30|16:25:35.5077|| OAuth authenticated t Transfer: 1220 : 30|16:25:35.5077|| user TMDDBA. t Transfer: 1220 : 30|16:25:35.5077||api user: TMDDBA t Transfer: 1220 : 13|16:26:05.7421||IsUserAuthenticated: /api/user-group-preferences?globals=htmlplayerhotkeys,audioOnFrameForward&_dc=1576167965666 t Transfer: 1220 : 13|16:26:05.7421||GetCurrentUser.. t Transfer: 1220 : 13|16:26:05.7421|| OAuth authenticated t Transfer: 1220 : 13|16:26:05.7421|| user TMDDBA. t Transfer: 1220 : 13|16:26:05.7421||api user: TMDDBA t Information: 1220 : 13|16:26:05.7421||V3Api.GetUserSettings t Transfer: 1220 : 13|16:26:05.7421||GetCurrentUser.. t Transfer: 1220 : 13|16:26:05.7421|| OAuth authenticated t Transfer: 1220 : 13|16:26:05.7421|| user TMDDBA. t Transfer: 1220 : 38|16:26:11.5859||IsUserAuthenticated: /api/media-details/298533?_dc=1576167971501 t Transfer: 1220 : 38|16:26:11.5859||GetCurrentUser.. t Transfer: 1220 : 38|16:26:11.5859|| OAuth authenticated t Transfer: 1220 : 38|16:26:11.5859|| user TMDDBA. t Transfer: 1220 : 38|16:26:11.5859||api user: TMDDBA t Transfer: 1220 : 38|16:26:11.5859||GetCurrentUser.. t Transfer: 1220 : 38|16:26:11.5859|| OAuth authenticated t Transfer: 1220 : 38|16:26:11.5859|| user TMDDBA. t Information: 1220 : 38|16:26:11.6015||TM_MIS. LoadSubtitles for ID: 298533. t Information: 1220 : 38|16:26:11.6015||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 : 38|16:26:11.6015||TM_MIS. LoadSubtitles for ID: 298533 found no subtitles. t Verbose: 1220 : 38|16:26:11.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 : 38|16:26:11.6327|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Australia vs South Africa Match 45.mp4 t Verbose: 1220 : 38|16:26:11.6327||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/Australia vs South Africa Match 45.mp4 t Transfer: 1220 : 38|16:26:11.6327||GetCurrentUser.. t Transfer: 1220 : 38|16:26:11.6327|| OAuth authenticated t Transfer: 1220 : 38|16:26:11.6327|| user TMDDBA. t Transfer: 1220 : 28|16:26:11.6796||IsUserAuthenticated: /api/media-captions/298533?_dc=1576167971608 t Transfer: 1220 : 28|16:26:11.6796||GetCurrentUser.. t Transfer: 1220 : 28|16:26:11.6796|| OAuth authenticated t Transfer: 1220 : 28|16:26:11.6796|| user TMDDBA. t Transfer: 1220 : 28|16:26:11.6796||api user: TMDDBA t Transfer: 1220 : 38|16:26:11.7577||IsUserAuthenticated: /api/user-group-preferences?globals=htmlplayerhotkeys,audioOnFrameForward&_dc=1576167971681 t Transfer: 1220 : 38|16:26:11.7577||GetCurrentUser.. t Transfer: 1220 : 38|16:26:11.7577|| OAuth authenticated t Transfer: 1220 : 38|16:26:11.7577|| user TMDDBA. t Transfer: 1220 : 38|16:26:11.7577||api user: TMDDBA t Information: 1220 : 38|16:26:11.7577||V3Api.GetUserSettings t Transfer: 1220 : 38|16:26:11.7577||GetCurrentUser.. t Transfer: 1220 : 38|16:26:11.7577|| OAuth authenticated t Transfer: 1220 : 38|16:26:11.7577|| user TMDDBA. t Transfer: 1220 : 22|16:26:12.2108||IsUserAuthenticated: /api/v3/media/related/298533/audio?_dc=1576167972140 t Transfer: 1220 : 22|16:26:12.2108||GetCurrentUser.. t Transfer: 1220 : 22|16:26:12.2264|| OAuth authenticated t Transfer: 1220 : 22|16:26:12.2264|| user TMDDBA. t Transfer: 1220 : 22|16:26:12.2264||api user: TMDDBA t Transfer: 1220 : 25|16:26:12.2577||IsUserAuthenticated: /api/mediavideo/298533?info=smudge,scene,audiovolume&_dc=1576167972184 t Transfer: 1220 : 25|16:26:12.2577||GetCurrentUser.. t Transfer: 1220 : 25|16:26:12.2577|| OAuth authenticated t Transfer: 1220 : 25|16:26:12.2577|| user TMDDBA. t Transfer: 1220 : 25|16:26:12.2577||api user: TMDDBA t Verbose: 1220 : 25|16:26:12.2577||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Australia vs South Africa Match 45.mp4 subfolder t Verbose: 1220 : 25|16:26:12.2577|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Australia vs South Africa Match 45.mp4 t Verbose: 1220 : 25|16:26:12.2577||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/Australia vs South Africa Match 45.mp4 t Transfer: 1220 : 25|16:26:12.2577||GetCurrentUser.. t Transfer: 1220 : 25|16:26:12.2577|| OAuth authenticated t Transfer: 1220 : 25|16:26:12.2577|| user TMDDBA. t Transfer: 1220 : 22|16:26:12.2890||IsUserAuthenticated: /api/v3/ai-tags/298533?_dc=1576167972215 t Transfer: 1220 : 22|16:26:12.2890||GetCurrentUser.. t Transfer: 1220 : 22|16:26:12.2890|| OAuth authenticated t Transfer: 1220 : 22|16:26:12.2890|| user TMDDBA. t Transfer: 1220 : 22|16:26:12.2890||api user: TMDDBA t Information: 1220 : 22|16:26:12.2890||V3Api.GetMediaAiTags t Transfer: 1220 : 25|16:26:13.1483||IsUserAuthenticated: /api/mediavideo/298533?info=smudge&_dc=1576167973081 t Transfer: 1220 : 25|16:26:13.1483||GetCurrentUser.. t Transfer: 1220 : 25|16:26:13.1483|| OAuth authenticated t Transfer: 1220 : 25|16:26:13.1483|| user TMDDBA. t Transfer: 1220 : 25|16:26:13.1483||api user: TMDDBA t Verbose: 1220 : 25|16:26:13.1640||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Australia vs South Africa Match 45.mp4 subfolder t Verbose: 1220 : 25|16:26:13.1640|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Australia vs South Africa Match 45.mp4 t Verbose: 1220 : 25|16:26:13.1640||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/Australia vs South Africa Match 45.mp4 t Transfer: 1220 : 25|16:26:13.1640||GetCurrentUser.. t Transfer: 1220 : 25|16:26:13.1640|| OAuth authenticated t Transfer: 1220 : 25|16:26:13.1640|| user TMDDBA. t Transfer: 1220 : 23|16:26:13.4608||IsUserAuthenticated: /api/metadata/4000/298533?_dc=1576167973389 t Transfer: 1220 : 23|16:26:13.4608||GetCurrentUser.. t Transfer: 1220 : 23|16:26:13.4608|| OAuth authenticated t Transfer: 1220 : 23|16:26:13.4608|| user TMDDBA. t Transfer: 1220 : 23|16:26:13.4608||api user: TMDDBA t Transfer: 1220 : 25|16:26:50.9765||IsUserAuthenticated: /api/media-details/298539?_dc=1576168011110 t Transfer: 1220 : 25|16:26:50.9765||GetCurrentUser.. t Transfer: 1220 : 25|16:26:50.9765|| OAuth authenticated t Transfer: 1220 : 25|16:26:50.9765|| user TONY. t Transfer: 1220 : 25|16:26:50.9765||api user: TONY t Transfer: 1220 : 25|16:26:50.9765||GetCurrentUser.. t Transfer: 1220 : 25|16:26:50.9765|| OAuth authenticated t Transfer: 1220 : 25|16:26:50.9765|| user TONY. t Information: 1220 : 25|16:26:50.9921||TM_MIS. LoadSubtitles for ID: 298539. t Information: 1220 : 25|16:26:50.9921||TM_MIS. LoadSubtitles for ID: 298539. 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=298380' t Information: 1220 : 25|16:26:50.9921||TM_MIS. LoadSubtitles for ID: 298539 found no subtitles. t Verbose: 1220 : 25|16:26:51.0233||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\England vs South Africa Match 1.mp4 subfolder t Verbose: 1220 : 25|16:26:51.0233|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/England vs South Africa Match 1.mp4 t Verbose: 1220 : 25|16:26:51.0233||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/England vs South Africa Match 1.mp4 t Transfer: 1220 : 25|16:26:51.0233||GetCurrentUser.. t Transfer: 1220 : 25|16:26:51.0233|| OAuth authenticated t Transfer: 1220 : 25|16:26:51.0233|| user TONY. t Transfer: 1220 : 31|16:26:52.1639||IsUserAuthenticated: /api/v3/detailsview/MediaDetails/5?lang=en-US&_dc=1576168012230 t Transfer: 1220 : 31|16:26:52.1639||GetCurrentUser.. t Transfer: 1220 : 31|16:26:52.1639|| OAuth authenticated t Transfer: 1220 : 31|16:26:52.1639|| user TONY. t Transfer: 1220 : 31|16:26:52.1639||api user: TONY t Transfer: 1220 : 37|16:26:52.2890||IsUserAuthenticated: /api/media-captions/298539?_dc=1576168012491 t Transfer: 1220 : 37|16:26:52.2890||GetCurrentUser.. t Transfer: 1220 : 37|16:26:52.2890|| OAuth authenticated t Transfer: 1220 : 37|16:26:52.2890|| user TONY. t Transfer: 1220 : 37|16:26:52.2890||api user: TONY t Transfer: 1220 : 18|16:26:52.3046||IsUserAuthenticated: /api/lookups/FriendlyNames?_dc=1576168012508 t Transfer: 1220 : 18|16:26:52.3046||GetCurrentUser.. t Transfer: 1220 : 18|16:26:52.3046|| OAuth authenticated t Transfer: 1220 : 18|16:26:52.3046|| user TONY. t Transfer: 1220 : 18|16:26:52.3046||api user: TONY t Transfer: 1220 : 37|16:26:52.3202||IsUserAuthenticated: /api/user-group-preferences?globals=htmlplayerhotkeys,audioOnFrameForward&_dc=1576168012528 t Transfer: 1220 : 37|16:26:52.3202||GetCurrentUser.. t Transfer: 1220 : 37|16:26:52.3202|| OAuth authenticated t Transfer: 1220 : 37|16:26:52.3202|| user TONY. t Transfer: 1220 : 37|16:26:52.3202||api user: TONY t Information: 1220 : 37|16:26:52.3202||V3Api.GetUserSettings t Transfer: 1220 : 37|16:26:52.3202||GetCurrentUser.. t Transfer: 1220 : 37|16:26:52.3202|| OAuth authenticated t Transfer: 1220 : 37|16:26:52.3202|| user TONY. t Transfer: 1220 : 31|16:26:52.3671||IsUserAuthenticated: /api/lookups/MediaEventTypes?_dc=1576168012585 t Transfer: 1220 : 31|16:26:52.3827||GetCurrentUser.. t Transfer: 1220 : 31|16:26:52.3827|| OAuth authenticated t Transfer: 1220 : 31|16:26:52.3827|| user TONY. t Transfer: 1220 : 31|16:26:52.3827||api user: TONY t Transfer: 1220 : 25|16:26:52.5390||IsUserAuthenticated: /api/v3/media/related/298539/audio?_dc=1576168012728 t Transfer: 1220 : 25|16:26:52.5390||GetCurrentUser.. t Transfer: 1220 : 25|16:26:52.5390|| OAuth authenticated t Transfer: 1220 : 25|16:26:52.5390|| user TONY. t Transfer: 1220 : 25|16:26:52.5390||api user: TONY t Transfer: 1220 : 18|16:26:52.5546||IsUserAuthenticated: /api/mediavideo/298539?info=smudge,scene,audiovolume&_dc=1576168012749 t Transfer: 1220 : 18|16:26:52.5546||GetCurrentUser.. t Transfer: 1220 : 18|16:26:52.5546|| OAuth authenticated t Transfer: 1220 : 18|16:26:52.5546|| user TONY. t Transfer: 1220 : 18|16:26:52.5546||api user: TONY t Verbose: 1220 : 18|16:26:52.5546||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\England vs South Africa Match 1.mp4 subfolder t Verbose: 1220 : 18|16:26:52.5546|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/England vs South Africa Match 1.mp4 t Verbose: 1220 : 18|16:26:52.5546||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/England vs South Africa Match 1.mp4 t Transfer: 1220 : 18|16:26:52.5546||GetCurrentUser.. t Transfer: 1220 : 18|16:26:52.5546|| OAuth authenticated t Transfer: 1220 : 18|16:26:52.5546|| user TONY. t Transfer: 1220 : 31|16:26:52.5702||IsUserAuthenticated: /api/v3/ai-tags/298539?_dc=1576168012774 t Transfer: 1220 : 31|16:26:52.5702||GetCurrentUser.. t Transfer: 1220 : 31|16:26:52.5702|| OAuth authenticated t Transfer: 1220 : 31|16:26:52.5702|| user TONY. t Transfer: 1220 : 31|16:26:52.5702||api user: TONY t Information: 1220 : 31|16:26:52.5702||V3Api.GetMediaAiTags t Transfer: 1220 : 18|16:26:52.7889||IsUserAuthenticated: /api/mediavideo/298539?info=smudge&_dc=1576168013006 t Transfer: 1220 : 18|16:26:52.7889||GetCurrentUser.. t Transfer: 1220 : 18|16:26:52.7889|| OAuth authenticated t Transfer: 1220 : 18|16:26:52.7889|| user TONY. t Transfer: 1220 : 18|16:26:52.7889||api user: TONY t Verbose: 1220 : 18|16:26:52.7889||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\England vs South Africa Match 1.mp4 subfolder t Verbose: 1220 : 18|16:26:52.7889|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/England vs South Africa Match 1.mp4 t Verbose: 1220 : 18|16:26:52.7889||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/England vs South Africa Match 1.mp4 t Transfer: 1220 : 18|16:26:52.7889||GetCurrentUser.. t Transfer: 1220 : 18|16:26:52.7889|| OAuth authenticated t Transfer: 1220 : 18|16:26:52.7889|| user TONY. t Transfer: 1220 : 25|16:26:53.1639||IsUserAuthenticated: /api/metadata/4000/298539?_dc=1576168013378 t Transfer: 1220 : 25|16:26:53.1639||GetCurrentUser.. t Transfer: 1220 : 25|16:26:53.1639|| OAuth authenticated t Transfer: 1220 : 25|16:26:53.1639|| user TONY. t Transfer: 1220 : 25|16:26:53.1639||api user: TONY t Transfer: 1220 : 48|16:27:57.6952||IsUserAuthenticated: /api/user-preferences?keys=media.basket.data&_dc=1576168046833 t Transfer: 1220 : 48|16:27:57.6952||GetCurrentUser.. t Transfer: 1220 : 48|16:27:57.6952|| OAuth authenticated t Transfer: 1220 : 48|16:27:57.6952|| user TONY. t Transfer: 1220 : 48|16:27:57.6952||api user: TONY t Information: 1220 : 48|16:27:57.6952||GetUserDataByKeys: media.basket.data t Transfer: 1220 : 48|16:27:57.6952||GetCurrentUser.. t Transfer: 1220 : 48|16:27:57.6952|| OAuth authenticated t Transfer: 1220 : 48|16:27:57.6952|| user TONY. t Transfer: 1220 : 31|16:27:57.7108||IsUserAuthenticated: /api/user-group-preferences?keys=logoImage&_dc=1576168046891 t Transfer: 1220 : 31|16:27:57.7108||GetCurrentUser.. t Transfer: 1220 : 31|16:27:57.7108|| OAuth authenticated t Transfer: 1220 : 31|16:27:57.7108|| user TONY. t Transfer: 1220 : 31|16:27:57.7108||api user: TONY t Information: 1220 : 31|16:27:57.7108||V3Api.GetUserSettings t Transfer: 1220 : 31|16:27:57.7108||GetCurrentUser.. t Transfer: 1220 : 31|16:27:57.7108|| OAuth authenticated t Transfer: 1220 : 31|16:27:57.7108|| user TONY. t Transfer: 1220 : 10|16:27:57.7265||IsUserAuthenticated: /api/user-preferences?keys=color_schema&_dc=1576168046841 t Transfer: 1220 : 10|16:27:57.7265||GetCurrentUser.. t Transfer: 1220 : 10|16:27:57.7265|| OAuth authenticated t Transfer: 1220 : 10|16:27:57.7265|| user TONY. t Transfer: 1220 : 10|16:27:57.7265||api user: TONY t Information: 1220 : 10|16:27:57.7265||GetUserDataByKeys: color_schema t Transfer: 1220 : 10|16:27:57.7265||GetCurrentUser.. t Transfer: 1220 : 10|16:27:57.7265|| OAuth authenticated t Transfer: 1220 : 10|16:27:57.7265|| user TONY. t Transfer: 1220 : 29|16:27:57.7421||IsUserAuthenticated: /api/user-preferences?keys=media.basket.data&_dc=1576168046875 t Transfer: 1220 : 29|16:27:57.7421||GetCurrentUser.. t Transfer: 1220 : 29|16:27:57.7421|| OAuth authenticated t Transfer: 1220 : 29|16:27:57.7421|| user TONY. t Transfer: 1220 : 29|16:27:57.7421||api user: TONY t Information: 1220 : 29|16:27:57.7421||GetUserDataByKeys: media.basket.data t Transfer: 1220 : 29|16:27:57.7421||GetCurrentUser.. t Transfer: 1220 : 29|16:27:57.7421|| OAuth authenticated t Transfer: 1220 : 29|16:27:57.7421|| user TONY. t Transfer: 1220 : 45|16:27:58.0546||IsUserAuthenticated: /api/user-preferences?keys=adv.recent.searches.titles&_dc=1576168047373 t Transfer: 1220 : 45|16:27:58.0546||GetCurrentUser.. t Transfer: 1220 : 45|16:27:58.0546|| OAuth authenticated t Transfer: 1220 : 45|16:27:58.0546|| user TONY. t Transfer: 1220 : 45|16:27:58.0546||api user: TONY t Information: 1220 : 45|16:27:58.0546||GetUserDataByKeys: adv.recent.searches.titles t Transfer: 1220 : 45|16:27:58.0546||GetCurrentUser.. t Transfer: 1220 : 45|16:27:58.0546|| OAuth authenticated t Transfer: 1220 : 45|16:27:58.0546|| user TONY. t Transfer: 1220 : 41|16:27:58.0546||IsUserAuthenticated: /api/view/searchinfo/TitleSearch?_dc=1576168047369 t Transfer: 1220 : 41|16:27:58.0546||GetCurrentUser.. t Transfer: 1220 : 41|16:27:58.0546|| OAuth authenticated t Transfer: 1220 : 41|16:27:58.0546|| user TONY. t Transfer: 1220 : 41|16:27:58.0546||api user: TONY t Information: 1220 : 41|16:27:58.0546||GetAdvSearchColumns. search type TitleSearch grid . t Transfer: 1220 : 10|16:27:58.0546||IsUserAuthenticated: /api/lookups/SearchSupportedOperators?_dc=1576168047370 t Transfer: 1220 : 10|16:27:58.0546||GetCurrentUser.. t Transfer: 1220 : 10|16:27:58.0546|| OAuth authenticated t Transfer: 1220 : 10|16:27:58.0546|| user TONY. t Transfer: 1220 : 10|16:27:58.0546||api user: TONY t Transfer: 1220 : 46|16:27:58.0702||IsUserAuthenticated: /api/view/info/TitleTree?lang=en-GB&_dc=1576168047395 t Transfer: 1220 : 46|16:27:58.0702||GetCurrentUser.. t Transfer: 1220 : 46|16:27:58.0702|| OAuth authenticated t Transfer: 1220 : 46|16:27:58.0702|| user TONY. t Transfer: 1220 : 46|16:27:58.0702||api user: TONY t Information: 1220 : 46|16:27:58.0702||GetGridViewBuilder. builder type TitleTree. t Transfer: 1220 : 46|16:27:58.0702||GetCurrentUser.. t Transfer: 1220 : 46|16:27:58.0702|| OAuth authenticated t Transfer: 1220 : 46|16:27:58.0702|| user TONY. t Information: 1220 : 46|16:27:58.0702||UserGridView. LoadView. ID 1281, Name Default. t Transfer: 1220 : 46|16:27:58.0702||GetCurrentUser.. t Transfer: 1220 : 46|16:27:58.0702|| OAuth authenticated t Transfer: 1220 : 46|16:27:58.0702|| user TONY. t Transfer: 1220 : 46|16:27:58.0859||GetCurrentUser.. t Transfer: 1220 : 46|16:27:58.0859|| OAuth authenticated t Transfer: 1220 : 46|16:27:58.0859|| user TONY. t Transfer: 1220 : 31|16:27:58.1171||IsUserAuthenticated: /api/view/searches/TitleSearch?_dc=1576168047420 t Transfer: 1220 : 31|16:27:58.1171||GetCurrentUser.. t Transfer: 1220 : 31|16:27:58.1171|| OAuth authenticated t Transfer: 1220 : 31|16:27:58.1171|| user TONY. t Transfer: 1220 : 31|16:27:58.1171||api user: TONY t Information: 1220 : 31|16:27:58.1171||GetSavedSearchNames. search type TitleSearch. t Transfer: 1220 : 31|16:27:58.1171||GetCurrentUser.. t Transfer: 1220 : 31|16:27:58.1171|| OAuth authenticated t Transfer: 1220 : 31|16:27:58.1171|| user TONY. t Transfer: 1220 : 10|16:27:58.1328||IsUserAuthenticated: /api/view/info/VersionGrid?lang=en-GB&_dc=1576168047433 t Transfer: 1220 : 10|16:27:58.1328||GetCurrentUser.. t Transfer: 1220 : 10|16:27:58.1328|| OAuth authenticated t Transfer: 1220 : 10|16:27:58.1328|| user TONY. t Transfer: 1220 : 10|16:27:58.1328||api user: TONY t Information: 1220 : 10|16:27:58.1328||GetGridViewBuilder. builder type VersionGrid. t Transfer: 1220 : 10|16:27:58.1328||GetCurrentUser.. t Transfer: 1220 : 10|16:27:58.1328|| OAuth authenticated t Transfer: 1220 : 10|16:27:58.1328|| user TONY. t Information: 1220 : 10|16:27:58.1328||UserGridView. LoadView. ID -1, Name Default. t Transfer: 1220 : 10|16:27:58.1328||GetCurrentUser.. t Transfer: 1220 : 10|16:27:58.1328|| OAuth authenticated t Transfer: 1220 : 10|16:27:58.1328|| user TONY. t Transfer: 1220 : 10|16:27:58.1328||GetCurrentUser.. t Transfer: 1220 : 10|16:27:58.1328|| OAuth authenticated t Transfer: 1220 : 10|16:27:58.1328|| user TONY. t Transfer: 1220 : 18|16:27:58.1952||IsUserAuthenticated: /api/view/info/MediaGrid?lang=en-GB&_dc=1576168047519 t Transfer: 1220 : 18|16:27:58.1952||GetCurrentUser.. t Transfer: 1220 : 18|16:27:58.1952|| OAuth authenticated t Transfer: 1220 : 18|16:27:58.1952|| user TONY. t Transfer: 1220 : 18|16:27:58.1952||api user: TONY t Information: 1220 : 18|16:27:58.1952||GetGridViewBuilder. builder type MediaGrid. t Transfer: 1220 : 18|16:27:58.1952||GetCurrentUser.. t Transfer: 1220 : 18|16:27:58.1952|| OAuth authenticated t Transfer: 1220 : 18|16:27:58.1952|| user TONY. t Information: 1220 : 18|16:27:58.1952||UserGridView. LoadView. ID 1282, Name Default. t Transfer: 1220 : 18|16:27:58.1952||GetCurrentUser.. t Transfer: 1220 : 18|16:27:58.1952|| OAuth authenticated t Transfer: 1220 : 18|16:27:58.1952|| user TONY. t Transfer: 1220 : 18|16:27:58.1952||GetCurrentUser.. t Transfer: 1220 : 18|16:27:58.1952|| OAuth authenticated t Transfer: 1220 : 18|16:27:58.1952|| user TONY. t Transfer: 1220 : 31|16:28:04.9452||IsUserAuthenticated: /api/view/searchinfo/Media?_dc=1576168054189 t Transfer: 1220 : 31|16:28:04.9452||GetCurrentUser.. t Transfer: 1220 : 31|16:28:04.9452|| OAuth authenticated t Transfer: 1220 : 31|16:28:04.9452|| user TONY. t Transfer: 1220 : 31|16:28:04.9452||api user: TONY t Information: 1220 : 31|16:28:04.9452||GetAdvSearchColumns. search type Media grid . t Transfer: 1220 : 41|16:28:04.9452||IsUserAuthenticated: /api/user-preferences?keys=adv.recent.searches.media&_dc=1576168054190 t Transfer: 1220 : 41|16:28:04.9452||GetCurrentUser.. t Transfer: 1220 : 41|16:28:04.9452|| OAuth authenticated t Transfer: 1220 : 41|16:28:04.9452|| user TONY. t Transfer: 1220 : 41|16:28:04.9452||api user: TONY t Information: 1220 : 41|16:28:04.9452||GetUserDataByKeys: adv.recent.searches.media t Transfer: 1220 : 41|16:28:04.9452||GetCurrentUser.. t Transfer: 1220 : 41|16:28:04.9452|| OAuth authenticated t Transfer: 1220 : 41|16:28:04.9452|| user TONY. t Transfer: 1220 : 32|16:28:04.9452||IsUserAuthenticated: /api/settings/user/searchLayoutConfig?_dc=1576168054193 t Transfer: 1220 : 32|16:28:04.9452||GetCurrentUser.. t Transfer: 1220 : 32|16:28:04.9452|| OAuth authenticated t Transfer: 1220 : 32|16:28:04.9452|| user TONY. t Transfer: 1220 : 32|16:28:04.9452||api user: TONY t Information: 1220 : 32|16:28:04.9452||V3Api.GetUserSettings t Transfer: 1220 : 32|16:28:04.9452||GetCurrentUser.. t Transfer: 1220 : 32|16:28:04.9452|| OAuth authenticated t Transfer: 1220 : 32|16:28:04.9452|| user TONY. t Transfer: 1220 : 32|16:28:04.9608||IsUserAuthenticated: /api/view/searches/Media?_dc=1576168054215 t Transfer: 1220 : 32|16:28:04.9608||GetCurrentUser.. t Transfer: 1220 : 32|16:28:04.9608|| OAuth authenticated t Transfer: 1220 : 32|16:28:04.9608|| user TONY. t Transfer: 1220 : 32|16:28:04.9608||api user: TONY t Information: 1220 : 32|16:28:04.9608||GetSavedSearchNames. search type Media. t Transfer: 1220 : 32|16:28:04.9608||GetCurrentUser.. t Transfer: 1220 : 32|16:28:04.9608|| OAuth authenticated t Transfer: 1220 : 32|16:28:04.9608|| user TONY. t Transfer: 1220 : 46|16:28:07.4608||IsUserAuthenticated: /api/SearchSuggestion/?_dc=1576168056499 t Transfer: 1220 : 46|16:28:07.4608||GetCurrentUser.. t Transfer: 1220 : 46|16:28:07.4608|| OAuth authenticated t Transfer: 1220 : 46|16:28:07.4608|| user TONY. t Transfer: 1220 : 46|16:28:07.4608||api user: TONY t Transfer: 1220 : 46|16:28:07.4608||GetCurrentUser.. t Transfer: 1220 : 46|16:28:07.4608|| OAuth authenticated t Transfer: 1220 : 46|16:28:07.4608|| user TONY. t Transfer: 1220 : 46|16:28:07.6952||IsUserAuthenticated: /api/user-group-preferences?keys=defaultSearchColumnsMedia&_dc=1576168056930 t Transfer: 1220 : 46|16:28:07.6952||GetCurrentUser.. t Transfer: 1220 : 46|16:28:07.6952|| OAuth authenticated t Transfer: 1220 : 46|16:28:07.6952|| user TONY. t Transfer: 1220 : 46|16:28:07.6952||api user: TONY t Information: 1220 : 46|16:28:07.6952||V3Api.GetUserSettings t Transfer: 1220 : 46|16:28:07.6952||GetCurrentUser.. t Transfer: 1220 : 46|16:28:07.6952|| OAuth authenticated t Transfer: 1220 : 46|16:28:07.6952|| user TONY. t Transfer: 1220 : 36|16:28:07.7109||IsUserAuthenticated: /api/search/Media?_dc=1576168056931 t Transfer: 1220 : 36|16:28:07.7109||GetCurrentUser.. t Transfer: 1220 : 36|16:28:07.7109|| OAuth authenticated t Transfer: 1220 : 36|16:28:07.7109|| user TONY. t Transfer: 1220 : 36|16:28:07.7109||api user: TONY t Information: 1220 : 36|16:28:07.7109||V3Api.SearchMedia t Information: 1220 : 36|16:28:07.7109||V3Api.SearchGeneric t Transfer: 1220 : 36|16:28:07.7109||GetCurrentUser.. t Transfer: 1220 : 36|16:28:07.7109|| OAuth authenticated t Transfer: 1220 : 36|16:28:07.7109|| user TONY. t Information: 1220 : 36|16:28:07.7265||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 : 36|16:28:07.7421|| timing: 00:00:00.0382423 t Verbose: 1220 : 36|16:28:07.7421||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\England v Bangladesh Match Group A.mp4 subfolder t Verbose: 1220 : 36|16:28:07.7421|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/England v Bangladesh Match Group A.mp4 t Verbose: 1220 : 36|16:28:07.7421||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/England v Bangladesh Match Group A.mp4 t Transfer: 1220 : 36|16:28:07.7421||GetCurrentUser.. t Transfer: 1220 : 36|16:28:07.7421|| OAuth authenticated t Transfer: 1220 : 36|16:28:07.7421|| user TONY. t Verbose: 1220 : 36|16:28:07.7421||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\ICC 360 Cricket for Change.mp4 subfolder t Verbose: 1220 : 36|16:28:07.7421|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/ICC 360 Cricket for Change.mp4 t Verbose: 1220 : 36|16:28:07.7421||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/ICC 360 Cricket for Change.mp4 t Transfer: 1220 : 36|16:28:07.7421||GetCurrentUser.. t Transfer: 1220 : 36|16:28:07.7421|| OAuth authenticated t Transfer: 1220 : 36|16:28:07.7421|| user TONY. t Verbose: 1220 : 36|16:28:07.7421||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Australia vs South Africa Match 45.mp4 subfolder t Verbose: 1220 : 36|16:28:07.7421|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Australia vs South Africa Match 45.mp4 t Verbose: 1220 : 36|16:28:07.7421||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/Australia vs South Africa Match 45.mp4 t Transfer: 1220 : 36|16:28:07.7421||GetCurrentUser.. t Transfer: 1220 : 36|16:28:07.7421|| OAuth authenticated t Transfer: 1220 : 36|16:28:07.7421|| user TONY. t Verbose: 1220 : 36|16:28:07.7421||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\England vs South Africa Match 1.mp4 subfolder t Verbose: 1220 : 36|16:28:07.7421|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/England vs South Africa Match 1.mp4 t Verbose: 1220 : 36|16:28:07.7421||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/England vs South Africa Match 1.mp4 t Transfer: 1220 : 36|16:28:07.7421||GetCurrentUser.. t Transfer: 1220 : 36|16:28:07.7421|| OAuth authenticated t Transfer: 1220 : 36|16:28:07.7421|| user TONY. t Verbose: 1220 : 36|16:28:07.7421||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\West Indies vs Pakistan Match 2.mp4 subfolder t Verbose: 1220 : 36|16:28:07.7421|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/West Indies vs Pakistan Match 2.mp4 t Verbose: 1220 : 36|16:28:07.7578||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/West Indies vs Pakistan Match 2.mp4 t Transfer: 1220 : 36|16:28:07.7578||GetCurrentUser.. t Transfer: 1220 : 36|16:28:07.7578|| OAuth authenticated t Transfer: 1220 : 36|16:28:07.7578|| user TONY. t Verbose: 1220 : 36|16:28:07.7578||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\New Zealand vs England Final.mp4 subfolder t Verbose: 1220 : 36|16:28:07.7578|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/New Zealand vs England Final.mp4 t Verbose: 1220 : 36|16:28:07.7578||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/New Zealand vs England Final.mp4 t Transfer: 1220 : 36|16:28:07.7578||GetCurrentUser.. t Transfer: 1220 : 36|16:28:07.7578|| OAuth authenticated t Transfer: 1220 : 36|16:28:07.7578|| user TONY. t Verbose: 1220 : 36|16:28:07.7578||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 : 36|16:28:07.7578|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Australia vs England Short Semi Final 2.mp4 t Verbose: 1220 : 36|16:28:07.7578||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/Australia vs England Short Semi Final 2.mp4 t Transfer: 1220 : 36|16:28:07.7578||GetCurrentUser.. t Transfer: 1220 : 36|16:28:07.7578|| OAuth authenticated t Transfer: 1220 : 36|16:28:07.7578|| user TONY. t Verbose: 1220 : 36|16:28:07.7578||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 : 36|16:28:07.7578|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/India vs New Zealand Semi Final 1.mp4 t Verbose: 1220 : 36|16:28:07.7578||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/India vs New Zealand Semi Final 1.mp4 t Transfer: 1220 : 36|16:28:07.7578||GetCurrentUser.. t Transfer: 1220 : 36|16:28:07.7578|| OAuth authenticated t Transfer: 1220 : 36|16:28:07.7578|| user TONY. t Verbose: 1220 : 36|16:28:07.7578||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 : 36|16:28:07.7578|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Scotland vs Oman 5th Place Play Off.mp4 t Verbose: 1220 : 36|16:28:07.7578||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/Scotland vs Oman 5th Place Play Off.mp4 t Transfer: 1220 : 36|16:28:07.7578||GetCurrentUser.. t Transfer: 1220 : 36|16:28:07.7578|| OAuth authenticated t Transfer: 1220 : 36|16:28:07.7578|| user TONY. t Verbose: 1220 : 36|16:28:07.7578||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\South Africa vs Bangladesh Match 5 .mp4 subfolder t Verbose: 1220 : 36|16:28:07.7578|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/South Africa vs Bangladesh Match 5 .mp4 t Verbose: 1220 : 36|16:28:07.7578||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/South Africa vs Bangladesh Match 5 .mp4 t Transfer: 1220 : 36|16:28:07.7578||GetCurrentUser.. t Transfer: 1220 : 36|16:28:07.7578|| OAuth authenticated t Transfer: 1220 : 36|16:28:07.7578|| user TONY. t Verbose: 1220 : 36|16:28:07.7578||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 : 36|16:28:07.7578|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/New Zealand vs Sri Lanka Match 3.mp4 t Verbose: 1220 : 36|16:28:07.7578||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/New Zealand vs Sri Lanka Match 3.mp4 t Transfer: 1220 : 36|16:28:07.7578||GetCurrentUser.. t Transfer: 1220 : 36|16:28:07.7578|| OAuth authenticated t Transfer: 1220 : 36|16:28:07.7578|| user TONY. t Verbose: 1220 : 36|16:28:07.7578||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Afghanistan vs Australia Match 4.mp4 subfolder t Verbose: 1220 : 36|16:28:07.7578|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Afghanistan vs Australia Match 4.mp4 t Verbose: 1220 : 36|16:28:07.7578||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/Afghanistan vs Australia Match 4.mp4 t Transfer: 1220 : 36|16:28:07.7578||GetCurrentUser.. t Transfer: 1220 : 36|16:28:07.7578|| OAuth authenticated t Transfer: 1220 : 36|16:28:07.7578|| user TONY. t Verbose: 1220 : 36|16:28:07.7733||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Bangladesh vs New Zealand Match 9.mp4 subfolder t Verbose: 1220 : 36|16:28:07.7733|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Bangladesh vs New Zealand Match 9.mp4 t Verbose: 1220 : 36|16:28:07.7733||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/Bangladesh vs New Zealand Match 9.mp4 t Transfer: 1220 : 36|16:28:07.7733||GetCurrentUser.. t Transfer: 1220 : 36|16:28:07.7733|| OAuth authenticated t Transfer: 1220 : 36|16:28:07.7733|| user TONY. t Verbose: 1220 : 36|16:28:07.7733||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Afghanistan vs Sri Lanka Match 7.mp4 subfolder t Verbose: 1220 : 36|16:28:07.7733|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Afghanistan vs Sri Lanka Match 7.mp4 t Verbose: 1220 : 36|16:28:07.7733||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/Afghanistan vs Sri Lanka Match 7.mp4 t Transfer: 1220 : 36|16:28:07.7733||GetCurrentUser.. t Transfer: 1220 : 36|16:28:07.7733|| OAuth authenticated t Transfer: 1220 : 36|16:28:07.7733|| user TONY. t Verbose: 1220 : 36|16:28:07.7733||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Australia vs West Indies Match 10.mp4 subfolder t Verbose: 1220 : 36|16:28:07.7733|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Australia vs West Indies Match 10.mp4 t Verbose: 1220 : 36|16:28:07.7733||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/Australia vs West Indies Match 10.mp4 t Transfer: 1220 : 36|16:28:07.7733||GetCurrentUser.. t Transfer: 1220 : 36|16:28:07.7733|| OAuth authenticated t Transfer: 1220 : 36|16:28:07.7733|| user TONY. t Verbose: 1220 : 36|16:28:07.7733||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\South Africa vs India Match 8.mp4 subfolder t Verbose: 1220 : 36|16:28:07.7733|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/South Africa vs India Match 8.mp4 t Verbose: 1220 : 36|16:28:07.7733||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/South Africa vs India Match 8.mp4 t Transfer: 1220 : 36|16:28:07.7733||GetCurrentUser.. t Transfer: 1220 : 36|16:28:07.7733|| OAuth authenticated t Transfer: 1220 : 36|16:28:07.7733|| user TONY. t Verbose: 1220 : 36|16:28:07.7733||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\England vs Pakistan Match 6.mp4 subfolder t Verbose: 1220 : 36|16:28:07.7733|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/England vs Pakistan Match 6.mp4 t Verbose: 1220 : 36|16:28:07.7733||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/England vs Pakistan Match 6.mp4 t Transfer: 1220 : 36|16:28:07.7733||GetCurrentUser.. t Transfer: 1220 : 36|16:28:07.7733|| OAuth authenticated t Transfer: 1220 : 36|16:28:07.7733|| user TONY. t Verbose: 1220 : 36|16:28:07.7733||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Pakistan vs Sri Lanka Match 11.mp4 subfolder t Verbose: 1220 : 36|16:28:07.7733|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Pakistan vs Sri Lanka Match 11.mp4 t Verbose: 1220 : 36|16:28:07.7733||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/Pakistan vs Sri Lanka Match 11.mp4 t Transfer: 1220 : 36|16:28:07.7733||GetCurrentUser.. t Transfer: 1220 : 36|16:28:07.7733|| OAuth authenticated t Transfer: 1220 : 36|16:28:07.7733|| user TONY. t Transfer: 1220 : 10|16:28:08.0233||IsUserAuthenticated: /api/user-preferences?_dc=1576168057228 t Transfer: 1220 : 10|16:28:08.0233||GetCurrentUser.. t Transfer: 1220 : 10|16:28:08.0233|| OAuth authenticated t Transfer: 1220 : 10|16:28:08.0233|| user TONY. t Transfer: 1220 : 10|16:28:08.0233||api user: TONY t Verbose: 1220 : 10|16:28:08.0233||StoreUserDataByKeys.. t Transfer: 1220 : 10|16:28:08.0233||GetCurrentUser.. t Transfer: 1220 : 10|16:28:08.0233|| OAuth authenticated t Transfer: 1220 : 10|16:28:08.0233|| user TONY. t Transfer: 1220 : 25|16:28:09.0389||IsUserAuthenticated: /api/user-preferences?keys=personal_settings&_dc=1576168058336 t Transfer: 1220 : 25|16:28:09.0389||GetCurrentUser.. t Transfer: 1220 : 25|16:28:09.0389|| OAuth authenticated t Transfer: 1220 : 25|16:28:09.0389|| user TONY. t Transfer: 1220 : 25|16:28:09.0389||api user: TONY t Information: 1220 : 25|16:28:09.0389||GetUserDataByKeys: personal_settings t Transfer: 1220 : 25|16:28:09.0389||GetCurrentUser.. t Transfer: 1220 : 25|16:28:09.0389|| OAuth authenticated t Transfer: 1220 : 25|16:28:09.0389|| user TONY. t Transfer: 1220 : 46|16:28:09.2889||IsUserAuthenticated: /api/user-group-preferences?globals=htmlplayerhotkeys,audioOnFrameForward&_dc=1576168058556 t Transfer: 1220 : 46|16:28:09.2889||GetCurrentUser.. t Transfer: 1220 : 46|16:28:09.2889|| OAuth authenticated t Transfer: 1220 : 46|16:28:09.2889|| user TONY. t Transfer: 1220 : 46|16:28:09.2889||api user: TONY t Information: 1220 : 46|16:28:09.2889||V3Api.GetUserSettings t Transfer: 1220 : 46|16:28:09.2889||GetCurrentUser.. t Transfer: 1220 : 46|16:28:09.2889|| OAuth authenticated t Transfer: 1220 : 46|16:28:09.2889|| user TONY. t Transfer: 1220 : 25|16:28:09.4452||IsUserAuthenticated: /api/user-group-preferences?globals=htmlplayerhotkeys,audioOnFrameForward&_dc=1576168058732 t Transfer: 1220 : 25|16:28:09.4452||GetCurrentUser.. t Transfer: 1220 : 25|16:28:09.4452|| OAuth authenticated t Transfer: 1220 : 25|16:28:09.4452|| user TONY. t Transfer: 1220 : 25|16:28:09.4452||api user: TONY t Information: 1220 : 25|16:28:09.4452||V3Api.GetUserSettings t Transfer: 1220 : 25|16:28:09.4452||GetCurrentUser.. t Transfer: 1220 : 25|16:28:09.4452|| OAuth authenticated t Transfer: 1220 : 25|16:28:09.4452|| user TONY. t Transfer: 1220 : 25|16:28:16.1640||IsUserAuthenticated: /api/media-details/298539?_dc=1576168065488 t Transfer: 1220 : 25|16:28:16.1640||GetCurrentUser.. t Transfer: 1220 : 25|16:28:16.1640|| OAuth authenticated t Transfer: 1220 : 25|16:28:16.1640|| user TONY. t Transfer: 1220 : 25|16:28:16.1640||api user: TONY t Transfer: 1220 : 25|16:28:16.1640||GetCurrentUser.. t Transfer: 1220 : 25|16:28:16.1640|| OAuth authenticated t Transfer: 1220 : 25|16:28:16.1640|| user TONY. t Information: 1220 : 25|16:28:16.1952||TM_MIS. LoadSubtitles for ID: 298539. t Information: 1220 : 25|16:28:16.1952||TM_MIS. LoadSubtitles for ID: 298539. 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=298380' t Information: 1220 : 25|16:28:16.1952||TM_MIS. LoadSubtitles for ID: 298539 found no subtitles. t Verbose: 1220 : 25|16:28:16.2265||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\England vs South Africa Match 1.mp4 subfolder t Verbose: 1220 : 25|16:28:16.2265|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/England vs South Africa Match 1.mp4 t Verbose: 1220 : 25|16:28:16.2265||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/England vs South Africa Match 1.mp4 t Transfer: 1220 : 25|16:28:16.2265||GetCurrentUser.. t Transfer: 1220 : 25|16:28:16.2265|| OAuth authenticated t Transfer: 1220 : 25|16:28:16.2265|| user TONY. t Transfer: 1220 : 10|16:28:16.2734||IsUserAuthenticated: /api/v3/detailsview/MediaDetails/5?lang=en-GB&_dc=1576168065599 t Transfer: 1220 : 10|16:28:16.2734||GetCurrentUser.. t Transfer: 1220 : 10|16:28:16.2734|| OAuth authenticated t Transfer: 1220 : 10|16:28:16.2734|| user TONY. t Transfer: 1220 : 10|16:28:16.2734||api user: TONY t Transfer: 1220 : 32|16:28:16.3827||IsUserAuthenticated: /api/lookups/FriendlyNames?_dc=1576168065677 t Transfer: 1220 : 32|16:28:16.3827||GetCurrentUser.. t Transfer: 1220 : 32|16:28:16.3827|| OAuth authenticated t Transfer: 1220 : 32|16:28:16.3827|| user TONY. t Transfer: 1220 : 32|16:28:16.3827||api user: TONY t Transfer: 1220 : 46|16:28:16.3827||IsUserAuthenticated: /api/lookups/PgmStatus?_dc=1576168065678 t Transfer: 1220 : 46|16:28:16.3827||GetCurrentUser.. t Transfer: 1220 : 46|16:28:16.3827|| OAuth authenticated t Transfer: 1220 : 46|16:28:16.3827|| user TONY. t Transfer: 1220 : 46|16:28:16.3827||api user: TONY t Transfer: 1220 : 32|16:28:16.3827||IsUserAuthenticated: /api/user-group-preferences?globals=htmlplayerhotkeys,audioOnFrameForward&_dc=1576168065706 t Transfer: 1220 : 32|16:28:16.3827||GetCurrentUser.. t Transfer: 1220 : 32|16:28:16.3827|| OAuth authenticated t Transfer: 1220 : 32|16:28:16.3827|| user TONY. t Transfer: 1220 : 32|16:28:16.3827||api user: TONY t Information: 1220 : 32|16:28:16.3827||V3Api.GetUserSettings t Transfer: 1220 : 32|16:28:16.3827||GetCurrentUser.. t Transfer: 1220 : 32|16:28:16.3827|| OAuth authenticated t Transfer: 1220 : 32|16:28:16.3827|| user TONY. t Transfer: 1220 : 25|16:28:16.3983||IsUserAuthenticated: /api/lookups/MediaStatus?_dc=1576168065679 t Transfer: 1220 : 25|16:28:16.3983||GetCurrentUser.. t Transfer: 1220 : 25|16:28:16.3983|| OAuth authenticated t Transfer: 1220 : 25|16:28:16.3983|| user TONY. t Transfer: 1220 : 25|16:28:16.3983||api user: TONY t Transfer: 1220 : 10|16:28:16.3983||IsUserAuthenticated: /api/media-captions/298539?_dc=1576168065651 t Transfer: 1220 : 10|16:28:16.3983||GetCurrentUser.. t Transfer: 1220 : 10|16:28:16.3983|| OAuth authenticated t Transfer: 1220 : 10|16:28:16.3983|| user TONY. t Transfer: 1220 : 10|16:28:16.3983||api user: TONY t Transfer: 1220 : 46|16:28:16.4608||IsUserAuthenticated: /api/lookups/MediaEventTypes?_dc=1576168065783 t Transfer: 1220 : 46|16:28:16.4608||GetCurrentUser.. t Transfer: 1220 : 46|16:28:16.4608|| OAuth authenticated t Transfer: 1220 : 46|16:28:16.4608|| user TONY. t Transfer: 1220 : 46|16:28:16.4608||api user: TONY t Transfer: 1220 : 29|16:28:16.6327||IsUserAuthenticated: /api/v3/media/related/298539/audio?_dc=1576168065957 t Transfer: 1220 : 29|16:28:16.6327||GetCurrentUser.. t Transfer: 1220 : 29|16:28:16.6327|| OAuth authenticated t Transfer: 1220 : 29|16:28:16.6327|| user TONY. t Transfer: 1220 : 29|16:28:16.6327||api user: TONY t Transfer: 1220 : 46|16:28:16.6796||IsUserAuthenticated: /api/mediavideo/298539?info=smudge,scene,audiovolume&_dc=1576168065985 t Transfer: 1220 : 46|16:28:16.6796||GetCurrentUser.. t Transfer: 1220 : 46|16:28:16.6796|| OAuth authenticated t Transfer: 1220 : 46|16:28:16.6796|| user TONY. t Transfer: 1220 : 46|16:28:16.6796||api user: TONY t Verbose: 1220 : 46|16:28:16.6796||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\England vs South Africa Match 1.mp4 subfolder t Verbose: 1220 : 46|16:28:16.6796|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/England vs South Africa Match 1.mp4 t Verbose: 1220 : 46|16:28:16.6796||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/England vs South Africa Match 1.mp4 t Transfer: 1220 : 46|16:28:16.6796||GetCurrentUser.. t Transfer: 1220 : 46|16:28:16.6796|| OAuth authenticated t Transfer: 1220 : 46|16:28:16.6796|| user TONY. t Transfer: 1220 : 29|16:28:16.7733||IsUserAuthenticated: /api/v3/ai-tags/298539?_dc=1576168066019 t Transfer: 1220 : 29|16:28:16.7733||GetCurrentUser.. t Transfer: 1220 : 29|16:28:16.7733|| OAuth authenticated t Transfer: 1220 : 29|16:28:16.7733|| user TONY. t Transfer: 1220 : 29|16:28:16.7733||api user: TONY t Information: 1220 : 29|16:28:16.7733||V3Api.GetMediaAiTags t Transfer: 1220 : 32|16:28:16.9608||IsUserAuthenticated: /api/mediavideo/298539?info=smudge&_dc=1576168066286 t Transfer: 1220 : 32|16:28:16.9608||GetCurrentUser.. t Transfer: 1220 : 32|16:28:16.9608|| OAuth authenticated t Transfer: 1220 : 32|16:28:16.9608|| user TONY. t Transfer: 1220 : 32|16:28:16.9608||api user: TONY t Verbose: 1220 : 32|16:28:16.9608||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\England vs South Africa Match 1.mp4 subfolder t Verbose: 1220 : 32|16:28:16.9608|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/England vs South Africa Match 1.mp4 t Verbose: 1220 : 32|16:28:16.9608||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/England vs South Africa Match 1.mp4 t Transfer: 1220 : 32|16:28:16.9608||GetCurrentUser.. t Transfer: 1220 : 32|16:28:16.9608|| OAuth authenticated t Transfer: 1220 : 32|16:28:16.9608|| user TONY. t Transfer: 1220 : 48|16:29:58.2891||IsUserAuthenticated: /api/xmldocument/113667?_dc=1576168198504 t Transfer: 1220 : 48|16:29:58.2891||GetCurrentUser.. t Transfer: 1220 : 48|16:29:58.2891|| OAuth authenticated t Transfer: 1220 : 48|16:29:58.2891|| user TONY. t Transfer: 1220 : 48|16:29:58.2891||api user: TONY t Information: 1220 : 25|16:30:41.3672||GetAppInfo t Information: 1220 : 25|16:30:41.3828|| db: TMDDEMO install mode: auth types: Native, PublicApiKey t Information: 1220 : 48|16:32:17.1797||GetAppInfo t Information: 1220 : 48|16:32:17.1797|| db: TMDDEMO install mode: auth types: Native, PublicApiKey t Transfer: 1220 : 65|16:49:41.1485||IsUserAuthenticated: /api/search/title?_dc=1576169349530 t Transfer: 1220 : 65|16:49:41.1485||GetCurrentUser.. t Transfer: 1220 : 65|16:49:41.1485|| OAuth authenticated t Verbose: 1220 : 65|16:49:41.1485|| uid claim is missing.. t Verbose: 1220 : 65|16:49:41.1485||AutoLogin not possible identity type WindowsIdentity t Transfer: 1220 : 104|16:49:41.1485||IsUserAuthenticated: /api/SearchSuggestion/?_dc=1576169349353 t Transfer: 1220 : 104|16:49:41.1485||GetCurrentUser.. t Transfer: 1220 : 104|16:49:41.1485|| OAuth authenticated t Verbose: 1220 : 104|16:49:41.1485|| uid claim is missing.. t Verbose: 1220 : 104|16:49:41.1485||AutoLogin not possible identity type WindowsIdentity t Information: 1220 : 101|16:49:41.3047||GetAppInfo t Information: 1220 : 101|16:49:41.3829|| db: TMDDEMO install mode: auth types: Native, PublicApiKey t Information: 1220 : 107|16:49:43.3829||Oauth validating.. t Verbose: 1220 : 107|16:49:43.3829||GrantResourceOwnerCredentials. t Verbose: 1220 : 107|16:49:43.3829||LoginUser. tony, login type OAuth, encrypt password True t Information: 1220 : 107|16:49:43.3829||TryLoginUser. tony, login type OAuth, check password True, check hash False, encrypt password True, load user data True t Information: 1220 : 107|16:49:43.3985||InitialiseLogin t Information: 1220 : 107|16:49:43.4141|| oauth token 00000000-0000-0000-0000-000000000000 t Information: 1220 : 107|16:49:43.4141||TryLoginUser. Logged in.. t Verbose: 1220 : 107|16:49:43.4141||LoginUser. Adding history. User Id 522, result TONY, host t Verbose: 1220 : 107|16:49:43.4297||GrantResourceOwnerCredentials. Try login finished. Logged: True t Transfer: 1220 : 98|16:49:43.5079||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=1576169352821 t Transfer: 1220 : 98|16:49:43.5079||GetCurrentUser.. t Transfer: 1220 : 98|16:49:43.5079|| OAuth authenticated t Transfer: 1220 : 98|16:49:43.5079|| user TONY. t Transfer: 1220 : 98|16:49:43.5079||api user: TONY t Information: 1220 : 98|16:49:43.5079||V3Api.GetUserSettings t Transfer: 1220 : 98|16:49:43.5079||GetCurrentUser.. t Transfer: 1220 : 98|16:49:43.5079|| OAuth authenticated t Transfer: 1220 : 98|16:49:43.5079|| user TONY. t Transfer: 1220 : 65|16:49:43.6016||IsUserAuthenticated: /api/user-preferences?keys=personal_settings;basket;default_page;color_schema;media.basket.data;defaultSearch&_dc=1576169352920 t Transfer: 1220 : 65|16:49:43.6016||GetCurrentUser.. t Transfer: 1220 : 65|16:49:43.6016|| OAuth authenticated t Transfer: 1220 : 65|16:49:43.6016|| user TONY. t Transfer: 1220 : 65|16:49:43.6016||api user: TONY t Information: 1220 : 65|16:49:43.6016||GetUserDataByKeys: personal_settings;basket;default_page;color_schema;media.basket.data;defaultSearch t Transfer: 1220 : 65|16:49:43.6016||GetCurrentUser.. t Transfer: 1220 : 65|16:49:43.6016|| OAuth authenticated t Transfer: 1220 : 65|16:49:43.6016|| user TONY. t Transfer: 1220 : 80|16:49:43.6485||IsUserAuthenticated: /api/lookups/MediaStatus?_dc=1576169352921 t Transfer: 1220 : 80|16:49:43.6485||GetCurrentUser.. t Transfer: 1220 : 80|16:49:43.6485|| OAuth authenticated t Transfer: 1220 : 80|16:49:43.6485|| user TONY. t Transfer: 1220 : 80|16:49:43.6485||api user: TONY t Transfer: 1220 : 102|16:49:43.6641||IsUserAuthenticated: /api/lookups/PgmStatus?_dc=1576169352923 t Transfer: 1220 : 102|16:49:43.6641||GetCurrentUser.. t Transfer: 1220 : 102|16:49:43.6641|| OAuth authenticated t Transfer: 1220 : 102|16:49:43.6641|| user TONY. t Transfer: 1220 : 102|16:49:43.6641||api user: TONY t Information: 1220 : 102|16:49:43.6954||GetUserProfile. Id: 0 t Transfer: 1220 : 102|16:49:43.6954||GetCurrentUser.. t Transfer: 1220 : 102|16:49:43.6954|| OAuth authenticated t Transfer: 1220 : 102|16:49:43.6954|| user TONY. t Transfer: 1220 : 100|16:49:43.8672||IsUserAuthenticated: /api/user-preferences?keys=adv.recent.searches.titles&_dc=1576169353186 t Transfer: 1220 : 100|16:49:43.8672||GetCurrentUser.. t Transfer: 1220 : 100|16:49:43.8672|| OAuth authenticated t Transfer: 1220 : 100|16:49:43.8672|| user TONY. t Transfer: 1220 : 100|16:49:43.8672||api user: TONY t Information: 1220 : 100|16:49:43.8672||GetUserDataByKeys: adv.recent.searches.titles t Transfer: 1220 : 100|16:49:43.8672||GetCurrentUser.. t Transfer: 1220 : 100|16:49:43.8672|| OAuth authenticated t Transfer: 1220 : 100|16:49:43.8672|| user TONY. t Transfer: 1220 : 101|16:49:43.8672||IsUserAuthenticated: /api/view/searchinfo/TitleSearch?_dc=1576169353182 t Transfer: 1220 : 101|16:49:43.8672||GetCurrentUser.. t Transfer: 1220 : 101|16:49:43.8672|| OAuth authenticated t Transfer: 1220 : 101|16:49:43.8672|| user TONY. t Transfer: 1220 : 101|16:49:43.8672||api user: TONY t Information: 1220 : 101|16:49:43.8672||GetAdvSearchColumns. search type TitleSearch grid . t Transfer: 1220 : 102|16:49:43.8828||IsUserAuthenticated: /api/view/info/TitleTree?lang=en-GB&_dc=1576169353202 t Transfer: 1220 : 102|16:49:43.8828||GetCurrentUser.. t Transfer: 1220 : 102|16:49:43.8828|| OAuth authenticated t Transfer: 1220 : 102|16:49:43.8828|| user TONY. t Transfer: 1220 : 102|16:49:43.8828||api user: TONY t Information: 1220 : 102|16:49:43.8828||GetGridViewBuilder. builder type TitleTree. t Transfer: 1220 : 102|16:49:43.8828||GetCurrentUser.. t Transfer: 1220 : 102|16:49:43.8828|| OAuth authenticated t Transfer: 1220 : 102|16:49:43.8828|| user TONY. t Information: 1220 : 102|16:49:43.8828||UserGridView. LoadView. ID 1281, Name Default. t Transfer: 1220 : 102|16:49:43.8828||GetCurrentUser.. t Transfer: 1220 : 102|16:49:43.8828|| OAuth authenticated t Transfer: 1220 : 102|16:49:43.8828|| user TONY. t Transfer: 1220 : 102|16:49:43.8985||GetCurrentUser.. t Transfer: 1220 : 102|16:49:43.8985|| OAuth authenticated t Transfer: 1220 : 102|16:49:43.8985|| user TONY. t Transfer: 1220 : 103|16:49:43.8985||IsUserAuthenticated: /api/view/searches/TitleSearch?_dc=1576169353213 t Transfer: 1220 : 103|16:49:43.8985||GetCurrentUser.. t Transfer: 1220 : 103|16:49:43.8985|| OAuth authenticated t Transfer: 1220 : 103|16:49:43.8985|| user TONY. t Transfer: 1220 : 103|16:49:43.8985||api user: TONY t Information: 1220 : 103|16:49:43.8985||GetSavedSearchNames. search type TitleSearch. t Transfer: 1220 : 103|16:49:43.8985||GetCurrentUser.. t Transfer: 1220 : 103|16:49:43.8985|| OAuth authenticated t Transfer: 1220 : 103|16:49:43.8985|| user TONY. t Transfer: 1220 : 100|16:49:43.8985||IsUserAuthenticated: /api/lookups/SearchSupportedOperators?_dc=1576169353183 t Transfer: 1220 : 100|16:49:43.8985||GetCurrentUser.. t Transfer: 1220 : 100|16:49:43.8985|| OAuth authenticated t Transfer: 1220 : 100|16:49:43.8985|| user TONY. t Transfer: 1220 : 100|16:49:43.8985||api user: TONY t Transfer: 1220 : 101|16:49:43.9141||IsUserAuthenticated: /api/view/info/VersionGrid?lang=en-GB&_dc=1576169353225 t Transfer: 1220 : 101|16:49:43.9141||GetCurrentUser.. t Transfer: 1220 : 101|16:49:43.9141|| OAuth authenticated t Transfer: 1220 : 101|16:49:43.9141|| user TONY. t Transfer: 1220 : 101|16:49:43.9141||api user: TONY t Information: 1220 : 101|16:49:43.9141||GetGridViewBuilder. builder type VersionGrid. t Transfer: 1220 : 101|16:49:43.9141||GetCurrentUser.. t Transfer: 1220 : 101|16:49:43.9141|| OAuth authenticated t Transfer: 1220 : 101|16:49:43.9141|| user TONY. t Information: 1220 : 101|16:49:43.9141||UserGridView. LoadView. ID -1, Name Default. t Transfer: 1220 : 101|16:49:43.9141||GetCurrentUser.. t Transfer: 1220 : 101|16:49:43.9141|| OAuth authenticated t Transfer: 1220 : 101|16:49:43.9141|| user TONY. t Transfer: 1220 : 101|16:49:43.9141||GetCurrentUser.. t Transfer: 1220 : 101|16:49:43.9141|| OAuth authenticated t Transfer: 1220 : 101|16:49:43.9141|| user TONY. t Transfer: 1220 : 100|16:49:43.9610||IsUserAuthenticated: /api/view/info/MediaGrid?lang=en-GB&_dc=1576169353270 t Transfer: 1220 : 100|16:49:43.9610||GetCurrentUser.. t Transfer: 1220 : 100|16:49:43.9610|| OAuth authenticated t Transfer: 1220 : 100|16:49:43.9610|| user TONY. t Transfer: 1220 : 100|16:49:43.9610||api user: TONY t Information: 1220 : 100|16:49:43.9610||GetGridViewBuilder. builder type MediaGrid. t Transfer: 1220 : 100|16:49:43.9610||GetCurrentUser.. t Transfer: 1220 : 100|16:49:43.9610|| OAuth authenticated t Transfer: 1220 : 100|16:49:43.9610|| user TONY. t Information: 1220 : 100|16:49:43.9610||UserGridView. LoadView. ID 1282, Name Default. t Transfer: 1220 : 100|16:49:43.9610||GetCurrentUser.. t Transfer: 1220 : 100|16:49:43.9610|| OAuth authenticated t Transfer: 1220 : 100|16:49:43.9610|| user TONY. t Transfer: 1220 : 100|16:49:43.9766||GetCurrentUser.. t Transfer: 1220 : 100|16:49:43.9766|| OAuth authenticated t Transfer: 1220 : 100|16:49:43.9766|| user TONY. t Transfer: 1220 : 100|16:49:47.0703||IsUserAuthenticated: /api/settings/user/searchLayoutConfig?_dc=1576169356392 t Transfer: 1220 : 100|16:49:47.0703||GetCurrentUser.. t Transfer: 1220 : 100|16:49:47.0703|| OAuth authenticated t Transfer: 1220 : 100|16:49:47.0703|| user TONY. t Transfer: 1220 : 100|16:49:47.0703||api user: TONY t Information: 1220 : 100|16:49:47.0703||V3Api.GetUserSettings t Transfer: 1220 : 100|16:49:47.0703||GetCurrentUser.. t Transfer: 1220 : 100|16:49:47.0703|| OAuth authenticated t Transfer: 1220 : 100|16:49:47.0703|| user TONY. t Transfer: 1220 : 103|16:49:47.0703||IsUserAuthenticated: /api/view/searchinfo/Media?_dc=1576169356386 t Transfer: 1220 : 103|16:49:47.0703||GetCurrentUser.. t Transfer: 1220 : 103|16:49:47.0703|| OAuth authenticated t Transfer: 1220 : 103|16:49:47.0703|| user TONY. t Transfer: 1220 : 103|16:49:47.0703||api user: TONY t Information: 1220 : 103|16:49:47.0703||GetAdvSearchColumns. search type Media grid . t Transfer: 1220 : 101|16:49:47.0860||IsUserAuthenticated: /api/view/searches/Media?_dc=1576169356412 t Transfer: 1220 : 101|16:49:47.0860||GetCurrentUser.. t Transfer: 1220 : 101|16:49:47.0860|| OAuth authenticated t Transfer: 1220 : 101|16:49:47.0860|| user TONY. t Transfer: 1220 : 101|16:49:47.0860||api user: TONY t Information: 1220 : 101|16:49:47.0860||GetSavedSearchNames. search type Media. t Transfer: 1220 : 101|16:49:47.0860||GetCurrentUser.. t Transfer: 1220 : 101|16:49:47.0860|| OAuth authenticated t Transfer: 1220 : 101|16:49:47.0860|| user TONY. t Transfer: 1220 : 100|16:49:47.1172||IsUserAuthenticated: /api/user-preferences?keys=adv.recent.searches.media&_dc=1576169356388 t Transfer: 1220 : 100|16:49:47.1172||GetCurrentUser.. t Transfer: 1220 : 100|16:49:47.1172|| OAuth authenticated t Transfer: 1220 : 100|16:49:47.1172|| user TONY. t Transfer: 1220 : 100|16:49:47.1172||api user: TONY t Information: 1220 : 100|16:49:47.1172||GetUserDataByKeys: adv.recent.searches.media t Transfer: 1220 : 100|16:49:47.1172||GetCurrentUser.. t Transfer: 1220 : 100|16:49:47.1172|| OAuth authenticated t Transfer: 1220 : 100|16:49:47.1172|| user TONY. t Transfer: 1220 : 100|16:49:49.3985||IsUserAuthenticated: /api/SearchSuggestion/?_dc=1576169358710 t Transfer: 1220 : 100|16:49:49.3985||GetCurrentUser.. t Transfer: 1220 : 100|16:49:49.3985|| OAuth authenticated t Transfer: 1220 : 100|16:49:49.3985|| user TONY. t Transfer: 1220 : 100|16:49:49.3985||api user: TONY t Transfer: 1220 : 100|16:49:49.3985||GetCurrentUser.. t Transfer: 1220 : 100|16:49:49.3985|| OAuth authenticated t Transfer: 1220 : 100|16:49:49.3985|| user TONY. t Transfer: 1220 : 107|16:49:49.5547||IsUserAuthenticated: /api/search/Media?_dc=1576169358878 t Transfer: 1220 : 107|16:49:49.5547||GetCurrentUser.. t Transfer: 1220 : 107|16:49:49.5547|| OAuth authenticated t Transfer: 1220 : 107|16:49:49.5547|| user TONY. t Transfer: 1220 : 107|16:49:49.5547||api user: TONY t Information: 1220 : 107|16:49:49.5547||V3Api.SearchMedia t Information: 1220 : 107|16:49:49.5547||V3Api.SearchGeneric t Transfer: 1220 : 107|16:49:49.5547||GetCurrentUser.. t Transfer: 1220 : 107|16:49:49.5547|| OAuth authenticated t Transfer: 1220 : 107|16:49:49.5547|| user TONY. t Information: 1220 : 107|16:49:49.5860||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 : 107|16:49:49.6172|| timing: 00:00:00.0499854 t Verbose: 1220 : 107|16:49:49.6172||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\England v Bangladesh Match Group A.mp4 subfolder t Verbose: 1220 : 107|16:49:49.6172|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/England v Bangladesh Match Group A.mp4 t Verbose: 1220 : 107|16:49:49.6172||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/England v Bangladesh Match Group A.mp4 t Transfer: 1220 : 107|16:49:49.6172||GetCurrentUser.. t Transfer: 1220 : 107|16:49:49.6172|| OAuth authenticated t Transfer: 1220 : 107|16:49:49.6172|| user TONY. t Verbose: 1220 : 107|16:49:49.6172||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\ICC 360 Cricket for Change.mp4 subfolder t Verbose: 1220 : 107|16:49:49.6172|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/ICC 360 Cricket for Change.mp4 t Verbose: 1220 : 107|16:49:49.6172||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/ICC 360 Cricket for Change.mp4 t Transfer: 1220 : 107|16:49:49.6172||GetCurrentUser.. t Transfer: 1220 : 107|16:49:49.6172|| OAuth authenticated t Transfer: 1220 : 107|16:49:49.6172|| user TONY. t Verbose: 1220 : 107|16:49:49.6172||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Australia vs South Africa Match 45.mp4 subfolder t Verbose: 1220 : 107|16:49:49.6172|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Australia vs South Africa Match 45.mp4 t Verbose: 1220 : 107|16:49:49.6172||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/Australia vs South Africa Match 45.mp4 t Transfer: 1220 : 107|16:49:49.6172||GetCurrentUser.. t Transfer: 1220 : 107|16:49:49.6172|| OAuth authenticated t Transfer: 1220 : 107|16:49:49.6172|| user TONY. t Verbose: 1220 : 107|16:49:49.6172||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\England vs South Africa Match 1.mp4 subfolder t Verbose: 1220 : 107|16:49:49.6172|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/England vs South Africa Match 1.mp4 t Verbose: 1220 : 107|16:49:49.6172||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/England vs South Africa Match 1.mp4 t Transfer: 1220 : 107|16:49:49.6172||GetCurrentUser.. t Transfer: 1220 : 107|16:49:49.6172|| OAuth authenticated t Transfer: 1220 : 107|16:49:49.6172|| user TONY. t Verbose: 1220 : 107|16:49:49.6172||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\West Indies vs Pakistan Match 2.mp4 subfolder t Verbose: 1220 : 107|16:49:49.6172|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/West Indies vs Pakistan Match 2.mp4 t Verbose: 1220 : 107|16:49:49.6172||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/West Indies vs Pakistan Match 2.mp4 t Transfer: 1220 : 107|16:49:49.6172||GetCurrentUser.. t Transfer: 1220 : 107|16:49:49.6172|| OAuth authenticated t Transfer: 1220 : 107|16:49:49.6172|| user TONY. t Verbose: 1220 : 107|16:49:49.6172||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\New Zealand vs England Final.mp4 subfolder t Verbose: 1220 : 107|16:49:49.6172|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/New Zealand vs England Final.mp4 t Verbose: 1220 : 107|16:49:49.6172||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/New Zealand vs England Final.mp4 t Transfer: 1220 : 107|16:49:49.6172||GetCurrentUser.. t Transfer: 1220 : 107|16:49:49.6172|| OAuth authenticated t Transfer: 1220 : 107|16:49:49.6172|| user TONY. t Verbose: 1220 : 107|16:49:49.6172||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 : 107|16:49:49.6172|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Australia vs England Short Semi Final 2.mp4 t Verbose: 1220 : 107|16:49:49.6172||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/Australia vs England Short Semi Final 2.mp4 t Transfer: 1220 : 107|16:49:49.6172||GetCurrentUser.. t Transfer: 1220 : 107|16:49:49.6172|| OAuth authenticated t Transfer: 1220 : 107|16:49:49.6172|| user TONY. t Verbose: 1220 : 107|16:49:49.6172||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 : 107|16:49:49.6172|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/India vs New Zealand Semi Final 1.mp4 t Verbose: 1220 : 107|16:49:49.6172||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/India vs New Zealand Semi Final 1.mp4 t Transfer: 1220 : 107|16:49:49.6172||GetCurrentUser.. t Transfer: 1220 : 107|16:49:49.6172|| OAuth authenticated t Transfer: 1220 : 107|16:49:49.6172|| user TONY. t Verbose: 1220 : 107|16:49:49.6328||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 : 107|16:49:49.6328|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Scotland vs Oman 5th Place Play Off.mp4 t Verbose: 1220 : 107|16:49:49.6328||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/Scotland vs Oman 5th Place Play Off.mp4 t Transfer: 1220 : 107|16:49:49.6328||GetCurrentUser.. t Transfer: 1220 : 107|16:49:49.6328|| OAuth authenticated t Transfer: 1220 : 107|16:49:49.6328|| user TONY. t Verbose: 1220 : 107|16:49:49.6328||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\South Africa vs Bangladesh Match 5 .mp4 subfolder t Verbose: 1220 : 107|16:49:49.6328|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/South Africa vs Bangladesh Match 5 .mp4 t Verbose: 1220 : 107|16:49:49.6328||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/South Africa vs Bangladesh Match 5 .mp4 t Transfer: 1220 : 107|16:49:49.6328||GetCurrentUser.. t Transfer: 1220 : 107|16:49:49.6328|| OAuth authenticated t Transfer: 1220 : 107|16:49:49.6328|| user TONY. t Verbose: 1220 : 107|16:49:49.6328||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 : 107|16:49:49.6328|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/New Zealand vs Sri Lanka Match 3.mp4 t Verbose: 1220 : 107|16:49:49.6328||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/New Zealand vs Sri Lanka Match 3.mp4 t Transfer: 1220 : 107|16:49:49.6328||GetCurrentUser.. t Transfer: 1220 : 107|16:49:49.6328|| OAuth authenticated t Transfer: 1220 : 107|16:49:49.6328|| user TONY. t Verbose: 1220 : 107|16:49:49.6328||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Afghanistan vs Australia Match 4.mp4 subfolder t Verbose: 1220 : 107|16:49:49.6328|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Afghanistan vs Australia Match 4.mp4 t Verbose: 1220 : 107|16:49:49.6328||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/Afghanistan vs Australia Match 4.mp4 t Transfer: 1220 : 107|16:49:49.6328||GetCurrentUser.. t Transfer: 1220 : 107|16:49:49.6328|| OAuth authenticated t Transfer: 1220 : 107|16:49:49.6328|| user TONY. t Verbose: 1220 : 107|16:49:49.6328||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Bangladesh vs New Zealand Match 9.mp4 subfolder t Verbose: 1220 : 107|16:49:49.6328|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Bangladesh vs New Zealand Match 9.mp4 t Verbose: 1220 : 107|16:49:49.6328||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/Bangladesh vs New Zealand Match 9.mp4 t Transfer: 1220 : 107|16:49:49.6328||GetCurrentUser.. t Transfer: 1220 : 107|16:49:49.6328|| OAuth authenticated t Transfer: 1220 : 107|16:49:49.6328|| user TONY. t Verbose: 1220 : 107|16:49:49.6328||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Afghanistan vs Sri Lanka Match 7.mp4 subfolder t Verbose: 1220 : 107|16:49:49.6328|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Afghanistan vs Sri Lanka Match 7.mp4 t Verbose: 1220 : 107|16:49:49.6328||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/Afghanistan vs Sri Lanka Match 7.mp4 t Transfer: 1220 : 107|16:49:49.6328||GetCurrentUser.. t Transfer: 1220 : 107|16:49:49.6328|| OAuth authenticated t Transfer: 1220 : 107|16:49:49.6328|| user TONY. t Verbose: 1220 : 107|16:49:49.6328||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Australia vs West Indies Match 10.mp4 subfolder t Verbose: 1220 : 107|16:49:49.6328|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Australia vs West Indies Match 10.mp4 t Verbose: 1220 : 107|16:49:49.6328||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/Australia vs West Indies Match 10.mp4 t Transfer: 1220 : 107|16:49:49.6328||GetCurrentUser.. t Transfer: 1220 : 107|16:49:49.6328|| OAuth authenticated t Transfer: 1220 : 107|16:49:49.6328|| user TONY. t Verbose: 1220 : 107|16:49:49.6485||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\South Africa vs India Match 8.mp4 subfolder t Verbose: 1220 : 107|16:49:49.6485|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/South Africa vs India Match 8.mp4 t Verbose: 1220 : 107|16:49:49.6485||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/South Africa vs India Match 8.mp4 t Transfer: 1220 : 107|16:49:49.6485||GetCurrentUser.. t Transfer: 1220 : 107|16:49:49.6485|| OAuth authenticated t Transfer: 1220 : 107|16:49:49.6485|| user TONY. t Verbose: 1220 : 107|16:49:49.6485||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\England vs Pakistan Match 6.mp4 subfolder t Verbose: 1220 : 107|16:49:49.6485|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/England vs Pakistan Match 6.mp4 t Verbose: 1220 : 107|16:49:49.6485||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/England vs Pakistan Match 6.mp4 t Transfer: 1220 : 107|16:49:49.6485||GetCurrentUser.. t Transfer: 1220 : 107|16:49:49.6485|| OAuth authenticated t Transfer: 1220 : 107|16:49:49.6485|| user TONY. t Verbose: 1220 : 107|16:49:49.6485||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Pakistan vs Sri Lanka Match 11.mp4 subfolder t Verbose: 1220 : 107|16:49:49.6485|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Pakistan vs Sri Lanka Match 11.mp4 t Verbose: 1220 : 107|16:49:49.6485||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/Pakistan vs Sri Lanka Match 11.mp4 t Transfer: 1220 : 107|16:49:49.6485||GetCurrentUser.. t Transfer: 1220 : 107|16:49:49.6485|| OAuth authenticated t Transfer: 1220 : 107|16:49:49.6485|| user TONY. t Transfer: 1220 : 107|16:49:49.7891||IsUserAuthenticated: /api/user-preferences?_dc=1576169359102 t Transfer: 1220 : 107|16:49:49.7891||GetCurrentUser.. t Transfer: 1220 : 107|16:49:49.7891|| OAuth authenticated t Transfer: 1220 : 107|16:49:49.7891|| user TONY. t Transfer: 1220 : 107|16:49:49.7891||api user: TONY t Verbose: 1220 : 107|16:49:49.7891||StoreUserDataByKeys.. t Transfer: 1220 : 107|16:49:49.7891||GetCurrentUser.. t Transfer: 1220 : 107|16:49:49.7891|| OAuth authenticated t Transfer: 1220 : 107|16:49:49.7891|| user TONY. t Transfer: 1220 : 80|16:49:56.0078||IsUserAuthenticated: /api/media-details/298503?_dc=1576169365321 t Transfer: 1220 : 80|16:49:56.0078||GetCurrentUser.. t Transfer: 1220 : 80|16:49:56.0078|| OAuth authenticated t Transfer: 1220 : 80|16:49:56.0078|| user TONY. t Transfer: 1220 : 80|16:49:56.0078||api user: TONY t Transfer: 1220 : 80|16:49:56.0078||GetCurrentUser.. t Transfer: 1220 : 80|16:49:56.0078|| OAuth authenticated t Transfer: 1220 : 80|16:49:56.0078|| user TONY. t Information: 1220 : 80|16:49:56.0391||TM_MIS. LoadSubtitles for ID: 298503. t Information: 1220 : 80|16:49:56.0391||TM_MIS. LoadSubtitles for ID: 298503. 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=298391' t Information: 1220 : 80|16:49:56.0547||TM_MIS. LoadSubtitles for ID: 298503 found no subtitles. t Verbose: 1220 : 80|16:49:56.0860||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\ICC 360 Cricket for Change.mp4 subfolder t Verbose: 1220 : 80|16:49:56.0860|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/ICC 360 Cricket for Change.mp4 t Verbose: 1220 : 80|16:49:56.0860||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/ICC 360 Cricket for Change.mp4 t Transfer: 1220 : 80|16:49:56.0860||GetCurrentUser.. t Transfer: 1220 : 80|16:49:56.0860|| OAuth authenticated t Transfer: 1220 : 80|16:49:56.0860|| user TONY. t Transfer: 1220 : 105|16:49:56.1797||IsUserAuthenticated: /api/v3/detailsview/MediaDetails/5?lang=en-GB&_dc=1576169365478 t Transfer: 1220 : 105|16:49:56.1797||GetCurrentUser.. t Transfer: 1220 : 105|16:49:56.1797|| OAuth authenticated t Transfer: 1220 : 105|16:49:56.1797|| user TONY. t Transfer: 1220 : 105|16:49:56.1797||api user: TONY t Transfer: 1220 : 101|16:49:56.2578||IsUserAuthenticated: /api/media-captions/298503?_dc=1576169365575 t Transfer: 1220 : 101|16:49:56.2578||GetCurrentUser.. t Transfer: 1220 : 101|16:49:56.2578|| OAuth authenticated t Transfer: 1220 : 101|16:49:56.2578|| user TONY. t Transfer: 1220 : 101|16:49:56.2735||api user: TONY t Transfer: 1220 : 107|16:49:56.2891||IsUserAuthenticated: /api/lookups/FriendlyNames?_dc=1576169365601 t Transfer: 1220 : 107|16:49:56.2891||GetCurrentUser.. t Transfer: 1220 : 107|16:49:56.2891|| OAuth authenticated t Transfer: 1220 : 107|16:49:56.2891|| user TONY. t Transfer: 1220 : 107|16:49:56.2891||api user: TONY t Transfer: 1220 : 65|16:49:56.3828||IsUserAuthenticated: /api/user-group-preferences?globals=htmlplayerhotkeys,audioOnFrameForward&_dc=1576169365705 t Transfer: 1220 : 65|16:49:56.3828||GetCurrentUser.. t Transfer: 1220 : 65|16:49:56.3828|| OAuth authenticated t Transfer: 1220 : 65|16:49:56.3828|| user TONY. t Transfer: 1220 : 65|16:49:56.3828||api user: TONY t Information: 1220 : 65|16:49:56.3828||V3Api.GetUserSettings t Transfer: 1220 : 65|16:49:56.3828||GetCurrentUser.. t Transfer: 1220 : 65|16:49:56.3828|| OAuth authenticated t Transfer: 1220 : 65|16:49:56.3828|| user TONY. t Transfer: 1220 : 105|16:49:56.4453||IsUserAuthenticated: /api/lookups/MediaEventTypes?_dc=1576169365766 t Transfer: 1220 : 105|16:49:56.4453||GetCurrentUser.. t Transfer: 1220 : 105|16:49:56.4453|| OAuth authenticated t Transfer: 1220 : 105|16:49:56.4453|| user TONY. t Transfer: 1220 : 105|16:49:56.4453||api user: TONY t Transfer: 1220 : 107|16:49:56.6016||IsUserAuthenticated: /api/v3/media/related/298503/audio?_dc=1576169365923 t Transfer: 1220 : 107|16:49:56.6016||GetCurrentUser.. t Transfer: 1220 : 107|16:49:56.6016|| OAuth authenticated t Transfer: 1220 : 107|16:49:56.6016|| user TONY. t Transfer: 1220 : 107|16:49:56.6016||api user: TONY t Transfer: 1220 : 65|16:49:56.6329||IsUserAuthenticated: /api/mediavideo/298503?info=smudge,scene,audiovolume&_dc=1576169365951 t Transfer: 1220 : 65|16:49:56.6329||GetCurrentUser.. t Transfer: 1220 : 65|16:49:56.6329|| OAuth authenticated t Transfer: 1220 : 65|16:49:56.6329|| user TONY. t Transfer: 1220 : 65|16:49:56.6329||api user: TONY t Verbose: 1220 : 65|16:49:56.6329||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\ICC 360 Cricket for Change.mp4 subfolder t Verbose: 1220 : 65|16:49:56.6329|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/ICC 360 Cricket for Change.mp4 t Verbose: 1220 : 65|16:49:56.6329||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/ICC 360 Cricket for Change.mp4 t Transfer: 1220 : 65|16:49:56.6329||GetCurrentUser.. t Transfer: 1220 : 65|16:49:56.6329|| OAuth authenticated t Transfer: 1220 : 65|16:49:56.6329|| user TONY. t Transfer: 1220 : 105|16:49:56.6797||IsUserAuthenticated: /api/v3/ai-tags/298503?_dc=1576169365988 t Transfer: 1220 : 105|16:49:56.6797||GetCurrentUser.. t Transfer: 1220 : 105|16:49:56.6797|| OAuth authenticated t Transfer: 1220 : 105|16:49:56.6797|| user TONY. t Transfer: 1220 : 105|16:49:56.6797||api user: TONY t Information: 1220 : 105|16:49:56.6797||V3Api.GetMediaAiTags t Transfer: 1220 : 80|16:49:56.9610||IsUserAuthenticated: /api/mediavideo/298503?info=smudge&_dc=1576169366273 t Transfer: 1220 : 80|16:49:56.9610||GetCurrentUser.. t Transfer: 1220 : 80|16:49:56.9610|| OAuth authenticated t Transfer: 1220 : 80|16:49:56.9610|| user TONY. t Transfer: 1220 : 80|16:49:56.9610||api user: TONY t Verbose: 1220 : 80|16:49:56.9610||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\ICC 360 Cricket for Change.mp4 subfolder t Verbose: 1220 : 80|16:49:56.9610|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/ICC 360 Cricket for Change.mp4 t Verbose: 1220 : 80|16:49:56.9610||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/ICC 360 Cricket for Change.mp4 t Transfer: 1220 : 80|16:49:56.9610||GetCurrentUser.. t Transfer: 1220 : 80|16:49:56.9610|| OAuth authenticated t Transfer: 1220 : 80|16:49:56.9610|| user TONY. t Transfer: 1220 : 108|16:50:25.7266||IsUserAuthenticated: /api/user-group-preferences?globals=htmlplayerhotkeys,audioOnFrameForward&_dc=1576169394997 t Transfer: 1220 : 108|16:50:25.7266||GetCurrentUser.. t Transfer: 1220 : 108|16:50:25.7266|| OAuth authenticated t Transfer: 1220 : 108|16:50:25.7266|| user TONY. t Transfer: 1220 : 108|16:50:25.7266||api user: TONY t Information: 1220 : 108|16:50:25.7266||V3Api.GetUserSettings t Transfer: 1220 : 108|16:50:25.7266||GetCurrentUser.. t Transfer: 1220 : 108|16:50:25.7266|| OAuth authenticated t Transfer: 1220 : 108|16:50:25.7266|| user TONY. t Information: 1220 : 105|16:50:36.3516||GetAppInfo t Information: 1220 : 105|16:50:36.3516|| db: TMDDEMO install mode: auth types: Native, PublicApiKey t Information: 1220 : 48|17:11:14.7577||OrabitWatcherBasic. Disposing. t Information: 1220 : 48|17:11:14.7577||OrabitWatcherBasic. Disposed. t Information: 1220 : 48|17:11:14.7577||========================================================================== t Information: 1220 : 48|17:11:14.7577||IMFX CORE SERVER APPLICATION END. t Information: 1220 : 2|17:11:15.9764||OrabitWatcherBasic disposing.. t Information: 1220 : 2|17:11:15.9764||OrabitWatcherBasic disposed.