Business Area Instance Page Navigation Fails with ' JBO-27122: SQL error during statement preparation' (Doc ID 2875873.1)

Last updated on JUNE 09, 2022

Applies to:

Symptoms

On Oracle Life Sciences Data Hub (LSH) 2.4.9.2 version,

When attempting to navigate to an already existing Business Area Instance having more than 100 source Table Descriptors,
the following error occurs:

ERROR
-----------------------

STEPS
-----------------------
The issue can be reproduced with the following steps:
1. From LSH go to a particular Work Area with a Business Area having more than 100 Table Descriptors.
2. Attempt to open the Business Area.

Cause

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