Bug
Labels disappear on SQL created points when zooming in to large scale, when points are created outside of current extent.
| Bug ID Number | NIM045835 |
|---|---|
| Submitted | June 9, 2009 |
| Last Modified | April 2, 2025 |
| Applies to | ArcSDE/Enterprise Geodatabase |
| Version found | 9.3.1 |
| Operating System | Windows OS |
| Operating System Version | XP |
| Version Fixed | 10.1 |
| Status | Fixed |
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
Steps to Reproduce
Bug ID: NIM045835
Software:
- ArcSDE/Enterprise Geodatabase
Get notified when the status of a bug changes
Discover more on this topic
Search for related information
Find training related to this topic
Explore ideas and give feedback
Get help from ArcGIS experts
Download the Esri Support App