Jump to content

We've recently updated our Privacy Statement, available here ×

kcd

Members

View Profile See their activity

Posts
54
Joined
July 26, 2011
Last visited
July 30, 2014

Community Answers

kcd's post in An error has occurred. (6632) - SQL validation of stored procedure in 4.5 breaks all report queries? was marked as the answer February 14, 2012

Solution found - there are security configuration options to amend or disable the validation.
1 - The following regex fix should work for most cases.
webapps/jasperserver/WEB-INF/classes/esapi/security-config.properties/validation.propertiesValidator.ValidSQL=^s*(?i)(withs+.*)?(select|call|exec(ute)?)s+[^;]+$
2 - Alternatively turn it off
webapps/jasperserver/WEB-INF/classes/esapi/security-config.propertiessecurity.validation.sql.on=false

Post Edited by kcd at 02/14/2012 23:00

Post Edited by kcd at 02/14/2012 23:01

×

×

Create New...