locked
CRM 2013: Select EntityImage via OData gives Generic SQL error RRS feed

  • Question

  • Hi,

    I am trying to retrieve a contacts EntityImage property via OData. Therefore I use an URL similar to /XrmServices/2011/OrganizationData.svc/ContactSet(GUID'%7B1B4E0141-C8CE-E311-A66F-842B2B6792E8%7D')?$select=EntityImage

    While this works fine for users with system administrator role, there is an error for "standard" users. If I have a look at the network trace, there is an HTTP 500 response coming up, the XML Response is:

    <?xml version="1.0" encoding="utf-8" standalone="yes"?>
    <error xmlns="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata">
      <code>-2147204784</code>
      <message xml:lang="de-DE">Generic SQL error.</message>
    </error>

    Am I missing special privileges here? Unfortunately I am not able to trace on SQL Server side, since I do not have access to the customers SQL Server.

    Tuesday, May 13, 2014 9:29 AM

All replies

  • All SQL access from CRM is done in the cotnext of the CRM service account (it doesn't impersonate the CRM user), therefore the user's permissions shouldn't affect what happens in SQL. You may be able to get more information about the SQL query from CRM tracing


    Microsoft CRM MVP - http://mscrmuk.blogspot.com/ http://www.excitation.co.uk

    Tuesday, May 13, 2014 9:47 AM
    Moderator
  • Yes, it SHOULD not affect... But somehow ist does.

    Unfortunately I am not able to reproduce this on any of our dev boxes, so I asked the customer if he could Trace this issue on SQL Server side. Maybe this will shed some light on this issue.

    Tuesday, May 13, 2014 10:48 AM