search cancel

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

book

Article ID: 134277

calendar_today

Updated On:

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)

Cause

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

Environment

Release : Any

Component : Clarity Jaspersoft

Resolution

Work with your internal Network team to resolve the issue.

Additional Information

See also: Jaspersoft / reports known issues with Clarity