Forum Discussion

Juca's avatar
Juca
Frequent Visitor
5 years ago
Solved

Teradata Timeout not working

As shown in the document, my query always aborts in 10 minutes, even when I use the command: "CommandTimeout" > 10min.

 

Exemple: 

= Teradata.Database("host",
[HierarchicalNavigation=true,
Query="
SELECT

databasename,

tablename 

from dbc.tables", 

CommandTimeout=#duration(0, 0, 35, 0)]
 
 
error: 


I'm using Dataflow. Is there any other configuration that I should review?
Thanks in advanced!

Need Help
  • Juca's avatar
    Juca
    5 years ago

    My workaround work. I informed an invalid date in RangeStart and RangeEnd. So, finally I can save the Dataflow and refresh all history based on parameters of incremental refresh.

4 Replies

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

    Hi Juca ,

    Seems that could not reproduce it in my envrionment. Have you tried the same query in power bi desktop and has it had the same issue?

     

    Best Regards,
    Community Support Team _ Yingjie Li

  • Juca's avatar
    Juca
    Frequent Visitor
    5 years ago

    Hi @Yingjie, I've tested on Power bi Desktop and 'timeout' only worked for less than 10min, times greater than 10min don't work either.

  • Juca's avatar
    Juca
    Frequent Visitor
    5 years ago

    My workaround work. I informed an invalid date in RangeStart and RangeEnd. So, finally I can save the Dataflow and refresh all history based on parameters of incremental refresh.

  • Juca's avatar
    Juca
    Frequent Visitor
    5 years ago

    I've found a article about Authoring Limits explains the timout in 10minuts, in my case happens in "query preview": 

    "Authoring limits are the same across all products. During authoring, query evaluations return previews that may be subsets of the data. Data is not persisted.

    Hourly Evaluation Count: 1000

    Daily Evaluation Time: Currently unrestricted 

    Per Query Timeout: 10 minutes".