cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

system copy error

Former Member

on ‎06-16-2010 9:48 AM

0 Kudos

Hi,

I am doing Hetrogenious system copy between windows IA64 ECC5 Abap stack with oracle 9.2.0.6 to windows 32 bit ECC5 ABAP with oracle 9.2.0.6 .

I have followed the below process

1. using R2load method ,

2. Source system = SID = PRD

a. no update is pending in sm13. VBDATA table

b. no schedule job is there

c. no operator mode

d.no temp table in QCM table

e. TATGPC and TATGPCA tables are empty

f.tried to generate ddl statement But I think no non standard database object is there , that's why ddl statemenet is not created.

g.shut down the sap instance , database is online ,

successfuly exported the productin system to a folder nameed "prdexport"

Target system procedure

1.Fresh windows 2k3 32 bit on x86 system

2.installed oracle with patch 9.2.0.6 , same patch level with production system

3. SID = D22 ,

4. intalled central instance

5. installed database instance with r3load method , copied prdexport folder to target pc.

6. now system is giving error

"F:\usr\sap\D22\SYS\exe\run/R3load.exe: START OF LOG: 20100615072312

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

F:\usr\sap\D22\SYS\exe\run/R3load.exe: version R6.40/V1.4

F:\usr\sap\D22\SYS\exe\run/R3load.exe -ctf I F:\PRDexport/DATA/SAP0000.STR C:\Program Files\sapinst_instdir\ECC04SR1\WEBAS_ABAP_ORA_NUC\DB/DDLORA.TPL C:\Program Files\sapinst_instdir\ECC04SR1\WEBAS_ABAP_ORA_NUC\DB/SAP0000.TSK ORA -l C:\Program Files\sapinst_instdir\ECC04SR1\WEBAS_ABAP_ORA_NUC\DB/SAP0000.log -o D

F:\usr\sap\D22\SYS\exe\run/R3load.exe: job completed

F:\usr\sap\D22\SYS\exe\run/R3load.exe: END OF LOG: 20100615072312

F:\usr\sap\D22\SYS\exe\run/R3load.exe: START OF LOG: 20100615093131

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

F:\usr\sap\D22\SYS\exe\run/R3load.exe: version R6.40/V1.4

F:\usr\sap\D22\SYS\exe\run/R3load.exe -dbcodepage 1100 -i C:\Program Files\sapinst_instdir\ECC04SR1\WEBAS_ABAP_ORA_NUC\DB/SAP0000.cmd -l C:\Program Files\sapinst_instdir\ECC04SR1\WEBAS_ABAP_ORA_NUC\DB/SAP0000.log -stop_on_error -k 1wqFDem50Dp01eqtdAYt0aew

DbSl Trace: ORA-1403 when accessing table SAPUSER

(DB) INFO: connected to DB

(DB) INFO: DbSlControl(DBSL_CMD_NLS_CHARACTERSET_GET): WE8DEC

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

(DB) ERROR: DDL statement failed

(CREATE TABLE "REPOLOAD" ( "PROGNAME" VARCHAR2(40) DEFAULT ' ' NOT NULL , "R3STATE" VARCHAR2(1) DEFAULT ' ' NOT NULL , "MACH" NUMBER(5) DEFAULT 0 NOT NULL , "UNAM" VARCHAR2(12) DEFAULT ' ' NOT NULL , "UDAT" VARCHAR2(8) DEFAULT '00000000' NOT NULL , "UTIME" VARCHAR2(6) DEFAULT '000000' NOT NULL , "L_DATALG" NUMBER(10) DEFAULT 0 NOT NULL , "Q_DATALG" NUMBER(10) DEFAULT 0 NOT NULL , "SDAT" VARCHAR2(8) DEFAULT '00000000' NOT NULL , "STIME" VARCHAR2(6) 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 PSAPPRD640 LOB ("LDATA", "QDATA") STORE AS (CACHE) 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 'PSAPPRD640' does not exist

(DB) INFO: disconnected from DB

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

F:\usr\sap\D22\SYS\exe\run/R3load.exe: END OF LOG: 20100615093132

F:\usr\sap\D22\SYS\exe\run/R3load.exe: START OF LOG: 20100615213822

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

F:\usr\sap\D22\SYS\exe\run/R3load.exe: version R6.40/V1.4

F:\usr\sap\D22\SYS\exe\run/R3load.exe -dbcodepage 1100 -i C:\Program Files\sapinst_instdir\ECC04SR1\WEBAS_ABAP_ORA_NUC\DB/SAP0000.cmd -l C:\Program Files\sapinst_instdir\ECC04SR1\WEBAS_ABAP_ORA_NUC\DB/SAP0000.log -stop_on_error -k 1wqFDem50Dp01eqtdAYt0aew

DbSl Trace: ORA-1403 when accessing table SAPUSER

(DB) INFO: connected to DB

(DB) INFO: DbSlControl(DBSL_CMD_NLS_CHARACTERSET_GET): WE8DEC

(DB) ERROR: DDL statement failed

(DROP TABLE "REPOLOAD")

DbSlExecute: rc = 103

(SQL error 942)

error message returned by DbSl:

ORA-00942: table or view does not exist

(IMP) INFO: a failed DROP attempt is not necessarily a problem

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

(DB) ERROR: DDL statement failed

(CREATE TABLE "REPOLOAD" ( "PROGNAME" VARCHAR2(40) DEFAULT ' ' NOT NULL , "R3STATE" VARCHAR2(1) DEFAULT ' ' NOT NULL , "MACH" NUMBER(5) DEFAULT 0 NOT NULL , "UNAM" VARCHAR2(12) DEFAULT ' ' NOT NULL , "UDAT" VARCHAR2(8) DEFAULT '00000000' NOT NULL , "UTIME" VARCHAR2(6) DEFAULT '000000' NOT NULL , "L_DATALG" NUMBER(10) DEFAULT 0 NOT NULL , "Q_DATALG" NUMBER(10) DEFAULT 0 NOT NULL , "SDAT" VARCHAR2(8) DEFAULT '00000000' NOT NULL , "STIME" VARCHAR2(6) 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 PSAPPRD640 LOB ("LDATA", "QDATA") STORE AS (CACHE) 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 'PSAPPRD640' does not exist

(DB) INFO: disconnected from DB

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

F:\usr\sap\D22\SYS\exe\run/R3load.exe: END OF LOG: 20100615213823

F:\usr\sap\D22\SYS\exe\run/R3load.exe: START OF LOG: 20100616005026

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

F:\usr\sap\D22\SYS\exe\run/R3load.exe: version R6.40/V1.4

F:\usr\sap\D22\SYS\exe\run/R3load.exe -dbcodepage 1100 -i C:\Program Files\sapinst_instdir\ECC04SR1\WEBAS_ABAP_ORA_NUC\DB/SAP0000.cmd -l C:\Program Files\sapinst_instdir\ECC04SR1\WEBAS_ABAP_ORA_NUC\DB/SAP0000.log -stop_on_error -k 1wqFDem50Dp01eqtdAYt0aew

DbSl Trace: ORA-1403 when accessing table SAPUSER

(DB) INFO: connected to DB

(DB) INFO: DbSlControl(DBSL_CMD_NLS_CHARACTERSET_GET): WE8DEC

(DB) ERROR: DDL statement failed

(DROP TABLE "REPOLOAD")

DbSlExecute: rc = 103

(SQL error 942)

error message returned by DbSl:

ORA-00942: table or view does not exist

(IMP) INFO: a failed DROP attempt is not necessarily a problem

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

(DB) ERROR: DDL statement failed

(CREATE TABLE "REPOLOAD" ( "PROGNAME" VARCHAR2(40) DEFAULT ' ' NOT NULL , "R3STATE" VARCHAR2(1) DEFAULT ' ' NOT NULL , "MACH" NUMBER(5) DEFAULT 0 NOT NULL , "UNAM" VARCHAR2(12) DEFAULT ' ' NOT NULL , "UDAT" VARCHAR2(8) DEFAULT '00000000' NOT NULL , "UTIME" VARCHAR2(6) DEFAULT '000000' NOT NULL , "L_DATALG" NUMBER(10) DEFAULT 0 NOT NULL , "Q_DATALG" NUMBER(10) DEFAULT 0 NOT NULL , "SDAT" VARCHAR2(8) DEFAULT '00000000' NOT NULL , "STIME" VARCHAR2(6) 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 PSAPPRD640 LOB ("LDATA", "QDATA") STORE AS (CACHE) 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 'PSAPPRD640' does not exist

(DB) INFO: disconnected from DB

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

F:\usr\sap\D22\SYS\exe\run/R3load.exe: END OF LOG: 20100616005027

pl. advise .

Show replies
Show replies
Answer

Accepted Solutions (0)

Answers (1)

Answers (1)

JPReyes
Active Contributor
‎06-16-2010 9:57 AM
0 Kudos

I had a similar problem once.... the issue was that for some reason the name of the tablespace on the target system was not copied exactly as the source.

Ex. PSAPPRD64 instead of PSAPPRD640

So the data load would not find the tablespace to import the data

What I did at that time was to use brtools to rename the tablespace and resume SAPINST

Hope that helps

Juan

Show replies
Show replies
Former Member
‎06-16-2010 1:19 PM
0 Kudos

Hi,

thanks for your reply , when I am trying to rename the tablespace , it is giving error

BRSPACE options for create tablespace

1 - BRSPACE profile (profile) ...... [initD22.sap]

2 - Database user/password (user) .. [/]

3 ~ Tablespace name (tablespace) ... [PSAPPRD640]

4 - Confirmation mode (confirm) .... [yes]

5 - Scrolling line count (scroll) .. [20]

6 - Message language (language) .... [E]

7 - BRSPACE command line (command) . [-p initD22.sap -s 20 -l E -f tscreate -t

PSAPPRD640]

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

-

BR0662I Enter your choice:

c

BR0280I BRTOOLS time stamp: 2010-06-16 02.28.35

BR0663I Your choice: 'c'

BR0259I Program execution will be continued...

BR0291I BRSPACE will be started with options '-p initD22.sap -s 20 -l E -f tscre

ate -t PSAPPRD640'

BR0280I BRTOOLS time stamp: 2010-06-16 02.28.35

BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:

BR0280I BRTOOLS time stamp: 2010-06-16 02.28.37

BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:

c

BR0280I BRTOOLS time stamp: 2010-06-16 02.28.38

BR0257I Your reply: 'c'

BR0259I Program execution will be continued...

###############################################################################

BR1001I BRSPACE 6.40 (15)

BR1002I Start of BRSPACE processing: sedlrecc.tsc 2010-06-16 02.28.38

BR0602E No valid SAP license found - please contact SAP

BR0700E Fatal errors occured - terminating processing...

BR1008I End of BRSPACE processing: sedlrecc.tsc 2010-06-16 02.28.47

BR0280I BRSPACE time stamp: 2010-06-16 02.28.47

BR1007I BRSPACE terminated with errors

###############################################################################

BR0292I Execution of BRSPACE finished with return code 3

BR0668I Warnings or errors occured - you can continue to ignore them or go back

to repeat the last action

BR0280I BRTOOLS time stamp: 2010-06-16 02.28.47>

Pl. help me how to rename the table space in this scenario.

> >

> Ex. PSAPPRD64 instead of PSAPPRD640

>

TomCenens
Active Contributor
‎06-16-2010 1:36 PM
0 Kudos

Dear

You will need to install a valid SAP license first:

hence the error line BR0602E No valid SAP license found - please contact SAP

Request the SAP license for your target SID + Hardware key through SAP Service Marketplace

Get hardware key in command prompt:

saplicense -get

Install license key using command prompt:

saplicense -install

Fill in requested parameter values after performing command "saplicense -install"

Kind regards

Tom

JPReyes
Active Contributor
‎06-16-2010 1:36 PM
0 Kudos

First you need to check if this is your scenario...

If most of the data is been imported you should be able to install the license to run brtools.

Then check the tablespaces to see if theres a problem

Then you can use the brconnect to rename the tablespace.

Regards

Juan

Former Member
‎06-16-2010 5:56 PM
0 Kudos

Hi,

i have checked with brtools

and sqlplus /nologon

PSAPPRD640 table space is not avaiable there.

select tablespace_name from dba_tablespaces; its output is

TABLESPACE_NAME

-

SYSTEM

PSAPUNDO

PSAPTEMP

PSAPPRD

PSAPPRDUSR

how to create the table space , when i am trying to to create through brtools , it is giving erro r

BR0657I Input menu 82 - please check/enter input values

-

BRSPACE options for create tablespace

1 - BRSPACE profile (profile) ...... [initD22.sap]

2 - Database user/password (user) .. [/]

3 ~ Tablespace name (tablespace) ... [PSAPPRD640]

4 - Confirmation mode (confirm) .... [yes]

5 - Scrolling line count (scroll) .. [20]

6 - Message language (language) .... [E]

7 - BRSPACE command line (command) . [-p initD22.sap -s 20 -l E -f tscreate -t

PSAPPRD640]

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

-

BR0662I Enter your choice:

c

BR0280I BRTOOLS time stamp: 2010-06-16 09.38.39

BR0663I Your choice: 'c'

BR0259I Program execution will be continued...

BR0291I BRSPACE will be started with options '-p initD22.sap -s 20 -l E -f tscr

ate -t PSAPPRD640'

BR0280I BRTOOLS time stamp: 2010-06-16 09.38.39

BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:

c

BR0280I BRTOOLS time stamp: 2010-06-16 09.38.57

BR0257I Your reply: 'c'

BR0259I Program execution will be continued...

###############################################################################

BR1001I BRSPACE 6.40 (15)

BR1002I Start of BRSPACE processing: sedlsqhd.tsc 2010-06-16 09.38.57

BR0602E No valid SAP license found - please contact SAP

BR0700E Fatal errors occured - terminating processing...

BR1008I End of BRSPACE processing: sedlsqhd.tsc 2010-06-16 09.39.05

BR0280I BRSPACE time stamp: 2010-06-16 09.39.05

BR1007I BRSPACE terminated with errors

###############################################################################

BR0292I Execution of BRSPACE finished with return code 3

BR0668I Warnings or errors occured - you can continue to ignore them or go back

to repeat the last action

BR0280I BRTOOLS time stamp: 2010-06-16 09.39.06

BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:

c

BR0280I BRTOOLS time stamp: 2010-06-16 09.39.16

BR0257I Your reply: 'c'

BR0259I Program execution will be continued...

pl. advice.

Edited by: sonal saxena on Jun 16, 2010 7:02 PM

Ask a Question