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 OCTOBER 25, 2023
Applies to:
Oracle Data Integrator - Version 11.1.1.6.3 and laterOracle Data Integrator on Marketplace - Version 1.0.2 and later
Information in this document applies to any platform.
Symptoms
When attempting to import and overwrite an Oracle Data Integrator (ODI) 11g Master repository implemented on Oracle database schema with an export file coming from Microsoft SQL Server with the following steps :
- Launch ODI 11.1.1.6.3 Studio on Oracle Master Repository
- Go to File Menu > New > Master repository Import Wizard (Creates a new master Rep using an existing export file) + OK button
- Select Database connection parameters and test the connection
- Set new Master Repository ID
- Select either zip file or Export Parth of EXPORT MASTER REP file coming from Microsoft SQL Server
- SELECT TECHNOLOGY (by this we understand SOURCE TECHNOLOGY - in this case Microsoft SQL Server
- Click Finish...operation start and aborts with error message :
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! |