Skip to content

Files

44 lines (31 loc) · 2 KB

connector-troubleshoot-oracle.md

File metadata and controls

44 lines (31 loc) · 2 KB
title titleSuffix description author ms.service ms.subservice ms.topic ms.date ms.author ms.custom
Troubleshoot the Oracle connector
Azure Data Factory & Azure Synapse
Learn how to troubleshoot issues with the Oracle connector in Azure Data Factory and Azure Synapse Analytics.
jianleishen
data-factory
data-movement
troubleshooting
10/01/2021
jianleishen
has-adal-ref, synapse

Troubleshoot the Oracle connector in Azure Data Factory and Azure Synapse

[!INCLUDEappliesto-adf-asa-md]

This article provides suggestions to troubleshoot common problems with the Oracle connector in Azure Data Factory and Azure Synapse.

Oracle

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?.

Next steps

For more troubleshooting help, try these resources: