← Back to team overview

dhis2-devs team mailing list archive

Re: [Bug 760499] [NEW] DataSet - edit compulsory data elements gives exception (resourcetable not generated)

 

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
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...



Follow ups

References