When running the report, getting error "while trying to invoke the method java.lang.String.length() of an object loaded from local variable 'str' ".

[Former Member]

Hi,

        We have a report with two filters Project Priority (Enumeration) and Project Status (Value List).

When I run the report without selecting don't select any value for the Project Priority filter, I am getting below error.

"while trying to invoke the method java.lang.String.length() of an object loaded from local variable 'str' "

This is happening in all environments.Here I am attaching the screen shot for your reference.

Please let me know if you have any idea on how to fix this issue.

Many Thanks,

Srini

[Former Member]

If you are using query substitutions please check the following, remove empty spaces within AND_OP method.

for ex: if you place empty space after comma (,) in below syntax you will get the same error. So make sure you clear all the empty spaces and try.

<%AND_OP("T1.CURRENT_PHASE",<%?(ProcessStatus)%>)%>

[Former Member]

Hi Srini,

Could you pls share the screenshot of query as well, as it is difficult to identify the issue with the given information.

Regards,

Vignesh