NIM055001 for No Product Found

不具合 ID 番号	NIM055001
送信されました	March 5, 2010
最終更新日	June 5, 2024
適用対象	No Product Found
見つかったバージョン	10.0 Beta
修正されたバージョン	N/A
ステータス	Fixed

対処法

Run these queries first (as the sde user) to see how many records are orphaned:select count(*) from sde_xml_doc1 where sde_xml_id not in (select sde_xml_id from sde_xml_doc1 where sde_xml_id in (select definition from sde.gdb_items));select count(*) from sde_xml_doc2 where sde_xml_id not in (select sde_xml_id from sde_xml_doc2 where sde_xml_id in (select documentation from sde.gdb_items));select count(*) from sde_xml_doc3 where sde_xml_id not in (select sde_xml_id from sde_xml_doc3 where sde_xml_id in (select iteminfo from sde.gdb_items));select count(*) from sde_xml_doc4 where sde_xml_id not in (select sde_xml_id from sde_xml_doc4 where sde_xml_id in (select attributes from sde.gdb_itemrelationships));============Run the following sql (as the sde user) to clean up the tables. This will delete orphaned xmldocs:delete from sde_xml_doc1 where sde_xml_id not in (select sde_xml_id from sde_xml_doc1 where sde_xml_id in (select definition from sde.gdb_items));delete from sde_xml_doc2 where sde_xml_id not in (select sde_xml_id from sde_xml_doc2 where sde_xml_id in (select documentation from sde.gdb_items));delete from sde_xml_doc3 where sde_xml_id not in (select sde_xml_id from sde_xml_doc3 where sde_xml_id in (select iteminfo from sde.gdb_items));delete from sde_xml_doc4 where sde_xml_id not in (select sde_xml_id from sde_xml_doc4 where sde_xml_id in (select attributes from sde.gdb_itemrelationships));

再現の手順

不具合 ID: NIM055001

ソフトウェア:

No Product Found

このトピックについてさらに調べる

ArcGIS エキスパートのサポートを受ける

テクニカルサポートへのお問い合わせ

Esri Support アプリのダウンロード

ダウンロードオプションに移動

Deleting data from an ArcSDE geodatabase for Oracle is leaving entries in the sde_xml_doc<> side tables.

対処法

再現の手順

バグのステータスが変更されたときに通知を受け取る

このトピックについてさらに調べる