SsoConfig utility is not working

Document ID : KB000097696
Last Modified Date : 23/05/2018
Show Technical Document Details
Issue:
We configured SSL settings for CA Performance center and after reverting the changes SsoConfig utility fails to connect 

[root@PerformanceCenter]# ./SsoConfig
Single Sign-On Configuration Tool
Enter q to quit the program or b to go back to previous menu

SSO Configuration:
1. CA Performance Center
Choose an option > 1

SSO Configuration/CA Performance Center:
1. LDAP Authentication
2. SAML2 Authentication
3. Performance Center
4. Single Sign-On
5. Test LDAP
6. Export SAML2 Service Provider Metadata
7. Enable FIPS
Choose an option > 4

SSO Configuration/CA Performance Center/Single Sign-On:
Cannot connect to the CA Performance Center SSO Web Service.
Check if CA Performance Center is running and retry.
Environment:
CA Performance Center 3.5
Cause:
SSO Service fails to connect to caperfcenter_console service.

PCService.log shows

org.springframework.web.client.HttpServerErrorException: 503 Service Unavailable
        at org.springframework.web.client.DefaultResponseErrorHandler.handleError(DefaultResponseErrorHandler.java:92)
        at org.springframework.web.client.RestTemplate.handleResponseError(RestTemplate.java:494)

Console Service fails to connect to caperfcenter_devicemanager service

DMService.log shows 

Caused by: java.lang.IllegalArgumentException: Invalid enumeration value: 8382 for enumeration class com.ca.im.portal.api.net.Protocol
        at com.ca.im.portal.api.util.ValueEnumMapHelper.fromValue(ValueEnumMapHelper.java:57)
        at com.ca.im.portal.api.net.Protocol.fromString(Protocol.java:38)
        at com.ca.im.portal.dm.datasourcedb.DBDataSourceDAO.loadAddress(DBDataSourceDAO.java:868)
        at com.ca.im.portal.dm.datasourcedb.DBDataSourceDAO.loadDataSourceContact(DBDataSourceDAO.java:796)
        at com.ca.im.portal.dm.datasourcedb.DBDataSourceDAO.buildDataSourceFromRow(DBDataSourceDAO.java:757)
        at com.ca.im.portal.dm.datasourcedb.DBDataSourceDAO.loadDataSources(DBDataSourceDAO.java:70)
        at com.ca.im.portal.api.services.datasource.DataSourceService.updateCache(DataSourceService.java:447)
        at com.ca.im.portal.api.services.datasource.DataSourceService.refreshCache(DataSourceService.java:384)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:498)
        at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor$LifecycleElement.invoke(InitDestroyAnnotationBeanPostProcessor.java:346)
        at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor$LifecycleMetadata.invokeInitMethods(InitDestroyAnnotationBeanPostProcessor.java:299)
        at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor.postProcessBeforeInitialization(InitDestroyAnnotationBeanPostProcessor.java:132)
        ... 137 more
 
Resolution:
The Consoleport and ConsoleProtocol field values in the data_sources2 table are incorrect within netqosportal database .

Please ssh into to the CA Performance Center Server

a)Stop CA Performance Center services.

service caperfcenter_sso stop &&
service caperfcenter_devicemanager  stop &&
service caperfcenter_eventmanager stop &&
service caperfcenter_console stop

b) mysql -u(username) -p(password) netqosportal 
c) select SourceID,ConsoleName,ConsoleHost,ConsolePort,ConsoleProtocol from data_sources2;

+----------+-----------------------------------------+---------------+-------------+-----------------+
| SourceID | ConsoleName                             | ConsoleHost   | ConsolePort | ConsoleProtocol |
+----------+-----------------------------------------+---------------+-------------+-----------------+
|        0 | CA Performance Center                   | xx.xxx.xx.xx  |        8382 | 8382            |

d) Update the values within the data_sources2 table

UPDATE `netqosportal`.`data_sources2` SET `ConsolePort`='8181', `ConsoleProtocol`='http' WHERE  `SourceID`=0;

Note : Depending on what port/protocol you are using for CAPC webaccess please set the above values.

e) Start CA Performance center Services

service caperfcenter_sso start &&
service caperfcenter_devicemanager  start &&
service caperfcenter_eventmanager start &&
service caperfcenter_console start