Very good but have found a bug

Oct 31, 2011 at 12:50 PM

Hi,

Thanks for this is just what I needed.  Work fine on most list apart from one (annoyingly the one I need for most, always the way).  Basically one of my list is large over 5000 items and so is not possibly to show all items.  I have made my view such that the default threshold of 5000 list items can be kept in place.

When I add the RUMarks field the items correct show as unread and I can navigate my filtered lists (less than 5000 items) fine however when I try and open a document it gives the following error.

Error

The attempted operation is prohibited because it exceeds the list view threshold enforced by the administrator. 

Troubleshoot issues with Microsoft SharePoint Foundation.

Correlation ID: 00000000-0000-0000-0000-000000000000

Date and Time: 10/31/2011 11:47:14 AM

 

My guess is something your solution does to mark as ready access the whole list without a filter and this is not possible as can only access 5000 items at most.

Interesting this error is also given for the main administrator despite the fact the threshold does not apply to that account.

Thanks,

James

Nov 5, 2011 at 2:05 PM

What type of list is it ? If its a document library is the read mark being set by the handler or on a read form ?

 

Nov 7, 2011 at 9:17 AM

Is is a doc lib and the mark read is being set by the handler I think.

Thanks

Nov 7, 2011 at 6:53 PM

I will take a look at it, for sure I never tested it with lists that big.

Nov 9, 2011 at 3:52 PM
Edited Nov 9, 2011 at 3:54 PM

Hi just thought I would add some further info, strangely even though it is not possible to open the document it does correctly mark the document as read after it attempts to open it.  Also this is what is in my logs file

General                      

Medium 

HTTP request URL: /documents/Publications/Argus%20-%20Global%20Markets/20111107agm.pdf

Monitoring                   

Medium 

Leaving Monitored Scope (Request (GET:http://intranet.mydomain.com:80/documents/Publications/Argus%20-%20Global%20Markets/20111107agm.pdf)). Execution Time=172.91611084649

Logging Correlation Data     

Medium 

Site=/

SPRequest                    

Medium 

Failed to cache field with id "{57f03728-3f26-414c-97c4-7ab8558bfb42}", overwrite=0

Monitoring                   

High   

Leaving Monitored Scope (EnsureListItemsData). Execution Time=23.4102378933635

SPRequest                    

Medium 

Failed to cache field with id "{57f03728-3f26-414c-97c4-7ab8558bfb42}", overwrite=0

Monitoring                   

High   

Leaving Monitored Scope (EnsureListItemsData). Execution Time=224.697272977431

Health                       

High   

Throttled:Big list slow query. List item query elapsed time: 0 milliseconds, Additional data (if available): Query HRESULT: 80070024 List internal name, flags, and URL: {6B3CE073-A2D9-4D00-8599-E7B5573F3416}, flags=0x0000000004c01008, URL="http://intranet.mydomain.com/" Current User: 1073741823 Query XML: "<Query><Where><And><Eq><FieldRef Name="FileDirRef"/><Value Type="Lookup">/documents/Publications/Argus - Global Markets</Value></Eq><Contains><FieldRef Name="RUMarks"/><Value Type="Text">.7.</Value></Contains></And></Where></Query>" SQL Query: "N/A"

General                      

High   

Unable to execute query: Error 0x80070024

General                      

High   

The attempted operation is prohibited because it exceeds the list view threshold enforced by the administrator.

Health                       

High   

big list slow query, list:{6B3CE073-A2D9-4D00-8599-E7B5573F3416}  viewname: viewxml: <View Scope="RecursiveAll"  ModerationType="Moderator"><Query><Where><And><Eq><FieldRef Name="FileDirRef" /><Value Type="Lookup">/documents/Publications/Argus - Global Markets</Value></Eq><Contains><FieldRef Name="RUMarks" /><Value Type="Text">.7.</Value></Contains></And></Where></Query><ViewFields><FieldRef Name="ID"/></ViewFields><RowLimit Paged="TRUE">2147483647</RowLimit></View>

Health                       

High   

Throttled:Big list slow query. List item query elapsed time: 0 milliseconds, Additional data (if available): Query HRESULT: 80070024 List internal name, flags, and URL: {6B3CE073-A2D9-4D00-8599-E7B5573F3416}, flags=0x0000000004c01008, URL="http://intranet.mydomain.com/" Current User: 1073741823 Query XML: "<Query><Where><Eq><FieldRef Name="FileDirRef"/><Value Type="Lookup">/documents/Publications/Argus - Global Markets</Value></Eq></Where></Query>" SQL Query: "N/A"

General                      

High   

Unable to execute query: Error 0x80070024

General                      

High   

The attempted operation is prohibited because it exceeds the list view threshold enforced by the administrator.

Health                       

High   

big list slow query, list:{6B3CE073-A2D9-4D00-8599-E7B5573F3416}  viewname: viewxml: <View Scope="RecursiveAll"  ModerationType="Moderator"><Query><Where><Eq><FieldRef Name="FileDirRef" /><Value Type="Lookup">/documents/Publications/Argus - Global Markets</Value></Eq></Where></Query><ViewFields><FieldRef Name="ID"/></ViewFields><RowLimit Paged="TRUE">2147483647</RowLimit></View>

Health                       

High   

Throttled:Big list slow query. List item query elapsed time: 0 milliseconds, Additional data (if available): Query HRESULT: 80070024 List internal name, flags, and URL: {6B3CE073-A2D9-4D00-8599-E7B5573F3416}, flags=0x0000000004c01008, URL="http://intranet.mydomain.com/" Current User: 1073741823 Query XML: "<Query><Where><And><And><Eq><FieldRef Name="ContentType"/><Value Type="Text">Folder</Value></Eq><Eq><FieldRef Name="FileLeafRef"/><Value Type="Lookup">Argus - Global Markets</Value></Eq></And><Eq><FieldRef Name="FileDirRef"/><Value Type="Lookup">documents/Publications</Value></Eq></And></Where></Query>" SQL Query: "N/A"

General                       

High   

Unable to execute query: Error 0x80070024

General                      

High   

The attempted operation is prohibited because it exceeds the list view threshold enforced by the administrator.

Health                        

High   

big list slow query, list:{6B3CE073-A2D9-4D00-8599-E7B5573F3416}  viewname: viewxml: <View Scope="RecursiveAll"  ModerationType="Moderator"><Query><Where><And><And><Eq><FieldRef Name='ContentType' /><Value Type='Text'>Folder</Value></Eq><Eq><FieldRef Name="FileLeafRef" /><Value Type="Lookup">Argus - Global Markets</Value></Eq></And><Eq><FieldRef Name="FileDirRef" /><Value Type="Lookup">documents/Publications</Value></Eq></And></Where></Query><RowLimit Paged="TRUE">2147483647</RowLimit></View>

Health                       

High   

Throttled:Big list slow query. List item query elapsed time: 0 milliseconds, Additional data (if available): Query HRESULT: 80070024 List internal name, flags, and URL: {6B3CE073-A2D9-4D00-8599-E7B5573F3416}, flags=0x0000000004c01008, URL="http://intranet.mydomain.com/" Current User: 1073741823 Query XML: "<Query><Where><Eq><FieldRef Name="FSObjType"/><Value Type="Integer">1</Value></Eq></Where></Query>" SQL Query: "N/A"

General                      

High   

Unable to execute query: Error 0x80070024

General                      

High   

The attempted operation is prohibited because it exceeds the list view threshold enforced by the administrator.

Health                       

High   

big list slow query, list:{6B3CE073-A2D9-4D00-8599-E7B5573F3416}  viewname: viewxml: <View Scope="RecursiveAll"><Query><Where><Eq><FieldRef Name="FSObjType" /><Value Type="Integer">1</Value></Eq></Where></Query><RowLimit Paged="TRUE">2147483647</RowLimit></View>

Runtime                      

Unexpected

System.Runtime.InteropServices.COMException: The attempted operation is prohibited because it exceeds the list view threshold enforced by the administrator.    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...

Runtime                      

Unexpected

..., SAFEARRAYFLAGS fSafeArrayFlags, ISP2DSafeArrayWriter pSACallback, ISPDataCallback pPagingCallback, ISPDataCallback pPagingPrevCallback, ISPDataCallback pFilterLinkCallback, ISPDataCallback pSchemaCallback, ISPDataCallback pRowCountCallback, Boolean& pbMaximalView)

Monitoring                   

Medium 

Entering monitored scope (Request (POST:http://intranet.mydomain.com:80/absences/SitePages/dubai_leave.aspx))

Nov 9, 2011 at 6:00 PM

Thanks for the additional detail, that helps , it may take a bit to integrate a solution .

Nov 16, 2011 at 3:13 PM

I just posted an update, it should fix the problem but it is not extensivly tested

Nov 17, 2011 at 6:51 PM

Hi,

Thanks for your efforts but sad to say it seems to have half worked,  I no longer get error when opening things and I can mark things as read using the toggle but it does not seem to automatically dectect mark as read anymore when opening a document.  Also It was ok yesterday but today when I try and open the the setting under central administation I get and error,  below from logs.

 

Name=Request (GET:http://lon-svr-004:47676/_admin/Voodoo.ListItemReadUnreadSiteColumn/ConfigureSettings.aspx) e0bdd6f9-efb2-40ef-b68a-f0bd913b4a2511/17/2011 18:45:45.62 w3wp.exe (0x22A4)                       0x1514 SharePoint Foundation         Logging Correlation Data       xmnv Medium   Site=/ e0bdd6f9-efb2-40ef-b68a-f0bd913b4a2511/17/2011 18:45:45.62 w3wp.exe (0x22A4)                       0x1514 SharePoint Foundation         Runtime                       tkau Unexpected System.NullReferenceException: Object reference not set to an instance of an object.    at Voodoo.SharePoint.ReadUnreadMarks.ListItemReadUnreadSiteColumnConfigureSettings.Page_Load(Object sender, EventArgs e)     at System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e)     at System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e)     at System.Web.UI.Control.OnLoad(EventArgs e)     at Microsoft.SharePoint.ApplicationPages.GlobalAdminPageBase.OnLoad(EventArgs e)     at System.Web.UI.Control.LoadRecursive()     at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) e0bdd6f9-efb2-40ef-b68a-f0bd913b4a2511/17/2011 18:45:45.64 w3wp.exe (0x22A4)                       0x1514 SharePoint Foundation         Monitoring                     b4ly Medium   Leaving Monitored Scope (Request (GET:http://lon-svr-004:47676/_admin/Voodoo.ListItemReadUnreadSiteColumn/ConfigureSettings.aspx)). Execution Time=18.1576150041416 e0bdd6f9-efb2-40ef-b68a-f0bd913b4a25

Thanks,

James

Nov 17, 2011 at 11:40 PM

So did you go to the configuration page in central admin and set it to automatically mark the documents ? the error below indicates that the control for configuration did not load. Just to check the basics, how did you update the WSP ?

From: jameslheard [email removed]
Sent: Thursday, November 17, 2011 1:51 PM
To: robert@ginsburg.me
Subject: Re: Very good but have found a bug [voodoo:277750]

From: jameslheard

Hi,

Thanks for your efforts but sad to say it seems to have half worked, I no longer get error when opening things and I can mark things as read using the toggle but it does not seem to automatically dectect mark as read anymore when opening a document. Also It was ok yesterday but today when I try and open the the setting under central administation I get and error, below from logs.

Name=Request (GET:http://lon-svr-004:47676/_admin/Voodoo.ListItemReadUnreadSiteColumn/ConfigureSettings.aspx) e0bdd6f9-efb2-40ef-b68a-f0bd913b4a2511/17/2011 18:45:45.62 w3wp.exe (0x22A4) 0x1514 SharePoint Foundation Logging Correlation Data xmnv Medium Site=/ e0bdd6f9-efb2-40ef-b68a-f0bd913b4a2511/17/2011 18:45:45.62 w3wp.exe (0x22A4) 0x1514 SharePoint Foundation Runtime tkau Unexpected System.NullReferenceException: Object reference not set to an instance of an object. at Voodoo.SharePoint.ReadUnreadMarks.ListItemReadUnreadSiteColumnConfigureSettings.Page_Load(Object sender, EventArgs e) at System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) at System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) at System.Web.UI.Control.OnLoad(EventArgs e) at Microsoft.SharePoint.ApplicationPages.GlobalAdminPageBase.OnLoad(EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) e0bdd6f9-efb2-40ef-b68a-f0bd913b4a2511/17/2011 18:45:45.64 w3wp.exe (0x22A4) 0x1514 SharePoint Foundation Monitoring b4ly Medium Leaving Monitored Scope (Request (GET:http://lon-svr-004:47676/_admin/Voodoo.ListItemReadUnreadSiteColumn/ConfigureSettings.aspx)). Execution Time=18.1576150041416 e0bdd6f9-efb2-40ef-b68a-f0bd913b4a25

Thanks,

James

Nov 18, 2011 at 10:30 AM

Yes I did but can no longer get into the settings. To update I remove,the solution then added the new one.
Thanks

Sent from my mobile

On Nov 17, 2011 11:40 PM, "robginsburg" <notifications@codeplex.com> wrote:

From: robginsburg

So did you go to the configuration page in central admin and set it to automatically mark the documents ? the error below indicates that the control for configuration did not load. Just to check the basics, how did you update the WSP ?

From: jameslheard [email removed]
Sent: Thursday, November 17, 2011 1:51 PM
To: robert@ginsburg.me
Subject: Re: Very good but have found a bug [voodoo:277750]

From: jameslheard

Hi,

Thanks for your efforts but sad to say it seems to have half worked, I no longer get error when opening things and I can mark things as read using the toggle but it does not seem to automatically dectect mark as read anymore when opening a document. Also It was ok yesterday but today when I try and open the the setting under central administation I get and error, below from logs.

Name=Request (GET:http://lon-svr-004:47676/_admin/Voodoo.ListItemReadUnreadSiteColumn/ConfigureSettings.aspx) e0bdd6f9-efb2-40ef-b68a-f0bd913b4a2511/17/2011 18:45:45.62 w3wp.exe (0x22A4) 0x1514 SharePoint Foundation Logging Correlation Data xmnv Medium Site=/ e0bdd6f9-efb2-40ef-b68a-f0bd913b4a2511/17/2011 18:45:45.62 w3wp.exe (0x22A4) 0x1514 SharePoint Foundation Runtime tkau Unexpected System.NullReferenceException: Object reference not set to an instance of an object. at Voodoo.SharePoint.ReadUnreadMarks.ListItemReadUnreadSiteColumnConfigureSettings.Page_Load(Object sender, EventArgs e) at System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) at System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) at System.Web.UI.Control.OnLoad(EventArgs e) at Microsoft.SharePoint.ApplicationPages.GlobalAdminPageBase.OnLoad(EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) e0bdd6f9-efb2-40ef-b68a-f0bd913b4a2511/17/2011 18:45:45.64 w3wp.exe (0x22A4) 0x1514 SharePoint Foundation Monitoring b4ly Medium Leaving Monitored Scope (Request (GET:http://lon-svr-004:47676/_admin/Voodoo.ListItemReadUnreadSiteColumn/ConfigureSettings.aspx)). Execution Time=18.1576150041416 e0bdd6f9-efb2-40ef-b68a-f0bd913b4a25

Thanks,

James

Read the full discussion online.

To add a post to this discussion, reply to this email (voodoo@discussions.codeplex.com)

To start a new discussion for this project, email voodoo@discussions.codeplex.com

You are receiving this email because you subscribed to this discussion on CodePlex. You can unsubscribe on CodePlex.com.

Please note: Images and attachments will be removed from emails. Any posts to this discussion will also be available online at CodePlex.com

Nov 18, 2011 at 3:45 PM

I checked the previous WSP file and could not duplicate your problem. But just in case, I built a fresh one and tested the deployment package and it does work. You should retract and delete the previous solution

then upload the new solution file and then deploy it.  Dont forget to deploy it , it may take a few minutes to deploy, but you should be able to get to the configuration page after it is done deploying.