Facing error while loading data from oracle to Synapse.

Ganga Keerthi 6 Reputation points
2022-04-01T10:04:39.907+00:00

Facing this error while loading the data from Oracle to Synapse Using ADF. Error[HY000] [Microsoft] [ODBC Oracle Drive Protocol Driver] [Oracle] Unexpected network error. Error[HY000] [Microsoft] [ODBC Oracle Drive Protocol Driver] [Oracle] ORA-12656 Cryptographic Checksum Mismatch. Tried different ways as adding WorkAround, EnableBulkLoad parameters to Oracle connection String but of not use. Could you please suggest.

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,246 questions
{count} votes

3 answers

Sort by: Most helpful
  1. KranthiPakala-MSFT 46,602 Reputation points Microsoft Employee
    2022-04-04T22:21:26.157+00:00

    Hello @Ganga Keerthi ,

    Thanks for the question and using MS Q&A platform.

    As per my understanding, you are receiving the above error message while trying to copy data from Oracle to Synapse using ADF copy activity. Please correct I'm not accurate.

    While doing research on this error, I found the below article related to it. Could you please have a look at this and work with your database administrator concerning the data integrity settings of your Oracle server and see if that helps: Very intermittent copy activity fails with ORA-12656: Cryptographic checksum

    Here is the root cause and workaround discussed in the above article, could you please verify yours and see if that helps:

    189836-image.png

    Below are related helpful docs:

    If the issue still persists, I recommend filing a support ticket for deeper investigation. Do let us know how it goes.

    Thanks

    0 comments No comments

  2. Ganga Keerthi 6 Reputation points
    2022-04-08T06:34:48.097+00:00

    I have tried adding dataintegritylevel=0 in the connection string which solved the issue.

    Thank you for the suggestion. @KranthiPakala-MSFT

    Please close this thread from your end. WIll get back to you if anything required.


  3. 46473808 0 Reputation points
    2023-04-20T17:32:59.7433333+00:00

    For users facing this issue still with dataintegritylevel=0 set in ADF: We have encountered this issue intermittently when ADF is loading large datasets from ORACLE. We have found that the Oracle driver used by ADF has issues with the BINARY_DOUBLE datatype in Oracle. Possibly other datatypes as well that ADF recognizes as Decimal. The workaround we have used is casting these fields to character using Oracle function TO_CHAR(YourColumnName, 'TM') as YourColumnName on the initial queries which has fixed the issue.
    sense that that issue is with the driver having issues with the hash of those columns overloading the buffer or something along those lines

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.