UPGRADE ERROR

[Former Member]

Hi Gurus ,

I try to restore the system copy from 32 bit platform to 64 bit platform of R/3 4.7 . But during restore the target system , Iam getting the following error .

E:\usr\sap\DEV\SYS\exe\run/R3load.exe: START OF LOG: 20090123182053

E:\usr\sap\DEV\SYS\exe\run/R3load.exe: sccsid @(#) $Id: //bas/640_REL/src/R3ld/R3load/R3ldmain.c#12 $ SAP

E:\usr\sap\DEV\SYS\exe\run/R3load.exe: version R6.40/V1.4 [UNICODE]

Compiled Dec 15 2005 22:22:21

E:\usr\sap\DEV\SYS\exe\run/R3load.exe -ctf I E:\NEWOLDDEV/DATA/SAP0000.STR C:\Program Files\sapinst_instdir\R3E47X2\COPY\IMPORT\SYSTEM\ABAP\ORA\UC\DB/DDLORA.TPL C:\Program Files\sapinst_instdir\R3E47X2\COPY\IMPORT\SYSTEM\ABAP\ORA\UC\DB/SAP0000.TSK ORA -l C:\Program Files\sapinst_instdir\R3E47X2\COPY\IMPORT\SYSTEM\ABAP\ORA\UC\DB/SAP0000.log -o D

E:\usr\sap\DEV\SYS\exe\run/R3load.exe: job completed

E:\usr\sap\DEV\SYS\exe\run/R3load.exe: END OF LOG: 20090123182053

E:\usr\sap\DEV\SYS\exe\run/R3load.exe: START OF LOG: 20090123190923

E:\usr\sap\DEV\SYS\exe\run/R3load.exe: sccsid @(#) $Id: //bas/640_REL/src/R3ld/R3load/R3ldmain.c#12 $ SAP

E:\usr\sap\DEV\SYS\exe\run/R3load.exe: version R6.40/V1.4 [UNICODE]

Compiled Dec 15 2005 22:22:21

E:\usr\sap\DEV\SYS\exe\run/R3load.exe -dbcodepage 4103 -i C:\Program Files\sapinst_instdir\R3E47X2\COPY\IMPORT\SYSTEM\ABAP\ORA\UC\DB/SAP0000.cmd -l C:\Program Files\sapinst_instdir\R3E47X2\COPY\IMPORT\SYSTEM\ABAP\ORA\UC\DB/SAP0000.log -stop_on_error

DbSl Trace: OCI-call 'OCIServerAttach' failed: rc = 12518

DbSl Trace: CONNECT failed with sql error '12518'

DbSl Trace: OCI-call 'OCIServerAttach' failed: rc = 12518

DbSl Trace: CONNECT failed with sql error '12518'

(DB) ERROR: db_connect rc = 256

DbSl Trace: OCI-call 'OCIServerAttach' failed: rc = 12518

DbSl Trace: CONNECT failed with sql error '12518'

DbSl Trace: OCI-call 'OCIServerAttach' failed: rc = 12518

DbSl Trace: CONNECT failed with sql error '12518'

(DB) ERROR: DbSlErrorMsg rc = 99

E:\usr\sap\DEV\SYS\exe\run/R3load.exe: job finished with 1 error(s)

E:\usr\sap\DEV\SYS\exe\run/R3load.exe: END OF LOG: 20090123190923

E:\usr\sap\DEV\SYS\exe\run/R3load.exe: START OF LOG: 20090124165914

E:\usr\sap\DEV\SYS\exe\run/R3load.exe: sccsid @(#) $Id: //bas/640_REL/src/R3ld/R3load/R3ldmain.c#12 $ SAP

E:\usr\sap\DEV\SYS\exe\run/R3load.exe: version R6.40/V1.4 [UNICODE]

Compiled Dec 15 2005 22:22:21

E:\usr\sap\DEV\SYS\exe\run/R3load.exe -dbcodepage 4103 -i C:\Program Files\sapinst_instdir\R3E47X2\COPY\IMPORT\SYSTEM\ABAP\ORA\UC\DB/SAP0000.cmd -l C:\Program Files\sapinst_instdir\R3E47X2\COPY\IMPORT\SYSTEM\ABAP\ORA\UC\DB/SAP0000.log -stop_on_error

DbSl Trace: ORA-1403 when accessing table SAPUSER

(DB) INFO: connected to DB

(DB) INFO: DbSlControl(DBSL_CMD_NLS_CHARACTERSET_GET): UTF8

DbSl Trace: Error in exec_immediate()

DbSl Trace: ORA-959 occurred when executing SQL statement (parse error offset=615)

(DB) ERROR: DDL statement failed

(CREATE TABLE "REPOLOAD" ( "PROGNAME" VARCHAR2(120) DEFAULT ' ' NOT NULL , "R3STATE" VARCHAR2(3) DEFAULT ' ' NOT NULL , "MACH" NUMBER(5) DEFAULT 0 NOT NULL , "UNAM" VARCHAR2(36) DEFAULT ' ' NOT NULL , "UDAT" VARCHAR2(24) DEFAULT '00000000' NOT NULL , "UTIME" VARCHAR2(18) DEFAULT '000000' NOT NULL , "L_DATALG" NUMBER(10) DEFAULT 0 NOT NULL , "Q_DATALG" NUMBER(10) DEFAULT 0 NOT NULL , "SDAT" VARCHAR2(24) DEFAULT '00000000' NOT NULL , "STIME" VARCHAR2(18) DEFAULT '000000' NOT NULL , "MINOR_VERS" NUMBER(5) DEFAULT 0 NOT NULL , "MAJOR_VERS" NUMBER(10) DEFAULT 0 NOT NULL , "LDATA" BLOB , "QDATA" BLOB ) TABLESPACE PSAPDEV620 STORAGE (INITIAL 0000000016K NEXT 0000040960K MINEXTENTS 0000000001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) )

DbSlExecute: rc = 99

(SQL error 959)

error message returned by DbSl:

ORA-00959: tablespace 'PSAPDEV620' does not exist

(DB) INFO: disconnected from DB

E:\usr\sap\DEV\SYS\exe\run/R3load.exe: job finished with 1 error(s)

E:\usr\sap\DEV\SYS\exe\run/R3load.exe: END OF LOG: 20090124165914

So kindly advice me to resolv the problem .

Regards

Selvan

[Former Member · Accepted solution]

Hi Markus

Can you tell me please what are the other new methods instead of r3load . Then kindly advice me why it shows tablespace does not exist ?

Regards

SElvan

[markus_doehr2 · Accepted solution]

Can you tell me please what are the other new methods instead of r3load .

Check

http://service.sap.com/systemcopy

you can use e. g. backup/restore to copy systems.

Then kindly advice me why it shows tablespace does not exist ?

I don´t know. I would need more logfiles and DBSIZE.XML of the export.

Markus

[Former Member]

Hi Markus ,

I already took the backup of the existing server using brtools 7.00 , Now can you tell me pls how can i restore the data to the new server .In which profile i have to change for restore the data .

Kindly advice me

Regards

Selvan

[markus_doehr2]

Read the guide mentioned - it will tell you what you need to do.

Markus

[Former Member]

Hi Markus ,

Sorry i cant get you clearly . Pls tell me briefly .

Regards

Selvan

[markus_doehr2]

Your tools (R3load) are VERY old. If you do system copies using R3load always first update the tools (on source and target system) before export and importing.

However, that was just additional info, you main problem is that the tablespace required does not exist.

Markus

[markus_doehr2]

> E:\usr\sap\DEV\SYS\exe\run/R3load.exe: version R6.40/V1.4 [UNICODE]

> Compiled Dec 15 2005 22:22:21

Just to add: Your tools a ancient.

Always use the latest copy tools (R3load, R3szchk, R3ldctl).

Markus

[Former Member]

Hi,

If you haven't already, as error log indicates make sure you have tablespace "PSAPDEV620" exist in the target system.

Hope this helps,

Kalyan.