Knowledge Partner
Knowledge Partner
126 views

Long running workflows, moving from DB to DB

With a workflow that runs and sits running, say for 1 year, and you want
to upgrade your User App DB.

Most people have found a UA upgrade is a disaster, so it is intensely
simpler to simply install a fresh 4.72 and then put your DAL and PRD's
back.

So if you wanted to copy out the running Workflows from the old UA's
database and copy it into the new DB,any ideas on how you might approach it?

I recall reading in the docs at one point that during an upgrade like
this you might want to copy out of the DB and then copy the contents back.

Anyone ever tried it?

I was thinking maybe querying over SOAP to getWorkEntries, then getWork
for each and then restarting the workflows. Thing is getting the
timeouts to match so that anything due is still due at the same time.
(I.e. If it is due 90 days from start, vs due at a specified date sort
of thing).

Any other options?
Labels (1)
0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.