Cannot run reports with fields that have word "Into" in the field name on the server

Scenario:

You designed a report in TIBCO Jaspersoft^® Studio that has a field with a name that contains the word "Into" in it, for example $F{MovedIntoFolder} or $F{ScannedIntoShipment}. The report runs fine in the Jaspersoft^® Studio and it doesn't run on the server. Alternatively, it ran on the server successfully before and then you upgraded to the newest version and it doesn't anymore.

Solution:

The word INTO is causing the SQL to be deemed invalid. The regex for the valid SQL has changed in the recent version. To avoid this problem go to ${JRS WAR file}/WEB-INF/classes/validation.properties file, find the ValidSQL validator:

Validator.ValidSQL=(?is)^\\s*(select|call)\\b((?!\\binto\\b)[^;])*;?\\s*$

Remove the word into from it:

Validator.ValidSQL=(?is)^\\s*(select|call)\\b((?!\\b\\b)[^;])*;?\\s*$

Save and restart.