BUG-000095895 for ArcSDE/Enterprise Geodatabase

漏洞 ID 编号	BUG-000095895
已提交	April 20, 2016
上次修改时间	June 5, 2024
适用范围	ArcSDE/Enterprise Geodatabase
找到的版本	10.2.1
操作系统	N/A
操作系统版本	N/A
状态	Will Not Be Addressed

附加信息

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.

解决办法

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.