Add new dataelement in an existing program

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.

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

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)

at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI

nvocation.java:252)

at org.hisp.dhis.webportal.interceptor.XWorkPortalUserInterceptor.interc

ept(XWorkPortalUserInterceptor.java:88)

at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI

nvocation.java:246)

at org.hisp.dhis.webportal.interceptor.XWorkPortalModuleInterceptor.inte

rcept(XWorkPortalModuleInterceptor.java:89)

at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI

nvocation.java:246)

at org.hisp.dhis.webportal.interceptor.XWorkPortalMenuInterceptor.interc

ept(XWorkPortalMenuInterceptor.java:97)

at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI

nvocation.java:246)

at org.hisp.dhis.webportal.interceptor.XWorkPortalParamsInterceptor.inte

rcept(XWorkPortalParamsInterceptor.java:147)

at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI

nvocation.java:246)

at org.hisp.dhis.interceptor.ContextInterceptor.intercept(ContextInterce

ptor.java:83)

at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI

nvocation.java:246)

at org.hisp.dhis.interceptor.UserSettingInterceptor.intercept(UserSettin

gInterceptor.java:81)

at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI

nvocation.java:246)

at org.hisp.dhis.security.intercept.LoginInterceptor.intercept(LoginInte

rceptor.java:85)

at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI

nvocation.java:246)

at org.hisp.dhis.security.intercept.XWorkSecurityInterceptor.intercept(X

WorkSecurityInterceptor.java:113)

at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI

nvocation.java:246)

at org.hisp.dhis.interceptor.SystemSettingInterceptor.intercept(SystemSe

ttingInterceptor.java:130)

at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI

nvocation.java:246)

at org.hisp.dhis.interceptor.I18nInterceptor.intercept(I18nInterceptor.j

ava:136)

at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI

nvocation.java:246)

at com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept

(ParametersInterceptor.java:254)

at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept

(MethodFilterInterceptor.java:98)

at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI

nvocation.java:246)

at com.opensymphony.xwork2.interceptor.StaticParametersInterceptor.inter

cept(StaticParametersInterceptor.java:191)

at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI

nvocation.java:246)

at org.hisp.dhis.interceptor.ExceptionInterceptor.intercept(ExceptionInt

erceptor.java:110)

at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI

nvocation.java:246)

at org.apache.struts2.impl.StrutsActionProxy.execute(StrutsActionProxy.j

ava:54)

at org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.jav

···

2015-02-26 22:36 GMT-05:00 Morten Olav Hansen mortenoh@gmail.com:

Hi Marko

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

Cordialmente,

Mag. ©. Marko David Garcia M.

Ingeniería Telemática

Universidad del Cauca

Skype: marko_david


Morten

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

Hi Marko,

which version of DHIS 2 is this?

regards,

Lars

Hello Team,

I found the solution just set a default value to true on the active column of the dataelement table. Then i was able to add data elements from version 2.15 to 2.16 and above.

Cheers

···

On Fri, Oct 23, 2015 at 1:38 PM, Mihayo Mathayo princehayo@gmail.com wrote:

Hello Team,
Did anyone found a solution on this bug of not being able to add new data element when upgrading from version 2.15 to either 2.16 or above.

Thanks

On Fri, Feb 27, 2015 at 2: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

Hi

I’m pretty sure that column can be just dropped. You had to update it because you had non-null values, but also try and drop the entire column

···

On Fri, Oct 23, 2015 at 8:23 PM, Mihayo Mathayo princehayo@gmail.com wrote:

Hello Team,

I found the solution just set a default value to true on the active column of the dataelement table. Then i was able to add data elements from version 2.15 to 2.16 and above.

Cheers


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


Morten

On Fri, Oct 23, 2015 at 1:38 PM, Mihayo Mathayo princehayo@gmail.com wrote:

Hello Team,
Did anyone found a solution on this bug of not being able to add new data element when upgrading from version 2.15 to either 2.16 or above.

Thanks

On Fri, Feb 27, 2015 at 2: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