My Oracle Support Banner

SOA 11g: Composite Data is not Picked up from Database Table (Doc ID 988864.1)

Last updated on JULY 24, 2018

Applies to:

Oracle(R) BPEL Process Manager - Version 11.1.1.2.0 and later
Information in this document applies to any platform.

Symptoms

User gets the following errors running the BPEL process:

 

[2010-01-12T10:16:58.453-05:00] [soa_server1] [ERROR] [] [] [tid: weblogic.work.j2ee.J2EEWorkManager$WorkWithListener@7ceeedaa] [userId: ] [ecid: 0000IOZ6yzLDwW4DzV4EwW1BJ98V000009,0] [APP: soa-infra] unable to build the TopLink Session
[2010-01-12T10:16:58.454-05:00] [soa_server1] [ERROR] [] [] [tid: weblogic.work.j2ee.J2EEWorkManager$WorkWithListener@7ceeedaa] [userId: ] [ecid: 0000IOZ6yzLDwW4DzV4EwW1BJ98V000009,0] [APP: soa-infra] Encountered a fatal exception while polling. Will continue polling but with minimal logging. Please investigate the fault and manually stop polling from the console if in development and this appears to be a modeling mistake. BINDING.JCA-11624[[
DBActivationSpec Polling Exception.
Query name: [ebsSelect], Descriptor name: [ebs.CieEaiEvents]. Polling the database for events failed on this iteration.
Caused by BINDING.JCA-11622
Could not create/access the TopLink Session.
This session is used to connect to the datastore.
Caused by javax.resource.spi.InvalidPropertyException: Missing Property Exception.
Missing Property: [DBManagedConnectionFactory.userName].
You may have set a property (in _db.jca) which requires another property to be set also.
Make sure the property is set in the interaction (activation) spec by editing its definition in _db.jca.
.
You may need to configure the connection settings in the deployment descriptor (i.e. DbAdapter.rar#META-INF/weblogic-ra.xml) and restart the server. This exception is considered not retriable, likely due to a modelling mistake. This polling process will shut down, unless the fault is related to processing a particular row, in which case polling will continue but the row will be rejected (faulted).
.
This exception is considered not retriable, likely due to a modelling mistake. This polling process will shut down, unless the fault is related to processing a particular row, in which case polling will continue but the row will be rejected (faulted).

at oracle.tip.adapter.db.exceptions.DBResourceException.createNonRetriableException(DBResourceException.java:650)
at oracle.tip.adapter.db.exceptions.DBResourceException.createEISException(DBResourceException.java:616)
at oracle.tip.adapter.db.exceptions.DBResourceException.inboundReadException(DBResourceException.java:457)
at oracle.tip.adapter.db.InboundWork.handleException(InboundWork.java:827)
at oracle.tip.adapter.db.InboundWork.run(InboundWork.java:468)
at oracle.tip.adapter.db.inbound.InboundWorkWrapper.run(InboundWorkWrapper.java:43)
at oracle.integration.platform.blocks.executor.WorkManagerExecutor$1.run(WorkManagerExecutor.java:77)
at weblogic.work.j2ee.J2EEWorkManager$WorkWithListener.run(J2EEWorkManager.java:183)
at weblogic.work.DaemonWorkThread.run(DaemonWorkThread.java:30)
Caused by: BINDING.JCA-11622
Could not create/access the TopLink Session.
This session is used to connect to the datastore.
Caused by javax.resource.spi.InvalidPropertyException: Missing Property Exception.
Missing Property: [DBManagedConnectionFactory.userName].
You may have set a property (in _db.jca) which requires another property to be set also.
Make sure the property is set in the interaction (activation) spec by editing its definition in _db.jca.
.
You may need to configure the connection settings in the deployment descriptor (i.e. DbAdapter.rar#META-INF/weblogic-ra.xml) and restart the server. This exception is considered not retriable, likely due to a modelling mistake. This polling process will shut down, unless the fault is related to processing a particular row, in which case polling will continue but the row will be rejected (faulted).

at oracle.tip.adapter.db.exceptions.DBResourceException.createNonRetriableException(DBResourceException.java:650)
at oracle.tip.adapter.db.exceptions.DBResourceException.createEISException(DBResourceException.java:616)
at oracle.tip.adapter.db.exceptions.DBResourceException.couldNotCreateTopLinkSessionException(DBResourceException.java:288)
at oracle.tip.adapter.db.DBManagedConnectionFactory.acquireSession(DBManagedConnectionFactory.java:797)
at oracle.tip.adapter.db.transaction.DBTransaction.getSession(DBTransaction.java:396)
at oracle.tip.adapter.db.DBConnection.getSession(DBConnection.java:252)
at oracle.tip.adapter.db.InboundWork.init(InboundWork.java:282)
at oracle.tip.adapter.db.InboundWork.run(InboundWork.java:464)
... 4 more
Caused by: javax.resource.spi.InvalidPropertyException: Missing Property Exception.
Missing Property: [DBManagedConnectionFactory.userName].
You may have set a property (in _db.jca) which requires another property to be set also.
Make sure the property is set in the interaction (activation) spec by editing its definition in _db.jca.

at oracle.tip.adapter.db.exceptions.DBResourceException.missingPropertyException(DBResourceException.java:420)
at oracle.tip.adapter.db.DBManagedConnectionFactory.createServerSession(DBManagedConnectionFactory.java:1138)
at oracle.tip.adapter.db.DBManagedConnectionFactory.acquireSession(DBManagedConnectionFactory.java:540)
... 8 more

]]

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.