ADF失败:功能“长度”期望它的参数是数组或字符串 [英] ADF Failure: Function "Length" expects its parameter to be array or string
问题描述
我正在尝试练习下面的教程,面对第二个管道上的错误消息[ IterateAndCopySQLTables ] 。
根据下面的教程,我创建了Array类型参数"tableList"。在这里寻求帮助。
https://docs.microsoft.com/en -us / azure / data-factory / tutorial-bulk-copy-portal#create-the-pipeline-iterateandcopysqltables
Activity IterateSQLTables失败:函数'length'要求其参数为数组或字符串。提供的值为'Null'类型。
你好,
调用ForEach活动时,该参数看起来没有任何值。
要缩小到确切的问题,我建议确保以下内容:
- 设置参数"tableList"时在管道"IterateAndCopySQLTables"中,类型设置为"Array"。
- 在forEach活动中,设置选项卡中的项目设置为"tableList"。格式为" @ pipeline()。参数强> .tableList" ;.
( 看起来文档中有拼写错误,它表示参数而不是参数)- 查询活动中的查询是正确的(您可以使用SQL Server Management Studio或使用查询编辑器在门户上测试它。
- 在InvokePipeline活动的参数中,参数tableList设置为@activity('LookupTableList')。output.value。
I am trying to practice the below tutorial, facing below error message on second pipeline [IterateAndCopySQLTables ]. As per below tutorial, I have created parameter of type Array "tableList". Seeking help here.
https://docs.microsoft.com/en-us/azure/data-factory/tutorial-bulk-copy-portal#create-the-pipeline-iterateandcopysqltables
Activity IterateSQLTables failed: The function 'length' expects its parameter to be an array or a string. The provided value is of type 'Null'.
Hi there,
Looks like the parameter doesn't hold any value when the ForEach activity is invoked.
To narrow down to the exact issue, I would recommend making sure the following things are in place :
- When setting parameter "tableList" in the pipeline "IterateAndCopySQLTables", the type is set to "Array".
- In the forEach activity, the Items in the settings tab is set to "tableList" in the format "@pipeline().parameters.tableList". (Looks like there's a typo in the doc, it says parameter instead of parameters)
- The query in the Lookup Activity is correct (you can test it using SQL Server Management Studio or on the portal using query editor.
- In the parameters for the InvokePipeline activity, the parameter tableList is set to @activity('LookupTableList').output.value.
这篇关于ADF失败:功能“长度”期望它的参数是数组或字符串的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!