'Invalid message while SQL transaction in process (14731,257)' Error When Changing the APT Instance on Student Program/Plan

(Doc ID 2000465.1)

Last updated on OCTOBER 05, 2016

Applies to:

PeopleSoft Enterprise CS Student Records - Version 9 and later
Information in this document applies to any platform.

Symptoms

On : Campus Solutions, Release 9, Student Program/Plan

When attempting to change a APT instance for a student, the following error can occur:

ERROR
-----------------------
"Invalid message while SQL transaction in process: Create a new APT Instance? (14731,257) (2,178) SSR_CAREER_TERM.
COMPONENTS.ACAD_PLAN.OnExecute Name:PE_SavePreChange PCPC:14767 Statement:192
Called from:SSR_CAREER_TERM.COMPONENTS.ACAD_PLAN.OnExecute Name:Component_SavePreChange Statement:107
Called from:ACAD_PLAN.GBL.SavePreChange Statement:2
A PeopleCode program tried to issue the indicated message while an SQL cursor is open."

The problem only occurs when the Stdnt_Car_Nbr = 1. The processing will only allow use of an APT Instance with an Academic Item ID with an effective date that is less than but not equal or greater than the effective date of the student's Program  (Main Menu --> Setup SACR --> Foundation Tables --> Academic Program Table).

This error doesn't occur when the STDNT_CAR_NBR is 0 even though the same set up is in place.

 Use the following steps to replicate the issue:

  1. Navigate to Records and Enrollment -> Career and Program Information ->Student Program/Plan
  2. Select student with Career Number = 0.
  3. Change the APT instance and save.
  4. Receive message of:  Create New APT instance (14731, 257).  Changes in Student academic data have resulted in a different AIR program mapping.  Create New APT inst
  5. Navigate to Records and Enrollment -> Career and Program Information ->Student Program/Plan
  6. Select a student with Career Number = 1.
  7. Change the APT instance and save.
  8. Receive message: : Invalid message while SQL transaction in process: Create a new APT Instance? (14731,257) (2,178) SSR_CAREER_TERM.
    COMPONENTS.ACAD_PLAN.OnExecute Name:PE_SavePreChange PCPC:14767 Statement:192
    Called from:SSR_CAREER_TERM.COMPONENTS.ACAD_PLAN.OnExecute Name:Component_SavePreChange Statement:107
    Called from:ACAD_PLAN.GBL.SavePreChange Statement:2
    A PeopleCode program tried to issue the indicated message while an SQL cursor is open



Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms