t Information: 1220 :   9|10:07:01.8737|||Get Configuration Values:
t Information: 1220 :   9|10:07:01.8737|||	AdminPassEnc, default: , value: ffqjrn0leKv4Lj2YJHe2dw==.
t Information: 1220 :   9|10:07:01.8737|||	EncryptedPasswords, default: false, value: true.
t Information: 1220 :   9|10:07:01.8737|||	OraConnectionString, default: , value: Server=TECHM;User Id=imfx;Password=xxxxx;Unicode=true;.
t Information: 1220 :   9|10:07:01.8737|||	SecondTimezone, default: , value: .
t Information: 1220 :   9|10:07:01.8737|||	UseActiveDirectoryAuth, default: false, value: false.
t Information: 1220 :   9|10:07:01.8737|||	ReportingServiceUrl, default: , value: http://localhost:92/ReportingService.svc.
t Information: 1220 :   9|10:07:01.8737|||	ReportsPath, default: , value: .
t Information: 1220 :   9|10:07:01.8737|||	ReportsURL, default: , value: .
t Information: 1220 :   9|10:07:01.8737|||	TapeServiceUrl, default: , value: .
t Information: 1220 :   9|10:07:01.8737|||	GatekeeperUrl, default: , value: .
t Information: 1220 :   9|10:07:01.8737|||	ValuationUrl, default: , value: .
t Information: 1220 :   9|10:07:01.8737|||	QueueManagerDelay, default: 30, value: 30.
t Information: 1220 :   9|10:07:01.8737|||	QueueManagerFullRefresh, default: 90, value: 90.
t Information: 1220 :   9|10:07:01.8737|||	AudioLoopDuration, default: 0, value: 150.
t Information: 1220 :   9|10:07:01.8737|||	AudioLoopsCount, default: 0, value: 0.
t Information: 1220 :   9|10:07:01.8737|||	PlayerFakeStep, default: 500, value: 500.
t Information: 1220 :   9|10:07:01.8737|||	PlayerForceRatio, default: 0, value: 1.
t Information: 1220 :   9|10:07:01.8737|||	CheckVersionsInProd, default: false, value: True.
t Information: 1220 :   9|10:07:01.8737|||	MaxResults, default: 3000, value: 10000.
t Information: 1220 :   9|10:07:01.8737|||	NetworkRestriction, default: false, value: True.
t Information: 1220 :   9|10:07:01.8737|||	TEReportID, default: 0, value: 0.
t Information: 1220 :   9|10:07:01.8737|||	ClosedCaptionsCache, default: , value: C:\inetpub\wwwroot\imfxcore\timedtextcache\.
t Information: 1220 :   9|10:07:01.8737|||	ClosedCaptionsStorage, default: , value: c:\Mediaflex\subs.
t Information: 1220 :   9|10:07:01.8737|||	TimeCodeFormat, default: , value: pal.
t Information: 1220 :   9|10:07:01.8737|||	RceMediaPath, default: , value: C:\edl\.
t Information: 1220 :   9|10:07:01.8737|||	RceMediaPath, default: , value: C:\edl\.
t Information: 1220 :   9|10:07:01.8737|||	RceCsmOutputPath, default: , value: C:\Inetpub\wwwroot\csm\.
t Information: 1220 :   9|10:07:01.8737|||	RceCsmUrl, default: , value: http://localhost/csm/.
t Information: 1220 :   9|10:07:01.8737|||	RceMediaSelection, default: , value: miLinkIdMatch.
t Information: 1220 :   9|10:07:01.8737|||	RequestBrowseJobPresetName, default: , value: .
t Information: 1220 :   9|10:07:01.8737|||	DontExtendDuration, default: false, value: False.
t Information: 1220 :   9|10:07:01.8737|||	V3ConfigUrl, default: , value: .
t Information: 1220 :   9|10:07:01.8737|||	StopWords, default: , value: .
t Information: 1220 :   9|10:07:01.8737|||	MisrTxFormat, default: G, value: G.
t Information: 1220 :   9|10:07:01.8737|||	ApiServer, default: , value: http://192.168.120.10:85.
t Information: 1220 :   9|10:07:01.8737|||	ApiTimeout, default: 120, value: 120.
t Information: 1220 :   9|10:07:01.8737|||	ApiWorkers, default: 10, value: 10.
t Information: 1220 :   9|10:07:01.8737|||	UsePerfCounters, default: false, value: false.
t Information: 1220 :   9|10:07:01.8737|||	StatsdAddress, default: , value: .
t Information: 1220 :   9|10:07:01.8737|||	LogGetCurrentUser, default: true, value: true.
t Information: 1220 :   9|10:07:01.8737|||	LogInternalApi, default: true, value: true.
t Information: 1220 :   9|10:07:01.8737|||	ThumbnailServer, default: , value: .
t Information: 1220 :   9|10:07:01.8737|||	LocationFilter, default: , value: .
t Information: 1220 :   9|10:07:01.8737|||	SvUtilServiceUrl, default: , value: .
t Information: 1220 :   9|10:07:01.8737|||	SolrConnection, default: , value: http://192.168.120.14:8983/solr.
t Information: 1220 :   9|10:07:01.8737|||	UseIndexServerSearch, default: false, value: True.
t Information: 1220 :   9|10:07:01.8737|||	SolrIndexVersion, default: 1, value: 6.
t Information: 1220 :   9|10:07:01.8737|||	SolrConnection, default: , value: http://192.168.120.14:8983/solr.
t Information: 1220 :   9|10:07:01.8737|||	FacetsGroups, default: , value: owners,season_id, series_id,version_key,item_type,media_type,media_format,episode_number.
t Information: 1220 :   9|10:07:01.8737|||	FacetsGroupsVersion, default: , value: owners,season_id, series_id,version_key,episode_number.
t Information: 1220 :   9|10:07:01.8737|||	FacetsGroupsChameleon, default: , value: season_id, series_id,genre,prod_year,version_key.
t Information: 1220 :   9|10:07:01.8737|||	PreviewPreset, default: , value: .
t Information: 1220 :   9|10:07:01.8737|||	DevMode, default: false, value: false.
t Information: 1220 :   9|10:07:01.8737|||	DisableSysMan, default: false, value: false.
t Information: 1220 :   9|10:07:01.8737|||	TimeCodeFormat, default: , value: pal.
t Information: 1220 :   9|10:07:01.8737|||	FileCatalystStorageDevice, default: , value: .
t Information: 1220 :   9|10:07:01.8737|||	UseResponsibilityTracking, default: true, value: True.
t Information: 1220 :   9|10:07:01.8737|||	SubtitleDeviceFilter, default: , value: .
t Information: 1220 :   9|10:07:01.8737|||	SystemMonitorNamedPipe, default: , value: .
t Information: 1220 :   9|10:07:01.8737|||	OracleMonitorEnable, default: false, value: False.
t Information: 1220 :   9|10:07:01.8737|||	ArcApiHost, default: , value: .
t Information: 1220 :   9|10:07:01.8737|||	RabbitMqUrl, default: , value: amqp://192.168.120.14:5672.
t Information: 1220 :   9|10:07:01.8737|||	SolrTimedTextSearch, default: false, value: false.
t Information: 1220 :   9|10:07:01.8737|||	ProductionDurationUsageID, default: 1, value: 1.
t Information: 1220 :   9|10:07:02.0924|||GetStreamServers..
t Information: 1220 :   9|10:07:02.4987|||	https://demo.tmd.tv/CBR Video/ |CBR Video| False  
t Information: 1220 :   9|10:07:02.4987|||	https://demo.tmd.tv/CBR Images/ |CBR Images| False  
t Information: 1220 :   9|10:07:02.4987|||	https://demo.tmd.tv/CBR Audio/ |CBR Audio| False  
t Information: 1220 :   9|10:07:02.4987|||	https://demo.tmd.tv/Temp Upload/ |TEMP_UPLOAD| False  
t Information: 1220 :   9|10:07:02.4987|||	http://localhost:82/images/ |IMAGES| False  
t Information: 1220 :   9|10:07:02.4987|||	http://192.168.91.73/smoothcloud/ |SMOOTH_CLOUD| False  
t Information: 1220 :   9|10:07:02.4987|||	http://192.168.91.73/cloudstore/ |CLOUD_STORE| False  
t Information: 1220 :   9|10:07:02.4987|||	http://192.168.91.73/editsystemin/ |EDIT_SYSTEM_IN| False  
t Information: 1220 :   9|10:07:02.4987|||	http://192.168.91.27:89/APPLEPROXY/ |APPLE_PROXY| False  
t Information: 1220 :   9|10:07:02.4987|||	http://localhost:82/video/ |FILESTORE_VIDEO| False  
t Information: 1220 :   9|10:07:02.4987|||	https://imfxv3tm.tmd.tv/streaming/ |Streaming| False  
t Information: 1220 :   9|10:07:02.4987|||	https://imfxv3tm.tmd.tv/VideoServer/ |Video| False  
t Information: 1220 :   9|10:07:02.4987|||	https://imfxv3tm.tmd.tv/AdobeIn/ |Adobe Premiere Pro In| False  
t Information: 1220 :   9|10:07:02.4987|||	https://imfxv3tm.tmd.tv/AudioServer/ |Audio| False  
t Information: 1220 :   9|10:07:02.4987|||	https://imfxv3tm.tmd.tv/ImageServer/ |Image| False  
t Information: 1220 :   9|10:07:02.4987|||	https://imfxv3tm.tmd.tv/DocsServer/ |Docs| False  
t Information: 1220 :   9|10:07:02.4987|||	https://imfxv3tm.tmd.tv/AmazonLabs/ |TEST HOUSE| False  
t Information: 1220 :   9|10:07:02.4987|||	SolrConnectionUms, default: http://192.168.120.14:8983/solr, value: http://192.168.120.14:8983/solr.
t Information: 1220 :   9|10:07:02.4987|||	LogWebApi, default: false, value: false.
t Information: 1220 :   9|10:07:02.4987|||	EmbeddedRceUrl, default: , value: .
t Information: 1220 :   9|10:07:02.4987|||	InstallMode, default: , value: .
t Information: 1220 :   9|10:07:02.4987|||	SamlRequestAddress, default: , value: .
t Information: 1220 :   9|10:07:02.4987|||	SamlTrustedIssuer, default: , value: .
t Information: 1220 :   9|10:07:02.4987|||	SamlLoginRedirect, default: , value: .
t Information: 1220 :   9|10:07:02.4987|||	NaturalLangSearch, default: false, value: True.
t Information: 1220 :   9|10:07:02.4987|||	OktaLoginField, default: , value: .
t Information: 1220 :   9|10:07:02.4987|||	AuthenticationTypes, default: , value: Native,PublicApiKey.
t Information: 1220 :   9|10:07:02.4987|||OrabitWatcherBasic. Initialize.
t Information: 1220 :   9|10:07:02.4987|||FillDictionaryCache.
t Information: 1220 :   9|10:07:05.8424|||GetSupportedOperators
t Information: 1220 :   9|10:07:06.0455|||CacheTechReports.
t Information: 1220 :   9|10:07:06.0455|||& Cache update. Server (global) filled with timestamp 10:04:06.0143260. types null
t Information: 1220 :   9|10:07:06.0455|||InitializeFromDatabase.
  'Server=TECHM;User Id=imfx;password=..;Unicode=true;'
  direct False, home , timeout 15
t Information: 1220 :   9|10:07:06.0455|||FillDictionaryCache.
t Information: 1220 :   9|10:07:06.2486|||& Cache update. Server (global) filled with timestamp 10:04:06.0299509. types FriendlyNames, DatabaseSearchFieldData
t Information: 1220 :   9|10:07:06.6549|||==========================================================================
t Information: 1220 :   9|10:07:06.6549|||IMFX CORE SERVER APPLICATION START.
t Information: 1220 :   9|10:07:06.6549|||DLL VERSION: 2.5.0.2610.
t Information: 1220 :   9|10:07:06.6549|||IS TIMER HIGH RESOULTION : True.
t Information: 1220 :   9|10:07:06.6549|||	UmsDev, default: False, value: False.
t Information: 1220 :   9|10:07:07.4674|||OrabitWatcherBasic trying to connect..
t Information: 1220 :   9|10:07:07.4674|||OrabitWatcherBasic connected.
t Information: 1220 :   9|10:07:07.4674|||OrabitWatcherBasic queue created tmd.cfg.in.aef34c23-af26-43ff-be62-dd3103004422
t Transfer: 1220 :      9|10:07:09.0924|GuRZQe|DANIEL|OAuth: /api/v3/config-tables?_dc=1585732027086
t Transfer: 1220 :      9|10:07:09.0924|UOEJmP|DANIEL|OAuth: /api/settings/groups/?_dc=1585732020532
t Transfer: 1220 :      9|10:07:09.0924|sS3BZT|DANIEL|OAuth: /api/v3/config/servicexml/types?_dc=1585732020461
t Transfer: 1220 :      9|10:07:09.0924|UOEJmP|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|10:07:09.0924|sS3BZT|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|10:07:09.0924|GuRZQe|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|10:07:09.0924|UOEJmP|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|10:07:09.0924|sS3BZT|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|10:07:09.0924|GuRZQe|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|10:07:09.0924|UOEJmP|DANIEL|    user DANIEL.
t Transfer: 1220 :      9|10:07:09.0924|sS3BZT|DANIEL|    user DANIEL.
t Transfer: 1220 :      9|10:07:09.0924|GuRZQe|DANIEL|    user DANIEL.
t Verbose: 1220 :       9|10:07:09.0924|sS3BZT|DANIEL|OAuth. User logged in: DANIEL
t Verbose: 1220 :       9|10:07:09.0924|UOEJmP|DANIEL|OAuth. User logged in: DANIEL
t Verbose: 1220 :       9|10:07:09.0924|GuRZQe|DANIEL|OAuth. User logged in: DANIEL
t Verbose: 1220 :       9|10:07:09.0924|sS3BZT|DANIEL|imfx v3 API took 0.059s '/api/v3/config/servicexml/types?_dc=1585732020461'
t Verbose: 1220 :       9|10:07:09.0924|UOEJmP|DANIEL|imfx v3 API took 0.059s '/api/settings/groups/?_dc=1585732020532'
t Verbose: 1220 :       9|10:07:09.0924|GuRZQe|DANIEL|imfx v3 API took 0.059s '/api/v3/config-tables?_dc=1585732027086'
t Information: 1220 :   9|10:07:14.7799|sqB27e|DANIEL|GetConfig TM_CFG_MEDIA_FILE_TYPES.
t Verbose: 1220 :       9|10:07:14.9830|sqB27e|DANIEL|imfx v3 API took 0.176s '/api/v3/config-table/TM_CFG_MEDIA_FILE_TYPES?_dc=1585732034692'
t Information: 1220 :   9|10:07:28.5924|Tvtakq|DANIEL|GetConfig TM_MI_TYPES.
t Verbose: 1220 :       9|10:07:28.5924|Tvtakq|DANIEL|imfx v3 API took 0.019s '/api/v3/config-table/TM_MI_TYPES?_dc=1585732048484'
t Information: 1220 :   9|10:07:35.4986|Z_AAFo|DANIEL|GetConfig TM_CFG_MEDIA_USAGE.
t Verbose: 1220 :       9|10:07:35.4986|Z_AAFo|DANIEL|imfx v3 API took 0.016s '/api/v3/config-table/TM_CFG_MEDIA_USAGE?_dc=1585732055380'
t Information: 1220 :   9|10:07:37.5299|lkbOBi|DANIEL|GetConfig TM_MI_SUB_TYPES.
t Verbose: 1220 :       9|10:07:37.5299|lkbOBi|DANIEL|imfx v3 API took 0.045s '/api/v3/config-table/TM_MI_SUB_TYPES?_dc=1585732057413'
t Information: 1220 :   9|10:07:53.5768|tlvKPP|DANIEL|GetConfig TM_CFG_MI_FMT.
t Verbose: 1220 :       9|10:07:53.5768|tlvKPP|DANIEL|imfx v3 API took 0.053s '/api/v3/config-table/TM_CFG_MI_FMT?_dc=1585732073365'
t Information: 1220 :   9|10:08:02.3111|bM6frL|DANIEL|GetConfig TM_CFG_MEDIA_FILE_TYPES.
t Verbose: 1220 :       9|10:08:02.3111|bM6frL|DANIEL|imfx v3 API took 0.011s '/api/v3/config-table/TM_CFG_MEDIA_FILE_TYPES?_dc=1585732082205'
t Transfer: 1220 :      9|10:09:12.7956|XIiDcz|DANIEL|OAuth: /api/settings/user/uploadSettings?_dc=1585732152692
t Transfer: 1220 :      9|10:09:12.7956|XIiDcz|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|10:09:12.7956|XIiDcz|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|10:09:12.7956|XIiDcz|DANIEL|    user DANIEL.
t Verbose: 1220 :       9|10:09:12.7956|XIiDcz|DANIEL|OAuth. User logged in: DANIEL
t Transfer: 1220 :      9|10:09:12.7956|XIiDcz|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|10:09:12.7956|XIiDcz|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|10:09:12.7956|XIiDcz|DANIEL|    user DANIEL.
t Verbose: 1220 :       9|10:09:12.7956|XIiDcz|DANIEL|imfx v3 API took 0.016s '/api/settings/user/uploadSettings?_dc=1585732152692'
t Information: 1220 :   9|10:09:13.2019|2VeT9M|DANIEL|GetUserProfile. Id: 0
t Transfer: 1220 :      9|10:09:13.2019|2VeT9M|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|10:09:13.2019|2VeT9M|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|10:09:13.2019|2VeT9M|DANIEL|    user DANIEL.
t Transfer: 1220 :      9|10:09:16.2487|j8XUzP|DANIEL|OAuth: /api/v3/config/servicexml/types?_dc=1585732156067
t Transfer: 1220 :      9|10:09:16.2487|j8XUzP|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|10:09:16.2487|j8XUzP|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|10:09:16.2487|j8XUzP|DANIEL|    user DANIEL.
t Verbose: 1220 :       9|10:09:16.2487|j8XUzP|DANIEL|OAuth. User logged in: DANIEL
t Verbose: 1220 :       9|10:09:16.2487|j8XUzP|DANIEL|imfx v3 API took 0.002s '/api/v3/config/servicexml/types?_dc=1585732156067'
t Transfer: 1220 :      9|10:09:16.2487|kujqCp|DANIEL|OAuth: /api/settings/groups/?_dc=1585732156179
t Transfer: 1220 :      9|10:09:16.2487|kujqCp|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|10:09:16.2487|kujqCp|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|10:09:16.2487|kujqCp|DANIEL|    user DANIEL.
t Verbose: 1220 :       9|10:09:16.2487|kujqCp|DANIEL|OAuth. User logged in: DANIEL
t Verbose: 1220 :       9|10:09:16.2487|kujqCp|DANIEL|imfx v3 API took 0.003s '/api/settings/groups/?_dc=1585732156179'
t Transfer: 1220 :      9|10:09:22.3424|YBukru|DANIEL|OAuth: /api/view/searchinfo/Job?_dc=1585732162298
t Transfer: 1220 :      9|10:09:22.3424|YBukru|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|10:09:22.3424|YBukru|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|10:09:22.3424|YBukru|DANIEL|    user DANIEL.
t Verbose: 1220 :       9|10:09:22.3424|YBukru|DANIEL|OAuth. User logged in: DANIEL
t Information: 1220 :   9|10:09:22.3424|YBukru|DANIEL|GetAdvSearchColumns. search type Job grid .
t Transfer: 1220 :      9|10:09:22.3424|0g9x1K|DANIEL|OAuth: /api/user-preferences?keys=adv.recent.searches.workflow&_dc=1585732162304
t Transfer: 1220 :      9|10:09:22.3424|0g9x1K|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|10:09:22.3424|0g9x1K|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|10:09:22.3424|0g9x1K|DANIEL|    user DANIEL.
t Verbose: 1220 :       9|10:09:22.3424|0g9x1K|DANIEL|OAuth. User logged in: DANIEL
t Information: 1220 :   9|10:09:22.3424|0g9x1K|DANIEL|GetUserDataByKeys: adv.recent.searches.workflow
t Transfer: 1220 :      9|10:09:22.3424|0g9x1K|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|10:09:22.3424|0g9x1K|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|10:09:22.3424|0g9x1K|DANIEL|    user DANIEL.
t Verbose: 1220 :       9|10:09:22.3424|YBukru|DANIEL|imfx v3 API took 0.013s '/api/view/searchinfo/Job?_dc=1585732162298'
t Verbose: 1220 :       9|10:09:22.3424|0g9x1K|DANIEL|imfx v3 API took 0.016s '/api/user-preferences?keys=adv.recent.searches.workflow&_dc=1585732162304'
t Transfer: 1220 :      9|10:09:22.5455|lzZRdN|DANIEL|OAuth: /api/view/searches/Job?_dc=1585732162414
t Transfer: 1220 :      9|10:09:22.5455|lzZRdN|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|10:09:22.5455|lzZRdN|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|10:09:22.5455|lzZRdN|DANIEL|    user DANIEL.
t Verbose: 1220 :       9|10:09:22.5455|lzZRdN|DANIEL|OAuth. User logged in: DANIEL
t Information: 1220 :   9|10:09:22.5455|lzZRdN|DANIEL|GetSavedSearchNames. search type Job.
t Transfer: 1220 :      9|10:09:22.5455|lzZRdN|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|10:09:22.5455|lzZRdN|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|10:09:22.5455|lzZRdN|DANIEL|    user DANIEL.
t Verbose: 1220 :       9|10:09:22.5455|lzZRdN|DANIEL|imfx v3 API took 0.032s '/api/view/searches/Job?_dc=1585732162414'
t Transfer: 1220 :      9|10:09:31.6861|gWIuri|DANIEL|OAuth: /api/v3/search/workflow?_dc=1585732171480
t Transfer: 1220 :      9|10:09:31.6861|gWIuri|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|10:09:31.6861|gWIuri|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|10:09:31.6861|gWIuri|DANIEL|    user DANIEL.
t Verbose: 1220 :       9|10:09:31.6861|gWIuri|DANIEL|OAuth. User logged in: DANIEL
t Information: 1220 :   9|10:09:31.6861|gWIuri|DANIEL|V3Api.SearchWorkflows
t Information: 1220 :   9|10:09:31.6861|gWIuri|DANIEL|V3Api.SearchGeneric
t Transfer: 1220 :      9|10:09:31.6861|gWIuri|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|10:09:31.6861|gWIuri|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|10:09:31.6861|gWIuri|DANIEL|    user DANIEL.
t Information: 1220 :   9|10:09:31.6861|gWIuri|DANIEL|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   not ( j.CMB_STAT = 19 and j.J_FAILURE_RESOLVED > 0 )   and j.J_CREATED >= to_date('01/04/2020','DD/MM/YYYY')   and  j.cmb_stat not in (15,18,23)    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|10:09:32.0924|gWIuri|DANIEL|    jobs returned 2, searched in 00:00:00.2182512
t Information: 1220 :   9|10:09:32.0924|gWIuri|DANIEL|    tasks returned 2, searched in 00:00:00.0667184
t Verbose: 1220 :       9|10:09:32.0924|gWIuri|DANIEL|imfx v3 API took 0.335s '/api/v3/search/workflow?_dc=1585732171480'
t Transfer: 1220 :      9|10:09:32.2955|M3JKUj|DANIEL|OAuth: /api/user-preferences?_dc=1585732172147
t Transfer: 1220 :      9|10:09:32.2955|M3JKUj|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|10:09:32.2955|M3JKUj|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|10:09:32.2955|M3JKUj|DANIEL|    user DANIEL.
t Verbose: 1220 :       9|10:09:32.2955|M3JKUj|DANIEL|OAuth. User logged in: DANIEL
t Verbose: 1220 :       9|10:09:32.2955|M3JKUj|DANIEL|StoreUserDataByKeys..
t Transfer: 1220 :      9|10:09:32.2955|M3JKUj|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|10:09:32.2955|M3JKUj|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|10:09:32.2955|M3JKUj|DANIEL|    user DANIEL.
t Verbose: 1220 :       9|10:09:32.2955|M3JKUj|DANIEL|imfx v3 API took 0.029s '/api/user-preferences?_dc=1585732172147'
t Transfer: 1220 :      9|10:09:36.3580|FUtq5c|DANIEL|OAuth: /api/v3/task/componentqc/109468?_dc=1585732176144
t Transfer: 1220 :      9|10:09:36.3580|FUtq5c|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|10:09:36.3580|FUtq5c|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|10:09:36.3580|FUtq5c|DANIEL|    user DANIEL.
t Verbose: 1220 :       9|10:09:36.3580|FUtq5c|DANIEL|OAuth. User logged in: DANIEL
t Information: 1220 :   9|10:09:36.3580|FUtq5c|DANIEL|V3Api. GetComponentQc task: 109468
t Information: 1220 :   9|10:09:36.3580|FUtq5c|DANIEL|SubtitleQcTask. LoadFromDb got Job 109452 and Subtitles 1.
t Verbose: 1220 :       9|10:09:36.3580|FUtq5c|DANIEL|imfx v3 API took 0.186s '/api/v3/task/componentqc/109468?_dc=1585732176144'
t Information: 1220 :   9|10:09:36.4049|FUtq5c|DANIEL|V3 Api exception handler: System.Collections.Generic.KeyNotFoundException: The given key was not present in the dictionary.
   at System.Collections.Generic.Dictionary`2.get_Item(TKey key)
   at xMfxModel.TM_MIS.ParseCustomStatuses() in C:\BuildAgent2\work\405c64e443a47d83\Server\xMfxDataLogic\Logic\TM_MIS.cs:line 440
   at xMfxDataLogic.ServiceLogic.Implementation.SubtitlesQcTaskLoad(Decimal taskId) in C:\BuildAgent2\work\405c64e443a47d83\Server\xMfxDataLogic\Logic\ServiceLogic\SubtitleQc.cs:line 68
   at iMfxServerCore.Api.v3.SubtitleQcTaskController.GetComponentQcTask(Int32 id) in C:\BuildAgent2\work\405c64e443a47d83\Server\iMfxServerCore\api\controllers\v3\Tasks\SubtitleQcTaskController.cs:line 44
   at lambda_method(Closure , Object , Object[] )
   at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ActionExecutor.<>c__DisplayClass6_2.<GetExecutor>b__2(Object instance, Object[] methodParameters)
   at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ActionExecutor.Execute(Object instance, Object[] arguments)
   at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ExecuteAsync(HttpControllerContext controllerContext, IDictionary`2 arguments, CancellationToken cancellationToken)
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Web.Http.Controllers.ApiControllerActionInvoker.<InvokeActionAsyncCore>d__1.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Web.Http.Filters.ActionFilterAttribute.<CallOnActionExecutedAsync>d__6.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Web.Http.Filters.ActionFilterAttribute.<CallOnActionExecutedAsync>d__6.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Web.Http.Filters.ActionFilterAttribute.<ExecuteActionFilterAsyncCore>d__5.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Web.Http.Filters.ActionFilterAttribute.<CallOnActionExecutedAsync>d__6.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Web.Http.Filters.ActionFilterAttribute.<CallOnActionExecutedAsync>d__6.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Web.Http.Filters.ActionFilterAttribute.<ExecuteActionFilterAsyncCore>d__5.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Web.Http.Controllers.ActionFilterResult.<ExecuteAsync>d__5.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Web.Http.Filters.AuthorizationFilterAttribute.<ExecuteAuthorizationFilterAsyncCore>d__3.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Web.Http.Controllers.ExceptionFilterResult.<ExecuteAsync>d__6.MoveNext()
  [GET] https://imfxv3tm.tmd.tv/api/v3/task/componentqc/109468?_dc=1585732176144
  System.Web.Http.Routing.HttpRoute
t Transfer: 1220 :      9|10:10:06.8737|mIdlSU|DANIEL|OAuth: /api/v3/search/workflow?_dc=1585732206797
t Transfer: 1220 :      9|10:10:06.8737|mIdlSU|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|10:10:06.8737|mIdlSU|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|10:10:06.8737|mIdlSU|DANIEL|    user DANIEL.
t Verbose: 1220 :       9|10:10:06.8737|mIdlSU|DANIEL|OAuth. User logged in: DANIEL
t Information: 1220 :   9|10:10:06.8737|mIdlSU|DANIEL|V3Api.SearchWorkflows
t Information: 1220 :   9|10:10:06.8737|mIdlSU|DANIEL|V3Api.SearchGeneric
t Transfer: 1220 :      9|10:10:06.8737|mIdlSU|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|10:10:06.8737|mIdlSU|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|10:10:06.8737|mIdlSU|DANIEL|    user DANIEL.
t Information: 1220 :   9|10:10:06.8737|mIdlSU|DANIEL|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=109452   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|10:10:07.0768|mIdlSU|DANIEL|    jobs returned 1, searched in 00:00:00.1399711
t Information: 1220 :   9|10:10:07.0768|mIdlSU|DANIEL|    tasks returned 1, searched in 00:00:00.0286425
t Verbose: 1220 :       9|10:10:07.0768|mIdlSU|DANIEL|imfx v3 API took 0.182s '/api/v3/search/workflow?_dc=1585732206797'
t Transfer: 1220 :      9|10:10:08.7018|Dn6Cj0|DANIEL|OAuth: /api/v3/task/componentqc/109468?_dc=1585732208526
t Transfer: 1220 :      9|10:10:08.7018|Dn6Cj0|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|10:10:08.7018|Dn6Cj0|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|10:10:08.7018|Dn6Cj0|DANIEL|    user DANIEL.
t Verbose: 1220 :       9|10:10:08.7018|Dn6Cj0|DANIEL|OAuth. User logged in: DANIEL
t Information: 1220 :   9|10:10:08.7018|Dn6Cj0|DANIEL|V3Api. GetComponentQc task: 109468
t Information: 1220 :   9|10:10:08.7018|Dn6Cj0|DANIEL|SubtitleQcTask. LoadFromDb got Job 109452 and Subtitles 1.
t Verbose: 1220 :       9|10:10:08.7018|Dn6Cj0|DANIEL|imfx v3 API took 0.028s '/api/v3/task/componentqc/109468?_dc=1585732208526'
t Information: 1220 :   9|10:10:08.7018|Dn6Cj0|DANIEL|V3 Api exception handler: System.Collections.Generic.KeyNotFoundException: The given key was not present in the dictionary.
   at System.Collections.Generic.Dictionary`2.get_Item(TKey key)
   at xMfxModel.TM_MIS.ParseCustomStatuses() in C:\BuildAgent2\work\405c64e443a47d83\Server\xMfxDataLogic\Logic\TM_MIS.cs:line 440
   at xMfxDataLogic.ServiceLogic.Implementation.SubtitlesQcTaskLoad(Decimal taskId) in C:\BuildAgent2\work\405c64e443a47d83\Server\xMfxDataLogic\Logic\ServiceLogic\SubtitleQc.cs:line 68
   at iMfxServerCore.Api.v3.SubtitleQcTaskController.GetComponentQcTask(Int32 id) in C:\BuildAgent2\work\405c64e443a47d83\Server\iMfxServerCore\api\controllers\v3\Tasks\SubtitleQcTaskController.cs:line 44
   at lambda_method(Closure , Object , Object[] )
   at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ActionExecutor.<>c__DisplayClass6_2.<GetExecutor>b__2(Object instance, Object[] methodParameters)
   at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ActionExecutor.Execute(Object instance, Object[] arguments)
   at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ExecuteAsync(HttpControllerContext controllerContext, IDictionary`2 arguments, CancellationToken cancellationToken)
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Web.Http.Controllers.ApiControllerActionInvoker.<InvokeActionAsyncCore>d__1.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Web.Http.Filters.ActionFilterAttribute.<CallOnActionExecutedAsync>d__6.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Web.Http.Filters.ActionFilterAttribute.<CallOnActionExecutedAsync>d__6.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Web.Http.Filters.ActionFilterAttribute.<ExecuteActionFilterAsyncCore>d__5.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Web.Http.Filters.ActionFilterAttribute.<CallOnActionExecutedAsync>d__6.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Web.Http.Filters.ActionFilterAttribute.<CallOnActionExecutedAsync>d__6.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Web.Http.Filters.ActionFilterAttribute.<ExecuteActionFilterAsyncCore>d__5.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Web.Http.Controllers.ActionFilterResult.<ExecuteAsync>d__5.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Web.Http.Filters.AuthorizationFilterAttribute.<ExecuteAuthorizationFilterAsyncCore>d__3.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Web.Http.Controllers.ExceptionFilterResult.<ExecuteAsync>d__6.MoveNext()
  [GET] https://imfxv3tm.tmd.tv/api/v3/task/componentqc/109468?_dc=1585732208526
  System.Web.Http.Routing.HttpRoute
t Transfer: 1220 :      9|10:11:49.0455|qJGN9g|DANIEL|OAuth: /api/v3/config/servicexml/types?_dc=1585732308869
t Transfer: 1220 :      9|10:11:49.0455|qJGN9g|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|10:11:49.0455|qJGN9g|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|10:11:49.0455|qJGN9g|DANIEL|    user DANIEL.
t Verbose: 1220 :       9|10:11:49.0455|qJGN9g|DANIEL|OAuth. User logged in: DANIEL
t Verbose: 1220 :       9|10:11:49.0455|qJGN9g|DANIEL|imfx v3 API took 0.003s '/api/v3/config/servicexml/types?_dc=1585732308869'
t Transfer: 1220 :      9|10:11:49.2486|XdKBPo|DANIEL|OAuth: /api/settings/groups/?_dc=1585732308969
t Transfer: 1220 :      9|10:11:49.2486|XdKBPo|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|10:11:49.2486|XdKBPo|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|10:11:49.2486|XdKBPo|DANIEL|    user DANIEL.
t Verbose: 1220 :       9|10:11:49.2486|XdKBPo|DANIEL|OAuth. User logged in: DANIEL
t Verbose: 1220 :       9|10:11:49.2486|XdKBPo|DANIEL|imfx v3 API took 0.004s '/api/settings/groups/?_dc=1585732308969'
t Transfer: 1220 :      9|10:11:52.0925|ahCQhY|DANIEL|OAuth: /api/v3/config-tables?_dc=1585732311911
t Transfer: 1220 :      9|10:11:52.0925|ahCQhY|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|10:11:52.0925|ahCQhY|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|10:11:52.0925|ahCQhY|DANIEL|    user DANIEL.
t Verbose: 1220 :       9|10:11:52.0925|ahCQhY|DANIEL|OAuth. User logged in: DANIEL
t Verbose: 1220 :       9|10:11:52.0925|ahCQhY|DANIEL|imfx v3 API took 0.000s '/api/v3/config-tables?_dc=1585732311911'
t Information: 1220 :   9|10:11:56.1549|RvtxfM|DANIEL|GetConfig TM_CFG_MEDIA_FILE_TYPES.
t Verbose: 1220 :       9|10:11:56.1549|RvtxfM|DANIEL|imfx v3 API took 0.013s '/api/v3/config-table/TM_CFG_MEDIA_FILE_TYPES?_dc=1585732316108'
t Information: 1220 :   9|10:11:58.7955|jv3pg4|DANIEL|GetConfig TM_CFG_MEDIA_FILE_TYPES.
t Verbose: 1220 :       9|10:11:58.7955|jv3pg4|DANIEL|imfx v3 API took 0.009s '/api/v3/config-table/TM_CFG_MEDIA_FILE_TYPES?_dc=1585732318651'
t Information: 1220 :   9|10:11:58.7955|b9LJVB|DANIEL|GetConfig TM_CFG_MEDIA_FILE_TYPES.
t Verbose: 1220 :       9|10:11:58.7955|b9LJVB|DANIEL|imfx v3 API took 0.007s '/api/v3/config-table/TM_CFG_MEDIA_FILE_TYPES?_dc=1585732318714'
t Transfer: 1220 :      9|10:12:47.5455|TtKDKS|DANIEL|OAuth: /api/v3/search/workflow?_dc=1585732367400
t Transfer: 1220 :      9|10:12:47.5455|TtKDKS|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|10:12:47.5455|TtKDKS|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|10:12:47.5455|TtKDKS|DANIEL|    user DANIEL.
t Verbose: 1220 :       9|10:12:47.5455|TtKDKS|DANIEL|OAuth. User logged in: DANIEL
t Information: 1220 :   9|10:12:47.5455|TtKDKS|DANIEL|V3Api.SearchWorkflows
t Information: 1220 :   9|10:12:47.5455|TtKDKS|DANIEL|V3Api.SearchGeneric
t Transfer: 1220 :      9|10:12:47.5455|TtKDKS|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|10:12:47.5455|TtKDKS|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|10:12:47.5455|TtKDKS|DANIEL|    user DANIEL.
t Information: 1220 :   9|10:12:47.5455|TtKDKS|DANIEL|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=109452   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|10:12:47.5455|TtKDKS|DANIEL|    jobs returned 1, searched in 00:00:00.0048556
t Information: 1220 :   9|10:12:47.5455|TtKDKS|DANIEL|    tasks returned 1, searched in 00:00:00.0026994
t Verbose: 1220 :       9|10:12:47.5455|TtKDKS|DANIEL|imfx v3 API took 0.014s '/api/v3/search/workflow?_dc=1585732367400'
t Transfer: 1220 :      9|10:12:48.9674|IbtqAl|DANIEL|OAuth: /api/v3/task/componentqc/109468?_dc=1585732368867
t Transfer: 1220 :      9|10:12:48.9674|IbtqAl|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|10:12:48.9674|IbtqAl|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|10:12:48.9674|IbtqAl|DANIEL|    user DANIEL.
t Verbose: 1220 :       9|10:12:48.9674|IbtqAl|DANIEL|OAuth. User logged in: DANIEL
t Information: 1220 :   9|10:12:48.9674|IbtqAl|DANIEL|V3Api. GetComponentQc task: 109468
t Information: 1220 :   9|10:12:48.9674|IbtqAl|DANIEL|SubtitleQcTask. LoadFromDb got Job 109452 and Subtitles 1.
t Verbose: 1220 :       9|10:12:48.9674|IbtqAl|DANIEL|imfx v3 API took 0.017s '/api/v3/task/componentqc/109468?_dc=1585732368867'
t Information: 1220 :   9|10:12:48.9674|IbtqAl|DANIEL|V3 Api exception handler: System.Collections.Generic.KeyNotFoundException: The given key was not present in the dictionary.
   at System.Collections.Generic.Dictionary`2.get_Item(TKey key)
   at xMfxModel.TM_MIS.ParseCustomStatuses() in C:\BuildAgent2\work\405c64e443a47d83\Server\xMfxDataLogic\Logic\TM_MIS.cs:line 440
   at xMfxDataLogic.ServiceLogic.Implementation.SubtitlesQcTaskLoad(Decimal taskId) in C:\BuildAgent2\work\405c64e443a47d83\Server\xMfxDataLogic\Logic\ServiceLogic\SubtitleQc.cs:line 68
   at iMfxServerCore.Api.v3.SubtitleQcTaskController.GetComponentQcTask(Int32 id) in C:\BuildAgent2\work\405c64e443a47d83\Server\iMfxServerCore\api\controllers\v3\Tasks\SubtitleQcTaskController.cs:line 44
   at lambda_method(Closure , Object , Object[] )
   at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ActionExecutor.<>c__DisplayClass6_2.<GetExecutor>b__2(Object instance, Object[] methodParameters)
   at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ActionExecutor.Execute(Object instance, Object[] arguments)
   at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ExecuteAsync(HttpControllerContext controllerContext, IDictionary`2 arguments, CancellationToken cancellationToken)
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Web.Http.Controllers.ApiControllerActionInvoker.<InvokeActionAsyncCore>d__1.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Web.Http.Filters.ActionFilterAttribute.<CallOnActionExecutedAsync>d__6.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Web.Http.Filters.ActionFilterAttribute.<CallOnActionExecutedAsync>d__6.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Web.Http.Filters.ActionFilterAttribute.<ExecuteActionFilterAsyncCore>d__5.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Web.Http.Filters.ActionFilterAttribute.<CallOnActionExecutedAsync>d__6.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Web.Http.Filters.ActionFilterAttribute.<CallOnActionExecutedAsync>d__6.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Web.Http.Filters.ActionFilterAttribute.<ExecuteActionFilterAsyncCore>d__5.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Web.Http.Controllers.ActionFilterResult.<ExecuteAsync>d__5.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Web.Http.Filters.AuthorizationFilterAttribute.<ExecuteAuthorizationFilterAsyncCore>d__3.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Web.Http.Controllers.ExceptionFilterResult.<ExecuteAsync>d__6.MoveNext()
  [GET] https://imfxv3tm.tmd.tv/api/v3/task/componentqc/109468?_dc=1585732368867
  System.Web.Http.Routing.HttpRoute
t Transfer: 1220 :      9|10:12:50.7955|Ho5_lo|DANIEL|OAuth: /api/v3/search/workflow?_dc=1585732370585
t Transfer: 1220 :      9|10:12:50.7955|Ho5_lo|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|10:12:50.7955|Ho5_lo|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|10:12:50.7955|Ho5_lo|DANIEL|    user DANIEL.
t Verbose: 1220 :       9|10:12:50.7955|Ho5_lo|DANIEL|OAuth. User logged in: DANIEL
t Information: 1220 :   9|10:12:50.7955|Ho5_lo|DANIEL|V3Api.SearchWorkflows
t Information: 1220 :   9|10:12:50.7955|Ho5_lo|DANIEL|V3Api.SearchGeneric
t Transfer: 1220 :      9|10:12:50.7955|Ho5_lo|DANIEL|GetCurrentUser..
t Transfer: 1220 :      9|10:12:50.7955|Ho5_lo|DANIEL|  OAuth authenticated
t Transfer: 1220 :      9|10:12:50.7955|Ho5_lo|DANIEL|    user DANIEL.
t Information: 1220 :   9|10:12:50.7955|Ho5_lo|DANIEL|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=109452   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|10:12:50.7955|Ho5_lo|DANIEL|    jobs returned 1, searched in 00:00:00.0046488
t Information: 1220 :   9|10:12:50.7955|Ho5_lo|DANIEL|    tasks returned 1, searched in 00:00:00.0024872
t Verbose: 1220 :       9|10:12:50.7955|Ho5_lo|DANIEL|imfx v3 API took 0.012s '/api/v3/search/workflow?_dc=1585732370585'
t Information: 1220 :   9|10:12:56.6862|||OrabitWatcherBasic. Disposing.
t Information: 1220 :   9|10:12:56.6862|||OrabitWatcherBasic. Disposed.
t Information: 1220 :   9|10:12:56.6862|||==========================================================================
t Information: 1220 :   9|10:12:56.6862|||IMFX CORE SERVER APPLICATION END.