dhis2-users team mailing list archive

[Lars Helge Øverland <larshelge@xxxxxxxxx>]

Hi Jose,

you likely have an SQL view in your database which depends on the
_orgunitstructure resource table which DHIS 2 needs to drop during
re-generation. Please remove that SQL view and rather create it through
DHIS 2 under data administration > SQL views - the system will then take
care of dropping and recreating at appropriate times.

regards,

Lars


--

não pode remover tabela _orgunitstructure porque outros objetos dependem
dele


On Fri, Jun 6, 2014 at 2:40 PM, José Berilo Lima <jberilo@xxxxxxxxx> wrote:

>
>
> Hi Ola and All
>
> I've tried to do manually but the "Analytics" is running forever.
> Apparently he gets caught. The file "erro1" contains the log before
> entering the system. The file "erro2" contains the log after trying to generate
> the "Analytics".
>
> Could you help me?
>
> Sorry but the system is not translating into English the screen.
>
>
> Thanks.
>
>
>
>
> 2014-05-26 8:18 GMT-03:00 Ola Hodne Titlestad <olati@xxxxxxxxxx>:
>
>> Hi José,
>>
>> As you pointed out the missing data for January in your pivot table is
>> most likely caused by a problem with the analytics tables generation.
>>
>> In order to find out what went wrong with the analytics process we need
>> to see your tomcat log.
>>
>> The current analytics tables are only replaced when a new analytics
>> export process has completed successfully, and if it fails the tables
>> remain as before.
>> So that is likely why you can still see older data in your pivots, but
>> not the new January data (you write that analytics process runs
>> indefinitely).
>>
>> Can you try to run analytics (manually from UI) one more time and then
>> monitor your tomcat log at the same time, and possibly share the relevant
>> part of the log with us?
>>
>> Thanks.
>>
>> Ola
>> -------
>>
>>
>> ----------------------------------
>> Ola Hodne Titlestad (Mr)
>> HISP
>> Department of Informatics
>> University of Oslo
>>
>> Mobile: +47 48069736
>> Home address: Eftasåsen 68, 0687 Oslo, Norway. Googlemaps link
>> <https://maps.google.com/maps?q=Eftas%C3%A5sen+68,+0687+Oslo,+Norge&hl=en&ie=UTF8&sll=59.893855,10.785116&sspn=0.222842,0.585709&oq=eftas%C3%A5sen+68,+0687+Oslo,+&t=h&hnear=Eftas%C3%A5sen+68,+%C3%98stensj%C3%B8,+0687+Oslo,+Norway&z=16>
>>
>>
>> On 22 May 2014 18:32, José Berilo <jberilo@xxxxxxxxxxxxx> wrote:
>>
>>> Hi All,
>>>
>>> I have the following problem:
>>>
>>>   Data entered in the data entry module does not appear in the pivot
>>> table as a sequence of screens figure 1, Figure 2 and figure 3. Follow the
>>> example in the screenshot below with data entered in a unit
>>> hierarchically linked to Prog Maranhão in January 2014. Pivot Table data that
>>> month is not displayed. Have tried to update the analytical tables but did
>>> not work. Is running indefinitely.
>>>
>>> Can someone help?
>>>
>>> Thank you.
>>>
>>> --
>>> ____________________________
>>> José Berilo
>>> Estatístico
>>> DEAVE - BEMFAM
>>> jberilo@xxxxxxxxxxxxx
>>> Tel. 21 30052412
>>>
>>>
>>>
>>
>
>
> _______________________________________________
> 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
>
>