Error when using Copy Dataverse data into Azure SQL

Henry Choi 0 Reputation points
2023-04-06T04:32:30.2766667+00:00

Hi all, I have follow this post https://learn.microsoft.com/en-us/power-apps/maker/data-platform/azure-synapse-link-pipelines?tabs=synapse-analytics 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
    2023-04-12T21:08:16.3266667+00:00

    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
    2023-11-19T07:37:46.6833333+00:00

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

    0 comments No comments