Re: [Dev] EI_Analytics_StatApp.siddhi error when purging
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 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 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 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 >> 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: saji...@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: saji...@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: saji...@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. ___ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev
Re: [Dev] EI_Analytics_StatApp.siddhi error when purging
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 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 > 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: saji...@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: saji...@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. ___ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev
Re: [Dev] EI_Analytics_StatApp.siddhi error when purging
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 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: saji...@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. ___ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev
Re: [Dev] WSO2 Committers += Fazlan Nazeem
Congratulations Fazlan!!! :) On Tue, Jan 12, 2016 at 9:10 PM, Menaka Jayawardena <men...@wso2.com> wrote: > Congratulations Fazlan. > > On Tue, Jan 12, 2016 at 8:59 PM, NIFRAS ISMAIL <nifrasism...@gmail.com> > wrote: > >> Great Keep up Fazlan! >> >> Regards. >> *M. Nifras Ismail* >> [image: LinkedIn] <http://lk.linkedin.com/pub/nifras-ismail/54/343/94b> >> >> >> >> On Tue, Jan 12, 2016 at 7:10 PM, Mohamed ZAJITH <mohamedzaj...@gmail.com> >> wrote: >> >>> Congratulations Fazlan. >>> On Jan 12, 2016 6:28 PM, "Nipuna Chandradasa" <nipu...@wso2.com> wrote: >>> >>>> Congratulations Fazlan .. :D >>>> >>>> On Tue, Jan 12, 2016 at 4:58 PM, Ashen Weerathunga <as...@wso2.com> >>>> wrote: >>>> >>>>> Congratulations Fazlan!!! :) >>>>> >>>>> On Tue, Jan 12, 2016 at 4:47 PM, Malintha Adikari <malin...@wso2.com> >>>>> wrote: >>>>> >>>>>> Congratulations..!!! >>>>>> >>>>>> On Tue, Jan 12, 2016 at 4:36 PM, Nirmal Fernando <nir...@wso2.com> >>>>>> wrote: >>>>>> >>>>>>> Hi All, >>>>>>> >>>>>>> It's my pleasure to announce *Fazlan Nazeem* as a *WSO2 Committer*. >>>>>>> He has been a key contributor to the *WSO2 Machine Learner *Product >>>>>>> and in recognition of his work, he had been voted as a WSO2 >>>>>>> Committer. >>>>>>> >>>>>>> Congratulations Fazlan and keep up the good work! >>>>>>> >>>>>>> -- >>>>>>> >>>>>>> Thanks & regards, >>>>>>> Nirmal >>>>>>> >>>>>>> Team Lead - WSO2 Machine Learner >>>>>>> Associate Technical Lead - Data Technologies Team, WSO2 Inc. >>>>>>> Mobile: +94715779733 >>>>>>> Blog: http://nirmalfdo.blogspot.com/ >>>>>>> >>>>>>> >>>>>>> >>>>>>> ___ >>>>>>> Dev mailing list >>>>>>> Dev@wso2.org >>>>>>> http://wso2.org/cgi-bin/mailman/listinfo/dev >>>>>>> >>>>>>> >>>>>> >>>>>> >>>>>> -- >>>>>> *Malintha Adikari* >>>>>> Software Engineer >>>>>> WSO2 Inc.; http://wso2.com >>>>>> lean.enterprise.middleware >>>>>> >>>>>> Mobile: +94 71 2312958 >>>>>> Blog:http://malinthas.blogspot.com >>>>>> Page: http://about.me/malintha >>>>>> >>>>>> ___ >>>>>> Dev mailing list >>>>>> Dev@wso2.org >>>>>> http://wso2.org/cgi-bin/mailman/listinfo/dev >>>>>> >>>>>> >>>>> >>>>> >>>>> -- >>>>> *Ashen Weerathunga* >>>>> Software Engineer - Intern >>>>> WSO2 Inc.: http://wso2.com >>>>> lean.enterprise.middleware >>>>> >>>>> Email: as...@wso2.com >>>>> Mobile: +94 716042995 <94716042995> >>>>> LinkedIn: >>>>> *http://lk.linkedin.com/in/ashenweerathunga >>>>> <http://lk.linkedin.com/in/ashenweerathunga>* >>>>> >>>>> ___ >>>>> Dev mailing list >>>>> Dev@wso2.org >>>>> http://wso2.org/cgi-bin/mailman/listinfo/dev >>>>> >>>>> >>>> >>>> >>>> -- >>>> Nipuna Marcus >>>> *Software Engineer* >>>> WSO2 Inc. >>>> http://wso2.com/ - "lean . enterprise . middleware" >>>> Mobile : +94 (0) 713 667906 >>>> nipu...@wso2.com >>>> >>>> ___ >>>> Dev mailing list >>>> Dev@wso2.org >>>> http://wso2.org/cgi-bin/mailman/listinfo/dev >>>> >>>> >>> ___ >>> Dev mailing list >>> Dev@wso2.org >>> http://wso2.org/cgi-bin/mailman/listinfo/dev >>> >>> >> >> ___ >> Dev mailing list >> Dev@wso2.org >> http://wso2.org/cgi-bin/mailman/listinfo/dev >> >> > > > -- > Menaka Madushanka Jayawardena > Software Engineering Intern > men...@wso2.com > Mobile:- +94 71 8851183/ +94 71 3505470 > LinkedIn - Menaka Jayawardena > <https://lk.linkedin.com/in/menakajayawardena> > > ___ > Dev mailing list > Dev@wso2.org > http://wso2.org/cgi-bin/mailman/listinfo/dev > > -- Thanks & Regards *Sajith Dimal* Software Engineer - Intern WSO2 Inc.: http://wso2.com lean.enterprise.middleware Email: saji...@wso2.com Mobile: +94 783101496 <94783101496> LinkedIn: https://lk.linkedin.com/pub/sajith-dimal/b8/1b1/25b <https://lk.linkedin.com/pub/sajith-dimal/b8/1b1/25b> ___ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev
Re: [Dev] [VOTE] Release WSO2 Developer Studio 3.8.0 RC 4
Hi All. I tested main use cases of the following scenarios and found no issues: 1. Analytics project creation. 2. Analytics artifacts (Execution-plan, Stream, Receiver, Publisher) creation. 3. Analytics artifact rename. 4. CAPP project creation and deploy for Analytics project. +1 for the release. Thanks. On Wed, Oct 14, 2015 at 2:53 PM, Susinda Perera <susi...@wso2.com> wrote: > Hi All > I have tested following and no blocking issues found. > > ESB, DSS, BPEL, CAPP project creation > ESB artifact creation > Importing connectors > Connector exporter project > All inbound endpoints > APIM perspective - commit/rename/checkout > > Thanks > Susinda > > > > > > On Wed, Oct 14, 2015 at 10:09 AM, Awanthika Senarath <awanth...@wso2.com> > wrote: > >> Hi >> >> I have tested the following features and bug fixes and the observations >> were positive, hence +1 >> >> >>- ESB projects, >>- Registry Projects >>- Data Service Projects >> >> >> >>- Capp projects (creation, deploy, redeploy, removal) >>- Servers (remote/local) >> >> >> >>- Artifact renaming. >> >> >> Regards >> Awanthika >> >> >> Awanthika Senarath >> Software Engineer, WSO2 Inc. >> Mobile: +94717681791 >> >> >> >> On Wed, Oct 14, 2015 at 9:25 AM, Kavith Lokuhewage <kav...@wso2.com> >> wrote: >> >>> Hi Devs, >>> >>> Please vote for the fourth release candidate of WSO2 Developer Studio >>> 3.8.0. >>> >>> This release fixes following issues. >>> https://wso2.org/jira/issues/?filter=12453 >>> >>> Please download, test and vote. Vote will be open for 72 hours or as >>> needed. >>> >>> Sources, binary distribution and pre-installed eclipse distributions: >>> http://builder1.us1.wso2.org/~developerstudio/developer-studio/3.8.0/RC4/ >>> >>> The tag to be voted upon: >>> https://github.com/wso2/developer-studio/tree/v3.8.0-RC4 >>> >>> >>> [+] Stable - go ahead and release >>> [-] Broken - do not release (explain why) >>> >>> Thanks and Regards, >>> DevStudio Team >>> >>> -- >>> *Kavith Lokuhewage* >>> Software Engineer >>> WSO2 Inc. - http://wso2.com >>> lean . enterprise . middleware >>> Mobile - +9477-9-145-123 | +9471-455-6-401 >>> Linkedin <http://www.linkedin.com/pub/kavith-lokuhewage/49/473/419> >>> Twitter <https://twitter.com/KavithThiranga> >>> >>> ___ >>> Dev mailing list >>> Dev@wso2.org >>> http://wso2.org/cgi-bin/mailman/listinfo/dev >>> >>> >> >> ___ >> Dev mailing list >> Dev@wso2.org >> http://wso2.org/cgi-bin/mailman/listinfo/dev >> >> > > > -- > *Susinda Perera* > Software Engineer > B.Sc.(Eng), M.Sc(Computer Science), AMIE(SL) > Mobile:(+94)716049075 > Blog: susinda.blogspot.com > WSO2 Inc. http://wso2.com/ > Tel : 94 11 214 5345 Fax :94 11 2145300 > > > ___ > Dev mailing list > Dev@wso2.org > http://wso2.org/cgi-bin/mailman/listinfo/dev > > -- Thanks & Regards *Sajith Dimal* Software Engineer - Intern WSO2 Inc.: http://wso2.com lean.enterprise.middleware Email: saji...@wso2.com Mobile: +94 783101496 <94783101496> LinkedIn: https://lk.linkedin.com/pub/sajith-dimal/b8/1b1/25b <https://lk.linkedin.com/pub/sajith-dimal/b8/1b1/25b> ___ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev
[Dev] Code Review Notes : Developer Studio plug-in for Analytics Project
Participants – Sriskandarajah Suhothayan, SajithD Notes - Change the naming convention “CEP” to “Analytics” through the entire project. - Update the license header. - Add class to handle project constants and messages. - Use proper name for the methods and variables. - Ex: “cepProjectName” to “analyticsProjectName” “file” to “artifactFile” - Use enum type's field instead of String type in Map<File,String> artifactList. - Use IdeveloperStudioLog log.error instead of e.printStackTrace for AnalyticsProjectArtifactCreator.serialize() method. - Remove artifact creation wizard 3rd page (Meven information), retrieve those information from the parent project. - Add folderLocation.isDirectory() validation for wizard option modelProperty="project.location" Please add if anything missing. Thanks & Regards, SajithD -- Thanks & Regards *Sajith Dimal* Software Engineer - Intern WSO2 Inc.: http://wso2.com lean.enterprise.middleware Email: saji...@wso2.com Mobile: +94 783101496 <94783101496> LinkedIn: https://lk.linkedin.com/pub/sajith-dimal/b8/1b1/25b <https://lk.linkedin.com/pub/sajith-dimal/b8/1b1/25b> ___ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev
Re: [Dev] Updated Invitation: [Code review]Developer Studio plug-in for Analytics Proje... @ Wed Aug 26, 2015 11am - 12pm (saji...@wso2.com)
Hi all, Please find the notes of this functional review. Attendees: Jasintha Dasanayake, Gayan Yalpathwala, Tishan Dahanayakage, Rajeev Sampath, Sajith Dimal. *Suggestions:* - Dependency artifacts must not be validated during deploy time. If there is going to be such validation, then the deployer should handle deploying order of different artifact types. - Content assistance should be provided at some point for the execution plan editor. At least, form editors should be provided for complex configurations. - New dashboard entries can be added using an extension point instead of hard-coding. - Project creation wizard should not contain import project option. Instead, pointing to an existing folder option is preferred. - Project import should be handled by WSO2 project import wizard. - Receiver wizard can contain a field to select input event adapter type. Then a template of that type can be created. Please add if I have missed anything. Thanks, SajithD On Tue, Aug 25, 2015 at 9:57 AM, saji...@wso2.com wrote: This event has been changed. more details » https://www.google.com/calendar/event?action=VIEWeid=NjVlZjFtMTllMGZwYWY4bjZrMDJhZmxmNHMgZGV2QHdzbzIub3Jntok=MTYjc2FqaXRoZEB3c28yLmNvbWViYjQxMDUxMTU2YmVlMWY0ZmY5NTYyMWJkOGM3YWRjZjk0OTBiZjIctz=Asia/Colombohl=en *Changed: *[Code review]Developer Studio plug-in for Analytics Project@ Tue Aug 26, 2015 11:00am - 12:00pm (saji...@wso2.com) *When* Wed Aug 26, 2015 11am – 12pm Colombo *Where* LK 1st Floor Meeting Room Ext:1005150 (map https://maps.google.com/maps?q=LK+1st+Floor+Meeting+Room+Ext:1005150hl=en ) *Video call* https://plus.google.com/hangouts/_/wso2.com/invitation-code https://plus.google.com/hangouts/_/wso2.com/invitation-code?hceid=c2FqaXRoZEB3c28yLmNvbQ.65ef1m19e0fpaf8n6k02aflf4s *Calendar* saji...@wso2.com *Who* • saji...@wso2.com - organizer • Ramindu De Silva • Damith Wickramasinghe • Jasintha Dasanayake • raje...@wso2.com • Gayan Yalpathwala • Sriskandarajah Suhothayan • thili...@wso2.com • Tishan Dahanayakage • dev@wso2.org • Sajith Ravindra • Tharik Kanaka • Viraj Rajaguru • Dilini Muthumala • Lasantha Fernando Going? *Yes https://www.google.com/calendar/event?action=RESPONDeid=NjVlZjFtMTllMGZwYWY4bjZrMDJhZmxmNHMgZGV2QHdzbzIub3Jnrst=1tok=MTYjc2FqaXRoZEB3c28yLmNvbWViYjQxMDUxMTU2YmVlMWY0ZmY5NTYyMWJkOGM3YWRjZjk0OTBiZjIctz=Asia/Colombohl=en - Maybe https://www.google.com/calendar/event?action=RESPONDeid=NjVlZjFtMTllMGZwYWY4bjZrMDJhZmxmNHMgZGV2QHdzbzIub3Jnrst=3tok=MTYjc2FqaXRoZEB3c28yLmNvbWViYjQxMDUxMTU2YmVlMWY0ZmY5NTYyMWJkOGM3YWRjZjk0OTBiZjIctz=Asia/Colombohl=en - No https://www.google.com/calendar/event?action=RESPONDeid=NjVlZjFtMTllMGZwYWY4bjZrMDJhZmxmNHMgZGV2QHdzbzIub3Jnrst=2tok=MTYjc2FqaXRoZEB3c28yLmNvbWViYjQxMDUxMTU2YmVlMWY0ZmY5NTYyMWJkOGM3YWRjZjk0OTBiZjIctz=Asia/Colombohl=en* more options » https://www.google.com/calendar/event?action=VIEWeid=NjVlZjFtMTllMGZwYWY4bjZrMDJhZmxmNHMgZGV2QHdzbzIub3Jntok=MTYjc2FqaXRoZEB3c28yLmNvbWViYjQxMDUxMTU2YmVlMWY0ZmY5NTYyMWJkOGM3YWRjZjk0OTBiZjIctz=Asia/Colombohl=en Invitation from Google Calendar https://www.google.com/calendar/ You are receiving this courtesy email at the account dev@wso2.org because you are an attendee of this event. To stop receiving future updates for this event, decline this event. Alternatively you can sign up for a Google account at https://www.google.com/calendar/ and control your notification settings for your entire calendar. Forwarding this invitation could allow any recipient to modify your RSVP response. Learn More https://support.google.com/calendar/answer/37135#forwarding. ___ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev -- Thanks Regards *Sajith Dimal* Software Engineer - Intern WSO2 Inc.: http://wso2.com lean.enterprise.middleware Email: saji...@wso2.com Mobile: +94 783101496 94783101496 LinkedIn: https://lk.linkedin.com/pub/sajith-dimal/b8/1b1/25b https://lk.linkedin.com/pub/sajith-dimal/b8/1b1/25b ___ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev