My Oracle Support Banner

E-AE/CI: Custom AE Program Failing With an "Internal Error: invalid transaction handle instance passed from SamSetBypassErrorFlag" Errror (Doc ID 2996638.1)

Last updated on JANUARY 08, 2024

Applies to:

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

Symptoms

When running a custom Application Engine (AE) program that uses a Component Interface (CI) to process data in production, the following errors are seen in the AE stdout file. The issue could not be replicated in non-production environments.

 

Errors:
-----------------------

Internal Error: invalid transaction handle instance passed from SamSetBypassErrorFlag 1: 4138 vs 0
304197 10:17:41.615 0.000991 Cur#1.20107.EPRD RC=0 Dur=0.000636 Commit
304198 10:17:41.615 0.000012 Cur#1.20107.EPRD RC=0 Dur=0.000005 Disconnect
304199 10:17:41.615 0.000017 37: &SQL1.Execute(&ERROR_REC);
304200 10:17:41.615 0.000118 ErrorReturn-> 295 - SQL.Execute: SQL object is not open, or is a open on a select. (2,295)


Steps to replicate:

1. Create the custom AE program and add the code.
2. Run the program so there's bad data.
3. Open the .stdout file, and observe the errors above.

Environment:

PeopleTools (PT) 8.58.21
HCM 9.20

 

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.