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: Juan Manuel Alcantara <jmalcantara@xxxxxxxxxxxxx>
Date: Fri, 24 Jan 2014 13:08:40 -0000
Reply-to: Bug 1272167 <1272167@xxxxxxxxxxxxxxxxxx>
Sender: bounces@xxxxxxxxxxxxx
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 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: Morten Olav Hansen, 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