I want to make system copy and getting error when trying to execute SMIGR_CREATE_DDL with following criteria
Database Version : 10 // i put manualy while no value in F4 against oracle
Unicode Migration Yes
Installation Directory: /tmp
Optional Parameter: NON
If i execute as a direct or background job with rdisp/max_wprun_time =0
rdisp/max_wprun_time = 1800 with direct and background job
Runtime Errors TIME_OUT
What happened? The program "SAPLSMIGR_ORA" has exceeded the maximum permitted runtime without interruption and has therefore been terminated.
so, i increased the value of parameter rdisp/max_wprun_time = 3600 then getting
Runtime Errors DATASET_NOT_OPEN
What happened? Error in the ABAP Application Program The current ABAP program "CL_SMIGR_DDL=====CP" had to be terminated because it has come across a statement that unfortunately cannot be executed.
your expert help is required.
> Installation Directory: /tmp
> Optional Parameter: NON
> If i execute as a direct or background job with rdisp/max_wprun_time =0
If you are on Windows there is no /tmp but you have to give a full directory/drive name (such as c:\temp)
This also explains the reason why the dataset (the file) could not be opened.
thxxxxxxxxx Markus for your reply....
SMIGR_CREATE_DDL successfully completed and now where i have to put this report(DFACT.SQL) on Target server.
now i directly exported the system with following path
System Import =
Oracle ->Source System -> Central System -> Based on AS ABAP -> Database Instance Export
but I did not used two following option
Table Splitting Preparation
Please confirm me that now i have to use above option or leave?
there is only one package interrupted during Import Abap phase,
+Loading of 'SAPAPPL1_29' import package: ERROR
Import Monitor jobs: running 0, waiting 27, completed 63, failed 1, total 91.+
while overall result
Import Monitor jobs: running 0, waiting 1, completed 89, failed 1, total 91. /* **** only one job failed
ERROR 2011-01-18 06:54:14
CJS-30022 Program 'Migration Monitor' exits with error code 103.
+ERROR: 2011-01-18 05:57:31 com.sap.inst.migmon.LoadTask run
Loading of 'SAPAPPL1_29' import package is interrupted with R3load error.
Process 'E:\usr\sap\TST\SYS\exe\uc\NTAMD64\R3load.exe -i SAPAPPL1_29.cmd
-dbcodepage 4103 -l SAPAPPL1_29.log -stop_on_error' exited with return code 2.
For mode details see 'SAPAPPL1_29.log' file.
Standard error output:
sapparam: sapargv( argc, argv) has not been called.
sapparam(1c): No Profile used.
sapparam: SAPSYSTEMNAME neither in Profile nor in Commandline+
+(IMP) INFO: import of TPALOG completed (97365 rows) #20110118055730
DbSl Trace: Error 1452 in exec_immediate() from oci_execute_stmt(), orpc=0
DbSl Trace: ORA-1452 occurred when executing SQL stmt (parse error offset=34)
(DB) ERROR: DDL statement failed
(CREATE UNIQUE INDEX "TPALOG~0" ON "TPALOG" ( "TRTIME", "TRKORR", "TARSYSTEM", "TRCLI", "TRSTEP" ) TABLESPACE PSAPSR3 STORAGE
(INITIAL 1208320 NEXT 0000000080K MINEXTENTS 0000000001 MAXEXTENTS
2147483645 PCTINCREASE 0 ) NOLOGGING COMPUTE STATISTICS )
DbSlExecute: rc = 99
(SQL error 1452)
error message returned by DbSl:
ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found .
/* how this key already exist in target system while all tables are generating from system Export file mean system was blank
(DB) INFO: disconnected from DB+
P TOPRK~0 C ok
T TPALOG C ok
D TPALOG I ok
P TPALOG~0 C err
T TPALOGHDR C xeq
D TPALOGHDR I xeq
P TPALOGHDR~0 C xeq
T TPDACTRL C xeq
now, what i have to do mean if i delete the index TPALOG~0 or change the err to OK then may be next index give error while there are still remaining lot of tables .
please guide how can i overcome on this issue for successful installation
Bump. anyone plz
why anyone is not replying of this post and if something wrong with this thread then tell me..
Edited by: majamil on Feb 1, 2011 4:01 PM
Since you are facing following error:
ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found
Please follow these notes regarding duplicate keys:
#11369 ORA-1452 during import after export from other
#23237 duplicate keys, duplicate rows, duplicate records