AWI can not complete login Invalid URL in MQSRV_RestEndpoint: null

Products

• CA Automic Workload Automation - Automation Engine
• CA Automic One Automation

Issue/Introduction

When attempting to log in, the login fails and the JWP generates a trace with the following:

20210428/171717.919 - 42               ----------------------- Stack Trace -----------------------
20210428/171717.935 - 42               java.lang.IllegalStateException: Invalid URL in MQSRV_RestEndpoint: null
20210428/171717.935 - 42                at com.automic.persistence.impl.AdministrationRepositoryImpl$1.processRow(AdministrationRepositoryImpl.java:27)
20210428/171717.935 - 42                at com.automic.database.impl.DBConnectionImpl.handleResult(DBConnectionImpl.java:529)
20210428/171717.935 - 42                at com.automic.database.impl.DBConnectionImpl.executeInternal(DBConnectionImpl.java:463)
20210428/171717.935 - 42                at com.automic.database.impl.DBConnectionImpl.select(DBConnectionImpl.java:382)

Environment

Release : 12.3.x

                 21.x

Component : AUTOMATION ENGINE

Cause

JCP is not up or registered within the database. 

Resolution

This can be caused when the JCP does not yet have a registration within the database. 

Run the following query against the DB:

SELECT MQSRV_RestEndpoint from MQSRV where MQSRV_Type = 32 AND MQSRV_MQSet = ?

Where the MQSet is your currently active MQSet.

If that returns no rows, then the JCP has not started. Check the JCP log for the line:

REST Endpoint registered as http:/<servername>:8088

If that is present, please provide this information and open a case with Broadcom Support 

Another possible cause could be that SSL had been activated in the past so you should check the 'sslEnabled' flag in the ucsrv.ini file.

If SSL is not used this parameter should be set to 0.

Change sslEnabled=1 to sslEnabled=0 save the AE configuration file and restart the JCP