Update feature classes with relationship class

219
2
03-04-2024 02:57 PM
Labels (2)
ChenChen4
New Contributor III

I have two feature classes and a relationship class that connects them.  The data are stored on an Enterprise Geodatabase and I need to refresh the two feature classes weekly. My original thought was to perform a simple truncate and append, but the truncate operation returns an "160592: Truncation not allowed while editing" error. The data are not versioned and are not in editing. Tried arcpy but got the same results. Tried Delete Rows and it worked but I do not want the ever growing objectids.  Tested in ArcGIS Pro 2.7, 2.8, 2.9, 3.1, and 3.2. Can anyone recommend a correct workflow to achieve the goal? 

 

0 Kudos
2 Replies
MarceloMarques
Esri Regular Contributor

@ChenChen4 - if the relationship class is 1:1 or 1:M and goes from FC_A to FC_B then try to truncate FC_B first then FC_A last, if still not successful then try to drop the relationship class and try the truncate again, also make sure that no ArcGIS Server services nor users are connected to the geodatabase or you will not be able to truncate because of locks.
Truncate Table (Data Management)—ArcGIS Pro | Documentation
also notice that to use truncate the geodatabase connection must be with the data owner user.

| Marcelo Marques | Principal Product Engineer | Esri |
| Cloud & Database Administrator | OCP - Oracle Certified Professional |
I work with Enterprise Geodatabases since 1997.
“ I do not fear computers. I fear the lack of them." Isaac Isimov
0 Kudos
ChenChen4
New Contributor III

Thanks for the input. It is 1:M relationship and I have to drop relationship first then do truncate and append. 

0 Kudos