Friday, July 10, 2015

ODI-26039 Connection Failed SnpConnect does not exit

After successful creation of Physical Connection for topology , whenever i would like to test connection below error occured.

--------------------------------------------------------------------------------------------------------------------------------------------------------------------

[2015-07-10T11:16:56.605+03:00] [] [ERROR] [ODI-1131] [] [tid: 138] [ecid: 0000KtqYh5M2zG15zvP5iW1LbDz400001H,0] Agent XXX encountered an error: c.getObjectByIdent :  SnpConnect does not exist[[
oracle.odi.runtime.agent.ExecutionException: SnpConnect.getObjectByIdent :  SnpConnect does not exist
        at oracle.odi.runtime.agent.processor.impl.TestDataServerProcessor.doProcessRequest(TestDataServerProcessor.java:144)
        at oracle.odi.runtime.agent.processor.SimpleAgentRequestProcessor.process(SimpleAgentRequestProcessor.java:49)
        at oracle.odi.runtime.agent.support.DefaultRuntimeAgent.execute(DefaultRuntimeAgent.java:68)
        at oracle.odi.runtime.agent.servlet.AgentServlet.processRequest(AgentServlet.java:512)
        at oracle.odi.runtime.agent.servlet.AgentServlet.doPost(AgentServlet.java:442)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
        at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:502)
        at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:389)
        at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216)
        at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181)
        at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:765)
        at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:417)
        at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
        at org.mortbay.jetty.Server.handle(Server.java:326)
        at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:534)
        at org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:879)
        at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:747)
        at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:218)
        at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404)
        at org.mortbay.jetty.bio.SocketConnector$Connection.run(SocketConnector.java:228)
        at org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:520)



--------------------------------------------------------------------------------------------------------------------------------------------------------------------

There was no error at connection string, username or password. Maybe error was about agent and new agent was created. But starting agent was not also successful and another error occured like below ,

--------------------------------------------------------------------------------------------------------------------------------------------------------------------



Agent NEWAGENT encountered an error: ODI-1405: Agent NEWAGENT start failure: the agent is not defined in the topology for master repository.
--------------------------------------------------------------------------------------------------------------------------------------------------------------------

This error gave some clue and in odiparams.sh file wrong setting of ODI_MASTER_URL was observed.After setting to proper value , everything gone fine.