Header Ads

  • Recent Post

    Processes getting Queued - Part 4 - AE Processes remain Queued when SQR with Email option Fails

    App Engine Processes remain Queued while other type of Processes like SQR Report, SQR Process, Crystal Reports run to completion.

    When I was faced with such a situation I was little bemused and checked the Process Scheduler and system settings without finding any clue.

    With the help of PeopleSoft Administrator, I found that all PSAESRV services were busy and hence I thought the system could not assign any further App Engine process. After waiting for a while, the result was the same. I could not see any process running through Process Scheduler in PIA and I decided also to check the Process Request and Process Queue tables. Inspecting the data in  PSPRCSRQST and PSPRCSQUE tables I could find no trace of any AE processes running.

    Then viewing the mstrschdlr_mmdd.log file at boot up, it listed the current running tasks, which had a Sqr program with an "Error" status. Initially chosing to ignore this information and trying several other stuff found nothing working. With little bit of help from google results, I zeroed in on the SQR program which resulted in error. The SQR which resulted in error had distribution method as Email on completion.

    This was a delivered PeopleSoft Issue that all the App Engine processes remain queued if SQR program with Output Type of "Email" ends in "Error".

    Solution
    To resolve this issue need to apply maintenance patches to: 8.46.18, 8.47.11 or 8.48.05.



    Alternatively, we need to manually remove the offending Sqr processes, and it could be done by running the below SQLs:

    UPDATE psprcsrqstSET    runstatus = 2
    WHERE  runstatus = 3
          AND prcstype IN ( 'SQR Report', 'SQR Process' );

    UPDATE psprcsque
    SET    runstatus = 2
    WHERE  runstatus = 3
          AND prcstype IN ( 'SQR Report', 'SQR Process' );

    COMMIT;

    Bounce all the schedulers to force the Master Scheduler to pick the updated list form the database.

    The list of those processes can be viewed by running the below SQLs against the database:

    In PSPRCSRQST Record:
    SELECT *
    FROM   psprcsrqst
    WHERE  runstatus = 3
           AND prcstype IN ( 'SQR Report', 'SQR Process' );
    In PSPRCSQUE Record:
    SELECT *
    FROM   psprcsque
    WHERE  runstatus = 3
           AND prcstype IN ( 'SQR Report', 'SQR Process' ); 

    No comments

    Please refrain for marketing messages and unnecessary back links.

    Post Top Ad

    Post Bottom Ad