dhis2-devs team mailing list archive

[Lars Helge Øverland <larshelge@xxxxxxxxx>]

Yes no doubt. We are just making a bug so we remember to address this in the
next release.

On Fri, Apr 15, 2011 at 4:31 AM, Hieu Duy Dang
<hieu.hispvietnam@xxxxxxxxx>wrote:

> Hi, actually, this is not a real bug but it's a big due with the resource
> tables. There are many places where those ones are being used in dhis2.
> This
> problem has being discussed in many other threads. Finally at conclusion,
> we
> should find out a centralized way to resolve this issue.
>
> On Thu, Apr 14, 2011 at 4:38 PM, Morten Olav Hansen
> <mortenoh@xxxxxxxxx>wrote:
>
> > Public bug reported:
> >
> > When the resource tables are not generated, the system gives an
> > exception when trying to edit compulsory data elements (in dataset).
> >
> > [+] Caused by (org.h2.jdbc.JdbcSQLException): Table
> > "_CATEGORYOPTIONCOMBONAME" not found; SQL statement: SELECT
> > de.dataelementid, de.name, cocn.categoryoptioncomboid,
> > cocn.categoryoptioncomboname FROM dataelement as de JOIN categorycombo
> > as cc on de.categorycomboid=cc.categorycomboid JOIN
> > categorycombos_optioncombos as ccoc on
> > cc.categorycomboid=ccoc.categorycomboid LEFT JOIN
> > _categoryoptioncomboname as cocn on
> > ccoc.categoryoptioncomboid=cocn.categoryoptioncomboid WHERE
> > de.dataelementid IN (2, 1, 4, 3); [42102-153]
> >
> > This is probably a general problem, and should be solved...
> >
> > ** Affects: dhis2
> >     Importance: Undecided
> >         Status: New
> >
> > --
> > You received this bug notification because you are a member of DHIS 2
> > India Developers, which is subscribed to DHIS.
> > https://bugs.launchpad.net/bugs/760499
> >
> > Title:
> >  DataSet - edit compulsory data elements gives exception (resourcetable
> >  not generated)
> >
> > Status in DHIS 2 - District Health Information Software:
> >  New
> >
> > Bug description:
> >  When the resource tables are not generated, the system gives an
> >  exception when trying to edit compulsory data elements (in dataset).
> >
> >  [+] Caused by (org.h2.jdbc.JdbcSQLException): Table
> >  "_CATEGORYOPTIONCOMBONAME" not found; SQL statement: SELECT
> >  de.dataelementid, de.name, cocn.categoryoptioncomboid,
> >  cocn.categoryoptioncomboname FROM dataelement as de JOIN categorycombo
> >  as cc on de.categorycomboid=cc.categorycomboid JOIN
> >  categorycombos_optioncombos as ccoc on
> >  cc.categorycomboid=ccoc.categorycomboid LEFT JOIN
> >  _categoryoptioncomboname as cocn on
> >  ccoc.categoryoptioncomboid=cocn.categoryoptioncomboid WHERE
> >  de.dataelementid IN (2, 1, 4, 3); [42102-153]
> >
> >  This is probably a general problem, and should be solved...
> >
>
>
> --
> Good health !
>
> --
> You received this bug notification because you are a member of DHIS 2
> India Developers, which is subscribed to DHIS.
> https://bugs.launchpad.net/bugs/760499
>
> Title:
>  DataSet - edit compulsory data elements gives exception (resourcetable
>  not generated)
>
> Status in DHIS 2 - District Health Information Software:
>  New
>
> Bug description:
>  When the resource tables are not generated, the system gives an
>  exception when trying to edit compulsory data elements (in dataset).
>
>  [+] Caused by (org.h2.jdbc.JdbcSQLException): Table
>  "_CATEGORYOPTIONCOMBONAME" not found; SQL statement: SELECT
>  de.dataelementid, de.name, cocn.categoryoptioncomboid,
>  cocn.categoryoptioncomboname FROM dataelement as de JOIN categorycombo
>  as cc on de.categorycomboid=cc.categorycomboid JOIN
>  categorycombos_optioncombos as ccoc on
>  cc.categorycomboid=ccoc.categorycomboid LEFT JOIN
>  _categoryoptioncomboname as cocn on
>  ccoc.categoryoptioncomboid=cocn.categoryoptioncomboid WHERE
>  de.dataelementid IN (2, 1, 4, 3); [42102-153]
>
>  This is probably a general problem, and should be solved...
>

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

Title:
  DataSet - edit compulsory data elements gives exception (resourcetable
  not generated)

Status in DHIS 2 - District Health Information Software:
  New

Bug description:
  When the resource tables are not generated, the system gives an
  exception when trying to edit compulsory data elements (in dataset).

  [+] Caused by (org.h2.jdbc.JdbcSQLException): Table
  "_CATEGORYOPTIONCOMBONAME" not found; SQL statement: SELECT
  de.dataelementid, de.name, cocn.categoryoptioncomboid,
  cocn.categoryoptioncomboname FROM dataelement as de JOIN categorycombo
  as cc on de.categorycomboid=cc.categorycomboid JOIN
  categorycombos_optioncombos as ccoc on
  cc.categorycomboid=ccoc.categorycomboid LEFT JOIN
  _categoryoptioncomboname as cocn on
  ccoc.categoryoptioncomboid=cocn.categoryoptioncomboid WHERE
  de.dataelementid IN (2, 1, 4, 3); [42102-153]

  This is probably a general problem, and should be solved...