t Information: 1220 : 1|11:20:54.6932||Get Configuration Values: t Information: 1220 : 1|11:20:54.6932|| AdminPassEnc, default: , value: ffqjrn0leKv4Lj2YJHe2dw==. t Information: 1220 : 1|11:20:54.6932|| EncryptedPasswords, default: false, value: true. t Information: 1220 : 1|11:20:54.6932|| OraConnectionString, default: , value: Server=TECHM;User Id=imfx;Password=;Unicode=true;. t Information: 1220 : 1|11:20:54.6932|| SecondTimezone, default: , value: . t Information: 1220 : 1|11:20:54.6932|| UseActiveDirectoryAuth, default: false, value: false. t Information: 1220 : 1|11:20:54.6932|| ReportingServiceUrl, default: , value: http://localhost:92/ReportingService.svc. t Information: 1220 : 1|11:20:54.6932|| ReportsPath, default: , value: . t Information: 1220 : 1|11:20:54.6932|| ReportsURL, default: , value: . t Information: 1220 : 1|11:20:54.6932|| TapeServiceUrl, default: , value: . t Information: 1220 : 1|11:20:54.6932|| GatekeeperUrl, default: , value: . t Information: 1220 : 1|11:20:54.6932|| ValuationUrl, default: , value: . t Information: 1220 : 1|11:20:54.6932|| QueueManagerDelay, default: 30, value: 30. t Information: 1220 : 1|11:20:54.6932|| QueueManagerFullRefresh, default: 90, value: 90. t Information: 1220 : 1|11:20:54.6932|| AudioLoopDuration, default: 0, value: 150. t Information: 1220 : 1|11:20:54.6932|| AudioLoopsCount, default: 0, value: 0. t Information: 1220 : 1|11:20:54.6932|| PlayerFakeStep, default: 500, value: 500. t Information: 1220 : 1|11:20:54.6932|| PlayerForceRatio, default: 0, value: 1. t Information: 1220 : 1|11:20:54.6932|| CheckVersionsInProd, default: false, value: True. t Information: 1220 : 1|11:20:54.6932|| MaxResults, default: 3000, value: 10000. t Information: 1220 : 1|11:20:54.6932|| NetworkRestriction, default: false, value: True. t Information: 1220 : 1|11:20:54.6932|| TEReportID, default: 0, value: 0. t Information: 1220 : 1|11:20:54.6932|| ClosedCaptionsCache, default: , value: C:\inetpub\wwwroot\imfxcore\timedtextcache\. t Information: 1220 : 1|11:20:54.6932|| ClosedCaptionsStorage, default: , value: c:\Mediaflex\subs. t Information: 1220 : 1|11:20:54.6932|| TimeCodeFormat, default: , value: pal. t Information: 1220 : 1|11:20:54.6932|| RceMediaPath, default: , value: C:\edl\. t Information: 1220 : 1|11:20:54.6932|| RceMediaPath, default: , value: C:\edl\. t Information: 1220 : 1|11:20:54.6932|| RceCsmOutputPath, default: , value: C:\Inetpub\wwwroot\csm\. t Information: 1220 : 1|11:20:54.6932|| RceCsmUrl, default: , value: http://localhost/csm/. t Information: 1220 : 1|11:20:54.6932|| RceMediaSelection, default: , value: miLinkIdMatch. t Information: 1220 : 1|11:20:54.6932|| RequestBrowseJobPresetName, default: , value: . t Information: 1220 : 1|11:20:54.6932|| DontExtendDuration, default: false, value: False. t Information: 1220 : 1|11:20:54.6932|| V3ConfigUrl, default: , value: . t Information: 1220 : 1|11:20:54.6932|| ApiServer, default: , value: http://192.168.120.10:85. t Information: 1220 : 1|11:20:54.6932|| StopWords, default: , value: . t Information: 1220 : 1|11:20:54.6932|| MisrTxFormat, default: G, value: G. t Information: 1220 : 1|11:20:54.6932|| ThumbnailServer, default: , value: . t Information: 1220 : 1|11:20:54.6932|| LocationFilter, default: , value: . t Information: 1220 : 1|11:20:54.6932|| SvUtilServiceUrl, default: , value: . t Information: 1220 : 1|11:20:54.6932|| SolrConnection, default: , value: http://192.168.120.14:8983/solr. t Information: 1220 : 1|11:20:54.6932|| UseIndexServerSearch, default: false, value: True. t Information: 1220 : 1|11:20:54.6932|| SolrIndexVersion, default: 1, value: 6. t Information: 1220 : 1|11:20:54.6932|| SolrConnection, default: , value: http://192.168.120.14:8983/solr. t Information: 1220 : 1|11:20:54.6932|| FacetsGroups, default: , value: owners,season_id, series_id,version_key,item_type,media_type,media_format,episode_number. t Information: 1220 : 1|11:20:54.6932|| FacetsGroupsVersion, default: , value: owners,season_id, series_id,version_key,episode_number. t Information: 1220 : 1|11:20:54.6932|| FacetsGroupsChameleon, default: , value: season_id, series_id,genre,prod_year,version_key. t Information: 1220 : 1|11:20:54.6932|| PreviewPreset, default: , value: . t Information: 1220 : 1|11:20:54.7088|| DevMode, default: false, value: false. t Information: 1220 : 1|11:20:54.7088|| DisableSysMan, default: false, value: false. t Information: 1220 : 1|11:20:54.7088|| TimeCodeFormat, default: , value: pal. t Information: 1220 : 1|11:20:54.7088|| FileCatalystStorageDevice, default: , value: . t Information: 1220 : 1|11:20:54.7088|| UseResponsibilityTracking, default: true, value: True. t Information: 1220 : 1|11:20:54.7088|| SubtitleDeviceFilter, default: , value: . t Information: 1220 : 1|11:20:54.7088|| SystemMonitorNamedPipe, default: , value: . t Information: 1220 : 1|11:20:54.7088|| OracleMonitorEnable, default: false, value: False. t Information: 1220 : 1|11:20:54.7088|| ArcApiHost, default: , value: . t Information: 1220 : 1|11:20:54.7088|| RabbitMqUrl, default: , value: amqp://192.168.120.14:5672. t Information: 1220 : 1|11:20:54.7088|| SolrTimedTextSearch, default: false, value: false. t Information: 1220 : 1|11:20:54.7088|| ProductionDurationUsageID, default: 1, value: 1. t Information: 1220 : 1|11:20:55.0213||GetStreamServers.. t Information: 1220 : 1|11:20:55.7557|| https://demo.tmd.tv/CBR Video/ |CBR Video| False t Information: 1220 : 1|11:20:55.7557|| https://demo.tmd.tv/CBR Images/ |CBR Images| False t Information: 1220 : 1|11:20:55.7557|| https://demo.tmd.tv/CBR Audio/ |CBR Audio| False t Information: 1220 : 1|11:20:55.7557|| https://demo.tmd.tv/Temp Upload/ |TEMP_UPLOAD| False t Information: 1220 : 1|11:20:55.7557|| http://localhost:82/images/ |IMAGES| False t Information: 1220 : 1|11:20:55.7557|| http://192.168.91.73/smoothcloud/ |SMOOTH_CLOUD| False t Information: 1220 : 1|11:20:55.7557|| http://192.168.91.73/cloudstore/ |CLOUD_STORE| False t Information: 1220 : 1|11:20:55.7557|| http://192.168.91.73/editsystemin/ |EDIT_SYSTEM_IN| False t Information: 1220 : 1|11:20:55.7557|| http://192.168.91.27:89/APPLEPROXY/ |APPLE_PROXY| False t Information: 1220 : 1|11:20:55.7557|| http://localhost:82/video/ |FILESTORE_VIDEO| False t Information: 1220 : 1|11:20:55.7557|| https://imfxv3tm.tmd.tv/streaming/ |Streaming| False t Information: 1220 : 1|11:20:55.7557|| https://imfxv3tm.tmd.tv/VideoServer/ |Video| False t Information: 1220 : 1|11:20:55.7557|| https://imfxv3tm.tmd.tv/AdobeIn/ |Adobe Premiere Pro In| False t Information: 1220 : 1|11:20:55.7557|| https://imfxv3tm.tmd.tv/AudioServer/ |Audio| False t Information: 1220 : 1|11:20:55.7557|| https://imfxv3tm.tmd.tv/ImageServer/ |Image| False t Information: 1220 : 1|11:20:55.7557|| https://imfxv3tm.tmd.tv/DocsServer/ |Docs| False t Information: 1220 : 1|11:20:55.7557|| https://imfxv3tm.tmd.tv/AmazonLabs/ |TEST HOUSE| False t Information: 1220 : 1|11:20:55.7557|| SolrConnectionUms, default: http://192.168.120.14:8983/solr, value: http://192.168.120.14:8983/solr. t Information: 1220 : 1|11:20:55.7557|| ApiLog, default: false, value: false. t Information: 1220 : 1|11:20:55.7713|| EmbeddedRceUrl, default: , value: . t Information: 1220 : 1|11:20:55.7713|| InstallMode, default: , value: . t Information: 1220 : 1|11:20:55.7713|| SamlRequestAddress, default: , value: . t Information: 1220 : 1|11:20:55.7713|| SamlTrustedIssuer, default: , value: . t Information: 1220 : 1|11:20:55.7713|| SamlLoginRedirect, default: , value: . t Information: 1220 : 1|11:20:55.7713|| NaturalLangSearch, default: false, value: True. t Information: 1220 : 1|11:20:55.7713|| OktaLoginField, default: , value: . t Information: 1220 : 1|11:20:55.7713|| AuthenticationTypes, default: , value: Native,PublicApiKey. t Information: 1220 : 1|11:20:55.7713||OrabitWatcherBasic. Initialize. t Information: 1220 : 1|11:20:55.8650||FillDictionaryCache. t Information: 1220 : 1|11:20:59.3494||GetSupportedOperators t Information: 1220 : 11|11:20:59.7088||CacheTechReports. t Information: 1220 : 1|11:20:59.8338||& Cache update. Server (global) filled with timestamp 11:02:59.8338180. types null t Information: 1220 : 1|11:20:59.8494||InitializeFromDatabase. 'Server=TECHM;User Id=imfx;password=..;Unicode=true;' direct False, home , timeout 15 t Information: 1220 : 1|11:20:59.8494||FillDictionaryCache. t Information: 1220 : 1|11:20:59.8963||& Cache update. Server (global) filled with timestamp 11:02:59.8963267. types FriendlyNames, DatabaseSearchFieldData t Information: 1220 : 1|11:21:00.2088||========================================================================== t Information: 1220 : 1|11:21:00.2088||IMFX CORE SERVER APPLICATION START. t Information: 1220 : 1|11:21:00.2088||DLL VERSION: 2.5.0.2448. t Information: 1220 : 11|11:21:00.2088|| UmsDev, default: False, value: False. t Information: 1220 : 1|11:21:00.3025|| ApiLog, default: false, value: false. t Information: 1220 : 10|11:21:00.7869||OrabitWatcherBasic trying to connect.. t Information: 1220 : 10|11:21:00.8650||OrabitWatcherBasic connected. t Information: 1220 : 10|11:21:00.8807||OrabitWatcherBasic queue created tmd.cfg.in.8160866e-f221-4dc8-b742-2bbe41e61508 t Information: 1220 : 17|11:21:07.5213||GetAppInfo t Information: 1220 : 17|11:21:07.5369|| db: TMDDEMO install mode: auth types: Native, PublicApiKey t Information: 1220 : 10|11:21:10.4900||Oauth validating.. t Verbose: 1220 : 10|11:21:10.4900||GrantResourceOwnerCredentials. t Verbose: 1220 : 10|11:21:10.4900||LoginUser. tony, login type OAuth, encrypt password True t Information: 1220 : 10|11:21:10.4900||TryLoginUser. tony, login type OAuth, check password True, check hash False, encrypt password True, load user data False t Information: 1220 : 10|11:21:10.6462|| oauth token 00000000-0000-0000-0000-000000000000 t Information: 1220 : 10|11:21:10.6462||TryLoginUser. Logged in.. t Information: 1220 : 10|11:21:10.6619||GetPasswordPolicy. WARNING: Policy not found for system Imediaflex. Validation disabled. t Verbose: 1220 : 10|11:21:10.6619||LoginUser. Adding history. User Id 522, result TONY, host 192.168.127.6 t Verbose: 1220 : 10|11:21:10.6931||GrantResourceOwnerCredentials. Try login finished. Logged: True t Transfer: 1220 : 11|11:21:10.7713||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,supplier_portal.version_complete.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=1581679228952 t Transfer: 1220 : 11|11:21:10.7713||GetCurrentUser.. t Transfer: 1220 : 11|11:21:10.7713|| OAuth authenticated t Transfer: 1220 : 11|11:21:10.7713|| user TONY. t Transfer: 1220 : 11|11:21:10.7713||api user: TONY t Information: 1220 : 11|11:21:10.7713||V3Api.GetUserSettings t Transfer: 1220 : 11|11:21:10.7713||GetCurrentUser.. t Transfer: 1220 : 11|11:21:10.7713|| OAuth authenticated t Transfer: 1220 : 11|11:21:10.7713|| user TONY. t Transfer: 1220 : 11|11:21:10.8650||IsUserAuthenticated: /api/user-preferences?keys=personal_settings;basket;default_page;color_schema;media.basket.data;defaultSearch&_dc=1581679229050 t Transfer: 1220 : 11|11:21:10.8650||GetCurrentUser.. t Transfer: 1220 : 11|11:21:10.8650|| OAuth authenticated t Transfer: 1220 : 11|11:21:10.8650|| user TONY. t Transfer: 1220 : 11|11:21:10.8650||api user: TONY t Information: 1220 : 11|11:21:10.8650||GetUserDataByKeys: personal_settings;basket;default_page;color_schema;media.basket.data;defaultSearch t Transfer: 1220 : 11|11:21:10.8650||GetCurrentUser.. t Transfer: 1220 : 11|11:21:10.8650|| OAuth authenticated t Transfer: 1220 : 11|11:21:10.8650|| user TONY. t Transfer: 1220 : 12|11:21:10.8650||IsUserAuthenticated: /api/lookups/MediaStatus?_dc=1581679229051 t Transfer: 1220 : 12|11:21:10.8650||GetCurrentUser.. t Transfer: 1220 : 12|11:21:10.8650|| OAuth authenticated t Transfer: 1220 : 12|11:21:10.8650|| user TONY. t Transfer: 1220 : 12|11:21:10.8650||api user: TONY t Transfer: 1220 : 17|11:21:10.8650||IsUserAuthenticated: /api/lookups/PgmStatus?_dc=1581679229052 t Transfer: 1220 : 17|11:21:10.8650||GetCurrentUser.. t Transfer: 1220 : 17|11:21:10.8650|| OAuth authenticated t Transfer: 1220 : 17|11:21:10.8650|| user TONY. t Transfer: 1220 : 17|11:21:10.8650||api user: TONY t Information: 1220 : 6|11:21:10.9431||GetUserProfile. Id: 0 t Transfer: 1220 : 6|11:21:10.9431||GetCurrentUser.. t Transfer: 1220 : 6|11:21:10.9431|| OAuth authenticated t Transfer: 1220 : 6|11:21:10.9431|| user TONY. t Transfer: 1220 : 11|11:21:11.2400||IsUserAuthenticated: /api/settings/user/defaultHomePage?_dc=1581679229407 t Transfer: 1220 : 11|11:21:11.2400||GetCurrentUser.. t Transfer: 1220 : 11|11:21:11.2400|| OAuth authenticated t Transfer: 1220 : 11|11:21:11.2400|| user TONY. t Transfer: 1220 : 11|11:21:11.2400||api user: TONY t Information: 1220 : 11|11:21:11.2400||V3Api.GetUserSettings t Transfer: 1220 : 11|11:21:11.2400||GetCurrentUser.. t Transfer: 1220 : 11|11:21:11.2400|| OAuth authenticated t Transfer: 1220 : 11|11:21:11.2400|| user TONY. t Transfer: 1220 : 6|11:21:11.5837||IsUserAuthenticated: /api/settings/user/uploadSettings?_dc=1581679229772 t Transfer: 1220 : 6|11:21:11.5837||GetCurrentUser.. t Transfer: 1220 : 6|11:21:11.5837|| OAuth authenticated t Transfer: 1220 : 6|11:21:11.5837|| user TONY. t Transfer: 1220 : 6|11:21:11.5837||api user: TONY t Information: 1220 : 6|11:21:11.5837||V3Api.GetUserSettings t Transfer: 1220 : 6|11:21:11.5837||GetCurrentUser.. t Transfer: 1220 : 6|11:21:11.5837|| OAuth authenticated t Transfer: 1220 : 6|11:21:11.5837|| user TONY. t Transfer: 1220 : 12|11:21:11.5994||IsUserAuthenticated: /api/settings/user/defaultSearch?_dc=1581679229789 t Transfer: 1220 : 12|11:21:11.5994||GetCurrentUser.. t Transfer: 1220 : 12|11:21:11.5994|| OAuth authenticated t Transfer: 1220 : 12|11:21:11.5994|| user TONY. t Transfer: 1220 : 12|11:21:11.5994||api user: TONY t Information: 1220 : 12|11:21:11.5994||V3Api.GetUserSettings t Transfer: 1220 : 12|11:21:11.5994||GetCurrentUser.. t Transfer: 1220 : 12|11:21:11.5994|| OAuth authenticated t Transfer: 1220 : 12|11:21:11.5994|| user TONY. t Transfer: 1220 : 17|11:21:11.5994||IsUserAuthenticated: /api/settings/user/startSearch?_dc=1581679229791 t Transfer: 1220 : 17|11:21:11.5994||GetCurrentUser.. t Transfer: 1220 : 17|11:21:11.5994|| OAuth authenticated t Transfer: 1220 : 17|11:21:11.5994|| user TONY. t Transfer: 1220 : 17|11:21:11.5994||api user: TONY t Information: 1220 : 17|11:21:11.5994||V3Api.GetUserSettings t Transfer: 1220 : 17|11:21:11.5994||GetCurrentUser.. t Transfer: 1220 : 17|11:21:11.5994|| OAuth authenticated t Transfer: 1220 : 17|11:21:11.5994|| user TONY. t Transfer: 1220 : 17|11:21:11.6306||IsUserAuthenticated: /api/user-preferences?keys=upload_native_queue&_dc=1581679229820 t Transfer: 1220 : 17|11:21:11.6306||GetCurrentUser.. t Transfer: 1220 : 17|11:21:11.6306|| OAuth authenticated t Transfer: 1220 : 17|11:21:11.6306|| user TONY. t Transfer: 1220 : 17|11:21:11.6306||api user: TONY t Information: 1220 : 17|11:21:11.6306||GetUserDataByKeys: upload_native_queue t Transfer: 1220 : 17|11:21:11.6306||GetCurrentUser.. t Transfer: 1220 : 17|11:21:11.6306|| OAuth authenticated t Transfer: 1220 : 17|11:21:11.6306|| user TONY. t Transfer: 1220 : 17|11:21:11.6775||IsUserAuthenticated: /api/user-preferences?keys=consumer.recent.data&_dc=1581679229868 t Transfer: 1220 : 17|11:21:11.6775||GetCurrentUser.. t Transfer: 1220 : 17|11:21:11.6775|| OAuth authenticated t Transfer: 1220 : 17|11:21:11.6775|| user TONY. t Transfer: 1220 : 17|11:21:11.6775||api user: TONY t Information: 1220 : 17|11:21:11.6775||GetUserDataByKeys: consumer.recent.data t Transfer: 1220 : 17|11:21:11.6775||GetCurrentUser.. t Transfer: 1220 : 17|11:21:11.6775|| OAuth authenticated t Transfer: 1220 : 17|11:21:11.6775|| user TONY. t Transfer: 1220 : 10|11:21:11.6931||IsUserAuthenticated: /api/user-preferences?keys=adv.recent.searches.consumer&_dc=1581679229881 t Transfer: 1220 : 10|11:21:11.6931||GetCurrentUser.. t Transfer: 1220 : 10|11:21:11.6931|| OAuth authenticated t Transfer: 1220 : 10|11:21:11.6931|| user TONY. t Transfer: 1220 : 10|11:21:11.6931||api user: TONY t Information: 1220 : 10|11:21:11.6931||GetUserDataByKeys: adv.recent.searches.consumer t Transfer: 1220 : 10|11:21:11.6931||GetCurrentUser.. t Transfer: 1220 : 10|11:21:11.6931|| OAuth authenticated t Transfer: 1220 : 10|11:21:11.6931|| user TONY. t Transfer: 1220 : 10|11:21:19.3963||IsUserAuthenticated: /api/view/info/MediaGrid?lang=en-GB&_dc=1581679237585 t Transfer: 1220 : 10|11:21:19.3963||GetCurrentUser.. t Transfer: 1220 : 10|11:21:19.3963|| OAuth authenticated t Transfer: 1220 : 10|11:21:19.3963|| user TONY. t Transfer: 1220 : 10|11:21:19.3963||api user: TONY t Transfer: 1220 : 6|11:21:19.3963||IsUserAuthenticated: /api/settings/user/searchLayoutConfig?_dc=1581679237570 t Transfer: 1220 : 6|11:21:19.3963||GetCurrentUser.. t Transfer: 1220 : 6|11:21:19.3963|| OAuth authenticated t Transfer: 1220 : 6|11:21:19.3963|| user TONY. t Transfer: 1220 : 12|11:21:19.3963||IsUserAuthenticated: /api/lookups/SearchSupportedOperators?_dc=1581679237564 t Transfer: 1220 : 12|11:21:19.3963||GetCurrentUser.. t Transfer: 1220 : 12|11:21:19.3963|| OAuth authenticated t Transfer: 1220 : 12|11:21:19.3963|| user TONY. t Transfer: 1220 : 12|11:21:19.3963||api user: TONY t Transfer: 1220 : 6|11:21:19.3963||api user: TONY t Information: 1220 : 6|11:21:19.3963||V3Api.GetUserSettings t Transfer: 1220 : 6|11:21:19.3963||GetCurrentUser.. t Transfer: 1220 : 11|11:21:19.3963||IsUserAuthenticated: /api/view/searchinfo/Media?_dc=1581679237563 t Transfer: 1220 : 11|11:21:19.3963||GetCurrentUser.. t Transfer: 1220 : 11|11:21:19.3963|| OAuth authenticated t Transfer: 1220 : 11|11:21:19.3963|| user TONY. t Transfer: 1220 : 11|11:21:19.3963||api user: TONY t Transfer: 1220 : 6|11:21:19.3963|| OAuth authenticated t Transfer: 1220 : 6|11:21:19.3963|| user TONY. t Information: 1220 : 10|11:21:19.3963||GetGridViewBuilder. builder type MediaGrid. t Information: 1220 : 11|11:21:19.3963||GetAdvSearchColumns. search type Media grid . t Transfer: 1220 : 10|11:21:19.3963||GetCurrentUser.. t Transfer: 1220 : 10|11:21:19.4119|| OAuth authenticated t Transfer: 1220 : 10|11:21:19.4119|| user TONY. t Transfer: 1220 : 6|11:21:19.4119||IsUserAuthenticated: /api/user-preferences?keys=adv.recent.searches.media&_dc=1581679237566 t Transfer: 1220 : 6|11:21:19.4119||GetCurrentUser.. t Transfer: 1220 : 6|11:21:19.4119|| OAuth authenticated t Transfer: 1220 : 6|11:21:19.4119|| user TONY. t Transfer: 1220 : 6|11:21:19.4119||api user: TONY t Information: 1220 : 6|11:21:19.4119||GetUserDataByKeys: adv.recent.searches.media t Transfer: 1220 : 6|11:21:19.4119||GetCurrentUser.. t Transfer: 1220 : 6|11:21:19.4119|| OAuth authenticated t Transfer: 1220 : 6|11:21:19.4119|| user TONY. t Information: 1220 : 10|11:21:19.4119||UserGridView. LoadView. ID 1282, Name Default. t Transfer: 1220 : 10|11:21:19.4119||GetCurrentUser.. t Transfer: 1220 : 10|11:21:19.4119|| OAuth authenticated t Transfer: 1220 : 10|11:21:19.4119|| user TONY. t Transfer: 1220 : 10|11:21:19.4119||GetCurrentUser.. t Transfer: 1220 : 10|11:21:19.4119|| OAuth authenticated t Transfer: 1220 : 10|11:21:19.4119|| user TONY. t Transfer: 1220 : 10|11:21:19.5212||IsUserAuthenticated: /api/view/searches/Media?_dc=1581679237601 t Transfer: 1220 : 10|11:21:19.5212||GetCurrentUser.. t Transfer: 1220 : 10|11:21:19.5212|| OAuth authenticated t Transfer: 1220 : 10|11:21:19.5212|| user TONY. t Transfer: 1220 : 10|11:21:19.5212||api user: TONY t Information: 1220 : 10|11:21:19.5212||GetSavedSearchNames. search type Media. t Transfer: 1220 : 10|11:21:19.5212||GetCurrentUser.. t Transfer: 1220 : 10|11:21:19.5212|| OAuth authenticated t Transfer: 1220 : 10|11:21:19.5212|| user TONY. t Transfer: 1220 : 6|11:21:22.4119||IsUserAuthenticated: /api/v3/search-suggestion/?_dc=1581679240595 t Transfer: 1220 : 6|11:21:22.4119||GetCurrentUser.. t Transfer: 1220 : 6|11:21:22.4119|| OAuth authenticated t Transfer: 1220 : 6|11:21:22.4119|| user TONY. t Transfer: 1220 : 6|11:21:22.4119||api user: TONY t Transfer: 1220 : 6|11:21:22.4744||GetCurrentUser.. t Transfer: 1220 : 6|11:21:22.4744|| OAuth authenticated t Transfer: 1220 : 6|11:21:22.4744|| user TONY. t Transfer: 1220 : 12|11:21:25.4119||IsUserAuthenticated: /api/v3/search/Media?_dc=1581679243562 t Transfer: 1220 : 12|11:21:25.4119||GetCurrentUser.. t Transfer: 1220 : 12|11:21:25.4119|| OAuth authenticated t Transfer: 1220 : 12|11:21:25.4119|| user TONY. t Transfer: 1220 : 12|11:21:25.4119||api user: TONY t Information: 1220 : 12|11:21:25.4900||V3Api.SearchMedia t Information: 1220 : 12|11:21:25.4900||V3Api.SearchGeneric t Transfer: 1220 : 12|11:21:25.5369||GetCurrentUser.. t Transfer: 1220 : 12|11:21:25.5369|| OAuth authenticated t Transfer: 1220 : 12|11:21:25.5369|| user TONY. t Information: 1220 : 12|11:21:25.6306||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 : 12|11:21:25.8025|| timing: 00:00:00.2826234 t Verbose: 1220 : 12|11:21:25.9744||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\ICC 360 Cricket for Change.mp4 subfolder t Verbose: 1220 : 12|11:21:25.9744|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/ICC 360 Cricket for Change.mp4 t Verbose: 1220 : 12|11:21:25.9744||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/ICC 360 Cricket for Change.mp4 t Transfer: 1220 : 12|11:21:25.9744||GetCurrentUser.. t Transfer: 1220 : 12|11:21:25.9744|| OAuth authenticated t Transfer: 1220 : 12|11:21:25.9744|| user TONY. t Transfer: 1220 : 17|11:21:26.2087||IsUserAuthenticated: /api/user-preferences?_dc=1581679244384 t Transfer: 1220 : 17|11:21:26.2087||GetCurrentUser.. t Transfer: 1220 : 17|11:21:26.2087|| OAuth authenticated t Transfer: 1220 : 17|11:21:26.2087|| user TONY. t Transfer: 1220 : 17|11:21:26.2087||api user: TONY t Verbose: 1220 : 17|11:21:26.2087||StoreUserDataByKeys.. t Transfer: 1220 : 17|11:21:26.2087||GetCurrentUser.. t Transfer: 1220 : 17|11:21:26.2087|| OAuth authenticated t Transfer: 1220 : 17|11:21:26.2087|| user TONY. t Transfer: 1220 : 6|11:21:30.7400||IsUserAuthenticated: /api/user-preferences?keys=adv.recent.searches.titles&_dc=1581679248929 t Transfer: 1220 : 6|11:21:30.7400||GetCurrentUser.. t Transfer: 1220 : 6|11:21:30.7400|| OAuth authenticated t Transfer: 1220 : 6|11:21:30.7400|| user TONY. t Transfer: 1220 : 6|11:21:30.7400||api user: TONY t Information: 1220 : 6|11:21:30.7400||GetUserDataByKeys: adv.recent.searches.titles t Transfer: 1220 : 6|11:21:30.7400||GetCurrentUser.. t Transfer: 1220 : 17|11:21:30.7400||IsUserAuthenticated: /api/view/searchinfo/TitleSearch?_dc=1581679248926 t Transfer: 1220 : 17|11:21:30.7400||GetCurrentUser.. t Transfer: 1220 : 17|11:21:30.7400|| OAuth authenticated t Transfer: 1220 : 17|11:21:30.7400|| user TONY. t Transfer: 1220 : 17|11:21:30.7400||api user: TONY t Transfer: 1220 : 6|11:21:30.7400|| OAuth authenticated t Transfer: 1220 : 6|11:21:30.7400|| user TONY. t Information: 1220 : 17|11:21:30.7400||GetAdvSearchColumns. search type TitleSearch grid . t Transfer: 1220 : 17|11:21:30.7556||IsUserAuthenticated: /api/view/info/TitleTree?lang=en-GB&_dc=1581679248946 t Transfer: 1220 : 17|11:21:30.7556||GetCurrentUser.. t Transfer: 1220 : 17|11:21:30.7556|| OAuth authenticated t Transfer: 1220 : 17|11:21:30.7556|| user TONY. t Transfer: 1220 : 17|11:21:30.7556||api user: TONY t Information: 1220 : 17|11:21:30.7556||GetGridViewBuilder. builder type TitleTree. t Transfer: 1220 : 17|11:21:30.7556||GetCurrentUser.. t Transfer: 1220 : 17|11:21:30.7556|| OAuth authenticated t Transfer: 1220 : 17|11:21:30.7556|| user TONY. t Information: 1220 : 17|11:21:30.7556||UserGridView. LoadView. ID 1281, Name Default. t Transfer: 1220 : 17|11:21:30.7556||GetCurrentUser.. t Transfer: 1220 : 17|11:21:30.7556|| OAuth authenticated t Transfer: 1220 : 17|11:21:30.7556|| user TONY. t Transfer: 1220 : 17|11:21:30.7556||GetCurrentUser.. t Transfer: 1220 : 17|11:21:30.7556|| OAuth authenticated t Transfer: 1220 : 17|11:21:30.7556|| user TONY. t Transfer: 1220 : 10|11:21:30.8181||IsUserAuthenticated: /api/view/info/VersionGrid?lang=en-GB&_dc=1581679248971 t Transfer: 1220 : 10|11:21:30.8181||GetCurrentUser.. t Transfer: 1220 : 10|11:21:30.8181|| OAuth authenticated t Transfer: 1220 : 10|11:21:30.8181|| user TONY. t Transfer: 1220 : 10|11:21:30.8181||api user: TONY t Information: 1220 : 10|11:21:30.8181||GetGridViewBuilder. builder type VersionGrid. t Transfer: 1220 : 10|11:21:30.8181||GetCurrentUser.. t Transfer: 1220 : 10|11:21:30.8181|| OAuth authenticated t Transfer: 1220 : 10|11:21:30.8181|| user TONY. t Information: 1220 : 10|11:21:30.8338||UserGridView. LoadView. ID -2, Name Default. t Transfer: 1220 : 10|11:21:30.8338||GetCurrentUser.. t Transfer: 1220 : 10|11:21:30.8338|| OAuth authenticated t Transfer: 1220 : 10|11:21:30.8338|| user TONY. t Transfer: 1220 : 10|11:21:30.8338||GetCurrentUser.. t Transfer: 1220 : 10|11:21:30.8338|| OAuth authenticated t Transfer: 1220 : 10|11:21:30.8338|| user TONY. t Transfer: 1220 : 12|11:21:30.8650||IsUserAuthenticated: /api/view/searches/TitleSearch?_dc=1581679248960 t Transfer: 1220 : 12|11:21:30.8650||GetCurrentUser.. t Transfer: 1220 : 12|11:21:30.8650|| OAuth authenticated t Transfer: 1220 : 12|11:21:30.8650|| user TONY. t Transfer: 1220 : 12|11:21:30.8650||api user: TONY t Information: 1220 : 12|11:21:30.8650||GetSavedSearchNames. search type TitleSearch. t Transfer: 1220 : 12|11:21:30.8650||GetCurrentUser.. t Transfer: 1220 : 12|11:21:30.8650|| OAuth authenticated t Transfer: 1220 : 12|11:21:30.8650|| user TONY. t Transfer: 1220 : 10|11:21:33.7400||IsUserAuthenticated: /api/v3/search-suggestion/?_dc=1581679251899 t Transfer: 1220 : 10|11:21:33.7400||GetCurrentUser.. t Transfer: 1220 : 10|11:21:33.7400|| OAuth authenticated t Transfer: 1220 : 10|11:21:33.7400|| user TONY. t Transfer: 1220 : 10|11:21:33.7400||api user: TONY t Transfer: 1220 : 10|11:21:33.7400||GetCurrentUser.. t Transfer: 1220 : 10|11:21:33.7400|| OAuth authenticated t Transfer: 1220 : 10|11:21:33.7400|| user TONY. t Transfer: 1220 : 6|11:21:34.7244||IsUserAuthenticated: /api/v3/search/title?_dc=1581679252845 t Transfer: 1220 : 6|11:21:34.7244||GetCurrentUser.. t Transfer: 1220 : 6|11:21:34.7244|| OAuth authenticated t Transfer: 1220 : 6|11:21:34.7244|| user TONY. t Transfer: 1220 : 6|11:21:34.7244||api user: TONY t Information: 1220 : 6|11:21:34.7244||V3Api.SearchTitles t Information: 1220 : 6|11:21:34.7244||V3Api.SearchGeneric t Transfer: 1220 : 6|11:21:34.7244||GetCurrentUser.. t Transfer: 1220 : 6|11:21:34.7244|| OAuth authenticated t Transfer: 1220 : 6|11:21:34.7244|| user TONY. t Transfer: 1220 : 6|11:21:34.7244||GetCurrentUser.. t Transfer: 1220 : 6|11:21:34.7244|| OAuth authenticated t Transfer: 1220 : 6|11:21:34.7244|| user TONY. t Information: 1220 : 6|11:21:34.7400||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 : 11|11:21:35.3806||IsUserAuthenticated: /api/v3/title/298401/versions?_dc=1581679253571 t Transfer: 1220 : 11|11:21:35.3806||GetCurrentUser.. t Transfer: 1220 : 11|11:21:35.3806|| OAuth authenticated t Transfer: 1220 : 6|11:21:35.3806||IsUserAuthenticated: /api/user-preferences?_dc=1581679253573 t Transfer: 1220 : 6|11:21:35.3806||GetCurrentUser.. t Transfer: 1220 : 6|11:21:35.3806|| OAuth authenticated t Transfer: 1220 : 6|11:21:35.3806|| user TONY. t Transfer: 1220 : 6|11:21:35.3806||api user: TONY t Verbose: 1220 : 6|11:21:35.3806||StoreUserDataByKeys.. t Transfer: 1220 : 6|11:21:35.3806||GetCurrentUser.. t Transfer: 1220 : 6|11:21:35.3806|| OAuth authenticated t Transfer: 1220 : 6|11:21:35.3806|| user TONY. t Transfer: 1220 : 11|11:21:35.3806|| user TONY. t Transfer: 1220 : 11|11:21:35.3806||api user: TONY t Information: 1220 : 11|11:21:35.3806||V3Api.GetVersionsByTitleIdAdv t Information: 1220 : 11|11:21:35.3806||V3Api.SearchGeneric t Transfer: 1220 : 11|11:21:35.3963||GetCurrentUser.. t Transfer: 1220 : 11|11:21:35.3963|| OAuth authenticated t Transfer: 1220 : 11|11:21:35.3963|| user TONY. t Transfer: 1220 : 11|11:21:35.3963||GetCurrentUser.. t Transfer: 1220 : 11|11:21:35.3963|| OAuth authenticated t Transfer: 1220 : 11|11:21:35.3963|| user TONY. t Information: 1220 : 11|11:21:35.4119||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 : 11|11:21:35.4431||Running version search. User: 522 Simple Search: Running Oracle search for COUNT Oracle count completed in: 4ms. Returned lines: 0 Running Oracle search. Oracle version search timing: 32ms. 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 : 11|11:21:40.6306||IsUserAuthenticated: /api/v3/title/298439/versions?_dc=1581679258731 t Transfer: 1220 : 11|11:21:40.6306||GetCurrentUser.. t Transfer: 1220 : 11|11:21:40.6306|| OAuth authenticated t Transfer: 1220 : 11|11:21:40.6306|| user TONY. t Transfer: 1220 : 11|11:21:40.6462||api user: TONY t Information: 1220 : 11|11:21:40.6462||V3Api.GetVersionsByTitleIdAdv t Information: 1220 : 11|11:21:40.6462||V3Api.SearchGeneric t Transfer: 1220 : 11|11:21:40.6462||GetCurrentUser.. t Transfer: 1220 : 11|11:21:40.6462|| OAuth authenticated t Transfer: 1220 : 11|11:21:40.6462|| user TONY. t Transfer: 1220 : 11|11:21:40.6462||GetCurrentUser.. t Transfer: 1220 : 11|11:21:40.6462|| OAuth authenticated t Transfer: 1220 : 11|11:21:40.6462|| user TONY. t Information: 1220 : 11|11:21:40.6462||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=298439 order by m.title,m.id) a where rownum <= 9999) r where rnum >=1 order by rnum t Information: 1220 : 11|11:21:40.6775||Running version search. User: 522 Simple Search: Running Oracle search for COUNT Oracle count completed in: 4ms. Returned lines: 0 Running Oracle search. Oracle version search timing: 27ms. 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=298439 order by m.title,m.id) a where rownum <= 9999) r where rnum >=1 order by rnum t Transfer: 1220 : 10|11:21:42.6931||IsUserAuthenticated: /api/v3/title/298440/versions?_dc=1581679260882 t Transfer: 1220 : 10|11:21:42.6931||GetCurrentUser.. t Transfer: 1220 : 10|11:21:42.6931|| OAuth authenticated t Transfer: 1220 : 10|11:21:42.6931|| user TONY. t Transfer: 1220 : 10|11:21:42.6931||api user: TONY t Information: 1220 : 10|11:21:42.6931||V3Api.GetVersionsByTitleIdAdv t Information: 1220 : 10|11:21:42.6931||V3Api.SearchGeneric t Transfer: 1220 : 10|11:21:42.6931||GetCurrentUser.. t Transfer: 1220 : 10|11:21:42.6931|| OAuth authenticated t Transfer: 1220 : 10|11:21:42.6931|| user TONY. t Transfer: 1220 : 10|11:21:42.6931||GetCurrentUser.. t Transfer: 1220 : 10|11:21:42.6931|| OAuth authenticated t Transfer: 1220 : 10|11:21:42.6931|| user TONY. t Information: 1220 : 10|11:21:42.6931||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=298440 order by m.title,m.id) a where rownum <= 9999) r where rnum >=1 order by rnum t Information: 1220 : 10|11:21:42.7244||Running version search. User: 522 Simple Search: Running Oracle search for COUNT Oracle count completed in: 4ms. Returned lines: 0 Running Oracle search. Oracle version search timing: 28ms. 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=298440 order by m.title,m.id) a where rownum <= 9999) r where rnum >=1 order by rnum t Transfer: 1220 : 6|11:21:44.4431||IsUserAuthenticated: /api/v3/title/298441/versions?_dc=1581679262642 t Transfer: 1220 : 6|11:21:44.4431||GetCurrentUser.. t Transfer: 1220 : 6|11:21:44.4431|| OAuth authenticated t Transfer: 1220 : 6|11:21:44.4431|| user TONY. t Transfer: 1220 : 6|11:21:44.4431||api user: TONY t Information: 1220 : 6|11:21:44.4431||V3Api.GetVersionsByTitleIdAdv t Information: 1220 : 6|11:21:44.4431||V3Api.SearchGeneric t Transfer: 1220 : 6|11:21:44.4431||GetCurrentUser.. t Transfer: 1220 : 6|11:21:44.4431|| OAuth authenticated t Transfer: 1220 : 6|11:21:44.4431|| user TONY. t Transfer: 1220 : 6|11:21:44.4431||GetCurrentUser.. t Transfer: 1220 : 6|11:21:44.4431|| OAuth authenticated t Transfer: 1220 : 6|11:21:44.4431|| user TONY. t Information: 1220 : 6|11:21:44.4588||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=298441 order by m.title,m.id) a where rownum <= 9999) r where rnum >=1 order by rnum t Information: 1220 : 6|11:21:44.4900||Running version search. User: 522 Simple Search: Running Oracle search for COUNT Oracle count completed in: 4ms. Returned lines: 0 Running Oracle search. Oracle version search timing: 32ms. 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=298441 order by m.title,m.id) a where rownum <= 9999) r where rnum >=1 order by rnum t Transfer: 1220 : 11|11:21:45.5056||IsUserAuthenticated: /api/v3/title/298442/versions?_dc=1581679263698 t Transfer: 1220 : 11|11:21:45.5056||GetCurrentUser.. t Transfer: 1220 : 11|11:21:45.5056|| OAuth authenticated t Transfer: 1220 : 11|11:21:45.5056|| user TONY. t Transfer: 1220 : 11|11:21:45.5056||api user: TONY t Information: 1220 : 11|11:21:45.5056||V3Api.GetVersionsByTitleIdAdv t Information: 1220 : 11|11:21:45.5056||V3Api.SearchGeneric t Transfer: 1220 : 11|11:21:45.5056||GetCurrentUser.. t Transfer: 1220 : 11|11:21:45.5056|| OAuth authenticated t Transfer: 1220 : 11|11:21:45.5056|| user TONY. t Transfer: 1220 : 11|11:21:45.5056||GetCurrentUser.. t Transfer: 1220 : 11|11:21:45.5056|| OAuth authenticated t Transfer: 1220 : 11|11:21:45.5056|| user TONY. t Information: 1220 : 11|11:21:45.5212||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=298442 order by m.title,m.id) a where rownum <= 9999) r where rnum >=1 order by rnum t Information: 1220 : 11|11:21:45.5369||Running version search. User: 522 Simple Search: Running Oracle search for COUNT Oracle count completed in: 4ms. Returned lines: 0 Running Oracle search. Oracle version search timing: 27ms. 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=298442 order by m.title,m.id) a where rownum <= 9999) r where rnum >=1 order by rnum t Transfer: 1220 : 6|11:21:46.5994||IsUserAuthenticated: /api/v3/title/298410/versions?_dc=1581679264782 t Transfer: 1220 : 6|11:21:46.5994||GetCurrentUser.. t Transfer: 1220 : 6|11:21:46.5994|| OAuth authenticated t Transfer: 1220 : 6|11:21:46.5994|| user TONY. t Transfer: 1220 : 6|11:21:46.5994||api user: TONY t Information: 1220 : 6|11:21:46.5994||V3Api.GetVersionsByTitleIdAdv t Information: 1220 : 6|11:21:46.5994||V3Api.SearchGeneric t Transfer: 1220 : 6|11:21:46.5994||GetCurrentUser.. t Transfer: 1220 : 6|11:21:46.5994|| OAuth authenticated t Transfer: 1220 : 6|11:21:46.5994|| user TONY. t Transfer: 1220 : 6|11:21:46.5994||GetCurrentUser.. t Transfer: 1220 : 6|11:21:46.5994|| OAuth authenticated t Transfer: 1220 : 6|11:21:46.5994|| user TONY. t Information: 1220 : 6|11:21:46.5994||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=298410 order by m.title,m.id) a where rownum <= 9999) r where rnum >=1 order by rnum t Information: 1220 : 6|11:21:46.6306||Running version search. User: 522 Simple Search: Running Oracle search for COUNT Oracle count completed in: 4ms. Returned lines: 0 Running Oracle search. Oracle version search timing: 28ms. 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=298410 order by m.title,m.id) a where rownum <= 9999) r where rnum >=1 order by rnum t Transfer: 1220 : 12|11:21:48.3806||IsUserAuthenticated: /api/v3/title/298439/versions?_dc=1581679266574 t Transfer: 1220 : 12|11:21:48.3806||GetCurrentUser.. t Transfer: 1220 : 12|11:21:48.3806|| OAuth authenticated t Transfer: 1220 : 12|11:21:48.3806|| user TONY. t Transfer: 1220 : 12|11:21:48.3806||api user: TONY t Information: 1220 : 12|11:21:48.3806||V3Api.GetVersionsByTitleIdAdv t Information: 1220 : 12|11:21:48.3806||V3Api.SearchGeneric t Transfer: 1220 : 12|11:21:48.3806||GetCurrentUser.. t Transfer: 1220 : 12|11:21:48.3806|| OAuth authenticated t Transfer: 1220 : 12|11:21:48.3806|| user TONY. t Transfer: 1220 : 12|11:21:48.3806||GetCurrentUser.. t Transfer: 1220 : 12|11:21:48.3806|| OAuth authenticated t Transfer: 1220 : 12|11:21:48.3806|| user TONY. t Information: 1220 : 12|11:21:48.3806||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=298439 order by m.title,m.id) a where rownum <= 9999) r where rnum >=1 order by rnum t Information: 1220 : 12|11:21:48.3963||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=298439 order by m.title,m.id) a where rownum <= 9999) r where rnum >=1 order by rnum t Transfer: 1220 : 10|11:21:49.3962||IsUserAuthenticated: /api/v3/title/298443/versions?_dc=1581679267595 t Transfer: 1220 : 10|11:21:49.3962||GetCurrentUser.. t Transfer: 1220 : 10|11:21:49.3962|| OAuth authenticated t Transfer: 1220 : 10|11:21:49.3962|| user TONY. t Transfer: 1220 : 10|11:21:49.3962||api user: TONY t Information: 1220 : 10|11:21:49.3962||V3Api.GetVersionsByTitleIdAdv t Information: 1220 : 10|11:21:49.3962||V3Api.SearchGeneric t Transfer: 1220 : 10|11:21:49.3962||GetCurrentUser.. t Transfer: 1220 : 10|11:21:49.3962|| OAuth authenticated t Transfer: 1220 : 10|11:21:49.3962|| user TONY. t Transfer: 1220 : 10|11:21:49.3962||GetCurrentUser.. t Transfer: 1220 : 10|11:21:49.3962|| OAuth authenticated t Transfer: 1220 : 10|11:21:49.3962|| user TONY. t Information: 1220 : 10|11:21:49.4119||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 : 10|11:21:49.4744||Running version search. User: 522 Simple Search: Running Oracle search for COUNT Oracle count completed in: 4ms. Returned lines: 1 Running Oracle search. Oracle version search timing: 64ms. 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 : 10|11:21:49.6619||IsUserAuthenticated: /api/v3/version/298444/media?_dc=1581679267831 t Transfer: 1220 : 10|11:21:49.6619||GetCurrentUser.. t Transfer: 1220 : 10|11:21:49.6619|| OAuth authenticated t Transfer: 1220 : 10|11:21:49.6619|| user TONY. t Transfer: 1220 : 10|11:21:49.6619||api user: TONY t Information: 1220 : 10|11:21:49.6619||V3Api.GetMediaByVersionIdAdv t Information: 1220 : 10|11:21:49.6619||V3Api.SearchGeneric t Transfer: 1220 : 10|11:21:49.6619||GetCurrentUser.. t Transfer: 1220 : 10|11:21:49.6619|| OAuth authenticated t Transfer: 1220 : 10|11:21:49.6619|| user TONY. t Information: 1220 : 10|11:21:49.6619||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 : 10|11:21:49.7556|| timing: 00:00:00.0930800 t Verbose: 1220 : 10|11:21:49.7556||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\England v Bangladesh Match Group A.mp4 subfolder t Verbose: 1220 : 10|11:21:49.7556|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/England v Bangladesh Match Group A.mp4 t Verbose: 1220 : 10|11:21:49.7556||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/England v Bangladesh Match Group A.mp4 t Transfer: 1220 : 10|11:21:49.7556||GetCurrentUser.. t Transfer: 1220 : 10|11:21:49.7556|| OAuth authenticated t Transfer: 1220 : 10|11:21:49.7556|| user TONY. t Transfer: 1220 : 6|11:21:57.9431||IsUserAuthenticated: /api/v3/title/298445/versions?_dc=1581679276131 t Transfer: 1220 : 6|11:21:57.9431||GetCurrentUser.. t Transfer: 1220 : 6|11:21:57.9431|| OAuth authenticated t Transfer: 1220 : 6|11:21:57.9431|| user TONY. t Transfer: 1220 : 6|11:21:57.9431||api user: TONY t Information: 1220 : 6|11:21:57.9431||V3Api.GetVersionsByTitleIdAdv t Information: 1220 : 6|11:21:57.9431||V3Api.SearchGeneric t Transfer: 1220 : 6|11:21:57.9431||GetCurrentUser.. t Transfer: 1220 : 6|11:21:57.9431|| OAuth authenticated t Transfer: 1220 : 6|11:21:57.9431|| user TONY. t Transfer: 1220 : 6|11:21:57.9431||GetCurrentUser.. t Transfer: 1220 : 6|11:21:57.9431|| OAuth authenticated t Transfer: 1220 : 6|11:21:57.9431|| user TONY. t Information: 1220 : 6|11:21:57.9431||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=298445 order by m.title,m.id) a where rownum <= 9999) r where rnum >=1 order by rnum t Information: 1220 : 6|11:21:57.9744||Running version search. User: 522 Simple Search: Running Oracle search for COUNT Oracle count completed in: 4ms. Returned lines: 1 Running Oracle search. Oracle version search timing: 35ms. 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=298445 order by m.title,m.id) a where rownum <= 9999) r where rnum >=1 order by rnum t Transfer: 1220 : 26|11:21:58.1150||IsUserAuthenticated: /api/v3/version/298446/media?_dc=1581679276238 t Transfer: 1220 : 26|11:21:58.1150||GetCurrentUser.. t Transfer: 1220 : 26|11:21:58.1150|| OAuth authenticated t Transfer: 1220 : 26|11:21:58.1150|| user TONY. t Transfer: 1220 : 26|11:21:58.1150||api user: TONY t Information: 1220 : 26|11:21:58.1150||V3Api.GetMediaByVersionIdAdv t Information: 1220 : 26|11:21:58.1150||V3Api.SearchGeneric t Transfer: 1220 : 26|11:21:58.1150||GetCurrentUser.. t Transfer: 1220 : 26|11:21:58.1150|| OAuth authenticated t Transfer: 1220 : 26|11:21:58.1150|| user TONY. t Information: 1220 : 26|11:21:58.1150||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: 298446 t Information: 1220 : 26|11:21:58.1150|| count returned 0 t Transfer: 1220 : 24|11:21:59.9744||IsUserAuthenticated: /api/v3/title/298443/versions?_dc=1581679278018 t Transfer: 1220 : 24|11:21:59.9744||GetCurrentUser.. t Transfer: 1220 : 24|11:21:59.9744|| OAuth authenticated t Transfer: 1220 : 24|11:21:59.9744|| user TONY. t Transfer: 1220 : 24|11:21:59.9900||api user: TONY t Information: 1220 : 24|11:21:59.9900||V3Api.GetVersionsByTitleIdAdv t Information: 1220 : 24|11:21:59.9900||V3Api.SearchGeneric t Transfer: 1220 : 24|11:21:59.9900||GetCurrentUser.. t Transfer: 1220 : 24|11:21:59.9900|| OAuth authenticated t Transfer: 1220 : 24|11:21:59.9900|| user TONY. t Transfer: 1220 : 24|11:21:59.9900||GetCurrentUser.. t Transfer: 1220 : 24|11:21:59.9900|| OAuth authenticated t Transfer: 1220 : 24|11:21:59.9900|| user TONY. t Information: 1220 : 24|11:21:59.9900||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 : 24|11:21:59.9900||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: 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=298443 order by m.title,m.id) a where rownum <= 9999) r where rnum >=1 order by rnum t Transfer: 1220 : 6|11:22:00.1150||IsUserAuthenticated: /api/v3/version/298444/media?_dc=1581679278271 t Transfer: 1220 : 6|11:22:00.1150||GetCurrentUser.. t Transfer: 1220 : 6|11:22:00.1150|| OAuth authenticated t Transfer: 1220 : 6|11:22:00.1150|| user TONY. t Transfer: 1220 : 6|11:22:00.1150||api user: TONY t Information: 1220 : 6|11:22:00.1150||V3Api.GetMediaByVersionIdAdv t Information: 1220 : 6|11:22:00.1150||V3Api.SearchGeneric t Transfer: 1220 : 6|11:22:00.1150||GetCurrentUser.. t Transfer: 1220 : 6|11:22:00.1150|| OAuth authenticated t Transfer: 1220 : 6|11:22:00.1150|| user TONY. t Information: 1220 : 6|11:22:00.1150||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 : 6|11:22:00.1307|| timing: 00:00:00.0226763 t Verbose: 1220 : 6|11:22:00.1307||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\England v Bangladesh Match Group A.mp4 subfolder t Verbose: 1220 : 6|11:22:00.1307|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/England v Bangladesh Match Group A.mp4 t Verbose: 1220 : 6|11:22:00.1307||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/England v Bangladesh Match Group A.mp4 t Transfer: 1220 : 6|11:22:00.1307||GetCurrentUser.. t Transfer: 1220 : 6|11:22:00.1307|| OAuth authenticated t Transfer: 1220 : 6|11:22:00.1307|| user TONY. t Transfer: 1220 : 39|11:25:25.4962||IsUserAuthenticated: /api/user-group-preferences?globals=htmlplayerhotkeys,audioOnFrameForward&_dc=1581679483483 t Transfer: 1220 : 39|11:25:25.4962||GetCurrentUser.. t Transfer: 1220 : 39|11:25:25.4962|| OAuth authenticated t Transfer: 1220 : 39|11:25:25.4962|| user TONY. t Transfer: 1220 : 39|11:25:25.4962||api user: TONY t Information: 1220 : 39|11:25:25.4962||V3Api.GetUserSettings t Transfer: 1220 : 39|11:25:25.4962||GetCurrentUser.. t Transfer: 1220 : 39|11:25:25.4962|| OAuth authenticated t Transfer: 1220 : 39|11:25:25.4962|| user TONY. t Transfer: 1220 : 37|11:25:43.3555||IsUserAuthenticated: /api/v3/media-details/298524?_dc=1581679501384 t Transfer: 1220 : 37|11:25:43.3555||GetCurrentUser.. t Transfer: 1220 : 37|11:25:43.3555|| OAuth authenticated t Transfer: 1220 : 37|11:25:43.3555|| user TONY. t Transfer: 1220 : 37|11:25:43.3555||api user: TONY t Transfer: 1220 : 37|11:25:43.3555||GetCurrentUser.. t Transfer: 1220 : 37|11:25:43.3555|| OAuth authenticated t Transfer: 1220 : 37|11:25:43.3555|| user TONY. t Information: 1220 : 6|11:25:43.7462||TM_MIS. LoadSubtitles for ID: 298524 t Information: 1220 : 6|11:25:43.7462||TM_MIS. LoadSubtitles for ID: 298524. 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=298444' t Information: 1220 : 6|11:25:43.7618||TM_MIS. LoadSubtitles for ID: 298524 found no subtitles. t Verbose: 1220 : 37|11:25:44.0431||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\England v Bangladesh Match Group A.mp4 subfolder t Verbose: 1220 : 37|11:25:44.0431|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/England v Bangladesh Match Group A.mp4 t Verbose: 1220 : 37|11:25:44.0431||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/England v Bangladesh Match Group A.mp4 t Transfer: 1220 : 37|11:25:44.0431||GetCurrentUser.. t Transfer: 1220 : 37|11:25:44.0431|| OAuth authenticated t Transfer: 1220 : 37|11:25:44.0431|| user TONY. t Transfer: 1220 : 6|11:25:44.2774||IsUserAuthenticated: /api/v3/detailsview/MediaDetails/5?lang=en-GB&_dc=1581679502335 t Transfer: 1220 : 6|11:25:44.2774||GetCurrentUser.. t Transfer: 1220 : 6|11:25:44.2774|| OAuth authenticated t Transfer: 1220 : 6|11:25:44.2774|| user TONY. t Transfer: 1220 : 6|11:25:44.2774||api user: TONY t Transfer: 1220 : 42|11:25:44.4024||IsUserAuthenticated: /api/v3/media-captions/298524?_dc=1581679502584 t Transfer: 1220 : 42|11:25:44.4024||GetCurrentUser.. t Transfer: 1220 : 42|11:25:44.4024|| OAuth authenticated t Transfer: 1220 : 42|11:25:44.4024|| user TONY. t Transfer: 1220 : 42|11:25:44.4024||api user: TONY t Transfer: 1220 : 35|11:25:44.4649||IsUserAuthenticated: /api/v3/mediavideo/298524?info=smudge,scene,audiovolume&_dc=1581679502654 t Transfer: 1220 : 35|11:25:44.4649||GetCurrentUser.. t Transfer: 1220 : 35|11:25:44.4649|| OAuth authenticated t Transfer: 1220 : 35|11:25:44.4649|| user TONY. t Transfer: 1220 : 35|11:25:44.4649||api user: TONY t Verbose: 1220 : 35|11:25:44.4806||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\England v Bangladesh Match Group A.mp4 subfolder t Verbose: 1220 : 35|11:25:44.4806|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/England v Bangladesh Match Group A.mp4 t Verbose: 1220 : 35|11:25:44.4806||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/England v Bangladesh Match Group A.mp4 t Transfer: 1220 : 35|11:25:44.4806||GetCurrentUser.. t Transfer: 1220 : 35|11:25:44.4806|| OAuth authenticated t Transfer: 1220 : 35|11:25:44.4806|| user TONY. t Transfer: 1220 : 32|11:25:44.6993||IsUserAuthenticated: /api/lookups/FriendlyNames?_dc=1581679502866 t Transfer: 1220 : 32|11:25:44.6993||GetCurrentUser.. t Transfer: 1220 : 32|11:25:44.6993|| OAuth authenticated t Transfer: 1220 : 32|11:25:44.6993|| user TONY. t Transfer: 1220 : 32|11:25:44.6993||api user: TONY t Transfer: 1220 : 34|11:25:44.7305||IsUserAuthenticated: /api/user-group-preferences?globals=htmlplayerhotkeys,audioOnFrameForward&_dc=1581679502880 t Transfer: 1220 : 34|11:25:44.7305||GetCurrentUser.. t Transfer: 1220 : 34|11:25:44.7305|| OAuth authenticated t Transfer: 1220 : 34|11:25:44.7305|| user TONY. t Transfer: 1220 : 34|11:25:44.7305||api user: TONY t Information: 1220 : 34|11:25:44.7305||V3Api.GetUserSettings t Transfer: 1220 : 34|11:25:44.7305||GetCurrentUser.. t Transfer: 1220 : 34|11:25:44.7305|| OAuth authenticated t Transfer: 1220 : 34|11:25:44.7305|| user TONY. t Transfer: 1220 : 25|11:25:45.0899||IsUserAuthenticated: /api/v3/ai-tags/298524?_dc=1581679503213 t Transfer: 1220 : 25|11:25:45.0899||GetCurrentUser.. t Transfer: 1220 : 25|11:25:45.0899|| OAuth authenticated t Transfer: 1220 : 25|11:25:45.0899|| user TONY. t Transfer: 1220 : 25|11:25:45.0899||api user: TONY t Information: 1220 : 25|11:25:45.0899||V3Api.GetMediaAiTags t Transfer: 1220 : 42|11:25:45.1680||IsUserAuthenticated: /api/v3/mediavideo/298524?info=smudge&_dc=1581679503217 t Transfer: 1220 : 42|11:25:45.1680||GetCurrentUser.. t Transfer: 1220 : 42|11:25:45.1680|| OAuth authenticated t Transfer: 1220 : 42|11:25:45.1680|| user TONY. t Transfer: 1220 : 42|11:25:45.1680||api user: TONY t Verbose: 1220 : 42|11:25:45.1680||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\England v Bangladesh Match Group A.mp4 subfolder t Verbose: 1220 : 42|11:25:45.1680|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/England v Bangladesh Match Group A.mp4 t Verbose: 1220 : 42|11:25:45.1680||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/England v Bangladesh Match Group A.mp4 t Transfer: 1220 : 42|11:25:45.1680||GetCurrentUser.. t Transfer: 1220 : 42|11:25:45.1680|| OAuth authenticated t Transfer: 1220 : 42|11:25:45.1680|| user TONY. t Information: 1220 : 34|11:25:55.2774||GetAppInfo t Information: 1220 : 34|11:25:55.2774|| db: TMDDEMO install mode: auth types: Native, PublicApiKey t Information: 1220 : 87|11:46:55.0117||OrabitWatcherBasic. Disposing. t Information: 1220 : 87|11:46:55.0117||OrabitWatcherBasic. Disposed. t Information: 1220 : 87|11:46:55.0117||========================================================================== t Information: 1220 : 87|11:46:55.0117||IMFX CORE SERVER APPLICATION END. t Information: 1220 : 2|11:46:56.2305||OrabitWatcherBasic disposing.. t Information: 1220 : 2|11:46:56.2305||OrabitWatcherBasic disposed.