laptop and a wrench

Bug

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.

Zuletzt veröffentlicht: August 25, 2014 ArcSDE/Enterprise Geodatabase
Bug-ID-Nummer NIM040183
EingereichtNovember 18, 2008
Zuletzt geändertApril 2, 2025
Gilt fürArcSDE/Enterprise Geodatabase
Gefunden in Version9.3
Behoben in Version9.4
StatusFixed

Workaround

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.

Schritte zur Reproduzierung

Bug-ID: NIM040183

Software:

  • ArcSDE/Enterprise Geodatabase

Benachrichtigung erhalten, wenn sich der Status eines Bugs ändert

Esri Support App herunterladen

Weitere Informationen zu diesem Thema erkunden

Esri Community

Nach zugehörigen Informationen suchen

Training

Nach Schulungen zu diesem Thema suchen

ArcGIS Ideas

Ideen erkunden und Feedback geben

Unterstützung durch ArcGIS-Experten anfordern

An den technischen Support wenden

Esri Support App herunterladen

Zu Download-Optionen wechseln