Why the Archive Manager is down in OneClick Connection Status?

Document ID : KB000032832
Last Modified Date : 14/02/2018
Show Technical Document Details

Question:

Why the Archive Manager is down in OneClick Connection Status?

 

Even though the Archive Manager process is up and running, the OneClick Console shows it as down.

ArchiveManager_down.png

 

Answer:

If either the previous Archive Manager shutdown was not successful or the Archive Manager database (DDMdb) was repaired, the next time the Archive Manager is started, it will validate the DDMdb database.

This validation operation will take time depending on the DDMdb database size.

 

Follow the steps below to query the MySQL server to list what threads are running:

1. Open a bash shell (bash -login)

2. Navigate to $SPECROOT/mysql/bin directory

    cd mysql/bin

3. Launch the MySQL command prompt

    ./mysql -uroot -proot ddmdb (for Windows)

    ./mysql --defaults-file=../my-spectrum.cnf -uroot -proot ddmdb (for Linux or Solaris)

4. Run the following MySQL query:

    show full processlist\G

 

In the example below the MySQL server is checking the event table:

ArchiveManager_validating_database.png

 

Once the validation is completed successfully, you will be able to access the Archive Manager database.

ArchiveManager_up.png