Hello, I'm trying to query on PI SQL Commander light, and it goes like this:

select * from [Element] where ID='a specific ID' , now it doesn't work when I search for all columns in Element table but when I remove the PrimaryPath column it works just fine.

so, any ideas on what might cause this issue with the PrimaryPath and how it could be fixed. appreciate any support here.