Global ranges

Hi,

In Sierra Leone, none of the orgunits have defined min-max ranges yet, and
the historical data is too poor to be used for calculation of such ranges
yet. Still, there have been some instances of really bad typos, such as
775 instead of 75. Most entries (maybe around 98%) are below 100, so as a
temporary shield we would like to set default ranges as 0-99 (to catch all
three-digit entries). Any clue on how to do this? Would running a query
directly on the database solve it, and what would that query look like?
(sorry, but not good at SQL)

Johan

Basically, you need to add rows to the minmaxdataelement tabls, which means a bunch of INSERT statements. I can try to generate it.

Knut

···

On Tue, May 19, 2009 at 5:06 PM, johansa@ifi.uio.no wrote:

Hi,

In Sierra Leone, none of the orgunits have defined min-max ranges yet, and

the historical data is too poor to be used for calculation of such ranges

yet. Still, there have been some instances of really bad typos, such as

775 instead of 75. Most entries (maybe around 98%) are below 100, so as a

temporary shield we would like to set default ranges as 0-99 (to catch all

three-digit entries). Any clue on how to do this? Would running a query

directly on the database solve it, and what would that query look like?

(sorry, but not good at SQL)

Johan


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp


Cheers,
Knut Staring

Hi again, I’m assuming the orgunit and dataelement IDs are the same as in our SL demo (http://208.76.222.114/dhis_sl). This is a big assumption, but anyway your db will suffer no harm if it’s not the fully the case.

Right click on the following link and save the file, then unzip it somwhere and make a note of the path.

http://208.76.222.114/files/MIN_MAX.7z

Open PgAdmin III, select the SL database and click on the SQL icon in the top row. Then paste in the below command, but substitute your own filepath. Note that the slashes go forward and not backwards as usually on Windows:

COPY minmaxdataelement FROM ‘F:/HISP/SL/MIN_MAX.csv’ USING DELIMITERS ‘,’

Knut

···

On Tue, May 19, 2009 at 5:33 PM, Knut Staring knutst@gmail.com wrote:

Basically, you need to add rows to the minmaxdataelement tabls, which means a bunch of INSERT statements. I can try to generate it.

Knut

On Tue, May 19, 2009 at 5:06 PM, johansa@ifi.uio.no wrote:

Hi,

In Sierra Leone, none of the orgunits have defined min-max ranges yet, and
the historical data is too poor to be used for calculation of such ranges
yet. Still, there have been some instances of really bad typos, such as

775 instead of 75. Most entries (maybe around 98%) are below 100, so as a
temporary shield we would like to set default ranges as 0-99 (to catch all
three-digit entries). Any clue on how to do this? Would running a query

directly on the database solve it, and what would that query look like?
(sorry, but not good at SQL)

Johan


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp


Cheers,
Knut Staring


Cheers,
Knut Staring

Would like to hear what the devs have to say, but maybe something like...

1) Delete the primary key minmaxdataelementid
2) Execute

INSERT INTO minmaxdataelement
SELECT a.organisationunitid, b.dataelementid, 0 as minvalue, 99 as
maxvalue, 'TRUE'::boolean as generated
FROM (SELECT DISTINCT organisationunitid FROM organisationunit) a
CROSS JOIN
(SELECT DISTINCT dataelementid FROM dataelement) b

Knut said that that the DISTINCT elements should probably not be
there, but just in case...

3) Recreate the primary key minmaxdatelementid with a serial datatype
to give you a serial list of integers in this field.
4) Remove the default value of the primary key and set it back to a
plain integer data type.
5) Add the primary key constraint again to the minmaxdataelemntid.

This procedure will not take into account particular elements that
only certain data organisationunits should be submitting. So there
would likely be many min-max elements that would be populated into
this table that would actually not be necessary. An example would be
that districts that do not report on a particular dataelement should
not have a restriction on the min-max value if the actual reporting is
done at a lower level.

Seems like a hack to me, but perhaps it might work. It might be better
to select from the organisationunitstructure table, for a particular
level, instead of the entire organisationunit table. I would make a
backup of the DB obviously before I tried any of this. :slight_smile:

Regards,
JPP

···

On Tue, May 19, 2009 at 5:06 PM, <johansa@ifi.uio.no> wrote:

Hi,

In Sierra Leone, none of the orgunits have defined min-max ranges yet, and
the historical data is too poor to be used for calculation of such ranges
yet. Still, there have been some instances of really bad typos, such as
775 instead of 75. Most entries (maybe around 98%) are below 100, so as a
temporary shield we would like to set default ranges as 0-99 (to catch all
three-digit entries). Any clue on how to do this? Would running a query
directly on the database solve it, and what would that query look like?
(sorry, but not good at SQL)

Johan

_______________________________________________
Mailing list: DHIS 2 developers in Launchpad
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : DHIS 2 developers in Launchpad
More help : ListHelp - Launchpad Help

Would like to hear what the devs have to say, but maybe something like…

  1. Delete the primary key minmaxdataelementid

  2. Execute

INSERT INTO minmaxdataelement

SELECT a.organisationunitid, b.dataelementid, 0 as minvalue, 99 as

maxvalue, ‘TRUE’::boolean as generated

FROM (SELECT DISTINCT organisationunitid FROM organisationunit) a

CROSS JOIN

(SELECT DISTINCT dataelementid FROM dataelement) b

Knut said that that the DISTINCT elements should probably not be

there, but just in case…

  1. Recreate the primary key minmaxdatelementid with a serial datatype

to give you a serial list of integers in this field.

  1. Remove the default value of the primary key and set it back to a

plain integer data type.

  1. Add the primary key constraint again to the minmaxdataelemntid.

This procedure will not take into account particular elements that

only certain data organisationunits should be submitting. So there

would likely be many min-max elements that would be populated into

this table that would actually not be necessary. An example would be

that districts that do not report on a particular dataelement should

not have a restriction on the min-max value if the actual reporting is

done at a lower level.

Seems like a hack to me, but perhaps it might work. It might be better

to select from the organisationunitstructure table, for a particular

level, instead of the entire organisationunit table. I would make a

backup of the DB obviously before I tried any of this. :slight_smile:

Regards,

JPP

Hi Jason,
You may compare to this

Okies, why dont you try this:

  • if you want all dataelements have ranges

insert into minmaxdataelement(sourceid, dataelementid, minvalue, maxvalue) select organisationunitid, dataelementid, 0, 99 from organisationunit, dataelement

  • if you only want those dataelements belonging to datasets assigned to certain orgunit

insert into minmaxdataelement(sourceid, dataelementid, minvalue, maxvalue)
select o.organisationunitid, dm.dataelementid, 0, 99

from organisationunit o inner join datasetsource ds on o.organisationunitid = ds.sourceid
inner join datasetmembers dm on dm.datasetid = ds.datasetid

remember to truncate minmaxdataelement table before inserting.

Thanh

···

On Wed, May 20, 2009 at 3:13 AM, Jason Pickering jason.p.pickering@gmail.com wrote:

On Tue, May 19, 2009 at 5:06 PM, johansa@ifi.uio.no wrote:

Hi,

In Sierra Leone, none of the orgunits have defined min-max ranges yet, and

the historical data is too poor to be used for calculation of such ranges

yet. Still, there have been some instances of really bad typos, such as

775 instead of 75. Most entries (maybe around 98%) are below 100, so as a

temporary shield we would like to set default ranges as 0-99 (to catch all

three-digit entries). Any clue on how to do this? Would running a query

directly on the database solve it, and what would that query look like?

(sorry, but not good at SQL)

Johan


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp


Best regards,
Thanh


Center for HIS development
957, 3/2 st., Dist 11, Hochiminh city
Tel: 08-956 0150
Cell: 098 221 8623


  • if you want all dataelements have ranges

insert into minmaxdataelement(sourceid, dataelementid, minvalue, maxvalue) select organisationunitid, dataelementid, 0, 99 from organisationunit, dataelement

This will not run without modifications: ERROR: null value in column “minmaxdataelementid” violates not-null constraint

You could probably make the id column serial to cope with that. Also, not sure if you should have the default value for categoryoptioncomboid or leave it as NULL.

  • if you only want those dataelements belonging to datasets assigned to certain orgunit

insert into minmaxdataelement(sourceid, dataelementid, minvalue, maxvalue)
select o.organisationunitid, dm.dataelementid, 0, 99

from organisationunit o inner join datasetsource ds on o.organisationunitid = ds.sourceid
inner join datasetmembers dm on dm.datasetid = ds.datasetid

This is better (with same comment as above).

Knut

···

On Wed, May 20, 2009 at 3:57 AM, Ngoc Thanh Nguyen thanh.hispvietnam@gmail.com wrote:

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;

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@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp

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@ifi.uio.no" <johansa@ifi.uio.no>
To: Knut Staring <knutst@gmail.com>
Cc: dhis2-devs@lists.launchpad.net
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@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp

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

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.

Ok, changed the owner, but I get another error now.

[-] Exception (org.hibernate.PropertyAccessException): Null value was
assigned to a property of primitive type setter of
org.hisp.dhis.minmax.MinMaxDataElement.generated

···

*
org.hibernate.property.BasicPropertyAccessor$BasicSetter.set(BasicPropertyAccessor.java:85)
    *
org.hibernate.tuple.entity.AbstractEntityTuplizer.setPropertyValues(AbstractEntityTuplizer.java:337)
    *
org.hibernate.tuple.entity.PojoEntityTuplizer.setPropertyValues(PojoEntityTuplizer.java:200)
    *
org.hibernate.persister.entity.AbstractEntityPersister.setPropertyValues(AbstractEntityPersister.java:3571)
    *
org.hibernate.engine.TwoPhaseLoad.initializeEntity(TwoPhaseLoad.java:133)
    *
org.hibernate.loader.Loader.initializeEntitiesAndCollections(Loader.java:854)
    * org.hibernate.loader.Loader.doQuery(Loader.java:729)
    *
org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
    * org.hibernate.loader.Loader.doList(Loader.java:2213)
    * 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 (java.lang.IllegalArgumentException): null

    *
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.hibernate.property.BasicPropertyAccessor$BasicSetter.set(BasicPropertyAccessor.java:42)
    *
org.hibernate.tuple.entity.AbstractEntityTuplizer.setPropertyValues(AbstractEntityTuplizer.java:337)
    *
org.hibernate.tuple.entity.PojoEntityTuplizer.setPropertyValues(PojoEntityTuplizer.java:200)
    *
org.hibernate.persister.entity.AbstractEntityPersister.setPropertyValues(AbstractEntityPersister.java:3571)
    *
org.hibernate.engine.TwoPhaseLoad.initializeEntity(TwoPhaseLoad.java:133)
    *
org.hibernate.loader.Loader.initializeEntitiesAndCollections(Loader.java:854)
    * org.hibernate.loader.Loader.doQuery(Loader.java:729)
    *
org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
    * org.hibernate.loader.Loader.doList(Loader.java:2213)
    * 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)

----- Original Message ----
From: "johansa@ifi.uio.no" <johansa@ifi.uio.no>
To: Knut Staring <knutst@gmail.com>
Cc: dhis2-devs@lists.launchpad.net
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@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp

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

hi,
That means you are supplying "null" somewhere in your hibernate object creation. Try to find out, otherwise create bug. Because if "null" is allowed primitive data type should be changed to Object, e.g. int should be Integer.

regards,
murod

···

----- Original Message ----
From: "johansa@ifi.uio.no" <johansa@ifi.uio.no>
To: Murodullo Latifov <murodlatifov@yahoo.com>
Cc: Knut Staring <knutst@gmail.com>; dhis2-devs@lists.launchpad.net
Sent: Tuesday, June 9, 2009 3:55:37 PM
Subject: Re: [Dhis2-devs] Global ranges

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.

Ok, changed the owner, but I get another error now.

[-] Exception (org.hibernate.PropertyAccessException): Null value was
assigned to a property of primitive type setter of
org.hisp.dhis.minmax.MinMaxDataElement.generated

    *
org.hibernate.property.BasicPropertyAccessor$BasicSetter.set(BasicPropertyAccessor.java:85)
    *
org.hibernate.tuple.entity.AbstractEntityTuplizer.setPropertyValues(AbstractEntityTuplizer.java:337)
    *
org.hibernate.tuple.entity.PojoEntityTuplizer.setPropertyValues(PojoEntityTuplizer.java:200)
    *
org.hibernate.persister.entity.AbstractEntityPersister.setPropertyValues(AbstractEntityPersister.java:3571)
    *
org.hibernate.engine.TwoPhaseLoad.initializeEntity(TwoPhaseLoad.java:133)
    *
org.hibernate.loader.Loader.initializeEntitiesAndCollections(Loader.java:854)
    * org.hibernate.loader.Loader.doQuery(Loader.java:729)
    *
org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
    * org.hibernate.loader.Loader.doList(Loader.java:2213)
    * 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 (java.lang.IllegalArgumentException): null

    *
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.hibernate.property.BasicPropertyAccessor$BasicSetter.set(BasicPropertyAccessor.java:42)
    *
org.hibernate.tuple.entity.AbstractEntityTuplizer.setPropertyValues(AbstractEntityTuplizer.java:337)
    *
org.hibernate.tuple.entity.PojoEntityTuplizer.setPropertyValues(PojoEntityTuplizer.java:200)
    *
org.hibernate.persister.entity.AbstractEntityPersister.setPropertyValues(AbstractEntityPersister.java:3571)
    *
org.hibernate.engine.TwoPhaseLoad.initializeEntity(TwoPhaseLoad.java:133)
    *
org.hibernate.loader.Loader.initializeEntitiesAndCollections(Loader.java:854)
    * org.hibernate.loader.Loader.doQuery(Loader.java:729)
    *
org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
    * org.hibernate.loader.Loader.doList(Loader.java:2213)
    * 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)

----- Original Message ----
From: "johansa@ifi.uio.no" <johansa@ifi.uio.no>
To: Knut Staring <knutst@gmail.com>
Cc: dhis2-devs@lists.launchpad.net
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@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp

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

Hi Johan,
Is it possible that the table has been changed somehow? If you can
access the database directly through pgAdminIII, could you post the
table definition to the list? It seems like something has changed,
otherwise, it is a possible bug.

···

On 6/9/09, Murodullo Latifov <murodlatifov@yahoo.com> wrote:

hi,
That means you are supplying "null" somewhere in your hibernate object
creation. Try to find out, otherwise create bug. Because if "null" is
allowed primitive data type should be changed to Object, e.g. int should be
Integer.

regards,
murod

----- Original Message ----
From: "johansa@ifi.uio.no" <johansa@ifi.uio.no>
To: Murodullo Latifov <murodlatifov@yahoo.com>
Cc: Knut Staring <knutst@gmail.com>; dhis2-devs@lists.launchpad.net
Sent: Tuesday, June 9, 2009 3:55:37 PM
Subject: Re: [Dhis2-devs] Global ranges

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.

Ok, changed the owner, but I get another error now.

[-] Exception (org.hibernate.PropertyAccessException): Null value was
assigned to a property of primitive type setter of
org.hisp.dhis.minmax.MinMaxDataElement.generated

    *
org.hibernate.property.BasicPropertyAccessor$BasicSetter.set(BasicPropertyAccessor.java:85)
    *
org.hibernate.tuple.entity.AbstractEntityTuplizer.setPropertyValues(AbstractEntityTuplizer.java:337)
    *
org.hibernate.tuple.entity.PojoEntityTuplizer.setPropertyValues(PojoEntityTuplizer.java:200)
    *
org.hibernate.persister.entity.AbstractEntityPersister.setPropertyValues(AbstractEntityPersister.java:3571)
    *
org.hibernate.engine.TwoPhaseLoad.initializeEntity(TwoPhaseLoad.java:133)
    *
org.hibernate.loader.Loader.initializeEntitiesAndCollections(Loader.java:854)
    * org.hibernate.loader.Loader.doQuery(Loader.java:729)
    *
org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
    * org.hibernate.loader.Loader.doList(Loader.java:2213)
    * 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 (java.lang.IllegalArgumentException): null

    *
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.hibernate.property.BasicPropertyAccessor$BasicSetter.set(BasicPropertyAccessor.java:42)
    *
org.hibernate.tuple.entity.AbstractEntityTuplizer.setPropertyValues(AbstractEntityTuplizer.java:337)
    *
org.hibernate.tuple.entity.PojoEntityTuplizer.setPropertyValues(PojoEntityTuplizer.java:200)
    *
org.hibernate.persister.entity.AbstractEntityPersister.setPropertyValues(AbstractEntityPersister.java:3571)
    *
org.hibernate.engine.TwoPhaseLoad.initializeEntity(TwoPhaseLoad.java:133)
    *
org.hibernate.loader.Loader.initializeEntitiesAndCollections(Loader.java:854)
    * org.hibernate.loader.Loader.doQuery(Loader.java:729)
    *
org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
    * org.hibernate.loader.Loader.doList(Loader.java:2213)
    * 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)

----- Original Message ----
From: "johansa@ifi.uio.no" <johansa@ifi.uio.no>
To: Knut Staring <knutst@gmail.com>
Cc: dhis2-devs@lists.launchpad.net
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: DHIS 2 developers in Launchpad
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : DHIS 2 developers in Launchpad
More help : ListHelp - Launchpad Help

_______________________________________________
Mailing list: DHIS 2 developers in Launchpad
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : DHIS 2 developers in Launchpad
More help : ListHelp - Launchpad Help

_______________________________________________
Mailing list: DHIS 2 developers in Launchpad
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : DHIS 2 developers in Launchpad
More help : ListHelp - Launchpad Help