Forum Discussion

timclaeys's avatar
timclaeys
Frequent Visitor
8 years ago
Solved

Scheduled refresh fail

Hi,   The scheduled refresh gives below error message. I find it too general to troubleshoot. Anyone got same issue before and was able to solve? Thanks!   Last refresh failed: Tue Jan 09 2018 16...
  • kdyess1's avatar
    kdyess1
    8 years ago

    Our scheduled refresh seemed to fix itself on 1/12.  Successful daily schedule refreshes completed 1/12, 1/13, 1/4, 1/15, and 1/16.  Any ideas on the root cause?

     

     

timclaeys's avatar
timclaeys
Frequent Visitor
8 years ago

Hi Anonymous,

 

I'm using an on-premises data gateway (personal mode), and data source types are several .xlsx files and 1 SQL server (data source credentials are all ok, no errors).

 

bajee's avatar
bajee
Kudo Kingpin
8 years ago

Anonymous,

 

Where those .xlsx's file are located, Is it in your local or share point.Those files are should be share point with no down time, if those files are in your local Scheduled refresh will not work.

 

Regards,

Bajee.

  • timclaeys's avatar
    timclaeys
    Frequent Visitor
    8 years ago

    HI bajee,

     

    Thanks for your reply. Those .xlsx files are on a SharePoint.

     

    The scheduled refresh worked well over the past few months, but only since a couple of days it fails. I did not change anything to any preferences or setup lately.

    • arivale_bi's avatar
      arivale_bi
      Regular Visitor
      8 years ago

      Having the same issue. Scheduled refresh using personal gateway on a VM, connecting to snowflake DW and sharepoint files.