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: "[email protected]" <[email protected]> To: Knut Staring <[email protected]> Cc: [email protected] 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 : [email protected] > Unsubscribe : https://launchpad.net/~dhis2-devs > More help : https://help.launchpad.net/ListHelp > _______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : [email protected] Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp _______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : [email protected] Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
