Skip to main content

Hi guys, 

I cannot get the companies and deals table to execute in the ODX phase. The error I get: 

Executing table eHubSpot].]Companies]:
failed with error:
System.Data.SqlClient.SqlException (0x80131904): Execution Timeout Expired.  The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.ComponentModel.Win32Exception (0x80004005): The wait operation timed out
 

Has anyone else seen this before? 

Hi @mmaxell 

I will add the solution to this. Eventually we got the provider to give a different error than before.

This explained what the issue was and what the solution would be.

We added the DefaultColumnSize=8000 to the Other field and did a synchronize. This changed all string value field to be max instead of 2000 and that resolved it.


Reply