CA Spectrum - Spectro Server not available when login attempted.

It could be related to the Archive Manager being corrupted.  Here is one thing you can do to attempt repair.

https://comm.support.ca.com/kb/spectrum-archive-manager-not-starting-after-system-crash/kb000057378

Spectrum Archive Manager not starting after system crash.
Document ID : KB000057378
Last Modified Date : 11/09/2018
 Show Technical Document Details
Issue:
Spectrum Archive Manager not starting after system crash. The following error message is seen in the $SPECROOT/SSS/DDM/ARCHMGR.OUT file:
"Native error: 145, table './ddmdb/event' is marked as crashed and should be repaired" 
Environment:
Spectrum 9.x and up
Cause:
The system crashed caused the Archive Manager DDM database to become corrupt.
Resolution:
1. Run ArchMgr -repair to repair the database by doing the following:
  • Log into the system as the user that owns the Spectrum installation
  • If on Windows, open a bash shell by running "bash -login". If on Linux or Solaris, open a terminal window.
  • cd to the $SPECROOT/SS/DDM directory
  • Remove the .DDMDB.LOCK file if present and Archive Manager is not running
  • Run the following command: ./ArchMgr -repair
NOTE: Depending on the size of the DDM database, the repair could take a few minutes up to several hours (if DDM is many GB in size). If the repair is successful, start the Archive Manager with Spectrum Control Panel. To start Archive Manager via command line, see Additional Notes below.

2. If the above repair was not successful, you can try ./ArchMgr -force -repair

3. If still not successful, you may need to perform some additional maintenance on the MySQL database
  • cd to <SPECROOT>/mysql/bin
  • run ./mysqlcheck -uroot -proot ddmdb
If errors are found, mysqlcheck will attempt to aut-repair them. If for some reason there is issue with the repair, you can try to Force Repair: 
  • ./mysqlcheck -f -r -uroot -proot ddmdb
You can also try running repair on the DB files individually: 
  • run  ./myisamchk -m data/ddmdb/*.MYI
  • if errors are found, run ./myisamchk -r data/ddmdb/*.MYI
NOTE: Starting in Spectrum 10.3 we are no longer using MyISAM MySQL Engine and have now moved to newer more efficient MySQL InnoDB Engine, thus this command will only work on 10.2.3 and lower.

Lastly, there is an option to set Archive Manager to repair automatically. Be Aware that for larger databases, this can cause significant Archive Manager startup delays, so use with caution.
  • add the following line to <SPECTRUM>/SS/DDM/.configrc: AUTO_REPAIR_DB=TRUE
  • save and restart Archive Manager from Spectrum Control Panel
Additional Information:
Start Archive Manager via command line: 
  • cd to <SPECROOT>/bin
  • run ./launchinstdbapp localhost ARCHMGR y ARCHMGR.OUT

If you also experienced a Spectrum SpectroSERVER crash and need instructions on how to load a backup database for recovery, please see this article: https://comm.support.ca.com/kb/spectrum-crashed-and-try-to-start-spectroserver-shows-error-database-was-not-gracefully-closed/KB000113595

For more information on repairing a corrupt DDM database, please reference the "DDM and Archive Manager Troubleshooting" section in the guides: https://docops.ca.com/ca-spectrum/10-3-0/en/administrating/database-management/ddm-database-maintenance/ddm-and-archive-manager-troubleshooting

Comments

Post a Comment

Popular posts from this blog

Stop http.sys from listening on port 80 in Windows

Info from this URL:   https://www.mikeplate.com/2011/11/06/stop-http-sys-from-listening-on-port-80-in-windows/  Stop http.sys from listening on port 80 in Windows On Windows 7 there is a system service called http.sys that listens on port 80. That makes it impossible to run applications and services that haven't been integrated with this feature to also listen on port 80, like Apache HTTP Server or Nginx. Here is one way to solve that problem. Background information First of all, the way http.sys works on newer Windows versions is a very useful feature. The reason behind http.sys is to have a single system service that listens on the all-important port 80 and be a mediator to different applications and services in the system that might like to handle incoming requests on port 80 but for different urls. What an integrated Windows application does, is use a Windows API for registering its own urls and then have them directed to itself. At the same time, there can be...
Read more