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... _______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp