- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Cannot find supported delta type for logical type TimeSpan
Hello
Trying to use Copy Activity to copy data from Azure SQL Server to DataLake via Pipeline.
Most of the tables are successful but some failed with the following error:
Activity failed because an inner activity failed; Inner activity name: Copy_s2q, Error: ErrorCode=DeltaNotSupportedLogicalType,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=The logical type TimeSpan is not supported in Delta format. Reason: Cannot find supported delta type for logical type TimeSpan,Source=Microsoft.DataTransfer.ClientLibrary,'
Any ideas on where to start looking to troubleshoot?
Output from CopyActivity:
{
"copyDuration": 9,
"errors": [{ "Code": 21450, "Message": "ErrorCode=DeltaNotSupportedLogicalType,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=The logical type TimeSpan is not supported in Delta format. Reason: Cannot find supported delta type for logical type TimeSpan,Source=Microsoft.DataTransfer.ClientLibrary,'", "EventType": 0, "Category": 5, "Data": {}, "MsgId": null, "ExceptionType": null, "Source": null, "StackTrace": null, "InnerEventInfos": [] } ],
"usedDataIntegrationUnits": 4,
"usedParallelCopies": 1,
"executionDetails": [{ "source": {"type": "AzureSqlDatabase","region": "North Europe" },
"sink": { "type": "Lakehouse" },
"status": "Failed",
"start": "7/11/2023, 12:33:06 PM",
"duration": 9,
"usedDataIntegrationUnits": 4,
"usedParallelCopies": 1,
"profile": { "queue": { "status": "Completed", "duration": 6 }, "transfer": { "status": "Completed", "duration": 3 } },
"detailedDurations": { "queuingDuration": 6, "transferDuration": 3 } } ],
"dataConsistencyVerification": { "VerificationResult": "Unsupported" }
}
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Would you mind filling a support case for this? We'll need engineering to track this one down. Thank you!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi there,
Did this issue ever get looked at as I've hit the same error with a 'Timespan' source column. Even if try to cast the column as a varchar or even remove the Timespan column from the SELECT statement, I still hit the same error: "Cannot find supported delta type for logical type TimeSpan"
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hey there DaveM92,
After chatting to the support team, they advised mapping the data type to a 'string' as part of the initial load.
In the copy wizard, on the mapping tab, I manually assigned the data type. Thankfully I only have 3 tables that this affects, so not a train smash, but not ideal either.

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
03-20-2024 02:57 PM | |||
10-12-2024 06:44 PM | |||
10-24-2024 08:48 AM | |||
12-04-2024 12:38 AM | |||
11-04-2024 10:47 AM |
User | Count |
---|---|
9 | |
8 | |
7 | |
6 | |
4 |