Current filter:
                                You should refresh the page.

                                You are using an older version of the DevExpress Support Center.

                                  • Hi,

                                    The data-sources I use for the dashboard widget binding are created and updated through our back-end system.
                                    Once the user has selected a data source for the first time the dashboard caches information about which fields that it contains. If that data source is changed in the back-end so that the fields it contains is changed those changes are not detected by the dashboard. The only way to clear the cached information I have found is to recycle the application pool of the web site. Obviously this is not acceptable in a production server. Is there a way to avoid the caching so that the field information is refreshed every time a data source is selected?

                                    Thanks in advance.

                                1 Solution

                                Creation Date Importance Sort by

                                Hi,

                                Sure, it is possible. I recommend you refer to the Web Dashboard - How to manage an in-memory data cache when the Client data processing is used KB article to learn more about our caching mechanism and use one of the suggested approaches to manage the cache.
                                Let me know if you have further questions.

                                • Alex.Ivanov 12.01.2019

                                  Hi.

                                  We applied imlementation in this article reccomended by you :
                                  https://www.devexpress.com/Support/Center/Question/Details/T520250/web-dashboard-how-to-manage-an-in-memory-data-cache-when-the-client-data-processing-is
                                  to solve the issue with dashboard cache problem described in ticket :
                                  https://www.devexpress.com/Support/Center/Question/Details/T716333/mvc-dashboard-how-to-disable-the-built-in-caching-mechanism#answer-99b36a55-7449-4af1-a6c8-89573b7731ce

                                  we implemented the steps as follows :

                                  • Implemented clear cache mechanism, which is triggered on Logout / Login
                                  - Implemented CacheManager :

                                    public static class CacheManager
                                    {
                                          public static void ResetCache()
                                          {
                                              if (HttpContext.Current.Session != null)
                                              {
                                                  HttpContext.Current.Session["UniqueCacheParam"] = Guid.NewGuid();
                                              }
                                          }
                                          public static Guid UniqueCacheParam
                                          {
                                              get
                                              {
                                                  if (HttpContext.Current.Session == null)
                                                  {
                                                       return Guid.Empty;
                                                  }
                                                  else
                                                  {
                                                      if (HttpContext.Current.Session["UniqueCacheParam"] == null)
                                                         ResetCache();
                                                      return (Guid)HttpContext.Current.Session["UniqueCacheParam"];
                                                  }
                                              }
                                          }
                                    }

                                  - On Logout / Login -> ResetCache() is called

                                        public void ResetCache()
                                        {
                                           CacheManager.ResetCache();
                                        }

                                  • Implemented e.Parameters.Add(new DashboardParameter("Param1", typeof(Guid), CacheManager.UniqueCacheParam));
                                  • js : On berforerender -> dashboardControl.refresh() is called

                                  When removing or adding columns in the datasource
                                  the change is not applied in the dashboard designer after exectuing Logout / Login.

                                  What could be the possible reason ?
                                  Should I give you details on how we are implementing the datasource loading ?

                                • Sergi (DevExpress Support) 12.01.2019

                                  Hello,

                                  I've created a separate ticket on your behalf (T837397: MVC Dashboard - How to reset cache manually). It has been placed in our processing queue and will be answered shortly.