t Information: 1220 :   9|13:02:16.3432|||Get Configuration Values:
t Information: 1220 :   9|13:02:16.3432|||	AdminPassEnc, default: , value: ffqjrn0leKv4Lj2YJHe2dw==.
t Information: 1220 :   9|13:02:16.3432|||	EncryptedPasswords, default: false, value: true.
t Information: 1220 :   9|13:02:16.3432|||	OraConnectionString, default: , value: Server=TECHM;User Id=imfx;Password=xxxxx;Unicode=true;.
t Information: 1220 :   9|13:02:16.3432|||	SecondTimezone, default: , value: .
t Information: 1220 :   9|13:02:16.3588|||	UseActiveDirectoryAuth, default: false, value: false.
t Information: 1220 :   9|13:02:16.3588|||	ReportingServiceUrl, default: , value: http://localhost:92/ReportingService.svc.
t Information: 1220 :   9|13:02:16.3588|||	ReportsPath, default: , value: .
t Information: 1220 :   9|13:02:16.3588|||	ReportsURL, default: , value: .
t Information: 1220 :   9|13:02:16.3588|||	TapeServiceUrl, default: , value: .
t Information: 1220 :   9|13:02:16.3588|||	GatekeeperUrl, default: , value: .
t Information: 1220 :   9|13:02:16.3588|||	ValuationUrl, default: , value: .
t Information: 1220 :   9|13:02:16.3588|||	QueueManagerDelay, default: 30, value: 30.
t Information: 1220 :   9|13:02:16.3588|||	QueueManagerFullRefresh, default: 90, value: 90.
t Information: 1220 :   9|13:02:16.3588|||	AudioLoopDuration, default: 0, value: 150.
t Information: 1220 :   9|13:02:16.3588|||	AudioLoopsCount, default: 0, value: 0.
t Information: 1220 :   9|13:02:16.3588|||	PlayerFakeStep, default: 500, value: 500.
t Information: 1220 :   9|13:02:16.3588|||	PlayerForceRatio, default: 0, value: 1.
t Information: 1220 :   9|13:02:16.3588|||	CheckVersionsInProd, default: false, value: True.
t Information: 1220 :   9|13:02:16.3588|||	MaxResults, default: 3000, value: 10000.
t Information: 1220 :   9|13:02:16.3588|||	NetworkRestriction, default: false, value: True.
t Information: 1220 :   9|13:02:16.3588|||	TEReportID, default: 0, value: 0.
t Information: 1220 :   9|13:02:16.3588|||	ClosedCaptionsCache, default: , value: C:\inetpub\wwwroot\imfxcore\timedtextcache\.
t Information: 1220 :   9|13:02:16.3588|||	ClosedCaptionsStorage, default: , value: c:\Mediaflex\subs.
t Information: 1220 :   9|13:02:16.3588|||	TimeCodeFormat, default: , value: pal.
t Information: 1220 :   9|13:02:16.3588|||	RceMediaPath, default: , value: C:\edl\.
t Information: 1220 :   9|13:02:16.3588|||	RceMediaPath, default: , value: C:\edl\.
t Information: 1220 :   9|13:02:16.3588|||	RceCsmOutputPath, default: , value: C:\Inetpub\wwwroot\csm\.
t Information: 1220 :   9|13:02:16.3588|||	RceCsmUrl, default: , value: http://localhost/csm/.
t Information: 1220 :   9|13:02:16.3588|||	RceMediaSelection, default: , value: miLinkIdMatch.
t Information: 1220 :   9|13:02:16.3588|||	RequestBrowseJobPresetName, default: , value: .
t Information: 1220 :   9|13:02:16.3588|||	DontExtendDuration, default: false, value: False.
t Information: 1220 :   9|13:02:16.3588|||	V3ConfigUrl, default: , value: .
t Information: 1220 :   9|13:02:16.3588|||	StopWords, default: , value: .
t Information: 1220 :   9|13:02:16.3588|||	MisrTxFormat, default: G, value: G.
t Information: 1220 :   9|13:02:16.3588|||	ApiServer, default: , value: http://192.168.120.10:85.
t Information: 1220 :   9|13:02:16.3588|||	ApiTimeout, default: 120, value: 120.
t Information: 1220 :   9|13:02:16.3588|||	ApiWorkers, default: 10, value: 10.
t Information: 1220 :   9|13:02:16.3588|||	UsePerfCounters, default: false, value: false.
t Information: 1220 :   9|13:02:16.3588|||	StatsdAddress, default: , value: .
t Information: 1220 :   9|13:02:16.3588|||	LogGetCurrentUser, default: true, value: true.
t Information: 1220 :   9|13:02:16.3588|||	LogInternalApi, default: true, value: true.
t Information: 1220 :   9|13:02:16.3588|||	ThumbnailServer, default: , value: .
t Information: 1220 :   9|13:02:16.3588|||	LocationFilter, default: , value: .
t Information: 1220 :   9|13:02:16.3588|||	SvUtilServiceUrl, default: , value: .
t Information: 1220 :   9|13:02:16.3588|||	SolrConnection, default: , value: http://192.168.120.14:8983/solr.
t Information: 1220 :   9|13:02:16.3588|||	UseIndexServerSearch, default: false, value: True.
t Information: 1220 :   9|13:02:16.3588|||	SolrIndexVersion, default: 1, value: 6.
t Information: 1220 :   9|13:02:16.3588|||	SolrConnection, default: , value: http://192.168.120.14:8983/solr.
t Information: 1220 :   9|13:02:16.3588|||	FacetsGroups, default: , value: owners,season_id, series_id,version_key,item_type,media_type,media_format,episode_number.
t Information: 1220 :   9|13:02:16.3588|||	FacetsGroupsVersion, default: , value: owners,season_id, series_id,version_key,episode_number.
t Information: 1220 :   9|13:02:16.3588|||	FacetsGroupsChameleon, default: , value: season_id, series_id,genre,prod_year,version_key.
t Information: 1220 :   9|13:02:16.3588|||	PreviewPreset, default: , value: .
t Information: 1220 :   9|13:02:16.3588|||	DevMode, default: false, value: false.
t Information: 1220 :   9|13:02:16.3588|||	DisableSysMan, default: false, value: false.
t Information: 1220 :   9|13:02:16.3588|||	TimeCodeFormat, default: , value: pal.
t Information: 1220 :   9|13:02:16.3588|||	FileCatalystStorageDevice, default: , value: .
t Information: 1220 :   9|13:02:16.3588|||	UseResponsibilityTracking, default: true, value: True.
t Information: 1220 :   9|13:02:16.3588|||	SubtitleDeviceFilter, default: , value: .
t Information: 1220 :   9|13:02:16.3588|||	SystemMonitorNamedPipe, default: , value: .
t Information: 1220 :   9|13:02:16.3588|||	OracleMonitorEnable, default: false, value: False.
t Information: 1220 :   9|13:02:16.3588|||	ArcApiHost, default: , value: .
t Information: 1220 :   9|13:02:16.3588|||	RabbitMqUrl, default: , value: amqp://192.168.120.14:5672.
t Information: 1220 :   9|13:02:16.3588|||	SolrTimedTextSearch, default: false, value: false.
t Information: 1220 :   9|13:02:16.3588|||	ProductionDurationUsageID, default: 1, value: 1.
t Information: 1220 :   9|13:02:16.5775|||GetStreamServers..
t Information: 1220 :   9|13:02:16.9838|||	https://demo.tmd.tv/CBR Video/ |CBR Video| False  
t Information: 1220 :   9|13:02:16.9838|||	https://demo.tmd.tv/CBR Images/ |CBR Images| False  
t Information: 1220 :   9|13:02:16.9838|||	https://demo.tmd.tv/CBR Audio/ |CBR Audio| False  
t Information: 1220 :   9|13:02:16.9838|||	https://demo.tmd.tv/Temp Upload/ |TEMP_UPLOAD| False  
t Information: 1220 :   9|13:02:16.9838|||	http://localhost:82/images/ |IMAGES| False  
t Information: 1220 :   9|13:02:16.9838|||	http://192.168.91.73/smoothcloud/ |SMOOTH_CLOUD| False  
t Information: 1220 :   9|13:02:16.9838|||	http://192.168.91.73/cloudstore/ |CLOUD_STORE| False  
t Information: 1220 :   9|13:02:16.9838|||	http://192.168.91.73/editsystemin/ |EDIT_SYSTEM_IN| False  
t Information: 1220 :   9|13:02:16.9838|||	http://192.168.91.27:89/APPLEPROXY/ |APPLE_PROXY| False  
t Information: 1220 :   9|13:02:16.9838|||	http://localhost:82/video/ |FILESTORE_VIDEO| False  
t Information: 1220 :   9|13:02:16.9838|||	https://imfxv3tm.tmd.tv/streaming/ |Streaming| False  
t Information: 1220 :   9|13:02:16.9838|||	https://imfxv3tm.tmd.tv/VideoServer/ |Video| False  
t Information: 1220 :   9|13:02:16.9838|||	https://imfxv3tm.tmd.tv/AdobeIn/ |Adobe Premiere Pro In| False  
t Information: 1220 :   9|13:02:16.9838|||	https://imfxv3tm.tmd.tv/AudioServer/ |Audio| False  
t Information: 1220 :   9|13:02:16.9838|||	https://imfxv3tm.tmd.tv/ImageServer/ |Image| False  
t Information: 1220 :   9|13:02:16.9838|||	https://imfxv3tm.tmd.tv/DocsServer/ |Docs| False  
t Information: 1220 :   9|13:02:16.9838|||	https://imfxv3tm.tmd.tv/AmazonLabs/ |TEST HOUSE| False  
t Information: 1220 :   9|13:02:16.9838|||	SolrConnectionUms, default: http://192.168.120.14:8983/solr, value: http://192.168.120.14:8983/solr.
t Information: 1220 :   9|13:02:16.9838|||	LogWebApi, default: false, value: false.
t Information: 1220 :   9|13:02:16.9838|||	EmbeddedRceUrl, default: , value: .
t Information: 1220 :   9|13:02:16.9838|||	InstallMode, default: , value: .
t Information: 1220 :   9|13:02:16.9838|||	SamlRequestAddress, default: , value: .
t Information: 1220 :   9|13:02:16.9838|||	SamlTrustedIssuer, default: , value: .
t Information: 1220 :   9|13:02:16.9838|||	SamlLoginRedirect, default: , value: .
t Information: 1220 :   9|13:02:16.9838|||	NaturalLangSearch, default: false, value: True.
t Information: 1220 :   9|13:02:16.9838|||	OktaLoginField, default: , value: .
t Information: 1220 :   9|13:02:16.9838|||	AuthenticationTypes, default: , value: Native,PublicApiKey.
t Information: 1220 :   9|13:02:16.9838|||OrabitWatcherBasic. Initialize.
t Information: 1220 :   9|13:02:16.9838|||FillDictionaryCache.
t Information: 1220 :   9|13:02:20.6557|||GetSupportedOperators
t Information: 1220 :   9|13:02:21.0776|||CacheTechReports.
t Information: 1220 :   9|13:02:21.0776|||& Cache update. Server (global) filled with timestamp 01:05:20.9682084. types null
t Information: 1220 :   9|13:02:21.0776|||InitializeFromDatabase.
  'Server=TECHM;User Id=imfx;password=..;Unicode=true;'
  direct False, home , timeout 15
t Information: 1220 :   9|13:02:21.0776|||FillDictionaryCache.
t Information: 1220 :   9|13:02:21.0776|||& Cache update. Server (global) filled with timestamp 01:05:21.0619638. types FriendlyNames, DatabaseSearchFieldData
t Information: 1220 :   9|13:02:21.6869|||==========================================================================
t Information: 1220 :   9|13:02:21.6869|||IMFX CORE SERVER APPLICATION START.
t Information: 1220 :   9|13:02:21.6869|||DLL VERSION: 2.5.0.2610.
t Information: 1220 :   9|13:02:21.6869|||IS TIMER HIGH RESOULTION : True.
t Information: 1220 :   9|13:02:21.6869|||	UmsDev, default: False, value: False.
t Information: 1220 :   9|13:02:21.8901|||OrabitWatcherBasic trying to connect..
t Information: 1220 :   9|13:02:22.1088|||OrabitWatcherBasic connected.
t Information: 1220 :   9|13:02:22.1088|||OrabitWatcherBasic queue created tmd.cfg.in.a93ad2fd-5b72-4749-bb9e-1a64b9e6ddd5
t Transfer: 1220 :      9|13:02:24.3588|zpLSxL|BORISLAVD|OAuth: /api/view/searches/TitleSearch?_dc=1588852935184
t Transfer: 1220 :      9|13:02:24.3588|nd7e7e|BORISLAVD|OAuth: /api/view/info/TitleTree?lang=en-US&_dc=1588852935159
t Transfer: 1220 :      9|13:02:24.3588|mOuKNF|BORISLAVD|OAuth: /api/user-preferences?keys=adv.recent.searches.titles&_dc=1588852935107
t Transfer: 1220 :      9|13:02:24.3588|VF0q0O|BORISLAVD|OAuth: /api/view/info/VersionGrid?lang=en-US&_dc=1588852935211
t Transfer: 1220 :      9|13:02:24.3588|kJqeN9|BORISLAVD|OAuth: /api/view/searchinfo/TitleSearch?_dc=1588852935102
t Transfer: 1220 :      9|13:02:24.3588|zpLSxL|BORISLAVD|GetCurrentUser..
t Transfer: 1220 :      9|13:02:24.3588|zpLSxL|BORISLAVD|  OAuth authenticated
t Transfer: 1220 :      9|13:02:24.3588|zpLSxL|BORISLAVD|    user BORISLAVD.
t Transfer: 1220 :      9|13:02:24.3588|VF0q0O|BORISLAVD|GetCurrentUser..
t Transfer: 1220 :      9|13:02:24.3588|VF0q0O|BORISLAVD|  OAuth authenticated
t Transfer: 1220 :      9|13:02:24.3588|VF0q0O|BORISLAVD|    user BORISLAVD.
t Transfer: 1220 :      9|13:02:24.3588|mOuKNF|BORISLAVD|GetCurrentUser..
t Transfer: 1220 :      9|13:02:24.3588|nd7e7e|BORISLAVD|GetCurrentUser..
t Transfer: 1220 :      9|13:02:24.3588|nd7e7e|BORISLAVD|  OAuth authenticated
t Transfer: 1220 :      9|13:02:24.3588|mOuKNF|BORISLAVD|  OAuth authenticated
t Transfer: 1220 :      9|13:02:24.3588|nd7e7e|BORISLAVD|    user BORISLAVD.
t Transfer: 1220 :      9|13:02:24.3588|mOuKNF|BORISLAVD|    user BORISLAVD.
t Verbose: 1220 :       9|13:02:24.3588|zpLSxL|BORISLAVD|OAuth. User logged in: BORISLAVD
t Verbose: 1220 :       9|13:02:24.3588|mOuKNF|BORISLAVD|OAuth. User logged in: BORISLAVD
t Verbose: 1220 :       9|13:02:24.3588|VF0q0O|BORISLAVD|OAuth. User logged in: BORISLAVD
t Verbose: 1220 :       9|13:02:24.3588|nd7e7e|BORISLAVD|OAuth. User logged in: BORISLAVD
t Transfer: 1220 :      9|13:02:24.3588|kJqeN9|BORISLAVD|GetCurrentUser..
t Transfer: 1220 :      9|13:02:24.3588|kJqeN9|BORISLAVD|  OAuth authenticated
t Transfer: 1220 :      9|13:02:24.3588|kJqeN9|BORISLAVD|    user BORISLAVD.
t Verbose: 1220 :       9|13:02:24.3588|kJqeN9|BORISLAVD|OAuth. User logged in: BORISLAVD
t Information: 1220 :   9|13:02:24.3588|mOuKNF|BORISLAVD|GetUserDataByKeys: adv.recent.searches.titles
t Transfer: 1220 :      9|13:02:24.3588|mOuKNF|BORISLAVD|GetCurrentUser..
t Transfer: 1220 :      9|13:02:24.3588|mOuKNF|BORISLAVD|  OAuth authenticated
t Transfer: 1220 :      9|13:02:24.3588|mOuKNF|BORISLAVD|    user BORISLAVD.
t Information: 1220 :   9|13:02:24.3588|VF0q0O|BORISLAVD|GetGridViewBuilder. builder type VersionGrid.
t Information: 1220 :   9|13:02:24.3588|nd7e7e|BORISLAVD|GetGridViewBuilder. builder type TitleTree.
t Information: 1220 :   9|13:02:24.3588|zpLSxL|BORISLAVD|GetSavedSearchNames. search type TitleSearch.
t Transfer: 1220 :      9|13:02:24.3588|zpLSxL|BORISLAVD|GetCurrentUser..
t Transfer: 1220 :      9|13:02:24.3588|zpLSxL|BORISLAVD|  OAuth authenticated
t Transfer: 1220 :      9|13:02:24.3588|zpLSxL|BORISLAVD|    user BORISLAVD.
t Transfer: 1220 :      9|13:02:24.3588|VF0q0O|BORISLAVD|GetCurrentUser..
t Transfer: 1220 :      9|13:02:24.3588|VF0q0O|BORISLAVD|  OAuth authenticated
t Transfer: 1220 :      9|13:02:24.3588|VF0q0O|BORISLAVD|    user BORISLAVD.
t Transfer: 1220 :      9|13:02:24.3588|nd7e7e|BORISLAVD|GetCurrentUser..
t Transfer: 1220 :      9|13:02:24.3588|nd7e7e|BORISLAVD|  OAuth authenticated
t Transfer: 1220 :      9|13:02:24.3588|nd7e7e|BORISLAVD|    user BORISLAVD.
t Information: 1220 :   9|13:02:24.3588|kJqeN9|BORISLAVD|GetAdvSearchColumns. search type TitleSearch grid .
t Information: 1220 :   9|13:02:24.3588|nd7e7e|BORISLAVD|UserGridView. LoadView. ID -2, Name Default.
t Transfer: 1220 :      9|13:02:24.3588|nd7e7e|BORISLAVD|GetCurrentUser..
t Transfer: 1220 :      9|13:02:24.3588|nd7e7e|BORISLAVD|  OAuth authenticated
t Transfer: 1220 :      9|13:02:24.3588|nd7e7e|BORISLAVD|    user BORISLAVD.
t Information: 1220 :   9|13:02:24.3588|VF0q0O|BORISLAVD|UserGridView. LoadView. ID -2, Name Default.
t Transfer: 1220 :      9|13:02:24.3588|VF0q0O|BORISLAVD|GetCurrentUser..
t Transfer: 1220 :      9|13:02:24.3588|VF0q0O|BORISLAVD|  OAuth authenticated
t Transfer: 1220 :      9|13:02:24.3588|VF0q0O|BORISLAVD|    user BORISLAVD.
t Verbose: 1220 :       9|13:02:24.3588|kJqeN9|BORISLAVD|imfx v3 API took 0.094s '/api/view/searchinfo/TitleSearch?_dc=1588852935102'
t Verbose: 1220 :       9|13:02:24.5776|mOuKNF|BORISLAVD|imfx v3 API took 0.114s '/api/user-preferences?keys=adv.recent.searches.titles&_dc=1588852935107'
t Verbose: 1220 :       9|13:02:24.5776|zpLSxL|BORISLAVD|imfx v3 API took 0.126s '/api/view/searches/TitleSearch?_dc=1588852935184'
t Transfer: 1220 :      9|13:02:24.5776|nd7e7e|BORISLAVD|GetCurrentUser..
t Transfer: 1220 :      9|13:02:24.5776|nd7e7e|BORISLAVD|  OAuth authenticated
t Transfer: 1220 :      9|13:02:24.5776|nd7e7e|BORISLAVD|    user BORISLAVD.
t Transfer: 1220 :      9|13:02:24.5776|VF0q0O|BORISLAVD|GetCurrentUser..
t Transfer: 1220 :      9|13:02:24.5776|VF0q0O|BORISLAVD|  OAuth authenticated
t Transfer: 1220 :      9|13:02:24.5776|VF0q0O|BORISLAVD|    user BORISLAVD.
t Verbose: 1220 :       9|13:02:24.5776|nd7e7e|BORISLAVD|imfx v3 API took 0.205s '/api/view/info/TitleTree?lang=en-US&_dc=1588852935159'
t Verbose: 1220 :       9|13:02:24.5776|VF0q0O|BORISLAVD|imfx v3 API took 0.208s '/api/view/info/VersionGrid?lang=en-US&_dc=1588852935211'
t Transfer: 1220 :      9|13:02:24.9838|RSbEra|BORISLAVD|OAuth: /api/settings/user/uploadSettings?_dc=1588852944778
t Transfer: 1220 :      9|13:02:24.9838|RSbEra|BORISLAVD|GetCurrentUser..
t Transfer: 1220 :      9|13:02:24.9838|RSbEra|BORISLAVD|  OAuth authenticated
t Transfer: 1220 :      9|13:02:24.9838|RSbEra|BORISLAVD|    user BORISLAVD.
t Verbose: 1220 :       9|13:02:24.9838|RSbEra|BORISLAVD|OAuth. User logged in: BORISLAVD
t Transfer: 1220 :      9|13:02:24.9838|RSbEra|BORISLAVD|GetCurrentUser..
t Transfer: 1220 :      9|13:02:24.9838|RSbEra|BORISLAVD|  OAuth authenticated
t Transfer: 1220 :      9|13:02:24.9838|RSbEra|BORISLAVD|    user BORISLAVD.
t Verbose: 1220 :       9|13:02:24.9838|RSbEra|BORISLAVD|imfx v3 API took 0.015s '/api/settings/user/uploadSettings?_dc=1588852944778'
t Transfer: 1220 :      9|13:02:24.9838|G7i3GL|BORISLAVD|OAuth: /api/settings/user/uploadSettings?_dc=1588852944885
t Transfer: 1220 :      9|13:02:24.9838|G7i3GL|BORISLAVD|GetCurrentUser..
t Transfer: 1220 :      9|13:02:24.9838|G7i3GL|BORISLAVD|  OAuth authenticated
t Transfer: 1220 :      9|13:02:24.9838|G7i3GL|BORISLAVD|    user BORISLAVD.
t Verbose: 1220 :       9|13:02:24.9838|G7i3GL|BORISLAVD|OAuth. User logged in: BORISLAVD
t Transfer: 1220 :      9|13:02:24.9838|G7i3GL|BORISLAVD|GetCurrentUser..
t Transfer: 1220 :      9|13:02:24.9838|G7i3GL|BORISLAVD|  OAuth authenticated
t Transfer: 1220 :      9|13:02:24.9838|G7i3GL|BORISLAVD|    user BORISLAVD.
t Verbose: 1220 :       9|13:02:24.9838|G7i3GL|BORISLAVD|imfx v3 API took 0.004s '/api/settings/user/uploadSettings?_dc=1588852944885'
t Transfer: 1220 :      9|13:02:25.7963|~BWP_M|BORISLAVD|OAuth: /api/v3/search-suggestion/?_dc=1588852945640
t Transfer: 1220 :      9|13:02:25.7963|~BWP_M|BORISLAVD|GetCurrentUser..
t Transfer: 1220 :      9|13:02:25.7963|~BWP_M|BORISLAVD|  OAuth authenticated
t Transfer: 1220 :      9|13:02:25.7963|~BWP_M|BORISLAVD|    user BORISLAVD.
t Verbose: 1220 :       9|13:02:25.7963|~BWP_M|BORISLAVD|OAuth. User logged in: BORISLAVD
t Transfer: 1220 :      9|13:02:25.7963|~BWP_M|BORISLAVD|GetCurrentUser..
t Transfer: 1220 :      9|13:02:25.7963|~BWP_M|BORISLAVD|  OAuth authenticated
t Transfer: 1220 :      9|13:02:25.7963|~BWP_M|BORISLAVD|    user BORISLAVD.
t Transfer: 1220 :      9|13:02:25.9994|Hq0_nj|BORISLAVD|OAuth: /api/v3/search-suggestion/?_dc=1588852945935
t Transfer: 1220 :      9|13:02:25.9994|Hq0_nj|BORISLAVD|GetCurrentUser..
t Transfer: 1220 :      9|13:02:25.9994|Hq0_nj|BORISLAVD|  OAuth authenticated
t Transfer: 1220 :      9|13:02:25.9994|Hq0_nj|BORISLAVD|    user BORISLAVD.
t Verbose: 1220 :       9|13:02:25.9994|Hq0_nj|BORISLAVD|OAuth. User logged in: BORISLAVD
t Transfer: 1220 :      9|13:02:25.9994|Hq0_nj|BORISLAVD|GetCurrentUser..
t Transfer: 1220 :      9|13:02:25.9994|Hq0_nj|BORISLAVD|  OAuth authenticated
t Transfer: 1220 :      9|13:02:25.9994|Hq0_nj|BORISLAVD|    user BORISLAVD.
t Transfer: 1220 :      9|13:02:25.9994|gBsl2O|BORISLAVD|OAuth: /api/v3/search-suggestion/?_dc=1588852945860
t Transfer: 1220 :      9|13:02:25.9994|gBsl2O|BORISLAVD|GetCurrentUser..
t Transfer: 1220 :      9|13:02:25.9994|gBsl2O|BORISLAVD|  OAuth authenticated
t Transfer: 1220 :      9|13:02:25.9994|gBsl2O|BORISLAVD|    user BORISLAVD.
t Verbose: 1220 :       9|13:02:25.9994|gBsl2O|BORISLAVD|OAuth. User logged in: BORISLAVD
t Transfer: 1220 :      9|13:02:25.9994|gBsl2O|BORISLAVD|GetCurrentUser..
t Transfer: 1220 :      9|13:02:25.9994|gBsl2O|BORISLAVD|  OAuth authenticated
t Transfer: 1220 :      9|13:02:25.9994|gBsl2O|BORISLAVD|    user BORISLAVD.
t Verbose: 1220 :       9|13:02:26.4057|~BWP_M|BORISLAVD|imfx v3 API took 0.459s '/api/v3/search-suggestion/?_dc=1588852945640'
t Verbose: 1220 :       9|13:02:26.4057|gBsl2O|BORISLAVD|imfx v3 API took 0.255s '/api/v3/search-suggestion/?_dc=1588852945860'
t Verbose: 1220 :       9|13:02:26.4057|Hq0_nj|BORISLAVD|imfx v3 API took 0.322s '/api/v3/search-suggestion/?_dc=1588852945935'
t Transfer: 1220 :      9|13:02:28.2338|ZlzlCp|BORISLAVD|OAuth: /api/v3/search/title?_dc=1588852948012
t Transfer: 1220 :      9|13:02:28.2338|ZlzlCp|BORISLAVD|GetCurrentUser..
t Transfer: 1220 :      9|13:02:28.2338|ZlzlCp|BORISLAVD|  OAuth authenticated
t Transfer: 1220 :      9|13:02:28.2338|ZlzlCp|BORISLAVD|    user BORISLAVD.
t Verbose: 1220 :       9|13:02:28.2338|ZlzlCp|BORISLAVD|OAuth. User logged in: BORISLAVD
t Information: 1220 :   9|13:02:28.2338|ZlzlCp|BORISLAVD|V3Api.SearchTitles
t Information: 1220 :   9|13:02:28.2338|ZlzlCp|BORISLAVD|V3Api.SearchGeneric
t Transfer: 1220 :      9|13:02:28.2338|ZlzlCp|BORISLAVD|GetCurrentUser..
t Transfer: 1220 :      9|13:02:28.2338|ZlzlCp|BORISLAVD|  OAuth authenticated
t Transfer: 1220 :      9|13:02:28.2338|ZlzlCp|BORISLAVD|    user BORISLAVD.
t Transfer: 1220 :      9|13:02:28.2338|ZlzlCp|BORISLAVD|GetCurrentUser..
t Transfer: 1220 :      9|13:02:28.2338|ZlzlCp|BORISLAVD|  OAuth authenticated
t Transfer: 1220 :      9|13:02:28.2338|ZlzlCp|BORISLAVD|    user BORISLAVD.
t Information: 1220 :   9|13:02:28.2338|ZlzlCp|BORISLAVD|SearchTitle SQL:
with 
 v as (
    SELECT 
        abs.*
       ,decode(ITEM_TYPE,
                 1010,SER_ABS_ID,
                 1020,CASE WHEN SER_ABS2_ID > 0 THEN SER_ABS2_ID ELSE SER_ABS_ID END
              ) xparent_id
      FROM TMDDBA.TM_PG_ABS abs
     WHERE abs.id in (
          select a.id
          FROM TMDDBA.TM_PG_ABS a
          where ABS_DELETED = 0  AND (INSTR(OWNERS,'|TECHM|')>0 ) AND   a.ser_abs_id=278625    AND ROWNUM < 25000   )
      
 )
,v_missing_parent_ids as (
    select xparent_id from v
    minus
    select id from v
 )
,v_missing_parents as (
    SELECT 
        distinct a.*
       ,decode(ITEM_TYPE,
                 1010,SER_ABS_ID,
                 1020,CASE WHEN SER_ABS2_ID > 0 THEN SER_ABS2_ID ELSE SER_ABS_ID END
              ) xparent_id
      FROM TMDDBA.TM_PG_ABS a
    START WITH ID IN (select xparent_id from v_missing_parent_ids)
    CONNECT BY
           CASE PRIOR ITEM_TYPE
             WHEN 1010 THEN PRIOR SER_ABS_ID
             WHEN 1020 THEN 
               CASE WHEN NVL(PRIOR SER_ABS2_ID, 0) > 0 THEN PRIOR SER_ABS2_ID ELSE PRIOR SER_ABS_ID END
             END = ID
 )
,v_all as (
   select x.*, count(*) over() RowCount
   from (
     select * from v_missing_parents
     union 
     select * from v
   ) x
 )
,v_top as (
   select id
   from (select id, row_number()over(order by upper(ser_title),upper(title),ser_num,ser_ep_num, SER_EP_SQ_NUM ) rnk -- sort roots
         from v_all 
         where  xparent_id is null)
   where rnk between (:page_number-1)*50+1 and :page_number*50
)
,v_tree as (
   select level lvl, a.*
   from v_all a
   start with id in (select id from v_top)
   connect by xparent_id = prior ID
   order siblings by upper(ser_title),ser_num,ser_ep_num, SER_EP_SQ_NUM,upper(title) -- sort children
 )
select *
from v_tree 
--where rnk <= 50
t Verbose: 1220 :       9|13:02:28.4369|ZlzlCp|BORISLAVD|imfx v3 API took 0.163s '/api/v3/search/title?_dc=1588852948012'
t Transfer: 1220 :      9|13:02:28.6400|cj7ZKB|BORISLAVD|OAuth: /api/user-preferences?_dc=1588852948435
t Transfer: 1220 :      9|13:02:28.6400|cj7ZKB|BORISLAVD|GetCurrentUser..
t Transfer: 1220 :      9|13:02:28.6400|cj7ZKB|BORISLAVD|  OAuth authenticated
t Transfer: 1220 :      9|13:02:28.6400|cj7ZKB|BORISLAVD|    user BORISLAVD.
t Verbose: 1220 :       9|13:02:28.6400|cj7ZKB|BORISLAVD|OAuth. User logged in: BORISLAVD
t Transfer: 1220 :      9|13:02:28.6400|kO4lNH|BORISLAVD|OAuth: /api/v3/title/278625/versions?_dc=1588852948431
t Transfer: 1220 :      9|13:02:28.6400|kO4lNH|BORISLAVD|GetCurrentUser..
t Transfer: 1220 :      9|13:02:28.6400|kO4lNH|BORISLAVD|  OAuth authenticated
t Transfer: 1220 :      9|13:02:28.6400|kO4lNH|BORISLAVD|    user BORISLAVD.
t Verbose: 1220 :       9|13:02:28.6400|kO4lNH|BORISLAVD|OAuth. User logged in: BORISLAVD
t Information: 1220 :   9|13:02:28.6400|kO4lNH|BORISLAVD|V3Api.SearchGeneric
t Verbose: 1220 :       9|13:02:28.6400|cj7ZKB|BORISLAVD|StoreUserDataByKeys..
t Transfer: 1220 :      9|13:02:28.6400|cj7ZKB|BORISLAVD|GetCurrentUser..
t Transfer: 1220 :      9|13:02:28.6400|cj7ZKB|BORISLAVD|  OAuth authenticated
t Transfer: 1220 :      9|13:02:28.6400|cj7ZKB|BORISLAVD|    user BORISLAVD.
t Verbose: 1220 :       9|13:02:28.6400|cj7ZKB|BORISLAVD|imfx v3 API took 0.008s '/api/user-preferences?_dc=1588852948435'
t Transfer: 1220 :      9|13:02:28.6400|kO4lNH|BORISLAVD|GetCurrentUser..
t Transfer: 1220 :      9|13:02:28.6400|kO4lNH|BORISLAVD|  OAuth authenticated
t Transfer: 1220 :      9|13:02:28.6400|kO4lNH|BORISLAVD|    user BORISLAVD.
t Transfer: 1220 :      9|13:02:28.6400|kO4lNH|BORISLAVD|GetCurrentUser..
t Transfer: 1220 :      9|13:02:28.6400|kO4lNH|BORISLAVD|  OAuth authenticated
t Transfer: 1220 :      9|13:02:28.6400|kO4lNH|BORISLAVD|    user BORISLAVD.
t Information: 1220 :   9|13:02:28.6400|kO4lNH|BORISLAVD|SearchVersion SQL:
 select * from (select a.*, rownum rnum  from ( select  m.*, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE,  nvl(t.text_id,-1) THUMBID, BUILD_PGRL_FULLTITLE(item_type, title, ser_name, ser_title) FULLTITLE     from tmddba.tm_pg_rl m 
        left outer join (select text_id, text_data_path, text_data_filename, text_ref_object from tmddba.tm_text) t on t.text_id = m.primary_thumb_id
 where item_type>0 and rl_deleted=0  and m.PGM_ABS_ID=278625  AND (INSTR(m.OWNERS,'|TECHM|')>0)
 order by m.title,m.id) a where rownum <= 9999) r where rnum >=1 order by rnum
t Information: 1220 :   9|13:02:28.6400|kO4lNH|BORISLAVD|Running version search. User: 802    Simple Search: 
Running Oracle search.
Running Oracle search for COUNT
Oracle count completed in: 10ms.  Returned lines: 0

t Verbose: 1220 :       9|13:02:28.6400|kO4lNH|BORISLAVD|imfx v3 API took 0.031s '/api/v3/title/278625/versions?_dc=1588852948431'
t Transfer: 1220 :      9|13:02:39.2025|drftYg|BORISLAVD|OAuth: /api/v3/title/293744/versions?_dc=1588852958984
t Transfer: 1220 :      9|13:02:39.2025|drftYg|BORISLAVD|GetCurrentUser..
t Transfer: 1220 :      9|13:02:39.2025|drftYg|BORISLAVD|  OAuth authenticated
t Transfer: 1220 :      9|13:02:39.2025|drftYg|BORISLAVD|    user BORISLAVD.
t Verbose: 1220 :       9|13:02:39.2025|drftYg|BORISLAVD|OAuth. User logged in: BORISLAVD
t Information: 1220 :   9|13:02:39.2025|drftYg|BORISLAVD|V3Api.SearchGeneric
t Transfer: 1220 :      9|13:02:39.2025|drftYg|BORISLAVD|GetCurrentUser..
t Transfer: 1220 :      9|13:02:39.2025|drftYg|BORISLAVD|  OAuth authenticated
t Transfer: 1220 :      9|13:02:39.2025|drftYg|BORISLAVD|    user BORISLAVD.
t Transfer: 1220 :      9|13:02:39.2025|drftYg|BORISLAVD|GetCurrentUser..
t Transfer: 1220 :      9|13:02:39.2025|drftYg|BORISLAVD|  OAuth authenticated
t Transfer: 1220 :      9|13:02:39.2025|drftYg|BORISLAVD|    user BORISLAVD.
t Information: 1220 :   9|13:02:39.2025|drftYg|BORISLAVD|SearchVersion SQL:
 select * from (select a.*, rownum rnum  from ( select  m.*, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE,  nvl(t.text_id,-1) THUMBID, BUILD_PGRL_FULLTITLE(item_type, title, ser_name, ser_title) FULLTITLE     from tmddba.tm_pg_rl m 
        left outer join (select text_id, text_data_path, text_data_filename, text_ref_object from tmddba.tm_text) t on t.text_id = m.primary_thumb_id
 where item_type>0 and rl_deleted=0  and m.PGM_ABS_ID=293744  AND (INSTR(m.OWNERS,'|TECHM|')>0)
 order by m.title,m.id) a where rownum <= 9999) r where rnum >=1 order by rnum
t Information: 1220 :   9|13:02:39.2025|drftYg|BORISLAVD|Running version search. User: 802    Simple Search: 
Running Oracle search.
Running Oracle search for COUNT
Oracle count completed in: 5ms.  Returned lines: 1
Oracle version search timing: 70ms.
SQL run:
 select * from (select a.*, rownum rnum  from ( select  m.*, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE,  nvl(t.text_id,-1) THUMBID, BUILD_PGRL_FULLTITLE(item_type, title, ser_name, ser_title) FULLTITLE     from tmddba.tm_pg_rl m 
        left outer join (select text_id, text_data_path, text_data_filename, text_ref_object from tmddba.tm_text) t on t.text_id = m.primary_thumb_id
 where item_type>0 and rl_deleted=0  and m.PGM_ABS_ID=293744  AND (INSTR(m.OWNERS,'|TECHM|')>0)
 order by m.title,m.id) a where rownum <= 9999) r where rnum >=1 order by rnum

t Verbose: 1220 :       9|13:02:39.2025|drftYg|BORISLAVD|imfx v3 API took 0.080s '/api/v3/title/293744/versions?_dc=1588852958984'
t Transfer: 1220 :      9|13:02:39.4056|iV4LnB|BORISLAVD|OAuth: /api/v3/version/293745/media?_dc=1588852959264
t Transfer: 1220 :      9|13:02:39.4056|iV4LnB|BORISLAVD|GetCurrentUser..
t Transfer: 1220 :      9|13:02:39.4056|iV4LnB|BORISLAVD|  OAuth authenticated
t Transfer: 1220 :      9|13:02:39.4056|iV4LnB|BORISLAVD|    user BORISLAVD.
t Verbose: 1220 :       9|13:02:39.4056|iV4LnB|BORISLAVD|OAuth. User logged in: BORISLAVD
t Information: 1220 :   9|13:02:39.4056|iV4LnB|BORISLAVD|V3Api.SearchGeneric
t Transfer: 1220 :      9|13:02:39.4056|iV4LnB|BORISLAVD|GetCurrentUser..
t Transfer: 1220 :      9|13:02:39.4056|iV4LnB|BORISLAVD|  OAuth authenticated
t Transfer: 1220 :      9|13:02:39.4056|iV4LnB|BORISLAVD|    user BORISLAVD.
t Information: 1220 :   9|13:02:39.4056|iV4LnB|BORISLAVD|MediaSearch SQL:
select r.*,
    nvl((select TMD_STR_AGG(c.u_id_pfix ) from tm_ctnrs c, tm_mi_tpi_lnx l where l.miid=r.id and c.u_id=l.tpiid and r.media_type=1),'') BARCODE,
    nvl(lnk.lib_loc_ext_id,0) lib_loc_ext_id, nvl(lnk.ctnr_loan_stat,0) ctnr_loan_status, nvl(lnk.ctnr_stat,0) ctnr_stat,
    nvl(t.text_data_path,'') THUMBSERVER, 
    nvl(t.text_data_filename,'') THUMBFILE,
    nvl(t.text_id,-1) THUMBID , 
    (select min(status.description) from TM_CFG_PGM_STATUS status where r.status = status.id) PGM_STATUS_TEXT, (select tmd_str_agg_pipe(cms.status_type_id ||',' ||cms.status_id) from tm_mi_cust_med_stat_lnx cms where cms.media_id=r.id) "CustomStatusesRaw", 
    GETMEDIALOC(r.id, r.media_type, r.compil, r.m_ctnr_int_o_loc, r.m_ctnr_ext_o_loc, r.m_ctnr_loc) LOCATION,
    nvl(dfl.fSOM,0) FILE_SOM, nvl(dfl.fEOM,0) FILE_EOM, dfl.fos_fname FILENAME, dfl.DFILE_LINK_GUID, dfl.OS_GUID, dfl.SUB_FOLDER, dfl.ORIGINAL_FILENAME 

    from (select a.*, rownum rnum from 
      (select  m.*,
     coalesce(m.primary_thumb_id, (select v.primary_thumb_id from tm_pg_rl v where v.id=m.pgm_parent_id)) primary_thumb_id2 
      from tmddba.tm_mis m 
 where media_type>0 and item_type>0  AND  PGM_PARENT_ID=:pgm_parent_id_1  and m.mi_deleted=0   AND (INSTR(m.OWNERS,'|TECHM|')>0)
 order by upper(m.title), m.media_type, m.ec_som, m.id ) a where rownum <= 50) r 
    ,lateral( select l.miid, max(c.C_EXT_OUT_LOC) lib_loc_ext_id, max(c.C_STAT) ctnr_stat, max(c.loan_stat) ctnr_loan_stat  from tm_mi_tpi_lnx l, tm_ctnrs c where c.u_id=l.tpiid and l.miid=r.id and r.media_type=1 group by l.miid)(+) lnk 
    ,lateral(select tt.* from tm_text tt where tt.text_id = r.primary_thumb_id2)(+) t
    ,lateral(select /*+ NO_DECORRELATE */  d.som fsom, d.eom feom, dl.mi_id fmi_id, d.os_fname fos_fname, d.DFILE_LINK_GUID, d.OS_GUID, d.SUB_FOLDER, dl.dfile_id, d.original_filename
        FROM tm_dfile d, tm_mi_dfile_lnx dl where d.id=dl.dfile_id and r.id=dl.mi_id and rownum=1)(+) dfl 
    
    where rnum >= 1 order by rnum
Param: pgm_parent_id_1: 293745
t Information: 1220 :   9|13:02:39.6088|iV4LnB|BORISLAVD|    timing: 00:00:00.0995072
t Verbose: 1220 :       9|13:02:39.6088|iV4LnB|BORISLAVD|imfx v3 API took 0.125s '/api/v3/version/293745/media?_dc=1588852959264'
t Transfer: 1220 :      9|13:02:39.6088|iV4LnB|BORISLAVD|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\gotspecialspromo10secaction.mp4 subfolder 
t Transfer: 1220 :      9|13:02:39.6088|iV4LnB|BORISLAVD|  GetFileName result https://imfxv3tm.tmd.tv/VideoServer/gotspecialspromo10secaction.mp4
t Transfer: 1220 :      9|13:02:39.6088|iV4LnB|BORISLAVD|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/gotspecialspromo10secaction.mp4
t Transfer: 1220 :      9|13:02:39.6088|iV4LnB|BORISLAVD|GetCurrentUser..
t Transfer: 1220 :      9|13:02:39.6088|iV4LnB|BORISLAVD|  OAuth authenticated
t Transfer: 1220 :      9|13:02:39.6088|iV4LnB|BORISLAVD|    user BORISLAVD.
t Transfer: 1220 :      9|13:02:39.8119|iV4LnB|BORISLAVD|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\gotspecialspromo20seccharacter.mp4 subfolder 
t Transfer: 1220 :      9|13:02:39.8119|iV4LnB|BORISLAVD|  GetFileName result https://imfxv3tm.tmd.tv/VideoServer/gotspecialspromo20seccharacter.mp4
t Transfer: 1220 :      9|13:02:39.8119|iV4LnB|BORISLAVD|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/gotspecialspromo20seccharacter.mp4
t Transfer: 1220 :      9|13:02:39.8119|iV4LnB|BORISLAVD|GetCurrentUser..
t Transfer: 1220 :      9|13:02:39.8119|iV4LnB|BORISLAVD|  OAuth authenticated
t Transfer: 1220 :      9|13:02:39.8119|iV4LnB|BORISLAVD|    user BORISLAVD.
t Transfer: 1220 :      9|13:02:39.8119|iV4LnB|BORISLAVD|GetUrl. Storage |Image| filename \\192.168.120.254\DemoFS\Digital Assets\Image\gotspecialspromosimage.jpg subfolder 
t Transfer: 1220 :      9|13:02:39.8119|iV4LnB|BORISLAVD|  GetFileName result https://imfxv3tm.tmd.tv/ImageServer/gotspecialspromosimage.jpg
t Transfer: 1220 :      9|13:02:39.8119|iV4LnB|BORISLAVD|GetUrl. result https://imfxv3tm.tmd.tv/ImageServer/gotspecialspromosimage.jpg
t Transfer: 1220 :      9|13:02:39.8119|iV4LnB|BORISLAVD|GetCurrentUser..
t Transfer: 1220 :      9|13:02:39.8119|iV4LnB|BORISLAVD|  OAuth authenticated
t Transfer: 1220 :      9|13:02:39.8119|iV4LnB|BORISLAVD|    user BORISLAVD.
t Transfer: 1220 :      9|13:02:39.8119|iV4LnB|BORISLAVD|GetUrl. Storage |TEMP_UPLOAD| filename \\192.168.120.254\DemoFS\Digital Assets\TEMP_UPLOAD\68add84afa7b\Animation Sample1.mp4 subfolder 68add84afa7b\
t Transfer: 1220 :      9|13:02:39.8119|iV4LnB|BORISLAVD|  GetFileName result https://demo.tmd.tv/Temp Upload/Animation Sample1.mp4
t Transfer: 1220 :      9|13:02:39.8119|iV4LnB|BORISLAVD|GetUrl. result https://demo.tmd.tv/Temp Upload/Animation Sample1.mp4
t Transfer: 1220 :      9|13:02:39.8119|iV4LnB|BORISLAVD|GetCurrentUser..
t Transfer: 1220 :      9|13:02:39.8119|iV4LnB|BORISLAVD|  OAuth authenticated
t Transfer: 1220 :      9|13:02:39.8119|iV4LnB|BORISLAVD|    user BORISLAVD.
t Transfer: 1220 :      9|13:02:39.8119|iV4LnB|BORISLAVD|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Example 06052020.mp4 subfolder 
t Transfer: 1220 :      9|13:02:39.8119|iV4LnB|BORISLAVD|  GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Example 06052020.mp4
t Transfer: 1220 :      9|13:02:39.8119|iV4LnB|BORISLAVD|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/Example 06052020.mp4
t Transfer: 1220 :      9|13:02:39.8119|iV4LnB|BORISLAVD|GetCurrentUser..
t Transfer: 1220 :      9|13:02:39.8119|iV4LnB|BORISLAVD|  OAuth authenticated
t Transfer: 1220 :      9|13:02:39.8119|iV4LnB|BORISLAVD|    user BORISLAVD.
t Transfer: 1220 :      9|13:02:39.8119|iV4LnB|BORISLAVD|GetUrl. Storage |Audio| filename \\192.168.120.254\DemoFS\Digital Assets\Audio\PMH_portugese - Copy.wav subfolder 
t Transfer: 1220 :      9|13:02:39.8119|iV4LnB|BORISLAVD|  GetFileName result https://imfxv3tm.tmd.tv/AudioServer/PMH_portugese - Copy.wav
t Transfer: 1220 :      9|13:02:39.8119|iV4LnB|BORISLAVD|GetUrl. result https://imfxv3tm.tmd.tv/AudioServer/PMH_portugese - Copy.wav
t Transfer: 1220 :      9|13:02:39.8119|iV4LnB|BORISLAVD|GetCurrentUser..
t Transfer: 1220 :      9|13:02:39.8119|iV4LnB|BORISLAVD|  OAuth authenticated
t Transfer: 1220 :      9|13:02:39.8119|iV4LnB|BORISLAVD|    user BORISLAVD.
t Transfer: 1220 :      9|13:02:39.8119|iV4LnB|BORISLAVD|GetUrl. Storage |Audio| filename \\192.168.120.254\DemoFS\Digital Assets\Audio\gotspecialspromosaudio.wav subfolder 
t Transfer: 1220 :      9|13:02:39.8119|iV4LnB|BORISLAVD|  GetFileName result https://imfxv3tm.tmd.tv/AudioServer/gotspecialspromosaudio.wav
t Transfer: 1220 :      9|13:02:39.8119|iV4LnB|BORISLAVD|GetUrl. result https://imfxv3tm.tmd.tv/AudioServer/gotspecialspromosaudio.wav
t Transfer: 1220 :      9|13:02:39.8119|iV4LnB|BORISLAVD|GetCurrentUser..
t Transfer: 1220 :      9|13:02:39.8119|iV4LnB|BORISLAVD|  OAuth authenticated
t Transfer: 1220 :      9|13:02:39.8119|iV4LnB|BORISLAVD|    user BORISLAVD.
t Transfer: 1220 :      9|13:03:03.9994|OWdBy3|BORISLAVD|OAuth: /api/v3/title/278627/versions?_dc=1588852983859
t Transfer: 1220 :      9|13:03:03.9994|OWdBy3|BORISLAVD|GetCurrentUser..
t Transfer: 1220 :      9|13:03:03.9994|OWdBy3|BORISLAVD|  OAuth authenticated
t Transfer: 1220 :      9|13:03:03.9994|OWdBy3|BORISLAVD|    user BORISLAVD.
t Verbose: 1220 :       9|13:03:03.9994|OWdBy3|BORISLAVD|OAuth. User logged in: BORISLAVD
t Information: 1220 :   9|13:03:03.9994|OWdBy3|BORISLAVD|V3Api.SearchGeneric
t Transfer: 1220 :      9|13:03:03.9994|OWdBy3|BORISLAVD|GetCurrentUser..
t Transfer: 1220 :      9|13:03:03.9994|OWdBy3|BORISLAVD|  OAuth authenticated
t Transfer: 1220 :      9|13:03:03.9994|OWdBy3|BORISLAVD|    user BORISLAVD.
t Transfer: 1220 :      9|13:03:03.9994|OWdBy3|BORISLAVD|GetCurrentUser..
t Transfer: 1220 :      9|13:03:03.9994|OWdBy3|BORISLAVD|  OAuth authenticated
t Transfer: 1220 :      9|13:03:03.9994|OWdBy3|BORISLAVD|    user BORISLAVD.
t Information: 1220 :   9|13:03:03.9994|OWdBy3|BORISLAVD|SearchVersion SQL:
 select * from (select a.*, rownum rnum  from ( select  m.*, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE,  nvl(t.text_id,-1) THUMBID, BUILD_PGRL_FULLTITLE(item_type, title, ser_name, ser_title) FULLTITLE     from tmddba.tm_pg_rl m 
        left outer join (select text_id, text_data_path, text_data_filename, text_ref_object from tmddba.tm_text) t on t.text_id = m.primary_thumb_id
 where item_type>0 and rl_deleted=0  and m.PGM_ABS_ID=278627  AND (INSTR(m.OWNERS,'|TECHM|')>0)
 order by m.title,m.id) a where rownum <= 9999) r where rnum >=1 order by rnum
t Information: 1220 :   9|13:03:03.9994|OWdBy3|BORISLAVD|Running version search. User: 802    Simple Search: 
Running Oracle search.
Running Oracle search for COUNT
Oracle count completed in: 5ms.  Returned lines: 1
Oracle version search timing: 46ms.
SQL run:
 select * from (select a.*, rownum rnum  from ( select  m.*, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE,  nvl(t.text_id,-1) THUMBID, BUILD_PGRL_FULLTITLE(item_type, title, ser_name, ser_title) FULLTITLE     from tmddba.tm_pg_rl m 
        left outer join (select text_id, text_data_path, text_data_filename, text_ref_object from tmddba.tm_text) t on t.text_id = m.primary_thumb_id
 where item_type>0 and rl_deleted=0  and m.PGM_ABS_ID=278627  AND (INSTR(m.OWNERS,'|TECHM|')>0)
 order by m.title,m.id) a where rownum <= 9999) r where rnum >=1 order by rnum

t Verbose: 1220 :       9|13:03:03.9994|OWdBy3|BORISLAVD|imfx v3 API took 0.054s '/api/v3/title/278627/versions?_dc=1588852983859'
t Transfer: 1220 :      9|13:03:04.2025|c7rh1f|BORISLAVD|OAuth: /api/v3/version/278628/media?_dc=1588852984047
t Transfer: 1220 :      9|13:03:04.2025|c7rh1f|BORISLAVD|GetCurrentUser..
t Transfer: 1220 :      9|13:03:04.2025|c7rh1f|BORISLAVD|  OAuth authenticated
t Transfer: 1220 :      9|13:03:04.2025|c7rh1f|BORISLAVD|    user BORISLAVD.
t Verbose: 1220 :       9|13:03:04.2025|c7rh1f|BORISLAVD|OAuth. User logged in: BORISLAVD
t Information: 1220 :   9|13:03:04.2025|c7rh1f|BORISLAVD|V3Api.SearchGeneric
t Transfer: 1220 :      9|13:03:04.2025|c7rh1f|BORISLAVD|GetCurrentUser..
t Transfer: 1220 :      9|13:03:04.2025|c7rh1f|BORISLAVD|  OAuth authenticated
t Transfer: 1220 :      9|13:03:04.2025|c7rh1f|BORISLAVD|    user BORISLAVD.
t Information: 1220 :   9|13:03:04.2025|c7rh1f|BORISLAVD|MediaSearch SQL:
select r.*,
    nvl((select TMD_STR_AGG(c.u_id_pfix ) from tm_ctnrs c, tm_mi_tpi_lnx l where l.miid=r.id and c.u_id=l.tpiid and r.media_type=1),'') BARCODE,
    nvl(lnk.lib_loc_ext_id,0) lib_loc_ext_id, nvl(lnk.ctnr_loan_stat,0) ctnr_loan_status, nvl(lnk.ctnr_stat,0) ctnr_stat,
    nvl(t.text_data_path,'') THUMBSERVER, 
    nvl(t.text_data_filename,'') THUMBFILE,
    nvl(t.text_id,-1) THUMBID , 
    (select min(status.description) from TM_CFG_PGM_STATUS status where r.status = status.id) PGM_STATUS_TEXT, (select tmd_str_agg_pipe(cms.status_type_id ||',' ||cms.status_id) from tm_mi_cust_med_stat_lnx cms where cms.media_id=r.id) "CustomStatusesRaw", 
    GETMEDIALOC(r.id, r.media_type, r.compil, r.m_ctnr_int_o_loc, r.m_ctnr_ext_o_loc, r.m_ctnr_loc) LOCATION,
    nvl(dfl.fSOM,0) FILE_SOM, nvl(dfl.fEOM,0) FILE_EOM, dfl.fos_fname FILENAME, dfl.DFILE_LINK_GUID, dfl.OS_GUID, dfl.SUB_FOLDER, dfl.ORIGINAL_FILENAME 

    from (select a.*, rownum rnum from 
      (select  m.*,
     coalesce(m.primary_thumb_id, (select v.primary_thumb_id from tm_pg_rl v where v.id=m.pgm_parent_id)) primary_thumb_id2 
      from tmddba.tm_mis m 
 where media_type>0 and item_type>0  AND  PGM_PARENT_ID=:pgm_parent_id_1  and m.mi_deleted=0   AND (INSTR(m.OWNERS,'|TECHM|')>0)
 order by upper(m.title), m.media_type, m.ec_som, m.id ) a where rownum <= 50) r 
    ,lateral( select l.miid, max(c.C_EXT_OUT_LOC) lib_loc_ext_id, max(c.C_STAT) ctnr_stat, max(c.loan_stat) ctnr_loan_stat  from tm_mi_tpi_lnx l, tm_ctnrs c where c.u_id=l.tpiid and l.miid=r.id and r.media_type=1 group by l.miid)(+) lnk 
    ,lateral(select tt.* from tm_text tt where tt.text_id = r.primary_thumb_id2)(+) t
    ,lateral(select /*+ NO_DECORRELATE */  d.som fsom, d.eom feom, dl.mi_id fmi_id, d.os_fname fos_fname, d.DFILE_LINK_GUID, d.OS_GUID, d.SUB_FOLDER, dl.dfile_id, d.original_filename
        FROM tm_dfile d, tm_mi_dfile_lnx dl where d.id=dl.dfile_id and r.id=dl.mi_id and rownum=1)(+) dfl 
    
    where rnum >= 1 order by rnum
Param: pgm_parent_id_1: 278628
t Information: 1220 :   9|13:03:04.2025|c7rh1f|BORISLAVD|    timing: 00:00:00.0179261
t Verbose: 1220 :       9|13:03:04.2025|c7rh1f|BORISLAVD|imfx v3 API took 0.018s '/api/v3/version/278628/media?_dc=1588852984047'
t Transfer: 1220 :      9|13:03:04.2025|c7rh1f|BORISLAVD|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Game of Thrones - Blinkbox-HD.mp4 subfolder 
t Transfer: 1220 :      9|13:03:04.2025|c7rh1f|BORISLAVD|  GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Game of Thrones - Blinkbox-HD.mp4
t Transfer: 1220 :      9|13:03:04.2025|c7rh1f|BORISLAVD|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/Game of Thrones - Blinkbox-HD.mp4
t Transfer: 1220 :      9|13:03:04.2025|c7rh1f|BORISLAVD|GetCurrentUser..
t Transfer: 1220 :      9|13:03:04.2025|c7rh1f|BORISLAVD|  OAuth authenticated
t Transfer: 1220 :      9|13:03:04.2025|c7rh1f|BORISLAVD|    user BORISLAVD.
t Transfer: 1220 :      9|13:03:04.2025|c7rh1f|BORISLAVD|GetUrl. Storage |VODPublish| filename \\192.168.120.254\DemoFS\Digital Assets\VODPublish\Temp\N0001343.mp4 subfolder Temp\
t Transfer: 1220 :      9|13:03:04.2025|c7rh1f|BORISLAVD|GetCurrentUser..
t Transfer: 1220 :      9|13:03:04.2025|c7rh1f|BORISLAVD|  OAuth authenticated
t Transfer: 1220 :      9|13:03:04.2025|c7rh1f|BORISLAVD|    user BORISLAVD.
t Transfer: 1220 :      9|13:03:04.2025|c7rh1f|BORISLAVD|GetUrl. Storage |Docs| filename I:\Docs\Mediaflex Supported Devices 2v03.pdf subfolder 
t Transfer: 1220 :      9|13:03:04.2025|c7rh1f|BORISLAVD|  GetFileName result https://imfxv3tm.tmd.tv/DocsServer/Mediaflex Supported Devices 2v03.pdf
t Transfer: 1220 :      9|13:03:04.2025|c7rh1f|BORISLAVD|GetUrl. result https://imfxv3tm.tmd.tv/DocsServer/Mediaflex Supported Devices 2v03.pdf
t Transfer: 1220 :      9|13:03:04.2025|c7rh1f|BORISLAVD|GetCurrentUser..
t Transfer: 1220 :      9|13:03:04.2025|c7rh1f|BORISLAVD|  OAuth authenticated
t Transfer: 1220 :      9|13:03:04.2025|c7rh1f|BORISLAVD|    user BORISLAVD.
t Transfer: 1220 :      9|13:03:04.2025|c7rh1f|BORISLAVD|GetUrl. Storage |VODPublish| filename \\192.168.120.254\DemoFS\Digital Assets\VODPublish\Temp\N0001344.dtd subfolder Temp\
t Transfer: 1220 :      9|13:03:04.2025|c7rh1f|BORISLAVD|GetCurrentUser..
t Transfer: 1220 :      9|13:03:04.2025|c7rh1f|BORISLAVD|  OAuth authenticated
t Transfer: 1220 :      9|13:03:04.2025|c7rh1f|BORISLAVD|    user BORISLAVD.
t Transfer: 1220 :      9|13:03:04.2025|c7rh1f|BORISLAVD|GetUrl. Storage |VODPublish| filename \\192.168.120.254\DemoFS\Digital Assets\VODPublish\Temp\N0001345.xml subfolder Temp\
t Transfer: 1220 :      9|13:03:04.2025|c7rh1f|BORISLAVD|GetCurrentUser..
t Transfer: 1220 :      9|13:03:04.2025|c7rh1f|BORISLAVD|  OAuth authenticated
t Transfer: 1220 :      9|13:03:04.2025|c7rh1f|BORISLAVD|    user BORISLAVD.
t Transfer: 1220 :      9|13:03:04.2025|c7rh1f|BORISLAVD|GetUrl. Storage |VODPublish| filename \\192.168.120.254\DemoFS\Digital Assets\VODPublish\Temp\N0001348.dtd subfolder Temp\
t Transfer: 1220 :      9|13:03:04.2025|c7rh1f|BORISLAVD|GetCurrentUser..
t Transfer: 1220 :      9|13:03:04.2025|c7rh1f|BORISLAVD|  OAuth authenticated
t Transfer: 1220 :      9|13:03:04.2025|c7rh1f|BORISLAVD|    user BORISLAVD.
t Transfer: 1220 :      9|13:03:04.2025|c7rh1f|BORISLAVD|GetUrl. Storage |VODPublish| filename \\192.168.120.254\DemoFS\Digital Assets\VODPublish\Temp\N0001349.xml subfolder Temp\
t Transfer: 1220 :      9|13:03:04.2025|c7rh1f|BORISLAVD|GetCurrentUser..
t Transfer: 1220 :      9|13:03:04.2025|c7rh1f|BORISLAVD|  OAuth authenticated
t Transfer: 1220 :      9|13:03:04.2025|c7rh1f|BORISLAVD|    user BORISLAVD.
t Transfer: 1220 :      9|13:03:18.0307|lHxxQW|BORISLAVD|OAuth: /api/user-preferences?_dc=1588852997887
t Transfer: 1220 :      9|13:03:18.0307|lHxxQW|BORISLAVD|GetCurrentUser..
t Transfer: 1220 :      9|13:03:18.0307|lHxxQW|BORISLAVD|  OAuth authenticated
t Transfer: 1220 :      9|13:03:18.0307|lHxxQW|BORISLAVD|    user BORISLAVD.
t Verbose: 1220 :       9|13:03:18.0307|lHxxQW|BORISLAVD|OAuth. User logged in: BORISLAVD
t Verbose: 1220 :       9|13:03:18.0307|lHxxQW|BORISLAVD|StoreUserDataByKeys..
t Transfer: 1220 :      9|13:03:18.0307|lHxxQW|BORISLAVD|GetCurrentUser..
t Transfer: 1220 :      9|13:03:18.0307|lHxxQW|BORISLAVD|  OAuth authenticated
t Transfer: 1220 :      9|13:03:18.0307|lHxxQW|BORISLAVD|    user BORISLAVD.
t Verbose: 1220 :       9|13:03:18.0307|lHxxQW|BORISLAVD|imfx v3 API took 0.027s '/api/user-preferences?_dc=1588852997887'
t Transfer: 1220 :      9|13:03:20.8744|eSubHQ|BORISLAVD|GetCurrentUser..
t Transfer: 1220 :      9|13:03:20.8744|eSubHQ|BORISLAVD|  OAuth authenticated
t Transfer: 1220 :      9|13:03:20.8744|eSubHQ|BORISLAVD|    user BORISLAVD.
t Transfer: 1220 :      9|13:03:27.9838|TEGaNB|BORISLAVD|OAuth: /api/user-group-preferences?globals=htmlplayerhotkeys,audioOnFrameForward&_dc=1588853007769
t Transfer: 1220 :      9|13:03:27.9838|TEGaNB|BORISLAVD|GetCurrentUser..
t Transfer: 1220 :      9|13:03:27.9838|TEGaNB|BORISLAVD|  OAuth authenticated
t Transfer: 1220 :      9|13:03:27.9838|TEGaNB|BORISLAVD|    user BORISLAVD.
t Verbose: 1220 :       9|13:03:27.9838|TEGaNB|BORISLAVD|OAuth. User logged in: BORISLAVD
t Transfer: 1220 :      9|13:03:27.9838|TEGaNB|BORISLAVD|GetCurrentUser..
t Transfer: 1220 :      9|13:03:27.9838|TEGaNB|BORISLAVD|  OAuth authenticated
t Transfer: 1220 :      9|13:03:27.9838|TEGaNB|BORISLAVD|    user BORISLAVD.
t Verbose: 1220 :       9|13:03:27.9838|TEGaNB|BORISLAVD|imfx v3 API took 0.005s '/api/user-group-preferences?globals=htmlplayerhotkeys,audioOnFrameForward&_dc=1588853007769'
t Transfer: 1220 :      9|13:04:10.4370|7fhMUt|BORISLAVD|OAuth: /api/v3/media-details/291883?_dc=1588853050304
t Transfer: 1220 :      9|13:04:10.4370|7fhMUt|BORISLAVD|GetCurrentUser..
t Transfer: 1220 :      9|13:04:10.4370|7fhMUt|BORISLAVD|  OAuth authenticated
t Transfer: 1220 :      9|13:04:10.4370|7fhMUt|BORISLAVD|    user BORISLAVD.
t Verbose: 1220 :       9|13:04:10.4370|7fhMUt|BORISLAVD|OAuth. User logged in: BORISLAVD
t Transfer: 1220 :      9|13:04:10.4370|7fhMUt|BORISLAVD|GetCurrentUser..
t Transfer: 1220 :      9|13:04:10.4370|7fhMUt|BORISLAVD|  OAuth authenticated
t Transfer: 1220 :      9|13:04:10.4370|7fhMUt|BORISLAVD|    user BORISLAVD.
t Information: 1220 :   9|13:04:10.4370|||TM_MIS. LoadSubtitles for ID: 291883
t Information: 1220 :   9|13:04:10.4370|||TM_MIS. LoadSubtitles for ID: 291883. SQL: 'select id, m_ctnr_id, m_ctnr_loc, modified_dt, tv_std, m_ctnr_fmt_id, 
    nvl((select max(l.language) from tm_audio l where l.miid=m.id),aud_language_id) aud_language_id
  from tm_mis m where mi_deleted=0 and item_type>0 and media_type=101 and PGM_PARENT_ID=278628'
t Information: 1220 :   9|13:04:10.4370|||    Subtitles added for ID: 291883, 291723 English : 'https://imfxv3tm.tmd.tv/getcaptions.aspx?f=inside game of thrones.stl&som=00:00:00:00&storage=TimedText&modified=637181405010000000&tcf=0&id=291723&tmp=0'.
t Verbose: 1220 :       9|13:04:10.6400|7fhMUt|BORISLAVD|imfx v3 API took 0.188s '/api/v3/media-details/291883?_dc=1588853050304'
t Transfer: 1220 :      9|13:04:10.6400|7fhMUt|BORISLAVD|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Game of Thrones - Blinkbox-HD.mp4 subfolder 
t Transfer: 1220 :      9|13:04:10.6400|7fhMUt|BORISLAVD|  GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Game of Thrones - Blinkbox-HD.mp4
t Transfer: 1220 :      9|13:04:10.6400|7fhMUt|BORISLAVD|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/Game of Thrones - Blinkbox-HD.mp4
t Transfer: 1220 :      9|13:04:10.6400|7fhMUt|BORISLAVD|GetCurrentUser..
t Transfer: 1220 :      9|13:04:10.6400|7fhMUt|BORISLAVD|  OAuth authenticated
t Transfer: 1220 :      9|13:04:10.6400|7fhMUt|BORISLAVD|    user BORISLAVD.
t Transfer: 1220 :      9|13:04:10.8431|748rH6|BORISLAVD|OAuth: /api/v3/media-captions/291883?_dc=1588853050651
t Transfer: 1220 :      9|13:04:10.8431|748rH6|BORISLAVD|GetCurrentUser..
t Transfer: 1220 :      9|13:04:10.8431|748rH6|BORISLAVD|  OAuth authenticated
t Transfer: 1220 :      9|13:04:10.8431|748rH6|BORISLAVD|    user BORISLAVD.
t Verbose: 1220 :       9|13:04:10.8431|748rH6|BORISLAVD|OAuth. User logged in: BORISLAVD
t Verbose: 1220 :       9|13:04:10.8431|748rH6|BORISLAVD|imfx v3 API took 0.012s '/api/v3/media-captions/291883?_dc=1588853050651'
t Transfer: 1220 :      9|13:04:10.8431|UdPoU1|BORISLAVD|OAuth: /api/v3/layout/default/6?_dc=1588853050663
t Transfer: 1220 :      9|13:04:10.8431|UdPoU1|BORISLAVD|GetCurrentUser..
t Transfer: 1220 :      9|13:04:10.8431|UdPoU1|BORISLAVD|  OAuth authenticated
t Transfer: 1220 :      9|13:04:10.8431|UdPoU1|BORISLAVD|    user BORISLAVD.
t Verbose: 1220 :       9|13:04:10.8431|UdPoU1|BORISLAVD|OAuth. User logged in: BORISLAVD
t Information: 1220 :   9|13:04:10.8431|UdPoU1|BORISLAVD|LoadDefaultDashboard.
t Transfer: 1220 :      9|13:04:10.8431|UdPoU1|BORISLAVD|GetCurrentUser..
t Transfer: 1220 :      9|13:04:10.8431|UdPoU1|BORISLAVD|  OAuth authenticated
t Transfer: 1220 :      9|13:04:10.8431|UdPoU1|BORISLAVD|    user BORISLAVD.
t Verbose: 1220 :       9|13:04:10.8431|UdPoU1|BORISLAVD|imfx v3 API took 0.066s '/api/v3/layout/default/6?_dc=1588853050663'
t Transfer: 1220 :      9|13:04:11.0463|DLGfVC|BORISLAVD|OAuth: /api/user-group-preferences?globals=htmlplayerhotkeys,audioOnFrameForward&_dc=1588853050875
t Transfer: 1220 :      9|13:04:11.0463|DLGfVC|BORISLAVD|GetCurrentUser..
t Transfer: 1220 :      9|13:04:11.0463|DLGfVC|BORISLAVD|  OAuth authenticated
t Transfer: 1220 :      9|13:04:11.0463|DLGfVC|BORISLAVD|    user BORISLAVD.
t Verbose: 1220 :       9|13:04:11.0463|DLGfVC|BORISLAVD|OAuth. User logged in: BORISLAVD
t Transfer: 1220 :      9|13:04:11.0463|DLGfVC|BORISLAVD|GetCurrentUser..
t Transfer: 1220 :      9|13:04:11.0463|DLGfVC|BORISLAVD|  OAuth authenticated
t Transfer: 1220 :      9|13:04:11.0463|DLGfVC|BORISLAVD|    user BORISLAVD.
t Information: 1220 :   9|13:04:11.0463|FdmNfI|BORISLAVD|V3Api.GetMediaTagging
t Verbose: 1220 :       9|13:04:11.0463|DLGfVC|BORISLAVD|imfx v3 API took 0.006s '/api/user-group-preferences?globals=htmlplayerhotkeys,audioOnFrameForward&_dc=1588853050875'
t Transfer: 1220 :      9|13:04:11.2494|Ph1DVb|BORISLAVD|OAuth: /api/v3/mediavideo/291883?info=smudge&_dc=1588853051092
t Transfer: 1220 :      9|13:04:11.2494|Ph1DVb|BORISLAVD|GetCurrentUser..
t Transfer: 1220 :      9|13:04:11.2494|Ph1DVb|BORISLAVD|  OAuth authenticated
t Transfer: 1220 :      9|13:04:11.2494|Ph1DVb|BORISLAVD|    user BORISLAVD.
t Verbose: 1220 :       9|13:04:11.2494|Ph1DVb|BORISLAVD|OAuth. User logged in: BORISLAVD
t Transfer: 1220 :      9|13:04:11.2494|Ph1DVb|BORISLAVD|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Game of Thrones - Blinkbox-HD.mp4 subfolder 
t Transfer: 1220 :      9|13:04:11.2494|Ph1DVb|BORISLAVD|  GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Game of Thrones - Blinkbox-HD.mp4
t Transfer: 1220 :      9|13:04:11.2494|Ph1DVb|BORISLAVD|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/Game of Thrones - Blinkbox-HD.mp4
t Transfer: 1220 :      9|13:04:11.2494|Ph1DVb|BORISLAVD|GetCurrentUser..
t Transfer: 1220 :      9|13:04:11.2494|Ph1DVb|BORISLAVD|  OAuth authenticated
t Transfer: 1220 :      9|13:04:11.2494|Ph1DVb|BORISLAVD|    user BORISLAVD.
t Verbose: 1220 :       9|13:04:11.2494|Ph1DVb|BORISLAVD|imfx v3 API took 0.031s '/api/v3/mediavideo/291883?info=smudge&_dc=1588853051092'
t Transfer: 1220 :      9|13:04:13.2806|8byA6j|BORISLAVD|OAuth: /api/v3/media-smudge/291883?_dc=1588853053099
t Transfer: 1220 :      9|13:04:13.2806|8byA6j|BORISLAVD|GetCurrentUser..
t Transfer: 1220 :      9|13:04:13.2806|8byA6j|BORISLAVD|  OAuth authenticated
t Transfer: 1220 :      9|13:04:13.2806|8byA6j|BORISLAVD|    user BORISLAVD.
t Verbose: 1220 :       9|13:04:13.2806|8byA6j|BORISLAVD|OAuth. User logged in: BORISLAVD
t Verbose: 1220 :       9|13:04:13.2806|8byA6j|BORISLAVD|imfx v3 API took 0.008s '/api/v3/media-smudge/291883?_dc=1588853053099'
t Transfer: 1220 :      9|13:05:03.8588|nnbSj5|BORISLAVD|GetCurrentUser..
t Transfer: 1220 :      9|13:05:03.8588|nnbSj5|BORISLAVD|  OAuth authenticated
t Transfer: 1220 :      9|13:05:03.8588|nnbSj5|BORISLAVD|    user BORISLAVD.
t Transfer: 1220 :      9|13:05:04.0619|RSBW6r|BORISLAVD|OAuth: /api/v3/search/workflow/media?_dc=1588853103798
t Transfer: 1220 :      9|13:05:04.0619|RSBW6r|BORISLAVD|GetCurrentUser..
t Transfer: 1220 :      9|13:05:04.0619|RSBW6r|BORISLAVD|  OAuth authenticated
t Transfer: 1220 :      9|13:05:04.0619|RSBW6r|BORISLAVD|    user BORISLAVD.
t Verbose: 1220 :       9|13:05:04.0619|RSBW6r|BORISLAVD|OAuth. User logged in: BORISLAVD
t Information: 1220 :   9|13:05:04.0619|RSBW6r|BORISLAVD|V3Api.SearchWorkflowsWithMedia
t Transfer: 1220 :      9|13:05:04.0619|RSBW6r|BORISLAVD|GetCurrentUser..
t Transfer: 1220 :      9|13:05:04.0619|RSBW6r|BORISLAVD|  OAuth authenticated
t Transfer: 1220 :      9|13:05:04.0619|RSBW6r|BORISLAVD|    user BORISLAVD.
t Information: 1220 :   9|13:05:04.0619|RSBW6r|BORISLAVD|SearchJob SQL:
 select * from (select a.*, rownum rnum  from ( select  /*+ INDEX(j JB_CMBST_IDX) */ j.*
    ,p.pname
    ,mi.tv_std
    ,mi.MIID1, mi.MIID2, mi.MIID3, mi.VERSIONID1, mi.VERSIONID2, mi.PROGID1, mi.PROGID2 
    ,txd.NEXT_TX_DATE
  FROM tm_mjob j 
    left join tm_mjob_pset p on j.j_sched_indx=p.id
    left join (select  j_id, TMD_str_agg(distinct miid1) MIID1, TMD_str_agg(distinct miid2) MIID2, TMD_str_agg(distinct miid3) MIID3, TMD_str_agg(distinct versionid1) VERSIONID1, TMD_str_agg(distinct versionid2) VERSIONID2, TMD_str_agg(distinct progid1) PROGID1, TMD_str_agg(distinct progid2) PROGID2, TMD_str_agg(distinct m.tv_std) TV_STD from tm_mis m, tm_mtsk_it i 
      where m.id=i.mi_id and i.src_dest in (2,3) group by j_id) mi on mi.j_id=j.id 
    LEFT JOIN (
        SELECT it.j_id, min(sch.tx_tm_st) NEXT_TX_DATE FROM TM_MTSK_IT it, TM_MIS m, hr_sched sch
          WHERE m.id = it.MI_ID AND (sch.prod_num = m.PROGID2 OR sch.prod_num = (select rl.VERSIONID1 from TM_PG_RL rl where rl.ID = m.PGM_PARENT_ID)) AND sch.tx_tm_st > sysdate
            GROUP BY J_ID) txd ON txd.j_id = j.id 
   where 1=1  AND   j.id in (
    select v.id from TM_MJOB v
      where v.id in (
        select t.j_id from TM_MTSK_IT t where t.mi_id in (291883) and t.src_dest in (2, 3)
        UNION
        select m.cret_job from TM_MIS m where m.id in (291883)) and (v.cmb_stat not in (15, 18, 19, 23) or (v.CMB_STAT = 19 and v.J_FAILURE_RESOLVED = 0)
      )
    )
   and  j.cmb_stat not in (15,18,23)    AND j.J_CLI_CODE in ('TECHM') order by j.J_COMPL_BY, j.id desc, j.id ) a where rownum <= 50) where rnum >= 1 order by rnum
t Information: 1220 :   9|13:05:04.4682|RSBW6r|BORISLAVD|    jobs returned 10, searched in 00:00:00.4314531
t Information: 1220 :   9|13:05:04.6713|RSBW6r|BORISLAVD|TechReports is not found. ID: 96.
t Information: 1220 :   9|13:05:04.6713|RSBW6r|BORISLAVD|TechReports is not found. ID: 41.
t Information: 1220 :   9|13:05:04.6713|RSBW6r|BORISLAVD|TechReports is not found. ID: 116.
t Information: 1220 :   9|13:05:04.6713|RSBW6r|BORISLAVD|TechReports is not found. ID: 672.
t Information: 1220 :   9|13:05:04.6713|RSBW6r|BORISLAVD|TechReports is not found. ID: 27.
t Information: 1220 :   9|13:05:04.6713|RSBW6r|BORISLAVD|    tasks returned 10, searched in 00:00:00.0771100
t Verbose: 1220 :       9|13:05:04.6713|RSBW6r|BORISLAVD|imfx v3 API took 0.612s '/api/v3/search/workflow/media?_dc=1588853103798'
t Transfer: 1220 :      9|13:05:05.0775|6lPrT_|BORISLAVD|OAuth: /api/v3/search/workflow/media?_dc=1588853105019
t Transfer: 1220 :      9|13:05:05.0775|6lPrT_|BORISLAVD|GetCurrentUser..
t Transfer: 1220 :      9|13:05:05.0775|6lPrT_|BORISLAVD|  OAuth authenticated
t Transfer: 1220 :      9|13:05:05.0775|6lPrT_|BORISLAVD|    user BORISLAVD.
t Verbose: 1220 :       9|13:05:05.0775|6lPrT_|BORISLAVD|OAuth. User logged in: BORISLAVD
t Information: 1220 :   9|13:05:05.0775|6lPrT_|BORISLAVD|V3Api.SearchWorkflowsWithMedia
t Transfer: 1220 :      9|13:05:05.0775|6lPrT_|BORISLAVD|GetCurrentUser..
t Transfer: 1220 :      9|13:05:05.0775|6lPrT_|BORISLAVD|  OAuth authenticated
t Transfer: 1220 :      9|13:05:05.0775|6lPrT_|BORISLAVD|    user BORISLAVD.
t Information: 1220 :   9|13:05:05.2806|6lPrT_|BORISLAVD|SearchJob SQL:
 select * from (select a.*, rownum rnum  from ( select  /*+ INDEX(j JB_CMBST_IDX) */ j.*
    ,p.pname
    ,mi.tv_std
    ,mi.MIID1, mi.MIID2, mi.MIID3, mi.VERSIONID1, mi.VERSIONID2, mi.PROGID1, mi.PROGID2 
    ,txd.NEXT_TX_DATE
  FROM tm_mjob j 
    left join tm_mjob_pset p on j.j_sched_indx=p.id
    left join (select  j_id, TMD_str_agg(distinct miid1) MIID1, TMD_str_agg(distinct miid2) MIID2, TMD_str_agg(distinct miid3) MIID3, TMD_str_agg(distinct versionid1) VERSIONID1, TMD_str_agg(distinct versionid2) VERSIONID2, TMD_str_agg(distinct progid1) PROGID1, TMD_str_agg(distinct progid2) PROGID2, TMD_str_agg(distinct m.tv_std) TV_STD from tm_mis m, tm_mtsk_it i 
      where m.id=i.mi_id and i.src_dest in (2,3) group by j_id) mi on mi.j_id=j.id 
    LEFT JOIN (
        SELECT it.j_id, min(sch.tx_tm_st) NEXT_TX_DATE FROM TM_MTSK_IT it, TM_MIS m, hr_sched sch
          WHERE m.id = it.MI_ID AND (sch.prod_num = m.PROGID2 OR sch.prod_num = (select rl.VERSIONID1 from TM_PG_RL rl where rl.ID = m.PGM_PARENT_ID)) AND sch.tx_tm_st > sysdate
            GROUP BY J_ID) txd ON txd.j_id = j.id 
   where 1=1  AND   j.id in (
    select v.id from TM_MJOB v
      where v.id in (
        select t.j_id from TM_MTSK_IT t where t.mi_id in (291883) and t.src_dest in (2, 3)
        UNION
        select m.cret_job from TM_MIS m where m.id in (291883)) and (v.cmb_stat not in (15, 18, 19, 23) or (v.CMB_STAT = 19 and v.J_FAILURE_RESOLVED = 0)
      )
    )
   and  j.cmb_stat not in (15,18,23)    AND j.J_CLI_CODE in ('TECHM') order by j.J_COMPL_BY, j.id desc, j.id ) a where rownum <= 50) where rnum >= 1 order by rnum
t Information: 1220 :   9|13:05:05.6869|6lPrT_|BORISLAVD|    jobs returned 10, searched in 00:00:00.4110051
t Information: 1220 :   9|13:05:05.6869|6lPrT_|BORISLAVD|TechReports is not found. ID: 96.
t Information: 1220 :   9|13:05:05.6869|6lPrT_|BORISLAVD|TechReports is not found. ID: 41.
t Information: 1220 :   9|13:05:05.6869|6lPrT_|BORISLAVD|TechReports is not found. ID: 116.
t Information: 1220 :   9|13:05:05.6869|6lPrT_|BORISLAVD|TechReports is not found. ID: 672.
t Information: 1220 :   9|13:05:05.6869|6lPrT_|BORISLAVD|TechReports is not found. ID: 27.
t Information: 1220 :   9|13:05:05.6869|6lPrT_|BORISLAVD|    tasks returned 10, searched in 00:00:00.0523021
t Verbose: 1220 :       9|13:05:05.6869|6lPrT_|BORISLAVD|imfx v3 API took 0.538s '/api/v3/search/workflow/media?_dc=1588853105019'
t Information: 1220 :   9|13:25:15.5618|||OrabitWatcherBasic. Disposing.
t Information: 1220 :   9|13:25:15.5618|||OrabitWatcherBasic. Disposed.
t Information: 1220 :   9|13:25:15.5618|||==========================================================================
t Information: 1220 :   9|13:25:15.5618|||IMFX CORE SERVER APPLICATION END.