1 Reply Latest reply on Jul 12, 2019 3:04 AM by Ivy Zhu-Oracle

    GSM Action Items Error

    Trey

      This is user is getting this error when trying to open GSM Action Items. OwnerId = '2053bc9a0ef6-1dec-4e34-b028-f534e35a6252'

      If I query gsmSpecOwners it returns 2,171 rows for this user. Anyone know how I can tell which SpecID is causing the error on the GSM Action Items?

       

      App: GSM| SessionId: 8ed4df7b-74e9-7c9e-df9f-580105d2bcb2| UserId: boyettti| IsNewSession: False| ServerID: 10.31.11.20| Misc: |  Exception: System.Web.HttpUnhandledException: Exception of type 'System.Web.HttpUnhandledException' was thrown. ---> System.NullReferenceException: Object reference not set to an instance of an object.   at Xeno.Prodika.Services.Specification.ActionItems.ActionItemsFetcherFactory.ActionItemsFetcher.GetSpecActionItems(IApplicationManager manager, String lang)   at Xeno.Prodika.Services.Specification.ActionItems.ActionItemsFetcherFactory.ActionItemsFetcher.GetActionItems(Object customArgs)   at Xeno.Prodika.WorkflowCommon.Service.WorkflowCommonService.GetActionItems(String entityTypeID, Object customArgs)   at prodika.frmActionItems.OnLoad(EventArgs e)   at System.Web.UI.Control.LoadRecursive()   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)   --- End of inner exception stack trace ---   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.ProcessRequest(HttpContext context)   at ASP.baseforms_frmactionitems_aspx.ProcessRequest(HttpContext context)   at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()   at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)'

       

      I tried using this sql which includes IsHidden, but still get 190 specs.

       

      select *

      from specSummary specSummary

      INNER JOIN gsmSpecOwners gsmSpecOwners ON gsmSpecOwners.fkSpecsummary = specSummary.PKID

      INNER JOIN Users Users ON Users.PKID =  gsmSpecOwners.OwnerID

      INNER JOIN commonWorkflowStatus cwf ON specsummary.SpecStatusID = cwf.pkid

      where gsmSpecOwners.OwnerID = '2053bc9a0ef6-1dec-4e34-b028-f534e35a6252'

      and specSummary.IsHidden = 1