ORA-02291 (FK_PROF_METH2) Displayed During Import Of a Security Profile After ODI Repository Was Cloned/Renumbered

(Doc ID 2016362.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Data Integrator - Version and later
Information in this document applies to any platform.


After Oracle Data Integrator (ODI) Repository has been cloned and renumbered, the export / import of a Profile from one Oracle Business Intelligence Applications (OBIA) environment to another fails.

The following message is signalled while importing the Profile:

ODI-23040: Import File
"d:\filepath\security_prof.xml" error

com.sunopsis.tools.core.exception.SnpsSimpleMessageException: ODI-10036: Importing object SNP_PROFMETH : null failed.
  at com.sunopsis.dwg.DwgDuplicationTools.importOtherObjects(DwgDuplicationTools.java:3203)
  at com.sunopsis.dwg.DwgDuplicationTools.synonymImport(DwgDuplicationTools.java:2631)
  at com.sunopsis.dwg.DwgObject.importFromObjectLst(DwgObject.java:7467)
  at com.sunopsis.dwg.DwgObject.internalImportObjectList(DwgObject.java:6459)
  at com.sunopsis.dwg.DwgObject.doImport(DwgObject.java:6866)
  at com.sunopsis.dwg.DwgObject.importFromXml(DwgObject.java:6085)



Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms