404 error post changing CABI-Jaspersoft 7.1 MSSQL database password

Products

• CA Service Operations Insight (SOI)

Issue/Introduction

Post changing CABI-Jaspersoft 7.1 MSSQL database password I am unable to access the Jaspersoft web console. It gives an error: "404 Page not found".

 

 

Environment

Release : 4.2

Component : Service Operations Insight (SOI) Manager

Cabi Jaspersoft 7.1

Resolution

Recreate the password in encrypted way in Jaspersoft 7.1 using the steps below:

1. Go to your Jaspersoft Install files: $jasper_install\jasperreports-server-7.1-bin\buildomatic\default_master.properties
2. Add the below parameters to the $jasper_install\jasperreports-server-7.1-bin\buildomatic\default_master.properties
   • dbPassword=<Enter your Database Password>
   • propsToEncrypt=dbPassword
   • appServerType=tomcat
   • dbType=<Enter your Database Type> (Example oracle or sql
   • appServerDir==<Enter your Jaspersoft Installed Path> (Example C:\\App\\Jasper)
   • encrypt=true
   • Enter the correct value for dbPassword, dbType, appServerDir in plain text
      
3. Save the file.
4. Navigate to $jasper_install\jasperreports-server-7.1-bin\buildomatic
5. Run the command: js-ant refresh-config and you should see the Build Success once the execution is completed.
6. Now again go to your Jaspersoft Install files: $jasper_install\jasperreports-server-7.1-bin\buildomatic\default_master.properties
7. You will see the dbPassword encrypted (Example: dbPassword=xxxxxxxxxxx)
8. Stop the Jaspersoft services
9. Open the following file with a text editor: $JSTomcat \webapps\reportservice\META-INF\context.xml
10. Copy the encrypted database password generated in Step 9 and update the password in $JSTomcat \webapps\reportservice\META-INF\context.xml 
    • <Resource name="jdbc/jasperserver" auth="Container" type="javax.sql.DataSource"maxActive="100" maxIdle="30" maxWait="10000"username="xxxxxxxx" password="xxxxxxxxxxx" driverClassName="xxxxxxxxxx" accessToUnderlyingConnectionAllowed = "true" validationQuery="SELECT 1 FROM DUAL"testOnBorrow="true"url="jdbc:oracle:thin:@Oracle:1521/jspdb"factory="com.jaspersoft.jasperserver.tomcat.jndi.JSCommonsBasicDataSourceFactory"/>
11. Restart the Jaspersoft Services

 Note: In order to encrypt the password you will need to have the Jaspersoft Installation on the Jaspersoft server.

If error persists, check if the  keystore files (.jrsks and .jrsksp) are corrupt. These files are located in the your user home directory, for example: Administrator user home directory is C:\Users\Administrator

Please  take back up of these two files from your home directory and delete the same post backup.

Please run the below steps from buildomatic folder:

js-ant gen-config

Update the default_master.properties as earlier (enter plain password, set encrypt=true)

js-ant refresh-config

Update the context.xml file with new encrypted password

Restart the CABI server 

 

Additional Information

Follow KB article below for Cabi/Jaspersoft 6.3 or earlier database password change:

https://knowledge.broadcom.com/external/article/129054/jaspersoft-database-password-change.html