Forum Stats

  • 3,767,914 Users
  • 2,252,729 Discussions
  • 7,874,380 Comments

Discussions

Error while migrating fdm to fdmee

Madhusudhan. M
Madhusudhan. M Business AnalystMember Posts: 1,904 Silver Trophy
edited Mar 22, 2018 9:12AM in EPM System Infrastructure

Followed as mentioned FDM to FDMEE Migration White Paper.

While migrating fdm to fdmee, we got issue below:

Caused by: Traceback (most recent call last):

  File "<string>", line 3, in <module>

  File "<string>", line 322, in createTargetApp

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.executeForRows(T4CPreparedStatement.java:1115)

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

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

at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3904)

at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1512)

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:597)

  1. java.sql.SQLSyntaxErrorException: java.sql.SQLSyntaxErrorException: ORA-00904: "PLAN6_NAME": invalid identifier

at org.python.core.PyException.fillInStackTrace(PyException.java:70)

at java.lang.Throwable.<init>(Throwable.java:181)

at java.lang.Exception.<init>(Exception.java:29)

at java.lang.RuntimeException.<init>(RuntimeException.java:32)

at org.python.core.PyException.<init>(PyException.java:46)

at org.python.core.PyException.doRaise(PyException.java:200)

at org.python.core.Py.makeException(Py.java:1166)

at org.python.core.Py.makeException(Py.java:1170)

at org.python.core.Py.makeException(Py.java:1174)

at org.python.core.Py.makeException(Py.java:1178)

at org.python.pycode._pyx8.createTargetApp$3(<string>:336)

at org.python.pycode._pyx8.call_function(<string>)

at org.python.core.PyTableCode.call(PyTableCode.java:165)

at org.python.core.PyBaseCode.call(PyBaseCode.java:297)

at org.python.core.PyBaseCode.call(PyBaseCode.java:191)

at org.python.core.PyFunction.__call__(PyFunction.java:385)

at org.python.core.PyMethod.__call__(PyMethod.java:215)

at org.python.core.PyMethod.instancemethod___call__(PyMethod.java:221)

at org.python.core.PyMethod.__call__(PyMethod.java:206)

at org.python.core.PyObject.__call__(PyObject.java:367)

at org.python.core.PyObject.__call__(PyObject.java:371)

at org.python.pycode._pyx11.f$0(<string>:3)

at org.python.pycode._pyx11.call_function(<string>)

at org.python.core.PyTableCode.call(PyTableCode.java:165)

at org.python.core.PyCode.call(PyCode.java:18)

Any inputs would be appreciated..!!

Thanks,

Mady

Tagged:

Best Answer

Answers

  • SureshM-Oracle
    SureshM-Oracle Member Posts: 407 Employee
    edited Mar 21, 2018 10:53AM

    What's the migration path i.e which version to which version?

    Did you use patch 21379349 to download the utility?

    Does the "PLAN6_NAME" exists?

    Review ODI operator if you can any errors in it.

    Also see if this doc helps(if incase you did not look it before)

    Madhusudhan. M
  • Madhusudhan. M
    Madhusudhan. M Business Analyst Member Posts: 1,904 Silver Trophy
    edited Mar 22, 2018 2:38AM

    I am checking white paper only Suresh, Patch is there. Plan6_name doesn't exist.

    Version is same 11.1.2.3 both. I am migrating fdm app to fdmee app.

    from ODI Operator only i posted error msg here.

    Thanks,

    Mady

  • User_7EQ9Q
    User_7EQ9Q Member Posts: 142 Blue Ribbon
    edited Mar 22, 2018 3:19AM

    Hi Mady,

    Bet you would have checked the XML file which you imported in ODI, do let know if you were able to spot the app name in that file?

    Thanks

    A

    Madhusudhan. M
  • Madhusudhan. M
    Madhusudhan. M Business Analyst Member Posts: 1,904 Silver Trophy
    edited Mar 22, 2018 3:41AM

    XML file with app name??

    while executing i am changing app name.

    Thanks,

    Mady

  • Madhusudhan. M
    Madhusudhan. M Business Analyst Member Posts: 1,904 Silver Trophy
    edited Mar 22, 2018 9:12AM Accepted Answer

    I have created whatever columns and re-run scenario for creating app.

    All good now.

    Thanks,

    Mady

This discussion has been closed.