After upgrade login to DX NetOps not working

Products

• CA Performance Management - Usage and Administration
• DX NetOps

Issue/Introduction

After upgrading from 22.2.3 to 22.2.4 and resolving a DB problem login to DX Console is not possible. The redirection to the 8381 SSO port fails with error 500.

SSO logs show following error:

INFO  | server-51         | 2022-12-01 11:26:48,623 | org.apache.cxf.wsdl.service.factory.ReflectionServiceFactoryBean
      | Creating Service {http://netqos.com/SingleSignOnWS}SingleSignOnWSSoapService from class com.netqos.singlesignonws.SingleSignOnWSSoap
WARN  | server-51         | 2022-12-01 11:26:48,665 | org.eclipse.jetty.server.HttpChannel            
      | /sso/sign-in.jsp
javax.servlet.ServletException: org.apache.jasper.JasperException: An exception occurred processing [/sign-in.jsp] at line [142]

139:     URL urlSingleSignOnWS = new URL(urlUtility.constructUrl(scheme, "127.0.0.1", port, pathAndQuery));
140:     SingleSignOnWSSoap singleSignOnWSSoap = DynamicJaxWsProxyFactory.create(
141:             SingleSignOnWSSoap.class, urlSingleSignOnWS.toString(), Utils.getCookieURLEntry(urlSingleSignOnWS.toString(),Utils.REST_USER_ADMIN_ID));
142:     LoginFailureTrackerConfig trackerconf=new LoginFailureTrackerSoapConfig(singleSignOnWSSoap);
143:     WebApplicationContext context = WebApplicationContextUtils.getRequiredWebApplicationContext( request.getServletContext() );
144:     LoginFailureTracker loginFailureTracker = (LoginFailureTracker)context.getBean( "loginFailureTracker" );
145:     NatProxyPath npp=new NatProxyPath(request);

Stacktrace:
        at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:162) ~[jetty-server-9.4.49.v20220914.jar:9.4.49.v20220914]

.........

Environment

Release : 22.2

Cause

Check SSO wrapper log for errors like this:

INFO   | jvm 1    | 2022/12/01 06:38:36 | Caused by: java.sql.SQLSyntaxErrorException: PROCEDURE netqosportal.sp_user_definitions_get_one_user_by_id does not exist

 

That's the issue;
missing procedures.

Resolution

bring down PM services except mysql

cd /opt/CA/PerformanceCenter/SQL/Functions
for file in *.sql; do mysql -p netqosportal -e "source $file;"; done
cd /opt/CA/PerformanceCenter/SQL/Procedures
for file in *.sql; do mysql -p netqosportal -e "source $file;"; done