NIM084357 for ArcSDE/Enterprise Geodatabase

Bug-ID-Nummer	NIM084357
Eingereicht	September 4, 2012
Zuletzt geändert	April 2, 2025
Gilt für	ArcSDE/Enterprise Geodatabase
Gefunden in Version	10.1
Betriebssystem	Windows OS
Betriebssystemversion	2008 64 Bit
Status	Will Not Be Addressed

Zusätzliche Informationen

We apologize that we were unable to address this issue within the current product support cycle. If the issue continues to affect your work in a supported release, please contact Technical Support.

Workaround

Use the Project (Data Management) tool to alter the projection of the feature dataset. Utilize a model or Python script to establish a schema standard and paramaterized the application of a coordinate system.From ArcCatalog:After running the Define projection tool and checking to see that the sde_spatial_referencess table has the correct coordinate system under srtext:1. Open ArcCatalog, connect to the geodatabase. Right-click the Feature Class,sde.TestShape.2. Export >TestShape_Export.3. Use the SQL Server Management Studio, check the sde_layers table. Now it has the SRID set to a new number and the spatial references table has auth_srid set to 26996 (to match NAD_1983_StatePlane_Missouri_East_FIPS_2401 set using the Define Projection tool), Srtext is set to NAD_1983_StatePlane_Missouri_East_FIPS_2401.4. Check constraint on sde.TestShape changed set to STSRID = 26996.5. Can load data in the correct coordinate because the check constraint is now updated to 0.Changing the SRID value stored in the shape column in the feature class table in the SQL Server database, resets the SRID value in the Feature class properties>General tab.From SQL Server:Modify check constraint from the SQL Server Management Studio.