Error opening list in datasheet
Hi, I'm working with SharePoint 2007 and have access to a number of sites within SharePoint. I and a number of other users have run into an issue that is happening when we try and open a list using the "Edit in Datasheet" option. The datasheet view opens but there is an error: Windows Internet Explorer Cannot connect to the server at this time. You can continue working with this list, but some data may not be available. When this issue was first identified, it was noted that the datasheet did not show the first 14 entries in the list and only showed entries 15-114. Since then, the list has grown in size and the datasheet consistently drops the first 100 entries after the above error is returned. I've searched a lot but cannot find a way to resolve this. Can anyone here help please? Thanks in advance. Chris
February 1st, 2008 3:34am

I had some issues this past summer. Your description reminds me of that. I believe it had something to do with a date field. Is there a date field in your list? I feel like our solution was to change the date to text and then back again. HTH, --Paul Galvin, Conchango RSS @ http://feeds.feedburner.com/PaulGalvinsSharepointSpace Web site @ http://paulgalvin.spaces.live.com
Free Windows Admin Tool Kit Click here and download it now
February 1st, 2008 4:06am

HI,Yes, there is a "Due Date" field in the list.I've tried what you suggested and have even gone to the extent of removing the field completely (there were only 4 entries with dates) but this has made no difference.I still get the error in the datasheet view and only entries 67-166 are shown.Chris
February 1st, 2008 5:27am

I should also add that when the datasheet opens, there is help text links at the bottom:Left corner = "Unable to retrieve all data."Right corner = "Read-only"Only "Read-only" link works and that help file doesn't help.
Free Windows Admin Tool Kit Click here and download it now
February 1st, 2008 5:44am

The only other idea I have is to look in the 12 hive log and see if any errors are reported there. --Paul
February 1st, 2008 5:47am

I've looked at the logs and this error appears around the same time as I try and edit in datasheet:02/01/2008 14:17:30.09 OWSTIMER.EXE (0x0BD0) 0x0BF8 Windows SharePoint Services Topology 0 High System.AccessViolationException: Attempted to read or write protected memory. This is often an indication that other memory is corrupt. at System.DirectoryServices.Interop.UnsafeNativeMethods.IntADsOpenObject(String path, String userName, String password, Int32 flags, Guid& iid, Object& ppObject) at System.DirectoryServices.Interop.UnsafeNativeMethods.ADsOpenObject(String path, String userName, String password, Int32 flags, Guid& iid, Object& ppObject) at System.DirectoryServices.DirectoryEntry.Bind(Boolean throwIfFail) at System.DirectoryServices.DirectoryEntry.Bind() at System.DirectoryServices.DirectoryEntry.get_IsContainer() at System.DirectoryServices.DirectoryEntries.CheckIsContainer() at System.DirectoryServices.DirectoryEntries.Find(String name, String s... 02/01/2008 14:17:30.09* OWSTIMER.EXE (0x0BD0) 0x0BF8 Windows SharePoint Services Topology 0 High ...chemaClassName) at Microsoft.SharePoint.Metabase.MetabaseObjectCollection`1.Find(String name) at Microsoft.SharePoint.Metabase.MetabaseObjectCollection`1.get_Item(String name) at Microsoft.SharePoint.Administration.SPProvisioningAssistant.ProvisionIisApplicationPool(String name, ApplicationPoolIdentityType identityType, String userName, SecureString password, TimeSpan idleTimeout, TimeSpan periodicRestartTime) 02/01/2008 14:17:30.09 OWSTIMER.EXE (0x0BD0) 0x0BF8 Office Server Office Server Shared Services 7u16 Critical Application Server Administration job failed for service instance Microsoft.Office.Server.Search.Administration.SearchAdminSharedWebServiceInstance (36cafdf5-8b31-4613-8f46-b5cce633c9d2). Reason: Attempted to read or write protected memory. This is often an indication that other memory is corrupt. Techinal Support Details: System.AccessViolationException: Attempted to read or write protected memory. This is often an indication that other memory is corrupt. at System.DirectoryServices.Interop.UnsafeNativeMethods.IntADsOpenObject(String path, String userName, String password, Int32 flags, Guid& iid, Object& ppObject) at System.DirectoryServices.Interop.UnsafeNativeMethods.ADsOpenObject(String path, String userName, String password, Int32 flags, Guid& iid, Object& ppObject) at S... I can't be 100% certain this arises from what I'm doing as the server hosts a number of team sites and I'm accessing just one of them.Is it possible this error is the reason for the dropping of records? If so, how is it resolved?Chris
Free Windows Admin Tool Kit Click here and download it now
February 1st, 2008 7:56am

This isn't familiar to me. You might try saving the list as a template and re-creating it and see if that clears out some cobwebs. Or, you could try creating a new empty list, add the columns (or content type) and then try to use windows explorer to move stuff from one to the other. I don't think that the above error is related. Those are OWSTIMER messages which ought not to be involved with a list. Are there workflows on the list? --Paul G
February 1st, 2008 2:51pm

Hi everyoneWe had this same problem in our environment and it took me a long time to find out whats wrong. As we use xml definitionsthen someone had writen one fields internal name with a space between two words. You can't do this from the Sharepoint UI because Sharepoint will automatically replace the space with proper encoding. While creating the fields with xml Sharepoint replaced the space with %20 and seems that it broke for some reason the datasheet view. Every time the datasheet view came to rendering the file that had this interesting field associated then it gave the "cannot connect to the server at this time" error. As suggested before you could save the list as template and create a new one from it. After this add some items to the new list and start removing fields from it to see when will the datasheet view start working. Maybe this suggestion won't help but there is one thing to try.
Free Windows Admin Tool Kit Click here and download it now
April 10th, 2009 5:36pm

Hi All,I am having the same issue with SharePoint 2007 and office 2007, in my company some people use the SharePoint list as Datasheet view for updating the status for their examinations, there are 8 people working together and there is 500 rows and almost 120 columns and 100 columns are calculative columns, if somebody open the file in Datasheet view it gives same error "cannot connect to the server at this time. you can continue working with this list". Not each time but many times, right now i have only one option to hit refresh by saying that its Microsoft bug. If any body know how to resolve this issue please let me know. i tried one - reducing the calculative columns but it doesn’t work much.Any idea?????
October 8th, 2009 9:13pm

What solved this problem for me was deleting redundant fields in the list view. By this I mean I went into my client's list view settings and saw that he was trying to display one field three times in the same view. I am not sure how he got it like that, but as soon as I unchecked those redundant field instances and only had one instance of any given field name in the view, I was able to get the list to display in data grid view correctly and to export into a spreadsheet. Easy fix to a very weird problem.Linda
Free Windows Admin Tool Kit Click here and download it now
January 5th, 2010 12:01am

Hi,Sorry for my ignorance, but what do you mean by a field's internal name? I use a Sharepoint list for work and just started getting this error yesterday; though no one else using the list does. I am the one who created the list, so maybe that's why I'm getting the error? Any help is much appreciated!
January 14th, 2010 4:55pm

Dear All,i faced this issue before, and solved it by adjusting my AAM, so if any one have this issue, make sure that AAM is correctly configured.any feedback is appreicated .i hope this help. Best Regrads, Ahmed Madany
Free Windows Admin Tool Kit Click here and download it now
January 14th, 2010 7:13pm

Thanks Ahmed! What is AAM? How would I adjust this and make sure it's configured correctly?
January 14th, 2010 8:02pm

HI,AAM is Alternate Access Mapping , you can reach by going to Central Administration -> operations -> Altrenate Access Mapping .could you please describe your AAM here?Best Regrads, Ahmed Madany
Free Windows Admin Tool Kit Click here and download it now
January 14th, 2010 8:11pm

Hi Ahmed, I am also facing this same problem but with some more complications. I have a site and wanted to make it FBA enabled. So I extended it on another port and made it FBA enabled. But after that the option "Edit in Datasheet View" has stopped working. I have enabled Client Integration in Authentication Provider. Now here is my AAM internet: http://servername:1000 extranet: http://servername:1001 custom: http://servername:1002 default: http://servername:1003 What needs to be done in AAM? Thanks, TejasThanks, Tejas
November 19th, 2010 7:16am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics