Spatial Reference for A Registered Spatial View

[vijaybadugu]

I am using ArcGIS Pro 3.1 and couldn't set Spatial reference for a registered Spatial View. it always throws same error that "Can not alter the spatial reference because the feature dataset is in use by another application/user." even though I killed all connected users . have been facing issue for 4 months and raised a ticket with ESRI Support team and they end up with a BUG. Do you guys have any workaround for this 

[DanPatterson]

BUG-000134031 or one of these

Esri Support Search Results

[VinceAngelo]

If it's registered, then there's a layers table entry which could be UPDATEd.

Personally, I mostly just use Query Layers, which don't require registration.

- V

[vijaybadugu]

general practice, we use SQL View query, which includes, non-spatial fields and shape field. then, we register with Geodatabases.

[VinceAngelo]

There's lots of variables here: The RDBMS, the frequency of data layer creation, the mechanisms used to maintain data contents, use of versioning, availability of SQL admin tool, individual DBA comfort with direct SQL queries,...

I often have a SQL script to paste into a DB client (pgAdmin,...), with a follow-up ArcPy script to register as necessary. I once had an ArcPy script that loaded 40 tables into a temporary schema with FeatureClassToGeodatabase, then issued tens of thousands of SQL statements through ArcSDESQLExecute cursors to repopulate the 400M row publishing database.

- V

[vijaybadugu]

Thanks for your suggestion. I created new a Query Layer in arcgis pro from select statement of view and it worked and I was able to set spatial reference too