Jaspersoft login page error HTTP Status 404

Document ID : KB000007037
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

When opening the URL for the Jaspersoft login page, below error is presented:

 

TEC1269604a.png

 

Checking at jasperserver.log files, there are several messages as below (in this case Oracle database is referred, but it might happen for other RDBMS).

 

ERROR JDBCExceptionReporter,localhost-startStop-2:101 - Cannot create PoolableConnectionFactory ([TibcoSoftwareInc][Oracle JDBC Driver][Oracle]ORA-28000: the account is locked

Environment:
SM 14.1Jasperserver 6.2.0
Cause:

The explanation is that for some reason the Jaspersoft account to connect to the database has been locked.

Resolution:

Reset the password in both the RDBMS used (PostgreSQL, MySQL, MS-SQL, Oracle) and in Jasper Server application.

 

 

 

Below process documents an example of Oracle database and Jaspersoft database user named as "admjasper".

 

 

 

- stop Jasper Server

 

- make sure you can login to Oracle with that user "admjasper" 

 

- if not, reset the password on the database user account

 

- make sure the same database user password is defined in context.xml file located, for example, under: 

 

"..\Program Files\Apache Software Foundation\Tomcat 8.0\webapps\jasperserver-pro\META-INF" 

 

   a. Open the file with a text editor: 

 

   b. Replace the details on the connection, enter the pwd in non-encrypted way for Oracle, save and restart Jaspersoft. 

 

       username="admjasper" password="ENC-a14dc8cb4fd2d728f344ff9ed6bc84ac6a9761d5c8600ea64d3a08a8bcb39b8a-" 

 

       to 

 

       username="admjasper" password="<type password in plain-text here>" 

 

- restart Jasper 

 

 

Additional Information:

How to change the password for jasperdb