question

SirilakshmiVeerapaneni-1115 avatar image
0 Votes"
SirilakshmiVeerapaneni-1115 asked AliYiitMucan-5745 commented

Not able to validate external location because The remote server returned an error: (500) Internal Server Error. (105215)

I am trying to read data from storage account Gen2 via External Table - dedicated sql pool.

I am able to access the storage account files and able to runt he queries absolutely fine for sometime and getting below error all of a sudden.

sqlalchemy.exc.ProgrammingError: (pyodbc.ProgrammingError) ('42000', '[42000] [Microsoft][ODBC Driver 18 for SQL Server][SQL Server]Not able to validate external location because The remote server returned an error: (500) Internal Server Error. (105215) (SQLExecDirectW)')

Could someone please guide what going wrong?

azure-synapse-analyticsazure-storage-accounts
· 2
5 |1600 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Visible to all users

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

PRADEEPCHEEKATLA-MSFT avatar image PRADEEPCHEEKATLA-MSFT ·

Hello @SirilakshmiVeerapaneni-1115,

Thanks for the question and using MS Q&A platform.

How often are you experiencing this error message?

This could be an intermittent issue. I would suggest you re-try again and check if that works.

In case if you getting this error message quite often, please do let me know.

0 Votes 0 ·
PRADEEPCHEEKATLA-MSFT avatar image PRADEEPCHEEKATLA-MSFT ·

Hello @SirilakshmiVeerapaneni-1115,

Just checking in if you have had a chance to see the previous response. We need the following information to understand/investigate this issue further.

0 Votes 0 ·

1 Answer

AliYiitMucan-5745 avatar image
0 Votes"
AliYiitMucan-5745 answered AliYiitMucan-5745 commented

Hi,

We are facing this issue in our recurring jobs too. We had manually restared but error still occurs.

· 1
5 |1600 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Visible to all users

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

AliYiitMucan-5745 avatar image AliYiitMucan-5745 ·

After 10 times failure, it succesfully worked. But we need further investigation and command about it.

0 Votes 0 ·