topic Re: MashupException.Error: Oracle: ORA-03135: connection lost contact in Dataflow

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

mkj1213 — Thu, 01 Aug 2024 09:24:50 GMT

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

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

Anonymous — Mon, 05 Aug 2024 06:14:16 GMT

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.

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

abhi21pura — Wed, 13 Nov 2024 12:08:35 GMT

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.