13 Replies Latest reply: Jul 24, 2013 2:19 PM by _Phil RSS

    view with dblink on ODI

    user11931614

      hi,

       

      create a view on the target, this view contains a dblink. When I want to see the data in ODI shows me the following error message

       

       

      anyone can help me

       

      ava.sql.SQLException: ORA-28267: Invalid NameSpace Value

      ORA-02063: line precediendo a COM_DMOLPERU

       

      at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)

      at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)

      at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931)

      at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481)

      at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205)

      at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:548)

      at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:217)

      at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:947)

      at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1283)

      at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1441)

      at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3769)

      at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3823)

      at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1671)

      at com.borland.dx.sql.dataset.o.f(Unknown Source)

      at com.borland.dx.sql.dataset.QueryProvider.e(Unknown Source)

      at com.borland.dx.sql.dataset.JdbcProvider.provideData(Unknown Source)

      at com.borland.dx.dataset.StorageDataSet.refresh(Unknown Source)

      at com.borland.dx.sql.dataset.QueryDataSet.refresh(Unknown Source)

      at com.sunopsis.graphical.frame.edit.AbstractEditFrameGridBorland.initialize(AbstractEditFrameGridBorland.java:628)

      at com.sunopsis.graphical.frame.edit.AbstractEditFrameGridBorland.<init>(AbstractEditFrameGridBorland.java:868)

      at com.sunopsis.graphical.frame.edit.EditFrameTableData.<init>(EditFrameTableData.java:50)

      at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

      at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)

      at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)

      at java.lang.reflect.Constructor.newInstance(Constructor.java:513)

      at oracle.odi.ui.editor.AbstractOdiEditor$1.run(AbstractOdiEditor.java:176)

      at oracle.ide.dialogs.ProgressBar.run(ProgressBar.java:655)

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