Error when using Copy Dataverse data into Azure SQL

Henry Choi 0 Reputation points

Hi all, I have follow this post to create trigger download from Storage Account to Azure SQL. When I manually trigger the flow, the following error appears: Operation on target Copy StatusMetadata failed: ErrorCode=AdlsGen2OperationFailed,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=ADLS Gen2 operation failed for: 'filesystem' does not match expected pattern '^[$a-z0-9][-a-z0-9]{1,61}[a-z0-9]$'.. Account: 'XXXXXXXXX'. FileSystem: '@split(triggerBody().folderPath,''. Path: '')[0]/@split(triggerBody().folderPath,'/')[1]/OptionsetMetadata/StatusMetadata.csv'..,Source=Microsoft.DataTransfer.ClientLibrary,''Type=Microsoft.Rest.ValidationException,Message='filesystem' does not match expected pattern '^[$a-z0-9][-a-z0-9]{1,61}[a-z0-9]$'.,Source=Microsoft.DataTransfer.ClientLibrary,'

Azure SQL Database
Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,484 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,776 questions
{count} votes

2 answers

Sort by: Most helpful
  1. BhargavaGunnam-MSFT 27,661 Reputation points Microsoft Employee

    Hello Henry Choi, Correct, The error message indicates that the file system name is being constructed using expressions like @split(triggerBody().folderPath,'/')[0] and @split(triggerBody().folderPath,'/')[1]. Most likely that these expressions are not generating a valid file system name. To resolve this issue, please double-check the value of triggerBody().folderPath and make sure it contains a valid file system name. If needed, please adjust the expressions used to extract the file system name from the folder path. I hope this helps.

  2. KjoniX 26 Reputation points

    I am stucked with the same problem. Did you solve this?

    0 comments No comments