The Event Manager data source will not synchronize.
The Event Manager data source shows Unable to Contact
The Data Sources page also shows the Event Manager data source on the same version as prior to the upgrade.
In the (default path) /opt/CA/PerformanceCenter/EM/logs/EMService.log we see this error:
ERROR | qtp66491224-198 | YYYY-MM-DD HH:MM:SS,XXX | com.ca.im.portal.api.security.Encryption
| Error performing encryption operation
javax.crypto.BadPaddingException: Error finalising cipher data: pad block corrupted
at org.bouncycastle.jcajce.provider.BaseCipher.engineDoFinal(Unknown Source)
WARN | qtp66491224-198 | YYYY-MM-DD HH:MM:SS,### | com.ca.im.portal.common.web.util.GlobalAdminAuthInterceptor
| SsoToken is expired or could not be decrypted
In both the (default paths) /opt/CA/PerformanceCenter/PC/logs/PCService.log and the /opt/CA/PerformanceCenter/DM/logs/DMService.log we see this error:
ERROR | qtp341763619-246 | 2021-11-03 13:16:14,316 | com.ca.im.portal.api.services.datasource.DataSourcePoll
| Received WebServiceException from version check for data source Event Manager@<EM_Host>. CAUSE=org.apache.cxf.transport.http.HTTPException: HTTP response '401: Unauthorized' when communicating with http://<EM_Host>:8281/EventManager/DataSourceWS.asmx. MESSAGE=Could not send Message.. Returning DS_COMM_FAILURE result.
ERROR | qtp341763619-246 | 2021-11-03 13:16:14,316 | com.ca.im.portal.api.services.datasource.DataSourcePoll
| javax.xml.ws.WebServiceException: Could not send Message.
Column K is missing or set to 0 post upgrade
All supported DX NetOps Performance Management releases
The upgrade fails to copy the SsoEncryptionDecryptionKey value to the Event Manager MySql em database.
NOTE: When prompted, you will need the Netops Portal MySQL password to enter into the MySQL CLI.
Confirm the errors are gone from the logs and the Event Manager Data Source is again successfully syncing in the Portal web UI.
This is a sample of a working system. Note the highest Priority value for the netqosportal DB (0) has a value that matches the highest Priority value (1) from the em DB. If these did not match, we'd update the em DB
Priority value 1 to match the netqosportal DB Priority value 0 value.
23.3.3 and earlier
23.3.4 and later
This can also happen if a local override is set for "SsoEncryptionDecryptionKey". In that scenario you will see 2 values for each query.
In that scenario where normally netqosportal only has a value set for Priority 0 we'd see it set with a Priority 1 value as well.
If that is found use the (default path) /opt/CA/PerformanceCenter/SsoConfig tool to reset the value for the SingleSign-On SsoEncryptionDecriptionKey value.