在参数中选择“作为空值处理"时，现有存储过程活动失败 [英] Existing Store procedure activity is failing when 'Treat as null' is selected in Parameter

问题描述

一些已经正常运行的管道突然失败，特别是存储过程活动失败.

Some pipelines which were already running without an issue, suddenly failed, specially store procedure activities are failing.

对问题进行了分析，发现使用视为空值处理"选项选择了任何参数的存储过程活动失败.所有这些活动在生产中都运行良好.错误消息也很容易引起误解.

The issues were analyzed and found out that the store procedure activity where any parameter has been selected with  'Treat as null' option was failing. All of these activities were working fine in production. Error message was also very misleading.

消息为:"属性"Value"的值无效:"Value是存储过程参数的必需属性\ r \ n参数名称:Value'.，Source =，''Type = System.ArgumentException，Message = Value 是存储过程参数的必需属性\ r \ n参数名称:Value，Source = Microsoft.DataTransfer.ClientLibrary，'，"

Message was : "The value of the property 'Value' is invalid: 'Value is required property of stored procedure parameters\r\nParameter name: Value'.,Source=,''Type=System.ArgumentException,Message=Value is required property of stored procedure parameters\r\nParameter name: Value,Source=Microsoft.DataTransfer.ClientLibrary,'","

我还可以通过简单的sp调用活动来复制相同的问题.

I am also able to replicate the same problem with simple sp calling activity.

需要知道Azure Data Factory(V2)中是否有任何最新版本破坏了这些功能.

Need to know was there any recent release in Azure Data Factory (V2) which breaks these thing.

推荐答案

您好，调试模式有问题，将清除所有空值.但是如果您使用立即触发或触发器来触发它，它将起作用.该修复程序正在进行中，将在本周内发布在PROD中.

Hi, The debug mode has an issue, all null value will be purged. but if you trigger it by using trigger now or triggers, it will work. The fix is ongoing, will be on PROD within this week.

这篇关于在参数中选择“作为空值处理"时，现有存储过程活动失败的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！