Getting error while loading data from Oracle database to Oracle database in Azure data factory

Suma Nvss Toyyeti01 0 Reputation points
2023-05-01T02:55:25.7166667+00:00

While loading data from Oracle database to Oracle database) i am getting error Failure happened on 'Sink' side. ErrorCode=UserErrorOdbcOperationFailed,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=ERROR [HY000] [Microsoft][ODBC Oracle Wire Protocol driver][Oracle]ORA-00604: error occurred at recursive SQL level 1 ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired Error in parameter 1.,Source=Microsoft.DataTransfer.ClientLibrary.Odbc.OdbcConnector,''Type=Microsoft.DataTransfer.ClientLibrary.Odbc.Exceptions.OdbcException,Message=ERROR [HY000] [Microsoft][ODBC Oracle Wire Protocol driver][Oracle]ORA-00604: error occurred at recursive SQL level 1 ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired Error in parameter 1.,Source=msora28.dll,'

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
8,507 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. ShaikMaheer-MSFT 35,796 Reputation points Microsoft Employee
    2023-05-08T16:05:41.1833333+00:00

    Hi Suma Nvss Toyyeti01,

    Thank you for posting query in Microsoft Q&A Platform.
    Kindly try below and see if that helps.

    • Check if there are any other processes that are currently accessing the same resource. If so, you may need to wait for them to finish before attempting to access the resource again.
    • If there are no other processes accessing the resource, you can try increasing the timeout value for the operation. This can be done by modifying the connection string used to connect to the Oracle database.
    • You can also try disabling the NOWAIT option for the operation. This can be done by modifying the query used to load data from the source database.

    Hope this helps. Please let me know if any further queries.

    Please consider hitting Accept Answer button. Accepted answers help community as well. Thank you.

    1 person found this answer helpful.
  2. Vinodh247 7,416 Reputation points
    2023-05-01T10:27:47.87+00:00

    Hi

    Thanks for reaching out to Microsoft Q&A.

    The error mentions ODBC many times but I think its not the real culprit. If it is so you wouldn't have been able to connect the source & sink from the pipeline in the first place.

    The table you are trying load data in the sink has a current uncommitted transaction due to which it is locked. When you try to fire another query when the former is still active you will receive this error.

    [Oracle]ORA-00604: error occurred at recursive SQL level 1 ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired

    Check the below link which confirms the same.

    https://stackoverflow.com/questions/4842765/ora-00054-resource-busy-and-acquire-with-nowait-specified-or-timeout-expired

    If the above doesn't help, I suggest you to raise a support case with Microsoft.

    Please Upvote and Accept as answer if the reply was helpful, this will be helpful to other community members.

    0 comments