查找错误:不支持数据类型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