Getting error ora-01843 with Oracle geodatabase

02-03-2021 11:34 AM
Labels (1)
New Contributor II

We are using ArcGIS Enterprise 10.8.1 (single machine deployment) and have an Oracle 12c enterprise geodatabase on a separate server. We receive an error in the server log whenever we enter a record with a date: Error: Underlying DBMS error [ORA-01843: not a valid month] [UST_Inspections]

We created the dataset from ArcGIS Pro (2.7 if that matters) and we are using the default date field type, but there seems to be a mismatch on the backend.

Any ideas on how to fix this?

EDIT: This error only appears when editor tracking turned on. When it's off and there are dates in the other date fields, everything works as it should.

0 Kudos
0 Replies