Google Cloud MINOR

JSON_SET function has stopped working

December 1, 2023 · 11:13 AM UTC – 06:45 PM UTC · Duration: 7h 32min

Affected Services

Google BigQuery

Timeline

06:45 PM
The issue with Google BigQuery has been resolved for all affected users as of Friday, 2023-12-01 10:32 US/Pacific. We thank you for your patience while we worked on resolving the issue.
05:13 PM
Summary: JSON_SET function has stopped working Description: We believe the issue with JSON_SET function is now resolved in US and EU multi-regions. The issue is partially mitigated in us-east4. Our engineers are continuing to work on fully mitigating the issue in us-east4 region. Full resolution is expected to complete by Friday, 2023-12-01 11:00 US/Pacific. We will provide an update by Friday, 2023-12-01 11:15 US/Pacific with current details. Diagnosis: Customers may receive an error message when running queries with JSON_SET: Invalid number of parameters passed to function: expected at least 4, got 3' Workaround: None at this time.
02:53 PM
Summary: JSON_SET function has stopped working Description: We believe the issue with JSON_SET function is now resolved in US and EU multi-regions. We are still working on mitigating the issue in us-east4 region. We do not have an ETA for full resolution at this point. We will provide an update by Friday, 2023-12-01 09:30 US/Pacific with current details. Diagnosis: Customers may receive an error message when running queries with JSON_SET: Invalid number of parameters passed to function: expected at least 4, got 3' Workaround: None at this time.
12:48 PM
Summary: JSON_SET function has stopped working Description: Mitigation work is still underway by our engineering team. We will provide more information by Friday, 2023-12-01 08:00 US/Pacific. Diagnosis: Customers may receive an error message when running queries with JSON_SET: Invalid number of parameters passed to function: expected at least 4, got 3' Workaround: None at this time.
11:54 AM
Summary: JSON_SET function has stopped working Description: Mitigation work is currently underway by our engineering team. We do not have an ETA for mitigation at this point. We will provide more information by Friday, 2023-12-01 05:00 US/Pacific. Diagnosis: Customers may receive an error message when running queries with JSON_SET: Invalid number of parameters passed to function: expected at least 4, got 3' Workaround: None at this time.