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: Lars Helge Øverland <larshelge@xxxxxxxxx>
Date: Fri, 24 Jan 2014 06:50:45 -0000
Reply-to: Bug 1272167 <1272167@xxxxxxxxxxxxxxxxxx>
Sender: bounces@xxxxxxxxxxxxx
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 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: Juan Manuel Alcantara, 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