数据工厂中的U-SQL作业失败 [英] U-SQL Job Failing in Data Factory

问题描述

每当我运行 U-SQL作业

Job submission failed, the user 'adla account name' does not have permissions to a subfolder in the /system/ path needed by Data Lake Analytics. Please run "Add User Wizard" from the Data Lake Analytics Azure Portal or use Azure PowerShell to grant access for the user to the /system/ and its children on the Data Lake Store.

并且我没有按照本文中的建议使用任何防火墙:

And I am not using any Firewall as suggested in this post:

运行U-SQL脚本从使用Azure数据工厂的C#代码中获取

我正在使用Azure Data Lake Store服务主体身份验证.当我从Visual Studio启动作业时，它也可以正常工作.

I am using the Azure Data Lake Store service principal authentication. When I start the Job from Visual Studio, it also works fine.

我将不胜感激...

谢谢

推荐答案

这听起来像是权限问题.您可以运行以下powershell脚本来确保已对安全主体应用了适当的权限:

It does sound like a permissions problem. You can run this powershell script to ensure you have applied the proper permissions to the security principal:

Login-AzureRmAccount
$appname = "adla"
$dataLakeStoreName = "yourdatalakename"

$app = Get-AzureRmADApplication -DisplayName $appname

$servicePrincipal = Get-AzureRmADServicePrincipal  -SearchString $appname

Set-AzureRmDataLakeStoreItemAclEntry -AccountName $dataLakeStoreName -Path / -AceType User -Id $servicePrincipal.Id -Permissions All

Set-AzureRmDataLakeStoreItemAclEntry -AccountName $dataLakeStoreName -Path /system -AceType User -Id $servicePrincipal.Id -Permissions All

如果您想使用Powershell脚本从头开始创建所有内容，请访问以下博客，以帮助您:

If you want to create everything from scratch using a powershell script, here is a blog that will help you:

http://dyor.com/setting-up-an-azure-data-lake-and-azure-data-factory-using-powershell/

这篇关于数据工厂中的U-SQL作业失败的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！