BUG

When zooming in to large scale and when features are created outside of the current extent, labels disappear on SQL created features

Last Published: April 25, 2020

Description

After inserting features using SQL (e.g., using an ST_GEOMETRY or SDO_GEOMETRY operator) and attempting to label the inserted features in ArcMap, the feature's labels disappear when zooming in to a large scale. This behavior occurs when the inserted features exist beyond the feature class extent. The issue impacts feature classes with ST_GEOMETRY or SDO_GEOMETRY storage types.For example:

Code:
DECLARE
v_registation_id number(8);
v_srid NUMBER(8);BEGIN SELECT registration_id INTO v_registation_id
FROM sde.table_registry
WHERE table_name = 'POLES'; SELECT srid INTO v_srid
FROM SDE.st_geometry_columns
WHERE (owner = USER AND table_name = 'POLES'); INSERT INTO roads (OBJECTID,LABEL,SHAPE) VALUES
(sde.version_user_ddl.next_row_id(USER, v_registation_id),
'ID_298',
sde.st_geometry('POINT ( 9689097.37142934 4423553.842365312)', v_srid)); COMMIT;

Cause

When inserting features with SQL (e.g., using ST_GEOMETRY or SDO_GEOMETRY operators), the feature class' extent is not automatically updated or expanded to include the new feature.

Workaround

After inserting features with SQL, recalculate the layer's extent by using the ArcSDE command sdelayer -o alter -E calc.

For example:
Code:
sdelayer -o alter -E calc -l poles,shape -i esri_sde -u username -p password

    Article ID:000010688

    Software:
    • Legacy Products

    Get help from ArcGIS experts

    Contact technical support

    Download the Esri Support App

    Go to download options

    Discover more on this topic