ADF问题中的存储过程 [英] Stored procedure in ADF issue

问题描述

从SQL数据库到CosmosDB的增量副本遇到了问题.

I am facing issue with the incremental copy from SQL Database to CosmosDB.

我正在按照

I am following the steps as mentioned in this link . When I debug the pipeline, I am getting the following error:

{"errorCode":"2400"，"message":无法创建Sql Source.请仔细检查连接字符串，存储过程设置为正确的格式. 错误:属性值"的值对于存储过程参数"CurrentTrackingVersion"无效. }

{ "errorCode": "2400", "message": "Cannot create Sql Source. Please double check the connection string, stored procedure are set with correct format. Error: The value of the property 'Value' is invalid for the stored procedure parameter 'CurrentTrackingVersion'.", "failureType": "UserError", "target": "StoredProceduretoUpdateChangeTracking" }

我确实检查了连接字符串的详细信息.我已按照链接中的相同步骤进行操作.但是，我仍然遇到同样的问题.

I did check the connection string details. I have followed the same steps as present in the link. Yet, I am still getting the same issue. 

任何人都可以帮助我解决此问题吗?

Could anyone please help me resolve this issue?

谢谢.

推荐答案

如所描述的错误消息所示，该错误是CurrentTrackingVersion的值.

As the error message described, the error is the value of CurrentTrackingVersion. 

您能否再次检查文档的第13步?

Could you double check step 13 of the doc?

13.切换到存储过程标签，然后执行以下步骤:

13. Switch to the Stored Procedure tab, and do the following steps:

1. 存储过程名称，请选择 Update_ChangeTracking_Version .
2. 导入参数.
3. 在存储过程参数部分中，为参数指定以下值:

1. For Stored procedure name, select Update_ChangeTracking_Version.
2. Select Import parameter.

3. In the Stored procedure parameters section, specify following values for the parameters:

CurrentTrackingVersion TableName

类型
@ {activity('LookupCurrentChangeTrackingVersionActivity').output.firstRow.CurrentChangeTrackingVersion}
@ {activity('LookupLastChangeTrackingVersionActivity').output.firstRow.TableN

Name	Type	Value
CurrentTrackingVersion	Int64	@{activity('LookupCurrentChangeTrackingVersionActivity').output.firstRow.CurrentChangeTrackingVersion}
TableName	String	@{activity('LookupLastChangeTrackingVersionActivity').output.firstRow.TableN

这篇关于ADF问题中的存储过程的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！