时间:2021-07-01 10:21:17 帮助过:25人阅读
ArcMap编辑SQLServer的ArcSDE图层提示: The Create Feature task could not be completed.DBMS table not found[sde.SDE.layer] 或者 Delete feature: An unexpected failure occurred.DBMS table not found[territory.SDE_USER.Alumbra][state_id=4622] 这
ArcMap编辑SQLServer的ArcSDE图层提示:
The Create Feature task could not be completed.DBMS table not found[sde.SDE.layer]
"Delete feature: An unexpected failure occurred.DBMS table not found[territory.SDE_USER.Alumbra][state_id=4622]"
这个问题造成的原因就是:用户删除了相关的i表。
所以说ArcSDE里面的表还是需要强调一下,千万不要擅自的使用数据库客户端工具任意的修改,删除表就更不可以了。
但是有没有可以挽救的办法,当然有。
使用sdesetup -o upgrade更新一下Geodatabase即可。更新之后,相应的i表就回来了。
C:\Documents and Settings\Administrator>sdesetup -o upgrade -d sqlserver -D sde2 -u sde -p sde ESRI ArcSDE Server Setup Utility Mon Feb 20 11:57:46 2012 ---------------------------------------------------------------- Upgrade ArcSDE, GDB table schema: Are you sure? (Y/N): y Upgrading ArcSde schema..... Successfully upgraded ArcSde schema. Upgrading locators..... Successfully upgraded locators. Upgrading geodatabase schema: Successfully upgraded geodatabase schema. Successfully upgraded ArcSDE instance. Refer SDEHOME\etc\sde_setup.log for more details.
最后说一下,这个问题出现在ArcSDE9.3.1之前的,而且支持的数据库为SQL Server,如果你的ArcSDE是10版本没有这个问题。