Elastic table queries return Generic SQL Error (Sql Number: 208)

[chriswaters78]

Summary

Querying an elastic table with FetchXmlBuilder throws a Generic SQL Error.

Setup

I have created an elastic table 'Generic Details' and created an advanced find query with the following xml:

<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="false">
  <entity name="tn_genericdetails">
    <attribute name="tn_genericdetailsid" />
    <attribute name="ttlinseconds" />
    <attribute name="partitionid" />
    <attribute name="createdon" />
  </entity>
</fetch>

These are just the standard fields added to an elastic table on first creation.

When I run this advanced find query I get the full list of elastic rows as expected.

Actual Result

When I try the equivalent query in FetchXmlBuilder it spins for 10 seconds or so before returning this error:

Sql error: Generic SQL error. CRM ErrorCode: -2147204784 Sql ErrorCode: -2146232060 Sql Number: 208

Expected Result:

FetchXml queries for Elastic tables should work the same in FetchXmlBuilder as they do in advanced find and via the API.

Version

I am testing with the latest 1.2025.3 release of FetchXmlBuilder.

[rappen]

Thanks for the report.

I've tried a bit with elastic earlier, and I know they are a bit tricky, and I don't know why...
Probably my only attempt - can you try run it with either Top=500 and also test with Count=500 on the fetch node?

[chriswaters78]

Thanks for taking a look. I have tried both suggestions, getting the same error for both top="500" and count="500".

The full error is:

System.ServiceModel.FaultException<Microsoft.Xrm.Sdk.OrganizationServiceFault> (0x80044150)
 Sql error: Generic SQL error. CRM ErrorCode: -2147204784 Sql ErrorCode: -2146232060 Sql Number: 208
FetchXML Builder
Server stack trace: 
   at System.ServiceModel.Channels.ServiceChannel.HandleReply(ProxyOperationRuntime operation, ProxyRpc& rpc)
   at System.ServiceModel.Channels.ServiceChannel.Call(String action, Boolean oneway, ProxyOperationRuntime operation, Object[] ins, Object[] outs, TimeSpan timeout)
   at System.ServiceModel.Channels.ServiceChannelProxy.InvokeService(IMethodCallMessage methodCall, ProxyOperationRuntime operation)
   at System.ServiceModel.Channels.ServiceChannelProxy.Invoke(IMessage message)

Exception rethrown at [0]: 
   at Microsoft.Xrm.Tooling.Connector.CrmServiceClient.Execute(OrganizationRequest request)
   at Rappen.XTB.FetchXmlBuilder.FetchXmlBuilder.Execute(OrganizationRequest request)
   at Rappen.XTB.FetchXmlBuilder.FetchXmlBuilder.<>c__DisplayClass131_0.<ExecuteFetch>b__0(DoWorkEventArgs eventargs)
   at System.ComponentModel.BackgroundWorker.OnDoWork(DoWorkEventArgs e)
   at System.ComponentModel.BackgroundWorker.WorkerThreadStart(Object argument)```