t Information: 1220 : 12|10:05:14.8751|||Get Configuration Values:
t Information: 1220 : 12|10:05:14.8751||| AdminPassEnc, default: , value: ffqjrn0leKv4Lj2YJHe2dw==.
t Information: 1220 : 12|10:05:14.8751||| EncryptedPasswords, default: false, value: true.
t Information: 1220 : 12|10:05:14.8751||| OraConnectionString, default: , value: Server=TECHM;User Id=imfx;Password=xxxxx;Unicode=true;.
t Information: 1220 : 12|10:05:14.8751||| SecondTimezone, default: , value: .
t Information: 1220 : 12|10:05:14.8751||| UseActiveDirectoryAuth, default: false, value: false.
t Information: 1220 : 12|10:05:14.8751||| ReportingServiceUrl, default: , value: http://localhost:92/ReportingService.svc.
t Information: 1220 : 12|10:05:14.8751||| ReportsPath, default: , value: .
t Information: 1220 : 12|10:05:14.8751||| ReportsURL, default: , value: .
t Information: 1220 : 12|10:05:14.8751||| TapeServiceUrl, default: , value: .
t Information: 1220 : 12|10:05:14.8751||| GatekeeperUrl, default: , value: .
t Information: 1220 : 12|10:05:14.8751||| ValuationUrl, default: , value: .
t Information: 1220 : 12|10:05:14.8751||| QueueManagerDelay, default: 30, value: 30.
t Information: 1220 : 12|10:05:14.8751||| QueueManagerFullRefresh, default: 90, value: 90.
t Information: 1220 : 12|10:05:14.8751||| AudioLoopDuration, default: 0, value: 150.
t Information: 1220 : 12|10:05:14.8751||| AudioLoopsCount, default: 0, value: 0.
t Information: 1220 : 12|10:05:14.8751||| PlayerFakeStep, default: 500, value: 500.
t Information: 1220 : 12|10:05:14.8751||| PlayerForceRatio, default: 0, value: 1.
t Information: 1220 : 12|10:05:14.8751||| CheckVersionsInProd, default: false, value: True.
t Information: 1220 : 12|10:05:14.8751||| MaxResults, default: 3000, value: 10000.
t Information: 1220 : 12|10:05:14.8751||| NetworkRestriction, default: false, value: True.
t Information: 1220 : 12|10:05:14.8751||| TEReportID, default: 0, value: 0.
t Information: 1220 : 12|10:05:14.8751||| ClosedCaptionsCache, default: , value: C:\inetpub\wwwroot\imfxcore\timedtextcache\.
t Information: 1220 : 12|10:05:14.8751||| ClosedCaptionsStorage, default: , value: c:\Mediaflex\subs.
t Information: 1220 : 12|10:05:14.8751||| TimeCodeFormat, default: , value: pal.
t Information: 1220 : 12|10:05:14.8751||| RceMediaPath, default: , value: C:\edl\.
t Information: 1220 : 12|10:05:14.8751||| RceMediaPath, default: , value: C:\edl\.
t Information: 1220 : 12|10:05:14.8751||| RceCsmOutputPath, default: , value: C:\Inetpub\wwwroot\csm\.
t Information: 1220 : 12|10:05:14.8751||| RceCsmUrl, default: , value: http://localhost/csm/.
t Information: 1220 : 12|10:05:14.8751||| RceMediaSelection, default: , value: miLinkIdMatch.
t Information: 1220 : 12|10:05:14.8751||| RequestBrowseJobPresetName, default: , value: .
t Information: 1220 : 12|10:05:14.8751||| DontExtendDuration, default: false, value: False.
t Information: 1220 : 12|10:05:14.8751||| V3ConfigUrl, default: , value: .
t Information: 1220 : 12|10:05:14.8751||| StopWords, default: , value: .
t Information: 1220 : 12|10:05:14.8751||| MisrTxFormat, default: G, value: G.
t Information: 1220 : 12|10:05:14.8751||| ApiServer, default: , value: http://192.168.120.10:85.
t Information: 1220 : 12|10:05:14.8751||| ApiTimeout, default: 120, value: 120.
t Information: 1220 : 12|10:05:14.8907||| ApiWorkers, default: 10, value: 10.
t Information: 1220 : 12|10:05:14.8907||| UsePerfCounters, default: false, value: false.
t Information: 1220 : 12|10:05:14.8907||| StatsdAddress, default: , value: .
t Information: 1220 : 12|10:05:14.8907||| LogGetCurrentUser, default: true, value: true.
t Information: 1220 : 12|10:05:14.8907||| LogInternalApi, default: true, value: true.
t Information: 1220 : 12|10:05:14.8907||| ThumbnailServer, default: , value: .
t Information: 1220 : 12|10:05:14.8907||| LocationFilter, default: , value: .
t Information: 1220 : 12|10:05:14.8907||| SvUtilServiceUrl, default: , value: .
t Information: 1220 : 12|10:05:14.8907||| SolrConnection, default: , value: http://192.168.120.14:8983/solr.
t Information: 1220 : 12|10:05:14.8907||| UseIndexServerSearch, default: false, value: True.
t Information: 1220 : 12|10:05:14.8907||| SolrIndexVersion, default: 1, value: 6.
t Information: 1220 : 12|10:05:14.8907||| SolrConnection, default: , value: http://192.168.120.14:8983/solr.
t Information: 1220 : 12|10:05:14.8907||| FacetsGroups, default: , value: owners,season_id, series_id,version_key,item_type,media_type,media_format,episode_number.
t Information: 1220 : 12|10:05:14.8907||| FacetsGroupsVersion, default: , value: owners,season_id, series_id,version_key,episode_number.
t Information: 1220 : 12|10:05:14.8907||| FacetsGroupsChameleon, default: , value: season_id, series_id,genre,prod_year,version_key.
t Information: 1220 : 12|10:05:14.8907||| PreviewPreset, default: , value: .
t Information: 1220 : 12|10:05:14.8907||| DevMode, default: false, value: false.
t Information: 1220 : 12|10:05:14.8907||| DisableSysMan, default: false, value: false.
t Information: 1220 : 12|10:05:14.8907||| TimeCodeFormat, default: , value: pal.
t Information: 1220 : 12|10:05:14.8907||| FileCatalystStorageDevice, default: , value: .
t Information: 1220 : 12|10:05:14.8907||| UseResponsibilityTracking, default: true, value: True.
t Information: 1220 : 12|10:05:14.8907||| SubtitleDeviceFilter, default: , value: .
t Information: 1220 : 12|10:05:14.8907||| SystemMonitorNamedPipe, default: , value: .
t Information: 1220 : 12|10:05:14.8907||| OracleMonitorEnable, default: false, value: False.
t Information: 1220 : 12|10:05:14.8907||| ArcApiHost, default: , value: .
t Information: 1220 : 12|10:05:14.8907||| RabbitMqUrl, default: , value: amqp://192.168.120.14:5672.
t Information: 1220 : 12|10:05:14.8907||| SolrTimedTextSearch, default: false, value: false.
t Information: 1220 : 12|10:05:14.8907||| ProductionDurationUsageID, default: 1, value: 1.
t Information: 1220 : 12|10:05:15.0939|||GetStreamServers..
t Information: 1220 : 12|10:05:15.5001||| https://demo.tmd.tv/CBR Video/ |CBR Video| False
t Information: 1220 : 12|10:05:15.5001||| https://demo.tmd.tv/CBR Images/ |CBR Images| False
t Information: 1220 : 12|10:05:15.5001||| https://demo.tmd.tv/CBR Audio/ |CBR Audio| False
t Information: 1220 : 12|10:05:15.5001||| https://demo.tmd.tv/Temp Upload/ |TEMP_UPLOAD| False
t Information: 1220 : 12|10:05:15.5001||| http://localhost:82/images/ |IMAGES| False
t Information: 1220 : 12|10:05:15.5001||| http://192.168.91.73/smoothcloud/ |SMOOTH_CLOUD| False
t Information: 1220 : 12|10:05:15.5001||| http://192.168.91.73/cloudstore/ |CLOUD_STORE| False
t Information: 1220 : 12|10:05:15.5001||| http://192.168.91.73/editsystemin/ |EDIT_SYSTEM_IN| False
t Information: 1220 : 12|10:05:15.5001||| http://192.168.91.27:89/APPLEPROXY/ |APPLE_PROXY| False
t Information: 1220 : 12|10:05:15.5001||| http://localhost:82/video/ |FILESTORE_VIDEO| False
t Information: 1220 : 12|10:05:15.5001||| https://imfxv3tm.tmd.tv/streaming/ |Streaming| False
t Information: 1220 : 12|10:05:15.5001||| https://imfxv3tm.tmd.tv/VideoServer/ |Video| False
t Information: 1220 : 12|10:05:15.5001||| https://imfxv3tm.tmd.tv/AdobeIn/ |Adobe Premiere Pro In| False
t Information: 1220 : 12|10:05:15.5001||| https://imfxv3tm.tmd.tv/AudioServer/ |Audio| False
t Information: 1220 : 12|10:05:15.5001||| https://imfxv3tm.tmd.tv/ImageServer/ |Image| False
t Information: 1220 : 12|10:05:15.5001||| https://imfxv3tm.tmd.tv/DocsServer/ |Docs| False
t Information: 1220 : 12|10:05:15.5001||| https://imfxv3tm.tmd.tv/AmazonLabs/ |TEST HOUSE| False
t Information: 1220 : 12|10:05:15.5001||| SolrConnectionUms, default: http://192.168.120.14:8983/solr, value: http://192.168.120.14:8983/solr.
t Information: 1220 : 12|10:05:15.5001||| LogWebApi, default: false, value: false.
t Information: 1220 : 12|10:05:15.5001||| EmbeddedRceUrl, default: , value: .
t Information: 1220 : 12|10:05:15.5001||| InstallMode, default: , value: .
t Information: 1220 : 12|10:05:15.5001||| SamlRequestAddress, default: , value: .
t Information: 1220 : 12|10:05:15.5001||| SamlTrustedIssuer, default: , value: .
t Information: 1220 : 12|10:05:15.5001||| SamlLoginRedirect, default: , value: .
t Information: 1220 : 12|10:05:15.5001||| NaturalLangSearch, default: false, value: True.
t Information: 1220 : 12|10:05:15.5001||| OktaLoginField, default: , value: .
t Information: 1220 : 12|10:05:15.5001||| AuthenticationTypes, default: , value: Native,PublicApiKey.
t Information: 1220 : 12|10:05:15.5001|||OrabitWatcherBasic. Initialize.
t Information: 1220 : 12|10:05:15.5001|||FillDictionaryCache.
t Information: 1220 : 12|10:05:19.1720|||GetSupportedOperators
t Information: 1220 : 12|10:05:19.5783|||CacheTechReports.
t Information: 1220 : 12|10:05:19.5783|||& Cache update. Server (global) filled with timestamp 10:04:19.4845474. types null
t Information: 1220 : 12|10:05:19.5783|||InitializeFromDatabase.
'Server=TECHM;User Id=imfx;password=..;Unicode=true;'
direct False, home , timeout 15
t Information: 1220 : 12|10:05:19.5783|||FillDictionaryCache.
t Information: 1220 : 12|10:05:19.5783|||& Cache update. Server (global) filled with timestamp 10:04:19.5158013. types FriendlyNames, DatabaseSearchFieldData
t Information: 1220 : 12|10:05:20.1876|||==========================================================================
t Information: 1220 : 12|10:05:20.1876|||IMFX CORE SERVER APPLICATION START.
t Information: 1220 : 12|10:05:20.1876|||DLL VERSION: 2.5.0.2610.
t Information: 1220 : 12|10:05:20.1876|||IS TIMER HIGH RESOULTION : True.
t Information: 1220 : 12|10:05:20.1876||| UmsDev, default: False, value: False.
t Information: 1220 : 12|10:05:20.3908|||OrabitWatcherBasic trying to connect..
t Information: 1220 : 12|10:05:20.5939|||OrabitWatcherBasic connected.
t Information: 1220 : 12|10:05:20.5939|||OrabitWatcherBasic queue created tmd.cfg.in.252f12ec-79de-48b2-9518-e9b665f48cfc
t Transfer: 1220 : 12|10:05:22.8439|eUsTRS|DANIEL|OAuth: /api/view/searchinfo/task?_dc=1587719110452
t Transfer: 1220 : 12|10:05:22.8439|1o14c3|DANIEL|OAuth: /api/user-preferences?keys=adv.recent.searches.my.tasks&_dc=1587719110455
t Transfer: 1220 : 12|10:05:22.8439|jdbErm|DANIEL|OAuth: /api/view/info/TaskGrid?lang=en-US&_dc=1587719110476
t Transfer: 1220 : 12|10:05:22.8439|m0WMue|DANIEL|OAuth: /api/lookup/job-schedule-nodes/search/?_dc=1587719110566
t Transfer: 1220 : 12|10:05:22.8439|JFPU~X|DANIEL|OAuth: /api/view/searches/task?_dc=1587719110492
t Transfer: 1220 : 12|10:05:22.8439|m0WMue|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:05:22.8439|eUsTRS|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:05:22.8439|m0WMue|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:05:22.8439|eUsTRS|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:05:22.8439|m0WMue|DANIEL| user DANIEL.
t Transfer: 1220 : 12|10:05:22.8439|eUsTRS|DANIEL| user DANIEL.
t Verbose: 1220 : 12|10:05:22.8439|m0WMue|DANIEL|OAuth. User logged in: DANIEL
t Verbose: 1220 : 12|10:05:22.8439|eUsTRS|DANIEL|OAuth. User logged in: DANIEL
t Transfer: 1220 : 12|10:05:22.8439|jdbErm|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:05:22.8439|jdbErm|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:05:22.8439|jdbErm|DANIEL| user DANIEL.
t Verbose: 1220 : 12|10:05:22.8439|jdbErm|DANIEL|OAuth. User logged in: DANIEL
t Transfer: 1220 : 12|10:05:22.8439|1o14c3|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:05:22.8439|1o14c3|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:05:22.8439|1o14c3|DANIEL| user DANIEL.
t Verbose: 1220 : 12|10:05:22.8439|1o14c3|DANIEL|OAuth. User logged in: DANIEL
t Transfer: 1220 : 12|10:05:22.8439|JFPU~X|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:05:22.8439|JFPU~X|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:05:22.8439|JFPU~X|DANIEL| user DANIEL.
t Verbose: 1220 : 12|10:05:22.8439|JFPU~X|DANIEL|OAuth. User logged in: DANIEL
t Information: 1220 : 12|10:05:22.8439|1o14c3|DANIEL|GetUserDataByKeys: adv.recent.searches.my.tasks
t Transfer: 1220 : 12|10:05:22.8439|1o14c3|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:05:22.8439|1o14c3|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:05:22.8439|1o14c3|DANIEL| user DANIEL.
t Information: 1220 : 12|10:05:22.8439|jdbErm|DANIEL|GetGridViewBuilder. builder type TaskGrid.
t Information: 1220 : 12|10:05:22.8439|JFPU~X|DANIEL|GetSavedSearchNames. search type Task.
t Transfer: 1220 : 12|10:05:22.8439|JFPU~X|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:05:22.8439|JFPU~X|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:05:22.8439|JFPU~X|DANIEL| user DANIEL.
t Transfer: 1220 : 12|10:05:22.8439|jdbErm|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:05:22.8439|jdbErm|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:05:22.8439|jdbErm|DANIEL| user DANIEL.
t Information: 1220 : 12|10:05:22.8439|eUsTRS|DANIEL|GetAdvSearchColumns. search type Task grid .
t Verbose: 1220 : 12|10:05:23.0626|eUsTRS|DANIEL|imfx v3 API took 0.083s '/api/view/searchinfo/task?_dc=1587719110452'
t Verbose: 1220 : 12|10:05:23.0626|m0WMue|DANIEL|imfx v3 API took 0.138s '/api/lookup/job-schedule-nodes/search/?_dc=1587719110566'
t Verbose: 1220 : 12|10:05:23.0626|1o14c3|DANIEL|imfx v3 API took 0.097s '/api/user-preferences?keys=adv.recent.searches.my.tasks&_dc=1587719110455'
t Information: 1220 : 12|10:05:23.0626|jdbErm|DANIEL|UserGridView. LoadView. ID -2, Name Default.
t Transfer: 1220 : 12|10:05:23.0626|jdbErm|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:05:23.0626|jdbErm|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:05:23.0626|jdbErm|DANIEL| user DANIEL.
t Transfer: 1220 : 12|10:05:23.0626|jdbErm|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:05:23.0626|jdbErm|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:05:23.0626|jdbErm|DANIEL| user DANIEL.
t Verbose: 1220 : 12|10:05:23.0626|JFPU~X|DANIEL|imfx v3 API took 0.137s '/api/view/searches/task?_dc=1587719110492'
t Verbose: 1220 : 12|10:05:23.0626|jdbErm|DANIEL|imfx v3 API took 0.164s '/api/view/info/TaskGrid?lang=en-US&_dc=1587719110476'
t Transfer: 1220 : 12|10:05:23.2658|liPTQm|DANIEL|OAuth: /api/lookups/SearchSupportedOperators?_dc=1587719110454
t Transfer: 1220 : 12|10:05:23.2658|liPTQm|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:05:23.2658|liPTQm|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:05:23.2658|liPTQm|DANIEL| user DANIEL.
t Verbose: 1220 : 12|10:05:23.2658|liPTQm|DANIEL|OAuth. User logged in: DANIEL
t Verbose: 1220 : 12|10:05:23.2658|liPTQm|DANIEL|imfx v3 API took 0.041s '/api/lookups/SearchSupportedOperators?_dc=1587719110454'
t Transfer: 1220 : 12|10:05:23.2658|Sks91o|DANIEL|OAuth: /api/v3/search/mytasks?_dc=1587719110587
t Transfer: 1220 : 12|10:05:23.2658|Sks91o|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:05:23.2658|Sks91o|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:05:23.2658|Sks91o|DANIEL| user DANIEL.
t Verbose: 1220 : 12|10:05:23.2658|Sks91o|DANIEL|OAuth. User logged in: DANIEL
t Transfer: 1220 : 12|10:05:23.2658|BRoNZX|DANIEL|OAuth: /api/v3/search/mytasks?_dc=1587719111689
t Transfer: 1220 : 12|10:05:23.2658|BRoNZX|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:05:23.2658|BRoNZX|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:05:23.2658|BRoNZX|DANIEL| user DANIEL.
t Verbose: 1220 : 12|10:05:23.2658|BRoNZX|DANIEL|OAuth. User logged in: DANIEL
t Information: 1220 : 12|10:05:23.4689|Sks91o|DANIEL|V3Api.SearchMyTasks
t Information: 1220 : 12|10:05:23.4689|BRoNZX|DANIEL|V3Api.SearchMyTasks
t Information: 1220 : 12|10:05:23.4689|Sks91o|DANIEL|V3Api.SearchGeneric
t Information: 1220 : 12|10:05:23.4689|BRoNZX|DANIEL|V3Api.SearchGeneric
t Transfer: 1220 : 12|10:05:23.4689|Sks91o|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:05:23.4689|Sks91o|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:05:23.4689|Sks91o|DANIEL| user DANIEL.
t Transfer: 1220 : 12|10:05:23.4689|BRoNZX|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:05:23.4689|BRoNZX|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:05:23.4689|BRoNZX|DANIEL| user DANIEL.
t Transfer: 1220 : 12|10:05:23.4689|BRoNZX|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:05:23.4689|BRoNZX|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:05:23.4689|BRoNZX|DANIEL| user DANIEL.
t Transfer: 1220 : 12|10:05:23.4689|Sks91o|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:05:23.4689|Sks91o|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:05:23.4689|Sks91o|DANIEL| user DANIEL.
t Information: 1220 : 12|10:05:23.4689|Sks91o|DANIEL|SearchTask SQL:
select * from (select a.*, rownum rnum from ( select /*+ INDEX(j JB_CMBST_IDX) */ /*+ INDEX(j JB_CMBST_IDX) */ j.*,
p.pname,
mi.MIID1,
mi.MIID2,
mi.MIID3,
mi.VERSIONID1,
mi.VERSIONID2,
mi.PROGID1,
mi.PROGID2,
mi.VERSION,
u.USER_ID OP_NAME,
nvl(j.tech_rptt_id, 0) TECH_REPORT_ID,
case when tsk_type=57 then cast(i.DEV_DATA_FMT as varchar2(100)) else '' end TASK_MODE,
jj.j_compl_by JOB_COMPL_BY
FROM tm_mtask j
join tm_mjob jj
on jj.id = j.j_id
left join tm_mjob_pset p
on p.id = jj.j_sched_indx
left outer join TM_USERS u
on u.id = j.assn_opid
left join (select tsk_id,
TMD_str_agg(distinct miid1) MIID1,
TMD_str_agg(distinct miid2) MIID2,
TMD_str_agg(distinct miid3) MIID3,
TMD_str_agg(distinct versionid1) VERSIONID1,
TMD_str_agg(distinct versionid2) VERSIONID2,
TMD_str_agg(distinct progid1) PROGID1,
TMD_str_agg(distinct progid2) PROGID2,
TMD_str_agg(distinct version) VERSION
from tm_mis m, tm_mtsk_it i
where m.id = i.mi_id
and i.src_dest in (2, 3)
group by tsk_id) mi
on mi.tsk_id = j.id
left join tm_mtsk_it i on i.tsk_id = j.id and i.src_dest = 4 and i.item_idx = 1
where 1=1 AND J_FAILURE_RESOLVED = 0 and assn_opid=342 and j.TSK_STATUS not in (15,18,23,19) order by jj.j_compl_by, j.id , j.id ) a where rownum <= 50) where rnum >= 1 order by rnum
t Information: 1220 : 12|10:05:23.4689|BRoNZX|DANIEL|SearchTask SQL:
select * from (select a.*, rownum rnum from ( select /*+ INDEX(j JB_CMBST_IDX) */ /*+ INDEX(j JB_CMBST_IDX) */ j.*,
p.pname,
mi.MIID1,
mi.MIID2,
mi.MIID3,
mi.VERSIONID1,
mi.VERSIONID2,
mi.PROGID1,
mi.PROGID2,
mi.VERSION,
u.USER_ID OP_NAME,
nvl(j.tech_rptt_id, 0) TECH_REPORT_ID,
case when tsk_type=57 then cast(i.DEV_DATA_FMT as varchar2(100)) else '' end TASK_MODE,
jj.j_compl_by JOB_COMPL_BY
FROM tm_mtask j
join tm_mjob jj
on jj.id = j.j_id
left join tm_mjob_pset p
on p.id = jj.j_sched_indx
left outer join TM_USERS u
on u.id = j.assn_opid
left join (select tsk_id,
TMD_str_agg(distinct miid1) MIID1,
TMD_str_agg(distinct miid2) MIID2,
TMD_str_agg(distinct miid3) MIID3,
TMD_str_agg(distinct versionid1) VERSIONID1,
TMD_str_agg(distinct versionid2) VERSIONID2,
TMD_str_agg(distinct progid1) PROGID1,
TMD_str_agg(distinct progid2) PROGID2,
TMD_str_agg(distinct version) VERSION
from tm_mis m, tm_mtsk_it i
where m.id = i.mi_id
and i.src_dest in (2, 3)
group by tsk_id) mi
on mi.tsk_id = j.id
left join tm_mtsk_it i on i.tsk_id = j.id and i.src_dest = 4 and i.item_idx = 1
where 1=1 AND J_FAILURE_RESOLVED = 0 and assn_opid=342 and j.TSK_STATUS not in (15,18,23,19) order by jj.j_compl_by, j.id , j.id ) a where rownum <= 50) where rnum >= 1 order by rnum
t Verbose: 1220 : 12|10:05:23.6720|Sks91o|DANIEL|imfx v3 API took 0.320s '/api/v3/search/mytasks?_dc=1587719110587'
t Verbose: 1220 : 12|10:05:23.6720|BRoNZX|DANIEL|imfx v3 API took 0.322s '/api/v3/search/mytasks?_dc=1587719111689'
t Transfer: 1220 : 12|10:05:23.8751|jkVr_5|DANIEL|OAuth: /api/user-preferences?_dc=1587719120538
t Transfer: 1220 : 12|10:05:23.8751|jkVr_5|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:05:23.8751|jkVr_5|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:05:23.8751|jkVr_5|DANIEL| user DANIEL.
t Verbose: 1220 : 12|10:05:23.8751|jkVr_5|DANIEL|OAuth. User logged in: DANIEL
t Verbose: 1220 : 12|10:05:23.8751|jkVr_5|DANIEL|StoreUserDataByKeys..
t Transfer: 1220 : 12|10:05:23.8751|jkVr_5|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:05:23.8751|jkVr_5|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:05:23.8751|jkVr_5|DANIEL| user DANIEL.
t Verbose: 1220 : 12|10:05:23.8751|jkVr_5|DANIEL|imfx v3 API took 0.012s '/api/user-preferences?_dc=1587719120538'
t Transfer: 1220 : 12|10:05:34.4376|xNkyU8|DANIEL|OAuth: /api/v3/detailsview/Job/0?lang=en-US&_dc=1587719131119
t Transfer: 1220 : 12|10:05:34.4376|xNkyU8|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:05:34.4376|xNkyU8|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:05:34.4376|xNkyU8|DANIEL| user DANIEL.
t Verbose: 1220 : 12|10:05:34.4376|xNkyU8|DANIEL|OAuth. User logged in: DANIEL
t Transfer: 1220 : 12|10:05:34.4376|WAUMgR|DANIEL|OAuth: /api/v3/task/assess/94979?_dc=1587719131119
t Transfer: 1220 : 12|10:05:34.4376|WAUMgR|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:05:34.4376|WAUMgR|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:05:34.4376|WAUMgR|DANIEL| user DANIEL.
t Verbose: 1220 : 12|10:05:34.4376|WAUMgR|DANIEL|OAuth. User logged in: DANIEL
t Transfer: 1220 : 12|10:05:34.4376|O_OFct|DANIEL|OAuth: /api/lookups/FriendlyNames?_dc=1587719131122
t Transfer: 1220 : 12|10:05:34.4376|O_OFct|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:05:34.4376|O_OFct|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:05:34.4376|O_OFct|DANIEL| user DANIEL.
t Verbose: 1220 : 12|10:05:34.4376|O_OFct|DANIEL|OAuth. User logged in: DANIEL
t Verbose: 1220 : 12|10:05:34.4376|O_OFct|DANIEL|imfx v3 API took 0.000s '/api/lookups/FriendlyNames?_dc=1587719131122'
t Verbose: 1220 : 12|10:05:34.4376|xNkyU8|DANIEL|imfx v3 API took 0.032s '/api/v3/detailsview/Job/0?lang=en-US&_dc=1587719131119'
t Information: 1220 : 12|10:05:34.6407|||TM_MIS. LoadSubtitles for ID: 297806
t Information: 1220 : 12|10:05:34.6407|||TM_MIS. LoadSubtitles for ID: 297806. 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=297702'
t Information: 1220 : 12|10:05:34.6407|||TM_MIS. LoadSubtitles for ID: 297806 found no subtitles.
t Information: 1220 : 12|10:05:34.6407|||TM_MIS. LoadSubtitles for ID: 297942
t Information: 1220 : 12|10:05:34.6407|||TM_MIS. LoadSubtitles for ID: 297942. 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=297702'
t Information: 1220 : 12|10:05:34.6407|||TM_MIS. LoadSubtitles for ID: 297942 found no subtitles.
t Verbose: 1220 : 12|10:05:35.0470|WAUMgR|DANIEL|imfx v3 API took 0.594s '/api/v3/task/assess/94979?_dc=1587719131119'
t Transfer: 1220 : 12|10:05:35.4533|WAUMgR|DANIEL|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\GADN02FREINTL2398HD01101B_Open - Copy.mp4 subfolder
t Transfer: 1220 : 12|10:05:35.4533|WAUMgR|DANIEL| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/GADN02FREINTL2398HD01101B_Open - Copy.mp4
t Transfer: 1220 : 12|10:05:35.4533|WAUMgR|DANIEL|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/GADN02FREINTL2398HD01101B_Open - Copy.mp4
t Transfer: 1220 : 12|10:05:35.4533|WAUMgR|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:05:35.4533|WAUMgR|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:05:35.4533|WAUMgR|DANIEL| user DANIEL.
t Transfer: 1220 : 12|10:05:35.4533|WAUMgR|DANIEL|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\GADN02FREINTL2398HD01101B_Open - Copy.mov subfolder
t Transfer: 1220 : 12|10:05:35.4533|WAUMgR|DANIEL| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/GADN02FREINTL2398HD01101B_Open - Copy.mov
t Transfer: 1220 : 12|10:05:35.4533|WAUMgR|DANIEL|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/GADN02FREINTL2398HD01101B_Open - Copy.mov
t Transfer: 1220 : 12|10:05:35.4533|WAUMgR|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:05:35.4533|WAUMgR|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:05:35.4533|WAUMgR|DANIEL| user DANIEL.
t Transfer: 1220 : 12|10:05:35.4533|B9DbIZ|DANIEL|OAuth: /api/v3/detailsview/MediaDetails/5?lang=en-US&_dc=1587719132209
t Transfer: 1220 : 12|10:05:35.4533|B9DbIZ|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:05:35.4533|B9DbIZ|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:05:35.4533|B9DbIZ|DANIEL| user DANIEL.
t Verbose: 1220 : 12|10:05:35.4533|B9DbIZ|DANIEL|OAuth. User logged in: DANIEL
t Transfer: 1220 : 12|10:05:35.4533|jQSzc9|DANIEL|OAuth: /api/v3/mediavideo/297806?info=smudge,scene,audiovolume&_dc=1587719132209
t Transfer: 1220 : 12|10:05:35.4533|jQSzc9|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:05:35.4533|jQSzc9|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:05:35.4533|jQSzc9|DANIEL| user DANIEL.
t Verbose: 1220 : 12|10:05:35.4533|jQSzc9|DANIEL|OAuth. User logged in: DANIEL
t Verbose: 1220 : 12|10:05:35.4533|B9DbIZ|DANIEL|imfx v3 API took 0.004s '/api/v3/detailsview/MediaDetails/5?lang=en-US&_dc=1587719132209'
t Transfer: 1220 : 12|10:05:35.6564|jQSzc9|DANIEL|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\GADN02FREINTL2398HD01101B_Open - Copy.mp4 subfolder
t Transfer: 1220 : 12|10:05:35.6564|jQSzc9|DANIEL| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/GADN02FREINTL2398HD01101B_Open - Copy.mp4
t Transfer: 1220 : 12|10:05:35.6564|jQSzc9|DANIEL|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/GADN02FREINTL2398HD01101B_Open - Copy.mp4
t Transfer: 1220 : 12|10:05:35.6564|jQSzc9|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:05:35.6564|jQSzc9|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:05:35.6564|jQSzc9|DANIEL| user DANIEL.
t Verbose: 1220 : 12|10:05:35.6564|jQSzc9|DANIEL|imfx v3 API took 0.074s '/api/v3/mediavideo/297806?info=smudge,scene,audiovolume&_dc=1587719132209'
t Transfer: 1220 : 12|10:05:35.6564|9u9JxF|DANIEL|OAuth: /api/v3/layout/default/5?_dc=1587719132326
t Transfer: 1220 : 12|10:05:35.6564|9u9JxF|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:05:35.6564|9u9JxF|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:05:35.6564|9u9JxF|DANIEL| user DANIEL.
t Verbose: 1220 : 12|10:05:35.6564|9u9JxF|DANIEL|OAuth. User logged in: DANIEL
t Information: 1220 : 12|10:05:35.6564|9u9JxF|DANIEL|LoadDefaultDashboard.
t Transfer: 1220 : 12|10:05:35.6564|9u9JxF|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:05:35.6564|9u9JxF|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:05:35.6564|9u9JxF|DANIEL| user DANIEL.
t Verbose: 1220 : 12|10:05:35.6564|9u9JxF|DANIEL|imfx v3 API took 0.037s '/api/v3/layout/default/5?_dc=1587719132326'
t Transfer: 1220 : 12|10:05:35.8595|I63RDf|DANIEL|OAuth: /api/lookups/FriendlyNames?_dc=1587719132425
t Transfer: 1220 : 12|10:05:35.8595|I63RDf|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:05:35.8595|I63RDf|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:05:35.8595|I63RDf|DANIEL| user DANIEL.
t Verbose: 1220 : 12|10:05:35.8595|I63RDf|DANIEL|OAuth. User logged in: DANIEL
t Verbose: 1220 : 12|10:05:35.8595|I63RDf|DANIEL|imfx v3 API took 0.000s '/api/lookups/FriendlyNames?_dc=1587719132425'
t Transfer: 1220 : 12|10:05:35.8595|3Eyf~~|DANIEL|OAuth: /api/lookups/FriendlyNames?_dc=1587719132429
t Transfer: 1220 : 12|10:05:35.8595|3Eyf~~|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:05:35.8595|3Eyf~~|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:05:35.8595|3Eyf~~|DANIEL| user DANIEL.
t Verbose: 1220 : 12|10:05:35.8595|3Eyf~~|DANIEL|OAuth. User logged in: DANIEL
t Verbose: 1220 : 12|10:05:35.8595|3Eyf~~|DANIEL|imfx v3 API took 0.000s '/api/lookups/FriendlyNames?_dc=1587719132429'
t Transfer: 1220 : 12|10:05:35.8595|8V7cfQ|DANIEL|OAuth: /api/lookups/MediaFileTypes?_dc=1587719132472
t Transfer: 1220 : 12|10:05:35.8595|8V7cfQ|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:05:35.8595|8V7cfQ|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:05:35.8595|8V7cfQ|DANIEL| user DANIEL.
t Verbose: 1220 : 12|10:05:35.8595|8V7cfQ|DANIEL|OAuth. User logged in: DANIEL
t Verbose: 1220 : 12|10:05:35.8595|8V7cfQ|DANIEL|imfx v3 API took 0.000s '/api/lookups/MediaFileTypes?_dc=1587719132472'
t Transfer: 1220 : 12|10:05:35.8595|tvtwdH|DANIEL|OAuth: /api/lookups/AspectRatioTypes?_dc=1587719132478
t Transfer: 1220 : 12|10:05:35.8595|tvtwdH|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:05:35.8595|tvtwdH|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:05:35.8595|tvtwdH|DANIEL| user DANIEL.
t Verbose: 1220 : 12|10:05:35.8595|tvtwdH|DANIEL|OAuth. User logged in: DANIEL
t Verbose: 1220 : 12|10:05:35.8595|tvtwdH|DANIEL|imfx v3 API took 0.000s '/api/lookups/AspectRatioTypes?_dc=1587719132478'
t Transfer: 1220 : 12|10:05:35.8595|~ykbo_|DANIEL|OAuth: /api/lookups/AfdTypes?_dc=1587719132485
t Transfer: 1220 : 12|10:05:35.8595|~ykbo_|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:05:35.8595|~ykbo_|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:05:35.8595|~ykbo_|DANIEL| user DANIEL.
t Verbose: 1220 : 12|10:05:35.8595|~ykbo_|DANIEL|OAuth. User logged in: DANIEL
t Verbose: 1220 : 12|10:05:35.8595|~ykbo_|DANIEL|imfx v3 API took 0.000s '/api/lookups/AfdTypes?_dc=1587719132485'
t Transfer: 1220 : 12|10:05:35.8595|~5c8xX|DANIEL|OAuth: /api/lookups/TvStandards?_dc=1587719132492
t Transfer: 1220 : 12|10:05:35.8595|~5c8xX|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:05:35.8595|~5c8xX|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:05:35.8595|~5c8xX|DANIEL| user DANIEL.
t Verbose: 1220 : 12|10:05:35.8595|~5c8xX|DANIEL|OAuth. User logged in: DANIEL
t Verbose: 1220 : 12|10:05:35.8595|~5c8xX|DANIEL|imfx v3 API took 0.000s '/api/lookups/TvStandards?_dc=1587719132492'
t Transfer: 1220 : 12|10:05:35.8595|plxZZ4|DANIEL|OAuth: /api/lookups/AgeCertification?_dc=1587719132499
t Transfer: 1220 : 12|10:05:35.8595|plxZZ4|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:05:35.8595|plxZZ4|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:05:35.8595|plxZZ4|DANIEL| user DANIEL.
t Verbose: 1220 : 12|10:05:35.8595|plxZZ4|DANIEL|OAuth. User logged in: DANIEL
t Verbose: 1220 : 12|10:05:35.8595|plxZZ4|DANIEL|imfx v3 API took 0.000s '/api/lookups/AgeCertification?_dc=1587719132499'
t Transfer: 1220 : 12|10:05:35.8595|a3RSr8|DANIEL|OAuth: /api/lookups/AssessmentSubsTypes?_dc=1587719132508
t Transfer: 1220 : 12|10:05:35.8595|a3RSr8|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:05:35.8595|a3RSr8|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:05:35.8595|a3RSr8|DANIEL| user DANIEL.
t Verbose: 1220 : 12|10:05:35.8595|a3RSr8|DANIEL|OAuth. User logged in: DANIEL
t Verbose: 1220 : 12|10:05:35.8595|a3RSr8|DANIEL|imfx v3 API took 0.001s '/api/lookups/AssessmentSubsTypes?_dc=1587719132508'
t Transfer: 1220 : 12|10:05:35.8595|1YEjR2|DANIEL|OAuth: /api/lookups/UsageTypes?_dc=1587719132515
t Transfer: 1220 : 12|10:05:35.8595|1YEjR2|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:05:35.8595|1YEjR2|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:05:35.8595|1YEjR2|DANIEL| user DANIEL.
t Verbose: 1220 : 12|10:05:35.8595|1YEjR2|DANIEL|OAuth. User logged in: DANIEL
t Verbose: 1220 : 12|10:05:35.8595|1YEjR2|DANIEL|imfx v3 API took 0.000s '/api/lookups/UsageTypes?_dc=1587719132515'
t Transfer: 1220 : 12|10:05:35.8595|NNUnSF|DANIEL|OAuth: /api/lookups/ItemTypes?_dc=1587719132525
t Transfer: 1220 : 12|10:05:35.8595|NNUnSF|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:05:35.8595|NNUnSF|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:05:35.8595|NNUnSF|DANIEL| user DANIEL.
t Verbose: 1220 : 12|10:05:35.8595|NNUnSF|DANIEL|OAuth. User logged in: DANIEL
t Verbose: 1220 : 12|10:05:35.8595|NNUnSF|DANIEL|imfx v3 API took 0.000s '/api/lookups/ItemTypes?_dc=1587719132525'
t Transfer: 1220 : 12|10:05:35.8595|vTQPgu|DANIEL|OAuth: /api/lookups/Languages?_dc=1587719132533
t Transfer: 1220 : 12|10:05:35.8595|vTQPgu|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:05:35.8595|vTQPgu|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:05:35.8595|vTQPgu|DANIEL| user DANIEL.
t Verbose: 1220 : 12|10:05:35.8595|vTQPgu|DANIEL|OAuth. User logged in: DANIEL
t Verbose: 1220 : 12|10:05:35.8595|vTQPgu|DANIEL|imfx v3 API took 0.000s '/api/lookups/Languages?_dc=1587719132533'
t Information: 1220 : 12|10:05:36.0782|N0Yaov|DANIEL|V3Api.GetMediaTagging
t Transfer: 1220 : 12|10:05:36.0782|UKNoL_|DANIEL|OAuth: /api/v3/media-captions/297806?_dc=1587719132706
t Transfer: 1220 : 12|10:05:36.0782|UKNoL_|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:05:36.0782|UKNoL_|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:05:36.0782|UKNoL_|DANIEL| user DANIEL.
t Verbose: 1220 : 12|10:05:36.0782|UKNoL_|DANIEL|OAuth. User logged in: DANIEL
t Transfer: 1220 : 12|10:05:36.0782|rY7c_H|DANIEL|OAuth: /api/v3/ai-tags/297806?_dc=1587719132716
t Transfer: 1220 : 12|10:05:36.0782|rY7c_H|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:05:36.0782|rY7c_H|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:05:36.0782|rY7c_H|DANIEL| user DANIEL.
t Verbose: 1220 : 12|10:05:36.0782|rY7c_H|DANIEL|OAuth. User logged in: DANIEL
t Information: 1220 : 12|10:05:36.0782|rY7c_H|DANIEL|V3Api.GetMediaAiTags
t Verbose: 1220 : 12|10:05:36.0782|UKNoL_|DANIEL|imfx v3 API took 0.014s '/api/v3/media-captions/297806?_dc=1587719132706'
t Verbose: 1220 : 12|10:05:36.0782|rY7c_H|DANIEL|imfx v3 API took 0.020s '/api/v3/ai-tags/297806?_dc=1587719132716'
t Transfer: 1220 : 12|10:05:36.4845|LGe_la|DANIEL|OAuth: /api/user-group-preferences?globals=htmlplayerhotkeys,audioOnFrameForward&_dc=1587719133120
t Transfer: 1220 : 12|10:05:36.4845|LGe_la|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:05:36.4845|LGe_la|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:05:36.4845|LGe_la|DANIEL| user DANIEL.
t Verbose: 1220 : 12|10:05:36.4845|LGe_la|DANIEL|OAuth. User logged in: DANIEL
t Transfer: 1220 : 12|10:05:36.4845|LGe_la|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:05:36.4845|LGe_la|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:05:36.4845|LGe_la|DANIEL| user DANIEL.
t Verbose: 1220 : 12|10:05:36.4845|LGe_la|DANIEL|imfx v3 API took 0.008s '/api/user-group-preferences?globals=htmlplayerhotkeys,audioOnFrameForward&_dc=1587719133120'
t Transfer: 1220 : 12|10:10:19.2501|bRjJG6|DANIEL|OAuth: /api/view/searchinfo/TitleSearch?_dc=1587719415820
t Transfer: 1220 : 12|10:10:19.2501|bRjJG6|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:10:19.2501|bRjJG6|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:10:19.2501|bRjJG6|DANIEL| user DANIEL.
t Verbose: 1220 : 12|10:10:19.2501|bRjJG6|DANIEL|OAuth. User logged in: DANIEL
t Information: 1220 : 12|10:10:19.2501|bRjJG6|DANIEL|GetAdvSearchColumns. search type TitleSearch grid .
t Verbose: 1220 : 12|10:10:19.2501|bRjJG6|DANIEL|imfx v3 API took 0.000s '/api/view/searchinfo/TitleSearch?_dc=1587719415820'
t Transfer: 1220 : 12|10:10:19.2501|g_2uwu|DANIEL|OAuth: /api/user-preferences?keys=adv.recent.searches.titles&_dc=1587719415824
t Transfer: 1220 : 12|10:10:19.2501|g_2uwu|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:10:19.2501|g_2uwu|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:10:19.2501|g_2uwu|DANIEL| user DANIEL.
t Verbose: 1220 : 12|10:10:19.2501|g_2uwu|DANIEL|OAuth. User logged in: DANIEL
t Information: 1220 : 12|10:10:19.2501|g_2uwu|DANIEL|GetUserDataByKeys: adv.recent.searches.titles
t Transfer: 1220 : 12|10:10:19.2501|g_2uwu|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:10:19.2501|g_2uwu|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:10:19.2501|g_2uwu|DANIEL| user DANIEL.
t Transfer: 1220 : 12|10:10:19.2501|8Jt93Q|DANIEL|OAuth: /api/view/info/TitleTree?lang=en-US&_dc=1587719415844
t Transfer: 1220 : 12|10:10:19.2501|8Jt93Q|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:10:19.2501|8Jt93Q|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:10:19.2501|8Jt93Q|DANIEL| user DANIEL.
t Verbose: 1220 : 12|10:10:19.2501|8Jt93Q|DANIEL|OAuth. User logged in: DANIEL
t Information: 1220 : 12|10:10:19.2501|8Jt93Q|DANIEL|GetGridViewBuilder. builder type TitleTree.
t Transfer: 1220 : 12|10:10:19.2501|8Jt93Q|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:10:19.2501|8Jt93Q|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:10:19.2501|8Jt93Q|DANIEL| user DANIEL.
t Transfer: 1220 : 12|10:10:19.2501|FnFyYm|DANIEL|OAuth: /api/view/searches/TitleSearch?_dc=1587719415859
t Transfer: 1220 : 12|10:10:19.2501|FnFyYm|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:10:19.2501|FnFyYm|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:10:19.2501|FnFyYm|DANIEL| user DANIEL.
t Verbose: 1220 : 12|10:10:19.2501|FnFyYm|DANIEL|OAuth. User logged in: DANIEL
t Information: 1220 : 12|10:10:19.2501|FnFyYm|DANIEL|GetSavedSearchNames. search type TitleSearch.
t Transfer: 1220 : 12|10:10:19.2501|FnFyYm|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:10:19.2501|FnFyYm|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:10:19.2501|FnFyYm|DANIEL| user DANIEL.
t Verbose: 1220 : 12|10:10:19.4689|g_2uwu|DANIEL|imfx v3 API took 0.095s '/api/user-preferences?keys=adv.recent.searches.titles&_dc=1587719415824'
t Transfer: 1220 : 12|10:10:19.4689|cngH98|DANIEL|OAuth: /api/view/info/VersionGrid?lang=en-US&_dc=1587719415868
t Transfer: 1220 : 12|10:10:19.4689|cngH98|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:10:19.4689|cngH98|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:10:19.4689|cngH98|DANIEL| user DANIEL.
t Verbose: 1220 : 12|10:10:19.4689|cngH98|DANIEL|OAuth. User logged in: DANIEL
t Information: 1220 : 12|10:10:19.4689|cngH98|DANIEL|GetGridViewBuilder. builder type VersionGrid.
t Transfer: 1220 : 12|10:10:19.4689|cngH98|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:10:19.4689|cngH98|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:10:19.4689|cngH98|DANIEL| user DANIEL.
t Information: 1220 : 12|10:10:19.4689|8Jt93Q|DANIEL|UserGridView. LoadView. ID 856, Name Default.
t Transfer: 1220 : 12|10:10:19.4689|8Jt93Q|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:10:19.4689|8Jt93Q|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:10:19.4689|8Jt93Q|DANIEL| user DANIEL.
t Verbose: 1220 : 12|10:10:19.4689|FnFyYm|DANIEL|imfx v3 API took 0.163s '/api/view/searches/TitleSearch?_dc=1587719415859'
t Transfer: 1220 : 12|10:10:19.4689|CLTH08|DANIEL|OAuth: /api/view/info/MediaGrid?lang=en-US&_dc=1587719415945
t Transfer: 1220 : 12|10:10:19.4689|CLTH08|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:10:19.4689|CLTH08|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:10:19.4689|CLTH08|DANIEL| user DANIEL.
t Verbose: 1220 : 12|10:10:19.4689|CLTH08|DANIEL|OAuth. User logged in: DANIEL
t Information: 1220 : 12|10:10:19.4689|CLTH08|DANIEL|GetGridViewBuilder. builder type MediaGrid.
t Transfer: 1220 : 12|10:10:19.4689|CLTH08|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:10:19.4689|CLTH08|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:10:19.4689|CLTH08|DANIEL| user DANIEL.
t Information: 1220 : 12|10:10:19.4689|CLTH08|DANIEL|UserGridView. LoadView. ID 760, Name Default.
t Transfer: 1220 : 12|10:10:19.4689|CLTH08|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:10:19.4689|CLTH08|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:10:19.4689|CLTH08|DANIEL| user DANIEL.
t Information: 1220 : 12|10:10:19.4689|cngH98|DANIEL|UserGridView. LoadView. ID 899, Name Default.
t Transfer: 1220 : 12|10:10:19.4689|cngH98|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:10:19.4689|cngH98|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:10:19.4689|cngH98|DANIEL| user DANIEL.
t Transfer: 1220 : 12|10:10:19.4689|CLTH08|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:10:19.4689|CLTH08|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:10:19.4689|CLTH08|DANIEL| user DANIEL.
t Transfer: 1220 : 12|10:10:19.4689|8Jt93Q|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:10:19.4689|8Jt93Q|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:10:19.4689|8Jt93Q|DANIEL| user DANIEL.
t Transfer: 1220 : 12|10:10:19.4689|cngH98|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:10:19.4689|cngH98|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:10:19.4689|cngH98|DANIEL| user DANIEL.
t Verbose: 1220 : 12|10:10:19.4689|CLTH08|DANIEL|imfx v3 API took 0.074s '/api/view/info/MediaGrid?lang=en-US&_dc=1587719415945'
t Verbose: 1220 : 12|10:10:19.4689|cngH98|DANIEL|imfx v3 API took 0.149s '/api/view/info/VersionGrid?lang=en-US&_dc=1587719415868'
t Verbose: 1220 : 12|10:10:19.4689|8Jt93Q|DANIEL|imfx v3 API took 0.244s '/api/view/info/TitleTree?lang=en-US&_dc=1587719415844'
t Transfer: 1220 : 12|10:10:19.6876|Y10ZuC|DANIEL|OAuth: /api/settings/user/uploadSettings?_dc=1587719416400
t Transfer: 1220 : 12|10:10:19.6876|Y10ZuC|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:10:19.6876|Y10ZuC|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:10:19.6876|Y10ZuC|DANIEL| user DANIEL.
t Verbose: 1220 : 12|10:10:19.6876|Y10ZuC|DANIEL|OAuth. User logged in: DANIEL
t Transfer: 1220 : 12|10:10:19.6876|Y10ZuC|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:10:19.6876|Y10ZuC|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:10:19.6876|Y10ZuC|DANIEL| user DANIEL.
t Verbose: 1220 : 12|10:10:19.6876|Y10ZuC|DANIEL|imfx v3 API took 0.012s '/api/settings/user/uploadSettings?_dc=1587719416400'
t Transfer: 1220 : 12|10:10:19.8907|ZA6PZM|DANIEL|OAuth: /api/settings/user/uploadSettings?_dc=1587719416474
t Transfer: 1220 : 12|10:10:19.8907|ZA6PZM|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:10:19.8907|ZA6PZM|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:10:19.8907|ZA6PZM|DANIEL| user DANIEL.
t Verbose: 1220 : 12|10:10:19.8907|ZA6PZM|DANIEL|OAuth. User logged in: DANIEL
t Transfer: 1220 : 12|10:10:19.8907|ZA6PZM|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:10:19.8907|ZA6PZM|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:10:19.8907|ZA6PZM|DANIEL| user DANIEL.
t Verbose: 1220 : 12|10:10:19.8907|ZA6PZM|DANIEL|imfx v3 API took 0.003s '/api/settings/user/uploadSettings?_dc=1587719416474'
t Transfer: 1220 : 12|10:10:21.7189|DX9yHI|DANIEL|OAuth: /api/v3/search-suggestion/?_dc=1587719418280
t Transfer: 1220 : 12|10:10:21.7189|DX9yHI|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:10:21.7189|DX9yHI|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:10:21.7189|DX9yHI|DANIEL| user DANIEL.
t Verbose: 1220 : 12|10:10:21.7189|DX9yHI|DANIEL|OAuth. User logged in: DANIEL
t Transfer: 1220 : 12|10:10:21.7189|DX9yHI|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:10:21.7189|DX9yHI|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:10:21.7189|DX9yHI|DANIEL| user DANIEL.
t Transfer: 1220 : 12|10:10:21.7189|beuyhU|DANIEL|OAuth: /api/v3/search-suggestion/?_dc=1587719418358
t Transfer: 1220 : 12|10:10:21.7189|beuyhU|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:10:21.7189|beuyhU|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:10:21.7189|beuyhU|DANIEL| user DANIEL.
t Verbose: 1220 : 12|10:10:21.7189|beuyhU|DANIEL|OAuth. User logged in: DANIEL
t Transfer: 1220 : 12|10:10:21.7189|beuyhU|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:10:21.7189|beuyhU|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:10:21.7189|beuyhU|DANIEL| user DANIEL.
t Verbose: 1220 : 12|10:10:22.1251|beuyhU|DANIEL|imfx v3 API took 0.372s '/api/v3/search-suggestion/?_dc=1587719418358'
t Verbose: 1220 : 12|10:10:22.1251|DX9yHI|DANIEL|imfx v3 API took 0.433s '/api/v3/search-suggestion/?_dc=1587719418280'
t Transfer: 1220 : 12|10:10:23.5470|RQRuha|DANIEL|OAuth: /api/v3/search-suggestion/?_dc=1587719420282
t Transfer: 1220 : 12|10:10:23.5470|RQRuha|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:10:23.5470|RQRuha|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:10:23.5470|RQRuha|DANIEL| user DANIEL.
t Verbose: 1220 : 12|10:10:23.5470|RQRuha|DANIEL|OAuth. User logged in: DANIEL
t Transfer: 1220 : 12|10:10:23.5470|RQRuha|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:10:23.5470|RQRuha|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:10:23.5470|RQRuha|DANIEL| user DANIEL.
t Verbose: 1220 : 12|10:10:23.7501|RQRuha|DANIEL|imfx v3 API took 0.047s '/api/v3/search-suggestion/?_dc=1587719420282'
t Transfer: 1220 : 12|10:10:23.7501|SrIlb1|DANIEL|OAuth: /api/v3/search-suggestion/?_dc=1587719420448
t Transfer: 1220 : 12|10:10:23.7501|SrIlb1|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:10:23.7501|SrIlb1|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:10:23.7501|SrIlb1|DANIEL| user DANIEL.
t Verbose: 1220 : 12|10:10:23.7501|SrIlb1|DANIEL|OAuth. User logged in: DANIEL
t Transfer: 1220 : 12|10:10:23.7501|SrIlb1|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:10:23.7501|SrIlb1|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:10:23.7501|SrIlb1|DANIEL| user DANIEL.
t Verbose: 1220 : 12|10:10:23.7501|SrIlb1|DANIEL|imfx v3 API took 0.017s '/api/v3/search-suggestion/?_dc=1587719420448'
t Transfer: 1220 : 12|10:10:23.9532|Qhu3QO|DANIEL|OAuth: /api/v3/search-suggestion/?_dc=1587719420531
t Transfer: 1220 : 12|10:10:23.9532|Qhu3QO|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:10:23.9532|Qhu3QO|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:10:23.9532|Qhu3QO|DANIEL| user DANIEL.
t Verbose: 1220 : 12|10:10:23.9532|Qhu3QO|DANIEL|OAuth. User logged in: DANIEL
t Transfer: 1220 : 12|10:10:23.9532|Qhu3QO|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:10:23.9532|Qhu3QO|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:10:23.9532|Qhu3QO|DANIEL| user DANIEL.
t Verbose: 1220 : 12|10:10:23.9532|Qhu3QO|DANIEL|imfx v3 API took 0.006s '/api/v3/search-suggestion/?_dc=1587719420531'
t Transfer: 1220 : 12|10:10:24.1564|fDEL4c|DANIEL|OAuth: /api/v3/search-suggestion/?_dc=1587719420786
t Transfer: 1220 : 12|10:10:24.1564|fDEL4c|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:10:24.1564|fDEL4c|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:10:24.1564|fDEL4c|DANIEL| user DANIEL.
t Verbose: 1220 : 12|10:10:24.1564|fDEL4c|DANIEL|OAuth. User logged in: DANIEL
t Transfer: 1220 : 12|10:10:24.1564|fDEL4c|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:10:24.1564|fDEL4c|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:10:24.1564|fDEL4c|DANIEL| user DANIEL.
t Verbose: 1220 : 12|10:10:24.1564|fDEL4c|DANIEL|imfx v3 API took 0.015s '/api/v3/search-suggestion/?_dc=1587719420786'
t Transfer: 1220 : 12|10:10:24.7657|zF4AgN|DANIEL|OAuth: /api/v3/search-suggestion/?_dc=1587719421328
t Transfer: 1220 : 12|10:10:24.7657|zF4AgN|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:10:24.7657|zF4AgN|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:10:24.7657|zF4AgN|DANIEL| user DANIEL.
t Verbose: 1220 : 12|10:10:24.7657|zF4AgN|DANIEL|OAuth. User logged in: DANIEL
t Transfer: 1220 : 12|10:10:24.7657|zF4AgN|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:10:24.7657|zF4AgN|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:10:24.7657|zF4AgN|DANIEL| user DANIEL.
t Verbose: 1220 : 12|10:10:24.7657|zF4AgN|DANIEL|imfx v3 API took 0.020s '/api/v3/search-suggestion/?_dc=1587719421328'
t Transfer: 1220 : 12|10:10:24.7657|F_LY7U|DANIEL|OAuth: /api/v3/search-suggestion/?_dc=1587719421417
t Transfer: 1220 : 12|10:10:24.7657|F_LY7U|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:10:24.7657|F_LY7U|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:10:24.7657|F_LY7U|DANIEL| user DANIEL.
t Verbose: 1220 : 12|10:10:24.7657|F_LY7U|DANIEL|OAuth. User logged in: DANIEL
t Transfer: 1220 : 12|10:10:24.7657|F_LY7U|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:10:24.7657|F_LY7U|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:10:24.7657|F_LY7U|DANIEL| user DANIEL.
t Verbose: 1220 : 12|10:10:24.7657|F_LY7U|DANIEL|imfx v3 API took 0.012s '/api/v3/search-suggestion/?_dc=1587719421417'
t Transfer: 1220 : 12|10:10:24.9689|leTWxh|DANIEL|OAuth: /api/v3/search-suggestion/?_dc=1587719421600
t Transfer: 1220 : 12|10:10:24.9689|leTWxh|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:10:24.9689|leTWxh|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:10:24.9689|leTWxh|DANIEL| user DANIEL.
t Verbose: 1220 : 12|10:10:24.9689|leTWxh|DANIEL|OAuth. User logged in: DANIEL
t Transfer: 1220 : 12|10:10:24.9689|leTWxh|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:10:24.9689|leTWxh|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:10:24.9689|leTWxh|DANIEL| user DANIEL.
t Verbose: 1220 : 12|10:10:24.9689|leTWxh|DANIEL|imfx v3 API took 0.006s '/api/v3/search-suggestion/?_dc=1587719421600'
t Transfer: 1220 : 12|10:10:25.1720|3Sv8Y_|DANIEL|OAuth: /api/v3/search-suggestion/?_dc=1587719421784
t Transfer: 1220 : 12|10:10:25.1720|3Sv8Y_|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:10:25.1720|3Sv8Y_|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:10:25.1720|3Sv8Y_|DANIEL| user DANIEL.
t Verbose: 1220 : 12|10:10:25.1720|3Sv8Y_|DANIEL|OAuth. User logged in: DANIEL
t Transfer: 1220 : 12|10:10:25.1720|3Sv8Y_|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:10:25.1720|3Sv8Y_|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:10:25.1720|3Sv8Y_|DANIEL| user DANIEL.
t Verbose: 1220 : 12|10:10:25.1720|3Sv8Y_|DANIEL|imfx v3 API took 0.007s '/api/v3/search-suggestion/?_dc=1587719421784'
t Transfer: 1220 : 12|10:10:25.3751|PYFXIV|DANIEL|OAuth: /api/v3/search/title?_dc=1587719422000
t Transfer: 1220 : 12|10:10:25.3751|PYFXIV|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:10:25.3751|PYFXIV|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:10:25.3751|PYFXIV|DANIEL| user DANIEL.
t Verbose: 1220 : 12|10:10:25.3751|PYFXIV|DANIEL|OAuth. User logged in: DANIEL
t Information: 1220 : 12|10:10:25.3751|PYFXIV|DANIEL|V3Api.SearchTitles
t Information: 1220 : 12|10:10:25.3751|PYFXIV|DANIEL|V3Api.SearchGeneric
t Transfer: 1220 : 12|10:10:25.3751|PYFXIV|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:10:25.3751|PYFXIV|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:10:25.3751|PYFXIV|DANIEL| user DANIEL.
t Transfer: 1220 : 12|10:10:25.3751|PYFXIV|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:10:25.3751|PYFXIV|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:10:25.3751|PYFXIV|DANIEL| user DANIEL.
t Information: 1220 : 12|10:10:25.3751|PYFXIV|DANIEL|SearchTitle SQL:
with
v as (
SELECT
abs.*
,decode(ITEM_TYPE,
1010,SER_ABS_ID,
1020,CASE WHEN SER_ABS2_ID > 0 THEN SER_ABS2_ID ELSE SER_ABS_ID END
) xparent_id
FROM TMDDBA.TM_PG_ABS abs
WHERE abs.id in (
select a.id
FROM TMDDBA.TM_PG_ABS a
where ABS_DELETED = 0 AND (CONTAINS(CTX_TEXT_COL,'mr robot') > 0 OR CONTAINS(CTX_IDS_COL,'mr robot') > 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|10:10:25.5782|PYFXIV|DANIEL|imfx v3 API took 0.185s '/api/v3/search/title?_dc=1587719422000'
t Transfer: 1220 : 12|10:10:25.5782|XIBvX2|DANIEL|OAuth: /api/user-preferences?_dc=1587719422311
t Transfer: 1220 : 12|10:10:25.5782|XIBvX2|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:10:25.5782|XIBvX2|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:10:25.5782|XIBvX2|DANIEL| user DANIEL.
t Verbose: 1220 : 12|10:10:25.5782|XIBvX2|DANIEL|OAuth. User logged in: DANIEL
t Transfer: 1220 : 12|10:10:25.5782|F6MowS|DANIEL|OAuth: /api/v3/title/298904/versions?_dc=1587719422308
t Transfer: 1220 : 12|10:10:25.5782|F6MowS|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:10:25.5782|F6MowS|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:10:25.5782|F6MowS|DANIEL| user DANIEL.
t Verbose: 1220 : 12|10:10:25.5782|F6MowS|DANIEL|OAuth. User logged in: DANIEL
t Verbose: 1220 : 12|10:10:25.5782|XIBvX2|DANIEL|StoreUserDataByKeys..
t Transfer: 1220 : 12|10:10:25.5782|XIBvX2|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:10:25.5782|XIBvX2|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:10:25.5782|XIBvX2|DANIEL| user DANIEL.
t Information: 1220 : 12|10:10:25.5782|F6MowS|DANIEL|V3Api.SearchGeneric
t Verbose: 1220 : 12|10:10:25.5782|XIBvX2|DANIEL|imfx v3 API took 0.010s '/api/user-preferences?_dc=1587719422311'
t Transfer: 1220 : 12|10:10:25.5782|F6MowS|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:10:25.5782|F6MowS|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:10:25.5782|F6MowS|DANIEL| user DANIEL.
t Transfer: 1220 : 12|10:10:25.5782|F6MowS|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:10:25.5782|F6MowS|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:10:25.5782|F6MowS|DANIEL| user DANIEL.
t Information: 1220 : 12|10:10:25.7814|F6MowS|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
where item_type>0 and rl_deleted=0 and m.PGM_ABS_ID=298904
order by m.title,m.id) a where rownum <= 9999) r where rnum >=1 order by rnum
t Information: 1220 : 12|10:10:25.7814|F6MowS|DANIEL|Running version search. User: 342 Simple Search:
Running Oracle search.
Running Oracle search for COUNT
Oracle count completed in: 7ms. Returned lines: 0
t Verbose: 1220 : 12|10:10:25.7814|F6MowS|DANIEL|imfx v3 API took 0.028s '/api/v3/title/298904/versions?_dc=1587719422308'
t Transfer: 1220 : 12|10:10:37.7657|gtaRIl|DANIEL|OAuth: /api/v3/title/298905/versions?_dc=1587719434318
t Transfer: 1220 : 12|10:10:37.7657|gtaRIl|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:10:37.7657|gtaRIl|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:10:37.7657|gtaRIl|DANIEL| user DANIEL.
t Verbose: 1220 : 12|10:10:37.7657|gtaRIl|DANIEL|OAuth. User logged in: DANIEL
t Information: 1220 : 12|10:10:37.7657|gtaRIl|DANIEL|V3Api.SearchGeneric
t Transfer: 1220 : 12|10:10:37.7657|gtaRIl|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:10:37.7657|gtaRIl|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:10:37.7657|gtaRIl|DANIEL| user DANIEL.
t Transfer: 1220 : 12|10:10:37.7657|gtaRIl|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:10:37.7657|gtaRIl|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:10:37.7657|gtaRIl|DANIEL| user DANIEL.
t Information: 1220 : 12|10:10:37.7657|gtaRIl|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
where item_type>0 and rl_deleted=0 and m.PGM_ABS_ID=298905
order by m.title,m.id) a where rownum <= 9999) r where rnum >=1 order by rnum
t Information: 1220 : 12|10:10:37.7657|gtaRIl|DANIEL|Running version search. User: 342 Simple Search:
Running Oracle search.
Running Oracle search for COUNT
Oracle count completed in: 6ms. Returned lines: 2
Oracle version search timing: 68ms.
SQL run:
select * from (select a.*, rownum rnum from ( select m.*, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID, BUILD_PGRL_FULLTITLE(item_type, title, ser_name, ser_title) FULLTITLE from tmddba.tm_pg_rl m
left outer join (select text_id, text_data_path, text_data_filename, text_ref_object from tmddba.tm_text) t on t.text_id = m.primary_thumb_id
where item_type>0 and rl_deleted=0 and m.PGM_ABS_ID=298905
order by m.title,m.id) a where rownum <= 9999) r where rnum >=1 order by rnum
t Verbose: 1220 : 12|10:10:37.7657|gtaRIl|DANIEL|imfx v3 API took 0.081s '/api/v3/title/298905/versions?_dc=1587719434318'
t Transfer: 1220 : 12|10:10:37.7657|vAGXHc|DANIEL|OAuth: /api/v3/version/298906/media?_dc=1587719434514
t Transfer: 1220 : 12|10:10:37.7657|vAGXHc|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:10:37.7657|vAGXHc|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:10:37.7657|vAGXHc|DANIEL| user DANIEL.
t Verbose: 1220 : 12|10:10:37.7657|vAGXHc|DANIEL|OAuth. User logged in: DANIEL
t Information: 1220 : 12|10:10:37.7657|vAGXHc|DANIEL|V3Api.SearchGeneric
t Transfer: 1220 : 12|10:10:37.9689|vAGXHc|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:10:37.9689|vAGXHc|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:10:37.9689|vAGXHc|DANIEL| user DANIEL.
t Information: 1220 : 12|10:10:37.9689|vAGXHc|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
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: 298906
t Information: 1220 : 12|10:10:37.9689|vAGXHc|DANIEL| timing: 00:00:00.0176721
t Verbose: 1220 : 12|10:10:37.9689|vAGXHc|DANIEL|imfx v3 API took 0.044s '/api/v3/version/298906/media?_dc=1587719434514'
t Transfer: 1220 : 12|10:10:37.9689|vAGXHc|DANIEL|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\MRR28-1.mov subfolder
t Transfer: 1220 : 12|10:10:37.9689|vAGXHc|DANIEL| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/MRR28-1.mov
t Transfer: 1220 : 12|10:10:37.9689|vAGXHc|DANIEL|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/MRR28-1.mov
t Transfer: 1220 : 12|10:10:37.9689|vAGXHc|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:10:37.9689|vAGXHc|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:10:37.9689|vAGXHc|DANIEL| user DANIEL.
t Transfer: 1220 : 12|10:10:37.9689|vAGXHc|DANIEL|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\N0001876.mpd subfolder
t Transfer: 1220 : 12|10:10:37.9689|vAGXHc|DANIEL| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/N0001876.mpd
t Transfer: 1220 : 12|10:10:37.9689|vAGXHc|DANIEL|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/N0001876.mpd
t Transfer: 1220 : 12|10:10:37.9689|vAGXHc|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:10:37.9689|vAGXHc|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:10:37.9689|vAGXHc|DANIEL| user DANIEL.
t Transfer: 1220 : 12|10:10:37.9689|vAGXHc|DANIEL|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\N0001895.mov subfolder
t Transfer: 1220 : 12|10:10:37.9689|vAGXHc|DANIEL| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/N0001895.mov
t Transfer: 1220 : 12|10:10:37.9689|vAGXHc|DANIEL|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/N0001895.mov
t Transfer: 1220 : 12|10:10:37.9689|vAGXHc|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:10:37.9689|vAGXHc|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:10:37.9689|vAGXHc|DANIEL| user DANIEL.
t Transfer: 1220 : 12|10:10:48.5470|iqiVl8|DANIEL|OAuth: /api/v3/version/299086/media?_dc=1587719445280
t Transfer: 1220 : 12|10:10:48.5470|iqiVl8|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:10:48.5470|iqiVl8|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:10:48.5470|iqiVl8|DANIEL| user DANIEL.
t Verbose: 1220 : 12|10:10:48.5470|iqiVl8|DANIEL|OAuth. User logged in: DANIEL
t Information: 1220 : 12|10:10:48.5470|iqiVl8|DANIEL|V3Api.SearchGeneric
t Transfer: 1220 : 12|10:10:48.5470|iqiVl8|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:10:48.5470|iqiVl8|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:10:48.5470|iqiVl8|DANIEL| user DANIEL.
t Information: 1220 : 12|10:10:48.5470|iqiVl8|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
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: 299086
t Information: 1220 : 12|10:10:48.7501|iqiVl8|DANIEL| timing: 00:00:00.0129847
t Verbose: 1220 : 12|10:10:48.7501|iqiVl8|DANIEL|imfx v3 API took 0.013s '/api/v3/version/299086/media?_dc=1587719445280'
t Transfer: 1220 : 12|10:10:48.7501|iqiVl8|DANIEL|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\N0001888.ts subfolder
t Transfer: 1220 : 12|10:10:48.7501|iqiVl8|DANIEL| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/N0001888.ts
t Transfer: 1220 : 12|10:10:48.7501|iqiVl8|DANIEL|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/N0001888.ts
t Transfer: 1220 : 12|10:10:48.7501|iqiVl8|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:10:48.7501|iqiVl8|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:10:48.7501|iqiVl8|DANIEL| user DANIEL.
t Transfer: 1220 : 12|10:10:48.7501|iqiVl8|DANIEL|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\N0001889.ts subfolder
t Transfer: 1220 : 12|10:10:48.7501|iqiVl8|DANIEL| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/N0001889.ts
t Transfer: 1220 : 12|10:10:48.7501|iqiVl8|DANIEL|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/N0001889.ts
t Transfer: 1220 : 12|10:10:48.7501|iqiVl8|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:10:48.7501|iqiVl8|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:10:48.7501|iqiVl8|DANIEL| user DANIEL.
t Transfer: 1220 : 12|10:10:48.7501|iqiVl8|DANIEL|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\N0001890.ts subfolder
t Transfer: 1220 : 12|10:10:48.7501|iqiVl8|DANIEL| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/N0001890.ts
t Transfer: 1220 : 12|10:10:48.7501|iqiVl8|DANIEL|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/N0001890.ts
t Transfer: 1220 : 12|10:10:48.7501|iqiVl8|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:10:48.7501|iqiVl8|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:10:48.7501|iqiVl8|DANIEL| user DANIEL.
t Transfer: 1220 : 12|10:10:49.5626|8iHqI0|DANIEL|OAuth: /api/v3/version/298906/media?_dc=1587719446303
t Transfer: 1220 : 12|10:10:49.5626|8iHqI0|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:10:49.5626|8iHqI0|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:10:49.5626|8iHqI0|DANIEL| user DANIEL.
t Verbose: 1220 : 12|10:10:49.5626|8iHqI0|DANIEL|OAuth. User logged in: DANIEL
t Information: 1220 : 12|10:10:49.5626|8iHqI0|DANIEL|V3Api.SearchGeneric
t Transfer: 1220 : 12|10:10:49.5626|8iHqI0|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:10:49.5626|8iHqI0|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:10:49.5626|8iHqI0|DANIEL| user DANIEL.
t Information: 1220 : 12|10:10:49.5626|8iHqI0|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
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: 298906
t Information: 1220 : 12|10:10:49.7657|8iHqI0|DANIEL| timing: 00:00:00.0139052
t Verbose: 1220 : 12|10:10:49.7657|8iHqI0|DANIEL|imfx v3 API took 0.014s '/api/v3/version/298906/media?_dc=1587719446303'
t Transfer: 1220 : 12|10:10:49.7657|8iHqI0|DANIEL|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\MRR28-1.mov subfolder
t Transfer: 1220 : 12|10:10:49.7657|8iHqI0|DANIEL| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/MRR28-1.mov
t Transfer: 1220 : 12|10:10:49.7657|8iHqI0|DANIEL|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/MRR28-1.mov
t Transfer: 1220 : 12|10:10:49.7657|8iHqI0|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:10:49.7657|8iHqI0|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:10:49.7657|8iHqI0|DANIEL| user DANIEL.
t Transfer: 1220 : 12|10:10:49.7657|8iHqI0|DANIEL|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\N0001876.mpd subfolder
t Transfer: 1220 : 12|10:10:49.7657|8iHqI0|DANIEL| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/N0001876.mpd
t Transfer: 1220 : 12|10:10:49.7657|8iHqI0|DANIEL|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/N0001876.mpd
t Transfer: 1220 : 12|10:10:49.7657|8iHqI0|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:10:49.7657|8iHqI0|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:10:49.7657|8iHqI0|DANIEL| user DANIEL.
t Transfer: 1220 : 12|10:10:49.7657|8iHqI0|DANIEL|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\N0001895.mov subfolder
t Transfer: 1220 : 12|10:10:49.7657|8iHqI0|DANIEL| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/N0001895.mov
t Transfer: 1220 : 12|10:10:49.7657|8iHqI0|DANIEL|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/N0001895.mov
t Transfer: 1220 : 12|10:10:49.7657|8iHqI0|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:10:49.7657|8iHqI0|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:10:49.7657|8iHqI0|DANIEL| user DANIEL.
t Transfer: 1220 : 12|10:10:50.1720|7yi1zf|DANIEL|OAuth: /api/v3/version/299086/media?_dc=1587719446805
t Transfer: 1220 : 12|10:10:50.1720|7yi1zf|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:10:50.1720|7yi1zf|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:10:50.1720|7yi1zf|DANIEL| user DANIEL.
t Verbose: 1220 : 12|10:10:50.1720|7yi1zf|DANIEL|OAuth. User logged in: DANIEL
t Information: 1220 : 12|10:10:50.1720|7yi1zf|DANIEL|V3Api.SearchGeneric
t Transfer: 1220 : 12|10:10:50.1720|7yi1zf|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:10:50.1720|7yi1zf|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:10:50.1720|7yi1zf|DANIEL| user DANIEL.
t Information: 1220 : 12|10:10:50.1720|7yi1zf|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
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: 299086
t Information: 1220 : 12|10:10:50.1720|7yi1zf|DANIEL| timing: 00:00:00.0139517
t Verbose: 1220 : 12|10:10:50.1720|7yi1zf|DANIEL|imfx v3 API took 0.014s '/api/v3/version/299086/media?_dc=1587719446805'
t Transfer: 1220 : 12|10:10:50.1720|7yi1zf|DANIEL|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\N0001888.ts subfolder
t Transfer: 1220 : 12|10:10:50.1720|7yi1zf|DANIEL| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/N0001888.ts
t Transfer: 1220 : 12|10:10:50.1720|7yi1zf|DANIEL|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/N0001888.ts
t Transfer: 1220 : 12|10:10:50.1720|7yi1zf|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:10:50.1720|7yi1zf|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:10:50.1720|7yi1zf|DANIEL| user DANIEL.
t Transfer: 1220 : 12|10:10:50.1720|7yi1zf|DANIEL|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\N0001889.ts subfolder
t Transfer: 1220 : 12|10:10:50.1720|7yi1zf|DANIEL| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/N0001889.ts
t Transfer: 1220 : 12|10:10:50.1720|7yi1zf|DANIEL|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/N0001889.ts
t Transfer: 1220 : 12|10:10:50.1720|7yi1zf|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:10:50.1720|7yi1zf|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:10:50.1720|7yi1zf|DANIEL| user DANIEL.
t Transfer: 1220 : 12|10:10:50.1720|7yi1zf|DANIEL|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\N0001890.ts subfolder
t Transfer: 1220 : 12|10:10:50.1720|7yi1zf|DANIEL| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/N0001890.ts
t Transfer: 1220 : 12|10:10:50.1720|7yi1zf|DANIEL|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/N0001890.ts
t Transfer: 1220 : 12|10:10:50.1720|7yi1zf|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:10:50.1720|7yi1zf|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:10:50.1720|7yi1zf|DANIEL| user DANIEL.
t Transfer: 1220 : 12|10:11:20.4376|X8wtSe|DANIEL|OAuth: /api/v3/version/298906/media?_dc=1587719477023
t Transfer: 1220 : 12|10:11:20.4376|X8wtSe|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:11:20.4376|X8wtSe|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:11:20.4376|X8wtSe|DANIEL| user DANIEL.
t Verbose: 1220 : 12|10:11:20.4376|X8wtSe|DANIEL|OAuth. User logged in: DANIEL
t Information: 1220 : 12|10:11:20.4376|X8wtSe|DANIEL|V3Api.SearchGeneric
t Transfer: 1220 : 12|10:11:20.4376|X8wtSe|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:11:20.4376|X8wtSe|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:11:20.4376|X8wtSe|DANIEL| user DANIEL.
t Information: 1220 : 12|10:11:20.4376|X8wtSe|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
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: 298906
t Information: 1220 : 12|10:11:20.4376|X8wtSe|DANIEL| timing: 00:00:00.0160847
t Verbose: 1220 : 12|10:11:20.4376|X8wtSe|DANIEL|imfx v3 API took 0.016s '/api/v3/version/298906/media?_dc=1587719477023'
t Transfer: 1220 : 12|10:11:20.4376|X8wtSe|DANIEL|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\MRR28-1.mov subfolder
t Transfer: 1220 : 12|10:11:20.4376|X8wtSe|DANIEL| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/MRR28-1.mov
t Transfer: 1220 : 12|10:11:20.4376|X8wtSe|DANIEL|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/MRR28-1.mov
t Transfer: 1220 : 12|10:11:20.4376|X8wtSe|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:11:20.4376|X8wtSe|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:11:20.4376|X8wtSe|DANIEL| user DANIEL.
t Transfer: 1220 : 12|10:11:20.4376|X8wtSe|DANIEL|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\N0001876.mpd subfolder
t Transfer: 1220 : 12|10:11:20.4376|X8wtSe|DANIEL| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/N0001876.mpd
t Transfer: 1220 : 12|10:11:20.4376|X8wtSe|DANIEL|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/N0001876.mpd
t Transfer: 1220 : 12|10:11:20.4376|X8wtSe|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:11:20.4376|X8wtSe|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:11:20.4376|X8wtSe|DANIEL| user DANIEL.
t Transfer: 1220 : 12|10:11:20.4376|X8wtSe|DANIEL|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\N0001895.mov subfolder
t Transfer: 1220 : 12|10:11:20.4376|X8wtSe|DANIEL| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/N0001895.mov
t Transfer: 1220 : 12|10:11:20.4376|X8wtSe|DANIEL|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/N0001895.mov
t Transfer: 1220 : 12|10:11:20.4376|X8wtSe|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:11:20.4376|X8wtSe|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:11:20.4376|X8wtSe|DANIEL| user DANIEL.
t Transfer: 1220 : 12|10:11:20.8438|~zGUb8|DANIEL|OAuth: /api/v3/version/299086/media?_dc=1587719477452
t Transfer: 1220 : 12|10:11:20.8438|~zGUb8|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:11:20.8438|~zGUb8|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:11:20.8438|~zGUb8|DANIEL| user DANIEL.
t Verbose: 1220 : 12|10:11:20.8438|~zGUb8|DANIEL|OAuth. User logged in: DANIEL
t Information: 1220 : 12|10:11:20.8438|~zGUb8|DANIEL|V3Api.SearchGeneric
t Transfer: 1220 : 12|10:11:20.8438|~zGUb8|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:11:20.8438|~zGUb8|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:11:20.8438|~zGUb8|DANIEL| user DANIEL.
t Information: 1220 : 12|10:11:20.8438|~zGUb8|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
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: 299086
t Information: 1220 : 12|10:11:20.8438|~zGUb8|DANIEL| timing: 00:00:00.0207864
t Verbose: 1220 : 12|10:11:20.8438|~zGUb8|DANIEL|imfx v3 API took 0.021s '/api/v3/version/299086/media?_dc=1587719477452'
t Transfer: 1220 : 12|10:11:20.8438|~zGUb8|DANIEL|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\N0001888.ts subfolder
t Transfer: 1220 : 12|10:11:20.8438|~zGUb8|DANIEL| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/N0001888.ts
t Transfer: 1220 : 12|10:11:20.8438|~zGUb8|DANIEL|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/N0001888.ts
t Transfer: 1220 : 12|10:11:20.8438|~zGUb8|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:11:20.8438|~zGUb8|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:11:20.8438|~zGUb8|DANIEL| user DANIEL.
t Transfer: 1220 : 12|10:11:20.8438|~zGUb8|DANIEL|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\N0001889.ts subfolder
t Transfer: 1220 : 12|10:11:20.8438|~zGUb8|DANIEL| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/N0001889.ts
t Transfer: 1220 : 12|10:11:20.8438|~zGUb8|DANIEL|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/N0001889.ts
t Transfer: 1220 : 12|10:11:20.8438|~zGUb8|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:11:20.8438|~zGUb8|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:11:20.8438|~zGUb8|DANIEL| user DANIEL.
t Transfer: 1220 : 12|10:11:20.8438|~zGUb8|DANIEL|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\N0001890.ts subfolder
t Transfer: 1220 : 12|10:11:20.8438|~zGUb8|DANIEL| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/N0001890.ts
t Transfer: 1220 : 12|10:11:20.8438|~zGUb8|DANIEL|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/N0001890.ts
t Transfer: 1220 : 12|10:11:20.8438|~zGUb8|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:11:20.8438|~zGUb8|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:11:20.8438|~zGUb8|DANIEL| user DANIEL.
t Transfer: 1220 : 12|10:11:21.2501|Ejqk65|DANIEL|OAuth: /api/v3/version/298906/media?_dc=1587719477998
t Transfer: 1220 : 12|10:11:21.2501|Ejqk65|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:11:21.2501|Ejqk65|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:11:21.2501|Ejqk65|DANIEL| user DANIEL.
t Verbose: 1220 : 12|10:11:21.2501|Ejqk65|DANIEL|OAuth. User logged in: DANIEL
t Information: 1220 : 12|10:11:21.2501|Ejqk65|DANIEL|V3Api.SearchGeneric
t Transfer: 1220 : 12|10:11:21.2501|Ejqk65|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:11:21.2501|Ejqk65|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:11:21.2501|Ejqk65|DANIEL| user DANIEL.
t Information: 1220 : 12|10:11:21.4532|Ejqk65|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
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: 298906
t Information: 1220 : 12|10:11:21.4532|Ejqk65|DANIEL| timing: 00:00:00.0128996
t Verbose: 1220 : 12|10:11:21.4532|Ejqk65|DANIEL|imfx v3 API took 0.013s '/api/v3/version/298906/media?_dc=1587719477998'
t Transfer: 1220 : 12|10:11:21.4532|Ejqk65|DANIEL|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\MRR28-1.mov subfolder
t Transfer: 1220 : 12|10:11:21.4532|Ejqk65|DANIEL| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/MRR28-1.mov
t Transfer: 1220 : 12|10:11:21.4532|Ejqk65|DANIEL|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/MRR28-1.mov
t Transfer: 1220 : 12|10:11:21.4532|Ejqk65|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:11:21.4532|Ejqk65|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:11:21.4532|Ejqk65|DANIEL| user DANIEL.
t Transfer: 1220 : 12|10:11:21.4532|Ejqk65|DANIEL|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\N0001876.mpd subfolder
t Transfer: 1220 : 12|10:11:21.4532|Ejqk65|DANIEL| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/N0001876.mpd
t Transfer: 1220 : 12|10:11:21.4532|Ejqk65|DANIEL|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/N0001876.mpd
t Transfer: 1220 : 12|10:11:21.4532|Ejqk65|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:11:21.4532|Ejqk65|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:11:21.4532|Ejqk65|DANIEL| user DANIEL.
t Transfer: 1220 : 12|10:11:21.4532|Ejqk65|DANIEL|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\N0001895.mov subfolder
t Transfer: 1220 : 12|10:11:21.4532|Ejqk65|DANIEL| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/N0001895.mov
t Transfer: 1220 : 12|10:11:21.4532|Ejqk65|DANIEL|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/N0001895.mov
t Transfer: 1220 : 12|10:11:21.4532|Ejqk65|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:11:21.4532|Ejqk65|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:11:21.4532|Ejqk65|DANIEL| user DANIEL.
t Transfer: 1220 : 12|10:11:32.2189|j2X2no|DANIEL|OAuth: /api/v3/version/299086/media?_dc=1587719488939
t Transfer: 1220 : 12|10:11:32.2189|j2X2no|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:11:32.2189|j2X2no|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:11:32.2189|j2X2no|DANIEL| user DANIEL.
t Verbose: 1220 : 12|10:11:32.2189|j2X2no|DANIEL|OAuth. User logged in: DANIEL
t Information: 1220 : 12|10:11:32.2189|j2X2no|DANIEL|V3Api.SearchGeneric
t Transfer: 1220 : 12|10:11:32.2189|j2X2no|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:11:32.2189|j2X2no|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:11:32.2189|j2X2no|DANIEL| user DANIEL.
t Information: 1220 : 12|10:11:32.2189|j2X2no|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
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: 299086
t Information: 1220 : 12|10:11:32.2189|j2X2no|DANIEL| timing: 00:00:00.0138462
t Verbose: 1220 : 12|10:11:32.2189|j2X2no|DANIEL|imfx v3 API took 0.014s '/api/v3/version/299086/media?_dc=1587719488939'
t Transfer: 1220 : 12|10:11:32.2189|j2X2no|DANIEL|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\N0001888.ts subfolder
t Transfer: 1220 : 12|10:11:32.2189|j2X2no|DANIEL| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/N0001888.ts
t Transfer: 1220 : 12|10:11:32.2189|j2X2no|DANIEL|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/N0001888.ts
t Transfer: 1220 : 12|10:11:32.2189|j2X2no|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:11:32.2189|j2X2no|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:11:32.2189|j2X2no|DANIEL| user DANIEL.
t Transfer: 1220 : 12|10:11:32.2189|j2X2no|DANIEL|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\N0001889.ts subfolder
t Transfer: 1220 : 12|10:11:32.2189|j2X2no|DANIEL| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/N0001889.ts
t Transfer: 1220 : 12|10:11:32.2189|j2X2no|DANIEL|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/N0001889.ts
t Transfer: 1220 : 12|10:11:32.2189|j2X2no|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:11:32.2189|j2X2no|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:11:32.2189|j2X2no|DANIEL| user DANIEL.
t Transfer: 1220 : 12|10:11:32.2189|j2X2no|DANIEL|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\N0001890.ts subfolder
t Transfer: 1220 : 12|10:11:32.2189|j2X2no|DANIEL| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/N0001890.ts
t Transfer: 1220 : 12|10:11:32.2189|j2X2no|DANIEL|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/N0001890.ts
t Transfer: 1220 : 12|10:11:32.2189|j2X2no|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:11:32.2189|j2X2no|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:11:32.2189|j2X2no|DANIEL| user DANIEL.
t Transfer: 1220 : 12|10:11:38.5157|lrb_JK|DANIEL|OAuth: /api/v3/title/298907/versions?_dc=1587719495144
t Transfer: 1220 : 12|10:11:38.5157|lrb_JK|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:11:38.5157|lrb_JK|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:11:38.5157|lrb_JK|DANIEL| user DANIEL.
t Verbose: 1220 : 12|10:11:38.5157|lrb_JK|DANIEL|OAuth. User logged in: DANIEL
t Information: 1220 : 12|10:11:38.5157|lrb_JK|DANIEL|V3Api.SearchGeneric
t Transfer: 1220 : 12|10:11:38.5157|lrb_JK|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:11:38.5157|lrb_JK|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:11:38.5157|lrb_JK|DANIEL| user DANIEL.
t Transfer: 1220 : 12|10:11:38.5157|lrb_JK|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:11:38.5157|lrb_JK|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:11:38.5157|lrb_JK|DANIEL| user DANIEL.
t Information: 1220 : 12|10:11:38.5157|lrb_JK|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
where item_type>0 and rl_deleted=0 and m.PGM_ABS_ID=298907
order by m.title,m.id) a where rownum <= 9999) r where rnum >=1 order by rnum
t Information: 1220 : 12|10:11:38.5157|lrb_JK|DANIEL|Running version search. User: 342 Simple Search:
Running Oracle search.
Running Oracle search for COUNT
Oracle count completed in: 5ms. Returned lines: 1
Oracle version search timing: 42ms.
SQL run:
select * from (select a.*, rownum rnum from ( select m.*, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID, BUILD_PGRL_FULLTITLE(item_type, title, ser_name, ser_title) FULLTITLE from tmddba.tm_pg_rl m
left outer join (select text_id, text_data_path, text_data_filename, text_ref_object from tmddba.tm_text) t on t.text_id = m.primary_thumb_id
where item_type>0 and rl_deleted=0 and m.PGM_ABS_ID=298907
order by m.title,m.id) a where rownum <= 9999) r where rnum >=1 order by rnum
t Verbose: 1220 : 12|10:11:38.5157|lrb_JK|DANIEL|imfx v3 API took 0.052s '/api/v3/title/298907/versions?_dc=1587719495144'
t Transfer: 1220 : 12|10:11:38.5157|3tBb~8|DANIEL|OAuth: /api/v3/version/298908/media?_dc=1587719495252
t Transfer: 1220 : 12|10:11:38.5157|3tBb~8|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:11:38.5157|3tBb~8|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:11:38.5157|3tBb~8|DANIEL| user DANIEL.
t Verbose: 1220 : 12|10:11:38.5157|3tBb~8|DANIEL|OAuth. User logged in: DANIEL
t Information: 1220 : 12|10:11:38.5157|3tBb~8|DANIEL|V3Api.SearchGeneric
t Transfer: 1220 : 12|10:11:38.5157|3tBb~8|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:11:38.5157|3tBb~8|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:11:38.5157|3tBb~8|DANIEL| user DANIEL.
t Information: 1220 : 12|10:11:38.5157|3tBb~8|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
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: 298908
t Information: 1220 : 12|10:11:38.5157|3tBb~8|DANIEL| timing: 00:00:00.0113779
t Verbose: 1220 : 12|10:11:38.5157|3tBb~8|DANIEL|imfx v3 API took 0.011s '/api/v3/version/298908/media?_dc=1587719495252'
t Transfer: 1220 : 12|10:11:38.5157|3tBb~8|DANIEL|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\MRR27-1.mp4 subfolder
t Transfer: 1220 : 12|10:11:38.5157|3tBb~8|DANIEL| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/MRR27-1.mp4
t Transfer: 1220 : 12|10:11:38.5157|3tBb~8|DANIEL|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/MRR27-1.mp4
t Transfer: 1220 : 12|10:11:38.5157|3tBb~8|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:11:38.5157|3tBb~8|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:11:38.5157|3tBb~8|DANIEL| user DANIEL.
t Transfer: 1220 : 12|10:11:38.5157|3tBb~8|DANIEL|GetUrl. Storage |TEMP_UPLOAD| filename \\192.168.120.254\DemoFS\Digital Assets\TEMP_UPLOAD\1089d5e57c868\fred.ts subfolder 1089d5e57c868\
t Transfer: 1220 : 12|10:11:38.5157|3tBb~8|DANIEL| GetFileName result https://demo.tmd.tv/Temp Upload/fred.ts
t Transfer: 1220 : 12|10:11:38.5157|3tBb~8|DANIEL|GetUrl. result https://demo.tmd.tv/Temp Upload/fred.ts
t Transfer: 1220 : 12|10:11:38.5157|3tBb~8|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:11:38.5157|3tBb~8|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:11:38.5157|3tBb~8|DANIEL| user DANIEL.
t Transfer: 1220 : 12|10:11:39.9532|gqP3Wn|DANIEL|OAuth: /api/v3/title/298909/versions?_dc=1587719496528
t Transfer: 1220 : 12|10:11:39.9532|gqP3Wn|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:11:39.9532|gqP3Wn|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:11:39.9532|gqP3Wn|DANIEL| user DANIEL.
t Verbose: 1220 : 12|10:11:39.9532|gqP3Wn|DANIEL|OAuth. User logged in: DANIEL
t Information: 1220 : 12|10:11:39.9532|gqP3Wn|DANIEL|V3Api.SearchGeneric
t Transfer: 1220 : 12|10:11:39.9532|gqP3Wn|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:11:39.9532|gqP3Wn|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:11:39.9532|gqP3Wn|DANIEL| user DANIEL.
t Transfer: 1220 : 12|10:11:39.9532|gqP3Wn|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:11:39.9532|gqP3Wn|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:11:39.9532|gqP3Wn|DANIEL| user DANIEL.
t Information: 1220 : 12|10:11:39.9532|gqP3Wn|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
where item_type>0 and rl_deleted=0 and m.PGM_ABS_ID=298909
order by m.title,m.id) a where rownum <= 9999) r where rnum >=1 order by rnum
t Information: 1220 : 12|10:11:39.9532|gqP3Wn|DANIEL|Running version search. User: 342 Simple Search:
Running Oracle search.
Running Oracle search for COUNT
Oracle count completed in: 4ms. Returned lines: 1
Oracle version search timing: 32ms.
SQL run:
select * from (select a.*, rownum rnum from ( select m.*, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID, BUILD_PGRL_FULLTITLE(item_type, title, ser_name, ser_title) FULLTITLE from tmddba.tm_pg_rl m
left outer join (select text_id, text_data_path, text_data_filename, text_ref_object from tmddba.tm_text) t on t.text_id = m.primary_thumb_id
where item_type>0 and rl_deleted=0 and m.PGM_ABS_ID=298909
order by m.title,m.id) a where rownum <= 9999) r where rnum >=1 order by rnum
t Verbose: 1220 : 12|10:11:39.9532|gqP3Wn|DANIEL|imfx v3 API took 0.041s '/api/v3/title/298909/versions?_dc=1587719496528'
t Transfer: 1220 : 12|10:11:39.9532|te69b_|DANIEL|OAuth: /api/v3/version/298910/media?_dc=1587719496629
t Transfer: 1220 : 12|10:11:39.9532|te69b_|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:11:39.9532|te69b_|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:11:39.9532|te69b_|DANIEL| user DANIEL.
t Verbose: 1220 : 12|10:11:39.9532|te69b_|DANIEL|OAuth. User logged in: DANIEL
t Information: 1220 : 12|10:11:39.9532|te69b_|DANIEL|V3Api.SearchGeneric
t Transfer: 1220 : 12|10:11:39.9532|te69b_|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:11:39.9532|te69b_|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:11:39.9532|te69b_|DANIEL| user DANIEL.
t Information: 1220 : 12|10:11:39.9532|te69b_|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
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: 298910
t Information: 1220 : 12|10:11:39.9532|te69b_|DANIEL| count returned 0
t Verbose: 1220 : 12|10:11:39.9532|te69b_|DANIEL|imfx v3 API took 0.006s '/api/v3/version/298910/media?_dc=1587719496629'
t Transfer: 1220 : 12|10:12:10.8282|BOscIx|DANIEL|OAuth: /api/settings/user/uploadSettings?_dc=1587719527412
t Transfer: 1220 : 12|10:12:10.8282|BOscIx|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:12:10.8282|BOscIx|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:12:10.8282|BOscIx|DANIEL| user DANIEL.
t Verbose: 1220 : 12|10:12:10.8282|BOscIx|DANIEL|OAuth. User logged in: DANIEL
t Transfer: 1220 : 12|10:12:10.8282|BOscIx|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:12:10.8282|BOscIx|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:12:10.8282|BOscIx|DANIEL| user DANIEL.
t Verbose: 1220 : 12|10:12:10.8282|BOscIx|DANIEL|imfx v3 API took 0.004s '/api/settings/user/uploadSettings?_dc=1587719527412'
t Transfer: 1220 : 12|10:12:10.8282|8VM78b|DANIEL|OAuth: /api/lookups/Channels?_dc=1587719527429
t Transfer: 1220 : 12|10:12:10.8282|8VM78b|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:12:10.8282|8VM78b|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:12:10.8282|8VM78b|DANIEL| user DANIEL.
t Verbose: 1220 : 12|10:12:10.8282|8VM78b|DANIEL|OAuth. User logged in: DANIEL
t Transfer: 1220 : 12|10:12:10.8282|8VM78b|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:12:10.8282|8VM78b|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:12:10.8282|8VM78b|DANIEL| user DANIEL.
t Verbose: 1220 : 12|10:12:10.8282|8VM78b|DANIEL|imfx v3 API took 0.008s '/api/lookups/Channels?_dc=1587719527429'
t Transfer: 1220 : 12|10:12:10.8282|3QgwQj|DANIEL|OAuth: /api/v3/order-presets?_dc=1587719527495
t Transfer: 1220 : 12|10:12:10.8282|3QgwQj|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:12:10.8282|3QgwQj|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:12:10.8282|3QgwQj|DANIEL| user DANIEL.
t Verbose: 1220 : 12|10:12:10.8282|3QgwQj|DANIEL|OAuth. User logged in: DANIEL
t Transfer: 1220 : 12|10:12:10.8282|3QgwQj|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:12:10.8282|3QgwQj|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:12:10.8282|3QgwQj|DANIEL| user DANIEL.
t Verbose: 1220 : 12|10:12:10.8282|3QgwQj|DANIEL|imfx v3 API took 0.017s '/api/v3/order-presets?_dc=1587719527495'
t Transfer: 1220 : 12|10:12:10.8282|ydjh3G|DANIEL|OAuth: /api/v3/order-presets?_dc=1587719527560
t Transfer: 1220 : 12|10:12:10.8282|ydjh3G|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:12:10.8282|ydjh3G|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:12:10.8282|ydjh3G|DANIEL| user DANIEL.
t Verbose: 1220 : 12|10:12:10.8282|ydjh3G|DANIEL|OAuth. User logged in: DANIEL
t Transfer: 1220 : 12|10:12:10.8282|ydjh3G|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:12:10.8282|ydjh3G|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:12:10.8282|ydjh3G|DANIEL| user DANIEL.
t Verbose: 1220 : 12|10:12:10.8282|ydjh3G|DANIEL|imfx v3 API took 0.008s '/api/v3/order-presets?_dc=1587719527560'
t Transfer: 1220 : 12|10:12:11.0470|hfXjA8|DANIEL|OAuth: /api/v3/checkFilesExist?_dc=1587719527665
t Transfer: 1220 : 12|10:12:11.0470|hfXjA8|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:12:11.0470|hfXjA8|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:12:11.0470|hfXjA8|DANIEL| user DANIEL.
t Verbose: 1220 : 12|10:12:11.0470|hfXjA8|DANIEL|OAuth. User logged in: DANIEL
t Verbose: 1220 : 12|10:12:11.0470|hfXjA8|DANIEL|imfx v3 API took 0.057s '/api/v3/checkFilesExist?_dc=1587719527665'
t Transfer: 1220 : 12|10:13:06.9220|hcF1Ov|DANIEL|OAuth: /api/upload/file
t Transfer: 1220 : 12|10:13:06.9220|hcF1Ov|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:13:06.9220|hcF1Ov|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:13:06.9220|hcF1Ov|DANIEL| user DANIEL.
t Verbose: 1220 : 12|10:13:06.9220|hcF1Ov|DANIEL|OAuth. User logged in: DANIEL
t Information: 1220 : 12|10:15:29.1095|hcF1Ov|DANIEL|UploadMedia start. Version 298910 device 521 filename Exampleclip001 (3).mp4
t Information: 1220 : 12|10:15:29.1095|hcF1Ov|DANIEL| writing to location: \\192.168.120.254\DemoFS\Digital Assets\TEMP_UPLOAD
t Information: 1220 : 12|10:15:34.1876|hcF1Ov|DANIEL| preparing xml
t Information: 1220 : 12|10:15:34.1876|hcF1Ov|DANIEL| preparing segments
t Information: 1220 : 12|10:15:34.1876|hcF1Ov|DANIEL| calling full import api
t Transfer: 1220 : 12|10:15:34.1876|hcF1Ov|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:15:34.1876|hcF1Ov|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:15:34.1876|hcF1Ov|DANIEL| user DANIEL.
t Transfer: 1220 : 12|10:15:34.1876|hcF1Ov|DANIEL| semaphore enter at: 4/24/2020 10:15:34 AM count: 9 thread: 40
t Information: 1220 : 12|10:15:34.1876|hcF1Ov|DANIEL|CallApi. In. Trace-id: TRbETW Msg: FullImport. User: DANIEL. Rights: False.
t Information: 1220 : 12|10:15:34.1876|hcF1Ov|DANIEL|
internalId
true
298910
MX299175
MRR26-1
MRR-261217
P
d3bug
AV Clip
|TMD|PMS|
0
00:00:00:00
00:00:00:00
00:00:00:00
525 / 29.97DF
54
Exampleclip001 (3).mp4
mp4
TEMP_UPLOAD
54
120196766
11a7075adb8ee
00:00:00:00
00:00:00:00
525 / 29.97DF
Not QCd
t Information: 1220 : 12|10:15:34.3908|hcF1Ov|DANIEL|CallApi. Out. Trace-id: TRbETW 88.3ms.
t Information: 1220 : 12|10:15:34.3908|hcF1Ov|DANIEL|10299176
t Transfer: 1220 : 12|10:15:34.3908|hcF1Ov|DANIEL| semaphore release at: 4/24/2020 10:15:34 AM count: 9 thread: 40
t Information: 1220 : 12|10:15:34.3908|hcF1Ov|DANIEL| got media 299176
t Information: 1220 : 12|10:15:34.3908|hcF1Ov|DANIEL| updating media
t Information: 1220 : 12|10:15:34.8126|hcF1Ov|DANIEL| media saved
t Information: 1220 : 12|10:15:34.8126|hcF1Ov|DANIEL| raising job
t Transfer: 1220 : 12|10:15:34.8126|hcF1Ov|DANIEL| semaphore enter at: 4/24/2020 10:15:34 AM count: 9 thread: 40
t Information: 1220 : 12|10:15:34.8126|hcF1Ov|DANIEL|CallApi. In. Trace-id: n_hn05 Msg: RaiseJobAdvanced. User: DANIEL. Rights: False.
t Information: 1220 : 12|10:15:34.8126|hcF1Ov|DANIEL|
1954
299176
i-mediaflex file upload.
t Information: 1220 : 12|10:15:35.4220|hcF1Ov|DANIEL|CallApi. Out. Trace-id: n_hn05 620.0ms.
t Information: 1220 : 12|10:15:35.4220|hcF1Ov|DANIEL|10111385TMD.111385
t Transfer: 1220 : 12|10:15:35.4220|hcF1Ov|DANIEL| semaphore release at: 4/24/2020 10:15:35 AM count: 9 thread: 40
t Information: 1220 : 12|10:15:35.4220|hcF1Ov|DANIEL| job raised
t Information: 1220 : 12|10:15:35.4220|hcF1Ov|DANIEL| job id 111385, error: ''
t Verbose: 1220 : 12|10:15:35.4220|hcF1Ov|DANIEL|imfx v3 API took 148.371s '/api/upload/file'
t Transfer: 1220 : 12|10:18:18.7503|7xEOBz|DANIEL|OAuth: /api/v3/version/298910/media?_dc=1587719895238
t Transfer: 1220 : 12|10:18:18.7503|7xEOBz|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:18:18.7503|7xEOBz|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:18:18.7503|7xEOBz|DANIEL| user DANIEL.
t Verbose: 1220 : 12|10:18:18.7503|7xEOBz|DANIEL|OAuth. User logged in: DANIEL
t Information: 1220 : 12|10:18:18.7503|7xEOBz|DANIEL|V3Api.SearchGeneric
t Transfer: 1220 : 12|10:18:18.7503|7xEOBz|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:18:18.7503|7xEOBz|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:18:18.7503|7xEOBz|DANIEL| user DANIEL.
t Information: 1220 : 12|10:18:18.7503|7xEOBz|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
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: 298910
t Information: 1220 : 12|10:18:18.7503|7xEOBz|DANIEL| timing: 00:00:00.0134528
t Verbose: 1220 : 12|10:18:18.7503|7xEOBz|DANIEL|imfx v3 API took 0.014s '/api/v3/version/298910/media?_dc=1587719895238'
t Transfer: 1220 : 12|10:18:18.7503|7xEOBz|DANIEL|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Exampleclip001 (3).mp4 subfolder
t Transfer: 1220 : 12|10:18:18.7503|7xEOBz|DANIEL| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Exampleclip001 (3).mp4
t Transfer: 1220 : 12|10:18:18.7503|7xEOBz|DANIEL|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/Exampleclip001 (3).mp4
t Transfer: 1220 : 12|10:18:18.7503|7xEOBz|DANIEL|GetCurrentUser..
t Transfer: 1220 : 12|10:18:18.7503|7xEOBz|DANIEL| OAuth authenticated
t Transfer: 1220 : 12|10:18:18.7503|7xEOBz|DANIEL| user DANIEL.
t Information: 1220 : 12|10:39:14.2974|||OrabitWatcherBasic. Disposing.
t Information: 1220 : 12|10:39:14.2974|||OrabitWatcherBasic. Disposed.
t Information: 1220 : 12|10:39:14.2974|||==========================================================================
t Information: 1220 : 12|10:39:14.2974|||IMFX CORE SERVER APPLICATION END.