t Information: 1220 :   9|20:24:28.7951|||Get Configuration Values:
t Information: 1220 :   9|20:24:28.7951|||	AdminPassEnc, default: , value: ffqjrn0leKv4Lj2YJHe2dw==.
t Information: 1220 :   9|20:24:28.7951|||	EncryptedPasswords, default: false, value: true.
t Information: 1220 :   9|20:24:28.7951|||	OraConnectionString, default: , value: Server=TECHM;User Id=imfx;Password=xxxxx;Unicode=true;.
t Information: 1220 :   9|20:24:28.7951|||	SecondTimezone, default: , value: .
t Information: 1220 :   9|20:24:28.7951|||	UseActiveDirectoryAuth, default: false, value: false.
t Information: 1220 :   9|20:24:28.7951|||	ReportingServiceUrl, default: , value: http://localhost:92/ReportingService.svc.
t Information: 1220 :   9|20:24:28.7951|||	ReportsPath, default: , value: .
t Information: 1220 :   9|20:24:28.7951|||	ReportsURL, default: , value: .
t Information: 1220 :   9|20:24:28.7951|||	TapeServiceUrl, default: , value: .
t Information: 1220 :   9|20:24:28.7951|||	GatekeeperUrl, default: , value: .
t Information: 1220 :   9|20:24:28.7951|||	ValuationUrl, default: , value: .
t Information: 1220 :   9|20:24:28.7951|||	QueueManagerDelay, default: 30, value: 30.
t Information: 1220 :   9|20:24:28.7951|||	QueueManagerFullRefresh, default: 90, value: 90.
t Information: 1220 :   9|20:24:28.7951|||	AudioLoopDuration, default: 0, value: 150.
t Information: 1220 :   9|20:24:28.7951|||	AudioLoopsCount, default: 0, value: 0.
t Information: 1220 :   9|20:24:28.7951|||	PlayerFakeStep, default: 500, value: 500.
t Information: 1220 :   9|20:24:28.7951|||	PlayerForceRatio, default: 0, value: 1.
t Information: 1220 :   9|20:24:28.7951|||	CheckVersionsInProd, default: false, value: True.
t Information: 1220 :   9|20:24:28.7951|||	MaxResults, default: 3000, value: 10000.
t Information: 1220 :   9|20:24:28.7951|||	NetworkRestriction, default: false, value: True.
t Information: 1220 :   9|20:24:28.7951|||	TEReportID, default: 0, value: 0.
t Information: 1220 :   9|20:24:28.7951|||	ClosedCaptionsCache, default: , value: C:\inetpub\wwwroot\imfxcore\timedtextcache\.
t Information: 1220 :   9|20:24:28.7951|||	ClosedCaptionsStorage, default: , value: c:\Mediaflex\subs.
t Information: 1220 :   9|20:24:28.7951|||	TimeCodeFormat, default: , value: pal.
t Information: 1220 :   9|20:24:28.7951|||	RceMediaPath, default: , value: C:\edl\.
t Information: 1220 :   9|20:24:28.7951|||	RceMediaPath, default: , value: C:\edl\.
t Information: 1220 :   9|20:24:28.7951|||	RceCsmOutputPath, default: , value: C:\Inetpub\wwwroot\csm\.
t Information: 1220 :   9|20:24:28.7951|||	RceCsmUrl, default: , value: http://localhost/csm/.
t Information: 1220 :   9|20:24:28.7951|||	RceMediaSelection, default: , value: miLinkIdMatch.
t Information: 1220 :   9|20:24:28.7951|||	RequestBrowseJobPresetName, default: , value: .
t Information: 1220 :   9|20:24:28.7951|||	DontExtendDuration, default: false, value: False.
t Information: 1220 :   9|20:24:28.7951|||	V3ConfigUrl, default: , value: .
t Information: 1220 :   9|20:24:28.7951|||	StopWords, default: , value: .
t Information: 1220 :   9|20:24:28.7951|||	MisrTxFormat, default: G, value: G.
t Information: 1220 :   9|20:24:28.7951|||	ApiServer, default: , value: http://192.168.120.10:85.
t Information: 1220 :   9|20:24:28.7951|||	ApiTimeout, default: 120, value: 120.
t Information: 1220 :   9|20:24:28.7951|||	ApiWorkers, default: 10, value: 10.
t Information: 1220 :   9|20:24:28.7951|||	UsePerfCounters, default: false, value: false.
t Information: 1220 :   9|20:24:28.7951|||	StatsdAddress, default: , value: .
t Information: 1220 :   9|20:24:28.7951|||	LogGetCurrentUser, default: true, value: true.
t Information: 1220 :   9|20:24:28.7951|||	LogInternalApi, default: true, value: true.
t Information: 1220 :   9|20:24:28.7951|||	ThumbnailServer, default: , value: .
t Information: 1220 :   9|20:24:28.7951|||	LocationFilter, default: , value: .
t Information: 1220 :   9|20:24:28.7951|||	SvUtilServiceUrl, default: , value: .
t Information: 1220 :   9|20:24:28.7951|||	SolrConnection, default: , value: http://192.168.120.14:8983/solr.
t Information: 1220 :   9|20:24:28.7951|||	UseIndexServerSearch, default: false, value: True.
t Information: 1220 :   9|20:24:28.7951|||	SolrIndexVersion, default: 1, value: 6.
t Information: 1220 :   9|20:24:28.7951|||	SolrConnection, default: , value: http://192.168.120.14:8983/solr.
t Information: 1220 :   9|20:24:28.7951|||	FacetsGroups, default: , value: owners,season_id, series_id,version_key,item_type,media_type,media_format,episode_number.
t Information: 1220 :   9|20:24:28.7951|||	FacetsGroupsVersion, default: , value: owners,season_id, series_id,version_key,episode_number.
t Information: 1220 :   9|20:24:28.7951|||	FacetsGroupsChameleon, default: , value: season_id, series_id,genre,prod_year,version_key.
t Information: 1220 :   9|20:24:28.7951|||	PreviewPreset, default: , value: .
t Information: 1220 :   9|20:24:28.7951|||	DevMode, default: false, value: false.
t Information: 1220 :   9|20:24:28.7951|||	DisableSysMan, default: false, value: false.
t Information: 1220 :   9|20:24:28.7951|||	TimeCodeFormat, default: , value: pal.
t Information: 1220 :   9|20:24:28.7951|||	FileCatalystStorageDevice, default: , value: .
t Information: 1220 :   9|20:24:28.7951|||	UseResponsibilityTracking, default: true, value: True.
t Information: 1220 :   9|20:24:28.7951|||	SubtitleDeviceFilter, default: , value: .
t Information: 1220 :   9|20:24:28.7951|||	SystemMonitorNamedPipe, default: , value: .
t Information: 1220 :   9|20:24:28.7951|||	OracleMonitorEnable, default: false, value: False.
t Information: 1220 :   9|20:24:28.7951|||	ArcApiHost, default: , value: .
t Information: 1220 :   9|20:24:28.7951|||	RabbitMqUrl, default: , value: amqp://192.168.120.14:5672.
t Information: 1220 :   9|20:24:28.7951|||	SolrTimedTextSearch, default: false, value: false.
t Information: 1220 :   9|20:24:28.7951|||	ProductionDurationUsageID, default: 1, value: 1.
t Information: 1220 :   9|20:24:29.0138|||GetStreamServers..
t Information: 1220 :   9|20:24:29.2169|||	https://demo.tmd.tv/CBR Video/ |CBR Video| False  
t Information: 1220 :   9|20:24:29.2169|||	https://demo.tmd.tv/CBR Images/ |CBR Images| False  
t Information: 1220 :   9|20:24:29.2169|||	https://demo.tmd.tv/CBR Audio/ |CBR Audio| False  
t Information: 1220 :   9|20:24:29.2169|||	https://demo.tmd.tv/Temp Upload/ |TEMP_UPLOAD| False  
t Information: 1220 :   9|20:24:29.2169|||	http://localhost:82/images/ |IMAGES| False  
t Information: 1220 :   9|20:24:29.2169|||	http://192.168.91.73/smoothcloud/ |SMOOTH_CLOUD| False  
t Information: 1220 :   9|20:24:29.2169|||	http://192.168.91.73/cloudstore/ |CLOUD_STORE| False  
t Information: 1220 :   9|20:24:29.2169|||	http://192.168.91.73/editsystemin/ |EDIT_SYSTEM_IN| False  
t Information: 1220 :   9|20:24:29.2169|||	http://192.168.91.27:89/APPLEPROXY/ |APPLE_PROXY| False  
t Information: 1220 :   9|20:24:29.2169|||	http://localhost:82/video/ |FILESTORE_VIDEO| False  
t Information: 1220 :   9|20:24:29.2169|||	https://imfxv3tm.tmd.tv/streaming/ |Streaming| False  
t Information: 1220 :   9|20:24:29.2169|||	https://imfxv3tm.tmd.tv/VideoServer/ |Video| False  
t Information: 1220 :   9|20:24:29.2169|||	https://imfxv3tm.tmd.tv/AdobeIn/ |Adobe Premiere Pro In| False  
t Information: 1220 :   9|20:24:29.2169|||	https://imfxv3tm.tmd.tv/AudioServer/ |Audio| False  
t Information: 1220 :   9|20:24:29.2169|||	https://imfxv3tm.tmd.tv/ImageServer/ |Image| False  
t Information: 1220 :   9|20:24:29.2169|||	https://imfxv3tm.tmd.tv/DocsServer/ |Docs| False  
t Information: 1220 :   9|20:24:29.2169|||	https://imfxv3tm.tmd.tv/AmazonLabs/ |TEST HOUSE| False  
t Information: 1220 :   9|20:24:29.2169|||	SolrConnectionUms, default: http://192.168.120.14:8983/solr, value: http://192.168.120.14:8983/solr.
t Information: 1220 :   9|20:24:29.2169|||	LogWebApi, default: false, value: false.
t Information: 1220 :   9|20:24:29.2169|||	EmbeddedRceUrl, default: , value: .
t Information: 1220 :   9|20:24:29.2169|||	InstallMode, default: , value: .
t Information: 1220 :   9|20:24:29.2169|||	SamlRequestAddress, default: , value: .
t Information: 1220 :   9|20:24:29.2169|||	SamlTrustedIssuer, default: , value: .
t Information: 1220 :   9|20:24:29.2169|||	SamlLoginRedirect, default: , value: .
t Information: 1220 :   9|20:24:29.2169|||	NaturalLangSearch, default: false, value: True.
t Information: 1220 :   9|20:24:29.2169|||	OktaLoginField, default: , value: .
t Information: 1220 :   9|20:24:29.2169|||	AuthenticationTypes, default: , value: Native,PublicApiKey.
t Information: 1220 :   9|20:24:29.2169|||OrabitWatcherBasic. Initialize.
t Information: 1220 :   9|20:24:29.4357|||FillDictionaryCache.
t Information: 1220 :   9|20:24:32.7482|||GetSupportedOperators
t Information: 1220 :   9|20:24:32.9513|||CacheTechReports.
t Information: 1220 :   9|20:24:33.1545|||& Cache update. Server (global) filled with timestamp 08:03:32.9826138. types null
t Information: 1220 :   9|20:24:33.1545|||InitializeFromDatabase.
  'Server=TECHM;User Id=imfx;password=..;Unicode=true;'
  direct False, home , timeout 15
t Information: 1220 :   9|20:24:33.1545|||FillDictionaryCache.
t Information: 1220 :   9|20:24:33.1545|||& Cache update. Server (global) filled with timestamp 08:03:32.9982302. types FriendlyNames, DatabaseSearchFieldData
t Information: 1220 :   9|20:24:33.7638|||==========================================================================
t Information: 1220 :   9|20:24:33.7638|||IMFX CORE SERVER APPLICATION START.
t Information: 1220 :   9|20:24:33.7638|||DLL VERSION: 2.5.0.2610.
t Information: 1220 :   9|20:24:33.7638|||IS TIMER HIGH RESOULTION : True.
t Information: 1220 :   9|20:24:33.7638|||	UmsDev, default: False, value: False.
t Information: 1220 :   9|20:24:34.3732|||OrabitWatcherBasic trying to connect..
t Information: 1220 :   9|20:24:34.3732|||OrabitWatcherBasic connected.
t Information: 1220 :   9|20:24:34.3732|||OrabitWatcherBasic queue created tmd.cfg.in.49cc9381-b6fa-4aa6-9036-55fba9289415
t Information: 1220 :   9|20:24:35.9981|wHOB_V|TMDDBA|GetUserProfile. Id: 30000
t Transfer: 1220 :      9|20:24:35.9981|wHOB_V|TMDDBA|GetCurrentUser..
t Transfer: 1220 :      9|20:24:35.9981|wHOB_V|TMDDBA|  OAuth authenticated
t Transfer: 1220 :      9|20:24:35.9981|wHOB_V|TMDDBA|    user TMDDBA.
t Transfer: 1220 :      9|20:24:42.7013|Bs6BG0|TMDDBA|OAuth: /api/settings/user/defaultHomePage?_dc=1585682682466
t Transfer: 1220 :      9|20:24:42.7013|Bs6BG0|TMDDBA|GetCurrentUser..
t Transfer: 1220 :      9|20:24:42.7013|Bs6BG0|TMDDBA|  OAuth authenticated
t Transfer: 1220 :      9|20:24:42.7013|Bs6BG0|TMDDBA|    user TMDDBA.
t Verbose: 1220 :       9|20:24:42.7013|Bs6BG0|TMDDBA|OAuth. User logged in: TMDDBA
t Transfer: 1220 :      9|20:24:42.7013|Bs6BG0|TMDDBA|GetCurrentUser..
t Transfer: 1220 :      9|20:24:42.7013|Bs6BG0|TMDDBA|  OAuth authenticated
t Transfer: 1220 :      9|20:24:42.7013|Bs6BG0|TMDDBA|    user TMDDBA.
t Verbose: 1220 :       9|20:24:42.7013|Bs6BG0|TMDDBA|imfx v3 API took 0.011s '/api/settings/user/defaultHomePage?_dc=1585682682466'
t Transfer: 1220 :      9|20:24:42.7013|Tj0zd7|TMDDBA|OAuth: /api/settings/user/uploadSettings?_dc=1585682682591
t Transfer: 1220 :      9|20:24:42.7013|Tj0zd7|TMDDBA|GetCurrentUser..
t Transfer: 1220 :      9|20:24:42.7013|Tj0zd7|TMDDBA|  OAuth authenticated
t Transfer: 1220 :      9|20:24:42.7013|Tj0zd7|TMDDBA|    user TMDDBA.
t Verbose: 1220 :       9|20:24:42.7013|Tj0zd7|TMDDBA|OAuth. User logged in: TMDDBA
t Transfer: 1220 :      9|20:24:42.7013|Tj0zd7|TMDDBA|GetCurrentUser..
t Transfer: 1220 :      9|20:24:42.7013|Tj0zd7|TMDDBA|  OAuth authenticated
t Transfer: 1220 :      9|20:24:42.7013|Tj0zd7|TMDDBA|    user TMDDBA.
t Verbose: 1220 :       9|20:24:42.7013|Tj0zd7|TMDDBA|imfx v3 API took 0.005s '/api/settings/user/uploadSettings?_dc=1585682682591'
t Information: 1220 :   9|20:24:43.3107|XR8yMu|TMDDBA|GetUserProfile. Id: 0
t Transfer: 1220 :      9|20:24:43.3107|XR8yMu|TMDDBA|GetCurrentUser..
t Transfer: 1220 :      9|20:24:43.3107|XR8yMu|TMDDBA|  OAuth authenticated
t Transfer: 1220 :      9|20:24:43.3107|XR8yMu|TMDDBA|    user TMDDBA.
t Transfer: 1220 :      9|20:24:43.3107|8MZPDA|TMDDBA|OAuth: /api/settings/user/defaultHomePage?_dc=1585682683151
t Transfer: 1220 :      9|20:24:43.3107|8MZPDA|TMDDBA|GetCurrentUser..
t Transfer: 1220 :      9|20:24:43.3107|8MZPDA|TMDDBA|  OAuth authenticated
t Transfer: 1220 :      9|20:24:43.3107|8MZPDA|TMDDBA|    user TMDDBA.
t Verbose: 1220 :       9|20:24:43.3107|8MZPDA|TMDDBA|OAuth. User logged in: TMDDBA
t Transfer: 1220 :      9|20:24:43.3107|8MZPDA|TMDDBA|GetCurrentUser..
t Transfer: 1220 :      9|20:24:43.3107|8MZPDA|TMDDBA|  OAuth authenticated
t Transfer: 1220 :      9|20:24:43.3107|8MZPDA|TMDDBA|    user TMDDBA.
t Verbose: 1220 :       9|20:24:43.3107|8MZPDA|TMDDBA|imfx v3 API took 0.002s '/api/settings/user/defaultHomePage?_dc=1585682683151'
t Transfer: 1220 :      9|20:24:44.1232|VmoUhJ|TMDDBA|OAuth: /api/view/searchinfo/Job?_dc=1585682683994
t Transfer: 1220 :      9|20:24:44.1232|VmoUhJ|TMDDBA|GetCurrentUser..
t Transfer: 1220 :      9|20:24:44.1232|VmoUhJ|TMDDBA|  OAuth authenticated
t Transfer: 1220 :      9|20:24:44.1232|VmoUhJ|TMDDBA|    user TMDDBA.
t Verbose: 1220 :       9|20:24:44.1232|VmoUhJ|TMDDBA|OAuth. User logged in: TMDDBA
t Transfer: 1220 :      9|20:24:44.1232|96l7B2|TMDDBA|OAuth: /api/user-preferences?keys=adv.recent.searches.workflow&_dc=1585682683997
t Transfer: 1220 :      9|20:24:44.1232|96l7B2|TMDDBA|GetCurrentUser..
t Transfer: 1220 :      9|20:24:44.1232|96l7B2|TMDDBA|  OAuth authenticated
t Transfer: 1220 :      9|20:24:44.1232|96l7B2|TMDDBA|    user TMDDBA.
t Verbose: 1220 :       9|20:24:44.1232|96l7B2|TMDDBA|OAuth. User logged in: TMDDBA
t Information: 1220 :   9|20:24:44.1232|VmoUhJ|TMDDBA|GetAdvSearchColumns. search type Job grid .
t Information: 1220 :   9|20:24:44.1232|96l7B2|TMDDBA|GetUserDataByKeys: adv.recent.searches.workflow
t Transfer: 1220 :      9|20:24:44.1232|96l7B2|TMDDBA|GetCurrentUser..
t Transfer: 1220 :      9|20:24:44.1232|96l7B2|TMDDBA|  OAuth authenticated
t Transfer: 1220 :      9|20:24:44.1232|96l7B2|TMDDBA|    user TMDDBA.
t Verbose: 1220 :       9|20:24:44.1232|VmoUhJ|TMDDBA|imfx v3 API took 0.013s '/api/view/searchinfo/Job?_dc=1585682683994'
t Verbose: 1220 :       9|20:24:44.1232|96l7B2|TMDDBA|imfx v3 API took 0.017s '/api/user-preferences?keys=adv.recent.searches.workflow&_dc=1585682683997'
t Transfer: 1220 :      9|20:24:44.1232|IOozIs|TMDDBA|OAuth: /api/view/searches/Job?_dc=1585682684085
t Transfer: 1220 :      9|20:24:44.1232|IOozIs|TMDDBA|GetCurrentUser..
t Transfer: 1220 :      9|20:24:44.1232|IOozIs|TMDDBA|  OAuth authenticated
t Transfer: 1220 :      9|20:24:44.1232|IOozIs|TMDDBA|    user TMDDBA.
t Verbose: 1220 :       9|20:24:44.1232|IOozIs|TMDDBA|OAuth. User logged in: TMDDBA
t Information: 1220 :   9|20:24:44.3263|IOozIs|TMDDBA|GetSavedSearchNames. search type Job.
t Transfer: 1220 :      9|20:24:44.3263|IOozIs|TMDDBA|GetCurrentUser..
t Transfer: 1220 :      9|20:24:44.3263|IOozIs|TMDDBA|  OAuth authenticated
t Transfer: 1220 :      9|20:24:44.3263|IOozIs|TMDDBA|    user TMDDBA.
t Verbose: 1220 :       9|20:24:44.3263|IOozIs|TMDDBA|imfx v3 API took 0.033s '/api/view/searches/Job?_dc=1585682684085'
t Transfer: 1220 :      9|20:25:10.3263|ejueHA|TMDDBA|OAuth: /api/v3/search/workflow?_dc=1585682710244
t Transfer: 1220 :      9|20:25:10.3263|ejueHA|TMDDBA|GetCurrentUser..
t Transfer: 1220 :      9|20:25:10.3263|ejueHA|TMDDBA|  OAuth authenticated
t Transfer: 1220 :      9|20:25:10.3263|ejueHA|TMDDBA|    user TMDDBA.
t Verbose: 1220 :       9|20:25:10.3263|ejueHA|TMDDBA|OAuth. User logged in: TMDDBA
t Information: 1220 :   9|20:25:10.3263|ejueHA|TMDDBA|V3Api.SearchWorkflows
t Information: 1220 :   9|20:25:10.3263|ejueHA|TMDDBA|V3Api.SearchGeneric
t Transfer: 1220 :      9|20:25:10.3263|ejueHA|TMDDBA|GetCurrentUser..
t Transfer: 1220 :      9|20:25:10.3263|ejueHA|TMDDBA|  OAuth authenticated
t Transfer: 1220 :      9|20:25:10.3263|ejueHA|TMDDBA|    user TMDDBA.
t Information: 1220 :   9|20:25:10.3263|ejueHA|TMDDBA|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('31/03/2020','DD/MM/YYYY')   and  j.cmb_stat not in (15,18,23)    AND j.J_CLI_CODE in ('03BO' , '03GD' , '03GO' , '03HA' , '03JO' , '03LI' , '03NB' , '03NM' , '03NO' , '03OR' , '03SB' , '03SC' , '03SE' , '03SG' , '03SK' , '03SM' , '03SN' , '03SS' , '03SY' , '03UP' , '03VA' , '03VB' , '03VL' , '03VT' , '3+ES' , '3PD' , '3PLV' , 'AECHD' , 'AECSD' , 'AL' , 'AMAY' , 'AMC' , 'ATP' , 'CENT' , 'CS' , 'CTCB' , 'CTCE' , 'DAVI' , 'DMA' , 'DMF' , 'DMY' , 'DTV' , 'EST' , 'EUROSPORT' , 'HDC1' , 'HDP1' , 'HDP2' , 'HUB' , 'KNL2' , 'KNVA' , 'LMH' , 'LNT' , 'MBNS' , 'MED' , 'MM' , 'MTG' , 'NAA' , 'NICK' , 'NVA' , 'OSP' , 'PBOY' , 'PMS' , 'PPL' , 'PSP' , 'Play' , 'RTR' , 'SFP1' , 'SFP2' , 'SPG' , 'SPTV' , 'T3LT' , 'T3LV' , 'T6LT' , 'T6LV' , 'T8LT' , 'TECHM' , 'TMD' , 'TV10' , 'TV1A' , 'TV1B' , 'TV1C' , 'TV1D' , 'TV1E' , 'TV1F' , 'TV1K' , 'TV1N' , 'TV1P' , 'TV1S' , 'TV2S' , 'TV3D' , 'TV3N' , 'TV3S' , 'TV5L' , 'TV6E' , 'TV6H' , 'TV6N' , 'TV6S' , 'TV8' , 'TVAE' , 'TVDP' , 'TVPB' , 'TVPU' , 'TVSL' , 'V1G' , 'V1TZ' , 'V3H' , 'V4N' , 'VEC' , 'VEPL' , 'VEPO' , 'VEXE' , 'VEXR' , 'VHIS' , 'VHPO' , 'VNC' , 'VNE' , 'VNH' , 'VNHD' , 'VNPO' , 'VODD' , 'VODE' , 'VODF' , 'VODN' , 'VODS' , 'VS2' , 'VS3' , 'VSAT' , 'VSD' , 'VSD2' , 'VSE' , 'VSG' , 'VSHD' , 'VSS' , 'WCIU' , 'YLE TV1' , 'ZTVS') 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|20:25:10.5295|ejueHA|TMDDBA|    jobs returned 13, searched in 00:00:00.0132584
t Information: 1220 :   9|20:25:10.5295|ejueHA|TMDDBA|TechReports is not found. ID: 96.
t Information: 1220 :   9|20:25:10.5295|ejueHA|TMDDBA|TechReports is not found. ID: 41.
t Information: 1220 :   9|20:25:10.5295|ejueHA|TMDDBA|TechReports is not found. ID: 1633.
t Information: 1220 :   9|20:25:10.5295|ejueHA|TMDDBA|TechReports is not found. ID: 1300.
t Information: 1220 :   9|20:25:10.5295|ejueHA|TMDDBA|TechReports is not found. ID: 116.
t Information: 1220 :   9|20:25:10.5295|ejueHA|TMDDBA|TechReports is not found. ID: 673.
t Information: 1220 :   9|20:25:10.5295|ejueHA|TMDDBA|TechReports is not found. ID: 1301.
t Information: 1220 :   9|20:25:10.5295|ejueHA|TMDDBA|    tasks returned 13, searched in 00:00:00.0497105
t Verbose: 1220 :       9|20:25:10.5295|ejueHA|TMDDBA|imfx v3 API took 0.076s '/api/v3/search/workflow?_dc=1585682710244'
t Transfer: 1220 :      9|20:25:10.7326|HbceSZ|TMDDBA|OAuth: /api/user-preferences?_dc=1585682710664
t Transfer: 1220 :      9|20:25:10.7326|HbceSZ|TMDDBA|GetCurrentUser..
t Transfer: 1220 :      9|20:25:10.7326|HbceSZ|TMDDBA|  OAuth authenticated
t Transfer: 1220 :      9|20:25:10.7326|HbceSZ|TMDDBA|    user TMDDBA.
t Verbose: 1220 :       9|20:25:10.7326|HbceSZ|TMDDBA|OAuth. User logged in: TMDDBA
t Verbose: 1220 :       9|20:25:10.7326|HbceSZ|TMDDBA|StoreUserDataByKeys..
t Transfer: 1220 :      9|20:25:10.7326|HbceSZ|TMDDBA|GetCurrentUser..
t Transfer: 1220 :      9|20:25:10.7326|HbceSZ|TMDDBA|  OAuth authenticated
t Transfer: 1220 :      9|20:25:10.7326|HbceSZ|TMDDBA|    user TMDDBA.
t Verbose: 1220 :       9|20:25:10.9357|HbceSZ|TMDDBA|imfx v3 API took 0.031s '/api/user-preferences?_dc=1585682710664'
t Transfer: 1220 :      9|20:25:14.4044|kw_shI|TMDDBA|OAuth: /api/v3/task/componentqc/108989?_dc=1585682714188
t Transfer: 1220 :      9|20:25:14.4044|kw_shI|TMDDBA|GetCurrentUser..
t Transfer: 1220 :      9|20:25:14.4044|kw_shI|TMDDBA|  OAuth authenticated
t Transfer: 1220 :      9|20:25:14.4044|kw_shI|TMDDBA|    user TMDDBA.
t Verbose: 1220 :       9|20:25:14.4044|kw_shI|TMDDBA|OAuth. User logged in: TMDDBA
t Information: 1220 :   9|20:25:14.4044|kw_shI|TMDDBA|V3Api. GetComponentQc task: 108989
t Information: 1220 :   9|20:25:14.4044|kw_shI|TMDDBA|SubtitleQcTask. LoadFromDb got Job 108988 and Subtitles 1.
t Verbose: 1220 :       9|20:25:14.4044|kw_shI|TMDDBA|imfx v3 API took 0.106s '/api/v3/task/componentqc/108989?_dc=1585682714188'
t Information: 1220 :   9|20:25:14.4200|kw_shI|TMDDBA|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/108989?_dc=1585682714188
  System.Web.Http.Routing.HttpRoute
t Transfer: 1220 :      9|20:25:17.0763|cKA4Gw|TMDDBA|OAuth: /api/v3/search/workflow?_dc=1585682716911
t Transfer: 1220 :      9|20:25:17.0763|cKA4Gw|TMDDBA|GetCurrentUser..
t Transfer: 1220 :      9|20:25:17.0763|cKA4Gw|TMDDBA|  OAuth authenticated
t Transfer: 1220 :      9|20:25:17.0763|cKA4Gw|TMDDBA|    user TMDDBA.
t Verbose: 1220 :       9|20:25:17.0763|cKA4Gw|TMDDBA|OAuth. User logged in: TMDDBA
t Information: 1220 :   9|20:25:17.0763|cKA4Gw|TMDDBA|V3Api.SearchWorkflows
t Information: 1220 :   9|20:25:17.0763|cKA4Gw|TMDDBA|V3Api.SearchGeneric
t Transfer: 1220 :      9|20:25:17.0763|cKA4Gw|TMDDBA|GetCurrentUser..
t Transfer: 1220 :      9|20:25:17.0763|cKA4Gw|TMDDBA|  OAuth authenticated
t Transfer: 1220 :      9|20:25:17.0763|cKA4Gw|TMDDBA|    user TMDDBA.
t Information: 1220 :   9|20:25:17.0763|cKA4Gw|TMDDBA|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=108988   AND j.J_CLI_CODE in ('03BO' , '03GD' , '03GO' , '03HA' , '03JO' , '03LI' , '03NB' , '03NM' , '03NO' , '03OR' , '03SB' , '03SC' , '03SE' , '03SG' , '03SK' , '03SM' , '03SN' , '03SS' , '03SY' , '03UP' , '03VA' , '03VB' , '03VL' , '03VT' , '3+ES' , '3PD' , '3PLV' , 'AECHD' , 'AECSD' , 'AL' , 'AMAY' , 'AMC' , 'ATP' , 'CENT' , 'CS' , 'CTCB' , 'CTCE' , 'DAVI' , 'DMA' , 'DMF' , 'DMY' , 'DTV' , 'EST' , 'EUROSPORT' , 'HDC1' , 'HDP1' , 'HDP2' , 'HUB' , 'KNL2' , 'KNVA' , 'LMH' , 'LNT' , 'MBNS' , 'MED' , 'MM' , 'MTG' , 'NAA' , 'NICK' , 'NVA' , 'OSP' , 'PBOY' , 'PMS' , 'PPL' , 'PSP' , 'Play' , 'RTR' , 'SFP1' , 'SFP2' , 'SPG' , 'SPTV' , 'T3LT' , 'T3LV' , 'T6LT' , 'T6LV' , 'T8LT' , 'TECHM' , 'TMD' , 'TV10' , 'TV1A' , 'TV1B' , 'TV1C' , 'TV1D' , 'TV1E' , 'TV1F' , 'TV1K' , 'TV1N' , 'TV1P' , 'TV1S' , 'TV2S' , 'TV3D' , 'TV3N' , 'TV3S' , 'TV5L' , 'TV6E' , 'TV6H' , 'TV6N' , 'TV6S' , 'TV8' , 'TVAE' , 'TVDP' , 'TVPB' , 'TVPU' , 'TVSL' , 'V1G' , 'V1TZ' , 'V3H' , 'V4N' , 'VEC' , 'VEPL' , 'VEPO' , 'VEXE' , 'VEXR' , 'VHIS' , 'VHPO' , 'VNC' , 'VNE' , 'VNH' , 'VNHD' , 'VNPO' , 'VODD' , 'VODE' , 'VODF' , 'VODN' , 'VODS' , 'VS2' , 'VS3' , 'VSAT' , 'VSD' , 'VSD2' , 'VSE' , 'VSG' , 'VSHD' , 'VSS' , 'WCIU' , 'YLE TV1' , 'ZTVS') 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|20:25:17.2794|cKA4Gw|TMDDBA|    jobs returned 1, searched in 00:00:00.1997046
t Information: 1220 :   9|20:25:17.4825|cKA4Gw|TMDDBA|    tasks returned 1, searched in 00:00:00.0314624
t Verbose: 1220 :       9|20:25:17.4825|cKA4Gw|TMDDBA|imfx v3 API took 0.344s '/api/v3/search/workflow?_dc=1585682716911'
t Information: 1220 :   9|20:25:28.0451|mXjz18|TMDDBA|GetUserProfile. Id: 30000
t Transfer: 1220 :      9|20:25:28.0451|mXjz18|TMDDBA|GetCurrentUser..
t Transfer: 1220 :      9|20:25:28.0451|mXjz18|TMDDBA|  OAuth authenticated
t Transfer: 1220 :      9|20:25:28.0451|mXjz18|TMDDBA|    user TMDDBA.
t Transfer: 1220 :      9|20:25:53.0294|GXGArH|TMDDBA|OAuth: /api/v3/search/workflow?_dc=1585682752912
t Transfer: 1220 :      9|20:25:53.0294|GXGArH|TMDDBA|GetCurrentUser..
t Transfer: 1220 :      9|20:25:53.0294|GXGArH|TMDDBA|  OAuth authenticated
t Transfer: 1220 :      9|20:25:53.0294|GXGArH|TMDDBA|    user TMDDBA.
t Verbose: 1220 :       9|20:25:53.0294|GXGArH|TMDDBA|OAuth. User logged in: TMDDBA
t Information: 1220 :   9|20:25:53.0294|GXGArH|TMDDBA|V3Api.SearchWorkflows
t Information: 1220 :   9|20:25:53.0294|GXGArH|TMDDBA|V3Api.SearchGeneric
t Transfer: 1220 :      9|20:25:53.0294|GXGArH|TMDDBA|GetCurrentUser..
t Transfer: 1220 :      9|20:25:53.0294|GXGArH|TMDDBA|  OAuth authenticated
t Transfer: 1220 :      9|20:25:53.0294|GXGArH|TMDDBA|    user TMDDBA.
t Information: 1220 :   9|20:25:53.0294|GXGArH|TMDDBA|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('31/03/2020','DD/MM/YYYY')   and  j.cmb_stat not in (15,18,23)    AND j.J_CLI_CODE in ('03BO' , '03GD' , '03GO' , '03HA' , '03JO' , '03LI' , '03NB' , '03NM' , '03NO' , '03OR' , '03SB' , '03SC' , '03SE' , '03SG' , '03SK' , '03SM' , '03SN' , '03SS' , '03SY' , '03UP' , '03VA' , '03VB' , '03VL' , '03VT' , '3+ES' , '3PD' , '3PLV' , 'AECHD' , 'AECSD' , 'AL' , 'AMAY' , 'AMC' , 'ATP' , 'CENT' , 'CS' , 'CTCB' , 'CTCE' , 'DAVI' , 'DMA' , 'DMF' , 'DMY' , 'DTV' , 'EST' , 'EUROSPORT' , 'HDC1' , 'HDP1' , 'HDP2' , 'HUB' , 'KNL2' , 'KNVA' , 'LMH' , 'LNT' , 'MBNS' , 'MED' , 'MM' , 'MTG' , 'NAA' , 'NICK' , 'NVA' , 'OSP' , 'PBOY' , 'PMS' , 'PPL' , 'PSP' , 'Play' , 'RTR' , 'SFP1' , 'SFP2' , 'SPG' , 'SPTV' , 'T3LT' , 'T3LV' , 'T6LT' , 'T6LV' , 'T8LT' , 'TECHM' , 'TMD' , 'TV10' , 'TV1A' , 'TV1B' , 'TV1C' , 'TV1D' , 'TV1E' , 'TV1F' , 'TV1K' , 'TV1N' , 'TV1P' , 'TV1S' , 'TV2S' , 'TV3D' , 'TV3N' , 'TV3S' , 'TV5L' , 'TV6E' , 'TV6H' , 'TV6N' , 'TV6S' , 'TV8' , 'TVAE' , 'TVDP' , 'TVPB' , 'TVPU' , 'TVSL' , 'V1G' , 'V1TZ' , 'V3H' , 'V4N' , 'VEC' , 'VEPL' , 'VEPO' , 'VEXE' , 'VEXR' , 'VHIS' , 'VHPO' , 'VNC' , 'VNE' , 'VNH' , 'VNHD' , 'VNPO' , 'VODD' , 'VODE' , 'VODF' , 'VODN' , 'VODS' , 'VS2' , 'VS3' , 'VSAT' , 'VSD' , 'VSD2' , 'VSE' , 'VSG' , 'VSHD' , 'VSS' , 'WCIU' , 'YLE TV1' , 'ZTVS') 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|20:25:53.0294|GXGArH|TMDDBA|    jobs returned 14, searched in 00:00:00.0118889
t Information: 1220 :   9|20:25:53.0294|GXGArH|TMDDBA|TechReports is not found. ID: 96.
t Information: 1220 :   9|20:25:53.0294|GXGArH|TMDDBA|TechReports is not found. ID: 41.
t Information: 1220 :   9|20:25:53.0294|GXGArH|TMDDBA|TechReports is not found. ID: 1633.
t Information: 1220 :   9|20:25:53.0294|GXGArH|TMDDBA|TechReports is not found. ID: 1300.
t Information: 1220 :   9|20:25:53.0294|GXGArH|TMDDBA|TechReports is not found. ID: 116.
t Information: 1220 :   9|20:25:53.0294|GXGArH|TMDDBA|TechReports is not found. ID: 673.
t Information: 1220 :   9|20:25:53.0294|GXGArH|TMDDBA|TechReports is not found. ID: 1301.
t Information: 1220 :   9|20:25:53.0294|GXGArH|TMDDBA|    tasks returned 14, searched in 00:00:00.0341650
t Verbose: 1220 :       9|20:25:53.0294|GXGArH|TMDDBA|imfx v3 API took 0.052s '/api/v3/search/workflow?_dc=1585682752912'
t Transfer: 1220 :      9|20:25:53.2482|EaRoUC|TMDDBA|OAuth: /api/user-preferences?_dc=1585682753151
t Transfer: 1220 :      9|20:25:53.2482|EaRoUC|TMDDBA|GetCurrentUser..
t Transfer: 1220 :      9|20:25:53.2482|EaRoUC|TMDDBA|  OAuth authenticated
t Transfer: 1220 :      9|20:25:53.2482|EaRoUC|TMDDBA|    user TMDDBA.
t Verbose: 1220 :       9|20:25:53.2482|EaRoUC|TMDDBA|OAuth. User logged in: TMDDBA
t Verbose: 1220 :       9|20:25:53.2482|EaRoUC|TMDDBA|StoreUserDataByKeys..
t Transfer: 1220 :      9|20:25:53.2482|EaRoUC|TMDDBA|GetCurrentUser..
t Transfer: 1220 :      9|20:25:53.2482|EaRoUC|TMDDBA|  OAuth authenticated
t Transfer: 1220 :      9|20:25:53.2482|EaRoUC|TMDDBA|    user TMDDBA.
t Verbose: 1220 :       9|20:25:53.2482|EaRoUC|TMDDBA|imfx v3 API took 0.010s '/api/user-preferences?_dc=1585682753151'
t Transfer: 1220 :      9|20:25:55.4825|mpPXC~|TMDDBA|OAuth: /api/v3/task/componentqc/108993?_dc=1585682755326
t Transfer: 1220 :      9|20:25:55.4825|mpPXC~|TMDDBA|GetCurrentUser..
t Transfer: 1220 :      9|20:25:55.4825|mpPXC~|TMDDBA|  OAuth authenticated
t Transfer: 1220 :      9|20:25:55.4825|mpPXC~|TMDDBA|    user TMDDBA.
t Verbose: 1220 :       9|20:25:55.4825|mpPXC~|TMDDBA|OAuth. User logged in: TMDDBA
t Information: 1220 :   9|20:25:55.4825|mpPXC~|TMDDBA|V3Api. GetComponentQc task: 108993
t Information: 1220 :   9|20:25:55.4825|mpPXC~|TMDDBA|SubtitleQcTask. LoadFromDb got Job 108992 and Subtitles 2.
t Verbose: 1220 :       9|20:25:55.4825|mpPXC~|TMDDBA|imfx v3 API took 0.030s '/api/v3/task/componentqc/108993?_dc=1585682755326'
t Information: 1220 :   9|20:25:55.4825|mpPXC~|TMDDBA|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/108993?_dc=1585682755326
  System.Web.Http.Routing.HttpRoute
t Transfer: 1220 :      9|20:25:57.5138|tgwzZR|TMDDBA|OAuth: /api/v3/search/workflow?_dc=1585682757451
t Transfer: 1220 :      9|20:25:57.5138|tgwzZR|TMDDBA|GetCurrentUser..
t Transfer: 1220 :      9|20:25:57.5138|tgwzZR|TMDDBA|  OAuth authenticated
t Transfer: 1220 :      9|20:25:57.5138|tgwzZR|TMDDBA|    user TMDDBA.
t Verbose: 1220 :       9|20:25:57.5138|tgwzZR|TMDDBA|OAuth. User logged in: TMDDBA
t Information: 1220 :   9|20:25:57.5138|tgwzZR|TMDDBA|V3Api.SearchWorkflows
t Information: 1220 :   9|20:25:57.5138|tgwzZR|TMDDBA|V3Api.SearchGeneric
t Transfer: 1220 :      9|20:25:57.5138|tgwzZR|TMDDBA|GetCurrentUser..
t Transfer: 1220 :      9|20:25:57.5138|tgwzZR|TMDDBA|  OAuth authenticated
t Transfer: 1220 :      9|20:25:57.5138|tgwzZR|TMDDBA|    user TMDDBA.
t Information: 1220 :   9|20:25:57.7169|tgwzZR|TMDDBA|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=108992   AND j.J_CLI_CODE in ('03BO' , '03GD' , '03GO' , '03HA' , '03JO' , '03LI' , '03NB' , '03NM' , '03NO' , '03OR' , '03SB' , '03SC' , '03SE' , '03SG' , '03SK' , '03SM' , '03SN' , '03SS' , '03SY' , '03UP' , '03VA' , '03VB' , '03VL' , '03VT' , '3+ES' , '3PD' , '3PLV' , 'AECHD' , 'AECSD' , 'AL' , 'AMAY' , 'AMC' , 'ATP' , 'CENT' , 'CS' , 'CTCB' , 'CTCE' , 'DAVI' , 'DMA' , 'DMF' , 'DMY' , 'DTV' , 'EST' , 'EUROSPORT' , 'HDC1' , 'HDP1' , 'HDP2' , 'HUB' , 'KNL2' , 'KNVA' , 'LMH' , 'LNT' , 'MBNS' , 'MED' , 'MM' , 'MTG' , 'NAA' , 'NICK' , 'NVA' , 'OSP' , 'PBOY' , 'PMS' , 'PPL' , 'PSP' , 'Play' , 'RTR' , 'SFP1' , 'SFP2' , 'SPG' , 'SPTV' , 'T3LT' , 'T3LV' , 'T6LT' , 'T6LV' , 'T8LT' , 'TECHM' , 'TMD' , 'TV10' , 'TV1A' , 'TV1B' , 'TV1C' , 'TV1D' , 'TV1E' , 'TV1F' , 'TV1K' , 'TV1N' , 'TV1P' , 'TV1S' , 'TV2S' , 'TV3D' , 'TV3N' , 'TV3S' , 'TV5L' , 'TV6E' , 'TV6H' , 'TV6N' , 'TV6S' , 'TV8' , 'TVAE' , 'TVDP' , 'TVPB' , 'TVPU' , 'TVSL' , 'V1G' , 'V1TZ' , 'V3H' , 'V4N' , 'VEC' , 'VEPL' , 'VEPO' , 'VEXE' , 'VEXR' , 'VHIS' , 'VHPO' , 'VNC' , 'VNE' , 'VNH' , 'VNHD' , 'VNPO' , 'VODD' , 'VODE' , 'VODF' , 'VODN' , 'VODS' , 'VS2' , 'VS3' , 'VSAT' , 'VSD' , 'VSD2' , 'VSE' , 'VSG' , 'VSHD' , 'VSS' , 'WCIU' , 'YLE TV1' , 'ZTVS') 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|20:25:57.7169|tgwzZR|TMDDBA|    jobs returned 1, searched in 00:00:00.1948465
t Information: 1220 :   9|20:25:57.9200|tgwzZR|TMDDBA|    tasks returned 1, searched in 00:00:00.0229552
t Verbose: 1220 :       9|20:25:57.9200|tgwzZR|TMDDBA|imfx v3 API took 0.246s '/api/v3/search/workflow?_dc=1585682757451'
t Transfer: 1220 :      9|20:26:28.6076|795ndS|TMDDBA|OAuth: /api/v3/task/componentqc/108993?_dc=1585682788425
t Transfer: 1220 :      9|20:26:28.6076|795ndS|TMDDBA|GetCurrentUser..
t Transfer: 1220 :      9|20:26:28.6076|795ndS|TMDDBA|  OAuth authenticated
t Transfer: 1220 :      9|20:26:28.6076|795ndS|TMDDBA|    user TMDDBA.
t Verbose: 1220 :       9|20:26:28.6076|795ndS|TMDDBA|OAuth. User logged in: TMDDBA
t Information: 1220 :   9|20:26:28.6076|795ndS|TMDDBA|V3Api. GetComponentQc task: 108993
t Information: 1220 :   9|20:26:28.6076|795ndS|TMDDBA|SubtitleQcTask. LoadFromDb got Job 108992 and Subtitles 2.
t Verbose: 1220 :       9|20:26:28.6076|795ndS|TMDDBA|imfx v3 API took 0.031s '/api/v3/task/componentqc/108993?_dc=1585682788425'
t Information: 1220 :   9|20:26:28.6076|795ndS|TMDDBA|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/108993?_dc=1585682788425
  System.Web.Http.Routing.HttpRoute
t Information: 1220 :   9|20:26:29.8263|fka74w|TMDDBA|GetUserProfile. Id: 30000
t Transfer: 1220 :      9|20:26:29.8263|fka74w|TMDDBA|GetCurrentUser..
t Transfer: 1220 :      9|20:26:29.8263|fka74w|TMDDBA|  OAuth authenticated
t Transfer: 1220 :      9|20:26:29.8263|fka74w|TMDDBA|    user TMDDBA.
t Transfer: 1220 :      9|20:26:31.0450|rcGN82|TMDDBA|OAuth: /api/v3/search/workflow?_dc=1585682790862
t Transfer: 1220 :      9|20:26:31.0450|rcGN82|TMDDBA|GetCurrentUser..
t Transfer: 1220 :      9|20:26:31.0450|rcGN82|TMDDBA|  OAuth authenticated
t Transfer: 1220 :      9|20:26:31.0450|rcGN82|TMDDBA|    user TMDDBA.
t Verbose: 1220 :       9|20:26:31.0450|rcGN82|TMDDBA|OAuth. User logged in: TMDDBA
t Information: 1220 :   9|20:26:31.0450|rcGN82|TMDDBA|V3Api.SearchWorkflows
t Information: 1220 :   9|20:26:31.0450|rcGN82|TMDDBA|V3Api.SearchGeneric
t Transfer: 1220 :      9|20:26:31.0450|rcGN82|TMDDBA|GetCurrentUser..
t Transfer: 1220 :      9|20:26:31.0450|rcGN82|TMDDBA|  OAuth authenticated
t Transfer: 1220 :      9|20:26:31.0450|rcGN82|TMDDBA|    user TMDDBA.
t Information: 1220 :   9|20:26:31.0450|rcGN82|TMDDBA|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=108992   AND j.J_CLI_CODE in ('03BO' , '03GD' , '03GO' , '03HA' , '03JO' , '03LI' , '03NB' , '03NM' , '03NO' , '03OR' , '03SB' , '03SC' , '03SE' , '03SG' , '03SK' , '03SM' , '03SN' , '03SS' , '03SY' , '03UP' , '03VA' , '03VB' , '03VL' , '03VT' , '3+ES' , '3PD' , '3PLV' , 'AECHD' , 'AECSD' , 'AL' , 'AMAY' , 'AMC' , 'ATP' , 'CENT' , 'CS' , 'CTCB' , 'CTCE' , 'DAVI' , 'DMA' , 'DMF' , 'DMY' , 'DTV' , 'EST' , 'EUROSPORT' , 'HDC1' , 'HDP1' , 'HDP2' , 'HUB' , 'KNL2' , 'KNVA' , 'LMH' , 'LNT' , 'MBNS' , 'MED' , 'MM' , 'MTG' , 'NAA' , 'NICK' , 'NVA' , 'OSP' , 'PBOY' , 'PMS' , 'PPL' , 'PSP' , 'Play' , 'RTR' , 'SFP1' , 'SFP2' , 'SPG' , 'SPTV' , 'T3LT' , 'T3LV' , 'T6LT' , 'T6LV' , 'T8LT' , 'TECHM' , 'TMD' , 'TV10' , 'TV1A' , 'TV1B' , 'TV1C' , 'TV1D' , 'TV1E' , 'TV1F' , 'TV1K' , 'TV1N' , 'TV1P' , 'TV1S' , 'TV2S' , 'TV3D' , 'TV3N' , 'TV3S' , 'TV5L' , 'TV6E' , 'TV6H' , 'TV6N' , 'TV6S' , 'TV8' , 'TVAE' , 'TVDP' , 'TVPB' , 'TVPU' , 'TVSL' , 'V1G' , 'V1TZ' , 'V3H' , 'V4N' , 'VEC' , 'VEPL' , 'VEPO' , 'VEXE' , 'VEXR' , 'VHIS' , 'VHPO' , 'VNC' , 'VNE' , 'VNH' , 'VNHD' , 'VNPO' , 'VODD' , 'VODE' , 'VODF' , 'VODN' , 'VODS' , 'VS2' , 'VS3' , 'VSAT' , 'VSD' , 'VSD2' , 'VSE' , 'VSG' , 'VSHD' , 'VSS' , 'WCIU' , 'YLE TV1' , 'ZTVS') 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|20:26:31.0450|rcGN82|TMDDBA|    jobs returned 1, searched in 00:00:00.0047598
t Information: 1220 :   9|20:26:31.0450|rcGN82|TMDDBA|    tasks returned 1, searched in 00:00:00.0070481
t Verbose: 1220 :       9|20:26:31.0450|rcGN82|TMDDBA|imfx v3 API took 0.024s '/api/v3/search/workflow?_dc=1585682790862'
t Transfer: 1220 :      9|20:26:31.8575|qovfUX||GetAppInfo. DB: TMDDEMO. Install mode: . Auth types: Native, PublicApiKey
t Transfer: 1220 :      9|20:26:33.2794|q94ejp||GetAppInfo. DB: TMDDEMO. Install mode: . Auth types: Native, PublicApiKey
t Information: 1220 :   9|20:27:30.7638|1BSPha|TMDDBA|GetUserProfile. Id: 30000
t Transfer: 1220 :      9|20:27:30.7638|1BSPha|TMDDBA|GetCurrentUser..
t Transfer: 1220 :      9|20:27:30.7638|1BSPha|TMDDBA|  OAuth authenticated
t Transfer: 1220 :      9|20:27:30.7638|1BSPha|TMDDBA|    user TMDDBA.
t Information: 1220 :   9|20:28:32.3107|8Y_Jie|TMDDBA|GetUserProfile. Id: 30000
t Transfer: 1220 :      9|20:28:32.3107|8Y_Jie|TMDDBA|GetCurrentUser..
t Transfer: 1220 :      9|20:28:32.3107|8Y_Jie|TMDDBA|  OAuth authenticated
t Transfer: 1220 :      9|20:28:32.3107|8Y_Jie|TMDDBA|    user TMDDBA.
t Information: 1220 :   9|20:29:33.8576|L5MhUx|TMDDBA|GetUserProfile. Id: 30000
t Transfer: 1220 :      9|20:29:33.8576|L5MhUx|TMDDBA|GetCurrentUser..
t Transfer: 1220 :      9|20:29:33.8576|L5MhUx|TMDDBA|  OAuth authenticated
t Transfer: 1220 :      9|20:29:33.8576|L5MhUx|TMDDBA|    user TMDDBA.
t Information: 1220 :   9|20:30:35.6078|exDPdw|TMDDBA|GetUserProfile. Id: 30000
t Transfer: 1220 :      9|20:30:35.6078|exDPdw|TMDDBA|GetCurrentUser..
t Transfer: 1220 :      9|20:30:35.6078|exDPdw|TMDDBA|  OAuth authenticated
t Transfer: 1220 :      9|20:30:35.6078|exDPdw|TMDDBA|    user TMDDBA.
t Information: 1220 :   9|20:31:37.1547|PoMyCP|TMDDBA|GetUserProfile. Id: 30000
t Transfer: 1220 :      9|20:31:37.1547|PoMyCP|TMDDBA|GetCurrentUser..
t Transfer: 1220 :      9|20:31:37.1547|PoMyCP|TMDDBA|  OAuth authenticated
t Transfer: 1220 :      9|20:31:37.1547|PoMyCP|TMDDBA|    user TMDDBA.
t Information: 1220 :   9|20:32:38.4984|O6D~K7|TMDDBA|GetUserProfile. Id: 30000
t Transfer: 1220 :      9|20:32:38.4984|O6D~K7|TMDDBA|GetCurrentUser..
t Transfer: 1220 :      9|20:32:38.4984|O6D~K7|TMDDBA|  OAuth authenticated
t Transfer: 1220 :      9|20:32:38.4984|O6D~K7|TMDDBA|    user TMDDBA.
t Information: 1220 :   9|20:33:39.8422|_9zMqK|TMDDBA|GetUserProfile. Id: 30000
t Transfer: 1220 :      9|20:33:39.8422|_9zMqK|TMDDBA|GetCurrentUser..
t Transfer: 1220 :      9|20:33:39.8422|_9zMqK|TMDDBA|  OAuth authenticated
t Transfer: 1220 :      9|20:33:39.8422|_9zMqK|TMDDBA|    user TMDDBA.
t Information: 1220 :   9|20:34:41.3891|ITtWoR|TMDDBA|GetUserProfile. Id: 30000
t Transfer: 1220 :      9|20:34:41.3891|ITtWoR|TMDDBA|GetCurrentUser..
t Transfer: 1220 :      9|20:34:41.3891|ITtWoR|TMDDBA|  OAuth authenticated
t Transfer: 1220 :      9|20:34:41.3891|ITtWoR|TMDDBA|    user TMDDBA.
t Information: 1220 :   9|20:35:42.1235|vs6DGu|TMDDBA|GetUserProfile. Id: 30000
t Transfer: 1220 :      9|20:35:42.1235|vs6DGu|TMDDBA|GetCurrentUser..
t Transfer: 1220 :      9|20:35:42.1235|vs6DGu|TMDDBA|  OAuth authenticated
t Transfer: 1220 :      9|20:35:42.1235|vs6DGu|TMDDBA|    user TMDDBA.
t Information: 1220 :   9|20:36:43.8735|ulVaCA|TMDDBA|GetUserProfile. Id: 30000
t Transfer: 1220 :      9|20:36:43.8735|ulVaCA|TMDDBA|GetCurrentUser..
t Transfer: 1220 :      9|20:36:43.8735|ulVaCA|TMDDBA|  OAuth authenticated
t Transfer: 1220 :      9|20:36:43.8735|ulVaCA|TMDDBA|    user TMDDBA.
t Information: 1220 :   9|20:37:45.2172|6LB~JW|TMDDBA|GetUserProfile. Id: 30000
t Transfer: 1220 :      9|20:37:45.2172|6LB~JW|TMDDBA|GetCurrentUser..
t Transfer: 1220 :      9|20:37:45.2172|6LB~JW|TMDDBA|  OAuth authenticated
t Transfer: 1220 :      9|20:37:45.2172|6LB~JW|TMDDBA|    user TMDDBA.
t Information: 1220 :   9|20:38:45.7484|9wsV5M|TMDDBA|GetUserProfile. Id: 30000
t Transfer: 1220 :      9|20:38:45.7484|9wsV5M|TMDDBA|GetCurrentUser..
t Transfer: 1220 :      9|20:38:45.7484|9wsV5M|TMDDBA|  OAuth authenticated
t Transfer: 1220 :      9|20:38:45.7484|9wsV5M|TMDDBA|    user TMDDBA.
t Information: 1220 :   9|20:39:46.2797|tr4Yvc|TMDDBA|GetUserProfile. Id: 30000
t Transfer: 1220 :      9|20:39:46.2797|tr4Yvc|TMDDBA|GetCurrentUser..
t Transfer: 1220 :      9|20:39:46.2797|tr4Yvc|TMDDBA|  OAuth authenticated
t Transfer: 1220 :      9|20:39:46.2797|tr4Yvc|TMDDBA|    user TMDDBA.
t Information: 1220 :   9|20:40:46.8110|GXT9b~|TMDDBA|GetUserProfile. Id: 30000
t Transfer: 1220 :      9|20:40:46.8110|GXT9b~|TMDDBA|GetCurrentUser..
t Transfer: 1220 :      9|20:40:46.8110|GXT9b~|TMDDBA|  OAuth authenticated
t Transfer: 1220 :      9|20:40:46.8110|GXT9b~|TMDDBA|    user TMDDBA.
t Information: 1220 :   9|20:41:48.3578|H6vM27|TMDDBA|GetUserProfile. Id: 30000
t Transfer: 1220 :      9|20:41:48.3578|H6vM27|TMDDBA|GetCurrentUser..
t Transfer: 1220 :      9|20:41:48.3578|H6vM27|TMDDBA|  OAuth authenticated
t Transfer: 1220 :      9|20:41:48.3578|H6vM27|TMDDBA|    user TMDDBA.
t Information: 1220 :   9|20:42:49.9048|nH~G1z|TMDDBA|GetUserProfile. Id: 30000
t Transfer: 1220 :      9|20:42:49.9048|nH~G1z|TMDDBA|GetCurrentUser..
t Transfer: 1220 :      9|20:42:49.9048|nH~G1z|TMDDBA|  OAuth authenticated
t Transfer: 1220 :      9|20:42:49.9048|nH~G1z|TMDDBA|    user TMDDBA.
t Information: 1220 :   9|20:43:51.2485|M_MzhD|TMDDBA|GetUserProfile. Id: 30000
t Transfer: 1220 :      9|20:43:51.2485|M_MzhD|TMDDBA|GetCurrentUser..
t Transfer: 1220 :      9|20:43:51.2485|M_MzhD|TMDDBA|  OAuth authenticated
t Transfer: 1220 :      9|20:43:51.2485|M_MzhD|TMDDBA|    user TMDDBA.
t Information: 1220 :   9|20:44:52.7954|ORsbps|TMDDBA|GetUserProfile. Id: 30000
t Transfer: 1220 :      9|20:44:52.7954|ORsbps|TMDDBA|GetCurrentUser..
t Transfer: 1220 :      9|20:44:52.7954|ORsbps|TMDDBA|  OAuth authenticated
t Transfer: 1220 :      9|20:44:52.7954|ORsbps|TMDDBA|    user TMDDBA.
t Information: 1220 :   9|20:45:54.3577|N3KX8y|TMDDBA|GetUserProfile. Id: 30000
t Transfer: 1220 :      9|20:45:54.3577|N3KX8y|TMDDBA|GetCurrentUser..
t Transfer: 1220 :      9|20:45:54.3577|N3KX8y|TMDDBA|  OAuth authenticated
t Transfer: 1220 :      9|20:45:54.3577|N3KX8y|TMDDBA|    user TMDDBA.
t Information: 1220 :   9|20:46:55.7015|43GGmv|TMDDBA|GetUserProfile. Id: 30000
t Transfer: 1220 :      9|20:46:55.7015|43GGmv|TMDDBA|GetCurrentUser..
t Transfer: 1220 :      9|20:46:55.7015|43GGmv|TMDDBA|  OAuth authenticated
t Transfer: 1220 :      9|20:46:55.7015|43GGmv|TMDDBA|    user TMDDBA.
t Transfer: 1220 :      9|20:47:13.1702|jY_iBH|TMDDBA|OAuth: /api/v3/search/workflow?_dc=1585684032989
t Transfer: 1220 :      9|20:47:13.1702|jY_iBH|TMDDBA|GetCurrentUser..
t Transfer: 1220 :      9|20:47:13.1702|jY_iBH|TMDDBA|  OAuth authenticated
t Transfer: 1220 :      9|20:47:13.1702|jY_iBH|TMDDBA|    user TMDDBA.
t Verbose: 1220 :       9|20:47:13.1702|jY_iBH|TMDDBA|OAuth. User logged in: TMDDBA
t Information: 1220 :   9|20:47:13.1702|jY_iBH|TMDDBA|V3Api.SearchWorkflows
t Information: 1220 :   9|20:47:13.1702|jY_iBH|TMDDBA|V3Api.SearchGeneric
t Transfer: 1220 :      9|20:47:13.1702|jY_iBH|TMDDBA|GetCurrentUser..
t Transfer: 1220 :      9|20:47:13.1702|jY_iBH|TMDDBA|  OAuth authenticated
t Transfer: 1220 :      9|20:47:13.1702|jY_iBH|TMDDBA|    user TMDDBA.
t Information: 1220 :   9|20:47:13.1702|jY_iBH|TMDDBA|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('31/03/2020','DD/MM/YYYY')   and  j.cmb_stat not in (15,18,23)    AND j.J_CLI_CODE in ('03BO' , '03GD' , '03GO' , '03HA' , '03JO' , '03LI' , '03NB' , '03NM' , '03NO' , '03OR' , '03SB' , '03SC' , '03SE' , '03SG' , '03SK' , '03SM' , '03SN' , '03SS' , '03SY' , '03UP' , '03VA' , '03VB' , '03VL' , '03VT' , '3+ES' , '3PD' , '3PLV' , 'AECHD' , 'AECSD' , 'AL' , 'AMAY' , 'AMC' , 'ATP' , 'CENT' , 'CS' , 'CTCB' , 'CTCE' , 'DAVI' , 'DMA' , 'DMF' , 'DMY' , 'DTV' , 'EST' , 'EUROSPORT' , 'HDC1' , 'HDP1' , 'HDP2' , 'HUB' , 'KNL2' , 'KNVA' , 'LMH' , 'LNT' , 'MBNS' , 'MED' , 'MM' , 'MTG' , 'NAA' , 'NICK' , 'NVA' , 'OSP' , 'PBOY' , 'PMS' , 'PPL' , 'PSP' , 'Play' , 'RTR' , 'SFP1' , 'SFP2' , 'SPG' , 'SPTV' , 'T3LT' , 'T3LV' , 'T6LT' , 'T6LV' , 'T8LT' , 'TECHM' , 'TMD' , 'TV10' , 'TV1A' , 'TV1B' , 'TV1C' , 'TV1D' , 'TV1E' , 'TV1F' , 'TV1K' , 'TV1N' , 'TV1P' , 'TV1S' , 'TV2S' , 'TV3D' , 'TV3N' , 'TV3S' , 'TV5L' , 'TV6E' , 'TV6H' , 'TV6N' , 'TV6S' , 'TV8' , 'TVAE' , 'TVDP' , 'TVPB' , 'TVPU' , 'TVSL' , 'V1G' , 'V1TZ' , 'V3H' , 'V4N' , 'VEC' , 'VEPL' , 'VEPO' , 'VEXE' , 'VEXR' , 'VHIS' , 'VHPO' , 'VNC' , 'VNE' , 'VNH' , 'VNHD' , 'VNPO' , 'VODD' , 'VODE' , 'VODF' , 'VODN' , 'VODS' , 'VS2' , 'VS3' , 'VSAT' , 'VSD' , 'VSD2' , 'VSE' , 'VSG' , 'VSHD' , 'VSS' , 'WCIU' , 'YLE TV1' , 'ZTVS') 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|20:47:13.1702|jY_iBH|TMDDBA|    jobs returned 14, searched in 00:00:00.0128287
t Information: 1220 :   9|20:47:13.1702|jY_iBH|TMDDBA|TechReports is not found. ID: 96.
t Information: 1220 :   9|20:47:13.1702|jY_iBH|TMDDBA|TechReports is not found. ID: 41.
t Information: 1220 :   9|20:47:13.1702|jY_iBH|TMDDBA|TechReports is not found. ID: 1633.
t Information: 1220 :   9|20:47:13.1702|jY_iBH|TMDDBA|TechReports is not found. ID: 1300.
t Information: 1220 :   9|20:47:13.1702|jY_iBH|TMDDBA|TechReports is not found. ID: 116.
t Information: 1220 :   9|20:47:13.1702|jY_iBH|TMDDBA|TechReports is not found. ID: 673.
t Information: 1220 :   9|20:47:13.1702|jY_iBH|TMDDBA|TechReports is not found. ID: 1301.
t Information: 1220 :   9|20:47:13.1702|jY_iBH|TMDDBA|    tasks returned 14, searched in 00:00:00.0202317
t Verbose: 1220 :       9|20:47:13.1702|jY_iBH|TMDDBA|imfx v3 API took 0.040s '/api/v3/search/workflow?_dc=1585684032989'
t Transfer: 1220 :      9|20:47:13.3733|lL8_bX|TMDDBA|OAuth: /api/user-preferences?_dc=1585684033192
t Transfer: 1220 :      9|20:47:13.3733|lL8_bX|TMDDBA|GetCurrentUser..
t Transfer: 1220 :      9|20:47:13.3733|lL8_bX|TMDDBA|  OAuth authenticated
t Transfer: 1220 :      9|20:47:13.3733|lL8_bX|TMDDBA|    user TMDDBA.
t Verbose: 1220 :       9|20:47:13.3733|lL8_bX|TMDDBA|OAuth. User logged in: TMDDBA
t Verbose: 1220 :       9|20:47:13.3733|lL8_bX|TMDDBA|StoreUserDataByKeys..
t Transfer: 1220 :      9|20:47:13.3733|lL8_bX|TMDDBA|GetCurrentUser..
t Transfer: 1220 :      9|20:47:13.3733|lL8_bX|TMDDBA|  OAuth authenticated
t Transfer: 1220 :      9|20:47:13.3733|lL8_bX|TMDDBA|    user TMDDBA.
t Verbose: 1220 :       9|20:47:13.3733|lL8_bX|TMDDBA|imfx v3 API took 0.013s '/api/user-preferences?_dc=1585684033192'
t Transfer: 1220 :      9|20:47:15.6077|krp~uQ|TMDDBA|OAuth: /api/v3/task/componentqc/108993?_dc=1585684035548
t Transfer: 1220 :      9|20:47:15.6077|krp~uQ|TMDDBA|GetCurrentUser..
t Transfer: 1220 :      9|20:47:15.6077|krp~uQ|TMDDBA|  OAuth authenticated
t Transfer: 1220 :      9|20:47:15.6077|krp~uQ|TMDDBA|    user TMDDBA.
t Verbose: 1220 :       9|20:47:15.6077|krp~uQ|TMDDBA|OAuth. User logged in: TMDDBA
t Information: 1220 :   9|20:47:15.6077|krp~uQ|TMDDBA|V3Api. GetComponentQc task: 108993
t Information: 1220 :   9|20:47:15.8108|krp~uQ|TMDDBA|SubtitleQcTask. LoadFromDb got Job 108992 and Subtitles 2.
t Verbose: 1220 :       9|20:47:15.8108|krp~uQ|TMDDBA|imfx v3 API took 0.022s '/api/v3/task/componentqc/108993?_dc=1585684035548'
t Information: 1220 :   9|20:47:15.8108|krp~uQ|TMDDBA|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/108993?_dc=1585684035548
  System.Web.Http.Routing.HttpRoute
t Transfer: 1220 :      9|20:47:20.2796|tXcgWZ|TMDDBA|OAuth: /api/v3/search/workflow?_dc=1585684040232
t Transfer: 1220 :      9|20:47:20.2796|tXcgWZ|TMDDBA|GetCurrentUser..
t Transfer: 1220 :      9|20:47:20.2796|tXcgWZ|TMDDBA|  OAuth authenticated
t Transfer: 1220 :      9|20:47:20.2796|tXcgWZ|TMDDBA|    user TMDDBA.
t Verbose: 1220 :       9|20:47:20.2796|tXcgWZ|TMDDBA|OAuth. User logged in: TMDDBA
t Information: 1220 :   9|20:47:20.2796|tXcgWZ|TMDDBA|V3Api.SearchWorkflows
t Information: 1220 :   9|20:47:20.2796|tXcgWZ|TMDDBA|V3Api.SearchGeneric
t Transfer: 1220 :      9|20:47:20.2796|tXcgWZ|TMDDBA|GetCurrentUser..
t Transfer: 1220 :      9|20:47:20.2796|tXcgWZ|TMDDBA|  OAuth authenticated
t Transfer: 1220 :      9|20:47:20.2796|tXcgWZ|TMDDBA|    user TMDDBA.
t Information: 1220 :   9|20:47:20.4826|tXcgWZ|TMDDBA|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=108992   AND j.J_CLI_CODE in ('03BO' , '03GD' , '03GO' , '03HA' , '03JO' , '03LI' , '03NB' , '03NM' , '03NO' , '03OR' , '03SB' , '03SC' , '03SE' , '03SG' , '03SK' , '03SM' , '03SN' , '03SS' , '03SY' , '03UP' , '03VA' , '03VB' , '03VL' , '03VT' , '3+ES' , '3PD' , '3PLV' , 'AECHD' , 'AECSD' , 'AL' , 'AMAY' , 'AMC' , 'ATP' , 'CENT' , 'CS' , 'CTCB' , 'CTCE' , 'DAVI' , 'DMA' , 'DMF' , 'DMY' , 'DTV' , 'EST' , 'EUROSPORT' , 'HDC1' , 'HDP1' , 'HDP2' , 'HUB' , 'KNL2' , 'KNVA' , 'LMH' , 'LNT' , 'MBNS' , 'MED' , 'MM' , 'MTG' , 'NAA' , 'NICK' , 'NVA' , 'OSP' , 'PBOY' , 'PMS' , 'PPL' , 'PSP' , 'Play' , 'RTR' , 'SFP1' , 'SFP2' , 'SPG' , 'SPTV' , 'T3LT' , 'T3LV' , 'T6LT' , 'T6LV' , 'T8LT' , 'TECHM' , 'TMD' , 'TV10' , 'TV1A' , 'TV1B' , 'TV1C' , 'TV1D' , 'TV1E' , 'TV1F' , 'TV1K' , 'TV1N' , 'TV1P' , 'TV1S' , 'TV2S' , 'TV3D' , 'TV3N' , 'TV3S' , 'TV5L' , 'TV6E' , 'TV6H' , 'TV6N' , 'TV6S' , 'TV8' , 'TVAE' , 'TVDP' , 'TVPB' , 'TVPU' , 'TVSL' , 'V1G' , 'V1TZ' , 'V3H' , 'V4N' , 'VEC' , 'VEPL' , 'VEPO' , 'VEXE' , 'VEXR' , 'VHIS' , 'VHPO' , 'VNC' , 'VNE' , 'VNH' , 'VNHD' , 'VNPO' , 'VODD' , 'VODE' , 'VODF' , 'VODN' , 'VODS' , 'VS2' , 'VS3' , 'VSAT' , 'VSD' , 'VSD2' , 'VSE' , 'VSG' , 'VSHD' , 'VSS' , 'WCIU' , 'YLE TV1' , 'ZTVS') 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|20:47:20.4826|tXcgWZ|TMDDBA|    jobs returned 1, searched in 00:00:00.0048287
t Information: 1220 :   9|20:47:20.4826|tXcgWZ|TMDDBA|    tasks returned 1, searched in 00:00:00.0032104
t Verbose: 1220 :       9|20:47:20.4826|tXcgWZ|TMDDBA|imfx v3 API took 0.019s '/api/v3/search/workflow?_dc=1585684040232'
t Information: 1220 :   9|20:47:57.2483|E7pveQ|TMDDBA|GetUserProfile. Id: 30000
t Transfer: 1220 :      9|20:47:57.2483|E7pveQ|TMDDBA|GetCurrentUser..
t Transfer: 1220 :      9|20:47:57.2483|E7pveQ|TMDDBA|  OAuth authenticated
t Transfer: 1220 :      9|20:47:57.2483|E7pveQ|TMDDBA|    user TMDDBA.
t Information: 1220 :   9|20:48:58.5921|Cq3M1m|TMDDBA|GetUserProfile. Id: 30000
t Transfer: 1220 :      9|20:48:58.5921|Cq3M1m|TMDDBA|GetCurrentUser..
t Transfer: 1220 :      9|20:48:58.5921|Cq3M1m|TMDDBA|  OAuth authenticated
t Transfer: 1220 :      9|20:48:58.5921|Cq3M1m|TMDDBA|    user TMDDBA.
t Information: 1220 :   9|20:50:00.3576|wDDvRY|TMDDBA|GetUserProfile. Id: 30000
t Transfer: 1220 :      9|20:50:00.3576|wDDvRY|TMDDBA|GetCurrentUser..
t Transfer: 1220 :      9|20:50:00.3576|wDDvRY|TMDDBA|  OAuth authenticated
t Transfer: 1220 :      9|20:50:00.3576|wDDvRY|TMDDBA|    user TMDDBA.
t Information: 1220 :   9|20:51:01.7014|IzYtwh|TMDDBA|GetUserProfile. Id: 30000
t Transfer: 1220 :      9|20:51:01.7014|IzYtwh|TMDDBA|GetCurrentUser..
t Transfer: 1220 :      9|20:51:01.7014|IzYtwh|TMDDBA|  OAuth authenticated
t Transfer: 1220 :      9|20:51:01.7014|IzYtwh|TMDDBA|    user TMDDBA.
t Information: 1220 :   9|20:52:02.0295|WVDAq1|TMDDBA|GetUserProfile. Id: 30000
t Transfer: 1220 :      9|20:52:02.0295|WVDAq1|TMDDBA|GetCurrentUser..
t Transfer: 1220 :      9|20:52:02.0295|WVDAq1|TMDDBA|  OAuth authenticated
t Transfer: 1220 :      9|20:52:02.0295|WVDAq1|TMDDBA|    user TMDDBA.
t Information: 1220 :   9|20:53:03.5764|Vqrf2X|TMDDBA|GetUserProfile. Id: 30000
t Transfer: 1220 :      9|20:53:03.5764|Vqrf2X|TMDDBA|GetCurrentUser..
t Transfer: 1220 :      9|20:53:03.5764|Vqrf2X|TMDDBA|  OAuth authenticated
t Transfer: 1220 :      9|20:53:03.5764|Vqrf2X|TMDDBA|    user TMDDBA.
t Transfer: 1220 :      9|20:53:54.5608|QLqEeW|TMDDBA|OAuth: /api/v3/config/servicexml/types?_dc=1585684434498
t Transfer: 1220 :      9|20:53:54.5608|QLqEeW|TMDDBA|GetCurrentUser..
t Transfer: 1220 :      9|20:53:54.5608|QLqEeW|TMDDBA|  OAuth authenticated
t Transfer: 1220 :      9|20:53:54.5608|QLqEeW|TMDDBA|    user TMDDBA.
t Verbose: 1220 :       9|20:53:54.5608|QLqEeW|TMDDBA|OAuth. User logged in: TMDDBA
t Verbose: 1220 :       9|20:53:54.5608|QLqEeW|TMDDBA|imfx v3 API took 0.005s '/api/v3/config/servicexml/types?_dc=1585684434498'
t Transfer: 1220 :      9|20:53:54.7639|ULjtBh|TMDDBA|OAuth: /api/settings/groups/?_dc=1585684434598
t Transfer: 1220 :      9|20:53:54.7639|ULjtBh|TMDDBA|GetCurrentUser..
t Transfer: 1220 :      9|20:53:54.7639|ULjtBh|TMDDBA|  OAuth authenticated
t Transfer: 1220 :      9|20:53:54.7639|ULjtBh|TMDDBA|    user TMDDBA.
t Verbose: 1220 :       9|20:53:54.7639|ULjtBh|TMDDBA|OAuth. User logged in: TMDDBA
t Verbose: 1220 :       9|20:53:54.7639|ULjtBh|TMDDBA|imfx v3 API took 0.017s '/api/settings/groups/?_dc=1585684434598'
t Transfer: 1220 :      9|20:53:56.5920|sAUBnH|TMDDBA|OAuth: /api/v3/config-tables?_dc=1585684436504
t Transfer: 1220 :      9|20:53:56.5920|sAUBnH|TMDDBA|GetCurrentUser..
t Transfer: 1220 :      9|20:53:56.5920|sAUBnH|TMDDBA|  OAuth authenticated
t Transfer: 1220 :      9|20:53:56.5920|sAUBnH|TMDDBA|    user TMDDBA.
t Verbose: 1220 :       9|20:53:56.5920|sAUBnH|TMDDBA|OAuth. User logged in: TMDDBA
t Verbose: 1220 :       9|20:53:56.5920|sAUBnH|TMDDBA|imfx v3 API took 0.010s '/api/v3/config-tables?_dc=1585684436504'
t Information: 1220 :   9|20:54:02.0764|RjNOqD|TMDDBA|GetConfig TM_CFG_CUST_MED_STAT_TYPE.
t Verbose: 1220 :       9|20:54:02.2795|RjNOqD|TMDDBA|imfx v3 API took 0.109s '/api/v3/config-table/TM_CFG_CUST_MED_STAT_TYPE?_dc=1585684441969'
t Information: 1220 :   9|20:54:02.2795|KTmIiN|TMDDBA|GetConfig TM_CFG_CUST_MED_STAT_TYPE.
t Verbose: 1220 :       9|20:54:02.2795|KTmIiN|TMDDBA|imfx v3 API took 0.003s '/api/v3/config-table/TM_CFG_CUST_MED_STAT_TYPE?_dc=1585684442134'
t Information: 1220 :   9|20:54:04.5139|4PHZJA|TMDDBA|GetUserProfile. Id: 30000
t Transfer: 1220 :      9|20:54:04.5139|4PHZJA|TMDDBA|GetCurrentUser..
t Transfer: 1220 :      9|20:54:04.5139|4PHZJA|TMDDBA|  OAuth authenticated
t Transfer: 1220 :      9|20:54:04.5139|4PHZJA|TMDDBA|    user TMDDBA.
t Information: 1220 :   9|20:55:05.4514|8G0i2U|TMDDBA|GetUserProfile. Id: 30000
t Transfer: 1220 :      9|20:55:05.4514|8G0i2U|TMDDBA|GetCurrentUser..
t Transfer: 1220 :      9|20:55:05.4514|8G0i2U|TMDDBA|  OAuth authenticated
t Transfer: 1220 :      9|20:55:05.4514|8G0i2U|TMDDBA|    user TMDDBA.
t Information: 1220 :   9|20:56:07.2014|x~9TCP|TMDDBA|GetUserProfile. Id: 30000
t Transfer: 1220 :      9|20:56:07.2014|x~9TCP|TMDDBA|GetCurrentUser..
t Transfer: 1220 :      9|20:56:07.2014|x~9TCP|TMDDBA|  OAuth authenticated
t Transfer: 1220 :      9|20:56:07.2014|x~9TCP|TMDDBA|    user TMDDBA.
t Information: 1220 :   9|20:57:09.1545|VKwi8E|TMDDBA|GetUserProfile. Id: 30000
t Transfer: 1220 :      9|20:57:09.1545|VKwi8E|TMDDBA|GetCurrentUser..
t Transfer: 1220 :      9|20:57:09.1545|VKwi8E|TMDDBA|  OAuth authenticated
t Transfer: 1220 :      9|20:57:09.1545|VKwi8E|TMDDBA|    user TMDDBA.
t Information: 1220 :   9|20:57:28.2483|||OrabitWatcherBasic. Disposing.
t Information: 1220 :   9|20:57:28.2483|||OrabitWatcherBasic. Disposed.
t Information: 1220 :   9|20:57:28.2483|||==========================================================================
t Information: 1220 :   9|20:57:28.2483|||IMFX CORE SERVER APPLICATION END.