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?

     

     

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi timclaeys,

 

Can you please provide more detail informations to help us clarify your issue? (e.g. datasource type, connect mode, using proxy? screenshots...etc)

 

Regards,

Xiaoxin Sheng

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.