October 11, 2016 at 9:29 am
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
October 22, 2016 at 3:22 pm
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.
October 23, 2016 at 5:13 am
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.
October 23, 2016 at 5:56 am
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.
October 24, 2016 at 2:13 am
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
October 24, 2016 at 2:20 am
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