Monday, August 24, 2015

[Solved] ODI-26039 - java.sql.SQLException: Object already exists

Scenario: Creating an XML Data Server in ODI Studio > Topology > Techonologies > XML and testing connection twice or deleting and creating the same XML Data Server in that same ODI Studio session

Error Description: ODI-26039 Connection Failed. java.sql.SQLException: object name already exists.

ODI Error Object Name Already Exists

Cause: This is because the first time you created the XML Data Server or tested the connection ODI created and stored the objects for this particular XML file in it's JVM.

Resolution: Well this is embarrassing. Hope ODI resolves this in the future. You have to close ODI Studio and open a new session and try again.

ODI XML Data server Successful connection
Courtesy: oracle.developer-works
Posted by at
Labels: ,

1 comment:

  1. vikas mishraAugust 23, 2017 at 12:39 AM

    I have the same error and i closed ODI opened a new session . In fact i restarted the agent and i still get the same error cause of which the iam not able to test the XML physical connection

    ReplyDelete

Subscribe to: Post Comments (Atom)