Archive Manager fails to start after a CA Spectrum install due to the install username having more than 16 characters.

Products

• CA Spectrum

Issue/Introduction

Archive Manager fails to start after a CA Spectrum install.

The error seen in the $SPECROOT/SS/DDM/ARCHMGR.OUT:

 

Jan 14 06:54:10 : ArchMgr started as user '<user>'
Jan 14 06:54:10 : ArchMgr validating database.

Error opening the DDM database. The most likely causes: 

 1. The SQL database server is not running. 
 2. The username, password, hostname, or database name are not correct. 

Jan 14 06:54:10 : ArchMgr error opening database.

You will also find two failures in the $SPECROOT/Install-Tools/LOGS/<SS Install>/postinst.hh.mm logfile. The mysql.cus script and ddm.cus script both failed due to the Spectrum Owner username being longer than 16 characters.

********** Started: Wed Jan 13 18:28:06 2016 **********

running Custom Script Install-Tools/CUS/mysql.cus

 ERROR 1470 (HY000) at line 1: String '<user>' is too long for user name (should be no longer than 16)

newUser Failure: mysql --defaults-file=d:/win32app/Spectrum/mysql/my-spectrum.cnf -u root -proot mysql

Error(s) occurred. Please see d:/win32app/Spectrum/Install-Tools/LOGS/10.0.0.0.251_20160113/mysql.log.

Script Install-Tools/CUS/mysql.cus has FAILED

********** Completed: Wed Jan 13 18:28:17 2016 **********

And

********** Started: Wed Jan 13 18:29:41 2016 **********

running Custom Script Install-Tools/CUS/ddm.cus

 Creating .configrc

Error(s) occurred. Please see d:/win32app/Spectrum/Install-Tools/LOGS/10.0.0.0.251_20160113/ddm.log.

Script Install-Tools/CUS/ddm.cus has FAILED

********** Completed: Wed Jan 13 18:29:41 2016 **********

Environment

Release: 10.2.x and 10.3.x
Component: Spectrum Archive Manager

Cause

If the Spectrum Owner's user name is longer than 16 characters, it will cause the Spectrum Install to complete with failures. The 16 character limitation is set by MySQL and not Spectrum. The result of the failures are:

1. The Spectrum Owner account will not be added in mysql.
2. The ddmdb database does not get created.

As a result Archive Manager will not be able to run.
 

Resolution

To resolve this issue:

1. Shorten the Spectrum Owner user name to 16 characters or less.
2. Uninstall Spectrum
3. Reboot the server
4. Reinstall Spectrum so that it uses the new account, which will allow the MySQL configuration to complete and the DDMdb database will be created.

This issue has been fixed in DX Spectrum 10.4.1 release.

https://techdocs.broadcom.com/content/broadcom/techdocs/us/en/ca-enterprise-software/it-operations-management/spectrum/10-4-1/release-information/issues-resolved.html

Symptom:
Installer throws a 'Username exceeded the maximum allowed length of 16 characters' error.

Resolution:
Now, the maximum install username length is increased to 32. (DE428276, 20046377, 10.4.1)