Issue : using link-entity in fetch xml.

[shashidhargithub]

[Write any error info to resolve it easier]

We are trying to pull the data from CDS (CommonDataverse Service) using the Azure data factory. We were able to pull the data using the same fetch XML syntax couple of months ago. Not sure, why we are facing this issue now, We see the error "Link entities are not supported". Any comment or suggestion appreciated. Please let me know, if we are missing anything here. ---

System.ServiceModel.FaultException<Microsoft.Xrm.Sdk.OrganizationServiceFault>:
Link entities are not supported
mscorlib

Server stack trace: 
- System.ServiceModel.Channels.ServiceChannel.HandleReply(ProxyOperationRuntime operation, ProxyRpc& rpc)
- System.ServiceModel.Channels.ServiceChannel.Call(String action, Boolean oneway, ProxyOperationRuntime operation, Object[] ins, Object[] outs, TimeSpan timeout)
- System.ServiceModel.Channels.ServiceChannelProxy.InvokeService(IMethodCallMessage methodCall, ProxyOperationRuntime operation)
- System.ServiceModel.Channels.ServiceChannelProxy.Invoke(IMessage message)

Exception rethrown at [0]: 
- Microsoft.Xrm.Tooling.Connector.CrmServiceClient.RetrieveMultiple(QueryBase query)
- Cinteros.Xrm.FetchXmlBuilder.FetchXmlBuilder.RetrieveMultiple(QueryBase query)
- Cinteros.Xrm.FetchXmlBuilder.FetchXmlBuilder.<>c__DisplayClass119_0.<RetrieveMultiple>b__0(BackgroundWorker worker, DoWorkEventArgs eventargs)
- System.ComponentModel.BackgroundWorker.OnDoWork(DoWorkEventArgs e)
- System.ComponentModel.BackgroundWorker.WorkerThreadStart(Object argument)

---

<fetch distinct="false" no-lock="false" mapping="logical">
  <entity name="msdyn_emission">
    <attribute name="msdyn_otherghgs" />
    <attribute name="msdyn_n2ounit" />
    <attribute name="msdyn_activityid" />
    <attribute name="msdyn_co2e" />
    <attribute name="msdyn_n2o" />
    <attribute name="msdyn_activityname" />
    <attribute name="msdyn_otherghgsunit" />
    <attribute name="msdyn_pfcs" />
    <attribute name="modifiedon" />
    <attribute name="owningbusinessunit" />
    <attribute name="msdyn_consumptionstartdate" />
    <attribute name="msdyn_pfcsunit" />
    <attribute name="msdyn_sf6unit" />
    <attribute name="msdyn_emissionsource" />
    <attribute name="partitionid" />
    <attribute name="ttlinseconds" />
    <attribute name="msdyn_hfcs" />
    <attribute name="msdyn_origincorrelationid" />
    <attribute name="ownerid" />
    <attribute name="msdyn_transactiondate" />
    <attribute name="msdyn_dataconnectionrefresh" />
    <attribute name="msdyn_organizationalunitid" />
    <attribute name="msdyn_co2eunit" />
    <attribute name="msdyn_consumptionenddate" />
    <attribute name="msdyn_calculationlibrary" />
    <attribute name="msdyn_countryisocode" />
    <attribute name="msdyn_emissionlookup" />
    <attribute name="msdyn_calculationdate" />
    <attribute name="msdyn_nf3" />
    <attribute name="msdyn_emissioncalculation" />
    <attribute name="msdyn_facilityid" />
    <attribute name="createdonbehalfby" />
    <attribute name="msdyn_ismarketbased" />
    <attribute name="msdyn_isbiogenic" />
    <attribute name="modifiedonbehalfby" />
    <attribute name="msdyn_hfcsunit" />
    <attribute name="msdyn_co2unit" />
    <attribute name="msdyn_sf6" />
    <attribute name="msdyn_ch4" />
    <attribute name="msdyn_activity" />
    <attribute name="msdyn_emissionfactor" />
    <attribute name="modifiedby" />
    <attribute name="msdyn_category" />
    <attribute name="overriddencreatedon" />
    <attribute name="msdyn_co2emt" />
    <attribute name="msdyn_emissionid" />
    <attribute name="createdby" />
    <attribute name="msdyn_latitude" />
    <attribute name="createdon" />
    <attribute name="msdyn_name" />
    <attribute name="msdyn_longitude" />
    <attribute name="msdyn_activityentityname" />
    <attribute name="msdyn_calculationjob" />
    <attribute name="msdyn_ch4unit" />
    <attribute name="msdyn_dataconnection" />
    <attribute name="msdyn_co2" />
    <attribute name="msdyn_scope" />
    <attribute name="msdyn_emissionsourcev2" />
    <attribute name="msdyn_nf3unit" />
    <link-entity name="msdyn_sustainabilityorganizationalunit" from="msdyn_sustainabilityorganizationalunitid" to="msdyn_organizationalunitid" link-type="outer" alias="organization" visible="true" />
  </entity>
</fetch>

---

• XrmToolBox Version: 1.2022.5.56
• FetchXML Builder Version: 1.2022.5.1
• DB Version: 9.2.22061.180
• Deployment: Online

[rappen]

Hi, the error message from core says just "Link entities are not supported". Is there something fishy with this relationship? How does this relationship work in the Advance Find? A very far-fetch... could it be a problem with the alias? "organization" has been a few problems with, years ago...

[rappen]

Closing this now, as no response. Please reopen if you have more info!