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: and later   [Release: and later ]
Information in this document applies to any platform.


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(
at oracle.jbo.common.ampool.ApplicationPoolImpl.useApplicationModule(
at oracle.jbo.common.ampool.SessionCookieImpl.useApplicationModule(

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


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