Erro
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.
| Número de ID do Erro | NIM040183 |
|---|---|
| Enviado | November 18, 2008 |
| Última Modificação | April 2, 2025 |
| Aplica-se à | ArcSDE/Enterprise Geodatabase |
| Versão encontrada | 9.3 |
| Versão Fixa | 9.4 |
| Status | Fixed |
Solução Provisória
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.Etapas para Reproduzir
ID do Erro: NIM040183
Software:
- ArcSDE/Enterprise Geodatabase
Seja notificado quando o status de um erro mudar
Descubra mais sobre este tema
Procurar por informações relacionadas
Encontre treinamento relacionado a este tópico
Explore idéias e forneça comentários
Obtenha ajuda de especialistas do ArcGIS
Baixe o Aplicativo de Suporte da Esri