t Information: 1220 :  10|11:47:16.2292|||Get Configuration Values:
t Information: 1220 :  10|11:47:16.2292|||	AdminPassEnc, default: , value: ffqjrn0leKv4Lj2YJHe2dw==.
t Information: 1220 :  10|11:47:16.2292|||	EncryptedPasswords, default: false, value: true.
t Information: 1220 :  10|11:47:16.2292|||	OraConnectionString, default: , value: Server=TECHM;User Id=imfx;Password=xxxxx;Unicode=true;.
t Information: 1220 :  10|11:47:16.2292|||	SecondTimezone, default: , value: .
t Information: 1220 :  10|11:47:16.2292|||	UseActiveDirectoryAuth, default: false, value: false.
t Information: 1220 :  10|11:47:16.2292|||	ReportingServiceUrl, default: , value: http://localhost:92/ReportingService.svc.
t Information: 1220 :  10|11:47:16.2292|||	ReportsPath, default: , value: .
t Information: 1220 :  10|11:47:16.2292|||	ReportsURL, default: , value: .
t Information: 1220 :  10|11:47:16.2292|||	TapeServiceUrl, default: , value: .
t Information: 1220 :  10|11:47:16.2292|||	GatekeeperUrl, default: , value: .
t Information: 1220 :  10|11:47:16.2292|||	ValuationUrl, default: , value: .
t Information: 1220 :  10|11:47:16.2292|||	QueueManagerDelay, default: 30, value: 30.
t Information: 1220 :  10|11:47:16.2292|||	QueueManagerFullRefresh, default: 90, value: 90.
t Information: 1220 :  10|11:47:16.2292|||	AudioLoopDuration, default: 0, value: 150.
t Information: 1220 :  10|11:47:16.2292|||	AudioLoopsCount, default: 0, value: 0.
t Information: 1220 :  10|11:47:16.2292|||	PlayerFakeStep, default: 500, value: 500.
t Information: 1220 :  10|11:47:16.2292|||	PlayerForceRatio, default: 0, value: 1.
t Information: 1220 :  10|11:47:16.2292|||	CheckVersionsInProd, default: false, value: True.
t Information: 1220 :  10|11:47:16.2292|||	MaxResults, default: 3000, value: 10000.
t Information: 1220 :  10|11:47:16.2292|||	TEReportID, default: 0, value: 0.
t Information: 1220 :  10|11:47:16.2292|||	ClosedCaptionsCache, default: , value: C:\inetpub\wwwroot\imfxcore\timedtextcache\.
t Information: 1220 :  10|11:47:16.2292|||	ClosedCaptionsStorage, default: , value: c:\Mediaflex\subs.
t Information: 1220 :  10|11:47:16.2292|||	TimeCodeFormat, default: , value: pal.
t Information: 1220 :  10|11:47:16.2292|||	RceMediaPath, default: , value: C:\edl\.
t Information: 1220 :  10|11:47:16.2292|||	RceMediaPath, default: , value: C:\edl\.
t Information: 1220 :  10|11:47:16.2292|||	RceCsmOutputPath, default: , value: C:\Inetpub\wwwroot\csm\.
t Information: 1220 :  10|11:47:16.2292|||	RceCsmUrl, default: , value: http://localhost/csm/.
t Information: 1220 :  10|11:47:16.2292|||	RceMediaSelection, default: , value: miLinkIdMatch.
t Information: 1220 :  10|11:47:16.2292|||	RequestBrowseJobPresetName, default: , value: .
t Information: 1220 :  10|11:47:16.2292|||	DontExtendDuration, default: false, value: False.
t Information: 1220 :  10|11:47:16.2292|||	V3ConfigUrl, default: , value: .
t Information: 1220 :  10|11:47:16.2292|||	StopWords, default: , value: .
t Information: 1220 :  10|11:47:16.2292|||	MisrTxFormat, default: G, value: G.
t Information: 1220 :  10|11:47:16.2292|||	ApiServer, default: , value: http://192.168.120.10:85.
t Information: 1220 :  10|11:47:16.2292|||	ApiTimeout, default: 120, value: 120.
t Information: 1220 :  10|11:47:16.2292|||	ApiWorkers, default: 10, value: 10.
t Information: 1220 :  10|11:47:16.2292|||	UsePerfCounters, default: false, value: false.
t Information: 1220 :  10|11:47:16.2292|||	LogGetCurrentUser, default: true, value: true.
t Information: 1220 :  10|11:47:16.2292|||	LogInternalApi, default: true, value: true.
t Information: 1220 :  10|11:47:16.2292|||	ThumbnailServer, default: , value: .
t Information: 1220 :  10|11:47:16.2292|||	LocationFilter, default: , value: .
t Information: 1220 :  10|11:47:16.2292|||	SvUtilServiceUrl, default: , value: .
t Information: 1220 :  10|11:47:16.2292|||	SolrConnection, default: , value: http://192.168.120.14:8983/solr.
t Information: 1220 :  10|11:47:16.2292|||	UseIndexServerSearch, default: false, value: True.
t Information: 1220 :  10|11:47:16.2292|||	SolrIndexVersion, default: 1, value: 6.
t Information: 1220 :  10|11:47:16.2292|||	SolrConnection, default: , value: http://192.168.120.14:8983/solr.
t Information: 1220 :  10|11:47:16.2292|||	FacetsGroups, default: , value: owners,season_id, series_id,version_key,item_type,media_type,media_format,episode_number.
t Information: 1220 :  10|11:47:16.2292|||	FacetsGroupsVersion, default: , value: owners,season_id, series_id,version_key,episode_number.
t Information: 1220 :  10|11:47:16.2292|||	FacetsGroupsChameleon, default: , value: season_id, series_id,genre,prod_year,version_key.
t Information: 1220 :  10|11:47:16.2292|||	PreviewPreset, default: , value: .
t Information: 1220 :  10|11:47:16.2292|||	DevMode, default: false, value: false.
t Information: 1220 :  10|11:47:16.2292|||	DisableSysMan, default: false, value: false.
t Information: 1220 :  10|11:47:16.2292|||	TimeCodeFormat, default: , value: pal.
t Information: 1220 :  10|11:47:16.2292|||	FileCatalystStorageDevice, default: , value: .
t Information: 1220 :  10|11:47:16.2292|||	UseResponsibilityTracking, default: true, value: True.
t Information: 1220 :  10|11:47:16.2292|||	SubtitleDeviceFilter, default: , value: .
t Information: 1220 :  10|11:47:16.2292|||	SystemMonitorNamedPipe, default: , value: .
t Information: 1220 :  10|11:47:16.2292|||	OracleMonitorEnable, default: false, value: False.
t Information: 1220 :  10|11:47:16.2292|||	ArcApiHost, default: , value: .
t Information: 1220 :  10|11:47:16.2292|||	RabbitMqUrl, default: , value: amqp://192.168.120.14:5672.
t Information: 1220 :  10|11:47:16.2292|||	SolrTimedTextSearch, default: false, value: false.
t Information: 1220 :  10|11:47:16.2292|||	ProductionDurationUsageID, default: 1, value: 1.
t Information: 1220 :  10|11:47:16.4480|||GetStreamServers..
t Information: 1220 :  10|11:47:17.2605|||	https://demo.tmd.tv/CBR Video/ |CBR Video| False  
t Information: 1220 :  10|11:47:17.2605|||	https://demo.tmd.tv/CBR Images/ |CBR Images| False  
t Information: 1220 :  10|11:47:17.2605|||	https://demo.tmd.tv/CBR Audio/ |CBR Audio| False  
t Information: 1220 :  10|11:47:17.2605|||	https://demo.tmd.tv/Temp Upload/ |TEMP_UPLOAD| False  
t Information: 1220 :  10|11:47:17.2605|||	http://localhost:82/images/ |IMAGES| False  
t Information: 1220 :  10|11:47:17.2605|||	http://192.168.91.73/smoothcloud/ |SMOOTH_CLOUD| False  
t Information: 1220 :  10|11:47:17.2605|||	http://192.168.91.73/cloudstore/ |CLOUD_STORE| False  
t Information: 1220 :  10|11:47:17.2605|||	http://192.168.91.73/editsystemin/ |EDIT_SYSTEM_IN| False  
t Information: 1220 :  10|11:47:17.2605|||	http://192.168.91.27:89/APPLEPROXY/ |APPLE_PROXY| False  
t Information: 1220 :  10|11:47:17.2605|||	http://localhost:82/video/ |FILESTORE_VIDEO| False  
t Information: 1220 :  10|11:47:17.2605|||	https://imfxv3tm.tmd.tv/streaming/ |Streaming| False  
t Information: 1220 :  10|11:47:17.2605|||	https://imfxv3tm.tmd.tv/VideoServer/ |Video| False  
t Information: 1220 :  10|11:47:17.2605|||	https://imfxv3tm.tmd.tv/AdobeIn/ |Adobe Premiere Pro In| False  
t Information: 1220 :  10|11:47:17.2605|||	https://imfxv3tm.tmd.tv/AudioServer/ |Audio| False  
t Information: 1220 :  10|11:47:17.2605|||	https://imfxv3tm.tmd.tv/ImageServer/ |Image| False  
t Information: 1220 :  10|11:47:17.2605|||	https://imfxv3tm.tmd.tv/DocsServer/ |Docs| False  
t Information: 1220 :  10|11:47:17.2605|||	https://imfxv3tm.tmd.tv/AmazonLabs/ |TEST HOUSE| False  
t Information: 1220 :  10|11:47:17.2605|||	SolrConnectionUms, default: http://192.168.120.14:8983/solr, value: http://192.168.120.14:8983/solr.
t Information: 1220 :  10|11:47:17.2605|||	LogWebApi, default: false, value: false.
t Information: 1220 :  10|11:47:17.2605|||	EmbeddedRceUrl, default: , value: .
t Information: 1220 :  10|11:47:17.2605|||	InstallMode, default: , value: .
t Information: 1220 :  10|11:47:17.2605|||	SamlRequestAddress, default: , value: .
t Information: 1220 :  10|11:47:17.2605|||	SamlTrustedIssuer, default: , value: .
t Information: 1220 :  10|11:47:17.2605|||	SamlLoginRedirect, default: , value: .
t Information: 1220 :  10|11:47:17.2605|||	NaturalLangSearch, default: false, value: True.
t Information: 1220 :  10|11:47:17.2605|||	LocalUploadExpirationHours, default: 0, value: 0.
t Information: 1220 :  10|11:47:17.2605|||	OktaLoginField, default: , value: .
t Information: 1220 :  10|11:47:17.2605|||	AuthenticationTypes, default: , value: Native,PublicApiKey.
t Information: 1220 :  10|11:47:17.2605|||OrabitWatcherBasic. Initialize.
t Information: 1220 :  10|11:47:17.4636|||FillDictionaryCache.
t Information: 1220 :  10|11:47:21.1511|||GetSupportedOperators
t Information: 1220 :  10|11:47:21.5573|||CacheTechReports.
t Information: 1220 :  10|11:47:21.5573|||& Cache update. Server (global) filled with timestamp 11:07:21.4636263. types null
t Information: 1220 :  10|11:47:21.5573|||InitializeFromDatabase.
  'Server=TECHM;User Id=imfx;password=..;Unicode=true;'
  direct False, home , timeout 15
t Information: 1220 :  10|11:47:21.5573|||FillDictionaryCache.
t Information: 1220 :  10|11:47:21.5573|||& Cache update. Server (global) filled with timestamp 11:07:21.4792728. types FriendlyNames, DatabaseSearchFieldData
t Information: 1220 :  10|11:47:22.1823|||==========================================================================
t Information: 1220 :  10|11:47:22.1823|||IMFX CORE SERVER APPLICATION START.
t Information: 1220 :  10|11:47:22.1823|||DLL VERSION: 2.5.0.2780.
t Information: 1220 :  10|11:47:22.1823|||IS TIMER HIGH RESOULTION : True.
t Information: 1220 :  10|11:47:22.1823|||	UmsDev, default: False, value: False.
t Information: 1220 :  10|11:47:22.3855|||OrabitWatcherBasic trying to connect..
t Information: 1220 :  10|11:47:22.3855|||OrabitWatcherBasic connected.
t Information: 1220 :  10|11:47:22.5886|||OrabitWatcherBasic queue created tmd.cfg.in.62cf077c-fda8-4dd2-b314-c0d6e56fc256
t Transfer: 1220 :     10|11:47:24.8386|WG52e_|DANIEL|OAuth: /api/v3/search-suggestion/?_dc=1593600438397
t Transfer: 1220 :     10|11:47:24.8386|eVWHee|DANIEL|OAuth: /api/view/searches/TitleSearch?_dc=1593600434813
t Transfer: 1220 :     10|11:47:24.8386|VtG3K5|DANIEL|OAuth: /api/v3/search-suggestion/?_dc=1593600438764
t Transfer: 1220 :     10|11:47:24.8386|Q9e5Cl|DANIEL|OAuth: /api/view/info/VersionGrid?lang=en-GB&_dc=1593600434879
t Transfer: 1220 :     10|11:47:24.8386|wlvrLw|DANIEL|OAuth: /api/view/searchinfo/TitleSearch?_dc=1593600434635
t Transfer: 1220 :     10|11:47:24.8542|WG52e_|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:47:24.8542|WG52e_|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:47:24.8542|WG52e_|DANIEL|    user DANIEL.
t Transfer: 1220 :     10|11:47:24.8542|Q9e5Cl|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:47:24.8542|Q9e5Cl|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:47:24.8542|Q9e5Cl|DANIEL|    user DANIEL.
t Verbose: 1220 :      10|11:47:24.8542|WG52e_|DANIEL|OAuth. User logged in: DANIEL
t Verbose: 1220 :      10|11:47:24.8542|Q9e5Cl|DANIEL|OAuth. User logged in: DANIEL
t Transfer: 1220 :     10|11:47:24.8542|wlvrLw|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:47:24.8542|wlvrLw|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:47:24.8542|eVWHee|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:47:24.8542|eVWHee|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:47:24.8542|eVWHee|DANIEL|    user DANIEL.
t Verbose: 1220 :      10|11:47:24.8542|eVWHee|DANIEL|OAuth. User logged in: DANIEL
t Transfer: 1220 :     10|11:47:24.8542|wlvrLw|DANIEL|    user DANIEL.
t Verbose: 1220 :      10|11:47:24.8542|wlvrLw|DANIEL|OAuth. User logged in: DANIEL
t Transfer: 1220 :     10|11:47:24.8542|VtG3K5|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:47:24.8542|VtG3K5|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:47:24.8542|VtG3K5|DANIEL|    user DANIEL.
t Verbose: 1220 :      10|11:47:24.8542|VtG3K5|DANIEL|OAuth. User logged in: DANIEL
t Information: 1220 :  10|11:47:24.8542|wlvrLw|DANIEL|GetAdvSearchColumns. search type TitleSearch grid .
t Information: 1220 :  10|11:47:24.8542|Q9e5Cl|DANIEL|GetGridViewBuilder. builder type VersionGrid.
t Information: 1220 :  10|11:47:24.8542|eVWHee|DANIEL|GetSavedSearchNames. search type TitleSearch.
t Transfer: 1220 :     10|11:47:24.8542|eVWHee|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:47:24.8542|eVWHee|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:47:24.8542|eVWHee|DANIEL|    user DANIEL.
t Transfer: 1220 :     10|11:47:24.8542|Q9e5Cl|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:47:24.8542|Q9e5Cl|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:47:24.8542|Q9e5Cl|DANIEL|    user DANIEL.
t Verbose: 1220 :      10|11:47:25.0730|wlvrLw|DANIEL|imfx v3 API took 0.082s '/api/view/searchinfo/TitleSearch?_dc=1593600434635'
t Information: 1220 :  10|11:47:25.0730|Q9e5Cl|DANIEL|UserGridView. LoadView. ID 899, Name Default.
t Transfer: 1220 :     10|11:47:25.0730|Q9e5Cl|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:47:25.0730|Q9e5Cl|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:47:25.0730|Q9e5Cl|DANIEL|    user DANIEL.
t Transfer: 1220 :     10|11:47:25.0730|Q9e5Cl|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:47:25.0730|Q9e5Cl|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:47:25.0730|Q9e5Cl|DANIEL|    user DANIEL.
t Verbose: 1220 :      10|11:47:25.0730|Q9e5Cl|DANIEL|imfx v3 API took 0.133s '/api/view/info/VersionGrid?lang=en-GB&_dc=1593600434879'
t Verbose: 1220 :      10|11:47:25.0730|eVWHee|DANIEL|imfx v3 API took 0.165s '/api/view/searches/TitleSearch?_dc=1593600434813'
t Transfer: 1220 :     10|11:47:25.0730|PmQSI~|DANIEL|OAuth: /api/v3/search-suggestion/?_dc=1593600438931
t Transfer: 1220 :     10|11:47:25.0730|PmQSI~|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:47:25.0730|PmQSI~|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:47:25.0730|PmQSI~|DANIEL|    user DANIEL.
t Verbose: 1220 :      10|11:47:25.0730|PmQSI~|DANIEL|OAuth. User logged in: DANIEL
t Transfer: 1220 :     10|11:47:25.2761|x33fuW|DANIEL|OAuth: /api/view/info/MediaGrid?lang=en-GB&_dc=1593600435160
t Transfer: 1220 :     10|11:47:25.2761|x33fuW|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:47:25.2761|x33fuW|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:47:25.2761|x33fuW|DANIEL|    user DANIEL.
t Verbose: 1220 :      10|11:47:25.2761|x33fuW|DANIEL|OAuth. User logged in: DANIEL
t Information: 1220 :  10|11:47:25.2761|x33fuW|DANIEL|GetGridViewBuilder. builder type MediaGrid.
t Transfer: 1220 :     10|11:47:25.2761|x33fuW|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:47:25.2761|x33fuW|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:47:25.2761|x33fuW|DANIEL|    user DANIEL.
t Transfer: 1220 :     10|11:47:25.2761|ww1DxG|DANIEL|OAuth: /api/view/info/TitleTree?lang=en-GB&_dc=1593600435218
t Transfer: 1220 :     10|11:47:25.2761|ww1DxG|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:47:25.2761|ww1DxG|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:47:25.2761|ww1DxG|DANIEL|    user DANIEL.
t Verbose: 1220 :      10|11:47:25.2761|ww1DxG|DANIEL|OAuth. User logged in: DANIEL
t Information: 1220 :  10|11:47:25.2761|ww1DxG|DANIEL|GetGridViewBuilder. builder type TitleTree.
t Transfer: 1220 :     10|11:47:25.2761|ww1DxG|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:47:25.2761|ww1DxG|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:47:25.2761|ww1DxG|DANIEL|    user DANIEL.
t Transfer: 1220 :     10|11:47:25.2761|PmQSI~|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:47:25.2761|PmQSI~|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:47:25.2761|PmQSI~|DANIEL|    user DANIEL.
t Information: 1220 :  10|11:47:25.2761|x33fuW|DANIEL|UserGridView. LoadView. ID 760, Name Default.
t Transfer: 1220 :     10|11:47:25.2761|x33fuW|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:47:25.2761|x33fuW|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:47:25.2761|x33fuW|DANIEL|    user DANIEL.
t Transfer: 1220 :     10|11:47:25.2761|WG52e_|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:47:25.2761|WG52e_|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:47:25.2761|WG52e_|DANIEL|    user DANIEL.
t Transfer: 1220 :     10|11:47:25.2761|VtG3K5|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:47:25.2761|VtG3K5|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:47:25.2761|VtG3K5|DANIEL|    user DANIEL.
t Information: 1220 :  10|11:47:25.2761|ww1DxG|DANIEL|UserGridView. LoadView. ID 856, Name Default.
t Transfer: 1220 :     10|11:47:25.2761|ww1DxG|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:47:25.2761|ww1DxG|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:47:25.2761|ww1DxG|DANIEL|    user DANIEL.
t Transfer: 1220 :     10|11:47:25.2761|x33fuW|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:47:25.2761|x33fuW|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:47:25.2761|x33fuW|DANIEL|    user DANIEL.
t Verbose: 1220 :      10|11:47:25.2761|x33fuW|DANIEL|imfx v3 API took 0.011s '/api/view/info/MediaGrid?lang=en-GB&_dc=1593600435160'
t Transfer: 1220 :     10|11:47:25.2761|LF9Itz|DANIEL|OAuth: /api/user-preferences?keys=adv.recent.searches.titles&_dc=1593600434640
t Transfer: 1220 :     10|11:47:25.2761|LF9Itz|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:47:25.2761|LF9Itz|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:47:25.2761|LF9Itz|DANIEL|    user DANIEL.
t Verbose: 1220 :      10|11:47:25.2761|LF9Itz|DANIEL|OAuth. User logged in: DANIEL
t Information: 1220 :  10|11:47:25.2761|LF9Itz|DANIEL|GetUserDataByKeys: adv.recent.searches.titles
t Transfer: 1220 :     10|11:47:25.2761|LF9Itz|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:47:25.2761|LF9Itz|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:47:25.2761|LF9Itz|DANIEL|    user DANIEL.
t Transfer: 1220 :     10|11:47:25.2761|ww1DxG|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:47:25.2761|ww1DxG|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:47:25.2761|ww1DxG|DANIEL|    user DANIEL.
t Verbose: 1220 :      10|11:47:25.2761|LF9Itz|DANIEL|imfx v3 API took 0.019s '/api/user-preferences?keys=adv.recent.searches.titles&_dc=1593600434640'
t Verbose: 1220 :      10|11:47:25.2761|ww1DxG|DANIEL|imfx v3 API took 0.104s '/api/view/info/TitleTree?lang=en-GB&_dc=1593600435218'
t Transfer: 1220 :     10|11:47:25.2761|rqZ9Cq|DANIEL|OAuth: /api/v3/search-suggestion/?_dc=1593600439527
t Transfer: 1220 :     10|11:47:25.2761|rqZ9Cq|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:47:25.2761|rqZ9Cq|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:47:25.2761|rqZ9Cq|DANIEL|    user DANIEL.
t Verbose: 1220 :      10|11:47:25.2761|rqZ9Cq|DANIEL|OAuth. User logged in: DANIEL
t Transfer: 1220 :     10|11:47:25.2761|rqZ9Cq|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:47:25.2761|rqZ9Cq|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:47:25.2761|rqZ9Cq|DANIEL|    user DANIEL.
t Transfer: 1220 :     10|11:47:25.2761|QEcRet|DANIEL|OAuth: /api/v3/search-suggestion/?_dc=1593600439796
t Transfer: 1220 :     10|11:47:25.2761|QEcRet|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:47:25.2761|QEcRet|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:47:25.2761|QEcRet|DANIEL|    user DANIEL.
t Verbose: 1220 :      10|11:47:25.2761|QEcRet|DANIEL|OAuth. User logged in: DANIEL
t Transfer: 1220 :     10|11:47:25.2761|QEcRet|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:47:25.2761|QEcRet|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:47:25.2761|QEcRet|DANIEL|    user DANIEL.
t Transfer: 1220 :     10|11:47:25.2761|93aH7G|DANIEL|OAuth: /api/v3/search-suggestion/?_dc=1593600439977
t Transfer: 1220 :     10|11:47:25.2761|93aH7G|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:47:25.2761|93aH7G|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:47:25.2761|93aH7G|DANIEL|    user DANIEL.
t Verbose: 1220 :      10|11:47:25.2761|93aH7G|DANIEL|OAuth. User logged in: DANIEL
t Transfer: 1220 :     10|11:47:25.2761|93aH7G|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:47:25.2761|93aH7G|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:47:25.2761|93aH7G|DANIEL|    user DANIEL.
t Transfer: 1220 :     10|11:47:25.4948|1kF89H|DANIEL|OAuth: /api/v3/search-suggestion/?_dc=1593600440114
t Transfer: 1220 :     10|11:47:25.4948|kRZGxP|DANIEL|OAuth: /api/v3/search-suggestion/?_dc=1593600440523
t Transfer: 1220 :     10|11:47:25.4948|kRZGxP|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:47:25.4948|1kF89H|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:47:25.4948|kRZGxP|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:47:25.4948|1kF89H|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:47:25.4948|kRZGxP|DANIEL|    user DANIEL.
t Transfer: 1220 :     10|11:47:25.4948|1kF89H|DANIEL|    user DANIEL.
t Verbose: 1220 :      10|11:47:25.4948|1kF89H|DANIEL|OAuth. User logged in: DANIEL
t Verbose: 1220 :      10|11:47:25.4948|kRZGxP|DANIEL|OAuth. User logged in: DANIEL
t Transfer: 1220 :     10|11:47:25.4948|1kF89H|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:47:25.4948|kRZGxP|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:47:25.4948|1kF89H|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:47:25.4948|kRZGxP|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:47:25.4948|kRZGxP|DANIEL|    user DANIEL.
t Transfer: 1220 :     10|11:47:25.4948|1kF89H|DANIEL|    user DANIEL.
t Transfer: 1220 :     10|11:47:25.4948|V6tSaT|DANIEL|OAuth: /api/v3/search-suggestion/?_dc=1593600440315
t Transfer: 1220 :     10|11:47:25.4948|V6tSaT|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:47:25.4948|V6tSaT|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:47:25.4948|V6tSaT|DANIEL|    user DANIEL.
t Verbose: 1220 :      10|11:47:25.4948|V6tSaT|DANIEL|OAuth. User logged in: DANIEL
t Transfer: 1220 :     10|11:47:25.4948|V6tSaT|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:47:25.4948|V6tSaT|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:47:25.4948|V6tSaT|DANIEL|    user DANIEL.
t Verbose: 1220 :      10|11:47:26.3073|rqZ9Cq|DANIEL|imfx v3 API took 0.963s '/api/v3/search-suggestion/?_dc=1593600439527'
t Verbose: 1220 :      10|11:47:26.3073|1kF89H|DANIEL|imfx v3 API took 0.914s '/api/v3/search-suggestion/?_dc=1593600440114'
t Verbose: 1220 :      10|11:47:26.3073|PmQSI~|DANIEL|imfx v3 API took 1.156s '/api/v3/search-suggestion/?_dc=1593600438931'
t Transfer: 1220 :     10|11:47:26.3073|RnrDGf|DANIEL|OAuth: /api/v3/search-suggestion/?_dc=1593600441018
t Transfer: 1220 :     10|11:47:26.3073|RnrDGf|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:47:26.3073|RnrDGf|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:47:26.3073|RnrDGf|DANIEL|    user DANIEL.
t Verbose: 1220 :      10|11:47:26.3073|RnrDGf|DANIEL|OAuth. User logged in: DANIEL
t Transfer: 1220 :     10|11:47:26.3073|RnrDGf|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:47:26.3073|RnrDGf|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:47:26.3073|RnrDGf|DANIEL|    user DANIEL.
t Verbose: 1220 :      10|11:47:26.5105|QEcRet|DANIEL|imfx v3 API took 1.103s '/api/v3/search-suggestion/?_dc=1593600439796'
t Transfer: 1220 :     10|11:47:26.5105|uVH94u|DANIEL|OAuth: /api/v3/search-suggestion/?_dc=1593600441298
t Transfer: 1220 :     10|11:47:26.5105|f48tG9|DANIEL|OAuth: /api/v3/search-suggestion/?_dc=1593600441617
t Transfer: 1220 :     10|11:47:26.5105|f48tG9|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:47:26.5105|f48tG9|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:47:26.5105|f48tG9|DANIEL|    user DANIEL.
t Transfer: 1220 :     10|11:47:26.5105|uVH94u|DANIEL|GetCurrentUser..
t Verbose: 1220 :      10|11:47:26.5105|f48tG9|DANIEL|OAuth. User logged in: DANIEL
t Transfer: 1220 :     10|11:47:26.5105|uVH94u|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:47:26.5105|uVH94u|DANIEL|    user DANIEL.
t Verbose: 1220 :      10|11:47:26.5105|uVH94u|DANIEL|OAuth. User logged in: DANIEL
t Transfer: 1220 :     10|11:47:26.5105|f48tG9|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:47:26.5105|f48tG9|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:47:26.5105|f48tG9|DANIEL|    user DANIEL.
t Transfer: 1220 :     10|11:47:26.5105|uVH94u|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:47:26.5105|uVH94u|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:47:26.5105|uVH94u|DANIEL|    user DANIEL.
t Verbose: 1220 :      10|11:47:26.5105|V6tSaT|DANIEL|imfx v3 API took 0.918s '/api/v3/search-suggestion/?_dc=1593600440315'
t Verbose: 1220 :      10|11:47:26.5105|kRZGxP|DANIEL|imfx v3 API took 0.986s '/api/v3/search-suggestion/?_dc=1593600440523'
t Verbose: 1220 :      10|11:47:26.5105|WG52e_|DANIEL|imfx v3 API took 1.227s '/api/v3/search-suggestion/?_dc=1593600438397'
t Verbose: 1220 :      10|11:47:26.5105|93aH7G|DANIEL|imfx v3 API took 1.110s '/api/v3/search-suggestion/?_dc=1593600439977'
t Transfer: 1220 :     10|11:47:26.5105|jjgIQm|DANIEL|OAuth: /api/v3/search-suggestion/?_dc=1593600441802
t Transfer: 1220 :     10|11:47:26.5105|jjgIQm|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:47:26.5105|jjgIQm|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:47:26.5105|jjgIQm|DANIEL|    user DANIEL.
t Verbose: 1220 :      10|11:47:26.5105|jjgIQm|DANIEL|OAuth. User logged in: DANIEL
t Transfer: 1220 :     10|11:47:26.5105|jjgIQm|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:47:26.5105|jjgIQm|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:47:26.5105|jjgIQm|DANIEL|    user DANIEL.
t Transfer: 1220 :     10|11:47:26.5105|IAIExY|DANIEL|OAuth: /api/v3/search-suggestion/?_dc=1593600442061
t Transfer: 1220 :     10|11:47:26.5105|IAIExY|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:47:26.5105|IAIExY|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:47:26.5105|IAIExY|DANIEL|    user DANIEL.
t Verbose: 1220 :      10|11:47:26.5105|IAIExY|DANIEL|OAuth. User logged in: DANIEL
t Transfer: 1220 :     10|11:47:26.5105|IAIExY|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:47:26.5105|IAIExY|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:47:26.5105|IAIExY|DANIEL|    user DANIEL.
t Transfer: 1220 :     10|11:47:26.5105|~hT8qK|DANIEL|OAuth: /api/v3/search/title?_dc=1593600442587
t Transfer: 1220 :     10|11:47:26.5105|~hT8qK|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:47:26.5105|~hT8qK|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:47:26.5105|~hT8qK|DANIEL|    user DANIEL.
t Verbose: 1220 :      10|11:47:26.5105|~hT8qK|DANIEL|OAuth. User logged in: DANIEL
t Transfer: 1220 :     10|11:47:26.5105|QpV_Fe|DANIEL|OAuth: /api/v3/search-suggestion/?_dc=1593600442328
t Transfer: 1220 :     10|11:47:26.5105|QpV_Fe|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:47:26.5105|QpV_Fe|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:47:26.5105|QpV_Fe|DANIEL|    user DANIEL.
t Verbose: 1220 :      10|11:47:26.5105|QpV_Fe|DANIEL|OAuth. User logged in: DANIEL
t Transfer: 1220 :     10|11:47:26.5105|QpV_Fe|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:47:26.5105|QpV_Fe|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:47:26.5105|QpV_Fe|DANIEL|    user DANIEL.
t Verbose: 1220 :      10|11:47:26.5105|VtG3K5|DANIEL|imfx v3 API took 1.300s '/api/v3/search-suggestion/?_dc=1593600438764'
t Information: 1220 :  10|11:47:26.5105|~hT8qK|DANIEL|V3Api.SearchTitles
t Information: 1220 :  10|11:47:26.5105|~hT8qK|DANIEL|V3Api.SearchGeneric
t Verbose: 1220 :      10|11:47:26.5105|IAIExY|DANIEL|imfx v3 API took 0.060s '/api/v3/search-suggestion/?_dc=1593600442061'
t Verbose: 1220 :      10|11:47:26.5105|RnrDGf|DANIEL|imfx v3 API took 0.173s '/api/v3/search-suggestion/?_dc=1593600441018'
t Transfer: 1220 :     10|11:47:26.5105|~hT8qK|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:47:26.5105|~hT8qK|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:47:26.5105|~hT8qK|DANIEL|    user DANIEL.
t Transfer: 1220 :     10|11:47:26.5105|~hT8qK|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:47:26.5105|~hT8qK|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:47:26.5105|~hT8qK|DANIEL|    user DANIEL.
t Verbose: 1220 :      10|11:47:26.5105|f48tG9|DANIEL|imfx v3 API took 0.139s '/api/v3/search-suggestion/?_dc=1593600441617'
t Verbose: 1220 :      10|11:47:26.5105|QpV_Fe|DANIEL|imfx v3 API took 0.064s '/api/v3/search-suggestion/?_dc=1593600442328'
t Verbose: 1220 :      10|11:47:26.5105|jjgIQm|DANIEL|imfx v3 API took 0.115s '/api/v3/search-suggestion/?_dc=1593600441802'
t Verbose: 1220 :      10|11:47:26.5105|uVH94u|DANIEL|imfx v3 API took 0.144s '/api/v3/search-suggestion/?_dc=1593600441298'
t Information: 1220 :  10|11:47:26.5105|~hT8qK|DANIEL|SearchTitle SQL:
with 
 v as (
    SELECT 
        abs.*
       ,decode(ITEM_TYPE,
                 1010,SER_ABS_ID,
                 1020,CASE WHEN SER_ABS2_ID > 0 THEN SER_ABS2_ID ELSE SER_ABS_ID END
              ) xparent_id
      FROM TMDDBA.TM_PG_ABS abs
     WHERE abs.id in (
          select a.id
          FROM TMDDBA.TM_PG_ABS a
          where ABS_DELETED = 0  AND (CONTAINS(CTX_TEXT_COL,'game of thrones') > 0 OR CONTAINS(CTX_IDS_COL,'game of thrones') > 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 "TreeLevel", a.*
   from v_all a
   start with id in (select id from v_top)
   connect by xparent_id = prior ID
   order siblings by upper(ser_title),ser_num,ser_ep_num, SER_EP_SQ_NUM,upper(title) -- sort children
 )
select *
from v_tree 
--where rnk <= 50
t Transfer: 1220 :     10|11:47:26.5105|~aNfas|DANIEL|OAuth: /api/settings/user/uploadSettings?_dc=1593600445223
t Transfer: 1220 :     10|11:47:26.5105|~aNfas|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:47:26.5105|~aNfas|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:47:26.5105|~aNfas|DANIEL|    user DANIEL.
t Verbose: 1220 :      10|11:47:26.5105|~aNfas|DANIEL|OAuth. User logged in: DANIEL
t Transfer: 1220 :     10|11:47:26.5105|Gcqjjs|DANIEL|OAuth: /api/settings/user/uploadSettings?_dc=1593600445571
t Transfer: 1220 :     10|11:47:26.5105|Gcqjjs|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:47:26.5105|Gcqjjs|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:47:26.5105|Gcqjjs|DANIEL|    user DANIEL.
t Verbose: 1220 :      10|11:47:26.5105|Gcqjjs|DANIEL|OAuth. User logged in: DANIEL
t Transfer: 1220 :     10|11:47:26.5105|~aNfas|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:47:26.5105|~aNfas|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:47:26.5105|~aNfas|DANIEL|    user DANIEL.
t Transfer: 1220 :     10|11:47:26.5105|Gcqjjs|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:47:26.5105|Gcqjjs|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:47:26.5105|Gcqjjs|DANIEL|    user DANIEL.
t Verbose: 1220 :      10|11:47:26.7292|~aNfas|DANIEL|imfx v3 API took 0.018s '/api/settings/user/uploadSettings?_dc=1593600445223'
t Verbose: 1220 :      10|11:47:26.7292|Gcqjjs|DANIEL|imfx v3 API took 0.017s '/api/settings/user/uploadSettings?_dc=1593600445571'
t Verbose: 1220 :      10|11:47:26.9323|~hT8qK|DANIEL|imfx v3 API took 0.418s '/api/v3/search/title?_dc=1593600442587'
t Transfer: 1220 :     10|11:47:27.3386|m9N5w5|DANIEL|OAuth: /api/v3/title/278625/versions?_dc=1593600447138
t Transfer: 1220 :     10|11:47:27.3386|m9N5w5|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:47:27.3386|m9N5w5|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:47:27.3386|m9N5w5|DANIEL|    user DANIEL.
t Verbose: 1220 :      10|11:47:27.3386|m9N5w5|DANIEL|OAuth. User logged in: DANIEL
t Information: 1220 :  10|11:47:27.3386|m9N5w5|DANIEL|V3Api.SearchGeneric
t Transfer: 1220 :     10|11:47:27.3386|OgZj9N|DANIEL|OAuth: /api/user-preferences?_dc=1593600447150
t Transfer: 1220 :     10|11:47:27.3386|OgZj9N|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:47:27.3386|OgZj9N|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:47:27.3386|OgZj9N|DANIEL|    user DANIEL.
t Verbose: 1220 :      10|11:47:27.3386|OgZj9N|DANIEL|OAuth. User logged in: DANIEL
t Transfer: 1220 :     10|11:47:27.3386|m9N5w5|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:47:27.3386|m9N5w5|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:47:27.3386|m9N5w5|DANIEL|    user DANIEL.
t Verbose: 1220 :      10|11:47:27.3386|OgZj9N|DANIEL|StoreUserDataByKeys..
t Transfer: 1220 :     10|11:47:27.3386|OgZj9N|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:47:27.3386|OgZj9N|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:47:27.3386|OgZj9N|DANIEL|    user DANIEL.
t Transfer: 1220 :     10|11:47:27.3386|m9N5w5|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:47:27.3386|m9N5w5|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:47:27.3386|m9N5w5|DANIEL|    user DANIEL.
t Information: 1220 :  10|11:47:27.3386|m9N5w5|DANIEL|SearchVersion SQL:
 select * from (select a.*, rownum rnum  from ( select  m.*, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE,  nvl(t.text_id,-1) THUMBID, BUILD_PGRL_FULLTITLE(item_type, title, ser_name, ser_title) FULLTITLE     from tmddba.tm_pg_rl m 
        left outer join (select text_id, text_data_path, text_data_filename, text_ref_object from tmddba.tm_text) t on t.text_id = m.primary_thumb_id
 where item_type>0 and rl_deleted=0  and m.PGM_ABS_ID=278625 
 order by m.title,m.id) a where rownum <= 9999) r where rnum >=1 order by rnum
t Verbose: 1220 :      10|11:47:27.3386|OgZj9N|DANIEL|imfx v3 API took 0.015s '/api/user-preferences?_dc=1593600447150'
t Information: 1220 :  10|11:47:27.3386|m9N5w5|DANIEL|Running version search. User: 342    Simple Search: 
Running Oracle search.
Running Oracle search for COUNT
Oracle count completed in: 26ms.  Returned lines: 0

t Verbose: 1220 :      10|11:47:27.3386|m9N5w5|DANIEL|imfx v3 API took 0.052s '/api/v3/title/278625/versions?_dc=1593600447138'
t Transfer: 1220 :     10|11:47:28.5573|RXEpUS|DANIEL|OAuth: /api/v3/title/293744/versions?_dc=1593600448433
t Transfer: 1220 :     10|11:47:28.5573|RXEpUS|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:47:28.5573|RXEpUS|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:47:28.5573|RXEpUS|DANIEL|    user DANIEL.
t Verbose: 1220 :      10|11:47:28.5573|RXEpUS|DANIEL|OAuth. User logged in: DANIEL
t Information: 1220 :  10|11:47:28.5573|RXEpUS|DANIEL|V3Api.SearchGeneric
t Transfer: 1220 :     10|11:47:28.5573|RXEpUS|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:47:28.5573|RXEpUS|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:47:28.5573|RXEpUS|DANIEL|    user DANIEL.
t Transfer: 1220 :     10|11:47:28.5573|RXEpUS|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:47:28.5573|RXEpUS|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:47:28.5573|RXEpUS|DANIEL|    user DANIEL.
t Information: 1220 :  10|11:47:28.5573|RXEpUS|DANIEL|SearchVersion SQL:
 select * from (select a.*, rownum rnum  from ( select  m.*, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE,  nvl(t.text_id,-1) THUMBID, BUILD_PGRL_FULLTITLE(item_type, title, ser_name, ser_title) FULLTITLE     from tmddba.tm_pg_rl m 
        left outer join (select text_id, text_data_path, text_data_filename, text_ref_object from tmddba.tm_text) t on t.text_id = m.primary_thumb_id
 where item_type>0 and rl_deleted=0  and m.PGM_ABS_ID=293744 
 order by m.title,m.id) a where rownum <= 9999) r where rnum >=1 order by rnum
t Information: 1220 :  10|11:47:28.7604|RXEpUS|DANIEL|Running version search. User: 342    Simple Search: 
Running Oracle search.
Running Oracle search for COUNT
Oracle count completed in: 7ms.  Returned lines: 1
Oracle version search timing: 92ms.
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=293744 
 order by m.title,m.id) a where rownum <= 9999) r where rnum >=1 order by rnum

t Verbose: 1220 :      10|11:47:28.7604|RXEpUS|DANIEL|imfx v3 API took 0.106s '/api/v3/title/293744/versions?_dc=1593600448433'
t Transfer: 1220 :     10|11:47:28.9635|f9U2Jp|DANIEL|OAuth: /api/v3/version/293745/media?_dc=1593600448693
t Transfer: 1220 :     10|11:47:28.9635|f9U2Jp|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:47:28.9635|f9U2Jp|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:47:28.9635|f9U2Jp|DANIEL|    user DANIEL.
t Verbose: 1220 :      10|11:47:28.9635|f9U2Jp|DANIEL|OAuth. User logged in: DANIEL
t Information: 1220 :  10|11:47:28.9635|f9U2Jp|DANIEL|V3Api.SearchGeneric
t Transfer: 1220 :     10|11:47:28.9635|f9U2Jp|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:47:28.9635|f9U2Jp|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:47:28.9635|f9U2Jp|DANIEL|    user DANIEL.
t Information: 1220 :  10|11:47:28.9635|f9U2Jp|DANIEL|MediaSearch SQL:
select r.*,
    nvl((select TMD_STR_AGG(c.u_id_pfix ) from tm_ctnrs c, tm_mi_tpi_lnx l where l.miid=r.id and c.u_id=l.tpiid and r.media_type=1),'') BARCODE,
    nvl(lnk.lib_loc_ext_id,0) lib_loc_ext_id, nvl(lnk.ctnr_loan_stat,0) ctnr_loan_status, nvl(lnk.ctnr_stat,0) ctnr_stat,
    nvl(t.text_data_path,'') THUMBSERVER, 
    nvl(t.text_data_filename,'') THUMBFILE,
    nvl(t.text_id,-1) THUMBID , 
    GETMEDIALOC(r.id, r.media_type, r.compil, r.m_ctnr_int_o_loc, r.m_ctnr_ext_o_loc, r.m_ctnr_loc) LOCATION,
    nvl(dfl.fSOM,0) FILE_SOM, nvl(dfl.fEOM,0) FILE_EOM, dfl.fos_fname FILENAME, dfl.DFILE_LINK_GUID, dfl.OS_GUID, dfl.SUB_FOLDER, dfl.ORIGINAL_FILENAME 

    from (select a.*, rownum rnum from 
      (select  m.*,
     coalesce(m.primary_thumb_id, (select v.primary_thumb_id from tm_pg_rl v where v.id=m.pgm_parent_id)) primary_thumb_id2 
      from tmddba.tm_mis m 
 where media_type>0 and item_type>0  AND  PGM_PARENT_ID=:pgm_parent_id_1  and m.mi_deleted=0  
 order by upper(m.title), m.media_type, m.ec_som, m.id ) a where rownum <= 50) r 
    ,lateral( select l.miid, max(c.C_EXT_OUT_LOC) lib_loc_ext_id, max(c.C_STAT) ctnr_stat, max(c.loan_stat) ctnr_loan_stat  from tm_mi_tpi_lnx l, tm_ctnrs c where c.u_id=l.tpiid and l.miid=r.id and r.media_type=1 group by l.miid)(+) lnk 
    ,lateral(select tt.* from tm_text tt where tt.text_id = r.primary_thumb_id2)(+) t
    ,lateral(select /*+ NO_DECORRELATE */  d.som fsom, d.eom feom, dl.mi_id fmi_id, d.os_fname fos_fname, d.DFILE_LINK_GUID, d.OS_GUID, d.SUB_FOLDER, dl.dfile_id, d.original_filename
        FROM tm_dfile d, tm_mi_dfile_lnx dl where d.id=dl.dfile_id and r.id=dl.mi_id and rownum=1)(+) dfl 
    
    where rnum >= 1 order by rnum
Param: pgm_parent_id_1: 293745
t Information: 1220 :  10|11:47:29.1667|f9U2Jp|DANIEL|    timing: 00:00:00.2134074
t Verbose: 1220 :      10|11:47:29.1667|f9U2Jp|DANIEL|imfx v3 API took 0.243s '/api/v3/version/293745/media?_dc=1593600448693'
t Transfer: 1220 :     10|11:47:29.3698|f9U2Jp|DANIEL|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\gotspecialspromo10secaction.mp4 subfolder 
t Transfer: 1220 :     10|11:47:29.3698|f9U2Jp|DANIEL|  GetFileName result https://imfxv3tm.tmd.tv/VideoServer/gotspecialspromo10secaction.mp4
t Transfer: 1220 :     10|11:47:29.3698|f9U2Jp|DANIEL|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/gotspecialspromo10secaction.mp4
t Transfer: 1220 :     10|11:47:29.3698|f9U2Jp|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:47:29.3698|f9U2Jp|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:47:29.3698|f9U2Jp|DANIEL|    user DANIEL.
t Transfer: 1220 :     10|11:47:29.3698|f9U2Jp|DANIEL|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\gotspecialspromo20seccharacter.mp4 subfolder 
t Transfer: 1220 :     10|11:47:29.3698|f9U2Jp|DANIEL|  GetFileName result https://imfxv3tm.tmd.tv/VideoServer/gotspecialspromo20seccharacter.mp4
t Transfer: 1220 :     10|11:47:29.3698|f9U2Jp|DANIEL|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/gotspecialspromo20seccharacter.mp4
t Transfer: 1220 :     10|11:47:29.3698|f9U2Jp|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:47:29.3698|f9U2Jp|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:47:29.3698|f9U2Jp|DANIEL|    user DANIEL.
t Transfer: 1220 :     10|11:47:29.3698|f9U2Jp|DANIEL|GetUrl. Storage |Image| filename \\192.168.120.254\DemoFS\Digital Assets\Image\gotspecialspromosimage.jpg subfolder 
t Transfer: 1220 :     10|11:47:29.3698|f9U2Jp|DANIEL|  GetFileName result https://imfxv3tm.tmd.tv/ImageServer/gotspecialspromosimage.jpg
t Transfer: 1220 :     10|11:47:29.3698|f9U2Jp|DANIEL|GetUrl. result https://imfxv3tm.tmd.tv/ImageServer/gotspecialspromosimage.jpg
t Transfer: 1220 :     10|11:47:29.3698|f9U2Jp|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:47:29.3698|f9U2Jp|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:47:29.3698|f9U2Jp|DANIEL|    user DANIEL.
t Transfer: 1220 :     10|11:47:29.3698|f9U2Jp|DANIEL|GetUrl. Storage |TEMP_UPLOAD| filename \\192.168.120.254\DemoFS\Digital Assets\TEMP_UPLOAD\68add84afa7b\Animation Sample1.mp4 subfolder 68add84afa7b\
t Transfer: 1220 :     10|11:47:29.3698|f9U2Jp|DANIEL|  GetFileName result https://demo.tmd.tv/Temp Upload/Animation%20Sample1.mp4
t Transfer: 1220 :     10|11:47:29.3698|f9U2Jp|DANIEL|GetUrl. result https://demo.tmd.tv/Temp Upload/Animation%20Sample1.mp4
t Transfer: 1220 :     10|11:47:29.3698|f9U2Jp|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:47:29.3698|f9U2Jp|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:47:29.3698|f9U2Jp|DANIEL|    user DANIEL.
t Transfer: 1220 :     10|11:47:29.3698|f9U2Jp|DANIEL|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Example 06052020.mp4 subfolder 
t Transfer: 1220 :     10|11:47:29.3698|f9U2Jp|DANIEL|  GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Example%2006052020.mp4
t Transfer: 1220 :     10|11:47:29.3698|f9U2Jp|DANIEL|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/Example%2006052020.mp4
t Transfer: 1220 :     10|11:47:29.3698|f9U2Jp|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:47:29.3698|f9U2Jp|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:47:29.3698|f9U2Jp|DANIEL|    user DANIEL.
t Transfer: 1220 :     10|11:47:29.3698|f9U2Jp|DANIEL|GetUrl. Storage |Audio| filename \\192.168.120.254\DemoFS\Digital Assets\Audio\PMH_portugese - Copy.wav subfolder 
t Transfer: 1220 :     10|11:47:29.3698|f9U2Jp|DANIEL|  GetFileName result https://imfxv3tm.tmd.tv/AudioServer/PMH_portugese%20-%20Copy.wav
t Transfer: 1220 :     10|11:47:29.3698|f9U2Jp|DANIEL|GetUrl. result https://imfxv3tm.tmd.tv/AudioServer/PMH_portugese%20-%20Copy.wav
t Transfer: 1220 :     10|11:47:29.3698|f9U2Jp|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:47:29.3698|f9U2Jp|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:47:29.3698|f9U2Jp|DANIEL|    user DANIEL.
t Transfer: 1220 :     10|11:47:29.3698|f9U2Jp|DANIEL|GetUrl. Storage |Audio| filename \\192.168.120.254\DemoFS\Digital Assets\Audio\gotspecialspromosaudio.wav subfolder 
t Transfer: 1220 :     10|11:47:29.3698|f9U2Jp|DANIEL|  GetFileName result https://imfxv3tm.tmd.tv/AudioServer/gotspecialspromosaudio.wav
t Transfer: 1220 :     10|11:47:29.3698|f9U2Jp|DANIEL|GetUrl. result https://imfxv3tm.tmd.tv/AudioServer/gotspecialspromosaudio.wav
t Transfer: 1220 :     10|11:47:29.3698|f9U2Jp|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:47:29.3698|f9U2Jp|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:47:29.3698|f9U2Jp|DANIEL|    user DANIEL.
t Transfer: 1220 :     10|11:47:57.4009|Pc_QyK|DANIEL|OAuth: /api/v3/search/workflow/version?_dc=1593600477228
t Transfer: 1220 :     10|11:47:57.4009|Pc_QyK|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:47:57.4009|Pc_QyK|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:47:57.4009|Pc_QyK|DANIEL|    user DANIEL.
t Verbose: 1220 :      10|11:47:57.4009|Pc_QyK|DANIEL|OAuth. User logged in: DANIEL
t Information: 1220 :  10|11:47:57.4009|Pc_QyK|DANIEL|V3Api.SearchWorkflowsWithVersion
t Transfer: 1220 :     10|11:47:57.4009|Pc_QyK|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:47:57.4009|Pc_QyK|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:47:57.4009|Pc_QyK|DANIEL|    user DANIEL.
t Transfer: 1220 :     10|11:47:57.6040|iHzaNg|DANIEL|OAuth: /api/view/info/Job?lang=en-GB&_dc=1593600477327
t Transfer: 1220 :     10|11:47:57.6040|iHzaNg|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:47:57.6040|iHzaNg|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:47:57.6040|iHzaNg|DANIEL|    user DANIEL.
t Verbose: 1220 :      10|11:47:57.6040|iHzaNg|DANIEL|OAuth. User logged in: DANIEL
t Information: 1220 :  10|11:47:57.6040|iHzaNg|DANIEL|GetGridViewBuilder. builder type Job.
t Transfer: 1220 :     10|11:47:57.6040|iHzaNg|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:47:57.6040|iHzaNg|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:47:57.6040|iHzaNg|DANIEL|    user DANIEL.
t Information: 1220 :  10|11:47:57.6040|iHzaNg|DANIEL|UserGridView. LoadView. ID 862, Name Default.
t Transfer: 1220 :     10|11:47:57.6040|iHzaNg|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:47:57.6040|iHzaNg|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:47:57.6040|iHzaNg|DANIEL|    user DANIEL.
t Transfer: 1220 :     10|11:47:57.6040|iHzaNg|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:47:57.6040|iHzaNg|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:47:57.6040|iHzaNg|DANIEL|    user DANIEL.
t Verbose: 1220 :      10|11:47:57.6040|iHzaNg|DANIEL|imfx v3 API took 0.008s '/api/view/info/Job?lang=en-GB&_dc=1593600477327'
t Verbose: 1220 :      10|11:47:57.6040|Pc_QyK|DANIEL|imfx v3 API took 0.123s '/api/v3/search/workflow/version?_dc=1593600477228'
t Transfer: 1220 :     10|11:48:11.2134|xKuPC_|DANIEL|OAuth: /api/v3/config/servicexml/types?_dc=1593600491059
t Transfer: 1220 :     10|11:48:11.2134|xKuPC_|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:48:11.2134|xKuPC_|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:48:11.2134|xKuPC_|DANIEL|    user DANIEL.
t Verbose: 1220 :      10|11:48:11.2134|xKuPC_|DANIEL|OAuth. User logged in: DANIEL
t Verbose: 1220 :      10|11:48:11.2134|xKuPC_|DANIEL|imfx v3 API took 0.004s '/api/v3/config/servicexml/types?_dc=1593600491059'
t Transfer: 1220 :     10|11:48:11.2134|5GS~E3|DANIEL|OAuth: /api/settings/groups/?_dc=1593600491138
t Transfer: 1220 :     10|11:48:11.2134|5GS~E3|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:48:11.2134|5GS~E3|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:48:11.2134|5GS~E3|DANIEL|    user DANIEL.
t Verbose: 1220 :      10|11:48:11.2134|5GS~E3|DANIEL|OAuth. User logged in: DANIEL
t Verbose: 1220 :      10|11:48:11.4165|5GS~E3|DANIEL|imfx v3 API took 0.014s '/api/settings/groups/?_dc=1593600491138'
t Transfer: 1220 :     10|11:48:18.9322|dS8P4_|DANIEL|OAuth: /api/v3/config-tables?_dc=1593600498714
t Transfer: 1220 :     10|11:48:18.9322|dS8P4_|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:48:18.9322|dS8P4_|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:48:18.9322|dS8P4_|DANIEL|    user DANIEL.
t Verbose: 1220 :      10|11:48:18.9322|dS8P4_|DANIEL|OAuth. User logged in: DANIEL
t Verbose: 1220 :      10|11:48:18.9322|dS8P4_|DANIEL|imfx v3 API took 0.009s '/api/v3/config-tables?_dc=1593600498714'
t Information: 1220 :  10|11:48:24.2134|OjrZhJ|DANIEL|GetConfig TM_VERSION_NAMES.
t Verbose: 1220 :      10|11:48:24.2134|OjrZhJ|DANIEL|imfx v3 API took 0.101s '/api/v3/config-table/TM_VERSION_NAMES?_dc=1593600503996'
t Transfer: 1220 :     10|11:48:39.4478|XyiF1s|DANIEL|OAuth: /api/v3/config-table/TM_VERSION_NAMES?_dc=1593600519293
t Transfer: 1220 :     10|11:48:39.4478|XyiF1s|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:48:39.4478|XyiF1s|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:48:39.4478|XyiF1s|DANIEL|    user DANIEL.
t Verbose: 1220 :      10|11:48:39.4478|XyiF1s|DANIEL|OAuth. User logged in: DANIEL
t Information: 1220 :  10|11:48:39.4478|XyiF1s|DANIEL|PostConfig TM_VERSION_NAMES
t Transfer: 1220 :     10|11:48:39.4478|XyiF1s|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:48:39.4478|XyiF1s|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:48:39.4478|XyiF1s|DANIEL|    user DANIEL.
t Verbose: 1220 :      10|11:48:39.8540|XyiF1s|DANIEL|imfx v3 API took 0.289s '/api/v3/config-table/TM_VERSION_NAMES?_dc=1593600519293'
t Information: 1220 :  10|11:48:39.8540|||OrabitWatcherBasic. message received: 12000440,CFG.TM_VERSION_NAMES,INS,AAASCTAANAAAW2OAAA
t Information: 1220 :  10|11:48:39.8540|||ProcessOrabitMessage. No dictionaries found.
t Information: 1220 :  10|11:48:39.8540|PrAYt9|DANIEL|GetConfig TM_VERSION_NAMES.
t Verbose: 1220 :      10|11:48:39.8540|PrAYt9|DANIEL|imfx v3 API took 0.006s '/api/v3/config-table/TM_VERSION_NAMES?_dc=1593600519641'
t Transfer: 1220 :     10|11:48:51.8384|ZHyvx2|DANIEL|OAuth: /api/v3/config-table/TM_VERSION_NAMES?_dc=1593600531731
t Transfer: 1220 :     10|11:48:51.8384|ZHyvx2|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:48:51.8384|ZHyvx2|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:48:51.8384|ZHyvx2|DANIEL|    user DANIEL.
t Verbose: 1220 :      10|11:48:51.8384|ZHyvx2|DANIEL|OAuth. User logged in: DANIEL
t Information: 1220 :  10|11:48:51.8384|ZHyvx2|DANIEL|PostConfig TM_VERSION_NAMES
t Transfer: 1220 :     10|11:48:51.8384|ZHyvx2|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:48:51.8384|ZHyvx2|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:48:51.8384|ZHyvx2|DANIEL|    user DANIEL.
t Verbose: 1220 :      10|11:48:51.8384|ZHyvx2|DANIEL|imfx v3 API took 0.013s '/api/v3/config-table/TM_VERSION_NAMES?_dc=1593600531731'
t Information: 1220 :  10|11:48:51.8384|||OrabitWatcherBasic. message received: 12000441,CFG.TM_VERSION_NAMES,INS,AAASCTAANAAAW2NAAA
t Information: 1220 :  10|11:48:51.8384|||ProcessOrabitMessage. No dictionaries found.
t Information: 1220 :  10|11:48:52.0415|NPPWmX|DANIEL|GetConfig TM_VERSION_NAMES.
t Verbose: 1220 :      10|11:48:52.0415|NPPWmX|DANIEL|imfx v3 API took 0.003s '/api/v3/config-table/TM_VERSION_NAMES?_dc=1593600531794'
t Transfer: 1220 :     10|11:49:13.9790|CJCQDd||GetAppInfo. DB: TMDDEMO. Install mode: . Auth types: Native, PublicApiKey
t Verbose: 1220 :      10|11:49:14.9947|qPdatE||imfx v3 API took 0.007s '/api/v3/visual-asset/group/M6I_N7/3/image'
t Verbose: 1220 :      10|11:49:20.8853|rrE_bO||Oauth validating..
t Verbose: 1220 :      10|11:49:20.8853|rrE_bO||GrantResourceOwnerCredentials.
t Verbose: 1220 :      10|11:49:20.8853|rrE_bO||LoginUser. daniel, login type OAuth, encrypt password True
t Information: 1220 :  10|11:49:20.8853|rrE_bO||TryLoginUser. daniel, login type OAuth, check password True, check hash False, encrypt password True, load user data False
t Information: 1220 :  10|11:49:21.0884|rrE_bO||  oauth token 00000000-0000-0000-0000-000000000000
t Information: 1220 :  10|11:49:21.0884|rrE_bO||TryLoginUser. Logged in..
t Information: 1220 :  10|11:49:21.0884|rrE_bO||GetPasswordPolicy. WARNING: Policy not found for system Imediaflex. Validation disabled.
t Verbose: 1220 :      10|11:49:21.0884|rrE_bO||LoginUser. Adding history. User Id 342, result DANIEL, host 192.168.127.6
t Verbose: 1220 :      10|11:49:21.0884|rrE_bO||GrantResourceOwnerCredentials. Try login finished. Logged: True
t Transfer: 1220 :     10|11:49:21.0884|u6Zzro|DANIEL|OAuth: /api/user-group-preferences?keys=defaultSearchColumnsMedia,defaultSearchColumnsVersion,defaultSearchColumnsSimple,defaultSearchMisrDetailsMediaColumns,versionCreationSettings,associate.advanced_search.version.setups,associate.advanced_search.media.setups,associate.wfrise.setups,supplier_portal.advanced_search.version.setups,supplier_portal.version_complete.setups,logoImage,uploadSettings,helpdeskUrl&globals=isDebugMode,htmlplayerhotkeys,versionCreationSettings,associate.advanced_search.version.setups,associate.advanced_search.media.setups,associate.wfrise.setups,supplier_portal.advanced_search.version.setups,helpdeskUrl&_dc=1593600560941
t Transfer: 1220 :     10|11:49:21.0884|u6Zzro|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:49:21.0884|u6Zzro|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:49:21.0884|u6Zzro|DANIEL|    user DANIEL.
t Verbose: 1220 :      10|11:49:21.0884|u6Zzro|DANIEL|OAuth. User logged in: DANIEL
t Transfer: 1220 :     10|11:49:21.0884|u6Zzro|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:49:21.0884|u6Zzro|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:49:21.0884|u6Zzro|DANIEL|    user DANIEL.
t Verbose: 1220 :      10|11:49:21.0884|u6Zzro|DANIEL|imfx v3 API took 0.026s '/api/user-group-preferences?keys=defaultSearchColumnsMedia,defaultSearchColumnsVersion,defaultSearchColumnsSimple,defaultSearchMisrDetailsMediaColumns,versionCreationSettings,associate.advanced_search.version.setups,associate.advanced_search.media.setups,associate.wfrise.setups,supplier_portal.advanced_search.version.setups,supplier_portal.version_complete.setups,logoImage,uploadSettings,helpdeskUrl&globals=isDebugMode,htmlplayerhotkeys,versionCreationSettings,associate.advanced_search.version.setups,associate.advanced_search.media.setups,associate.wfrise.setups,supplier_portal.advanced_search.version.setups,helpdeskUrl&_dc=1593600560941'
t Transfer: 1220 :     10|11:49:21.2915|bUnoBI|DANIEL|OAuth: /api/user-preferences?keys=personal_settings;basket;default_page;color_schema;media.basket.data;defaultSearch&_dc=1593600561020
t Transfer: 1220 :     10|11:49:21.2915|bUnoBI|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:49:21.2915|bUnoBI|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:49:21.2915|bUnoBI|DANIEL|    user DANIEL.
t Verbose: 1220 :      10|11:49:21.2915|bUnoBI|DANIEL|OAuth. User logged in: DANIEL
t Information: 1220 :  10|11:49:21.2915|bUnoBI|DANIEL|GetUserDataByKeys: personal_settings;basket;default_page;color_schema;media.basket.data;defaultSearch
t Transfer: 1220 :     10|11:49:21.2915|bUnoBI|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:49:21.2915|bUnoBI|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:49:21.2915|bUnoBI|DANIEL|    user DANIEL.
t Transfer: 1220 :     10|11:49:21.2915|v0CB2j|DANIEL|OAuth: /api/lookups/MediaStatus?_dc=1593600561022
t Transfer: 1220 :     10|11:49:21.2915|v0CB2j|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:49:21.2915|v0CB2j|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:49:21.2915|v0CB2j|DANIEL|    user DANIEL.
t Verbose: 1220 :      10|11:49:21.2915|v0CB2j|DANIEL|OAuth. User logged in: DANIEL
t Transfer: 1220 :     10|11:49:21.2915|gzeYiU|DANIEL|OAuth: /api/lookups/PgmStatus?_dc=1593600561025
t Transfer: 1220 :     10|11:49:21.2915|gzeYiU|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:49:21.2915|gzeYiU|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:49:21.2915|gzeYiU|DANIEL|    user DANIEL.
t Verbose: 1220 :      10|11:49:21.2915|gzeYiU|DANIEL|OAuth. User logged in: DANIEL
t Verbose: 1220 :      10|11:49:21.2915|bUnoBI|DANIEL|imfx v3 API took 0.017s '/api/user-preferences?keys=personal_settings;basket;default_page;color_schema;media.basket.data;defaultSearch&_dc=1593600561020'
t Verbose: 1220 :      10|11:49:21.2915|v0CB2j|DANIEL|imfx v3 API took 0.033s '/api/lookups/MediaStatus?_dc=1593600561022'
t Verbose: 1220 :      10|11:49:21.2915|gzeYiU|DANIEL|imfx v3 API took 0.033s '/api/lookups/PgmStatus?_dc=1593600561025'
t Information: 1220 :  10|11:49:21.2915|XyOk35|DANIEL|GetUserProfile. Id: 0
t Transfer: 1220 :     10|11:49:21.2915|XyOk35|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:49:21.2915|XyOk35|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:49:21.2915|XyOk35|DANIEL|    user DANIEL.
t Transfer: 1220 :     10|11:49:21.4947|onn0cg|DANIEL|OAuth: /api/settings/group/0?_dc=1593600561182
t Transfer: 1220 :     10|11:49:21.4947|onn0cg|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:49:21.4947|onn0cg|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:49:21.4947|onn0cg|DANIEL|    user DANIEL.
t Verbose: 1220 :      10|11:49:21.4947|onn0cg|DANIEL|OAuth. User logged in: DANIEL
t Transfer: 1220 :     10|11:49:21.4947|yETPoj|DANIEL|OAuth: /api/settings/user/uploadSettings?_dc=1593600561190
t Transfer: 1220 :     10|11:49:21.4947|yETPoj|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:49:21.4947|yETPoj|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:49:21.4947|yETPoj|DANIEL|    user DANIEL.
t Verbose: 1220 :      10|11:49:21.4947|yETPoj|DANIEL|OAuth. User logged in: DANIEL
t Transfer: 1220 :     10|11:49:21.4947|yETPoj|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:49:21.4947|yETPoj|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:49:21.4947|yETPoj|DANIEL|    user DANIEL.
t Verbose: 1220 :      10|11:49:21.4947|yETPoj|DANIEL|imfx v3 API took 0.004s '/api/settings/user/uploadSettings?_dc=1593600561190'
t Transfer: 1220 :     10|11:49:21.4947|r2DMgs|DANIEL|OAuth: /api/settings/user/defaultHomePage?_dc=1593600561344
t Transfer: 1220 :     10|11:49:21.4947|r2DMgs|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:49:21.4947|r2DMgs|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:49:21.4947|r2DMgs|DANIEL|    user DANIEL.
t Verbose: 1220 :      10|11:49:21.4947|r2DMgs|DANIEL|OAuth. User logged in: DANIEL
t Transfer: 1220 :     10|11:49:21.4947|r2DMgs|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:49:21.4947|r2DMgs|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:49:21.4947|r2DMgs|DANIEL|    user DANIEL.
t Verbose: 1220 :      10|11:49:21.4947|r2DMgs|DANIEL|imfx v3 API took 0.004s '/api/settings/user/defaultHomePage?_dc=1593600561344'
t Verbose: 1220 :      10|11:49:21.4947|2gpWuc||imfx v3 API took 0.005s '/api/v3/visual-asset/group/M6I_N7/0/image'
t Transfer: 1220 :     10|11:49:21.6978|kNO4Tt|DANIEL|OAuth: /api/settings/user/defaultSearch?_dc=1593600561428
t Transfer: 1220 :     10|11:49:21.6978|kNO4Tt|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:49:21.6978|kNO4Tt|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:49:21.6978|kNO4Tt|DANIEL|    user DANIEL.
t Verbose: 1220 :      10|11:49:21.6978|kNO4Tt|DANIEL|OAuth. User logged in: DANIEL
t Transfer: 1220 :     10|11:49:21.6978|kNO4Tt|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:49:21.6978|kNO4Tt|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:49:21.6978|kNO4Tt|DANIEL|    user DANIEL.
t Verbose: 1220 :      10|11:49:21.6978|kNO4Tt|DANIEL|imfx v3 API took 0.003s '/api/settings/user/defaultSearch?_dc=1593600561428'
t Transfer: 1220 :     10|11:49:21.6978|QsQh~O|DANIEL|OAuth: /api/settings/user/startSearch?_dc=1593600561430
t Transfer: 1220 :     10|11:49:21.6978|QsQh~O|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:49:21.6978|QsQh~O|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:49:21.6978|QsQh~O|DANIEL|    user DANIEL.
t Verbose: 1220 :      10|11:49:21.6978|QsQh~O|DANIEL|OAuth. User logged in: DANIEL
t Transfer: 1220 :     10|11:49:21.6978|QsQh~O|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:49:21.6978|QsQh~O|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:49:21.6978|QsQh~O|DANIEL|    user DANIEL.
t Verbose: 1220 :      10|11:49:21.6978|QsQh~O|DANIEL|imfx v3 API took 0.003s '/api/settings/user/startSearch?_dc=1593600561430'
t Verbose: 1220 :      10|11:49:21.6978|onn0cg|DANIEL|imfx v3 API took 0.224s '/api/settings/group/0?_dc=1593600561182'
t Transfer: 1220 :     10|11:49:21.6978|VuOWEp|DANIEL|OAuth: /api/user-preferences?keys=consumer.recent.data&_dc=1593600561464
t Transfer: 1220 :     10|11:49:21.6978|VuOWEp|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:49:21.6978|VuOWEp|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:49:21.6978|VuOWEp|DANIEL|    user DANIEL.
t Verbose: 1220 :      10|11:49:21.6978|VuOWEp|DANIEL|OAuth. User logged in: DANIEL
t Information: 1220 :  10|11:49:21.6978|VuOWEp|DANIEL|GetUserDataByKeys: consumer.recent.data
t Transfer: 1220 :     10|11:49:21.6978|VuOWEp|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:49:21.6978|VuOWEp|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:49:21.6978|VuOWEp|DANIEL|    user DANIEL.
t Transfer: 1220 :     10|11:49:21.6978|GHAvhf|DANIEL|OAuth: /api/user-preferences?keys=adv.recent.searches.consumer&_dc=1593600561493
t Transfer: 1220 :     10|11:49:21.6978|GHAvhf|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:49:21.6978|GHAvhf|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:49:21.6978|GHAvhf|DANIEL|    user DANIEL.
t Verbose: 1220 :      10|11:49:21.6978|GHAvhf|DANIEL|OAuth. User logged in: DANIEL
t Information: 1220 :  10|11:49:21.6978|GHAvhf|DANIEL|GetUserDataByKeys: adv.recent.searches.consumer
t Transfer: 1220 :     10|11:49:21.6978|GHAvhf|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:49:21.6978|GHAvhf|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:49:21.6978|GHAvhf|DANIEL|    user DANIEL.
t Verbose: 1220 :      10|11:49:21.6978|VuOWEp|DANIEL|imfx v3 API took 0.008s '/api/user-preferences?keys=consumer.recent.data&_dc=1593600561464'
t Verbose: 1220 :      10|11:49:21.6978|GHAvhf|DANIEL|imfx v3 API took 0.008s '/api/user-preferences?keys=adv.recent.searches.consumer&_dc=1593600561493'
t Transfer: 1220 :     10|11:50:12.2759|HAHXhO|DANIEL|OAuth: /api/view/searchinfo/TitleSearch?_dc=1593600612142
t Transfer: 1220 :     10|11:50:12.2759|HJuAGG|DANIEL|OAuth: /api/lookups/SearchSupportedOperators?_dc=1593600612144
t Transfer: 1220 :     10|11:50:12.2759|HJuAGG|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:50:12.2759|HAHXhO|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:50:12.2759|HAHXhO|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:50:12.2759|HJuAGG|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:50:12.2759|HJuAGG|DANIEL|    user DANIEL.
t Verbose: 1220 :      10|11:50:12.2759|HJuAGG|DANIEL|OAuth. User logged in: DANIEL
t Transfer: 1220 :     10|11:50:12.2759|HAHXhO|DANIEL|    user DANIEL.
t Verbose: 1220 :      10|11:50:12.2759|HAHXhO|DANIEL|OAuth. User logged in: DANIEL
t Information: 1220 :  10|11:50:12.2759|HAHXhO|DANIEL|GetAdvSearchColumns. search type TitleSearch grid .
t Verbose: 1220 :      10|11:50:12.2759|HAHXhO|DANIEL|imfx v3 API took 0.000s '/api/view/searchinfo/TitleSearch?_dc=1593600612142'
t Verbose: 1220 :      10|11:50:12.2759|HJuAGG|DANIEL|imfx v3 API took 0.000s '/api/lookups/SearchSupportedOperators?_dc=1593600612144'
t Transfer: 1220 :     10|11:50:12.2759|Itl_~x|DANIEL|OAuth: /api/user-preferences?keys=adv.recent.searches.titles&_dc=1593600612154
t Transfer: 1220 :     10|11:50:12.2759|Itl_~x|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:50:12.2759|Itl_~x|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:50:12.2759|Itl_~x|DANIEL|    user DANIEL.
t Verbose: 1220 :      10|11:50:12.2759|Itl_~x|DANIEL|OAuth. User logged in: DANIEL
t Information: 1220 :  10|11:50:12.2759|Itl_~x|DANIEL|GetUserDataByKeys: adv.recent.searches.titles
t Transfer: 1220 :     10|11:50:12.2759|Itl_~x|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:50:12.2759|Itl_~x|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:50:12.2759|Itl_~x|DANIEL|    user DANIEL.
t Verbose: 1220 :      10|11:50:12.2759|Itl_~x|DANIEL|imfx v3 API took 0.007s '/api/user-preferences?keys=adv.recent.searches.titles&_dc=1593600612154'
t Transfer: 1220 :     10|11:50:12.4790|K92qrm|DANIEL|OAuth: /api/view/searches/TitleSearch?_dc=1593600612241
t Transfer: 1220 :     10|11:50:12.4790|K92qrm|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:50:12.4790|K92qrm|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:50:12.4790|K92qrm|DANIEL|    user DANIEL.
t Verbose: 1220 :      10|11:50:12.4790|K92qrm|DANIEL|OAuth. User logged in: DANIEL
t Information: 1220 :  10|11:50:12.4790|K92qrm|DANIEL|GetSavedSearchNames. search type TitleSearch.
t Transfer: 1220 :     10|11:50:12.4790|K92qrm|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:50:12.4790|K92qrm|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:50:12.4790|K92qrm|DANIEL|    user DANIEL.
t Verbose: 1220 :      10|11:50:12.4790|K92qrm|DANIEL|imfx v3 API took 0.005s '/api/view/searches/TitleSearch?_dc=1593600612241'
t Transfer: 1220 :     10|11:50:12.4790|UXS~Fd|DANIEL|OAuth: /api/view/info/VersionGrid?lang=en-GB&_dc=1593600612301
t Transfer: 1220 :     10|11:50:12.4790|UXS~Fd|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:50:12.4790|UXS~Fd|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:50:12.4790|UXS~Fd|DANIEL|    user DANIEL.
t Verbose: 1220 :      10|11:50:12.4790|UXS~Fd|DANIEL|OAuth. User logged in: DANIEL
t Information: 1220 :  10|11:50:12.4790|UXS~Fd|DANIEL|GetGridViewBuilder. builder type VersionGrid.
t Transfer: 1220 :     10|11:50:12.4790|UXS~Fd|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:50:12.4790|UXS~Fd|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:50:12.4790|UXS~Fd|DANIEL|    user DANIEL.
t Information: 1220 :  10|11:50:12.4790|UXS~Fd|DANIEL|UserGridView. LoadView. ID 899, Name Default.
t Transfer: 1220 :     10|11:50:12.4790|UXS~Fd|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:50:12.4790|UXS~Fd|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:50:12.4790|UXS~Fd|DANIEL|    user DANIEL.
t Transfer: 1220 :     10|11:50:12.4790|UXS~Fd|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:50:12.4790|UXS~Fd|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:50:12.4790|UXS~Fd|DANIEL|    user DANIEL.
t Verbose: 1220 :      10|11:50:12.4790|UXS~Fd|DANIEL|imfx v3 API took 0.007s '/api/view/info/VersionGrid?lang=en-GB&_dc=1593600612301'
t Transfer: 1220 :     10|11:50:12.6821|SqfjoI|DANIEL|OAuth: /api/view/info/MediaGrid?lang=en-GB&_dc=1593600612438
t Transfer: 1220 :     10|11:50:12.6821|SqfjoI|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:50:12.6821|SqfjoI|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:50:12.6821|SqfjoI|DANIEL|    user DANIEL.
t Verbose: 1220 :      10|11:50:12.6821|SqfjoI|DANIEL|OAuth. User logged in: DANIEL
t Information: 1220 :  10|11:50:12.6821|SqfjoI|DANIEL|GetGridViewBuilder. builder type MediaGrid.
t Transfer: 1220 :     10|11:50:12.6821|SqfjoI|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:50:12.6821|SqfjoI|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:50:12.6821|SqfjoI|DANIEL|    user DANIEL.
t Information: 1220 :  10|11:50:12.6821|SqfjoI|DANIEL|UserGridView. LoadView. ID 760, Name Default.
t Transfer: 1220 :     10|11:50:12.6821|SqfjoI|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:50:12.6821|SqfjoI|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:50:12.6821|SqfjoI|DANIEL|    user DANIEL.
t Transfer: 1220 :     10|11:50:12.6821|SqfjoI|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:50:12.6821|SqfjoI|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:50:12.6821|SqfjoI|DANIEL|    user DANIEL.
t Verbose: 1220 :      10|11:50:12.6821|SqfjoI|DANIEL|imfx v3 API took 0.007s '/api/view/info/MediaGrid?lang=en-GB&_dc=1593600612438'
t Transfer: 1220 :     10|11:50:12.8853|buA1Qh|DANIEL|OAuth: /api/view/info/TitleTree?lang=en-GB&_dc=1593600612632
t Transfer: 1220 :     10|11:50:12.8853|buA1Qh|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:50:12.8853|buA1Qh|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:50:12.8853|buA1Qh|DANIEL|    user DANIEL.
t Verbose: 1220 :      10|11:50:12.8853|buA1Qh|DANIEL|OAuth. User logged in: DANIEL
t Information: 1220 :  10|11:50:12.8853|buA1Qh|DANIEL|GetGridViewBuilder. builder type TitleTree.
t Transfer: 1220 :     10|11:50:12.8853|buA1Qh|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:50:12.8853|buA1Qh|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:50:12.8853|buA1Qh|DANIEL|    user DANIEL.
t Information: 1220 :  10|11:50:12.8853|buA1Qh|DANIEL|UserGridView. LoadView. ID 856, Name Default.
t Transfer: 1220 :     10|11:50:12.8853|buA1Qh|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:50:12.8853|buA1Qh|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:50:12.8853|buA1Qh|DANIEL|    user DANIEL.
t Transfer: 1220 :     10|11:50:12.8853|buA1Qh|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:50:12.8853|buA1Qh|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:50:12.8853|buA1Qh|DANIEL|    user DANIEL.
t Verbose: 1220 :      10|11:50:12.8853|buA1Qh|DANIEL|imfx v3 API took 0.008s '/api/view/info/TitleTree?lang=en-GB&_dc=1593600612632'
t Transfer: 1220 :     10|11:50:13.0884|VKd8DL|DANIEL|OAuth: /api/settings/user/uploadSettings?_dc=1593600613005
t Transfer: 1220 :     10|11:50:13.0884|VKd8DL|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:50:13.0884|VKd8DL|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:50:13.0884|VKd8DL|DANIEL|    user DANIEL.
t Verbose: 1220 :      10|11:50:13.0884|VKd8DL|DANIEL|OAuth. User logged in: DANIEL
t Transfer: 1220 :     10|11:50:13.0884|VKd8DL|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:50:13.0884|VKd8DL|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:50:13.0884|VKd8DL|DANIEL|    user DANIEL.
t Verbose: 1220 :      10|11:50:13.0884|VKd8DL|DANIEL|imfx v3 API took 0.004s '/api/settings/user/uploadSettings?_dc=1593600613005'
t Transfer: 1220 :     10|11:50:13.4947|3gIEaY|DANIEL|OAuth: /api/settings/user/uploadSettings?_dc=1593600613280
t Transfer: 1220 :     10|11:50:13.4947|3gIEaY|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:50:13.4947|3gIEaY|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:50:13.4947|3gIEaY|DANIEL|    user DANIEL.
t Verbose: 1220 :      10|11:50:13.4947|3gIEaY|DANIEL|OAuth. User logged in: DANIEL
t Transfer: 1220 :     10|11:50:13.4947|3gIEaY|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:50:13.4947|3gIEaY|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:50:13.4947|3gIEaY|DANIEL|    user DANIEL.
t Verbose: 1220 :      10|11:50:13.4947|3gIEaY|DANIEL|imfx v3 API took 0.004s '/api/settings/user/uploadSettings?_dc=1593600613280'
t Transfer: 1220 :     10|11:50:17.5571|dSKW2A|DANIEL|OAuth: /api/v3/search-suggestion/?_dc=1593600617366
t Transfer: 1220 :     10|11:50:17.5571|dSKW2A|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:50:17.5571|dSKW2A|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:50:17.5571|dSKW2A|DANIEL|    user DANIEL.
t Verbose: 1220 :      10|11:50:17.5571|dSKW2A|DANIEL|OAuth. User logged in: DANIEL
t Transfer: 1220 :     10|11:50:17.5571|dSKW2A|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:50:17.5571|dSKW2A|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:50:17.5571|dSKW2A|DANIEL|    user DANIEL.
t Verbose: 1220 :      10|11:50:17.5571|dSKW2A|DANIEL|imfx v3 API took 0.012s '/api/v3/search-suggestion/?_dc=1593600617366'
t Transfer: 1220 :     10|11:50:17.5571|a_4Uz5|DANIEL|OAuth: /api/v3/search-suggestion/?_dc=1593600617472
t Transfer: 1220 :     10|11:50:17.5571|a_4Uz5|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:50:17.5571|a_4Uz5|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:50:17.5571|a_4Uz5|DANIEL|    user DANIEL.
t Verbose: 1220 :      10|11:50:17.5571|a_4Uz5|DANIEL|OAuth. User logged in: DANIEL
t Transfer: 1220 :     10|11:50:17.5571|a_4Uz5|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:50:17.5571|a_4Uz5|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:50:17.5571|a_4Uz5|DANIEL|    user DANIEL.
t Verbose: 1220 :      10|11:50:17.5571|a_4Uz5|DANIEL|imfx v3 API took 0.008s '/api/v3/search-suggestion/?_dc=1593600617472'
t Transfer: 1220 :     10|11:50:17.7603|mIjMLY|DANIEL|OAuth: /api/v3/search-suggestion/?_dc=1593600617572
t Transfer: 1220 :     10|11:50:17.7603|mIjMLY|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:50:17.7603|mIjMLY|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:50:17.7603|mIjMLY|DANIEL|    user DANIEL.
t Verbose: 1220 :      10|11:50:17.7603|mIjMLY|DANIEL|OAuth. User logged in: DANIEL
t Transfer: 1220 :     10|11:50:17.7603|mIjMLY|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:50:17.7603|mIjMLY|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:50:17.7603|mIjMLY|DANIEL|    user DANIEL.
t Verbose: 1220 :      10|11:50:17.7603|mIjMLY|DANIEL|imfx v3 API took 0.007s '/api/v3/search-suggestion/?_dc=1593600617572'
t Transfer: 1220 :     10|11:50:17.9634|8MK7w_|DANIEL|OAuth: /api/v3/search-suggestion/?_dc=1593600617693
t Transfer: 1220 :     10|11:50:17.9634|8MK7w_|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:50:17.9634|8MK7w_|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:50:17.9634|8MK7w_|DANIEL|    user DANIEL.
t Verbose: 1220 :      10|11:50:17.9634|8MK7w_|DANIEL|OAuth. User logged in: DANIEL
t Transfer: 1220 :     10|11:50:17.9634|8MK7w_|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:50:17.9634|8MK7w_|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:50:17.9634|8MK7w_|DANIEL|    user DANIEL.
t Verbose: 1220 :      10|11:50:17.9634|8MK7w_|DANIEL|imfx v3 API took 0.006s '/api/v3/search-suggestion/?_dc=1593600617693'
t Transfer: 1220 :     10|11:50:17.9634|LEG85N|DANIEL|OAuth: /api/v3/search-suggestion/?_dc=1593600617870
t Transfer: 1220 :     10|11:50:17.9634|LEG85N|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:50:17.9634|LEG85N|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:50:17.9634|LEG85N|DANIEL|    user DANIEL.
t Verbose: 1220 :      10|11:50:17.9634|LEG85N|DANIEL|OAuth. User logged in: DANIEL
t Transfer: 1220 :     10|11:50:17.9634|LEG85N|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:50:17.9634|LEG85N|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:50:17.9634|LEG85N|DANIEL|    user DANIEL.
t Verbose: 1220 :      10|11:50:17.9634|LEG85N|DANIEL|imfx v3 API took 0.006s '/api/v3/search-suggestion/?_dc=1593600617870'
t Transfer: 1220 :     10|11:50:18.1665|z6s058|DANIEL|OAuth: /api/v3/search-suggestion/?_dc=1593600617997
t Transfer: 1220 :     10|11:50:18.1665|z6s058|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:50:18.1665|z6s058|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:50:18.1665|z6s058|DANIEL|    user DANIEL.
t Verbose: 1220 :      10|11:50:18.1665|z6s058|DANIEL|OAuth. User logged in: DANIEL
t Transfer: 1220 :     10|11:50:18.1665|z6s058|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:50:18.1665|z6s058|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:50:18.1665|z6s058|DANIEL|    user DANIEL.
t Verbose: 1220 :      10|11:50:18.1665|z6s058|DANIEL|imfx v3 API took 0.006s '/api/v3/search-suggestion/?_dc=1593600617997'
t Transfer: 1220 :     10|11:50:18.1665|eEbDYe|DANIEL|OAuth: /api/v3/search-suggestion/?_dc=1593600618066
t Transfer: 1220 :     10|11:50:18.1665|eEbDYe|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:50:18.1665|eEbDYe|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:50:18.1665|eEbDYe|DANIEL|    user DANIEL.
t Verbose: 1220 :      10|11:50:18.1665|eEbDYe|DANIEL|OAuth. User logged in: DANIEL
t Transfer: 1220 :     10|11:50:18.1665|eEbDYe|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:50:18.1665|eEbDYe|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:50:18.1665|eEbDYe|DANIEL|    user DANIEL.
t Verbose: 1220 :      10|11:50:18.1665|eEbDYe|DANIEL|imfx v3 API took 0.007s '/api/v3/search-suggestion/?_dc=1593600618066'
t Transfer: 1220 :     10|11:50:18.3697|GaiCTI|DANIEL|OAuth: /api/v3/search-suggestion/?_dc=1593600618265
t Transfer: 1220 :     10|11:50:18.3697|GaiCTI|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:50:18.3697|GaiCTI|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:50:18.3697|GaiCTI|DANIEL|    user DANIEL.
t Verbose: 1220 :      10|11:50:18.3697|GaiCTI|DANIEL|OAuth. User logged in: DANIEL
t Transfer: 1220 :     10|11:50:18.3697|GaiCTI|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:50:18.3697|GaiCTI|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:50:18.3697|GaiCTI|DANIEL|    user DANIEL.
t Verbose: 1220 :      10|11:50:18.3697|GaiCTI|DANIEL|imfx v3 API took 0.007s '/api/v3/search-suggestion/?_dc=1593600618265'
t Transfer: 1220 :     10|11:50:18.5728|pH6mNg|DANIEL|OAuth: /api/v3/search-suggestion/?_dc=1593600618332
t Transfer: 1220 :     10|11:50:18.5728|pH6mNg|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:50:18.5728|pH6mNg|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:50:18.5728|pH6mNg|DANIEL|    user DANIEL.
t Verbose: 1220 :      10|11:50:18.5728|pH6mNg|DANIEL|OAuth. User logged in: DANIEL
t Transfer: 1220 :     10|11:50:18.5728|pH6mNg|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:50:18.5728|pH6mNg|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:50:18.5728|pH6mNg|DANIEL|    user DANIEL.
t Verbose: 1220 :      10|11:50:18.5728|pH6mNg|DANIEL|imfx v3 API took 0.007s '/api/v3/search-suggestion/?_dc=1593600618332'
t Transfer: 1220 :     10|11:50:18.7759|rpMVwV|DANIEL|OAuth: /api/v3/search-suggestion/?_dc=1593600618501
t Transfer: 1220 :     10|11:50:18.7759|rpMVwV|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:50:18.7759|rpMVwV|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:50:18.7759|rpMVwV|DANIEL|    user DANIEL.
t Verbose: 1220 :      10|11:50:18.7759|rpMVwV|DANIEL|OAuth. User logged in: DANIEL
t Transfer: 1220 :     10|11:50:18.7759|rpMVwV|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:50:18.7759|rpMVwV|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:50:18.7759|rpMVwV|DANIEL|    user DANIEL.
t Verbose: 1220 :      10|11:50:18.7759|rpMVwV|DANIEL|imfx v3 API took 0.007s '/api/v3/search-suggestion/?_dc=1593600618501'
t Transfer: 1220 :     10|11:50:18.7759|BTUiWs|DANIEL|OAuth: /api/v3/search-suggestion/?_dc=1593600618620
t Transfer: 1220 :     10|11:50:18.7759|BTUiWs|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:50:18.7759|BTUiWs|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:50:18.7759|BTUiWs|DANIEL|    user DANIEL.
t Verbose: 1220 :      10|11:50:18.7759|BTUiWs|DANIEL|OAuth. User logged in: DANIEL
t Transfer: 1220 :     10|11:50:18.7759|BTUiWs|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:50:18.7759|BTUiWs|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:50:18.7759|BTUiWs|DANIEL|    user DANIEL.
t Verbose: 1220 :      10|11:50:18.7759|BTUiWs|DANIEL|imfx v3 API took 0.007s '/api/v3/search-suggestion/?_dc=1593600618620'
t Transfer: 1220 :     10|11:50:18.9790|EmDah7|DANIEL|OAuth: /api/v3/search-suggestion/?_dc=1593600618814
t Transfer: 1220 :     10|11:50:18.9790|EmDah7|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:50:18.9790|EmDah7|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:50:18.9790|EmDah7|DANIEL|    user DANIEL.
t Verbose: 1220 :      10|11:50:18.9790|EmDah7|DANIEL|OAuth. User logged in: DANIEL
t Transfer: 1220 :     10|11:50:18.9790|EmDah7|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:50:18.9790|EmDah7|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:50:18.9790|EmDah7|DANIEL|    user DANIEL.
t Verbose: 1220 :      10|11:50:18.9790|EmDah7|DANIEL|imfx v3 API took 0.006s '/api/v3/search-suggestion/?_dc=1593600618814'
t Transfer: 1220 :     10|11:50:19.1821|wwpgrM|DANIEL|OAuth: /api/v3/search-suggestion/?_dc=1593600618964
t Transfer: 1220 :     10|11:50:19.1821|wwpgrM|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:50:19.1821|wwpgrM|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:50:19.1821|wwpgrM|DANIEL|    user DANIEL.
t Verbose: 1220 :      10|11:50:19.1821|wwpgrM|DANIEL|OAuth. User logged in: DANIEL
t Transfer: 1220 :     10|11:50:19.1821|wwpgrM|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:50:19.1821|wwpgrM|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:50:19.1821|wwpgrM|DANIEL|    user DANIEL.
t Verbose: 1220 :      10|11:50:19.1821|wwpgrM|DANIEL|imfx v3 API took 0.005s '/api/v3/search-suggestion/?_dc=1593600618964'
t Transfer: 1220 :     10|11:50:19.1821|r8lyKo|DANIEL|OAuth: /api/v3/search-suggestion/?_dc=1593600619016
t Transfer: 1220 :     10|11:50:19.1821|r8lyKo|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:50:19.1821|r8lyKo|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:50:19.1821|r8lyKo|DANIEL|    user DANIEL.
t Verbose: 1220 :      10|11:50:19.1821|r8lyKo|DANIEL|OAuth. User logged in: DANIEL
t Transfer: 1220 :     10|11:50:19.1821|r8lyKo|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:50:19.1821|r8lyKo|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:50:19.1821|r8lyKo|DANIEL|    user DANIEL.
t Verbose: 1220 :      10|11:50:19.1821|r8lyKo|DANIEL|imfx v3 API took 0.004s '/api/v3/search-suggestion/?_dc=1593600619016'
t Transfer: 1220 :     10|11:50:19.1821|HCkB9H|DANIEL|OAuth: /api/v3/search-suggestion/?_dc=1593600619072
t Transfer: 1220 :     10|11:50:19.1821|HCkB9H|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:50:19.1821|HCkB9H|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:50:19.1821|HCkB9H|DANIEL|    user DANIEL.
t Verbose: 1220 :      10|11:50:19.1821|HCkB9H|DANIEL|OAuth. User logged in: DANIEL
t Transfer: 1220 :     10|11:50:19.1821|HCkB9H|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:50:19.1821|HCkB9H|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:50:19.1821|HCkB9H|DANIEL|    user DANIEL.
t Verbose: 1220 :      10|11:50:19.1821|HCkB9H|DANIEL|imfx v3 API took 0.005s '/api/v3/search-suggestion/?_dc=1593600619072'
t Transfer: 1220 :     10|11:50:19.3853|nAI625|DANIEL|OAuth: /api/v3/search-suggestion/?_dc=1593600619261
t Transfer: 1220 :     10|11:50:19.3853|nAI625|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:50:19.3853|nAI625|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:50:19.3853|nAI625|DANIEL|    user DANIEL.
t Verbose: 1220 :      10|11:50:19.3853|nAI625|DANIEL|OAuth. User logged in: DANIEL
t Transfer: 1220 :     10|11:50:19.3853|nAI625|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:50:19.3853|nAI625|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:50:19.3853|nAI625|DANIEL|    user DANIEL.
t Verbose: 1220 :      10|11:50:19.3853|nAI625|DANIEL|imfx v3 API took 0.005s '/api/v3/search-suggestion/?_dc=1593600619261'
t Transfer: 1220 :     10|11:50:19.5884|AZ5rzh|DANIEL|OAuth: /api/v3/search/title?_dc=1593600619487
t Transfer: 1220 :     10|11:50:19.5884|AZ5rzh|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:50:19.5884|AZ5rzh|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:50:19.5884|AZ5rzh|DANIEL|    user DANIEL.
t Verbose: 1220 :      10|11:50:19.5884|AZ5rzh|DANIEL|OAuth. User logged in: DANIEL
t Information: 1220 :  10|11:50:19.5884|AZ5rzh|DANIEL|V3Api.SearchTitles
t Information: 1220 :  10|11:50:19.5884|AZ5rzh|DANIEL|V3Api.SearchGeneric
t Transfer: 1220 :     10|11:50:19.5884|AZ5rzh|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:50:19.5884|AZ5rzh|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:50:19.5884|AZ5rzh|DANIEL|    user DANIEL.
t Transfer: 1220 :     10|11:50:19.5884|AZ5rzh|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:50:19.5884|AZ5rzh|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:50:19.5884|AZ5rzh|DANIEL|    user DANIEL.
t Information: 1220 :  10|11:50:19.5884|AZ5rzh|DANIEL|SearchTitle SQL:
with 
 v as (
    SELECT 
        abs.*
       ,decode(ITEM_TYPE,
                 1010,SER_ABS_ID,
                 1020,CASE WHEN SER_ABS2_ID > 0 THEN SER_ABS2_ID ELSE SER_ABS_ID END
              ) xparent_id
      FROM TMDDBA.TM_PG_ABS abs
     WHERE abs.id in (
          select a.id
          FROM TMDDBA.TM_PG_ABS a
          where ABS_DELETED = 0  AND (CONTAINS(CTX_TEXT_COL,'game of thrones') > 0 OR CONTAINS(CTX_IDS_COL,'game of thrones') > 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 "TreeLevel", 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 :      10|11:50:19.7916|AZ5rzh|DANIEL|imfx v3 API took 0.160s '/api/v3/search/title?_dc=1593600619487'
t Transfer: 1220 :     10|11:50:19.9947|5EazrR|DANIEL|OAuth: /api/v3/title/278625/versions?_dc=1593600619887
t Transfer: 1220 :     10|11:50:19.9947|5EazrR|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:50:19.9947|5EazrR|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:50:19.9947|5EazrR|DANIEL|    user DANIEL.
t Verbose: 1220 :      10|11:50:19.9947|5EazrR|DANIEL|OAuth. User logged in: DANIEL
t Information: 1220 :  10|11:50:19.9947|5EazrR|DANIEL|V3Api.SearchGeneric
t Transfer: 1220 :     10|11:50:19.9947|5EazrR|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:50:19.9947|5EazrR|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:50:19.9947|5EazrR|DANIEL|    user DANIEL.
t Transfer: 1220 :     10|11:50:19.9947|5EazrR|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:50:19.9947|5EazrR|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:50:19.9947|5EazrR|DANIEL|    user DANIEL.
t Information: 1220 :  10|11:50:19.9947|5EazrR|DANIEL|SearchVersion SQL:
 select * from (select a.*, rownum rnum  from ( select  m.*, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE,  nvl(t.text_id,-1) THUMBID, BUILD_PGRL_FULLTITLE(item_type, title, ser_name, ser_title) FULLTITLE     from tmddba.tm_pg_rl m 
        left outer join (select text_id, text_data_path, text_data_filename, text_ref_object from tmddba.tm_text) t on t.text_id = m.primary_thumb_id
 where item_type>0 and rl_deleted=0  and m.PGM_ABS_ID=278625 
 order by m.title,m.id) a where rownum <= 9999) r where rnum >=1 order by rnum
t Information: 1220 :  10|11:50:19.9947|5EazrR|DANIEL|Running version search. User: 342    Simple Search: 
Running Oracle search.
Running Oracle search for COUNT
Oracle count completed in: 1ms.  Returned lines: 0

t Verbose: 1220 :      10|11:50:19.9947|5EazrR|DANIEL|imfx v3 API took 0.005s '/api/v3/title/278625/versions?_dc=1593600619887'
t Transfer: 1220 :     10|11:50:19.9947|sBz~do|DANIEL|OAuth: /api/user-preferences?_dc=1593600619897
t Transfer: 1220 :     10|11:50:19.9947|sBz~do|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:50:19.9947|sBz~do|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:50:19.9947|sBz~do|DANIEL|    user DANIEL.
t Verbose: 1220 :      10|11:50:19.9947|sBz~do|DANIEL|OAuth. User logged in: DANIEL
t Verbose: 1220 :      10|11:50:19.9947|sBz~do|DANIEL|StoreUserDataByKeys..
t Transfer: 1220 :     10|11:50:19.9947|sBz~do|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:50:19.9947|sBz~do|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:50:19.9947|sBz~do|DANIEL|    user DANIEL.
t Verbose: 1220 :      10|11:50:19.9947|sBz~do|DANIEL|imfx v3 API took 0.009s '/api/user-preferences?_dc=1593600619897'
t Transfer: 1220 :     10|11:50:22.4321|kD9fRJ|DANIEL|OAuth: /api/v3/title/293744/versions?_dc=1593600622207
t Transfer: 1220 :     10|11:50:22.4321|kD9fRJ|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:50:22.4321|kD9fRJ|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:50:22.4321|kD9fRJ|DANIEL|    user DANIEL.
t Verbose: 1220 :      10|11:50:22.4321|kD9fRJ|DANIEL|OAuth. User logged in: DANIEL
t Information: 1220 :  10|11:50:22.4321|kD9fRJ|DANIEL|V3Api.SearchGeneric
t Transfer: 1220 :     10|11:50:22.4321|kD9fRJ|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:50:22.4321|kD9fRJ|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:50:22.4321|kD9fRJ|DANIEL|    user DANIEL.
t Transfer: 1220 :     10|11:50:22.4321|kD9fRJ|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:50:22.4321|kD9fRJ|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:50:22.4321|kD9fRJ|DANIEL|    user DANIEL.
t Information: 1220 :  10|11:50:22.4321|kD9fRJ|DANIEL|SearchVersion SQL:
 select * from (select a.*, rownum rnum  from ( select  m.*, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE,  nvl(t.text_id,-1) THUMBID, BUILD_PGRL_FULLTITLE(item_type, title, ser_name, ser_title) FULLTITLE     from tmddba.tm_pg_rl m 
        left outer join (select text_id, text_data_path, text_data_filename, text_ref_object from tmddba.tm_text) t on t.text_id = m.primary_thumb_id
 where item_type>0 and rl_deleted=0  and m.PGM_ABS_ID=293744 
 order by m.title,m.id) a where rownum <= 9999) r where rnum >=1 order by rnum
t Information: 1220 :  10|11:50:22.4321|kD9fRJ|DANIEL|Running version search. User: 342    Simple Search: 
Running Oracle search.
Running Oracle search for COUNT
Oracle count completed in: 1ms.  Returned lines: 1
Oracle version search timing: 8ms.
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=293744 
 order by m.title,m.id) a where rownum <= 9999) r where rnum >=1 order by rnum

t Verbose: 1220 :      10|11:50:22.4321|kD9fRJ|DANIEL|imfx v3 API took 0.014s '/api/v3/title/293744/versions?_dc=1593600622207'
t Transfer: 1220 :     10|11:50:22.6353|73cwnY|DANIEL|OAuth: /api/v3/version/293745/media?_dc=1593600622407
t Transfer: 1220 :     10|11:50:22.6353|73cwnY|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:50:22.6353|73cwnY|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:50:22.6353|73cwnY|DANIEL|    user DANIEL.
t Verbose: 1220 :      10|11:50:22.6353|73cwnY|DANIEL|OAuth. User logged in: DANIEL
t Information: 1220 :  10|11:50:22.6353|73cwnY|DANIEL|V3Api.SearchGeneric
t Transfer: 1220 :     10|11:50:22.6353|73cwnY|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:50:22.6353|73cwnY|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:50:22.6353|73cwnY|DANIEL|    user DANIEL.
t Information: 1220 :  10|11:50:22.6353|73cwnY|DANIEL|MediaSearch SQL:
select r.*,
    nvl((select TMD_STR_AGG(c.u_id_pfix ) from tm_ctnrs c, tm_mi_tpi_lnx l where l.miid=r.id and c.u_id=l.tpiid and r.media_type=1),'') BARCODE,
    nvl(lnk.lib_loc_ext_id,0) lib_loc_ext_id, nvl(lnk.ctnr_loan_stat,0) ctnr_loan_status, nvl(lnk.ctnr_stat,0) ctnr_stat,
    nvl(t.text_data_path,'') THUMBSERVER, 
    nvl(t.text_data_filename,'') THUMBFILE,
    nvl(t.text_id,-1) THUMBID , 
    GETMEDIALOC(r.id, r.media_type, r.compil, r.m_ctnr_int_o_loc, r.m_ctnr_ext_o_loc, r.m_ctnr_loc) LOCATION,
    nvl(dfl.fSOM,0) FILE_SOM, nvl(dfl.fEOM,0) FILE_EOM, dfl.fos_fname FILENAME, dfl.DFILE_LINK_GUID, dfl.OS_GUID, dfl.SUB_FOLDER, dfl.ORIGINAL_FILENAME 

    from (select a.*, rownum rnum from 
      (select  m.*,
     coalesce(m.primary_thumb_id, (select v.primary_thumb_id from tm_pg_rl v where v.id=m.pgm_parent_id)) primary_thumb_id2 
      from tmddba.tm_mis m 
 where media_type>0 and item_type>0  AND  PGM_PARENT_ID=:pgm_parent_id_1  and m.mi_deleted=0  
 order by upper(m.title), m.media_type, m.ec_som, m.id ) a where rownum <= 50) r 
    ,lateral( select l.miid, max(c.C_EXT_OUT_LOC) lib_loc_ext_id, max(c.C_STAT) ctnr_stat, max(c.loan_stat) ctnr_loan_stat  from tm_mi_tpi_lnx l, tm_ctnrs c where c.u_id=l.tpiid and l.miid=r.id and r.media_type=1 group by l.miid)(+) lnk 
    ,lateral(select tt.* from tm_text tt where tt.text_id = r.primary_thumb_id2)(+) t
    ,lateral(select /*+ NO_DECORRELATE */  d.som fsom, d.eom feom, dl.mi_id fmi_id, d.os_fname fos_fname, d.DFILE_LINK_GUID, d.OS_GUID, d.SUB_FOLDER, dl.dfile_id, d.original_filename
        FROM tm_dfile d, tm_mi_dfile_lnx dl where d.id=dl.dfile_id and r.id=dl.mi_id and rownum=1)(+) dfl 
    
    where rnum >= 1 order by rnum
Param: pgm_parent_id_1: 293745
t Information: 1220 :  10|11:50:22.6353|73cwnY|DANIEL|    timing: 00:00:00.0300219
t Verbose: 1220 :      10|11:50:22.6353|73cwnY|DANIEL|imfx v3 API took 0.030s '/api/v3/version/293745/media?_dc=1593600622407'
t Transfer: 1220 :     10|11:50:22.6353|73cwnY|DANIEL|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\gotspecialspromo10secaction.mp4 subfolder 
t Transfer: 1220 :     10|11:50:22.6353|73cwnY|DANIEL|  GetFileName result https://imfxv3tm.tmd.tv/VideoServer/gotspecialspromo10secaction.mp4
t Transfer: 1220 :     10|11:50:22.6353|73cwnY|DANIEL|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/gotspecialspromo10secaction.mp4
t Transfer: 1220 :     10|11:50:22.6353|73cwnY|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:50:22.6353|73cwnY|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:50:22.6353|73cwnY|DANIEL|    user DANIEL.
t Transfer: 1220 :     10|11:50:22.6353|73cwnY|DANIEL|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\gotspecialspromo20seccharacter.mp4 subfolder 
t Transfer: 1220 :     10|11:50:22.6353|73cwnY|DANIEL|  GetFileName result https://imfxv3tm.tmd.tv/VideoServer/gotspecialspromo20seccharacter.mp4
t Transfer: 1220 :     10|11:50:22.6353|73cwnY|DANIEL|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/gotspecialspromo20seccharacter.mp4
t Transfer: 1220 :     10|11:50:22.6353|73cwnY|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:50:22.6353|73cwnY|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:50:22.6353|73cwnY|DANIEL|    user DANIEL.
t Transfer: 1220 :     10|11:50:22.6353|73cwnY|DANIEL|GetUrl. Storage |Image| filename \\192.168.120.254\DemoFS\Digital Assets\Image\gotspecialspromosimage.jpg subfolder 
t Transfer: 1220 :     10|11:50:22.6353|73cwnY|DANIEL|  GetFileName result https://imfxv3tm.tmd.tv/ImageServer/gotspecialspromosimage.jpg
t Transfer: 1220 :     10|11:50:22.6353|73cwnY|DANIEL|GetUrl. result https://imfxv3tm.tmd.tv/ImageServer/gotspecialspromosimage.jpg
t Transfer: 1220 :     10|11:50:22.6353|73cwnY|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:50:22.6353|73cwnY|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:50:22.6353|73cwnY|DANIEL|    user DANIEL.
t Transfer: 1220 :     10|11:50:22.6353|73cwnY|DANIEL|GetUrl. Storage |TEMP_UPLOAD| filename \\192.168.120.254\DemoFS\Digital Assets\TEMP_UPLOAD\68add84afa7b\Animation Sample1.mp4 subfolder 68add84afa7b\
t Transfer: 1220 :     10|11:50:22.6353|73cwnY|DANIEL|  GetFileName result https://demo.tmd.tv/Temp Upload/Animation%20Sample1.mp4
t Transfer: 1220 :     10|11:50:22.6353|73cwnY|DANIEL|GetUrl. result https://demo.tmd.tv/Temp Upload/Animation%20Sample1.mp4
t Transfer: 1220 :     10|11:50:22.6353|73cwnY|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:50:22.6353|73cwnY|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:50:22.6353|73cwnY|DANIEL|    user DANIEL.
t Transfer: 1220 :     10|11:50:22.6353|73cwnY|DANIEL|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Example 06052020.mp4 subfolder 
t Transfer: 1220 :     10|11:50:22.6353|73cwnY|DANIEL|  GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Example%2006052020.mp4
t Transfer: 1220 :     10|11:50:22.6353|73cwnY|DANIEL|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/Example%2006052020.mp4
t Transfer: 1220 :     10|11:50:22.6353|73cwnY|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:50:22.6353|73cwnY|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:50:22.6353|73cwnY|DANIEL|    user DANIEL.
t Transfer: 1220 :     10|11:50:22.6353|73cwnY|DANIEL|GetUrl. Storage |Audio| filename \\192.168.120.254\DemoFS\Digital Assets\Audio\PMH_portugese - Copy.wav subfolder 
t Transfer: 1220 :     10|11:50:22.6353|73cwnY|DANIEL|  GetFileName result https://imfxv3tm.tmd.tv/AudioServer/PMH_portugese%20-%20Copy.wav
t Transfer: 1220 :     10|11:50:22.6353|73cwnY|DANIEL|GetUrl. result https://imfxv3tm.tmd.tv/AudioServer/PMH_portugese%20-%20Copy.wav
t Transfer: 1220 :     10|11:50:22.6353|73cwnY|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:50:22.6353|73cwnY|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:50:22.6353|73cwnY|DANIEL|    user DANIEL.
t Transfer: 1220 :     10|11:50:22.6353|73cwnY|DANIEL|GetUrl. Storage |Audio| filename \\192.168.120.254\DemoFS\Digital Assets\Audio\gotspecialspromosaudio.wav subfolder 
t Transfer: 1220 :     10|11:50:22.6353|73cwnY|DANIEL|  GetFileName result https://imfxv3tm.tmd.tv/AudioServer/gotspecialspromosaudio.wav
t Transfer: 1220 :     10|11:50:22.6353|73cwnY|DANIEL|GetUrl. result https://imfxv3tm.tmd.tv/AudioServer/gotspecialspromosaudio.wav
t Transfer: 1220 :     10|11:50:22.6353|73cwnY|DANIEL|GetCurrentUser..
t Transfer: 1220 :     10|11:50:22.6353|73cwnY|DANIEL|  OAuth authenticated
t Transfer: 1220 :     10|11:50:22.6353|73cwnY|DANIEL|    user DANIEL.
t Information: 1220 :  10|11:54:13.1926|||OrabitWatcherBasic. Disposing.
t Information: 1220 :  10|11:54:13.1926|||OrabitWatcherBasic. Disposed.
t Information: 1220 :  10|11:54:13.1926|||==========================================================================
t Information: 1220 :  10|11:54:13.1926|||IMFX CORE SERVER APPLICATION END.