web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

Strange behavior when removing AOS from cluster config

(0) ShareShare
ReportReport
Posted on by

Hello, there! Recently we came across a very very strange behavior when trying to remove AOS instances from the cluster config of AX 2012 R3... Here's the story...

We have a PROD instance with 5 AOS instances - 4 AOS in a cluster and one out of the cluster that serves as a batch server. All works as a charm. Then we take a backup of the PROD transnational DB and restore it over the TEST DB. The TEST environment is a sandbox that consists only of one AOS.

Now, after the restore, we open the Cluster  configuration of the refreshed TEST environment and we see the 5 AOS instances from PROD along with the currently active TEST AOS instances.

2018_2D00_01_2D00_19_5F00_11h06_5F00_25.png

We need to remove those 5 PROD AOS records from the cluster configuration of TEST. If we try to do so, we get the following error:

2018_2D00_01_2D00_19_5F00_11h09_5F00_15.png

As per my understanding, if we want to remove those application servers from the cluster config, they need to be drained from client connections and stopped, no matter they are actually serving another instance? OK, here comes the strange part... After 2 attempts to remove them without stopping anything, I got that same mistake. THEN, on my 3rd attempt, I actually managed to remove all 5 PROD AOS instances, as well as the whole cluster from the config:

2018_2D00_01_2D00_19_5F00_11h12_5F00_15.png

Any idea why and how this actually happens? First I get the error, then nothing changed at all, only 10 minutes later I manage to remove all app servers with no issue... Is there any mechanism behind this?

*This post is locked for comments

I have the same question (0)
  • Mariano Gracia Profile Picture
    on at
    RE: Strange behavior when removing AOS from cluster config

    Tell your customer they will need to run scripts in sql, you can give them this whitepaper, you will find a complete explanation, at least you have an official and supported argument.

  • Community Member Profile Picture
    on at
    RE: Strange behavior when removing AOS from cluster config

    Hey, thanks! The problem with queries we have is that the customer wants to be able to do this restore on his own and they're not feeling comfortable with SQL scripts.

    In the best scenario, we want to avoid any queries in the DB, but if not possible, we have no choice.

    Anyway - what is interesting for me is how I managed to remove old AOS without clearing the session tables?

  • Verified answer
    Mariano Gracia Profile Picture
    on at
    RE: Strange behavior when removing AOS from cluster config

    when you restore a database backup from a production environment to a test environment you have allways to run this queries in the test restored database before starting the aos:

    delete from SYSCLIENTSESSIONS

    delete from SYSSERVERSESSIONS

    delete from SYSSERVERCONFIG

    delete from SYSCLUSTERCONFIG

    I like also to delete batch tables and history:

    delete from BATCH
    delete from BATCHHISTORY
    delete from BATCHJOB

    but it is not strictly necessary

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Community Member Profile Picture

Community Member 4

#2
Mea_ Profile Picture

Mea_ 2

#2
Martin Dráb Profile Picture

Martin Dráb 2 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans