Related Items and multiple values
Dear Support,
i have a n:n relation from locations to contacts.
The "contacts" content type has a site colum "related locations" with a value type of spfieldlookupvalueCollection.
When i create a related items control in the locations list form and link to contacts via the usual "form-field" + "list field" mechanism i get a runtime error when the display form is rendered:
Q: Does the related items control support n:n relationship at all and is there a workaround?
Thanks,
Armin
--
07/14/2016 10:04:52.61 w3wp.exe (0x069C) 0x6ACC SharePoint Foundation Fields tknl High Type mismatch with field Related_x0020_Locations and value Location NY WEST. cba98f9d-b927-d02b-bbe5-cf32f703890a
07/14/2016 10:04:52.61 w3wp.exe (0x069C) 0x6ACC SharePoint Foundation Database 880i High System.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near ')'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String rese... cba98f9d-b927-d02b-bbe5-cf32f703890a
07/14/2016 10:04:52.61* w3wp.exe (0x069C) 0x6ACC SharePoint Foundation Database 880i High ...tOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) at Microsof... cba98f9d-b927-d02b-bbe5-cf32f703890a
07/14/2016 10:04:52.61* w3wp.exe (0x069C) 0x6ACC SharePoint Foundation Database 880i High ...t.SharePoint.Utilities.SqlSession.ExecuteReader(SqlCommand command, CommandBehavior behavior, SqlQueryData monitoringData, Boolean retryForDeadLock) ClientConnectionId:fa9a2545-5a8a-4076-bed0-ac1e9fafa808 Error Number:102,State:1,Class:15 cba98f9d-b927-d02b-bbe5-cf32f703890a
07/14/2016 10:04:52.61 w3wp.exe (0x069C) 0x6ACC SharePoint Foundation Database 880k High at Microsoft.SharePoint.SPSqlClient.ExecuteQueryInternal(Boolean retryfordeadlock) at Microsoft.SharePoint.SPSqlClient.ExecuteQuery(Boolean retryfordeadlock) 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.SPRequestInternalClass.GetListItemDataWithCallback2(IListItemSqlClient pSqlClient, String bstrUrl, String bstrListName, String bstrViewNa... cba98f9d-b927-d02b-bbe5-cf32f703890a
07/14/2016 10:04:52.61* w3wp.exe (0x069C) 0x6ACC SharePoint Foundation Database 880k High ...me, 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, ISP2DSafeArrayWriter pSACallback, ISPDataCallback pPagingCallback, ISPDataCallback pPagingPrevCallback, ISPDataCallback pFilterLinkCallback, ISPDataCallback pSchemaCallback, ISPDataCallback pRowCountCallback, Boolean& pbMaximalView) at Microsoft.SharePoint.SPListItemCollection.EnsureListIte... cba98f9d-b927-d02b-bbe5-cf32f703890a
07/14/2016 10:04:52.61* w3wp.exe (0x069C) 0x6ACC SharePoint Foundation Database 880k High ...msData() 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.SharePoint.WebPartPages.DataFormWebPart.DataBind() at Microsoft.SharePoint.WebPartPages.DataFormWebPart.CreateChildControls() at Microsoft.SharePoint.WebPartPages.X... cba98f9d-b927-d02b-bbe5-cf32f703890a
07/14/2016 10:04:52.61* w3wp.exe (0x069C) 0x6ACC SharePoint Foundation Database 880k High ...sltListViewWebPart.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.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 includeS... cba98f9d-b927-d02b-bbe5-cf32f703890a
07/14/2016 10:04:52.61* w3wp.exe (0x069C) 0x6ACC SharePoint Foundation Database 880k High ...tagesAfterAsyncPoint) 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) 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) ... cba98f9d-b927-d02b-bbe5-cf32f703890a
07/14/2016 10:04:52.61* w3wp.exe (0x069C) 0x6ACC SharePoint Foundation Database 880k High ... at System.Web.Hosting.PipelineRuntime.ProcessRequestNotification(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags) at System.Web.Hosting.UnsafeIISMethods.MgdIndicateCompletion(IntPtr pHandler, RequestNotificationStatus& 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) cba98f9d-b927-d02b-bbe5-cf32f703890a
07/14/2016 10:04:52.61 w3wp.exe (0x069C) 0x6ACC SharePoint Foundation Database 880j High SqlError: 'Incorrect syntax near ')'.' Source: '.Net SqlClient Data Provider' Number: 102 State: 1 Class: 15 Procedure: '' LineNumber: 1 Server: 'sp2013dbsvr1' cba98f9d-b927-d02b-bbe5-cf32f703890a
07/14/2016 10:04:52.61 w3wp.exe (0x069C) 0x6ACC SharePoint Foundation Database 5586 Critical Unknown SQL Exception 102 occurred. Additional error information from SQL Server is included below. Incorrect syntax near ')'. cba98f9d-b927-d02b-bbe5-cf32f703890a
07/14/2016 10:04:52.61 w3wp.exe (0x069C) 0x6ACC SharePoint Foundation Database tzku High ConnectionString: 'Data Source=sp2013dbsvr1;Initial Catalog=WSS_Content_sfus2;Integrated Security=True;Persist Security Info=False;Enlist=False;Pooling=True;Min Pool Size=0;Max Pool Size=100;Asynchronous Processing=False;Connection Reset=True;MultipleActiveResultSets=False;Replication=False;Connect Timeout=15;Encrypt=False;TrustServerCertificate=False;Load Balance Timeout=0;Packet Size=8000;Type System Version=Latest;Application Name=".Net SqlClient Data Provider";User Instance=False;Context Connection=False;Transaction Binding="Implicit Unbind";ApplicationIntent=ReadWrite;MultiSubnetFailover=False;ConnectRetryCount=1;ConnectRetryInterval=10' Partition: 11bcfac8-00a6-4aa1-aaed-bc050c5775c2 ConnectionState: Closed ConnectionTimeout: 15 cba98f9d-b927-d02b-bbe5-cf32f703890a
07/14/2016 10:04:52.61 w3wp.exe (0x069C) 0x6ACC SharePoint Foundation Database tzkv High SqlCommand: 'DECLARE @DocParentIdForRF uniqueidentifier SELECT TOP 1 @DocParentIdForRF = Docs.Id FROM TVF_Docs_Url(@SITEID, @FDN, @FLN) AS Docs; SELECT TOP(@NUMROWS) t1.[TimeCreated] AS c18, t1.[Type] AS c0, UserData.[tp_Modified], CASE WHEN DATALENGTH(t1.DirName) = 0 THEN t1.LeafName WHEN DATALENGTH(t1.LeafName) = 0 THEN t1.DirName ELSE t1.DirName + N'/' + t1.LeafName END AS c2, UserData.[tp_ContentTypeId], UserData.[tp_ID], t1.[SortBehavior] AS c1, UserData.[tp_ModerationStatus], UserData.[tp_Level], UserData.[nvarchar1], t1.[LeafName] AS c17, t1.[ScopeId] AS c5, UserData.[nvarchar2] FROM AllUserData AS UserData WITH(FORCESEEK(AllUserData_PK(tp_SiteId,tp_ListId,tp_DeleteTransactionId,tp_IsCurrentVersion))) LEFT OUTER LOOP JOIN Docs AS t1 WITH(NOLOCK) ON (UserData.[tp_CalculatedVersion]... cba98f9d-b927-d02b-bbe5-cf32f703890a
07/14/2016 10:04:52.61* w3wp.exe (0x069C) 0x6ACC SharePoint Foundation Database tzkv High ... = 0 ) AND (UserData.[tp_IsCurrentVersion] = CONVERT(bit,1) ) AND (UserData.[tp_DeleteTransactionId] = 0x ) AND (UserData.[tp_RowOrdinal] = 0) AND (t1.SiteId=UserData.tp_SiteId) AND (t1.SiteId = @SITEID) AND (t1.ParentId = UserData.tp_ParentId) AND (t1.Id = UserData.tp_DocId) AND ( (UserData.tp_Level = 1) ) AND (t1.Level = UserData.tp_Level) AND (t1.IsCurrentVersion = 1) AND (t1.Level = 1 OR t1.Level = 2) AND (UserData.[tp_IsCurrentVersion] = CONVERT(bit,1) ) AND (UserData.[tp_CalculatedVersion] = 0 ) AND (UserData.[tp_DeleteTransactionId] = 0x ) WHERE (UserData.tp_ListID=@LISTID) AND (UserData.tp_SiteId=@SITEID) AND ( (UserData.tp_Level = 1) ) AND (UserData.tp_SiteId=@SITEID AND (UserData.tp_ParentId=@DocParentIdForRF)) AND (UserData.tp_RowOrdinal=0) AND ((0 = 1))) ) AND t1.SiteId=@SITEI... cba98f9d-b927-d02b-bbe5-cf32f703890a
07/14/2016 10:04:52.61* w3wp.exe (0x069C) 0x6ACC SharePoint Foundation Database tzkv High ...D AND (t1.ParentId=@DocParentIdForRF)) ORDER BY UserData.[tp_ID] ASC OPTION (FORCE ORDER, MAXDOP 1)' CommandType: Text CommandTimeout: 0 Parameter: '@LFFP' Type: UniqueIdentifier Size: 0 Direction: Input Value: '00000000-0000-0000-0000-000000000000' Parameter: '@SITEID' Type: UniqueIdentifier Size: 0 Direction: Input Value: '11bcfac8-00a6-4aa1-aaed-bc050c5775c2' Parameter: '@FDN' Type: NVarChar Size: 4000 Direction: Input Value: 'sites/sfus2/Lists' Parameter: '@FLN' Type: NVarChar Size: 4000 Direction: Input Value: 'Contacts' Parameter: '@LISTID' Type: UniqueIdentifier Size: 0 Direction: Input Value: 'dffcfe8e-74e1-441d-81e4-94520ec085e9' Parameter: '@NUMROWS' Type: BigInt Size: 0 Direction: Input Value: '31' Parameter: '@RequestGuid' Type: UniqueIdentifie... cba98f9d-b927-d02b-bbe5-cf32f703890a
07/14/2016 10:04:52.61* w3wp.exe (0x069C) 0x6ACC SharePoint Foundation Database tzkv High ...r Size: 0 Direction: Input Value: 'cba98f9d-b927-d02b-bbe5-cf32f703890a' cba98f9d-b927-d02b-bbe5-cf32f703890a
07/14/2016 10:04:52.61 w3wp.exe (0x069C) 0x6ACC SharePoint Foundation Database aek90 High SecurityOnOperationCheck = True cba98f9d-b927-d02b-bbe5-cf32f703890a
07/14/2016 10:04:52.61 w3wp.exe (0x069C) 0x6ACC SharePoint Foundation Database d0d6 High System.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near ')'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String rese... cba98f9d-b927-d02b-bbe5-cf32f703890a
07/14/2016 10:04:52.61* w3wp.exe (0x069C) 0x6ACC SharePoint Foundation Database d0d6 High ...tOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) at Microsof... cba98f9d-b927-d02b-bbe5-cf32f703890a
07/14/2016 10:04:52.61* w3wp.exe (0x069C) 0x6ACC SharePoint Foundation Database d0d6 High ...t.SharePoint.Utilities.SqlSession.ExecuteReader(SqlCommand command, CommandBehavior behavior, SqlQueryData monitoringData, Boolean retryForDeadLock) at Microsoft.SharePoint.SPSqlClient.ExecuteQueryInternal(Boolean retryfordeadlock) at Microsoft.SharePoint.SPSqlClient.ExecuteQuery(Boolean retryfordeadlock) ClientConnectionId:fa9a2545-5a8a-4076-bed0-ac1e9fafa808 Error Number:102,State:1,Class:15 cba98f9d-b927-d02b-bbe5-cf32f703890a
07/14/2016 10:04:52.61 w3wp.exe (0x069C) 0x6ACC SharePoint Foundation Database ad194 High ExecuteQuery failed with original error 0x80131904 cba98f9d-b927-d02b-bbe5-cf32f703890a
07/14/2016 10:04:52.61 w3wp.exe (0x069C) 0x6ACC SharePoint Foundation General xxpm High Unable to execute query: Error 0x80131904 cba98f9d-b927-d02b-bbe5-cf32f703890a
07/14/2016 10:04:52.61 w3wp.exe (0x069C) 0x6ACC SharePoint Foundation General 8e2s Medium Unknown SPRequest error occurred. More information: 0x80131904 cba98f9d-b927-d02b-bbe5-cf32f703890a
07/14/2016 10:04:52.61 w3wp.exe (0x069C) 0x6ACC SharePoint Foundation General aix9j High SPRequest.GetListItemDataWithCallback2: UserPrincipalName=i:0).w|s-1-5-21-2582922058-3218278914-315117220-1149, AppPrincipalName= ,pSqlClient=<null> ,bstrUrl=https://ecm.xxx.com/sites/sfus2 ,bstrListName={DFFCFE8E-74E1-441D-81E4-94520EC085E9} ,bstrViewName=<null> ,bstrViewXml=<View><Query><OrderBy><FieldRef Name="ID" /></OrderBy><Where><Eq><FieldRef Name="Related_x0020_Locations" /><Value Type="LookupMulti">Location NY WEST</Value></Eq></Where></Query><ViewFields><FieldRef Name="ID" /><FieldRef Name="PermMask" /><FieldRef Name="FSObjType" /><FieldRef Name="ContentType" / ,fSafeArrayFlags=SAFEARRAYFLAG_AUTOHYPERLINK cba98f9d-b927-d02b-bbe5-cf32f703890a
07/14/2016 10:04:52.61 w3wp.exe (0x069C) 0x6ACC SharePoint Foundation General ai1wu Medium System.Runtime.InteropServices.COMException: Exception from HRESULT: 0x80131904, 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.SharePoint.WebPart... cba98f9d-b927-d02b-bbe5-cf32f703890a
07/14/2016 10:04:52.61* w3wp.exe (0x069C) 0x6ACC SharePoint Foundation General ai1wu Medium ...Pages.DataFormWebPart.DataBind() 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.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStag... cba98f9d-b927-d02b-bbe5-cf32f703890a
07/14/2016 10:04:52.61* w3wp.exe (0x069C) 0x6ACC SharePoint Foundation General ai1wu Medium ...esBeforeAsyncPoint, 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) 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... cba98f9d-b927-d02b-bbe5-cf32f703890a
07/14/2016 10:04:52.61* w3wp.exe (0x069C) 0x6ACC SharePoint Foundation General ai1wu Medium ....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, RequestNotificationStatus& 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.ProcessRequestNotificati... cba98f9d-b927-d02b-bbe5-cf32f703890a
07/14/2016 10:04:52.61* w3wp.exe (0x069C) 0x6ACC SharePoint Foundation General ai1wu Medium ...on(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags) cba98f9d-b927-d02b-bbe5-cf32f703890a
07/14/2016 10:04:52.61 w3wp.exe (0x069C) 0x6ACC SharePoint Foundation Web Parts 89a1 High Error while executing web part: Microsoft.SharePoint.SPException: Exception from HRESULT: 0x80131904 ---> System.Runtime.InteropServices.COMException: Exception from HRESULT: 0x80131904 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 bs... cba98f9d-b927-d02b-bbe5-cf32f703890a
07/14/2016 10:04:52.61* w3wp.exe (0x069C) 0x6ACC SharePoint Foundation Web Parts 89a1 High ...trViewName, 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 pFilterLinkCallback, ISPDataCallback pSchema... cba98f9d-b927-d02b-bbe5-cf32f703890a
07/14/2016 10:04:52.61* w3wp.exe (0x069C) 0x6ACC SharePoint Foundation Web Parts 89a1 High ...Callback, 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) cba98f9d-b927-d02b-bbe5-cf32f703890a
07/14/2016 10:04:52.61 w3wp.exe (0x069C) 0x6ACC SharePoint Foundation Web Parts 89a2 High InnerException 1: System.Runtime.InteropServices.COMException (0x80131904): Exception from HRESULT: 0x80131904 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, ISP2DSafeAr... cba98f9d-b927-d02b-bbe5-cf32f703890a
07/14/2016 10:04:52.61* w3wp.exe (0x069C) 0x6ACC SharePoint Foundation Web Parts 89a2 High ...rayWriter pSACallback, ISPDataCallback pPagingCallback, ISPDataCallback pPagingPrevCallback, ISPDataCallback pFilterLinkCallback, ISPDataCallback pSchemaCallback, ISPDataCallback pRowCountCallback, Boolean& pbMaximalView) cba98f9d-b927-d02b-bbe5-cf32f703890a
07/14/2016 10:04:52.63 w3wp.exe (0x069C) 0x6ACC SharePoint Foundation Monitoring nasq Medium Entering monitored scope (Render Ribbon.). Parent SharePointForm Control Render cba98f9d-b927-d02b-bbe5-cf32f703890a
07/14/2016 10:04:52.63 w3wp.exe (0x069C) 0x6ACC SharePoint Foundation Monitoring b4ly Medium Leaving Monitored Scope (Render Ribbon.). Execution Time=2.1455 cba98f9d-b927-d02b-bbe5-cf32f703890a
07/14/2016 10:04:52.63 w3wp.exe (0x069C) 0x6ACC SharePoint Server Search Query dn4s High FetchDataFromURL start at(outside if): 1 param: start cba98f9d-b927-d02b-bbe5-cf32f703890a
07/14/2016 10:04:52.63 w3wp.exe (0x069C) 0x6ACC SharePoint Foundation Micro Trace uls4 Medium Micro Trace Tags: 0 nasq,1 agb9s,9 abnwk,5 b4ly,0 b4ly,0 b4ly,11 eua9,61 89dd,0 89dd,45 880i,0 880k,0 880j,0 tzku,0 tzkv,0 aek90,0 d0d6,0 aix9j,0 ai1wu,0 89a1,0 89a2,12 nasq,2 b4ly,0 dn4s cba98f9d-b927-d02b-bbe5-cf32f703890a
07/14/2016 10:04:52.63 w3wp.exe (0x069C) 0x6ACC SharePoint Foundation Monitoring b4ly Medium Leaving Monitored Scope (Request (GET:https://ecm.xxx.com:443/sites/sfus2/Lis ... 68179baa6d)). Execution Time=155.829 cba98f9d-b927-d02b-bbe5-cf32f703890a
07/14/2016 10:04:52.63 w3wp.exe (0x069C) 0x0270 SharePoint Foundation Request Management aeboc High [Forced due to logging gap, cached @ 07/14/2016 10:04:52.47, Original Level: Verbose] No data was found on the incoming client request cba98f9d-b927-d02b-bbe5-cf32f703890a
07/14/2016 10:04:52.63 w3wp.exe (0x069C) 0x0270 SharePoint Foundation Monitoring b4ly High Leaving Monitored Scope (SPRoutingReverseProxy Get Response). Execution Time=158.982 cba98f9d-b927-d02b-bbe5-cf32f703890a
07/14/2016 10:04:52.64 w3wp.exe (0x069C) 0x53E8 SharePoint Foundation Micro Trace uls4 Medium Micro Trace Tags: 0 nasq,0 adc7u,159 b4ly cba98f9d-b927-d02b-bbe5-cf32f703890a
07/14/2016 10:04:52.64 w3wp.exe (0x069C) 0x53E8 SharePoint Foundation Monitoring b4ly Medium Leaving Monitored Scope (Request (GET:https://ecm.xxx.com/sites/sfus2/Lists/L ... USLocation
i have a n:n relation from locations to contacts.
The "contacts" content type has a site colum "related locations" with a value type of spfieldlookupvalueCollection.
When i create a related items control in the locations list form and link to contacts via the usual "form-field" + "list field" mechanism i get a runtime error when the display form is rendered:
Q: Does the related items control support n:n relationship at all and is there a workaround?
Thanks,
Armin
--
07/14/2016 10:04:52.61 w3wp.exe (0x069C) 0x6ACC SharePoint Foundation Fields tknl High Type mismatch with field Related_x0020_Locations and value Location NY WEST. cba98f9d-b927-d02b-bbe5-cf32f703890a
07/14/2016 10:04:52.61 w3wp.exe (0x069C) 0x6ACC SharePoint Foundation Database 880i High System.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near ')'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String rese... cba98f9d-b927-d02b-bbe5-cf32f703890a
07/14/2016 10:04:52.61* w3wp.exe (0x069C) 0x6ACC SharePoint Foundation Database 880i High ...tOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) at Microsof... cba98f9d-b927-d02b-bbe5-cf32f703890a
07/14/2016 10:04:52.61* w3wp.exe (0x069C) 0x6ACC SharePoint Foundation Database 880i High ...t.SharePoint.Utilities.SqlSession.ExecuteReader(SqlCommand command, CommandBehavior behavior, SqlQueryData monitoringData, Boolean retryForDeadLock) ClientConnectionId:fa9a2545-5a8a-4076-bed0-ac1e9fafa808 Error Number:102,State:1,Class:15 cba98f9d-b927-d02b-bbe5-cf32f703890a
07/14/2016 10:04:52.61 w3wp.exe (0x069C) 0x6ACC SharePoint Foundation Database 880k High at Microsoft.SharePoint.SPSqlClient.ExecuteQueryInternal(Boolean retryfordeadlock) at Microsoft.SharePoint.SPSqlClient.ExecuteQuery(Boolean retryfordeadlock) 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.SPRequestInternalClass.GetListItemDataWithCallback2(IListItemSqlClient pSqlClient, String bstrUrl, String bstrListName, String bstrViewNa... cba98f9d-b927-d02b-bbe5-cf32f703890a
07/14/2016 10:04:52.61* w3wp.exe (0x069C) 0x6ACC SharePoint Foundation Database 880k High ...me, 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, ISP2DSafeArrayWriter pSACallback, ISPDataCallback pPagingCallback, ISPDataCallback pPagingPrevCallback, ISPDataCallback pFilterLinkCallback, ISPDataCallback pSchemaCallback, ISPDataCallback pRowCountCallback, Boolean& pbMaximalView) at Microsoft.SharePoint.SPListItemCollection.EnsureListIte... cba98f9d-b927-d02b-bbe5-cf32f703890a
07/14/2016 10:04:52.61* w3wp.exe (0x069C) 0x6ACC SharePoint Foundation Database 880k High ...msData() 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.SharePoint.WebPartPages.DataFormWebPart.DataBind() at Microsoft.SharePoint.WebPartPages.DataFormWebPart.CreateChildControls() at Microsoft.SharePoint.WebPartPages.X... cba98f9d-b927-d02b-bbe5-cf32f703890a
07/14/2016 10:04:52.61* w3wp.exe (0x069C) 0x6ACC SharePoint Foundation Database 880k High ...sltListViewWebPart.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.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 includeS... cba98f9d-b927-d02b-bbe5-cf32f703890a
07/14/2016 10:04:52.61* w3wp.exe (0x069C) 0x6ACC SharePoint Foundation Database 880k High ...tagesAfterAsyncPoint) 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) 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) ... cba98f9d-b927-d02b-bbe5-cf32f703890a
07/14/2016 10:04:52.61* w3wp.exe (0x069C) 0x6ACC SharePoint Foundation Database 880k High ... at System.Web.Hosting.PipelineRuntime.ProcessRequestNotification(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags) at System.Web.Hosting.UnsafeIISMethods.MgdIndicateCompletion(IntPtr pHandler, RequestNotificationStatus& 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) cba98f9d-b927-d02b-bbe5-cf32f703890a
07/14/2016 10:04:52.61 w3wp.exe (0x069C) 0x6ACC SharePoint Foundation Database 880j High SqlError: 'Incorrect syntax near ')'.' Source: '.Net SqlClient Data Provider' Number: 102 State: 1 Class: 15 Procedure: '' LineNumber: 1 Server: 'sp2013dbsvr1' cba98f9d-b927-d02b-bbe5-cf32f703890a
07/14/2016 10:04:52.61 w3wp.exe (0x069C) 0x6ACC SharePoint Foundation Database 5586 Critical Unknown SQL Exception 102 occurred. Additional error information from SQL Server is included below. Incorrect syntax near ')'. cba98f9d-b927-d02b-bbe5-cf32f703890a
07/14/2016 10:04:52.61 w3wp.exe (0x069C) 0x6ACC SharePoint Foundation Database tzku High ConnectionString: 'Data Source=sp2013dbsvr1;Initial Catalog=WSS_Content_sfus2;Integrated Security=True;Persist Security Info=False;Enlist=False;Pooling=True;Min Pool Size=0;Max Pool Size=100;Asynchronous Processing=False;Connection Reset=True;MultipleActiveResultSets=False;Replication=False;Connect Timeout=15;Encrypt=False;TrustServerCertificate=False;Load Balance Timeout=0;Packet Size=8000;Type System Version=Latest;Application Name=".Net SqlClient Data Provider";User Instance=False;Context Connection=False;Transaction Binding="Implicit Unbind";ApplicationIntent=ReadWrite;MultiSubnetFailover=False;ConnectRetryCount=1;ConnectRetryInterval=10' Partition: 11bcfac8-00a6-4aa1-aaed-bc050c5775c2 ConnectionState: Closed ConnectionTimeout: 15 cba98f9d-b927-d02b-bbe5-cf32f703890a
07/14/2016 10:04:52.61 w3wp.exe (0x069C) 0x6ACC SharePoint Foundation Database tzkv High SqlCommand: 'DECLARE @DocParentIdForRF uniqueidentifier SELECT TOP 1 @DocParentIdForRF = Docs.Id FROM TVF_Docs_Url(@SITEID, @FDN, @FLN) AS Docs; SELECT TOP(@NUMROWS) t1.[TimeCreated] AS c18, t1.[Type] AS c0, UserData.[tp_Modified], CASE WHEN DATALENGTH(t1.DirName) = 0 THEN t1.LeafName WHEN DATALENGTH(t1.LeafName) = 0 THEN t1.DirName ELSE t1.DirName + N'/' + t1.LeafName END AS c2, UserData.[tp_ContentTypeId], UserData.[tp_ID], t1.[SortBehavior] AS c1, UserData.[tp_ModerationStatus], UserData.[tp_Level], UserData.[nvarchar1], t1.[LeafName] AS c17, t1.[ScopeId] AS c5, UserData.[nvarchar2] FROM AllUserData AS UserData WITH(FORCESEEK(AllUserData_PK(tp_SiteId,tp_ListId,tp_DeleteTransactionId,tp_IsCurrentVersion))) LEFT OUTER LOOP JOIN Docs AS t1 WITH(NOLOCK) ON (UserData.[tp_CalculatedVersion]... cba98f9d-b927-d02b-bbe5-cf32f703890a
07/14/2016 10:04:52.61* w3wp.exe (0x069C) 0x6ACC SharePoint Foundation Database tzkv High ... = 0 ) AND (UserData.[tp_IsCurrentVersion] = CONVERT(bit,1) ) AND (UserData.[tp_DeleteTransactionId] = 0x ) AND (UserData.[tp_RowOrdinal] = 0) AND (t1.SiteId=UserData.tp_SiteId) AND (t1.SiteId = @SITEID) AND (t1.ParentId = UserData.tp_ParentId) AND (t1.Id = UserData.tp_DocId) AND ( (UserData.tp_Level = 1) ) AND (t1.Level = UserData.tp_Level) AND (t1.IsCurrentVersion = 1) AND (t1.Level = 1 OR t1.Level = 2) AND (UserData.[tp_IsCurrentVersion] = CONVERT(bit,1) ) AND (UserData.[tp_CalculatedVersion] = 0 ) AND (UserData.[tp_DeleteTransactionId] = 0x ) WHERE (UserData.tp_ListID=@LISTID) AND (UserData.tp_SiteId=@SITEID) AND ( (UserData.tp_Level = 1) ) AND (UserData.tp_SiteId=@SITEID AND (UserData.tp_ParentId=@DocParentIdForRF)) AND (UserData.tp_RowOrdinal=0) AND ((0 = 1))) ) AND t1.SiteId=@SITEI... cba98f9d-b927-d02b-bbe5-cf32f703890a
07/14/2016 10:04:52.61* w3wp.exe (0x069C) 0x6ACC SharePoint Foundation Database tzkv High ...D AND (t1.ParentId=@DocParentIdForRF)) ORDER BY UserData.[tp_ID] ASC OPTION (FORCE ORDER, MAXDOP 1)' CommandType: Text CommandTimeout: 0 Parameter: '@LFFP' Type: UniqueIdentifier Size: 0 Direction: Input Value: '00000000-0000-0000-0000-000000000000' Parameter: '@SITEID' Type: UniqueIdentifier Size: 0 Direction: Input Value: '11bcfac8-00a6-4aa1-aaed-bc050c5775c2' Parameter: '@FDN' Type: NVarChar Size: 4000 Direction: Input Value: 'sites/sfus2/Lists' Parameter: '@FLN' Type: NVarChar Size: 4000 Direction: Input Value: 'Contacts' Parameter: '@LISTID' Type: UniqueIdentifier Size: 0 Direction: Input Value: 'dffcfe8e-74e1-441d-81e4-94520ec085e9' Parameter: '@NUMROWS' Type: BigInt Size: 0 Direction: Input Value: '31' Parameter: '@RequestGuid' Type: UniqueIdentifie... cba98f9d-b927-d02b-bbe5-cf32f703890a
07/14/2016 10:04:52.61* w3wp.exe (0x069C) 0x6ACC SharePoint Foundation Database tzkv High ...r Size: 0 Direction: Input Value: 'cba98f9d-b927-d02b-bbe5-cf32f703890a' cba98f9d-b927-d02b-bbe5-cf32f703890a
07/14/2016 10:04:52.61 w3wp.exe (0x069C) 0x6ACC SharePoint Foundation Database aek90 High SecurityOnOperationCheck = True cba98f9d-b927-d02b-bbe5-cf32f703890a
07/14/2016 10:04:52.61 w3wp.exe (0x069C) 0x6ACC SharePoint Foundation Database d0d6 High System.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near ')'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String rese... cba98f9d-b927-d02b-bbe5-cf32f703890a
07/14/2016 10:04:52.61* w3wp.exe (0x069C) 0x6ACC SharePoint Foundation Database d0d6 High ...tOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) at Microsof... cba98f9d-b927-d02b-bbe5-cf32f703890a
07/14/2016 10:04:52.61* w3wp.exe (0x069C) 0x6ACC SharePoint Foundation Database d0d6 High ...t.SharePoint.Utilities.SqlSession.ExecuteReader(SqlCommand command, CommandBehavior behavior, SqlQueryData monitoringData, Boolean retryForDeadLock) at Microsoft.SharePoint.SPSqlClient.ExecuteQueryInternal(Boolean retryfordeadlock) at Microsoft.SharePoint.SPSqlClient.ExecuteQuery(Boolean retryfordeadlock) ClientConnectionId:fa9a2545-5a8a-4076-bed0-ac1e9fafa808 Error Number:102,State:1,Class:15 cba98f9d-b927-d02b-bbe5-cf32f703890a
07/14/2016 10:04:52.61 w3wp.exe (0x069C) 0x6ACC SharePoint Foundation Database ad194 High ExecuteQuery failed with original error 0x80131904 cba98f9d-b927-d02b-bbe5-cf32f703890a
07/14/2016 10:04:52.61 w3wp.exe (0x069C) 0x6ACC SharePoint Foundation General xxpm High Unable to execute query: Error 0x80131904 cba98f9d-b927-d02b-bbe5-cf32f703890a
07/14/2016 10:04:52.61 w3wp.exe (0x069C) 0x6ACC SharePoint Foundation General 8e2s Medium Unknown SPRequest error occurred. More information: 0x80131904 cba98f9d-b927-d02b-bbe5-cf32f703890a
07/14/2016 10:04:52.61 w3wp.exe (0x069C) 0x6ACC SharePoint Foundation General aix9j High SPRequest.GetListItemDataWithCallback2: UserPrincipalName=i:0).w|s-1-5-21-2582922058-3218278914-315117220-1149, AppPrincipalName= ,pSqlClient=<null> ,bstrUrl=https://ecm.xxx.com/sites/sfus2 ,bstrListName={DFFCFE8E-74E1-441D-81E4-94520EC085E9} ,bstrViewName=<null> ,bstrViewXml=<View><Query><OrderBy><FieldRef Name="ID" /></OrderBy><Where><Eq><FieldRef Name="Related_x0020_Locations" /><Value Type="LookupMulti">Location NY WEST</Value></Eq></Where></Query><ViewFields><FieldRef Name="ID" /><FieldRef Name="PermMask" /><FieldRef Name="FSObjType" /><FieldRef Name="ContentType" / ,fSafeArrayFlags=SAFEARRAYFLAG_AUTOHYPERLINK cba98f9d-b927-d02b-bbe5-cf32f703890a
07/14/2016 10:04:52.61 w3wp.exe (0x069C) 0x6ACC SharePoint Foundation General ai1wu Medium System.Runtime.InteropServices.COMException: Exception from HRESULT: 0x80131904, 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.SharePoint.WebPart... cba98f9d-b927-d02b-bbe5-cf32f703890a
07/14/2016 10:04:52.61* w3wp.exe (0x069C) 0x6ACC SharePoint Foundation General ai1wu Medium ...Pages.DataFormWebPart.DataBind() 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.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStag... cba98f9d-b927-d02b-bbe5-cf32f703890a
07/14/2016 10:04:52.61* w3wp.exe (0x069C) 0x6ACC SharePoint Foundation General ai1wu Medium ...esBeforeAsyncPoint, 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) 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... cba98f9d-b927-d02b-bbe5-cf32f703890a
07/14/2016 10:04:52.61* w3wp.exe (0x069C) 0x6ACC SharePoint Foundation General ai1wu Medium ....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, RequestNotificationStatus& 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.ProcessRequestNotificati... cba98f9d-b927-d02b-bbe5-cf32f703890a
07/14/2016 10:04:52.61* w3wp.exe (0x069C) 0x6ACC SharePoint Foundation General ai1wu Medium ...on(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags) cba98f9d-b927-d02b-bbe5-cf32f703890a
07/14/2016 10:04:52.61 w3wp.exe (0x069C) 0x6ACC SharePoint Foundation Web Parts 89a1 High Error while executing web part: Microsoft.SharePoint.SPException: Exception from HRESULT: 0x80131904 ---> System.Runtime.InteropServices.COMException: Exception from HRESULT: 0x80131904 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 bs... cba98f9d-b927-d02b-bbe5-cf32f703890a
07/14/2016 10:04:52.61* w3wp.exe (0x069C) 0x6ACC SharePoint Foundation Web Parts 89a1 High ...trViewName, 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 pFilterLinkCallback, ISPDataCallback pSchema... cba98f9d-b927-d02b-bbe5-cf32f703890a
07/14/2016 10:04:52.61* w3wp.exe (0x069C) 0x6ACC SharePoint Foundation Web Parts 89a1 High ...Callback, 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) cba98f9d-b927-d02b-bbe5-cf32f703890a
07/14/2016 10:04:52.61 w3wp.exe (0x069C) 0x6ACC SharePoint Foundation Web Parts 89a2 High InnerException 1: System.Runtime.InteropServices.COMException (0x80131904): Exception from HRESULT: 0x80131904 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, ISP2DSafeAr... cba98f9d-b927-d02b-bbe5-cf32f703890a
07/14/2016 10:04:52.61* w3wp.exe (0x069C) 0x6ACC SharePoint Foundation Web Parts 89a2 High ...rayWriter pSACallback, ISPDataCallback pPagingCallback, ISPDataCallback pPagingPrevCallback, ISPDataCallback pFilterLinkCallback, ISPDataCallback pSchemaCallback, ISPDataCallback pRowCountCallback, Boolean& pbMaximalView) cba98f9d-b927-d02b-bbe5-cf32f703890a
07/14/2016 10:04:52.63 w3wp.exe (0x069C) 0x6ACC SharePoint Foundation Monitoring nasq Medium Entering monitored scope (Render Ribbon.). Parent SharePointForm Control Render cba98f9d-b927-d02b-bbe5-cf32f703890a
07/14/2016 10:04:52.63 w3wp.exe (0x069C) 0x6ACC SharePoint Foundation Monitoring b4ly Medium Leaving Monitored Scope (Render Ribbon.). Execution Time=2.1455 cba98f9d-b927-d02b-bbe5-cf32f703890a
07/14/2016 10:04:52.63 w3wp.exe (0x069C) 0x6ACC SharePoint Server Search Query dn4s High FetchDataFromURL start at(outside if): 1 param: start cba98f9d-b927-d02b-bbe5-cf32f703890a
07/14/2016 10:04:52.63 w3wp.exe (0x069C) 0x6ACC SharePoint Foundation Micro Trace uls4 Medium Micro Trace Tags: 0 nasq,1 agb9s,9 abnwk,5 b4ly,0 b4ly,0 b4ly,11 eua9,61 89dd,0 89dd,45 880i,0 880k,0 880j,0 tzku,0 tzkv,0 aek90,0 d0d6,0 aix9j,0 ai1wu,0 89a1,0 89a2,12 nasq,2 b4ly,0 dn4s cba98f9d-b927-d02b-bbe5-cf32f703890a
07/14/2016 10:04:52.63 w3wp.exe (0x069C) 0x6ACC SharePoint Foundation Monitoring b4ly Medium Leaving Monitored Scope (Request (GET:https://ecm.xxx.com:443/sites/sfus2/Lis ... 68179baa6d)). Execution Time=155.829 cba98f9d-b927-d02b-bbe5-cf32f703890a
07/14/2016 10:04:52.63 w3wp.exe (0x069C) 0x0270 SharePoint Foundation Request Management aeboc High [Forced due to logging gap, cached @ 07/14/2016 10:04:52.47, Original Level: Verbose] No data was found on the incoming client request cba98f9d-b927-d02b-bbe5-cf32f703890a
07/14/2016 10:04:52.63 w3wp.exe (0x069C) 0x0270 SharePoint Foundation Monitoring b4ly High Leaving Monitored Scope (SPRoutingReverseProxy Get Response). Execution Time=158.982 cba98f9d-b927-d02b-bbe5-cf32f703890a
07/14/2016 10:04:52.64 w3wp.exe (0x069C) 0x53E8 SharePoint Foundation Micro Trace uls4 Medium Micro Trace Tags: 0 nasq,0 adc7u,159 b4ly cba98f9d-b927-d02b-bbe5-cf32f703890a
07/14/2016 10:04:52.64 w3wp.exe (0x069C) 0x53E8 SharePoint Foundation Monitoring b4ly Medium Leaving Monitored Scope (Request (GET:https://ecm.xxx.com/sites/sfus2/Lists/L ... USLocation
-
Dmitry Kozlov
- Site Admin
- Posts: 1524
- Joined: Thu Jun 07, 2012
Hi,
You cannot filter the related items control by 'multi-lookup to multi-lookup' but your can filter it by 'single-lookup to multi-lookup'. I'd recommend you to re-design the solution by adding a new list containing links (single-lookup) to both existing lists.
You cannot filter the related items control by 'multi-lookup to multi-lookup' but your can filter it by 'single-lookup to multi-lookup'. I'd recommend you to re-design the solution by adding a new list containing links (single-lookup) to both existing lists.
-
- Information
-
Who is online
Users browsing this forum: No registered users and 8 guests