Seems like link code is not properly generated when filtering for a field named YEAR. The SQL Select Statement under SQL section is enclosing the name of the field with quotes as seems YEAR is a command or reserved word in SQL Server, everything works fine except Refined Search not. I had to rename the field in database to solve this issue.
Thanks.