My Oracle Support Banner

'Remote program FAPSARRC failed with return code: 8621' with Reason 'Incorrect syntax' When Clicking Process ISIR Button on ISIR Suspense Management 24/25, in MSSQL Environment (Doc ID 3010659.1)

Last updated on MARCH 15, 2024

Applies to:

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

Symptoms

On ISIR Suspense Management 24/25, when clicking the 'Process ISIR' button, the following error displays on the page:

Remote program FAPSARRC failed with return code: 8621 .Reason: [Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near '('.[Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near the keyword 'WHERE'.[Microsoft][SQL Server Native Client 11.0][SQL Server]Statement(s) could not. In section: SQLRT: EXECUTE-STMTERROR INSERTING U-FTIM (FAP00SLD) (2,-1) DERIVED_ISIRWK5.LOAD_ISIR_PB.FieldChange PCPC:2023 Statement:25

The issue has been observed to occur specifically in a MSSQL environment and can be reproduced with the following steps:

  1. Navigate to Financial Aid > File Management > 2024-2025 Suspense Management and select any record that has not yet loaded.
  2. Enter the ID (if not already populated), click the 'ID Lock' box, and the 'Add ISIR' button.
  3. Click 'Process ISIR' and note the error displayed.

 

Changes

The issue occurs after applying the fixes related to Patch 35043037: 2024-2025 ISIR Update: FAFSA Simplification, from CS 9.2 PUM Image 31 (or the PRP when it was available prior to the release of Image 31).

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
Changes
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.