Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 63 Insurance
- 536.4K On-Premises Infrastructure
- 138.3K Analytics Software
- 38.6K Application Development Software
- 5.8K Cloud Platform
- 109.5K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71.1K Infrastructure Software
- 105.3K Integration
- 41.6K Security Software
Error while migrating fdm to fdmee

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)
- 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
Best Answer
-
I have created whatever columns and re-run scenario for creating app.
All good now.
Thanks,
Mady
Answers
-
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)
-
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
-
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
-
XML file with app name??
while executing i am changing app name.
Thanks,
Mady
-
I have created whatever columns and re-run scenario for creating app.
All good now.
Thanks,
Mady