How to define data-sources-alias.xml to use Oracle data source

[Former Member]

Hi,

I created Oracle jdbc Data Source named "MYDS" in Visual Admin. I added the alias = MYDS_ALIAS. I set the Initial Connection to 2. On the Monitor tab, I see a green line running across the screen. The datasource MYDS is connected to the Oracle.

Now, I would like to define "data-sources-alias.xml" to use MYDS.

When creating data-source-aliases.xml it creates the alias by default on ${com.sap.datasource.default} which is the default DB.

I followed the link -->

and my data-sources-alias.xml is now:

<data-source-aliases>

<aliases>

<data-source-name>$</data-source-name>

<alias>BRANCH50DS</alias>

</aliases>

</data-source-aliases>

The "EAR generatation has finished successfully", but when "Deploy to J2EE Engine", I got the error below:

1) How to define data-sources-alias.xml to use Oracle data source?

2) I found the link () talking about "sda-dd.xml". How to create "sda-dd.xml" and make it use substitution variables "MYDS"

Dec 20, 2005 3:53:41 PM /userOut/deploy (com.sap.ide.eclipse.sdm.threading.DeployThreadManager) [Thread[Deploy Thread,5,main]] INFO:

[003]Additional log information about the deployment

<!LOGHEADER[START]/>

<!HELP[Manual modification of the header may cause parsing problem!]/>

<!LOGGINGVERSION[1.5.3.7181 - 630_SP]/>

<!NAME[C:\usr\sap\J2E\JC00\SDM\program\log\sdmcl20051220205339.log]/>

<!PATTERN[sdmcl20051220205339.log]/>

<!FORMATTER[com.sap.tc.logging.TraceFormatter(%24d %s: %m)]/>

<!ENCODING[Cp1252]/>

<!LOGHEADER[END]/>

Dec 20, 2005 3:53:39 PM Info: -

---

Starting deployment -

---

Dec 20, 2005 3:53:39 PM Info: Loading selected archives...

Dec 20, 2005 3:53:39 PM Info: Loading archive 'C:\usr\sap\J2E\JC00\SDM\program\temp\temp856850022Ear.ear'

Dec 20, 2005 3:53:40 PM Info: Selected archives successfully loaded.

Dec 20, 2005 3:53:40 PM Info: Actions per selected component:

Dec 20, 2005 3:53:40 PM Info: Update: Selected development component '50022Ear'/'sap.com'/'localhost'/'2005.12.20.15.53.28' updates currently deployed development component '50022Ear'/'sap.com'/'localhost'/'2005.12.19.18.39.12'.

Dec 20, 2005 3:53:40 PM Info: Saved current Engine state.

Dec 20, 2005 3:53:40 PM Info: Error handling strategy: OnErrorStop

Dec 20, 2005 3:53:40 PM Info: Update strategy: UpdateAllVersions

Dec 20, 2005 3:53:40 PM Info: Starting: Update: Selected development component '50022Ear'/'sap.com'/'localhost'/'2005.12.20.15.53.28' updates currently deployed development component '50022Ear'/'sap.com'/'localhost'/'2005.12.19.18.39.12'.

Dec 20, 2005 3:53:40 PM Info: SDA to be deployed: C:\usr\sap\J2E\JC00\SDM\root\origin\sap.com\50022Ear\localhost\2005.12.20.15.53.28\temp856850022Ear.ear

Dec 20, 2005 3:53:40 PM Info: Software type of SDA: J2EE

Dec 20, 2005 3:53:40 PM Info: ***** Begin of SAP J2EE Engine Deployment (J2EE Application) *****

Dec 20, 2005 3:53:41 PM Info: Begin of log messages of the target system:

05/12/20 15:53:40 - ***********************************************************

05/12/20 15:53:41 - Start updating EAR file...

05/12/20 15:53:41 - start-up mode is lazy

05/12/20 15:53:41 - com.sap.engine.deploy.manager.MissingSubstitutionException: Missing substitution value for variable [MYDS].

at com.sap.engine.deploy.manager.DeployManagerImpl.makeTempEar(DeployManagerImpl.java:3727)

at com.sap.engine.deploy.manager.DeployManagerImpl.makeNewEar1(DeployManagerImpl.java:3695)

at com.sap.engine.deploy.manager.DeployManagerImpl.deployUpdateAction(DeployManagerImpl.java:523)

at com.sap.engine.deploy.manager.DeployManagerImpl.update(DeployManagerImpl.java:512)

at com.sap.sdm.serverext.servertype.inqmy.extern.EngineApplOnlineDeployerImpl.performDeployment(EngineApplOnlineDeployerImpl.java:196)

at com.sap.sdm.serverext.servertype.inqmy.extern.EngineDeployerImpl.deploy(EngineDeployerImpl.java:96)

at com.sap.sdm.serverext.servertype.inqmy.EngineProcessor.executeAction(EngineProcessor.java:224)

at com.sap.sdm.app.proc.deployment.impl.PhysicalDeploymentActionExecutor.execute(PhysicalDeploymentActionExecutor.java:60)

at com.sap.sdm.app.proc.deployment.impl.DeploymentActionImpl.execute(DeploymentActionImpl.java:186)

at com.sap.sdm.app.proc.deployment.controllers.internal.impl.DeploymentExecutorImpl.execute(DeploymentExecutorImpl.java:46)

at com.sap.sdm.app.proc.deployment.states.eventhandler.ExecuteDeploymentHandler.executeAction(ExecuteDeploymentHandler.java:83)

at com.sap.sdm.app.proc.deployment.states.eventhandler.ExecuteDeploymentHandler.handleEvent(ExecuteDeploymentHandler.java:60)

at com.sap.sdm.app.proc.deployment.states.StateBeforeNextDeployment.processEvent(StateBeforeNextDeployment.java:127)

at com.sap.sdm.app.proc.deployment.states.InstContext.processEventServerSide(InstContext.java:73)

at com.sap.sdm.app.proc.deployment.states.InstContext.processEvent(InstContext.java:59)

at com.sap.sdm.app.sequential.deployment.impl.DeployerImpl.doPhysicalDeployment(DeployerImpl.java:127)

at com.sap.sdm.app.sequential.deployment.impl.DeployerImpl.deploy(DeployerImpl.java:96)

at com.sap.sdm.apiimpl.local.DeployProcessorImpl.deploy(DeployProcessorImpl.java:67)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:324)

at com.sap.sdm.is.cs.remoteproxy.server.impl.RemoteProxyServerImpl.requestRemoteCall(RemoteProxyServerImpl.java:127)

at com.sap.sdm.is.cs.remoteproxy.server.impl.RemoteProxyServerImpl.process(RemoteProxyServerImpl.java:38)

at com.sap.sdm.apiimpl.remote.server.ApiClientRoleCmdProcessor.process(ApiClientRoleCmdProcessor.java:81)

at com.sap.sdm.is.cs.session.server.SessionCmdProcessor.process(SessionCmdProcessor.java:67)

at com.sap.sdm.is.cs.cmd.server.CmdServer.execCommand(CmdServer.java:76)

at com.sap.sdm.client_server.launch.ServerLauncher$ConnectionHandlerImpl.handle(ServerLauncher.java:280)

at com.sap.sdm.is.cs.ncserver.NetCommServer.serve(NetCommServer.java:43)

at com.sap.sdm.is.cs.ncwrapper.impl.ServiceWrapper.serve(ServiceWrapper.java:39)

at com.sap.bc.cts.tp.net.Worker.run(Worker.java:50)

at java.lang.Thread.run(Thread.java:534)

05/12/20 15:53:41 - ***********************************************************

Dec 20, 2005 3:53:41 PM Info: End of log messages of the target system.

Dec 20, 2005 3:53:41 PM Info: ***** End of SAP J2EE Engine Deployment (J2EE Application) *****

Dec 20, 2005 3:53:41 PM Error: Aborted: development component '50022Ear'/'sap.com'/'localhost'/'2005.12.20.15.53.28':

Caught exception during application deployment from SAP J2EE Engine's deploy API:

com.sap.engine.deploy.manager.MissingSubstitutionException: Missing substitution value for variable [MYDS].

(message ID: com.sap.sdm.serverext.servertype.inqmy.extern.EngineApplOnlineDeployerImpl.performAction(DeploymentActionTypes).DMEXC)

Dec 20, 2005 3:53:41 PM Info: J2EE Engine is in same state (online/offline) as it has been before this deployment process.

Dec 20, 2005 3:53:41 PM Error: -

---

At least one of the Deployments failed -

---

[Former Member]

Hi Divakar

Thanks a lot. That solves the problem.

How can I reward point? The "Solve Problem" button went grey. I'll click the "Very Helpful Answers" instead.

-- Joe

[Former Member]

Hi,

If you remove the $ and braces (as shown below) it will work.

<data-source-aliases>

<aliases>

<data-source-name>MYDS</data-source-name>

<alias>BRANCH50DS</alias>

</aliases>

</data-source-aliases>

Regards,

S.Divakar