Unable to get entityimage - Generic SQL error

(0) Share

Report

Posted on by Community Member Microsoft Employee

In our production server we are trying to get entityimage with fetchXML and get generic sql error.

    <entity name="contact" >
        <attribute name="birthdate" />
        <attribute name="firstname" />
        <attribute name="contactid" />
        <attribute name="lastname" />
        <attribute name="entityimage" />
        <filter type="and" >
            <condition attribute="contactid" operator="eq" value="{db747cc2-b9e0-e611-80d7-0050568be28a}" />
        </filter>
    </entity>
</fetch>

Trace Log output:

Crm Exception: Message: Generic SQL error., ErrorCode: -2147204784, InnerException: System.Data.SqlClient.SqlException (0x80131904): The data type image cannot be used as an operand to the UNION, INTERSECT or EXCEPT operators because it is not comparable.

I am wondering why this code work on our development server. on both server everything is the same.

And also when Read on Contact entity is at organization level it works.

*This post is locked for comments