Thursday, 24 April 2014

ODI setup tips

1. Interface Flow IKM Selector Is <Undefined> Even IKM Has Already Been Imported (Doc ID 1453984.1)

SYMPTOMS:
Trying to create a new interface with IKM, such as IKM SQL to Hyperion Planning
The KM has already been imported but it does not show up on Interface -> Flow tab
IKM Selector is <Undefined>
The problem does not occur in Oracle Data Integrator 11.1.1.5

Cause Currently the issue is being investigated via unpublished BUG 13532957 - IKM SQL TO PLANNING COULD NOT BE SELECTED ON STAGING AREA

Solution:
 The following workaround is available :
1) After importing the IKM, open the KM and go to "Definition" -> "Source Technology"
2) Manually change "Source Technology" value from "Generic SQL" to "Undefined" 
3) Save and proceed with your new interface creation

No comments:

Post a Comment