I would like to ask your attention one more time for 2 bugs (?) as we’re now very close to testing and system production:
···
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@gmail.com]
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@sher.be 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@gmail.com]
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@sher.be > 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@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp
