laptop and a wrench

Bogue

Inconsistent behavior is observed in ArcGIS while working with non-spatial ArcSDE views or Oracle views.

Dernière publication: August 25, 2014 No Product Found
Numéro d’ID de bogue NIM005470
EnvoiDecember 9, 2006
Dernière modificationApril 2, 2025
S’applique àNo Product Found
Version trouvée9.2
Version de correction9.3
StatutFixed

Solution de contournement

1) Have an objectid number(38) not null field in the veiw. Then register the view with Geodatabase using the existing objectid field. Once registered, everything works.If a view does not have an objectid number(38) not null field, then registering with geodatabase fails with many reasons like proper privileges.For sql server users, the above workaround does not work as sql server has some reservations in creating indexes for views.Since with 9.1, all geoprocessing tools were working with non-spatial views, some users are having big trouble as their workflow demands use of views in model bldr.Another user reported the same problem today. Fortunately he works with tables (not views), having those tables registered with geodatabase made his models run correctly again. However he has to change his scripts that was updating the tables everyday.Miner & Miner has mxd with joins to oracle views not registered with ArcSDE. At 9.1 they were able to edit their FCs that have these joins defined; at 9.2 they are getting a network I/O error. For now they are using the OLEDB suggested workaround but they have stated that this can only be a temporary solution. (Cheryl C 01/23/07)

Étapes pour reproduire

ID de bogue: NIM005470

Logiciel:

  • No Product Found

Recevoir une notification lorsque le statut d’un bogue change

Télécharger l’application Esri Support

En savoir plus sur ce sujet

Obtenir de l’aide auprès des experts ArcGIS

Contacter le support technique

Télécharger l’application Esri Support

Accéder aux options de téléchargement