My Oracle Support Banner

E-AE: Application Engine SQL With If/Else Statement Fails With Error "Error Code: Return: 6100 - End of fetch" When It Updates Zero Rows (Doc ID 2992211.1)

Last updated on DECEMBER 13, 2023

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.59 and later
Information in this document applies to any platform.


When running Application Engine (AE), if it is using If/Else statement in the SQL action, it runs to SQL Error when the UPDATE SQL updates 0 rows.
This happens when sql syntax is specific to one database (e.g. MS SQL Server) and error can be seen in <ProgramName>_<Instance>.stdout file.

Error Code: Return: 6100 - End of fetch (SQLSTATE PS001)

The issue can be reproduced at will with the following steps:
1. Create an AE program with sql action using If/Else that updates 0 rows in database.
2. Run application engine from PeopleTools > Process Scheduler > Schedule Process Request
3. Go to process monitor page from here and click on details for AE program
4. Notice the error in log here.  


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

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