Jaspersoft does not start - Errors: "HTTP 404" / "Cannot open connection"

Products

• Clarity PPM On Premise

Issue/Introduction

Unable to bring Jaspersoft up after changes to DNS and other network changes.

Catalina.out has no issues, Tomcat starts well.

Jaspersoft reportservice does not start, and you find multiple messages in the jasperserver.log:

2019-07-08 10:02:54,369 ERROR ContextLoader,localhost-startStop-1:331 [] - Context initialization failed
org.springframework.dao.DataAccessResourceFailureException: Cannot open connection; nested exception is org.hibernate.exception.JDBCConnectionException: Cannot open connection
 at org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:631)
 at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:412)
 at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:412)
 at org.springframework.orm.hibernate3.HibernateTemplate.executeFind(HibernateTemplate.java:344)
 at com.jaspersoft.jasperserver.api.metadata.user.service.impl.ProfileAttributeServiceImpl.getAttributesBySearchCriteria(ProfileAttributeServiceImpl.java:497)
 at com.jaspersoft.jasperserver.api.metadata.user.service.impl.ProfileAttributeServiceImpl.getClientProfileAttributes(ProfileAttributeServiceImpl.java:444)
 at com.jaspersoft.jasperserver.api.metadata.user.service.impl.ProfileAttributeServiceImpl.applyProfileAttributes(ProfileAttributeServiceImpl.java:756)
 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
Caused by: org.hibernate.exception.JDBCConnectionException: Cannot open connection
 at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:97)
 at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
 at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:52)
 at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:449)
 at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:167)
 at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:161)
 at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1577)
 at org.hibernate.loader.Loader.doQuery(Loader.java:696)
Caused by: java.sql.SQLRecoverableException: IO Error: Connection reset by peer, Authentication lapse 1 ms.
 at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:794)
 at oracle.jdbc.driver.PhysicalConnection.connect(PhysicalConnection.java:688)
 at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:39)
 at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:691)
 at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)
 at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582)

Environment

Release : Any

Cause

Jaspersoft is not able to connect to the database server due to DNS changes made on the system

Resolution

Work with your internal Network team to resolve the issue.

Additional Information

See also: Jaspersoft / reports known issues with Clarity