t Transfer: 1220 : 10|11:53:07.5818|mXvjM6||OAuth: /api/logout?_dc=1710849186648 t Transfer: 1220 : 10|11:53:07.5818|mXvjM6||GetCurrentUser.. t Transfer: 1220 : 10|11:53:07.5818|mXvjM6|| OAuth authenticated t Verbose: 1220 : 10|11:53:07.5818|mXvjM6|| uid claim is missing.. t Information: 1220 : 10|11:53:07.5818|mXvjM6||OAuth. AutoLogin no Windows identity type WindowsIdentity t Transfer: 1220 : 10|11:53:07.8004|Rq34xA||GetAppInfo. DB: TMDDEMO. Install mode: . Auth types: Native, PublicApiKey t Information: 1220 : 10|11:53:08.0192|gJf4PL||GetCache. t Information: 1220 : 10|11:53:08.0192|gJf4PL||GetCache. Found: C:\inetpub\wwwroot\imfxcore\VisualAssetsCache\108_2_PnqJC_.png t Information: 1220 : 10|11:53:08.0192|gJf4PL||GetCache. Data read: 154944 t Verbose: 1220 : 10|11:53:08.0192|gJf4PL||imfx v3 API took 0.067s '/api/v3/visual-asset/group/PnqJC_/2/image' t Transfer: 1220 : 10|11:58:56.7646|MdWZdJ||GetAppInfo. DB: TMDDEMO. Install mode: . Auth types: Native, PublicApiKey t Verbose: 1220 : 10|11:58:57.1708|S8566~||Oauth validating.. t Verbose: 1220 : 10|11:58:57.1708|S8566~||GrantResourceOwnerCredentials. t Verbose: 1220 : 10|11:58:57.3740|S8566~||LoginUser. lucas.boechat, login type OAuth, encrypt password True t Information: 1220 : 10|11:58:57.3740|S8566~||TryLoginUser. lucas.boechat, login type OAuth, check password True, check hash False, encrypt password True, load user data False t Information: 1220 : 10|11:58:57.5837|S8566~||TryLoginUser. Password is incorrect. t Verbose: 1220 : 10|11:58:57.5837|S8566~||GrantResourceOwnerCredentials. Try login finished. Logged: False t Verbose: 1220 : 10|11:59:00.4336|066tMd||Oauth validating.. t Verbose: 1220 : 10|11:59:00.4336|066tMd||GrantResourceOwnerCredentials. t Verbose: 1220 : 10|11:59:00.4336|066tMd||LoginUser. lucas.boechat, login type OAuth, encrypt password True t Information: 1220 : 10|11:59:00.4336|066tMd||TryLoginUser. lucas.boechat, login type OAuth, check password True, check hash False, encrypt password True, load user data False t Information: 1220 : 10|11:59:00.4336|066tMd||TryLoginUser. Password is incorrect. t Verbose: 1220 : 10|11:59:00.4336|066tMd||GrantResourceOwnerCredentials. Try login finished. Logged: False t Verbose: 1220 : 10|11:59:02.2645|Nk4D8d||Oauth validating.. t Verbose: 1220 : 10|11:59:02.2645|Nk4D8d||GrantResourceOwnerCredentials. t Verbose: 1220 : 10|11:59:02.2645|Nk4D8d||LoginUser. lucas.boechat, login type OAuth, encrypt password True t Information: 1220 : 10|11:59:02.2645|Nk4D8d||TryLoginUser. lucas.boechat, login type OAuth, check password True, check hash False, encrypt password True, load user data False t Information: 1220 : 10|11:59:02.2645|Nk4D8d||TryLoginUser. Password is incorrect. t Verbose: 1220 : 10|11:59:02.2645|Nk4D8d||GrantResourceOwnerCredentials. Try login finished. Logged: False t Verbose: 1220 : 10|12:00:06.9418|jPTLgl||Oauth validating.. t Verbose: 1220 : 10|12:00:06.9418|jPTLgl||GrantResourceOwnerCredentials. t Information: 1220 : 10|12:00:06.9418|jPTLgl||Login denied - too many failed attempts t Information: 1220 : 10|12:12:57.6993|WEd0Ga||System.NullReferenceException: Object reference not set to an instance of an object. at iMfxServerCore.mediabrowser.Page_Load(Object sender, EventArgs e) in C:\TeamCity\buildAgent\work\405c64e443a47d83\Server\iMfxServerCore\mediabrowser.aspx.cs:line 49 t Information: 1220 : 10|12:12:57.6993|WEd0Ga||IMFX CORE ERROR: System.Web.HttpUnhandledException (0x80004005): Exception of type 'System.Web.HttpUnhandledException' was thrown. ---> System.NullReferenceException: Object reference not set to an instance of an object. at iMfxServerCore.mediabrowser.Page_Load(Object sender, EventArgs e) in C:\TeamCity\buildAgent\work\405c64e443a47d83\Server\iMfxServerCore\mediabrowser.aspx.cs:line 877 at System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) at System.Web.UI.Control.OnLoad(EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) at System.Web.UI.Page.HandleError(Exception e) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) at System.Web.UI.Page.ProcessRequest() at System.Web.UI.Page.ProcessRequestWithNoAssert(HttpContext context) at System.Web.UI.Page.ProcessRequest(HttpContext context) at ASP.mediabrowser_aspx.ProcessRequest(HttpContext context) at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() at System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step) at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) t Information: 1220 : 10|12:12:57.6993|DNEwpX||GetCaptionsForWeb. Filename: . SubFolder . Device . Format . Timecode format Pal. Media ID 0. Last Modified 1/1/0001 12:00:00 AM t Information: 1220 : 10|12:12:57.6993|DNEwpX||GetCaptionsForWeb. Exception: System.ApplicationException: Storage device is missing: at iMfxServerCommon.WebCaptions.GetCaptionsForWeb(String& outPath) t Information: 1220 : 10|12:13:03.8860|wiEMK7||IMFX CORE ERROR: System.Web.HttpCompileException (0x80004005): C:\inetpub\wwwroot\imfxcore\xplayer.aspx(120): error CS0103: The name 'Globals' does not exist in the current context at System.Web.Compilation.BuildManager.CompileWebFile(VirtualPath virtualPath) at System.Web.Compilation.BuildManager.GetVPathBuildResultInternal(VirtualPath virtualPath, Boolean noBuild, Boolean allowCrossApp, Boolean allowBuildInPrecompile, Boolean throwIfNotFound, Boolean ensureIsUpToDate) at System.Web.Compilation.BuildManager.GetVPathBuildResultWithNoAssert(HttpContext context, VirtualPath virtualPath, Boolean noBuild, Boolean allowCrossApp, Boolean allowBuildInPrecompile, Boolean throwIfNotFound, Boolean ensureIsUpToDate) at System.Web.Compilation.BuildManager.GetVirtualPathObjectFactory(VirtualPath virtualPath, HttpContext context, Boolean allowCrossApp, Boolean throwIfNotFound) at System.Web.Compilation.BuildManager.CreateInstanceFromVirtualPath(VirtualPath virtualPath, Type requiredBaseType, HttpContext context, Boolean allowCrossApp) at System.Web.UI.PageHandlerFactory.GetHandlerHelper(HttpContext context, String requestType, VirtualPath virtualPath, String physicalPath) at System.Web.UI.PageHandlerFactory.GetHandler(HttpContext context, String requestType, String virtualPath, String path) at System.Web.HttpApplication.MaterializeHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() at System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step) at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) t Information: 1220 : 10|13:24:31.1568|NB5Kyx||GetCaptionsForWeb. Filename: . SubFolder . Device . Format . Timecode format Pal. Media ID 0. Last Modified 1/1/0001 12:00:00 AM t Information: 1220 : 10|13:24:31.1568|NB5Kyx||GetCaptionsForWeb. Exception: System.ApplicationException: Storage device is missing: at iMfxServerCommon.WebCaptions.GetCaptionsForWeb(String& outPath) t Information: 1220 : 10|13:24:58.1362|VWTiWJ||IMFX CORE ERROR: System.Web.HttpCompileException (0x80004005): C:\inetpub\wwwroot\imfxcore\xplayer.aspx(120): error CS0103: The name 'Globals' does not exist in the current context at System.Web.Compilation.BuildManager.CompileWebFile(VirtualPath virtualPath) at System.Web.Compilation.BuildManager.GetVPathBuildResultInternal(VirtualPath virtualPath, Boolean noBuild, Boolean allowCrossApp, Boolean allowBuildInPrecompile, Boolean throwIfNotFound, Boolean ensureIsUpToDate) at System.Web.Compilation.BuildManager.GetVPathBuildResultWithNoAssert(HttpContext context, VirtualPath virtualPath, Boolean noBuild, Boolean allowCrossApp, Boolean allowBuildInPrecompile, Boolean throwIfNotFound, Boolean ensureIsUpToDate) at System.Web.Compilation.BuildManager.GetVirtualPathObjectFactory(VirtualPath virtualPath, HttpContext context, Boolean allowCrossApp, Boolean throwIfNotFound) at System.Web.Compilation.BuildManager.CreateInstanceFromVirtualPath(VirtualPath virtualPath, Type requiredBaseType, HttpContext context, Boolean allowCrossApp) at System.Web.UI.PageHandlerFactory.GetHandlerHelper(HttpContext context, String requestType, VirtualPath virtualPath, String physicalPath) at System.Web.UI.PageHandlerFactory.GetHandler(HttpContext context, String requestType, String virtualPath, String path) at System.Web.HttpApplication.MaterializeHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() at System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step) at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) t Information: 1220 : 10|13:24:58.7456|ObbIde||IMFX CORE ERROR: System.Web.HttpCompileException (0x80004005): C:\inetpub\wwwroot\imfxcore\xplayer.aspx(120): error CS0103: The name 'Globals' does not exist in the current context at System.Web.Compilation.BuildManager.PostProcessFoundBuildResult(BuildResult result, Boolean keyFromVPP, VirtualPath virtualPath) at System.Web.Compilation.BuildManager.GetBuildResultFromCacheInternal(String cacheKey, Boolean keyFromVPP, VirtualPath virtualPath, Int64 hashCode, Boolean ensureIsUpToDate) at System.Web.Compilation.BuildManager.GetVPathBuildResultFromCacheInternal(VirtualPath virtualPath, Boolean ensureIsUpToDate) at System.Web.Compilation.BuildManager.GetVPathBuildResultInternal(VirtualPath virtualPath, Boolean noBuild, Boolean allowCrossApp, Boolean allowBuildInPrecompile, Boolean throwIfNotFound, Boolean ensureIsUpToDate) at System.Web.Compilation.BuildManager.GetVPathBuildResultWithNoAssert(HttpContext context, VirtualPath virtualPath, Boolean noBuild, Boolean allowCrossApp, Boolean allowBuildInPrecompile, Boolean throwIfNotFound, Boolean ensureIsUpToDate) at System.Web.Compilation.BuildManager.GetVirtualPathObjectFactory(VirtualPath virtualPath, HttpContext context, Boolean allowCrossApp, Boolean throwIfNotFound) at System.Web.Compilation.BuildManager.CreateInstanceFromVirtualPath(VirtualPath virtualPath, Type requiredBaseType, HttpContext context, Boolean allowCrossApp) at System.Web.UI.PageHandlerFactory.GetHandlerHelper(HttpContext context, String requestType, VirtualPath virtualPath, String physicalPath) at System.Web.UI.PageHandlerFactory.GetHandler(HttpContext context, String requestType, String virtualPath, String path) at System.Web.HttpApplication.MaterializeHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() at System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step) at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) t Information: 1220 : 10|13:24:59.9843|dbvYRJ||System.NullReferenceException: Object reference not set to an instance of an object. at iMfxServerCore.mediabrowser.Page_Load(Object sender, EventArgs e) in C:\TeamCity\buildAgent\work\405c64e443a47d83\Server\iMfxServerCore\mediabrowser.aspx.cs:line 49 t Information: 1220 : 10|13:24:59.9843|dbvYRJ||IMFX CORE ERROR: System.Web.HttpUnhandledException (0x80004005): Exception of type 'System.Web.HttpUnhandledException' was thrown. ---> System.NullReferenceException: Object reference not set to an instance of an object. at iMfxServerCore.mediabrowser.Page_Load(Object sender, EventArgs e) in C:\TeamCity\buildAgent\work\405c64e443a47d83\Server\iMfxServerCore\mediabrowser.aspx.cs:line 877 at System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) at System.Web.UI.Control.OnLoad(EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) at System.Web.UI.Page.HandleError(Exception e) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) at System.Web.UI.Page.ProcessRequest() at System.Web.UI.Page.ProcessRequestWithNoAssert(HttpContext context) at System.Web.UI.Page.ProcessRequest(HttpContext context) at ASP.mediabrowser_aspx.ProcessRequest(HttpContext context) at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() at System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step) at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) t Transfer: 1220 : 10|14:00:04.3864|lHkz2R||GetAppInfo. DB: TMDDEMO. Install mode: . Auth types: Native, PublicApiKey t Information: 1220 : 10|14:00:04.8485|umEh4u||GetCache. t Information: 1220 : 10|14:00:04.8485|umEh4u||GetCache. Found: C:\inetpub\wwwroot\imfxcore\VisualAssetsCache\108_2_PnqJC_.png t Information: 1220 : 10|14:00:04.8639|umEh4u||GetCache. Data read: 154944 t Verbose: 1220 : 10|14:00:04.8639|umEh4u||imfx v3 API took 0.006s '/api/v3/visual-asset/group/PnqJC_/2/image' t Verbose: 1220 : 10|14:00:05.9567|5gD~PV||Oauth validating.. t Verbose: 1220 : 10|14:00:05.9567|5gD~PV||GrantResourceOwnerCredentials. t Verbose: 1220 : 10|14:00:05.9567|5gD~PV||LoginUser. tmddba, login type OAuth, encrypt password True t Information: 1220 : 10|14:00:05.9567|5gD~PV||TryLoginUser. tmddba, login type OAuth, check password True, check hash False, encrypt password True, load user data False t Information: 1220 : 10|14:00:06.1754|5gD~PV|| oauth token 00000000-0000-0000-0000-000000000000 t Information: 1220 : 10|14:00:06.1754|5gD~PV||TryLoginUser. Logged in.. t Information: 1220 : 10|14:00:06.1754|5gD~PV||GetPasswordPolicy. WARNING: Policy not found for system Imediaflex. Validation disabled. t Verbose: 1220 : 10|14:00:06.1754|5gD~PV||LoginUser. Adding history. User Id 1, result TMDDBA, host 192.168.127.6 t Verbose: 1220 : 10|14:00:06.1754|5gD~PV||GrantResourceOwnerCredentials. Try login finished. Logged: True t Transfer: 1220 : 10|14:00:06.3941|hXviL4|TMDDBA|OAuth: /api/user-group-preferences?keys=defaultSearchColumnsMedia,defaultSearchColumnsVersion,defaultSearchColumnsSimple,defaultSearchColumnsTitle,defaultSearchMisrDetailsMediaColumns,versionCreationSettings,associate.advanced_search.version.setups,associate.advanced_search.media.setups,associate.wfrise.setups,supplier_portal.advanced_search.version.setups,media_portal.del_history.advanced.search_criteria,supplier_portal.version_complete.setups,logoImage,uploadSettings,helpdeskUrl,customLabels,googleMapsApiSettings&globals=isDebugMode,htmlplayerhotkeys,versionCreationSettings,associate.advanced_search.version.setups,associate.advanced_search.media.setups,associate.wfrise.setups,supplier_portal.advanced_search.version.setups,media_portal.del_history.advanced.search_criteria,helpdeskUrl,customLabels&_dc=1710856806316 t Transfer: 1220 : 10|14:00:06.3941|hXviL4|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|14:00:06.3941|hXviL4|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|14:00:06.3941|hXviL4|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|14:00:06.3941|hXviL4|TMDDBA|OAuth. User logged in: TMDDBA t Transfer: 1220 : 10|14:00:06.3941|hXviL4|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|14:00:06.3941|hXviL4|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|14:00:06.3941|hXviL4|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|14:00:06.3941|hXviL4|TMDDBA|imfx v3 API took 0.050s '/api/user-group-preferences?keys=defaultSearchColumnsMedia,defaultSearchColumnsVersion,defaultSearchColumnsSimple,defaultSearchColumnsTitle,defaultSearchMisrDetailsMediaColumns,versionCreationSettings,associate.advanced_search.version.setups,associate.advanced_search.media.setups,associate.wfrise.setups,supplier_portal.advanced_search.version.setups,media_portal.del_history.advanced.search_criteria,supplier_portal.version_complete.setups,logoImage,uploadSettings,helpdeskUrl,customLabels,googleMapsApiSettings&globals=isDebugMode,htmlplayerhotkeys,versionCreationSettings,associate.advanced_search.version.setups,associate.advanced_search.media.setups,associate.wfrise.setups,supplier_portal.advanced_search.version.setups,media_portal.del_history.advanced.search_criteria,helpdeskUrl,customLabels&_dc=1710856806316' t Transfer: 1220 : 10|14:00:07.0618|_c7tNc|TMDDBA|OAuth: /api/user-preferences?keys=personal_settings;basket;default_page;color_schema;media.basket.data;defaultSearch;workflow_queues_actions;workflow_queues_settings&_dc=1710856806418 t Transfer: 1220 : 10|14:00:07.0618|_c7tNc|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|14:00:07.0618|_c7tNc|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|14:00:07.0618|_c7tNc|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|14:00:07.0618|_c7tNc|TMDDBA|OAuth. User logged in: TMDDBA t Information: 1220 : 10|14:00:07.0618|_c7tNc|TMDDBA|GetUserDataByKeys: personal_settings;basket;default_page;color_schema;media.basket.data;defaultSearch;workflow_queues_actions;workflow_queues_settings t Transfer: 1220 : 10|14:00:07.0618|_c7tNc|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|14:00:07.0618|_c7tNc|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|14:00:07.0618|_c7tNc|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|14:00:07.0618|_c7tNc|TMDDBA|imfx v3 API took 0.035s '/api/user-preferences?keys=personal_settings;basket;default_page;color_schema;media.basket.data;defaultSearch;workflow_queues_actions;workflow_queues_settings&_dc=1710856806418' t Information: 1220 : 10|14:00:07.0618|o74s5t|TMDDBA|GetUserProfile. Id: 0 t Transfer: 1220 : 10|14:00:07.0618|o74s5t|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|14:00:07.0618|o74s5t|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|14:00:07.0618|o74s5t|TMDDBA| user TMDDBA. t Transfer: 1220 : 10|14:00:07.0618|eeZW1x|TMDDBA|OAuth: /api/settings/group/0?_dc=1710856806607 t Transfer: 1220 : 10|14:00:07.0618|eeZW1x|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|14:00:07.0618|eeZW1x|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|14:00:07.0618|eeZW1x|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|14:00:07.0618|eeZW1x|TMDDBA|OAuth. User logged in: TMDDBA t Transfer: 1220 : 10|14:00:07.0618|PUtjao|TMDDBA|OAuth: /api/settings/group/0?_dc=1710856806631 t Transfer: 1220 : 10|14:00:07.0618|PUtjao|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|14:00:07.0618|PUtjao|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|14:00:07.0618|PUtjao|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|14:00:07.0618|PUtjao|TMDDBA|OAuth. User logged in: TMDDBA t Transfer: 1220 : 10|14:00:07.0618|G5L9GB|TMDDBA|OAuth: /api/settings/user/uploadSettings?_dc=1710856806613 t Transfer: 1220 : 10|14:00:07.0618|G5L9GB|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|14:00:07.0618|G5L9GB|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|14:00:07.0618|G5L9GB|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|14:00:07.0618|G5L9GB|TMDDBA|OAuth. User logged in: TMDDBA t Transfer: 1220 : 10|14:00:07.0618|f2wfPQ|TMDDBA|OAuth: /api/settings/user/mainMenuSettings?_dc=1710856806608 t Transfer: 1220 : 10|14:00:07.0618|f2wfPQ|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|14:00:07.0618|f2wfPQ|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|14:00:07.0618|f2wfPQ|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|14:00:07.0618|f2wfPQ|TMDDBA|OAuth. User logged in: TMDDBA t Transfer: 1220 : 10|14:00:07.0618|J1Pcty|TMDDBA|OAuth: /api/settings/user/mainMenuSettings?_dc=1710856806633 t Transfer: 1220 : 10|14:00:07.0618|J1Pcty|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|14:00:07.0618|J1Pcty|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|14:00:07.0618|J1Pcty|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|14:00:07.0618|J1Pcty|TMDDBA|OAuth. User logged in: TMDDBA t Verbose: 1220 : 10|14:00:07.0618|eeZW1x|TMDDBA|imfx v3 API took 0.332s '/api/settings/group/0?_dc=1710856806607' t Transfer: 1220 : 10|14:00:07.2792|G5L9GB|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|14:00:07.2792|G5L9GB|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|14:00:07.2792|G5L9GB|TMDDBA| user TMDDBA. t Transfer: 1220 : 10|14:00:07.2792|xCVzKs|TMDDBA|OAuth: /api/lookups/MediaStatus?_dc=1710856806642 t Transfer: 1220 : 10|14:00:07.2792|xCVzKs|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|14:00:07.2792|xCVzKs|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|14:00:07.2792|xCVzKs|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|14:00:07.2792|xCVzKs|TMDDBA|OAuth. User logged in: TMDDBA t Transfer: 1220 : 10|14:00:07.2792|J1Pcty|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|14:00:07.2792|J1Pcty|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|14:00:07.2792|J1Pcty|TMDDBA| user TMDDBA. t Information: 1220 : 10|14:00:07.2792|qDbLMk||GetCache. t Information: 1220 : 10|14:00:07.2792|qDbLMk||GetCache. Found: C:\inetpub\wwwroot\imfxcore\VisualAssetsCache\106_0_PnqJC_.png t Information: 1220 : 10|14:00:07.2792|qDbLMk||GetCache. Data read: 0 t Verbose: 1220 : 10|14:00:07.2792|qDbLMk||imfx v3 API took 0.107s '/api/v3/visual-asset/group/PnqJC_/0/image' t Transfer: 1220 : 10|14:00:07.2792|f2wfPQ|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|14:00:07.2792|f2wfPQ|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|14:00:07.2792|f2wfPQ|TMDDBA| user TMDDBA. t Transfer: 1220 : 10|14:00:07.2792|Cr2KcI|TMDDBA|OAuth: /api/lookups/PgmStatus?_dc=1710856806643 t Transfer: 1220 : 10|14:00:07.2792|Cr2KcI|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|14:00:07.2792|Cr2KcI|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|14:00:07.2792|Cr2KcI|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|14:00:07.2792|Cr2KcI|TMDDBA|OAuth. User logged in: TMDDBA t Verbose: 1220 : 10|14:00:07.4916|xCVzKs|TMDDBA|imfx v3 API took 0.050s '/api/lookups/MediaStatus?_dc=1710856806642' t Verbose: 1220 : 10|14:00:07.4916|J1Pcty|TMDDBA|imfx v3 API took 0.219s '/api/settings/user/mainMenuSettings?_dc=1710856806633' t Verbose: 1220 : 10|14:00:07.4916|G5L9GB|TMDDBA|imfx v3 API took 0.320s '/api/settings/user/uploadSettings?_dc=1710856806613' t Transfer: 1220 : 10|14:00:07.4916|HfsuD2|TMDDBA|OAuth: /api/lookup/CustomVersionStatusTypes?_dc=1710856806644 t Transfer: 1220 : 10|14:00:07.4916|HfsuD2|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|14:00:07.4916|HfsuD2|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|14:00:07.4916|HfsuD2|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|14:00:07.4916|HfsuD2|TMDDBA|OAuth. User logged in: TMDDBA t Transfer: 1220 : 10|14:00:07.7103|xzF8C0|TMDDBA|OAuth: /api/lookup/CustomMediaStatusTypes?_dc=1710856806644 t Transfer: 1220 : 10|14:00:07.7103|xzF8C0|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|14:00:07.7103|xzF8C0|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|14:00:07.7103|xzF8C0|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|14:00:07.7103|xzF8C0|TMDDBA|OAuth. User logged in: TMDDBA t Transfer: 1220 : 10|14:00:07.7103|YmavuN|TMDDBA|OAuth: /api/lookup/CustomTitleStatusTypes?_dc=1710856806645 t Transfer: 1220 : 10|14:00:07.7103|YmavuN|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|14:00:07.7103|YmavuN|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|14:00:07.7103|YmavuN|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|14:00:07.7103|YmavuN|TMDDBA|OAuth. User logged in: TMDDBA t Verbose: 1220 : 10|14:00:07.7103|PUtjao|TMDDBA|imfx v3 API took 0.470s '/api/settings/group/0?_dc=1710856806631' t Verbose: 1220 : 10|14:00:07.7103|Cr2KcI|TMDDBA|imfx v3 API took 0.000s '/api/lookups/PgmStatus?_dc=1710856806643' t Verbose: 1220 : 10|14:00:07.7103|f2wfPQ|TMDDBA|imfx v3 API took 0.384s '/api/settings/user/mainMenuSettings?_dc=1710856806608' t Transfer: 1220 : 10|14:00:07.7103|DwjaD3|TMDDBA|OAuth: /api/settings/user/defaultHomePage?_dc=1710856806646 t Transfer: 1220 : 10|14:00:07.7103|DwjaD3|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|14:00:07.7103|DwjaD3|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|14:00:07.7103|DwjaD3|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|14:00:07.7103|DwjaD3|TMDDBA|OAuth. User logged in: TMDDBA t Transfer: 1220 : 10|14:00:07.9291|DwjaD3|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|14:00:07.9291|DwjaD3|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|14:00:07.9291|DwjaD3|TMDDBA| user TMDDBA. t Information: 1220 : 10|14:00:07.9291|ggj4UZ||GetCache. t Information: 1220 : 10|14:00:07.9291|ggj4UZ||GetCache. Found: C:\inetpub\wwwroot\imfxcore\VisualAssetsCache\107_1_PnqJC_.png t Information: 1220 : 10|14:00:07.9291|ggj4UZ||GetCache. Data read: 0 t Verbose: 1220 : 10|14:00:07.9291|ggj4UZ||imfx v3 API took 0.141s '/api/v3/visual-asset/group/PnqJC_/1/image' t Verbose: 1220 : 10|14:00:07.9291|xzF8C0|TMDDBA|imfx v3 API took 0.203s '/api/lookup/CustomMediaStatusTypes?_dc=1710856806644' t Verbose: 1220 : 10|14:00:07.9291|HfsuD2|TMDDBA|imfx v3 API took 0.215s '/api/lookup/CustomVersionStatusTypes?_dc=1710856806644' t Verbose: 1220 : 10|14:00:07.9291|DwjaD3|TMDDBA|imfx v3 API took 0.089s '/api/settings/user/defaultHomePage?_dc=1710856806646' t Verbose: 1220 : 10|14:00:07.9291|YmavuN|TMDDBA|imfx v3 API took 0.072s '/api/lookup/CustomTitleStatusTypes?_dc=1710856806645' t Transfer: 1220 : 10|14:00:08.1478|6w0ZON|TMDDBA|OAuth: /api/settings/user/consumer?_dc=1710856808130 t Transfer: 1220 : 10|14:00:08.1478|6w0ZON|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|14:00:08.1478|6w0ZON|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|14:00:08.1478|6w0ZON|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|14:00:08.1478|6w0ZON|TMDDBA|OAuth. User logged in: TMDDBA t Transfer: 1220 : 10|14:00:08.1478|6w0ZON|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|14:00:08.1478|6w0ZON|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|14:00:08.1478|6w0ZON|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|14:00:08.1478|6w0ZON|TMDDBA|imfx v3 API took 0.004s '/api/settings/user/consumer?_dc=1710856808130' t Transfer: 1220 : 10|14:00:08.3509|Wo~VRZ|TMDDBA|OAuth: /api/user-preferences?keys=consumer.recent.data&_dc=1710856808176 t Transfer: 1220 : 10|14:00:08.3509|Wo~VRZ|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|14:00:08.3509|Wo~VRZ|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|14:00:08.3509|Wo~VRZ|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|14:00:08.3509|Wo~VRZ|TMDDBA|OAuth. User logged in: TMDDBA t Information: 1220 : 10|14:00:08.3509|Wo~VRZ|TMDDBA|GetUserDataByKeys: consumer.recent.data t Transfer: 1220 : 10|14:00:08.3509|Wo~VRZ|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|14:00:08.3509|Wo~VRZ|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|14:00:08.3509|Wo~VRZ|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|14:00:08.3509|Wo~VRZ|TMDDBA|imfx v3 API took 0.009s '/api/user-preferences?keys=consumer.recent.data&_dc=1710856808176' t Transfer: 1220 : 10|14:00:08.3509|HHyf7g|TMDDBA|OAuth: /api/settings/user/defaultSearch?_dc=1710856808260 t Transfer: 1220 : 10|14:00:08.3509|HHyf7g|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|14:00:08.3509|HHyf7g|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|14:00:08.3509|HHyf7g|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|14:00:08.3509|HHyf7g|TMDDBA|OAuth. User logged in: TMDDBA t Transfer: 1220 : 10|14:00:08.3509|ZgSoEX|TMDDBA|OAuth: /api/settings/user/startSearch?_dc=1710856808261 t Transfer: 1220 : 10|14:00:08.3509|ZgSoEX|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|14:00:08.3509|ZgSoEX|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|14:00:08.3509|ZgSoEX|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|14:00:08.3509|ZgSoEX|TMDDBA|OAuth. User logged in: TMDDBA t Transfer: 1220 : 10|14:00:08.3509|HHyf7g|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|14:00:08.3509|HHyf7g|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|14:00:08.3509|HHyf7g|TMDDBA| user TMDDBA. t Transfer: 1220 : 10|14:00:08.3509|ZgSoEX|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|14:00:08.3509|ZgSoEX|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|14:00:08.3509|ZgSoEX|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|14:00:08.3509|HHyf7g|TMDDBA|imfx v3 API took 0.007s '/api/settings/user/defaultSearch?_dc=1710856808260' t Verbose: 1220 : 10|14:00:08.3509|ZgSoEX|TMDDBA|imfx v3 API took 0.004s '/api/settings/user/startSearch?_dc=1710856808261' t Transfer: 1220 : 10|14:00:08.3509|KsWglC|TMDDBA|OAuth: /api/user-preferences?keys=consumer.recent.data&_dc=1710856808333 t Transfer: 1220 : 10|14:00:08.3509|KsWglC|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|14:00:08.3509|KsWglC|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|14:00:08.3509|KsWglC|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|14:00:08.3509|KsWglC|TMDDBA|OAuth. User logged in: TMDDBA t Information: 1220 : 10|14:00:08.3509|KsWglC|TMDDBA|GetUserDataByKeys: consumer.recent.data t Transfer: 1220 : 10|14:00:08.3509|KsWglC|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|14:00:08.3509|KsWglC|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|14:00:08.3509|KsWglC|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|14:00:08.3509|KsWglC|TMDDBA|imfx v3 API took 0.006s '/api/user-preferences?keys=consumer.recent.data&_dc=1710856808333' t Information: 1220 : 10|14:00:08.3509|bRRNoy||GetCache. t Information: 1220 : 10|14:00:08.3509|bRRNoy||GetCache. Found: C:\inetpub\wwwroot\imfxcore\VisualAssetsCache\109_3_PnqJC_.png t Information: 1220 : 10|14:00:08.3509|bRRNoy||GetCache. Data read: 154944 t Verbose: 1220 : 10|14:00:08.3665|bRRNoy||imfx v3 API took 0.006s '/api/v3/visual-asset/group/PnqJC_/3/image' t Transfer: 1220 : 10|14:00:10.7034|4BFAoC|TMDDBA|OAuth: /api/v3/config/servicexml/types?_dc=1710856810608 t Transfer: 1220 : 10|14:00:10.7034|4BFAoC|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|14:00:10.7034|4BFAoC|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|14:00:10.7034|4BFAoC|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|14:00:10.7034|4BFAoC|TMDDBA|OAuth. User logged in: TMDDBA t Verbose: 1220 : 10|14:00:10.7034|4BFAoC|TMDDBA|imfx v3 API took 0.010s '/api/v3/config/servicexml/types?_dc=1710856810608' t Transfer: 1220 : 10|14:00:10.7034|bjtjZf|TMDDBA|OAuth: /api/settings/groups/?_dc=1710856810667 t Transfer: 1220 : 10|14:00:10.7034|bjtjZf|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|14:00:10.7034|bjtjZf|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|14:00:10.7034|bjtjZf|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|14:00:10.7034|bjtjZf|TMDDBA|OAuth. User logged in: TMDDBA t Verbose: 1220 : 10|14:00:10.7034|bjtjZf|TMDDBA|imfx v3 API took 0.023s '/api/settings/groups/?_dc=1710856810667' t Transfer: 1220 : 10|14:00:14.9962|mJiUFW|TMDDBA|OAuth: /api/v3/config/users?showDisabled=true&_dc=1710856814987 t Transfer: 1220 : 10|14:00:14.9962|mJiUFW|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|14:00:14.9962|mJiUFW|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|14:00:14.9962|mJiUFW|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|14:00:14.9962|mJiUFW|TMDDBA|OAuth. User logged in: TMDDBA t Information: 1220 : 10|14:00:14.9962|mJiUFW|TMDDBA|GetUsersFiltered t Verbose: 1220 : 10|14:00:15.8243|mJiUFW|TMDDBA|imfx v3 API took 0.678s '/api/v3/config/users?showDisabled=true&_dc=1710856814987' t Transfer: 1220 : 10|14:00:20.6390|8Ca2j2|TMDDBA|OAuth: /api/lookups/Departments?_dc=1710856820265 t Transfer: 1220 : 10|14:00:20.6390|8Ca2j2|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|14:00:20.6390|8Ca2j2|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|14:00:20.6390|8Ca2j2|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|14:00:20.6390|8Ca2j2|TMDDBA|OAuth. User logged in: TMDDBA t Verbose: 1220 : 10|14:00:20.6546|8Ca2j2|TMDDBA|imfx v3 API took 0.000s '/api/lookups/Departments?_dc=1710856820265' t Transfer: 1220 : 10|14:00:20.6546|H94J51|TMDDBA|OAuth: /api/settings/groups/?_dc=1710856820275 t Transfer: 1220 : 10|14:00:20.6546|H94J51|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|14:00:20.6546|H94J51|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|14:00:20.6546|H94J51|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|14:00:20.6546|H94J51|TMDDBA|OAuth. User logged in: TMDDBA t Transfer: 1220 : 10|14:00:20.6546|KtslaW|TMDDBA|OAuth: /api/lookups/Devices?_dc=1710856820266 t Transfer: 1220 : 10|14:00:20.6546|KtslaW|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|14:00:20.6546|KtslaW|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|14:00:20.6546|KtslaW|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|14:00:20.6546|KtslaW|TMDDBA|OAuth. User logged in: TMDDBA t Transfer: 1220 : 10|14:00:20.6546|GuP2VH|TMDDBA|OAuth: /api/v3/config/user-groups/channels?_dc=1710856820269 t Transfer: 1220 : 10|14:00:20.6546|GuP2VH|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|14:00:20.6546|GuP2VH|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|14:00:20.6546|GuP2VH|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|14:00:20.6546|GuP2VH|TMDDBA|OAuth. User logged in: TMDDBA t Verbose: 1220 : 10|14:00:20.6546|H94J51|TMDDBA|imfx v3 API took 0.006s '/api/settings/groups/?_dc=1710856820275' t Verbose: 1220 : 10|14:00:20.6546|KtslaW|TMDDBA|imfx v3 API took 0.000s '/api/lookups/Devices?_dc=1710856820266' t Information: 1220 : 10|14:00:20.6546|NHIE2u|TMDDBA|v3.GetCustomUiOptions t Transfer: 1220 : 10|14:00:20.6546|jbSQaN|TMDDBA|OAuth: /api/v3/config/user/1285?_dc=1710856820274 t Transfer: 1220 : 10|14:00:20.6546|jbSQaN|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|14:00:20.6546|jbSQaN|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|14:00:20.6546|jbSQaN|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|14:00:20.6546|jbSQaN|TMDDBA|OAuth. User logged in: TMDDBA t Information: 1220 : 10|14:00:20.6546|jbSQaN|TMDDBA|GetUserById 1285 t Verbose: 1220 : 10|14:00:20.6546|GuP2VH|TMDDBA|imfx v3 API took 0.122s '/api/v3/config/user-groups/channels?_dc=1710856820269' t Verbose: 1220 : 10|14:00:20.6546|NHIE2u|TMDDBA|imfx v3 API took 0.239s '/api/v3/customuioptions?_dc=1710856820267' t Information: 1220 : 10|14:00:21.6859|jbSQaN|TMDDBA|GetUserDbaMode t Information: 1220 : 10|14:00:21.6859|jbSQaN|TMDDBA|GetUserOracleStatus t Information: 1220 : 10|14:00:21.8890|jbSQaN|TMDDBA|InitializeReportGenerator. Output Directory: t Information: 1220 : 10|14:00:21.8890|jbSQaN|TMDDBA|InitializeReportGenerator. Exception: System.ArgumentException: Path cannot be the empty string or all whitespace. at System.IO.Directory.CreateDirectory(String path) at TMD.ReportEngine.ReportGenerator.SetDestinationDirectory(String Destination) at TMD.ReportEngine.ReportGenerator.Initialize(String cnnString, String destination) at iMfxServerCore.Classes.ReportsImplementation.Initialize(ReportGenerator repGen, String cnnStr) in C:\TeamCity\buildAgent\work\405c64e443a47d83\Server\iMfxServerCore\Classes\ReportsImplementation.cs:line 300 t Information: 1220 : 10|14:00:21.8890|jbSQaN|TMDDBA|Getting a list of reports for user id: 1285 t Information: 1220 : 10|14:00:21.8890|jbSQaN|TMDDBA|Found 3 Reports t Verbose: 1220 : 10|14:00:21.8890|jbSQaN|TMDDBA|imfx v3 API took 1.498s '/api/v3/config/user/1285?_dc=1710856820274' t Transfer: 1220 : 10|14:00:22.0921|4k_gC6|TMDDBA|OAuth: /api/lookup/locations/search/?_dc=1710856821944 t Transfer: 1220 : 10|14:00:22.0921|4k_gC6|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|14:00:22.0921|4k_gC6|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|14:00:22.0921|4k_gC6|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|14:00:22.0921|4k_gC6|TMDDBA|OAuth. User logged in: TMDDBA t Transfer: 1220 : 10|14:00:22.0921|4k_gC6|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|14:00:22.0921|4k_gC6|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|14:00:22.0921|4k_gC6|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|14:00:22.0921|4k_gC6|TMDDBA|imfx v3 API took 0.049s '/api/lookup/locations/search/?_dc=1710856821944' t Transfer: 1220 : 10|14:00:22.0921|R_j1U1|TMDDBA|OAuth: /api/lookup/locations/all?_dc=1710856821944 t Transfer: 1220 : 10|14:00:22.0921|R_j1U1|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|14:00:22.0921|R_j1U1|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|14:00:22.0921|R_j1U1|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|14:00:22.0921|R_j1U1|TMDDBA|OAuth. User logged in: TMDDBA t Transfer: 1220 : 10|14:00:22.0921|9NKykO|TMDDBA|OAuth: /api/v3/config/user/1285/customuioptions?_dc=1710856822066 t Transfer: 1220 : 10|14:00:22.0921|9NKykO|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 10|14:00:22.0921|9NKykO|TMDDBA| OAuth authenticated t Transfer: 1220 : 10|14:00:22.0921|9NKykO|TMDDBA| user TMDDBA. t Verbose: 1220 : 10|14:00:22.0921|9NKykO|TMDDBA|OAuth. User logged in: TMDDBA t Information: 1220 : 10|14:00:22.0921|9NKykO|TMDDBA|v3.GetUserCustomUiOptions t Verbose: 1220 : 10|14:00:22.0921|R_j1U1|TMDDBA|imfx v3 API took 0.012s '/api/lookup/locations/all?_dc=1710856821944' t Verbose: 1220 : 10|14:00:22.2953|9NKykO|TMDDBA|imfx v3 API took 0.036s '/api/v3/config/user/1285/customuioptions?_dc=1710856822066' t Transfer: 1220 : 10|15:09:41.7438|qRDJtE||GetAppInfo. DB: TMDDEMO. Install mode: . Auth types: Native, PublicApiKey t Verbose: 1220 : 10|15:09:41.7438|5Wjvu~||imfx v3 API took 0.005s '/api/v3/visual-asset/group/PnqJC_/2/image' t Verbose: 1220 : 10|15:10:39.8634|YlSqfv||Oauth validating.. t Verbose: 1220 : 10|15:10:39.8634|YlSqfv||GrantResourceOwnerCredentials. t Verbose: 1220 : 10|15:10:39.8634|YlSqfv||LoginUser. fullclient, login type OAuth, encrypt password True t Information: 1220 : 10|15:10:39.8634|YlSqfv||TryLoginUser. fullclient, login type OAuth, check password True, check hash False, encrypt password True, load user data False t Information: 1220 : 10|15:10:39.8634|YlSqfv||TryLoginUser. Password is incorrect. t Verbose: 1220 : 10|15:10:39.8634|YlSqfv||GrantResourceOwnerCredentials. Try login finished. Logged: False t Verbose: 1220 : 10|15:11:00.3780|WMN~dq||Oauth validating.. t Verbose: 1220 : 10|15:11:00.3780|WMN~dq||GrantResourceOwnerCredentials. t Verbose: 1220 : 10|15:11:00.3780|WMN~dq||LoginUser. lucasb, login type OAuth, encrypt password True t Information: 1220 : 10|15:11:00.3780|WMN~dq||TryLoginUser. lucasb, login type OAuth, check password True, check hash False, encrypt password True, load user data False t Information: 1220 : 10|15:11:00.3780|WMN~dq|| oauth token 00000000-0000-0000-0000-000000000000 t Information: 1220 : 10|15:11:00.3780|WMN~dq||TryLoginUser. Logged in.. t Verbose: 1220 : 10|15:11:00.3780|WMN~dq||LoginUser. Adding history. User Id 1285, result LUCASB, host 192.168.127.6 t Verbose: 1220 : 10|15:11:00.3780|WMN~dq||GrantResourceOwnerCredentials. Try login finished. Logged: True t Transfer: 1220 : 10|15:11:00.3780|qBms4d|LUCASB|OAuth: /api/user-group-preferences?keys=defaultSearchColumnsMedia,defaultSearchColumnsVersion,defaultSearchColumnsSimple,defaultSearchColumnsTitle,defaultSearchMisrDetailsMediaColumns,versionCreationSettings,associate.advanced_search.version.setups,associate.advanced_search.media.setups,associate.wfrise.setups,supplier_portal.advanced_search.version.setups,media_portal.del_history.advanced.search_criteria,supplier_portal.version_complete.setups,logoImage,uploadSettings,helpdeskUrl,customLabels,googleMapsApiSettings&globals=isDebugMode,htmlplayerhotkeys,versionCreationSettings,associate.advanced_search.version.setups,associate.advanced_search.media.setups,associate.wfrise.setups,supplier_portal.advanced_search.version.setups,media_portal.del_history.advanced.search_criteria,helpdeskUrl,customLabels&_dc=1710861060041 t Transfer: 1220 : 10|15:11:00.3780|qBms4d|LUCASB|GetCurrentUser.. t Transfer: 1220 : 10|15:11:00.3780|qBms4d|LUCASB| OAuth authenticated t Transfer: 1220 : 10|15:11:00.3780|qBms4d|LUCASB| user LUCASB. t Verbose: 1220 : 10|15:11:00.3780|qBms4d|LUCASB|OAuth. User logged in: LUCASB t Transfer: 1220 : 10|15:11:00.3780|qBms4d|LUCASB|GetCurrentUser.. t Transfer: 1220 : 10|15:11:00.3780|qBms4d|LUCASB| OAuth authenticated t Transfer: 1220 : 10|15:11:00.3780|qBms4d|LUCASB| user LUCASB. t Verbose: 1220 : 10|15:11:00.3780|qBms4d|LUCASB|imfx v3 API took 0.041s '/api/user-group-preferences?keys=defaultSearchColumnsMedia,defaultSearchColumnsVersion,defaultSearchColumnsSimple,defaultSearchColumnsTitle,defaultSearchMisrDetailsMediaColumns,versionCreationSettings,associate.advanced_search.version.setups,associate.advanced_search.media.setups,associate.wfrise.setups,supplier_portal.advanced_search.version.setups,media_portal.del_history.advanced.search_criteria,supplier_portal.version_complete.setups,logoImage,uploadSettings,helpdeskUrl,customLabels,googleMapsApiSettings&globals=isDebugMode,htmlplayerhotkeys,versionCreationSettings,associate.advanced_search.version.setups,associate.advanced_search.media.setups,associate.wfrise.setups,supplier_portal.advanced_search.version.setups,media_portal.del_history.advanced.search_criteria,helpdeskUrl,customLabels&_dc=1710861060041' t Transfer: 1220 : 10|15:11:00.5967|yp750H|LUCASB|OAuth: /api/user-preferences?keys=personal_settings;basket;default_page;color_schema;media.basket.data;defaultSearch;workflow_queues_actions;workflow_queues_settings&_dc=1710861060148 t Transfer: 1220 : 10|15:11:00.5967|yp750H|LUCASB|GetCurrentUser.. t Transfer: 1220 : 10|15:11:00.5967|yp750H|LUCASB| OAuth authenticated t Transfer: 1220 : 10|15:11:00.5967|yp750H|LUCASB| user LUCASB. t Verbose: 1220 : 10|15:11:00.5967|yp750H|LUCASB|OAuth. User logged in: LUCASB t Information: 1220 : 10|15:11:00.5967|yp750H|LUCASB|GetUserDataByKeys: personal_settings;basket;default_page;color_schema;media.basket.data;defaultSearch;workflow_queues_actions;workflow_queues_settings t Transfer: 1220 : 10|15:11:00.5967|yp750H|LUCASB|GetCurrentUser.. t Transfer: 1220 : 10|15:11:00.5967|yp750H|LUCASB| OAuth authenticated t Transfer: 1220 : 10|15:11:00.5967|yp750H|LUCASB| user LUCASB. t Verbose: 1220 : 10|15:11:00.5967|yp750H|LUCASB|imfx v3 API took 0.025s '/api/user-preferences?keys=personal_settings;basket;default_page;color_schema;media.basket.data;defaultSearch;workflow_queues_actions;workflow_queues_settings&_dc=1710861060148' t Information: 1220 : 10|15:11:00.5967|ma_26v|LUCASB|GetUserProfile. Id: 0 t Transfer: 1220 : 10|15:11:00.5967|ma_26v|LUCASB|GetCurrentUser.. t Transfer: 1220 : 10|15:11:00.5967|ma_26v|LUCASB| OAuth authenticated t Transfer: 1220 : 10|15:11:00.5967|ma_26v|LUCASB| user LUCASB. t Transfer: 1220 : 10|15:11:00.5967|UrA1m8|LUCASB|OAuth: /api/settings/group/0?_dc=1710861060330 t Transfer: 1220 : 10|15:11:00.5967|UrA1m8|LUCASB|GetCurrentUser.. t Transfer: 1220 : 10|15:11:00.5967|UrA1m8|LUCASB| OAuth authenticated t Transfer: 1220 : 10|15:11:00.5967|UrA1m8|LUCASB| user LUCASB. t Verbose: 1220 : 10|15:11:00.5967|UrA1m8|LUCASB|OAuth. User logged in: LUCASB t Verbose: 1220 : 10|15:11:00.8311|UrA1m8|LUCASB|imfx v3 API took 0.095s '/api/settings/group/0?_dc=1710861060330' t Transfer: 1220 : 10|15:11:00.8311|nFrpQZ|LUCASB|OAuth: /api/settings/user/uploadSettings?_dc=1710861060334 t Transfer: 1220 : 10|15:11:00.8311|nFrpQZ|LUCASB|GetCurrentUser.. t Transfer: 1220 : 10|15:11:00.8311|nFrpQZ|LUCASB| OAuth authenticated t Transfer: 1220 : 10|15:11:00.8311|nFrpQZ|LUCASB| user LUCASB. t Verbose: 1220 : 10|15:11:00.8467|nFrpQZ|LUCASB|OAuth. User logged in: LUCASB t Transfer: 1220 : 10|15:11:00.8467|nFrpQZ|LUCASB|GetCurrentUser.. t Transfer: 1220 : 10|15:11:00.8467|nFrpQZ|LUCASB| OAuth authenticated t Transfer: 1220 : 10|15:11:00.8467|nFrpQZ|LUCASB| user LUCASB. t Verbose: 1220 : 10|15:11:00.8467|nFrpQZ|LUCASB|imfx v3 API took 0.004s '/api/settings/user/uploadSettings?_dc=1710861060334' t Transfer: 1220 : 10|15:11:00.8467|cstzSY|LUCASB|OAuth: /api/settings/user/mainMenuSettings?_dc=1710861060350 t Transfer: 1220 : 10|15:11:00.8467|cstzSY|LUCASB|GetCurrentUser.. t Transfer: 1220 : 10|15:11:00.8467|cstzSY|LUCASB| OAuth authenticated t Transfer: 1220 : 10|15:11:00.8467|cstzSY|LUCASB| user LUCASB. t Verbose: 1220 : 10|15:11:00.8467|cstzSY|LUCASB|OAuth. User logged in: LUCASB t Transfer: 1220 : 10|15:11:00.8467|cstzSY|LUCASB|GetCurrentUser.. t Transfer: 1220 : 10|15:11:00.8467|cstzSY|LUCASB| OAuth authenticated t Transfer: 1220 : 10|15:11:00.8467|cstzSY|LUCASB| user LUCASB. t Transfer: 1220 : 10|15:11:00.8467|wlUz0S|LUCASB|OAuth: /api/settings/group/0?_dc=1710861060350 t Transfer: 1220 : 10|15:11:00.8467|wlUz0S|LUCASB|GetCurrentUser.. t Transfer: 1220 : 10|15:11:00.8467|wlUz0S|LUCASB| OAuth authenticated t Transfer: 1220 : 10|15:11:00.8467|wlUz0S|LUCASB| user LUCASB. t Verbose: 1220 : 10|15:11:00.8467|wlUz0S|LUCASB|OAuth. User logged in: LUCASB t Verbose: 1220 : 10|15:11:00.8467|cstzSY|LUCASB|imfx v3 API took 0.004s '/api/settings/user/mainMenuSettings?_dc=1710861060350' t Transfer: 1220 : 10|15:11:00.8467|3TlB35|LUCASB|OAuth: /api/settings/user/mainMenuSettings?_dc=1710861060330 t Transfer: 1220 : 10|15:11:00.8467|3TlB35|LUCASB|GetCurrentUser.. t Transfer: 1220 : 10|15:11:00.8624|3TlB35|LUCASB| OAuth authenticated t Transfer: 1220 : 10|15:11:00.8624|3TlB35|LUCASB| user LUCASB. t Verbose: 1220 : 10|15:11:00.8624|3TlB35|LUCASB|OAuth. User logged in: LUCASB t Transfer: 1220 : 10|15:11:00.8624|3TlB35|LUCASB|GetCurrentUser.. t Transfer: 1220 : 10|15:11:00.8624|3TlB35|LUCASB| OAuth authenticated t Transfer: 1220 : 10|15:11:00.8624|3TlB35|LUCASB| user LUCASB. t Verbose: 1220 : 10|15:11:00.8624|3TlB35|LUCASB|imfx v3 API took 0.005s '/api/settings/user/mainMenuSettings?_dc=1710861060330' t Transfer: 1220 : 10|15:11:00.8624|LTFTWm|LUCASB|OAuth: /api/lookups/MediaStatus?_dc=1710861060356 t Transfer: 1220 : 10|15:11:00.8624|LTFTWm|LUCASB|GetCurrentUser.. t Transfer: 1220 : 10|15:11:00.8624|LTFTWm|LUCASB| OAuth authenticated t Transfer: 1220 : 10|15:11:00.8624|LTFTWm|LUCASB| user LUCASB. t Verbose: 1220 : 10|15:11:00.8624|LTFTWm|LUCASB|OAuth. User logged in: LUCASB t Verbose: 1220 : 10|15:11:00.8624|LTFTWm|LUCASB|imfx v3 API took 0.000s '/api/lookups/MediaStatus?_dc=1710861060356' t Information: 1220 : 10|15:11:01.0811|foQe5p||GetCache. t Information: 1220 : 10|15:11:01.0811|foQe5p||GetCache. Found: C:\inetpub\wwwroot\imfxcore\VisualAssetsCache\106_0_PnqJC_.png t Information: 1220 : 10|15:11:01.0811|foQe5p||GetCache. Data read: 0 t Verbose: 1220 : 10|15:11:01.0811|foQe5p||imfx v3 API took 0.006s '/api/v3/visual-asset/group/PnqJC_/0/image' t Transfer: 1220 : 10|15:11:01.0811|m9P_T8|LUCASB|OAuth: /api/lookups/PgmStatus?_dc=1710861060356 t Transfer: 1220 : 10|15:11:01.0811|m9P_T8|LUCASB|GetCurrentUser.. t Transfer: 1220 : 10|15:11:01.0811|m9P_T8|LUCASB| OAuth authenticated t Transfer: 1220 : 10|15:11:01.0811|m9P_T8|LUCASB| user LUCASB. t Verbose: 1220 : 10|15:11:01.0811|m9P_T8|LUCASB|OAuth. User logged in: LUCASB t Verbose: 1220 : 10|15:11:01.0811|m9P_T8|LUCASB|imfx v3 API took 0.000s '/api/lookups/PgmStatus?_dc=1710861060356' t Verbose: 1220 : 10|15:11:01.0811|wlUz0S|LUCASB|imfx v3 API took 0.107s '/api/settings/group/0?_dc=1710861060350' t Transfer: 1220 : 10|15:11:01.0811|On827M|LUCASB|OAuth: /api/lookup/CustomMediaStatusTypes?_dc=1710861060357 t Transfer: 1220 : 10|15:11:01.0811|On827M|LUCASB|GetCurrentUser.. t Transfer: 1220 : 10|15:11:01.0811|On827M|LUCASB| OAuth authenticated t Transfer: 1220 : 10|15:11:01.0811|On827M|LUCASB| user LUCASB. t Verbose: 1220 : 10|15:11:01.0811|On827M|LUCASB|OAuth. User logged in: LUCASB t Verbose: 1220 : 10|15:11:01.0811|On827M|LUCASB|imfx v3 API took 0.004s '/api/lookup/CustomMediaStatusTypes?_dc=1710861060357' t Transfer: 1220 : 10|15:11:01.0811|SWriyJ|LUCASB|OAuth: /api/lookup/CustomVersionStatusTypes?_dc=1710861060357 t Transfer: 1220 : 10|15:11:01.0811|SWriyJ|LUCASB|GetCurrentUser.. t Transfer: 1220 : 10|15:11:01.0811|SWriyJ|LUCASB| OAuth authenticated t Transfer: 1220 : 10|15:11:01.0811|SWriyJ|LUCASB| user LUCASB. t Verbose: 1220 : 10|15:11:01.0811|SWriyJ|LUCASB|OAuth. User logged in: LUCASB t Verbose: 1220 : 10|15:11:01.0811|SWriyJ|LUCASB|imfx v3 API took 0.003s '/api/lookup/CustomVersionStatusTypes?_dc=1710861060357' t Transfer: 1220 : 10|15:11:01.0811|NcBmUy|LUCASB|OAuth: /api/lookup/CustomTitleStatusTypes?_dc=1710861060358 t Transfer: 1220 : 10|15:11:01.0811|NcBmUy|LUCASB|GetCurrentUser.. t Transfer: 1220 : 10|15:11:01.0811|NcBmUy|LUCASB| OAuth authenticated t Transfer: 1220 : 10|15:11:01.0811|NcBmUy|LUCASB| user LUCASB. t Verbose: 1220 : 10|15:11:01.0811|NcBmUy|LUCASB|OAuth. User logged in: LUCASB t Verbose: 1220 : 10|15:11:01.0811|NcBmUy|LUCASB|imfx v3 API took 0.003s '/api/lookup/CustomTitleStatusTypes?_dc=1710861060358' t Transfer: 1220 : 10|15:11:01.0811|KAM7Jd|LUCASB|OAuth: /api/settings/user/defaultHomePage?_dc=1710861060358 t Transfer: 1220 : 10|15:11:01.0811|KAM7Jd|LUCASB|GetCurrentUser.. t Transfer: 1220 : 10|15:11:01.0811|KAM7Jd|LUCASB| OAuth authenticated t Transfer: 1220 : 10|15:11:01.0811|KAM7Jd|LUCASB| user LUCASB. t Verbose: 1220 : 10|15:11:01.0811|KAM7Jd|LUCASB|OAuth. User logged in: LUCASB t Transfer: 1220 : 10|15:11:01.0811|KAM7Jd|LUCASB|GetCurrentUser.. t Transfer: 1220 : 10|15:11:01.0811|KAM7Jd|LUCASB| OAuth authenticated t Transfer: 1220 : 10|15:11:01.0811|KAM7Jd|LUCASB| user LUCASB. t Verbose: 1220 : 10|15:11:01.0811|KAM7Jd|LUCASB|imfx v3 API took 0.004s '/api/settings/user/defaultHomePage?_dc=1710861060358' t Information: 1220 : 10|15:11:01.0811|7IgeCs||GetCache. t Information: 1220 : 10|15:11:01.0811|7IgeCs||GetCache. Found: C:\inetpub\wwwroot\imfxcore\VisualAssetsCache\106_0_PnqJC_.png t Information: 1220 : 10|15:11:01.0811|7IgeCs||GetCache. Data read: 0 t Verbose: 1220 : 10|15:11:01.0811|7IgeCs||imfx v3 API took 0.003s '/api/v3/visual-asset/group/PnqJC_/0/image' t Transfer: 1220 : 10|15:11:01.7061|3V~cnG|LUCASB|OAuth: /api/settings/user/consumer?_dc=1710861061257 t Transfer: 1220 : 10|15:11:01.7061|3V~cnG|LUCASB|GetCurrentUser.. t Transfer: 1220 : 10|15:11:01.7061|3V~cnG|LUCASB| OAuth authenticated t Transfer: 1220 : 10|15:11:01.7061|3V~cnG|LUCASB| user LUCASB. t Verbose: 1220 : 10|15:11:01.7061|3V~cnG|LUCASB|OAuth. User logged in: LUCASB t Transfer: 1220 : 10|15:11:01.7061|3V~cnG|LUCASB|GetCurrentUser.. t Transfer: 1220 : 10|15:11:01.7061|3V~cnG|LUCASB| OAuth authenticated t Transfer: 1220 : 10|15:11:01.7061|3V~cnG|LUCASB| user LUCASB. t Verbose: 1220 : 10|15:11:01.7061|3V~cnG|LUCASB|imfx v3 API took 0.006s '/api/settings/user/consumer?_dc=1710861061257' t Transfer: 1220 : 10|15:11:01.7061|xJLu00|LUCASB|OAuth: /api/user-preferences?keys=consumer.recent.data&_dc=1710861061277 t Transfer: 1220 : 10|15:11:01.7061|xJLu00|LUCASB|GetCurrentUser.. t Transfer: 1220 : 10|15:11:01.7061|xJLu00|LUCASB| OAuth authenticated t Transfer: 1220 : 10|15:11:01.7061|xJLu00|LUCASB| user LUCASB. t Verbose: 1220 : 10|15:11:01.7061|xJLu00|LUCASB|OAuth. User logged in: LUCASB t Information: 1220 : 10|15:11:01.7061|xJLu00|LUCASB|GetUserDataByKeys: consumer.recent.data t Transfer: 1220 : 10|15:11:01.7061|xJLu00|LUCASB|GetCurrentUser.. t Transfer: 1220 : 10|15:11:01.7061|xJLu00|LUCASB| OAuth authenticated t Transfer: 1220 : 10|15:11:01.7061|xJLu00|LUCASB| user LUCASB. t Verbose: 1220 : 10|15:11:01.7061|xJLu00|LUCASB|imfx v3 API took 0.006s '/api/user-preferences?keys=consumer.recent.data&_dc=1710861061277' t Transfer: 1220 : 10|15:11:01.7061|vyq6HT|LUCASB|OAuth: /api/settings/user/defaultSearch?_dc=1710861061382 t Transfer: 1220 : 10|15:11:01.7061|vyq6HT|LUCASB|GetCurrentUser.. t Transfer: 1220 : 10|15:11:01.7061|vyq6HT|LUCASB| OAuth authenticated t Transfer: 1220 : 10|15:11:01.7061|vyq6HT|LUCASB| user LUCASB. t Verbose: 1220 : 10|15:11:01.7061|vyq6HT|LUCASB|OAuth. User logged in: LUCASB t Transfer: 1220 : 10|15:11:01.7061|vyq6HT|LUCASB|GetCurrentUser.. t Transfer: 1220 : 10|15:11:01.7061|vyq6HT|LUCASB| OAuth authenticated t Transfer: 1220 : 10|15:11:01.7061|vyq6HT|LUCASB| user LUCASB. t Verbose: 1220 : 10|15:11:01.7061|vyq6HT|LUCASB|imfx v3 API took 0.004s '/api/settings/user/defaultSearch?_dc=1710861061382' t Transfer: 1220 : 10|15:11:01.7061|d0fSGJ|LUCASB|OAuth: /api/settings/user/startSearch?_dc=1710861061382 t Transfer: 1220 : 10|15:11:01.7061|d0fSGJ|LUCASB|GetCurrentUser.. t Transfer: 1220 : 10|15:11:01.7061|d0fSGJ|LUCASB| OAuth authenticated t Transfer: 1220 : 10|15:11:01.7061|d0fSGJ|LUCASB| user LUCASB. t Verbose: 1220 : 10|15:11:01.7061|d0fSGJ|LUCASB|OAuth. User logged in: LUCASB t Transfer: 1220 : 10|15:11:01.7061|d0fSGJ|LUCASB|GetCurrentUser.. t Transfer: 1220 : 10|15:11:01.7061|d0fSGJ|LUCASB| OAuth authenticated t Transfer: 1220 : 10|15:11:01.7061|d0fSGJ|LUCASB| user LUCASB. t Verbose: 1220 : 10|15:11:01.7061|d0fSGJ|LUCASB|imfx v3 API took 0.004s '/api/settings/user/startSearch?_dc=1710861061382' t Transfer: 1220 : 10|15:11:01.9249|mHUVwq|LUCASB|OAuth: /api/user-preferences?keys=consumer.recent.data&_dc=1710861061497 t Transfer: 1220 : 10|15:11:01.9249|mHUVwq|LUCASB|GetCurrentUser.. t Transfer: 1220 : 10|15:11:01.9249|mHUVwq|LUCASB| OAuth authenticated t Transfer: 1220 : 10|15:11:01.9249|mHUVwq|LUCASB| user LUCASB. t Verbose: 1220 : 10|15:11:01.9249|mHUVwq|LUCASB|OAuth. User logged in: LUCASB t Information: 1220 : 10|15:11:01.9249|mHUVwq|LUCASB|GetUserDataByKeys: consumer.recent.data t Transfer: 1220 : 10|15:11:01.9249|mHUVwq|LUCASB|GetCurrentUser.. t Transfer: 1220 : 10|15:11:01.9249|mHUVwq|LUCASB| OAuth authenticated t Transfer: 1220 : 10|15:11:01.9249|mHUVwq|LUCASB| user LUCASB. t Verbose: 1220 : 10|15:11:01.9249|mHUVwq|LUCASB|imfx v3 API took 0.005s '/api/user-preferences?keys=consumer.recent.data&_dc=1710861061497' t Transfer: 1220 : 10|15:57:45.5782|hfaUlM|LUCASB|OAuth: /api/lookups/SearchSupportedOperators?_dc=1710863865155 t Transfer: 1220 : 10|15:57:45.5782|hfaUlM|LUCASB|GetCurrentUser.. t Transfer: 1220 : 10|15:57:45.5782|hfaUlM|LUCASB| OAuth authenticated t Transfer: 1220 : 10|15:57:45.5782|hfaUlM|LUCASB| user LUCASB. t Verbose: 1220 : 10|15:57:45.5782|hfaUlM|LUCASB|OAuth. User logged in: LUCASB t Transfer: 1220 : 10|15:57:45.5782|i912lK|LUCASB|OAuth: /api/view/searchinfo/Job?_dc=1710863865154 t Transfer: 1220 : 10|15:57:45.5782|i912lK|LUCASB|GetCurrentUser.. t Transfer: 1220 : 10|15:57:45.5782|i912lK|LUCASB| OAuth authenticated t Transfer: 1220 : 10|15:57:45.5782|i912lK|LUCASB| user LUCASB. t Verbose: 1220 : 10|15:57:45.5782|i912lK|LUCASB|OAuth. User logged in: LUCASB t Transfer: 1220 : 10|15:57:45.5782|qxM3xG|LUCASB|OAuth: /api/user-preferences?keys=adv.recent.searches.workflow&_dc=1710863865155 t Transfer: 1220 : 10|15:57:45.5782|qxM3xG|LUCASB|GetCurrentUser.. t Transfer: 1220 : 10|15:57:45.5782|qxM3xG|LUCASB| OAuth authenticated t Transfer: 1220 : 10|15:57:45.5782|qxM3xG|LUCASB| user LUCASB. t Verbose: 1220 : 10|15:57:45.5782|qxM3xG|LUCASB|OAuth. User logged in: LUCASB t Transfer: 1220 : 10|15:57:45.5782|3AX5EM|LUCASB|OAuth: /api/view/searches/Job?_dc=1710863865175 t Transfer: 1220 : 10|15:57:45.5782|3AX5EM|LUCASB|GetCurrentUser.. t Transfer: 1220 : 10|15:57:45.5782|3AX5EM|LUCASB| OAuth authenticated t Transfer: 1220 : 10|15:57:45.5782|3AX5EM|LUCASB| user LUCASB. t Verbose: 1220 : 10|15:57:45.5782|3AX5EM|LUCASB|OAuth. User logged in: LUCASB t Transfer: 1220 : 10|15:57:45.5782|KBiaeE|LUCASB|OAuth: /api/view/info/Job?lang=en-US&_dc=1710863865177 t Transfer: 1220 : 10|15:57:45.5782|KBiaeE|LUCASB|GetCurrentUser.. t Transfer: 1220 : 10|15:57:45.5782|KBiaeE|LUCASB| OAuth authenticated t Transfer: 1220 : 10|15:57:45.5782|KBiaeE|LUCASB| user LUCASB. t Verbose: 1220 : 10|15:57:45.5782|KBiaeE|LUCASB|OAuth. User logged in: LUCASB t Verbose: 1220 : 10|15:57:45.5782|hfaUlM|LUCASB|imfx v3 API took 0.000s '/api/lookups/SearchSupportedOperators?_dc=1710863865155' t Information: 1220 : 10|15:57:45.5782|qxM3xG|LUCASB|GetUserDataByKeys: adv.recent.searches.workflow t Transfer: 1220 : 10|15:57:45.5782|qxM3xG|LUCASB|GetCurrentUser.. t Transfer: 1220 : 10|15:57:45.5782|qxM3xG|LUCASB| OAuth authenticated t Transfer: 1220 : 10|15:57:45.5782|qxM3xG|LUCASB| user LUCASB. t Transfer: 1220 : 10|15:57:45.8302|xdUin1|LUCASB|OAuth: /api/lookup/job-schedule-nodes/search/?_dc=1710863865192 t Transfer: 1220 : 10|15:57:45.8302|xdUin1|LUCASB|GetCurrentUser.. t Transfer: 1220 : 10|15:57:45.8302|xdUin1|LUCASB| OAuth authenticated t Transfer: 1220 : 10|15:57:45.8302|xdUin1|LUCASB| user LUCASB. t Verbose: 1220 : 10|15:57:45.8302|xdUin1|LUCASB|OAuth. User logged in: LUCASB t Information: 1220 : 10|15:57:45.8302|i912lK|LUCASB|GetAdvSearchColumns. search type Job grid . t Verbose: 1220 : 10|15:57:45.8302|i912lK|LUCASB|imfx v3 API took 0.002s '/api/view/searchinfo/Job?_dc=1710863865154' t Information: 1220 : 10|15:57:45.8302|KBiaeE|LUCASB|GetGridViewBuilder. builder type Job. t Transfer: 1220 : 10|15:57:45.8302|KBiaeE|LUCASB|GetCurrentUser.. t Transfer: 1220 : 10|15:57:45.8302|KBiaeE|LUCASB| OAuth authenticated t Transfer: 1220 : 10|15:57:45.8302|KBiaeE|LUCASB| user LUCASB. t Verbose: 1220 : 10|15:57:45.8302|qxM3xG|LUCASB|imfx v3 API took 0.086s '/api/user-preferences?keys=adv.recent.searches.workflow&_dc=1710863865155' t Information: 1220 : 10|15:57:45.8302|3AX5EM|LUCASB|GetSavedSearchNames. search type Job. t Transfer: 1220 : 10|15:57:45.8302|3AX5EM|LUCASB|GetCurrentUser.. t Transfer: 1220 : 10|15:57:45.8302|3AX5EM|LUCASB| OAuth authenticated t Transfer: 1220 : 10|15:57:45.8302|3AX5EM|LUCASB| user LUCASB. t Information: 1220 : 10|15:57:45.8302|KBiaeE|LUCASB|UserGridView. LoadView. ID -2, Name Default. t Transfer: 1220 : 10|15:57:45.8302|KBiaeE|LUCASB|GetCurrentUser.. t Transfer: 1220 : 10|15:57:45.8302|KBiaeE|LUCASB| OAuth authenticated t Transfer: 1220 : 10|15:57:45.8302|KBiaeE|LUCASB| user LUCASB. t Transfer: 1220 : 10|15:57:45.8302|xdUin1|LUCASB|GetCurrentUser.. t Transfer: 1220 : 10|15:57:45.8302|xdUin1|LUCASB| OAuth authenticated t Transfer: 1220 : 10|15:57:45.8302|xdUin1|LUCASB| user LUCASB. t Transfer: 1220 : 10|15:57:45.8302|KBiaeE|LUCASB|GetCurrentUser.. t Transfer: 1220 : 10|15:57:45.8302|KBiaeE|LUCASB| OAuth authenticated t Transfer: 1220 : 10|15:57:45.8302|KBiaeE|LUCASB| user LUCASB. t Verbose: 1220 : 10|15:57:45.8302|3AX5EM|LUCASB|imfx v3 API took 0.117s '/api/view/searches/Job?_dc=1710863865175' t Verbose: 1220 : 10|15:57:45.8302|KBiaeE|LUCASB|imfx v3 API took 0.138s '/api/view/info/Job?lang=en-US&_dc=1710863865177' t Verbose: 1220 : 10|15:57:45.8302|xdUin1|LUCASB|imfx v3 API took 0.070s '/api/lookup/job-schedule-nodes/search/?_dc=1710863865192' t Transfer: 1220 : 10|15:57:51.5493|3G5mmA|LUCASB|OAuth: /api/view/searchinfo/task?_dc=1710863871072 t Transfer: 1220 : 10|15:57:51.5493|3G5mmA|LUCASB|GetCurrentUser.. t Transfer: 1220 : 10|15:57:51.5493|3G5mmA|LUCASB| OAuth authenticated t Transfer: 1220 : 10|15:57:51.7655|3G5mmA|LUCASB| user LUCASB. t Verbose: 1220 : 10|15:57:51.7655|3G5mmA|LUCASB|OAuth. User logged in: LUCASB t Information: 1220 : 10|15:57:51.7655|3G5mmA|LUCASB|GetAdvSearchColumns. search type Task grid . t Transfer: 1220 : 10|15:57:51.7655|u8_2cZ|LUCASB|OAuth: /api/user-preferences?keys=adv.recent.searches.tasks&_dc=1710863871072 t Transfer: 1220 : 10|15:57:51.7655|u8_2cZ|LUCASB|GetCurrentUser.. t Transfer: 1220 : 10|15:57:51.7665|u8_2cZ|LUCASB| OAuth authenticated t Transfer: 1220 : 10|15:57:51.7665|u8_2cZ|LUCASB| user LUCASB. t Verbose: 1220 : 10|15:57:51.7665|u8_2cZ|LUCASB|OAuth. User logged in: LUCASB t Verbose: 1220 : 10|15:57:51.7665|3G5mmA|LUCASB|imfx v3 API took 0.000s '/api/view/searchinfo/task?_dc=1710863871072' t Transfer: 1220 : 10|15:57:51.7665|n6t31i|LUCASB|OAuth: /api/view/searches/task?_dc=1710863871081 t Transfer: 1220 : 10|15:57:51.7665|n6t31i|LUCASB|GetCurrentUser.. t Transfer: 1220 : 10|15:57:51.7675|n6t31i|LUCASB| OAuth authenticated t Transfer: 1220 : 10|15:57:51.7675|n6t31i|LUCASB| user LUCASB. t Verbose: 1220 : 10|15:57:51.7675|n6t31i|LUCASB|OAuth. User logged in: LUCASB t Information: 1220 : 10|15:57:51.7685|u8_2cZ|LUCASB|GetUserDataByKeys: adv.recent.searches.tasks t Transfer: 1220 : 10|15:57:51.7685|u8_2cZ|LUCASB|GetCurrentUser.. t Transfer: 1220 : 10|15:57:51.7685|u8_2cZ|LUCASB| OAuth authenticated t Transfer: 1220 : 10|15:57:51.7685|u8_2cZ|LUCASB| user LUCASB. t Information: 1220 : 10|15:57:51.7685|n6t31i|LUCASB|GetSavedSearchNames. search type Task. t Transfer: 1220 : 10|15:57:51.7685|n6t31i|LUCASB|GetCurrentUser.. t Transfer: 1220 : 10|15:57:51.7695|n6t31i|LUCASB| OAuth authenticated t Transfer: 1220 : 10|15:57:51.7695|n6t31i|LUCASB| user LUCASB. t Transfer: 1220 : 10|15:57:51.7695|c70MX8|LUCASB|OAuth: /api/v3/search/task?_dc=1710863871115 t Transfer: 1220 : 10|15:57:51.7695|c70MX8|LUCASB|GetCurrentUser.. t Transfer: 1220 : 10|15:57:51.7695|c70MX8|LUCASB| OAuth authenticated t Transfer: 1220 : 10|15:57:51.7695|c70MX8|LUCASB| user LUCASB. t Verbose: 1220 : 10|15:57:51.7705|c70MX8|LUCASB|OAuth. User logged in: LUCASB t Transfer: 1220 : 10|15:57:51.7705|gcwfia|LUCASB|OAuth: /api/view/info/TaskGrid?lang=en-US&_dc=1710863871087 t Transfer: 1220 : 10|15:57:51.7705|gcwfia|LUCASB|GetCurrentUser.. t Transfer: 1220 : 10|15:57:51.7705|gcwfia|LUCASB| OAuth authenticated t Transfer: 1220 : 10|15:57:51.7705|gcwfia|LUCASB| user LUCASB. t Verbose: 1220 : 10|15:57:51.7705|gcwfia|LUCASB|OAuth. User logged in: LUCASB t Verbose: 1220 : 10|15:57:51.7715|u8_2cZ|LUCASB|imfx v3 API took 0.008s '/api/user-preferences?keys=adv.recent.searches.tasks&_dc=1710863871072' t Information: 1220 : 10|15:57:51.7715|gcwfia|LUCASB|GetGridViewBuilder. builder type TaskGrid. t Transfer: 1220 : 10|15:57:51.7715|gcwfia|LUCASB|GetCurrentUser.. t Transfer: 1220 : 10|15:57:51.7715|gcwfia|LUCASB| OAuth authenticated t Transfer: 1220 : 10|15:57:51.7715|gcwfia|LUCASB| user LUCASB. t Verbose: 1220 : 10|15:57:51.7715|n6t31i|LUCASB|imfx v3 API took 0.006s '/api/view/searches/task?_dc=1710863871081' t Information: 1220 : 10|15:57:51.7715|gcwfia|LUCASB|UserGridView. LoadView. ID -2, Name Default. t Transfer: 1220 : 10|15:57:51.7725|gcwfia|LUCASB|GetCurrentUser.. t Transfer: 1220 : 10|15:57:51.7725|gcwfia|LUCASB| OAuth authenticated t Transfer: 1220 : 10|15:57:51.7725|gcwfia|LUCASB| user LUCASB. t Transfer: 1220 : 10|15:57:51.7725|t89L0g|LUCASB|OAuth: /api/v3/search/task?_dc=1710863871116 t Transfer: 1220 : 10|15:57:51.7725|t89L0g|LUCASB|GetCurrentUser.. t Transfer: 1220 : 10|15:57:51.7725|t89L0g|LUCASB| OAuth authenticated t Transfer: 1220 : 10|15:57:51.7725|t89L0g|LUCASB| user LUCASB. t Verbose: 1220 : 10|15:57:51.7735|t89L0g|LUCASB|OAuth. User logged in: LUCASB t Transfer: 1220 : 10|15:57:51.7735|gcwfia|LUCASB|GetCurrentUser.. t Transfer: 1220 : 10|15:57:51.7735|gcwfia|LUCASB| OAuth authenticated t Transfer: 1220 : 10|15:57:51.7735|gcwfia|LUCASB| user LUCASB. t Verbose: 1220 : 10|15:57:51.7735|gcwfia|LUCASB|imfx v3 API took 0.016s '/api/view/info/TaskGrid?lang=en-US&_dc=1710863871087' t Transfer: 1220 : 10|15:57:51.7735|AHOMC5|LUCASB|OAuth: /api/v3/search/task?_dc=1710863871117 t Transfer: 1220 : 10|15:57:51.7745|AHOMC5|LUCASB|GetCurrentUser.. t Transfer: 1220 : 10|15:57:51.7745|AHOMC5|LUCASB| OAuth authenticated t Transfer: 1220 : 10|15:57:51.7745|AHOMC5|LUCASB| user LUCASB. t Verbose: 1220 : 10|15:57:51.7745|AHOMC5|LUCASB|OAuth. User logged in: LUCASB t Transfer: 1220 : 10|15:57:51.7745|mIZ9nZ|LUCASB|OAuth: /api/v3/search/task?_dc=1710863871116 t Transfer: 1220 : 10|15:57:51.7745|mIZ9nZ|LUCASB|GetCurrentUser.. t Transfer: 1220 : 10|15:57:51.7745|mIZ9nZ|LUCASB| OAuth authenticated t Transfer: 1220 : 10|15:57:51.7755|mIZ9nZ|LUCASB| user LUCASB. t Verbose: 1220 : 10|15:57:51.7755|mIZ9nZ|LUCASB|OAuth. User logged in: LUCASB t Transfer: 1220 : 10|15:57:51.7755|Mubm2A|LUCASB|OAuth: /api/v3/search/task?_dc=1710863871118 t Transfer: 1220 : 10|15:57:51.8085|Mubm2A|LUCASB|GetCurrentUser.. t Transfer: 1220 : 10|15:57:51.8085|Mubm2A|LUCASB| OAuth authenticated t Transfer: 1220 : 10|15:57:51.8085|Mubm2A|LUCASB| user LUCASB. t Verbose: 1220 : 10|15:57:51.8085|Mubm2A|LUCASB|OAuth. User logged in: LUCASB t Transfer: 1220 : 10|15:57:51.8085|5OYV9e|LUCASB|OAuth: /api/v3/search/task?_dc=1710863871124 t Transfer: 1220 : 10|15:57:51.8085|5OYV9e|LUCASB|GetCurrentUser.. t Transfer: 1220 : 10|15:57:51.8095|5OYV9e|LUCASB| OAuth authenticated t Transfer: 1220 : 10|15:57:51.8095|5OYV9e|LUCASB| user LUCASB. t Verbose: 1220 : 10|15:57:51.8095|5OYV9e|LUCASB|OAuth. User logged in: LUCASB t Information: 1220 : 10|15:57:51.8095|AHOMC5|LUCASB|V3Api.SearchTask t Information: 1220 : 10|15:57:51.8095|AHOMC5|LUCASB|V3Api.SearchGeneric t Information: 1220 : 10|15:57:51.8095|t89L0g|LUCASB|V3Api.SearchTask t Information: 1220 : 10|15:57:51.8095|t89L0g|LUCASB|V3Api.SearchGeneric t Information: 1220 : 10|15:57:51.8095|Mubm2A|LUCASB|V3Api.SearchTask t Information: 1220 : 10|15:57:51.8105|Mubm2A|LUCASB|V3Api.SearchGeneric t Information: 1220 : 10|15:57:51.8105|mIZ9nZ|LUCASB|V3Api.SearchTask t Information: 1220 : 10|15:57:51.8105|mIZ9nZ|LUCASB|V3Api.SearchGeneric t Information: 1220 : 10|15:57:51.8105|c70MX8|LUCASB|V3Api.SearchTask t Information: 1220 : 10|15:57:51.8105|c70MX8|LUCASB|V3Api.SearchGeneric t Transfer: 1220 : 10|15:57:51.8105|AHOMC5|LUCASB|GetCurrentUser.. t Transfer: 1220 : 10|15:57:51.8105|AHOMC5|LUCASB| OAuth authenticated t Transfer: 1220 : 10|15:57:51.8105|AHOMC5|LUCASB| user LUCASB. t Transfer: 1220 : 10|15:57:51.8115|t89L0g|LUCASB|GetCurrentUser.. t Transfer: 1220 : 10|15:57:51.8115|t89L0g|LUCASB| OAuth authenticated t Transfer: 1220 : 10|15:57:51.8115|t89L0g|LUCASB| user LUCASB. t Transfer: 1220 : 10|15:57:51.8115|Mubm2A|LUCASB|GetCurrentUser.. t Transfer: 1220 : 10|15:57:51.8115|Mubm2A|LUCASB| OAuth authenticated t Transfer: 1220 : 10|15:57:51.8115|Mubm2A|LUCASB| user LUCASB. t Transfer: 1220 : 10|15:57:51.8115|mIZ9nZ|LUCASB|GetCurrentUser.. t Transfer: 1220 : 10|15:57:51.8115|mIZ9nZ|LUCASB| OAuth authenticated t Transfer: 1220 : 10|15:57:51.8125|mIZ9nZ|LUCASB| user LUCASB. t Information: 1220 : 10|15:57:51.8125|5OYV9e|LUCASB|V3Api.SearchTask t Information: 1220 : 10|15:57:51.8125|5OYV9e|LUCASB|V3Api.SearchGeneric t Transfer: 1220 : 10|15:57:51.8125|c70MX8|LUCASB|GetCurrentUser.. t Transfer: 1220 : 10|15:57:51.8125|c70MX8|LUCASB| OAuth authenticated t Transfer: 1220 : 10|15:57:51.8125|c70MX8|LUCASB| user LUCASB. t Transfer: 1220 : 10|15:57:51.8125|5OYV9e|LUCASB|GetCurrentUser.. t Transfer: 1220 : 10|15:57:51.8135|5OYV9e|LUCASB| OAuth authenticated t Transfer: 1220 : 10|15:57:51.8135|5OYV9e|LUCASB| user LUCASB. t Information: 1220 : 10|15:57:52.0231|c70MX8|LUCASB|SearchTask SQL: select * from (select a.*, rownum rnum from ( select /*+ INDEX(j JB_CMBST_IDX) */ /*+ INDEX(j JB_CMBST_IDX) */ j.*, p.pname, mi.MIID1, mi.MIID2, mi.MIID3, mi.VERSIONID1, mi.VERSIONID2, mi.PROGID1, mi.PROGID2, mi.VERSION, u.USER_ID OP_NAME, nvl(j.tech_rptt_id, 0) TECH_REPORT_ID, case when tsk_type=57 then cast(i.DEV_DATA_FMT as varchar2(100)) else '' end TASK_MODE, jj.j_compl_by JOB_COMPL_BY FROM tm_mtask j join tm_mjob jj on jj.id = j.j_id left join tm_mjob_pset p on p.id = jj.j_sched_indx left outer join TM_USERS u on u.id = j.assn_opid left join (select tsk_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 version) VERSION from tm_mis m, tm_mtsk_it i where m.id = i.mi_id and i.src_dest in (2, 3) group by tsk_id) mi on mi.tsk_id = j.id left join tm_mtsk_it i on i.tsk_id = j.id and i.src_dest = 4 and i.item_idx = 1 where 1=1 AND J_FAILURE_RESOLVED = 0 and ( j.area_id=421 OR j.area_id=501 OR j.assn_opid=662 OR j.assn_opid=1245 OR j.assn_opid=442 OR j.area_id=622 OR j.area_id=623 OR j.area_id=624 OR j.assn_opid=702 OR j.assn_opid=422 OR j.assn_opid=515 OR j.area_id=481 OR j.area_id=807 OR j.area_id=561 OR j.area_id=625 OR j.area_id=745 OR j.area_id=826 OR j.area_id=827 OR j.assn_opid=1065 OR j.assn_opid=922 OR j.assn_opid=923 OR j.assn_opid=1086 OR j.assn_opid=1085 OR j.assn_opid=1067 OR j.assn_opid=1105 OR j.area_id=705 OR j.area_id=846 OR j.assn_opid=925 OR j.assn_opid=1005 OR j.assn_opid=928 OR j.assn_opid=927 OR j.area_id=850 OR j.assn_opid=1011 OR j.assn_opid=1012 OR j.assn_opid=946 OR j.assn_opid=969 OR j.area_id=851 OR j.area_id=852 OR j.assn_opid=943 OR j.area_id=845 OR j.area_id=848 OR j.assn_opid=945 OR j.area_id=1 OR j.area_id=321 OR j.area_id=21 OR j.assn_opid=322 OR j.assn_opid=343 OR j.assn_opid=502 OR j.assn_opid=993 OR j.assn_opid=516 OR j.assn_opid=762 OR j.assn_opid=503 OR j.assn_opid=915 OR j.assn_opid=342 OR j.assn_opid=907 OR j.assn_opid=682 OR j.assn_opid=562 OR j.assn_opid=44 OR j.assn_opid=22 OR j.assn_opid=43 OR j.assn_opid=344 OR j.assn_opid=505 OR j.assn_opid=822 OR j.assn_opid=906 OR j.assn_opid=582 OR j.assn_opid=1 OR j.assn_opid=918 OR j.assn_opid=917 OR j.assn_opid=926 OR j.assn_opid=912 OR j.assn_opid=914 OR j.assn_opid=913 OR j.assn_opid=919 OR j.assn_opid=921 OR j.assn_opid=522 OR j.assn_opid=1185 OR j.assn_opid=902 OR j.assn_opid=482 OR j.assn_opid=903 OR j.assn_opid=602 OR j.assn_opid=904 OR j.assn_opid=42 OR j.area_id=2 OR j.area_id=341 OR j.area_id=645 OR j.area_id=646 OR j.area_id=885 OR j.area_id=685 OR j.assn_opid=666 ) and j.TSK_STATUS not in (15,18,23,19) AND j.TSK_CLIENT in ('VODF' , 'VNHD' , 'VNH' , 'VNC' , 'V3H' , 'TVAE' , 'TV3N' , 'TV1S' , '03SM' , 'TV1C' , 'NVA' , '03OR' , 'AMAY' , 'MTG' , 'OSP' , 'PSP' , 'PMH' , 'BT' , 'VODN' , 'VEPL' , 'V4N' , 'TV6N' , 'TV6E' , 'TV1P' , 'TV1F' , 'T6LV' , 'T3LV' , 'RTR' , 'DAVI' , 'CTCE' , '3PLV' , '03SY' , '03SK' , '03SE' , '03JO' , '03GD' , 'AL' , 'ITV' , 'VSG' , 'VSD2' , 'VNE' , 'TV5L' , 'T8LT' , 'Play' , 'MM' , 'HDP2' , 'HDP1' , 'HDC1' , 'CTCB' , 'CS' , '03BO' , 'TV10' , 'AECHD' , 'PPL' , 'SKYCRI' , 'HUB' , 'VSD' , 'VEXE' , 'TVSL' , 'TV8' , 'TV2S' , 'TV1E' , 'TV1B' , 'TV1A' , 'DTV' , 'DMY' , 'DMA' , '03VL' , '03VB' , '03SS' , '03NO' , '03NB' , 'TECHM' , 'PMS' , 'SKYHORSE' , 'MED' , 'SFP1' , 'SFP2' , 'VSS' , 'TMD' , 'VEXR' , 'VEPO' , 'TVDP' , 'TV3S' , '3+ES' , '03SB' , '03HA' , 'NAA' , 'TVONE' , 'BBC' , 'BEDIG' , 'BTS' , 'SKYDART' , 'SKYGOLF' , 'SPG' , 'VSHD' , 'VSE' , 'VS2' , 'VODE' , 'TVPB' , 'TV6S' , 'TV1N' , 'TV1D' , 'NICK' , 'LNT' , 'DMF' , '3PD' , '03VA' , '03SG' , '03NM' , '03LI' , '03GO' , 'EUROSPORT' , 'WCIU' , 'ATP' , 'SKYRUGUN' , 'VS3' , 'VODD' , 'VHIS' , 'V1TZ' , 'TV6H' , 'TV1K' , 'KNVA' , 'MBNS' , 'YLE TV1' , 'LMH' , 'VIVA' , 'OUT' , 'SKY' , 'SKYFOOT' , 'ZTVS' , 'VSAT' , 'VODS' , 'VNPO' , 'VHPO' , 'VEC' , 'V1G' , 'TVPU' , 'AMC' , 'T6LT' , 'T3LT' , 'SPTV' , 'PBOY' , 'KNL2' , 'CENT' , '03VT' , '03UP' , '03SN' , 'TV3D' , '03SC' , 'EST' , 'AECSD' , 'ANTV') order by jj.j_compl_by, j.id , j.id ) a where rownum <= 50) where rnum >= 1 order by rnum t Information: 1220 : 10|15:57:52.0231|Mubm2A|LUCASB|SearchTask SQL: select * from (select a.*, rownum rnum from ( select /*+ INDEX(j JB_CMBST_IDX) */ /*+ INDEX(j JB_CMBST_IDX) */ j.*, p.pname, mi.MIID1, mi.MIID2, mi.MIID3, mi.VERSIONID1, mi.VERSIONID2, mi.PROGID1, mi.PROGID2, mi.VERSION, u.USER_ID OP_NAME, nvl(j.tech_rptt_id, 0) TECH_REPORT_ID, case when tsk_type=57 then cast(i.DEV_DATA_FMT as varchar2(100)) else '' end TASK_MODE, jj.j_compl_by JOB_COMPL_BY FROM tm_mtask j join tm_mjob jj on jj.id = j.j_id left join tm_mjob_pset p on p.id = jj.j_sched_indx left outer join TM_USERS u on u.id = j.assn_opid left join (select tsk_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 version) VERSION from tm_mis m, tm_mtsk_it i where m.id = i.mi_id and i.src_dest in (2, 3) group by tsk_id) mi on mi.tsk_id = j.id left join tm_mtsk_it i on i.tsk_id = j.id and i.src_dest = 4 and i.item_idx = 1 where 1=1 AND J_FAILURE_RESOLVED = 0 and ( j.area_id=421 OR j.area_id=501 OR j.assn_opid=662 OR j.assn_opid=1245 OR j.assn_opid=442 OR j.area_id=622 OR j.area_id=623 OR j.area_id=624 OR j.assn_opid=702 OR j.assn_opid=422 OR j.assn_opid=515 OR j.area_id=481 OR j.area_id=807 OR j.area_id=561 OR j.area_id=625 OR j.area_id=745 OR j.area_id=826 OR j.area_id=827 OR j.assn_opid=1065 OR j.assn_opid=922 OR j.assn_opid=923 OR j.assn_opid=1086 OR j.assn_opid=1085 OR j.assn_opid=1067 OR j.assn_opid=1105 OR j.area_id=705 OR j.area_id=846 OR j.assn_opid=925 OR j.assn_opid=1005 OR j.assn_opid=928 OR j.assn_opid=927 OR j.area_id=850 OR j.assn_opid=1011 OR j.assn_opid=1012 OR j.assn_opid=946 OR j.assn_opid=969 OR j.area_id=851 OR j.area_id=852 OR j.assn_opid=943 OR j.area_id=845 OR j.area_id=848 OR j.assn_opid=945 OR j.area_id=1 OR j.area_id=321 OR j.area_id=21 OR j.assn_opid=322 OR j.assn_opid=343 OR j.assn_opid=502 OR j.assn_opid=993 OR j.assn_opid=516 OR j.assn_opid=762 OR j.assn_opid=503 OR j.assn_opid=915 OR j.assn_opid=342 OR j.assn_opid=907 OR j.assn_opid=682 OR j.assn_opid=562 OR j.assn_opid=44 OR j.assn_opid=22 OR j.assn_opid=43 OR j.assn_opid=344 OR j.assn_opid=505 OR j.assn_opid=822 OR j.assn_opid=906 OR j.assn_opid=582 OR j.assn_opid=1 OR j.assn_opid=918 OR j.assn_opid=917 OR j.assn_opid=926 OR j.assn_opid=912 OR j.assn_opid=914 OR j.assn_opid=913 OR j.assn_opid=919 OR j.assn_opid=921 OR j.assn_opid=522 OR j.assn_opid=1185 OR j.assn_opid=902 OR j.assn_opid=482 OR j.assn_opid=903 OR j.assn_opid=602 OR j.assn_opid=904 OR j.assn_opid=42 OR j.area_id=2 OR j.area_id=341 OR j.area_id=645 OR j.area_id=646 OR j.area_id=885 OR j.area_id=685 OR j.assn_opid=666 ) and j.TSK_STATUS not in (15,18,23,19) AND j.TSK_CLIENT in ('VODF' , 'VNHD' , 'VNH' , 'VNC' , 'V3H' , 'TVAE' , 'TV3N' , 'TV1S' , '03SM' , 'TV1C' , 'NVA' , '03OR' , 'AMAY' , 'MTG' , 'OSP' , 'PSP' , 'PMH' , 'BT' , 'VODN' , 'VEPL' , 'V4N' , 'TV6N' , 'TV6E' , 'TV1P' , 'TV1F' , 'T6LV' , 'T3LV' , 'RTR' , 'DAVI' , 'CTCE' , '3PLV' , '03SY' , '03SK' , '03SE' , '03JO' , '03GD' , 'AL' , 'ITV' , 'VSG' , 'VSD2' , 'VNE' , 'TV5L' , 'T8LT' , 'Play' , 'MM' , 'HDP2' , 'HDP1' , 'HDC1' , 'CTCB' , 'CS' , '03BO' , 'TV10' , 'AECHD' , 'PPL' , 'SKYCRI' , 'HUB' , 'VSD' , 'VEXE' , 'TVSL' , 'TV8' , 'TV2S' , 'TV1E' , 'TV1B' , 'TV1A' , 'DTV' , 'DMY' , 'DMA' , '03VL' , '03VB' , '03SS' , '03NO' , '03NB' , 'TECHM' , 'PMS' , 'SKYHORSE' , 'MED' , 'SFP1' , 'SFP2' , 'VSS' , 'TMD' , 'VEXR' , 'VEPO' , 'TVDP' , 'TV3S' , '3+ES' , '03SB' , '03HA' , 'NAA' , 'TVONE' , 'BBC' , 'BEDIG' , 'BTS' , 'SKYDART' , 'SKYGOLF' , 'SPG' , 'VSHD' , 'VSE' , 'VS2' , 'VODE' , 'TVPB' , 'TV6S' , 'TV1N' , 'TV1D' , 'NICK' , 'LNT' , 'DMF' , '3PD' , '03VA' , '03SG' , '03NM' , '03LI' , '03GO' , 'EUROSPORT' , 'WCIU' , 'ATP' , 'SKYRUGUN' , 'VS3' , 'VODD' , 'VHIS' , 'V1TZ' , 'TV6H' , 'TV1K' , 'KNVA' , 'MBNS' , 'YLE TV1' , 'LMH' , 'VIVA' , 'OUT' , 'SKY' , 'SKYFOOT' , 'ZTVS' , 'VSAT' , 'VODS' , 'VNPO' , 'VHPO' , 'VEC' , 'V1G' , 'TVPU' , 'AMC' , 'T6LT' , 'T3LT' , 'SPTV' , 'PBOY' , 'KNL2' , 'CENT' , '03VT' , '03UP' , '03SN' , 'TV3D' , '03SC' , 'EST' , 'AECSD' , 'ANTV') order by jj.j_compl_by, j.id , j.id ) a where rownum <= 50) where rnum >= 1 order by rnum t Information: 1220 : 10|15:57:52.0231|mIZ9nZ|LUCASB|SearchTask SQL: select * from (select a.*, rownum rnum from ( select /*+ INDEX(j JB_CMBST_IDX) */ /*+ INDEX(j JB_CMBST_IDX) */ j.*, p.pname, mi.MIID1, mi.MIID2, mi.MIID3, mi.VERSIONID1, mi.VERSIONID2, mi.PROGID1, mi.PROGID2, mi.VERSION, u.USER_ID OP_NAME, nvl(j.tech_rptt_id, 0) TECH_REPORT_ID, case when tsk_type=57 then cast(i.DEV_DATA_FMT as varchar2(100)) else '' end TASK_MODE, jj.j_compl_by JOB_COMPL_BY FROM tm_mtask j join tm_mjob jj on jj.id = j.j_id left join tm_mjob_pset p on p.id = jj.j_sched_indx left outer join TM_USERS u on u.id = j.assn_opid left join (select tsk_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 version) VERSION from tm_mis m, tm_mtsk_it i where m.id = i.mi_id and i.src_dest in (2, 3) group by tsk_id) mi on mi.tsk_id = j.id left join tm_mtsk_it i on i.tsk_id = j.id and i.src_dest = 4 and i.item_idx = 1 where 1=1 AND J_FAILURE_RESOLVED = 0 and ( j.area_id=421 OR j.area_id=501 OR j.assn_opid=662 OR j.assn_opid=1245 OR j.assn_opid=442 OR j.area_id=622 OR j.area_id=623 OR j.area_id=624 OR j.assn_opid=702 OR j.assn_opid=422 OR j.assn_opid=515 OR j.area_id=481 OR j.area_id=807 OR j.area_id=561 OR j.area_id=625 OR j.area_id=745 OR j.area_id=826 OR j.area_id=827 OR j.assn_opid=1065 OR j.assn_opid=922 OR j.assn_opid=923 OR j.assn_opid=1086 OR j.assn_opid=1085 OR j.assn_opid=1067 OR j.assn_opid=1105 OR j.area_id=705 OR j.area_id=846 OR j.assn_opid=925 OR j.assn_opid=1005 OR j.assn_opid=928 OR j.assn_opid=927 OR j.area_id=850 OR j.assn_opid=1011 OR j.assn_opid=1012 OR j.assn_opid=946 OR j.assn_opid=969 OR j.area_id=851 OR j.area_id=852 OR j.assn_opid=943 OR j.area_id=845 OR j.area_id=848 OR j.assn_opid=945 OR j.area_id=1 OR j.area_id=321 OR j.area_id=21 OR j.assn_opid=322 OR j.assn_opid=343 OR j.assn_opid=502 OR j.assn_opid=993 OR j.assn_opid=516 OR j.assn_opid=762 OR j.assn_opid=503 OR j.assn_opid=915 OR j.assn_opid=342 OR j.assn_opid=907 OR j.assn_opid=682 OR j.assn_opid=562 OR j.assn_opid=44 OR j.assn_opid=22 OR j.assn_opid=43 OR j.assn_opid=344 OR j.assn_opid=505 OR j.assn_opid=822 OR j.assn_opid=906 OR j.assn_opid=582 OR j.assn_opid=1 OR j.assn_opid=918 OR j.assn_opid=917 OR j.assn_opid=926 OR j.assn_opid=912 OR j.assn_opid=914 OR j.assn_opid=913 OR j.assn_opid=919 OR j.assn_opid=921 OR j.assn_opid=522 OR j.assn_opid=1185 OR j.assn_opid=902 OR j.assn_opid=482 OR j.assn_opid=903 OR j.assn_opid=602 OR j.assn_opid=904 OR j.assn_opid=42 OR j.area_id=2 OR j.area_id=341 OR j.area_id=645 OR j.area_id=646 OR j.area_id=885 OR j.area_id=685 OR j.assn_opid=666 ) and j.TSK_STATUS not in (15,18,23,19) AND j.TSK_CLIENT in ('VODF' , 'VNHD' , 'VNH' , 'VNC' , 'V3H' , 'TVAE' , 'TV3N' , 'TV1S' , '03SM' , 'TV1C' , 'NVA' , '03OR' , 'AMAY' , 'MTG' , 'OSP' , 'PSP' , 'PMH' , 'BT' , 'VODN' , 'VEPL' , 'V4N' , 'TV6N' , 'TV6E' , 'TV1P' , 'TV1F' , 'T6LV' , 'T3LV' , 'RTR' , 'DAVI' , 'CTCE' , '3PLV' , '03SY' , '03SK' , '03SE' , '03JO' , '03GD' , 'AL' , 'ITV' , 'VSG' , 'VSD2' , 'VNE' , 'TV5L' , 'T8LT' , 'Play' , 'MM' , 'HDP2' , 'HDP1' , 'HDC1' , 'CTCB' , 'CS' , '03BO' , 'TV10' , 'AECHD' , 'PPL' , 'SKYCRI' , 'HUB' , 'VSD' , 'VEXE' , 'TVSL' , 'TV8' , 'TV2S' , 'TV1E' , 'TV1B' , 'TV1A' , 'DTV' , 'DMY' , 'DMA' , '03VL' , '03VB' , '03SS' , '03NO' , '03NB' , 'TECHM' , 'PMS' , 'SKYHORSE' , 'MED' , 'SFP1' , 'SFP2' , 'VSS' , 'TMD' , 'VEXR' , 'VEPO' , 'TVDP' , 'TV3S' , '3+ES' , '03SB' , '03HA' , 'NAA' , 'TVONE' , 'BBC' , 'BEDIG' , 'BTS' , 'SKYDART' , 'SKYGOLF' , 'SPG' , 'VSHD' , 'VSE' , 'VS2' , 'VODE' , 'TVPB' , 'TV6S' , 'TV1N' , 'TV1D' , 'NICK' , 'LNT' , 'DMF' , '3PD' , '03VA' , '03SG' , '03NM' , '03LI' , '03GO' , 'EUROSPORT' , 'WCIU' , 'ATP' , 'SKYRUGUN' , 'VS3' , 'VODD' , 'VHIS' , 'V1TZ' , 'TV6H' , 'TV1K' , 'KNVA' , 'MBNS' , 'YLE TV1' , 'LMH' , 'VIVA' , 'OUT' , 'SKY' , 'SKYFOOT' , 'ZTVS' , 'VSAT' , 'VODS' , 'VNPO' , 'VHPO' , 'VEC' , 'V1G' , 'TVPU' , 'AMC' , 'T6LT' , 'T3LT' , 'SPTV' , 'PBOY' , 'KNL2' , 'CENT' , '03VT' , '03UP' , '03SN' , 'TV3D' , '03SC' , 'EST' , 'AECSD' , 'ANTV') order by jj.j_compl_by, j.id , j.id ) a where rownum <= 50) where rnum >= 1 order by rnum t Information: 1220 : 10|15:57:52.0231|t89L0g|LUCASB|SearchTask SQL: select * from (select a.*, rownum rnum from ( select /*+ INDEX(j JB_CMBST_IDX) */ /*+ INDEX(j JB_CMBST_IDX) */ j.*, p.pname, mi.MIID1, mi.MIID2, mi.MIID3, mi.VERSIONID1, mi.VERSIONID2, mi.PROGID1, mi.PROGID2, mi.VERSION, u.USER_ID OP_NAME, nvl(j.tech_rptt_id, 0) TECH_REPORT_ID, case when tsk_type=57 then cast(i.DEV_DATA_FMT as varchar2(100)) else '' end TASK_MODE, jj.j_compl_by JOB_COMPL_BY FROM tm_mtask j join tm_mjob jj on jj.id = j.j_id left join tm_mjob_pset p on p.id = jj.j_sched_indx left outer join TM_USERS u on u.id = j.assn_opid left join (select tsk_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 version) VERSION from tm_mis m, tm_mtsk_it i where m.id = i.mi_id and i.src_dest in (2, 3) group by tsk_id) mi on mi.tsk_id = j.id left join tm_mtsk_it i on i.tsk_id = j.id and i.src_dest = 4 and i.item_idx = 1 where 1=1 AND J_FAILURE_RESOLVED = 0 and ( j.area_id=421 OR j.area_id=501 OR j.assn_opid=662 OR j.assn_opid=1245 OR j.assn_opid=442 OR j.area_id=622 OR j.area_id=623 OR j.area_id=624 OR j.assn_opid=702 OR j.assn_opid=422 OR j.assn_opid=515 OR j.area_id=481 OR j.area_id=807 OR j.area_id=561 OR j.area_id=625 OR j.area_id=745 OR j.area_id=826 OR j.area_id=827 OR j.assn_opid=1065 OR j.assn_opid=922 OR j.assn_opid=923 OR j.assn_opid=1086 OR j.assn_opid=1085 OR j.assn_opid=1067 OR j.assn_opid=1105 OR j.area_id=705 OR j.area_id=846 OR j.assn_opid=925 OR j.assn_opid=1005 OR j.assn_opid=928 OR j.assn_opid=927 OR j.area_id=850 OR j.assn_opid=1011 OR j.assn_opid=1012 OR j.assn_opid=946 OR j.assn_opid=969 OR j.area_id=851 OR j.area_id=852 OR j.assn_opid=943 OR j.area_id=845 OR j.area_id=848 OR j.assn_opid=945 OR j.area_id=1 OR j.area_id=321 OR j.area_id=21 OR j.assn_opid=322 OR j.assn_opid=343 OR j.assn_opid=502 OR j.assn_opid=993 OR j.assn_opid=516 OR j.assn_opid=762 OR j.assn_opid=503 OR j.assn_opid=915 OR j.assn_opid=342 OR j.assn_opid=907 OR j.assn_opid=682 OR j.assn_opid=562 OR j.assn_opid=44 OR j.assn_opid=22 OR j.assn_opid=43 OR j.assn_opid=344 OR j.assn_opid=505 OR j.assn_opid=822 OR j.assn_opid=906 OR j.assn_opid=582 OR j.assn_opid=1 OR j.assn_opid=918 OR j.assn_opid=917 OR j.assn_opid=926 OR j.assn_opid=912 OR j.assn_opid=914 OR j.assn_opid=913 OR j.assn_opid=919 OR j.assn_opid=921 OR j.assn_opid=522 OR j.assn_opid=1185 OR j.assn_opid=902 OR j.assn_opid=482 OR j.assn_opid=903 OR j.assn_opid=602 OR j.assn_opid=904 OR j.assn_opid=42 OR j.area_id=2 OR j.area_id=341 OR j.area_id=645 OR j.area_id=646 OR j.area_id=885 OR j.area_id=685 OR j.assn_opid=666 ) and j.TSK_STATUS not in (15,18,23,19) AND j.TSK_CLIENT in ('VODF' , 'VNHD' , 'VNH' , 'VNC' , 'V3H' , 'TVAE' , 'TV3N' , 'TV1S' , '03SM' , 'TV1C' , 'NVA' , '03OR' , 'AMAY' , 'MTG' , 'OSP' , 'PSP' , 'PMH' , 'BT' , 'VODN' , 'VEPL' , 'V4N' , 'TV6N' , 'TV6E' , 'TV1P' , 'TV1F' , 'T6LV' , 'T3LV' , 'RTR' , 'DAVI' , 'CTCE' , '3PLV' , '03SY' , '03SK' , '03SE' , '03JO' , '03GD' , 'AL' , 'ITV' , 'VSG' , 'VSD2' , 'VNE' , 'TV5L' , 'T8LT' , 'Play' , 'MM' , 'HDP2' , 'HDP1' , 'HDC1' , 'CTCB' , 'CS' , '03BO' , 'TV10' , 'AECHD' , 'PPL' , 'SKYCRI' , 'HUB' , 'VSD' , 'VEXE' , 'TVSL' , 'TV8' , 'TV2S' , 'TV1E' , 'TV1B' , 'TV1A' , 'DTV' , 'DMY' , 'DMA' , '03VL' , '03VB' , '03SS' , '03NO' , '03NB' , 'TECHM' , 'PMS' , 'SKYHORSE' , 'MED' , 'SFP1' , 'SFP2' , 'VSS' , 'TMD' , 'VEXR' , 'VEPO' , 'TVDP' , 'TV3S' , '3+ES' , '03SB' , '03HA' , 'NAA' , 'TVONE' , 'BBC' , 'BEDIG' , 'BTS' , 'SKYDART' , 'SKYGOLF' , 'SPG' , 'VSHD' , 'VSE' , 'VS2' , 'VODE' , 'TVPB' , 'TV6S' , 'TV1N' , 'TV1D' , 'NICK' , 'LNT' , 'DMF' , '3PD' , '03VA' , '03SG' , '03NM' , '03LI' , '03GO' , 'EUROSPORT' , 'WCIU' , 'ATP' , 'SKYRUGUN' , 'VS3' , 'VODD' , 'VHIS' , 'V1TZ' , 'TV6H' , 'TV1K' , 'KNVA' , 'MBNS' , 'YLE TV1' , 'LMH' , 'VIVA' , 'OUT' , 'SKY' , 'SKYFOOT' , 'ZTVS' , 'VSAT' , 'VODS' , 'VNPO' , 'VHPO' , 'VEC' , 'V1G' , 'TVPU' , 'AMC' , 'T6LT' , 'T3LT' , 'SPTV' , 'PBOY' , 'KNL2' , 'CENT' , '03VT' , '03UP' , '03SN' , 'TV3D' , '03SC' , 'EST' , 'AECSD' , 'ANTV') order by jj.j_compl_by, j.id , j.id ) a where rownum <= 50) where rnum >= 1 order by rnum t Information: 1220 : 10|15:57:52.0231|AHOMC5|LUCASB|SearchTask SQL: select * from (select a.*, rownum rnum from ( select /*+ INDEX(j JB_CMBST_IDX) */ /*+ INDEX(j JB_CMBST_IDX) */ j.*, p.pname, mi.MIID1, mi.MIID2, mi.MIID3, mi.VERSIONID1, mi.VERSIONID2, mi.PROGID1, mi.PROGID2, mi.VERSION, u.USER_ID OP_NAME, nvl(j.tech_rptt_id, 0) TECH_REPORT_ID, case when tsk_type=57 then cast(i.DEV_DATA_FMT as varchar2(100)) else '' end TASK_MODE, jj.j_compl_by JOB_COMPL_BY FROM tm_mtask j join tm_mjob jj on jj.id = j.j_id left join tm_mjob_pset p on p.id = jj.j_sched_indx left outer join TM_USERS u on u.id = j.assn_opid left join (select tsk_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 version) VERSION from tm_mis m, tm_mtsk_it i where m.id = i.mi_id and i.src_dest in (2, 3) group by tsk_id) mi on mi.tsk_id = j.id left join tm_mtsk_it i on i.tsk_id = j.id and i.src_dest = 4 and i.item_idx = 1 where 1=1 AND J_FAILURE_RESOLVED = 0 and ( j.area_id=421 OR j.area_id=501 OR j.assn_opid=662 OR j.assn_opid=1245 OR j.assn_opid=442 OR j.area_id=622 OR j.area_id=623 OR j.area_id=624 OR j.assn_opid=702 OR j.assn_opid=422 OR j.assn_opid=515 OR j.area_id=481 OR j.area_id=807 OR j.area_id=561 OR j.area_id=625 OR j.area_id=745 OR j.area_id=826 OR j.area_id=827 OR j.assn_opid=1065 OR j.assn_opid=922 OR j.assn_opid=923 OR j.assn_opid=1086 OR j.assn_opid=1085 OR j.assn_opid=1067 OR j.assn_opid=1105 OR j.area_id=705 OR j.area_id=846 OR j.assn_opid=925 OR j.assn_opid=1005 OR j.assn_opid=928 OR j.assn_opid=927 OR j.area_id=850 OR j.assn_opid=1011 OR j.assn_opid=1012 OR j.assn_opid=946 OR j.assn_opid=969 OR j.area_id=851 OR j.area_id=852 OR j.assn_opid=943 OR j.area_id=845 OR j.area_id=848 OR j.assn_opid=945 OR j.area_id=1 OR j.area_id=321 OR j.area_id=21 OR j.assn_opid=322 OR j.assn_opid=343 OR j.assn_opid=502 OR j.assn_opid=993 OR j.assn_opid=516 OR j.assn_opid=762 OR j.assn_opid=503 OR j.assn_opid=915 OR j.assn_opid=342 OR j.assn_opid=907 OR j.assn_opid=682 OR j.assn_opid=562 OR j.assn_opid=44 OR j.assn_opid=22 OR j.assn_opid=43 OR j.assn_opid=344 OR j.assn_opid=505 OR j.assn_opid=822 OR j.assn_opid=906 OR j.assn_opid=582 OR j.assn_opid=1 OR j.assn_opid=918 OR j.assn_opid=917 OR j.assn_opid=926 OR j.assn_opid=912 OR j.assn_opid=914 OR j.assn_opid=913 OR j.assn_opid=919 OR j.assn_opid=921 OR j.assn_opid=522 OR j.assn_opid=1185 OR j.assn_opid=902 OR j.assn_opid=482 OR j.assn_opid=903 OR j.assn_opid=602 OR j.assn_opid=904 OR j.assn_opid=42 OR j.area_id=2 OR j.area_id=341 OR j.area_id=645 OR j.area_id=646 OR j.area_id=885 OR j.area_id=685 OR j.assn_opid=666 ) and j.TSK_STATUS not in (15,18,23,19) AND j.TSK_CLIENT in ('VODF' , 'VNHD' , 'VNH' , 'VNC' , 'V3H' , 'TVAE' , 'TV3N' , 'TV1S' , '03SM' , 'TV1C' , 'NVA' , '03OR' , 'AMAY' , 'MTG' , 'OSP' , 'PSP' , 'PMH' , 'BT' , 'VODN' , 'VEPL' , 'V4N' , 'TV6N' , 'TV6E' , 'TV1P' , 'TV1F' , 'T6LV' , 'T3LV' , 'RTR' , 'DAVI' , 'CTCE' , '3PLV' , '03SY' , '03SK' , '03SE' , '03JO' , '03GD' , 'AL' , 'ITV' , 'VSG' , 'VSD2' , 'VNE' , 'TV5L' , 'T8LT' , 'Play' , 'MM' , 'HDP2' , 'HDP1' , 'HDC1' , 'CTCB' , 'CS' , '03BO' , 'TV10' , 'AECHD' , 'PPL' , 'SKYCRI' , 'HUB' , 'VSD' , 'VEXE' , 'TVSL' , 'TV8' , 'TV2S' , 'TV1E' , 'TV1B' , 'TV1A' , 'DTV' , 'DMY' , 'DMA' , '03VL' , '03VB' , '03SS' , '03NO' , '03NB' , 'TECHM' , 'PMS' , 'SKYHORSE' , 'MED' , 'SFP1' , 'SFP2' , 'VSS' , 'TMD' , 'VEXR' , 'VEPO' , 'TVDP' , 'TV3S' , '3+ES' , '03SB' , '03HA' , 'NAA' , 'TVONE' , 'BBC' , 'BEDIG' , 'BTS' , 'SKYDART' , 'SKYGOLF' , 'SPG' , 'VSHD' , 'VSE' , 'VS2' , 'VODE' , 'TVPB' , 'TV6S' , 'TV1N' , 'TV1D' , 'NICK' , 'LNT' , 'DMF' , '3PD' , '03VA' , '03SG' , '03NM' , '03LI' , '03GO' , 'EUROSPORT' , 'WCIU' , 'ATP' , 'SKYRUGUN' , 'VS3' , 'VODD' , 'VHIS' , 'V1TZ' , 'TV6H' , 'TV1K' , 'KNVA' , 'MBNS' , 'YLE TV1' , 'LMH' , 'VIVA' , 'OUT' , 'SKY' , 'SKYFOOT' , 'ZTVS' , 'VSAT' , 'VODS' , 'VNPO' , 'VHPO' , 'VEC' , 'V1G' , 'TVPU' , 'AMC' , 'T6LT' , 'T3LT' , 'SPTV' , 'PBOY' , 'KNL2' , 'CENT' , '03VT' , '03UP' , '03SN' , 'TV3D' , '03SC' , 'EST' , 'AECSD' , 'ANTV') order by jj.j_compl_by, j.id , j.id ) a where rownum <= 50) where rnum >= 1 order by rnum t Information: 1220 : 10|15:57:52.0231|5OYV9e|LUCASB|SearchTask SQL: select * from (select a.*, rownum rnum from ( select /*+ INDEX(j JB_CMBST_IDX) */ /*+ INDEX(j JB_CMBST_IDX) */ j.*, p.pname, mi.MIID1, mi.MIID2, mi.MIID3, mi.VERSIONID1, mi.VERSIONID2, mi.PROGID1, mi.PROGID2, mi.VERSION, u.USER_ID OP_NAME, nvl(j.tech_rptt_id, 0) TECH_REPORT_ID, case when tsk_type=57 then cast(i.DEV_DATA_FMT as varchar2(100)) else '' end TASK_MODE, jj.j_compl_by JOB_COMPL_BY FROM tm_mtask j join tm_mjob jj on jj.id = j.j_id left join tm_mjob_pset p on p.id = jj.j_sched_indx left outer join TM_USERS u on u.id = j.assn_opid left join (select tsk_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 version) VERSION from tm_mis m, tm_mtsk_it i where m.id = i.mi_id and i.src_dest in (2, 3) group by tsk_id) mi on mi.tsk_id = j.id left join tm_mtsk_it i on i.tsk_id = j.id and i.src_dest = 4 and i.item_idx = 1 where 1=1 AND J_FAILURE_RESOLVED = 0 and ( j.area_id=421 OR j.area_id=501 OR j.assn_opid=662 OR j.assn_opid=1245 OR j.assn_opid=442 OR j.area_id=622 OR j.area_id=623 OR j.area_id=624 OR j.assn_opid=702 OR j.assn_opid=422 OR j.assn_opid=515 OR j.area_id=481 OR j.area_id=807 OR j.area_id=561 OR j.area_id=625 OR j.area_id=745 OR j.area_id=826 OR j.area_id=827 OR j.assn_opid=1065 OR j.assn_opid=922 OR j.assn_opid=923 OR j.assn_opid=1086 OR j.assn_opid=1085 OR j.assn_opid=1067 OR j.assn_opid=1105 OR j.area_id=705 OR j.area_id=846 OR j.assn_opid=925 OR j.assn_opid=1005 OR j.assn_opid=928 OR j.assn_opid=927 OR j.area_id=850 OR j.assn_opid=1011 OR j.assn_opid=1012 OR j.assn_opid=946 OR j.assn_opid=969 OR j.area_id=851 OR j.area_id=852 OR j.assn_opid=943 OR j.area_id=845 OR j.area_id=848 OR j.assn_opid=945 OR j.area_id=1 OR j.area_id=321 OR j.area_id=21 OR j.assn_opid=322 OR j.assn_opid=343 OR j.assn_opid=502 OR j.assn_opid=993 OR j.assn_opid=516 OR j.assn_opid=762 OR j.assn_opid=503 OR j.assn_opid=915 OR j.assn_opid=342 OR j.assn_opid=907 OR j.assn_opid=682 OR j.assn_opid=562 OR j.assn_opid=44 OR j.assn_opid=22 OR j.assn_opid=43 OR j.assn_opid=344 OR j.assn_opid=505 OR j.assn_opid=822 OR j.assn_opid=906 OR j.assn_opid=582 OR j.assn_opid=1 OR j.assn_opid=918 OR j.assn_opid=917 OR j.assn_opid=926 OR j.assn_opid=912 OR j.assn_opid=914 OR j.assn_opid=913 OR j.assn_opid=919 OR j.assn_opid=921 OR j.assn_opid=522 OR j.assn_opid=1185 OR j.assn_opid=902 OR j.assn_opid=482 OR j.assn_opid=903 OR j.assn_opid=602 OR j.assn_opid=904 OR j.assn_opid=42 OR j.area_id=2 OR j.area_id=341 OR j.area_id=645 OR j.area_id=646 OR j.area_id=885 OR j.area_id=685 OR j.assn_opid=666 ) and j.TSK_STATUS not in (15,18,23,19) AND j.TSK_CLIENT in ('VODF' , 'VNHD' , 'VNH' , 'VNC' , 'V3H' , 'TVAE' , 'TV3N' , 'TV1S' , '03SM' , 'TV1C' , 'NVA' , '03OR' , 'AMAY' , 'MTG' , 'OSP' , 'PSP' , 'PMH' , 'BT' , 'VODN' , 'VEPL' , 'V4N' , 'TV6N' , 'TV6E' , 'TV1P' , 'TV1F' , 'T6LV' , 'T3LV' , 'RTR' , 'DAVI' , 'CTCE' , '3PLV' , '03SY' , '03SK' , '03SE' , '03JO' , '03GD' , 'AL' , 'ITV' , 'VSG' , 'VSD2' , 'VNE' , 'TV5L' , 'T8LT' , 'Play' , 'MM' , 'HDP2' , 'HDP1' , 'HDC1' , 'CTCB' , 'CS' , '03BO' , 'TV10' , 'AECHD' , 'PPL' , 'SKYCRI' , 'HUB' , 'VSD' , 'VEXE' , 'TVSL' , 'TV8' , 'TV2S' , 'TV1E' , 'TV1B' , 'TV1A' , 'DTV' , 'DMY' , 'DMA' , '03VL' , '03VB' , '03SS' , '03NO' , '03NB' , 'TECHM' , 'PMS' , 'SKYHORSE' , 'MED' , 'SFP1' , 'SFP2' , 'VSS' , 'TMD' , 'VEXR' , 'VEPO' , 'TVDP' , 'TV3S' , '3+ES' , '03SB' , '03HA' , 'NAA' , 'TVONE' , 'BBC' , 'BEDIG' , 'BTS' , 'SKYDART' , 'SKYGOLF' , 'SPG' , 'VSHD' , 'VSE' , 'VS2' , 'VODE' , 'TVPB' , 'TV6S' , 'TV1N' , 'TV1D' , 'NICK' , 'LNT' , 'DMF' , '3PD' , '03VA' , '03SG' , '03NM' , '03LI' , '03GO' , 'EUROSPORT' , 'WCIU' , 'ATP' , 'SKYRUGUN' , 'VS3' , 'VODD' , 'VHIS' , 'V1TZ' , 'TV6H' , 'TV1K' , 'KNVA' , 'MBNS' , 'YLE TV1' , 'LMH' , 'VIVA' , 'OUT' , 'SKY' , 'SKYFOOT' , 'ZTVS' , 'VSAT' , 'VODS' , 'VNPO' , 'VHPO' , 'VEC' , 'V1G' , 'TVPU' , 'AMC' , 'T6LT' , 'T3LT' , 'SPTV' , 'PBOY' , 'KNL2' , 'CENT' , '03VT' , '03UP' , '03SN' , 'TV3D' , '03SC' , 'EST' , 'AECSD' , 'ANTV') order by jj.j_compl_by, j.id , j.id ) a where rownum <= 50) where rnum >= 1 order by rnum t Verbose: 1220 : 10|15:57:53.1325|AHOMC5|LUCASB|imfx v3 API took 1.408s '/api/v3/search/task?_dc=1710863871117' t Verbose: 1220 : 10|15:57:53.1325|mIZ9nZ|LUCASB|imfx v3 API took 1.419s '/api/v3/search/task?_dc=1710863871116' t Verbose: 1220 : 10|15:57:53.1325|c70MX8|LUCASB|imfx v3 API took 1.514s '/api/v3/search/task?_dc=1710863871115' t Verbose: 1220 : 10|15:57:53.4137|Mubm2A|LUCASB|imfx v3 API took 1.569s '/api/v3/search/task?_dc=1710863871118' t Verbose: 1220 : 10|15:57:53.5231|t89L0g|LUCASB|imfx v3 API took 1.577s '/api/v3/search/task?_dc=1710863871116' t Transfer: 1220 : 10|15:57:53.5231|9YbSAV|LUCASB|OAuth: /api/v3/search/task?_dc=1710863871125 t Transfer: 1220 : 10|15:57:53.5231|9YbSAV|LUCASB|GetCurrentUser.. t Transfer: 1220 : 10|15:57:53.5231|9YbSAV|LUCASB| OAuth authenticated t Transfer: 1220 : 10|15:57:53.5231|9YbSAV|LUCASB| user LUCASB. t Verbose: 1220 : 10|15:57:53.5231|9YbSAV|LUCASB|OAuth. User logged in: LUCASB t Information: 1220 : 10|15:57:53.5231|9YbSAV|LUCASB|V3Api.SearchTask t Information: 1220 : 10|15:57:53.5231|9YbSAV|LUCASB|V3Api.SearchGeneric t Transfer: 1220 : 10|15:57:53.5231|9YbSAV|LUCASB|GetCurrentUser.. t Transfer: 1220 : 10|15:57:53.5231|9YbSAV|LUCASB| OAuth authenticated t Transfer: 1220 : 10|15:57:53.5231|9YbSAV|LUCASB| user LUCASB. t Information: 1220 : 10|15:57:53.5231|9YbSAV|LUCASB|SearchTask SQL: select * from (select a.*, rownum rnum from ( select /*+ INDEX(j JB_CMBST_IDX) */ /*+ INDEX(j JB_CMBST_IDX) */ j.*, p.pname, mi.MIID1, mi.MIID2, mi.MIID3, mi.VERSIONID1, mi.VERSIONID2, mi.PROGID1, mi.PROGID2, mi.VERSION, u.USER_ID OP_NAME, nvl(j.tech_rptt_id, 0) TECH_REPORT_ID, case when tsk_type=57 then cast(i.DEV_DATA_FMT as varchar2(100)) else '' end TASK_MODE, jj.j_compl_by JOB_COMPL_BY FROM tm_mtask j join tm_mjob jj on jj.id = j.j_id left join tm_mjob_pset p on p.id = jj.j_sched_indx left outer join TM_USERS u on u.id = j.assn_opid left join (select tsk_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 version) VERSION from tm_mis m, tm_mtsk_it i where m.id = i.mi_id and i.src_dest in (2, 3) group by tsk_id) mi on mi.tsk_id = j.id left join tm_mtsk_it i on i.tsk_id = j.id and i.src_dest = 4 and i.item_idx = 1 where 1=1 AND J_FAILURE_RESOLVED = 0 and ( j.area_id=421 OR j.area_id=501 OR j.assn_opid=662 OR j.assn_opid=1245 OR j.assn_opid=442 OR j.area_id=622 OR j.area_id=623 OR j.area_id=624 OR j.assn_opid=702 OR j.assn_opid=422 OR j.assn_opid=515 OR j.area_id=481 OR j.area_id=807 OR j.area_id=561 OR j.area_id=625 OR j.area_id=745 OR j.area_id=826 OR j.area_id=827 OR j.assn_opid=1065 OR j.assn_opid=922 OR j.assn_opid=923 OR j.assn_opid=1086 OR j.assn_opid=1085 OR j.assn_opid=1067 OR j.assn_opid=1105 OR j.area_id=705 OR j.area_id=846 OR j.assn_opid=925 OR j.assn_opid=1005 OR j.assn_opid=928 OR j.assn_opid=927 OR j.area_id=850 OR j.assn_opid=1011 OR j.assn_opid=1012 OR j.assn_opid=946 OR j.assn_opid=969 OR j.area_id=851 OR j.area_id=852 OR j.assn_opid=943 OR j.area_id=845 OR j.area_id=848 OR j.assn_opid=945 OR j.area_id=1 OR j.area_id=321 OR j.area_id=21 OR j.assn_opid=322 OR j.assn_opid=343 OR j.assn_opid=502 OR j.assn_opid=993 OR j.assn_opid=516 OR j.assn_opid=762 OR j.assn_opid=503 OR j.assn_opid=915 OR j.assn_opid=342 OR j.assn_opid=907 OR j.assn_opid=682 OR j.assn_opid=562 OR j.assn_opid=44 OR j.assn_opid=22 OR j.assn_opid=43 OR j.assn_opid=344 OR j.assn_opid=505 OR j.assn_opid=822 OR j.assn_opid=906 OR j.assn_opid=582 OR j.assn_opid=1 OR j.assn_opid=918 OR j.assn_opid=917 OR j.assn_opid=926 OR j.assn_opid=912 OR j.assn_opid=914 OR j.assn_opid=913 OR j.assn_opid=919 OR j.assn_opid=921 OR j.assn_opid=522 OR j.assn_opid=1185 OR j.assn_opid=902 OR j.assn_opid=482 OR j.assn_opid=903 OR j.assn_opid=602 OR j.assn_opid=904 OR j.assn_opid=42 OR j.area_id=2 OR j.area_id=341 OR j.area_id=645 OR j.area_id=646 OR j.area_id=885 OR j.area_id=685 OR j.assn_opid=666 ) and j.TSK_STATUS not in (15,18,23,19) AND j.TSK_CLIENT in ('VODF' , 'VNHD' , 'VNH' , 'VNC' , 'V3H' , 'TVAE' , 'TV3N' , 'TV1S' , '03SM' , 'TV1C' , 'NVA' , '03OR' , 'AMAY' , 'MTG' , 'OSP' , 'PSP' , 'PMH' , 'BT' , 'VODN' , 'VEPL' , 'V4N' , 'TV6N' , 'TV6E' , 'TV1P' , 'TV1F' , 'T6LV' , 'T3LV' , 'RTR' , 'DAVI' , 'CTCE' , '3PLV' , '03SY' , '03SK' , '03SE' , '03JO' , '03GD' , 'AL' , 'ITV' , 'VSG' , 'VSD2' , 'VNE' , 'TV5L' , 'T8LT' , 'Play' , 'MM' , 'HDP2' , 'HDP1' , 'HDC1' , 'CTCB' , 'CS' , '03BO' , 'TV10' , 'AECHD' , 'PPL' , 'SKYCRI' , 'HUB' , 'VSD' , 'VEXE' , 'TVSL' , 'TV8' , 'TV2S' , 'TV1E' , 'TV1B' , 'TV1A' , 'DTV' , 'DMY' , 'DMA' , '03VL' , '03VB' , '03SS' , '03NO' , '03NB' , 'TECHM' , 'PMS' , 'SKYHORSE' , 'MED' , 'SFP1' , 'SFP2' , 'VSS' , 'TMD' , 'VEXR' , 'VEPO' , 'TVDP' , 'TV3S' , '3+ES' , '03SB' , '03HA' , 'NAA' , 'TVONE' , 'BBC' , 'BEDIG' , 'BTS' , 'SKYDART' , 'SKYGOLF' , 'SPG' , 'VSHD' , 'VSE' , 'VS2' , 'VODE' , 'TVPB' , 'TV6S' , 'TV1N' , 'TV1D' , 'NICK' , 'LNT' , 'DMF' , '3PD' , '03VA' , '03SG' , '03NM' , '03LI' , '03GO' , 'EUROSPORT' , 'WCIU' , 'ATP' , 'SKYRUGUN' , 'VS3' , 'VODD' , 'VHIS' , 'V1TZ' , 'TV6H' , 'TV1K' , 'KNVA' , 'MBNS' , 'YLE TV1' , 'LMH' , 'VIVA' , 'OUT' , 'SKY' , 'SKYFOOT' , 'ZTVS' , 'VSAT' , 'VODS' , 'VNPO' , 'VHPO' , 'VEC' , 'V1G' , 'TVPU' , 'AMC' , 'T6LT' , 'T3LT' , 'SPTV' , 'PBOY' , 'KNL2' , 'CENT' , '03VT' , '03UP' , '03SN' , 'TV3D' , '03SC' , 'EST' , 'AECSD' , 'ANTV') order by jj.j_compl_by, j.id , j.id ) a where rownum <= 50) where rnum >= 1 order by rnum t Verbose: 1220 : 10|15:57:53.5387|5OYV9e|LUCASB|imfx v3 API took 1.804s '/api/v3/search/task?_dc=1710863871124' t Transfer: 1220 : 10|15:57:53.5387|QT6Ctk|LUCASB|OAuth: /api/v3/search/task?_dc=1710863871126 t Transfer: 1220 : 10|15:57:53.5387|QT6Ctk|LUCASB|GetCurrentUser.. t Transfer: 1220 : 10|15:57:53.5387|QT6Ctk|LUCASB| OAuth authenticated t Transfer: 1220 : 10|15:57:53.5387|QT6Ctk|LUCASB| user LUCASB. t Verbose: 1220 : 10|15:57:53.5387|QT6Ctk|LUCASB|OAuth. User logged in: LUCASB t Information: 1220 : 10|15:57:53.5387|QT6Ctk|LUCASB|V3Api.SearchTask t Information: 1220 : 10|15:57:53.5387|QT6Ctk|LUCASB|V3Api.SearchGeneric t Transfer: 1220 : 10|15:57:53.5387|QT6Ctk|LUCASB|GetCurrentUser.. t Transfer: 1220 : 10|15:57:53.5387|QT6Ctk|LUCASB| OAuth authenticated t Transfer: 1220 : 10|15:57:53.5387|QT6Ctk|LUCASB| user LUCASB. t Verbose: 1220 : 10|15:57:53.5387|9YbSAV|LUCASB|imfx v3 API took 0.183s '/api/v3/search/task?_dc=1710863871125' t Information: 1220 : 10|15:57:53.5387|QT6Ctk|LUCASB|SearchTask SQL: select * from (select a.*, rownum rnum from ( select /*+ INDEX(j JB_CMBST_IDX) */ /*+ INDEX(j JB_CMBST_IDX) */ j.*, p.pname, mi.MIID1, mi.MIID2, mi.MIID3, mi.VERSIONID1, mi.VERSIONID2, mi.PROGID1, mi.PROGID2, mi.VERSION, u.USER_ID OP_NAME, nvl(j.tech_rptt_id, 0) TECH_REPORT_ID, case when tsk_type=57 then cast(i.DEV_DATA_FMT as varchar2(100)) else '' end TASK_MODE, jj.j_compl_by JOB_COMPL_BY FROM tm_mtask j join tm_mjob jj on jj.id = j.j_id left join tm_mjob_pset p on p.id = jj.j_sched_indx left outer join TM_USERS u on u.id = j.assn_opid left join (select tsk_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 version) VERSION from tm_mis m, tm_mtsk_it i where m.id = i.mi_id and i.src_dest in (2, 3) group by tsk_id) mi on mi.tsk_id = j.id left join tm_mtsk_it i on i.tsk_id = j.id and i.src_dest = 4 and i.item_idx = 1 where 1=1 AND J_FAILURE_RESOLVED = 0 and ( j.area_id=421 OR j.area_id=501 OR j.assn_opid=662 OR j.assn_opid=1245 OR j.assn_opid=442 OR j.area_id=622 OR j.area_id=623 OR j.area_id=624 OR j.assn_opid=702 OR j.assn_opid=422 OR j.assn_opid=515 OR j.area_id=481 OR j.area_id=807 OR j.area_id=561 OR j.area_id=625 OR j.area_id=745 OR j.area_id=826 OR j.area_id=827 OR j.assn_opid=1065 OR j.assn_opid=922 OR j.assn_opid=923 OR j.assn_opid=1086 OR j.assn_opid=1085 OR j.assn_opid=1067 OR j.assn_opid=1105 OR j.area_id=705 OR j.area_id=846 OR j.assn_opid=925 OR j.assn_opid=1005 OR j.assn_opid=928 OR j.assn_opid=927 OR j.area_id=850 OR j.assn_opid=1011 OR j.assn_opid=1012 OR j.assn_opid=946 OR j.assn_opid=969 OR j.area_id=851 OR j.area_id=852 OR j.assn_opid=943 OR j.area_id=845 OR j.area_id=848 OR j.assn_opid=945 OR j.area_id=1 OR j.area_id=321 OR j.area_id=21 OR j.assn_opid=322 OR j.assn_opid=343 OR j.assn_opid=502 OR j.assn_opid=993 OR j.assn_opid=516 OR j.assn_opid=762 OR j.assn_opid=503 OR j.assn_opid=915 OR j.assn_opid=342 OR j.assn_opid=907 OR j.assn_opid=682 OR j.assn_opid=562 OR j.assn_opid=44 OR j.assn_opid=22 OR j.assn_opid=43 OR j.assn_opid=344 OR j.assn_opid=505 OR j.assn_opid=822 OR j.assn_opid=906 OR j.assn_opid=582 OR j.assn_opid=1 OR j.assn_opid=918 OR j.assn_opid=917 OR j.assn_opid=926 OR j.assn_opid=912 OR j.assn_opid=914 OR j.assn_opid=913 OR j.assn_opid=919 OR j.assn_opid=921 OR j.assn_opid=522 OR j.assn_opid=1185 OR j.assn_opid=902 OR j.assn_opid=482 OR j.assn_opid=903 OR j.assn_opid=602 OR j.assn_opid=904 OR j.assn_opid=42 OR j.area_id=2 OR j.area_id=341 OR j.area_id=645 OR j.area_id=646 OR j.area_id=885 OR j.area_id=685 OR j.assn_opid=666 ) and j.TSK_STATUS not in (15,18,23,19) AND j.TSK_CLIENT in ('VODF' , 'VNHD' , 'VNH' , 'VNC' , 'V3H' , 'TVAE' , 'TV3N' , 'TV1S' , '03SM' , 'TV1C' , 'NVA' , '03OR' , 'AMAY' , 'MTG' , 'OSP' , 'PSP' , 'PMH' , 'BT' , 'VODN' , 'VEPL' , 'V4N' , 'TV6N' , 'TV6E' , 'TV1P' , 'TV1F' , 'T6LV' , 'T3LV' , 'RTR' , 'DAVI' , 'CTCE' , '3PLV' , '03SY' , '03SK' , '03SE' , '03JO' , '03GD' , 'AL' , 'ITV' , 'VSG' , 'VSD2' , 'VNE' , 'TV5L' , 'T8LT' , 'Play' , 'MM' , 'HDP2' , 'HDP1' , 'HDC1' , 'CTCB' , 'CS' , '03BO' , 'TV10' , 'AECHD' , 'PPL' , 'SKYCRI' , 'HUB' , 'VSD' , 'VEXE' , 'TVSL' , 'TV8' , 'TV2S' , 'TV1E' , 'TV1B' , 'TV1A' , 'DTV' , 'DMY' , 'DMA' , '03VL' , '03VB' , '03SS' , '03NO' , '03NB' , 'TECHM' , 'PMS' , 'SKYHORSE' , 'MED' , 'SFP1' , 'SFP2' , 'VSS' , 'TMD' , 'VEXR' , 'VEPO' , 'TVDP' , 'TV3S' , '3+ES' , '03SB' , '03HA' , 'NAA' , 'TVONE' , 'BBC' , 'BEDIG' , 'BTS' , 'SKYDART' , 'SKYGOLF' , 'SPG' , 'VSHD' , 'VSE' , 'VS2' , 'VODE' , 'TVPB' , 'TV6S' , 'TV1N' , 'TV1D' , 'NICK' , 'LNT' , 'DMF' , '3PD' , '03VA' , '03SG' , '03NM' , '03LI' , '03GO' , 'EUROSPORT' , 'WCIU' , 'ATP' , 'SKYRUGUN' , 'VS3' , 'VODD' , 'VHIS' , 'V1TZ' , 'TV6H' , 'TV1K' , 'KNVA' , 'MBNS' , 'YLE TV1' , 'LMH' , 'VIVA' , 'OUT' , 'SKY' , 'SKYFOOT' , 'ZTVS' , 'VSAT' , 'VODS' , 'VNPO' , 'VHPO' , 'VEC' , 'V1G' , 'TVPU' , 'AMC' , 'T6LT' , 'T3LT' , 'SPTV' , 'PBOY' , 'KNL2' , 'CENT' , '03VT' , '03UP' , '03SN' , 'TV3D' , '03SC' , 'EST' , 'AECSD' , 'ANTV') order by jj.j_compl_by, j.id , j.id ) a where rownum <= 50) where rnum >= 1 order by rnum t Verbose: 1220 : 10|15:57:53.9715|QT6Ctk|LUCASB|imfx v3 API took 0.131s '/api/v3/search/task?_dc=1710863871126' t Transfer: 1220 : 10|15:57:53.9715|KKQquR|LUCASB|OAuth: /api/v3/search/task?_dc=1710863871126 t Transfer: 1220 : 10|15:57:53.9715|KKQquR|LUCASB|GetCurrentUser.. t Transfer: 1220 : 10|15:57:53.9715|KKQquR|LUCASB| OAuth authenticated t Transfer: 1220 : 10|15:57:53.9715|KKQquR|LUCASB| user LUCASB. t Verbose: 1220 : 10|15:57:53.9715|KKQquR|LUCASB|OAuth. User logged in: LUCASB t Information: 1220 : 10|15:57:53.9715|KKQquR|LUCASB|V3Api.SearchTask t Information: 1220 : 10|15:57:53.9715|KKQquR|LUCASB|V3Api.SearchGeneric t Transfer: 1220 : 10|15:57:53.9715|KKQquR|LUCASB|GetCurrentUser.. t Transfer: 1220 : 10|15:57:53.9715|KKQquR|LUCASB| OAuth authenticated t Transfer: 1220 : 10|15:57:53.9715|KKQquR|LUCASB| user LUCASB. t Information: 1220 : 10|15:57:53.9715|KKQquR|LUCASB|SearchTask SQL: select * from (select a.*, rownum rnum from ( select /*+ INDEX(j JB_CMBST_IDX) */ /*+ INDEX(j JB_CMBST_IDX) */ j.*, p.pname, mi.MIID1, mi.MIID2, mi.MIID3, mi.VERSIONID1, mi.VERSIONID2, mi.PROGID1, mi.PROGID2, mi.VERSION, u.USER_ID OP_NAME, nvl(j.tech_rptt_id, 0) TECH_REPORT_ID, case when tsk_type=57 then cast(i.DEV_DATA_FMT as varchar2(100)) else '' end TASK_MODE, jj.j_compl_by JOB_COMPL_BY FROM tm_mtask j join tm_mjob jj on jj.id = j.j_id left join tm_mjob_pset p on p.id = jj.j_sched_indx left outer join TM_USERS u on u.id = j.assn_opid left join (select tsk_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 version) VERSION from tm_mis m, tm_mtsk_it i where m.id = i.mi_id and i.src_dest in (2, 3) group by tsk_id) mi on mi.tsk_id = j.id left join tm_mtsk_it i on i.tsk_id = j.id and i.src_dest = 4 and i.item_idx = 1 where 1=1 AND J_FAILURE_RESOLVED = 0 and ( j.area_id=421 OR j.area_id=501 OR j.assn_opid=662 OR j.assn_opid=1245 OR j.assn_opid=442 OR j.area_id=622 OR j.area_id=623 OR j.area_id=624 OR j.assn_opid=702 OR j.assn_opid=422 OR j.assn_opid=515 OR j.area_id=481 OR j.area_id=807 OR j.area_id=561 OR j.area_id=625 OR j.area_id=745 OR j.area_id=826 OR j.area_id=827 OR j.assn_opid=1065 OR j.assn_opid=922 OR j.assn_opid=923 OR j.assn_opid=1086 OR j.assn_opid=1085 OR j.assn_opid=1067 OR j.assn_opid=1105 OR j.area_id=705 OR j.area_id=846 OR j.assn_opid=925 OR j.assn_opid=1005 OR j.assn_opid=928 OR j.assn_opid=927 OR j.area_id=850 OR j.assn_opid=1011 OR j.assn_opid=1012 OR j.assn_opid=946 OR j.assn_opid=969 OR j.area_id=851 OR j.area_id=852 OR j.assn_opid=943 OR j.area_id=845 OR j.area_id=848 OR j.assn_opid=945 OR j.area_id=1 OR j.area_id=321 OR j.area_id=21 OR j.assn_opid=322 OR j.assn_opid=343 OR j.assn_opid=502 OR j.assn_opid=993 OR j.assn_opid=516 OR j.assn_opid=762 OR j.assn_opid=503 OR j.assn_opid=915 OR j.assn_opid=342 OR j.assn_opid=907 OR j.assn_opid=682 OR j.assn_opid=562 OR j.assn_opid=44 OR j.assn_opid=22 OR j.assn_opid=43 OR j.assn_opid=344 OR j.assn_opid=505 OR j.assn_opid=822 OR j.assn_opid=906 OR j.assn_opid=582 OR j.assn_opid=1 OR j.assn_opid=918 OR j.assn_opid=917 OR j.assn_opid=926 OR j.assn_opid=912 OR j.assn_opid=914 OR j.assn_opid=913 OR j.assn_opid=919 OR j.assn_opid=921 OR j.assn_opid=522 OR j.assn_opid=1185 OR j.assn_opid=902 OR j.assn_opid=482 OR j.assn_opid=903 OR j.assn_opid=602 OR j.assn_opid=904 OR j.assn_opid=42 OR j.area_id=2 OR j.area_id=341 OR j.area_id=645 OR j.area_id=646 OR j.area_id=885 OR j.area_id=685 OR j.assn_opid=666 ) and j.TSK_STATUS not in (15,18,23,19) AND j.TSK_CLIENT in ('VODF' , 'VNHD' , 'VNH' , 'VNC' , 'V3H' , 'TVAE' , 'TV3N' , 'TV1S' , '03SM' , 'TV1C' , 'NVA' , '03OR' , 'AMAY' , 'MTG' , 'OSP' , 'PSP' , 'PMH' , 'BT' , 'VODN' , 'VEPL' , 'V4N' , 'TV6N' , 'TV6E' , 'TV1P' , 'TV1F' , 'T6LV' , 'T3LV' , 'RTR' , 'DAVI' , 'CTCE' , '3PLV' , '03SY' , '03SK' , '03SE' , '03JO' , '03GD' , 'AL' , 'ITV' , 'VSG' , 'VSD2' , 'VNE' , 'TV5L' , 'T8LT' , 'Play' , 'MM' , 'HDP2' , 'HDP1' , 'HDC1' , 'CTCB' , 'CS' , '03BO' , 'TV10' , 'AECHD' , 'PPL' , 'SKYCRI' , 'HUB' , 'VSD' , 'VEXE' , 'TVSL' , 'TV8' , 'TV2S' , 'TV1E' , 'TV1B' , 'TV1A' , 'DTV' , 'DMY' , 'DMA' , '03VL' , '03VB' , '03SS' , '03NO' , '03NB' , 'TECHM' , 'PMS' , 'SKYHORSE' , 'MED' , 'SFP1' , 'SFP2' , 'VSS' , 'TMD' , 'VEXR' , 'VEPO' , 'TVDP' , 'TV3S' , '3+ES' , '03SB' , '03HA' , 'NAA' , 'TVONE' , 'BBC' , 'BEDIG' , 'BTS' , 'SKYDART' , 'SKYGOLF' , 'SPG' , 'VSHD' , 'VSE' , 'VS2' , 'VODE' , 'TVPB' , 'TV6S' , 'TV1N' , 'TV1D' , 'NICK' , 'LNT' , 'DMF' , '3PD' , '03VA' , '03SG' , '03NM' , '03LI' , '03GO' , 'EUROSPORT' , 'WCIU' , 'ATP' , 'SKYRUGUN' , 'VS3' , 'VODD' , 'VHIS' , 'V1TZ' , 'TV6H' , 'TV1K' , 'KNVA' , 'MBNS' , 'YLE TV1' , 'LMH' , 'VIVA' , 'OUT' , 'SKY' , 'SKYFOOT' , 'ZTVS' , 'VSAT' , 'VODS' , 'VNPO' , 'VHPO' , 'VEC' , 'V1G' , 'TVPU' , 'AMC' , 'T6LT' , 'T3LT' , 'SPTV' , 'PBOY' , 'KNL2' , 'CENT' , '03VT' , '03UP' , '03SN' , 'TV3D' , '03SC' , 'EST' , 'AECSD' , 'ANTV') order by jj.j_compl_by, j.id , j.id ) a where rownum <= 50) where rnum >= 1 order by rnum t Verbose: 1220 : 10|15:57:53.9715|KKQquR|LUCASB|imfx v3 API took 0.058s '/api/v3/search/task?_dc=1710863871126' t Transfer: 1220 : 10|15:57:53.9715|2TKT0d|LUCASB|OAuth: /api/v3/search/task?_dc=1710863871126 t Transfer: 1220 : 10|15:57:53.9715|2TKT0d|LUCASB|GetCurrentUser.. t Transfer: 1220 : 10|15:57:53.9715|2TKT0d|LUCASB| OAuth authenticated t Transfer: 1220 : 10|15:57:53.9715|2TKT0d|LUCASB| user LUCASB. t Verbose: 1220 : 10|15:57:53.9715|2TKT0d|LUCASB|OAuth. User logged in: LUCASB t Transfer: 1220 : 10|15:57:53.9715|X75zFc|LUCASB|OAuth: /api/v3/search/task?_dc=1710863871127 t Transfer: 1220 : 10|15:57:53.9715|X75zFc|LUCASB|GetCurrentUser.. t Transfer: 1220 : 10|15:57:53.9715|X75zFc|LUCASB| OAuth authenticated t Transfer: 1220 : 10|15:57:53.9715|X75zFc|LUCASB| user LUCASB. t Verbose: 1220 : 10|15:57:53.9715|X75zFc|LUCASB|OAuth. User logged in: LUCASB t Information: 1220 : 10|15:57:53.9715|X75zFc|LUCASB|V3Api.SearchTask t Information: 1220 : 10|15:57:53.9715|X75zFc|LUCASB|V3Api.SearchGeneric t Transfer: 1220 : 10|15:57:53.9715|X75zFc|LUCASB|GetCurrentUser.. t Transfer: 1220 : 10|15:57:53.9715|X75zFc|LUCASB| OAuth authenticated t Transfer: 1220 : 10|15:57:53.9715|X75zFc|LUCASB| user LUCASB. t Information: 1220 : 10|15:57:53.9715|2TKT0d|LUCASB|V3Api.SearchTask t Information: 1220 : 10|15:57:53.9715|2TKT0d|LUCASB|V3Api.SearchGeneric t Transfer: 1220 : 10|15:57:53.9715|2TKT0d|LUCASB|GetCurrentUser.. t Transfer: 1220 : 10|15:57:53.9715|2TKT0d|LUCASB| OAuth authenticated t Transfer: 1220 : 10|15:57:53.9715|2TKT0d|LUCASB| user LUCASB. t Information: 1220 : 10|15:57:53.9715|2TKT0d|LUCASB|SearchTask SQL: select * from (select a.*, rownum rnum from ( select /*+ INDEX(j JB_CMBST_IDX) */ /*+ INDEX(j JB_CMBST_IDX) */ j.*, p.pname, mi.MIID1, mi.MIID2, mi.MIID3, mi.VERSIONID1, mi.VERSIONID2, mi.PROGID1, mi.PROGID2, mi.VERSION, u.USER_ID OP_NAME, nvl(j.tech_rptt_id, 0) TECH_REPORT_ID, case when tsk_type=57 then cast(i.DEV_DATA_FMT as varchar2(100)) else '' end TASK_MODE, jj.j_compl_by JOB_COMPL_BY FROM tm_mtask j join tm_mjob jj on jj.id = j.j_id left join tm_mjob_pset p on p.id = jj.j_sched_indx left outer join TM_USERS u on u.id = j.assn_opid left join (select tsk_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 version) VERSION from tm_mis m, tm_mtsk_it i where m.id = i.mi_id and i.src_dest in (2, 3) group by tsk_id) mi on mi.tsk_id = j.id left join tm_mtsk_it i on i.tsk_id = j.id and i.src_dest = 4 and i.item_idx = 1 where 1=1 AND J_FAILURE_RESOLVED = 0 and ( j.area_id=421 OR j.area_id=501 OR j.assn_opid=662 OR j.assn_opid=1245 OR j.assn_opid=442 OR j.area_id=622 OR j.area_id=623 OR j.area_id=624 OR j.assn_opid=702 OR j.assn_opid=422 OR j.assn_opid=515 OR j.area_id=481 OR j.area_id=807 OR j.area_id=561 OR j.area_id=625 OR j.area_id=745 OR j.area_id=826 OR j.area_id=827 OR j.assn_opid=1065 OR j.assn_opid=922 OR j.assn_opid=923 OR j.assn_opid=1086 OR j.assn_opid=1085 OR j.assn_opid=1067 OR j.assn_opid=1105 OR j.area_id=705 OR j.area_id=846 OR j.assn_opid=925 OR j.assn_opid=1005 OR j.assn_opid=928 OR j.assn_opid=927 OR j.area_id=850 OR j.assn_opid=1011 OR j.assn_opid=1012 OR j.assn_opid=946 OR j.assn_opid=969 OR j.area_id=851 OR j.area_id=852 OR j.assn_opid=943 OR j.area_id=845 OR j.area_id=848 OR j.assn_opid=945 OR j.area_id=1 OR j.area_id=321 OR j.area_id=21 OR j.assn_opid=322 OR j.assn_opid=343 OR j.assn_opid=502 OR j.assn_opid=993 OR j.assn_opid=516 OR j.assn_opid=762 OR j.assn_opid=503 OR j.assn_opid=915 OR j.assn_opid=342 OR j.assn_opid=907 OR j.assn_opid=682 OR j.assn_opid=562 OR j.assn_opid=44 OR j.assn_opid=22 OR j.assn_opid=43 OR j.assn_opid=344 OR j.assn_opid=505 OR j.assn_opid=822 OR j.assn_opid=906 OR j.assn_opid=582 OR j.assn_opid=1 OR j.assn_opid=918 OR j.assn_opid=917 OR j.assn_opid=926 OR j.assn_opid=912 OR j.assn_opid=914 OR j.assn_opid=913 OR j.assn_opid=919 OR j.assn_opid=921 OR j.assn_opid=522 OR j.assn_opid=1185 OR j.assn_opid=902 OR j.assn_opid=482 OR j.assn_opid=903 OR j.assn_opid=602 OR j.assn_opid=904 OR j.assn_opid=42 OR j.area_id=2 OR j.area_id=341 OR j.area_id=645 OR j.area_id=646 OR j.area_id=885 OR j.area_id=685 OR j.assn_opid=666 ) and j.TSK_STATUS not in (15,18,23,19) AND j.TSK_CLIENT in ('VODF' , 'VNHD' , 'VNH' , 'VNC' , 'V3H' , 'TVAE' , 'TV3N' , 'TV1S' , '03SM' , 'TV1C' , 'NVA' , '03OR' , 'AMAY' , 'MTG' , 'OSP' , 'PSP' , 'PMH' , 'BT' , 'VODN' , 'VEPL' , 'V4N' , 'TV6N' , 'TV6E' , 'TV1P' , 'TV1F' , 'T6LV' , 'T3LV' , 'RTR' , 'DAVI' , 'CTCE' , '3PLV' , '03SY' , '03SK' , '03SE' , '03JO' , '03GD' , 'AL' , 'ITV' , 'VSG' , 'VSD2' , 'VNE' , 'TV5L' , 'T8LT' , 'Play' , 'MM' , 'HDP2' , 'HDP1' , 'HDC1' , 'CTCB' , 'CS' , '03BO' , 'TV10' , 'AECHD' , 'PPL' , 'SKYCRI' , 'HUB' , 'VSD' , 'VEXE' , 'TVSL' , 'TV8' , 'TV2S' , 'TV1E' , 'TV1B' , 'TV1A' , 'DTV' , 'DMY' , 'DMA' , '03VL' , '03VB' , '03SS' , '03NO' , '03NB' , 'TECHM' , 'PMS' , 'SKYHORSE' , 'MED' , 'SFP1' , 'SFP2' , 'VSS' , 'TMD' , 'VEXR' , 'VEPO' , 'TVDP' , 'TV3S' , '3+ES' , '03SB' , '03HA' , 'NAA' , 'TVONE' , 'BBC' , 'BEDIG' , 'BTS' , 'SKYDART' , 'SKYGOLF' , 'SPG' , 'VSHD' , 'VSE' , 'VS2' , 'VODE' , 'TVPB' , 'TV6S' , 'TV1N' , 'TV1D' , 'NICK' , 'LNT' , 'DMF' , '3PD' , '03VA' , '03SG' , '03NM' , '03LI' , '03GO' , 'EUROSPORT' , 'WCIU' , 'ATP' , 'SKYRUGUN' , 'VS3' , 'VODD' , 'VHIS' , 'V1TZ' , 'TV6H' , 'TV1K' , 'KNVA' , 'MBNS' , 'YLE TV1' , 'LMH' , 'VIVA' , 'OUT' , 'SKY' , 'SKYFOOT' , 'ZTVS' , 'VSAT' , 'VODS' , 'VNPO' , 'VHPO' , 'VEC' , 'V1G' , 'TVPU' , 'AMC' , 'T6LT' , 'T3LT' , 'SPTV' , 'PBOY' , 'KNL2' , 'CENT' , '03VT' , '03UP' , '03SN' , 'TV3D' , '03SC' , 'EST' , 'AECSD' , 'ANTV') order by jj.j_compl_by, j.id , j.id ) a where rownum <= 50) where rnum >= 1 order by rnum t Information: 1220 : 10|15:57:53.9715|X75zFc|LUCASB|SearchTask SQL: select * from (select a.*, rownum rnum from ( select /*+ INDEX(j JB_CMBST_IDX) */ /*+ INDEX(j JB_CMBST_IDX) */ j.*, p.pname, mi.MIID1, mi.MIID2, mi.MIID3, mi.VERSIONID1, mi.VERSIONID2, mi.PROGID1, mi.PROGID2, mi.VERSION, u.USER_ID OP_NAME, nvl(j.tech_rptt_id, 0) TECH_REPORT_ID, case when tsk_type=57 then cast(i.DEV_DATA_FMT as varchar2(100)) else '' end TASK_MODE, jj.j_compl_by JOB_COMPL_BY FROM tm_mtask j join tm_mjob jj on jj.id = j.j_id left join tm_mjob_pset p on p.id = jj.j_sched_indx left outer join TM_USERS u on u.id = j.assn_opid left join (select tsk_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 version) VERSION from tm_mis m, tm_mtsk_it i where m.id = i.mi_id and i.src_dest in (2, 3) group by tsk_id) mi on mi.tsk_id = j.id left join tm_mtsk_it i on i.tsk_id = j.id and i.src_dest = 4 and i.item_idx = 1 where 1=1 AND J_FAILURE_RESOLVED = 0 and ( j.area_id=421 OR j.area_id=501 OR j.assn_opid=662 OR j.assn_opid=1245 OR j.assn_opid=442 OR j.area_id=622 OR j.area_id=623 OR j.area_id=624 OR j.assn_opid=702 OR j.assn_opid=422 OR j.assn_opid=515 OR j.area_id=481 OR j.area_id=807 OR j.area_id=561 OR j.area_id=625 OR j.area_id=745 OR j.area_id=826 OR j.area_id=827 OR j.assn_opid=1065 OR j.assn_opid=922 OR j.assn_opid=923 OR j.assn_opid=1086 OR j.assn_opid=1085 OR j.assn_opid=1067 OR j.assn_opid=1105 OR j.area_id=705 OR j.area_id=846 OR j.assn_opid=925 OR j.assn_opid=1005 OR j.assn_opid=928 OR j.assn_opid=927 OR j.area_id=850 OR j.assn_opid=1011 OR j.assn_opid=1012 OR j.assn_opid=946 OR j.assn_opid=969 OR j.area_id=851 OR j.area_id=852 OR j.assn_opid=943 OR j.area_id=845 OR j.area_id=848 OR j.assn_opid=945 OR j.area_id=1 OR j.area_id=321 OR j.area_id=21 OR j.assn_opid=322 OR j.assn_opid=343 OR j.assn_opid=502 OR j.assn_opid=993 OR j.assn_opid=516 OR j.assn_opid=762 OR j.assn_opid=503 OR j.assn_opid=915 OR j.assn_opid=342 OR j.assn_opid=907 OR j.assn_opid=682 OR j.assn_opid=562 OR j.assn_opid=44 OR j.assn_opid=22 OR j.assn_opid=43 OR j.assn_opid=344 OR j.assn_opid=505 OR j.assn_opid=822 OR j.assn_opid=906 OR j.assn_opid=582 OR j.assn_opid=1 OR j.assn_opid=918 OR j.assn_opid=917 OR j.assn_opid=926 OR j.assn_opid=912 OR j.assn_opid=914 OR j.assn_opid=913 OR j.assn_opid=919 OR j.assn_opid=921 OR j.assn_opid=522 OR j.assn_opid=1185 OR j.assn_opid=902 OR j.assn_opid=482 OR j.assn_opid=903 OR j.assn_opid=602 OR j.assn_opid=904 OR j.assn_opid=42 OR j.area_id=2 OR j.area_id=341 OR j.area_id=645 OR j.area_id=646 OR j.area_id=885 OR j.area_id=685 OR j.assn_opid=666 ) and j.TSK_STATUS not in (15,18,23,19) AND j.TSK_CLIENT in ('VODF' , 'VNHD' , 'VNH' , 'VNC' , 'V3H' , 'TVAE' , 'TV3N' , 'TV1S' , '03SM' , 'TV1C' , 'NVA' , '03OR' , 'AMAY' , 'MTG' , 'OSP' , 'PSP' , 'PMH' , 'BT' , 'VODN' , 'VEPL' , 'V4N' , 'TV6N' , 'TV6E' , 'TV1P' , 'TV1F' , 'T6LV' , 'T3LV' , 'RTR' , 'DAVI' , 'CTCE' , '3PLV' , '03SY' , '03SK' , '03SE' , '03JO' , '03GD' , 'AL' , 'ITV' , 'VSG' , 'VSD2' , 'VNE' , 'TV5L' , 'T8LT' , 'Play' , 'MM' , 'HDP2' , 'HDP1' , 'HDC1' , 'CTCB' , 'CS' , '03BO' , 'TV10' , 'AECHD' , 'PPL' , 'SKYCRI' , 'HUB' , 'VSD' , 'VEXE' , 'TVSL' , 'TV8' , 'TV2S' , 'TV1E' , 'TV1B' , 'TV1A' , 'DTV' , 'DMY' , 'DMA' , '03VL' , '03VB' , '03SS' , '03NO' , '03NB' , 'TECHM' , 'PMS' , 'SKYHORSE' , 'MED' , 'SFP1' , 'SFP2' , 'VSS' , 'TMD' , 'VEXR' , 'VEPO' , 'TVDP' , 'TV3S' , '3+ES' , '03SB' , '03HA' , 'NAA' , 'TVONE' , 'BBC' , 'BEDIG' , 'BTS' , 'SKYDART' , 'SKYGOLF' , 'SPG' , 'VSHD' , 'VSE' , 'VS2' , 'VODE' , 'TVPB' , 'TV6S' , 'TV1N' , 'TV1D' , 'NICK' , 'LNT' , 'DMF' , '3PD' , '03VA' , '03SG' , '03NM' , '03LI' , '03GO' , 'EUROSPORT' , 'WCIU' , 'ATP' , 'SKYRUGUN' , 'VS3' , 'VODD' , 'VHIS' , 'V1TZ' , 'TV6H' , 'TV1K' , 'KNVA' , 'MBNS' , 'YLE TV1' , 'LMH' , 'VIVA' , 'OUT' , 'SKY' , 'SKYFOOT' , 'ZTVS' , 'VSAT' , 'VODS' , 'VNPO' , 'VHPO' , 'VEC' , 'V1G' , 'TVPU' , 'AMC' , 'T6LT' , 'T3LT' , 'SPTV' , 'PBOY' , 'KNL2' , 'CENT' , '03VT' , '03UP' , '03SN' , 'TV3D' , '03SC' , 'EST' , 'AECSD' , 'ANTV') order by jj.j_compl_by, j.id , j.id ) a where rownum <= 50) where rnum >= 1 order by rnum t Verbose: 1220 : 10|15:57:53.9715|X75zFc|LUCASB|imfx v3 API took 0.111s '/api/v3/search/task?_dc=1710863871127' t Verbose: 1220 : 10|15:57:53.9715|2TKT0d|LUCASB|imfx v3 API took 0.134s '/api/v3/search/task?_dc=1710863871126' t Transfer: 1220 : 10|15:57:54.1901|8f7jCf|LUCASB|OAuth: /api/user-preferences?_dc=1710863873748 t Transfer: 1220 : 10|15:57:54.1901|8f7jCf|LUCASB|GetCurrentUser.. t Transfer: 1220 : 10|15:57:54.1901|8f7jCf|LUCASB| OAuth authenticated t Transfer: 1220 : 10|15:57:54.1901|8f7jCf|LUCASB| user LUCASB. t Verbose: 1220 : 10|15:57:54.1901|8f7jCf|LUCASB|OAuth. User logged in: LUCASB t Verbose: 1220 : 10|15:57:54.1901|8f7jCf|LUCASB|StoreUserDataByKeys.. t Transfer: 1220 : 10|15:57:54.1901|8f7jCf|LUCASB|GetCurrentUser.. t Transfer: 1220 : 10|15:57:54.1901|8f7jCf|LUCASB| OAuth authenticated t Transfer: 1220 : 10|15:57:54.1901|8f7jCf|LUCASB| user LUCASB. t Verbose: 1220 : 10|15:57:54.1901|8f7jCf|LUCASB|imfx v3 API took 0.011s '/api/user-preferences?_dc=1710863873748' t Information: 1220 : 10|22:09:55.0526|||OrabitWatcherBasic. Disposing. t Information: 1220 : 10|22:09:55.0526|||OrabitWatcherBasic. Disposed. t Information: 1220 : 10|22:09:55.0526|||========================================================================== t Information: 1220 : 10|22:09:55.0526|||IMFX CORE SERVER APPLICATION END.