My Oracle Support Banner

Academic Advisement Report Status Remains 'Request Processing' with Page Log Error 'SAA_ACADEMIC_ADVISEMENT.AA_Report.AA_ReportRequest.OnExecute' ; Application Server Log (.out) File Shows '153 Subscript out of range' in SRPCARQL.cbl (Doc ID 2303461.1)

Last updated on SEPTEMBER 14, 2022

Applies to:

PeopleSoft Enterprise CS Academic Advisement - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

 When running the Academic Advisement Report (AAR), administratively or in self service, the request does not complete. On the page where the request is executed, or on the Request Log page, the following error will display, with possible small variations (especially the numbers at the end of the first line).

On the Advisement Request Report page, the Report Status remains in 'Request Processing'.

The issue may only occur for a small number of students, however the problem records may cause batch refresh jobs to error and have to be re-started to process subsequent students.

The issue can be reproduced at will with the following steps:

  1. Navigate to Academic Advisement > Student Advisement > Request Advisement Report.
  2. Add the request for the affected student and populate the fields.
  3. Click the 'Process Request' button. If the error does not already display immediately, click the 'Advisement Report Request Log' tab and note the error under Request Messages.



Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.