I have created XML data server referencing local xml file. Testing Local (No Agent), Physical Schema, Logical Shema, Mapping… Everything worked fine. End then I have deleted everything.
Now when I try to create new XML data server referencing file on a server and try to test it with ODI Agent, I get error below.
My question is why this happens and how to fined object/table GEO_D_GEOGRAPHY_DIM to delete it?
Error:
oracle.odi.runtime.agent.invocation.InvocationException: oracle.odi.core.exception.OdiRuntimeException: java.sql.SQLSyntaxErrorException: object name already exists: GEO_D_GEOGRAPHY_DIM in statement [create table GEO_D_GEOGRAPHY_DIM(GEOGRAPHY_DIMPK NUMERIC(10) NOT NULL, SNPSFILENAME VARCHAR(255) NULL, SNPSFILEPATH VARCHAR(255) NULL, SNPSLOADDATE VARCHAR(255) NULL)]
at oracle.odi.runtime.agent.invocation.RemoteRuntimeAgentInvoker.invoke(RemoteRuntimeAgentInvoker.java:475)
at oracle.odi.runtime.agent.invocation.support.InternalRemoteRuntimeAgentInvoker.invoke(InternalRemoteRuntimeAgentInvoker.java:162)
at oracle.odi.runtime.agent.invocation.RemoteRuntimeAgentInvoker.invokeTestDataServer(RemoteRuntimeAgentInvoker.java:1155)
at com.sunopsis.graphical.dialog.SnpsDialogTestConnet.remoteTestConn(SnpsDialogTestConnet.java:915)
at com.sunopsis.graphical.dialog.SnpsDialogTestConnet$11.doInBackground(SnpsDialogTestConnet.java:873)
at oracle.odi.ui.framework.AbsUIRunnableTask.run(AbsUIRunnableTask.java:258)
at oracle.ide.dialogs.ProgressBar.run(ProgressBar.java:961)
at java.lang.Thread.run(Thread.java:748)