Solved

There was a problem running the query

  • 23 June 2021
  • 1 reply
  • 66 views

Userlevel 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?

icon

Best answer by sri75 25 June 2021, 14:52

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.

View original

1 reply

Userlevel 1

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.

Reply