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

[mkj1213]

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

[abhi21pura]

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.

[Anonymous · Accepted solution]

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.