GSM Action Items Error
Trey Jul 11, 2019 6:57 PMThis 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