Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

DetailsODBC: ERROR[HY000] [Simba][BigQuery] (115) Operation timeout.PollJob

Hi everyone, 

Ive got a problem when trying to create a new visual for a query (source is Google BigQuery). 

I'm using a similar query, that is already working (but with an extra filter), making the new query take a little longer.

 

It runs for about 10 minutes, and return this error message: 

Details: "ODBC: ERROR[HY000] [Simba][BigQuery] (115) Operation timeout.PollJob"

 

So add an time limit parameter: "connect timeout=10000", but it doesnt work neither.

driver={Simba ODBC Driver for Google BigQuery};oauthmechanism=1;refreshtoken=TOKEN;catalog=mm-datamart-kd;connect timeout=10000

 

If someone get the error or have a solution for this error message. I would be grateful if you give me your advised.

Thanks!

 

General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests

4 Replies

  • v-yingjl's avatar
    v-yingjl
    Icon for Community Support rankCommunity Support
    5 years ago

    Hi Anonymous ,

    You can try these workarounds:

    • Add timeout parameter to Query argument within M Code / Advanced Editor
    • [Query="SELECT ...", CommandTimeout =#duration(0,1,0,0)]

     

    Please refer: ODBC & OLE DB Timeout Errors 

     

    Best Regards,
    Community Support Team _ Yingjie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi, thanks for your replay!, I already try that solution too, but it give me the same error message, 

      Details: "ODBC: ERROR[HY000] [Simba][BigQuery] (115) Operation timeout.PollJob"

       

      I dont know if you have another recomendation

      Thanks !

  • fezik921's avatar
    fezik921
    New Member
    5 years ago

    Hey Anonymous ,

    We're getting the same error message, did you manage to find a soloution for this problem ?

     

    Thanks

  • Tani4ka's avatar
    Tani4ka
    Icon for Helper II rankHelper II
    5 years ago

    I also get the same error but it seems to be connected to a specific server only. I have 2 identical GBQ views on different servers and 1 connects to PBI with no issues whereas the other throws this error. CommandTimeout doesn't work for me either.