Forum Discussion

mkj1213's avatar
mkj1213
Helper II
2 years ago
Solved

MashupException.Error: Oracle: ORA-03135: connection lost contact

Hello i am trying to write a table from an Oracle database to a table in the lakehouse using a Dataflow Gen2, however i am getting the following error:
Mashup Exception Data Source Error Couldn't refresh the entity because of an issue with the mashup document MashupException.Error: Oracle: ORA-03135: connection lost contact
 
I had tried to copy the table using a copy activity from the pipeline it had executed in less than 10 mins and this is the ouput of the datapipeline.
 
dataRead": 5888482512, "dataWritten": 509448331, "filesWritten": 3, "sourcePeakConnections": 1, "sinkPeakConnections": 2, "rowsRead": 61295977, "rowsCopied": 61295977, "copyDuration": 496
 
Is it possible that dataflow Gen 2 is not able to handle such volume? Fast copy is not supported for Oracle DB


Dataflows
General Question
Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi mkj1213 ,

     

    For error messages such as ORA-03135, they are usually caused by unexpected or forced termination of the server, server connection timeout, and so on.

    Refer to the following similar solution if it helps you.

    c# - "ORA-03135: connection lost contact" when inserting large file - Stack Overflow

     

    Best Regards,
    Adamk Kong

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • abhi21pura's avatar
    abhi21pura
    New Member
    1 year ago

    Hi mkj1213 ,

    Please can you share if you were able to fix this issue with Dataflow and Oracle.
    We also are facing the a similar issue.