Troubleshoot the Oracle connector in Azure Data Factory and Azure Synapse
APPLIES TO: Azure Data Factory Azure Synapse Analytics
Tip
Try out Data Factory in Microsoft Fabric, an all-in-one analytics solution for enterprises. Microsoft Fabric covers everything from data movement to data science, real-time analytics, business intelligence, and reporting. Learn how to start a new trial for free!
This article provides suggestions to troubleshoot common problems with the Oracle connector in Azure Data Factory and Azure Synapse.
Error code: ArgumentOutOfRangeException
Message:
Hour, Minute, and Second parameters describe an un-representable DateTime.
Cause: In Azure Data Factory and Synapse pipelines, DateTime values are supported in the range from 0001-01-01 00:00:00 to 9999-12-31 23:59:59. However, Oracle supports a wider range of DateTime values, such as the BC century or min/sec>59, which leads to failure.
Recommendation:
To see whether the value in Oracle is in the supported range of dates, run
select dump(<column name>)
.To learn the byte sequence in the result, see How are dates stored in Oracle?.
Add secure algorithms when using the self-hosted integration runtime version 5.36.8726.3 or higher
Symptoms: When you use the self-hosted integration runtime version 5.36.8726.3 or higher, you meet this error message:
[Oracle]ORA-12650: No common encryption or data integrity algorithm
.Cause: The secure algorithm is not added to your Oracle server.
Recommendation: Update your Oracle server settings to add these secure algorithms:
The following algorithms are deemed as secure by OpenSSL, and will be sent along to the server for OAS (Oracle Advanced Security) encryption.
- AES256
- AES192
- 3DES168
- AES128
- 3DES112
- DES
The following algorithms are deemed as secure by OpenSSL, and will be sent along to the server for OAS (Oracle Advanced Security) data integrity.
- SHA256
- SHA384
- SHA512
Related content
For more troubleshooting help, try these resources:
משוב
https://aka.ms/ContentUserFeedback.
בקרוב: במהלך 2024, נפתור בעיות GitHub כמנגנון המשוב לתוכן ונחליף אותו במערכת משוב חדשה. לקבלת מידע נוסף, ראה:שלח והצג משוב עבור