t Information: 1220 :  12|08:44:33.6361|||Get Configuration Values:
t Information: 1220 :  12|08:44:33.6361|||	AdminPassEnc, default: , value: ffqjrn0leKv4Lj2YJHe2dw==.
t Information: 1220 :  12|08:44:33.6361|||	EncryptedPasswords, default: true, value: true.
t Information: 1220 :  12|08:44:33.6361|||	OraConnectionString, default: , value: Server=TECHM;User Id=imfx;Password=xxxxx;Unicode=true;.
t Information: 1220 :  12|08:44:33.6361|||	SecondTimezone, default: , value: .
t Information: 1220 :  12|08:44:33.6361|||	UseActiveDirectoryAuth, default: false, value: false.
t Information: 1220 :  12|08:44:33.6361|||	ReportingServiceUrl, default: , value: http://localhost:92/ReportingService.svc.
t Information: 1220 :  12|08:44:33.6518|||	ReportsPath, default: , value: .
t Information: 1220 :  12|08:44:33.6518|||	ReportsURL, default: , value: .
t Information: 1220 :  12|08:44:33.6518|||	TapeServiceUrl, default: , value: .
t Information: 1220 :  12|08:44:33.6518|||	GatekeeperUrl, default: , value: .
t Information: 1220 :  12|08:44:33.6518|||	ValuationUrl, default: , value: .
t Information: 1220 :  12|08:44:33.6518|||	QueueManagerDelay, default: 30, value: 30.
t Information: 1220 :  12|08:44:33.6518|||	QueueManagerFullRefresh, default: 90, value: 90.
t Information: 1220 :  12|08:44:33.6518|||	AudioLoopDuration, default: 0, value: 150.
t Information: 1220 :  12|08:44:33.6518|||	AudioLoopsCount, default: 0, value: 0.
t Information: 1220 :  12|08:44:33.6518|||	PlayerFakeStep, default: 500, value: 500.
t Information: 1220 :  12|08:44:33.6518|||	PlayerForceRatio, default: 0, value: 1.
t Information: 1220 :  12|08:44:33.6518|||	CheckVersionsInProd, default: false, value: True.
t Information: 1220 :  12|08:44:33.6593|||	MaxResults, default: 3000, value: 10000.
t Information: 1220 :  12|08:44:33.6593|||	TEReportID, default: 0, value: 0.
t Information: 1220 :  12|08:44:33.6593|||	ClosedCaptionsCache, default: , value: C:\inetpub\wwwroot\imfxcore\timedtextcache\.
t Information: 1220 :  12|08:44:33.6593|||	ClosedCaptionsStorage, default: , value: c:\Mediaflex\subs.
t Information: 1220 :  12|08:44:33.6593|||	TimeCodeFormat, default: , value: pal.
t Information: 1220 :  12|08:44:33.6593|||	RceMediaPath, default: , value: C:\edl\.
t Information: 1220 :  12|08:44:33.6602|||	RceMediaPath, default: , value: C:\edl\.
t Information: 1220 :  12|08:44:33.6602|||	RceCsmOutputPath, default: , value: C:\Inetpub\wwwroot\csm\.
t Information: 1220 :  12|08:44:33.6602|||	RceCsmUrl, default: , value: http://localhost/csm/.
t Information: 1220 :  12|08:44:33.6612|||	RceMediaSelection, default: , value: miLinkIdMatch.
t Information: 1220 :  12|08:44:33.6612|||	RequestBrowseJobPresetName, default: , value: .
t Information: 1220 :  12|08:44:33.6612|||	DontExtendDuration, default: false, value: False.
t Information: 1220 :  12|08:44:33.6612|||	V3ConfigUrl, default: , value: .
t Information: 1220 :  12|08:44:33.6612|||	StopWords, default: , value: .
t Information: 1220 :  12|08:44:33.6612|||	MisrTxFormat, default: G, value: G.
t Information: 1220 :  12|08:44:33.6612|||	ApiServer, default: , value: http://192.168.120.10:85.
t Information: 1220 :  12|08:44:33.6622|||	ApiTimeout, default: 120, value: 120.
t Information: 1220 :  12|08:44:33.6622|||	ApiWorkers, default: 10, value: 10.
t Information: 1220 :  12|08:44:33.6622|||	UsePerfCounters, default: false, value: false.
t Information: 1220 :  12|08:44:33.6622|||	LogGetCurrentUser, default: true, value: true.
t Information: 1220 :  12|08:44:33.6622|||	LogInternalApi, default: true, value: true.
t Information: 1220 :  12|08:44:33.6622|||	LivePlayApiUrl, default: , value: .
t Information: 1220 :  12|08:44:33.6642|||	LivePlayApiTimeout, default: 120, value: 120.
t Information: 1220 :  12|08:44:33.6652|||	ThumbnailServer, default: , value: .
t Information: 1220 :  12|08:44:33.6662|||	PasswordResetEmailTemplateId, default: 0, value: 0.
t Information: 1220 :  12|08:44:33.6662|||	PasswordResetEmailTemplateId_MediaPortal, default: 0, value: 0.
t Information: 1220 :  12|08:44:33.6662|||	imfxBaseUrl, default: , value: .
t Information: 1220 :  12|08:44:33.6662|||	imfxBaseUrl_MediaPortal, default: , value: .
t Information: 1220 :  12|08:44:33.6672|||	imfxBaseUrl_VideoBrowser, default: , value: .
t Information: 1220 :  12|08:44:33.6672|||	ShowDetailedErrors, default: false, value: false.
t Information: 1220 :  12|08:44:33.6672|||	AllowXmlRequests, default: false, value: false.
t Information: 1220 :  12|08:44:33.6672|||	MaxLoginAttempts, default: 3, value: 3.
t Information: 1220 :  12|08:44:33.6672|||	MaxLoginAttemptsPeriod, default: 15, value: 15.
t Information: 1220 :  12|08:44:33.6672|||	AllowRaisePreviewInMiSR, default: false, value: false.
t Information: 1220 :  12|08:44:33.6672|||	LocationFilter, default: , value: .
t Information: 1220 :  12|08:44:33.6672|||	SvUtilServiceUrl, default: , value: .
t Information: 1220 :  12|08:44:33.6682|||	SolrConnection, default: , value: http://192.168.120.14:8983/solr.
t Information: 1220 :  12|08:44:33.6682|||	UseIndexServerSearch, default: false, value: True.
t Information: 1220 :  12|08:44:33.6682|||	SolrIndexVersion, default: 1, value: 6.
t Information: 1220 :  12|08:44:33.6682|||	SolrConnection, default: , value: http://192.168.120.14:8983/solr.
t Information: 1220 :  12|08:44:33.6682|||	FacetsGroups, default: , value: owners,season_id, series_id,version_key,item_type,media_type,media_format,episode_number.
t Information: 1220 :  12|08:44:33.6682|||	FacetsGroupsVersion, default: , value: owners,season_id, series_id,version_key,episode_number.
t Information: 1220 :  12|08:44:33.6692|||	FacetsGroupsChameleon, default: , value: season_id, series_id,genre,prod_year,version_key.
t Information: 1220 :  12|08:44:33.6692|||	PreviewPreset, default: , value: .
t Information: 1220 :  12|08:44:33.6692|||	DevMode, default: false, value: false.
t Information: 1220 :  12|08:44:33.6692|||	DisableSysMan, default: false, value: false.
t Information: 1220 :  12|08:44:33.6692|||	TimeCodeFormat, default: , value: pal.
t Information: 1220 :  12|08:44:33.6692|||	FileCatalystStorageDevice, default: , value: .
t Information: 1220 :  12|08:44:33.6692|||	UseResponsibilityTracking, default: true, value: True.
t Information: 1220 :  12|08:44:33.6692|||	SubtitleDeviceFilter, default: , value: .
t Information: 1220 :  12|08:44:33.6692|||	SystemMonitorNamedPipe, default: , value: .
t Information: 1220 :  12|08:44:33.6692|||	OracleMonitorEnable, default: false, value: False.
t Information: 1220 :  12|08:44:33.6692|||	ArcApiHost, default: , value: .
t Information: 1220 :  12|08:44:33.6692|||	SolrTimedTextSearch, default: false, value: false.
t Information: 1220 :  12|08:44:33.6692|||	ProductionDurationUsageID, default: 1, value: 1.
t Information: 1220 :  12|08:44:33.6692|||	MediaFacetOrder, default: ResultCountAsc, value: ResultCountAsc.
t Information: 1220 :  12|08:44:33.6692|||	VersionFacetOrder, default: ResultCountAsc, value: ResultCountAsc.
t Information: 1220 :  12|08:44:34.0817|||GetStreamServers..
t Information: 1220 :  12|08:44:34.4892|||	https://demo.tmd.tv/CBR Video/ |CBR Video| False  
t Information: 1220 :  12|08:44:34.4892|||	https://demo.tmd.tv/CBR Images/ |CBR Images| False  
t Information: 1220 :  12|08:44:34.4892|||	https://demo.tmd.tv/CBR Audio/ |CBR Audio| False  
t Information: 1220 :  12|08:44:34.4892|||	https://demo.tmd.tv/Temp Upload/ |TEMP_UPLOAD| False  
t Information: 1220 :  12|08:44:34.4892|||	http://localhost:82/images/ |IMAGES| False  
t Information: 1220 :  12|08:44:34.4892|||	http://192.168.91.73/smoothcloud/ |SMOOTH_CLOUD| False  
t Information: 1220 :  12|08:44:34.4892|||	http://192.168.91.73/cloudstore/ |CLOUD_STORE| False  
t Information: 1220 :  12|08:44:34.4892|||	http://192.168.91.73/editsystemin/ |EDIT_SYSTEM_IN| False  
t Information: 1220 :  12|08:44:34.4892|||	http://192.168.91.27:89/APPLEPROXY/ |APPLE_PROXY| False  
t Information: 1220 :  12|08:44:34.4892|||	http://localhost:82/video/ |FILESTORE_VIDEO| False  
t Information: 1220 :  12|08:44:34.4892|||	https://imfxv3tm.tmd.tv/streaming/ |Streaming| False  
t Information: 1220 :  12|08:44:34.4892|||	https://imfxv3tm.tmd.tv/VideoServer/ |Video| False  
t Information: 1220 :  12|08:44:34.4892|||	https://imfxv3tm.tmd.tv/Proxy/ |Proxy| False  
t Information: 1220 :  12|08:44:34.4892|||	https://imfxv3tm.tmd.tv/AdobeIn/ |Adobe Premiere Pro In| False  
t Information: 1220 :  12|08:44:34.4892|||	https://imfxv3tm.tmd.tv/AudioServer/ |Audio| False  
t Information: 1220 :  12|08:44:34.4892|||	https://imfxv3tm.tmd.tv/ImageServer/ |Image| False  
t Information: 1220 :  12|08:44:34.4892|||	https://imfxv3tm.tmd.tv/DocsServer/ |Docs| False  
t Information: 1220 :  12|08:44:34.4892|||	https://imfxv3tm.tmd.tv/AmazonLabs/ |TEST HOUSE| False  
t Information: 1220 :  12|08:44:34.4892|||	SolrConnectionUms, default: http://192.168.120.14:8983/solr, value: http://192.168.120.14:8983/solr.
t Information: 1220 :  12|08:44:34.4892|||	LogWebApi, default: false, value: false.
t Information: 1220 :  12|08:44:34.4892|||	EmbeddedRceUrl, default: , value: .
t Information: 1220 :  12|08:44:34.4892|||	InstallMode, default: , value: .
t Information: 1220 :  12|08:44:34.4892|||	SamlRequestAddress, default: , value: .
t Information: 1220 :  12|08:44:34.4892|||	SamlTrustedIssuer, default: , value: .
t Information: 1220 :  12|08:44:34.4892|||	SamlLoginRedirect, default: , value: .
t Information: 1220 :  12|08:44:34.4892|||	NaturalLangSearch, default: false, value: True.
t Information: 1220 :  12|08:44:34.4892|||	LocalUploadExpirationHours, default: 0, value: 0.
t Information: 1220 :  12|08:44:34.4892|||	LocalUploadDeviceId, default: 0, value: 0.
t Information: 1220 :  12|08:44:34.4892|||	VideosFileFormatIds, default: , value: .
t Information: 1220 :  12|08:44:34.4892|||	VideosStorageIds, default: , value: .
t Information: 1220 :  12|08:44:34.4892|||	OktaLoginField, default: , value: .
t Information: 1220 :  12|08:44:34.4892|||	AuthenticationTypes, default: , value: Native,PublicApiKey.
t Information: 1220 :  12|08:44:34.4892|||OrabitWatcherBasic. Initialize.
t Information: 1220 :  12|08:44:34.7080|||FillDictionaryCache.
t Information: 1220 :  12|08:44:38.4415|||GetSupportedOperators
t Information: 1220 :  12|08:44:38.8521|||CacheTechReports.
t Information: 1220 :  12|08:44:39.0552|||& Cache update. Server (global) filled with timestamp 08:10:38.8677545. types null
t Information: 1220 :  12|08:44:39.0552|||InitializeFromDatabase.
  'Server=TECHM;User Id=imfx;password=..;Unicode=true;'
  direct False, home , timeout 15
t Information: 1220 :  12|08:44:39.0552|||FillDictionaryCache.
t Information: 1220 :  12|08:44:39.0552|||& Cache update. Server (global) filled with timestamp 08:10:38.8990046. types FriendlyNames, DatabaseSearchFieldData
t Information: 1220 :  12|08:44:39.4927|||OrabitWatcherBasic trying to connect..
t Information: 1220 :  12|08:44:39.4927|||OrabitWatcherBasic connected.
t Information: 1220 :  12|08:44:39.4927|||OrabitWatcherBasic queue created tmd.cfg.in.5b6a31ff-c040-435e-bad1-d7d8adaf53a1
t Information: 1220 :  12|08:44:39.6958|||==========================================================================
t Information: 1220 :  12|08:44:39.6958|||IMFX CORE SERVER APPLICATION START.
t Information: 1220 :  12|08:44:39.6958|||DLL VERSION: 3.0.0.1034.
t Information: 1220 :  12|08:44:39.6958|||IS TIMER HIGH RESOLUTION : True.
t Information: 1220 :  12|08:44:39.6958|||	UmsDev, default: False, value: False.
t Transfer: 1220 :     12|15:26:37.4787|Kkwg5W||OAuth: /api/user-preferences?keys=color_schema&_dc=1698765998014
t Transfer: 1220 :     12|15:26:37.4787|PMoQiz||OAuth: /api/settings/user/mainMenuSettings?_dc=1698765998031
t Transfer: 1220 :     12|15:26:37.4787|VIjLfY||OAuth: /api/settings/group/0?_dc=1698765998030
t Transfer: 1220 :     12|15:26:37.4787|QqiV0y||OAuth: /api/settings/user/uploadSettings?_dc=1698765998035
t Transfer: 1220 :     12|15:26:37.4787|iiBfs5||OAuth: /api/settings/user/defaultHomePage?_dc=1698765998011
t Transfer: 1220 :     12|15:26:37.4787|mWKjCF||OAuth: /api/user-preferences?keys=media.basket.data&_dc=1698765998009
t Transfer: 1220 :     12|15:26:37.4787|Kkwg5W||GetCurrentUser..
t Transfer: 1220 :     12|15:26:37.4787|Kkwg5W||  OAuth authenticated
t Verbose: 1220 :      12|15:26:37.4787|Kkwg5W||    uid claim is missing..
t Information: 1220 :  12|15:26:37.4787|Kkwg5W||OAuth. AutoLogin no Windows identity  type WindowsIdentity
t Transfer: 1220 :     12|15:26:37.4787|iiBfs5||GetCurrentUser..
t Transfer: 1220 :     12|15:26:37.4787|iiBfs5||  OAuth authenticated
t Verbose: 1220 :      12|15:26:37.4787|iiBfs5||    uid claim is missing..
t Information: 1220 :  12|15:26:37.4787|iiBfs5||OAuth. AutoLogin no Windows identity  type WindowsIdentity
t Transfer: 1220 :     12|15:26:37.4787|mWKjCF||GetCurrentUser..
t Transfer: 1220 :     12|15:26:37.4787|mWKjCF||  OAuth authenticated
t Verbose: 1220 :      12|15:26:37.4787|mWKjCF||    uid claim is missing..
t Information: 1220 :  12|15:26:37.4787|mWKjCF||OAuth. AutoLogin no Windows identity  type WindowsIdentity
t Transfer: 1220 :     12|15:26:37.4787|PMoQiz||GetCurrentUser..
t Transfer: 1220 :     12|15:26:37.4787|PMoQiz||  OAuth authenticated
t Verbose: 1220 :      12|15:26:37.4787|PMoQiz||    uid claim is missing..
t Information: 1220 :  12|15:26:37.4787|PMoQiz||OAuth. AutoLogin no Windows identity  type WindowsIdentity
t Transfer: 1220 :     12|15:26:37.4787|QqiV0y||GetCurrentUser..
t Transfer: 1220 :     12|15:26:37.4787|QqiV0y||  OAuth authenticated
t Verbose: 1220 :      12|15:26:37.4787|QqiV0y||    uid claim is missing..
t Information: 1220 :  12|15:26:37.4787|QqiV0y||OAuth. AutoLogin no Windows identity  type WindowsIdentity
t Transfer: 1220 :     12|15:26:37.4787|VIjLfY||GetCurrentUser..
t Transfer: 1220 :     12|15:26:37.4787|VIjLfY||  OAuth authenticated
t Verbose: 1220 :      12|15:26:37.4787|VIjLfY||    uid claim is missing..
t Information: 1220 :  12|15:26:37.4787|VIjLfY||OAuth. AutoLogin no Windows identity  type WindowsIdentity
t Transfer: 1220 :     12|15:26:37.6975|00q2Jj||OAuth: /api/user-preferences?keys=media.basket.data&_dc=1698765998044
t Transfer: 1220 :     12|15:26:37.6975|00q2Jj||GetCurrentUser..
t Transfer: 1220 :     12|15:26:37.6975|00q2Jj||  OAuth authenticated
t Verbose: 1220 :      12|15:26:37.6975|00q2Jj||    uid claim is missing..
t Information: 1220 :  12|15:26:37.6975|00q2Jj||OAuth. AutoLogin no Windows identity  type WindowsIdentity
t Transfer: 1220 :     12|15:26:37.6975|BSLXK8||OAuth: /api/settings/group/0?_dc=1698765998060
t Transfer: 1220 :     12|15:26:37.6975|BSLXK8||GetCurrentUser..
t Transfer: 1220 :     12|15:26:37.6975|BSLXK8||  OAuth authenticated
t Verbose: 1220 :      12|15:26:37.6975|BSLXK8||    uid claim is missing..
t Information: 1220 :  12|15:26:37.6975|BSLXK8||OAuth. AutoLogin no Windows identity  type WindowsIdentity
t Transfer: 1220 :     12|15:26:37.6975|kfloOx||OAuth: /api/settings/user/mainMenuSettings?_dc=1698765998060
t Transfer: 1220 :     12|15:26:37.6975|kfloOx||GetCurrentUser..
t Transfer: 1220 :     12|15:26:37.6975|kfloOx||  OAuth authenticated
t Verbose: 1220 :      12|15:26:37.6975|kfloOx||    uid claim is missing..
t Information: 1220 :  12|15:26:37.6975|kfloOx||OAuth. AutoLogin no Windows identity  type WindowsIdentity
t Transfer: 1220 :     12|15:26:37.9078|Ru1yf5||OAuth: /api/logout?_dc=1698765998436
t Transfer: 1220 :     12|15:26:37.9078|Ru1yf5||GetCurrentUser..
t Transfer: 1220 :     12|15:26:37.9078|Ru1yf5||  OAuth authenticated
t Verbose: 1220 :      12|15:26:37.9078|Ru1yf5||    uid claim is missing..
t Information: 1220 :  12|15:26:37.9078|Ru1yf5||OAuth. AutoLogin no Windows identity  type WindowsIdentity
t Information: 1220 :  12|15:26:37.9078|NIWNKq||GetCache.
t Information: 1220 :  12|15:26:37.9078|vN3eF1||GetCache.
t Information: 1220 :  12|15:26:37.9078|vN3eF1||GetCache. Found: C:\inetpub\wwwroot\imfxcore\VisualAssetsCache\106_0_PnqJC_.png
t Information: 1220 :  12|15:26:37.9078|NIWNKq||GetCache. Found: C:\inetpub\wwwroot\imfxcore\VisualAssetsCache\106_0_PnqJC_.png
t Information: 1220 :  12|15:26:37.9078|NIWNKq||GetCache. Data read: 0
t Information: 1220 :  12|15:26:37.9078|vN3eF1||GetCache. Data read: 0
t Verbose: 1220 :      12|15:26:37.9078|vN3eF1||imfx v3 API took 0.196s '/api/v3/visual-asset/group/PnqJC_/0/image'
t Verbose: 1220 :      12|15:26:37.9078|NIWNKq||imfx v3 API took 0.196s '/api/v3/visual-asset/group/PnqJC_/0/image'
t Transfer: 1220 :     12|15:26:38.1110|fS~09D||GetAppInfo. DB: TMDDEMO. Install mode: . Auth types: Native, PublicApiKey
t Information: 1220 :  12|15:26:38.3141|DuX_lL||GetCache.
t Information: 1220 :  12|15:26:38.3141|DuX_lL||GetCache. Found: C:\inetpub\wwwroot\imfxcore\VisualAssetsCache\108_2_PnqJC_.png
t Information: 1220 :  12|15:26:38.3141|DuX_lL||GetCache. Data read: 154944
t Verbose: 1220 :      12|15:26:38.3141|DuX_lL||imfx v3 API took 0.005s '/api/v3/visual-asset/group/PnqJC_/2/image'
t Verbose: 1220 :      12|15:26:47.8964|CbzrWM||Oauth validating..
t Verbose: 1220 :      12|15:26:47.8964|CbzrWM||GrantResourceOwnerCredentials.
t Verbose: 1220 :      12|15:26:47.8964|CbzrWM||LoginUser. daniel, login type OAuth, encrypt password True
t Information: 1220 :  12|15:26:47.8964|CbzrWM||TryLoginUser. daniel, login type OAuth, check password True, check hash False, encrypt password True, load user data False
t Information: 1220 :  12|15:26:48.3107|CbzrWM||  oauth token 00000000-0000-0000-0000-000000000000
t Information: 1220 :  12|15:26:48.3107|CbzrWM||TryLoginUser. Logged in..
t Information: 1220 :  12|15:26:48.3107|CbzrWM||GetPasswordPolicy. WARNING: Policy not found for system Imediaflex. Validation disabled.
t Verbose: 1220 :      12|15:26:48.3107|CbzrWM||LoginUser. Adding history. User Id 342, result DANIEL, host 192.168.127.6
t Verbose: 1220 :      12|15:26:48.3107|CbzrWM||GrantResourceOwnerCredentials. Try login finished. Logged: True
t Transfer: 1220 :     12|15:26:48.5138|wNlpg1|DANIEL|OAuth: /api/user-group-preferences?keys=defaultSearchColumnsMedia,defaultSearchColumnsVersion,defaultSearchColumnsSimple,defaultSearchColumnsTitle,defaultSearchMisrDetailsMediaColumns,versionCreationSettings,associate.advanced_search.version.setups,associate.advanced_search.media.setups,associate.wfrise.setups,supplier_portal.advanced_search.version.setups,media_portal.del_history.advanced.search_criteria,supplier_portal.version_complete.setups,logoImage,uploadSettings,helpdeskUrl,customLabels,googleMapsApiSettings&globals=isDebugMode,htmlplayerhotkeys,versionCreationSettings,associate.advanced_search.version.setups,associate.advanced_search.media.setups,associate.wfrise.setups,supplier_portal.advanced_search.version.setups,media_portal.del_history.advanced.search_criteria,helpdeskUrl,customLabels&_dc=1698766009192
t Transfer: 1220 :     12|15:26:48.5138|wNlpg1|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|15:26:48.5138|wNlpg1|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|15:26:48.5138|wNlpg1|DANIEL|    user DANIEL.
t Verbose: 1220 :      12|15:26:48.5138|wNlpg1|DANIEL|OAuth. User logged in: DANIEL
t Transfer: 1220 :     12|15:26:48.5138|wNlpg1|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|15:26:48.5138|wNlpg1|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|15:26:48.5138|wNlpg1|DANIEL|    user DANIEL.
t Verbose: 1220 :      12|15:26:48.5138|wNlpg1|DANIEL|imfx v3 API took 0.043s '/api/user-group-preferences?keys=defaultSearchColumnsMedia,defaultSearchColumnsVersion,defaultSearchColumnsSimple,defaultSearchColumnsTitle,defaultSearchMisrDetailsMediaColumns,versionCreationSettings,associate.advanced_search.version.setups,associate.advanced_search.media.setups,associate.wfrise.setups,supplier_portal.advanced_search.version.setups,media_portal.del_history.advanced.search_criteria,supplier_portal.version_complete.setups,logoImage,uploadSettings,helpdeskUrl,customLabels,googleMapsApiSettings&globals=isDebugMode,htmlplayerhotkeys,versionCreationSettings,associate.advanced_search.version.setups,associate.advanced_search.media.setups,associate.wfrise.setups,supplier_portal.advanced_search.version.setups,media_portal.del_history.advanced.search_criteria,helpdeskUrl,customLabels&_dc=1698766009192'
t Transfer: 1220 :     12|15:26:48.5138|Dp7V5Q|DANIEL|OAuth: /api/user-preferences?keys=personal_settings;basket;default_page;color_schema;media.basket.data;defaultSearch;workflow_queues_actions;workflow_queues_settings&_dc=1698766009285
t Transfer: 1220 :     12|15:26:48.5138|Dp7V5Q|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|15:26:48.5138|Dp7V5Q|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|15:26:48.5138|Dp7V5Q|DANIEL|    user DANIEL.
t Verbose: 1220 :      12|15:26:48.5138|Dp7V5Q|DANIEL|OAuth. User logged in: DANIEL
t Information: 1220 :  12|15:26:48.5138|Dp7V5Q|DANIEL|GetUserDataByKeys: personal_settings;basket;default_page;color_schema;media.basket.data;defaultSearch;workflow_queues_actions;workflow_queues_settings
t Transfer: 1220 :     12|15:26:48.5138|Dp7V5Q|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|15:26:48.5138|Dp7V5Q|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|15:26:48.5138|Dp7V5Q|DANIEL|    user DANIEL.
t Verbose: 1220 :      12|15:26:48.7169|Dp7V5Q|DANIEL|imfx v3 API took 0.044s '/api/user-preferences?keys=personal_settings;basket;default_page;color_schema;media.basket.data;defaultSearch;workflow_queues_actions;workflow_queues_settings&_dc=1698766009285'
t Information: 1220 :  12|15:26:48.7169|7m0g8w|DANIEL|GetUserProfile. Id: 0
t Transfer: 1220 :     12|15:26:48.7169|7m0g8w|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|15:26:48.7169|7m0g8w|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|15:26:48.7169|7m0g8w|DANIEL|    user DANIEL.
t Transfer: 1220 :     12|15:26:48.7169|yuDqSM|DANIEL|OAuth: /api/settings/group/0?_dc=1698766009511
t Transfer: 1220 :     12|15:26:48.7169|yuDqSM|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|15:26:48.7169|yuDqSM|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|15:26:48.7169|yuDqSM|DANIEL|    user DANIEL.
t Verbose: 1220 :      12|15:26:48.7169|yuDqSM|DANIEL|OAuth. User logged in: DANIEL
t Transfer: 1220 :     12|15:26:48.9200|VnXBAj|DANIEL|OAuth: /api/settings/user/mainMenuSettings?_dc=1698766009513
t Transfer: 1220 :     12|15:26:48.9200|VnXBAj|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|15:26:48.9200|VnXBAj|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|15:26:48.9200|VnXBAj|DANIEL|    user DANIEL.
t Verbose: 1220 :      12|15:26:48.9200|VnXBAj|DANIEL|OAuth. User logged in: DANIEL
t Transfer: 1220 :     12|15:26:48.9200|s_Pg2I|DANIEL|OAuth: /api/settings/user/uploadSettings?_dc=1698766009515
t Transfer: 1220 :     12|15:26:48.9200|s_Pg2I|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|15:26:48.9200|s_Pg2I|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|15:26:48.9200|s_Pg2I|DANIEL|    user DANIEL.
t Verbose: 1220 :      12|15:26:48.9200|s_Pg2I|DANIEL|OAuth. User logged in: DANIEL
t Transfer: 1220 :     12|15:26:48.9200|s_Pg2I|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|15:26:48.9200|s_Pg2I|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|15:26:48.9200|s_Pg2I|DANIEL|    user DANIEL.
t Transfer: 1220 :     12|15:26:48.9200|VnXBAj|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|15:26:48.9200|VnXBAj|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|15:26:48.9200|VnXBAj|DANIEL|    user DANIEL.
t Transfer: 1220 :     12|15:26:48.9200|6io6Tz|DANIEL|OAuth: /api/settings/group/0?_dc=1698766009532
t Transfer: 1220 :     12|15:26:48.9200|6io6Tz|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|15:26:48.9200|6io6Tz|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|15:26:48.9200|6io6Tz|DANIEL|    user DANIEL.
t Verbose: 1220 :      12|15:26:48.9200|6io6Tz|DANIEL|OAuth. User logged in: DANIEL
t Verbose: 1220 :      12|15:26:48.9200|s_Pg2I|DANIEL|imfx v3 API took 0.011s '/api/settings/user/uploadSettings?_dc=1698766009515'
t Verbose: 1220 :      12|15:26:48.9200|VnXBAj|DANIEL|imfx v3 API took 0.014s '/api/settings/user/mainMenuSettings?_dc=1698766009513'
t Transfer: 1220 :     12|15:26:48.9200|KXT2ub|DANIEL|OAuth: /api/settings/user/mainMenuSettings?_dc=1698766009532
t Transfer: 1220 :     12|15:26:48.9200|KXT2ub|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|15:26:48.9200|KXT2ub|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|15:26:48.9200|KXT2ub|DANIEL|    user DANIEL.
t Verbose: 1220 :      12|15:26:48.9200|KXT2ub|DANIEL|OAuth. User logged in: DANIEL
t Transfer: 1220 :     12|15:26:48.9200|85wQKt|DANIEL|OAuth: /api/lookups/MediaStatus?_dc=1698766009543
t Transfer: 1220 :     12|15:26:48.9200|85wQKt|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|15:26:48.9200|85wQKt|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|15:26:48.9200|85wQKt|DANIEL|    user DANIEL.
t Verbose: 1220 :      12|15:26:48.9200|85wQKt|DANIEL|OAuth. User logged in: DANIEL
t Transfer: 1220 :     12|15:26:48.9200|V2ePdW|DANIEL|OAuth: /api/lookups/PgmStatus?_dc=1698766009543
t Transfer: 1220 :     12|15:26:48.9200|V2ePdW|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|15:26:48.9200|V2ePdW|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|15:26:48.9200|V2ePdW|DANIEL|    user DANIEL.
t Verbose: 1220 :      12|15:26:48.9200|V2ePdW|DANIEL|OAuth. User logged in: DANIEL
t Information: 1220 :  12|15:26:48.9200|KrmzoL||GetCache.
t Information: 1220 :  12|15:26:48.9200|KrmzoL||GetCache. Found: C:\inetpub\wwwroot\imfxcore\VisualAssetsCache\107_1_PnqJC_.png
t Information: 1220 :  12|15:26:48.9200|KrmzoL||GetCache. Data read: 0
t Verbose: 1220 :      12|15:26:48.9200|KrmzoL||imfx v3 API took 0.097s '/api/v3/visual-asset/group/PnqJC_/1/image'
t Transfer: 1220 :     12|15:26:48.9200|1RkjMI|DANIEL|OAuth: /api/lookup/CustomMediaStatusTypes?_dc=1698766009544
t Transfer: 1220 :     12|15:26:48.9200|1RkjMI|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|15:26:48.9200|1RkjMI|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|15:26:48.9200|1RkjMI|DANIEL|    user DANIEL.
t Verbose: 1220 :      12|15:26:48.9200|1RkjMI|DANIEL|OAuth. User logged in: DANIEL
t Transfer: 1220 :     12|15:26:48.9200|KXT2ub|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|15:26:48.9200|KXT2ub|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|15:26:48.9200|KXT2ub|DANIEL|    user DANIEL.
t Verbose: 1220 :      12|15:26:48.9200|V2ePdW|DANIEL|imfx v3 API took 0.032s '/api/lookups/PgmStatus?_dc=1698766009543'
t Verbose: 1220 :      12|15:26:48.9200|85wQKt|DANIEL|imfx v3 API took 0.035s '/api/lookups/MediaStatus?_dc=1698766009543'
t Transfer: 1220 :     12|15:26:49.1388|A~6tkj|DANIEL|OAuth: /api/lookup/CustomVersionStatusTypes?_dc=1698766009545
t Transfer: 1220 :     12|15:26:49.1388|YPLZre|DANIEL|OAuth: /api/lookup/CustomTitleStatusTypes?_dc=1698766009547
t Transfer: 1220 :     12|15:26:49.1388|YPLZre|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|15:26:49.1388|A~6tkj|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|15:26:49.1388|A~6tkj|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|15:26:49.1388|YPLZre|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|15:26:49.1388|YPLZre|DANIEL|    user DANIEL.
t Transfer: 1220 :     12|15:26:49.1388|A~6tkj|DANIEL|    user DANIEL.
t Verbose: 1220 :      12|15:26:49.1388|A~6tkj|DANIEL|OAuth. User logged in: DANIEL
t Verbose: 1220 :      12|15:26:49.1388|YPLZre|DANIEL|OAuth. User logged in: DANIEL
t Verbose: 1220 :      12|15:26:49.1388|KXT2ub|DANIEL|imfx v3 API took 0.083s '/api/settings/user/mainMenuSettings?_dc=1698766009532'
t Transfer: 1220 :     12|15:26:49.1388|GpgnYy|DANIEL|OAuth: /api/settings/user/defaultHomePage?_dc=1698766009548
t Transfer: 1220 :     12|15:26:49.1388|GpgnYy|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|15:26:49.1388|GpgnYy|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|15:26:49.1388|GpgnYy|DANIEL|    user DANIEL.
t Verbose: 1220 :      12|15:26:49.1388|GpgnYy|DANIEL|OAuth. User logged in: DANIEL
t Transfer: 1220 :     12|15:26:49.1388|GpgnYy|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|15:26:49.1388|GpgnYy|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|15:26:49.1388|GpgnYy|DANIEL|    user DANIEL.
t Verbose: 1220 :      12|15:26:49.1388|A~6tkj|DANIEL|imfx v3 API took 0.142s '/api/lookup/CustomVersionStatusTypes?_dc=1698766009545'
t Verbose: 1220 :      12|15:26:49.3419|YPLZre|DANIEL|imfx v3 API took 0.029s '/api/lookup/CustomTitleStatusTypes?_dc=1698766009547'
t Verbose: 1220 :      12|15:26:49.3419|1RkjMI|DANIEL|imfx v3 API took 0.177s '/api/lookup/CustomMediaStatusTypes?_dc=1698766009544'
t Verbose: 1220 :      12|15:26:49.3419|GpgnYy|DANIEL|imfx v3 API took 0.052s '/api/settings/user/defaultHomePage?_dc=1698766009548'
t Verbose: 1220 :      12|15:26:49.3419|6io6Tz|DANIEL|imfx v3 API took 0.341s '/api/settings/group/0?_dc=1698766009532'
t Verbose: 1220 :      12|15:26:49.3419|yuDqSM|DANIEL|imfx v3 API took 0.442s '/api/settings/group/0?_dc=1698766009511'
t Transfer: 1220 :     12|15:26:49.5450|NvXuUm|DANIEL|OAuth: /api/settings/user/consumer?_dc=1698766010247
t Transfer: 1220 :     12|15:26:49.5450|NvXuUm|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|15:26:49.5450|NvXuUm|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|15:26:49.5450|NvXuUm|DANIEL|    user DANIEL.
t Verbose: 1220 :      12|15:26:49.5450|NvXuUm|DANIEL|OAuth. User logged in: DANIEL
t Transfer: 1220 :     12|15:26:49.5450|NvXuUm|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|15:26:49.5450|NvXuUm|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|15:26:49.5450|NvXuUm|DANIEL|    user DANIEL.
t Verbose: 1220 :      12|15:26:49.5450|NvXuUm|DANIEL|imfx v3 API took 0.010s '/api/settings/user/consumer?_dc=1698766010247'
t Transfer: 1220 :     12|15:26:49.5450|gh5I51|DANIEL|OAuth: /api/user-preferences?keys=consumer.recent.data&_dc=1698766010283
t Transfer: 1220 :     12|15:26:49.5450|gh5I51|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|15:26:49.5450|gh5I51|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|15:26:49.5450|gh5I51|DANIEL|    user DANIEL.
t Verbose: 1220 :      12|15:26:49.5450|gh5I51|DANIEL|OAuth. User logged in: DANIEL
t Information: 1220 :  12|15:26:49.5450|gh5I51|DANIEL|GetUserDataByKeys: consumer.recent.data
t Transfer: 1220 :     12|15:26:49.5450|gh5I51|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|15:26:49.5450|gh5I51|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|15:26:49.5450|gh5I51|DANIEL|    user DANIEL.
t Verbose: 1220 :      12|15:26:49.5450|gh5I51|DANIEL|imfx v3 API took 0.009s '/api/user-preferences?keys=consumer.recent.data&_dc=1698766010283'
t Transfer: 1220 :     12|15:26:49.7481|FbABtu|DANIEL|OAuth: /api/settings/user/defaultSearch?_dc=1698766010395
t Transfer: 1220 :     12|15:26:49.7481|FbABtu|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|15:26:49.7481|FbABtu|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|15:26:49.7481|FbABtu|DANIEL|    user DANIEL.
t Verbose: 1220 :      12|15:26:49.7481|FbABtu|DANIEL|OAuth. User logged in: DANIEL
t Transfer: 1220 :     12|15:26:49.7481|FbABtu|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|15:26:49.7481|FbABtu|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|15:26:49.7481|FbABtu|DANIEL|    user DANIEL.
t Transfer: 1220 :     12|15:26:49.7481|VGLCsw|DANIEL|OAuth: /api/settings/user/startSearch?_dc=1698766010396
t Transfer: 1220 :     12|15:26:49.7481|VGLCsw|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|15:26:49.7481|VGLCsw|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|15:26:49.7481|VGLCsw|DANIEL|    user DANIEL.
t Verbose: 1220 :      12|15:26:49.7481|VGLCsw|DANIEL|OAuth. User logged in: DANIEL
t Transfer: 1220 :     12|15:26:49.7481|VGLCsw|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|15:26:49.7481|VGLCsw|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|15:26:49.7481|VGLCsw|DANIEL|    user DANIEL.
t Verbose: 1220 :      12|15:26:49.7481|FbABtu|DANIEL|imfx v3 API took 0.008s '/api/settings/user/defaultSearch?_dc=1698766010395'
t Verbose: 1220 :      12|15:26:49.7481|VGLCsw|DANIEL|imfx v3 API took 0.009s '/api/settings/user/startSearch?_dc=1698766010396'
t Transfer: 1220 :     12|15:26:49.9512|YxB~8o|DANIEL|OAuth: /api/user-preferences?keys=consumer.recent.data&_dc=1698766010595
t Transfer: 1220 :     12|15:26:49.9512|YxB~8o|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|15:26:49.9512|YxB~8o|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|15:26:49.9512|YxB~8o|DANIEL|    user DANIEL.
t Verbose: 1220 :      12|15:26:49.9512|YxB~8o|DANIEL|OAuth. User logged in: DANIEL
t Information: 1220 :  12|15:26:49.9512|YxB~8o|DANIEL|GetUserDataByKeys: consumer.recent.data
t Transfer: 1220 :     12|15:26:49.9512|YxB~8o|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|15:26:49.9512|YxB~8o|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|15:26:49.9512|YxB~8o|DANIEL|    user DANIEL.
t Verbose: 1220 :      12|15:26:49.9512|YxB~8o|DANIEL|imfx v3 API took 0.005s '/api/user-preferences?keys=consumer.recent.data&_dc=1698766010595'
t Information: 1220 :  12|15:26:49.9512|qFunMS||GetCache.
t Information: 1220 :  12|15:26:49.9512|qFunMS||GetCache. Found: C:\inetpub\wwwroot\imfxcore\VisualAssetsCache\109_3_PnqJC_.png
t Information: 1220 :  12|15:26:49.9512|qFunMS||GetCache. Data read: 154944
t Verbose: 1220 :      12|15:26:49.9512|qFunMS||imfx v3 API took 0.004s '/api/v3/visual-asset/group/PnqJC_/3/image'
t Transfer: 1220 :     12|15:26:57.3153|V5xmII|DANIEL|OAuth: /api/view/searchinfo/Media?_dc=1698766018087
t Transfer: 1220 :     12|15:26:57.3153|V5xmII|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|15:26:57.3153|V5xmII|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|15:26:57.3153|V5xmII|DANIEL|    user DANIEL.
t Verbose: 1220 :      12|15:26:57.3153|V5xmII|DANIEL|OAuth. User logged in: DANIEL
t Transfer: 1220 :     12|15:26:57.3153|cA2bMY|DANIEL|OAuth: /api/lookups/SearchSupportedOperators?_dc=1698766018088
t Transfer: 1220 :     12|15:26:57.3153|cA2bMY|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|15:26:57.3153|cA2bMY|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|15:26:57.3153|cA2bMY|DANIEL|    user DANIEL.
t Verbose: 1220 :      12|15:26:57.3153|cA2bMY|DANIEL|OAuth. User logged in: DANIEL
t Transfer: 1220 :     12|15:26:57.3153|ah_HTq|DANIEL|OAuth: /api/user-preferences?keys=adv.recent.searches.media&_dc=1698766018089
t Transfer: 1220 :     12|15:26:57.3153|ah_HTq|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|15:26:57.3153|ah_HTq|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|15:26:57.3153|ah_HTq|DANIEL|    user DANIEL.
t Verbose: 1220 :      12|15:26:57.3153|ah_HTq|DANIEL|OAuth. User logged in: DANIEL
t Information: 1220 :  12|15:26:57.3153|ah_HTq|DANIEL|GetUserDataByKeys: adv.recent.searches.media
t Transfer: 1220 :     12|15:26:57.3153|ah_HTq|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|15:26:57.3153|ah_HTq|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|15:26:57.3153|ah_HTq|DANIEL|    user DANIEL.
t Verbose: 1220 :      12|15:26:57.3153|cA2bMY|DANIEL|imfx v3 API took 0.000s '/api/lookups/SearchSupportedOperators?_dc=1698766018088'
t Information: 1220 :  12|15:26:57.3153|V5xmII|DANIEL|GetAdvSearchColumns. search type Media grid .
t Verbose: 1220 :      12|15:26:57.3153|V5xmII|DANIEL|imfx v3 API took 0.001s '/api/view/searchinfo/Media?_dc=1698766018087'
t Verbose: 1220 :      12|15:26:57.3153|ah_HTq|DANIEL|imfx v3 API took 0.009s '/api/user-preferences?keys=adv.recent.searches.media&_dc=1698766018089'
t Transfer: 1220 :     12|15:26:57.3153|8SFjRc|DANIEL|OAuth: /api/view/searches/Media?_dc=1698766018113
t Transfer: 1220 :     12|15:26:57.3153|8SFjRc|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|15:26:57.3153|8SFjRc|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|15:26:57.3153|8SFjRc|DANIEL|    user DANIEL.
t Verbose: 1220 :      12|15:26:57.3153|8SFjRc|DANIEL|OAuth. User logged in: DANIEL
t Information: 1220 :  12|15:26:57.3153|8SFjRc|DANIEL|GetSavedSearchNames. search type Media.
t Transfer: 1220 :     12|15:26:57.3153|8SFjRc|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|15:26:57.3153|8SFjRc|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|15:26:57.3153|8SFjRc|DANIEL|    user DANIEL.
t Transfer: 1220 :     12|15:26:57.3153|PA4IYd|DANIEL|OAuth: /api/view/info/MediaGrid?lang=en-GB&_dc=1698766018115
t Transfer: 1220 :     12|15:26:57.3153|PA4IYd|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|15:26:57.3153|PA4IYd|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|15:26:57.3153|PA4IYd|DANIEL|    user DANIEL.
t Verbose: 1220 :      12|15:26:57.3153|PA4IYd|DANIEL|OAuth. User logged in: DANIEL
t Information: 1220 :  12|15:26:57.5340|PA4IYd|DANIEL|GetGridViewBuilder. builder type MediaGrid.
t Transfer: 1220 :     12|15:26:57.5340|PA4IYd|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|15:26:57.5340|PA4IYd|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|15:26:57.5340|PA4IYd|DANIEL|    user DANIEL.
t Information: 1220 :  12|15:26:57.5340|PA4IYd|DANIEL|UserGridView. LoadView. ID 760, Name Default.
t Transfer: 1220 :     12|15:26:57.5340|PA4IYd|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|15:26:57.5340|PA4IYd|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|15:26:57.5340|PA4IYd|DANIEL|    user DANIEL.
t Transfer: 1220 :     12|15:26:57.5340|cFdvW3|DANIEL|OAuth: /api/settings/user/searchLayoutConfig?_dc=1698766018116
t Transfer: 1220 :     12|15:26:57.5340|cFdvW3|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|15:26:57.5340|cFdvW3|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|15:26:57.5340|cFdvW3|DANIEL|    user DANIEL.
t Verbose: 1220 :      12|15:26:57.5340|cFdvW3|DANIEL|OAuth. User logged in: DANIEL
t Transfer: 1220 :     12|15:26:57.5340|cFdvW3|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|15:26:57.5340|cFdvW3|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|15:26:57.5340|cFdvW3|DANIEL|    user DANIEL.
t Verbose: 1220 :      12|15:26:57.5340|cFdvW3|DANIEL|imfx v3 API took 0.008s '/api/settings/user/searchLayoutConfig?_dc=1698766018116'
t Transfer: 1220 :     12|15:26:57.5340|PA4IYd|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|15:26:57.5340|PA4IYd|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|15:26:57.5340|PA4IYd|DANIEL|    user DANIEL.
t Verbose: 1220 :      12|15:26:57.5340|8SFjRc|DANIEL|imfx v3 API took 0.087s '/api/view/searches/Media?_dc=1698766018113'
t Verbose: 1220 :      12|15:26:57.5340|PA4IYd|DANIEL|imfx v3 API took 0.100s '/api/view/info/MediaGrid?lang=en-GB&_dc=1698766018115'
t Transfer: 1220 :     12|15:27:20.9764|s3xcAC|DANIEL|OAuth: /api/lookups/AccessStatuses?_dc=1698766041744
t Transfer: 1220 :     12|15:27:20.9764|s3xcAC|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|15:27:20.9764|s3xcAC|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|15:27:20.9764|s3xcAC|DANIEL|    user DANIEL.
t Verbose: 1220 :      12|15:27:20.9764|s3xcAC|DANIEL|OAuth. User logged in: DANIEL
t Verbose: 1220 :      12|15:27:20.9764|s3xcAC|DANIEL|imfx v3 API took 0.000s '/api/lookups/AccessStatuses?_dc=1698766041744'
t Transfer: 1220 :     12|15:27:29.9534|P9uykW|DANIEL|OAuth: /api/lookups/MediaFileTypes?_dc=1698766050654
t Transfer: 1220 :     12|15:27:29.9534|P9uykW|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|15:27:29.9534|P9uykW|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|15:27:29.9534|P9uykW|DANIEL|    user DANIEL.
t Verbose: 1220 :      12|15:27:29.9534|P9uykW|DANIEL|OAuth. User logged in: DANIEL
t Verbose: 1220 :      12|15:27:29.9534|P9uykW|DANIEL|imfx v3 API took 0.000s '/api/lookups/MediaFileTypes?_dc=1698766050654'
t Transfer: 1220 :     12|15:27:32.8135|UOmUAs|DANIEL|OAuth: /api/v3/search/Media?_dc=1698766053519
t Transfer: 1220 :     12|15:27:32.8135|UOmUAs|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|15:27:32.8135|UOmUAs|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|15:27:32.8135|UOmUAs|DANIEL|    user DANIEL.
t Verbose: 1220 :      12|15:27:32.8135|UOmUAs|DANIEL|OAuth. User logged in: DANIEL
t Information: 1220 :  12|15:27:33.0181|UOmUAs|DANIEL|V3Api.SearchMedia
t Information: 1220 :  12|15:27:33.0184|UOmUAs|DANIEL|V3Api.SearchGeneric
t Transfer: 1220 :     12|15:27:33.0184|UOmUAs|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|15:27:33.0184|UOmUAs|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|15:27:33.0184|UOmUAs|DANIEL|    user DANIEL.
t Information: 1220 :  12|15:27:33.2276|UOmUAs|DANIEL|Running solr search: [q, ((((media_format:((1443))))) AND deleted_flag:(0) AND (owners:((VSHD) OR (VSE) OR (VS3) OR (VODS) OR (VHPO) OR (VEXE) OR (VEPL) OR (V4N) OR (V3H) OR (V1G) OR (TV6N) OR (TV3N) OR (TV1D) OR (T8LT) OR (T6LV) OR (T3LV) OR (DMY) OR (CENT) OR (03VT) OR (03SS) OR (03SE) OR (AMAY) OR (BBC) OR (SKY) OR (MED) OR (SFP1) OR (TMD) OR (HUB) OR (VNE) OR (TVPU) OR (PBOY) OR (CTCE) OR (03GO) OR (EST) OR (MTG) OR (NAA) OR (ATP) OR (ICCCTY) OR (ICCWCP) OR (ICCICC) OR (ITV) OR (SKYRUGUN) OR (SKYCRI) OR (VODD) OR (VEPO) OR (VEC) OR (TVSL) OR (TV8) OR (TV1N) OR (TV1K) OR (TV1F) OR (T6LT) OR (T3LT) OR (NVA) OR (KNL2) OR (DMF) OR (CTCB) OR (3PD) OR (03SK) OR (03HA) OR (EUROSPORT) OR (TVONE) OR (ICCCWC) OR (ICCU19CWC) OR (ICCWCL) OR (PSP) OR (SKYHORSE) OR (SFP2) OR (VODN) OR (VODF) OR (VNPO) OR (VHIS) OR (VEXR) OR (TVAE) OR (03SM) OR (TV1P) OR (TV1A) OR (RTR) OR (HDP2) OR (03VA) OR (03SN) OR (AECSD) OR (WCIU) OR (ICCTWT) OR (ICCCWL2) OR (BTS) OR (SKYGOLF) OR (ZTVS) OR (V1TZ) OR (TV6S) OR (TV5L) OR (TV2S) OR (DAVI) OR (3PLV) OR (03VL) OR (03VB) OR (03SY) OR (03SG) OR (03SB) OR (03OR) OR (03LI) OR (03JO) OR (03BO) OR (MBNS) OR (OSP) OR (ICCWTC) OR (PPL) OR (ANTV) OR (OUT) OR (SPG) OR (VSS) OR (VSAT) OR (VNHD) OR (VNC) OR (TV6H) OR (TV6E) OR (TV1C) OR (NICK) OR (HDP1) OR (HDC1) OR (DMA) OR (3\+ES) OR (TV10) OR (AECHD) OR (TECHM) OR (ICCWWC) OR (LMH) OR (SKYDART) OR (VS2) OR (TV1S) OR (SPTV) OR (LNT) OR (DTV) OR (CS) OR (TV3D) OR (03SC) OR (03NM) OR ("YLE TV1") OR (ICCWTT) OR (PMS) OR (VIVA) OR (BEDIG) OR (BT) OR (SKYFOOT) OR (VSG) OR (VSD2) OR (VSD) OR (VODE) OR (VNH) OR (TVPB) OR (TVDP) OR (TV3S) OR (AMC) OR (TV1E) OR (TV1B) OR (Play) OR (MM) OR (KNVA) OR (03UP) OR (03NO) OR (03NB) OR (03GD) OR (AL) OR (ICCWCCL) OR (PMH))))]
t Information: 1220 :  12|15:27:33.4394|UOmUAs|DANIEL|Solr query returned:  5 in 64ms
t Information: 1220 :  12|15:27:33.4394|UOmUAs|DANIEL|MediaSearch SQL:
--sqlFromPaging
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 in (1,110)),'') BARCODE,
    nvl(lnk.lib_loc_ext_id,0) lib_loc_ext_id, nvl(lnk.ctnr_loan_stat,0) ctnr_loan_status, nvl(lnk.ctnr_stat,0) ctnr_stat,
    nvl(t.text_data_path,'') THUMBSERVER, 
    nvl(t.text_data_filename,'') THUMBFILE,
    nvl(t.text_id,-1) THUMBID , 
    (SELECT SUBSTR( trim( replace (replace (
          LISTAGG(trim(tt.tags || ' ' || tt.notes), ' ') WITHIN GROUP (ORDER BY trim(tt.tags || ' ' || tt.notes)), chr (13), ''), chr (10), ' ')), 1, 150) z
            FROM tm_media_tagging tt
              WHERE link_guid = DFILE_LINK_GUID and rownum=1) TAGS_TEXT , 
    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 t.*,
     coalesce(t.primary_thumb_id, 
             (select v.primary_thumb_id from tm_pg_rl v where v.id=t.pgm_parent_id), 
             (select a.primary_thumb_id from tm_pg_abs a where a.id=t.pgm_abs_id), 
             (select a.primary_thumb_id from tm_pg_abs a where a.id=t.ser_abs_id), 
             (select a.primary_thumb_id from tm_pg_abs a where a.id=t.ser_abs2_id)
) primary_thumb_id2
    from (
                 --sqlSubSelect   
                 select s.*  from
                (select a.*, rownum rnum from
                    (select  --sqlFrom
m.*
      from tmddba.tm_mis m ,(select /*+ cardinality(4) */ rownum rn, column_value id from table(:ids)) ids 

--sqlWhere
where m.id = ids.id 
 order by ids.rn ) a where rownum <= 10000) s 
     where rnum >= 1) t ) 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 
    
     order by rnum 

t Information: 1220 :  12|15:27:33.8457|UOmUAs|DANIEL|    timing: 00:00:00.8284319
t Verbose: 1220 :      12|15:27:33.8457|UOmUAs|DANIEL|imfx v3 API took 0.847s '/api/v3/search/Media?_dc=1698766053519'
t Transfer: 1220 :     12|15:27:34.0488|UOmUAs|DANIEL|GetUrl. Storage |TEMP_UPLOAD| filename \\192.168.120.254\DemoFS\Digital Assets\TEMP_UPLOAD\1da09b0a-c38f-4343-addd-a2fd2bae4453\cjp.zip subfolder 1da09b0a-c38f-4343-addd-a2fd2bae4453\
t Transfer: 1220 :     12|15:27:34.0488|UOmUAs|DANIEL|  GetFileName result https://demo.tmd.tv/Temp Upload/cjp.zip
t Transfer: 1220 :     12|15:27:34.0488|UOmUAs|DANIEL|GetUrl. result https://demo.tmd.tv/Temp Upload/cjp.zip
t Transfer: 1220 :     12|15:27:34.0488|UOmUAs|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|15:27:34.0488|UOmUAs|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|15:27:34.0488|UOmUAs|DANIEL|    user DANIEL.
t Transfer: 1220 :     12|15:27:34.0488|UOmUAs|DANIEL|GetUrl. Storage |TEMP_UPLOAD| filename \\192.168.120.254\DemoFS\Digital Assets\TEMP_UPLOAD\ff269512-0a32-4852-acde-fa63e0b4920b\SA550004.zip subfolder ff269512-0a32-4852-acde-fa63e0b4920b\
t Transfer: 1220 :     12|15:27:34.0488|UOmUAs|DANIEL|  GetFileName result https://demo.tmd.tv/Temp Upload/SA550004.zip
t Transfer: 1220 :     12|15:27:34.0488|UOmUAs|DANIEL|GetUrl. result https://demo.tmd.tv/Temp Upload/SA550004.zip
t Transfer: 1220 :     12|15:27:34.0488|UOmUAs|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|15:27:34.0488|UOmUAs|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|15:27:34.0488|UOmUAs|DANIEL|    user DANIEL.
t Transfer: 1220 :     12|15:27:34.0488|UOmUAs|DANIEL|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\SA550004.zip subfolder 
t Transfer: 1220 :     12|15:27:34.0488|UOmUAs|DANIEL|  GetFileName result https://imfxv3tm.tmd.tv/VideoServer/SA550004.zip
t Transfer: 1220 :     12|15:27:34.0488|UOmUAs|DANIEL|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/SA550004.zip
t Transfer: 1220 :     12|15:27:34.0488|UOmUAs|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|15:27:34.0488|UOmUAs|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|15:27:34.0488|UOmUAs|DANIEL|    user DANIEL.
t Transfer: 1220 :     12|15:27:34.0488|1leKO8|DANIEL|OAuth: /api/user-preferences?_dc=1698766054853
t Transfer: 1220 :     12|15:27:34.0488|1leKO8|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|15:27:34.0488|1leKO8|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|15:27:34.0488|1leKO8|DANIEL|    user DANIEL.
t Verbose: 1220 :      12|15:27:34.0488|1leKO8|DANIEL|OAuth. User logged in: DANIEL
t Verbose: 1220 :      12|15:27:34.2675|1leKO8|DANIEL|StoreUserDataByKeys..
t Transfer: 1220 :     12|15:27:34.2675|1leKO8|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|15:27:34.2675|1leKO8|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|15:27:34.2675|1leKO8|DANIEL|    user DANIEL.
t Verbose: 1220 :      12|15:27:34.2675|1leKO8|DANIEL|imfx v3 API took 0.037s '/api/user-preferences?_dc=1698766054853'
t Transfer: 1220 :     12|15:28:07.3066|DLdQ~7|DANIEL|OAuth: /api/view/MediaGrid/860?_dc=1698766087884
t Transfer: 1220 :     12|15:28:07.3066|DLdQ~7|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|15:28:07.3066|DLdQ~7|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|15:28:07.3066|DLdQ~7|DANIEL|    user DANIEL.
t Verbose: 1220 :      12|15:28:07.3066|DLdQ~7|DANIEL|OAuth. User logged in: DANIEL
t Information: 1220 :  12|15:28:07.3066|DLdQ~7|DANIEL|UserGridView. LoadView. ID 860, Name .
t Transfer: 1220 :     12|15:28:07.3066|DLdQ~7|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|15:28:07.3066|DLdQ~7|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|15:28:07.3066|DLdQ~7|DANIEL|    user DANIEL.
t Verbose: 1220 :      12|15:28:07.3066|DLdQ~7|DANIEL|imfx v3 API took 0.004s '/api/view/MediaGrid/860?_dc=1698766087884'
t Transfer: 1220 :     12|15:28:20.1842|vgBXPQ|DANIEL|OAuth: /api/v3/search/Media?_dc=1698766100879
t Transfer: 1220 :     12|15:28:20.1842|vgBXPQ|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|15:28:20.1842|vgBXPQ|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|15:28:20.1842|vgBXPQ|DANIEL|    user DANIEL.
t Verbose: 1220 :      12|15:28:20.1842|vgBXPQ|DANIEL|OAuth. User logged in: DANIEL
t Transfer: 1220 :     12|15:28:20.1842|uXI3KH|DANIEL|OAuth: /api/view?_dc=1698766100881
t Transfer: 1220 :     12|15:28:20.1842|uXI3KH|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|15:28:20.1842|uXI3KH|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|15:28:20.1842|uXI3KH|DANIEL|    user DANIEL.
t Verbose: 1220 :      12|15:28:20.1842|uXI3KH|DANIEL|OAuth. User logged in: DANIEL
t Information: 1220 :  12|15:28:20.1842|vgBXPQ|DANIEL|V3Api.SearchMedia
t Information: 1220 :  12|15:28:20.1842|vgBXPQ|DANIEL|V3Api.SearchGeneric
t Transfer: 1220 :     12|15:28:20.1842|vgBXPQ|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|15:28:20.1842|vgBXPQ|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|15:28:20.1842|vgBXPQ|DANIEL|    user DANIEL.
t Information: 1220 :  12|15:28:20.1842|vgBXPQ|DANIEL|Running solr search: [q, ((((media_format:((1443))))) AND deleted_flag:(0) AND (owners:((VSHD) OR (VSE) OR (VS3) OR (VODS) OR (VHPO) OR (VEXE) OR (VEPL) OR (V4N) OR (V3H) OR (V1G) OR (TV6N) OR (TV3N) OR (TV1D) OR (T8LT) OR (T6LV) OR (T3LV) OR (DMY) OR (CENT) OR (03VT) OR (03SS) OR (03SE) OR (AMAY) OR (BBC) OR (SKY) OR (MED) OR (SFP1) OR (TMD) OR (HUB) OR (VNE) OR (TVPU) OR (PBOY) OR (CTCE) OR (03GO) OR (EST) OR (MTG) OR (NAA) OR (ATP) OR (ICCCTY) OR (ICCWCP) OR (ICCICC) OR (ITV) OR (SKYRUGUN) OR (SKYCRI) OR (VODD) OR (VEPO) OR (VEC) OR (TVSL) OR (TV8) OR (TV1N) OR (TV1K) OR (TV1F) OR (T6LT) OR (T3LT) OR (NVA) OR (KNL2) OR (DMF) OR (CTCB) OR (3PD) OR (03SK) OR (03HA) OR (EUROSPORT) OR (TVONE) OR (ICCCWC) OR (ICCU19CWC) OR (ICCWCL) OR (PSP) OR (SKYHORSE) OR (SFP2) OR (VODN) OR (VODF) OR (VNPO) OR (VHIS) OR (VEXR) OR (TVAE) OR (03SM) OR (TV1P) OR (TV1A) OR (RTR) OR (HDP2) OR (03VA) OR (03SN) OR (AECSD) OR (WCIU) OR (ICCTWT) OR (ICCCWL2) OR (BTS) OR (SKYGOLF) OR (ZTVS) OR (V1TZ) OR (TV6S) OR (TV5L) OR (TV2S) OR (DAVI) OR (3PLV) OR (03VL) OR (03VB) OR (03SY) OR (03SG) OR (03SB) OR (03OR) OR (03LI) OR (03JO) OR (03BO) OR (MBNS) OR (OSP) OR (ICCWTC) OR (PPL) OR (ANTV) OR (OUT) OR (SPG) OR (VSS) OR (VSAT) OR (VNHD) OR (VNC) OR (TV6H) OR (TV6E) OR (TV1C) OR (NICK) OR (HDP1) OR (HDC1) OR (DMA) OR (3\+ES) OR (TV10) OR (AECHD) OR (TECHM) OR (ICCWWC) OR (LMH) OR (SKYDART) OR (VS2) OR (TV1S) OR (SPTV) OR (LNT) OR (DTV) OR (CS) OR (TV3D) OR (03SC) OR (03NM) OR ("YLE TV1") OR (ICCWTT) OR (PMS) OR (VIVA) OR (BEDIG) OR (BT) OR (SKYFOOT) OR (VSG) OR (VSD2) OR (VSD) OR (VODE) OR (VNH) OR (TVPB) OR (TVDP) OR (TV3S) OR (AMC) OR (TV1E) OR (TV1B) OR (Play) OR (MM) OR (KNVA) OR (03UP) OR (03NO) OR (03NB) OR (03GD) OR (AL) OR (ICCWCCL) OR (PMH))))]
t Information: 1220 :  12|15:28:20.1842|uXI3KH|DANIEL|SaveUserView. name Ben's Media View.
t Verbose: 1220 :      12|15:28:20.1842|uXI3KH|DANIEL|imfx v3 API took 0.012s '/api/view?_dc=1698766100881'
t Information: 1220 :  12|15:28:20.1842|vgBXPQ|DANIEL|Solr query returned:  5 in 43ms
t Information: 1220 :  12|15:28:20.1842|vgBXPQ|DANIEL|MediaSearch SQL:
--sqlFromPaging
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 in (1,110)),'') BARCODE,
    nvl(lnk.lib_loc_ext_id,0) lib_loc_ext_id, nvl(lnk.ctnr_loan_stat,0) ctnr_loan_status, nvl(lnk.ctnr_stat,0) ctnr_stat,
    nvl(t.text_data_path,'') THUMBSERVER, 
    nvl(t.text_data_filename,'') THUMBFILE,
    nvl(t.text_id,-1) THUMBID , 
    (select t.name from TM_CFG_MI_FMT_TYP t where t.id = r.mi_fmt_type) ITEM_FORMAT_TEXT, 
    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 t.*,
     coalesce(t.primary_thumb_id, 
             (select v.primary_thumb_id from tm_pg_rl v where v.id=t.pgm_parent_id), 
             (select a.primary_thumb_id from tm_pg_abs a where a.id=t.pgm_abs_id), 
             (select a.primary_thumb_id from tm_pg_abs a where a.id=t.ser_abs_id), 
             (select a.primary_thumb_id from tm_pg_abs a where a.id=t.ser_abs2_id)
) primary_thumb_id2
    from (
                 --sqlSubSelect   
                 select s.*  from
                (select a.*, rownum rnum from
                    (select  --sqlFrom
m.*
      from tmddba.tm_mis m ,(select /*+ cardinality(4) */ rownum rn, column_value id from table(:ids)) ids 

--sqlWhere
where m.id = ids.id 
 order by ids.rn ) a where rownum <= 10000) s 
     where rnum >= 1) t ) 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 
    
     order by rnum 

t Transfer: 1220 :     12|15:28:20.3872|jRQ_o9|DANIEL|OAuth: /api/view/info/MediaGrid?lang=en-GB&_dc=1698766100979
t Transfer: 1220 :     12|15:28:20.3872|jRQ_o9|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|15:28:20.3872|jRQ_o9|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|15:28:20.3872|jRQ_o9|DANIEL|    user DANIEL.
t Verbose: 1220 :      12|15:28:20.3872|jRQ_o9|DANIEL|OAuth. User logged in: DANIEL
t Information: 1220 :  12|15:28:20.3872|jRQ_o9|DANIEL|GetGridViewBuilder. builder type MediaGrid.
t Transfer: 1220 :     12|15:28:20.3872|jRQ_o9|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|15:28:20.3872|jRQ_o9|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|15:28:20.3872|jRQ_o9|DANIEL|    user DANIEL.
t Information: 1220 :  12|15:28:20.3872|jRQ_o9|DANIEL|UserGridView. LoadView. ID 760, Name Default.
t Transfer: 1220 :     12|15:28:20.3872|jRQ_o9|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|15:28:20.3872|jRQ_o9|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|15:28:20.3872|jRQ_o9|DANIEL|    user DANIEL.
t Transfer: 1220 :     12|15:28:20.3872|jRQ_o9|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|15:28:20.3872|jRQ_o9|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|15:28:20.3872|jRQ_o9|DANIEL|    user DANIEL.
t Verbose: 1220 :      12|15:28:20.3872|jRQ_o9|DANIEL|imfx v3 API took 0.008s '/api/view/info/MediaGrid?lang=en-GB&_dc=1698766100979'
t Information: 1220 :  12|15:28:20.3872|vgBXPQ|DANIEL|    timing: 00:00:00.1592105
t Verbose: 1220 :      12|15:28:20.3872|vgBXPQ|DANIEL|imfx v3 API took 0.159s '/api/v3/search/Media?_dc=1698766100879'
t Transfer: 1220 :     12|15:28:20.3872|vgBXPQ|DANIEL|GetUrl. Storage |TEMP_UPLOAD| filename \\192.168.120.254\DemoFS\Digital Assets\TEMP_UPLOAD\1da09b0a-c38f-4343-addd-a2fd2bae4453\cjp.zip subfolder 1da09b0a-c38f-4343-addd-a2fd2bae4453\
t Transfer: 1220 :     12|15:28:20.3872|vgBXPQ|DANIEL|  GetFileName result https://demo.tmd.tv/Temp Upload/cjp.zip
t Transfer: 1220 :     12|15:28:20.3872|vgBXPQ|DANIEL|GetUrl. result https://demo.tmd.tv/Temp Upload/cjp.zip
t Transfer: 1220 :     12|15:28:20.3872|vgBXPQ|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|15:28:20.3872|vgBXPQ|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|15:28:20.3872|vgBXPQ|DANIEL|    user DANIEL.
t Transfer: 1220 :     12|15:28:20.3872|vgBXPQ|DANIEL|GetUrl. Storage |TEMP_UPLOAD| filename \\192.168.120.254\DemoFS\Digital Assets\TEMP_UPLOAD\ff269512-0a32-4852-acde-fa63e0b4920b\SA550004.zip subfolder ff269512-0a32-4852-acde-fa63e0b4920b\
t Transfer: 1220 :     12|15:28:20.3872|vgBXPQ|DANIEL|  GetFileName result https://demo.tmd.tv/Temp Upload/SA550004.zip
t Transfer: 1220 :     12|15:28:20.3872|vgBXPQ|DANIEL|GetUrl. result https://demo.tmd.tv/Temp Upload/SA550004.zip
t Transfer: 1220 :     12|15:28:20.3872|vgBXPQ|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|15:28:20.3872|vgBXPQ|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|15:28:20.3872|vgBXPQ|DANIEL|    user DANIEL.
t Transfer: 1220 :     12|15:28:20.3872|vgBXPQ|DANIEL|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\SA550004.zip subfolder 
t Transfer: 1220 :     12|15:28:20.3872|vgBXPQ|DANIEL|  GetFileName result https://imfxv3tm.tmd.tv/VideoServer/SA550004.zip
t Transfer: 1220 :     12|15:28:20.3872|vgBXPQ|DANIEL|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/SA550004.zip
t Transfer: 1220 :     12|15:28:20.3872|vgBXPQ|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|15:28:20.3872|vgBXPQ|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|15:28:20.3872|vgBXPQ|DANIEL|    user DANIEL.
t Transfer: 1220 :     12|15:28:20.3872|r94muk|DANIEL|OAuth: /api/user-preferences?_dc=1698766101086
t Transfer: 1220 :     12|15:28:20.3872|r94muk|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|15:28:20.3872|r94muk|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|15:28:20.3872|r94muk|DANIEL|    user DANIEL.
t Verbose: 1220 :      12|15:28:20.3872|r94muk|DANIEL|OAuth. User logged in: DANIEL
t Verbose: 1220 :      12|15:28:20.3872|r94muk|DANIEL|StoreUserDataByKeys..
t Transfer: 1220 :     12|15:28:20.3872|r94muk|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|15:28:20.3872|r94muk|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|15:28:20.3872|r94muk|DANIEL|    user DANIEL.
t Verbose: 1220 :      12|15:28:20.3872|r94muk|DANIEL|imfx v3 API took 0.013s '/api/user-preferences?_dc=1698766101086'
t Transfer: 1220 :     12|15:31:12.2693|Kx~N_e|DANIEL|OAuth: /api/v3/config/servicexml/types?_dc=1698766272913
t Transfer: 1220 :     12|15:31:12.2693|Kx~N_e|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|15:31:12.2693|Kx~N_e|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|15:31:12.2693|Kx~N_e|DANIEL|    user DANIEL.
t Verbose: 1220 :      12|15:31:12.2693|Kx~N_e|DANIEL|OAuth. User logged in: DANIEL
t Verbose: 1220 :      12|15:31:12.2693|Kx~N_e|DANIEL|imfx v3 API took 0.016s '/api/v3/config/servicexml/types?_dc=1698766272913'
t Transfer: 1220 :     12|15:31:12.2693|_yRObx|DANIEL|OAuth: /api/settings/groups/?_dc=1698766272960
t Transfer: 1220 :     12|15:31:12.2693|_yRObx|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|15:31:12.2693|_yRObx|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|15:31:12.2693|_yRObx|DANIEL|    user DANIEL.
t Verbose: 1220 :      12|15:31:12.2693|_yRObx|DANIEL|OAuth. User logged in: DANIEL
t Verbose: 1220 :      12|15:31:12.2693|_yRObx|DANIEL|imfx v3 API took 0.026s '/api/settings/groups/?_dc=1698766272960'
t Transfer: 1220 :     12|15:31:18.9927|ieXUZq|DANIEL|OAuth: /api/v3/config-tables?_dc=1698766279739
t Transfer: 1220 :     12|15:31:18.9927|ieXUZq|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|15:31:18.9927|ieXUZq|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|15:31:18.9927|ieXUZq|DANIEL|    user DANIEL.
t Verbose: 1220 :      12|15:31:18.9927|ieXUZq|DANIEL|OAuth. User logged in: DANIEL
t Verbose: 1220 :      12|15:31:18.9927|ieXUZq|DANIEL|imfx v3 API took 0.004s '/api/v3/config-tables?_dc=1698766279739'
t Information: 1220 :  12|15:31:26.1315|39mR8q|DANIEL|GetConfig TM_CFG_MI_FMT_TYP.
t Verbose: 1220 :      12|15:31:26.3346|39mR8q|DANIEL|imfx v3 API took 0.271s '/api/v3/config-table/TM_CFG_MI_FMT_TYP?_dc=1698766286719'
t Transfer: 1220 :     12|15:31:52.4743|k47TVL|DANIEL|OAuth: /api/settings/user/startSearch?_dc=1698766313070
t Transfer: 1220 :     12|15:31:52.4743|k47TVL|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|15:31:52.4743|k47TVL|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|15:31:52.4743|k47TVL|DANIEL|    user DANIEL.
t Verbose: 1220 :      12|15:31:52.4743|k47TVL|DANIEL|OAuth. User logged in: DANIEL
t Transfer: 1220 :     12|15:31:52.4743|6wOMFs|DANIEL|OAuth: /api/settings/user/defaultSearch?_dc=1698766313068
t Transfer: 1220 :     12|15:31:52.4743|6wOMFs|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|15:31:52.4743|6wOMFs|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|15:31:52.4743|6wOMFs|DANIEL|    user DANIEL.
t Verbose: 1220 :      12|15:31:52.4743|6wOMFs|DANIEL|OAuth. User logged in: DANIEL
t Transfer: 1220 :     12|15:31:52.4743|k47TVL|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|15:31:52.4743|k47TVL|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|15:31:52.4743|k47TVL|DANIEL|    user DANIEL.
t Verbose: 1220 :      12|15:31:52.4743|k47TVL|DANIEL|imfx v3 API took 0.077s '/api/settings/user/startSearch?_dc=1698766313070'
t Transfer: 1220 :     12|15:31:52.4743|6wOMFs|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|15:31:52.4743|6wOMFs|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|15:31:52.4743|6wOMFs|DANIEL|    user DANIEL.
t Verbose: 1220 :      12|15:31:52.4743|6wOMFs|DANIEL|imfx v3 API took 0.003s '/api/settings/user/defaultSearch?_dc=1698766313068'
t Transfer: 1220 :     12|15:31:52.4743|AV_QCw|DANIEL|OAuth: /api/user-preferences?keys=consumer.recent.data&_dc=1698766313246
t Transfer: 1220 :     12|15:31:52.4743|AV_QCw|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|15:31:52.4743|AV_QCw|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|15:31:52.4743|AV_QCw|DANIEL|    user DANIEL.
t Verbose: 1220 :      12|15:31:52.4743|AV_QCw|DANIEL|OAuth. User logged in: DANIEL
t Information: 1220 :  12|15:31:52.4743|AV_QCw|DANIEL|GetUserDataByKeys: consumer.recent.data
t Transfer: 1220 :     12|15:31:52.4743|AV_QCw|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|15:31:52.4743|AV_QCw|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|15:31:52.4743|AV_QCw|DANIEL|    user DANIEL.
t Verbose: 1220 :      12|15:31:52.4743|J0yi7l||imfx v3 API took 0.004s '/api/v3/visual-asset/group/PnqJC_/3/image'
t Verbose: 1220 :      12|15:31:52.4743|AV_QCw|DANIEL|imfx v3 API took 0.005s '/api/user-preferences?keys=consumer.recent.data&_dc=1698766313246'
t Transfer: 1220 :     12|15:31:52.6931|J5RKkv|DANIEL|OAuth: /api/user-preferences?keys=adv.recent.searches.consumer&_dc=1698766313248
t Transfer: 1220 :     12|15:31:52.6931|J5RKkv|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|15:31:52.6931|J5RKkv|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|15:31:52.6931|J5RKkv|DANIEL|    user DANIEL.
t Verbose: 1220 :      12|15:31:52.6931|J5RKkv|DANIEL|OAuth. User logged in: DANIEL
t Information: 1220 :  12|15:31:52.6931|J5RKkv|DANIEL|GetUserDataByKeys: adv.recent.searches.consumer
t Transfer: 1220 :     12|15:31:52.6931|J5RKkv|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|15:31:52.6931|J5RKkv|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|15:31:52.6931|J5RKkv|DANIEL|    user DANIEL.
t Verbose: 1220 :      12|15:31:52.6931|J5RKkv|DANIEL|imfx v3 API took 0.004s '/api/user-preferences?keys=adv.recent.searches.consumer&_dc=1698766313248'
t Transfer: 1220 :     12|15:31:55.1504|Itp9cV|DANIEL|OAuth: /api/v3/search/Media?_dc=1698766315909
t Transfer: 1220 :     12|15:31:55.1504|Itp9cV|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|15:31:55.1504|Itp9cV|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|15:31:55.1504|Itp9cV|DANIEL|    user DANIEL.
t Verbose: 1220 :      12|15:31:55.1504|Itp9cV|DANIEL|OAuth. User logged in: DANIEL
t Information: 1220 :  12|15:31:55.1504|Itp9cV|DANIEL|V3Api.SearchMedia
t Information: 1220 :  12|15:31:55.1504|Itp9cV|DANIEL|V3Api.SearchGeneric
t Transfer: 1220 :     12|15:31:55.3536|Itp9cV|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|15:31:55.3536|Itp9cV|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|15:31:55.3536|Itp9cV|DANIEL|    user DANIEL.
t Information: 1220 :  12|15:31:55.3536|Itp9cV|DANIEL|MediaSearch SQL:
--sqlFromPaging
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 in (1,110)),'') BARCODE,
    nvl(lnk.lib_loc_ext_id,0) lib_loc_ext_id, nvl(lnk.ctnr_loan_stat,0) ctnr_loan_status, nvl(lnk.ctnr_stat,0) ctnr_stat,
    nvl(t.text_data_path,'') THUMBSERVER, 
    nvl(t.text_data_filename,'') THUMBFILE,
    nvl(t.text_id,-1) THUMBID , 
    (select t.name from TM_CFG_MI_FMT_TYP t where t.id = r.mi_fmt_type) ITEM_FORMAT_TEXT, 
    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 t.*,
     coalesce(t.primary_thumb_id, 
             (select v.primary_thumb_id from tm_pg_rl v where v.id=t.pgm_parent_id), 
             (select a.primary_thumb_id from tm_pg_abs a where a.id=t.pgm_abs_id), 
             (select a.primary_thumb_id from tm_pg_abs a where a.id=t.ser_abs_id), 
             (select a.primary_thumb_id from tm_pg_abs a where a.id=t.ser_abs2_id)
) primary_thumb_id2
    from (
                 --sqlSubSelect   
                 select s.*  from
                (select a.*, rownum rnum from
                    (select  --sqlFrom
m.*
      from tmddba.tm_mis m 

--sqlWhere
where  media_type>0 and item_type>0  AND   m.ID = :param_0  and m.mi_deleted=0   AND (INSTR(m.OWNERS,'|VSHD|')>0 OR INSTR(m.OWNERS,'|VSE|')>0 OR INSTR(m.OWNERS,'|VS3|')>0 OR INSTR(m.OWNERS,'|VODS|')>0 OR INSTR(m.OWNERS,'|VHPO|')>0 OR INSTR(m.OWNERS,'|VEXE|')>0 OR INSTR(m.OWNERS,'|VEPL|')>0 OR INSTR(m.OWNERS,'|V4N|')>0 OR INSTR(m.OWNERS,'|V3H|')>0 OR INSTR(m.OWNERS,'|V1G|')>0 OR INSTR(m.OWNERS,'|TV6N|')>0 OR INSTR(m.OWNERS,'|TV3N|')>0 OR INSTR(m.OWNERS,'|TV1D|')>0 OR INSTR(m.OWNERS,'|T8LT|')>0 OR INSTR(m.OWNERS,'|T6LV|')>0 OR INSTR(m.OWNERS,'|T3LV|')>0 OR INSTR(m.OWNERS,'|DMY|')>0 OR INSTR(m.OWNERS,'|CENT|')>0 OR INSTR(m.OWNERS,'|03VT|')>0 OR INSTR(m.OWNERS,'|03SS|')>0 OR INSTR(m.OWNERS,'|03SE|')>0 OR INSTR(m.OWNERS,'|AMAY|')>0 OR INSTR(m.OWNERS,'|BBC|')>0 OR INSTR(m.OWNERS,'|SKY|')>0 OR INSTR(m.OWNERS,'|MED|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|TMD|')>0 OR INSTR(m.OWNERS,'|HUB|')>0 OR INSTR(m.OWNERS,'|VNE|')>0 OR INSTR(m.OWNERS,'|TVPU|')>0 OR INSTR(m.OWNERS,'|PBOY|')>0 OR INSTR(m.OWNERS,'|CTCE|')>0 OR INSTR(m.OWNERS,'|03GO|')>0 OR INSTR(m.OWNERS,'|EST|')>0 OR INSTR(m.OWNERS,'|MTG|')>0 OR INSTR(m.OWNERS,'|NAA|')>0 OR INSTR(m.OWNERS,'|ATP|')>0 OR INSTR(m.OWNERS,'|ICCCTY|')>0 OR INSTR(m.OWNERS,'|ICCWCP|')>0 OR INSTR(m.OWNERS,'|ICCICC|')>0 OR INSTR(m.OWNERS,'|ITV|')>0 OR INSTR(m.OWNERS,'|SKYRUGUN|')>0 OR INSTR(m.OWNERS,'|SKYCRI|')>0 OR INSTR(m.OWNERS,'|VODD|')>0 OR INSTR(m.OWNERS,'|VEPO|')>0 OR INSTR(m.OWNERS,'|VEC|')>0 OR INSTR(m.OWNERS,'|TVSL|')>0 OR INSTR(m.OWNERS,'|TV8|')>0 OR INSTR(m.OWNERS,'|TV1N|')>0 OR INSTR(m.OWNERS,'|TV1K|')>0 OR INSTR(m.OWNERS,'|TV1F|')>0 OR INSTR(m.OWNERS,'|T6LT|')>0 OR INSTR(m.OWNERS,'|T3LT|')>0 OR INSTR(m.OWNERS,'|NVA|')>0 OR INSTR(m.OWNERS,'|KNL2|')>0 OR INSTR(m.OWNERS,'|DMF|')>0 OR INSTR(m.OWNERS,'|CTCB|')>0 OR INSTR(m.OWNERS,'|3PD|')>0 OR INSTR(m.OWNERS,'|03SK|')>0 OR INSTR(m.OWNERS,'|03HA|')>0 OR INSTR(m.OWNERS,'|EUROSPORT|')>0 OR INSTR(m.OWNERS,'|TVONE|')>0 OR INSTR(m.OWNERS,'|ICCCWC|')>0 OR INSTR(m.OWNERS,'|ICCU19CWC|')>0 OR INSTR(m.OWNERS,'|ICCWCL|')>0 OR INSTR(m.OWNERS,'|PSP|')>0 OR INSTR(m.OWNERS,'|SKYHORSE|')>0 OR INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|VODN|')>0 OR INSTR(m.OWNERS,'|VODF|')>0 OR INSTR(m.OWNERS,'|VNPO|')>0 OR INSTR(m.OWNERS,'|VHIS|')>0 OR INSTR(m.OWNERS,'|VEXR|')>0 OR INSTR(m.OWNERS,'|TVAE|')>0 OR INSTR(m.OWNERS,'|03SM|')>0 OR INSTR(m.OWNERS,'|TV1P|')>0 OR INSTR(m.OWNERS,'|TV1A|')>0 OR INSTR(m.OWNERS,'|RTR|')>0 OR INSTR(m.OWNERS,'|HDP2|')>0 OR INSTR(m.OWNERS,'|03VA|')>0 OR INSTR(m.OWNERS,'|03SN|')>0 OR INSTR(m.OWNERS,'|AECSD|')>0 OR INSTR(m.OWNERS,'|WCIU|')>0 OR INSTR(m.OWNERS,'|ICCTWT|')>0 OR INSTR(m.OWNERS,'|ICCCWL2|')>0 OR INSTR(m.OWNERS,'|BTS|')>0 OR INSTR(m.OWNERS,'|SKYGOLF|')>0 OR INSTR(m.OWNERS,'|ZTVS|')>0 OR INSTR(m.OWNERS,'|V1TZ|')>0 OR INSTR(m.OWNERS,'|TV6S|')>0 OR INSTR(m.OWNERS,'|TV5L|')>0 OR INSTR(m.OWNERS,'|TV2S|')>0 OR INSTR(m.OWNERS,'|DAVI|')>0 OR INSTR(m.OWNERS,'|3PLV|')>0 OR INSTR(m.OWNERS,'|03VL|')>0 OR INSTR(m.OWNERS,'|03VB|')>0 OR INSTR(m.OWNERS,'|03SY|')>0 OR INSTR(m.OWNERS,'|03SG|')>0 OR INSTR(m.OWNERS,'|03SB|')>0 OR INSTR(m.OWNERS,'|03OR|')>0 OR INSTR(m.OWNERS,'|03LI|')>0 OR INSTR(m.OWNERS,'|03JO|')>0 OR INSTR(m.OWNERS,'|03BO|')>0 OR INSTR(m.OWNERS,'|MBNS|')>0 OR INSTR(m.OWNERS,'|OSP|')>0 OR INSTR(m.OWNERS,'|ICCWTC|')>0 OR INSTR(m.OWNERS,'|PPL|')>0 OR INSTR(m.OWNERS,'|ANTV|')>0 OR INSTR(m.OWNERS,'|OUT|')>0 OR INSTR(m.OWNERS,'|SPG|')>0 OR INSTR(m.OWNERS,'|VSS|')>0 OR INSTR(m.OWNERS,'|VSAT|')>0 OR INSTR(m.OWNERS,'|VNHD|')>0 OR INSTR(m.OWNERS,'|VNC|')>0 OR INSTR(m.OWNERS,'|TV6H|')>0 OR INSTR(m.OWNERS,'|TV6E|')>0 OR INSTR(m.OWNERS,'|TV1C|')>0 OR INSTR(m.OWNERS,'|NICK|')>0 OR INSTR(m.OWNERS,'|HDP1|')>0 OR INSTR(m.OWNERS,'|HDC1|')>0 OR INSTR(m.OWNERS,'|DMA|')>0 OR INSTR(m.OWNERS,'|3+ES|')>0 OR INSTR(m.OWNERS,'|TV10|')>0 OR INSTR(m.OWNERS,'|AECHD|')>0 OR INSTR(m.OWNERS,'|TECHM|')>0 OR INSTR(m.OWNERS,'|ICCWWC|')>0 OR INSTR(m.OWNERS,'|LMH|')>0 OR INSTR(m.OWNERS,'|SKYDART|')>0 OR INSTR(m.OWNERS,'|VS2|')>0 OR INSTR(m.OWNERS,'|TV1S|')>0 OR INSTR(m.OWNERS,'|SPTV|')>0 OR INSTR(m.OWNERS,'|LNT|')>0 OR INSTR(m.OWNERS,'|DTV|')>0 OR INSTR(m.OWNERS,'|CS|')>0 OR INSTR(m.OWNERS,'|TV3D|')>0 OR INSTR(m.OWNERS,'|03SC|')>0 OR INSTR(m.OWNERS,'|03NM|')>0 OR INSTR(m.OWNERS,'|YLE TV1|')>0 OR INSTR(m.OWNERS,'|ICCWTT|')>0 OR INSTR(m.OWNERS,'|PMS|')>0 OR INSTR(m.OWNERS,'|VIVA|')>0 OR INSTR(m.OWNERS,'|BEDIG|')>0 OR INSTR(m.OWNERS,'|BT|')>0 OR INSTR(m.OWNERS,'|SKYFOOT|')>0 OR INSTR(m.OWNERS,'|VSG|')>0 OR INSTR(m.OWNERS,'|VSD2|')>0 OR INSTR(m.OWNERS,'|VSD|')>0 OR INSTR(m.OWNERS,'|VODE|')>0 OR INSTR(m.OWNERS,'|VNH|')>0 OR INSTR(m.OWNERS,'|TVPB|')>0 OR INSTR(m.OWNERS,'|TVDP|')>0 OR INSTR(m.OWNERS,'|TV3S|')>0 OR INSTR(m.OWNERS,'|AMC|')>0 OR INSTR(m.OWNERS,'|TV1E|')>0 OR INSTR(m.OWNERS,'|TV1B|')>0 OR INSTR(m.OWNERS,'|Play|')>0 OR INSTR(m.OWNERS,'|MM|')>0 OR INSTR(m.OWNERS,'|KNVA|')>0 OR INSTR(m.OWNERS,'|03UP|')>0 OR INSTR(m.OWNERS,'|03NO|')>0 OR INSTR(m.OWNERS,'|03NB|')>0 OR INSTR(m.OWNERS,'|03GD|')>0 OR INSTR(m.OWNERS,'|AL|')>0 OR INSTR(m.OWNERS,'|ICCWCCL|')>0 OR INSTR(m.OWNERS,'|PMH|')>0)
 order by upper(m.title), m.media_type, m.ec_som, m.id ) a where rownum <= 50) s 
     where rnum >= 1) t ) 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 
    
     order by r.rnum

t Information: 1220 :  12|15:31:55.3536|Itp9cV|DANIEL|    timing: 00:00:00.1990802
t Verbose: 1220 :      12|15:31:55.3536|Itp9cV|DANIEL|imfx v3 API took 0.199s '/api/v3/search/Media?_dc=1698766315909'
t Transfer: 1220 :     12|15:31:55.3536|Itp9cV|DANIEL|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\SA550004.zip subfolder 
t Transfer: 1220 :     12|15:31:55.3536|Itp9cV|DANIEL|  GetFileName result https://imfxv3tm.tmd.tv/VideoServer/SA550004.zip
t Transfer: 1220 :     12|15:31:55.3536|Itp9cV|DANIEL|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/SA550004.zip
t Transfer: 1220 :     12|15:31:55.3536|Itp9cV|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|15:31:55.3536|Itp9cV|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|15:31:55.3536|Itp9cV|DANIEL|    user DANIEL.