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