Error when using Copy Dataverse data into Azure SQL

Question

Error when using Copy Dataverse data into Azure SQL

Henry Choi 0

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,'

Bhargava-MSFT 31,261 Reputation points Microsoft Employee Moderator

2023-04-07T19:50:18.7966667+00:00
Hello Henry Choi, Welcome to the MS Q&A platform. The error message indicates that the filesystem name in your pipeline does not match the pattern ^[$a-z0-9][-a-z0-9]{1,61}[a-z0-9]$, which means it should:

Start with a dollar sign ($) or a lowercase letter (a-z) or a digit (0-9).

Followed by 1 to 61 lowercase letters (a-z), digits (0-9), or hyphens (-).

End with a lowercase letter (a-z) or a digit (0-9).

If you're using dynamic content to generate the filesystem name, ensure the expressions used to generate the name produce a valid file name. I hope this helps. Please let me know if you have any further questions.
Bhargava-MSFT 31,261 Reputation points Microsoft Employee Moderator

2023-04-10T23:30:37.4333333+00:00

Hello Henry Choi, I am checking to see if you got a chance to look into my earlier response.
Henry Choi 0 Reputation points

2023-04-11T01:16:24.2933333+00:00
Hi @Bhargava-MSFT , sorry for the late reply, Hong Kong was on Easter holiday for the last few days, I could not indicate the issue with the filesystem name. Inside the tutorial there is a section ask for Container and Folder,

In the Trigger Run Parameter section, enter the below parameters, and then select OK.

Container: @split(triggerBody().folderPath,'/')[0]

Folder: @split(triggerBody().folderPath,'/')[1]

Could it be due to these 2 lines causing the error message? Thank you very much for your help.
Bhargava-MSFT 31,261 Reputation points Microsoft Employee Moderator

2023-04-13T18:36:17.59+00:00

Hello Henry Choi, I am just checking to see if you have any further questions here.
Bhargava-MSFT 31,261 Reputation points Microsoft Employee Moderator

2023-04-18T19:54:11.4733333+00:00

Hello Henry Choi, I am checking to see if you have any further questions.

2 answers

Your answer

Bhargava-MSFT 31,261 Reputation points Microsoft Employee Moderator

2023-04-07T19:50:18.7966667+00:00

Hello Henry Choi, Welcome to the MS Q&A platform. The error message indicates that the filesystem name in your pipeline does not match the pattern ^[$a-z0-9][-a-z0-9]{1,61}[a-z0-9]$, which means it should:

Start with a dollar sign ($) or a lowercase letter (a-z) or a digit (0-9).

Followed by 1 to 61 lowercase letters (a-z), digits (0-9), or hyphens (-).

End with a lowercase letter (a-z) or a digit (0-9).

If you're using dynamic content to generate the filesystem name, ensure the expressions used to generate the name produce a valid file name. I hope this helps. Please let me know if you have any further questions.
Bhargava-MSFT 31,261 Reputation points Microsoft Employee Moderator

2023-04-10T23:30:37.4333333+00:00

Hello Henry Choi, I am checking to see if you got a chance to look into my earlier response.
Henry Choi 0 Reputation points

2023-04-11T01:16:24.2933333+00:00

Hi @Bhargava-MSFT , sorry for the late reply, Hong Kong was on Easter holiday for the last few days, I could not indicate the issue with the filesystem name. Inside the tutorial there is a section ask for Container and Folder,

In the Trigger Run Parameter section, enter the below parameters, and then select OK.

Container: @split(triggerBody().folderPath,'/')[0]

Folder: @split(triggerBody().folderPath,'/')[1]

Could it be due to these 2 lines causing the error message? Thank you very much for your help.
Bhargava-MSFT 31,261 Reputation points Microsoft Employee Moderator

2023-04-13T18:36:17.59+00:00

Hello Henry Choi, I am just checking to see if you have any further questions here.
Bhargava-MSFT 31,261 Reputation points Microsoft Employee Moderator

2023-04-18T19:54:11.4733333+00:00

Hello Henry Choi, I am checking to see if you have any further questions.

Answer 1

Bhargava-MSFT 31,261 Microsoft Employee Moderator

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.

Awais Aslam 0 Reputation points

2023-05-18T23:51:11.7933333+00:00

did you get solutions to this problem?

Answer 2

KjoniX 26

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

Share via

Error when using Copy Dataverse data into Azure SQL

2 answers

Your answer