laptop and a wrench

Error

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.

Última publicación: August 25, 2014 ArcSDE/Enterprise Geodatabase
Número de ID del error NIM040183
EnviadoNovember 18, 2008
Última modificaciónApril 2, 2025
Relacionado conArcSDE/Enterprise Geodatabase
Versión encontrada9.3
Versión corregida9.4
EstadoFixed

Solución alternativa

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.

Pasos para reproducir

ID del error: NIM040183

Software:

  • ArcSDE/Enterprise Geodatabase

Recibir notificaciones cuando cambie el estado de un error

Descargar la aplicación de soporte de Esri

Descubrir más sobre este tema

Esri Community

Buscar información relacionada

Training

Encontrar formación relacionada con este tema

ArcGIS Ideas

Explorar ideas y aportar opiniones

Obtener ayuda de expertos en ArcGIS

Contactar con el soporte técnico

Descargar la aplicación de soporte de Esri

Ir a opciones de descarga