Error while migrating fdm to fdmee

Madhusudhan. M

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

Madhusudhan. M

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

All good now.

Thanks,

Mady

SureshM-Oracle

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)

Oracle Hyperion Financial Data Quality Management (FDM) to Oracle Hyperion Financial Data Quality Management, Enterprise Edition (FDMEE) - White Paper on FDM to FDMEE Migration Utility (Doc ID 2077244.1)

Madhusudhan. M

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

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

XML file with app name??

while executing i am changing app name.

Thanks,

Mady

Madhusudhan. M

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

All good now.

Thanks,

Mady