locked
500 Internal Server error on ListData.svc RRS feed

  • Question

  • Hello,

    When trying to add a new datasource to SharePoint designer to display blog posts, I ran into an error. Designer tells me "the server returned a non-specific error when trying to get data from the data source". I browsed to the url (http://site.domain.com/blog/_vti_bin/ListData.svc), that seemed to be working fine. But when I browse to http://site.domain.com/blog/_vti_bin/ListData.svc/Posts, it throws an 500 internal server error.

    What could be going on and how can I find some more debug info on it? I tried modifying the web.config in C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\ISAPI to give some more debug info (since ListData.svc is in there), but that doesn't seem to do anything.

    Edit: I also tried adding the svc reference in VS2010, but that errors out too with a complaint about missing authentication. I have no idea where that's coming from.


    MCTS in Web Application Development in .NET 2.0
    Thursday, April 29, 2010 10:05 AM

Answers

All replies

  • ListData.svc is Lists Data Service. So, make sure you are invoking a list name when you say: http://site.domain.com/blog/_vti_bin/ListData.svc/Posts - Posts should be the list or document library name.
    Regards,
    Chakkaradeep || SharePoint Developer - MCTS SharePoint Dev, WSS Dev
    http://www.intergen.co.nz || Twitter: http://twitter.com/chakkaradeep || http://www.chakkaradeep.com
    Saturday, May 1, 2010 3:34 AM
  • Hi Chakkaradeep,

    The site I'm trying to query is a OOTB Blog site. There's indeed a Posts library in there, which is also enlisted when I view http://site.domain.com/blog/_vti_bin/ListData.svc. But when I add /Posts to the URL, the 500 internal server error pops up. You can try reproducing the same results by querying the Posts library of an OOTB Blog site.


    MCTS in Web Application Development in .NET 2.0
    Saturday, May 1, 2010 9:29 AM
  • I'm now running RTM, problem still exists.

    Reproducing is quite simple:

    Create a blog site, say http://site/blog
    Navigate to http://site/blog/_vti_bin/ListData.svc/Posts
    And voila: 500 server error

    Running Windows 7 x64,
    SharePoint version 14.0.0.4762
    Microsoft-IIS/7.5


    MCTS in Web Application Development in .NET 2.0
    Thursday, May 20, 2010 3:13 PM
  • I'm now running RTM, problem still exists.

    Reproducing is quite simple:

    Create a blog site, say http://site/blog
    Navigate to http://site/blog/_vti_bin/ListData.svc/Posts
    And voila: 500 server error

    Running Windows 7 x64,
    SharePoint version 14.0.0.4762
    Microsoft-IIS/7.5


    MCTS in Web Application Development in .NET 2.0


    Have you installed the ADO.NET Data Services CTP2 and the ADO.NET Data Services Update?  These are required for the ListData service to run properly.  I know the latest ADO.NET Data Services update is not run by the prerequisite installer, but since you have apparently done the Windows 7 developer install, you probably would have to do these steps manually anyway.

    Also note that there are 2 version of ADO.NET Data Services; one for Windows Server 2008 SP2 and one for Windows Server 2008 R2/Windows 7.

    Regards,

    Tom Browenll


    Tom Brownell KnowledgeLake, Inc.
    Monday, May 24, 2010 1:17 PM
  • Monday, May 24, 2010 2:53 PM
  • Installed the update, doesn't help. Have you guys tried reproducing the same results?

    I've setup failed request tracing to check what was going on on the server. The only thing I can find is a result MODULE_SET_RESPONSE_ERROR_STATUS by the module ManagedPipelineHandler. ErrorCode = "The operation completed successfully. (0x0)"?? This is listed as a warning, the only one (no errors).

    When I disable the friendly IE messages, the resulting XML is:

      <?xml version="1.0" encoding="utf-8" standalone="yes" ?>
    - <error xmlns="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata">
      <code />
      <message xml:lang="en-US">An error occurred while processing this request.</message>
      </error>

    Not very helpfull.


    MCTS in Web Application Development in .NET 2.0

    Tuesday, May 25, 2010 6:52 AM
  • Did you restart after installing update? Update Installer should ask you about it.
    Tuesday, May 25, 2010 7:24 AM
  • Installer didn't ask about it, so I didn't. But now I did, makes no difference unfortunately :(
    MCTS in Web Application Development in .NET 2.0
    Tuesday, May 25, 2010 7:41 AM
  • This problem occurs only when quering Posts list? Try to create simple custom list and query it.

    Tuesday, May 25, 2010 7:53 AM
  • Yep, other lists in the same site work fine, custom lists do too. The only thing which seems to be having problems is that one OOTB Posts list.
    MCTS in Web Application Development in .NET 2.0
    Tuesday, May 25, 2010 8:06 AM
  • So I almost find the problem. Every list that have lookup column with count related causes error 500 while retreiving through the REST.
    Tuesday, May 25, 2010 7:10 PM
  • That's a great lead! Indeed, the Posts library also has a look-up column in there (category) which apparantly is messing things up. Now the next question becomes; how can we get this bug to disappear? I'll check if I can contact the ado.net data services team somehow to get this fixed.

    In the meantime, do you perhaps know if it's possible to specify which columns you want returned in the result? If we could omit the look-up column for now, that would be a workable workaround for me.


    MCTS in Web Application Development in .NET 2.0

    Wednesday, May 26, 2010 6:43 AM
  • That's a great lead! Indeed, the Posts library also has a look-up column in there (category) which apparantly is messing things up. Now the next question becomes; how can we get this bug to disappear? I'll check if I can contact the ado.net data services team somehow to get this fixed.

    In the meantime, do you perhaps know if it's possible to specify which columns you want returned in the result? If we could omit the look-up column for now, that would be a workable workaround for me.

     


     

    MCTS in Web Application Development in .NET 2.0

    Do you understand thet problem occures not while quering any list with lookup, but only in quering those lists that have lookup with count related columns?
    Wednesday, May 26, 2010 10:01 AM
  • I'm not sure what you mean by count related? How can I check that and possibly change it??


    MCTS in Web Application Development in .NET 2.0
    Wednesday, May 26, 2010 10:56 AM
  • For example, there is two lists, "Comments" and "Posts".

    Comments list have simple lookup column, that looks at Posts list.

    Posts list have "(Count related)" lookup, that looks to Comments. This column show to user count of comments, related to current post.

    You can create 2 custom lists and link them to each other this way, than you will clearly understood me.

    Wednesday, May 26, 2010 12:02 PM
  • Ah okay, now I see. You're right, there's indeed a # Comments column in that list! Now how can we find a way to make Microsoft interact on this...
    MCTS in Web Application Development in .NET 2.0
    Wednesday, May 26, 2010 2:41 PM
  • Ive created a connect item. Not sure if it's in the right place, but I didn't find any other suitable spot to leave it at.

    https://connect.microsoft.com/site428/feedback/details/561651/rest-gives-internal-server-error-on-lists-with-count-related-column


    MCTS in Web Application Development in .NET 2.0
    Wednesday, May 26, 2010 2:53 PM
  • J Siegmund - that URL doesn't work.  I've tried every way possible to get my sharepoing blog posts to show on my parent sharepoint site.  I thought the REST connection was my solution.  Nothing seems to work at this point.  I can do a content query, but it's a total pain as I want to customize it and you have to jump through hoops to get it to display what you want.  Any updates on this REST connection issue with Blog Posts and Comments?
    Thursday, July 29, 2010 2:55 PM
  • Hello Pitz77,

    I've got a support case running but unfortunately that also doesn't seem to be a quick way to get in touch with the people responsible. I've request my support engineer to give me a status update, if I hear anything else I'll report back here.


    MCTS in Web Application Development in .NET 2.0
    Thursday, July 29, 2010 3:08 PM
  • We currently seem to have possibly related problem. We also get the 500 errors when we try to use ListData.svc. But, in our case we are also having problems with _vti_bin/Search.asmx. I don't know for sure if they are related, so I've raised the issue on: http://social.technet.microsoft.com/Forums/en-US/sharepoint2010customization/thread/ecca318d-ad0b-4749-8663-af44c0d7791d. I'll update this thread too if resolving search.asmx also resolves our ListData.svc problem.

     

    regards

    chris.

    Friday, August 27, 2010 10:13 AM
  • Hello Pitz77,

    I've got a support case running but unfortunately that also doesn't seem to be a quick way to get in touch with the people responsible. I've request my support engineer to give me a status update, if I hear anything else I'll report back here.


    MCTS in Web Application Development in .NET 2.0

    Did your support case ever get resolved? I'm having this issue as well and can't seem to find any solution.
    Tuesday, September 21, 2010 6:50 PM
  • Nope, still nothing. Support sucks.
    MCTS in Web Application Development in .NET 2.0
    Thursday, September 30, 2010 7:35 AM
  • Hi guys. Good news! A hotfix is finally being made to solve this problem. I will get it asap to test the solution. When it works, it will be made publically available and will also get into the next CU. Took a while, but it seems like a solution is on it's way!
    MCTS in Web Application Development in .NET 2.0
    Monday, October 11, 2010 8:29 AM
  • Any news on this?

     

     

    Friday, October 15, 2010 3:09 PM
  • The december 2010 cumulative update fixes this bug:

    http://jsiegmund.wordpress.com/2011/01/02/sp2010-december-cumulative-update/

    Didn't test it yet, but I'm confident it'll work :)


    MCTS in Web Application Development in .NET 2.0
    Sunday, January 2, 2011 1:11 PM
  • @Siegmund - That is excellent news! Will wait for your end result then :)
    Regards,
    Chakkaradeep | SharePoint Server MVP | SharePoint Solutions Specialist | http://www.intergen.co.nz | http://twitter.com/chakkaradeep | http://www.chakkaradeep.com
    Sunday, January 2, 2011 11:38 PM
  • I finally got the chance to test it and it works! I don't seem to have any problems anymore with ListData.svc. Big hurray for the product team :-)
    MCTS in Web Application Development in .NET 2.0
    Wednesday, January 19, 2011 7:26 AM