when we are sending a transaction from EBS to SOA, we are getting below fault.
Non Recoverable System Fault :
Exception occured when binding was invoked. Exception occured during invocation of JCA binding: "JCA Binding execute of Reference operation 'AuthenticateTicket' failed due to: Could not create/access the TopLink Session. This session is used to connect to the datastore. Caused by Exception [EclipseLink-7060] (Eclipse Persistence Services - 2.1.2.v20101206-r8635): org.eclipse.persistence.exceptions.ValidationException Exception Description: Cannot acquire data source [EBizDataSource]. Internal Exception: javax.naming.NameNotFoundException: Unable to resolve 'EBizDataSource'. Resolved ''; remaining name 'EBizDataSource'. 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. ". The invoked JCA adapter raised a resource exception. Please examine the above error message carefully to determine a resolution.
1. Do other DB's connections works?
2. Can you run a simple bpel process that uses your EBizDataSource connection?
3. Did it work in the past or it failed on the first run?
4. Just to be sure - can you describe the steps of creating the conection in the WL (data source, conection pool etc...)
I am using only one DB.
when i tested it before there were no issues.
Creation of connection pool:
Click on DB Adapter. It will open window for settings of DB Adapter.
Select Configuration tab and then Outbound Connection pools tab. The window will open as below.
add new instance by clicking on New tab.
Check the option button for outbound Connection group and click next button and add the JNDI name ex: eis/DB/DbAdapterEbsAltrndomain.
Click on finish, it opens a window with Path, Current Location and Deployment order. Click on save.
Creation of Data source:
On the home page of console, select data source.
Create a new generic data source.
Provide name and JNDI name and click on next.
Select oracle driver (oracle driver for instance connection version 9.0.1 & later)>next.
Click next on Transactions page.
Provide all the details on connection properties page like database name, host name, port number, user id, and Password and click next.
Click on test configuration, it displays message test connection succeeded. And click next.
Select soa-server and click on finish.
Data source is created.
Go to summary of data sources.
After the data source i screated, go to deployments>db adapter>connection pool > add the jndi name of datasource like jdbc/EBizDataSource and click enter>save.
Select the data source>configuration >outbound connection pools>click on advanced>check the Test Connections on Reserve check box> save.
Displays message like settings updated successfully.
It looks ok beside that you need to create the data source first (not sure it is a problem but still...)
Can you create a simple bpel process and test the connection?
What you can do (just to be sure there is no corruption of the plan file) is recreate the DbAdapter - mark the DbAdapter deployment and delete it. After that create it again.
You will have to create the connection pool again.