getting Failure happened on 'Source' side. ErrorCode=UserErrorOdbcOperationFailed,

Question

I am getting this error while perform incremental data loading from oracle database to azure datalake storage

Failure happened on 'Source' side. ErrorCode=UserErrorOdbcOperationFailed,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=ERROR [HY000] [Microsoft][ODBC Oracle Wire Protocol driver][Oracle]ORA-01821: date format not recognized

,Source=Microsoft.DataTransfer.ClientLibrary.Odbc.OdbcConnector,''Type=System.Data.Odbc.OdbcException,Message=ERROR [HY000] [Microsoft][ODBC Oracle Wire Protocol driver][Oracle]ORA-01821: date format not recognized

,Source=msora28.dll,'

Any ideas how to solve this?

thanks!

Answer 1

@Thumati madhu The error message you’re encountering, ORA-01821: date format not recognized, indicates that there’s an issue with the date format in your query.

The date format you’re using is not recognized by Oracle. Oracle’s TO_DATE function expects a valid format model to interpret the input string correctly. You need to adjust your date format to match the ISO 8601 format with fractional seconds and time zone information.

Refer to this post: https://stackoverflow.com/questions/39164692/ora-01821-date-format-not-recognized-error-for-iso-8601-date-with-local-time

Additional Reading: https://stackoverflow.com/questions/40569080/error-ora-01821-date-format-not-recognized

https://stackoverflow.com/questions/61059772/ora-01821-date-format-not-recognized

Also, ensure that you have the ODBC driver installed. Link to download Microsoft ODBC driver is: https://www.microsoft.com/en-in/download/details.aspx?id=40886
Once the installation or Upgrade completes, consider restarting system.