Laurent Hinoul

“Always code as if the guy who ends up maintaining your code will be a violent psychopath who knows where you live.” - John F. Woods

How to fix Jasperserver error 6632

When I want to run a certain report on Jasperserver. I got an error like: An error has occurred. Please contact your system administrator. (6632)

When I looked into the logs or the jasper messages. I saw an error like:

You probably have an error in your SQL query. I had a query where I did a union all surrounded by parentheses. For example, it’s the same as you do:

Jasperserver sees that as invalid, so I recreated my query without the parentheses and that works fine!

Now if this error keeps throwing, you could set the SQL validation off. You can do this by opening the following file on your jasperserver: webapps/jasperserver/WEB-INF/classes/esapi/

Now, when this file is opened with a text editor, search for ‘security.validation.sql.on‘. If you found that, you need to set its value to false:

After you changed that and uploaded it back, restart your jasperserver instance and enjoy running your report! Not that disabling the security could lead to SQL injection.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: