How can I identify which record is causing "Geodatabase Error: Underlying DBMS error [ORA-01722]"

KeithWeber1 — Tue, 03 Mar 2015 20:14:05 GMT

I have a map service that provides a feature layer that is pointing to an Oracle database table with an SDO_GEOMETRY column. The table has 40k+ records and recently I started seeing the following error in the ArcGIS Server logs.

GeoDatabase Error: Underlying DBMS error [ORA-01722: invalid number][tablename]

I'm not sure how to figure out which record is causing the problem. When I attempt to open the map document containing the feature layer, I only see 135 records, but when I use SQLPlus to query the table from Oracle, everything seems fine. Any suggestions?

The server is ArcGIS Server 10.0 and Oracle is 12c

Re: How can I identify which record is causing "Geodatabase Error: Underlying DBMS error [ORA-01722]"

DusanOstojic — Fri, 17 May 2019 06:39:37 GMT

I know this is an old post, but I have exactly the same issue in ArcMap and strugling with the problem for days.

Does anybody have an idea what can be done in this case?

I am using ArcGIS 10.6 with Oracle 12c.

Thanks in advance

topic How can I identify which record is causing "Geodatabase Error: Underlying DBMS error [ORA-01722]" in ArcGIS Enterprise Questions

How can I identify which record is causing "Geodatabase Error: Underlying DBMS error [ORA-01722]"

Re: How can I identify which record is causing "Geodatabase Error: Underlying DBMS error [ORA-01722]"