Bad Request - The specifed resource name contains invalid characters.
Encountered below error when triggered the pipeline which moves data from SQL to Azure Data Lake Store Gen2 and writes a csv file
You need to use lowercase alphabets also there is support for numbers for providing name to container. There is no such restriction on Directory/ foldername.
Output file was created after correcting the container name.
Error
Activity Copy DataFromSQL failed: ErrorCode=UserErrorFailedBlobFSOperation,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=BlobFS operation failed for: Operation returned an invalid status code 'BadRequest'. Account: 'adls2adf'. FileSystem: 'EMPARCHIVE'. ErrorCode: 'InvalidResourceName'. Message: 'The specifed resource name contains invalid characters.'. RequestId: '8a0437a7-201f-0008-4ac7-1e3e47000000'.,Source=Microsoft.DataTransfer.ClientLibrary,''Type=Microsoft.Azure.Storage.Data.Models.ErrorSchemaException,Message=Operation returned an invalid status code 'BadRequest',Source=Microsoft.DataTransfer.ClientLibrary,'
Why it happened
As can be seen in above image name of container,directory and filename are all in Uppercase, however the error points to the name given to the container i.e. EMPARCHIVE. And it is because uppercase is not yet supported for container name.
What to do
Output file was created after correcting the container name.
Related Post
- Getting Started with Azure Data Factory - CopyData from CosmosDB to SQL
- Getting Started with Azure API Management - Fundamentals
Comments
Post a Comment