There was a problem running the query

Looker Q&A Looker
,
1

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?

2

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.