2014-2015 INAS Fails with the error "INVALID CHARACTER AT END OF DATA" in FAPINAS5 (Doc ID 1666153.1)

Last updated on OCTOBER 05, 2016

Applies to:

PeopleSoft Enterprise CS Financial Aid - Version 8.9 to 9 [Release 8.9 to 9]
Information in this document applies to any platform.

Symptoms

When running INAS on an ISIR, either at the time of ISIR Load, in INAS Batch Calculation or online,  the process abends with the following error....

PTPSQLRT - ERROR IN SELECT SETUP/DATA
STATEMENT=FAPINAS5_S_PARENT
VARIABLE#=00105
INVALID CHARACTER AT END OF DATA=

Application Program Failed
Action Type     : SQL SELECT                    
In Pgm Section  :                                                                                                                                                            
Error Message   :  
Stored Stmt     : FAPINAS5_S_PARENT


Error W/FAPINAS5             !

SQL Error: GET-FEDPAR(SELECT)                                                                                                                                          


Application Program Failed
In Pgm Section  : GET-FEDPAR(SELECT)                                                                                                                                          

PTPSQLRT - Error Encountered
No longer have connection to DB due to an error from previous
action: SQL SELECT                    . Bypassing current action: CLEAR-STMT                    .
Terminating Program.

 



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