topic Re: Editing default with version view (evw - multi-version view) in sde with many versions in Geodatabase Questions

Editing default with version view (evw - multi-version view) in sde with many versions

forestknutsen1 — Wed, 29 Sep 2021 19:14:02 GMT

Is there any risk in editing the default version with an multi-version view (evw) in an sde environment?

We have a number of batch jobs that update default version attributes with sql and the evw
Database is Oracle
We have a high number of versions within the database, ~900. All of the versions have default as parent

Re: Editing default with version view (evw - multi-version view) in sde with many versions

forestknutsen1 — Thu, 30 Sep 2021 18:44:17 GMT

Bumping this one up...

Re: Editing default with version view (evw - multi-version view) in sde with many versions

Steve_Salas — Tue, 12 Oct 2021 21:23:46 GMT

If the changes impact a signifcant number of records that are likely to be edited in those existing versions, I'd be prepared for conflicts arising during the reconcile process. Sure you can automatically resolve conflicts in favor of _______ version, but I don't think it will differentiate between conflicts with your SQL update against the EVW vs. conflicts created by a different version being posted. Those are the factors I would look at without knowing much else about your data & workflow.

Re: Editing default with version view (evw - multi-version view) in sde with many versions

forestknutsen1 — Tue, 12 Oct 2021 23:20:38 GMT

Thanks Steven.

Right. The fields in question only get edited by the evw jobs and they are mostly static values, i.e. once set they are unlikely to change. So, I think the conflicts will be low.