Issue Summary

When I run a query in Redash, I get the following error.

Error running query: Invalid control character at: line 6736 column 17 (char 299741)

I was able to execute the query yesterday. The data source is BigQuery. Do you have any solutions?

Technical details:

  • Redash Version: Error running query: Version: 8.0.0+b32245 (a16f551e)
  • Browser/OS: Google Chrome/Mac
  • How did you install Redash:
    I created an instance in AWS using the ap-northeast-1 AMI, ami-0c7d9b740e997aa69.

This may be an issue with how Redash is deserialising data from BigQuery. Can you advise how the query behaves if you execute it from a different query tool?

When I ran the same query directly on BigQuery, no error occurred and the data was retrieved successfully.

I don’t know why, but the error no longer occurs. Thanks!