[prev in list] [next in list] [prev in thread] [next in thread]
List: wsf-java-dev
Subject: Re: [Dev] EI_Analytics_StatApp.siddhi error when purging
From: Sajith Dimal <sajithd () wso2 ! com>
Date: 2019-02-11 10:16:32
Message-ID: CACO2=HAVGWh7YxaxDpcXb3tYXw4-NQ4oGMPKw8PaETMWkHtDmw () mail ! gmail ! com
[Download RAW message or body]
[Attachment #2 (multipart/alternative)]
Hi Bernard,
We'll provide official fixes for this issue through the WUM.
The most suggested fix will be updating the query as follows:
select convert(time:dateSub(triggered_time, 2, 'week'), 'long') as
purgingTime
Thanks,
SajithD
On Mon, Feb 11, 2019 at 3:25 PM Bernard Paris <bernard.paris@uclouvain.be>
wrote:
> Ah ok, great.
> As I understand I have to correct the line
> select time:dateSub(triggered_time, 2, 'week') as purgingTime
>
> right ?
> What is the replacement ?
> (sorry I don't know about that)
>
> Many thanks,
> Bernard
>
>
>
> Le 8 févr. 2019 à 13:06, Sajith Dimal <sajithd@wso2.com> a écrit :
>
> Hi Bernard,
>
> We have identified the possible cause for the issue.
> Please track the fixes with the public issue:
> https://github.com/wso2/analytics-solutions/issues/208
>
> Thanks,
> Sajith Dimal
>
> On Thu, Feb 7, 2019 at 11:05 PM Sajith Dimal <sajithd@wso2.com> wrote:
>
>> Hi Bernard,
>>
>> Sorry for the late reply!
>> Could you let us know the Postgres Database version and the connector
>> version?
>>
>> Best Regards,
>> Sajith Dimal
>>
>> On Wed, Feb 6, 2019 at 7:15 PM Bernard Paris <bernard.paris@uclouvain.be>
>> wrote:
>>
>>> Hi team,
>>>
>>> We are running wso2 EI-6.4 package (EI + Analytics worker)
>>>
>>> I get this error, I understand it but really don't know how to solve it
>>> (EI_Analytics_StatApp.siddhi file is just "out of the box"; we use postgres
>>> for datasources)
>>>
>>> Error performing record deletion on table 'ConfigEntryTable': Batch
>>> entry 0 DELETE FROM ConfigEntryTable WHERE (ConfigEntryTable.eventTimestamp
>>> < '1548194400031' ) was aborted: ERROR: operator does not exist: bigint <
>>> character varying
>>> Hint: No operator matches the given name and argument type(s). You
>>> might need to add explicit type casts.
>>>
>>> How could I manage that ?
>>> Thanks a lot,
>>> Bernard
>>>
>>>
>>> _______________________________________________
>>> Dev mailing list
>>> Dev@wso2.org
>>> http://wso2.org/cgi-bin/mailman/listinfo/dev
>>>
>>
>>
>> --
>> <http://wso2.com/signature>
>> Sajith Dimal
>> Senior Software Engineer
>> Email: sajithd@wso2.com
>> Mobile: +94783101496
>> WSO2 Inc. | http://wso2.com
>> lean.enterprise.middleware
>>
>>
>> Disclaimer: This communication may contain privileged or other
>> confidential information and is intended exclusively for the addressee/s.
>> If you are not the intended recipient/s, or believe that you may have
>> received this communication in error, please reply to the sender indicating
>> that fact and delete the copy you received and in addition, you should not
>> print, copy, re-transmit, disseminate, or otherwise use the information
>> contained in this communication. Internet communications cannot be
>> guaranteed to be timely, secure, error or virus-free. The sender does not
>> accept liability for any errors or omissions.
>>
>
>
> --
> <http://wso2.com/signature>
> Sajith Dimal
> Senior Software Engineer
> Email: sajithd@wso2.com
> Mobile: +94783101496
> WSO2 Inc. | http://wso2.com
> lean.enterprise.middleware
>
>
> Disclaimer: This communication may contain privileged or other
> confidential information and is intended exclusively for the addressee/s.
> If you are not the intended recipient/s, or believe that you may have
> received this communication in error, please reply to the sender indicating
> that fact and delete the copy you received and in addition, you should not
> print, copy, re-transmit, disseminate, or otherwise use the information
> contained in this communication. Internet communications cannot be
> guaranteed to be timely, secure, error or virus-free. The sender does not
> accept liability for any errors or omissions.
>
>
>
--
<http://wso2.com/signature>
Sajith Dimal
Senior Software Engineer
Email: sajithd@wso2.com
Mobile: +94783101496
WSO2 Inc. | http://wso2.com
lean.enterprise.middleware
Disclaimer: This communication may contain privileged or other confidential
information and is intended exclusively for the addressee/s. If you are not
the intended recipient/s, or believe that you may have received this
communication in error, please reply to the sender indicating that fact and
delete the copy you received and in addition, you should not print, copy,
re-transmit, disseminate, or otherwise use the information contained in
this communication. Internet communications cannot be guaranteed to be
timely, secure, error or virus-free. The sender does not accept liability
for any errors or omissions.
[Attachment #5 (text/html)]
<div dir="ltr">Hi Bernard,<div><br></div><div>We'll provide official fixes for \
this issue through the WUM.</div><div>The most suggested fix will be updating the \
query as follows:<br><br><div>select convert(time:dateSub(triggered_time, 2, \
'week'), 'long') as purgingTime<br><br>Thanks,<br>SajithD</div><br \
class="gmail-Apple-interchange-newline"></div></div><br><div class="gmail_quote"><div \
dir="ltr" class="gmail_attr">On Mon, Feb 11, 2019 at 3:25 PM Bernard Paris <<a \
href="mailto:bernard.paris@uclouvain.be">bernard.paris@uclouvain.be</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 style="overflow-wrap: break-word;">
Ah ok, great.
<div>As I understand I have to correct the line</div>
<div>select time:dateSub(triggered_time, 2, 'week') as purgingTime</div>
<div><br>
</div>
<div>right ?</div>
<div>What is the replacement ?</div>
<div>(sorry I don't know about that)</div>
<div><br>
</div>
<div>Many thanks,</div>
<div>Bernard</div>
<div><br>
</div>
<div><br>
</div>
<div>
<div><br>
<blockquote type="cite">
<div>Le 8 févr. 2019 à 13:06, Sajith Dimal <<a href="mailto:sajithd@wso2.com" \
target="_blank">sajithd@wso2.com</a>> a écrit :</div> <br \
class="gmail-m_9019887037516239368Apple-interchange-newline"> <div>
<div dir="ltr">
<div dir="ltr">Hi Bernard,
<div><br>
</div>
<div>We have identified the possible cause for the issue.</div>
<div>Please track the fixes with the public issue: <a \
href="https://github.com/wso2/analytics-solutions/issues/208" \
target="_blank">https://github.com/wso2/analytics-solutions/issues/208</a></div> \
<div><br> </div>
<div>Thanks,</div>
<div>Sajith Dimal</div>
</div>
</div>
<br>
<div class="gmail_quote">
<div dir="ltr" class="gmail_attr">On Thu, Feb 7, 2019 at 11:05 PM Sajith Dimal <<a \
href="mailto:sajithd@wso2.com" target="_blank">sajithd@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 \
Bernard, <div><br>
</div>
<div>Sorry for the late reply!</div>
<div>Could you let us know the Postgres Database version and the connector \
version?</div> <div><br>
</div>
<div>Best Regards,</div>
<div>Sajith Dimal</div>
</div>
<br>
<div class="gmail_quote">
<div dir="ltr" class="gmail_attr">On Wed, Feb 6, 2019 at 7:15 PM Bernard Paris <<a \
href="mailto:bernard.paris@uclouvain.be" \
target="_blank">bernard.paris@uclouvain.be</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"> Hi team,<br>
<br>
We are running wso2 EI-6.4 package (EI + Analytics worker)<br>
<br>
I get this error, I understand it but really don't know how to solve it \
(EI_Analytics_StatApp.siddhi file is just "out of the box"; we use postgres \
for datasources)<br> <br>
Error performing record deletion on table 'ConfigEntryTable': Batch entry 0 \
DELETE FROM ConfigEntryTable WHERE (ConfigEntryTable.eventTimestamp < \
'1548194400031' ) was aborted: ERROR: operator does not exist: bigint < \
character varying<br> Hint: No operator matches the given name and argument type(s). \
You might need to add explicit type casts.<br> <br>
How could I manage that ?<br>
Thanks a lot,<br>
Bernard<br>
<br>
<br>
_______________________________________________<br>
Dev mailing list<br>
<a href="mailto:Dev@wso2.org" target="_blank">Dev@wso2.org</a><br>
<a href="http://wso2.org/cgi-bin/mailman/listinfo/dev" rel="noreferrer" \
target="_blank">http://wso2.org/cgi-bin/mailman/listinfo/dev</a><br> </blockquote>
</div>
<br clear="all">
<div><br>
</div>
-- <br>
<div dir="ltr" class="gmail-m_9019887037516239368gmail-m_6743006619875024476gmail_signature">
<div dir="ltr">
<div>
<div dir="ltr">
<div>
<div dir="ltr">
<div>
<div dir="ltr">
<div>
<div dir="ltr">
<div>
<div dir="ltr">
<div dir="ltr"><font color="#888888">
<div dir="ltr"><span><font color="#888888"><a href="http://wso2.com/signature" \
target="_blank"><img \
src="http://c.content.wso2.com/signatures/wso2-signature-general.png" width="200" \
height="45"></a></font></span></div> <div dir="ltr"><span><font \
color="#888888">Sajith Dimal<br> Senior Software Engineer<br>
</font></span></div>
<div dir="ltr"><span style="font-size:12.8px">Email: <a \
href="mailto:sajithd@wso2.com" target="_blank"> sajithd@wso2.com</a></span><font \
color="#888888"><br> </font></div>
<div><span><font color="#888888">Mobile: +94<font \
color="#888888">783101496</font></font></span></div> <div dir="ltr"><span><font \
color="#888888">WSO2 Inc. | <a href="http://wso2.com/" \
target="_blank">http://wso2.com</a><br> lean.enterprise.middleware</font></span><br>
</div>
<div dir="ltr"><span><font color="#888888"><br>
</font></span></div>
<div dir="ltr"><br>
<span style="font-family:tahoma,sans-serif;font-size:12.8px">Disclaimer: This \
communication may contain privileged or other confidential information and is \
intended exclusively for the addressee/s. If you are not the intended recipient/s, or \
believe that you may have received this communication in error, please reply to the \
sender indicating that fact and delete the copy you received and in addition, you \
should not print, copy, re-transmit, disseminate, or otherwise use the information \
contained in this communication. Internet communications cannot be guaranteed to be \
timely, secure, error or virus-free. The sender does not accept liability for any \
errors or omissions.</span><span><font color="#888888"><br> </font></span></div>
</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" class="gmail-m_9019887037516239368gmail_signature">
<div dir="ltr">
<div>
<div dir="ltr">
<div>
<div dir="ltr">
<div>
<div dir="ltr">
<div>
<div dir="ltr">
<div>
<div dir="ltr">
<div dir="ltr"><font color="#888888">
<div dir="ltr"><span><font color="#888888"><a href="http://wso2.com/signature" \
target="_blank"><img \
src="http://c.content.wso2.com/signatures/wso2-signature-general.png" width="200" \
height="45"></a></font></span></div> <div dir="ltr"><span><font \
color="#888888">Sajith Dimal<br> Senior Software Engineer<br>
</font></span></div>
<div dir="ltr"><span style="font-size:12.8px">Email: <a \
href="mailto:sajithd@wso2.com" target="_blank"> sajithd@wso2.com</a></span><font \
color="#888888"><br> </font></div>
<div><span><font color="#888888">Mobile: +94<font \
color="#888888">783101496</font></font></span></div> <div dir="ltr"><span><font \
color="#888888">WSO2 Inc. | <a href="http://wso2.com/" \
target="_blank">http://wso2.com</a><br> lean.enterprise.middleware</font></span><br>
</div>
<div dir="ltr"><span><font color="#888888"><br>
</font></span></div>
<div dir="ltr"><br>
<span style="font-family:tahoma,sans-serif;font-size:12.8px">Disclaimer: This \
communication may contain privileged or other confidential information and is \
intended exclusively for the addressee/s. If you are not the intended recipient/s, or \
believe that you may have received this communication in error, please reply to the \
sender indicating that fact and delete the copy you received and in addition, you \
should not print, copy, re-transmit, disseminate, or otherwise use the information \
contained in this communication. Internet communications cannot be guaranteed to be \
timely, secure, error or virus-free. The sender does not accept liability for any \
errors or omissions.</span><span><font color="#888888"><br> </font></span></div>
</font></div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</blockquote>
</div>
<br>
</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><div \
dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div \
dir="ltr"><font color="#888888"><div dir="ltr"><span><font color="#888888"><a \
href="http://wso2.com/signature" target="_blank"><img \
src="http://c.content.wso2.com/signatures/wso2-signature-general.png" width="200" \
height="45"></a></font></span></div><div dir="ltr"><span><font color="#888888">Sajith \
Dimal<br>Senior Software Engineer<br></font></span></div><div dir="ltr"><span \
style="font-size:12.8px">Email: <a href="mailto:sajithd@wso2.com" \
target="_blank">sajithd@wso2.com</a></span><font \
color="#888888"><br></font></div><div><span><font color="#888888">Mobile: +94<font \
color="#888888">783101496</font></font></span></div><div dir="ltr"><span><font \
color="#888888">WSO2 Inc. | <a href="http://wso2.com" \
target="_blank">http://wso2.com</a><br>lean.enterprise.middleware</font></span><br></div><div \
dir="ltr"><span><font color="#888888"><br></font></span></div><div \
dir="ltr"><br><span style="font-family:tahoma,sans-serif;font-size:12.8px">Disclaimer: \
This communication may contain privileged or other confidential information and is \
intended exclusively for the addressee/s. If you are not the intended recipient/s, or \
believe that you may have received this communication in error, please reply to the \
sender indicating that fact and delete the copy you received and in addition, you \
should not print, copy, re-transmit, disseminate, or otherwise use the information \
contained in this communication. Internet communications cannot be guaranteed to be \
timely, secure, error or virus-free. The sender does not accept liability for any \
errors or omissions.</span><span><font \
color="#888888"><br></font></span></div></font></div></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