Forum Discussion

setis's avatar
setis
Post Partisan
6 years ago

Refresh fails

Dear all, 

 

I've been getting the following refresh fails on random tables. 

 

On all my tables, i have inserted the following as an attempt to avoid timeout errors but I'm still getting them.

 

Most of my tables are an "Append Query as new" in which I'm combining 4 tables and I deactivate "Enable load" on the 4 tables. The above code is on the 4 tables but not on the Appended. 

 

I hope that this makes sense. 

 

Does anyone have an idea of what the problem is here?

 

Thanks in advance

Need Help

4 Replies

  • v-yingjl's avatar
    v-yingjl
    Community Support
    6 years ago

    Hi setis ,

    With that said in the DataMovement.Pipeline.Gateway config file you can edit this settings to your desire value to see if this resolves you problem. 

    </setting>

    <setting name="DbConnectionPoolMaxSize" serializeAs="String">
    <value>256</value>
    </setting>

     

    If not help, I would recommend you create a support ticket here .

     

    Best Regards,
    Yingjie Li

    If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

  • v-yingjl's avatar
    v-yingjl
    Community Support
    6 years ago

    Hi setis ,

     

    If you've fixed the issue on your own please kindly share your solution. If the above posts help, please kindly mark it as a solution to help others find it more quickly. Thanks!


    Best Regards,
    Yingjie Li

    • setis's avatar
      setis
      Post Partisan
      6 years ago

      v-yingjl unfortunately the issue is not fixed. 

       

      The settings you suggested were already in the gateway and I have an open ticket with MS that has received the gateways logs. 

       

      I will update the thread with their findings if there is a solution.