Was the case paused because it is waiting for an intermediate timer event? or because the case was paused by a user?
If the case was paused by an intermediate timer event, have you tried manually executing the timereventcron.php script? Do you see any error message?
If the case was paused by a user, then you can try this:
Create a new process that will execute the following trigger:
Code: Select all
$caseId = 'XXXXXXXXXXXXXXXXXXXX';
$delIndex = X;
$userId = 'XXXXXXXXXXXXXXXXXXXXX';
$oCase = new Cases();
$oCase->unpauseCase($caseId, $delIndex, $userId);
Find the record of the paused case in the database with this query:
SELECT * FROM APP_DELAY WHERE APP_TYPE='PAUSE';
In your trigger, set the value of $caseId to the APP_UID, $delIndex to the value of APP_DEL_INDEX and $userId to the value of APP_DELEGATION_USER.
Note: if you don't know the APP_UID of the case, then look it up in the APPLICATION table by searching for the APP_NUMBER (which is the case number).
Amos B. Batto ♦ ProcessMaker Forum Manager since 2009