SECURITY FAILURE Anonymous:null@unknown -> /ExampleApplication/IntrusionException] INTRUSION - Mixed encoding (2x) detected

[xavier.bonislawski]

Hello,

I Had a repport that worked fine in JasperServer 7.1

After upgrading to 7.5 the same repport doesn't work anymore.

I got the following error message :

"ERROR IntrusionException,pool-5-thread-521:55 - [sECURITY FAILURE Anonymous:null@unknown -> /ExampleApplication/IntrusionException] INTRUSION - Mixed encoding (2x) detected "

" Error during report execution com.jaspersoft.jasperserver.api.JSSecurityException"

I understand that  a security check causes the exception, and I found  the SQL instruction that causes the problem

SELECT REGEXP_REPLACE(CODE_ANALYTIQUE,'^(.){4}(.*)([[:digit:]]{3}$)','2-3') AS PROJET FROM MYTABLE

and if I modify my query like this

SELECT SUBSTRING((CODE_ANALYTIQUE,....)-SUBSTRING((CODE_ANALYTIQUE,....)

It works fine.

But I prefer to use the REGEXP_REPLACE statment rather than the SUBSTRING

So what is the cause of tis exception, and how can I fix it ?

Thanks