Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

New Gateway setup timeout

Hi all,

 

My first post in this forum :smileylol: 

 

I am trying to set up a OleDb gateway (to a SAS metadata server), but receiving the following error:

 

Unable to connect to the data source undefined.
Underlying error code:-2147467259
Underlying error message:Timeout expired. The timeout period elapsed prior to completion of the operation.

 

When testing the gateway connection on the server itself it works. Additionally, when I put in dummy credentials I get an incorrect credentials error message - so the gateway server is definitely reaching the SAS server. Additionally we have similar gateway connections to other SAS servers that work (and I have opened all the necessary firewall ports).

 

Any ideas on a solution?

Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Unfortunately this article didn't help.

     

    However I found the solution - it's true that even establishing the connection via Power BI desktop did take a long time - so the timeout was genuinely a timeout and not another issue.

     

    SAS OleDb driver is generally very slow unfortunately.

     

    Solution: go to <C:\Program Files\On-premises data gateway\Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.dll.config>, increase test connection timeout value (e.g, 00:02:50) and check if the issue still persists. Please note that after changing the timeout value, gateway service is required to restart.

     

    <setting name="MashupDSRTestConnectionTimeout" serializeAs="String">
<value>00:00:50</value>
</setting>

2 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Unfortunately this article didn't help.

       

      However I found the solution - it's true that even establishing the connection via Power BI desktop did take a long time - so the timeout was genuinely a timeout and not another issue.

       

      SAS OleDb driver is generally very slow unfortunately.

       

      Solution: go to <C:\Program Files\On-premises data gateway\Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.dll.config>, increase test connection timeout value (e.g, 00:02:50) and check if the issue still persists. Please note that after changing the timeout value, gateway service is required to restart.

       

      <setting name="MashupDSRTestConnectionTimeout" serializeAs="String">
<value>00:00:50</value>
</setting>