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 whare I did a union all surounded by parentheses. For example, it’s the same like 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/security-config.properties

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

%d bloggers like this: