My Oracle Support Banner

Siebel DDLIMP Utility is not Started when Attemtping to Import Schema at Target Environment According Synchronous Full RR Without Using Migration Application Instructions (Doc ID 2498653.1)

Last updated on JANUARY 24, 2019

Applies to:

Siebel CRM - Version 18.11 and later
Information in this document applies to any platform.

Symptoms


ACTUAL BEHAVIOR
---------------

ddlimp is not being  executed after  entering all the details mentioned in Task #7 described in  the document below:

 

Bookshelf > SiebelDatabase Upgrade Guide  > Data Migration Using Siebel Migration > Process of Using Siebel Migration to Migrate Data > Synchronous Full RR Without using Migration Application

https://docs.oracle.com/cd/F14158_01/books/UPG/data-migration-using-siebel-migration.html#c_Sync_FullRR_without_Using_Sieb_Mig



EXPECTED BEHAVIOR
-----------------------
ddlimp should be executed and completed on target environment

STEPS
-----------------------
The issue can be reproduced at will with the following steps:


1. You must perform this task after the export procedure on source environment was finished
2. Copy the schema_export folder from <FS_PATH>\migration\ folder from the Source Machine
3. Paste the schema_export folder in <FS_PATH>\migration on the Target machine
4. Launch Target Call center or any other employee facing application
5. Navigate to Administration Business Service  Simulator
6. Create a new record in the Service methods list applet
a. Open the Service pick applet and search for “Migration Schema Service” by selecting the Name from the drop down
b. Open the Method pick applet and search for “Import” by selecting the Name from the drop down
7. Create a new record in the Input Arguments list applet
a. Open the Property Name pick field
b. Click the + icon on the pick applet
c. Type the Property Name as “migrationid”
d. Enter the Value as “schema_export”
e. Click the + icon on the pick applet
f. Type the Property Name as “filename”
g. Paste the value taken from Step #6 of Task#1 for the Property Value
h. Click the + icon on the pick applet
i. Type the Property Name as “username”
j. Enter the Value as Target Database Schema Username
k. Click the + icon on the pick applet
l. Type the Property Name as “password”
m. Covert the Target Database Schema Password into Base 64 and enter the converted value to the Value field
n. Click the Save icon
o. Click Ok to close the pick applet
8. Click the Run button
9. Ensure the process ddlimp is running in Target env
a. Use Task Manager for Windows and ps command for Non Windows
10. Wait till the ddlimp is completed successfully
a. You can check the log from <FS_PATH>\migration\schema_export\log folder in Target



Changes

 

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
Changes
Cause
Solution


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