java.sql.SQLException: ORA-12154: TNS:could not resolve the connect identi

[Former Member]

Hi,

I am using Netweaver 2004 with oracle 10g and I am integrating xMII and visiprise application.

while sending the production order from xMII to visiprise webservice call is failed.

I am getting the following error.

u2022 [ERROR]: STEP EXCEPTION (TerminateTxnOnWebServiceFailure) : WebServiceDelegate.TerminateTxnOnWebServiceFailure: Terminated the txn because of webservice call failure. The failure message is: com.visiprise.frame.webservices.StackTraceRemoteException: java.rmi.RemoteException: null; nested exception is: Exception Occurred. Exception is javax.ejb.EJBException: nested exception is: java.sql.SQLException: ORA-12154: TNS:could not resolve the connect identifier specified javax.ejb.EJBException: nested exception is: java.sql.SQLException: ORA-12154: TNS:could not resolve the connect identifier specified at com.genrad.frame.SystemBase.executeQuery(SystemBase.java:599) at com.genrad.frame.SystemBase.executeQuery(SystemBase.java:525) at com.genrad.app.core.prod.server.RevisionHelper.getNewInnerRevision(RevisionHelper.java:40) at com.visiprise.app.core.services.productionOrder.BOMHandler.processOrderSpecificBOMComparison(BOMHandler.java:477) at com.visiprise.app.core.services.productionOrder.BOMHandler.processProductionOrderBOMupdate(BOMHandler.java:346) at com.visiprise.app.core.services.productionOrder.BOMHandler.update(BOMHandler.java:82) at com.genrad.app.core.prod.server.BasicProductionOrderWorkflow.handle(BasicProductionOrderWorkflow.java:179) at com.genrad.app.core.prod.server.BasicProductionOrderWorkflow.handleBOM(BasicProductionOrderWorkflow.java:130) at com.genrad.app.core.prod.server.BasicProductionOrderWorkflow.handleItemRouterBOM(BasicProductionOrderWorkflow.java:154) at com.genrad.app.core.prod.server.BasicProductionOrderWorkflow.processCreate(BasicProductionOrderWorkflow.java:43) at com.genrad.app.core.prod.server.ProductionOrderSOBean.create(ProductionOrderSOBean.java:79) at com.genrad.app.core.prod.server.ProductionOrderSOLocalObjectImpl150.create(ProductionOrderSOLocalObjectImpl150.java:115) at com.visiprise.app.core.services.productionOrder.ProductionOrderPersister.createOrUpdate(ProductionOrderPersister.java:133) at com.visiprise.app.core.services.GenericVOServiceImpl.createOrUpdate(GenericVOServiceImpl.java:71) 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.visiprise.frame.proxy.DefaultInterceptor.intercept(DefaultInterceptor.java:30) at com.visiprise.frame.proxy.InterceptorChain.process(InterceptorChain.java:45) at com.visiprise.frame.proxy.ProxyContext.process(ProxyContext.java:62) at com.visiprise.app.core.services.AccessControlInterceptor.intercept(AccessControlInterceptor.java:41) at com.visiprise.frame.proxy.InterceptorChain.process(InterceptorChain.java:45) at com.visiprise.frame.proxy.GenericSOProxy.invoke(GenericSOProxy.java:79) at $Proxy146.createOrUpdate(Unknown Source) 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.visiprise.frame.webservices.axis.FactoryRPCProvider.invokeMethod(FactoryRPCProvider.java:108) at org.apache.axis.providers.java.RPCProvider.processMessage(RPCProvider.java:186) at org.apache.axis.providers.java.JavaProvider.invoke(JavaProvider.java:323) at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:32) at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:118) at org.apache.axis.SimpleChain.invoke(SimpleChain.java:83) at org.apache.axis.handlers.soap.SOAPService.invoke(SOAPService.java:453) at org.apache.axis.server.AxisServer.invoke(AxisServer.java:281) at org.apache.axis.transport.http.AxisServlet.doPost(AxisServlet.java:699) at javax.servlet.http.HttpServlet.service(HttpServlet.java:760) at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:327) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at com.sap.engine.services.servlets_jsp.server.HttpHandlerImpl.runServlet(HttpHandlerImpl.java:390) at com.sap.engine.services.servlets_jsp.server.HttpHandlerImpl.handleRequest(HttpHandlerImpl.java:264) at com.sap.engine.services.httpserver.server.RequestAnalizer.startServlet(RequestAnalizer.java:347)

Can anyone please help

[Former Member · Accepted solution]

Hi,

Please go thr this link, i hope it will help you

http://ora-12154.ora-code.com/

Thanks,

Sreeni.

[kishore_soma]

Is linstener started, if yes, then try the below command

tnsping <SID>

This should give you output ok(msec)

If it is not giving ok, then first solve that problem.

[TomCenens]

Dear

Can you please give more detail to help solve this issue ?

Can you post the configuration made in the webservice, your tnsnames.ora content, your listener.ora content and any other log content that is valuable information ?

Kind regards

Tom

[Former Member]

Hi ,

we have configured wrong SID.Thanks for the help