Reporter generation stays in RUNNING when database connection fails during the operation.

Document ID : KB000087047
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
Affects Release version(s): 5

Error Message :
 The following error message is present in the server.log file:
#########################
org.springframework.dao.DataAccessResourceFailureException: Cannot open connection; nested exception is org.hibernate.exception.JDBCConnectionException: Cannot open connection 
Caused by: 
org.hibernate.exception.JDBCConnectionException: Cannot open connection 
    at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:74) 
    at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43) 
    at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29) 
    at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:420) 
    at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:144) 
    at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:139) 
    at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1538) 
    at org.hibernate.loader.Loader.doQuery(Loader.java:661) 
    at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224) 
    at org.hibernate.loader.Loader.doList(Loader.java:2211) 
    at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2095) 
    at org.hibernate.loader.Loader.list(Loader.java:2090) 
    at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:388) 
    at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338) 
    at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172) 
    at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121) 
    at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79) 
    at com.orsyp.reppub.server.manager.db.HibernateCallbackImpl.doInHibernate(HibernateCallbackImpl.java:46) 
    at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:362) 
    at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:328) 
    at com.orsyp.reppub.server.manager.report.ReportExecutionStatusPM.getLastReportExecutionList(ReportExecutionStatusPM.java:123) 
    at com.orsyp.reppub.server.command.rep.reports.ListReportDefinitionsNeverExecuted.internalLaunchCommand(ListReportDefinitionsNeverExecuted.java:58) 
    at com.orsyp.reppub.server.command.Command.launchCommand(Command.java:30) 
    at com.orsyp.reppub.server.CommandInterpretor.commandRecived(CommandInterpretor.java:119) 
    at com.orsyp.reppub.server.communication.NetDispatcher.run(NetDispatcher.java:38) 
    at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) 
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) 
    at java.lang.Thread.run(Thread.java:662) 
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Connection reset
######################### 

Patch level detected:Reporter 3.0.0
Product Version: Dollar.Universe 5.6.0 FX25010

Description :Reporter generation stays in RUNNING when database connection fails during the operation.
Environment:
OS: All
OS Version: ALL
Cause:
Cause type:
Defect
Root Cause: N/A
Resolution:
Update to the fix version listed below or a newer version if available.

Fix Status: Released

Fix Version(s):
Component: Reporter
Version: Dollar.Universe 6.0.0
Additional Information:
Workaround :
N/A