dhis2-devs team mailing list archive
-
dhis2-devs team
-
Mailing list archive
-
Message #11669
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