Unable to find data source null [Caused by: jdbc/Apps1DataSource not found]

October 11 0
Advertisement
Hi,
I am using OA Adapter which listens to an EBiz HRMS event, and I am encountering the following error in $Home\j2ee\oc4j_soa\log\oc4j_soa_default_group_1\oc4j\log.xml while registering the ESB service.
Error details:
<MSG_TEXT>Failed to process control event for Service "DefaultSystem.SyncWorkerPartyEbizOAAdapter" due to an error while adding the Service! Reason : oracle.tip.esb.server.common.exceptions.BusinessEventFatalException: An unhandled exception has been thrown in the ESB system. The exception reported is: "ORABPEL-12517
AdapterFrameworkImpl::endpointActivation - Endpoint Activation Error.
The Resource Adapter Oracle Applications Resource Adapter was unable to activate the endpoint oracle.tip.adapter.apps.AppsWFBesQueueDequeueActivationSpec:{MessageSelectorRule=tab.user_data.event_name = 'oracle.apps.per.api.person.update_person', QueueName=WF_BPEL_Q, Consumer=ORA_6krj2dpn70s36c1g6h1k8dhi8h, DatabaseSchema=APPS, AppsEventSchema=ANY_SCHEMA} due to the following reason: javax.resource.ResourceException: Unable to find data source null Caused by: jdbc/Apps1DataSource not found
Please correct the reported issue and redeploy the BPEL process.
     at oracle.tip.adapter.fw.jca.AdapterFrameworkImpl.endpointActivation(AdapterFrameworkImpl.java:566)
     at oracle.tip.esb.server.service.impl.inadapter.ESBActivationAgent.activateInboundJcaEndpoint(ESBActivationAgent.java:390)
     at oracle.tip.esb.server.service.impl.inadapter.ESBActivationAgent.performEndpointActivation(ESBActivationAgent.java:306)
     at oracle.tip.esb.server.service.impl.inadapter.ESBActivationAgent.activateEndpoint(ESBActivationAgent.java:236)
     at oracle.tip.esb.server.service.impl.inadapter.ESBActivationAgent.activateEndpoint(ESBActivationAgent.java:209)
     at oracle.tip.esb.server.service.impl.inadapter.InboundAdapterService.activateEndpoint(InboundAdapterService.java:177)
     at oracle.tip.esb.server.service.impl.inadapter.InboundAdapterService.activateService(InboundAdapterService.java:119)
     at oracle.tip.esb.server.service.EsbServiceFactory.activateEsbService(EsbServiceFactory.java:222)
     at oracle.tip.esb.server.service.EsbServiceFactory.addEsbService(EsbServiceFactory.java:240)
     at oracle.tip.esb.server.common.RuntimeESBSystem.addService(RuntimeESBSystem.java:211)
     at oracle.tip.esb.common.system.ServiceEventsHandler.handleCreateService(ServiceEventsHandler.java:72)
     at oracle.tip.esb.common.system.MetadataChangeListener.handleServiceEvent(MetadataChangeListener.java:136)
     at oracle.tip.esb.common.system.MetadataChangeListener.onMetadataChange(MetadataChangeListener.java:85)
     at oracle.tip.esb.common.control.ControlMessageHandler.handleMessage(ControlMessageHandler.java:115)
     at oracle.tip.esb.server.dispatch.agent.ESBWork.process(ESBWork.java:162)
     at oracle.tip.esb.server.dispatch.agent.ESBWork.run(ESBWork.java:120)
     at oracle.j2ee.connector.work.WorkWrapper.runTargetWork(WorkWrapper.java:242)
     at oracle.j2ee.connector.work.WorkWrapper.doWork(WorkWrapper.java:215)
     at oracle.j2ee.connector.work.WorkWrapper.run(WorkWrapper.java:190)
     at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(PooledExecutor.java:814)
     at java.lang.Thread.run(Thread.java:595)
Caused by: javax.resource.ResourceException: Unable to find data source null
     at oracle.tip.adapter.apps.AppsManagedConnectionFactory.getDataSourceConnection(AppsManagedConnectionFactory.java:411)
     at oracle.tip.adapter.apps.AppsManagedConnectionFactory.getConnection(AppsManagedConnectionFactory.java:288)
     at oracle.tip.adapter.apps.AppsManagedConnection.getConnection(AppsManagedConnection.java:85)
     at oracle.tip.adapter.apps.AppsConnection.getJdbcConnection(AppsConnection.java:70)
     at oracle_tip_adapter_apps_AppsConnection_Proxy.getJdbcConnection()
     at oracle.tip.adapter.aq.database.MessageReader.establishDBconnection(MessageReader.java:358)
     at oracle.tip.adapter.aq.database.MessageReader.&lt;init>(MessageReader.java:265)
     at oracle.tip.adapter.aq.inbound.AQActivationSpecDequeuer.init(AQActivationSpecDequeuer.java:142)
     at oracle.tip.adapter.aq.AQEndpoint.&lt;init>(AQEndpoint.java:99)
     at oracle.tip.adapter.aq.AQResourceAdapter.endpointActivation(AQResourceAdapter.java:73)
     at oracle.tip.adapter.apps.AppsResourceAdapter.endpointActivation(AppsResourceAdapter.java:147)
     at oracle.tip.adapter.fw.jca.AdapterFrameworkImpl.endpointActivation(AdapterFrameworkImpl.java:541)
     ... 20 more
Caused by: javax.naming.NameNotFoundException: jdbc/Apps1DataSource not found
     at com.evermind.server.rmi.RMIServerContext.lookup(RMIServerContext.java:207)
     at com.evermind.server.ApplicationContext.unprivileged_lookup(ApplicationContext.java:257)
     at com.evermind.server.ApplicationContext.lookup(ApplicationContext.java:197)
     at javax.naming.InitialContext.lookup(InitialContext.java:351)
     at oracle.tip.adapter.apps.AppsManagedConnectionFactory.getDataSourceConnection(AppsManagedConnectionFactory.java:408)
     ... 31 more
</MSG_TEXT>
I have added the connection properties in $Home\j2ee\oc4j_soa\application-deployments\defaul\oc4j-ra.xml as follows:
<connector-factory location="eis/Apps/apps1" connector-name="Oracle Applications Adapter">
     <config-property name="xADataSourceName" value="jdbc/AIADataSource"/>
     <config-property name="dataSourceName" value=""/>
     <connection-pooling use="none">
     </connection-pooling>
     <security-config use="none">
     </security-config>
</connector-factory>
Please correct me if the connection properties are wrong.
I tried AppsEventSchema with 'NO-SCHEMA' and 'ANY-SCHEMA' also.
If I use File Adapter I was able to register the ESB and instances were created successfully.
My versions:
JDEV:      10.1.3.3.0
SOA:     10.1.3.3.0
I have done a lot of research on this but in vain. Is there any patch for rectifying this error?
Help me on this issue pl.
Regards
RK
Advertisement
You need to check your datasource name jdbc/AIADataSource
Check out your data-sources.xml to make sure you didn't mistype it.
Unable to find data source null [Caused by: jdbc/Apps1DataSource not found]

Hi, I am using OA Adapter which listens to an EBiz HRMS event, and I am encountering the following error in $Home\j2ee\oc4j_soa\log\oc4j_soa_default_group_1\oc4j\log.xml while registering the ESB service. Error details: <MSG_TEXT>Failed to process c

JNDI failure. Unable to lookup Data Source

Dear all I'm running my ADF application from the jdeveloper integrated web logic server and every thing is ok. My project contains BC and a bounded tasklflow that contains two views. the problem happened when I changed the connection type of the appl

JNDI failure. Unable to lookup Data Source at context jdbc/AppsDatasource

I'm not able to run my Application locally due to issue "JNDI failure. Unable to lookup Data Source at context jdbc/APPSnonXA", I did the following under debugging. 1. Finding SPACE in DataSource, I verified 1a. The data source for spaces and co

Unable to find data source

Hi All, we have installed standard cubes and ODS from Business content. Now we want to load standard ODS but we are unable to identify standard data source. 0CPR_C03 -  Infocube. We have already checked in BI Content and help.sap.com but it doesnot d

Unable to find data source in bw server

Hai Experts, Iam novice to bw,got a problem in co-pa extraction, created data source in R/3 n generated,in bw to assign data source to infosource n create info package.But i dont find the infosource or replicated data in bw,could any one suggest how

Unable to change data source of any report

Hello there, I am using the Crystal Reports Eclipse plugin. I added a datasource to Eclipse 3.3 which connects to a Oracle database using JDBC. Now I want to change the data source of a report. I get a popup window which displays the old data source

Unable to change data source at runtime

I have a simple Crystal Report based on a MS-SQL stored procedure that takes one parameter.  I developed it against my dev database, so when I run the application, I want to point it at our production database, but no matter what I do, it always call

Unable to create Data source on SAP R/3 Side

Hi I want to create a Data Source in SAP R/3 After having given the Application Component SAP R/3 and Table Name(for extraction by view/table). During save it gives an error "You are not allowed to change cross-client Customizing." Please let me

Unable to create data source for planning via workspace

I have installed the following products in Hyperion 11.1.2 - Foundation - Essbase, EAS - Planning - Reporting & Analysis However, when I log in to Workspace (http://server:19000/workspace, I only see the following menu options under Navigate -> Adm

Data Sources error:[Macromedia][SQLServer JDBC Driver]No more data available to read.

I have just set up the developer edition coldfusion and a standard SQL Server. When trying to set up a datasource i recieve the following error:  [Macromedia][SQLServer JDBC Driver]No more data available to read. I have no clue what this means. I hav

Unable to post data to a database via JDBC adapter in PI 7.1

Hello experts, The scenario I am trying to implement is Proxy -- to -- JDBC. Earlier it was assumed that the table has primary key and therefore I started with UPDATE_INSERT structure but later on we came to know that the table does not have any prim

Unable to find a data source in RSA5 which can be seen in RSA3.

Hi there, I am unable to find the business content data sources in RSA5, but I can find the same data sources in RSA3 (extract checker). I need these data sources to be replicated to BW and take it up further. Any light on the above issue will be of

Using JDBC Data Sources with ADFBC, NoInitialContextException

Using JDBC Data Sources with ADF Business Components, NoInitialContextException I follow the instruction in the link below to create an ADF Swing application using datasource. I am using JDeveloper version 10.1.3. http://www.oracle.com/technology/pro

Problem with finding data-source

I get the following exception: javax.naming.NameNotFoundException: jdbc/localDatabaseDS not found when i try to initiate my ds (datasource). Does anybody know what to do? class = import java.sql.Connection; import java.sql.SQLException; import javax.

ADF BC standalone app and JDBC data source

Hi, I have created a small ADF BC (swing) application that is not using ANY application server. It's just a small rich client app. It's using a table on an Oracle database. In JDeveloper I have set the Connection Type in the AppModule to JDBC URL and

Problem using JDBC (JNDI) DataSource and data-sources.xml w/ OC4J

I have a JClient application developed in JDev X. It works fine when using a JDBC URL for the connection (which then writes the connection into the BC4J.xcfg files, one for each application module). However, I would like the app to retrieve the data

Weblogic Data source is not releasing connections

Hi All, Weblogic JDBC data source is not releasing connection until JDBC connection is deleted and created again. Could you please let me know this is a database issue or weblogic jdbc driver issue. We are using weblogic 10.1. Please see the followin

Connection verification failed for data source using mySQL

Hi, I having problem with mySQL datasource and getting the above error. This is only happening in our staging server. We are using ColdFusion 8 running JRUN4 and trying to connect to mySQL v 5.1.41. I tried adding DSN from my localhost using ColdFusi

Connection verification failed for data source:

Hi, I having problem with mySQL  datasource and getting the above error. This is only happening in our  staging server. We are using ColdFusion 8 running JRUN4 and trying to  connect to mySQL v 5.1.41. I tried adding DSN from my localhost using  Cold

Cannot set up data source for SQL Server 2005

Is it possible to use Microsoft's Beta 2 version of the SQL Server 2005 JDBC driver with WebLogic 9.0? I've downloaded the driver and added it to my server classpath, but when I try to create a new data source using the admin console, the drop-down l