dhis2-devs team mailing list archive

Thread
Date
Re: Error occured when accessing the webapi of data elements

To: 'Tanusree Bag' <tanusree.bag@xxxxxxxxx>, <dhis2-devs@xxxxxxxxxxxxxxxxxxx>
From: Paulo Grácio <pgracio@xxxxxxxxxxxxxxxxxxxx>
Date: Thu, 18 Apr 2013 14:38:56 +0200
In-reply-to: <CAMswFjV-xULHUvEUe0DqzZiHPQPk8zgCFtOZBkyGnLKUq25YAA@mail.gmail.com>
Mls-mark-acronym: PUBLIC
Mls-mark-id: 67
Mls-user: p-gracio
Thread-index: AQLMeMhiqCs+9A8TzGu+Y7HHnRYxkJbfcXUg
Hi,

 

If you run this query on your database does it returns any row?

 

select * from dataset where datasetid = 544

 

Regards,

Paulo Grácio

 

From: Dhis2-devs
[mailto:dhis2-devs-bounces+pgracio=criticalsoftware.com@xxxxxxxxxxxxxxxxxxx]
On Behalf Of Tanusree Bag
Sent: quinta-feira, 18 de Abril de 2013 14:33
To: dhis2-devs@xxxxxxxxxxxxxxxxxxx
Subject: [Dhis2-devs] Error occured when accessing the webapi of data
elements

 

Hello All,

 

We are facing an HTTP status 500 error while trying to access the webapi of
data elements (URL : IP/dhis/api/dataElements). It may be the reason why the
"Available Data Elements" are not getting populated in different part of the
application and timing out.

 

It seems the error is due to not finding a dataset No row with the given
identifier exists: [org.hisp.dhis.dataset.DataSet#544]

 

 

We are not sure exactly what is the underlying cause of this error. Please
help us to fix this error

 

The log is copy/pasted below

 


HTTP Status 500 -

  _____  


type Exception report

message

description The server encountered an internal error () that prevented it
from fulfilling this request.

exception

org.springframework.web.util.NestedServletException: Request processing
failed; nested exception is org.hibernate.ObjectNotFoundException: No row
with the given identifier exists: [org.hisp.dhis.dataset.DataSet#544]
 
org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkSer
vlet.java:932)
 
org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java
:816)
        javax.servlet.http.HttpServlet.service(HttpServlet.java:621)
 
org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.ja
va:801)
        javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
 
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilte
r(FilterChainProxy.java:330)
 
org.springframework.security.web.access.intercept.FilterSecurityInterceptor.
invoke(FilterSecurityInterceptor.java:118)
 
org.springframework.security.web.access.intercept.FilterSecurityInterceptor.
doFilter(FilterSecurityInterceptor.java:84)
 
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilte
r(FilterChainProxy.java:342)
 
org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(
ExceptionTranslationFilter.java:113)
 
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilte
r(FilterChainProxy.java:342)
 
org.springframework.security.web.session.SessionManagementFilter.doFilter(Se
ssionManagementFilter.java:103)
 
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilte
r(FilterChainProxy.java:342)
 
org.springframework.security.web.authentication.AnonymousAuthenticationFilte
r.doFilter(AnonymousAuthenticationFilter.java:113)
 
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilte
r(FilterChainProxy.java:342)
 
org.springframework.security.web.servletapi.SecurityContextHolderAwareReques
tFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:54)
 
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilte
r(FilterChainProxy.java:342)
 
org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilt
er(RequestCacheAwareFilter.java:45)
 
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilte
r(FilterChainProxy.java:342)
 
org.springframework.security.web.authentication.www.BasicAuthenticationFilte
r.doFilter(BasicAuthenticationFilter.java:150)
 
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilte
r(FilterChainProxy.java:342)
 
org.springframework.security.web.authentication.AbstractAuthenticationProces
singFilter.doFilter(AbstractAuthenticationProcessingFilter.java:183)
 
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilte
r(FilterChainProxy.java:342)
 
org.hisp.dhis.security.filter.CustomAuthenticationFilter.doFilter(CustomAuth
enticationFilter.java:54)
 
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilte
r(FilterChainProxy.java:342)
 
org.springframework.security.web.authentication.logout.LogoutFilter.doFilter
(LogoutFilter.java:105)
 
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilte
r(FilterChainProxy.java:342)
 
org.hisp.dhis.security.filter.AutomaticAccessFilter.doFilter(AutomaticAccess
Filter.java:112)
 
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilte
r(FilterChainProxy.java:342)
 
org.springframework.security.web.context.SecurityContextPersistenceFilter.do
Filter(SecurityContextPersistenceFilter.java:87)
 
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilte
r(FilterChainProxy.java:342)
 
org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterCha
inProxy.java:192)
 
org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.
java:160)
 
org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(Delegati
ngFilterProxy.java:346)
 
org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilt
erProxy.java:259)
 
org.springframework.orm.hibernate4.support.OpenSessionInViewFilter.doFilterI
nternal(OpenSessionInViewFilter.java:152)
 
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestF
ilter.java:107)
 
org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(Char
acterEncodingFilter.java:88)
 
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestF
ilter.java:107)

root cause

org.hibernate.ObjectNotFoundException: No row with the given identifier
exists: [org.hisp.dhis.dataset.DataSet#544]
 
org.hibernate.internal.SessionFactoryImpl$1$1.handleEntityNotFound(SessionFa
ctoryImpl.java:244)
 
org.hibernate.event.internal.DefaultLoadEventListener.load(DefaultLoadEventL
istener.java:210)
 
org.hibernate.event.internal.DefaultLoadEventListener.proxyOrLoad(DefaultLoa
dEventListener.java:260)
 
org.hibernate.event.internal.DefaultLoadEventListener.onLoad(DefaultLoadEven
tListener.java:148)
        org.hibernate.internal.SessionImpl.fireLoad(SessionImpl.java:1078)
 
org.hibernate.internal.SessionImpl.internalLoad(SessionImpl.java:1005)
        org.hibernate.type.EntityType.resolveIdentifier(EntityType.java:616)
        org.hibernate.type.ManyToOneType.assemble(ManyToOneType.java:247)
 
org.hibernate.collection.internal.PersistentSet.initializeFromCache(Persiste
ntSet.java:141)
 
org.hibernate.cache.spi.entry.CollectionCacheEntry.assemble(CollectionCacheE
ntry.java:57)
 
org.hibernate.event.internal.DefaultInitializeCollectionEventListener.initia
lizeCollectionFromCache(DefaultInitializeCollectionEventListener.java:141)
 
org.hibernate.event.internal.DefaultInitializeCollectionEventListener.onInit
ializeCollection(DefaultInitializeCollectionEventListener.java:68)
 
org.hibernate.internal.SessionImpl.initializeCollection(SessionImpl.java:180
4)
 
org.hibernate.collection.internal.AbstractPersistentCollection$4.doWork(Abst
ractPersistentCollection.java:549)
 
org.hibernate.collection.internal.AbstractPersistentCollection.withTemporary
SessionIfNeeded(AbstractPersistentCollection.java:234)
 
org.hibernate.collection.internal.AbstractPersistentCollection.initialize(Ab
stractPersistentCollection.java:545)
 
org.hibernate.collection.internal.AbstractPersistentCollection.read(Abstract
PersistentCollection.java:124)
 
org.hibernate.collection.internal.PersistentSet.iterator(PersistentSet.java:
180)
        org.hisp.dhis.api.utils.WebUtils.generateLinks(WebUtils.java:142)
        org.hisp.dhis.api.utils.WebUtils.generateLinks(WebUtils.java:74)
 
org.hisp.dhis.api.controller.AbstractCrudController.getObjectList(AbstractCr
udController.java:92)
        sun.reflect.GeneratedMethodAccessor1383.invoke(Unknown Source)
 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl
.java:43)
        java.lang.reflect.Method.invoke(Method.java:601)
 
org.springframework.web.method.support.InvocableHandlerMethod.invoke(Invocab
leHandlerMethod.java:219)
 
org.springframework.web.method.support.InvocableHandlerMethod.invokeForReque
st(InvocableHandlerMethod.java:132)
 
org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandle
rMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:104)
 
org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerA
dapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:745)
 
org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerA
dapter.handleInternal(RequestMappingHandlerAdapter.java:686)
 
org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.hand
le(AbstractHandlerMethodAdapter.java:80)
 
org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServl
et.java:925)
 
org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServle
t.java:856)
 
org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkSer
vlet.java:920)
 
org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java
:816)
        javax.servlet.http.HttpServlet.service(HttpServlet.java:621)
 
org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.ja
va:801)
        javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
 
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilte
r(FilterChainProxy.java:330)
 
org.springframework.security.web.access.intercept.FilterSecurityInterceptor.
invoke(FilterSecurityInterceptor.java:118)
 
org.springframework.security.web.access.intercept.FilterSecurityInterceptor.
doFilter(FilterSecurityInterceptor.java:84)
 
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilte
r(FilterChainProxy.java:342)
 
org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(
ExceptionTranslationFilter.java:113)
 
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilte
r(FilterChainProxy.java:342)
 
org.springframework.security.web.session.SessionManagementFilter.doFilter(Se
ssionManagementFilter.java:103)
 
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilte
r(FilterChainProxy.java:342)
 
org.springframework.security.web.authentication.AnonymousAuthenticationFilte
r.doFilter(AnonymousAuthenticationFilter.java:113)
 
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilte
r(FilterChainProxy.java:342)
 
org.springframework.security.web.servletapi.SecurityContextHolderAwareReques
tFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:54)
 
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilte
r(FilterChainProxy.java:342)
 
org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilt
er(RequestCacheAwareFilter.java:45)
 
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilte
r(FilterChainProxy.java:342)
 
org.springframework.security.web.authentication.www.BasicAuthenticationFilte
r.doFilter(BasicAuthenticationFilter.java:150)
 
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilte
r(FilterChainProxy.java:342)
 
org.springframework.security.web.authentication.AbstractAuthenticationProces
singFilter.doFilter(AbstractAuthenticationProcessingFilter.java:183)
 
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilte
r(FilterChainProxy.java:342)
 
org.hisp.dhis.security.filter.CustomAuthenticationFilter.doFilter(CustomAuth
enticationFilter.java:54)
 
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilte
r(FilterChainProxy.java:342)
 
org.springframework.security.web.authentication.logout.LogoutFilter.doFilter
(LogoutFilter.java:105)
 
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilte
r(FilterChainProxy.java:342)
 
org.hisp.dhis.security.filter.AutomaticAccessFilter.doFilter(AutomaticAccess
Filter.java:112)
 
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilte
r(FilterChainProxy.java:342)
 
org.springframework.security.web.context.SecurityContextPersistenceFilter.do
Filter(SecurityContextPersistenceFilter.java:87)
 
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilte
r(FilterChainProxy.java:342)
 
org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterCha
inProxy.java:192)
 
org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.
java:160)
 
org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(Delegati
ngFilterProxy.java:346)
 
org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilt
erProxy.java:259)
 
org.springframework.orm.hibernate4.support.OpenSessionInViewFilter.doFilterI
nternal(OpenSessionInViewFilter.java:152)
 
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestF
ilter.java:107)
 
org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(Char
acterEncodingFilter.java:88)
 
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestF
ilter.java:107)

note The full stack trace of the root cause is available in the Apache
Tomcat/7.0.26 logs.

  _____  


Apache Tomcat/7.0.26


Thanks,

Tanusree
Follow ups

Re: Error occured when accessing the webapi of data elements
From: Lars Helge Øverland, 2013-04-18
References

Error occured when accessing the webapi of data elements
From: Tanusree Bag, 2013-04-18