← Back to team overview

dhis2-devs team mailing list archive

Re: Executing [Schedule automated aggregation] only working for [Last month]

 

Hi Devs/Tran

I stumbled across this page somehow but I cannot locate an object with uid
value "WFQCq1dDkd1". How do I dig in further?

[image: Inline image 1]

On Sun, Mar 1, 2015 at 8:09 PM, Greg Rowles <greg.rowles@xxxxxxxxx> wrote:

> Hi Devs/Tran
>
> Does any of the following make sense to you? Aggregations still fail but I
> have better error info:
>
> [image: Inline image 1]
>
> FYI - I cannot locate the Aggregation Query Builder "J16EIqxFAau". It's
> not in the current list (I check each one's details and none have that
> id). Here is a different screenshot (each aggregate_query_builder error
> references the same "J16EIqxFAau" id:
>
> [image: Inline image 2]
>
> Any suggestions?
>
> Regards,
> Greg
>
>
> On Fri, Feb 27, 2015 at 3:28 PM, Greg Rowles <greg.rowles@xxxxxxxxx>
> wrote:
>
>> Thank you Tran
>>
>> We'll start testing ASAP... when we figure it out - we'll explain...
>>
>> Best,
>> Greg
>>
>>
>> On Fri, Feb 27, 2015 at 1:35 PM, Tran Chau (HISP Vietnam) <
>> tran.hispvietnam@xxxxxxxxx> wrote:
>>
>>> Thank Greg,
>>>
>>> I tried creating a formula as your simple formula and chose the Task
>>> strategy as 6 months, the data is generated and saved ok for 6 months in my
>>> side. Please see the attachment snapshots.
>>> I guess maybe data in your database got some issues.
>>>
>>> Besides, when Task strategy is changedd from  "12 months" to "6
>>> months", we have to click *Stop *button and *Start *button before
>>> clicking on *Execute *button. If not, the system will run with the old Task
>>> strategy which we did set when we start *Schedule automated aggregation*
>>> before.
>>>
>>> .................................
>>> Best regards,
>>> Tran Chau
>>>
>>>
>>> On Thu, Feb 26, 2015 at 10:31 PM, Greg Rowles <greg.rowles@xxxxxxxxx>
>>> wrote:
>>>
>>>> Hi Tran
>>>>
>>>> The schedule was changed from "12 months" to "6 months" but we are
>>>> testing aggregation outcomes using the "Execute" command (most of the time
>>>> it just hangs with "504 (Gateway Time-out)" and we also noticed the same
>>>> for "Manual Aggregation", preview & save options). Our basic formulas use
>>>> [Visited selected program stage] criteria while we have a set using more
>>>> complex DateDiff() formulas. We know we have tracker data starting in
>>>> Aug-2014 up till a few minutes ago:
>>>>
>>>> [image: Inline image 1]
>>>>
>>>>
>>>> Complex Query:
>>>>
>>>> [image: Inline image 2]
>>>>
>>>> Basic Query:
>>>>
>>>> [image: Inline image 3]
>>>>
>>>>
>>>> I hope this is what you were asking for...?
>>>>
>>>> Best,
>>>> Greg
>>>>
>>>>
>>>> On Thu, Feb 26, 2015 at 3:05 PM, Tran Chau (HISP Vietnam) <
>>>> tran.hispvietnam@xxxxxxxxx> wrote:
>>>>
>>>>> Hi Greg,
>>>>>
>>>>> Can you give me more information about snapshots, your formulas, your
>>>>> event cases, what the *Task strategy* is selected in *Schedule
>>>>> automated aggregation* .... ?
>>>>>
>>>>> ..................................
>>>>> Best regards,
>>>>> Tran Chau
>>>>>
>>>>>
>>>>>
>>>>> On Thu, Feb 26, 2015 at 5:26 AM, Greg Rowles <greg.rowles@xxxxxxxxx>
>>>>> wrote:
>>>>>
>>>>>> Hi Devs
>>>>>>
>>>>>> We've noticed our Aggregation-Queries are only loading values for the
>>>>>> last month regardless of the selected time frame.
>>>>>>
>>>>>> Is there a known bug or known cause for this problem? Perhaps its a
>>>>>> data-quality issue (we're still refining our data quality kinks, i.e. there
>>>>>> may be programstageinstance.executiondate dates that violate expected
>>>>>> values, e.g. date value "0013-02-13" and "0022-02-06" is present).
>>>>>> Is this the likely cause? We cannot aggregate data before 24 Jan 2015...
>>>>>>
>>>>>> Greg
>>>>>>
>>>>>> --
>>>>>> *Health Information Systems Program - South Africa*
>>>>>> *- - - - - - - **- - - - - - - **- - - - - - - **- - - - - - - **- -
>>>>>> - - - *
>>>>>> Mobile  :    073 246 2992
>>>>>> Landline:   021 554 3130
>>>>>> Fax:          086 733 8432
>>>>>> Skype:      gregory_rowles
>>>>>>
>>>>>> _______________________________________________
>>>>>> Mailing list: https://launchpad.net/~dhis2-devs
>>>>>> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
>>>>>> Unsubscribe : https://launchpad.net/~dhis2-devs
>>>>>> More help   : https://help.launchpad.net/ListHelp
>>>>>>
>>>>>>
>>>>>
>>>>
>>>>
>>>> --
>>>> *Health Information Systems Program - South Africa*
>>>> *- - - - - - - **- - - - - - - **- - - - - - - **- - - - - - - **- - -
>>>> - - *
>>>> Mobile  :    073 246 2992
>>>> Landline:   021 554 3130
>>>> Fax:          086 733 8432
>>>> Skype:      gregory_rowles
>>>>
>>>
>>>
>>
>>
>> --
>> *Health Information Systems Program - South Africa*
>> *- - - - - - - **- - - - - - - **- - - - - - - **- - - - - - - **- - - -
>> - *
>> Mobile  :    073 246 2992
>> Landline:   021 554 3130
>> Fax:          086 733 8432
>> Skype:      gregory_rowles
>>
>
>
>
> --
> *Health Information Systems Program - South Africa*
> *- - - - - - - **- - - - - - - **- - - - - - - **- - - - - - - **- - - -
> - *
> Mobile  :    073 246 2992
> Landline:   021 554 3130
> Fax:          086 733 8432
> Skype:      gregory_rowles
>



-- 
*Health Information Systems Program - South Africa*
*- - - - - - - **- - - - - - - **- - - - - - - **- - - - - - - **- - - - - *
Mobile  :    073 246 2992
Landline:   021 554 3130
Fax:          086 733 8432
Skype:      gregory_rowles

PNG image

PNG image

PNG image

PNG image

PNG image

PNG image


Follow ups

References