Possible problems:

  • Usually is described as “sql injection error” but most likely it means typo in your SQL query. Like “;” instead of “:”.
    • Try to allow SQL queries logging and look into default “jasperserver.log” file and try SQL query directly on your database – you will see more.
  • There can be a problem if you use regular expressions. For example “regexp_replace” postgresql function. Jasper can take it as danger of “sql injection”. I such case you will have no other choice then switch off this check in jasper server.
    • Read this “error 6632 text” – you will have to set “security.validation.sql.on=false” in the file …/webapps/jasperserver/WEB-INF/classes/esapi/security-config.properties