← Back to team overview

dhis2-devs team mailing list archive

  1. dhis2-devs team
  2. Mailing list archive
  3. Message #01262

Re: Global ranges

  Thread Previous • Date Previous • • Thread Next 
Hi,

Most likely this is pg security restriction. Open PGadmin and navigate to minmaxdataelement table, right click and select properties. Make sure if owner is the same as other tables. This should solve the issue.

regards,
murod



----- Original Message ----
From: "johansa@xxxxxxxxxx" <johansa@xxxxxxxxxx>
To: Knut Staring <knutst@xxxxxxxxx>
Cc: dhis2-devs@xxxxxxxxxxxxxxxxxxx
Sent: Monday, June 8, 2009 10:51:06 PM
Subject: Re: [Dhis2-devs] Global ranges

After running the below statement and trying to access Data Entry, we get
this error. Any ideas about what causes the "ERROR: permission denied for
relation minmaxdataelement"?

[+]  Exception (org.hibernate.exception.SQLGrammarException): could not
execute query

    *
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
    *
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
    * org.hibernate.loader.Loader.doList(Loader.java:2216)
    * org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
    * org.hibernate.loader.Loader.list(Loader.java:2099)
    *
org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:94)
    * org.hibernate.impl.SessionImpl.list(SessionImpl.java:1569)
    * org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:283)
    *
org.hisp.dhis.minmax.hibernate.HibernateMinMaxDataElementStore.getMinMaxDataElements(HibernateMinMaxDataElementStore.java:134)
    *
sun.reflect.NativeMethodAccessorImpl.invoke0(NativeMethodAccessorImpl.java:-2)
    *
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    *
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    * java.lang.reflect.Method.invoke(Method.java:597)
    *
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)
    *
org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
    *
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
    *
org.hisp.dhis.transaction.TransactionInterceptor.invoke(TransactionInterceptor.java:75)
    *
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
    *
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
    * $Proxy31.getMinMaxDataElements(Unknown source)
    *
org.hisp.dhis.de.action.multidimensional.FormAction.execute(FormAction.java:476)
    *
sun.reflect.NativeMethodAccessorImpl.invoke0(NativeMethodAccessorImpl.java:-2)
    *
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    *
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    * java.lang.reflect.Method.invoke(Method.java:597)
    *
com.opensymphony.xwork.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:358)
    *
com.opensymphony.xwork.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:218)
    *
com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:192)
    *
org.hisp.dhis.webwork.interceptor.AbstractPreResultListener.intercept(AbstractPreResultListener.java:71)
    *
com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
    *
org.hisp.dhis.webwork.interceptor.WebWorkTransactionInterceptor.intercept(WebWorkTransactionInterceptor.java:79)
    *
com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
    *
com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31)
    *
com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
    *
com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31)
    *
com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
    *
com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31)
    *
com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
    *
com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31)
    *
com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
    *
com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31)
    *
com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
    *
com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31)
    *
com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
    *
com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31)
    *
com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
    *
org.hisp.dhis.webwork.interceptor.WebWorkDisplayPropertyInterceptor.intercept(WebWorkDisplayPropertyInterceptor.java:90)
    *
com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
    *
org.hisp.dhis.webwork.interceptor.WebWorkSortOrderInterceptor.intercept(WebWorkSortOrderInterceptor.java:124)
    *
com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
    *
org.hisp.dhis.security.intercept.WebWorkSecurityInterceptor.intercept(WebWorkSecurityInterceptor.java:98)
    *
com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
    *
com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31)
    *
com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
    *
com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31)
    *
com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
    *
com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31)
    *
com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
    *
com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31)
    *
com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
    *
org.hisp.dhis.webwork.interceptor.WebWorkExceptionInterceptor.intercept(WebWorkExceptionInterceptor.java:89)
    *
com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
    *
com.opensymphony.xwork.DefaultActionProxy.execute(DefaultActionProxy.java:116)
    *
com.opensymphony.xwork.ActionChainResult.execute(ActionChainResult.java:156)
    *
com.opensymphony.xwork.DefaultActionInvocation.executeResult(DefaultActionInvocation.java:313)
    *
com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:208)
    *
org.hisp.dhis.webwork.interceptor.AbstractPreResultListener.intercept(AbstractPreResultListener.java:71)
    *
com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
    *
org.hisp.dhis.webwork.interceptor.WebWorkTransactionInterceptor.intercept(WebWorkTransactionInterceptor.java:79)
    *
com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
    *
com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31)
    *
com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
    *
com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31)
    *
com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
    *
com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31)
    *
com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
    *
com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31)
    *
com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
    *
com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31)
    *
com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
    *
com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31)
    *
com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
    *
com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31)
    *
com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
    *
org.hisp.dhis.webwork.interceptor.WebWorkDisplayPropertyInterceptor.intercept(WebWorkDisplayPropertyInterceptor.java:90)
    *
com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
    *
org.hisp.dhis.webwork.interceptor.WebWorkSortOrderInterceptor.intercept(WebWorkSortOrderInterceptor.java:124)
    *
com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
    *
org.hisp.dhis.security.intercept.WebWorkSecurityInterceptor.intercept(WebWorkSecurityInterceptor.java:98)
    *
com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
    *
com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31)
    *
com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
    *
com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31)
    *
com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
    *
com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31)
    *
com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
    *
com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31)
    *
com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
    *
org.hisp.dhis.webwork.interceptor.WebWorkExceptionInterceptor.intercept(WebWorkExceptionInterceptor.java:89)
    *
com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
    *
com.opensymphony.xwork.DefaultActionProxy.execute(DefaultActionProxy.java:116)
    *
com.opensymphony.webwork.dispatcher.DispatcherUtils.serviceAction(DispatcherUtils.java:273)
    *
com.opensymphony.webwork.dispatcher.FilterDispatcher.doFilter(FilterDispatcher.java:202)
    *
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    *
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    *
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:264)
    *
org.hisp.dhis.security.filter.RequiredLoginFilter.doFilter(RequiredLoginFilter.java:131)
    *
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
    *
org.hisp.dhis.security.filter.AutomaticAccessFilter.doFilter(AutomaticAccessFilter.java:107)
    *
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
    *
org.acegisecurity.ui.logout.LogoutFilter.doFilter(LogoutFilter.java:108)
    *
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
    *
org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:217)
    *
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
    *
org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:193)
    *
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
    *
org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:148)
    *
org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:98)
    *
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    *
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    *
org.hisp.dhis.servlet.filter.OpenSessionInViewFilter.doFilter(OpenSessionInViewFilter.java:71)
    *
org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:236)
    *
org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167)
    *
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    *
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    *
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
    *
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
    *
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
    *
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
    *
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
    *
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:263)
    *
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
    *
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:584)
    * org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
    * java.lang.Thread.run(Thread.java:619)

[-] Caused by (org.postgresql.util.PSQLException): ERROR: permission
denied for relation minmaxdataelement

    *
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1592)
    *
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1327)

> Ok, I think I would like to recommend ignoring the file I sent and rather
> redefine the table and then run Thanh's first SQL, for a total of three
> statements. They can all be run in one go, just paste the following into
> the
> SQL window in PgAdmin III:
>
> DROP TABLE minmaxdataelement;
>
> CREATE TABLE minmaxdataelement
> (
>   minmaxdataelementid SERIAL NOT NULL,
>   sourceid integer,
>   dataelementid integer,
>   "minvalue" integer,
>   "maxvalue" integer,
>   generated boolean,
>   categoryoptioncomboid integer,
>   CONSTRAINT minmaxdataelement_pkey PRIMARY KEY (minmaxdataelementid),
>   CONSTRAINT fk_minmaxdataelement_categoryoptioncomboid FOREIGN KEY
> (categoryoptioncomboid)
>       REFERENCES categoryoptioncombo (categoryoptioncomboid) MATCH SIMPLE
>       ON UPDATE NO ACTION ON DELETE NO ACTION,
>   CONSTRAINT fk_minmaxdataelement_dataelementid FOREIGN KEY
> (dataelementid)
>       REFERENCES dataelement (dataelementid) MATCH SIMPLE
>       ON UPDATE NO ACTION ON DELETE NO ACTION,
>   CONSTRAINT fk_minmaxdataelement_sourceid FOREIGN KEY (sourceid)
>       REFERENCES source (sourceid) MATCH SIMPLE
>       ON UPDATE NO ACTION ON DELETE NO ACTION
> )
> WITH (OIDS=FALSE);
>
> insert into minmaxdataelement(sourceid, dataelementid, minvalue, maxvalue)
> select organisationunitid, dataelementid, 0, 99 from organisationunit,
> dataelement;
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>



_______________________________________________
Mailing list: https://launchpad.net/~dhis2-devs
Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Follow ups

References

  Thread Previous • Date Previous • • Thread Next