Open the following file with a text editor: $JSTomcat \webappseportservice\META-INF\context.xml
Replace the details on the connection
Enter the password in a non-encrypted way for the database
save and restart Jaspersoft
Recreate the password in encrypted way in Jaspersoft 5.6.1, 6.1, 6.4.2 and higher
Go to your Jaspersoft Install files: $jasper_install\jasperreports-server-5.6.1-bin\buildomatic\default_master.properties
Enter the correct value for Jasper DB Password in plain text
Ensure all other values are still valid, such as Tomcat directory etc.
Change the encrypt.done=true to encrypt=true
Save the file.
Now navigate to $jasper_install\jasperreports-server-5.6.1-bin\buildomatic
Run the command: js-ant refresh-config This will remove and recreate all the configuration files without deploying them to the application server.
Once done, get the context file from: $jasper_install\jasperreports-server-5.6.1-bin\buildomatic\build_conf\default\webapp\META-INF\context.xml and replace the one in $JSTomcat\webappseportservice\META-INF\context.xml
Restart Jaspersoft Tomcat
Recreate the password in encrypted way in Jaspersoft 7.1, 7.8, 8.1
Go to your Jaspersoft Install files: $jasper_install\jasperreports-server-7.1-bin\buildomatic\default_master.properties
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
Save the file.
Navigate to $jasper_install\jasperreports-server-7.1-bin\buildomatic
Run the command: js-ant refresh-config and you should see the Build Success once the execution is completed.
Now again go to your Jaspersoft Install files: $jasper_install\jasperreports-server-7.1-bin\buildomatic\default_master.properties
You will see the dbPassword encrypted (Example: dbPassword=ENC-5024da1014088fdf4dc15a8f797f98f6d976ffd98e692173674e090778296f-)
Stop the Jaspersoft services
Open the following file with a text editor: $JSTomcat \webappseportservice\META-INF\context.xml
Copy the encrypted database password generated in Step 9 and update the password in $JSTomcat \webappseportservice\META-INF\context.xml
Start the Jaspersoft Services and check the context.xml to ensure password is encrypted
Note: In order to encrypt the password you will need to have the Jaspersoft Installer extracted on the Jaspersoft server.
After the Jaspersoft Database password is corrected you should be able to login to the Jaspersoft console using superuser however the default password will not work, reach out to Broadcom Support to have the superuser password reset
However, running reports from Clarity --> Advance Reporting will continue to fail. In order to correct the same, you will need to perform the below steps
Log in to Jaspersoft as Superuser
Search for user jasperadmin under your organization you created for integrating with Clarity and edit the user
Look for tab Attributes on the right-hand panel
Delete all the attributes except domainWhitelist as that is read-only
Now log in to the Clarity application server
Navigate to CLARITY_HOME\bin and execute admin update jasperParameters