Knowledge Drop

Why does System Activity give the error data exception: invalid character value for cast`?

  • 7 July 2021
  • 0 replies
  • 22 views

Userlevel 3

Last tested: Nov 16, 2017

 

The history explore in System Activity includes both User-Defined and LookML dashboards. Because of this, when filtering on a dashboard id, the generated SQL will convert the ID to a VARCHAR.

If you try to filter on a dashboard id within a custom filter, you might get the error message data exception: invalid character value for cast (if they are on a HyperSQL back-end). To get around this, change your custom filter to be:

concat(${history.dashboard_id},"") = "58"

This will cast the dashboard ID to a VARCHAR in the generated SQL and filter correctly.

 

 

This content is subject to limited support.                

 

 


0 replies

Be the first to reply!

Reply