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

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

问题描述:

我正在关注

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.您可以访问https://docs.microsoft.com/en-us/azure/data-factory/control-flow-lookup-activity

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