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

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

book

Article ID: 276951

calendar_today

Updated On:

Products

DX Unified Infrastructure Management (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 parameter 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