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 <[email protected]> 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 <[email protected]> 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 <[email protected]> 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 <[email protected]> >> 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 >>> [email protected] >>> http://wso2.org/cgi-bin/mailman/listinfo/dev >>> >> >> >> -- >> <http://wso2.com/signature> >> Sajith Dimal >> Senior Software Engineer >> Email: [email protected] >> 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: [email protected] > 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: [email protected] 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 [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
