External Approval event not firing

I am in the process of upgrading from Identity Manager 6.1.4 to 7.0.3. I have an approval policy and workflow that were migrated from the Version 6.1.4 instance that uses a single approval step of type EX -- External Approval. When the request is inserted into the PersonWantsOrg table, the event that is supposed to be triggered by the approval workflow never fires, and the requests just sit there awaiting approval. Any suggestions on what to look for?

  • Any errors in dialogjournal? What does the DBQueue show? You can check both of these via the job queue info tool.

  • I would imagine that this is a custom approval policy? There maybe a change in 7.x that no longer works with the 6.1.x approval policy code. Possibly a table name change or column, this is bound to happen with a new version upgrade. There is a lot of changes between those two versions.

  • I saw nothing unusual in DialogJournal or the DBQueue.  To test the idea that the problem was in the 6.1.x approval policy or approval workflow, I created a new custom approval policy and approval workflow and associated them with the product, and then submitted another request.  Two previously submitted requests that were "stuck" executed when the approval was recalculated.  The request inserted after the change did not trigger the event and execute the associated process.  I then changed the approval policy and workflow associated with the product back to the ones migrated from 6.1.x.  At that point, the event for last submitted request was triggered and the associated process was run.  So it seems that when a request is originally submitted, the event does not get fired, but when an approval recalculation is performed, the event does fire and trigger the associated process.