Add new dataelement in an existing program

Marko_David_Garcia · 26 February 2015 23:14

Hello friends.

When adding a new data element in an existing program the following error occurs:

"An exception Occurred

Sorry! The system failed to execute the operation. Usually, no data is lost and you can continue working by going back to the previous page".

The Dhis2 version is: 2.16.

Thank you very much.

···

Best regards,

Marko David Garcia M.

morten · 27 February 2015 03:36

Hi Marko

Could you provide us with the full log output? Need to know a bit more information…

···

On Fri, Feb 27, 2015 at 6:14 AM, Marko David Garcia markodavidgm@gmail.com wrote:

Hello friends.

When adding a new data element in an existing program the following error occurs:

"An exception Occurred

Sorry! The system failed to execute the operation. Usually, no data is lost and you can continue working by going back to the previous page".

The Dhis2 version is: 2.16.

Thank you very much.

Best regards,

Marko David Garcia M.

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

–
Morten

Marko_David_Garcia · 27 February 2015 17:32

Thanks for your answers.

This is the tomcat log:

INFO 2015-02-27 12:09:05,390 Time: 1737988 micros: Tracked entity instance qu

ery SQL: select tei.uid as instance, tei.created as created, tei.lastupdated as

lastupdated, ou.uid as ou, te.uid as te, “eax4yJM6RvI”.value as “eax4yJM6RvI”, "

ei9KJWCIVV6".value as “ei9KJWCIVV6”, “hsqeqonqKxm”.value as “hsqeqonqKxm”, "DbDO

GyMz2H8".value as “DbDOGyMz2H8” from trackedentityinstance tei inner join tracke

dentity te on tei.trackedentityid = te.trackedentityid inner join organisationun

it ou on tei.organisationunitid = ou.organisationunitid left join trackedentitya

ttributevalue as “eax4yJM6RvI” on “eax4yJM6RvI”.trackedentityinstanceid = tei.tr

ackedentityinstanceid and “eax4yJM6RvI”.trackedentityattributeid = 74099 left jo

in trackedentityattributevalue as “ei9KJWCIVV6” on “ei9KJWCIVV6”.trackedentityin

stanceid = tei.trackedentityinstanceid and “ei9KJWCIVV6”.trackedentityattributei

d = 83080 left join trackedentityattributevalue as “hsqeqonqKxm” on "hsqeqonqKxm

".trackedentityinstanceid = tei.trackedentityinstanceid and “hsqeqonqKxm”.tracke

dentityattributeid = 74153 left join trackedentityattributevalue as "DbDOGyMz2H8

" on “DbDOGyMz2H8”.trackedentityinstanceid = tei.trackedentityinstanceid and "Db

DOGyMz2H8".trackedentityattributeid = 74097 where tei.organisationunitid in (73)

and exists (select pi.trackedentityinstanceid from programinstance pi where pi.

trackedentityinstanceid = tei.trackedentityinstanceid and pi.programid = 83981 )

limit 50 offset 0 (Timer.java [http-apr-8080-exec-4])

INFO 2015-02-27 12:09:07,328 Time: 1924658 micros: Tracked entity instance co

unt SQL: select count(tei.uid) as instance from trackedentityinstance tei inner

join trackedentity te on tei.trackedentityid = te.trackedentityid inner join org

anisationunit ou on tei.organisationunitid = ou.organisationunitid left join tra

ckedentityattributevalue as “eax4yJM6RvI” on “eax4yJM6RvI”.trackedentityinstance

id = tei.trackedentityinstanceid and “eax4yJM6RvI”.trackedentityattributeid = 74

099 left join trackedentityattributevalue as “ei9KJWCIVV6” on “ei9KJWCIVV6”.trac

kedentityinstanceid = tei.trackedentityinstanceid and “ei9KJWCIVV6”.trackedentit

yattributeid = 83080 left join trackedentityattributevalue as “hsqeqonqKxm” on "

hsqeqonqKxm".trackedentityinstanceid = tei.trackedentityinstanceid and "hsqeqonq

Kxm".trackedentityattributeid = 74153 left join trackedentityattributevalue as "

DbDOGyMz2H8" on “DbDOGyMz2H8”.trackedentityinstanceid = tei.trackedentityinstanc

eid and “DbDOGyMz2H8”.trackedentityattributeid = 74097 where tei.organisationuni

tid in (73) and exists (select pi.trackedentityinstanceid from programinstance p

i where pi.trackedentityinstanceid = tei.trackedentityinstanceid and pi.programi

d = 83981 ) (Timer.java [http-apr-8080-exec-4])

INFO 2015-02-27 12:13:38,234 ‘mgarcia’ update org.hisp.dhis.program.ProgramSt

age, name: Formato de Tutelas, uid: E7NfRfjBOrW (AuditLogUtil.java [http-apr-808

0-exec-4])

INFO 2015-02-27 12:14:07,171 ‘mgarcia’ update org.hisp.dhis.program.ProgramSt

ageSection, name: General, uid: TQsiWPi4o2s (AuditLogUtil.java [http-apr-8080-ex

ec-9])

INFO 2015-02-27 12:15:09,031 Time: 141921 micros: Tracked entity instance que

ry SQL: select tei.uid as instance, tei.created as created, tei.lastupdated as l

astupdated, ou.uid as ou, te.uid as te, “eax4yJM6RvI”.value as “eax4yJM6RvI”, "e

i9KJWCIVV6".value as “ei9KJWCIVV6”, “hsqeqonqKxm”.value as “hsqeqonqKxm”, "DbDOG

yMz2H8".value as “DbDOGyMz2H8” from trackedentityinstance tei inner join tracked

entity te on tei.trackedentityid = te.trackedentityid inner join organisationuni

t ou on tei.organisationunitid = ou.organisationunitid left join trackedentityat

tributevalue as “eax4yJM6RvI” on “eax4yJM6RvI”.trackedentityinstanceid = tei.tra

ckedentityinstanceid and “eax4yJM6RvI”.trackedentityattributeid = 74099 left joi

n trackedentityattributevalue as “ei9KJWCIVV6” on “ei9KJWCIVV6”.trackedentityins

tanceid = tei.trackedentityinstanceid and “ei9KJWCIVV6”.trackedentityattributeid

= 83080 left join trackedentityattributevalue as “hsqeqonqKxm” on “hsqeqonqKxm”

.trackedentityinstanceid = tei.trackedentityinstanceid and “hsqeqonqKxm”.tracked

entityattributeid = 74153 left join trackedentityattributevalue as “DbDOGyMz2H8”

on “DbDOGyMz2H8”.trackedentityinstanceid = tei.trackedentityinstanceid and "DbD

OGyMz2H8".trackedentityattributeid = 74097 where tei.organisationunitid in (74)

and exists (select pi.trackedentityinstanceid from programinstance pi where pi.t

rackedentityinstanceid = tei.trackedentityinstanceid and pi.programid = 83981 )

limit 50 offset 0 (Timer.java [http-apr-8080-exec-5])

INFO 2015-02-27 12:15:09,046 Time: 16891 micros: Tracked entity instance coun

t SQL: select count(tei.uid) as instance from trackedentityinstance tei inner jo

in trackedentity te on tei.trackedentityid = te.trackedentityid inner join organ

isationunit ou on tei.organisationunitid = ou.organisationunitid left join track

edentityattributevalue as “eax4yJM6RvI” on “eax4yJM6RvI”.trackedentityinstanceid

= tei.trackedentityinstanceid and “eax4yJM6RvI”.trackedentityattributeid = 7409

9 left join trackedentityattributevalue as “ei9KJWCIVV6” on “ei9KJWCIVV6”.tracke

dentityinstanceid = tei.trackedentityinstanceid and “ei9KJWCIVV6”.trackedentitya

ttributeid = 83080 left join trackedentityattributevalue as “hsqeqonqKxm” on "hs

qeqonqKxm".trackedentityinstanceid = tei.trackedentityinstanceid and "hsqeqonqKx

m".trackedentityattributeid = 74153 left join trackedentityattributevalue as "Db

DOGyMz2H8" on “DbDOGyMz2H8”.trackedentityinstanceid = tei.trackedentityinstancei

d and “DbDOGyMz2H8”.trackedentityattributeid = 74097 where tei.organisationuniti

d in (74) and exists (select pi.trackedentityinstanceid from programinstance pi

where pi.trackedentityinstanceid = tei.trackedentityinstanceid and pi.programid

= 83981 ) (Timer.java [http-apr-8080-exec-5])

ERROR 2015-02-27 12:15:12,765 Error while executing action (ExceptionIntercept

or.java [http-apr-8080-exec-7])

java.lang.NullPointerException

at java.lang.Integer.compareTo(Integer.java:1216)

at org.hisp.dhis.program.comparator.ProgramStageDataElementSortOrderComp

arator.compare(ProgramStageDataElementSortOrderComparator.java:46)

at org.hisp.dhis.program.comparator.ProgramStageDataElementSortOrderComp

arator.compare(ProgramStageDataElementSortOrderComparator.java:35)

at java.util.TimSort.gallopLeft(TimSort.java:556)

at java.util.TimSort.mergeHi(TimSort.java:868)

at java.util.TimSort.mergeAt(TimSort.java:512)

at java.util.TimSort.mergeForceCollapse(TimSort.java:453)

at java.util.TimSort.sort(TimSort.java:250)

at java.util.Arrays.sort(Arrays.java:1512)

at java.util.ArrayList.sort(ArrayList.java:1454)

at java.util.Collections.sort(Collections.java:175)

at org.hisp.dhis.caseentry.action.caseentry.LoadDataEntryAction.execute(

LoadDataEntryAction.java:292)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.

java:62)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces

sorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:483)

at com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultA

ctionInvocation.java:450)

at com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(Defa

ultActionInvocation.java:289)