problem with export for system copy

[patrick_nabil]

hi

i am using  SWPM for a system copy but it came out with error on the export phase on the source server

aix on oracle

Unloading of 'APQD' export package is interrupted with R3load error.

Process '/usr/sap/FTP/DVEBMGS00/exe/R3load -e APQD.cmd -datacodepage 4103 -l APQD.log -stop_on_error' exited with return code 2.

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

any ides ?

[former_member182657 · Accepted solution]

Hi,

Could you share APQD.log file to suggest you for the issue.

Regards,

[patrick_nabil · Accepted solution]

hi Gaurav

pleas find log

/usr/sap/FPT/DVEBMGS00/exe/R3load: START OF LOG: 20160627074659

/usr/sap/FPT/DVEBMGS00/exe/R3load: sccsid @(#) $Id: //bas/721_REL/src/R3ld/R3load/R3ldmain.c#13 $ SAP

/usr/sap/FPT/DVEBMGS00/exe/R3load: version R7.20/V1.6 [UNICODE]

Compiled Apr 28 2015 21:32:09

/usr/sap/FPT/DVEBMGS00/exe/R3load -ctf E /mnt/sandbox2/ABAP/DATA/APQD.STR /mnt/sandbox2/ABAP/DB/DDLORA.TPL APQD.TSK ORA -l APQD.log

(PRC) INFO: working directory "/tmp/sapinst_instdir/NW700/LM/COPY/ORA/EXP/DISTRIBUTED/AS-ABAP/EXPDB"

/usr/sap/FPT/DVEBMGS00/exe/R3load: job completed

/usr/sap/FPT/DVEBMGS00/exe/R3load: END OF LOG: 20160627074659

/usr/sap/FPT/DVEBMGS00/exe/R3load: START OF LOG: 20160627074659

/usr/sap/FPT/DVEBMGS00/exe/R3load: sccsid @(#) $Id: //bas/721_REL/src/R3ld/R3load/R3ldmain.c#13 $ SAP

/usr/sap/FPT/DVEBMGS00/exe/R3load: version R7.20/V1.6 [UNICODE]

Compiled Apr 28 2015 21:32:09

/usr/sap/FPT/DVEBMGS00/exe/R3load -e APQD.cmd -datacodepage 4103 -l APQD.log -stop_on_error

(PRC) INFO: working directory "/tmp/sapinst_instdir/NW700/LM/COPY/ORA/EXP/DISTRIBUTED/AS-ABAP/EXPDB"

(DB) INFO: connected to DB

(DB) INFO: DbSlControl(DBSL_CMD_NLS_CHARACTERSET_GET): UTF16

(DB) INFO: Export without hintfile

(GSI) INFO: dbname   = "FPT20160625080648                                                                                                               "

(GSI) INFO: vname    = "ORACLE                          "

(GSI) INFO: hostname = "SANDBOX-TEST                                                    "

(GSI) INFO: sysname  = "AIX"

(GSI) INFO: nodename = "SANDBOX-TEST"

(GSI) INFO: release  = "1"

(GSI) INFO: version  = "7"

(GSI) INFO: machine  = "00035A0AD400"

(INO) INFO: can't use SAPLIKEY, trying SlicGetInstallationNo()

(GSI) INFO: instno   = "INITIAL   "

DbSl Trace: Error 1652 in stmt_fetch() from oci_execute_stmt(), orpc=0

DbSl Trace: ORA-01652 occurred at SQL stmt (parse error offset=5111808)

(EXP) ERROR: DbSlExeRead failed

  rc = 99, table "APQD"

  (SQL error 1652)

  error message returned by DbSl:

ORA-01652: unable to extend temp segment by 128 in tablespace PSAPTEMP

(DB) INFO: disconnected from DB

/usr/sap/FPT/DVEBMGS00/exe/R3load: job finished with 1 error(s)

/usr/sap/FPT/DVEBMGS00/exe/R3load: END OF LOG: 20160627075212

[Former Member · Accepted solution]

Hi,

Check the settings for the PSAPTEMP tablespace in accordance with Notes 107257 and 164925.

Increase the space for the PSAPTEMP temporary tablespace.

You can extend tablespace using below command

alter tablespace PSAPTEMP add tempfile 'path of the file name\temp01' size xx autoextend on;

Regards

Prithviraj

[patrick_nabil · Accepted solution]

thanks alot

[patrick_nabil · Accepted solution]

thanks

[former_member182657]

Hi,

You need to follow below options

1.Check the settings for the PSAPTEMP tablespace in accordance with Notes 107257 and 164925.

 2.Increase the space for the PSAPTEMP temporary tablespace.

After that try to re-execute the step.

Regards,

[patrick_nabil]

thanks alot