Intermittent Error "UnknownSQLTypeException, msg=JBO-25000: Unknown SQL type: null" (Doc ID 400316.1)

Last updated on AUGUST 04, 2016

Applies to:

Oracle JDeveloper - Version: 10.1.3.0.4 and later   [Release: and later ]
Information in this document applies to any platform.

Symptoms

You have intermittent problems in your Production environment where the following errors are reported:

JBO-30003: The application pool  (AppModuleLocal) failed to checkout an
application module due to the following
exception:oracle.jbo.JboException: JBO-29000: Unexpected exception caught:
oracle.jbo.common.UnknownSQLTypeException, msg=JBO-25000: Unknown SQL type: null
at oracle.jbo.common.ampool.ApplicationPoolImpl.doCheckout(ApplicationPoolImpl.java:1954)
at oracle.jbo.common.ampool.ApplicationPoolImpl.useApplicationModule(ApplicationPoolImpl.java:2756)
at oracle.jbo.common.ampool.SessionCookieImpl.useApplicationModule(SessionCookieImpl.java:426)
...

The problem can be reproduced in the Development environment by setting the parameter jbo.ampool.doampooling = false
to simulate the Application Module passivation / activation, as explained in <> - How To Reproduce Problems Related to AM Passivation / Activation

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms