Error:HCRException: The filter value is unaccepted. Please try some other value

Adhoc
, , , ,
#1

Hello Helical Insight,

I am using Canned report interface to generate reports on Helical Insight 4.1.1.18666 GA
Version. I am getting following error when I pass this as my filter value like: ORG4_DESC_ALTERNATE IN ( ‘22000000-UNIVdgjRSITY OF HAWAII’ , ‘436874-BOARD OF RENTS’ , ‘2100-EXEC ADMIN & SECRETARY OF BOR’

Error:HCRException: The filter value is unaccepted. Please try some other value.

thanks,
Sesa.

#2

Hello Sesa,

In helicalinsight few values are restricted in filter expression for the security reasons…

If you pass that restricted keyword you might get the below error

Error: HCRException: The filter value is unaccepted, please try with someother value…

In case if you compulsory want those values to be passed in filter expression then navigate yourself to this location

/HelicalInsight/hi/hi-repository/System/Admin

Here you will find ‘defaults.properties’ file

image

you will find the below keywords
CREATE|DELETE|DROP|INSERT( +INTO){0,1}|MERGE|SELECT|UPDATE|UNION( +ALL){0,1}|FROM|WHERE|SLEEP

try to remove the keyword that is restricting your filter expression and save it.
Refresh the tomcat and try now…

Thank You,
Helical Insight.