← Back to team overview

dhis2-users team mailing list archive

Re: problem with to upgrade from Dhis 2.10 to 2.11

 

Well, then I only should run  analytics tables.
I could to solve the problem (
https://lists.launchpad.net/dhis2-users/msg02671.html), But now I have one
doubt. If not necessary to run datamart then why it appears even?, when
should I run datamart? and why analytics tables and  datamart  has been
separated.

Thanks.





2013/7/24 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
>>
>>
>>
>


-- 
__________________________
@Heldersoft

Follow ups

References