查找错误:不支持数据类型ByteArray

本文介绍了查找错误:不支持数据类型ByteArray的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

我正在关注 文档以逐步从SQL Server的多个表中加载数据.

I'm following this documentation to Incrementally load data from multiple tables in SQL Server.

我们正在使用MS更改数据捕获(CDC)，因此我们的高水位标记是最大lsn.查找运行:选择sys.fn_cdc_get_max_lsn()AS max_lsn

We are using MS Change Data Capture (CDC) so our high watermark is the max lsn. The lookup runs: select sys.fn_cdc_get_max_lsn() AS max_lsn

"

How can we use the lookup to get the high watermark for each of the tables processed?

以下是来自ADF的错误:

Below is the error from ADF:

消息":"ErrorCode = DataTypeNotSupported，类型= Microsoft.DataTransfer.Common.Shared.HybridDeliveryException，消息=列:max_lsn，数据类型不支持ByteArray.，Source =，'''， "ExceptionMessage":"ErrorCode = DataTypeNotSupported，'Type = Microsoft.DataTransfer.Common.Shared.HybridDeliveryException，Message = Column:max_lsn，不支持数据类型ByteArray.，Source =，'''， "ExceptionType":"Microsoft.DataTransfer.Execution.Core.ExecutionException"， "StackTrace":在System.Web.Http.Filters.ActionFilterAttribute.d__1.MoveNext()\ r \ n ---从上一个引发异常的位置开始的堆栈结束跟踪

"Message": "ErrorCode=DataTypeNotSupported,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Column: max_lsn,The data type ByteArray is not supported.,Source=,'", "ExceptionMessage": "ErrorCode=DataTypeNotSupported,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Column: max_lsn,The data type ByteArray is not supported.,Source=,'", "ExceptionType": "Microsoft.DataTransfer.Execution.Core.ExecutionException", "StackTrace": " at System.Web.Http.Filters.ActionFilterAttribute.d__1.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown

推荐答案

Lookup当前不支持ByteArray.您可以访问docs.microsoft/en-us/azure/data-factory/control-flow-lookup-activity

The ByteArray is currently not supported in Lookup. You may check limit atdocs.microsoft/en-us/azure/data-factory/control-flow-lookup-activity