NIM006156 for No Product Found

Bug ID Number	NIM006156
Submitted	January 18, 2007
Last Modified	June 5, 2024
Applies to	No Product Found
Version found	9.1
Version Fixed	N/A
Status	Fixed

Description

**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.

Cause

The problem is due to a bug in ArcGIS.

Workaround

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.