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.