Adding Spectrum Data Source in Performance Management fails

book

Article ID: 198526

calendar_today

Updated On:

Products

CA Infrastructure Management CA Performance Management - Usage and Administration DX NetOps

Issue/Introduction

Performance Center host failed requiring rebuild on a new host. No backups of the PC MySql DB's were available.

Performance Center was rebuilt clean, same as a new first time install.

Performance Center was integrated with Spectrum.

When trying to add the Spectrum Data Source to the rebuilt Performance Center host it fails with the following message.

The following errors are also observed in the Performance Center console service PCService.log files or wrapper.log files.

INFO   | jvm 1    | 2020/08/31 10:20:42 | INFO  | qtp2125167811-200        | 2020-08-31 10:20:42,340 | com.ca.im.portal.api.services.datasource.DataSourceBuilderImpl   
INFO   | jvm 1    | 2020/08/31 10:20:42 |       | commit data source (with id):Spectrum Infrastructure [email protected]_HostName
INFO   | jvm 1    | 2020/08/31 10:20:42 | INFO  | qtp2125167811-200        | 2020-08-31 10:20:42,342 | org.apache.cxf.service.factory.ReflectionServiceFactoryBean      
INFO   | jvm 1    | 2020/08/31 10:20:42 |       | Creating Service {http://netqos.com/DataSourceWS}IDataSourceWSService from class com.ca.im.portal.api.datasources.interfaces.datasourcews.IDataSourceWS
INFO   | jvm 1    | 2020/08/31 10:20:42 | INFO  | qtp2125167811-200        | 2020-08-31 10:20:42,436 | org.apache.cxf.service.factory.ReflectionServiceFactoryBean      
INFO   | jvm 1    | 2020/08/31 10:20:42 |       | Creating Service {http://netqos.com/ProductSync2WS}IProductSync2WSService from class com.ca.im.portal.api.datasources.interfaces.productsync2ws.IProductSync2WS
INFO   | jvm 1    | 2020/08/31 10:20:42 | WARN  | qtp2125167811-200        | 2020-08-31 10:20:42,555 | com.ca.im.portal.api.services.datasource.DataSourceBuilderImpl   
INFO   | jvm 1    | 2020/08/31 10:20:42 |       | commit (with id) failed - exception: enum.datasourceerror.ALREADY_REGISTERED

Cause

Database on Spectrum OC host still contains strings and references to old Performance Center host.

Environment

All supported releases

Resolution

Take the following steps to reset the Spectrum OC host.

  1. Remove the Performance Center integration database from CA Spectrum. Log into the OC host and open a command line. Run the following commands, entering the DB password when prompted in command #4.
    1. bash -login
    2. cd mysql
    3. cd bin
    4. ./mysqladmin --defaults-file=../my-spectrum.cnf -unetqos -ppassword drop netqos_integ
  2. Restart CA Spectrum OC hosts tomcat service using the following commands.
    1. cd Spectrum_Install_Directory/tomcat/bin
    2. ./stopTomcat.sh
    3. ./starttomcat.sh
  3. Add the Spectrum Data Source again in Performance Center after the Spectrum OC host tomcat service is restarted.

Attachments