NIM084357 for ArcSDE/Enterprise Geodatabase

Numéro d’ID de bogue	NIM084357
Envoi	September 4, 2012
Dernière modification	April 2, 2025
S’applique à	ArcSDE/Enterprise Geodatabase
Version trouvée	10.1
Système d’exploitation	Windows OS
Version du système d’exploitation	2008 64 Bit
Statut	Will Not Be Addressed

Informations supplémentaires

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.

Solution de contournement

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.