Forum Discussion

Chad1234's avatar
Chad1234
Frequent Visitor
4 years ago
Solved

CRM Dataverse table timing out on transform

Hi,

 

We have recently started using a Dataverse connection to fetch data from our CRM instance. Most tables load fine, but we need to start reporting on the email table, and I assume because of the sheer amount of emails held in this table it times out before I can transform the data. 

Is there a way to select only a subset of the data to avoid this issue? We probably have near a decade of email data in this table, but realistically we only need the last 6 months or so.

 

The way I am loadiung the data is:

Dataverse ->

Select our instance (xxxxx..crm11.dynamics.com)

-> Select Import or direct query

-> Select Transform data 

then I get the error:

"DataSource.Error: Microsoft SQL: An error occurred while receiving the HTTP response to https://xxxx.crm11.dynamics.com/xrmservices/2011/organization.svc/web?SdkClientVersion=9.2.47.9978. This could be due to the service endpoint binding not using the HTTP protocol. This could also be due to an HTTP request context being aborted by the server (possibly due to the service shutting down). See server logs for more details.
RequestId: TDS;ecce373d-c4d7-4973-99eb-0f56df0f6ec4;2
Time: 2022-07-22T13:57:37.7584644Z
Details:
DataSourceKind=CommonDataService
DataSourcePath=xxxxx.crm11.dynamics.com
Message=An error occurred while receiving the HTTP response to https://xxxxx.crm11.dynamics.com/xrmservices/2011/organization.svc/web?SdkClientVersion=9.2.47.9978. This could be due to the service endpoint binding not using the HTTP protocol. This could also be due to an HTTP request context being aborted by the server (possibly due to the service shutting down). See server logs for more details.
RequestId: TDS;ecce373d-c4d7-4973-99eb-0f56df0f6ec4;2
Time: 2022-07-22T13:57:37.7584644Z
ErrorCode=-2146232060
Number=40000
Class=16

"

 

Need Help
  • v-luwang-msft's avatar
    v-luwang-msft
    4 years ago

    HI Chad1234 ,

    Try to  find exact error just need to add below code in service config in <configuration> section.

    After config update "App_tracelog.svclog" file will create, where your service exist just need to open .svclog file and find red color line on left side panel which is error and see its description for more info.

    <configuration>
...
...

<system.diagnostics>
    <sources>
      <source name="System.ServiceModel.MessageLogging" switchValue="Warning, ActivityTracing">
        <listeners>
          <add name="ServiceModelTraceListener" />
        </listeners>
      </source>
      <source name="System.ServiceModel" switchValue="Verbose,ActivityTracing">
        <listeners>
          <add name="ServiceModelTraceListener" />
        </listeners>
      </source>
      <source name="System.Runtime.Serialization" switchValue="Verbose,ActivityTracing">
        <listeners>
          <add name="ServiceModelTraceListener" />
        </listeners>
      </source>
    </sources>
    <sharedListeners>
      <add initializeData="App_tracelog.svclog" type="System.Diagnostics.XmlWriterTraceListener, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" name="ServiceModelTraceListener" traceOutputOptions="Timestamp" />
    </sharedListeners>
  </system.diagnostics>

  </configuration>

    Similar error refer:

    https://stackoverflow.com/questions/5870958/this-could-be-due-to-the-service-endpoint-binding-not-using-the-http-protocol 

     

    Did I answer your question? Mark my post as a solution!


    Best Regards

    Lucien

1 Reply

  • v-luwang-msft's avatar
    v-luwang-msft
    Icon for Community Support rankCommunity Support
    4 years ago

    HI Chad1234 ,

    Try to  find exact error just need to add below code in service config in <configuration> section.

    After config update "App_tracelog.svclog" file will create, where your service exist just need to open .svclog file and find red color line on left side panel which is error and see its description for more info.

    <configuration>
...
...

<system.diagnostics>
    <sources>
      <source name="System.ServiceModel.MessageLogging" switchValue="Warning, ActivityTracing">
        <listeners>
          <add name="ServiceModelTraceListener" />
        </listeners>
      </source>
      <source name="System.ServiceModel" switchValue="Verbose,ActivityTracing">
        <listeners>
          <add name="ServiceModelTraceListener" />
        </listeners>
      </source>
      <source name="System.Runtime.Serialization" switchValue="Verbose,ActivityTracing">
        <listeners>
          <add name="ServiceModelTraceListener" />
        </listeners>
      </source>
    </sources>
    <sharedListeners>
      <add initializeData="App_tracelog.svclog" type="System.Diagnostics.XmlWriterTraceListener, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" name="ServiceModelTraceListener" traceOutputOptions="Timestamp" />
    </sharedListeners>
  </system.diagnostics>

  </configuration>

    Similar error refer:

    https://stackoverflow.com/questions/5870958/this-could-be-due-to-the-service-endpoint-binding-not-using-the-http-protocol 

     

    Did I answer your question? Mark my post as a solution!


    Best Regards

    Lucien