laptop and a wrench

不具合

After upgrading from ArcSDE 9.2 SP6 to ArcSDE 9.3, some GDB coded value domains (stored as LONGRAW) disappear from ArcCatalog, and newly added coded value domains disappear too.

最後に公開された状態: August 25, 2014 ArcSDE/Enterprise Geodatabase
不具合 ID 番号 NIM040183
送信されましたNovember 18, 2008
最終更新日April 2, 2025
適用対象ArcSDE/Enterprise Geodatabase
見つかったバージョン9.3
修正されたバージョン9.4
ステータスFixed

対処法

AFTER UPGRADE to 9.3:1- Update the sde.dbtune table ATTRIBUTE_BINARY parameter in the DATA_DICTIONARY keyword to be "BLOB" instead of "LONGRAW" (if needed) using sdedbtune command:C:\>sdedbtune -o list -u sde -i 5151 -k DATA_DICTIONARY -P ATTRIBUTE_BINARYEnter Database User password:ArcSDE 9.3 for Oracle10g Build 546 Thu Sep 18 12:35:50 2008Attribute Administration Utility----------------------------------------------------- ##DATA_DICTIONARY ATTRIBUTE_BINARY "LONGRAW" ENDC:\>sdedbtune -o alter -u sde -i 5151 -k DATA_DICTIONARY -P ATTRIBUTE_BINARY -v "BLOB"Enter Database User password:ArcSDE 9.3 for Oracle10g Build 546 Thu Sep 18 12:35:50 2008Attribute Administration Utility-----------------------------------------------------Update DBTUNE data. Are you sure? (Y/N): y Successfully altered dbtune data.C:\>sdedbtune -o list -u sde -i 5151 -k DATA_DICTIONARY -P ATTRIBUTE_BINARYEnter Database User password:ArcSDE 9.3 for Oracle10g Build 546 Thu Sep 18 12:35:50 2008Attribute Administration Utility----------------------------------------------------- ##DATA_DICTIONARY ATTRIBUTE_BINARY "BLOB" END2- Run sdetable -o migrate on the GDB_CODEDDOMAINS table as the sde user:C:\>sdetable -o migrate -u sde -i 5151 -k DATA_DICTIONARY -t GDB_CODEDDOMAINSEnter Database User password:ArcSDE 9.3 for Oracle10g Build 546 Thu Sep 18 12:35:50 2008Attribute Administration Utility-----------------------------------------------------Migrate table GDB_CODEDDOMAINS to DATA_DICTIONARY.Are you sure? (Y/N): ySuccessfully migrated binary attributes in GDB_CODEDDOMAINS to blobBEFORE UPGRADE to 9.3:1- Use the stored procedures documented and provided with the whitepaper entitled "Converting from LONG RAW to BLOB in an ArcSDE for Oracle Geodatabase" to migradbtune -o list -u sde -p sde te the GDB_CODEDDOMAINS table to BLOB storage.

再現の手順

不具合 ID: NIM040183

ソフトウェア:

  • ArcSDE/Enterprise Geodatabase

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

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

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

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

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

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

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