BUG-000095895 for ArcSDE/Enterprise Geodatabase

Bug ID Number	BUG-000095895
Submitted	April 20, 2016
Last Modified	June 5, 2024
Applies to	ArcSDE/Enterprise Geodatabase
Version found	10.2.1
Operating System	N/A
Operating System Version	N/A
Status	Will Not Be Addressed

Additional Information

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.

Workaround

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.