Hi all,
I'm using JDeveloper 12.2.1.1.0
WebLogic 12.2.1.1.0
Oracle 12.1.0.2.0
We have been running our adf application for a couple of months with 30 users and no problems, since we have doubled the number of users from 30 to 60 we are seeing intermittent errors
Caused by: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT ENABLED_YN,
MAJOR_MODE_NAME,
MAJOR_MODE_NUMBER
FROM
(
SELECT Failure_Mode_MajorEO.ENABLED_YN,
Failure_Mode_MajorEO.MAJOR_MODE_NAME AS
MAJOR_MODE_NAME,
Failure_Mode_MajorEO.MAJOR_MODE_NUMBER
FROM QG_FAILURE_MODE_MAJOR Failure_Mode_MajorEO
WHERE Failure_Mode_MajorEO.ENABLED_YN = 'Y'
UNION
SELECT 'Y', '<<-- Select -->>' AS MAJOR_MODE_NAME , NULL
FROM SYS.DUAL
)
ORDER BY upper(MAJOR_MODE_NAME)) QRSLT WHERE ( ( (UPPER(MAJOR_MODE_NAME) LIKE UPPER( :SearchCriteria || '%') ) ) )
It's always the same piece of SQL, but only happens, maybe 1 in 10 times the code is executed.
I have been unable to reproduce in our test environment. And even in Production it only happens when all the users are actively using the system. Even though the server does not appear to be under a heavy load
The app server log files reveal nothing (no errors shown in logs when the problem manifests itself) and the oracle db logs don't provide any help either.
Has anyone seen anything like this before, or can point me in the direction of where to start looking.
Thanks in advance