Drill Down Option Stopped Working in Dashboards: Unexpected end of JSON input

vsil
Participant I

Hello, we have an issue which seems to have appeared without any changes from our end. Drill down options display the Unexpected end of JSON input error in the drill down pop up. All of these drill downs were working fine before.

4ccc4b1f-1600-4e16-9c46-92bbc31fd2d8.png

Any idea what causes this issue?

Solved Solved
7 19 3,296
1 ACCEPTED SOLUTION

Same thing has happened to our instance. Enabling the legacy runtime again fixed it for most existing tables. Admin > Legacy Features and you can toggle it on from there. However I still get the error when creating new visuals sometimes.

View solution in original post

19 REPLIES 19

Getting same error. Can someone help me with it?

Seeing the same issue.

same issue, did anyone find the solution?

vsil
Participant I

One way around this seems to be clicking ‘Explore from Here’ in the drill down window where you see the error. The explore layer opens and you can see the drilled down data.

I cannot comprehend why it does not render directly in dashboards. Can someone from Looker staff take a look?

@vsil  -- thank you. I saw that too, however, not everyone has Explore rights in our company, and they need to see the dashboard in question drilled down 😞

Having same issue, please advise.

Same thing has happened to our instance. Enabling the legacy runtime again fixed it for most existing tables. Admin > Legacy Features and you can toggle it on from there. However I still get the error when creating new visuals sometimes.

It did not work for me

Same issue here.

vsil
Participant I

Thanks @Tom_Roberts, turning on the Legacy LookML Runtime solved this issue. Hopefully Looker will come up with a permanent solution as this one is valid only for the next 7 months.

Thanks @Tom_Roberts, it worked here too. Waiting for a permanent solution, because activating the Legacy LookML Runtime can impact on queries performances. 

I am also having this issue, why is this issue marked as resolved?

Ran into this issue today for the first time. Activating the Legacy LookML Runtime worked for me for now but prefer this not be the fix.

m-fernandes
Participant III

Not working for me and I already have the Legacy LookML Runtime activated

Not working here either. Seems to work sometimes, but not others. Is anybody looking at this?

Does anyone know if there is a bug report for this that I can upvote? 

Works when enabling the legacy runtime, but there is a disclaimer saying that this setting will be removed in a few months.

Can we please have a fix?

Many thanks

Anyone found a fix for this? I started facing this issue today.


@vsil wrote:

Hello, we have an issue which seems to have appeared without any changes from our end. Drill down options display the Unexpected end of JSON input error in the drill down pop up. All of these drill downs were working fine before.

4ccc4b1f-1600-4e16-9c46-92bbc31fd2d8.png

Any idea what causes this issue?


SOLUTION

I faced the same issue recently and couldn't figure out what happened as the drill down fields used to work a day before. I noticed my explore had more than 20 custom measures and this caused the "Unexpected end of JSON input" issue (reason : since looker filters and custom measures gets populated in url that browser sends to server, lengthy request caused to overflow, you can check this in browser inspect-> Network shows bad request)

Fix : 

I deleted unused custom measures in each tile and kept only those that I'm using in the respective tile and this error is gone and drill fields are working now.

Hope this Helps!

Top Labels in this Space
Top Solution Authors