Error in read parquet files from extrenal storage with Synapse Analytics

Question

Error in read parquet files from extrenal storage with Synapse Analytics

Shlomi Lanton 6

Hey,

I'm using Synapse Analytics to query parquet files in blob storage. once every few queries (could be the exact same query), I get the error

Error handling external file: 'IO request completed with an error. ERROR = 0x0000000C'. File/External table name: 'https://xxxx.blob.core.windows.net/container/service_id=1111/month=10/partition_version=last/part-0.parquet'.

Note that it could be that the file is been updated while the query is running. Could it be the cause for this error? What can I do to prevent it?

Thanks

PRADEEPCHEEKATLA-MSFT 59,336 Reputation points Microsoft Employee

2022-11-01T09:51:58.567+00:00
Hello @Shlomi Lanton ,

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

Could you please confirm the below details for further investigation:

Are you quering using SQL serverless or dedicated pool?

How often you are experiencing this error message?

After you recieve this error message - does re-try works?

Please do share the screenshot of the query along with the error message which you are experiencing?
Shlomi Lanton 6 Reputation points

2022-11-02T08:51:09.737+00:00
Serverless
2+ 3. Every few queries, in most cases if I ran the query again it will pass 4. Will try to create one, but we have sensitive info in the query, I shared all the error message I got
PRADEEPCHEEKATLA-MSFT 59,336 Reputation points Microsoft Employee

2022-11-07T05:34:58.887+00:00

Hello @Shlomi Lanton ,

You can hide the sentive info and share the detailed stacktrace of the error message?
PRADEEPCHEEKATLA-MSFT 59,336 Reputation points Microsoft Employee

2022-11-14T09:43:47.607+00:00

Hello @Shlomi Lanton ,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others . Otherwise, will respond with more details and we will try to help.

PRADEEPCHEEKATLA-MSFT 59,336 Reputation points Microsoft Employee

2022-11-01T09:51:58.567+00:00

Hello @Shlomi Lanton ,

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

Could you please confirm the below details for further investigation:

Are you quering using SQL serverless or dedicated pool?

How often you are experiencing this error message?

After you recieve this error message - does re-try works?

Please do share the screenshot of the query along with the error message which you are experiencing?
Shlomi Lanton 6 Reputation points

2022-11-02T08:51:09.737+00:00

Serverless
2+ 3. Every few queries, in most cases if I ran the query again it will pass 4. Will try to create one, but we have sensitive info in the query, I shared all the error message I got
PRADEEPCHEEKATLA-MSFT 59,336 Reputation points Microsoft Employee

2022-11-07T05:34:58.887+00:00

Hello @Shlomi Lanton ,

You can hide the sentive info and share the detailed stacktrace of the error message?
PRADEEPCHEEKATLA-MSFT 59,336 Reputation points Microsoft Employee

2022-11-14T09:43:47.607+00:00

Hello @Shlomi Lanton ,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others . Otherwise, will respond with more details and we will try to help.

Error in read parquet files from extrenal storage with Synapse Analytics

Activity