CA Business Intelligence upgrade from 6.30 to 7.11 is successful but logon fails with HTTP 404

book

Article ID: 205442

calendar_today

Updated On:

Products

CA Unified Infrastructure Management On-Premise (Nimsoft / UIM) NIMSOFT PROBES DX Infrastructure Management

Issue/Introduction

Environment:
CA CABI 7.11 controlled UIM version (Build 20190405_0833) installed on Windows

Problem:
CA CABI upgrade from 6.30 to 7.11 is successfully but logon fails with HTTP/1.1 404

Errors captured:

catalina*.log:

WARNING [localhost-startStop-1] org.apache.naming.NamingContext.lookup Unexpected exception resolving reference
 java.lang.RuntimeException: Failed to decrypt

*tomcat*.err:

WARNING [localhost-startStop-1] org.apache.naming.NamingContext.lookup Unexpected exception resolving reference
 java.lang.RuntimeException: Failed to decrypt

localhost*.log:

[Root exception is java.lang.RuntimeException: Failed to decrypt]

Cause

CA Business Intelligence is unable to decrypt the postgres user password

Environment

Release : 20.1, 20.3

Component : CA BUSINESS INTELLIGENCE

Resolution

1. Go to cabi server folder structure and open ../ca business intelligence /apache-tomcat/webapps/jasperserver-pro/META-INF and edit context.xml file(after having a backup of this file) .
2. Then for all the postgres username related configurations in the file, remove the encrypted password and enter the password in plain text. Save the file.

Example:

From

  <Resource accessToUnderlyingConnectionAllowed="true" auth="Container" driverClassName="org.postgresql.Driver" factory="com.jaspersoft.jasperserver.tomcat.jndi.JSCommonsBasicDataSourceFactory" maxActive="100" maxIdle="30" maxWait="10000" name="jdbc/jasperserver" password="ENC-c23924889e17929960f288723c7a9d63aeb6806056acdd650ddea8a149d240fd-" testOnBorrow="true" type="javax.sql.DataSource" url="jdbc:postgresql://localhost:5432/jasperserver" username="postgres" validationQuery="SELECT 1"/>

To:

   <Resource accessToUnderlyingConnectionAllowed="true" auth="Container" driverClassName="org.postgresql.Driver" factory="com.jaspersoft.jasperserver.tomcat.jndi.JSCommonsBasicDataSourceFactory" maxActive="100" maxIdle="30" maxWait="10000" name="jdbc/jasperserver" password="mypostgresuserpassword" testOnBorrow="true" type="javax.sql.DataSource" url="jdbc:postgresql://localhost:5432/jasperserver" username="postgres" validationQuery="SELECT 1"/>


3. Restart CA CABI server.