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

Last updated on MARCH 08, 2017

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

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