There was a problem running the query

[sri75]

I have been getting this error in a Look . 

I narrowed it down to one particular field , but the same field works fine in an another look so i am not sure what the exact problem is at this point.

I recently added a link to the troubled field , so i am not sure if that caused the problem but when i validate the lookml i donot see any errors

And also when i  run the same query including the troubled field in sql runner it just runs fine and gives me the result. Any idea why this is happening?

[sri75 · Accepted solution]

It took me sometime but i resolved the issue. Within the URL i set for this field it was referencing a field that doesnt have any connection in the explore , hence it is not working. 

Once i included the viewin the explore and gave the appropriate join it started to work.