SharePoint SSRS ORA-00904: "LISTAGG_CLOB" invalid intentifier

  • 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

  • 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.

  • 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

    The error is pointing to the LISTAGG_CLOB as (as far as I can remember) there is no such function in Oracle. Chances are that it exists as something like this:

    CREATE or replace FUNCTION listagg_clob (input varchar2)

    RETURN clob

    PARALLEL_ENABLE AGGREGATE USING listagg_clob_t;

    😎

    Are you using the same credentials for both the old and the new report? Could be a permission problem.

  • Eirikur Eiriksson (10/23/2016)


    The error is pointing to the LISTAGG_CLOB as (as far as I can remember) there is no such function in Oracle. Chances are that it exists as something like this:

    CREATE or replace FUNCTION listagg_clob (input varchar2)

    RETURN clob

    PARALLEL_ENABLE AGGREGATE USING listagg_clob_t;

    😎

    Are you using the same credentials for both the old and the new report? Could be a permission problem.

    I didn't think there was a function like that either, but it's been quite a while since I've used Oracle. In looking at permissions like Eirikur said, be sure to consider synonym permissions as well as the function.

  • Hy Guys,

    thank you for your replies.

    Yes of course, it was a permission trouble. We have two reporting plattforms and different user in the connection settings.

    My problem was homemade 😀

    greets, Georg

  • office 74070 (10/24/2016)


    Hy Guys,

    thank you for your replies.

    Yes of course, it was a permission trouble. We have two reporting plattforms and different user in the connection settings.

    My problem was homemade 😀

    greets, Georg

    You are most welcome

    😎

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply