t Information: 1220 : 7|14:12:54.8963|||Get Configuration Values: t Information: 1220 : 7|14:12:54.8963||| AdminPassEnc, default: , value: ffqjrn0leKv4Lj2YJHe2dw==. t Information: 1220 : 7|14:12:54.8963||| EncryptedPasswords, default: false, value: true. t Information: 1220 : 7|14:12:54.8963||| OraConnectionString, default: , value: Server=TECHM;User Id=imfx;Password=xxxxx;Unicode=true;. t Information: 1220 : 7|14:12:54.8963||| SecondTimezone, default: , value: . t Information: 1220 : 7|14:12:54.8963||| UseActiveDirectoryAuth, default: false, value: false. t Information: 1220 : 7|14:12:54.8963||| ReportingServiceUrl, default: , value: http://localhost:92/ReportingService.svc. t Information: 1220 : 7|14:12:54.8963||| ReportsPath, default: , value: . t Information: 1220 : 7|14:12:54.8963||| ReportsURL, default: , value: . t Information: 1220 : 7|14:12:54.8963||| TapeServiceUrl, default: , value: . t Information: 1220 : 7|14:12:54.8963||| GatekeeperUrl, default: , value: . t Information: 1220 : 7|14:12:54.8963||| ValuationUrl, default: , value: . t Information: 1220 : 7|14:12:54.8963||| QueueManagerDelay, default: 30, value: 30. t Information: 1220 : 7|14:12:54.8963||| QueueManagerFullRefresh, default: 90, value: 90. t Information: 1220 : 7|14:12:54.8963||| AudioLoopDuration, default: 0, value: 150. t Information: 1220 : 7|14:12:54.8963||| AudioLoopsCount, default: 0, value: 0. t Information: 1220 : 7|14:12:54.8963||| PlayerFakeStep, default: 500, value: 500. t Information: 1220 : 7|14:12:54.8963||| PlayerForceRatio, default: 0, value: 1. t Information: 1220 : 7|14:12:54.8963||| CheckVersionsInProd, default: false, value: True. t Information: 1220 : 7|14:12:54.8963||| MaxResults, default: 3000, value: 10000. t Information: 1220 : 7|14:12:54.8963||| TEReportID, default: 0, value: 0. t Information: 1220 : 7|14:12:54.8963||| ClosedCaptionsCache, default: , value: C:\inetpub\wwwroot\imfxcore\timedtextcache\. t Information: 1220 : 7|14:12:54.8963||| ClosedCaptionsStorage, default: , value: c:\Mediaflex\subs. t Information: 1220 : 7|14:12:54.8963||| TimeCodeFormat, default: , value: pal. t Information: 1220 : 7|14:12:54.8963||| RceMediaPath, default: , value: C:\edl\. t Information: 1220 : 7|14:12:54.8963||| RceMediaPath, default: , value: C:\edl\. t Information: 1220 : 7|14:12:54.8963||| RceCsmOutputPath, default: , value: C:\Inetpub\wwwroot\csm\. t Information: 1220 : 7|14:12:54.8963||| RceCsmUrl, default: , value: http://localhost/csm/. t Information: 1220 : 7|14:12:54.8963||| RceMediaSelection, default: , value: miLinkIdMatch. t Information: 1220 : 7|14:12:54.8963||| RequestBrowseJobPresetName, default: , value: . t Information: 1220 : 7|14:12:54.8963||| DontExtendDuration, default: false, value: False. t Information: 1220 : 7|14:12:54.8963||| V3ConfigUrl, default: , value: . t Information: 1220 : 7|14:12:54.8963||| StopWords, default: , value: . t Information: 1220 : 7|14:12:54.8963||| MisrTxFormat, default: G, value: G. t Information: 1220 : 7|14:12:54.8963||| ApiServer, default: , value: http://192.168.120.10:85. t Information: 1220 : 7|14:12:54.8963||| ApiTimeout, default: 120, value: 120. t Information: 1220 : 7|14:12:54.8963||| ApiWorkers, default: 10, value: 10. t Information: 1220 : 7|14:12:54.8963||| UsePerfCounters, default: false, value: false. t Information: 1220 : 7|14:12:54.8963||| LogGetCurrentUser, default: true, value: true. t Information: 1220 : 7|14:12:54.8963||| LogInternalApi, default: true, value: true. t Information: 1220 : 7|14:12:54.8963||| ThumbnailServer, default: , value: . t Information: 1220 : 7|14:12:54.8963||| LocationFilter, default: , value: . t Information: 1220 : 7|14:12:54.8963||| SvUtilServiceUrl, default: , value: . t Information: 1220 : 7|14:12:54.8963||| SolrConnection, default: , value: http://192.168.120.14:8983/solr. t Information: 1220 : 7|14:12:54.8963||| UseIndexServerSearch, default: false, value: True. t Information: 1220 : 7|14:12:54.8963||| SolrIndexVersion, default: 1, value: 6. t Information: 1220 : 7|14:12:54.8963||| SolrConnection, default: , value: http://192.168.120.14:8983/solr. t Information: 1220 : 7|14:12:54.8963||| FacetsGroups, default: , value: owners,season_id, series_id,version_key,item_type,media_type,media_format,episode_number. t Information: 1220 : 7|14:12:54.8963||| FacetsGroupsVersion, default: , value: owners,season_id, series_id,version_key,episode_number. t Information: 1220 : 7|14:12:54.8963||| FacetsGroupsChameleon, default: , value: season_id, series_id,genre,prod_year,version_key. t Information: 1220 : 7|14:12:54.8963||| PreviewPreset, default: , value: . t Information: 1220 : 7|14:12:54.8963||| DevMode, default: false, value: false. t Information: 1220 : 7|14:12:54.8963||| DisableSysMan, default: false, value: false. t Information: 1220 : 7|14:12:54.8963||| TimeCodeFormat, default: , value: pal. t Information: 1220 : 7|14:12:54.8963||| FileCatalystStorageDevice, default: , value: . t Information: 1220 : 7|14:12:54.8963||| UseResponsibilityTracking, default: true, value: True. t Information: 1220 : 7|14:12:54.8963||| SubtitleDeviceFilter, default: , value: . t Information: 1220 : 7|14:12:54.8963||| SystemMonitorNamedPipe, default: , value: . t Information: 1220 : 7|14:12:54.8963||| OracleMonitorEnable, default: false, value: False. t Information: 1220 : 7|14:12:54.8963||| ArcApiHost, default: , value: . t Information: 1220 : 7|14:12:54.8963||| SolrTimedTextSearch, default: false, value: false. t Information: 1220 : 7|14:12:54.8963||| ProductionDurationUsageID, default: 1, value: 1. t Information: 1220 : 7|14:12:55.1206|||GetStreamServers.. t Information: 1220 : 7|14:12:55.9331||| https://demo.tmd.tv/CBR Video/ |CBR Video| False t Information: 1220 : 7|14:12:55.9331||| https://demo.tmd.tv/CBR Images/ |CBR Images| False t Information: 1220 : 7|14:12:55.9331||| https://demo.tmd.tv/CBR Audio/ |CBR Audio| False t Information: 1220 : 7|14:12:55.9331||| https://demo.tmd.tv/Temp Upload/ |TEMP_UPLOAD| False t Information: 1220 : 7|14:12:55.9331||| http://localhost:82/images/ |IMAGES| False t Information: 1220 : 7|14:12:55.9331||| http://192.168.91.73/smoothcloud/ |SMOOTH_CLOUD| False t Information: 1220 : 7|14:12:55.9331||| http://192.168.91.73/cloudstore/ |CLOUD_STORE| False t Information: 1220 : 7|14:12:55.9331||| http://192.168.91.73/editsystemin/ |EDIT_SYSTEM_IN| False t Information: 1220 : 7|14:12:55.9331||| http://192.168.91.27:89/APPLEPROXY/ |APPLE_PROXY| False t Information: 1220 : 7|14:12:55.9331||| http://localhost:82/video/ |FILESTORE_VIDEO| False t Information: 1220 : 7|14:12:55.9331||| https://imfxv3tm.tmd.tv/streaming/ |Streaming| False t Information: 1220 : 7|14:12:55.9331||| https://imfxv3tm.tmd.tv/VideoServer/ |Video| False t Information: 1220 : 7|14:12:55.9331||| https://imfxv3tm.tmd.tv/AdobeIn/ |Adobe Premiere Pro In| False t Information: 1220 : 7|14:12:55.9331||| https://imfxv3tm.tmd.tv/AudioServer/ |Audio| False t Information: 1220 : 7|14:12:55.9331||| https://imfxv3tm.tmd.tv/ImageServer/ |Image| False t Information: 1220 : 7|14:12:55.9331||| https://imfxv3tm.tmd.tv/DocsServer/ |Docs| False t Information: 1220 : 7|14:12:55.9331||| https://imfxv3tm.tmd.tv/AmazonLabs/ |TEST HOUSE| False t Information: 1220 : 7|14:12:55.9331||| SolrConnectionUms, default: http://192.168.120.14:8983/solr, value: http://192.168.120.14:8983/solr. t Information: 1220 : 7|14:12:55.9331||| LogWebApi, default: false, value: false. t Information: 1220 : 7|14:12:55.9331||| EmbeddedRceUrl, default: , value: . t Information: 1220 : 7|14:12:55.9331||| InstallMode, default: , value: . t Information: 1220 : 7|14:12:55.9331||| SamlRequestAddress, default: , value: . t Information: 1220 : 7|14:12:55.9331||| SamlTrustedIssuer, default: , value: . t Information: 1220 : 7|14:12:55.9331||| SamlLoginRedirect, default: , value: . t Information: 1220 : 7|14:12:55.9331||| NaturalLangSearch, default: false, value: True. t Information: 1220 : 7|14:12:55.9331||| LocalUploadExpirationHours, default: 0, value: 0. t Information: 1220 : 7|14:12:55.9331||| LocalUploadDeviceId, default: 0, value: 0. t Information: 1220 : 7|14:12:55.9331||| VideosFileFormatIds, default: , value: . t Information: 1220 : 7|14:12:55.9331||| VideosStorageIds, default: , value: . t Information: 1220 : 7|14:12:55.9331||| OktaLoginField, default: , value: . t Information: 1220 : 7|14:12:55.9331||| AuthenticationTypes, default: , value: Native,PublicApiKey. t Information: 1220 : 7|14:12:55.9331|||OrabitWatcherBasic. Initialize. t Information: 1220 : 7|14:12:56.1425|||FillDictionaryCache. t Information: 1220 : 7|14:13:00.0018|||GetSupportedOperators t Information: 1220 : 7|14:13:00.2050|||CacheTechReports. t Information: 1220 : 7|14:13:00.4081|||& Cache update. Server (global) filled with timestamp 02:12:00.2518797. types null t Information: 1220 : 7|14:13:00.4081|||InitializeFromDatabase. 'Server=TECHM;User Id=imfx;password=..;Unicode=true;' direct False, home , timeout 15 t Information: 1220 : 7|14:13:00.4081|||FillDictionaryCache. t Information: 1220 : 7|14:13:00.4081|||& Cache update. Server (global) filled with timestamp 02:12:00.2831366. types FriendlyNames, DatabaseSearchFieldData t Information: 1220 : 7|14:13:01.0175|||OrabitWatcherBasic trying to connect.. t Information: 1220 : 7|14:13:01.0175|||========================================================================== t Information: 1220 : 7|14:13:01.0175|||IMFX CORE SERVER APPLICATION START. t Information: 1220 : 7|14:13:01.0175|||DLL VERSION: 3.0.0.111. t Information: 1220 : 7|14:13:01.0175|||IS TIMER HIGH RESOLUTION : True. t Information: 1220 : 7|14:13:01.0175||| UmsDev, default: False, value: False. t Information: 1220 : 7|14:13:01.0175|||OrabitWatcherBasic connected. t Information: 1220 : 7|14:13:01.0175|||OrabitWatcherBasic queue created tmd.cfg.in.d723838b-793e-4f90-a328-880dc8983ec7 t Transfer: 1220 : 7|14:13:03.6581|RSAqP2|DANIEL|OAuth: /api/view/searches/TitleSearch?_dc=1607609576695 t Transfer: 1220 : 7|14:13:03.6737|y~_Pm8|DANIEL|OAuth: /api/lookups/SearchSupportedOperators?_dc=1607609576563 t Transfer: 1220 : 7|14:13:03.6737|NVaaHL|DANIEL|OAuth: /api/view/info/VersionGrid?lang=en-GB&_dc=1607609576730 t Transfer: 1220 : 7|14:13:03.6737|nrj8z3|DANIEL|OAuth: /api/view/searchinfo/TitleSearch?_dc=1607609576560 t Transfer: 1220 : 7|14:13:03.6737|y~_Pm8|DANIEL|GetCurrentUser.. t Transfer: 1220 : 7|14:13:03.6737|y~_Pm8|DANIEL| OAuth authenticated t Transfer: 1220 : 7|14:13:03.6737|RSAqP2|DANIEL|GetCurrentUser.. t Transfer: 1220 : 7|14:13:03.6737|RSAqP2|DANIEL| OAuth authenticated t Transfer: 1220 : 7|14:13:03.6737|y~_Pm8|DANIEL| user DANIEL. t Transfer: 1220 : 7|14:13:03.6737|RSAqP2|DANIEL| user DANIEL. t Verbose: 1220 : 7|14:13:03.6737|RSAqP2|DANIEL|OAuth. User logged in: DANIEL t Verbose: 1220 : 7|14:13:03.6737|y~_Pm8|DANIEL|OAuth. User logged in: DANIEL t Transfer: 1220 : 7|14:13:03.6737|NVaaHL|DANIEL|GetCurrentUser.. t Transfer: 1220 : 7|14:13:03.6893|NVaaHL|DANIEL| OAuth authenticated t Transfer: 1220 : 7|14:13:03.6893|NVaaHL|DANIEL| user DANIEL. t Verbose: 1220 : 7|14:13:03.6893|NVaaHL|DANIEL|OAuth. User logged in: DANIEL t Transfer: 1220 : 7|14:13:03.6893|OFNt8U|DANIEL|OAuth: /api/view/info/MediaGrid?lang=en-GB&_dc=1607609576857 t Transfer: 1220 : 7|14:13:03.6893|OFNt8U|DANIEL|GetCurrentUser.. t Transfer: 1220 : 7|14:13:03.6893|OFNt8U|DANIEL| OAuth authenticated t Transfer: 1220 : 7|14:13:03.6893|OFNt8U|DANIEL| user DANIEL. t Verbose: 1220 : 7|14:13:03.6893|OFNt8U|DANIEL|OAuth. User logged in: DANIEL t Transfer: 1220 : 7|14:13:03.6893|nrj8z3|DANIEL|GetCurrentUser.. t Transfer: 1220 : 7|14:13:03.6893|nrj8z3|DANIEL| OAuth authenticated t Transfer: 1220 : 7|14:13:03.6893|nrj8z3|DANIEL| user DANIEL. t Verbose: 1220 : 7|14:13:03.6893|nrj8z3|DANIEL|OAuth. User logged in: DANIEL t Transfer: 1220 : 7|14:13:03.6893|1kHNtX|DANIEL|OAuth: /api/user-preferences?keys=adv.recent.searches.titles&_dc=1607609576573 t Transfer: 1220 : 7|14:13:03.6893|1kHNtX|DANIEL|GetCurrentUser.. t Transfer: 1220 : 7|14:13:03.6893|1kHNtX|DANIEL| OAuth authenticated t Transfer: 1220 : 7|14:13:03.6893|1kHNtX|DANIEL| user DANIEL. t Verbose: 1220 : 7|14:13:03.6893|1kHNtX|DANIEL|OAuth. User logged in: DANIEL t Information: 1220 : 7|14:13:03.6893|1kHNtX|DANIEL|GetUserDataByKeys: adv.recent.searches.titles t Transfer: 1220 : 7|14:13:03.6893|1kHNtX|DANIEL|GetCurrentUser.. t Transfer: 1220 : 7|14:13:03.6893|1kHNtX|DANIEL| OAuth authenticated t Transfer: 1220 : 7|14:13:03.6893|1kHNtX|DANIEL| user DANIEL. t Information: 1220 : 7|14:13:03.6893|NVaaHL|DANIEL|GetGridViewBuilder. builder type VersionGrid. t Information: 1220 : 7|14:13:03.6893|OFNt8U|DANIEL|GetGridViewBuilder. builder type MediaGrid. t Information: 1220 : 7|14:13:03.6893|RSAqP2|DANIEL|GetSavedSearchNames. search type TitleSearch. t Transfer: 1220 : 7|14:13:03.6893|RSAqP2|DANIEL|GetCurrentUser.. t Transfer: 1220 : 7|14:13:03.6893|RSAqP2|DANIEL| OAuth authenticated t Transfer: 1220 : 7|14:13:03.6893|RSAqP2|DANIEL| user DANIEL. t Transfer: 1220 : 7|14:13:03.6893|NVaaHL|DANIEL|GetCurrentUser.. t Transfer: 1220 : 7|14:13:03.6893|NVaaHL|DANIEL| OAuth authenticated t Transfer: 1220 : 7|14:13:03.6893|OFNt8U|DANIEL|GetCurrentUser.. t Transfer: 1220 : 7|14:13:03.6893|NVaaHL|DANIEL| user DANIEL. t Transfer: 1220 : 7|14:13:03.6893|OFNt8U|DANIEL| OAuth authenticated t Transfer: 1220 : 7|14:13:03.6893|OFNt8U|DANIEL| user DANIEL. t Information: 1220 : 7|14:13:03.6893|nrj8z3|DANIEL|GetAdvSearchColumns. search type TitleSearch grid . t Information: 1220 : 7|14:13:03.9081|OFNt8U|DANIEL|UserGridView. LoadView. ID 760, Name Default. t Information: 1220 : 7|14:13:03.9081|NVaaHL|DANIEL|UserGridView. LoadView. ID 899, Name Default. t Transfer: 1220 : 7|14:13:03.9081|OFNt8U|DANIEL|GetCurrentUser.. t Transfer: 1220 : 7|14:13:03.9081|OFNt8U|DANIEL| OAuth authenticated t Transfer: 1220 : 7|14:13:03.9081|OFNt8U|DANIEL| user DANIEL. t Transfer: 1220 : 7|14:13:03.9081|NVaaHL|DANIEL|GetCurrentUser.. t Transfer: 1220 : 7|14:13:03.9081|NVaaHL|DANIEL| OAuth authenticated t Transfer: 1220 : 7|14:13:03.9081|NVaaHL|DANIEL| user DANIEL. t Transfer: 1220 : 7|14:13:03.9081|NVaaHL|DANIEL|GetCurrentUser.. t Transfer: 1220 : 7|14:13:03.9081|NVaaHL|DANIEL| OAuth authenticated t Transfer: 1220 : 7|14:13:03.9081|NVaaHL|DANIEL| user DANIEL. t Verbose: 1220 : 7|14:13:03.9081|nrj8z3|DANIEL|imfx v3 API took 0.109s '/api/view/searchinfo/TitleSearch?_dc=1607609576560' t Verbose: 1220 : 7|14:13:03.9081|1kHNtX|DANIEL|imfx v3 API took 0.133s '/api/user-preferences?keys=adv.recent.searches.titles&_dc=1607609576573' t Verbose: 1220 : 7|14:13:03.9081|y~_Pm8|DANIEL|imfx v3 API took 0.110s '/api/lookups/SearchSupportedOperators?_dc=1607609576563' t Verbose: 1220 : 7|14:13:03.9081|NVaaHL|DANIEL|imfx v3 API took 0.161s '/api/view/info/VersionGrid?lang=en-GB&_dc=1607609576730' t Verbose: 1220 : 7|14:13:03.9081|RSAqP2|DANIEL|imfx v3 API took 0.172s '/api/view/searches/TitleSearch?_dc=1607609576695' t Transfer: 1220 : 7|14:13:03.9081|OFNt8U|DANIEL|GetCurrentUser.. t Transfer: 1220 : 7|14:13:03.9081|OFNt8U|DANIEL| OAuth authenticated t Transfer: 1220 : 7|14:13:03.9081|OFNt8U|DANIEL| user DANIEL. t Verbose: 1220 : 7|14:13:03.9081|OFNt8U|DANIEL|imfx v3 API took 0.193s '/api/view/info/MediaGrid?lang=en-GB&_dc=1607609576857' t Transfer: 1220 : 7|14:13:04.3168|Ynf6Fk|DANIEL|OAuth: /api/view/info/TitleTree?lang=en-GB&_dc=1607609576911 t Transfer: 1220 : 7|14:13:04.3168|Ynf6Fk|DANIEL|GetCurrentUser.. t Transfer: 1220 : 7|14:13:04.3168|Ynf6Fk|DANIEL| OAuth authenticated t Transfer: 1220 : 7|14:13:04.3168|Ynf6Fk|DANIEL| user DANIEL. t Verbose: 1220 : 7|14:13:04.3168|Ynf6Fk|DANIEL|OAuth. User logged in: DANIEL t Information: 1220 : 7|14:13:04.3168|Ynf6Fk|DANIEL|GetGridViewBuilder. builder type TitleTree. t Transfer: 1220 : 7|14:13:04.3168|Ynf6Fk|DANIEL|GetCurrentUser.. t Transfer: 1220 : 7|14:13:04.3168|Ynf6Fk|DANIEL| OAuth authenticated t Transfer: 1220 : 7|14:13:04.3168|Ynf6Fk|DANIEL| user DANIEL. t Information: 1220 : 7|14:13:04.3168|Ynf6Fk|DANIEL|UserGridView. LoadView. ID 736, Name Default. t Transfer: 1220 : 7|14:13:04.3168|Ynf6Fk|DANIEL|GetCurrentUser.. t Transfer: 1220 : 7|14:13:04.3168|Ynf6Fk|DANIEL| OAuth authenticated t Transfer: 1220 : 7|14:13:04.3168|Ynf6Fk|DANIEL| user DANIEL. t Transfer: 1220 : 7|14:13:04.3168|Ynf6Fk|DANIEL|GetCurrentUser.. t Transfer: 1220 : 7|14:13:04.3168|Ynf6Fk|DANIEL| OAuth authenticated t Transfer: 1220 : 7|14:13:04.3168|Ynf6Fk|DANIEL| user DANIEL. t Verbose: 1220 : 7|14:13:04.3168|Ynf6Fk|DANIEL|imfx v3 API took 0.007s '/api/view/info/TitleTree?lang=en-GB&_dc=1607609576911' t Transfer: 1220 : 7|14:13:04.3168|fB~i5v|DANIEL|OAuth: /api/settings/user/uploadSettings?_dc=1607609587558 t Transfer: 1220 : 7|14:13:04.3168|fB~i5v|DANIEL|GetCurrentUser.. t Transfer: 1220 : 7|14:13:04.3168|fB~i5v|DANIEL| OAuth authenticated t Transfer: 1220 : 7|14:13:04.3168|fB~i5v|DANIEL| user DANIEL. t Verbose: 1220 : 7|14:13:04.3168|fB~i5v|DANIEL|OAuth. User logged in: DANIEL t Transfer: 1220 : 7|14:13:04.3168|fB~i5v|DANIEL|GetCurrentUser.. t Transfer: 1220 : 7|14:13:04.3168|fB~i5v|DANIEL| OAuth authenticated t Transfer: 1220 : 7|14:13:04.3168|fB~i5v|DANIEL| user DANIEL. t Verbose: 1220 : 7|14:13:04.3168|fB~i5v|DANIEL|imfx v3 API took 0.015s '/api/settings/user/uploadSettings?_dc=1607609587558' t Transfer: 1220 : 7|14:13:04.5199|ezVwI5|DANIEL|OAuth: /api/settings/user/uploadSettings?_dc=1607609587699 t Transfer: 1220 : 7|14:13:04.5199|ezVwI5|DANIEL|GetCurrentUser.. t Transfer: 1220 : 7|14:13:04.5199|ezVwI5|DANIEL| OAuth authenticated t Transfer: 1220 : 7|14:13:04.5199|ezVwI5|DANIEL| user DANIEL. t Verbose: 1220 : 7|14:13:04.5199|ezVwI5|DANIEL|OAuth. User logged in: DANIEL t Transfer: 1220 : 7|14:13:04.5199|ezVwI5|DANIEL|GetCurrentUser.. t Transfer: 1220 : 7|14:13:04.5199|ezVwI5|DANIEL| OAuth authenticated t Transfer: 1220 : 7|14:13:04.5199|ezVwI5|DANIEL| user DANIEL. t Verbose: 1220 : 7|14:13:04.5199|ezVwI5|DANIEL|imfx v3 API took 0.004s '/api/settings/user/uploadSettings?_dc=1607609587699' t Transfer: 1220 : 7|14:13:05.9463|K9boxR|DANIEL|OAuth: /api/view/searchinfo/Version?_dc=1607609589105 t Transfer: 1220 : 7|14:13:05.9463|K9boxR|DANIEL|GetCurrentUser.. t Transfer: 1220 : 7|14:13:05.9463|K9boxR|DANIEL| OAuth authenticated t Transfer: 1220 : 7|14:13:05.9463|K9boxR|DANIEL| user DANIEL. t Verbose: 1220 : 7|14:13:05.9463|K9boxR|DANIEL|OAuth. User logged in: DANIEL t Information: 1220 : 7|14:13:05.9463|K9boxR|DANIEL|GetAdvSearchColumns. search type Version grid . t Verbose: 1220 : 7|14:13:05.9463|K9boxR|DANIEL|imfx v3 API took 0.000s '/api/view/searchinfo/Version?_dc=1607609589105' t Transfer: 1220 : 7|14:13:05.9463|M7bX2I|DANIEL|OAuth: /api/user-preferences?keys=adv.recent.searches.versions&_dc=1607609589111 t Transfer: 1220 : 7|14:13:05.9463|M7bX2I|DANIEL|GetCurrentUser.. t Transfer: 1220 : 7|14:13:05.9463|M7bX2I|DANIEL| OAuth authenticated t Transfer: 1220 : 7|14:13:05.9463|M7bX2I|DANIEL| user DANIEL. t Verbose: 1220 : 7|14:13:05.9463|M7bX2I|DANIEL|OAuth. User logged in: DANIEL t Information: 1220 : 7|14:13:05.9463|M7bX2I|DANIEL|GetUserDataByKeys: adv.recent.searches.versions t Transfer: 1220 : 7|14:13:05.9463|M7bX2I|DANIEL|GetCurrentUser.. t Transfer: 1220 : 7|14:13:05.9463|M7bX2I|DANIEL| OAuth authenticated t Transfer: 1220 : 7|14:13:05.9463|M7bX2I|DANIEL| user DANIEL. t Verbose: 1220 : 7|14:13:05.9463|M7bX2I|DANIEL|imfx v3 API took 0.008s '/api/user-preferences?keys=adv.recent.searches.versions&_dc=1607609589111' t Transfer: 1220 : 7|14:13:05.9463|YCaPbC|DANIEL|OAuth: /api/view/searches/Version?_dc=1607609589208 t Transfer: 1220 : 7|14:13:05.9463|YCaPbC|DANIEL|GetCurrentUser.. t Transfer: 1220 : 7|14:13:05.9463|YCaPbC|DANIEL| OAuth authenticated t Transfer: 1220 : 7|14:13:05.9463|YCaPbC|DANIEL| user DANIEL. t Verbose: 1220 : 7|14:13:05.9463|YCaPbC|DANIEL|OAuth. User logged in: DANIEL t Information: 1220 : 7|14:13:05.9463|YCaPbC|DANIEL|GetSavedSearchNames. search type Version. t Transfer: 1220 : 7|14:13:05.9463|YCaPbC|DANIEL|GetCurrentUser.. t Transfer: 1220 : 7|14:13:05.9463|YCaPbC|DANIEL| OAuth authenticated t Transfer: 1220 : 7|14:13:05.9463|YCaPbC|DANIEL| user DANIEL. t Verbose: 1220 : 7|14:13:05.9463|YCaPbC|DANIEL|imfx v3 API took 0.005s '/api/view/searches/Version?_dc=1607609589208' t Transfer: 1220 : 7|14:13:05.9463|PI0dDy|DANIEL|OAuth: /api/settings/user/searchLayoutConfig?_dc=1607609589258 t Transfer: 1220 : 7|14:13:05.9463|PI0dDy|DANIEL|GetCurrentUser.. t Transfer: 1220 : 7|14:13:05.9463|PI0dDy|DANIEL| OAuth authenticated t Transfer: 1220 : 7|14:13:05.9463|PI0dDy|DANIEL| user DANIEL. t Verbose: 1220 : 7|14:13:05.9463|PI0dDy|DANIEL|OAuth. User logged in: DANIEL t Transfer: 1220 : 7|14:13:05.9463|PI0dDy|DANIEL|GetCurrentUser.. t Transfer: 1220 : 7|14:13:05.9463|PI0dDy|DANIEL| OAuth authenticated t Transfer: 1220 : 7|14:13:05.9463|PI0dDy|DANIEL| user DANIEL. t Verbose: 1220 : 7|14:13:05.9463|PI0dDy|DANIEL|imfx v3 API took 0.003s '/api/settings/user/searchLayoutConfig?_dc=1607609589258' t Transfer: 1220 : 7|14:13:06.1536|ViNGCQ|DANIEL|OAuth: /api/settings/user/uploadSettings?_dc=1607609589447 t Transfer: 1220 : 7|14:13:06.1536|ViNGCQ|DANIEL|GetCurrentUser.. t Transfer: 1220 : 7|14:13:06.1536|ViNGCQ|DANIEL| OAuth authenticated t Transfer: 1220 : 7|14:13:06.1536|ViNGCQ|DANIEL| user DANIEL. t Verbose: 1220 : 7|14:13:06.1536|ViNGCQ|DANIEL|OAuth. User logged in: DANIEL t Transfer: 1220 : 7|14:13:06.1536|ViNGCQ|DANIEL|GetCurrentUser.. t Transfer: 1220 : 7|14:13:06.1536|ViNGCQ|DANIEL| OAuth authenticated t Transfer: 1220 : 7|14:13:06.1544|ViNGCQ|DANIEL| user DANIEL. t Verbose: 1220 : 7|14:13:06.1544|ViNGCQ|DANIEL|imfx v3 API took 0.004s '/api/settings/user/uploadSettings?_dc=1607609589447' t Transfer: 1220 : 7|14:13:11.0297|ZRCVH8|DANIEL|OAuth: /api/v3/search-suggestion/?_dc=1607609594224 t Transfer: 1220 : 7|14:13:11.0297|ZRCVH8|DANIEL|GetCurrentUser.. t Transfer: 1220 : 7|14:13:11.0297|ZRCVH8|DANIEL| OAuth authenticated t Transfer: 1220 : 7|14:13:11.0297|ZRCVH8|DANIEL| user DANIEL. t Verbose: 1220 : 7|14:13:11.0297|ZRCVH8|DANIEL|OAuth. User logged in: DANIEL t Transfer: 1220 : 7|14:13:11.0297|jkrFk7|DANIEL|OAuth: /api/v3/search-suggestion/?_dc=1607609594304 t Transfer: 1220 : 7|14:13:11.0297|jkrFk7|DANIEL|GetCurrentUser.. t Transfer: 1220 : 7|14:13:11.0297|jkrFk7|DANIEL| OAuth authenticated t Transfer: 1220 : 7|14:13:11.0297|jkrFk7|DANIEL| user DANIEL. t Verbose: 1220 : 7|14:13:11.0297|jkrFk7|DANIEL|OAuth. User logged in: DANIEL t Transfer: 1220 : 7|14:13:11.0297|jkrFk7|DANIEL|GetCurrentUser.. t Transfer: 1220 : 7|14:13:11.0297|jkrFk7|DANIEL| OAuth authenticated t Transfer: 1220 : 7|14:13:11.0297|jkrFk7|DANIEL| user DANIEL. t Transfer: 1220 : 7|14:13:11.0297|ZRCVH8|DANIEL|GetCurrentUser.. t Transfer: 1220 : 7|14:13:11.0297|ZRCVH8|DANIEL| OAuth authenticated t Transfer: 1220 : 7|14:13:11.0297|ZRCVH8|DANIEL| user DANIEL. t Transfer: 1220 : 7|14:13:11.2484|998hAu|DANIEL|OAuth: /api/v3/search-suggestion/?_dc=1607609594478 t Transfer: 1220 : 7|14:13:11.2484|998hAu|DANIEL|GetCurrentUser.. t Transfer: 1220 : 7|14:13:11.2484|998hAu|DANIEL| OAuth authenticated t Transfer: 1220 : 7|14:13:11.2484|998hAu|DANIEL| user DANIEL. t Verbose: 1220 : 7|14:13:11.2484|998hAu|DANIEL|OAuth. User logged in: DANIEL t Transfer: 1220 : 7|14:13:11.2484|998hAu|DANIEL|GetCurrentUser.. t Transfer: 1220 : 7|14:13:11.2484|998hAu|DANIEL| OAuth authenticated t Transfer: 1220 : 7|14:13:11.2484|998hAu|DANIEL| user DANIEL. t Transfer: 1220 : 7|14:13:11.4515|LGOIY0|DANIEL|OAuth: /api/v3/search-suggestion/?_dc=1607609594727 t Transfer: 1220 : 7|14:13:11.4515|LGOIY0|DANIEL|GetCurrentUser.. t Transfer: 1220 : 7|14:13:11.4515|LGOIY0|DANIEL| OAuth authenticated t Transfer: 1220 : 7|14:13:11.4515|LGOIY0|DANIEL| user DANIEL. t Verbose: 1220 : 7|14:13:11.4515|LGOIY0|DANIEL|OAuth. User logged in: DANIEL t Transfer: 1220 : 7|14:13:11.4515|LGOIY0|DANIEL|GetCurrentUser.. t Transfer: 1220 : 7|14:13:11.4515|LGOIY0|DANIEL| OAuth authenticated t Transfer: 1220 : 7|14:13:11.4515|LGOIY0|DANIEL| user DANIEL. t Verbose: 1220 : 7|14:13:11.6547|jkrFk7|DANIEL|imfx v3 API took 0.515s '/api/v3/search-suggestion/?_dc=1607609594304' t Verbose: 1220 : 7|14:13:11.6547|ZRCVH8|DANIEL|imfx v3 API took 0.515s '/api/v3/search-suggestion/?_dc=1607609594224' t Transfer: 1220 : 7|14:13:11.6547|5hxeKE|DANIEL|OAuth: /api/v3/search/versions?_dc=1607609594865 t Transfer: 1220 : 7|14:13:11.6547|5hxeKE|DANIEL|GetCurrentUser.. t Transfer: 1220 : 7|14:13:11.6547|5hxeKE|DANIEL| OAuth authenticated t Transfer: 1220 : 7|14:13:11.6547|5hxeKE|DANIEL| user DANIEL. t Verbose: 1220 : 7|14:13:11.6547|5hxeKE|DANIEL|OAuth. User logged in: DANIEL t Verbose: 1220 : 7|14:13:11.6547|998hAu|DANIEL|imfx v3 API took 0.407s '/api/v3/search-suggestion/?_dc=1607609594478' t Verbose: 1220 : 7|14:13:11.6547|LGOIY0|DANIEL|imfx v3 API took 0.172s '/api/v3/search-suggestion/?_dc=1607609594727' t Information: 1220 : 7|14:13:11.6547|5hxeKE|DANIEL|V3Api.SearchVersions t Information: 1220 : 7|14:13:11.6547|5hxeKE|DANIEL|V3Api.SearchGeneric t Transfer: 1220 : 7|14:13:11.6547|5hxeKE|DANIEL|GetCurrentUser.. t Transfer: 1220 : 7|14:13:11.6547|5hxeKE|DANIEL| OAuth authenticated t Transfer: 1220 : 7|14:13:11.6547|5hxeKE|DANIEL| user DANIEL. t Transfer: 1220 : 7|14:13:11.6547|5hxeKE|DANIEL|GetCurrentUser.. t Transfer: 1220 : 7|14:13:11.6547|5hxeKE|DANIEL| OAuth authenticated t Transfer: 1220 : 7|14:13:11.6547|5hxeKE|DANIEL| user DANIEL. t Information: 1220 : 7|14:13:11.6547|5hxeKE|DANIEL|Running solr search: [q, (((title:(diving))^2 OR series:(diving) OR (titleMergedNgram:diving*)^10 OR versionid1:(diving) OR progid1:(diving)) AND deleted_flag:(0) AND (owners:((03BO) OR (03GD) OR (03GO) OR (03HA) OR (03JO) OR (03LI) OR (03NB) OR (03NM) OR (03NO) OR (03OR) OR (03SB) OR (03SC) OR (03SE) OR (03SG) OR (03SK) OR (03SM) OR (03SN) OR (03SS) OR (03SY) OR (03UP) OR (03VA) OR (03VB) OR (03VL) OR (03VT) OR (3\+ES) OR (3PD) OR (3PLV) OR (AECHD) OR (AECSD) OR (AL) OR (AMAY) OR (AMC) OR (ANTV) OR (ATP) OR (BBC) OR (BEDIG) OR (CENT) OR (CS) OR (CTCB) OR (CTCE) OR (DAVI) OR (DMA) OR (DMF) OR (DMY) OR (DTV) OR (EST) OR (EUROSPORT) OR (HDC1) OR (HDP1) OR (HDP2) OR (HUB) OR (ICCCTY) OR (ICCCWC) OR (ICCCWL2) OR (ICCICC) OR (ICCTWT) OR (ICCU19CWC) OR (ICCWCCL) OR (ICCWCL) OR (ICCWCP) OR (ICCWTC) OR (ICCWTT) OR (ICCWWC) OR (ITV) OR (KNL2) OR (KNVA) OR (LMH) OR (LNT) OR (MBNS) OR (MED) OR (MM) OR (MTG) OR (NAA) OR (NICK) OR (NVA) OR (OSP) OR (PBOY) OR (PMS) OR (PPL) OR (PSP) OR (Play) OR (RTR) OR (SFP1) OR (SFP2) OR (SPG) OR (SPTV) OR (T3LT) OR (T3LV) OR (T6LT) OR (T6LV) OR (T8LT) OR (TECHM) OR (TMD) OR (TV10) OR (TV1A) OR (TV1B) OR (TV1C) OR (TV1D) OR (TV1E) OR (TV1F) OR (TV1K) OR (TV1N) OR (TV1P) OR (TV1S) OR (TV2S) OR (TV3D) OR (TV3N) OR (TV3S) OR (TV5L) OR (TV6E) OR (TV6H) OR (TV6N) OR (TV6S) OR (TV8) OR (TVAE) OR (TVDP) OR (TVONE) OR (TVPB) OR (TVPU) OR (TVSL) OR (V1G) OR (V1TZ) OR (V3H) OR (V4N) OR (VEC) OR (VEPL) OR (VEPO) OR (VEXE) OR (VEXR) OR (VHIS) OR (VHPO) OR (VIVA) OR (VNC) OR (VNE) OR (VNH) OR (VNHD) OR (VNPO) OR (VODD) OR (VODE) OR (VODF) OR (VODN) OR (VODS) OR (VS2) OR (VS3) OR (VSAT) OR (VSD) OR (VSD2) OR (VSE) OR (VSG) OR (VSHD) OR (VSS) OR (WCIU) OR ("YLE TV1") OR (ZTVS))))] t Information: 1220 : 7|14:13:11.6547|5hxeKE|DANIEL|Solr query returned: 141 in 11ms t Information: 1220 : 7|14:13:11.8578|5hxeKE|DANIEL|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 : 7|14:13:12.0765|5hxeKE|DANIEL|Running version search. User: 342 Simple Search: diving Trying to use Solr Search... Solr completed in: 133ms. Returned lines: 141 Running Oracle search. Oracle version search timing: 167ms. 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 Verbose: 1220 : 7|14:13:12.0765|5hxeKE|DANIEL|imfx v3 API took 0.327s '/api/v3/search/versions?_dc=1607609594865' t Transfer: 1220 : 7|14:13:12.2797|46wBzb|DANIEL|OAuth: /api/user-preferences?_dc=1607609595611 t Transfer: 1220 : 7|14:13:12.2797|46wBzb|DANIEL|GetCurrentUser.. t Transfer: 1220 : 7|14:13:12.2797|46wBzb|DANIEL| OAuth authenticated t Transfer: 1220 : 7|14:13:12.2797|46wBzb|DANIEL| user DANIEL. t Verbose: 1220 : 7|14:13:12.2797|46wBzb|DANIEL|OAuth. User logged in: DANIEL t Verbose: 1220 : 7|14:13:12.2797|46wBzb|DANIEL|StoreUserDataByKeys.. t Transfer: 1220 : 7|14:13:12.2797|46wBzb|DANIEL|GetCurrentUser.. t Transfer: 1220 : 7|14:13:12.2797|46wBzb|DANIEL| OAuth authenticated t Transfer: 1220 : 7|14:13:12.2797|46wBzb|DANIEL| user DANIEL. t Verbose: 1220 : 7|14:13:12.2797|46wBzb|DANIEL|imfx v3 API took 0.011s '/api/user-preferences?_dc=1607609595611' t Transfer: 1220 : 7|14:13:17.9763|62vSfs|DANIEL|OAuth: /api/v3/version-details/299402?_dc=1607609601223 t Transfer: 1220 : 7|14:13:17.9763|62vSfs|DANIEL|GetCurrentUser.. t Transfer: 1220 : 7|14:13:17.9763|62vSfs|DANIEL| OAuth authenticated t Transfer: 1220 : 7|14:13:17.9763|62vSfs|DANIEL| user DANIEL. t Verbose: 1220 : 7|14:13:17.9763|62vSfs|DANIEL|OAuth. User logged in: DANIEL t Transfer: 1220 : 7|14:13:17.9763|62vSfs|DANIEL|GetCurrentUser.. t Transfer: 1220 : 7|14:13:17.9763|62vSfs|DANIEL| OAuth authenticated t Transfer: 1220 : 7|14:13:17.9763|62vSfs|DANIEL| user DANIEL. t Verbose: 1220 : 7|14:13:18.1794|62vSfs|DANIEL|imfx v3 API took 0.164s '/api/v3/version-details/299402?_dc=1607609601223' t Transfer: 1220 : 7|14:13:18.1794|M9YtV4|DANIEL|OAuth: /api/v3/detailsview/VersionDetails/0?lang=en-GB&_dc=1607609601458 t Transfer: 1220 : 7|14:13:18.1794|M9YtV4|DANIEL|GetCurrentUser.. t Transfer: 1220 : 7|14:13:18.1794|M9YtV4|DANIEL| OAuth authenticated t Transfer: 1220 : 7|14:13:18.1794|M9YtV4|DANIEL| user DANIEL. t Verbose: 1220 : 7|14:13:18.1794|M9YtV4|DANIEL|OAuth. User logged in: DANIEL t Transfer: 1220 : 7|14:13:18.1794|M9YtV4|DANIEL|GetCurrentUser.. t Transfer: 1220 : 7|14:13:18.1794|M9YtV4|DANIEL| OAuth authenticated t Transfer: 1220 : 7|14:13:18.1794|M9YtV4|DANIEL| user DANIEL. t Information: 1220 : 7|14:13:18.3825|M9YtV4|DANIEL|GetSystemPref. Pref: DetailsView, Type: -4014, subType: 0 t Information: 1220 : 7|14:13:18.3825|M9YtV4|DANIEL|GetSystemPref. Pref: DetailsView, Type: -4014, subType: 0 t Verbose: 1220 : 7|14:13:18.3825|M9YtV4|DANIEL|imfx v3 API took 0.154s '/api/v3/detailsview/VersionDetails/0?lang=en-GB&_dc=1607609601458' t Transfer: 1220 : 7|14:13:18.7888|pnYTvw|DANIEL|OAuth: /api/lookups/FriendlyNames?_dc=1607609602034 t Transfer: 1220 : 7|14:13:18.7888|pnYTvw|DANIEL|GetCurrentUser.. t Transfer: 1220 : 7|14:13:18.7888|pnYTvw|DANIEL| OAuth authenticated t Transfer: 1220 : 7|14:13:18.7888|pnYTvw|DANIEL| user DANIEL. t Verbose: 1220 : 7|14:13:18.7888|pnYTvw|DANIEL|OAuth. User logged in: DANIEL t Verbose: 1220 : 7|14:13:18.7888|pnYTvw|DANIEL|imfx v3 API took 0.000s '/api/lookups/FriendlyNames?_dc=1607609602034' t Transfer: 1220 : 7|14:13:18.9919|2GtBQa|DANIEL|OAuth: /api/v3/imf/299402?_dc=1607609602235 t Transfer: 1220 : 7|14:13:18.9919|2GtBQa|DANIEL|GetCurrentUser.. t Transfer: 1220 : 7|14:13:18.9919|2GtBQa|DANIEL| OAuth authenticated t Transfer: 1220 : 7|14:13:18.9919|2GtBQa|DANIEL| user DANIEL. t Verbose: 1220 : 7|14:13:18.9919|2GtBQa|DANIEL|OAuth. User logged in: DANIEL t Verbose: 1220 : 7|14:13:18.9919|2GtBQa|DANIEL|imfx v3 API took 0.044s '/api/v3/imf/299402?_dc=1607609602235' t Transfer: 1220 : 7|14:13:20.0075|C4RcAe|DANIEL|OAuth: /api/metadata/1040/299402?_dc=1607609603282 t Transfer: 1220 : 7|14:13:20.0075|C4RcAe|DANIEL|GetCurrentUser.. t Transfer: 1220 : 7|14:13:20.0075|C4RcAe|DANIEL| OAuth authenticated t Transfer: 1220 : 7|14:13:20.0075|C4RcAe|DANIEL| user DANIEL. t Verbose: 1220 : 7|14:13:20.0075|C4RcAe|DANIEL|OAuth. User logged in: DANIEL t Verbose: 1220 : 7|14:13:20.0075|C4RcAe|DANIEL|imfx v3 API took 0.062s '/api/metadata/1040/299402?_dc=1607609603282' t Transfer: 1220 : 7|14:13:30.7820|CyBXb7|DANIEL|OAuth: /api/v3/version/299402/media?_dc=1607609614049 t Transfer: 1220 : 7|14:13:30.7820|CyBXb7|DANIEL|GetCurrentUser.. t Transfer: 1220 : 7|14:13:30.7820|CyBXb7|DANIEL| OAuth authenticated t Transfer: 1220 : 7|14:13:30.7820|CyBXb7|DANIEL| user DANIEL. t Verbose: 1220 : 7|14:13:30.7820|CyBXb7|DANIEL|OAuth. User logged in: DANIEL t Information: 1220 : 7|14:13:30.7820|CyBXb7|DANIEL|V3Api.SearchGeneric t Transfer: 1220 : 7|14:13:30.7820|CyBXb7|DANIEL|GetCurrentUser.. t Transfer: 1220 : 7|14:13:30.7820|CyBXb7|DANIEL| OAuth authenticated t Transfer: 1220 : 7|14:13:30.7820|CyBXb7|DANIEL| user DANIEL. t Information: 1220 : 7|14:13:30.7820|CyBXb7|DANIEL|MediaSearch SQL: select r.*, nvl((select TMD_STR_AGG(c.u_id_pfix ) from tm_ctnrs c, tm_mi_tpi_lnx l where l.miid=r.id and c.u_id=l.tpiid and r.media_type=1),'') BARCODE, nvl(lnk.lib_loc_ext_id,0) lib_loc_ext_id, nvl(lnk.ctnr_loan_stat,0) ctnr_loan_status, nvl(lnk.ctnr_stat,0) ctnr_stat, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID , GETMEDIALOC(r.id, r.media_type, r.compil, r.m_ctnr_int_o_loc, r.m_ctnr_ext_o_loc, r.m_ctnr_loc) LOCATION, nvl(dfl.fSOM,0) FILE_SOM, nvl(dfl.fEOM,0) FILE_EOM, dfl.fos_fname FILENAME, dfl.DFILE_LINK_GUID, dfl.OS_GUID, dfl.SUB_FOLDER, dfl.ORIGINAL_FILENAME from (select a.*, rownum rnum from (select m.*, coalesce(m.primary_thumb_id, (select v.primary_thumb_id from tm_pg_rl v where v.id=m.pgm_parent_id)) primary_thumb_id2 from tmddba.tm_mis m where media_type>0 and item_type>0 AND PGM_PARENT_ID=:pgm_parent_id_1 and m.mi_deleted=0 AND (INSTR(m.OWNERS,'|03BO|')>0 OR INSTR(m.OWNERS,'|03GD|')>0 OR INSTR(m.OWNERS,'|03GO|')>0 OR INSTR(m.OWNERS,'|03HA|')>0 OR INSTR(m.OWNERS,'|03JO|')>0 OR INSTR(m.OWNERS,'|03LI|')>0 OR INSTR(m.OWNERS,'|03NB|')>0 OR INSTR(m.OWNERS,'|03NM|')>0 OR INSTR(m.OWNERS,'|03NO|')>0 OR INSTR(m.OWNERS,'|03OR|')>0 OR INSTR(m.OWNERS,'|03SB|')>0 OR INSTR(m.OWNERS,'|03SC|')>0 OR INSTR(m.OWNERS,'|03SE|')>0 OR INSTR(m.OWNERS,'|03SG|')>0 OR INSTR(m.OWNERS,'|03SK|')>0 OR INSTR(m.OWNERS,'|03SM|')>0 OR INSTR(m.OWNERS,'|03SN|')>0 OR INSTR(m.OWNERS,'|03SS|')>0 OR INSTR(m.OWNERS,'|03SY|')>0 OR INSTR(m.OWNERS,'|03UP|')>0 OR INSTR(m.OWNERS,'|03VA|')>0 OR INSTR(m.OWNERS,'|03VB|')>0 OR INSTR(m.OWNERS,'|03VL|')>0 OR INSTR(m.OWNERS,'|03VT|')>0 OR INSTR(m.OWNERS,'|3+ES|')>0 OR INSTR(m.OWNERS,'|3PD|')>0 OR INSTR(m.OWNERS,'|3PLV|')>0 OR INSTR(m.OWNERS,'|AECHD|')>0 OR INSTR(m.OWNERS,'|AECSD|')>0 OR INSTR(m.OWNERS,'|AL|')>0 OR INSTR(m.OWNERS,'|AMAY|')>0 OR INSTR(m.OWNERS,'|AMC|')>0 OR INSTR(m.OWNERS,'|ANTV|')>0 OR INSTR(m.OWNERS,'|ATP|')>0 OR INSTR(m.OWNERS,'|BBC|')>0 OR INSTR(m.OWNERS,'|BEDIG|')>0 OR INSTR(m.OWNERS,'|CENT|')>0 OR INSTR(m.OWNERS,'|CS|')>0 OR INSTR(m.OWNERS,'|CTCB|')>0 OR INSTR(m.OWNERS,'|CTCE|')>0 OR INSTR(m.OWNERS,'|DAVI|')>0 OR INSTR(m.OWNERS,'|DMA|')>0 OR INSTR(m.OWNERS,'|DMF|')>0 OR INSTR(m.OWNERS,'|DMY|')>0 OR INSTR(m.OWNERS,'|DTV|')>0 OR INSTR(m.OWNERS,'|EST|')>0 OR INSTR(m.OWNERS,'|EUROSPORT|')>0 OR INSTR(m.OWNERS,'|HDC1|')>0 OR INSTR(m.OWNERS,'|HDP1|')>0 OR INSTR(m.OWNERS,'|HDP2|')>0 OR INSTR(m.OWNERS,'|HUB|')>0 OR INSTR(m.OWNERS,'|ICCCTY|')>0 OR INSTR(m.OWNERS,'|ICCCWC|')>0 OR INSTR(m.OWNERS,'|ICCCWL2|')>0 OR INSTR(m.OWNERS,'|ICCICC|')>0 OR INSTR(m.OWNERS,'|ICCTWT|')>0 OR INSTR(m.OWNERS,'|ICCU19CWC|')>0 OR INSTR(m.OWNERS,'|ICCWCCL|')>0 OR INSTR(m.OWNERS,'|ICCWCL|')>0 OR INSTR(m.OWNERS,'|ICCWCP|')>0 OR INSTR(m.OWNERS,'|ICCWTC|')>0 OR INSTR(m.OWNERS,'|ICCWTT|')>0 OR INSTR(m.OWNERS,'|ICCWWC|')>0 OR INSTR(m.OWNERS,'|ITV|')>0 OR INSTR(m.OWNERS,'|KNL2|')>0 OR INSTR(m.OWNERS,'|KNVA|')>0 OR INSTR(m.OWNERS,'|LMH|')>0 OR INSTR(m.OWNERS,'|LNT|')>0 OR INSTR(m.OWNERS,'|MBNS|')>0 OR INSTR(m.OWNERS,'|MED|')>0 OR INSTR(m.OWNERS,'|MM|')>0 OR INSTR(m.OWNERS,'|MTG|')>0 OR INSTR(m.OWNERS,'|NAA|')>0 OR INSTR(m.OWNERS,'|NICK|')>0 OR INSTR(m.OWNERS,'|NVA|')>0 OR INSTR(m.OWNERS,'|OSP|')>0 OR INSTR(m.OWNERS,'|PBOY|')>0 OR INSTR(m.OWNERS,'|PMS|')>0 OR INSTR(m.OWNERS,'|PPL|')>0 OR INSTR(m.OWNERS,'|PSP|')>0 OR INSTR(m.OWNERS,'|Play|')>0 OR INSTR(m.OWNERS,'|RTR|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|SPG|')>0 OR INSTR(m.OWNERS,'|SPTV|')>0 OR INSTR(m.OWNERS,'|T3LT|')>0 OR INSTR(m.OWNERS,'|T3LV|')>0 OR INSTR(m.OWNERS,'|T6LT|')>0 OR INSTR(m.OWNERS,'|T6LV|')>0 OR INSTR(m.OWNERS,'|T8LT|')>0 OR INSTR(m.OWNERS,'|TECHM|')>0 OR INSTR(m.OWNERS,'|TMD|')>0 OR INSTR(m.OWNERS,'|TV10|')>0 OR INSTR(m.OWNERS,'|TV1A|')>0 OR INSTR(m.OWNERS,'|TV1B|')>0 OR INSTR(m.OWNERS,'|TV1C|')>0 OR INSTR(m.OWNERS,'|TV1D|')>0 OR INSTR(m.OWNERS,'|TV1E|')>0 OR INSTR(m.OWNERS,'|TV1F|')>0 OR INSTR(m.OWNERS,'|TV1K|')>0 OR INSTR(m.OWNERS,'|TV1N|')>0 OR INSTR(m.OWNERS,'|TV1P|')>0 OR INSTR(m.OWNERS,'|TV1S|')>0 OR INSTR(m.OWNERS,'|TV2S|')>0 OR INSTR(m.OWNERS,'|TV3D|')>0 OR INSTR(m.OWNERS,'|TV3N|')>0 OR INSTR(m.OWNERS,'|TV3S|')>0 OR INSTR(m.OWNERS,'|TV5L|')>0 OR INSTR(m.OWNERS,'|TV6E|')>0 OR INSTR(m.OWNERS,'|TV6H|')>0 OR INSTR(m.OWNERS,'|TV6N|')>0 OR INSTR(m.OWNERS,'|TV6S|')>0 OR INSTR(m.OWNERS,'|TV8|')>0 OR INSTR(m.OWNERS,'|TVAE|')>0 OR INSTR(m.OWNERS,'|TVDP|')>0 OR INSTR(m.OWNERS,'|TVONE|')>0 OR INSTR(m.OWNERS,'|TVPB|')>0 OR INSTR(m.OWNERS,'|TVPU|')>0 OR INSTR(m.OWNERS,'|TVSL|')>0 OR INSTR(m.OWNERS,'|V1G|')>0 OR INSTR(m.OWNERS,'|V1TZ|')>0 OR INSTR(m.OWNERS,'|V3H|')>0 OR INSTR(m.OWNERS,'|V4N|')>0 OR INSTR(m.OWNERS,'|VEC|')>0 OR INSTR(m.OWNERS,'|VEPL|')>0 OR INSTR(m.OWNERS,'|VEPO|')>0 OR INSTR(m.OWNERS,'|VEXE|')>0 OR INSTR(m.OWNERS,'|VEXR|')>0 OR INSTR(m.OWNERS,'|VHIS|')>0 OR INSTR(m.OWNERS,'|VHPO|')>0 OR INSTR(m.OWNERS,'|VIVA|')>0 OR INSTR(m.OWNERS,'|VNC|')>0 OR INSTR(m.OWNERS,'|VNE|')>0 OR INSTR(m.OWNERS,'|VNH|')>0 OR INSTR(m.OWNERS,'|VNHD|')>0 OR INSTR(m.OWNERS,'|VNPO|')>0 OR INSTR(m.OWNERS,'|VODD|')>0 OR INSTR(m.OWNERS,'|VODE|')>0 OR INSTR(m.OWNERS,'|VODF|')>0 OR INSTR(m.OWNERS,'|VODN|')>0 OR INSTR(m.OWNERS,'|VODS|')>0 OR INSTR(m.OWNERS,'|VS2|')>0 OR INSTR(m.OWNERS,'|VS3|')>0 OR INSTR(m.OWNERS,'|VSAT|')>0 OR INSTR(m.OWNERS,'|VSD|')>0 OR INSTR(m.OWNERS,'|VSD2|')>0 OR INSTR(m.OWNERS,'|VSE|')>0 OR INSTR(m.OWNERS,'|VSG|')>0 OR INSTR(m.OWNERS,'|VSHD|')>0 OR INSTR(m.OWNERS,'|VSS|')>0 OR INSTR(m.OWNERS,'|WCIU|')>0 OR INSTR(m.OWNERS,'|YLE TV1|')>0 OR INSTR(m.OWNERS,'|ZTVS|')>0) order by upper(m.title), m.media_type, m.ec_som, m.id ) a where rownum <= 50) r ,lateral( select l.miid, max(c.C_EXT_OUT_LOC) lib_loc_ext_id, max(c.C_STAT) ctnr_stat, max(c.loan_stat) ctnr_loan_stat from tm_mi_tpi_lnx l, tm_ctnrs c where c.u_id=l.tpiid and l.miid=r.id and r.media_type=1 group by l.miid)(+) lnk ,lateral(select tt.* from tm_text tt where tt.text_id = r.primary_thumb_id2)(+) t ,lateral(select /*+ NO_DECORRELATE */ d.som fsom, d.eom feom, dl.mi_id fmi_id, d.os_fname fos_fname, d.DFILE_LINK_GUID, d.OS_GUID, d.SUB_FOLDER, dl.dfile_id, d.original_filename FROM tm_dfile d, tm_mi_dfile_lnx dl where d.id=dl.dfile_id and r.id=dl.mi_id and rownum=1)(+) dfl where rnum >= 1 order by rnum Param: pgm_parent_id_1: 299402 t Information: 1220 : 7|14:13:30.7820|CyBXb7|DANIEL| count returned 0 t Verbose: 1220 : 7|14:13:30.7820|CyBXb7|DANIEL|imfx v3 API took 0.036s '/api/v3/version/299402/media?_dc=1607609614049' t Information: 1220 : 7|14:33:54.3546|||OrabitWatcherBasic. Disposing. t Information: 1220 : 7|14:33:54.3546|||OrabitWatcherBasic. Disposed. t Information: 1220 : 7|14:33:54.3546|||========================================================================== t Information: 1220 : 7|14:33:54.3546|||IMFX CORE SERVER APPLICATION END.