Bug
ArcGIS does not set the first not-null field it finds as the unique identifier for a database view.
| Bug ID Number | NIM085661 |
|---|---|
| Submitted | October 13, 2012 |
| Last Modified | April 2, 2025 |
| Applies to | ArcSDE/Enterprise Geodatabase |
| Version found | 10.1 |
| Operating System | Windows OS |
| Operating System Version | 7 64 Bit |
| Status | Will Not Be Addressed |
Additional Information
We apologize that we were unable to address this issue within the current product support cycle. If the issue continues to affect your work in a supported release, please contact Technical Support.Workaround
1. Launch ArcMap. 2. Navigate to File > Add Data > Add Query Layer.3. Connect to the oracle database. 4. Select the database view table. 5. Run the query "select * from (table_name)".6. Validate.7. Check the 'Show advanced options' check box, and click Next. 8. The unique identifers are already identified.9. Click OK.Steps to Reproduce
Bug ID: NIM085661
Software:
- ArcSDE/Enterprise Geodatabase
Get notified when the status of a bug changes
Discover more on this topic
Search for related information
Find training related to this topic
Explore ideas and give feedback
Get help from ArcGIS experts
Download the Esri Support App