chrisu's avatar
chrisu
Responsive Resident
7 years ago
Status:
Needs Info

Schedule Refresh Issue

Datasets on scheduled refresh fail and give the following error on the schedule refresh page:

 

Before the data import for XXXXXXX finished, its data source timed out. Double-check whether that data source can process import queries, and if it can, try again.

 

There is no error on the refresh history, it just shows failed.  It is a different table name every day.  Refresh Now works for these datasets when I try them an hour or two later.  

 

I believe this started after I updated to the Februrary on-prem gateway.  

 

Gateways

16 Comments

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    @chrisu ,

    What is the data source of your Power BI report? Could you please export gateway log here?

    Regards,
    Lydia

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    We are also experiencing these errors while refreshing our SQL database using the Scheduled Refresh, failures are intermitant. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Also getting these errors. Our datasource is on prem SQL database

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Getting this as well.  prem sql, prem iSeries - ODBC, some domain XLS

    This was only an issue after latest update for Gateway.  Had September GW version running and operating flawlessly until week ago.

     

    Did anyone open a ticket as suggested?

  • mwaltercpa's avatar
    mwaltercpa
    Advocate III
    7 years ago

    I am also getting these errors... It seems to happen to different dashboards each day.. and the table that is times out on changes on each refresh.

  • David_V's avatar
    David_V
    Frequent Visitor
    7 years ago

    Same problems for us after updating to the latest gateway (version 3000.1.257 (2019-02-24)) last week. The scheduled refresh randomly failed with the same error (data source timed out). It's a shame that it's impossible to roll back to a previous version of the gateway...

  • simonefraquelli's avatar
    simonefraquelli
    Helper I
    7 years ago

    Same problems for us using the latest gateway version: every time i get a timeout error on scheduled refresh

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Having exactly this issue as well.  Multiple refresh failures but no pattern.  Randomly failing, we had this for a few weeks and had hope the March update would resolve.  Problem still exists on march Gateway version.  Desktop client also fully updated

Completed Ideas