ArcPro-Roads and Highways Event: What is best way to Field Calculate on an existing event with large number of records

[ElsitMandal1]

Hello,

Wondering if anyone able to do "Calculate Field" on an existing event with many rows( branch versioned feature service , conflict prevention enabled --about 400,000+ records ), by using some method that wouldn't take too long to complete? 

Appreciate if anyone can share any  experience with this kind of issues and what worked out for them to accomplish the task.

Background Info:

Recently we migrated to ArcPro 3.3 ( Pro 3.3.1, Server 11.3) Roads and Highways Branch versioned/conflict prevention enabled, feature service editing. After that we are not able to use field calculate in an existing event  in a timely manner ( takes too long even if successful; otherwise due to unknown/ambiguous reasons 99999 error pops up-possibly locks not retained because of long transaction pr default version changed since the start of edit) 

The only workaround that seem to accomplish bulk data update so far is by taking a copy of existing data into a filegeodatabase; delete existing records (about 400,000)  in the branch version and then append the processed records back in. We need to repeat this process, whenever we have data ready to update for other  fields in the event.

Thanks

[ElsitMandal1]

Thank you, Kyle.  When we were in ArcMap roads and Highways, the updates using SQL were successful. But with branch versioned feature service, we are still not so sure  how to do it. Not many examples out there. Tried this one, https://support.esri.com/en-us/knowledge-base/how-to-edit-branch-versioned-feature-layers-using-the-... . But was unable to make it work yet for our environment

[MarceloMarques]

Branch Version updates via SQL are not a supported workflow.

Branch versioning follows a services based implementation pattern and there are not currently any plans for direct SQL access.

Branch versioning and SQL Views - Esri Community

SQL Views and Branch Versioning - Esri Community

branch versioning vs. mass updates

Branch Version Sql Views - Utility Network - Esri Community

Utility Network Journey: Branch Versioning and SQL