Upgrade 2016-2017 - Workflow issue

poppins

Hi everyone,

I am upgrading from NAV 2016 to 2017.
For the data upgrade, I used the following command:
Start-NavDataUpgrade -ServerInstance XXX -Force
It stops in the very beginning, and when investigating the error, I get the following:
There is one or more workflow instances.You must complere all running workflows before proceeding with the upgrade.
Did anyone face this before?
How shall I proceed about that?

Thanks in advance

HannesHolst

Hey,

Maybe a (approval-)workflow in NAV hasn't been completed yet?
I would check the Approval Request Entries or the Workflow*-tables.

Good luck.

poppins

HannesHolst wrote: »

Hey,

Maybe a (approval-)workflow in NAV hasn't been completed yet?
I would check the Approval Request Entries or the Workflow*-tables.

Good luck.

Indeeed, there are approval request entries...
But what to do? I can't approve nor cancel them...

HannesHolst

Why not?

For an upgrade from 2016 to 2017 you should expect, that the daily work is completed.
When you are doing a test run at the moment, I would cancel or approve the requests by myself.

Later for production run, I would ask the owners to complete the entries. If not possible, cancel them and create new requests in 2017 afterwards.

poppins

I checked the code and the problem is in the upgrade code:
IF NOT WorkflowStepInstance.ISEMPTY THEN
ERROR(WorkflowInstancessAreRunningErr);
Apparently, the table Workflow Step Instances should be empty otherwise I'll get always an error...
I can remove the records, but would that be correct?