Skip to Content
author's profile photo Former Member
Former Member

Error in Import Abap phase

Hi Experts,

I am doing db2 import (hetero system copy) and got stuck at the Import Abap phase, with the following error:

CONFIG: 2008-07-24 01:21:23

List of packages with table structure: 'SAP0000'.

CONFIG: 2008-07-24 01:21:23

List of packages with views: 'SAPVIEW'.

TRACE: 2008-07-24 01:21:23 com.sap.inst.migmon.imp.ImportStandardTask preCreate

Parse of 'C:\Program Files\sapinst_instdir\SOLMAN\LM\COPY\DB6\SYSTEM\CENTRAL\AS\DDLDB6.TPL' template file is started.

INFO: 2008-07-24 01:21:23 com.sap.inst.migmon.imp.ImportStandardTask preCreate

Parse of 'C:\Program Files\sapinst_instdir\SOLMAN\LM\COPY\DB6\SYSTEM\CENTRAL\AS\DDLDB6.TPL' template file is successfully completed.

Primary key creation: after load.

Index creation: after load.

INFO: 2008-07-24 01:21:24

Data codepage 4103 is determined using TOC file 'E:\Source\DB_Export\ABAP\DATA\D010INC.TOC' for package 'D010INC'.

TRACE: 2008-07-24 01:21:24 com.sap.inst.migmon.LoadTask run

Loading of 'REPOSRC' import package is started.

TRACE: 2008-07-24 01:21:24 com.sap.inst.migmon.LoadTask run

Loading of 'SASACONT1' import package is started.

TRACE: 2008-07-24 01:21:24 com.sap.inst.migmon.LoadTask run

Loading of 'SAPAPPL0_2' import package is started.

TRACE: 2008-07-24 01:21:24 com.sap.inst.migmon.LoadTask processPackage

Task file generation for 'SASACONT1' import package:

E:\usr\sap\SLM\SYS\exe\uc\NTAMD64\R3load.exe -ctf I E:\Source\DB_Export\ABAP\DATA\SASACONT1.STR "C:\Program Files\sapinst_instdir\SOLMAN\LM\COPY\DB6\SYSTEM\CENTRAL\AS\DDLDB6.TPL" SASACONT1.TSK DB6 -l SASACONT1.log

TRACE: 2008-07-24 01:21:24 com.sap.inst.migmon.LoadTask processPackage

Task file generation for 'REPOSRC' import package:

E:\usr\sap\SLM\SYS\exe\uc\NTAMD64\R3load.exe -ctf I E:\Source\DB_Export\ABAP\DATA\REPOSRC.STR "C:\Program Files\sapinst_instdir\SOLMAN\LM\COPY\DB6\SYSTEM\CENTRAL\AS\DDLDB6.TPL" REPOSRC.TSK DB6 -l REPOSRC.log

TRACE: 2008-07-24 01:21:24 com.sap.inst.migmon.LoadTask processPackage

Task file generation for 'SAPAPPL0_2' import package:

E:\usr\sap\SLM\SYS\exe\uc\NTAMD64\R3load.exe -ctf I E:\Source\DB_Export\ABAP\DATA\SAPAPPL0_2.STR "C:\Program Files\sapinst_instdir\SOLMAN\LM\COPY\DB6\SYSTEM\CENTRAL\AS\DDLDB6.TPL" SAPAPPL0_2.TSK DB6 -l SAPAPPL0_2.log

TRACE: 2008-07-24 01:21:24 com.sap.inst.migmon.LoadTask processPackage

Loading of 'SASACONT1' import package into database:

E:\usr\sap\SLM\SYS\exe\uc\NTAMD64\R3load.exe -i SASACONT1.cmd -dbcodepage 4103 -l SASACONT1.log -stop_on_error -loadprocedure fast LOAD:COMPRESS_ALL:DEF_CRT

TRACE: 2008-07-24 01:21:24 com.sap.inst.migmon.LoadTask processPackage

Loading of 'REPOSRC' import package into database:

E:\usr\sap\SLM\SYS\exe\uc\NTAMD64\R3load.exe -i REPOSRC.cmd -dbcodepage 4103 -l REPOSRC.log -stop_on_error -loadprocedure fast LOAD:COMPRESS_ALL:DEF_CRT

TRACE: 2008-07-24 01:21:24 com.sap.inst.migmon.LoadTask processPackage

Loading of 'SAPAPPL0_2' import package into database:

E:\usr\sap\SLM\SYS\exe\uc\NTAMD64\R3load.exe -i SAPAPPL0_2.cmd -dbcodepage 4103 -l SAPAPPL0_2.log -stop_on_error -loadprocedure fast LOAD:COMPRESS_ALL:DEF_CRT

ERROR: 2008-07-24 01:21:24 com.sap.inst.migmon.LoadTask run

Loading of 'SASACONT1' import package is interrupted with R3load error.

Process 'E:\usr\sap\SLM\SYS\exe\uc\NTAMD64\R3load.exe -i SASACONT1.cmd -dbcodepage 4103 -l SASACONT1.log -stop_on_error -loadprocedure fast LOAD:COMPRESS_ALL:DEF_CRT' exited with return code 2.

For mode details see 'SASACONT1.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

ERROR: 2008-07-24 01:21:24 com.sap.inst.migmon.LoadTask run

Loading of 'SAPAPPL0_2' import package is interrupted with R3load error.

Process 'E:\usr\sap\SLM\SYS\exe\uc\NTAMD64\R3load.exe -i SAPAPPL0_2.cmd -dbcodepage 4103 -l SAPAPPL0_2.log -stop_on_error -loadprocedure fast LOAD:COMPRESS_ALL:DEF_CRT' exited with return code 2.

For mode details see 'SAPAPPL0_2.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

ETC...

I tried to using the latest R3load file and tried other ways, but still the same error.

Please advise me to resolve the problem after 2 days being suffered with it.

Your response is greatly appreciated.

Kind Regards,

Rudi

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jul 23, 2008 at 10:49 AM

    Hi Tomas,

    Thanks for your response, i paste the error log for SAPAPPL0_1.log:

    E:\usr\sap\SLM\SYS\exe\uc\NTAMD64\R3load.exe: START OF LOG: 20080724012453

    E:\usr\sap\SLM\SYS\exe\uc\NTAMD64\R3load.exe: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#18 $ SAP

    E:\usr\sap\SLM\SYS\exe\uc\NTAMD64\R3load.exe: version R7.00/V1.4 [UNICODE]

    Compiled Jun 30 2008 00:30:08

    E:\usr\sap\SLM\SYS\exe\uc\NTAMD64\R3load.exe -ctf I E:\Source\DB_Export\ABAP\DATA\SAPAPPL0_1.STR C:\Program Files\sapinst_instdir\SOLMAN\LM\COPY\DB6\SYSTEM\CENTRAL\AS\DDLDB6.TPL SAPAPPL0_1.TSK DB6 -l SAPAPPL0_1.log

    (RTF) WARNING: CREATE PSEUDO TABLE template not found in control file "C:\Program Files\sapinst_instdir\SOLMAN\LM\COPY\DB6\SYSTEM\CENTRAL\AS\DDLDB6.TPL"

    E:\usr\sap\SLM\SYS\exe\uc\NTAMD64\R3load.exe: job completed

    E:\usr\sap\SLM\SYS\exe\uc\NTAMD64\R3load.exe: END OF LOG: 20080724012454

    E:\usr\sap\SLM\SYS\exe\uc\NTAMD64\R3load.exe: START OF LOG: 20080724012454

    E:\usr\sap\SLM\SYS\exe\uc\NTAMD64\R3load.exe: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#18 $ SAP

    E:\usr\sap\SLM\SYS\exe\uc\NTAMD64\R3load.exe: version R7.00/V1.4 [UNICODE]

    Compiled Jun 30 2008 00:30:08

    E:\usr\sap\SLM\SYS\exe\uc\NTAMD64\R3load.exe -i SAPAPPL0_1.cmd -dbcodepage 4103 -l SAPAPPL0_1.log -stop_on_error -loadprocedure fast LOAD:COMPRESS_ALL:DEF_CRT

    (DB) INFO: connected to DB

    (DB6) INFO: COMPRESS YES is set during table creation.

    (DB6) DB2 9.5 automatic dictionary creation does not require an explicit REORG.

    (DB6) Compression threshold is ignored.

    (GSI) INFO: dbname = "SLM "

    (GSI) INFO: vname = "DB6 "

    (GSI) INFO: hostname = "UNKNOWN "

    (GSI) INFO: sysname = "Windows NT"

    (GSI) INFO: nodename = "PORTAL01"

    (GSI) INFO: release = "5.2"

    (GSI) INFO: version = "3790 Service Pack 2"

    (GSI) INFO: machine = "4x AMD64 Level 6 (Mod 23 Step 8)"

    (RTF) WARNING: CREATE PSEUDO TABLE template not found in control file "C:\Program Files\sapinst_instdir\SOLMAN\LM\COPY\DB6\SYSTEM\CENTRAL\AS\DDLDB6.TPL"

    (DDL) ERROR: CREATE PSEUDO TABLE template has not been initialized(DB) INFO: disconnected from DB

    E:\usr\sap\SLM\SYS\exe\uc\NTAMD64\R3load.exe: job finished with 1 error(s)

    E:\usr\sap\SLM\SYS\exe\uc\NTAMD64\R3load.exe: END OF LOG: 20080724012500

    Another log files have the same error content.

    Please advise.

    Thanks in advance,

    Rudi

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi,

      if you did not do the database export with a current version of R3szchk, you can not use the new "deferred table creation" option in the new SAPINST versions.

      DDLDB6.TPL needs to include the following lines.

      cretab: CREATE TABLE &tab_name&

      ( /{ &fld_name& &fld_desc& /-, /} )

      IN &location&

      INDEX IN &locationI&

      LONG IN &locationL&

      lazytb: CREATE VIEW &tab_name& AS SELECT * FROM

      ( VALUES( /{ &fld_cast& /-, /} )) AS &tab_name&

      ( /{ &fld_name& /-, /} )

      WHERE 1 = 2

      Older R3szchk versions do not write the second block into DDLDB6.TPL .

      Regards

      Frank

  • author's profile photo Former Member
    Former Member
    Posted on Jul 23, 2008 at 10:43 AM

    Hi,

    you have to have a look at the R3load logs. Those logs always have tha name of the package you try to import (in your examples: SAPAPPL0_2.log, SASACONT1.log)

    I would suggest that the r4eason can be found there...

    kind regards

    Thomas

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 24, 2008 at 02:29 AM

    Hi Frank,

    Your brilliant advice has made the process moving on, the abap import is still running now and there is no failed so far. Full point for you...

    Many Thanks and Kind Regards,

    Rudi

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.