Azure Synapse Analytics Serverless SQL view return log "Ajaxerror:null"

Question

Azure Synapse Analytics Serverless SQL view return log "Ajaxerror:null"

Richard Xu - IT 50

I have two Synapse Analytics workspaces. One of them has had an error notice recently when we create a Serverless SQL view, the VIEW returns 'AjaxError:null', I can confirm my SQL query is right and it successfully gets a view on the other workspace. User's image

Now, all my VIEWs are getting the same error, does anybody know how to resolve that?

Justin-1307 0 Reputation points

2024-01-17T22:22:08.58+00:00

I am running into the same issue. I believe the error exists on Microsoft's end. My Views suddenly quit working as of today.
Goldman, Joshua 0 Reputation points

2024-01-19T16:38:43.0833333+00:00

I have the same exact problem that recently stated. I can query the view and see that the data is in there, but when I try to expand the columns, I get that exact issue.

Accepted answer

1 additional answer

Your answer

Justin-1307 0 Reputation points

2024-01-17T22:22:08.58+00:00

I am running into the same issue. I believe the error exists on Microsoft's end. My Views suddenly quit working as of today.
Goldman, Joshua 0 Reputation points

2024-01-19T16:38:43.0833333+00:00

I have the same exact problem that recently stated. I can query the view and see that the data is in there, but when I try to expand the columns, I get that exact issue.

Answer 1

KranthiPakala-MSFT 46,642 Microsoft Employee Moderator

@Richard Xu - IT , GG, Goldman, Joshua, @Jean Fabrice - Thanks for reaching out here and sorry for your experience because of this issue.

As per my internal investigation, looks like this issue is caused because of recent change in the service side. The respective product team has applied mitigation and confirmed that the issue should be resolved to the end users.
Kindly refresh or reopen Synapse Studio and let me know if you still experience the problem. In case if the issue persists, kindly share your Synapse Workspace location so that I can double check with internal team on the same.

Thank you

Goldman, Joshua 0 Reputation points

2024-01-29T16:28:44.3+00:00

I looked again this morning, and the problem was resolved. Thanks for letting us know!
KranthiPakala-MSFT 46,642 Reputation points Microsoft Employee Moderator

2024-02-02T04:12:21.64+00:00

Thank you for confirming Goldman!

Answer 2

Amira Bedhiafi 33,071 Volunteer Moderator

Sometimes, such errors can be caused by issues with the browser. Try clearing your browser cache and cookies, or using a different browser or a private/incognito window. Check Azure status page to see if there are any reported outages or issues with the Synapse service. Check these old threads : https://stackoverflow.com/questions/71225247/why-can-i-connect-to-a-synapse-serverless-sql-pool-but-cannot-connect-to-a-dedic https://stackoverflow.com/questions/71225247/why-can-i-connect-to-a-synapse-serverless-sql-pool-but-cannot-connect-to-a-dedic

Richard Xu - IT 50 Reputation points

2024-01-18T01:39:26.6133333+00:00

Thanks, Amira, I tried to clean the browser cache and use the private mode to access the Synapse service but I had no lucky. My team member also has the same issues when they access this workspace. I already checked the old threads on the stack over flow, we have no private network connection on the Azure. Do you have any ideas?
Amira Bedhiafi 33,071 Reputation points Volunteer Moderator

2024-01-21T13:50:37.25+00:00

In this case try to open a ticket to the Azure Support team.
https://azure.microsoft.com/en-us/support/create-ticket/
Jean Fabrice 0 Reputation points

2024-01-23T20:12:52.9133333+00:00

Was this resolved ? I am facing the same issue . I have tried to clear the browser cache but still have the same issue where I can't open columns . Getting same error: ajaxError:null
Amira Bedhiafi 33,071 Reputation points Volunteer Moderator

2024-01-23T20:19:52.5033333+00:00

Can you check this thread : https://techcommunity.microsoft.com/t5/azure-synapse-analytics-blog/synapse-workspace-pools-and-on-demand-inaccessible/ba-p/1403485
Goldman, Joshua 0 Reputation points

2024-01-23T20:29:30.03+00:00

I don't think the link you posted is relevant to the the issue. The pool is accessible, but the columns are showing an error.
Amira Bedhiafi 33,071 Reputation points Volunteer Moderator

2024-01-23T20:33:49.0233333+00:00

Read the content/Identification : Network Error when trying to view Database Objects in the workspace
Jean Fabrice 0 Reputation points

2024-01-23T20:39:01.5733333+00:00

The posted link isn't relevant for the issue. I do have access to the pool and I can query all my views and get results back. However when trying to display the columns it fails with ajaxError:null
Goldman, Joshua 0 Reputation points

2024-01-23T20:40:56.1+00:00

Same for me. The view exists, I can access it directly through a query and even reference it in PowerBI. I just get an error when trying to display the columns.
Amira Bedhiafi 33,071 Reputation points Volunteer Moderator

2024-01-23T20:41:17.21+00:00

Can you try with another browser ?
Jean Fabrice 0 Reputation points

2024-01-23T20:45:44.48+00:00

Yes I have tried. All my colleagues are having the same issue so definitely not browser related.
Amira Bedhiafi 33,071 Reputation points Volunteer Moderator

2024-01-23T20:47:41.07+00:00

In this case please open a ticket, the support team will take this in charge : https://azure.microsoft.com/en-us/support/create-ticket/
Goldman, Joshua 0 Reputation points

2024-01-23T20:58:02.5166667+00:00

Same here - just tried in Chrome and got same result.
Amira Bedhiafi 33,071 Reputation points Volunteer Moderator

2024-01-23T21:00:56.5066667+00:00

In this case please open a ticket, the support team will take this in charge : https://azure.microsoft.com/en-us/support/create-ticket/
GG 5 Reputation points

2024-01-25T15:26:28.6333333+00:00

We have the same issue. This issue only occurs in the Synapse Studio UI.

Share via

Azure Synapse Analytics Serverless SQL view return log "Ajaxerror:null"

1 additional answer

Your answer