7 Replies Latest reply: Feb 1, 2011 2:44 PM by John Feely RSS

SMIGR_CREATE_DDL for  System Copy

M. Abdul Jamil
Currently Being Moderated

Dear All,

I want to make system copy and getting error when trying to execute SMIGR_CREATE_DDL with following criteria

Target Database:

Oracle

Database Version : 10    // i put manualy while no value in F4 against oracle

Additional Parameters:

Unicode Migration  Yes

Installation Directory:  /tmp

Optional Parameter: NON

 

If i execute as a direct or background job with rdisp/max_wprun_time =0

 

DATASET_NOT_OPEN

CX_SY_FILE_OPEN_MODE

 

 

rdisp/max_wprun_time = 1800 with direct and background job

then got

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

Exception      CX_SY_FILE_OPEN_MODE

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.

 

Regards,

  • Re: SMIGR_CREATE_DDL for  System Copy
    Markus Doehr
    Currently Being Moderated

    > 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)

     

    > DATASET_NOT_OPEN

    > CX_SY_FILE_OPEN_MODE

     

    This also explains the reason why the dataset (the file) could not be opened.

     

     

     

    Markus

    • Re: SMIGR_CREATE_DDL for  System Copy
      M. Abdul Jamil
      Currently Being Moderated

      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

      Export Preparation

      Table Splitting Preparation

      Please confirm me that now i have to use above option or leave?

       

      Regard,

      • Re: SMIGR_CREATE_DDL for  System Copy
        Markus Doehr
        Currently Being Moderated

        They have to be put in the export directory:

         

        <EXPORT_DIR>/ABAP/DB/ORA

         

        before you start the import on the target system.

         

        They are not relevant for the export.

         

         

         

        Markus

        • Re: SMIGR_CREATE_DDL for  System Copy
          M. Abdul Jamil
          Currently Being Moderated

          Dear Markus,

          i got a error catproc.sql during Create Database phase so, i edit the Keydb.xml file and now installation is running. I vl catch you if i get any critical issue.

           

          Regards,

          majamil

          • Re: SMIGR_CREATE_DDL for  System Copy
            Markus Doehr
            Currently Being Moderated

            >  i got a error catproc.sql during Create Database phase so, i edit the Keydb.xml file and now installation is running. I vl catch you if i get any critical issue.

             

            So you are already at import state?

             

             

             

            Markus

            • Re: SMIGR_CREATE_DDL for  System Copy
              M. Abdul Jamil
              Currently Being Moderated

              Dear Markus,

              there is only one package interrupted during Import Abap phase,

              Logs

              sapinst.log

              +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.

               

              import_monitor.log

              +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+

               

               

              SAPAPPL1_29

              +(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+

               

              SAPAPPL1_29.TSK

              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

               

               

               

              Regards,

              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

  • Re: SMIGR_CREATE_DDL for  System Copy
    John Feely
    Currently Being Moderated

    Hello,

     

    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

     

    regards,

    John Feely

Actions