t Information: 1220 : 1|11:58:36.7888||Get Configuration Values: t Information: 1220 : 1|11:58:36.7888|| AdminPassEnc, default: , value: ffqjrn0leKv4Lj2YJHe2dw==. t Information: 1220 : 1|11:58:36.7888|| EncryptedPasswords, default: false, value: true. t Information: 1220 : 1|11:58:36.7888|| OraConnectionString, default: , value: Server=TECHM;User Id=imfx;Password=;Unicode=true;. t Information: 1220 : 1|11:58:36.7888|| SecondTimezone, default: , value: . t Information: 1220 : 1|11:58:36.7888|| UseActiveDirectoryAuth, default: false, value: false. t Information: 1220 : 1|11:58:36.7888|| ReportingServiceUrl, default: , value: http://localhost:92/ReportingService.svc. t Information: 1220 : 1|11:58:36.7888|| ReportsPath, default: , value: . t Information: 1220 : 1|11:58:36.7888|| ReportsURL, default: , value: . t Information: 1220 : 1|11:58:36.7888|| TapeServiceUrl, default: , value: . t Information: 1220 : 1|11:58:36.7888|| GatekeeperUrl, default: , value: . t Information: 1220 : 1|11:58:36.7888|| ValuationUrl, default: , value: . t Information: 1220 : 1|11:58:36.7888|| QueueManagerDelay, default: 30, value: 30. t Information: 1220 : 1|11:58:36.7888|| QueueManagerFullRefresh, default: 90, value: 90. t Information: 1220 : 1|11:58:36.7888|| AudioLoopDuration, default: 0, value: 150. t Information: 1220 : 1|11:58:36.7888|| AudioLoopsCount, default: 0, value: 0. t Information: 1220 : 1|11:58:36.7888|| PlayerFakeStep, default: 500, value: 500. t Information: 1220 : 1|11:58:36.7888|| PlayerForceRatio, default: 0, value: 1. t Information: 1220 : 1|11:58:36.7888|| CheckVersionsInProd, default: false, value: True. t Information: 1220 : 1|11:58:36.7888|| MaxResults, default: 3000, value: 10000. t Information: 1220 : 1|11:58:36.7888|| NetworkRestriction, default: false, value: True. t Information: 1220 : 1|11:58:36.7888|| TEReportID, default: 0, value: 0. t Information: 1220 : 1|11:58:36.7888|| ClosedCaptionsCache, default: , value: C:\inetpub\wwwroot\imfxcore\timedtextcache\. t Information: 1220 : 1|11:58:36.7888|| ClosedCaptionsStorage, default: , value: c:\Mediaflex\subs. t Information: 1220 : 1|11:58:36.7888|| TimeCodeFormat, default: , value: pal. t Information: 1220 : 1|11:58:36.7888|| RceMediaPath, default: , value: C:\edl\. t Information: 1220 : 1|11:58:36.7888|| RceMediaPath, default: , value: C:\edl\. t Information: 1220 : 1|11:58:36.7888|| RceCsmOutputPath, default: , value: C:\Inetpub\wwwroot\csm\. t Information: 1220 : 1|11:58:36.7888|| RceCsmUrl, default: , value: http://localhost/csm/. t Information: 1220 : 1|11:58:36.7888|| RceMediaSelection, default: , value: miLinkIdMatch. t Information: 1220 : 1|11:58:36.7888|| RequestBrowseJobPresetName, default: , value: . t Information: 1220 : 1|11:58:36.7888|| DontExtendDuration, default: false, value: False. t Information: 1220 : 1|11:58:36.7888|| V3ConfigUrl, default: , value: . t Information: 1220 : 1|11:58:36.7888|| ApiServer, default: , value: http://192.168.120.10:85. t Information: 1220 : 1|11:58:36.7888|| StopWords, default: , value: . t Information: 1220 : 1|11:58:36.7888|| MisrTxFormat, default: G, value: G. t Information: 1220 : 1|11:58:36.7888|| ThumbnailServer, default: , value: . t Information: 1220 : 1|11:58:36.7888|| LocationFilter, default: , value: . t Information: 1220 : 1|11:58:36.7888|| SvUtilServiceUrl, default: , value: . t Information: 1220 : 1|11:58:36.7888|| SolrConnection, default: , value: http://192.168.120.14:8983/solr. t Information: 1220 : 1|11:58:36.7888|| UseIndexServerSearch, default: false, value: True. t Information: 1220 : 1|11:58:36.7888|| SolrIndexVersion, default: 1, value: 6. t Information: 1220 : 1|11:58:36.7888|| SolrConnection, default: , value: http://192.168.120.14:8983/solr. t Information: 1220 : 1|11:58:36.7888|| FacetsGroups, default: , value: owners,season_id, series_id,version_key,item_type,media_type,media_format,episode_number. t Information: 1220 : 1|11:58:36.7888|| FacetsGroupsVersion, default: , value: owners,season_id, series_id,version_key,episode_number. t Information: 1220 : 1|11:58:36.7888|| FacetsGroupsChameleon, default: , value: season_id, series_id,genre,prod_year,version_key. t Information: 1220 : 1|11:58:36.7888|| PreviewPreset, default: , value: . t Information: 1220 : 1|11:58:36.7888|| DevMode, default: false, value: false. t Information: 1220 : 1|11:58:36.7888|| DisableSysMan, default: false, value: false. t Information: 1220 : 1|11:58:36.7888|| TimeCodeFormat, default: , value: pal. t Information: 1220 : 1|11:58:36.7888|| FileCatalystStorageDevice, default: , value: . t Information: 1220 : 1|11:58:36.7888|| UseResponsibilityTracking, default: true, value: True. t Information: 1220 : 1|11:58:36.7888|| SubtitleDeviceFilter, default: , value: . t Information: 1220 : 1|11:58:36.7888|| SystemMonitorNamedPipe, default: , value: . t Information: 1220 : 1|11:58:36.7888|| OracleMonitorEnable, default: false, value: False. t Information: 1220 : 1|11:58:36.7888|| ArcApiHost, default: , value: . t Information: 1220 : 1|11:58:36.7888|| RabbitMqUrl, default: , value: amqp://192.168.120.14:5672. t Information: 1220 : 1|11:58:36.7888|| SolrTimedTextSearch, default: false, value: false. t Information: 1220 : 1|11:58:36.8044|| ProductionDurationUsageID, default: 1, value: 1. t Information: 1220 : 1|11:58:37.0857||GetStreamServers.. t Information: 1220 : 1|11:58:37.7887|| https://demo.tmd.tv/CBR Video/ |CBR Video| False t Information: 1220 : 1|11:58:37.7887|| https://demo.tmd.tv/CBR Images/ |CBR Images| False t Information: 1220 : 1|11:58:37.7887|| https://demo.tmd.tv/CBR Audio/ |CBR Audio| False t Information: 1220 : 1|11:58:37.7887|| https://demo.tmd.tv/Temp Upload/ |TEMP_UPLOAD| False t Information: 1220 : 1|11:58:37.7887|| http://localhost:82/images/ |IMAGES| False t Information: 1220 : 1|11:58:37.7887|| http://192.168.91.73/smoothcloud/ |SMOOTH_CLOUD| False t Information: 1220 : 1|11:58:37.7887|| http://192.168.91.73/cloudstore/ |CLOUD_STORE| False t Information: 1220 : 1|11:58:37.7887|| http://192.168.91.73/editsystemin/ |EDIT_SYSTEM_IN| False t Information: 1220 : 1|11:58:37.7887|| http://192.168.91.27:89/APPLEPROXY/ |APPLE_PROXY| False t Information: 1220 : 1|11:58:37.7887|| http://localhost:82/video/ |FILESTORE_VIDEO| False t Information: 1220 : 1|11:58:37.7887|| https://imfxv3tm.tmd.tv/streaming/ |Streaming| False t Information: 1220 : 1|11:58:37.7887|| https://imfxv3tm.tmd.tv/VideoServer/ |Video| False t Information: 1220 : 1|11:58:37.7887|| https://imfxv3tm.tmd.tv/AdobeIn/ |Adobe Premiere Pro In| False t Information: 1220 : 1|11:58:37.7887|| https://imfxv3tm.tmd.tv/AudioServer/ |Audio| False t Information: 1220 : 1|11:58:37.7887|| https://imfxv3tm.tmd.tv/ImageServer/ |Image| False t Information: 1220 : 1|11:58:37.7887|| https://imfxv3tm.tmd.tv/DocsServer/ |Docs| False t Information: 1220 : 1|11:58:37.7887|| https://imfxv3tm.tmd.tv/AmazonLabs/ |TEST HOUSE| False t Information: 1220 : 1|11:58:37.7887|| SolrConnectionUms, default: http://192.168.120.14:8983/solr, value: http://192.168.120.14:8983/solr. t Information: 1220 : 1|11:58:37.7887|| ApiLog, default: false, value: false. t Information: 1220 : 1|11:58:37.7887|| EmbeddedRceUrl, default: , value: . t Information: 1220 : 1|11:58:37.7887|| InstallMode, default: , value: . t Information: 1220 : 1|11:58:37.7887|| SamlRequestAddress, default: , value: . t Information: 1220 : 1|11:58:37.7887|| SamlTrustedIssuer, default: , value: . t Information: 1220 : 1|11:58:37.7887|| SamlLoginRedirect, default: , value: . t Information: 1220 : 1|11:58:37.7887|| NaturalLangSearch, default: false, value: True. t Information: 1220 : 1|11:58:37.7887|| OktaLoginField, default: , value: . t Information: 1220 : 1|11:58:37.7887|| AuthenticationTypes, default: , value: Native,PublicApiKey. t Information: 1220 : 1|11:58:37.7887||OrabitWatcherBasic. Initialize. t Information: 1220 : 1|11:58:37.8669||FillDictionaryCache. t Information: 1220 : 1|11:58:41.2575||GetSupportedOperators t Information: 1220 : 13|11:58:41.5545||CacheTechReports. t Information: 1220 : 1|11:58:41.6638||& Cache update. Server (global) filled with timestamp 11:12:41.6482054. types null t Information: 1220 : 1|11:58:41.6638||InitializeFromDatabase. 'Server=TECHM;User Id=imfx;password=..;Unicode=true;' direct False, home , timeout 15 t Information: 1220 : 1|11:58:41.6638||FillDictionaryCache. t Information: 1220 : 1|11:58:41.6794||& Cache update. Server (global) filled with timestamp 11:12:41.6794224. types FriendlyNames, DatabaseSearchFieldData t Information: 1220 : 1|11:58:42.0232||========================================================================== t Information: 1220 : 1|11:58:42.0232||IMFX CORE SERVER APPLICATION START. t Information: 1220 : 1|11:58:42.0232||DLL VERSION: 2.5.0.2322. t Information: 1220 : 12|11:58:42.0232|| UmsDev, default: False, value: False. t Information: 1220 : 1|11:58:42.1013|| ApiLog, default: false, value: false. t Information: 1220 : 11|11:58:42.8044||OrabitWatcherBasic trying to connect.. t Information: 1220 : 11|11:58:42.8826||OrabitWatcherBasic connected. t Information: 1220 : 11|11:58:42.8982||OrabitWatcherBasic queue created tmd.cfg.in.1946cddb-83e7-44e4-936d-57678fe57649 t Information: 1220 : 14|11:58:43.3825||GetAppInfo t Information: 1220 : 14|11:58:43.3825|| db: TMDDEMO install mode: auth types: Native, PublicApiKey t Information: 1220 : 12|11:58:59.9919||Oauth validating.. t Verbose: 1220 : 12|11:58:59.9919||GrantResourceOwnerCredentials. t Verbose: 1220 : 12|11:58:59.9919||LoginUser. tony, login type OAuth, encrypt password True t Information: 1220 : 12|11:59:00.0075||TryLoginUser. tony, login type OAuth, check password True, check hash False, encrypt password True, load user data True t Information: 1220 : 12|11:59:00.1794||InitialiseLogin t Information: 1220 : 12|11:59:00.2106|| oauth token 00000000-0000-0000-0000-000000000000 t Information: 1220 : 12|11:59:00.2106||TryLoginUser. Logged in.. t Information: 1220 : 12|11:59:00.2575||GetPasswordPolicy. WARNING: Policy not found for system Imediaflex. Validation disabled. t Verbose: 1220 : 12|11:59:00.2575||LoginUser. Adding history. User Id 522, result TONY, host t Verbose: 1220 : 12|11:59:00.2575||GrantResourceOwnerCredentials. Try login finished. Logged: True t Transfer: 1220 : 12|11:59:00.3356||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=1575979140355 t Transfer: 1220 : 12|11:59:00.3356||GetCurrentUser.. t Transfer: 1220 : 12|11:59:00.3356|| OAuth authenticated t Transfer: 1220 : 12|11:59:00.3356|| user TONY. t Transfer: 1220 : 12|11:59:00.3356||api user: TONY t Information: 1220 : 12|11:59:00.3669||V3Api.GetUserSettings t Transfer: 1220 : 12|11:59:00.3669||GetCurrentUser.. t Transfer: 1220 : 12|11:59:00.3669|| OAuth authenticated t Transfer: 1220 : 12|11:59:00.3669|| user TONY. t Transfer: 1220 : 13|11:59:00.4294||IsUserAuthenticated: /api/user-preferences?keys=personal_settings;basket;default_page;color_schema;media.basket.data;defaultSearch&_dc=1575979140461 t Transfer: 1220 : 13|11:59:00.4450||GetCurrentUser.. t Transfer: 1220 : 13|11:59:00.4450|| OAuth authenticated t Transfer: 1220 : 13|11:59:00.4450|| user TONY. t Transfer: 1220 : 13|11:59:00.4450||api user: TONY t Transfer: 1220 : 12|11:59:00.4450||IsUserAuthenticated: /api/lookups/PgmStatus?_dc=1575979140464 t Transfer: 1220 : 12|11:59:00.4450||GetCurrentUser.. t Transfer: 1220 : 12|11:59:00.4450|| OAuth authenticated t Transfer: 1220 : 12|11:59:00.4450|| user TONY. t Transfer: 1220 : 12|11:59:00.4450||api user: TONY t Information: 1220 : 13|11:59:00.4450||GetUserDataByKeys: personal_settings;basket;default_page;color_schema;media.basket.data;defaultSearch t Transfer: 1220 : 13|11:59:00.4450||GetCurrentUser.. t Transfer: 1220 : 13|11:59:00.4450|| OAuth authenticated t Transfer: 1220 : 13|11:59:00.4450|| user TONY. t Transfer: 1220 : 11|11:59:00.4607||IsUserAuthenticated: /api/lookups/MediaStatus?_dc=1575979140463 t Transfer: 1220 : 11|11:59:00.4607||GetCurrentUser.. t Transfer: 1220 : 11|11:59:00.4607|| OAuth authenticated t Transfer: 1220 : 11|11:59:00.4607|| user TONY. t Transfer: 1220 : 11|11:59:00.4607||api user: TONY t Information: 1220 : 5|11:59:00.5076||GetUserProfile. Id: 0 t Transfer: 1220 : 5|11:59:00.5076||GetCurrentUser.. t Transfer: 1220 : 5|11:59:00.5076|| OAuth authenticated t Transfer: 1220 : 5|11:59:00.5076|| user TONY. t Transfer: 1220 : 14|11:59:00.9450||IsUserAuthenticated: /api/settings/user/defaultSearch?_dc=1575979140976 t Transfer: 1220 : 14|11:59:00.9450||GetCurrentUser.. t Transfer: 1220 : 14|11:59:00.9450|| OAuth authenticated t Transfer: 1220 : 14|11:59:00.9450|| user TONY. t Transfer: 1220 : 14|11:59:00.9450||api user: TONY t Information: 1220 : 14|11:59:00.9450||V3Api.GetUserSettings t Transfer: 1220 : 14|11:59:00.9450||GetCurrentUser.. t Transfer: 1220 : 14|11:59:00.9450|| OAuth authenticated t Transfer: 1220 : 14|11:59:00.9450|| user TONY. t Transfer: 1220 : 13|11:59:00.9607||IsUserAuthenticated: /api/settings/user/startSearch?_dc=1575979140978 t Transfer: 1220 : 13|11:59:00.9607||GetCurrentUser.. t Transfer: 1220 : 13|11:59:00.9607|| OAuth authenticated t Transfer: 1220 : 13|11:59:00.9607|| user TONY. t Transfer: 1220 : 13|11:59:00.9607||api user: TONY t Information: 1220 : 13|11:59:00.9607||V3Api.GetUserSettings t Transfer: 1220 : 13|11:59:00.9607||GetCurrentUser.. t Transfer: 1220 : 13|11:59:00.9607|| OAuth authenticated t Transfer: 1220 : 13|11:59:00.9607|| user TONY. t Transfer: 1220 : 13|11:59:01.0076||IsUserAuthenticated: /api/user-preferences?keys=consumer.recent.data&_dc=1575979141051 t Transfer: 1220 : 13|11:59:01.0076||GetCurrentUser.. t Transfer: 1220 : 13|11:59:01.0076|| OAuth authenticated t Transfer: 1220 : 13|11:59:01.0076|| user TONY. t Transfer: 1220 : 13|11:59:01.0076||api user: TONY t Information: 1220 : 13|11:59:01.0076||GetUserDataByKeys: consumer.recent.data t Transfer: 1220 : 13|11:59:01.0076||GetCurrentUser.. t Transfer: 1220 : 13|11:59:01.0076|| OAuth authenticated t Transfer: 1220 : 13|11:59:01.0076|| user TONY. t Transfer: 1220 : 12|11:59:01.0232||IsUserAuthenticated: /api/user-preferences?keys=adv.recent.searches.consumer&_dc=1575979141063 t Transfer: 1220 : 12|11:59:01.0232||GetCurrentUser.. t Transfer: 1220 : 12|11:59:01.0232|| OAuth authenticated t Transfer: 1220 : 12|11:59:01.0232|| user TONY. t Transfer: 1220 : 12|11:59:01.0232||api user: TONY t Information: 1220 : 12|11:59:01.0232||GetUserDataByKeys: adv.recent.searches.consumer t Transfer: 1220 : 12|11:59:01.0232||GetCurrentUser.. t Transfer: 1220 : 12|11:59:01.0232|| OAuth authenticated t Transfer: 1220 : 12|11:59:01.0232|| user TONY. t Transfer: 1220 : 11|11:59:07.0233||IsUserAuthenticated: /api/view/searches/Media?_dc=1575979146917 t Transfer: 1220 : 11|11:59:07.0233||GetCurrentUser.. t Transfer: 1220 : 11|11:59:07.0233|| OAuth authenticated t Transfer: 1220 : 11|11:59:07.0233|| user TONY. t Transfer: 1220 : 11|11:59:07.0233||api user: TONY t Information: 1220 : 11|11:59:07.0233||GetSavedSearchNames. search type Media. t Transfer: 1220 : 11|11:59:07.0233||GetCurrentUser.. t Transfer: 1220 : 11|11:59:07.0233|| OAuth authenticated t Transfer: 1220 : 11|11:59:07.0233|| user TONY. t Transfer: 1220 : 12|11:59:07.0233||IsUserAuthenticated: /api/view/searchinfo/Media?_dc=1575979146889 t Transfer: 1220 : 12|11:59:07.0233||GetCurrentUser.. t Transfer: 1220 : 12|11:59:07.0233|| OAuth authenticated t Transfer: 1220 : 12|11:59:07.0233|| user TONY. t Transfer: 1220 : 12|11:59:07.0233||api user: TONY t Transfer: 1220 : 14|11:59:07.0233||IsUserAuthenticated: /api/lookups/SearchSupportedOperators?_dc=1575979146890 t Transfer: 1220 : 14|11:59:07.0233||GetCurrentUser.. t Transfer: 1220 : 14|11:59:07.0233|| OAuth authenticated t Transfer: 1220 : 14|11:59:07.0233|| user TONY. t Transfer: 1220 : 14|11:59:07.0233||api user: TONY t Transfer: 1220 : 5|11:59:07.0233||IsUserAuthenticated: /api/settings/user/searchLayoutConfig?_dc=1575979146895 t Transfer: 1220 : 5|11:59:07.0233||GetCurrentUser.. t Transfer: 1220 : 5|11:59:07.0233|| OAuth authenticated t Transfer: 1220 : 5|11:59:07.0233|| user TONY. t Transfer: 1220 : 5|11:59:07.0233||api user: TONY t Information: 1220 : 5|11:59:07.0233||V3Api.GetUserSettings t Transfer: 1220 : 5|11:59:07.0233||GetCurrentUser.. t Transfer: 1220 : 5|11:59:07.0233|| OAuth authenticated t Transfer: 1220 : 5|11:59:07.0233|| user TONY. t Information: 1220 : 12|11:59:07.0233||GetAdvSearchColumns. search type Media grid . t Transfer: 1220 : 14|11:59:07.0390||IsUserAuthenticated: /api/user-preferences?keys=adv.recent.searches.media&_dc=1575979146891 t Transfer: 1220 : 14|11:59:07.0390||GetCurrentUser.. t Transfer: 1220 : 14|11:59:07.0390|| OAuth authenticated t Transfer: 1220 : 14|11:59:07.0390|| user TONY. t Transfer: 1220 : 14|11:59:07.0390||api user: TONY t Information: 1220 : 14|11:59:07.0390||GetUserDataByKeys: adv.recent.searches.media t Transfer: 1220 : 14|11:59:07.0390||GetCurrentUser.. t Transfer: 1220 : 14|11:59:07.0390|| OAuth authenticated t Transfer: 1220 : 14|11:59:07.0390|| user TONY. t Transfer: 1220 : 5|11:59:07.0390||IsUserAuthenticated: /api/view/info/MediaGrid?lang=en-US&_dc=1575979146907 t Transfer: 1220 : 5|11:59:07.0390||GetCurrentUser.. t Transfer: 1220 : 5|11:59:07.0390|| OAuth authenticated t Transfer: 1220 : 5|11:59:07.0390|| user TONY. t Transfer: 1220 : 5|11:59:07.0390||api user: TONY t Information: 1220 : 5|11:59:07.0390||GetGridViewBuilder. builder type MediaGrid. t Transfer: 1220 : 5|11:59:07.0546||GetCurrentUser.. t Transfer: 1220 : 5|11:59:07.0546|| OAuth authenticated t Transfer: 1220 : 5|11:59:07.0546|| user TONY. t Information: 1220 : 5|11:59:07.0546||UserGridView. LoadView. ID 1282, Name Default. t Transfer: 1220 : 5|11:59:07.0546||GetCurrentUser.. t Transfer: 1220 : 5|11:59:07.0546|| OAuth authenticated t Transfer: 1220 : 5|11:59:07.0546|| user TONY. t Transfer: 1220 : 5|11:59:07.0546||GetCurrentUser.. t Transfer: 1220 : 5|11:59:07.0546|| OAuth authenticated t Transfer: 1220 : 5|11:59:07.0546|| user TONY. t Transfer: 1220 : 11|11:59:09.8983||IsUserAuthenticated: /api/SearchSuggestion/?_dc=1575979149931 t Transfer: 1220 : 11|11:59:09.8983||GetCurrentUser.. t Transfer: 1220 : 11|11:59:09.8983|| OAuth authenticated t Transfer: 1220 : 11|11:59:09.8983|| user TONY. t Transfer: 1220 : 11|11:59:09.8983||api user: TONY t Transfer: 1220 : 11|11:59:09.9764||GetCurrentUser.. t Transfer: 1220 : 11|11:59:09.9764|| OAuth authenticated t Transfer: 1220 : 11|11:59:09.9764|| user TONY. t Transfer: 1220 : 13|11:59:10.9452||IsUserAuthenticated: /api/search/Media?_dc=1575979150992 t Transfer: 1220 : 13|11:59:10.9452||GetCurrentUser.. t Transfer: 1220 : 13|11:59:10.9452|| OAuth authenticated t Transfer: 1220 : 13|11:59:10.9452|| user TONY. t Transfer: 1220 : 13|11:59:10.9452||api user: TONY t Information: 1220 : 13|11:59:10.9765||V3Api.SearchMedia t Information: 1220 : 13|11:59:11.0233||V3Api.SearchGeneric t Transfer: 1220 : 13|11:59:11.0702||GetCurrentUser.. t Transfer: 1220 : 13|11:59:11.0702|| OAuth authenticated t Transfer: 1220 : 13|11:59:11.0702|| user TONY. t Information: 1220 : 13|11:59:11.1639||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 : 13|11:59:11.2733|| timing: 00:00:00.2190227 t Verbose: 1220 : 13|11:59:11.4452||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Australia vs South Africa Match 45.mp4 subfolder t Verbose: 1220 : 13|11:59:11.4452|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Australia vs South Africa Match 45.mp4 t Verbose: 1220 : 13|11:59:11.4452||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/Australia vs South Africa Match 45.mp4 t Transfer: 1220 : 13|11:59:11.4452||GetCurrentUser.. t Transfer: 1220 : 13|11:59:11.4452|| OAuth authenticated t Transfer: 1220 : 13|11:59:11.4452|| user TONY. t Verbose: 1220 : 13|11:59:11.5390||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\England vs South Africa Match 1.mp4 subfolder t Verbose: 1220 : 13|11:59:11.5390|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/England vs South Africa Match 1.mp4 t Verbose: 1220 : 13|11:59:11.5390||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/England vs South Africa Match 1.mp4 t Transfer: 1220 : 13|11:59:11.5390||GetCurrentUser.. t Transfer: 1220 : 13|11:59:11.5390|| OAuth authenticated t Transfer: 1220 : 13|11:59:11.5390|| user TONY. t Verbose: 1220 : 13|11:59:11.5390||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\West Indies vs Pakistan Match 2.mp4 subfolder t Verbose: 1220 : 13|11:59:11.5390|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/West Indies vs Pakistan Match 2.mp4 t Verbose: 1220 : 13|11:59:11.5390||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/West Indies vs Pakistan Match 2.mp4 t Transfer: 1220 : 13|11:59:11.5390||GetCurrentUser.. t Transfer: 1220 : 13|11:59:11.5390|| OAuth authenticated t Transfer: 1220 : 13|11:59:11.5390|| user TONY. t Verbose: 1220 : 13|11:59:11.5390||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\New Zealand vs England Final.mp4 subfolder t Verbose: 1220 : 13|11:59:11.5390|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/New Zealand vs England Final.mp4 t Verbose: 1220 : 13|11:59:11.5390||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/New Zealand vs England Final.mp4 t Transfer: 1220 : 13|11:59:11.5390||GetCurrentUser.. t Transfer: 1220 : 13|11:59:11.5390|| OAuth authenticated t Transfer: 1220 : 13|11:59:11.5390|| user TONY. t Verbose: 1220 : 13|11:59:11.5390||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|11:59:11.5390|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Australia vs England Short Semi Final 2.mp4 t Verbose: 1220 : 13|11:59:11.5390||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/Australia vs England Short Semi Final 2.mp4 t Transfer: 1220 : 13|11:59:11.5390||GetCurrentUser.. t Transfer: 1220 : 13|11:59:11.5390|| OAuth authenticated t Transfer: 1220 : 13|11:59:11.5390|| user TONY. t Verbose: 1220 : 13|11:59:11.5390||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 : 13|11:59:11.5390|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/India vs New Zealand Semi Final 1.mp4 t Verbose: 1220 : 13|11:59:11.5390||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/India vs New Zealand Semi Final 1.mp4 t Transfer: 1220 : 13|11:59:11.5390||GetCurrentUser.. t Transfer: 1220 : 13|11:59:11.5390|| OAuth authenticated t Transfer: 1220 : 13|11:59:11.5390|| user TONY. t Verbose: 1220 : 13|11:59:11.5390||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\South Africa vs Bangladesh Match 5 .mp4 subfolder t Verbose: 1220 : 13|11:59:11.5390|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/South Africa vs Bangladesh Match 5 .mp4 t Verbose: 1220 : 13|11:59:11.5390||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/South Africa vs Bangladesh Match 5 .mp4 t Transfer: 1220 : 13|11:59:11.5390||GetCurrentUser.. t Transfer: 1220 : 13|11:59:11.5390|| OAuth authenticated t Transfer: 1220 : 13|11:59:11.5390|| user TONY. t Verbose: 1220 : 13|11:59:11.5546||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 : 13|11:59:11.5546|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/New Zealand vs Sri Lanka Match 3.mp4 t Verbose: 1220 : 13|11:59:11.5546||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/New Zealand vs Sri Lanka Match 3.mp4 t Transfer: 1220 : 13|11:59:11.5546||GetCurrentUser.. t Transfer: 1220 : 13|11:59:11.5546|| OAuth authenticated t Transfer: 1220 : 13|11:59:11.5546|| user TONY. t Verbose: 1220 : 13|11:59:11.5546||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Afghanistan vs Australia Match 4.mp4 subfolder t Verbose: 1220 : 13|11:59:11.5546|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Afghanistan vs Australia Match 4.mp4 t Verbose: 1220 : 13|11:59:11.5546||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/Afghanistan vs Australia Match 4.mp4 t Transfer: 1220 : 13|11:59:11.5546||GetCurrentUser.. t Transfer: 1220 : 13|11:59:11.5546|| OAuth authenticated t Transfer: 1220 : 13|11:59:11.5546|| user TONY. t Verbose: 1220 : 13|11:59:11.5546||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Bangladesh vs New Zealand Match 9.mp4 subfolder t Verbose: 1220 : 13|11:59:11.5546|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Bangladesh vs New Zealand Match 9.mp4 t Verbose: 1220 : 13|11:59:11.5546||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/Bangladesh vs New Zealand Match 9.mp4 t Transfer: 1220 : 13|11:59:11.5546||GetCurrentUser.. t Transfer: 1220 : 13|11:59:11.5546|| OAuth authenticated t Transfer: 1220 : 13|11:59:11.5546|| user TONY. t Verbose: 1220 : 13|11:59:11.5546||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Afghanistan vs Sri Lanka Match 7.mp4 subfolder t Verbose: 1220 : 13|11:59:11.5546|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Afghanistan vs Sri Lanka Match 7.mp4 t Verbose: 1220 : 13|11:59:11.5546||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/Afghanistan vs Sri Lanka Match 7.mp4 t Transfer: 1220 : 13|11:59:11.5546||GetCurrentUser.. t Transfer: 1220 : 13|11:59:11.5546|| OAuth authenticated t Transfer: 1220 : 13|11:59:11.5546|| user TONY. t Verbose: 1220 : 13|11:59:11.5546||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Australia vs West Indies Match 10.mp4 subfolder t Verbose: 1220 : 13|11:59:11.5546|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Australia vs West Indies Match 10.mp4 t Verbose: 1220 : 13|11:59:11.5546||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/Australia vs West Indies Match 10.mp4 t Transfer: 1220 : 13|11:59:11.5546||GetCurrentUser.. t Transfer: 1220 : 13|11:59:11.5546|| OAuth authenticated t Transfer: 1220 : 13|11:59:11.5546|| user TONY. t Verbose: 1220 : 13|11:59:11.5546||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\South Africa vs India Match 8.mp4 subfolder t Verbose: 1220 : 13|11:59:11.5546|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/South Africa vs India Match 8.mp4 t Verbose: 1220 : 13|11:59:11.5546||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/South Africa vs India Match 8.mp4 t Transfer: 1220 : 13|11:59:11.5546||GetCurrentUser.. t Transfer: 1220 : 13|11:59:11.5546|| OAuth authenticated t Transfer: 1220 : 13|11:59:11.5546|| user TONY. t Verbose: 1220 : 13|11:59:11.5702||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\England vs Pakistan Match 6.mp4 subfolder t Verbose: 1220 : 13|11:59:11.5702|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/England vs Pakistan Match 6.mp4 t Verbose: 1220 : 13|11:59:11.5702||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/England vs Pakistan Match 6.mp4 t Transfer: 1220 : 13|11:59:11.5702||GetCurrentUser.. t Transfer: 1220 : 13|11:59:11.5702|| OAuth authenticated t Transfer: 1220 : 13|11:59:11.5702|| user TONY. t Verbose: 1220 : 13|11:59:11.5702||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Pakistan vs Sri Lanka Match 11.mp4 subfolder t Verbose: 1220 : 13|11:59:11.5702|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Pakistan vs Sri Lanka Match 11.mp4 t Verbose: 1220 : 13|11:59:11.5702||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/Pakistan vs Sri Lanka Match 11.mp4 t Transfer: 1220 : 13|11:59:11.5702||GetCurrentUser.. t Transfer: 1220 : 13|11:59:11.5702|| OAuth authenticated t Transfer: 1220 : 13|11:59:11.5702|| user TONY. t Verbose: 1220 : 13|11:59:11.5702||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|11:59:11.5702|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/England v Bangladesh Match Group A.mp4 t Verbose: 1220 : 13|11:59:11.5702||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/England v Bangladesh Match Group A.mp4 t Transfer: 1220 : 13|11:59:11.5702||GetCurrentUser.. t Transfer: 1220 : 13|11:59:11.5702|| OAuth authenticated t Transfer: 1220 : 13|11:59:11.5702|| user TONY. t Verbose: 1220 : 13|11:59:11.5702||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\ICC 360 Cricket for Change.mp4 subfolder t Verbose: 1220 : 13|11:59:11.5702|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/ICC 360 Cricket for Change.mp4 t Verbose: 1220 : 13|11:59:11.5702||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/ICC 360 Cricket for Change.mp4 t Transfer: 1220 : 13|11:59:11.5702||GetCurrentUser.. t Transfer: 1220 : 13|11:59:11.5702|| OAuth authenticated t Transfer: 1220 : 13|11:59:11.5702|| user TONY. t Verbose: 1220 : 13|11:59:11.5702||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Scotland vs Oman 5th Place Play Off.mp4 subfolder t Verbose: 1220 : 13|11:59:11.5702|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Scotland vs Oman 5th Place Play Off.mp4 t Verbose: 1220 : 13|11:59:11.5702||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/Scotland vs Oman 5th Place Play Off.mp4 t Transfer: 1220 : 13|11:59:11.5702||GetCurrentUser.. t Transfer: 1220 : 13|11:59:11.5702|| OAuth authenticated t Transfer: 1220 : 13|11:59:11.5702|| user TONY. t Transfer: 1220 : 11|11:59:11.6483||IsUserAuthenticated: /api/user-preferences?_dc=1575979151684 t Transfer: 1220 : 11|11:59:11.6483||GetCurrentUser.. t Transfer: 1220 : 11|11:59:11.6483|| OAuth authenticated t Transfer: 1220 : 11|11:59:11.6483|| user TONY. t Transfer: 1220 : 11|11:59:11.6483||api user: TONY t Verbose: 1220 : 11|11:59:11.6483||StoreUserDataByKeys.. t Transfer: 1220 : 11|11:59:11.6483||GetCurrentUser.. t Transfer: 1220 : 11|11:59:11.6483|| OAuth authenticated t Transfer: 1220 : 11|11:59:11.6483|| user TONY. t Transfer: 1220 : 14|11:59:18.8202||IsUserAuthenticated: /api/user-group-preferences?globals=htmlplayerhotkeys,audioOnFrameForward&_dc=1575979158862 t Transfer: 1220 : 14|11:59:18.8202||GetCurrentUser.. t Transfer: 1220 : 14|11:59:18.8202|| OAuth authenticated t Transfer: 1220 : 14|11:59:18.8202|| user TONY. t Transfer: 1220 : 14|11:59:18.8202||api user: TONY t Information: 1220 : 14|11:59:18.8202||V3Api.GetUserSettings t Transfer: 1220 : 14|11:59:18.8202||GetCurrentUser.. t Transfer: 1220 : 14|11:59:18.8202|| OAuth authenticated t Transfer: 1220 : 14|11:59:18.8202|| user TONY. t Transfer: 1220 : 14|11:59:19.2733||IsUserAuthenticated: /api/user-group-preferences?globals=htmlplayerhotkeys,audioOnFrameForward&_dc=1575979159313 t Transfer: 1220 : 14|11:59:19.2733||GetCurrentUser.. t Transfer: 1220 : 14|11:59:19.2733|| OAuth authenticated t Transfer: 1220 : 14|11:59:19.2733|| user TONY. t Transfer: 1220 : 14|11:59:19.2733||api user: TONY t Information: 1220 : 14|11:59:19.2733||V3Api.GetUserSettings t Transfer: 1220 : 14|11:59:19.2733||GetCurrentUser.. t Transfer: 1220 : 14|11:59:19.2733|| OAuth authenticated t Transfer: 1220 : 14|11:59:19.2733|| user TONY. t Transfer: 1220 : 13|11:59:22.2264||IsUserAuthenticated: /api/title-details/298279?_dc=1575979162273 t Transfer: 1220 : 13|11:59:22.2264||GetCurrentUser.. t Transfer: 1220 : 13|11:59:22.2264|| OAuth authenticated t Transfer: 1220 : 13|11:59:22.2264|| user TONY. t Transfer: 1220 : 13|11:59:22.2264||api user: TONY t Transfer: 1220 : 13|11:59:22.3827||IsUserAuthenticated: /api/v3/detailsview/TitleDetails/0?lang=en-US&_dc=1575979162423 t Transfer: 1220 : 13|11:59:22.3827||GetCurrentUser.. t Transfer: 1220 : 13|11:59:22.3827|| OAuth authenticated t Transfer: 1220 : 13|11:59:22.3827|| user TONY. t Transfer: 1220 : 13|11:59:22.3827||api user: TONY t Transfer: 1220 : 12|11:59:22.5233||IsUserAuthenticated: /api/lookups/FriendlyNames?_dc=1575979162567 t Transfer: 1220 : 12|11:59:22.5233||GetCurrentUser.. t Transfer: 1220 : 12|11:59:22.5233|| OAuth authenticated t Transfer: 1220 : 12|11:59:22.5233|| user TONY. t Transfer: 1220 : 12|11:59:22.5233||api user: TONY t Transfer: 1220 : 14|11:59:22.5702||IsUserAuthenticated: /api/view/info/VersionGrid?lang=en-US&_dc=1575979162606 t Transfer: 1220 : 14|11:59:22.5702||GetCurrentUser.. t Transfer: 1220 : 14|11:59:22.5702|| OAuth authenticated t Transfer: 1220 : 14|11:59:22.5702|| user TONY. t Transfer: 1220 : 14|11:59:22.5702||api user: TONY t Information: 1220 : 14|11:59:22.5702||GetGridViewBuilder. builder type VersionGrid. t Transfer: 1220 : 14|11:59:22.5702||GetCurrentUser.. t Transfer: 1220 : 14|11:59:22.5702|| OAuth authenticated t Transfer: 1220 : 14|11:59:22.5702|| user TONY. t Information: 1220 : 14|11:59:22.5702||UserGridView. LoadView. ID -1, Name Default. t Transfer: 1220 : 14|11:59:22.5702||GetCurrentUser.. t Transfer: 1220 : 14|11:59:22.5702|| OAuth authenticated t Transfer: 1220 : 14|11:59:22.5702|| user TONY. t Transfer: 1220 : 14|11:59:22.5702||GetCurrentUser.. t Transfer: 1220 : 14|11:59:22.5702|| OAuth authenticated t Transfer: 1220 : 14|11:59:22.5702|| user TONY. t Transfer: 1220 : 13|11:59:22.5858||IsUserAuthenticated: /api/view/info/TitleTree?lang=en-US&_dc=1575979162624 t Transfer: 1220 : 13|11:59:22.5858||GetCurrentUser.. t Transfer: 1220 : 13|11:59:22.5858|| OAuth authenticated t Transfer: 1220 : 13|11:59:22.5858|| user TONY. t Transfer: 1220 : 13|11:59:22.5858||api user: TONY t Information: 1220 : 13|11:59:22.5858||GetGridViewBuilder. builder type TitleTree. t Transfer: 1220 : 13|11:59:22.5858||GetCurrentUser.. t Transfer: 1220 : 13|11:59:22.5858|| OAuth authenticated t Transfer: 1220 : 13|11:59:22.5858|| user TONY. t Information: 1220 : 13|11:59:22.5858||UserGridView. LoadView. ID 1281, Name Default. t Transfer: 1220 : 13|11:59:22.5858||GetCurrentUser.. t Transfer: 1220 : 13|11:59:22.5858|| OAuth authenticated t Transfer: 1220 : 13|11:59:22.5858|| user TONY. t Transfer: 1220 : 13|11:59:22.5858||GetCurrentUser.. t Transfer: 1220 : 13|11:59:22.5858|| OAuth authenticated t Transfer: 1220 : 13|11:59:22.5858|| user TONY. t Transfer: 1220 : 14|11:59:22.6171||IsUserAuthenticated: /api/search/title?_dc=1575979162650 t Transfer: 1220 : 14|11:59:22.6171||GetCurrentUser.. t Transfer: 1220 : 14|11:59:22.6171|| OAuth authenticated t Transfer: 1220 : 14|11:59:22.6171|| user TONY. t Transfer: 1220 : 14|11:59:22.6171||api user: TONY t Information: 1220 : 14|11:59:22.6171||V3Api.SearchTitles t Information: 1220 : 14|11:59:22.6171||V3Api.SearchGeneric t Transfer: 1220 : 14|11:59:22.6171||GetCurrentUser.. t Transfer: 1220 : 14|11:59:22.6171|| OAuth authenticated t Transfer: 1220 : 14|11:59:22.6171|| user TONY. t Transfer: 1220 : 14|11:59:22.6327||GetCurrentUser.. t Transfer: 1220 : 14|11:59:22.6327|| OAuth authenticated t Transfer: 1220 : 14|11:59:22.6327|| user TONY. t Information: 1220 : 14|11:59:22.6327||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 (INSTR(OWNERS,'|ATP|')>0 OR INSTR(OWNERS,'|ICCCTY|')>0 OR INSTR(OWNERS,'|ICCCWC|')>0 OR INSTR(OWNERS,'|ICCCWL2|')>0 OR INSTR(OWNERS,'|ICCICC|')>0 OR INSTR(OWNERS,'|ICCTWT|')>0 OR INSTR(OWNERS,'|ICCU19CWC|')>0 OR INSTR(OWNERS,'|ICCWCCL|')>0 OR INSTR(OWNERS,'|ICCWCL|')>0 OR INSTR(OWNERS,'|ICCWCP|')>0 OR INSTR(OWNERS,'|ICCWTC|')>0 OR INSTR(OWNERS,'|ICCWTT|')>0 OR INSTR(OWNERS,'|ICCWWC|')>0 OR INSTR(OWNERS,'|OSP|')>0 OR INSTR(OWNERS,'|SFP1|')>0 OR INSTR(OWNERS,'|SFP2|')>0 OR INSTR(OWNERS,'|TMD|')>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 : 11|11:59:22.6483||IsUserAuthenticated: /api/search/title?_dc=1575979162687 t Transfer: 1220 : 11|11:59:22.6483||GetCurrentUser.. t Transfer: 1220 : 11|11:59:22.6483|| OAuth authenticated t Transfer: 1220 : 11|11:59:22.6483|| user TONY. t Transfer: 1220 : 11|11:59:22.6483||api user: TONY t Information: 1220 : 11|11:59:22.6483||V3Api.SearchTitles t Information: 1220 : 11|11:59:22.6483||V3Api.SearchGeneric t Transfer: 1220 : 11|11:59:22.6483||GetCurrentUser.. t Transfer: 1220 : 11|11:59:22.6483|| OAuth authenticated t Transfer: 1220 : 11|11:59:22.6483|| user TONY. t Transfer: 1220 : 11|11:59:22.6483||GetCurrentUser.. t Transfer: 1220 : 11|11:59:22.6483|| OAuth authenticated t Transfer: 1220 : 11|11:59:22.6483|| user TONY. t Information: 1220 : 11|11:59:22.6483||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 (INSTR(OWNERS,'|ATP|')>0 OR INSTR(OWNERS,'|ICCCTY|')>0 OR INSTR(OWNERS,'|ICCCWC|')>0 OR INSTR(OWNERS,'|ICCCWL2|')>0 OR INSTR(OWNERS,'|ICCICC|')>0 OR INSTR(OWNERS,'|ICCTWT|')>0 OR INSTR(OWNERS,'|ICCU19CWC|')>0 OR INSTR(OWNERS,'|ICCWCCL|')>0 OR INSTR(OWNERS,'|ICCWCL|')>0 OR INSTR(OWNERS,'|ICCWCP|')>0 OR INSTR(OWNERS,'|ICCWTC|')>0 OR INSTR(OWNERS,'|ICCWTT|')>0 OR INSTR(OWNERS,'|ICCWWC|')>0 OR INSTR(OWNERS,'|OSP|')>0 OR INSTR(OWNERS,'|SFP1|')>0 OR INSTR(OWNERS,'|SFP2|')>0 OR INSTR(OWNERS,'|TMD|')>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 : 5|11:59:50.3670||IsUserAuthenticated: /api/v3/config/servicexml/types?_dc=1575979190408 t Transfer: 1220 : 5|11:59:50.3670||GetCurrentUser.. t Transfer: 1220 : 5|11:59:50.3670|| OAuth authenticated t Transfer: 1220 : 5|11:59:50.3670|| user TONY. t Transfer: 1220 : 5|11:59:50.3670||api user: TONY t Transfer: 1220 : 13|11:59:50.3983||IsUserAuthenticated: /api/settings/groups/?_dc=1575979190444 t Transfer: 1220 : 13|11:59:50.3983||GetCurrentUser.. t Transfer: 1220 : 13|11:59:50.3983|| OAuth authenticated t Transfer: 1220 : 13|11:59:50.3983|| user TONY. t Transfer: 1220 : 13|11:59:50.3983||api user: TONY t Information: 1220 : 13|11:59:50.3983||V3Api.GetSettingsGroupsNames t Transfer: 1220 : 5|11:59:58.2420||IsUserAuthenticated: /api/v3/config/users?showDisabled=true&_dc=1575979198292 t Transfer: 1220 : 5|11:59:58.2420||GetCurrentUser.. t Transfer: 1220 : 5|11:59:58.2420|| OAuth authenticated t Transfer: 1220 : 5|11:59:58.2420|| user TONY. t Transfer: 1220 : 5|11:59:58.2420||api user: TONY t Information: 1220 : 5|11:59:58.2577||GetUsersFiltered t Transfer: 1220 : 13|12:00:01.5077||IsUserAuthenticated: /api/v3/config/location-views?_dc=1575979201544 t Transfer: 1220 : 13|12:00:01.5077||GetCurrentUser.. t Transfer: 1220 : 13|12:00:01.5077|| OAuth authenticated t Transfer: 1220 : 13|12:00:01.5077|| user TONY. t Transfer: 1220 : 13|12:00:01.5077||api user: TONY t Information: 1220 : 13|12:00:01.5077||Get location views t Information: 1220 : 13|12:00:01.5077||GetLocationDefaultViews. t Transfer: 1220 : 14|12:00:06.1014||IsUserAuthenticated: /api/v3/config/users?showDisabled=true&_dc=1575979206141 t Transfer: 1220 : 14|12:00:06.1014||GetCurrentUser.. t Transfer: 1220 : 14|12:00:06.1014|| OAuth authenticated t Transfer: 1220 : 14|12:00:06.1014|| user TONY. t Transfer: 1220 : 14|12:00:06.1014||api user: TONY t Information: 1220 : 14|12:00:06.1014||GetUsersFiltered t Transfer: 1220 : 6|12:00:12.5077||IsUserAuthenticated: /api/lookups/Devices?_dc=1575979212547 t Transfer: 1220 : 6|12:00:12.5077||GetCurrentUser.. t Transfer: 1220 : 6|12:00:12.5077|| OAuth authenticated t Transfer: 1220 : 6|12:00:12.5077|| user TONY. t Transfer: 1220 : 14|12:00:12.5077||IsUserAuthenticated: /api/lookups/Departments?_dc=1575979212546 t Transfer: 1220 : 14|12:00:12.5077||GetCurrentUser.. t Transfer: 1220 : 14|12:00:12.5077|| OAuth authenticated t Transfer: 1220 : 6|12:00:12.5077||api user: TONY t Transfer: 1220 : 14|12:00:12.5077|| user TONY. t Transfer: 1220 : 14|12:00:12.5077||api user: TONY t Transfer: 1220 : 24|12:00:12.6327||IsUserAuthenticated: /api/v3/config/user/522?_dc=1575979212661 t Transfer: 1220 : 24|12:00:12.6327||GetCurrentUser.. t Transfer: 1220 : 24|12:00:12.6327|| OAuth authenticated t Transfer: 1220 : 24|12:00:12.6327|| user TONY. t Transfer: 1220 : 24|12:00:12.6327||api user: TONY t Transfer: 1220 : 13|12:00:12.6327||IsUserAuthenticated: /api/settings/groups/?_dc=1575979212662 t Transfer: 1220 : 13|12:00:12.6327||GetCurrentUser.. t Transfer: 1220 : 13|12:00:12.6327|| OAuth authenticated t Transfer: 1220 : 13|12:00:12.6327|| user TONY. t Transfer: 1220 : 13|12:00:12.6327||api user: TONY t Information: 1220 : 13|12:00:12.6327||V3Api.GetSettingsGroupsNames t Information: 1220 : 24|12:00:12.6483||GetUserById 522 t Information: 1220 : 24|12:00:13.2733||GetUserDbaMode t Information: 1220 : 24|12:00:13.2889||GetUserOracleStatus t Transfer: 1220 : 11|12:00:13.5858||IsUserAuthenticated: /api/lookup/locations/search/?_dc=1575979213616 t Transfer: 1220 : 11|12:00:13.5858||GetCurrentUser.. t Transfer: 1220 : 11|12:00:13.5858|| OAuth authenticated t Transfer: 1220 : 11|12:00:13.5858|| user TONY. t Transfer: 1220 : 11|12:00:13.5858||api user: TONY t Transfer: 1220 : 24|12:01:31.9295||IsUserAuthenticated: /api/v3/config/user-groups?filter=&_dc=1575979291945 t Transfer: 1220 : 24|12:01:31.9295||GetCurrentUser.. t Transfer: 1220 : 24|12:01:31.9295|| OAuth authenticated t Transfer: 1220 : 24|12:01:31.9295|| user TONY. t Transfer: 1220 : 24|12:01:31.9295||api user: TONY t Information: 1220 : 24|12:01:31.9295||GetGroupsSurrogatesAll t Transfer: 1220 : 11|12:02:01.8670||IsUserAuthenticated: /api/settings/groups/?_dc=1575979321914 t Transfer: 1220 : 11|12:02:01.8670||GetCurrentUser.. t Transfer: 1220 : 11|12:02:01.8670|| OAuth authenticated t Transfer: 1220 : 11|12:02:01.8670|| user TONY. t Transfer: 1220 : 11|12:02:01.8670||api user: TONY t Information: 1220 : 11|12:02:01.8670||V3Api.GetSettingsGroupsNames t Transfer: 1220 : 10|12:02:01.8827||IsUserAuthenticated: /api/v3/config/user/522?_dc=1575979321913 t Transfer: 1220 : 10|12:02:01.8827||GetCurrentUser.. t Transfer: 1220 : 10|12:02:01.8827|| OAuth authenticated t Transfer: 1220 : 10|12:02:01.8827|| user TONY. t Transfer: 1220 : 10|12:02:01.8827||api user: TONY t Information: 1220 : 10|12:02:01.8827||GetUserById 522 t Information: 1220 : 10|12:02:01.9452||GetUserDbaMode t Information: 1220 : 10|12:02:01.9452||GetUserOracleStatus t Transfer: 1220 : 11|12:02:11.6639||IsUserAuthenticated: /api/v3/config/user-groups?filter=&_dc=1575979331700 t Transfer: 1220 : 11|12:02:11.6639||GetCurrentUser.. t Transfer: 1220 : 11|12:02:11.6639|| OAuth authenticated t Transfer: 1220 : 11|12:02:11.6639|| user TONY. t Transfer: 1220 : 11|12:02:11.6639||api user: TONY t Information: 1220 : 11|12:02:11.6639||GetGroupsSurrogatesAll t Transfer: 1220 : 12|12:02:23.1014||IsUserAuthenticated: /api/v3/config/user/522?_dc=1575979342902 t Transfer: 1220 : 12|12:02:23.1014||GetCurrentUser.. t Transfer: 1220 : 12|12:02:23.1014|| OAuth authenticated t Transfer: 1220 : 12|12:02:23.1014|| user TONY. t Transfer: 1220 : 12|12:02:23.1014||api user: TONY t Information: 1220 : 12|12:02:23.1952||SaveUser. 522 t Information: 1220 : 12|12:02:23.2108||WriteAreaHistory t Transfer: 1220 : 12|12:02:23.2108||GetCurrentUser.. t Transfer: 1220 : 12|12:02:23.2108|| OAuth authenticated t Transfer: 1220 : 12|12:02:23.2108|| user TONY. t Transfer: 1220 : 29|12:02:23.3983||IsUserAuthenticated: /api/v3/config/user/522?_dc=1575979343233 t Transfer: 1220 : 29|12:02:23.3983||GetCurrentUser.. t Transfer: 1220 : 29|12:02:23.3983|| OAuth authenticated t Transfer: 1220 : 29|12:02:23.3983|| user TONY. t Transfer: 1220 : 29|12:02:23.3983||api user: TONY t Information: 1220 : 29|12:02:23.4764||SaveUser. 522 t Information: 1220 : 29|12:02:23.5546||WriteAreaHistory t Transfer: 1220 : 29|12:02:23.5546||GetCurrentUser.. t Transfer: 1220 : 29|12:02:23.5546|| OAuth authenticated t Transfer: 1220 : 29|12:02:23.5546|| user TONY. t Information: 1220 : 29|12:02:25.1483||V3 Api exception handler: System.Data.Entity.Core.OptimisticConcurrencyException: Store update, insert, or delete statement affected an unexpected number of rows (0). Entities may have been modified or deleted since entities were loaded. See http://go.microsoft.com/fwlink/?LinkId=472540 for information on understanding and handling optimistic concurrency exceptions. at System.Data.Entity.Core.Mapping.Update.Internal.UpdateTranslator.ValidateRowsAffected(Int64 rowsAffected, UpdateCommand source) at System.Data.Entity.Core.Mapping.Update.Internal.UpdateTranslator.Update() at System.Data.Entity.Core.EntityClient.Internal.EntityAdapter.b__2(UpdateTranslator ut) at System.Data.Entity.Core.EntityClient.Internal.EntityAdapter.Update[T](T noChangesResult, Func`2 updateFunction) at System.Data.Entity.Core.EntityClient.Internal.EntityAdapter.Update() at System.Data.Entity.Core.Objects.ObjectContext.b__35() at System.Data.Entity.Core.Objects.ObjectContext.ExecuteInTransaction[T](Func`1 func, IDbExecutionStrategy executionStrategy, Boolean startLocalTransaction, Boolean releaseConnectionOnSuccess) at System.Data.Entity.Core.Objects.ObjectContext.SaveChangesToStore(SaveOptions options, IDbExecutionStrategy executionStrategy, Boolean startLocalTransaction) at System.Data.Entity.Core.Objects.ObjectContext.<>c__DisplayClass2a.b__27() at System.Data.Entity.Infrastructure.DefaultExecutionStrategy.Execute[TResult](Func`1 operation) at System.Data.Entity.Core.Objects.ObjectContext.SaveChangesInternal(SaveOptions options, Boolean executeInExistingTransaction) at System.Data.Entity.Core.Objects.ObjectContext.SaveChanges(SaveOptions options) at System.Data.Entity.Core.Objects.ObjectContext.SaveChanges() at xMfxDataLogic.ServiceLogic.Implementation.SaveUser(USR_USER user, Int32 system) in C:\BuildAgent2\work\405c64e443a47d83\Server\xMfxDataLogic\Logic\ServiceLogic\UserManagement.cs:line 466 at iMfxServerCore.api.controllers.v3.UserConfigController.UpdateUser(Int32 id, USR_USER user) in C:\BuildAgent2\work\405c64e443a47d83\Server\iMfxServerCore\api\controllers\v3\Configuration\UserConfigController.cs:line 69 at lambda_method(Closure , Object , Object[] ) at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ActionExecutor.<>c__DisplayClass6_1.b__0(Object instance, Object[] methodParameters) at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ActionExecutor.Execute(Object instance, Object[] arguments) at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ExecuteAsync(HttpControllerContext controllerContext, IDictionary`2 arguments, CancellationToken cancellationToken) --- End of stack trace from previous location where exception was thrown --- at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Web.Http.Controllers.ApiControllerActionInvoker.d__1.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Web.Http.Controllers.ActionFilterResult.d__5.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Web.Http.Filters.AuthorizationFilterAttribute.d__3.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Web.Http.Controllers.ExceptionFilterResult.d__6.MoveNext() t Information: 1220 : 12|12:02:25.1483||SaveUser. Rebuilding view: TONY t Information: 1220 : 12|12:02:25.1483||RebuildUserViews: TONY t Information: 1220 : 12|12:02:26.0545||RebuildUserViews. TONY executed: 00:00:00.8945294 t Transfer: 1220 : 36|12:02:26.1170||IsUserAuthenticated: /api/v3/config/user/TONY/lock/false?_dc=1575979346151 t Transfer: 1220 : 36|12:02:26.1170||GetCurrentUser.. t Transfer: 1220 : 36|12:02:26.1170|| OAuth authenticated t Transfer: 1220 : 36|12:02:26.1170|| user TONY. t Transfer: 1220 : 36|12:02:26.1170||api user: TONY t Information: 1220 : 36|12:02:26.1170||ChangeUserOracleStatus t Transfer: 1220 : 34|12:02:26.1170||IsUserAuthenticated: /api/v3/config/user/522/dba/0?_dc=1575979346148 t Transfer: 1220 : 34|12:02:26.1170||GetCurrentUser.. t Transfer: 1220 : 34|12:02:26.1170|| OAuth authenticated t Transfer: 1220 : 34|12:02:26.1170|| user TONY. t Transfer: 1220 : 34|12:02:26.1170||api user: TONY t Transfer: 1220 : 32|12:02:26.1170||IsUserAuthenticated: /api/v3/config/user/522/passthru/0?_dc=1575979346149 t Transfer: 1220 : 32|12:02:26.1170||GetCurrentUser.. t Transfer: 1220 : 32|12:02:26.1170|| OAuth authenticated t Transfer: 1220 : 32|12:02:26.1170|| user TONY. t Transfer: 1220 : 32|12:02:26.1170||api user: TONY t Information: 1220 : 34|12:02:26.1170||ChangeUserDbaMode t Information: 1220 : 32|12:02:26.1170||ChangeUserSsoStatus t Information: 1220 : 36|12:02:26.1327||GetUserOracleStatus t Transfer: 1220 : 25|12:02:26.2576||IsUserAuthenticated: /api/v3/config/users?showDisabled=true&_dc=1575979346300 t Transfer: 1220 : 25|12:02:26.2576||GetCurrentUser.. t Transfer: 1220 : 25|12:02:26.2576|| OAuth authenticated t Transfer: 1220 : 25|12:02:26.2576|| user TONY. t Transfer: 1220 : 25|12:02:26.2576||api user: TONY t Information: 1220 : 25|12:02:26.2576||GetUsersFiltered t Transfer: 1220 : 20|12:02:38.4139||IsUserAuthenticated: /api/v3/config/user/522?_dc=1575979358445 t Transfer: 1220 : 20|12:02:38.4139||GetCurrentUser.. t Transfer: 1220 : 20|12:02:38.4139|| OAuth authenticated t Transfer: 1220 : 20|12:02:38.4139|| user TONY. t Transfer: 1220 : 20|12:02:38.4139||api user: TONY t Information: 1220 : 20|12:02:38.4139||GetUserById 522 t Transfer: 1220 : 28|12:02:38.4139||IsUserAuthenticated: /api/settings/groups/?_dc=1575979358446 t Transfer: 1220 : 28|12:02:38.4139||GetCurrentUser.. t Transfer: 1220 : 28|12:02:38.4139|| OAuth authenticated t Transfer: 1220 : 28|12:02:38.4139|| user TONY. t Transfer: 1220 : 28|12:02:38.4139||api user: TONY t Information: 1220 : 28|12:02:38.4139||V3Api.GetSettingsGroupsNames t Information: 1220 : 20|12:02:38.6639||GetUserDbaMode t Information: 1220 : 20|12:02:38.6639||GetUserOracleStatus t Transfer: 1220 : 35|12:03:06.9452||IsUserAuthenticated: /api/v3/config/user/rebuild-view?_dc=1575979386980 t Transfer: 1220 : 35|12:03:06.9452||GetCurrentUser.. t Transfer: 1220 : 35|12:03:06.9452|| OAuth authenticated t Transfer: 1220 : 35|12:03:06.9452|| user TONY. t Transfer: 1220 : 35|12:03:06.9452||api user: TONY t Information: 1220 : 35|12:03:06.9608||RebuildUsersViews t Information: 1220 : 35|12:03:06.9608||RebuildUsersViews. Rebuilding views: 1 t Information: 1220 : 35|12:03:06.9764||RebuildUserViews: TONY t Information: 1220 : 35|12:03:07.5233||RebuildUserViews. TONY executed: 00:00:00.5482278 t Information: 1220 : 35|12:03:07.5233||RebuildUsersViewsParallel. executed: 00:00:00.5495871. users 1. threads 1. t Information: 1220 : 30|12:03:15.1639||GetAppInfo t Information: 1220 : 30|12:03:15.1639|| db: TMDDEMO install mode: auth types: Native, PublicApiKey t Information: 1220 : 35|12:03:28.6796||Oauth validating.. t Verbose: 1220 : 35|12:03:28.6796||GrantResourceOwnerCredentials. t Verbose: 1220 : 35|12:03:28.6796||LoginUser. tony, login type OAuth, encrypt password True t Information: 1220 : 35|12:03:28.6796||TryLoginUser. tony, login type OAuth, check password True, check hash False, encrypt password True, load user data True t Information: 1220 : 35|12:03:28.6796||InitialiseLogin t Information: 1220 : 35|12:03:28.6952|| oauth token 00000000-0000-0000-0000-000000000000 t Information: 1220 : 35|12:03:28.6952||TryLoginUser. Logged in.. t Verbose: 1220 : 35|12:03:28.6952||LoginUser. Adding history. User Id 522, result TONY, host t Verbose: 1220 : 35|12:03:28.7108||GrantResourceOwnerCredentials. Try login finished. Logged: True t Transfer: 1220 : 20|12:03:28.7577||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=1575979408780 t Transfer: 1220 : 20|12:03:28.7577||GetCurrentUser.. t Transfer: 1220 : 20|12:03:28.7577|| OAuth authenticated t Transfer: 1220 : 20|12:03:28.7577|| user TONY. t Transfer: 1220 : 20|12:03:28.7577||api user: TONY t Information: 1220 : 20|12:03:28.7577||V3Api.GetUserSettings t Transfer: 1220 : 20|12:03:28.7577||GetCurrentUser.. t Transfer: 1220 : 20|12:03:28.7577|| OAuth authenticated t Transfer: 1220 : 20|12:03:28.7577|| user TONY. t Transfer: 1220 : 34|12:03:28.7889||IsUserAuthenticated: /api/user-preferences?keys=personal_settings;basket;default_page;color_schema;media.basket.data;defaultSearch&_dc=1575979408821 t Transfer: 1220 : 34|12:03:28.7889||GetCurrentUser.. t Transfer: 1220 : 34|12:03:28.7889|| OAuth authenticated t Transfer: 1220 : 34|12:03:28.7889|| user TONY. t Transfer: 1220 : 34|12:03:28.7889||api user: TONY t Information: 1220 : 34|12:03:28.7889||GetUserDataByKeys: personal_settings;basket;default_page;color_schema;media.basket.data;defaultSearch t Transfer: 1220 : 34|12:03:28.7889||GetCurrentUser.. t Transfer: 1220 : 34|12:03:28.7889|| OAuth authenticated t Transfer: 1220 : 34|12:03:28.7889|| user TONY. t Transfer: 1220 : 25|12:03:28.7889||IsUserAuthenticated: /api/lookups/PgmStatus?_dc=1575979408824 t Transfer: 1220 : 25|12:03:28.7889||GetCurrentUser.. t Transfer: 1220 : 25|12:03:28.7889|| OAuth authenticated t Transfer: 1220 : 25|12:03:28.7889|| user TONY. t Transfer: 1220 : 25|12:03:28.7889||api user: TONY t Transfer: 1220 : 12|12:03:28.8202||IsUserAuthenticated: /api/lookups/MediaStatus?_dc=1575979408823 t Transfer: 1220 : 12|12:03:28.8202||GetCurrentUser.. t Transfer: 1220 : 12|12:03:28.8202|| OAuth authenticated t Transfer: 1220 : 12|12:03:28.8202|| user TONY. t Transfer: 1220 : 12|12:03:28.8202||api user: TONY t Information: 1220 : 32|12:03:28.8670||GetUserProfile. Id: 0 t Transfer: 1220 : 32|12:03:28.8670||GetCurrentUser.. t Transfer: 1220 : 32|12:03:28.8670|| OAuth authenticated t Transfer: 1220 : 32|12:03:28.8670|| user TONY. t Transfer: 1220 : 34|12:03:28.9764||IsUserAuthenticated: /api/settings/user/startSearch?_dc=1575979409000 t Transfer: 1220 : 34|12:03:28.9764||GetCurrentUser.. t Transfer: 1220 : 34|12:03:28.9764|| OAuth authenticated t Transfer: 1220 : 34|12:03:28.9764|| user TONY. t Transfer: 1220 : 34|12:03:28.9764||api user: TONY t Information: 1220 : 34|12:03:28.9764||V3Api.GetUserSettings t Transfer: 1220 : 34|12:03:28.9764||GetCurrentUser.. t Transfer: 1220 : 34|12:03:28.9764|| OAuth authenticated t Transfer: 1220 : 34|12:03:28.9764|| user TONY. t Transfer: 1220 : 33|12:03:29.0233||IsUserAuthenticated: /api/settings/user/defaultSearch?_dc=1575979408999 t Transfer: 1220 : 33|12:03:29.0233||GetCurrentUser.. t Transfer: 1220 : 33|12:03:29.0233|| OAuth authenticated t Transfer: 1220 : 33|12:03:29.0233|| user TONY. t Transfer: 1220 : 33|12:03:29.0233||api user: TONY t Information: 1220 : 33|12:03:29.0233||V3Api.GetUserSettings t Transfer: 1220 : 33|12:03:29.0233||GetCurrentUser.. t Transfer: 1220 : 33|12:03:29.0233|| OAuth authenticated t Transfer: 1220 : 33|12:03:29.0233|| user TONY. t Transfer: 1220 : 25|12:03:29.0858||IsUserAuthenticated: /api/user-preferences?keys=consumer.recent.data&_dc=1575979409117 t Transfer: 1220 : 25|12:03:29.0858||GetCurrentUser.. t Transfer: 1220 : 25|12:03:29.0858|| OAuth authenticated t Transfer: 1220 : 25|12:03:29.0858|| user TONY. t Transfer: 1220 : 25|12:03:29.0858||api user: TONY t Information: 1220 : 25|12:03:29.0858||GetUserDataByKeys: consumer.recent.data t Transfer: 1220 : 25|12:03:29.0858||GetCurrentUser.. t Transfer: 1220 : 25|12:03:29.0858|| OAuth authenticated t Transfer: 1220 : 25|12:03:29.0858|| user TONY. t Transfer: 1220 : 20|12:03:29.0858||IsUserAuthenticated: /api/user-preferences?keys=adv.recent.searches.consumer&_dc=1575979409121 t Transfer: 1220 : 20|12:03:29.0858||GetCurrentUser.. t Transfer: 1220 : 20|12:03:29.0858|| OAuth authenticated t Transfer: 1220 : 20|12:03:29.0858|| user TONY. t Transfer: 1220 : 20|12:03:29.0858||api user: TONY t Information: 1220 : 20|12:03:29.0858||GetUserDataByKeys: adv.recent.searches.consumer t Transfer: 1220 : 20|12:03:29.0858||GetCurrentUser.. t Transfer: 1220 : 20|12:03:29.0858|| OAuth authenticated t Transfer: 1220 : 20|12:03:29.0858|| user TONY. t Transfer: 1220 : 25|12:03:42.4140||IsUserAuthenticated: /api/user-preferences?keys=adv.recent.searches.media&_dc=1575979422450 t Transfer: 1220 : 25|12:03:42.4140||GetCurrentUser.. t Transfer: 1220 : 25|12:03:42.4140|| OAuth authenticated t Transfer: 1220 : 25|12:03:42.4140|| user TONY. t Transfer: 1220 : 25|12:03:42.4140||api user: TONY t Information: 1220 : 25|12:03:42.4140||GetUserDataByKeys: adv.recent.searches.media t Transfer: 1220 : 25|12:03:42.4140||GetCurrentUser.. t Transfer: 1220 : 25|12:03:42.4140|| OAuth authenticated t Transfer: 1220 : 25|12:03:42.4140|| user TONY. t Transfer: 1220 : 10|12:03:42.4140||IsUserAuthenticated: /api/view/searchinfo/Media?_dc=1575979422447 t Transfer: 1220 : 10|12:03:42.4140||GetCurrentUser.. t Transfer: 1220 : 10|12:03:42.4140|| OAuth authenticated t Transfer: 1220 : 10|12:03:42.4140|| user TONY. t Transfer: 1220 : 10|12:03:42.4140||api user: TONY t Information: 1220 : 10|12:03:42.4140||GetAdvSearchColumns. search type Media grid . t Transfer: 1220 : 35|12:03:42.4296||IsUserAuthenticated: /api/view/info/MediaGrid?lang=en-US&_dc=1575979422460 t Transfer: 1220 : 35|12:03:42.4296||GetCurrentUser.. t Transfer: 1220 : 35|12:03:42.4296|| OAuth authenticated t Transfer: 1220 : 35|12:03:42.4296|| user TONY. t Transfer: 1220 : 35|12:03:42.4296||api user: TONY t Information: 1220 : 35|12:03:42.4296||GetGridViewBuilder. builder type MediaGrid. t Transfer: 1220 : 35|12:03:42.4296||GetCurrentUser.. t Transfer: 1220 : 35|12:03:42.4296|| OAuth authenticated t Transfer: 1220 : 35|12:03:42.4296|| user TONY. t Transfer: 1220 : 30|12:03:42.4296||IsUserAuthenticated: /api/lookups/SearchSupportedOperators?_dc=1575979422448 t Transfer: 1220 : 30|12:03:42.4296||GetCurrentUser.. t Transfer: 1220 : 30|12:03:42.4296|| OAuth authenticated t Transfer: 1220 : 30|12:03:42.4296|| user TONY. t Transfer: 1220 : 30|12:03:42.4296||api user: TONY t Information: 1220 : 35|12:03:42.4296||UserGridView. LoadView. ID 1282, Name Default. t Transfer: 1220 : 35|12:03:42.4296||GetCurrentUser.. t Transfer: 1220 : 35|12:03:42.4296|| OAuth authenticated t Transfer: 1220 : 35|12:03:42.4296|| user TONY. t Transfer: 1220 : 32|12:03:42.4296||IsUserAuthenticated: /api/settings/user/searchLayoutConfig?_dc=1575979422454 t Transfer: 1220 : 32|12:03:42.4296||GetCurrentUser.. t Transfer: 1220 : 32|12:03:42.4296|| OAuth authenticated t Transfer: 1220 : 32|12:03:42.4296|| user TONY. t Transfer: 1220 : 32|12:03:42.4296||api user: TONY t Information: 1220 : 32|12:03:42.4296||V3Api.GetUserSettings t Transfer: 1220 : 32|12:03:42.4296||GetCurrentUser.. t Transfer: 1220 : 32|12:03:42.4296|| OAuth authenticated t Transfer: 1220 : 32|12:03:42.4296|| user TONY. t Transfer: 1220 : 35|12:03:42.4452||GetCurrentUser.. t Transfer: 1220 : 35|12:03:42.4452|| OAuth authenticated t Transfer: 1220 : 35|12:03:42.4452|| user TONY. t Transfer: 1220 : 11|12:03:42.4452||IsUserAuthenticated: /api/view/searches/Media?_dc=1575979422478 t Transfer: 1220 : 11|12:03:42.4452||GetCurrentUser.. t Transfer: 1220 : 11|12:03:42.4452|| OAuth authenticated t Transfer: 1220 : 11|12:03:42.4452|| user TONY. t Transfer: 1220 : 11|12:03:42.4452||api user: TONY t Information: 1220 : 11|12:03:42.4452||GetSavedSearchNames. search type Media. t Transfer: 1220 : 11|12:03:42.4452||GetCurrentUser.. t Transfer: 1220 : 11|12:03:42.4452|| OAuth authenticated t Transfer: 1220 : 11|12:03:42.4452|| user TONY. t Transfer: 1220 : 28|12:03:46.1639||IsUserAuthenticated: /api/SearchSuggestion/?_dc=1575979426202 t Transfer: 1220 : 28|12:03:46.1639||GetCurrentUser.. t Transfer: 1220 : 28|12:03:46.1639|| OAuth authenticated t Transfer: 1220 : 28|12:03:46.1639|| user TONY. t Transfer: 1220 : 28|12:03:46.1639||api user: TONY t Transfer: 1220 : 28|12:03:46.1639||GetCurrentUser.. t Transfer: 1220 : 28|12:03:46.1639|| OAuth authenticated t Transfer: 1220 : 28|12:03:46.1639|| user TONY. t Transfer: 1220 : 35|12:03:46.6795||IsUserAuthenticated: /api/search/Media?_dc=1575979426721 t Transfer: 1220 : 35|12:03:46.6795||GetCurrentUser.. t Transfer: 1220 : 35|12:03:46.6795|| OAuth authenticated t Transfer: 1220 : 35|12:03:46.6952|| user TONY. t Transfer: 1220 : 35|12:03:46.6952||api user: TONY t Information: 1220 : 35|12:03:46.6952||V3Api.SearchMedia t Information: 1220 : 35|12:03:46.6952||V3Api.SearchGeneric t Transfer: 1220 : 35|12:03:46.6952||GetCurrentUser.. t Transfer: 1220 : 35|12:03:46.6952|| OAuth authenticated t Transfer: 1220 : 35|12:03:46.6952|| user TONY. t Information: 1220 : 35|12:03:46.7108||MediaSearch SQL: select r.*, nvl((select TMD_STR_AGG(c.u_id_pfix ) from tm_ctnrs c, tm_mi_tpi_lnx l where l.miid=r.id and c.u_id=l.tpiid and r.media_type=1),'') BARCODE, nvl(lnk.lib_loc_ext_id,0) lib_loc_ext_id, nvl(lnk.ctnr_loan_stat,0) ctnr_loan_status, nvl(lnk.ctnr_stat,0) ctnr_stat, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID , GETMEDIALOC(r.id, r.media_type, r.compil, r.m_ctnr_int_o_loc, r.m_ctnr_ext_o_loc, r.m_ctnr_loc) LOCATION, nvl(dfl.fSOM,0) FILE_SOM, nvl(dfl.fEOM,0) FILE_EOM, dfl.fos_fname FILENAME, dfl.DFILE_LINK_GUID, dfl.OS_GUID, dfl.SUB_FOLDER, dfl.ORIGINAL_FILENAME from (select a.*, rownum rnum from (select m.*, coalesce(m.primary_thumb_id, (select v.primary_thumb_id from tm_pg_rl v where v.id=m.pgm_parent_id)) primary_thumb_id2 from tmddba.tm_mis m ,(select /*+ cardinality(4) */ rownum rn, column_value id from table(:ids)) ids where media_type>0 and item_type>0 and m.id = ids.id order by ids.rn ) a where rownum <= 10000) r ,lateral( select l.miid, max(c.C_EXT_OUT_LOC) lib_loc_ext_id, max(c.C_STAT) ctnr_stat, max(c.loan_stat) ctnr_loan_stat from tm_mi_tpi_lnx l, tm_ctnrs c where c.u_id=l.tpiid and l.miid=r.id and r.media_type=1 group by l.miid)(+) lnk ,lateral(select tt.* from tm_text tt where tt.text_id = r.primary_thumb_id2)(+) t ,lateral(select /*+ NO_DECORRELATE */ d.som fsom, d.eom feom, dl.mi_id fmi_id, d.os_fname fos_fname, d.DFILE_LINK_GUID, d.OS_GUID, d.SUB_FOLDER, dl.dfile_id, d.original_filename FROM tm_dfile d, tm_mi_dfile_lnx dl where d.id=dl.dfile_id and r.id=dl.mi_id and rownum=1)(+) dfl where rnum >= 1 order by rnum t Information: 1220 : 35|12:03:46.7265|| timing: 00:00:00.0398241 t Verbose: 1220 : 35|12:03:46.7265||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Australia vs South Africa Match 45.mp4 subfolder t Verbose: 1220 : 35|12:03:46.7265|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Australia vs South Africa Match 45.mp4 t Verbose: 1220 : 35|12:03:46.7265||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/Australia vs South Africa Match 45.mp4 t Transfer: 1220 : 35|12:03:46.7265||GetCurrentUser.. t Transfer: 1220 : 35|12:03:46.7265|| OAuth authenticated t Transfer: 1220 : 35|12:03:46.7265|| user TONY. t Verbose: 1220 : 35|12:03:46.7265||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\England vs South Africa Match 1.mp4 subfolder t Verbose: 1220 : 35|12:03:46.7265|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/England vs South Africa Match 1.mp4 t Verbose: 1220 : 35|12:03:46.7265||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/England vs South Africa Match 1.mp4 t Transfer: 1220 : 35|12:03:46.7265||GetCurrentUser.. t Transfer: 1220 : 35|12:03:46.7265|| OAuth authenticated t Transfer: 1220 : 35|12:03:46.7265|| user TONY. t Verbose: 1220 : 35|12:03:46.7265||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\West Indies vs Pakistan Match 2.mp4 subfolder t Verbose: 1220 : 35|12:03:46.7265|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/West Indies vs Pakistan Match 2.mp4 t Verbose: 1220 : 35|12:03:46.7265||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/West Indies vs Pakistan Match 2.mp4 t Transfer: 1220 : 35|12:03:46.7265||GetCurrentUser.. t Transfer: 1220 : 35|12:03:46.7265|| OAuth authenticated t Transfer: 1220 : 35|12:03:46.7265|| user TONY. t Verbose: 1220 : 35|12:03:46.7265||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\New Zealand vs England Final.mp4 subfolder t Verbose: 1220 : 35|12:03:46.7265|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/New Zealand vs England Final.mp4 t Verbose: 1220 : 35|12:03:46.7265||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/New Zealand vs England Final.mp4 t Transfer: 1220 : 35|12:03:46.7265||GetCurrentUser.. t Transfer: 1220 : 35|12:03:46.7265|| OAuth authenticated t Transfer: 1220 : 35|12:03:46.7265|| user TONY. t Verbose: 1220 : 35|12:03:46.7421||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Australia vs England Short Semi Final 2.mp4 subfolder t Verbose: 1220 : 35|12:03:46.7421|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Australia vs England Short Semi Final 2.mp4 t Verbose: 1220 : 35|12:03:46.7421||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/Australia vs England Short Semi Final 2.mp4 t Transfer: 1220 : 35|12:03:46.7421||GetCurrentUser.. t Transfer: 1220 : 35|12:03:46.7421|| OAuth authenticated t Transfer: 1220 : 35|12:03:46.7421|| user TONY. t Verbose: 1220 : 35|12:03:46.7421||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\India vs New Zealand Semi Final 1.mp4 subfolder t Verbose: 1220 : 35|12:03:46.7421|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/India vs New Zealand Semi Final 1.mp4 t Verbose: 1220 : 35|12:03:46.7421||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/India vs New Zealand Semi Final 1.mp4 t Transfer: 1220 : 35|12:03:46.7421||GetCurrentUser.. t Transfer: 1220 : 35|12:03:46.7421|| OAuth authenticated t Transfer: 1220 : 35|12:03:46.7421|| user TONY. t Verbose: 1220 : 35|12:03:46.7421||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\South Africa vs Bangladesh Match 5 .mp4 subfolder t Verbose: 1220 : 35|12:03:46.7421|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/South Africa vs Bangladesh Match 5 .mp4 t Verbose: 1220 : 35|12:03:46.7421||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/South Africa vs Bangladesh Match 5 .mp4 t Transfer: 1220 : 35|12:03:46.7421||GetCurrentUser.. t Transfer: 1220 : 35|12:03:46.7421|| OAuth authenticated t Transfer: 1220 : 35|12:03:46.7421|| user TONY. t Verbose: 1220 : 35|12:03:46.7421||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\New Zealand vs Sri Lanka Match 3.mp4 subfolder t Verbose: 1220 : 35|12:03:46.7421|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/New Zealand vs Sri Lanka Match 3.mp4 t Verbose: 1220 : 35|12:03:46.7421||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/New Zealand vs Sri Lanka Match 3.mp4 t Transfer: 1220 : 35|12:03:46.7421||GetCurrentUser.. t Transfer: 1220 : 35|12:03:46.7421|| OAuth authenticated t Transfer: 1220 : 35|12:03:46.7421|| user TONY. t Verbose: 1220 : 35|12:03:46.7421||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Afghanistan vs Australia Match 4.mp4 subfolder t Verbose: 1220 : 35|12:03:46.7421|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Afghanistan vs Australia Match 4.mp4 t Verbose: 1220 : 35|12:03:46.7421||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/Afghanistan vs Australia Match 4.mp4 t Transfer: 1220 : 35|12:03:46.7421||GetCurrentUser.. t Transfer: 1220 : 35|12:03:46.7421|| OAuth authenticated t Transfer: 1220 : 35|12:03:46.7421|| user TONY. t Verbose: 1220 : 35|12:03:46.7421||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Bangladesh vs New Zealand Match 9.mp4 subfolder t Verbose: 1220 : 35|12:03:46.7421|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Bangladesh vs New Zealand Match 9.mp4 t Verbose: 1220 : 35|12:03:46.7421||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/Bangladesh vs New Zealand Match 9.mp4 t Transfer: 1220 : 35|12:03:46.7421||GetCurrentUser.. t Transfer: 1220 : 35|12:03:46.7421|| OAuth authenticated t Transfer: 1220 : 35|12:03:46.7421|| user TONY. t Verbose: 1220 : 35|12:03:46.7421||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Afghanistan vs Sri Lanka Match 7.mp4 subfolder t Verbose: 1220 : 35|12:03:46.7421|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Afghanistan vs Sri Lanka Match 7.mp4 t Verbose: 1220 : 35|12:03:46.7421||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/Afghanistan vs Sri Lanka Match 7.mp4 t Transfer: 1220 : 35|12:03:46.7421||GetCurrentUser.. t Transfer: 1220 : 35|12:03:46.7421|| OAuth authenticated t Transfer: 1220 : 35|12:03:46.7421|| user TONY. t Verbose: 1220 : 35|12:03:46.7421||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Australia vs West Indies Match 10.mp4 subfolder t Verbose: 1220 : 35|12:03:46.7421|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Australia vs West Indies Match 10.mp4 t Verbose: 1220 : 35|12:03:46.7421||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/Australia vs West Indies Match 10.mp4 t Transfer: 1220 : 35|12:03:46.7577||GetCurrentUser.. t Transfer: 1220 : 35|12:03:46.7577|| OAuth authenticated t Transfer: 1220 : 35|12:03:46.7577|| user TONY. t Verbose: 1220 : 35|12:03:46.7577||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\South Africa vs India Match 8.mp4 subfolder t Verbose: 1220 : 35|12:03:46.7577|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/South Africa vs India Match 8.mp4 t Verbose: 1220 : 35|12:03:46.7577||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/South Africa vs India Match 8.mp4 t Transfer: 1220 : 35|12:03:46.7577||GetCurrentUser.. t Transfer: 1220 : 35|12:03:46.7577|| OAuth authenticated t Transfer: 1220 : 35|12:03:46.7577|| user TONY. t Verbose: 1220 : 35|12:03:46.7577||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\England vs Pakistan Match 6.mp4 subfolder t Verbose: 1220 : 35|12:03:46.7577|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/England vs Pakistan Match 6.mp4 t Verbose: 1220 : 35|12:03:46.7577||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/England vs Pakistan Match 6.mp4 t Transfer: 1220 : 35|12:03:46.7577||GetCurrentUser.. t Transfer: 1220 : 35|12:03:46.7577|| OAuth authenticated t Transfer: 1220 : 35|12:03:46.7577|| user TONY. t Verbose: 1220 : 35|12:03:46.7577||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Pakistan vs Sri Lanka Match 11.mp4 subfolder t Verbose: 1220 : 35|12:03:46.7577|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Pakistan vs Sri Lanka Match 11.mp4 t Verbose: 1220 : 35|12:03:46.7577||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/Pakistan vs Sri Lanka Match 11.mp4 t Transfer: 1220 : 35|12:03:46.7577||GetCurrentUser.. t Transfer: 1220 : 35|12:03:46.7577|| OAuth authenticated t Transfer: 1220 : 35|12:03:46.7577|| user TONY. t Verbose: 1220 : 35|12:03:46.7577||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|12:03:46.7577|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/England v Bangladesh Match Group A.mp4 t Verbose: 1220 : 35|12:03:46.7577||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/England v Bangladesh Match Group A.mp4 t Transfer: 1220 : 35|12:03:46.7577||GetCurrentUser.. t Transfer: 1220 : 35|12:03:46.7577|| OAuth authenticated t Transfer: 1220 : 35|12:03:46.7577|| user TONY. t Verbose: 1220 : 35|12:03:46.7577||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\ICC 360 Cricket for Change.mp4 subfolder t Verbose: 1220 : 35|12:03:46.7577|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/ICC 360 Cricket for Change.mp4 t Verbose: 1220 : 35|12:03:46.7577||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/ICC 360 Cricket for Change.mp4 t Transfer: 1220 : 35|12:03:46.7577||GetCurrentUser.. t Transfer: 1220 : 35|12:03:46.7577|| OAuth authenticated t Transfer: 1220 : 35|12:03:46.7577|| user TONY. t Verbose: 1220 : 35|12:03:46.7577||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Scotland vs Oman 5th Place Play Off.mp4 subfolder t Verbose: 1220 : 35|12:03:46.7577|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Scotland vs Oman 5th Place Play Off.mp4 t Verbose: 1220 : 35|12:03:46.7577||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/Scotland vs Oman 5th Place Play Off.mp4 t Transfer: 1220 : 35|12:03:46.7577||GetCurrentUser.. t Transfer: 1220 : 35|12:03:46.7577|| OAuth authenticated t Transfer: 1220 : 35|12:03:46.7577|| user TONY. t Transfer: 1220 : 34|12:03:46.8202||IsUserAuthenticated: /api/user-preferences?_dc=1575979426856 t Transfer: 1220 : 34|12:03:46.8202||GetCurrentUser.. t Transfer: 1220 : 34|12:03:46.8202|| OAuth authenticated t Transfer: 1220 : 34|12:03:46.8202|| user TONY. t Transfer: 1220 : 34|12:03:46.8202||api user: TONY t Verbose: 1220 : 34|12:03:46.8202||StoreUserDataByKeys.. t Transfer: 1220 : 34|12:03:46.8202||GetCurrentUser.. t Transfer: 1220 : 34|12:03:46.8202|| OAuth authenticated t Transfer: 1220 : 34|12:03:46.8202|| user TONY. t Transfer: 1220 : 36|12:03:47.6483||IsUserAuthenticated: /api/user-group-preferences?globals=htmlplayerhotkeys,audioOnFrameForward&_dc=1575979427689 t Transfer: 1220 : 36|12:03:47.6483||GetCurrentUser.. t Transfer: 1220 : 36|12:03:47.6483|| OAuth authenticated t Transfer: 1220 : 36|12:03:47.6483|| user TONY. t Transfer: 1220 : 36|12:03:47.6483||api user: TONY t Information: 1220 : 36|12:03:47.6483||V3Api.GetUserSettings t Transfer: 1220 : 36|12:03:47.6483||GetCurrentUser.. t Transfer: 1220 : 36|12:03:47.6483|| OAuth authenticated t Transfer: 1220 : 36|12:03:47.6483|| user TONY. t Transfer: 1220 : 20|12:03:50.3983||IsUserAuthenticated: /api/title-details/298279?_dc=1575979430429 t Transfer: 1220 : 20|12:03:50.3983||GetCurrentUser.. t Transfer: 1220 : 20|12:03:50.3983|| OAuth authenticated t Transfer: 1220 : 20|12:03:50.3983|| user TONY. t Transfer: 1220 : 20|12:03:50.3983||api user: TONY t Transfer: 1220 : 11|12:03:50.4139||IsUserAuthenticated: /api/v3/detailsview/TitleDetails/0?lang=en-US&_dc=1575979430457 t Transfer: 1220 : 11|12:03:50.4139||GetCurrentUser.. t Transfer: 1220 : 11|12:03:50.4139|| OAuth authenticated t Transfer: 1220 : 11|12:03:50.4139|| user TONY. t Transfer: 1220 : 11|12:03:50.4139||api user: TONY t Transfer: 1220 : 32|12:03:50.4921||IsUserAuthenticated: /api/lookups/FriendlyNames?_dc=1575979430523 t Transfer: 1220 : 32|12:03:50.4921||GetCurrentUser.. t Transfer: 1220 : 32|12:03:50.4921|| OAuth authenticated t Transfer: 1220 : 32|12:03:50.4921|| user TONY. t Transfer: 1220 : 32|12:03:50.4921||api user: TONY t Transfer: 1220 : 11|12:03:50.5077||IsUserAuthenticated: /api/view/info/VersionGrid?lang=en-US&_dc=1575979430539 t Transfer: 1220 : 11|12:03:50.5077||GetCurrentUser.. t Transfer: 1220 : 11|12:03:50.5077|| OAuth authenticated t Transfer: 1220 : 11|12:03:50.5077|| user TONY. t Transfer: 1220 : 11|12:03:50.5077||api user: TONY t Information: 1220 : 11|12:03:50.5077||GetGridViewBuilder. builder type VersionGrid. t Transfer: 1220 : 11|12:03:50.5077||GetCurrentUser.. t Transfer: 1220 : 11|12:03:50.5077|| OAuth authenticated t Transfer: 1220 : 11|12:03:50.5077|| user TONY. t Information: 1220 : 11|12:03:50.5077||UserGridView. LoadView. ID -1, Name Default. t Transfer: 1220 : 11|12:03:50.5077||GetCurrentUser.. t Transfer: 1220 : 11|12:03:50.5077|| OAuth authenticated t Transfer: 1220 : 11|12:03:50.5077|| user TONY. t Transfer: 1220 : 11|12:03:50.5077||GetCurrentUser.. t Transfer: 1220 : 11|12:03:50.5077|| OAuth authenticated t Transfer: 1220 : 11|12:03:50.5077|| user TONY. t Transfer: 1220 : 34|12:03:50.5233||IsUserAuthenticated: /api/view/info/TitleTree?lang=en-US&_dc=1575979430553 t Transfer: 1220 : 34|12:03:50.5233||GetCurrentUser.. t Transfer: 1220 : 34|12:03:50.5233|| OAuth authenticated t Transfer: 1220 : 34|12:03:50.5233|| user TONY. t Transfer: 1220 : 34|12:03:50.5233||api user: TONY t Information: 1220 : 34|12:03:50.5233||GetGridViewBuilder. builder type TitleTree. t Transfer: 1220 : 34|12:03:50.5233||GetCurrentUser.. t Transfer: 1220 : 34|12:03:50.5233|| OAuth authenticated t Transfer: 1220 : 34|12:03:50.5233|| user TONY. t Information: 1220 : 34|12:03:50.5233||UserGridView. LoadView. ID 1281, Name Default. t Transfer: 1220 : 34|12:03:50.5233||GetCurrentUser.. t Transfer: 1220 : 34|12:03:50.5233|| OAuth authenticated t Transfer: 1220 : 34|12:03:50.5233|| user TONY. t Transfer: 1220 : 34|12:03:50.5233||GetCurrentUser.. t Transfer: 1220 : 34|12:03:50.5233|| OAuth authenticated t Transfer: 1220 : 34|12:03:50.5233|| user TONY. t Transfer: 1220 : 29|12:03:50.5233||IsUserAuthenticated: /api/search/title?_dc=1575979430563 t Transfer: 1220 : 29|12:03:50.5233||GetCurrentUser.. t Transfer: 1220 : 29|12:03:50.5233|| OAuth authenticated t Transfer: 1220 : 29|12:03:50.5233|| user TONY. t Transfer: 1220 : 29|12:03:50.5233||api user: TONY t Information: 1220 : 29|12:03:50.5233||V3Api.SearchTitles t Information: 1220 : 29|12:03:50.5233||V3Api.SearchGeneric t Transfer: 1220 : 29|12:03:50.5233||GetCurrentUser.. t Transfer: 1220 : 29|12:03:50.5233|| OAuth authenticated t Transfer: 1220 : 29|12:03:50.5233|| user TONY. t Transfer: 1220 : 29|12:03:50.5233||GetCurrentUser.. t Transfer: 1220 : 29|12:03:50.5233|| OAuth authenticated t Transfer: 1220 : 29|12:03:50.5233|| user TONY. t Information: 1220 : 29|12:03:50.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 : 32|12:03:50.5702||IsUserAuthenticated: /api/search/title?_dc=1575979430608 t Transfer: 1220 : 32|12:03:50.5702||GetCurrentUser.. t Transfer: 1220 : 32|12:03:50.5702|| OAuth authenticated t Transfer: 1220 : 32|12:03:50.5702|| user TONY. t Transfer: 1220 : 32|12:03:50.5702||api user: TONY t Information: 1220 : 32|12:03:50.5702||V3Api.SearchTitles t Information: 1220 : 32|12:03:50.5702||V3Api.SearchGeneric t Transfer: 1220 : 32|12:03:50.5702||GetCurrentUser.. t Transfer: 1220 : 32|12:03:50.5702|| OAuth authenticated t Transfer: 1220 : 32|12:03:50.5702|| user TONY. t Transfer: 1220 : 32|12:03:50.5702||GetCurrentUser.. t Transfer: 1220 : 32|12:03:50.5702|| OAuth authenticated t Transfer: 1220 : 32|12:03:50.5702|| user TONY. t Information: 1220 : 32|12:03:50.5702||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 : 36|12:05:47.3827||IsUserAuthenticated: /api/v3/config/servicexml/types?_dc=1575979547419 t Transfer: 1220 : 36|12:05:47.3827||GetCurrentUser.. t Transfer: 1220 : 36|12:05:47.3827|| OAuth authenticated t Transfer: 1220 : 36|12:05:47.3827|| user TONY. t Transfer: 1220 : 36|12:05:47.3827||api user: TONY t Transfer: 1220 : 37|12:05:47.3983||IsUserAuthenticated: /api/settings/groups/?_dc=1575979547445 t Transfer: 1220 : 37|12:05:47.3983||GetCurrentUser.. t Transfer: 1220 : 37|12:05:47.3983|| OAuth authenticated t Transfer: 1220 : 37|12:05:47.3983|| user TONY. t Transfer: 1220 : 37|12:05:47.3983||api user: TONY t Information: 1220 : 37|12:05:47.3983||V3Api.GetSettingsGroupsNames t Transfer: 1220 : 38|12:06:16.6952||IsUserAuthenticated: /api/settings/group/0?_dc=1575979576721 t Transfer: 1220 : 38|12:06:16.6952||GetCurrentUser.. t Transfer: 1220 : 38|12:06:16.6952|| OAuth authenticated t Transfer: 1220 : 38|12:06:16.6952|| user TONY. t Transfer: 1220 : 38|12:06:16.6952||api user: TONY t Transfer: 1220 : 35|12:06:16.6952||IsUserAuthenticated: /api/settings/group/0?_dc=1575979576720 t Transfer: 1220 : 35|12:06:16.6952||GetCurrentUser.. t Transfer: 1220 : 35|12:06:16.6952|| OAuth authenticated t Transfer: 1220 : 35|12:06:16.6952|| user TONY. t Transfer: 1220 : 35|12:06:16.6952||api user: TONY t Transfer: 1220 : 23|12:06:16.6952||IsUserAuthenticated: /api/settings/group/0?_dc=1575979576724 t Transfer: 1220 : 23|12:06:16.6952||GetCurrentUser.. t Transfer: 1220 : 23|12:06:16.6952|| OAuth authenticated t Transfer: 1220 : 23|12:06:16.6952|| user TONY. t Transfer: 1220 : 23|12:06:16.6952||api user: TONY t Information: 1220 : 35|12:06:16.6952||V3Api.GetSettingsGroup t Information: 1220 : 23|12:06:16.6952||V3Api.GetSettingsGroup t Information: 1220 : 38|12:06:16.6952||V3Api.GetSettingsGroup t Transfer: 1220 : 39|12:06:25.3046||IsUserAuthenticated: /api/v3/config-tables?_dc=1575979585337 t Transfer: 1220 : 39|12:06:25.3046||GetCurrentUser.. t Transfer: 1220 : 39|12:06:25.3046|| OAuth authenticated t Transfer: 1220 : 39|12:06:25.3046|| user TONY. t Transfer: 1220 : 39|12:06:25.3046||api user: TONY t Transfer: 1220 : 49|12:09:42.3983||IsUserAuthenticated: /api/title-details/298279?_dc=1575979782175 t Transfer: 1220 : 49|12:09:42.3983||GetCurrentUser.. t Transfer: 1220 : 49|12:09:42.3983|| OAuth authenticated t Transfer: 1220 : 49|12:09:42.3983|| user TONY. t Transfer: 1220 : 49|12:09:42.3983||api user: TONY t Transfer: 1220 : 45|12:09:42.6171||IsUserAuthenticated: /api/search/title?_dc=1575979782586 t Transfer: 1220 : 45|12:09:42.6171||GetCurrentUser.. t Transfer: 1220 : 45|12:09:42.6171|| OAuth authenticated t Transfer: 1220 : 45|12:09:42.6171|| user TONY. t Transfer: 1220 : 45|12:09:42.6171||api user: TONY t Information: 1220 : 45|12:09:42.6171||V3Api.SearchTitles t Information: 1220 : 45|12:09:42.6171||V3Api.SearchGeneric t Transfer: 1220 : 45|12:09:42.6171||GetCurrentUser.. t Transfer: 1220 : 45|12:09:42.6171|| OAuth authenticated t Transfer: 1220 : 45|12:09:42.6171|| user TONY. t Transfer: 1220 : 45|12:09:42.6171||GetCurrentUser.. t Transfer: 1220 : 45|12:09:42.6171|| OAuth authenticated t Transfer: 1220 : 45|12:09:42.6171|| user TONY. t Information: 1220 : 45|12:09:42.6327||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 : 5|12:09:42.6952||IsUserAuthenticated: /api/search/title?_dc=1575979782724 t Transfer: 1220 : 5|12:09:42.6952||GetCurrentUser.. t Transfer: 1220 : 5|12:09:42.6952|| OAuth authenticated t Transfer: 1220 : 5|12:09:42.6952|| user TONY. t Transfer: 1220 : 5|12:09:42.6952||api user: TONY t Information: 1220 : 5|12:09:42.6952||V3Api.SearchTitles t Information: 1220 : 5|12:09:42.6952||V3Api.SearchGeneric t Transfer: 1220 : 5|12:09:42.7108||GetCurrentUser.. t Transfer: 1220 : 5|12:09:42.7108|| OAuth authenticated t Transfer: 1220 : 5|12:09:42.7108|| user TONY. t Transfer: 1220 : 5|12:09:42.7108||GetCurrentUser.. t Transfer: 1220 : 5|12:09:42.7108|| OAuth authenticated t Transfer: 1220 : 5|12:09:42.7108|| user TONY. t Information: 1220 : 5|12:09:42.7108||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 : 5|12:10:13.4921||IsUserAuthenticated: /api/title-details/298279?_dc=1575979813420 t Transfer: 1220 : 5|12:10:13.4921||GetCurrentUser.. t Transfer: 1220 : 5|12:10:13.4921|| OAuth authenticated t Transfer: 1220 : 5|12:10:13.4921|| user TONY. t Transfer: 1220 : 5|12:10:13.4921||api user: TONY t Transfer: 1220 : 49|12:10:13.7108||IsUserAuthenticated: /api/search/title?_dc=1575979813644 t Transfer: 1220 : 49|12:10:13.7108||GetCurrentUser.. t Transfer: 1220 : 49|12:10:13.7108|| OAuth authenticated t Transfer: 1220 : 49|12:10:13.7108|| user TONY. t Transfer: 1220 : 49|12:10:13.7108||api user: TONY t Information: 1220 : 49|12:10:13.7265||V3Api.SearchTitles t Information: 1220 : 49|12:10:13.7265||V3Api.SearchGeneric t Transfer: 1220 : 49|12:10:13.7265||GetCurrentUser.. t Transfer: 1220 : 49|12:10:13.7265|| OAuth authenticated t Transfer: 1220 : 49|12:10:13.7265|| user TONY. t Transfer: 1220 : 49|12:10:13.7265||GetCurrentUser.. t Transfer: 1220 : 49|12:10:13.7265|| OAuth authenticated t Transfer: 1220 : 49|12:10:13.7265|| user TONY. t Information: 1220 : 49|12:10:13.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 : 53|12:10:13.8983||IsUserAuthenticated: /api/search/title?_dc=1575979813861 t Transfer: 1220 : 53|12:10:13.8983||GetCurrentUser.. t Transfer: 1220 : 53|12:10:13.8983|| OAuth authenticated t Transfer: 1220 : 53|12:10:13.8983|| user TONY. t Transfer: 1220 : 53|12:10:13.8983||api user: TONY t Information: 1220 : 53|12:10:13.8983||V3Api.SearchTitles t Information: 1220 : 53|12:10:13.8983||V3Api.SearchGeneric t Transfer: 1220 : 53|12:10:13.8983||GetCurrentUser.. t Transfer: 1220 : 53|12:10:13.8983|| OAuth authenticated t Transfer: 1220 : 53|12:10:13.8983|| user TONY. t Transfer: 1220 : 53|12:10:13.8983||GetCurrentUser.. t Transfer: 1220 : 53|12:10:13.8983|| OAuth authenticated t Transfer: 1220 : 53|12:10:13.8983|| user TONY. t Information: 1220 : 53|12:10:13.8983||SearchTitle SQL: with v as ( SELECT abs.* ,decode(ITEM_TYPE, 1010,SER_ABS_ID, 1020,CASE WHEN SER_ABS2_ID > 0 THEN SER_ABS2_ID ELSE SER_ABS_ID END ) xparent_id FROM TMDDBA.TM_PG_ABS abs WHERE abs.id in ( select a.id FROM TMDDBA.TM_PG_ABS a where ABS_DELETED = 0 AND Upper(a.ID) = Upper('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 : 47|12:10:22.5858||IsUserAuthenticated: /api/user-preferences?_dc=1575979822615 t Transfer: 1220 : 47|12:10:22.5858||GetCurrentUser.. t Transfer: 1220 : 47|12:10:22.5858|| OAuth authenticated t Transfer: 1220 : 47|12:10:22.5858|| user TONY. t Transfer: 1220 : 47|12:10:22.5858||api user: TONY t Verbose: 1220 : 47|12:10:22.5858||StoreUserDataByKeys.. t Transfer: 1220 : 47|12:10:22.5858||GetCurrentUser.. t Transfer: 1220 : 47|12:10:22.5858|| OAuth authenticated t Transfer: 1220 : 47|12:10:22.5858|| user TONY. t Transfer: 1220 : 54|12:10:48.5233||IsUserAuthenticated: /api/taxonomy?_dc=1575979848543 t Transfer: 1220 : 54|12:10:48.5233||GetCurrentUser.. t Transfer: 1220 : 54|12:10:48.5233|| OAuth authenticated t Transfer: 1220 : 54|12:10:48.5233|| user TONY. t Transfer: 1220 : 54|12:10:48.5233||api user: TONY t Transfer: 1220 : 55|12:10:48.5233||IsUserAuthenticated: /api/media-details/298533?_dc=1575979848544 t Transfer: 1220 : 55|12:10:48.5233||GetCurrentUser.. t Transfer: 1220 : 55|12:10:48.5233|| OAuth authenticated t Transfer: 1220 : 55|12:10:48.5233|| user TONY. t Transfer: 1220 : 55|12:10:48.5233||api user: TONY t Transfer: 1220 : 55|12:10:48.5233||GetCurrentUser.. t Transfer: 1220 : 55|12:10:48.5233|| OAuth authenticated t Transfer: 1220 : 55|12:10:48.5233|| user TONY. t Information: 1220 : 55|12:10:49.0859||TM_MIS. LoadSubtitles for ID: 298533. t Information: 1220 : 55|12:10:49.0859||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 : 55|12:10:49.1015||TM_MIS. LoadSubtitles for ID: 298533 found no subtitles. t Verbose: 1220 : 55|12:10:49.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 : 55|12:10:49.2577|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Australia vs South Africa Match 45.mp4 t Verbose: 1220 : 55|12:10:49.2577||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/Australia vs South Africa Match 45.mp4 t Transfer: 1220 : 55|12:10:49.2577||GetCurrentUser.. t Transfer: 1220 : 55|12:10:49.2577|| OAuth authenticated t Transfer: 1220 : 55|12:10:49.2577|| user TONY. t Transfer: 1220 : 47|12:10:49.3046||IsUserAuthenticated: /api/v3/detailsview/MediaDetails/5?lang=en-US&_dc=1575979849333 t Transfer: 1220 : 47|12:10:49.3046||GetCurrentUser.. t Transfer: 1220 : 47|12:10:49.3046|| OAuth authenticated t Transfer: 1220 : 47|12:10:49.3046|| user TONY. t Transfer: 1220 : 47|12:10:49.3046||api user: TONY t Transfer: 1220 : 55|12:10:49.3827||IsUserAuthenticated: /api/v3/layout/default/4?_dc=1575979849406 t Transfer: 1220 : 55|12:10:49.3827||GetCurrentUser.. t Transfer: 1220 : 55|12:10:49.3827|| OAuth authenticated t Transfer: 1220 : 55|12:10:49.3827|| user TONY. t Transfer: 1220 : 55|12:10:49.3827||api user: TONY t Information: 1220 : 55|12:10:49.3827||LoadDefaultDashboard. t Transfer: 1220 : 55|12:10:49.3827||GetCurrentUser.. t Transfer: 1220 : 55|12:10:49.3827|| OAuth authenticated t Transfer: 1220 : 55|12:10:49.3827|| user TONY. t Transfer: 1220 : 55|12:10:49.4921||IsUserAuthenticated: /api/lookups/FriendlyNames?_dc=1575979849500 t Transfer: 1220 : 55|12:10:49.4921||GetCurrentUser.. t Transfer: 1220 : 55|12:10:49.4921|| OAuth authenticated t Transfer: 1220 : 55|12:10:49.4921|| user TONY. t Transfer: 1220 : 55|12:10:49.4921||api user: TONY t Transfer: 1220 : 47|12:10:49.6015||IsUserAuthenticated: /api/user-group-preferences?globals=htmlplayerhotkeys,audioOnFrameForward&_dc=1575979849593 t Transfer: 1220 : 47|12:10:49.6015||GetCurrentUser.. t Transfer: 1220 : 47|12:10:49.6015|| OAuth authenticated t Transfer: 1220 : 47|12:10:49.6015|| user TONY. t Transfer: 1220 : 47|12:10:49.6015||api user: TONY t Information: 1220 : 47|12:10:49.6015||V3Api.GetUserSettings t Transfer: 1220 : 47|12:10:49.6015||GetCurrentUser.. t Transfer: 1220 : 47|12:10:49.6015|| OAuth authenticated t Transfer: 1220 : 47|12:10:49.6015|| user TONY. t Transfer: 1220 : 54|12:10:49.6327||IsUserAuthenticated: /api/mediavideo/298533?info=smudge,scene,audiovolume&_dc=1575979849603 t Transfer: 1220 : 54|12:10:49.6327||GetCurrentUser.. t Transfer: 1220 : 54|12:10:49.6327|| OAuth authenticated t Transfer: 1220 : 54|12:10:49.6327|| user TONY. t Transfer: 1220 : 54|12:10:49.6327||api user: TONY t Information: 1220 : 55|12:10:49.6483||V3Api.GetMediaTagging t Verbose: 1220 : 54|12:10:49.6483||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Australia vs South Africa Match 45.mp4 subfolder t Verbose: 1220 : 54|12:10:49.6483|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Australia vs South Africa Match 45.mp4 t Verbose: 1220 : 54|12:10:49.6483||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/Australia vs South Africa Match 45.mp4 t Transfer: 1220 : 54|12:10:49.6483||GetCurrentUser.. t Transfer: 1220 : 54|12:10:49.6483|| OAuth authenticated t Transfer: 1220 : 54|12:10:49.6483|| user TONY. t Transfer: 1220 : 5|12:10:49.7265||IsUserAuthenticated: /api/mediavideo/298533?info=smudge&_dc=1575979849757 t Transfer: 1220 : 5|12:10:49.7265||GetCurrentUser.. t Transfer: 1220 : 5|12:10:49.7265|| OAuth authenticated t Transfer: 1220 : 5|12:10:49.7265|| user TONY. t Transfer: 1220 : 5|12:10:49.7265||api user: TONY t Verbose: 1220 : 5|12:10:49.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 : 5|12:10:49.7421|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Australia vs South Africa Match 45.mp4 t Verbose: 1220 : 5|12:10:49.7421||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/Australia vs South Africa Match 45.mp4 t Transfer: 1220 : 5|12:10:49.7421||GetCurrentUser.. t Transfer: 1220 : 5|12:10:49.7421|| OAuth authenticated t Transfer: 1220 : 5|12:10:49.7421|| user TONY. t Transfer: 1220 : 45|12:10:49.8046||IsUserAuthenticated: /api/mediavideo/298533?info=smudge,scene,audiovolume&_dc=1575979849831 t Transfer: 1220 : 45|12:10:49.8046||GetCurrentUser.. t Transfer: 1220 : 45|12:10:49.8046|| OAuth authenticated t Transfer: 1220 : 45|12:10:49.8046|| user TONY. t Transfer: 1220 : 45|12:10:49.8046||api user: TONY t Verbose: 1220 : 45|12:10:49.8046||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Australia vs South Africa Match 45.mp4 subfolder t Verbose: 1220 : 45|12:10:49.8046|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Australia vs South Africa Match 45.mp4 t Verbose: 1220 : 45|12:10:49.8046||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/Australia vs South Africa Match 45.mp4 t Transfer: 1220 : 45|12:10:49.8046||GetCurrentUser.. t Transfer: 1220 : 45|12:10:49.8046|| OAuth authenticated t Transfer: 1220 : 45|12:10:49.8046|| user TONY. t Transfer: 1220 : 49|12:10:58.5233||IsUserAuthenticated: /api/user-preferences?_dc=1575979858508 t Transfer: 1220 : 49|12:10:58.5233||GetCurrentUser.. t Transfer: 1220 : 49|12:10:58.5233|| OAuth authenticated t Transfer: 1220 : 49|12:10:58.5233|| user TONY. t Transfer: 1220 : 49|12:10:58.5233||api user: TONY t Verbose: 1220 : 49|12:10:58.5233||StoreUserDataByKeys.. t Transfer: 1220 : 49|12:10:58.5233||GetCurrentUser.. t Transfer: 1220 : 49|12:10:58.5233|| OAuth authenticated t Transfer: 1220 : 49|12:10:58.5233|| user TONY. t Transfer: 1220 : 53|12:12:07.6952||IsUserAuthenticated: /api/v3/layout/default/4?_dc=1575979927663 t Transfer: 1220 : 53|12:12:07.6952||GetCurrentUser.. t Transfer: 1220 : 53|12:12:07.6952|| OAuth authenticated t Transfer: 1220 : 53|12:12:07.6952|| user TONY. t Transfer: 1220 : 53|12:12:07.6952||api user: TONY t Information: 1220 : 53|12:12:07.6952||LoadDefaultDashboard. t Transfer: 1220 : 53|12:12:07.6952||GetCurrentUser.. t Transfer: 1220 : 53|12:12:07.6952|| OAuth authenticated t Transfer: 1220 : 53|12:12:07.6952|| user TONY. t Transfer: 1220 : 55|12:12:08.0077||IsUserAuthenticated: /api/user-group-preferences?globals=htmlplayerhotkeys,audioOnFrameForward&_dc=1575979928037 t Transfer: 1220 : 55|12:12:08.0077||GetCurrentUser.. t Transfer: 1220 : 55|12:12:08.0077|| OAuth authenticated t Transfer: 1220 : 55|12:12:08.0077|| user TONY. t Transfer: 1220 : 55|12:12:08.0077||api user: TONY t Information: 1220 : 55|12:12:08.0077||V3Api.GetUserSettings t Transfer: 1220 : 55|12:12:08.0077||GetCurrentUser.. t Transfer: 1220 : 55|12:12:08.0077|| OAuth authenticated t Transfer: 1220 : 55|12:12:08.0077|| user TONY. t Transfer: 1220 : 55|12:12:08.0233||IsUserAuthenticated: /api/mediavideo/298533?info=smudge&_dc=1575979928053 t Transfer: 1220 : 55|12:12:08.0233||GetCurrentUser.. t Transfer: 1220 : 55|12:12:08.0233|| OAuth authenticated t Transfer: 1220 : 55|12:12:08.0233|| user TONY. t Transfer: 1220 : 55|12:12:08.0233||api user: TONY t Verbose: 1220 : 55|12:12:08.0233||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Australia vs South Africa Match 45.mp4 subfolder t Verbose: 1220 : 55|12:12:08.0233|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Australia vs South Africa Match 45.mp4 t Verbose: 1220 : 55|12:12:08.0233||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/Australia vs South Africa Match 45.mp4 t Transfer: 1220 : 55|12:12:08.0390||GetCurrentUser.. t Transfer: 1220 : 55|12:12:08.0390|| OAuth authenticated t Transfer: 1220 : 55|12:12:08.0390|| user TONY. t Transfer: 1220 : 46|12:15:33.3513||IsUserAuthenticated: /api/title-details/298279?_dc=1575980133335 t Transfer: 1220 : 46|12:15:33.3513||GetCurrentUser.. t Transfer: 1220 : 46|12:15:33.3513|| OAuth authenticated t Transfer: 1220 : 46|12:15:33.3513|| user TONY. t Transfer: 1220 : 46|12:15:33.3513||api user: TONY t Transfer: 1220 : 14|12:15:33.5388||IsUserAuthenticated: /api/search/title?_dc=1575980133536 t Transfer: 1220 : 14|12:15:33.5388||GetCurrentUser.. t Transfer: 1220 : 14|12:15:33.5388|| OAuth authenticated t Transfer: 1220 : 14|12:15:33.5388|| user TONY. t Transfer: 1220 : 14|12:15:33.5388||api user: TONY t Information: 1220 : 14|12:15:33.5388||V3Api.SearchTitles t Information: 1220 : 14|12:15:33.5388||V3Api.SearchGeneric t Transfer: 1220 : 14|12:15:33.5388||GetCurrentUser.. t Transfer: 1220 : 14|12:15:33.5388|| OAuth authenticated t Transfer: 1220 : 14|12:15:33.5388|| user TONY. t Transfer: 1220 : 14|12:15:33.5388||GetCurrentUser.. t Transfer: 1220 : 14|12:15:33.5388|| OAuth authenticated t Transfer: 1220 : 14|12:15:33.5388|| user TONY. t Information: 1220 : 14|12:15:33.5388||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 : 12|12:16:37.3356||IsUserAuthenticated: /api/search/title?_dc=1575980197361 t Transfer: 1220 : 12|12:16:37.3356||GetCurrentUser.. t Transfer: 1220 : 12|12:16:37.3356|| OAuth authenticated t Transfer: 1220 : 12|12:16:37.3356|| user TONY. t Transfer: 1220 : 12|12:16:37.3356||api user: TONY t Information: 1220 : 12|12:16:37.3356||V3Api.SearchTitles t Information: 1220 : 12|12:16:37.3356||V3Api.SearchGeneric t Transfer: 1220 : 12|12:16:37.3356||GetCurrentUser.. t Transfer: 1220 : 12|12:16:37.3356|| OAuth authenticated t Transfer: 1220 : 12|12:16:37.3356|| user TONY. t Transfer: 1220 : 12|12:16:37.3356||GetCurrentUser.. t Transfer: 1220 : 12|12:16:37.3356|| OAuth authenticated t Transfer: 1220 : 12|12:16:37.3356|| user TONY. t Information: 1220 : 12|12:16:37.3513||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 : 14|12:16:37.5231||IsUserAuthenticated: /api/int/title/298279/versions?_dc=1575980197541 t Transfer: 1220 : 14|12:16:37.5231||GetCurrentUser.. t Transfer: 1220 : 14|12:16:37.5231|| OAuth authenticated t Transfer: 1220 : 14|12:16:37.5231|| user TONY. t Transfer: 1220 : 14|12:16:37.5231||api user: TONY t Information: 1220 : 14|12:16:37.5231||V3Api.GetVersionsByTitleIdAdv t Information: 1220 : 14|12:16:37.5231||V3Api.SearchGeneric t Transfer: 1220 : 14|12:16:37.5388||GetCurrentUser.. t Transfer: 1220 : 14|12:16:37.5388|| OAuth authenticated t Transfer: 1220 : 14|12:16:37.5388|| user TONY. t Transfer: 1220 : 14|12:16:37.5388||GetCurrentUser.. t Transfer: 1220 : 14|12:16:37.5388|| OAuth authenticated t Transfer: 1220 : 14|12:16:37.5388|| user TONY. t Information: 1220 : 14|12:16:37.5388||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=298279 order by m.title, m.id ) a where rownum <= 9999) r where rnum >=1 order by rnum t Information: 1220 : 14|12:16:37.5700||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: 29ms. 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=298279 order by m.title, m.id ) a where rownum <= 9999) r where rnum >=1 order by rnum t Transfer: 1220 : 29|12:17:31.0231||IsUserAuthenticated: /api/metadata/1000/298279?_dc=1575980251034 t Transfer: 1220 : 29|12:17:31.0231||GetCurrentUser.. t Transfer: 1220 : 29|12:17:31.0231|| OAuth authenticated t Transfer: 1220 : 29|12:17:31.0231|| user TONY. t Transfer: 1220 : 29|12:17:31.0231||api user: TONY t Transfer: 1220 : 14|12:17:58.0544||IsUserAuthenticated: /api/SearchSuggestion/?_dc=1575980277692 t Transfer: 1220 : 14|12:17:58.0544||GetCurrentUser.. t Transfer: 1220 : 14|12:17:58.0544|| OAuth authenticated t Transfer: 1220 : 14|12:17:58.0544|| user TONY. t Transfer: 1220 : 14|12:17:58.0544||api user: TONY t Transfer: 1220 : 14|12:17:58.0544||GetCurrentUser.. t Transfer: 1220 : 14|12:17:58.0544|| OAuth authenticated t Transfer: 1220 : 14|12:17:58.0544|| user TONY. t Transfer: 1220 : 62|12:18:26.3669||IsUserAuthenticated: /api/title-details/298279?_dc=1575980306170 t Transfer: 1220 : 62|12:18:26.3669||GetCurrentUser.. t Transfer: 1220 : 62|12:18:26.3669|| OAuth authenticated t Transfer: 1220 : 62|12:18:26.3669|| user TONY. t Transfer: 1220 : 62|12:18:26.3669||api user: TONY t Transfer: 1220 : 58|12:18:26.5544||IsUserAuthenticated: /api/search/title?_dc=1575980306512 t Transfer: 1220 : 58|12:18:26.5544||GetCurrentUser.. t Transfer: 1220 : 58|12:18:26.5544|| OAuth authenticated t Transfer: 1220 : 58|12:18:26.5544|| user TONY. t Transfer: 1220 : 58|12:18:26.5544||api user: TONY t Information: 1220 : 58|12:18:26.5544||V3Api.SearchTitles t Information: 1220 : 58|12:18:26.5544||V3Api.SearchGeneric t Transfer: 1220 : 58|12:18:26.5544||GetCurrentUser.. t Transfer: 1220 : 58|12:18:26.5544|| OAuth authenticated t Transfer: 1220 : 58|12:18:26.5544|| user TONY. t Transfer: 1220 : 58|12:18:26.5544||GetCurrentUser.. t Transfer: 1220 : 58|12:18:26.5544|| OAuth authenticated t Transfer: 1220 : 58|12:18:26.5544|| user TONY. t Information: 1220 : 58|12:18:26.5544||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 : 62|12:18:26.7575||IsUserAuthenticated: /api/metadata/1000/298279?_dc=1575980306731 t Transfer: 1220 : 62|12:18:26.7575||GetCurrentUser.. t Transfer: 1220 : 62|12:18:26.7575|| OAuth authenticated t Transfer: 1220 : 62|12:18:26.7575|| user TONY. t Transfer: 1220 : 62|12:18:26.7575||api user: TONY t Transfer: 1220 : 14|12:18:26.7732||IsUserAuthenticated: /api/int/title/298279/versions?_dc=1575980306730 t Transfer: 1220 : 14|12:18:26.7732||GetCurrentUser.. t Transfer: 1220 : 14|12:18:26.7732|| OAuth authenticated t Transfer: 1220 : 14|12:18:26.7732|| user TONY. t Transfer: 1220 : 14|12:18:26.7732||api user: TONY t Information: 1220 : 14|12:18:26.7732||V3Api.GetVersionsByTitleIdAdv t Information: 1220 : 14|12:18:26.7732||V3Api.SearchGeneric t Transfer: 1220 : 14|12:18:26.7732||GetCurrentUser.. t Transfer: 1220 : 14|12:18:26.7732|| OAuth authenticated t Transfer: 1220 : 14|12:18:26.7732|| user TONY. t Transfer: 1220 : 14|12:18:26.7732||GetCurrentUser.. t Transfer: 1220 : 14|12:18:26.7732|| OAuth authenticated t Transfer: 1220 : 14|12:18:26.7732|| user TONY. t Information: 1220 : 14|12:18:26.7732||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=298279 order by m.title, m.id ) a where rownum <= 9999) r where rnum >=1 order by rnum t Information: 1220 : 14|12:18:26.7887||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: 11ms. 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=298279 order by m.title, m.id ) a where rownum <= 9999) r where rnum >=1 order by rnum t Transfer: 1220 : 14|12:19:14.2263||IsUserAuthenticated: /api/title-details/298279?_dc=1575980354208 t Transfer: 1220 : 14|12:19:14.2263||GetCurrentUser.. t Transfer: 1220 : 14|12:19:14.2263|| OAuth authenticated t Transfer: 1220 : 14|12:19:14.2263|| user TONY. t Transfer: 1220 : 14|12:19:14.2263||api user: TONY t Transfer: 1220 : 24|12:19:14.4294||IsUserAuthenticated: /api/search/title?_dc=1575980354385 t Transfer: 1220 : 24|12:19:14.4294||GetCurrentUser.. t Transfer: 1220 : 24|12:19:14.4294|| OAuth authenticated t Transfer: 1220 : 24|12:19:14.4294|| user TONY. t Transfer: 1220 : 24|12:19:14.4294||api user: TONY t Information: 1220 : 24|12:19:14.4294||V3Api.SearchTitles t Information: 1220 : 24|12:19:14.4294||V3Api.SearchGeneric t Transfer: 1220 : 24|12:19:14.4294||GetCurrentUser.. t Transfer: 1220 : 24|12:19:14.4294|| OAuth authenticated t Transfer: 1220 : 24|12:19:14.4294|| user TONY. t Transfer: 1220 : 24|12:19:14.4294||GetCurrentUser.. t Transfer: 1220 : 24|12:19:14.4294|| OAuth authenticated t Transfer: 1220 : 24|12:19:14.4294|| user TONY. t Information: 1220 : 24|12:19:14.4294||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 : 57|12:19:14.5700||IsUserAuthenticated: /api/metadata/1000/298279?_dc=1575980354600 t Transfer: 1220 : 57|12:19:14.5700||GetCurrentUser.. t Transfer: 1220 : 57|12:19:14.5700|| OAuth authenticated t Transfer: 1220 : 57|12:19:14.5700|| user TONY. t Transfer: 1220 : 57|12:19:14.5700||api user: TONY t Transfer: 1220 : 46|12:19:14.6169||IsUserAuthenticated: /api/int/title/298279/versions?_dc=1575980354597 t Transfer: 1220 : 46|12:19:14.6169||GetCurrentUser.. t Transfer: 1220 : 46|12:19:14.6169|| OAuth authenticated t Transfer: 1220 : 46|12:19:14.6169|| user TONY. t Transfer: 1220 : 46|12:19:14.6169||api user: TONY t Information: 1220 : 46|12:19:14.6169||V3Api.GetVersionsByTitleIdAdv t Information: 1220 : 46|12:19:14.6169||V3Api.SearchGeneric t Transfer: 1220 : 46|12:19:14.6169||GetCurrentUser.. t Transfer: 1220 : 46|12:19:14.6169|| OAuth authenticated t Transfer: 1220 : 46|12:19:14.6169|| user TONY. t Transfer: 1220 : 46|12:19:14.6169||GetCurrentUser.. t Transfer: 1220 : 46|12:19:14.6169|| OAuth authenticated t Transfer: 1220 : 46|12:19:14.6169|| user TONY. t Information: 1220 : 46|12:19:14.6169||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=298279 order by m.title, m.id ) a where rownum <= 9999) r where rnum >=1 order by rnum t Information: 1220 : 46|12:19:14.6326||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: 10ms. 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=298279 order by m.title, m.id ) a where rownum <= 9999) r where rnum >=1 order by rnum t Transfer: 1220 : 46|12:19:29.5388||IsUserAuthenticated: /api/search/title?_dc=1575980369550 t Transfer: 1220 : 46|12:19:29.5388||GetCurrentUser.. t Transfer: 1220 : 46|12:19:29.5388|| OAuth authenticated t Transfer: 1220 : 46|12:19:29.5388|| user TONY. t Transfer: 1220 : 46|12:19:29.5388||api user: TONY t Information: 1220 : 46|12:19:29.5388||V3Api.SearchTitles t Information: 1220 : 46|12:19:29.5388||V3Api.SearchGeneric t Transfer: 1220 : 46|12:19:29.5388||GetCurrentUser.. t Transfer: 1220 : 46|12:19:29.5388|| OAuth authenticated t Transfer: 1220 : 46|12:19:29.5388|| user TONY. t Transfer: 1220 : 46|12:19:29.5388||GetCurrentUser.. t Transfer: 1220 : 46|12:19:29.5388|| OAuth authenticated t Transfer: 1220 : 46|12:19:29.5388|| user TONY. t Information: 1220 : 46|12:19:29.5388||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 : 11|12:19:29.6950||IsUserAuthenticated: /api/int/title/298279/versions?_dc=1575980369732 t Transfer: 1220 : 11|12:19:29.6950||GetCurrentUser.. t Transfer: 1220 : 11|12:19:29.6950|| OAuth authenticated t Transfer: 1220 : 11|12:19:29.6950|| user TONY. t Transfer: 1220 : 11|12:19:29.6950||api user: TONY t Information: 1220 : 11|12:19:29.6950||V3Api.GetVersionsByTitleIdAdv t Information: 1220 : 11|12:19:29.6950||V3Api.SearchGeneric t Transfer: 1220 : 11|12:19:29.6950||GetCurrentUser.. t Transfer: 1220 : 11|12:19:29.6950|| OAuth authenticated t Transfer: 1220 : 11|12:19:29.6950|| user TONY. t Transfer: 1220 : 11|12:19:29.6950||GetCurrentUser.. t Transfer: 1220 : 11|12:19:29.6950|| OAuth authenticated t Transfer: 1220 : 11|12:19:29.6950|| user TONY. t Information: 1220 : 11|12:19:29.7107||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=298279 order by m.title, m.id ) a where rownum <= 9999) r where rnum >=1 order by rnum t Information: 1220 : 11|12:19:29.7107||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=298279 order by m.title, m.id ) a where rownum <= 9999) r where rnum >=1 order by rnum t Transfer: 1220 : 34|12:19:53.0075||IsUserAuthenticated: /api/v3/config/servicexml/types?_dc=1575980393043 t Transfer: 1220 : 34|12:19:53.0075||GetCurrentUser.. t Transfer: 1220 : 34|12:19:53.0075|| OAuth authenticated t Transfer: 1220 : 34|12:19:53.0075|| user TONY. t Transfer: 1220 : 34|12:19:53.0075||api user: TONY t Transfer: 1220 : 14|12:19:53.0544||IsUserAuthenticated: /api/settings/groups/?_dc=1575980393080 t Transfer: 1220 : 14|12:19:53.0544||GetCurrentUser.. t Transfer: 1220 : 14|12:19:53.0544|| OAuth authenticated t Transfer: 1220 : 14|12:19:53.0544|| user TONY. t Transfer: 1220 : 14|12:19:53.0544||api user: TONY t Information: 1220 : 14|12:19:53.0544||V3Api.GetSettingsGroupsNames t Transfer: 1220 : 58|12:20:00.6013||IsUserAuthenticated: /api/v3/config/location-views?_dc=1575980400631 t Transfer: 1220 : 58|12:20:00.6013||GetCurrentUser.. t Transfer: 1220 : 58|12:20:00.6013|| OAuth authenticated t Transfer: 1220 : 58|12:20:00.6013|| user TONY. t Transfer: 1220 : 58|12:20:00.6013||api user: TONY t Information: 1220 : 58|12:20:00.6013||Get location views t Information: 1220 : 58|12:20:00.6013||GetLocationDefaultViews. t Transfer: 1220 : 62|12:20:20.7107||IsUserAuthenticated: /api/v3/config/users?showDisabled=true&_dc=1575980420739 t Transfer: 1220 : 62|12:20:20.7107||GetCurrentUser.. t Transfer: 1220 : 62|12:20:20.7107|| OAuth authenticated t Transfer: 1220 : 62|12:20:20.7107|| user TONY. t Transfer: 1220 : 62|12:20:20.7107||api user: TONY t Information: 1220 : 62|12:20:20.7107||GetUsersFiltered t Transfer: 1220 : 61|12:20:32.6638||IsUserAuthenticated: /api/lookups/Departments?_dc=1575980432697 t Transfer: 1220 : 14|12:20:32.6638||IsUserAuthenticated: /api/lookups/Devices?_dc=1575980432698 t Transfer: 1220 : 14|12:20:32.6638||GetCurrentUser.. t Transfer: 1220 : 14|12:20:32.6638|| OAuth authenticated t Transfer: 1220 : 14|12:20:32.6638|| user TONY. t Transfer: 1220 : 14|12:20:32.6638||api user: TONY t Transfer: 1220 : 61|12:20:32.6638||GetCurrentUser.. t Transfer: 1220 : 61|12:20:32.6638|| OAuth authenticated t Transfer: 1220 : 61|12:20:32.6638|| user TONY. t Transfer: 1220 : 61|12:20:32.6638||api user: TONY t Transfer: 1220 : 62|12:20:32.7263||IsUserAuthenticated: /api/settings/groups/?_dc=1575980432764 t Transfer: 1220 : 62|12:20:32.7263||GetCurrentUser.. t Transfer: 1220 : 62|12:20:32.7263|| OAuth authenticated t Transfer: 1220 : 62|12:20:32.7263|| user TONY. t Transfer: 1220 : 62|12:20:32.7263||api user: TONY t Information: 1220 : 62|12:20:32.7263||V3Api.GetSettingsGroupsNames t Transfer: 1220 : 58|12:20:32.7419||IsUserAuthenticated: /api/v3/config/user/522?_dc=1575980432763 t Transfer: 1220 : 58|12:20:32.7419||GetCurrentUser.. t Transfer: 1220 : 58|12:20:32.7419|| OAuth authenticated t Transfer: 1220 : 58|12:20:32.7419|| user TONY. t Transfer: 1220 : 58|12:20:32.7419||api user: TONY t Information: 1220 : 58|12:20:32.7419||GetUserById 522 t Information: 1220 : 58|12:20:33.0075||GetUserDbaMode t Information: 1220 : 58|12:20:33.0075||GetUserOracleStatus t Transfer: 1220 : 58|12:20:33.2419||IsUserAuthenticated: /api/lookup/locations/search/?_dc=1575980433276 t Transfer: 1220 : 58|12:20:33.2419||GetCurrentUser.. t Transfer: 1220 : 58|12:20:33.2419|| OAuth authenticated t Transfer: 1220 : 58|12:20:33.2419|| user TONY. t Transfer: 1220 : 58|12:20:33.2419||api user: TONY t Transfer: 1220 : 53|12:23:19.6950||IsUserAuthenticated: /api/v3/config/user/rebuild-view?_dc=1575980599654 t Transfer: 1220 : 53|12:23:19.6950||GetCurrentUser.. t Transfer: 1220 : 53|12:23:19.6950|| OAuth authenticated t Transfer: 1220 : 53|12:23:19.6950|| user TONY. t Transfer: 1220 : 53|12:23:19.6950||api user: TONY t Information: 1220 : 53|12:23:19.6950||RebuildUsersViews t Information: 1220 : 53|12:23:19.6950||RebuildUsersViews. Rebuilding views: 1 t Information: 1220 : 53|12:23:19.6950||RebuildUserViews: TONY t Information: 1220 : 53|12:23:20.2731||RebuildUserViews. TONY executed: 00:00:00.5744094 t Information: 1220 : 53|12:23:20.2731||RebuildUsersViewsParallel. executed: 00:00:00.5750911. users 1. threads 1. t Transfer: 1220 : 42|12:23:30.3981||IsUserAuthenticated: /api/title-details/298279?_dc=1575980610380 t Transfer: 1220 : 42|12:23:30.3981||GetCurrentUser.. t Transfer: 1220 : 42|12:23:30.3981|| OAuth authenticated t Transfer: 1220 : 42|12:23:30.3981|| user TONY. t Transfer: 1220 : 42|12:23:30.3981||api user: TONY t Transfer: 1220 : 39|12:23:30.5856||IsUserAuthenticated: /api/search/title?_dc=1575980610547 t Transfer: 1220 : 39|12:23:30.5856||GetCurrentUser.. t Transfer: 1220 : 39|12:23:30.5856|| OAuth authenticated t Transfer: 1220 : 39|12:23:30.5856|| user TONY. t Transfer: 1220 : 39|12:23:30.5856||api user: TONY t Information: 1220 : 39|12:23:30.5856||V3Api.SearchTitles t Information: 1220 : 39|12:23:30.5856||V3Api.SearchGeneric t Transfer: 1220 : 39|12:23:30.5856||GetCurrentUser.. t Transfer: 1220 : 39|12:23:30.5856|| OAuth authenticated t Transfer: 1220 : 39|12:23:30.5856|| user TONY. t Transfer: 1220 : 39|12:23:30.5856||GetCurrentUser.. t Transfer: 1220 : 39|12:23:30.5856|| OAuth authenticated t Transfer: 1220 : 39|12:23:30.5856|| user TONY. t Information: 1220 : 39|12:23:30.6013||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 : 61|12:23:30.7419||IsUserAuthenticated: /api/int/title/298279/versions?_dc=1575980610762 t Transfer: 1220 : 61|12:23:30.7419||GetCurrentUser.. t Transfer: 1220 : 61|12:23:30.7419|| OAuth authenticated t Transfer: 1220 : 61|12:23:30.7419|| user TONY. t Transfer: 1220 : 61|12:23:30.7419||api user: TONY t Information: 1220 : 61|12:23:30.7419||V3Api.GetVersionsByTitleIdAdv t Information: 1220 : 61|12:23:30.7419||V3Api.SearchGeneric t Transfer: 1220 : 61|12:23:30.7419||GetCurrentUser.. t Transfer: 1220 : 61|12:23:30.7419|| OAuth authenticated t Transfer: 1220 : 61|12:23:30.7419|| user TONY. t Transfer: 1220 : 61|12:23:30.7419||GetCurrentUser.. t Transfer: 1220 : 61|12:23:30.7419|| OAuth authenticated t Transfer: 1220 : 61|12:23:30.7419|| user TONY. t Information: 1220 : 61|12:23:30.7575||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=298279 order by m.title, m.id ) a where rownum <= 9999) r where rnum >=1 order by rnum t Information: 1220 : 61|12:23:30.7575||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: 2ms. 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=298279 order by m.title, m.id ) a where rownum <= 9999) r where rnum >=1 order by rnum t Transfer: 1220 : 61|12:23:49.6481||IsUserAuthenticated: /api/metadata/1000/298279?_dc=1575980629671 t Transfer: 1220 : 61|12:23:49.6481||GetCurrentUser.. t Transfer: 1220 : 61|12:23:49.6481|| OAuth authenticated t Transfer: 1220 : 61|12:23:49.6481|| user TONY. t Transfer: 1220 : 61|12:23:49.6481||api user: TONY t Transfer: 1220 : 40|12:24:28.6638||IsUserAuthenticated: /api/view/searchinfo/Version?_dc=1575980668684 t Transfer: 1220 : 40|12:24:28.6638||GetCurrentUser.. t Transfer: 1220 : 40|12:24:28.6638|| OAuth authenticated t Transfer: 1220 : 40|12:24:28.6638|| user TONY. t Transfer: 1220 : 40|12:24:28.6638||api user: TONY t Information: 1220 : 40|12:24:28.6638||GetAdvSearchColumns. search type Version grid . t Transfer: 1220 : 44|12:24:28.6950||IsUserAuthenticated: /api/user-preferences?keys=adv.recent.searches.versions&_dc=1575980668685 t Transfer: 1220 : 44|12:24:28.6950||GetCurrentUser.. t Transfer: 1220 : 44|12:24:28.6950|| OAuth authenticated t Transfer: 1220 : 44|12:24:28.6950|| user TONY. t Transfer: 1220 : 44|12:24:28.6950||api user: TONY t Information: 1220 : 44|12:24:28.6950||GetUserDataByKeys: adv.recent.searches.versions t Transfer: 1220 : 44|12:24:28.6950||GetCurrentUser.. t Transfer: 1220 : 44|12:24:28.6950|| OAuth authenticated t Transfer: 1220 : 44|12:24:28.6950|| user TONY. t Transfer: 1220 : 40|12:24:28.6950||IsUserAuthenticated: /api/settings/user/searchLayoutConfig?_dc=1575980668687 t Transfer: 1220 : 40|12:24:28.6950||GetCurrentUser.. t Transfer: 1220 : 40|12:24:28.6950|| OAuth authenticated t Transfer: 1220 : 40|12:24:28.6950|| user TONY. t Transfer: 1220 : 40|12:24:28.6950||api user: TONY t Information: 1220 : 40|12:24:28.6950||V3Api.GetUserSettings t Transfer: 1220 : 40|12:24:28.6950||GetCurrentUser.. t Transfer: 1220 : 40|12:24:28.6950|| OAuth authenticated t Transfer: 1220 : 40|12:24:28.6950|| user TONY. t Transfer: 1220 : 61|12:24:28.7107||IsUserAuthenticated: /api/view/searches/Version?_dc=1575980668713 t Transfer: 1220 : 61|12:24:28.7107||GetCurrentUser.. t Transfer: 1220 : 61|12:24:28.7107|| OAuth authenticated t Transfer: 1220 : 61|12:24:28.7107|| user TONY. t Transfer: 1220 : 61|12:24:28.7107||api user: TONY t Information: 1220 : 61|12:24:28.7107||GetSavedSearchNames. search type Version. t Transfer: 1220 : 61|12:24:28.7107||GetCurrentUser.. t Transfer: 1220 : 61|12:24:28.7107|| OAuth authenticated t Transfer: 1220 : 61|12:24:28.7107|| user TONY. t Transfer: 1220 : 44|12:24:32.3200||IsUserAuthenticated: /api/SearchSuggestion/?_dc=1575980672331 t Transfer: 1220 : 44|12:24:32.3200||GetCurrentUser.. t Transfer: 1220 : 44|12:24:32.3200|| OAuth authenticated t Transfer: 1220 : 44|12:24:32.3200|| user TONY. t Transfer: 1220 : 44|12:24:32.3200||api user: TONY t Transfer: 1220 : 44|12:24:32.3200||GetCurrentUser.. t Transfer: 1220 : 44|12:24:32.3200|| OAuth authenticated t Transfer: 1220 : 44|12:24:32.3200|| user TONY. t Transfer: 1220 : 12|12:24:32.5387||IsUserAuthenticated: /api/search/versions?_dc=1575980672566 t Transfer: 1220 : 12|12:24:32.5387||GetCurrentUser.. t Transfer: 1220 : 12|12:24:32.5387|| OAuth authenticated t Transfer: 1220 : 12|12:24:32.5387|| user TONY. t Transfer: 1220 : 12|12:24:32.5387||api user: TONY t Information: 1220 : 12|12:24:32.5387||V3Api.SearchVersions t Information: 1220 : 12|12:24:32.5387||V3Api.SearchGeneric t Transfer: 1220 : 12|12:24:32.5387||GetCurrentUser.. t Transfer: 1220 : 12|12:24:32.5387|| OAuth authenticated t Transfer: 1220 : 12|12:24:32.5387|| user TONY. t Transfer: 1220 : 12|12:24:32.5544||GetCurrentUser.. t Transfer: 1220 : 12|12:24:32.5544|| OAuth authenticated t Transfer: 1220 : 12|12:24:32.5544|| user TONY. t Information: 1220 : 12|12:24:32.5700||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,(select /*+ cardinality(4) */ rownum rn, column_value id from table(:ids)) ids where item_type>0 and rl_deleted=0 and m.id = ids.id order by ids.rn ) a where rownum <= 10000) r where rnum >=1 order by rnum t Information: 1220 : 12|12:24:32.6794||Running version search. User: 522 Simple Search: icc Trying to use Solr Search... Solr completed in: 31ms. Returned lines: 36 Running Oracle search. Oracle version search timing: 102ms. 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,(select /*+ cardinality(4) */ rownum rn, column_value id from table(:ids)) ids where item_type>0 and rl_deleted=0 and m.id = ids.id order by ids.rn ) a where rownum <= 10000) r where rnum >=1 order by rnum t Transfer: 1220 : 12|12:24:32.9137||IsUserAuthenticated: /api/user-preferences?_dc=1575980672936 t Transfer: 1220 : 12|12:24:32.9137||GetCurrentUser.. t Transfer: 1220 : 12|12:24:32.9137|| OAuth authenticated t Transfer: 1220 : 12|12:24:32.9137|| user TONY. t Transfer: 1220 : 12|12:24:32.9137||api user: TONY t Verbose: 1220 : 12|12:24:32.9137||StoreUserDataByKeys.. t Transfer: 1220 : 12|12:24:32.9137||GetCurrentUser.. t Transfer: 1220 : 12|12:24:32.9137|| OAuth authenticated t Transfer: 1220 : 12|12:24:32.9137|| user TONY. t Transfer: 1220 : 12|12:24:41.1169||IsUserAuthenticated: /api/version-details/298372?_dc=1575980681147 t Transfer: 1220 : 12|12:24:41.1169||GetCurrentUser.. t Transfer: 1220 : 12|12:24:41.1169|| OAuth authenticated t Transfer: 1220 : 12|12:24:41.1169|| user TONY. t Transfer: 1220 : 12|12:24:41.1169||api user: TONY t Transfer: 1220 : 12|12:24:41.1169||GetCurrentUser.. t Transfer: 1220 : 12|12:24:41.1169|| OAuth authenticated t Transfer: 1220 : 12|12:24:41.1325|| user TONY. t Transfer: 1220 : 59|12:24:41.3200||IsUserAuthenticated: /api/v3/detailsview/VersionDetails/0?lang=en-US&_dc=1575980681349 t Transfer: 1220 : 59|12:24:41.3200||GetCurrentUser.. t Transfer: 1220 : 59|12:24:41.3200|| OAuth authenticated t Transfer: 1220 : 59|12:24:41.3200|| user TONY. t Transfer: 1220 : 59|12:24:41.3200||api user: TONY t Transfer: 1220 : 13|12:24:41.4137||IsUserAuthenticated: /api/lookups/FriendlyNames?_dc=1575980681439 t Transfer: 1220 : 13|12:24:41.4137||GetCurrentUser.. t Transfer: 1220 : 13|12:24:41.4137|| OAuth authenticated t Transfer: 1220 : 13|12:24:41.4137|| user TONY. t Transfer: 1220 : 13|12:24:41.4137||api user: TONY t Transfer: 1220 : 44|12:24:41.4606||IsUserAuthenticated: /api/v3/imf/298372?_dc=1575980681491 t Transfer: 1220 : 44|12:24:41.4606||GetCurrentUser.. t Transfer: 1220 : 44|12:24:41.4606|| OAuth authenticated t Transfer: 1220 : 44|12:24:41.4606|| user TONY. t Transfer: 1220 : 44|12:24:41.4606||api user: TONY t Transfer: 1220 : 40|12:24:41.4762||IsUserAuthenticated: /api/search/title?_dc=1575980681512 t Transfer: 1220 : 40|12:24:41.4762||GetCurrentUser.. t Transfer: 1220 : 40|12:24:41.4762|| OAuth authenticated t Transfer: 1220 : 40|12:24:41.4762|| user TONY. t Transfer: 1220 : 40|12:24:41.4762||api user: TONY t Information: 1220 : 40|12:24:41.4762||V3Api.SearchTitles t Information: 1220 : 40|12:24:41.4762||V3Api.SearchGeneric t Transfer: 1220 : 40|12:24:41.4762||GetCurrentUser.. t Transfer: 1220 : 40|12:24:41.4762|| OAuth authenticated t Transfer: 1220 : 40|12:24:41.4762|| user TONY. t Transfer: 1220 : 40|12:24:41.4762||GetCurrentUser.. t Transfer: 1220 : 40|12:24:41.4762|| OAuth authenticated t Transfer: 1220 : 40|12:24:41.4762|| user TONY. t Information: 1220 : 40|12:24:41.4919||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('298371') 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 : 48|12:24:41.7419||IsUserAuthenticated: /api/metadata/1040/298372?_dc=1575980681769 t Transfer: 1220 : 48|12:24:41.7419||GetCurrentUser.. t Transfer: 1220 : 48|12:24:41.7419|| OAuth authenticated t Transfer: 1220 : 48|12:24:41.7419|| user TONY. t Transfer: 1220 : 48|12:24:41.7419||api user: TONY t Transfer: 1220 : 13|12:24:54.4294||IsUserAuthenticated: /api/int/version/298372/media?_dc=1575980694463 t Transfer: 1220 : 13|12:24:54.4294||GetCurrentUser.. t Transfer: 1220 : 13|12:24:54.4294|| OAuth authenticated t Transfer: 1220 : 13|12:24:54.4450|| user TONY. t Transfer: 1220 : 13|12:24:54.4450||api user: TONY t Information: 1220 : 13|12:24:54.4450||V3Api.GetMediaByVersionIdAdv t Information: 1220 : 13|12:24:54.4450||V3Api.SearchGeneric t Transfer: 1220 : 13|12:24:54.4450||GetCurrentUser.. t Transfer: 1220 : 13|12:24:54.4450|| OAuth authenticated t Transfer: 1220 : 13|12:24:54.4450|| user TONY. t Information: 1220 : 13|12:24:54.4450||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: 298372 t Information: 1220 : 13|12:24:54.5544|| timing: 00:00:00.1097380 t Verbose: 1220 : 13|12:24:54.5544||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Australia vs South Africa Match 45.mp4 subfolder t Verbose: 1220 : 13|12:24:54.5544|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Australia vs South Africa Match 45.mp4 t Verbose: 1220 : 13|12:24:54.5544||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/Australia vs South Africa Match 45.mp4 t Transfer: 1220 : 13|12:24:54.5544||GetCurrentUser.. t Transfer: 1220 : 13|12:24:54.5544|| OAuth authenticated t Transfer: 1220 : 13|12:24:54.5544|| user TONY. t Transfer: 1220 : 12|12:25:05.3669||IsUserAuthenticated: /api/user-group-preferences?globals=htmlplayerhotkeys,audioOnFrameForward&_dc=1575980705392 t Transfer: 1220 : 12|12:25:05.3669||GetCurrentUser.. t Transfer: 1220 : 12|12:25:05.3669|| OAuth authenticated t Transfer: 1220 : 12|12:25:05.3669|| user TONY. t Transfer: 1220 : 12|12:25:05.3669||api user: TONY t Information: 1220 : 12|12:25:05.3669||V3Api.GetUserSettings t Transfer: 1220 : 12|12:25:05.3669||GetCurrentUser.. t Transfer: 1220 : 12|12:25:05.3669|| OAuth authenticated t Transfer: 1220 : 12|12:25:05.3669|| user TONY. t Transfer: 1220 : 59|12:25:07.3669||IsUserAuthenticated: /api/user-group-preferences?globals=htmlplayerhotkeys,audioOnFrameForward&_dc=1575980707394 t Transfer: 1220 : 59|12:25:07.3669||GetCurrentUser.. t Transfer: 1220 : 59|12:25:07.3669|| OAuth authenticated t Transfer: 1220 : 59|12:25:07.3669|| user TONY. t Transfer: 1220 : 59|12:25:07.3669||api user: TONY t Information: 1220 : 59|12:25:07.3669||V3Api.GetUserSettings t Transfer: 1220 : 59|12:25:07.3669||GetCurrentUser.. t Transfer: 1220 : 59|12:25:07.3669|| OAuth authenticated t Transfer: 1220 : 59|12:25:07.3669|| user TONY. t Transfer: 1220 : 48|12:25:07.4450||IsUserAuthenticated: /api/mediavideo/298533?info=smudge&_dc=1575980707480 t Transfer: 1220 : 48|12:25:07.4450||GetCurrentUser.. t Transfer: 1220 : 48|12:25:07.4450|| OAuth authenticated t Transfer: 1220 : 48|12:25:07.4450|| user TONY. t Transfer: 1220 : 48|12:25:07.4450||api user: TONY t Verbose: 1220 : 48|12:25:07.4606||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Australia vs South Africa Match 45.mp4 subfolder t Verbose: 1220 : 48|12:25:07.4606|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Australia vs South Africa Match 45.mp4 t Verbose: 1220 : 48|12:25:07.4606||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/Australia vs South Africa Match 45.mp4 t Transfer: 1220 : 48|12:25:07.4606||GetCurrentUser.. t Transfer: 1220 : 48|12:25:07.4606|| OAuth authenticated t Transfer: 1220 : 48|12:25:07.4606|| user TONY. t Transfer: 1220 : 12|12:25:48.6012||IsUserAuthenticated: /api/title-details/298279?_dc=1575980748470 t Transfer: 1220 : 12|12:25:48.6012||GetCurrentUser.. t Transfer: 1220 : 12|12:25:48.6012|| OAuth authenticated t Transfer: 1220 : 12|12:25:48.6012|| user TONY. t Transfer: 1220 : 12|12:25:48.6012||api user: TONY t Transfer: 1220 : 40|12:25:48.8044||IsUserAuthenticated: /api/search/title?_dc=1575980748838 t Transfer: 1220 : 40|12:25:48.8044||GetCurrentUser.. t Transfer: 1220 : 40|12:25:48.8044|| OAuth authenticated t Transfer: 1220 : 40|12:25:48.8044|| user TONY. t Transfer: 1220 : 40|12:25:48.8044||api user: TONY t Information: 1220 : 40|12:25:48.8044||V3Api.SearchTitles t Information: 1220 : 40|12:25:48.8044||V3Api.SearchGeneric t Transfer: 1220 : 40|12:25:48.8044||GetCurrentUser.. t Transfer: 1220 : 40|12:25:48.8044|| OAuth authenticated t Transfer: 1220 : 40|12:25:48.8044|| user TONY. t Transfer: 1220 : 40|12:25:48.8044||GetCurrentUser.. t Transfer: 1220 : 40|12:25:48.8044|| OAuth authenticated t Transfer: 1220 : 40|12:25:48.8044|| user TONY. t Information: 1220 : 40|12:25:48.8200||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 : 40|12:26:55.6013||IsUserAuthenticated: /api/view/searchinfo/CacheManagerSearch?_dc=1575980815632 t Transfer: 1220 : 40|12:26:55.6013||GetCurrentUser.. t Transfer: 1220 : 40|12:26:55.6013|| OAuth authenticated t Transfer: 1220 : 40|12:26:55.6013|| user TONY. t Transfer: 1220 : 40|12:26:55.6013||api user: TONY t Information: 1220 : 40|12:26:55.6013||GetAdvSearchColumns. search type CacheManagerSearch grid . t Transfer: 1220 : 58|12:26:55.6013||IsUserAuthenticated: /api/user-preferences?keys=adv.recent.searches.cachemanager&_dc=1575980815634 t Transfer: 1220 : 58|12:26:55.6013||GetCurrentUser.. t Transfer: 1220 : 58|12:26:55.6013|| OAuth authenticated t Transfer: 1220 : 58|12:26:55.6013|| user TONY. t Transfer: 1220 : 58|12:26:55.6013||api user: TONY t Information: 1220 : 58|12:26:55.6013||GetUserDataByKeys: adv.recent.searches.cachemanager t Transfer: 1220 : 58|12:26:55.6013||GetCurrentUser.. t Transfer: 1220 : 58|12:26:55.6013|| OAuth authenticated t Transfer: 1220 : 58|12:26:55.6013|| user TONY. t Transfer: 1220 : 48|12:26:55.6169||IsUserAuthenticated: /api/view/info/CacheManagerSearch?lang=en-US&_dc=1575980815640 t Transfer: 1220 : 48|12:26:55.6169||GetCurrentUser.. t Transfer: 1220 : 48|12:26:55.6169|| OAuth authenticated t Transfer: 1220 : 48|12:26:55.6169|| user TONY. t Transfer: 1220 : 48|12:26:55.6169||api user: TONY t Information: 1220 : 48|12:26:55.6169||GetGridViewBuilder. builder type CacheManagerSearch. t Transfer: 1220 : 48|12:26:55.6169||GetCurrentUser.. t Transfer: 1220 : 48|12:26:55.6169|| OAuth authenticated t Transfer: 1220 : 48|12:26:55.6169|| user TONY. t Information: 1220 : 48|12:26:55.6169||UserGridView. LoadView. ID -1, Name Default. t Transfer: 1220 : 48|12:26:55.6169||GetCurrentUser.. t Transfer: 1220 : 48|12:26:55.6169|| OAuth authenticated t Transfer: 1220 : 48|12:26:55.6169|| user TONY. t Transfer: 1220 : 48|12:26:55.6169||GetCurrentUser.. t Transfer: 1220 : 48|12:26:55.6169|| OAuth authenticated t Transfer: 1220 : 48|12:26:55.6169|| user TONY. t Transfer: 1220 : 12|12:26:55.6638||IsUserAuthenticated: /api/view/searches/CacheManagerSearch?_dc=1575980815650 t Transfer: 1220 : 12|12:26:55.6638||GetCurrentUser.. t Transfer: 1220 : 12|12:26:55.6638|| OAuth authenticated t Transfer: 1220 : 12|12:26:55.6638|| user TONY. t Transfer: 1220 : 12|12:26:55.6638||api user: TONY t Information: 1220 : 12|12:26:55.6638||GetSavedSearchNames. search type CacheManagerSearch. t Transfer: 1220 : 12|12:26:55.6638||GetCurrentUser.. t Transfer: 1220 : 12|12:26:55.6638|| OAuth authenticated t Transfer: 1220 : 12|12:26:55.6638|| user TONY. t Transfer: 1220 : 29|12:27:00.6794||IsUserAuthenticated: /api/view/CacheManagerSearch/471?_dc=1575980820719 t Transfer: 1220 : 29|12:27:00.6794||GetCurrentUser.. t Transfer: 1220 : 29|12:27:00.6794|| OAuth authenticated t Transfer: 1220 : 29|12:27:00.6794|| user TONY. t Transfer: 1220 : 29|12:27:00.6794||api user: TONY t Information: 1220 : 29|12:27:00.6950||UserGridView. LoadView. ID 471, Name . t Transfer: 1220 : 29|12:27:00.6950||GetCurrentUser.. t Transfer: 1220 : 29|12:27:00.6950|| OAuth authenticated t Transfer: 1220 : 29|12:27:00.6950|| user TONY. t Transfer: 1220 : 58|12:27:11.4919||IsUserAuthenticated: /api/view/searchinfo/ResourceReq?_dc=1575980831515 t Transfer: 1220 : 58|12:27:11.4919||GetCurrentUser.. t Transfer: 1220 : 58|12:27:11.4919|| OAuth authenticated t Transfer: 1220 : 58|12:27:11.4919|| user TONY. t Transfer: 1220 : 58|12:27:11.4919||api user: TONY t Information: 1220 : 58|12:27:11.4919||GetAdvSearchColumns. search type ResourceReq grid . t Transfer: 1220 : 58|12:27:11.5232||IsUserAuthenticated: /api/view/searches/ResourceReq?_dc=1575980831543 t Transfer: 1220 : 58|12:27:11.5232||GetCurrentUser.. t Transfer: 1220 : 58|12:27:11.5232|| OAuth authenticated t Transfer: 1220 : 58|12:27:11.5232|| user TONY. t Transfer: 1220 : 58|12:27:11.5232||api user: TONY t Information: 1220 : 58|12:27:11.5232||GetSavedSearchNames. search type ResourceReq. t Transfer: 1220 : 58|12:27:11.5232||GetCurrentUser.. t Transfer: 1220 : 58|12:27:11.5232|| OAuth authenticated t Transfer: 1220 : 58|12:27:11.5232|| user TONY. t Transfer: 1220 : 58|12:27:11.5388||IsUserAuthenticated: /api/user-preferences?keys=adv.recent.searches.work_orders&_dc=1575980831517 t Transfer: 1220 : 58|12:27:11.5388||GetCurrentUser.. t Transfer: 1220 : 58|12:27:11.5388|| OAuth authenticated t Transfer: 1220 : 58|12:27:11.5388|| user TONY. t Transfer: 1220 : 58|12:27:11.5388||api user: TONY t Information: 1220 : 58|12:27:11.5388||GetUserDataByKeys: adv.recent.searches.work_orders t Transfer: 1220 : 58|12:27:11.5388||GetCurrentUser.. t Transfer: 1220 : 58|12:27:11.5388|| OAuth authenticated t Transfer: 1220 : 58|12:27:11.5388|| user TONY. t Transfer: 1220 : 60|12:27:11.5388||IsUserAuthenticated: /api/view/info/ResourceReq?lang=en-US&_dc=1575980831529 t Transfer: 1220 : 60|12:27:11.5388||GetCurrentUser.. t Transfer: 1220 : 60|12:27:11.5388|| OAuth authenticated t Transfer: 1220 : 60|12:27:11.5388|| user TONY. t Transfer: 1220 : 60|12:27:11.5388||api user: TONY t Information: 1220 : 60|12:27:11.5388||GetGridViewBuilder. builder type ResourceReq. t Transfer: 1220 : 60|12:27:11.5388||GetCurrentUser.. t Transfer: 1220 : 60|12:27:11.5388|| OAuth authenticated t Transfer: 1220 : 60|12:27:11.5388|| user TONY. t Information: 1220 : 60|12:27:11.5544||UserGridView. LoadView. ID -1, Name Default. t Transfer: 1220 : 60|12:27:11.5544||GetCurrentUser.. t Transfer: 1220 : 60|12:27:11.5544|| OAuth authenticated t Transfer: 1220 : 60|12:27:11.5544|| user TONY. t Transfer: 1220 : 60|12:27:11.5544||GetCurrentUser.. t Transfer: 1220 : 60|12:27:11.5544|| OAuth authenticated t Transfer: 1220 : 60|12:27:11.5544|| user TONY. t Transfer: 1220 : 48|12:27:23.5544||IsUserAuthenticated: /api/user-preferences?keys=associate_media_workflow&_dc=1575980843586 t Transfer: 1220 : 48|12:27:23.5544||GetCurrentUser.. t Transfer: 1220 : 48|12:27:23.5544|| OAuth authenticated t Transfer: 1220 : 48|12:27:23.5544|| user TONY. t Transfer: 1220 : 48|12:27:23.5544||api user: TONY t Information: 1220 : 48|12:27:23.5544||GetUserDataByKeys: associate_media_workflow t Transfer: 1220 : 48|12:27:23.5544||GetCurrentUser.. t Transfer: 1220 : 48|12:27:23.5544|| OAuth authenticated t Transfer: 1220 : 48|12:27:23.5544|| user TONY. t Transfer: 1220 : 57|12:27:23.5700||IsUserAuthenticated: /api/settings/user/searchLayoutConfig?_dc=1575980843607 t Transfer: 1220 : 57|12:27:23.5700||GetCurrentUser.. t Transfer: 1220 : 57|12:27:23.5700|| OAuth authenticated t Transfer: 1220 : 57|12:27:23.5700|| user TONY. t Transfer: 1220 : 57|12:27:23.5700||api user: TONY t Information: 1220 : 57|12:27:23.5700||V3Api.GetUserSettings t Transfer: 1220 : 57|12:27:23.5700||GetCurrentUser.. t Transfer: 1220 : 57|12:27:23.5700|| OAuth authenticated t Transfer: 1220 : 57|12:27:23.5700|| user TONY. t Transfer: 1220 : 60|12:27:23.6013||IsUserAuthenticated: /api/user-preferences?keys=adv.recent.searches.versions&_dc=1575980843597 t Transfer: 1220 : 60|12:27:23.6013||GetCurrentUser.. t Transfer: 1220 : 60|12:27:23.6013|| OAuth authenticated t Transfer: 1220 : 60|12:27:23.6013|| user TONY. t Transfer: 1220 : 60|12:27:23.6013||api user: TONY t Information: 1220 : 60|12:27:23.6013||GetUserDataByKeys: adv.recent.searches.versions t Transfer: 1220 : 60|12:27:23.6013||GetCurrentUser.. t Transfer: 1220 : 60|12:27:23.6013|| OAuth authenticated t Transfer: 1220 : 60|12:27:23.6013|| user TONY. t Transfer: 1220 : 57|12:27:23.6794||IsUserAuthenticated: /api/user-preferences?keys=associate_media_workflow&_dc=1575980843716 t Transfer: 1220 : 57|12:27:23.6794||GetCurrentUser.. t Transfer: 1220 : 57|12:27:23.6794|| OAuth authenticated t Transfer: 1220 : 57|12:27:23.6794|| user TONY. t Transfer: 1220 : 57|12:27:23.6794||api user: TONY t Information: 1220 : 57|12:27:23.6794||GetUserDataByKeys: associate_media_workflow t Transfer: 1220 : 57|12:27:23.6794||GetCurrentUser.. t Transfer: 1220 : 57|12:27:23.6794|| OAuth authenticated t Transfer: 1220 : 57|12:27:23.6794|| user TONY. t Transfer: 1220 : 12|12:27:23.7419||IsUserAuthenticated: /api/search/Media?_dc=1575980843765 t Transfer: 1220 : 12|12:27:23.7419||GetCurrentUser.. t Transfer: 1220 : 12|12:27:23.7419|| OAuth authenticated t Transfer: 1220 : 12|12:27:23.7419|| user TONY. t Transfer: 1220 : 12|12:27:23.7419||api user: TONY t Information: 1220 : 12|12:27:23.7419||V3Api.SearchMedia t Information: 1220 : 12|12:27:23.7419||V3Api.SearchGeneric t Transfer: 1220 : 12|12:27:23.7419||GetCurrentUser.. t Transfer: 1220 : 12|12:27:23.7419|| OAuth authenticated t Transfer: 1220 : 12|12:27:23.7419|| user TONY. t Transfer: 1220 : 12|12:27:33.3981||IsUserAuthenticated: /api/view/searchinfo/TitleSearch?_dc=1575980853416 t Transfer: 1220 : 12|12:27:33.3981||GetCurrentUser.. t Transfer: 1220 : 12|12:27:33.3981|| OAuth authenticated t Transfer: 1220 : 12|12:27:33.3981|| user TONY. t Transfer: 1220 : 12|12:27:33.3981||api user: TONY t Information: 1220 : 12|12:27:33.3981||GetAdvSearchColumns. search type TitleSearch grid . t Transfer: 1220 : 48|12:27:33.3981||IsUserAuthenticated: /api/user-preferences?keys=adv.recent.searches.titles&_dc=1575980853418 t Transfer: 1220 : 48|12:27:33.3981||GetCurrentUser.. t Transfer: 1220 : 48|12:27:33.3981|| OAuth authenticated t Transfer: 1220 : 48|12:27:33.3981|| user TONY. t Transfer: 1220 : 48|12:27:33.3981||api user: TONY t Information: 1220 : 48|12:27:33.3981||GetUserDataByKeys: adv.recent.searches.titles t Transfer: 1220 : 48|12:27:33.3981||GetCurrentUser.. t Transfer: 1220 : 48|12:27:33.3981|| OAuth authenticated t Transfer: 1220 : 48|12:27:33.3981|| user TONY. t Transfer: 1220 : 60|12:27:33.4138||IsUserAuthenticated: /api/view/searches/TitleSearch?_dc=1575980853436 t Transfer: 1220 : 60|12:27:33.4138||GetCurrentUser.. t Transfer: 1220 : 60|12:27:33.4138|| OAuth authenticated t Transfer: 1220 : 60|12:27:33.4138|| user TONY. t Transfer: 1220 : 60|12:27:33.4138||api user: TONY t Information: 1220 : 60|12:27:33.4138||GetSavedSearchNames. search type TitleSearch. t Transfer: 1220 : 60|12:27:33.4138||GetCurrentUser.. t Transfer: 1220 : 60|12:27:33.4138|| OAuth authenticated t Transfer: 1220 : 60|12:27:33.4138|| user TONY. t Transfer: 1220 : 58|12:27:37.8513||IsUserAuthenticated: /api/SearchSuggestion/?_dc=1575980857870 t Transfer: 1220 : 58|12:27:37.8513||GetCurrentUser.. t Transfer: 1220 : 58|12:27:37.8513|| OAuth authenticated t Transfer: 1220 : 58|12:27:37.8513|| user TONY. t Transfer: 1220 : 58|12:27:37.8513||api user: TONY t Transfer: 1220 : 58|12:27:37.8513||GetCurrentUser.. t Transfer: 1220 : 58|12:27:37.8513|| OAuth authenticated t Transfer: 1220 : 58|12:27:37.8513|| user TONY. t Transfer: 1220 : 49|12:27:38.3356||IsUserAuthenticated: /api/SearchSuggestion/?_dc=1575980858355 t Transfer: 1220 : 49|12:27:38.3356||GetCurrentUser.. t Transfer: 1220 : 49|12:27:38.3356|| OAuth authenticated t Transfer: 1220 : 49|12:27:38.3356|| user TONY. t Transfer: 1220 : 49|12:27:38.3356||api user: TONY t Transfer: 1220 : 49|12:27:38.3356||GetCurrentUser.. t Transfer: 1220 : 49|12:27:38.3356|| OAuth authenticated t Transfer: 1220 : 49|12:27:38.3356|| user TONY. t Transfer: 1220 : 47|12:27:39.9606||IsUserAuthenticated: /api/search/title?_dc=1575980859992 t Transfer: 1220 : 47|12:27:39.9606||GetCurrentUser.. t Transfer: 1220 : 47|12:27:39.9606|| OAuth authenticated t Transfer: 1220 : 47|12:27:39.9606|| user TONY. t Transfer: 1220 : 47|12:27:39.9606||api user: TONY t Information: 1220 : 47|12:27:39.9606||V3Api.SearchTitles t Information: 1220 : 47|12:27:39.9606||V3Api.SearchGeneric t Transfer: 1220 : 47|12:27:39.9606||GetCurrentUser.. t Transfer: 1220 : 47|12:27:39.9606|| OAuth authenticated t Transfer: 1220 : 47|12:27:39.9606|| user TONY. t Transfer: 1220 : 47|12:27:39.9606||GetCurrentUser.. t Transfer: 1220 : 47|12:27:39.9606|| OAuth authenticated t Transfer: 1220 : 47|12:27:39.9606|| user TONY. t Information: 1220 : 47|12:27:39.9763||SearchTitle SQL: with v as ( SELECT abs.* ,decode(ITEM_TYPE, 1010,SER_ABS_ID, 1020,CASE WHEN SER_ABS2_ID > 0 THEN SER_ABS2_ID ELSE SER_ABS_ID END ) xparent_id FROM TMDDBA.TM_PG_ABS abs WHERE abs.id in ( select a.id FROM TMDDBA.TM_PG_ABS a where ABS_DELETED = 0 AND a.ser_abs_id=278625 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 : 48|12:27:40.2731||IsUserAuthenticated: /api/int/title/278625/versions?_dc=1575980860305 t Transfer: 1220 : 48|12:27:40.2731||GetCurrentUser.. t Transfer: 1220 : 48|12:27:40.2731|| OAuth authenticated t Transfer: 1220 : 48|12:27:40.2731|| user TONY. t Transfer: 1220 : 48|12:27:40.2731||api user: TONY t Information: 1220 : 48|12:27:40.2731||V3Api.GetVersionsByTitleIdAdv t Information: 1220 : 48|12:27:40.2731||V3Api.SearchGeneric t Transfer: 1220 : 48|12:27:40.2731||GetCurrentUser.. t Transfer: 1220 : 48|12:27:40.2731|| OAuth authenticated t Transfer: 1220 : 48|12:27:40.2731|| user TONY. t Transfer: 1220 : 48|12:27:40.2731||GetCurrentUser.. t Transfer: 1220 : 48|12:27:40.2731|| OAuth authenticated t Transfer: 1220 : 48|12:27:40.2731|| user TONY. t Transfer: 1220 : 57|12:27:40.2888||IsUserAuthenticated: /api/user-preferences?_dc=1575980860309 t Transfer: 1220 : 57|12:27:40.2888||GetCurrentUser.. t Transfer: 1220 : 57|12:27:40.2888|| OAuth authenticated t Transfer: 1220 : 57|12:27:40.2888|| user TONY. t Transfer: 1220 : 57|12:27:40.2888||api user: TONY t Verbose: 1220 : 57|12:27:40.2888||StoreUserDataByKeys.. t Transfer: 1220 : 57|12:27:40.2888||GetCurrentUser.. t Transfer: 1220 : 57|12:27:40.2888|| OAuth authenticated t Transfer: 1220 : 57|12:27:40.2888|| user TONY. t Information: 1220 : 48|12:27:40.2888||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=278625 order by m.title, m.id ) a where rownum <= 9999) r where rnum >=1 order by rnum t Information: 1220 : 48|12:27:40.3825||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: 100ms. 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=278625 order by m.title, m.id ) a where rownum <= 9999) r where rnum >=1 order by rnum t Transfer: 1220 : 48|12:27:42.5700||IsUserAuthenticated: /api/int/title/278626/versions?_dc=1575980862593 t Transfer: 1220 : 48|12:27:42.5700||GetCurrentUser.. t Transfer: 1220 : 48|12:27:42.5700|| OAuth authenticated t Transfer: 1220 : 48|12:27:42.5700|| user TONY. t Transfer: 1220 : 48|12:27:42.5700||api user: TONY t Information: 1220 : 48|12:27:42.5700||V3Api.GetVersionsByTitleIdAdv t Information: 1220 : 48|12:27:42.5700||V3Api.SearchGeneric t Transfer: 1220 : 48|12:27:42.5700||GetCurrentUser.. t Transfer: 1220 : 48|12:27:42.5700|| OAuth authenticated t Transfer: 1220 : 48|12:27:42.5700|| user TONY. t Transfer: 1220 : 48|12:27:42.5700||GetCurrentUser.. t Transfer: 1220 : 48|12:27:42.5700|| OAuth authenticated t Transfer: 1220 : 48|12:27:42.5700|| user TONY. t Information: 1220 : 48|12:27:42.5856||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=278626 order by m.title, m.id ) a where rownum <= 9999) r where rnum >=1 order by rnum t Information: 1220 : 48|12:27:42.6169||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: 39ms. 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=278626 order by m.title, m.id ) a where rownum <= 9999) r where rnum >=1 order by rnum t Transfer: 1220 : 51|12:27:44.3044||IsUserAuthenticated: /api/int/title/278656/versions?_dc=1575980864327 t Transfer: 1220 : 51|12:27:44.3044||GetCurrentUser.. t Transfer: 1220 : 51|12:27:44.3044|| OAuth authenticated t Transfer: 1220 : 51|12:27:44.3044|| user TONY. t Transfer: 1220 : 51|12:27:44.3044||api user: TONY t Information: 1220 : 51|12:27:44.3044||V3Api.GetVersionsByTitleIdAdv t Information: 1220 : 51|12:27:44.3044||V3Api.SearchGeneric t Transfer: 1220 : 51|12:27:44.3044||GetCurrentUser.. t Transfer: 1220 : 51|12:27:44.3044|| OAuth authenticated t Transfer: 1220 : 51|12:27:44.3044|| user TONY. t Transfer: 1220 : 51|12:27:44.3044||GetCurrentUser.. t Transfer: 1220 : 51|12:27:44.3044|| OAuth authenticated t Transfer: 1220 : 51|12:27:44.3044|| user TONY. t Information: 1220 : 51|12:27:44.3200||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=278656 order by m.title, m.id ) a where rownum <= 9999) r where rnum >=1 order by rnum t Information: 1220 : 51|12:27:44.3356||Running version search. User: 522 Simple Search: Running Oracle search for COUNT Oracle count completed in: 4ms. Returned lines: 2 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=278656 order by m.title, m.id ) a where rownum <= 9999) r where rnum >=1 order by rnum t Transfer: 1220 : 48|12:27:44.4450||IsUserAuthenticated: /api/int/version/278657/media?_dc=1575980864475 t Transfer: 1220 : 48|12:27:44.4450||GetCurrentUser.. t Transfer: 1220 : 48|12:27:44.4450|| OAuth authenticated t Transfer: 1220 : 48|12:27:44.4450|| user TONY. t Transfer: 1220 : 48|12:27:44.4450||api user: TONY t Information: 1220 : 48|12:27:44.4450||V3Api.GetMediaByVersionIdAdv t Information: 1220 : 48|12:27:44.4450||V3Api.SearchGeneric t Transfer: 1220 : 48|12:27:44.4450||GetCurrentUser.. t Transfer: 1220 : 48|12:27:44.4450|| OAuth authenticated t Transfer: 1220 : 48|12:27:44.4450|| user TONY. t Information: 1220 : 48|12:27:44.4450||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: 278657 t Information: 1220 : 48|12:27:44.4762|| timing: 00:00:00.0343363 t Verbose: 1220 : 48|12:27:44.4762||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\gots1ep1us.mp4 subfolder t Verbose: 1220 : 48|12:27:44.4762|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/gots1ep1us.mp4 t Verbose: 1220 : 48|12:27:44.4762||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/gots1ep1us.mp4 t Transfer: 1220 : 48|12:27:44.4919||GetCurrentUser.. t Transfer: 1220 : 48|12:27:44.4919|| OAuth authenticated t Transfer: 1220 : 48|12:27:44.4919|| user TONY. t Verbose: 1220 : 48|12:27:44.4919||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\gots1ep1us.mpd subfolder t Verbose: 1220 : 48|12:27:44.4919|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/gots1ep1us.mpd t Verbose: 1220 : 48|12:27:44.4919||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/gots1ep1us.mpd t Transfer: 1220 : 48|12:27:44.4919||GetCurrentUser.. t Transfer: 1220 : 48|12:27:44.4919|| OAuth authenticated t Transfer: 1220 : 48|12:27:44.4919|| user TONY. t Verbose: 1220 : 48|12:27:44.4919||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\gots1ep1uk.mpd subfolder t Verbose: 1220 : 48|12:27:44.4919|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/gots1ep1uk.mpd t Verbose: 1220 : 48|12:27:44.4919||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/gots1ep1uk.mpd t Transfer: 1220 : 48|12:27:44.4919||GetCurrentUser.. t Transfer: 1220 : 48|12:27:44.4919|| OAuth authenticated t Transfer: 1220 : 48|12:27:44.4919|| user TONY. t Verbose: 1220 : 48|12:27:44.4919||GetUrl. Enter. Storage |Audio| filename \\192.168.120.254\DemoFS\Digital Assets\Audio\spanish.wav subfolder t Verbose: 1220 : 48|12:27:44.4919|| GetFileName result https://imfxv3tm.tmd.tv/AudioServer/spanish.wav t Verbose: 1220 : 48|12:27:44.4919||GetUrl. Exit. result https://imfxv3tm.tmd.tv/AudioServer/spanish.wav t Transfer: 1220 : 48|12:27:44.4919||GetCurrentUser.. t Transfer: 1220 : 48|12:27:44.4919|| OAuth authenticated t Transfer: 1220 : 48|12:27:44.4919|| user TONY. t Verbose: 1220 : 48|12:27:44.4919||GetUrl. Enter. Storage |Audio| filename \\192.168.120.254\DemoFS\Digital Assets\Audio\portugese.wav subfolder t Verbose: 1220 : 48|12:27:44.4919|| GetFileName result https://imfxv3tm.tmd.tv/AudioServer/portugese.wav t Verbose: 1220 : 48|12:27:44.4919||GetUrl. Exit. result https://imfxv3tm.tmd.tv/AudioServer/portugese.wav t Transfer: 1220 : 48|12:27:44.4919||GetCurrentUser.. t Transfer: 1220 : 48|12:27:44.4919|| OAuth authenticated t Transfer: 1220 : 48|12:27:44.4919|| user TONY. t Verbose: 1220 : 48|12:27:44.4919||GetUrl. Enter. Storage |Image| filename \\192.168.120.254\DemoFS\Digital Assets\Image\game_of_thrones_still_3.jpg subfolder t Verbose: 1220 : 48|12:27:44.4919|| GetFileName result https://imfxv3tm.tmd.tv/ImageServer/game_of_thrones_still_3.jpg t Verbose: 1220 : 48|12:27:44.5075||GetUrl. Exit. result https://imfxv3tm.tmd.tv/ImageServer/game_of_thrones_still_3.jpg t Transfer: 1220 : 48|12:27:44.5075||GetCurrentUser.. t Transfer: 1220 : 48|12:27:44.5075|| OAuth authenticated t Transfer: 1220 : 48|12:27:44.5075|| user TONY. t Verbose: 1220 : 48|12:27:44.5075||GetUrl. Enter. Storage |Docs| filename \\192.168.120.254\DemoFS\Digital Assets\Docs\package rundown.xml subfolder t Verbose: 1220 : 48|12:27:44.5075|| GetFileName result https://imfxv3tm.tmd.tv/DocsServer/package rundown.xml t Verbose: 1220 : 48|12:27:44.5075||GetUrl. Exit. result https://imfxv3tm.tmd.tv/DocsServer/package rundown.xml t Transfer: 1220 : 48|12:27:44.5075||GetCurrentUser.. t Transfer: 1220 : 48|12:27:44.5075|| OAuth authenticated t Transfer: 1220 : 48|12:27:44.5075|| user TONY. t Verbose: 1220 : 48|12:27:44.5075||GetUrl. Enter. Storage |Docs| filename \\192.168.120.254\DemoFS\Digital Assets\Docs\Data Model Description 4.pdf subfolder t Verbose: 1220 : 48|12:27:44.5075|| GetFileName result https://imfxv3tm.tmd.tv/DocsServer/Data Model Description 4.pdf t Verbose: 1220 : 48|12:27:44.5075||GetUrl. Exit. result https://imfxv3tm.tmd.tv/DocsServer/Data Model Description 4.pdf t Transfer: 1220 : 48|12:27:44.5075||GetCurrentUser.. t Transfer: 1220 : 48|12:27:44.5075|| OAuth authenticated t Transfer: 1220 : 48|12:27:44.5075|| user TONY. t Verbose: 1220 : 48|12:27:44.5075||GetUrl. Enter. Storage |Docs| filename \\192.168.120.254\DemoFS\Digital Assets\Docs\Mediaflex Supported Devices 2v03_0.pdf subfolder t Verbose: 1220 : 48|12:27:44.5075|| GetFileName result https://imfxv3tm.tmd.tv/DocsServer/Mediaflex Supported Devices 2v03_0.pdf t Verbose: 1220 : 48|12:27:44.5075||GetUrl. Exit. result https://imfxv3tm.tmd.tv/DocsServer/Mediaflex Supported Devices 2v03_0.pdf t Transfer: 1220 : 48|12:27:44.5075||GetCurrentUser.. t Transfer: 1220 : 48|12:27:44.5075|| OAuth authenticated t Transfer: 1220 : 48|12:27:44.5075|| user TONY. t Verbose: 1220 : 48|12:27:44.5075||GetUrl. Enter. Storage |Docs| filename \\192.168.120.254\DemoFS\Digital Assets\Docs\Report-762-BlackFrames_AudioMute.avi.pdf subfolder t Verbose: 1220 : 48|12:27:44.5075|| GetFileName result https://imfxv3tm.tmd.tv/DocsServer/Report-762-BlackFrames_AudioMute.avi.pdf t Verbose: 1220 : 48|12:27:44.5075||GetUrl. Exit. result https://imfxv3tm.tmd.tv/DocsServer/Report-762-BlackFrames_AudioMute.avi.pdf t Transfer: 1220 : 48|12:27:44.5075||GetCurrentUser.. t Transfer: 1220 : 48|12:27:44.5075|| OAuth authenticated t Transfer: 1220 : 48|12:27:44.5075|| user TONY. t Transfer: 1220 : 53|12:27:49.4606||IsUserAuthenticated: /api/title-details/278625?_dc=1575980869484 t Transfer: 1220 : 53|12:27:49.4606||GetCurrentUser.. t Transfer: 1220 : 53|12:27:49.4606|| OAuth authenticated t Transfer: 1220 : 53|12:27:49.4606|| user TONY. t Transfer: 1220 : 53|12:27:49.4606||api user: TONY t Transfer: 1220 : 60|12:27:49.5856||IsUserAuthenticated: /api/search/title?_dc=1575980869612 t Transfer: 1220 : 60|12:27:49.5856||GetCurrentUser.. t Transfer: 1220 : 60|12:27:49.5856|| OAuth authenticated t Transfer: 1220 : 60|12:27:49.5856|| user TONY. t Transfer: 1220 : 60|12:27:49.5856||api user: TONY t Information: 1220 : 60|12:27:49.5856||V3Api.SearchTitles t Information: 1220 : 60|12:27:49.5856||V3Api.SearchGeneric t Transfer: 1220 : 60|12:27:49.5856||GetCurrentUser.. t Transfer: 1220 : 60|12:27:49.5856|| OAuth authenticated t Transfer: 1220 : 60|12:27:49.5856|| user TONY. t Transfer: 1220 : 60|12:27:49.5856||GetCurrentUser.. t Transfer: 1220 : 60|12:27:49.5856|| OAuth authenticated t Transfer: 1220 : 60|12:27:49.5856|| user TONY. t Information: 1220 : 60|12:27:49.5856||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('278625') 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 : 51|12:27:49.6794||IsUserAuthenticated: /api/search/title?_dc=1575980869705 t Transfer: 1220 : 51|12:27:49.6794||GetCurrentUser.. t Transfer: 1220 : 51|12:27:49.6794|| OAuth authenticated t Transfer: 1220 : 51|12:27:49.6794|| user TONY. t Transfer: 1220 : 51|12:27:49.6794||api user: TONY t Information: 1220 : 51|12:27:49.6794||V3Api.SearchTitles t Information: 1220 : 51|12:27:49.6794||V3Api.SearchGeneric t Transfer: 1220 : 51|12:27:49.6794||GetCurrentUser.. t Transfer: 1220 : 51|12:27:49.6794|| OAuth authenticated t Transfer: 1220 : 51|12:27:49.6794|| user TONY. t Transfer: 1220 : 51|12:27:49.6794||GetCurrentUser.. t Transfer: 1220 : 51|12:27:49.6794|| OAuth authenticated t Transfer: 1220 : 51|12:27:49.6794|| user TONY. t Information: 1220 : 51|12:27:49.6794||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('278625') AND ROWNUM < 25000 ) ) ,v_missing_parent_ids as ( select xparent_id from v minus select id from v ) ,v_missing_parents as ( SELECT distinct a.* ,decode(ITEM_TYPE, 1010,SER_ABS_ID, 1020,CASE WHEN SER_ABS2_ID > 0 THEN SER_ABS2_ID ELSE SER_ABS_ID END ) xparent_id FROM TMDDBA.TM_PG_ABS a START WITH ID IN (select xparent_id from v_missing_parent_ids) CONNECT BY CASE PRIOR ITEM_TYPE WHEN 1010 THEN PRIOR SER_ABS_ID WHEN 1020 THEN CASE WHEN NVL(PRIOR SER_ABS2_ID, 0) > 0 THEN PRIOR SER_ABS2_ID ELSE PRIOR SER_ABS_ID END END = ID ) ,v_all as ( select x.*, count(*) over() RowCount from ( select * from v_missing_parents union select * from v ) x ) ,v_top as ( select id from (select id, row_number()over(order by upper(ser_title),upper(title),ser_num,ser_ep_num, SER_EP_SQ_NUM ) rnk -- sort roots from v_all where xparent_id is null) where rnk between (:page_number-1)*50+1 and :page_number*50 ) ,v_tree as ( select level lvl, a.* from v_all a start with id in (select id from v_top) connect by xparent_id = prior ID order siblings by upper(ser_title),ser_num,ser_ep_num, SER_EP_SQ_NUM,upper(title) -- sort children ) select * from v_tree --where rnk <= 50 t Transfer: 1220 : 55|12:28:27.6013||IsUserAuthenticated: /api/view/TitleTree/1301?_dc=1575980907618 t Transfer: 1220 : 55|12:28:27.6013||GetCurrentUser.. t Transfer: 1220 : 55|12:28:27.6013|| OAuth authenticated t Transfer: 1220 : 55|12:28:27.6013|| user TONY. t Transfer: 1220 : 55|12:28:27.6013||api user: TONY t Information: 1220 : 55|12:28:27.6013||UserGridView. LoadView. ID 1301, Name . t Transfer: 1220 : 55|12:28:27.6013||GetCurrentUser.. t Transfer: 1220 : 55|12:28:27.6013|| OAuth authenticated t Transfer: 1220 : 55|12:28:27.6013|| user TONY. t Transfer: 1220 : 49|12:28:42.3669||IsUserAuthenticated: /api/title-details/278625?_dc=1575980922386 t Transfer: 1220 : 49|12:28:42.3669||GetCurrentUser.. t Transfer: 1220 : 49|12:28:42.3669|| OAuth authenticated t Transfer: 1220 : 49|12:28:42.3669|| user TONY. t Transfer: 1220 : 49|12:28:42.3669||api user: TONY t Transfer: 1220 : 53|12:28:42.4762||IsUserAuthenticated: /api/search/title?_dc=1575980922494 t Transfer: 1220 : 53|12:28:42.4762||GetCurrentUser.. t Transfer: 1220 : 53|12:28:42.4762|| OAuth authenticated t Transfer: 1220 : 53|12:28:42.4762|| user TONY. t Transfer: 1220 : 53|12:28:42.4762||api user: TONY t Information: 1220 : 53|12:28:42.4762||V3Api.SearchTitles t Information: 1220 : 53|12:28:42.4762||V3Api.SearchGeneric t Transfer: 1220 : 53|12:28:42.4762||GetCurrentUser.. t Transfer: 1220 : 53|12:28:42.4762|| OAuth authenticated t Transfer: 1220 : 53|12:28:42.4762|| user TONY. t Transfer: 1220 : 53|12:28:42.4762||GetCurrentUser.. t Transfer: 1220 : 53|12:28:42.4762|| OAuth authenticated t Transfer: 1220 : 53|12:28:42.4762|| user TONY. t Information: 1220 : 53|12:28:42.4762||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('278625') 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 : 34|12:28:42.5544||IsUserAuthenticated: /api/search/title?_dc=1575980922579 t Transfer: 1220 : 34|12:28:42.5544||GetCurrentUser.. t Transfer: 1220 : 34|12:28:42.5544|| OAuth authenticated t Transfer: 1220 : 34|12:28:42.5544|| user TONY. t Transfer: 1220 : 34|12:28:42.5544||api user: TONY t Information: 1220 : 34|12:28:42.5544||V3Api.SearchTitles t Information: 1220 : 34|12:28:42.5544||V3Api.SearchGeneric t Transfer: 1220 : 34|12:28:42.5544||GetCurrentUser.. t Transfer: 1220 : 34|12:28:42.5544|| OAuth authenticated t Transfer: 1220 : 34|12:28:42.5544|| user TONY. t Transfer: 1220 : 34|12:28:42.5544||GetCurrentUser.. t Transfer: 1220 : 34|12:28:42.5544|| OAuth authenticated t Transfer: 1220 : 34|12:28:42.5544|| user TONY. t Information: 1220 : 34|12:28:42.5544||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('278625') 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 : 53|12:29:00.5544||IsUserAuthenticated: /api/v3/config/servicexml/types?_dc=1575980940566 t Transfer: 1220 : 53|12:29:00.5544||GetCurrentUser.. t Transfer: 1220 : 53|12:29:00.5544|| OAuth authenticated t Transfer: 1220 : 53|12:29:00.5544|| user TONY. t Transfer: 1220 : 53|12:29:00.5544||api user: TONY t Transfer: 1220 : 58|12:29:00.6013||IsUserAuthenticated: /api/settings/groups/?_dc=1575980940607 t Transfer: 1220 : 58|12:29:00.6013||GetCurrentUser.. t Transfer: 1220 : 58|12:29:00.6013|| OAuth authenticated t Transfer: 1220 : 58|12:29:00.6013|| user TONY. t Transfer: 1220 : 58|12:29:00.6013||api user: TONY t Information: 1220 : 58|12:29:00.6013||V3Api.GetSettingsGroupsNames t Transfer: 1220 : 51|12:29:10.5544||IsUserAuthenticated: /api/settings/group/110?_dc=1575980950591 t Transfer: 1220 : 51|12:29:10.5544||GetCurrentUser.. t Transfer: 1220 : 51|12:29:10.5544|| OAuth authenticated t Transfer: 1220 : 51|12:29:10.5544|| user TONY. t Transfer: 1220 : 51|12:29:10.5544||api user: TONY t Information: 1220 : 51|12:29:10.5544||V3Api.GetSettingsGroup t Transfer: 1220 : 58|12:29:10.6325||IsUserAuthenticated: /api/search/search-fields/?_dc=1575980950665 t Transfer: 1220 : 58|12:29:10.6325||GetCurrentUser.. t Transfer: 1220 : 58|12:29:10.6325|| OAuth authenticated t Transfer: 1220 : 58|12:29:10.6325|| user TONY. t Transfer: 1220 : 58|12:29:10.6325||api user: TONY t Information: 1220 : 58|12:29:10.6325||V3Api.GetSearchFieldsAll t Transfer: 1220 : 53|12:29:10.7262||IsUserAuthenticated: /api/view/info/ChameleonSearch?_dc=1575980950763 t Transfer: 1220 : 53|12:29:10.7262||GetCurrentUser.. t Transfer: 1220 : 53|12:29:10.7262|| OAuth authenticated t Transfer: 1220 : 53|12:29:10.7262|| user TONY. t Transfer: 1220 : 53|12:29:10.7262||api user: TONY t Information: 1220 : 53|12:29:10.7262||GetGridViewBuilder. builder type ChameleonSearch. t Transfer: 1220 : 53|12:29:10.7262||GetCurrentUser.. t Transfer: 1220 : 53|12:29:10.7262|| OAuth authenticated t Transfer: 1220 : 53|12:29:10.7262|| user TONY. t Information: 1220 : 53|12:29:10.7262||UserGridView. LoadView. ID -1, Name Default. t Transfer: 1220 : 53|12:29:10.7262||GetCurrentUser.. t Transfer: 1220 : 53|12:29:10.7262|| OAuth authenticated t Transfer: 1220 : 53|12:29:10.7262|| user TONY. t Transfer: 1220 : 53|12:29:10.7419||GetCurrentUser.. t Transfer: 1220 : 53|12:29:10.7419|| OAuth authenticated t Transfer: 1220 : 53|12:29:10.7419|| user TONY. t Transfer: 1220 : 51|12:29:10.7419||IsUserAuthenticated: /api/view/info/ChameleonSearch?_dc=1575980950766 t Transfer: 1220 : 51|12:29:10.7419||GetCurrentUser.. t Transfer: 1220 : 51|12:29:10.7419|| OAuth authenticated t Transfer: 1220 : 51|12:29:10.7419|| user TONY. t Transfer: 1220 : 51|12:29:10.7419||api user: TONY t Transfer: 1220 : 58|12:29:10.7419||IsUserAuthenticated: /api/settings/user/defaultSearch?_dc=1575980950759 t Transfer: 1220 : 58|12:29:10.7419||GetCurrentUser.. t Transfer: 1220 : 58|12:29:10.7419|| OAuth authenticated t Transfer: 1220 : 58|12:29:10.7419|| user TONY. t Transfer: 1220 : 58|12:29:10.7419||api user: TONY t Information: 1220 : 58|12:29:10.7419||V3Api.GetUserSettings t Transfer: 1220 : 58|12:29:10.7419||GetCurrentUser.. t Transfer: 1220 : 58|12:29:10.7419|| OAuth authenticated t Transfer: 1220 : 58|12:29:10.7419|| user TONY. t Information: 1220 : 51|12:29:10.7419||GetGridViewBuilder. builder type ChameleonSearch. t Transfer: 1220 : 51|12:29:10.7419||GetCurrentUser.. t Transfer: 1220 : 51|12:29:10.7419|| OAuth authenticated t Transfer: 1220 : 51|12:29:10.7419|| user TONY. t Transfer: 1220 : 53|12:29:10.7887||IsUserAuthenticated: /api/lookups/UsageTypes?_dc=1575980950822 t Transfer: 1220 : 53|12:29:10.7887||GetCurrentUser.. t Transfer: 1220 : 53|12:29:10.7887|| OAuth authenticated t Transfer: 1220 : 53|12:29:10.7887|| user TONY. t Transfer: 1220 : 53|12:29:10.7887||api user: TONY t Transfer: 1220 : 53|12:29:10.8044||IsUserAuthenticated: /api/lookups/ItemTypes?_dc=1575980950827 t Transfer: 1220 : 53|12:29:10.8044||GetCurrentUser.. t Transfer: 1220 : 53|12:29:10.8044|| OAuth authenticated t Transfer: 1220 : 53|12:29:10.8044|| user TONY. t Transfer: 1220 : 59|12:29:10.8044||IsUserAuthenticated: /api/search/facets/?_dc=1575980950830 t Transfer: 1220 : 59|12:29:10.8044||GetCurrentUser.. t Transfer: 1220 : 59|12:29:10.8044|| OAuth authenticated t Transfer: 1220 : 59|12:29:10.8044|| user TONY. t Transfer: 1220 : 59|12:29:10.8044||api user: TONY t Transfer: 1220 : 53|12:29:10.8044||api user: TONY t Information: 1220 : 59|12:29:10.8044||V3Api.GetFacetsAll t Transfer: 1220 : 38|12:29:10.8044||IsUserAuthenticated: /api/xml-schemas/?_dc=1575980950847 t Transfer: 1220 : 38|12:29:10.8044||GetCurrentUser.. t Transfer: 1220 : 38|12:29:10.8044|| OAuth authenticated t Transfer: 1220 : 38|12:29:10.8044|| user TONY. t Transfer: 1220 : 38|12:29:10.8044||api user: TONY t Information: 1220 : 51|12:29:10.8200||UserGridView. LoadView. ID -1, Name Default. t Transfer: 1220 : 51|12:29:10.8200||GetCurrentUser.. t Transfer: 1220 : 51|12:29:10.8200|| OAuth authenticated t Transfer: 1220 : 51|12:29:10.8200|| user TONY. t Transfer: 1220 : 51|12:29:10.8200||GetCurrentUser.. t Transfer: 1220 : 51|12:29:10.8200|| OAuth authenticated t Transfer: 1220 : 51|12:29:10.8200|| user TONY. t Transfer: 1220 : 29|12:29:10.8356||IsUserAuthenticated: /api/order-presets?_dc=1575980950828 t Transfer: 1220 : 29|12:29:10.8356||GetCurrentUser.. t Transfer: 1220 : 29|12:29:10.8356|| OAuth authenticated t Transfer: 1220 : 29|12:29:10.8356|| user TONY. t Transfer: 1220 : 29|12:29:10.8356||api user: TONY t Transfer: 1220 : 29|12:29:10.8356||GetCurrentUser.. t Transfer: 1220 : 29|12:29:10.8356|| OAuth authenticated t Transfer: 1220 : 29|12:29:10.8356|| user TONY. t Transfer: 1220 : 29|12:29:11.0387||IsUserAuthenticated: /api/user-preferences?keys=consumer.recent.data&_dc=1575980950913 t Transfer: 1220 : 29|12:29:11.0387||GetCurrentUser.. t Transfer: 1220 : 29|12:29:11.0387|| OAuth authenticated t Transfer: 1220 : 29|12:29:11.0387|| user TONY. t Transfer: 1220 : 29|12:29:11.0387||api user: TONY t Information: 1220 : 29|12:29:11.0387||GetUserDataByKeys: consumer.recent.data t Transfer: 1220 : 29|12:29:11.0387||GetCurrentUser.. t Transfer: 1220 : 29|12:29:11.0387|| OAuth authenticated t Transfer: 1220 : 29|12:29:11.0387|| user TONY. t Transfer: 1220 : 51|12:29:11.0543||IsUserAuthenticated: /api/order-presets?_dc=1575980950828 t Transfer: 1220 : 51|12:29:11.0543||GetCurrentUser.. t Transfer: 1220 : 51|12:29:11.0543|| OAuth authenticated t Transfer: 1220 : 51|12:29:11.0543|| user TONY. t Transfer: 1220 : 51|12:29:11.0543||api user: TONY t Transfer: 1220 : 51|12:29:11.0543||GetCurrentUser.. t Transfer: 1220 : 51|12:29:11.0543|| OAuth authenticated t Transfer: 1220 : 51|12:29:11.0543|| user TONY. t Transfer: 1220 : 53|12:30:17.3200||IsUserAuthenticated: /api/settings/group/110?_dc=1575981017295 t Transfer: 1220 : 53|12:30:17.3200||GetCurrentUser.. t Transfer: 1220 : 53|12:30:17.3200|| OAuth authenticated t Transfer: 1220 : 53|12:30:17.3200|| user TONY. t Transfer: 1220 : 53|12:30:17.3200||api user: TONY t Information: 1220 : 53|12:30:17.3669||V3Api.UpdateSettingsGroup t Transfer: 1220 : 34|12:30:17.6950||IsUserAuthenticated: /api/settings/user/defaultSearchColumnsSimple?_dc=1575981017723 t Transfer: 1220 : 34|12:30:17.6950||GetCurrentUser.. t Transfer: 1220 : 34|12:30:17.6950|| OAuth authenticated t Transfer: 1220 : 34|12:30:17.6950|| user TONY. t Transfer: 1220 : 34|12:30:17.6950||api user: TONY t Information: 1220 : 34|12:30:17.6950||V3Api.GetUserSettings t Transfer: 1220 : 34|12:30:17.6950||GetCurrentUser.. t Transfer: 1220 : 34|12:30:17.6950|| OAuth authenticated t Transfer: 1220 : 34|12:30:17.6950|| user TONY. t Transfer: 1220 : 38|12:30:17.6950||IsUserAuthenticated: /api/settings/user/defaultSearchColumnsVersion?_dc=1575981017722 t Transfer: 1220 : 38|12:30:17.6950||GetCurrentUser.. t Transfer: 1220 : 38|12:30:17.6950|| OAuth authenticated t Transfer: 1220 : 38|12:30:17.6950|| user TONY. t Transfer: 1220 : 38|12:30:17.6950||api user: TONY t Information: 1220 : 38|12:30:17.6950||V3Api.GetUserSettings t Transfer: 1220 : 38|12:30:17.6950||GetCurrentUser.. t Transfer: 1220 : 38|12:30:17.6950|| OAuth authenticated t Transfer: 1220 : 38|12:30:17.6950|| user TONY. t Transfer: 1220 : 59|12:30:17.6950||IsUserAuthenticated: /api/settings/user/defaultSearchMisrDetailsMediaColumns?_dc=1575981017725 t Transfer: 1220 : 59|12:30:17.6950||GetCurrentUser.. t Transfer: 1220 : 59|12:30:17.6950|| OAuth authenticated t Transfer: 1220 : 59|12:30:17.6950|| user TONY. t Transfer: 1220 : 59|12:30:17.6950||api user: TONY t Transfer: 1220 : 53|12:30:17.6950||IsUserAuthenticated: /api/settings/user/defaultSearchColumnsMedia?_dc=1575981017720 t Information: 1220 : 59|12:30:17.6950||V3Api.GetUserSettings t Transfer: 1220 : 59|12:30:17.6950||GetCurrentUser.. t Transfer: 1220 : 59|12:30:17.6950|| OAuth authenticated t Transfer: 1220 : 59|12:30:17.6950|| user TONY. t Transfer: 1220 : 55|12:30:17.6950||IsUserAuthenticated: /api/user-preferences?_dc=1575981017727 t Transfer: 1220 : 53|12:30:17.6950||GetCurrentUser.. t Transfer: 1220 : 53|12:30:17.6950|| OAuth authenticated t Transfer: 1220 : 53|12:30:17.6950|| user TONY. t Transfer: 1220 : 53|12:30:17.6950||api user: TONY t Information: 1220 : 53|12:30:17.6950||V3Api.GetUserSettings t Transfer: 1220 : 53|12:30:17.6950||GetCurrentUser.. t Transfer: 1220 : 53|12:30:17.7107|| OAuth authenticated t Transfer: 1220 : 53|12:30:17.7107|| user TONY. t Transfer: 1220 : 55|12:30:17.7107||GetCurrentUser.. t Transfer: 1220 : 55|12:30:17.7107|| OAuth authenticated t Transfer: 1220 : 55|12:30:17.7107|| user TONY. t Transfer: 1220 : 55|12:30:17.7107||api user: TONY t Verbose: 1220 : 55|12:30:17.7107||StoreUserDataByKeys.. t Transfer: 1220 : 55|12:30:17.7107||GetCurrentUser.. t Transfer: 1220 : 55|12:30:17.7107|| OAuth authenticated t Transfer: 1220 : 55|12:30:17.7107|| user TONY. t Transfer: 1220 : 34|12:30:17.7419||IsUserAuthenticated: /api/settings/user/versionCreationSettings?_dc=1575981017726 t Transfer: 1220 : 34|12:30:17.7419||GetCurrentUser.. t Transfer: 1220 : 34|12:30:17.7419|| OAuth authenticated t Transfer: 1220 : 34|12:30:17.7419|| user TONY. t Transfer: 1220 : 34|12:30:17.7419||api user: TONY t Information: 1220 : 34|12:30:17.7419||V3Api.GetUserSettings t Transfer: 1220 : 34|12:30:17.7419||GetCurrentUser.. t Transfer: 1220 : 34|12:30:17.7419|| OAuth authenticated t Transfer: 1220 : 34|12:30:17.7419|| user TONY. t Information: 1220 : 95|12:50:37.0391||OrabitWatcherBasic. Disposing. t Information: 1220 : 95|12:50:37.0391||OrabitWatcherBasic. Disposed. t Information: 1220 : 95|12:50:37.0391||========================================================================== t Information: 1220 : 95|12:50:37.0391||IMFX CORE SERVER APPLICATION END. t Information: 1220 : 2|12:50:38.2578||OrabitWatcherBasic disposing.. t Information: 1220 : 2|12:50:38.2578||OrabitWatcherBasic disposed.