Custom form designer creates error in data entry

Support - Assistance technique
1

DHIS 2.7 with Chrome

I tried to create a custom data entry form and it looks like the form designer was missing things (I couldn’t find data elements to add for example).

I saved the custom version anyway and then went to data entry which now had an exception. So I went back to the custom form screen, deleted it, but there is still an exception for data entry.

Here’s the exception code:

[+] Exception (org.hibernate.ObjectNotFoundException): No row with the given identifier exists: [org.hisp.dhis.dataelement.DataElementCategoryOptionCombo#61]

Any idea how I can fix this and hopefully be able to add custom forms?

Thanks,

Tom

···

This message was scanned for viruses with Trend Micro ScanMail, GFI MailSecurity and GFI MailEssentials by the World Health Organization Regional Office for the Western Pacific. However, the recipient is advised to scan this e-mail and any attached files for viruses.

Disclaimer:

This e-mail, together with any attachments, is intended for the named recipients only and is confidential. It may also be privileged or otherwise protected by law.

If you have received it in error, please notify the sender immediately by reply e-mail and delete it and any attachments from your system. You may not copy or disclose its contents to anyone.

2

I encountered a similar issue yesterday but did not think much about
it at the time, however I see it may now really be a bug.

I added a data element..

No. of HIV+ pregnant women newly intiated on ART for their own health
(New) with default category options

When I opened up the custom data entry form, I managed to dig this out
of the JavaScript console

c.defaultView.c.defaultView.getComputedStyle.bAjquery.min.js:4
f.extend.cssjquery.min.js:4
f.fn.extend.showjquery.min.js:4
f.fn.extend.showjquery-ui-1.8.12.custom.min.js:585
e.widget._create._renderAxisjquery-ui-1.8.12.custom.min.js:161
e.widget._createjquery-ui-1.8.12.custom.min.js:161
b.Widget._createWidgetjquery-ui-1.8.12.custom.min.js:30
b.widget.b.(anonymous function).(anonymous
function)jquery-ui-1.8.12.custom.min.js:28
b.widget.bridge.b.fn.(anonymous function)jquery-ui-1.8.12.custom.min.js:29
e.extend.eachjquery.min.js:2
e.fn.e.eachjquery.min.js:2
b.widget.bridge.b.fn.(anonymous function)jquery-ui-1.8.12.custom.min.js:29
c.widget._makeResizablejquery-ui-1.8.12.custom.min.js:387
c.widget._createjquery-ui-1.8.12.custom.min.js:380
b.Widget._createWidgetjquery-ui-1.8.12.custom.min.js:30
b.widget.b.(anonymous function).(anonymous
function)jquery-ui-1.8.12.custom.min.js:28
b.widget.bridge.b.fn.(anonymous function)jquery-ui-1.8.12.custom.min.js:29
e.extend.eachjquery.min.js:2
e.fn.e.eachjquery.min.js:2
b.widget.bridge.b.fn.(anonymous function)jquery-ui-1.8.12.custom.min.js:29
(anonymous function)viewDataEntryForm.js:11
f.Callbacks.njquery.min.js:2
f.Callbacks.o.fireWithjquery.min.js:2
e.extend.readyjquery.min.js:2
c.addEventListener.B

Not very helpful. When I changed (New) to (Foo) it got the same
error, thinking that it might have something to do with the use of
(New). When I removed (New) it worked just fine. Maybe it is related
to the name of the DE?

I do not know what you data element is, but normally that error
happens when a data element exists in the custom form, which does not
exist in the database. You may need to clear your cache completely in
order for the new form to appear. Otherwise, the full stack trace
would be helpful for the devs.

Best regards,
Jason

···

On Thu, Apr 26, 2012 at 2:40 AM, Hiatt, Mr Tom (WPRO) <hiattt@wpro.who.int> wrote:

DHIS 2.7 with Chrome

I tried to create a custom data entry form and it looks like the form
designer was missing things (I couldn’t find data elements to add for
example).

I saved the custom version anyway and then went to data entry which now had
an exception. So I went back to the custom form screen, deleted it, but
there is still an exception for data entry.

Here’s the exception code:

[+] Exception (org.hibernate.ObjectNotFoundException): No row with the given
identifier exists:
[org.hisp.dhis.dataelement.DataElementCategoryOptionCombo#61]

Any idea how I can fix this and hopefully be able to add custom forms?

Thanks,

Tom

________________________________

This message was scanned for viruses with Trend Micro ScanMail, GFI
MailSecurity and GFI MailEssentials by the World Health Organization
Regional Office for the Western Pacific. However, the recipient is advised
to scan this e-mail and any attached files for viruses.

Disclaimer:

This e-mail, together with any attachments, is intended for the named
recipients only and is confidential. It may also be privileged or otherwise
protected by law.

If you have received it in error, please notify the sender immediately by
reply e-mail and delete it and any attachments from your system. You may not
copy or disclose its contents to anyone.

_______________________________________________
Mailing list: DHIS 2 Users in Launchpad
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : DHIS 2 Users in Launchpad
More help : ListHelp - Launchpad Help

3

Thanks for your help.

I don't think this had to do with changing data element names since I was never able to add a data element into the form (my other issue). Also, I don't think I changed any names or categories.

Clearing the cache didn't seem to clear things up either, unfortunately.

Do I need to really dig into the tables then?

Thanks again,
Tom

···

-----Original Message-----
From: Jason Pickering [mailto:jason.p.pickering@gmail.com]
Sent: 26 April 2012 15:35
To: Hiatt, Mr Tom (WPRO)
Cc: dhis2-users@lists.launchpad.net
Subject: Re: [Dhis2-users] Custom form designer creates error in data entry

I encountered a similar issue yesterday but did not think much about
it at the time, however I see it may now really be a bug.

I added a data element..

No. of HIV+ pregnant women newly intiated on ART for their own health
(New) with default category options

When I opened up the custom data entry form, I managed to dig this out
of the JavaScript console

c.defaultView.c.defaultView.getComputedStyle.bAjquery.min.js:4
f.extend.cssjquery.min.js:4
f.fn.extend.showjquery.min.js:4
f.fn.extend.showjquery-ui-1.8.12.custom.min.js:585
e.widget._create._renderAxisjquery-ui-1.8.12.custom.min.js:161
e.widget._createjquery-ui-1.8.12.custom.min.js:161
b.Widget._createWidgetjquery-ui-1.8.12.custom.min.js:30
b.widget.b.(anonymous function).(anonymous
function)jquery-ui-1.8.12.custom.min.js:28
b.widget.bridge.b.fn.(anonymous function)jquery-ui-1.8.12.custom.min.js:29
e.extend.eachjquery.min.js:2
e.fn.e.eachjquery.min.js:2
b.widget.bridge.b.fn.(anonymous function)jquery-ui-1.8.12.custom.min.js:29
c.widget._makeResizablejquery-ui-1.8.12.custom.min.js:387
c.widget._createjquery-ui-1.8.12.custom.min.js:380
b.Widget._createWidgetjquery-ui-1.8.12.custom.min.js:30
b.widget.b.(anonymous function).(anonymous
function)jquery-ui-1.8.12.custom.min.js:28
b.widget.bridge.b.fn.(anonymous function)jquery-ui-1.8.12.custom.min.js:29
e.extend.eachjquery.min.js:2
e.fn.e.eachjquery.min.js:2
b.widget.bridge.b.fn.(anonymous function)jquery-ui-1.8.12.custom.min.js:29
(anonymous function)viewDataEntryForm.js:11
f.Callbacks.njquery.min.js:2
f.Callbacks.o.fireWithjquery.min.js:2
e.extend.readyjquery.min.js:2
c.addEventListener.B

Not very helpful. When I changed (New) to (Foo) it got the same
error, thinking that it might have something to do with the use of
(New). When I removed (New) it worked just fine. Maybe it is related
to the name of the DE?

I do not know what you data element is, but normally that error
happens when a data element exists in the custom form, which does not
exist in the database. You may need to clear your cache completely in
order for the new form to appear. Otherwise, the full stack trace
would be helpful for the devs.

Best regards,
Jason

On Thu, Apr 26, 2012 at 2:40 AM, Hiatt, Mr Tom (WPRO) <hiattt@wpro.who.int> wrote:

DHIS 2.7 with Chrome

I tried to create a custom data entry form and it looks like the form
designer was missing things (I couldn't find data elements to add for
example).

I saved the custom version anyway and then went to data entry which now had
an exception. So I went back to the custom form screen, deleted it, but
there is still an exception for data entry.

Here's the exception code:

[+] Exception (org.hibernate.ObjectNotFoundException): No row with the given
identifier exists:
[org.hisp.dhis.dataelement.DataElementCategoryOptionCombo#61]

Any idea how I can fix this and hopefully be able to add custom forms?

Thanks,

Tom

________________________________

This message was scanned for viruses with Trend Micro ScanMail, GFI
MailSecurity and GFI MailEssentials by the World Health Organization
Regional Office for the Western Pacific. However, the recipient is advised
to scan this e-mail and any attached files for viruses.

Disclaimer:

This e-mail, together with any attachments, is intended for the named
recipients only and is confidential. It may also be privileged or otherwise
protected by law.

If you have received it in error, please notify the sender immediately by
reply e-mail and delete it and any attachments from your system. You may not
copy or disclose its contents to anyone.

_______________________________________________
Mailing list: DHIS 2 Users in Launchpad
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : DHIS 2 Users in Launchpad
More help : ListHelp - Launchpad Help

====================================================
This message was scanned for viruses with Trend Micro ScanMail, GFI MailSecurity and GFI MailEssentials by the World Health Organization Regional Office for the Western Pacific. However, the recipient is advised to scan this e-mail and any attached files for viruses.

Disclaimer:

This e-mail, together with any attachments, is intended for the named recipients only and is confidential. It may also be privileged or otherwise protected by law.

If you have received it in error, please notify the sender immediately by reply e-mail and delete it and any attachments from your system. You may not copy or disclose its contents to anyone.

4

Just a stupid question:

Have you added data elements to the dataset?

···

On 26 April 2012 10:11, Hiatt, Mr Tom (WPRO) hiattt@wpro.who.int wrote:

Thanks for your help.

I don’t think this had to do with changing data element names since I was never able to add a data element into the form (my other issue). Also, I don’t think I changed any names or categories.

Clearing the cache didn’t seem to clear things up either, unfortunately.

Do I need to really dig into the tables then?

Thanks again,

Tom

-----Original Message-----

From: Jason Pickering [mailto:jason.p.pickering@gmail.com]

Sent: 26 April 2012 15:35

To: Hiatt, Mr Tom (WPRO)

Cc: dhis2-users@lists.launchpad.net

Subject: Re: [Dhis2-users] Custom form designer creates error in data entry

I encountered a similar issue yesterday but did not think much about

it at the time, however I see it may now really be a bug.

I added a data element…

No. of HIV+ pregnant women newly intiated on ART for their own health

(New) with default category options

When I opened up the custom data entry form, I managed to dig this out

of the JavaScript console

c.defaultView.c.defaultView.getComputedStyle.bAjquery.min.js:4

f.extend.cssjquery.min.js:4

f.fn.extend.showjquery.min.js:4

f.fn.extend.showjquery-ui-1.8.12.custom.min.js:585

e.widget._create._renderAxisjquery-ui-1.8.12.custom.min.js:161

e.widget._createjquery-ui-1.8.12.custom.min.js:161

b.Widget._createWidgetjquery-ui-1.8.12.custom.min.js:30

b.widget.b.(anonymous function).(anonymous

function)jquery-ui-1.8.12.custom.min.js:28

b.widget.bridge.b.fn.(anonymous function)jquery-ui-1.8.12.custom.min.js:29

e.extend.eachjquery.min.js:2

e.fn.e.eachjquery.min.js:2

b.widget.bridge.b.fn.(anonymous function)jquery-ui-1.8.12.custom.min.js:29

c.widget._makeResizablejquery-ui-1.8.12.custom.min.js:387

c.widget._createjquery-ui-1.8.12.custom.min.js:380

b.Widget._createWidgetjquery-ui-1.8.12.custom.min.js:30

b.widget.b.(anonymous function).(anonymous

function)jquery-ui-1.8.12.custom.min.js:28

b.widget.bridge.b.fn.(anonymous function)jquery-ui-1.8.12.custom.min.js:29

e.extend.eachjquery.min.js:2

e.fn.e.eachjquery.min.js:2

b.widget.bridge.b.fn.(anonymous function)jquery-ui-1.8.12.custom.min.js:29

(anonymous function)viewDataEntryForm.js:11

f.Callbacks.njquery.min.js:2

f.Callbacks.o.fireWithjquery.min.js:2

e.extend.readyjquery.min.js:2

c.addEventListener.B

Not very helpful. When I changed (New) to (Foo) it got the same

error, thinking that it might have something to do with the use of

(New). When I removed (New) it worked just fine. Maybe it is related

to the name of the DE?

I do not know what you data element is, but normally that error

happens when a data element exists in the custom form, which does not

exist in the database. You may need to clear your cache completely in

order for the new form to appear. Otherwise, the full stack trace

would be helpful for the devs.

Best regards,

Jason

On Thu, Apr 26, 2012 at 2:40 AM, Hiatt, Mr Tom (WPRO)

hiattt@wpro.who.int wrote:

DHIS 2.7 with Chrome

I tried to create a custom data entry form and it looks like the form

designer was missing things (I couldn’t find data elements to add for

example).

I saved the custom version anyway and then went to data entry which now had

an exception. So I went back to the custom form screen, deleted it, but

there is still an exception for data entry.

Here’s the exception code:

[+] Exception (org.hibernate.ObjectNotFoundException): No row with the given

identifier exists:

[org.hisp.dhis.dataelement.DataElementCategoryOptionCombo#61]

Any idea how I can fix this and hopefully be able to add custom forms?

Thanks,

Tom

This message was scanned for viruses with Trend Micro ScanMail, GFI

MailSecurity and GFI MailEssentials by the World Health Organization

Regional Office for the Western Pacific. However, the recipient is advised

to scan this e-mail and any attached files for viruses.

Disclaimer:

This e-mail, together with any attachments, is intended for the named

recipients only and is confidential. It may also be privileged or otherwise

protected by law.

If you have received it in error, please notify the sender immediately by

reply e-mail and delete it and any attachments from your system. You may not

copy or disclose its contents to anyone.

Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

====================================================
This message was scanned for viruses with Trend Micro ScanMail, GFI MailSecurity and GFI MailEssentials by the World Health Organization Regional Office for the Western Pacific. However, the recipient is advised to scan this e-mail and any attached files for viruses.

Disclaimer:

This e-mail, together with any attachments, is intended for the named recipients only and is confidential. It may also be privileged or otherwise protected by law.

If you have received it in error, please notify the sender immediately by reply e-mail and delete it and any attachments from your system. You may not copy or disclose its contents to anyone.

Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

5

I was thinking the same way as Ola, may be the data element is attached to the dataset but later removed from the dataset.

···

Muhire Andrew

HMIS/Ministry of Health

First say to yourself what you would be; and then do what you have to do..

From: Ola Hodne Titlestad olati@ifi.uio.no
To: “Hiatt, Mr Tom (WPRO)” hiattt@wpro.who.int
Cc: “dhis2-users@lists.launchpad.net” dhis2-users@lists.launchpad.net
Sent: Thursday, April 26, 2012 10:16 AM
Subject: Re: [Dhis2-users] Custom form designer creates error in data entry

Just a stupid question:
Have you added data elements to the dataset?

Ola Hodne Titlestad (Mr)
HISP
Department of Informatics
University
of Oslo

Mobile: +47 48069736
Home address: Vetlandsvn. 95B, 0685 Oslo, Norway. Googlemaps
link

On 26 April 2012 10:11, Hiatt, Mr Tom (WPRO) hiattt@wpro.who.int wrote:

Thanks for your help.

I don’t think this had to do with changing data element names since I was never able to add a data element into the form (my other issue). Also, I don’t think I changed any names or categories.

Clearing the cache didn’t seem to clear things up either, unfortunately.

Do I need to really dig into the tables then?

Thanks again,

Tom

-----Original Message-----

From: Jason Pickering [mailto:jason.p.pickering@gmail.com]

Sent: 26 April 2012 15:35

To: Hiatt, Mr Tom (WPRO)

Cc: dhis2-users@lists.launchpad.net

Subject: Re: [Dhis2-users] Custom form designer creates error in data entry

I encountered a similar issue yesterday but did not think much about

it at the time, however I see it may now really be a bug.

I added a data element…

No. of HIV+ pregnant women newly intiated on ART for their own health

(New) with default category options

When I opened up the custom data entry form, I managed to dig this out

of the JavaScript console

c.defaultView.c.defaultView.getComputedStyle.bAjquery.min.js:4

f.extend.cssjquery.min.js:4

f.fn.extend.showjquery.min.js:4

f.fn.extend.showjquery-ui-1.8.12.custom.min.js:585

e.widget._create._renderAxisjquery-ui-1.8.12.custom.min.js:161

e.widget._createjquery-ui-1.8.12.custom.min.js:161

b.Widget._createWidgetjquery-ui-1.8.12.custom.min.js:30

b.widget.b.(anonymous function).(anonymous

function)jquery-ui-1.8.12.custom.min.js:28

b.widget.bridge.b.fn.(anonymous function)jquery-ui-1.8.12.custom.min.js:29

e.extend.eachjquery.min.js:2

e.fn.e.eachjquery.min.js:2

b.widget.bridge.b.fn.(anonymous function)jquery-ui-1.8.12.custom.min.js:29

c.widget._makeResizablejquery-ui-1.8.12.custom.min.js:387

c.widget._createjquery-ui-1.8.12.custom.min.js:380

b.Widget._createWidgetjquery-ui-1.8.12.custom.min.js:30

b.widget.b.(anonymous function).(anonymous

function)jquery-ui-1.8.12.custom.min.js:28

b.widget.bridge.b.fn.(anonymous function)jquery-ui-1.8.12.custom.min.js:29

e.extend.eachjquery.min.js:2

e.fn.e.eachjquery.min.js:2

b.widget.bridge.b.fn.(anonymous function)jquery-ui-1.8.12.custom.min.js:29

(anonymous function)viewDataEntryForm.js:11

f.Callbacks.njquery.min.js:2

f.Callbacks.o.fireWithjquery.min.js:2

e.extend.readyjquery.min.js:2

c.addEventListener.B

Not very helpful. When I changed (New) to (Foo) it got the same

error, thinking that it might have something to do with the use of

(New). When I removed (New) it worked just fine. Maybe it is related

to the name of the DE?

I do not know what you data element is, but normally that error

happens when a data element exists in the custom form, which does not

exist in the database. You may need to clear your cache completely in

order for the new form to appear. Otherwise, the full stack trace

would be helpful for the devs.

Best regards,

Jason

On Thu, Apr 26, 2012 at 2:40 AM, Hiatt, Mr Tom (WPRO) > > hiattt@wpro.who.int wrote:

DHIS 2.7 with Chrome

I tried to create a custom data entry form and it looks like the form

designer was missing things (I couldn’t find data elements to add for

example).

I saved the custom version anyway and then went to data entry which now had

an exception. So I went back to the custom form screen, deleted it, but

there is still an exception for data entry.

Here’s the exception code:

[+] Exception (org.hibernate.ObjectNotFoundException): No row with the given

identifier exists:

[org.hisp.dhis.dataelement.DataElementCategoryOptionCombo#61]

Any idea how I can fix this and hopefully be able to add custom forms?

Thanks,

Tom

This message was scanned for viruses with Trend Micro ScanMail, GFI

MailSecurity and GFI MailEssentials by the World Health Organization

Regional Office for the Western Pacific. However, the recipient is advised

to scan this e-mail and any attached files for viruses.

Disclaimer:

This e-mail, together with any attachments, is intended for the named

recipients only and is confidential. It may also be privileged or otherwise

protected by law.

If you have received it in error, please notify the sender immediately by

reply e-mail and delete it and any attachments from your system. You may not

copy or disclose its contents to anyone.

Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

====================================================
This message was scanned for viruses with Trend Micro ScanMail, GFI MailSecurity and GFI MailEssentials by the World Health Organization Regional Office for the Western Pacific. However, the recipient is advised to scan this e-mail and any attached files for viruses.

Disclaimer:

This e-mail, together with any attachments, is intended for the named recipients only and is confidential. It may also be privileged or otherwise protected by law.

If you have received it in error, please notify the sender immediately by reply e-mail and delete it and any attachments from your system. You may not copy or disclose its contents to anyone.

Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help : https://help.launchpad.net/ListHelp

6

Not a stupid question, but yes I have added data elements. In fact, the data entry was working fine until I opened and saved the custom form.

···

From: Muhire Andrew [mailto:muhireandrew@yahoo.com]

Sent: 26 April 2012 16:30

To: Ola Hodne Titlestad; Hiatt, Mr Tom (WPRO)

Cc: dhis2-users@lists.launchpad.net

Subject: Re: [Dhis2-users] Custom form designer creates error in data entry

I was thinking the same way as Ola, may be the data element is attached to the dataset but later removed from the dataset.

Muhire Andrew

HMIS/Ministry of Health

First say to yourself what you would be; and then do what you have to do..

From: Ola Hodne Titlestad olati@ifi.uio.no

To: " Hiatt, Mr Tom (WPRO)" hiattt@wpro.who.int

Cc: “dhis2-users@lists.launchpad.net” dhis2-users@lists.launchpad.net

Sent: Thursday, April 26, 2012 10:16 AM

Subject: Re: [Dhis2-users] Custom form designer creates error in data entry

Just a stupid question:

Have you added data elements to the dataset?

Ola Hodne Titlestad (Mr)

HISP

Department of Informatics

University of Oslo

Mobile: +47 48069736

Home address: Vetlandsvn. 95B, 0685 Oslo , Norway. Googlemaps link

On 26 April 2012 10:11, Hiatt, Mr Tom (WPRO) hiattt@wpro.who.int wrote:

Thanks for your help.

I don’t think this had to do with changing data element names since I was never able to add a data element into the form (my other issue). Also, I don’t think I changed any names or categories.

Clearing the cache didn’t seem to clear things up either, unfortunately.

Do I need to really dig into the tables then?

Thanks again,

Tom

-----Original Message-----

From: Jason Pickering [mailto:jason.p.pickering@gmail.com]

Sent: 26 April 2012 15:35

To: Hiatt, Mr Tom (WPRO)

Cc: dhis2-users@lists.launchpad.net

Subject: Re: [Dhis2-users] Custom form designer creates error in data entry

I encountered a similar issue yesterday but did not think much about

it at the time, however I see it may now really be a bug.

I added a data element…

No. of HIV+ pregnant women newly intiated on ART for their own health

(New) with default category options

When I opened up the custom data entry form, I managed to dig this out

of the JavaScript console

c.defaultView.c.defaultView.getComputedStyle.bAjquery.min.js:4

f.extend.cssjquery.min.js:4

f.fn.extend.showjquery.min.js:4

f.fn.extend.showjquery-ui-1.8.12.custom.min.js:585

e.widget._create._renderAxisjquery-ui-1.8.12.custom.min.js:161

e.widget._createjquery-ui-1.8.12.custom.min.js:161

b.Widget._createWidgetjquery-ui-1.8.12.custom.min.js:30

b.widget.b.(anonymous function).(anonymous

function)jquery-ui-1.8.12.custom.min.js:28

b.widget.bridge.b.fn.(anonymous function)jquery-ui-1.8.12.custom.min.js:29

e.extend.eachjquery.min.js:2

e.fn.e.eachjquery.min.js:2

b.widget.bridge.b.fn.(anonymous function)jquery-ui-1.8.12.custom.min.js:29

c.widget._makeResizablejquery-ui-1.8.12.custom.min.js:387

c.widget._createjquery-ui-1.8.12.custom.min.js:380

b.Widget._createWidgetjquery-ui-1.8.12.custom.min.js:30

b.widget.b.(anonymous function).(anonymous

function)jquery-ui-1.8.12.custom.min.js:28

b.widget.bridge.b.fn.(anonymous function)jquery-ui-1.8.12.custom.min.js:29

e.extend.eachjquery.min.js:2

e.fn.e.eachjquery.min.js:2

b.widget.bridge.b.fn.(anonymous function)jquery-ui-1.8.12.custom.min.js:29

(anonymous function)viewDataEntryForm.js:11

f.Callbacks.njquery.min.js:2

f.Callbacks.o.fireWithjquery.min.js:2

e.extend.readyjquery.min.js:2

c.addEventListener.B

Not very helpful. When I changed (New) to (Foo) it got the same

error, thinking that it might have something to do with the use of

(New). When I removed (New) it worked just fine. Maybe it is related

to the name of the DE?

I do not know what you data element is, but normally that error

happens when a data element exists in the custom form, which does not

exist in the database. You may need to clear your cache completely in

order for the new form to appear. Otherwise, the full stack trace

would be helpful for the devs.

Best regards,

Jason

On Thu, Apr 26, 2012 at 2:40 AM, Hiatt, Mr Tom (WPRO) hiattt@wpro.who.int wrote:

DHIS 2.7 with Chrome

I tried to create a custom data entry form and it looks like the form

designer was missing things (I couldn’t find data elements to add for

example).

I saved the custom version anyway and then went to data entry which now had

an exception. So I went back to the custom form screen, deleted it, but

there is still an exception for data entry.

Here’s the exception code:

[+] Exception (org.hibernate.ObjectNotFoundException): No row with the given

identifier exists:

[org.hisp.dhis.dataelement.DataElementCategoryOptionCombo#61]

Any idea how I can fix this and hopefully be able to add custom forms?

Thanks,

Tom

This message was scanned for viruses with Trend Micro ScanMail, GFI

MailSecurity and GFI MailEssentials by the World Health Organization

Regional Office for the Western Pacific. However, the recipient is advised

to scan this e-mail and any attached files for viruses.

Disclaimer:

This e-mail, together with any attachments, is intended for the named

recipients only and is confidential. It may also be privileged or otherwise

protected by law.

If you have received it in error, please notify the sender immediately by

reply e-mail and delete it and any attachments from your system. You may not

copy or disclose its contents to anyone.

Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

====================================================

This message was scanned for viruses with Trend Micro ScanMail, GFI MailSecurity and GFI MailEssentials by the World Health Organization Regional Office for the Western Pacific. However, the recipient is advised to scan this e-mail and any attached files for viruses.

Disclaimer:

This e-mail, together with any attachments, is intended for the named recipients only and is confidential. It may also be privileged or otherwise protected by law.

If you have received it in error, please notify the sender immediately by reply e-mail and delete it and any attachments from your system. You may not copy or disclose its contents to anyone.

Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

This message was scanned for viruses with Trend Micro ScanMail, GFI MailSecurity and GFI MailEssentials by the World Health Organization Regional Office for the Western Pacific. However, the recipient is advised to scan this e-mail and any attached files for viruses.

Disclaimer:

This e-mail, together with any attachments, is intended for the named recipients only and is confidential. It may also be privileged or otherwise protected by law.

If you have received it in error, please notify the sender immediately by reply e-mail and delete it and any attachments from your system. You may not copy or disclose its contents to anyone.

7

Okay I think I got it!

It seems DHIS is really fiddly with more than 3 categories in a combo. When I changed my data element to only be disaggregated by 3 categories it worked again. Afterward I changed it back to the 4 category (age, sex, case type, and disability level in case you were wondering) it works again. Luckily I don’t have any real data in there yet.

So I’m thinking it’s safer to only have up to 3 categories at a time and then, sort of break my data model and create additional (duplicate) data elements for the other categories. Is this what you would do?

Thanks again,

Tom

···

From: Muhire Andrew [mailto:muhireandrew@yahoo.com]

Sent: 26 April 2012 16:30

To: Ola Hodne Titlestad; Hiatt, Mr Tom (WPRO)

Cc: dhis2-users@lists.launchpad.net

Subject: Re: [Dhis2-users] Custom form designer creates error in data entry

I was thinking the same way as Ola, may be the data element is attached to the dataset but later removed from the dataset.

Muhire Andrew

HMIS/Ministry of Health

First say to yourself what you would be; and then do what you have to do..

From: Ola Hodne Titlestad olati@ifi.uio.no

To: " Hiatt, Mr Tom (WPRO)" hiattt@wpro.who.int

Cc: “dhis2-users@lists.launchpad.net” dhis2-users@lists.launchpad.net

Sent: Thursday, April 26, 2012 10:16 AM

Subject: Re: [Dhis2-users] Custom form designer creates error in data entry

Just a stupid question:

Have you added data elements to the dataset?

Ola Hodne Titlestad (Mr)

HISP

Department of Informatics

University of Oslo

Mobile: +47 48069736

Home address: Vetlandsvn. 95B, 0685 Oslo , Norway. Googlemaps link

On 26 April 2012 10:11, Hiatt, Mr Tom (WPRO) hiattt@wpro.who.int wrote:

Thanks for your help.

I don’t think this had to do with changing data element names since I was never able to add a data element into the form (my other issue). Also, I don’t think I changed any names or categories.

Clearing the cache didn’t seem to clear things up either, unfortunately.

Do I need to really dig into the tables then?

Thanks again,

Tom

-----Original Message-----

From: Jason Pickering [mailto:jason.p.pickering@gmail.com]

Sent: 26 April 2012 15:35

To: Hiatt, Mr Tom (WPRO)

Cc: dhis2-users@lists.launchpad.net

Subject: Re: [Dhis2-users] Custom form designer creates error in data entry

I encountered a similar issue yesterday but did not think much about

it at the time, however I see it may now really be a bug.

I added a data element…

No. of HIV+ pregnant women newly intiated on ART for their own health

(New) with default category options

When I opened up the custom data entry form, I managed to dig this out

of the JavaScript console

c.defaultView.c.defaultView.getComputedStyle.bAjquery.min.js:4

f.extend.cssjquery.min.js:4

f.fn.extend.showjquery.min.js:4

f.fn.extend.showjquery-ui-1.8.12.custom.min.js:585

e.widget._create._renderAxisjquery-ui-1.8.12.custom.min.js:161

e.widget._createjquery-ui-1.8.12.custom.min.js:161

b.Widget._createWidgetjquery-ui-1.8.12.custom.min.js:30

b.widget.b.(anonymous function).(anonymous

function)jquery-ui-1.8.12.custom.min.js:28

b.widget.bridge.b.fn.(anonymous function)jquery-ui-1.8.12.custom.min.js:29

e.extend.eachjquery.min.js:2

e.fn.e.eachjquery.min.js:2

b.widget.bridge.b.fn.(anonymous function)jquery-ui-1.8.12.custom.min.js:29

c.widget._makeResizablejquery-ui-1.8.12.custom.min.js:387

c.widget._createjquery-ui-1.8.12.custom.min.js:380

b.Widget._createWidgetjquery-ui-1.8.12.custom.min.js:30

b.widget.b.(anonymous function).(anonymous

function)jquery-ui-1.8.12.custom.min.js:28

b.widget.bridge.b.fn.(anonymous function)jquery-ui-1.8.12.custom.min.js:29

e.extend.eachjquery.min.js:2

e.fn.e.eachjquery.min.js:2

b.widget.bridge.b.fn.(anonymous function)jquery-ui-1.8.12.custom.min.js:29

(anonymous function)viewDataEntryForm.js:11

f.Callbacks.njquery.min.js:2

f.Callbacks.o.fireWithjquery.min.js:2

e.extend.readyjquery.min.js:2

c.addEventListener.B

Not very helpful. When I changed (New) to (Foo) it got the same

error, thinking that it might have something to do with the use of

(New). When I removed (New) it worked just fine. Maybe it is related

to the name of the DE?

I do not know what you data element is, but normally that error

happens when a data element exists in the custom form, which does not

exist in the database. You may need to clear your cache completely in

order for the new form to appear. Otherwise, the full stack trace

would be helpful for the devs.

Best regards,

Jason

On Thu, Apr 26, 2012 at 2:40 AM, Hiatt, Mr Tom (WPRO) hiattt@wpro.who.int wrote:

DHIS 2.7 with Chrome

I tried to create a custom data entry form and it looks like the form

designer was missing things (I couldn’t find data elements to add for

example).

I saved the custom version anyway and then went to data entry which now had

an exception. So I went back to the custom form screen, deleted it, but

there is still an exception for data entry.

Here’s the exception code:

[+] Exception (org.hibernate.ObjectNotFoundException): No row with the given

identifier exists:

[org.hisp.dhis.dataelement.DataElementCategoryOptionCombo#61]

Any idea how I can fix this and hopefully be able to add custom forms?

Thanks,

Tom

This message was scanned for viruses with Trend Micro ScanMail, GFI

MailSecurity and GFI MailEssentials by the World Health Organization

Regional Office for the Western Pacific. However, the recipient is advised

to scan this e-mail and any attached files for viruses.

Disclaimer:

This e-mail, together with any attachments, is intended for the named

recipients only and is confidential. It may also be privileged or otherwise

protected by law.

If you have received it in error, please notify the sender immediately by

reply e-mail and delete it and any attachments from your system. You may not

copy or disclose its contents to anyone.

Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

====================================================

This message was scanned for viruses with Trend Micro ScanMail, GFI MailSecurity and GFI MailEssentials by the World Health Organization Regional Office for the Western Pacific. However, the recipient is advised to scan this e-mail and any attached files for viruses.

Disclaimer:

This e-mail, together with any attachments, is intended for the named recipients only and is confidential. It may also be privileged or otherwise protected by law.

If you have received it in error, please notify the sender immediately by reply e-mail and delete it and any attachments from your system. You may not copy or disclose its contents to anyone.

Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

This message was scanned for viruses with Trend Micro ScanMail, GFI MailSecurity and GFI MailEssentials by the World Health Organization Regional Office for the Western Pacific. However, the recipient is advised to scan this e-mail and any attached files for viruses.

Disclaimer:

This e-mail, together with any attachments, is intended for the named recipients only and is confidential. It may also be privileged or otherwise protected by law.

If you have received it in error, please notify the sender immediately by reply e-mail and delete it and any attachments from your system. You may not copy or disclose its contents to anyone.

8

Hi Tom,

If you send a copy of your paper form it will be easier to comment on how to map to data elements and categories.

Haven’t heard of any problems with more than 3 categories in a combo before, but this problem might be related to a change in categorycombo for the data elements in the form (after the form was designed).

Each data field in the form is linked a the data element + a categoryoptioncombination, and the categoryoptioncombination will be different when you change from 3 to 4 categories. If you re-design the custom for (delete all assigned fields) and try again, it should work for both 4 and 3 categories in a combination.

Ola

···

On 26 April 2012 10:46, Hiatt, Mr Tom (WPRO) hiattt@wpro.who.int wrote:

Okay I think I got it!

It seems DHIS is really fiddly with more than 3 categories in a combo. When I changed my data element to only be disaggregated by 3 categories it worked again. Afterward I changed it back to the 4 category (age, sex, case type, and disability level in case you were wondering) it works again. Luckily I don’t have any real data in there yet.

So I’m thinking it’s safer to only have up to 3 categories at a time and then, sort of break my data model and create additional (duplicate) data elements for the other categories. Is this what you would do?

Thanks again,

Tom

From: Muhire Andrew [mailto:muhireandrew@yahoo.com]

Sent: 26 April 2012 16:30

Cc: dhis2-users@lists.launchpad.net

Subject: Re: [Dhis2-users] Custom form designer creates error in data entry

To: Ola Hodne Titlestad; Hiatt, Mr Tom (WPRO)

I was thinking the same way as Ola, may be the data element is attached to the dataset but later removed from the dataset.

Muhire Andrew

HMIS/Ministry of Health

First say to yourself what you would be; and then do what you have to do..

From: Ola Hodne Titlestad olati@ifi.uio.no

To: " Hiatt, Mr Tom (WPRO)" hiattt@wpro.who.int

Cc: “dhis2-users@lists.launchpad.net” dhis2-users@lists.launchpad.net

Sent: Thursday, April 26, 2012 10:16 AM

Subject: Re: [Dhis2-users] Custom form designer creates error in data entry

Just a stupid question:

Have you added data elements to the dataset?

Ola Hodne Titlestad (Mr)

HISP

Department of Informatics

University of Oslo

Mobile: +47 48069736

Home address: Vetlandsvn. 95B, 0685 Oslo , Norway. Googlemaps link

On 26 April 2012 10:11, Hiatt, Mr Tom (WPRO) hiattt@wpro.who.int wrote:

Thanks for your help.

I don’t think this had to do with changing data element names since I was never able to add a data element into the form (my other issue). Also, I don’t think I changed any names or categories.

Clearing the cache didn’t seem to clear things up either, unfortunately.

Do I need to really dig into the tables then?

Thanks again,

Tom

-----Original Message-----

From: Jason Pickering [mailto:jason.p.pickering@gmail.com]

Sent: 26 April 2012 15:35

To: Hiatt, Mr Tom (WPRO)

Cc: dhis2-users@lists.launchpad.net

Subject: Re: [Dhis2-users] Custom form designer creates error in data entry

I encountered a similar issue yesterday but did not think much about

it at the time, however I see it may now really be a bug.

I added a data element…

No. of HIV+ pregnant women newly intiated on ART for their own health

(New) with default category options

When I opened up the custom data entry form, I managed to dig this out

of the JavaScript console

c.defaultView.c.defaultView.getComputedStyle.bAjquery.min.js:4

f.extend.cssjquery.min.js:4

f.fn.extend.showjquery.min.js:4

f.fn.extend.showjquery-ui-1.8.12.custom.min.js:585

e.widget._create._renderAxisjquery-ui-1.8.12.custom.min.js:161

e.widget._createjquery-ui-1.8.12.custom.min.js:161

b.Widget._createWidgetjquery-ui-1.8.12.custom.min.js:30

b.widget.b.(anonymous function).(anonymous

function)jquery-ui-1.8.12.custom.min.js:28

b.widget.bridge.b.fn.(anonymous function)jquery-ui-1.8.12.custom.min.js:29

e.extend.eachjquery.min.js:2

e.fn.e.eachjquery.min.js:2

b.widget.bridge.b.fn.(anonymous function)jquery-ui-1.8.12.custom.min.js:29

c.widget._makeResizablejquery-ui-1.8.12.custom.min.js:387

c.widget._createjquery-ui-1.8.12.custom.min.js:380

b.Widget._createWidgetjquery-ui-1.8.12.custom.min.js:30

b.widget.b.(anonymous function).(anonymous

function)jquery-ui-1.8.12.custom.min.js:28

b.widget.bridge.b.fn.(anonymous function)jquery-ui-1.8.12.custom.min.js:29

e.extend.eachjquery.min.js:2

e.fn.e.eachjquery.min.js:2

b.widget.bridge.b.fn.(anonymous function)jquery-ui-1.8.12.custom.min.js:29

(anonymous function)viewDataEntryForm.js:11

f.Callbacks.njquery.min.js:2

f.Callbacks.o.fireWithjquery.min.js:2

e.extend.readyjquery.min.js:2

c.addEventListener.B

Not very helpful. When I changed (New) to (Foo) it got the same

error, thinking that it might have something to do with the use of

(New). When I removed (New) it worked just fine. Maybe it is related

to the name of the DE?

I do not know what you data element is, but normally that error

happens when a data element exists in the custom form, which does not

exist in the database. You may need to clear your cache completely in

order for the new form to appear. Otherwise, the full stack trace

would be helpful for the devs.

Best regards,

Jason

On Thu, Apr 26, 2012 at 2:40 AM, Hiatt, Mr Tom
(WPRO)

hiattt@wpro.who.int wrote:

DHIS 2.7 with Chrome

I tried to create a custom data entry form and it looks like the form

designer was missing things (I couldn’t find data elements to add for

example).

I saved the custom version anyway and then went to data entry which now had

an exception. So I went back to the custom form screen, deleted it, but

there is still an exception for data entry.

Here’s the exception code:

[+] Exception (org.hibernate.ObjectNotFoundException): No row with the given

identifier exists:

[org.hisp.dhis.dataelement.DataElementCategoryOptionCombo#61]

Any idea how I can fix this and hopefully be able to add custom forms?

Thanks,

Tom

This message was scanned for viruses with Trend Micro ScanMail, GFI

MailSecurity and GFI MailEssentials by the World Health Organization

Regional Office for the Western Pacific. However, the recipient is advised

to scan this e-mail and any attached files for viruses.

Disclaimer:

This e-mail, together with any attachments, is intended for the named

recipients only and is confidential. It may also be privileged or otherwise

protected by law.

If you have received it in error, please notify the sender immediately by

reply e-mail and delete it and any attachments from your system. You may not

copy or disclose its contents to anyone.

Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

====================================================

This message was scanned for viruses with Trend Micro ScanMail, GFI MailSecurity and GFI MailEssentials by the World Health Organization Regional Office for the Western Pacific. However, the recipient is advised to scan this e-mail and any attached files for viruses.

Disclaimer:

This e-mail, together with any attachments, is intended for the named recipients only and is confidential. It may also be privileged or otherwise protected by law.

If you have received it in error, please notify the sender immediately by reply e-mail and delete it and any attachments from your system. You may not copy or disclose its contents to anyone.

Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

This message was scanned for viruses with Trend Micro ScanMail, GFI MailSecurity and GFI MailEssentials by the World Health Organization Regional Office for the Western Pacific. However, the recipient is advised to scan this e-mail and any attached files for viruses.

Disclaimer:

This e-mail, together with any attachments, is intended for the named recipients only and is confidential. It may also be privileged or otherwise protected by law.

If you have received it in error, please notify the sender immediately by reply e-mail and delete it and any attachments from your system. You may not copy or disclose its contents to anyone.

Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

9

Hi Ola,

Here is the form I'm using. As you can see, it asks for more indicator-level data and my plan was to collect the elements that a user would need to collect anyway in order to calculate the indicators. I'd certainly be interested in how you would structure it. (Related question: is there a way in DHIS, where a user can fill in the total when the disaggregation is unavailable? i.e. age or sex unknown. Or is it better to just have an unknown category?)

Thanks for the info about custom forms. Again, I wasn't able to add any fields to the form (I didn't do anything but save it), so something is still temperamental at least in my installation.

Thanks,
Tom

···

________________________________
From: olatitle@gmail.com [mailto:olatitle@gmail.com] On Behalf Of Ola Hodne Titlestad
Sent: 26 April 2012 17:10
To: Hiatt, Mr Tom (WPRO)
Cc: Muhire Andrew; dhis2-users@lists.launchpad.net
Subject: Re: [Dhis2-users] Custom form designer creates error in data entry

Hi Tom,

If you send a copy of your paper form it will be easier to comment on how to map to data elements and categories.

Haven't heard of any problems with more than 3 categories in a combo before, but this problem might be related to a change in categorycombo for the data elements in the form (after the form was designed).

Each data field in the form is linked a the data element + a categoryoptioncombination, and the categoryoptioncombination will be different when you change from 3 to 4 categories. If you re-design the custom for (delete all assigned fields) and try again, it should work for both 4 and 3 categories in a combination.

Ola
----

----------------------------------
Ola Hodne Titlestad (Mr)
HISP
Department of Informatics
University of Oslo

Mobile: +47 48069736
Home address: Vetlandsvn. 95B, 0685 Oslo, Norway. Googlemaps link<http://maps.google.com/maps?f=q&source=s_q&hl=en&geocode=&q=Vetlandsvn.+95B,+0685+Oslo,+Norway&gt;

On 26 April 2012 10:46, Hiatt, Mr Tom (WPRO) <hiattt@wpro.who.int<mailto:hiattt@wpro.who.int>> wrote:
Okay I think I got it!

It seems DHIS is really fiddly with more than 3 categories in a combo. When I changed my data element to only be disaggregated by 3 categories it worked again. Afterward I changed it back to the 4 category (age, sex, case type, and disability level in case you were wondering) it works again. Luckily I don't have any real data in there yet.

So I'm thinking it's safer to only have up to 3 categories at a time and then, sort of break my data model and create additional (duplicate) data elements for the other categories. Is this what you would do?

Thanks again,
Tom

________________________________
From: Muhire Andrew [mailto:muhireandrew@yahoo.com<mailto:muhireandrew@yahoo.com>]
Sent: 26 April 2012 16:30
To: Ola Hodne Titlestad; Hiatt, Mr Tom (WPRO)