Incident: Error OS-BERT-60409 when using Count in Advanced Query across multiple regions

This incident has been fully resolved, and the Count parameter in advanced SQL queries is now operating as expected. To ensure you benefit from this fix, please make sure you republish the affected application and deploy it to the affected stage if necessary.

Thank you for your patience and understanding while we worked to resolve this matter.

A solution has been applied to resolve this issue.
A republish of the application is required to fully apply the fix.
We will continue monitoring this situation to ensure full recovery.

We continue to make progress on the deployment of the fix affecting ODC services.

During the final stages of the rollout and validation process, additional time was required before pipelines could be safely unfrozen and normal operations resumed.

The updated estimated resolution time is now 11:00 UTC on May 25th.

Users may continue to experience intermittent symptoms while mitigation and validation activities remain in progress. We are actively monitoring the situation and will continue to provide updates as additional information becomes available.

We continue to deploy the fix for the issue affecting ODC and are seeing progress across the impacted services.

Due to additional time required to complete the rollout safely and validate platform stability, the estimated resolution time has been updated to 07:00 UTC on May 23rd.

Users may continue to experience intermittent symptoms while deployment activities are ongoing. We are closely monitoring the situation and will provide further updates as progress continues.

We have identified the cause of the issue affecting ODC and a fix is currently being deployed.
Users may continue to experience symptoms while the update is being implemented. We are monitoring the progress closely and aim to have the issue fully resolved by 00:00 UTC on May 23rd.

We have identified the cause of an issue affecting the Count parameter in advanced SQL queries.

Customers may experience a runtime error (OS-BERT-60409 – Could not calculate the query count) and application crashes when using the Count parameter in advanced SQL queries.

Additionally, we strongly recommend avoiding any redeployment or republishing of applications that use Advanced SQL in production until the issue is resolved, to prevent any potential unexpected behavior.

Our team is actively working on a solution, and we will provide an update as soon as more details are available.