Error Code:2200 microsoft.windowsazure.storage,storageextendedmessage=0:one of the request inputs is out of range

jay marathe 41

I am copying data from Azure Database to Azure Storage Table using ADF Copy activity.Able to copy 50% of data and then it failed saying 'Error Code:2200 microsoft.windowsazure.storage,storageextendedmessage=0:one of the request inputs is out of range'.I tried checking all the data but as the data contain more than 3LACs record not sure where it is getting failed.The error is also not giving proper information where it is failing.Does anyone faces this issue or can anyone guide me where to look into.
Thanks

1 answer

BhargavaGunnam-MSFT 25,971 Reputation points Microsoft Employee

2022-11-09T23:00:39.287+00:00

Hello @jay marathe ,
Welcome to the MS Q&A platform.
Could you please let us know if this is an intermittent issue or if this issue is happening whenever trying to copy the data from the Azure database to Azure table Storage?
When you say "able to copy 50% of data", is this failing every time at the same records to copy?
This error generally occurs if there is any issue with the storage account or blob name.

Please take a look at this naming rules.
Please sign in to rate this answer.
BhargavaGunnam-MSFT 25,971 Reputation points Microsoft Employee

2022-11-15T00:04:54.737+00:00

Hello @jay marathe ,
I am just checking to see if you got a chance to look into my above response.

jay marathe 41 Reputation points

2022-11-22T17:39:55.85+00:00

No still having the issue. This is intermittent issue. I am not sure where it is actually failing as there is no proper message in the error code. Error message doesn't contain any column name from which I can rectify issue. I am trying to load the data as per the date column to rectify the issue. The table from which I am copying is contains new data like incremental data and after some days I am deleting records also based on the some condition.
There is no issue in storage account or blob name.
Either I have to find that record which having the issue or have to wait for that particular record to get delete as I am deleting some records after some days based on condition.

BhargavaGunnam-MSFT 25,971 Reputation points Microsoft Employee

2022-11-22T19:30:06.3+00:00

Hello @jay marathe ,
Sorry to hear that you are still facing the issue. My understanding from your above comment is that this is a data issue. You do not see the error when that particular record gets deleted.
And the error message doesn't show which column/record has the issue.
As the next steps, I would suggest filing a support request, and a support engineer can take a deeper look to troubleshoot the issue further. If you don't have a support plan, I can enable one-time free support for you to work closely on this matter.
I am looking forward to hearing from you.
Sign in to comment