OBIA 11.1.1.8.1 with JDE-Importing Source Adapter Metadata Content into the New ODI Repository failing with SnpPop Does Not Exist (Doc ID 1990071.1)

Last updated on JANUARY 31, 2017

Applies to:

Business Intelligence Applications Consumer - Version 11.1.1.8.1 and later
Information in this document applies to any platform.

Symptoms

Installed OBIA 11.1.1.8.1 and Applied PB6 patch as using JDE as source
You have a source JDE on Microsoft SQL server. To use it there is addition configuration required:

Business Intelligence Applications Installation Guide

Chapter 6 Deploying the ODI Repository for Non-Oracle Source Databases
6.5 Importing Source Adapter Metadata Content into the New ODI Repository

Running the Command Line Utility to Import Source Adapter Metadata Content involves 2 steps:

1) importing meta data --> OBIA 11
2) Import metadata for Source Adopters

Getting an error when trying to import metadata for source adopters, which is JDE_MSSQL adopter using the following command:


/u01/app/oracle/product/obiadev/Oracle_BI1/jdk/bin/java \-client \-Xms32m \-Xmx1024m \-classpath "/u01/app/oracle/product/obiadev/Oracle_ODI1/oracledi.sdk/lib/*:/u01/app/oracle/product/obiadev/Oracle_ODI1/inventory/Scripts/ext/jlib/*:/u01/app/oracle/product/obiadev/Oracle_ODI1/modules/oracle.idm_11.1.1/*:/u01/app/oracle/product/obiadev/Oracle_ODI1/modules/oracle.jps_11.1.1/*:/u01/app/oracle/product/obiadev/Oracle_BI1/biapps/lib/*:/u01/app/oracle/product/obiadev/Oracle_BI1/biapps/biaodiutil/lib/bia-odi-util.jar" oracle.apps.biaodiutil.Import MODE=IMPREGEN FILEDIR=/u01/app/456 PLV=JDE_9_1 JPSCONFIGFILE=/u01/app/oracle/product/obiadev/user_projects/domains/bifoundation_domain/odi-client-config/embedded/\jps-config-jse.xml LOGDIR=/u01/app/456/Work_DIr SRCTECH=MICROSOFT_SQL_SERVER

Error :

**************************************************************************
2015/Mar/06 09:39:15 Error while generating Scenario BI Apps Project/Mappings/SDE_JDEE1_91_Adaptor/SDE_JDE_PurchaseCostFact_MatchUpdate/SDE_JDE_PurchaseCostFact_MatchUpdate
**************************************************************************
com.sunopsis.core.SnpsInexistantObjectException: SnpPop.getObjectByIdent : SnpPop does not exist

java.lang.Thread.getStackTrace(Thread.java:1479)
oracle.apps.bi.odi.scengen.ScenGenerationUtil.genScenFolder(ScenGenerationUtil.java:195)
oracle.apps.bi.odi.scengen.ScenGeneration.callGenScen(ScenGeneration.java:739)
oracle.apps.bi.odi.scengen.ScenGeneration.genScenFoldList(ScenGeneration.java:857)
oracle.apps.bi.odi.scengen.ScenGeneration.genScenFoldList(ScenGeneration.java:885)
oracle.apps.bi.odi.scengen.ScenGeneration.genScenarios(ScenGeneration.java:686)
oracle.apps.bi.odi.scengen.ScenGeneration.runScenRegen(ScenGeneration.java:904)
oracle.apps.biaodiutil.Import.regenAdaptorScen(Import.java:313)
oracle.apps.biaodiutil.Import.runImportAdaptor(Import.java:553)
oracle.apps.biaodiutil.Import.main(Import.java:577)



Cause

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