MetricSign
EN|NLRequest Access
Medium severityfabric

Power BI Refresh Error:
ArgumentOutOfRangeException

What does this error mean?

A copy pipeline reading from Oracle via Fabric Data Factory failed because an Oracle DateTime value is outside the range supported by Azure Data Factory and Synapse (0001-01-01 to 9999-12-31). Oracle supports BC-era dates and second values above 59 which have no equivalent in .NET DateTime.

Common causes

  • 1Oracle table contains BC-era dates (year < 1) which cannot be represented in .NET DateTime
  • 2Oracle stores second or minute values greater than 59 (valid in Oracle, invalid in .NET)
  • 3Source table has historical data loaded from legacy systems with non-standard date representations
  • 4DateTime columns were not validated when data was loaded into Oracle

How to fix it

  1. 1Run SELECT dump(<column_name>) FROM <table> in Oracle SQL Developer to inspect the raw byte values of problematic DateTime fields

Beyond the docs

Common practitioner solutions not covered in the official documentation.

  1. 1Identify rows with out-of-range dates using: SELECT * FROM <table> WHERE <date_col> < DATE '0001-01-01'
  2. 2Cast the Oracle DateTime column to VARCHAR in the copy source query to bypass the conversion: TO_CHAR(<col>, 'YYYY-MM-DD HH24:MI:SS')
  3. 3Filter out or replace known out-of-range values at the source query level before they reach the copy sink
  4. 4If BC dates are business-critical, consider a custom transformation step before loading into the target

Official documentation: https://learn.microsoft.com/en-us/fabric/data-factory/connector-troubleshoot-oracle

Other fabric errors