This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(115.19999999999999, 41%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP%3C/text%3E%3C/svg%3E)
Hi, inside an Azure Data Factory instance I've implemented a pipeline to copy data from a Synapse SQL pool to an Oracle db on premise. I need to copy a Synapse table having 260 columns and more of three millions of rows. For the copy activity I've enabled the staging. When I run the pipeline I've this error message:
ErrorCode=UserErrorOdbcOperationFailed,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=ERROR [HY000] [Microsoft][ODBC Oracle Wire Protocol driver][Oracle]ORA-39776: fatal Direct Path API error loading table "DWH"."xxxxxx"> ORA-03137: malformed TTC packet from client rejected: [klaprs_11] [60] [512] [3] [4] [573] [] []> ,Source=Microsoft.DataTransfer.ClientLibrary.Odbc.OdbcConnector,''Type=Microsoft.DataTransfer.ClientLibrary.Odbc.Exceptions.OdbcException,Message=ERROR [HY000] [Microsoft][ODBC Oracle Wire Protocol driver][Oracle]ORA-39776: fatal Direct Path API error loading table "DWH"."xxxxxx"> ORA-03137: malformed TTC packet from client rejected: [klaprs_11] [60] [512] [3] [4] [573] [] []> ,Source=msora28.dll,'
Any helps to me, please? Thanks
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(54.400000000000006, 38%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EQ%3C/text%3E%3C/svg%3E)
pmscorca Thanks for sharing the error message.
Looks like we may need much more information over here to understand what's going on!
We may need further details!
I need to copy a Synapse table having 260 columns and more of three millions of rows.
Could you please check if the same error is encountered with less volume?
Is there any SHIR being used here?
Any timeouts experienced which the client is rejected, can try increasing the timeout!!!
Hi,
I've the same error also for 600 data rows.
I need to write on an Oracle db on-premises and so the Oracle linked service uses a SHIR.
@pmscorca Where is the SHIR installed?
Is the SHIR and Oracle DB on a same VM?
Hi,
the on premise Oracle database is installed on a local server.
The SHIR is installed on another local vm.
Hi,
I've solved the issue by specifying these additional connection properties for the Oracle linked service. In particular, it is important the EnableBulkLoad property:
I hope the all possible connection properties of the Oracle connector in ADF could be well documented from Microsoft!
Thanks
pmscorca Thank you for sharing the solution on this forum, we will revisit the Documentation.