How to fix Cannot read properties of undefined (reading 'valid') error while attempting scaling a Synapse SQL Dedicated pool

Question

Receiving an error message when attempting to scale the Synapse Analytics dedicated pool:
Any ideas on how to resolve this?

{ "shellProps": { "sessionId": "e72684e96bd24d33a7a77f87c774c1cd", "extName": "Microsoft_Azure_Synapse", "contentName": "SqlPoolWorkloadManagementBlade" }, "error": { "message": "Cannot read properties of undefined (reading 'valid')", "error": { "message": "Cannot read properties of undefined (reading 'valid')", "name": "TypeError", "stack": "TypeError: Cannot read properties of undefined (reading 'valid')\n at https://hosting.portal.azure.net/synapse/Content/Dynamic/hBYJv-xbpLnX.js:1:15049\n at l.evaluateImmediate_CallReadThenEndDependencyDetection (https://portal.azure.com/Content/Dynamic/5FFTK2mKahio.js:14:29204)\n at l.evaluateImmediate_CallReadWithDependencyDetection (https://portal.azure.com/Content/Dynamic/5FFTK2mKahio.js:14:28697)\n at l.evaluateImmediate (https://portal.azure.com/Content/Dynamic/5FFTK2mKahio.js:14:28215)\n at l.beforeSubscriptionAdd (https://portal.azure.com/Content/Dynamic/5FFTK2mKahio.js:14:30325)\n at l.subscribe (https://portal.azure.com/Content/Dynamic/5FFTK2mKahio.js:14:19583)\n at e.subscribe (https://portal.azure.com/Content/Dynamic/MNBqbLYmikCd.js:1:61244)\n at l.subscribeToDependency (https://portal.azure.com/Content/Dynamic/5FFTK2mKahio.js:14:27519)\n at Object.h (https://portal.azure.com/Content/Dynamic/5FFTK2mKahio.js:14:24848)\n at t.registerDependency (https://portal.azure.com/Content/Dynamic/5FFTK2mKahio.js:14:11093)\n at l (https://portal.azure.com/Content/Dynamic/5FFTK2mKahio.js:14:25810)\n at https://hosting.portal.azure.net/synapse/Content/Dynamic/hBYJv-xbpLnX.js:1:15328\n at l.evaluateImmediate_CallReadThenEndDependencyDetection (https://portal.azure.com/Content/Dynamic/5FFTK2mKahio.js:14:29204)\n at l.evaluateImmediate_CallReadWithDependencyDetection (https://portal.azure.com/Content/Dynamic/5FFTK2mKahio.js:14:28697)\n at l.evaluateImmediate (https://portal.azure.com/Content/Dynamic/5FFTK2mKahio.js:14:28215)\n at l.beforeSubscriptionAdd (https://portal.azure.com/Content/Dynamic/5FFTK2mKahio.js:14:30325)\n at l.subscribe (https://portal.azure.com/Content/Dynamic/5FFTK2mKahio.js:14:19583)\n at e.subscribe (https://portal.azure.com/Content/Dynamic/MNBqbLYmikCd.js:1:61244)\n at l.subscribeToDependency (https://portal.azure.com/Content/Dynamic/5FFTK2mKahio.js:14:27519)\n at Object.h (https://portal.azure.com/Content/Dynamic/5FFTK2mKahio.js:14:24848)\n at t.registerDependency (https://portal.azure.com/Content/Dynamic/5FFTK2mKahio.js:14:11093)\n at l (https://portal.azure.com/Content/Dynamic/5FFTK2mKahio.js:14:25810)\n at read (https://portal.azure.com/Content/Dynamic/5FFTK2mKahio.js:90:770)\n at l.evaluateImmediate_CallReadThenEndDependencyDetection (https://portal.azure.com/Content/Dynamic/5FFTK2mKahio.js:14:29204)\n at l.evaluateImmediate_CallReadWithDependencyDetection (https://portal.azure.com/Content/Dynamic/5FFTK2mKahio.js:14:28697)", "extension": "Microsoft_Azure_Synapse" }, "code": null }}

Answer 1

Hi Vardges Bokhyan,

This issue was caused by a temporary problem in the Azure portal interface that affected the scale blade for dedicated SQL pools. The engineering team has now rolled back to a stable version of the Synapse portal extension, and the fix has been deployed.

You should now be able to scale your SQL pool through the Azure portal without seeing the "Cannot read properties of undefined (reading 'valid')" error.

Please try again and let me know if you still face any issues.

Answer 2

The error message "Cannot read properties of undefined (reading 'valid')" typically indicates that there is an issue with the JavaScript code running in the Azure portal, possibly due to a missing or improperly defined variable. This can occur during operations like scaling a Synapse SQL Dedicated pool.

Here are some steps you can take to troubleshoot and potentially resolve this issue:

1. Refresh the Azure Portal: Sometimes, simply refreshing the Azure portal can resolve temporary issues.
2. Clear Browser Cache: Clear your browser's cache and cookies, as stale data can sometimes cause issues with web applications.
3. Try a Different Browser: If the issue persists, try accessing the Azure portal using a different web browser to see if the problem is browser-specific.
4. Check Service Health: Verify if there are any ongoing issues with Azure services that might be affecting your ability to scale the dedicated SQL pool. You can check the Azure status page for any incidents.
5. Retry the Operation: If the error is transient, waiting a few moments and then retrying the scaling operation may help.
6. Contact Support: If none of the above steps work, consider reaching out to Azure support for assistance, as they can provide more specific guidance based on your account and the error details.

If the problem continues, it may be beneficial to check for any updates or known issues related to the Azure Synapse service that could be affecting functionality.