Thank you.

The comment on the permission got me thinking. I analyzed few logs.

Found the issue. I had a new 2019 Windows on which the user was created with admin privileges....

It is a typo. In the select statement also, it is  'where id =123' and not 'where wi_id=123'.

However, irrespective of the typo, the issue still remains the same.