Every Other Call To IMP Fails

(Doc ID 2330020.1)

Last updated on NOVEMBER 26, 2017

Applies to:

Oracle Healthcare Data Repository - Version 7.0.1.7 and later
Information in this document applies to any platform.

Symptoms

On : 7.0.1.7 version, EMPI issues

Every other call to IMP fails with
the following error:

ERROR
-----------------------
Aug 28, 2017 6:58:26 PM oracle.apps.ctb.fwk.base.server.CTBAppsLogHelper logEvent
INFO: closeConnection.closeConnection : JTAOracleConnection closed
oracle.apps.ctb.fwk.base.common.CTBUnexpectedException
CODE = CTB_UNEXPECTED_EXCEPTION
MESSAGE = An unexpected error has occurred. Please contact your support representative.

Original Stacktrace:
java.lang.NullPointerException
at oracle.jbo.server.DBTransactionImpl.findApplicationModule(DBTransactionImpl.java:6274)
at oracle.apps.ctb.message.improcessor.hl7.engine.server.CtbServiceFactoryImpl.getService(CtbServiceFactoryImpl.java:128)
at oracle.apps.ctb.message.improcessor.hl7.engine.server.CtbServiceFactoryImpl.getIMPService(CtbServiceFactoryImpl.java:171)
at oracle.apps.ctb.message.improcessor.hl7.engine.server.SaxDispatcher.(SaxDispatcher.java:2939)
at oracle.apps.ctb.message.improcessor.hl7.engine.server.IMPProcessorImpl.processMessage(IMPProcessorImpl.java:442)
at oracle.apps.ctb.message.improcessor.hl7.engine.server.IMPProcessorImpl.processMessage(IMPProcessorImpl.java:416)
at oracle.apps.ctb.message.improcessor.hl7.server.IMPServiceAMImpl.processMessageInternal(IMPServiceAMImpl.java:152)
at oracle.apps.ctb.message.improcessor.hl7.server.RawIMPServiceAMImpl.processMessage(RawIMPServiceAMImpl.java:80)


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
A simple deployed web application does the following:
- login() using ServiceLocator
- begin() UserTransaction
- get RawIMPService
- execute processMessage() with a v3 message
- rollback() the transaction

Calling this service will alternate with successful submissions (and rollbacks), and a CTB_UNEXPECTED_EXCEPTION.


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