Bogue
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.
| Numéro d’ID de bogue | NIM040183 |
|---|---|
| Envoi | November 18, 2008 |
| Dernière modification | April 2, 2025 |
| S’applique à | ArcSDE/Enterprise Geodatabase |
| Version trouvée | 9.3 |
| Version de correction | 9.4 |
| Statut | Fixed |
Solution de contournement
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.Étapes pour reproduire
ID de bogue: NIM040183
Logiciel:
- ArcSDE/Enterprise Geodatabase
Recevoir une notification lorsque le statut d’un bogue change
En savoir plus sur ce sujet
Rechercher des informations associées
Rechercher une formation sur ce sujet
Explorer des pistes et donner un avis
Obtenir de l’aide auprès des experts ArcGIS
Télécharger l’application Esri Support