CABI login for superuser displays a blank Home page after upgrade to CABI 23.4.0 with Oracle as the backend database

Products

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

Issue/Introduction

 

CABI Home Page

 

 

ORA-01017 error in jasperserver.log

 

org.springframework.transaction.CannotCreateTransactionException: Could not open Hibernate Session for transaction; nested exception is org.hibernate.exception.GenericJDBCException: Unable to acquire JDBC Connection
at org.springframework.orm.hibernate5.HibernateTransactionManager.doBegin(HibernateTransactionManager.java:598)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.startTransaction(AbstractPlatformTransactionManager.java:400)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:373)
at org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:595)
at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:382)
org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory ([TibcoSoftware][Oracle JDBC Driver][Oracle]ORA-01017: invalid username/password; logon denied

Environment

• Version: 23.4, 23.4 CU1
• Component: cabi 23.4.0

Cause

../Nimsoft/probes/service/wasp/webapps/cabijs/META-INF/context.xml is not properly updated

Resolution

Follow steps below on the CABI robot

1. Stop the wasp probe

2, Backup the /opt/nimsoft/probes/service/wasp/webapps/cabijs/META-INF/context.xml file outside the original path.

3. Open the context.xml file and replace all the Oracle SID parameters with serviceName

In this example the Oracle servicename is PDB:

<Resource accessToUnderlyingConnectionAllowed="true" auth="Container" driverClassName="tibcosoftware.jdbc.oracle.OracleDriver" factory="com.jaspersoft.jasperserver.tomcat.jndi.JSCommonsBasicDataSourceFactory" maxActive="100" maxIdle="30" maxWait="10000" name="jdbc/jasperserverAudit" password="<encrypted password>" testOnBorrow="true" type="javax.sql.DataSource" url="jdbc:tibcosoftware:oracle://<oracleservername>:1521;serviceName=<pdb>" username="cauim" validationQuery="SELECT 1 FROM DUAL"/>

4. Save the changes and activate the probe.

5. Login directly to CABIJS portal with superuser and validate if the Home Page renders