0

I am currently working on a report which use the function SYS_CONNECT_BY_PATH to produce a concatenated list. Considering my version of Oracle, I can't use the easier and fancier approach that is LISTAGG.

My query is working as intended in my Oracle developper and in my report (in Jaspersoft Studio). The problem is that when I publish the report and try to use it on the server, I receive the following error : 

2019-03-12 09:37:57,471 ERROR Validator,pool-4-thread-1:496 - Invalid SQL:An error has occurred. Please contact your system administrator. (6632).

Cool, an error code, let's read about it : https://laurenthinoul.com/how-to-fix-jasperserver-error-6632/ .

I tried checking for wrong parenthesis and such, but everything is fine and when I take out the SYS_CONNECT_BY_PATH function from my report and republish it, it works. I would VERY MUCH like to not disable security for the sake of this report.

So, considering the following informations about my current settings :

  • JasperSoft studio version : 6.4.0.final
  • Jasperserver version : 7.1.0 (build 20180504_1307)
  • Oracle version : Oracle9i Release 9.2.0.6.0 - Production

Why is the Oracle function SYS_CONNECT_BY_PATH working in Jasper Studio, but not on Jasper Server?

Alex K
  • 22,315
  • 19
  • 108
  • 236
KeineMaster
  • 285
  • 5
  • 14
  • 1
    JRS has it is own validator. You can change validation rules to pass check - it is just regexp – Alex K Mar 19 '19 at 18:19
  • @AlexK Thanks for that advice! If you'd like to post an answer, i'd gladly mark you as the correct one. This helped me find my solution! – KeineMaster Mar 21 '19 at 13:42
  • You are welcome. You can mark this question as duplicate of [An error has occurred. Please contact your system administrator. (6632) error in Jasper server 6.2](https://stackoverflow.com/q/34430291/876298) – Alex K Mar 21 '19 at 20:52

0 Answers0