t Information: 1220 : 12|18:18:53.8104|||Get Configuration Values: t Information: 1220 : 12|18:18:53.8104||| AdminPassEnc, default: , value: ffqjrn0leKv4Lj2YJHe2dw==. t Information: 1220 : 12|18:18:53.8104||| EncryptedPasswords, default: false, value: true. t Information: 1220 : 12|18:18:53.8104||| OraConnectionString, default: , value: Server=TECHM;User Id=imfx;Password=xxxxx;Unicode=true;. t Information: 1220 : 12|18:18:53.8104||| SecondTimezone, default: , value: . t Information: 1220 : 12|18:18:53.8104||| UseActiveDirectoryAuth, default: false, value: false. t Information: 1220 : 12|18:18:53.8104||| ReportingServiceUrl, default: , value: http://localhost:92/ReportingService.svc. t Information: 1220 : 12|18:18:53.8104||| ReportsPath, default: , value: . t Information: 1220 : 12|18:18:53.8104||| ReportsURL, default: , value: . t Information: 1220 : 12|18:18:53.8104||| TapeServiceUrl, default: , value: . t Information: 1220 : 12|18:18:53.8104||| GatekeeperUrl, default: , value: . t Information: 1220 : 12|18:18:53.8104||| ValuationUrl, default: , value: . t Information: 1220 : 12|18:18:53.8104||| QueueManagerDelay, default: 30, value: 30. t Information: 1220 : 12|18:18:53.8104||| QueueManagerFullRefresh, default: 90, value: 90. t Information: 1220 : 12|18:18:53.8104||| AudioLoopDuration, default: 0, value: 150. t Information: 1220 : 12|18:18:53.8104||| AudioLoopsCount, default: 0, value: 0. t Information: 1220 : 12|18:18:53.8104||| PlayerFakeStep, default: 500, value: 500. t Information: 1220 : 12|18:18:53.8104||| PlayerForceRatio, default: 0, value: 1. t Information: 1220 : 12|18:18:53.8104||| CheckVersionsInProd, default: false, value: True. t Information: 1220 : 12|18:18:53.8104||| MaxResults, default: 3000, value: 10000. t Information: 1220 : 12|18:18:53.8104||| NetworkRestriction, default: false, value: True. t Information: 1220 : 12|18:18:53.8104||| TEReportID, default: 0, value: 0. t Information: 1220 : 12|18:18:53.8104||| ClosedCaptionsCache, default: , value: C:\inetpub\wwwroot\imfxcore\timedtextcache\. t Information: 1220 : 12|18:18:53.8104||| ClosedCaptionsStorage, default: , value: c:\Mediaflex\subs. t Information: 1220 : 12|18:18:53.8104||| TimeCodeFormat, default: , value: pal. t Information: 1220 : 12|18:18:53.8260||| RceMediaPath, default: , value: C:\edl\. t Information: 1220 : 12|18:18:53.8260||| RceMediaPath, default: , value: C:\edl\. t Information: 1220 : 12|18:18:53.8260||| RceCsmOutputPath, default: , value: C:\Inetpub\wwwroot\csm\. t Information: 1220 : 12|18:18:53.8260||| RceCsmUrl, default: , value: http://localhost/csm/. t Information: 1220 : 12|18:18:53.8260||| RceMediaSelection, default: , value: miLinkIdMatch. t Information: 1220 : 12|18:18:53.8260||| RequestBrowseJobPresetName, default: , value: . t Information: 1220 : 12|18:18:53.8260||| DontExtendDuration, default: false, value: False. t Information: 1220 : 12|18:18:53.8260||| V3ConfigUrl, default: , value: . t Information: 1220 : 12|18:18:53.8260||| StopWords, default: , value: . t Information: 1220 : 12|18:18:53.8260||| MisrTxFormat, default: G, value: G. t Information: 1220 : 12|18:18:53.8260||| ApiServer, default: , value: http://192.168.120.10:85. t Information: 1220 : 12|18:18:53.8260||| ApiTimeout, default: 120, value: 120. t Information: 1220 : 12|18:18:53.8260||| ApiWorkers, default: 10, value: 10. t Information: 1220 : 12|18:18:53.8260||| UsePerfCounters, default: false, value: false. t Information: 1220 : 12|18:18:53.8260||| StatsdAddress, default: , value: . t Information: 1220 : 12|18:18:53.8260||| LogGetCurrentUser, default: true, value: true. t Information: 1220 : 12|18:18:53.8260||| LogInternalApi, default: true, value: true. t Information: 1220 : 12|18:18:53.8260||| ThumbnailServer, default: , value: . t Information: 1220 : 12|18:18:53.8260||| LocationFilter, default: , value: . t Information: 1220 : 12|18:18:53.8260||| SvUtilServiceUrl, default: , value: . t Information: 1220 : 12|18:18:53.8260||| SolrConnection, default: , value: http://192.168.120.14:8983/solr. t Information: 1220 : 12|18:18:53.8260||| UseIndexServerSearch, default: false, value: True. t Information: 1220 : 12|18:18:53.8260||| SolrIndexVersion, default: 1, value: 6. t Information: 1220 : 12|18:18:53.8260||| SolrConnection, default: , value: http://192.168.120.14:8983/solr. t Information: 1220 : 12|18:18:53.8260||| FacetsGroups, default: , value: owners,season_id, series_id,version_key,item_type,media_type,media_format,episode_number. t Information: 1220 : 12|18:18:53.8260||| FacetsGroupsVersion, default: , value: owners,season_id, series_id,version_key,episode_number. t Information: 1220 : 12|18:18:53.8260||| FacetsGroupsChameleon, default: , value: season_id, series_id,genre,prod_year,version_key. t Information: 1220 : 12|18:18:53.8260||| PreviewPreset, default: , value: . t Information: 1220 : 12|18:18:53.8260||| DevMode, default: false, value: false. t Information: 1220 : 12|18:18:53.8260||| DisableSysMan, default: false, value: false. t Information: 1220 : 12|18:18:53.8260||| TimeCodeFormat, default: , value: pal. t Information: 1220 : 12|18:18:53.8260||| FileCatalystStorageDevice, default: , value: . t Information: 1220 : 12|18:18:53.8260||| UseResponsibilityTracking, default: true, value: True. t Information: 1220 : 12|18:18:53.8260||| SubtitleDeviceFilter, default: , value: . t Information: 1220 : 12|18:18:53.8260||| SystemMonitorNamedPipe, default: , value: . t Information: 1220 : 12|18:18:53.8260||| OracleMonitorEnable, default: false, value: False. t Information: 1220 : 12|18:18:53.8260||| ArcApiHost, default: , value: . t Information: 1220 : 12|18:18:53.8260||| RabbitMqUrl, default: , value: amqp://192.168.120.14:5672. t Information: 1220 : 12|18:18:53.8260||| SolrTimedTextSearch, default: false, value: false. t Information: 1220 : 12|18:18:53.8260||| ProductionDurationUsageID, default: 1, value: 1. t Information: 1220 : 12|18:18:54.0448|||GetStreamServers.. t Information: 1220 : 12|18:18:54.8573||| https://demo.tmd.tv/CBR Video/ |CBR Video| False t Information: 1220 : 12|18:18:54.8573||| https://demo.tmd.tv/CBR Images/ |CBR Images| False t Information: 1220 : 12|18:18:54.8573||| https://demo.tmd.tv/CBR Audio/ |CBR Audio| False t Information: 1220 : 12|18:18:54.8573||| https://demo.tmd.tv/Temp Upload/ |TEMP_UPLOAD| False t Information: 1220 : 12|18:18:54.8573||| http://localhost:82/images/ |IMAGES| False t Information: 1220 : 12|18:18:54.8573||| http://192.168.91.73/smoothcloud/ |SMOOTH_CLOUD| False t Information: 1220 : 12|18:18:54.8573||| http://192.168.91.73/cloudstore/ |CLOUD_STORE| False t Information: 1220 : 12|18:18:54.8573||| http://192.168.91.73/editsystemin/ |EDIT_SYSTEM_IN| False t Information: 1220 : 12|18:18:54.8573||| http://192.168.91.27:89/APPLEPROXY/ |APPLE_PROXY| False t Information: 1220 : 12|18:18:54.8573||| http://localhost:82/video/ |FILESTORE_VIDEO| False t Information: 1220 : 12|18:18:54.8573||| https://imfxv3tm.tmd.tv/streaming/ |Streaming| False t Information: 1220 : 12|18:18:54.8573||| https://imfxv3tm.tmd.tv/VideoServer/ |Video| False t Information: 1220 : 12|18:18:54.8573||| https://imfxv3tm.tmd.tv/AdobeIn/ |Adobe Premiere Pro In| False t Information: 1220 : 12|18:18:54.8573||| https://imfxv3tm.tmd.tv/AudioServer/ |Audio| False t Information: 1220 : 12|18:18:54.8573||| https://imfxv3tm.tmd.tv/ImageServer/ |Image| False t Information: 1220 : 12|18:18:54.8573||| https://imfxv3tm.tmd.tv/DocsServer/ |Docs| False t Information: 1220 : 12|18:18:54.8573||| https://imfxv3tm.tmd.tv/AmazonLabs/ |TEST HOUSE| False t Information: 1220 : 12|18:18:54.8573||| SolrConnectionUms, default: http://192.168.120.14:8983/solr, value: http://192.168.120.14:8983/solr. t Information: 1220 : 12|18:18:54.8573||| LogWebApi, default: false, value: false. t Information: 1220 : 12|18:18:54.8573||| EmbeddedRceUrl, default: , value: . t Information: 1220 : 12|18:18:54.8573||| InstallMode, default: , value: . t Information: 1220 : 12|18:18:54.8573||| SamlRequestAddress, default: , value: . t Information: 1220 : 12|18:18:54.8573||| SamlTrustedIssuer, default: , value: . t Information: 1220 : 12|18:18:54.8573||| SamlLoginRedirect, default: , value: . t Information: 1220 : 12|18:18:54.8573||| NaturalLangSearch, default: false, value: True. t Information: 1220 : 12|18:18:54.8573||| OktaLoginField, default: , value: . t Information: 1220 : 12|18:18:54.8573||| AuthenticationTypes, default: , value: Native,PublicApiKey. t Information: 1220 : 12|18:18:54.8573|||OrabitWatcherBasic. Initialize. t Information: 1220 : 12|18:18:54.8573|||FillDictionaryCache. t Information: 1220 : 12|18:18:58.1854|||GetSupportedOperators t Information: 1220 : 12|18:18:58.3886|||CacheTechReports. t Information: 1220 : 12|18:18:58.5917|||& Cache update. Server (global) filled with timestamp 06:03:58.3729901. types null t Information: 1220 : 12|18:18:58.5917|||InitializeFromDatabase. 'Server=TECHM;User Id=imfx;password=..;Unicode=true;' direct False, home , timeout 15 t Information: 1220 : 12|18:18:58.5917|||FillDictionaryCache. t Information: 1220 : 12|18:18:58.5917|||& Cache update. Server (global) filled with timestamp 06:03:58.4042272. types FriendlyNames, DatabaseSearchFieldData t Information: 1220 : 12|18:18:58.9979|||========================================================================== t Information: 1220 : 12|18:18:58.9979|||IMFX CORE SERVER APPLICATION START. t Information: 1220 : 12|18:18:58.9979|||DLL VERSION: 2.5.0.2610. t Information: 1220 : 12|18:18:58.9979|||IS TIMER HIGH RESOULTION : True. t Information: 1220 : 12|18:18:58.9979||| UmsDev, default: False, value: False. t Information: 1220 : 12|18:18:59.8105|||OrabitWatcherBasic trying to connect.. t Information: 1220 : 12|18:18:59.8105|||OrabitWatcherBasic connected. t Information: 1220 : 12|18:18:59.8105|||OrabitWatcherBasic queue created tmd.cfg.in.8ba23a7b-4d85-4207-80ba-b8593987e59d t Information: 1220 : 12|18:19:38.6229|wLQPqb|TMDDBA|GetUserProfile. Id: 30000 t Transfer: 1220 : 12|18:19:38.6229|wLQPqb|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 12|18:19:38.6229|wLQPqb|TMDDBA| OAuth authenticated t Transfer: 1220 : 12|18:19:38.6229|wLQPqb|TMDDBA| user TMDDBA. t Information: 1220 : 12|18:20:39.7792|eAyGhT|TMDDBA|GetUserProfile. Id: 30000 t Transfer: 1220 : 12|18:20:39.7792|eAyGhT|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 12|18:20:39.7792|eAyGhT|TMDDBA| OAuth authenticated t Transfer: 1220 : 12|18:20:39.7792|eAyGhT|TMDDBA| user TMDDBA. t Information: 1220 : 12|18:21:39.9041|Y2aj8T|TMDDBA|GetUserProfile. Id: 30000 t Transfer: 1220 : 12|18:21:39.9041|Y2aj8T|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 12|18:21:39.9041|Y2aj8T|TMDDBA| OAuth authenticated t Transfer: 1220 : 12|18:21:39.9041|Y2aj8T|TMDDBA| user TMDDBA. t Information: 1220 : 12|18:22:41.4667|4Qcd62|TMDDBA|GetUserProfile. Id: 30000 t Transfer: 1220 : 12|18:22:41.4667|4Qcd62|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 12|18:22:41.4667|4Qcd62|TMDDBA| OAuth authenticated t Transfer: 1220 : 12|18:22:41.4667|4Qcd62|TMDDBA| user TMDDBA. t Information: 1220 : 12|18:23:42.4041|xqNQqy|TMDDBA|GetUserProfile. Id: 30000 t Transfer: 1220 : 12|18:23:42.4041|xqNQqy|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 12|18:23:42.4041|xqNQqy|TMDDBA| OAuth authenticated t Transfer: 1220 : 12|18:23:42.4041|xqNQqy|TMDDBA| user TMDDBA. t Information: 1220 : 12|18:24:43.1385|JSz~2b|TMDDBA|GetUserProfile. Id: 30000 t Transfer: 1220 : 12|18:24:43.1385|JSz~2b|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 12|18:24:43.1385|JSz~2b|TMDDBA| OAuth authenticated t Transfer: 1220 : 12|18:24:43.1385|JSz~2b|TMDDBA| user TMDDBA. t Transfer: 1220 : 12|18:25:33.3104|phv5an|TMDDBA|OAuth: /api/v3/search/title?_dc=1585589133099 t Transfer: 1220 : 12|18:25:33.3104|phv5an|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 12|18:25:33.3104|phv5an|TMDDBA| OAuth authenticated t Transfer: 1220 : 12|18:25:33.3104|phv5an|TMDDBA| user TMDDBA. t Verbose: 1220 : 12|18:25:33.3104|phv5an|TMDDBA|OAuth. User logged in: TMDDBA t Information: 1220 : 12|18:25:33.3104|phv5an|TMDDBA|V3Api.SearchTitles t Information: 1220 : 12|18:25:33.3104|phv5an|TMDDBA|V3Api.SearchGeneric t Transfer: 1220 : 12|18:25:33.3104|phv5an|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 12|18:25:33.3104|phv5an|TMDDBA| OAuth authenticated t Transfer: 1220 : 12|18:25:33.3104|phv5an|TMDDBA| user TMDDBA. t Transfer: 1220 : 12|18:25:33.3104|phv5an|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 12|18:25:33.3104|phv5an|TMDDBA| OAuth authenticated t Transfer: 1220 : 12|18:25:33.3104|phv5an|TMDDBA| user TMDDBA. t Information: 1220 : 12|18:25:33.3104|phv5an|TMDDBA|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,'|03BO|')>0 OR INSTR(OWNERS,'|03GD|')>0 OR INSTR(OWNERS,'|03GO|')>0 OR INSTR(OWNERS,'|03HA|')>0 OR INSTR(OWNERS,'|03JO|')>0 OR INSTR(OWNERS,'|03LI|')>0 OR INSTR(OWNERS,'|03NB|')>0 OR INSTR(OWNERS,'|03NM|')>0 OR INSTR(OWNERS,'|03NO|')>0 OR INSTR(OWNERS,'|03OR|')>0 OR INSTR(OWNERS,'|03SB|')>0 OR INSTR(OWNERS,'|03SC|')>0 OR INSTR(OWNERS,'|03SE|')>0 OR INSTR(OWNERS,'|03SG|')>0 OR INSTR(OWNERS,'|03SK|')>0 OR INSTR(OWNERS,'|03SM|')>0 OR INSTR(OWNERS,'|03SN|')>0 OR INSTR(OWNERS,'|03SS|')>0 OR INSTR(OWNERS,'|03SY|')>0 OR INSTR(OWNERS,'|03UP|')>0 OR INSTR(OWNERS,'|03VA|')>0 OR INSTR(OWNERS,'|03VB|')>0 OR INSTR(OWNERS,'|03VL|')>0 OR INSTR(OWNERS,'|03VT|')>0 OR INSTR(OWNERS,'|3+ES|')>0 OR INSTR(OWNERS,'|3PD|')>0 OR INSTR(OWNERS,'|3PLV|')>0 OR INSTR(OWNERS,'|AECHD|')>0 OR INSTR(OWNERS,'|AECSD|')>0 OR INSTR(OWNERS,'|AL|')>0 OR INSTR(OWNERS,'|AMAY|')>0 OR INSTR(OWNERS,'|AMC|')>0 OR INSTR(OWNERS,'|ATP|')>0 OR INSTR(OWNERS,'|CENT|')>0 OR INSTR(OWNERS,'|CS|')>0 OR INSTR(OWNERS,'|CTCB|')>0 OR INSTR(OWNERS,'|CTCE|')>0 OR INSTR(OWNERS,'|DAVI|')>0 OR INSTR(OWNERS,'|DMA|')>0 OR INSTR(OWNERS,'|DMF|')>0 OR INSTR(OWNERS,'|DMY|')>0 OR INSTR(OWNERS,'|DTV|')>0 OR INSTR(OWNERS,'|EST|')>0 OR INSTR(OWNERS,'|EUROSPORT|')>0 OR INSTR(OWNERS,'|HDC1|')>0 OR INSTR(OWNERS,'|HDP1|')>0 OR INSTR(OWNERS,'|HDP2|')>0 OR INSTR(OWNERS,'|HUB|')>0 OR INSTR(OWNERS,'|KNL2|')>0 OR INSTR(OWNERS,'|KNVA|')>0 OR INSTR(OWNERS,'|LMH|')>0 OR INSTR(OWNERS,'|LNT|')>0 OR INSTR(OWNERS,'|MBNS|')>0 OR INSTR(OWNERS,'|MED|')>0 OR INSTR(OWNERS,'|MM|')>0 OR INSTR(OWNERS,'|MTG|')>0 OR INSTR(OWNERS,'|NAA|')>0 OR INSTR(OWNERS,'|NICK|')>0 OR INSTR(OWNERS,'|NVA|')>0 OR INSTR(OWNERS,'|OSP|')>0 OR INSTR(OWNERS,'|PBOY|')>0 OR INSTR(OWNERS,'|PMS|')>0 OR INSTR(OWNERS,'|PPL|')>0 OR INSTR(OWNERS,'|PSP|')>0 OR INSTR(OWNERS,'|Play|')>0 OR INSTR(OWNERS,'|RTR|')>0 OR INSTR(OWNERS,'|SFP1|')>0 OR INSTR(OWNERS,'|SFP2|')>0 OR INSTR(OWNERS,'|SPG|')>0 OR INSTR(OWNERS,'|SPTV|')>0 OR INSTR(OWNERS,'|T3LT|')>0 OR INSTR(OWNERS,'|T3LV|')>0 OR INSTR(OWNERS,'|T6LT|')>0 OR INSTR(OWNERS,'|T6LV|')>0 OR INSTR(OWNERS,'|T8LT|')>0 OR INSTR(OWNERS,'|TECHM|')>0 OR INSTR(OWNERS,'|TMD|')>0 OR INSTR(OWNERS,'|TV10|')>0 OR INSTR(OWNERS,'|TV1A|')>0 OR INSTR(OWNERS,'|TV1B|')>0 OR INSTR(OWNERS,'|TV1C|')>0 OR INSTR(OWNERS,'|TV1D|')>0 OR INSTR(OWNERS,'|TV1E|')>0 OR INSTR(OWNERS,'|TV1F|')>0 OR INSTR(OWNERS,'|TV1K|')>0 OR INSTR(OWNERS,'|TV1N|')>0 OR INSTR(OWNERS,'|TV1P|')>0 OR INSTR(OWNERS,'|TV1S|')>0 OR INSTR(OWNERS,'|TV2S|')>0 OR INSTR(OWNERS,'|TV3D|')>0 OR INSTR(OWNERS,'|TV3N|')>0 OR INSTR(OWNERS,'|TV3S|')>0 OR INSTR(OWNERS,'|TV5L|')>0 OR INSTR(OWNERS,'|TV6E|')>0 OR INSTR(OWNERS,'|TV6H|')>0 OR INSTR(OWNERS,'|TV6N|')>0 OR INSTR(OWNERS,'|TV6S|')>0 OR INSTR(OWNERS,'|TV8|')>0 OR INSTR(OWNERS,'|TVAE|')>0 OR INSTR(OWNERS,'|TVDP|')>0 OR INSTR(OWNERS,'|TVPB|')>0 OR INSTR(OWNERS,'|TVPU|')>0 OR INSTR(OWNERS,'|TVSL|')>0 OR INSTR(OWNERS,'|V1G|')>0 OR INSTR(OWNERS,'|V1TZ|')>0 OR INSTR(OWNERS,'|V3H|')>0 OR INSTR(OWNERS,'|V4N|')>0 OR INSTR(OWNERS,'|VEC|')>0 OR INSTR(OWNERS,'|VEPL|')>0 OR INSTR(OWNERS,'|VEPO|')>0 OR INSTR(OWNERS,'|VEXE|')>0 OR INSTR(OWNERS,'|VEXR|')>0 OR INSTR(OWNERS,'|VHIS|')>0 OR INSTR(OWNERS,'|VHPO|')>0 OR INSTR(OWNERS,'|VNC|')>0 OR INSTR(OWNERS,'|VNE|')>0 OR INSTR(OWNERS,'|VNH|')>0 OR INSTR(OWNERS,'|VNHD|')>0 OR INSTR(OWNERS,'|VNPO|')>0 OR INSTR(OWNERS,'|VODD|')>0 OR INSTR(OWNERS,'|VODE|')>0 OR INSTR(OWNERS,'|VODF|')>0 OR INSTR(OWNERS,'|VODN|')>0 OR INSTR(OWNERS,'|VODS|')>0 OR INSTR(OWNERS,'|VS2|')>0 OR INSTR(OWNERS,'|VS3|')>0 OR INSTR(OWNERS,'|VSAT|')>0 OR INSTR(OWNERS,'|VSD|')>0 OR INSTR(OWNERS,'|VSD2|')>0 OR INSTR(OWNERS,'|VSE|')>0 OR INSTR(OWNERS,'|VSG|')>0 OR INSTR(OWNERS,'|VSHD|')>0 OR INSTR(OWNERS,'|VSS|')>0 OR INSTR(OWNERS,'|WCIU|')>0 OR INSTR(OWNERS,'|YLE TV1|')>0 OR INSTR(OWNERS,'|ZTVS|')>0 ) AND (CONTAINS(CTX_TEXT_COL,'pmh') > 0 OR CONTAINS(CTX_IDS_COL,'pmh') > 0 ) AND ROWNUM < 25000 ) ) ,v_missing_parent_ids as ( select xparent_id from v minus select id from v ) ,v_missing_parents as ( SELECT distinct a.* ,decode(ITEM_TYPE, 1010,SER_ABS_ID, 1020,CASE WHEN SER_ABS2_ID > 0 THEN SER_ABS2_ID ELSE SER_ABS_ID END ) xparent_id FROM TMDDBA.TM_PG_ABS a START WITH ID IN (select xparent_id from v_missing_parent_ids) CONNECT BY CASE PRIOR ITEM_TYPE WHEN 1010 THEN PRIOR SER_ABS_ID WHEN 1020 THEN CASE WHEN NVL(PRIOR SER_ABS2_ID, 0) > 0 THEN PRIOR SER_ABS2_ID ELSE PRIOR SER_ABS_ID END END = ID ) ,v_all as ( select x.*, count(*) over() RowCount from ( select * from v_missing_parents union select * from v ) x ) ,v_top as ( select id from (select id, row_number()over(order by upper(ser_title),upper(title),ser_num,ser_ep_num, SER_EP_SQ_NUM ) rnk -- sort roots from v_all where xparent_id is null) where rnk between (:page_number-1)*50+1 and :page_number*50 ) ,v_tree as ( select level lvl, a.* from v_all a start with id in (select id from v_top) connect by xparent_id = prior ID order siblings by upper(ser_title),ser_num,ser_ep_num, SER_EP_SQ_NUM,upper(title) -- sort children ) select * from v_tree --where rnk <= 50 t Verbose: 1220 : 12|18:25:33.3104|phv5an|TMDDBA|imfx v3 API took 0.071s '/api/v3/search/title?_dc=1585589133099' t Transfer: 1220 : 12|18:25:33.5135|K0Ij~H|TMDDBA|OAuth: /api/user-preferences?_dc=1585589133309 t Transfer: 1220 : 12|18:25:33.5135|K0Ij~H|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 12|18:25:33.5135|K0Ij~H|TMDDBA| OAuth authenticated t Transfer: 1220 : 12|18:25:33.5135|K0Ij~H|TMDDBA| user TMDDBA. t Verbose: 1220 : 12|18:25:33.5135|K0Ij~H|TMDDBA|OAuth. User logged in: TMDDBA t Verbose: 1220 : 12|18:25:33.5135|K0Ij~H|TMDDBA|StoreUserDataByKeys.. t Transfer: 1220 : 12|18:25:33.5135|K0Ij~H|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 12|18:25:33.5135|K0Ij~H|TMDDBA| OAuth authenticated t Transfer: 1220 : 12|18:25:33.5135|K0Ij~H|TMDDBA| user TMDDBA. t Verbose: 1220 : 12|18:25:33.5135|K0Ij~H|TMDDBA|imfx v3 API took 0.011s '/api/user-preferences?_dc=1585589133309' t Transfer: 1220 : 12|18:25:37.1698|EsLwbl|TMDDBA|OAuth: /api/view/searchinfo/Media?_dc=1585589136958 t Transfer: 1220 : 12|18:25:37.1698|EsLwbl|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 12|18:25:37.1698|EsLwbl|TMDDBA| OAuth authenticated t Transfer: 1220 : 12|18:25:37.1698|EsLwbl|TMDDBA| user TMDDBA. t Verbose: 1220 : 12|18:25:37.1698|EsLwbl|TMDDBA|OAuth. User logged in: TMDDBA t Information: 1220 : 12|18:25:37.1698|EsLwbl|TMDDBA|GetAdvSearchColumns. search type Media grid . t Transfer: 1220 : 12|18:25:37.1698|IzAYsV|TMDDBA|OAuth: /api/user-preferences?keys=adv.recent.searches.media&_dc=1585589136963 t Transfer: 1220 : 12|18:25:37.1698|IzAYsV|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 12|18:25:37.1698|IzAYsV|TMDDBA| OAuth authenticated t Transfer: 1220 : 12|18:25:37.1698|IzAYsV|TMDDBA| user TMDDBA. t Verbose: 1220 : 12|18:25:37.1698|IzAYsV|TMDDBA|OAuth. User logged in: TMDDBA t Information: 1220 : 12|18:25:37.1698|IzAYsV|TMDDBA|GetUserDataByKeys: adv.recent.searches.media t Transfer: 1220 : 12|18:25:37.1698|IzAYsV|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 12|18:25:37.1698|IzAYsV|TMDDBA| OAuth authenticated t Transfer: 1220 : 12|18:25:37.1698|IzAYsV|TMDDBA| user TMDDBA. t Verbose: 1220 : 12|18:25:37.1698|EsLwbl|TMDDBA|imfx v3 API took 0.018s '/api/view/searchinfo/Media?_dc=1585589136958' t Verbose: 1220 : 12|18:25:37.1698|IzAYsV|TMDDBA|imfx v3 API took 0.019s '/api/user-preferences?keys=adv.recent.searches.media&_dc=1585589136963' t Transfer: 1220 : 12|18:25:37.1698|i9IOo6|TMDDBA|OAuth: /api/view/searches/Media?_dc=1585589137071 t Transfer: 1220 : 12|18:25:37.1698|i9IOo6|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 12|18:25:37.1698|i9IOo6|TMDDBA| OAuth authenticated t Transfer: 1220 : 12|18:25:37.1698|i9IOo6|TMDDBA| user TMDDBA. t Verbose: 1220 : 12|18:25:37.1698|i9IOo6|TMDDBA|OAuth. User logged in: TMDDBA t Information: 1220 : 12|18:25:37.1698|i9IOo6|TMDDBA|GetSavedSearchNames. search type Media. t Transfer: 1220 : 12|18:25:37.1698|i9IOo6|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 12|18:25:37.1698|i9IOo6|TMDDBA| OAuth authenticated t Transfer: 1220 : 12|18:25:37.1698|i9IOo6|TMDDBA| user TMDDBA. t Verbose: 1220 : 12|18:25:37.1698|i9IOo6|TMDDBA|imfx v3 API took 0.017s '/api/view/searches/Media?_dc=1585589137071' t Transfer: 1220 : 12|18:25:37.1698|sF9afw|TMDDBA|OAuth: /api/settings/user/searchLayoutConfig?_dc=1585589137104 t Transfer: 1220 : 12|18:25:37.1698|sF9afw|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 12|18:25:37.1698|sF9afw|TMDDBA| OAuth authenticated t Transfer: 1220 : 12|18:25:37.1698|sF9afw|TMDDBA| user TMDDBA. t Verbose: 1220 : 12|18:25:37.1698|sF9afw|TMDDBA|OAuth. User logged in: TMDDBA t Transfer: 1220 : 12|18:25:37.1698|sF9afw|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 12|18:25:37.1698|sF9afw|TMDDBA| OAuth authenticated t Transfer: 1220 : 12|18:25:37.1698|sF9afw|TMDDBA| user TMDDBA. t Verbose: 1220 : 12|18:25:37.3885|sF9afw|TMDDBA|imfx v3 API took 0.014s '/api/settings/user/searchLayoutConfig?_dc=1585589137104' t Information: 1220 : 12|18:25:43.2791|TPPXS0|TMDDBA|GetUserProfile. Id: 30000 t Transfer: 1220 : 12|18:25:43.2791|TPPXS0|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 12|18:25:43.2791|TPPXS0|TMDDBA| OAuth authenticated t Transfer: 1220 : 12|18:25:43.2791|TPPXS0|TMDDBA| user TMDDBA. t Transfer: 1220 : 12|18:25:47.7479|YIAwZc|TMDDBA|OAuth: /api/v3/search/Media?_dc=1585589147611 t Transfer: 1220 : 12|18:25:47.7479|YIAwZc|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 12|18:25:47.7479|YIAwZc|TMDDBA| OAuth authenticated t Transfer: 1220 : 12|18:25:47.7479|YIAwZc|TMDDBA| user TMDDBA. t Verbose: 1220 : 12|18:25:47.7479|YIAwZc|TMDDBA|OAuth. User logged in: TMDDBA t Information: 1220 : 12|18:25:47.7479|YIAwZc|TMDDBA|V3Api.SearchMedia t Information: 1220 : 12|18:25:47.7479|YIAwZc|TMDDBA|V3Api.SearchGeneric t Transfer: 1220 : 12|18:25:47.7479|YIAwZc|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 12|18:25:47.7479|YIAwZc|TMDDBA| OAuth authenticated t Transfer: 1220 : 12|18:25:47.7479|YIAwZc|TMDDBA| user TMDDBA. t Information: 1220 : 12|18:25:48.1541|YIAwZc|TMDDBA|Running solr search: [q, (((created_date:[2020-03-29T23:00:00Z TO 2020-03-30T23:00:00Z}})) 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 (ATP) 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 (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 (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 (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 : 12|18:25:48.1541|YIAwZc|TMDDBA|Solr query returned: 15 in 5ms t Information: 1220 : 12|18:25:48.1541|YIAwZc|TMDDBA|MediaSearch SQL: select r.*, nvl((select TMD_STR_AGG(c.u_id_pfix ) from tm_ctnrs c, tm_mi_tpi_lnx l where l.miid=r.id and c.u_id=l.tpiid and r.media_type=1),'') BARCODE, nvl(lnk.lib_loc_ext_id,0) lib_loc_ext_id, nvl(lnk.ctnr_loan_stat,0) ctnr_loan_status, nvl(lnk.ctnr_stat,0) ctnr_stat, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID , (select min(status.description) from TM_CFG_PGM_STATUS status where r.status = status.id) PGM_STATUS_TEXT, (select tmd_str_agg_pipe(cms.status_type_id ||',' ||cms.status_id) from tm_mi_cust_med_stat_lnx cms where cms.media_id=r.id) "CustomStatusesRaw", GETMEDIALOC(r.id, r.media_type, r.compil, r.m_ctnr_int_o_loc, r.m_ctnr_ext_o_loc, r.m_ctnr_loc) LOCATION, nvl(dfl.fSOM,0) FILE_SOM, nvl(dfl.fEOM,0) FILE_EOM, dfl.fos_fname FILENAME, dfl.DFILE_LINK_GUID, dfl.OS_GUID, dfl.SUB_FOLDER, dfl.ORIGINAL_FILENAME from (select a.*, rownum rnum from (select m.*, coalesce(m.primary_thumb_id, (select v.primary_thumb_id from tm_pg_rl v where v.id=m.pgm_parent_id)) primary_thumb_id2 from tmddba.tm_mis m ,(select /*+ cardinality(4) */ rownum rn, column_value id from table(:ids)) ids where media_type>0 and item_type>0 and m.id = ids.id order by ids.rn ) a where rownum <= 10000) r ,lateral( select l.miid, max(c.C_EXT_OUT_LOC) lib_loc_ext_id, max(c.C_STAT) ctnr_stat, max(c.loan_stat) ctnr_loan_stat from tm_mi_tpi_lnx l, tm_ctnrs c where c.u_id=l.tpiid and l.miid=r.id and r.media_type=1 group by l.miid)(+) lnk ,lateral(select tt.* from tm_text tt where tt.text_id = r.primary_thumb_id2)(+) t ,lateral(select /*+ NO_DECORRELATE */ d.som fsom, d.eom feom, dl.mi_id fmi_id, d.os_fname fos_fname, d.DFILE_LINK_GUID, d.OS_GUID, d.SUB_FOLDER, dl.dfile_id, d.original_filename FROM tm_dfile d, tm_mi_dfile_lnx dl where d.id=dl.dfile_id and r.id=dl.mi_id and rownum=1)(+) dfl where rnum >= 1 order by rnum t Information: 1220 : 12|18:25:48.3573|YIAwZc|TMDDBA| timing: 00:00:00.5590902 t Verbose: 1220 : 12|18:25:48.3573|YIAwZc|TMDDBA|imfx v3 API took 0.584s '/api/v3/search/Media?_dc=1585589147611' t Transfer: 1220 : 12|18:25:48.5604|YIAwZc|TMDDBA|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\N0001783.mp4 subfolder t Transfer: 1220 : 12|18:25:48.5604|YIAwZc|TMDDBA| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/N0001783.mp4 t Transfer: 1220 : 12|18:25:48.5604|YIAwZc|TMDDBA|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/N0001783.mp4 t Transfer: 1220 : 12|18:25:48.5604|YIAwZc|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 12|18:25:48.5604|YIAwZc|TMDDBA| OAuth authenticated t Transfer: 1220 : 12|18:25:48.5604|YIAwZc|TMDDBA| user TMDDBA. t Transfer: 1220 : 12|18:25:48.5604|YIAwZc|TMDDBA|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\short.mov subfolder t Transfer: 1220 : 12|18:25:48.5604|YIAwZc|TMDDBA| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/short.mov t Transfer: 1220 : 12|18:25:48.5604|YIAwZc|TMDDBA|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/short.mov t Transfer: 1220 : 12|18:25:48.5604|YIAwZc|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 12|18:25:48.5604|YIAwZc|TMDDBA| OAuth authenticated t Transfer: 1220 : 12|18:25:48.5604|YIAwZc|TMDDBA| user TMDDBA. t Transfer: 1220 : 12|18:25:48.5604|YIAwZc|TMDDBA|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\N0001781.mp4 subfolder t Transfer: 1220 : 12|18:25:48.5604|YIAwZc|TMDDBA| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/N0001781.mp4 t Transfer: 1220 : 12|18:25:48.5604|YIAwZc|TMDDBA|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/N0001781.mp4 t Transfer: 1220 : 12|18:25:48.5604|YIAwZc|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 12|18:25:48.5604|YIAwZc|TMDDBA| OAuth authenticated t Transfer: 1220 : 12|18:25:48.5604|YIAwZc|TMDDBA| user TMDDBA. t Transfer: 1220 : 12|18:25:48.5604|YIAwZc|TMDDBA|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\N0001782.mp4 subfolder t Transfer: 1220 : 12|18:25:48.5604|YIAwZc|TMDDBA| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/N0001782.mp4 t Transfer: 1220 : 12|18:25:48.5604|YIAwZc|TMDDBA|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/N0001782.mp4 t Transfer: 1220 : 12|18:25:48.5604|YIAwZc|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 12|18:25:48.5604|YIAwZc|TMDDBA| OAuth authenticated t Transfer: 1220 : 12|18:25:48.5604|YIAwZc|TMDDBA| user TMDDBA. t Transfer: 1220 : 12|18:25:48.5604|YIAwZc|TMDDBA|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\N0001784.mp4 subfolder t Transfer: 1220 : 12|18:25:48.5604|YIAwZc|TMDDBA| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/N0001784.mp4 t Transfer: 1220 : 12|18:25:48.5604|YIAwZc|TMDDBA|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/N0001784.mp4 t Transfer: 1220 : 12|18:25:48.5604|YIAwZc|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 12|18:25:48.5604|YIAwZc|TMDDBA| OAuth authenticated t Transfer: 1220 : 12|18:25:48.5604|YIAwZc|TMDDBA| user TMDDBA. t Transfer: 1220 : 12|18:25:48.7635|Mqr8sT|TMDDBA|OAuth: /api/user-preferences?_dc=1585589148608 t Transfer: 1220 : 12|18:25:48.7635|Mqr8sT|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 12|18:25:48.7635|Mqr8sT|TMDDBA| OAuth authenticated t Transfer: 1220 : 12|18:25:48.7635|Mqr8sT|TMDDBA| user TMDDBA. t Verbose: 1220 : 12|18:25:48.7635|Mqr8sT|TMDDBA|OAuth. User logged in: TMDDBA t Verbose: 1220 : 12|18:25:48.7635|Mqr8sT|TMDDBA|StoreUserDataByKeys.. t Transfer: 1220 : 12|18:25:48.7635|Mqr8sT|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 12|18:25:48.7635|Mqr8sT|TMDDBA| OAuth authenticated t Transfer: 1220 : 12|18:25:48.7635|Mqr8sT|TMDDBA| user TMDDBA. t Verbose: 1220 : 12|18:25:48.7635|Mqr8sT|TMDDBA|imfx v3 API took 0.009s '/api/user-preferences?_dc=1585589148608' t Transfer: 1220 : 12|18:25:54.2479|iLo8VZ|TMDDBA|OAuth: /api/v3/search/Media?_dc=1585589154150 t Transfer: 1220 : 12|18:25:54.2479|iLo8VZ|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 12|18:25:54.2479|iLo8VZ|TMDDBA| OAuth authenticated t Transfer: 1220 : 12|18:25:54.2479|iLo8VZ|TMDDBA| user TMDDBA. t Verbose: 1220 : 12|18:25:54.2479|iLo8VZ|TMDDBA|OAuth. User logged in: TMDDBA t Information: 1220 : 12|18:25:54.2479|iLo8VZ|TMDDBA|V3Api.SearchMedia t Information: 1220 : 12|18:25:54.2479|iLo8VZ|TMDDBA|V3Api.SearchGeneric t Transfer: 1220 : 12|18:25:54.2479|iLo8VZ|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 12|18:25:54.2479|iLo8VZ|TMDDBA| OAuth authenticated t Transfer: 1220 : 12|18:25:54.2479|iLo8VZ|TMDDBA| user TMDDBA. t Information: 1220 : 12|18:25:54.2479|iLo8VZ|TMDDBA|Running solr search: [q, (((created_date:[2020-03-29T23:00:00Z TO 2020-03-30T23:00:00Z}})) 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 (ATP) 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 (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 (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 (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 : 12|18:25:54.2479|iLo8VZ|TMDDBA|Solr query returned: 15 in 7ms t Information: 1220 : 12|18:25:54.2479|iLo8VZ|TMDDBA|MediaSearch SQL: select r.*, nvl((select TMD_STR_AGG(c.u_id_pfix ) from tm_ctnrs c, tm_mi_tpi_lnx l where l.miid=r.id and c.u_id=l.tpiid and r.media_type=1),'') BARCODE, nvl(lnk.lib_loc_ext_id,0) lib_loc_ext_id, nvl(lnk.ctnr_loan_stat,0) ctnr_loan_status, nvl(lnk.ctnr_stat,0) ctnr_stat, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID , (select min(status.description) from TM_CFG_PGM_STATUS status where r.status = status.id) PGM_STATUS_TEXT, (select tmd_str_agg_pipe(cms.status_type_id ||',' ||cms.status_id) from tm_mi_cust_med_stat_lnx cms where cms.media_id=r.id) "CustomStatusesRaw", GETMEDIALOC(r.id, r.media_type, r.compil, r.m_ctnr_int_o_loc, r.m_ctnr_ext_o_loc, r.m_ctnr_loc) LOCATION, nvl(dfl.fSOM,0) FILE_SOM, nvl(dfl.fEOM,0) FILE_EOM, dfl.fos_fname FILENAME, dfl.DFILE_LINK_GUID, dfl.OS_GUID, dfl.SUB_FOLDER, dfl.ORIGINAL_FILENAME from (select a.*, rownum rnum from (select m.*, coalesce(m.primary_thumb_id, (select v.primary_thumb_id from tm_pg_rl v where v.id=m.pgm_parent_id)) primary_thumb_id2 from tmddba.tm_mis m ,(select /*+ cardinality(4) */ rownum rn, column_value id from table(:ids)) ids where media_type>0 and item_type>0 and m.id = ids.id order by ids.rn ) a where rownum <= 10000) r ,lateral( select l.miid, max(c.C_EXT_OUT_LOC) lib_loc_ext_id, max(c.C_STAT) ctnr_stat, max(c.loan_stat) ctnr_loan_stat from tm_mi_tpi_lnx l, tm_ctnrs c where c.u_id=l.tpiid and l.miid=r.id and r.media_type=1 group by l.miid)(+) lnk ,lateral(select tt.* from tm_text tt where tt.text_id = r.primary_thumb_id2)(+) t ,lateral(select /*+ NO_DECORRELATE */ d.som fsom, d.eom feom, dl.mi_id fmi_id, d.os_fname fos_fname, d.DFILE_LINK_GUID, d.OS_GUID, d.SUB_FOLDER, dl.dfile_id, d.original_filename FROM tm_dfile d, tm_mi_dfile_lnx dl where d.id=dl.dfile_id and r.id=dl.mi_id and rownum=1)(+) dfl where rnum >= 1 order by rnum t Information: 1220 : 12|18:25:54.4510|iLo8VZ|TMDDBA| timing: 00:00:00.0473670 t Verbose: 1220 : 12|18:25:54.4510|iLo8VZ|TMDDBA|imfx v3 API took 0.047s '/api/v3/search/Media?_dc=1585589154150' t Transfer: 1220 : 12|18:25:54.4510|iLo8VZ|TMDDBA|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\short.mov subfolder t Transfer: 1220 : 12|18:25:54.4510|iLo8VZ|TMDDBA| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/short.mov t Transfer: 1220 : 12|18:25:54.4510|iLo8VZ|TMDDBA|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/short.mov t Transfer: 1220 : 12|18:25:54.4510|iLo8VZ|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 12|18:25:54.4510|iLo8VZ|TMDDBA| OAuth authenticated t Transfer: 1220 : 12|18:25:54.4510|iLo8VZ|TMDDBA| user TMDDBA. t Transfer: 1220 : 12|18:25:54.4510|iLo8VZ|TMDDBA|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\N0001781.mp4 subfolder t Transfer: 1220 : 12|18:25:54.4510|iLo8VZ|TMDDBA| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/N0001781.mp4 t Transfer: 1220 : 12|18:25:54.4510|iLo8VZ|TMDDBA|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/N0001781.mp4 t Transfer: 1220 : 12|18:25:54.4510|iLo8VZ|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 12|18:25:54.4510|iLo8VZ|TMDDBA| OAuth authenticated t Transfer: 1220 : 12|18:25:54.4510|iLo8VZ|TMDDBA| user TMDDBA. t Transfer: 1220 : 12|18:25:54.4510|iLo8VZ|TMDDBA|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\N0001782.mp4 subfolder t Transfer: 1220 : 12|18:25:54.4510|iLo8VZ|TMDDBA| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/N0001782.mp4 t Transfer: 1220 : 12|18:25:54.4510|iLo8VZ|TMDDBA|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/N0001782.mp4 t Transfer: 1220 : 12|18:25:54.4510|iLo8VZ|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 12|18:25:54.4510|iLo8VZ|TMDDBA| OAuth authenticated t Transfer: 1220 : 12|18:25:54.4510|iLo8VZ|TMDDBA| user TMDDBA. t Transfer: 1220 : 12|18:25:54.4510|iLo8VZ|TMDDBA|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\N0001783.mp4 subfolder t Transfer: 1220 : 12|18:25:54.4510|iLo8VZ|TMDDBA| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/N0001783.mp4 t Transfer: 1220 : 12|18:25:54.4510|iLo8VZ|TMDDBA|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/N0001783.mp4 t Transfer: 1220 : 12|18:25:54.4510|iLo8VZ|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 12|18:25:54.4510|iLo8VZ|TMDDBA| OAuth authenticated t Transfer: 1220 : 12|18:25:54.4510|iLo8VZ|TMDDBA| user TMDDBA. t Transfer: 1220 : 12|18:25:54.4510|iLo8VZ|TMDDBA|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\N0001784.mp4 subfolder t Transfer: 1220 : 12|18:25:54.4510|iLo8VZ|TMDDBA| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/N0001784.mp4 t Transfer: 1220 : 12|18:25:54.4510|iLo8VZ|TMDDBA|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/N0001784.mp4 t Transfer: 1220 : 12|18:25:54.4510|iLo8VZ|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 12|18:25:54.4510|iLo8VZ|TMDDBA| OAuth authenticated t Transfer: 1220 : 12|18:25:54.4510|iLo8VZ|TMDDBA| user TMDDBA. t Transfer: 1220 : 12|18:25:54.4510|~Z47vq|TMDDBA|OAuth: /api/user-preferences?_dc=1585589154334 t Transfer: 1220 : 12|18:25:54.4510|~Z47vq|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 12|18:25:54.4510|~Z47vq|TMDDBA| OAuth authenticated t Transfer: 1220 : 12|18:25:54.4510|~Z47vq|TMDDBA| user TMDDBA. t Verbose: 1220 : 12|18:25:54.4510|~Z47vq|TMDDBA|OAuth. User logged in: TMDDBA t Verbose: 1220 : 12|18:25:54.4510|~Z47vq|TMDDBA|StoreUserDataByKeys.. t Transfer: 1220 : 12|18:25:54.4510|~Z47vq|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 12|18:25:54.4510|~Z47vq|TMDDBA| OAuth authenticated t Transfer: 1220 : 12|18:25:54.4510|~Z47vq|TMDDBA| user TMDDBA. t Verbose: 1220 : 12|18:25:54.4510|~Z47vq|TMDDBA|imfx v3 API took 0.012s '/api/user-preferences?_dc=1585589154334' t Transfer: 1220 : 12|18:25:59.1229|9yFUWi|TMDDBA|OAuth: /api/v3/media-details/299034?_dc=1585589158991 t Transfer: 1220 : 12|18:25:59.1229|9yFUWi|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 12|18:25:59.1229|9yFUWi|TMDDBA| OAuth authenticated t Transfer: 1220 : 12|18:25:59.1229|9yFUWi|TMDDBA| user TMDDBA. t Verbose: 1220 : 12|18:25:59.1229|9yFUWi|TMDDBA|OAuth. User logged in: TMDDBA t Transfer: 1220 : 12|18:25:59.1229|9yFUWi|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 12|18:25:59.1229|9yFUWi|TMDDBA| OAuth authenticated t Transfer: 1220 : 12|18:25:59.1229|9yFUWi|TMDDBA| user TMDDBA. t Information: 1220 : 12|18:25:59.1229|||TM_MIS. LoadSubtitles for ID: 299034 t Information: 1220 : 12|18:25:59.1229|||TM_MIS. LoadSubtitles for ID: 299034. 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=299000' t Information: 1220 : 12|18:25:59.1229|||TM_MIS. LoadSubtitles for ID: 299034 found no subtitles. t Verbose: 1220 : 12|18:25:59.3260|9yFUWi|TMDDBA|imfx v3 API took 0.128s '/api/v3/media-details/299034?_dc=1585589158991' t Transfer: 1220 : 12|18:25:59.3260|~zNlED|TMDDBA|OAuth: /api/v3/media-captions/299034?_dc=1585589159193 t Transfer: 1220 : 12|18:25:59.3260|~zNlED|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 12|18:25:59.3260|~zNlED|TMDDBA| OAuth authenticated t Transfer: 1220 : 12|18:25:59.3260|~zNlED|TMDDBA| user TMDDBA. t Verbose: 1220 : 12|18:25:59.3260|~zNlED|TMDDBA|OAuth. User logged in: TMDDBA t Verbose: 1220 : 12|18:25:59.3260|~zNlED|TMDDBA|imfx v3 API took 0.013s '/api/v3/media-captions/299034?_dc=1585589159193' t Transfer: 1220 : 12|18:26:00.3416|kFw0G7|TMDDBA|OAuth: /api/v3/ai-tags/299034?_dc=1585589160097 t Transfer: 1220 : 12|18:26:00.3416|kFw0G7|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 12|18:26:00.3416|kFw0G7|TMDDBA| OAuth authenticated t Transfer: 1220 : 12|18:26:00.3416|kFw0G7|TMDDBA| user TMDDBA. t Verbose: 1220 : 12|18:26:00.3416|kFw0G7|TMDDBA|OAuth. User logged in: TMDDBA t Information: 1220 : 12|18:26:00.3416|kFw0G7|TMDDBA|V3Api.GetMediaAiTags t Verbose: 1220 : 12|18:26:00.3416|kFw0G7|TMDDBA|imfx v3 API took 0.023s '/api/v3/ai-tags/299034?_dc=1585589160097' t Transfer: 1220 : 12|18:26:00.3416|cTP52s|TMDDBA|OAuth: /api/metadata/4000/299034?_dc=1585589160177 t Transfer: 1220 : 12|18:26:00.3416|cTP52s|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 12|18:26:00.3416|cTP52s|TMDDBA| OAuth authenticated t Transfer: 1220 : 12|18:26:00.3416|cTP52s|TMDDBA| user TMDDBA. t Verbose: 1220 : 12|18:26:00.3416|cTP52s|TMDDBA|OAuth. User logged in: TMDDBA t Verbose: 1220 : 12|18:26:00.3416|cTP52s|TMDDBA|imfx v3 API took 0.014s '/api/metadata/4000/299034?_dc=1585589160177' t Transfer: 1220 : 12|18:26:09.4823|3teWsw|TMDDBA|OAuth: /api/v3/config/servicexml/types?_dc=1585589169397 t Transfer: 1220 : 12|18:26:09.4823|3teWsw|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 12|18:26:09.4823|3teWsw|TMDDBA| OAuth authenticated t Transfer: 1220 : 12|18:26:09.4823|3teWsw|TMDDBA| user TMDDBA. t Verbose: 1220 : 12|18:26:09.4823|3teWsw|TMDDBA|OAuth. User logged in: TMDDBA t Verbose: 1220 : 12|18:26:09.4823|3teWsw|TMDDBA|imfx v3 API took 0.013s '/api/v3/config/servicexml/types?_dc=1585589169397' t Transfer: 1220 : 12|18:26:09.6854|g9i8r2|TMDDBA|OAuth: /api/settings/groups/?_dc=1585589169448 t Transfer: 1220 : 12|18:26:09.6854|g9i8r2|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 12|18:26:09.6854|g9i8r2|TMDDBA| OAuth authenticated t Transfer: 1220 : 12|18:26:09.6854|g9i8r2|TMDDBA| user TMDDBA. t Verbose: 1220 : 12|18:26:09.6854|g9i8r2|TMDDBA|OAuth. User logged in: TMDDBA t Verbose: 1220 : 12|18:26:09.6854|g9i8r2|TMDDBA|imfx v3 API took 0.026s '/api/settings/groups/?_dc=1585589169448' t Transfer: 1220 : 12|18:26:14.1541|3cydLt|TMDDBA|OAuth: /api/v3/mfx-settings/groups?_dc=1585589173958 t Transfer: 1220 : 12|18:26:14.1541|3cydLt|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 12|18:26:14.1541|3cydLt|TMDDBA| OAuth authenticated t Transfer: 1220 : 12|18:26:14.1541|3cydLt|TMDDBA| user TMDDBA. t Verbose: 1220 : 12|18:26:14.1541|3cydLt|TMDDBA|OAuth. User logged in: TMDDBA t Verbose: 1220 : 12|18:26:14.1541|3cydLt|TMDDBA|imfx v3 API took 0.001s '/api/v3/mfx-settings/groups?_dc=1585589173958' t Transfer: 1220 : 12|18:26:14.1541|a~4j19|TMDDBA|OAuth: /api/v3/mfx-settings?_dc=1585589174081 t Transfer: 1220 : 12|18:26:14.1541|a~4j19|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 12|18:26:14.1541|a~4j19|TMDDBA| OAuth authenticated t Transfer: 1220 : 12|18:26:14.1541|a~4j19|TMDDBA| user TMDDBA. t Verbose: 1220 : 12|18:26:14.1541|a~4j19|TMDDBA|OAuth. User logged in: TMDDBA t Information: 1220 : 12|18:26:14.1541|a~4j19|TMDDBA|GetMfxSettings t Verbose: 1220 : 12|18:26:14.3573|a~4j19|TMDDBA|imfx v3 API took 0.047s '/api/v3/mfx-settings?_dc=1585589174081' t Transfer: 1220 : 12|18:26:18.4198|pBf01C|TMDDBA|OAuth: /api/v3/config-tables?_dc=1585589178192 t Transfer: 1220 : 12|18:26:18.4198|pBf01C|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 12|18:26:18.4198|pBf01C|TMDDBA| OAuth authenticated t Transfer: 1220 : 12|18:26:18.4198|pBf01C|TMDDBA| user TMDDBA. t Verbose: 1220 : 12|18:26:18.4198|pBf01C|TMDDBA|OAuth. User logged in: TMDDBA t Verbose: 1220 : 12|18:26:18.4198|pBf01C|TMDDBA|imfx v3 API took 0.008s '/api/v3/config-tables?_dc=1585589178192' t Information: 1220 : 12|18:26:22.2792|ogcZZs|TMDDBA|GetConfig TM_CFG_MEDIA_FILE_TYPES. t Verbose: 1220 : 12|18:26:22.4823|ogcZZs|TMDDBA|imfx v3 API took 0.182s '/api/v3/config-table/TM_CFG_MEDIA_FILE_TYPES?_dc=1585589182150' t Information: 1220 : 12|18:26:43.8104|8sh3~O|TMDDBA|GetUserProfile. Id: 30000 t Transfer: 1220 : 12|18:26:43.8104|8sh3~O|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 12|18:26:43.8104|8sh3~O|TMDDBA| OAuth authenticated t Transfer: 1220 : 12|18:26:43.8104|8sh3~O|TMDDBA| user TMDDBA. t Transfer: 1220 : 12|18:26:47.2636|YQ_wdo|TMDDBA|OAuth: /api/v3/config-table/TM_CFG_MEDIA_FILE_TYPES?_dc=1585589207007 t Transfer: 1220 : 12|18:26:47.2636|YQ_wdo|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 12|18:26:47.2636|YQ_wdo|TMDDBA| OAuth authenticated t Transfer: 1220 : 12|18:26:47.2636|YQ_wdo|TMDDBA| user TMDDBA. t Verbose: 1220 : 12|18:26:47.2636|YQ_wdo|TMDDBA|OAuth. User logged in: TMDDBA t Information: 1220 : 12|18:26:47.2636|YQ_wdo|TMDDBA|PostConfig TM_CFG_MEDIA_FILE_TYPES t Transfer: 1220 : 12|18:26:47.2636|YQ_wdo|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 12|18:26:47.2636|YQ_wdo|TMDDBA| OAuth authenticated t Transfer: 1220 : 12|18:26:47.2636|YQ_wdo|TMDDBA| user TMDDBA. t Verbose: 1220 : 12|18:26:47.4667|YQ_wdo|TMDDBA|imfx v3 API took 0.258s '/api/v3/config-table/TM_CFG_MEDIA_FILE_TYPES?_dc=1585589207007' t Information: 1220 : 12|18:26:47.4667|smfgcQ|TMDDBA|GetConfig TM_CFG_MEDIA_FILE_TYPES. t Verbose: 1220 : 12|18:26:47.4667|smfgcQ|TMDDBA|imfx v3 API took 0.009s '/api/v3/config-table/TM_CFG_MEDIA_FILE_TYPES?_dc=1585589207309' t Transfer: 1220 : 12|18:26:54.1697|q0ztpO|TMDDBA|OAuth: /api/v3/search/Media?_dc=1585589214068 t Transfer: 1220 : 12|18:26:54.1697|q0ztpO|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 12|18:26:54.1697|q0ztpO|TMDDBA| OAuth authenticated t Transfer: 1220 : 12|18:26:54.1697|q0ztpO|TMDDBA| user TMDDBA. t Verbose: 1220 : 12|18:26:54.1697|q0ztpO|TMDDBA|OAuth. User logged in: TMDDBA t Information: 1220 : 12|18:26:54.1697|q0ztpO|TMDDBA|V3Api.SearchMedia t Information: 1220 : 12|18:26:54.1697|q0ztpO|TMDDBA|V3Api.SearchGeneric t Transfer: 1220 : 12|18:26:54.1697|q0ztpO|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 12|18:26:54.1697|q0ztpO|TMDDBA| OAuth authenticated t Transfer: 1220 : 12|18:26:54.1697|q0ztpO|TMDDBA| user TMDDBA. t Information: 1220 : 12|18:26:54.1697|q0ztpO|TMDDBA|Running solr search: [q, (((created_date:[2020-03-29T23:00:00Z TO 2020-03-30T23:00:00Z}})) 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 (ATP) 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 (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 (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 (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 : 12|18:26:54.1697|q0ztpO|TMDDBA|Solr query returned: 15 in 2ms t Information: 1220 : 12|18:26:54.1697|q0ztpO|TMDDBA|MediaSearch SQL: select r.*, nvl((select TMD_STR_AGG(c.u_id_pfix ) from tm_ctnrs c, tm_mi_tpi_lnx l where l.miid=r.id and c.u_id=l.tpiid and r.media_type=1),'') BARCODE, nvl(lnk.lib_loc_ext_id,0) lib_loc_ext_id, nvl(lnk.ctnr_loan_stat,0) ctnr_loan_status, nvl(lnk.ctnr_stat,0) ctnr_stat, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID , (select min(status.description) from TM_CFG_PGM_STATUS status where r.status = status.id) PGM_STATUS_TEXT, (select tmd_str_agg_pipe(cms.status_type_id ||',' ||cms.status_id) from tm_mi_cust_med_stat_lnx cms where cms.media_id=r.id) "CustomStatusesRaw", GETMEDIALOC(r.id, r.media_type, r.compil, r.m_ctnr_int_o_loc, r.m_ctnr_ext_o_loc, r.m_ctnr_loc) LOCATION, nvl(dfl.fSOM,0) FILE_SOM, nvl(dfl.fEOM,0) FILE_EOM, dfl.fos_fname FILENAME, dfl.DFILE_LINK_GUID, dfl.OS_GUID, dfl.SUB_FOLDER, dfl.ORIGINAL_FILENAME from (select a.*, rownum rnum from (select m.*, coalesce(m.primary_thumb_id, (select v.primary_thumb_id from tm_pg_rl v where v.id=m.pgm_parent_id)) primary_thumb_id2 from tmddba.tm_mis m ,(select /*+ cardinality(4) */ rownum rn, column_value id from table(:ids)) ids where media_type>0 and item_type>0 and m.id = ids.id order by ids.rn ) a where rownum <= 10000) r ,lateral( select l.miid, max(c.C_EXT_OUT_LOC) lib_loc_ext_id, max(c.C_STAT) ctnr_stat, max(c.loan_stat) ctnr_loan_stat from tm_mi_tpi_lnx l, tm_ctnrs c where c.u_id=l.tpiid and l.miid=r.id and r.media_type=1 group by l.miid)(+) lnk ,lateral(select tt.* from tm_text tt where tt.text_id = r.primary_thumb_id2)(+) t ,lateral(select /*+ NO_DECORRELATE */ d.som fsom, d.eom feom, dl.mi_id fmi_id, d.os_fname fos_fname, d.DFILE_LINK_GUID, d.OS_GUID, d.SUB_FOLDER, dl.dfile_id, d.original_filename FROM tm_dfile d, tm_mi_dfile_lnx dl where d.id=dl.dfile_id and r.id=dl.mi_id and rownum=1)(+) dfl where rnum >= 1 order by rnum t Information: 1220 : 12|18:26:54.3729|q0ztpO|TMDDBA| timing: 00:00:00.0332052 t Verbose: 1220 : 12|18:26:54.3729|q0ztpO|TMDDBA|imfx v3 API took 0.033s '/api/v3/search/Media?_dc=1585589214068' t Transfer: 1220 : 12|18:26:54.3729|q0ztpO|TMDDBA|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\short.mov subfolder t Transfer: 1220 : 12|18:26:54.3729|q0ztpO|TMDDBA| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/short.mov t Transfer: 1220 : 12|18:26:54.3729|q0ztpO|TMDDBA|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/short.mov t Transfer: 1220 : 12|18:26:54.3729|q0ztpO|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 12|18:26:54.3729|q0ztpO|TMDDBA| OAuth authenticated t Transfer: 1220 : 12|18:26:54.3729|q0ztpO|TMDDBA| user TMDDBA. t Transfer: 1220 : 12|18:26:54.3729|q0ztpO|TMDDBA|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\N0001781.mp4 subfolder t Transfer: 1220 : 12|18:26:54.3729|q0ztpO|TMDDBA| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/N0001781.mp4 t Transfer: 1220 : 12|18:26:54.3729|q0ztpO|TMDDBA|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/N0001781.mp4 t Transfer: 1220 : 12|18:26:54.3729|q0ztpO|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 12|18:26:54.3729|q0ztpO|TMDDBA| OAuth authenticated t Transfer: 1220 : 12|18:26:54.3729|q0ztpO|TMDDBA| user TMDDBA. t Transfer: 1220 : 12|18:26:54.3729|q0ztpO|TMDDBA|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\N0001782.mp4 subfolder t Transfer: 1220 : 12|18:26:54.3729|q0ztpO|TMDDBA| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/N0001782.mp4 t Transfer: 1220 : 12|18:26:54.3729|q0ztpO|TMDDBA|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/N0001782.mp4 t Transfer: 1220 : 12|18:26:54.3729|q0ztpO|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 12|18:26:54.3729|q0ztpO|TMDDBA| OAuth authenticated t Transfer: 1220 : 12|18:26:54.3729|q0ztpO|TMDDBA| user TMDDBA. t Transfer: 1220 : 12|18:26:54.3729|q0ztpO|TMDDBA|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\N0001783.mp4 subfolder t Transfer: 1220 : 12|18:26:54.3729|q0ztpO|TMDDBA| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/N0001783.mp4 t Transfer: 1220 : 12|18:26:54.3729|q0ztpO|TMDDBA|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/N0001783.mp4 t Transfer: 1220 : 12|18:26:54.3729|q0ztpO|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 12|18:26:54.3729|q0ztpO|TMDDBA| OAuth authenticated t Transfer: 1220 : 12|18:26:54.3729|q0ztpO|TMDDBA| user TMDDBA. t Transfer: 1220 : 12|18:26:54.3729|q0ztpO|TMDDBA|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\N0001784.mp4 subfolder t Transfer: 1220 : 12|18:26:54.3729|q0ztpO|TMDDBA| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/N0001784.mp4 t Transfer: 1220 : 12|18:26:54.3729|q0ztpO|TMDDBA|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/N0001784.mp4 t Transfer: 1220 : 12|18:26:54.3729|q0ztpO|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 12|18:26:54.3729|q0ztpO|TMDDBA| OAuth authenticated t Transfer: 1220 : 12|18:26:54.3729|q0ztpO|TMDDBA| user TMDDBA. t Transfer: 1220 : 12|18:26:54.3729|KRh5s8|TMDDBA|OAuth: /api/user-preferences?_dc=1585589214264 t Transfer: 1220 : 12|18:26:54.3729|KRh5s8|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 12|18:26:54.3729|KRh5s8|TMDDBA| OAuth authenticated t Transfer: 1220 : 12|18:26:54.3729|KRh5s8|TMDDBA| user TMDDBA. t Verbose: 1220 : 12|18:26:54.3729|KRh5s8|TMDDBA|OAuth. User logged in: TMDDBA t Verbose: 1220 : 12|18:26:54.3729|KRh5s8|TMDDBA|StoreUserDataByKeys.. t Transfer: 1220 : 12|18:26:54.3729|KRh5s8|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 12|18:26:54.3729|KRh5s8|TMDDBA| OAuth authenticated t Transfer: 1220 : 12|18:26:54.3729|KRh5s8|TMDDBA| user TMDDBA. t Verbose: 1220 : 12|18:26:54.3729|KRh5s8|TMDDBA|imfx v3 API took 0.006s '/api/user-preferences?_dc=1585589214264' t Transfer: 1220 : 12|18:26:55.9979|jl3BL2|TMDDBA|OAuth: /api/v3/media-details/299034?_dc=1585589215861 t Transfer: 1220 : 12|18:26:55.9979|jl3BL2|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 12|18:26:55.9979|jl3BL2|TMDDBA| OAuth authenticated t Transfer: 1220 : 12|18:26:55.9979|jl3BL2|TMDDBA| user TMDDBA. t Verbose: 1220 : 12|18:26:55.9979|jl3BL2|TMDDBA|OAuth. User logged in: TMDDBA t Transfer: 1220 : 12|18:26:55.9979|jl3BL2|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 12|18:26:55.9979|jl3BL2|TMDDBA| OAuth authenticated t Transfer: 1220 : 12|18:26:55.9979|jl3BL2|TMDDBA| user TMDDBA. t Information: 1220 : 12|18:26:55.9979|||TM_MIS. LoadSubtitles for ID: 299034 t Information: 1220 : 12|18:26:55.9979|||TM_MIS. LoadSubtitles for ID: 299034. 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=299000' t Information: 1220 : 12|18:26:55.9979|||TM_MIS. LoadSubtitles for ID: 299034 found no subtitles. t Verbose: 1220 : 12|18:26:56.2010|jl3BL2|TMDDBA|imfx v3 API took 0.106s '/api/v3/media-details/299034?_dc=1585589215861' t Transfer: 1220 : 12|18:26:56.2010|uPWr6k|TMDDBA|OAuth: /api/v3/media-captions/299034?_dc=1585589216032 t Transfer: 1220 : 12|18:26:56.2010|uPWr6k|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 12|18:26:56.2010|uPWr6k|TMDDBA| OAuth authenticated t Transfer: 1220 : 12|18:26:56.2010|uPWr6k|TMDDBA| user TMDDBA. t Verbose: 1220 : 12|18:26:56.2010|uPWr6k|TMDDBA|OAuth. User logged in: TMDDBA t Verbose: 1220 : 12|18:26:56.2010|uPWr6k|TMDDBA|imfx v3 API took 0.004s '/api/v3/media-captions/299034?_dc=1585589216032' t Transfer: 1220 : 12|18:26:57.0135|HJ3C6c|TMDDBA|OAuth: /api/v3/ai-tags/299034?_dc=1585589216770 t Transfer: 1220 : 12|18:26:57.0135|HJ3C6c|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 12|18:26:57.0135|HJ3C6c|TMDDBA| OAuth authenticated t Transfer: 1220 : 12|18:26:57.0135|HJ3C6c|TMDDBA| user TMDDBA. t Verbose: 1220 : 12|18:26:57.0135|HJ3C6c|TMDDBA|OAuth. User logged in: TMDDBA t Information: 1220 : 12|18:26:57.0135|HJ3C6c|TMDDBA|V3Api.GetMediaAiTags t Verbose: 1220 : 12|18:26:57.0135|HJ3C6c|TMDDBA|imfx v3 API took 0.007s '/api/v3/ai-tags/299034?_dc=1585589216770' t Transfer: 1220 : 12|18:26:57.0135|pzyHNB|TMDDBA|OAuth: /api/metadata/4000/299034?_dc=1585589216806 t Transfer: 1220 : 12|18:26:57.0135|pzyHNB|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 12|18:26:57.0135|pzyHNB|TMDDBA| OAuth authenticated t Transfer: 1220 : 12|18:26:57.0135|pzyHNB|TMDDBA| user TMDDBA. t Verbose: 1220 : 12|18:26:57.0135|pzyHNB|TMDDBA|OAuth. User logged in: TMDDBA t Verbose: 1220 : 12|18:26:57.0135|pzyHNB|TMDDBA|imfx v3 API took 0.003s '/api/metadata/4000/299034?_dc=1585589216806' t Transfer: 1220 : 12|18:27:00.6698|Kegx~R||GetAppInfo. DB: TMDDEMO. Install mode: . Auth types: Native, PublicApiKey t Information: 1220 : 12|18:27:07.1698|||OrabitWatcherBasic. Disposing. t Information: 1220 : 12|18:27:07.1698|||OrabitWatcherBasic. Disposed. t Information: 1220 : 12|18:27:07.1698|||========================================================================== t Information: 1220 : 12|18:27:07.1698|||IMFX CORE SERVER APPLICATION END.