t Information: 1220 :   9|12:50:37.3658|||Get Configuration Values:
t Information: 1220 :   9|12:50:37.3658|||	AdminPassEnc, default: , value: ffqjrn0leKv4Lj2YJHe2dw==.
t Information: 1220 :   9|12:50:37.3658|||	EncryptedPasswords, default: false, value: true.
t Information: 1220 :   9|12:50:37.3658|||	OraConnectionString, default: , value: Server=TECHM;User Id=imfx;Password=xxxxx;Unicode=true;.
t Information: 1220 :   9|12:50:37.3658|||	SecondTimezone, default: , value: .
t Information: 1220 :   9|12:50:37.3658|||	UseActiveDirectoryAuth, default: false, value: false.
t Information: 1220 :   9|12:50:37.3658|||	ReportingServiceUrl, default: , value: http://localhost:92/ReportingService.svc.
t Information: 1220 :   9|12:50:37.3658|||	ReportsPath, default: , value: .
t Information: 1220 :   9|12:50:37.3658|||	ReportsURL, default: , value: .
t Information: 1220 :   9|12:50:37.3658|||	TapeServiceUrl, default: , value: .
t Information: 1220 :   9|12:50:37.3658|||	GatekeeperUrl, default: , value: .
t Information: 1220 :   9|12:50:37.3658|||	ValuationUrl, default: , value: .
t Information: 1220 :   9|12:50:37.3658|||	QueueManagerDelay, default: 30, value: 30.
t Information: 1220 :   9|12:50:37.3658|||	QueueManagerFullRefresh, default: 90, value: 90.
t Information: 1220 :   9|12:50:37.3658|||	AudioLoopDuration, default: 0, value: 150.
t Information: 1220 :   9|12:50:37.3658|||	AudioLoopsCount, default: 0, value: 0.
t Information: 1220 :   9|12:50:37.3658|||	PlayerFakeStep, default: 500, value: 500.
t Information: 1220 :   9|12:50:37.3658|||	PlayerForceRatio, default: 0, value: 1.
t Information: 1220 :   9|12:50:37.3658|||	CheckVersionsInProd, default: false, value: True.
t Information: 1220 :   9|12:50:37.3658|||	MaxResults, default: 3000, value: 10000.
t Information: 1220 :   9|12:50:37.3658|||	NetworkRestriction, default: false, value: True.
t Information: 1220 :   9|12:50:37.3658|||	TEReportID, default: 0, value: 0.
t Information: 1220 :   9|12:50:37.3658|||	ClosedCaptionsCache, default: , value: C:\inetpub\wwwroot\imfxcore\timedtextcache\.
t Information: 1220 :   9|12:50:37.3658|||	ClosedCaptionsStorage, default: , value: c:\Mediaflex\subs.
t Information: 1220 :   9|12:50:37.3658|||	TimeCodeFormat, default: , value: pal.
t Information: 1220 :   9|12:50:37.3658|||	RceMediaPath, default: , value: C:\edl\.
t Information: 1220 :   9|12:50:37.3658|||	RceMediaPath, default: , value: C:\edl\.
t Information: 1220 :   9|12:50:37.3658|||	RceCsmOutputPath, default: , value: C:\Inetpub\wwwroot\csm\.
t Information: 1220 :   9|12:50:37.3658|||	RceCsmUrl, default: , value: http://localhost/csm/.
t Information: 1220 :   9|12:50:37.3658|||	RceMediaSelection, default: , value: miLinkIdMatch.
t Information: 1220 :   9|12:50:37.3658|||	RequestBrowseJobPresetName, default: , value: .
t Information: 1220 :   9|12:50:37.3658|||	DontExtendDuration, default: false, value: False.
t Information: 1220 :   9|12:50:37.3658|||	V3ConfigUrl, default: , value: .
t Information: 1220 :   9|12:50:37.3658|||	StopWords, default: , value: .
t Information: 1220 :   9|12:50:37.3658|||	MisrTxFormat, default: G, value: G.
t Information: 1220 :   9|12:50:37.3658|||	ApiServer, default: , value: http://192.168.120.10:85.
t Information: 1220 :   9|12:50:37.3658|||	ApiTimeout, default: 120, value: 120.
t Information: 1220 :   9|12:50:37.3658|||	ApiWorkers, default: 10, value: 10.
t Information: 1220 :   9|12:50:37.3658|||	UsePerfCounters, default: false, value: false.
t Information: 1220 :   9|12:50:37.3658|||	StatsdAddress, default: , value: .
t Information: 1220 :   9|12:50:37.3658|||	LogGetCurrentUser, default: true, value: true.
t Information: 1220 :   9|12:50:37.3658|||	LogInternalApi, default: true, value: true.
t Information: 1220 :   9|12:50:37.3658|||	ThumbnailServer, default: , value: .
t Information: 1220 :   9|12:50:37.3658|||	LocationFilter, default: , value: .
t Information: 1220 :   9|12:50:37.3658|||	SvUtilServiceUrl, default: , value: .
t Information: 1220 :   9|12:50:37.3658|||	SolrConnection, default: , value: http://192.168.120.14:8983/solr.
t Information: 1220 :   9|12:50:37.3658|||	UseIndexServerSearch, default: false, value: True.
t Information: 1220 :   9|12:50:37.3658|||	SolrIndexVersion, default: 1, value: 6.
t Information: 1220 :   9|12:50:37.3658|||	SolrConnection, default: , value: http://192.168.120.14:8983/solr.
t Information: 1220 :   9|12:50:37.3658|||	FacetsGroups, default: , value: owners,season_id, series_id,version_key,item_type,media_type,media_format,episode_number.
t Information: 1220 :   9|12:50:37.3658|||	FacetsGroupsVersion, default: , value: owners,season_id, series_id,version_key,episode_number.
t Information: 1220 :   9|12:50:37.3658|||	FacetsGroupsChameleon, default: , value: season_id, series_id,genre,prod_year,version_key.
t Information: 1220 :   9|12:50:37.3658|||	PreviewPreset, default: , value: .
t Information: 1220 :   9|12:50:37.3658|||	DevMode, default: false, value: false.
t Information: 1220 :   9|12:50:37.3658|||	DisableSysMan, default: false, value: false.
t Information: 1220 :   9|12:50:37.3658|||	TimeCodeFormat, default: , value: pal.
t Information: 1220 :   9|12:50:37.3658|||	FileCatalystStorageDevice, default: , value: .
t Information: 1220 :   9|12:50:37.3658|||	UseResponsibilityTracking, default: true, value: True.
t Information: 1220 :   9|12:50:37.3658|||	SubtitleDeviceFilter, default: , value: .
t Information: 1220 :   9|12:50:37.3658|||	SystemMonitorNamedPipe, default: , value: .
t Information: 1220 :   9|12:50:37.3658|||	OracleMonitorEnable, default: false, value: False.
t Information: 1220 :   9|12:50:37.3658|||	ArcApiHost, default: , value: .
t Information: 1220 :   9|12:50:37.3658|||	RabbitMqUrl, default: , value: amqp://192.168.120.14:5672.
t Information: 1220 :   9|12:50:37.3814|||	SolrTimedTextSearch, default: false, value: false.
t Information: 1220 :   9|12:50:37.3814|||	ProductionDurationUsageID, default: 1, value: 1.
t Information: 1220 :   9|12:50:37.7876|||GetStreamServers..
t Information: 1220 :   9|12:50:38.6001|||	https://demo.tmd.tv/CBR Video/ |CBR Video| False  
t Information: 1220 :   9|12:50:38.6001|||	https://demo.tmd.tv/CBR Images/ |CBR Images| False  
t Information: 1220 :   9|12:50:38.6001|||	https://demo.tmd.tv/CBR Audio/ |CBR Audio| False  
t Information: 1220 :   9|12:50:38.6001|||	https://demo.tmd.tv/Temp Upload/ |TEMP_UPLOAD| False  
t Information: 1220 :   9|12:50:38.6001|||	http://localhost:82/images/ |IMAGES| False  
t Information: 1220 :   9|12:50:38.6001|||	http://192.168.91.73/smoothcloud/ |SMOOTH_CLOUD| False  
t Information: 1220 :   9|12:50:38.6001|||	http://192.168.91.73/cloudstore/ |CLOUD_STORE| False  
t Information: 1220 :   9|12:50:38.6001|||	http://192.168.91.73/editsystemin/ |EDIT_SYSTEM_IN| False  
t Information: 1220 :   9|12:50:38.6001|||	http://192.168.91.27:89/APPLEPROXY/ |APPLE_PROXY| False  
t Information: 1220 :   9|12:50:38.6001|||	http://localhost:82/video/ |FILESTORE_VIDEO| False  
t Information: 1220 :   9|12:50:38.6001|||	https://imfxv3tm.tmd.tv/streaming/ |Streaming| False  
t Information: 1220 :   9|12:50:38.6001|||	https://imfxv3tm.tmd.tv/VideoServer/ |Video| False  
t Information: 1220 :   9|12:50:38.6001|||	https://imfxv3tm.tmd.tv/AdobeIn/ |Adobe Premiere Pro In| False  
t Information: 1220 :   9|12:50:38.6001|||	https://imfxv3tm.tmd.tv/AudioServer/ |Audio| False  
t Information: 1220 :   9|12:50:38.6001|||	https://imfxv3tm.tmd.tv/ImageServer/ |Image| False  
t Information: 1220 :   9|12:50:38.6001|||	https://imfxv3tm.tmd.tv/DocsServer/ |Docs| False  
t Information: 1220 :   9|12:50:38.6001|||	https://imfxv3tm.tmd.tv/AmazonLabs/ |TEST HOUSE| False  
t Information: 1220 :   9|12:50:38.6001|||	SolrConnectionUms, default: http://192.168.120.14:8983/solr, value: http://192.168.120.14:8983/solr.
t Information: 1220 :   9|12:50:38.6001|||	LogWebApi, default: false, value: false.
t Information: 1220 :   9|12:50:38.6001|||	EmbeddedRceUrl, default: , value: .
t Information: 1220 :   9|12:50:38.6001|||	InstallMode, default: , value: .
t Information: 1220 :   9|12:50:38.6001|||	SamlRequestAddress, default: , value: .
t Information: 1220 :   9|12:50:38.6001|||	SamlTrustedIssuer, default: , value: .
t Information: 1220 :   9|12:50:38.6001|||	SamlLoginRedirect, default: , value: .
t Information: 1220 :   9|12:50:38.6001|||	NaturalLangSearch, default: false, value: True.
t Information: 1220 :   9|12:50:38.6001|||	OktaLoginField, default: , value: .
t Information: 1220 :   9|12:50:38.6001|||	AuthenticationTypes, default: , value: Native,PublicApiKey.
t Information: 1220 :   9|12:50:38.6001|||OrabitWatcherBasic. Initialize.
t Information: 1220 :   9|12:50:38.8188|||FillDictionaryCache.
t Information: 1220 :   9|12:50:42.5532|||GetSupportedOperators
t Information: 1220 :   9|12:50:42.9595|||CacheTechReports.
t Information: 1220 :   9|12:50:43.1626|||& Cache update. Server (global) filled with timestamp 12:04:42.9595174. types null
t Information: 1220 :   9|12:50:43.1626|||InitializeFromDatabase.
  'Server=TECHM;User Id=imfx;password=..;Unicode=true;'
  direct False, home , timeout 15
t Information: 1220 :   9|12:50:43.1626|||FillDictionaryCache.
t Information: 1220 :   9|12:50:43.1626|||& Cache update. Server (global) filled with timestamp 12:04:42.9907664. types FriendlyNames, DatabaseSearchFieldData
t Information: 1220 :   9|12:50:43.5689|||OrabitWatcherBasic trying to connect..
t Information: 1220 :   9|12:50:43.7720|||==========================================================================
t Information: 1220 :   9|12:50:43.7720|||IMFX CORE SERVER APPLICATION START.
t Information: 1220 :   9|12:50:43.7720|||DLL VERSION: 2.5.0.2610.
t Information: 1220 :   9|12:50:43.7720|||IS TIMER HIGH RESOULTION : True.
t Information: 1220 :   9|12:50:43.7720|||	UmsDev, default: False, value: False.
t Information: 1220 :   9|12:50:43.7720|||OrabitWatcherBasic connected.
t Information: 1220 :   9|12:50:43.7720|||OrabitWatcherBasic queue created tmd.cfg.in.b282e25f-96dd-473a-a2d8-2e93a7be77e7
t Transfer: 1220 :      9|12:50:51.4907|3Bb3vx||GetAppInfo. DB: TMDDEMO. Install mode: . Auth types: Native, PublicApiKey
t Verbose: 1220 :       9|12:50:56.7720|lYenxP||Oauth validating..
t Verbose: 1220 :       9|12:50:56.7720|lYenxP||GrantResourceOwnerCredentials.
t Verbose: 1220 :       9|12:50:56.7720|lYenxP||LoginUser. daniel, login type OAuth, encrypt password True
t Information: 1220 :   9|12:50:56.7720|lYenxP||TryLoginUser. daniel, login type OAuth, check password True, check hash False, encrypt password True, load user data False
t Information: 1220 :   9|12:50:57.1782|lYenxP||  oauth token 00000000-0000-0000-0000-000000000000
t Information: 1220 :   9|12:50:57.1782|lYenxP||TryLoginUser. Logged in..
t Information: 1220 :   9|12:50:57.1782|lYenxP||GetPasswordPolicy. WARNING: Policy not found for system Imediaflex. Validation disabled.
t Verbose: 1220 :       9|12:50:57.1782|lYenxP||LoginUser. Adding history. User Id 342, result DANIEL, host 192.168.127.6
t Verbose: 1220 :       9|12:50:57.1782|lYenxP||GrantResourceOwnerCredentials. Try login finished. Logged: True
t Transfer: 1220 :      9|12:50:57.3814|BxMRN4|DANIEL|OAuth: /api/user-group-preferences?keys=defaultSearchColumnsMedia,defaultSearchColumnsVersion,defaultSearchColumnsSimple,defaultSearchMisrDetailsMediaColumns,versionCreationSettings,associate.advanced_search.version.setups,associate.advanced_search.media.setups,associate.wfrise.setups,supplier_portal.advanced_search.version.setups,supplier_portal.version_complete.setups,logoImage,uploadSettings&globals=isDebugMode,htmlplayerhotkeys,versionCreationSettings,associate.advanced_search.version.setups,associate.advanced_search.media.setups,associate.wfrise.setups,supplier_portal.advanced_search.version.setups&_dc=1587383462534
t Transfer: 1220 :      9|12:50:57.3814|BxMRN4|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|12:50:57.3814|BxMRN4|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|12:50:57.3814|BxMRN4|DANIEL|    user DANIEL.
t Verbose: 1220 :       9|12:50:57.3814|BxMRN4|DANIEL|OAuth. User logged in: DANIEL
t Transfer: 1220 :      9|12:50:57.3814|BxMRN4|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|12:50:57.3814|BxMRN4|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|12:50:57.3814|BxMRN4|DANIEL|    user DANIEL.
t Verbose: 1220 :       9|12:50:57.3814|BxMRN4|DANIEL|imfx v3 API took 0.037s '/api/user-group-preferences?keys=defaultSearchColumnsMedia,defaultSearchColumnsVersion,defaultSearchColumnsSimple,defaultSearchMisrDetailsMediaColumns,versionCreationSettings,associate.advanced_search.version.setups,associate.advanced_search.media.setups,associate.wfrise.setups,supplier_portal.advanced_search.version.setups,supplier_portal.version_complete.setups,logoImage,uploadSettings&globals=isDebugMode,htmlplayerhotkeys,versionCreationSettings,associate.advanced_search.version.setups,associate.advanced_search.media.setups,associate.wfrise.setups,supplier_portal.advanced_search.version.setups&_dc=1587383462534'
t Transfer: 1220 :      9|12:50:57.3814|KUSoSz|DANIEL|OAuth: /api/user-preferences?keys=personal_settings;basket;default_page;color_schema;media.basket.data;defaultSearch&_dc=1587383462616
t Transfer: 1220 :      9|12:50:57.3814|KUSoSz|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|12:50:57.3814|KUSoSz|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|12:50:57.3814|KUSoSz|DANIEL|    user DANIEL.
t Verbose: 1220 :       9|12:50:57.3814|KUSoSz|DANIEL|OAuth. User logged in: DANIEL
t Information: 1220 :   9|12:50:57.3814|KUSoSz|DANIEL|GetUserDataByKeys: personal_settings;basket;default_page;color_schema;media.basket.data;defaultSearch
t Transfer: 1220 :      9|12:50:57.3814|KUSoSz|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|12:50:57.3814|KUSoSz|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|12:50:57.3814|KUSoSz|DANIEL|    user DANIEL.
t Transfer: 1220 :      9|12:50:57.3814|jlYib6|DANIEL|OAuth: /api/lookups/MediaStatus?_dc=1587383462618
t Transfer: 1220 :      9|12:50:57.3814|jlYib6|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|12:50:57.3814|jlYib6|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|12:50:57.3814|jlYib6|DANIEL|    user DANIEL.
t Verbose: 1220 :       9|12:50:57.3814|jlYib6|DANIEL|OAuth. User logged in: DANIEL
t Transfer: 1220 :      9|12:50:57.3814|CBFIgZ|DANIEL|OAuth: /api/lookups/PgmStatus?_dc=1587383462620
t Transfer: 1220 :      9|12:50:57.3814|CBFIgZ|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|12:50:57.3814|CBFIgZ|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|12:50:57.3814|CBFIgZ|DANIEL|    user DANIEL.
t Verbose: 1220 :       9|12:50:57.3814|CBFIgZ|DANIEL|OAuth. User logged in: DANIEL
t Verbose: 1220 :       9|12:50:57.3814|KUSoSz|DANIEL|imfx v3 API took 0.035s '/api/user-preferences?keys=personal_settings;basket;default_page;color_schema;media.basket.data;defaultSearch&_dc=1587383462616'
t Verbose: 1220 :       9|12:50:57.3814|CBFIgZ|DANIEL|imfx v3 API took 0.034s '/api/lookups/PgmStatus?_dc=1587383462620'
t Verbose: 1220 :       9|12:50:57.3814|jlYib6|DANIEL|imfx v3 API took 0.034s '/api/lookups/MediaStatus?_dc=1587383462618'
t Information: 1220 :   9|12:50:57.3814|C0hwSW|DANIEL|GetUserProfile. Id: 0
t Transfer: 1220 :      9|12:50:57.3814|C0hwSW|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|12:50:57.3814|C0hwSW|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|12:50:57.3814|C0hwSW|DANIEL|    user DANIEL.
t Transfer: 1220 :      9|12:50:57.5845|y5WN7B|DANIEL|OAuth: /api/settings/user/defaultHomePage?_dc=1587383462789
t Transfer: 1220 :      9|12:50:57.5845|y5WN7B|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|12:50:57.5845|y5WN7B|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|12:50:57.5845|y5WN7B|DANIEL|    user DANIEL.
t Verbose: 1220 :       9|12:50:57.5845|y5WN7B|DANIEL|OAuth. User logged in: DANIEL
t Transfer: 1220 :      9|12:50:57.5845|y5WN7B|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|12:50:57.5845|y5WN7B|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|12:50:57.5845|y5WN7B|DANIEL|    user DANIEL.
t Verbose: 1220 :       9|12:50:57.5845|y5WN7B|DANIEL|imfx v3 API took 0.014s '/api/settings/user/defaultHomePage?_dc=1587383462789'
t Transfer: 1220 :      9|12:50:58.3970|HyHTRm|DANIEL|OAuth: /api/settings/user/consumer?_dc=1587383463522
t Transfer: 1220 :      9|12:50:58.3970|HyHTRm|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|12:50:58.3970|HyHTRm|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|12:50:58.3970|HyHTRm|DANIEL|    user DANIEL.
t Verbose: 1220 :       9|12:50:58.3970|HyHTRm|DANIEL|OAuth. User logged in: DANIEL
t Transfer: 1220 :      9|12:50:58.3970|HyHTRm|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|12:50:58.3970|HyHTRm|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|12:50:58.3970|HyHTRm|DANIEL|    user DANIEL.
t Verbose: 1220 :       9|12:50:58.3970|HyHTRm|DANIEL|imfx v3 API took 0.008s '/api/settings/user/consumer?_dc=1587383463522'
t Transfer: 1220 :      9|12:50:58.3970|WFjcL9|DANIEL|OAuth: /api/settings/user/uploadSettings?_dc=1587383463646
t Transfer: 1220 :      9|12:50:58.3970|WFjcL9|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|12:50:58.3970|WFjcL9|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|12:50:58.3970|WFjcL9|DANIEL|    user DANIEL.
t Verbose: 1220 :       9|12:50:58.3970|WFjcL9|DANIEL|OAuth. User logged in: DANIEL
t Transfer: 1220 :      9|12:50:58.3970|WFjcL9|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|12:50:58.3970|WFjcL9|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|12:50:58.3970|WFjcL9|DANIEL|    user DANIEL.
t Verbose: 1220 :       9|12:50:58.3970|WFjcL9|DANIEL|imfx v3 API took 0.006s '/api/settings/user/uploadSettings?_dc=1587383463646'
t Transfer: 1220 :      9|12:50:58.6001|P3xYbm|DANIEL|OAuth: /api/user-preferences?keys=consumer.recent.data&_dc=1587383463735
t Transfer: 1220 :      9|12:50:58.6001|P3xYbm|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|12:50:58.6001|P3xYbm|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|12:50:58.6001|P3xYbm|DANIEL|    user DANIEL.
t Verbose: 1220 :       9|12:50:58.6001|P3xYbm|DANIEL|OAuth. User logged in: DANIEL
t Information: 1220 :   9|12:50:58.6001|P3xYbm|DANIEL|GetUserDataByKeys: consumer.recent.data
t Transfer: 1220 :      9|12:50:58.6001|P3xYbm|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|12:50:58.6001|P3xYbm|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|12:50:58.6001|P3xYbm|DANIEL|    user DANIEL.
t Verbose: 1220 :       9|12:50:58.6001|P3xYbm|DANIEL|imfx v3 API took 0.006s '/api/user-preferences?keys=consumer.recent.data&_dc=1587383463735'
t Transfer: 1220 :      9|12:50:58.8032|9tHoEN|DANIEL|OAuth: /api/settings/user/defaultSearch?_dc=1587383463964
t Transfer: 1220 :      9|12:50:58.8032|9tHoEN|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|12:50:58.8032|9tHoEN|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|12:50:58.8032|9tHoEN|DANIEL|    user DANIEL.
t Verbose: 1220 :       9|12:50:58.8032|9tHoEN|DANIEL|OAuth. User logged in: DANIEL
t Transfer: 1220 :      9|12:50:58.8032|9tHoEN|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|12:50:58.8032|9tHoEN|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|12:50:58.8032|9tHoEN|DANIEL|    user DANIEL.
t Transfer: 1220 :      9|12:50:58.8032|NO1xrN|DANIEL|OAuth: /api/settings/user/startSearch?_dc=1587383463966
t Transfer: 1220 :      9|12:50:58.8032|NO1xrN|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|12:50:58.8032|NO1xrN|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|12:50:58.8032|NO1xrN|DANIEL|    user DANIEL.
t Verbose: 1220 :       9|12:50:58.8032|NO1xrN|DANIEL|OAuth. User logged in: DANIEL
t Transfer: 1220 :      9|12:50:58.8032|NO1xrN|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|12:50:58.8032|NO1xrN|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|12:50:58.8032|NO1xrN|DANIEL|    user DANIEL.
t Verbose: 1220 :       9|12:50:58.8032|9tHoEN|DANIEL|imfx v3 API took 0.007s '/api/settings/user/defaultSearch?_dc=1587383463964'
t Verbose: 1220 :       9|12:50:58.8032|NO1xrN|DANIEL|imfx v3 API took 0.006s '/api/settings/user/startSearch?_dc=1587383463966'
t Transfer: 1220 :      9|12:50:59.0063|TMeMSe|DANIEL|OAuth: /api/user-preferences?keys=consumer.recent.data&_dc=1587383464161
t Transfer: 1220 :      9|12:50:59.0063|TMeMSe|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|12:50:59.0063|TMeMSe|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|12:50:59.0063|TMeMSe|DANIEL|    user DANIEL.
t Verbose: 1220 :       9|12:50:59.0063|TMeMSe|DANIEL|OAuth. User logged in: DANIEL
t Information: 1220 :   9|12:50:59.0063|TMeMSe|DANIEL|GetUserDataByKeys: consumer.recent.data
t Transfer: 1220 :      9|12:50:59.0063|TMeMSe|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|12:50:59.0063|TMeMSe|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|12:50:59.0063|TMeMSe|DANIEL|    user DANIEL.
t Verbose: 1220 :       9|12:50:59.0063|TMeMSe|DANIEL|imfx v3 API took 0.007s '/api/user-preferences?keys=consumer.recent.data&_dc=1587383464161'
t Transfer: 1220 :      9|12:51:02.8657|p_gYXO|DANIEL|OAuth: /api/view/searchinfo/TitleSearch?_dc=1587383468024
t Transfer: 1220 :      9|12:51:02.8657|p_gYXO|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|12:51:02.8657|p_gYXO|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|12:51:02.8657|p_gYXO|DANIEL|    user DANIEL.
t Verbose: 1220 :       9|12:51:02.8657|p_gYXO|DANIEL|OAuth. User logged in: DANIEL
t Transfer: 1220 :      9|12:51:02.8657|ZQVkEF|DANIEL|OAuth: /api/lookups/SearchSupportedOperators?_dc=1587383468025
t Transfer: 1220 :      9|12:51:02.8657|ZQVkEF|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|12:51:02.8657|ZQVkEF|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|12:51:02.8657|ZQVkEF|DANIEL|    user DANIEL.
t Verbose: 1220 :       9|12:51:02.8657|ZQVkEF|DANIEL|OAuth. User logged in: DANIEL
t Verbose: 1220 :       9|12:51:02.8657|ZQVkEF|DANIEL|imfx v3 API took 0.000s '/api/lookups/SearchSupportedOperators?_dc=1587383468025'
t Information: 1220 :   9|12:51:02.8657|p_gYXO|DANIEL|GetAdvSearchColumns. search type TitleSearch grid .
t Transfer: 1220 :      9|12:51:02.8657|vUjv53|DANIEL|OAuth: /api/user-preferences?keys=adv.recent.searches.titles&_dc=1587383468032
t Transfer: 1220 :      9|12:51:02.8657|vUjv53|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|12:51:02.8657|vUjv53|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|12:51:02.8657|vUjv53|DANIEL|    user DANIEL.
t Verbose: 1220 :       9|12:51:02.8657|vUjv53|DANIEL|OAuth. User logged in: DANIEL
t Information: 1220 :   9|12:51:02.8657|vUjv53|DANIEL|GetUserDataByKeys: adv.recent.searches.titles
t Transfer: 1220 :      9|12:51:02.8657|vUjv53|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|12:51:02.8657|vUjv53|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|12:51:02.8657|vUjv53|DANIEL|    user DANIEL.
t Verbose: 1220 :       9|12:51:02.8657|vUjv53|DANIEL|imfx v3 API took 0.006s '/api/user-preferences?keys=adv.recent.searches.titles&_dc=1587383468032'
t Verbose: 1220 :       9|12:51:02.8657|p_gYXO|DANIEL|imfx v3 API took 0.014s '/api/view/searchinfo/TitleSearch?_dc=1587383468024'
t Transfer: 1220 :      9|12:51:02.8657|k_PN9~|DANIEL|OAuth: /api/view/info/TitleTree?lang=en-GB&_dc=1587383468089
t Transfer: 1220 :      9|12:51:02.8657|k_PN9~|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|12:51:02.8657|k_PN9~|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|12:51:02.8657|k_PN9~|DANIEL|    user DANIEL.
t Verbose: 1220 :       9|12:51:02.8657|k_PN9~|DANIEL|OAuth. User logged in: DANIEL
t Information: 1220 :   9|12:51:02.8657|k_PN9~|DANIEL|GetGridViewBuilder. builder type TitleTree.
t Transfer: 1220 :      9|12:51:02.8657|k_PN9~|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|12:51:02.8657|k_PN9~|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|12:51:02.8657|k_PN9~|DANIEL|    user DANIEL.
t Information: 1220 :   9|12:51:02.8657|k_PN9~|DANIEL|UserGridView. LoadView. ID 856, Name Default.
t Transfer: 1220 :      9|12:51:02.8657|k_PN9~|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|12:51:02.8657|k_PN9~|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|12:51:02.8657|k_PN9~|DANIEL|    user DANIEL.
t Transfer: 1220 :      9|12:51:02.8657|k_PN9~|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|12:51:02.8657|k_PN9~|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|12:51:02.8657|k_PN9~|DANIEL|    user DANIEL.
t Transfer: 1220 :      9|12:51:02.8657|V2cIis|DANIEL|OAuth: /api/view/searches/TitleSearch?_dc=1587383468122
t Transfer: 1220 :      9|12:51:02.8657|V2cIis|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|12:51:02.8657|V2cIis|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|12:51:02.8657|V2cIis|DANIEL|    user DANIEL.
t Verbose: 1220 :       9|12:51:02.8657|V2cIis|DANIEL|OAuth. User logged in: DANIEL
t Information: 1220 :   9|12:51:02.8657|V2cIis|DANIEL|GetSavedSearchNames. search type TitleSearch.
t Transfer: 1220 :      9|12:51:02.8657|V2cIis|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|12:51:02.8657|V2cIis|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|12:51:02.8657|V2cIis|DANIEL|    user DANIEL.
t Verbose: 1220 :       9|12:51:02.8657|k_PN9~|DANIEL|imfx v3 API took 0.057s '/api/view/info/TitleTree?lang=en-GB&_dc=1587383468089'
t Transfer: 1220 :      9|12:51:02.8657|1f6qze|DANIEL|OAuth: /api/view/info/VersionGrid?lang=en-GB&_dc=1587383468148
t Transfer: 1220 :      9|12:51:02.8657|1f6qze|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|12:51:02.8657|1f6qze|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|12:51:02.8657|1f6qze|DANIEL|    user DANIEL.
t Verbose: 1220 :       9|12:51:02.8657|1f6qze|DANIEL|OAuth. User logged in: DANIEL
t Information: 1220 :   9|12:51:02.8657|1f6qze|DANIEL|GetGridViewBuilder. builder type VersionGrid.
t Transfer: 1220 :      9|12:51:02.8657|1f6qze|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|12:51:02.8657|1f6qze|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|12:51:02.8657|1f6qze|DANIEL|    user DANIEL.
t Information: 1220 :   9|12:51:02.8814|1f6qze|DANIEL|UserGridView. LoadView. ID 899, Name Default.
t Transfer: 1220 :      9|12:51:02.8814|1f6qze|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|12:51:02.8814|1f6qze|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|12:51:02.8814|1f6qze|DANIEL|    user DANIEL.
t Verbose: 1220 :       9|12:51:02.8814|V2cIis|DANIEL|imfx v3 API took 0.053s '/api/view/searches/TitleSearch?_dc=1587383468122'
t Transfer: 1220 :      9|12:51:02.8814|1f6qze|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|12:51:02.8814|1f6qze|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|12:51:02.8814|1f6qze|DANIEL|    user DANIEL.
t Verbose: 1220 :       9|12:51:02.8814|1f6qze|DANIEL|imfx v3 API took 0.035s '/api/view/info/VersionGrid?lang=en-GB&_dc=1587383468148'
t Transfer: 1220 :      9|12:51:03.1001|hpreOR|DANIEL|OAuth: /api/view/info/MediaGrid?lang=en-GB&_dc=1587383468237
t Transfer: 1220 :      9|12:51:03.1001|hpreOR|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|12:51:03.1001|hpreOR|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|12:51:03.1001|hpreOR|DANIEL|    user DANIEL.
t Verbose: 1220 :       9|12:51:03.1001|hpreOR|DANIEL|OAuth. User logged in: DANIEL
t Information: 1220 :   9|12:51:03.1001|hpreOR|DANIEL|GetGridViewBuilder. builder type MediaGrid.
t Transfer: 1220 :      9|12:51:03.1001|hpreOR|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|12:51:03.1001|hpreOR|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|12:51:03.1001|hpreOR|DANIEL|    user DANIEL.
t Information: 1220 :   9|12:51:03.1001|hpreOR|DANIEL|UserGridView. LoadView. ID 760, Name Default.
t Transfer: 1220 :      9|12:51:03.1001|hpreOR|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|12:51:03.1001|hpreOR|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|12:51:03.1001|hpreOR|DANIEL|    user DANIEL.
t Transfer: 1220 :      9|12:51:03.1001|hpreOR|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|12:51:03.1001|hpreOR|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|12:51:03.1001|hpreOR|DANIEL|    user DANIEL.
t Verbose: 1220 :       9|12:51:03.1001|hpreOR|DANIEL|imfx v3 API took 0.008s '/api/view/info/MediaGrid?lang=en-GB&_dc=1587383468237'
t Transfer: 1220 :      9|12:51:03.3032|sj7QSy|DANIEL|OAuth: /api/settings/user/uploadSettings?_dc=1587383468469
t Transfer: 1220 :      9|12:51:03.3032|sj7QSy|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|12:51:03.3032|sj7QSy|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|12:51:03.3032|sj7QSy|DANIEL|    user DANIEL.
t Verbose: 1220 :       9|12:51:03.3032|sj7QSy|DANIEL|OAuth. User logged in: DANIEL
t Transfer: 1220 :      9|12:51:03.3032|sj7QSy|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|12:51:03.3032|sj7QSy|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|12:51:03.3032|sj7QSy|DANIEL|    user DANIEL.
t Verbose: 1220 :       9|12:51:03.3032|sj7QSy|DANIEL|imfx v3 API took 0.003s '/api/settings/user/uploadSettings?_dc=1587383468469'
t Transfer: 1220 :      9|12:51:03.3032|vvdhjD|DANIEL|OAuth: /api/settings/user/uploadSettings?_dc=1587383468614
t Transfer: 1220 :      9|12:51:03.3032|vvdhjD|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|12:51:03.3032|vvdhjD|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|12:51:03.3032|vvdhjD|DANIEL|    user DANIEL.
t Verbose: 1220 :       9|12:51:03.3032|vvdhjD|DANIEL|OAuth. User logged in: DANIEL
t Transfer: 1220 :      9|12:51:03.3032|vvdhjD|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|12:51:03.3032|vvdhjD|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|12:51:03.3032|vvdhjD|DANIEL|    user DANIEL.
t Verbose: 1220 :       9|12:51:03.3032|vvdhjD|DANIEL|imfx v3 API took 0.003s '/api/settings/user/uploadSettings?_dc=1587383468614'
t Transfer: 1220 :      9|12:51:15.8970|2SRh3U|DANIEL|OAuth: /api/v3/search-suggestion/?_dc=1587383481069
t Transfer: 1220 :      9|12:51:15.8970|2SRh3U|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|12:51:15.8970|2SRh3U|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|12:51:15.8970|2SRh3U|DANIEL|    user DANIEL.
t Verbose: 1220 :       9|12:51:15.8970|2SRh3U|DANIEL|OAuth. User logged in: DANIEL
t Transfer: 1220 :      9|12:51:15.8970|2SRh3U|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|12:51:15.8970|2SRh3U|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|12:51:15.8970|2SRh3U|DANIEL|    user DANIEL.
t Transfer: 1220 :      9|12:51:16.3032|lHiciZ|DANIEL|OAuth: /api/v3/search-suggestion/?_dc=1587383481540
t Transfer: 1220 :      9|12:51:16.3032|lHiciZ|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|12:51:16.3032|lHiciZ|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|12:51:16.3032|lHiciZ|DANIEL|    user DANIEL.
t Verbose: 1220 :       9|12:51:16.3032|lHiciZ|DANIEL|OAuth. User logged in: DANIEL
t Transfer: 1220 :      9|12:51:16.3032|lHiciZ|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|12:51:16.3032|lHiciZ|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|12:51:16.3032|lHiciZ|DANIEL|    user DANIEL.
t Transfer: 1220 :      9|12:51:16.9126|94V5EG|DANIEL|OAuth: /api/v3/search/title?_dc=1587383482122
t Transfer: 1220 :      9|12:51:16.9126|94V5EG|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|12:51:16.9126|94V5EG|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|12:51:16.9126|94V5EG|DANIEL|    user DANIEL.
t Verbose: 1220 :       9|12:51:16.9126|94V5EG|DANIEL|OAuth. User logged in: DANIEL
t Information: 1220 :   9|12:51:16.9126|94V5EG|DANIEL|V3Api.SearchTitles
t Information: 1220 :   9|12:51:16.9126|94V5EG|DANIEL|V3Api.SearchGeneric
t Transfer: 1220 :      9|12:51:16.9126|94V5EG|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|12:51:16.9126|94V5EG|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|12:51:16.9126|94V5EG|DANIEL|    user DANIEL.
t Transfer: 1220 :      9|12:51:16.9126|94V5EG|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|12:51:16.9126|94V5EG|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|12:51:16.9126|94V5EG|DANIEL|    user DANIEL.
t Information: 1220 :   9|12:51:16.9126|94V5EG|DANIEL|SearchTitle SQL:
with 
 v as (
    SELECT 
        abs.*
       ,decode(ITEM_TYPE,
                 1010,SER_ABS_ID,
                 1020,CASE WHEN SER_ABS2_ID > 0 THEN SER_ABS2_ID ELSE SER_ABS_ID END
              ) xparent_id
      FROM TMDDBA.TM_PG_ABS abs
     WHERE abs.id in (
          select a.id
          FROM TMDDBA.TM_PG_ABS a
          where ABS_DELETED = 0  AND (CONTAINS(CTX_TEXT_COL,'test') > 0 OR CONTAINS(CTX_IDS_COL,'test') > 0 ) AND ROWNUM < 25000   )
      
 )
,v_missing_parent_ids as (
    select xparent_id from v
    minus
    select id from v
 )
,v_missing_parents as (
    SELECT 
        distinct a.*
       ,decode(ITEM_TYPE,
                 1010,SER_ABS_ID,
                 1020,CASE WHEN SER_ABS2_ID > 0 THEN SER_ABS2_ID ELSE SER_ABS_ID END
              ) xparent_id
      FROM TMDDBA.TM_PG_ABS a
    START WITH ID IN (select xparent_id from v_missing_parent_ids)
    CONNECT BY
           CASE PRIOR ITEM_TYPE
             WHEN 1010 THEN PRIOR SER_ABS_ID
             WHEN 1020 THEN 
               CASE WHEN NVL(PRIOR SER_ABS2_ID, 0) > 0 THEN PRIOR SER_ABS2_ID ELSE PRIOR SER_ABS_ID END
             END = ID
 )
,v_all as (
   select x.*, count(*) over() RowCount
   from (
     select * from v_missing_parents
     union 
     select * from v
   ) x
 )
,v_top as (
   select id
   from (select id, row_number()over(order by upper(ser_title),upper(title),ser_num,ser_ep_num, SER_EP_SQ_NUM ) rnk -- sort roots
         from v_all 
         where  xparent_id is null)
   where rnk between (:page_number-1)*50+1 and :page_number*50
)
,v_tree as (
   select level lvl, a.*
   from v_all a
   start with id in (select id from v_top)
   connect by xparent_id = prior ID
   order siblings by upper(ser_title),ser_num,ser_ep_num, SER_EP_SQ_NUM,upper(title) -- sort children
 )
select *
from v_tree 
--where rnk <= 50
t Verbose: 1220 :       9|12:51:17.5220|94V5EG|DANIEL|imfx v3 API took 0.534s '/api/v3/search/title?_dc=1587383482122'
t Transfer: 1220 :      9|12:51:18.3345|C6CyVR|DANIEL|OAuth: /api/v3/title/1671/versions?_dc=1587383483446
t Transfer: 1220 :      9|12:51:18.3345|C6CyVR|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|12:51:18.3345|C6CyVR|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|12:51:18.3345|C6CyVR|DANIEL|    user DANIEL.
t Verbose: 1220 :       9|12:51:18.3345|C6CyVR|DANIEL|OAuth. User logged in: DANIEL
t Transfer: 1220 :      9|12:51:18.3345|s5beNn|DANIEL|OAuth: /api/user-preferences?_dc=1587383483490
t Transfer: 1220 :      9|12:51:18.3345|s5beNn|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|12:51:18.3345|s5beNn|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|12:51:18.3345|s5beNn|DANIEL|    user DANIEL.
t Verbose: 1220 :       9|12:51:18.3345|s5beNn|DANIEL|OAuth. User logged in: DANIEL
t Information: 1220 :   9|12:51:18.3345|C6CyVR|DANIEL|V3Api.SearchGeneric
t Verbose: 1220 :       9|12:51:18.3345|s5beNn|DANIEL|StoreUserDataByKeys..
t Transfer: 1220 :      9|12:51:18.3345|s5beNn|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|12:51:18.3345|s5beNn|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|12:51:18.3345|s5beNn|DANIEL|    user DANIEL.
t Transfer: 1220 :      9|12:51:18.3345|C6CyVR|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|12:51:18.3345|C6CyVR|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|12:51:18.3345|C6CyVR|DANIEL|    user DANIEL.
t Transfer: 1220 :      9|12:51:18.3345|C6CyVR|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|12:51:18.3345|C6CyVR|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|12:51:18.3345|C6CyVR|DANIEL|    user DANIEL.
t Verbose: 1220 :       9|12:51:18.3345|s5beNn|DANIEL|imfx v3 API took 0.016s '/api/user-preferences?_dc=1587383483490'
t Information: 1220 :   9|12:51:18.3345|C6CyVR|DANIEL|SearchVersion SQL:
 select * from (select a.*, rownum rnum  from ( select  m.*, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE,  nvl(t.text_id,-1) THUMBID, BUILD_PGRL_FULLTITLE(item_type, title, ser_name, ser_title) FULLTITLE     from tmddba.tm_pg_rl m 
        left outer join (select text_id, text_data_path, text_data_filename, text_ref_object from tmddba.tm_text) t on t.text_id = m.primary_thumb_id
 where item_type>0 and rl_deleted=0  and m.PGM_ABS_ID=1671 
 order by m.title,m.id) a where rownum <= 9999) r where rnum >=1 order by rnum
t Information: 1220 :   9|12:51:18.3345|C6CyVR|DANIEL|Running version search. User: 342    Simple Search: 
Running Oracle search.
Running Oracle search for COUNT
Oracle count completed in: 15ms.  Returned lines: 0

t Verbose: 1220 :       9|12:51:18.3345|C6CyVR|DANIEL|imfx v3 API took 0.044s '/api/v3/title/1671/versions?_dc=1587383483446'
t Verbose: 1220 :       9|12:51:18.5376|lHiciZ|DANIEL|imfx v3 API took 2.138s '/api/v3/search-suggestion/?_dc=1587383481540'
t Verbose: 1220 :       9|12:51:18.5376|2SRh3U|DANIEL|imfx v3 API took 2.554s '/api/v3/search-suggestion/?_dc=1587383481069'
t Transfer: 1220 :      9|12:51:49.8188|FKxtoX|DANIEL|OAuth: /api/v3/title/26677/versions?_dc=1587383514948
t Transfer: 1220 :      9|12:51:49.8188|FKxtoX|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|12:51:49.8188|FKxtoX|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|12:51:49.8188|FKxtoX|DANIEL|    user DANIEL.
t Verbose: 1220 :       9|12:51:49.8188|FKxtoX|DANIEL|OAuth. User logged in: DANIEL
t Information: 1220 :   9|12:51:49.8188|FKxtoX|DANIEL|V3Api.SearchGeneric
t Transfer: 1220 :      9|12:51:49.8188|FKxtoX|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|12:51:49.8188|FKxtoX|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|12:51:49.8188|FKxtoX|DANIEL|    user DANIEL.
t Transfer: 1220 :      9|12:51:49.8188|FKxtoX|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|12:51:49.8188|FKxtoX|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|12:51:49.8188|FKxtoX|DANIEL|    user DANIEL.
t Information: 1220 :   9|12:51:49.8188|FKxtoX|DANIEL|SearchVersion SQL:
 select * from (select a.*, rownum rnum  from ( select  m.*, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE,  nvl(t.text_id,-1) THUMBID, BUILD_PGRL_FULLTITLE(item_type, title, ser_name, ser_title) FULLTITLE     from tmddba.tm_pg_rl m 
        left outer join (select text_id, text_data_path, text_data_filename, text_ref_object from tmddba.tm_text) t on t.text_id = m.primary_thumb_id
 where item_type>0 and rl_deleted=0  and m.PGM_ABS_ID=26677 
 order by m.title,m.id) a where rownum <= 9999) r where rnum >=1 order by rnum
t Information: 1220 :   9|12:51:49.8188|FKxtoX|DANIEL|Running version search. User: 342    Simple Search: 
Running Oracle search.
Running Oracle search for COUNT
Oracle count completed in: 5ms.  Returned lines: 1
Oracle version search timing: 83ms.
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=26677 
 order by m.title,m.id) a where rownum <= 9999) r where rnum >=1 order by rnum

t Verbose: 1220 :       9|12:51:49.8188|FKxtoX|DANIEL|imfx v3 API took 0.094s '/api/v3/title/26677/versions?_dc=1587383514948'
t Transfer: 1220 :      9|12:51:50.0220|E0mNt7|DANIEL|OAuth: /api/v3/version/84348/media?_dc=1587383515220
t Transfer: 1220 :      9|12:51:50.0220|E0mNt7|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|12:51:50.0220|E0mNt7|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|12:51:50.0220|E0mNt7|DANIEL|    user DANIEL.
t Verbose: 1220 :       9|12:51:50.0220|E0mNt7|DANIEL|OAuth. User logged in: DANIEL
t Information: 1220 :   9|12:51:50.0220|E0mNt7|DANIEL|V3Api.SearchGeneric
t Transfer: 1220 :      9|12:51:50.0220|E0mNt7|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|12:51:50.0220|E0mNt7|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|12:51:50.0220|E0mNt7|DANIEL|    user DANIEL.
t Information: 1220 :   9|12:51:50.0220|E0mNt7|DANIEL|MediaSearch SQL:
select r.*,
    nvl((select TMD_STR_AGG(c.u_id_pfix ) from tm_ctnrs c, tm_mi_tpi_lnx l where l.miid=r.id and c.u_id=l.tpiid and r.media_type=1),'') BARCODE,
    nvl(lnk.lib_loc_ext_id,0) lib_loc_ext_id, nvl(lnk.ctnr_loan_stat,0) ctnr_loan_status, nvl(lnk.ctnr_stat,0) ctnr_stat,
    nvl(t.text_data_path,'') THUMBSERVER, 
    nvl(t.text_data_filename,'') THUMBFILE,
    nvl(t.text_id,-1) THUMBID , 
    GETMEDIALOC(r.id, r.media_type, r.compil, r.m_ctnr_int_o_loc, r.m_ctnr_ext_o_loc, r.m_ctnr_loc) LOCATION,
    nvl(dfl.fSOM,0) FILE_SOM, nvl(dfl.fEOM,0) FILE_EOM, dfl.fos_fname FILENAME, dfl.DFILE_LINK_GUID, dfl.OS_GUID, dfl.SUB_FOLDER, dfl.ORIGINAL_FILENAME 

    from (select a.*, rownum rnum from 
      (select  m.*,
     coalesce(m.primary_thumb_id, (select v.primary_thumb_id from tm_pg_rl v where v.id=m.pgm_parent_id)) primary_thumb_id2 
      from tmddba.tm_mis m 
 where media_type>0 and item_type>0  AND  PGM_PARENT_ID=:pgm_parent_id_1  and m.mi_deleted=0  
 order by upper(m.title), m.media_type, m.ec_som, m.id ) a where rownum <= 50) r 
    ,lateral( select l.miid, max(c.C_EXT_OUT_LOC) lib_loc_ext_id, max(c.C_STAT) ctnr_stat, max(c.loan_stat) ctnr_loan_stat  from tm_mi_tpi_lnx l, tm_ctnrs c where c.u_id=l.tpiid and l.miid=r.id and r.media_type=1 group by l.miid)(+) lnk 
    ,lateral(select tt.* from tm_text tt where tt.text_id = r.primary_thumb_id2)(+) t
    ,lateral(select /*+ NO_DECORRELATE */  d.som fsom, d.eom feom, dl.mi_id fmi_id, d.os_fname fos_fname, d.DFILE_LINK_GUID, d.OS_GUID, d.SUB_FOLDER, dl.dfile_id, d.original_filename
        FROM tm_dfile d, tm_mi_dfile_lnx dl where d.id=dl.dfile_id and r.id=dl.mi_id and rownum=1)(+) dfl 
    
    where rnum >= 1 order by rnum
Param: pgm_parent_id_1: 84348
t Information: 1220 :   9|12:51:50.0220|E0mNt7|DANIEL|  count returned 0
t Verbose: 1220 :       9|12:51:50.0220|E0mNt7|DANIEL|imfx v3 API took 0.053s '/api/v3/version/84348/media?_dc=1587383515220'
t Transfer: 1220 :      9|12:51:50.6313|iG0ZHN|DANIEL|OAuth: /api/v3/title/3542/versions?_dc=1587383515880
t Transfer: 1220 :      9|12:51:50.6313|iG0ZHN|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|12:51:50.6313|iG0ZHN|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|12:51:50.6313|iG0ZHN|DANIEL|    user DANIEL.
t Verbose: 1220 :       9|12:51:50.6313|iG0ZHN|DANIEL|OAuth. User logged in: DANIEL
t Information: 1220 :   9|12:51:50.6313|iG0ZHN|DANIEL|V3Api.SearchGeneric
t Transfer: 1220 :      9|12:51:50.6313|iG0ZHN|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|12:51:50.6313|iG0ZHN|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|12:51:50.6313|iG0ZHN|DANIEL|    user DANIEL.
t Transfer: 1220 :      9|12:51:50.6313|iG0ZHN|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|12:51:50.6313|iG0ZHN|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|12:51:50.6313|iG0ZHN|DANIEL|    user DANIEL.
t Information: 1220 :   9|12:51:50.6313|iG0ZHN|DANIEL|SearchVersion SQL:
 select * from (select a.*, rownum rnum  from ( select  m.*, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE,  nvl(t.text_id,-1) THUMBID, BUILD_PGRL_FULLTITLE(item_type, title, ser_name, ser_title) FULLTITLE     from tmddba.tm_pg_rl m 
        left outer join (select text_id, text_data_path, text_data_filename, text_ref_object from tmddba.tm_text) t on t.text_id = m.primary_thumb_id
 where item_type>0 and rl_deleted=0  and m.PGM_ABS_ID=3542 
 order by m.title,m.id) a where rownum <= 9999) r where rnum >=1 order by rnum
t Information: 1220 :   9|12:51:50.6313|iG0ZHN|DANIEL|Running version search. User: 342    Simple Search: 
Running Oracle search.
Running Oracle search for COUNT
Oracle count completed in: 4ms.  Returned lines: 0

t Verbose: 1220 :       9|12:51:50.6313|iG0ZHN|DANIEL|imfx v3 API took 0.008s '/api/v3/title/3542/versions?_dc=1587383515880'
t Transfer: 1220 :      9|12:51:52.2563|UqhOWc|DANIEL|OAuth: /api/v3/title/56067/versions?_dc=1587383517452
t Transfer: 1220 :      9|12:51:52.2563|UqhOWc|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|12:51:52.2563|UqhOWc|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|12:51:52.2563|UqhOWc|DANIEL|    user DANIEL.
t Verbose: 1220 :       9|12:51:52.2563|UqhOWc|DANIEL|OAuth. User logged in: DANIEL
t Information: 1220 :   9|12:51:52.2563|UqhOWc|DANIEL|V3Api.SearchGeneric
t Transfer: 1220 :      9|12:51:52.2563|UqhOWc|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|12:51:52.2563|UqhOWc|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|12:51:52.2563|UqhOWc|DANIEL|    user DANIEL.
t Transfer: 1220 :      9|12:51:52.2563|UqhOWc|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|12:51:52.2563|UqhOWc|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|12:51:52.2563|UqhOWc|DANIEL|    user DANIEL.
t Information: 1220 :   9|12:51:52.2563|UqhOWc|DANIEL|SearchVersion SQL:
 select * from (select a.*, rownum rnum  from ( select  m.*, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE,  nvl(t.text_id,-1) THUMBID, BUILD_PGRL_FULLTITLE(item_type, title, ser_name, ser_title) FULLTITLE     from tmddba.tm_pg_rl m 
        left outer join (select text_id, text_data_path, text_data_filename, text_ref_object from tmddba.tm_text) t on t.text_id = m.primary_thumb_id
 where item_type>0 and rl_deleted=0  and m.PGM_ABS_ID=56067 
 order by m.title,m.id) a where rownum <= 9999) r where rnum >=1 order by rnum
t Information: 1220 :   9|12:51:52.2563|UqhOWc|DANIEL|Running version search. User: 342    Simple Search: 
Running Oracle search.
Running Oracle search for COUNT
Oracle count completed in: 7ms.  Returned lines: 1
Oracle version search timing: 33ms.
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=56067 
 order by m.title,m.id) a where rownum <= 9999) r where rnum >=1 order by rnum

t Verbose: 1220 :       9|12:51:52.2563|UqhOWc|DANIEL|imfx v3 API took 0.044s '/api/v3/title/56067/versions?_dc=1587383517452'
t Transfer: 1220 :      9|12:51:52.4595|14y~pz|DANIEL|OAuth: /api/v3/version/114431/media?_dc=1587383517721
t Transfer: 1220 :      9|12:51:52.4595|14y~pz|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|12:51:52.4595|14y~pz|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|12:51:52.4595|14y~pz|DANIEL|    user DANIEL.
t Verbose: 1220 :       9|12:51:52.4595|14y~pz|DANIEL|OAuth. User logged in: DANIEL
t Information: 1220 :   9|12:51:52.4595|14y~pz|DANIEL|V3Api.SearchGeneric
t Transfer: 1220 :      9|12:51:52.4595|14y~pz|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|12:51:52.4595|14y~pz|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|12:51:52.4595|14y~pz|DANIEL|    user DANIEL.
t Information: 1220 :   9|12:51:52.4595|14y~pz|DANIEL|MediaSearch SQL:
select r.*,
    nvl((select TMD_STR_AGG(c.u_id_pfix ) from tm_ctnrs c, tm_mi_tpi_lnx l where l.miid=r.id and c.u_id=l.tpiid and r.media_type=1),'') BARCODE,
    nvl(lnk.lib_loc_ext_id,0) lib_loc_ext_id, nvl(lnk.ctnr_loan_stat,0) ctnr_loan_status, nvl(lnk.ctnr_stat,0) ctnr_stat,
    nvl(t.text_data_path,'') THUMBSERVER, 
    nvl(t.text_data_filename,'') THUMBFILE,
    nvl(t.text_id,-1) THUMBID , 
    GETMEDIALOC(r.id, r.media_type, r.compil, r.m_ctnr_int_o_loc, r.m_ctnr_ext_o_loc, r.m_ctnr_loc) LOCATION,
    nvl(dfl.fSOM,0) FILE_SOM, nvl(dfl.fEOM,0) FILE_EOM, dfl.fos_fname FILENAME, dfl.DFILE_LINK_GUID, dfl.OS_GUID, dfl.SUB_FOLDER, dfl.ORIGINAL_FILENAME 

    from (select a.*, rownum rnum from 
      (select  m.*,
     coalesce(m.primary_thumb_id, (select v.primary_thumb_id from tm_pg_rl v where v.id=m.pgm_parent_id)) primary_thumb_id2 
      from tmddba.tm_mis m 
 where media_type>0 and item_type>0  AND  PGM_PARENT_ID=:pgm_parent_id_1  and m.mi_deleted=0  
 order by upper(m.title), m.media_type, m.ec_som, m.id ) a where rownum <= 50) r 
    ,lateral( select l.miid, max(c.C_EXT_OUT_LOC) lib_loc_ext_id, max(c.C_STAT) ctnr_stat, max(c.loan_stat) ctnr_loan_stat  from tm_mi_tpi_lnx l, tm_ctnrs c where c.u_id=l.tpiid and l.miid=r.id and r.media_type=1 group by l.miid)(+) lnk 
    ,lateral(select tt.* from tm_text tt where tt.text_id = r.primary_thumb_id2)(+) t
    ,lateral(select /*+ NO_DECORRELATE */  d.som fsom, d.eom feom, dl.mi_id fmi_id, d.os_fname fos_fname, d.DFILE_LINK_GUID, d.OS_GUID, d.SUB_FOLDER, dl.dfile_id, d.original_filename
        FROM tm_dfile d, tm_mi_dfile_lnx dl where d.id=dl.dfile_id and r.id=dl.mi_id and rownum=1)(+) dfl 
    
    where rnum >= 1 order by rnum
Param: pgm_parent_id_1: 114431
t Information: 1220 :   9|12:51:52.4595|14y~pz|DANIEL|  count returned 0
t Verbose: 1220 :       9|12:51:52.4595|14y~pz|DANIEL|imfx v3 API took 0.005s '/api/v3/version/114431/media?_dc=1587383517721'
t Transfer: 1220 :      9|12:51:53.0688|t6uvOP|DANIEL|OAuth: /api/v3/title/539/versions?_dc=1587383518335
t Transfer: 1220 :      9|12:51:53.0688|t6uvOP|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|12:51:53.0688|t6uvOP|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|12:51:53.0688|t6uvOP|DANIEL|    user DANIEL.
t Verbose: 1220 :       9|12:51:53.0688|t6uvOP|DANIEL|OAuth. User logged in: DANIEL
t Information: 1220 :   9|12:51:53.0688|t6uvOP|DANIEL|V3Api.SearchGeneric
t Transfer: 1220 :      9|12:51:53.0688|t6uvOP|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|12:51:53.0688|t6uvOP|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|12:51:53.0688|t6uvOP|DANIEL|    user DANIEL.
t Transfer: 1220 :      9|12:51:53.0688|t6uvOP|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|12:51:53.0688|t6uvOP|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|12:51:53.0688|t6uvOP|DANIEL|    user DANIEL.
t Information: 1220 :   9|12:51:53.0688|t6uvOP|DANIEL|SearchVersion SQL:
 select * from (select a.*, rownum rnum  from ( select  m.*, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE,  nvl(t.text_id,-1) THUMBID, BUILD_PGRL_FULLTITLE(item_type, title, ser_name, ser_title) FULLTITLE     from tmddba.tm_pg_rl m 
        left outer join (select text_id, text_data_path, text_data_filename, text_ref_object from tmddba.tm_text) t on t.text_id = m.primary_thumb_id
 where item_type>0 and rl_deleted=0  and m.PGM_ABS_ID=539 
 order by m.title,m.id) a where rownum <= 9999) r where rnum >=1 order by rnum
t Information: 1220 :   9|12:51:53.0688|t6uvOP|DANIEL|Running version search. User: 342    Simple Search: 
Running Oracle search.
Running Oracle search for COUNT
Oracle count completed in: 4ms.  Returned lines: 0

t Verbose: 1220 :       9|12:51:53.0688|t6uvOP|DANIEL|imfx v3 API took 0.009s '/api/v3/title/539/versions?_dc=1587383518335'
t Information: 1220 :   9|13:12:36.8658|||OrabitWatcherBasic. Disposing.
t Information: 1220 :   9|13:12:36.8658|||OrabitWatcherBasic. Disposed.
t Information: 1220 :   9|13:12:36.8658|||==========================================================================
t Information: 1220 :   9|13:12:36.8658|||IMFX CORE SERVER APPLICATION END.