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.hispviet...@gmail.com>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 > <morte...@gmail.com>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... _______________________________________________ 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
