topic Re: Changing a version's parent in Data Management Questions

Changing a version's parent

Anonymous User — Fri, 21 Sep 2012 21:14:42 GMT

We currently have a Bulletin Board version under sde.default, and then edit versions under the Bulletin Board version. Our normal workflow is to reconcile/post the edit versions to the Bulletin Board during the day. At the end of the day the Bulletin Board is reconciled/posted with sde.default. Usually this works fine. We do have many (300+) long-term versions that can have work in-process for months. They are reconciled daily bia a batch reconcile tool. My question is this: Can we change the parent version on existing versions from the Bulletin Board to sde.default without having to post them? We would like to get rid of the Bulletin Board version because of ghost conflicts we are getting and go to a flat versioning structure.

Re: Changing a version's parent

AsrujitSengupta — Wed, 26 Sep 2012 01:11:50 GMT

No, you cannot change a version's parent after it has been created.
You will need to create all the versions again, if you want the parent to be SDE.Default.

Regards,
asrujit

Re: Changing a version's parent

anthonysanchez — Wed, 26 Sep 2012 14:45:42 GMT

Hi Dori,

while not supported, this can be done. I've done it before for other bulletin board folks.

1) test this!
2) take good backups
3) the trick is to get bulletin board and sde.default to be at the exact same state prior to re-parenting. This is achieved by posting and reconciling the in the appropriate order.
4) once they are at the same state (query sde.versions), you can update the attributes in sde.versions for the version which you'd like to reparent.

UPDATE sde.versions SET parent_name = 'DEFAULT', parent_owner = 'SDE', parent_version_id = 1
WHERE owner = 'CHILD OWNER' AND name ='CHILD VERSION NAME';
commit;

Re: Changing a version's parent

KimPeter — Wed, 26 Sep 2012 19:25:10 GMT

Dori,

Rather than mess with changing the parent version, why not change your workflow to reconcile and post edits directly to DEFAULT from your edit versions?

-Kim

Re: Changing a version's parent

anthonysanchez — Thu, 27 Sep 2012 03:19:24 GMT

Hi Kim,
That's exactly the workflow that's causing Dori's ghost conflict problem to begin with.

Anthony

Re: Changing a version's parent

Anonymous User — Fri, 28 Sep 2012 17:01:19 GMT

Thanks for the replies. We have had ghost conflicts appear about every 2 years and it's a real pain to clean up. We are at the point of desparation and willing to get rid of our bulletin board version. 🙂 I'll test out the process you suggested Anthony and see if I break anything. Of course, backups first!

Re: Changing a version's parent

KimPeter — Fri, 28 Sep 2012 22:26:00 GMT

Hi Dori,

I would encourage you to also contact support about your phantom conflicts. If there is a problem in the software that's causing this, we need to fix it. Or if it is a problem that happens with certain workflows, we need to document how to avoid it.

Thanks,

Kim