dhis2-devs team mailing list archive

[Robin Martens <martens@xxxxxxx>]

Hi devs,

I would like to ask your attention one more time for 2 bugs (?) as we're now very close to testing and system production:


1.       409 conflict error given in event reports and impossibility to export more than 1 event, probably an error on analytics level (please see below)

2.       In Single event without registration, I have a date data element which is marked as "Allow for future" in the program stage settings but still does not allow future dates. Recreating the data elements or programs does not help. There's no error log. I managed to recreate the bug on the Demo server (program "test", data element "test") with the same results. Is this a bug?

Kind regards,

Robin

From: Robin Martens
Sent: 18 September 2014 13:06
To: 'Abyot Gizaw'
Cc: DHIS 2 Developers list
Subject: RE: [Dhis2-devs] DHIS2 - Event capture error

Hi Abyot,

Analytics has no effect, let me try to give you some more details:


·         Event reports on individual cases work, but when swapping to aggregated cases gives the 409 conflict. The aggregated case table doesn't show.

·         When downloading, only the first entry is in the export file, all others are not.

·         This issue is for each and every program I with single event without registration.

Actually, my program instances were not deleted, I was merely thinking about it. I deleted one duplicate program instance however, and that solved my previous problem. You're probably right that the problems are linked.

This is the query reported by catalina (only INFO, no WARN or ERROR):

* INFO  2014-09-18 12:50:28,945 Time: 6047 micros: Analytics event aggregate SQL: select count(psi) as value,"uidlevel3","yearly","CNsby5YXfwg" from analytics_event_2014_zxpbxmexqlw where Yearly in ('2014') and (uidlevel3 = 'I0VKkMOZxpX' or uidlevel3 = 'glgeSKFNXPa' or uidlevel3 = 'KXilAievUdU' or uidlevel3 = 'z2zryIhRXae' or uidlevel3 = 'D8BN7nadgnq' or uidlevel3 = 'vnSd7A99aQq' or uidlevel3 = 'BOFb4akeNH3' or uidlevel3 = 'ULF8Ho2cfD7' or uidlevel3 = 'B2RgtXQ2qes' or uidlevel3 = 'wzLzzvCxYKi' or uidlevel3 = 'a8E8JE43lO9' or uidlevel3 = 'qXuzuo4CNka' or uidlevel3 = 'Jk5fEbW2MRy' or uidlevel3 = 'rHOAciJo2rS' or uidlevel3 = 'N3WWpd56AF7' or uidlevel3 = 'lp9neuproli' or uidlevel3 = 'kDMzUcY2ZVF' or uidlevel3 = 'k16oIshfkwk' or uidlevel3 = 'UNA6CawrQhK' or uidlevel3 = 'l250JocutpA' or uidlevel3 = 'PByvDxpbibx' or uidlevel3 = 'DgPyE1KSE4N' or uidlevel3 = 'wnSidr8A3Pw' or uidlevel3 = 'XmH5uCIONk4' or uidlevel3 = 'yJbg2GIMdnc' or uidlevel3 = 'bcU1Jq7BOKq' or uidlevel3 = 'CeEl2ug1n6w' or uidlevel3 = 'iq4s71gcYF4' or uidlevel3 = 'SO5Czg58s82' or uidlevel3 = 'L6qT9m4jIOF' ) and ps = 'ZHScYfgW1HR' group by "uidlevel3","yearly","CNsby5YXfwg" limit 1 (Timer.java [http-bio-8080-exec-1])

I also put my program tables in annex.

Regards,

Robin

From: Abyot Gizaw [mailto:abyota@xxxxxxxxx]
Sent: 18 September 2014 12:33
To: Robin Martens
Cc: DHIS 2 Developers list
Subject: Re: [Dhis2-devs] DHIS2 - Event capture error

Hi Robin,

More details would be nice.

Often, the 409 conflict happens when there is a mismatch in identifiers. And I guess this is related to the earlier problem you reported, that all your program instances are deleted. Try to re-run the analytic and see what happens.

---
Thank you,
Abyot.

On Thu, Sep 18, 2014 at 11:50 AM, Robin Martens <martens@xxxxxxx<mailto:martens@xxxxxxx>> wrote:
Hi devs,

Sorry to bother you but it's pretty urgent. Do you have any idea about the error below?

Thanks a lot!

Robin

From: Robin Martens
Sent: 17 September 2014 17:06
To: 'Abyot Gizaw'
Cc: DHIS 2 Developers list
Subject: RE: [Dhis2-devs] DHIS2 - Event capture error

I'm again on the events, reporting here. When generating any random event report previously generated without problems (i.e. before upgrading), it gives the following error in Chrome Console (none in catalina):

GET http://xx.xx.xx.xx:xx/api/analytics/events/aggregate/Rz3Kk3wc7Hr.json?stage=O6kuhQjsj9b&dimension=pe:THIS_YEAR&dimension=AWDGkLx05Wu&filter=ou:l01au4APkBP 409 Conflict

Most tables don't work, and those that do work can only export a single row when downloading (similar error).

The demo apparently doesn't show this issue. Any idea if this is linked to the upgrade? I'm in 16431 now.

Robin

From: Abyot Gizaw [mailto:abyota@xxxxxxxxx]
Sent: 17 September 2014 14:24
To: Robin Martens
Cc: DHIS 2 Developers list
Subject: Re: [Dhis2-devs] DHIS2 - Event capture error

You mean you custom form is not shown? If you are using chrome, do you see any log by pressing F12?


---
Thank you,
Abyot.

On Wed, Sep 17, 2014 at 1:13 PM, Robin Martens <martens@xxxxxxx<mailto:martens@xxxxxxx>> wrote:
To add a point (after checking my other programs for event capture): there is one for which my custom data form is invisible in event capture but still there for editing. It's a different one from the one with the error message below. There's no error log on this one when loading the template.

How can this happen?

Kind regards,

Robin

From: Robin Martens
Sent: 17 September 2014 13:08
To: DHIS 2 Developers list
Subject: DHIS2 - Event capture error

Hi all,

I upgraded this morning to the last version and had the following error message when trying to save a single event without registration:

"No active event exists for single event no registration program xxx, please check and correct your database".

I read in the mailing list this might be linked to program instances. Does it mean I delete all my program instances?

Regards,

Robin



_______________________________________________
Mailing list: https://launchpad.net/~dhis2-devs
Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx<mailto:dhis2-devs@xxxxxxxxxxxxxxxxxxx>
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp