Hi guys,
I cannot get the companies and deals table to execute in the ODX phase. The error I get:
Executing table [HubSpot].[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?
Best answer by Thomas Lind
View original
+5
Hi
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.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
