Home Forums Reporting Services SSRS 2012 SharePoint SSRS ORA-00904: "LISTAGG_CLOB" invalid intentifier RE: SharePoint SSRS ORA-00904: "LISTAGG_CLOB" invalid intentifier

  • office 74070 (10/11/2016)


    Hey guys,

    i become following error during report rendering on a sharepoint intergrated ssrs mode:

    Fehler bei der Berichtsverarbeitung. (rsProcessingAborted)

    Fehler beim Ausführen der Abfrage für das DataSet1-Dataset. (rsErrorExecutingCommand)

    ORA-00904: "LISTAGG_CLOB": ungültiger Bezeichner

    The same report on an older version with the same ora driver works fine.

    The SQL Query i have tried:

    select listagg_clob(distinct s.SRC_NAME) as SERVICE from ...

    select listagg_clob(distinct s.SRC_NAME) as "SERVICE" from ...

    select listagg_clob(distinct s.SRC_NAME) SERVICE from ...

    select listagg_clob(distinct s.SRC_NAME) "SERVICE" from ...

    Nothing would be work 🙁

    Can anybody help me?

    with kind regards,

    georg

    That's an Oracle error, so it's coming from the Oracle database. There are those on this forum who may be able to answer it, but you'll probably have better results posting it on an Oracle forum.