dhis2-devs team mailing list archive

Thread
Date
Re: [Bug 1272167] [NEW] Web API query fails for categories, category option combos and category options

To: dhis2-devs@xxxxxxxxxxxxxxxxxxx
From: Morten Olav Hansen <1272167@xxxxxxxxxxxxxxxxxx>
Date: Fri, 24 Jan 2014 13:27:49 -0000
Reply-to: Bug 1272167 <1272167@xxxxxxxxxxxxxxxxxx>
Sender: bounces@xxxxxxxxxxxxx
Can you show example from our dev server? It seemed to work fine when i
tested
On Jan 24, 2014 8:15 PM, "Juan Manuel Alcantara" <jmalcantara@xxxxxxxxxxxxx>
wrote:

> Hi Lars
> This problem is present in the following versions:
>
>  2.13 build: 12951 date: 2014-01-24 05:53
>  2.14 build: 13717 date: 2014-01-17 14:20
>  2.15 build: 13768 date: 2014-01-18 00:20
>
> Best regards,
> JM
>
>
> El 24/01/2014, a las 01:50, Lars Helge Øverland <larshelge@xxxxxxxxx>
> escribió:
>
> > Hi, what dhis version/build?
> > On Jan 24, 2014 7:30 AM, "Juan Manuel Alcantara" <
> jmalcantara@xxxxxxxxxxxxx>
> > wrote:
> >
> >> Public bug reported:
> >>
> >> The query returns the following information:
> >>
> >> *********
> >> HTTP Status 500 - Request processing failed; nested exception is
> >> org.hibernate.QueryException: could not resolve property: shortName of:
> >> org.hisp.dhis.dataelement.DataElementCategory [from
> >> org.hisp.dhis.dataelement.DataElementCategory c where lower(shortName)
> like
> >> :shortName order by c.shortName]
> >>
> >> type Exception report
> >>
> >> message Request processing failed; nested exception is
> >> org.hibernate.QueryException: could not resolve property: shortName of:
> >> org.hisp.dhis.dataelement.DataElementCategory [from
> >> org.hisp.dhis.dataelement.DataElementCategory c where lower(shortName)
> >> like :shortName order by c.shortName]
> >>
> >> description The server encountered an internal error that prevented it
> >> from fulfilling this request.
> >>
> >> +++++++++++++++
> >>
> >> HTTP Status 500 - Request processing failed; nested exception is
> >> org.hibernate.QueryException: could not resolve property: name of:
> >> org.hisp.dhis.dataelement.DataElementCategoryOptionCombo [from
> >> org.hisp.dhis.dataelement.DataElementCategoryOptionCombo c where
> >> lower(name) like :name order by c.name]
> >>
> >> type Exception report
> >>
> >> message Request processing failed; nested exception is
> >> org.hibernate.QueryException: could not resolve property: name of:
> >> org.hisp.dhis.dataelement.DataElementCategoryOptionCombo [from
> >> org.hisp.dhis.dataelement.DataElementCategoryOptionCombo c where
> >> lower(name) like :name order by c.name]
> >>
> >> description The server encountered an internal error that prevented it
> >> from fulfilling this request.
> >>
> >> ++++++++++++++++
> >>
> >> HTTP Status 500 - Request processing failed; nested exception is
> >> org.hibernate.QueryException: could not resolve property: shortName of:
> >> org.hisp.dhis.dataelement.DataElementCategoryOption [from
> >> org.hisp.dhis.dataelement.DataElementCategoryOption c where
> >> lower(shortName) like :shortName order by c.shortName]
> >>
> >> type Exception report
> >>
> >> message Request processing failed; nested exception is
> >> org.hibernate.QueryException: could not resolve property: shortName of:
> >> org.hisp.dhis.dataelement.DataElementCategoryOption [from
> >> org.hisp.dhis.dataelement.DataElementCategoryOption c where
> >> lower(shortName) like :shortName order by c.shortName]
> >>
> >> description The server encountered an internal error that prevented it
> >> from fulfilling this request.
> >>
> >> ** Affects: dhis2
> >>     Importance: Undecided
> >>         Status: New
> >>
> >>
> >> ** Tags: api query
> >>
> >> --
> >> You received this bug notification because you are a member of DHIS 2
> >> developers, which is subscribed to DHIS.
> >> https://bugs.launchpad.net/bugs/1272167
> >>
> >> Title:
> >>  Web API query fails for categories, category option combos and
> >>  category options
> >>
> >> Status in DHIS 2:
> >>  New
> >>
> >> Bug description:
> >>  The query returns the following information:
> >>
> >>  *********
> >>  HTTP Status 500 - Request processing failed; nested exception is
> >> org.hibernate.QueryException: could not resolve property: shortName of:
> >> org.hisp.dhis.dataelement.DataElementCategory [from
> >> org.hisp.dhis.dataelement.DataElementCategory c where lower(shortName)
> like
> >> :shortName order by c.shortName]
> >>
> >>  type Exception report
> >>
> >>  message Request processing failed; nested exception is
> >>  org.hibernate.QueryException: could not resolve property: shortName
> >>  of: org.hisp.dhis.dataelement.DataElementCategory [from
> >>  org.hisp.dhis.dataelement.DataElementCategory c where lower(shortName)
> >>  like :shortName order by c.shortName]
> >>
> >>  description The server encountered an internal error that prevented it
> >>  from fulfilling this request.
> >>
> >>  +++++++++++++++
> >>
> >>  HTTP Status 500 - Request processing failed; nested exception is
> >>  org.hibernate.QueryException: could not resolve property: name of:
> >>  org.hisp.dhis.dataelement.DataElementCategoryOptionCombo [from
> >>  org.hisp.dhis.dataelement.DataElementCategoryOptionCombo c where
> >>  lower(name) like :name order by c.name]
> >>
> >>  type Exception report
> >>
> >>  message Request processing failed; nested exception is
> >>  org.hibernate.QueryException: could not resolve property: name of:
> >>  org.hisp.dhis.dataelement.DataElementCategoryOptionCombo [from
> >>  org.hisp.dhis.dataelement.DataElementCategoryOptionCombo c where
> >>  lower(name) like :name order by c.name]
> >>
> >>  description The server encountered an internal error that prevented it
> >>  from fulfilling this request.
> >>
> >>  ++++++++++++++++
> >>
> >>  HTTP Status 500 - Request processing failed; nested exception is
> >>  org.hibernate.QueryException: could not resolve property: shortName
> >>  of: org.hisp.dhis.dataelement.DataElementCategoryOption [from
> >>  org.hisp.dhis.dataelement.DataElementCategoryOption c where
> >>  lower(shortName) like :shortName order by c.shortName]
> >>
> >>  type Exception report
> >>
> >>  message Request processing failed; nested exception is
> >>  org.hibernate.QueryException: could not resolve property: shortName
> >>  of: org.hisp.dhis.dataelement.DataElementCategoryOption [from
> >>  org.hisp.dhis.dataelement.DataElementCategoryOption c where
> >>  lower(shortName) like :shortName order by c.shortName]
> >>
> >>  description The server encountered an internal error that prevented it
> >>  from fulfilling this request.
> >>
> >> To manage notifications about this bug go to:
> >> https://bugs.launchpad.net/dhis2/+bug/1272167/+subscriptions
> >>
> >> _______________________________________________
> >> Mailing list: https://launchpad.net/~dhis2-devs
> >> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
> >> Unsubscribe : https://launchpad.net/~dhis2-devs
> >> More help   : https://help.launchpad.net/ListHelp
> >>
> >
> > --
> > You received this bug notification because you are subscribed to the bug
> > report.
> > https://bugs.launchpad.net/bugs/1272167
> >
> > Title:
> >  Web API query fails for categories, category option combos and
> >  category options
> >
> > Status in DHIS 2:
> >  New
> >
> > Bug description:
> >  The query returns the following information:
> >
> >  *********
> >  HTTP Status 500 - Request processing failed; nested exception is
> org.hibernate.QueryException: could not resolve property: shortName of:
> org.hisp.dhis.dataelement.DataElementCategory [from
> org.hisp.dhis.dataelement.DataElementCategory c where lower(shortName) like
> :shortName order by c.shortName]
> >
> >  type Exception report
> >
> >  message Request processing failed; nested exception is
> >  org.hibernate.QueryException: could not resolve property: shortName
> >  of: org.hisp.dhis.dataelement.DataElementCategory [from
> >  org.hisp.dhis.dataelement.DataElementCategory c where lower(shortName)
> >  like :shortName order by c.shortName]
> >
> >  description The server encountered an internal error that prevented it
> >  from fulfilling this request.
> >
> >  +++++++++++++++
> >
> >  HTTP Status 500 - Request processing failed; nested exception is
> >  org.hibernate.QueryException: could not resolve property: name of:
> >  org.hisp.dhis.dataelement.DataElementCategoryOptionCombo [from
> >  org.hisp.dhis.dataelement.DataElementCategoryOptionCombo c where
> >  lower(name) like :name order by c.name]
> >
> >  type Exception report
> >
> >  message Request processing failed; nested exception is
> >  org.hibernate.QueryException: could not resolve property: name of:
> >  org.hisp.dhis.dataelement.DataElementCategoryOptionCombo [from
> >  org.hisp.dhis.dataelement.DataElementCategoryOptionCombo c where
> >  lower(name) like :name order by c.name]
> >
> >  description The server encountered an internal error that prevented it
> >  from fulfilling this request.
> >
> >  ++++++++++++++++
> >
> >  HTTP Status 500 - Request processing failed; nested exception is
> >  org.hibernate.QueryException: could not resolve property: shortName
> >  of: org.hisp.dhis.dataelement.DataElementCategoryOption [from
> >  org.hisp.dhis.dataelement.DataElementCategoryOption c where
> >  lower(shortName) like :shortName order by c.shortName]
> >
> >  type Exception report
> >
> >  message Request processing failed; nested exception is
> >  org.hibernate.QueryException: could not resolve property: shortName
> >  of: org.hisp.dhis.dataelement.DataElementCategoryOption [from
> >  org.hisp.dhis.dataelement.DataElementCategoryOption c where
> >  lower(shortName) like :shortName order by c.shortName]
> >
> >  description The server encountered an internal error that prevented it
> >  from fulfilling this request.
> >
> > To manage notifications about this bug go to:
> > https://bugs.launchpad.net/dhis2/+bug/1272167/+subscriptions
>
> --
> You received this bug notification because you are subscribed to DHIS.
> https://bugs.launchpad.net/bugs/1272167
>
> Title:
>   Web API query fails for categories, category option combos and
>   category options
>
> Status in DHIS 2:
>   New
>
> Bug description:
>   The query returns the following information:
>
>   *********
>   HTTP Status 500 - Request processing failed; nested exception is
> org.hibernate.QueryException: could not resolve property: shortName of:
> org.hisp.dhis.dataelement.DataElementCategory [from
> org.hisp.dhis.dataelement.DataElementCategory c where lower(shortName) like
> :shortName order by c.shortName]
>
>   type Exception report
>
>   message Request processing failed; nested exception is
>   org.hibernate.QueryException: could not resolve property: shortName
>   of: org.hisp.dhis.dataelement.DataElementCategory [from
>   org.hisp.dhis.dataelement.DataElementCategory c where lower(shortName)
>   like :shortName order by c.shortName]
>
>   description The server encountered an internal error that prevented it
>   from fulfilling this request.
>
>   +++++++++++++++
>
>   HTTP Status 500 - Request processing failed; nested exception is
>   org.hibernate.QueryException: could not resolve property: name of:
>   org.hisp.dhis.dataelement.DataElementCategoryOptionCombo [from
>   org.hisp.dhis.dataelement.DataElementCategoryOptionCombo c where
>   lower(name) like :name order by c.name]
>
>   type Exception report
>
>   message Request processing failed; nested exception is
>   org.hibernate.QueryException: could not resolve property: name of:
>   org.hisp.dhis.dataelement.DataElementCategoryOptionCombo [from
>   org.hisp.dhis.dataelement.DataElementCategoryOptionCombo c where
>   lower(name) like :name order by c.name]
>
>   description The server encountered an internal error that prevented it
>   from fulfilling this request.
>
>   ++++++++++++++++
>
>   HTTP Status 500 - Request processing failed; nested exception is
>   org.hibernate.QueryException: could not resolve property: shortName
>   of: org.hisp.dhis.dataelement.DataElementCategoryOption [from
>   org.hisp.dhis.dataelement.DataElementCategoryOption c where
>   lower(shortName) like :shortName order by c.shortName]
>
>   type Exception report
>
>   message Request processing failed; nested exception is
>   org.hibernate.QueryException: could not resolve property: shortName
>   of: org.hisp.dhis.dataelement.DataElementCategoryOption [from
>   org.hisp.dhis.dataelement.DataElementCategoryOption c where
>   lower(shortName) like :shortName order by c.shortName]
>
>   description The server encountered an internal error that prevented it
>   from fulfilling this request.
>
> To manage notifications about this bug go to:
> https://bugs.launchpad.net/dhis2/+bug/1272167/+subscriptions
>

-- 
You received this bug notification because you are a member of DHIS 2
developers, which is subscribed to DHIS.
https://bugs.launchpad.net/bugs/1272167

Title:
  Web API query fails for categories, category option combos and
  category options

Status in DHIS 2:
  New

Bug description:
  The query returns the following information:

  *********
  HTTP Status 500 - Request processing failed; nested exception is org.hibernate.QueryException: could not resolve property: shortName of: org.hisp.dhis.dataelement.DataElementCategory [from org.hisp.dhis.dataelement.DataElementCategory c where lower(shortName) like :shortName order by c.shortName]

  type Exception report

  message Request processing failed; nested exception is
  org.hibernate.QueryException: could not resolve property: shortName
  of: org.hisp.dhis.dataelement.DataElementCategory [from
  org.hisp.dhis.dataelement.DataElementCategory c where lower(shortName)
  like :shortName order by c.shortName]

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

  +++++++++++++++

  HTTP Status 500 - Request processing failed; nested exception is
  org.hibernate.QueryException: could not resolve property: name of:
  org.hisp.dhis.dataelement.DataElementCategoryOptionCombo [from
  org.hisp.dhis.dataelement.DataElementCategoryOptionCombo c where
  lower(name) like :name order by c.name]

  type Exception report

  message Request processing failed; nested exception is
  org.hibernate.QueryException: could not resolve property: name of:
  org.hisp.dhis.dataelement.DataElementCategoryOptionCombo [from
  org.hisp.dhis.dataelement.DataElementCategoryOptionCombo c where
  lower(name) like :name order by c.name]

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

  ++++++++++++++++

  HTTP Status 500 - Request processing failed; nested exception is
  org.hibernate.QueryException: could not resolve property: shortName
  of: org.hisp.dhis.dataelement.DataElementCategoryOption [from
  org.hisp.dhis.dataelement.DataElementCategoryOption c where
  lower(shortName) like :shortName order by c.shortName]

  type Exception report

  message Request processing failed; nested exception is
  org.hibernate.QueryException: could not resolve property: shortName
  of: org.hisp.dhis.dataelement.DataElementCategoryOption [from
  org.hisp.dhis.dataelement.DataElementCategoryOption c where
  lower(shortName) like :shortName order by c.shortName]

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

To manage notifications about this bug go to:
https://bugs.launchpad.net/dhis2/+bug/1272167/+subscriptions
Follow ups

Re: [Bug 1272167] [NEW] Web API query fails for categories, category option combos and category options
From: Lars Helge Øverland, 2014-01-24
References

[Bug 1272167] [NEW] Web API query fails for categories, category option combos and category options
From: Juan Manuel Alcantara, 2014-01-24
Re: [Bug 1272167] [NEW] Web API query fails for categories, category option combos and category options
From: Lars Helge Øverland, 2014-01-24
Re: [Bug 1272167] [NEW] Web API query fails for categories, category option combos and category options
From: Juan Manuel Alcantara, 2014-01-24