HTTP Status 500 – Internal Server Error


Type Exception Report

Message org.springframework.dao.EmptyResultDataAccessException: Incorrect result size: expected 1, actual 0

Description The server encountered an unexpected condition that prevented it from fulfilling the request.

Exception

javax.servlet.ServletException: org.springframework.dao.EmptyResultDataAccessException: Incorrect result size: expected 1, actual 0
	org.glassfish.jersey.servlet.WebComponent.service(WebComponent.java:353)
	org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:372)
	org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:335)
	org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:218)
	org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)
	org.tuckey.web.filters.urlrewrite.RuleChain.handleRewrite(RuleChain.java:176)
	org.tuckey.web.filters.urlrewrite.RuleChain.doRules(RuleChain.java:145)
	org.tuckey.web.filters.urlrewrite.UrlRewriter.processRequest(UrlRewriter.java:92)
	org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:394)
	gov.fda.nctr.fdalabel.CacheFilter.doFilter(CacheFilter.java:27)

Root Cause

org.springframework.dao.EmptyResultDataAccessException: Incorrect result size: expected 1, actual 0
	org.springframework.dao.support.DataAccessUtils.requiredSingleResult(DataAccessUtils.java:71)
	org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate.queryForObject(NamedParameterJdbcTemplate.java:196)
	org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate.queryForObject(NamedParameterJdbcTemplate.java:202)
	org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate.queryForObject(NamedParameterJdbcTemplate.java:214)
	gov.fda.nctr.fdalabel.dataaccess.DAO.getSplUtf8Blob(DAO.java:3023)
	gov.fda.nctr.fdalabel.dataaccess.DAO.getSplWithAlternateStylesheet(DAO.java:2934)
	gov.fda.nctr.fdalabel.Spls.splDocument(Spls.java:703)
	sun.reflect.GeneratedMethodAccessor34.invoke(Unknown Source)
	sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	java.lang.reflect.Method.invoke(Method.java:498)
	org.glassfish.jersey.server.model.internal.ResourceMethodInvocationHandlerFactory$1.invoke(ResourceMethodInvocationHandlerFactory.java:81)
	org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.invoke(AbstractJavaResourceMethodDispatcher.java:128)
	org.glassfish.jersey.server.model.internal.JavaResourceMethodDispatcherProvider$TypeOutInvoker.doDispatch(JavaResourceMethodDispatcherProvider.java:195)
	org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.dispatch(AbstractJavaResourceMethodDispatcher.java:94)
	org.glassfish.jersey.server.model.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:353)
	org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:343)
	org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:102)
	org.glassfish.jersey.server.ServerRuntime$1.run(ServerRuntime.java:237)
	org.glassfish.jersey.internal.Errors$1.call(Errors.java:271)
	org.glassfish.jersey.internal.Errors$1.call(Errors.java:267)
	org.glassfish.jersey.internal.Errors.process(Errors.java:315)
	org.glassfish.jersey.internal.Errors.process(Errors.java:297)
	org.glassfish.jersey.internal.Errors.process(Errors.java:267)
	org.glassfish.jersey.process.internal.RequestScope.runInScope(RequestScope.java:322)
	org.glassfish.jersey.server.ServerRuntime.process(ServerRuntime.java:211)
	org.glassfish.jersey.server.ApplicationHandler.handle(ApplicationHandler.java:979)
	org.glassfish.jersey.servlet.WebComponent.service(WebComponent.java:344)
	org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:372)
	org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:335)
	org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:218)
	org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)
	org.tuckey.web.filters.urlrewrite.RuleChain.handleRewrite(RuleChain.java:176)
	org.tuckey.web.filters.urlrewrite.RuleChain.doRules(RuleChain.java:145)
	org.tuckey.web.filters.urlrewrite.UrlRewriter.processRequest(UrlRewriter.java:92)
	org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:394)
	gov.fda.nctr.fdalabel.CacheFilter.doFilter(CacheFilter.java:27)

Note The full stack trace of the root cause is available in the server logs.


Apache Tomcat/8.5.90