Question Status

Verified
Brandon Wiese asked a question on 27 May 2013 11:09 AM

Multiple AOS in a cluster can easily have different code or data in their local server caches, both with data (parameter tables set to EntireTable typically) and code.  This is, of course, readily expected anytime parameters are changed or code is imported into the AOT on one AOS.

What is not expected is that the cache invalidation mechanisms built into AX seem broken out of the box.

First, there are several options under the Developer Tools menu, under Caches.  These are Refresh dictionary, Refresh data, and Refresh elements.  Unfortunately, the menu items behind each of these specify RunOn Called from, and the classes themselves also are set Called from, and the static main(..) methods of those classes do not peg them at server.  Consequently, there appears to be no way to clear the AOS cache from the client.  The solution to this, as one can quite readily find on blogs and forum posts, is to copy these menu items and force these copies to RunOn the Server, and testing shows that this indeed seems to work.

But, what is the value of clearing the client cache when simply closing and re-opening the client is so easy, and yet no mechanism is provided to clear the server cache, when stopping and restarting the server is so painful?

Second, there appears to be a cache invalidation mechanism between multiple AOS via the SysEvent table.  For example, the SysFlushData\main method makes a call to SysEvent::fireEvent(SysEventType::FlushData) which inserts a record into the SysEvent table.  While at first glance this may appear like transaction history only, I found a class called SysEventHandler which appears to poll this table and execute the various types of cache flush based on these newly inserted records.

However, SysEventHandler does not appear to get started anywhere.  Monitoring an active AOS cluster with SQL Server Profiler reveals no polling against the SysEvent table by any AOS.  It appears at first glance as though a built-in AOS to AOS cache invalidation mechanism exists, but is simply not activated or otherwise broken.

Does anyone understand why this situation is designed as it is and why managing an AOS cluster is made more complex due to apparently simple oversights such as leaving menu items set to Client and forgetting to start an event handler?

Reply
Verified Answer
Brandon Wiese responded on 21 Jun 2013 3:16 PM

Setting the flush menu items to RunOn Server seems to generally work.  Most new objects can be deployed on one AOS in a cluster and the caches on other AOS can be flushed to pick up the change.  This also works for cached data, such as parameter tables set to Cache EntireTable.

There are notable cases where it appears not to be needed.  For example, the Security branch of the AOT appears to cache less rigorously and changes to one AOS appear to be picked up on others immediately.  

There are also notable cases where it appears not to work at all.  I recently added a menu item to a menu on one AOS, and absolutely nothing short of an AOS restart would allow it to appear on clients connecting to another AOS.  Flushing did not work.

As for the SysEventHandler, I have managed to get it started on the AOS service thread (and can see it operating using the SQL Server Profiler querying the SysEvent table), but it stops all on its own after a while without explanation.  Since it's running on the core AOS thread and not on a user client or server thread, I expect debugging it will be difficult if not impossible.  Since the caches can be flushed manually on each AOS, the proper functioning of the SysEventHandler would be a convenience but not required.

Closing the question.

Reply
Andreas Rudischhauser responded on 28 May 2013 12:26 AM

Thanks for this question. I asked myself the same question in the past. I'd like to see some MS developers answering those questions...

Reply
Verified Answer
Brandon Wiese responded on 21 Jun 2013 3:16 PM

Setting the flush menu items to RunOn Server seems to generally work.  Most new objects can be deployed on one AOS in a cluster and the caches on other AOS can be flushed to pick up the change.  This also works for cached data, such as parameter tables set to Cache EntireTable.

There are notable cases where it appears not to be needed.  For example, the Security branch of the AOT appears to cache less rigorously and changes to one AOS appear to be picked up on others immediately.  

There are also notable cases where it appears not to work at all.  I recently added a menu item to a menu on one AOS, and absolutely nothing short of an AOS restart would allow it to appear on clients connecting to another AOS.  Flushing did not work.

As for the SysEventHandler, I have managed to get it started on the AOS service thread (and can see it operating using the SQL Server Profiler querying the SysEvent table), but it stops all on its own after a while without explanation.  Since it's running on the core AOS thread and not on a user client or server thread, I expect debugging it will be difficult if not impossible.  Since the caches can be flushed manually on each AOS, the proper functioning of the SysEventHandler would be a convenience but not required.

Closing the question.

Reply
Carlos Javier Criales Cardozo responded on 21 Oct 2013 12:56 PM

Hi I have a solution in my blog that can work here www.dynamicsaxlatino.com/como-limpiar-cache-de-dynamics-ax

Microsoft Dynamics AX Programmer

http://www.dynamicsaxlatino.com/

Reply
Carlos Javier Criales Cardozo responded on 2 Nov 2013 11:12 AM

I have found this how to clean cache of AOT and take multiple AOS changes

www.dynamicsaxlatino.com/limpiar-flush-cache-de-aos-o-aot-en-ax

Microsoft Dynamics AX Programmer

http://www.dynamicsaxlatino.com/

Reply