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.