t Information: 1220 : 9|19:10:55.3731|||Get Configuration Values:
t Information: 1220 : 9|19:10:55.3731||| AdminPassEnc, default: , value: ffqjrn0leKv4Lj2YJHe2dw==.
t Information: 1220 : 9|19:10:55.3731||| EncryptedPasswords, default: false, value: true.
t Information: 1220 : 9|19:10:55.3731||| OraConnectionString, default: , value: Server=TECHM;User Id=imfx;Password=xxxxx;Unicode=true;.
t Information: 1220 : 9|19:10:55.3731||| SecondTimezone, default: , value: .
t Information: 1220 : 9|19:10:55.3731||| UseActiveDirectoryAuth, default: false, value: false.
t Information: 1220 : 9|19:10:55.3731||| ReportingServiceUrl, default: , value: http://localhost:92/ReportingService.svc.
t Information: 1220 : 9|19:10:55.3731||| ReportsPath, default: , value: .
t Information: 1220 : 9|19:10:55.3731||| ReportsURL, default: , value: .
t Information: 1220 : 9|19:10:55.3731||| TapeServiceUrl, default: , value: .
t Information: 1220 : 9|19:10:55.3731||| GatekeeperUrl, default: , value: .
t Information: 1220 : 9|19:10:55.3731||| ValuationUrl, default: , value: .
t Information: 1220 : 9|19:10:55.3731||| QueueManagerDelay, default: 30, value: 30.
t Information: 1220 : 9|19:10:55.3731||| QueueManagerFullRefresh, default: 90, value: 90.
t Information: 1220 : 9|19:10:55.3731||| AudioLoopDuration, default: 0, value: 150.
t Information: 1220 : 9|19:10:55.3731||| AudioLoopsCount, default: 0, value: 0.
t Information: 1220 : 9|19:10:55.3731||| PlayerFakeStep, default: 500, value: 500.
t Information: 1220 : 9|19:10:55.3731||| PlayerForceRatio, default: 0, value: 1.
t Information: 1220 : 9|19:10:55.3731||| CheckVersionsInProd, default: false, value: True.
t Information: 1220 : 9|19:10:55.3731||| MaxResults, default: 3000, value: 10000.
t Information: 1220 : 9|19:10:55.3731||| NetworkRestriction, default: false, value: True.
t Information: 1220 : 9|19:10:55.3731||| TEReportID, default: 0, value: 0.
t Information: 1220 : 9|19:10:55.3731||| ClosedCaptionsCache, default: , value: C:\inetpub\wwwroot\imfxcore\timedtextcache\.
t Information: 1220 : 9|19:10:55.3887||| ClosedCaptionsStorage, default: , value: c:\Mediaflex\subs.
t Information: 1220 : 9|19:10:55.3887||| TimeCodeFormat, default: , value: pal.
t Information: 1220 : 9|19:10:55.3887||| RceMediaPath, default: , value: C:\edl\.
t Information: 1220 : 9|19:10:55.3887||| RceMediaPath, default: , value: C:\edl\.
t Information: 1220 : 9|19:10:55.3887||| RceCsmOutputPath, default: , value: C:\Inetpub\wwwroot\csm\.
t Information: 1220 : 9|19:10:55.3887||| RceCsmUrl, default: , value: http://localhost/csm/.
t Information: 1220 : 9|19:10:55.3887||| RceMediaSelection, default: , value: miLinkIdMatch.
t Information: 1220 : 9|19:10:55.3887||| RequestBrowseJobPresetName, default: , value: .
t Information: 1220 : 9|19:10:55.3887||| DontExtendDuration, default: false, value: False.
t Information: 1220 : 9|19:10:55.3887||| V3ConfigUrl, default: , value: .
t Information: 1220 : 9|19:10:55.3887||| StopWords, default: , value: .
t Information: 1220 : 9|19:10:55.3887||| MisrTxFormat, default: G, value: G.
t Information: 1220 : 9|19:10:55.3887||| ApiServer, default: , value: http://192.168.120.10:85.
t Information: 1220 : 9|19:10:55.3887||| ApiTimeout, default: 120, value: 120.
t Information: 1220 : 9|19:10:55.3887||| ApiWorkers, default: 10, value: 10.
t Information: 1220 : 9|19:10:55.3887||| UsePerfCounters, default: false, value: false.
t Information: 1220 : 9|19:10:55.3887||| StatsdAddress, default: , value: .
t Information: 1220 : 9|19:10:55.3887||| LogGetCurrentUser, default: true, value: true.
t Information: 1220 : 9|19:10:55.3887||| LogInternalApi, default: true, value: true.
t Information: 1220 : 9|19:10:55.3887||| ThumbnailServer, default: , value: .
t Information: 1220 : 9|19:10:55.3887||| LocationFilter, default: , value: .
t Information: 1220 : 9|19:10:55.3887||| SvUtilServiceUrl, default: , value: .
t Information: 1220 : 9|19:10:55.3887||| SolrConnection, default: , value: http://192.168.120.14:8983/solr.
t Information: 1220 : 9|19:10:55.3887||| UseIndexServerSearch, default: false, value: True.
t Information: 1220 : 9|19:10:55.3887||| SolrIndexVersion, default: 1, value: 6.
t Information: 1220 : 9|19:10:55.3887||| SolrConnection, default: , value: http://192.168.120.14:8983/solr.
t Information: 1220 : 9|19:10:55.3887||| FacetsGroups, default: , value: owners,season_id, series_id,version_key,item_type,media_type,media_format,episode_number.
t Information: 1220 : 9|19:10:55.3887||| FacetsGroupsVersion, default: , value: owners,season_id, series_id,version_key,episode_number.
t Information: 1220 : 9|19:10:55.3887||| FacetsGroupsChameleon, default: , value: season_id, series_id,genre,prod_year,version_key.
t Information: 1220 : 9|19:10:55.3887||| PreviewPreset, default: , value: .
t Information: 1220 : 9|19:10:55.3887||| DevMode, default: false, value: false.
t Information: 1220 : 9|19:10:55.3887||| DisableSysMan, default: false, value: false.
t Information: 1220 : 9|19:10:55.3887||| TimeCodeFormat, default: , value: pal.
t Information: 1220 : 9|19:10:55.3887||| FileCatalystStorageDevice, default: , value: .
t Information: 1220 : 9|19:10:55.3887||| UseResponsibilityTracking, default: true, value: True.
t Information: 1220 : 9|19:10:55.3887||| SubtitleDeviceFilter, default: , value: .
t Information: 1220 : 9|19:10:55.3887||| SystemMonitorNamedPipe, default: , value: .
t Information: 1220 : 9|19:10:55.3887||| OracleMonitorEnable, default: false, value: False.
t Information: 1220 : 9|19:10:55.3887||| ArcApiHost, default: , value: .
t Information: 1220 : 9|19:10:55.3887||| RabbitMqUrl, default: , value: amqp://192.168.120.14:5672.
t Information: 1220 : 9|19:10:55.3887||| SolrTimedTextSearch, default: false, value: false.
t Information: 1220 : 9|19:10:55.3887||| ProductionDurationUsageID, default: 1, value: 1.
t Information: 1220 : 9|19:10:55.6074|||GetStreamServers..
t Information: 1220 : 9|19:10:56.0137||| https://demo.tmd.tv/CBR Video/ |CBR Video| False
t Information: 1220 : 9|19:10:56.0137||| https://demo.tmd.tv/CBR Images/ |CBR Images| False
t Information: 1220 : 9|19:10:56.0137||| https://demo.tmd.tv/CBR Audio/ |CBR Audio| False
t Information: 1220 : 9|19:10:56.0137||| https://demo.tmd.tv/Temp Upload/ |TEMP_UPLOAD| False
t Information: 1220 : 9|19:10:56.0137||| http://localhost:82/images/ |IMAGES| False
t Information: 1220 : 9|19:10:56.0137||| http://192.168.91.73/smoothcloud/ |SMOOTH_CLOUD| False
t Information: 1220 : 9|19:10:56.0137||| http://192.168.91.73/cloudstore/ |CLOUD_STORE| False
t Information: 1220 : 9|19:10:56.0137||| http://192.168.91.73/editsystemin/ |EDIT_SYSTEM_IN| False
t Information: 1220 : 9|19:10:56.0137||| http://192.168.91.27:89/APPLEPROXY/ |APPLE_PROXY| False
t Information: 1220 : 9|19:10:56.0137||| http://localhost:82/video/ |FILESTORE_VIDEO| False
t Information: 1220 : 9|19:10:56.0137||| https://imfxv3tm.tmd.tv/streaming/ |Streaming| False
t Information: 1220 : 9|19:10:56.0137||| https://imfxv3tm.tmd.tv/VideoServer/ |Video| False
t Information: 1220 : 9|19:10:56.0137||| https://imfxv3tm.tmd.tv/AdobeIn/ |Adobe Premiere Pro In| False
t Information: 1220 : 9|19:10:56.0137||| https://imfxv3tm.tmd.tv/AudioServer/ |Audio| False
t Information: 1220 : 9|19:10:56.0137||| https://imfxv3tm.tmd.tv/ImageServer/ |Image| False
t Information: 1220 : 9|19:10:56.0137||| https://imfxv3tm.tmd.tv/DocsServer/ |Docs| False
t Information: 1220 : 9|19:10:56.0137||| https://imfxv3tm.tmd.tv/AmazonLabs/ |TEST HOUSE| False
t Information: 1220 : 9|19:10:56.0137||| SolrConnectionUms, default: http://192.168.120.14:8983/solr, value: http://192.168.120.14:8983/solr.
t Information: 1220 : 9|19:10:56.0137||| LogWebApi, default: false, value: false.
t Information: 1220 : 9|19:10:56.0137||| EmbeddedRceUrl, default: , value: .
t Information: 1220 : 9|19:10:56.0137||| InstallMode, default: , value: .
t Information: 1220 : 9|19:10:56.0137||| SamlRequestAddress, default: , value: .
t Information: 1220 : 9|19:10:56.0137||| SamlTrustedIssuer, default: , value: .
t Information: 1220 : 9|19:10:56.0137||| SamlLoginRedirect, default: , value: .
t Information: 1220 : 9|19:10:56.0137||| NaturalLangSearch, default: false, value: True.
t Information: 1220 : 9|19:10:56.0137||| OktaLoginField, default: , value: .
t Information: 1220 : 9|19:10:56.0137||| AuthenticationTypes, default: , value: Native,PublicApiKey.
t Information: 1220 : 9|19:10:56.0137|||OrabitWatcherBasic. Initialize.
t Information: 1220 : 9|19:10:56.0137|||FillDictionaryCache.
t Information: 1220 : 9|19:10:59.7168|||GetSupportedOperators
t Information: 1220 : 9|19:10:59.9199|||CacheTechReports.
t Information: 1220 : 9|19:11:00.1230|||& Cache update. Server (global) filled with timestamp 07:03:59.9980899. types null
t Information: 1220 : 9|19:11:00.1230|||InitializeFromDatabase.
'Server=TECHM;User Id=imfx;password=..;Unicode=true;'
direct False, home , timeout 15
t Information: 1220 : 9|19:11:00.1230|||FillDictionaryCache.
t Information: 1220 : 9|19:11:00.1230|||& Cache update. Server (global) filled with timestamp 07:03:00.0137085. types FriendlyNames, DatabaseSearchFieldData
t Information: 1220 : 9|19:11:00.7324|||==========================================================================
t Information: 1220 : 9|19:11:00.7324|||IMFX CORE SERVER APPLICATION START.
t Information: 1220 : 9|19:11:00.7324|||DLL VERSION: 2.5.0.2610.
t Information: 1220 : 9|19:11:00.7324|||IS TIMER HIGH RESOULTION : True.
t Information: 1220 : 9|19:11:00.7324||| UmsDev, default: False, value: False.
t Information: 1220 : 9|19:11:00.9356|||OrabitWatcherBasic trying to connect..
t Information: 1220 : 9|19:11:01.1543|||OrabitWatcherBasic connected.
t Information: 1220 : 9|19:11:01.1543|||OrabitWatcherBasic queue created tmd.cfg.in.866ba924-24b3-49dd-b938-08e0fff53e97
t Information: 1220 : 9|19:11:06.4824|4hcGI2|TMDDBA|GetUserProfile. Id: 30000
t Transfer: 1220 : 9|19:11:06.4824|4hcGI2|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:11:06.4824|4hcGI2|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:11:06.4824|4hcGI2|TMDDBA| user TMDDBA.
t Information: 1220 : 9|19:12:08.0293|cg4OIv|TMDDBA|GetUserProfile. Id: 30000
t Transfer: 1220 : 9|19:12:08.0293|cg4OIv|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:12:08.0293|cg4OIv|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:12:08.0293|cg4OIv|TMDDBA| user TMDDBA.
t Transfer: 1220 : 9|19:12:55.7636|yz8ULJ|TMDDBA|OAuth: /api/settings/user/defaultHomePage?_dc=1585678375674
t Transfer: 1220 : 9|19:12:55.7636|yz8ULJ|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:12:55.7636|yz8ULJ|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:12:55.7636|yz8ULJ|TMDDBA| user TMDDBA.
t Verbose: 1220 : 9|19:12:55.7636|yz8ULJ|TMDDBA|OAuth. User logged in: TMDDBA
t Transfer: 1220 : 9|19:12:55.7636|yz8ULJ|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:12:55.7636|yz8ULJ|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:12:55.7636|yz8ULJ|TMDDBA| user TMDDBA.
t Verbose: 1220 : 9|19:12:55.7636|yz8ULJ|TMDDBA|imfx v3 API took 0.009s '/api/settings/user/defaultHomePage?_dc=1585678375674'
t Transfer: 1220 : 9|19:12:55.9668|lD0ty3|TMDDBA|OAuth: /api/settings/user/uploadSettings?_dc=1585678375745
t Transfer: 1220 : 9|19:12:55.9668|lD0ty3|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:12:55.9668|lD0ty3|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:12:55.9668|lD0ty3|TMDDBA| user TMDDBA.
t Verbose: 1220 : 9|19:12:55.9668|lD0ty3|TMDDBA|OAuth. User logged in: TMDDBA
t Transfer: 1220 : 9|19:12:55.9668|lD0ty3|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:12:55.9668|lD0ty3|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:12:55.9668|lD0ty3|TMDDBA| user TMDDBA.
t Verbose: 1220 : 9|19:12:55.9668|lD0ty3|TMDDBA|imfx v3 API took 0.004s '/api/settings/user/uploadSettings?_dc=1585678375745'
t Information: 1220 : 9|19:12:56.1699|Mz8Fdk|TMDDBA|GetUserProfile. Id: 0
t Transfer: 1220 : 9|19:12:56.1699|Mz8Fdk|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:12:56.1699|Mz8Fdk|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:12:56.1699|Mz8Fdk|TMDDBA| user TMDDBA.
t Transfer: 1220 : 9|19:12:56.3730|ypx8ks|TMDDBA|OAuth: /api/settings/user/defaultHomePage?_dc=1585678376210
t Transfer: 1220 : 9|19:12:56.3730|ypx8ks|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:12:56.3730|ypx8ks|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:12:56.3730|ypx8ks|TMDDBA| user TMDDBA.
t Verbose: 1220 : 9|19:12:56.3730|ypx8ks|TMDDBA|OAuth. User logged in: TMDDBA
t Transfer: 1220 : 9|19:12:56.3730|ypx8ks|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:12:56.3730|ypx8ks|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:12:56.3730|ypx8ks|TMDDBA| user TMDDBA.
t Verbose: 1220 : 9|19:12:56.3730|ypx8ks|TMDDBA|imfx v3 API took 0.002s '/api/settings/user/defaultHomePage?_dc=1585678376210'
t Transfer: 1220 : 9|19:12:58.6074|ySAEIo|TMDDBA|OAuth: /api/v3/task/assess/108155?_dc=1585678378542
t Transfer: 1220 : 9|19:12:58.6074|_vA0VW|TMDDBA|OAuth: /api/v3/detailsview/Job/0?lang=en-GB&_dc=1585678378542
t Transfer: 1220 : 9|19:12:58.6074|ySAEIo|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:12:58.6074|_vA0VW|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:12:58.6074|ySAEIo|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:12:58.6074|_vA0VW|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:12:58.6074|ySAEIo|TMDDBA| user TMDDBA.
t Transfer: 1220 : 9|19:12:58.6074|_vA0VW|TMDDBA| user TMDDBA.
t Verbose: 1220 : 9|19:12:58.6074|ySAEIo|TMDDBA|OAuth. User logged in: TMDDBA
t Verbose: 1220 : 9|19:12:58.6074|_vA0VW|TMDDBA|OAuth. User logged in: TMDDBA
t Verbose: 1220 : 9|19:12:58.8105|_vA0VW|TMDDBA|imfx v3 API took 0.046s '/api/v3/detailsview/Job/0?lang=en-GB&_dc=1585678378542'
t Information: 1220 : 9|19:12:58.8105|||TM_MIS. LoadSubtitles for ID: 299064
t Information: 1220 : 9|19:12:58.8105|||TM_MIS. LoadSubtitles for ID: 299064. SQL: 'select id, m_ctnr_id, m_ctnr_loc, modified_dt, tv_std, m_ctnr_fmt_id,
nvl((select max(l.language) from tm_audio l where l.miid=m.id),aud_language_id) aud_language_id
from tm_mis m where mi_deleted=0 and item_type>0 and media_type=101 and PGM_PARENT_ID=299000'
t Information: 1220 : 9|19:12:58.8105|||TM_MIS. LoadSubtitles for ID: 299064 found no subtitles.
t Verbose: 1220 : 9|19:12:59.2168|ySAEIo|TMDDBA|imfx v3 API took 0.431s '/api/v3/task/assess/108155?_dc=1585678378542'
t Transfer: 1220 : 9|19:12:59.6230|ySAEIo|TMDDBA|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\N0001864.mpd subfolder
t Transfer: 1220 : 9|19:12:59.6230|ySAEIo|TMDDBA| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/N0001864.mpd
t Transfer: 1220 : 9|19:12:59.6230|ySAEIo|TMDDBA|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/N0001864.mpd
t Transfer: 1220 : 9|19:12:59.6230|ySAEIo|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:12:59.6230|ySAEIo|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:12:59.6230|ySAEIo|TMDDBA| user TMDDBA.
t Transfer: 1220 : 9|19:12:59.8261|0iLOXW|TMDDBA|OAuth: /api/v3/detailsview/MediaDetails/5?lang=en-GB&_dc=1585678379586
t Transfer: 1220 : 9|19:12:59.8261|0iLOXW|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:12:59.8261|0iLOXW|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:12:59.8261|0iLOXW|TMDDBA| user TMDDBA.
t Verbose: 1220 : 9|19:12:59.8261|0iLOXW|TMDDBA|OAuth. User logged in: TMDDBA
t Transfer: 1220 : 9|19:12:59.8261|McU8ft|TMDDBA|OAuth: /api/v3/mediavideo/299064?info=smudge,scene,audiovolume&_dc=1585678379586
t Transfer: 1220 : 9|19:12:59.8261|McU8ft|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:12:59.8261|McU8ft|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:12:59.8261|McU8ft|TMDDBA| user TMDDBA.
t Verbose: 1220 : 9|19:12:59.8261|McU8ft|TMDDBA|OAuth. User logged in: TMDDBA
t Verbose: 1220 : 9|19:12:59.8261|0iLOXW|TMDDBA|imfx v3 API took 0.006s '/api/v3/detailsview/MediaDetails/5?lang=en-GB&_dc=1585678379586'
t Transfer: 1220 : 9|19:12:59.8261|McU8ft|TMDDBA|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\N0001864.mpd subfolder
t Transfer: 1220 : 9|19:12:59.8261|McU8ft|TMDDBA| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/N0001864.mpd
t Transfer: 1220 : 9|19:12:59.8261|McU8ft|TMDDBA|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/N0001864.mpd
t Transfer: 1220 : 9|19:12:59.8261|McU8ft|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:12:59.8261|McU8ft|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:12:59.8261|McU8ft|TMDDBA| user TMDDBA.
t Verbose: 1220 : 9|19:12:59.8261|McU8ft|TMDDBA|imfx v3 API took 0.087s '/api/v3/mediavideo/299064?info=smudge,scene,audiovolume&_dc=1585678379586'
t Transfer: 1220 : 9|19:13:00.4356|261hc4|TMDDBA|OAuth: /api/v3/layout/default/5?_dc=1585678380264
t Transfer: 1220 : 9|19:13:00.4356|261hc4|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:13:00.4356|261hc4|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:13:00.4356|261hc4|TMDDBA| user TMDDBA.
t Verbose: 1220 : 9|19:13:00.4356|261hc4|TMDDBA|OAuth. User logged in: TMDDBA
t Information: 1220 : 9|19:13:00.4356|261hc4|TMDDBA|LoadDefaultDashboard.
t Transfer: 1220 : 9|19:13:00.4356|261hc4|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:13:00.4356|261hc4|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:13:00.4356|261hc4|TMDDBA| user TMDDBA.
t Transfer: 1220 : 9|19:13:00.4356|261hc4|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:13:00.4356|261hc4|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:13:00.4356|261hc4|TMDDBA| user TMDDBA.
t Verbose: 1220 : 9|19:13:00.4356|261hc4|TMDDBA|imfx v3 API took 0.053s '/api/v3/layout/default/5?_dc=1585678380264'
t Information: 1220 : 9|19:13:01.0449|iDaW0O|TMDDBA|V3Api.GetMediaTagging
t Transfer: 1220 : 9|19:13:01.2481|u1gEdr|TMDDBA|OAuth: /api/v3/media-captions/299064?_dc=1585678381108
t Transfer: 1220 : 9|19:13:01.2481|u1gEdr|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:13:01.2481|u1gEdr|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:13:01.2481|u1gEdr|TMDDBA| user TMDDBA.
t Verbose: 1220 : 9|19:13:01.2481|u1gEdr|TMDDBA|OAuth. User logged in: TMDDBA
t Verbose: 1220 : 9|19:13:01.2481|u1gEdr|TMDDBA|imfx v3 API took 0.012s '/api/v3/media-captions/299064?_dc=1585678381108'
t Transfer: 1220 : 9|19:13:01.2481|RpnICC|TMDDBA|OAuth: /api/v3/ai-tags/299064?_dc=1585678381134
t Transfer: 1220 : 9|19:13:01.2481|RpnICC|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:13:01.2481|RpnICC|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:13:01.2481|RpnICC|TMDDBA| user TMDDBA.
t Verbose: 1220 : 9|19:13:01.2481|RpnICC|TMDDBA|OAuth. User logged in: TMDDBA
t Information: 1220 : 9|19:13:01.2481|RpnICC|TMDDBA|V3Api.GetMediaAiTags
t Verbose: 1220 : 9|19:13:01.2481|RpnICC|TMDDBA|imfx v3 API took 0.019s '/api/v3/ai-tags/299064?_dc=1585678381134'
t Transfer: 1220 : 9|19:13:01.8574|nsI6Q9|TMDDBA|OAuth: /api/user-group-preferences?globals=htmlplayerhotkeys,audioOnFrameForward&_dc=1585678381637
t Transfer: 1220 : 9|19:13:01.8574|nsI6Q9|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:13:01.8574|nsI6Q9|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:13:01.8574|nsI6Q9|TMDDBA| user TMDDBA.
t Verbose: 1220 : 9|19:13:01.8574|nsI6Q9|TMDDBA|OAuth. User logged in: TMDDBA
t Transfer: 1220 : 9|19:13:01.8574|nsI6Q9|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:13:01.8574|nsI6Q9|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:13:01.8574|nsI6Q9|TMDDBA| user TMDDBA.
t Verbose: 1220 : 9|19:13:01.8574|nsI6Q9|TMDDBA|imfx v3 API took 0.010s '/api/user-group-preferences?globals=htmlplayerhotkeys,audioOnFrameForward&_dc=1585678381637'
t Information: 1220 : 9|19:13:08.7637|YbnSWD|TMDDBA|GetUserProfile. Id: 30000
t Transfer: 1220 : 9|19:13:08.7637|YbnSWD|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:13:08.7637|YbnSWD|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:13:08.7637|YbnSWD|TMDDBA| user TMDDBA.
t Information: 1220 : 9|19:13:53.6855|imAdTm|TMDDBA|GetConfig TM_CFG_CUST_MED_STAT_TYPE.
t Verbose: 1220 : 9|19:13:53.6855|imAdTm|TMDDBA|imfx v3 API took 0.016s '/api/v3/config-table/TM_CFG_CUST_MED_STAT_TYPE?_dc=1585678433554'
t Information: 1220 : 9|19:14:10.7480|iAESqe|TMDDBA|GetUserProfile. Id: 30000
t Transfer: 1220 : 9|19:14:10.7480|iAESqe|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:14:10.7480|iAESqe|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:14:10.7480|iAESqe|TMDDBA| user TMDDBA.
t Transfer: 1220 : 9|19:14:33.4980|QHJrRv|TMDDBA|OAuth: /api/v3/config-table/TM_CFG_CUST_MED_STAT_TYPE?_dc=1585678473232
t Transfer: 1220 : 9|19:14:33.4980|QHJrRv|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:14:33.4980|QHJrRv|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:14:33.4980|QHJrRv|TMDDBA| user TMDDBA.
t Verbose: 1220 : 9|19:14:33.4980|QHJrRv|TMDDBA|OAuth. User logged in: TMDDBA
t Information: 1220 : 9|19:14:33.4980|QHJrRv|TMDDBA|PostConfig TM_CFG_CUST_MED_STAT_TYPE
t Transfer: 1220 : 9|19:14:33.4980|QHJrRv|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:14:33.4980|QHJrRv|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:14:33.4980|QHJrRv|TMDDBA| user TMDDBA.
t Verbose: 1220 : 9|19:14:33.7011|QHJrRv|TMDDBA|imfx v3 API took 0.325s '/api/v3/config-table/TM_CFG_CUST_MED_STAT_TYPE?_dc=1585678473232'
t Information: 1220 : 9|19:14:33.7011|59FIU3|TMDDBA|GetConfig TM_CFG_CUST_MED_STAT_TYPE.
t Verbose: 1220 : 9|19:14:33.7011|59FIU3|TMDDBA|imfx v3 API took 0.004s '/api/v3/config-table/TM_CFG_CUST_MED_STAT_TYPE?_dc=1585678473615'
t Information: 1220 : 9|19:14:44.4668|6ykMw3|TMDDBA|GetConfig TM_CFG_CUST_MED_STAT.
t Verbose: 1220 : 9|19:14:44.4668|6ykMw3|TMDDBA|imfx v3 API took 0.014s '/api/v3/config-table/TM_CFG_CUST_MED_STAT?_dc=1585678484270'
t Transfer: 1220 : 9|19:15:10.2636|Tnatkw|TMDDBA|OAuth: /api/v3/config-table/TM_CFG_CUST_MED_STAT?_dc=1585678510065
t Transfer: 1220 : 9|19:15:10.2636|Tnatkw|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:15:10.2636|Tnatkw|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:15:10.2636|Tnatkw|TMDDBA| user TMDDBA.
t Verbose: 1220 : 9|19:15:10.2636|Tnatkw|TMDDBA|OAuth. User logged in: TMDDBA
t Information: 1220 : 9|19:15:10.2636|Tnatkw|TMDDBA|PostConfig TM_CFG_CUST_MED_STAT
t Transfer: 1220 : 9|19:15:10.2636|Tnatkw|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:15:10.2636|Tnatkw|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:15:10.2636|Tnatkw|TMDDBA| user TMDDBA.
t Verbose: 1220 : 9|19:15:10.2636|Tnatkw|TMDDBA|imfx v3 API took 0.029s '/api/v3/config-table/TM_CFG_CUST_MED_STAT?_dc=1585678510065'
t Information: 1220 : 9|19:15:10.2636|aCs94U|TMDDBA|GetConfig TM_CFG_CUST_MED_STAT.
t Verbose: 1220 : 9|19:15:10.2636|aCs94U|TMDDBA|imfx v3 API took 0.005s '/api/v3/config-table/TM_CFG_CUST_MED_STAT?_dc=1585678510131'
t Information: 1220 : 9|19:15:11.2793|IGhTir|TMDDBA|GetUserProfile. Id: 30000
t Transfer: 1220 : 9|19:15:11.2793|IGhTir|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:15:11.2793|IGhTir|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:15:11.2793|IGhTir|TMDDBA| user TMDDBA.
t Transfer: 1220 : 9|19:15:14.9356|GIg2m9|TMDDBA|OAuth: /api/v3/config-table/TM_CFG_CUST_MED_STAT?_dc=1585678514856
t Transfer: 1220 : 9|19:15:14.9356|GIg2m9|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:15:14.9356|GIg2m9|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:15:14.9356|GIg2m9|TMDDBA| user TMDDBA.
t Verbose: 1220 : 9|19:15:14.9356|GIg2m9|TMDDBA|OAuth. User logged in: TMDDBA
t Information: 1220 : 9|19:15:14.9356|GIg2m9|TMDDBA|PostConfig TM_CFG_CUST_MED_STAT
t Transfer: 1220 : 9|19:15:14.9356|GIg2m9|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:15:14.9356|GIg2m9|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:15:14.9356|GIg2m9|TMDDBA| user TMDDBA.
t Verbose: 1220 : 9|19:15:14.9356|GIg2m9|TMDDBA|imfx v3 API took 0.010s '/api/v3/config-table/TM_CFG_CUST_MED_STAT?_dc=1585678514856'
t Information: 1220 : 9|19:15:15.1387|Qwp~MT|TMDDBA|GetConfig TM_CFG_CUST_MED_STAT.
t Verbose: 1220 : 9|19:15:15.1387|Qwp~MT|TMDDBA|imfx v3 API took 0.005s '/api/v3/config-table/TM_CFG_CUST_MED_STAT?_dc=1585678514908'
t Transfer: 1220 : 9|19:15:18.7949|6dbsG0|TMDDBA|OAuth: /api/v3/config-table/TM_CFG_CUST_MED_STAT?_dc=1585678518713
t Transfer: 1220 : 9|19:15:18.7949|6dbsG0|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:15:18.7949|6dbsG0|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:15:18.7949|6dbsG0|TMDDBA| user TMDDBA.
t Verbose: 1220 : 9|19:15:18.7949|6dbsG0|TMDDBA|OAuth. User logged in: TMDDBA
t Information: 1220 : 9|19:15:18.7949|6dbsG0|TMDDBA|PostConfig TM_CFG_CUST_MED_STAT
t Transfer: 1220 : 9|19:15:18.7949|6dbsG0|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:15:18.7949|6dbsG0|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:15:18.7949|6dbsG0|TMDDBA| user TMDDBA.
t Verbose: 1220 : 9|19:15:18.7949|6dbsG0|TMDDBA|imfx v3 API took 0.009s '/api/v3/config-table/TM_CFG_CUST_MED_STAT?_dc=1585678518713'
t Information: 1220 : 9|19:15:18.9980|D4l1cS|TMDDBA|GetConfig TM_CFG_CUST_MED_STAT.
t Verbose: 1220 : 9|19:15:18.9980|D4l1cS|TMDDBA|imfx v3 API took 0.005s '/api/v3/config-table/TM_CFG_CUST_MED_STAT?_dc=1585678518757'
t Information: 1220 : 9|19:16:13.6386|1ysmPB|TMDDBA|GetUserProfile. Id: 30000
t Transfer: 1220 : 9|19:16:13.6386|1ysmPB|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:16:13.6386|1ysmPB|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:16:13.6386|1ysmPB|TMDDBA| user TMDDBA.
t Information: 1220 : 9|19:17:14.1699|2m4M1X|TMDDBA|GetUserProfile. Id: 30000
t Transfer: 1220 : 9|19:17:14.1699|2m4M1X|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:17:14.1699|2m4M1X|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:17:14.1699|2m4M1X|TMDDBA| user TMDDBA.
t Information: 1220 : 9|19:18:14.9199|0voW58|TMDDBA|GetUserProfile. Id: 30000
t Transfer: 1220 : 9|19:18:14.9199|0voW58|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:18:14.9199|0voW58|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:18:14.9199|0voW58|TMDDBA| user TMDDBA.
t Information: 1220 : 9|19:19:15.2480|~npA0h|TMDDBA|GetUserProfile. Id: 30000
t Transfer: 1220 : 9|19:19:15.2480|~npA0h|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:19:15.2480|~npA0h|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:19:15.2480|~npA0h|TMDDBA| user TMDDBA.
t Information: 1220 : 9|19:20:16.3886|tW8Z5x|TMDDBA|GetUserProfile. Id: 30000
t Transfer: 1220 : 9|19:20:16.3886|tW8Z5x|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:20:16.3886|tW8Z5x|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:20:16.3886|tW8Z5x|TMDDBA| user TMDDBA.
t Information: 1220 : 9|19:21:17.7324|tKfw3m|TMDDBA|GetUserProfile. Id: 30000
t Transfer: 1220 : 9|19:21:17.7324|tKfw3m|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:21:17.7324|tKfw3m|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:21:17.7324|tKfw3m|TMDDBA| user TMDDBA.
t Information: 1220 : 9|19:22:18.2636|Nw1KEM|TMDDBA|GetUserProfile. Id: 30000
t Transfer: 1220 : 9|19:22:18.2636|Nw1KEM|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:22:18.2636|Nw1KEM|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:22:18.2636|Nw1KEM|TMDDBA| user TMDDBA.
t Information: 1220 : 9|19:23:18.8262|4MZfKR|TMDDBA|GetUserProfile. Id: 30000
t Transfer: 1220 : 9|19:23:18.8262|4MZfKR|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:23:18.8262|4MZfKR|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:23:18.8262|4MZfKR|TMDDBA| user TMDDBA.
t Information: 1220 : 9|19:24:20.1699|UWrJWV|TMDDBA|GetUserProfile. Id: 30000
t Transfer: 1220 : 9|19:24:20.1699|UWrJWV|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:24:20.1699|UWrJWV|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:24:20.1699|UWrJWV|TMDDBA| user TMDDBA.
t Information: 1220 : 9|19:25:22.7636|6HGwGY|TMDDBA|GetUserProfile. Id: 30000
t Transfer: 1220 : 9|19:25:22.7636|6HGwGY|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:25:22.7636|6HGwGY|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:25:22.7636|6HGwGY|TMDDBA| user TMDDBA.
t Information: 1220 : 9|19:26:23.2949|p610Ds|TMDDBA|GetUserProfile. Id: 30000
t Transfer: 1220 : 9|19:26:23.2949|p610Ds|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:26:23.2949|p610Ds|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:26:23.2949|p610Ds|TMDDBA| user TMDDBA.
t Information: 1220 : 9|19:27:23.6231|YCLlTB|TMDDBA|GetUserProfile. Id: 30000
t Transfer: 1220 : 9|19:27:23.6231|YCLlTB|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:27:23.6231|YCLlTB|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:27:23.6231|YCLlTB|TMDDBA| user TMDDBA.
t Information: 1220 : 9|19:28:24.3574|Jq0hJU|TMDDBA|GetUserProfile. Id: 30000
t Transfer: 1220 : 9|19:28:24.3574|Jq0hJU|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:28:24.3574|Jq0hJU|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:28:24.3574|Jq0hJU|TMDDBA| user TMDDBA.
t Information: 1220 : 9|19:29:25.9199|66ZKum|TMDDBA|GetUserProfile. Id: 30000
t Transfer: 1220 : 9|19:29:25.9199|66ZKum|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:29:25.9199|66ZKum|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:29:25.9199|66ZKum|TMDDBA| user TMDDBA.
t Information: 1220 : 9|19:30:26.2481|uLHSm8|TMDDBA|GetUserProfile. Id: 30000
t Transfer: 1220 : 9|19:30:26.2481|uLHSm8|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:30:26.2481|uLHSm8|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:30:26.2481|uLHSm8|TMDDBA| user TMDDBA.
t Information: 1220 : 9|19:31:26.7793|hVUfZz|TMDDBA|GetUserProfile. Id: 30000
t Transfer: 1220 : 9|19:31:26.7793|hVUfZz|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:31:26.7793|hVUfZz|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:31:26.7793|hVUfZz|TMDDBA| user TMDDBA.
t Information: 1220 : 9|19:32:28.7324|jyn9fi|TMDDBA|GetUserProfile. Id: 30000
t Transfer: 1220 : 9|19:32:28.7324|jyn9fi|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:32:28.7324|jyn9fi|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:32:28.7324|jyn9fi|TMDDBA| user TMDDBA.
t Information: 1220 : 9|19:33:29.2793|MXlnQi|TMDDBA|GetUserProfile. Id: 30000
t Transfer: 1220 : 9|19:33:29.2793|MXlnQi|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:33:29.2793|MXlnQi|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:33:29.2793|MXlnQi|TMDDBA| user TMDDBA.
t Information: 1220 : 9|19:34:31.0293|oJ0FyU|TMDDBA|GetUserProfile. Id: 30000
t Transfer: 1220 : 9|19:34:31.0293|oJ0FyU|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:34:31.0293|oJ0FyU|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:34:31.0293|oJ0FyU|TMDDBA| user TMDDBA.
t Information: 1220 : 9|19:35:31.5606|LOnL1O|TMDDBA|GetUserProfile. Id: 30000
t Transfer: 1220 : 9|19:35:31.5606|LOnL1O|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:35:31.5606|LOnL1O|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:35:31.5606|LOnL1O|TMDDBA| user TMDDBA.
t Information: 1220 : 9|19:36:33.3418|gJRqN2|TMDDBA|GetUserProfile. Id: 30000
t Transfer: 1220 : 9|19:36:33.3418|gJRqN2|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:36:33.3418|gJRqN2|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:36:33.3418|gJRqN2|TMDDBA| user TMDDBA.
t Information: 1220 : 9|19:37:33.4668|i8tVUW|TMDDBA|GetUserProfile. Id: 30000
t Transfer: 1220 : 9|19:37:33.4668|i8tVUW|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:37:33.4668|i8tVUW|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:37:33.4668|i8tVUW|TMDDBA| user TMDDBA.
t Information: 1220 : 9|19:38:33.7950|B2jaK7|TMDDBA|GetUserProfile. Id: 30000
t Transfer: 1220 : 9|19:38:33.7950|B2jaK7|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:38:33.7950|B2jaK7|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:38:33.7950|B2jaK7|TMDDBA| user TMDDBA.
t Information: 1220 : 9|19:39:34.5293|oV4Bim|TMDDBA|GetUserProfile. Id: 30000
t Transfer: 1220 : 9|19:39:34.5293|oV4Bim|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:39:34.5293|oV4Bim|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:39:34.5293|oV4Bim|TMDDBA| user TMDDBA.
t Information: 1220 : 9|19:40:36.2793|_FYb89|TMDDBA|GetUserProfile. Id: 30000
t Transfer: 1220 : 9|19:40:36.2793|_FYb89|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:40:36.2793|_FYb89|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:40:36.2793|_FYb89|TMDDBA| user TMDDBA.
t Information: 1220 : 9|19:41:37.4199|RJEA0S|TMDDBA|GetUserProfile. Id: 30000
t Transfer: 1220 : 9|19:41:37.4199|RJEA0S|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:41:37.4199|RJEA0S|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:41:37.4199|RJEA0S|TMDDBA| user TMDDBA.
t Information: 1220 : 9|19:42:38.1543|v7PgVA|TMDDBA|GetUserProfile. Id: 30000
t Transfer: 1220 : 9|19:42:38.1543|v7PgVA|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:42:38.1543|v7PgVA|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:42:38.1543|v7PgVA|TMDDBA| user TMDDBA.
t Information: 1220 : 9|19:43:38.0762|tAzfbD|TMDDBA|GetUserProfile. Id: 30000
t Transfer: 1220 : 9|19:43:38.0762|tAzfbD|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:43:38.0762|tAzfbD|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:43:38.0762|tAzfbD|TMDDBA| user TMDDBA.
t Information: 1220 : 9|19:44:39.0137|~V1o9V|TMDDBA|GetUserProfile. Id: 30000
t Transfer: 1220 : 9|19:44:39.0137|~V1o9V|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:44:39.0137|~V1o9V|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:44:39.0137|~V1o9V|TMDDBA| user TMDDBA.
t Information: 1220 : 9|19:45:40.3574|Xx1U0x|TMDDBA|GetUserProfile. Id: 30000
t Transfer: 1220 : 9|19:45:40.3574|Xx1U0x|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:45:40.3574|Xx1U0x|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:45:40.3574|Xx1U0x|TMDDBA| user TMDDBA.
t Information: 1220 : 9|19:45:57.2324|tPqYgL|TMDDBA|GetConfig TM_WATCH_FOLDER_PROCESSORS.
t Verbose: 1220 : 9|19:45:57.4356|tPqYgL|TMDDBA|imfx v3 API took 0.229s '/api/v3/config-table/TM_WATCH_FOLDER_PROCESSORS?_dc=1585680357099'
t Information: 1220 : 9|19:46:41.5137|NFPRot|TMDDBA|GetUserProfile. Id: 30000
t Transfer: 1220 : 9|19:46:41.5137|NFPRot|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:46:41.5137|NFPRot|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:46:41.5137|NFPRot|TMDDBA| user TMDDBA.
t Transfer: 1220 : 9|19:47:01.4199|h7ktXX|TMDDBA|OAuth: /api/view/searchinfo/Media?_dc=1585680421321
t Transfer: 1220 : 9|19:47:01.4199|h7ktXX|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:47:01.4199|h7ktXX|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:47:01.4199|h7ktXX|TMDDBA| user TMDDBA.
t Verbose: 1220 : 9|19:47:01.4199|h7ktXX|TMDDBA|OAuth. User logged in: TMDDBA
t Transfer: 1220 : 9|19:47:01.4199|Bjs9G8|TMDDBA|OAuth: /api/user-preferences?keys=adv.recent.searches.media&_dc=1585680421326
t Transfer: 1220 : 9|19:47:01.4199|Bjs9G8|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:47:01.4199|Bjs9G8|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:47:01.4199|Bjs9G8|TMDDBA| user TMDDBA.
t Verbose: 1220 : 9|19:47:01.4199|Bjs9G8|TMDDBA|OAuth. User logged in: TMDDBA
t Information: 1220 : 9|19:47:01.4199|h7ktXX|TMDDBA|GetAdvSearchColumns. search type Media grid .
t Information: 1220 : 9|19:47:01.4199|Bjs9G8|TMDDBA|GetUserDataByKeys: adv.recent.searches.media
t Transfer: 1220 : 9|19:47:01.4199|Bjs9G8|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:47:01.4199|Bjs9G8|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:47:01.4199|Bjs9G8|TMDDBA| user TMDDBA.
t Verbose: 1220 : 9|19:47:01.4199|Bjs9G8|TMDDBA|imfx v3 API took 0.009s '/api/user-preferences?keys=adv.recent.searches.media&_dc=1585680421326'
t Verbose: 1220 : 9|19:47:01.4199|h7ktXX|TMDDBA|imfx v3 API took 0.019s '/api/view/searchinfo/Media?_dc=1585680421321'
t Transfer: 1220 : 9|19:47:01.6231|H~f3X~|TMDDBA|OAuth: /api/view/searches/Media?_dc=1585680421439
t Transfer: 1220 : 9|19:47:01.6231|H~f3X~|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:47:01.6231|H~f3X~|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:47:01.6231|H~f3X~|TMDDBA| user TMDDBA.
t Verbose: 1220 : 9|19:47:01.6231|H~f3X~|TMDDBA|OAuth. User logged in: TMDDBA
t Information: 1220 : 9|19:47:01.6231|H~f3X~|TMDDBA|GetSavedSearchNames. search type Media.
t Transfer: 1220 : 9|19:47:01.6231|H~f3X~|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:47:01.6231|H~f3X~|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:47:01.6231|H~f3X~|TMDDBA| user TMDDBA.
t Transfer: 1220 : 9|19:47:01.6231|fWYBmZ|TMDDBA|OAuth: /api/settings/user/searchLayoutConfig?_dc=1585680421451
t Transfer: 1220 : 9|19:47:01.6231|fWYBmZ|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:47:01.6231|fWYBmZ|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:47:01.6231|fWYBmZ|TMDDBA| user TMDDBA.
t Verbose: 1220 : 9|19:47:01.6231|fWYBmZ|TMDDBA|OAuth. User logged in: TMDDBA
t Transfer: 1220 : 9|19:47:01.6231|fWYBmZ|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:47:01.6231|fWYBmZ|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:47:01.6231|fWYBmZ|TMDDBA| user TMDDBA.
t Verbose: 1220 : 9|19:47:01.6231|fWYBmZ|TMDDBA|imfx v3 API took 0.003s '/api/settings/user/searchLayoutConfig?_dc=1585680421451'
t Verbose: 1220 : 9|19:47:01.6231|H~f3X~|TMDDBA|imfx v3 API took 0.042s '/api/view/searches/Media?_dc=1585680421439'
t Transfer: 1220 : 9|19:47:05.4824|RJ7q4w|TMDDBA|OAuth: /api/user-preferences?keys=adv.recent.searches.titles&_dc=1585680425328
t Transfer: 1220 : 9|19:47:05.4824|zz1JM3|TMDDBA|OAuth: /api/view/searchinfo/TitleSearch?_dc=1585680425325
t Transfer: 1220 : 9|19:47:05.4824|zz1JM3|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:47:05.4824|RJ7q4w|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:47:05.4824|RJ7q4w|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:47:05.4824|zz1JM3|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:47:05.4824|zz1JM3|TMDDBA| user TMDDBA.
t Transfer: 1220 : 9|19:47:05.4824|RJ7q4w|TMDDBA| user TMDDBA.
t Verbose: 1220 : 9|19:47:05.4824|RJ7q4w|TMDDBA|OAuth. User logged in: TMDDBA
t Verbose: 1220 : 9|19:47:05.4824|zz1JM3|TMDDBA|OAuth. User logged in: TMDDBA
t Information: 1220 : 9|19:47:05.4824|zz1JM3|TMDDBA|GetAdvSearchColumns. search type TitleSearch grid .
t Information: 1220 : 9|19:47:05.4824|RJ7q4w|TMDDBA|GetUserDataByKeys: adv.recent.searches.titles
t Transfer: 1220 : 9|19:47:05.4824|RJ7q4w|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:47:05.4824|RJ7q4w|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:47:05.4824|RJ7q4w|TMDDBA| user TMDDBA.
t Verbose: 1220 : 9|19:47:05.4824|zz1JM3|TMDDBA|imfx v3 API took 0.000s '/api/view/searchinfo/TitleSearch?_dc=1585680425325'
t Verbose: 1220 : 9|19:47:05.4824|RJ7q4w|TMDDBA|imfx v3 API took 0.005s '/api/user-preferences?keys=adv.recent.searches.titles&_dc=1585680425328'
t Transfer: 1220 : 9|19:47:05.4824|7WLCA6|TMDDBA|OAuth: /api/view/searches/TitleSearch?_dc=1585680425395
t Transfer: 1220 : 9|19:47:05.4824|7WLCA6|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:47:05.4824|7WLCA6|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:47:05.4824|7WLCA6|TMDDBA| user TMDDBA.
t Verbose: 1220 : 9|19:47:05.4824|7WLCA6|TMDDBA|OAuth. User logged in: TMDDBA
t Information: 1220 : 9|19:47:05.4824|7WLCA6|TMDDBA|GetSavedSearchNames. search type TitleSearch.
t Transfer: 1220 : 9|19:47:05.4824|7WLCA6|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:47:05.4824|7WLCA6|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:47:05.4824|7WLCA6|TMDDBA| user TMDDBA.
t Verbose: 1220 : 9|19:47:05.4824|7WLCA6|TMDDBA|imfx v3 API took 0.005s '/api/view/searches/TitleSearch?_dc=1585680425395'
t Transfer: 1220 : 9|19:47:05.8887|B1tud4|TMDDBA|OAuth: /api/settings/user/uploadSettings?_dc=1585680425783
t Transfer: 1220 : 9|19:47:05.8887|B1tud4|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:47:05.8887|B1tud4|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:47:05.8887|B1tud4|TMDDBA| user TMDDBA.
t Verbose: 1220 : 9|19:47:05.8887|B1tud4|TMDDBA|OAuth. User logged in: TMDDBA
t Transfer: 1220 : 9|19:47:05.8887|B1tud4|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:47:05.8887|B1tud4|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:47:05.8887|B1tud4|TMDDBA| user TMDDBA.
t Verbose: 1220 : 9|19:47:05.8887|B1tud4|TMDDBA|imfx v3 API took 0.003s '/api/settings/user/uploadSettings?_dc=1585680425783'
t Transfer: 1220 : 9|19:47:09.5450|xDrWt0|TMDDBA|OAuth: /api/v3/search-suggestion/?_dc=1585680429359
t Transfer: 1220 : 9|19:47:09.5450|xDrWt0|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:47:09.5450|xDrWt0|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:47:09.5450|xDrWt0|TMDDBA| user TMDDBA.
t Verbose: 1220 : 9|19:47:09.5450|xDrWt0|TMDDBA|OAuth. User logged in: TMDDBA
t Transfer: 1220 : 9|19:47:09.5450|xDrWt0|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:47:09.5450|xDrWt0|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:47:09.5450|xDrWt0|TMDDBA| user TMDDBA.
t Verbose: 1220 : 9|19:47:09.9512|xDrWt0|TMDDBA|imfx v3 API took 0.433s '/api/v3/search-suggestion/?_dc=1585680429359'
t Transfer: 1220 : 9|19:47:09.9512|eCGeRy|TMDDBA|OAuth: /api/v3/search/title?_dc=1585680429857
t Transfer: 1220 : 9|19:47:09.9512|eCGeRy|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:47:09.9512|eCGeRy|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:47:09.9512|eCGeRy|TMDDBA| user TMDDBA.
t Verbose: 1220 : 9|19:47:09.9512|eCGeRy|TMDDBA|OAuth. User logged in: TMDDBA
t Information: 1220 : 9|19:47:09.9512|eCGeRy|TMDDBA|V3Api.SearchTitles
t Information: 1220 : 9|19:47:09.9512|eCGeRy|TMDDBA|V3Api.SearchGeneric
t Transfer: 1220 : 9|19:47:09.9512|eCGeRy|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:47:09.9512|eCGeRy|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:47:09.9512|eCGeRy|TMDDBA| user TMDDBA.
t Transfer: 1220 : 9|19:47:09.9512|eCGeRy|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:47:09.9512|eCGeRy|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:47:09.9512|eCGeRy|TMDDBA| user TMDDBA.
t Information: 1220 : 9|19:47:09.9512|eCGeRy|TMDDBA|SearchTitle SQL:
with
v as (
SELECT
abs.*
,decode(ITEM_TYPE,
1010,SER_ABS_ID,
1020,CASE WHEN SER_ABS2_ID > 0 THEN SER_ABS2_ID ELSE SER_ABS_ID END
) xparent_id
FROM TMDDBA.TM_PG_ABS abs
WHERE abs.id in (
select a.id
FROM TMDDBA.TM_PG_ABS a
where ABS_DELETED = 0 AND (INSTR(OWNERS,'|03BO|')>0 OR INSTR(OWNERS,'|03GD|')>0 OR INSTR(OWNERS,'|03GO|')>0 OR INSTR(OWNERS,'|03HA|')>0 OR INSTR(OWNERS,'|03JO|')>0 OR INSTR(OWNERS,'|03LI|')>0 OR INSTR(OWNERS,'|03NB|')>0 OR INSTR(OWNERS,'|03NM|')>0 OR INSTR(OWNERS,'|03NO|')>0 OR INSTR(OWNERS,'|03OR|')>0 OR INSTR(OWNERS,'|03SB|')>0 OR INSTR(OWNERS,'|03SC|')>0 OR INSTR(OWNERS,'|03SE|')>0 OR INSTR(OWNERS,'|03SG|')>0 OR INSTR(OWNERS,'|03SK|')>0 OR INSTR(OWNERS,'|03SM|')>0 OR INSTR(OWNERS,'|03SN|')>0 OR INSTR(OWNERS,'|03SS|')>0 OR INSTR(OWNERS,'|03SY|')>0 OR INSTR(OWNERS,'|03UP|')>0 OR INSTR(OWNERS,'|03VA|')>0 OR INSTR(OWNERS,'|03VB|')>0 OR INSTR(OWNERS,'|03VL|')>0 OR INSTR(OWNERS,'|03VT|')>0 OR INSTR(OWNERS,'|3+ES|')>0 OR INSTR(OWNERS,'|3PD|')>0 OR INSTR(OWNERS,'|3PLV|')>0 OR INSTR(OWNERS,'|AECHD|')>0 OR INSTR(OWNERS,'|AECSD|')>0 OR INSTR(OWNERS,'|AL|')>0 OR INSTR(OWNERS,'|AMAY|')>0 OR INSTR(OWNERS,'|AMC|')>0 OR INSTR(OWNERS,'|ATP|')>0 OR INSTR(OWNERS,'|CENT|')>0 OR INSTR(OWNERS,'|CS|')>0 OR INSTR(OWNERS,'|CTCB|')>0 OR INSTR(OWNERS,'|CTCE|')>0 OR INSTR(OWNERS,'|DAVI|')>0 OR INSTR(OWNERS,'|DMA|')>0 OR INSTR(OWNERS,'|DMF|')>0 OR INSTR(OWNERS,'|DMY|')>0 OR INSTR(OWNERS,'|DTV|')>0 OR INSTR(OWNERS,'|EST|')>0 OR INSTR(OWNERS,'|EUROSPORT|')>0 OR INSTR(OWNERS,'|HDC1|')>0 OR INSTR(OWNERS,'|HDP1|')>0 OR INSTR(OWNERS,'|HDP2|')>0 OR INSTR(OWNERS,'|HUB|')>0 OR INSTR(OWNERS,'|KNL2|')>0 OR INSTR(OWNERS,'|KNVA|')>0 OR INSTR(OWNERS,'|LMH|')>0 OR INSTR(OWNERS,'|LNT|')>0 OR INSTR(OWNERS,'|MBNS|')>0 OR INSTR(OWNERS,'|MED|')>0 OR INSTR(OWNERS,'|MM|')>0 OR INSTR(OWNERS,'|MTG|')>0 OR INSTR(OWNERS,'|NAA|')>0 OR INSTR(OWNERS,'|NICK|')>0 OR INSTR(OWNERS,'|NVA|')>0 OR INSTR(OWNERS,'|OSP|')>0 OR INSTR(OWNERS,'|PBOY|')>0 OR INSTR(OWNERS,'|PMS|')>0 OR INSTR(OWNERS,'|PPL|')>0 OR INSTR(OWNERS,'|PSP|')>0 OR INSTR(OWNERS,'|Play|')>0 OR INSTR(OWNERS,'|RTR|')>0 OR INSTR(OWNERS,'|SFP1|')>0 OR INSTR(OWNERS,'|SFP2|')>0 OR INSTR(OWNERS,'|SPG|')>0 OR INSTR(OWNERS,'|SPTV|')>0 OR INSTR(OWNERS,'|T3LT|')>0 OR INSTR(OWNERS,'|T3LV|')>0 OR INSTR(OWNERS,'|T6LT|')>0 OR INSTR(OWNERS,'|T6LV|')>0 OR INSTR(OWNERS,'|T8LT|')>0 OR INSTR(OWNERS,'|TECHM|')>0 OR INSTR(OWNERS,'|TMD|')>0 OR INSTR(OWNERS,'|TV10|')>0 OR INSTR(OWNERS,'|TV1A|')>0 OR INSTR(OWNERS,'|TV1B|')>0 OR INSTR(OWNERS,'|TV1C|')>0 OR INSTR(OWNERS,'|TV1D|')>0 OR INSTR(OWNERS,'|TV1E|')>0 OR INSTR(OWNERS,'|TV1F|')>0 OR INSTR(OWNERS,'|TV1K|')>0 OR INSTR(OWNERS,'|TV1N|')>0 OR INSTR(OWNERS,'|TV1P|')>0 OR INSTR(OWNERS,'|TV1S|')>0 OR INSTR(OWNERS,'|TV2S|')>0 OR INSTR(OWNERS,'|TV3D|')>0 OR INSTR(OWNERS,'|TV3N|')>0 OR INSTR(OWNERS,'|TV3S|')>0 OR INSTR(OWNERS,'|TV5L|')>0 OR INSTR(OWNERS,'|TV6E|')>0 OR INSTR(OWNERS,'|TV6H|')>0 OR INSTR(OWNERS,'|TV6N|')>0 OR INSTR(OWNERS,'|TV6S|')>0 OR INSTR(OWNERS,'|TV8|')>0 OR INSTR(OWNERS,'|TVAE|')>0 OR INSTR(OWNERS,'|TVDP|')>0 OR INSTR(OWNERS,'|TVPB|')>0 OR INSTR(OWNERS,'|TVPU|')>0 OR INSTR(OWNERS,'|TVSL|')>0 OR INSTR(OWNERS,'|V1G|')>0 OR INSTR(OWNERS,'|V1TZ|')>0 OR INSTR(OWNERS,'|V3H|')>0 OR INSTR(OWNERS,'|V4N|')>0 OR INSTR(OWNERS,'|VEC|')>0 OR INSTR(OWNERS,'|VEPL|')>0 OR INSTR(OWNERS,'|VEPO|')>0 OR INSTR(OWNERS,'|VEXE|')>0 OR INSTR(OWNERS,'|VEXR|')>0 OR INSTR(OWNERS,'|VHIS|')>0 OR INSTR(OWNERS,'|VHPO|')>0 OR INSTR(OWNERS,'|VNC|')>0 OR INSTR(OWNERS,'|VNE|')>0 OR INSTR(OWNERS,'|VNH|')>0 OR INSTR(OWNERS,'|VNHD|')>0 OR INSTR(OWNERS,'|VNPO|')>0 OR INSTR(OWNERS,'|VODD|')>0 OR INSTR(OWNERS,'|VODE|')>0 OR INSTR(OWNERS,'|VODF|')>0 OR INSTR(OWNERS,'|VODN|')>0 OR INSTR(OWNERS,'|VODS|')>0 OR INSTR(OWNERS,'|VS2|')>0 OR INSTR(OWNERS,'|VS3|')>0 OR INSTR(OWNERS,'|VSAT|')>0 OR INSTR(OWNERS,'|VSD|')>0 OR INSTR(OWNERS,'|VSD2|')>0 OR INSTR(OWNERS,'|VSE|')>0 OR INSTR(OWNERS,'|VSG|')>0 OR INSTR(OWNERS,'|VSHD|')>0 OR INSTR(OWNERS,'|VSS|')>0 OR INSTR(OWNERS,'|WCIU|')>0 OR INSTR(OWNERS,'|YLE TV1|')>0 OR INSTR(OWNERS,'|ZTVS|')>0 ) AND (CONTAINS(CTX_TEXT_COL,'pmh') > 0 OR CONTAINS(CTX_IDS_COL,'pmh') > 0 ) AND ROWNUM < 25000 )
)
,v_missing_parent_ids as (
select xparent_id from v
minus
select id from v
)
,v_missing_parents as (
SELECT
distinct a.*
,decode(ITEM_TYPE,
1010,SER_ABS_ID,
1020,CASE WHEN SER_ABS2_ID > 0 THEN SER_ABS2_ID ELSE SER_ABS_ID END
) xparent_id
FROM TMDDBA.TM_PG_ABS a
START WITH ID IN (select xparent_id from v_missing_parent_ids)
CONNECT BY
CASE PRIOR ITEM_TYPE
WHEN 1010 THEN PRIOR SER_ABS_ID
WHEN 1020 THEN
CASE WHEN NVL(PRIOR SER_ABS2_ID, 0) > 0 THEN PRIOR SER_ABS2_ID ELSE PRIOR SER_ABS_ID END
END = ID
)
,v_all as (
select x.*, count(*) over() RowCount
from (
select * from v_missing_parents
union
select * from v
) x
)
,v_top as (
select id
from (select id, row_number()over(order by upper(ser_title),upper(title),ser_num,ser_ep_num, SER_EP_SQ_NUM ) rnk -- sort roots
from v_all
where xparent_id is null)
where rnk between (:page_number-1)*50+1 and :page_number*50
)
,v_tree as (
select level lvl, a.*
from v_all a
start with id in (select id from v_top)
connect by xparent_id = prior ID
order siblings by upper(ser_title),ser_num,ser_ep_num, SER_EP_SQ_NUM,upper(title) -- sort children
)
select *
from v_tree
--where rnk <= 50
t Verbose: 1220 : 9|19:47:10.1544|eCGeRy|TMDDBA|imfx v3 API took 0.062s '/api/v3/search/title?_dc=1585680429857'
t Transfer: 1220 : 9|19:47:10.1544|lYf2Go|TMDDBA|OAuth: /api/v3/title/298999/versions?_dc=1585680430051
t Transfer: 1220 : 9|19:47:10.1544|lYf2Go|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:47:10.1544|lYf2Go|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:47:10.1544|lYf2Go|TMDDBA| user TMDDBA.
t Verbose: 1220 : 9|19:47:10.1544|lYf2Go|TMDDBA|OAuth. User logged in: TMDDBA
t Information: 1220 : 9|19:47:10.1544|lYf2Go|TMDDBA|V3Api.SearchGeneric
t Transfer: 1220 : 9|19:47:10.1544|TIJw3I|TMDDBA|OAuth: /api/user-preferences?_dc=1585680430059
t Transfer: 1220 : 9|19:47:10.1544|TIJw3I|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:47:10.1544|TIJw3I|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:47:10.1544|TIJw3I|TMDDBA| user TMDDBA.
t Verbose: 1220 : 9|19:47:10.1544|TIJw3I|TMDDBA|OAuth. User logged in: TMDDBA
t Transfer: 1220 : 9|19:47:10.1544|lYf2Go|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:47:10.1544|lYf2Go|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:47:10.1544|lYf2Go|TMDDBA| user TMDDBA.
t Verbose: 1220 : 9|19:47:10.1544|TIJw3I|TMDDBA|StoreUserDataByKeys..
t Transfer: 1220 : 9|19:47:10.1544|TIJw3I|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:47:10.1544|TIJw3I|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:47:10.1544|TIJw3I|TMDDBA| user TMDDBA.
t Transfer: 1220 : 9|19:47:10.1544|lYf2Go|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:47:10.1544|lYf2Go|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:47:10.1544|lYf2Go|TMDDBA| user TMDDBA.
t Information: 1220 : 9|19:47:10.1700|lYf2Go|TMDDBA|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=298999 AND (INSTR(m.OWNERS,'|03BO|')>0 OR INSTR(m.OWNERS,'|03GD|')>0 OR INSTR(m.OWNERS,'|03GO|')>0 OR INSTR(m.OWNERS,'|03HA|')>0 OR INSTR(m.OWNERS,'|03JO|')>0 OR INSTR(m.OWNERS,'|03LI|')>0 OR INSTR(m.OWNERS,'|03NB|')>0 OR INSTR(m.OWNERS,'|03NM|')>0 OR INSTR(m.OWNERS,'|03NO|')>0 OR INSTR(m.OWNERS,'|03OR|')>0 OR INSTR(m.OWNERS,'|03SB|')>0 OR INSTR(m.OWNERS,'|03SC|')>0 OR INSTR(m.OWNERS,'|03SE|')>0 OR INSTR(m.OWNERS,'|03SG|')>0 OR INSTR(m.OWNERS,'|03SK|')>0 OR INSTR(m.OWNERS,'|03SM|')>0 OR INSTR(m.OWNERS,'|03SN|')>0 OR INSTR(m.OWNERS,'|03SS|')>0 OR INSTR(m.OWNERS,'|03SY|')>0 OR INSTR(m.OWNERS,'|03UP|')>0 OR INSTR(m.OWNERS,'|03VA|')>0 OR INSTR(m.OWNERS,'|03VB|')>0 OR INSTR(m.OWNERS,'|03VL|')>0 OR INSTR(m.OWNERS,'|03VT|')>0 OR INSTR(m.OWNERS,'|3+ES|')>0 OR INSTR(m.OWNERS,'|3PD|')>0 OR INSTR(m.OWNERS,'|3PLV|')>0 OR INSTR(m.OWNERS,'|AECHD|')>0 OR INSTR(m.OWNERS,'|AECSD|')>0 OR INSTR(m.OWNERS,'|AL|')>0 OR INSTR(m.OWNERS,'|AMAY|')>0 OR INSTR(m.OWNERS,'|AMC|')>0 OR INSTR(m.OWNERS,'|ATP|')>0 OR INSTR(m.OWNERS,'|CENT|')>0 OR INSTR(m.OWNERS,'|CS|')>0 OR INSTR(m.OWNERS,'|CTCB|')>0 OR INSTR(m.OWNERS,'|CTCE|')>0 OR INSTR(m.OWNERS,'|DAVI|')>0 OR INSTR(m.OWNERS,'|DMA|')>0 OR INSTR(m.OWNERS,'|DMF|')>0 OR INSTR(m.OWNERS,'|DMY|')>0 OR INSTR(m.OWNERS,'|DTV|')>0 OR INSTR(m.OWNERS,'|EST|')>0 OR INSTR(m.OWNERS,'|EUROSPORT|')>0 OR INSTR(m.OWNERS,'|HDC1|')>0 OR INSTR(m.OWNERS,'|HDP1|')>0 OR INSTR(m.OWNERS,'|HDP2|')>0 OR INSTR(m.OWNERS,'|HUB|')>0 OR INSTR(m.OWNERS,'|KNL2|')>0 OR INSTR(m.OWNERS,'|KNVA|')>0 OR INSTR(m.OWNERS,'|LMH|')>0 OR INSTR(m.OWNERS,'|LNT|')>0 OR INSTR(m.OWNERS,'|MBNS|')>0 OR INSTR(m.OWNERS,'|MED|')>0 OR INSTR(m.OWNERS,'|MM|')>0 OR INSTR(m.OWNERS,'|MTG|')>0 OR INSTR(m.OWNERS,'|NAA|')>0 OR INSTR(m.OWNERS,'|NICK|')>0 OR INSTR(m.OWNERS,'|NVA|')>0 OR INSTR(m.OWNERS,'|OSP|')>0 OR INSTR(m.OWNERS,'|PBOY|')>0 OR INSTR(m.OWNERS,'|PMS|')>0 OR INSTR(m.OWNERS,'|PPL|')>0 OR INSTR(m.OWNERS,'|PSP|')>0 OR INSTR(m.OWNERS,'|Play|')>0 OR INSTR(m.OWNERS,'|RTR|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|SPG|')>0 OR INSTR(m.OWNERS,'|SPTV|')>0 OR INSTR(m.OWNERS,'|T3LT|')>0 OR INSTR(m.OWNERS,'|T3LV|')>0 OR INSTR(m.OWNERS,'|T6LT|')>0 OR INSTR(m.OWNERS,'|T6LV|')>0 OR INSTR(m.OWNERS,'|T8LT|')>0 OR INSTR(m.OWNERS,'|TECHM|')>0 OR INSTR(m.OWNERS,'|TMD|')>0 OR INSTR(m.OWNERS,'|TV10|')>0 OR INSTR(m.OWNERS,'|TV1A|')>0 OR INSTR(m.OWNERS,'|TV1B|')>0 OR INSTR(m.OWNERS,'|TV1C|')>0 OR INSTR(m.OWNERS,'|TV1D|')>0 OR INSTR(m.OWNERS,'|TV1E|')>0 OR INSTR(m.OWNERS,'|TV1F|')>0 OR INSTR(m.OWNERS,'|TV1K|')>0 OR INSTR(m.OWNERS,'|TV1N|')>0 OR INSTR(m.OWNERS,'|TV1P|')>0 OR INSTR(m.OWNERS,'|TV1S|')>0 OR INSTR(m.OWNERS,'|TV2S|')>0 OR INSTR(m.OWNERS,'|TV3D|')>0 OR INSTR(m.OWNERS,'|TV3N|')>0 OR INSTR(m.OWNERS,'|TV3S|')>0 OR INSTR(m.OWNERS,'|TV5L|')>0 OR INSTR(m.OWNERS,'|TV6E|')>0 OR INSTR(m.OWNERS,'|TV6H|')>0 OR INSTR(m.OWNERS,'|TV6N|')>0 OR INSTR(m.OWNERS,'|TV6S|')>0 OR INSTR(m.OWNERS,'|TV8|')>0 OR INSTR(m.OWNERS,'|TVAE|')>0 OR INSTR(m.OWNERS,'|TVDP|')>0 OR INSTR(m.OWNERS,'|TVPB|')>0 OR INSTR(m.OWNERS,'|TVPU|')>0 OR INSTR(m.OWNERS,'|TVSL|')>0 OR INSTR(m.OWNERS,'|V1G|')>0 OR INSTR(m.OWNERS,'|V1TZ|')>0 OR INSTR(m.OWNERS,'|V3H|')>0 OR INSTR(m.OWNERS,'|V4N|')>0 OR INSTR(m.OWNERS,'|VEC|')>0 OR INSTR(m.OWNERS,'|VEPL|')>0 OR INSTR(m.OWNERS,'|VEPO|')>0 OR INSTR(m.OWNERS,'|VEXE|')>0 OR INSTR(m.OWNERS,'|VEXR|')>0 OR INSTR(m.OWNERS,'|VHIS|')>0 OR INSTR(m.OWNERS,'|VHPO|')>0 OR INSTR(m.OWNERS,'|VNC|')>0 OR INSTR(m.OWNERS,'|VNE|')>0 OR INSTR(m.OWNERS,'|VNH|')>0 OR INSTR(m.OWNERS,'|VNHD|')>0 OR INSTR(m.OWNERS,'|VNPO|')>0 OR INSTR(m.OWNERS,'|VODD|')>0 OR INSTR(m.OWNERS,'|VODE|')>0 OR INSTR(m.OWNERS,'|VODF|')>0 OR INSTR(m.OWNERS,'|VODN|')>0 OR INSTR(m.OWNERS,'|VODS|')>0 OR INSTR(m.OWNERS,'|VS2|')>0 OR INSTR(m.OWNERS,'|VS3|')>0 OR INSTR(m.OWNERS,'|VSAT|')>0 OR INSTR(m.OWNERS,'|VSD|')>0 OR INSTR(m.OWNERS,'|VSD2|')>0 OR INSTR(m.OWNERS,'|VSE|')>0 OR INSTR(m.OWNERS,'|VSG|')>0 OR INSTR(m.OWNERS,'|VSHD|')>0 OR INSTR(m.OWNERS,'|VSS|')>0 OR INSTR(m.OWNERS,'|WCIU|')>0 OR INSTR(m.OWNERS,'|YLE TV1|')>0 OR INSTR(m.OWNERS,'|ZTVS|')>0)
order by m.title,m.id) a where rownum <= 9999) r where rnum >=1 order by rnum
t Verbose: 1220 : 9|19:47:10.1700|TIJw3I|TMDDBA|imfx v3 API took 0.013s '/api/user-preferences?_dc=1585680430059'
t Information: 1220 : 9|19:47:10.3887|lYf2Go|TMDDBA|Running version search. User: 1 Simple Search:
Running Oracle search.
Running Oracle search for COUNT
Oracle count completed in: 2ms. Returned lines: 1
Oracle version search timing: 78ms.
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=298999 AND (INSTR(m.OWNERS,'|03BO|')>0 OR INSTR(m.OWNERS,'|03GD|')>0 OR INSTR(m.OWNERS,'|03GO|')>0 OR INSTR(m.OWNERS,'|03HA|')>0 OR INSTR(m.OWNERS,'|03JO|')>0 OR INSTR(m.OWNERS,'|03LI|')>0 OR INSTR(m.OWNERS,'|03NB|')>0 OR INSTR(m.OWNERS,'|03NM|')>0 OR INSTR(m.OWNERS,'|03NO|')>0 OR INSTR(m.OWNERS,'|03OR|')>0 OR INSTR(m.OWNERS,'|03SB|')>0 OR INSTR(m.OWNERS,'|03SC|')>0 OR INSTR(m.OWNERS,'|03SE|')>0 OR INSTR(m.OWNERS,'|03SG|')>0 OR INSTR(m.OWNERS,'|03SK|')>0 OR INSTR(m.OWNERS,'|03SM|')>0 OR INSTR(m.OWNERS,'|03SN|')>0 OR INSTR(m.OWNERS,'|03SS|')>0 OR INSTR(m.OWNERS,'|03SY|')>0 OR INSTR(m.OWNERS,'|03UP|')>0 OR INSTR(m.OWNERS,'|03VA|')>0 OR INSTR(m.OWNERS,'|03VB|')>0 OR INSTR(m.OWNERS,'|03VL|')>0 OR INSTR(m.OWNERS,'|03VT|')>0 OR INSTR(m.OWNERS,'|3+ES|')>0 OR INSTR(m.OWNERS,'|3PD|')>0 OR INSTR(m.OWNERS,'|3PLV|')>0 OR INSTR(m.OWNERS,'|AECHD|')>0 OR INSTR(m.OWNERS,'|AECSD|')>0 OR INSTR(m.OWNERS,'|AL|')>0 OR INSTR(m.OWNERS,'|AMAY|')>0 OR INSTR(m.OWNERS,'|AMC|')>0 OR INSTR(m.OWNERS,'|ATP|')>0 OR INSTR(m.OWNERS,'|CENT|')>0 OR INSTR(m.OWNERS,'|CS|')>0 OR INSTR(m.OWNERS,'|CTCB|')>0 OR INSTR(m.OWNERS,'|CTCE|')>0 OR INSTR(m.OWNERS,'|DAVI|')>0 OR INSTR(m.OWNERS,'|DMA|')>0 OR INSTR(m.OWNERS,'|DMF|')>0 OR INSTR(m.OWNERS,'|DMY|')>0 OR INSTR(m.OWNERS,'|DTV|')>0 OR INSTR(m.OWNERS,'|EST|')>0 OR INSTR(m.OWNERS,'|EUROSPORT|')>0 OR INSTR(m.OWNERS,'|HDC1|')>0 OR INSTR(m.OWNERS,'|HDP1|')>0 OR INSTR(m.OWNERS,'|HDP2|')>0 OR INSTR(m.OWNERS,'|HUB|')>0 OR INSTR(m.OWNERS,'|KNL2|')>0 OR INSTR(m.OWNERS,'|KNVA|')>0 OR INSTR(m.OWNERS,'|LMH|')>0 OR INSTR(m.OWNERS,'|LNT|')>0 OR INSTR(m.OWNERS,'|MBNS|')>0 OR INSTR(m.OWNERS,'|MED|')>0 OR INSTR(m.OWNERS,'|MM|')>0 OR INSTR(m.OWNERS,'|MTG|')>0 OR INSTR(m.OWNERS,'|NAA|')>0 OR INSTR(m.OWNERS,'|NICK|')>0 OR INSTR(m.OWNERS,'|NVA|')>0 OR INSTR(m.OWNERS,'|OSP|')>0 OR INSTR(m.OWNERS,'|PBOY|')>0 OR INSTR(m.OWNERS,'|PMS|')>0 OR INSTR(m.OWNERS,'|PPL|')>0 OR INSTR(m.OWNERS,'|PSP|')>0 OR INSTR(m.OWNERS,'|Play|')>0 OR INSTR(m.OWNERS,'|RTR|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|SPG|')>0 OR INSTR(m.OWNERS,'|SPTV|')>0 OR INSTR(m.OWNERS,'|T3LT|')>0 OR INSTR(m.OWNERS,'|T3LV|')>0 OR INSTR(m.OWNERS,'|T6LT|')>0 OR INSTR(m.OWNERS,'|T6LV|')>0 OR INSTR(m.OWNERS,'|T8LT|')>0 OR INSTR(m.OWNERS,'|TECHM|')>0 OR INSTR(m.OWNERS,'|TMD|')>0 OR INSTR(m.OWNERS,'|TV10|')>0 OR INSTR(m.OWNERS,'|TV1A|')>0 OR INSTR(m.OWNERS,'|TV1B|')>0 OR INSTR(m.OWNERS,'|TV1C|')>0 OR INSTR(m.OWNERS,'|TV1D|')>0 OR INSTR(m.OWNERS,'|TV1E|')>0 OR INSTR(m.OWNERS,'|TV1F|')>0 OR INSTR(m.OWNERS,'|TV1K|')>0 OR INSTR(m.OWNERS,'|TV1N|')>0 OR INSTR(m.OWNERS,'|TV1P|')>0 OR INSTR(m.OWNERS,'|TV1S|')>0 OR INSTR(m.OWNERS,'|TV2S|')>0 OR INSTR(m.OWNERS,'|TV3D|')>0 OR INSTR(m.OWNERS,'|TV3N|')>0 OR INSTR(m.OWNERS,'|TV3S|')>0 OR INSTR(m.OWNERS,'|TV5L|')>0 OR INSTR(m.OWNERS,'|TV6E|')>0 OR INSTR(m.OWNERS,'|TV6H|')>0 OR INSTR(m.OWNERS,'|TV6N|')>0 OR INSTR(m.OWNERS,'|TV6S|')>0 OR INSTR(m.OWNERS,'|TV8|')>0 OR INSTR(m.OWNERS,'|TVAE|')>0 OR INSTR(m.OWNERS,'|TVDP|')>0 OR INSTR(m.OWNERS,'|TVPB|')>0 OR INSTR(m.OWNERS,'|TVPU|')>0 OR INSTR(m.OWNERS,'|TVSL|')>0 OR INSTR(m.OWNERS,'|V1G|')>0 OR INSTR(m.OWNERS,'|V1TZ|')>0 OR INSTR(m.OWNERS,'|V3H|')>0 OR INSTR(m.OWNERS,'|V4N|')>0 OR INSTR(m.OWNERS,'|VEC|')>0 OR INSTR(m.OWNERS,'|VEPL|')>0 OR INSTR(m.OWNERS,'|VEPO|')>0 OR INSTR(m.OWNERS,'|VEXE|')>0 OR INSTR(m.OWNERS,'|VEXR|')>0 OR INSTR(m.OWNERS,'|VHIS|')>0 OR INSTR(m.OWNERS,'|VHPO|')>0 OR INSTR(m.OWNERS,'|VNC|')>0 OR INSTR(m.OWNERS,'|VNE|')>0 OR INSTR(m.OWNERS,'|VNH|')>0 OR INSTR(m.OWNERS,'|VNHD|')>0 OR INSTR(m.OWNERS,'|VNPO|')>0 OR INSTR(m.OWNERS,'|VODD|')>0 OR INSTR(m.OWNERS,'|VODE|')>0 OR INSTR(m.OWNERS,'|VODF|')>0 OR INSTR(m.OWNERS,'|VODN|')>0 OR INSTR(m.OWNERS,'|VODS|')>0 OR INSTR(m.OWNERS,'|VS2|')>0 OR INSTR(m.OWNERS,'|VS3|')>0 OR INSTR(m.OWNERS,'|VSAT|')>0 OR INSTR(m.OWNERS,'|VSD|')>0 OR INSTR(m.OWNERS,'|VSD2|')>0 OR INSTR(m.OWNERS,'|VSE|')>0 OR INSTR(m.OWNERS,'|VSG|')>0 OR INSTR(m.OWNERS,'|VSHD|')>0 OR INSTR(m.OWNERS,'|VSS|')>0 OR INSTR(m.OWNERS,'|WCIU|')>0 OR INSTR(m.OWNERS,'|YLE TV1|')>0 OR INSTR(m.OWNERS,'|ZTVS|')>0)
order by m.title,m.id) a where rownum <= 9999) r where rnum >=1 order by rnum
t Verbose: 1220 : 9|19:47:10.3887|lYf2Go|TMDDBA|imfx v3 API took 0.107s '/api/v3/title/298999/versions?_dc=1585680430051'
t Transfer: 1220 : 9|19:47:10.3887|XElrlI|TMDDBA|OAuth: /api/v3/version/299000/media?_dc=1585680430313
t Transfer: 1220 : 9|19:47:10.3887|XElrlI|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:47:10.3887|XElrlI|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:47:10.3887|XElrlI|TMDDBA| user TMDDBA.
t Verbose: 1220 : 9|19:47:10.3887|XElrlI|TMDDBA|OAuth. User logged in: TMDDBA
t Information: 1220 : 9|19:47:10.3887|XElrlI|TMDDBA|V3Api.SearchGeneric
t Transfer: 1220 : 9|19:47:10.3887|XElrlI|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:47:10.3887|XElrlI|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:47:10.3887|XElrlI|TMDDBA| user TMDDBA.
t Information: 1220 : 9|19:47:10.3887|XElrlI|TMDDBA|MediaSearch SQL:
select r.*,
nvl((select TMD_STR_AGG(c.u_id_pfix ) from tm_ctnrs c, tm_mi_tpi_lnx l where l.miid=r.id and c.u_id=l.tpiid and r.media_type=1),'') BARCODE,
nvl(lnk.lib_loc_ext_id,0) lib_loc_ext_id, nvl(lnk.ctnr_loan_stat,0) ctnr_loan_status, nvl(lnk.ctnr_stat,0) ctnr_stat,
nvl(t.text_data_path,'') THUMBSERVER,
nvl(t.text_data_filename,'') THUMBFILE,
nvl(t.text_id,-1) THUMBID ,
(select min(status.description) from TM_CFG_PGM_STATUS status where r.status = status.id) PGM_STATUS_TEXT, (select tmd_str_agg_pipe(cms.status_type_id ||',' ||cms.status_id) from tm_mi_cust_med_stat_lnx cms where cms.media_id=r.id) "CustomStatusesRaw",
GETMEDIALOC(r.id, r.media_type, r.compil, r.m_ctnr_int_o_loc, r.m_ctnr_ext_o_loc, r.m_ctnr_loc) LOCATION,
nvl(dfl.fSOM,0) FILE_SOM, nvl(dfl.fEOM,0) FILE_EOM, dfl.fos_fname FILENAME, dfl.DFILE_LINK_GUID, dfl.OS_GUID, dfl.SUB_FOLDER, dfl.ORIGINAL_FILENAME
from (select a.*, rownum rnum from
(select m.*,
coalesce(m.primary_thumb_id, (select v.primary_thumb_id from tm_pg_rl v where v.id=m.pgm_parent_id)) primary_thumb_id2
from tmddba.tm_mis m
where media_type>0 and item_type>0 AND PGM_PARENT_ID=:pgm_parent_id_1 and m.mi_deleted=0 AND (INSTR(m.OWNERS,'|03BO|')>0 OR INSTR(m.OWNERS,'|03GD|')>0 OR INSTR(m.OWNERS,'|03GO|')>0 OR INSTR(m.OWNERS,'|03HA|')>0 OR INSTR(m.OWNERS,'|03JO|')>0 OR INSTR(m.OWNERS,'|03LI|')>0 OR INSTR(m.OWNERS,'|03NB|')>0 OR INSTR(m.OWNERS,'|03NM|')>0 OR INSTR(m.OWNERS,'|03NO|')>0 OR INSTR(m.OWNERS,'|03OR|')>0 OR INSTR(m.OWNERS,'|03SB|')>0 OR INSTR(m.OWNERS,'|03SC|')>0 OR INSTR(m.OWNERS,'|03SE|')>0 OR INSTR(m.OWNERS,'|03SG|')>0 OR INSTR(m.OWNERS,'|03SK|')>0 OR INSTR(m.OWNERS,'|03SM|')>0 OR INSTR(m.OWNERS,'|03SN|')>0 OR INSTR(m.OWNERS,'|03SS|')>0 OR INSTR(m.OWNERS,'|03SY|')>0 OR INSTR(m.OWNERS,'|03UP|')>0 OR INSTR(m.OWNERS,'|03VA|')>0 OR INSTR(m.OWNERS,'|03VB|')>0 OR INSTR(m.OWNERS,'|03VL|')>0 OR INSTR(m.OWNERS,'|03VT|')>0 OR INSTR(m.OWNERS,'|3+ES|')>0 OR INSTR(m.OWNERS,'|3PD|')>0 OR INSTR(m.OWNERS,'|3PLV|')>0 OR INSTR(m.OWNERS,'|AECHD|')>0 OR INSTR(m.OWNERS,'|AECSD|')>0 OR INSTR(m.OWNERS,'|AL|')>0 OR INSTR(m.OWNERS,'|AMAY|')>0 OR INSTR(m.OWNERS,'|AMC|')>0 OR INSTR(m.OWNERS,'|ATP|')>0 OR INSTR(m.OWNERS,'|CENT|')>0 OR INSTR(m.OWNERS,'|CS|')>0 OR INSTR(m.OWNERS,'|CTCB|')>0 OR INSTR(m.OWNERS,'|CTCE|')>0 OR INSTR(m.OWNERS,'|DAVI|')>0 OR INSTR(m.OWNERS,'|DMA|')>0 OR INSTR(m.OWNERS,'|DMF|')>0 OR INSTR(m.OWNERS,'|DMY|')>0 OR INSTR(m.OWNERS,'|DTV|')>0 OR INSTR(m.OWNERS,'|EST|')>0 OR INSTR(m.OWNERS,'|EUROSPORT|')>0 OR INSTR(m.OWNERS,'|HDC1|')>0 OR INSTR(m.OWNERS,'|HDP1|')>0 OR INSTR(m.OWNERS,'|HDP2|')>0 OR INSTR(m.OWNERS,'|HUB|')>0 OR INSTR(m.OWNERS,'|KNL2|')>0 OR INSTR(m.OWNERS,'|KNVA|')>0 OR INSTR(m.OWNERS,'|LMH|')>0 OR INSTR(m.OWNERS,'|LNT|')>0 OR INSTR(m.OWNERS,'|MBNS|')>0 OR INSTR(m.OWNERS,'|MED|')>0 OR INSTR(m.OWNERS,'|MM|')>0 OR INSTR(m.OWNERS,'|MTG|')>0 OR INSTR(m.OWNERS,'|NAA|')>0 OR INSTR(m.OWNERS,'|NICK|')>0 OR INSTR(m.OWNERS,'|NVA|')>0 OR INSTR(m.OWNERS,'|OSP|')>0 OR INSTR(m.OWNERS,'|PBOY|')>0 OR INSTR(m.OWNERS,'|PMS|')>0 OR INSTR(m.OWNERS,'|PPL|')>0 OR INSTR(m.OWNERS,'|PSP|')>0 OR INSTR(m.OWNERS,'|Play|')>0 OR INSTR(m.OWNERS,'|RTR|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|SPG|')>0 OR INSTR(m.OWNERS,'|SPTV|')>0 OR INSTR(m.OWNERS,'|T3LT|')>0 OR INSTR(m.OWNERS,'|T3LV|')>0 OR INSTR(m.OWNERS,'|T6LT|')>0 OR INSTR(m.OWNERS,'|T6LV|')>0 OR INSTR(m.OWNERS,'|T8LT|')>0 OR INSTR(m.OWNERS,'|TECHM|')>0 OR INSTR(m.OWNERS,'|TMD|')>0 OR INSTR(m.OWNERS,'|TV10|')>0 OR INSTR(m.OWNERS,'|TV1A|')>0 OR INSTR(m.OWNERS,'|TV1B|')>0 OR INSTR(m.OWNERS,'|TV1C|')>0 OR INSTR(m.OWNERS,'|TV1D|')>0 OR INSTR(m.OWNERS,'|TV1E|')>0 OR INSTR(m.OWNERS,'|TV1F|')>0 OR INSTR(m.OWNERS,'|TV1K|')>0 OR INSTR(m.OWNERS,'|TV1N|')>0 OR INSTR(m.OWNERS,'|TV1P|')>0 OR INSTR(m.OWNERS,'|TV1S|')>0 OR INSTR(m.OWNERS,'|TV2S|')>0 OR INSTR(m.OWNERS,'|TV3D|')>0 OR INSTR(m.OWNERS,'|TV3N|')>0 OR INSTR(m.OWNERS,'|TV3S|')>0 OR INSTR(m.OWNERS,'|TV5L|')>0 OR INSTR(m.OWNERS,'|TV6E|')>0 OR INSTR(m.OWNERS,'|TV6H|')>0 OR INSTR(m.OWNERS,'|TV6N|')>0 OR INSTR(m.OWNERS,'|TV6S|')>0 OR INSTR(m.OWNERS,'|TV8|')>0 OR INSTR(m.OWNERS,'|TVAE|')>0 OR INSTR(m.OWNERS,'|TVDP|')>0 OR INSTR(m.OWNERS,'|TVPB|')>0 OR INSTR(m.OWNERS,'|TVPU|')>0 OR INSTR(m.OWNERS,'|TVSL|')>0 OR INSTR(m.OWNERS,'|V1G|')>0 OR INSTR(m.OWNERS,'|V1TZ|')>0 OR INSTR(m.OWNERS,'|V3H|')>0 OR INSTR(m.OWNERS,'|V4N|')>0 OR INSTR(m.OWNERS,'|VEC|')>0 OR INSTR(m.OWNERS,'|VEPL|')>0 OR INSTR(m.OWNERS,'|VEPO|')>0 OR INSTR(m.OWNERS,'|VEXE|')>0 OR INSTR(m.OWNERS,'|VEXR|')>0 OR INSTR(m.OWNERS,'|VHIS|')>0 OR INSTR(m.OWNERS,'|VHPO|')>0 OR INSTR(m.OWNERS,'|VNC|')>0 OR INSTR(m.OWNERS,'|VNE|')>0 OR INSTR(m.OWNERS,'|VNH|')>0 OR INSTR(m.OWNERS,'|VNHD|')>0 OR INSTR(m.OWNERS,'|VNPO|')>0 OR INSTR(m.OWNERS,'|VODD|')>0 OR INSTR(m.OWNERS,'|VODE|')>0 OR INSTR(m.OWNERS,'|VODF|')>0 OR INSTR(m.OWNERS,'|VODN|')>0 OR INSTR(m.OWNERS,'|VODS|')>0 OR INSTR(m.OWNERS,'|VS2|')>0 OR INSTR(m.OWNERS,'|VS3|')>0 OR INSTR(m.OWNERS,'|VSAT|')>0 OR INSTR(m.OWNERS,'|VSD|')>0 OR INSTR(m.OWNERS,'|VSD2|')>0 OR INSTR(m.OWNERS,'|VSE|')>0 OR INSTR(m.OWNERS,'|VSG|')>0 OR INSTR(m.OWNERS,'|VSHD|')>0 OR INSTR(m.OWNERS,'|VSS|')>0 OR INSTR(m.OWNERS,'|WCIU|')>0 OR INSTR(m.OWNERS,'|YLE TV1|')>0 OR INSTR(m.OWNERS,'|ZTVS|')>0)
order by upper(m.title), m.media_type, m.ec_som, m.id ) a where rownum <= 50) r
,lateral( select l.miid, max(c.C_EXT_OUT_LOC) lib_loc_ext_id, max(c.C_STAT) ctnr_stat, max(c.loan_stat) ctnr_loan_stat from tm_mi_tpi_lnx l, tm_ctnrs c where c.u_id=l.tpiid and l.miid=r.id and r.media_type=1 group by l.miid)(+) lnk
,lateral(select tt.* from tm_text tt where tt.text_id = r.primary_thumb_id2)(+) t
,lateral(select /*+ NO_DECORRELATE */ d.som fsom, d.eom feom, dl.mi_id fmi_id, d.os_fname fos_fname, d.DFILE_LINK_GUID, d.OS_GUID, d.SUB_FOLDER, dl.dfile_id, d.original_filename
FROM tm_dfile d, tm_mi_dfile_lnx dl where d.id=dl.dfile_id and r.id=dl.mi_id and rownum=1)(+) dfl
where rnum >= 1 order by rnum
Param: pgm_parent_id_1: 299000
t Information: 1220 : 9|19:47:10.5918|XElrlI|TMDDBA| timing: 00:00:00.0177733
t Verbose: 1220 : 9|19:47:10.5918|XElrlI|TMDDBA|imfx v3 API took 0.044s '/api/v3/version/299000/media?_dc=1585680430313'
t Transfer: 1220 : 9|19:47:10.5918|XElrlI|TMDDBA|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\short.mov subfolder
t Transfer: 1220 : 9|19:47:10.5918|XElrlI|TMDDBA| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/short.mov
t Transfer: 1220 : 9|19:47:10.5918|XElrlI|TMDDBA|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/short.mov
t Transfer: 1220 : 9|19:47:10.5918|XElrlI|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:47:10.5918|XElrlI|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:47:10.5918|XElrlI|TMDDBA| user TMDDBA.
t Transfer: 1220 : 9|19:47:10.5918|XElrlI|TMDDBA|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\N0001864.mpd subfolder
t Transfer: 1220 : 9|19:47:10.5918|XElrlI|TMDDBA| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/N0001864.mpd
t Transfer: 1220 : 9|19:47:10.5918|XElrlI|TMDDBA|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/N0001864.mpd
t Transfer: 1220 : 9|19:47:10.5918|XElrlI|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:47:10.5918|XElrlI|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:47:10.5918|XElrlI|TMDDBA| user TMDDBA.
t Transfer: 1220 : 9|19:47:34.5606|2rgySP|TMDDBA|OAuth: /api/settings/user/uploadSettings?_dc=1585680454405
t Transfer: 1220 : 9|19:47:34.5606|2rgySP|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:47:34.5606|2rgySP|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:47:34.5606|2rgySP|TMDDBA| user TMDDBA.
t Verbose: 1220 : 9|19:47:34.5606|2rgySP|TMDDBA|OAuth. User logged in: TMDDBA
t Transfer: 1220 : 9|19:47:34.5606|2rgySP|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:47:34.5606|2rgySP|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:47:34.5606|2rgySP|TMDDBA| user TMDDBA.
t Verbose: 1220 : 9|19:47:34.5606|2rgySP|TMDDBA|imfx v3 API took 0.004s '/api/settings/user/uploadSettings?_dc=1585680454405'
t Transfer: 1220 : 9|19:47:34.5606|cZaS9~|TMDDBA|OAuth: /api/lookups/Channels?_dc=1585680454430
t Transfer: 1220 : 9|19:47:34.5606|cZaS9~|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:47:34.5606|cZaS9~|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:47:34.5606|cZaS9~|TMDDBA| user TMDDBA.
t Verbose: 1220 : 9|19:47:34.5606|cZaS9~|TMDDBA|OAuth. User logged in: TMDDBA
t Transfer: 1220 : 9|19:47:34.5606|cZaS9~|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:47:34.5606|cZaS9~|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:47:34.5606|cZaS9~|TMDDBA| user TMDDBA.
t Verbose: 1220 : 9|19:47:34.5606|cZaS9~|TMDDBA|imfx v3 API took 0.037s '/api/lookups/Channels?_dc=1585680454430'
t Transfer: 1220 : 9|19:47:34.7637|dkvhu1|TMDDBA|OAuth: /api/settings/user/uploadSettings?_dc=1585680454568
t Transfer: 1220 : 9|19:47:34.7637|dkvhu1|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:47:34.7637|dkvhu1|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:47:34.7637|dkvhu1|TMDDBA| user TMDDBA.
t Verbose: 1220 : 9|19:47:34.7637|dkvhu1|TMDDBA|OAuth. User logged in: TMDDBA
t Transfer: 1220 : 9|19:47:34.7637|dkvhu1|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:47:34.7637|dkvhu1|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:47:34.7637|dkvhu1|TMDDBA| user TMDDBA.
t Verbose: 1220 : 9|19:47:34.7637|dkvhu1|TMDDBA|imfx v3 API took 0.003s '/api/settings/user/uploadSettings?_dc=1585680454568'
t Transfer: 1220 : 9|19:47:34.7637|agl5Kk|TMDDBA|OAuth: /api/v3/order-presets?_dc=1585680454633
t Transfer: 1220 : 9|19:47:34.7637|agl5Kk|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:47:34.7637|agl5Kk|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:47:34.7637|agl5Kk|TMDDBA| user TMDDBA.
t Verbose: 1220 : 9|19:47:34.7637|agl5Kk|TMDDBA|OAuth. User logged in: TMDDBA
t Transfer: 1220 : 9|19:47:34.7637|agl5Kk|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:47:34.7637|agl5Kk|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:47:34.7637|agl5Kk|TMDDBA| user TMDDBA.
t Verbose: 1220 : 9|19:47:34.7637|agl5Kk|TMDDBA|imfx v3 API took 0.030s '/api/v3/order-presets?_dc=1585680454633'
t Transfer: 1220 : 9|19:47:34.7637|t8Ie~9|TMDDBA|OAuth: /api/v3/order-presets?_dc=1585680454668
t Transfer: 1220 : 9|19:47:34.7637|t8Ie~9|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:47:34.7637|t8Ie~9|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:47:34.7637|t8Ie~9|TMDDBA| user TMDDBA.
t Verbose: 1220 : 9|19:47:34.7637|t8Ie~9|TMDDBA|OAuth. User logged in: TMDDBA
t Transfer: 1220 : 9|19:47:34.7637|t8Ie~9|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:47:34.7637|t8Ie~9|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:47:34.7637|t8Ie~9|TMDDBA| user TMDDBA.
t Verbose: 1220 : 9|19:47:34.7637|t8Ie~9|TMDDBA|imfx v3 API took 0.007s '/api/v3/order-presets?_dc=1585680454668'
t Transfer: 1220 : 9|19:47:34.9668|mhWgxV|TMDDBA|OAuth: /api/v3/checkFilesExist?_dc=1585680454777
t Transfer: 1220 : 9|19:47:34.9668|mhWgxV|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:47:34.9668|mhWgxV|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:47:34.9668|mhWgxV|TMDDBA| user TMDDBA.
t Verbose: 1220 : 9|19:47:34.9668|mhWgxV|TMDDBA|OAuth. User logged in: TMDDBA
t Verbose: 1220 : 9|19:47:34.9668|mhWgxV|TMDDBA|imfx v3 API took 0.062s '/api/v3/checkFilesExist?_dc=1585680454777'
t Information: 1220 : 9|19:47:43.0918|7y_RLS|TMDDBA|GetUserProfile. Id: 30000
t Transfer: 1220 : 9|19:47:43.0918|7y_RLS|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:47:43.0918|7y_RLS|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:47:43.0918|7y_RLS|TMDDBA| user TMDDBA.
t Information: 1220 : 9|19:48:43.8262|ycAA86|TMDDBA|GetUserProfile. Id: 30000
t Transfer: 1220 : 9|19:48:43.8262|ycAA86|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:48:43.8262|ycAA86|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:48:43.8262|ycAA86|TMDDBA| user TMDDBA.
t Transfer: 1220 : 9|19:49:05.9668|br9Enf|TMDDBA|OAuth: /api/settings/user/uploadSettings?_dc=1585680545744
t Transfer: 1220 : 9|19:49:05.9668|br9Enf|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:49:05.9668|br9Enf|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:49:05.9668|br9Enf|TMDDBA| user TMDDBA.
t Verbose: 1220 : 9|19:49:05.9668|br9Enf|TMDDBA|OAuth. User logged in: TMDDBA
t Transfer: 1220 : 9|19:49:05.9668|br9Enf|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:49:05.9668|br9Enf|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:49:05.9668|br9Enf|TMDDBA| user TMDDBA.
t Verbose: 1220 : 9|19:49:05.9668|br9Enf|TMDDBA|imfx v3 API took 0.003s '/api/settings/user/uploadSettings?_dc=1585680545744'
t Transfer: 1220 : 9|19:49:06.1699|a~_Owm|TMDDBA|OAuth: /api/settings/user/uploadSettings?_dc=1585680545902
t Transfer: 1220 : 9|19:49:06.1699|a~_Owm|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:49:06.1699|a~_Owm|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:49:06.1699|a~_Owm|TMDDBA| user TMDDBA.
t Verbose: 1220 : 9|19:49:06.1699|a~_Owm|TMDDBA|OAuth. User logged in: TMDDBA
t Transfer: 1220 : 9|19:49:06.1699|a~_Owm|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:49:06.1699|a~_Owm|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:49:06.1699|a~_Owm|TMDDBA| user TMDDBA.
t Transfer: 1220 : 9|19:49:06.1699|e1Bvyx|TMDDBA|OAuth: /api/v3/order-presets?_dc=1585680545945
t Transfer: 1220 : 9|19:49:06.1699|e1Bvyx|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:49:06.1699|e1Bvyx|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:49:06.1699|e1Bvyx|TMDDBA| user TMDDBA.
t Verbose: 1220 : 9|19:49:06.1699|e1Bvyx|TMDDBA|OAuth. User logged in: TMDDBA
t Transfer: 1220 : 9|19:49:06.1699|e1Bvyx|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:49:06.1699|e1Bvyx|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:49:06.1699|e1Bvyx|TMDDBA| user TMDDBA.
t Verbose: 1220 : 9|19:49:06.1699|a~_Owm|TMDDBA|imfx v3 API took 0.005s '/api/settings/user/uploadSettings?_dc=1585680545902'
t Verbose: 1220 : 9|19:49:06.1699|e1Bvyx|TMDDBA|imfx v3 API took 0.023s '/api/v3/order-presets?_dc=1585680545945'
t Transfer: 1220 : 9|19:49:06.3731|Nx7cbi|TMDDBA|OAuth: /api/v3/order-presets?_dc=1585680546222
t Transfer: 1220 : 9|19:49:06.3731|Nx7cbi|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:49:06.3731|Nx7cbi|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:49:06.3731|Nx7cbi|TMDDBA| user TMDDBA.
t Verbose: 1220 : 9|19:49:06.3731|Nx7cbi|TMDDBA|OAuth. User logged in: TMDDBA
t Transfer: 1220 : 9|19:49:06.3731|Nx7cbi|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:49:06.3731|Nx7cbi|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:49:06.3731|Nx7cbi|TMDDBA| user TMDDBA.
t Verbose: 1220 : 9|19:49:06.3731|Nx7cbi|TMDDBA|imfx v3 API took 0.009s '/api/v3/order-presets?_dc=1585680546222'
t Transfer: 1220 : 9|19:49:06.3731|xW02CT|TMDDBA|OAuth: /api/v3/checkFilesExist?_dc=1585680546265
t Transfer: 1220 : 9|19:49:06.3731|xW02CT|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:49:06.3731|xW02CT|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:49:06.3731|xW02CT|TMDDBA| user TMDDBA.
t Verbose: 1220 : 9|19:49:06.3731|xW02CT|TMDDBA|OAuth. User logged in: TMDDBA
t Verbose: 1220 : 9|19:49:06.5762|xW02CT|TMDDBA|imfx v3 API took 0.043s '/api/v3/checkFilesExist?_dc=1585680546265'
t Transfer: 1220 : 9|19:49:35.2169|tS3myO|TMDDBA|OAuth: /api/upload/file
t Transfer: 1220 : 9|19:49:35.2169|tS3myO|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:49:35.2169|tS3myO|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:49:35.2169|tS3myO|TMDDBA| user TMDDBA.
t Verbose: 1220 : 9|19:49:35.2169|tS3myO|TMDDBA|OAuth. User logged in: TMDDBA
t Information: 1220 : 9|19:49:35.2169|tS3myO|TMDDBA|UploadMedia start. Version 299000 device 521 filename PMH_s1ep1_pt1 - Copy.scc
t Information: 1220 : 9|19:49:35.2169|tS3myO|TMDDBA| writing to location: \\192.168.120.254\DemoFS\Digital Assets\TEMP_UPLOAD
t Information: 1220 : 9|19:49:35.4199|tS3myO|TMDDBA| preparing xml
t Information: 1220 : 9|19:49:35.4199|tS3myO|TMDDBA| preparing segments
t Information: 1220 : 9|19:49:35.4199|tS3myO|TMDDBA| calling full import api
t Transfer: 1220 : 9|19:49:35.4199|tS3myO|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:49:35.4199|tS3myO|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:49:35.4199|tS3myO|TMDDBA| user TMDDBA.
t Transfer: 1220 : 9|19:49:35.4199|tS3myO|TMDDBA| semaphore enter at: 3/31/2020 7:49:35 PM count: 9 thread: 13
t Information: 1220 : 9|19:49:35.4199|tS3myO|TMDDBA|CallApi. In. Trace-id: xmgrjS Msg: FullImport. User: TMDDBA. Rights: False.
t Information: 1220 : 9|19:49:35.4199|tS3myO|TMDDBA|
internalId
true
299000
MX299071
P
PmH Demo file
AV Clip
|TMD|
0
00:00:00:00
00:00:00:00
00:00:00:00
525 / 29.97DF
22181
PMH_s1ep1_pt1 - Copy.scc
scc
TEMP_UPLOAD
22181
7872
107e4af45bac6
00:00:00:00
00:00:00:00
525 / 29.97DF
Not QCd
t Information: 1220 : 9|19:49:35.6231|tS3myO|TMDDBA|CallApi. Out. Trace-id: xmgrjS 195.0ms.
t Information: 1220 : 9|19:49:35.6231|tS3myO|TMDDBA|10299072
t Transfer: 1220 : 9|19:49:35.6231|tS3myO|TMDDBA| semaphore release at: 3/31/2020 7:49:35 PM count: 9 thread: 13
t Information: 1220 : 9|19:49:35.6231|tS3myO|TMDDBA| got media 299072
t Information: 1220 : 9|19:49:35.6231|tS3myO|TMDDBA| updating media
t Information: 1220 : 9|19:49:35.8262|tS3myO|TMDDBA| media saved
t Information: 1220 : 9|19:49:35.8262|tS3myO|TMDDBA| raising job
t Transfer: 1220 : 9|19:49:35.8262|tS3myO|TMDDBA| semaphore enter at: 3/31/2020 7:49:35 PM count: 9 thread: 13
t Information: 1220 : 9|19:49:35.8262|tS3myO|TMDDBA|CallApi. In. Trace-id: Tw~5lM Msg: RaiseJobAdvanced. User: TMDDBA. Rights: False.
t Information: 1220 : 9|19:49:35.8262|tS3myO|TMDDBA|
1954
299072
i-mediaflex file upload.
t Information: 1220 : 9|19:49:38.0871|tS3myO|TMDDBA|CallApi. Out. Trace-id: Tw~5lM 2339.0ms.
t Information: 1220 : 9|19:49:38.0871|tS3myO|TMDDBA|10108749TMD.108749
t Transfer: 1220 : 9|19:49:38.0871|tS3myO|TMDDBA| semaphore release at: 3/31/2020 7:49:37 PM count: 9 thread: 13
t Information: 1220 : 9|19:49:38.0871|tS3myO|TMDDBA| job raised
t Information: 1220 : 9|19:49:38.0871|tS3myO|TMDDBA| job id 108749, error: ''
t Verbose: 1220 : 9|19:49:38.0871|tS3myO|TMDDBA|imfx v3 API took 2.951s '/api/upload/file'
t Information: 1220 : 9|19:49:44.5918|5VwkOm|TMDDBA|GetUserProfile. Id: 30000
t Transfer: 1220 : 9|19:49:44.5918|5VwkOm|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:49:44.5918|5VwkOm|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:49:44.5918|5VwkOm|TMDDBA| user TMDDBA.
t Transfer: 1220 : 9|19:50:05.3106|8WJVju|TMDDBA|OAuth: /api/v3/search/title?_dc=1585680605234
t Transfer: 1220 : 9|19:50:05.3106|8WJVju|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:50:05.3106|8WJVju|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:50:05.3106|8WJVju|TMDDBA| user TMDDBA.
t Verbose: 1220 : 9|19:50:05.3106|8WJVju|TMDDBA|OAuth. User logged in: TMDDBA
t Information: 1220 : 9|19:50:05.3106|8WJVju|TMDDBA|V3Api.SearchTitles
t Information: 1220 : 9|19:50:05.3106|8WJVju|TMDDBA|V3Api.SearchGeneric
t Transfer: 1220 : 9|19:50:05.3106|8WJVju|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:50:05.3106|8WJVju|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:50:05.3106|8WJVju|TMDDBA| user TMDDBA.
t Transfer: 1220 : 9|19:50:05.3106|8WJVju|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:50:05.3106|8WJVju|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:50:05.3106|8WJVju|TMDDBA| user TMDDBA.
t Information: 1220 : 9|19:50:05.3106|8WJVju|TMDDBA|SearchTitle SQL:
with
v as (
SELECT
abs.*
,decode(ITEM_TYPE,
1010,SER_ABS_ID,
1020,CASE WHEN SER_ABS2_ID > 0 THEN SER_ABS2_ID ELSE SER_ABS_ID END
) xparent_id
FROM TMDDBA.TM_PG_ABS abs
WHERE abs.id in (
select a.id
FROM TMDDBA.TM_PG_ABS a
where ABS_DELETED = 0 AND (INSTR(OWNERS,'|03BO|')>0 OR INSTR(OWNERS,'|03GD|')>0 OR INSTR(OWNERS,'|03GO|')>0 OR INSTR(OWNERS,'|03HA|')>0 OR INSTR(OWNERS,'|03JO|')>0 OR INSTR(OWNERS,'|03LI|')>0 OR INSTR(OWNERS,'|03NB|')>0 OR INSTR(OWNERS,'|03NM|')>0 OR INSTR(OWNERS,'|03NO|')>0 OR INSTR(OWNERS,'|03OR|')>0 OR INSTR(OWNERS,'|03SB|')>0 OR INSTR(OWNERS,'|03SC|')>0 OR INSTR(OWNERS,'|03SE|')>0 OR INSTR(OWNERS,'|03SG|')>0 OR INSTR(OWNERS,'|03SK|')>0 OR INSTR(OWNERS,'|03SM|')>0 OR INSTR(OWNERS,'|03SN|')>0 OR INSTR(OWNERS,'|03SS|')>0 OR INSTR(OWNERS,'|03SY|')>0 OR INSTR(OWNERS,'|03UP|')>0 OR INSTR(OWNERS,'|03VA|')>0 OR INSTR(OWNERS,'|03VB|')>0 OR INSTR(OWNERS,'|03VL|')>0 OR INSTR(OWNERS,'|03VT|')>0 OR INSTR(OWNERS,'|3+ES|')>0 OR INSTR(OWNERS,'|3PD|')>0 OR INSTR(OWNERS,'|3PLV|')>0 OR INSTR(OWNERS,'|AECHD|')>0 OR INSTR(OWNERS,'|AECSD|')>0 OR INSTR(OWNERS,'|AL|')>0 OR INSTR(OWNERS,'|AMAY|')>0 OR INSTR(OWNERS,'|AMC|')>0 OR INSTR(OWNERS,'|ATP|')>0 OR INSTR(OWNERS,'|CENT|')>0 OR INSTR(OWNERS,'|CS|')>0 OR INSTR(OWNERS,'|CTCB|')>0 OR INSTR(OWNERS,'|CTCE|')>0 OR INSTR(OWNERS,'|DAVI|')>0 OR INSTR(OWNERS,'|DMA|')>0 OR INSTR(OWNERS,'|DMF|')>0 OR INSTR(OWNERS,'|DMY|')>0 OR INSTR(OWNERS,'|DTV|')>0 OR INSTR(OWNERS,'|EST|')>0 OR INSTR(OWNERS,'|EUROSPORT|')>0 OR INSTR(OWNERS,'|HDC1|')>0 OR INSTR(OWNERS,'|HDP1|')>0 OR INSTR(OWNERS,'|HDP2|')>0 OR INSTR(OWNERS,'|HUB|')>0 OR INSTR(OWNERS,'|KNL2|')>0 OR INSTR(OWNERS,'|KNVA|')>0 OR INSTR(OWNERS,'|LMH|')>0 OR INSTR(OWNERS,'|LNT|')>0 OR INSTR(OWNERS,'|MBNS|')>0 OR INSTR(OWNERS,'|MED|')>0 OR INSTR(OWNERS,'|MM|')>0 OR INSTR(OWNERS,'|MTG|')>0 OR INSTR(OWNERS,'|NAA|')>0 OR INSTR(OWNERS,'|NICK|')>0 OR INSTR(OWNERS,'|NVA|')>0 OR INSTR(OWNERS,'|OSP|')>0 OR INSTR(OWNERS,'|PBOY|')>0 OR INSTR(OWNERS,'|PMS|')>0 OR INSTR(OWNERS,'|PPL|')>0 OR INSTR(OWNERS,'|PSP|')>0 OR INSTR(OWNERS,'|Play|')>0 OR INSTR(OWNERS,'|RTR|')>0 OR INSTR(OWNERS,'|SFP1|')>0 OR INSTR(OWNERS,'|SFP2|')>0 OR INSTR(OWNERS,'|SPG|')>0 OR INSTR(OWNERS,'|SPTV|')>0 OR INSTR(OWNERS,'|T3LT|')>0 OR INSTR(OWNERS,'|T3LV|')>0 OR INSTR(OWNERS,'|T6LT|')>0 OR INSTR(OWNERS,'|T6LV|')>0 OR INSTR(OWNERS,'|T8LT|')>0 OR INSTR(OWNERS,'|TECHM|')>0 OR INSTR(OWNERS,'|TMD|')>0 OR INSTR(OWNERS,'|TV10|')>0 OR INSTR(OWNERS,'|TV1A|')>0 OR INSTR(OWNERS,'|TV1B|')>0 OR INSTR(OWNERS,'|TV1C|')>0 OR INSTR(OWNERS,'|TV1D|')>0 OR INSTR(OWNERS,'|TV1E|')>0 OR INSTR(OWNERS,'|TV1F|')>0 OR INSTR(OWNERS,'|TV1K|')>0 OR INSTR(OWNERS,'|TV1N|')>0 OR INSTR(OWNERS,'|TV1P|')>0 OR INSTR(OWNERS,'|TV1S|')>0 OR INSTR(OWNERS,'|TV2S|')>0 OR INSTR(OWNERS,'|TV3D|')>0 OR INSTR(OWNERS,'|TV3N|')>0 OR INSTR(OWNERS,'|TV3S|')>0 OR INSTR(OWNERS,'|TV5L|')>0 OR INSTR(OWNERS,'|TV6E|')>0 OR INSTR(OWNERS,'|TV6H|')>0 OR INSTR(OWNERS,'|TV6N|')>0 OR INSTR(OWNERS,'|TV6S|')>0 OR INSTR(OWNERS,'|TV8|')>0 OR INSTR(OWNERS,'|TVAE|')>0 OR INSTR(OWNERS,'|TVDP|')>0 OR INSTR(OWNERS,'|TVPB|')>0 OR INSTR(OWNERS,'|TVPU|')>0 OR INSTR(OWNERS,'|TVSL|')>0 OR INSTR(OWNERS,'|V1G|')>0 OR INSTR(OWNERS,'|V1TZ|')>0 OR INSTR(OWNERS,'|V3H|')>0 OR INSTR(OWNERS,'|V4N|')>0 OR INSTR(OWNERS,'|VEC|')>0 OR INSTR(OWNERS,'|VEPL|')>0 OR INSTR(OWNERS,'|VEPO|')>0 OR INSTR(OWNERS,'|VEXE|')>0 OR INSTR(OWNERS,'|VEXR|')>0 OR INSTR(OWNERS,'|VHIS|')>0 OR INSTR(OWNERS,'|VHPO|')>0 OR INSTR(OWNERS,'|VNC|')>0 OR INSTR(OWNERS,'|VNE|')>0 OR INSTR(OWNERS,'|VNH|')>0 OR INSTR(OWNERS,'|VNHD|')>0 OR INSTR(OWNERS,'|VNPO|')>0 OR INSTR(OWNERS,'|VODD|')>0 OR INSTR(OWNERS,'|VODE|')>0 OR INSTR(OWNERS,'|VODF|')>0 OR INSTR(OWNERS,'|VODN|')>0 OR INSTR(OWNERS,'|VODS|')>0 OR INSTR(OWNERS,'|VS2|')>0 OR INSTR(OWNERS,'|VS3|')>0 OR INSTR(OWNERS,'|VSAT|')>0 OR INSTR(OWNERS,'|VSD|')>0 OR INSTR(OWNERS,'|VSD2|')>0 OR INSTR(OWNERS,'|VSE|')>0 OR INSTR(OWNERS,'|VSG|')>0 OR INSTR(OWNERS,'|VSHD|')>0 OR INSTR(OWNERS,'|VSS|')>0 OR INSTR(OWNERS,'|WCIU|')>0 OR INSTR(OWNERS,'|YLE TV1|')>0 OR INSTR(OWNERS,'|ZTVS|')>0 ) AND (CONTAINS(CTX_TEXT_COL,'pmh') > 0 OR CONTAINS(CTX_IDS_COL,'pmh') > 0 ) AND ROWNUM < 25000 )
)
,v_missing_parent_ids as (
select xparent_id from v
minus
select id from v
)
,v_missing_parents as (
SELECT
distinct a.*
,decode(ITEM_TYPE,
1010,SER_ABS_ID,
1020,CASE WHEN SER_ABS2_ID > 0 THEN SER_ABS2_ID ELSE SER_ABS_ID END
) xparent_id
FROM TMDDBA.TM_PG_ABS a
START WITH ID IN (select xparent_id from v_missing_parent_ids)
CONNECT BY
CASE PRIOR ITEM_TYPE
WHEN 1010 THEN PRIOR SER_ABS_ID
WHEN 1020 THEN
CASE WHEN NVL(PRIOR SER_ABS2_ID, 0) > 0 THEN PRIOR SER_ABS2_ID ELSE PRIOR SER_ABS_ID END
END = ID
)
,v_all as (
select x.*, count(*) over() RowCount
from (
select * from v_missing_parents
union
select * from v
) x
)
,v_top as (
select id
from (select id, row_number()over(order by upper(ser_title),upper(title),ser_num,ser_ep_num, SER_EP_SQ_NUM ) rnk -- sort roots
from v_all
where xparent_id is null)
where rnk between (:page_number-1)*50+1 and :page_number*50
)
,v_tree as (
select level lvl, a.*
from v_all a
start with id in (select id from v_top)
connect by xparent_id = prior ID
order siblings by upper(ser_title),ser_num,ser_ep_num, SER_EP_SQ_NUM,upper(title) -- sort children
)
select *
from v_tree
--where rnk <= 50
t Verbose: 1220 : 9|19:50:05.3106|8WJVju|TMDDBA|imfx v3 API took 0.017s '/api/v3/search/title?_dc=1585680605234'
t Transfer: 1220 : 9|19:50:05.5137|X8uYCl|TMDDBA|OAuth: /api/user-preferences?_dc=1585680605301
t Transfer: 1220 : 9|19:50:05.5137|X8uYCl|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:50:05.5137|X8uYCl|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:50:05.5137|X8uYCl|TMDDBA| user TMDDBA.
t Verbose: 1220 : 9|19:50:05.5137|X8uYCl|TMDDBA|OAuth. User logged in: TMDDBA
t Verbose: 1220 : 9|19:50:05.5137|X8uYCl|TMDDBA|StoreUserDataByKeys..
t Transfer: 1220 : 9|19:50:05.5137|X8uYCl|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:50:05.5137|X8uYCl|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:50:05.5137|X8uYCl|TMDDBA| user TMDDBA.
t Verbose: 1220 : 9|19:50:05.5137|X8uYCl|TMDDBA|imfx v3 API took 0.007s '/api/user-preferences?_dc=1585680605301'
t Transfer: 1220 : 9|19:50:08.1543|adtvfv|TMDDBA|OAuth: /api/v3/search/title?_dc=1585680608063
t Transfer: 1220 : 9|19:50:08.1543|adtvfv|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:50:08.1543|adtvfv|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:50:08.1543|adtvfv|TMDDBA| user TMDDBA.
t Verbose: 1220 : 9|19:50:08.1543|adtvfv|TMDDBA|OAuth. User logged in: TMDDBA
t Information: 1220 : 9|19:50:08.1543|adtvfv|TMDDBA|V3Api.SearchTitles
t Information: 1220 : 9|19:50:08.1543|adtvfv|TMDDBA|V3Api.SearchGeneric
t Transfer: 1220 : 9|19:50:08.1543|adtvfv|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:50:08.1543|adtvfv|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:50:08.1543|adtvfv|TMDDBA| user TMDDBA.
t Transfer: 1220 : 9|19:50:08.1543|adtvfv|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:50:08.1543|adtvfv|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:50:08.1543|adtvfv|TMDDBA| user TMDDBA.
t Information: 1220 : 9|19:50:08.1543|adtvfv|TMDDBA|SearchTitle SQL:
with
v as (
SELECT
abs.*
,decode(ITEM_TYPE,
1010,SER_ABS_ID,
1020,CASE WHEN SER_ABS2_ID > 0 THEN SER_ABS2_ID ELSE SER_ABS_ID END
) xparent_id
FROM TMDDBA.TM_PG_ABS abs
WHERE abs.id in (
select a.id
FROM TMDDBA.TM_PG_ABS a
where ABS_DELETED = 0 AND (INSTR(OWNERS,'|03BO|')>0 OR INSTR(OWNERS,'|03GD|')>0 OR INSTR(OWNERS,'|03GO|')>0 OR INSTR(OWNERS,'|03HA|')>0 OR INSTR(OWNERS,'|03JO|')>0 OR INSTR(OWNERS,'|03LI|')>0 OR INSTR(OWNERS,'|03NB|')>0 OR INSTR(OWNERS,'|03NM|')>0 OR INSTR(OWNERS,'|03NO|')>0 OR INSTR(OWNERS,'|03OR|')>0 OR INSTR(OWNERS,'|03SB|')>0 OR INSTR(OWNERS,'|03SC|')>0 OR INSTR(OWNERS,'|03SE|')>0 OR INSTR(OWNERS,'|03SG|')>0 OR INSTR(OWNERS,'|03SK|')>0 OR INSTR(OWNERS,'|03SM|')>0 OR INSTR(OWNERS,'|03SN|')>0 OR INSTR(OWNERS,'|03SS|')>0 OR INSTR(OWNERS,'|03SY|')>0 OR INSTR(OWNERS,'|03UP|')>0 OR INSTR(OWNERS,'|03VA|')>0 OR INSTR(OWNERS,'|03VB|')>0 OR INSTR(OWNERS,'|03VL|')>0 OR INSTR(OWNERS,'|03VT|')>0 OR INSTR(OWNERS,'|3+ES|')>0 OR INSTR(OWNERS,'|3PD|')>0 OR INSTR(OWNERS,'|3PLV|')>0 OR INSTR(OWNERS,'|AECHD|')>0 OR INSTR(OWNERS,'|AECSD|')>0 OR INSTR(OWNERS,'|AL|')>0 OR INSTR(OWNERS,'|AMAY|')>0 OR INSTR(OWNERS,'|AMC|')>0 OR INSTR(OWNERS,'|ATP|')>0 OR INSTR(OWNERS,'|CENT|')>0 OR INSTR(OWNERS,'|CS|')>0 OR INSTR(OWNERS,'|CTCB|')>0 OR INSTR(OWNERS,'|CTCE|')>0 OR INSTR(OWNERS,'|DAVI|')>0 OR INSTR(OWNERS,'|DMA|')>0 OR INSTR(OWNERS,'|DMF|')>0 OR INSTR(OWNERS,'|DMY|')>0 OR INSTR(OWNERS,'|DTV|')>0 OR INSTR(OWNERS,'|EST|')>0 OR INSTR(OWNERS,'|EUROSPORT|')>0 OR INSTR(OWNERS,'|HDC1|')>0 OR INSTR(OWNERS,'|HDP1|')>0 OR INSTR(OWNERS,'|HDP2|')>0 OR INSTR(OWNERS,'|HUB|')>0 OR INSTR(OWNERS,'|KNL2|')>0 OR INSTR(OWNERS,'|KNVA|')>0 OR INSTR(OWNERS,'|LMH|')>0 OR INSTR(OWNERS,'|LNT|')>0 OR INSTR(OWNERS,'|MBNS|')>0 OR INSTR(OWNERS,'|MED|')>0 OR INSTR(OWNERS,'|MM|')>0 OR INSTR(OWNERS,'|MTG|')>0 OR INSTR(OWNERS,'|NAA|')>0 OR INSTR(OWNERS,'|NICK|')>0 OR INSTR(OWNERS,'|NVA|')>0 OR INSTR(OWNERS,'|OSP|')>0 OR INSTR(OWNERS,'|PBOY|')>0 OR INSTR(OWNERS,'|PMS|')>0 OR INSTR(OWNERS,'|PPL|')>0 OR INSTR(OWNERS,'|PSP|')>0 OR INSTR(OWNERS,'|Play|')>0 OR INSTR(OWNERS,'|RTR|')>0 OR INSTR(OWNERS,'|SFP1|')>0 OR INSTR(OWNERS,'|SFP2|')>0 OR INSTR(OWNERS,'|SPG|')>0 OR INSTR(OWNERS,'|SPTV|')>0 OR INSTR(OWNERS,'|T3LT|')>0 OR INSTR(OWNERS,'|T3LV|')>0 OR INSTR(OWNERS,'|T6LT|')>0 OR INSTR(OWNERS,'|T6LV|')>0 OR INSTR(OWNERS,'|T8LT|')>0 OR INSTR(OWNERS,'|TECHM|')>0 OR INSTR(OWNERS,'|TMD|')>0 OR INSTR(OWNERS,'|TV10|')>0 OR INSTR(OWNERS,'|TV1A|')>0 OR INSTR(OWNERS,'|TV1B|')>0 OR INSTR(OWNERS,'|TV1C|')>0 OR INSTR(OWNERS,'|TV1D|')>0 OR INSTR(OWNERS,'|TV1E|')>0 OR INSTR(OWNERS,'|TV1F|')>0 OR INSTR(OWNERS,'|TV1K|')>0 OR INSTR(OWNERS,'|TV1N|')>0 OR INSTR(OWNERS,'|TV1P|')>0 OR INSTR(OWNERS,'|TV1S|')>0 OR INSTR(OWNERS,'|TV2S|')>0 OR INSTR(OWNERS,'|TV3D|')>0 OR INSTR(OWNERS,'|TV3N|')>0 OR INSTR(OWNERS,'|TV3S|')>0 OR INSTR(OWNERS,'|TV5L|')>0 OR INSTR(OWNERS,'|TV6E|')>0 OR INSTR(OWNERS,'|TV6H|')>0 OR INSTR(OWNERS,'|TV6N|')>0 OR INSTR(OWNERS,'|TV6S|')>0 OR INSTR(OWNERS,'|TV8|')>0 OR INSTR(OWNERS,'|TVAE|')>0 OR INSTR(OWNERS,'|TVDP|')>0 OR INSTR(OWNERS,'|TVPB|')>0 OR INSTR(OWNERS,'|TVPU|')>0 OR INSTR(OWNERS,'|TVSL|')>0 OR INSTR(OWNERS,'|V1G|')>0 OR INSTR(OWNERS,'|V1TZ|')>0 OR INSTR(OWNERS,'|V3H|')>0 OR INSTR(OWNERS,'|V4N|')>0 OR INSTR(OWNERS,'|VEC|')>0 OR INSTR(OWNERS,'|VEPL|')>0 OR INSTR(OWNERS,'|VEPO|')>0 OR INSTR(OWNERS,'|VEXE|')>0 OR INSTR(OWNERS,'|VEXR|')>0 OR INSTR(OWNERS,'|VHIS|')>0 OR INSTR(OWNERS,'|VHPO|')>0 OR INSTR(OWNERS,'|VNC|')>0 OR INSTR(OWNERS,'|VNE|')>0 OR INSTR(OWNERS,'|VNH|')>0 OR INSTR(OWNERS,'|VNHD|')>0 OR INSTR(OWNERS,'|VNPO|')>0 OR INSTR(OWNERS,'|VODD|')>0 OR INSTR(OWNERS,'|VODE|')>0 OR INSTR(OWNERS,'|VODF|')>0 OR INSTR(OWNERS,'|VODN|')>0 OR INSTR(OWNERS,'|VODS|')>0 OR INSTR(OWNERS,'|VS2|')>0 OR INSTR(OWNERS,'|VS3|')>0 OR INSTR(OWNERS,'|VSAT|')>0 OR INSTR(OWNERS,'|VSD|')>0 OR INSTR(OWNERS,'|VSD2|')>0 OR INSTR(OWNERS,'|VSE|')>0 OR INSTR(OWNERS,'|VSG|')>0 OR INSTR(OWNERS,'|VSHD|')>0 OR INSTR(OWNERS,'|VSS|')>0 OR INSTR(OWNERS,'|WCIU|')>0 OR INSTR(OWNERS,'|YLE TV1|')>0 OR INSTR(OWNERS,'|ZTVS|')>0 ) AND (CONTAINS(CTX_TEXT_COL,'pmh') > 0 OR CONTAINS(CTX_IDS_COL,'pmh') > 0 ) AND ROWNUM < 25000 )
)
,v_missing_parent_ids as (
select xparent_id from v
minus
select id from v
)
,v_missing_parents as (
SELECT
distinct a.*
,decode(ITEM_TYPE,
1010,SER_ABS_ID,
1020,CASE WHEN SER_ABS2_ID > 0 THEN SER_ABS2_ID ELSE SER_ABS_ID END
) xparent_id
FROM TMDDBA.TM_PG_ABS a
START WITH ID IN (select xparent_id from v_missing_parent_ids)
CONNECT BY
CASE PRIOR ITEM_TYPE
WHEN 1010 THEN PRIOR SER_ABS_ID
WHEN 1020 THEN
CASE WHEN NVL(PRIOR SER_ABS2_ID, 0) > 0 THEN PRIOR SER_ABS2_ID ELSE PRIOR SER_ABS_ID END
END = ID
)
,v_all as (
select x.*, count(*) over() RowCount
from (
select * from v_missing_parents
union
select * from v
) x
)
,v_top as (
select id
from (select id, row_number()over(order by upper(ser_title),upper(title),ser_num,ser_ep_num, SER_EP_SQ_NUM ) rnk -- sort roots
from v_all
where xparent_id is null)
where rnk between (:page_number-1)*50+1 and :page_number*50
)
,v_tree as (
select level lvl, a.*
from v_all a
start with id in (select id from v_top)
connect by xparent_id = prior ID
order siblings by upper(ser_title),ser_num,ser_ep_num, SER_EP_SQ_NUM,upper(title) -- sort children
)
select *
from v_tree
--where rnk <= 50
t Verbose: 1220 : 9|19:50:08.1543|adtvfv|TMDDBA|imfx v3 API took 0.014s '/api/v3/search/title?_dc=1585680608063'
t Transfer: 1220 : 9|19:50:08.3574|oLxEPM|TMDDBA|OAuth: /api/user-preferences?_dc=1585680608120
t Transfer: 1220 : 9|19:50:08.3574|oLxEPM|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:50:08.3574|oLxEPM|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:50:08.3574|oLxEPM|TMDDBA| user TMDDBA.
t Verbose: 1220 : 9|19:50:08.3574|oLxEPM|TMDDBA|OAuth. User logged in: TMDDBA
t Verbose: 1220 : 9|19:50:08.3574|oLxEPM|TMDDBA|StoreUserDataByKeys..
t Transfer: 1220 : 9|19:50:08.3574|oLxEPM|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:50:08.3574|oLxEPM|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:50:08.3574|oLxEPM|TMDDBA| user TMDDBA.
t Verbose: 1220 : 9|19:50:08.3574|oLxEPM|TMDDBA|imfx v3 API took 0.007s '/api/user-preferences?_dc=1585680608120'
t Transfer: 1220 : 9|19:50:10.1856|rGAzxG|TMDDBA|OAuth: /api/v3/search-suggestion/?_dc=1585680609999
t Transfer: 1220 : 9|19:50:10.1856|rGAzxG|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:50:10.1856|rGAzxG|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:50:10.1856|rGAzxG|TMDDBA| user TMDDBA.
t Verbose: 1220 : 9|19:50:10.1856|rGAzxG|TMDDBA|OAuth. User logged in: TMDDBA
t Transfer: 1220 : 9|19:50:10.1856|rGAzxG|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:50:10.1856|rGAzxG|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:50:10.1856|rGAzxG|TMDDBA| user TMDDBA.
t Verbose: 1220 : 9|19:50:10.1856|rGAzxG|TMDDBA|imfx v3 API took 0.019s '/api/v3/search-suggestion/?_dc=1585680609999'
t Transfer: 1220 : 9|19:50:10.3887|XMfsbd|TMDDBA|OAuth: /api/v3/search/title?_dc=1585680610309
t Transfer: 1220 : 9|19:50:10.3887|XMfsbd|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:50:10.3887|XMfsbd|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:50:10.3887|XMfsbd|TMDDBA| user TMDDBA.
t Verbose: 1220 : 9|19:50:10.3887|XMfsbd|TMDDBA|OAuth. User logged in: TMDDBA
t Information: 1220 : 9|19:50:10.3887|XMfsbd|TMDDBA|V3Api.SearchTitles
t Information: 1220 : 9|19:50:10.3887|XMfsbd|TMDDBA|V3Api.SearchGeneric
t Transfer: 1220 : 9|19:50:10.3887|XMfsbd|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:50:10.3887|XMfsbd|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:50:10.3887|XMfsbd|TMDDBA| user TMDDBA.
t Transfer: 1220 : 9|19:50:10.3887|XMfsbd|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:50:10.3887|XMfsbd|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:50:10.3887|XMfsbd|TMDDBA| user TMDDBA.
t Information: 1220 : 9|19:50:10.3887|XMfsbd|TMDDBA|SearchTitle SQL:
with
v as (
SELECT
abs.*
,decode(ITEM_TYPE,
1010,SER_ABS_ID,
1020,CASE WHEN SER_ABS2_ID > 0 THEN SER_ABS2_ID ELSE SER_ABS_ID END
) xparent_id
FROM TMDDBA.TM_PG_ABS abs
WHERE abs.id in (
select a.id
FROM TMDDBA.TM_PG_ABS a
where ABS_DELETED = 0 AND (INSTR(OWNERS,'|03BO|')>0 OR INSTR(OWNERS,'|03GD|')>0 OR INSTR(OWNERS,'|03GO|')>0 OR INSTR(OWNERS,'|03HA|')>0 OR INSTR(OWNERS,'|03JO|')>0 OR INSTR(OWNERS,'|03LI|')>0 OR INSTR(OWNERS,'|03NB|')>0 OR INSTR(OWNERS,'|03NM|')>0 OR INSTR(OWNERS,'|03NO|')>0 OR INSTR(OWNERS,'|03OR|')>0 OR INSTR(OWNERS,'|03SB|')>0 OR INSTR(OWNERS,'|03SC|')>0 OR INSTR(OWNERS,'|03SE|')>0 OR INSTR(OWNERS,'|03SG|')>0 OR INSTR(OWNERS,'|03SK|')>0 OR INSTR(OWNERS,'|03SM|')>0 OR INSTR(OWNERS,'|03SN|')>0 OR INSTR(OWNERS,'|03SS|')>0 OR INSTR(OWNERS,'|03SY|')>0 OR INSTR(OWNERS,'|03UP|')>0 OR INSTR(OWNERS,'|03VA|')>0 OR INSTR(OWNERS,'|03VB|')>0 OR INSTR(OWNERS,'|03VL|')>0 OR INSTR(OWNERS,'|03VT|')>0 OR INSTR(OWNERS,'|3+ES|')>0 OR INSTR(OWNERS,'|3PD|')>0 OR INSTR(OWNERS,'|3PLV|')>0 OR INSTR(OWNERS,'|AECHD|')>0 OR INSTR(OWNERS,'|AECSD|')>0 OR INSTR(OWNERS,'|AL|')>0 OR INSTR(OWNERS,'|AMAY|')>0 OR INSTR(OWNERS,'|AMC|')>0 OR INSTR(OWNERS,'|ATP|')>0 OR INSTR(OWNERS,'|CENT|')>0 OR INSTR(OWNERS,'|CS|')>0 OR INSTR(OWNERS,'|CTCB|')>0 OR INSTR(OWNERS,'|CTCE|')>0 OR INSTR(OWNERS,'|DAVI|')>0 OR INSTR(OWNERS,'|DMA|')>0 OR INSTR(OWNERS,'|DMF|')>0 OR INSTR(OWNERS,'|DMY|')>0 OR INSTR(OWNERS,'|DTV|')>0 OR INSTR(OWNERS,'|EST|')>0 OR INSTR(OWNERS,'|EUROSPORT|')>0 OR INSTR(OWNERS,'|HDC1|')>0 OR INSTR(OWNERS,'|HDP1|')>0 OR INSTR(OWNERS,'|HDP2|')>0 OR INSTR(OWNERS,'|HUB|')>0 OR INSTR(OWNERS,'|KNL2|')>0 OR INSTR(OWNERS,'|KNVA|')>0 OR INSTR(OWNERS,'|LMH|')>0 OR INSTR(OWNERS,'|LNT|')>0 OR INSTR(OWNERS,'|MBNS|')>0 OR INSTR(OWNERS,'|MED|')>0 OR INSTR(OWNERS,'|MM|')>0 OR INSTR(OWNERS,'|MTG|')>0 OR INSTR(OWNERS,'|NAA|')>0 OR INSTR(OWNERS,'|NICK|')>0 OR INSTR(OWNERS,'|NVA|')>0 OR INSTR(OWNERS,'|OSP|')>0 OR INSTR(OWNERS,'|PBOY|')>0 OR INSTR(OWNERS,'|PMS|')>0 OR INSTR(OWNERS,'|PPL|')>0 OR INSTR(OWNERS,'|PSP|')>0 OR INSTR(OWNERS,'|Play|')>0 OR INSTR(OWNERS,'|RTR|')>0 OR INSTR(OWNERS,'|SFP1|')>0 OR INSTR(OWNERS,'|SFP2|')>0 OR INSTR(OWNERS,'|SPG|')>0 OR INSTR(OWNERS,'|SPTV|')>0 OR INSTR(OWNERS,'|T3LT|')>0 OR INSTR(OWNERS,'|T3LV|')>0 OR INSTR(OWNERS,'|T6LT|')>0 OR INSTR(OWNERS,'|T6LV|')>0 OR INSTR(OWNERS,'|T8LT|')>0 OR INSTR(OWNERS,'|TECHM|')>0 OR INSTR(OWNERS,'|TMD|')>0 OR INSTR(OWNERS,'|TV10|')>0 OR INSTR(OWNERS,'|TV1A|')>0 OR INSTR(OWNERS,'|TV1B|')>0 OR INSTR(OWNERS,'|TV1C|')>0 OR INSTR(OWNERS,'|TV1D|')>0 OR INSTR(OWNERS,'|TV1E|')>0 OR INSTR(OWNERS,'|TV1F|')>0 OR INSTR(OWNERS,'|TV1K|')>0 OR INSTR(OWNERS,'|TV1N|')>0 OR INSTR(OWNERS,'|TV1P|')>0 OR INSTR(OWNERS,'|TV1S|')>0 OR INSTR(OWNERS,'|TV2S|')>0 OR INSTR(OWNERS,'|TV3D|')>0 OR INSTR(OWNERS,'|TV3N|')>0 OR INSTR(OWNERS,'|TV3S|')>0 OR INSTR(OWNERS,'|TV5L|')>0 OR INSTR(OWNERS,'|TV6E|')>0 OR INSTR(OWNERS,'|TV6H|')>0 OR INSTR(OWNERS,'|TV6N|')>0 OR INSTR(OWNERS,'|TV6S|')>0 OR INSTR(OWNERS,'|TV8|')>0 OR INSTR(OWNERS,'|TVAE|')>0 OR INSTR(OWNERS,'|TVDP|')>0 OR INSTR(OWNERS,'|TVPB|')>0 OR INSTR(OWNERS,'|TVPU|')>0 OR INSTR(OWNERS,'|TVSL|')>0 OR INSTR(OWNERS,'|V1G|')>0 OR INSTR(OWNERS,'|V1TZ|')>0 OR INSTR(OWNERS,'|V3H|')>0 OR INSTR(OWNERS,'|V4N|')>0 OR INSTR(OWNERS,'|VEC|')>0 OR INSTR(OWNERS,'|VEPL|')>0 OR INSTR(OWNERS,'|VEPO|')>0 OR INSTR(OWNERS,'|VEXE|')>0 OR INSTR(OWNERS,'|VEXR|')>0 OR INSTR(OWNERS,'|VHIS|')>0 OR INSTR(OWNERS,'|VHPO|')>0 OR INSTR(OWNERS,'|VNC|')>0 OR INSTR(OWNERS,'|VNE|')>0 OR INSTR(OWNERS,'|VNH|')>0 OR INSTR(OWNERS,'|VNHD|')>0 OR INSTR(OWNERS,'|VNPO|')>0 OR INSTR(OWNERS,'|VODD|')>0 OR INSTR(OWNERS,'|VODE|')>0 OR INSTR(OWNERS,'|VODF|')>0 OR INSTR(OWNERS,'|VODN|')>0 OR INSTR(OWNERS,'|VODS|')>0 OR INSTR(OWNERS,'|VS2|')>0 OR INSTR(OWNERS,'|VS3|')>0 OR INSTR(OWNERS,'|VSAT|')>0 OR INSTR(OWNERS,'|VSD|')>0 OR INSTR(OWNERS,'|VSD2|')>0 OR INSTR(OWNERS,'|VSE|')>0 OR INSTR(OWNERS,'|VSG|')>0 OR INSTR(OWNERS,'|VSHD|')>0 OR INSTR(OWNERS,'|VSS|')>0 OR INSTR(OWNERS,'|WCIU|')>0 OR INSTR(OWNERS,'|YLE TV1|')>0 OR INSTR(OWNERS,'|ZTVS|')>0 ) AND (CONTAINS(CTX_TEXT_COL,'pmhk') > 0 OR CONTAINS(CTX_IDS_COL,'pmhk') > 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 : 9|19:50:10.5918|XMfsbd|TMDDBA|imfx v3 API took 0.159s '/api/v3/search/title?_dc=1585680610309'
t Transfer: 1220 : 9|19:50:10.5918|VALdv5|TMDDBA|OAuth: /api/user-preferences?_dc=1585680610516
t Transfer: 1220 : 9|19:50:10.5918|VALdv5|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:50:10.5918|VALdv5|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:50:10.5918|VALdv5|TMDDBA| user TMDDBA.
t Verbose: 1220 : 9|19:50:10.5918|VALdv5|TMDDBA|OAuth. User logged in: TMDDBA
t Verbose: 1220 : 9|19:50:10.5918|VALdv5|TMDDBA|StoreUserDataByKeys..
t Transfer: 1220 : 9|19:50:10.5918|VALdv5|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:50:10.5918|VALdv5|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:50:10.5918|VALdv5|TMDDBA| user TMDDBA.
t Verbose: 1220 : 9|19:50:10.5918|VALdv5|TMDDBA|imfx v3 API took 0.006s '/api/user-preferences?_dc=1585680610516'
t Transfer: 1220 : 9|19:50:11.4043|0cT~js|TMDDBA|OAuth: /api/v3/search-suggestion/?_dc=1585680611273
t Transfer: 1220 : 9|19:50:11.4043|0cT~js|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:50:11.4043|0cT~js|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:50:11.4043|0cT~js|TMDDBA| user TMDDBA.
t Verbose: 1220 : 9|19:50:11.4043|0cT~js|TMDDBA|OAuth. User logged in: TMDDBA
t Transfer: 1220 : 9|19:50:11.4043|0cT~js|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:50:11.4043|0cT~js|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:50:11.4043|0cT~js|TMDDBA| user TMDDBA.
t Verbose: 1220 : 9|19:50:11.4043|0cT~js|TMDDBA|imfx v3 API took 0.006s '/api/v3/search-suggestion/?_dc=1585680611273'
t Transfer: 1220 : 9|19:50:11.8106|px1uJ2|TMDDBA|OAuth: /api/v3/search/title?_dc=1585680611615
t Transfer: 1220 : 9|19:50:11.8106|px1uJ2|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:50:11.8106|px1uJ2|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:50:11.8106|px1uJ2|TMDDBA| user TMDDBA.
t Verbose: 1220 : 9|19:50:11.8106|px1uJ2|TMDDBA|OAuth. User logged in: TMDDBA
t Information: 1220 : 9|19:50:11.8106|px1uJ2|TMDDBA|V3Api.SearchTitles
t Information: 1220 : 9|19:50:11.8106|px1uJ2|TMDDBA|V3Api.SearchGeneric
t Transfer: 1220 : 9|19:50:11.8106|px1uJ2|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:50:11.8106|px1uJ2|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:50:11.8106|px1uJ2|TMDDBA| user TMDDBA.
t Transfer: 1220 : 9|19:50:11.8106|px1uJ2|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:50:11.8106|px1uJ2|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:50:11.8106|px1uJ2|TMDDBA| user TMDDBA.
t Information: 1220 : 9|19:50:11.8106|px1uJ2|TMDDBA|SearchTitle SQL:
with
v as (
SELECT
abs.*
,decode(ITEM_TYPE,
1010,SER_ABS_ID,
1020,CASE WHEN SER_ABS2_ID > 0 THEN SER_ABS2_ID ELSE SER_ABS_ID END
) xparent_id
FROM TMDDBA.TM_PG_ABS abs
WHERE abs.id in (
select a.id
FROM TMDDBA.TM_PG_ABS a
where ABS_DELETED = 0 AND (INSTR(OWNERS,'|03BO|')>0 OR INSTR(OWNERS,'|03GD|')>0 OR INSTR(OWNERS,'|03GO|')>0 OR INSTR(OWNERS,'|03HA|')>0 OR INSTR(OWNERS,'|03JO|')>0 OR INSTR(OWNERS,'|03LI|')>0 OR INSTR(OWNERS,'|03NB|')>0 OR INSTR(OWNERS,'|03NM|')>0 OR INSTR(OWNERS,'|03NO|')>0 OR INSTR(OWNERS,'|03OR|')>0 OR INSTR(OWNERS,'|03SB|')>0 OR INSTR(OWNERS,'|03SC|')>0 OR INSTR(OWNERS,'|03SE|')>0 OR INSTR(OWNERS,'|03SG|')>0 OR INSTR(OWNERS,'|03SK|')>0 OR INSTR(OWNERS,'|03SM|')>0 OR INSTR(OWNERS,'|03SN|')>0 OR INSTR(OWNERS,'|03SS|')>0 OR INSTR(OWNERS,'|03SY|')>0 OR INSTR(OWNERS,'|03UP|')>0 OR INSTR(OWNERS,'|03VA|')>0 OR INSTR(OWNERS,'|03VB|')>0 OR INSTR(OWNERS,'|03VL|')>0 OR INSTR(OWNERS,'|03VT|')>0 OR INSTR(OWNERS,'|3+ES|')>0 OR INSTR(OWNERS,'|3PD|')>0 OR INSTR(OWNERS,'|3PLV|')>0 OR INSTR(OWNERS,'|AECHD|')>0 OR INSTR(OWNERS,'|AECSD|')>0 OR INSTR(OWNERS,'|AL|')>0 OR INSTR(OWNERS,'|AMAY|')>0 OR INSTR(OWNERS,'|AMC|')>0 OR INSTR(OWNERS,'|ATP|')>0 OR INSTR(OWNERS,'|CENT|')>0 OR INSTR(OWNERS,'|CS|')>0 OR INSTR(OWNERS,'|CTCB|')>0 OR INSTR(OWNERS,'|CTCE|')>0 OR INSTR(OWNERS,'|DAVI|')>0 OR INSTR(OWNERS,'|DMA|')>0 OR INSTR(OWNERS,'|DMF|')>0 OR INSTR(OWNERS,'|DMY|')>0 OR INSTR(OWNERS,'|DTV|')>0 OR INSTR(OWNERS,'|EST|')>0 OR INSTR(OWNERS,'|EUROSPORT|')>0 OR INSTR(OWNERS,'|HDC1|')>0 OR INSTR(OWNERS,'|HDP1|')>0 OR INSTR(OWNERS,'|HDP2|')>0 OR INSTR(OWNERS,'|HUB|')>0 OR INSTR(OWNERS,'|KNL2|')>0 OR INSTR(OWNERS,'|KNVA|')>0 OR INSTR(OWNERS,'|LMH|')>0 OR INSTR(OWNERS,'|LNT|')>0 OR INSTR(OWNERS,'|MBNS|')>0 OR INSTR(OWNERS,'|MED|')>0 OR INSTR(OWNERS,'|MM|')>0 OR INSTR(OWNERS,'|MTG|')>0 OR INSTR(OWNERS,'|NAA|')>0 OR INSTR(OWNERS,'|NICK|')>0 OR INSTR(OWNERS,'|NVA|')>0 OR INSTR(OWNERS,'|OSP|')>0 OR INSTR(OWNERS,'|PBOY|')>0 OR INSTR(OWNERS,'|PMS|')>0 OR INSTR(OWNERS,'|PPL|')>0 OR INSTR(OWNERS,'|PSP|')>0 OR INSTR(OWNERS,'|Play|')>0 OR INSTR(OWNERS,'|RTR|')>0 OR INSTR(OWNERS,'|SFP1|')>0 OR INSTR(OWNERS,'|SFP2|')>0 OR INSTR(OWNERS,'|SPG|')>0 OR INSTR(OWNERS,'|SPTV|')>0 OR INSTR(OWNERS,'|T3LT|')>0 OR INSTR(OWNERS,'|T3LV|')>0 OR INSTR(OWNERS,'|T6LT|')>0 OR INSTR(OWNERS,'|T6LV|')>0 OR INSTR(OWNERS,'|T8LT|')>0 OR INSTR(OWNERS,'|TECHM|')>0 OR INSTR(OWNERS,'|TMD|')>0 OR INSTR(OWNERS,'|TV10|')>0 OR INSTR(OWNERS,'|TV1A|')>0 OR INSTR(OWNERS,'|TV1B|')>0 OR INSTR(OWNERS,'|TV1C|')>0 OR INSTR(OWNERS,'|TV1D|')>0 OR INSTR(OWNERS,'|TV1E|')>0 OR INSTR(OWNERS,'|TV1F|')>0 OR INSTR(OWNERS,'|TV1K|')>0 OR INSTR(OWNERS,'|TV1N|')>0 OR INSTR(OWNERS,'|TV1P|')>0 OR INSTR(OWNERS,'|TV1S|')>0 OR INSTR(OWNERS,'|TV2S|')>0 OR INSTR(OWNERS,'|TV3D|')>0 OR INSTR(OWNERS,'|TV3N|')>0 OR INSTR(OWNERS,'|TV3S|')>0 OR INSTR(OWNERS,'|TV5L|')>0 OR INSTR(OWNERS,'|TV6E|')>0 OR INSTR(OWNERS,'|TV6H|')>0 OR INSTR(OWNERS,'|TV6N|')>0 OR INSTR(OWNERS,'|TV6S|')>0 OR INSTR(OWNERS,'|TV8|')>0 OR INSTR(OWNERS,'|TVAE|')>0 OR INSTR(OWNERS,'|TVDP|')>0 OR INSTR(OWNERS,'|TVPB|')>0 OR INSTR(OWNERS,'|TVPU|')>0 OR INSTR(OWNERS,'|TVSL|')>0 OR INSTR(OWNERS,'|V1G|')>0 OR INSTR(OWNERS,'|V1TZ|')>0 OR INSTR(OWNERS,'|V3H|')>0 OR INSTR(OWNERS,'|V4N|')>0 OR INSTR(OWNERS,'|VEC|')>0 OR INSTR(OWNERS,'|VEPL|')>0 OR INSTR(OWNERS,'|VEPO|')>0 OR INSTR(OWNERS,'|VEXE|')>0 OR INSTR(OWNERS,'|VEXR|')>0 OR INSTR(OWNERS,'|VHIS|')>0 OR INSTR(OWNERS,'|VHPO|')>0 OR INSTR(OWNERS,'|VNC|')>0 OR INSTR(OWNERS,'|VNE|')>0 OR INSTR(OWNERS,'|VNH|')>0 OR INSTR(OWNERS,'|VNHD|')>0 OR INSTR(OWNERS,'|VNPO|')>0 OR INSTR(OWNERS,'|VODD|')>0 OR INSTR(OWNERS,'|VODE|')>0 OR INSTR(OWNERS,'|VODF|')>0 OR INSTR(OWNERS,'|VODN|')>0 OR INSTR(OWNERS,'|VODS|')>0 OR INSTR(OWNERS,'|VS2|')>0 OR INSTR(OWNERS,'|VS3|')>0 OR INSTR(OWNERS,'|VSAT|')>0 OR INSTR(OWNERS,'|VSD|')>0 OR INSTR(OWNERS,'|VSD2|')>0 OR INSTR(OWNERS,'|VSE|')>0 OR INSTR(OWNERS,'|VSG|')>0 OR INSTR(OWNERS,'|VSHD|')>0 OR INSTR(OWNERS,'|VSS|')>0 OR INSTR(OWNERS,'|WCIU|')>0 OR INSTR(OWNERS,'|YLE TV1|')>0 OR INSTR(OWNERS,'|ZTVS|')>0 ) AND (CONTAINS(CTX_TEXT_COL,'pmh') > 0 OR CONTAINS(CTX_IDS_COL,'pmh') > 0 ) AND ROWNUM < 25000 )
)
,v_missing_parent_ids as (
select xparent_id from v
minus
select id from v
)
,v_missing_parents as (
SELECT
distinct a.*
,decode(ITEM_TYPE,
1010,SER_ABS_ID,
1020,CASE WHEN SER_ABS2_ID > 0 THEN SER_ABS2_ID ELSE SER_ABS_ID END
) xparent_id
FROM TMDDBA.TM_PG_ABS a
START WITH ID IN (select xparent_id from v_missing_parent_ids)
CONNECT BY
CASE PRIOR ITEM_TYPE
WHEN 1010 THEN PRIOR SER_ABS_ID
WHEN 1020 THEN
CASE WHEN NVL(PRIOR SER_ABS2_ID, 0) > 0 THEN PRIOR SER_ABS2_ID ELSE PRIOR SER_ABS_ID END
END = ID
)
,v_all as (
select x.*, count(*) over() RowCount
from (
select * from v_missing_parents
union
select * from v
) x
)
,v_top as (
select id
from (select id, row_number()over(order by upper(ser_title),upper(title),ser_num,ser_ep_num, SER_EP_SQ_NUM ) rnk -- sort roots
from v_all
where xparent_id is null)
where rnk between (:page_number-1)*50+1 and :page_number*50
)
,v_tree as (
select level lvl, a.*
from v_all a
start with id in (select id from v_top)
connect by xparent_id = prior ID
order siblings by upper(ser_title),ser_num,ser_ep_num, SER_EP_SQ_NUM,upper(title) -- sort children
)
select *
from v_tree
--where rnk <= 50
t Verbose: 1220 : 9|19:50:11.8106|px1uJ2|TMDDBA|imfx v3 API took 0.014s '/api/v3/search/title?_dc=1585680611615'
t Transfer: 1220 : 9|19:50:11.8106|cvCiaX|TMDDBA|OAuth: /api/v3/title/298999/versions?_dc=1585680611671
t Transfer: 1220 : 9|19:50:11.8106|cvCiaX|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:50:11.8106|cvCiaX|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:50:11.8106|cvCiaX|TMDDBA| user TMDDBA.
t Verbose: 1220 : 9|19:50:11.8106|cvCiaX|TMDDBA|OAuth. User logged in: TMDDBA
t Information: 1220 : 9|19:50:11.8106|cvCiaX|TMDDBA|V3Api.SearchGeneric
t Transfer: 1220 : 9|19:50:11.8106|cvCiaX|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:50:11.8106|cvCiaX|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:50:11.8106|cvCiaX|TMDDBA| user TMDDBA.
t Transfer: 1220 : 9|19:50:11.8106|cvCiaX|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:50:11.8106|cvCiaX|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:50:11.8106|cvCiaX|TMDDBA| user TMDDBA.
t Information: 1220 : 9|19:50:11.8106|cvCiaX|TMDDBA|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=298999 AND (INSTR(m.OWNERS,'|03BO|')>0 OR INSTR(m.OWNERS,'|03GD|')>0 OR INSTR(m.OWNERS,'|03GO|')>0 OR INSTR(m.OWNERS,'|03HA|')>0 OR INSTR(m.OWNERS,'|03JO|')>0 OR INSTR(m.OWNERS,'|03LI|')>0 OR INSTR(m.OWNERS,'|03NB|')>0 OR INSTR(m.OWNERS,'|03NM|')>0 OR INSTR(m.OWNERS,'|03NO|')>0 OR INSTR(m.OWNERS,'|03OR|')>0 OR INSTR(m.OWNERS,'|03SB|')>0 OR INSTR(m.OWNERS,'|03SC|')>0 OR INSTR(m.OWNERS,'|03SE|')>0 OR INSTR(m.OWNERS,'|03SG|')>0 OR INSTR(m.OWNERS,'|03SK|')>0 OR INSTR(m.OWNERS,'|03SM|')>0 OR INSTR(m.OWNERS,'|03SN|')>0 OR INSTR(m.OWNERS,'|03SS|')>0 OR INSTR(m.OWNERS,'|03SY|')>0 OR INSTR(m.OWNERS,'|03UP|')>0 OR INSTR(m.OWNERS,'|03VA|')>0 OR INSTR(m.OWNERS,'|03VB|')>0 OR INSTR(m.OWNERS,'|03VL|')>0 OR INSTR(m.OWNERS,'|03VT|')>0 OR INSTR(m.OWNERS,'|3+ES|')>0 OR INSTR(m.OWNERS,'|3PD|')>0 OR INSTR(m.OWNERS,'|3PLV|')>0 OR INSTR(m.OWNERS,'|AECHD|')>0 OR INSTR(m.OWNERS,'|AECSD|')>0 OR INSTR(m.OWNERS,'|AL|')>0 OR INSTR(m.OWNERS,'|AMAY|')>0 OR INSTR(m.OWNERS,'|AMC|')>0 OR INSTR(m.OWNERS,'|ATP|')>0 OR INSTR(m.OWNERS,'|CENT|')>0 OR INSTR(m.OWNERS,'|CS|')>0 OR INSTR(m.OWNERS,'|CTCB|')>0 OR INSTR(m.OWNERS,'|CTCE|')>0 OR INSTR(m.OWNERS,'|DAVI|')>0 OR INSTR(m.OWNERS,'|DMA|')>0 OR INSTR(m.OWNERS,'|DMF|')>0 OR INSTR(m.OWNERS,'|DMY|')>0 OR INSTR(m.OWNERS,'|DTV|')>0 OR INSTR(m.OWNERS,'|EST|')>0 OR INSTR(m.OWNERS,'|EUROSPORT|')>0 OR INSTR(m.OWNERS,'|HDC1|')>0 OR INSTR(m.OWNERS,'|HDP1|')>0 OR INSTR(m.OWNERS,'|HDP2|')>0 OR INSTR(m.OWNERS,'|HUB|')>0 OR INSTR(m.OWNERS,'|KNL2|')>0 OR INSTR(m.OWNERS,'|KNVA|')>0 OR INSTR(m.OWNERS,'|LMH|')>0 OR INSTR(m.OWNERS,'|LNT|')>0 OR INSTR(m.OWNERS,'|MBNS|')>0 OR INSTR(m.OWNERS,'|MED|')>0 OR INSTR(m.OWNERS,'|MM|')>0 OR INSTR(m.OWNERS,'|MTG|')>0 OR INSTR(m.OWNERS,'|NAA|')>0 OR INSTR(m.OWNERS,'|NICK|')>0 OR INSTR(m.OWNERS,'|NVA|')>0 OR INSTR(m.OWNERS,'|OSP|')>0 OR INSTR(m.OWNERS,'|PBOY|')>0 OR INSTR(m.OWNERS,'|PMS|')>0 OR INSTR(m.OWNERS,'|PPL|')>0 OR INSTR(m.OWNERS,'|PSP|')>0 OR INSTR(m.OWNERS,'|Play|')>0 OR INSTR(m.OWNERS,'|RTR|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|SPG|')>0 OR INSTR(m.OWNERS,'|SPTV|')>0 OR INSTR(m.OWNERS,'|T3LT|')>0 OR INSTR(m.OWNERS,'|T3LV|')>0 OR INSTR(m.OWNERS,'|T6LT|')>0 OR INSTR(m.OWNERS,'|T6LV|')>0 OR INSTR(m.OWNERS,'|T8LT|')>0 OR INSTR(m.OWNERS,'|TECHM|')>0 OR INSTR(m.OWNERS,'|TMD|')>0 OR INSTR(m.OWNERS,'|TV10|')>0 OR INSTR(m.OWNERS,'|TV1A|')>0 OR INSTR(m.OWNERS,'|TV1B|')>0 OR INSTR(m.OWNERS,'|TV1C|')>0 OR INSTR(m.OWNERS,'|TV1D|')>0 OR INSTR(m.OWNERS,'|TV1E|')>0 OR INSTR(m.OWNERS,'|TV1F|')>0 OR INSTR(m.OWNERS,'|TV1K|')>0 OR INSTR(m.OWNERS,'|TV1N|')>0 OR INSTR(m.OWNERS,'|TV1P|')>0 OR INSTR(m.OWNERS,'|TV1S|')>0 OR INSTR(m.OWNERS,'|TV2S|')>0 OR INSTR(m.OWNERS,'|TV3D|')>0 OR INSTR(m.OWNERS,'|TV3N|')>0 OR INSTR(m.OWNERS,'|TV3S|')>0 OR INSTR(m.OWNERS,'|TV5L|')>0 OR INSTR(m.OWNERS,'|TV6E|')>0 OR INSTR(m.OWNERS,'|TV6H|')>0 OR INSTR(m.OWNERS,'|TV6N|')>0 OR INSTR(m.OWNERS,'|TV6S|')>0 OR INSTR(m.OWNERS,'|TV8|')>0 OR INSTR(m.OWNERS,'|TVAE|')>0 OR INSTR(m.OWNERS,'|TVDP|')>0 OR INSTR(m.OWNERS,'|TVPB|')>0 OR INSTR(m.OWNERS,'|TVPU|')>0 OR INSTR(m.OWNERS,'|TVSL|')>0 OR INSTR(m.OWNERS,'|V1G|')>0 OR INSTR(m.OWNERS,'|V1TZ|')>0 OR INSTR(m.OWNERS,'|V3H|')>0 OR INSTR(m.OWNERS,'|V4N|')>0 OR INSTR(m.OWNERS,'|VEC|')>0 OR INSTR(m.OWNERS,'|VEPL|')>0 OR INSTR(m.OWNERS,'|VEPO|')>0 OR INSTR(m.OWNERS,'|VEXE|')>0 OR INSTR(m.OWNERS,'|VEXR|')>0 OR INSTR(m.OWNERS,'|VHIS|')>0 OR INSTR(m.OWNERS,'|VHPO|')>0 OR INSTR(m.OWNERS,'|VNC|')>0 OR INSTR(m.OWNERS,'|VNE|')>0 OR INSTR(m.OWNERS,'|VNH|')>0 OR INSTR(m.OWNERS,'|VNHD|')>0 OR INSTR(m.OWNERS,'|VNPO|')>0 OR INSTR(m.OWNERS,'|VODD|')>0 OR INSTR(m.OWNERS,'|VODE|')>0 OR INSTR(m.OWNERS,'|VODF|')>0 OR INSTR(m.OWNERS,'|VODN|')>0 OR INSTR(m.OWNERS,'|VODS|')>0 OR INSTR(m.OWNERS,'|VS2|')>0 OR INSTR(m.OWNERS,'|VS3|')>0 OR INSTR(m.OWNERS,'|VSAT|')>0 OR INSTR(m.OWNERS,'|VSD|')>0 OR INSTR(m.OWNERS,'|VSD2|')>0 OR INSTR(m.OWNERS,'|VSE|')>0 OR INSTR(m.OWNERS,'|VSG|')>0 OR INSTR(m.OWNERS,'|VSHD|')>0 OR INSTR(m.OWNERS,'|VSS|')>0 OR INSTR(m.OWNERS,'|WCIU|')>0 OR INSTR(m.OWNERS,'|YLE TV1|')>0 OR INSTR(m.OWNERS,'|ZTVS|')>0)
order by m.title,m.id) a where rownum <= 9999) r where rnum >=1 order by rnum
t Transfer: 1220 : 9|19:50:11.8106|aQ5APJ|TMDDBA|OAuth: /api/user-preferences?_dc=1585680611674
t Transfer: 1220 : 9|19:50:11.8106|aQ5APJ|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:50:11.8106|aQ5APJ|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:50:11.8106|aQ5APJ|TMDDBA| user TMDDBA.
t Verbose: 1220 : 9|19:50:11.8106|aQ5APJ|TMDDBA|OAuth. User logged in: TMDDBA
t Verbose: 1220 : 9|19:50:11.8106|aQ5APJ|TMDDBA|StoreUserDataByKeys..
t Transfer: 1220 : 9|19:50:11.8106|aQ5APJ|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:50:11.8106|aQ5APJ|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:50:11.8106|aQ5APJ|TMDDBA| user TMDDBA.
t Information: 1220 : 9|19:50:11.8106|cvCiaX|TMDDBA|Running version search. User: 1 Simple Search:
Running Oracle search.
Running Oracle search for COUNT
Oracle count completed in: 2ms. Returned lines: 1
Oracle version search timing: 4ms.
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=298999 AND (INSTR(m.OWNERS,'|03BO|')>0 OR INSTR(m.OWNERS,'|03GD|')>0 OR INSTR(m.OWNERS,'|03GO|')>0 OR INSTR(m.OWNERS,'|03HA|')>0 OR INSTR(m.OWNERS,'|03JO|')>0 OR INSTR(m.OWNERS,'|03LI|')>0 OR INSTR(m.OWNERS,'|03NB|')>0 OR INSTR(m.OWNERS,'|03NM|')>0 OR INSTR(m.OWNERS,'|03NO|')>0 OR INSTR(m.OWNERS,'|03OR|')>0 OR INSTR(m.OWNERS,'|03SB|')>0 OR INSTR(m.OWNERS,'|03SC|')>0 OR INSTR(m.OWNERS,'|03SE|')>0 OR INSTR(m.OWNERS,'|03SG|')>0 OR INSTR(m.OWNERS,'|03SK|')>0 OR INSTR(m.OWNERS,'|03SM|')>0 OR INSTR(m.OWNERS,'|03SN|')>0 OR INSTR(m.OWNERS,'|03SS|')>0 OR INSTR(m.OWNERS,'|03SY|')>0 OR INSTR(m.OWNERS,'|03UP|')>0 OR INSTR(m.OWNERS,'|03VA|')>0 OR INSTR(m.OWNERS,'|03VB|')>0 OR INSTR(m.OWNERS,'|03VL|')>0 OR INSTR(m.OWNERS,'|03VT|')>0 OR INSTR(m.OWNERS,'|3+ES|')>0 OR INSTR(m.OWNERS,'|3PD|')>0 OR INSTR(m.OWNERS,'|3PLV|')>0 OR INSTR(m.OWNERS,'|AECHD|')>0 OR INSTR(m.OWNERS,'|AECSD|')>0 OR INSTR(m.OWNERS,'|AL|')>0 OR INSTR(m.OWNERS,'|AMAY|')>0 OR INSTR(m.OWNERS,'|AMC|')>0 OR INSTR(m.OWNERS,'|ATP|')>0 OR INSTR(m.OWNERS,'|CENT|')>0 OR INSTR(m.OWNERS,'|CS|')>0 OR INSTR(m.OWNERS,'|CTCB|')>0 OR INSTR(m.OWNERS,'|CTCE|')>0 OR INSTR(m.OWNERS,'|DAVI|')>0 OR INSTR(m.OWNERS,'|DMA|')>0 OR INSTR(m.OWNERS,'|DMF|')>0 OR INSTR(m.OWNERS,'|DMY|')>0 OR INSTR(m.OWNERS,'|DTV|')>0 OR INSTR(m.OWNERS,'|EST|')>0 OR INSTR(m.OWNERS,'|EUROSPORT|')>0 OR INSTR(m.OWNERS,'|HDC1|')>0 OR INSTR(m.OWNERS,'|HDP1|')>0 OR INSTR(m.OWNERS,'|HDP2|')>0 OR INSTR(m.OWNERS,'|HUB|')>0 OR INSTR(m.OWNERS,'|KNL2|')>0 OR INSTR(m.OWNERS,'|KNVA|')>0 OR INSTR(m.OWNERS,'|LMH|')>0 OR INSTR(m.OWNERS,'|LNT|')>0 OR INSTR(m.OWNERS,'|MBNS|')>0 OR INSTR(m.OWNERS,'|MED|')>0 OR INSTR(m.OWNERS,'|MM|')>0 OR INSTR(m.OWNERS,'|MTG|')>0 OR INSTR(m.OWNERS,'|NAA|')>0 OR INSTR(m.OWNERS,'|NICK|')>0 OR INSTR(m.OWNERS,'|NVA|')>0 OR INSTR(m.OWNERS,'|OSP|')>0 OR INSTR(m.OWNERS,'|PBOY|')>0 OR INSTR(m.OWNERS,'|PMS|')>0 OR INSTR(m.OWNERS,'|PPL|')>0 OR INSTR(m.OWNERS,'|PSP|')>0 OR INSTR(m.OWNERS,'|Play|')>0 OR INSTR(m.OWNERS,'|RTR|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|SPG|')>0 OR INSTR(m.OWNERS,'|SPTV|')>0 OR INSTR(m.OWNERS,'|T3LT|')>0 OR INSTR(m.OWNERS,'|T3LV|')>0 OR INSTR(m.OWNERS,'|T6LT|')>0 OR INSTR(m.OWNERS,'|T6LV|')>0 OR INSTR(m.OWNERS,'|T8LT|')>0 OR INSTR(m.OWNERS,'|TECHM|')>0 OR INSTR(m.OWNERS,'|TMD|')>0 OR INSTR(m.OWNERS,'|TV10|')>0 OR INSTR(m.OWNERS,'|TV1A|')>0 OR INSTR(m.OWNERS,'|TV1B|')>0 OR INSTR(m.OWNERS,'|TV1C|')>0 OR INSTR(m.OWNERS,'|TV1D|')>0 OR INSTR(m.OWNERS,'|TV1E|')>0 OR INSTR(m.OWNERS,'|TV1F|')>0 OR INSTR(m.OWNERS,'|TV1K|')>0 OR INSTR(m.OWNERS,'|TV1N|')>0 OR INSTR(m.OWNERS,'|TV1P|')>0 OR INSTR(m.OWNERS,'|TV1S|')>0 OR INSTR(m.OWNERS,'|TV2S|')>0 OR INSTR(m.OWNERS,'|TV3D|')>0 OR INSTR(m.OWNERS,'|TV3N|')>0 OR INSTR(m.OWNERS,'|TV3S|')>0 OR INSTR(m.OWNERS,'|TV5L|')>0 OR INSTR(m.OWNERS,'|TV6E|')>0 OR INSTR(m.OWNERS,'|TV6H|')>0 OR INSTR(m.OWNERS,'|TV6N|')>0 OR INSTR(m.OWNERS,'|TV6S|')>0 OR INSTR(m.OWNERS,'|TV8|')>0 OR INSTR(m.OWNERS,'|TVAE|')>0 OR INSTR(m.OWNERS,'|TVDP|')>0 OR INSTR(m.OWNERS,'|TVPB|')>0 OR INSTR(m.OWNERS,'|TVPU|')>0 OR INSTR(m.OWNERS,'|TVSL|')>0 OR INSTR(m.OWNERS,'|V1G|')>0 OR INSTR(m.OWNERS,'|V1TZ|')>0 OR INSTR(m.OWNERS,'|V3H|')>0 OR INSTR(m.OWNERS,'|V4N|')>0 OR INSTR(m.OWNERS,'|VEC|')>0 OR INSTR(m.OWNERS,'|VEPL|')>0 OR INSTR(m.OWNERS,'|VEPO|')>0 OR INSTR(m.OWNERS,'|VEXE|')>0 OR INSTR(m.OWNERS,'|VEXR|')>0 OR INSTR(m.OWNERS,'|VHIS|')>0 OR INSTR(m.OWNERS,'|VHPO|')>0 OR INSTR(m.OWNERS,'|VNC|')>0 OR INSTR(m.OWNERS,'|VNE|')>0 OR INSTR(m.OWNERS,'|VNH|')>0 OR INSTR(m.OWNERS,'|VNHD|')>0 OR INSTR(m.OWNERS,'|VNPO|')>0 OR INSTR(m.OWNERS,'|VODD|')>0 OR INSTR(m.OWNERS,'|VODE|')>0 OR INSTR(m.OWNERS,'|VODF|')>0 OR INSTR(m.OWNERS,'|VODN|')>0 OR INSTR(m.OWNERS,'|VODS|')>0 OR INSTR(m.OWNERS,'|VS2|')>0 OR INSTR(m.OWNERS,'|VS3|')>0 OR INSTR(m.OWNERS,'|VSAT|')>0 OR INSTR(m.OWNERS,'|VSD|')>0 OR INSTR(m.OWNERS,'|VSD2|')>0 OR INSTR(m.OWNERS,'|VSE|')>0 OR INSTR(m.OWNERS,'|VSG|')>0 OR INSTR(m.OWNERS,'|VSHD|')>0 OR INSTR(m.OWNERS,'|VSS|')>0 OR INSTR(m.OWNERS,'|WCIU|')>0 OR INSTR(m.OWNERS,'|YLE TV1|')>0 OR INSTR(m.OWNERS,'|ZTVS|')>0)
order by m.title,m.id) a where rownum <= 9999) r where rnum >=1 order by rnum
t Verbose: 1220 : 9|19:50:11.8106|cvCiaX|TMDDBA|imfx v3 API took 0.011s '/api/v3/title/298999/versions?_dc=1585680611671'
t Verbose: 1220 : 9|19:50:11.8106|aQ5APJ|TMDDBA|imfx v3 API took 0.007s '/api/user-preferences?_dc=1585680611674'
t Transfer: 1220 : 9|19:50:11.8106|FxkJjF|TMDDBA|OAuth: /api/v3/version/299000/media?_dc=1585680611729
t Transfer: 1220 : 9|19:50:11.8106|FxkJjF|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:50:11.8106|FxkJjF|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:50:11.8106|FxkJjF|TMDDBA| user TMDDBA.
t Verbose: 1220 : 9|19:50:11.8106|FxkJjF|TMDDBA|OAuth. User logged in: TMDDBA
t Information: 1220 : 9|19:50:11.8106|FxkJjF|TMDDBA|V3Api.SearchGeneric
t Transfer: 1220 : 9|19:50:11.8106|FxkJjF|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:50:11.8106|FxkJjF|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:50:11.8106|FxkJjF|TMDDBA| user TMDDBA.
t Information: 1220 : 9|19:50:11.8106|FxkJjF|TMDDBA|MediaSearch SQL:
select r.*,
nvl((select TMD_STR_AGG(c.u_id_pfix ) from tm_ctnrs c, tm_mi_tpi_lnx l where l.miid=r.id and c.u_id=l.tpiid and r.media_type=1),'') BARCODE,
nvl(lnk.lib_loc_ext_id,0) lib_loc_ext_id, nvl(lnk.ctnr_loan_stat,0) ctnr_loan_status, nvl(lnk.ctnr_stat,0) ctnr_stat,
nvl(t.text_data_path,'') THUMBSERVER,
nvl(t.text_data_filename,'') THUMBFILE,
nvl(t.text_id,-1) THUMBID ,
(select min(status.description) from TM_CFG_PGM_STATUS status where r.status = status.id) PGM_STATUS_TEXT, (select tmd_str_agg_pipe(cms.status_type_id ||',' ||cms.status_id) from tm_mi_cust_med_stat_lnx cms where cms.media_id=r.id) "CustomStatusesRaw",
GETMEDIALOC(r.id, r.media_type, r.compil, r.m_ctnr_int_o_loc, r.m_ctnr_ext_o_loc, r.m_ctnr_loc) LOCATION,
nvl(dfl.fSOM,0) FILE_SOM, nvl(dfl.fEOM,0) FILE_EOM, dfl.fos_fname FILENAME, dfl.DFILE_LINK_GUID, dfl.OS_GUID, dfl.SUB_FOLDER, dfl.ORIGINAL_FILENAME
from (select a.*, rownum rnum from
(select m.*,
coalesce(m.primary_thumb_id, (select v.primary_thumb_id from tm_pg_rl v where v.id=m.pgm_parent_id)) primary_thumb_id2
from tmddba.tm_mis m
where media_type>0 and item_type>0 AND PGM_PARENT_ID=:pgm_parent_id_1 and m.mi_deleted=0 AND (INSTR(m.OWNERS,'|03BO|')>0 OR INSTR(m.OWNERS,'|03GD|')>0 OR INSTR(m.OWNERS,'|03GO|')>0 OR INSTR(m.OWNERS,'|03HA|')>0 OR INSTR(m.OWNERS,'|03JO|')>0 OR INSTR(m.OWNERS,'|03LI|')>0 OR INSTR(m.OWNERS,'|03NB|')>0 OR INSTR(m.OWNERS,'|03NM|')>0 OR INSTR(m.OWNERS,'|03NO|')>0 OR INSTR(m.OWNERS,'|03OR|')>0 OR INSTR(m.OWNERS,'|03SB|')>0 OR INSTR(m.OWNERS,'|03SC|')>0 OR INSTR(m.OWNERS,'|03SE|')>0 OR INSTR(m.OWNERS,'|03SG|')>0 OR INSTR(m.OWNERS,'|03SK|')>0 OR INSTR(m.OWNERS,'|03SM|')>0 OR INSTR(m.OWNERS,'|03SN|')>0 OR INSTR(m.OWNERS,'|03SS|')>0 OR INSTR(m.OWNERS,'|03SY|')>0 OR INSTR(m.OWNERS,'|03UP|')>0 OR INSTR(m.OWNERS,'|03VA|')>0 OR INSTR(m.OWNERS,'|03VB|')>0 OR INSTR(m.OWNERS,'|03VL|')>0 OR INSTR(m.OWNERS,'|03VT|')>0 OR INSTR(m.OWNERS,'|3+ES|')>0 OR INSTR(m.OWNERS,'|3PD|')>0 OR INSTR(m.OWNERS,'|3PLV|')>0 OR INSTR(m.OWNERS,'|AECHD|')>0 OR INSTR(m.OWNERS,'|AECSD|')>0 OR INSTR(m.OWNERS,'|AL|')>0 OR INSTR(m.OWNERS,'|AMAY|')>0 OR INSTR(m.OWNERS,'|AMC|')>0 OR INSTR(m.OWNERS,'|ATP|')>0 OR INSTR(m.OWNERS,'|CENT|')>0 OR INSTR(m.OWNERS,'|CS|')>0 OR INSTR(m.OWNERS,'|CTCB|')>0 OR INSTR(m.OWNERS,'|CTCE|')>0 OR INSTR(m.OWNERS,'|DAVI|')>0 OR INSTR(m.OWNERS,'|DMA|')>0 OR INSTR(m.OWNERS,'|DMF|')>0 OR INSTR(m.OWNERS,'|DMY|')>0 OR INSTR(m.OWNERS,'|DTV|')>0 OR INSTR(m.OWNERS,'|EST|')>0 OR INSTR(m.OWNERS,'|EUROSPORT|')>0 OR INSTR(m.OWNERS,'|HDC1|')>0 OR INSTR(m.OWNERS,'|HDP1|')>0 OR INSTR(m.OWNERS,'|HDP2|')>0 OR INSTR(m.OWNERS,'|HUB|')>0 OR INSTR(m.OWNERS,'|KNL2|')>0 OR INSTR(m.OWNERS,'|KNVA|')>0 OR INSTR(m.OWNERS,'|LMH|')>0 OR INSTR(m.OWNERS,'|LNT|')>0 OR INSTR(m.OWNERS,'|MBNS|')>0 OR INSTR(m.OWNERS,'|MED|')>0 OR INSTR(m.OWNERS,'|MM|')>0 OR INSTR(m.OWNERS,'|MTG|')>0 OR INSTR(m.OWNERS,'|NAA|')>0 OR INSTR(m.OWNERS,'|NICK|')>0 OR INSTR(m.OWNERS,'|NVA|')>0 OR INSTR(m.OWNERS,'|OSP|')>0 OR INSTR(m.OWNERS,'|PBOY|')>0 OR INSTR(m.OWNERS,'|PMS|')>0 OR INSTR(m.OWNERS,'|PPL|')>0 OR INSTR(m.OWNERS,'|PSP|')>0 OR INSTR(m.OWNERS,'|Play|')>0 OR INSTR(m.OWNERS,'|RTR|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|SPG|')>0 OR INSTR(m.OWNERS,'|SPTV|')>0 OR INSTR(m.OWNERS,'|T3LT|')>0 OR INSTR(m.OWNERS,'|T3LV|')>0 OR INSTR(m.OWNERS,'|T6LT|')>0 OR INSTR(m.OWNERS,'|T6LV|')>0 OR INSTR(m.OWNERS,'|T8LT|')>0 OR INSTR(m.OWNERS,'|TECHM|')>0 OR INSTR(m.OWNERS,'|TMD|')>0 OR INSTR(m.OWNERS,'|TV10|')>0 OR INSTR(m.OWNERS,'|TV1A|')>0 OR INSTR(m.OWNERS,'|TV1B|')>0 OR INSTR(m.OWNERS,'|TV1C|')>0 OR INSTR(m.OWNERS,'|TV1D|')>0 OR INSTR(m.OWNERS,'|TV1E|')>0 OR INSTR(m.OWNERS,'|TV1F|')>0 OR INSTR(m.OWNERS,'|TV1K|')>0 OR INSTR(m.OWNERS,'|TV1N|')>0 OR INSTR(m.OWNERS,'|TV1P|')>0 OR INSTR(m.OWNERS,'|TV1S|')>0 OR INSTR(m.OWNERS,'|TV2S|')>0 OR INSTR(m.OWNERS,'|TV3D|')>0 OR INSTR(m.OWNERS,'|TV3N|')>0 OR INSTR(m.OWNERS,'|TV3S|')>0 OR INSTR(m.OWNERS,'|TV5L|')>0 OR INSTR(m.OWNERS,'|TV6E|')>0 OR INSTR(m.OWNERS,'|TV6H|')>0 OR INSTR(m.OWNERS,'|TV6N|')>0 OR INSTR(m.OWNERS,'|TV6S|')>0 OR INSTR(m.OWNERS,'|TV8|')>0 OR INSTR(m.OWNERS,'|TVAE|')>0 OR INSTR(m.OWNERS,'|TVDP|')>0 OR INSTR(m.OWNERS,'|TVPB|')>0 OR INSTR(m.OWNERS,'|TVPU|')>0 OR INSTR(m.OWNERS,'|TVSL|')>0 OR INSTR(m.OWNERS,'|V1G|')>0 OR INSTR(m.OWNERS,'|V1TZ|')>0 OR INSTR(m.OWNERS,'|V3H|')>0 OR INSTR(m.OWNERS,'|V4N|')>0 OR INSTR(m.OWNERS,'|VEC|')>0 OR INSTR(m.OWNERS,'|VEPL|')>0 OR INSTR(m.OWNERS,'|VEPO|')>0 OR INSTR(m.OWNERS,'|VEXE|')>0 OR INSTR(m.OWNERS,'|VEXR|')>0 OR INSTR(m.OWNERS,'|VHIS|')>0 OR INSTR(m.OWNERS,'|VHPO|')>0 OR INSTR(m.OWNERS,'|VNC|')>0 OR INSTR(m.OWNERS,'|VNE|')>0 OR INSTR(m.OWNERS,'|VNH|')>0 OR INSTR(m.OWNERS,'|VNHD|')>0 OR INSTR(m.OWNERS,'|VNPO|')>0 OR INSTR(m.OWNERS,'|VODD|')>0 OR INSTR(m.OWNERS,'|VODE|')>0 OR INSTR(m.OWNERS,'|VODF|')>0 OR INSTR(m.OWNERS,'|VODN|')>0 OR INSTR(m.OWNERS,'|VODS|')>0 OR INSTR(m.OWNERS,'|VS2|')>0 OR INSTR(m.OWNERS,'|VS3|')>0 OR INSTR(m.OWNERS,'|VSAT|')>0 OR INSTR(m.OWNERS,'|VSD|')>0 OR INSTR(m.OWNERS,'|VSD2|')>0 OR INSTR(m.OWNERS,'|VSE|')>0 OR INSTR(m.OWNERS,'|VSG|')>0 OR INSTR(m.OWNERS,'|VSHD|')>0 OR INSTR(m.OWNERS,'|VSS|')>0 OR INSTR(m.OWNERS,'|WCIU|')>0 OR INSTR(m.OWNERS,'|YLE TV1|')>0 OR INSTR(m.OWNERS,'|ZTVS|')>0)
order by upper(m.title), m.media_type, m.ec_som, m.id ) a where rownum <= 50) r
,lateral( select l.miid, max(c.C_EXT_OUT_LOC) lib_loc_ext_id, max(c.C_STAT) ctnr_stat, max(c.loan_stat) ctnr_loan_stat from tm_mi_tpi_lnx l, tm_ctnrs c where c.u_id=l.tpiid and l.miid=r.id and r.media_type=1 group by l.miid)(+) lnk
,lateral(select tt.* from tm_text tt where tt.text_id = r.primary_thumb_id2)(+) t
,lateral(select /*+ NO_DECORRELATE */ d.som fsom, d.eom feom, dl.mi_id fmi_id, d.os_fname fos_fname, d.DFILE_LINK_GUID, d.OS_GUID, d.SUB_FOLDER, dl.dfile_id, d.original_filename
FROM tm_dfile d, tm_mi_dfile_lnx dl where d.id=dl.dfile_id and r.id=dl.mi_id and rownum=1)(+) dfl
where rnum >= 1 order by rnum
Param: pgm_parent_id_1: 299000
t Information: 1220 : 9|19:50:11.8106|FxkJjF|TMDDBA| timing: 00:00:00.0188038
t Verbose: 1220 : 9|19:50:11.8106|FxkJjF|TMDDBA|imfx v3 API took 0.019s '/api/v3/version/299000/media?_dc=1585680611729'
t Transfer: 1220 : 9|19:50:11.8106|FxkJjF|TMDDBA|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\short.mov subfolder
t Transfer: 1220 : 9|19:50:11.8106|FxkJjF|TMDDBA| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/short.mov
t Transfer: 1220 : 9|19:50:11.8106|FxkJjF|TMDDBA|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/short.mov
t Transfer: 1220 : 9|19:50:11.8106|FxkJjF|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:50:11.8106|FxkJjF|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:50:11.8106|FxkJjF|TMDDBA| user TMDDBA.
t Transfer: 1220 : 9|19:50:11.8106|FxkJjF|TMDDBA|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\N0001864.mpd subfolder
t Transfer: 1220 : 9|19:50:11.8106|FxkJjF|TMDDBA| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/N0001864.mpd
t Transfer: 1220 : 9|19:50:11.8106|FxkJjF|TMDDBA|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/N0001864.mpd
t Transfer: 1220 : 9|19:50:11.8106|FxkJjF|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:50:11.8106|FxkJjF|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:50:11.8106|FxkJjF|TMDDBA| user TMDDBA.
t Transfer: 1220 : 9|19:50:16.4981|Sn_o2V|TMDDBA|OAuth: /api/v3/media-details/299064?_dc=1585680616369
t Transfer: 1220 : 9|19:50:16.4981|Sn_o2V|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:50:16.4981|Sn_o2V|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:50:16.4981|Sn_o2V|TMDDBA| user TMDDBA.
t Verbose: 1220 : 9|19:50:16.4981|Sn_o2V|TMDDBA|OAuth. User logged in: TMDDBA
t Transfer: 1220 : 9|19:50:16.4981|Sn_o2V|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:50:16.4981|Sn_o2V|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:50:16.4981|Sn_o2V|TMDDBA| user TMDDBA.
t Information: 1220 : 9|19:50:16.4981|||TM_MIS. LoadSubtitles for ID: 299064
t Information: 1220 : 9|19:50:16.4981|||TM_MIS. LoadSubtitles for ID: 299064. SQL: 'select id, m_ctnr_id, m_ctnr_loc, modified_dt, tv_std, m_ctnr_fmt_id,
nvl((select max(l.language) from tm_audio l where l.miid=m.id),aud_language_id) aud_language_id
from tm_mis m where mi_deleted=0 and item_type>0 and media_type=101 and PGM_PARENT_ID=299000'
t Information: 1220 : 9|19:50:16.4981||| Subtitles added for ID: 299064, 299072 Unknown [0] : 'https://imfxv3tm.tmd.tv/getcaptions.aspx?f=PMH_s1ep1_pt1 - Copy.scc&som=00:00:00:00&storage=TimedText&modified=637212770340000000&tcf=0&id=299072&tmp=0'.
t Verbose: 1220 : 9|19:50:16.7012|Sn_o2V|TMDDBA|imfx v3 API took 0.148s '/api/v3/media-details/299064?_dc=1585680616369'
t Transfer: 1220 : 9|19:50:16.7012|Sn_o2V|TMDDBA|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\N0001864.mpd subfolder
t Transfer: 1220 : 9|19:50:16.7012|Sn_o2V|TMDDBA| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/N0001864.mpd
t Transfer: 1220 : 9|19:50:16.7012|Sn_o2V|TMDDBA|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/N0001864.mpd
t Transfer: 1220 : 9|19:50:16.7012|Sn_o2V|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:50:16.7012|Sn_o2V|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:50:16.7012|Sn_o2V|TMDDBA| user TMDDBA.
t Transfer: 1220 : 9|19:50:16.7012|0rE9ln|TMDDBA|OAuth: /api/v3/media-captions/299064?_dc=1585680616566
t Transfer: 1220 : 9|19:50:16.7012|0rE9ln|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:50:16.7012|0rE9ln|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:50:16.7012|0rE9ln|TMDDBA| user TMDDBA.
t Verbose: 1220 : 9|19:50:16.7012|0rE9ln|TMDDBA|OAuth. User logged in: TMDDBA
t Verbose: 1220 : 9|19:50:16.7012|0rE9ln|TMDDBA|imfx v3 API took 0.004s '/api/v3/media-captions/299064?_dc=1585680616566'
t Transfer: 1220 : 9|19:50:16.9043|7WEnt5|TMDDBA|OAuth: /api/v3/mediavideo/299064?info=smudge,scene,audiovolume&_dc=1585680616775
t Transfer: 1220 : 9|19:50:16.9043|7WEnt5|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:50:16.9043|7WEnt5|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:50:16.9043|7WEnt5|TMDDBA| user TMDDBA.
t Verbose: 1220 : 9|19:50:16.9043|7WEnt5|TMDDBA|OAuth. User logged in: TMDDBA
t Transfer: 1220 : 9|19:50:16.9043|7WEnt5|TMDDBA|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\N0001864.mpd subfolder
t Transfer: 1220 : 9|19:50:16.9043|7WEnt5|TMDDBA| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/N0001864.mpd
t Transfer: 1220 : 9|19:50:16.9043|7WEnt5|TMDDBA|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/N0001864.mpd
t Transfer: 1220 : 9|19:50:16.9043|7WEnt5|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:50:16.9043|7WEnt5|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:50:16.9043|7WEnt5|TMDDBA| user TMDDBA.
t Verbose: 1220 : 9|19:50:16.9043|7WEnt5|TMDDBA|imfx v3 API took 0.027s '/api/v3/mediavideo/299064?info=smudge,scene,audiovolume&_dc=1585680616775'
t Transfer: 1220 : 9|19:50:17.5137|bO4UTm|TMDDBA|OAuth: /api/user-group-preferences?globals=htmlplayerhotkeys,audioOnFrameForward&_dc=1585680617355
t Transfer: 1220 : 9|19:50:17.5137|bO4UTm|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:50:17.5137|bO4UTm|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:50:17.5137|bO4UTm|TMDDBA| user TMDDBA.
t Verbose: 1220 : 9|19:50:17.5137|bO4UTm|TMDDBA|OAuth. User logged in: TMDDBA
t Transfer: 1220 : 9|19:50:17.5137|bO4UTm|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:50:17.5137|bO4UTm|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:50:17.5137|bO4UTm|TMDDBA| user TMDDBA.
t Verbose: 1220 : 9|19:50:17.5137|bO4UTm|TMDDBA|imfx v3 API took 0.003s '/api/user-group-preferences?globals=htmlplayerhotkeys,audioOnFrameForward&_dc=1585680617355'
t Transfer: 1220 : 9|19:50:17.9200|Gbh3sx|TMDDBA|OAuth: /api/v3/subtitles/299072?_dc=1585680617817
t Transfer: 1220 : 9|19:50:17.9200|Gbh3sx|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:50:17.9200|Gbh3sx|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:50:17.9200|Gbh3sx|TMDDBA| user TMDDBA.
t Verbose: 1220 : 9|19:50:17.9200|Gbh3sx|TMDDBA|OAuth. User logged in: TMDDBA
t Information: 1220 : 9|19:50:17.9200|Gbh3sx|TMDDBA|V3 api. GetSubtitles: 299072
t Information: 1220 : 9|19:50:17.9200|Gbh3sx|TMDDBA|SubtitlesQcLoadSubtitles. ID 299072
t Information: 1220 : 9|19:50:17.9200|Gbh3sx|TMDDBA|LoadSubtitlesById. filename PMH_s1ep1_pt1 - Copy.scc device TimedText frame rate NTCS_DF
t Information: 1220 : 9|19:50:17.9200|Gbh3sx|TMDDBA|LoadSubtitlesById. Filename: PMH_s1ep1_pt1 - Copy.scc. Device TimedText. Timecode format NTCS_DF. Media ID 299072.
t Information: 1220 : 9|19:50:17.9200|Gbh3sx|TMDDBA|GetCaptions. Start. Filename: PMH_s1ep1_pt1 - Copy.scc. Cache path C:\inetpub\wwwroot\imfxcore\timedtextcache\. Storage path \\192.168.120.254\DemoFS\Digital Assets\TimedText. Last Modified 1/1/0001 12:00:00 AM
t Transfer: 1220 : 9|19:50:17.9200|fDBr37|TMDDBA|OAuth: /api/v3/ai-tags/299064?_dc=1585680617856
t Transfer: 1220 : 9|19:50:17.9200|fDBr37|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:50:17.9200|fDBr37|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:50:17.9200|fDBr37|TMDDBA| user TMDDBA.
t Verbose: 1220 : 9|19:50:17.9200|fDBr37|TMDDBA|OAuth. User logged in: TMDDBA
t Information: 1220 : 9|19:50:17.9200|fDBr37|TMDDBA|V3Api.GetMediaAiTags
t Verbose: 1220 : 9|19:50:17.9200|fDBr37|TMDDBA|imfx v3 API took 0.006s '/api/v3/ai-tags/299064?_dc=1585680617856'
t Transfer: 1220 : 9|19:50:18.1231|6dd95q|TMDDBA|OAuth: /api/v3/mediavideo/299064?info=smudge&_dc=1585680617870
t Transfer: 1220 : 9|19:50:18.1231|6dd95q|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:50:18.1231|6dd95q|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:50:18.1231|6dd95q|TMDDBA| user TMDDBA.
t Verbose: 1220 : 9|19:50:18.1231|6dd95q|TMDDBA|OAuth. User logged in: TMDDBA
t Transfer: 1220 : 9|19:50:18.1231|6dd95q|TMDDBA|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\N0001864.mpd subfolder
t Transfer: 1220 : 9|19:50:18.1231|6dd95q|TMDDBA| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/N0001864.mpd
t Transfer: 1220 : 9|19:50:18.1231|6dd95q|TMDDBA|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/N0001864.mpd
t Transfer: 1220 : 9|19:50:18.1231|6dd95q|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:50:18.1231|6dd95q|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:50:18.1231|6dd95q|TMDDBA| user TMDDBA.
t Verbose: 1220 : 9|19:50:18.1231|6dd95q|TMDDBA|imfx v3 API took 0.010s '/api/v3/mediavideo/299064?info=smudge&_dc=1585680617870'
t Information: 1220 : 9|19:50:18.1231|Gbh3sx|TMDDBA|GetCaptions. Convert required. Som 00:00:00. From: \\192.168.120.254\DemoFS\Digital Assets\TimedText\PMH_s1ep1_pt1 - Copy.scc to: C:\inetpub\wwwroot\imfxcore\timedtextcache\PMH_s1ep1_pt1 - Copy.scc_ntcs_df_299072.xml
t Information: 1220 : 9|19:50:18.1231|Gbh3sx|TMDDBA|GetCaptions. Convertor lock aquired.
t Transfer: 1220 : 9|19:50:18.3262|RXOSu9|TMDDBA|OAuth: /api/metadata/4000/299064?_dc=1585680618262
t Transfer: 1220 : 9|19:50:18.3262|RXOSu9|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:50:18.3262|RXOSu9|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:50:18.3262|RXOSu9|TMDDBA| user TMDDBA.
t Verbose: 1220 : 9|19:50:18.3262|RXOSu9|TMDDBA|OAuth. User logged in: TMDDBA
t Verbose: 1220 : 9|19:50:18.3262|RXOSu9|TMDDBA|imfx v3 API took 0.011s '/api/metadata/4000/299064?_dc=1585680618262'
t Information: 1220 : 9|19:50:18.5293|Gbh3sx|TMDDBA|GetCaptions. File converted: \\192.168.120.254\DemoFS\Digital Assets\TimedText\PMH_s1ep1_pt1 - Copy.scc. Result: True
t Information: 1220 : 9|19:50:18.5293|Gbh3sx|TMDDBA|GetCaptions. In cache. Filename: C:\inetpub\wwwroot\imfxcore\timedtextcache\PMH_s1ep1_pt1 - Copy.scc_ntcs_df_299072.xml
t Information: 1220 : 9|19:50:18.5293|Gbh3sx|TMDDBA|LoadSubtitlesById. Convertor lock acquired.
t Information: 1220 : 9|19:50:18.7324|Gbh3sx|TMDDBA|LoadSubtitlesById got 43 lines.
t Verbose: 1220 : 9|19:50:18.7324|Gbh3sx|TMDDBA|imfx v3 API took 0.686s '/api/v3/subtitles/299072?_dc=1585680617817'
t Information: 1220 : 9|19:50:18.7324|vqUqlJ||GetCaptionsForWeb. Filename: PMH_s1ep1_pt1 - Copy.scc. Device TimedText. Format WebVTT. Timecode format Pal. Media ID 299072. Last Modified 3/31/2020 6:43:54 PM
t Information: 1220 : 9|19:50:18.7324|vqUqlJ||GetCaptions. Start. Filename: PMH_s1ep1_pt1 - Copy.scc. Cache path C:\inetpub\wwwroot\imfxcore\timedtextcache\. Storage path \\192.168.120.254\DemoFS\Digital Assets\TimedText. Last Modified 3/31/2020 6:43:54 PM
t Information: 1220 : 9|19:50:18.7324|vqUqlJ||GetCaptions. Convert required. Som 00:00:00. From: \\192.168.120.254\DemoFS\Digital Assets\TimedText\PMH_s1ep1_pt1 - Copy.scc to: C:\inetpub\wwwroot\imfxcore\timedtextcache\PMH_s1ep1_pt1 - Copy.scc_pal_299072.vtt
t Information: 1220 : 9|19:50:18.7324|vqUqlJ||GetCaptions. Convertor lock aquired.
t Information: 1220 : 9|19:50:18.7324|vqUqlJ||GetCaptions. File converted: \\192.168.120.254\DemoFS\Digital Assets\TimedText\PMH_s1ep1_pt1 - Copy.scc. Result: True
t Information: 1220 : 9|19:50:18.7324|vqUqlJ||GetCaptions. In cache. Filename: C:\inetpub\wwwroot\imfxcore\timedtextcache\PMH_s1ep1_pt1 - Copy.scc_pal_299072.vtt
t Transfer: 1220 : 9|19:50:39.6543|jyG_lP|TMDDBA|OAuth: /api/user-preferences?_dc=1585680639589
t Transfer: 1220 : 9|19:50:39.6543|jyG_lP|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:50:39.6543|jyG_lP|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:50:39.6543|jyG_lP|TMDDBA| user TMDDBA.
t Verbose: 1220 : 9|19:50:39.6543|jyG_lP|TMDDBA|OAuth. User logged in: TMDDBA
t Verbose: 1220 : 9|19:50:39.6543|jyG_lP|TMDDBA|StoreUserDataByKeys..
t Transfer: 1220 : 9|19:50:39.6543|jyG_lP|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:50:39.6543|jyG_lP|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:50:39.6543|jyG_lP|TMDDBA| user TMDDBA.
t Verbose: 1220 : 9|19:50:39.8575|jyG_lP|TMDDBA|imfx v3 API took 0.026s '/api/user-preferences?_dc=1585680639589'
t Transfer: 1220 : 9|19:50:42.3262|L4AR7S|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:50:42.3262|L4AR7S|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:50:42.3262|L4AR7S|TMDDBA| user TMDDBA.
t Information: 1220 : 9|19:50:44.9668|KOFDrF|TMDDBA|GetUserProfile. Id: 30000
t Transfer: 1220 : 9|19:50:44.9668|KOFDrF|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:50:44.9668|KOFDrF|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:50:44.9668|KOFDrF|TMDDBA| user TMDDBA.
t Transfer: 1220 : 9|19:50:57.3575|vi0rlC|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:50:57.3575|vi0rlC|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:50:57.3575|vi0rlC|TMDDBA| user TMDDBA.
t Transfer: 1220 : 9|19:50:57.5606|7XT99A|TMDDBA|OAuth: /api/v3/search/workflow/media?_dc=1585680657377
t Transfer: 1220 : 9|19:50:57.5606|7XT99A|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:50:57.5606|7XT99A|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:50:57.5606|7XT99A|TMDDBA| user TMDDBA.
t Verbose: 1220 : 9|19:50:57.5606|7XT99A|TMDDBA|OAuth. User logged in: TMDDBA
t Information: 1220 : 9|19:50:57.5606|7XT99A|TMDDBA|V3Api.SearchWorkflowsWithMedia
t Transfer: 1220 : 9|19:50:57.5606|7XT99A|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:50:57.5606|7XT99A|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:50:57.5606|7XT99A|TMDDBA| user TMDDBA.
t Information: 1220 : 9|19:50:57.5606|7XT99A|TMDDBA|SearchJob SQL:
select * from (select a.*, rownum rnum from ( select /*+ INDEX(j JB_CMBST_IDX) */ j.*
,p.pname
,mi.tv_std
,mi.MIID1, mi.MIID2, mi.MIID3, mi.VERSIONID1, mi.VERSIONID2, mi.PROGID1, mi.PROGID2
,txd.NEXT_TX_DATE
FROM tm_mjob j
left join tm_mjob_pset p on j.j_sched_indx=p.id
left join (select j_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 m.tv_std) TV_STD from tm_mis m, tm_mtsk_it i
where m.id=i.mi_id and i.src_dest in (2,3) group by j_id) mi on mi.j_id=j.id
LEFT JOIN (
SELECT it.j_id, min(sch.tx_tm_st) NEXT_TX_DATE FROM TM_MTSK_IT it, TM_MIS m, hr_sched sch
WHERE m.id = it.MI_ID AND (sch.prod_num = m.PROGID2 OR sch.prod_num = (select rl.VERSIONID1 from TM_PG_RL rl where rl.ID = m.PGM_PARENT_ID)) AND sch.tx_tm_st > sysdate
GROUP BY J_ID) txd ON txd.j_id = j.id
where 1=1 AND j.id in (
select v.id from TM_MJOB v
where v.id in (
select t.j_id from TM_MTSK_IT t where t.mi_id in (299064) and t.src_dest in (2, 3)
UNION
select m.cret_job from TM_MIS m where m.id in (299064)) and (v.cmb_stat not in (15, 18, 19, 23) or (v.CMB_STAT = 19 and v.J_FAILURE_RESOLVED = 0)
)
)
and j.cmb_stat not in (15,18,23) AND j.J_CLI_CODE in ('03BO' , '03GD' , '03GO' , '03HA' , '03JO' , '03LI' , '03NB' , '03NM' , '03NO' , '03OR' , '03SB' , '03SC' , '03SE' , '03SG' , '03SK' , '03SM' , '03SN' , '03SS' , '03SY' , '03UP' , '03VA' , '03VB' , '03VL' , '03VT' , '3+ES' , '3PD' , '3PLV' , 'AECHD' , 'AECSD' , 'AL' , 'AMAY' , 'AMC' , 'ATP' , 'CENT' , 'CS' , 'CTCB' , 'CTCE' , 'DAVI' , 'DMA' , 'DMF' , 'DMY' , 'DTV' , 'EST' , 'EUROSPORT' , 'HDC1' , 'HDP1' , 'HDP2' , 'HUB' , 'KNL2' , 'KNVA' , 'LMH' , 'LNT' , 'MBNS' , 'MED' , 'MM' , 'MTG' , 'NAA' , 'NICK' , 'NVA' , 'OSP' , 'PBOY' , 'PMS' , 'PPL' , 'PSP' , 'Play' , 'RTR' , 'SFP1' , 'SFP2' , 'SPG' , 'SPTV' , 'T3LT' , 'T3LV' , 'T6LT' , 'T6LV' , 'T8LT' , 'TECHM' , 'TMD' , 'TV10' , 'TV1A' , 'TV1B' , 'TV1C' , 'TV1D' , 'TV1E' , 'TV1F' , 'TV1K' , 'TV1N' , 'TV1P' , 'TV1S' , 'TV2S' , 'TV3D' , 'TV3N' , 'TV3S' , 'TV5L' , 'TV6E' , 'TV6H' , 'TV6N' , 'TV6S' , 'TV8' , 'TVAE' , 'TVDP' , 'TVPB' , 'TVPU' , 'TVSL' , 'V1G' , 'V1TZ' , 'V3H' , 'V4N' , 'VEC' , 'VEPL' , 'VEPO' , 'VEXE' , 'VEXR' , 'VHIS' , 'VHPO' , 'VNC' , 'VNE' , 'VNH' , 'VNHD' , 'VNPO' , 'VODD' , 'VODE' , 'VODF' , 'VODN' , 'VODS' , 'VS2' , 'VS3' , 'VSAT' , 'VSD' , 'VSD2' , 'VSE' , 'VSG' , 'VSHD' , 'VSS' , 'WCIU' , 'YLE TV1' , 'ZTVS') order by j.J_COMPL_BY, j.id desc, j.id ) a where rownum <= 50) where rnum >= 1 order by rnum
t Information: 1220 : 9|19:50:57.5606|7XT99A|TMDDBA| jobs returned 7, searched in 00:00:00.0111349
t Information: 1220 : 9|19:50:57.5606|7XT99A|TMDDBA|TechReports is not found. ID: 96.
t Information: 1220 : 9|19:50:57.5606|7XT99A|TMDDBA|TechReports is not found. ID: 41.
t Information: 1220 : 9|19:50:57.5606|7XT99A|TMDDBA|TechReports is not found. ID: 1633.
t Information: 1220 : 9|19:50:57.5606|7XT99A|TMDDBA|TechReports is not found. ID: 1300.
t Information: 1220 : 9|19:50:57.5606|7XT99A|TMDDBA|TechReports is not found. ID: 116.
t Information: 1220 : 9|19:50:57.5606|7XT99A|TMDDBA|TechReports is not found. ID: 673.
t Information: 1220 : 9|19:50:57.5606|7XT99A|TMDDBA| tasks returned 7, searched in 00:00:00.0291178
t Verbose: 1220 : 9|19:50:57.5606|7XT99A|TMDDBA|imfx v3 API took 0.073s '/api/v3/search/workflow/media?_dc=1585680657377'
t Transfer: 1220 : 9|19:50:57.9668|V3b1r9|TMDDBA|OAuth: /api/v3/search/workflow/media?_dc=1585680657788
t Transfer: 1220 : 9|19:50:57.9668|V3b1r9|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:50:57.9668|V3b1r9|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:50:57.9668|V3b1r9|TMDDBA| user TMDDBA.
t Verbose: 1220 : 9|19:50:57.9668|V3b1r9|TMDDBA|OAuth. User logged in: TMDDBA
t Information: 1220 : 9|19:50:57.9668|V3b1r9|TMDDBA|V3Api.SearchWorkflowsWithMedia
t Transfer: 1220 : 9|19:50:57.9668|V3b1r9|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:50:57.9668|V3b1r9|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:50:57.9668|V3b1r9|TMDDBA| user TMDDBA.
t Information: 1220 : 9|19:50:57.9668|V3b1r9|TMDDBA|SearchJob SQL:
select * from (select a.*, rownum rnum from ( select /*+ INDEX(j JB_CMBST_IDX) */ j.*
,p.pname
,mi.tv_std
,mi.MIID1, mi.MIID2, mi.MIID3, mi.VERSIONID1, mi.VERSIONID2, mi.PROGID1, mi.PROGID2
,txd.NEXT_TX_DATE
FROM tm_mjob j
left join tm_mjob_pset p on j.j_sched_indx=p.id
left join (select j_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 m.tv_std) TV_STD from tm_mis m, tm_mtsk_it i
where m.id=i.mi_id and i.src_dest in (2,3) group by j_id) mi on mi.j_id=j.id
LEFT JOIN (
SELECT it.j_id, min(sch.tx_tm_st) NEXT_TX_DATE FROM TM_MTSK_IT it, TM_MIS m, hr_sched sch
WHERE m.id = it.MI_ID AND (sch.prod_num = m.PROGID2 OR sch.prod_num = (select rl.VERSIONID1 from TM_PG_RL rl where rl.ID = m.PGM_PARENT_ID)) AND sch.tx_tm_st > sysdate
GROUP BY J_ID) txd ON txd.j_id = j.id
where 1=1 AND j.id in (
select v.id from TM_MJOB v
where v.id in (
select t.j_id from TM_MTSK_IT t where t.mi_id in (299064) and t.src_dest in (2, 3)
UNION
select m.cret_job from TM_MIS m where m.id in (299064)) and (v.cmb_stat not in (15, 18, 19, 23) or (v.CMB_STAT = 19 and v.J_FAILURE_RESOLVED = 0)
)
)
and j.cmb_stat not in (15,18,23) AND j.J_CLI_CODE in ('03BO' , '03GD' , '03GO' , '03HA' , '03JO' , '03LI' , '03NB' , '03NM' , '03NO' , '03OR' , '03SB' , '03SC' , '03SE' , '03SG' , '03SK' , '03SM' , '03SN' , '03SS' , '03SY' , '03UP' , '03VA' , '03VB' , '03VL' , '03VT' , '3+ES' , '3PD' , '3PLV' , 'AECHD' , 'AECSD' , 'AL' , 'AMAY' , 'AMC' , 'ATP' , 'CENT' , 'CS' , 'CTCB' , 'CTCE' , 'DAVI' , 'DMA' , 'DMF' , 'DMY' , 'DTV' , 'EST' , 'EUROSPORT' , 'HDC1' , 'HDP1' , 'HDP2' , 'HUB' , 'KNL2' , 'KNVA' , 'LMH' , 'LNT' , 'MBNS' , 'MED' , 'MM' , 'MTG' , 'NAA' , 'NICK' , 'NVA' , 'OSP' , 'PBOY' , 'PMS' , 'PPL' , 'PSP' , 'Play' , 'RTR' , 'SFP1' , 'SFP2' , 'SPG' , 'SPTV' , 'T3LT' , 'T3LV' , 'T6LT' , 'T6LV' , 'T8LT' , 'TECHM' , 'TMD' , 'TV10' , 'TV1A' , 'TV1B' , 'TV1C' , 'TV1D' , 'TV1E' , 'TV1F' , 'TV1K' , 'TV1N' , 'TV1P' , 'TV1S' , 'TV2S' , 'TV3D' , 'TV3N' , 'TV3S' , 'TV5L' , 'TV6E' , 'TV6H' , 'TV6N' , 'TV6S' , 'TV8' , 'TVAE' , 'TVDP' , 'TVPB' , 'TVPU' , 'TVSL' , 'V1G' , 'V1TZ' , 'V3H' , 'V4N' , 'VEC' , 'VEPL' , 'VEPO' , 'VEXE' , 'VEXR' , 'VHIS' , 'VHPO' , 'VNC' , 'VNE' , 'VNH' , 'VNHD' , 'VNPO' , 'VODD' , 'VODE' , 'VODF' , 'VODN' , 'VODS' , 'VS2' , 'VS3' , 'VSAT' , 'VSD' , 'VSD2' , 'VSE' , 'VSG' , 'VSHD' , 'VSS' , 'WCIU' , 'YLE TV1' , 'ZTVS') order by j.J_COMPL_BY, j.id desc, j.id ) a where rownum <= 50) where rnum >= 1 order by rnum
t Information: 1220 : 9|19:50:57.9668|V3b1r9|TMDDBA| jobs returned 7, searched in 00:00:00.0085142
t Information: 1220 : 9|19:50:57.9668|V3b1r9|TMDDBA|TechReports is not found. ID: 96.
t Information: 1220 : 9|19:50:57.9668|V3b1r9|TMDDBA|TechReports is not found. ID: 41.
t Information: 1220 : 9|19:50:57.9668|V3b1r9|TMDDBA|TechReports is not found. ID: 1633.
t Information: 1220 : 9|19:50:57.9668|V3b1r9|TMDDBA|TechReports is not found. ID: 1300.
t Information: 1220 : 9|19:50:57.9668|V3b1r9|TMDDBA|TechReports is not found. ID: 116.
t Information: 1220 : 9|19:50:57.9668|V3b1r9|TMDDBA|TechReports is not found. ID: 673.
t Information: 1220 : 9|19:50:57.9668|V3b1r9|TMDDBA| tasks returned 7, searched in 00:00:00.0119182
t Verbose: 1220 : 9|19:50:57.9668|V3b1r9|TMDDBA|imfx v3 API took 0.026s '/api/v3/search/workflow/media?_dc=1585680657788'
t Transfer: 1220 : 9|19:50:59.5918|33qzD2|TMDDBA|OAuth: /api/v3/mediaorder?_dc=1585680659481
t Transfer: 1220 : 9|19:50:59.5918|33qzD2|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:50:59.5918|33qzD2|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:50:59.5918|33qzD2|TMDDBA| user TMDDBA.
t Verbose: 1220 : 9|19:50:59.5918|33qzD2|TMDDBA|OAuth. User logged in: TMDDBA
t Transfer: 1220 : 9|19:50:59.5918|33qzD2|TMDDBA| semaphore enter at: 3/31/2020 7:50:59 PM count: 9 thread: 26
t Transfer: 1220 : 9|19:50:59.5918|33qzD2|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:50:59.5918|33qzD2|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:50:59.5918|33qzD2|TMDDBA| user TMDDBA.
t Information: 1220 : 9|19:50:59.5918|33qzD2|TMDDBA|CallApi. In. Trace-id: 36MOt7 Msg: createworkflow. User: TMDDBA. Rights: False.
t Information: 1220 : 9|19:50:59.5918|33qzD2|TMDDBA|
2352
media/299064
t Information: 1220 : 9|19:50:59.5918|33qzD2|TMDDBA|CallApi. Out. Trace-id: 36MOt7 21.1ms.
t Information: 1220 : 9|19:50:59.5918|33qzD2|TMDDBA|
0
511
Workflow preset with ID 2352 not found [879.874.511]
400
t Transfer: 1220 : 9|19:50:59.5918|33qzD2|TMDDBA| semaphore release at: 3/31/2020 7:50:59 PM count: 9 thread: 26
t Verbose: 1220 : 9|19:50:59.5918|33qzD2|TMDDBA|imfx v3 API took 0.039s '/api/v3/mediaorder?_dc=1585680659481'
t Transfer: 1220 : 9|19:50:59.7949|4l8j78|TMDDBA|OAuth: /api/user-preferences?_dc=1585680659572
t Transfer: 1220 : 9|19:50:59.7949|4l8j78|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:50:59.7949|4l8j78|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:50:59.7949|4l8j78|TMDDBA| user TMDDBA.
t Verbose: 1220 : 9|19:50:59.7949|4l8j78|TMDDBA|OAuth. User logged in: TMDDBA
t Verbose: 1220 : 9|19:50:59.7949|4l8j78|TMDDBA|StoreUserDataByKeys..
t Transfer: 1220 : 9|19:50:59.7949|4l8j78|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:50:59.7949|4l8j78|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:50:59.7949|4l8j78|TMDDBA| user TMDDBA.
t Verbose: 1220 : 9|19:50:59.7949|4l8j78|TMDDBA|imfx v3 API took 0.005s '/api/user-preferences?_dc=1585680659572'
t Transfer: 1220 : 9|19:51:15.8418|iLVZT~|TMDDBA|OAuth: /api/ums/service/87c0c817-62ad-4f82-ae08-7546f32ab096/restart?_dc=1585680675657
t Transfer: 1220 : 9|19:51:15.8418|iLVZT~|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:51:15.8418|iLVZT~|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:51:15.8418|iLVZT~|TMDDBA| user TMDDBA.
t Verbose: 1220 : 9|19:51:15.8418|iLVZT~|TMDDBA|OAuth. User logged in: TMDDBA
t Transfer: 1220 : 9|19:51:15.8418|iLVZT~|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:51:15.8418|iLVZT~|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:51:15.8418|iLVZT~|TMDDBA| user TMDDBA.
t Transfer: 1220 : 9|19:51:15.8418|iLVZT~|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:51:15.8418|iLVZT~|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:51:15.8418|iLVZT~|TMDDBA| user TMDDBA.
t Information: 1220 : 9|19:51:15.8418|iLVZT~|TMDDBA|Request to restart service 87c0c817-62ad-4f82-ae08-7546f32ab096 - TMDDEMO-APPS/Core.API received from User: TMDDBA IP: 192.168.127.6
t Verbose: 1220 : 9|19:51:15.8418|iLVZT~|TMDDBA|imfx v3 API took 0.052s '/api/ums/service/87c0c817-62ad-4f82-ae08-7546f32ab096/restart?_dc=1585680675657'
t Transfer: 1220 : 9|19:51:21.5293|miHleb|TMDDBA|OAuth: /api/v3/mediaorder?_dc=1585680681304
t Transfer: 1220 : 9|19:51:21.5293|miHleb|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:51:21.5293|miHleb|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:51:21.5293|miHleb|TMDDBA| user TMDDBA.
t Verbose: 1220 : 9|19:51:21.5293|miHleb|TMDDBA|OAuth. User logged in: TMDDBA
t Transfer: 1220 : 9|19:51:21.5293|miHleb|TMDDBA| semaphore enter at: 3/31/2020 7:51:21 PM count: 9 thread: 35
t Transfer: 1220 : 9|19:51:21.5293|miHleb|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:51:21.5293|miHleb|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:51:21.5293|miHleb|TMDDBA| user TMDDBA.
t Information: 1220 : 9|19:51:21.5293|miHleb|TMDDBA|CallApi. In. Trace-id: Lh~AlG Msg: createworkflow. User: TMDDBA. Rights: False.
t Information: 1220 : 9|19:51:21.5293|miHleb|TMDDBA|
2352
t Information: 1220 : 9|19:51:21.7325|miHleb|TMDDBA|CallApi. Out. Trace-id: Lh~AlG 290.4ms.
t Information: 1220 : 9|19:51:21.7325|miHleb|TMDDBA|
0
880
No source items defined [879.876.880]
400
t Transfer: 1220 : 9|19:51:21.7325|miHleb|TMDDBA| semaphore release at: 3/31/2020 7:51:21 PM count: 9 thread: 35
t Verbose: 1220 : 9|19:51:21.7325|miHleb|TMDDBA|imfx v3 API took 0.292s '/api/v3/mediaorder?_dc=1585680681304'
t Transfer: 1220 : 9|19:51:21.7325|Tpfgfh|TMDDBA|OAuth: /api/user-preferences?_dc=1585680681631
t Transfer: 1220 : 9|19:51:21.7325|Tpfgfh|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:51:21.7325|Tpfgfh|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:51:21.7325|Tpfgfh|TMDDBA| user TMDDBA.
t Verbose: 1220 : 9|19:51:21.7325|Tpfgfh|TMDDBA|OAuth. User logged in: TMDDBA
t Verbose: 1220 : 9|19:51:21.7325|Tpfgfh|TMDDBA|StoreUserDataByKeys..
t Transfer: 1220 : 9|19:51:21.7325|Tpfgfh|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:51:21.7325|Tpfgfh|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:51:21.7325|Tpfgfh|TMDDBA| user TMDDBA.
t Verbose: 1220 : 9|19:51:21.7325|Tpfgfh|TMDDBA|imfx v3 API took 0.005s '/api/user-preferences?_dc=1585680681631'
t Transfer: 1220 : 9|19:51:33.9199|kQTIeC|TMDDBA|OAuth: /api/user-preferences?_dc=1585680693695
t Transfer: 1220 : 9|19:51:33.9199|kQTIeC|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:51:33.9199|kQTIeC|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:51:33.9199|kQTIeC|TMDDBA| user TMDDBA.
t Verbose: 1220 : 9|19:51:33.9199|kQTIeC|TMDDBA|OAuth. User logged in: TMDDBA
t Verbose: 1220 : 9|19:51:33.9199|kQTIeC|TMDDBA|StoreUserDataByKeys..
t Transfer: 1220 : 9|19:51:33.9199|kQTIeC|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:51:33.9199|kQTIeC|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:51:33.9199|kQTIeC|TMDDBA| user TMDDBA.
t Verbose: 1220 : 9|19:51:33.9199|kQTIeC|TMDDBA|imfx v3 API took 0.015s '/api/user-preferences?_dc=1585680693695'
t Transfer: 1220 : 9|19:51:37.3731|RlnJbU|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:51:37.3731|RlnJbU|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:51:37.3731|RlnJbU|TMDDBA| user TMDDBA.
t Transfer: 1220 : 9|19:51:37.5762|PMjzFG|TMDDBA|OAuth: /api/v3/search/workflow/media?_dc=1585680697440
t Transfer: 1220 : 9|19:51:37.5762|PMjzFG|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:51:37.5762|PMjzFG|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:51:37.5762|PMjzFG|TMDDBA| user TMDDBA.
t Verbose: 1220 : 9|19:51:37.5762|PMjzFG|TMDDBA|OAuth. User logged in: TMDDBA
t Information: 1220 : 9|19:51:37.5762|PMjzFG|TMDDBA|V3Api.SearchWorkflowsWithMedia
t Transfer: 1220 : 9|19:51:37.5762|PMjzFG|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:51:37.5762|PMjzFG|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:51:37.5762|PMjzFG|TMDDBA| user TMDDBA.
t Information: 1220 : 9|19:51:37.5762|PMjzFG|TMDDBA|SearchJob SQL:
select * from (select a.*, rownum rnum from ( select /*+ INDEX(j JB_CMBST_IDX) */ j.*
,p.pname
,mi.tv_std
,mi.MIID1, mi.MIID2, mi.MIID3, mi.VERSIONID1, mi.VERSIONID2, mi.PROGID1, mi.PROGID2
,txd.NEXT_TX_DATE
FROM tm_mjob j
left join tm_mjob_pset p on j.j_sched_indx=p.id
left join (select j_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 m.tv_std) TV_STD from tm_mis m, tm_mtsk_it i
where m.id=i.mi_id and i.src_dest in (2,3) group by j_id) mi on mi.j_id=j.id
LEFT JOIN (
SELECT it.j_id, min(sch.tx_tm_st) NEXT_TX_DATE FROM TM_MTSK_IT it, TM_MIS m, hr_sched sch
WHERE m.id = it.MI_ID AND (sch.prod_num = m.PROGID2 OR sch.prod_num = (select rl.VERSIONID1 from TM_PG_RL rl where rl.ID = m.PGM_PARENT_ID)) AND sch.tx_tm_st > sysdate
GROUP BY J_ID) txd ON txd.j_id = j.id
where 1=1 AND j.id in (
select v.id from TM_MJOB v
where v.id in (
select t.j_id from TM_MTSK_IT t where t.mi_id in (299064) and t.src_dest in (2, 3)
UNION
select m.cret_job from TM_MIS m where m.id in (299064)) and (v.cmb_stat not in (15, 18, 19, 23) or (v.CMB_STAT = 19 and v.J_FAILURE_RESOLVED = 0)
)
)
and j.cmb_stat not in (15,18,23) AND j.J_CLI_CODE in ('03BO' , '03GD' , '03GO' , '03HA' , '03JO' , '03LI' , '03NB' , '03NM' , '03NO' , '03OR' , '03SB' , '03SC' , '03SE' , '03SG' , '03SK' , '03SM' , '03SN' , '03SS' , '03SY' , '03UP' , '03VA' , '03VB' , '03VL' , '03VT' , '3+ES' , '3PD' , '3PLV' , 'AECHD' , 'AECSD' , 'AL' , 'AMAY' , 'AMC' , 'ATP' , 'CENT' , 'CS' , 'CTCB' , 'CTCE' , 'DAVI' , 'DMA' , 'DMF' , 'DMY' , 'DTV' , 'EST' , 'EUROSPORT' , 'HDC1' , 'HDP1' , 'HDP2' , 'HUB' , 'KNL2' , 'KNVA' , 'LMH' , 'LNT' , 'MBNS' , 'MED' , 'MM' , 'MTG' , 'NAA' , 'NICK' , 'NVA' , 'OSP' , 'PBOY' , 'PMS' , 'PPL' , 'PSP' , 'Play' , 'RTR' , 'SFP1' , 'SFP2' , 'SPG' , 'SPTV' , 'T3LT' , 'T3LV' , 'T6LT' , 'T6LV' , 'T8LT' , 'TECHM' , 'TMD' , 'TV10' , 'TV1A' , 'TV1B' , 'TV1C' , 'TV1D' , 'TV1E' , 'TV1F' , 'TV1K' , 'TV1N' , 'TV1P' , 'TV1S' , 'TV2S' , 'TV3D' , 'TV3N' , 'TV3S' , 'TV5L' , 'TV6E' , 'TV6H' , 'TV6N' , 'TV6S' , 'TV8' , 'TVAE' , 'TVDP' , 'TVPB' , 'TVPU' , 'TVSL' , 'V1G' , 'V1TZ' , 'V3H' , 'V4N' , 'VEC' , 'VEPL' , 'VEPO' , 'VEXE' , 'VEXR' , 'VHIS' , 'VHPO' , 'VNC' , 'VNE' , 'VNH' , 'VNHD' , 'VNPO' , 'VODD' , 'VODE' , 'VODF' , 'VODN' , 'VODS' , 'VS2' , 'VS3' , 'VSAT' , 'VSD' , 'VSD2' , 'VSE' , 'VSG' , 'VSHD' , 'VSS' , 'WCIU' , 'YLE TV1' , 'ZTVS') order by j.J_COMPL_BY, j.id desc, j.id ) a where rownum <= 50) where rnum >= 1 order by rnum
t Information: 1220 : 9|19:51:37.5762|PMjzFG|TMDDBA| jobs returned 7, searched in 00:00:00.0081662
t Information: 1220 : 9|19:51:37.5762|PMjzFG|TMDDBA|TechReports is not found. ID: 96.
t Information: 1220 : 9|19:51:37.5762|PMjzFG|TMDDBA|TechReports is not found. ID: 41.
t Information: 1220 : 9|19:51:37.5762|PMjzFG|TMDDBA|TechReports is not found. ID: 1633.
t Information: 1220 : 9|19:51:37.5762|PMjzFG|TMDDBA|TechReports is not found. ID: 1300.
t Information: 1220 : 9|19:51:37.5762|PMjzFG|TMDDBA|TechReports is not found. ID: 116.
t Information: 1220 : 9|19:51:37.5762|PMjzFG|TMDDBA|TechReports is not found. ID: 673.
t Information: 1220 : 9|19:51:37.5762|PMjzFG|TMDDBA| tasks returned 7, searched in 00:00:00.0185366
t Verbose: 1220 : 9|19:51:37.5762|PMjzFG|TMDDBA|imfx v3 API took 0.032s '/api/v3/search/workflow/media?_dc=1585680697440'
t Transfer: 1220 : 9|19:51:38.1856|0_8Obx|TMDDBA|OAuth: /api/v3/search/workflow/media?_dc=1585680698032
t Transfer: 1220 : 9|19:51:38.1856|0_8Obx|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:51:38.1856|0_8Obx|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:51:38.1856|0_8Obx|TMDDBA| user TMDDBA.
t Verbose: 1220 : 9|19:51:38.1856|0_8Obx|TMDDBA|OAuth. User logged in: TMDDBA
t Information: 1220 : 9|19:51:38.1856|0_8Obx|TMDDBA|V3Api.SearchWorkflowsWithMedia
t Transfer: 1220 : 9|19:51:38.1856|0_8Obx|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:51:38.1856|0_8Obx|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:51:38.1856|0_8Obx|TMDDBA| user TMDDBA.
t Information: 1220 : 9|19:51:38.1856|0_8Obx|TMDDBA|SearchJob SQL:
select * from (select a.*, rownum rnum from ( select /*+ INDEX(j JB_CMBST_IDX) */ j.*
,p.pname
,mi.tv_std
,mi.MIID1, mi.MIID2, mi.MIID3, mi.VERSIONID1, mi.VERSIONID2, mi.PROGID1, mi.PROGID2
,txd.NEXT_TX_DATE
FROM tm_mjob j
left join tm_mjob_pset p on j.j_sched_indx=p.id
left join (select j_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 m.tv_std) TV_STD from tm_mis m, tm_mtsk_it i
where m.id=i.mi_id and i.src_dest in (2,3) group by j_id) mi on mi.j_id=j.id
LEFT JOIN (
SELECT it.j_id, min(sch.tx_tm_st) NEXT_TX_DATE FROM TM_MTSK_IT it, TM_MIS m, hr_sched sch
WHERE m.id = it.MI_ID AND (sch.prod_num = m.PROGID2 OR sch.prod_num = (select rl.VERSIONID1 from TM_PG_RL rl where rl.ID = m.PGM_PARENT_ID)) AND sch.tx_tm_st > sysdate
GROUP BY J_ID) txd ON txd.j_id = j.id
where 1=1 AND j.id in (
select v.id from TM_MJOB v
where v.id in (
select t.j_id from TM_MTSK_IT t where t.mi_id in (299064) and t.src_dest in (2, 3)
UNION
select m.cret_job from TM_MIS m where m.id in (299064)) and (v.cmb_stat not in (15, 18, 19, 23) or (v.CMB_STAT = 19 and v.J_FAILURE_RESOLVED = 0)
)
)
and j.cmb_stat not in (15,18,23) AND j.J_CLI_CODE in ('03BO' , '03GD' , '03GO' , '03HA' , '03JO' , '03LI' , '03NB' , '03NM' , '03NO' , '03OR' , '03SB' , '03SC' , '03SE' , '03SG' , '03SK' , '03SM' , '03SN' , '03SS' , '03SY' , '03UP' , '03VA' , '03VB' , '03VL' , '03VT' , '3+ES' , '3PD' , '3PLV' , 'AECHD' , 'AECSD' , 'AL' , 'AMAY' , 'AMC' , 'ATP' , 'CENT' , 'CS' , 'CTCB' , 'CTCE' , 'DAVI' , 'DMA' , 'DMF' , 'DMY' , 'DTV' , 'EST' , 'EUROSPORT' , 'HDC1' , 'HDP1' , 'HDP2' , 'HUB' , 'KNL2' , 'KNVA' , 'LMH' , 'LNT' , 'MBNS' , 'MED' , 'MM' , 'MTG' , 'NAA' , 'NICK' , 'NVA' , 'OSP' , 'PBOY' , 'PMS' , 'PPL' , 'PSP' , 'Play' , 'RTR' , 'SFP1' , 'SFP2' , 'SPG' , 'SPTV' , 'T3LT' , 'T3LV' , 'T6LT' , 'T6LV' , 'T8LT' , 'TECHM' , 'TMD' , 'TV10' , 'TV1A' , 'TV1B' , 'TV1C' , 'TV1D' , 'TV1E' , 'TV1F' , 'TV1K' , 'TV1N' , 'TV1P' , 'TV1S' , 'TV2S' , 'TV3D' , 'TV3N' , 'TV3S' , 'TV5L' , 'TV6E' , 'TV6H' , 'TV6N' , 'TV6S' , 'TV8' , 'TVAE' , 'TVDP' , 'TVPB' , 'TVPU' , 'TVSL' , 'V1G' , 'V1TZ' , 'V3H' , 'V4N' , 'VEC' , 'VEPL' , 'VEPO' , 'VEXE' , 'VEXR' , 'VHIS' , 'VHPO' , 'VNC' , 'VNE' , 'VNH' , 'VNHD' , 'VNPO' , 'VODD' , 'VODE' , 'VODF' , 'VODN' , 'VODS' , 'VS2' , 'VS3' , 'VSAT' , 'VSD' , 'VSD2' , 'VSE' , 'VSG' , 'VSHD' , 'VSS' , 'WCIU' , 'YLE TV1' , 'ZTVS') order by j.J_COMPL_BY, j.id desc, j.id ) a where rownum <= 50) where rnum >= 1 order by rnum
t Information: 1220 : 9|19:51:38.1856|0_8Obx|TMDDBA| jobs returned 7, searched in 00:00:00.0079965
t Information: 1220 : 9|19:51:38.1856|0_8Obx|TMDDBA|TechReports is not found. ID: 96.
t Information: 1220 : 9|19:51:38.1856|0_8Obx|TMDDBA|TechReports is not found. ID: 41.
t Information: 1220 : 9|19:51:38.1856|0_8Obx|TMDDBA|TechReports is not found. ID: 1633.
t Information: 1220 : 9|19:51:38.1856|0_8Obx|TMDDBA|TechReports is not found. ID: 1300.
t Information: 1220 : 9|19:51:38.1856|0_8Obx|TMDDBA|TechReports is not found. ID: 116.
t Information: 1220 : 9|19:51:38.1856|0_8Obx|TMDDBA|TechReports is not found. ID: 673.
t Information: 1220 : 9|19:51:38.1856|0_8Obx|TMDDBA| tasks returned 7, searched in 00:00:00.0193063
t Verbose: 1220 : 9|19:51:38.1856|0_8Obx|TMDDBA|imfx v3 API took 0.033s '/api/v3/search/workflow/media?_dc=1585680698032'
t Transfer: 1220 : 9|19:51:39.6075|KymHaB|TMDDBA|OAuth: /api/v3/mediaorder?_dc=1585680699395
t Transfer: 1220 : 9|19:51:39.6075|KymHaB|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:51:39.6075|KymHaB|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:51:39.6075|KymHaB|TMDDBA| user TMDDBA.
t Verbose: 1220 : 9|19:51:39.6075|KymHaB|TMDDBA|OAuth. User logged in: TMDDBA
t Transfer: 1220 : 9|19:51:39.6075|KymHaB|TMDDBA| semaphore enter at: 3/31/2020 7:51:39 PM count: 9 thread: 30
t Transfer: 1220 : 9|19:51:39.6075|KymHaB|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:51:39.6075|KymHaB|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:51:39.6075|KymHaB|TMDDBA| user TMDDBA.
t Information: 1220 : 9|19:51:39.6075|KymHaB|TMDDBA|CallApi. In. Trace-id: h1g6P3 Msg: createworkflow. User: TMDDBA. Rights: False.
t Information: 1220 : 9|19:51:39.6075|KymHaB|TMDDBA|
2352
media/299064
t Information: 1220 : 9|19:51:40.4199|KymHaB|TMDDBA|CallApi. Out. Trace-id: h1g6P3 808.1ms.
t Information: 1220 : 9|19:51:40.4199|KymHaB|TMDDBA|
job/108772
108772
2352
PmH Subtitle Approval
TMD
Ready
2020-03-31T18:45:52
task/108773
job/108772
108773
Source Media Filter
1
Completed
2020-03-31T19:51:39
2020-03-31T19:51:40
task/108776
job/108772
108776
Workflow Decisions
2
Task Dependent
task/108779
job/108772
108779
Assess
3
Task Dependent
task/108782
job/108772
108782
Raise Workflows
4
Task Dependent
t Transfer: 1220 : 9|19:51:40.4199|KymHaB|TMDDBA| semaphore release at: 3/31/2020 7:51:40 PM count: 9 thread: 30
t Information: 1220 : 9|19:51:40.4199|KymHaB|TMDDBA|TechReports is not found. ID: 673.
t Verbose: 1220 : 9|19:51:40.4199|KymHaB|TMDDBA|imfx v3 API took 0.840s '/api/v3/mediaorder?_dc=1585680699395'
t Transfer: 1220 : 9|19:51:40.4199|Vi2mmb|TMDDBA|OAuth: /api/user-preferences?_dc=1585680700284
t Transfer: 1220 : 9|19:51:40.4199|Vi2mmb|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:51:40.4199|Vi2mmb|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:51:40.4199|Vi2mmb|TMDDBA| user TMDDBA.
t Verbose: 1220 : 9|19:51:40.4199|Vi2mmb|TMDDBA|OAuth. User logged in: TMDDBA
t Verbose: 1220 : 9|19:51:40.4199|Vi2mmb|TMDDBA|StoreUserDataByKeys..
t Transfer: 1220 : 9|19:51:40.4199|Vi2mmb|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:51:40.4199|Vi2mmb|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:51:40.4199|Vi2mmb|TMDDBA| user TMDDBA.
t Verbose: 1220 : 9|19:51:40.4199|Vi2mmb|TMDDBA|imfx v3 API took 0.004s '/api/user-preferences?_dc=1585680700284'
t Transfer: 1220 : 9|19:51:44.0762|RMpWBv|TMDDBA|OAuth: /api/v3/job/108772?_dc=1585680703869
t Transfer: 1220 : 9|19:51:44.0762|RMpWBv|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:51:44.0762|RMpWBv|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:51:44.0762|RMpWBv|TMDDBA| user TMDDBA.
t Verbose: 1220 : 9|19:51:44.0762|RMpWBv|TMDDBA|OAuth. User logged in: TMDDBA
t Information: 1220 : 9|19:51:44.0762|RMpWBv|TMDDBA|TechReports is not found. ID: 673.
t Information: 1220 : 9|19:51:44.0762|RMpWBv|TMDDBA|TechReports is not found. ID: 1300.
t Information: 1220 : 9|19:51:44.0762|RMpWBv|TMDDBA|TechReports is not found. ID: 1301.
t Verbose: 1220 : 9|19:51:44.0762|RMpWBv|TMDDBA|imfx v3 API took 0.132s '/api/v3/job/108772?_dc=1585680703869'
t Transfer: 1220 : 9|19:51:44.0762|RMpWBv|TMDDBA|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\N0001864.mpd subfolder
t Transfer: 1220 : 9|19:51:44.0762|RMpWBv|TMDDBA| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/N0001864.mpd
t Transfer: 1220 : 9|19:51:44.0762|RMpWBv|TMDDBA|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/N0001864.mpd
t Transfer: 1220 : 9|19:51:44.0762|RMpWBv|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:51:44.0762|RMpWBv|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:51:44.0762|RMpWBv|TMDDBA| user TMDDBA.
t Transfer: 1220 : 9|19:51:46.1074|Vj~yga|TMDDBA|OAuth: /api/v3/task/108779/history?_dc=1585680705970
t Transfer: 1220 : 9|19:51:46.1074|Vj~yga|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:51:46.1074|Vj~yga|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:51:46.1074|Vj~yga|TMDDBA| user TMDDBA.
t Verbose: 1220 : 9|19:51:46.1074|Vj~yga|TMDDBA|OAuth. User logged in: TMDDBA
t Information: 1220 : 9|19:51:46.1074|Vj~yga|TMDDBA|V3Api. GetTaskStatusHistory.
t Verbose: 1220 : 9|19:51:46.1074|Vj~yga|TMDDBA|imfx v3 API took 0.020s '/api/v3/task/108779/history?_dc=1585680705970'
t Transfer: 1220 : 9|19:51:46.3106|G1L77I|TMDDBA|OAuth: /api/v3/task/108779/history?_dc=1585680706144
t Transfer: 1220 : 9|19:51:46.3106|G1L77I|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:51:46.3106|G1L77I|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:51:46.3106|G1L77I|TMDDBA| user TMDDBA.
t Verbose: 1220 : 9|19:51:46.3106|G1L77I|TMDDBA|OAuth. User logged in: TMDDBA
t Information: 1220 : 9|19:51:46.3106|G1L77I|TMDDBA|V3Api. GetTaskStatusHistory.
t Verbose: 1220 : 9|19:51:46.3106|G1L77I|TMDDBA|imfx v3 API took 0.004s '/api/v3/task/108779/history?_dc=1585680706144'
t Transfer: 1220 : 9|19:51:47.1231|kYXQIb|TMDDBA|OAuth: /api/v3/task/componentqc/108779?_dc=1585680707017
t Transfer: 1220 : 9|19:51:47.1231|kYXQIb|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:51:47.1231|kYXQIb|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:51:47.1231|kYXQIb|TMDDBA| user TMDDBA.
t Verbose: 1220 : 9|19:51:47.1231|kYXQIb|TMDDBA|OAuth. User logged in: TMDDBA
t Information: 1220 : 9|19:51:47.1231|kYXQIb|TMDDBA|V3Api. GetComponentQc task: 108779
t Information: 1220 : 9|19:51:48.3418|f73kH2|TMDDBA|GetUserProfile. Id: 30000
t Transfer: 1220 : 9|19:51:48.3418|f73kH2|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:51:48.3418|f73kH2|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:51:48.3418|f73kH2|TMDDBA| user TMDDBA.
t Information: 1220 : 9|19:51:48.5450|kYXQIb|TMDDBA|SubtitleQcTask. LoadFromDb got Job 108772 and Subtitles 3.
t Information: 1220 : 9|19:51:48.5450|kYXQIb|TMDDBA|SubtitleQcTask. LoadFromDb processing Media 299009.
t Information: 1220 : 9|19:51:48.5450|kYXQIb|TMDDBA|SubtitleQcTask. LoadFromDb processing Media 299064.
t Information: 1220 : 9|19:51:48.5450|kYXQIb|TMDDBA|SubtitleQcTask. LoadFromDb processing Media 299072.
t Information: 1220 : 9|19:51:48.5450|kYXQIb|TMDDBA|LoadSubtitlesById. filename PMH_s1ep1_pt1 - Copy.scc device TimedText frame rate NTCS_DF
t Information: 1220 : 9|19:51:48.5450|kYXQIb|TMDDBA|LoadSubtitlesById. Filename: PMH_s1ep1_pt1 - Copy.scc. Device TimedText. Timecode format NTCS_DF. Media ID 0.
t Information: 1220 : 9|19:51:48.5450|kYXQIb|TMDDBA|GetCaptions. Start. Filename: PMH_s1ep1_pt1 - Copy.scc. Cache path C:\inetpub\wwwroot\imfxcore\timedtextcache\. Storage path \\192.168.120.254\DemoFS\Digital Assets\TimedText. Last Modified 1/1/0001 12:00:00 AM
t Information: 1220 : 9|19:51:48.5450|kYXQIb|TMDDBA|GetCaptions. Convert required. Som 00:00:00. From: \\192.168.120.254\DemoFS\Digital Assets\TimedText\PMH_s1ep1_pt1 - Copy.scc to: C:\inetpub\wwwroot\imfxcore\timedtextcache\PMH_s1ep1_pt1 - Copy.scc_ntcs_df_0.xml
t Information: 1220 : 9|19:51:48.5450|kYXQIb|TMDDBA|GetCaptions. Convertor lock aquired.
t Information: 1220 : 9|19:51:48.5450|kYXQIb|TMDDBA|GetCaptions. File converted: \\192.168.120.254\DemoFS\Digital Assets\TimedText\PMH_s1ep1_pt1 - Copy.scc. Result: True
t Information: 1220 : 9|19:51:48.5450|kYXQIb|TMDDBA|GetCaptions. In cache. Filename: C:\inetpub\wwwroot\imfxcore\timedtextcache\PMH_s1ep1_pt1 - Copy.scc_ntcs_df_0.xml
t Information: 1220 : 9|19:51:48.5450|kYXQIb|TMDDBA|LoadSubtitlesById. Convertor lock acquired.
t Information: 1220 : 9|19:51:48.5450|kYXQIb|TMDDBA|LoadSubtitlesById got 43 lines.
t Information: 1220 : 9|19:51:48.5450|kYXQIb|TMDDBA|TM_MIS. LoadSubtitles for ID: 299064
t Information: 1220 : 9|19:51:48.5450|kYXQIb|TMDDBA|TM_MIS. LoadSubtitles for ID: 299064. 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 m.id in (299072)'
t Information: 1220 : 9|19:51:48.5450|kYXQIb|TMDDBA| Subtitles added for ID: 299064, 299072 Unknown [0] : 'https://imfxv3tm.tmd.tv/getcaptions.aspx?f=PMH_s1ep1_pt1 - Copy.scc&som=00:00:00:00&storage=TimedText&modified=637212770340000000&tcf=0&id=299072&tmp=0'.
t Information: 1220 : 9|19:51:48.5450|kYXQIb|TMDDBA|SubtitleQcTask. LoadFromDb finished.
t Verbose: 1220 : 9|19:51:48.5450|kYXQIb|TMDDBA|imfx v3 API took 1.455s '/api/v3/task/componentqc/108779?_dc=1585680707017'
t Transfer: 1220 : 9|19:51:48.5450|kYXQIb|TMDDBA|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\N0001864.mpd subfolder
t Transfer: 1220 : 9|19:51:48.5450|kYXQIb|TMDDBA| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/N0001864.mpd
t Transfer: 1220 : 9|19:51:48.5450|kYXQIb|TMDDBA|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/N0001864.mpd
t Transfer: 1220 : 9|19:51:48.5450|kYXQIb|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:51:48.5450|kYXQIb|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:51:48.5450|kYXQIb|TMDDBA| user TMDDBA.
t Transfer: 1220 : 9|19:51:48.7481|cUfEFA|TMDDBA|OAuth: /api/v3/detailsview/Job/0?lang=en-GB&_dc=1585680708527
t Transfer: 1220 : 9|19:51:48.7481|cUfEFA|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:51:48.7481|cUfEFA|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:51:48.7481|cUfEFA|TMDDBA| user TMDDBA.
t Verbose: 1220 : 9|19:51:48.7481|cUfEFA|TMDDBA|OAuth. User logged in: TMDDBA
t Verbose: 1220 : 9|19:51:48.7481|cUfEFA|TMDDBA|imfx v3 API took 0.003s '/api/v3/detailsview/Job/0?lang=en-GB&_dc=1585680708527'
t Transfer: 1220 : 9|19:51:48.7481|_vhTIS|TMDDBA|OAuth: /api/v3/detailsview/MediaDetails/[object Object]?lang=en-GB&_dc=1585680708558
t Transfer: 1220 : 9|19:51:48.7481|_vhTIS|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:51:48.7481|_vhTIS|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:51:48.7481|_vhTIS|TMDDBA| user TMDDBA.
t Verbose: 1220 : 9|19:51:48.7481|_vhTIS|TMDDBA|OAuth. User logged in: TMDDBA
t Verbose: 1220 : 9|19:51:48.7481|_vhTIS|TMDDBA|imfx v3 API took 0.002s '/api/v3/detailsview/MediaDetails/%5Bobject%20Object%5D?lang=en-GB&_dc=1585680708558'
t Transfer: 1220 : 9|19:51:48.7481|n4Pnsq|TMDDBA|OAuth: /api/v3/layout/default/10?_dc=1585680708610
t Transfer: 1220 : 9|19:51:48.7481|n4Pnsq|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:51:48.7481|n4Pnsq|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:51:48.7481|n4Pnsq|TMDDBA| user TMDDBA.
t Verbose: 1220 : 9|19:51:48.7481|n4Pnsq|TMDDBA|OAuth. User logged in: TMDDBA
t Information: 1220 : 9|19:51:48.7481|n4Pnsq|TMDDBA|LoadDefaultDashboard.
t Transfer: 1220 : 9|19:51:48.7481|n4Pnsq|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:51:48.7481|n4Pnsq|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:51:48.7481|n4Pnsq|TMDDBA| user TMDDBA.
t Verbose: 1220 : 9|19:51:48.7481|n4Pnsq|TMDDBA|imfx v3 API took 0.004s '/api/v3/layout/default/10?_dc=1585680708610'
t Transfer: 1220 : 9|19:51:49.3574|WeVEY~|TMDDBA|OAuth: /api/user-group-preferences?globals=htmlplayerhotkeys,audioOnFrameForward&_dc=1585680709142
t Transfer: 1220 : 9|19:51:49.3574|WeVEY~|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:51:49.3574|WeVEY~|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:51:49.3574|WeVEY~|TMDDBA| user TMDDBA.
t Verbose: 1220 : 9|19:51:49.3574|WeVEY~|TMDDBA|OAuth. User logged in: TMDDBA
t Transfer: 1220 : 9|19:51:49.3574|WeVEY~|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:51:49.3574|WeVEY~|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:51:49.3574|WeVEY~|TMDDBA| user TMDDBA.
t Verbose: 1220 : 9|19:51:49.3574|WeVEY~|TMDDBA|imfx v3 API took 0.003s '/api/user-group-preferences?globals=htmlplayerhotkeys,audioOnFrameForward&_dc=1585680709142'
t Transfer: 1220 : 9|19:51:49.3574|ZtPcT~|TMDDBA|OAuth: /api/v3/mediavideo/299064?info=smudge&_dc=1585680709175
t Transfer: 1220 : 9|19:51:49.3574|ZtPcT~|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:51:49.3574|ZtPcT~|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:51:49.3574|ZtPcT~|TMDDBA| user TMDDBA.
t Verbose: 1220 : 9|19:51:49.3574|ZtPcT~|TMDDBA|OAuth. User logged in: TMDDBA
t Transfer: 1220 : 9|19:51:49.3574|ZtPcT~|TMDDBA|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\N0001864.mpd subfolder
t Transfer: 1220 : 9|19:51:49.3574|ZtPcT~|TMDDBA| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/N0001864.mpd
t Transfer: 1220 : 9|19:51:49.3574|ZtPcT~|TMDDBA|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/N0001864.mpd
t Transfer: 1220 : 9|19:51:49.3574|ZtPcT~|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:51:49.3574|ZtPcT~|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:51:49.3574|ZtPcT~|TMDDBA| user TMDDBA.
t Verbose: 1220 : 9|19:51:49.3574|ZtPcT~|TMDDBA|imfx v3 API took 0.011s '/api/v3/mediavideo/299064?info=smudge&_dc=1585680709175'
t Information: 1220 : 9|19:51:49.5606|E~HUno||GetCaptionsForWeb. Filename: PMH_s1ep1_pt1 - Copy.scc. Device TimedText. Format WebVTT. Timecode format Pal. Media ID 299072. Last Modified 3/31/2020 6:43:54 PM
t Information: 1220 : 9|19:51:49.5606|E~HUno||GetCaptions. Start. Filename: PMH_s1ep1_pt1 - Copy.scc. Cache path C:\inetpub\wwwroot\imfxcore\timedtextcache\. Storage path \\192.168.120.254\DemoFS\Digital Assets\TimedText. Last Modified 3/31/2020 6:43:54 PM
t Information: 1220 : 9|19:51:49.5606|E~HUno||GetCaptions. No refresh needed. Filename: C:\inetpub\wwwroot\imfxcore\timedtextcache\PMH_s1ep1_pt1 - Copy.scc_pal_299072.vtt
t Information: 1220 : 9|19:51:49.5606|E~HUno||GetCaptions. In cache. Filename: C:\inetpub\wwwroot\imfxcore\timedtextcache\PMH_s1ep1_pt1 - Copy.scc_pal_299072.vtt
t Information: 1220 : 9|19:52:50.0918|Zz74Y~|TMDDBA|GetUserProfile. Id: 30000
t Transfer: 1220 : 9|19:52:50.0918|Zz74Y~|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:52:50.0918|Zz74Y~|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:52:50.0918|Zz74Y~|TMDDBA| user TMDDBA.
t Information: 1220 : 9|19:53:51.2325|n5IR3A|TMDDBA|GetUserProfile. Id: 30000
t Transfer: 1220 : 9|19:53:51.2325|n5IR3A|TMDDBA|GetCurrentUser..
t Transfer: 1220 : 9|19:53:51.2325|n5IR3A|TMDDBA| OAuth authenticated
t Transfer: 1220 : 9|19:53:51.2325|n5IR3A|TMDDBA| user TMDDBA.
t Information: 1220 : 9|19:54:42.2169|||OrabitWatcherBasic. Disposing.
t Information: 1220 : 9|19:54:42.2169|||OrabitWatcherBasic. Disposed.
t Information: 1220 : 9|19:54:42.2169|||==========================================================================
t Information: 1220 : 9|19:54:42.2169|||IMFX CORE SERVER APPLICATION END.