CABI Home page is empty or blank after upgrading UIM to 23.4

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)
• CA Unified Infrastructure Management On-Premise (Nimsoft / UIM)
• CA Unified Infrastructure Management SaaS (Nimsoft / UIM)

Issue/Introduction

 After Upgrading UIM to 23.4, CABI Home page is not visible. The cabi home page is empty or blank. There is no content on the page.

When the CABI home page is successfully rendered, it should appear as:

Environment

• UIM 23.4
• cabi 23.4
• Windows Authentication 

Cause

jasperserver.log shows the error shown below:

2024-05-23T11:05:27,496 ERROR SqlExceptionHelper,pool-6-thread-9:142 - Cannot create PoolableConnectionFactory ([TibcoSoftware][SQLServer JDBC Driver]Kerberos Authentication is not supported by this SQLServer. The driver attempted Kerberos authentication because the AuthenticationMethod connect option was "auto" and no username/password was specified.)

When the browser Dev tools are displayed via F12 and the page is hit/refreshed, it throws an 'Unable to acquire JDBC authentication' and/or '500 Internal Server error.'

Request Method
    GET
    Status Code
    500 Internal Server Error
    Remote Address
    ##.###.#.###:80
    Referrer Policy
    strict-origin-when-cross-origin

Resolution

Please follow the steps listed below:

1. Stop the cabi and wasp probes 

2.  On the cabi server go to /Nimsoft/probes/service/wasp/webapps/cabijs/META-INF/context.xml

     For Windows Authentication Environment:

3. Edit the context.xml file

---

<?xml version="1.0" encoding="UTF-8" standalone="no"?>

<header content removed for this Article>

    <Resource accessToUnderlyingConnectionAllowed="true" auth="Container" driverClassName="tibcosoftware.jdbc.sqlserver.SQLServerDriver" factory="com.jaspersoft.jasperserver.tomcat.jndi.JSCommonsBasicDataSourceFactory" maxActive="100" maxIdle="30" maxWait="10000" name="jdbc/jasperserver" password="<encrypted_password_string_removed>" testOnBorrow="true" type="javax.sql.DataSource" url="jdbc:tibcosoftware:sqlserver://<UIM_DB_Hostname>1:<DB_port_number>;databaseName=<UIM_DB_Name>;sendTimestampEscapeAsString=false;integratedSecurity=true;AuthenticationMethod=ntlm" username="" validationQuery="SELECT 1"/>

<Resource accessToUnderlyingConnectionAllowed="true" auth="Container" driverClassName="tibcosoftware.jdbc.sqlserver.SQLServerDriver" factory="com.jaspersoft.jasperserver.tomcat.jndi.JSCommonsBasicDataSourceFactory" maxActive="100" maxIdle="30" maxWait="10000" name="jdbc/jasperserverAudit" password="<encrypted_password_string_removed>" testOnBorrow="true" type="javax.sql.DataSource" url="jdbc:tibcosoftware:sqlserver://<UIM_DB_Hostname>1:<DB_port_number>;databaseName=<UIM_DB_Name>;sendTimestampEscapeAsString=false;integratedSecurity=true;AuthenticationMethod=ntlm" username="" validationQuery="SELECT 1"/>   

<!-- Comment this line to enable session persistence across Tomcat restarts -->

<footer/bottom of context.xml file removed for this article>

</Context>

---

4. Save the changes

5. Select both cabi and wasp probes

6. Click Activate

7. Refresh the cabi home page and see if it is populated