Share via

Urgent Help Needed – Error After Upgrading Oracle Linked Service to 2.0

Thalluri, Srinivas Yaswanth 0 Reputation points
2025-12-04T10:38:25.2833333+00:00

I’m running into a critical issue after switching from the Oracle Linked Service 1.0 to 2.0. Everything worked fine before the upgrade. Now my pipeline fails on the Sink side with the following error:

Failure happened on 'Sink' side. ErrorCode=SqlOperationFailed,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=A database operation failed. Please search error to get more details.,Source=Microsoft.DataTransfer.ClientLibrary,''Type=System.ArgumentOutOfRangeException,Message=Specified argument was out of the range of valid values.

Parameter name: value,Source=Microsoft.DataTransfer.DataContracts,'

Has anyone experienced this after upgrading? Any guidance or quick solution would be greatly appreciated. I’m trying to resolve this urgently.

Thanks in advance!

Srinivas

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
Answer accepted by question author
  1. Manoj Kumar Boyini 1,250 Reputation points Microsoft External Staff Moderator
    2025-12-04T14:24:32.49+00:00

    Hi Thalluri, Srinivas Yaswanth,

    Please update your SHIR to version 5.56 or above. In these versions, Oracle V2 allows you to customize the precision and scale for Oracle NUMBER types in the copy source (as shown in the screenshot).
    Picture1.png

    Please let us know if you have any questions and concerns.

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.