Re: [Dhis2-devs] [Dhis2-users] new tutorial: analysing postgresql logs using pgbadger

2015-05-26 Thread Edward Ari Bichetero
Ah, thanks for this. Was previously using pgFouine but it began to break down processing increasingly larger logs. I had considered migration to pgbadger but had not had the time to look at it properly. This will save us a lot of work. - Edward - On Saturday, May 2, 2015 11:59 AM, Lars Helge Ø

[Dhis2-devs] [Bug 1191698] [NEW] Analytics creation causes SQL syntax error

2013-06-17 Thread Edward Ari Bichetero
Public bug reported: The analytics tables use DHIS2 UIDs as fieldnames in a number of tables. However the rules for a table column's name are restricted by the rules for any identifiers in the SQL language. Namely: - Identifiers and key words must begin with a letter or an underscore. Subseque

[Dhis2-devs] [Bug 1191698] Re: Analytics creation causes SQL syntax error

2013-06-17 Thread Edward Ari Bichetero
Hi Lars, Do you mean that the new code releaseses will always generate UIDs that start with alphabetic characters ? If so, does it correctly upgrade the "hibernate_sequence" that exists in the database ? I assume that is what is used to derive UIDs. And what happens to existing UIDs that start

[Dhis2-devs] [Bug 1191698] Re: Analytics creation causes SQL syntax error

2013-06-17 Thread Edward Ari Bichetero
I beg to differ. If you look at the revision history for "CodeGenerator.java" you will see that the change to make UIDs start with a English alphabet character was made at the end of 2011 (Rev: 5104 on 2011-11-03 by Bob Jolliffe). I haven't tried to track down which was the first release that had t

[Dhis2-devs] [Bug 1191698] Re: Analytics creation causes SQL syntax error

2013-06-17 Thread Edward Ari Bichetero
A quick look shows we have about 1000 orgunits and 150 dataelements with this problem (I've only checked orgunits, dataelements and datasets). The proper fix would be to wait until there was a new release (or WAR drop) with a "UIDTableAlteror.java" or "UIDUpgrader.java" that converted the UIDs prop

[Dhis2-devs] [Merge] lp:~ebichete/dhis2/dhis2 into lp:dhis2

2013-08-29 Thread Edward Ari Bichetero
Edward Ari Bichetero has proposed merging lp:~ebichete/dhis2/dhis2 into lp:dhis2. Requested reviews: DHIS 2 core developers (dhis2-devs-core) For more details, see: https://code.launchpad.net/~ebichete/dhis2/dhis2/+merge/182887 The aggregation code was checking the wrong collection of

Re: [Dhis2-devs] [Dhis2-users] data mart deprecation - 2.21

2015-08-27 Thread Edward Ari Bichetero
That seems a little extreme, but whatever works. Desperate times call for desperate measures. - Edward - On Thursday, August 27, 2015 9:53 AM, Calle Hedberg wrote: Paralytics?? On 27 August 2015 at 09:35, Hannan Khan wrote: In Bangladesh we are not using Data Mart; instead we

[Dhis2-devs] [Bug 1191698] Re: Analytics creation causes SQL syntax error

2014-01-30 Thread Edward Ari Bichetero
Looks like the quoting solution was implemented in rev.13039, so marking as fixed. - Edward - ** Changed in: dhis2 Assignee: (unassigned) => Lars Helge Øverland (larshelge) ** Changed in: dhis2 Status: New => Fix Released -- You received this bug notification because you are a mem