cancel
Showing results for 
Search instead for 
Did you mean: 
lonesurvivor
Nintex Newbie

Filtering in a ListView is not working if field to filter is an additional lookup-field

Hi everybody,


I just came to a weird behaviour of the List View-Control in my Nintex Form. I do have a Lookup-Field named "Project" with an additional field "Project:ID" in my list.

In my Nintex Form I added a List View which I wanted to filter to the field "Project:ID" by specified value of the current Item's ID.

 

If I open the form in preview-mode, I get an errormessage which says "Cannot complete this action. Please try again.".

 

In the SharePoint-Log the Trace is like following:

Spoiler
SPRequest.GetListItemDataWithCallback2: UserPrincipalName=i:0).w|s-1-5-21-435809281-806517502-2525237208-368890, AppPrincipalName= ,pSqlClient=<null> ,bstrUrl=http://spsq2.xxx.com/teamsite/5510 ,bstrListName={B4F6AF12-3219-459C-9DE3-41A10A354F9C} ,bstrViewName=<null> ,bstrViewXml=<View><Query><OrderBy><FieldRef Name="Title" /></OrderBy><Where><Eq><FieldRef Name="Project_x003a_ID" LookupId="TRUE" /><Value Type="Lookup">1</Value></Eq></Where></Query><ViewFields><FieldRef Name="ID"/><FieldRef Name="PermMask"/><FieldRef Name="FSObjType"/><FieldRef Name="Title"/><FieldRef Name="F ,fSafeArrayFlags=SAFEARRAYFLAG_AUTOHYPERLINK 0248bd9e-7443-4050-bf06-6ba8298434a2
02/06/2019 11:21:05.79 w3wp.exe (0x31E4) 0x100C SharePoint Foundation General ai1wu Medium System.Runtime.InteropServices.COMException: Cannot complete this action. Please try again., StackTrace: at Microsoft.SharePoint.SPListItemCollection.EnsureListItemsData() at Microsoft.SharePoint.SPListItemCollection.get_Count() at Microsoft.SharePoint.WebControls.SPDataSourceView.ExecuteSelect(DataSourceSelectArguments selectArguments, String aggregateString, Boolean wantReturn, BaseXsltListWebPart webpart, SPListItem& listItem, SPListItemCollection& listItems, String[]& fieldList) at Microsoft.SharePoint.WebControls.SingleDataSource.GetXPathNavigatorInternal() at Microsoft.SharePoint.WebControls.SingleDataSource.GetXPathNavigator() at Microsoft.SharePoint.WebPartPages.DataFormWebPart.PrepareAndPerformTransform(Boolean bDeferExecuteTransform) at Microsoft.Share... 0248bd9e-7443-4050-bf06-6ba8298434a2
02/06/2019 11:21:05.79* w3wp.exe (0x31E4) 0x100C SharePoint Foundation General ai1wu Medium ...Point.WebPartPages.DataFormWebPart.PerformSelect() at Microsoft.SharePoint.WebPartPages.DataFormWebPart.DataBind() at Microsoft.SharePoint.WebPartPages.DataFormWebPart.EnsureDataBound() at Microsoft.SharePoint.WebPartPages.DataFormWebPart.CreateChildControls() at Microsoft.SharePoint.WebPartPages.XsltListViewWebPart.CreateChildControls() at Microsoft.SharePoint.WebPartPages.WebPartMobileAdapter.CreateChildControls() at System.Web.UI.Control.EnsureChildControls() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.U... 0248bd9e-7443-4050-bf06-6ba8298434a2
02/06/2019 11:21:05.79* w3wp.exe (0x31E4) 0x100C SharePoint Foundation General ai1wu Medium ...I.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at ... 0248bd9e-7443-4050-bf06-6ba8298434a2
02/06/2019 11:21:05.79* w3wp.exe (0x31E4) 0x100C SharePoint Foundation General ai1wu Medium ...System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() 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 System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() ... 0248bd9e-7443-4050-bf06-6ba8298434a2
02/06/2019 11:21:05.79* w3wp.exe (0x31E4) 0x100C SharePoint Foundation General ai1wu Medium ... at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) at System.Web.HttpApplication.PipelineStepManager.ResumeSteps(Exception error) at System.Web.HttpApplication.BeginProcessRequestNotification(HttpContext context, AsyncCallback cb) at System.Web.HttpRuntime.ProcessRequestNotificationPrivate(IIS7WorkerRequest wr, HttpContext context) at System.Web.Hosting.PipelineRuntime.ProcessRequestNotificationHelper(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags) at System.Web.Hosting.PipelineRuntime.ProcessRequestNotification(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags) at System.Web.Hosting.UnsafeIISMethods.MgdIndicateCompletion(IntPtr pHandler, Re... 0248bd9e-7443-4050-bf06-6ba8298434a2
02/06/2019 11:21:05.79* w3wp.exe (0x31E4) 0x100C SharePoint Foundation General ai1wu Medium ...questNotificationStatus& notificationStatus) at System.Web.Hosting.UnsafeIISMethods.MgdIndicateCompletion(IntPtr pHandler, RequestNotificationStatus& notificationStatus) at System.Web.Hosting.PipelineRuntime.ProcessRequestNotificationHelper(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags) at System.Web.Hosting.PipelineRuntime.ProcessRequestNotification(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags) 0248bd9e-7443-4050-bf06-6ba8298434a2
02/06/2019 11:21:05.79 w3wp.exe (0x31E4) 0x100C SharePoint Foundation Web Parts 89a1 High Error while executing web part: Microsoft.SharePoint.SPException: Cannot complete this action. Please try again. ---> System.Runtime.InteropServices.COMException: Cannot complete this action. Please try again. at Microsoft.SharePoint.Library.SPRequestInternalClass.GetListItemDataWithCallback2(IListItemSqlClient pSqlClient, String bstrUrl, String bstrListName, String bstrViewName, String bstrViewXml, SAFEARRAYFLAGS fSafeArrayFlags, ISP2DSafeArrayWriter pSACallback, ISPDataCallback pPagingCallback, ISPDataCallback pPagingPrevCallback, ISPDataCallback pFilterLinkCallback, ISPDataCallback pSchemaCallback, ISPDataCallback pRowCountCallback, Boolean& pbMaximalView) at Microsoft.SharePoint.Library.SPRequest.GetListItemDataWithCallback2(IListItemSqlClient pSqlClient, String bstrUrl, Stri... 0248bd9e-7443-4050-bf06-6ba8298434a2
02/06/2019 11:21:05.79* w3wp.exe (0x31E4) 0x100C SharePoint Foundation Web Parts 89a1 High ...ng bstrListName, String bstrViewName, String bstrViewXml, SAFEARRAYFLAGS fSafeArrayFlags, ISP2DSafeArrayWriter pSACallback, ISPDataCallback pPagingCallback, ISPDataCallback pPagingPrevCallback, ISPDataCallback pFilterLinkCallback, ISPDataCallback pSchemaCallback, ISPDataCallback pRowCountCallback, Boolean& pbMaximalView) --- End of inner exception stack trace --- at Microsoft.SharePoint.SPGlobal.HandleComException(COMException comEx) at Microsoft.SharePoint.Library.SPRequest.GetListItemDataWithCallback2(IListItemSqlClient pSqlClient, String bstrUrl, String bstrListName, String bstrViewName, String bstrViewXml, SAFEARRAYFLAGS fSafeArrayFlags, ISP2DSafeArrayWriter pSACallback, ISPDataCallback pPagingCallback, ISPDataCallback pPagingPrevCallback, ISPDataCallback pFilterLinkCallbac... 0248bd9e-7443-4050-bf06-6ba8298434a2
02/06/2019 11:21:05.79* w3wp.exe (0x31E4) 0x100C SharePoint Foundation Web Parts 89a1 High ...k, ISPDataCallback pSchemaCallback, ISPDataCallback pRowCountCallback, Boolean& pbMaximalView) at Microsoft.SharePoint.SPListItemCollection.EnsureListItemsData() at Microsoft.SharePoint.SPListItemCollection.get_Count() at Microsoft.SharePoint.WebControls.SPDataSourceView.ExecuteSelect(DataSourceSelectArguments selectArguments, String aggregateString, Boolean wantReturn, BaseXsltListWebPart webpart, SPListItem& listItem, SPListItemCollection& listItems, String[]& fieldList) at Microsoft.SharePoint.WebControls.SingleDataSource.GetXPathNavigatorInternal() at Microsoft.SharePoint.WebControls.SingleDataSource.GetXPathNavigator() at Microsoft.SharePoint.WebPartPages.DataFormWebPart.PrepareAndPerformTransform(Boolean bDeferExecuteTransform) 0248bd9e-7443-4050-bf06-6ba8298434a2
02/06/2019 11:21:05.79 w3wp.exe (0x31E4) 0x100C SharePoint Foundation Web Parts 89a2 High InnerException 1: System.Runtime.InteropServices.COMException (0x80004005): Cannot complete this action. Please try again. at Microsoft.SharePoint.Library.SPRequestInternalClass.GetListItemDataWithCallback2(IListItemSqlClient pSqlClient, String bstrUrl, String bstrListName, String bstrViewName, String bstrViewXml, SAFEARRAYFLAGS fSafeArrayFlags, ISP2DSafeArrayWriter pSACallback, ISPDataCallback pPagingCallback, ISPDataCallback pPagingPrevCallback, ISPDataCallback pFilterLinkCallback, ISPDataCallback pSchemaCallback, ISPDataCallback pRowCountCallback, Boolean& pbMaximalView) at Microsoft.SharePoint.Library.SPRequest.GetListItemDataWithCallback2(IListItemSqlClient pSqlClient, String bstrUrl, String bstrListName, String bstrViewName, String bstrViewXml, SAFEARRAYFLAGS fSafeArrayFlags... 0248bd9e-7443-4050-bf06-6ba8298434a2
02/06/2019 11:21:05.79* w3wp.exe (0x31E4) 0x100C SharePoint Foundation Web Parts 89a2 High ..., ISP2DSafeArrayWriter pSACallback, ISPDataCallback pPagingCallback, ISPDataCallback pPagingPrevCallback, ISPDataCallback pFilterLinkCallback, ISPDataCallback pSchemaCallback, ISPDataCallback pRowCountCallback, Boolean& pbMaximalView) 0248bd9e-7443-4050-bf06-6ba8298434a2
02/06/2019 11:21:05.80 w3wp.exe (0x31E4) 0x100C SharePoint Foundation Database adhpr Medium Entering Monitored Scope (VqueryEngine). Parent=SPRequest.GetListItemDataWithCallback 0248bd9e-7443-4050-bf06-6ba8298434a2
02/06/2019 11:21:05.80 w3wp.exe (0x31E4) 0x100C SharePoint Foundation Database adhpr Medium Leaving Monitored Scope: (VqueryEngine) Execution Time=3.6315; CPU Milliseconds=2; SQL Query Count=1; Parent=SPRequest.GetListItemDataWithCallback 0248bd9e-7443-4050-bf06-6ba8298434a2
02/06/2019 11:21:05.80 w3wp.exe (0x31E4) 0x100C SharePoint Foundation Asp Runtime avwhw Medium SPRequestModule.ErrorAppHandler Begin 0248bd9e-7443-4050-bf06-6ba8298434a2
02/06/2019 11:21:05.80 w3wp.exe (0x31E4) 0x100C SharePoint Foundation General 8nca Medium Application error when access /teamsite/5510/Lists/Projects/DispForm.aspx, Error=Data at the root level is invalid. Line 1, position 1. at System.Xml.XmlTextReaderImpl.Throw(Exception e) at System.Xml.XmlTextReaderImpl.ParseRootLevelWhitespace() at System.Xml.XmlTextReaderImpl.ParseDocumentContent() at System.Xml.XmlReader.MoveToContent() at Microsoft.SharePoint.SPFieldMap.InitFromSchema(String strSchema) at Microsoft.SharePoint.SPListItemVersionCollection.EnsureVersionsData() at Microsoft.SharePoint.SPBaseCollection.GetEnumerator() at Nintex.Forms.SharePoint.ControlTemplates.FormFooter.OnPreRender(EventArgs e) at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRen... 0248bd9e-7443-4050-bf06-6ba8298434a2
02/06/2019 11:21:05.80* w3wp.exe (0x31E4) 0x100C SharePoint Foundation General 8nca Medium ...derRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoin... 0248bd9e-7443-4050-bf06-6ba8298434a2
02/06/2019 11:21:05.80* w3wp.exe (0x31E4) 0x100C SharePoint Foundation General 8nca Medium ...t, Boolean includeStagesAfterAsyncPoint) 0248bd9e-7443-4050-bf06-6ba8298434a2
02/06/2019 11:21:05.80 w3wp.exe (0x31E4) 0x100C SharePoint Foundation Runtime tkau Unexpected System.Xml.XmlException: Data at the root level is invalid. Line 1, position 1. at System.Xml.XmlTextReaderImpl.Throw(Exception e) at System.Xml.XmlTextReaderImpl.ParseRootLevelWhitespace() at System.Xml.XmlTextReaderImpl.ParseDocumentContent() at System.Xml.XmlReader.MoveToContent() at Microsoft.SharePoint.SPFieldMap.InitFromSchema(String strSchema) at Microsoft.SharePoint.SPListItemVersionCollection.EnsureVersionsData() at Microsoft.SharePoint.SPBaseCollection.GetEnumerator() at Nintex.Forms.SharePoint.ControlTemplates.FormFooter.OnPreRender(EventArgs e) at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.Pre... 0248bd9e-7443-4050-bf06-6ba8298434a2
02/06/2019 11:21:05.80* w3wp.exe (0x31E4) 0x100C SharePoint Foundation Runtime tkau Unexpected ...RenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) 0248bd9e-7443-4050-bf06-6ba8298434a2
02/06/2019 11:21:05.80 w3wp.exe (0x31E4) 0x100C SharePoint Foundation General ajlz0 High Getting Error Message for Exception System.Web.HttpUnhandledException (0x80004005): Exception of type 'System.Web.HttpUnhandledException' was thrown. ---> System.Xml.XmlException: Data at the root level is invalid. Line 1, position 1. at System.Xml.XmlTextReaderImpl.Throw(Exception e) at System.Xml.XmlTextReaderImpl.ParseRootLevelWhitespace() at System.Xml.XmlTextReaderImpl.ParseDocumentContent() at System.Xml.XmlReader.MoveToContent() at Microsoft.SharePoint.SPFieldMap.InitFromSchema(String strSchema) at Microsoft.SharePoint.SPListItemVersionCollection.EnsureVersionsData() at Microsoft.SharePoint.SPBaseCollection.GetEnumerator() at Nintex.Forms.SharePoint.ControlTemplates.FormFooter.OnPreRender(EventArgs e) at System.Web.UI.Control.PreRenderRecursiveInt... 0248bd9e-7443-4050-bf06-6ba8298434a2
02/06/2019 11:21:05.80* w3wp.exe (0x31E4) 0x100C SharePoint Foundation General ajlz0 High ...ernal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRender... 0248bd9e-7443-4050-bf06-6ba8298434a2
02/06/2019 11:21:05.80* w3wp.exe (0x31E4) 0x100C SharePoint Foundation General ajlz0 High ...RecursiveInternal() 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.ProcessRequest(HttpContext context) at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) 0248bd9e-7443-4050-bf06-6ba8298434a2
02/06/2019 11:21:05.80 w3wp.exe (0x31E4) 0x100C SharePoint Foundation WOPI aw5fv Medium...

Any ideas?

 

Greetings from Nuremberg
Ricky

 

Labels: (1)
0 Kudos
Reply
1 Reply
fccrous
Nintex Newbie

Re: Filtering in a ListView is not working if field to filter is an additional lookup-field

Hello Ricky,

 

If you look at the log, there is one thing that is telling me something (Error=Data at the root level is invalid.) 

1.Are you sure that the value type you are using for the lookup is the same type as the value you are filtering on

2.Are you sure that there are no spaces or different characters in the two fields you are using?  To test this you can remove the filter for now and try and display the two values with calculated fields on your form.

 

Greetings from South Africa Smiley Happy

Francois

0 Kudos
Reply