Skip to Content

Datetime parameter in KPI Delete query

Hi Experts,

We have KPI objects in which we need to retain data for some period of time lets say, I want to retain data for the last 24 hrs and delete the remaining KPI data. I have prepared KPI query in delete mode. In Filter Expression field of the query i am passing the expression as

"[TimeStamp] <= to_date ( '01/12/2015' , 'MM/DD/YYYY') "

then i am getting the following error:

SQL error has occurred on query The SQL statement "DELETE FROM MDO11061 WHERE FIELD2 <= to_date ( '01/12/2015' , 'MM/DD/YYYY')" contains the syntax error[s]: - 1:46 - SQL syntax error: the token "(" was not expected here

Is it possible to perform such function in the Delete mode of KPI query. If yes, what am I doing incorrectly ? Has anyone faced similar issue earlier.

I would highly appreciate any hint which could help in solving this problem.

System Information:

NW 7.31 SP 10

Oracle 11.2.0.4

MII 14.0 SP5 patch 7

Regards,
Darshan Sheth

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Jan 14, 2015 at 10:11 AM

    Hi Darshan,

    Try using [Timestamp] > [Param.1]. In the parameters tab specify the parameter and type as timestamp.

    Regards,

    Anushree

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 14, 2015 at 09:04 AM

    Hi Darshan,

    Try removing double quotes. Refer below document by Rutika:

    MII - KPI Configuration Guide

    Also, check backend of you MII System. Is it Oracle or SQL?

    Thanks,
    Swaroop

    Add comment
    10|10000 characters needed characters exceeded