9 Replies Latest reply on Mar 31, 2016 6:35 AM by 2838447

    [Microsoft][ODBC SQL Server Driver][SQL Server]'LISTAGG' is not a recognized built-in function name

    2838447

      Dears

      kindly i face an issue when use the following formula with SQL DB

       

      cast(EVALUATE_AGGR('LISTAGG(%1,%2) WITHIN GROUP (ORDER BY %3 DESC)',"AS_INT_REQUEST_DIM"."REQUEST STATUS",',',"AS_INT_REQUEST_DIM"."REQUEST STATUS") as char(500))

       

      it return

      Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P

       

      State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 43119] Query Failed: [nQSError: 16001] ODBC error state: 37000 code: 8180 message: [Microsoft][ODBC SQL Server Driver][SQL Server]Statement(s) could not be prepared.. [nQSError: 16001] ODBC error state: 37000 code: 195 message: [Microsoft][ODBC SQL Server Driver][SQL Server]'LISTAGG' is not a recognized built-in function name.. [nQSError: 16002] Cannot obtain number of columns for the query result. (HY000)

       

      SQL Issued: SELECT 0 s_0, cast(EVALUATE_AGGR('LISTAGG(%1,%2) WITHIN GROUP (ORDER BY %3 DESC)',"Intranet"."AS_INT_REQUEST_DIM"."REQUEST STATUS",',',"Intranet"."AS_INT_REQUEST_DIM"."REQUEST STATUS") as char(500)) s_1 FROM "Intranet" WHERE ("AS_INT_REQUEST_DIM"."REQUEST STATUS" IN ('Closed', 'Completed')) FETCH FIRST 65001 ROWS ONLY

       

      while it work with oracle DB