E1: ORCH: Orchestration Using Logic Extension to Insert Data into JDE Table Getting Database Exception Error When Logic Extension Is Iterating More Than 50 Times (Doc ID 3004824.1)

Last updated on MARCH 02, 2024

Applies to:

Symptoms

Logic Extensions doing table io to insert data into JDE table getting database connection error if the logic extension is called 50 or more times in a while loop. i.e. the loop is outside the Logic Extension.

Error:

Issue does not appear when inserting the same number of records using a while loop inside the same Logic Extension.

Steps to Replicate:

1. Read Data from csv file using FTP as data set

2. Orchestration calls Logic Extension to iterate through the dataset and insert into JDE table.

3. No error occurs in the process. In the AIS server logs shows database connection exceptions.

Questions:

1. Is there a way to use Table IO Handles in Logic Extensions so database connection can be re-used ?

2. Is it possible to group the call to the logic extension into one DB session ?

3. Any Suggestions on how to make the insert works without database connection error ?

Changes

Cause

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