BUG-000095895 for ArcSDE/Enterprise Geodatabase

Número de ID del error	BUG-000095895
Enviado	April 20, 2016
Última modificación	June 5, 2024
Relacionado con	ArcSDE/Enterprise Geodatabase
Versión encontrada	10.2.1
Sistema operativo	N/A
Versión de sistema operativo	N/A
Estado	Will Not Be Addressed

Información adicional

This known issue is encountered because of an invalid workflow. The projection is changed (not supported) after data has been created in the original projection. The archive table ends up with the new projection and the business table still has a check-constraint that does not match the new projection.

Solución alternativa

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.The check constraint on the shape field prevents any changes being made to the SRID value in the feature class. So changing the SRID value in the feature class from SQL Server Management Studio can be done only after disabling the check constraint and then setting the SRID value to the correct one. Finally update the constraint with the new SRID. The following syntax was used on the feature class sde.TESTSHP_SRID, with the geometry in the 'Shape' column. The SRID is changed from 0 to 4326 (for WGS 1984 coordinate system).SELECT shape.STSrid from sde.TESTSHP_SRID;alter table sde.TESTSHP_SRID NOCHECK CONSTRAINT ALL;update sde.TESTSHP_SRID set shape.STSrid = 4326;alter table sde.TESTSHP_SRID CHECK CONSTRAINT all;NOTE:The check constraint for the feature class in the geodatabase needs to be updated so that it checks for Shape.STSRID = 4326 and not 0, because any new features added to this table in the future should have the correct SRID number.