dhis2-devs team mailing list archive

[Morten Olav Hansen <mortenoh@xxxxxxxxx>]

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