While performing copy activity in ADF from Oracle On prim to ADLS I am getting the below error

Samarth Mishra 1 Reputation point
2022-08-31T14:41:00.747+00:00

Failure happened on 'Source' side. ErrorCode=UserErrorUnclassifiedError,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Odbc Operation Failed.,Source=Microsoft.DataTransfer.ClientLibrary.Odbc.OdbcConnector,''Type=System.Data.Odbc.OdbcException,Message=ERROR [22018] [Microsoft][ODBC Oracle Wire Protocol driver][Oracle]ORA-01722: invalid number ,Source=msora28.dll,'

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
6,643 questions
{count} votes

1 answer

Sort by: Most helpful
  1. AnnuKumari-MSFT 20,996 Reputation points Microsoft Employee
    2022-09-02T05:13:53.167+00:00

    Hi @Samarth Mishra ,

    Welcome to Microsoft Q&A platform and thanks for posting your questions.

    As I understand your query, you are trying to copy data from Oracle on premise to Azure datalake storage. However, you are getting the above stated error and are looking for the mitigation. Please let me know if my understanding is incorrect.

    The ORA-01722 message is a fairly typical error in Oracle. It is an “invalid number” error, occurring during a failure when converting a character string to a valid number. While this type of error can be an easy fix, it can be caused by a multitude of numerical mistakes.

    • The first step in resolving this error is first keeping in mind what a valid number in Oracle represents. Valid numbers will contain the digits zero through nine, and can contain specific characters such as +/- at the beginning or end of the string, a single decimal point or an ‘E’ (upper or lower case) for floating point numbers in scientific notation. You should double check the character strings in the expression in question to make sure that the numbers follow these precise rules.
    • There are ways to fix this problem, with the first looking at an “INSERT INTO… VALUES (…)” attempt. Go through the steps above; check the data you are entering to make sure the numerical values are in line, and correct any that are invalid. In the event that all of the numbers are valid, the error possibly occurred from your columns being out of order (resulting in a VALUES string being placed into a NUMBER column, often deriving from removing or adding columns to a table).

    For more details, kindly check the following resources: ORA-01722 ERROR MESSAGE
    ORA-01722: invalid number error

    Hope this will help. Please let us know if any further queries.

    ------------------------------

    • Please don't forget to click on 130616-image.png or upvote 130671-image.png button whenever the information provided helps you.
      Original posters help the community find answers faster by identifying the correct answer. Here is how
    • Want a reminder to come back and check responses? Here is how to subscribe to a notification
    • If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators