t Information: 1220 :   1|07:59:15.1485||Get Configuration Values:
t Information: 1220 :   1|07:59:15.1485||	AdminPassEnc, default: , value: ffqjrn0leKv4Lj2YJHe2dw==.
t Information: 1220 :   1|07:59:15.1485||	EncryptedPasswords, default: false, value: true.
t Information: 1220 :   1|07:59:15.1485||	OraConnectionString, default: , value: Server=TECHM;User Id=imfx;Password=;Unicode=true;.
t Information: 1220 :   1|07:59:15.1485||	SecondTimezone, default: , value: .
t Information: 1220 :   1|07:59:15.1485||	UseActiveDirectoryAuth, default: false, value: false.
t Information: 1220 :   1|07:59:15.1485||	ReportingServiceUrl, default: , value: http://localhost:92/ReportingService.svc.
t Information: 1220 :   1|07:59:15.1485||	ReportsPath, default: , value: .
t Information: 1220 :   1|07:59:15.1485||	ReportsURL, default: , value: .
t Information: 1220 :   1|07:59:15.1485||	TapeServiceUrl, default: , value: .
t Information: 1220 :   1|07:59:15.1485||	GatekeeperUrl, default: , value: .
t Information: 1220 :   1|07:59:15.1485||	ValuationUrl, default: , value: .
t Information: 1220 :   1|07:59:15.1485||	QueueManagerDelay, default: 30, value: 30.
t Information: 1220 :   1|07:59:15.1485||	QueueManagerFullRefresh, default: 90, value: 90.
t Information: 1220 :   1|07:59:15.1485||	AudioLoopDuration, default: 0, value: 150.
t Information: 1220 :   1|07:59:15.1485||	AudioLoopsCount, default: 0, value: 0.
t Information: 1220 :   1|07:59:15.1485||	PlayerFakeStep, default: 500, value: 500.
t Information: 1220 :   1|07:59:15.1485||	PlayerForceRatio, default: 0, value: 1.
t Information: 1220 :   1|07:59:15.1485||	CheckVersionsInProd, default: false, value: True.
t Information: 1220 :   1|07:59:15.1485||	MaxResults, default: 3000, value: 10000.
t Information: 1220 :   1|07:59:15.1485||	NetworkRestriction, default: false, value: True.
t Information: 1220 :   1|07:59:15.1485||	TEReportID, default: 0, value: 0.
t Information: 1220 :   1|07:59:15.1485||	ClosedCaptionsCache, default: , value: C:\inetpub\wwwroot\imfxcore\timedtextcache\.
t Information: 1220 :   1|07:59:15.1485||	ClosedCaptionsStorage, default: , value: c:\Mediaflex\subs.
t Information: 1220 :   1|07:59:15.1485||	TimeCodeFormat, default: , value: pal.
t Information: 1220 :   1|07:59:15.1485||	RceMediaPath, default: , value: C:\edl\.
t Information: 1220 :   1|07:59:15.1485||	RceMediaPath, default: , value: C:\edl\.
t Information: 1220 :   1|07:59:15.1485||	RceCsmOutputPath, default: , value: C:\Inetpub\wwwroot\csm\.
t Information: 1220 :   1|07:59:15.1485||	RceCsmUrl, default: , value: http://localhost/csm/.
t Information: 1220 :   1|07:59:15.1485||	RceMediaSelection, default: , value: miLinkIdMatch.
t Information: 1220 :   1|07:59:15.1485||	RequestBrowseJobPresetName, default: , value: .
t Information: 1220 :   1|07:59:15.1485||	DontExtendDuration, default: false, value: False.
t Information: 1220 :   1|07:59:15.1485||	V3ConfigUrl, default: , value: .
t Information: 1220 :   1|07:59:15.1485||	ApiServer, default: , value: http://192.168.120.10:85.
t Information: 1220 :   1|07:59:15.1485||	StopWords, default: , value: .
t Information: 1220 :   1|07:59:15.1485||	MisrTxFormat, default: G, value: G.
t Information: 1220 :   1|07:59:15.1485||	ThumbnailServer, default: , value: .
t Information: 1220 :   1|07:59:15.1485||	LocationFilter, default: , value: .
t Information: 1220 :   1|07:59:15.1485||	SvUtilServiceUrl, default: , value: .
t Information: 1220 :   1|07:59:15.1485||	SolrConnection, default: , value: http://192.168.120.14:8983/solr.
t Information: 1220 :   1|07:59:15.1485||	UseIndexServerSearch, default: false, value: True.
t Information: 1220 :   1|07:59:15.1485||	SolrIndexVersion, default: 1, value: 6.
t Information: 1220 :   1|07:59:15.1485||	SolrConnection, default: , value: http://192.168.120.14:8983/solr.
t Information: 1220 :   1|07:59:15.1485||	FacetsGroups, default: , value: owners,season_id, series_id,version_key,item_type,media_type,media_format,episode_number.
t Information: 1220 :   1|07:59:15.1485||	FacetsGroupsVersion, default: , value: owners,season_id, series_id,version_key,episode_number.
t Information: 1220 :   1|07:59:15.1641||	FacetsGroupsChameleon, default: , value: season_id, series_id,genre,prod_year,version_key.
t Information: 1220 :   1|07:59:15.1641||	PreviewPreset, default: , value: .
t Information: 1220 :   1|07:59:15.1641||	DevMode, default: false, value: false.
t Information: 1220 :   1|07:59:15.1641||	DisableSysMan, default: false, value: false.
t Information: 1220 :   1|07:59:15.1641||	TimeCodeFormat, default: , value: pal.
t Information: 1220 :   1|07:59:15.1641||	FileCatalystStorageDevice, default: , value: .
t Information: 1220 :   1|07:59:15.1641||	UseResponsibilityTracking, default: true, value: True.
t Information: 1220 :   1|07:59:15.1641||	SubtitleDeviceFilter, default: , value: .
t Information: 1220 :   1|07:59:15.1641||	SystemMonitorNamedPipe, default: , value: .
t Information: 1220 :   1|07:59:15.1641||	OracleMonitorEnable, default: false, value: False.
t Information: 1220 :   1|07:59:15.1641||	ArcApiHost, default: , value: .
t Information: 1220 :   1|07:59:15.1641||	RabbitMqUrl, default: , value: amqp://192.168.120.14:5672.
t Information: 1220 :   1|07:59:15.1641||	SolrTimedTextSearch, default: false, value: false.
t Information: 1220 :   1|07:59:15.1641||	ProductionDurationUsageID, default: 1, value: 1.
t Information: 1220 :   1|07:59:15.4297||GetStreamServers..
t Information: 1220 :   1|07:59:16.1016||	https://demo.tmd.tv/CBR Video/ |CBR Video| False  
t Information: 1220 :   1|07:59:16.1172||	https://demo.tmd.tv/CBR Images/ |CBR Images| False  
t Information: 1220 :   1|07:59:16.1172||	https://demo.tmd.tv/CBR Audio/ |CBR Audio| False  
t Information: 1220 :   1|07:59:16.1172||	https://demo.tmd.tv/Temp Upload/ |TEMP_UPLOAD| False  
t Information: 1220 :   1|07:59:16.1172||	http://localhost:82/images/ |IMAGES| False  
t Information: 1220 :   1|07:59:16.1172||	http://192.168.91.73/smoothcloud/ |SMOOTH_CLOUD| False  
t Information: 1220 :   1|07:59:16.1172||	http://192.168.91.73/cloudstore/ |CLOUD_STORE| False  
t Information: 1220 :   1|07:59:16.1172||	http://192.168.91.73/editsystemin/ |EDIT_SYSTEM_IN| False  
t Information: 1220 :   1|07:59:16.1172||	http://192.168.91.27:89/APPLEPROXY/ |APPLE_PROXY| False  
t Information: 1220 :   1|07:59:16.1172||	http://localhost:82/video/ |FILESTORE_VIDEO| False  
t Information: 1220 :   1|07:59:16.1172||	https://imfxv3tm.tmd.tv/streaming/ |Streaming| False  
t Information: 1220 :   1|07:59:16.1172||	https://imfxv3tm.tmd.tv/VideoServer/ |Video| False  
t Information: 1220 :   1|07:59:16.1172||	https://imfxv3tm.tmd.tv/AdobeIn/ |Adobe Premiere Pro In| False  
t Information: 1220 :   1|07:59:16.1172||	https://imfxv3tm.tmd.tv/AudioServer/ |Audio| False  
t Information: 1220 :   1|07:59:16.1172||	https://imfxv3tm.tmd.tv/ImageServer/ |Image| False  
t Information: 1220 :   1|07:59:16.1172||	https://imfxv3tm.tmd.tv/DocsServer/ |Docs| False  
t Information: 1220 :   1|07:59:16.1172||	https://imfxv3tm.tmd.tv/AmazonLabs/ |TEST HOUSE| False  
t Information: 1220 :   1|07:59:16.1172||	SolrConnectionUms, default: http://192.168.120.14:8983/solr, value: http://192.168.120.14:8983/solr.
t Information: 1220 :   1|07:59:16.1172||	ApiLog, default: false, value: false.
t Information: 1220 :   1|07:59:16.1172||	EmbeddedRceUrl, default: , value: .
t Information: 1220 :   1|07:59:16.1172||	InstallMode, default: , value: .
t Information: 1220 :   1|07:59:16.1172||	SamlRequestAddress, default: , value: .
t Information: 1220 :   1|07:59:16.1172||	SamlTrustedIssuer, default: , value: .
t Information: 1220 :   1|07:59:16.1172||	SamlLoginRedirect, default: , value: .
t Information: 1220 :   1|07:59:16.1172||	NaturalLangSearch, default: false, value: True.
t Information: 1220 :   1|07:59:16.1172||	OktaLoginField, default: , value: .
t Information: 1220 :   1|07:59:16.1172||	AuthenticationTypes, default: , value: Native,PublicApiKey.
t Information: 1220 :   1|07:59:16.1172||OrabitWatcherBasic. Initialize.
t Information: 1220 :   1|07:59:16.2110||FillDictionaryCache.
t Information: 1220 :   1|07:59:19.6328||GetSupportedOperators
t Information: 1220 :  10|07:59:19.9297||CacheTechReports.
t Information: 1220 :   1|07:59:20.0391||& Cache update. Server (global) filled with timestamp 07:12:20.0391226. types null
t Information: 1220 :   1|07:59:20.0391||InitializeFromDatabase.
  'Server=TECHM;User Id=imfx;password=..;Unicode=true;'
  direct False, home , timeout 15
t Information: 1220 :   1|07:59:20.0547||FillDictionaryCache.
t Information: 1220 :   1|07:59:20.0547||& Cache update. Server (global) filled with timestamp 07:12:20.0547503. types FriendlyNames, DatabaseSearchFieldData
t Information: 1220 :   1|07:59:20.3828|<UNK>|==========================================================================
t Information: 1220 :   1|07:59:20.3828|<UNK>|IMFX CORE SERVER APPLICATION START.
t Information: 1220 :   1|07:59:20.3828|<UNK>|DLL VERSION: 2.5.0.2322.
t Information: 1220 :  18|07:59:20.3828|<UNK>|	UmsDev, default: False, value: False.
t Information: 1220 :   1|07:59:20.4609|<UNK>|	ApiLog, default: false, value: false.
t Information: 1220 :  11|07:59:21.1328|<UNK>|OrabitWatcherBasic trying to connect..
t Information: 1220 :  11|07:59:21.2110|<UNK>|OrabitWatcherBasic connected.
t Information: 1220 :  11|07:59:21.2266|<UNK>|OrabitWatcherBasic queue created tmd.cfg.in.65a53c99-4726-48f0-86b8-3e57acaabee2
t Information: 1220 :  12|07:59:27.2266|<UNK>|GetAppInfo
t Information: 1220 :  12|07:59:27.2422|<UNK>|  db: TMDDEMO
  install mode: 
  auth types: Native, PublicApiKey
t Information: 1220 :  12|07:59:41.0234|<UNK>|Oauth validating..
t Verbose: 1220 :      12|07:59:41.0391|<UNK>|GrantResourceOwnerCredentials.
t Verbose: 1220 :      12|07:59:41.0391|<UNK>|LoginUser. tony, login type OAuth, encrypt password True
t Information: 1220 :  12|07:59:41.0391|<UNK>|TryLoginUser. tony, login type OAuth, check password True, check hash False, encrypt password True, load user data True
t Information: 1220 :  12|07:59:41.2109|<UNK>|InitialiseLogin
t Information: 1220 :  12|07:59:41.2422|<UNK>|  oauth token 00000000-0000-0000-0000-000000000000
t Information: 1220 :  12|07:59:41.2422|<UNK>|TryLoginUser. Logged in..
t Information: 1220 :  12|07:59:41.2735|<UNK>|GetPasswordPolicy. WARNING: Policy not found for system Imediaflex. Validation disabled.
t Verbose: 1220 :      12|07:59:41.2735|<UNK>|LoginUser. Adding history. User Id 522, result TONY, host 
t Verbose: 1220 :      12|07:59:41.3047|<UNK>|GrantResourceOwnerCredentials. Try login finished. Logged: True
t Transfer: 1220 :     10|07:59:41.4141|<UNK>|IsUserAuthenticated: /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,logoImage&globals=isDebugMode,htmlplayerhotkeys,versionCreationSettings,associate.advanced_search.version.setups,associate.advanced_search.media.setups,associate.wfrise.setups,supplier_portal.advanced_search.version.setups&_dc=1575964781399
t Transfer: 1220 :     10|07:59:41.4141|<UNK>|GetCurrentUser..
t Transfer: 1220 :     10|07:59:41.4141|<UNK>|  OAuth authenticated
t Transfer: 1220 :     10|07:59:41.4141|<UNK>|    user TONY.
t Transfer: 1220 :     10|07:59:41.4141|<UNK>|api user: TONY
t Information: 1220 :  10|07:59:41.4297|<UNK>|V3Api.GetUserSettings
t Transfer: 1220 :     10|07:59:41.4297|<UNK>|GetCurrentUser..
t Transfer: 1220 :     10|07:59:41.4297|<UNK>|  OAuth authenticated
t Transfer: 1220 :     10|07:59:41.4297|<UNK>|    user TONY.
t Transfer: 1220 :     11|07:59:41.5078|<UNK>|IsUserAuthenticated: /api/user-preferences?keys=personal_settings;basket;default_page;color_schema;media.basket.data;defaultSearch&_dc=1575964781538
t Transfer: 1220 :     11|07:59:41.5078|<UNK>|GetCurrentUser..
t Transfer: 1220 :     11|07:59:41.5078|<UNK>|  OAuth authenticated
t Transfer: 1220 :     11|07:59:41.5078|<UNK>|    user TONY.
t Transfer: 1220 :     11|07:59:41.5078|<UNK>|api user: TONY
t Information: 1220 :  11|07:59:41.5078|<UNK>|GetUserDataByKeys: personal_settings;basket;default_page;color_schema;media.basket.data;defaultSearch
t Transfer: 1220 :     11|07:59:41.5078|<UNK>|GetCurrentUser..
t Transfer: 1220 :     11|07:59:41.5078|<UNK>|  OAuth authenticated
t Transfer: 1220 :     11|07:59:41.5078|<UNK>|    user TONY.
t Transfer: 1220 :     10|07:59:41.5391|<UNK>|IsUserAuthenticated: /api/lookups/MediaStatus?_dc=1575964781540
t Transfer: 1220 :     10|07:59:41.5391|<UNK>|GetCurrentUser..
t Transfer: 1220 :     10|07:59:41.5391|<UNK>|  OAuth authenticated
t Transfer: 1220 :     10|07:59:41.5391|<UNK>|    user TONY.
t Transfer: 1220 :     10|07:59:41.5391|<UNK>|api user: TONY
t Transfer: 1220 :      5|07:59:41.5391|<UNK>|IsUserAuthenticated: /api/lookups/PgmStatus?_dc=1575964781541
t Transfer: 1220 :      5|07:59:41.5391|<UNK>|GetCurrentUser..
t Transfer: 1220 :      5|07:59:41.5391|<UNK>|  OAuth authenticated
t Transfer: 1220 :      5|07:59:41.5391|<UNK>|    user TONY.
t Transfer: 1220 :      5|07:59:41.5391|<UNK>|api user: TONY
t Information: 1220 :  12|07:59:41.6172|<UNK>|GetUserProfile. Id: 0
t Transfer: 1220 :     12|07:59:41.6172|<UNK>|GetCurrentUser..
t Transfer: 1220 :     12|07:59:41.6172|<UNK>|  OAuth authenticated
t Transfer: 1220 :     12|07:59:41.6172|<UNK>|    user TONY.
t Transfer: 1220 :     10|07:59:41.9766|<UNK>|IsUserAuthenticated: /api/settings/user/defaultSearch?_dc=1575964782005
t Transfer: 1220 :     10|07:59:41.9766|<UNK>|GetCurrentUser..
t Transfer: 1220 :     10|07:59:41.9766|<UNK>|  OAuth authenticated
t Transfer: 1220 :     10|07:59:41.9766|<UNK>|    user TONY.
t Transfer: 1220 :     10|07:59:41.9766|<UNK>|api user: TONY
t Information: 1220 :  10|07:59:41.9766|<UNK>|V3Api.GetUserSettings
t Transfer: 1220 :     10|07:59:41.9766|<UNK>|GetCurrentUser..
t Transfer: 1220 :     10|07:59:41.9766|<UNK>|  OAuth authenticated
t Transfer: 1220 :     10|07:59:41.9766|<UNK>|    user TONY.
t Transfer: 1220 :     10|07:59:42.0079|<UNK>|IsUserAuthenticated: /api/settings/user/startSearch?_dc=1575964782006
t Transfer: 1220 :     10|07:59:42.0079|<UNK>|GetCurrentUser..
t Transfer: 1220 :     10|07:59:42.0079|<UNK>|  OAuth authenticated
t Transfer: 1220 :     10|07:59:42.0079|<UNK>|    user TONY.
t Transfer: 1220 :     10|07:59:42.0079|<UNK>|api user: TONY
t Information: 1220 :  10|07:59:42.0079|<UNK>|V3Api.GetUserSettings
t Transfer: 1220 :     10|07:59:42.0079|<UNK>|GetCurrentUser..
t Transfer: 1220 :     10|07:59:42.0079|<UNK>|  OAuth authenticated
t Transfer: 1220 :     10|07:59:42.0079|<UNK>|    user TONY.
t Transfer: 1220 :      5|07:59:42.0234|<UNK>|IsUserAuthenticated: /api/user-preferences?keys=consumer.recent.data&_dc=1575964782059
t Transfer: 1220 :      5|07:59:42.0234|<UNK>|GetCurrentUser..
t Transfer: 1220 :      5|07:59:42.0234|<UNK>|  OAuth authenticated
t Transfer: 1220 :      5|07:59:42.0234|<UNK>|    user TONY.
t Transfer: 1220 :      5|07:59:42.0234|<UNK>|api user: TONY
t Information: 1220 :   5|07:59:42.0234|<UNK>|GetUserDataByKeys: consumer.recent.data
t Transfer: 1220 :      5|07:59:42.0234|<UNK>|GetCurrentUser..
t Transfer: 1220 :      5|07:59:42.0234|<UNK>|  OAuth authenticated
t Transfer: 1220 :      5|07:59:42.0234|<UNK>|    user TONY.
t Transfer: 1220 :     10|07:59:42.0703|<UNK>|IsUserAuthenticated: /api/user-preferences?keys=adv.recent.searches.consumer&_dc=1575964782106
t Transfer: 1220 :     10|07:59:42.0703|<UNK>|GetCurrentUser..
t Transfer: 1220 :     10|07:59:42.0703|<UNK>|  OAuth authenticated
t Transfer: 1220 :     10|07:59:42.0703|<UNK>|    user TONY.
t Transfer: 1220 :     10|07:59:42.0703|<UNK>|api user: TONY
t Information: 1220 :  10|07:59:42.0703|<UNK>|GetUserDataByKeys: adv.recent.searches.consumer
t Transfer: 1220 :     10|07:59:42.0703|<UNK>|GetCurrentUser..
t Transfer: 1220 :     10|07:59:42.0703|<UNK>|  OAuth authenticated
t Transfer: 1220 :     10|07:59:42.0703|<UNK>|    user TONY.
t Transfer: 1220 :     12|07:59:46.2891|<UNK>|IsUserAuthenticated: /api/SearchSuggestion/?_dc=1575964786278
t Transfer: 1220 :     12|07:59:46.2891|<UNK>|GetCurrentUser..
t Transfer: 1220 :     12|07:59:46.2891|<UNK>|  OAuth authenticated
t Transfer: 1220 :     12|07:59:46.2891|<UNK>|    user TONY.
t Transfer: 1220 :     12|07:59:46.2891|<UNK>|api user: TONY
t Transfer: 1220 :     12|07:59:46.3516|<UNK>|GetCurrentUser..
t Transfer: 1220 :     12|07:59:46.3516|<UNK>|  OAuth authenticated
t Transfer: 1220 :     12|07:59:46.3516|<UNK>|    user TONY.
t Transfer: 1220 :     10|07:59:47.4765|<UNK>|IsUserAuthenticated: /api/settings/user/consumer?_dc=1575964787504
t Transfer: 1220 :     10|07:59:47.4765|<UNK>|GetCurrentUser..
t Transfer: 1220 :     10|07:59:47.4765|<UNK>|  OAuth authenticated
t Transfer: 1220 :     10|07:59:47.4765|<UNK>|    user TONY.
t Transfer: 1220 :     10|07:59:47.4765|<UNK>|api user: TONY
t Information: 1220 :  10|07:59:47.4765|<UNK>|V3Api.GetUserSettings
t Transfer: 1220 :     10|07:59:47.4765|<UNK>|GetCurrentUser..
t Transfer: 1220 :     10|07:59:47.4765|<UNK>|  OAuth authenticated
t Transfer: 1220 :     10|07:59:47.4765|<UNK>|    user TONY.
t Transfer: 1220 :     11|07:59:47.5078|<UNK>|IsUserAuthenticated: /api/user-preferences?keys=consumer.recent.data&_dc=1575964787538
t Transfer: 1220 :     11|07:59:47.5078|<UNK>|GetCurrentUser..
t Transfer: 1220 :     11|07:59:47.5078|<UNK>|  OAuth authenticated
t Transfer: 1220 :     11|07:59:47.5078|<UNK>|    user TONY.
t Transfer: 1220 :     11|07:59:47.5078|<UNK>|api user: TONY
t Information: 1220 :  11|07:59:47.5078|<UNK>|GetUserDataByKeys: consumer.recent.data
t Transfer: 1220 :     11|07:59:47.5078|<UNK>|GetCurrentUser..
t Transfer: 1220 :     11|07:59:47.5078|<UNK>|  OAuth authenticated
t Transfer: 1220 :     11|07:59:47.5078|<UNK>|    user TONY.
t Transfer: 1220 :     12|07:59:47.5391|<UNK>|GetCurrentUser..
t Transfer: 1220 :     12|07:59:47.5391|<UNK>|  OAuth authenticated
t Transfer: 1220 :     12|07:59:47.5391|<UNK>|    user TONY.
t Transfer: 1220 :     12|07:59:47.5547|<UNK>|GetCurrentUser..
t Transfer: 1220 :     12|07:59:47.5547|<UNK>|  OAuth authenticated
t Transfer: 1220 :     12|07:59:47.5547|<UNK>|    user TONY.
t Information: 1220 :  12|07:59:47.6328|<UNK>|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  ,(select UTL_RAW.CAST_TO_VARCHAR2(DBMS_LOB.SUBSTR(data2, 2000,1))  from tm_txt_obj where type_id=5021083 and pgm_rl_id=m.id and rownum=1) SYNOPSIS  ,(select m_ctnr_loc || '^' || m_ctnr_id from tm_mis mis join tm_cfg_media_file_types t on t.id=mis.m_ctnr_fmt_id and t.imfx_disable_playback<>1 where mis.pgm_parent_id=m.id /*and mis.m_ctnr_fmt_id in (2,4,54,52,98,57,62)*/ and mis.item_type>0 and mis.mi_deleted=0 and mis.media_type=100 and not mis.m_ctnr_id is null
  and mis.m_ctnr_loc is not null and rownum=1) PROXY_MEDIA    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,(select /*+ cardinality(4) */ rownum rn, column_value id from table(:ids)) ids  where item_type>0 and rl_deleted=0  and  m.id = ids.id  order by ids.rn ) a where rownum <= 10000) r where rnum >=1 order by rnum
t Information: 1220 :  12|07:59:47.8203|<UNK>|Running version search. User: 522    Simple Search: icc
Trying to use Solr Search...
Solr completed in: 79ms.  Returned lines: 36
Running Oracle search.
Oracle version search timing: 194ms.
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  ,(select UTL_RAW.CAST_TO_VARCHAR2(DBMS_LOB.SUBSTR(data2, 2000,1))  from tm_txt_obj where type_id=5021083 and pgm_rl_id=m.id and rownum=1) SYNOPSIS  ,(select m_ctnr_loc || '^' || m_ctnr_id from tm_mis mis join tm_cfg_media_file_types t on t.id=mis.m_ctnr_fmt_id and t.imfx_disable_playback<>1 where mis.pgm_parent_id=m.id /*and mis.m_ctnr_fmt_id in (2,4,54,52,98,57,62)*/ and mis.item_type>0 and mis.mi_deleted=0 and mis.media_type=100 and not mis.m_ctnr_id is null
  and mis.m_ctnr_loc is not null and rownum=1) PROXY_MEDIA    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,(select /*+ cardinality(4) */ rownum rn, column_value id from table(:ids)) ids  where item_type>0 and rl_deleted=0  and  m.id = ids.id  order by ids.rn ) a where rownum <= 10000) r where rnum >=1 order by rnum

t Verbose: 1220 :      12|07:59:47.8203|<UNK>|GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Australia vs South Africa  Match 45.mp4 subfolder 
t Verbose: 1220 :      12|07:59:47.8203|<UNK>|  GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Australia vs South Africa  Match 45.mp4
t Verbose: 1220 :      12|07:59:47.8203|<UNK>|GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/Australia vs South Africa  Match 45.mp4
t Verbose: 1220 :      12|07:59:47.8203|<UNK>|GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\West Indies vs Pakistan Match 2.mp4 subfolder 
t Verbose: 1220 :      12|07:59:47.8203|<UNK>|  GetFileName result https://imfxv3tm.tmd.tv/VideoServer/West Indies vs Pakistan Match 2.mp4
t Verbose: 1220 :      12|07:59:47.8203|<UNK>|GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/West Indies vs Pakistan Match 2.mp4
t Verbose: 1220 :      12|07:59:47.8203|<UNK>|GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\New Zealand vs England  Final.mp4 subfolder 
t Verbose: 1220 :      12|07:59:47.8203|<UNK>|  GetFileName result https://imfxv3tm.tmd.tv/VideoServer/New Zealand vs England  Final.mp4
t Verbose: 1220 :      12|07:59:47.8203|<UNK>|GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/New Zealand vs England  Final.mp4
t Verbose: 1220 :      12|07:59:47.8203|<UNK>|GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Australia vs England Short Semi Final 2.mp4 subfolder 
t Verbose: 1220 :      12|07:59:47.8203|<UNK>|  GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Australia vs England Short Semi Final 2.mp4
t Verbose: 1220 :      12|07:59:47.8203|<UNK>|GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/Australia vs England Short Semi Final 2.mp4
t Verbose: 1220 :      12|07:59:47.8203|<UNK>|GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\India vs New Zealand  Semi Final 1.mp4 subfolder 
t Verbose: 1220 :      12|07:59:47.8203|<UNK>|  GetFileName result https://imfxv3tm.tmd.tv/VideoServer/India vs New Zealand  Semi Final 1.mp4
t Verbose: 1220 :      12|07:59:47.8203|<UNK>|GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/India vs New Zealand  Semi Final 1.mp4
t Verbose: 1220 :      12|07:59:47.8203|<UNK>|GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\South Africa vs Bangladesh Match 5 .mp4 subfolder 
t Verbose: 1220 :      12|07:59:47.8203|<UNK>|  GetFileName result https://imfxv3tm.tmd.tv/VideoServer/South Africa vs Bangladesh Match 5 .mp4
t Verbose: 1220 :      12|07:59:47.8359|<UNK>|GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/South Africa vs Bangladesh Match 5 .mp4
t Verbose: 1220 :      12|07:59:47.8359|<UNK>|GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\New Zealand vs Sri Lanka  Match 3.mp4 subfolder 
t Verbose: 1220 :      12|07:59:47.8359|<UNK>|  GetFileName result https://imfxv3tm.tmd.tv/VideoServer/New Zealand vs Sri Lanka  Match 3.mp4
t Verbose: 1220 :      12|07:59:47.8359|<UNK>|GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/New Zealand vs Sri Lanka  Match 3.mp4
t Verbose: 1220 :      12|07:59:47.8359|<UNK>|GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Afghanistan vs Australia  Match 4.mp4 subfolder 
t Verbose: 1220 :      12|07:59:47.8359|<UNK>|  GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Afghanistan vs Australia  Match 4.mp4
t Verbose: 1220 :      12|07:59:47.8359|<UNK>|GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/Afghanistan vs Australia  Match 4.mp4
t Verbose: 1220 :      12|07:59:47.8359|<UNK>|GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Bangladesh vs New Zealand  Match 9.mp4 subfolder 
t Verbose: 1220 :      12|07:59:47.8359|<UNK>|  GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Bangladesh vs New Zealand  Match 9.mp4
t Verbose: 1220 :      12|07:59:47.8359|<UNK>|GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/Bangladesh vs New Zealand  Match 9.mp4
t Verbose: 1220 :      12|07:59:47.8359|<UNK>|GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Afghanistan vs Sri Lanka  Match 7.mp4 subfolder 
t Verbose: 1220 :      12|07:59:47.8359|<UNK>|  GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Afghanistan vs Sri Lanka  Match 7.mp4
t Verbose: 1220 :      12|07:59:47.8359|<UNK>|GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/Afghanistan vs Sri Lanka  Match 7.mp4
t Verbose: 1220 :      12|07:59:47.8359|<UNK>|GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Australia vs West Indies Match 10.mp4 subfolder 
t Verbose: 1220 :      12|07:59:47.8359|<UNK>|  GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Australia vs West Indies Match 10.mp4
t Verbose: 1220 :      12|07:59:47.8359|<UNK>|GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/Australia vs West Indies Match 10.mp4
t Verbose: 1220 :      12|07:59:47.8359|<UNK>|GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\South Africa vs India  Match 8.mp4 subfolder 
t Verbose: 1220 :      12|07:59:47.8359|<UNK>|  GetFileName result https://imfxv3tm.tmd.tv/VideoServer/South Africa vs India  Match 8.mp4
t Verbose: 1220 :      12|07:59:47.8359|<UNK>|GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/South Africa vs India  Match 8.mp4
t Verbose: 1220 :      12|07:59:47.8359|<UNK>|GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Pakistan vs Sri Lanka  Match 11.mp4 subfolder 
t Verbose: 1220 :      12|07:59:47.8359|<UNK>|  GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Pakistan vs Sri Lanka  Match 11.mp4
t Verbose: 1220 :      12|07:59:47.8359|<UNK>|GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/Pakistan vs Sri Lanka  Match 11.mp4
t Verbose: 1220 :      12|07:59:47.8359|<UNK>|GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\England vs Pakistan  Match 6.mp4 subfolder 
t Verbose: 1220 :      12|07:59:47.8359|<UNK>|  GetFileName result https://imfxv3tm.tmd.tv/VideoServer/England vs Pakistan  Match 6.mp4
t Verbose: 1220 :      12|07:59:47.8359|<UNK>|GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/England vs Pakistan  Match 6.mp4
t Verbose: 1220 :      12|07:59:47.8359|<UNK>|GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\England vs South Africa  Match 1.mp4 subfolder 
t Verbose: 1220 :      12|07:59:47.8359|<UNK>|  GetFileName result https://imfxv3tm.tmd.tv/VideoServer/England vs South Africa  Match 1.mp4
t Verbose: 1220 :      12|07:59:47.8359|<UNK>|GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/England vs South Africa  Match 1.mp4
t Transfer: 1220 :     11|07:59:47.9609|<UNK>|IsUserAuthenticated: /api/user-preferences?keys=adv.recent.searches.consumer&_dc=1575964787951
t Transfer: 1220 :     11|07:59:47.9609|<UNK>|GetCurrentUser..
t Transfer: 1220 :     11|07:59:47.9609|<UNK>|  OAuth authenticated
t Transfer: 1220 :     11|07:59:47.9609|<UNK>|    user TONY.
t Transfer: 1220 :     11|07:59:47.9609|<UNK>|api user: TONY
t Information: 1220 :  11|07:59:47.9609|<UNK>|GetUserDataByKeys: adv.recent.searches.consumer
t Transfer: 1220 :     11|07:59:47.9609|<UNK>|GetCurrentUser..
t Transfer: 1220 :     11|07:59:47.9609|<UNK>|  OAuth authenticated
t Transfer: 1220 :     11|07:59:47.9609|<UNK>|    user TONY.
t Transfer: 1220 :     10|07:59:48.2578|<UNK>|IsUserAuthenticated: /api/user-group-preferences?globals=htmlplayerhotkeys,audioOnFrameForward&_dc=1575964788285
t Transfer: 1220 :     10|07:59:48.2578|<UNK>|GetCurrentUser..
t Transfer: 1220 :     10|07:59:48.2578|<UNK>|  OAuth authenticated
t Transfer: 1220 :     10|07:59:48.2578|<UNK>|    user TONY.
t Transfer: 1220 :     10|07:59:48.2578|<UNK>|api user: TONY
t Information: 1220 :  10|07:59:48.2578|<UNK>|V3Api.GetUserSettings
t Transfer: 1220 :     10|07:59:48.2578|<UNK>|GetCurrentUser..
t Transfer: 1220 :     10|07:59:48.2578|<UNK>|  OAuth authenticated
t Transfer: 1220 :     10|07:59:48.2578|<UNK>|    user TONY.
t Transfer: 1220 :     12|07:59:48.2891|<UNK>|IsUserAuthenticated: /api/versionvideo/298372?_dc=1575964788312
t Transfer: 1220 :     12|07:59:48.2891|<UNK>|GetCurrentUser..
t Transfer: 1220 :     12|07:59:48.2891|<UNK>|  OAuth authenticated
t Transfer: 1220 :     12|07:59:48.2891|<UNK>|    user TONY.
t Transfer: 1220 :     12|07:59:48.2891|<UNK>|api user: TONY
t Transfer: 1220 :     12|07:59:48.3047|<UNK>|GetCurrentUser..
t Transfer: 1220 :     12|07:59:48.3047|<UNK>|  OAuth authenticated
t Transfer: 1220 :     12|07:59:48.3047|<UNK>|    user TONY.
t Verbose: 1220 :      12|07:59:48.3516|<UNK>|GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Australia vs South Africa  Match 45.mp4 subfolder 
t Verbose: 1220 :      12|07:59:48.3516|<UNK>|  GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Australia vs South Africa  Match 45.mp4
t Verbose: 1220 :      12|07:59:48.3516|<UNK>|GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/Australia vs South Africa  Match 45.mp4
t Transfer: 1220 :     12|07:59:48.3516|<UNK>|GetCurrentUser..
t Transfer: 1220 :     12|07:59:48.3516|<UNK>|  OAuth authenticated
t Transfer: 1220 :     12|07:59:48.3516|<UNK>|    user TONY.
t Transfer: 1220 :     11|07:59:49.6172|<UNK>|IsUserAuthenticated: /api/versionvideo/298372?_dc=1575964789643
t Transfer: 1220 :     11|07:59:49.6172|<UNK>|GetCurrentUser..
t Transfer: 1220 :     11|07:59:49.6172|<UNK>|  OAuth authenticated
t Transfer: 1220 :     11|07:59:49.6172|<UNK>|    user TONY.
t Transfer: 1220 :     11|07:59:49.6172|<UNK>|api user: TONY
t Transfer: 1220 :     11|07:59:49.6172|<UNK>|GetCurrentUser..
t Transfer: 1220 :     11|07:59:49.6172|<UNK>|  OAuth authenticated
t Transfer: 1220 :     11|07:59:49.6172|<UNK>|    user TONY.
t Verbose: 1220 :      11|07:59:49.6328|<UNK>|GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Australia vs South Africa  Match 45.mp4 subfolder 
t Verbose: 1220 :      11|07:59:49.6328|<UNK>|  GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Australia vs South Africa  Match 45.mp4
t Verbose: 1220 :      11|07:59:49.6328|<UNK>|GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/Australia vs South Africa  Match 45.mp4
t Transfer: 1220 :     11|07:59:49.6328|<UNK>|GetCurrentUser..
t Transfer: 1220 :     11|07:59:49.6328|<UNK>|  OAuth authenticated
t Transfer: 1220 :     11|07:59:49.6328|<UNK>|    user TONY.
t Transfer: 1220 :     10|07:59:49.6328|<UNK>|IsUserAuthenticated: /api/user-group-preferences?globals=htmlplayerhotkeys,audioOnFrameForward&_dc=1575964789673
t Transfer: 1220 :     10|07:59:49.6328|<UNK>|GetCurrentUser..
t Transfer: 1220 :     10|07:59:49.6328|<UNK>|  OAuth authenticated
t Transfer: 1220 :     10|07:59:49.6328|<UNK>|    user TONY.
t Transfer: 1220 :     10|07:59:49.6328|<UNK>|api user: TONY
t Information: 1220 :  10|07:59:49.6328|<UNK>|V3Api.GetUserSettings
t Transfer: 1220 :     10|07:59:49.6328|<UNK>|GetCurrentUser..
t Transfer: 1220 :     10|07:59:49.6328|<UNK>|  OAuth authenticated
t Transfer: 1220 :     10|07:59:49.6328|<UNK>|    user TONY.
t Transfer: 1220 :     12|07:59:49.6484|<UNK>|IsUserAuthenticated: /api/versionvideo/298382?_dc=1575964789683
t Transfer: 1220 :     12|07:59:49.6484|<UNK>|GetCurrentUser..
t Transfer: 1220 :     12|07:59:49.6484|<UNK>|  OAuth authenticated
t Transfer: 1220 :     12|07:59:49.6484|<UNK>|    user TONY.
t Transfer: 1220 :     12|07:59:49.6484|<UNK>|api user: TONY
t Transfer: 1220 :     12|07:59:49.6484|<UNK>|GetCurrentUser..
t Transfer: 1220 :     12|07:59:49.6484|<UNK>|  OAuth authenticated
t Transfer: 1220 :     12|07:59:49.6484|<UNK>|    user TONY.
t Verbose: 1220 :      12|07:59:49.7422|<UNK>|GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\West Indies vs Pakistan Match 2.mp4 subfolder 
t Verbose: 1220 :      12|07:59:49.7422|<UNK>|  GetFileName result https://imfxv3tm.tmd.tv/VideoServer/West Indies vs Pakistan Match 2.mp4
t Verbose: 1220 :      12|07:59:49.7422|<UNK>|GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/West Indies vs Pakistan Match 2.mp4
t Transfer: 1220 :     12|07:59:49.7422|<UNK>|GetCurrentUser..
t Transfer: 1220 :     12|07:59:49.7422|<UNK>|  OAuth authenticated
t Transfer: 1220 :     12|07:59:49.7422|<UNK>|    user TONY.
t Transfer: 1220 :     11|07:59:50.3359|<UNK>|IsUserAuthenticated: /api/versionvideo/298382?_dc=1575964790359
t Transfer: 1220 :     11|07:59:50.3359|<UNK>|GetCurrentUser..
t Transfer: 1220 :     11|07:59:50.3359|<UNK>|  OAuth authenticated
t Transfer: 1220 :     11|07:59:50.3359|<UNK>|    user TONY.
t Transfer: 1220 :     11|07:59:50.3359|<UNK>|api user: TONY
t Transfer: 1220 :     11|07:59:50.3359|<UNK>|GetCurrentUser..
t Transfer: 1220 :     11|07:59:50.3359|<UNK>|  OAuth authenticated
t Transfer: 1220 :     11|07:59:50.3359|<UNK>|    user TONY.
t Verbose: 1220 :      11|07:59:50.3359|<UNK>|GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\West Indies vs Pakistan Match 2.mp4 subfolder 
t Verbose: 1220 :      11|07:59:50.3359|<UNK>|  GetFileName result https://imfxv3tm.tmd.tv/VideoServer/West Indies vs Pakistan Match 2.mp4
t Verbose: 1220 :      11|07:59:50.3359|<UNK>|GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/West Indies vs Pakistan Match 2.mp4
t Transfer: 1220 :     11|07:59:50.3359|<UNK>|GetCurrentUser..
t Transfer: 1220 :     11|07:59:50.3359|<UNK>|  OAuth authenticated
t Transfer: 1220 :     11|07:59:50.3359|<UNK>|    user TONY.
t Transfer: 1220 :     18|07:59:51.1484|<UNK>|IsUserAuthenticated: /api/versionvideo/298372?_dc=1575964791176
t Transfer: 1220 :     18|07:59:51.1484|<UNK>|GetCurrentUser..
t Transfer: 1220 :     18|07:59:51.1484|<UNK>|  OAuth authenticated
t Transfer: 1220 :     18|07:59:51.1484|<UNK>|    user TONY.
t Transfer: 1220 :     18|07:59:51.1484|<UNK>|api user: TONY
t Transfer: 1220 :     18|07:59:51.1484|<UNK>|GetCurrentUser..
t Transfer: 1220 :     18|07:59:51.1484|<UNK>|  OAuth authenticated
t Transfer: 1220 :     18|07:59:51.1484|<UNK>|    user TONY.
t Verbose: 1220 :      18|07:59:51.2266|<UNK>|GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Australia vs South Africa  Match 45.mp4 subfolder 
t Verbose: 1220 :      18|07:59:51.2266|<UNK>|  GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Australia vs South Africa  Match 45.mp4
t Verbose: 1220 :      18|07:59:51.2266|<UNK>|GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/Australia vs South Africa  Match 45.mp4
t Transfer: 1220 :     18|07:59:51.2266|<UNK>|GetCurrentUser..
t Transfer: 1220 :     18|07:59:51.2266|<UNK>|  OAuth authenticated
t Transfer: 1220 :     18|07:59:51.2266|<UNK>|    user TONY.
t Transfer: 1220 :     12|08:00:02.3984|<UNK>|IsUserAuthenticated: /api/lookups/SearchSupportedOperators?_dc=1575964802412
t Transfer: 1220 :     12|08:00:02.3984|<UNK>|GetCurrentUser..
t Transfer: 1220 :     12|08:00:02.3984|<UNK>|  OAuth authenticated
t Transfer: 1220 :     12|08:00:02.3984|<UNK>|    user TONY.
t Transfer: 1220 :     12|08:00:02.3984|<UNK>|api user: TONY
t Transfer: 1220 :     10|08:00:02.3984|<UNK>|IsUserAuthenticated: /api/user-preferences?keys=adv.recent.searches.media&_dc=1575964802415
t Transfer: 1220 :     10|08:00:02.3984|<UNK>|GetCurrentUser..
t Transfer: 1220 :     10|08:00:02.3984|<UNK>|  OAuth authenticated
t Transfer: 1220 :     10|08:00:02.3984|<UNK>|    user TONY.
t Transfer: 1220 :     10|08:00:02.3984|<UNK>|api user: TONY
t Information: 1220 :  10|08:00:02.3984|<UNK>|GetUserDataByKeys: adv.recent.searches.media
t Transfer: 1220 :     10|08:00:02.3984|<UNK>|GetCurrentUser..
t Transfer: 1220 :     10|08:00:02.3984|<UNK>|  OAuth authenticated
t Transfer: 1220 :     10|08:00:02.3984|<UNK>|    user TONY.
t Transfer: 1220 :     11|08:00:02.4610|<UNK>|IsUserAuthenticated: /api/settings/user/searchLayoutConfig?_dc=1575964802417
t Transfer: 1220 :     11|08:00:02.4610|<UNK>|GetCurrentUser..
t Transfer: 1220 :     11|08:00:02.4610|<UNK>|  OAuth authenticated
t Transfer: 1220 :     11|08:00:02.4610|<UNK>|    user TONY.
t Transfer: 1220 :     11|08:00:02.4610|<UNK>|api user: TONY
t Information: 1220 :  11|08:00:02.4610|<UNK>|V3Api.GetUserSettings
t Transfer: 1220 :     11|08:00:02.4610|<UNK>|GetCurrentUser..
t Transfer: 1220 :      5|08:00:02.4610|<UNK>|IsUserAuthenticated: /api/view/searchinfo/Media?_dc=1575964802408
t Transfer: 1220 :      5|08:00:02.4610|<UNK>|GetCurrentUser..
t Transfer: 1220 :      5|08:00:02.4610|<UNK>|  OAuth authenticated
t Transfer: 1220 :      5|08:00:02.4610|<UNK>|    user TONY.
t Transfer: 1220 :      5|08:00:02.4610|<UNK>|api user: TONY
t Transfer: 1220 :     11|08:00:02.4610|<UNK>|  OAuth authenticated
t Transfer: 1220 :     11|08:00:02.4610|<UNK>|    user TONY.
t Transfer: 1220 :     10|08:00:02.4610|<UNK>|IsUserAuthenticated: /api/view/info/MediaGrid?lang=en-US&_dc=1575964802444
t Transfer: 1220 :     10|08:00:02.4610|<UNK>|GetCurrentUser..
t Transfer: 1220 :     10|08:00:02.4610|<UNK>|  OAuth authenticated
t Transfer: 1220 :     10|08:00:02.4610|<UNK>|    user TONY.
t Transfer: 1220 :     10|08:00:02.4610|<UNK>|api user: TONY
t Transfer: 1220 :     12|08:00:02.4610|<UNK>|IsUserAuthenticated: /api/view/searches/Media?_dc=1575964802474
t Transfer: 1220 :     12|08:00:02.4610|<UNK>|GetCurrentUser..
t Information: 1220 :   5|08:00:02.4610|<UNK>|GetAdvSearchColumns. search type Media grid .
t Transfer: 1220 :     12|08:00:02.4610|<UNK>|  OAuth authenticated
t Transfer: 1220 :     12|08:00:02.4610|<UNK>|    user TONY.
t Transfer: 1220 :     12|08:00:02.4610|<UNK>|api user: TONY
t Information: 1220 :  10|08:00:02.4610|<UNK>|GetGridViewBuilder. builder type MediaGrid.
t Transfer: 1220 :     10|08:00:02.4766|<UNK>|GetCurrentUser..
t Transfer: 1220 :     10|08:00:02.4766|<UNK>|  OAuth authenticated
t Transfer: 1220 :     10|08:00:02.4766|<UNK>|    user TONY.
t Information: 1220 :  12|08:00:02.4766|<UNK>|GetSavedSearchNames. search type Media.
t Transfer: 1220 :     12|08:00:02.4766|<UNK>|GetCurrentUser..
t Transfer: 1220 :     12|08:00:02.4766|<UNK>|  OAuth authenticated
t Transfer: 1220 :     12|08:00:02.4766|<UNK>|    user TONY.
t Information: 1220 :  10|08:00:02.4766|<UNK>|UserGridView. LoadView. ID 1282, Name Default.
t Transfer: 1220 :     10|08:00:02.4766|<UNK>|GetCurrentUser..
t Transfer: 1220 :     10|08:00:02.4766|<UNK>|  OAuth authenticated
t Transfer: 1220 :     10|08:00:02.4766|<UNK>|    user TONY.
t Transfer: 1220 :     10|08:00:02.4766|<UNK>|GetCurrentUser..
t Transfer: 1220 :     10|08:00:02.4766|<UNK>|  OAuth authenticated
t Transfer: 1220 :     10|08:00:02.4766|<UNK>|    user TONY.
t Transfer: 1220 :     12|08:00:08.8047|<UNK>|IsUserAuthenticated: /api/SearchSuggestion/?_dc=1575964808802
t Transfer: 1220 :     12|08:00:08.8047|<UNK>|GetCurrentUser..
t Transfer: 1220 :     12|08:00:08.8047|<UNK>|  OAuth authenticated
t Transfer: 1220 :     12|08:00:08.8047|<UNK>|    user TONY.
t Transfer: 1220 :     12|08:00:08.8047|<UNK>|api user: TONY
t Transfer: 1220 :     12|08:00:08.8047|<UNK>|GetCurrentUser..
t Transfer: 1220 :     12|08:00:08.8047|<UNK>|  OAuth authenticated
t Transfer: 1220 :     12|08:00:08.8047|<UNK>|    user TONY.
t Transfer: 1220 :     12|08:00:10.7109|<UNK>|IsUserAuthenticated: /api/search/Media?_dc=1575964810719
t Transfer: 1220 :     12|08:00:10.7109|<UNK>|GetCurrentUser..
t Transfer: 1220 :     12|08:00:10.7109|<UNK>|  OAuth authenticated
t Transfer: 1220 :     12|08:00:10.7109|<UNK>|    user TONY.
t Transfer: 1220 :     12|08:00:10.7109|<UNK>|api user: TONY
t Information: 1220 :  12|08:00:10.7266|<UNK>|V3Api.SearchMedia
t Information: 1220 :  12|08:00:10.7734|<UNK>|V3Api.SearchGeneric
t Transfer: 1220 :     12|08:00:10.8203|<UNK>|GetCurrentUser..
t Transfer: 1220 :     12|08:00:10.8203|<UNK>|  OAuth authenticated
t Transfer: 1220 :     12|08:00:10.8203|<UNK>|    user TONY.
t Information: 1220 :  12|08:00:10.8516|<UNK>|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 ,(select /*+ cardinality(4) */ rownum rn, column_value id from table(:ids)) ids  where media_type>0 and item_type>0  and m.id = ids.id  order by ids.rn ) a where rownum <= 10000) r 
    ,lateral( select l.miid, max(c.C_EXT_OUT_LOC) lib_loc_ext_id, max(c.C_STAT) ctnr_stat, max(c.loan_stat) ctnr_loan_stat  from tm_mi_tpi_lnx l, tm_ctnrs c where c.u_id=l.tpiid and l.miid=r.id and r.media_type=1 group by l.miid)(+) lnk 
    ,lateral(select tt.* from tm_text tt where tt.text_id = r.primary_thumb_id2)(+) t
    ,lateral(select /*+ NO_DECORRELATE */  d.som fsom, d.eom feom, dl.mi_id fmi_id, d.os_fname fos_fname, d.DFILE_LINK_GUID, d.OS_GUID, d.SUB_FOLDER, dl.dfile_id, d.original_filename
        FROM tm_dfile d, tm_mi_dfile_lnx dl where d.id=dl.dfile_id and r.id=dl.mi_id and rownum=1)(+) dfl 
    
    where rnum >= 1 order by rnum 

t Information: 1220 :  12|08:00:10.9296|<UNK>|    timing: 00:00:00.1428485
t Verbose: 1220 :      12|08:00:11.0859|<UNK>|GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Australia vs South Africa  Match 45.mp4 subfolder 
t Verbose: 1220 :      12|08:00:11.0859|<UNK>|  GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Australia vs South Africa  Match 45.mp4
t Verbose: 1220 :      12|08:00:11.0859|<UNK>|GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/Australia vs South Africa  Match 45.mp4
t Transfer: 1220 :     12|08:00:11.0859|<UNK>|GetCurrentUser..
t Transfer: 1220 :     12|08:00:11.0859|<UNK>|  OAuth authenticated
t Transfer: 1220 :     12|08:00:11.0859|<UNK>|    user TONY.
t Verbose: 1220 :      12|08:00:11.1328|<UNK>|GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\England vs South Africa  Match 1.mp4 subfolder 
t Verbose: 1220 :      12|08:00:11.1328|<UNK>|  GetFileName result https://imfxv3tm.tmd.tv/VideoServer/England vs South Africa  Match 1.mp4
t Verbose: 1220 :      12|08:00:11.1328|<UNK>|GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/England vs South Africa  Match 1.mp4
t Transfer: 1220 :     12|08:00:11.1328|<UNK>|GetCurrentUser..
t Transfer: 1220 :     12|08:00:11.1328|<UNK>|  OAuth authenticated
t Transfer: 1220 :     12|08:00:11.1328|<UNK>|    user TONY.
t Verbose: 1220 :      12|08:00:11.1328|<UNK>|GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\West Indies vs Pakistan Match 2.mp4 subfolder 
t Verbose: 1220 :      12|08:00:11.1328|<UNK>|  GetFileName result https://imfxv3tm.tmd.tv/VideoServer/West Indies vs Pakistan Match 2.mp4
t Verbose: 1220 :      12|08:00:11.1328|<UNK>|GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/West Indies vs Pakistan Match 2.mp4
t Transfer: 1220 :     12|08:00:11.1328|<UNK>|GetCurrentUser..
t Transfer: 1220 :     12|08:00:11.1328|<UNK>|  OAuth authenticated
t Transfer: 1220 :     12|08:00:11.1328|<UNK>|    user TONY.
t Verbose: 1220 :      12|08:00:11.1328|<UNK>|GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\New Zealand vs England  Final.mp4 subfolder 
t Verbose: 1220 :      12|08:00:11.1328|<UNK>|  GetFileName result https://imfxv3tm.tmd.tv/VideoServer/New Zealand vs England  Final.mp4
t Verbose: 1220 :      12|08:00:11.1328|<UNK>|GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/New Zealand vs England  Final.mp4
t Transfer: 1220 :     12|08:00:11.1328|<UNK>|GetCurrentUser..
t Transfer: 1220 :     12|08:00:11.1328|<UNK>|  OAuth authenticated
t Transfer: 1220 :     12|08:00:11.1328|<UNK>|    user TONY.
t Verbose: 1220 :      12|08:00:11.1328|<UNK>|GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Australia vs England Short Semi Final 2.mp4 subfolder 
t Verbose: 1220 :      12|08:00:11.1328|<UNK>|  GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Australia vs England Short Semi Final 2.mp4
t Verbose: 1220 :      12|08:00:11.1328|<UNK>|GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/Australia vs England Short Semi Final 2.mp4
t Transfer: 1220 :     12|08:00:11.1328|<UNK>|GetCurrentUser..
t Transfer: 1220 :     12|08:00:11.1328|<UNK>|  OAuth authenticated
t Transfer: 1220 :     12|08:00:11.1328|<UNK>|    user TONY.
t Verbose: 1220 :      12|08:00:11.1328|<UNK>|GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\India vs New Zealand  Semi Final 1.mp4 subfolder 
t Verbose: 1220 :      12|08:00:11.1328|<UNK>|  GetFileName result https://imfxv3tm.tmd.tv/VideoServer/India vs New Zealand  Semi Final 1.mp4
t Verbose: 1220 :      12|08:00:11.1328|<UNK>|GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/India vs New Zealand  Semi Final 1.mp4
t Transfer: 1220 :     12|08:00:11.1328|<UNK>|GetCurrentUser..
t Transfer: 1220 :     12|08:00:11.1328|<UNK>|  OAuth authenticated
t Transfer: 1220 :     12|08:00:11.1328|<UNK>|    user TONY.
t Verbose: 1220 :      12|08:00:11.1485|<UNK>|GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\South Africa vs Bangladesh Match 5 .mp4 subfolder 
t Verbose: 1220 :      12|08:00:11.1485|<UNK>|  GetFileName result https://imfxv3tm.tmd.tv/VideoServer/South Africa vs Bangladesh Match 5 .mp4
t Verbose: 1220 :      12|08:00:11.1485|<UNK>|GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/South Africa vs Bangladesh Match 5 .mp4
t Transfer: 1220 :     12|08:00:11.1485|<UNK>|GetCurrentUser..
t Transfer: 1220 :     12|08:00:11.1485|<UNK>|  OAuth authenticated
t Transfer: 1220 :     12|08:00:11.1485|<UNK>|    user TONY.
t Verbose: 1220 :      12|08:00:11.1485|<UNK>|GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\New Zealand vs Sri Lanka  Match 3.mp4 subfolder 
t Verbose: 1220 :      12|08:00:11.1485|<UNK>|  GetFileName result https://imfxv3tm.tmd.tv/VideoServer/New Zealand vs Sri Lanka  Match 3.mp4
t Verbose: 1220 :      12|08:00:11.1485|<UNK>|GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/New Zealand vs Sri Lanka  Match 3.mp4
t Transfer: 1220 :     12|08:00:11.1485|<UNK>|GetCurrentUser..
t Transfer: 1220 :     12|08:00:11.1485|<UNK>|  OAuth authenticated
t Transfer: 1220 :     12|08:00:11.1485|<UNK>|    user TONY.
t Verbose: 1220 :      12|08:00:11.1485|<UNK>|GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Afghanistan vs Australia  Match 4.mp4 subfolder 
t Verbose: 1220 :      12|08:00:11.1485|<UNK>|  GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Afghanistan vs Australia  Match 4.mp4
t Verbose: 1220 :      12|08:00:11.1485|<UNK>|GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/Afghanistan vs Australia  Match 4.mp4
t Transfer: 1220 :     12|08:00:11.1485|<UNK>|GetCurrentUser..
t Transfer: 1220 :     12|08:00:11.1485|<UNK>|  OAuth authenticated
t Transfer: 1220 :     12|08:00:11.1485|<UNK>|    user TONY.
t Verbose: 1220 :      12|08:00:11.1485|<UNK>|GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Bangladesh vs New Zealand  Match 9.mp4 subfolder 
t Verbose: 1220 :      12|08:00:11.1485|<UNK>|  GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Bangladesh vs New Zealand  Match 9.mp4
t Verbose: 1220 :      12|08:00:11.1485|<UNK>|GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/Bangladesh vs New Zealand  Match 9.mp4
t Transfer: 1220 :     12|08:00:11.1485|<UNK>|GetCurrentUser..
t Transfer: 1220 :     12|08:00:11.1485|<UNK>|  OAuth authenticated
t Transfer: 1220 :     12|08:00:11.1485|<UNK>|    user TONY.
t Verbose: 1220 :      12|08:00:11.1485|<UNK>|GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Afghanistan vs Sri Lanka  Match 7.mp4 subfolder 
t Verbose: 1220 :      12|08:00:11.1485|<UNK>|  GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Afghanistan vs Sri Lanka  Match 7.mp4
t Verbose: 1220 :      12|08:00:11.1485|<UNK>|GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/Afghanistan vs Sri Lanka  Match 7.mp4
t Transfer: 1220 :     12|08:00:11.1485|<UNK>|GetCurrentUser..
t Transfer: 1220 :     12|08:00:11.1485|<UNK>|  OAuth authenticated
t Transfer: 1220 :     12|08:00:11.1485|<UNK>|    user TONY.
t Verbose: 1220 :      12|08:00:11.1485|<UNK>|GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Australia vs West Indies Match 10.mp4 subfolder 
t Verbose: 1220 :      12|08:00:11.1485|<UNK>|  GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Australia vs West Indies Match 10.mp4
t Verbose: 1220 :      12|08:00:11.1485|<UNK>|GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/Australia vs West Indies Match 10.mp4
t Transfer: 1220 :     12|08:00:11.1485|<UNK>|GetCurrentUser..
t Transfer: 1220 :     12|08:00:11.1485|<UNK>|  OAuth authenticated
t Transfer: 1220 :     12|08:00:11.1485|<UNK>|    user TONY.
t Verbose: 1220 :      12|08:00:11.1485|<UNK>|GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\South Africa vs India  Match 8.mp4 subfolder 
t Verbose: 1220 :      12|08:00:11.1485|<UNK>|  GetFileName result https://imfxv3tm.tmd.tv/VideoServer/South Africa vs India  Match 8.mp4
t Verbose: 1220 :      12|08:00:11.1485|<UNK>|GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/South Africa vs India  Match 8.mp4
t Transfer: 1220 :     12|08:00:11.1485|<UNK>|GetCurrentUser..
t Transfer: 1220 :     12|08:00:11.1485|<UNK>|  OAuth authenticated
t Transfer: 1220 :     12|08:00:11.1485|<UNK>|    user TONY.
t Verbose: 1220 :      12|08:00:11.1485|<UNK>|GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\England vs Pakistan  Match 6.mp4 subfolder 
t Verbose: 1220 :      12|08:00:11.1485|<UNK>|  GetFileName result https://imfxv3tm.tmd.tv/VideoServer/England vs Pakistan  Match 6.mp4
t Verbose: 1220 :      12|08:00:11.1485|<UNK>|GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/England vs Pakistan  Match 6.mp4
t Transfer: 1220 :     12|08:00:11.1485|<UNK>|GetCurrentUser..
t Transfer: 1220 :     12|08:00:11.1485|<UNK>|  OAuth authenticated
t Transfer: 1220 :     12|08:00:11.1485|<UNK>|    user TONY.
t Verbose: 1220 :      12|08:00:11.1485|<UNK>|GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Pakistan vs Sri Lanka  Match 11.mp4 subfolder 
t Verbose: 1220 :      12|08:00:11.1485|<UNK>|  GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Pakistan vs Sri Lanka  Match 11.mp4
t Verbose: 1220 :      12|08:00:11.1485|<UNK>|GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/Pakistan vs Sri Lanka  Match 11.mp4
t Transfer: 1220 :     12|08:00:11.1485|<UNK>|GetCurrentUser..
t Transfer: 1220 :     12|08:00:11.1485|<UNK>|  OAuth authenticated
t Transfer: 1220 :     12|08:00:11.1485|<UNK>|    user TONY.
t Verbose: 1220 :      12|08:00:11.1485|<UNK>|GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\England v Bangladesh Match Group A.mp4 subfolder 
t Verbose: 1220 :      12|08:00:11.1485|<UNK>|  GetFileName result https://imfxv3tm.tmd.tv/VideoServer/England v Bangladesh Match Group A.mp4
t Verbose: 1220 :      12|08:00:11.1485|<UNK>|GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/England v Bangladesh Match Group A.mp4
t Transfer: 1220 :     12|08:00:11.1485|<UNK>|GetCurrentUser..
t Transfer: 1220 :     12|08:00:11.1485|<UNK>|  OAuth authenticated
t Transfer: 1220 :     12|08:00:11.1485|<UNK>|    user TONY.
t Verbose: 1220 :      12|08:00:11.1485|<UNK>|GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\ICC 360 Cricket for Change.mp4 subfolder 
t Verbose: 1220 :      12|08:00:11.1485|<UNK>|  GetFileName result https://imfxv3tm.tmd.tv/VideoServer/ICC 360 Cricket for Change.mp4
t Verbose: 1220 :      12|08:00:11.1485|<UNK>|GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/ICC 360 Cricket for Change.mp4
t Transfer: 1220 :     12|08:00:11.1485|<UNK>|GetCurrentUser..
t Transfer: 1220 :     12|08:00:11.1485|<UNK>|  OAuth authenticated
t Transfer: 1220 :     12|08:00:11.1485|<UNK>|    user TONY.
t Verbose: 1220 :      12|08:00:11.1485|<UNK>|GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Scotland vs Oman 5th Place Play Off.mp4 subfolder 
t Verbose: 1220 :      12|08:00:11.1485|<UNK>|  GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Scotland vs Oman 5th Place Play Off.mp4
t Verbose: 1220 :      12|08:00:11.1485|<UNK>|GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/Scotland vs Oman 5th Place Play Off.mp4
t Transfer: 1220 :     12|08:00:11.1485|<UNK>|GetCurrentUser..
t Transfer: 1220 :     12|08:00:11.1485|<UNK>|  OAuth authenticated
t Transfer: 1220 :     12|08:00:11.1485|<UNK>|    user TONY.
t Transfer: 1220 :      6|08:00:12.7109|<UNK>|IsUserAuthenticated: /api/user-preferences?_dc=1575964812720
t Transfer: 1220 :      6|08:00:12.7109|<UNK>|GetCurrentUser..
t Transfer: 1220 :      6|08:00:12.7109|<UNK>|  OAuth authenticated
t Transfer: 1220 :      6|08:00:12.7109|<UNK>|    user TONY.
t Transfer: 1220 :      6|08:00:12.7109|<UNK>|api user: TONY
t Verbose: 1220 :       6|08:00:12.7109|<UNK>|StoreUserDataByKeys..
t Transfer: 1220 :      6|08:00:12.7109|<UNK>|GetCurrentUser..
t Transfer: 1220 :      6|08:00:12.7109|<UNK>|  OAuth authenticated
t Transfer: 1220 :      6|08:00:12.7109|<UNK>|    user TONY.
t Transfer: 1220 :      7|08:00:18.9453|<UNK>|IsUserAuthenticated: /api/user-group-preferences?globals=htmlplayerhotkeys,audioOnFrameForward&_dc=1575964818955
t Transfer: 1220 :      7|08:00:18.9453|<UNK>|GetCurrentUser..
t Transfer: 1220 :      7|08:00:18.9453|<UNK>|  OAuth authenticated
t Transfer: 1220 :      7|08:00:18.9453|<UNK>|    user TONY.
t Transfer: 1220 :      7|08:00:18.9453|<UNK>|api user: TONY
t Information: 1220 :   7|08:00:18.9453|<UNK>|V3Api.GetUserSettings
t Transfer: 1220 :      7|08:00:18.9453|<UNK>|GetCurrentUser..
t Transfer: 1220 :      7|08:00:18.9453|<UNK>|  OAuth authenticated
t Transfer: 1220 :      7|08:00:18.9453|<UNK>|    user TONY.
t Transfer: 1220 :     18|08:00:19.4922|<UNK>|IsUserAuthenticated: /api/user-group-preferences?globals=htmlplayerhotkeys,audioOnFrameForward&_dc=1575964819501
t Transfer: 1220 :     18|08:00:19.4922|<UNK>|GetCurrentUser..
t Transfer: 1220 :     18|08:00:19.4922|<UNK>|  OAuth authenticated
t Transfer: 1220 :     18|08:00:19.4922|<UNK>|    user TONY.
t Transfer: 1220 :     18|08:00:19.4922|<UNK>|api user: TONY
t Information: 1220 :  18|08:00:19.4922|<UNK>|V3Api.GetUserSettings
t Transfer: 1220 :     18|08:00:19.4922|<UNK>|GetCurrentUser..
t Transfer: 1220 :     18|08:00:19.4922|<UNK>|  OAuth authenticated
t Transfer: 1220 :     18|08:00:19.4922|<UNK>|    user TONY.
t Transfer: 1220 :      6|08:00:19.8359|<UNK>|IsUserAuthenticated: /api/user-group-preferences?globals=htmlplayerhotkeys,audioOnFrameForward&_dc=1575964819839
t Transfer: 1220 :      6|08:00:19.8359|<UNK>|GetCurrentUser..
t Transfer: 1220 :      6|08:00:19.8359|<UNK>|  OAuth authenticated
t Transfer: 1220 :      6|08:00:19.8359|<UNK>|    user TONY.
t Transfer: 1220 :      6|08:00:19.8359|<UNK>|api user: TONY
t Information: 1220 :   6|08:00:19.8359|<UNK>|V3Api.GetUserSettings
t Transfer: 1220 :      6|08:00:19.8359|<UNK>|GetCurrentUser..
t Transfer: 1220 :      6|08:00:19.8359|<UNK>|  OAuth authenticated
t Transfer: 1220 :      6|08:00:19.8359|<UNK>|    user TONY.
t Transfer: 1220 :     10|08:00:23.6641|<UNK>|IsUserAuthenticated: /api/user-group-preferences?globals=htmlplayerhotkeys,audioOnFrameForward&_dc=1575964823653
t Transfer: 1220 :     10|08:00:23.6641|<UNK>|GetCurrentUser..
t Transfer: 1220 :     10|08:00:23.6641|<UNK>|  OAuth authenticated
t Transfer: 1220 :     10|08:00:23.6641|<UNK>|    user TONY.
t Transfer: 1220 :     10|08:00:23.6641|<UNK>|api user: TONY
t Information: 1220 :  10|08:00:23.6641|<UNK>|V3Api.GetUserSettings
t Transfer: 1220 :     10|08:00:23.6641|<UNK>|GetCurrentUser..
t Transfer: 1220 :     10|08:00:23.6641|<UNK>|  OAuth authenticated
t Transfer: 1220 :     10|08:00:23.6641|<UNK>|    user TONY.
t Transfer: 1220 :     25|08:00:23.9765|<UNK>|IsUserAuthenticated: /api/user-group-preferences?globals=htmlplayerhotkeys,audioOnFrameForward&_dc=1575964823945
t Transfer: 1220 :     25|08:00:23.9765|<UNK>|GetCurrentUser..
t Transfer: 1220 :     25|08:00:23.9765|<UNK>|  OAuth authenticated
t Transfer: 1220 :     25|08:00:23.9765|<UNK>|    user TONY.
t Transfer: 1220 :     25|08:00:23.9765|<UNK>|api user: TONY
t Information: 1220 :  25|08:00:23.9765|<UNK>|V3Api.GetUserSettings
t Transfer: 1220 :     25|08:00:23.9765|<UNK>|GetCurrentUser..
t Transfer: 1220 :     25|08:00:23.9765|<UNK>|  OAuth authenticated
t Transfer: 1220 :     25|08:00:23.9765|<UNK>|    user TONY.
t Transfer: 1220 :     12|08:00:28.0547|<UNK>|IsUserAuthenticated: /api/search/Media?_dc=1575964828052
t Transfer: 1220 :     12|08:00:28.0547|<UNK>|GetCurrentUser..
t Transfer: 1220 :     12|08:00:28.0547|<UNK>|  OAuth authenticated
t Transfer: 1220 :     12|08:00:28.0547|<UNK>|    user TONY.
t Transfer: 1220 :     12|08:00:28.0547|<UNK>|api user: TONY
t Transfer: 1220 :      7|08:00:28.0547|<UNK>|IsUserAuthenticated: /api/lookups/FriendlyNames?_dc=1575964828051
t Transfer: 1220 :      7|08:00:28.0547|<UNK>|GetCurrentUser..
t Transfer: 1220 :      7|08:00:28.0547|<UNK>|  OAuth authenticated
t Transfer: 1220 :      7|08:00:28.0547|<UNK>|    user TONY.
t Transfer: 1220 :      7|08:00:28.0547|<UNK>|api user: TONY
t Information: 1220 :  12|08:00:28.0547|<UNK>|V3Api.SearchMedia
t Information: 1220 :  12|08:00:28.0547|<UNK>|V3Api.SearchGeneric
t Transfer: 1220 :     12|08:00:28.0703|<UNK>|GetCurrentUser..
t Transfer: 1220 :     12|08:00:28.0703|<UNK>|  OAuth authenticated
t Transfer: 1220 :     12|08:00:28.0703|<UNK>|    user TONY.
t Information: 1220 :  12|08:00:28.0703|<UNK>|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  m.ID=298533  and m.mi_deleted=0   AND (INSTR(m.OWNERS,'|ATP|')>0 OR INSTR(m.OWNERS,'|ICCCTY|')>0 OR INSTR(m.OWNERS,'|ICCCWC|')>0 OR INSTR(m.OWNERS,'|ICCCWL2|')>0 OR INSTR(m.OWNERS,'|ICCICC|')>0 OR INSTR(m.OWNERS,'|ICCTWT|')>0 OR INSTR(m.OWNERS,'|ICCU19CWC|')>0 OR INSTR(m.OWNERS,'|ICCWCCL|')>0 OR INSTR(m.OWNERS,'|ICCWCL|')>0 OR INSTR(m.OWNERS,'|ICCWCP|')>0 OR INSTR(m.OWNERS,'|ICCWTC|')>0 OR INSTR(m.OWNERS,'|ICCWTT|')>0 OR INSTR(m.OWNERS,'|ICCWWC|')>0 OR INSTR(m.OWNERS,'|OSP|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|TMD|')>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

t Transfer: 1220 :     17|08:00:28.0703|<UNK>|IsUserAuthenticated: /api/user-group-preferences?globals=htmlplayerhotkeys,audioOnFrameForward&_dc=1575964828107
t Transfer: 1220 :     17|08:00:28.0703|<UNK>|GetCurrentUser..
t Transfer: 1220 :     17|08:00:28.0703|<UNK>|  OAuth authenticated
t Transfer: 1220 :     17|08:00:28.0703|<UNK>|    user TONY.
t Transfer: 1220 :     17|08:00:28.0703|<UNK>|api user: TONY
t Information: 1220 :  17|08:00:28.0703|<UNK>|V3Api.GetUserSettings
t Transfer: 1220 :     17|08:00:28.0703|<UNK>|GetCurrentUser..
t Transfer: 1220 :     17|08:00:28.0703|<UNK>|  OAuth authenticated
t Transfer: 1220 :     17|08:00:28.0703|<UNK>|    user TONY.
t Information: 1220 :  12|08:00:28.1484|<UNK>|    timing: 00:00:00.0951488
t Verbose: 1220 :      12|08:00:28.1484|<UNK>|GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Australia vs South Africa  Match 45.mp4 subfolder 
t Verbose: 1220 :      12|08:00:28.1484|<UNK>|  GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Australia vs South Africa  Match 45.mp4
t Verbose: 1220 :      12|08:00:28.1641|<UNK>|GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/Australia vs South Africa  Match 45.mp4
t Transfer: 1220 :     12|08:00:28.1641|<UNK>|GetCurrentUser..
t Transfer: 1220 :     12|08:00:28.1641|<UNK>|  OAuth authenticated
t Transfer: 1220 :     12|08:00:28.1641|<UNK>|    user TONY.
t Transfer: 1220 :      6|08:00:28.1641|<UNK>|IsUserAuthenticated: /api/lookups/FriendlyNames?_dc=1575964828201
t Transfer: 1220 :      6|08:00:28.1641|<UNK>|GetCurrentUser..
t Transfer: 1220 :      6|08:00:28.1641|<UNK>|  OAuth authenticated
t Transfer: 1220 :      6|08:00:28.1641|<UNK>|    user TONY.
t Transfer: 1220 :      6|08:00:28.1641|<UNK>|api user: TONY
t Transfer: 1220 :      5|08:00:28.1641|<UNK>|IsUserAuthenticated: /api/media-captions/298533?_dc=1575964828202
t Transfer: 1220 :      5|08:00:28.1641|<UNK>|GetCurrentUser..
t Transfer: 1220 :      5|08:00:28.1641|<UNK>|  OAuth authenticated
t Transfer: 1220 :      5|08:00:28.1641|<UNK>|    user TONY.
t Transfer: 1220 :      5|08:00:28.1641|<UNK>|api user: TONY
t Information: 1220 :  18|08:00:28.1797|<UNK>|V3Api.GetMediaTagging
t Transfer: 1220 :     29|08:00:28.1797|<UNK>|IsUserAuthenticated: /api/v3/detailsview/MediaDetails/5?lang=en-US&_dc=1575964828200
t Transfer: 1220 :     29|08:00:28.1797|<UNK>|GetCurrentUser..
t Transfer: 1220 :     29|08:00:28.1797|<UNK>|  OAuth authenticated
t Transfer: 1220 :     29|08:00:28.1797|<UNK>|    user TONY.
t Transfer: 1220 :     29|08:00:28.1797|<UNK>|api user: TONY
t Transfer: 1220 :     17|08:00:28.1797|<UNK>|IsUserAuthenticated: /api/mediavideo/298533?info=smudge&_dc=1575964828210
t Transfer: 1220 :     17|08:00:28.1797|<UNK>|GetCurrentUser..
t Transfer: 1220 :     17|08:00:28.1797|<UNK>|  OAuth authenticated
t Transfer: 1220 :     17|08:00:28.1797|<UNK>|    user TONY.
t Transfer: 1220 :     17|08:00:28.1797|<UNK>|api user: TONY
t Verbose: 1220 :      17|08:00:28.1954|<UNK>|GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Australia vs South Africa  Match 45.mp4 subfolder 
t Verbose: 1220 :      17|08:00:28.1954|<UNK>|  GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Australia vs South Africa  Match 45.mp4
t Verbose: 1220 :      17|08:00:28.1954|<UNK>|GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/Australia vs South Africa  Match 45.mp4
t Transfer: 1220 :     17|08:00:28.1954|<UNK>|GetCurrentUser..
t Transfer: 1220 :     17|08:00:28.1954|<UNK>|  OAuth authenticated
t Transfer: 1220 :     17|08:00:28.1954|<UNK>|    user TONY.
t Transfer: 1220 :     25|08:00:28.3047|<UNK>|IsUserAuthenticated: /api/search/Media?_dc=1575964828334
t Transfer: 1220 :     25|08:00:28.3047|<UNK>|GetCurrentUser..
t Transfer: 1220 :     25|08:00:28.3047|<UNK>|  OAuth authenticated
t Transfer: 1220 :     25|08:00:28.3047|<UNK>|    user TONY.
t Transfer: 1220 :     25|08:00:28.3047|<UNK>|api user: TONY
t Information: 1220 :  25|08:00:28.3047|<UNK>|V3Api.SearchMedia
t Information: 1220 :  25|08:00:28.3047|<UNK>|V3Api.SearchGeneric
t Transfer: 1220 :     25|08:00:28.3047|<UNK>|GetCurrentUser..
t Transfer: 1220 :     25|08:00:28.3047|<UNK>|  OAuth authenticated
t Transfer: 1220 :     25|08:00:28.3047|<UNK>|    user TONY.
t Information: 1220 :  25|08:00:28.3047|<UNK>|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  m.ID=298533  and m.mi_deleted=0   AND (INSTR(m.OWNERS,'|ATP|')>0 OR INSTR(m.OWNERS,'|ICCCTY|')>0 OR INSTR(m.OWNERS,'|ICCCWC|')>0 OR INSTR(m.OWNERS,'|ICCCWL2|')>0 OR INSTR(m.OWNERS,'|ICCICC|')>0 OR INSTR(m.OWNERS,'|ICCTWT|')>0 OR INSTR(m.OWNERS,'|ICCU19CWC|')>0 OR INSTR(m.OWNERS,'|ICCWCCL|')>0 OR INSTR(m.OWNERS,'|ICCWCL|')>0 OR INSTR(m.OWNERS,'|ICCWCP|')>0 OR INSTR(m.OWNERS,'|ICCWTC|')>0 OR INSTR(m.OWNERS,'|ICCWTT|')>0 OR INSTR(m.OWNERS,'|ICCWWC|')>0 OR INSTR(m.OWNERS,'|OSP|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|TMD|')>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

t Information: 1220 :  25|08:00:28.3047|<UNK>|    timing: 00:00:00.0112728
t Verbose: 1220 :      25|08:00:28.3047|<UNK>|GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Australia vs South Africa  Match 45.mp4 subfolder 
t Verbose: 1220 :      25|08:00:28.3047|<UNK>|  GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Australia vs South Africa  Match 45.mp4
t Verbose: 1220 :      25|08:00:28.3047|<UNK>|GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/Australia vs South Africa  Match 45.mp4
t Transfer: 1220 :     25|08:00:28.3047|<UNK>|GetCurrentUser..
t Transfer: 1220 :     25|08:00:28.3047|<UNK>|  OAuth authenticated
t Transfer: 1220 :     25|08:00:28.3047|<UNK>|    user TONY.
t Transfer: 1220 :      7|08:00:38.6016|<UNK>|IsUserAuthenticated: /api/user-group-preferences?globals=htmlplayerhotkeys,audioOnFrameForward&_dc=1575964838626
t Transfer: 1220 :      7|08:00:38.6016|<UNK>|GetCurrentUser..
t Transfer: 1220 :      7|08:00:38.6016|<UNK>|  OAuth authenticated
t Transfer: 1220 :      7|08:00:38.6016|<UNK>|    user TONY.
t Transfer: 1220 :      7|08:00:38.6016|<UNK>|api user: TONY
t Information: 1220 :   7|08:00:38.6016|<UNK>|V3Api.GetUserSettings
t Transfer: 1220 :      7|08:00:38.6172|<UNK>|GetCurrentUser..
t Transfer: 1220 :      7|08:00:38.6172|<UNK>|  OAuth authenticated
t Transfer: 1220 :      7|08:00:38.6172|<UNK>|    user TONY.
t Information: 1220 :  98|08:21:15.4297|<UNK>|OrabitWatcherBasic. Disposing.
t Information: 1220 :  98|08:21:15.4297|<UNK>|OrabitWatcherBasic. Disposed.
t Information: 1220 :  98|08:21:15.4297|<UNK>|==========================================================================
t Information: 1220 :  98|08:21:15.4297|<UNK>|IMFX CORE SERVER APPLICATION END.