This is a fun one I haven’t seen in a while so I figured I’d blog. Support issue today where user was trying to access listdata.svc

http://webappurl/sites/sitecollection/subsite/_vti_bin/listdata.svc

This worked at the web app URL root, the site collection root, but was giving a 500 error at a specific subsite. There was a subsite underneath the affected site and that one loaded up just fine as well..seemed to be isolated to one site.

This issue is caused by a couple of things (specifically if it’s isolated to a single site or list):

  1. Invalid characters in list (Either displayname of list or column names): https://support.microsoft.com/en-us/kb/905231
  2. List view threshold/list lookup threshold
  3. Anonymous user tries to access ListData.svc
  4. svc does not work with Discussion Lists
  5. A few others:
    1. http://allthatjs.com/2012/07/20/limitations-of-sharepoint-listdata-svc/
    2. http://blogs.technet.com/b/victorbutuza/archive/2014/06/30/why-would-listdata-svc-return-an-error.aspx

It was none of these..pretty small site with nothing too crazy for naming or anything like that. Turns out the user created a list and gave it the same displayname as another list on the site (URL’s different..sharing the same displayname). This caused the entire site to throw a 500 error when accessing it with listdata.svc. Even when explicitly going to a list on the site that wasn’t affected. Once the user switched one of the lists to <listname> (old) everything started working.

-AJB