Displaying Flow Direction for a geometric network causes the following error: Underlying DBMS error[ORA-00904: "SHAPE"."LEN": invalid identifier]

Last Published: April 25, 2020


**This issue has been resolved in ArcGIS 9.3.1 Service Pack 2.**

When displaying a geometric network classes' Flow Direction when the feature class is stored using Oracle's sdo_geometry, the following error displays:

"One or more layers failed to draw:
Underlying DBMS error[ORA-00904: "SHAPE"."LEN": invalid identifier]".

The name of the edge feature class may be appended to the end of the error message. The underlying DBMS error may also be listed several times.


The problem is due to a bug in ArcGIS.


Change the storage type; for example, use ESRI's spatial type for Oracle, st_geometry.

This is not an issue when using SDEBINARY or st_geometry storage types because the shape.len attribute is persisted as a property of the geometry.

    Article ID:000010244

    • ArcMap 9 x
    • ArcMap 8 x

    Get help from ArcGIS experts

    Contact technical support

    Download the Esri Support App

    Go to download options

    Related Information

    Discover more on this topic