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:
Below are related helpful docs:
- https://docs.progress.com/bundle/datadirect-oracle-odbc-80/page/Data-Integrity-Level.html
- https://docs.progress.com/bundle/datadirect-oracle-odbc-80/page/Encryption-Level.html
If the issue still persists, I recommend filing a support ticket for deeper investigation. Do let us know how it goes.
Thanks