uimapi is not working and showing page not found

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

uimapi is broken (404) post 23.4.4 upgrade form UIM 23.4.0 

Environment

UIM 23.4 CU4

 

Resolution

Can see below errors in the uimapi logs 

 
 Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'entityManagerFactory' defined in class path resource [com/ca/uim/policy/management/config/DatabaseConfig.class]: Bean instantiation via factory method failed; nested exception is org.springframework.beans.BeanInstantiationException: 
 Failed to instantiate [javax.persistence.EntityManagerFactory]: Factory method 'entityManagerFactory' threw exception; nested exception is javax.persistence.PersistenceException: [PersistenceUnit: default] Unable to build Hibernate SessionFactory; nested exception is org.hibernate.tool.schema.spi.SchemaManagementException: Schema-validation: missing table [SSRV2AlarmVariables]

Caused by: org.hibernate.tool.schema.spi.SchemaManagementException: Schema-validation: missing table [SSRV2AlarmVariables]

To fix this need to recreate the missing table SSRV2AlarmVariables

• In IM, deactivate the wasp probe of the OC server
• Run the below script in any DB IDE. Below script is for MSSQL database 

CREATE TABLE SSRV2AlarmVariables (
   id INTEGER PRIMARY KEY IDENTITY,
   probe_name  varchar(256),
   qos_name  varchar(256),
   var_name  varchar(256),
   var_description  varchar(1024)
)

• Activate the OC server's wasp probe.
• Once the wasp is up, check to access the uimapi link 

Note: If using other database type i.e Mysql or Oracle choose one of the following based on the DB type.

MySQL:

CREATE TABLE SSRV2AlarmVariables (
   id Integer AUTO_INCREMENT,
   probe_name  VARCHAR(256),
   qos_name  VARCHAR(256),
    var_name  VARCHAR(256),
    var_description  VARCHAR(1024),
   PRIMARY KEY (id)
);

 

Oracle:

CREATE TABLE SSRV2AlarmVariables (
   id NUMBER GENERATED ALWAYS AS IDENTITY PRIMARY KEY,
   probe_name  VARCHAR(256),
   qos_name  VARCHAR(256),
    var_name  VARCHAR(256),
   var_description  VARCHAR(1024)
);