dhis2-users team mailing list archive

[Lars Helge Øverland <larshelge@xxxxxxxxx>]

Hello Helder,

in version 2.12 there is no need to run data mart anymore.

Instead you should run the analytics tables. You can do this ad-hoc from
the reports module, and schedule it to run automatically at night from data
administration module -> scheduling. Make sure you have full rights (ALL).

The difference between the data mart and the analytics tables is that the
former is a pre-aggregated data table while the latter are denormalized
data tables which are used as basis for on-the-fly aggregation.

Lars



On Wed, Jul 24, 2013 at 1:00 AM, Helder Yesid Castrillon Cobo <
heldersoft@xxxxxxxxx> wrote:

> Hi,
>
> We have upgraded from dhis 2.10 to 2.11 and 2.12, the problem was caused
> by a duplicate key error, which we solved with help of Knut ( to see
> https://lists.launchpad.net/dhis2-users/msg02468.html).
>
> Now we have another problem in version 2.12, after that we upgrade does
> not show all information in SIG and data visualizer, even so to try again
> after exporting to datamart.
>
> this problem we will report in another post, more detailed.
>
> regards.
>
> Helder and Marko.
> Secretaria departamental de salud del cauca.
> Colombia.
>
> * <https://lists.launchpad.net/dhis2-users/msg02468.html>*
>
>
> 2013/6/19 Lars Helge Øverland <larshelge@xxxxxxxxx>
>
>> Hello Helder,
>>
>> can you please check in your hibernate.properties file that this line is
>> present without any blank spaces at the end?
>>
>> hibernate.hbm2ddl.auto = update
>>
>> Also, can you please provide us with some more information, like
>>
>> - what you are doing when this error happens
>> - output of your tomcat log
>> - http://www.dhis2.org/doc/snapshot/en/implementer/html/ch09s03.html
>>
>> Also, can you check that your database user has permissions to create
>> tables in your database? Just make your database user a superuser for
>> debugging porposes and try again.
>>
>> regards,
>>
>> Lars
>>
>>
>> On Wed, Jun 19, 2013 at 12:23 AM, Helder Yesid Castrillon Cobo <
>> heldersoft@xxxxxxxxx> wrote:
>>
>>> Hi,
>>>
>>> We upgrade from Dhis 2.10 to the version 2.11, but to sign in displays
>>> an error that can not continue, in a second attempt display other error
>>> related with a column organisati1_.uuid.
>>>
>>> I should clarify that my partner marko previously reported the drawbacks
>>> to upgrade from version 2.10 to 2.12 and he was recommended upgrade to
>>> version 2.11 first.
>>>
>>> attached  screen print.
>>>
>>> Helder Castrillon
>>> Secretaria Departamental de Salud del Cauca
>>> Colombia.
>>>
>>>
>>> --
>>> __________________________
>>> @Heldersoft
>>>
>>>
>>>
>>> _______________________________________________
>>> Mailing list: https://launchpad.net/~dhis2-users
>>> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>> More help   : https://help.launchpad.net/ListHelp
>>>
>>>
>>
>
>
> --
> __________________________
> @Heldersoft
>
>
>