My Oracle Support Banner

Errors When Attempting To Create A New ODI 11G Oracle Master Repository On An Oracle Database Schema From A Micrososft SQL Server Master Repository Export File (Doc ID 1498937.1)

Last updated on JUNE 16, 2022

Applies to:

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

Symptoms

When attempting to import and overwrite an ODI 11g Master repository implemented on Oracle database schema with an export file coming from Microsoft SQL Server with the following steps :

  1. Launch ODI 11.1.1.6.3 Studio on Oracle Master Repository
  2. Go to File Menu > New > Master repository Import Wizard (Creates a new master Rep using an existing export file) + OK button
  3. Select Database connection parameters and test the connection
  4. Set new Master Repository ID 
  5. Select either zip file or Export Parth of EXPORT MASTER REP file coming from Microsoft SQL Server
  6. SELECT TECHNOLOGY (by this we understand SOURCE TECHNOLOGY - in this case Microsoft SQL Server
  7. Click Finish...operation start and aborts with error message :

      oracle.odi.setup.RepositorySetupException: java.lang.RuntimeException: Error while executing create table SNP_ACTION
    (
     I_TXT_DESC NUMERIC(10) NULL ,
     LAST_USER NVARCHAR(400) NULL ,
    .......
    )
    at oracle.odi.setup.support.MasterRepositorySetupImpl.internalCreateMaster(MasterRepositorySetupImpl.java:152)
    at oracle.odi.setup.support.MasterRepositorySetupImpl.createMasterRepositoryFromExport(MasterRepositorySetupImpl.java:261)
    at oracle.odi.ui.gallery.support.MasterImportRepositoryPage.invoke(MasterImportRepositoryPage.java:228)
    at oracle.odi.ui.gallery.support.AbstractMasterRepositoryWizard$2.run(AbstractMasterRepositoryWizard.java:156)
    at oracle.ide.dialogs.ProgressBar.run(ProgressBar.java:656)
    at java.lang.Thread.run(Thread.java:662)
    ......

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.