[prev in list] [next in list] [prev in thread] [next in thread]
List: wsf-c-dev
Subject: Re: [Dev] Aggregation timezone not work with dashbord profile.
From: Rukshan Premathunga <rukshan () wso2 ! com>
Date: 2020-07-13 4:55:54
Message-ID: CAAQqULUG=2QN7jYmgRdwu9qmSXLg-2Bm=wM+R9bkkEhArWp9Eg () mail ! gmail ! com
[Download RAW message or body]
[Attachment #2 (multipart/alternative)]
On Mon, Jul 13, 2020 at 10:09 AM Damith Wickramasinghe <damithn@wso2.com>
wrote:
> Hi Rukshan,
>
> What is the product version you are using ?
>
This APIM analytics 3.2.0 snapshot version.
siddhi.version = 5.1.14
carbon.analytics.version = 3.0.38
>
> Regards,
> Damith
>
> On Mon, Jul 13, 2020 at 10:04 AM Rukshan Premathunga <rukshan@wso2.com>
> wrote:
>
>> Hi All,
>>
>> Any update on this?
>>
>> Thanks and Regards
>>
>> On Fri, Jul 10, 2020 at 5:02 PM Rukshan Premathunga <rukshan@wso2.com>
>> wrote:
>>
>>> Hi All,
>>>
>>> We had an issue with dashboards widgets in past releases, it uses the
>>> GMT timezone to calculate siddhi windows. I found this fixed[1] but looks
>>> like it working for the worker if we use rest API. But in the dashboard
>>> runtime when widgets are loading using WS calls, it still returns time in
>>> GMT timezone.
>>>
>>> I have added the following config in both runtimes.
>>> properties:
>>> aggTimeZone: Asia/Colombo
>>>
>>> here an example:
>>>
>>> *query*: from ApiErrorAnalysisAgg within 0L, 1694194742000L per
>>> \"days\" select AGG_TIMESTAMP group by AGG_TIMESTAMP
>>>
>>> *Worker rest API:*
>>> Long value of AGG_TIMESTAMP: 1594233000000
>>> GMT: Wednesday, July 8, 2020 6:30:00 PM
>>> Your time zone: Thursday, July 9, 2020 12:00:00 AM (expected behaviour)
>>>
>>> *Dashboard response is taken in the network tab*
>>> Long value of AGG_TIMESTAMP: 1594166400000
>>> GMT: Wednesday, July 8, 2020 12:00:00 AM
>>> Your time zone: Wednesday, July 8, 2020 5:30:00 AM
>>>
>>> At this time when I check the DB in the day's table, it is persisted
>>> correctly as '1594233000000'. So what could be the reason for this?
>>>
>>>
>>> [1] https://github.com/siddhi-io/siddhi/pull/1637
>>>
>>> --
>>> Rukshan C. Premathunga | Associate Technical Lead | WSO2 Inc.
>>> (m) +94711822074 | (w) +94112145345 | Email: rukshan@wso2.com
>>> GET INTEGRATION AGILE
>>> Integration Agility for Digitally Driven Business
>>>
>>
>>
>> --
>> Rukshan C. Premathunga | Associate Technical Lead | WSO2 Inc.
>> (m) +94711822074 | (w) +94112145345 | Email: rukshan@wso2.com
>> GET INTEGRATION AGILE
>> Integration Agility for Digitally Driven Business
>>
>
>
> --
> Associate Technical Lead | WSO2 Inc.
> lean.enterprise.middleware
>
> mobile: *+94728671315*
>
>
--
Rukshan C. Premathunga | Associate Technical Lead | WSO2 Inc.
(m) +94711822074 | (w) +94112145345 | Email: rukshan@wso2.com
GET INTEGRATION AGILE
Integration Agility for Digitally Driven Business
[Attachment #5 (text/html)]
<div dir="ltr"><div dir="ltr"><br></div><br><div class="gmail_quote"><div dir="ltr" \
class="gmail_attr">On Mon, Jul 13, 2020 at 10:09 AM Damith Wickramasinghe <<a \
href="mailto:damithn@wso2.com">damithn@wso2.com</a>> wrote:<br></div><blockquote \
class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid \
rgb(204,204,204);padding-left:1ex"><div dir="ltr"><div>Hi \
Rukshan,</div><div><br></div><div>What is the product version you are using \
?</div></div></blockquote><div>This APIM analytics 3.2.0 snapshot \
version.</div><div><br></div><div>siddhi.version = 5.1.14<br>carbon.analytics.version \
= 3.0.38</div><blockquote class="gmail_quote" style="margin:0px 0px 0px \
0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div \
dir="ltr"><div><br></div><div>Regards,</div><div>Damith<br></div></div><br><div \
class="gmail_quote"><div dir="ltr" class="gmail_attr">On Mon, Jul 13, 2020 at 10:04 \
AM Rukshan Premathunga <<a href="mailto:rukshan@wso2.com" \
target="_blank">rukshan@wso2.com</a>> wrote:<br></div><blockquote \
class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid \
rgb(204,204,204);padding-left:1ex"><div dir="ltr">Hi All,<div><br></div><div>Any \
update on this?</div><div><br></div><div>Thanks and Regards</div></div><br><div \
class="gmail_quote"><div dir="ltr" class="gmail_attr">On Fri, Jul 10, 2020 at 5:02 PM \
Rukshan Premathunga <<a href="mailto:rukshan@wso2.com" \
target="_blank">rukshan@wso2.com</a>> wrote:<br></div><blockquote \
class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid \
rgb(204,204,204);padding-left:1ex"><div dir="ltr">Hi All,<div><br></div><div>We had \
an issue with dashboards widgets in past releases, it uses the GMT timezone to \
calculate siddhi windows. I found this fixed[1] but looks like it working for the \
worker if we use rest API. But in the dashboard runtime when widgets are loading \
using WS calls, it still returns time in GMT timezone. </div><div><br></div><div>I \
have added the following config in both runtimes.</div><div>properties:<br> \
aggTimeZone: Asia/Colombo<br></div><div><br></div><div>here an \
example:</div><div><br></div><div><b>query</b>: from ApiErrorAnalysisAgg within 0L, \
1694194742000L per \"days\" select AGG_TIMESTAMP group by \
AGG_TIMESTAMP</div><div><br></div><div><div><b>Worker rest API:</b></div>Long value \
of AGG_TIMESTAMP: 1594233000000<div></div></div><div>GMT: Wednesday, July 8, 2020 \
6:30:00 PM<br>Your time zone: Thursday, July 9, 2020 12:00:00 AM (expected \
behaviour)<br></div><div><br></div><div><b>Dashboard response is taken in the network \
tab</b></div><div><div>Long value of AGG_TIMESTAMP: \
1594166400000<div></div></div><div>GMT: Wednesday, July 8, 2020 12:00:00 AM<br>Your \
time zone: Wednesday, July 8, 2020 5:30:00 AM<br></div></div><div><br></div><div>At \
this time when I check the DB in the day's table, it is persisted correctly as \
'1594233000000'. So what could be the reason for \
this?</div><div><br></div><div><br></div><div>[1] <a \
href="https://github.com/siddhi-io/siddhi/pull/1637" \
target="_blank">https://github.com/siddhi-io/siddhi/pull/1637</a><br \
clear="all"><div><br></div>-- <br><div dir="ltr"><div dir="ltr"><div><div \
dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div \
style="color:rgb(136,136,136)"><div dir="ltr">Rukshan C. Premathunga | Associate \
Technical Lead | WSO2 Inc.<br></div></div><div dir="ltr" \
style="color:rgb(136,136,136)"><div>(m) +94711822074 | (w) +94112145345 | Email: <a \
href="mailto:rukshan@wso2.com" style="color:rgb(17,85,204)" \
target="_blank">rukshan@wso2.com</a></div><div><div><font color="#999999">GET \
INTEGRATION AGILE</font></div><div><font color="#999999">Integration Agility for \
Digitally Driven Business</font></div></div></div></div></div></div></div></div></div></div></div></div></div>
</blockquote></div><br clear="all"><div><br></div>-- <br><div dir="ltr"><div \
dir="ltr"><div><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div \
dir="ltr"><div style="color:rgb(136,136,136)"><div dir="ltr">Rukshan C. Premathunga | \
Associate Technical Lead | WSO2 Inc.<br></div></div><div dir="ltr" \
style="color:rgb(136,136,136)"><div>(m) +94711822074 | (w) +94112145345 | Email: <a \
href="mailto:rukshan@wso2.com" style="color:rgb(17,85,204)" \
target="_blank">rukshan@wso2.com</a></div><div><div><font color="#999999">GET \
INTEGRATION AGILE</font></div><div><font color="#999999">Integration Agility for \
Digitally Driven Business</font></div></div></div></div></div></div></div></div></div></div></div>
</blockquote></div><br clear="all"><br>-- <br><div dir="ltr"><div \
dir="ltr"><div><div dir="ltr"><div><div dir="ltr">Associate Technical Lead |<b> \
</b>WSO2 Inc.<br> lean.enterprise.middleware<br><br>mobile: \
<u>+94728671315</u><br><br></div></div></div></div></div></div> \
</blockquote></div><br clear="all"><div><br></div>-- <br><div dir="ltr" \
class="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div dir="ltr"><div \
dir="ltr"><div dir="ltr"><div dir="ltr"><div style="color:rgb(136,136,136)"><div \
dir="ltr">Rukshan C. Premathunga | Associate Technical Lead | WSO2 \
Inc.<br></div></div><div dir="ltr" style="color:rgb(136,136,136)"><div>(m) \
+94711822074 | (w) +94112145345 | Email: <a href="mailto:rukshan@wso2.com" \
style="color:rgb(17,85,204)" \
target="_blank">rukshan@wso2.com</a></div><div><div><font color="#999999">GET \
INTEGRATION AGILE</font></div><div><font color="#999999">Integration Agility for \
Digitally Driven Business</font></div></div></div></div></div></div></div></div></div></div></div></div>
_______________________________________________
Dev mailing list
Dev@wso2.org
http://wso2.org/cgi-bin/mailman/listinfo/dev
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic