Invalid package error for a valid package! – Revisited
A while back, I wrote this post about the dreaded “existing state of the packages” error when recompiling code that is used in a Workflow process.
There is some degree of official guidance on what you need to do now, contained in Metalink note 754993.1 – “How can you Avoid Bouncing the Database after Changing a WF Package”. The advice is, to be honest, perhaps a little Draconian and unwieldy, but the guidance from Oracle is that all you need to do is:
- Shut down the concurrent managers
- Flush the shard pool
- Update the package
- Restart the concurrent managers
Now, that certainly will do it (so would bouncing the database, though!) – the likelihood of a developer shutting down the managers, then flushing the pool, and THEN compiling their code is probably quite low, though 
November 5th, 2009 at 11:12 am
Restarting the Agent Listener Container usually does the job.
> Workflow Administrator
> Workflow Manager
> Click on the green tick (or red cross) next to ‘Agent Listeners’
> Click on ‘Workflow Agent Listener Service’ under the Container column
> Select the ‘Workflow Agent Listener Service’ and select Restart
Then sit back and have a nice cup of tea and Voila!