Bug
Upgrade enterprise geodatabase fails on SQL Server when colregistry_fk is missing.
| Bug ID Number | BUG-000169238 |
|---|---|
| Submitted | July 19, 2024 |
| Last Modified | August 19, 2024 |
| Applies to | ArcGIS Pro |
| Version found | 3.3.1 |
| Operating System | Windows OS |
| Operating System Version | 11.0 64 bit |
| Version Fixed | 3.4, 3.3.2 |
| Status | Fixed |
Additional Information
This issue is addressed in ArcGIS Pro 3.3.2 and 3.4.Workaround
Run the SQL statement below on the database, and ArcGIS Pro 3.3.1 can be used to run an upgrade:
ALTER TABLE [sde].[SDE_column_registry] WITH CHECK ADD CONSTRAINT [colregistry_fk] FOREIGN KEY([table_name], [owner], [database_name])
REFERENCES [sde].[SDE_table_registry] ([table_name], [owner], [database_name])
ON UPDATE CASCADE
ON DELETE CASCADE
GO
Steps to Reproduce
Bug ID: BUG-000169238
Software:
- ArcGIS Pro
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